Glen Burnie Bancorp (GLBZ) 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
Glen Burnie Bancorp (GLBZ) Bundle
Explore the financial potential of Glen Burnie Bancorp (GLBZ) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate the intrinsic value of Glen Burnie Bancorp (GLBZ) and refine your investment approach.
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 | 13.8 | 13.0 | 13.1 | 13.3 | 12.9 | 12.7 | 12.5 | 12.3 | 12.1 | 11.9 |
| Revenue Growth, % | 0 | -5.34 | 0.13804 | 1.49 | -2.63 | -1.58 | -1.58 | -1.58 | -1.58 | -1.58 |
| EBITDA | -.1 | -.2 | -.2 | -.1 | .0 | -.1 | -.1 | -.1 | -.1 | -.1 |
| EBITDA, % | -0.951 | -1.43 | -1.29 | -0.84516 | 0 | -0.90335 | -0.90335 | -0.90335 | -0.90335 | -0.90335 |
| Depreciation | .4 | .4 | .4 | .4 | .1 | .3 | .3 | .3 | .3 | .3 |
| Depreciation, % | 2.9 | 3.07 | 3.06 | 3.02 | 0.92219 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 |
| EBIT | -.5 | -.6 | -.6 | -.5 | -.1 | -.4 | -.4 | -.4 | -.4 | -.4 |
| EBIT, % | -3.85 | -4.49 | -4.36 | -3.86 | -0.92219 | -3.5 | -3.5 | -3.5 | -3.5 | -3.5 |
| Total Cash | 84.8 | 151.1 | 218.1 | 174.2 | 141.4 | 12.7 | 12.5 | 12.3 | 12.1 | 11.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2.2 | 1.4 | 1.4 | 1.2 | 1.3 | 1.4 | 1.4 | 1.4 | 1.4 | 1.3 |
| Account Receivables, % | 15.84 | 10.87 | 10.61 | 8.75 | 10.18 | 11.25 | 11.25 | 11.25 | 11.25 | 11.25 |
| Inventories | -16.6 | -39.4 | -63.9 | .0 | .0 | -7.6 | -7.5 | -7.4 | -7.3 | -7.1 |
| Inventories, % | -120.38 | -302.18 | -489.46 | 0 | 0 | -60 | -60 | -60 | -60 | -60 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | -.3 | -.6 | -.3 | -.3 | -.2 | -.3 | -.3 | -.3 | -.3 | -.3 |
| Capital Expenditure, % | -2.44 | -4.39 | -2.2 | -1.93 | -1.18 | -2.43 | -2.43 | -2.43 | -2.43 | -2.43 |
| Tax Rate, % | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 | 4.8 |
| EBITAT | -.4 | -.5 | -.5 | -.5 | -.1 | -.4 | -.4 | -.4 | -.4 | -.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 14.1 | 23.0 | 24.2 | -64.0 | -.3 | 7.2 | -.4 | -.4 | -.4 | -.4 |
| WACC, % | 4.86 | 4.84 | 4.95 | 5.14 | 5.35 | 5.03 | 5.03 | 5.03 | 5.03 | 5.03 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | -14 | |||||||||
| Present Terminal Value | -11 | |||||||||
| Enterprise Value | -6 | |||||||||
| Net Debt | 15 | |||||||||
| Equity Value | -21 | |||||||||
| Diluted Shares Outstanding, MM | 3 | |||||||||
| Equity Value Per Share | -7.16 |
What You Will Receive
- Pre-Filled Financial Model: Glen Burnie Bancorp’s actual data facilitates accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates allow you to view results instantly as you make adjustments.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Glen Burnie Bancorp (GLBZ).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to Glen Burnie Bancorp (GLBZ).
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates for Glen Burnie Bancorp (GLBZ).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Glen Burnie Bancorp (GLBZ).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of Glen Burnie Bancorp (GLBZ).
How It Functions
- Download the Template: Gain immediate access to the Excel-based GLBZ DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Glen Burnie Bancorp’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential valuation impacts.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator?
- Accurate Data: Reliable financials from Glen Burnie Bancorp (GLBZ) ensure trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate design and clear instructions cater to users of all experience levels.
Who Should Use This Product?
- Individual Investors: Gain insights to make informed decisions about buying or selling Glen Burnie Bancorp (GLBZ) stock.
- Financial Analysts: Enhance your valuation processes with comprehensive financial models tailored for Glen Burnie Bancorp (GLBZ).
- Consultants: Provide clients with accurate and timely valuation insights related to Glen Burnie Bancorp (GLBZ).
- Business Owners: Learn how regional banks like Glen Burnie Bancorp (GLBZ) are valued to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and case studies involving Glen Burnie Bancorp (GLBZ).
What the Glen Burnie Bancorp Template Contains
- Detailed DCF Model: Editable template featuring thorough valuation calculations specifically for Glen Burnie Bancorp (GLBZ).
- Historical Financial Data: Preloaded financials of Glen Burnie Bancorp (GLBZ) for both historical and projected analysis.
- Adjustable Assumptions: Customize WACC, growth rates, and tax parameters to explore various scenarios.
- Comprehensive Financial Statements: Complete annual and quarterly financial breakdowns for enhanced insights.
- Essential Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Interactive Dashboard: Visual outputs including charts and tables for clear and actionable insights.