Real Estate Investing

Debt Yield Calculator

Free debt yield calculator for commercial real estate: check NOI against the lender's debt yield floor, size the maximum loan across the debt yield, LTV and DSCR tests, and see which constraint binds the deal.

Did this calculator help you?

What is Debt Yield Calculator?

Debt yield measures how much income a commercial property throws off per dollar borrowed: net operating income divided by the loan balance, expressed as a percentage. A 10,000,000 loan on a building earning 800,000 a year has a debt yield of exactly 8.00%. Lenders reach for this ratio first because it ignores interest rates and amortisation schedules — the two variables that can be restructured in a workout — and looks only at whether the asset itself can carry the debt. A loan can be renegotiated; the income cannot. That is why debt yield sits beside loan-to-value and debt-service coverage as one of the three numbers every commercial credit agreement quotes, and why most lenders attach a floor, commonly between 7.5% and 10%, that the finished loan must clear at closing. The calculator works in three directions: it tests a loan against the floor, it sizes the largest loan the floor allows, and it solves backwards for the NOI a given loan needs.

When to Use This Calculator

  • When a lender quotes a loan amount and you need to test it against their debt yield floor before it goes to committee.
  • When you are sizing a new acquisition and want the maximum proceeds the debt yield test alone would allow.
  • When three ceilings disagree and you need to know which ratio is actually capping the loan.
  • When a sponsor's pro forma claims a comfortable yield and you want the arithmetic on the real loan amount.
  • When NOI is fixed by the appraisal but the loan size is still negotiable.
  • When you are comparing quotes with different floors, LTV caps and DSCR requirements on the same building.

Steps:

  1. Enter the property's annual NOI — gross income minus operating expenses, before debt service and capital reserves.
  2. Set the lender's debt yield floor. Agency multifamily paper typically sits near 7.5%, bank paper around 8% to 9%, and hotel or transitional assets at 10% or above.
  3. Pick a mode. Debt yield tests an existing loan, sizing recommends the largest loan, and required NOI answers the reverse question.
  4. In debt yield mode enter the loan balance and, if you have it, the appraised value to unlock the LTV and cap-rate cross-check.
  5. In sizing mode set the maximum LTV, then open the debt service panel for the note rate, amortisation term and minimum DSCR.
  6. Read the three ceilings side by side. The smallest one is the binding constraint — the amount the lender will actually advance.
  7. Check the implied LTV and implied debt yield on the recommended loan. Clearing one test does not clear the others.
  8. Use the sensitivity grid to watch the ceiling move as NOI swings plus and minus 20% across floors from 7.5% to 11%.

Formula

Debt yield = NOI ÷ Loan × 100 Max loan at floor = NOI ÷ Floor Required NOI = Loan × Floor Debt yield = Cap rate ÷ LTV Annual loan constant = 12 × Monthly payment ÷ Loan DSCR ceiling = (NOI ÷ Minimum DSCR) ÷ Annual loan constant Recommended loan = Min(Debt-yield ceiling, LTV ceiling, DSCR ceiling)

Use Cases

  • A lender quoted 18,000,000 against 1,400,000 of NOI and you need to know in one click whether their 9% floor is cleared.
  • You are sizing an acquisition loan and want the maximum the debt yield test alone allows before fees and reserves.
  • Your bank underwrites three ratios and you need to know which one is actually blocking the closing.
  • A sponsor is shopping a 12,000,000 request and you want the NOI the property must produce to justify it at an 8.5% floor.
  • You are comparing agency, bank and bridge quotes whose floors differ, and want a single ratio to line them up.
  • An investor claims the deal clears 10% — you check the arithmetic on the real loan amount rather than the asking price.

