HomeStreet, Inc. (HMST) DCF Valuation

HomeStreet, Inc. (HMST) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

HomeStreet, Inc. (HMST) 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:

Whether you’re an investor or an analyst, this (HMST) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from HomeStreet, Inc., you can adjust forecasts and observe the effects in real-time.


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 235.5 328.0 319.1 254.9 178.8 172.8 167.0 161.4 156.0 150.7
Revenue Growth, % 0 39.29 -2.71 -20.13 -29.86 -3.35 -3.35 -3.35 -3.35 -3.35
EBITDA .0 118.4 165.3 103.0 .0 44.3 42.9 41.4 40.0 38.7
EBITDA, % 0 36.08 51.81 40.42 0 25.66 25.66 25.66 25.66 25.66
Depreciation 12.4 12.1 12.1 11.3 15.9 9.0 8.7 8.4 8.1 7.9
Depreciation, % 5.28 3.68 3.81 4.41 8.88 5.21 5.21 5.21 5.21 5.21
EBIT -12.4 106.3 153.2 91.8 -15.9 35.3 34.1 33.0 31.9 30.8
EBIT, % -5.28 32.4 48.01 36 -8.88 20.45 20.45 20.45 20.45 20.45
Total Cash 57.9 58.0 65.2 72.8 209.3 66.1 63.9 61.7 59.7 57.7
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 .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
Accounts Payable 192.9 249.1 175.2 110.3 .0 88.5 85.5 82.6 79.9 77.2
Accounts Payable, % 81.92 75.95 54.91 43.27 0 51.21 51.21 51.21 51.21 51.21
Capital Expenditure -2.3 -3.3 -2.9 -6.8 -3.8 -2.7 -2.6 -2.5 -2.4 -2.3
Capital Expenditure, % -0.96434 -1.01 -0.9216 -2.66 -2.13 -1.54 -1.54 -1.54 -1.54 -1.54
Tax Rate, % 16.02 16.02 16.02 16.02 16.02 16.02 16.02 16.02 16.02 16.02
EBITAT -10.4 83.4 120.5 72.1 -13.3 28.5 27.5 26.6 25.7 24.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 192.7 148.5 55.8 11.7 -111.6 123.3 30.7 29.7 28.7 27.7
WACC, % 10.01 9.46 9.48 9.47 10.05 9.7 9.7 9.7 9.7 9.7
PV UFCF
SUM PV UFCF 197.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 28
Terminal Value 368
Present Terminal Value 231
Enterprise Value 429
Net Debt 1,754
Equity Value -1,325
Diluted Shares Outstanding, MM 19
Equity Value Per Share -70.54

What You Will Get

  • Real HMST Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Dynamic Calculations: Intrinsic value and NPV are computed automatically.
  • Scenario Analysis: Explore various scenarios to assess HomeStreet, Inc.'s future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for novices.

Key Features

  • Real-Life HMST Data: Pre-filled with HomeStreet, Inc.'s historical financials and forward-looking projections.
  • Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures to suit your analysis.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your customized inputs.
  • Scenario Testing: Create multiple forecast scenarios to explore various valuation outcomes.
  • User-Friendly Design: Intuitive, structured, and tailored for both professionals and newcomers.

How It Works

  • Step 1: Download the prebuilt Excel template with HomeStreet, Inc.'s (HMST) data included.
  • Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
  • Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Instantly view recalculated results, including HomeStreet, Inc.'s (HMST) intrinsic value.
  • Step 5: Make informed investment decisions or generate reports using the outputs.

Why Choose HomeStreet, Inc. (HMST)?

  • Time Efficiency: Quickly access banking solutions without the hassle of lengthy processes.
  • Enhanced Accuracy: Dependable financial services ensure precise transactions and reporting.
  • Fully Customizable Services: Adapt our offerings to meet your unique banking needs and goals.
  • User-Friendly Experience: Intuitive interfaces and clear communication make banking straightforward.
  • Endorsed by Professionals: A reputable choice for clients who prioritize expertise and reliability.

Who Should Use This Product?

  • Investors: Accurately assess HomeStreet, Inc.'s (HMST) fair value before making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to HomeStreet, Inc. (HMST).
  • Consultants: Easily customize the template for valuation reports tailored to HomeStreet, Inc. (HMST) clients.
  • Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions, including HomeStreet, Inc. (HMST).
  • Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to HomeStreet, Inc. (HMST).

What the Template Contains

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

No products were found matching.