background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Vacancy Loss

Step-by-Step Guide to Understanding Vacancy Loss

Last Updated August 21, 2024

Learn Online Now

Join 750k+ Learners Today

Vacancy Loss

How to Calculate Vacancy Loss

The vacancy loss refers to the rental income lost because of unoccupied units, where there are no tenants.

While there is a negative connotation, the vacancy loss metric can also be viewed as representing the potential rental income that could be earned in the future.

The process of calculating the real estate metric involves multiplying the vacancy assumption by the gross potential income generated by the property, i.e., the rental income if all units were occupied.

The resulting amount is the rental income lost by the unoccupied units.

When projecting the anticipated loss, assumptions are necessary regarding the conditions of the real estate market, tenant demand, property conditions (i.e., number of available space vs. unavailable space due to construction), and retention of existing tenants.

For property owners striving to reduce their vacancy loss, the following measures can be taken:

  • Offer Incentives, e.g., Free Months
  • Reduction to Rent, i.e., Net Effective Rent < Gross Rent
  • Interior Improvements and Renovations
  • Marketing and Advertising Campaigns
dl

Real Estate Interview Guide | File Download Form

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Vacancy Loss Formula

The formula for calculating vacancy loss is equal to the gross scheduled income (GSI) multiplied by the vacancy rate.

Vacancy Loss = Gross Scheduled Income (GSI) × Vacancy Rate

Where:

  • Gross Scheduled Income (GSI) → The gross scheduled income is the total amount of potential rental income that could be generated by commercial property, assuming the property is at full capacity, i.e., 100% occupancy.
  • Vacancy Rate → The vacancy rate is the implied percentage of unoccupied units, and can be computed as one minus the occupancy rate.

The Wharton Online
and Wall Street Prep Real Estate Investing & Analysis Certificate Program

Level up your real estate investing career. Enrollment is open for the Feb. 10 - Apr. 6 Wharton Certificate Program cohort.

Enroll Today

Vacancy Loss Calculator — Excel Template

We’ll now move to a modeling exercise, which you can access by filling out the form below.

dl

Excel Template

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.

Submitting...

Vacancy Loss Calculation Example

Suppose the property manager of a residential building is attempting to determine the expected vacancy loss in anticipation of the upcoming year, 2023.

The residential building has 100 units available for rent in total, with each unit priced at the same monthly rate of $4,000.

While an unrealistic scenario – for purposes of this exercise – we’ll assume that all rental lease commitments are on a 12-month basis.

  • Number of Units = 100
  • Rental Cost Per Month = $4,000
  • Lease Term = 12 Months

Given those assumptions, we can calculate the gross scheduled income (GSI) by multiplying all three assumptions.

  • Gross Scheduled Income (GSI) = 100 × $4,000 × 12 Months = $4,800,000

The $4.8 million represents the total potential rental income assuming 100% occupancy, as well as no concessions or discounts that affect the net effective rent paid by tenants.

Next, we’ll assume that the occupancy rate as of the present date is 95%, meaning that 95 units have an existing tenant that has signed a lease and will be obligated to pay rent each month.

The vacancy rate equals one minus the occupancy rate, so the vacancy rate is 5.0%.

  • Occupancy Rate = 95%
  • Vacancy Rate = 1 – 95% = 5.0%
  • Occupied Units = 95 Units
  • Unoccupied Units = 5 Units

By multiplying the gross scheduled income (GSI) by the vacancy rate, we arrive at a vacancy loss of $240,000, which represents the rental income expected to be lost in 2023 unless those unoccupied units are filled.

  • Vacancy Loss = $4,800,000 × 5.0% = $240,000

Vacancy Loss Calculator


The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.