Why Do the Rent Roll and T-12 Disagree? Build a Bridge to Underwritten NOI

The broker's summary, current rent roll, and trailing operating statement may all show different income. That is not automatically a data error. One describes a current lease position, another summarizes recorded activity over twelve months, and the third may describe a future operating plan. Underwriting starts by making those differences explicit.

A multifamily NOI and cash flow calculator is useful only when its inputs describe the same property and clearly identified periods. Property investors evaluating commercial real estate cash flow analysis software should start with this reconciliation: which income is reported, which NOI is normalized, and which cash flow belongs to the forward investment analysis?

Put a date and a definition beside each number

Write down the rent roll's as-of date, the exact start and end of the T-12, and the period behind the OM's financial table. Confirm whether the operating statement uses cash or accrual accounting. If the source does not say, ask. Do not silently treat a January-to-December statement as the latest trailing year in October.

Keep three income views in the workpaper: what the leases show now, what the property recorded historically, and what you expect it to earn. This makes it easier to distinguish extraction corrections from underwriting judgments. Correcting a transposed number restores the source; assuming higher rents changes the forecast.

Explain the gap between leases and recorded income

Consider an illustrative property with $150,000 in current monthly contract rent across its occupied units. Multiplying by twelve gives a $1.8 million annual run rate. Suppose the T-12 shows $1.68 million in net rental income. The $120,000 difference is a question to investigate, not an automatic increase to NOI.

• Check whether occupied units or rents changed during the year.
• Identify concessions, bad debt, and collection timing.
• Confirm whether recurring charges are included in one source but separated in another.
• Keep vacant-unit market rents separate from occupied-unit contract rent.
• Ask for monthly detail where an annual total hides a recent change.

A useful reconciliation can include an unresolved remainder. If the team can explain only $90,000 of that $120,000 gap, record the remaining $30,000 and assign a follow-up. Forcing the bridge to zero by inventing a catch-all adjustment hides the issue.

Build a bridge from reported to underwritten NOI

The example below is a proposed workpaper structure. All figures are illustrative annual dollars. Each adjustment needs its own evidence and reviewer decision before it becomes an adopted forecast.

Keep the source and timing beside each adjustment. A quote effective halfway through the forecast year should not be applied for a full year without explanation. A renovation expense cannot simply disappear from the analysis because it sits outside recurring operating costs; it still needs a place in the cash-flow schedule.

Fannie Mae's Form 4254 distinguishes borrower actuals from normalized results and separately calculates cash flow after replacement reserves. That supports a useful discipline: name the measure and preserve the adjustments, rather than using NOI and cash flow interchangeably. Apply the definitions required by your own analysis.

Show how the NOI decision affects value

For a simple direct-capitalization illustration, $890,000 divided by a 5.5% cap rate gives about $16.18 million. Capitalizing the unadjusted $900,000 at the same rate gives about $16.36 million. The $10,000 annual NOI difference moves indicated value by about $181,818. These are arithmetic examples, not market cap-rate recommendations.

Changing the NOI basis and cap rate at the same time can conceal what caused the valuation change. First show the effect of the income adjustments at a fixed rate. Then show the cap-rate sensitivity separately. For a refresher on that calculation, see our cap-rate guide.

Make the report explain its NOI

A reviewer should be able to find the historical period, the adjustment bridge, the adopted NOI, and the cap rate without reconciling several screenshots. The buyer's return analysis should also identify its financing, hold period, exit assumption, and capital spending. Those inputs answer different questions from the direct-cap valuation.

Cactus's automated underwriting report separates the income story, cost story, valuation, and buyer returns. The example we reviewed includes a T-12-to-valuation NOI bridge and makes the age of the operating statement visible. Use a demo to check whether your own report explains each change and leaves unsupported assumptions open for review.