Hello:

With the numbers you gave for the first one trying all rates from
-90% up to 2060% there is no answer. That's what the #num is
telling you. Why? For the same reason you will not
be able to find the value of X in the following:

6X^2 - 10X + 5 = 0

Look up Descartes rule of signs. There are 6 sign changes.
Therefore the solution may have as many as 6 answers or as few as zero.

Pieter Vandenberg

wrote:
: I am trying to calculate a few IRRs that are returning #NUM. I can't
: figure out why. I've been trying different guesses and I've been
: tweaking the number of iterations and max change in Tools | Options |
: Calculation, and yet I still get #NUM. Can anyone take a look and
: figure out what I'm doing wrong?

: Here are the three cash flows for which I can't get an IRR:

: Cash Flow 1:
: $ (14,038,400) $ 9,419,009 $ (172,248) $ 6,172,725
: $ (269,064) $ 2,955,516 $ (269,064) $ (5,730,809)
: $ (79,376)


: Cash Flow 2:
: $ (9,826,880) $ 6,500,691 $ (120,573) $
: 4,433,082 $ (188,344) $ 2,391,228 $ (188,344) $
: (4,011,566) $ (55,563)


: Cash Flow 3:
: $ (4,211,520) $ 2,918,318 $ (51,674) $
: 1,739,643 $ (80,719) $ 564,288 $ (80,719) $
: (1,719,243) $ (23,813)


: I would REALLY appreciate any help anyone could provide!
:
: Thanks in advance,
: Adam Sinclair