|
Claros Mortgage Trust, Inc. (CMTG) Valoración de DCF
US | Real Estate | REIT - Mortgage | NYSE
|
- ✓ 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
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (CMTG)! Utilizando datos reales de Claros Mortgage Trust, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y evaluar (CMTG) como un inversor experimentado.
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 | 32.0 | 28.5 | 25.5 | 22.8 | 20.3 |
Account Receivables, % | 14.35 | 13.06 | 10.47 | 2724.1 | 0 | 27.58 | 27.58 | 27.58 | 27.58 | 27.58 |
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
- Download the Template: Gain immediate access to the Excel-based CMTG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates Claros Mortgage Trust’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- 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).