QUESTION ONE The following spreadsheet has been set up to compare the depreciation of 8 new cars
Fantastic news! We've Found the answer you've been seeking!
Question:
QUESTION ONE
- 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 |
- What formula must be in cell G4 to find the depreciation on a Range Rover after
4 years? [3]
- What formula must be in cell G10 to calculate the mean (average) depreciation of
all 8 cars? [3]
- What formula must be in cell G11 to find the highest (maximum) depreciation of
all 8 cars? [3]
- Describe how it would be possible to predict the value of each car after 5 years and
after 10 years? [3]
Related Book For
Posted Date: