Medalist Diversified REIT, Inc. (MDRR) 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
Medalist Diversified REIT, Inc. (MDRR) Bundle
Whether you’re an investor or analyst, this (MDRR) DCF Calculator is your go-to resource for accurate valuation. Loaded with real data from Medalist Diversified REIT, 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 | 8.3 | 9.3 | 11.5 | 11.1 | 10.3 | 10.9 | 11.6 | 12.3 | 13.1 | 13.9 |
| Revenue Growth, % | 0 | 12.18 | 23.68 | -3.32 | -7.38 | 6.29 | 6.29 | 6.29 | 6.29 | 6.29 |
| EBITDA | 1.4 | 2.5 | 4.7 | 4.6 | 3.5 | 3.5 | 3.7 | 4.0 | 4.2 | 4.5 |
| EBITDA, % | 17.44 | 27.05 | 40.83 | 41.47 | 34.48 | 32.25 | 32.25 | 32.25 | 32.25 | 32.25 |
| Depreciation | 8.6 | 11.3 | 10.8 | 11.5 | 4.6 | 9.6 | 10.2 | 10.8 | 11.5 | 12.2 |
| Depreciation, % | 103.51 | 121.9 | 93.99 | 103.53 | 44.53 | 87.7 | 87.7 | 87.7 | 87.7 | 87.7 |
| EBIT | -7.1 | -8.8 | -6.1 | -6.9 | -1.0 | -6.7 | -7.1 | -7.6 | -8.0 | -8.5 |
| EBIT, % | -86.07 | -94.85 | -53.15 | -62.06 | -10.05 | -61.24 | -61.24 | -61.24 | -61.24 | -61.24 |
| Total Cash | .6 | 2.9 | 4.4 | 3.9 | 3.8 | 3.3 | 3.5 | 3.7 | 3.9 | 4.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .6 | 1.1 | 1.3 | 1.4 | .3 | 1.0 | 1.1 | 1.2 | 1.2 | 1.3 |
| Account Receivables, % | 7.38 | 12.21 | 11.67 | 12.84 | 2.85 | 9.39 | 9.39 | 9.39 | 9.39 | 9.39 |
| Inventories | 3.7 | 20.2 | 20.7 | .0 | .0 | 5.3 | 5.7 | 6.0 | 6.4 | 6.8 |
| Inventories, % | 44.51 | 217.76 | 180.52 | 0.000009016055 | 0 | 48.9 | 48.9 | 48.9 | 48.9 | 48.9 |
| Accounts Payable | 1.6 | 1.2 | 1.0 | .8 | 1.0 | 1.3 | 1.3 | 1.4 | 1.5 | 1.6 |
| Accounts Payable, % | 18.93 | 13.35 | 8.59 | 6.99 | 9.98 | 11.57 | 11.57 | 11.57 | 11.57 | 11.57 |
| Capital Expenditure | -2.1 | -.4 | -.5 | -1.0 | -1.5 | -1.3 | -1.4 | -1.4 | -1.5 | -1.6 |
| Capital Expenditure, % | -25.83 | -4.47 | -4.68 | -9.19 | -14.44 | -11.72 | -11.72 | -11.72 | -11.72 | -11.72 |
| Tax Rate, % | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 | 0.04537152 |
| EBITAT | -10.1 | -11.3 | -14.4 | -7.2 | -1.0 | -6.7 | -7.1 | -7.6 | -8.0 | -8.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -6.4 | -17.7 | -5.1 | 23.7 | 3.4 | -4.2 | 1.4 | 1.5 | 1.6 | 1.7 |
| WACC, % | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 | 7.08 |
| PV UFCF | ||||||||||
| SUM PV UFCF | .9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 2 | |||||||||
| Terminal Value | 34 | |||||||||
| Present Terminal Value | 24 | |||||||||
| Enterprise Value | 25 | |||||||||
| Net Debt | 50 | |||||||||
| Equity Value | -25 | |||||||||
| Diluted Shares Outstanding, MM | 1 | |||||||||
| Equity Value Per Share | -22.42 |
What You Will Get
- Real MDRR Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust metrics such as cap rates, occupancy rates, and expense ratios.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess the future performance of Medalist Diversified REIT, Inc.
- User-Friendly Design: Designed for industry experts while remaining approachable for newcomers.
Key Features
- Comprehensive Market Data: Gain access to reliable historical performance data and future market forecasts for Medalist Diversified REIT, Inc. (MDRR).
- Adjustable Investment Assumptions: Modify highlighted parameters such as cap rates, occupancy rates, and rental growth directly.
- Real-Time Analytics: Enjoy automatic recalculations for metrics like DCF, Net Asset Value (NAV), and income projections.
- User-Friendly Interface: Intuitive visualizations and summaries to help you interpret your investment analysis effectively.
- Designed for All Skill Levels: A straightforward layout tailored for both seasoned investors and those new to real estate investment.
How It Works
- Download: Obtain the comprehensive Excel file containing Medalist Diversified REIT, Inc.'s (MDRR) financial information.
- Customize: Modify projections, including rental income growth, occupancy rates, and cap rates.
- Update Automatically: The calculations for intrinsic value and NPV refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly evaluate different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for Medalist Diversified REIT, Inc. (MDRR)?
- Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for real estate investment trusts.
- Customizable Inputs: Modify yellow-highlighted cells to explore different investment scenarios.
- Detailed Insights: Automatically computes Medalist Diversified REIT’s intrinsic value and Net Present Value.
- Preloaded Data: Historical and projected data provide reliable starting points for analysis.
- Professional Quality: Perfect for real estate analysts, investors, and financial consultants.
Who Should Use This Product?
- Investors: Assess the fair value of Medalist Diversified REIT, Inc. (MDRR) to inform your investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and analysis specific to real estate investments.
- Consultants: Easily customize the template for client valuation reports in the real estate sector.
- Entrepreneurs: Discover financial modeling techniques employed by leading real estate investment firms.
- Educators: Employ it as a resource to illustrate valuation practices in real estate finance.
What the Template Contains
- Preloaded MDRR Data: Historical and projected financial data, including revenue, net operating income, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, occupancy rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.