Calculating the Rate of Return

Internal Rate of Return
Knowledge Center

 

Next Topic

Internal Rate of Return > Forum > Calculating the Rate of Return

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? (...) Read more? Sign up for free
 

Please register now to read all responses and to join this discussion yourself. It's easy and 100% free.

    Log in

 
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

Interested? Sign up for free.


Internal Rate of Return
Summary
Forum
Best Practices


    Internal Rate of Return
    Knowledge Center

     

    Next Topic



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