2016 Leaf Cashflow over Time (rough!)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Assumptions (feel free to save your own copy of this spreadsheet and change these)
2
Monthly Driving (miles):Efficiency of competing car (MPG)Gas Cost ($ per gallon)Electricity Cost ($ per kWh)Annual Return on Investments
3
1000352.50.10.05
4
5
6
MonthDescriptionAmountNet CashflowFuel Cost (Gas)Fuel Cost (electricity)Fuel Savings (cumulative)Cashflow after Fuel SavingsInvestment Returns (cumulative)Cashflow after Investment Returns
7
9/1/2016Purchase Date000000
8
Oct 2016No car payment yet00$71.43$22.22$49.21$49.21$0.21$49.41
9
10/1/2016Sold old car on Craigslist50005000$71.43$22.22$98.41$5,098.41$21.45$5,119.86
10
10/2/2016County New-Car Registration Fees-6004400$71.43$22.22$147.62$4,547.62$40.40$4,588.02
11
11/1/2016Car Payment-391.494008.51$71.43$22.22$196.83$4,205.34$57.92$4,263.25
12
Dec 2016Car Payment-391.493617.02$71.43$22.22$246.03$3,863.05$74.02$3,937.07
13
12/31/2016Extra Insurance Cost-47.53569.52$71.43$22.22$295.24$3,864.76$90.12$3,954.88
14
1/1/2017Car Payment-391.493178.03$71.43$22.22$344.44$3,522.47$104.80$3,627.27
15
Feb 2017Car Payment-391.492786.54$71.43$22.22$393.65$3,180.19$118.05$3,298.24
16
3/1/2017Car Payment-391.492395.05$71.43$22.22$442.86$2,837.91$129.87$2,967.78
17
Apr 2017Car Payment-391.492003.56$71.43$22.22$492.06$2,495.62$140.27$2,635.89
18
4/15/2017Federal Tax Credit75009503.56$71.43$22.22$541.27$10,044.83$182.12$10,226.95
19
4/15/2017State Tax Credit465314156.56$71.43$22.22$590.48$14,747.04$243.57$14,990.60
20
5/1/2017Car Payment-391.4913765.07$71.43$22.22$639.68$14,404.75$303.59$14,708.34
21
Jun 2017Car Payment-391.4913373.58$71.43$22.22$688.89$14,062.47$362.18$14,424.65
22
7/1/2017Car Payment-391.4912982.09$71.43$22.22$738.10$13,720.19$419.35$14,139.53
23
Aug 2017Car Payment-391.4912590.6$71.43$22.22$787.30$13,377.90$475.09$13,852.99
24
9/1/2017Car Payment-391.4912199.11$71.43$22.22$836.51$13,035.62$529.41$13,565.02
25
Oct 2017Car Payment-391.4911807.62$71.43$22.22$885.71$12,693.33$582.29$13,275.63
26
11/1/2017Car Payment-391.4911416.13$71.43$22.22$934.92$12,351.05$633.76$12,984.81
27
Dec 2017Car Payment-391.4911024.64$71.43$22.22$984.13$12,008.77$683.79$12,692.56
28
12/31/2017Extra Insurance Cost-19010834.64$71.43$22.22$1,033.33$11,867.97$733.24$12,601.22
29
1/1/2018Car Payment-391.4910443.15$71.43$22.22$1,082.54$11,525.69$781.27$12,306.96
30
Feb 2018Car Payment-391.4910051.66$71.43$22.22$1,131.75$11,183.41$827.86$12,011.27
31
3/1/2018Car Payment-391.499660.17$71.43$22.22$1,180.95$10,841.12$873.04$11,714.16
32
Apr 2018Car Payment-391.499268.68$71.43$22.22$1,230.16$10,498.84$916.78$11,415.62
33
5/1/2018Car Payment-391.498877.19$71.43$22.22$1,279.37$10,156.56$959.10$11,115.66
34
Jun 2018Car Payment-391.498485.7$71.43$22.22$1,328.57$9,814.27$999.99$10,814.26
35
7/1/2018Car Payment-391.498094.21$71.43$22.22$1,377.78$9,471.99$1,039.46$10,511.45
36
Aug 2018Car Payment-391.497702.72$71.43$22.22$1,426.98$9,129.70$1,077.50$10,207.20
37
9/1/2018Car Payment-391.497311.23$71.43$22.22$1,476.19$8,787.42$1,114.11$9,901.54
38
Oct 2018Car Payment-391.496919.74$71.43$22.22$1,525.40$8,445.14$1,149.30$9,594.44
39
11/1/2018Car Payment-391.496528.25$71.43$22.22$1,574.60$8,102.85$1,183.06$9,285.92
40
Dec 2018Car Payment-391.496136.76$71.43$22.22$1,623.81$7,760.57$1,215.40$8,975.97
41
12/31/2018Extra Insurance Cost-1905946.76$71.43$22.22$1,673.02$7,619.78$1,247.15$8,866.93
42
1/1/2019Car Payment-391.495555.27$71.43$22.22$1,722.22$7,277.49$1,277.47$8,554.96
43
Feb 2019Car Payment-391.495163.78$71.43$22.22$1,771.43$6,935.21$1,306.37$8,241.58
44
3/1/2019Car Payment-391.494772.29$71.43$22.22$1,820.63$6,592.92$1,333.84$7,926.76
45
Apr 2019Car Payment-391.494380.8$71.43$22.22$1,869.84$6,250.64$1,359.88$7,610.52
46
5/1/2019Car Payment-391.493989.31$71.43$22.22$1,919.05$5,908.36$1,384.50$7,292.86
47
Jun 2019Car Payment-391.493597.82$71.43$22.22$1,968.25$5,566.07$1,407.69$6,973.77
48
7/1/2019Car Payment-391.493206.33$71.43$22.22$2,017.46$5,223.79$1,429.46$6,653.25
49
Aug 2019Car Payment-391.492814.84$71.43$22.22$2,066.67$4,881.51$1,449.80$6,331.31
50
9/1/2019Car Payment-391.492423.35$71.43$22.22$2,115.87$4,539.22$1,468.71$6,007.94
51
Oct 2019Car Payment-391.492031.86$71.43$22.22$2,165.08$4,196.94$1,486.20$5,683.14
52
11/1/2019Car Payment-391.491640.37$71.43$22.22$2,214.29$3,854.66$1,502.26$5,356.92
53
Dec 2019Car Payment-391.491248.88$71.43$22.22$2,263.49$3,512.37$1,516.90$5,029.27
54
12/31/2019Extra Insurance Cost-1901058.88$71.43$22.22$2,312.70$3,371.58$1,530.94$4,902.52
55
1/1/2020Car Payment-391.49667.39$71.43$22.22$2,361.90$3,029.29$1,543.57$4,572.86
56
Feb 2020Car Payment-391.49275.9$71.43$22.22$2,411.11$2,687.01$1,554.76$4,241.77
57
3/1/2020Car Payment-391.49-115.59$71.43$22.22$2,460.32$2,344.73$1,564.53$3,909.26
58
Apr 2020Car Payment-391.49-507.08$71.43$22.22$2,509.52$2,002.44$1,572.88$3,575.32
59
5/1/2020Car Payment-391.49-898.57$71.43$22.22$2,558.73$1,660.16$1,579.79$3,239.95
60
Jun 2020Car Payment-391.49-1290.06$71.43$22.22$2,607.94$1,317.88$1,585.28$2,903.16
61
7/1/2020Car Payment-391.49-1681.55$71.43$22.22$2,657.14$975.59$1,589.35$2,564.94
62
Aug 2020Car Payment-391.49-2073.04$71.43$22.22$2,706.35$633.31$1,591.99$2,225.30
63
9/1/2020Car Payment-391.49-2464.53$71.43$22.22$2,755.56$291.03$1,593.20$1,884.23
64
Oct 2020Car Payment-391.49-2856.02$71.43$22.22$2,804.76-$51.26$1,592.99$1,541.73
65
11/1/2020Car Payment-391.49-3247.51$71.43$22.22$2,853.97-$393.54$1,591.35$1,197.81
66
Dec 2020Car Payment-391.49-3639$71.43$22.22$2,903.17-$735.83$1,588.28$852.46
67
12/31/2020Extra Insurance Cost-190-3829$71.43$22.22$2,952.38-$876.62$1,584.63$708.01
68
1/1/2021Car Payment-391.49-4220.49$71.43$22.22$3,001.59-$1,218.90$1,579.55$360.65
69
Feb 2021Car Payment-391.49-4611.98$71.43$22.22$3,050.79-$1,561.19$1,573.04$11.86
70
3/1/2021Car Payment-391.49-5003.47$71.43$22.22$3,100.00-$1,903.47$1,565.11-$338.36
71
Apr 2021Car Payment-391.49-5394.96$71.43$22.22$3,149.21-$2,245.75$1,555.76-$690.00
72
5/1/2021Car Payment-391.49-5786.45$71.43$22.22$3,198.41-$2,588.04$1,544.97-$1,043.06
73
Jun 2021Car Payment-391.49-6177.94$71.43$22.22$3,247.62-$2,930.32$1,532.76-$1,397.56
74
7/1/2021Car Payment-391.49-6569.43$71.43$22.22$3,296.83-$3,272.60$1,519.13-$1,753.48
75
8/1/2021Car Payment-391.49-6960.92$71.43$22.22$3,346.03-$3,614.89$1,504.07-$2,110.82
76
9/1/2021Car Payment-391.49-7352.41$71.43$22.22$3,395.24-$3,957.17$1,487.58-$2,469.60
77
10/1/2021Car Payment-391.49-7743.9$71.43$22.22$3,444.44-$4,299.46$1,469.66-$2,829.79
78
11/1/2021Car Payment-391.49-8135.39$71.43$22.22$3,493.65-$4,641.74$1,450.32-$3,191.42
79
12/1/2021Car Payment-391.49-8526.88$71.43$22.22$3,542.86-$4,984.02$1,429.56-$3,554.47
80
12/31/2021Extra Insurance Cost-190-8716.88$71.43$22.22$3,592.06-$5,124.82$1,408.20-$3,716.61
81
1/1/2022Car Payment-391.49-9108.37$71.43$22.22$3,641.27-$5,467.10$1,385.42-$4,081.68
82
2/1/2022Car Payment-391.49-9499.86$71.43$22.22$3,690.48-$5,809.38$1,361.22-$4,448.17
83
3/1/2022Car Payment-391.49-9891.35$71.43$22.22$3,739.68-$6,151.67$1,335.58-$4,816.08
84
4/1/2022Car Payment-391.49-10282.84$71.43$22.22$3,788.89-$6,493.95$1,308.53-$5,185.42
85
5/1/2022Car Payment-391.49-10674.33$71.43$22.22$3,838.10-$6,836.23$1,280.04-$5,556.19
86
6/1/2022Car Payment-391.49-11065.82$71.43$22.22$3,887.30-$7,178.52$1,250.13-$5,928.39
87
7/1/2022Car Payment-391.49-11457.31$71.43$22.22$3,936.51-$7,520.80$1,218.79-$6,302.01
88
8/1/2022Car Payment-391.49-11848.8$71.43$22.22$3,985.71-$7,863.09$1,186.03-$6,677.05
89
9/1/2022Car Payment-391.49-12240.29$71.43$22.22$4,034.92-$8,205.37$1,151.84-$7,053.53
90
9/1/2022Car Payment-391.49-12631.78$71.43$22.22$4,084.13-$8,547.65$1,116.23-$7,431.43
91
11/1/2022Sell car (difference between Leaf and Scion value)5500-5957.31$71.43$22.22$3,985.71-$1,971.60$1,210.58-$761.02
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
 
 
Main menu