Calcady™

Commercial Real Estate Triangulated Debt Sizing Matrix

Size commercial real estate loans across LTV, DSCR, and Debt Yield constraints. Determine governing loan proceeds, required equity, and debt constants.
Institutional Presets:Quickly load standard underwriting parameters

1. Property Financials

Total asset cost or appraisal
In-place net operating income
Origination, title, legal, escrow

2. Financing Terms

Nominal annual borrowing rate
Principal + interest schedule
Annual Loan Constant (k):
7.585%
Monthly debt constant: 0.6321%

3. Lender Underwriting Hurdles

Typical: 65% to 75% LTV
Typical: 1.20x to 1.35x coverage
Typical: 8.5% to 10.5% DY
BINDING GOVERNING CONSTRAINT: DSCR

$6,855,802

The loan is restricted by the DSCR covenant. To increase proceeds, lower interest rate, negotiate longer amortization, or increase property NOI.

Required Equity$3,144,19831.4% of basis
Monthly Payment$43,333$520,000/yr
Achieved DSCR1.25xDY: 9.5%
Underwriting Triangulation Visualizer

Three-Pillar Covenant Comparison & Governing Constraint

Governing: DSCR Constraint
$7,500,0001. LTV Limit68.6% CapGOVERNING$6,855,8022. DSCR LimitCoverage Constraint$7,222,2223. Debt Yield LimitLender Return Basis
CAPITAL STACK DISTRIBUTIONPROPERTY VALUE: $10,000,000
Senior Debt68.6%
Common Equity31.4%
Senior Loan$6,855,802
Required Equity$3,144,198
Closing Costs (est.)$102,837
Net Loan Proceeds$6,752,965

Three Underwriting Sizing Limits(Detailed Breakdown)

Underwriting CovenantHurdle RequirementSized Loan ProceedsAchieved RatioStatus
Loan-to-Value (LTV)75.0% Max$7,500,00068.6%+$644,198 cushion
Debt Service Coverage (DSCR)1.25x Min$6,855,8021.25xBINDING CONSTRAINT
Debt Yield (DY)9.0% Min$7,222,2229.5%+$366,420 cushion

Underwriting Sensitivity Matrix: Interest Rate vs. NOI

Shows max supportable loan across interest rate shifts (rows) and NOI variations (columns).

[DSCR] = DSCR Governed | [LTV] = LTV Governed | [DY] = DY Governed
Rate \ NOI-10% NOI-5% NOIBase NOI+5% NOI+10% NOI
5.50% (-100 bps)
$6,500,000
DY
$6,861,111
DY
$7,222,222
DY
$7,500,000
LTV
$7,500,000
LTV
6.00% (-50 bps)
$6,500,000
DY
$6,861,111
DY
$7,222,222
DY
$7,500,000
LTV
$7,500,000
LTV
6.50% (0 bps)
$6,170,222
DSCR
$6,513,012
DSCR
$6,855,802
DSCR
$7,198,592
DSCR
$7,500,000
LTV
7.00% (+50 bps)
$5,861,995
DSCR
$6,187,662
DSCR
$6,513,328
DSCR
$6,838,994
DSCR
$7,164,661
DSCR
7.50% (+100 bps)
$5,577,687
DSCR
$5,887,559
DSCR
$6,197,431
DSCR
$6,507,302
DSCR
$6,817,174
DSCR
Email LinkText/SMSWhatsApp

What is Commercial Real Estate Triangulated Debt Underwriting & Capital Sizing?

Institutional commercial mortgage underwriting evaluates loan proceeds simultaneously across three core credit covenants: Loan-to-Value (LTV), Debt Service Coverage Ratio (DSCR), and Debt Yield (DY). Sizing algorithms determine the binding constraint governing maximum supportable loan proceeds, calculating the resultant sponsor equity requirement and interest rate sensitivity.

Mathematical Foundation

