Flanigan's Enterprises, Inc. (BDL) 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
Flanigan's Enterprises, Inc. (BDL) Bundle
Explore the financial future of Flanigan's Enterprises, Inc. (BDL) with our user-friendly DCF Calculator! Enter your assumptions on growth, margins, and costs to calculate the intrinsic value of Flanigan's Enterprises, Inc. (BDL) and refine your investment strategy.
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 | 112.9 | 137.0 | 158.0 | 174.4 | 1.1 | 1.0 | .8 | .7 | .6 | .5 |
Revenue Growth, % | 0 | 21.42 | 15.26 | 10.41 | -99.37 | -13.07 | -13.07 | -13.07 | -13.07 | -13.07 |
EBITDA | 9.3 | 24.5 | 16.0 | 13.2 | 6.3 | .3 | .2 | .2 | .2 | .2 |
EBITDA, % | 8.2 | 17.87 | 10.11 | 7.6 | 571.86 | 28.75 | 28.75 | 28.75 | 28.75 | 28.75 |
Depreciation | 6.3 | 5.6 | 5.4 | 6.1 | 4.3 | .2 | .2 | .2 | .1 | .1 |
Depreciation, % | 5.57 | 4.09 | 3.42 | 3.51 | 386.24 | 23.32 | 23.32 | 23.32 | 23.32 | 23.32 |
EBIT | 3.0 | 18.9 | 10.6 | 7.1 | 2.1 | .2 | .2 | .2 | .2 | .1 |
EBIT, % | 2.62 | 13.78 | 6.69 | 4.09 | 185.61 | 25.44 | 25.44 | 25.44 | 25.44 | 25.44 |
Total Cash | 29.9 | 32.7 | 42.1 | 25.5 | .0 | .2 | .2 | .1 | .1 | .1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .7 | .5 | .5 | .8 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0.60336 | 0.32836 | 0.28868 | 0.47822 | 0 | 0.33972 | 0.33972 | 0.33972 | 0.33972 | 0.33972 |
Inventories | 3.6 | 4.3 | 6.5 | 7.2 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 3.21 | 3.13 | 4.11 | 4.13 | 0 | 2.91 | 2.91 | 2.91 | 2.91 | 2.91 |
Accounts Payable | 9.2 | 6.4 | 8.1 | 9.3 | .0 | .0 | .0 | .0 | .0 | .0 |
Accounts Payable, % | 8.18 | 4.69 | 5.13 | 5.32 | 0 | 4.66 | 4.66 | 4.66 | 4.66 | 4.66 |
Capital Expenditure | -3.1 | -11.3 | -9.6 | -18.7 | -3.4 | -.2 | -.2 | -.2 | -.2 | -.1 |
Capital Expenditure, % | -2.73 | -8.26 | -6.05 | -10.71 | -311.76 | -25.55 | -25.55 | -25.55 | -25.55 | -25.55 |
Tax Rate, % | 39.92 | 39.92 | 39.92 | 39.92 | 39.92 | 39.92 | 39.92 | 39.92 | 39.92 | 39.92 |
EBITAT | 3.0 | 17.6 | 9.7 | 4.7 | 1.2 | .2 | .2 | .2 | .1 | .1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 11.2 | 8.7 | 5.1 | -7.8 | .8 | .2 | .2 | .1 | .1 | .1 |
WACC, % | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 | 8.22 |
PV UFCF | ||||||||||
SUM PV UFCF | .6 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 1 | |||||||||
Present Terminal Value | 1 | |||||||||
Enterprise Value | 1 | |||||||||
Net Debt | 0 | |||||||||
Equity Value | 1 | |||||||||
Diluted Shares Outstanding, MM | 2 | |||||||||
Equity Value Per Share | 0.79 |
What You Will Get
- Real BDL Financial Data: Pre-filled with Flanigan's Enterprises' historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Flanigan's intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life BDL Financials: Pre-filled historical and projected data for Flanigan's Enterprises, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Flanigan's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Flanigan's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based BDL Valuation Model.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, discount rates, profit margins, and more.
- Instant Calculations: The model automatically recalculates Flanigan's intrinsic value.
- Test Scenarios: Experiment with various assumptions to see how they affect the valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose Flanigan's Enterprises, Inc. (BDL)?
- Save Time: Quickly access essential financial insights without extensive setup.
- Enhance Accuracy: Utilize dependable data and calculations to minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific forecasts and assumptions.
- User-Friendly: Intuitive charts and outputs facilitate straightforward analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize both precision and functionality.
Who Should Use Flanigan's Enterprises, Inc. (BDL)?
- Restaurant Investors: Develop comprehensive financial models to assess investment opportunities in the dining sector.
- Corporate Strategy Teams: Evaluate market trends to inform strategic decisions for Flanigan's Enterprises.
- Financial Consultants: Offer clients precise valuation assessments for Flanigan's Enterprises, Inc. (BDL).
- Students and Instructors: Utilize industry data to enhance learning in restaurant management and financial analysis.
- Culinary Enthusiasts: Gain insights into how restaurant chains like Flanigan's are valued within the industry.
What the Template Contains
- Pre-Filled DCF Model: Flanigan's financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Flanigan's profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.