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 12019VSVehicle 22017
2
Estimated Years of Ownership10Start on left sideEstimated Years of Ownership10
3
Miles Driven per Year13500Miles Driven per Year13500Autofilled from left side
4
Vehicle Total Purchase Price$6,000
Include fees but do not include taxes
Vehicle Total Purchase Price$48,751
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
$4,000
6
Annual Maint & Repair Cost$700Include tires, oil change, etcAnnual Maint & Repair Cost$200
7
Annual Insurance Cost$600Annual Insurance Cost$820
8
Annual Registration & Fees$100Yearly DMV/DEQ fees, property taxAnnual Registration & Fees$100
9
State and local tax %Total of all tax ratesState and local tax %Autofilled from left side
10
Principal Amount Financed$6,000.00Loan amount if financedPrincipal Amount Financed$42,751.00
11
Interest Rate %0.0249Example 3.55% = 3.55Interest Rate %0.0289Autofilled from left side
12
Years Financed2Loan term in yearsYears Financed5Autofilled from left side
13
14
Vehicle Average MPG38Complete if vehicle uses fuelVehicle Average MPG
15
Fuel Price per Gallon$2.30Complete if vehicle uses fuelFuel Price per GallonAutofilled from left side
16
17
Electric Utility Rate - Dollars per kWh
Complete if vehicle is EV or Plug-in
Electric Utility Rate - Dollars per kWh$0.220
18
Miles per KWh
Complete if vehicle is EV or Plug-in
Miles per KW4.0
19
Estimated % of miles driven on battery alone
0
Enter 0 if gas only, 100 for EV only
Estimated % of miles driven on battery alone
100%
20
21
Total miles after 10 years135000Auto calculatedTotal miles after 10 years135000
22
Lifetime Depreciation$4,000Auto calculatedLifetime Depreciation$44,751
23
Lifetime Maint & Repair Cost$7,000Auto calculatedLifetime Maint & Repair Cost$2,000
24
Lifetime Insurance Cost$6,000Auto calculatedLifetime Insurance Cost$8,200
25
Lifetime Registration & Fees Cost$1,000Auto calculatedLifetime Registration & Fees Cost$1,000
26
Lifetime Fuel Cost$8,171Lifetime Fuel Cost$0
27
Lifetime Electricity Cost$0Auto calculatedLifetime Electricity Cost$7,481
28
Lifetime Loan Interest Cost$306.37Auto calculatedLifetime Loan Interest Cost$6,646.19
29
30
Total Lifetime Cost$26,477Auto calculatedTotal Lifetime Cost$70,078
31
Average Yearly Cost$2,647.74Auto calculatedAverage Yearly Cost$7,007.83
32
Average Monthly Cost$220.65Auto calculatedAverage Monthly Cost$583.99
33
Average Daily Cost$7.25Auto calculatedAverage Daily Cost$19.20
34
Total Cost per Mile$0.20Auto calculatedTotal Cost per Mile$0.52
35
Fuel and Electricity Cost per Mile$0.06Auto calculatedFuel and Electricity Cost per Mile$0.06
36
Average Yearly Fuel and Electricity Cost$817.11Auto calculatedAverage Yearly Fuel and Electricity Cost$748.11
37
Average Monthly Fuel and Electricity Cost$68.09Auto calculatedAverage Monthly Fuel and Electricity Cost$62.34
38
Average Daily Fuel and Electricity Cost$2.24Auto calculatedAverage Daily Fuel and Electricity Cost$2.05
39
40
41
42
Target price = $29,400
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