Can I Afford This Property?Commercial real estate financing, worked out

Testing NOI sensitivity while holding the requested loan constant

A practical guide for sponsors to build an NOI sensitivity workpaper that isolates the effect of income and expense changes on debt service coverage, using the same loan amount throughout.

Source: CodexTopic: Debt service and coverage898 wordsUpdated 2026-11-19

A practical guide for sponsors to build an NOI sensitivity workpaper that isolates the effect of income and expense changes on debt service coverage, using the same loan amount throughout.

This guide explains how to prepare an NOI sensitivity workpaper that tests what happens to debt service coverage when net operating income changes, while keeping the requested loan amount fixed. The goal is to show a lender that the property can absorb reasonable shocks to income or expenses without breaking the loan's primary repayment source.

What the workpaper shows

The workpaper is a simple spreadsheet that calculates debt service coverage ratio (DSCR) under three or four NOI scenarios, all using the same proposed loan amount. The base case uses your underwritten NOI. The stress cases reduce NOI by a set percentage or by specific line items (e.g., vacancy rises, a major tenant leaves, expenses increase). The loan payment stays constant, so the ratio changes only because NOI changes. This isolates the property's cash flow risk from the loan size question. [1]

How lenders use this analysis

Bank supervisory guidance expects the lender to assess the adequacy of cash flow to meet debt service requirements, commenting on trends in NOI, vacancy, and expenses. A lender reviews current rent rolls and leases to evaluate the primary source of repayment. By presenting an NOI sensitivity workpaper, you give the lender a structured way to see how the property performs under stress, which directly addresses that underwriting concern. This is not a mandatory format, but it organizes information in the way an underwriter typically examines. [1]

Building the NOI sensitivity workpaper

Create a spreadsheet with the following columns:

One suggested way to prepare this information is to use a single spreadsheet with the loan amount locked in a cell referenced by all scenarios, so changing the loan does not accidentally alter the stress tests.

Distinguishing the rent roll from the T-12

The current rent roll is a snapshot of in-place leases as of today. It shows who is paying, what they pay, and when the lease expires. The trailing twelve months (T-12) is a historical summary of actual income and expenses over the past year. The two may not match because the T-12 includes months with different occupancy, rent concessions, or one-time expenses. When building the workpaper, use the T-12 as the historical baseline for vacancy and expenses, then adjust forward using the rent roll for known lease changes. Explain the timing difference between the snapshot and the historical period so the lender understands why the numbers differ. [1]

Identifying the reporting basis

Financial statements for the property may be prepared on an accrual or cash basis. The workpaper should note which basis is used and reconcile any differences between the two. For example, accrued but uncollected rent appears as income on an accrual statement but not as cash received. The lender will want to see collected income, not just billed amounts. Distinguish gross rent, collected income, NOI, capital expenditures, debt service, and equity cash flow in the workpaper. This helps the lender understand where cash actually flows. [1]

How the workpaper affects the financing discussion

Presenting this workpaper shows the lender that you have thought about cash flow risk and have quantified it. It can lead to a discussion about loan structure: if coverage is thin under stress, the lender may ask for a lower loan amount, a longer amortization, or a reserve requirement. It can also support a request for a higher loan amount if coverage remains strong under stress. The workpaper is evidence of underwriting diligence, which is a factor in loan approval. [1]

What the workpaper does not do

  • It does not guarantee loan approval or any specific terms. Lenders make their own underwriting decisions.
  • It does not replace a full appraisal or environmental report. Those are separate requirements.
  • It does not address the borrower's or guarantor's ability to service debt from other sources. The workpaper focuses solely on property cash flow. [1]

Evidence checklist

Before submitting the workpaper, verify the following:

  • [ ] The rent roll snapshot date is noted and matches the T-12 start date.
  • [ ] The T-12 covers twelve consecutive months and is labeled with the period.
  • [ ] Vacancy and expense assumptions are based on historical data or market reports, not guesses.
  • [ ] The loan amount is the same in every scenario.
  • [ ] The debt service calculation uses the proposed interest rate and amortization.
  • [ ] The reporting basis (accrual or cash) is identified and reconciled.
  • [ ] Gross rent, collected income, NOI, capex, debt service, and equity cash flow are each shown separately.
  • [ ] The workpaper is in a format that can be shared with the lender, such as a PDF or Excel file.

Should I include the lender's proposed interest rate in the workpaper?

Yes, use the interest rate you are requesting or the rate you expect based on current market quotes. If the rate changes during negotiations, update the workpaper. The loan amount stays constant, but the debt service changes with the rate.

Can I use this workpaper for a construction loan?

Yes, but the analysis differs because construction loans are funded in draws and the property may not yet be income-producing. For construction, use a pro forma stabilized NOI and test sensitivity on lease-up assumptions and operating expenses after completion.


*Send us the property, the business plan, and the capital you need. We will tell you how we would approach it.

Run the numbers on your deal

Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.

Open the loan sizing calculator

Talk through your financing

Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.

Contact us

Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).

Sources

  1. OCC Commercial Real Estate Lending handbook
  2. Wraith commercial real estate debt