Claros Mortgage Trust, Inc. (CMTG) DCF Valuation

Claros Mortgage Trust, Inc. (CMTG) 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

Claros Mortgage Trust, Inc. (CMTG) 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:

Streamline your analysis and improve precision with our (CMTG) DCF Calculator! Utilizing real data from Claros Mortgage Trust, Inc. and customizable assumptions, this tool empowers you to forecast, evaluate, and appraise (CMTG) 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 249.7 273.1 248.3 270.2 129.8 115.9 103.5 92.4 82.5 73.7
Revenue Growth, % 0 9.35 -9.07 8.82 -51.95 -10.71 -10.71 -10.71 -10.71 -10.71
EBITDA 168.8 202.4 176.9 216.2 .0 67.9 60.7 54.2 48.4 43.2
EBITDA, % 67.58 74.12 71.24 80.03 0 58.6 58.6 58.6 58.6 58.6
Depreciation 75.7 67.4 92.7 109.6 .7 30.9 27.6 24.7 22.0 19.7
Depreciation, % 30.32 24.68 37.35 40.56 0.54532 26.69 26.69 26.69 26.69 26.69
EBIT 93.0 135.0 84.2 106.7 -.7 37.0 33.0 29.5 26.3 23.5
EBIT, % 37.26 49.44 33.9 39.47 -0.54532 31.91 31.91 31.91 31.91 31.91
Total Cash 335.0 427.5 310.2 7,795.5 187.3 115.9 103.5 92.4 82.5 73.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 35.8 35.7 26.0 7,360.4 .0
Account Receivables, % 14.35 13.06 10.47 2724.1 0
Inventories 6,537.0 6,930.7 6,990.9 -6.0 .0 69.0 61.6 55.0 49.1 43.9
Inventories, % 2617.77 2538.1 2815.45 -2.22 0 59.56 59.56 59.56 59.56 59.56
Accounts Payable 15.2 15.3 54.5 .0 .0 7.8 7.0 6.2 5.6 5.0
Accounts Payable, % 6.1 5.62 21.93 0 0 6.73 6.73 6.73 6.73 6.73
Capital Expenditure .0 .0 -11.5 -2.3 -2.1 -1.6 -1.5 -1.3 -1.2 -1.0
Capital Expenditure, % 0 0 -4.62 -0.86715 -1.61 -1.42 -1.42 -1.42 -1.42 -1.42
Tax Rate, % 0 0 0 0 0 0 0 0 0 0
EBITAT 90.2 132.9 84.2 106.6 -.7 36.6 32.7 29.2 26.1 23.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -6,391.7 -193.2 154.2 -178.2 7,352.3 -27.3 68.9 61.5 54.9 49.0
WACC, % 21.41 21.69 22 21.98 22 21.81 21.81 21.81 21.81 21.81
PV UFCF
SUM PV UFCF 101.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 50
Terminal Value 252
Present Terminal Value 94
Enterprise Value 195
Net Debt 1,684
Equity Value -1,489
Diluted Shares Outstanding, MM 139
Equity Value Per Share -10.74

What You Will Get

  • Comprehensive CMTG Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Real-Time Calculations: Dynamic computation of intrinsic value and NPV.
  • Scenario Analysis: Explore various scenarios to assess Claros Mortgage Trust's future performance.
  • User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.

Key Features

  • Comprehensive Data: Claros Mortgage Trust, Inc.’s historical performance and detailed projections.
  • Customizable Parameters: Adjust interest rates, loan-to-value ratios, and occupancy rates.
  • Real-Time Insights: Monitor CMTG’s valuation updates as changes are made.
  • Intuitive Visualizations: Interactive charts showcase investment metrics and valuation outcomes.
  • Designed for Precision: A robust platform tailored for analysts, investors, and real estate professionals.

How It Works

  1. Download the Template: Gain immediate access to the Excel-based CMTG DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
  3. Instant Calculations: The model automatically recalculates Claros Mortgage Trust’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
  5. Analyze and Decide: Leverage the results to inform your investment or financial analysis.

Why Choose This Calculator?

  • User-Friendly Interface: Perfect for both novice and experienced users.
  • Customizable Inputs: Adjust parameters to suit your specific financial analysis.
  • Real-Time Feedback: Monitor immediate changes to Claros Mortgage Trust, Inc. (CMTG)’s valuation as you tweak the settings.
  • Preloaded Data: Comes with Claros Mortgage Trust, Inc. (CMTG)’s actual financial metrics for swift evaluations.
  • Relied Upon by Experts: Widely utilized by investors and financial analysts for strategic decision-making.

Who Should Use This Product?

  • Investors: Assess Claros Mortgage Trust, Inc.'s (CMTG) valuation to make informed stock trading decisions.
  • CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts for CMTG.
  • Real Estate Professionals: Understand the valuation metrics used for mortgage trusts like CMTG.
  • Consultants: Provide comprehensive valuation analyses and reports for clients interested in CMTG.
  • Students and Educators: Utilize current market data to study and teach mortgage trust valuation principles.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Claros Mortgage Trust, Inc. (CMTG).
  • Real-World Data: CMTG’s historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into CMTG’s performance.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage specific to CMTG.
  • Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results relevant to Claros Mortgage Trust, Inc. (CMTG).

No products were found matching.