Ellington Residential Mortgage REIT (EARN) DCF Valuation

Ellington Residential Mortgage REIT (EARN) 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

Ellington Residential Mortgage REIT (EARN) 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 (EARN) DCF Calculator! Equipped with real data from Ellington Residential Mortgage REIT and customizable assumptions, this tool empowers you to forecast, analyze, and value (EARN) just 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 27.5 25.9 -.6 20.2 -2.7 -.6 -.2 .0 .0 .0
Revenue Growth, % 0 -5.83 -102.15 -3724.06 -113.41 -76.46 -76.46 -76.46 -76.46 -76.46
EBITDA .0 14.8 23.4 17.9 49.8 .1 .0 .0 .0 .0
EBITDA, % 0 57.12 -4199.1 88.81 -1840.23 -10.81 -10.81 -10.81 -10.81 -10.81
Depreciation -15.1 -3.8 33.2 25.7 53.9 .2 .1 .0 .0 .0
Depreciation, % -54.84 -14.82 -5968.04 127.31 -1992.35 -33.93 -33.93 -33.93 -33.93 -33.93
EBIT 15.1 18.7 -9.9 -7.8 -4.1 -.4 -.1 .0 .0 .0
EBIT, % 54.84 71.94 1768.94 -38.5 152.12 57.66 57.66 57.66 57.66 57.66
Total Cash 35.4 58.2 69.0 34.8 38.5 -.1 .0 .0 .0 .0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 45.1 51.9 93.2 55.6 58.9
Account Receivables, % 163.78 200.14 -16726.39 275.45 -2175.8
Inventories .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Inventories, % 0 0 0 0 0 0 0 0 0 0
Accounts Payable 3.8 1.5 2.8 50.4 .0 .0 .0 .0 .0 .0
Accounts Payable, % 13.66 5.91 -510.59 249.49 0 3.91 3.91 3.91 3.91 3.91
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, % 0 0 0 0 0 0 0 0 0 0
EBITAT 15.1 18.7 -9.9 -7.8 -4.1 -.4 -.1 .0 .0 .0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -41.4 5.8 -16.6 103.0 -3.8 58.9 -.1 .0 .0 .0
WACC, % 7.07 7.07 7.07 7.07 7.07 7.07 7.07 7.07 7.07 7.07
PV UFCF
SUM PV UFCF 54.8
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 0
Terminal Value 0
Present Terminal Value 0
Enterprise Value 55
Net Debt -39
Equity Value 93
Diluted Shares Outstanding, MM 15
Equity Value Per Share 6.28

What You Will Get

  • Comprehensive EARN Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Tailor WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Instant Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess Ellington's future performance.
  • User-Friendly Interface: Designed for industry experts while remaining approachable for newcomers.

Key Features

  • 🔍 Real-Life EARN Financials: Pre-filled historical and projected data for Ellington Residential Mortgage REIT (EARN).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Built-in formulas calculate EARN’s intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize EARN’s valuation instantly after making changes.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Ellington Residential Mortgage REIT (EARN) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Ellington Residential Mortgage REIT’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Ellington Residential Mortgage REIT (EARN)?

  • Designed for Investors: A sophisticated tool tailored for real estate analysts, portfolio managers, and investors.
  • Comprehensive Data: Historical and projected financials for Ellington Residential preloaded for precise analysis.
  • Flexible Scenario Analysis: Easily test various investment scenarios and assumptions.
  • Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly: Step-by-step guidance simplifies the calculation process.

Who Should Use This Product?

  • Investors: Evaluate Ellington Residential Mortgage REIT’s (EARN) performance before making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methodologies and validate financial forecasts for (EARN).
  • Startup Founders: Understand the valuation strategies of established real estate investment trusts like (EARN).
  • Consultants: Provide comprehensive valuation assessments and reports for clients interested in (EARN).
  • Students and Educators: Utilize current market data to teach and practice valuation principles related to (EARN).

What the Template Contains

  • Pre-Filled Data: Contains Ellington Residential Mortgage REIT’s historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (EARN).
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs relevant to (EARN).
  • Key Financial Ratios: Evaluate (EARN)'s profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily adjust revenue growth, margins, and tax rates for (EARN).
  • Clear Dashboard: Visuals and tables summarizing essential valuation outcomes for (EARN).

Es wurden keine passenden Produkte gefunden.