T-12 Underwriting Calculator: Your NOI vs the Lender's

Short answer

Lenders rarely use the NOI on your T-12. They apply their own vacancy, a minimum management fee, replacement reserves and higher taxes and insurance, so underwritten NOI is usually lower. This calculator takes your T-12 lines, applies those adjustments, and shows the difference and how much smaller the loan gets at the lender's minimum DSCR.

What this calculator answers

You send a lender a T-12 showing a certain NOI. The term sheet comes back sized on a lower one. That gap is not a mistake: it is underwriting, and it follows a predictable set of adjustments.

This tool rebuilds your NOI from your T-12, then applies the adjustments a lender makes, line by line. You see the owner's NOI, the lender's NOI, the difference, and what that difference does to the maximum loan at the lender's minimum debt service coverage ratio. It is built for owners of 5+ unit buildings before they request quotes.

Your NOI vs. the lender's NOI

Income

UnitsGross potential rent ($/yr)Vacancy and credit loss (%)Other income ($/yr)

Expenses ($/yr)

Property taxesInsuranceUtilitiesRepairs and maintenancePayrollManagement fee (% of EGI)General and administrativeContract servicesMarketing

The lender's assumptions (edit to your lender's)

Lender's vacancy floor (%)Lender's management fee floor (%)Replacement reserves ($/unit/yr)Tax trend (%)Insurance trend (%)

Loan sizing

Loan rate (%)Amortization (years)Min DSCR (x)

Your NOI–

Lender's NOI–

Difference–

Loan on lender's NOI–

Loan lost to the gap–

Estimates only, not a loan quote.

How to use it

Use the trailing-twelve-month operating statement from your property manager or bookkeeper. Each input maps to a line on it.

Units. Total units in the building, from your rent roll.
Gross potential rent. What every unit would earn in a year at its scheduled rent if 100 percent occupied. Your T-12 may show it as GPR or scheduled rent.
Vacancy. Your actual vacancy and credit loss over the period as a percent of GPR. If your T-12 shows vacancy, concessions and bad debt separately, add them together.
Other income. Laundry, parking, pet fees, utility reimbursements, late fees. Only include income that recurs.
Expense lines. Real estate taxes, insurance, utilities, repairs and maintenance, payroll, management, general and administrative, contract services and marketing, straight from the T-12. Leave out debt service, depreciation and capital improvements.
Management fee. What you pay, as a percent of effective gross income. If you self-manage and pay nothing, enter zero and watch what the lender's floor does.
Lender adjustments. The vacancy floor, management fee floor, replacement reserve per unit, and the percent increase the lender applies to taxes and insurance. If you have a term sheet, use its assumptions. If not, start with the example and test a range.

Worked example

Say you own a 40-unit building with $960,000 of gross potential rent, 3% vacancy and $30,000 of other income. Expenses are taxes $110,000, insurance $48,000, utilities $52,000, repairs $40,000, payroll $60,000, management at 2.5% of effective gross income, G&A $15,000, contract services $18,000 and marketing $6,000. The lender underwrites with a 5% vacancy floor, a 3% management fee floor, $300 per unit of replacement reserves, and insurance trended up 10%.

	Your T-12	Lender's view
Vacancy and credit loss	3.0%	5.0%
Effective gross income	$961,200	$942,000
Management fee	$24,030	$28,260
Replacement reserves	$0	$12,000
Total expenses	$373,030	$394,060
Net operating income	$588,170	$547,940
Loan at 1.25x DSCR	$6,368,400	$5,932,810

Each lender adjustment takes a slice out of NOI, and they stack. In this scenario none of them is dramatic on its own, but together they move NOI enough to change the loan the property supports. The last row shows that cost in loan dollars, which is the number that matters when you compare a refinance to your current payoff.

The adjustments, and why lender NOI is usually lower

Your T-12 shows what happened. The lender underwrites what it expects to happen over the life of the loan, with a cushion. Each adjustment below closes a gap between those two views.

Vacancy floor

If your actual vacancy is below the lender's minimum, the lender uses its minimum. A strong year can reflect luck as much as management, and the loan has to survive an average year. The floor varies by lender, program and market.

Management fee floor

