Vistra Corp. (VST) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Vistra Corp. (VST) Bundle
Evaluate Vistra Corp.'s (VST) financial outlook like an expert! This (VST) DCF Calculator provides pre-filled financial data and allows you complete flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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,809.0 | 11,443.0 | 12,077.0 | 13,728.0 | 14,779.0 | 15,657.2 | 16,587.5 | 17,573.1 | 18,617.3 | 19,723.5 |
Revenue Growth, % | 0 | -3.1 | 5.54 | 13.67 | 7.66 | 5.94 | 5.94 | 5.94 | 5.94 | 5.94 |
EBITDA | 3,408.0 | 3,163.0 | 782.0 | 1,287.0 | 4,573.0 | 3,234.6 | 3,426.8 | 3,630.4 | 3,846.1 | 4,074.6 |
EBITDA, % | 28.86 | 27.64 | 6.48 | 9.38 | 30.94 | 20.66 | 20.66 | 20.66 | 20.66 | 20.66 |
Depreciation | 1,811.0 | 1,977.0 | 1,976.0 | 1,994.0 | 1,867.0 | 2,384.0 | 2,525.7 | 2,675.8 | 2,834.8 | 3,003.2 |
Depreciation, % | 15.34 | 17.28 | 16.36 | 14.53 | 12.63 | 15.23 | 15.23 | 15.23 | 15.23 | 15.23 |
EBIT | 1,597.0 | 1,186.0 | -1,194.0 | -707.0 | 2,706.0 | 850.5 | 901.1 | 954.6 | 1,011.3 | 1,071.4 |
EBIT, % | 13.52 | 10.36 | -9.89 | -5.15 | 18.31 | 5.43 | 5.43 | 5.43 | 5.43 | 5.43 |
Total Cash | 300.0 | 406.0 | 1,325.0 | 455.0 | 3,485.0 | 1,376.4 | 1,458.2 | 1,544.8 | 1,636.6 | 1,733.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,365.0 | 1,279.0 | 1,956.0 | 2,086.0 | 1,680.0 | 2,050.9 | 2,172.8 | 2,301.9 | 2,438.7 | 2,583.6 |
Account Receivables, % | 11.56 | 11.18 | 16.2 | 15.2 | 11.37 | 13.1 | 13.1 | 13.1 | 13.1 | 13.1 |
Inventories | 469.0 | 515.0 | 610.0 | 570.0 | 740.0 | 710.3 | 752.5 | 797.2 | 844.6 | 894.7 |
Inventories, % | 3.97 | 4.5 | 5.05 | 4.15 | 5.01 | 4.54 | 4.54 | 4.54 | 4.54 | 4.54 |
Accounts Payable | 947.0 | 880.0 | 1,515.0 | 1,556.0 | 1,147.0 | 1,482.7 | 1,570.8 | 1,664.2 | 1,763.0 | 1,867.8 |
Accounts Payable, % | 8.02 | 7.69 | 12.54 | 11.33 | 7.76 | 9.47 | 9.47 | 9.47 | 9.47 | 9.47 |
Capital Expenditure | -609.0 | -1,259.0 | -1,033.0 | -1,301.0 | -1,676.0 | -1,425.7 | -1,510.5 | -1,600.2 | -1,695.3 | -1,796.0 |
Capital Expenditure, % | -5.16 | -11 | -8.55 | -9.48 | -11.34 | -9.11 | -9.11 | -9.11 | -9.11 | -9.11 |
Tax Rate, % | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 |
EBITAT | 1,218.8 | 847.5 | -876.4 | -548.4 | 2,020.0 | 635.2 | 672.9 | 712.9 | 755.3 | 800.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,533.8 | 1,538.5 | -70.4 | 95.6 | 2,038.0 | 1,588.0 | 1,612.2 | 1,708.0 | 1,809.4 | 1,917.0 |
WACC, % | 8.42 | 8.37 | 8.39 | 8.44 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 | 8.41 |
PV UFCF | ||||||||||
SUM PV UFCF | 6,767.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,955 | |||||||||
Terminal Value | 30,523 | |||||||||
Present Terminal Value | 20,387 | |||||||||
Enterprise Value | 27,155 | |||||||||
Net Debt | 11,199 | |||||||||
Equity Value | 15,956 | |||||||||
Diluted Shares Outstanding, MM | 375 | |||||||||
Equity Value Per Share | 42.53 |
What You Will Get
- Pre-Filled Financial Model: Vistra Corp.’s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- 🔍 Real-Life VST Financials: Pre-filled historical and projected data for Vistra Corp. (VST).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Vistra’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Vistra’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Vistra Corp. (VST) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Vistra Corp.'s (VST) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Vistra Corp. (VST)?
- Time Efficiency: Skip the hassle of building models from the ground up – our tools are ready for immediate use.
- Enhanced Accuracy: Dependable data and methodologies minimize valuation errors.
- Completely Customizable: Adjust the framework to suit your specific forecasts and assumptions.
- User-Friendly: Intuitive visuals and outputs simplify result interpretation.
- Endorsed by Professionals: Crafted for industry experts who prioritize both precision and functionality.
Who Should Use This Product?
- Institutional Investors: Develop comprehensive and accurate valuation models for portfolio management.
- Energy Sector Analysts: Evaluate valuation scenarios to inform strategic decisions within the energy market.
- Financial Consultants: Offer clients precise valuation assessments for Vistra Corp. (VST) stock.
- Students and Instructors: Utilize real-time data to enhance learning and practice in financial modeling.
- Energy Industry Enthusiasts: Gain insights into how companies like Vistra Corp. (VST) are valued in the energy sector.
What the Template Contains
- Historical Data: Includes Vistra Corp.'s (VST) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Vistra Corp.'s (VST) 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 Vistra Corp.'s (VST) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.