ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Problem with IRR function (https://www.excelbanter.com/excel-worksheet-functions/143504-problem-irr-function.html)

Keith
Problem with IRR function
 
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

Niek Otten
Problem with IRR function
 
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

"Keith" wrote in message ...
|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
|



Keith
Problem with IRR function
 
Hi Niek,
thanks very much.
Keith

"Niek Otten" wrote:

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

"Keith" wrote in message ...
|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
|





All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com