Project B is cut out but same blanks as project A. Fill in blanks. Ok excel preferably.

Saved Following Is Information on two alternative Investments being considered by Jolee Company. The company requires a 6% return from Its Investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project A Project B Initial investment $ (181, 325) $ (141, 960) Expected net cash flows in: Year 1 38, 060 42,000 Year 2 52, 090 48, 090 Year 3 80, 295 55,080 Year 4 92, 400 82, 090 Year 5 72, 060 25, 090 a. For each alternative project compute the net present value. b. For each alternative project compute the profitability Index. If the company can only select one project, which should It choose? Complete this question by entering your answers in the tabs below. Required A Required B For each alternative project compute the net present value. Project A Initial Investment 181,325 Chart Values are Based on: % Year Cash Inflow X Py Factor Present Value 38,000 x = 52,000 3 80.295 x 92,400 X 72.000 x Net present value 95.213 Project B Initial Investment S 141.960