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

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEF
1
Vehicle 1Bolt EVVSVehicle 2
2
Estimated Years of Ownership10Start on left sideEstimated Years of Ownership10
3
Miles Driven per Year13000Miles Driven per Year13000Autofilled from left side
4
Vehicle Total Purchase Price$30,000
Include fees but do not include taxes
Vehicle Total Purchase Price$20,000
5
Estimated Vehicle Sale Price at End of Ownership
$2,000
Vehicle value after 10 years of ownership
Estimated Vehicle Sale Price at End of Ownership
$2,000
6
Annual Maint & Repair Cost$250Include tires, oil change, etcAnnual Maint & Repair Cost$750
7
Annual Insurance Cost$600Annual Insurance Cost$600
8
Annual Registration & Fees$150Yearly DMV/DEQ fees, property taxAnnual Registration & Fees$150
9
State and local tax %0.00%Total of all tax ratesState and local tax %0.00%Autofilled from left side
10
Principal Amount Financed$27,000.00Loan amount if financedPrincipal Amount Financed$0.00
11
Interest Rate %0.029Example 3.55% = 3.55Interest Rate %2.90%Autofilled from left side
12
Years Financed6Loan term in yearsYears Financed6Autofilled from left side
13
14
Vehicle Average MPG0Complete if vehicle uses fuelVehicle Average MPG30
15
Fuel Price per Gallon$0.00Complete if vehicle uses fuelFuel Price per Gallon$3.25Autofilled from left side
16
17
Electric Utility Rate - Dollars per kWh$0.105
Complete if vehicle is EV or Plug-in
Electric Utility Rate - Dollars per kWh$0.000
18
Miles per KWh3.5
Complete if vehicle is EV or Plug-in
Miles per KW0.0
19
Estimated % of miles driven on battery alone
100%
Enter 0 if gas only, 100 for EV only
Estimated % of miles driven on battery alone
0%
20
21
Total miles after 10 years130000Auto calculatedTotal miles after 10 years130000
22
Lifetime Depreciation$28,000Auto calculatedLifetime Depreciation$18,000
23
Lifetime Maint & Repair Cost$2,500Auto calculatedLifetime Maint & Repair Cost$7,500
24
Lifetime Insurance Cost$6,000Auto calculatedLifetime Insurance Cost$6,000
25
Lifetime Registration & Fees Cost$1,500Auto calculatedLifetime Registration & Fees Cost$1,500
26
Lifetime Fuel Cost$0Lifetime Fuel Cost$14,083
27
Lifetime Electricity Cost$3,900Auto calculatedLifetime Electricity Cost$0
28
Lifetime Loan Interest Cost$5,131.54Auto calculatedLifetime Loan Interest Cost$0.00
29
30
Total Lifetime Cost$47,032Auto calculatedTotal Lifetime Cost$47,083
31
Average Yearly Cost$4,703.15Auto calculatedAverage Yearly Cost$4,708.33
32
Average Monthly Cost$391.93Auto calculatedAverage Monthly Cost$392.36
33
Average Daily Cost$12.89Auto calculatedAverage Daily Cost$12.90
34
Total Cost per Mile$0.36Auto calculatedTotal Cost per Mile$0.36
35
Fuel and Electricity Cost per Mile$0.03Auto calculatedFuel and Electricity Cost per Mile$0.11
36
Average Yearly Fuel and Electricity Cost$390.00Auto calculatedAverage Yearly Fuel and Electricity Cost$1,408.33
37
Average Monthly Fuel and Electricity Cost$32.50Auto calculatedAverage Monthly Fuel and Electricity Cost$117.36
38
Average Daily Fuel and Electricity Cost$1.07Auto calculatedAverage Daily Fuel and Electricity Cost$3.86
39
40
41
42
15% on automobilia sales
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...
Main menu