c. To find the crossover rate, we subtract the cash flows from one project from the cash flows of
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find
that:
13. The IRR is the interest rate that makes the NPV of the project equal to zero. The equation to
calculate the IRR of Project X is:
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:
For Project Y, the equation to find the IRR is:
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:
To find the crossover rate, we subtract the cash flows from one project from the cash flows of the
other project, and find the IRR of the differential cash flows. We will subtract the cash flows from
Project Y from the cash flows from Project X. It is irrelevant which cash flows we subtract from the
other. Subtracting the cash flows, the equation to calculate the IRR for these differential cash flows
is:
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:
The table below shows the NPV of each project for different required returns. Notice that Project X