+ Reply to Thread
Results 1 to 1 of 1

XIRR - Array Formula Error

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    XIRR - Array Formula Error

    Hi All -

    I am having an issue when calculating return figures for my portfolio...

    My CFs are setup as follows:
    Column A: Disposition Year
    Column B: CF Dates
    Column C: CF Values

    I am using an array formula to sift through the data to calculate IRRs based on the year the asset was disposed of. My formula works for years with positive returns, but does not for Years 2010 & 2011 when negative returns occurred (yawn!). When I use a positive guess for '10 & '11, the formula produces a 0.0%. When I use a negative guess for said years, the formula produces an error - #NUM. I have attached a sample of my workbook for further reference and my array formulas are below.

    Array Formula (Positive Return Guess):

    Array Formula (Negative Return Guess):

    Thank you for the help!

    Attached Files Attached Files
    Last edited by Dtark513; 01-31-2013 at 04:54 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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