fx B G D E F H Consider the following two mutually exclusive projects. Whichever project you choose, it any, you require a return of 15 percent on your investment $ $ Annual cash flows: Year 0 Year 1 Year 2 Year 3 Year 4 A (350,000) 45,000 65,000 65,000 440,000 $ $ $ $ B (50,000) 24,000 22,000 19,500 14,600 $ Required return 15% Complete the following analysis. Do not hard code values in your calculations. What is the NPV of each project? NPV of Project A NPV of Project B 32,589.76 8,673.89 $ What is the IRR of each proiect? Sheet1 G Year 4 H $ le 440,000 14,600 Required return 15% Complete the following analysis. Do not hard code values in your calculations. What is the NPV of each project? NPV of Project A NPV of Project B $ $ 32,589.76 8,673.89 What is the IRR of each project? IRR of Project A IRR of Project B