Scribd
Upload
82 views8 pages

Car Assignment

The document compares the total 5-year costs of owning three vehicles: a Jaguar F-Type R convertible, a Tesla Model S, and a Genesis G80. It includes costs for maintenance and repairs, insurance, taxes and fees, fuel costs, and depreciation. Over 5 years, the Jaguar has the highest total cost of ownership at $71,789 while the Tesla has the lowest at $68,753. Fuel costs are lowest for the Tesla due to its high gas mileage.

Uploaded by

api-400094966
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
82 views8 pages

Car Assignment

The document compares the total 5-year costs of owning three vehicles: a Jaguar F-Type R convertible, a Tesla Model S, and a Genesis G80. It includes costs for maintenance and repairs, insurance, taxes and fees, fuel costs, and depreciation. Over 5 years, the Jaguar has the highest total cost of ownership at $71,789 while the Tesla has the lowest at $68,753. Fuel costs are lowest for the Tesla due to its high gas mileage.

Uploaded by

api-400094966
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

Data

Make Sum - Maintenance and Repairs over 5 yrs. Sum - Insurance over 5 yrs.
Genesis $ 5,837.00 $ 8,242.00
Jaguar $ 9,118.00 $ 8,565.00
Tesla $ 7,833.00 $ 8,489.00
Total Result $ 22,788.00 $ 25,296.00

10000

9000

8000

7000

6000
Data
5000 Col umn C
4000 Col umn D

3000

2000

1000

0
Make Genes is Jagua r Tes l a
Sum - Taxes and Fees over 5 yrs.
$ 3,641.00
$ 4,519.00
$ 5,330.00
$ 13,490.00

Data
Col umn C
Col umn D

s Jagua r Tes l a
Make Model MPG combined MPG City Mpg Highway
Jaguar F-Type R AWD Convertible 18 15 23
Tesla Model S (75 kW-hr battery pack) 98 97 100
Genesis G80 AWD 20 17 24
Annual fuel Cost Depreciation over 5 yrs. Taxes and Fees over 5 yrs. Insurance over 5 yrs.
$ 2,700.00 $ 36,087.00 $ 4,519.00 $ 8,565.00
$ 650.00 $ 43,851.00 $ 5,330.00 $ 8,489.00
$ 2,400.00 $ 33,850.00 $ 3,641.00 $ 8,242.00
Maintenance and Repairs over 5 yrs. Cost to Own 5 yrs. With Depreciation
$ 9,118.00 $ 71,789.00
$ 7,833.00 $ 68,753.00
$ 5,837.00 $ 63,570.00
Cost to own 5 yrs. Without Depreciation
$ 35,702.00
$ 24,902.00
$ 29,720.00
Make Model MPG City MPG HWY Miles Driven City % HWY %
Jaguar F-Type R AWD Convertible 15 23 12,000 60% 40%
Tesla Model S (75 kW-hr battery pack) 97 100 12,000 60% 40%
Genesis G80 AWD 17 24 12,000 60% 40%
Cost per Gallon City Miles HWY Miles Total Gallons Total Cost
$2.56 7200 4800 688.69565217 $1,763.06
$2.56 7200 4800 122.22680412 $312.90
$2.56 7200 4800 623.52941176 $1,596.24

You might also like