i've been off the forum for a while but still have my modeling for the company. i attached an update below. street estimates still look too low for the december quarter. there's an upside surprise catalyst in that i have not modeled additional credits from the fiat/chrysler deal. i would expect some of that deferred revenue to start flowing through this quarter. once we have some clarity i would be able to think more intelligently about the future periods. my guess is around $100m/quarter, so that would be around another 50c in gaap eps vs what i have shown.
i also haven't added the impact of solarcity installations/revenue increasing profitably. not sure that could happen this quarter. with the hiring the opex may go up there.
i am positioning for an s&p 500 index addition in 2020. i think any good active large cap manager would be aware of this, and it sets up a very natural trade for them in the stock. most active large cap managers are benchmarked to the s&p - and here's the easy outperformance trade based on the s&p index addition: underweight apple, and take tesla to a weight above what it would be if included in the index. on the day tesla is added to the s&p, sell the extra tesla and renormalize your apple weight (or whatever other stocks you underweighted). i think that's part of the reason we have this nonstop lift, you're seeing a huge amount of active managers almost being forced to buy. when it's added to the index, the index trackers will be forced to buy.
… |
… |
s deliveries |
x deliveries |
s+x deliveries |
3 deliveries |
3 production |
lease 3s % veh |
lease s/x % veh |
avg price s+x (calc'd) |
avg price model 3 (set) |
non-zev credits per delivery |
zev credits |
|
revenue |
auto sales ex 3 |
auto sales mod 3 |
auto leasing |
zev+nonzev credits |
1 time revenue |
total auto |
|
energy storage |
solarcity |
grohmann |
services/other |
total revenue |
|
cost of revenue |
auto sales ex 3 |
auto sales mod 3 |
auto leasing |
1 time cogs |
total auto |
energy storage |
solarcity |
grohmann |
services & other |
total cost of rev |
|
gross profit |
|
auto ex 3 ex credits gm |
auto gaap gm |
auto lease gm |
auto gaap ex 3 gm |
model 3 gm ex credits |
auto-credits incl 3 gm |
storage gm |
scty gm |
maxwell/grohmann |
services gm |
|
opex |
tesla r&d |
tesla sg&a |
1 time costs |
solarcity r&d |
solarcity sg&a |
total opex |
|
op income |
|
interest inc |
interest exp |
scty interest |
other income exp |
1time scty gain |
pretax income |
income tax |
net income |
non-cont int. |
net inc to common |
|
basic shares |
diluted shares |
|
diluted gaap eps |
gaap net income |
+ stock based comp |
+ one time scty |
non-gaap net income |
non-gaap diluted eps |
[TD2]
luv est
[/TD2][TD2]
tsla
[/TD2][TD2]
tsla
[/TD2][TD2]
tsla
[/TD2]
[TD2]
Dec-19
[/TD2][TD2]
Sep-19
[/TD2][TD2]
Jun-19
[/TD2][TD2]
Mar-19
[/TD2]
[TD2]10,000[/TD2][TD2]8,741[/TD2][TD2]8,787[/TD2][TD2]6,000[/TD2]
[TD2]9,450[/TD2][TD2]8,742[/TD2][TD2]8,935[/TD2][TD2]6,091[/TD2]
[TD2]
19,450
[/TD2][TD2]
17,483
[/TD2][TD2]
17,722
[/TD2][TD2]
12,091
[/TD2]
[TD2]
92,550
[/TD2][TD2]
79,703
[/TD2][TD2]
77,634
[/TD2][TD2]
50,900
[/TD2]
[TD2]
87,000
[/TD2][TD2]
79,837
[/TD2][TD2]
72,531
[/TD2][TD2]
62,950
[/TD2]
[TD2]
0.07
[/TD2][TD2]
0.08
[/TD2][TD2]
0.06
[/TD2][TD2]
-
[/TD2]
[TD2]
0.14
[/TD2][TD2]
0.15
[/TD2][TD2]
0.10
[/TD2][TD2]
0.11
[/TD2]
[TD2]
95.00
[/TD2][TD2]
95.18
[/TD2][TD2]
97.21
[/TD2][TD2]
113.65
[/TD2]
[TD2]
50.00
[/TD2][TD2]
50.00
[/TD2][TD2]
50.00
[/TD2][TD2]
54.00
[/TD2]
[TD2]
1.22
[/TD2][TD2]
1.38
[/TD2][TD2]
1.17
[/TD2][TD2]
3.18
[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]15,412[/TD2]
[TD2]1,589,065[/TD2][TD2]1,417,644[/TD2][TD2]1,545,857[/TD2][TD2]1,219,184[/TD2]
[TD2]4,303,575[/TD2][TD2]3,550,356[/TD2][TD2]3,575,051[/TD2][TD2]2,574,076[/TD2]
[TD2]240,100[/TD2][TD2]221,000[/TD2][TD2]208,362[/TD2][TD2]215,120[/TD2]
[TD2]137,000[/TD2][TD2]134,000[/TD2][TD2]111,219[/TD2][TD2]215,981[/TD2]
[TD2]20,000[/TD2][TD2]30,000[/TD2][TD2]-64,100[/TD2][TD2]-500,500[/TD2]
[TD2]
6,289,740
[/TD2][TD2]
5,353,000
[/TD2][TD2]
5,376,389
[/TD2][TD2]
3,723,861
[/TD2]
[TD2]280,250[/TD2][TD2]281,430[/TD2][TD2]244,850[/TD2][TD2]129,094[/TD2]
[TD2]101,844[/TD2][TD2]120,570[/TD2][TD2]123,358[/TD2][TD2]195,567[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]575,000[/TD2][TD2]548,000[/TD2][TD2]605,079[/TD2][TD2]492,942[/TD2]
[TD2]
7,246,834
[/TD2][TD2]
6,303,000
[/TD2][TD2]
6,349,676
[/TD2][TD2]
4,541,464
[/TD2]
[TD2]1,223,580[/TD2][TD2]1,102,708[/TD2][TD2]1,264,570[/TD2][TD2]1,051,304[/TD2]
[TD2]3,442,860[/TD2][TD2]2,911,292[/TD2][TD2]3,038,793[/TD2][TD2]2,213,705[/TD2]
[TD2]127,253[/TD2][TD2]117,000[/TD2][TD2]106,322[/TD2][TD2]117,092[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]-49,600[/TD2][TD2]-408,800[/TD2]
[TD2]
4,793,693
[/TD2][TD2]
4,131,000
[/TD2][TD2]
4,360,085
[/TD2][TD2]
2,973,301
[/TD2]
[TD2]221,398[/TD2][TD2]215,133[/TD2][TD2]224,369[/TD2][TD2]159,456[/TD2]
[TD2]83,512[/TD2][TD2]98,867[/TD2][TD2]101,154[/TD2][TD2]157,431[/TD2]
[TD2]11,000[/TD2][TD2]11,000[/TD2][TD2]11,000[/TD2][TD2]11,000[/TD2]
[TD2]678,500[/TD2][TD2]656,000[/TD2][TD2]732,022[/TD2][TD2]674,533[/TD2]
[TD2]
5,788,103
[/TD2][TD2]
5,112,000
[/TD2][TD2]
5,428,630
[/TD2][TD2]
3,975,721
[/TD2]
[TD2]
1,458,731
[/TD2][TD2]
1,191,000
[/TD2][TD2]
921,046
[/TD2][TD2]
565,743
[/TD2]
[TD2]23.0%[/TD2][TD2]22.2%[/TD2][TD2]18.2%[/TD2][TD2]13.8%[/TD2]
[TD2]23.8%[/TD2][TD2]22.8%[/TD2][TD2]18.9%[/TD2][TD2]20.2%[/TD2]
[TD2]47.0%[/TD2][TD2]47.1%[/TD2][TD2]49.0%[/TD2][TD2]45.6%[/TD2]
[TD2]32.0%[/TD2][TD2]32.3%[/TD2][TD2]26.6%[/TD2][TD2]33.9%[/TD2]
[TD2]20.0%[/TD2][TD2]18.0%[/TD2][TD2]15.0%[/TD2][TD2]14.0%[/TD2]
[TD2]21.8%[/TD2][TD2]20.4%[/TD2][TD2]17.3%[/TD2][TD2]15.6%[/TD2]
[TD2]21.0%[/TD2][TD2]23.6%[/TD2][TD2]8.4%[/TD2][TD2]-23.5%[/TD2]
[TD2]18.0%[/TD2][TD2]18.0%[/TD2][TD2]18.0%[/TD2][TD2]19.5%[/TD2]
[TD2]-100.0%[/TD2][TD2]-100.0%[/TD2][TD2]-100.0%[/TD2][TD2]-100.0%[/TD2]
[TD2]-18.0%[/TD2][TD2]-19.7%[/TD2][TD2]-21.0%[/TD2][TD2]-36.8%[/TD2]
[TD2]315,000[/TD2][TD2]304,000[/TD2][TD2]293,898[/TD2][TD2]295,174[/TD2]
[TD2]525,000[/TD2][TD2]506,000[/TD2][TD2]557,261[/TD2][TD2]573,929[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]117,345[/TD2][TD2]43,471[/TD2]
[TD2]30,000[/TD2][TD2]30,000[/TD2][TD2]30,000[/TD2][TD2]45,000[/TD2]
[TD2]90,000[/TD2][TD2]90,000[/TD2][TD2]90,000[/TD2][TD2]130,000[/TD2]
[TD2]
960,000
[/TD2][TD2]
930,000
[/TD2][TD2]
1,088,504
[/TD2][TD2]
1,087,574
[/TD2]
[TD2]
498,731
[/TD2][TD2]
261,000
[/TD2][TD2]
-167,458
[/TD2][TD2]
-521,831
[/TD2]
[TD2]15,000[/TD2][TD2]15,000[/TD2][TD2]10,362[/TD2][TD2]8,762[/TD2]
[TD2]-132,000[/TD2][TD2]-132,000[/TD2][TD2]-118,979[/TD2][TD2]-104,453[/TD2]
[TD2]-53,000[/TD2][TD2]-53,000[/TD2][TD2]-53,000[/TD2][TD2]-53,000[/TD2]
[TD2]0[/TD2][TD2]85,000[/TD2][TD2]-40,756[/TD2][TD2]25,750[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]
328,731
[/TD2][TD2]
176,000
[/TD2][TD2]
-369,831
[/TD2][TD2]
-644,772
[/TD2]
[TD2]26,000[/TD2][TD2]26,000[/TD2][TD2]19,431[/TD2][TD2]22,873[/TD2]
[TD2]
302,731
[/TD2][TD2]
150,000
[/TD2][TD2]
-389,262
[/TD2][TD2]
-667,645
[/TD2]
[TD2]7,000[/TD2][TD2]7,000[/TD2][TD2]19,072[/TD2][TD2]34,490[/TD2]
[TD2]
295,731
[/TD2][TD2]
143,000
[/TD2][TD2]
-408,334
[/TD2][TD2]
-702,135
[/TD2]
[TD2]181,500[/TD2][TD2]179,000[/TD2][TD2]176,654[/TD2][TD2]172,989[/TD2]
[TD2]190,000[/TD2][TD2]184,000[/TD2][TD2]176,654[/TD2][TD2]172,989[/TD2]
[TD2]
1.56
[/TD2][TD2]
0.78
[/TD2][TD2]
-2.31
[/TD2][TD2]
-4.06
[/TD2]
[TD2]295,731[/TD2][TD2]143,000[/TD2][TD2]-408,334[/TD2][TD2]-702,135[/TD2]
[TD2]200,000[/TD2][TD2]199,000[/TD2][TD2]209,863[/TD2][TD2]208,378[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]495,731[/TD2][TD2]342,000[/TD2][TD2]-198,471[/TD2][TD2]-493,757[/TD2]
[TD2]
2.61
[/TD2][TD2]
1.86
[/TD2][TD2]
-1.12
[/TD2][TD2]
-2.85
[/TD2]