Gregg Fous Perspectives in Real Estate


What is IRR? Spreadsheet for APOD and IRR Here.

Ok. Let's talk IRR - Internal rates of return - on a real estate investment. I have previously covered CAP rate.  (Click Here) You might want to start by reviewing that post.

When I first started buying rental properties here in Fort Myers, Florida, I never used CAP rates to compare properties. I did not trust the numbers that were given to me and quite frankly had never been taught CAP rates.   Instead, I evaluated every property I bought on a spread sheet.  Into this excel spreadsheet I plugged all my variables:  Purchase price, down payment, interest rates, terms, expected capital improvements, and other items like vacancy and credit loss.  I would then have a number of spread sheets and make "what if?" scenarios.

On the same sheet I put an expected appreciation rate and my anticipated tax rate.  (I forecast when I was going to sell the asset and at what price).  What I was building, without really knowing what it was called, was an internal rate of return analysis.  I wanted to know that the annual return was on my investment after I had cashed out of it, in say, five years at an annual appreciation of say 5% on the asset.

An internal rate of return is called internal, because it ignores how you might invest periodic cash flow once it is out of the investment. It only looks at return that is internal to the investment.

CAP rates tell you what the annual rate of return is on an investment while you own it ( ignoring debt); The IRR will tell me what the return is on the total investment when you are out, in present value terms.

The IRR evaluates a series of cash flow streams.  The first year there is an outlay. This is the year you buy the project. Every economic period there after (Months or Years) there is either an income or a loss. The final year, when you sell the property, you also have an income ( or, God forbid, a loss).  IRR takes into account all of these cash flow streams (both positive and negative)  and puts a present value on it.  IRR's are best calculated in a spread sheet or a financial calculator. Here is a link to a good primer on the subject: ( Click Here).   I use the Gary Tharp,  CCIM prepared APOD  ( Annual Property Operating Data) that includes an IRR calculation for my commercial investments.  I always prepare one of these for my clients for every potential investment.  (Gary Tharp has made it available for use HERE)

What does all this mean?  An investment with an 11% CAP rate and 9% cash on cash is good, but if, at the end of your ownership period, you cannot sell this property because of functional obsolescence, (A restaurant that is outdated, for example, or better yet, a dirt mine that is depleted)   then your IRR will be lower  (Your cash flow stream will be functionally zero at the end).  On the other hand if you have a decent cap rate and great appreciation and are able to sell and get a goodly bump on cash flow the last year - then your IRR well be excellent.

Cape rates are good. IRR is better. Learn to use both.


Gregg Fous

Fort Myers, Florida Real Estate Broker


Comment balloon 10 commentsGregg Fous • July 30 2008 09:09PM
What is IRR? Spreadsheet for APOD and IRR Here.
Ok. Let's talk IRR - Internal rates of return - on a real estate investment. I have previously covered CAP rate. ( Click Here ) You might want to start by reviewing that post. When I first started buying rental properties here in Fort Myers,… more
My 10 Predictions for the Next Twelve Months -Fort Myers/Cape Coral
I recently have joined a Web-2 blogging and networking web site called ActiveRain On ActiveRain many Realtors post their Blogs. When looking at the number of hits that the leading Bogs get and the blogs that are most commented on; I noticed… more
13 points about Analysis Paralysis in Real Estate
Paralysis by Analysis in Real Estate I am sure that all of you have heard term "Analysis Paralysis" and even seen or experienced the phenomenon yourself. Whatever the decision that needs to be made, it is forestalled and in… more
Learn from the fable - Cottage by the Sea
COTTAGE BY THE SEA There was a successful workaholic industrialist on his first vacation in many years sitting on his balcony at his hotel on the beautiful coast of Costa Rica. It was about 10:30 in the morning and he was working on his… more
Top Ten Negotiating Techniques
Ten (or so) Negotiating Techniques - Some Comments I have been in sales almost all my life. When I was eight years old I went door to door with a wagon and sold pachysandra plants that I grew from cuttings from my parent's yard. I… more
Brick Walls in Real Estate - Ten Reasons they are there.
Brick Walls are there for a Reason - Earlier this summer I traveled to Tampa for a meeting with the other franchise owners for Engel and Voelkers. We all had dinner just down the street from the Tampa Engel and Voelkers Shop. It was motivational… more
Step to a Goal, Not a tune
Sometimes we think we are stepping towards a goal - but we are just dancing to a tune. I was sitting in a crowded doctor's waiting room on Monday. There was not a seat to be had. I was sitting with my back to the wall, facing the receptionist… more
The Informational Salesman
The Informational Salesman I have been shopping for a car lately. What an education! And I don't mean about cars, I mean about car salesmen. It certainly is not easy finding a knowledgeable salesman; a salesman that knows his product as well… more
Find Your Own Cat Pee
Find Your Own Cat Pee Years ago, when I first started looking for homes to renovate and either rent out or resell, I would tell my agent to find me homes that had cat pee on the carpet. You see, I liked homes that smelled bad, were closed up… more
What is the "Right" Price on Commercial Properties? CAP…
Last week one of my clients told me that he would like to raise some cash to pay his impending federal tax bill. He owns quite a few properties - most are income producing, some land, some warehouses, some offices - and all very marketable. This… more