The Simply Good Foods Company (SMPL) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
The Simply Good Foods Company (SMPL) Bundle
Explore The Simply Good Foods Company's (SMPL) financial potential with our easy-to-use DCF Calculator! Enter your assumptions regarding growth, margins, and costs to calculate The Simply Good Foods Company's intrinsic value and enhance your investment approach.
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 | 816.6 | 1,005.6 | 1,168.7 | 1,242.7 | 1,331.3 | 1,507.1 | 1,706.1 | 1,931.4 | 2,186.5 | 2,475.2 |
Revenue Growth, % | 0 | 23.14 | 16.22 | 6.33 | 7.13 | 13.21 | 13.21 | 13.21 | 13.21 | 13.21 |
EBITDA | 131.6 | 135.6 | 198.4 | 232.7 | 240.1 | 251.2 | 284.4 | 321.9 | 364.5 | 412.6 |
EBITDA, % | 16.12 | 13.49 | 16.97 | 18.73 | 18.03 | 16.67 | 16.67 | 16.67 | 16.67 | 16.67 |
Depreciation | 19.9 | 23.2 | 25.9 | 27.0 | 28.0 | 33.9 | 38.3 | 43.4 | 49.1 | 55.6 |
Depreciation, % | 2.43 | 2.31 | 2.22 | 2.17 | 2.1 | 2.25 | 2.25 | 2.25 | 2.25 | 2.25 |
EBIT | 111.8 | 112.4 | 172.5 | 205.8 | 212.1 | 217.4 | 246.1 | 278.6 | 315.3 | 357.0 |
EBIT, % | 13.69 | 11.18 | 14.76 | 16.56 | 15.93 | 14.42 | 14.42 | 14.42 | 14.42 | 14.42 |
Total Cash | 95.8 | 75.3 | 67.5 | 87.7 | 132.5 | 126.7 | 143.4 | 162.3 | 183.7 | 208.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 89.7 | 111.5 | 132.7 | 145.1 | 150.7 | 170.1 | 192.5 | 217.9 | 246.7 | 279.3 |
Account Receivables, % | 10.99 | 11.08 | 11.35 | 11.67 | 11.32 | 11.28 | 11.28 | 11.28 | 11.28 | 11.28 |
Inventories | 59.1 | 97.3 | 125.5 | 116.6 | 142.1 | 143.8 | 162.8 | 184.3 | 208.6 | 236.1 |
Inventories, % | 7.24 | 9.67 | 10.74 | 9.38 | 10.67 | 9.54 | 9.54 | 9.54 | 9.54 | 9.54 |
Accounts Payable | 32.2 | 59.7 | 62.1 | 52.7 | 58.6 | 71.9 | 81.4 | 92.1 | 104.3 | 118.0 |
Accounts Payable, % | 3.95 | 5.94 | 5.32 | 4.24 | 4.4 | 4.77 | 4.77 | 4.77 | 4.77 | 4.77 |
Capital Expenditure | -2.7 | -6.7 | -5.8 | -12.2 | -6.5 | -8.9 | -10.1 | -11.4 | -12.9 | -14.6 |
Capital Expenditure, % | -0.32683 | -0.66686 | -0.49252 | -0.98079 | -0.48621 | -0.59064 | -0.59064 | -0.59064 | -0.59064 | -0.59064 |
Tax Rate, % | 25.12 | 25.12 | 25.12 | 25.12 | 25.12 | 25.12 | 25.12 | 25.12 | 25.12 | 25.12 |
EBITAT | 92.9 | 56.8 | 124.4 | 156.4 | 158.8 | 155.1 | 175.5 | 198.7 | 225.0 | 254.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -6.5 | 40.9 | 97.5 | 158.3 | 155.0 | 172.3 | 171.8 | 194.5 | 220.2 | 249.3 |
WACC, % | 7.29 | 7.1 | 7.23 | 7.25 | 7.24 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
PV UFCF | ||||||||||
SUM PV UFCF | 810.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 254 | |||||||||
Terminal Value | 4,870 | |||||||||
Present Terminal Value | 3,436 | |||||||||
Enterprise Value | 4,247 | |||||||||
Net Debt | 270 | |||||||||
Equity Value | 3,976 | |||||||||
Diluted Shares Outstanding, MM | 101 | |||||||||
Equity Value Per Share | 39.26 |
What You Will Get
- Pre-Filled Financial Model: The Simply Good Foods Company’s (SMPL) actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers for accurate projections.
- Instant Calculations: Automatic updates ensure you see results in real-time as you make changes.
- Investor-Ready Template: A polished Excel file crafted for professional-grade valuation.
- Customizable and Reusable: Designed for flexibility, allowing repeated use for comprehensive forecasts.
Key Features
- Comprehensive Data: The Simply Good Foods Company's (SMPL) historical financial statements and pre-filled forecasts.
- Fully Customizable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe The Simply Good Foods Company's (SMPL) intrinsic value updating instantly.
- Intuitive Visual Outputs: Dashboard charts illustrate valuation results and essential metrics clearly.
- Designed for Precision: A reliable tool for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing The Simply Good Foods Company’s (SMPL) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Immediately: The DCF model automatically calculates intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation outcomes.
- 5. Present with Assurance: Deliver professional valuation insights to enhance your decision-making.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: The Simply Good Foods Company's (SMPL) historical and forecasted financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Comprehensive step-by-step instructions facilitate the entire process.
Who Should Use This Product?
- Investors: Accurately assess The Simply Good Foods Company's (SMPL) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to (SMPL).
- Consultants: Easily customize the template for valuation reports tailored to clients of (SMPL).
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies like (SMPL).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to (SMPL).
What the Template Contains
- Pre-Filled Data: Includes The Simply Good Foods Company'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 The Simply Good Foods Company'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.