The most easily understood metric of investment return in real estate is Cash on Cash Return, usually abbreviated either CCR or COC. The concept is rather simple – CCR juxtaposes the cash investment that has been made to the Cash Flow (Income minus Expenses) being received.

For example, let’s say you invest $100,000 cash to buy a 4-plex which generates $2,000/month of Gross Income which results in $1,200/month of Cash Flow. Since CCR is usually thought of in terms of annual return, we must multiply all of the monthly numbers by 12. Thus, this $100,000 4-plex is generating $14,400 of Annual Cash Flow.

Now, CCR is simply the answer to the question – *if I invest $100,000 in this 4-plex, how quickly, or at what rate, would I recover my cash*?

Framed in this way, all we basically aim to find out is what percentage of $100,000 does $14,400 represent. In mathematical terms, if $100,000 is 100%, then $14,400 is x – at which point we solve for x:

X (CCR) = $14,400 / $100,000 = 14.4%

Thus, having paid $100,000 and received $1,200/month of Cash Flow, our achieved CCR is 14.4%.

I’ll segue for just a sec, even though this doesn’t particularly have bearing on today’s discussion, but it is timely to point out that leverage obviously has the effect of improving the CCR. For example, let’s just say that in lieu of paying $100,000 cash for this 4-plex, you instead make a down-payment of 25% ($25,000) and finance the rest.

In this case, the presence of a note for $75,000 would require a monthly payment – let’s just say $450/month. This extra expense would have the effect of lowering your Cash Flow from $1,200/month to $750, or $9,000 per annum. But, what does this look like in terms of the CCR?

Well – the thing to remember is that while the cost of your investment is still $100,000, the actual cash investment to you is only $25,000 in this case. Thus, what percentage of $25,000 is $9,000?

CCR = $9,000 / $25,000 = 36%

**Related:** How to Really Calculate Cash Flow on Your Next Rental Property

**How to Analyze a Real Estate Deal**

Deal analysis is one of the best ways to learn real estate investing and it comes down to fundamental comfort in estimating expenses, rents, and cash flow. This guide will give you the knowledge you need to begin analyzing properties with confidence.

## Infinity ROI

Indeed – the less money you have in the deal, the higher the Cash on Cash Return.

And if we follow this path of thought far enough, we would realize that any return on investment of $0, no matter how small, is actually infinity ROI. Yes – it’s true; if you managed to purchase this 4-plex with 100% financing, without putting any money into the deal, then even if you were only earning $100/month of cash flow, it is still a return on investment of zero – infinity.

This is the neighborhood where I’ve lived for the past decade and how I’ve bought everything that I own.

Having said this, I must warn you to please not go out and buy a fully financed 4-plex if the extent of your cash flow will be $100; doing so will put you one leaky faucet away from not having the money to keep afloat. However, it is indeed possible to buy with no money down and this represents the single greatest advantage of real estate as an investment vehicle. But I’ve strayed, so let’s get to the IRR…

## Limitations of CCR Which Are Corrected With IRR

CCR has some inherent to it limitations which render it inaccurate for the very sophisticated investors. When very sophisticated investors evaluate investment opportunities, they must assign value to things like time value of money and opportunity cast, not to mention that any movement of cash in or out of the transaction significantly impacts the returns, this can not be addressed by simply considering the IRR. Let’s talk about these one at a time:

## Time Value of Money

Time Value of money is simply the reality that money is more valuable today than at any time in the future.

**Related:** Apartment Building Investment and the Time Value of Money

There are many economic reasons for why this is true, but it all comes down to the concept of buying power and erosion thereof over time due to inflation of the currency supply and the resulting price inflation. Currency held today does indeed store more buying power that it will in the future – this statement is almost always true.

With this in mind, the sophisticated investors have to price this erosion of value into their return. Let’s say that over a set period of time a given investment produces Cash on Cash Return of 12%.

But, in the same period the inflation clocks in at 3%. On the day the money was vested, it had buying power equal to 100%, but on the day the return was dispersed the buying power is only 97%. This has to be accounted for, and the IRR formula does exactly that, while CCR does not.

