Retail Real Estate & Lease Accounting
Retail Percentage Lease & Natural Breakpoint Formula
Calculate shopping-center Natural Breakpoint = Base_Rent / Pct_Rate, Overage Rent = Pct_Rate * MAX(0, Sales - Breakpoint), and Effective Occupancy-Cost-to-Sales Ratio.
Master Natural vs Artificial Breakpoints in retail shopping-center percentage leases!
Retail, restaurant, and airport-concession leases align landlord foot-traffic incentives with tenant turnover by combining guaranteed Minimum Base Rent R_base with Percentage Overage Rent p_ovg * MAX(0, Gross_Sales - Breakpoint)! Unless an Artificial Breakpoint is negotiated explicitly, leases default to the Natural Breakpoint BP_nat = R_base / p_ovg — the exact sales level where p_ovg * BP_nat = R_base, guaranteeing that once Gross_Sales >= BP_nat, Total Rent / Gross_Sales equals exact p_ovg!
Check by hand with Annual_Base_Rent = 180,000 (B2), Overage_Rate_p = 0.06 (B3 = 6.0%), Tenant_Gross_Sales = 3,500,000 (B4), and Custom_Artificial_BP = 0 (B5 = use Natural Breakpoint): Natural Breakpoint is 180,000 / 0.06 = 3,000,000.00, Overage Rent on the 500,000 excess sales is 0.06 * 500,000 = 30,000.00, Total Rent is 210,000.00, and Occupancy Cost Ratio is 210,000 / 3,500,000 = 0.0600 (exact 6.00%!)! Now test negotiating an Artificial Breakpoint B5 = 3,200,000: Overage Rent drops to 18,000.00 and Total Rent falls to 198,000.00!
| Retail Lease Metric (Base=180k, p=6%, Sales=3.5M) | Formula | Verified Output |
|---|---|---|
| Natural Sales Breakpoint (BP_nat) | Base_Rent / Pct_Rate | 3,000,000.00 |
| Percentage Overage Rent (Natural BP) | 0.06 * MAX(0, 3.5M - 3.0M) | 30,000.00 |
| Total Annual Rent (Base + Overage) | Base_Rent + Overage_Rent | 210,000.00 (6.00% of Sales!) |
| Negotiated Artificial BP (3,200,000) | 180k + 0.06 * MAX(0, 3.5M - 3.2M) | 198,000.00 (5.66% of Sales) |
Natural vs Artificial Breakpoint Overage Rent Formula
Use IF(B5 > 0, B5, B2 / B3) so lease analysts can toggle seamlessly between Natural Breakpoint (B5 = 0) and any negotiated Artificial Breakpoint (B5 > 0).
=LET(r_bs, B2, p_ov, B3, sl_g, B4, bp_c, B5, IF(OR(r_bs <= 0, p_ov <= 0, p_ov >= 1, sl_g < 0, bp_c < 0), "Invalid Lease Input", LET(bp_ef, IF(bp_c > 0, bp_c, r_bs / p_ov), ROUND(p_ov * MAX(0, sl_g - bp_ef), 2))))Total Annual Retail Rent (Base + Overage) Formula
Test slow-season sales B4 = 2,500,000 (< 3,000,000 breakpoint): MAX(0, ...) floors overage at 0.00 so Total Rent equals Base Rent 180,000.00.
=IF(ISTEXT(E3), E3, ROUND(B2 + E3, 2))Try the example
Use the original values or change them to test your understanding.