CF Bankshares Inc. (CFBK) DCF Valuation

CF Bankshares Inc. (CFBK) DCF Valuation
  • ✓ 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

CF Bankshares Inc. (CFBK) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

As an investor or analyst, this [Symbol] DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from CF Bankshares Inc., you can adjust forecasts and instantly observe the effects.


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 33.2 87.5 53.3 51.3 51.1 58.3 66.5 76.0 86.7 99.0
Revenue Growth, % 0 163.64 -39.05 -3.79 -0.49507 14.17 14.17 14.17 14.17 14.17
EBITDA 12.4 36.7 .0 .0 .0 9.2 10.5 12.0 13.7 15.7
EBITDA, % 37.23 41.9 0 0 0 15.83 15.83 15.83 15.83 15.83
Depreciation .3 .4 .4 .5 -.5 .3 .3 .3 .4 .5
Depreciation, % 0.95215 0.43544 0.81572 0.96675 -0.89517 0.45498 0.45498 0.45498 0.45498 0.45498
EBIT 12.0 36.3 -.4 -.5 .5 9.0 10.2 11.7 13.3 15.2
EBIT, % 36.28 41.47 -0.81572 -0.96675 0.89517 15.37 15.37 15.37 15.37 15.37
Total Cash 54.2 230.4 183.0 162.3 269.7 58.3 66.5 76.0 86.7 99.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 .0 .0 .0 .0
Account Receivables, % 0 0 0 0 0
Inventories -48.7 -226.3 -170.8 -162.0 .0 -46.6 -53.2 -60.8 -69.4 -79.2
Inventories, % -146.82 -258.61 -320.35 -315.72 0 -80 -80 -80 -80 -80
Accounts Payable 6.8 21.9 14.5 23.7 .0 13.9 15.8 18.1 20.6 23.6
Accounts Payable, % 20.63 25.01 27.22 46.13 0 23.8 23.8 23.8 23.8 23.8
Capital Expenditure -.4 -.4 -3.0 -.9 -.7 -1.2 -1.4 -1.6 -1.8 -2.1
Capital Expenditure, % -1.33 -0.44002 -5.55 -1.76 -1.29 -2.08 -2.08 -2.08 -2.08 -2.08
Tax Rate, % 19.29 19.29 19.29 19.29 19.29 19.29 19.29 19.29 19.29 19.29
EBITAT 9.6 29.6 -.4 -.4 .4 7.2 8.3 9.4 10.8 12.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 65.0 222.2 -65.7 -.5 -186.4 66.8 15.7 18.0 20.5 23.4
WACC, % 20.78 21.18 21.02 20.92 20.99 20.98 20.98 20.98 20.98 20.98
PV UFCF
SUM PV UFCF 94.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 24
Terminal Value 126
Present Terminal Value 49
Enterprise Value 143
Net Debt -131
Equity Value 275
Diluted Shares Outstanding, MM 6
Equity Value Per Share 42.61

What You Will Get

  • Editable Forecast Inputs: Easily adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Real-World Data: CF Bankshares Inc.’s (CFBK) financial information pre-filled to streamline your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Customizable Financial Parameters: Adjust essential inputs such as loan growth, interest rates, and operational expenses.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional metrics with ease.
  • High-Precision Accuracy: Leverages CF Bankshares Inc.'s (CFBK) real financial data for credible valuation results.
  • Effortless Scenario Testing: Evaluate various assumptions and analyze results without hassle.
  • Efficiency Booster: Avoid the complexity of creating intricate valuation models from the ground up.

How It Works

  • Step 1: Download the prebuilt Excel template featuring CF Bankshares Inc. (CFBK) 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 see recalculated results, including CF Bankshares Inc.'s (CFBK) intrinsic value.
  • Step 5: Make well-informed investment decisions or create reports based on the outputs.

Why Choose This Calculator for CF Bankshares Inc. (CFBK)?

  • Comprehensive Tool: Combines DCF, WACC, and financial ratio analyses tailored for CF Bankshares Inc. (CFBK).
  • Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios for CF Bankshares Inc. (CFBK).
  • Detailed Insights: Automatically computes CF Bankshares Inc. (CFBK)'s intrinsic value and Net Present Value.
  • Preloaded Data: Historical and projected data provide a solid foundation for analysis of CF Bankshares Inc. (CFBK).
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on CF Bankshares Inc. (CFBK).

Who Should Use This Product?

  • Investors: Evaluate CF Bankshares Inc. (CFBK) to inform your investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and assess financial forecasts.
  • Startup Founders: Understand the valuation practices of established financial institutions like CF Bankshares Inc. (CFBK).
  • Consultants: Provide detailed valuation assessments and reports for your clients.
  • Students and Educators: Utilize real-time data to learn and teach financial valuation strategies.

What the Template Contains

  • Preloaded CFBK Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.