VAALCO Energy, Inc. (EGY) DCF Valuation

VAALCO Energy, Inc. (EGY) 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

VAALCO Energy, Inc. (EGY) 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:

Optimize your time and improve precision with our (EGY) DCF Calculator! Powered by real VAALCO Energy data and customizable assumptions, this tool enables you to forecast, analyze, and appraise VAALCO Energy, Inc. like an expert investor.


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
Account Receivables, % 21.97 11.79 16.47 14.72 9.86
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).

No products were found matching.