do not do in excel solve by the formula

b) What is the payback period on each of the following projects? (10 Marks) Project A B Time 0 -5,000 -1,000 -5,000 Cash Flow in Dollars 1 2 3 +1,000 +1,000 +3,000 0 +1,000 +2,000 +1,000 +1,000 +3,000 4 0 +3,000 +5,000 1) Given that you wish to use the payback rule with cut off period of 2 years, which project will you accept? 2) If you use a cut off period of 3 years, which projects would you accept? 3) If the opportunity cost of capital is 10%, which projects have positive NPVs? I 4) "Payback gives too much weight to cash flows that occur after the cutoff date" - Do you agree with this statement. Please explain in short