Bank of Marin Bancorp (BMRC) DCF Valuation

Bank of Marin Bancorp (BMRC) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Bank of Marin Bancorp (BMRC) 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:

Gain insight into your Bank of Marin Bancorp (BMRC) valuation analysis with our cutting-edge DCF Calculator! This Excel template comes preloaded with real BMRC data, enabling you to adjust forecasts and assumptions for an accurate calculation of Bank of Marin Bancorp's intrinsic value.


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 104.8 105.2 115.1 138.4 105.0 106.5 108.1 109.7 111.3 113.0
Revenue Growth, % 0 0.42476 9.39 20.26 -24.16 1.48 1.48 1.48 1.48 1.48
EBITDA 49.0 43.6 47.8 66.8 .0 37.9 38.5 39.1 39.6 40.2
EBITDA, % 46.78 41.43 41.5 48.29 0 35.6 35.6 35.6 35.6 35.6
Depreciation 3.1 3.0 2.9 3.3 3.4 3.0 3.0 3.1 3.1 3.2
Depreciation, % 2.97 2.85 2.5 2.41 3.28 2.8 2.8 2.8 2.8 2.8
EBIT 45.9 40.6 44.9 63.5 -3.4 34.9 35.5 36.0 36.5 37.0
EBIT, % 43.81 38.58 39 45.89 -3.28 32.8 32.8 32.8 32.8 32.8
Total Cash 615.6 592.7 1,515.2 848.0 30.5 91.4 92.7 94.1 95.5 96.9
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 75.7 80.0 51.4 79.8 .0
Account Receivables, % 72.27 76.07 44.63 57.68 0
Inventories -191.1 -211.2 -360.3 -58.9 .0 -73.0 -74.1 -75.2 -76.3 -77.4
Inventories, % -182.43 -200.78 -313.1 -42.59 0 -68.52 -68.52 -68.52 -68.52 -68.52
Accounts Payable 18.5 19.5 29.4 22.9 .0 16.7 16.9 17.2 17.4 17.7
Accounts Payable, % 17.63 18.56 25.58 16.58 0 15.67 15.67 15.67 15.67 15.67
Capital Expenditure -.5 -1.0 -1.0 -2.3 -1.7 -1.2 -1.2 -1.2 -1.3 -1.3
Capital Expenditure, % -0.51735 -0.93243 -0.90717 -1.64 -1.67 -1.13 -1.13 -1.13 -1.13 -1.13
Tax Rate, % 23.59 23.59 23.59 23.59 23.59 23.59 23.59 23.59 23.59 23.59
EBITAT 34.2 30.2 33.2 46.6 -2.6 26.1 26.4 26.8 27.2 27.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 170.7 49.1 222.7 -288.7 -3.0 64.1 28.8 29.2 29.6 30.1
WACC, % 14.06 14.05 14.01 13.95 14.21 14.06 14.06 14.06 14.06 14.06
PV UFCF
SUM PV UFCF 131.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 31
Terminal Value 254
Present Terminal Value 132
Enterprise Value 263
Net Debt 19
Equity Value 244
Diluted Shares Outstanding, MM 16
Equity Value Per Share 15.24

What You Will Get

  • Real BMRC 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: Evaluate various scenarios to assess Bank of Marin Bancorp's future performance.
  • User-Friendly Design: Designed for professionals while remaining easy to use for newcomers.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Bank of Marin Bancorp (BMRC).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to BMRC.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to suit your analysis of BMRC.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Bank of Marin Bancorp (BMRC).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.

How It Works

  1. Step 1: Download the Excel file for Bank of Marin Bancorp (BMRC).
  2. Step 2: Review the pre-filled financial data and forecasts for Bank of Marin Bancorp (BMRC).
  3. Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and leverage the results for your investment decisions regarding Bank of Marin Bancorp (BMRC).

Why Choose This Calculator for Bank of Marin Bancorp (BMRC)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Easily adjust parameters to suit your financial analysis.
  • Real-Time Feedback: Observe immediate changes to Bank of Marin Bancorp’s valuation as you modify inputs.
  • Preconfigured Data: Comes with Bank of Marin Bancorp’s actual financial figures for swift evaluations.
  • Relied Upon by Experts: Utilized by investors and analysts for making well-informed decisions.

Who Should Use Bank of Marin Bancorp (BMRC)?

  • Investors: Make informed investment choices with a trusted financial institution.
  • Small Business Owners: Access tailored banking solutions to support your growth.
  • Community Members: Benefit from local banking services that prioritize personal relationships.
  • Financial Advisors: Collaborate with a bank that understands your client's needs.
  • Individuals Seeking Home Loans: Explore competitive mortgage options for your dream home.

What the Template Contains

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