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 1ForteVSVehicle 2bOLT
2
Estimated Years of Ownership10<--- Start on left sideEstimated Years of Ownership10Autofilled from left side
3
Miles Driven per Year20000Blue is editable, Red is autofilledMiles Driven per Year20000Autofilled from left side
4
Vehicle Total Purchase Price$31,000
Include fees but do not include taxes
Vehicle Total Purchase Price$31,000
5
Estimated Vehicle Sale Price at End of Ownership
$5,000
Vehicle value after 10 years of ownership
Estimated Vehicle Sale Price at End of Ownership
$5,000
6
Annual Maint & Repair Cost$100Include tires, oil change, etcAnnual Maint & Repair Cost$500
7
Annual Insurance Cost$910Annual Insurance Cost$900
8
Annual Registration & Fees$350Yearly DMV/DEQ fees, property taxAnnual Registration & Fees$350
9
State and local sales tax %6%Total of all tax ratesState and local sales tax %6%Autofilled from left side
10
Principal Amount Financed$0.00Loan amount if financedPrincipal Amount Financed$0.00
11
Interest Rate %3.25%Example 3.55% = 3.55Interest Rate %3.25%Autofilled from left side
12
Years Financed6Loan term in yearsYears Financed6Autofilled from left side
13
14
Vehicle Average MPG
Complete if vehicle uses any fuel
Vehicle Average MPG18
15
Fuel Price per Gallon
Complete if vehicle uses any fuel
Fuel Price per Gallon$2.50
16
17
Electric Utility Rate - Dollars per kWh$0.120
Complete if vehicle is EV or Plug-in
Electric Utility Rate - Dollars per kWh$0.000
18
Miles per KWh3.0
Complete if vehicle is EV or Plug-in
Miles per KWh0.0
19
Estimated % of miles driven on battery alone
100.00%
Enter 0 if gas only, 100 for EV only
Estimated % of miles driven on battery alone
0%
20
21
Total miles after 10 years200000Auto calculatedTotal miles after 10 years200000
22
Lifetime Depreciation$26,000Auto calculatedLifetime Depreciation$26,000
23
Lifetime Maint & Repair Cost$1,000Auto calculatedLifetime Maint & Repair Cost$5,000
24
Lifetime Insurance Cost$9,100Auto calculatedLifetime Insurance Cost$9,000
25
Lifetime Registration & Fees Cost$3,500Auto calculatedLifetime Registration & Fees Cost$3,500
26
Lifetime Fuel Cost$0Lifetime Fuel Cost$27,778
27
Lifetime Electricity Cost$8,000Auto calculatedLifetime Electricity Cost$0
28
Lifetime Loan Interest Cost$0Auto calculatedLifetime Loan Interest Cost$0
29
30
Total Lifetime Cost$47,600Auto calculatedTotal Lifetime Cost$71,278
31
Average Yearly Cost$4,760Auto calculatedAverage Yearly Cost$7,128
32
Average Monthly Cost$396.67Auto calculatedAverage Monthly Cost$593.98
33
Average Daily Cost$13.04Auto calculatedAverage Daily Cost$19.53
34
Total Cost per Mile$0.24Auto calculatedTotal Cost per Mile$0.36
35
Fuel and Electricity Cost per Mile$0.04Auto calculatedFuel and Electricity Cost per Mile$0.14
36
Average Yearly Fuel and Electricity Cost$800.00Auto calculatedAverage Yearly Fuel and Electricity Cost$2,777.78
37
Average Monthly Fuel and Electricity Cost$66.67Auto calculatedAverage Monthly Fuel and Electricity Cost$231.48
38
Average Daily Fuel and Electricity Cost$2.19Auto calculatedAverage Daily Fuel and Electricity Cost$7.61
39
40
Please download the spreadsheet which gives full control to modify all parameters
41
Comments or questions- email me at nojbrooks@gmail.com
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...