background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Join 750k+ learners today. Learn online from Wall Street Prep — the training firm that prepares new hires at the world's top financial institutions.

Enroll Today

Debt Yield (DY)

  Table of Contents

How to Calculate Debt Yield

The debt yield is frequently utilized by lenders in the commercial real estate market (CRE) as a method to measure credit risk in underwriting.

In short, the debt yield is the ratio between a property’s net operating income (NOI) and total loan amount, expressed as a percentage.

  • Net Operating Income (NOI) → Net operating income, or “NOI” for short, is a fundamental real estate metric used to measure a property’s cash flows and profitability. The NOI of a rental property is calculated by first determining the property’s total income – the sum of its rental and ancillary income – and then subtracting its operating expenses.
  • Loan Amount → The total loan amount refers to the outstanding principal balance associated with real estate financing, such as a mortgage loan.

Conceptually, the debt yield is the estimated return a real estate lender receives relative to the original loan amount provided to the borrower under the hypothetical scenario of default (and foreclosure).

Because non-operating costs such as financing costs and income taxes are not part of the net operating income (NOI) calculation, the metric is considered an unlevered, pre-tax measure of profitability (i.e. “capital structure neutral”). The debt yield is therefore suited for comparability purposes.

The items excluded from the NOI calculation, such as capital reserves, capital expenditures, and tenant improvements, are unrelated to the property’s core operations.

Likewise, the debt service component is also excluded since it falls under the category of financing costs.

The calculation of the debt yield metric is a three-step process:

  1. Calculate Net Operating Income (NOI)
  2. Divide Net Operating Income (NOI) by the Loan Amount
  3. Convert Debt Yield from Decimal to Percentage Form (Multiply by 100)
dl

Real Estate Interview Guide | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Debt Yield Formula

The formula to calculate the debt yield divides the net operating income (NOI) by the total loan amount.

Debt Yield (%) = Net Operating Income (NOI) ÷ Loan Amount

Where:

  • Net Operating Income (NOI) = (Rental Income + Ancillary Income) – Direct Operating Expenses

Ancillary income refers to the non-rental sources of income, such as reimbursements on utilities and fees charged to tenants for amenities access.

On the other hand, direct operating expenses are the costs tied to the operations of the property, such as repair and maintenance costs, marketing, general and administrative expenses, and utilities.

The debt yield formula can also be expressed as the property’s annual NOI divided by the difference between the purchase price and the down payment.

Debt Yield (%) = Net Operating Income (NOI) ÷ (Purchase Price – Down Payment)

Note: While income taxes are excluded in the net operating income (NOI) metric, the property taxes paid by the owner must be included.

The Wharton Online
and Wall Street Prep Real Estate Investing & Analysis Certificate Program

Level up your real estate investing career. Enrollment is open for the Feb. 10 - Apr. 6 Wharton Certificate Program cohort.

Enroll Today

What is a Good Debt Yield?

In practice, real estate lenders that provide commercial and multifamily loans use the debt yield metric to estimate the time required to recoup their initial investment, in the scenario where the property is seized post-default and now belongs to them.

While each lender sets different targets for the debt yield, the standard range among commercial real estate lenders (CMBS) is around 8% to 12%.

The general rules of thumb for interpreting the debt yield are as follows:

  • Lower Debt Yield → If the debt yield is low, the implied risk to the lender is higher, because the property’s operating cash flows could not meet the mandatory debt service.
  • Higher Debt Yield → In contrast, the higher the debt yield, the less risk the financing poses due to the reduced likelihood of the borrower defaulting on the obligation.

But of course, most lenders tend to be risk-averse and prioritize the retrieval of the original principal at maturity. Therefore, measuring the potential downside risk in the event of foreclosure is part of worst-case scenario contingency planning.

Most institutional real estate lenders will set internal targets on the minimum debt yield in their underwriting process, wherein a borrowing unable to meet the minimum target will either be adjusted downward or declined.

Therefore, the more practical use-case of the debt yield metric pertains more toward debt sizing, i.e. quantifying the maximum amount of debt capital to put at risk based on the perceived riskiness of the borrowing.

However, the target yield is lender-specific and conditional on external factors, such as the current conditions of the credit markets, among other considerations.

Debt Yield vs. DSCR vs. LTV Ratio: What is the Difference?

There are two other risk measures of particular importance in real estate lending:

  • Debt Service Coverage Ratio (DCSR)
  • Loan-to-Value Ratio (LTV)

The debt yield is unique, however, because the metric is independent of fluctuating interest rates and real estate market values and is unaffected by the borrowing term, i.e. length of the loan amortization schedule.

Debt Yield Calculator

We’ll now move on to a modeling exercise, which you can access by filling out the form below.

dl

Excel Template | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

1. Commercial Real Estate Loan Assumptions (CRE)

Suppose a real estate lender is performing due diligence on a potential borrower who has requested $8 million in financing to purchase a property.

Once purchased, the property is expected to generate $1 million in effective gross income (EGI) while incurring $600k in total operating expenses.

  • Loan Amount Requested = $8 million
  • Effective Gross Income (EGI) = $1 million
  • Total Operating Expense = $600k

By subtracting the total operating expense from the effective gross income (EGI), the property’s net operating income (NOI) comes out to $400k.

  • Net Operating Income (NOI) = $1 million – $600k = $400k

2. Debt Yield Calculation Example

In the next step, we’ll calculate the debt yield on the proposed financing arrangement using the two inputs from the prior section.

The implied debt yield in our financing scenario is 5.0%, which we determined by dividing the property’s net operating income (NOI) by the requested loan amount from the borrower.

  • Debt Yield (%) = $400k ÷ $8 million = 5.0%

To reiterate from earlier, lenders prefer higher debt yields to limit the downside risk and potential for incurring losses.

Therefore, the 5.0% debt yield will most likely result in the lender declining the requested loan unless the terms of the financing are adjusted, i.e. via a reduction in the size of the loan.

3. Debt Yield Loan Sizing Analysis Example

The final section of our debt yield modeling exercise will consist of loan sizing, where we’ll rearrange the formula from earlier to determine the maximum loan amount the lender should offer to meet its target yield.

Loan Sizing = Net Operating Income (NOI) ÷ Target Debt Yield (%)

The minimum target yield of the lender is assumed to be 8.0% here.

  • Target Debt Yield (%) = 8.0%

In closing, we arrive at $5 million as the maximum loan amount upon dividing the borrower’s net operating income (NOI) by the target debt yield.

  • Loan Sizing = $400k ÷ 8.0% = $5 million

Debt Yield Calculator


The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.