Vista Energy, S.A.B. de C.V. (VIST) DCF Valuation

Vista Energy, S.A.B. de C.V. (VIST) 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

Vista Energy, S.A.B. de C.V. (VIST) 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:

Designed for accuracy, our (VIST) DCF Calculator enables you to evaluate the valuation of Vista Energy, S.A.B. de C.V. with up-to-date financial data and complete flexibility to modify all essential parameters for improved 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 416.0 273.9 652.2 1,143.8 1,168.8 1,587.8 2,157.1 2,930.6 3,981.3 5,408.8
Revenue Growth, % 0 -34.15 138.08 75.38 2.18 35.85 35.85 35.85 35.85 35.85
EBITDA 176.8 90.2 403.6 706.1 848.4 862.7 1,172.0 1,592.2 2,163.1 2,938.6
EBITDA, % 42.51 32.94 61.88 61.73 72.59 54.33 54.33 54.33 54.33 54.33
Depreciation 155.5 150.7 194.9 239.4 279.3 530.7 721.0 979.5 1,330.7 1,807.9
Depreciation, % 37.39 55.02 29.88 20.93 23.9 33.42 33.42 33.42 33.42 33.42
EBIT 21.3 -60.5 208.7 466.7 569.1 331.9 451.0 612.7 832.3 1,130.7
EBIT, % 5.12 -22.08 31.99 40.8 48.69 20.91 20.91 20.91 20.91 20.91
Total Cash 247.8 203.3 315.3 245.0 213.3 704.3 956.8 1,299.9 1,766.0 2,399.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 56.5 25.2 27.2 41.2 153.6
Account Receivables, % 13.58 9.21 4.18 3.6 13.14
Inventories 19.1 13.9 14.0 12.9 7.5 43.1 58.5 79.5 108.1 146.8
Inventories, % 4.59 5.06 2.14 1.13 0.64589 2.71 2.71 2.71 2.71 2.71
Accounts Payable 59.3 117.4 119.3 196.5 204.7 349.6 474.9 645.2 876.6 1,190.8
Accounts Payable, % 14.25 42.86 18.29 17.18 17.51 22.02 22.02 22.02 22.02 22.02
Capital Expenditure -244.5 -156.9 -322.9 -485.4 -695.7 -849.6 -1,154.3 -1,568.1 -2,130.3 -2,894.2
Capital Expenditure, % -58.79 -57.28 -49.51 -42.44 -59.53 -53.51 -53.51 -53.51 -53.51 -53.51
Tax Rate, % 27.21 27.21 27.21 27.21 27.21 27.21 27.21 27.21 27.21 27.21
EBITAT 42.3 -55.1 69.2 290.2 414.2 238.4 323.9 440.1 597.9 812.2
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -63.0 33.4 -59.1 108.6 -101.1 43.7 -49.2 -66.8 -90.8 -123.3
WACC, % 5.29 5.24 4.95 5.1 5.15 5.15 5.15 5.15 5.15 5.15
PV UFCF
SUM PV UFCF -230.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) -126
Terminal Value -3,999
Present Terminal Value -3,112
Enterprise Value -3,342
Net Debt 477
Equity Value -3,819
Diluted Shares Outstanding, MM 99
Equity Value Per Share -38.49

What You Will Get

  • Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: Vista Energy’s financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • 🔍 Real-Life VIST Financials: Pre-filled historical and projected data for Vista Energy, S.A.B. de C.V. (VIST).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Vista Energy’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Vista Energy’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 Vista Energy data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Vista Energy’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose Vista Energy (VIST)?

  • Save Time: Quickly access essential energy data without building complex models.
  • Enhance Precision: Utilize accurate metrics and insights to minimize valuation discrepancies.
  • Fully Customizable: Adjust parameters to align with your energy market forecasts and strategies.
  • User-Friendly Interface: Intuitive design and visualizations simplify data interpretation.
  • Endorsed by Industry Leaders: Crafted for professionals who prioritize reliability and efficiency.

Who Should Use This Product?

  • Investors: Assess Vista Energy's valuation before making stock transactions.
  • CFOs and Financial Analysts: Enhance valuation workflows and evaluate financial forecasts.
  • Startup Founders: Understand how large public companies like Vista Energy are appraised.
  • Consultants: Provide comprehensive valuation reports for clients in the energy sector.
  • Students and Educators: Utilize real-world data to learn and teach valuation methodologies.

What the Template Contains

  • Historical Data: Includes Vista Energy's past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Vista Energy's 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 Vista Energy's financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.