HarborOne Bancorp, Inc. (HONE) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
HarborOne Bancorp, Inc. (HONE) Bundle
Explore HarborOne Bancorp, Inc. (HONE) financial future with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate HarborOne Bancorp, Inc. (HONE) intrinsic value 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 | 164.3 | 248.9 | 226.3 | 204.9 | 163.4 | 168.6 | 174.0 | 179.5 | 185.2 | 191.1 |
| Revenue Growth, % | 0 | 51.5 | -9.09 | -9.46 | -20.23 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
| EBITDA | .0 | 48.0 | 70.2 | 56.6 | 20.6 | 30.6 | 31.5 | 32.5 | 33.6 | 34.6 |
| EBITDA, % | 0 | 19.3 | 31.04 | 27.62 | 12.62 | 18.12 | 18.12 | 18.12 | 18.12 | 18.12 |
| Depreciation | 6.7 | 5.7 | 5.6 | 4.8 | 4.6 | 4.7 | 4.9 | 5.0 | 5.2 | 5.4 |
| Depreciation, % | 4.1 | 2.28 | 2.48 | 2.35 | 2.81 | 2.81 | 2.81 | 2.81 | 2.81 | 2.81 |
| EBIT | -6.7 | 42.4 | 64.6 | 51.8 | 16.0 | 25.8 | 26.6 | 27.5 | 28.4 | 29.3 |
| EBIT, % | -4.1 | 17.02 | 28.55 | 25.27 | 9.81 | 15.31 | 15.31 | 15.31 | 15.31 | 15.31 |
| Total Cash | 451.1 | 482.4 | 588.8 | 399.2 | 227.4 | 168.6 | 174.0 | 179.5 | 185.2 | 191.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 9.8 | 11.9 | 10.6 | 15.1 | 18.2 | 11.4 | 11.8 | 12.2 | 12.6 | 13.0 |
| Account Receivables, % | 5.97 | 4.77 | 4.69 | 7.39 | 11.12 | 6.79 | 6.79 | 6.79 | 6.79 | 6.79 |
| Inventories | -230.7 | -218.3 | -206.3 | -113.2 | .0 | -112.7 | -116.3 | -120.0 | -123.8 | -127.7 |
| Inventories, % | -140.39 | -87.71 | -91.15 | -55.22 | 0 | -66.82 | -66.82 | -66.82 | -66.82 | -66.82 |
| Accounts Payable | 1.7 | 1.3 | 1.1 | 2.3 | 5.3 | 2.1 | 2.2 | 2.3 | 2.4 | 2.4 |
| Accounts Payable, % | 1.02 | 0.50696 | 0.47853 | 1.13 | 3.21 | 1.27 | 1.27 | 1.27 | 1.27 | 1.27 |
| Capital Expenditure | -4.4 | -5.7 | -6.5 | -2.3 | -4.5 | -3.9 | -4.1 | -4.2 | -4.3 | -4.5 |
| Capital Expenditure, % | -2.7 | -2.31 | -2.85 | -1.11 | -2.74 | -2.34 | -2.34 | -2.34 | -2.34 | -2.34 |
| Tax Rate, % | 36.01 | 36.01 | 36.01 | 36.01 | 36.01 | 36.01 | 36.01 | 36.01 | 36.01 | 36.01 |
| EBITAT | -5.4 | 32.7 | 47.0 | 38.2 | 10.3 | 19.0 | 19.6 | 20.2 | 20.9 | 21.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 219.4 | 17.8 | 35.2 | -55.6 | -102.9 | 136.1 | 23.7 | 24.5 | 25.3 | 26.1 |
| WACC, % | 12.47 | 12.11 | 11.63 | 11.75 | 10.69 | 11.73 | 11.73 | 11.73 | 11.73 | 11.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 189.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 27 | |||||||||
| Terminal Value | 273 | |||||||||
| Present Terminal Value | 157 | |||||||||
| Enterprise Value | 346 | |||||||||
| Net Debt | 341 | |||||||||
| Equity Value | 5 | |||||||||
| Diluted Shares Outstanding, MM | 43 | |||||||||
| Equity Value Per Share | 0.12 |
What You Will Get
- Real HarborOne Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for HarborOne Bancorp, Inc. (HONE).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specifically for HarborOne Bancorp, Inc. (HONE).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on HarborOne Bancorp, Inc.'s (HONE) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections related to HarborOne Bancorp, Inc. (HONE).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for HarborOne Bancorp, Inc. (HONE).
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 additional metrics without delay.
- High-Precision Accuracy: Leverages HarborOne Bancorp's (HONE) actual financial data for credible valuation results.
- Simplified Scenario Analysis: Evaluate various assumptions and analyze results effortlessly.
- Efficiency Booster: Streamline the valuation process, removing the need to construct intricate models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based HONE DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates HarborOne Bancorp’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for HarborOne Bancorp, Inc. (HONE)?
- Accurate Data: Utilize real HarborOne financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
- User-Friendly: Easy-to-navigate interface and clear instructions cater to users of all experience levels.
Who Should Use This Product?
- Finance Students: Master financial analysis techniques and apply them to real-world data.
- Academics: Integrate advanced financial models into your teaching or research projects.
- Investors: Validate your investment strategies and evaluate the financial performance of HarborOne Bancorp, Inc. (HONE).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model.
- Small Business Owners: Understand how financial institutions like HarborOne Bancorp, Inc. (HONE) are assessed and valued.
What the Template Contains
- Pre-Filled Data: Includes HarborOne Bancorp, Inc.'s (HONE) 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 HarborOne Bancorp, Inc.'s (HONE) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.