What Is a 5% Vacancy Rate

Retail is slightly better than Office. The opposite of the Vacancy Rate is the Occupancy Rate. 5% vacancy rate means 95% occupancy rate.

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.

How is vacancy loss calculated?

1. Take the total rent lost during the vacancy period.
2. Divide that by the total potential rent that could be collected in a year.