B2Gold Corp. (BTG) 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
B2Gold Corp. (BTG) Bundle
Whether you’re an investor or analyst, this (BTG) DCF Calculator is your go-to tool for accurate valuation. With real data from B2Gold Corp. preloaded, you can easily adjust forecasts and observe the effects in real time.
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,155.6 | 1,788.9 | 1,762.3 | 1,732.6 | 1,934.3 | 2,240.2 | 2,594.5 | 3,004.9 | 3,480.2 | 4,030.6 |
Revenue Growth, % | 0 | 54.8 | -1.49 | -1.68 | 11.64 | 15.82 | 15.82 | 15.82 | 15.82 | 15.82 |
EBITDA | 776.8 | 1,399.8 | 1,081.9 | 925.3 | 729.9 | 1,335.2 | 1,546.3 | 1,790.9 | 2,074.2 | 2,402.2 |
EBITDA, % | 67.22 | 78.25 | 61.39 | 53.41 | 37.74 | 59.6 | 59.6 | 59.6 | 59.6 | 59.6 |
Depreciation | 257.1 | 317.4 | 375.6 | 368.6 | 402.4 | 463.2 | 536.5 | 621.3 | 719.6 | 833.4 |
Depreciation, % | 22.25 | 17.74 | 21.31 | 21.28 | 20.8 | 20.68 | 20.68 | 20.68 | 20.68 | 20.68 |
EBIT | 519.6 | 1,082.4 | 706.3 | 556.7 | 327.5 | 871.9 | 1,009.9 | 1,169.6 | 1,354.6 | 1,568.8 |
EBIT, % | 44.96 | 60.5 | 40.08 | 32.13 | 16.93 | 38.92 | 38.92 | 38.92 | 38.92 | 38.92 |
Total Cash | 140.6 | 479.7 | 673.0 | 651.9 | 306.9 | 585.4 | 678.0 | 785.3 | 909.5 | 1,053.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | -13.8 | .0 | 42.3 | .0 | 48.5 | 16.6 | 19.3 | 22.3 | 25.8 | 29.9 |
Account Receivables, % | -1.19 | 0 | 2.4 | 0 | 2.5 | 0.74272 | 0.74272 | 0.74272 | 0.74272 | 0.74272 |
Inventories | 217.9 | 238.1 | 272.4 | 332.0 | 346.5 | 379.5 | 439.5 | 509.0 | 589.5 | 682.8 |
Inventories, % | 18.86 | 13.31 | 15.45 | 19.16 | 17.91 | 16.94 | 16.94 | 16.94 | 16.94 | 16.94 |
Accounts Payable | 83.4 | 89.1 | 111.7 | 114.8 | 167.1 | 151.4 | 175.4 | 203.1 | 235.2 | 272.4 |
Accounts Payable, % | 7.21 | 4.98 | 6.34 | 6.63 | 8.64 | 6.76 | 6.76 | 6.76 | 6.76 | 6.76 |
Capital Expenditure | -261.2 | -352.6 | -302.3 | -390.3 | -824.9 | -558.4 | -646.7 | -749.0 | -867.5 | -1,004.7 |
Capital Expenditure, % | -22.6 | -19.71 | -17.16 | -22.53 | -42.64 | -24.93 | -24.93 | -24.93 | -24.93 | -24.93 |
Tax Rate, % | 96.85 | 96.85 | 96.85 | 96.85 | 96.85 | 96.85 | 96.85 | 96.85 | 96.85 | 96.85 |
EBITAT | 316.0 | 657.2 | 408.6 | 265.3 | 10.3 | 401.4 | 464.9 | 538.4 | 623.6 | 722.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 191.2 | 593.8 | 427.9 | 229.3 | -422.8 | 289.3 | 315.9 | 365.9 | 423.8 | 490.8 |
WACC, % | 9.98 | 9.98 | 9.97 | 9.93 | 9.74 | 9.92 | 9.92 | 9.92 | 9.92 | 9.92 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,396.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 501 | |||||||||
Terminal Value | 6,320 | |||||||||
Present Terminal Value | 3,939 | |||||||||
Enterprise Value | 5,335 | |||||||||
Net Debt | -126 | |||||||||
Equity Value | 5,461 | |||||||||
Diluted Shares Outstanding, MM | 1,237 | |||||||||
Equity Value Per Share | 4.41 |
What You Will Get
- Real B2Gold Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for B2Gold Corp. (BTG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to B2Gold Corp. (BTG).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on B2Gold Corp.'s (BTG) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections related to B2Gold Corp. (BTG).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for B2Gold Corp. (BTG).
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as gold production forecasts, operating costs, and capital investment.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional metrics.
- Industry-Leading Precision: Leverages B2Gold's actual financial data for accurate valuation results.
- Streamlined Scenario Analysis: Effortlessly evaluate various scenarios and analyze their implications.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download: Access the ready-to-use Excel file with B2Gold Corp.'s (BTG) financial data.
- Customize: Adjust forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations update in real-time.
- Test Scenarios: Create multiple projections and compare outcomes instantly.
- Make Decisions: Use the valuation results to guide your investment strategy.
Why Choose This Calculator for B2Gold Corp. (BTG)?
- Accuracy: Utilizes real B2Gold financial data to ensure precise calculations.
- Flexibility: Allows users to adjust and test various inputs with ease.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users lacking advanced financial modeling skills.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling B2Gold Corp. (BTG) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for B2Gold Corp. (BTG).
- Consultants: Deliver professional valuation insights on B2Gold Corp. (BTG) to clients quickly and accurately.
- Business Owners: Understand how mining companies like B2Gold Corp. (BTG) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to B2Gold Corp. (BTG).
What the Template Contains
- Preloaded BTG Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.