Please show how to do this on excel

5. In mutually exclusive projects with conflicting NPV and IRR rankings you have to sacrifice the NPV if you chose the project based on the highest IRR. Your cost of capital is 10 percent. How much value will your firm sacrifice if it selects the project with the higher IRR? (Hint: Remember that value is measured by NPV). Project A: Project B: A $86.36 C) $32.50 2 3 1,100 2 3 4 5