|
CFSB Bancorp, Inc. (CFSB) Valoración de DCF
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
CFSB Bancorp, Inc. (CFSB) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (CFSB)! Utilizando datos reales de CFSB Bancorp, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar CFSB como un inversor experimentado.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 8.3 | 8.0 | 8.9 | 9.4 | 7.5 | 7.4 | 7.2 | 7.1 | 7.0 | 6.9 |
Revenue Growth, % | 0 | -3.06 | 10.56 | 5.81 | -20.38 | -1.77 | -1.77 | -1.77 | -1.77 | -1.77 |
EBITDA | 2.6 | 1.9 | .0 | 2.0 | .0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.0 |
EBITDA, % | 31.78 | 23.7 | 0 | 21.05 | 0 | 15.31 | 15.31 | 15.31 | 15.31 | 15.31 |
Depreciation | .2 | .3 | .3 | .2 | .2 | .2 | .2 | .2 | .2 | .2 |
Depreciation, % | 2.85 | 3.35 | 2.87 | 2.5 | 3.17 | 2.95 | 2.95 | 2.95 | 2.95 | 2.95 |
EBIT | 2.4 | 1.6 | -.3 | 1.7 | -.2 | .9 | .9 | .9 | .9 | .8 |
EBIT, % | 28.93 | 20.35 | -2.87 | 18.55 | -3.17 | 12.36 | 12.36 | 12.36 | 12.36 | 12.36 |
Total Cash | 38.7 | 44.0 | 31.9 | 7.0 | 27.0 | 7.0 | 6.9 | 6.7 | 6.6 | 6.5 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | 1.3 | 1.4 | 1.4 | .7 | .7 | .7 | .7 | .6 |
Account Receivables, % | 0 | 0 | 14.22 | 14.48 | 18.65 | 9.47 | 9.47 | 9.47 | 9.47 | 9.47 |
Inventories | -39.5 | -42.8 | -32.9 | -8.2 | .0 | -5.7 | -5.6 | -5.5 | -5.4 | -5.3 |
Inventories, % | -475.27 | -531.79 | -370.06 | -87.34 | 0 | -77.47 | -77.47 | -77.47 | -77.47 | -77.47 |
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 | -.1 | -.3 | -.1 | -.2 | -.2 | -.2 | -.2 | -.2 |
Capital Expenditure, % | -7.91 | -2.65 | -1.46 | -3.33 | -0.94705 | -3.26 | -3.26 | -3.26 | -3.26 | -3.26 |
Tax Rate, % | 650 | 650 | 650 | 650 | 650 | 650 | 650 | 650 | 650 | 650 |
EBITAT | 2.1 | 1.4 | -.3 | 1.4 | 1.3 | .6 | .6 | .6 | .6 | .6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 41.1 | 4.8 | -11.3 | -23.4 | -6.8 | 7.0 | .5 | .5 | .5 | .5 |
WACC, % | 12.2 | 12.09 | 13.47 | 11.89 | 4.27 | 10.78 | 10.78 | 10.78 | 10.78 | 10.78 |
PV UFCF | ||||||||||
SUM PV UFCF | 7.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1 | |||||||||
Terminal Value | 6 | |||||||||
Present Terminal Value | 3 | |||||||||
Enterprise Value | 11 | |||||||||
Net Debt | -16 | |||||||||
Equity Value | 27 | |||||||||
Diluted Shares Outstanding, MM | 6 | |||||||||
Equity Value Per Share | 4.28 |
What You Will Receive
- Comprehensive Financial Model: CFSB Bancorp, Inc.'s (CFSB) actual data facilitates accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth, profit margins, WACC, and other essential variables.
- Real-Time Calculations: Automatic updates guarantee immediate visibility of results as adjustments are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasting.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for CFSB Bancorp, Inc. (CFSB).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to CFSB.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit CFSB's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to CFSB Bancorp, Inc. (CFSB).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for quick and effective analysis of CFSB.
How It Operates
- Download the Template: Gain immediate access to the Excel-based CFSB DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates CFSB's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for CFSB Bancorp, Inc. (CFSB)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Updates: Instantly observe changes in CFSB's valuation as you modify inputs.
- Pre-Loaded Data: Comes with CFSB's actual financial information for immediate analysis.
- Relied Upon by Experts: Favored by investors and analysts for making well-informed choices.
Who Should Use CFSB Bancorp, Inc. (CFSB)?
- Investors: Evaluate CFSB’s financial health before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established financial institutions like CFSB.
- Consultants: Create detailed valuation reports and analyses for clients in the banking sector.
- Students and Educators: Utilize real data from CFSB to teach and learn about financial valuation practices.
What the Template Contains
- Historical Data: Includes CFSB Bancorp, Inc.'s (CFSB) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate CFSB Bancorp, Inc.'s (CFSB) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of CFSB Bancorp, Inc.'s (CFSB) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.