Consolidated Edison Financial Statements Trends

Consolidated Edison Inc -- USA Stock  

USD 85.04  0.18  0.21%

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 B37.8 B
Increasing
Slightly volatile
Current Assets3.8 B3.4 B3.3 B
Increasing
Slightly volatile
Assets Non Current45.6 B44.8 B34.8 B
Increasing
Slightly volatile
Cash and Equivalents816 M776 M516 M
Increasing
Slightly volatile
Cash and Equivalents USD905.3 M776 M523.5 M
Increasing
Slightly volatile
Total Debt16.4 B15.8 B11.7 B
Increasing
Slightly volatile
Debt Current1.8 B1.1 B2.3 B
Decreasing
Slightly volatile
Debt Non Current14.1 B14.7 B11.1 B
Increasing
Slightly volatile
Total Debt USD15.8 B15.8 B11.7 B
Increasing
Slightly volatile
Deposit Liabilities371.6 M352 M303.4 M
Increasing
Slightly volatile
Shareholders Equity14.4 B14.3 B11.4 B
Increasing
Slightly volatile
Shareholders Equity USD14.4 B14.3 B11.4 B
Increasing
Slightly volatile
Goodwill and Intangible Assets517.4 M552 M453 M
Increasing
Slightly volatile
Inventory362.6 M339 M359.8 M
Decreasing
Very volatile
Investments1.5 B1.9 B684.9 M
Increasing
Slightly volatile
Investments Non Current1.5 B1.9 B684.9 M
Increasing
Slightly volatile
Total Liabilities35 B33.9 B26.7 B
Increasing
Slightly volatile
Current Liabilities4.7 B3.8 B3.6 B
Increasing
Slightly volatile
Liabilities Non Current30.5 B30.1 B23.1 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.1 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 M253.9 M
Decreasing
Slightly volatile
Tax Liabilities10.5 B10.3 B7.5 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.8 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT2.7 B2.6 B2.2 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD2.7 B2.6 B2.2 B
Increasing
Slightly volatile
Gross Profit5.7 B5.7 B4.7 B
Increasing
Slightly volatile
Interest Expense710 M696 M606.6 M
Increasing
Slightly volatile
Net Income1.3 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)(231.7 M)
Decreasing
Slightly volatile
Operating Expenses3.3 B3.2 B2.6 B
Increasing
Slightly volatile
Operating Income2.6 B2.5 B2.2 B
Increasing
Slightly volatile
Preferred Dividends Income Statement Impact3.5 M3 M7 M
Decreasing
Slightly volatile
Revenues12 B12.1 B12.5 B
Increasing
Very volatile
Revenues USD13 B12.1 B12.5 B
Increasing
Stable
Weighted Average Shares309.8 M300.4 M282.1 M
Increasing
Slightly volatile
Weighted Average Shares Diluted313.8 M301.9 M283.2 M
Increasing
Slightly volatile
Income Tax Expense685.8 M698 M552.1 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.4 B)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion1.2 B1.2 B921.3 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents40.5 M(172 M)82.2 M
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(368.9 M)(402 M)(209.2 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares396.8 M753 M218.1 M
Increasing
Very volatile
Issuance Repayment of Debt Securities 1.4 B1.4 B720.1 M
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (787.4 M)(763 M)(670.4 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing1 B1.3 B237.2 M
Increasing
Slightly volatile
Net Cash Flow from Investing(4.5 B)(5 B)(2.7 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations3.4 B3.5 B2.5 B
Increasing
Slightly volatile
Cash Beginning of Year864.7 M944 M441.1 M
Increasing
Slightly volatile
Cash End of Year905.3 M772 M511 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.28210.2560.3607
Decreasing
Slightly volatile
Book Value per Share48.151646.98739.7994
Increasing
Slightly volatile
Current Ratio0.760.8860.9433
Decreasing
Very volatile
Debt to Equity Ratio1132.37411.5325
Increasing
Slightly volatile
Share Dilution Ratio1.05711.00481.0077
Increasing
Slightly volatile
Dividend Yield0.040.0360.0497
Decreasing
Slightly volatile
Dividends per Basic Common Share2.77892.682.6557
Increasing
Very volatile
EBITDA Margin0.31790.3190.2524
Increasing
Slightly volatile
Earnings per Basic Share4.32634.153.7589
Increasing
Slightly volatile
Earnings per Diluted Share4.134.123.7258
Increasing
Slightly volatile
EPS Diluted Growth0.06280.09160.0728
Decreasing
Stable
EPS Growth0.0640.09120.0727
Decreasing
Stable
Earnings per Basic Share USD4.32634.153.7589
Increasing
Slightly volatile
Enterprise Value over EBIT14.210514.011.7675
Increasing
Slightly volatile
Enterprise Value over EBITDA9.78269.5978.6203
Increasing
Slightly volatile
Free Cash Flow per Share2.67(4.318)0.8556
Decreasing
Stable
Gross Margin0.480.4740.383
Increasing
Slightly volatile
Financial Leverage0.77420.73360.7283
Increasing
Slightly volatile
Leverage Ratio3.5673.47283.332
Increasing
Slightly volatile
NCFO Growth0.14050.15750.2507
Decreasing
Very volatile
Net Income Growth0.06350.09250.0486
Increasing
Very volatile
Profit Margin0.10560.1030.0852
Increasing
Slightly volatile
Payout Ratio0.67630.6460.7236
Decreasing
Stable
Price to Book Value1.791.571.4262
Increasing
Slightly volatile
Price to Earnings Ratio20.5317.75415.2196
Increasing
Slightly volatile
Price to Sales Ratio2.191.8331.3148
Increasing
Slightly volatile
Revenue Growth0.0092(0.0283)0.0152
Decreasing
Slightly volatile
Return on Average Assets0.03250.0260.03
Decreasing
Slightly volatile
Return on Average Equity0.0890.0920.0972
Decreasing
Slightly volatile
Return on Invested Capital0.05410.0460.0532
Decreasing
Slightly volatile
Return on Sales0.21790.2190.1786
Increasing
Slightly volatile
Weighted Average Share Growth4.0E-43.0E-40.017
Decreasing
Slightly volatile
Sales per Share43.706340.19644.6848
Decreasing
Slightly volatile
Tax Efficiency0.69540.66350.6595
Increasing
Slightly volatile
Tangible Assets Book Value per Share164157132
Increasing
Slightly volatile
Total Assets Per Share172171137
Increasing
Slightly volatile
Cash Flow Per Share12.342212.2668.7021
Increasing
Slightly volatile
Return on Investment9.7939.00699.7593
Decreasing
Slightly volatile
Operating Margin20.9120.463816.9141
Increasing
Slightly volatile
Calculated Tax Rate36.61735.923834.2186
Increasing
Slightly volatile
Receivables Turnover7.38186.95277.3226
Decreasing
Slightly volatile
Inventory Turnover25.93224.348325.6641
Increasing
Stable
PPandE Turnover0.4010.35720.5214
Decreasing
Slightly volatile
Cash and Equivalents Turnover15.346413.97843.1286
Decreasing
Slightly volatile
Accounts Payable Turnover12.401411.175911.7477
Increasing
Slightly volatile
Accrued Expenses Turnover43.02739.48239.0522
Decreasing
Slightly volatile
Interest Coverage3.82473.55033.525
Increasing
Slightly volatile
Long Term Debt to Equity1.02651.03060.912
Increasing
Slightly volatile
Quick Ratio0.64070.65480.6466
Increasing
Stable
Net Current Assets as percentage of Total Assets(1.496)(0.9056)(0.8769)
Increasing
Stable
Revenue to Assets0.27650.25020.3423
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets48.4 B47.1 B37 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA3.8 B3.9 B3.1 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD3.9 B3.9 B3.1 B
Increasing
Slightly volatile
Earnings before Tax2 B1.9 B1.6 B
Increasing
Slightly volatile
Average Equity14.1 B13.9 B11.1 B
Increasing
Slightly volatile
Enterprise Value41.5 B37 B27.7 B
Increasing
Slightly volatile
Free Cash Flow(565.3 M)(1.3 B)105.4 M
Decreasing
Slightly volatile
Invested Capital55.9 B53.8 B44.8 B
Increasing
Slightly volatile
Invested Capital Average58.2 B57.2 B44 B
Increasing
Slightly volatile
Market Capitalization26.3 B22.5 B16.4 B
Increasing
Slightly volatile
Tangible Asset Value48.9 B47.7 B37.7 B
Increasing
Slightly volatile
Working Capital(884 M)(437 M)(274.9 M)
Decreasing
Stable
Revenue Per Employee869.9 K804.9 K862.2 K
Decreasing
Stable
Net Income Per Employee86.1 K83 K72.9 K
Increasing
Slightly volatile