In: Finance
Year | Cash Flow (X) | Cash FLow (Y) |
0 | -23000 | -23000 |
1 | 10490 | 12000 |
2 | 10900 | 9360 |
3 | 10500 | 10400 |
Calculate the IRR for each project.
What is the crossover rate for these two projects?
Solution :
The IRR of project X is = 18.29 %
The IRR of project Y is = 18.62 %
The crossover rate for these two projects is = 8.11 %
Please find the attached screenshots of the excel sheet containing the detailed calculation for the solution.