Kinross Gold Corporation (KGC) DCF Valuation
- ✓ 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
Kinross Gold Corporation (KGC) Bundle
Looking to determine the intrinsic value of Kinross Gold Corporation? Our KGC DCF Calculator integrates real-world data with comprehensive customization features, allowing you to refine your forecasts and make more informed investment choices.
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 | 3,497.3 | 4,213.4 | 3,729.4 | 3,455.1 | 4,239.7 | 4,497.7 | 4,771.4 | 5,061.8 | 5,369.8 | 5,696.6 |
| Revenue Growth, % | 0 | 20.48 | -11.49 | -7.36 | 22.71 | 6.09 | 6.09 | 6.09 | 6.09 | 6.09 |
| EBITDA | 1,832.7 | 2,730.4 | 854.6 | 945.4 | 1,764.4 | 1,881.0 | 1,995.4 | 2,116.8 | 2,245.7 | 2,382.3 |
| EBITDA, % | 52.4 | 64.8 | 22.92 | 27.36 | 41.62 | 41.82 | 41.82 | 41.82 | 41.82 | 41.82 |
| Depreciation | 767.8 | 911.0 | 700.1 | 777.4 | 986.8 | 972.6 | 1,031.8 | 1,094.6 | 1,161.2 | 1,231.9 |
| Depreciation, % | 21.96 | 21.62 | 18.77 | 22.5 | 23.28 | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 |
| EBIT | 1,064.9 | 1,819.4 | 154.5 | 168.0 | 777.6 | 908.3 | 963.6 | 1,022.2 | 1,084.4 | 1,150.4 |
| EBIT, % | 30.45 | 43.18 | 4.14 | 4.86 | 18.34 | 20.2 | 20.2 | 20.2 | 20.2 | 20.2 |
| Total Cash | 575.1 | 1,210.9 | 531.5 | 418.1 | 366.9 | 721.3 | 765.2 | 811.8 | 861.2 | 913.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6.9 | 8.1 | 89.6 | 99.4 | 106.6 | 73.6 | 78.1 | 82.8 | 87.9 | 93.2 |
| Account Receivables, % | 0.1973 | 0.19224 | 2.4 | 2.88 | 2.51 | 1.64 | 1.64 | 1.64 | 1.64 | 1.64 |
| Inventories | 1,053.8 | 1,072.9 | 1,151.3 | 1,072.2 | 1,153.0 | 1,301.6 | 1,380.8 | 1,464.8 | 1,554.0 | 1,648.5 |
| Inventories, % | 30.13 | 25.46 | 30.87 | 31.03 | 27.2 | 28.94 | 28.94 | 28.94 | 28.94 | 28.94 |
| Accounts Payable | 89.3 | 89.1 | 87.8 | 119.1 | 113.7 | 118.3 | 125.5 | 133.1 | 141.2 | 149.8 |
| Accounts Payable, % | 2.55 | 2.11 | 2.35 | 3.45 | 2.68 | 2.63 | 2.63 | 2.63 | 2.63 | 2.63 |
| Capital Expenditure | -1,105.2 | -964.0 | -989.7 | -807.9 | -1,098.3 | -1,172.2 | -1,243.5 | -1,319.2 | -1,399.4 | -1,484.6 |
| Capital Expenditure, % | -31.6 | -22.88 | -26.54 | -23.38 | -25.91 | -26.06 | -26.06 | -26.06 | -26.06 | -26.06 |
| Tax Rate, % | 41.25 | 41.25 | 41.25 | 41.25 | 41.25 | 41.25 | 41.25 | 41.25 | 41.25 | 41.25 |
| EBITAT | 794.0 | 1,358.0 | 72.8 | -952.7 | 456.8 | 463.4 | 491.6 | 521.5 | 553.2 | 586.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -514.8 | 1,284.5 | -378.0 | -882.6 | 251.9 | 152.9 | 203.4 | 215.8 | 228.9 | 242.9 |
| WACC, % | 9.19 | 9.19 | 8.99 | 8.65 | 9.08 | 9.02 | 9.02 | 9.02 | 9.02 | 9.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 797.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 248 | |||||||||
| Terminal Value | 3,529 | |||||||||
| Present Terminal Value | 2,291 | |||||||||
| Enterprise Value | 3,089 | |||||||||
| Net Debt | 1,908 | |||||||||
| Equity Value | 1,181 | |||||||||
| Diluted Shares Outstanding, MM | 1,237 | |||||||||
| Equity Value Per Share | 0.96 |
What You Will Get
- Real Kinross Gold Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Kinross Gold’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Customizable Mining Metrics: Adjust essential inputs such as gold price forecasts, production costs, and capital investments.
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and additional financial metrics on demand.
- Industry-Leading Precision: Leverages Kinross Gold's actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Evaluate various scenarios and analyze results with ease.
- Efficiency Booster: Streamline your workflow by avoiding the creation of intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Kinross Gold Corporation’s (KGC) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Kinross Gold Corporation’s (KGC) intrinsic value.
- Step 5: Make well-informed investment choices or create reports utilizing the outputs.
Why Choose This Calculator for Kinross Gold Corporation (KGC)?
- Accuracy: Utilizes real Kinross Gold financials for precise data representation.
- Flexibility: Built to allow users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of constructing a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use Kinross Gold Corporation (KGC)?
- Gold Investors: Make informed choices with a reliable resource for gold mining investments.
- Market Analysts: Streamline your research with comprehensive data and insights on KGC's performance.
- Financial Consultants: Easily modify reports and presentations tailored to your clients' needs.
- Mining Enthusiasts: Enhance your knowledge of the gold sector with practical insights and examples.
- Students and Educators: Leverage it as a valuable tool for learning about mining finance and investment strategies.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Kinross Gold Corporation (KGC) 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 such as Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Kinross Gold Corporation (KGC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy result analysis.