Need help with REITs ER Modeling

When valuing a newly listed self-storage REIT with limited historical data, a DCF model tailored for REITs can be a powerful tool. Based on the most helpful WSO content, here’s how you can approach this:

Key Steps for Your REIT DCF Model:

1. Forecasting Cash Flows:

   • Focus on Funds from Operations (FFO) or Adjusted Funds from Operations (AFFO) as the primary cash flow metric. These are more relevant for REITs than traditional net income.
   • Use available data (e.g., quarterly reports, investor presentations) to estimate revenue growth, operating expenses, and property-level NOI (Net Operating Income).

2. Terminal Value:

   • Use a cap rate approach for terminal value, which is common in REIT valuations. Terminal Value = Stabilized NOI / Cap Rate.
   • Alternatively, you can use a perpetual growth model if cap rate data is unavailable.

3. Discount Rate:

   • Use the Weighted Average Cost of Capital (WACC) or a cost of equity approach. For REITs, the cost of equity is often derived using CAPM, and the cost of debt is based on the REIT’s borrowing rates.

4. NAV and Sensitivity Analysis:

   • Complement your DCF with a Net Asset Value (NAV) analysis. NAV = (Fair Value of Assets - Liabilities) / Shares Outstanding.
   • Perform sensitivity analysis on key variables like cap rates, growth rates, and discount rates to account for the limited historical data.

Resources for Models:

• WSO Financial Modeling Templates: The WSO platform offers 27 financial modeling templates, including DCF models, which can be adapted for REITs. These templates are dynamic and can help you structure your inputs and outputs effectively.
• REFM Courses: The Real Estate Financial Modeling (REFM) courses on WSO provide self-study materials that include REIT-specific valuation techniques.
• Multifamily and Self-Storage Models: While not directly for REITs, the multifamily and self-storage acquisition models discussed in WSO threads can be adapted for your needs.

Pro Tips:

• Limited Historical Data: Use industry benchmarks and peer analysis to fill gaps in historical data. Look at similar self-storage REITs for guidance on growth rates, cap rates, and expense ratios.
• Dynamic Inputs: Ensure your model is dynamic, with clear assumptions for revenue growth, cap rates, and discount rates. Avoid hardcoding values.
• IRR and Sensitivity Checks: Include an IRR calculation for the REIT’s cash flows and test your assumptions with sensitivity analysis.

If you’re looking for a ready-to-use model, consider reaching out to the WSO community. Many users have shared REIT-specific models or are willing to provide guidance for a fee. You can also explore the WSO templates library for a starting point. Good luck with your modeling test!

Sources: Multi-Family Acquisitions Excel Test, Beginner RE Valuation/Modeling, DCF Myth 1: If you have a D(discount rate) and a CF (cash flow), you have a DCF!, Self Storage and MF Models