Consolidated Edison, Inc. Financial Ratios — ED Stock

Profitability (USD)

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Return on Common Equity (%)	9.26	9.77	8.81	8.8	9.31	9.1	10.26	8.6	7.73	5.97	6.92	8.15	12.04	8.44	8.77
Return on Assets (%)	2.81	2.84	2.59	2.58	2.66	2.65	3.17	2.71	2.4	1.82	2.14	2.51	3.72	2.66	2.79
Return on Capital (%)	6.51	6.76	6.51	5.9	6.16	5.88	6.7	5.8	5.28	4.72	5.1	5.37	7.39	5.9	5.83
Return on Invested Capital (%)	6.45	6.71	6.42	5.75	6.1	6.2	6.81	5.93	5.67	5.8	5.44	4.42	5.89	4.78	4.51
Gross Margin (%)	38.15	42	41.79	39.57	43.76	49.05	52.1	50.56	53.81	58.38	56.07	49.04	50.5	53.53	53.25
EBITDA Margin (%)	24.24	27.03	26.45	25.39	28.33	33.09	34.2	33.25	34.67	37.35	35.52	29.87	35.65	31.63	31.07
Operating Margin (%)	17.46	19.19	18.16	16.75	19.33	22.24	23.14	20.53	21.28	21.67	20.66	16.75	15.9	17.91	17.73
Incremental Operating Margin (%)	- -	- -	- -	- -	- -	- -	- -	- -	60.34	6.71	12.03	- -	29.1	67.62	16.13
Pretax Margin (%)	12.9	14.28	12.45	12.85	14.32	16.09	16.6	14.45	13.81	10.08	10.11	13.39	20.48	14.01	15.35
Profit Margin (%)	8.24	9.36	8.6	8.45	9.5	10.31	12.67	11.2	10.68	8.99	9.84	10.59	17.18	11.93	11.96
Net Income to Common Margin (%)	8.16	9.34	8.6	8.45	9.5	10.31	12.67	11.2	10.68	8.99	9.84	10.59	17.18	11.93	11.96
Effective Tax Rate (%)	36.1	34.46	30.95	34.22	33.65	35.92	23.64	22.49	17.05	7.29	13.74	23.74	16.22	14.87	22.1
Dvd Payout Ratio (%)	65.94	62.3	67.89	67.67	61.44	61.29	52.66	60.93	60.12	82.14	99.04	70.71	43.61	60.44	57.64
Sustainable Growth Rate (%)	3.15	3.68	2.83	2.84	3.59	3.52	4.86	3.36	3.08	1.07	0.07	2.39	6.79	3.34	3.71

Credit (USD)

