How to Calculate ROI on Investment Property

How to Calculate ROI on Investment Property

One of the questions I am asked often is how I know if a property is a good investment.  To me, the answer to this question translates into knowing exactly how to calculate ROI on investment property.  The reality that folks are willing to put money under my management via syndication of real estate is in part a function of me knowing precisely how to calculate ROI – all of the ways to do so.

It is important to understand that what makes a piece of investment-grade real estate actually a good investment opportunity is only partially a function of the numbers – there are a lot of less quantifiable and less obvious aspects of any given opportunity that need to be taken into consideration.  I will go even further by saying that it happens quite often that all of the numbers look stellar, and yet the opportunity is actually very flawed…

I cover all of the perspectives that apply to this conversation as part of the Cash Flow Freedom University, so I will not attempt to do anything more here than address the numbers.  Indeed, the scope of this article is to simply address the main numerical measurements that we use in our analysis process, and I will try to do so in fewer than 3,000 words- although this will be a challenge.

I will begin with the most general metrics – a birds-eye view of the property from 1,000 feet in the air, so to speak.  And as the article progresses the metrics will become more specific.  And now, without further adieu on to how to calculate ROI on investment property…

How to Calculate ROI on Investment Property, Yield

Yield should most easily be thought of as the gross revenue, which in the world of real estate is simply the sum of all rental and other income attributable to a building.  For example, if each unit in a 4-plex rents for $500 per month, then the monthly yield is $2,000, while the annual yield is $24,000.  If, however, there happens to be a coin-operated laundry in the building which brings-in an additional $100/month, then the monthly Yield is $2,100.

Yield represented as a percentage is calculated with the following formula:

Yield = Annual Gross Revenue / Price (Value)

Thus, if you pay $130,000 for a 4-plex which generates an Annual Gross Income (Annual Yield) of $24,000, then it can be said that your investment yields 18.5%:

Yield = $24,000 / $130,000 = 18.5%

Yield as a measurement of the health of a real estate investment is rather limited by the fact that it focuses strictly on the income side of the operations structure and does not take into account the expense structure of the building.  As a result, it is possible to have two buildings with an identical Yield produce substantially different NOI (Net Operating Income – discussed in next section) based on the reality that one costs a lot more to operate and maintain than does the other.

As such, the only useful application of this metric is with respect to determining whether the income streams being advertised / represented by the seller appear to be in-line with other buildings of similar nature and in similar location.  Naturally, knowledge of the marketplace is requisite to make this determination…

How to Calculate ROI on Investment Property, GRM

Gross Rent Multiplier is a coefficient that represents the general dynamic in a marketplace relative to how much investors are willing to spend for income as is represented by Gross Rent.  While we do pay attention to the GRM when analyzing larger apartment buildings, it is very under-weighted in this environment for reasons that will become apparent to you as you continue to read.  However, the GRM is indeed the prevalent metric when apprising buildings with 4 units or fewer; in other words, when appraising any structure the can be financed with a residential mortgage needs to be evaluated via GRM.

The GRM provides us with a very vague look of the financial health of the building for the same reason as does the Yield – neither takes into account the expense structure of the asset, which makes it highly imprecise.  But, since people do use it, you should know it, and here’s how the GRM works:

If someone pays $120,000 for a building which brings in $2,000/month of Gross Rent, then the multiple which relates the Gross Income to the Purchase Price is 60:

GRM = Purchase Price (Value) / Gross Income = $120,000 / $2,000 = 60

This number “60” is the Gross Rent Multiplier in this case.  If, however, the Gross Income in this building were $2,200, then having paid $120,000 for the building the buyer will have realized a GRM of 54.5:

GRM = Purchase Price (Value) / Gross Income = $120,000 / $2,200 = 54.5

Now – let’s say that you analyze 10 buildings in a given marketplace of like character and realize that all of them sold in the range of 65 to 75 GRM.  Armed with this information you can determine a value of your building relative to the GRM Method by multiplying the Gross Income (Yield) of your building by the appropriate multiplier.

