Xcel Energy Inc. (XEL) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Xcel Energy Inc. (XEL) Bundle
Explore the financial potential of Xcel Energy Inc. (XEL) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Xcel Energy Inc. (XEL) and shape your investment decisions.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 11,529.0 | 11,526.0 | 13,431.0 | 15,310.0 | 14,206.0 | 15,032.8 | 15,907.8 | 16,833.6 | 17,813.4 | 18,850.2 |
| Revenue Growth, % | 0 | -0.02602134 | 16.53 | 13.99 | -7.21 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 |
| EBITDA | 4,116.0 | 4,190.0 | 4,462.0 | 5,013.0 | 5,191.0 | 5,248.2 | 5,553.7 | 5,876.9 | 6,219.0 | 6,581.0 |
| EBITDA, % | 35.7 | 36.35 | 33.22 | 32.74 | 36.54 | 34.91 | 34.91 | 34.91 | 34.91 | 34.91 |
| Depreciation | 1,884.0 | 2,082.0 | 2,257.0 | 2,554.0 | 2,567.0 | 2,584.5 | 2,734.9 | 2,894.1 | 3,062.5 | 3,240.8 |
| Depreciation, % | 16.34 | 18.06 | 16.8 | 16.68 | 18.07 | 17.19 | 17.19 | 17.19 | 17.19 | 17.19 |
| EBIT | 2,232.0 | 2,108.0 | 2,205.0 | 2,459.0 | 2,624.0 | 2,663.8 | 2,818.8 | 2,982.9 | 3,156.5 | 3,340.2 |
| EBIT, % | 19.36 | 18.29 | 16.42 | 16.06 | 18.47 | 17.72 | 17.72 | 17.72 | 17.72 | 17.72 |
| Total Cash | 248.0 | 129.0 | 166.0 | 111.0 | 129.0 | 184.6 | 195.3 | 206.7 | 218.7 | 231.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,550.0 | 1,630.0 | 1,880.0 | 2,478.0 | 2,168.0 | 2,195.7 | 2,323.5 | 2,458.7 | 2,601.8 | 2,753.3 |
| Account Receivables, % | 13.44 | 14.14 | 14 | 16.19 | 15.26 | 14.61 | 14.61 | 14.61 | 14.61 | 14.61 |
| Inventories | 544.0 | 535.0 | 631.0 | 803.0 | 711.0 | 730.8 | 773.4 | 818.4 | 866.0 | 916.4 |
| Inventories, % | 4.72 | 4.64 | 4.7 | 5.24 | 5 | 4.86 | 4.86 | 4.86 | 4.86 | 4.86 |
| Accounts Payable | 1,294.0 | 1,237.0 | 1,409.0 | 1,804.0 | 1,668.0 | 1,682.8 | 1,780.8 | 1,884.4 | 1,994.1 | 2,110.1 |
| Accounts Payable, % | 11.22 | 10.73 | 10.49 | 11.78 | 11.74 | 11.19 | 11.19 | 11.19 | 11.19 | 11.19 |
| Capital Expenditure | -4,225.0 | -5,369.0 | -4,244.0 | -4,638.0 | -5,854.0 | -5,602.1 | -5,928.1 | -6,273.2 | -6,638.3 | -7,024.7 |
| Capital Expenditure, % | -36.65 | -46.58 | -31.6 | -30.29 | -41.21 | -37.27 | -37.27 | -37.27 | -37.27 | -37.27 |
| Tax Rate, % | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 |
| EBITAT | 2,041.5 | 2,116.6 | 2,306.1 | 2,666.3 | 2,859.8 | 2,618.3 | 2,770.7 | 2,932.0 | 3,102.6 | 3,283.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1,099.5 | -1,298.4 | 145.1 | 207.3 | -161.2 | -432.0 | -494.9 | -523.7 | -554.2 | -586.5 |
| WACC, % | 5.37 | 5.53 | 5.53 | 5.53 | 5.53 | 5.5 | 5.5 | 5.5 | 5.5 | 5.5 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,196.1 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -604 | |||||||||
| Terminal Value | -24,135 | |||||||||
| Present Terminal Value | -18,464 | |||||||||
| Enterprise Value | -20,661 | |||||||||
| Net Debt | 27,385 | |||||||||
| Equity Value | -48,046 | |||||||||
| Diluted Shares Outstanding, MM | 552 | |||||||||
| Equity Value Per Share | -87.04 |
What You Will Receive
- Adjustable Forecast Parameters: Modify key inputs (growth %, margins, WACC) effortlessly to explore various scenarios.
- Comprehensive Data: Xcel Energy Inc.’s financial information pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional: A refined Excel model that meets your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life XEL Financials: Pre-filled historical and projected data for Xcel Energy Inc. (XEL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Xcel Energy’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Xcel Energy’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based Xcel Energy Inc. (XEL) DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key factors.
- Instant Calculations: The model automatically recalculates Xcel Energy’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation variations.
- Analyze and Decide: Utilize the results to inform your investment or financial strategy.
Why Choose This Calculator for Xcel Energy Inc. (XEL)?
- Designed for Industry Experts: A sophisticated tool utilized by energy analysts, financial officers, and consultants.
- Comprehensive Data: Xcel Energy’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Energy Sector Students: Understand energy market dynamics and analyze real-time data.
- Researchers: Utilize industry models for academic projects or studies related to energy.
- Investors: Evaluate your investment strategies and assess valuation metrics for Xcel Energy Inc. (XEL).
- Financial Analysts: Enhance your analysis with a customizable financial model tailored for the energy sector.
- Small Business Owners: Learn how major energy companies like Xcel Energy Inc. (XEL) are evaluated in the market.
What the Template Contains
- Historical Data: Includes Xcel Energy Inc.'s (XEL) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Xcel Energy Inc.'s (XEL) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Xcel Energy Inc.'s (XEL) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.