Constraint 1: Maximum Loan via Loan-to-Value (LTV)
LoanLTV=Vappraised×LTVmax⁡\text{Loan}_{\text{LTV}} = V_{\text{appraised}} \times \text{LTV}_{\max}
LoanLTV\text{Loan}_{\text{LTV}}= Maximum allowable loan based on appraised property valuation ($)
VappraisedV_{\text{appraised}}= Appraised market valuation or purchase price of the property ($)
LTVmax⁡\text{LTV}_{\max}= Lender maximum loan-to-value percentage threshold (e.g., 0.75 for 75%)
Constraint 2: Maximum Loan via Debt Service Coverage Ratio (DSCR)
LoanDSCR=NOIDSCRmin⁡×k\text{Loan}_{\text{DSCR}} = \frac{\text{NOI}}{\text{DSCR}_{\min} \times k}
LoanDSCR\text{Loan}_{\text{DSCR}}= Maximum supportable loan governed by property operating cash flow ($)
NOI\text{NOI}= Underwritten annual Net Operating Income ($)
DSCRmin⁡\text{DSCR}_{\min}= Lender minimum debt service coverage ratio (e.g., 1.25x)
kk= Annual mortgage loan constant: k = 12 × [r(1+r)^n / ((1+r)^n - 1)]
Constraint 3: Maximum Loan via Debt Yield (DY)
LoanDY=NOIDYmin⁡\text{Loan}_{\text{DY}} = \frac{\text{NOI}}{\text{DY}_{\min}}
LoanDY\text{Loan}_{\text{DY}}= Maximum supportable loan governed by minimum cash-on-cash yield ($)
NOI\text{NOI}= Underwritten in-place annual Net Operating Income ($)
DYmin⁡\text{DY}_{\min}= Lender minimum acceptable debt yield threshold (e.g., 0.09 for 9.0%)
Triangulated Sizing & Required Common Equity
Loanmax⁡=min⁡(LoanLTV, LoanDSCR, LoanDY),Equity=V−Loanmax⁡\text{Loan}_{\max} = \min(\text{Loan}_{\text{LTV}},\ \text{Loan}_{\text{DSCR}},\ \text{Loan}_{\text{DY}}), \quad \text{Equity} = V - \text{Loan}_{\max}
Loanmax⁡\text{Loan}_{\max}= Binding maximum supportable senior loan proceeds ($)
Equity\text{Equity}= Required sponsor common equity contribution to complete capitalization ($)

Laws & Principles

  • Triangulated Underwriting Principle: Commercial real estate debt proceeds are determined by the minimum of three binding covenants: Loan-to-Value (asset equity protection), Debt Service Coverage Ratio (operational cash flow buffer), and Debt Yield (unlevered lender return basis).
  • The DSCR Rate-Inversion Law: As benchmark interest rates rise, the annual loan constant (k) increases. Because Loan_DSCR = NOI / (DSCR_min × k), proceeds under DSCR compress rapidly, flipping the governing constraint away from LTV to cash flow.
  • Debt Yield Basis Independence: Debt Yield (NOI / Loan Amount) measures the lender's day-one cash return if foreclosure occurs. Unlike DSCR, it is completely independent of loan amortization term, interest rate, and exit cap rate assumptions.
  • Capital Stack Equilibrium: Total Capitalization = Senior Debt + Required Equity. Any shortfall between the governing sized senior loan and the total acquisition cost must be bridged by sponsor common equity, mezzanine debt, or preferred equity.
  • Unlevered Basis Protection: Lenders enforce Debt Yield hurdles (typically 8.0% to 11.0%) to prevent overleveraging assets in low cap-rate environments where high property valuations might otherwise support excessive debt under LTV tests.

Step-by-Step Example Walkthrough

" An acquisition analyst is evaluating senior permanent debt for a $10,000,000 grocery-anchored retail center generating $650,000 in underwritten annual NOI. The lender offers a 6.50% interest rate with 30-year amortization and standard underwriting covenants: 75% max LTV, 1.25x min DSCR, and 9.0% min Debt Yield. "

  1. 1. Calculate Loan via LTV: Loan_LTV = $10,000,000 × 75.0% = $7,500,000.
  2. 2. Determine monthly and annual loan constant: At 6.50% annual interest with 30-year amortization (360 months), monthly rate r = 0.065 / 12 = 0.0054167. Monthly constant km = [0.0054167 × (1.0054167)^360] / [(1.0054167)^360 - 1] = 0.00632068. Annual constant k = 12 × 0.00632068 = 0.075848 (7.585%).
  3. 3. Calculate Loan via DSCR: Max allowable annual debt service = $650,000 / 1.25 = $520,000. Loan_DSCR = $520,000 / 0.075848 = $6,855,802.
  4. 4. Calculate Loan via Debt Yield: Loan_DY = $650,000 / 0.090 = $7,222,222.
  5. 5. Triangulate the three constraints: Comparing LTV ($7,500,000), DSCR ($6,855,802), and Debt Yield ($7,222,222), the binding covenant is DSCR.
  6. 6. Determine required common equity: Required Equity = $10,000,000 - $6,855,802 = $3,144,198 (31.44% of capitalization).
  7. 7. Calculate actual debt service: Annual Debt Service = $6,855,802 × 0.075848 = $520,000 ($43,333.33/month), yielding an achieved DSCR of exactly 1.25x and an achieved LTV of 68.56%.
