Cullman Bancorp, Inc. (CULL) 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
Cullman Bancorp, Inc. (CULL) Bundle
Looking to determine the intrinsic value of Cullman Bancorp, Inc.? Our CULL DCF Calculator integrates real-world data with extensive customization options, enabling you to refine your forecasts and enhance your investment choices.
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 | 15.8 | 12.8 | 13.1 | 16.9 | 16.9 | 17.4 | 18.0 | 18.5 | 19.1 | 19.7 |
Revenue Growth, % | 0 | -19.21 | 2.66 | 28.69 | 0.24926 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 |
EBITDA | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
EBITDA, % | -0.25339 | 0 | 0 | 0 | 0 | -0.05067782 | -0.05067782 | -0.05067782 | -0.05067782 | -0.05067782 |
Depreciation | -4.8 | .4 | .4 | .5 | .5 | -.6 | -.7 | -.7 | -.7 | -.7 |
Depreciation, % | -30.34 | 3.29 | 3.38 | 2.78 | 2.78 | -3.62 | -3.62 | -3.62 | -3.62 | -3.62 |
EBIT | 4.7 | -.4 | -.4 | -.5 | -.5 | .6 | .6 | .7 | .7 | .7 |
EBIT, % | 30.08 | -3.29 | -3.38 | -2.78 | -2.78 | 3.57 | 3.57 | 3.57 | 3.57 | 3.57 |
Total Cash | 6.1 | 22.0 | 23.5 | 30.2 | 32.7 | 15.3 | 15.8 | 16.2 | 16.7 | 17.3 |
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 | .0 | -61.8 | -63.1 | -37.9 | .0 | -10.4 | -10.8 | -11.1 | -11.5 | -11.8 |
Inventories, % | 0 | -484.52 | -482.04 | -224.67 | 0 | -60 | -60 | -60 | -60 | -60 |
Accounts Payable | .0 | .1 | .1 | .2 | .2 | .1 | .1 | .1 | .1 | .1 |
Accounts Payable, % | 0 | 0.78407 | 0.45826 | 0.91988 | 1.41 | 0.71542 | 0.71542 | 0.71542 | 0.71542 | 0.71542 |
Capital Expenditure | -.3 | -.4 | -1.3 | -1.7 | -3.6 | -1.6 | -1.7 | -1.7 | -1.8 | -1.9 |
Capital Expenditure, % | -1.94 | -3.37 | -9.97 | -10.34 | -21.49 | -9.42 | -9.42 | -9.42 | -9.42 | -9.42 |
Tax Rate, % | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 | 21.72 |
EBITAT | 3.7 | -.3 | -.4 | -.4 | -.4 | .5 | .5 | .5 | .5 | .6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1.4 | 61.6 | .0 | -26.8 | -41.3 | 8.6 | -1.5 | -1.6 | -1.6 | -1.6 |
WACC, % | 6.81 | 6.82 | 7.02 | 6.84 | 6.8 | 6.86 | 6.86 | 6.86 | 6.86 | 6.86 |
PV UFCF | ||||||||||
SUM PV UFCF | 3.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -2 | |||||||||
Terminal Value | -35 | |||||||||
Present Terminal Value | -25 | |||||||||
Enterprise Value | -22 | |||||||||
Net Debt | 31 | |||||||||
Equity Value | -52 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | -7.31 |
What You Will Get
- Real Cullman Bancorp Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Cullman Bancorp’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Provides immediate calculations of intrinsic value, NPV, and additional financial metrics.
- High-Precision Accuracy: Leverages Cullman Bancorp's actual financial data for trustworthy valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze the resulting impacts.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download: Obtain the pre-built Excel file featuring Cullman Bancorp, Inc.'s (CULL) financial data.
- Customize: Tailor your forecasts, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and compare results instantly.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Cullman Bancorp, Inc. (CULL)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one solution.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes Cullman 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 advisors focusing on (CULL).
Who Should Use This Product?
- Investors: Evaluate Cullman Bancorp, Inc.'s (CULL) performance before making investment decisions.
- CFOs and Financial Analysts: Enhance financial analysis and refine valuation methodologies.
- Startup Founders: Understand the valuation strategies of established financial institutions like Cullman Bancorp, Inc. (CULL).
- Consultants: Provide comprehensive valuation insights and reports for your clients.
- Students and Educators: Utilize authentic financial data to explore and teach valuation principles.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Cullman Bancorp, Inc. (CULL) 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 Cullman Bancorp, Inc. (CULL).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.