Special offer

Absorption Rates Explained With Chart Example

By
Real Estate Agent with Inactive INACTIVE HI Lic# RB-20941

What is this "Absorption Rate" thing anyway and how can I make sense of the data for my clients?  Read on...

Recent blogs on absorption rate prompted me to share my own experience with this market parameter.  Absorption rate can best be thought of as the number of months it would take to sell all existing inventory based on current monthly rate of sales.  If no new listings were to come on the market, that is how many months would be required before the inventory was depleted.  I was introduced to absorption rate by a short but terrific article in the July 17, 2006 issue of Business Week entitled "Tips for Selling in a Changing Market" written by Chris Palmeri.  Of special value in that article was the author's characterization of bounds as "fine", "okay", "troublesome", and "not pretty".  It's always better to quote an outside authority than to try to characterize such things yourself.  I researched the Kauai market via our multiple list service and then created a column chart with color bands to show what was healthy and what was not (see the illustration below).  The color bands allow immediate interpretation as to health of each region of Kauai without struggling with exactly what the term absorption rate means.  In my case, I decided to show single family residential and condominiums separately.  One could also show it by price bands or whatever parameter you deem important.

Hope this is helpful in understanding absorption rate and how to make the data meaningful.  Let me know if you need tips on how to create the color bands in an Excel chart.

Absorption Rate Chart (right click and select

Special thanks to Sandi Bauman who got me thinking about this earlier today.

Visit www.KauaiRocks.com for Hawaii real estate information

Richard Dolbeare, REALTOR-ASSOCIATE

Richard Dolbeare
REALTOR-ASSOCIATE®
Accredited Buyer Representative & e-PRO
Century 21 All Islands, the #1 brokerage on Kauai
(808) 651-4550
(866) 757-8239 (FAX)
Posted by

Richard T. Dolbeare, R(B) photo

Richard Dolbeare, R(B), HI LIc. # RB-20941
Hawaii multi-island specialist for Maui & Kauai with eXp Realty
Property owner on both Maui & Kauai
(808) 651-4550 | Aloha@eXp808.com
MauiSandCastles.comKauaiRocks.com

Linked-in logo  Google+ Twitter icon Facebook logo Youtube logo

 

eXp Realty is a nationwide cloud-based brokerage licensed in Hawaii as follows:

eXp Realty, Lic. # RB-21841, 500 Ala Moana Blvd., #7-400, Honolulu, HI 96813

Comments(12)

Bob Carney
Taylor-Made Deep Creek Vacations & Sales - Mc Henry, MD
Licensed MD/PA Real Estate Agent
That's purdy!!!  And pretty educational!  Nice presentation of the local facts. 
Jul 05, 2007 07:02 PM
Randy L. Prothero
eXp Realty - Hollister, MO
Missouri REALTOR, (808) 384-5645
When taking listings I go over the absorption rates with my clients.  They need to know what kind of market they are in, good or bad.
Jul 05, 2007 09:45 PM
Cindy Jones
Integrity Real Estate Group - Woodbridge, VA
Pentagon, Fort Belvoir & Quantico Real Estate News
I learned about absorption rates in a CRS class and have been using them in listing presentations every since.  Your chart is great! 
Jul 05, 2007 11:40 PM
Sandi Bauman
Chico Homes Real Estate - Chico, CA
Chico CA Realtor
Hi Richard--  Great explanation!!  I'm really anxious to see your chart...  I'm sure that it goes a long way towards understanding the idea... but it's not coming up on my computer??  I just have a box and red X.
Jul 06, 2007 05:18 AM
Sandi Bauman
Chico Homes Real Estate - Chico, CA
Chico CA Realtor
Richard--  I came back to visit again, and presto!!  there was the chart.  Very impressive work- I never could have pulled it off  :)  Nice job.
Jul 06, 2007 05:22 AM
Richard Dolbeare
Inactive - Wailuku, HI
Living the Hawaii Lifestyle

Hi Sandi.  The chart is there but sometimes you must right click the X and then select "Show Picture".  The reload button may work too.  Don't know what causes this little annoyance.  Let me know what you think of the chart.

Mahalo and aloha,

Richard

Jul 06, 2007 05:22 AM
Marlene Bridges
Village Real Estate Services, Inc. - Laguna Hills, CA
Laguna Homes|Laguna Condos|Laguna Real Estate
Richard - What a great graphic representation of your market.  And, what a great tool to take along on a listing appointment.  I'll bet you work with a lot of professionals who appreciate your very practical way of visually presenting the facts.  Another great job!
Jul 06, 2007 03:41 PM
Richard Dolbeare
Inactive - Wailuku, HI
Living the Hawaii Lifestyle

Marlene--Uhoh, I think my former engineering career is showing <grin>.  Yes I love charts and many of the people I work with are professionals who share the interest in graphical representations of data. 

Jul 07, 2007 08:45 AM
This is not an active account
no company affiliation - International, IT

I've used the absorption rate when speaking to potential clients....but  I LOVE the visual you've created!  Thanks so much for sharing this terrific tool!

Jul 09, 2007 08:43 AM
Joseph "Joe" Peters
Coldwell Banker - Warren, NJ
Helping you to achieve your Goals and Dreams
Great presentation on this subject.

I use these statisticcs with both buyers and sellers.

Se my post at: http://activerain.com/blogs/jpeters
Apr 04, 2008 10:05 AM
Anonymous
Maggie

great graph! Can you give me some tips on how to create it in an Excel? I would like to include it into my appraisal report. Thank you very much.

Dec 09, 2008 11:51 AM
#11
Richard Dolbeare
Inactive - Wailuku, HI
Living the Hawaii Lifestyle

Hi Maggie,

Thanks for your comments.  I'm flagged your request and will do my best to post an overview real soon.

Aloha & best wishes,  Richard

Dec 10, 2008 05:15 AM