ConnectOne Bancorp, Inc. (CNOB) 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
ConnectOne Bancorp, Inc. (CNOB) Bundle
Whether you’re an investor or an analyst, this (CNOB) DCF Calculator is your go-to resource for accurate valuation. Preloaded with real data from ConnectOne Bancorp, Inc., you can easily 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 | 194.4 | 252.4 | 277.9 | 315.4 | 269.1 | 295.2 | 323.8 | 355.2 | 389.7 | 427.4 |
Revenue Growth, % | 0 | 29.86 | 10.1 | 13.48 | -14.67 | 9.7 | 9.7 | 9.7 | 9.7 | 9.7 |
EBITDA | 98.5 | 97.2 | 180.8 | 176.8 | 122.9 | 151.1 | 165.8 | 181.8 | 199.5 | 218.8 |
EBITDA, % | 50.67 | 38.51 | 65.06 | 56.05 | 45.67 | 51.19 | 51.19 | 51.19 | 51.19 | 51.19 |
Depreciation | 4.5 | 6.8 | 5.7 | 5.5 | 5.9 | 6.5 | 7.1 | 7.8 | 8.6 | 9.4 |
Depreciation, % | 2.3 | 2.7 | 2.06 | 1.76 | 2.21 | 2.2 | 2.2 | 2.2 | 2.2 | 2.2 |
EBIT | 94.0 | 90.4 | 175.1 | 171.2 | 117.0 | 144.6 | 158.6 | 174.0 | 190.9 | 209.4 |
EBIT, % | 48.38 | 35.81 | 62.99 | 54.29 | 43.46 | 48.99 | 48.99 | 48.99 | 48.99 | 48.99 |
Total Cash | 606.2 | 791.7 | 800.0 | 903.2 | 678.6 | 295.2 | 323.8 | 355.2 | 389.7 | 427.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 20.9 | 35.3 | 34.2 | 46.1 | 49.1 | 41.3 | 45.3 | 49.7 | 54.5 | 59.8 |
Account Receivables, % | 10.78 | 13.99 | 12.29 | 14.61 | 18.25 | 13.98 | 13.98 | 13.98 | 13.98 | 13.98 |
Inventories | -222.4 | -339.1 | -299.7 | -314.6 | .0 | -236.0 | -258.9 | -284.0 | -311.5 | -341.8 |
Inventories, % | -114.45 | -134.34 | -107.84 | -99.77 | 0 | -79.95 | -79.95 | -79.95 | -79.95 | -79.95 |
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.5 | -2.2 | -2.8 | -3.3 | -7.4 | -3.8 | -4.2 | -4.6 | -5.0 | -5.5 |
Capital Expenditure, % | -0.78568 | -0.87127 | -1 | -1.05 | -2.76 | -1.29 | -1.29 | -1.29 | -1.29 | -1.29 |
Tax Rate, % | 25.61 | 25.61 | 25.61 | 25.61 | 25.61 | 25.61 | 25.61 | 25.61 | 25.61 | 25.61 |
EBITAT | 73.4 | 71.3 | 130.4 | 125.2 | 87.0 | 109.6 | 120.2 | 131.9 | 144.7 | 158.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 277.8 | 178.2 | 95.1 | 130.5 | -232.2 | 356.1 | 142.0 | 155.8 | 170.9 | 187.5 |
WACC, % | 14.37 | 14.47 | 13.92 | 13.76 | 13.91 | 14.09 | 14.09 | 14.09 | 14.09 | 14.09 |
PV UFCF | ||||||||||
SUM PV UFCF | 724.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 191 | |||||||||
Terminal Value | 1,582 | |||||||||
Present Terminal Value | 819 | |||||||||
Enterprise Value | 1,543 | |||||||||
Net Debt | 783 | |||||||||
Equity Value | 759 | |||||||||
Diluted Shares Outstanding, MM | 39 | |||||||||
Equity Value Per Share | 19.49 |
What You Will Get
- Pre-Filled Financial Model: ConnectOne Bancorp, Inc.'s (CNOB) actual data facilitates accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you view results as you implement changes.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, allowing repeated application for comprehensive forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for ConnectOne Bancorp, Inc. (CNOB).
- WACC Calculator: Includes a pre-built Weighted Average Cost of Capital sheet with customizable inputs specific to CNOB.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit ConnectOne's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to ConnectOne Bancorp, Inc. (CNOB).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review ConnectOne Bancorp, Inc.'s (CNOB) pre-filled financial data and forecasts.
- Step 3: Modify critical inputs such as loan growth, cost of capital, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose This Calculator for ConnectOne Bancorp, Inc. (CNOB)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for ConnectOne Bancorp.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes ConnectOne Bancorp’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on ConnectOne Bancorp.
Who Should Use ConnectOne Bancorp, Inc. (CNOB)?
- Investors: Gain insights into banking performance with our comprehensive financial analysis tools.
- Financial Analysts: Streamline your workflow with our pre-designed financial models tailored for the banking sector.
- Consultants: Easily customize reports and presentations for your clients using our adaptable templates.
- Finance Enthusiasts: Enhance your knowledge of banking operations and valuation strategies with practical examples.
- Educators and Students: Utilize our resources as a hands-on learning aid in finance and banking courses.
What the Template Contains
- Pre-Filled DCF Model: ConnectOne Bancorp, Inc.’s (CNOB) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate ConnectOne Bancorp, Inc.’s (CNOB) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.