CMS Energy Corporation Financial Ratios — CMS-PC 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
Return on Common Equity (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	211.12	68.55	58.2	53.69	47.32
Return on Assets (%)	2.59	2.27	2.62	2.61	2.65	2.63	2.06	2.76	2.65	2.67	4.63	2.79	2.73	2.89	2.82
Return on Capital (%)	12.2	10.35	10.68	10.25	9.55	9.28	7.06	9.7	8.54	9.01	13.22	8.62	8.73	8.84	8.59
Return on Invested Capital (%)	6.46	5.62	6.02	6.18	5.85	5.92	4.66	6.14	5.18	5.61	5.19	5.16	4.47	4.99	5.02
Gross Margin (%)	26.97	29.27	30.52	29.1	33.92	36.69	38.02	34.89	36.76	40.98	36.14	32.13	38.35	42.7	41.53
EBITDA Margin (%)	23.82	25.6	26.96	25.59	29.86	32.3	33.71	30.48	31.76	35.42	30.84	27.34	32.36	36.29	35.52
Operating Margin (%)	15.42	16.04	17.39	16.05	18.25	19.63	20.33	16.91	16.83	19.16	15.64	14.24	16.55	19.79	20.22
Incremental Operating Margin (%)	43.66	- -	44.41	1.63	-3.6	-136.84	44.57	-60.69	18.88	-55.83	-9.22	6.16	-0.97	475.47	23.44
Pretax Margin (%)	9.32	9.95	11.51	10.15	12.33	12.91	13.46	11.26	11.53	12.61	11.23	10.49	12.78	14.94	14.62
Profit Margin (%)	6.38	6.11	6.88	6.64	8.1	8.61	6.99	9.56	10.27	11.76	18.46	9.74	11.89	13.35	12.54
Net Income to Common Margin (%)	6.38	6.11	6.88	6.64	8.1	8.61	6.99	9.53	10.24	11.73	18.39	9.62	11.75	13.21	12.43
Effective Tax Rate (%)	31.52	39.39	39.95	34.29	34.05	33.05	47.86	14.86	17.15	14.22	11.54	10.31	15.41	15.67	19.71
Dvd Payout Ratio (%)	50.6	66.49	59.87	61.33	61.1	62.52	81.25	61.46	68.56	67.49	71.86	68.9	79.25	69.92	70.75
Sustainable Growth Rate (%)	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	59.42	21.32	12.08	16.15	13.84

Credit (USD)

API Chat

	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
Total Debt	7,264	7,514	7,971	8,739	9,473	10,034	10,487	11,777	13,247	12,391	12,474	14,309	15,643	16,566	18,898
ST Debt	1,057	651	732	600	955	1,284	1,273	1,093	1,220	591	382	1,119	1,073	1,260	956
LT Debt	6,207	6,863	7,239	8,139	8,518	8,750	9,214	10,684	12,027	11,800	12,092	13,190	14,570	15,306	17,942
Total Debt/EBITDA	4.69	4.69	4.5	4.76	4.91	4.85	4.73	5.62	6.3	5.45	5.52	6.09	6.48	6.07	6.23
Net Debt/EBITDA	4.48	4.54	4.33	4.58	4.71	4.69	4.6	5.52	6.19	5.41	5.3	5.99	6.36	6	6.02
Total Debt/EBIT	7.24	7.49	6.98	7.59	8.04	7.99	7.84	10.14	11.88	10.07	10.88	11.69	12.67	11.14	10.94
Net Debt/EBIT	6.92	7.25	6.71	7.3	7.72	7.71	7.63	9.94	11.69	10	10.45	11.5	12.43	11	10.57
EBITDA to Interest Expense	3.73	4.12	4.45	4.51	4.87	4.75	5.07	4.57	4.57	4.5	4.52	4.53	3.76	3.85	3.8
EBITDA-CapEx/Interest Expense	3.6	3.99	4.31	4.35	4.58	4.51	4.8	4.26	4.3	4.25	4.25	4.32	2.23	3.63	3.53
EBIT to Interest Expense	2.42	2.58	2.87	2.83	2.97	2.89	3.05	2.54	2.42	2.44	2.29	2.36	1.92	2.1	2.16
Interest Expense	415	389	398	407	396	435	438	458	460	505	500	519	643	708	798
Common Equity/Total Assets	-9.42	-8.29	-7.11	-5.5	-4.2	-2.84	-2.29	-1.09	-0.08	0.73	3.69	4.32	4.96	5.67	6.12
Long-Term Debt/Equity (%)	202.05	211.95	207.36	219.56	214.29	203.96	205.76	222.95	237.92	194.17	168.22	173.67	179.32	174.97	184.76
Long-Term Debt/Capital (%)	107.8	111.81	106.94	105.41	98.38	92.51	92.18	92.53	90.69	89.47	84.47	80.1	80.46	79.12	81.06
Long-Term Debt/Total Assets (%)	37.73	40.06	41.57	42.42	41.96	40.47	39.97	43.56	44.81	39.78	42.05	42.07	43.47	42.61	44.92
Total Debt/Equity (%)	236.46	232.06	228.33	235.74	238.31	233.89	234.19	245.76	262.06	203.9	173.54	188.4	192.53	189.37	194.6
Total Debt/Capital (%)	126.15	122.42	117.76	113.18	109.41	106.09	104.91	102	99.89	93.95	87.14	86.9	86.38	85.63	85.38
Total Debt/Total Assets (%)	44.15	43.86	45.77	45.55	46.67	46.41	45.5	48.01	49.36	41.77	43.38	45.64	46.67	46.12	47.31
Net Debt to Equity	225.78	224.46	219.45	226.84	228.65	225.85	228.09	241.13	257.78	202.45	166.61	185.35	188.97	186.91	187.97
Net Debt/Capital (%)	123.92	120.23	116.13	111.91	108.31	105.05	104.08	101.42	99.31	93.51	86.39	86.35	85.86	84.97	84.41
EBITDA	1,549	1,601	1,770	1,837	1,928	2,067	2,219	2,095	2,104	2,273	2,260	2,350	2,415	2,727	3,033
EBITDA-CapEx	1,495	1,552	1,714	1,771	1,813	1,960	2,104	1,949	1,977	2,144	2,127	2,243	1,436	2,567	2,819
Operating Income (Loss)	1,003	1,003	1,142	1,152	1,178	1,256	1,338	1,162	1,115	1,230	1,146	1,224	1,235	1,487	1,727

Liquidity (USD)

API Chat

	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
Cash Ratio	0.07	0.05	0.09	0.11	0.12	0.09	0.07	0.06	0.05	0.01	0.21	0.05	0.08	0.03	0.14
Current Ratio	1.1	1.35	1.3	1.33	1.01	0.86	0.89	0.94	0.86	0.78	1.19	1.15	0.98	0.79	0.98
Quick Ratio	0.47	0.57	0.6	0.63	0.51	0.47	0.51	0.53	0.48	0.29	0.63	0.58	0.4	0.33	0.52
CFO/Avg Current Liab	0.54	0.6	0.76	0.76	0.77	0.66	0.63	0.63	0.67	0.44	0.69	0.33	0.79	0.74	0.63
Common Equity/Total Assets	-9.42	-8.29	-7.11	-5.5	-4.2	-2.84	-2.29	-1.09	-0.08	0.73	3.69	4.32	4.96	5.67	6.12
Long-Term Debt/Equity (%)	202.05	211.95	207.36	219.56	214.29	203.96	205.76	222.95	237.92	194.17	168.22	173.67	179.32	174.97	184.76
Long-Term Debt/Capital (%)	107.8	111.81	106.94	105.41	98.38	92.51	92.18	92.53	90.69	89.47	84.47	80.1	80.46	79.12	81.06
Long-Term Debt/Total Assets (%)	37.73	40.06	41.57	42.42	41.96	40.47	39.97	43.56	44.81	39.78	42.05	42.07	43.47	42.61	44.92
Total Debt/Equity (%)	236.46	232.06	228.33	235.74	238.31	233.89	234.19	245.76	262.06	203.9	173.54	188.4	192.53	189.37	194.6
Total Debt/Capital (%)	126.15	122.42	117.76	113.18	109.41	106.09	104.91	102	99.89	93.95	87.14	86.9	86.38	85.63	85.38
Total Debt/Total Assets (%)	44.15	43.86	45.77	45.55	46.67	46.41	45.5	48.01	49.36	41.77	43.38	45.64	46.67	46.12	47.31
CFO/Total Liabilities	8.74	8.93	10.2	9.57	10.05	9.4	9.18	8.63	8.22	5.41	8.43	3.6	9.09	8.72	7.39
CFO/CapEx	21.65	25.33	25.38	22.44	14.26	15.22	14.83	11.66	14.09	9.89	13.68	7.99	2.36	14.81	10.44
Altman's Z-Score	0.48	0.49	0.53	0.54	0.45	0.43	0.43	0.41	0.37	0.34	0.46	0.48	0.41	0.4	0.44

Working Capital (USD)

API Chat

	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
Accounts Receivable Turnover	6.99	7.17	7.34	7.91	7.7	7.97	7.06	6.8	7.04	7.23	8.13	6.89	5.98	7.58	7.25
Days Sales Outstanding	52.2	50.9	49.72	46.17	47.41	45.8	51.7	53.69	51.82	50.47	44.9	52.97	61.07	48.13	50.33
Inventory Turnover	4.02	3.9	4.64	5.66	5.03	5.77	6.29	6.77	6.68	6.41	7.53	6.54	4.48	5.05	6.4
Days Inventory Outstanding	90.77	93.71	78.61	64.5	72.56	63.25	58.06	53.91	54.68	56.9	48.47	55.81	81.53	72.35	57.02
Accounts Payable Turnover	8.85	7.82	7.81	7.99	6.2	6.29	6.17	6.05	6.06	5.77	6.18	6.97	5.11	4.38	4.04
Accounts Payable Turnover Days	41.25	46.68	46.72	45.67	58.83	58.04	59.18	60.37	60.25	63.26	59.02	52.36	71.41	83.24	90.25
Cash Conversion Cycle	101.72	97.92	81.61	65	61.13	51.01	50.58	47.24	46.25	44.11	34.35	56.42	71.18	37.24	17.1
Inventory to Cash Days	-38.57	-42.8	-28.88	-18.34	-25.15	-17.45	-6.36	-0.22	-2.85	-6.43	-3.58	-2.84	-20.46	-24.21	-6.69
Inventories	1,187	1,084	881	918	778	626	672	650	605	576	667	1,117	938	769	791
Raw Materials	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Work In Process	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Finished Goods	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Other Inventory	1,187	1,084	881	918	778	626	672	650	605	576	667	1,117	938	769	791

Enterprise Value (USD)

API Chat

	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
Market Capitalization	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
- Cash & Cash Equivalents	161	93	172	207	266	235	182	153	140	32	452	164	227	103	509
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	224	224	224	224	224
+ Minority/Non Controlling Interest	44	44	37	37	37	37	37	37	37	581	557	580	581	518	567
+ Total Debt	7,264	7,514	7,971	8,739	9,473	10,034	10,487	11,777	13,247	12,391	12,474	14,309	15,643	16,566	18,898
Enterprise Value	7,147	7,465	7,836	8,569	9,244	9,836	10,342	11,661	13,144	12,940	12,803	14,949	16,221	17,205	19,180
Total Capital	5,758	6,138	6,769	7,721	8,658	9,458	9,996	11,546	13,262	13,189	14,315	16,466	18,109	19,346	22,135
Total Debt/Capital (%)	126.15	122.42	117.76	113.18	109.41	106.09	104.91	102	99.89	93.95	87.14	86.9	86.38	85.63	85.38
Total Debt / EV	1.02	1.01	1.02	1.02	1.02	1.02	1.01	1.01	1.01	0.96	0.97	0.96	0.96	0.96	0.99
EV/Sales	1.1	1.19	1.19	1.19	1.43	1.54	1.57	1.7	1.98	2.02	1.75	1.74	2.17	2.29	2.25
EV/EBITDA	4.61	4.66	4.43	4.66	4.79	4.76	4.66	5.57	6.25	5.69	5.67	6.36	6.72	6.31	6.32
EV/EBIT	7.13	7.44	6.86	7.44	7.85	7.83	7.73	10.04	11.79	10.52	11.17	12.21	13.13	11.57	11.11
EV/Cash Flow to Firm	4.92	5.05	4.72	4.9	4.86	5.12	5.35	5.57	6.05	7.57	5.66	11.32	5.69	5.8	6.67
EV/Free Cash Flow to Firm	4.74	4.89	4.57	4.72	4.58	4.85	5.05	5.21	5.72	7.04	5.35	10.47	4.23	5.5	6.21
Diluted Market Cap	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted Enterprise Value	7,147	7,465	7,836	8,569	9,244	9,836	10,342	11,661	13,144	12,940	12,803	14,949	16,221	17,205	19,180
EV per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
TTM Sales	6,503	6,253	6,566	7,179	6,456	6,399	6,583	6,873	6,624	6,418	7,329	8,596	7,462	7,515	8,539
TTM EBITDA	1,549	1,601	1,770	1,837	1,928	2,067	2,219	2,095	2,104	2,273	2,260	2,350	2,415	2,727	3,033
TTM Operating Income	1,003	1,003	1,142	1,152	1,178	1,256	1,338	1,162	1,115	1,230	1,146	1,224	1,235	1,487	1,727
TTM Cash Flow to Firm	1,453	1,477	1,660	1,748	1,901	1,920	1,933	2,093	2,171	1,709	2,261	1,320	2,853	2,967	2,876
TTM Free Cash Flow to Firm	1,507	1,526	1,716	1,814	2,016	2,027	2,048	2,239	2,298	1,838	2,394	1,427	3,832	3,127	3,090

Multiples (USD)

API Chat

	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
Price/Free Cash Flow	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EV/EBIT	7.13	7.44	6.86	7.44	7.85	7.83	7.73	10.04	11.79	10.52	11.17	12.21	13.13	11.57	11.11
Enterprise Value	7,147	7,465	7,836	8,569	9,244	9,836	10,342	11,661	13,144	12,940	12,803	14,949	16,221	17,205	19,180
Low Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	24.09	16	17.51	18.07	16.06
EV/Sales	1.1	1.19	1.19	1.19	1.43	1.54	1.57	1.7	1.98	2.02	1.75	1.74	2.17	2.29	2.25
EV/EBITDA	4.61	4.66	4.43	4.66	4.79	4.76	4.66	5.57	6.25	5.69	5.67	6.36	6.72	6.31	6.32
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	1.1	1.19	1.19	1.19	1.43	1.54	1.57	1.7	1.98	2.02	1.75	1.74	2.17	2.29	2.25
EV/Sales High	1.1	1.19	1.19	1.19	1.43	1.54	1.57	1.7	1.98	2.02	1.75	1.74	2.17	2.29	2.25
EV/Sales Low	1.1	1.19	1.19	1.19	1.43	1.54	1.57	1.7	1.98	2.02	1.75	1.74	2.17	2.29	2.25
EV/EBITDA Average	4.61	4.66	4.43	4.66	4.79	4.76	4.66	5.57	6.25	5.69	5.67	6.36	6.72	6.31	6.32
EV/EBITDA High	4.61	4.66	4.43	4.66	4.79	4.76	4.66	5.57	6.25	5.69	5.67	6.36	6.72	6.31	6.32
EV/EBITDA Low	4.61	4.66	4.43	4.66	4.79	4.76	4.66	5.57	6.25	5.69	5.67	6.36	6.72	6.31	6.32
EV/EBIT Average	7.13	7.44	6.86	7.44	7.85	7.83	7.73	10.04	11.79	10.52	11.17	12.21	13.13	11.57	11.11
EV/EBIT High	7.13	7.44	6.86	7.44	7.85	7.83	7.73	10.04	11.79	10.52	11.17	12.21	13.13	11.57	11.11
EV/EBIT Low	7.13	7.44	6.86	7.44	7.85	7.83	7.73	10.04	11.79	10.52	11.17	12.21	13.13	11.57	11.11
Last Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	25	17.67	19.87	18.7	17.45
High Price	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	25.8	25.05	21.26	21.68	19.62
Enterprise Value Average	7,147	7,465	7,836	8,569	9,244	9,836	10,342	11,661	13,144	12,940	12,803	14,949	16,221	17,205	19,180
Enterprise Value High	7,147	7,465	7,836	8,569	9,244	9,836	10,342	11,661	13,144	12,940	12,803	14,949	16,221	17,205	19,180
Enterprise Value Low	7,147	7,465	7,836	8,569	9,244	9,836	10,342	11,661	13,144	12,940	12,803	14,949	16,221	17,205	19,180

	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
Shares Outstanding	254	264	266	275	277	279	282	283	284	289	290	291	294	299	306
Diluted Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic Weighted Avg Shares	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Revenue per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
EBITDA per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Operating Income per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic EPS, GAAP	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Basic EPS from Cont Ops	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted EPS, GAAP	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Diluted EPS from Cont Ops	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Dividend per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash Flow per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Free Cash Flow per Basic Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Cash & Equivalents per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Book Value per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Tangible Book Value per Share	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

CMS Energy Corporation

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)