Calculating the Rate of Return

Internal Rate of Return > Best Practices Log in

Calculating the Rate of Return
Bernard Lim
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, Member
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, Member
The easiest is to use your own scientific calculator:
[3^(1/9)-1] x 100 = 12.983%
Hope this is useful....



Special Interest Group Leader

Internal Rate of Return

Best Practices
Expert Tips


About 12manage | Advertising | Link to us / Cite us | Privacy | Suggestions | Terms of Service
2018 12manage - The Executive Fast Track. V14.1 - Last updated: 18-10-2018. All names of their owners.