Five Star Bancorp (FSBC) DCF Valuation

Five Star Bancorp (FSBC) 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

Five Star Bancorp (FSBC) 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:

Designed for accuracy, our FSBC (Five Star Bancorp) DCF Calculator enables you to evaluate the valuation of Five Star Bancorp with real-world financial data, offering complete flexibility to modify all key parameters for improved projections.


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 58.0 73.8 83.8 108.9 117.2 140.2 167.6 200.5 239.7 286.7
Revenue Growth, % 0 27.21 13.64 29.93 7.58 19.59 19.59 19.59 19.59 19.59
EBITDA 30.8 37.7 47.8 -1.2 .0 44.9 53.7 64.2 76.8 91.8
EBITDA, % 53.1 51.12 56.96 -1.09 0 32.02 32.02 32.02 32.02 32.02
Depreciation .4 .5 .6 1.6 1.6 1.4 1.7 2.0 2.4 2.9
Depreciation, % 0.74659 0.62483 0.72395 1.5 1.38 0.99451 0.99451 0.99451 0.99451 0.99451
EBIT 30.4 37.3 47.1 -2.8 -1.6 43.5 52.0 62.2 74.4 88.9
EBIT, % 52.35 50.49 56.23 -2.59 -1.38 31.02 31.02 31.02 31.02 31.02
Total Cash 274.5 429.1 588.6 385.8 113.5 139.3 166.6 199.2 238.2 284.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 5.4 21.6 7.5 22.6
Account Receivables, % 0 7.35 25.79 6.84 19.27
Inventories -200.8 -319.6 -445.1 -303.9 .0 -112.1 -134.1 -160.4 -191.8 -229.4
Inventories, % -346.21 -433.21 -530.88 -278.98 0 -80 -80 -80 -80 -80
Accounts Payable 6.0 7.7 7.4 14.5 .0 12.0 14.4 17.2 20.6 24.6
Accounts Payable, % 10.31 10.39 8.87 13.29 0 8.57 8.57 8.57 8.57 8.57
Capital Expenditure -.5 -.8 -.7 -.5 -.7 -1.1 -1.3 -1.5 -1.9 -2.2
Capital Expenditure, % -0.87591 -1.13 -0.85514 -0.44153 -0.55717 -0.77176 -0.77176 -0.77176 -0.77176 -0.77176
Tax Rate, % 28.34 28.34 28.34 28.34 28.34 28.34 28.34 28.34 28.34 28.34
EBITAT 29.3 35.9 42.4 -2.0 -1.2 37.0 44.3 53.0 63.3 75.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 236.0 150.7 151.4 -120.8 -333.7 167.5 65.7 78.6 94.0 112.4
WACC, % 12.27 12.26 11.73 10.18 10.21 11.33 11.33 11.33 11.33 11.33
PV UFCF
SUM PV UFCF 387.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 115
Terminal Value 1,229
Present Terminal Value 718
Enterprise Value 1,106
Net Debt -78
Equity Value 1,184
Diluted Shares Outstanding, MM 17
Equity Value Per Share 68.88

What You Will Receive

  • Pre-Loaded Financial Model: Five Star Bancorp’s (FSBC) actual data facilitates accurate DCF valuation.
  • Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential variables.
  • Real-Time Calculations: Automatic updates provide immediate feedback as you adjust inputs.
  • Professional-Grade Template: A polished Excel file crafted for high-quality valuation.
  • Adaptable and Reusable: Designed for versatility, enabling repeated application for in-depth forecasts.

Key Features

  • Accurate Financial Data for Five Star Bancorp: Access reliable historical data and future forecasts tailored for FSBC.
  • Adjustable Forecast Parameters: Modify highlighted cells for key metrics like WACC, growth rates, and profit margins.
  • Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow metrics.
  • User-Friendly Dashboard: Intuitive charts and summaries to easily interpret your valuation findings.
  • Designed for All Skill Levels: A straightforward layout suitable for investors, CFOs, and consultants alike.

How It Works

  • Download: Obtain the pre-configured Excel file featuring Five Star Bancorp’s (FSBC) financial data.
  • Customize: Tailor your forecasts, such as revenue growth, EBITDA %, and WACC as per your analysis.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time for accurate insights.
  • Test Scenarios: Generate various projections and evaluate outcomes without delay.
  • Make Decisions: Leverage the valuation findings to inform your investment choices.

Why Choose This Calculator for Five Star Bancorp (FSBC)?

  • All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for FSBC.
  • Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
  • In-Depth Analysis: Automatically computes Five Star Bancorp’s intrinsic value and Net Present Value.
  • Included Data: Historical and projected data provide reliable foundations for analysis.
  • High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on FSBC.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Five Star Bancorp (FSBC) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Five Star Bancorp (FSBC).
  • Consultants: Deliver professional valuation insights on Five Star Bancorp (FSBC) to clients quickly and accurately.
  • Business Owners: Understand how companies like Five Star Bancorp (FSBC) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios related to Five Star Bancorp (FSBC).

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Five Star Bancorp (FSBC) 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 Five Star Bancorp (FSBC).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.