Self-managing owners often show little or no management expense. A lender has to assume that, if it ever takes the building back, it will pay a third-party manager. So it charges a market-rate fee whether you pay one or not. This is often the single biggest adjustment for small owner-operators.

Replacement reserves

Roofs, boilers and parking lots wear out. Lenders deduct an annual amount per unit for future capital needs, even if your T-12 shows nothing, because capital spending sits below NOI on your books. The amount is usually set by the lender, sometimes informed by the property condition report.

If a sale or reappraisal will raise your tax bill, the lender underwrites the new bill, not the old one. On an acquisition, this can be the largest single change. Our tax reassessment calculator estimates it.

Lenders use the current quote or renewal, not last year's expense, and many add a percentage when premiums are rising. If your renewal is due before closing, the lender may ask for the new quote.

Income the lender will not count

One-time income, such as a legal settlement or a large lease-break fee, is usually removed. Other income the lender cannot trace to deposits may be cut as well.

What this tool assumes

Your T-12 is clean. It assumes expenses are recorded in the right period and capital items are not mixed into repairs. Lenders reclassify both, in either direction.
The adjustments you enter. Vacancy floors, management floors and reserve amounts are the lender's assumptions, and they vary by lender, program, market and property condition. Use real term sheet numbers when you have them.
Trailing, not annualized. Some lenders annualize the last three months of income when it is rising, or use the lower of T-12 and T-3. The tool uses the full year.
One coverage test. Loan size is shown at your minimum DSCR only. Real sizing also checks loan-to-value and sometimes debt yield; the lowest result wins.

What to do next

If the gap is small, your T-12 will hold up. Move on to sizing with the DSCR sensitivity calculator and requesting quotes.

If the gap is large, find the line driving it. A missing management fee or no reserves is expected, and every lender will make the same cut. A large tax or insurance trend is worth confirming with a real quote or an assessor estimate before you accept it. Recorded expenses that are really capital improvements are worth reclassifying with your bookkeeper, with invoices to back it up.

If the lender's NOI no longer supports the loan you need, read what to do when a refinance won't size. Use "get quotes on these numbers" to send this scenario to desk@janover.co.

Take it offline

Prefer a spreadsheet you can save, send or change? The same math, with formulas you can see.

Excel

T-12 to lender underwriting

Your operating statement next to the lender's view: vacancy floor, management fee floor, reserves and tax and insurance trending, with the loan each NOI supports.

Download Excel

Frequently asked questions

Why is the lender's NOI lower than the NOI on my T-12?

Lenders underwrite expected performance over the loan term, not last year's results. They apply a minimum vacancy rate, charge a market management fee even if you self-manage, deduct annual replacement reserves, use current tax and insurance figures, and remove one-time income. Each adjustment is small, but together they usually produce an underwritten NOI below the owner's figure.

Do lenders charge a management fee if I manage the building myself?

Generally yes. A lender has to assume that if the loan defaults it will hire a professional manager, so it underwrites a market-rate management fee regardless of what you pay. The fee it uses is the lender's assumption and varies by lender, property size and market. Self-managing owners should expect this adjustment on nearly every term sheet.

What are replacement reserves in underwriting?

Replacement reserves are an annual per-unit deduction for future capital needs such as roofs, mechanical systems and paving. They lower underwritten NOI even if your books show no such cost, because capital spending is not in your operating expenses. Many lenders also collect reserves monthly into an escrow account. The per-unit amount is set by the lender and often informed by the property condition report.

Can I argue with a lender's underwriting adjustments?

Sometimes. Adjustments that are policy, like a management fee floor or minimum vacancy, rarely move. Adjustments based on estimates, like tax and insurance trending or reclassified expenses, can change if you provide evidence: a binding insurance quote, an assessor's notice, or invoices showing an expense was a one-time capital item. Comparing lenders also helps, since assumptions differ from one to the next.

Does underwritten NOI change how much I can borrow?

Yes. Lenders size most apartment loans on the lower of a loan-to-value limit and a debt service coverage limit. The coverage limit divides underwritten NOI by the minimum DSCR to get the most annual debt service the loan can carry. A lower NOI means less debt service allowed, which means a smaller loan at the same rate and amortization.