I need the answer for the NPV of projects A and B. Please let me know what to type in exactly for excel. For example =IRR, F6

F20 A B Consider the following two mutually exclusive projects. Whichever project you choose, if any, you require a return of 15 percent on your investment. Annual cash flows: S (350,000) (50,000) $ 45,000 S S 65,000 Year 0 Yer 1 Year 2 22,000 Year 3 Year 4 14,600 S440,000 $ 10 15% 12 Required return 13 14 15 Complete the following analysis. Do not hard code values in your calculations 16 What is the NPV of each project? 17 18 NPV of Project A NPV of Project B 19 20 21 Sheet! rm Paper Che...docx