+ Reply to Thread
Results 1 to 2 of 2

XIRR and negative IRRs

  1. #1
    dave in Toronto
    Guest

    XIRR and negative IRRs

    I had a series of CF's that should produce a negative IRR (uisng the XIRR
    function).
    However, the excel XIRR answer always goes to 0.00%.
    When I force to periodic payments and use IRR funciton I do get a negative
    IRR answer.

    Is this a XIRR issue?


  2. #2
    Fred Smith
    Guest

    Re: XIRR and negative IRRs

    No, XIRR will quite happily produce a negative return.

    Post your data so we can help you out solving the problem.

    --
    Regards,
    Fred


    "dave in Toronto" <daveinToronto@discussions.microsoft.com> wrote in message
    news:91F1DFDC-7640-4403-B007-D46C36125F3C@microsoft.com...
    >I had a series of CF's that should produce a negative IRR (uisng the XIRR
    > function).
    > However, the excel XIRR answer always goes to 0.00%.
    > When I force to periodic payments and use IRR funciton I do get a negative
    > IRR answer.
    >
    > Is this a XIRR issue?
    >




+ 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