Calculating the Rate of Return

Internal Rate of Return
Knowledge Center

 

Next Topic

Internal Rate of Return > Best Practices

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.

Sign up for free     Log in


  Craig Sanders
 

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 LANGAR, Business 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.

 
More on Internal Rate of Return
Summary
Forum
Internal Rate of Return and Real Estate
Internal Rate of Return (IRR) Based KPIs
🔥Advantages of Internal Rate of Return (IRR) Method
Best Practices
🥇Internal Rate of Return (IRR) versus ROE versus ROA
🥈Internal Rate of Return (IRR) Formula
🥉Calculating Internal Rate of Return
Flat Rate versus Internal Rate of Return (IRR)
Calculating the Rate of Return
TVM versus Internal Rate of Return (IRR)
Internal Rate of Return (IRR) in Real Value?
Weaknesses of Internal Rate of Return (IRR)
Special Interest Group Leader

Are you an expert in Internal Rate of Return? Sign up for free


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.6 - Last updated: 25-9-2020. All names of their owners.