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 1VSVehicle 2
2
Estimated Years of Ownership10Start on left sideEstimated Years of Ownership10
3
Miles Driven per Year18700Miles Driven per Year18700Autofilled from left side
4
Vehicle Total Purchase Price$40,000
Include fees but do not include taxes
Vehicle Total Purchase Price$30,000
5
Estimated Vehicle Sale Price at End of Ownership
$500
Vehicle value after 10 years of ownership
Estimated Vehicle Sale Price at End of Ownership
$500
6
Annual Maint & Repair Cost$0Include tires, oil change, etcAnnual Maint & Repair Cost$800
7
Annual Insurance Cost$0Annual Insurance Cost$0
8
Annual Registration & Fees$100Yearly DMV/DEQ fees, property taxAnnual Registration & Fees$100
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$0.00Loan amount if financedPrincipal Amount Financed$0.00
11
Interest Rate %4.00%Example 3.55% = 3.55Interest Rate %4.00%Autofilled from left side
12
Years Financed6Loan term in yearsYears Financed6Autofilled from left side
13
14
Vehicle Average MPG0Complete if vehicle uses fuelVehicle Average MPG53
15
Fuel Price per Gallon$5.00Complete if vehicle uses fuelFuel Price per Gallon$5.00Autofilled from left side
16
17
Electric Utility Rate - Dollars per kWh$0.090
Complete if vehicle is EV or Plug-in
Electric Utility Rate - Dollars per kWh$0.000
18
Miles per KWh4.7
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 years187000Auto calculatedTotal miles after 10 years187000
22
Lifetime Depreciation$39,500Auto calculatedLifetime Depreciation$29,500
23
Lifetime Maint & Repair Cost$0Auto calculatedLifetime Maint & Repair Cost$8,000
24
Lifetime Insurance Cost$0Auto calculatedLifetime Insurance Cost$0
25
Lifetime Registration & Fees Cost$1,000Auto calculatedLifetime Registration & Fees Cost$1,000
26
Lifetime Fuel Cost$0Lifetime Fuel Cost$17,642
27
Lifetime Electricity Cost$3,581Auto calculatedLifetime Electricity Cost$0
28
Lifetime Loan Interest Cost$0.00Auto calculatedLifetime Loan Interest Cost$0.00
29
30
Total Lifetime Cost$44,081Auto calculatedTotal Lifetime Cost$56,142
31
Average Yearly Cost$4,408.09Auto calculatedAverage Yearly Cost$5,614.15
32
Average Monthly Cost$367.34Auto calculatedAverage Monthly Cost$467.85
33
Average Daily Cost$12.08Auto calculatedAverage Daily Cost$15.38
34
Total Cost per Mile$0.24Auto calculatedTotal Cost per Mile$0.30
35
Fuel and Electricity Cost per Mile$0.02Auto calculatedFuel and Electricity Cost per Mile$0.09
36
Average Yearly Fuel and Electricity Cost$358.09Auto calculatedAverage Yearly Fuel and Electricity Cost$1,764.15
37
Average Monthly Fuel and Electricity Cost$29.84Auto calculatedAverage Monthly Fuel and Electricity Cost$147.01
38
Average Daily Fuel and Electricity Cost$0.98Auto calculatedAverage Daily Fuel and Electricity Cost$4.83
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
 
 
Main menu