|
Vaalco Energy, Inc. (Egy) Valoración de DCF
US | Energy | Oil & Gas Exploration & Production | NYSE
|
- ✓ 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
VAALCO Energy, Inc. (EGY) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (egy)! Impulsada por datos de energía de Vaalco reales y supuestos personalizables, esta herramienta le permite pronosticar, analizar y evaluar Vaalco Energy, Inc. como un inversor experto.
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 | 84.5 | 67.2 | 199.1 | 354.3 | 455.1 | 415.3 | 379.0 | 345.9 | 315.7 | 288.1 |
Revenue Growth, % | 0 | -20.52 | 196.35 | 77.99 | 28.43 | -8.74 | -8.74 | -8.74 | -8.74 | -8.74 |
EBITDA | 28.1 | 14.1 | 77.3 | 183.4 | 274.2 | 170.4 | 155.5 | 141.9 | 129.5 | 118.2 |
EBITDA, % | 33.28 | 20.97 | 38.85 | 51.76 | 60.25 | 41.02 | 41.02 | 41.02 | 41.02 | 41.02 |
Depreciation | 7.1 | 9.4 | 21.1 | 48.1 | 115.3 | 59.7 | 54.5 | 49.7 | 45.4 | 41.4 |
Depreciation, % | 8.38 | 13.97 | 10.58 | 13.59 | 25.34 | 14.37 | 14.37 | 14.37 | 14.37 | 14.37 |
EBIT | 21.0 | 4.7 | 56.3 | 135.3 | 158.9 | 110.7 | 101.0 | 92.2 | 84.1 | 76.8 |
EBIT, % | 24.9 | 7.01 | 28.27 | 38.18 | 34.92 | 26.65 | 26.65 | 26.65 | 26.65 | 26.65 |
Total Cash | 45.9 | 47.9 | 48.7 | 37.2 | 121.0 | 155.4 | 141.8 | 129.4 | 118.1 | 107.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 18.6 | 7.9 | 32.8 | 52.1 | 44.9 | 62.1 | 56.7 | 51.8 | 47.2 | 43.1 |
Account Receivables, % | 21.97 | 11.79 | 16.47 | 14.72 | 9.86 | 14.96 | 14.96 | 14.96 | 14.96 | 14.96 |
Inventories | 1.1 | 3.9 | 1.6 | 3.3 | 1.9 | 7.7 | 7.0 | 6.4 | 5.8 | 5.3 |
Inventories, % | 1.27 | 5.81 | 0.8002 | 0.94122 | 0.42807 | 1.85 | 1.85 | 1.85 | 1.85 | 1.85 |
Accounts Payable | 15.9 | 16.7 | 18.8 | 59.9 | 22.2 | 62.2 | 56.8 | 51.8 | 47.3 | 43.1 |
Accounts Payable, % | 18.81 | 24.85 | 9.44 | 16.9 | 4.87 | 14.97 | 14.97 | 14.97 | 14.97 | 14.97 |
Capital Expenditure | -10.3 | -24.3 | -39.1 | -159.9 | -97.2 | -111.8 | -102.0 | -93.1 | -85.0 | -77.5 |
Capital Expenditure, % | -12.24 | -36.22 | -19.62 | -45.13 | -21.36 | -26.91 | -26.91 | -26.91 | -26.91 | -26.91 |
Tax Rate, % | 59.8 | 59.8 | 59.8 | 59.8 | 59.8 | 59.8 | 59.8 | 59.8 | 59.8 | 59.8 |
EBITAT | -2.8 | 11.1 | 77.0 | 56.9 | 63.9 | 62.5 | 57.0 | 52.0 | 47.5 | 43.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -9.9 | 4.8 | 38.6 | -34.9 | 52.9 | 27.4 | 10.1 | 9.3 | 8.5 | 7.7 |
WACC, % | 8.37 | 9.56 | 9.56 | 8.87 | 8.85 | 9.04 | 9.04 | 9.04 | 9.04 | 9.04 |
PV UFCF | ||||||||||
SUM PV UFCF | 51.8 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 8 | |||||||||
Terminal Value | 91 | |||||||||
Present Terminal Value | 59 | |||||||||
Enterprise Value | 111 | |||||||||
Net Debt | -30 | |||||||||
Equity Value | 141 | |||||||||
Diluted Shares Outstanding, MM | 107 | |||||||||
Equity Value Per Share | 1.32 |
What You Will Get
- Pre-Filled Financial Model: VAALCO Energy’s actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify production rates, pricing assumptions, and other essential variables.
- Instant Calculations: Real-time updates provide immediate feedback as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated application for comprehensive forecasts.
Key Features
- Customizable Production Assumptions: Adjust essential metrics such as oil production rates, operating costs, and capital investments.
- Instant DCF Valuation: Computes intrinsic value, NPV, and other financial metrics in real-time.
- Industry-Leading Precision: Leverages VAALCO's actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Evaluate various scenarios and analyze outcomes with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring VAALCO Energy's (EGY) data.
- Step 2: Navigate through the pre-filled sheets and familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly observe recalculated results, including VAALCO Energy's (EGY) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for VAALCO Energy, Inc. (EGY)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to suit your specific analysis needs.
- Real-Time Valuation: Monitor immediate changes to VAALCO's valuation as you tweak inputs.
- Preloaded Data: Comes with VAALCO’s actual financial metrics for efficient evaluation.
- Widely Recognized: Endorsed by investors and analysts for making well-informed choices.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios related to VAALCO Energy, Inc. (EGY).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the energy sector.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in VAALCO Energy, Inc. (EGY).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling focused on energy companies.
- Energy Sector Enthusiasts: Gain insights into how companies like VAALCO Energy, Inc. (EGY) are valued in the marketplace.
What the Template Contains
- Pre-Filled DCF Model: VAALCO Energy, Inc.'s (EGY) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital specific to VAALCO Energy, Inc. (EGY).
- Financial Ratios: Evaluate VAALCO Energy, Inc.'s (EGY) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for VAALCO Energy, Inc. (EGY).
- Financial Statements: Annual and quarterly reports to support detailed analysis of VAALCO Energy, Inc. (EGY).
- Interactive Dashboard: Easily visualize key valuation metrics and results for VAALCO Energy, Inc. (EGY).