Consolidated Edison Financial Statements Trends

Consolidated Edison -- USA Stock  

USD 78.12  0.19  0.24%

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 Equivalents797 M776 M534.6 M
Increasing
Slightly volatile
Cash and Equivalents USD905.3 M776 M542.9 M
Increasing
Slightly volatile
Total Debt16.6 B15.8 B12.1 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 Profit6.1 B5.7 B4.9 B
Increasing
Slightly volatile
Interest Expense710 M696 M613.5 M
Increasing
Slightly volatile
Net Income1.5 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
Revenues12 B12.1 B12.4 B
Increasing
Very volatile
Revenues USD13 B12.1 B12.5 B
Increasing
Stable
Weighted Average Shares310.6 M300.4 M283.6 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 Operations(792 M)3.5 B2.2 B
Increasing
Stable
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.720.8860.9358
Decreasing
Stable
Debt to Equity Ratio1082.37410.4203
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 Share4.944.123.8185
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 Share2.57(4.318)0.4499
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.12670.1030.0882
Increasing
Slightly volatile
Payout Ratio0.67630.6460.7176
Decreasing
Stable
Price to Book Value1.441.571.4103
Increasing
Slightly volatile
Price to Earnings Ratio15.7117.75415.0438
Increasing
Slightly volatile
Price to Sales Ratio2.01.8331.3401
Increasing
Slightly volatile
Revenue Growth(0.0332)(0.0283)0.0085
Decreasing
Slightly volatile
Return on Average Assets0.03380.0260.0298
Decreasing
Slightly volatile
Return on Average Equity0.10260.0890.0976
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 Margin32.8320.463818.104
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 EBITDA4 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.2 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.1 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

My Equities

My Current Equities and Potential Positions
View AllNext
ED - USA Stock
Consolidated Edison
Fama & French Utilities
Utilities
Fama & French Classification
RegionNorth America
ExchangeNew York Stock Exchange
$78.12

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  
Additionally see analysis of Consolidated Edison Correlation with competitors. Please also try Headlines Timeline module to stay connected to all market stories and filter out noise. drill down to analyze hype elasticity.