FAT Brands Inc. (FATBB) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
FAT Brands Inc. (FATBB) Bundle
Evaluate FAT Brands Inc.'s financial outlook like an expert! This (FATBB) DCF Calculator provides pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 22.5 | 18.1 | 118.9 | 407.2 | 480.5 | 718.9 | 1,075.6 | 1,609.3 | 2,407.9 | 3,602.8 |
Revenue Growth, % | 0 | -19.49 | 556.15 | 242.55 | 17.98 | 49.62 | 49.62 | 49.62 | 49.62 | 49.62 |
EBITDA | 6.7 | -8.8 | .8 | 21.5 | 52.3 | -3.0 | -4.5 | -6.7 | -10.0 | -15.0 |
EBITDA, % | 29.78 | -48.72 | 0.69313 | 5.28 | 10.88 | -0.41513 | -0.41513 | -0.41513 | -0.41513 | -0.41513 |
Depreciation | .8 | 1.2 | 8.6 | 34.0 | 31.1 | 46.0 | 68.8 | 103.0 | 154.1 | 230.6 |
Depreciation, % | 3.49 | 6.47 | 7.21 | 8.36 | 6.48 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
EBIT | 5.9 | -10.0 | -7.7 | -12.5 | 21.2 | -49.0 | -73.3 | -109.7 | -164.1 | -245.5 |
EBIT, % | 26.3 | -55.19 | -6.51 | -3.08 | 4.41 | -6.82 | -6.82 | -6.82 | -6.82 | -6.82 |
Total Cash | .0 | 3.9 | 56.7 | 28.7 | 37.0 | 121.2 | 181.3 | 271.3 | 405.9 | 607.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 4.4 | 4.4 | 23.0 | 23.9 | 21.1 | 105.8 | 158.3 | 236.9 | 354.5 | 530.4 |
Account Receivables, % | 19.58 | 24.37 | 19.39 | 5.86 | 4.4 | 14.72 | 14.72 | 14.72 | 14.72 | 14.72 |
Inventories | 5.1 | 13.7 | 30.2 | 6.9 | 9.3 | 183.2 | 274.2 | 410.2 | 613.8 | 918.3 |
Inventories, % | 22.79 | 75.6 | 25.42 | 1.7 | 1.94 | 25.49 | 25.49 | 25.49 | 25.49 | 25.49 |
Accounts Payable | 7.2 | 8.6 | 27.5 | 18.3 | 21.8 | 160.6 | 240.3 | 359.6 | 538.0 | 805.0 |
Accounts Payable, % | 31.92 | 47.6 | 23.16 | 4.5 | 4.54 | 22.34 | 22.34 | 22.34 | 22.34 | 22.34 |
Capital Expenditure | .0 | -.5 | -10.4 | -23.2 | -21.5 | -31.2 | -46.6 | -69.8 | -104.4 | -156.2 |
Capital Expenditure, % | -0.19996 | -2.54 | -8.77 | -5.69 | -4.48 | -4.33 | -4.33 | -4.33 | -4.33 | -4.33 |
Tax Rate, % | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 | 6.49 |
EBITAT | 11.9 | -8.0 | -7.0 | -14.7 | 19.8 | -45.4 | -68.0 | -101.7 | -152.1 | -227.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 10.2 | -14.4 | -25.1 | 9.4 | 33.3 | -150.4 | -109.5 | -163.8 | -245.1 | -366.7 |
WACC, % | 8.78 | 7.19 | 7.98 | 8.78 | 8.26 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 |
PV UFCF | ||||||||||
SUM PV UFCF | -787.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -374 | |||||||||
Terminal Value | -6,032 | |||||||||
Present Terminal Value | -4,067 | |||||||||
Enterprise Value | -4,855 | |||||||||
Net Debt | 1,345 | |||||||||
Equity Value | -6,200 | |||||||||
Diluted Shares Outstanding, MM | 17 | |||||||||
Equity Value Per Share | -373.50 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real FAT Brands Inc. (FATBB) financials.
- Authentic Data: Historical figures and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect FAT Brands Inc. (FATBB)’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as sales growth, operating margin, and investment costs.
- Instant DCF Valuation: Quickly determines intrinsic value, net present value, and various financial metrics.
- High-Precision Estimates: Incorporates FAT Brands Inc.'s (FATBB) actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Evaluate different scenarios and analyze results with ease.
- Efficiency Booster: Streamline the valuation process by avoiding the need for intricate model development.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered FAT Brands Inc. (FATBB) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for FAT Brands Inc. (FATBB)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for FAT Brands Inc. (FATBB)?
- All-in-One Solution: Features DCF, WACC, and comprehensive financial ratio analyses tailored for FAT Brands.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for FAT Brands.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value specific to FAT Brands Inc.
- Preloaded Financial Data: Incorporates historical and projected data for precise calculations.
- Designed for Professionals: Perfect for financial analysts, investors, and consultants focusing on FAT Brands Inc. (FATBB).
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling FAT Brands Inc. (FATBB) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for FAT Brands Inc. (FATBB).
- Consultants: Deliver professional valuation insights on FAT Brands Inc. (FATBB) to clients quickly and accurately.
- Business Owners: Understand how companies like FAT Brands Inc. (FATBB) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to FAT Brands Inc. (FATBB).
What the Template Contains
- Pre-Filled Data: Includes FAT Brands Inc.'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 FAT Brands Inc.'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.