Consolidated Edison
Financial ratios & Valuation

Forward Multiples (2025 – 2028)

Years

	2025	2026	2027	2028
Price/Earnings ratio	15.12	14.36	13.64	12.80
Price/Sales ratio	1.66	1.61	1.54	1.52
Earnings per Share (EPS)	$5.59	$5.89	$6.20	$6.61

Historical Multiples (2014 – 2023)

Years

	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023	TTM	Median
Valuation Ratios
Price/Earnings ratio	17.70	15.78	17.77	17.10	17.24	22.12	21.97	22.08	20.35	12.55	16.81	22.12
Price/Sales ratio Price/Sales ratio The P/E ratio and P/S reflects how many times investors are paying for every dollar of a company's sales. Since earnings are subject, to one degree or another, to accounting estimates and management manipulation, many investors consider a company's sales (revenue) figure a more reliable ratio component in calculating a stock's price multiple than the earnings figure. $\frac{StockPricePerShare}{RevenuePerShare}$	1.49	1.50	1.83	2.16	1.93	2.36	1.97	2.17	2.15	2.15	2.06	1.93
Price/Book Value ratio	1.53	1.44	1.54	1.69	1.42	1.64	1.28	1.48	1.63	1.49	1.41	1.64
Price/Cash Flow ratio	6.82	5.74	6.39	7.74	8.84	9.48	11.00	10.87	8.58	14.67	9.45	8.84
Price/Free Cash Flow ratio	46.92	84.44	-100.15	-343.26	-29.71	-84.43	-14.14	-24.36	-145.01	-13.52	-20.54	-29.71
Price/Earnings Growth ratio Price/Earnings Growth ratio The PEG ratio is a refinement of the P/E ratio and factors in a stock's estimated earnings growth into its current valuation.The general consensus is that if the PEG ratio indicates a value of 1, this means that the market is correctly valuing (the current P/E ratio) a stock in accordance with the stock's current estimated earnings per share growth. If the PEG ratio is less than 1, this means that EPS growth is potentially able to surpass the market's current valuation. In other words, the stock's price is being undervalued. On the other hand, stocks with high PEG ratios can indicate just the opposite - that the stock is currently overvalued. $\frac{PriceEarningsRatio}{ExpectedRevenueGrowth}$	5.82	1.73	9.04	0.86	-1.58	-2.88	-1.12	1.27	0.95	0.22	12.91	-1.58
Dividend Yield Dividend Yield Income investors value a dividend-paying stock, while growth investors have little interest in dividends, preferring to capture large capital gains. Whatever your investing style, it is a matter of historical record that dividend-paying stocks have performed better than non-paying-dividend stocks over the long term. $\frac{DividendPerShare}{StockPricePerShare}$	3.82%	3.89%	3.44%	3.07%	3.53%	3.10%	4.02%	3.46%	3.22%	3.46%	3.70%	3.53%

Profitability Indicator Ratios
Gross Profit Margin	39.56%	43.76%	47.35%	50.73%	50.55%	53.80%	58.37%	56.06%	49.04%	50.50%	56.29%	50.55%
Operating Profit Margin	17.09%	19.33%	21.32%	21.69%	21.59%	21.28%	21.67%	20.66%	16.74%	21.79%	17.58%	21.28%
Pretax Profit Margin	12.84%	14.32%	16.09%	16.59%	14.45%	13.80%	10.07%	10.11%	13.38%	20.48%	14.77%	14.45%
Net Profit Margin	8.45%	9.50%	10.31%	12.67%	11.20%	10.68%	8.99%	9.84%	10.59%	17.17%	12.26%	11.20%
Effective Tax Rate	34.21%	33.64%	35.92%	23.63%	22.49%	17.05%	7.29%	13.73%	23.73%	16.21%	17.01%	17.05%
Return on Assets	2.46%	2.61%	2.58%	3.17%	2.56%	2.31%	1.75%	2.13%	2.40%	3.79%	2.68%	2.56%
Return On Equity	8.68%	9.14%	8.70%	9.89%	8.26%	7.45%	5.84%	6.71%	8.02%	11.90%	8.55%	8.26%
Return on Capital Employed	5.44%	5.93%	5.79%	6.04%	5.59%	5.16%	4.77%	4.89%	4.54%	5.33%	4.22%	5.16%

