Dime Community Bancshares, Inc. (DCOM) 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
Dime Community Bancshares, Inc. (DCOM) Bundle
Whether you're an investor or analyst, this (DCOM) DCF Calculator is your go-to resource for accurate valuation. Preloaded with Dime Community Bancshares, Inc. real data, you can adjust forecasts and observe the effects in real-time.
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 | 159.6 | 180.5 | 399.7 | 418.0 | 350.0 | 438.7 | 550.0 | 689.4 | 864.2 | 1,083.3 |
Revenue Growth, % | 0 | 13.09 | 121.45 | 4.59 | -16.27 | 25.35 | 25.35 | 25.35 | 25.35 | 25.35 |
EBITDA | 70.8 | 60.1 | 158.6 | 222.1 | .0 | 149.6 | 187.5 | 235.0 | 294.6 | 369.3 |
EBITDA, % | 44.38 | 33.27 | 39.68 | 53.13 | 0 | 34.09 | 34.09 | 34.09 | 34.09 | 34.09 |
Depreciation | 5.0 | 4.1 | 9.1 | 9.3 | .0 | 8.7 | 10.9 | 13.7 | 17.2 | 21.5 |
Depreciation, % | 3.16 | 2.27 | 2.28 | 2.22 | 0 | 1.99 | 1.99 | 1.99 | 1.99 | 1.99 |
EBIT | 65.8 | 56.0 | 149.5 | 212.8 | .0 | 140.9 | 176.6 | 221.4 | 277.5 | 347.8 |
EBIT, % | 41.22 | 31 | 37.4 | 50.91 | 0 | 32.11 | 32.11 | 32.11 | 32.11 | 32.11 |
Total Cash | 706.5 | 1,327.2 | 1,957.4 | 1,119.9 | 1,343.8 | 438.7 | 550.0 | 689.4 | 864.2 | 1,083.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | 16.6 | 40.1 | 48.6 | 55.7 | 41.0 | 51.4 | 64.5 | 80.8 | 101.3 |
Account Receivables, % | 0 | 9.18 | 10.05 | 11.62 | 15.9 | 9.35 | 9.35 | 9.35 | 9.35 | 9.35 |
Inventories | -150.0 | -278.4 | -434.4 | -223.3 | .0 | -304.8 | -382.1 | -479.0 | -600.4 | -752.7 |
Inventories, % | -93.99 | -154.26 | -108.69 | -53.41 | 0 | -69.48 | -69.48 | -69.48 | -69.48 | -69.48 |
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 | -1.7 | -5.1 | 957.7 | -3.7 | -5.7 | -5.7 | -7.1 | -8.9 | -11.1 | -14.0 |
Capital Expenditure, % | -1.08 | -2.84 | 239.63 | -0.89589 | -1.63 | -1.29 | -1.29 | -1.29 | -1.29 | -1.29 |
Tax Rate, % | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 |
EBITAT | 50.8 | 42.5 | 104.9 | 153.2 | .0 | 103.0 | 129.1 | 161.8 | 202.9 | 254.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 204.1 | 153.3 | 1,204.2 | -60.8 | -236.1 | 425.5 | 199.8 | 250.5 | 314.0 | 393.6 |
WACC, % | 12.39 | 12.25 | 11.64 | 11.83 | 11.64 | 11.95 | 11.95 | 11.95 | 11.95 | 11.95 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,141.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 401 | |||||||||
Terminal Value | 4,035 | |||||||||
Present Terminal Value | 2,294 | |||||||||
Enterprise Value | 3,436 | |||||||||
Net Debt | 1,111 | |||||||||
Equity Value | 2,325 | |||||||||
Diluted Shares Outstanding, MM | 38 | |||||||||
Equity Value Per Share | 60.88 |
What You Will Get
- Real DCOM Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are automatically computed.
- Scenario Analysis: Evaluate various scenarios to assess Dime Community Bancshares, Inc.'s future performance.
- User-Friendly Design: Crafted for professionals while remaining approachable for newcomers.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other financial metrics.
- High-Precision Accuracy: Incorporates Dime Community Bancshares, Inc.'s (DCOM) actual financial data for reliable valuation results.
- Effortless Scenario Testing: Easily explore various assumptions and evaluate different outcomes.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring Dime Community Bancshares, Inc. (DCOM) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Dime Community Bancshares, Inc.'s (DCOM) intrinsic value.
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose This Calculator for Dime Community Bancshares, Inc. (DCOM)?
- Designed for Financial Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
- Comprehensive Data: Dime Community Bancshares’ historical and forecasted financials are preloaded for enhanced precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions to see potential outcomes.
- Transparent Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Detailed step-by-step guidance ensures a smooth experience.
Who Should Use This Product?
- Investors: Accurately assess Dime Community Bancshares, Inc.'s (DCOM) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting specific to DCOM.
- Consultants: Easily customize the template for valuation reports tailored to Dime Community Bancshares, Inc. (DCOM) clients.
- Entrepreneurs: Discover insights into financial modeling practices employed by leading financial institutions like DCOM.
- Educators: Implement it as a resource to illustrate valuation techniques in financial education.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Dime Community Bancshares, Inc. (DCOM) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Dime Community Bancshares, Inc. (DCOM).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.