The Scotts Miracle-Gro Company (SMG) 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
The Scotts Miracle-Gro Company (SMG) Bundle
Designed for accuracy, our (SMG) DCF Calculator empowers you to assess The Scotts Miracle-Gro Company valuation using up-to-date financial data, offering complete flexibility to modify all essential parameters for improved forecasts.
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 | 4,131.6 | 4,925.0 | 3,924.1 | 3,551.3 | 3,552.7 | 3,458.7 | 3,367.2 | 3,278.2 | 3,191.5 | 3,107.0 |
| Revenue Growth, % | 0 | 19.2 | -20.32 | -9.5 | 0.03942218 | -2.65 | -2.65 | -2.65 | -2.65 | -2.65 |
| EBITDA | 697.6 | 845.8 | -336.9 | -174.4 | 215.8 | 184.3 | 179.4 | 174.6 | 170.0 | 165.5 |
| EBITDA, % | 16.88 | 17.17 | -8.59 | -4.91 | 6.07 | 5.33 | 5.33 | 5.33 | 5.33 | 5.33 |
| Depreciation | 94.7 | 93.8 | 105.2 | 173.5 | 80.6 | 97.1 | 94.5 | 92.0 | 89.6 | 87.2 |
| Depreciation, % | 2.29 | 1.9 | 2.68 | 4.89 | 2.27 | 2.81 | 2.81 | 2.81 | 2.81 | 2.81 |
| EBIT | 602.9 | 752.0 | -442.1 | -347.9 | 135.2 | 87.2 | 84.9 | 82.6 | 80.5 | 78.3 |
| EBIT, % | 14.59 | 15.27 | -11.27 | -9.8 | 3.81 | 2.52 | 2.52 | 2.52 | 2.52 | 2.52 |
| Total Cash | 16.6 | 244.1 | 86.8 | 31.9 | 71.6 | 72.5 | 70.6 | 68.7 | 66.9 | 65.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 497.1 | 483.4 | 378.8 | 304.2 | 176.8 | 311.6 | 303.3 | 295.3 | 287.5 | 279.9 |
| Account Receivables, % | 12.03 | 9.82 | 9.65 | 8.57 | 4.98 | 9.01 | 9.01 | 9.01 | 9.01 | 9.01 |
| Inventories | 621.9 | 1,126.6 | 1,343.5 | 880.3 | 587.5 | 785.1 | 764.3 | 744.1 | 724.4 | 705.2 |
| Inventories, % | 15.05 | 22.88 | 34.24 | 24.79 | 16.54 | 22.7 | 22.7 | 22.7 | 22.7 | 22.7 |
| Accounts Payable | 391.0 | 609.4 | 422.6 | 271.2 | 254.7 | 328.0 | 319.3 | 310.9 | 302.6 | 294.6 |
| Accounts Payable, % | 9.46 | 12.37 | 10.77 | 7.64 | 7.17 | 9.48 | 9.48 | 9.48 | 9.48 | 9.48 |
| Capital Expenditure | -62.7 | -106.9 | -113.5 | -92.8 | -84.0 | -80.0 | -77.8 | -75.8 | -73.8 | -71.8 |
| Capital Expenditure, % | -1.52 | -2.17 | -2.89 | -2.61 | -2.36 | -2.31 | -2.31 | -2.31 | -2.31 | -2.31 |
| Tax Rate, % | -47.88 | -47.88 | -47.88 | -47.88 | -47.88 | -47.88 | -47.88 | -47.88 | -47.88 | -47.88 |
| EBITAT | 457.4 | 569.2 | -346.6 | -291.7 | 199.9 | 72.2 | 70.3 | 68.4 | 66.6 | 64.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -238.6 | 283.5 | -654.0 | 175.4 | 600.2 | -169.8 | 107.2 | 104.4 | 101.6 | 99.0 |
| WACC, % | 9.96 | 9.96 | 10.03 | 10.17 | 10.6 | 10.14 | 10.14 | 10.14 | 10.14 | 10.14 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 142.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 101 | |||||||||
| Terminal Value | 1,239 | |||||||||
| Present Terminal Value | 764 | |||||||||
| Enterprise Value | 907 | |||||||||
| Net Debt | 2,155 | |||||||||
| Equity Value | -1,248 | |||||||||
| Diluted Shares Outstanding, MM | 57 | |||||||||
| Equity Value Per Share | -21.98 |
What You Will Get
- Real Scotts Miracle-Gro Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for The Scotts Miracle-Gro Company (SMG).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to The Scotts Miracle-Gro Company (SMG).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on The Scotts Miracle-Gro Company (SMG)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for The Scotts Miracle-Gro Company (SMG).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for The Scotts Miracle-Gro Company (SMG).
Key Features
- 🔍 Real-Life SMG Financials: Pre-filled historical and projected data for The Scotts Miracle-Gro Company (SMG).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate The Scotts Miracle-Gro Company’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize The Scotts Miracle-Gro Company’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Scotts Miracle-Gro Company's (SMG) preloaded data.
- 2. Adjust Key Inputs: Modify essential parameters such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: 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 enhance your decision-making process.
Why Choose This Calculator for Scotts Miracle-Gro Company (SMG)?
- Designed for Experts: A sophisticated tool utilized by industry analysts, financial officers, and consultants.
- Accurate Data: Scotts Miracle-Gro's historical and forecasted financials are preloaded for precision.
- Scenario Analysis: Easily simulate various forecasts and assumptions to explore different outcomes.
- Clear Results: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use Scotts Miracle-Gro Company (SMG)?
- Gardeners: Enhance your gardening experience with top-quality products designed for optimal plant growth.
- Landscapers: Utilize professional-grade solutions to create stunning outdoor spaces for clients.
- Retailers: Stock up on reliable gardening supplies to meet customer demands and boost sales.
- Hobbyists: Explore innovative gardening techniques and products for your personal projects.
- Educators and Students: Incorporate practical applications of horticulture in science and agriculture courses.
What the Template Contains
- Pre-Filled Data: Includes Scotts Miracle-Gro's historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Scotts Miracle-Gro's profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.