Liquidity Ratios
Current Ratio	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	1.00	N/A
Quick Ratio Quick Ratio The quick ratio is more conservative than the current ratio because it excludes inventory and other current assets, which generally are more difficult to turn into cash. A higher quick ratio means a more liquid current position. $\frac{CashAndCashEquivalents + ShortTermInvestments + AccountReceivables}{CurrentLiabilities}$	0.92	0.73	0.79	0.65	0.56	0.62	0.67	0.94	1.10	0.93	0.93	0.56
Cash ratio	0.18	0.2	0.20	0.16	0.14	0.15	0.17	0.18	0.11	0.18	0.01	0.15
Days of Sales Outstanding	58.14	54.71	55.22	51.59	62.57	61.39	81.69	82.89	75.28	94.29	87.36	62.57
Days of Inventory outstanding	17.39	18.09	19.46	20.56	21.42	22.12	25.49	26.54	22.48	23.58	26.21	21.42
Operating Cycle	75.53	72.81	74.69	72.16	83.99	83.51	107.19	109.44	97.77	117.87	113.58	83.99
Days of Payables Outstanding	48.38	52.11	65.85	79.18	71.02	73.15	105.62	90.94	89.36	89.26	81.75	71.02
Cash Conversion Cycle Cash Conversion Cycle The cash conversion cycle (CCC = DSO + DIO – DPO) measures the number of days a company's cash is tied up in the production and sales process of its operations and the benefit it derives from payment terms from its creditors. The shorter this cycle, the more liquid the company's working capital position is. The CCC is also known as the "cash" or "operating" cycle. $(DSO+DIO-DPO)$	27.14	20.69	8.83	-7.01	12.96	10.36	1.56	18.49	8.40	28.61	31.82	12.96

Debt Ratios
Debt Ratio	0.29	0.31	0.32	0.34	0.38	0.37	0.38	0.38	0.34	0.36	0.37	0.37
Debt Equity Ratio	1.02	1.09	1.10	1.07	1.23	1.20	1.28	1.22	1.15	1.15	1.17	1.20
Long-term Debt to Capitalization	0.47	0.47	0.50	0.48	0.51	0.50	0.51	0.53	0.49	0.50	0.51	0.51
Total Debt to Capitalization	0.50	0.52	0.52	0.51	0.55	0.54	0.56	0.55	0.53	0.53	0.54	0.54
Interest Coverage Ratio	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A	2.30	N/A
Cash Flow to Debt Ratio	0.21	0.22	0.21	0.20	0.13	0.14	0.09	0.11	0.16	0.08	0.12	0.14
Company Equity Multiplier	3.52	3.49	3.37	3.11	3.21	3.22	3.33	3.14	3.33	3.13	3.13	3.22

Cash Flow Ratios
Operating Cash Flow / Sales Ratio	0.21	0.26	0.28	0.27	0.21	0.24	0.17	0.19	0.25	0.14	0.21	0.24
Free Cash Flow / Operating Cash Flow Ratio	0.14	0.06	-0.06	-0.02	-0.29	-0.11	-0.77	-0.44	-0.05	-1.08	-0.46	-0.11
Cash Flow Coverage Ratio	0.21	0.22	0.21	0.20	0.13	0.14	0.09	0.11	0.16	0.08	0.12	0.14
Short Term Coverage Ratio	2.08	1.44	3.16	1.79	0.83	0.99	0.56	1.40	1.06	0.84	1.42	0.83
Dividend Payout Ratio	67.67%	61.44%	61.28%	52.65%	60.92%	68.80%	88.55%	76.52%	65.60%	43.50%	59.16%	68.80%

Consolidated Edison Financial ratios & Valuation

Forward Multiples (2025 – 2028)

Historical Multiples (2014 – 2023)

Consolidated Edison
Financial ratios & Valuation