QUESTION ONE

1. The following spreadsheet has been set up to compare the depreciation of 8 new cars over a 4 year period.

Name of car	new price	value after year	value of after year	value of after year	value of after year	depreciation over 4 years (%)
Fiat Bravo 150	28 000	21 000	21 000	11 200	9 800	65
Honda Civic ''R''	36 000	28 800	28 800	20 000	18 000	50
Range Rover SE	80 000	64 000	60 000	50 000	48 000	40
Mitsubishi Lancer	20 000	12 000	9 000	6 400	5 000	75
Citroen C8 LX	40 000	20 000	13 200	10 000	8 000	80
BMW 320 Conv	72 000	57 600	50 000	43 200	36 000	50
Audi A3 1.6 SE	30 000	22 500	18 000	15 000	12 000	60
Mercedes SLK 350	68 000	57 800	51 000	48 000	45 600	33
				Mean	Deprecn	56.6
				Highest	Deprecn	80

1. What formula must be in cell G4 to find the depreciation on a Range Rover after

4 years? [3]

1. What formula must be in cell G10 to calculate the mean (average) depreciation of

all 8 cars? [3]

1. What formula must be in cell G11 to find the highest (maximum) depreciation of

all 8 cars? [3]

1. Describe how it would be possible to predict the value of each car after 5 years and

after 10 years? [3]

Answer rating: 100% (QA)

To find the depreciation on a Range Rover after 4 years the formula in cell G4 should be B4E4B4100Th... View the full answer