I need to see the Excel formulas used to do this. The answer to the payback period fkr project A is 3.90, the answer to NPV of project B is $23788.87 and MIRR of project A is 11.50%

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: 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