Intrinsic value of Consolidated Edison Inc (ED)

[per Chepakovich valuation model]

other valuations of ED

[per Chepakovich valuation model]  See other valuations of ED stock

Previous Close$73.04
Intrinsic Value
Upside potential
Previous Close
$73.04

VALUATION INPUT DATA

Revenue, mln $
Initial revenue growth rate (norm.), %
Variable cost ratio, %
Fixed operating expenses, mln $
Production assets / Revenue, %
Working capital / Revenue, %
Interest rate on debt, %
Life of production assets, yrs
Initial discount rate, %
Shares outstanding, mln
Adjusted equity ratio
Adjusted assets / Revenue
Based on fiscal year data as of 2020-12-31 and quarterly data as of 2021-03-31.
NOTE: The bar chart shows historic and forecasted yearly revenue growth rates. Its purpose is to help you in determining what initial revenue rate you want to base your stock valuation on. Please make sure that you are confident in the value you select - for most stocks it is by far the most important parameter in valuation.
  1. Annual
  2. Quarterly YoY
  3. Quarterly QoQ

Annual revenue growth rates, % (past and forecasted)

show cash flow forecast

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year2020(a)2021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045

INCOME STATEMENT

Revenue growth rate, %-2.6NaN
Revenue, $12246NaN
Variable operating expenses, $mNaN
Fixed operating expenses, $mNaN
Total operating expenses, $m9592NaN
Operating income, $m2654NaN
EBITDA, $m4574NaN
Interest expense (income), $mNaN
Earnings before tax, $m1191NaN
Tax expense, $m90NaN
Net income, $m1101NaN

BALANCE SHEET

Cash and short-term investments, $m1436NaN
Total assets, $m62895NaN
Adjusted assets (=assets-cash), $m61459NaN
Average production assets, $m47177NaN
Working capital, $m-2053NaN
Total debt, $m22514NaN
Total liabilities, $m43830NaN
Total equity, $m19065NaN
Debt-to-equity ratio1.181NaN
Adjusted equity ratio0.322NaN

CASH FLOW

Net income, $m1101NaN
Depreciation, amort., depletion, $m1920NaN
Funds from operations, $mNaN
Change in working capital, $mNaN
Cash from operations, $m2198NaN
Maintenance CAPEX, $mNaN
New CAPEX, $mNaN
Total CAPEX, $m-4219NaN
Free cash flow, $m6417NaN
Issuance/(repurchase) of shares, $mNaN
Retained Cash Flow, $mNaN
Pot'l extraordinary dividend, $m-2053
Cash available for distribution, $mNaN
Discount rate, %NaN
PV of cash for distribution, $mNaN
Current shareholders' claim on cash, %NaN