*PLEASE PROVIDE ALL SOLUTIONS USING MICROSOFT EXCEL WITH ANY RELEVANT FORMULAS, thank you!*

If the cost of capital is 15%, which project should be chosen? If the cost of capital is 25% which project should be chosen? 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% Expected Cash Flows Expected Cash Flows Year Project A Proiect B -24,000 17,000 1,500 10,500 20,500 25,000 28,000 11,500 4,500 5,000 6,500 8,000 9,000 9,500 10,000 0 6 7 a) Calculate each project's IRR and the crossover rate of the two projects b) Calculate each project's MIRR at a cost of capital of 10% c) Calculate each project's regular payback period d) Calculate each project's discounted payback period with a cost of capital of 10% e) Calculate each project's profitability index at a cost of capital of 10%