The Simply Good Foods Company (SMPL) DCF Valuation

The Simply Good Foods Company (SMPL) DCF Valuation
  • Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • Aucune Expertise N'Est Requise; Facile À Suivre

The Simply Good Foods Company (SMPL) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 10.99 11.08 11.35 11.67 11.32
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.