Matthews International Corporation (MATW) 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
Matthews International Corporation (MATW) Bundle
Gain insight into your Matthews International Corporation (MATW) valuation analysis with our sophisticated DCF Calculator! Preloaded with real MATW data, this Excel template enables you to adjust forecasts and assumptions to accurately calculate the intrinsic value of Matthews International Corporation (MATW).
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 1,498.3 | 1,671.0 | 1,762.4 | 1,880.9 | 1,795.7 | 1,881.9 | 1,972.2 | 2,066.8 | 2,166.0 | 2,269.9 |
| Revenue Growth, % | 0 | 11.53 | 5.47 | 6.72 | -4.53 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 |
| EBITDA | 46.1 | 169.7 | 24.4 | 195.2 | 75.6 | 109.9 | 115.2 | 120.7 | 126.5 | 132.6 |
| EBITDA, % | 3.08 | 10.16 | 1.39 | 10.38 | 4.21 | 5.84 | 5.84 | 5.84 | 5.84 | 5.84 |
| Depreciation | 119.1 | 133.5 | 104.1 | 96.5 | 94.8 | 121.4 | 127.2 | 133.3 | 139.7 | 146.4 |
| Depreciation, % | 7.95 | 7.99 | 5.9 | 5.13 | 5.28 | 6.45 | 6.45 | 6.45 | 6.45 | 6.45 |
| EBIT | -73.0 | 36.2 | -79.6 | 98.7 | -19.1 | -11.4 | -12.0 | -12.6 | -13.2 | -13.8 |
| EBIT, % | -4.87 | 2.17 | -4.52 | 5.25 | -1.06 | -0.60806 | -0.60806 | -0.60806 | -0.60806 | -0.60806 |
| Total Cash | 41.3 | 49.2 | 69.0 | 42.1 | 40.8 | 53.2 | 55.7 | 58.4 | 61.2 | 64.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 295.2 | 309.8 | 221.0 | 282.2 | 299.0 | 310.3 | 325.1 | 340.7 | 357.1 | 374.2 |
| Account Receivables, % | 19.7 | 18.54 | 12.54 | 15 | 16.65 | 16.49 | 16.49 | 16.49 | 16.49 | 16.49 |
| Inventories | 175.1 | 189.1 | 225.4 | 260.4 | 237.9 | 236.7 | 248.0 | 259.9 | 272.4 | 285.5 |
| Inventories, % | 11.69 | 11.32 | 12.79 | 13.84 | 13.25 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 |
| Accounts Payable | 82.9 | 112.7 | 121.4 | 114.3 | 108.4 | 117.7 | 123.4 | 129.3 | 135.5 | 142.0 |
| Accounts Payable, % | 5.53 | 6.75 | 6.89 | 6.08 | 6.03 | 6.26 | 6.26 | 6.26 | 6.26 | 6.26 |
| Capital Expenditure | -34.8 | -34.3 | -61.3 | -50.6 | -45.2 | -49.2 | -51.5 | -54.0 | -56.6 | -59.3 |
| Capital Expenditure, % | -2.33 | -2.05 | -3.48 | -2.69 | -2.52 | -2.61 | -2.61 | -2.61 | -2.61 | -2.61 |
| Tax Rate, % | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 | 14.35 |
| EBITAT | -60.1 | 11.4 | -76.3 | 94.8 | -16.4 | -9.0 | -9.4 | -9.8 | -10.3 | -10.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -363.3 | 111.8 | 27.6 | 37.5 | 33.0 | 62.5 | 45.7 | 47.9 | 50.2 | 52.6 |
| WACC, % | 7.21 | 5.69 | 7.61 | 7.62 | 7.31 | 7.09 | 7.09 | 7.09 | 7.09 | 7.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 212.7 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 54 | |||||||||
| Terminal Value | 1,325 | |||||||||
| Present Terminal Value | 941 | |||||||||
| Enterprise Value | 1,154 | |||||||||
| Net Debt | 798 | |||||||||
| Equity Value | 355 | |||||||||
| Diluted Shares Outstanding, MM | 31 | |||||||||
| Equity Value Per Share | 11.49 |
What You Will Receive
- Comprehensive Financial Model: Utilizes Matthews International Corporation's (MATW) actual data for accurate DCF valuation.
- Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential variables.
- Real-Time Calculations: Instant updates ensure you see the impact of adjustments immediately.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, enabling ongoing use for in-depth forecasting.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Matthews International Corporation (MATW).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with customizable inputs for precise calculations.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to reflect your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Matthews International Corporation (MATW).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the ready-to-use Excel file featuring Matthews International Corporation's (MATW) financial data.
- Customize: Tailor forecasts, including revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Matthews International Corporation (MATW)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Insights: Observe immediate updates to Matthews International's valuation with input changes.
- Preloaded Data: Comes equipped with Matthews International's actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by analysts and investors for making well-informed choices.
Who Should Use Matthews International Corporation (MATW) Products?
- Investors: Gain insights and make informed decisions with our comprehensive valuation tools.
- Financial Analysts: Enhance your efficiency with our customizable DCF model designed for quick analysis.
- Consultants: Effortlessly modify our templates for impactful client presentations and reports.
- Finance Enthusiasts: Explore valuation techniques through practical, real-world examples provided by our resources.
- Educators and Students: Utilize our tools as a hands-on learning resource in finance and investment courses.
What the Template Contains
- Pre-Filled DCF Model: Matthews International Corporation’s (MATW) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Matthews International Corporation’s 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.