REIT Acquisition Model Overstates FFO Through an Unreconciled Depreciation Add-Back
Executive Summary
Background¶
This is an illustrative, composite scenario, not a specific real transaction, built to demonstrate a recurring pattern.
A REIT's internal underwriting team was preparing an acquisition model for a target office portfolio ahead of an investment committee vote. As is standard practice, the model built a funds from operations (FFO) reconciliation to present the acquisition's expected contribution to the REIT's core reported metric — see REIT Financial Model Structure for the general FFO/AFFO build methodology this case illustrates.
What Happened¶
The FFO reconciliation added back the target portfolio's total historical real estate depreciation, taken as a single summary figure directly from the target's audited financial statements, consistent with the standard FFO convention of adding back real estate depreciation to net income.
However, the acquisition model's own going-forward net operating income build had separately excluded ongoing tenant improvement (TI) amortization from projected operating cost, treating it instead as a capital item within the model's own capital expenditure schedule — a treatment decision made independently of, and not cross-referenced against, the historical depreciation figure being added back in the FFO reconciliation.
A portion of the historical depreciation figure related specifically to those same tenant improvement assets. Adding back the full historical depreciation figure while separately excluding the related TI amortization from the going-forward operating cost effectively double-counted a portion of the benefit, one adjustment in the historical add-back, a separate but overlapping adjustment in the going-forward NOI build, producing an FFO figure for the combined post-acquisition entity that was overstated relative to what would actually be reported.
How It Was Caught¶
An independent structural audit of the acquisition model traced the FFO reconciliation's depreciation add-back formula back to its source, the target's depreciation schedule, and cross-referenced the composition of that depreciation figure against how the acquisition model's own NOI build had treated tenant improvement costs going forward. The overlap between the two adjustments was identified through this trace, rather than being visible from the FFO summary line itself, which displayed as an internally consistent, correctly formatted figure with no obvious error indicator.
Resolution¶
The underwriting team corrected the FFO reconciliation to add back only the portion of historical depreciation not already addressed through the going-forward TI capital expenditure treatment, and the corrected FFO figure was presented to the investment committee alongside a note explaining the adjustment. The acquisition proceeded, with the committee's return expectations recalibrated to the corrected figure.
Lessons¶
An FFO or AFFO reconciliation is only as reliable as its traceability back to the specific depreciation and cost schedules it references. A headline add-back figure copied from a target's historical financials, without confirming consistency against how the acquisition model's own going-forward cost build treats the same underlying cost categories, can silently misstate a REIT's core reported metric, precisely because the resulting FFO line appears internally well-formed and does not itself signal the double-count.
Continue Reading¶
Related Pillars¶
Related Technical Guides¶
Related Glossary¶
Related Products¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
Is this a real client engagement?
No. This is an illustrative, composite scenario built from patterns commonly observed in financial model audits. It does not describe a specific, identifiable transaction.
What exactly caused the FFO figure to be overstated?
The FFO reconciliation added back the target portfolio's total historical real estate depreciation figure taken directly from its financial statements. A portion of that depreciation related to tenant improvement assets that the acquisition model's own going-forward NOI build had already excluded from projected operating cost on a different basis, so adding back the full historical depreciation figure effectively double-counted part of the benefit.
Why is this type of error easy to miss in a REIT acquisition model?
Because the FFO add-back is frequently pulled as a single summary figure from the target's historical financial statements, and without tracing that figure back against the acquisition model's own going-forward NOI and capital expenditure treatment, the double-count is not visible from the FFO line itself.
How did the independent audit identify the issue?
By tracing the FFO reconciliation's depreciation add-back formula against the underlying depreciation schedule and cross-referencing it against how the acquisition model's own NOI build had already treated tenant improvement costs, rather than accepting the add-back as a correctly sourced, standalone figure.
What is the broader lesson for REIT and portfolio acquisition modelling?
That FFO, AFFO, and similar non-GAAP reconciliations should be built as fully traceable formulas referencing the model's own underlying schedules, not summary figures copied from a target's historical financials without confirming those figures are consistent with how the acquisition model itself treats the same cost categories going forward.
Could a structural audit alone have caught this without understanding REIT accounting conventions?
The structural trace, following the FFO formula back to its source schedule and checking for consistency with the NOI build, is a general audit discipline applicable regardless of REIT-specific knowledge, though correctly interpreting what the double-count meant for the reported FFO figure did draw on REIT-specific reporting convention knowledge.
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.
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.
What Is a Financial Model Audit?
A financial model audit is an independent, structured examination of an Excel based financial model to confirm that its mechanics, logic, and outputs are reliable enough to support a decision. It is not a check of whether the assumptions are optimistic or conservative. It is a check of whether the model actually calculates what its author believes it calculates. Every year, lenders extend debt, investment committees approve capital, and boards sign off on transactions using numbers that came out of a spreadsheet nobody outside the immediate deal team has independently verified. A financial model audit exists to close that gap before it becomes expensive.