Key Benefits

  • Three underwriting tests in one view — debt yield, LTV and DSCR — with the binding constraint named instead of guessed.
  • The full floor test: maximum loan, headroom in points, and the gap in currency against the balance you actually want.
  • A reverse solve for the question borrowers really ask: how much NOI must this loan generate to be acceptable?
  • Rate and amortisation folded into the DSCR ceiling, so the recommendation reflects the loan you will actually sign.
  • Implied LTV and implied debt yield printed on the recommended loan, because clearing one test never guarantees the others.
  • Sensitivity across plus or minus 20% NOI and a 7.5% to 11% floor sweep, so a rent dip or a tougher lender is already priced in.

Pro Tips

  • Run sizing first, then test the loan you actually want against the floor. The gap tells you exactly how much NOI to negotiate.
  • If debt yield binds, the only levers are more NOI or less debt. If LTV binds, the appraisal is the constraint. If DSCR binds, a longer amortisation or a lower rate buys room.
  • Ask for the floor in writing in the term sheet — minimum debt yield, in percent — rather than asking whether you clear their test.
  • Cross-check the recommendation with the identity: divide the cap rate by the LTV before taking the number to committee.
  • Stress NOI down 10% in the grid. If the ceiling falls below your loan amount, the deal has no cushion for a vacancy.
  • When two quotes carry the same rate, compare their floors. The looser floor is worth real dollars of extra proceeds.

Common Mistakes to Avoid

  • Treating debt yield as a substitute for DSCR. Debt yield ignores debt service, so a 9% yield on a 5% loan behaves nothing like the same yield on a 9% loan.
  • Measuring the floor against the wrong denominator. The floor is NOI divided by loan, not NOI divided by value — the cap-rate cousin that confuses them inflates the ratio by the LTV factor.
  • Assuming the debt yield test always binds. On the retail preset LTV binds, and on a high-rate deal the DSCR ceiling lands first even with a comfortable floor.
  • Using asking-price NOI instead of underwritten NOI. Lenders credit income net of vacancy, management and reserves, not the broker's pro forma.
  • Comparing floors across products without their other terms. An 8% floor at 65% LTV is a different box than an 8% floor at 80% LTV.
  • Forgetting that the floor moves the maximum loan directly. Raising the floor from 7.5% to 9% cuts the debt yield ceiling by 16.7% on the same NOI.

Key Terms Explained

Debt yield:
net operating income divided by the loan balance, times 100 — income coverage of the loan before rate or term is considered.
Debt yield floor:
the minimum ratio a lender will accept on a new loan, typically 7.5% to 10% depending on product and property type.
Binding constraint:
among the debt yield, LTV and DSCR ceilings, the smallest one — the amount the lender will actually advance.
Annual loan constant:
yearly debt service as a percentage of the original balance — the bridge between NOI and the DSCR test.
Implied LTV:
the recommended loan divided by the property value, shown so a debt-yield-clearing loan is not secretly above the leverage cap.
Implied debt yield:
the yield the recommended loan ends up with — equal to the floor when debt yield binds, higher when another test binds.
NOI surplus (shortfall):
actual NOI minus the NOI the floor requires; a negative figure is the income gap still to close.
Cap-rate identity:
debt yield equals cap rate divided by LTV — the same ratio viewed through the property rather than the loan.

Related Concepts

  • Cap Rate Calculator: net operating income against price — the property-side view that divides into debt yield through the identity.
  • DSCR Calculator: the coverage test lenders run beside debt yield, and the ceiling that binds first when rates are high.
  • NOI Calculator: build the net operating income that every ratio on this page reads from, line by line.
  • Cash on Cash Return Calculator: the equity-side yield — what the down payment earns once debt service is paid.
  • Rental Property Cash Flow Calculator: monthly cash flow after debt service, the number the debt yield floor exists to protect.
  • Loan-to-Value Calculator: the leverage test that pairs with debt yield in every commercial credit agreement.

Example

