Debt Yield Calculator
Updated September 20, 20263 min read

Office & Retail Debt Yield Floors: Underwriting Risk in Volatile Sectors

Analyze office and retail lease rollover, cash requirements and quoted debt-yield targets using transparent scenarios instead of universal market floors.

Quick answer

For office and retail, examine tenant concentration, lease rollover and re-leasing cash needs before interpreting debt yield. A quoted target is specific to the financing; an 11% or 12% ratio does not guarantee coverage after a tenant leaves or establish that capital work is funded.

Separate recurring income from re-leasing costs

A rent roll can concentrate income in a few leases. Record each tenant's share of rent, expiry, contractual options and any relevant provisions. Avoid assuming that a particular asset label or anchor tenant removes the risk.

InputEvidenceModeling treatment
Rent at riskLease schedule and collectionsExplicit income scenario
DowntimeSupported leasing assumptionMonths of reduced collections
Tenant improvementsScoped budget or quoteSeparate cash requirement
Leasing commissionsAgreement or estimateSeparate cash requirement
Recurring expensesOperating history and contractsOperating NOI calculation
Lender reserve allowanceApplicable quote or programSeparate, labeled income adjustment

Do not use a generic cost per square foot as a substitute for an actual scope. Also distinguish capital expenditure from the replacement reserve deduction used in a particular underwriting calculation.

Test a loss of income

Assume hypothetical annual income of $1.2 million and a $10 million loan. The debt yield is 12%. If accepted income falls to $800,000 after a lease loss, the ratio becomes 8%.

If annual debt service is $900,000, coverage falls from 1.33x to 0.89x. This illustrates why the initial 12% ratio does not ensure the remaining income will cover payments. Use actual payment terms in the DSCR calculator.

Separate target changes from income changes

With $1.2 million of accepted income, a hypothetical 10% target supports $12 million under the DY test. A 12% target supports $10 million. Those are sensitivities, not stated office or retail market requirements.

If the lender also reduces accepted income, show that change separately. The property comparison and income reconciliation guide help avoid mixing a more conservative numerator with a higher target without explaining either.

Include an exit scenario

Evaluate future income, payoff balance, refinancing costs and all takeout sizing tests. The OCC refinance-risk bulletin identifies stress testing as a way to examine whether a borrower could refinance under changed financial and market conditions. It does not prescribe the illustrative targets above.

Use the loan-sizing workbook for income and financing sensitivities. Keep tenant-improvement and leasing budgets in the sources-and-uses analysis as well; a satisfactory debt yield does not fund them automatically.

Frequently asked questions

What is the current office or retail debt-yield floor? This guide does not publish a surveyed market floor. Obtain a current quote identifying the income definition, target and balance tested.

Does higher debt yield mean the lender can ignore rollover? No. The ratio captures one income scenario. Recalculate under documented rollover assumptions and examine the cash needed to restore occupancy.

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 →