1. W

    Dynamic XIRR with zeros the numbers

    Hi all - I am trying to use the xirr function but running into challenges. I am a series’s of dates starting in A1, and series of cashflow in B1. The challenge I am running into is that if I have zeros in the first cell then negative for outflow before inflow starts, excel doesn’t calculate...
  2. J

    Withdrawal or disinvestment when using XIRR

    How does one account for a withdrawal or disinvestment when using the XIRR formula? For example, let's say I put 100K every year in an investment but then in the 5th year I withdraw 200k and transfer it into my bank account. And then starting the next year I continue investing 100k. So does that...
  3. G

    Monthly IRR Calculation for Stock Portfolio

    Hello, all. I'm trying to calculate the IRR (Internal Rate of Return) of a stock portfolio but my cash flow data is monthly. I used both IRR and XIRR but it seems like the way I'm calculating them is wrong. How should I go about calculating the monthly IRR accurately? Since I can't attached...
  4. N

    Need to Reverse XIRR?

    Hello, I've seen similar problems and related (solved) solutions so I don't think what I'm requesting is impossible, but here goes... In the attached you will an XIRR calculated in cell A1 that pivots off of row 1 and row 36. I would like to instead change A1 to a desired XIRR outcome and have...
  5. P

    XIRR with non-contiguous entries for Flows (ranges) and Valuation (single period) based on cutoff date.

    Hello All: I am trying to find a way to calculate the XIRR for many investments over a vast Data Input structure that already exists and which is constantly being updated with new Inputs for the respective investments. The challenge is to find a standard formula that produces XIRR...
  6. K

    Calculate running XIRR for specific account

    Hi, Need help with the below issue. I have a dataset with multiple investment accounts for which I want to calculate the XIRR on a recurring/ongoing basis. Sample data for 2 accounts below Account 1 BCDEFGHI2AccountDateParticularsEmployee Contribution ($)Employer's Contribution ($)Total...
  7. K

    XIRR function with 1 value from another cell

    Hi, I am using Excel 2016 and need help using the XIRR formula for the sample data below: In the above sample data, I want to calculate XIRR in column D. It would be great if I could build the formula like =XIRR ((B$2:B3), C3), (A$2:A3), A3)) but unfortunately excel does not work as per my...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back