PLEASE READ INSTRUCTIONS BEFORE DOING: show work..dont answer must show values directly in cells. formulas

2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. D3 G H t Calculate the NPV for each project and determine which project should be accepted 2. Please show vour work in the cells Use Excel formulas instead of writing the values/answers directly in the cell he instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropriate) CF2 + CF + (1 + r) CF (1 + r) NPV =-CF + + (1+ r) (1 + r) accept if NPV> 0 reject if NPV 0 10 Project C (110,000.00) Project B Project D Project A 11 (85,000.00) 45,000.00 50,000.00 30,000,00 62,000.00 Initial Outlay Inflow year 1 Inflow year 2 (105,000.00) 53,000.00 50,000.00 48,000.00 (99,000.00) 51,000.00 47,000.00 12 25,000.00 13 55,000.00 34 41.000.00 15,000.00 Inflow vear 3 15 Inflow year 4 30,000 00 52,000.00 21,000.00 35,000.00 16 40,000.00 68,000.00 18% Inflow vear 5 35,000.00 17 Rate 7% 10% 13% 18 NPV= 19 20 21 Answer: 22 23 24 25 26 27 28 290 30 Problem 1 NPV Problem 3 WACC Instructions Problem 2 Payback Ready Count 2 2:14 Type here to search W 6/20 File Home Insert Draw Page Layout Formulas Data Review O Search View Help G13 C F G K 1 Calculate the NPV for each project and determine which project should be accepted. 2. Please show your work in the cells, Use Excel formulas instead of writing the values/answers directly in the cell. 4 The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria CF CF (1+ r) CF CF (1+ r" 5 -CFo NPV= (1 + r) (1 + 6 7 accept if NPV> 0 reject if NPV