Please solve it in a proper way on excel with all the formulas.

1. You are considering two projects, A and B. Each project will cost $200,000, the WACC is 8.5%, and the projected cash flows are as follows: Year 1 2 Project A $ 12,580 37,733 70,437 88,050 100,625 Project B $90,562 67,920 50,312 36,735 25,156 3 4 5 a. Calculate the payback period, discounted payback, NPV, PI, IRR, and MIRR. If A and B are mutually exclusive, which should be selected? b. Create an NPV profile chart for projects A and B. What is the exact crossover rate for these two projects