THE FOLLOWING QUESTION REQUIRES TO USE EXCEL .

AutoSave OFF OFF A SU BUS37352021FINAL-makeup-richards-2 - Compatibility Mode - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share Comments v [G - A A Aa A EE11 U XX ADA = = = Aalde Aa BbCcDc AabhccDdE AaBbCcDc AaBaDee Nammal Heading Heading 2 Title Suhtit Psstc ! Emasis Dictate Sensitivity Sty es Pere Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates 22 Q 22) Griffith Vehicle has received three proposals for its new vehicle-painting machine. Information on each proposal is as follows: ProposalX Proposal Y Proposal Z S240,000 $150,000 $190,000 0 10,000 3 0 Initial investment in equipment Working capital needed Annual cash saved by operations: Year 1 Year 2 Year 3 Year 4 Salvage value end of year: Year 1 Year 2 Year 3 Year 4 Working capital returned 80,000 80,000 80,000 80,000 50,000 42,000 46,000 24,000 80,000 80,000 80,000 80,000 100,000 80,000 40,000 10,000 80,000 60,000 40,000 20,000 0 60,000 50,000 30,000 15,000 10,000 Required: Determine each proposal's payback. b. Calculate the internal rate of return (IRR) for proposals X and Z only. Which proposal should Griffith accept? C. 6 Page 6 of 9 120 of 1598 wards CS English (United States Focus E = + 194%