Pan American Silver Corp. (PAAS) 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
Pan American Silver Corp. (PAAS) Bundle
Evaluate Pan American Silver Corp.'s financial outlook with expertise! This (PAAS) DCF Calculator comes with pre-filled financials and the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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,350.8 | 1,338.8 | 1,632.8 | 1,494.7 | 2,316.1 | 2,707.3 | 3,164.7 | 3,699.3 | 4,324.1 | 5,054.6 |
Revenue Growth, % | 0 | -0.88447 | 21.96 | -8.45 | 54.95 | 16.89 | 16.89 | 16.89 | 16.89 | 16.89 |
EBITDA | 474.3 | 554.2 | 554.9 | -7.2 | 476.8 | 707.1 | 826.6 | 966.2 | 1,129.4 | 1,320.2 |
EBITDA, % | 35.11 | 41.39 | 33.98 | -0.48054 | 20.59 | 26.12 | 26.12 | 26.12 | 26.12 | 26.12 |
Depreciation | 269.5 | 277.8 | 307.7 | 317.8 | 484.2 | 550.7 | 643.8 | 752.5 | 879.6 | 1,028.2 |
Depreciation, % | 19.95 | 20.75 | 18.85 | 21.26 | 20.91 | 20.34 | 20.34 | 20.34 | 20.34 | 20.34 |
EBIT | 204.8 | 276.4 | 247.2 | -324.9 | -7.4 | 156.4 | 182.8 | 213.7 | 249.8 | 292.0 |
EBIT, % | 15.16 | 20.64 | 15.14 | -21.74 | -0.3195 | 5.78 | 5.78 | 5.78 | 5.78 | 5.78 |
Total Cash | 238.3 | 279.1 | 335.3 | 142.3 | 440.9 | 474.2 | 554.3 | 648.0 | 757.4 | 885.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 186.0 | 149.8 | 148.4 | 176.6 | 200.9 | 295.3 | 345.2 | 403.5 | 471.6 | 551.3 |
Account Receivables, % | 13.77 | 11.19 | 9.09 | 11.81 | 8.67 | 10.91 | 10.91 | 10.91 | 10.91 | 10.91 |
Inventories | 346.5 | 406.2 | 500.5 | 471.6 | 711.6 | 806.4 | 942.6 | 1,101.8 | 1,287.9 | 1,505.5 |
Inventories, % | 25.65 | 30.34 | 30.65 | 31.55 | 30.72 | 29.78 | 29.78 | 29.78 | 29.78 | 29.78 |
Accounts Payable | 66.9 | 80.3 | 77.5 | 88.8 | 198.2 | 163.5 | 191.1 | 223.4 | 261.1 | 305.2 |
Accounts Payable, % | 4.95 | 6 | 4.74 | 5.94 | 8.56 | 6.04 | 6.04 | 6.04 | 6.04 | 6.04 |
Capital Expenditure | -207.4 | -178.6 | -243.5 | -274.7 | -379.0 | -424.2 | -495.8 | -579.6 | -677.5 | -792.0 |
Capital Expenditure, % | -15.35 | -13.34 | -14.91 | -18.38 | -16.36 | -15.67 | -15.67 | -15.67 | -15.67 | -15.67 |
Tax Rate, % | -76.36 | -76.36 | -76.36 | -76.36 | -76.36 | -76.36 | -76.36 | -76.36 | -76.36 | -76.36 |
EBITAT | 124.2 | 195.1 | 98.3 | -367.2 | -13.1 | 116.0 | 135.6 | 158.6 | 185.3 | 216.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -279.2 | 284.2 | 66.8 | -312.1 | -62.7 | 18.7 | 125.1 | 146.2 | 170.9 | 199.8 |
WACC, % | 10.39 | 10.47 | 10.23 | 10.7 | 10.7 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 |
PV UFCF | ||||||||||
SUM PV UFCF | 463.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 204 | |||||||||
Terminal Value | 2,399 | |||||||||
Present Terminal Value | 1,456 | |||||||||
Enterprise Value | 1,920 | |||||||||
Net Debt | 402 | |||||||||
Equity Value | 1,518 | |||||||||
Diluted Shares Outstanding, MM | 327 | |||||||||
Equity Value Per Share | 4.65 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real PAAS financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on Pan American Silver Corp.'s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life PAAS Financials: Pre-filled historical and projected data for Pan American Silver Corp.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Pan American Silver’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Pan American Silver’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing Pan American Silver Corp.'s (PAAS) financial data.
- 2. Adjust Key Inputs: Modify essential parameters such as production forecasts, operating costs, and metal prices.
- 3. Analyze Results in Real-Time: The DCF model automatically computes the intrinsic value and NPV based on your inputs.
- 4. Explore Different Scenarios: Evaluate various projections to understand a range of valuation possibilities.
- 5. Present with Assurance: Deliver expert valuation analyses to bolster your investment strategies.
Why Choose This Calculator for Pan American Silver Corp. (PAAS)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and mining consultants.
- Comprehensive Data: Pan American Silver’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Pan American Silver Corp. (PAAS) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Pan American Silver Corp. (PAAS).
- Consultants: Deliver professional valuation insights on Pan American Silver Corp. (PAAS) to clients quickly and accurately.
- Business Owners: Understand how mining companies like Pan American Silver Corp. (PAAS) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data from Pan American Silver Corp. (PAAS) and similar companies.
What the Template Contains
- Pre-Filled DCF Model: Pan American Silver Corp.’s (PAAS) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Pan American Silver Corp.’s (PAAS) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.