Question one (I) The following spreadsheet has been set up to compare the depreciation of 8 new cars over a 4 year period. A B C D E new Value Value Value Value 1 name of car price after year after year after year after year Depreciation over 4 years (5) 1 (5) 2 (5) 3 (5) 4 (5) (%) 2 Fiat Bravo 150 28 000 21.000 15 600 11 200 9 800 65 3 Honda Civic "R" 36 000 28 800 23 400 20 000 18 000 50 4 Range Rover SE 80 000 64 000 60 000 50 000 48 000 40 5 Mitsubishi Lancer 20 000 12 000 9000 6 400 5000 75 6 Citroen C8 LX 40 000 20 000 13 200 10 000 8 000 80 7 BMW 320 Conv 72 000 57 600 50 000 43 200 36 000 50 8 Audi A3 1.6 SE 30 000 22 500 18 000 15 000 12 000 60 9 Mercedes SLK 350 68 000 57 800 51 000 48 000 45 600 33 10 11 Mean Deprecn 56.6 Highest Deprecn. 80.0 (a) What formula must be in cell G4 to find the depreciation on a Range Rover after 4 years? (3 marks) (b) What formula must be in cell G10 to calculate the mean (average) depreciation of all 8 cars? (3 marks) (c) What formula must be in cell G11 to find the highest (maximum) depreciation of all 8 cars? (3 marks) (d) Describe how it would be possible to predict the value of each car after 5 years and after 10 years? (3 marks)