Corporate Finance, Net-Lease Real Estate & Sale-Leaseback Structuring
Corporate Sale-Leaseback Debt-Paydown Arbitrage Formula
Calculate Industrial / Retail Sale-Leaseback Gross Valuation Proceeds (NNN Rent / Cap Rate), Net After-Tax Debt Paydown After Capital-Gain Tax on Low-Basis Real Estate, Annual Interest Saved, and Pre-Tax Annual Cash-Flow Accretion / Dilution ($M).
Account for low-basis capital-gain tax leakage before claiming sale-leaseback debt arbitrage!
Private-equity portfolio companies and industrial operators often monetize owned warehouses or stores via a Triple-Net (NNN) Sale-Leaseback: selling the property at Gross_Proceeds = Initial_NNN_Rent / Cap_Rate and using the proceeds to retire high-coupon term debt! The hidden trap is depreciated tax basis: if long-held real estate sits at a low Property_Tax_Basis, corporate tax on the gain (MAX(0, Gross_Proceeds - Tax_Basis) * Gain_Tax_Rate) shrinks Net_Debt_Paydown = Gross_Proceeds - Tax_Leakage! Consequently, Annual Pre-Tax Cash-Flow Delta = (Net_Debt_Paydown * Retired_Debt_Interest_Rate) - Initial_NNN_Rent is positive ONLY when the retired debt coupon exceeds Cap_Rate / (1 - Effective_Proceeds_Tax_Drag)!
Verify on a Manufacturing Distribution Center Sale-Leaseback—Initial_Annual_NNN_Rent = $6.00M/yr (B2), Net_Lease_Cap_Rate = 0.075 (7.50%, B3 -> Gross Sale Proceeds = 6.00 / 0.075 = $80.00M in E2), Depreciated_Tax_Basis = $32.00M (B4 -> $48.00M taxable gain), Corporate_Gain_Tax_Rate = 0.25 (25.0% -> $12.00M tax leakage, leaving Net Debt Paydown = $68.00M in E3, B5), and Retired_LBO_Term_Loan_Rate = 0.095 (9.50%, B6): Annual Interest Saved is 68.00 * 0.095 = $6.46M/yr (E4), generating +$0.46M/yr of net pre-tax cash-flow accretion over the $6.00M rent (E5)!
| Sale-Leaseback Metric ($6M Rent @ 7.5% Cap, $32M Basis, 25% Tax, 9.5% Debt) | Formula | Verified Output |
|---|---|---|
| Gross Property Sale Proceeds ($M) | Initial_NNN_Rent_M / Cap_Rate | $80.00M |
| Net After-Tax Debt Paydown ($M) | Gross - MAX(0, Gross - Basis) * Tax_Rate | $68.00M ($12.00M Gain Tax) |
| Annual Debt Interest Saved ($M) | Net_Debt_Paydown_M * Retired_Debt_Rate | $6.46M ($4.76M @ 7.0% Debt) |
| Net Pre-Tax Cash Flow Delta ($M) | Annual_Interest_Saved - Initial_NNN_Rent | +$0.46M (-$1.24M @ 7.0% Debt) |
After-Tax Sale-Leaseback Debt-Paydown Cash Arbitrage Formula
Validate Rent > 0, Cap_Rate in (0, 0.25), Tax_Basis >= 0, Tax_Rate in [0, 0.50), and Retired_Debt_Rate > 0!
=LET(rn_m, B2, cp_r, B3, bs_m, B4, tx_r, B5, db_r, B6, IF(OR(rn_m <= 0, cp_r <= 0, cp_r >= 0.25, bs_m < 0, tx_r < 0, tx_r >= 0.5, db_r <= 0), "Invalid Sale-Leaseback Input", LET(gr_p, rn_m / cp_r, nt_p, gr_p - MAX(0, gr_p - bs_m) * tx_r, sv_i, nt_p * db_r, ROUND(sv_i - rn_m, 2))))Investment-Grade Debt Dilution Check (Set Retired Debt Coupon = 7.00%)
Test why investment-grade issuers with 7.00% debt (B6 = 0.07) lose cash flow even at a 7.50% cap rate: because $12.00M of gain tax leaves only $68.00M to pay down debt, Interest Saved E4 drops to $4.76M/yr, creating -$1.24M/yr of annual cash dilution vs $6.00M rent (E5)!
=IF(ISTEXT(E5), E5, ROUND((B2 / B3 - MAX(0, B2 / B3 - B4) * B5) * B6, 2))Try the example
Use the original values or change them to test your understanding.