Final Result: The loan is DSCR-constrained at $6,855,802, requiring $3,144,198 in sponsor equity. Because 6.50% interest elevates debt constant k to 7.585%, cash flow limits borrowing $644,198 below the 75% LTV ceiling.

Quick Answer: How do commercial real estate lenders size loan proceeds?

Commercial lenders determine loan proceeds by calculating three separate limits and taking the lowest (most restrictive) amount: (1) LTV Sizing = Appraised Value × Max LTV (typically 65%–75%); (2) DSCR Sizing = (NOI / Min DSCR) / Annual Loan Constant (typically 1.20x–1.35x); (3) Debt Yield Sizing = NOI / Min Debt Yield (typically 8.5%–10.0%). The smallest figure becomes the binding senior loan, and the difference between total purchase price and this sized loan represents the mandatory sponsor equity requirement.

Institutional Commercial Underwriting Benchmarks by Asset Class

Asset Sector Max LTV (%) Min DSCR (x) Min Debt Yield (%) Typical Governing Hurdle
Multifamily (Agency / GSE) 75.0% – 80.0% 1.25x 7.5% – 8.5% DSCR / LTV
Industrial / Logistics 65.0% – 70.0% 1.25x – 1.30x 8.5% – 9.5% LTV / Debt Yield
Grocery-Anchored Retail 65.0% – 70.0% 1.30x – 1.35x 9.0% – 10.0% DSCR / Debt Yield
Hospitality (Full Service) 55.0% – 60.0% 1.40x – 1.50x 11.0% – 12.5% Debt Yield (Basis Risk)
Class-A Commercial Office 50.0% – 60.0% 1.35x – 1.45x 10.5% – 12.0% Debt Yield / DSCR

Frequently Asked Questions

Why do high interest rates flip the governing loan constraint from LTV to DSCR?

The debt service coverage constraint (Loan_DSCR = NOI / (DSCR_min × k)) depends directly on the annual loan constant (k). When interest rates increase, the mortgage constant rises steeply. Even if a property appraises for a high valuation, its current Net Operating Income cannot support a larger mortgage without violating the lender's 1.25x DSCR safety cushion, making cash flow the binding bottleneck rather than asset value.

What is Debt Yield and why do commercial lenders rely on it?

Debt Yield is calculated as annual Net Operating Income divided by the total loan amount (NOI / Loan). It represents the lender's unlevered, cash-on-cash rate of return if they had to take title to the property through foreclosure on day one. Unlike LTV (which relies on subjective market cap rates and appraisals) or DSCR (which can be manipulated by lengthening amortization or offering interest-only periods), Debt Yield provides an unvarnished measure of lender basis risk.

How does Interest-Only (I/O) financing affect triangulated loan sizing?

Under an Interest-Only loan, the borrower makes zero principal payments. The annual loan constant (k) drops to equal the nominal interest rate (e.g., 6.00% rather than 7.19% for a 30-year amortizing loan). This lower constant substantially expands the DSCR loan capacity. However, because Debt Yield does not account for amortization, lenders often tighten Debt Yield hurdles on I/O loans to prevent overleveraging.

What options do borrowers have when facing an equity gap caused by a DSCR bottleneck?

When sized senior debt falls short of acquisition targets due to DSCR constraints, borrowers typically pursue four avenues: (1) injecting additional common equity, (2) securing mezzanine financing or preferred equity to fill the middle capital stack, (3) negotiating seller carryback financing, or (4) negotiating an interest rate buydown or interest-only period with the senior lender.