Vermilion Energy Inc. (VET) 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
Vermilion Energy Inc. (VET) Bundle
Whether you're an investor or an analyst, this [VET] DCF Calculator is the perfect tool for accurate valuation. Equipped with real data from Vermilion Energy Inc., you can adjust forecasts and instantly observe the effects.
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 | 1,326.6 | 865.9 | 1,545.7 | 2,583.0 | 1,526.8 | 1,794.0 | 2,108.0 | 2,476.9 | 2,910.4 | 3,419.7 |
| Revenue Growth, % | 0 | -34.73 | 78.52 | 67.11 | -40.89 | 17.5 | 17.5 | 17.5 | 17.5 | 17.5 |
| EBITDA | 636.7 | 272.3 | 893.3 | 1,703.0 | 360.6 | 813.7 | 956.1 | 1,123.4 | 1,320.0 | 1,551.0 |
| EBITDA, % | 48 | 31.44 | 57.79 | 65.93 | 23.62 | 45.36 | 45.36 | 45.36 | 45.36 | 45.36 |
| Depreciation | 491.3 | 427.4 | 427.1 | 441.0 | 494.7 | 586.6 | 689.3 | 809.9 | 951.7 | 1,118.3 |
| Depreciation, % | 37.04 | 49.37 | 27.63 | 17.07 | 32.4 | 32.7 | 32.7 | 32.7 | 32.7 | 32.7 |
| EBIT | 145.4 | -155.2 | 466.2 | 1,262.0 | -134.0 | 227.0 | 266.8 | 313.5 | 368.3 | 432.8 |
| EBIT, % | 10.96 | -17.92 | 30.16 | 48.86 | -8.78 | 12.66 | 12.66 | 12.66 | 12.66 | 12.66 |
| Total Cash | 20.1 | 4.8 | 4.2 | 9.6 | 98.2 | 32.8 | 38.6 | 45.3 | 53.2 | 62.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 146.7 | 136.1 | 228.1 | 259.4 | 168.6 | 224.7 | 264.0 | 310.2 | 364.5 | 428.3 |
| Account Receivables, % | 11.06 | 15.72 | 14.76 | 10.04 | 11.04 | 12.52 | 12.52 | 12.52 | 12.52 | 12.52 |
| Inventories | 20.4 | 9.3 | 13.9 | 13.6 | 39.8 | 23.9 | 28.0 | 32.9 | 38.7 | 45.5 |
| Inventories, % | 1.54 | 1.07 | 0.90127 | 0.52824 | 2.61 | 1.33 | 1.33 | 1.33 | 1.33 | 1.33 |
| Accounts Payable | 171.7 | 187.6 | 269.6 | 74.4 | 249.4 | 255.7 | 300.5 | 353.1 | 414.8 | 487.4 |
| Accounts Payable, % | 12.95 | 21.67 | 17.44 | 2.88 | 16.34 | 14.25 | 14.25 | 14.25 | 14.25 | 14.25 |
| Capital Expenditure | -363.1 | -254.9 | -260.2 | -383.0 | -409.7 | -413.7 | -486.1 | -571.2 | -671.2 | -788.6 |
| Capital Expenditure, % | -27.37 | -29.44 | -16.83 | -14.83 | -26.83 | -23.06 | -23.06 | -23.06 | -23.06 | -23.06 |
| Tax Rate, % | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 | 14.62 |
| EBITAT | 33.8 | -125.4 | 387.5 | 807.9 | -114.4 | 152.8 | 179.6 | 211.0 | 247.9 | 291.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 166.6 | 84.7 | 539.9 | 639.6 | 210.1 | 292.0 | 384.0 | 451.2 | 530.2 | 623.0 |
| WACC, % | 12.11 | 13.71 | 13.78 | 13.24 | 13.84 | 13.34 | 13.34 | 13.34 | 13.34 | 13.34 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,521.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 635 | |||||||||
| Terminal Value | 5,605 | |||||||||
| Present Terminal Value | 2,997 | |||||||||
| Enterprise Value | 4,519 | |||||||||
| Net Debt | 559 | |||||||||
| Equity Value | 3,959 | |||||||||
| Diluted Shares Outstanding, MM | 164 | |||||||||
| Equity Value Per Share | 24.18 |
What You Will Receive
- Comprehensive Financial Model: Vermilion Energy Inc.’s actual data allows for accurate DCF valuation.
- Complete Forecasting Flexibility: Modify production growth, operating margins, discount rates, and other essential factors.
- Real-Time Calculations: Instant updates ensure you view results as adjustments are made.
- Professional-Grade Template: An expertly crafted Excel file intended for high-quality valuation.
- Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for Vermilion Energy Inc. (VET).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital tool with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Vermilion Energy Inc. (VET).
- Visual Dashboard and Charts: Graphical representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Vermilion Energy Inc. (VET) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Vermilion Energy Inc. (VET)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Vermilion Energy Inc. (VET)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses tailored for Vermilion Energy Inc. (VET).
- Customizable Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- Detailed Insights: Automatically computes Vermilion Energy Inc.'s (VET) intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on Vermilion Energy Inc. (VET).
Who Should Use This Product?
- Investors: Evaluate Vermilion Energy Inc.'s (VET) market position before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation workflows and assess financial forecasts for (VET).
- Startup Founders: Understand the valuation methods applied to established companies like Vermilion Energy Inc. (VET).
- Consultants: Provide detailed valuation analyses and reports for clients interested in (VET).
- Students and Educators: Utilize real-time data to practice and instruct on valuation strategies related to (VET).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Vermilion Energy Inc. (VET) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Vermilion Energy Inc. (VET).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.