Solved

IRR Issues

• 3 replies
• 557 views

Userlevel 3
+4
• Budding Pigmenteer
• 13 replies

Hi Team

I need to compute cell by cell XIRR . So for example, first IRR will be calculated from FY21 to FY 22, FY21 to FY 23 . them FY21 to FY24 and goes on and on. Is there a way to achieve this?

So its an expanding calc starting with FY21 and keeps on expanding by brining in additional year.

Thanks

Musab

icon

Best answer by Benoit 4 September 2023, 14:38

View original

3 replies

Userlevel 6
+12

Hi Musab,

Sorry, I’m not sure to totally understand your need.

What is the calculation you’d like to make?

Is it:
FY21 = FY21
FY22 = FY21 + FY22
FY23 = FY21 + FY22 + FY23
?

If it’s an addition, I believe you can cumulate the results?

If I did not get it, can you make an example please?

Thanks

Userlevel 3
+4

@Benoit , no thats not what i need.

Dates matter when it comes to IRR and what i need is IRR should be an expanding calc.

FY22 = FY21  and  FY22 ( IRR 8%)
FY23 = FY21  and FY22  and FY23 ( IRR 9%)

so we dont really need to add it but just need to include those as an item when it comes to IRR.

Userlevel 6
+12

Hi,

I believe you can try to use the IRR and XIRR functions maybe:

Does this help?