Wheeler Real Estate Investment Trust, Inc. (WHLR) 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
Wheeler Real Estate Investment Trust, Inc. (WHLR) Bundle
Discover the true potential of Wheeler Real Estate Investment Trust, Inc. (WHLR) with our advanced DCF Calculator! Customize key assumptions, explore various scenarios, and examine how adjustments affect Wheeler Real Estate Investment Trust, Inc. (WHLR) valuation – all within one comprehensive Excel template.
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 | 63.2 | 61.0 | 61.3 | 76.6 | 102.0 | 106.0 | 110.1 | 114.4 | 118.9 | 123.5 |
| Revenue Growth, % | 0 | -3.42 | 0.50325 | 25.01 | 33.08 | 3.9 | 3.9 | 3.9 | 3.9 | 3.9 |
| EBITDA | 32.2 | 34.7 | 34.6 | 41.2 | 59.2 | 58.5 | 60.8 | 63.1 | 65.6 | 68.1 |
| EBITDA, % | 50.94 | 56.83 | 56.38 | 53.72 | 58 | 55.18 | 55.18 | 55.18 | 55.18 | 55.18 |
| Depreciation | 45.5 | 43.1 | 38.0 | 56.6 | 28.5 | 65.0 | 67.5 | 70.2 | 72.9 | 75.7 |
| Depreciation, % | 72.1 | 70.72 | 62.02 | 73.83 | 27.94 | 61.32 | 61.32 | 61.32 | 61.32 | 61.32 |
| EBIT | -13.4 | -8.5 | -3.5 | -15.4 | 30.7 | -6.5 | -6.8 | -7.0 | -7.3 | -7.6 |
| EBIT, % | -21.16 | -13.88 | -5.65 | -20.11 | 30.06 | -6.15 | -6.15 | -6.15 | -6.15 | -6.15 |
| Total Cash | 5.5 | 7.7 | 22.9 | 28.5 | 18.4 | 24.1 | 25.1 | 26.0 | 27.0 | 28.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6.9 | 9.2 | 9.2 | 13.5 | 13.1 | 15.2 | 15.8 | 16.4 | 17.0 | 17.7 |
| Account Receivables, % | 10.93 | 15 | 15.06 | 17.67 | 12.87 | 14.31 | 14.31 | 14.31 | 14.31 | 14.31 |
| Inventories | 46.4 | .0 | 69.2 | .0 | .0 | 36.8 | 38.2 | 39.7 | 41.2 | 42.8 |
| Inventories, % | 73.42 | -0.000001639264 | 112.9 | 0.000001304717 | 0 | 34.68 | 34.68 | 34.68 | 34.68 | 34.68 |
| Accounts Payable | 9.6 | 11.2 | 11.1 | 18.4 | 17.1 | 19.6 | 20.3 | 21.1 | 21.9 | 22.8 |
| Accounts Payable, % | 15.13 | 18.41 | 18.03 | 24 | 16.73 | 18.46 | 18.46 | 18.46 | 18.46 | 18.46 |
| Capital Expenditure | -2.7 | -2.3 | -6.4 | -8.5 | -20.0 | -10.4 | -10.8 | -11.3 | -11.7 | -12.2 |
| Capital Expenditure, % | -4.29 | -3.72 | -10.46 | -11.1 | -19.63 | -9.84 | -9.84 | -9.84 | -9.84 | -9.84 |
| Tax Rate, % | 176.45 | 176.45 | 176.45 | 176.45 | 176.45 | 176.45 | 176.45 | 176.45 | 176.45 | 176.45 |
| EBITAT | -13.4 | 466.4 | -3.5 | -39.1 | -23.4 | -3.9 | -4.1 | -4.2 | -4.4 | -4.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -14.3 | 553.1 | -41.3 | 81.2 | -15.9 | 14.4 | 51.4 | 53.4 | 55.4 | 57.6 |
| WACC, % | 6.62 | 0.00153332 | 6.62 | 6.62 | 0.00153332 | 3.97 | 3.97 | 3.97 | 3.97 | 3.97 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 203.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 59 | |||||||||
| Terminal Value | 2,976 | |||||||||
| Present Terminal Value | 2,449 | |||||||||
| Enterprise Value | 2,652 | |||||||||
| Net Debt | 487 | |||||||||
| Equity Value | 2,165 | |||||||||
| Diluted Shares Outstanding, MM | 0 | |||||||||
| Equity Value Per Share | 121,778.13 |
What You Will Get
- Real WHLR Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Wheeler Real Estate Investment Trust, Inc.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on WHLR’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections specific to WHLR.
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and adaptability.
Key Features
- Comprehensive DCF Analysis: Offers detailed unlevered and levered DCF valuation models tailored for Wheeler Real Estate Investment Trust, Inc. (WHLR).
- WACC Calculation Tool: Features a pre-built Weighted Average Cost of Capital sheet with customizable parameters.
- Adjustable Forecast Variables: Easily modify growth projections, capital expenditures, and discount rates.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Wheeler Real Estate Investment Trust, Inc. (WHLR).
- User-Friendly Dashboard and Visuals: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Wheeler Real Estate Investment Trust, Inc.'s (WHLR) pre-filled financial data and forecasts.
- Step 3: Modify essential inputs such as rental income growth, capitalization rates, and operating expenses (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Wheeler Real Estate Investment Trust, Inc. (WHLR)?
- Save Time: Utilize our pre-built financial models without the hassle of starting from scratch.
- Enhance Accuracy: Dependable data and established formulas minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify the analysis of results.
- Endorsed by Professionals: Crafted for experts who prioritize both precision and ease of use.
Who Should Use This Product?
- Real Estate Investors: Develop comprehensive and accurate valuation models for property analysis.
- Property Management Teams: Evaluate valuation scenarios to inform strategic decisions.
- Consultants and Advisors: Deliver clients precise valuation insights for Wheeler Real Estate Investment Trust, Inc. (WHLR).
- Students and Educators: Utilize real-world data to learn and teach real estate financial modeling.
- Market Analysts: Gain insights into how real estate investment trusts like WHLR are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Wheeler Real Estate Investment Trust, Inc.'s (WHLR) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital tailored for (WHLR).
- Financial Ratios: Assess (WHLR)'s profitability, leverage, and efficiency metrics.
- Editable Inputs: Modify assumptions such as growth rates, margins, and CAPEX to suit your analysis.
- Financial Statements: Access annual and quarterly reports for comprehensive evaluation.
- Interactive Dashboard: Visualize key valuation metrics and outcomes with ease.