What is the appropriate multiplier; after all 65 – 75 is a big variance?  Well, it would be easy enough to add all 10 of your comps together and divide by 10 to arrive at an average.  The problem with doing that, however, is that the variances in the GRM multipliers likely indicate differences in amenities, age, and condition of the comps, and by simply using an average you would not arrive at a multiplier that is sensitive enough.  It is better to arrive at “weighted” GRM coefficient that would most closely fit the type and condition of the building that you are valuing.  This, however, is a job, and I suggest that it’s best to ask an appraiser.

Having said all this, however, understand that the GRM Method is not very accurate in the first place since it does not account for expenses.  As such perhaps an average is OK to use after all.  Thus, if your building, or the building you are trying to valuate brings in $2,000/month of Gross Income, then the GRM method would value it at $120,000 presuming multiplier of 60, and $130,000 presuming a multiplier of 65, and so on…

To do better than this, we have to account for the expense structure of the asset

How to Calculate ROI on Investment Property, NOI

Net Operating Income (NOI) is the measurement of the income-potential of a piece of income-producing real estate which accounts for the expense structure of the asset.  The NOI provides a very detailed look at the health of the investment, and it is used as the basis for estimating the value of the investment through the Capitalization Rate Analysis, which will be addressed further in this article.   The formula for NOI is as follows:

NOI = Gross Income (Yield) – Operating Costs (Not including cost of money)

With respect to this formula, it important to understand that the Cost of Money (Debt Service), which is essentially the sum of all mortgage payments, is not figured into the NOI calculation as one of the expenses.  The reason for this is that the mortgage payment depends on the amount and the terms of the Leverage, or lack thereof.  For instance, if someone were to pay all cash for the building, then they obviously would not have any payments for the mortgage because they would not have a mortgage.  On then other hand, someone like me might finance the entire purchase and back into very substantial debt service.  Regardless of how we do it, all of us need to be able to conduct an apples to apples analysis of the income-potential of the building, and the most reasonable way to do so is by excluding the cost of money.  This is why the NOI is used to underpin the valuation process in commercial real estate.

Thus, if the 4-plex you are considering shows $2,000/month of Gross Income, and all of the expenses such as Property Taxes & Special Assessments, Owner-paid Utilities, Upkeep, Lawn Care & Snow removal, Vacancy Factor, Management Costs, Fire Insurance, etc. add up to $800/month, then the NOI of this building is $1,200/month:

NOI = Gross Income – Operating Costs = $2,000 – $800 = $1,200/month

This number $1,200 gives us a much more honest perspective on the income-potential of the building than if we simply consider the Gross Income.

Furthermore, if we want to estimate a value of this building we can do so with much more precision by using the NOI as the basis rather than the GRM.  The process of doing so is called Capitalization Rate Analysis…

How to Calculate ROI on Investment Property, CAP Rate

First of all, capitalization rate is simply understood as the rate of return that a reasonably aggressive investor would be willing to receive on his/her investments in real estate.  The rationale is rather simple in that every investor has to ultimately make the call on what rate of return is good enough for them to “pull the trigger”- at what point does it become “worth it” to put your money at risk?

For instance, if you are comfortable deploying capital so long as you can generate at least a 10% return, then you should be willing to pay $144,000 for the 4-plex we’ve been discussing.  Why – because $1,200 of monthly NOI constitutes an annual return of 10% at the price of $144,000

$1,200 x 12 = $14,400 which is 10% of $144,000

Thus, the formula for capitalization rate is:

CAP Rate = NOI / Price (Value)

Now – to place a value on income-producing property relative to the CAP Rate and its income we simply invert the capitalization formula:

Value = NOI / CAP Rate

Thus, once you’ve researched the income and expenses of a building and have arrived at an NOI, you can estimate the value of the income stream represented by this building.  In the case of our 4-plex with annual NOI of $14,400, and presuming a CAP Rate of 10%, the market valuation is $144,000:

Value = NOI / CAP Rate = $14,400 / 10% = $144,00

Interestingly, should the going CAP Rate in your marketplace be 7 CAP and not 10, then the valuation would look very different

Value = NOI / CAP Rate = $14,400 / 7% = $205,714

