|
PB Bankshares, Inc. (PBBK) DCF Valuation
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ 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
PB Bankshares, Inc. (PBBK) Bundle
Explore the financial future of PB Bankshares, Inc. (PBBK) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to determine the intrinsic value of PB Bankshares, Inc. (PBBK) and refine your investment strategy.
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 | 7.4 | 7.1 | 8.5 | 11.3 | 12.3 | 14.0 | 16.0 | 18.3 | 20.9 | 23.9 |
Revenue Growth, % | 0 | -3.75 | 19.29 | 33.04 | 8.37 | 14.24 | 14.24 | 14.24 | 14.24 | 14.24 |
EBITDA | 1.1 | -.4 | 1.1 | .0 | .0 | .7 | .8 | .9 | 1.0 | 1.1 |
EBITDA, % | 15.5 | -4.91 | 13.24 | 0 | 0 | 4.77 | 4.77 | 4.77 | 4.77 | 4.77 |
Depreciation | .2 | .2 | .2 | .3 | .0 | .3 | .3 | .4 | .4 | .5 |
Depreciation, % | 2.66 | 2.87 | 2.02 | 2.54 | 0 | 2.02 | 2.02 | 2.02 | 2.02 | 2.02 |
EBIT | 1.0 | -.6 | 1.0 | -.3 | .0 | .4 | .4 | .5 | .6 | .7 |
EBIT, % | 12.85 | -7.78 | 11.22 | -2.54 | 0 | 2.75 | 2.75 | 2.75 | 2.75 | 2.75 |
Total Cash | 27.2 | 51.9 | 41.3 | 68.1 | 85.9 | 14.0 | 16.0 | 18.3 | 20.9 | 23.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 302.0 | .0 | 2.8 | 3.2 | 3.7 | 4.2 | 4.8 |
Account Receivables, % | 0 | 0 | 0 | 2667.65 | 0 | 20 | 20 | 20 | 20 | 20 |
Inventories | -13.5 | -51.4 | -27.7 | 282.5 | .0 | -5.6 | -6.4 | -7.3 | -8.4 | -9.5 |
Inventories, % | -181.93 | -721.18 | -325.73 | 2495.83 | 0 | -40 | -40 | -40 | -40 | -40 |
Accounts Payable | .0 | .0 | .0 | -209.2 | .0 | -2.8 | -3.2 | -3.7 | -4.2 | -4.8 |
Accounts Payable, % | 0 | 0 | 0 | -1847.81 | 0 | -20 | -20 | -20 | -20 | -20 |
Capital Expenditure | -.1 | -.7 | .0 | -.1 | -.6 | -.5 | -.6 | -.7 | -.8 | -.9 |
Capital Expenditure, % | -1.81 | -9.7 | -0.11752 | -1.28 | -5.23 | -3.63 | -3.63 | -3.63 | -3.63 | -3.63 |
Tax Rate, % | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 | 22.12 |
EBITAT | .8 | -.4 | .8 | -.2 | .0 | .3 | .3 | .4 | .5 | .5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 14.3 | 37.1 | -22.8 | -821.5 | 793.0 | .1 | .1 | .1 | .1 | .1 |
WACC, % | 8.98 | 8.4 | 9.01 | 8.82 | 8.65 | 8.77 | 8.77 | 8.77 | 8.77 | 8.77 |
PV UFCF | ||||||||||
SUM PV UFCF | .4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 0 | |||||||||
Terminal Value | 2 | |||||||||
Present Terminal Value | 1 | |||||||||
Enterprise Value | 2 | |||||||||
Net Debt | 37 | |||||||||
Equity Value | -35 | |||||||||
Diluted Shares Outstanding, MM | 2 | |||||||||
Equity Value Per Share | -14.10 |
What You Will Get
- Real PB Bankshares Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for PB Bankshares, Inc. (PBBK).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis of PB Bankshares, Inc. (PBBK).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on PB Bankshares, Inc. (PBBK)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specific to PB Bankshares, Inc. (PBBK).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for PB Bankshares, Inc. (PBBK).
Key Features
- Comprehensive Financial Data: Gain access to precise historical performance and future forecasts for PB Bankshares, Inc. (PBBK).
- Adjustable Forecast Parameters: Modify highlighted fields like WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow metrics.
- User-Friendly Dashboard: Clear and concise charts and summaries to help you interpret your valuation findings.
- Designed for All Skill Levels: An accessible and straightforward layout tailored for investors, CFOs, and financial consultants.
How It Works
- Download the Template: Gain immediate access to the Excel-based PBBK DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional variables.
- Instant Calculations: The model automatically recalculates PB Bankshares’ intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose PB Bankshares, Inc. (PBBK) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses for comprehensive evaluations.
- Flexible Inputs: Modify the highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes PB Bankshares’ intrinsic value and Net Present Value.
- Preloaded Information: Access historical and projected data for reliable analysis.
- Expert Level: Perfect for financial analysts, investors, and business advisors.
Who Should Use PB Bankshares, Inc. (PBBK)?
- Investors: Enhance your investment strategies with insights from a trusted financial institution.
- Financial Analysts: Streamline your analysis with comprehensive data and reports on PB Bankshares, Inc. (PBBK).
- Consultants: Leverage our resources to provide informed recommendations to your clients.
- Finance Enthusiasts: Explore the banking sector's dynamics and improve your financial literacy with real-time data.
- Educators and Students: Utilize our materials as a valuable resource for finance education and research.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: PB Bankshares, Inc.'s (PBBK) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for in-depth insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.