eBike Payoff Calculator

	A	C	D	E	F	G	H	I	J	L
1		Values	Units	Notes
2		10	mi	Round trip work commute
3		3	day/week	Days per week eBike is used for commute
4		30	mi/week	Weekly commuting miles
5		10	mi/week	Other trips on eBike saved from car, i.e. grocery store trips
6		39	weeks	Assumes bike is used 3/4 of a year
7		1560	total miles	eBike miles accumulated in one year time period
8		$ 3.50	$/gal	Price of Gas
9		24	mi/gal	Fuel economy of car
10		65	gallons	Gallons of gas saved
11		$ 227.50	Dollars	Annual gas costs saved
12		$0.00	Dollars	Weekly parking costs saved
13		$0.00	Dollars	Annual parking costs saved
14		$ 2,000.00	Dollars	Cost of eBike
15		$ 200.00	Dollars	Annual eBike costs, e.g. inner tubes, accessories
16
17
18		9.67	Years	Payoff time of eBike
19					Year 1	Year 2	Year 3	Year 4	Year 5
20	Car
21		227.5	gas		$5,327.50	$5,327.50	$5,327.50	$5,327.50	$5,327.50	Yearly
22		3600	payments		$5,327.50	$10,655.00	$15,982.50	$21,310.00	$26,637.50	Cumulative
23		1500	insurance
24		5327.5			-$1,727.50	-$5,455.00	-$9,182.50	-$12,910.00	-$16,637.50	Difference
25
26	Bike	2000	purchase		$3,600.00	$1,600.00	$1,600.00	$1,600.00	$1,600.00	Yearly
27		1000	maintenance and gear		$3,600.00	$5,200.00	$6,800.00	$8,400.00	$10,000.00	Cumulative
28		600	other transport
29		3600
30
31
32
33
34
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