Calculating the Rate of Return

Internal Rate of Return > Forum Log in

Calculating the Rate of Return
Bernard Lim, Malaysia
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?

IRR Calculation in Excel
Craig Sanders, Other, USA
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.

Another Easy Way to calculate IRR
Rachid LANGAR, Business Consultant, Qatar
The easiest is to use your own scientific calculator:
[3^(1/9)-1] x 100 = 12.983%
Hope this is useful.



    Do you wish to study further? You can learn more from the summary, forum, discussions, lessons, courses, training, instructions, expert tips, best practices and education sources. Register.  

Special Interest Group Leader

You here

More on Internal Rate of Return
Best Practices

Expert Tips


About 12manage | Advertising | Link to us | Privacy | Terms of Service
Copyright 2016 12manage - The Executive Fast Track. V14.1 - Last updated: 28-10-2016. All names tm by their owners.