please include excel formulas

Question#3 You observe the following project in the market. Assume your cost of capital is 10% A) Should you take or reject this project? B) Calculate the NPVs of each hypothetical discount rate. C) What is the range of cost of capital for which should take the project? covered workbooks? Your recent changes were saved. Do you want to continue wa =NPV(B1,04:04)-84 37 B C F A Discount rate, G H 10% + 3 0 -150 1 1,000 2 -1,000 100 307.78 8.40% NPV 22 3 Year 4 Cash flow 5 6 A) 7 NPV BIRR 9 Take or reject? 10 11 12 B) 13 NPV chart 14 Discount rate 15 0% 16 10% 17 20% 18 30% 19 40% 20 50% 21 60% 70% 23 80% 24 90% 25 100% 26 110% 27 120% 28 130% 29 140% 30 150% 31 175% 32 200% 33 225% 250% 35 275% 36 300% 37 325% 38 350 39 3759 40 400% 41 425% 42 450% 475% 50014 45 5254 46 47 Questions Question 4 Question 2 Group Members Question 1 D