REIT Financial Model –NAV (Net Asset Value) & DCF Valuation Analysis Model

Financial Model, Hospitality, Hotel, Investment, Real Estate

10-year Financial Projections, 5-year Financial Projections, Business Valuation, Cap Rate (Capitalization Rate), Cap Table, Cash Flow Analysis, Cash Flow Projections, CFO, DCF Model, Financial Model, Financial Modeling, Financial Projections, Financial Ratios, Financial Statements, Forecast, Forecasting, Property Valuation, Real Estate Valuation, Rental Income, Revenue Projections

This is a REIT (Real Estate Investment Trust) financial model with detailed segment revenue, Net Asset Value, and DCF valuation analysis.

Currently, REIT products have become one of the most popular elements of the majority of investors’ portfolios since their high yield and relatively low barrier compared with private funds.

Therefore, understanding your REIT operation model and its valuation would be quite helpful for an investor’s decision.

This model provides investors and analysts a comprehensive and detailed forecast model of the REIT target company / project that the users could easily figure out your REIT’s NAV and valuation by simply modifying some inputs.

The model could be generally separated into three parts.
The 1st part includes “Rev by Seg” and “Model” in which users could find out how REIT generates revenue, its key drivers for each segment, and the comprehensive forecast of Three Financial Statements.

“Rev by Seg” also has scenarios embedded that let users easily switch the cases and learn the outcomes of distinct circumstances.

“Model” sheet is demonstrating the assumptions of key drivers for three financial statements forecast and the outcomes.

The 2nd part contains “NAV” and “DCF” sheets where users can figure out the valuation of the REIT target based on the two methodologies.

In the “NAV” sheet, we performed a detailed calculation of the NAV of the target company and the sensitivity analysis sensitizing NOI (net operation income) and cap rate.

In the “DCF” sheet we performed Discounted cash flow analysis based on the 10 years forecast.

The 3rd part is the instruction of the model and includes “Guidance” and “Rev Forecast Logic” sheets.

In “Guidance” we displayed the structure of the model and keynotes of each element.

In the “Rev Forecast Logic” sheet we detailed and explained the logic of the revenue forecast for each segment.

To guarantee the user-friendly feature, the model clearly explained its calculation logic by applying simple formulas.

The model is completely customizable both for the operation part and for the valuation part. All inputs are in color BLUE that the users could modify according to their real circumstances.

With the above-mentioned characteristics, the model will be a great helpful tool for REIT investment project analysis and decision-making purposes.

The template is greatly user-friendly either for professional analysts or for users with little experience in financial modeling since its simple design pattern and easy-to-follow logic. The model will provide useful information and be helpful for decision-making.

To guarantee the users’ satisfaction, the model does not place any complicated formulas or VBA code. The structure and content have been created following the Best Financial Modeling Principles and considering the high level of flexibility and user-friendly priority.

Please don’t hesitate to contact us if you experience any problems when using the models provided.
In addition, if you need a customized model for your specific business, please just let us know and we would be happy to help you with this.

Model Structure
1. “Model” – Three Financial Statements Model
2. “Rev by Seg” – Revenue Forecast for each Segment with scenarios switch function
3. “NAV” – Calculation and sensitivity analysis on Net Asset Value of targe REIT
4. “DCF” – Assumptions, calculation, outputs, and sensitivity analysis on Valuation of target REIT by Discounted Cash Flow
5. “Guidance”- Explanation of structure of the model
6. “Rev Forecast Logic” – Explanation of Revenue forecast logic

You must log in to submit a review.