Gmail Car Cost Comparison Tool For Excel Healthywealthywiseproject.jpg 3a2z2n

A

C

D

G

33 Age of Vehicle: Miles at end of 5 Year

H

K

L

8

0

0

0

0

0

0

0

239,000

75,250

75,250

75,250

75,250

75,250

75,250

75,250

$2,500

$23,900

$20,650

$16,700

$12,700

$18,400

$13,350

34 Depreciation Future 5 Year Trade-in 35

value:

36

Depreciation Loss:

$2,500

$23,900

$20,650

$16,700

$12,700

$18,400

$13,350

37

Your average mpg:

18

22

22

23

27

25

27

$16,314

$13,095

$12,674

$11,876

$10,253

$10,928

$10,253

75,000

75,000

75,000

75,000

75,000

75,000

75,000

$3,113

$3,113

$3,113

$3,150

$3,113

$3,068

$2,588

$3,000

$10,000

$10,000

$9,000

$8,500

$9,000

$7,500

$1,500

$4,000

$4,000

$3,500

$3,250

$3,500

$2,500

Fuel Costs 38

fuel cost next 5 years: Miles driven in 5 years:

3g

Maintenance

& Repairs

Estimated Maintenance/Tire costs 10

next 5 years:

11

5 years of insurance: 5 Years of property

12

taxes:

13 5-Year Cost of Ownership

$2,555 Est. Cost to own next 5 years:

$26,426

$58,211

$54,090

$47,335

$40,371

$48,239

$38,836

$0.35

$0.78

$0.72

$0.63

$0.54

$0.64

$0.52

5-Year Cost per mile 15 driven: 16

Cost for extra 5 years:

10-Yea r Cost

Total_ Cost for 10 years:

$25,176

$42,158

$40,111

$35,876

$31,465

$35,696

$29,515

$51,602

$100,369

$94,201

$83,211

$71,836

$83,935

$68,351

$0.34

$0.67

$0.63

$0.55

$0.48

$0.56

$0.46

47,800.00

41,300.00

33,400.00

25,400.00

36,800.00

26,700.00

22,700.00

4,780.00

4,130.00

3,340.00

2,540.00

3,680.00

2,670.00

2,270.00

2.95%

2.95%

2.95%

2.95%

2.95%

2.95%

2.95%

5

5

5

5

5

5

5

$667.07

$539.47

$410.26

$594.39

$431.25

$366.65

$426.41

17 of Ownership 10-Year Cost per mile 18 driven: 19 50 ii

Car Price

:

52 Down Payment : 53 Interest rate

:

Repayment period . 54 (year)

-

Ss 56 Monthly Payment :

$772.06

57 Total Payment :

$46,323.45 $40,024.24 $32,368.27 $24,615.39 $35,663.25 $25,875.23 $21,998.80 $25,584.50

Total Interest . 58 Payment

$3,303.45

$2,854.24

$2,308.27

$1,755.39 $2,54325

$1,845.23

$1,568.80

51,824.50

N 0 Change equation each year 75,250

Use Edmunds estimate that cars $11,350

$13,200

$11,350

$13,200

28

31

$9,918

$8,816

75,000

75,000

$2,588

$2,588

$7,500

$7,500

$2,500

$2,500

$36,225

$37,228

$0.48

$0.50

depreciate 50% every 5 years

$28,181

$64,406

$28,004 (assumes new car is paid off by 5 years}

$65,232 10-Year Cost of Ownership may not be applicable to your car

$0.43

26,400.00 2,640.00 2.95% 5

$0.43