Consolidated Edison Financial Statements Trends

ED -- USA Stock  

USD 78.67  0.34  0.43%

This module enables investors to look at Consolidated Edison various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 1.3 B, Cost of Revenue of 7.1 B or Earning Before Interest and Taxes EBIT of 2.7 B, but also many exotic indicators such as Interest Coverage of 3.8247, Long Term Debt to Equity of 1.0265 or Calculated Tax Rate of 36.617. This module is a perfect complement to use when analyzing Consolidated Edison Valuation or Volatility. It can also complement various Consolidated Edison Technical models. Additionally see analysis of Consolidated Edison Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets45.6 B48.3 B39.5 B
Increasing
Slightly volatile
Cash and Equivalents866 M776 M567.4 M
Increasing
Slightly volatile
Investments1.5 B1.9 B813.5 M
Increasing
Slightly volatile
Investments Non Current1.5 B1.9 B813.5 M
Increasing
Slightly volatile
Deposit Liabilities371.6 M352 M312 M
Increasing
Slightly volatile
Inventory362.6 M339 M354.3 M
Decreasing
Very volatile
Tax Assets128.9 M79 M238.3 M
Decreasing
Slightly volatile
Trade and Non Trade Receivables1.8 B1.7 B1.8 B
Increasing
Slightly volatile
Trade and Non Trade Payables1.1 B1.1 B1.1 B
Increasing
Slightly volatile
Goodwill and Intangible Assets517.4 M552 M464.8 M
Increasing
Slightly volatile
Total Liabilities35 B33.9 B28 B
Increasing
Slightly volatile
Shareholders Equity14.4 B14.3 B11.8 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit6.4 B5.4 B5.5 B
Increasing
Slightly volatile
Current Assets3.8 B3.4 B3.4 B
Increasing
Slightly volatile
Assets Non Current45.6 B44.8 B36.4 B
Increasing
Slightly volatile
Current Liabilities4.7 B3.8 B3.6 B
Increasing
Slightly volatile
Liabilities Non Current30.5 B30.1 B24.4 B
Increasing
Slightly volatile
Tax Liabilities10.5 B10.3 B7.9 B
Increasing
Slightly volatile
Total Debt17.9 B15.8 B12.4 B
Increasing
Slightly volatile
Debt Current1.8 B1.1 B1.6 B
Decreasing
Stable
Debt Non Current14.1 B14.7 B11.5 B
Increasing
Slightly volatile
Shareholders Equity USD14.4 B14.3 B11.8 B
Increasing
Slightly volatile
Cash and Equivalents USD905.3 M776 M570.6 M
Increasing
Slightly volatile
Total Debt USD15.8 B15.8 B12.2 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues12.2 B12.1 B12.4 B
Increasing
Very volatile
Cost of Revenue7.1 B6.4 B7.5 B
Decreasing
Slightly volatile
Operating Expenses3.3 B3.2 B2.7 B
Increasing
Slightly volatile
Interest Expense710 M696 M621.5 M
Increasing
Slightly volatile
Income Tax Expense685.8 M698 M573.8 M
Increasing
Slightly volatile
Net Income from Discontinued Operations(322.4 M)(274 M)(254.2 M)
Decreasing
Slightly volatile
Consolidated Income1.3 B1.2 B1.1 B
Increasing
Slightly volatile
Net Income1.6 B1.2 B1.1 B
Increasing
Slightly volatile
Preferred Dividends Income Statement Impact3.5 M3 M6.4 M
Decreasing
Slightly volatile
Net Income Common Stock1.3 B1.2 B1.1 B
Increasing
Slightly volatile
Weighted Average Shares311.1 M300.4 M285.1 M
Increasing
Slightly volatile
Weighted Average Shares Diluted313.8 M301.9 M286.2 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT2.7 B2.6 B2.3 B
Increasing
Slightly volatile
Revenues USD13 B12.1 B12.4 B
Increasing
Stable
Net Income Common Stock USD1.3 B1.2 B1.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD2.7 B2.6 B2.3 B
Increasing
Slightly volatile
Gross Profit6.1 B5.7 B4.9 B
Increasing
Slightly volatile
Operating Income2.6 B2.5 B2.2 B
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(4.1 B)(4.8 B)(2.6 B)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(368.9 M)(402 M)(240.1 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing1 B1.3 B296.3 M
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 1.4 B1.4 B787.8 M
Increasing
Slightly volatile
Issuance Purchase of Equity Shares396.8 M753 M223.7 M
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (787.4 M)(763 M)(685.5 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(4.5 B)(5 B)(2.9 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations(1.1 B)3.5 B2.3 B
Increasing
Very volatile
Net Cash Flow or Change in Cash and Cash Equivalents40.5 M(172 M)58.2 M
Decreasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share4.32634.153.8139
Increasing
Slightly volatile
Earnings per Diluted Share5.074.123.8583
Increasing
Slightly volatile
Earnings per Basic Share USD4.32634.153.8139
Increasing
Slightly volatile
Dividends per Basic Common Share2.77892.682.6857
Decreasing
Very volatile
Return on Average Equity0.10470.0890.0971
Decreasing
Slightly volatile
Return on Average Assets0.0320.0260.0293
Decreasing
Slightly volatile
Return on Invested Capital0.05410.0460.0522
Decreasing
Slightly volatile
Gross Margin0.480.4740.3983
Increasing
Slightly volatile
Profit Margin0.1290.1030.0898
Increasing
Slightly volatile
EBITDA Margin0.31790.3190.2628
Increasing
Slightly volatile
Return on Sales0.21790.2190.1848
Increasing
Slightly volatile
Asset Turnover0.28210.2560.3423
Decreasing
Slightly volatile
Payout Ratio0.67630.6460.722
Decreasing
Stable
Enterprise Value over EBITDA9.78269.5978.6924
Increasing
Slightly volatile
Enterprise Value over EBIT14.210514.012.0175
Increasing
Slightly volatile
Price to Earnings Ratio15.5717.75415.1193
Increasing
Slightly volatile
Sales per Share43.706340.19643.9288
Decreasing
Slightly volatile
Price to Sales Ratio2.011.8331.3699
Increasing
Slightly volatile
Price to Book Value1.571.4441.4169
Increasing
Slightly volatile
Debt to Equity Ratio1142.37411.6792
Increasing
Slightly volatile
Dividend Yield0.040.0360.0488
Decreasing
Slightly volatile
Current Ratio0.630.8860.9511
Decreasing
Slightly volatile
Free Cash Flow per Share2.78(4.318)0.6107
Decreasing
Slightly volatile
Book Value per Share48.151646.98740.9282
Increasing
Slightly volatile
Tangible Assets Book Value per Share164157136
Increasing
Slightly volatile
Total Assets Per Share172171142
Increasing
Slightly volatile
Cash Flow Per Share12.342212.2669.2479
Increasing
Slightly volatile
Return on Investment9.7939.00699.6214
Decreasing
Slightly volatile
Operating Margin31.8520.463818.3579
Increasing
Slightly volatile
Calculated Tax Rate36.61735.923834.5676
Increasing
Slightly volatile
Receivables Turnover7.38186.95277.1714
Decreasing
Slightly volatile
Inventory Turnover25.93224.348325.6595
Decreasing
Very volatile
PPandE Turnover0.4010.35720.4942
Decreasing
Slightly volatile
Cash and Equivalents Turnover15.346413.97837.1004
Decreasing
Slightly volatile
Accounts Payable Turnover12.401411.175911.7336
Increasing
Stable
Accrued Expenses Turnover43.02739.48238.0632
Decreasing
Slightly volatile
Interest Coverage3.82473.55033.5231
Increasing
Slightly volatile
Long Term Debt to Equity1.02651.03060.9294
Increasing
Slightly volatile
Quick Ratio0.64070.65480.6643
Increasing
Very volatile
Net Current Assets as percentage of Total Assets(1.496)(0.9056)(0.5731)
Decreasing
Stable
Revenue to Assets0.27650.25020.3246
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax2 B1.9 B1.7 B
Increasing
Slightly volatile
Market Capitalization24.6 B22.5 B17 B
Increasing
Slightly volatile
Enterprise Value41.5 B37 B28.9 B
Increasing
Slightly volatile
Invested Capital63.3 B53.8 B47.1 B
Increasing
Slightly volatile
Average Equity14.1 B13.9 B11.5 B
Increasing
Slightly volatile
Average Assets48.4 B47.1 B38.6 B
Increasing
Slightly volatile
Invested Capital Average58.2 B57.2 B46.1 B
Increasing
Slightly volatile
Tangible Asset Value48.9 B47.7 B39.4 B
Increasing
Slightly volatile
Free Cash Flow(565.3 M)(1.3 B)25.5 M
Decreasing
Slightly volatile
Working Capital(884 M)(437 M)(202.9 M)
Decreasing
Slightly volatile
Revenue Per Employee869.9 K804.9 K857.4 K
Decreasing
Slightly volatile
Net Income Per Employee86.1 K83 K74.7 K
Increasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities
Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Upcoming Events

Consolidated Edison Upcoming Company Events
Upcoming Quarterly ReportMay 4, 2017
Next Earnings ReportAugust 3, 2017
Additionally see analysis of Consolidated Edison Correlation with competitors. Please also try Portfolio Center module to all portfolio management and optimization tools to improve performance of your portfolios.