MetroCity Bankshares, Inc. (MCBS) DCF Valuation

MetroCity Bankshares, Inc. (MCBS) 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

MetroCity Bankshares, Inc. (MCBS) 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:

Discover the true potential of MetroCity Bankshares, Inc. (MCBS) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different factors influence the valuation of MetroCity Bankshares, Inc. (MCBS) – all within one comprehensive Excel template.


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 100.9 93.3 138.0 4.1 119.7 132.7 147.1 163.0 180.7 200.2
Revenue Growth, % 0 -7.47 47.83 -97 2792.65 10.84 10.84 10.84 10.84 10.84
EBITDA 61.9 .0 85.5 .2 .0 33.8 37.4 41.5 46.0 51.0
EBITDA, % 61.34 0 61.96 3.94 0 25.45 25.45 25.45 25.45 25.45
Depreciation 1.0 1.1 1.2 1.2 .0 8.5 9.4 10.4 11.6 12.8
Depreciation, % 0.99139 1.18 0.86974 29 0 6.41 6.41 6.41 6.41 6.41
EBIT 60.9 -1.1 84.3 -1.0 .0 25.3 28.0 31.0 34.4 38.1
EBIT, % 60.34 -1.18 61.09 -25.06 0 19.04 19.04 19.04 19.04 19.04
Total Cash 286.2 158.9 458.3 170.2 144.8 132.7 147.1 163.0 180.7 200.2
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 5.1 9.3 11.1 13.2 15.1
Account Receivables, % 5.06 9.99 8.01 318.29 12.64
Inventories -296.9 -165.2 -456.0 -197.0 .0 -106.1 -117.6 -130.4 -144.5 -160.2
Inventories, % -294.38 -177.01 -330.51 -4760.37 0 -80 -80 -80 -80 -80
Accounts Payable .9 .2 .2 2.7 4.1 18.8 20.9 23.1 25.6 28.4
Accounts Payable, % 0.88234 0.23786 0.14786 66.19 3.45 14.18 14.18 14.18 14.18 14.18
Capital Expenditure -1.1 -.5 -.4 -2.4 -4.9 -16.7 -18.5 -20.5 -22.7 -25.2
Capital Expenditure, % -1.09 -0.57537 -0.27832 -56.89 -4.12 -12.59 -12.59 -12.59 -12.59 -12.59
Tax Rate, % 28.29 28.29 28.29 28.29 28.29 28.29 28.29 28.29 28.29 28.29
EBITAT 44.7 -.8 62.9 -.7 .0 18.3 20.3 22.5 25.0 27.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 337.3 -136.9 352.8 -260.5 -202.5 110.1 20.9 23.1 25.7 28.4
WACC, % 11.01 11.1 11.1 10.62 10.87 10.94 10.94 10.94 10.94 10.94
PV UFCF
SUM PV UFCF 167.0
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 29
Terminal Value 324
Present Terminal Value 193
Enterprise Value 360
Net Debt 191
Equity Value 169
Diluted Shares Outstanding, MM 26
Equity Value Per Share 6.61

What You Will Get

  • Pre-Filled Financial Model: MetroCity Bankshares, Inc.'s (MCBS) actual data provides an accurate DCF valuation.
  • Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
  • Instant Calculations: Real-time updates ensure you see the outcomes as you adjust inputs.
  • Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
  • Customizable and Reusable: Designed for adaptability, allowing repeated use for in-depth forecasts.

Key Features

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

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review MetroCity Bankshares, Inc.'s (MCBS) pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions.

Why Choose MetroCity Bankshares, Inc. (MCBS)?

  • Save Time: Skip the hassle of building financial models from the ground up – we provide ready-to-use solutions.
  • Enhance Precision: Our reliable data and formulas help minimize valuation errors.
  • Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
  • User-Friendly: Intuitive charts and outputs simplify the analysis of results.
  • Endorsed by Professionals: Crafted for experts who prioritize accuracy and ease of use.

Who Should Use This Product?

  • Investors: Accurately assess MetroCity Bankshares, Inc.'s (MCBS) fair value prior to making investment choices.
  • CFOs: Utilize a top-tier DCF model for comprehensive financial reporting and analysis.
  • Consultants: Easily customize the template for client valuation reports.
  • Entrepreneurs: Acquire knowledge on financial modeling practices utilized by leading financial institutions.
  • Educators: Employ it as a pedagogical resource to illustrate valuation techniques.

What the Template Contains

  • Pre-Filled Data: Includes MetroCity Bankshares, Inc.'s (MCBS) historical financials and forecasts.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (MCBS).
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs specific to (MCBS).
  • Key Financial Ratios: Analyze MetroCity Bankshares, Inc.'s (MCBS) profitability, efficiency, and leverage.
  • Customizable Inputs: Edit revenue growth, margins, and tax rates easily for (MCBS).
  • Clear Dashboard: Charts and tables summarizing key valuation results for (MCBS).

No products were found matching.