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
Bookmarks