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
5
Estimated Years of Ownership
5
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$900Annual Insurance Cost$1,800
10
Annual Registration & Fees$200Annual Registration & Fees$200
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 Miles235000Auto calculatedLifetime Miles71000
18
Lifetime Depreciation$0Auto calculatedLifetime Depreciation$0
19
Lifetime Maint & Repair Cost$3,500Auto calculatedLifetime Maint & Repair Cost$3,500
20
Lifetime Insurance Cost$4,500Auto calculatedLifetime Insurance Cost$9,000
21
Lifetime Registration & Fees Cost
$1,000Auto calculated
Lifetime Registration & Fees Cost
$1,000
22
Lifetime Fuel Cost$7,954Auto calculatedLifetime Fuel Cost$9,188
23
Lifetime Electricity Cost$0Auto calculatedLifetime Electricity Cost$0
24
Interest Cost$0.00Auto calculatedInterest Cost$0.00
25
26
Total Lifetime Cost$16,954Auto calculatedTotal Lifetime Cost$22,688
27
Average Yearly Cost$3,390.77Auto calculatedAverage Yearly Cost$4,537.65
28
Average Monthly Cost$282.56Auto calculatedAverage Monthly Cost$378.14
29
Average Daily Cost$9.29Auto calculatedAverage Daily Cost$12.43
30
Total Cost per Mile$0.07Auto calculatedTotal Cost per Mile$0.32
31
Fuel/Electricity Cost per Mile$0.03Auto calculatedFuel/Electricity Cost per Mile$0.13
32
Average Yearly Energy Cost$1,590.77Auto calculatedAverage Yearly Energy Cost$1,837.65
33
Average Monthly Energy Cost$132.56Auto calculatedAverage Monthly Energy Cost$153.14
34
Average Daily Energy Cost$4.36Auto calculatedAverage Daily Energy Cost$5.03
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