How Do You Calculate Vacancy Rate

The rate is calculated by taking the number of vacant units, multiplying that number by 100, and dividing that result by the total number of units. The vacancy rate and occupancy rate should add up to 100%. So if an apartment building has 300 units, and 30 units are unoccupied, it means the vacancy rate is 10%.

What is considered a good vacancy rate?

As a general rule, though, five to eight percent vacancy is an average. … When vacancy rates drop below five percent the increased demand and reduced supply allow rental rates to rise faster. If your property or area has a vacancy rate of below 5 percent, the rental market is good for landlords and rents will go up.

How do I calculate vacancy in Excel?

To express this in excel we can divide the total number of available rooms in B1 , against each of the days in the spreadsheet. For example, to calculate the first day’s occupancy rate we can do =B4/$B$1 : N.B. We type $B$4 instead of just B4 because we want to keep the second cell reference in the function static.