How to calculate internal rate of return for a set of values without using the IRR function?. The calculated IRR must also be able to change automatically if one of the values is changed.
How to calculate internal rate of return for a set of values without using the IRR function?. The calculated IRR must also be able to change automatically if one of the values is changed.
Have a look at link.
https://www.investopedia.com/terms/i/irr.asp
Edit: Here's one more specifically for Excel.
https://www.investopedia.com/ask/ans...-irr-excel.asp
Short answer, without using IRR, there is no direct way to calculate IRR.
You'll need to write custom function (in VBA), use Solver etc.
Last edited by CK76; 08-15-2018 at 09:37 AM.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
The real Q is... whay not use IRR? Are you trying to do something difficult with it??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks