 Quote:
Originally Posted by jIMOh
my function wizard does not have XIRR
running excel 2003.
the link does not show the math behind the calculation, can you display it here? thx
|
I'm pretty sure the math for XIRR is not a simple equation. I believe Excel starts with a guess (of 10%, unless you give it a different guess) and tweaks it slightly up or down until it gets the correct answer.
2Cor521
__________________
"At times the world can seem an unfriendly and sinister place, but believe us when we say there is much more good in it than bad. All you have to do is look hard enough, and what might seem to be a series of unfortunate events, may in fact be the first steps of a journey." Violet Baudelaire.
|