please input what you would type into each cell to get your answer

B D E 1 w N Question 1. A project has an initial cost of $800 and will generate a $200 cash inflow at the end of year 1, a $224 cash inflow at the end of year 2, a $188 cash outflow at the end of year 3, a $989 cash inflow at the end of year 4, and a $59 cash inflow at the end of year 5. The discount rate is 8%. 4 5 6 Please use Excel to calculate the NPV, IRR, Payback period, Discounted payback period, and Profitability Index of the project. 7 8 9 10 Note: keep two decimal places for the results of NPV, IRR, Payback period, Discounted payback period, and Profitability Index. (E.g. NPV is 10.58, and IRR is 23.22%) 11 (All the cells in Question 1 are equally weighted) 12 13 14 15 Discount rate 16 17 Year Cash Flow 18 19 0 1 2 3 20 21 22 4 23 5 24 25 26 27 28 NPV IRR Payback period Discounted payback period Profitability index 29 30