WillScot Mobile Mini Holdings Corp. (WSC) 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
WillScot Mobile Mini Holdings Corp. (WSC) Bundle
If you're an investor or analyst, this WillScot Mobile Mini Holdings Corp. (WSC) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from WillScot Mobile Mini Holdings Corp., you can adjust forecasts and observe the effects instantly.
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,063.7 | 1,367.6 | 1,894.9 | 2,142.6 | 2,364.8 | 2,900.2 | 3,556.9 | 4,362.3 | 5,350.0 | 6,561.5 |
| Revenue Growth, % | 0 | 28.58 | 38.55 | 13.07 | 10.37 | 22.64 | 22.64 | 22.64 | 22.64 | 22.64 |
| EBITDA | 121.2 | 377.5 | 536.3 | 826.1 | 1,023.7 | 865.1 | 1,060.9 | 1,301.2 | 1,595.8 | 1,957.1 |
| EBITDA, % | 11.39 | 27.6 | 28.3 | 38.55 | 43.29 | 29.83 | 29.83 | 29.83 | 29.83 | 29.83 |
| Depreciation | 188.1 | 243.8 | 280.6 | 319.1 | 338.7 | 461.3 | 565.8 | 693.9 | 851.0 | 1,043.7 |
| Depreciation, % | 17.68 | 17.83 | 14.81 | 14.89 | 14.32 | 15.91 | 15.91 | 15.91 | 15.91 | 15.91 |
| EBIT | -66.9 | 133.7 | 255.8 | 507.0 | 685.0 | 403.8 | 495.2 | 607.3 | 744.8 | 913.5 |
| EBIT, % | -6.29 | 9.77 | 13.5 | 23.66 | 28.97 | 13.92 | 13.92 | 13.92 | 13.92 | 13.92 |
| Total Cash | 3.0 | 24.9 | 12.7 | 7.4 | 11.0 | 20.8 | 25.5 | 31.3 | 38.4 | 47.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 247.6 | 330.9 | 351.3 | 409.8 | 451.1 | 604.5 | 741.4 | 909.2 | 1,115.1 | 1,367.6 |
| Account Receivables, % | 23.28 | 24.2 | 18.54 | 19.12 | 19.08 | 20.84 | 20.84 | 20.84 | 20.84 | 20.84 |
| Inventories | 15.4 | 21.7 | 32.7 | 41.0 | 47.4 | 50.3 | 61.7 | 75.7 | 92.8 | 113.9 |
| Inventories, % | 1.45 | 1.58 | 1.73 | 1.91 | 2 | 1.74 | 1.74 | 1.74 | 1.74 | 1.74 |
| Accounts Payable | 109.9 | 106.9 | 102.6 | 108.1 | 86.1 | 187.1 | 229.4 | 281.4 | 345.1 | 423.2 |
| Accounts Payable, % | 10.33 | 7.82 | 5.41 | 5.04 | 3.64 | 6.45 | 6.45 | 6.45 | 6.45 | 6.45 |
| Capital Expenditure | -213.4 | -188.8 | -309.0 | -486.8 | -249.2 | -484.0 | -593.6 | -728.0 | -892.8 | -1,095.0 |
| Capital Expenditure, % | -20.07 | -13.81 | -16.31 | -22.72 | -10.54 | -16.69 | -16.69 | -16.69 | -16.69 | -16.69 |
| Tax Rate, % | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 | -1.72 |
| EBITAT | -56.2 | 485.0 | 195.3 | 471.3 | 696.8 | 366.1 | 449.0 | 550.7 | 675.4 | 828.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -234.7 | 447.4 | 131.1 | 242.4 | 716.5 | 288.1 | 315.3 | 386.7 | 474.2 | 581.6 |
| WACC, % | 8.63 | 8.94 | 8.48 | 8.8 | 8.94 | 8.76 | 8.76 | 8.76 | 8.76 | 8.76 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,553.3 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 605 | |||||||||
| Terminal Value | 12,713 | |||||||||
| Present Terminal Value | 8,355 | |||||||||
| Enterprise Value | 9,908 | |||||||||
| Net Debt | 3,792 | |||||||||
| Equity Value | 6,117 | |||||||||
| Diluted Shares Outstanding, MM | 202 | |||||||||
| Equity Value Per Share | 30.30 |
What You Will Get
- Real WSC Financial Data: Pre-filled with WillScot Mobile Mini'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 WillScot Mobile Mini'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
- Comprehensive Data: WillScot Mobile Mini's historical financial statements and pre-filled projections.
- Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: View the intrinsic value of WillScot Mobile Mini recalculated instantly.
- Intuitive Visual Outputs: Dashboard charts present valuation results and essential metrics clearly.
- 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 WillScot Mobile Mini Holdings Corp.'s preloaded data.
- 2. Adjust Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.
Why Choose This Calculator for WillScot Mobile Mini Holdings Corp. (WSC)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: Historical and projected financials for WillScot preloaded to ensure precision.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions to evaluate different outcomes.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and other essential metrics.
- User-Friendly: Step-by-step guidance to help you navigate the calculation process effortlessly.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling WillScot Mobile Mini Holdings Corp. (WSC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for WillScot Mobile Mini Holdings Corp. (WSC).
- Consultants: Deliver professional valuation insights on WillScot Mobile Mini Holdings Corp. (WSC) to clients quickly and accurately.
- Business Owners: Understand how companies like WillScot Mobile Mini Holdings Corp. (WSC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to WillScot Mobile Mini Holdings Corp. (WSC).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled WillScot Mobile Mini Holdings Corp. (WSC) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for WillScot Mobile Mini Holdings Corp. (WSC).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.