## Opportunity Cost

As they say, there’s a right place and the right time to do everything.

So, if you invest the money now and lock it in for a set period of time, what other, and perhaps better, opportunities might come along that you will not be able to take action upon because your money is locked in…?

For sophisticated investors this is an ongoing problem. For example, I bring to them my syndicated apartment building. It looks good today, but what if someone else brings them a deal tomorrow that’s better? What is the premium ROI that they expect to receive with me today in order to be willing to tie-up funds for a period of time…?

IRR formula addresses this as well.

## Movement of Money

Finally, having weighted the opportunity for time value of money and the opportunity cost, IRR also is able to track movement of cash in and out of investment by tagging each movement with a date.

For instance, having purchased an asset, you might receive cash flow for two years, and then you might choose to refinance the building, which would constitute a large waterfall event.

Later, however, you realize that you were too aggressive on your refinance, leaving your DSCR too low, which result in your cash flow being unable to support the CapEx. Now you have to dip into your pocket to pay for the repairs, which naturally adversely impacts your IRR.

Once this happens, you decide to sell the building. And, since there are so many idiots chasing yield in the marketplace, you actually manage to sell a money-loosing asset at a profit – so you add that profit into the IRR.

## Conclusion

The formula for IRR is rather complex, and I’ll let the mathematicians worry about why it works and how. I simply use an excel spreadsheet to line-up and time-tag all of the in-flows and out-flows, and the formula calculates the return.

Perhaps some visuals or even a little video would be useful here. But, I’m busy – may be next time. I’ll simply tell you that to an individual investor buying long-term hold a 10% – 12% IRR might be quite respectable. In terms of syndications, however, we shoot for mid-teens to make opportunities attractive to the partners.

**Related**: Introduction to Internal Rate of Return (IRR)

That’s hard to find indeed!

*What metric of real estate investing do you find most difficult to understand?*

**Be sure to leave your comments below!**

## 36 Comments

Wow this is great. I had just read about IRR in a book and was having trouble understanding the concept from the Wikipedia article, but this definitely cleared it up 😀 Thanks!

Haha – I don’t think that whoever wrote the wikipedia article ever used the IRR – that’s what happens a lot…lol

Thanks so much Vamsi!

Yes, Please Ben try to find some time to make a video on this specific subject, some of us would greatly appreciate your time, thank you in advance.

Roberto – I’ll see what I can do perhaps in the future 🙂

Thanks so much!

Good stuff Ben. I know I need to do more with IRR, including adding it to the BiggerPockets Rental Property Calculator soon!

Yeah – I’d have to teach it to you first 🙂

Is this going to be done soon still? Also including NVP?

Has it been added?

My understanding of IRR is that is assumes returns are reinvested at the rate of IRR and this isn’t always feasible. Then again if you’re using it to compare 1 project to another it’s a wash right?

Great post though; IRR is a widely used concept that would behoove most to understand even at a basic level.

James – yes, continual re-investment would be nice, and we try our best to provide this. But, this is easier said than done 🙂

Thank you so much for reading and commenting!

Ben

Fantastic information, as a novice investor it was a concept

I had difficulty wrapping my head around, thanks for this

informative piece.

You are welcome Cedric.

Thanks indeed for leaving a comment!

The IRR is the discount rate by the net sum of all future discounted cash flows less initial investment equals zero. Would you include in the model adjusting the pro forma of the cash flows to account for capital investments (-CF) in future years? And, wouldn’t we also adjust NOI to account for increasing rents during those years? For example, year 0, you have an initial investment of $100,000 (Cf0=-100,000), then in year 3 say you have to replace the building roof for $40K, (Cf3=CF3-40,000). I think some people include those future capex expenditures in their IRR calculations. What do people think?

