| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Vehicle 1 | NV200 | VS | Vehicle 2 | eNv200 | |
2 | Estimated Years of Ownership | 12 | <--- Start on left side | Estimated Years of Ownership | 12 | Autofilled from left side |
3 | Miles Driven per Year | 12000 | Blue is editable, Red is autofilled | Miles Driven per Year | 12000 | Autofilled from left side |
4 | Vehicle Total Purchase Price | $35,000 | Include fees but do not include taxes | Vehicle Total Purchase Price | $20,000 | |
5 | Estimated Vehicle Sale Price at End of Ownership | $2,000 | Vehicle value after 12 years of ownership | Estimated Vehicle Sale Price at End of Ownership | $2,000 | |
6 | Annual Maint & Repair Cost | $400 | Include tires, oil change, etc | Annual Maint & Repair Cost | $1,000 | |
7 | Annual Insurance Cost | $1,500 | Annual Insurance Cost | $1,300 | ||
8 | Annual Registration & Fees | $200 | Yearly DMV/DEQ fees, property tax | Annual Registration & Fees | $60 | |
9 | State and local sales tax % | 3 | Total of all tax rates | State and local sales tax % | 3 | Autofilled from left side |
10 | Principal Amount Financed | $5,000 | Loan amount if financed | Principal Amount Financed | $0 | |
11 | Interest Rate % | 3.50% | Example 3.55% = 3.55 | Interest Rate % | 3.50% | Autofilled from left side |
12 | Years Financed | 3 | Loan term in years | Years Financed | 3 | Autofilled from left side |
13 | ||||||
14 | Vehicle Average MPG | Complete if vehicle uses any fuel | Vehicle Average MPG | 21 | ||
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 | $7.310 | Complete if vehicle is EV or Plug-in | Electric Utility Rate - Dollars per kWh | $0.000 | |
18 | Miles per KWh | 3.5 | 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 12 years | 144000 | Auto calculated | Total miles after 12 years | 144000 | |
22 | Lifetime Depreciation | $33,000 | Auto calculated | Lifetime Depreciation | $18,000 | |
23 | Lifetime Maint & Repair Cost | $4,800 | Auto calculated | Lifetime Maint & Repair Cost | $12,000 | |
24 | Lifetime Insurance Cost | $18,000 | Auto calculated | Lifetime Insurance Cost | $15,600 | |
25 | Lifetime Registration & Fees Cost | $2,400 | Auto calculated | Lifetime Registration & Fees Cost | $720 | |
26 | Lifetime Fuel Cost | $0 | Lifetime Fuel Cost | $17,143 | ||
27 | Lifetime Electricity Cost | $30,075,429 | Auto calculated | Lifetime Electricity Cost | $0 | |
28 | Lifetime Loan Interest Cost | $554 | Auto calculated | Lifetime Loan Interest Cost | $0 | |
29 | ||||||
30 | Total Lifetime Cost | $30,134,182 | Auto calculated | Total Lifetime Cost | $63,463 | |
31 | Average Yearly Cost | $2,511,182 | Auto calculated | Average Yearly Cost | $5,289 | |
32 | Average Monthly Cost | $209,265.15 | Auto calculated | Average Monthly Cost | $440.71 | |
33 | Average Daily Cost | $6,879.95 | Auto calculated | Average Daily Cost | $14.49 | |
34 | Total Cost per Mile | $209.27 | Auto calculated | Total Cost per Mile | $0.44 | |
35 | Fuel and Electricity Cost per Mile | $208.86 | Auto calculated | Fuel and Electricity Cost per Mile | $0.12 | |
36 | Average Yearly Fuel and Electricity Cost | $2,506,285.71 | Auto calculated | Average Yearly Fuel and Electricity Cost | $1,428.57 | |
37 | Average Monthly Fuel and Electricity Cost | $208,857.14 | Auto calculated | Average Monthly Fuel and Electricity Cost | $119.05 | |
38 | Average Daily Fuel and Electricity Cost | $6,866.54 | Auto calculated | Average Daily Fuel and Electricity Cost | $3.91 | |
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 |