AutoSave O OFF ~ A @ . G ... Assignment 4 (2022-23) Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 12 AA ab Wrap Text General Insert v Ex AY- O. x Delete v Z Paste BIUVE MVAv E Merge & Center v $ ~ % 9 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format v Filter Select Data B15 X V fx Disposal value now A B D E F G H K L M N 0 Question 2 (10 Marks) M A W N H Jimbob Co. is considering replacing its existing fleet of trucks with new trucks. Estimates for the next three years are as follows: Old trucks New trucks Average annual sales $500,000 $520,000 Annual operating costs $100,000 $75,000 Original costs of old trucks $100,000 11 Remaining book value of old $10,000 List price of new trucks $120,000 13 Remaining life 3 year 14 Expect life 3 years Disposal value now $10,000 16 Disposal value in 3 years $nill $nil 18 19 20 Required: Based strictly on the financial information presented above, should the company replace the old trucks now? (Ignore time value of money). 24 Note: 1 mark for the decision and 9 marks for the supporting calculations 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 D Instructions Question 1 Question 2 Question 3 Question 4 Assessment Criteria + Ready Accessibility: Investigate + 100%