| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Vehicle 1 | Forte | VS | Vehicle 2 | bOLT | |
2 | Estimated Years of Ownership | 10 | <--- Start on left side | Estimated Years of Ownership | 10 | Autofilled from left side |
3 | Miles Driven per Year | 20000 | Blue is editable, Red is autofilled | Miles Driven per Year | 20000 | Autofilled from left side |
4 | Vehicle Total Purchase Price | $31,000 | Include fees but do not include taxes | Vehicle Total Purchase Price | $31,000 | |
5 | Estimated Vehicle Sale Price at End of Ownership | $5,000 | Vehicle value after 10 years of ownership | Estimated Vehicle Sale Price at End of Ownership | $5,000 | |
6 | Annual Maint & Repair Cost | $100 | Include tires, oil change, etc | Annual Maint & Repair Cost | $500 | |
7 | Annual Insurance Cost | $910 | Annual Insurance Cost | $900 | ||
8 | Annual Registration & Fees | $350 | Yearly DMV/DEQ fees, property tax | Annual Registration & Fees | $350 | |
9 | State and local sales tax % | 6% | Total of all tax rates | State and local sales tax % | 6% | Autofilled from left side |
10 | Principal Amount Financed | $0.00 | Loan amount if financed | Principal Amount Financed | $0.00 | |
11 | Interest Rate % | 3.25% | Example 3.55% = 3.55 | Interest Rate % | 3.25% | 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 | 18 | ||
15 | Fuel Price per Gallon | Complete if vehicle uses any fuel | Fuel Price per Gallon | $2.50 | ||
16 | ||||||
17 | Electric Utility Rate - Dollars per kWh | $0.120 | Complete if vehicle is EV or Plug-in | Electric Utility Rate - Dollars per kWh | $0.000 | |
18 | Miles per KWh | 3.0 | Complete if vehicle is EV or Plug-in | Miles per KWh | 0.0 | |
19 | Estimated % of miles driven on battery alone | 100.00% | Enter 0 if gas only, 100 for EV only | Estimated % of miles driven on battery alone | 0% | |
20 | ||||||
21 | Total miles after 10 years | 200000 | Auto calculated | Total miles after 10 years | 200000 | |
22 | Lifetime Depreciation | $26,000 | Auto calculated | Lifetime Depreciation | $26,000 | |
23 | Lifetime Maint & Repair Cost | $1,000 | Auto calculated | Lifetime Maint & Repair Cost | $5,000 | |
24 | Lifetime Insurance Cost | $9,100 | Auto calculated | Lifetime Insurance Cost | $9,000 | |
25 | Lifetime Registration & Fees Cost | $3,500 | Auto calculated | Lifetime Registration & Fees Cost | $3,500 | |
26 | Lifetime Fuel Cost | $0 | Lifetime Fuel Cost | $27,778 | ||
27 | Lifetime Electricity Cost | $8,000 | Auto calculated | Lifetime Electricity Cost | $0 | |
28 | Lifetime Loan Interest Cost | $0 | Auto calculated | Lifetime Loan Interest Cost | $0 | |
29 | ||||||
30 | Total Lifetime Cost | $47,600 | Auto calculated | Total Lifetime Cost | $71,278 | |
31 | Average Yearly Cost | $4,760 | Auto calculated | Average Yearly Cost | $7,128 | |
32 | Average Monthly Cost | $396.67 | Auto calculated | Average Monthly Cost | $593.98 | |
33 | Average Daily Cost | $13.04 | Auto calculated | Average Daily Cost | $19.53 | |
34 | Total Cost per Mile | $0.24 | Auto calculated | Total Cost per Mile | $0.36 | |
35 | Fuel and Electricity Cost per Mile | $0.04 | Auto calculated | Fuel and Electricity Cost per Mile | $0.14 | |
36 | Average Yearly Fuel and Electricity Cost | $800.00 | Auto calculated | Average Yearly Fuel and Electricity Cost | $2,777.78 | |
37 | Average Monthly Fuel and Electricity Cost | $66.67 | Auto calculated | Average Monthly Fuel and Electricity Cost | $231.48 | |
38 | Average Daily Fuel and Electricity Cost | $2.19 | Auto calculated | Average Daily Fuel and Electricity Cost | $7.61 | |
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 | ||||||
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...