please add the details of the spreadsheet

Assignment 5-5 (Please do it with spreadsheets and attach them): Refer to Example 5-13. Create a single spreadsheet that calculates PW, FW, AW, IRR, and ERR for the proposed investment. Assume that e MARR 20% per year. Does your recommendation change if the MARR decreases to 18%? Increases to 22%. Evaluation of New Equipment Purchase, Using the Internal -13 Rate of Return Method (Example 5-1 Revisited) A piece of new equipment has been proposed by engineers to increase the productivity of a certain manual welding operation. The investment cost is $25.000 and the equipment will have a market (salvage) value of $5,000 at the end of its expected life of five years. Increased productivity attributable to the equipment will amount to $8,000 per year after extra operating costs have been subtracted from the value of the additional production. Use a spreadsheet to evaluate the IRR of the proposed equipment. Is the investment a good one? Recall that the MARR is 20% per year. The spreadsheet solution for this problem is shown in Figure 5-7. In column E of Figure 5-7(a), the individual EOY cash flows for year five (net annual savings Spreadsheet Solution A 20% 1 MARR= Capital 2 Investment= 25,000 5,000 5 $ 3 Market Value = $ 4 Useful Life Net Annual 5 Savings= $ 8,000 EOY 2 Cash Flow Cash Flow $ 25,000) 8,000 8,000 8,000 8,000 13,000 EOY = B8 $25,000) 1 8,000 $ 8,000 55 10 11 12 13 14 15 2 8,000 0 0 5,000 4 $ $ $ 5 4 $ B3 5 5 16 B13+B14 IRR= 21.58% Figure 5-7 Soreadsh