brian45011
Active Member
Apologies if it alarmed you.So I only had a quick look at your numbers, but this reduction looks (wildly) invalid for several reasons:
Fixing that omission alone adds about +$246m in revenue to your estimate.
- You reduced ASP from $59k to $55.5k, while the Troy Model tracker estimates Q3 ASP based on deliveries - i.e. Q2-made cars will be accounted in the Q3. Troy's tracking estimates a current average ASP for Q3 of $60.2k.
- But even if we take the 11,166 Q2-made Model 3's in transit, they are a minority of the cars delivered in Q3. If we go with your estimate of 52,500 Q3 deliveries then that still leaves 41,334 Q3-made cars delivered in Q3 - and you assign an inexplicably low ASP of $56k to them - which is barely higher than the Q2 ASP of $55.4k.
There is a typo (my bad) in my M3 ASP value shown in the Assumptions--it should be $57,500. You can verify it by dividing the M3 Revenue by 52,500 M3 deliveries. Tesla does not report Operating Statement categories by model so every one guesses as to the as reported splits among S, X, and M3. 11,166 is 21% of my estimated 52,500 M3 deliveries (some other minor fraction of those estimated deliveries could be from the 1,473 M3s in Finished Goods Inventory at the beginning of the quarter). There is also some component of the LR versions in the 41,334 remaining. Troy's estimate is but one data point--the Q3 numbers will report the average for the quarter not what is current at the end of the quarter. Using the weighted average between your estimated ASPs of $55k and $60k for M3 deliveries produced during Q2 and Q3, respectively, yields an ASP $58,650 and increases M3 Revenue by $60 million vice $246 million. luvb2b's ASP was $59,000
But there's more that looks unsupported:
- The Troy Model S/X tracker is currently projecting a Q3 S/X ASP of about $106.5k - you used $102k.
- I estimated $103k which is ex-regulatory credits; luvb2b estimated $104k. Are you adopting Troy's estimate?
- You used 23,500 Model S/X deliveries, while Tesla guided for 27,000. I.e. you are predicting a serious miss.
- Yes, for the reasons offered in note 1. Tesla has not guided to anything for Q3, only for all of 2018
- These two factors account for a potential revenue gap of $476m (!).
- The effect on Gross Profit is far less since there is a corresponding "gap" in COGS
- You also reduced Model S/X margins from 27% to 26% - another drop of $24m in revenue.
- luvb2b's 27% apparently includes regulatory credits; my 26% does not. The difference between our Gross Profits is less than $26 million--almost all of that is because of my lower estimate of deliveries
- You inexplicably reduced Model 3 gross margin to 13%, which is significantly below the guided 15%. Considering that ASP increased significantly in Q3 due to the much higher than expected take-rate of AWD, EAP/FSD and Performance, these will increase not just revenue but margins as well. I.e. even a 15% assumption might turn out to be conservative. This factor alone removes at least $63m of net income.
- Not inexplicable--attributed in Note 2. to the 11,166 vehicles carried over from Q2 production for which GM% was at best slightly positive. The Q2 Shareholder Letter was internally inconsistent about M3 Gross Margin.
- "Model 3 gross margin turned slightly positive in Q2" but also
- "Model 3 gross profit excluding non-cash items shifted from negative in Q1 to positive in Q2,"
We'll see. You may be underestimating the number of hours associates and junior partners can bill while conducting internal familiarization of corporate digital and paper documents in the process of preparing responses to the SEC's subpoena and the DOE's informal RFI . Those associates and junior partners are also busy answering multiple Shareholder Derivative actions and girding up for the inevitable motion practice. The scope of discovery is limited to ANYTHING that may lead to admissible evidence. Defense costs, experts, settlements and judgments in other on-going litigation are also charged to SG&A.Legal and consulting expense is likely in the peanuts category - litigation tends to be the most expensive in the immediate pre-trial phase, none of them are at that stage yet, and unlikely to get there. The facts are also pretty narrow in most of the controversies which limit the scope of any discovery (another source of litigation expense).
Elon tweeted on August 13:
"I’m excited to work with Silver Lake and Goldman Sachs as financial advisors, plus Wachtell, Lipton, Rosen & Katz and Munger, Tolles & Olson as legal advisors, on the proposal to take Tesla private" {The former two later also received SEC subpoenas}Apparently, the Board of Directors separately retained Wilson Sonsini Goodrich & Rosati and Latham & Watkins plus the public relations specialty firm Joele Frank; and some Directors many have retained their own individual attorneys. (IMO, there is a legitimate issue as to whether the corporate indemnity covers the cost of those retained by Elon, since he claimed to be acting as an individual and not as CEO nor Board Chairman. Another poster in a different thread opined this issue should not be discussed further; I only mention it in this thread because it affects the Operating Statement)
You have it exactly backwards. luvb2b's S/X COGS is $274 million more than mine--again largely because his delivery estimate is higher.You increased Model S/X Sales expenses by $274m - why? They are mature products, if then Model S/X became more efficient and margins improved significantly in Q2 already. Q3 margins might be even better due to higher deliveries, which distributes fixed costs/overhead more.
All estimates are, a priori, imprecise--often, too low a presumed value in one category may be more than offset by too high of one in a counteracting category. Wildcards this quarter include regulatory credits, currency effects, and NCI's. I'll update my estimates after the delivery 8k and CARB's ZEV report.
It's unclear if you are adopting luvb2b's projections in their entirety or using Troy's estimates in your own modeling. If the latter, why not share it to advance the discussion?
Last edited: