Personal Finance

The Difference Between Internal Rate of Return and Return on Investment

Internal rate of return and return on investment are two common metrics used to show how an investment has performed over time. Although similar, these two metrics describe investment performance in very different terms.

Let's start simple

Return on investment is the easier of the two methods. It describes the percentage gain or loss from an investment over any period of time. If you bought an investment for $50 and today it is worth $75, you're return on investment is 50%. That is:

Investors should be careful to understand and incorporate any costs associated with an investment in their calculation. For example, taxes, fees, and carrying costs can all subtract from the value of the investment when sold. In those cases, those expenses must be subtracted from the "current value" in the equation above before completing the math.

Return on investment works for any time period. It is simply a reflection of the change from one point in time to another. That can be problematic when evaluating an investment over a long period of time. For example, a 100% ROI seems strong without knowing that it took 100 years to achieve that return.

Enter internal rate of return

The internal rate of return solves this problem by calculating the percentage return on an annualized basis regardless of the actual investment period. Hold an investment for one year, three years, or 100 years, it doesn't matter. Internal rate of return will tell you the annualized percentage returns of that investment over any period of time.

For an investment that lasts exactly one year, the internal rate of return is the same as the return on investment. From the example above, our stock must grow 50% per year to grow from $50 to $75 over a one year period. That's pretty simple.

The hard part comes in when calculating the returns on an annualized basis, over multiple years, and still incorporating taxes, fees, dividend payments, and other cash expenses or gains.

The easiest way to do these more challenging calculations is with a spreadsheet. We'll use Excel to demonstrate an example.

The screenshot below shows the cash spent and cash returned for a four year stock investment. In year one, there is the cash outflow to purchase the stock and pay brokerage fees. In years two and three, the company pays a dividend of $5 per year. For simplicity, we'll assume those dividends are not reinvested. Finally, in year four, the stock is sold for $165, and we also subtract taxes and brokerage fees. We also assume that we were able to collect another $5 dividend check in year four, prior to selling.

Below each year, we've added together all the cash outflow and inflow. That step is critical, as those net cash flow figures will determine our internal rate of return.

The next step is to use the =IRR() formula in Excel to calculate our internal rate of return.

That formula returns 16.2%, which is our internal rate of return for this investment. Remember, the IRR is the annualized percentage return. The 16.2% represents the average annual return over the four years of this investment.

The ROI of this investment calculates to 57%, which includes the dividend gains and the costs of brokerage fees and taxes. This ROI represents the simple percentage gain over the entire four year period, not annualized as in the IRR calculation.

Used together, these two metrics tell a robust story

At the end of the day, each metric is useful in its own way. For monitoring your performance over the long term or against benchmarks like the S&P 500, the internal rate of return is more informative because it describes the performance in consistent, annual terms. However, for determining short term gains or understanding your cash-on-cash returns, the return on investment number gives you everything you need with a much simpler calculation.

How one Seattle couple secured a $60K Social Security bonus -- and you can too

A Seattle couple recently discovered some little-known Social Security secrets that can boost many retirees' income by as much as $60,000. They were shocked by how easy it was to actually take advantage of these loopholes. And although it may seem too good to be true, it's 100% real. In fact, one MarketWatch reporter argues that if more Americans used them, the government would have to shell out an extra $10 billion... every year! So once you learn how to take advantage of these loopholes, you could retire confidently with the peace of mind we're all after, even if you're woefully unprepared. Simply click here to receive your free copy of our new report that details how you can take advantage of these strategies.

This article is part of The Motley Fool's Knowledge Center, which was created based on the collected wisdom of a fantastic community of investors based in the Foolsaurus . Pop on over there to learn more about our Wiki and how you can be involved in helping the world invest, better! If you see any issues with this page, please email us at . Thanks -- and Fool on!

The article The Difference Between Internal Rate of Return and Return on Investment originally appeared on

Try any of our Foolish newsletter services free for 30 days . We Fools may not all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors. The Motley Fool has a disclosure policy .

Copyright © 1995 - 2015 The Motley Fool, LLC. All rights reserved. The Motley Fool has a disclosure policy .

The views and opinions expressed herein are the views and opinions of the author and do not necessarily reflect those of Nasdaq, Inc.

The views and opinions expressed herein are the views and opinions of the author and do not necessarily reflect those of Nasdaq, Inc.

Other Topics


The Motley Fool

Founded in 1993 in Alexandria, VA., by brothers David and Tom Gardner, The Motley Fool is a multimedia financial-services company dedicated to building the world's greatest investment community. Reaching millions of people each month through its website, books, newspaper column, radio show, television appearances, and subscription newsletter services, The Motley Fool champions shareholder values and advocates tirelessly for the individual investor. The company's name was taken from Shakespeare, whose wise fools both instructed and amused, and could speak the truth to the king -- without getting their heads lopped off.

Learn More