How to Calculate NOI for a Commercial Property: The Lender’s Method

To calculate NOI the way a lender does, start with gross potential rent, subtract vacancy and credit loss, add verified other income to reach effective gross income (EGI), then subtract normalized operating expenses, including a market management fee. Lenders also deduct replacement reserves before sizing the loan. NOI excludes debt service, depreciation, income taxes and capital expenditures. Clik.ai automates this spreading for US lenders, tracing every adjustment to its source document.

Two analysts can spread the same trailing 12-month statement and land on NOI figures 8% apart. On a loan sized to a 1.25x debt service coverage ratio, a gap that size can change the maximum loan amount or push the deal into a credit exception. Lenders underwrite a normalized figure, and the borrower’s reported profit is only the starting point.

Calculate NOI Step by Step

Gather and digitize inputs

Underwriting starts with a complete document package:

• The current rent roll
• The T-12 operating statement
• Leases
• Real estate tax bills
• Insurance declarations

For many deals you’ll also want vacancy history and aged receivables. Collecting the documents is only half the job. Rent rolls come in dozens of formats, so the data needs to be extracted and mapped to a standard schema before underwriting: unit, tenant, lease dates, contract rent and concessions at minimum. A clean schema lets you check the rent roll’s total rent against collections on the T-12. Our Smart Extract product does this extraction and links each value to its page.

Build underwritten NOI

Revenue comes first:

1. Start with gross potential rent (GPR), the rent you’d collect if every unit were leased at contract or market rates.
2. Subtract vacancy and credit loss. Most underwriters use the greater of actual or market vacancy.
3. Add verified other income, such as parking, laundry or fees, that shows up consistently in the operating history.

The result is effective gross income (EGI).

Next come expenses. Begin with historical operating costs: taxes, insurance, utilities, repairs and maintenance, payroll and administrative costs. Then normalize them. If the borrower self-manages or charges a below-market fee, replace it with a market fee. Fannie Mae’s small loan underwriting table sets the management fee at the greatest of 3% of EGI and the market or actual fee, and deducts a replacement reserve per unit to reach underwritten net cash flow.

The formula is: NOI = EGI − operating expenses. Leave out debt service, depreciation, income taxes and capital expenditures. For a closer look at the T-12 lines that feed this formula, see our guide to reading and normalizing a T-12.

Worked Example and Pitfalls

Multifamily NOI example

Take a 40-unit multifamily property where the borrower reports $453,000 of NOI.

Line item	Amount
Gross potential rent	$720,000
Less vacancy (5%)	($36,000)
Plus other income	$24,000
Effective gross income	$708,000
Historical operating expenses	($255,000)
Market management fee (3% of EGI)	($21,240)
Underwritten NOI	$431,760
Replacement reserves ($250/unit)	($10,000)
Underwritten net cash flow	$421,760
Annual debt service	$300,000
DSCR on underwritten net cash flow	1.41x

The lender’s underwritten net cash flow is $31,240 lower than the borrower’s $453,000 NOI: $21,240 comes from the market management fee and $10,000 from replacement reserves. On the borrower’s number, DSCR would be 1.51x. Apply a 1.25x minimum and the underwritten cash flow supports $337,408 of annual debt service, against $362,400 on the borrower’s figure. That $24,992 annual gap translates directly into lower loan proceeds.

Common NOI errors

• Annualizing partial-year data. Multiplying three months by four overstates income at seasonal or recently leased-up properties.
• Using stale rent rolls. The rent roll should be dated close to the T-12 period end.
• Ignoring concessions and expiring leases. Free rent and near-term rollover cut the income you can count on.
• Accepting below-market management fees. Normalize to market even when the borrower manages the property.
• Not reconciling vacancy and collections. Compare rent roll occupancy with collected revenue before you trust either.

Tools that automate NOI underwriting

US lenders usually automate this work with three kinds of tools: loan origination systems with document intake, automated financial spreading software that normalizes T-12s and rent rolls, and AI-driven CRE underwriting platforms that carry adjustments through to cash flow analysis and the credit memo. Judge any of them on extraction accuracy on messy rent rolls, audit trails that link every adjusted figure to its source, exception handling, and how cleanly the output feeds your model.

Building Defensible NOI

NOI drives both valuation and loan sizing. When every analyst applies the same documented normalization rules, loan sizes hold up in credit committee and in exams. The hard part is consistency at volume. AutoUW automates rent roll and T-12 spreading with each adjustment traced to its source, and Bellwether Enterprise cut the time its team spent on financial spreads by up to 50% after adopting it. Book a demo to see it on your own files.

Frequently Asked Questions

Does NOI include debt service or capital expenditures?

No. NOI excludes debt service, depreciation, income taxes and capital expenditures. Lenders deduct replacement reserves when they size the loan, which is one reason a lender’s cash flow figure is lower than the borrower’s NOI.

What tools automate commercial loan underwriting for US lenders?

Commercial loan origination systems, automated spreading software and AI-driven CRE underwriting platforms each cover part of the workflow: intake, data extraction, cash flow analysis and credit memo inputs. Clik.ai covers extraction through the lender-ready model.

What is the best way to digitize rent roll data?

Use AI extraction mapped to a standard schema, then reconcile totals against the T-12 and the leases before you start underwriting. Our rent roll processing service does both steps.