xirr non-contiguous

  1. 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...
  2. G

    Using the XIRR formula with non contiguous cells

    Hi everyone, I have been stuck on an excel problem for the past few days. I have checked other posts but can not find the answer. My problem is the following: I want to calculate the IRR of a range of cashflows using XIRR (can not use IRR since the cashflows are not evenly distributed). I...
  3. 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...
  4. 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...
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
Top