RRI Function

Below is an excerpt from our Excel Time Value of Money course written by Joseph Helstrom,CPA.

RRI

RRI is a new function that was introduced in Excel 2013. It returns the equivalent interest rate for the growth of an investment.  The inputs required are the number of periods, the present value and the future value.
As an example, let’s say you invested $100,000 for 8 years compounded annually and the investment grows to a value of $150,000.  What is the equivalent rate of return?  In these examples, we will type the formula directly into the cell and not use the function wizard.
Start in the cell with =RRI( and then type the inputs as shown below.
RRI function

 

 

 

The answer:

RRI - Time value of money function

About 5.2%.

Remember, compounding periods are important.  What if the investment was for 8 years compounded quarterly?  You would need to adjust NPER for the quarterly compounding so it would be 8 years x 4 compounding periods per year = 32.  You will also need to adjust the result if the desired answer is an annual rate.  You can type a new formula by starting with =RRI( and then typing the new inputs or selecting the cell and pressing F2 to edit the existing formula.
RRI function

 

 

The answer:

RRI -Time Value of Money function

 

 

This is the answer for a quarterly rate.  When multiplied by 4 to translate it into an annual rate, the answer is .012751 x 4 = .051004 or about 5.1%.
The quarterly compounding slightly reduced the rate necessary to achieve the same result.

Leave a Reply

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

  • “Excellent Regulatory Review Course. The self-study format (E-Book) provided an excellent overview of the regulatory requirements for Califonia CPAs. I will be using the E-Book as  a reference material. Thank you for providing a very comprehensive yet affordable option for this required CPE.”

    - Constance

  • You guys do a great job!  As a person in industry it can be really expensive to stay current and you have great options that are actually useful as well as cost effective!

    - Sue

  • Overall I was very pleased with the course. Previously I knew just enough about pivot tables to be dangerous. Now I see the power that they have and I feel much more confident using pivot tables. The course materials were very clear and well prepared. I’ll be looking at your website for future CPE hours.

    - Scott