ok I have a list of these cash flows:
-500,000
-8,482,710
-578,710
-340,000
-340,000
-340,000
-340,000
-340,000
-1,192,854
-621,427
-1,192,854
-1,764,281
-4,621,417
-4,345,746
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
12,253,733
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
26,731,978
When I do IRR(A1:A68) I get a #DIV/0 error? I've never gotten that before on an IRR? Putting in a guess didn't seem to help, I traced the error and it referred to the first cell but I have no idea what I'm doing wrong. I've used IRR a million times I don't get it.
Thank you,
Brandon
-500,000
-8,482,710
-578,710
-340,000
-340,000
-340,000
-340,000
-340,000
-1,192,854
-621,427
-1,192,854
-1,764,281
-4,621,417
-4,345,746
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
12,253,733
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
26,731,978
When I do IRR(A1:A68) I get a #DIV/0 error? I've never gotten that before on an IRR? Putting in a guess didn't seem to help, I traced the error and it referred to the first cell but I have no idea what I'm doing wrong. I've used IRR a million times I don't get it.
Thank you,
Brandon