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
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEF
1
2001 Honda InsightVS2006 Ford Mustang
2
Estimated Years of Ownership
9
Estimated Years of Ownership
9
3
Miles Driven per Year15000Miles Driven per Year15000
4
Total Vehicle Purchase Cost$0Total Vehicle Purchase Cost$0
5
Estimated Vehicle Sale Price$0Estimated Vehicle Sale Price$0
6
Vehicle Average MPG65Miles per gallonVehicle Average MPG17
7
Fuel Price per Gallon$2.20Fuel Price per Gallon$2.20
8
Annual Maint & Repair Cost$700Include tires, Oil change, etcAnnual Maint & Repair Cost$700
9
Annual Insurance Cost$700Annual Insurance Cost$700
10
Annual Registration & Fees$200Annual Registration & Fees$200
11
Dollars per KWh$200.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 Miles10000Auto calculatedLifetime Miles100000
18
Lifetime Depreciation$0Auto calculatedLifetime Depreciation$0
19
Lifetime Maint & Repair Cost$6,300Auto calculatedLifetime Maint & Repair Cost$6,300
20
Lifetime Insurance Cost$6,300Auto calculatedLifetime Insurance Cost$6,300
21
Lifetime Registration & Fees Cost
$1,800Auto calculated
Lifetime Registration & Fees Cost
$1,800
22
Lifetime Fuel Cost$338Auto calculatedLifetime Fuel Cost$12,941
23
Lifetime Electricity Cost$0Auto calculatedLifetime Electricity Cost$0
24
Interest Cost$0.00Auto calculatedInterest Cost$0.00
25
26
Total Lifetime Cost$14,738Auto calculatedTotal Lifetime Cost$27,341
27
Average Yearly Cost$1,637.61Auto calculatedAverage Yearly Cost$3,037.91
28
Average Monthly Cost$136.47Auto calculatedAverage Monthly Cost$253.16
29
Average Daily Cost$4.49Auto calculatedAverage Daily Cost$8.32
30
Total Cost per Mile$1.47Auto calculatedTotal Cost per Mile$0.27
31
Fuel/Electricity Cost per Mile$0.03Auto calculatedFuel/Electricity Cost per Mile$0.13
32
Average Yearly Energy Cost$37.61Auto calculatedAverage Yearly Energy Cost$1,437.91
33
Average Monthly Energy Cost$3.13Auto calculatedAverage Monthly Energy Cost$119.83
34
Average Daily Energy Cost$0.10Auto calculatedAverage Daily Energy Cost$3.94
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