Debt Yield Calculator
Updated July 15, 20265 min read

Underwritten NOI vs. Actual NOI in Commercial Real Estate

Understand how lenders adjust your property's actual cash flow to determine 'Underwritten NOI' and size your commercial mortgage.

Quick answer

Actual NOI is the property’s true historical net income over a set period (usually the trailing 12 months). Underwritten NOI is the risk-adjusted cash flow calculated by a lender to size a loan. Lenders subtract vacancy floors, management fees, and replacement reserves, which typically makes Underwritten NOI 5% to 15% lower than Actual NOI.

When preparing a commercial real estate deal for financing, the first number most sponsors calculate is Net Operating Income (NOI). You pull the profit and loss (P&L) statements, summarize your revenues, subtract your operating expenses, and arrive at your historical Actual NOI.

But when the lender’s term sheet arrives, you notice the loan is sized against a smaller figure: the Underwritten NOI.

Lenders do not size mortgages on historical performance alone. Instead, they apply a credit-risk filter, stripping out volatile revenues and adding standard expense assumptions. Understanding the differences between these two numbers is critical to predicting your final loan proceeds.


Why Lenders Adjust Actual NOI

A property owner’s incentive is to make NOI look as large as possible to maximize valuation. A lender’s incentive is to find the sustainable baseline cash flow that will persist even during economic stress.

To do this, underwriters "haircut" the income and inflate the expenses. This adjusted figure forms the numerator for both the Debt Service Coverage Ratio (DSCR) and the Debt Yield calculations.

Actual NOI (Owner's Book)  ──►  [ Underwriter's Credit Filter ]  ──►  Underwritten NOI (Lender's Book)

Key Adjustments: How Lenders Haircut Your Books

Lenders modify a property’s financials across several key categories:

1. Vacancy and Collection Loss Floors

Even if your property has been 100% occupied for three years, a lender will rarely model a 0.0% vacancy rate.

  • The adjustment: Lenders apply a minimum vacancy and credit loss floor (typically 5.0% for multifamily and standard commercial assets). If your submarket’s historical vacancy is 8.0%, they will use 8.0% instead.
  • The impact: This immediately reduces underwritten gross revenue, even if every unit is generating rent today.

2. Underwritten Management Fees

If you manage the property yourself, your P&L might show a $0 management expense.

  • The adjustment: Lenders assume that if they have to foreclose, they will hire a professional third-party management company. Therefore, they write in a management fee (usually 3.0% to 5.0% of Gross Revenues) regardless of your actual management structure.
  • The impact: Operating expenses rise, directly reducing underwritten NOI.

3. Replacement Reserves (Capital Expenditures)

Actual NOI calculations usually exclude Capital Expenditures (CapEx), categorizing major repairs as balance sheet items rather than operating expenses.

  • The adjustment: Lenders know structures degrade. They write in a recurring deduction for replacement reserves to fund future roofs, HVAC systems, or parking lot repairs.
    • Multifamily: $250 to $350 per unit per year.
    • Office/Retail: $0.15 to $0.25 per square foot per year.
  • The impact: This deduction is subtracted directly from NOI before the loan is sized.

4. Real Estate Tax Reassessment

If you are purchasing a property, the transaction will trigger a local tax assessment update.

  • The adjustment: Lenders will ignore the seller's historically low tax bill. They calculate taxes based on the new purchase price and local millage rates.
  • The impact: In high-tax jurisdictions, this reassessment can increase operating expenses by tens of thousands of dollars.

The Sizing Math: A Real-World Example

Let's see how these underwriting haircuts shrink loan proceeds.

Consider a 50-unit multifamily building with a Trailing-12-Month P&L showing:

  • Gross Rental Income: $1,000,000 (currently 98% occupied)
  • Other Income (Late fees, laundry): $30,000
  • Actual Operating Expenses: $380,000 (self-managed; no reserves)
  • Actual NOI: $650,000 ($1,030,000 – $380,000)

Now, the lender applies agency underwriting standards:

  1. Vacancy & Credit Loss: Applied at 5.0% of rental income ($50,000 deduction).
  2. Other Income: Haircut by 50% to exclude volatile fees ($15,000 allowed).
  3. Management Fee: Added at 4.0% of gross income ($40,000 expense).
  4. Replacement Reserves: Subtracted at $300/unit/year ($15,000 deduction).
  5. Adjusted Taxes: Increased by $20,000 based on post-sale estimate.

Underwritten Calculation:

  • Underwritten Revenue: $1,000,000 (Rental) - $50,000 (Vacancy) + $15,000 (Other) = $965,000
  • Underwritten Expenses: $380,000 (Base) + $40,000 (Management) + $20,000 (Tax Hike) = $440,000
  • Underwritten NOI (Pre-Reserves): $965,000 - $440,000 = $525,000
  • Underwritten NOI (Post-Reserves): $525,000 - $15,000 = $510,000

Lender’s Underwritten NOI is $510,000 — a $140,000 (21.5%) haircut from the actual books.

Sizing Consequences:

If a CMBS lender requires a 10.0% minimum debt yield:

  • Based on Actual NOI: Supported loan is $650,000 ÷ 0.10 = $6,500,000
  • Based on Underwritten NOI: Supported loan is $510,000 ÷ 0.10 = $5,100,000

The sponsor faces a $1,400,000 equity shortfall at the closing table because they modeled their loan proceeds using Actual NOI instead of Underwritten NOI.

Frequently asked questions

What is underwritten NOI? Underwritten NOI is a property's net operating income after a lender applies its own conservative adjustments — market vacancy floors, a management fee, and replacement reserves — rather than accepting the owner's actual trailing financials. It is almost always lower than actual NOI.

Why is underwritten NOI lower than actual NOI? Lenders add expenses the owner may not book: a standardized vacancy allowance (often 5%–7%), a management fee (typically 3%–5% of income even if self-managed), and per-unit or per-square-foot replacement reserves. They also normalize one-time income spikes.

How does underwritten NOI affect my loan amount? Loan sizing uses underwritten NOI, not actual NOI. Because debt yield and DSCR both divide by NOI, a lower underwritten figure directly shrinks maximum proceeds. Modeling your loan on actual NOI is the most common cause of an equity shortfall at closing.

How do I estimate my underwritten NOI before applying? Start with actual income, apply a 5% vacancy factor, add a 3%–5% management fee, and subtract $250–$300 per unit (or $0.15–$0.25 per square foot) in reserves. Then divide the result by the lender's minimum debt yield to see supported proceeds.

Commercial Real Estate Finance Reviewer

Edwin Toe reviews each calculator and guide against the methodology lenders apply when sizing commercial real estate loans. Formulas, benchmarks, and worked examples are aligned with how debt yield, DSCR, and LTV are used in institutional practice. Outputs are educational estimates, not lending advice.

Ready to run the numbers?

Get your result instantly — private, in your browser.

Open the calculator →