 # Calculating the Rate of Return Bernard Lim, Malaysia

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, USA 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 LANGARBusiness 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. Leave a comment?

 More on Internal Rate of Return:
 Forum
 Flat Rate versus Internal Rate of Return (IRR) 👀 Calculating the Rate of Return Internal Rate of Return and Real Estate TVM versus Internal Rate of Return (IRR) Internal Rate of Return (IRR) Based KPIs Internal Rate of Return (IRR) in Real Value? 🔥 Advantages of Internal Rate of Return (IRR) Method
 Best Practices
 Special Interest Group
 Do you have a keen interest in Internal Rate of Return? Become our SIG Leader 