Work in Excel Consider the following projects Project A requires an Inital investment of $200,000. It will generate cash flows of $50,000 for 3 years, $30,000 for 4 years, and $10,000 for 2 years. Prgect B requres an initial investment of $200,000. It will generate cash flows of $60,000 for 2 years, $20,000 for 5 years, and $40,00 for 2 years Pigect A+ B have an appropriate cost of capital of 6% A) Calculate the NPV +IRR for each of these projects Project NPV IRR B B) If project A+B are independent, which one (5) will you undertake? Why? c) If project A+B are mutually exclusive, which one (5) will vw undertake? Why