Tesla Cash Flow

	A	B	C	D	E	F	G	H
1
2			Buy Model 3 AWD	Buy Model 3 PD	Keep 2014 BWW M235i
3		MSRP	62000	75500	52000
4		Delivery Fee	1200	1200	0
5		Taxes	5580	6795	6795
6		Total	68780	83495	58795
7		Incentives	10500	10500	0
8		Net amount	58280	72995	58795
9		Resell after 3 years	40300	49075	18000
10
11		Total depreciation	17980	23920	40795
12			499.44	664.44	485.65
13
14	Cash Flow	Depreciation	Maintenance	Gas/Charging	Total	Per Month (36)
15	Model 3 AWD	17980	0	1300	19280	536	-1370
16	Model 3 PD	23920	0	1300	25220	664	4570	126.9444444
17	2014 BWW M235i	16000	1750	2900	20650	573.6111111	0
18
19
20
21
22
23
24
25
26
27
28
29
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