Bridgewater Bancshares, Inc. (BWB) DCF Valuation

Bridgewater Bancshares, Inc. (BWB) DCF Valuation

US | Financial Services | Banks - Regional | NASDAQ
Bridgewater Bancshares, Inc. (BWB) 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

Bridgewater Bancshares, Inc. (BWB) Bundle

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

TOTAL:

Maximize efficiency and improve precision with our [BWB] DCF Calculator! Utilizing actual data from Bridgewater Bancshares, Inc. and customizable assumptions, this tool empowers you to forecast, analyze, and appraise [Company] just like a seasoned investor.


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 78.0 93.8 114.8 136.0 111.8 124.0 137.4 152.4 168.9 187.2
Revenue Growth, % 0 20.33 22.4 18.47 -17.78 10.86 10.86 10.86 10.86 10.86
EBITDA 39.5 37.1 64.1 75.0 55.7 62.2 69.0 76.5 84.8 94.0
EBITDA, % 50.7 39.51 55.86 55.11 49.77 50.19 50.19 50.19 50.19 50.19
Depreciation 1.2 1.4 2.6 2.8 3.1 2.5 2.8 3.1 3.4 3.8
Depreciation, % 1.54 1.49 2.23 2.03 2.81 2.02 2.02 2.02 2.02 2.02
EBIT 38.3 35.7 61.6 72.2 52.5 59.7 66.2 73.4 81.4 90.2
EBIT, % 49.16 38.02 53.63 53.08 46.96 48.17 48.17 48.17 48.17 48.17
Total Cash 324.5 554.2 584.7 94.6 128.6 116.4 129.1 143.1 158.6 175.8
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 -41.4 -172.7 -154.5 -101.7 .0 -81.3 -90.1 -99.9 -110.7 -122.8
Inventories, % -53.06 -184.12 -134.59 -74.77 0 -65.56 -65.56 -65.56 -65.56 -65.56
Accounts Payable 2.0 1.6 1.4 2.8 5.3 3.0 3.4 3.7 4.2 4.6
Accounts Payable, % 2.54 1.72 1.23 2.08 4.72 2.46 2.46 2.46 2.46 2.46
Capital Expenditure -15.6 -24.7 -.8 -1.6 -3.0 -12.6 -14.0 -15.5 -17.2 -19.0
Capital Expenditure, % -19.97 -26.32 -0.67672 -1.2 -2.66 -10.17 -10.17 -10.17 -10.17 -10.17
Tax Rate, % 23.92 23.92 23.92 23.92 23.92 23.92 23.92 23.92 23.92 23.92
EBITAT 31.4 27.2 45.7 53.8 40.0 45.7 50.7 56.2 62.3 69.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 60.4 134.9 29.1 3.5 -59.1 114.7 48.7 53.9 59.8 66.3
WACC, % 15.75 14.91 14.61 14.65 14.89 14.96 14.96 14.96 14.96 14.96
PV UFCF
SUM PV UFCF 239.3
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 68
Terminal Value 522
Present Terminal Value 260
Enterprise Value 499
Net Debt 284
Equity Value 215
Diluted Shares Outstanding, MM 28
Equity Value Per Share 7.60

What You Will Get

  • Authentic BWB Financials: Features 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 in real-time.
  • Scenario Analysis: Evaluate various scenarios to assess Bridgewater Bancshares' future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Accurate Financial Insights: Gain access to reliable pre-loaded historical data and future forecasts for Bridgewater Bancshares, Inc. (BWB).
  • Adjustable Financial Assumptions: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Experience automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
  • User-Friendly Dashboard: Clear and concise charts and summaries to help you visualize valuation outcomes.
  • Designed for All Users: An intuitive layout catering to investors, CFOs, and consultants, regardless of experience level.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Bridgewater Bancshares, Inc. (BWB) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Bridgewater Bancshares, Inc. (BWB)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose Bridgewater Bancshares, Inc. (BWB)?

  • Save Time: Our services streamline your banking needs, eliminating unnecessary delays.
  • Enhance Financial Security: Robust systems and protocols ensure your assets are well-protected.
  • Tailored Solutions: Customize banking options to fit your unique financial goals.
  • User-Friendly Experience: Intuitive interfaces and support make banking straightforward and efficient.
  • Backed by Expertise: Our team of professionals is dedicated to providing reliable financial guidance.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing investments in Bridgewater Bancshares, Inc. (BWB).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
  • Consultants and Advisors: Deliver precise valuation insights for clients interested in Bridgewater Bancshares, Inc. (BWB).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
  • Banking Enthusiasts: Gain insights into how financial institutions like Bridgewater Bancshares, Inc. (BWB) are valued in the market.

What the Template Contains

  • Preloaded BWB 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.