please answer using excel and show excel functions used

Lease or purchase? Note: Support your answer with detailed work. You can use the blank space in this worksheet to show your work Discount rate 12% Year Project A Project B 0 500 500 1 180 200 2 175 250 160 . 170 4 100 25 5 100 30 NPV IRR Which project is preferred if you rank by NPV? Which project is preferred if you rank by IRR? crossover rate Discount rate, r 10% NPV IRR(1) IRR(2) Should you take the project or reject it? Part d: to decide on a range of cost of capital to accept/reject, make a table of NPV for different r