# REIT Portfolio Model Build a REIT model for multi-asset portfolio management with property-level NOI, FFO and AFFO reconciliation, debt tracking, and investor distribution modelling across residential, office, and retail assets. - Canonical: https://finamodel.com/templates/reit-portfolio-model - Excel download: https://finamodel.com/templates/reit-portfolio.xlsx - Category: Real Estate - Model type: Portfolio - Difficulty: Intermediate - Audiences: Fund managers, Investors & analysts, REIT investors, Equity analysts, Real estate brokers - Tags: reit, nav-analysis, property-valuation, cap-rates, nav-per-share ## Overview Analyze a diversified REIT's portfolio of industrial, office, retail, and multifamily properties with segment-level NOI modeling, debt covenants, and FFO/AFFO metrics. This template projects NOI by property segment with occupancy and rent growth assumptions specific to each asset type, calculates FFO (net income plus depreciation add-back minus gains on sale) and AFFO (FFO minus maintenance capex treated as opex), and tracks funded dividend payout ratios. NAV per share is calculated from forward NOI divided by implied cap rate, less net debt. The workbook includes property portfolio segments with rent PSF, occupancy rates, and operating expense ratios by property type, a debt schedule with amortisation and DSCR monitoring (typically 1.25x+), an income statement where maintenance capex flows through opex (not capex), and FFO/AFFO bridges showing the walk from net income to distributable cash. The valuation sheet calculates NAV per share, NAV premium/discount to market price, P/FFO and P/AFFO multiples, and dividend yield. Key risks are cap rate expansion (impacts NAV), office occupancy decline (structural headwind post-WFH), and interest rate increases (refinance risk). Target users are REIT equity analysts, institutional real estate investors, REIT shareholders, and credit analysts evaluating REITs managing $5B to $100B+ in real estate assets. ## What's included - Multi-asset property roll with granular NOI builds - FFO and AFFO reconciliation following NAREIT guidelines - Portfolio-level consolidation and NAV analysis - Debt service coverage and LTV tracking by asset - Investor distribution waterfall with preferred return and promote logic - Property inventory with asset type, location, and occupancy - NOI by property with revenue and expense drivers - Cap rate and valuation methodologies by property type - Debt schedule and leverage by loan facility - Acquisition and disposition assumptions - Net asset value (NAV) and implied share valuation ## Understanding the REIT Portfolio Model: FFO, AFFO, NAV, and Debt This reit portfolio model template projects five years of financial statements for a diversified REIT, integrating property-level operations, lease rollover, capital planning, debt, and valuation. It structures NOI by segment, reconciles FFO and AFFO, calculates NAV, and monitors covenant headroom, offering a practical framework for institutional investors and analysts evaluating REIT performance and risks. ### Operating Drivers and Revenue Architecture The model builds revenue from property-level operations, not from broad assumptions. Each of the four segments—industrial, office, retail, and multifamily—has its own lease mechanics: expiring space based on weighted average unexpired lease term, renewal probability, downtime months, and mark-to-market spreads. - Occupancy converges toward a stabilised level at an absorption rate, while rent per square foot blends retained and re-let rents. This approach captures re-leasing risk and income dynamics. - All segments follow a uniform NOI build: gross potential revenue less vacancy and credit losses yields effective gross revenue, then subtracts operating expenses to arrive at segment NOI. The model reports portfolio WAULT to summarise lease length. ### Calculation Flow and Integration Projections flow through integrated statements. The capital plan tracks recurring maintenance capex, leasing capital, acquisitions, disposals, and equity funding, feeding a property roll-forward. - Debt includes a senior amortising tranche, a bullet tranche refinanced at maturity, and a revolver that maintains a minimum cash floor; interest is calculated on opening balances. The income statement, balance sheet, and cash flow statement are fully linked, with non-cash items like depreciation and straight-line rent adjustments reconciled. - Corporate G&A and a low effective tax rate reflect the REIT pass-through structure. Distributions are shown as a separate contra-equity line because they typically exceed net income due to non-cash depreciation. ### Outputs and Performance Metrics The model produces key REIT metrics. FFO starts with net income, adds back real estate depreciation, and removes gains on disposal. - AFFO further deducts maintenance capex, leasing costs, and straight-line rent. Per-share figures use weighted-average shares. - Valuation derives segment values by dividing segment NOI by segment cap rates, then subtracts net debt to calculate NAV and NAV per share. It reports premium or discount to NAV, price-to-FFO, price-to-AFFO, dividend yield, and implied cap rate. Debt metrics include LTV on market value and historic cost, interest coverage, and debt service coverage, each with live covenant headroom against named thresholds. Sensitivity grids test NAV per share against exit cap rates and rent growth, and DSCR against interest rates. ### Practical Use and Risk Assessment This template supports evaluating REIT performance under base, bull, and bear scenarios. - A single toggle switches cap rates, rent escalations, occupancies, and mark-to-market spreads, allowing users to stress-test key risks: cap rate expansion, office occupancy decline, interest rate resets on refinancing, payout sustainability, and re-leasing risk. - The checks sheet validates balance sheet integrity, cash reconciliation, debt ties, and covenant compliance across all scenarios. - By linking lease-level assumptions to financial statements and valuation, the model helps users assess whether a diversified REIT's projected FFO/AFFO growth, dividend coverage, and asset values justify a buy, hold, or sell decision within a five-year horizon. ## Built for REIT-specific analysis Use this model when you need to track property-level performance, reconcile FFO and AFFO, and manage distributions across a diversified real estate portfolio. ## Useful for portfolio management and reporting A REIT model helps bridge property-level cash flows to portfolio-level KPIs, debt monitoring, and investor reporting in one integrated structure. ## Better than single-asset models for portfolio work This gives you a multi-property framework with consolidated outputs instead of running separate models for each asset and manually aggregating results. ## Built for REIT-specific analysis Use this model when you need to track property-level performance, reconcile FFO and AFFO, and manage distributions across a diversified real estate portfolio. ## Useful for portfolio management and reporting A REIT model helps bridge property-level cash flows to portfolio-level KPIs, debt monitoring, and investor reporting in one integrated structure. ## Better than single-asset models for portfolio work This gives you a multi-property framework with consolidated outputs instead of running separate models for each asset and manually aggregating results. ## Features - **Property-level NOI modeling:** Tracks occupancy, rent growth, and operating margins by property to forecast contribution to REIT earnings. - **Multi-asset class cap rates:** Applies property-type-specific cap rates to value stabilized properties in the portfolio. - **NAV and peer comparison:** Calculates net asset value per share and compares to trading price to identify valuation gaps. ## Use cases - **REIT equity research and valuation:** Model property NOI growth, cap rate compression, and debt paydown to forecast REIT NAV and share returns. - **Portfolio optimization and disposition planning:** Evaluate property contribution to REIT returns and identify candidates for sale or 1031 exchange. - **Dividend sustainability and payout policy:** Forecast FFO and AFFO to assess dividend sustainability and identify upside or downside risks. ## Frequently asked questions ### What is a REIT portfolio model? It is a model that tracks property-level income, FFO/AFFO metrics, debt, and investor distributions across a portfolio of real estate assets held within a REIT structure. ### What should a REIT model include? It should include property-level NOI, FFO and AFFO reconciliation, NAV analysis, debt tracking, and distribution waterfall mechanics. ### Who uses REIT portfolio models? REIT managers, real estate analysts, private equity firms, and institutional investors use them for portfolio management, performance reporting, and capital planning. ### What is the difference between FFO and AFFO? FFO adds back depreciation to net income. AFFO further adjusts for recurring capital expenditures and leasing costs to show cash flow available for distribution. ### Can it handle different property types? Yes. The model supports multiple asset classes including residential, office, retail, and industrial properties, each with their own lease structures and assumptions. ## Related templates - [Real Estate Development Pro Forma Model](https://finamodel.com/templates/real-estate-model) - [Real Estate Fund Investment Model](https://finamodel.com/templates/real-estate-fund-model) - [Multifamily Residential Model](https://finamodel.com/templates/multi-family-model)