Sound Financial Bancorp, Inc. (SFBC) DCF Valuation

Sound Financial Bancorp, Inc. (SFBC) DCF Valuation
  • Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • Aucune Expertise N'Est Requise; Facile À Suivre

Sound Financial Bancorp, Inc. (SFBC) 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:

Simplify Sound Financial Bancorp, Inc. (SFBC) valuation with this customizable DCF Calculator! Featuring real Sound Financial Bancorp, Inc. (SFBC) financials and adjustable forecast inputs, you can test scenarios and uncover Sound Financial Bancorp, Inc. (SFBC) fair value in minutes.


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 31.0 34.9 37.2 39.9 50.6 57.4 65.0 73.7 83.5 94.6
Revenue Growth, % 0 12.72 6.64 7.06 26.91 13.33 13.33 13.33 13.33 13.33
EBITDA 9.9 13.2 13.0 12.5 10.7 18.0 20.4 23.1 26.2 29.7
EBITDA, % 31.79 37.65 34.94 31.28 21.05 31.34 31.34 31.34 31.34 31.34
Depreciation .9 .9 .7 .7 1.7 1.4 1.6 1.8 2.1 2.4
Depreciation, % 3 2.59 1.81 1.77 3.26 2.49 2.49 2.49 2.49 2.49
EBIT 8.9 12.2 12.3 11.8 9.0 16.6 18.8 21.3 24.1 27.3
EBIT, % 28.79 35.06 33.13 29.52 17.78 28.86 28.86 28.86 28.86 28.86
Total Cash 65.1 204.0 192.0 68.0 49.7 57.1 64.8 73.4 83.2 94.3
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2.2 2.3 2.2 3.1 3.5
Account Receivables, % 7.12 6.45 5.95 7.73 6.82
Inventories -58.6 -196.7 -186.5 -61.6 .0 -45.9 -52.0 -58.9 -66.8 -75.7
Inventories, % -188.94 -563.04 -500.59 -154.42 0 -80 -80 -80 -80 -80
Accounts Payable .2 .4 .2 .4 .8 .6 .6 .7 .8 .9
Accounts Payable, % 0.72927 1.06 0.53693 0.99055 1.61 0.98549 0.98549 0.98549 0.98549 0.98549
Capital Expenditure -.7 -.4 -.2 -.4 -.4 -.7 -.7 -.8 -1.0 -1.1
Capital Expenditure, % -2.11 -1.17 -0.60404 -0.99807 -0.87731 -1.15 -1.15 -1.15 -1.15 -1.15
Tax Rate, % 17.34 17.34 17.34 17.34 17.34 17.34 17.34 17.34 17.34 17.34
EBITAT 7.2 9.7 9.9 9.5 7.4 13.3 15.1 17.1 19.4 22.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 64.0 148.4 .0 -115.7 -52.9 59.3 21.6 24.5 27.8 31.5
WACC, % 12.4 12.28 12.39 12.46 12.61 12.43 12.43 12.43 12.43 12.43
PV UFCF
SUM PV UFCF 122.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 32
Terminal Value 308
Present Terminal Value 172
Enterprise Value 294
Net Debt 7
Equity Value 287
Diluted Shares Outstanding, MM 3
Equity Value Per Share 111.09

What You Will Get

  • Real SFBC Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Sound Financial Bancorp, Inc.
  • Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specifically for SFBC.
  • Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Sound Financial Bancorp’s fair value.
  • Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for SFBC.
  • Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for your SFBC analysis.

Key Features

  • 🔍 Real-Life SFBC Financials: Pre-filled historical and projected data for Sound Financial Bancorp, Inc. (SFBC).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate Sound Financial Bancorp's intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize Sound Financial Bancorp's valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  • Download: Obtain the pre-configured Excel file featuring Sound Financial Bancorp, Inc.'s (SFBC) financial metrics.
  • Customize: Modify projections, such as revenue growth, EBITDA %, and WACC to suit your analysis.
  • Update Automatically: The intrinsic value and NPV calculations refresh in real-time as you make changes.
  • Test Scenarios: Develop various forecasts and instantly evaluate different outcomes.
  • Make Decisions: Leverage the valuation insights to inform your investment choices.

Why Choose Sound Financial Bancorp, Inc. (SFBC) Calculator?

  • Accuracy: Leveraging real SFBC financials for precise data.
  • Flexibility: Users can easily test and adjust inputs as needed.
  • Time-Saving: Avoid the complexities of creating a financial model from the ground up.
  • Professional-Grade: Crafted with the precision and usability expected at the CFO level.
  • User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling expertise.

Who Should Utilize Sound Financial Bancorp, Inc. (SFBC)?

  • Investors: Enhance your investment strategies with insights from a trusted financial institution.
  • Financial Analysts: Streamline your analysis with comprehensive reports and data from SFBC.
  • Consultants: Leverage SFBC's resources for impactful client presentations and financial advice.
  • Finance Enthusiasts: Expand your knowledge of banking operations and investment opportunities through SFBC's offerings.
  • Educators and Students: Utilize SFBC as a case study in finance and banking education.

What the Template Contains

  • Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Sound Financial Bancorp, Inc. (SFBC).
  • Real-World Data: SFBC’s historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into SFBC's performance.
  • Key Ratios: Built-in analysis for assessing profitability, efficiency, and leverage specific to SFBC.
  • Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.