Results 1 to 13 of 13

Help with XIRR too high

Threaded View

leguicri Help with XIRR too high 08-29-2018, 07:17 AM
alansidman Re: Help with XIRR too high 08-29-2018, 08:17 AM
joeu2004 Re: Help with XIRR too high 08-29-2018, 10:19 AM
leguicri Re: Help with XIRR too high 08-29-2018, 11:10 AM
joeu2004 Re: Help with XIRR too high 08-29-2018, 12:30 PM
leguicri Re: Help with XIRR too high 08-30-2018, 08:28 AM
joeu2004 Re: Help with XIRR too high 08-30-2018, 02:44 PM
joeu2004 Re: Help with XIRR too high 08-30-2018, 02:54 PM
joeu2004 Re: Help with XIRR too high 08-30-2018, 04:15 PM
joeu2004 Re: Help with XIRR too high 08-31-2018, 04:16 AM
leguicri Re: Help with XIRR too high 08-31-2018, 08:54 AM
joeu2004 Re: Help with XIRR too high 08-31-2018, 10:20 AM
leguicri Re: Help with XIRR too high 09-01-2018, 05:04 PM
  1. #1
    Registered User
    Join Date
    08-09-2018
    Location
    N/A
    MS-Off Ver
    2007
    Posts
    5

    Help with XIRR too high

    Hello! I'm from Argentina, so, my apologies if I write it incorrectly.

    I have a problem using XIRR in Excel (and Openoffice Calc)

    When I use this cashflow

    feb-07-2014 -20000
    mar-12-2014 73375.05
    sep-10-2014 4400
    oct-10-2014 4400
    nov-10-2014 4400
    dic-10-2014 4400
    ene-10-2015 4400
    feb-10-2015 4400


    XIRR rate it's too high. It's 175482535%

    Here is another example

    oct-19-2013 -20000,00
    dec-10-2013 5391.00
    dec-16-2013 67782.87
    feb-06-2014 6952.66
    feb-06-2014 3047.34

    In this case, XIRR is 482085%


    What does it mean? It's weird and it doesn't look right.
    What can I do to get a consistent rate? I have a lot of cashflows with that kind of results. Something it's wrong.
    Could somebody help me?

    I ask the same question in mrexcel.com/forum/excel-questions/1068754-help-xirr-something-its-wrong.html


    Thank you!
    Last edited by leguicri; 08-30-2018 at 08:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Rank items in Pivot table from high to low and low to high based on the filter selected
    By jholiday78 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-19-2017, 11:22 AM
  2. High Low Close Chart - How to add High & Low labels
    By stephenedwardbennett in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-23-2015, 06:45 AM
  3. Xirr
    By Bbaury1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2007, 07:31 PM
  4. XIRR: a bug?
    By gummy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2007, 09:48 AM
  5. [SOLVED] xirr
    By john in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-22-2006, 02:10 PM
  6. XIRR in VB
    By Nuraq in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-22-2005, 02:55 PM
  7. [SOLVED] XIRR and IRR
    By Dan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2005, 11:06 PM

Tags for this Thread

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