|
Vista Energy, S.A.B. de C.V. (VIST) DCF Valuation
MX | Energy | Oil & Gas Exploration & Production | NYSE
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Vista Energy, S.A.B. de C.V. (VIST) Bundle
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 | 138.8 | 188.6 | 256.2 | 348.0 | 472.8 |
Account Receivables, % | 13.58 | 9.21 | 4.18 | 3.6 | 13.14 | 8.74 | 8.74 | 8.74 | 8.74 | 8.74 |
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
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Vista Energy data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Vista Energy’s intrinsic value.
- 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.