ABCDEF
1
BoltVSVehicle 2Soul
2
Estimated Years of Ownership15<--- Start on left sideEstimated Years of Ownership15Autofilled from left side
3
Miles Driven per Year30000Blue is editable, Red is autofilledMiles Driven per Year30000Autofilled from left side
4
Vehicle Total Purchase Price$55,000Include fees but do not include taxesVehicle Total Purchase Price$27,000
5
Estimated Vehicle Sale Price at End of Ownership
$0
Vehicle value after 15 years of ownership
Estimated Vehicle Sale Price at End of Ownership
$0
6
Annual Maint & Repair Cost$300Include tires, oil change, etcAnnual Maint & Repair Cost$750
7
Annual Insurance Cost$1,500Annual Insurance Cost$1,250
8
Annual Registration & Fees$100Yearly DMV/DEQ fees, property taxAnnual Registration & Fees$100
9
State and local sales tax %6
Total of all tax rates at time of purchase
State and local sales tax %6Autofilled from left side
10
Principal Amount Financed$29,000Principal Amount Financed$25,000
11
Interest Rate %0.05Example 3.55% = 3.55Interest Rate %0.05Autofilled from left side
12
Years Financed6Loan term in yearsYears Financed6Autofilled from left side
13
14
Vehicle Average MPGComplete if vehicle uses any fuelVehicle Average MPG33
15
Fuel Price per GallonComplete if vehicle uses any fuelFuel Price per Gallon$4.00
16
17
Electric Utility Rate - Dollars per kWh$0.150Complete if vehicle is EV or Plug-inElectric Utility Rate - Dollars per kWh$0.150
18
Miles per KWh4.0Complete if vehicle is EV or Plug-inMiles per KWh0.0
19
Estimated % of miles driven on battery alone100%Enter 0 if gas only, 100 for EV onlyEstimated % of miles driven on battery alone0%
20
21
Total miles after 15 years450000Auto calculatedTotal miles after 15 years450000
22
Lifetime Depreciation$55,000Auto calculatedLifetime Depreciation$27,000
23
Lifetime Maint & Repair Cost$4,500Auto calculatedLifetime Maint & Repair Cost$11,250
24
Lifetime Insurance Cost$22,500Auto calculatedLifetime Insurance Cost$18,750
25
Lifetime Registration & Fees Cost$1,500Auto calculatedLifetime Registration & Fees Cost$1,500
26
Lifetime Fuel Cost$0Auto calculatedLifetime Fuel Cost$54,545
27
Lifetime Electricity Cost$16,875Auto calculatedLifetime Electricity Cost$0
28
Lifetime Loan Interest Cost$10,146Auto calculatedLifetime Loan Interest Cost$8,747
29
Auto calculated
30
Total Lifetime Cost$110,521Auto calculatedTotal Lifetime Cost$121,792
31
Average Yearly Cost$7,368Auto calculatedAverage Yearly Cost$8,119
32
Average Monthly Cost$614.01Auto calculatedAverage Monthly Cost$676.62
33
Average Daily Cost$20.19Auto calculatedAverage Daily Cost$22.25
34
Total Cost per Mile$0.25Auto calculatedTotal Cost per Mile$0.27
35
Fuel and/or Electricity Cost per Mile$0.04Auto calculatedFuel and/or Electricity Cost per Mile$0.12
36
Average Yearly Fuel and Electricity Cost$1,125.00Auto calculatedAverage Yearly Fuel and Electricity Cost$3,636.36
37
Average Monthly Fuel and Electricity Cost$93.75Auto calculatedAverage Monthly Fuel and Electricity Cost$303.03
38
Average Daily Fuel and Electricity Cost$3.08Auto calculatedAverage Daily Fuel and Electricity Cost$9.96
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
$921.01
44
$41.86
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