Pro Forma vs Underwritten NOI: The Gap That Kills Deals

The model was tight. Every metric cleared the lender's stated minimums. The debt yield was 9.8% on a 9% floor. The DSCR was 1.31x on a 1.25x minimum. The term sheet arrived and proceeded to take $1.1 million off the top — with no explanation beyond a different loan amount.

Nothing in the capital structure changed. The property did not change. The only thing that moved was the NOI the lender used — and it was not the number submitted in the package.

This gap between pro forma NOI and underwritten NOI is the single most common source of unexpected loan shortfalls in commercial real estate. Understanding exactly what lenders cut and why is the only way to model proceeds accurately before a term sheet reveals the answer.

What pro forma NOI looks like

A borrower's pro forma NOI typically reflects:

• Current actual rents from the existing rent roll
• 2%–3% vacancy assumption (often matching current occupancy)
• Current operating expenses per the trailing 12-month P&L
• No replacement reserves, or minimal reserves well below lender standards
• Projected rent growth of 2%–3% annually

This is not dishonesty — it is optimism. The borrower is showing the property as it is performing today, with reasonable assumptions about its near-term trajectory.

What lenders do to it before running any formula

The lender's underwriting department receives the package and constructs their own NOI independently. Here is the typical sequence:

1. Market vacancy is applied regardless of current occupancy

The lender does not care that the building is 100% occupied today. They apply a market vacancy factor based on property type and location, typically 5%–8% for stabilized multifamily, 8%–12% for office, and 5%–10% for retail and industrial.

If your gross income is $2,000,000 and they apply 7% market vacancy where you used 2%:

Your deduction:   $40,000  (2%)
Lender deduction: $140,000 (7%)
Difference:       $100,000 lost from NOI

2. Replacement reserves are added as a line item

Lenders underwrite a replacement reserve for future capital expenditure — roof replacement, HVAC, parking surfaces — even if you have not budgeted for it. Typical reserve assumptions:

On a 60,000 sq ft office building at $0.25/sqft, that is $15,000/year deducted from NOI before the lender runs a single formula.

3. Miscellaneous income is haircut or removed

If the rent roll includes parking, storage, laundry, signage, antenna leases, or other miscellaneous income, lenders often apply a haircut — sometimes 25%–50% — because those revenue streams are viewed as less stable than base rent. Some lenders exclude them entirely from the underwritten NOI.

4. Expiring leases are stress-tested, not projected

This is where lenders cause the most surprise. If any tenant with a meaningful lease is expiring within 18–24 months, the lender does not assume renewal. They run a stress scenario: the space goes dark for 6–12 months, then re-tenants at market rent, with tenant improvement and leasing commission costs deducted upfront.

On a retail center where an anchor tenant generating $200,000 of annual rent has 18 months remaining, the lender may deduct:

• $200,000 × 50% (6 months dark) = $100,000 lost rent
• TI/LC reserve: $30/sqft × 20,000 sqft = $600,000, amortized over 5 years = $120,000/year
• Total stress-test deduction: $220,000

That $220,000 is removed from the NOI before applying the debt yield floor or the DSCR test. On a 9% floor, that deduction alone reduces the maximum loan by $2,444,444.

The cumulative impact

Here is the same property modeled at the borrower's NOI vs. the lender's underwritten NOI:

At a 9% debt yield floor:

That $4.3 million gap does not appear anywhere on the term sheet as an explanation. It appears as a loan amount $4.3 million below what you expected. And it was entirely predictable if the underwriting assumptions had been modeled before submission.

How to close the gap before the term sheet

The practical answer is to ask the lender their underwriting assumptions before the package is submitted — not after.

Three questions close most of the gap:

1. "What vacancy factor will you apply to this property type in this market?" — Get the percentage in writing. Model it yourself.
2. "What replacement reserve line item will you underwrite?" — Ask for per-unit or per-square-foot assumption.
3. "Are there any leases expiring in the next 24 months that you will stress-test?" — If yes, ask what their dark period and TI/LC assumptions look like.

With those three answers, you can construct the lender's NOI yourself before the package is submitted. The maximum loan you calculate will be within 3%–5% of what the term sheet produces. You will know which assumption is the problem — and you can address it before the lender does.

What to do when your deal depends on a higher NOI

When the lender's underwritten NOI produces insufficient proceeds, there are four paths:

1. Bring more equity. Reduce the loan request to match the lender's proceeds ceiling. The debt yield and DSCR constraints apply to the lender's NOI — they do not move.

2. Increase actual NOI before closing. If you can burn off concessions, sign a vacant tenant, or eliminate a cost line before the appraisal date, the lender may use the higher stabilized NOI.

3. Negotiate specific line items. Challenge specific deductions with documentation: updated tax assessments, signed leases for rolling tenants, third-party management quotes. Do not argue the standard — argue the facts that change how the standard applies.

4. Change lenders. Portfolio lenders have more discretion than CMBS programs. A bank with existing relationship exposure may apply more favorable underwriting assumptions than a CMBS originator bound by securitization pool rules. The CREFC market standards that govern CMBS underwriting leave far less room for case-by-case adjustment than a Fannie Mae DUS lender's underwriting guidelines or a conventional bank's credit policy.

Use the debt yield calculator and CRE loan sizing calculator to model proceeds under both your NOI and the lender's likely underwritten NOI before submitting any package.

Frequently asked questions

Is the lender's underwritten NOI ever higher than the borrower's pro forma? Occasionally, yes — typically when a borrower is being overly conservative or when below-market rents are in place. If the property's current leases are well below market and the lender underwrites to market rent (on multifamily stabilized programs, Fannie Mae and Freddie Mac often underwrite to market), the lender's NOI may exceed what the borrower submitted. This is more common on agency multifamily than on CMBS or bank programs.

Do lenders share their underwriting worksheets with borrowers? Most will share a summary of their key assumptions — vacancy, reserves, major deductions — but not always the full model. CMBS lenders may share less than portfolio lenders because their credit decision involves rating agency review, not just the originator's judgment. Asking for a pre-submission underwriting call is often more productive than requesting the worksheet.

If I hire a third-party property manager, does that affect the lender's management fee assumption? Only if you can document the actual management contract and fee structure. Lenders typically underwrite a market management fee regardless of actual arrangements — often 4%–5% of EGI. If your actual management fee is lower and you can prove it with a signed contract, some lenders will credit the lower fee. Others will apply the market standard regardless.

How does the lender's NOI affect the cap rate on the appraisal? The appraisal and the lender's credit underwriting may use different NOI figures. The appraisal reflects market value, which the appraiser determines using comparable sales and income approaches. The lender's credit underwriting uses their own stressed NOI for loan sizing. The two can diverge — an appraisal may support a high value using market rents while the lender's credit underwriting uses a more conservative income figure.

Does the Mortgage Bankers Association publish data on how lenders underwrite NOI? The MBA's commercial real estate surveys capture lender appetite and underwriting conditions at a high level but do not publish detailed NOI underwriting standards by lender type. The most authoritative source for agency underwriting requirements is the Fannie Mae DUS resource center and the comparable Freddie Mac seller/servicer guide.