A | B | C | D | E | F | |
---|---|---|---|---|---|---|
1 | Bolt | VS | Vehicle 2 | Soul | ||
2 | Estimated Years of Ownership | 15 | <--- Start on left side | Estimated Years of Ownership | 15 | Autofilled from left side |
3 | Miles Driven per Year | 30000 | Blue is editable, Red is autofilled | Miles Driven per Year | 30000 | Autofilled from left side |
4 | Vehicle Total Purchase Price | $55,000 | Include fees but do not include taxes | Vehicle 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 | $300 | Include tires, oil change, etc | Annual Maint & Repair Cost | $750 | |
7 | Annual Insurance Cost | $1,500 | Annual Insurance Cost | $1,250 | ||
8 | Annual Registration & Fees | $100 | Yearly DMV/DEQ fees, property tax | Annual Registration & Fees | $100 | |
9 | State and local sales tax % | 6 | Total of all tax rates at time of purchase | State and local sales tax % | 6 | Autofilled from left side |
10 | Principal Amount Financed | $29,000 | Principal Amount Financed | $25,000 | ||
11 | Interest Rate % | 0.05 | Example 3.55% = 3.55 | Interest Rate % | 0.05 | Autofilled from left side |
12 | Years Financed | 6 | Loan term in years | Years Financed | 6 | Autofilled from left side |
13 | ||||||
14 | Vehicle Average MPG | Complete if vehicle uses any fuel | Vehicle Average MPG | 33 | ||
15 | Fuel Price per Gallon | Complete if vehicle uses any fuel | Fuel Price per Gallon | $4.00 | ||
16 | ||||||
17 | Electric Utility Rate - Dollars per kWh | $0.150 | Complete if vehicle is EV or Plug-in | Electric Utility Rate - Dollars per kWh | $0.150 | |
18 | Miles per KWh | 4.0 | Complete if vehicle is EV or Plug-in | Miles per KWh | 0.0 | |
19 | Estimated % of miles driven on battery alone | 100% | Enter 0 if gas only, 100 for EV only | Estimated % of miles driven on battery alone | 0% | |
20 | ||||||
21 | Total miles after 15 years | 450000 | Auto calculated | Total miles after 15 years | 450000 | |
22 | Lifetime Depreciation | $55,000 | Auto calculated | Lifetime Depreciation | $27,000 | |
23 | Lifetime Maint & Repair Cost | $4,500 | Auto calculated | Lifetime Maint & Repair Cost | $11,250 | |
24 | Lifetime Insurance Cost | $22,500 | Auto calculated | Lifetime Insurance Cost | $18,750 | |
25 | Lifetime Registration & Fees Cost | $1,500 | Auto calculated | Lifetime Registration & Fees Cost | $1,500 | |
26 | Lifetime Fuel Cost | $0 | Auto calculated | Lifetime Fuel Cost | $54,545 | |
27 | Lifetime Electricity Cost | $16,875 | Auto calculated | Lifetime Electricity Cost | $0 | |
28 | Lifetime Loan Interest Cost | $10,146 | Auto calculated | Lifetime Loan Interest Cost | $8,747 | |
29 | Auto calculated | |||||
30 | Total Lifetime Cost | $110,521 | Auto calculated | Total Lifetime Cost | $121,792 | |
31 | Average Yearly Cost | $7,368 | Auto calculated | Average Yearly Cost | $8,119 | |
32 | Average Monthly Cost | $614.01 | Auto calculated | Average Monthly Cost | $676.62 | |
33 | Average Daily Cost | $20.19 | Auto calculated | Average Daily Cost | $22.25 | |
34 | Total Cost per Mile | $0.25 | Auto calculated | Total Cost per Mile | $0.27 | |
35 | Fuel and/or Electricity Cost per Mile | $0.04 | Auto calculated | Fuel and/or Electricity Cost per Mile | $0.12 | |
36 | Average Yearly Fuel and Electricity Cost | $1,125.00 | Auto calculated | Average Yearly Fuel and Electricity Cost | $3,636.36 | |
37 | Average Monthly Fuel and Electricity Cost | $93.75 | Auto calculated | Average Monthly Fuel and Electricity Cost | $303.03 | |
38 | Average Daily Fuel and Electricity Cost | $3.08 | Auto calculated | Average 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 |