Showing results:
Displaying 1 - 3 of 3
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...
IRR formula in xls vs. DCF calculated IRR.
I am in a debate over using the IRR formula in .xls and a DCF calculated IRR . For my DCF lets say my WACC is 10%, I discount all of the CF and terminal value back to get a EV of 100M . Then I build a sensitivity table for the points over the CoC (i.e. 11%, 12%, 13% - which I am also call a IRR). I...
or Want to Sign up with your social account?