Indeed, a 3 point swing in the capitalization rate caused the valuation to jump from $144,000 to almost $206,000.  Thus, in order to conduct an honest valuation of real estate you must have knowledge of precise CAP Rate which is prevalent in a given marketplace.

To figure out the going CAP Rate in a given marketplace you would need to do similar research as what we discussed relative to the GRM.  However, in lieu of needing to find out prices of the comps and their corresponding gross rents, in this case you will need to know the NOI of the comps.  This, as you can imagine, is a more difficult proposition since in order to know the NOI you must know the expense structure of the comp, which is difficult to gauge indeed.

p>As such, I suggest that the best way to understand the trends in any marketplace is just to ask a commercial banker or a good appraiser, whose job it is to know the going CAP Rate.

How to Calculate ROI on Investment Property, Cash FLow

While the NOI is a valuable tool in being able to assess the income potential of an investment, and in combination with the CAP Rate allows us to estimate the value of any income-producing asset, neither gives as a clear understanding of our bottom line relative to the type of financing we arranged for this transaction.  As I stated earlier, the NOI accounts for all of the expenses except for one – financing costs.

Obviously, if we were to pay all cash for a building, then there would not be a mortgage or a mortgage payment.  In this case the NOI is in fact our bottom line – the dough in the bank at the end of the month.

However, most of us will have to utilize some amount of leverage in order to acquire assets, and as such we will have debt service obligations, and since debt service is not included into the NOI calculation, we must add one more step to our analysis.  Namely, we must subtract the cost of our mortgage from the NOI in order to arrive at Cash Flow

Cash Flow = NOI – Debt Service

Cash Flow is the single most important metric relative to long-term investments.  Cash Flow, as far as I am concerned, is the true measure of the investment.  We acquire income-producing assets for the purpose of generating passive cash flow, because we view passive cash flow as the more stable alternative to earned income.  Therefore, the entire purpose of acquisition of income-producing real estate is relative to its capacity to “throw-off” passive cash flow.

An important distinction to be understood is that the terms of the underlying financing have a profound impact on the Cash Flow.  For instance, a 4-plex which generates monthly NOI of $1,250, and is financed with a 30-year mortgage loan at 6%, can generate monthly cash flow of about $650, since the monthly debt service associated with this loan will be roughly $600.  However, the same exact building financed with a 15-year mortgage loan at 7% will generate only about $350 of monthly cash flow, because the monthly payment in this case is much higher.

How to Calculate ROI on Investment Property, Cash on Cash

Another important way of analyzing the return on your investment is to consider your cash contribution as the entirety of the investment.  In fact, this may very well be the most reasonable approach. After all, you may have bought that 4-plex we’ve been discussing for $144,000 dollars, but unless you paid cash for it, it can be said that your actual cash out of pocket investment is only the down-payment and closing costs…

The metric of Cash on Cash Return juxtaposes your cash investment against the cash flow achieved by the building you bought.  The formula is:

CCR = Annual Cash Flow / Total Cash Investment

Thus, if you put down 20% ($28,800) and spent $1,200 on closing costs for a total cash out of pocket investment of $30,000, and the 4-plex cash flows $650/month ($7,800/year), then you’ve achieved a Cash on Cash Return of 26%:

CCR = Annual Cash Flow / Total Cash Investment = $7,800 / $30,000 = 26%

How to Calculate ROI on Investment Property, IRR

The IRR is likely the most sophisticated measure of investment return in real estate. Frankly, it wasn’t until quite late in my investing career and needed to track investment returns throughout multiple years and income in-flows and out-flows that I paid any attention to it.  Cash Flow, CAP Rate, and Cash on Cash should be sufficient measurements of investment return for the vast majority of folks reading this.  However, if you have money coming in and going out at various stages of the investment, the Internal Rate of Return is the only metric capable of giving you the complete answer. One article I came across that I thought stood out is by J Scott – one of my compatriots at BiggerPockets, who about 4 years ago wrote on the subject. In fact, his article was the best content on the subject in my opinion – until my fingers touched the keyboard that is…:)

