Consolidated Edison Financial Statements Trends

Consolidated Edison Inc -- USA Stock  

USD 78.53  0.26  0.33%

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 B38.6 B
Increasing
Slightly volatile
Current Assets3.8 B3.4 B3.3 B
Increasing
Slightly volatile
Assets Non Current45.6 B44.8 B35.6 B
Increasing
Slightly volatile
Cash and Equivalents69 M776 M478.6 M
Increasing
Slightly volatile
Cash and Equivalents USD905.3 M776 M542.9 M
Increasing
Slightly volatile
Total Debt15.7 B15.8 B12 B
Increasing
Slightly volatile
Debt Current1.8 B1.1 B2.2 B
Decreasing
Slightly volatile
Debt Non Current14.1 B14.7 B11.4 B
Increasing
Slightly volatile
Total Debt USD15.8 B15.8 B12 B
Increasing
Slightly volatile
Deposit Liabilities371.6 M352 M307.1 M
Increasing
Slightly volatile
Shareholders Equity14.4 B14.3 B11.6 B
Increasing
Slightly volatile
Shareholders Equity USD14.4 B14.3 B11.6 B
Increasing
Slightly volatile
Goodwill and Intangible Assets517.4 M552 M460.6 M
Increasing
Slightly volatile
Inventory362.6 M339 M358.2 M
Decreasing
Very volatile
Investments1.5 B1.9 B780 M
Increasing
Slightly volatile
Investments Non Current1.5 B1.9 B780 M
Increasing
Slightly volatile
Total Liabilities35 B33.9 B27.3 B
Increasing
Slightly volatile
Current Liabilities4.7 B3.8 B3.6 B
Increasing
Slightly volatile
Liabilities Non Current30.5 B30.1 B23.7 B
Increasing
Slightly volatile
Trade and Non Trade Payables1.1 B1.1 B1.1 B
Increasing
Stable
Property Plant and Equipment Net35.5 B35.2 B26.8 B
Increasing
Slightly volatile
Trade and Non Trade Receivables1.8 B1.7 B1.7 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit6.4 B5.4 B5.5 B
Increasing
Slightly volatile
Tax Assets128.9 M79 M240.5 M
Decreasing
Slightly volatile
Tax Liabilities10.5 B10.3 B7.7 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income1.3 B1.2 B1.1 B
Increasing
Slightly volatile
Cost of Revenue7.1 B6.4 B7.7 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT2.7 B2.6 B2.3 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD2.7 B2.6 B2.3 B
Increasing
Slightly volatile
Gross Profit5.7 B5.7 B4.8 B
Increasing
Slightly volatile
Interest Expense710 M696 M613.5 M
Increasing
Slightly volatile
Net Income1.2 B1.2 B1.1 B
Increasing
Slightly volatile
Net Income Common Stock1.3 B1.2 B1.1 B
Increasing
Slightly volatile
Net Income Common Stock USD1.3 B1.2 B1.1 B
Increasing
Slightly volatile
Net Income from Discontinued Operations(322.4 M)(274 M)(235 M)
Decreasing
Slightly volatile
Operating Expenses3.3 B3.2 B2.7 B
Increasing
Slightly volatile
Operating Income2.6 B2.5 B2.2 B
Increasing
Slightly volatile
Preferred Dividends Income Statement Impact3.5 M3 M6.7 M
Decreasing
Slightly volatile
Revenues11.8 B12.1 B12.4 B
Increasing
Very volatile
Revenues USD13 B12.1 B12.5 B
Increasing
Stable
Weighted Average Shares310.1 M300.4 M283.5 M
Increasing
Slightly volatile
Weighted Average Shares Diluted313.8 M301.9 M284.6 M
Increasing
Slightly volatile
Income Tax Expense685.8 M698 M563.3 M
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
Depreciation Amortization and Accretion1.2 B1.2 B944 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents40.5 M(172 M)62.7 M
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(368.9 M)(402 M)(224.1 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares396.8 M753 M259.2 M
Increasing
Stable
Issuance Repayment of Debt Securities 1.4 B1.4 B769 M
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (787.4 M)(763 M)(677.6 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing1 B1.3 B322.5 M
Increasing
Slightly volatile
Net Cash Flow from Investing(4.5 B)(5 B)(2.8 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations3.4 B3.5 B2.6 B
Increasing
Slightly volatile
Cash Beginning of Year864.7 M944 M479.8 M
Increasing
Slightly volatile
Cash End of Year905.3 M772 M531.1 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.28210.2560.3526
Decreasing
Slightly volatile
Book Value per Share48.151646.98740.3523
Increasing
Slightly volatile
Current Ratio0.790.8860.9412
Decreasing
Very volatile
Debt to Equity Ratio1042.37410.128
Increasing
Slightly volatile
Share Dilution Ratio1.18211.00481.0171
Increasing
Slightly volatile
Dividend Yield0.040.0360.0487
Decreasing
Slightly volatile
Dividends per Basic Common Share2.77892.682.6576
Increasing
Very volatile
EBITDA Margin0.31790.3190.2575
Increasing
Slightly volatile
Earnings per Basic Share4.32634.153.7889
Increasing
Slightly volatile
Earnings per Diluted Share3.984.123.7446
Increasing
Slightly volatile
EPS Diluted Growth0.10780.09160.0777
Decreasing
Stable
EPS Growth0.10720.09120.0775
Decreasing
Stable
Earnings per Basic Share USD4.32634.153.7889
Increasing
Slightly volatile
Enterprise Value over EBIT14.210514.011.9393
Increasing
Slightly volatile
Enterprise Value over EBITDA9.78269.5978.6954
Increasing
Slightly volatile
Free Cash Flow per Share0.22(4.318)0.2692
Decreasing
Slightly volatile
Gross Margin0.480.4740.39
Increasing
Slightly volatile
Financial Leverage0.8630.73360.7356
Increasing
Slightly volatile
Leverage Ratio4.08573.47283.3827
Increasing
Slightly volatile
NCFO Growth0.18530.15750.247
Decreasing
Very volatile
Net Income Growth0.10880.09250.0555
Increasing
Very volatile
Profit Margin0.10410.1030.0865
Increasing
Slightly volatile
Payout Ratio0.67630.6460.7176
Decreasing
Stable
Price to Book Value1.631.571.4249
Increasing
Slightly volatile
Price to Earnings Ratio19.9317.75415.3684
Increasing
Slightly volatile
Price to Sales Ratio2.091.8331.347
Increasing
Slightly volatile
Revenue Growth(0.0332)(0.0283)0.0085
Decreasing
Slightly volatile
Return on Average Assets0.03290.0260.0298
Decreasing
Slightly volatile
Return on Average Equity0.08340.0890.0961
Decreasing
Slightly volatile
Return on Invested Capital0.05410.0460.0526
Decreasing
Slightly volatile
Return on Sales0.21790.2190.1817
Increasing
Slightly volatile
Weighted Average Share Growth4.0E-43.0E-40.0157
Decreasing
Slightly volatile
Sales per Share43.706340.19644.3395
Decreasing
Slightly volatile
Tax Efficiency0.78060.66350.6664
Increasing
Slightly volatile
Tangible Assets Book Value per Share164157134
Increasing
Slightly volatile
Total Assets Per Share172171139
Increasing
Slightly volatile
Cash Flow Per Share12.342212.2668.9762
Increasing
Slightly volatile
Return on Investment9.7939.00699.7014
Decreasing
Slightly volatile
Operating Margin21.5920.463817.2394
Increasing
Slightly volatile
Calculated Tax Rate36.61735.923834.3497
Increasing
Slightly volatile
Receivables Turnover7.38186.95277.2942
Decreasing
Slightly volatile
Inventory Turnover25.93224.348325.5629
Increasing
Very volatile
PPandE Turnover0.4010.35720.5088
Decreasing
Slightly volatile
Cash and Equivalents Turnover15.346413.97840.8862
Decreasing
Slightly volatile
Accounts Payable Turnover12.401411.175911.7037
Increasing
Stable
Accrued Expenses Turnover43.02739.48239.0853
Decreasing
Slightly volatile
Interest Coverage3.82473.55033.5269
Increasing
Slightly volatile
Long Term Debt to Equity1.02651.03060.9211
Increasing
Slightly volatile
Quick Ratio0.64070.65480.6473
Increasing
Stable
Net Current Assets as percentage of Total Assets(1.496)(0.9056)(0.8791)
Increasing
Stable
Revenue to Assets0.27650.25020.3352
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets48.4 B47.1 B37.8 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA3.9 B3.9 B3.2 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD3.9 B3.9 B3.2 B
Increasing
Slightly volatile
Earnings before Tax2 B1.9 B1.6 B
Increasing
Slightly volatile
Average Equity14.1 B13.9 B11.3 B
Increasing
Slightly volatile
Enterprise Value40.1 B37 B28.3 B
Increasing
Slightly volatile
Free Cash Flow(565.3 M)(1.3 B)(2.5 M)
Decreasing
Slightly volatile
Invested Capital63.3 B53.8 B46 B
Increasing
Slightly volatile
Invested Capital Average58.2 B57.2 B45 B
Increasing
Slightly volatile
Market Capitalization24.6 B22.5 B16.7 B
Increasing
Slightly volatile
Tangible Asset Value48.9 B47.7 B38.5 B
Increasing
Slightly volatile
Working Capital(884 M)(437 M)(287.3 M)
Decreasing
Stable
Revenue Per Employee869.9 K804.9 K857.8 K
Decreasing
Slightly volatile
Net Income Per Employee86.1 K83 K73.6 K
Increasing
Slightly volatile