Thanks for taking a second look at this -- it also took a while for it to sink in with me that S/X had the potential to provide such a significant source of cash for Model 3.
I would caution that we have only seen one quarter of results with S/X both running at something close to full production, so there is potential for significant variability, down or up.
In terms of potential for upcoming quarters, let me start with a little back of the envelope calculation showing a very rough estimate of changes from Q3 to Q4. Please take this with a large grain of salt since it is early in the quarter, we don't have much visibility into production rates (although the signs seem positive so far), and there are a lot of variables.
Assuming that Tesla meets its 2H delivery target of 50,000 vehicles, I estimate the following for Q4 cash generation starting with Q3 as a baseline:
Tesla Q4 Earnings/Cash Flow Estimate
4.5% increase in ASP:
P100D 0.5%
X60 phase-out 1.0%
Higher option pricing/limited inventory S60s/less discounting 1.5%
AP2/FSDC 3%*0.5 (1/2 Q4 deliveries)=1.5%
4% higher non-GAAP gross margin:
P100D 0.25%
X60 phase out 1.0%
Higher option pricing/limited inventory S60s/less discounting 1.5%
AP2/FSDC 1.5%*0.5=.75%
Production efficiency/sourcing gains: 0.5%
$2.28B automotive revenue ($2.15B *25.2/24.8*1.045)
Non-GAAP automotive GP $2.28B*.29=$661M
GAAP automotive GP=$571M plus ZEV
Services and other $250M*8% GAAP GM=$20M GP GAAP/$22M Non-GAAP
Non-GAAP total GP $683M; GAAP $591M plus ZEV
OpEx -- assume Q3-Q4 has about same rate of increase as Q2-Q3=$590M
Non-GAAP earnings $93M
Cash generation before capital expenditures: $597M (Q3 cash flow plus cash from vehicle sales to lease partners) -$139M (ZEV) + $60M guesstimate more D&A + ($93M-$111M) (Q4-Q3 Non-GAAP earnings) = $500M plus ZEV
+$50M from 100K Powerwall 2 reservations (conservative)=$550M plus ZEV increased cash position before CapEx.
Q4 CapEx Guidance $1.04B
12/31/2016 Cash: $3.1B-1.04B+.5B=$2.6B (not including adjustments up or down due to ABL etc.)
Again, these are very rough calculations and I think the absolute numbers are less important than the possibility that S/X will continue to generate significant and likely increasing amounts of cash for Model 3.
Incidentally, I recognize the 29% GM estimate seems very high at first blush. But based on the changes outlined above that Tesla has made this quarter with an eye toward generating more cash, I think 29% is a reasonable number. It is a "best guess" rather than conservative figure and if you pushed me I would be more comfortable with a non-GAAP GM estimate of 27-29%. But if the actual GM number is lower it should not have much impact on cash flow -- about $23M per GM percentage point out of $500M+ in cash generation. In any case, I think we are trending toward a beat on deliveries so it is likely to be a wash.
I expect actual CapEx to be lower than guidance as that has been the trend so far under Jason's leadership. So, overall I think this calculation ends up being slightly on the conservative side in terms of cash position exiting 2016, even if not all the elements are conservative.
Accounts Payable has gotten a lot of attention. Jason acknowledged in the earnings call that there may be some unwinding of AP but he and Elon suggested that it would not be material, especially given increased AR counterbalancing it. I treat that as a wash but it is worth keeping an eye on.
I think Q1 2017 should be even better with TE ramping and S/X business likely to be even stronger but this is already way too much for one post so I'll save that for another day.