A storage facility's monthly revenue is rented units times what they rent for. Multiply the two for each unit size and you have the income line every operator tracks.
40 units rented at an average $95 brings in $3,800 a month from that size class.
The example
Three unit sizes with the count rented and their average rate.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Unit size | Units rented | Avg rate | Monthly revenue |
| 2 | 10x10 | 40 | $95 | $3,800 |
| 3 | 5x10 | 60 | $65 | $3,900 |
| 4 | 10x20 | 18 | $150 | $2,700 |
The formula
One multiplication per size class:
How it works
Revenue is rented inventory valued at its rate:
B2is the number of units of that size currently rented.C2is the average monthly rate those units rent for.- Multiplying gives the monthly revenue from that size; sum the column for total facility revenue.
Compare to gross potential rent (all units times rate) to see how much vacancy is costing you.
Try it: interactive demo
Enter rented units and the average monthly rate.
Variations
Total facility revenue
Sum the revenue across every size class.
Gross potential rent
Value every unit, rented or not, to gauge vacancy loss.
Pitfalls & errors
Use rented units, not total units, for actual revenue. Total units times rate is potential, not realized, income.
Promotional first-month rates skew the average — use the in-place average rate, not the sign-up special.
Practice workbook
Frequently asked questions
How do I get total facility revenue?
What is gross potential rent?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class