Commercial Real Estate & Structured Finance
Real Estate Mezzanine Debt & Blended Cost Formula
Calculate Combined Senior-plus-Mezzanine Loan-to-Value (CLTV), Blended Debt Coupon Rate, Combined Interest-Only DSCR, and Levered Cash-on-Cash Equity Yield.
Price the marginal cost of stretching leverage from 60% Senior LTV to 75% CLTV with Mezzanine Debt!
When a commercial mortgage lender caps Senior First-Lien LTV at ltv_sen = 60.0% at interest rate r_sen = 6.0%, a sponsor seeking 75.0% Combined Loan-to-Value (CLTV) layers a subordinate Mezzanine Tranche ltv_mez = 15.0% (pledging 100% of equity LLC membership interests under an Intercreditor Agreement) at r_mez = 12.0%! Look at two critical numbers: (1) Blended Debt Rate r_blend = (ltv_sen * r_sen + ltv_mez * r_mez) / (ltv_sen + ltv_mez), and (2) Levered Equity Cash-on-Cash Return CoC = (NOI - V_prop * (ltv_sen * r_sen + ltv_mez * r_mez)) / (V_prop * (1 - ltv_sen - ltv_mez))! Notice the negative-leverage trap: if Property Cap Rate NOI / V_prop = 8.0% exceeds Senior 6.0% (positive senior leverage) YET sits BELOW Mezzanine 12.0%, adding 12% mezzanine debt REDUCES cash-on-cash equity yield!
Verify on Property_Value V_prop = $100.00M (B2), Property_NOI = $8.25M (8.25% Cap Rate, B3), Senior_LTV ltv_sen = 0.60 ($60M @ r_sen = 0.06 = $3.60M interest, B4 & B5), and Mezzanine_LTV ltv_mez = 0.15 ($15M @ r_mez = 0.12 = $1.80M interest, B6 & B7 -> Total Debt = $75M, Sponsor Equity = $25M): Combined LTV is 0.7500 (75.00% in E2); Blended Debt Rate is (3.60 + 1.80) / 75.00 = 0.0720 (7.20% in E3); Combined Interest-Only DSCR is 8.25 / 5.40 = 1.5278x (E4); and Levered Cash-on-Cash Yield is (8.25 - 5.40) / 25.00 = 0.1140 (11.40% in E5—still BELOW un-mezzed 60%-Senior CoC of (8.25 - 3.60) / 40 = 11.625% because 12.0% Mezz > 8.25% Cap Rate!)! Drop r_mez to 0.075 (7.50% < 8.25% Cap Rate): CoC jumps to (8.25 - 4.725) / 25 = 0.1410 (14.10%, positive mezz leverage)!
| Capital Stack Metric ($100M Asset, $8.25M NOI, 60%@6% Sen + 15%@12% Mezz) | Formula | Verified Output |
|---|---|---|
| Combined Loan-to-Value (CLTV) | ltv_sen + ltv_mez | 0.7500 (75.00% Leverage) |
| Blended Debt Interest Rate | (ltv_sen*r_sen + ltv_mez*r_mez) / CLTV | 0.0720 (7.20% Blended) |
| Combined IO Debt Service Coverage | NOI / (V_prop * (ltv_sen*r_sen + ltv_mez*r_mez)) | 1.5278x DSCR |
| Sponsor Cash-on-Cash Yield | (NOI - Total_Interest) / ((1 - CLTV) * V_prop) | 0.1140 (11.40%; 14.10% @ 7.5% Mezz) |
Blended Debt Coupon & Combined IO DSCR Formula
Validate V_prop > 0, NOI > 0, ltv_sen > 0, ltv_mez >= 0, ltv_sen + ltv_mez < 1, and r_sen, r_mez > 0!
=LET(vl_p, B2, no_i, B3, lv_s, B4, rt_s, B5, lv_m, B6, rt_m, B7, cl_v, lv_s + lv_m, IF(OR(vl_p <= 0, no_i <= 0, lv_s <= 0, lv_m < 0, cl_v >= 1, rt_s <= 0, rt_m < 0), "Invalid Capital Stack", ROUND(no_i / (vl_p * (lv_s * rt_s + lv_m * rt_m)), 4)))Levered Sponsor Cash-on-Cash Equity Yield Formula
Always compare marginal mezzanine coupon r_mez directly against Asset Cap Rate NOI / V_prop—not against Blended Debt Rate r_blend!
=LET(vl_p, B2, no_i, B3, lv_s, B4, rt_s, B5, lv_m, B6, rt_m, B7, cl_v, lv_s + lv_m, IF(ISTEXT(E4), E4, ROUND((no_i - vl_p * (lv_s * rt_s + lv_m * rt_m)) / (vl_p * (1 - cl_v)), 4)))Try the example
Use the original values or change them to test your understanding.