New York Mortgage Trust, Inc. (NYMT) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
New York Mortgage Trust, Inc. (NYMT) Bundle
Whether you’re an investor or analyst, this NYMT DCF Calculator is your go-to resource for accurate valuation. Preloaded with New York Mortgage Trust, Inc. real data, you can adjust forecasts and observe the effects in real-time.
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 | 221.9 | -207.5 | 266.5 | 8.5 | 210.0 | 106.7 | 54.2 | 27.5 | 14.0 | 7.1 |
Revenue Growth, % | 0 | -193.5 | -228.45 | -96.83 | 2383.47 | -49.21 | -49.21 | -49.21 | -49.21 | -49.21 |
EBITDA | 117.7 | .0 | 251.9 | .0 | 206.4 | 52.4 | 26.6 | 13.5 | 6.9 | 3.5 |
EBITDA, % | 53.03 | 0 | 94.5 | 0 | 98.3 | 49.17 | 49.17 | 49.17 | 49.17 | 49.17 |
Depreciation | 578.0 | 214.7 | 11.2 | 671.9 | 24.6 | 24.7 | 12.6 | 6.4 | 3.2 | 1.6 |
Depreciation, % | 260.46 | -103.49 | 4.19 | 7945.34 | 11.72 | 23.18 | 23.18 | 23.18 | 23.18 | 23.18 |
EBIT | -460.3 | -214.7 | 240.7 | -671.9 | 181.8 | 16.4 | 8.3 | 4.2 | 2.1 | 1.1 |
EBIT, % | -207.42 | 103.49 | 90.32 | -7945.34 | 86.58 | 15.38 | 15.38 | 15.38 | 15.38 | 15.38 |
Total Cash | 2,124.9 | 1,017.9 | 490.4 | 409.9 | 2,200.9 | 64.0 | 32.5 | 16.5 | 8.4 | 4.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 169.2 | .0 | .0 | 60.8 | 64.9 | 44.2 | 22.4 | 11.4 | 5.8 | 2.9 |
Account Receivables, % | 76.25 | 0 | 0 | 718.99 | 30.89 | 41.43 | 41.43 | 41.43 | 41.43 | 41.43 |
Inventories | -15.9 | .0 | 337.9 | 380.9 | .0 | 41.1 | 20.9 | 10.6 | 5.4 | 2.7 |
Inventories, % | -7.16 | -0.000000482 | 126.77 | 4504.94 | 0 | 38.57 | 38.57 | 38.57 | 38.57 | 38.57 |
Accounts Payable | .0 | .0 | 9.1 | 10.6 | 23.7 | 24.5 | 12.4 | 6.3 | 3.2 | 1.6 |
Accounts Payable, % | 0 | 0 | 3.4 | 125.7 | 11.26 | 22.93 | 22.93 | 22.93 | 22.93 | 22.93 |
Capital Expenditure | -.1 | -.2 | -486.8 | -209.4 | .0 | -42.7 | -21.7 | -11.0 | -5.6 | -2.8 |
Capital Expenditure, % | -0.05768182 | 0.09928811 | -182.67 | -2476.02 | 0 | -40.01 | -40.01 | -40.01 | -40.01 | -40.01 |
Tax Rate, % | 37.39 | 37.39 | 37.39 | 37.39 | 37.39 | 37.39 | 37.39 | 37.39 | 37.39 | 37.39 |
EBITAT | -463.6 | -215.5 | 243.6 | -672.9 | 113.8 | 15.2 | 7.7 | 3.9 | 2.0 | 1.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -39.1 | 152.4 | -560.9 | -312.7 | 528.4 | -22.4 | 28.5 | 14.5 | 7.4 | 3.7 |
WACC, % | 5.3 | 5.3 | 5.3 | 5.3 | 3.79 | 5 | 5 | 5 | 5 | 5 |
PV UFCF | ||||||||||
SUM PV UFCF | 26.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 4 | |||||||||
Terminal Value | 127 | |||||||||
Present Terminal Value | 100 | |||||||||
Enterprise Value | 126 | |||||||||
Net Debt | 2,618 | |||||||||
Equity Value | -2,492 | |||||||||
Diluted Shares Outstanding, MM | 91 | |||||||||
Equity Value Per Share | -27.37 |
What You Will Get
- Real NYMT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust assumptions for WACC, tax rates, revenue growth, and capital expenditures.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess NYMT’s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive NYMT Data: Pre-loaded with New York Mortgage Trust's historical performance and future outlook.
- Flexible Input Options: Modify key variables such as interest rates, loan-to-value ratios, and dividend yields.
- Adaptive Valuation Framework: Instant recalculations of Net Asset Value (NAV) and fair value based on your modifications.
- Scenario Analysis: Develop various financial scenarios to explore different valuation possibilities.
- Intuitive Interface: Designed for ease of use, catering to both seasoned investors and newcomers.
How It Works
- Download: Obtain the pre-formatted Excel file containing New York Mortgage Trust, Inc.'s (NYMT) financial information.
- Customize: Modify projections, including interest rates, loan growth, and return on equity.
- Update Automatically: The intrinsic value and net present value calculations refresh in real-time.
- Test Scenarios: Develop various financial forecasts and analyze results immediately.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for New York Mortgage Trust, Inc. (NYMT)?
- Comprehensive Tool: Features DCF, WACC, and financial ratio analyses tailored for NYMT.
- Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes NYMT’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for financial analysts, investors, and mortgage consultants focusing on NYMT.
Who Should Use This Product?
- Investors: Assess the fair value of New York Mortgage Trust, Inc. (NYMT) prior to making investment choices.
- CFOs: Utilize a robust DCF model for accurate financial reporting and analysis.
- Consultants: Efficiently customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading mortgage trusts.
- Educators: Implement it as a resource to illustrate valuation methodologies in the classroom.
What the Template Contains
- Pre-Filled DCF Model: New York Mortgage Trust, Inc.'s (NYMT) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate NYMT's profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.