I CANNOT SOLVE USING EXCEL SO PLEASE DO NOT SOLVE USUINH EXCEL!

(10-13) Cummings Products is considering two mutually exclusive investments whose expected NpV and IRR net cash flows are as follows: Analysis EXPECTED NET CASH FLOws Year Project A -$400 -528 -219 -150 1,100 820 990 -325 Project B -$650 210 210 210 210 210 210 210 4 a. Construct NPV profiles for Projects A and B b. What is each project's IRR? C. If each project's cost of capital were 10%, which project, if either, should be selected? If the cost of capital were 17%, what would be the proper choice? d, what is each project's MIRR at the cost of capital of 10%? At 17%? (Hint: Consider Period 7 as the end of Project B's life) e. What is the crossover rate, and what is its significance