hello friends. i haven't been spending so much time on tesla. just wanted to post a quick update with what i feel are fairly optimistic delivery numbers. i wanted to have something ready for when real numbers are out. it's not great so feel free to share your comments. thanks.
one majorly important change for those not familiar with my past work - model 3 leasing has been introduced. this means not all model 3 units will flow into the revenue line.
… |
s deliveries |
x deliveries |
s+x deliveries |
3 deliveries |
3 production |
est cash gm for model 3 |
lease 3s % veh |
lease s/x % veh |
avg price s+x |
avg price model 3 |
|
revenue |
auto sales ex 3 |
auto sales mod 3 |
auto leasing |
1 time revenue |
zev credits |
total auto |
|
energy storage |
solarcity |
maxwell/grohmann |
services/other |
total revenue |
|
cost of revenue |
auto sales ex 3 |
auto sales mod 3 |
auto leasing |
total auto |
energy storage |
solarcity |
maxwell/grohmann |
services & other |
total cost of rev |
|
gross profit |
|
auto ex 3 gm |
auto gaap gm |
auto lease gm |
auto gaap ex 3 gm |
auto-zev ex 3 gm |
model 3 gm |
auto-zev incl 3 gm |
storage gm |
scty gm |
mxwl/grohmann gm |
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]
Jun-19
[/TD2][TD2]
Mar-19
[/TD2][TD2]
Dec-18
[/TD2][TD2]
Sep-18
[/TD2]
[TD2]9,000[/TD2][TD2]6,000[/TD2][TD2]13,500[/TD2][TD2]14,495[/TD2]
[TD2]9,100[/TD2][TD2]6,100[/TD2][TD2]14,107[/TD2][TD2]13,215[/TD2]
[TD2]
18,100
[/TD2][TD2]
12,100
[/TD2][TD2]
27,607
[/TD2][TD2]
27,710
[/TD2]
[TD2]
73,500
[/TD2][TD2]
50,900
[/TD2][TD2]
63,359
[/TD2][TD2]
56,065
[/TD2]
[TD2]
75,000
[/TD2][TD2]
62,950
[/TD2][TD2]
60,000
[/TD2][TD2]
53,239
[/TD2]
[TD2]31.6%[/TD2][TD2]32.2%[/TD2][TD2]33.3%[/TD2][TD2]34.5%[/TD2]
[TD2]
0.10
[/TD2][TD2]
-
[/TD2][TD2]
-
[/TD2][TD2]
-
[/TD2]
[TD2]
0.10
[/TD2][TD2]
0.10
[/TD2][TD2]
0.13
[/TD2][TD2]
0.09
[/TD2]
[TD2]
98.00
[/TD2][TD2]
102.00
[/TD2][TD2]
106.00
[/TD2][TD2]
104.80
[/TD2]
[TD2]
53.00
[/TD2][TD2]
56.75
[/TD2][TD2]
55.75
[/TD2][TD2]
56.78
[/TD2]
[TD2]1,594,264[/TD2][TD2]1,105,680[/TD2][TD2]2,540,646[/TD2][TD2]2,642,647[/TD2]
[TD2]3,505,950[/TD2][TD2]2,888,649[/TD2][TD2]3,532,057[/TD2][TD2]3,183,389[/TD2]
[TD2]225,000[/TD2][TD2]215,120[/TD2][TD2]249,748[/TD2][TD2]220,461[/TD2]
[TD2]0[/TD2][TD2]-501,000[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]15,000[/TD2][TD2]15,412[/TD2][TD2]768[/TD2][TD2]52,269[/TD2]
[TD2]
5,340,214
[/TD2][TD2]
3,723,861
[/TD2][TD2]
6,323,219
[/TD2][TD2]
6,098,766
[/TD2]
[TD2]133,950[/TD2][TD2]129,094[/TD2][TD2]131,497[/TD2][TD2]105,317[/TD2]
[TD2]235,125[/TD2][TD2]195,567[/TD2][TD2]240,000[/TD2][TD2]294,000[/TD2]
[TD2]12,000[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]535,000[/TD2][TD2]492,942[/TD2][TD2]531,157[/TD2][TD2]326,330[/TD2]
[TD2]
6,256,289
[/TD2][TD2]
4,541,464
[/TD2][TD2]
7,225,873
[/TD2][TD2]
6,824,413
[/TD2]
[TD2]1,291,354[/TD2][TD2]945,624[/TD2][TD2]1,850,532[/TD2][TD2]1,875,125[/TD2]
[TD2]2,815,278[/TD2][TD2]2,319,585[/TD2][TD2]2,807,985[/TD2][TD2]2,530,794[/TD2]
[TD2]130,500[/TD2][TD2]117,092[/TD2][TD2]127,731[/TD2][TD2]119,283[/TD2]
[TD2]
4,237,132
[/TD2][TD2]
2,973,301
[/TD2][TD2]
4,786,248
[/TD2][TD2]
4,525,202
[/TD2]
[TD2]160,740[/TD2][TD2]159,456[/TD2][TD2]160,706[/TD2][TD2]124,754[/TD2]
[TD2]189,276[/TD2][TD2]157,431[/TD2][TD2]168,000[/TD2][TD2]205,800[/TD2]
[TD2]27,000[/TD2][TD2]11,000[/TD2][TD2]11,000[/TD2][TD2]11,000[/TD2]
[TD2]695,500[/TD2][TD2]674,533[/TD2][TD2]657,019[/TD2][TD2]433,992[/TD2]
[TD2]
5,309,647
[/TD2][TD2]
3,975,721
[/TD2][TD2]
5,782,973
[/TD2][TD2]
5,300,748
[/TD2]
[TD2]
946,642
[/TD2][TD2]
565,743
[/TD2][TD2]
1,442,900
[/TD2][TD2]
1,523,665
[/TD2]
[TD2]19.0%[/TD2][TD2]14.5%[/TD2][TD2]27.2%[/TD2][TD2]29.0%[/TD2]
[TD2]20.7%[/TD2][TD2]20.2%[/TD2][TD2]24.3%[/TD2][TD2]25.8%[/TD2]
[TD2]42.0%[/TD2][TD2]45.6%[/TD2][TD2]48.9%[/TD2][TD2]45.9%[/TD2]
[TD2]22.5%[/TD2][TD2]21.7%[/TD2][TD2]29.1%[/TD2][TD2]31.6%[/TD2]
[TD2]21.8%[/TD2][TD2]19.5%[/TD2][TD2]29.1%[/TD2][TD2]30.3%[/TD2]
[TD2]19.7%[/TD2][TD2]19.7%[/TD2][TD2]20.5%[/TD2][TD2]20.5%[/TD2]
[TD2]20.4%[/TD2][TD2]19.6%[/TD2][TD2]24.3%[/TD2][TD2]25.2%[/TD2]
[TD2]-20.0%[/TD2][TD2]-23.5%[/TD2][TD2]-22.2%[/TD2][TD2]-18.5%[/TD2]
[TD2]19.5%[/TD2][TD2]19.5%[/TD2][TD2]30.0%[/TD2][TD2]30.0%[/TD2]
[TD2]-125.0%[/TD2][TD2]-100.0%[/TD2][TD2]-100.0%[/TD2][TD2]-100.0%[/TD2]
[TD2]-30.0%[/TD2][TD2]-36.8%[/TD2][TD2]-23.7%[/TD2][TD2]-33.0%[/TD2]
[TD2]300,000[/TD2][TD2]295,174[/TD2][TD2]306,297[/TD2][TD2]315,848[/TD2]
[TD2]575,000[/TD2][TD2]573,929[/TD2][TD2]522,452[/TD2][TD2]599,876[/TD2]
[TD2]25,000[/TD2][TD2]43,471[/TD2][TD2]5,615[/TD2][TD2]26,184[/TD2]
[TD2]45,000[/TD2][TD2]45,000[/TD2][TD2]50,000[/TD2][TD2]35,000[/TD2]
[TD2]130,000[/TD2][TD2]130,000[/TD2][TD2]145,000[/TD2][TD2]130,000[/TD2]
[TD2]
1,075,000
[/TD2][TD2]
1,087,574
[/TD2][TD2]
1,029,364
[/TD2][TD2]
1,106,908
[/TD2]
[TD2]
-128,358
[/TD2][TD2]
-521,831
[/TD2][TD2]
413,536
[/TD2][TD2]
416,757
[/TD2]
[TD2]17,000[/TD2][TD2]8,762[/TD2][TD2]7,348[/TD2][TD2]6,907[/TD2]
[TD2]-115,000[/TD2][TD2]-104,453[/TD2][TD2]-121,723[/TD2][TD2]-122,220[/TD2]
[TD2]-53,000[/TD2][TD2]-53,000[/TD2][TD2]-53,000[/TD2][TD2]-53,000[/TD2]
[TD2]25,750[/TD2][TD2]25,750[/TD2][TD2]-14,205[/TD2][TD2]22,876[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]
-253,608
[/TD2][TD2]
-644,772
[/TD2][TD2]
231,956
[/TD2][TD2]
271,320
[/TD2]
[TD2]23,000[/TD2][TD2]22,873[/TD2][TD2]21,878[/TD2][TD2]16,647[/TD2]
[TD2]
-276,608
[/TD2][TD2]
-667,645
[/TD2][TD2]
210,078
[/TD2][TD2]
254,673
[/TD2]
[TD2]25,000[/TD2][TD2]34,490[/TD2][TD2]70,595[/TD2][TD2]-56,843[/TD2]
[TD2]
-301,608
[/TD2][TD2]
-702,135
[/TD2][TD2]
139,483
[/TD2][TD2]
311,516
[/TD2]
[TD2]176,000[/TD2][TD2]172,989[/TD2][TD2]172,026[/TD2][TD2]170,893[/TD2]
[TD2]176,000[/TD2][TD2]172,989[/TD2][TD2]179,026[/TD2][TD2]178,196[/TD2]
[TD2]
-1.71
[/TD2][TD2]
-4.06
[/TD2][TD2]
0.78
[/TD2][TD2]
1.75
[/TD2]
[TD2]-301,608[/TD2][TD2]-702,135[/TD2][TD2]139,483[/TD2][TD2]311,516[/TD2]
[TD2]210,000[/TD2][TD2]208,378[/TD2][TD2]205,313[/TD2][TD2]204,728[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]-91,608[/TD2][TD2]-493,757[/TD2][TD2]344,796[/TD2][TD2]516,244[/TD2]
[TD2]
-0.52
[/TD2][TD2]
-2.85
[/TD2][TD2]
1.93
[/TD2][TD2]
2.90
[/TD2]