These two pictures are one question and related ?

could you answer it with formulas in cells ? Thank you

1 BA213 Ch 11 Capital Analysis - Excel problem 3 4 Instructions: Read the Problem Data and complete the calculations section. Enter data in the blue cells and formulas in the yellow cells. Gray cells require no entry. 5 6 7 8 9 10 Problem Data 11 12 The plant manager of ABC Manufacturing is considering the purchase of new automated assembly equipment. 13 14 New Equipment Cost 1,200,000 15 Direct Labor Cost savings 16 Year 1 195,000 17 Year 2 225,000 18 Year 3 300,000 19 Year 4 362,000 20 Year 5 251,000 21 Year 6 187,500 22 Year 7 95,000 23 24 25 26 Calculations 27 28 1. What is the payback period on this project? 29 Annual Cash Flow Cumulative Cash Flow 30 31 Year o enter a formula to compute the answer in yellow cells 32 Year 1 enter data in blue cells 33 Year 2 34 Year 3 35 Year 4 36 Year 5 37 Year 6 Year 7 38 39 payback occurs in approximately how many years and months? 40 41 42 2. What is the Net Present Value, assuming a 6% rate of return? 43 44 45 46 3. What is the Internal Rate of Return on this project? 47 48 49 50 4. Should this project be accepted? 51 52 use the "F" formula to answer this question 53 54 55