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
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
2001 Honda InsightVS2006 Ford Mustang
2
Estimated Years of Ownership
10
Estimated Years of Ownership
10
3
Miles Driven per Year16000Miles Driven per Year16000
4
Total Vehicle Purchase Cost$0Total Vehicle Purchase Cost$0
5
Estimated Vehicle Sale Price$4,000
6
Vehicle Average MPG65Miles per gallonVehicle Average MPG25
7
Fuel Price per Gallon$3.78Fuel Price per Gallon$3.78
8
Annual Maint & Repair Cost$250Include tires, Oil change, etcAnnual Maint & Repair Cost$250
9
Annual Insurance Cost$900Annual Insurance Cost$1,800
10
Annual Registration & Fees$100Annual Registration & Fees$100
11
Dollars per KWh$0.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 Miles160000Auto calculatedLifetime Miles160000
18
Lifetime Depreciation$0Auto calculatedLifetime Depreciation-$4,000
19
Lifetime Maint & Repair Cost$2,500Auto calculatedLifetime Maint & Repair Cost$2,500
20
Lifetime Insurance Cost$9,000Auto calculatedLifetime Insurance Cost$18,000
21
Lifetime Registration & Fees Cost
$1,000Auto calculated
Lifetime Registration & Fees Cost
$1,000
22
Lifetime Fuel Cost$9,305Auto calculatedLifetime Fuel Cost$24,192
23
Lifetime Electricity Cost$0Auto calculatedLifetime Electricity Cost$0
24
Interest Cost$0.00Auto calculatedInterest Cost$0.00
25
26
Total Lifetime Cost$21,805Auto calculatedTotal Lifetime Cost$41,692
27
Average Yearly Cost$2,180.46Auto calculatedAverage Yearly Cost$4,169.20
28
Average Monthly Cost$181.71Auto calculatedAverage Monthly Cost$347.43
29
Average Daily Cost$5.97Auto calculatedAverage Daily Cost$11.42
30
Total Cost per Mile$0.14Auto calculatedTotal Cost per Mile$0.26
31
Fuel/Electricity Cost per Mile$0.06Auto calculatedFuel/Electricity Cost per Mile$0.15
32
Average Yearly Energy Cost$930.46Auto calculatedAverage Yearly Energy Cost$2,419.20
33
Average Monthly Energy Cost$77.54Auto calculatedAverage Monthly Energy Cost$201.60
34
Average Daily Energy Cost$2.55Auto calculatedAverage Daily Energy Cost$6.63
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