+ Reply to Thread
Results 1 to 3 of 3

Irr

  1. #1
    Registered User
    Join Date
    03-25-2009
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    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. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Irr

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

  3. #3
    Registered User
    Join Date
    03-24-2009
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    25

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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