Transcribed Image Text
Problem Two 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 ofcapital ranges from 0% to 30% by increments of 2%.Expected Cash FlowsExpected Cash FlowsYearProject AProject B0-24,000-11,5001-17,0004,50021,5005,000310,5006,500420,5008,000525,0009,000628,0009,500730,00010,000Calculate each project’s IRR and the crossover rate of the twoprojects.Calculate each project’s MIRR at a cost of capital of 10%.Calculate each project’s regular payback period.Calculate each project’s discounted payback period with a costof capital of 10%.Calculate each project’s profitability index at a cost ofcapital of 10%.Please answer question using excel functions with in cellviewing.