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
Summary
Forum

Best Practices
Expert Tips

Resources



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.