AG Mortgage Investment Trust, Inc. (MITT) DCF Valuation

AG Mortgage Investment Trust, Inc. (MITT) 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

AG Mortgage Investment Trust, Inc. (MITT) 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:

Explore the financial potential of AG Mortgage Investment Trust, Inc. (MITT) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to calculate the intrinsic value of AG Mortgage Investment Trust, Inc. (MITT) and refine your investment strategy.


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 119.0 -390.4 99.8 .2 47.8 23.9 12.0 6.0 3.0 1.5
Revenue Growth, % 0 -427.93 -125.57 -99.78 21839.91 -49.95 -49.95 -49.95 -49.95 -49.95
EBITDA 97.3 .0 .0 52.9 248.6 13.5 6.8 3.4 1.7 .8
EBITDA, % 81.77 0 0 24283.03 519.68 56.35 56.35 56.35 56.35 56.35
Depreciation 37.6 193.1 -39.3 164.2 211.1 6.8 3.4 1.7 .9 .4
Depreciation, % 31.54 -49.46 -39.42 75330.28 441.26 28.53 28.53 28.53 28.53 28.53
EBIT 59.8 -193.1 39.3 -111.3 37.5 5.6 2.8 1.4 .7 .4
EBIT, % 50.23 49.46 39.42 -51047.25 78.43 23.51 23.51 23.51 23.51 23.51
Total Cash 81.7 47.9 68.1 155.7 111.5 15.5 7.8 3.9 1.9 1.0
Total Cash, percent .0 .0 .0 .1 .0 .0 .0 .0 .0 .0
Account Receivables 15.2 3.9 16.2 21.4 30.6
Account Receivables, % 12.81 -0.99115 16.18 9813.76 63.9
Inventories -2.3 .0 -.2 -1.2 .0 -4.9 -2.4 -1.2 -.6 -.3
Inventories, % -1.92 -0.000000256 -0.23147 -558.72 0 -20.43 -20.43 -20.43 -20.43 -20.43
Accounts Payable 12.0 53.3 3.9 14.1 23.9 7.2 3.6 1.8 .9 .5
Accounts Payable, % 10.12 -13.64 3.92 6477.52 49.99 30.08 30.08 30.08 30.08 30.08
Capital Expenditure .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Capital Expenditure, % 0 0 0 0 0 0 0 0 0 0
Tax Rate, % 2.52 2.52 2.52 2.52 2.52 2.52 2.52 2.52 2.52 2.52
EBITAT 61.9 -193.5 56.7 -420.2 36.6 5.6 2.8 1.4 .7 .4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 98.6 49.9 -44.0 -250.0 247.0 22.0 4.8 2.4 1.2 .6
WACC, % 4.7 4.7 4.7 4.7 4.59 4.68 4.68 4.68 4.68 4.68
PV UFCF
SUM PV UFCF 28.9
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1
Terminal Value 23
Present Terminal Value 18
Enterprise Value 47
Net Debt 5,453
Equity Value -5,406
Diluted Shares Outstanding, MM 21
Equity Value Per Share -256.24

What You Will Get

  • Real MITT Financials: Includes 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 MITT’s future performance.
  • User-Friendly Design: Designed for professionals while remaining approachable for newcomers.

Key Features

  • Accurate MITT Financials: Gain access to reliable pre-loaded historical data and future forecasts.
  • Adjustable Forecast Parameters: Modify yellow-highlighted cells such as WACC, growth rates, and profit margins.
  • Real-Time Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
  • Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
  • Designed for All Users: An easy-to-navigate structure tailored for investors, CFOs, and consultants alike.

How It Works

  1. Step 1: Download the Excel file for AG Mortgage Investment Trust, Inc. (MITT).
  2. Step 2: Review MITT’s pre-filled financial data and projections.
  3. Step 3: Adjust key inputs such as dividend yield, interest rates, and loan-to-value ratios (highlighted cells).
  4. Step 4: Observe the DCF model refresh in real-time as you modify your assumptions.
  5. Step 5: Evaluate the outputs and apply the findings to your investment strategies.

Why Choose This Calculator for AG Mortgage Investment Trust, Inc. (MITT)?

  • Accurate Data: Utilize real AG Mortgage financials for trustworthy valuation outcomes.
  • Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
  • Professional-Grade Tool: Crafted for investors, analysts, and financial consultants.
  • User-Friendly: Easy-to-navigate design and clear instructions ensure accessibility for all users.

Who Should Use This Product?

  • Investors: Evaluate AG Mortgage Investment Trust, Inc. (MITT)'s performance before making stock transactions.
  • CFOs and Financial Analysts: Optimize valuation methods and assess financial forecasts for MITT.
  • Startup Founders: Understand the valuation strategies of established companies like AG Mortgage Investment Trust, Inc. (MITT).
  • Consultants: Provide comprehensive valuation analyses and reports for clients involving MITT.
  • Students and Educators: Utilize current data from AG Mortgage Investment Trust, Inc. (MITT) to learn and teach valuation practices.

What the Template Contains

  • Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for AG Mortgage Investment Trust, Inc. (MITT).
  • Real-World Data: Historical and projected financials for AG Mortgage Investment Trust, Inc. (MITT) preloaded for analysis.
  • Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for deeper insights into AG Mortgage Investment Trust, Inc. (MITT).
  • Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to AG Mortgage Investment Trust, Inc. (MITT).
  • Dashboard with Visual Outputs: Charts and tables for clear, actionable results regarding AG Mortgage Investment Trust, Inc. (MITT).

No products were found matching.