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

Absorption Rate

Step-by-Step Guide to Understanding Absorption Rate in Commercial Real Estate (CRE)

Last Updated February 20, 2024

Learn Online Now

Absorption Rate

How the Absorption Rate Works in Commercial Real Estate

In commercial real estate (CRE), the absorption rate is an indicator of market demand that is closely tracked by practitioners, namely to forecast future trends of a specific sector or on a macro level.

Based on the current absorption rate of a real estate market (or submarket) – such as the commercial office, retail, and industrial sectors – CRE investors can derive useful insights pertaining to the current level of liquidity and supply-and-demand dynamics.

Therefore, the absorption rate is a closely tracked indicator that serves as a proxy for the market conditions in the real estate sector at a given point in time.

From the perspective of real estate investors, the current supply-and-demand dynamics and liquidity in a specific real estate market are instrumental factors in determining whether they will meet their targeted return (“hurdle rate”) on a given property investment.

This reasoning is tied to the inherent cyclicality of the commercial real estate (CRE) market, which causes the timing of the date of purchase and sale to be two of the core drivers of returns.

That said, real estate investors are incentivized to purchase when asking prices are compressed and sell (i.e. “exit”) at peak valuations – albeit, timing the market is easier said than done.


Real Estate Technical 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.


Buyer’s Market vs. Seller’s Market: What is the Difference?

A real estate market can be designated as either a buyer’s market, seller’s market, or balanced market:

  • Buyer’s Market → The supply outpaces demand in a buyer’s market, which is favorable to buyers since the asking prices of properties available for sale are most often compressed.
  • Seller’s Market → The demand exceeds supply in a seller’s market, meaning that the number of buyers in the market actively looking to purchase properties exceeds the quantity of properties listed for sale.
  • Balanced Market → The market is in a state of equilibrium concerning supply and demand, favoring neither the buyers nor sellers.

Therefore, the absorption rate is higher from the expansion in demand in a seller’s market, and vice versa in a buyer’s market.

The factors that influence absorption rates are frequently specific to the location, sector, and property type.

But the prevailing economic conditions and interest rate environment can also impact absorption rates.

For instance, the interest rate hikes by the Fed to fend off inflation post-COVID caused net absorptions to decline across all sectors, with the effects persisting into 2024.

The commercial sector remained most stable, with the office space sector struggling to recover from the shift toward work-from-home (WFM) and hybrid models.

Net Absorption Rate in 2023

Absorptions Data – Real Estate Market Insights (Source: Aprio Insights)

Positive vs. Negative Absorption Rate: What is the Difference?

In practice, the absorption rate is described as either positive or negative.

  • Positive Absorption Rate → A positive absorption rate implies an increase in the occupancy rates, or that more square footage of space is occupied relative to the amount of space vacated and that is now available to be leased in a set time period.
  • Negative Absorption Rate → In contrast, a negative absorption rate is indicative of a decline in occupancy rates, in which more square footage is vacated by tenants compared to the amount occupied by new tenants.

The periods with high positive net absorption rates tend to correspond to a widespread increase in property prices, often attracting more real estate investors like property developers to enter the market (i.e. outsized tenant demand, increased rental rates).

However, the decision to invest based solely on these types of trends by themselves is not a viable investment strategy, especially for property development, as the trend could be short-term (and the market direction can easily pivot).

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 Sep. 9 - Nov. 10 Wharton Certificate Program cohort.

Enroll Today

How to Calculate Absorption Rate

The net absorption is the difference between the amount of space that has been leased (or “occupied”) and the amount of space that has been vacated (or “unoccupied”) across a specific time period.

The net absorption metric reflects the net change in demand relative to supply, contrary to its counterpart, the gross absorption.

The gross absorption measures the total new square footage (sq. ft.) leased by tenants in a given period, without adjusting for vacant units.

The available space is the total amount of space – in square footage (sq. ft.) to ensure consistency – currently marketed to potential buyers as available for lease at the start of the period.

The two core components of the ratio – net absorption and the initial available space – are each denoted in square footage (sq. ft).

Absorption Rate Formula

The formula to calculate the absorption rate is the ratio between net absorption and the initial available space, expressed as a percentage.

Absorption Rate (%) = Net Absorption ÷ Initial Available Space


  • Net Absorption = Total Space Leased – Vacated Space – New Space
  • Initial Available Space = Σ Total Space Marketed as Available for Lease

Absorption Rate Calculator

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


Excel Template | 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.


Absorption Rate Calculation Example

Suppose we’re tasked with calculating the absorption rate for a commercial building with 16 units in total.

For illustrative purposes, we’ll assume the size of each unit is 1k sq. ft., so the total available space is 16k.

  • Square Footage per Unit = 1,000 sq. ft.
  • Total Units = 16 Units
  • Total Available Space = 1,000 sq. ft. × 16 Units = 16,000 sq. ft.

At the start of 2024, four units were vacant and unoccupied by a tenant. Therefore, the initial vacancy rate was 25.0%.

  • Initial Vacant Units = 4 Units
  • Initial Vacancy Rate (%) = 4 Vacant Units ÷ 16 Total Units = 25.0%

Two tenants signed a lease and moved into the building in 2024.

Given that assumption, we can calculate the ending vacancy rate, or 12.5%

  • Ending Vacancy Rate (%) = 2 Vacant Units ÷ 16 Total Units = 12.5%

In conclusion, the net absorption rate is 50% for the annual period, which we determined by dividing the net absorption (i.e. the change in available space) by the initial available space.

  • Absorption Rate = 2,000 sq. ft. ÷ 4,000 sq. ft. = 50.0% 

Net Absorption Rate Calculator

Inline Feedbacks
View all comments

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.