Take the default preset: a building with 800,000 of net operating income and a 10,000,000 loan against a 13,500,000 value, tested at a 7.5% floor. The debt yield is 800,000 ÷ 10,000,000 × 100 = 8.00%, so the loan clears the floor by 0.50 points. The largest balance that floor supports is 800,000 ÷ 7.5% = 10,666,666.67, which leaves the current loan 666,666.67 under the cap, and the NOI the floor requires of this loan is 10,000,000 × 7.5% = 750,000. Now take the office preset into required mode: 1,400,000 of NOI against an 18,000,000 request at a 9% floor gives 7.78%, a shortfall of 1.22 points — the property needs 1,620,000 of NOI and is 220,000 short. Finally size the retail preset: the three ceilings come out at 14,117,647.06 from debt yield, 11,200,000 from a 70% LTV cap on the 16,000,000 value, and 12,656,865.56 from a 1.25 DSCR at 6.5% over 30 years. The smallest wins, so LTV binds: the recommended loan is 11,200,000, sitting at exactly 70.00% LTV with an implied debt yield of 10.71%.

Interpreting Your Results

Read the page in this order. The hero is colour-coded by the test: red when the yield sits under the lender floor, amber below 8% even if your floor is looser, green at 10% or above, and blue in the standard 8% to 10% band. In debt yield mode the four cards under it give the maximum loan at your floor, the headroom in points, the currency gap against your current balance, and the NOI the floor requires. The breakdown then repeats every figure, adding LTV and the cap rate once a property value is entered, and the sensitivity grid shows how the ceiling moves as NOI swings plus or minus 20% across floors from 7.5% to 11%. In sizing mode the three ceilings appear as cards and as a table with the binding test flagged, followed by the implied LTV and implied yield on the recommended loan. The step-by-step panel reproduces the arithmetic line by line, so every number on screen can be re-derived by hand.

Frequently Asked Questions

