Calculating the Rate of Return

12manage is looking for
MBA students.


 
Internal Rate of Return > Forum 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....Sign up
 

 
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....Sign up
 

 
 

Special Interest Group Leader

Interested? Sign up for free.


Internal Rate of Return
Summary
Forum
Best Practices

Expert Tips

Resources
 



About 12manage | Advertising | Link to us / Cite us | Privacy | Suggestions | Terms of Service
2019 12manage - The Executive Fast Track. V15.0 - Last updated: 16-1-2019. All names of their owners.