xirr

  1. A

    Help with an XIRR error - #NUM

    Hello, Can anyone identify what the issue is with the XIRR formula in the attached/embedded screenshot? The dates are consecutive. The dates are formatted as 'Date'. The cash flows are formatted as Accounting. The initial cash flow value is negative, representing an investment or cash...
  2. R

    Conditional XIRR with multiple columns for dates / cash flows

    I need a XIRR function that would only compute the XIRR for specific ISINs. This is a picture of a sample file with unnecessary info deleted: <tbody> ISIN DATE OF INVESTMENT DATE OF SALE BUY VOLUME SELL VOLUME US7475251036 18.11. 2015 2421 -385,86 US3546131018 3.12. 2015...
  3. D

    FV, IRR, XIRR Return Differing Investment Results - Why?

    I need to present to others a proposal on investing in some equities and bond funds and discovered that different functions return different results using the same parameters. FV, XIRR, and IRR, and the differences are not small. Here's a test spreadsheet I made that demonstrates the problem...
  4. O

    XIRR Formula when not Cash Flow not Starting in the First Month

    I’ve done a search for solution to my XIRR issue within this board and the web and have not found anything that’s quite the same to help me solve this issue. Thanks in advance for any suggestions, and I will provide feedback on any proposed solutions. To get the answers I have, I modified...
  5. D

    using xirr on dynamic pivot table

    Hello - is anyone able to help with the below without the need for having to create a macro. I have a pivot table with 2 Report filters and 2 columns (Date in column A and cashflow in column B). The 'Row Labels' heading of the pivot is in cell A4 and the date start from cell A5 downwards, with...
  6. H

    What does XIRR tell me exactly?

    Hello all, I am trying to figure out what XIRR tells me exactly, I understand that it is a method used to calculate returns for a project, but in terms of what it actually means I am finding conflicting information from research online. Specifically I want to understand the difference between...
  7. S

    XIRR with non-contiguous last value

    I have been wrestling with a XIRR formula for the past week. I have a table with outflows and fund names for each outflow. I created a XIRR formula that not only takes into a count a specific fund identified in cell F2 but also prevents any XIRR errors when the initial outflow value is 0. The...
  8. K

    XIRR issue

    Why is XIRR 0% for years 2022-2025,but in 2026 its negative? Using a guess does not change the answer. <colgroup><col width="64" style="width: 48pt;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;" span="3"> <col width="69" style="width: 52pt...
  9. L

    Help with XIRR - Something it's wrong

    Hello! My name is Cristian and I'm from Ushuaia, 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...
  10. I

    Problem with XIRR Array formulae using column()

    Hi there, hope someone can help me with this. I've searched previous posts and can find loads of really useful information, but I can;t seem to find a solution to this one :-( Basically I have data in a sheet that is based on dates across the columns and then rows with values that correspond...
  11. T

    How do I create an XIRR function based on unique names and between certain dates?

    I'm trying to create an XIRR function that will calculate the return based on an unique investment names and corresponding cash flows between certain dates. For example, I want to calculate the IRR for Investment A between 01/16/2018 to 5/20/2018 with the following cash flows...
  12. Z

    Dynamic XIRR Function -- I'm Lost

    Hello, I have a series of cash outflows and inflows over 144 months. The first 24 months are cash outflows - the next 120 month cash inflows. My sheet is set up as follows Row 1 - Numbered 1-144 Row 2 - Months (Beginning 8/1/18 thru 144 months) Row 3 - Cash flows Currently my sheet calculates...
  13. M

    Help with IRR vs. XIRR

    Hi, I'm trying to figure out why XIRR and IRR are showing different returns in this case (simple bond math). These are the cash flows: 4/30/2018: -1,000 5/1/2018: 100 5/1/2019: 100 5/1/2020: 100 5/1/2021: 100 5/1/2022: 100+1,000 IRR returns 10%, which makes sense. XIRR returns 13%. Could...
  14. F

    Dynamic XIRR Forumla Help

    Hi everyone, I am trying to create a dynamic XIRR formula as I am working on a case study that involves a sensitivity analysis to see changes exit years. How could I go about writing an XIRR formula that ignores 0's while still calculating the correct XIRR? Below is a cut out from my file. There...
  15. N

    XNPV Result is not 0 when I use the XIRR result as the rate

    I have a stream of cash flows for a financial model that I am building (pasted below). I am trying to calculate the IRR of the Gross and Net lines. For the Gross line, I entered the following formula =XIRR(G19:AD19,G17:AD17,0.5) and I get the result of 47.16%. I then try to verify that XIRR...
  16. R

    XIRR with non-contiguous data

    Although there have been helpful discussions about Excel 2013's XIRR function using non-contiguous cells, I can't get any suggestions to work in my particular situation. Below is an excerpt from a large spreadsheet covering a number of years. It shows some formulas that work and some that don't...
  17. C

    IRR calculation for single outflow and single payment 20 days later?

    So I work for a hedge fund/private equity administrator. We have a client that provided us with a loan portfolio and asked us to provide a spreadsheet showing the IRR for each deal. Simple enough. But all his loans are paid back, with interest, in a single payment within weeks to months. I...
  18. P

    XIRR Reverse lookup?

    Hi, I have a target goal of getting a 20% XIRR return on 3/31/2018. As you can see. My current IRR is -97%. What formula would tell me that I need X amount for 3/31/2018 to reach my goal of getting a exact 20% XIRR? <colgroup><col span="11"><col><col span="4"><col><col...
  19. J

    XIRR Question

    Hello, I am using a XIRR formula to calculate cash flows at different dates for multiple investments but for a reason that I ignore, the last investment (the 50th of many) I entered returned me a #NUM error as the IRR will be negative. But the same exact formula was used to calculate negative...
  20. P

    XIRR Question

    I am trying to create an XIRR table that can give me a returns on a certain number of periods (months). The IRR works 12 months at a time. For example if I did a $1,333,500 investment and over 3 years (table on the right) I would get a IRR of 20.4% But what I am trying to figure out if the 3...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top