Debt Yield vs DSCR vs Cap Rate: The Commercial Underwriting Trifecta

By Maniteja · Investor · Educational analysis

A debt yield vs DSCR calculator answers two different lending questions: how much property income supports each dollar borrowed, and how comfortably that income pays the scheduled debt service. Add cap rate and LTV, and you can see whether income, payment terms or collateral value actually limits the loan. The model below calculates all three measures together and shows the smallest of the entered DSCR, debt yield and LTV loan caps.

These are commercial underwriting calculations. A residential rental program may instead compare qualifying monthly rent with PITIA. Use our DSCR loan guide to distinguish the products before comparing quoted ratios. Every rate and threshold on this page is an editable illustration, not a lender quote or approval standard.

Why Commercial Lenders Rely on Debt Yield

Debt yield measures annual underwritten property cash flow relative to loan principal. Lowering the interest rate improves DSCR without changing the property's income or the amount owed. Extending amortization can do the same. Debt yield does not move merely because either payment assumption changes.

Suppose a property supports $120,000 of annual underwritten cash flow and a $1 million loan. Its debt yield is 12%. That remains 12% whether the loan has a 6.5% or 8.5% interest rate, provided the income and principal stay the same. DSCR changes because the scheduled payments change.

This is why commercial lenders can apply both tests. A long repayment schedule might make annual payments appear manageable while leaving substantial principal exposed to a weak property. The OCC commercial real estate lending handbook discusses debt yield alongside other underwriting measures. It is a complementary screen, not a replacement for appraisal, tenant analysis or repayment review.

Debt yield also is not a promised liquidation return. A 12% debt yield does not establish that foreclosure would recover principal, or that income would continue unchanged after a default. Selling costs, capital needs, collection problems and changes in occupancy still matter.

The Debt Yield Formula: NOI Divided by Loan Amount

The basic debt yield formula is annual NOI ÷ outstanding or proposed loan principal × 100. Use a consistent measurement date and explain any lender adjustments to NOI. Do not mix an annual numerator with a monthly denominator.

Build the numerator before calculating ratios. Potential rent less vacancy and collection loss, plus supported other income, produces effective gross income, or EGI. EGI less recurring operating expenses produces NOI. Mortgage payments, income taxes and depreciation are not property operating expenses in this model. Replacement reserves appear separately when the lender deducts them in underwriting.

For a smaller hypothetical rental, $3,200 monthly potential rent produces $38,400 annually. A 5% vacancy and collection allowance leaves $36,480. Subtract $12,000 of operating expenses and NOI is $24,480. On a $280,000 loan, unadjusted debt yield is 8.74%. At an illustrative 7.5% rate over 30 years, annual P&I is about $23,494, producing approximately 1.04x NOI-based DSCR before any reserve adjustment.

That example demonstrates a definition, not an available commercial program for a single house. If a residential lender uses rent divided by PITIA, the answer will differ. Our rental property DSCR calculation guide explains why a ratio must travel with its income and expense definitions.

Minimum Debt Yield Thresholds: 9%, 10% and 11.5% Scenarios

There is no universal 9.5% minimum across commercial lending. A requirement can vary by property type, lender, sponsor, market, lease structure and loan terms. The 9%, 10% and 11.5% figures below are sensitivity assumptions. Obtain the actual minimum and its numerator definition from the proposed lender.

Loan capacity from debt yield equals underwritten cash flow divided by the required debt yield expressed as a decimal. At $120,000 of cash flow, a higher required yield reduces the permitted balance.

These amounts are only debt yield caps. They ignore the other constraints until those constraints are calculated separately. A $1.2 million debt yield limit does not mean $1.2 million is fundable if the appraisal or payment test supports less.

Ask whether the lender uses historical, annualized or stabilized income. Then reconcile management fees, replacement reserves, tax reassessment and insurance renewal costs. A seemingly minor numerator adjustment affects both debt yield and DSCR. Changing the label on a spreadsheet does not eliminate that adjustment.

The Three-Way Relationship: Cap Rate vs DSCR vs Debt Yield

Cap rate compares property NOI with property value. Debt yield compares underwritten cash flow with loan principal. DSCR compares underwritten cash flow with annual debt service. The denominators explain why these percentages and multiples cannot be substituted for one another.

