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