Showing results:
Displaying 1 - 3 of 3
Why do we still have NPV / IRR vs XNPV / XIRR?
The question that always lingered without anyone finding the solution: NPV does a limited function of XNPV IRR does a limited function of XIRR Why has Excel not got rid of NPV / IRR function? Are they useful for anything?
Is there an IRR formula
I am told there are no IRR formulas when number of cash flows excess 5 Is it so? Is there an IRR formula to find internal rate of return when number of cash flows exceed 5? For example, is it possible to find IRR of the following investment using a "formula" rather than "iterative methods" -100, 50,...
Finding an alternative investment that has the same IRR
If one is given a set of cash flows that are in uneven amounts, is there a way to find an alternative investment (one that has a different set of uneven cash flows) that has the same IRR - internal rate of return as that of the original investment. For example Investment A -100, 50, 40, 30, 10...
or Want to Sign up with your social account?