Anaplan IRR different from Excel IRR results.
Answers
-
I replicated the same with just a small correction, and it is giving the results now.
Formula: IRR('SYS: Transactions 1.0 Module'.Cashflows, 'SYS: Transactions 1.0 Module'.Date, 'Transactions 1.0 #', -0.1)
Write the formula in a similar way and mention -0.1 in the last and instead of Transaction 1.0 list, use the list that you used in SYS: Transactions Module.
0 -
Thanks. You are trully a hero. How much trade off will this have? i.e. how much off will this be for 0.1
0 -
I just tried it on my full (blown) model: a -0.1 factor doesn't work (has no impact). It works when i set it at 0.2 or beyond. However it's far off. (like giving me IRR of 80%)
Can i say this is owing to something related to Anaplan's computing power is lacking? (Can't use such a low estimation factor for a huge model like mine)
0 -
As you can see here. a -0.1 factor anaplan will give up calculating. When I set it to -0.3 it gives us a value but i don't know how much i can trust this number.
0 -
Also, it seems that using the estimation will cause some previously correctly calculated IRRs blowing up.
0 -
Resurfacing this. Please help
0