Need Help with Irregular IRR function

  • Thread starter Thread starter jordanlawman83
  • Start date Start date
J

jordanlawman83

I am doing a big project for work that requires inputing a whole bunc
of irregular cash inflows and outflows over a period of about 3 years.

I tried ordering all the cash flows chronologically so that it woul
look like:

Date Cash Flow

and the outflows were negative, inflows were positive.

I thought I covered all the possible problems, but I was wrong becaus
Excel kept telling me that when i selected all the values, (Cash Flo
and/or date) I had an error because I was dividing by Zero. I trie
taking out all the zero values for cash flow, but still I got the sam
result.

I didn't attempt a guess, because I am not sure what that would do.

Help!!!

Jorda
 
I am doing a big project for work that requires inputing a whole bunch
of irregular cash inflows and outflows over a period of about 3 years.

I tried ordering all the cash flows chronologically so that it would
look like:

Date Cash Flow

and the outflows were negative, inflows were positive.

I thought I covered all the possible problems, but I was wrong because
Excel kept telling me that when i selected all the values, (Cash Flow
and/or date) I had an error because I was dividing by Zero. I tried
taking out all the zero values for cash flow, but still I got the same
result.

I didn't attempt a guess, because I am not sure what that would do.

Help!!!

Jordan
Click to expand...

The values that you are using, and the function that you are using would both
be useful information in trying to help you with your problem.

Absent that information, have you tried to use the error tracing tool?


--ron
 
Hi Jordan!

I'll back Ron's comment on needing data.

The most common cause of #DIV/0! is the wrong signage of the cash
flows. But you can get it with very large differences between the
(absolute) sums of negatives and positives.

Also with dates available as well I'd go for XIRR rather than IRR any
day.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top