Problem with IRR function

K

Keith

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

Why won't th unhide function work?? 7
Formula Refresh Problem 2
Cell identification for a 'lookup' 4
Multiple chart creation using multiple series in the same row 1
Excel - match problem 1
Complicated Sum Product Function 0
Problem Resetting Data Source Ranges via VBA 0
Slightly Urgent: Problem Resetting Chart Value Ranges 4

Top