HI,

I've got a series of numbers in a row from which I need to know the IRR.

Because the first number is positive the function is returning the #DIV0
error.

Can anyone tell me how to get round this?

Thanks

David

Correct me if i'm wrong but it is suppsed to always be negative right? If
that is the case and you are just wanting positives to turn to negatives
throw this in =IF(A10,A1*-1,A1)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

HI,

I've got a series of numbers in a row from which I need to know the IRR.

Because the first number is positive the function is returning the #DIV0
error.

Can anyone tell me how to get round this?

Thanks

David

John,

Normally I'd agree but I work for a University and it's never that simple!

The plan is expected to produce more students, therefore more cash, before
the new building is complete. Hence the positive figure in year 0.

Any way around this?

"John Bundy" wrote:

Correct me if i'm wrong but it is suppsed to always be negative right? If
that is the case and you are just wanting positives to turn to negatives
throw this in =IF(A10,A1*-1,A1)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

HI,

I've got a series of numbers in a row from which I need to know the IRR.

Because the first number is positive the function is returning the #DIV0
error.

Can anyone tell me how to get round this?

Thanks

David

hmm, not sure, reading tells me for IRR you have to have a negative but try
here for possible solutions
http://www.exceluser.com/solutions/irr.htm

http://exceltips.vitalnews.com/Pages..._Function.html

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

John,

Normally I'd agree but I work for a University and it's never that simple!

The plan is expected to produce more students, therefore more cash, before
the new building is complete. Hence the positive figure in year 0.

Any way around this?

"John Bundy" wrote:

Correct me if i'm wrong but it is suppsed to always be negative right? If
that is the case and you are just wanting positives to turn to negatives
throw this in =IF(A10,A1*-1,A1)

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"David" wrote:

HI,

I've got a series of numbers in a row from which I need to know the IRR.

Because the first number is positive the function is returning the #DIV0
error.

Can anyone tell me how to get round this?

Thanks

David

David wrote:
I've got a series of numbers in a row from which I need to know the IRR.
Because the first number is positive the function is returning the #DIV0 error.

IRR() requires that __some__ cash flows be negative and positive, but
it does __not__ require that the first cash flow be negative. For
example, IRR({2000,-10000,4000,5000}) works just fine (in Office Excel
2003).

In my experience, the #DIV/0! error usually has the same meaning as the
#NUM! error, namely: the IRR() algorithm hit a divide-by-zero
condition before it (would have) exhausted the iteration limit of
20(!).

The remedy might be to pick a good "guess", the 2nd IRR() parameter.

However, that does not always work, either. For example,
IRR({-2000,10000,4000,5000}) produces 445.10%, but
IRR({10000,-2000,4000,5000},guess) refuses to provide a solution, even
when I provide it (-158.34%!) in the "guess" parameter.

(I determined the solution manually by using the sum of the PV's and
trial rates.)