Problem with XIRR function returning #NUM!

  • Thread starter Francois_Provost
  • Start date
F

Francois_Provost

Thanks Myrna.

Unfortunately, I've tried to specify the 3rd parameter (the guess), and
it doesn't work. However, if I change some of the "early" dates in the
cash flow to put them later in time, it does give me a result.
Obviously, this is of no use to me because it does not reflect
real-life events, but I was just curious to see if eliminating a
"large" gap in the cash flow (4.5 years) could make XIRR work properly.
I guess that this is not a bug in Excel XIRR function, but some
incapacity of the "Newton algorithm" to complete properly in this kind
of situation. In any case, thanks for your help.

François
 
M

Myrna Larson

I have coded the XIRR algorithm in VB, and in fact it runs a bit faster than
the one in the ATP. If you send me your data, I will see if it can handle this
data set.

myrna larson @ charter . net

without the spaces.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
Better Understanding of XIRR 4
Problem with XIRR function returning #NUM! 1
XIRR problem 4
Unexplainable XIRR #NUM! Error 3
XIRR Problem 4
XIRR Function - #NUM error 4
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9

Top