Eastern Bankshares, Inc. (EBC) 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
Eastern Bankshares, Inc. (EBC) Bundle
Explore the financial future of Eastern Bankshares, Inc. (EBC) with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine the intrinsic value of Eastern Bankshares, Inc. (EBC) and enhance 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 | 593.6 | 572.9 | 616.5 | 737.8 | 308.2 | 281.7 | 257.4 | 235.3 | 215.0 | 196.5 |
Revenue Growth, % | 0 | -3.48 | 7.61 | 19.69 | -58.23 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 |
EBITDA | 194.1 | 63.8 | 211.6 | 261.6 | .0 | 64.0 | 58.5 | 53.5 | 48.9 | 44.7 |
EBITDA, % | 32.69 | 11.14 | 34.32 | 35.46 | 0 | 22.72 | 22.72 | 22.72 | 22.72 | 22.72 |
Depreciation | 19.4 | 15.9 | 14.5 | 14.4 | 23.6 | 10.1 | 9.3 | 8.5 | 7.7 | 7.1 |
Depreciation, % | 3.28 | 2.77 | 2.35 | 1.95 | 7.67 | 3.6 | 3.6 | 3.6 | 3.6 | 3.6 |
EBIT | 174.6 | 48.0 | 197.1 | 247.3 | -23.6 | 53.9 | 49.2 | 45.0 | 41.1 | 37.6 |
EBIT, % | 29.42 | 8.37 | 31.97 | 33.51 | -7.67 | 19.12 | 19.12 | 19.12 | 19.12 | 19.12 |
Total Cash | 1,870.8 | 5,237.9 | 9,743.0 | 6,860.3 | 693.1 | 281.7 | 257.4 | 235.3 | 215.0 | 196.5 |
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 | -7.2 | -5.1 | -5.7 | -8.6 | -8.1 | -3.9 | -3.5 | -3.2 | -2.9 | -2.7 |
Capital Expenditure, % | -1.21 | -0.89789 | -0.92917 | -1.17 | -2.64 | -1.37 | -1.37 | -1.37 | -1.37 | -1.37 |
Tax Rate, % | 284.27 | 284.27 | 284.27 | 284.27 | 284.27 | 284.27 | 284.27 | 284.27 | 284.27 | 284.27 |
EBITAT | 135.1 | 30.4 | 161.6 | 192.4 | 43.6 | 32.4 | 29.6 | 27.0 | 24.7 | 22.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 147.4 | 41.1 | 170.3 | 198.2 | 59.1 | 38.7 | 35.3 | 32.3 | 29.5 | 27.0 |
WACC, % | 15.16 | 13.94 | 15.55 | 15.2 | 8.47 | 13.66 | 13.66 | 13.66 | 13.66 | 13.66 |
PV UFCF | ||||||||||
SUM PV UFCF | 115.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 28 | |||||||||
Terminal Value | 236 | |||||||||
Present Terminal Value | 124 | |||||||||
Enterprise Value | 240 | |||||||||
Net Debt | -645 | |||||||||
Equity Value | 884 | |||||||||
Diluted Shares Outstanding, MM | 162 | |||||||||
Equity Value Per Share | 5.45 |
What You Will Get
- Real EBC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are automatically computed.
- Scenario Analysis: Evaluate various scenarios to assess Eastern Bankshares, Inc.'s future performance.
- User-Friendly Design: Designed for professionals but easy enough for newcomers to navigate.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Eastern Bankshares, Inc. (EBC).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Adjust growth projections, capital expenditures, and discount rates according to your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Eastern Bankshares, Inc. (EBC).
- Interactive Dashboard and Charts: Visual representations provide a summary of essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Eastern Bankshares, Inc. (EBC) data.
- Step 2: Navigate through the pre-filled sheets to grasp the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Eastern Bankshares, Inc.'s (EBC) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Eastern Bankshares, Inc. (EBC)?
- Accurate Data: Up-to-date financials from Eastern Bankshares ensure dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: Clear layout and step-by-step guidance make it accessible for all users.
Who Should Use Eastern Bankshares, Inc. (EBC)?
- Investors: Gain insights and make informed decisions with our comprehensive financial analysis tools.
- Financial Analysts: Streamline your workflow with our advanced modeling resources tailored for Eastern Bankshares, Inc. (EBC).
- Consultants: Effortlessly customize our templates for impactful client presentations or detailed reports.
- Finance Enthusiasts: Enhance your knowledge of banking and investment strategies through practical examples from Eastern Bankshares, Inc. (EBC).
- Educators and Students: Utilize our resources as a valuable teaching aid in finance and investment courses.
What the Template Contains
- Pre-Filled Data: Includes Eastern Bankshares, Inc.'s (EBC) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Eastern Bankshares, Inc.'s (EBC) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.