| ← Back to Cover | |||||||||
| KEY ASSUMPTIONS & INPUTS | |||||||||
| Blue values are editable inputs | |||||||||
| REVENUE & GROWTH | |||||||||
| Period | FY2023A | FY2024A | FY2025A | FY2026E | FY2027E | FY2028E | FY2029E | FY2030E | |
| Revenue ($mm) | 4,200.0 | 4,550.0 | 4,900.0 | 5,292.0 | 5,688.9 | 6,058.7 | 6,391.9 | 6,711.5 | |
| Revenue Growth (%) | 8.3% | 7.7% | 8.0% | 7.5% | 6.5% | 5.5% | 5.0% | ||
| MARGIN ASSUMPTIONS | |||||||||
| COGS (% of Revenue) | 58.0% | 57.5% | 57.0% | 56.5% | 56.0% | 55.5% | 55.0% | 54.5% | |
| Gross Margin (%) | 42.0% | 42.5% | 43.0% | 43.5% | 44.0% | 44.5% | 45.0% | 45.5% | |
| SG&A (% of Revenue) | 15.0% | 14.8% | 14.5% | 14.3% | 14.0% | 13.8% | 13.5% | 13.3% | |
| R&D (% of Revenue) | 5.0% | 5.0% | 5.0% | 4.8% | 4.7% | 4.6% | 4.5% | 4.4% | |
| Other OpEx (% of Revenue) | 2.0% | 2.0% | 2.0% | 1.9% | 1.8% | 1.8% | 1.7% | 1.7% | |
| EBITDA Margin (%) | 20.0% | 20.7% | 21.5% | 22.5% | 23.5% | 24.3% | 25.3% | 26.1% | |
| D&A AND CAPEX | |||||||||
| D&A (% of Revenue) | 4.0% | 4.0% | 4.0% | 4.0% | 3.9% | 3.9% | 3.8% | 3.8% | |
| Capex (% of Revenue) | 5.0% | 5.0% | 4.8% | 4.7% | 4.6% | 4.5% | 4.4% | 4.3% | |
| WORKING CAPITAL | |||||||||
| Days Sales Outstanding (DSO) | 45 | 44 | 43 | 42 | 41 | 40 | 40 | 39 | |
| Days Inventory Outstanding (DIO) | 60 | 58 | 57 | 56 | 55 | 54 | 53 | 52 | |
| Days Payable Outstanding (DPO) | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | |
| TAX & INTEREST | |||||||||
| Tax Rate (%) | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | 25.0% | |
| Interest Rate (%) | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | 5.0% | |
| Other Income ($mm) | 15.0 | 16.0 | 18.0 | 20.0 | 22.0 | 24.0 | 26.0 | 28.0 | |
| WACC INPUTS | |||||||||
| Risk-Free Rate | 4.20% | ||||||||
| Equity Risk Premium | 5.50% | ||||||||
| Levered Beta | 1.15 | ||||||||
| Size Premium | 1.00% | ||||||||
| Company-Specific Risk | 0.50% | ||||||||
| Cost of Equity (Ke) | 12.03% | ||||||||
| Pre-Tax Cost of Debt | 5.50% | ||||||||
| Marginal Tax Rate | 25.00% | ||||||||
| After-Tax Cost of Debt | 4.13% | ||||||||
| Equity Weight | 87.50% | ||||||||
| Debt Weight | 12.50% | ||||||||
| WACC | 11.04% | ||||||||
| TERMINAL VALUE ASSUMPTIONS | |||||||||
| Terminal Growth Rate (g) | 2.5% | ||||||||
| Exit EV/EBITDA Multiple | 12.0x | ||||||||
| SHARE & ENTERPRISE DATA | |||||||||
| Shares Outstanding (mm) | 250.0 | ||||||||
| Current Share Price ($) | $42.00 | ||||||||
| Market Cap ($mm) | 10,500.0 | ||||||||
| Total Debt ($mm) | 1,500.0 | ||||||||
| Cash & Equivalents ($mm) | 350.0 | ||||||||
| Enterprise Value ($mm) | 11,650.0 | ||||||||
| DEBT SCHEDULE INPUTS | |||||||||
| Beginning Total Debt ($mm) | 1,500.0 | ||||||||
| Annual Debt Repayment ($mm) | 75.0 | ||||||||
| Note: All sample data is for illustrative purposes only. | |||||||||