SiteOne Landscape Supply, Inc. (SITE) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
SiteOne Landscape Supply, Inc. (SITE) Bundle
Looking to assess the intrinsic value of SiteOne Landscape Supply, Inc.? Our (SITE) DCF Calculator integrates real-world data with extensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 2,357.5 | 2,704.5 | 3,475.7 | 4,014.5 | 4,301.2 | 5,009.6 | 5,834.6 | 6,795.6 | 7,914.8 | 9,218.3 |
| Revenue Growth, % | 0 | 14.72 | 28.52 | 15.5 | 7.14 | 16.47 | 16.47 | 16.47 | 16.47 | 16.47 |
| EBITDA | 184.4 | 247.0 | 396.7 | 436.9 | 378.0 | 481.3 | 560.6 | 652.9 | 760.4 | 885.7 |
| EBITDA, % | 7.82 | 9.13 | 11.41 | 10.88 | 8.79 | 9.61 | 9.61 | 9.61 | 9.61 | 9.61 |
| Depreciation | 59.5 | 67.2 | 83.0 | 103.8 | 127.7 | 129.8 | 151.1 | 176.0 | 205.0 | 238.8 |
| Depreciation, % | 2.52 | 2.48 | 2.39 | 2.59 | 2.97 | 2.59 | 2.59 | 2.59 | 2.59 | 2.59 |
| EBIT | 124.9 | 179.8 | 313.7 | 333.1 | 250.3 | 351.6 | 409.5 | 476.9 | 555.4 | 646.9 |
| EBIT, % | 5.3 | 6.65 | 9.03 | 8.3 | 5.82 | 7.02 | 7.02 | 7.02 | 7.02 | 7.02 |
| Total Cash | 19.0 | 55.2 | 53.7 | 29.1 | 82.5 | 70.5 | 82.1 | 95.6 | 111.4 | 129.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 283.4 | 299.6 | 397.1 | 466.4 | 490.6 | 576.6 | 671.5 | 782.1 | 911.0 | 1,061.0 |
| Account Receivables, % | 12.02 | 11.08 | 11.43 | 11.62 | 11.41 | 11.51 | 11.51 | 11.51 | 11.51 | 11.51 |
| Inventories | 427.1 | 458.6 | 636.6 | 767.7 | 771.2 | 906.2 | 1,055.4 | 1,229.2 | 1,431.7 | 1,667.4 |
| Inventories, % | 18.12 | 16.96 | 18.32 | 19.12 | 17.93 | 18.09 | 18.09 | 18.09 | 18.09 | 18.09 |
| Accounts Payable | 162.2 | 172.8 | 254.5 | 279.7 | 270.8 | 339.2 | 395.1 | 460.1 | 535.9 | 624.2 |
| Accounts Payable, % | 6.88 | 6.39 | 7.32 | 6.97 | 6.3 | 6.77 | 6.77 | 6.77 | 6.77 | 6.77 |
| Capital Expenditure | -21.4 | -25.8 | -37.0 | -41.7 | -36.0 | -48.1 | -56.0 | -65.3 | -76.0 | -88.5 |
| Capital Expenditure, % | -0.90774 | -0.95397 | -1.06 | -1.04 | -0.83698 | -0.96039 | -0.96039 | -0.96039 | -0.96039 | -0.96039 |
| Tax Rate, % | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 | 22.31 |
| EBITAT | 106.1 | 146.6 | 253.9 | 261.1 | 194.5 | 283.7 | 330.4 | 384.8 | 448.2 | 522.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -404.1 | 150.9 | 106.1 | 148.0 | 249.6 | 212.8 | 237.2 | 276.2 | 321.7 | 374.7 |
| WACC, % | 10.72 | 10.7 | 10.7 | 10.68 | 10.68 | 10.69 | 10.69 | 10.69 | 10.69 | 10.69 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,029.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 382 | |||||||||
| Terminal Value | 4,396 | |||||||||
| Present Terminal Value | 2,645 | |||||||||
| Enterprise Value | 3,674 | |||||||||
| Net Debt | 779 | |||||||||
| Equity Value | 2,895 | |||||||||
| Diluted Shares Outstanding, MM | 46 | |||||||||
| Equity Value Per Share | 63.38 |
What You Will Get
- Real SITE Financial Data: Pre-filled with SiteOne Landscape Supply’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 SiteOne’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
- 🔍 Real-Life SITE Financials: Pre-filled historical and projected data for SiteOne Landscape Supply, Inc. (SITE).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate SiteOne’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize SiteOne’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based SITE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh SITE’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose This Calculator for SiteOne Landscape Supply, Inc. (SITE)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio assessments in a single platform.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes SiteOne's intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Investors: Accurately assess SiteOne Landscape Supply, Inc.’s (SITE) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to SITE.
- Consultants: Efficiently customize the template for valuation reports tailored to clients in the landscaping industry.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies like SITE.
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to SITE.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled SiteOne Landscape Supply 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 SiteOne Landscape Supply, Inc. (SITE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.