|
Valoración de DCF de PotBelly Corporation (PBPB)
US | Consumer Cyclical | Restaurants | NASDAQ
|
- ✓ 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
Potbelly Corporation (PBPB) Bundle
¡Simplifique la valoración de PotBelly Corporation (PBPB) con esta calculadora DCF personalizable! Con las finanzas de Real Potbelly Corporation (PBPB) y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Potbelly Corporation (PBPB) en minutos.
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 | 409.7 | 291.3 | 380.1 | 452.0 | 491.4 | 527.3 | 565.8 | 607.2 | 651.5 | 699.1 |
| Revenue Growth, % | 0 | -28.91 | 30.48 | 18.92 | 8.73 | 7.31 | 7.31 | 7.31 | 7.31 | 7.31 |
| EBITDA | 12.9 | -37.3 | -1.5 | 44.1 | 21.9 | 4.4 | 4.7 | 5.1 | 5.4 | 5.8 |
| EBITDA, % | 3.15 | -12.8 | -0.38258 | 9.75 | 4.46 | 0.83482 | 0.83482 | 0.83482 | 0.83482 | 0.83482 |
| Depreciation | 50.0 | 46.4 | 41.8 | 37.7 | 12.1 | 52.6 | 56.5 | 60.6 | 65.1 | 69.8 |
| Depreciation, % | 12.19 | 15.93 | 10.99 | 8.34 | 2.47 | 9.98 | 9.98 | 9.98 | 9.98 | 9.98 |
| EBIT | -37.0 | -83.7 | -43.2 | 6.4 | 9.8 | -48.2 | -51.8 | -55.6 | -59.6 | -64.0 |
| EBIT, % | -9.04 | -28.73 | -11.37 | 1.41 | 1.99 | -9.15 | -9.15 | -9.15 | -9.15 | -9.15 |
| Total Cash | 18.8 | 11.1 | 14.4 | 15.6 | 33.8 | 23.7 | 25.5 | 27.3 | 29.3 | 31.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 4.3 | 4.4 | 6.0 | 6.4 | 8.0 | 7.6 | 8.1 | 8.7 | 9.3 | 10.0 |
| Account Receivables, % | 1.04 | 1.49 | 1.59 | 1.42 | 1.62 | 1.43 | 1.43 | 1.43 | 1.43 | 1.43 |
| Inventories | 3.5 | 3.0 | 3.5 | 4.0 | 3.5 | 4.6 | 5.0 | 5.3 | 5.7 | 6.1 |
| Inventories, % | 0.84768 | 1.03 | 0.91856 | 0.8828 | 0.71549 | 0.87814 | 0.87814 | 0.87814 | 0.87814 | 0.87814 |
| Accounts Payable | 3.9 | 6.2 | 8.1 | 10.7 | 9.9 | 10.1 | 10.9 | 11.7 | 12.5 | 13.4 |
| Accounts Payable, % | 0.94848 | 2.13 | 2.14 | 2.37 | 2.02 | 1.92 | 1.92 | 1.92 | 1.92 | 1.92 |
| Capital Expenditure | -14.4 | -10.9 | -9.0 | -8.4 | -17.1 | -15.8 | -16.9 | -18.2 | -19.5 | -20.9 |
| Capital Expenditure, % | -3.51 | -3.75 | -2.38 | -1.86 | -3.47 | -2.99 | -2.99 | -2.99 | -2.99 | -2.99 |
| Tax Rate, % | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 | 21.08 |
| EBITAT | -93.0 | -76.1 | -43.5 | 5.5 | 7.7 | -44.0 | -47.2 | -50.7 | -54.4 | -58.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -61.3 | -37.9 | -11.1 | 36.5 | .9 | -7.6 | -7.8 | -8.4 | -9.0 | -9.7 |
| WACC, % | 7.87 | 7.71 | 7.87 | 7.63 | 7.5 | 7.72 | 7.72 | 7.72 | 7.72 | 7.72 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -33.9 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -10 | |||||||||
| Terminal Value | -135 | |||||||||
| Present Terminal Value | -93 | |||||||||
| Enterprise Value | -127 | |||||||||
| Net Debt | 153 | |||||||||
| Equity Value | -280 | |||||||||
| Diluted Shares Outstanding, MM | 30 | |||||||||
| Equity Value Per Share | -9.30 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-loaded financial data for Potbelly Corporation (PBPB).
- Authentic Data: Access to historical figures and forward-looking projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Potbelly’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Potbelly Corporation (PBPB).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for your convenience.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Potbelly Corporation (PBPB).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-built Excel file featuring Potbelly Corporation's (PBPB) financial data.
- Customize: Modify projections, including sales growth, EBITDA margin, and discount rate.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and evaluate results instantly.
- Make Decisions: Utilize the valuation insights to shape your investment approach.
Why Choose Potbelly's Financial Calculator?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Potbelly Corporation (PBPB).
- Flexible Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Potbelly’s intrinsic value and Net Present Value.
- Preloaded Information: Includes historical and projected data for precise calculations.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors focused on Potbelly Corporation (PBPB).
Who Should Use Potbelly Corporation (PBPB)?
- Food Enthusiasts: Discover and enjoy a diverse menu of sandwiches and salads crafted with quality ingredients.
- Franchise Owners: Leverage a proven business model with strong brand recognition and support.
- Health-Conscious Consumers: Explore nutritious options that cater to a variety of dietary preferences.
- Investors: Analyze the growth potential of a company committed to enhancing the customer experience.
- Families: Enjoy a welcoming atmosphere perfect for casual dining and gatherings.
What the Template Contains
- Historical Data: Includes Potbelly Corporation’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Potbelly Corporation’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Potbelly Corporation’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.