Mercer International Inc. (MERC) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Mercer International Inc. (MERC) Bundle
Designed for accuracy, our (MERC) DCF Calculator empowers you to evaluate Mercer International Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for enhanced projections.
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,624.4 | 1,423.1 | 1,803.3 | 2,280.9 | 1,993.8 | 2,134.5 | 2,285.1 | 2,446.4 | 2,619.0 | 2,803.7 |
| Revenue Growth, % | 0 | -12.39 | 26.71 | 26.49 | -12.59 | 7.06 | 7.06 | 7.06 | 7.06 | 7.06 |
| EBITDA | 210.4 | 192.7 | 478.8 | 561.0 | -9.1 | 329.5 | 352.7 | 377.6 | 404.3 | 432.8 |
| EBITDA, % | 12.95 | 13.54 | 26.55 | 24.59 | -0.45515 | 15.44 | 15.44 | 15.44 | 15.44 | 15.44 |
| Depreciation | 126.4 | 128.9 | 132.2 | 144.2 | 172.5 | 167.1 | 178.9 | 191.5 | 205.0 | 219.5 |
| Depreciation, % | 7.78 | 9.06 | 7.33 | 6.32 | 8.65 | 7.83 | 7.83 | 7.83 | 7.83 | 7.83 |
| EBIT | 84.0 | 63.7 | 346.6 | 416.8 | -181.6 | 162.4 | 173.8 | 186.1 | 199.2 | 213.3 |
| EBIT, % | 5.17 | 4.48 | 19.22 | 18.27 | -9.11 | 7.61 | 7.61 | 7.61 | 7.61 | 7.61 |
| Total Cash | 351.1 | 361.1 | 345.6 | 354.0 | 314.0 | 415.9 | 445.2 | 476.7 | 510.3 | 546.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 208.7 | 227.1 | 345.3 | 352.0 | 306.2 | 336.2 | 359.9 | 385.3 | 412.5 | 441.6 |
| Account Receivables, % | 12.85 | 15.95 | 19.15 | 15.43 | 15.36 | 15.75 | 15.75 | 15.75 | 15.75 | 15.75 |
| Inventories | 272.6 | 271.7 | 356.7 | 450.5 | 414.2 | 410.6 | 439.6 | 470.6 | 503.8 | 539.3 |
| Inventories, % | 16.78 | 19.09 | 19.78 | 19.75 | 20.77 | 19.24 | 19.24 | 19.24 | 19.24 | 19.24 |
| Accounts Payable | 73.7 | 42.7 | 58.5 | 92.8 | 61.1 | 76.5 | 81.9 | 87.7 | 93.8 | 100.5 |
| Accounts Payable, % | 4.54 | 3 | 3.24 | 4.07 | 3.06 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
| Capital Expenditure | -132.7 | -79.2 | -160.8 | -179.2 | -136.3 | -159.4 | -170.7 | -182.7 | -195.6 | -209.4 |
| Capital Expenditure, % | -8.17 | -5.56 | -8.92 | -7.86 | -6.84 | -7.47 | -7.47 | -7.47 | -7.47 | -7.47 |
| Tax Rate, % | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 | 10.29 |
| EBITAT | -84.5 | 98.6 | 227.4 | 298.2 | -162.9 | 106.2 | 113.6 | 121.7 | 130.2 | 139.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -498.3 | 100.0 | 11.2 | 197.1 | -76.3 | 102.8 | 74.6 | 79.8 | 85.5 | 91.5 |
| WACC, % | 2.28 | 6.56 | 5.09 | 5.34 | 6.12 | 5.08 | 5.08 | 5.08 | 5.08 | 5.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 375.7 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 92 | |||||||||
| Terminal Value | 2,008 | |||||||||
| Present Terminal Value | 1,567 | |||||||||
| Enterprise Value | 1,943 | |||||||||
| Net Debt | 1,315 | |||||||||
| Equity Value | 628 | |||||||||
| Diluted Shares Outstanding, MM | 66 | |||||||||
| Equity Value Per Share | 9.46 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real MERC financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Mercer International'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
- Comprehensive Financial Data: Mercer International Inc.’s historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Valuation: Observe Mercer’s intrinsic value update instantly.
- Intuitive Visual Representations: Dashboard graphs illustrate valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool tailored for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Mercer International Inc. (MERC) preloaded data.
- 2. Modify Assumptions: Adjust essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
- 5. Present with Assurance: Share professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Mercer International Inc. (MERC)?
- Accurate Data: Utilize real Mercer International financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from ground zero.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants alike.
- User-Friendly: An intuitive design and guided instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Assess Mercer International Inc.'s (MERC) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation practices of established companies like Mercer International Inc.
- Consultants: Create comprehensive valuation reports for your clients based on Mercer International Inc. (MERC).
- Students and Educators: Utilize real-time data to learn and teach valuation strategies involving Mercer International Inc. (MERC).
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Mercer International Inc. (MERC).
- Real-World Data: Historical and projected financials for Mercer International Inc. (MERC) preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into Mercer International Inc. (MERC).
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to Mercer International Inc. (MERC).
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for decision-making.