Metropolitan Bank Holding Corp. (MCB) DCF Valuation

Metropolitan Bank Holding Corp. (MCB) 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

Metropolitan Bank Holding Corp. (MCB) 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 mastery over your Metropolitan Bank Holding Corp. (MCB) valuation analysis using our cutting-edge DCF Calculator! Preloaded with real (MCB) data, this Excel template empowers you to adjust forecasts and assumptions, enabling you to accurately calculate the intrinsic value of Metropolitan Bank Holding Corp.


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 108.2 141.9 180.7 255.8 238.5 294.0 362.5 447.0 551.2 679.6
Revenue Growth, % 0 31.12 27.32 41.54 -6.76 23.3 23.3 23.3 23.3 23.3
EBITDA 45.7 60.5 92.0 99.4 109.5 129.7 159.9 197.1 243.1 299.7
EBITDA, % 42.2 42.6 50.9 38.87 45.93 44.1 44.1 44.1 44.1 44.1
Depreciation 1.6 2.5 2.4 2.5 2.6 3.9 4.8 6.0 7.4 9.1
Depreciation, % 1.49 1.79 1.33 0.97751 1.09 1.33 1.33 1.33 1.33 1.33
EBIT 44.1 57.9 89.6 96.9 106.9 125.7 155.0 191.2 235.7 290.6
EBIT, % 40.71 40.81 49.57 37.89 44.84 42.76 42.76 42.76 42.76 42.76
Total Cash 626.2 1,130.4 2,926.0 703.2 20.8 240.4 296.4 365.4 450.6 555.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 20.4 40.5 55.1 85.6 .0
Account Receivables, % 18.89 28.54 30.47 33.47 0
Inventories -34.8 -49.2 -83.9 -343.0 .0 -125.4 -154.6 -190.7 -235.1 -289.9
Inventories, % -32.14 -34.67 -46.44 -134.12 0 -42.65 -42.65 -42.65 -42.65 -42.65
Accounts Payable 24.8 62.4 37.2 .0 .0 51.4 63.4 78.1 96.3 118.8
Accounts Payable, % 22.9 43.94 20.56 0 0 17.48 17.48 17.48 17.48 17.48
Capital Expenditure -6.8 -3.9 -4.0 -19.2 -5.7 -12.5 -15.4 -19.0 -23.4 -28.8
Capital Expenditure, % -6.32 -2.76 -2.21 -7.52 -2.41 -4.24 -4.24 -4.24 -4.24 -4.24
Tax Rate, % 27.73 27.73 27.73 27.73 27.73 27.73 27.73 27.73 27.73 27.73
EBITAT 30.1 39.5 60.6 59.4 77.3 84.9 104.7 129.1 159.2 196.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 64.0 70.0 53.9 234.1 -183.3 187.7 120.1 148.1 182.6 225.2
WACC, % 13.29 13.26 13.2 12.44 13.76 13.19 13.19 13.19 13.19 13.19
PV UFCF
SUM PV UFCF 594.1
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 230
Terminal Value 2,052
Present Terminal Value 1,105
Enterprise Value 1,699
Net Debt 344
Equity Value 1,355
Diluted Shares Outstanding, MM 11
Equity Value Per Share 121.70

What You Will Receive

  • Adjustable Forecast Inputs: Effortlessly modify parameters (growth %, margins, WACC) to explore various scenarios.
  • Industry Data: Metropolitan Bank Holding Corp.'s (MCB) financial information pre-loaded to facilitate your analysis.
  • Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
  • Tailored and Professional: A refined Excel model that caters to your valuation requirements.
  • Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Customizable Financial Metrics: Adjust essential inputs such as loan growth, net interest margin, and operating expenses.
  • Instant DCF Calculations: Quickly determines intrinsic value, NPV, and other financial metrics.
  • High Precision Results: Leverages Metropolitan Bank's actual financial data for accurate valuation insights.
  • Effortless Scenario Testing: Easily evaluate various assumptions and analyze different outcomes.
  • Efficiency Booster: Streamline the valuation process without the hassle of creating intricate models from the ground up.

How It Works

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

Why Choose This Calculator for Metropolitan Bank Holding Corp. (MCB)?

  • Accurate Data: Access to real-time Metropolitan Bank financials guarantees dependable valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Built-in calculations streamline your process, removing the need to start from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: An intuitive interface and comprehensive instructions ensure ease of use for everyone.

Who Should Use This Product?

  • Investors: Evaluate Metropolitan Bank Holding Corp.'s (MCB) financial health before making investment decisions.
  • CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts for MCB.
  • Startup Founders: Understand the valuation strategies of established banks like Metropolitan Bank Holding Corp. (MCB).
  • Consultants: Create comprehensive valuation reports for clients involving MCB.
  • Students and Educators: Utilize MCB's financial data to teach and practice valuation principles.

What the Template Contains

  • Pre-Filled DCF Model: Metropolitan Bank Holding Corp.'s (MCB) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored to (MCB).
  • Financial Ratios: Evaluate Metropolitan Bank Holding Corp.'s (MCB) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios for (MCB).
  • Financial Statements: Annual and quarterly reports to support detailed analysis of (MCB).
  • Interactive Dashboard: Easily visualize key valuation metrics and results for Metropolitan Bank Holding Corp. (MCB).

No products were found matching.