Grocery Outlet Holding Corp. (GO) DCF Valuation

Grocery Outlet Holding Corp. (GO) 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

Grocery Outlet Holding Corp. (GO) 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:

Engineered for accuracy, our Grocery Outlet DCF Calculator empowers you to evaluate Grocery Outlet Holding Corp. (GO) valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.


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,559.6 3,134.6 3,079.6 3,578.1 3,969.5 4,444.1 4,975.6 5,570.6 6,236.8 6,982.6
Revenue Growth, % 0 22.47 -1.76 16.19 10.94 11.96 11.96 11.96 11.96 11.96
EBITDA 118.5 165.4 160.2 173.2 216.0 225.7 252.7 282.9 316.7 354.6
EBITDA, % 4.63 5.28 5.2 4.84 5.44 5.08 5.08 5.08 5.08 5.08
Depreciation 50.1 58.1 71.1 78.3 88.0 93.5 104.7 117.2 131.3 147.0
Depreciation, % 1.96 1.85 2.31 2.19 2.22 2.1 2.1 2.1 2.1 2.1
EBIT 68.3 107.4 89.1 95.0 128.1 132.2 148.0 165.7 185.5 207.7
EBIT, % 2.67 3.43 2.89 2.65 3.23 2.97 2.97 2.97 2.97 2.97
Total Cash 28.1 105.3 140.1 102.7 115.0 131.3 147.0 164.6 184.3 206.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 9.9 11.4 10.4 15.2 19.1
Account Receivables, % 0.3849 0.36345 0.33699 0.42405 0.48188
Inventories 219.4 245.2 275.5 334.3 350.0 386.6 432.9 484.6 542.6 607.5
Inventories, % 8.57 7.82 8.95 9.34 8.82 8.7 8.7 8.7 8.7 8.7
Accounts Payable 119.2 114.3 122.1 137.6 209.4 190.1 212.8 238.3 266.8 298.7
Accounts Payable, % 4.66 3.65 3.97 3.85 5.27 4.28 4.28 4.28 4.28 4.28
Capital Expenditure -100.3 -130.8 -133.2 -147.1 -192.0 -189.9 -212.6 -238.0 -266.4 -298.3
Capital Expenditure, % -3.92 -4.17 -4.32 -4.11 -4.84 -4.27 -4.27 -4.27 -4.27 -4.27
Tax Rate, % 23.68 23.68 23.68 23.68 23.68 23.68 23.68 23.68 23.68 23.68
EBITAT 62.8 131.5 71.6 81.6 97.7 114.8 128.6 144.0 161.2 180.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -97.4 26.6 -11.9 -35.3 45.8 -35.9 -4.9 -5.5 -6.1 -6.8
WACC, % 4.78 4.95 4.54 4.65 4.45 4.67 4.67 4.67 4.67 4.67
PV UFCF
SUM PV UFCF -54.1
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) -7
Terminal Value -188
Present Terminal Value -150
Enterprise Value -204
Net Debt 1,280
Equity Value -1,484
Diluted Shares Outstanding, MM 101
Equity Value Per Share -14.71

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real GO financials.
  • Real-World Data: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe the effects of your inputs on Grocery Outlet’s valuation.
  • Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
  • User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.

Key Features

  • Grocery Outlet Financial Insights: Gain access to reliable pre-loaded historical data and future forecasts.
  • Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
  • Interactive Dashboard: User-friendly charts and summaries to easily interpret your valuation outcomes.
  • Designed for All Levels: An accessible, intuitive layout tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Grocery Outlet data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Grocery Outlet’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Grocery Outlet Holding Corp. (GO)?

  • All-in-One Solution: Combines DCF, WACC, and key financial ratio analyses tailored for Grocery Outlet.
  • Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Grocery Outlet’s intrinsic value and Net Present Value.
  • Data-Driven: Comes with historical and projected data for precise calculations.
  • Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on Grocery Outlet.

Who Should Use This Product?

  • Finance Students: Explore grocery industry valuation techniques and apply them using real market data.
  • Academics: Integrate professional valuation models into your grocery sector coursework or research projects.
  • Investors: Validate your investment strategies and analyze valuation outcomes for Grocery Outlet Holding Corp. (GO).
  • Analysts: Enhance your analysis efficiency with a customizable DCF model tailored for the grocery sector.
  • Small Business Owners: Understand how large grocery chains like Grocery Outlet Holding Corp. (GO) are evaluated in the market.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring in-depth valuation calculations.
  • Real-World Data: Grocery Outlet Holding Corp.'s (GO) historical and projected financials preloaded for analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.

No products were found matching.