+ Reply to Thread
Results 1 to 2 of 2

xirr function

  1. #1
    john
    Guest

    xirr function

    If the data is organized as follows, how do I adjust the XIRR formula (or
    format of the data) to produce a CAGR ?

    2008 2009 2010
    NS 100 200 350

    Must the year row include m/d/y format only ?

    Thanks,

  2. #2
    Fred Smith
    Guest

    Re: xirr function

    You don't use XIRR. Use IRR.

    By the way you will need to have at least one negative cash flow to get a
    result. The data you have says you are receiving $100 in 2008, $200 in 2009 and
    $350 in 2010. But how much did you invest, and when did you invest it? You'll
    have to tell IRR (and XIRR for that matter) that before it can calculate a
    result.

    --
    Regards,
    Fred


    "john" <john@discussions.microsoft.com> wrote in message
    news:16E1DAEF-BD7C-4900-B12B-01F67D152FBF@microsoft.com...
    > If the data is organized as follows, how do I adjust the XIRR formula (or
    > format of the data) to produce a CAGR ?
    >
    > 2008 2009 2010
    > NS 100 200 350
    >
    > Must the year row include m/d/y format only ?
    >
    > Thanks,




+ 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