Underwritten NOI vs. Actual NOI in Commercial Real Estate
Distinguish historical NOI, lender-adjusted operating income and post-reserve NCF, with a documented hypothetical reconciliation.
Actual NOI describes operating income for a stated historical period. Underwritten NOI reflects accepted adjustments for a lending analysis and can differ in either direction. A separate reserve deduction may produce underwritten NCF. Do not assume a standard percentage haircut or call every post-reserve figure ordinary NOI.
Identify the period and accounting basis
Record the reporting dates and whether the source reflects collected cash, accruals or projections. Actual income is not automatically a sustainable forecast, and projected rents are not already collected. Compare the rent roll, leases, collections and operating statements before explaining the variance.
Document each adjustment
| Category | Question |
|---|---|
| Rent and vacancy | Does reported rent already reflect vacancy or credit loss? |
| Other income | Is the amount supported, recurring and counted only once? |
| Management | Does the accepted expense differ from recorded costs? |
| Taxes and insurance | Are there supported future changes? |
| Capital work | Is it incorrectly classified as a recurring operating expense? |
| Reserve allowance | Is this a separate deduction under the applicable income definition? |
Tax reassessment depends on local rules and circumstances; a sale does not establish one universal reassessment method. Do not automatically deduct a fixed vacancy, management or reserve percentage from collected income.
T12 Actuals vs. Underwritten Pro Forma Comparison
The table below contrasts historical operating financials against standard institutional lender adjustments on a 100-unit multifamily property:
| Line Item | Borrower T12 Actuals | Lender Underwritten Pro Forma | Underwriting Haircut Rationale |
|---|---|---|---|
| Gross Potential Rent | $1,200,000 | $1,200,000 | In-place rent roll verified |
| Physical & Economic Vacancy | -$24,000 (2.0% actual) | -$60,000 (5.0% floor) | Institutional 5.0% market vacancy floor applied |
| Effective Gross Income (EGI) | $1,176,000 | $1,140,000 | Haircut: -$36,000 revenue reduction |
| Operating Expenses | -$380,000 | -$395,000 | Tax reassessment & insurance adjustment |
| Management Fee | -$20,000 (1.7% actual) | -$39,900 (3.5% floor) | Mandatory 3.5% third-party management fee floor |
| Replacement Reserves | $0 (not reserved) | -$25,000 ($250/unit) | Mandatory capital replacement reserve ($250–$350/unit) |
| Underwritten Net Cash Flow | $776,000 | $680,100 | Net Sizing Haircut: -$95,900 (-12.36%) |
This 12.36% haircut directly contracts maximum debt yield proceeds: at an assumed 9.0% debt yield hurdle, loan sizing contracts from $8,622,222 down to $7,556,667—an immediate $1,065,555 equity gap. Build your own line-item underwriting model with our NOI Calculator.
A hypothetical reconciliation
Assume historical collected rent of $1 million, other income of $30,000 and operating expenses of $380,000. Historical operating NOI is $650,000.
For a separate hypothetical underwriting scenario, assume the lender accepts $950,000 of rent after a documented additional adjustment, $15,000 of other income and $440,000 of operating expenses. The expense change includes an incremental $40,000 management allowance and $20,000 tax adjustment. These are invented assumptions, not agency standards.
| Calculation | Amount |
|---|---|
| Accepted operating revenue | $965,000 |
| Accepted operating expenses | ($440,000) |
| Underwritten operating NOI | $525,000 |
| Separate reserve allowance | ($15,000) |
| Post-reserve income | $510,000 |
The post-reserve figure is $140,000 below historical operating NOI, or approximately 21.5%. This comparison includes both operating adjustments and a separate reserve deduction; do not describe the entire change as one NOI haircut.
Apply the lender's income definition
At an illustrative 10% DY target, $650,000 supports $6.5 million and $510,000 supports $5.1 million under that test. The $1.4 million difference is a DY-only sizing difference, not proof of a closing equity shortfall; the full budget and other limits still matter. NOI is the numerator of DY and DSCR, not their denominator.
See the reserve guide for the specific Fannie Mae NCF definition and the pro forma reconciliation guide for a repeatable process. Use the NOI worksheet to preserve each adjustment and source rather than guessing a universal haircut.
Ready to run the numbers?
Get your result instantly — private, in your browser.