On Thu, 22 Jan 2009 14:21:01 -0800, gotahavit
wrote:

I have a question regarding IRR.
I am trying to figure out the IRR for an investment (actually, this has come
up a number of times in the past). Unfortunately, it is not one of those
simple cases where the initial investment is negative and all subsequent cash
flows are positive. There are a couple of times when the cash flow signs
switch. I understand the multiple IRR issue, but it still doesn't help that I
cannot get a return number from Excel.
I have to imagine that these cases, where the negatives and positives switch
more than once, is common. It is difficult to just say "well, there is no
IRR". I still need to know what the rate of return would be. What can I do?
Please help.

Thanks.

Why do you think there is a requirement for Excel's IRR function that it must
be the case that "the initial investment is negative and all subsequent cash
flows are positive." ??

What does "cannot get a return number from Excel" mean? Do you get a blank? Do
you get an Error message? If so, what is the message or error value?

HELP states that there must be at least one positive and one negative cash
flow; but I see no requirement there such as you write. And I've analyzed
numerous cash flows where the "signs switch".

Either you are using an inappropriate "guess", or there is something peculiar
about the values you are using. But without more specific information, it
would be difficult to advise you further.
--ron