here are my estimates. the street is far underestimating the loss - i come in at over $3 gaap loss per share on $3.02b revenue. revenues will be good. model 3 will run at -1400% gross margins by my count. curious to hear people's input. some notes:
1. i have put the solarcity fine in "1 time solarcity gain"
2. interest expense increases due to more loans
3. other income remains negative due to dollar weakness.
4. i keep opex about flat vs last quarter.
5. s&x running around 25% gross margins.
6. model 3 margins widely negative due to fixed costs spread over few cars (see q2 letter comment).
7. solar city, energy storage, and used cars sales all improving from last quarter.
8. i have no zev credits in the model although they may put in 20-40 million to help salvage how bad it looks.
9. comments welcome as always.
… |
ls veh % total |
avg price s+x |
avg price model 3 |
revenue |
auto sales ex 3 |
auto sales mod 3 |
auto leasing |
1 time autopilot |
zev credits |
total auto |
|
energy storage |
solarcity |
grohmann |
services/other |
total revenue |
|
cost of revenue |
auto sales ex 3 |
auto sales mod 3 |
auto leasing |
total auto |
|
energy storage |
solarcity |
grohmann |
services & other |
total cost of rev |
|
gross profit |
|
opex |
tesla r&d |
tesla sg&a |
1time acq cost |
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 eps |
[TD2]
luv q3-17
[/TD2][TD2]
Jun-17
[/TD2][TD2]
Mar-17
[/TD2][TD2]
Sep-16
[/TD2]
[TD2]
0.21
[/TD2][TD2]
0.19
[/TD2][TD2]
0.26
[/TD2][TD2]
0.32
[/TD2]
[TD2]
108.00
[/TD2][TD2]
107.27
[/TD2][TD2]
108.06
[/TD2][TD2]
105.40
[/TD2]
[TD2]
50.00
[/TD2][TD2]
0.00
[/TD2][TD2]
0.00
[/TD2][TD2]
0.00
[/TD2]
[TD2]2,212,348[/TD2][TD2]1,913,852[/TD2][TD2]2,000,060[/TD2][TD2]1,778,901[/TD2]
[TD2]8,690[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]253,395[/TD2][TD2]272,764[/TD2][TD2]254,540[/TD2][TD2]231,285[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]35,000[/TD2][TD2]0[/TD2]
[TD2]0[/TD2][TD2]100,000[/TD2][TD2]0[/TD2][TD2]138,541[/TD2]
[TD2]
2,474,433
[/TD2][TD2]
2,286,616
[/TD2][TD2]
2,289,600
[/TD2][TD2]
2,148,727
[/TD2]
[TD2]35,000[/TD2][TD2]15,680[/TD2][TD2]5,244[/TD2][TD2]23,334[/TD2]
[TD2]285,000[/TD2][TD2]271,100[/TD2][TD2]208,700[/TD2][TD2]0[/TD2]
[TD2]5,100[/TD2][TD2]10,200[/TD2][TD2]22,400[/TD2][TD2]0[/TD2]
[TD2]230,000[/TD2][TD2]205,961[/TD2][TD2]170,326[/TD2][TD2]126,375[/TD2]
[TD2]
3,029,533
[/TD2][TD2]
2,789,557
[/TD2][TD2]
2,696,270
[/TD2][TD2]
2,298,436
[/TD2]
[TD2]1,686,317[/TD2][TD2]1,472,578[/TD2][TD2]1,496,649[/TD2][TD2]1,355,102[/TD2]
[TD2]130,350[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]162,990[/TD2][TD2]175,433[/TD2][TD2]166,026[/TD2][TD2]161,959[/TD2]
[TD2]
1,979,657
[/TD2][TD2]
1,648,011
[/TD2][TD2]
1,662,675
[/TD2][TD2]
1,517,061
[/TD2]
[TD2]36,750[/TD2][TD2]19,414[/TD2][TD2]6,473[/TD2][TD2]24,281[/TD2]
[TD2]199,500[/TD2][TD2]184,348[/TD2][TD2]145,300[/TD2][TD2]0[/TD2]
[TD2]3,825[/TD2][TD2]7,600[/TD2][TD2]14,900[/TD2][TD2]0[/TD2]
[TD2]287,500[/TD2][TD2]263,569[/TD2][TD2]198,976[/TD2][TD2]120,359[/TD2]
[TD2]
2,507,232
[/TD2][TD2]
2,122,942
[/TD2][TD2]
2,028,324
[/TD2][TD2]
1,661,701
[/TD2]
[TD2]
522,301
[/TD2][TD2]
666,615
[/TD2][TD2]
667,946
[/TD2][TD2]
636,735
[/TD2]
[TD2]250,000[/TD2][TD2]324,774[/TD2][TD2]239,070[/TD2][TD2]214,302[/TD2]
[TD2]470,000[/TD2][TD2]407,757[/TD2][TD2]446,637[/TD2][TD2]336,811[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]67,000[/TD2][TD2]0[/TD2]
[TD2]30,000[/TD2][TD2]45,000[/TD2][TD2]44,800[/TD2][TD2]0[/TD2]
[TD2]145,000[/TD2][TD2]130,000[/TD2][TD2]127,988[/TD2][TD2]0[/TD2]
[TD2]
895,000
[/TD2][TD2]
907,531
[/TD2][TD2]
925,495
[/TD2][TD2]
551,113
[/TD2]
[TD2]
-372,699
[/TD2][TD2]
-240,916
[/TD2][TD2]
-257,549
[/TD2][TD2]
85,622
[/TD2]
[TD2]6,000[/TD2][TD2]4,785[/TD2][TD2]3,090[/TD2][TD2]2,858[/TD2]
[TD2]-65,000[/TD2][TD2]-54,441[/TD2][TD2]-46,146[/TD2][TD2]-46,713[/TD2]
[TD2]-54,000[/TD2][TD2]-54,000[/TD2][TD2]-53,200[/TD2][TD2]0[/TD2]
[TD2]-12,000[/TD2][TD2]-41,208[/TD2][TD2]-18,098[/TD2][TD2]-11,756[/TD2]
[TD2]-29,500[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]
-527,199
[/TD2][TD2]
-385,780
[/TD2][TD2]
-371,903
[/TD2][TD2]
30,011
[/TD2]
[TD2]20,000[/TD2][TD2]15,647[/TD2][TD2]25,278[/TD2][TD2]8,133[/TD2]
[TD2]
-547,199
[/TD2][TD2]
-401,427
[/TD2][TD2]
-397,181
[/TD2][TD2]
21,878
[/TD2]
[TD2]-50,000[/TD2][TD2]-65,030[/TD2][TD2]-66,904[/TD2][TD2]0[/TD2]
[TD2]
-497,199
[/TD2][TD2]
-336,397
[/TD2][TD2]
-330,277
[/TD2][TD2]
21,878
[/TD2]
[TD2]163,000[/TD2][TD2]165,212[/TD2][TD2]162,129[/TD2][TD2]148,991[/TD2]
[TD2]163,000[/TD2][TD2]165,212[/TD2][TD2]162,129[/TD2][TD2]156,935[/TD2]
[TD2]
-3.05
[/TD2][TD2]
-2.04
[/TD2][TD2]
-2.04
[/TD2][TD2]
0.14
[/TD2]