Debt Yield & Refinancing Risk Calculator
Size commercial mortgage loans across the institutional Tri-Constrained Underwriting Framework (Debt Yield vs. DSCR vs. LTV). Identify the binding constraint, calculate refinancing equity shortfalls (cash-in requirements), model interest rate shocks, and export 1-click lender credit packages and IC presentation decks.
1. Property Financials & Valuation
Contractual revenue minus operating expenses & reserves
Prevailing institutional exit cap rate
2. Maturing Debt Facility (The Balloon Cliff)
Current loan principal due at maturity
Origination, legal, title, appraisal & rate lock
3. Senior Takeout Underwriting Parameters
Constrained by lender's 9.50% minimum Debt Yield threshold.
To settle the $34,000,000 expiring balance plus $663,158 in fees, the sponsor must inject $1,505,263 in fresh equity.
Because Debt Yield = NOI / Loan and Cap Rate = NOI / Value, the mathematical identity holds:Debt Yield = Cap Rate / LTV ⟺ Max LTV = Cap Rate / Target Debt YieldAt a 5.75% market cap rate and a 9.50% required Debt Yield, the lender is mathematically capping your loan at 60.5% LTV.
Dynamic Capital Markets Sensitivity Sandbox
Stress-test property NOI changes, rate shocks, and lender hurdle rate expansions in real time.
2D Underwriting Sensitivity Matrix: Property NOI vs. Debt Yield Hurdle
Displays senior loan sizing proceeds (in $M) and highlights resulting refinancing equity shortfalls across market conditions.
| NOI Scenario | In-Place NOI | 9.00% DY | 9.50% DY | 10.00% DY | 10.50% DY | 11.00% DY |
|---|---|---|---|---|---|---|
| -10% NOI | $2.83M | $30.70M -3.92M Gap | $29.84M -4.75M Gap | $28.35M -6.22M Gap | $27.00M -7.54M Gap | $25.77M -8.74M Gap |
| -5% NOI | $2.99M | $32.40M -2.25M Gap | $31.50M -3.13M Gap | $29.93M -4.67M Gap | $28.50M -6.07M Gap | $27.20M -7.34M Gap |
| Base Case | $3.15M | $34.11M -0.58M Gap | $33.16M -1.51M Gap | $31.50M -3.13M Gap | $30.00M -4.60M Gap | $28.64M -5.94M Gap |
| +5% NOI | $3.31M | $35.81M +1.10M Surplus | $34.82M +0.12M Surplus | $33.08M -1.59M Gap | $31.50M -3.13M Gap | $30.07M -4.53M Gap |
| +10% NOI | $3.47M | $37.52M +2.77M Surplus | $36.47M +1.74M Surplus | $34.65M -0.04M Gap | $33.00M -1.66M Gap | $31.50M -3.13M Gap |
1-Click Institutional Memoranda & Presentation Outlines
Zero-friction copyable memoranda formatted for Lender Credit Committees, LP Investors, and Sponsor Board Decks.
================================================================================ INSTITUTIONAL LENDER CREDIT COMMITTEE: COMMERCIAL REAL ESTATE LOAN APPROVAL MEMO PROPERTY ASSET: Multifamily Residential (Suburban Sunbelt) VALUATION: $54,782,609 (@ 5.75% Cap Rate) REQUESTED TAKEOUT SIZING: $33,157,895 (Debt Yield Hurdle) ================================================================================ 1. EXECUTIVE UNDERWRITING SUMMARY & SIZING RECOMMENDATION -------------------------------------------------------------------------------- The Credit Committee is requested to approve a senior mortgage refinancing package of $33,157,895 to refinance the existing debt facility of $34,000,000. The underwriting team applied the institutional Tri-Constrained Loan Sizing Framework: • Sizing by Minimum Debt Yield (9.50% Hurdle): $33,157,895 • Sizing by Minimum DSCR (1.25x @ 6.25% rate): $34,106,567 • Sizing by Maximum LTV (65.0% Ceiling): $35,608,696 BINDING UNDERWRITING CONSTRAINT: The loan is strictly constrained by the DEBT YIELD HURDLE (Constrained by lender's 9.50% minimum Debt Yield threshold.). The senior loan amount is capped at $33,157,895, resulting in: • Underwritten In-Place Debt Yield: 9.50% (vs. 9.50% required hurdle) • Underwritten In-Place DSCR: 1.29x (vs. 1.25x covenant floor) • Underwritten Loan-to-Value (LTV): 60.5% (vs. 65.0% ceiling) • Annual Debt Service Requirement: $2,449,906 (Mortgage Constant: 7.39%) • Annual Cash Flow After Debt Service: $700,094 2. REFINANCING GAP & SOURCES AND USES -------------------------------------------------------------------------------- To pay off the expiring facility of $34,000,000 plus estimated lender fees, legal expenses, and reserves of $663,158 (2.0%), total payoff capital required is $34,663,158. • Senior Takeout Loan Proceeds: $33,157,895 • Total Refinancing Payoff Requirement: $34,663,158 • NET REFINANCING STATUS: CASH-IN EQUITY GAP OF $1,505,263 CONDITION PRECEDENT: The sponsor must fund an equity cash-in contribution of $1,505,263 at closing to bridge the shortfall, escrowed 5 business days prior to closing. 3. LENDER LOSS PROTECTION & SPREAD ANALYSIS -------------------------------------------------------------------------------- • Unleveraged Debt Yield Cushion: +3.75% spread above property Cap Rate • Implied Max LTV at Debt Yield: 60.5% (mathematical identity: Cap Rate / Debt Yield) • Break-Even NOI for Debt Service: $2,449,906 (represents a 22.2% tolerable NOI cushion) • Break-Even NOI for Full Refi ($0 Gap): $3,295,918 (NOI gap: $145,918) RECOMMENDATION: APPROVAL recommended subject to sponsor equity verification and standard closing escrows.
Why Debt Yield is the King of Commercial Mortgage Underwriting
In commercial real estate finance, Debt Yield has superseded traditional Loan-to-Value (LTV) and Debt Service Coverage Ratio (DSCR) as the paramount risk metric mandated by CMBS originators, life insurance companies, and debt funds.
The fundamental flaw of traditional DSCR (Net Operating Income / Debt Service) is that it can be easily manipulated through financial engineering. A sponsor can take an otherwise distressed asset and artificially inflate its DSCR from a failing 1.10x to an institutional 1.45x simply by negotiating a 3-year Interest-Only (IO) period, extending amortization from 25 to 30 years, or buying down floating-rate SOFR caps. DSCR measures current debt service payment affordability—not the underlying debt risk.
Similarly, Loan-to-Value (LTV) relies heavily on subjective, backward-looking appraiser opinions. In periods of macroeconomic rate volatility, transaction volume freezes and appraisal cap rates lag behind real capital markets pricing. Debt Yield solves both problems with mathematical purity:
Debt Yield asks the single most critical question in credit underwriting: “If the borrower walks away tomorrow and the lender forecloses on the property, what is the lender’s exact unleveraged cash-on-cash return on its loan basis?” It is completely independent of the interest rate, amortization schedule, or appraisal valuation.
The Mathematical Identity: Debt Yield = Cap Rate / LTV
A common misconception among borrowers is that Debt Yield and Loan-to-Value are independent constraints. In reality, they are bound by an exact mathematical identity derived from fundamental real estate accounting:
Dividing the Cap Rate formula by the LTV formula yields:
Rearranging this identity provides the ultimate institutional rule of thumb:
If an industrial property trades at a 5.50% Cap Rate and a lender demands a 10.00% Debt Yield, the lender is mathematically prohibiting the loan from exceeding 55.0% LTV (5.50% / 10.00% = 55.0%). Even if the term sheet advertises “Up to 65% LTV,” the 10.0% Debt Yield hurdle will always govern!
Cross-Property Type Debt Yield Benchmark Matrix
Lender Debt Yield requirements vary significantly across commercial real estate sectors based on tenant lease length, re-leasing capital expenditures, and historical cash flow volatility:
| Property Asset Class | Typical Cap Rate | Senior Debt Yield Hurdle | Min. DSCR Target | Max Underwritten LTV | Underwriting Rationale |
|---|---|---|---|---|---|
| Multifamily Class A/B | 5.25% - 6.00% | 8.75% - 9.75% | 1.20x - 1.25x | 65% - 70% | Fannie/Freddie agency liquidity; granular tenant base. |
| Industrial Logistics | 5.75% - 6.50% | 9.25% - 10.25% | 1.25x - 1.30x | 60% - 65% | Long-term leases, credit tenants, low ongoing capex drag. |
| Grocery-Anchored Retail | 6.50% - 7.25% | 10.00% - 11.00% | 1.30x - 1.35x | 60% - 65% | Foot traffic resilience; anchor co-tenancy covenants. |
| Life Science & Medical | 6.75% - 7.50% | 10.50% - 11.50% | 1.35x - 1.40x | 55% - 60% | Specialized wet lab/clinical improvements; re-leasing capex. |
| Suburban Office / Mixed | 8.00% - 9.50%+ | 12.00% - 14.00%+ | 1.40x - 1.50x | 45% - 55% | Severe work-from-home lease attrition; bank syndication freeze. |
5 Fatal Mistakes Sponsors Make in Lender Debt Presentations
1. Sizing Proceeds Exclusively on Appraised LTV
Borrowers frequently enter lender negotiations demanding 65% LTV without verifying the Debt Yield. If property cap rates are 5.5% and the lender demands a 10.0% Debt Yield, the actual maximum loan is 55.0% LTV. Pitching 65% immediately flags underwriting amateurism to credit officers.
2. Using Pro Forma or Stabilized NOI Instead of Trailing In-Place NOI
Institutional lenders underwrite senior loan sizing based on Trailing 12-Month (T12) or Trailing 3-Month (T3) annualized collections. Incorporating unexecuted lease renewals or projected mark-to-market upside into the Debt Yield denominator results in immediate lender pushback and re-trading.
3. Omitting Replacement Reserves from NOI Deductions
Lenders calculate Underwritten Net Cash Flow (NCF) by deducting capital replacement reserves (e.g. $250–$350/unit/year for multifamily, $0.15–$0.25/sq ft for industrial) from reported GAAP NOI. Failing to deduct reserves overstates debt yield by 25 to 50 basis points.
4. Ignoring Financing Fees in Refinancing Gap Calculations
Closing a $30M+ commercial mortgage incurs 1.5% to 2.5% in transaction drag: lender origination fees (1.0%), legal fees ($75k–$150k), title insurance, third-party reports (Appraisal, Phase I ESA, Property Condition Assessment), and rate lock escrows. A borrower who calculates debt payoff without fees ends up underfunding the equity escrow at closing.
5. Failing to Model Tri-Constrained Binding Bottlenecks
A package that fails to disclose whether the loan is constrained by Debt Yield, DSCR, or LTV delays credit committee approval. Credit analysts must write the constraint into their formal approval memo. Presenting the exact tri-constrained comparison upfront accelerates credit sign-off.
Real-World Case Study: $55M Multifamily Community Resolving a $1.5M Refinancing Gap
The Scenario: A private equity real estate sponsor acquired a 220-unit Class A apartment asset in Dallas, TX in 2021 for $58.0M using a $34.0M floating-rate bridge loan at SOFR + 325 bps. By 2024, the bridge facility reached its contractual maturity date. In-place net operating income (NOI) grew to $3,150,000, and a fresh appraisal valued the asset at $54,780,000 (a 5.75% capitalization rate).
The Dilemma: The sponsor approached an agency lender seeking a 65% LTV refinancing ($35.61M), which would have fully paid off the $34.0M bridge loan with $950k in cash-out proceeds. However, the agency underwriter applied the Tri-Constrained Loan Sizing framework:
- LTV Ceiling (65.0% of $54.78M): $35,607,000
- DSCR Constraint (1.25x @ 6.25% 30-yr amort): $34,105,000
- Debt Yield Hurdle (9.50% minimum): $33,157,895 (BINDING CONSTRAINT)
Factoring in $663,000 in loan fees and title escrows, total payoff capital required was $34,663,000. Sizing the loan to the 9.50% Debt Yield hurdle created an immediate $1,505,105 refinancing equity gap.
The Resolution: Armed with the Tri-Constrained sizing deck generated in XLSlides, the sponsor presented a structured briefing to their Limited Partners. Rather than selling the property into a soft buyer market at a 5.75% cap rate or issuing expensive 14% mezzanine debt, the partnership authorized a modest $1.50M capital call. The asset secured a 10-year fixed senior agency mortgage at 6.25%, yielding $734k in annual net cash flow after debt service (6.52% cash-on-cash return on equity).
Frequently Asked Questions (Debt Yield & Commercial Mortgage Underwriting)
What is Debt Yield in commercial real estate?
Debt Yield is an unleveraged underwriting metric defined as: Debt Yield = (Net Operating Income / Loan Amount) × 100. It quantifies the lender’s cash-on-cash rate of return on its loan principal if it were forced to foreclose and operate the property.
How is Debt Yield different from Cap Rate?
Cap Rate is NOI / Property Purchase Price, measuring the asset’s unleveraged return on total valuation. Debt Yield is NOI / Loan Amount, measuring return specifically on the lender’s senior loan basis. Because the loan is smaller than the property value (LTV < 100%), the Debt Yield is always higher than the Cap Rate.
What causes a Refinancing Gap?
A Refinancing Gap (equity shortfall) occurs when maturing debt originated during a low-interest-rate regime cannot be fully refinanced by a new takeout loan sized under higher debt yield hurdles and higher interest constants. Borrowers must inject fresh equity or raise mezzanine debt to close the gap.
What is the Tri-Constrained Loan Sizing framework?
Lenders size loans against three simultaneous constraints: 1) Debt Yield constraint (NOI / Target Debt Yield), 2) DSCR constraint (NOI / [Min DSCR × Mortgage Constant]), and 3) LTV ceiling (Property Value × Max LTV). The lowest of these three figures becomes the governing senior loan amount.
Can Debt Yield be changed by choosing Interest-Only (IO) financing?
No. Because Debt Yield divides NOI strictly by the loan principal amount, it is completely unaffected by whether the loan is 30-year amortizing, 25-year amortizing, or interest-only. This mathematical invariance is why credit committees rely on it over DSCR.
What Debt Yield do CMBS and Life Insurance lenders require today?
Most institutional lenders require 9.0% to 10.5% Debt Yields for multifamily and prime industrial logistics, 10.0% to 11.5% for grocery-anchored retail, and 12.0% to 14.0%+ for commercial office assets.
How do I turn this Debt Yield analysis into executive presentation slides?
Click “Generate Lender & Investment Committee Slides in XLSlides” above. XLSlides automatically formats your property financials, tri-constrained loan sizing comparisons, refinancing gap waterfall, and 2D sensitivity matrix into an executive PowerPoint (.pptx) or PDF presentation formatted in institutional banking styles (McKinsey, Morgan Stanley, Eastdil Secured).
Related Free Real Estate & Corporate Finance Tools
Debt Service Coverage Ratio (DSCR) Calculator
Evaluate annual debt service capacity, cash available for debt service (CFADS), and covenant headroom for lenders and boards.
Net Debt to EBITDA Leverage Calculator
Pair property debt yield analysis with corporate leverage covenants and debt paydown requirements for portfolio companies.
LBO Returns & Returns Attribution Calculator
Model sponsor equity IRR, MoIC, and returns attribution bridges across EBITDA growth, multiple expansion, and debt deleveraging.
Working Capital & Cash Flow Bridge Calculator
Bridge operating EBITDA to Free Cash Flow, decompose ΔNWC cash drag, and optimize cash conversion cycles.