I would like to calculate the IRR of multiple different projects, I try to take array of cashflow and dates of different projects, then using XIRR, but XIRR can only calculate continuous data. Below is a simplify sample, I can manually put all the data of one project together, but I can't do that if there are hundreds project. Is there any method to calculate the IRR of different projects? Thanks for help!
<tbody>
</tbody>
A | B | C | D | E | F | |
1 | Dates | Projects | Cashflow | Projects | IRR | |
2 | 1/1/18 | A | -100 | A | ? | |
3 | 1/2/18 | B | -120 | B | ? | |
4 | 1/3/18 | C | -50 | C | ? | |
5 | 1/4/18 | D | 2 | D | ? | |
6 | 1/5/18 | B | 24 | |||
7 | 1/6/18 | C | 29 | |||
8 | 1/7/18 | A | 21 | |||
9 | 1/8/18 | D | 29 | |||
10 | 1/9/18 | B | 9 | |||
11 | 1/10/18 | A | 1 | |||
12 | 1/11/18 | C | 23 | |||
13 | 1/12/18 | D | 20 | |||
14 | 1/13/18 | B | 25 |
<tbody>
</tbody>