Calculating the Rate of Return

Internal Rate of Return
Knowledge Center


New Topic

Bernard Lim

Calculating the Rate of Return

A leading broker has advertised money multiplier certificates that will triple your money in 9 years. If you buy one for $333.33 today, it will pay you $1000 at the end of nine years. What rate of return will you earn on these money multiplier certificates?

  Craig Sanders

IRR Calculation in Excel

The IRR = 12.979% using a start date of 1/1/10 in my example and ending 12/31/18. I use the formula in Microsoft Excel of =XIRR.

  Rachid LANGAR
Business Consultant, Qatar

Another Easy Way to calculate IRR

The easiest is to use your own scientific calculator:
[3^(1/9)-1] x 100 = 12.983%
Hope this is useful.

Start a new forum topic


More on Internal Rate of Return:
Special Interest Group

Do you have a keen interest in Internal Rate of Return? Become our SIG Leader

Internal Rate of Return
Knowledge Center

About 12manage | Advertising | Link to us / Cite us | Privacy | Suggestions | Terms of Service
2021 12manage - The Executive Fast Track. V15.8 - Last updated: 25-9-2021. All names of their owners.