- Please note: 1) Use your chapter 9 homework PDF file as the question portion. 2) Use appropriate Excel functions to solve the problems. 3) Please use the cell reference instead of actual numbers in the function. Problem 1: Year Cash flows Cum. Cash flows 0 -25,000 1 5,500 2 8,500 3 9,000 4 15,000 1 Payback Period 2 3 Problem 2: 4 Year Cash flow (A) Cash flow (B) Cum CFS (A) Cum CFs (B) 5 -70,000 -100,000 6 1 48,000 10,000 7 2 25,000 25,000 B 3 15,000 40,000 4 5,000 100,000 Payback period 1 2 Problems 3 & 4: 3 Year Cashflow IRR Req Rate of Return NPV 4 -70,000 11% 5 1 41,000 20% 5 2 20,000 7 3 30,000 should they accept the project if the required rate of return is 14% O