DSCR and Debt Yield Tests with Lender-Specific Adjustments: The Full Catalogue

A lender-specific DSCR or debt yield test is the version of the ratio defined in a particular loan agreement: net operating income adjusted for that lender’s rules on tenants, vacancy, management fees and reserves, divided by debt service (or loan balance) computed under that lender’s conventions, on that lender’s measurement period. The textbook ratio is NOI over debt service. The ratio your lender calculates is NOI as they define it over debt service as they define it, and the two can differ by enough to turn a comfortable cushion into a breach.

Why the adjustments exist

Lenders adjust for two reasons. They want NOI that will persist (so they strip out tenants who are leaving and income that is temporary), and they want debt service that reflects the loan’s risk rather than its current terms (so they test against a hypothetical amortizing payment at a stressed rate even during interest-only periods). Each adjustment is defensible. The problem is the accumulation across a portfolio: thirty loans, thirty rule sets.

Revenue adjustments

• Tenant exclusions. Exclude tenants with notice to vacate, in default, in bankruptcy or with leases expiring within a window (commonly six months). Some lenders exclude tenants below a minimum credit standard.
• Tenant inclusions. Include executed leases commencing within a window (commonly three months), sometimes only if the tenant has taken occupancy.
• Free rent. Exclude periods of abated rent; some lenders annualize the contractual rent once abatement ends.
• Scheduled increases. Include contractual rent increases within the next twelve months.
• Vacancy. Apply a vacancy factor at the greater of actual vacancy or a floor (often 5% to 10%), even if the property is full.
• Other income. Cap or exclude parking, laundry, fees and other non-rental income above a percentage of revenue.
• Rent roll date. Test on the rent roll as of a specified date, which may not be the financial statement date.

Expense adjustments

• Management fee floor. The greater of actual fees paid or a percentage of effective gross income (3% to 5% is typical), regardless of whether the owner self-manages.
• Capital reserve. A fixed amount per unit or per square foot deducted from NOI whether or not spent.
• Real estate taxes. Reassessed taxes, or taxes as if fully assessed after a sale, rather than the current bill.
• Insurance. Annualized premiums under the current policy rather than the trailing expense.
• Non-recurring items. Add back or exclude one-time expenses per the lender’s definition.
• Owner expenses. Exclude entity-level expenses, or include them, depending on the document.

Debt service adjustments

• Actual versus hypothetical. During interest-only periods, or always, compute debt service as if the loan amortized over a stated schedule (often 25 or 30 years).
• Stressed rate. Use the greater of the note rate, a fixed floor, or an index plus spread (10-year Treasury plus 250 basis points is a common form).
• Three-prong test. The greater of actual debt service, hypothetical amortization at the stressed rate, and the fixed rate in place. All three computed, largest used.
• Floating loans. Test at the current all-in rate, the cap strike plus spread, or a forward curve, per the document.
• Combined debt. Include mezzanine, preferred equity or supplemental debt service in the denominator for combined tests.

Measurement period

Current month annualized, trailing three annualized, trailing six, trailing twelve, or a comparison across several with the lowest used. See T-3 vs T-12 NOI.

Debt yield adjustments

Debt yield divides adjusted NOI by the loan balance, so it inherits every revenue and expense adjustment above and drops the debt service ones. Lenders vary in whether the balance is outstanding principal, the full commitment, or combined debt. See DSCR vs. debt yield and debt yield.

A worked example: every adjustment, one loan

A 150-unit property. Trailing twelve months: gross potential rent $3,300,000, actual vacancy 4% ($132,000), other income $140,000, operating expenses $1,240,000 including management fees of $79,000 (2.5% of collections) and no capital reserve. The loan: $26 million at 5.90% fixed, interest-only for two more years, 30-year amortization thereafter. The lender’s covenant: 1.25x.

Revenue. Start at $3,300,000. Exclude one tenant on notice ($38,000). Include a lease executed last month commencing in 60 days ($22,000). Vacancy at the greater of actual (4%) or 5%: deduct $164,000. Other income capped at 3% of effective gross income: $140,000 is above the cap; allow $97,000. Adjusted revenue: $3,217,000.

Expenses. Start at $1,240,000. Management fees at the greater of actual ($79,000) or 3% of adjusted revenue ($96,500): add $17,500. Capital reserve at $300 per unit: add $45,000. Adjusted expenses: $1,302,500.

Adjusted NOI. $1,914,500, against a textbook NOI of $2,068,000.

Debt service. Actual, interest-only: $1,534,000. Hypothetical, 30-year amortization at the greater of 5.90% and the 10-year Treasury plus 250 (4.77% plus 2.50% = 7.27%): $2,128,000. The test uses the greater: $2,128,000.

Lender DSCR. 0.90x. Textbook DSCR: 1.35x. The covenant is 1.25x. The owner’s spreadsheet says the loan is comfortably in compliance, and the lender’s annual test will say it is in default by a wide margin. There are eight months to the test date.

Illustrative example: the same loan on both definitions

The arithmetic is simple. The abstraction of the rules, the delivery of the inputs on the right dates, and the discipline of running it monthly are the work.

Where the tests appear

• Covenant tests with a threshold and a breach consequence. See balance sheet and bank loans.
• Cash management triggers that spring a sweep. See cash management triggers and cash sweeps.
• Extension tests on bridge loans. See bridge and debt fund loans.
• Supplemental eligibility on agency loans. See supplemental loans.
• Partial release tests after a property leaves a pool. See partial release provisions.
• Recourse burndown milestones. See recourse and guaranty burndown.
• IO expiry planning, where the hypothetical test becomes the actual test. See interest-only expiry planning.

What automating the test requires

1. The adjustments abstracted as structured fields per loan, not as a paragraph in a memo.
2. Live inputs: rent roll with lease dates, operating statement by line, balance and rate, from the accounting system on the test date. See Yardi, MRI and RealPage integrations.
3. A per-loan calculation that applies each rule in the document’s order and shows its work, so the result reconciles to the lender’s spreadsheet line by line.
4. Continuous testing, so the ratio’s trajectory is visible between test dates.

How this looks in LoanBoss

The lender compliance tool applies each loan’s adjustments to integrated financials: vacancy comparisons, rent roll adjustments for lease inception and termination, inclusion of scheduled increases, exclusion of free rent, management fee comparisons, per-unit or per-square-foot reserves, actual versus hypothetical amortization, greater-of comparisons across fixed, floating and Treasury-plus-spread rates, and current, T-3 and T-12 comparisons. One click produces DSCR and debt yield for every lender adjustment across the portfolio. A sample of the test is available on loanboss.com. A customer’s co-founder described it as transforming covenant reporting from hours of spreadsheet work to results delivered instantly with the flexibility to match every lender’s adjustment.

Frequently Asked Questions

Related reading

• Covenant compliance software compared
• Loan critical date tracking
• Escrows, reserves and repair schedules
• Lender consent requirements
• DSCR and covenant in the glossary

A customer once told us this test would be impossible to build. They were among the first to sign up once we had.