|
Valoración de DCF de Columbia Financial, Inc. (CLBK)
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Columbia Financial, Inc. (CLBK) Bundle
¡Descubra el verdadero potencial de Columbia Financial, Inc. (CLBK) con nuestra calculadora DCF avanzada! Ajuste los supuestos críticos, explore varios escenarios y evalúe los efectos de los cambios en la valoración de Columbia Financial, todo dentro de una sola plantilla de Excel.
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 | 204.0 | 252.8 | 272.0 | 297.2 | 233.3 | 244.5 | 256.3 | 268.6 | 281.5 | 295.1 |
| Revenue Growth, % | 0 | 23.94 | 7.56 | 9.27 | -21.51 | 4.82 | 4.82 | 4.82 | 4.82 | 4.82 |
| EBITDA | 76.1 | 86.6 | 137.8 | 130.2 | -.2 | 81.1 | 85.0 | 89.1 | 93.4 | 97.9 |
| EBITDA, % | 37.29 | 34.26 | 50.68 | 43.82 | -0.10246 | 33.19 | 33.19 | 33.19 | 33.19 | 33.19 |
| Depreciation | 5.1 | 10.2 | 11.4 | 13.1 | 14.0 | 10.3 | 10.8 | 11.4 | 11.9 | 12.5 |
| Depreciation, % | 2.5 | 4.05 | 4.18 | 4.41 | 6.02 | 4.23 | 4.23 | 4.23 | 4.23 | 4.23 |
| EBIT | 71.0 | 76.4 | 126.4 | 117.1 | -14.3 | 70.8 | 74.2 | 77.8 | 81.5 | 85.4 |
| EBIT, % | 34.79 | 30.21 | 46.49 | 39.41 | -6.12 | 28.96 | 28.96 | 28.96 | 28.96 | 28.96 |
| Total Cash | 1,173.9 | 1,739.9 | 1,774.8 | 1,507.9 | 423.2 | 244.5 | 256.3 | 268.6 | 281.5 | 295.1 |
| 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 | -97.6 | -452.4 | -99.3 | -213.1 | .0 | -125.2 | -131.2 | -137.6 | -144.2 | -151.1 |
| Inventories, % | -47.86 | -178.93 | -36.5 | -71.72 | 0 | -51.22 | -51.22 | -51.22 | -51.22 | -51.22 |
| 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 | -19.3 | -4.6 | -5.5 | -7.2 | -7.6 | -9.3 | -9.8 | -10.2 | -10.7 | -11.2 |
| Capital Expenditure, % | -9.48 | -1.83 | -2.02 | -2.42 | -3.27 | -3.81 | -3.81 | -3.81 | -3.81 | -3.81 |
| Tax Rate, % | 21.64 | 21.64 | 21.64 | 21.64 | 21.64 | 21.64 | 21.64 | 21.64 | 21.64 | 21.64 |
| EBITAT | 54.6 | 57.7 | 92.2 | 86.3 | -11.2 | 53.5 | 56.0 | 58.7 | 61.6 | 64.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 138.0 | 418.1 | -255.0 | 206.1 | -217.9 | 179.7 | 63.2 | 66.2 | 69.4 | 72.7 |
| WACC, % | 7.39 | 7.31 | 7.15 | 7.2 | 7.48 | 7.31 | 7.31 | 7.31 | 7.31 | 7.31 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 379.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 74 | |||||||||
| Terminal Value | 1,398 | |||||||||
| Present Terminal Value | 983 | |||||||||
| Enterprise Value | 1,362 | |||||||||
| Net Debt | 1,105 | |||||||||
| Equity Value | 257 | |||||||||
| Diluted Shares Outstanding, MM | 103 | |||||||||
| Equity Value Per Share | 2.49 |
What You Will Receive
- Adjustable Financial Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Columbia Financial, Inc.’s (CLBK) financial information pre-loaded to facilitate your analysis.
- Automated DCF Calculations: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Tailored and Professional Design: A refined Excel model that can be customized to fit your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating forecasts, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life CLBK Financials: Pre-filled historical and projected data for Columbia Financial, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Columbia’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Columbia’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template featuring Columbia Financial, Inc.'s (CLBK) 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 view updated results, including Columbia Financial, Inc.'s (CLBK) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create comprehensive reports.
Why Choose Columbia Financial, Inc. (CLBK) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses for comprehensive evaluation.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Columbia Financial’s intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for reliable analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Investors: Assess Columbia Financial, Inc.'s (CLBK) performance before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of established financial institutions like Columbia Financial, Inc.
- Consultants: Provide comprehensive valuation assessments for your clients.
- Students and Educators: Utilize current market data to learn and teach financial valuation principles.
What the Template Contains
- Pre-Filled Data: Features Columbia Financial, Inc.'s (CLBK) historical financials and projections.
- Discounted Cash Flow Model: An editable DCF valuation model with automated calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for computing WACC based on user-defined inputs.
- Key Financial Ratios: Assess Columbia Financial, Inc.'s (CLBK) profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation outcomes.