Calculating the Rate of Return

Internal Rate of Return
Knowledge Center

Forum

New Topic

Bernard Lim

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
 

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.

Participate and leave a comment
Exchanging your ideas stimulates your personal and professional development. And you can help other people! Please motivate your point of view. You can still edit your comment for 3 hours.

Start a new forum topic

 

More on Internal Rate of Return
Summary
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
Internal Rate of Return (IRR) versus ROE versus ROA
Internal Rate of Return (IRR) Formula
Calculating Internal Rate of Return
Weaknesses of Internal Rate of Return (IRR)
Special Interest Group

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

Notify your students

Copy this into your study materials:

and add a hyperlink to:

Link to this discussion

Copy this HTML code to your web site:

Internal Rate of Return
Knowledge Center



About 12manage | Advertising | Link to us / Cite us | Privacy | Suggestions | Terms of Service
2021 12manage - The Executive Fast Track. V15.8 - Last updated: 9-5-2021. All names of their owners.