Vistra Corp. (VST) DCF Valuation

Vistra Corp. (VST) DCF Valuation
  • Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • Predeterminadas Para Un Uso Rápido Y Eficiente
  • No Se Necesita Experiencia; Fáciles De Seguir

Vistra Corp. (VST) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 11.56 11.18 16.2 15.2 11.37
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

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Vistra Corp. (VST) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Vistra Corp.'s (VST) intrinsic value.
  5. 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.