Haha Yes and Yes Paul. Besides, IRR is easily manipulated through refinancing, cash-outs, and by other means. We should never underwrite to IRR, and LPs should never really deploy capital based on IRR. A deal is good because discounted cash flows say so, not because of the IRR. That is a sort of catch 22 – sophisticated investors want to see the IRR, but that’s not where the magic is 🙂

Thanks for your comment Paul!

Hey Ben — When I used to teach analysis to other pros, IRR was always integral. The first thing out of my mouth was the false and misleading assumption in virtually every IRR analysis. This is especially true today. Here’s what I mean.

A syndication shows an IRR of 15%. Much of it is based on the foundation of impressive annual cash flow. Once a property ‘throws out’ a dollar of cash flow, by definition that dollar is NO LONGER ‘internal’. In fact, it’s now out in the cold, lucky to make 1% at the bank. So, to the extent cash flow is a relatively large part of any investment, the IRR becomes more than somewhat misleading.

The way to eliminate that mirage of 15%, and mirage is being kind, is to bring cash flows ‘forward’ each year at the actual market rate of return. In my experience doing IRR analyses before tax is of no value, so cash flows would then be brought forward at a rate of 1% minus the projected tax hit. In an investment leaning heavily on cash flow for IRR, that 15% would be significantly reduced, but would at least then be far more accurate. Though calculating an IRR takes some doing, computing what used to be called a FMRR (financial management rate of return) now referred to as MIRR (modified internal rate of return). The modified return, especially in for properties generating impressive cash flows, will virtually always be less than the IRR. They’ll also be much more accurate. Make sense?

Jeff – you see through the bull better than most – I’ve told you that before ::