Credit Ratios API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Total Debt	10,675	11,309	12,425	12,906	14,274	15,828	16,606	20,711	22,539	25,079	25,362	24,415	25,010	27,825	28,376
ST Debt	530	1,245	1,936	1,360	2,268	1,093	1,875	3,216	3,203	3,933	2,041	3,792	2,654	2,788	2,448
LT Debt	10,145	10,064	10,489	11,546	12,006	14,735	14,731	17,495	19,336	21,146	23,321	20,623	22,356	25,037	25,928
Total Debt/EBITDA	3.42	3.43	3.8	3.93	4.01	3.96	4.04	5.05	5.17	5.48	5.22	5.22	4.78	5.77	5.4
Net Debt/EBITDA	3.21	3.31	3.6	3.72	3.75	3.77	3.84	4.83	4.74	5.02	4.85	4.82	4.45	5.39	4.99
Total Debt/EBIT	4.77	4.83	5.54	5.84	5.88	5.69	5.99	7.77	8.42	9.45	8.97	9.3	7.83	10.42	9.67
Net Debt/EBIT	4.48	4.67	5.24	5.53	5.49	5.41	5.7	7.44	7.73	8.65	8.33	8.6	7.28	9.74	8.94
EBITDA to Interest Expense	5.26	5.45	4.55	5.55	5.45	5.74	5.64	5.01	4.4	4.49	5.29	4.92	5.11	4.06	4.26
EBITDA-CapEx/Interest Expense	1.95	2.03	1.02	1.46	0.77	0.45	0.92	0.74	0.88	0.65	5.29	4.92	5.11	4.06	4.26
EBIT to Interest Expense	3.79	3.87	3.12	3.66	3.72	3.86	3.82	3.09	2.7	2.6	3.08	2.76	2.28	2.3	2.43
Interest Expense	594	604	719	591	653	696	729	819	991	1,019	919	951	1,023	1,187	1,233
Common Equity/Total Assets	29.16	28.8	30.13	28.54	28.6	29.63	32.05	31.02	31.03	29.97	31.75	29.95	31.9	31.12	32.42
Long-Term Debt/Equity (%)	87.09	84.79	85.66	91.74	91.92	103	95.5	103.9	106.17	110.92	114.68	98.73	105.66	114	107.18
Long-Term Debt/Capital (%)	45.44	43.42	42.52	45.29	43.92	48.9	45.99	46.59	47.45	47.9	51.03	45.52	48.42	50.29	49.32
Long-Term Debt/Total Assets (%)	25.87	24.42	25.81	26.2	26.3	30.54	30.62	32.45	33.29	33.62	36.95	29.86	33.7	35.48	34.75
Total Debt/Equity (%)	91.64	95.28	101.47	102.55	109.29	110.64	107.66	122.99	123.75	131.54	124.71	116.88	118.21	126.7	117.3
Total Debt/Capital (%)	47.82	48.79	50.36	50.63	52.22	52.53	51.84	55.16	55.31	56.81	55.5	53.89	54.17	55.89	53.98
Total Debt/Total Assets (%)	27.22	27.44	30.57	29.28	31.27	32.8	34.52	38.41	38.81	39.87	40.18	35.35	37.7	39.43	38.04
Net Debt to Equity	86.06	91.95	95.97	97	102.06	105.21	102.49	117.68	113.57	120.36	115.76	107.97	110.01	118.37	108.5
Net Debt/Capital (%)	46.25	47.9	48.97	49.24	50.51	51.27	50.61	54.06	52.01	53.52	52.66	51.23	51.75	53.64	51.53
EBITDA	3,123	3,294	3,268	3,280	3,557	3,996	4,115	4,102	4,360	4,574	4,858	4,680	5,227	4,825	5,256
EBITDA-CapEx	1,156	1,225	730	861	503	316	672	605	874	665	4,858	4,680	5,227	4,825	5,256
Operating Income (Loss)	2,250	2,339	2,244	2,164	2,427	2,686	2,784	2,533	2,676	2,654	2,826	2,624	2,331	2,732	3,000

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Cash Ratio	0.22	0.12	0.21	0.19	0.2	0.2	0.16	0.14	0.16	0.17	0.18	0.11	0.18	0.21	0.25
Current Ratio	1.22	0.87	0.82	0.99	0.81	0.89	0.72	0.62	0.68	0.72	1.02	1.14	1.01	1.04	1.02
Quick Ratio	0.85	0.62	0.64	0.74	0.6	0.68	0.56	0.48	0.49	0.55	0.76	0.4	0.77	0.82	0.83
CFO/Avg Current Liab	1.14	0.75	0.59	0.67	0.77	0.81	0.77	0.49	0.5	0.32	0.43	0.47	0.24	0.56	0.74
Common Equity/Total Assets	29.16	28.8	30.13	28.54	28.6	29.63	32.05	31.02	31.03	29.97	31.75	29.95	31.9	31.12	32.42
Long-Term Debt/Equity (%)	87.09	84.79	85.66	91.74	91.92	103	95.5	103.9	106.17	110.92	114.68	98.73	105.66	114	107.18
Long-Term Debt/Capital (%)	45.44	43.42	42.52	45.29	43.92	48.9	45.99	46.59	47.45	47.9	51.03	45.52	48.42	50.29	49.32
Long-Term Debt/Total Assets (%)	25.87	24.42	25.81	26.2	26.3	30.54	30.62	32.45	33.29	33.62	36.95	29.86	33.7	35.48	34.75
Total Debt/Equity (%)	91.64	95.28	101.47	102.55	109.29	110.64	107.66	122.99	123.75	131.54	124.71	116.88	118.21	126.7	117.3
Total Debt/Capital (%)	47.82	48.79	50.36	50.63	52.22	52.53	51.84	55.16	55.31	56.81	55.5	53.89	54.17	55.89	53.98
Total Debt/Total Assets (%)	27.22	27.44	30.57	29.28	31.27	32.8	34.52	38.41	38.81	39.87	40.18	35.35	37.7	39.43	38.04
CFO/Total Liabilities	11.38	8.86	8.99	8.99	10.06	10.19	10.3	7.27	7.86	5.01	6.39	8.17	4.77	7.44	9.52
CFO/CapEx	1.59	1.26	1.01	1.17	1.07	0.94	0.98	0.77	0.9	0.56	- -	- -	- -	- -	- -
Altman's Z-Score	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Accounts Receivable Turnover	11.22	10.39	9.99	10.54	11.14	11.19	10.89	10.41	10.05	8.34	7.51	7.58	6.36	6.28	6.74
Days Sales Outstanding	32.52	35.11	36.53	34.64	32.75	32.62	33.5	35.06	36.33	43.77	48.63	48.16	57.38	58.11	54.18
Inventory Turnover	22.64	20.61	20.75	21.24	19.56	17.86	17.13	17.63	16.36	14.4	15.15	17.19	15.11	14.86	15.58
Days Inventory Outstanding	16.12	17.71	17.59	17.18	18.66	20.44	21.31	20.7	22.31	25.35	24.09	21.23	24.16	24.56	23.42
Accounts Payable Turnover	7.58	6.49	6.47	7.62	6.89	5.7	4.73	4.95	4.94	3.87	4.1	4.66	3.88	4.12	4.39
Accounts Payable Turnover Days	48.18	56.23	56.39	47.91	52.98	64.04	77.1	73.7	73.95	94.42	89.08	78.36	94.09	88.64	83.13
Cash Conversion Cycle	0.46	-3.41	-2.27	3.91	-1.56	-10.99	-22.29	-17.93	-15.31	-25.3	-16.36	-8.97	-12.55	-5.97	-5.52
Inventory to Cash Days	16.4	17.4	18.94	17.46	14.09	12.18	12.19	14.36	14.02	18.42	24.54	26.93	33.21	33.55	30.76
Inventories	356	330	363	372	350	339	334	358	352	356	437	492	469	485	530
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	356	330	363	372	350	339	334	358	352	356	437	492	469	485	530

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Market Capitalization	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
- Cash & Cash Equivalents	648	394	674	699	944	776	797	895	981	1,272	992	1,282	1,189	1,324	1,629
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	213	- -	- -	9	9	8	7	113	191	218	299	202	- -	- -	- -
+ Total Debt	10,675	11,309	12,425	12,906	14,274	15,828	16,606	20,711	22,539	25,079	25,362	24,415	25,010	27,825	28,376
Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Capital	22,324	23,178	24,670	25,491	27,335	30,134	32,031	37,550	40,752	44,144	45,698	45,304	46,168	49,787	52,566
Total Debt/Capital (%)	47.82	48.79	50.36	50.63	52.22	52.53	51.84	55.16	55.31	56.81	55.5	53.89	54.17	55.89	53.98
Total Debt / EV	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Market Cap	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Sales	12,886	12,188	12,354	12,919	12,554	12,075	12,033	12,337	12,574	12,246	13,676	15,670	14,663	15,256	16,918
TTM EBITDA	3,123	3,294	3,268	3,280	3,557	3,996	4,115	4,102	4,360	4,574	4,858	4,680	5,227	4,825	5,256
TTM Operating Income	2,250	2,339	2,244	2,164	2,427	2,686	2,784	2,533	2,676	2,654	2,826	2,624	2,331	2,732	3,000
TTM Cash Flow to Firm	3,517	2,995	3,048	3,220	3,710	3,905	3,924	3,330	3,956	3,143	3,526	4,660	3,013	4,624	5,760
TTM Free Cash Flow to Firm	1,550	926	510	801	656	225	481	-167	470	-766	3,526	4,660	3,013	4,624	5,760

