Problem with IRR function

G

Guest

I am attempting to use the IRR function with a series of 121 payments. The
first is positive, and all others are negative. When entering the function,
the result displays as #NUM! I rechecked, and all are numbers. What's going
on.

I've pasted the numbers below for anyone who would like to try this. Note
that the first payment is larger than the others. The first part of the
series,
10,000, -309, -175 is as intended.

I wonder what is going on, and how I can make this work.

Thanks very much.

10,000
-309
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
-175
 
N

Niek Otten

Hi Keith,

If you supply a guess of 2% as the second argument to the IRR you'll probably get the right answer

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am attempting to use the IRR function with a series of 121 payments. The
| first is positive, and all others are negative. When entering the function,
| the result displays as #NUM! I rechecked, and all are numbers. What's going
| on.
|
| I've pasted the numbers below for anyone who would like to try this. Note
| that the first payment is larger than the others. The first part of the
| series,
| 10,000, -309, -175 is as intended.
|
| I wonder what is going on, and how I can make this work.
|
| Thanks very much.
|
| 10,000
| -309
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
| -175
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
IRR, with cash flows in non-adjacent cells 6
A #DIV/0! With IRR Function 2
IRR Guess Problem 4
IRR 2
IRR - #NUM error 1
excel payments functions 2
Textbox - IRR calculation with VBA 0

Top