Debt yield calculator for CRE underwriting

A debt yield calculator divides net operating income by loan amount and expresses the result as a percent. The OCC CRE handbook lists debt yield among the underwriting metrics for income-producing CRE loans, alongside LTV and DSCR, defined as NOI over loan amount. Because the formula uses only those two inputs, the result does not move with the interest rate, the amortisation period or the capitalisation rate used to value the property. Lower debt yields indicate higher leverage on the same NOI.

Debt yield calculator formula

Debt yield = NOI / loan amount × 100

Desks typically take operating income net of operating expenses other than debt service and depreciation, with operating expenses commonly including real-estate taxes, insurance, common-area maintenance, utilities, replacement reserves, management fees and administrative costs. The OCC handbook treats NOI as the property income input for this and related coverage tests and carries its own formal NOI definition for that purpose.

Debt yield is used alongside DSCR and LTV precisely because low interest rates or compressed capitalisation rates can otherwise support large loan amounts on those two tests alone. Debt yield, built only from NOI and loan amount, does not move with either input.

Federal Reserve Bank of New York staff research using supervisory CRE data defines debt yield as NOI divided by loan balance and links it mechanically to capitalisation: substituting the perpetuity valuation formula into LTV yields debt yield equal to cap rate divided by LTV. On that identity, debt yield below the prevailing cap rate implies LTV above 100 percent on an income-capitalisation basis, an underwater position. The same research treats low debt yield as a loan-level distress indicator: a borrower is in distress when NOI falls below debt service obligations, equivalent to debt yield falling below the loan's interest rate, and the paper reports that debt yields below an 8 percent threshold predicted future defaults in its pre-pandemic data.

Inputs

• NOI: stabilised, trailing or underwritten net operating income under the credit policy
• Loan amount: commitment at origination, or outstanding balance for a current debt yield restatement
• NOI adjustments: vacancy, credit loss, management fee and reserve normalisations
• Scope: whole loan, senior only or combined debt stack
• Case: in place, underwritten stabilised or stressed NOI

Worked numerical example

Illustrative permanent CRE loan:

• Underwritten NOI: 9.0 million
• Senior loan amount: 100.0 million

Debt yield = 9.0 / 100.0 × 100 = 9.0%

If the desk stresses NOI to 8.1 million (10 percent haircut), stressed debt yield = 8.1%. If loan size rises to 112.5 million on the original 9.0 million NOI, debt yield falls to 8.0%. The metric moves only with NOI and loan amount; coupon and amortisation elections do not enter the formula.

Using the New York Fed identity for illustration, if the prevailing cap rate is 6.0% and LTV is 75%, implied debt yield = 6.0% / 0.75 = 8.0%. A sized loan with debt yield below the cap rate used in valuation is inconsistent with that income-capitalisation LTV frame.

Interpretation limits

Debt yield ignores the coupon. A facility can show a strong debt yield and still fail interest coverage ratio or DSCR if rate resets or amortisation begins. Debt yield also ignores appraisal value, which distinguishes it from LTV when valuations are contested, but does not replace collateral analysis.

NOI definition errors are the most common source of miscalculation. Mixing gross rent with net operating income, omitting replacement reserves from operating expenses, or capitalising tenant improvements inconsistently across deals breaks comparability. Using aspirational stabilised NOI for a transitional asset overstates debt yield relative to in-place cash. Whole loan versus senior only denominators also change the percent without any change in property operations.

Minimum debt yield appears among common financial covenants for income-producing CRE, though the metric does not carry a universal floor; property type, lease structure and rate environment drive desk hurdles.