Commercial Real Estate, Retail Leasing & Store Economics
Retail Percentage Rent, Natural Breakpoint & CAM Formula
Calculate Retail Shopping-Center Natural Sales Breakpoint (Base_Rent / Overage_Pct), Percentage Rent Overage Charge MAX(0, (Sales - Breakpoint)*Pct), Capped Controllable CAM Reconciliation, and Total Occupancy Cost % of Sales.
Anchor retail lease negotiations on Natural Sales Breakpoint and Controllable CAM Caps!
Mall and lifestyle-center retail leases pair Minimum Annual Base Rent with Percentage Rent Overage on tenant gross store sales exceeding a Sales Breakpoint! Unless an artificial breakpoint is negotiated, the Natural Breakpoint equals Annual_Base_Rent / Percentage_Rent_Rate—the exact sales volume where Base Rent equals Overage_Rate * Gross_Sales! Above that threshold, Percentage Rent = MAX(0, (Gross_Sales - Natural_Breakpoint) * Percentage_Rent_Rate). Adding Capped Common Area Maintenance MIN(Actual_ProRata_CAM, Negotiated_CAM_Cap) yields Total Annual Occupancy Cost, which specialty retailers benchmark as Occupancy-to-Sales Ratio = Total_Occupancy / Gross_Sales (targeting <= 8%–12% for healthy four-wall store EBITDA)!
Verify on a Flagship Apparel Lease—Annual_Base_Rent = $180,000 (B2), Percentage_Overage_Rate = 0.06 (6.0%, B3 -> Natural Sales Breakpoint = 180,000 / 0.06 = $3,000,000 in E2), Audited_Store_Gross_Sales = $3,500,000 (B4 -> Percentage Rent = ($3.5M - $3.0M) * 6% = $30,000 in E3), Landlord_Actual_CAM_Share = $45,000 (B5), and Cumulative_CAM_Cap_Ceiling = $42,000 (B6): Capped Total Annual Occupancy is 180,000 + 30,000 + 42,000 = $252,000 (saving $3,000 of excess CAM in E4), representing a healthy 252,000 / 3,500,000 = 0.0720 (7.20% Occupancy-to-Sales Ratio in E5)!
| Retail Lease Metric ($180k Base, 6.0% Overage, $3.5M Sales, $45k CAM vs $42k Cap) | Formula | Verified Output |
|---|---|---|
| Natural Sales Breakpoint ($) | Annual_Base_Rent / Overage_Rate | $3,000,000 |
| Percentage Rent Overage ($) | MAX(0, (Gross_Sales - Breakpoint)*Rate) | $30,000 ($0 @ $2.5M Sales) |
| Total Capped Occupancy Cost ($) | Base + Pct_Rent + MIN(Actual_CAM, Cap) | $252,000 ($222,000 @ $2.5M Sales) |
| Occupancy-to-Sales Ratio | Total_Occupancy_Cost / Gross_Sales | 0.0720 (7.20% Four-Wall Ratio) |
Retail Lease Total Capped Occupancy Cost Formula
Validate Base_Rent > 0, 0 < Overage_Rate < 1, Gross_Sales > 0, and non-negative CAM amounts!
=LET(bs_r, B2, ov_r, B3, sl_g, B4, cm_a, B5, cm_c, B6, IF(OR(bs_r <= 0, ov_r <= 0, ov_r >= 1, sl_g <= 0, cm_a < 0, cm_c < 0), "Invalid Retail Lease Terms", LET(bp_n, bs_r / ov_r, pr_r, MAX(0, (sl_g - bp_n) * ov_r), ROUND(bs_r + pr_r + MIN(cm_a, cm_c), 2))))Sub-Breakpoint Sales Downside Check (Set Gross Sales = $2,500,000)
Simulate a soft traffic year with B4 = $2,500,000 (< $3,000,000 Natural Breakpoint): Percentage Rent E3 drops cleanly to $0, trimming Total Occupancy E4 to $222,000 (8.88% of sales)!
=IF(ISTEXT(E4), E4, ROUND(E4 / B4, 4))Try the example
Use the original values or change them to test your understanding.