# Irr

1. ## Irr

I have a table containing net cash flows and i would like to find the IRR value. The figures that are being used are

-3994000
-3734000
-2814000
-1114000
2586000

I cannot seem to get a figure to appear in the IRR box, it simply shows #NUM!

Can anyone help????

Thanks

2. ## Re: Irr

Have you selected the complete range of numbers in the function.??
I get 35%!!

3. ## Re: Irr

Being an engineer, I have no idea what the result means, but I got -44% as a result from your data.

The guess part of the IRR fuction is what seems to be important as the default guess value is 10% while your result is -44%. Here is an exerp from the help file.

Guess is a number that you guess is close to the result of IRR.

-Microsoft Excel uses an iterative technique for calculating IRR. Starting with guess, IRR cycles through the calculation until the result is accurate within 0.00001 percent. If IRR can't find a result that works after 20 tries, the #NUM! error value is returned.
-In most cases you do not need to provide guess for the IRR calculation. If guess is omitted, it is assumed to be 0.1 (10 percent).
-If IRR gives the #NUM! error value, or if the result is not close to what you expected, try again with a different value for guess.

I entered a guess of -30% and the the -44% result was returned.
=IRR(A1:A5,-30%)

Hope this helps.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1