Real Estate Operations, Self-Storage REITs & Revenue Management
Self-Storage Economic Occupancy & ECRI Rent-Roll Formula
Calculate Self-Storage REIT Move-In Concession & Bad-Debt Drag ($k), Existing Customer Rate Increase (ECRI) Lift ($k), Net Collected Rental Revenue ($k), and Economic Occupancy (%).
Separate physical square-foot occupancy from economic occupancy after web move-in promos and ECRI!
Self-storage operators routinely advertise aggressive "$1 first month" or "30% off web street rate" move-in concessions to fill vacant units, creating a wide gap between Physical Square-Foot Occupancy (Occupied_SF / Net_Rentable_SF) and Economic Occupancy (Net_Collected_Rent / Gross_Potential_Rent_at_Street_Rate). Operators bridge that gap through Existing Customer Rate Increases (ECRI)—programmatic 10%–15% rate increases sent to tenured customers after 6–9 months in place! If an acquisitions analyst models Physical Occupancy * Street_Rate without separating Concession/Bad-Debt Drag from ECRI Lift, year-1 lease-up revenue will be severely overstated.
Verify on an 80,000 NRSF Climate-Controlled Facility—Net_Rentable_SqFt = 80,000 SF (B2) at Street_Potential_Rent = $20.00/SF/yr ($1,600.00k Gross Potential Rent, B3), Physical_Occupancy = 0.90 (90.0% -> $1,440.00k occupied street base, B4), Concession_And_BadDebt_Drag = 0.08 (8.0% of occupied base = $115.20k loss in E2, B5), and ECRI applied to B6 = 0.50 (50.0% tenured share) at B7 = 0.12 (+12.0% rate lift -> $86.40k lift in E3): Net Collected Rent is 1,440.00 - 115.20 + 86.40 = $1,411.20k (E4), yielding 88.20% Economic Occupancy (E5 vs 90.00% Physical Occupancy)!
| Self-Storage Revenue KPI (80k SF @ $20/SF, 90% Phys Occ, 8% Drag, 50%x12% ECRI) | Formula | Verified Output |
|---|---|---|
| Concession & Bad-Debt Drag ($k) | GPR_k * Phys_Occ * Concession_BadDebt_Pct | $115.20k |
| Annual ECRI Rent-Roll Lift ($k) | GPR_k * Phys_Occ * ECRI_Share * ECRI_Lift | $86.40k ($0.00k Lease-Up) |
| Net Collected Rental Revenue ($k) | Occupied_Base_k - Drag_k + ECRI_Lift_k | $1,411.20k ($1,324.80k No ECRI) |
| Economic Occupancy (%) | (Net_Collected_Rent_k / Street_GPR_k) * 100 | 88.20% (82.80% No ECRI) |
Self-Storage Economic Occupancy & ECRI Revenue Formula
Validate NRSF > 0, Street_Rent > 0, Physical_Occupancy in (0, 1], Concession_Drag in [0, 0.50), ECRI_Eligible_Share in [0, 1], and ECRI_Lift in [0, 0.50]!
=LET(sf_n, B2, st_r, B3, oc_p, B4, dr_p, B5, ec_s, B6, ec_l, B7, IF(OR(sf_n <= 0, st_r <= 0, oc_p <= 0, oc_p > 1, dr_p < 0, dr_p >= 0.5, ec_s < 0, ec_s > 1, ec_l < 0, ec_l > 0.5), "Invalid Storage Rent Input", LET(gp_k, sf_n * st_r / 1000, ob_k, gp_k * oc_p, nt_k, ob_k * (1 - dr_p + ec_s * ec_l), ROUND((nt_k / gp_k) * 100, 2))))Unseasoned Lease-Up Check Without ECRI Power (Set ECRI Rate Lift = 0%)
Set ECRI_Rate_Lift B7 to 0.00 (a newly opened facility whose tenants have < 6 months tenure): ECRI Lift E3 drops to $0.00k, Net Collected Rent E4 falls to $1,324.80k, and Economic Occupancy E5 drops to 82.80%—a full 720 bps below the 90.00% Physical Occupancy headline!
=IF(ISTEXT(E5), E5, ROUND((B2 * B3 / 1000) * B4 * (1 - B5 + B6 * B7), 2))Try the example
Use the original values or change them to test your understanding.