ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Cars Sold392000Revenue$25,247,000,000.00
2
Average Car Price$54,821.43Earnings$4,458,800,000.00
3
Margin on Car Sales19.00%
4
Energy Generation and Storage1531000000Market Price PE$89,176,000,000.00Stock Price$494.87
5
- Margin10.00%Market Price 2x Rev$50,494,000,000.00Stock Price$280.21
6
Services and Other2226000000
7
- Margin10.00%This Year2019
8
PE20Current Price$734.70
9
Shares180200000Target Year2024
10
Future Price$494.87
11
Model S/X Sold42000Return-32.64%
12
Model S/X Price$95,000.00Annual Return-7.60%
13
Model 3/Y Sold350000
14
Model 3/Y Price$50,000.00
15
Cybertruck Sold0Notes:Change green fields.
16
Cybertruck Price$50,000.00Don't change red fields.
17
Roadster Sold0Don't change yellow fields.
18
Roadster Price$250,000.00
19
20
21
Note: Based on the Q4 2019 (Feb 2020) numbers, random ass split between models, a *no growth*.
22
23
Reminder: This model assumes NO growth in car sales or other revenue.
24
25
Updates From Last Tab:
26
- Combined S/X and 3/Y
27
- Added in Energy and Services revenue based on 2019 numbers.
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