Multiples (USD)

Valuation Multiples API ChatGPT

No data availableFinancial data will appear here once available

Per Share Data Items (USD)

Per-Share Data API ChatGPT

	2011 Y	2012 Y	2013 Y	2014 Y	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y
As of date	12/31/2011	12/31/2012	12/31/2013	12/31/2014	12/31/2015	12/31/2016	12/31/2017	12/31/2018	12/31/2019	12/31/2020	12/31/2021	12/31/2022	12/31/2023	12/31/2024	12/31/2025

Shares Outstanding	293	293	293	293	293	305	310	321	333	342	354	355	345	347	361
Diluted Weighted Avg Shares	294	294	294	294	294	302	309	313	329	336	349	356	349	347	359
Basic Weighted Avg Shares	293	293	293	293	293	300	307	312	328	335	348	354	348	346	357
Revenue per Share	44.04	41.61	42.18	44.11	42.85	40.2	39.18	39.58	38.28	36.58	39.25	44.2	42.17	44.09	47.34
EBITDA per Share	10.67	11.25	11.16	11.2	12.14	13.3	13.4	13.16	13.27	13.66	13.94	13.2	15.03	13.95	14.71
Operating Income per Share	7.69	7.99	7.66	7.39	8.28	8.94	9.07	8.13	8.15	7.93	8.11	7.4	6.7	7.9	8.39
Basic EPS, GAAP	3.59	3.89	3.63	3.73	4.07	4.14	4.97	4.43	4.09	3.29	3.86	4.68	7.24	5.26	5.66
Basic EPS from Cont Ops	3.63	3.9	3.63	3.73	4.07	4.14	4.97	4.43	4.38	3.42	3.42	4.51	7.24	5.26	5.66
Diluted EPS, GAAP	3.57	3.86	3.61	3.71	4.05	4.12	4.94	4.42	4.08	3.28	3.85	4.67	7.21	5.24	5.64
Diluted EPS from Cont Ops	3.61	3.87	3.61	3.71	4.05	4.12	4.94	4.42	4.37	3.41	3.41	4.5	7.2	5.24	5.64
Dividend per Share	2.41	2.43	2.46	2.52	2.5	2.54	2.61	2.7	2.81	2.91	2.96	3.07	3.15	3.18	3.26
Cash Flow per Share	10.72	8.87	8.71	9.67	11.18	11.51	10.96	8.65	9.54	6.57	7.84	11.1	6.2	10.45	13.43
Free Cash Flow per Basic Share	4	1.81	0.05	1.41	0.76	-0.74	-0.25	-2.57	-1.07	-5.11	7.84	11.1	6.2	10.45	13.43
Cash & Equivalents per Share	2.21	1.58	3.42	2.41	3.23	2.54	2.57	2.79	2.95	3.72	2.8	3.61	3.44	3.82	4.51
Book Value per Share	39.05	40.53	41.81	42.94	44.55	46.88	49.74	52.11	54.18	55.06	56.6	58.28	61.25	63.36	66.99
Tangible Book Value per Share	37.57	39.05	40.33	41.46	43.08	45.07	47.93	45.58	48.16	49.49	51.71	57.13	60.07	62.19	65.86