Please solve using excel and show all work thank you

Problem Five (20 marks) You have been asked to analyze two mutually exclusive projects. Expected Cash Flows Expected Cash Flows Year Project A Project B 0 -191,000 -48,500 1 -101,000 14,500 2 -24,500 16,000 3 41,500 18,550 4 100,500 22,000 5 132,500 23,500 6 177,000 25,500 7 212,000 28,000 8 275,000 35,000 a) Construct the NPV profiles for Project A and Project B. (Note: plot the NPVs of both projects on the same graph.) The cost of capital ranges from 0% to 30% by increments of 2%. b) Calculate each project's IRR c) Calculate the crossover rate of the two projects. d) Calculate each project's MIRR at a cost of capital of 14% and reinvestment rate of 10%. e) Calculate each project's regular payback period. f) Calculate each project's counted payback period with a cost of capital of 14%. Calculate each project's profitability index at a cost of capital of 14%. h) Calculate each project's NPV at a required rate of return of 14%. i) Calculate each project's NPV at a required rate of return of 28%. Problem Five (20 marks) You have been asked to analyze two mutually exclusive projects. Expected Cash Flows Expected Cash Flows Year Project A Project B 0 -191,000 -48,500 1 -101,000 14,500 2 -24,500 16,000 3 41,500 18,550 4 100,500 22,000 5 132,500 23,500 6 177,000 25,500 7 212,000 28,000 8 275,000 35,000 a) Construct the NPV profiles for Project A and Project B. (Note: plot the NPVs of both projects on the same graph.) The cost of capital ranges from 0% to 30% by increments of 2%. b) Calculate each project's IRR c) Calculate the crossover rate of the two projects. d) Calculate each project's MIRR at a cost of capital of 14% and reinvestment rate of 10%. e) Calculate each project's regular payback period. f) Calculate each project's counted payback period with a cost of capital of 14%. Calculate each project's profitability index at a cost of capital of 14%. h) Calculate each project's NPV at a required rate of return of 14%. i) Calculate each project's NPV at a required rate of return of 28%