Let us consider an investment opportunity which involves you buying an apartment complex for $3,000,000.  The required down-payment is $600,000; the remodel will cost $400,000; and the closing costs, points, prorations, and various deposits total $100,000.  Thus, to close on the deal you will need $1,100,000.

Now lets say that this project throws off $110,000 of Cash Flow in year 1; $113,000 in year 2; $117,000 in year 3; $120,000 in year 4; and $122,000 of Cash Flow in year 5.  Further, let’s say that after 5 years you sell the asset for $3,300,000.  Let’s say that the remaining balance on your debt is $2,250,000, in which case having sold for $3,300,000 you’ll be receiving $1,050,000 at closing.  Also, at closing you are refunded $50,000 worth of deposits which you made at the time of acquisition.  Thus, the total amount of cash coming to you at closing is $1,100,000.

The IRR formula is capable of taking into account all of the inflows and outflows and to reconcile them into the Internal Rate of Return.  The formula is very complex, but the actual calculation is accomplished with ease in Microsoft Excel since the formula for IRR is standard – here’s what it looks like:

How to Calculate ROI on Investment Property, IRR

 

Notice that the opening balance is a negative number; think of it as money being taken away from you.  Subsequently, years 1 through 5 represent the positive Cash Flow from the investment.  And finally, the last item is the total cash distribution to you at closing.  And as you can see, with the numbers being what they are, the apparent Internal Rate of Return on this investment is 9.14%.

You’ll find that the more sophisticated investors do want to know the IRR on any given investment, and this is specifically true of investments into a real estate syndicate, which is what I am involved with and the reason I use this calculation a lot.  As I mentioned, I am not sure if IRR is entirely useful to you, but here you go J

How to Calculate ROI on Investment Property, DSCR

Now – the DSCR you should know for sure!  DSCR is a ratio that the lenders use to determine the relationship of the Monthly Debt Service (Mortgage Payment) to the NOI.  Essentially, the lender wants to establish how easily you are going to be able to make your mortgage payment.  The reason I am including DSCR into the article is because you need to know what your lender is thinking in order to be able to structure deals!

The formula is:

DSCR = Monthly NOI / Monthly Debt Service

Thus, if the lender allowed you to borrow money at a cost of $1,200 per month to finance your 4-plex which achieves a monthly NOI of $1,200, then the proportion would be 1:

DSCR = Monthly NOI / Monthly Debt Service = $1,200 / $1,200 = 1

This would mean that after you pay your mortgage, there would be nothing left; your cash flow would be $0.  Naturally, lenders are not likely to entertain this scenario.  More likely, lenders will require a minimum of 1.2 DSCR, meaning that your monthly NOI will need to exceed the mortgage payment by 20%.  To figure out the maximum mortgage payment you will qualify for assuming a 1.2 DSCR, we invert the formula:

Mortgage Payment = Monthly NOI / DSCR = $1,200 / 1.2 = $1,000

Prior to approaching a lender for funding, you should research their guidelines relative to DSCR and make sure that your proposal falls within the scope of their requirements.  No matter how much sense your project makes, it is not going to be approved if it doesn’t fit the guidelines

SO – HOW TO CALCULATE ROI ON INVESTMENT PROPERTY

Answer – as simple as the 3,000 words above. Well, may be not quite as simple as that. As I mentioned at the outset, what makes a good investment opportunity is a can of worms that holds much more than just numbers, and to learn what all is in that can I encourage you to consult the CFFU.  However, understanding the logic and application discussed in this article will put you a leg up on your competition relative to being able to analyze the financial worth of an investment.

Was this article useful?  Feel free to leave comments guys…

