Invesco Mortgage Capital Inc. (IVR) 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
Invesco Mortgage Capital Inc. (IVR) Bundle
As an investor or analyst, this (IVR) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from Invesco Mortgage Capital Inc., you can adjust forecasts and instantly observe the effects.
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 | 408.1 | -1,648.3 | -63.4 | 194.5 | 4.2 | .1 | .0 | .0 | .0 | .0 |
| Revenue Growth, % | 0 | -503.93 | -96.15 | -406.78 | -97.85 | -98.5 | -98.5 | -98.5 | -98.5 | -98.5 |
| EBITDA | -96.4 | -1,481.7 | -101.5 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| EBITDA, % | -23.64 | 89.89 | 160.15 | 0 | 0 | 33.25 | 33.25 | 33.25 | 33.25 | 33.25 |
| Depreciation | -119.7 | 556.5 | 130.5 | -106.1 | -9.8 | .0 | .0 | .0 | .0 | .0 |
| Depreciation, % | -29.32 | -33.76 | -205.81 | -54.55 | -234.69 | -63.53 | -63.53 | -63.53 | -63.53 | -63.53 |
| EBIT | 23.2 | -2,038.1 | -232.0 | 106.1 | 9.8 | .0 | .0 | .0 | .0 | .0 |
| EBIT, % | 5.69 | 123.65 | 365.96 | 54.55 | 234.69 | 72.05 | 72.05 | 72.05 | 72.05 | 72.05 |
| Total Cash | 172.5 | 148.0 | 357.1 | 175.5 | 77.0 | .0 | .0 | .0 | .0 | .0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 100.5 | 16.9 | 24.8 | 24.3 | 26.6 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 24.64 | -1.03 | -39.04 | 12.51 | 634.79 | 19.42 | 19.42 | 19.42 | 19.42 | 19.42 |
| Inventories | -18.5 | -10.0 | -.3 | 305.4 | .0 | .0 | .0 | .0 | .0 | .0 |
| Inventories, % | -4.54 | 0.60694 | 0.42583 | 156.99 | 0 | 19.3 | 19.3 | 19.3 | 19.3 | 19.3 |
| Accounts Payable | 45.6 | 2.3 | 3.1 | 21.9 | 17.1 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 11.16 | -0.13778 | -4.82 | 11.26 | 407.61 | 23.49 | 23.49 | 23.49 | 23.49 | 23.49 |
| 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 | 23.2 | -2,038.1 | -232.0 | 119.7 | 9.8 | .0 | .0 | .0 | .0 | .0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -132.9 | -1,449.8 | -118.3 | -272.8 | 298.3 | 9.5 | .0 | .0 | .0 | .0 |
| WACC, % | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 | 5.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 9.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 0 | |||||||||
| Terminal Value | 0 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | 9 | |||||||||
| Net Debt | 4,260 | |||||||||
| Equity Value | -4,251 | |||||||||
| Diluted Shares Outstanding, MM | 44 | |||||||||
| Equity Value Per Share | -96.45 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-populated financials for Invesco Mortgage Capital Inc. (IVR).
- Real-Time Data: Access to historical data and future projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly visualize how your inputs affect the valuation of Invesco Mortgage Capital Inc. (IVR).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and user-friendliness, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Invesco Mortgage Capital Inc. (IVR).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to IVR.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit IVR's financial outlook.
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios relevant to Invesco Mortgage Capital Inc. (IVR).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of IVR.
How It Works
- 1. Access the Template: Download and open the Excel file containing Invesco Mortgage Capital Inc.'s (IVR) financial data.
- 2. Modify Assumptions: Adjust key parameters such as interest rates, dividend yields, and loan-to-value ratios.
- 3. Analyze Results Immediately: The DCF model automatically computes the intrinsic value and net present value.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation scenarios.
- 5. Present with Assurance: Deliver expert valuation insights to enhance your decision-making process.
Why Choose This Calculator for Invesco Mortgage Capital Inc. (IVR)?
- User-Friendly Design: Perfectly suited for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to tailor your financial analysis.
- Real-Time Feedback: Observe immediate updates to Invesco’s valuation as you tweak the numbers.
- Pre-Loaded Data: Comes with Invesco’s latest financial metrics for swift evaluations.
- Preferred by Experts: Utilized by financial analysts and investors for well-informed decision-making.
Who Should Use Invesco Mortgage Capital Inc. (IVR)?
- Real Estate Investors: Develop comprehensive models for assessing mortgage-backed securities.
- Portfolio Managers: Evaluate investment strategies involving mortgage REITs for optimal returns.
- Financial Analysts: Deliver precise valuation assessments for Invesco Mortgage Capital Inc. (IVR) to clients.
- Students and Educators: Utilize market data to enhance learning in real estate finance and investment.
- Market Researchers: Gain insights into the performance and valuation of mortgage REITs like Invesco Mortgage Capital Inc. (IVR).
What the Template Contains
- Historical Data: Includes Invesco Mortgage Capital Inc.'s (IVR) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Invesco Mortgage Capital Inc.'s (IVR) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, dividend yields, and investment assumptions.
- Quarterly and Annual Statements: A complete breakdown of Invesco Mortgage Capital Inc.'s (IVR) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.