the plant manager of XYZ electronics is considering the purchase of new automated assembly equipment

Format Painter B r u, Clipboard - Font Alignment C33 12 The plant manager of Z Electronics is considering the purchase of new automated assembly equi uipment. 13 14 New Equipment Cost1,195,000 15 Direct Labor Cost savings 16 Year 1 17 Year 2 18 Year 3 9 Year 4 20 Year 5 21Year 6 22Year 7 210,000 252,000 10,000 346,000 265,000 197,000 100,000 25 2 6 Calculations 8 1. What is the payback period on this project? Annual Cash Cumulative Cash Flow Flow 31 Year 0 Year 1 Year 2 1,195,000 32 nwdatain bie cals 252,000EE 310,000 36 37 38 Year 4 Year 5 Year 6 Year 7 265,000 197,000 100,000 payback occurs in approximately how many years and months? Ch 10 Excel Problem Ready O Type here to search di e Ma C33 Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 31 1,195,000 210,000 252,000 310,000 346,000 265,000 197,000 100,000 antar a kmatomour the nelour zoll 32 erdata in bia vels 34 35 36 37 38 39 payback occurs in approximately how many years and months? 40 41 4212. what is the Net Present Value, assuming a 9% rate of return? 43 uth NeVfunction in Excelto soe tis probiem 45 46 47 3. What is the Internal Rate of Return on this project? 48 theIRR function in Excelo sohe this problem 49 50 51 52 4. Should this project be accepted? 53 54 use the "IF" formula to answer this question 56 57 58 59