When the same NOI is used throughout, debt yield equals cap rate divided by LTV. A 6% cap rate at 60% LTV implies a 10% debt yield. Likewise, DSCR equals debt yield divided by the mortgage constant, where the mortgage constant is annual debt service divided by principal. These identities stop working as written if one numerator includes a reserve deduction and another does not.

The calculator deliberately uses property NOI to estimate value from cap rate. It then deducts the entered replacement reserve for the DSCR and debt yield numerator. With a nonzero reserve, those lender ratios will use less cash flow than the value calculation. The result labels make the difference visible.

Consider the default $120,000 NOI, no reserve, 6% cap rate and $1 million loan. Indicated value is $2 million, LTV is 50%, and debt yield is 12%. At 7.5% over 30 years, annual P&I is approximately $83,906 and DSCR is approximately 1.43x. The rate here is a scenario assumption, not today's DSCR pricing.

The smallest cap governs this simplified model. If two caps tie, both constraints matter. A lender may add lower limits for concentration, loan size, collateral condition or borrower liquidity. The model does not underwrite those restrictions, subordinate debt, interest-only periods, loan fees or a maturity balloon.

Interactive Live Debt Yield Modeler

Enter annual property NOI after recurring operating expenses. Enter replacement reserves separately rather than deducting the same reserve twice. A negative NOI stress percentage reduces income, while a positive percentage increases it. Use the remaining controls to enter proposed terms and actual lender thresholds when available.

The matrix varies interest rates across columns and cap rates down rows. Each cell recomputes the minimum DSCR, debt yield and LTV loan caps. The five rate scenarios are centered on your entered rate; cap-rate scenarios are centered on your entered cap rate. Cells display permitted principal under the entered assumptions, rather than DSCR alone.

Try raising the interest rate while leaving NOI and principal unchanged. Requested-loan DSCR falls, but debt yield stays fixed. Then raise the cap rate. Indicated property value and the LTV loan cap fall, while debt yield on the requested balance remains unchanged. These are distinct routes to a lower supported loan.

Finally, reduce NOI by 10%. All income-dependent loan caps decline. The model keeps the reserve as the entered dollar amount, so adjusted cash flow may decline by a different percentage. That is useful when a reserve does not automatically shrink just because collections weaken.

The form rejects a reserve greater than stressed NOI and percentages that cannot produce a valid positive cap rate. Zero interest is supported through a straight principal-amortization calculation. A result is an educational calculation, not a commitment to lend. No personal financial information is required or sent by the tool.

For an apartment acquisition, compare these results with our commercial DSCR guide for 5–20 unit multifamily. Five-plus-unit collateral belongs in a commercial product discussion; conventional one-to-four-unit mortgage rules should not be carried over as if every commercial lender follows them. Commercial and non-QM flexibility still comes with property, sponsor and documentation requirements.

Downloadable Commercial Sizing Model

Download the commercial DSCR, debt yield and cap rate Excel model (.xlsx). For a snapshot of your current scenario, use Export CSV for Excel in the live modeler above.

The Excel workbook contains editable inputs, formula-driven outputs and a native two-input What-If Data Table for interest rate and cap rate. Blue input cells identify the values to change. The default matrix uses fixed scenario axes, so edit the axis values if you want a different range. Recalculate in desktop Excel after changing assumptions; another spreadsheet application may handle Excel Data Tables differently.

The page's CSV export records the current inputs, ratio outputs, loan caps and sensitivity matrix. Excel can open it, but a CSV stores values rather than formulas. Download the XLSX when you want a reusable calculation model. Use CSV when you need a dated snapshot to compare with a term sheet.

Before sending a model to a lender, replace every illustrative threshold with the lender's written requirement. Reconcile the property's income period, recurring expenses, reserves and accepted value. Note which assumption produces the lowest cap and how much equity that cap requires. A clean calculation is useful only when the supporting evidence is equally clear.

Keep the three denominators visible: For $100,000 NOI, an $800,000 loan and $1.25 million value imply 12.5% debt yield and an 8% cap rate. If annual debt service is $80,000, DSCR is 1.25. Changing the interest rate alters DSCR without changing the other two ratios unless the loan amount, NOI or valuation also changes.

Frequently Asked Questions