Southern Copper Corporation (SCCO) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Southern Copper Corporation (SCCO) Bundle
Discover the true potential of Southern Copper Corporation (SCCO) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different changes affect Southern Copper Corporation (SCCO) valuation – all within a single Excel template.
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 | 7,285.6 | 7,984.9 | 10,934.1 | 10,047.9 | 9,895.8 | 10,809.0 | 11,806.6 | 12,896.2 | 14,086.3 | 15,386.3 |
| Revenue Growth, % | 0 | 9.6 | 36.93 | -8.1 | -1.51 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 |
| EBITDA | 3,531.6 | 3,888.0 | 6,859.9 | 5,232.1 | 5,116.1 | 5,700.2 | 6,226.2 | 6,800.8 | 7,428.4 | 8,114.0 |
| EBITDA, % | 48.47 | 48.69 | 62.74 | 52.07 | 51.7 | 52.74 | 52.74 | 52.74 | 52.74 | 52.74 |
| Depreciation | 764.4 | 775.6 | 806.0 | 796.3 | 833.6 | 949.6 | 1,037.2 | 1,132.9 | 1,237.5 | 1,351.7 |
| Depreciation, % | 10.49 | 9.71 | 7.37 | 7.93 | 8.42 | 8.79 | 8.79 | 8.79 | 8.79 | 8.79 |
| EBIT | 2,767.2 | 3,112.4 | 6,053.9 | 4,435.8 | 4,282.5 | 4,750.6 | 5,189.0 | 5,667.9 | 6,190.9 | 6,762.3 |
| EBIT, % | 37.98 | 38.98 | 55.37 | 44.15 | 43.28 | 43.95 | 43.95 | 43.95 | 43.95 | 43.95 |
| Total Cash | 2,005.8 | 2,594.4 | 3,488.9 | 2,278.0 | 1,750.8 | 2,860.0 | 3,123.9 | 3,412.2 | 3,727.1 | 4,071.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 911.8 | 1,136.6 | 1,446.6 | 1,473.8 | 1,228.3 | 1,449.7 | 1,583.5 | 1,729.6 | 1,889.2 | 2,063.6 |
| Account Receivables, % | 12.52 | 14.23 | 13.23 | 14.67 | 12.41 | 13.41 | 13.41 | 13.41 | 13.41 | 13.41 |
| Inventories | 1,068.5 | 950.2 | 972.9 | 1,013.9 | 1,016.9 | 1,206.9 | 1,318.3 | 1,440.0 | 1,572.9 | 1,718.0 |
| Inventories, % | 14.67 | 11.9 | 8.9 | 10.09 | 10.28 | 11.17 | 11.17 | 11.17 | 11.17 | 11.17 |
| Accounts Payable | 598.3 | 594.6 | 591.9 | 657.6 | 652.6 | 739.6 | 807.8 | 882.4 | 963.8 | 1,052.8 |
| Accounts Payable, % | 8.21 | 7.45 | 5.41 | 6.54 | 6.59 | 6.84 | 6.84 | 6.84 | 6.84 | 6.84 |
| Capital Expenditure | -707.5 | -592.2 | -892.3 | -948.5 | -1,008.6 | -971.1 | -1,060.7 | -1,158.6 | -1,265.5 | -1,382.3 |
| Capital Expenditure, % | -9.71 | -7.42 | -8.16 | -9.44 | -10.19 | -8.98 | -8.98 | -8.98 | -8.98 | -8.98 |
| Tax Rate, % | 38.69 | 38.69 | 38.69 | 38.69 | 38.69 | 38.69 | 38.69 | 38.69 | 38.69 | 38.69 |
| EBITAT | 1,694.4 | 1,780.1 | 3,610.0 | 2,744.9 | 2,625.5 | 2,862.2 | 3,126.3 | 3,414.8 | 3,730.0 | 4,074.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 369.3 | 1,853.3 | 3,188.3 | 2,590.2 | 2,688.0 | 2,516.2 | 2,925.9 | 3,195.9 | 3,490.9 | 3,813.0 |
| WACC, % | 9.43 | 9.41 | 9.42 | 9.43 | 9.43 | 9.42 | 9.42 | 9.42 | 9.42 | 9.42 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 12,048.6 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 3,946 | |||||||||
| Terminal Value | 66,646 | |||||||||
| Present Terminal Value | 42,487 | |||||||||
| Enterprise Value | 54,536 | |||||||||
| Net Debt | 5,879 | |||||||||
| Equity Value | 48,657 | |||||||||
| Diluted Shares Outstanding, MM | 786 | |||||||||
| Equity Value Per Share | 61.94 |
What You Will Get
- Real SCCO Financial Data: Pre-filled with Southern Copper Corporation’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Southern Copper Corporation’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life SCCO Financials: Pre-filled historical and projected data for Southern Copper Corporation (SCCO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Southern Copper's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Southern Copper's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring Southern Copper Corporation’s (SCCO) 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 observe recalculated results, including Southern Copper Corporation’s intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Southern Copper Corporation (SCCO)?
- Accuracy: Utilizes real Southern Copper Corporation financials for precise data.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Eliminates the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and precision expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling knowledge.
Who Should Use This Product?
- Investors: Accurately assess Southern Copper Corporation’s (SCCO) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Southern Copper Corporation (SCCO).
- Consultants: Efficiently customize the template for valuation reports tailored to clients in the mining sector.
- Entrepreneurs: Acquire knowledge about financial modeling practices employed by leading mining firms.
- Educators: Implement it as a teaching resource to illustrate valuation techniques in the mining industry.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Southern Copper Corporation (SCCO).
- Real-World Data: Southern Copper’s historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.