side-by-side my model vs. actual numbers. in the actual numbers i had to guess at some of the breakdowns which were not provided in the letter.
line item | q1 17 luv's est | q1 17 act. | q4 16 act. | q3 16 act. |
ls veh % total | | | | |
avg price | | | | |
revenue | | | | |
auto sales | | | | |
auto leasing | | | | |
1 time autopilot | | | | |
zev credits | | | | |
total auto | | | | |
| | | | |
energy storage | | | | |
solarcity | | | | |
grohmann | | | | |
services/other | | | | |
total revenue | | | | |
| | | | |
cost of revenue | | | | |
auto | | | | |
auto leasing | | | | |
total auto | | | | |
| | | | |
energy storage | | | | |
solarcity | | | | |
grohmann | | | | |
services & other | | | | |
total cost of rev | | | | |
| | | | |
gross profit[/B] | | | | |
[TD2]
0.25
[/TD2][TD2]
0.26
[/TD2][TD2]
0.25
[/TD2][TD2]
0.32
[/TD2]
[TD2]
105.40
[/TD2][TD2]
107.27
[/TD2][TD2]
103.28
[/TD2][TD2]
105.40
[/TD2]
[TD2]1,976,250[/TD2][TD2]1,985,425[/TD2][TD2]1,719,609[/TD2][TD2]1,778,901[/TD2]
[TD2]239,274[/TD2][TD2]254,540[/TD2][TD2]254,674[/TD2][TD2]231,285[/TD2]
[TD2]44,000[/TD2][TD2]49,635[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]126,800[/TD2][TD2]0[/TD2][TD2]19,840[/TD2][TD2]138,541[/TD2]
[TD2]
2,386,324
[/TD2][TD2]
2,289,600
[/TD2][TD2]
1,994,123
[/TD2][TD2]
2,148,727
[/TD2]
[TD2]70,928[/TD2][TD2]50,000[/TD2][TD2]47,285[/TD2][TD2]23,334[/TD2]
[TD2]200,000[/TD2][TD2]163,944[/TD2][TD2]84,100[/TD2][TD2]0[/TD2]
[TD2]17,000[/TD2][TD2]17,000[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]200,357[/TD2][TD2]175,726[/TD2][TD2]159,123[/TD2][TD2]126,375[/TD2]
[TD2]
2,874,609
[/TD2][TD2]
2,696,270
[/TD2][TD2]
2,284,631
[/TD2][TD2]
2,298,436
[/TD2]
[TD2]1,537,108[/TD2][TD2]1,496,649[/TD2][TD2]1,372,604[/TD2][TD2]1,355,102[/TD2]
[TD2]157,535[/TD2][TD2]166,026[/TD2][TD2]171,818[/TD2][TD2]161,959[/TD2]
[TD2]
1,694,643
[/TD2][TD2]
1,662,675
[/TD2][TD2]
1,544,422
[/TD2][TD2]
1,517,061
[/TD2]
[TD2]74,474[/TD2][TD2]50,000[/TD2][TD2]60,779[/TD2][TD2]24,281[/TD2]
[TD2]140,000[/TD2][TD2]101,773[/TD2][TD2]67,000[/TD2][TD2]0[/TD2]
[TD2]16,150[/TD2][TD2]17,000[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]206,368[/TD2][TD2]196,876[/TD2][TD2]177,152[/TD2][TD2]120,359[/TD2]
[TD2]
2,131,635
[/TD2][TD2]
2,028,324
[/TD2][TD2]
1,849,353
[/TD2][TD2]
1,661,701
[/TD2]
[TD2]742,974[/TD2][TD2]667,946[/TD2][TD2]435,278[/TD2][TD2]636,735[/TD2]
[TR][/TR]
[TR][TD]auto gaap gm[/TD][TD2]29.0%[/TD2][TD2]27.4%[/TD2][TD2]22.6%[/TD2][TD2]29.4%[/TD2][/TR]
[TR][TD]opex[/TD][/TR]
[TR][TD]tesla r&d[/TD][TD2]250,000[/TD2][TD2]292,040[/TD2][TD2]234,960[/TD2][TD2]214,302[/TD2][/TR]
[TR][TD]tesla sg&a[/TD][TD2]370,000[/TD2][TD2]458,455[/TD2][TD2]365,909[/TD2][TD2]336,811[/TD2][/TR]
[TR][TD]1time acq cost[/TD][TD2]0[/TD2][TD2]0[/TD2][TD2]15,807[/TD2][TD2]0[/TD2][/TR]
[TR][TD]solarcity r&d[/TD][TD2]30,000[/TD2][TD2]30,000[/TD2][TD2]11,000[/TD2][TD2]0[/TD2][/TR]
[TR][TD]solarcity sg&a[/TD][TD2]145,000[/TD2][TD2]145,000[/TD2][TD2]74,300[/TD2][TD2]0[/TD2][/TR]
[TR][TD]total opex[/TD][TD2]795,000[/TD2][TD2]925,495[/TD2][TD2]701,976[/TD2][TD2]551,113[/TD2][/TR]
[TR][/TR]
[TR][TD]op income[/TD][TD2]-52,026[/TD2][TD2]-257,549[/TD2][TD2]-266,698[/TD2][TD2]85,622[/TD2][/TR]
[TR][/TR]
[TR][TD]interest inc[/TD][TD2]3,000[/TD2][TD2]3,090[/TD2][TD2]2,179[/TD2][TD2]2,858[/TD2][/TR]
[TR][TD]interest exp[/TD][TD2]-50,000[/TD2][TD2]-50,000[/TD2][TD2]-43,104[/TD2][TD2]-46,713[/TD2][/TR]
[TR][TD]scty interest[/TD][TD2]-65,000[/TD2][TD2]-49,346[/TD2][TD2]-22,000[/TD2][TD2]0[/TD2][/TR]
[TR][TD]other income exp[/TD][TD2]0[/TD2][TD2]-18,098[/TD2][TD2]32,524[/TD2][TD2]-11,756[/TD2][/TR]
[TR][TD]1time scty gain[/TD][TD2]0[/TD2][TD2]0[/TD2][TD2]88,700[/TD2][TD2]0[/TD2][/TR]
[TR][TD]pretax income[/TD][TD2]-164,026[/TD2][TD2]-371,903[/TD2][TD2]-208,399[/TD2][TD2]30,011[/TD2][/TR]
[TR][TD]income tax[/TD][TD2]12,000[/TD2][TD2]25,278[/TD2][TD2]11,070[/TD2][TD2]8,133[/TD2][/TR]
[TR][TD]net income[/TD][TD2]-176,026[/TD2][TD2]-397,181[/TD2][TD2]-219,469[/TD2][TD2]21,878[/TD2][/TR]
[TR][TD]non-cont int.[/TD][TD2]-275,000[/TD2][TD2]-66,904[/TD2][TD2]-98,132[/TD2][TD2]0[/TD2][/TR]
[TR][TD]net inc to common[/TD][TD2]98,974[/TD2][TD2]-330,277[/TD2][TD2]-121,337[/TD2][TD2]21,878[/TD2][/TR]
[TR][/TR]
[TR][TD]basic shares[/TD][TD2]163,000[/TD2][TD2]162,129[/TD2][TD2]155,024[/TD2][TD2]148,991[/TD2][/TR]
[TR][TD]diluted shares[/TD][TD2]163,000[/TD2][TD2]162,129[/TD2][TD2]155,024[/TD2][TD2]156,935[/TD2][/TR]
[TR][/TR]
[TR][TD]diluted eps[/TD][TD2]0.61[/TD2][TD2]-2.04[/TD2][TD2]-0.78[/TD2][TD2]0.14[/TD2][/TR]