Duke Energy Corporation (Holding Company) Financial Ratios — DUK/PA

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 (%)	7.53	5.56	6.48	4.58	6.99	5.33	7.39	6.23	8.36	2.8	8.15	5.16	5.79	9.18	9.82
Return on Assets (%)	2.81	2	2.33	1.6	2.33	1.7	2.26	1.88	2.46	0.86	2.35	1.47	1.6	2.49	2.6
Return on Capital (%)	5.4	4.23	4.52	3.51	4.64	3.98	4.78	4.52	5.51	- -	5.41	3.99	4.31	5.57	5.77
Return on Invested Capital (%)	4.5	3.33	4.02	3.92	4.15	4.12	4.3	4.02	4.68	- -	4.39	4.51	4.97	5.24	5.44
Gross Margin (%)	38.64	37.28	40.48	40.37	41.73	42.34	45.15	42.94	46.09	48.59	48.57	45.11	47.34	50.06	51.18
EBITDA Margin (%)	33.06	31.06	35.52	37.09	38.85	39.93	41.04	38.26	43.4	43.04	45.34	41.21	45.26	47.25	50.66
Operating Margin (%)	21.36	19.91	23.15	21.83	23.04	22.83	24.95	21.11	22.75	23.7	23.72	22.33	24.44	26.15	26.61
Incremental Operating Margin (%)	27.24	13.69	35.14	144.13	- -	10.48	83.45	- -	94.8	9.75	24.14	14.06	232.53	64.38	33.99
Pretax Margin (%)	16.97	12.47	16.68	16.72	17.48	16.42	18.1	12.53	16.34	3.94	16.21	14.18	16.4	17.11	17.72
Profit Margin (%)	11.74	9.87	11.71	8.37	12.59	9.46	12.98	10.87	14.94	5.89	15.87	8.86	9.78	14.9	15.41
Net Income to Common Margin (%)	11.74	9.87	11.71	8.37	12.59	9.46	12.98	10.87	14.78	5.44	15.44	8.5	9.41	14.55	15.24
Effective Tax Rate (%)	30.51	27.89	31.75	32.55	32.12	30.96	28.04	14.58	12.67	- -	6.72	7.36	9.19	11.36	11.24
Dvd Payout Ratio (%)	77.22	107.82	84.12	87.81	84.45	89.83	79.67	94.93	78.18	393.74	91.48	85.91	73.73	67.72	63.4
Sustainable Growth Rate (%)	1.72	-0.43	1.03	0.56	1.09	0.54	1.5	0.32	1.82	-8.21	0.69	0.73	1.52	2.96	3.6

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	21,000	40,518	41,095	42,382	42,501	50,382	54,442	57,939	62,693	64,076	68,263	74,579	80,457	85,230	90,869
ST Debt	2,321	4,167	2,943	5,321	5,659	4,806	5,407	6,816	6,276	7,111	6,875	7,830	7,088	7,933	9,728
LT Debt	18,679	36,351	38,152	37,061	36,842	45,576	49,035	51,123	56,417	56,965	61,388	66,749	73,369	77,297	81,141
Total Debt/EBITDA	4.37	7.28	5.08	5.08	4.89	5.55	5.63	6.18	5.76	6.37	6.12	6.29	6.12	5.94	5.56
Net Debt/EBITDA	3.93	7.03	4.9	4.83	4.85	5.5	5.59	6.03	5.6	6.21	5.9	6.18	6.03	5.85	5.49
Total Debt/EBIT	7.56	13.92	8.47	8.75	8.37	9.69	9.68	12.37	10.98	14.02	12.41	12.41	11.38	10.75	10.53
Net Debt/EBIT	6.8	13.43	8.16	8.33	8.29	9.61	9.61	12.07	10.68	13.67	11.98	12.19	11.21	10.59	10.39
EBITDA to Interest Expense	5.59	4.47	5.24	5.46	5.69	4.74	4.87	4.48	4.94	4.8	5.06	4.86	4.36	4.24	4.49
EBITDA-CapEx/Interest Expense	5.58	4.47	5.24	5.46	5.69	4.74	4.87	4.48	4.94	4.8	5.06	4.86	4.36	4.24	4.49
EBIT to Interest Expense	3.61	2.87	3.41	3.21	3.38	2.71	2.96	2.47	2.59	2.64	2.65	2.63	2.36	2.35	2.36
Interest Expense	859	1,244	1,543	1,529	1,527	1,916	1,986	2,094	2,204	2,097	2,207	2,439	3,014	3,384	3,634
Common Equity/Total Assets	36.42	35.89	36.01	33.91	32.79	30.91	30.26	30.14	28.24	28.33	27.91	26.59	26.65	26.38	25.99
Long-Term Debt/Equity (%)	81.69	88.59	92.14	90.62	92.64	111.05	117.49	116.63	117.66	115.82	120.05	128.73	146.19	150.81	153.04
Long-Term Debt/Capital (%)	42.58	44.57	46.24	44.5	44.78	49.85	50.98	50.23	50.99	50.3	51.41	52.79	56.16	56.63	56.39
Long-Term Debt/Total Assets (%)	29.87	31.93	33.24	30.74	30.41	34.33	35.55	35.16	35.52	35.08	36.2	37.48	41.48	41.48	41.45
Total Debt/Equity (%)	91.84	98.74	99.24	103.63	106.86	122.76	130.44	132.18	130.74	130.28	133.49	143.83	160.32	166.28	171.39
Total Debt/Capital (%)	47.87	49.68	49.81	50.89	51.66	55.11	56.6	56.93	56.66	56.57	57.17	58.99	61.59	62.45	63.15
Total Debt/Total Assets (%)	33.59	35.59	35.8	35.16	35.08	37.95	39.48	39.85	39.47	39.46	40.25	41.88	45.48	45.74	46.42
Net Debt to Equity	82.62	95.27	95.62	98.65	105.9	121.81	129.58	129.02	127.11	127.03	128.84	141.35	157.99	163.8	168.98
Net Debt/Capital (%)	45.24	48.79	48.88	49.66	51.43	54.92	56.44	55.81	55.24	55.29	55.34	58.16	60.81	61.66	62.37
EBITDA	4,803	5,563	8,083	8,349	8,691	9,082	9,671	9,381	10,885	10,057	11,163	11,855	13,154	14,345	16,330
EBITDA-CapEx	4,794	5,563	8,083	8,349	8,691	9,082	9,671	9,381	10,885	10,057	11,163	11,855	13,154	14,345	16,330
Operating Income (Loss)	3,104	3,567	5,269	4,913	5,154	5,193	5,879	5,176	5,705	5,538	5,841	6,424	7,103	7,938	8,577

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.42	0.18	0.18	0.18	0.03	0.03	0.03	0.03	0.02	0.02	0.02	0.02	0.01	0.02	0.01
Current Ratio	1.24	1.01	1.22	1.03	0.73	0.7	0.68	0.65	0.62	0.53	0.62	0.7	0.74	0.67	0.55
Quick Ratio	0.77	0.45	0.53	0.43	0.23	0.26	0.25	0.24	0.23	0.21	0.24	0.26	0.25	0.25	0.21
CFO/Avg Current Liab	0.78	0.67	0.68	0.66	0.59	0.6	0.55	0.52	0.55	0.57	0.51	0.34	0.55	0.67	0.61
Common Equity/Total Assets	36.42	35.89	36.01	33.91	32.79	30.91	30.26	30.14	28.24	28.33	27.91	26.59	26.65	26.38	25.99
Long-Term Debt/Equity (%)	81.69	88.59	92.14	90.62	92.64	111.05	117.49	116.63	117.66	115.82	120.05	128.73	146.19	150.81	153.04
Long-Term Debt/Capital (%)	42.58	44.57	46.24	44.5	44.78	49.85	50.98	50.23	50.99	50.3	51.41	52.79	56.16	56.63	56.39
Long-Term Debt/Total Assets (%)	29.87	31.93	33.24	30.74	30.41	34.33	35.55	35.16	35.52	35.08	36.2	37.48	41.48	41.48	41.45
Total Debt/Equity (%)	91.84	98.74	99.24	103.63	106.86	122.76	130.44	132.18	130.74	130.28	133.49	143.83	160.32	166.28	171.39
Total Debt/Capital (%)	47.87	49.68	49.81	50.89	51.66	55.11	56.6	56.93	56.66	56.57	57.17	58.99	61.59	62.45	63.15
Total Debt/Total Assets (%)	33.59	35.59	35.8	35.16	35.08	37.95	39.48	39.85	39.47	39.46	40.25	41.88	45.48	45.74	46.42
CFO/Total Liabilities	9.26	7.2	8.7	8.27	8.23	7.48	6.89	7.08	7.4	7.82	7	4.7	7.8	9.13	8.64
CFO/CapEx	408	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
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	10.74	7.69	7.95	7.8	8.9	9.27	8.7	8.3	8.1	7.52	7.38	7.25	6.8	6.95	7.29
Days Sales Outstanding	33.98	47.46	45.89	46.77	41.01	39.38	41.96	43.97	45.07	48.53	49.48	50.35	53.67	52.55	50.04
Inventory Turnover	6.14	4.67	4.19	4	3.62	3.61	3.82	4.42	4.28	3.75	4.03	4.72	3.89	3.45	3.47
Days Inventory Outstanding	59.49	78.15	87.21	91.22	100.88	101.14	95.61	82.62	85.26	97.21	90.48	77.37	93.92	105.79	105.11
Accounts Payable Turnover	6.51	6.64	5.61	5.85	5.77	4.82	4.19	4.23	3.92	3.6	3.78	3.93	3.57	3.18	2.97
Accounts Payable Turnover Days	56.03	54.98	65.02	62.41	63.3	75.66	87.07	86.2	93.13	101.29	96.63	92.96	102.37	114.79	123.02
Cash Conversion Cycle	37.44	70.63	68.09	75.58	78.58	64.86	50.51	40.39	37.21	44.45	43.33	34.76	45.22	43.55	32.13
Inventory to Cash Days	-25.51	-30.69	-41.32	-44.44	-59.87	-61.77	-53.65	-38.65	-40.19	-48.69	-41	-27.02	-40.25	-53.24	-55.07
Inventories	1,588	3,223	3,250	3,459	3,746	3,522	3,250	3,084	3,232	3,167	3,111	3,584	4,292	4,496	4,569
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	1,588	3,223	3,250	3,459	3,746	3,522	3,250	3,084	3,232	3,167	3,111	3,584	4,292	4,496	4,569

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	2,110	1,424	1,501	2,036	383	392	358	442	311	259	341	409	253	314	245
+ Preferred Equity and Hybrid Capital	- -	93	- -	- -	- -	- -	- -	- -	1,962	1,962	1,962	1,962	1,962	973	973
+ Minority/Non Controlling Interest	93	78	78	24	44	8	-2	17	1,129	1,220	1,840	2,531	1,075	1,129	1,177
+ Total Debt	21,000	40,518	41,095	42,382	42,501	50,382	54,442	57,939	62,693	64,076	68,263	74,579	80,457	85,230	90,869
Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Total Capital	43,865	81,552	82,503	83,281	82,272	91,423	96,179	101,773	110,644	113,260	119,399	126,432	130,643	136,486	143,888
Total Debt/Capital (%)	47.87	49.68	49.81	50.89	51.66	55.11	56.6	56.93	56.66	56.57	57.17	58.99	61.59	62.45	63.15
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	14,529	17,912	22,756	22,509	22,371	22,743	23,565	24,521	25,079	23,366	24,621	28,768	29,060	30,357	32,237
TTM EBITDA	4,803	5,563	8,083	8,349	8,691	9,082	9,671	9,381	10,885	10,057	11,163	11,855	13,154	14,345	16,330
TTM Operating Income	3,104	3,567	5,269	4,913	5,154	5,193	5,879	5,176	5,705	5,538	5,841	6,424	7,103	7,938	8,577
TTM Cash Flow to Firm	4,269	6,141	7,435	7,617	7,736	8,186	8,053	8,975	10,134	- -	10,349	8,187	12,615	15,328	15,556
TTM Free Cash Flow to Firm	4,260	6,141	7,435	7,617	7,736	8,186	8,053	8,975	10,134	- -	10,349	8,187	12,615	15,328	15,556

Multiples (USD)

Valuation Multiples 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

Price/Free Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Low Price	- -	- -	- -	- -	- -	- -	- -	- -	25.1	22.1	26.4	22.78	22.71	24.06	24.1
EV/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Earnings Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Tangible Book Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Sales Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Price/Free Cash Flow Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/Sales Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBITDA Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Last Price	- -	- -	- -	- -	- -	- -	- -	- -	27.71	28.51	27.36	23.39	24.4	24.38	24.97
High Price	- -	- -	- -	- -	- -	- -	- -	- -	28.56	28.81	28.84	27.48	26.12	25.66	25.41
Enterprise Value Average	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value High	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Enterprise Value Low	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Per Share Data Items (USD)

Per-Share Data API ChatGPT

No data availableFinancial data will appear here once available