@bonaire and
@Fallenone - Why don't you put your prediction on what kind of "hit" to the margins we should expect in Q3. Are you implying that margins will reduce in Q3, contrary to Tesla guidance?
According to Q2 2016 shareholder letter:
"Q2 Automotive gross margin was 23.1% on a GAAP basis. On a non-GAAP basis, gross margin excluding ZEV credits increased over 200 basis points from Q1 to 21.9%"
"Model S and Model X cost reductions and improved vehicle manufacturing efficiency should offset the margin impact of the expected mix shift toward our 60 kWh configured vehicles and still drive additional gross margin increases throughout the year. We expect GAAP and non-GAAP Automotive gross margins excluding ZEV credits to increase by 2-3 percentage points through Q3 and Q4."
OK I'll bite. Wanna do this for a few weeks anyway and you just gave me the extra motivation.
So I've spent about 2 hours working on a previous spreadsheet I made to calculate the costs of base models. This time I added various options and uptake rate for each and the % of each model (75, 90, 75D, 90D, etc.) in total sales. Overall I'm pretty happy with the results as I got 27% GM and $98k for Model S and 16% GM and $112k for Model X, which have a combined of 21.8% GM in Q2. So, I think my model is reasonably validated with Q2 results up till this point.
Assumptions I made for Q3. All costs discussed on per car basis. I consider variable costs including sourced parts (glider), labor cost, tooling cost, delivery logistics, and warranty. Fixed cost is the depreciation of the factory. Sourced parts (the glider) cost decreased 10%, thanks to increased production and Model 3 reservation number. Labor assumed not decreased because of Tesla hiring more people to accommodate the increased production, which we know. Tooling cost unchanged as Tesla specially stated their tooling cost is on a per car basis, so no matter how much cars they produce, it's the same for each car (I think quite a few people on TMC put tooling into fixed cost and assume this will go down as production increases, no). Delivery logistics and warranty assumed unchanged. Fixed cost assumed reduced by 40%, but this doesn't affect much as it's not an important part of COGS in my model.
On the revenue side, I assumed the all 75 and 75D have an overall 5% discount off the base price MSRP, i.e., options not affected. 90D and up have 15% discount overall. This is based on the observation of a lot of 10% and 30% discount off the cars. But I don't assume all buyers took advantage of them, and assumed only half buyers did.
Because of observations we've seen on the high uptake rate of the 60, I assumed the sales of 60 and 60D are the same as 75 and 75D in Q3. Total sales predicted are 14700 for Model S and 10100 for Model X. These numbers also include a few hundred of the new P100D. I also assigned higher percentage of the Model X sales to the higher end versions, because basically European just got their Model X this quarter and most of them should be Signature versions.
Those are my major assumptions. The results are, for Model S, $91k ASP with 27% GM. For Model X, $107k ASP with 18% GM. Overall ASP $98k with 23% GM. Better than I previously thought, I admit.