Results 1 to 7 of 7

XIRR fail -- cash flows alternate between positive and negative

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-05-2014
    Location
    Bay Area
    MS-Off Ver
    Excel 2010
    Posts
    164

    XIRR fail -- cash flows alternate between positive and negative

    Hi - I'm having a hard time determining the IRR on a project with cashflows that are sometimes positive (+) and sometimes negative (-). I understand this is a limitation of the XIRR formula (through google searches), but I can't find a proper alternative to the XIRR formula.
    My challenge is to find the IRR for these irregular and alternating (+/-) cash flows.
    The attached sample workbook shows my problem.
    Thanks in advance for any help!
    Jeff
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. XIRR - naming ranges to include monthly cash flows only
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2020, 05:09 PM
  2. XIRR formula not working when adding extra cash flows
    By lp12345 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2018, 02:23 AM
  3. Replies: 5
    Last Post: 07-09-2017, 03:24 AM
  4. XIRR: Different cash flows but same answer. Why?
    By Guy Hoffman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-24-2007, 11:37 AM
  5. [SOLVED] NPV Calc appears incorrect with a large # of negative cash flows
    By StanJ in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 09:05 PM
  6. [SOLVED] NPV Calc appears incorrect with a large # of negative cash flows
    By MikeW in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM

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