+ Reply to Thread
Results 1 to 2 of 2

Issue with IRR Calculation

  1. #1
    Registered User
    Join Date
    07-05-2019
    Location
    Alaska
    MS-Off Ver
    2016
    Posts
    1

    Issue with IRR Calculation

    Having an issue calculating the adjusted net IRR.

    I have attached a side by side comparison of adjusted versus unadjusted.

    The residual value of the investments is the only thing that changes. The adjusted value is ~$3MM more but for some reason, the IRR isnít changing at all. Any ideas what is going on?
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,363

    Re: Issue with IRR Calculation

    FRom others on this forum more knowledgeable than me, I have learned that Excel's XIRR() function has some numerical instabilities in it that cause it to return incorrect results in some cases. That 2.98E-9 result is one indication that the XIRR() calculation is not converging on the correct result. If I enter an optional "gues" to your XIRR() function =XIRR(current argument, currentargument,-.5), then I get the XIRR() functions to return -1.55% and -3.34% (I did this in Gnumeric and LO Calc -- I know I have seen Excel's XIRR() function be less stable than these other spreadsheets). From what I can tell, any time you get that 2.98E-9 result, that tells you that you need to supply a "guess" argument, until you find a suitable value that allows Excel's XIRR() to calculate the true rate of return.

    see discussion here: https://www.excelforum.com/excel-gen...ml#post4809641
    https://www.excelforum.com/excel-for...ml#post4831063

    See if that helps.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculation Issue
    By Imran Shaikh001 in forum Excel General
    Replies: 7
    Last Post: 04-09-2017, 11:31 AM
  2. Calculation Time is an issue.
    By aashishkr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2015, 06:17 AM
  3. Excel 2007 : Calculation issue?
    By Hotte in forum Excel General
    Replies: 6
    Last Post: 09-27-2011, 05:58 AM
  4. Calculation issue with zero
    By Edscuda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2011, 10:16 AM
  5. Calculation Issue
    By eddiesvoicebox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2009, 08:14 AM
  6. Strange Calculation issue
    By LACA in forum Excel General
    Replies: 1
    Last Post: 06-18-2006, 04:20 AM
  7. calculation issue?
    By JKC in forum Excel General
    Replies: 6
    Last Post: 03-21-2006, 09:30 AM

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