Industrial Logistics REITs, Cold-Chain Warehousing & Unit Economics
Cold-Storage REIT Pallet Rent, Handling Turns & NOI Formula
Calculate Cold-Storage Warehouse REIT Annual Pallet Storage Revenue ($M), Throughput Handling & Blast-Freezing Revenue ($M), Dual-Segment Facility NOI ($M), and Blended NOI Margin (%).
Model cold storage as high-margin pallet rent (~75%) PLUS labor-heavy throughput services (~25%)!
Temperature-controlled -20°F cold-storage REITs earn two structurally different revenue streams inside the same insulated box: (1) Pallet-Position Storage Rent = Total_Pallets * Economic_Occupancy * Monthly_Storage_Rate * 12, which carries ~70%–80% segment NOI margin (after ammonia refrigeration kWh), and (2) Warehouse Handling, Case-Picking & Blast-Freezing Services = Occupied_Pallets * Annual_Inventory_Turns * Handling_Fee_Per_Turn, which carries only ~20%–30% segment margin due to freezer-suit forklift labor! Applying a single blended dry-warehouse margin mismodels throughput slowdowns.
Verify on a 40,000-Pallet Automated Cold-Storage Facility—Total_Pallet_Positions = 40,000 (B2), Economic_Occupancy = 0.85 (34,000 occupied pallets, B3), Monthly_Storage_Rate = $25.00/pallet/mo (B4 -> Storage Revenue = $10.20M in E2), Annual_Pallet_Turns = 10.0x/yr (340,000 turns, B5), Handling_And_Blast_Fee = $28.00/turn (B6 -> Services Revenue = $9.52M in E3), and Storage_Margin = 0.75 vs 25.0% Services Margin (B7): Total Facility NOI equals 10.20 * 0.75 + 9.52 * 0.25 = 7.65 + 2.38 = $10.03M (E4), yielding a 50.86% Blended NOI Margin (E5)!
| Cold-Storage REIT KPI (40k Pallets @ 85% Occ, $25/mo, 10x Turns @ $28/turn) | Formula | Verified Output |
|---|---|---|
| Annual Storage Rent Revenue ($M) | Pallets * Occ * Storage_Mo * 12 / 10^6 | $10.20M |
| Throughput Services Revenue ($M) | Pallets * Occ * Annual_Turns * Fee_Turn / 10^6 | $9.52M ($5.71M @ 6x Turns) |
| Combined Facility NOI ($M) | Storage_Rev * Stg_Mgn + Services_Rev * 0.25 | $10.03M ($9.08M @ 6x Turns) |
| Blended Facility NOI Margin (%) | (Combined_NOI_M / Total_Revenue_M) * 100 | 50.86% (57.05% @ 6x Turns) |
Dual-Segment Cold-Storage NOI & Blended Margin Formula
Validate Pallets > 0, Occupancy in (0, 1], Storage_Rate > 0, Turns >= 0, Handling_Fee >= 0, and Storage_Margin in (0.30, 0.95]!
=LET(pl_t, B2, oc_e, B3, st_m, B4, tr_n, B5, hn_f, B6, mg_s, B7, IF(OR(pl_t <= 0, oc_e <= 0, oc_e > 1, st_m <= 0, tr_n < 0, hn_f < 0, mg_s <= 0.3, mg_s > 0.95), "Invalid Cold Storage Input", LET(rv_s, pl_t * oc_e * st_m * 12 / 1000000, rv_h, pl_t * oc_e * tr_n * hn_f / 1000000, ROUND(rv_s * mg_s + rv_h * 0.25, 2))))Slower Inventory-Turn Mix-Shift Check (Set Annual Pallet Turns = 6.0x)
Slow Annual_Pallet_Turns B5 from 10.0x to 6.0x (frozen protein stockpiling with fewer outbound shipments): Services Revenue E3 drops from $9.52M to $5.71M, Combined NOI E4 dips slightly from $10.03M to $9.08M, while Blended NOI Margin E5 RISES from 50.86% to 57.05% due to higher storage mix!
=IF(ISTEXT(E4), E4, LET(rv_s, B2 * B3 * B4 * 12 / 1000000, rv_h, B2 * B3 * B5 * B6 / 1000000, no_i, rv_s * B7 + rv_h * 0.25, ROUND((no_i / (rv_s + rv_h)) * 100, 2)))Try the example
Use the original values or change them to test your understanding.