What is debt yield in commercial real estate?
Debt yield is net operating income divided by the loan amount, multiplied by 100. A property producing 800,000 a year against a 10,000,000 loan has a debt yield of exactly 8.00%. Because it reads only income and balance, it does not change when rates rise or the amortisation schedule is extended — which is precisely why lenders treat it as the ratio that cannot be restructured away in a workout. It is normally quoted alongside LTV and DSCR in a credit agreement, and most lenders attach a floor, commonly between 7.5% and 10%, that the loan must clear at closing and often again at each renewal.
How do you calculate debt yield?
Divide annual net operating income by the loan balance and multiply by 100: debt yield = NOI ÷ Loan × 100. The identity runs in reverse too. Multiply the loan by the floor to get required NOI — 10,000,000 × 7.5% = 750,000 — or divide NOI by the floor to get the maximum loan: 800,000 ÷ 7.5% = 10,666,666.67. Enter either direction into this calculator and it solves all of them together, returning the yield, the headroom in points, the gap in currency and the NOI the floor demands of your specific balance.
What is a good debt yield ratio?
Most commercial lenders treat 10% or higher as strong, 8% to 10% as standard, and below 8% as weak — a zone where the loan is thin against the property's cash flow and lenders will typically reduce the amount, add reserves or decline. What counts as good depends heavily on the product. Agency multifamily paper commonly carries a 7.5% floor because the income is stable and the loan is assumable, while hotel or transitional assets are held to 10% to 12% because the income is volatile. Read the floor written into your own term sheet as the definition of good for that deal, then test the real loan amount against it.
What debt yield floor do lenders use?
Conventional floors by product: agency and multifamily near 7.5% to 9%, regional bank deals 8% to 10%, CMBS pools 8.5% to 10%, life insurance companies 9% to 11%, and bridge or transitional paper 7% to 9% but with tighter LTV and DSCR tests attached. Property type matters as much as the lender: industrial and self-storage often clear at 8%, anchored retail around 8.5%, office near 9%, and hotels 10% to 12%. These are market conventions rather than rules — the floor in your term sheet governs, which is why the calculator lets you test against any number and sweep the whole range in the sensitivity grid.
How is debt yield different from DSCR?
Debt yield divides NOI by the loan balance; DSCR divides NOI by annual debt service. Debt yield therefore ignores the interest rate and the amortisation schedule, while DSCR is entirely driven by them. On the retail preset the debt-yield ceiling is 14,117,647.06 at an 8.5% floor, but at 6.5% over 30 years with a 1.25 coverage requirement the DSCR ceiling falls to 12,656,865.56 — the coverage test binds first. Lenders run both for a reason: debt yield asks whether the asset can carry the principal, DSCR asks whether it can carry the payments, and a loan must satisfy whichever constraint is tighter.
How is debt yield different from cap rate?
Cap rate is NOI divided by value; debt yield is NOI divided by loan. The two are locked together by the identity debt yield = cap rate ÷ LTV, which holds exactly: a 6% cap rate at 70% LTV is an 8.57% debt yield. That relationship explains how the same building can show a comfortable cap rate and a weak debt yield at once — leverage is the divisor, so every point of LTV pushes the yield up. Whenever you enter a property value this calculator cross-checks the identity automatically, printing the cap rate and LTV next to the yield so the two views reconcile.
Can debt yield be too high?
Yes, though rarely as a credit problem. A very high debt yield usually means the loan is small relative to the income — either the borrower left proceeds on the table, the price paid was low relative to income, or the NOI includes items a lender will not underwrite anyway. In sizing mode, a high implied yield on the recommended loan is a signal about the process rather than the deal: it tells you a test other than debt yield is binding, so the real constraint is leverage or coverage rather than income. For a borrower the practical question is not whether the ratio is high, but whether the binding test lets you borrow what you need.
How can I improve debt yield on a deal?
Three levers, in order of speed: increase underwritten NOI by confirming recoveries, completing lease-ups or reclassifying expenses the lender will credit; reduce the loan amount by bringing more equity or repricing the deal; or negotiate a lower floor with the lender if the asset class supports it. On the default example, lifting NOI from 800,000 to 850,000 raises the yield from 8.00% to 8.50% on the same loan and pushes the floor-based maximum from 10,666,666.67 to 11,333,333.33. Alternatively, trimming the loan to 9,500,000 reaches 8.42% with no change to income at all.
Does debt yield apply to residential mortgages?
Rarely. Consumer mortgages are underwritten with front-end and back-end debt-to-income ratios, LTV and credit score, because the salary — not the property — repays the debt. Debt yield is a commercial ratio, used on multifamily, office, retail, industrial and hospitality loans where the building's income services the loan. Some residential investors and portfolio lenders do apply it informally, and because the cap-rate identity holds for any income property it transfers directly. If you are comparing a residential quote with a commercial one, expect only the commercial term sheet to carry a minimum debt yield floor.
What is the annual loan constant and why does it matter?
The annual loan constant is one year of debt service divided by the original loan balance, expressed as a percentage — the yearly cost of carrying the debt per dollar borrowed. At 6.25% over 30 years it is 7.3886%; at 7% over 25 years it is 8.4814%. It is the bridge between NOI and the DSCR test, because the coverage ceiling equals NOI divided by minimum DSCR, divided by that constant. A lower constant means each dollar of income supports more debt, which is exactly why the DSCR ceiling in sizing mode moves the moment you change the note rate or the amortisation term — and why the calculator prints the constant alongside the ceiling.
How does three-test sizing decide the loan amount?
Each test produces its own ceiling. The debt-yield test gives NOI ÷ floor; the LTV test gives value × maximum LTV; the DSCR test gives (NOI ÷ minimum DSCR) ÷ annual loan constant. The calculator recommends the smallest of the three, because that is the first constraint the loan hits in underwriting. Ties resolve in a fixed order — debt yield, then LTV, then DSCR — so the reported binding test is deterministic rather than arbitrary. On the retail preset the ceilings are 14,117,647.06, 11,200,000 and 12,656,865.56, so LTV binds at 11,200,000 and the implied debt yield on that loan comes out at 10.71%.

Discover More Tools

Fresh picks from across our tool library.

House Hacking Calculator

Ohm's Law Calculator

Reading Time Calculator

Take-Home Pay Calculator

Gravitational Force Calculator

AP/Honors Weighted GPA Calculator