@Tandi H.
Hi Tandi,
To go into complete depth with IRR, it will take an entire book!
In fact, there is an entire book! It's called "What Every Real Estate Investor needs to know about Cash Flow..." by Frank Gallinelli
Either case, I put together a very quick spreadsheet (took me 10 minutes) as an example. Please refer to this Spreadsheet:
To do a basic IRR calculation, you will need to project out a bunch of things including:
1) Your Investment: Cells A1 to B7
2) The Mortgage Balance Reduction: Cells A9 to B14
3) The Future Value you will sell the Investment: Cells D1 to E12
4) The Proceeds after the Sale: Cells D14 to E21
5) Your Rents and Expenses and how they will increase throughout the 10 Years: Cells H1 to L2
6) A Chart which will take into account all the above for the next 10 years: Cells G6 to M18.
After totalling up everything, you will get a single number. In the above case, 9% IRR.
You should think of it as putting the Investment in to a Certificate of Deposit, holding it for 10 years at the 9% IRR per year for the 10 years.
The IRR Calculations gives you a fantastic way to calculate ANY type of Investment against each other, including Stocks, Bonds, Real Estate, ANYTHING really.
Once you know all the Cashflows for the entire 10 year target life of the Investment, then you can get an IRR for it.
Now, let's look at a 2nd Scenario with this EXACT spreadsheet, but with different numbers:
We increased the price to $500k, buying in a location that has at least the national appreciation rate. The rent for the property is $3k per month with around a $650 per month total expense, but our mortgage is $2,398 per month, giving us the 1st year at a NEGATIVE cash flow of -578 annually or around a negative $50 per month loss.
If you notice, the IRR calculates 14%... which is much higher than 9% in the first scenario.
Typically, I accept a break even scenario to capture a much higher IRR. I have purchased 8 Multi-Family Brooklyn Properties in 21 years. At least 2 started out negative. All are doing significantly better then even a 14% IRR.
To give you a little bit of what I'm saying in terms of SIMPLE INTEREST CALCULATIONS, in 2004 I bought a property for $880k with approximately 25% down or roughly $250k invested. TODAY, that property is worth over $3 Million. If I sold it today, I will get back around $2.5 Million in Proceeds. If you do the SIMPLE INTEREST Calculation, you get a profit of $2.25 Million for an investment of $225k. The ROI is 900%. If you divided it by 14 years, that's roughly 64% per year for 14 straight years. NOTE, this does not even consider Cash Flow. TODAY, we Cash flow over $3,500 per month but when we started, we barely broke even.
So, without going too much into things, you can see how a basic IRR pro-forma 10 year business plan is put together.
This isn't even close to what the professionals would actually do.
We need to justify every number. For instance, why did we chose a 5% Appreciation rate? Well, it could be that the historic appreciation rate for the city and neighborhood is close to 10% (Brooklyn NYC is actually even higher than 10% for the last 20 years in the neighborhoods I have invested in). So 5% is CONSERVATIVE depending on where you are investing.
We can then look at how the rents and expenses are moving up. A 2.5% increase of market rents in NYC
is WAY TOO CONSERVATIVE while a 3.5% increase in Expenses is somewhat normal.
ANYWAY... I don't want to write a book for this post. I think you get the picture on how comprehensive and sophisticated you have to be in order to put together something like this.
Remember, this is a very simple and basic pro-forma 10 year projection IRR Business Plan. All numbers must be explained and justified.
I won't explain every calculation on this spreadsheet, but I think the reader of this post will get an understanding.
This is what I recommend on EVERY investment. That would also include EVERY TYPE of investment, not just Real Estate.
Hope some of this helps with the explanation of IRR.
Once you get a full understanding of it, you can then look at all the kinds of Real Estate in any kind of City and then put in the pro-forma assumptions conservatively.
When you do enough of these, you will start to get a picture on where is the best place to invest (or even what type of investment is the best) simply by looking at the IRR that is calculated.
Other factors that are not put into this spreadsheet are Cap Ex, Vacancies, Legal, etc.
But given all of those variables, you can add them into your IRR Calculations and project them out over the 10 years.
OK... I'm not going to beat a dead horse. You get the point.