Brookline Bancorp, Inc. (BRKL) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Brookline Bancorp, Inc. (BRKL) Bundle
Engineered for accuracy, our (BRKL) DCF Calculator allows you to evaluate Brookline Bancorp, Inc. valuation using real-world financial data, providing full flexibility to modify all essential parameters for improved 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 | 283.1 | 284.8 | 309.4 | 328.1 | 333.4 | 347.5 | 362.2 | 377.5 | 393.5 | 410.1 |
Revenue Growth, % | 0 | 0.60545 | 8.62 | 6.06 | 1.62 | 4.23 | 4.23 | 4.23 | 4.23 | 4.23 |
EBITDA | 124.6 | 68.8 | 161.3 | 146.5 | 109.9 | 137.6 | 143.4 | 149.4 | 155.7 | 162.3 |
EBITDA, % | 44 | 24.17 | 52.13 | 44.64 | 32.96 | 39.58 | 39.58 | 39.58 | 39.58 | 39.58 |
Depreciation | 8.5 | 6.8 | 6.7 | 6.5 | 16.0 | 10.0 | 10.4 | 10.8 | 11.3 | 11.7 |
Depreciation, % | 3.01 | 2.37 | 2.15 | 1.99 | 4.8 | 2.86 | 2.86 | 2.86 | 2.86 | 2.86 |
EBIT | 116.0 | 62.1 | 154.6 | 139.9 | 93.9 | 127.6 | 133.0 | 138.6 | 144.5 | 150.6 |
EBIT, % | 40.99 | 21.8 | 49.97 | 42.65 | 28.17 | 36.71 | 36.71 | 36.71 | 36.71 | 36.71 |
Total Cash | 580.4 | 1,181.3 | 1,048.6 | 1,039.7 | 133.0 | 305.8 | 318.7 | 332.2 | 346.2 | 360.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
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 | -5.0 | -2.9 | -4.8 | -7.4 | -12.4 | -7.2 | -7.5 | -7.8 | -8.1 | -8.4 |
Capital Expenditure, % | -1.77 | -1.02 | -1.55 | -2.25 | -3.71 | -2.06 | -2.06 | -2.06 | -2.06 | -2.06 |
Tax Rate, % | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 | 20.14 |
EBITAT | 87.7 | 47.6 | 115.4 | 109.7 | 75.0 | 98.3 | 102.5 | 106.8 | 111.3 | 116.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 91.2 | 51.5 | 117.3 | 108.9 | 78.6 | 101.1 | 105.4 | 109.9 | 114.5 | 119.3 |
WACC, % | 10.72 | 10.83 | 10.63 | 10.99 | 11.13 | 10.86 | 10.86 | 10.86 | 10.86 | 10.86 |
PV UFCF | ||||||||||
SUM PV UFCF | 404.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 122 | |||||||||
Terminal Value | 1,374 | |||||||||
Present Terminal Value | 821 | |||||||||
Enterprise Value | 1,226 | |||||||||
Net Debt | 1,276 | |||||||||
Equity Value | -50 | |||||||||
Diluted Shares Outstanding, MM | 88 | |||||||||
Equity Value Per Share | -0.57 |
What You Will Get
- Real Brookline Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Brookline Bancorp, Inc. (BRKL).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Brookline Bancorp, Inc. (BRKL).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Brookline Bancorp, Inc. (BRKL)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Brookline Bancorp, Inc. (BRKL).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Brookline Bancorp, Inc. (BRKL).
Key Features
- Customizable Financial Metrics: Adjust essential inputs such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Brookline Bancorp's real-world financial data for precise valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes.
- Efficiency Booster: Streamlines the valuation process, eliminating the need for complex model creation.
How It Works
- 1. Access the Template: Download and open the Excel file containing Brookline Bancorp, Inc.'s (BRKL) preloaded financial data.
- 2. Adjust Assumptions: Modify key parameters such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation scenarios.
- 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Brookline Bancorp, Inc. (BRKL)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Brookline Bancorp, Inc. (BRKL).
- Flexible Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes the intrinsic value and Net Present Value for Brookline Bancorp, Inc. (BRKL).
- Preloaded Information: Historical and projected data provide reliable benchmarks for analysis.
- Expert-Level Tool: Designed for financial analysts, investors, and business consultants focusing on Brookline Bancorp, Inc. (BRKL).
Who Should Use Brookline Bancorp, Inc. (BRKL)?
- Finance Students: Explore banking valuation methods and apply them using real-world data.
- Academics: Integrate industry-specific models into your research or educational materials.
- Investors: Evaluate your investment strategies and assess the valuation performance of Brookline Bancorp, Inc. (BRKL).
- Analysts: Enhance your analysis with a user-friendly, customizable DCF model tailored for banking institutions.
- Small Business Owners: Understand how public banking companies like Brookline Bancorp, Inc. (BRKL) are evaluated and analyzed.
What the Template Contains
- Pre-Filled DCF Model: Brookline Bancorp’s (BRKL) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored for Brookline Bancorp.
- Financial Ratios: Assess Brookline Bancorp’s profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to align with your scenarios.
- Financial Statements: Access annual and quarterly reports to facilitate comprehensive analysis.
- Interactive Dashboard: Effortlessly visualize key valuation metrics and results for Brookline Bancorp.