1) calculate the following using Excel

Calculate the NPV for each project and determine which project should be accepted. CF +- NPV =-C& +-+-+-+ accept if NPV0 reject if NPV0 Project A Project B Project C Project D Initial Outlay Inflow year 1 Inflow year 2 Inflow year 3 Inflow year 4 Inflow year 5 Rate NPV = (105,000.00) 53,000.00 50,000.00 48,000.00 30,000.00 35,000.00 (99,000.00) 51,000.00 47,000.00 41.000.00 52,000.00 40,000.00 (110,000.00) 25,000.00 55,000.0 15,000.00 21,000.00 35,000.00 (85,000.00) 45,000.00 50,000.00 30,000.00 62.000.00 68,000.00 14 18 796 10% 13% 1896 21 Answer 23 27 28