Debt yield is a property's net operating income divided by the loan amount, written as a percentage. In Excel it is a single division: =B1/B2, where B1 is annual NOI and B2 is the loan balance, formatted as a percent. If a property produces $500,000 of NOI against a $5,000,000 loan, the debt yield is 10.0 percent. That one number tells a lender how quickly it would recover its money if it had to foreclose, and unlike most loan metrics it cannot be dressed up by stretching the amortization or riding a low interest rate.
Here is how to build it, what counts as a healthy figure, and why underwriters lean on debt yield when the deal looks fine on every other ratio.
What is debt yield in commercial real estate?
Debt yield is the ratio of a property's net operating income to the loan amount, and it measures the lender's return if it took the property back at that loan balance. A 10 percent debt yield means the income alone would return 10 percent of the loan each year, so the lender would recoup its principal in about ten years from operations, before any sale. Because it ignores the interest rate, the amortization schedule, the loan term, and the appraised value, debt yield strips out the levers a borrower or a low rate environment can use to make a shaky loan look safe. That is exactly why lenders adopted it widely after the 2008 downturn.
How do you calculate debt yield in Excel?
Put NOI and the loan amount in their own labeled cells and divide. Keeping the two inputs separate makes the sheet easy to audit and lets you flex the loan amount to test scenarios.
| Cell | Label | Value |
|---|---|---|
| B1 | Net operating income (annual) | $500,000 |
| B2 | Loan amount | $5,000,000 |
| B3 | Debt yield =B1/B2 | 10.0% |
Format B3 as a percentage with one decimal. Use a clean, stabilized NOI in B1, meaning trailing twelve month income with realistic vacancy and a full expense load, not a broker's pro forma. The whole calculation is that one line; the accuracy lives entirely in getting NOI right.
What is a good debt yield?
As a general guideline, most lenders look for a minimum debt yield around 10 percent, and the common range runs from about 8 to 12 percent. The Office of the Comptroller of the Currency's commercial real estate lending guidance points lenders toward a 10 percent floor, and many follow it. Lenders may accept 8 percent for a Class A asset in a major, liquid market, and they will want more than 10 percent for a riskier property or a secondary market. Treat these as underwriting conventions, not fixed rules, because the acceptable floor moves with the asset type, the market, and the lender's own risk appetite. A higher debt yield always means a safer loan for the lender.
How is debt yield different from DSCR?
Both measure loan safety from income, but they answer different questions. The debt service coverage ratio compares NOI to the annual loan payment, so it depends on the interest rate and the amortization period. Lengthen the amortization or catch a lower rate and the payment falls, which lifts the DSCR even though the property has not changed. Debt yield uses the loan amount instead of the payment, so none of those financing terms touch it. A deal can show a comfortable DSCR and a thin debt yield at the same time, which is the warning sign lenders built the metric to catch.
How is debt yield different from LTV?
Loan to value divides the loan by the property's appraised value, and appraised value rises and falls with market cap rates. When cap rates compress, values inflate, and a loan can look conservative on LTV while the income barely supports it. Debt yield ignores value entirely and anchors to actual income, so a market wide repricing does not flatter it. Underwriters often run all three, LTV, DSCR, and debt yield, and let the most conservative one govern the maximum loan.
| Metric | Formula | Sensitive to |
|---|---|---|
| Debt yield | NOI / loan amount | Income only |
| DSCR | NOI / annual debt service | Interest rate and amortization |
| LTV | Loan amount / appraised value | Market values and cap rates |
How do lenders use debt yield to size a loan?
A lender flips the formula to find the largest loan a property can support at its minimum debt yield. Rearranged, loan amount equals NOI divided by the target debt yield, so in Excel that is =B1/0.10 for a 10 percent floor. With $500,000 of NOI, a 10 percent minimum caps the loan at $5,000,000; raise the floor to 12 percent and the maximum loan drops to about $4,166,667. Build a small grid that varies the target from 8 to 12 percent and you can see instantly how the loan proceeds shrink as the lender demands a safer position. This is often the binding constraint on how much a borrower can actually raise.
Where do the numbers come from?
The NOI that drives debt yield sits on the property's operating statement or trailing twelve month report, which usually lands in your inbox as a PDF from a broker or property manager. Retyping every rent and expense line to rebuild NOI is slow and one wrong figure moves the ratio, so it is worth converting the operating statement PDF to Excel and letting each line drop into its own cell. The same underwriting sheet feeds your NOI from a T12, DSCR, and cap rate calculations, so getting the statement into spreadsheet form once pays off across the whole model. When the income detail is buried in the rent schedule, teams often pull the terms straight from the leases that generate that income before the numbers reach the underwriting model.
The bottom line
Debt yield is the one loan metric a borrower cannot engineer, which is why lenders trust it. Calculate it as NOI over the loan amount, hold NOI to a conservative, stabilized figure, and read anything under roughly 10 percent as a flag to check the rest of the file. Pair it with DSCR and LTV, let the strictest one set the loan, and you will size deals the way an underwriter actually does.