Vehicle Cost of Ownership.xlsx
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
2001 Honda InsightVS2006 Ford Mustang
2
Estimated Years of Ownership
5
Estimated Years of Ownership
5
3
Miles Driven per Year15000Miles Driven per Year15000
4
Total Vehicle Purchase Cost$2,300Total Vehicle Purchase Cost$17,000
5
Estimated Vehicle Sale Price$2Estimated Vehicle Sale Price$4,000
6
Vehicle Average MPG17Miles per gallonVehicle Average MPG85
7
Fuel Price per Gallon$2.20Fuel Price per Gallon$2.20
8
Annual Maint & Repair Cost$1,000Include tires, Oil change, etcAnnual Maint & Repair Cost$1,000
9
Annual Insurance Cost$900Annual Insurance Cost$1,800
10
Annual Registration & Fees$1,000Annual Registration & Fees$1,000
11
Dollars per KWh$0.00000Killowatt price if electricDollars per KWh$0.00000
12
Miles per KWh0.0If vehicle is electricMiles per KW0.0
13
Principal Amount Financed$0.00Loan amount financedPrincipal Amount Financed$0.00
14
Interest Rate %0Example 3.55% = 3.55Interest Rate %0
15
Years Financed0Loan term in yearsYears Financed0
16
17
Lifetime Miles235000Auto calculatedLifetime Miles17000
18
Lifetime Depreciation$2,298Auto calculatedLifetime Depreciation$13,000
19
Lifetime Maint & Repair Cost$5,000Auto calculatedLifetime Maint & Repair Cost$5,000
20
Lifetime Insurance Cost$4,500Auto calculatedLifetime Insurance Cost$9,000
21
Lifetime Registration & Fees Cost
$5,000Auto calculated
Lifetime Registration & Fees Cost
$5,000
22
Lifetime Fuel Cost$30,412Auto calculatedLifetime Fuel Cost$440
23
Lifetime Electricity Cost$0Auto calculatedLifetime Electricity Cost$0
24
Interest Cost$0.00Auto calculatedInterest Cost$0.00
25
26
Total Lifetime Cost$47,209Auto calculatedTotal Lifetime Cost$32,440
27
Average Yearly Cost$9,441.89Auto calculatedAverage Yearly Cost$6,488.00
28
Average Monthly Cost$786.82Auto calculatedAverage Monthly Cost$540.67
29
Average Daily Cost$25.87Auto calculatedAverage Daily Cost$17.78
30
Total Cost per Mile$0.20Auto calculatedTotal Cost per Mile$1.91
31
Fuel/Electricity Cost per Mile$0.13Auto calculatedFuel/Electricity Cost per Mile$0.03
32
Average Yearly Energy Cost$6,082.35Auto calculatedAverage Yearly Energy Cost$88.00
33
Average Monthly Energy Cost$506.86Auto calculatedAverage Monthly Energy Cost$7.33
34
Average Daily Energy Cost$16.66Auto calculatedAverage Daily Energy Cost$0.24
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
Sheet2
Sheet3