IRR is fool’s gold. As the syndicator, I can manipulate and engineer IRR to be anything I want it to be to a very large extent. In order to understand this, people need to understand more about how the IRR works (perhaps in an upcoming article 🙂

This game is all about cash flows…not the kind of cash flow the newbies talk about, but the kind that you and I know. The sad reality is that sophisticated investors look at IRR as the definitive metric, not realizing that IRR says almost nothing about the health of an investment, which is all about discounting the cash flows properly. SO – are they really as sophisticated as they think, Jeff?

We do not underwrite to IRR – that’s akin to lying to ourselves. People shouldn’t worry so much about the IRR, and focus more on what’s important…

Still love me Jeff?

Yup, and as always, you’re still crackin’ me up.

One last observation. The modified return will be just as reliable as the IRR analysis from whence it came. Learned that one the hard way. #bloodynose 🙂

Boy… Sure wish I could have been one of your students during those analysis sessions! Amazing how much deeper of a story numbers can tell when you learn which ones are misleading. Brings a sharper focus to the underwriting. I definitely need a lot more work… Haha! Thanks Jeff, I always appreciate reading your comments!

A question about accounting for the time-value of money. If you do a simple IRR calculation, say for $1000 spent in Jan-11, and $1000 received in Jan-12, the IRR is 0. Given that we made no money in a year, while the buying power decreased, I would expect a negative IRR.

So, how is the time value of money reflected?

Good question – I do not have the answer…

To account for inflation while calculating IRR, you’d have to discount the cash flows by the inflation percentage. It’s easier to do this with MIRR but here is an example I’d use with IRR.

Setup a spreadsheet with 2 columns, one will have years and another your cash-flow for that year.

year / cash flow / cash flow including inflation

0 -1,000 -1,000 * (inflation %) ^ year = -1,000

1 1,000 1,000 * (inflation %) ^ year = 970

If you use inflation of 3% then your IRR will be -3%

This looks better if you use more years 🙂

But we could assume rents will rise in concert with inflation so it is a wash.

Great post and comments Ben. I would only add to your segue that leverage doesn’t necessarily improve the CCR. The CCR could go down depending on the terms of the financing too. In that case the deal would be negatively leveraged. In fact I would say that anytime the CCR is lower than the buyer’s cap rate (Based on the entire cost of the deal including purchase price, commissions, closing costs, loan fees, third party reports, legal, immediate capex, etc.) is higher than the CCR a deal is negatively leveraged and that a better deal should be sought.

Wow – yeah, I guess CCR could go down with terms that are horrendous. But, who is that stupid Giovanni?! Seriously – this never even occurred to me…;lol

People like to see percentages.

I don’t do this as it isn’t worth the effort for the deals I generally am doing, but I think the best way to evaluate a potential deal is to calculate the NPV discounting at your WACC.

🙂

Hey Ben,

Love your writing, cracks me up every time, and I usually learn something. When I was in college I learned how to calculate IRR by hand (old school professor) but only basic scenarios. So I was wondering if you would upload that fancy excel IRR spreadsheet you referenced above to BiggerPockets, and if you already have if you could post a link here too it.

Thanks Ben and keep on keeping Brandon honest!

Ha – working on a fancy spreadsheet now; talk to me in about 5 years… The thing about IRR is knowing how to account cash flows; that’s the hard part!

As to Brandon – he has been lost to society for a long time now, and try as I may I can not bring him back 🙂

Thanks so much for reading my stuff Nick!

Good topic, Ben. IRR is often misunderstood and underappreciated. Investors evaluate several deal variables, not just a single number, so IRR should be part of the analysis.

The concept of IRR is straightforward, but its calculation is more complex. IRR is the rate of return for all of the investment’s cash inflows and outflows, including purchase and sale, and everything in between.

To calculate, most people are better off using reliable financial tools, not homemade spreadsheets. I can help you with a cloud-based IRR calculator any time you need it.

To Paul Lopez’s point – yes, I include projected capital expenses in the model, as that investment impacts IRR. Again, you want to capture cash inflows and outflows.

Investors need to validate the numbers related to their own deals. By understanding IRR and being able to run their own numbers, investors won’t have to rely on “manipulated or engineered” IRR from sellers. (Not that you do that.)

I do take issue with infinite return. It takes money to make money, even if it’s not your money, and while a return may be high, it is not infinite.

Great article Ben! Thanks for this. Can’t wait to read the introduction to IRR

Thanks for posting about IRR. I just had an investor ask what the IRR was on a property package I was presenting. I can put this to use.

Hey Ben, thanks for this informative post — I’m only beginning to learn about IRR, so this was a great read for clearing up a lot of questions I had about it, such as its function. I do have one question, though — why is the depreciation of money from inflation included in IRR calculations? Even if the investor walks away and pursues another opportunity (i.e. opportunity cost), they still lose money to inflation. It’s sort of a constant, no matter the investment vehicle. I say sort of a constant, too, because inflation ranges wildly — for example, inflation in 2014 was just 0.8%, while 2007 saw a rate of 4.1%. I understand that, historically speaking, it’s been around 3%, but no wise real estate investor would look at a property and say, “On average, operating expenses are around 50% of gross income, so I’ll go ahead and buy this property without checking expenses.” Operating expenses can be readily ascertained, though, while I know of no way to readily predict inflation rates.

Inflation is a real cost. Most investors actually use the MIRR, which provides for a discount rate. This discount rate can be one or more factors, of which cost of inflation is one, cost of money is another, safe re-investment levels is another.

As such, IRR is the basis – apples to apples, so to say. IRR is the rate at which NPV is “0” – the break even point, so to say. But, IRR presumes re-investment of returns, and re-investment ROI is different for all. Therefore, we provide them with the IRR basis, but each investor will discount appropriately for them. Inflation is certainly part of that formula, and it is the only one that is same for all…

Hey Ben,

Great post- it is very informative and offers great insight. You mentioned being too aggressive on a refi…can you go more into detail on this topic and how to avoid being too aggressive while still being able to utilize the brrr strategy ? Thank you for all your help and time!!

This is a great discussion on IRR. You may also find my post useful that provides visuals on how to use XIRR function.

https://www.biggerpockets.com/blogs/10322/67935-use-of-internal-rate-of-return-irr-in-syndications

I’m having a problem getting the same results in my Excel spreadsheet using the exact same data as you used. Instead of 7.6% I got 44%. What am I missing?