12 Comments

  • Sharon Tzib Reply

    Yeah, IRR makes my head hurt, but your example helps a lot. So I’m sure it’s a coincidence that the figures for the initial money you needed to close and the total amount of cash coming to you at closing was $1,100,000. To be clear, in the chart, the opening balance was the initial money you invested, correct?

    So do you calculate IRR prior to purchasing an investment using cash flow projections? Or is this only something that you use during ownership? Thanks, Ben.

    p.s. I don’t seem to get email notification of your replies to me. Is there a way to change that?

    • Ben Reply

      Hi Sharon,

      Yes – it is a coincidence. The initial balance is the total outlay of capital. Think of IRR as a combination of COC and CAP. I did not do it in this example, but if the investment were to be refinanced and/or needed additional capital at any point, the IRR formula would be able to track the worth of the investment better than any other metric.

      Sophisticated investors, such as those who want to invest with me in a syndication, definitely want to know the projected IRR before they get in. This is a very sophisticated way of gauging ROI.

  • Thom H. Reply

    Ben,
    I’ve been reading your articles for some time on BP, and following your steady growth. Extremely nice work putting these metrics into a simple, straight forward, easy to understand article, especially for your newbies. Probably the best single-source explanation I’ve seen on the subject matter. Enjoyed the article even as a slightly “more seasoned” RE investor. Hope you continue to find successes investing and writing. Also best of luck with your venture into syndicating. Hope to continue reading more upcoming articles on the subject soon. Again best of luck. -T

    • Ben Reply

      Thank you indeed Thom! I will definitely continue to write both here and on BiggerPockets.com – syndicating will be the main focus, but not solely. Once in a while I need space to step away from that which is on my mind 24 hours a day – you know? But, I’ll definitely continue to write!

      Thanks very much for reading and commenting,

      Ben

  • Sara Cunningham Reply

    Ben,

    Great information and explanations of the different terms.. I had no clue about the IRR. Also helped me refresh my memory on all the others. After a while you just seem to know what works and what doesn’t and you don’t even think about how you figure it out.

    Looking forward to your future blogs and articles.Thanks Ben.

    • Ben Reply

      Hey Sara!

      I agree with you about the IRR. Now days that I am working with investors via the syndication process, sophisticated investors want to know the IRR. But, it is one of those metrics that are “down the track”.

      Thanks so much for reading and commenting Sara!

  • Michael Reply

    So the DSCR is the bank way of saying Cash Flow, aren’t the two the exact same thing?

    • Ben Reply

      Hey Michael – no. DSCR (sometimes referred to as DCR) is the relationship of the NOI to Cost of Money. Cash Flow is what is left of the NOI after Cost of Money. They want to know how easily you’ll be able to pay the mortgage. For instance, if the sum of your mortgage payments is $1,000/month and the NOI looks like $1,600, then they know that having paid the mortgage you will still be left with $600/month of CF. To the bank this means that you have $600 of wiggle room – you can loose $600 of income and still make their debt service. DSCR in this case is 1.6

      If, on the other hand, the NOI is only $1,200, then while DSCR is 1.2 you are only left with $200 of Cash Flow, which is your wiggle room. Personally, even though the bank will finance DSCR of 1.25 and even 1.2 in some cases, I do not touch anything with DSCR of under 1.4 – 1.6 or better.

      Hopefully this puts perspective on DSCR for you. Thoughts?

  • Roberto Reyna Reply

    I learned a lot from this article as well as your video on YouTube. Yes, a picture is worth a thousand words, but a video is worth a million words. Please continue to provide more videos.
    thanks,
    Robert Reyna from Houston, Texas

    • Ben Reply

      Thank you so much Robert!

      Yes – I’ve been slacking in the video department. Really busy at the moment with my syndicate. I’ll try to get something out though, and please feel free to reach out!

      Ben

  • Sandy Reply

    HI Ben,
    Very Nice article . Everything from beginning to end is simple and through with proper example.
    But I would love to get the formula for IRR and want to confirm that it is only useful in big apartment complexes or it can be useful in small 4 plexes as well ? if yes, can you give an example please.

    Thanks,
    sandy

    • Ben Reply

      Hi, Sandy.

      IRR is a very complex formula. Google it if you want. But, the practical application of it is through a spreadsheet; any spreadsheet program will have an IRR function. The proper use of it is another can of worms that I can’t possibly cover here. I’ve written other article though; perhaps do a search 🙂

      Yes – you can use it relative to 4-plex, and you should. The use of this formula requires a particular approach to underwriting that is much more precise. Perhaps I’ll have to do a video blog some time…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.