Skip to main content
Solved

IRR Issues

  • August 30, 2023
  • 3 replies
  • 894 views
M
Wallflower
Forum|alt.badge.img+5

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

 

Best answer by Benoit

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

3 replies

Benoit
Community Manager
Forum|alt.badge.img+15
  • BenoitCommunity Manager
  • Community Manager
  • 232 replies
  • Answer
  • September 4, 2023

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

Benoit - Pigment wizard
M
Wallflower
Forum|alt.badge.img+5
  • mmusabWallflower
  • Author
  • Wallflower
  • 14 replies
  • September 6, 2023

@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.

Benoit
Community Manager
Forum|alt.badge.img+15
  • BenoitCommunity Manager
  • Community Manager
  • 232 replies
  • September 11, 2023

Hi,

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

Does this help?

Benoit - Pigment wizard


Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement