Financial Ratios Xcel Energy Inc.

Equities

XEL

US98389B1008

Electric Utilities

Market Closed - Nasdaq Other stock markets 04:00:00 2024-12-06 pm EST			5-day change	1st Jan Change
69.74 ^USD	-1.58%		-3.89%	+12.65%

Dec. 04	KeyBanc Raises Price Target on Xcel Energy to $79 From $74, Maintains Overweight Rating	MT
Dec. 02	Sector Update: Energy Stocks Fall Late Afternoon	MT

e0e8681.Jhtt9K_H9xWVhsEeClDoJTDdBLmVu16W23yF_1yG514.T05Zo9-WvX3f17VTXRaJS0K6PenM1zujqEXTlCXckg9kYQWi7ZWSV8_Qtg

Published financial data: XCEL ENERGY INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues - (Utility Template)	11.44B	11.44B	13.34B	15.2B	14.09B
Other Revenues, Total	86M	88M	94M	107M	115M
Total Revenues	11.53B	11.53B	13.43B	15.31B	14.21B
Fuel & Purchased Power	3.29B	3.27B	4.48B	4.76B	4.04B
Operations And Maintenance	2.28B	2.25B	2.29B	2.47B	2.42B
Selling General & Admin Expenses, Total	221M	238M	251M	241M	241M
Depreciation & Amortization - (IS) - (Collected)	1.76B	1.95B	2.12B	2.41B	2.45B
Other Operating Expenses	1.9B	1.71B	2.14B	2.96B	2.45B
Total Operating Expenses	9.45B	9.42B	11.28B	12.85B	11.59B
Operating Income (REIT / Utility Template)	2.08B	2.11B	2.15B	2.46B	2.61B
Interest Expense, Total	-773M	-840M	-842M	-953M	-1.06B
Interest and Investment Income	-	-	-	-	-
Net Interest Expenses	-773M	-840M	-842M	-953M	-1.06B
Income (Loss) on Equity Invest.	39M	40M	62M	36M	35M
Allowance For Equity Funds Used During Construction	77M	115M	73M	75M	91M
Allowance For Borrowed Funds Used During Construction	37M	42M	26M	28M	51M
Other Non Operating Income (Expenses)	42M	2M	62M	27M	-3M
EBT, Excl. Unusual Items	1.5B	1.47B	1.53B	1.67B	1.73B
Restructuring Charges	-	-	-	-	-72M
Legal Settlements	-	-	-	-	-35M
Other Unusual Items	-	-	-	-71M	-
EBT, Incl. Unusual Items	1.5B	1.47B	1.53B	1.6B	1.62B
Income Tax Expense	128M	-6M	-70M	-135M	-146M
Earnings From Continuing Operations	1.37B	1.47B	1.6B	1.74B	1.77B
Net Income to Company	1.37B	1.47B	1.6B	1.74B	1.77B
Net Income - (IS)	1.37B	1.47B	1.6B	1.74B	1.77B
Net Income to Common Incl Extra Items	1.37B	1.47B	1.6B	1.74B	1.77B
Net Income to Common Excl. Extra Items	1.37B	1.47B	1.6B	1.74B	1.77B
Per Share Items
Net EPS - Basic	2.64	2.8	2.96	3.17	3.21
Basic EPS - Continuing Operations	2.64	2.8	2.96	3.17	3.21
Basic Weighted Average Shares Outstanding	519M	527M	539M	547M	552M
Net EPS - Diluted	2.64	2.79	2.96	3.17	3.21
Diluted EPS - Continuing Operations	2.64	2.79	2.96	3.17	3.21
Diluted Weighted Average Shares Outstanding	520M	528M	540M	547M	552M
Normalized Basic EPS	1.81	1.74	1.77	1.91	1.96
Normalized Diluted EPS	1.8	1.74	1.77	1.91	1.96
Dividend Per Share	1.62	1.72	1.83	1.95	2.08
Payout Ratio	57.65	58.11	58.55	58.29	61.66
American Depositary Receipts Ratio (ADR)	0.5	0.5	0.5	0.5	0.5
Supplemental Items
Utility Revenues	11.44B	11.44B	13.34B	15.2B	14.09B
Non Utility Revenues	86M	88M	94M	107M	115M
EBITDA	3.81B	4.19B	4.4B	5.01B	5.18B
EBITA	2.08B	2.11B	2.15B	2.46B	2.61B
EBIT	2.08B	2.11B	2.15B	2.46B	2.61B
EBITDAR	4.07B	4.45B	4.69B	5.29B	5.46B
Total Revenues (As Reported)	11.53B	11.53B	13.43B	15.31B	14.21B
Effective Tax Rate - (Ratio)	8.53	-0.41	-4.58	-8.43	-8.98
Current Domestic Taxes	-10M	7M	14M	9M	108M
Total Current Taxes	-10M	7M	14M	9M	108M
Deferred Domestic Taxes	138M	-13M	-84M	-144M	-254M
Total Deferred Taxes	138M	-13M	-84M	-144M	-254M
Normalized Net Income	938M	917M	954M	1.04B	1.08B
Interest Capitalized	37M	42M	26M	28M	51M
Interest on Long-Term Debt	19M	18M	17M	16M	15M
Non-Cash Pension Expense	29M	22M	17M	17M	0
Supplemental Operating Expense Items
Net Rental Expense, Total	255M	264M	287M	280M	283M
Imputed Operating Lease Interest Expense	87.47M	87.03M	84.78M	86.46M	93.38M
Imputed Operating Lease Depreciation	168M	177M	202M	194M	190M
Stock-Based Comp., COGS (Total)	58M	73M	31M	20M	25M
Total Stock-Based Compensation	58M	73M	31M	20M	25M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	248M	129M	166M	111M	129M
Trading Asset Securities, Total	26M	18M	46M	82M	32M
Accounts Receivable, Total	1.55B	1.63B	1.88B	2.48B	2.17B
Accounts Receivable (Summary Subtotal)	1.55B	1.63B	1.88B	2.48B	2.17B
Inventory - (Utility Template)	544M	535M	631M	803M	711M
Prepaid Expenses	228M	292M	333M	414M	346M
Deferred Tax Assets Current	-	-	-	-	-
Other Current Assets, Total	517M	671M	1.18B	1.26B	683M
Total Current Assets	3.11B	3.28B	4.24B	5.14B	4.07B
Gross Property Plant And Equipment	57.69B	61.16B	64.09B	67.38B	71.84B
Accumulated Depreciation	-16.91B	-17.03B	-17.65B	-18.21B	-19.33B
Net Property Plant And Equipment	40.78B	44.13B	46.44B	49.17B	52.51B
Net Nuclear Fuel	374M	311M	308M	291M	349M
Regulatory Assets	2.94B	2.74B	2.74B	2.87B	2.8B
Long-Term Investments - (Utility Template)	218M	237M	324M	362M	376M
Deferred Charges Long-Term	-	-	-	-	-
Other Long-Term Assets, Total	3.03B	3.27B	3.8B	3.35B	3.98B
Total Assets	50.45B	53.96B	57.85B	61.19B	64.08B
Liabilities
Accounts Payable, Total	1.29B	1.24B	1.41B	1.8B	1.67B
Accrued Expenses, Total	192M	203M	209M	217M	251M
Short-Term Borrowings	595M	584M	1B	813M	785M
Current Portion of Long-Term Debt	702M	421M	601M	1.15B	569M
Current Portion of Leases	198M	218M	208M	219M	228M
Current Income Taxes Payable	466M	578M	569M	569M	557M
Unearned Revenue, Current	-	10M	9M	-	-
Deferred Tax Liability Current	75M	20M	26M	9M	7M
Other Current Liabilities - (Bank / Utility Template)	1.05B	968M	1.01B	1.3B	1.59B
Total Current Liabilities	4.57B	4.24B	5.05B	6.08B	5.65B
Long-Term Debt	17.41B	19.64B	21.78B	22.81B	24.91B
Long-Term Leases	1.63B	1.42B	1.22B	1.1B	1.1B
Unearned Revenue Non Current	-	41M	41M	77M	-
Pension & Other Post Retirement Benefits	981M	887M	541M	637M	722M
Deferred Tax Liability Non-Current	8.12B	8.21B	8.23B	7.98B	8.02B
Other Non Current Liabilities, Total	4.51B	4.94B	5.39B	5.83B	6.06B
Total Liabilities	37.21B	39.38B	42.24B	44.51B	46.46B
Common Stock, Total	1.31B	1.34B	1.36B	1.37B	1.39B
Additional Paid In Capital	6.66B	7.4B	7.8B	8.16B	8.46B
Retained Earnings	5.41B	5.97B	6.57B	7.24B	7.86B
Comprehensive Income and Other	-141M	-141M	-123M	-93M	-94M
Total Common Equity	13.24B	14.58B	15.61B	16.68B	17.62B
Total Equity	13.24B	14.58B	15.61B	16.68B	17.62B
Total Liabilities And Equity	50.45B	53.96B	57.85B	61.19B	64.08B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	525M	538M	544M	550M	555M
ECS Total Common Shares Outstanding	525M	537M	544M	550M	555M
Book Value / Share	25.24	27.14	28.7	30.34	31.74
Tangible Book Value	13.24B	14.58B	15.61B	16.68B	17.62B
Tangible Book Value Per Share	25.24	27.14	28.7	30.34	31.74
Total Debt	20.53B	22.28B	24.81B	26.1B	27.6B
Net Debt	20.25B	22.14B	24.6B	25.9B	27.43B
Debt Equivalent of Unfunded Proj. Benefit Obligation	517M	365M	48M	186M	253M
Debt Equivalent Oper. Leases	2.04B	2.11B	2.3B	2.24B	2.26B
Equity Method Investments, Total	155M	165M	208M	219M	244M
Account Code - Inventory Valuation	6	6	6	6	6
Inventories - Raw Materials, Total	461M	451M	471M	531M	588M
Inventories - Finished Goods, Total	83M	84M	160M	272M	123M
Machinery, Total	51.17B	54.92B	57.64B	60.37B	63.63B
Full Time Employees	11.27K	11.37K	11.32K	11.98K	11.31K
Part Time Employees	44	-	-	-	-
Accumulated Allowance for Doubtful Accounts (Supple)	55M	79M	106M	122M	128M

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	1.37B	1.47B	1.6B	1.74B	1.77B
Depreciation, Depletion & Amortization	1.9B	2.08B	2.26B	2.55B	2.57B
Total Depreciation, Depletion & Amortization	1.9B	2.08B	2.26B	2.55B	2.57B
(Income) Loss On Equity Investments - (CF)	-39M	-40M	-62M	-36M	-35M
Stock-Based Compensation (CF)	58M	73M	31M	20M	25M
Provision and Write-off of Bad Debts	42M	60M	60M	73M	79M
Change in Accounts Receivable	22M	-157M	-313M	-672M	225M
Change In Inventories	-84M	-80M	-126M	-203M	-98M
Change in Accounts Payable	-12M	-33M	138M	195M	-149M
Change in Other Net Operating Assets (Collected)	-191M	-285M	-1.14B	565M	1.21B
Other Operating Activities	191M	-245M	-250M	-300M	-272M
Cash from Operations	3.26B	2.85B	2.19B	3.93B	5.33B
Capital Expenditure	-4.22B	-5.37B	-4.24B	-4.64B	-5.85B
Sale of Property, Plant, and Equipment	-	684M	-	-	-
Contributions to Nuclear Decommissioning Trust	-995M	-1.4B	-757M	-1.33B	-994M
Investment in Marketable and Equity Securities, Total	-	-	-	-	-
Other Investing Activities, Total	877M	1.34B	714M	1.32B	922M
Cash from Investing	-4.34B	-4.74B	-4.29B	-4.65B	-5.93B
Short Term Debt Issued, Total	-	-	421M	-	-
Long-Term Debt Issued, Total	2.92B	2.94B	2.71B	2.16B	2.63B
Total Debt Issued	2.92B	2.94B	3.13B	2.16B	2.63B
Short Term Debt Repaid, Total	-443M	-11M	-	-192M	-28M
Long-Term Debt Repaid, Total	-949M	-1B	-417M	-601M	-1.15B
Total Debt Repaid	-1.39B	-1.01B	-417M	-793M	-1.18B
Issuance of Common Stock	458M	727M	366M	322M	270M
Repurchase of Common Stock	-	-	-	-	-
Common Dividends Paid	-791M	-856M	-935M	-1.01B	-1.09B
Common & Preferred Stock Dividends Paid	-791M	-856M	-935M	-1.01B	-1.09B
Other Financing Activities, Total	-14M	-26M	-10M	-15M	-12M
Cash from Financing	1.18B	1.77B	2.14B	666M	617M
Net Change in Cash	101M	-119M	37M	-55M	18M
Supplemental Items
Cash Interest Paid	698M	758M	788M	887M	945M
Cash Income Tax Paid (Refund)	-53M	-12M	4M	15M	-92M
Net Debt Issued / Repaid	1.53B	1.93B	2.71B	1.37B	1.45B
Levered Free Cash Flow	-1.33B	-2.77B	-1.83B	-1.39B	-1.07B
Unlevered Free Cash Flow	-846M	-2.25B	-1.3B	-791M	-412M
Change In Net Working Capital	-118M	350M	687M	264M	-1.22B

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	2.69	2.52	2.4	2.58	2.61
Return on Total Capital	4.11	3.73	3.47	3.7	3.72
Return On Equity %	10.78	10.59	10.58	10.75	10.33
Return on Common Equity	10.78	10.59	10.58	10.75	10.33
Margin Analysis
Gross Profit Margin %	40.41	42.63	38.75	37.69	41.77
SG&A Margin	2.14	2.13	2.29	1.37	1.52
EBITDA Margin %	33.06	36.35	32.78	32.74	36.46
EBITA Margin %	18.02	18.29	15.98	16.06	18.39
EBIT Margin %	18.02	18.29	15.98	16.06	18.39
Income From Continuing Operations Margin %	11.9	12.78	11.89	11.34	12.47
Net Income Margin %	11.9	12.78	11.89	11.34	12.47
Net Avail. For Common Margin %	11.9	12.78	11.89	11.34	12.47
Normalized Net Income Margin	8.13	7.95	7.11	6.83	7.62
Levered Free Cash Flow Margin	-11.53	-24.05	-13.61	-9.06	-7.54
Unlevered Free Cash Flow Margin	-7.34	-19.49	-9.69	-5.17	-2.9
Asset Turnover
Asset Turnover	0.24	0.22	0.24	0.26	0.23
Fixed Assets Turnover	0.3	0.27	0.3	0.32	0.28
Receivables Turnover (Average Receivables)	7.23	7.19	7.6	6.98	6.07
Inventory Turnover (Average Inventory)	12.58	12.26	14.11	13.31	10.93
Short Term Liquidity
Current Ratio	0.68	0.77	0.84	0.85	0.72
Quick Ratio	0.4	0.42	0.41	0.44	0.41
Operating Cash Flow to Current Liabilities	0.71	0.67	0.43	0.65	0.94
Days Sales Outstanding (Average Receivables)	50.48	50.88	48.03	52.31	60.17
Days Outstanding Inventory (Average Inventory)	29.01	29.86	25.87	27.43	33.4
Average Days Payable Outstanding	67.27	70.15	58.03	60.38	77.46
Cash Conversion Cycle (Average Days)	12.21	10.6	15.87	19.37	16.11
Long Term Solvency
Total Debt/Equity	155.06	152.9	158.9	156.51	156.65
Total Debt / Total Capital	60.79	60.46	61.38	61.02	61.04
LT Debt/Equity	143.76	144.51	147.28	143.42	147.67
Long-Term Debt / Total Capital	56.37	57.14	56.89	55.91	57.54
Total Liabilities / Total Assets	73.76	72.99	73.01	72.75	72.51
EBIT / Interest Expense	2.69	2.51	2.55	2.58	2.48
EBITDA / Interest Expense	5.26	5.3	5.57	5.55	5.18
(EBITDA - Capex) / Interest Expense	-0.21	-1.09	0.53	0.69	-0.37
Total Debt / EBITDA	5.05	5	5.29	4.93	5.05
Net Debt / EBITDA	4.98	4.97	5.24	4.89	5.02
Total Debt / (EBITDA - Capex)	-129.11	-24.36	55.62	39.84	-70.58
Net Debt / (EBITDA - Capex)	-127.38	-24.19	55.15	39.55	-70.16
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	-0.07	-0.03	16.53	13.99	-7.21
Gross Profit, 1 Yr. Growth %	6.54