REIT and Portfolio Model Audit Checklist
Executive Summary
Key Takeaways
- ✓ REIT and portfolio models carry entity-level FFO/AFFO, NAV, and distribution coverage mechanics that a single-asset income model checklist does not test.
- ✓ FFO and AFFO figures should be checked as fully traceable reconciliations from net income against the underlying depreciation and capital expenditure schedules, not accepted as standalone summary figures.
- ✓ NAV methodology should be checked for consistency, confirming asset-by-asset direct capitalization is not conflated with an entity-level income capitalization shortcut.
- ✓ Distribution coverage should be checked as an explicit constraint on capital available for reinvestment, not assessed only as a downstream reporting metric.
Objective¶
This checklist verifies the structural mechanics specific to REIT and multi-asset portfolio real estate models: FFO/AFFO reconciliation traceability, NAV methodology consistency, and distribution coverage against the mandated payout ratio. It exists as a distinct checklist because these entity-level mechanics do not appear in a single-asset model and are not covered by the Income-Producing Asset Model Checklist, which this checklist assumes has already been applied to the underlying asset-level models.
Applicability¶
Applicable when reviewing a REIT's entity-level financial model, whether for ongoing reporting, an acquisition underwriting model, or a multi-asset portfolio valuation aggregating several individual assets.
Checklist¶
| # | Check Item | Why It Matters | Evidence to Collect |
|---|---|---|---|
| 1 | FFO is built as a live, traceable reconciliation from net income, not a standalone summary figure | An untraceable add-back figure can conceal a double-count or omitted adjustment | FFO reconciliation formula trace against net income |
| 2 | The depreciation add-back in the FFO reconciliation is checked for consistency against how the model's own going-forward NOI or capex build treats the same cost categories | Inconsistent treatment between historical add-back and going-forward cost build can double-count or omit an adjustment | Cross-reference of depreciation add-back against NOI/capex schedules |
| 3 | AFFO deducts recurring capital expenditure and adjusts for straight-line rent using the model's own schedules, not an assumed percentage | An assumed percentage disconnected from actual capex or rent schedules misstates the AFFO figure | AFFO adjustment schedule trace |
| 4 | NAV is built from asset-by-asset direct capitalization, not conflated with an entity-level net income capitalization | Mixing the two methodologies within one model produces an internally inconsistent NAV figure | NAV build methodology documentation |
| 5 | The mandated minimum distribution payout ratio is modelled as an explicit constraint on capital available for reinvestment | Treating distribution coverage only as a downstream check misstates capital genuinely available for growth | Distribution constraint formula trace |
| 6 | Acquisition and disposition transactions show their effect on portfolio-level FFO/AFFO, NAV, and distribution coverage explicitly | Omitting transaction-level effects understates how portfolio activity drives entity-level metrics | Transaction impact schedule |
| 7 | Portfolio aggregation preserves asset-level detail traceable from the entity-level summary | A purely top-down entity model prevents verifying which underlying assets drive the aggregate figures | Asset-level to entity-level reconciliation |
| 8 | Debt covenant and leverage metrics are calculated consistently at both the entity and, where relevant, individual-facility level | Inconsistent leverage calculation between levels can mask a covenant breach at one level while the other appears compliant | Leverage calculation cross-check across levels |
Common Failures¶
- FFO or AFFO presented as a standalone summary figure with no traceable reconciliation to net income.
- Historical depreciation add-back inconsistent with how the model's own going-forward cost build treats the same cost categories, producing a double-count.
- NAV calculated by blending asset-by-asset direct capitalization with an entity-level income capitalization shortcut.
- Distribution payout ratio compliance checked only after distributions are calculated, rather than modelled as an upfront constraint on reinvestment capital.
- Acquisition or disposition activity modelled without showing its explicit effect on entity-level FFO, NAV, or distribution coverage.
Recommended Evidence¶
A completed REIT or portfolio model review should be accompanied by an FFO/AFFO reconciliation trace, a NAV methodology confirmation, and a distribution coverage constraint trace. The table above is structured for direct use in investment committee submission materials or an independent audit working-paper file.
How to Use This Checklist¶
Apply the Income-Producing Asset Model Checklist to each underlying asset-level model first, then work through this checklist with particular attention to the FFO/AFFO traceability item, the one most likely to conceal a material entity-level error. See REIT Financial Model Structure for the full construction methodology and REIT Acquisition Model Overstates FFO Through an Unreconciled Depreciation Add-Back for an applied example.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Checklists¶
Related Case Studies¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Why does a REIT model need its own dedicated audit checklist?
Because it carries entity-level FFO/AFFO reconciliation, NAV methodology, and mandated distribution coverage mechanics that a single-asset income-producing asset model checklist does not test, and errors in these entity-level reconciliations are both common and hard to detect without tracing them to source.
What is the single highest-priority item on this checklist?
Confirming FFO and AFFO figures are built as fully traceable reconciliations from net income, referencing the actual underlying depreciation and capital expenditure schedules, rather than accepted as standalone summary figures that could conceal a double-count or omitted adjustment.
How should NAV methodology be checked?
For internal consistency, confirming the model uses asset-by-asset direct capitalization (summed, less net debt) rather than conflating it with an entity-level net income capitalization approach, since the two can produce materially different results if mixed inconsistently within the same model.
How should distribution coverage be checked?
As an explicit constraint feeding the model's capital available for reinvestment and growth, tested against the mandated minimum payout ratio applicable in the relevant jurisdiction, not assessed only as a downstream reporting metric calculated after the fact.
Who typically uses this checklist?
Investment committees and analysts reviewing a REIT's acquisition or portfolio model, and advisors conducting an independent review of a REIT's entity-level financial model.
Does this checklist replace the Income-Producing Asset Model Checklist?
No. It supplements it. The underlying asset-level income models aggregated into the REIT or portfolio structure should still be reviewed against the Income-Producing Asset Model Checklist; this checklist adds the entity-level checks specific to REIT and portfolio aggregation.
Related Articles
REIT Financial Model Structure
A REIT financial model differs from a single-asset income-producing asset model because it operates at the entity level across a portfolio of assets, is measured against REIT-specific metrics (FFO, AFFO, NAV per share) rather than standard corporate earnings, and is typically subject to a mandated minimum distribution payout ratio that directly constrains retained capital for growth. This guide sets out how these entity-level mechanics should be represented.
Income-Producing Asset Model Checklist
This checklist covers the structural checks specific to income-producing (stabilised) real estate asset models, on top of the general financial model audit baseline. It focuses on rent roll integrity, NOI normalization, the discount-rate-versus-exit-cap-rate distinction, and lease-level rollover treatment. It is intended for investment committees, lenders, and advisors reviewing an income-producing asset model ahead of an acquisition, financing, or valuation decision.
Net Operating Income
Net operating income (NOI) is a real estate asset's total revenue less operating expenses, calculated before debt service, capital expenditure, and depreciation. It is the anchor figure for valuing an income-producing asset, whether through direct capitalization (NOI divided by a market capitalization rate) or as the cash flow line discounted in a real estate DCF. NOI should be built from a lease-level rent roll and an itemized operating expense schedule, and normalized for one-off items before being used in a stabilised valuation.