I'm posting here given its a weekend, but if you have comments on the model please reply in the Earnings Projections Thread: Near-future quarterly financial projections
Q419 Earnings Estimates:
P&L
Revenue $7,325m (+$1,022m QoQ, +$100m YoY):
Gross Profit $1,430m
Opex $970m
Net Income $269m (+$58m YoY, +$118m QoQ)
GAAP diluted EPS $1.5, Non GAAP EPS $2.6:
Key Revenue & Margin Assumptions:
In this model I have kept Model 3 like for like production cost flat QoQ. This excludes credit revenue, one off software upgrades (Acceleration boost), deferred FSD recognition and China one off ramp costs which have all been broken out separately.
I think flat production cost QoQ is likely conservative - Tesla has consistently reduced production costs QoQ & > production drives > margins (fixed cost leverage, < staff hours/car, supplier scale saving passed on). Main risks are larger one off GF3 headwind & more +ve one offs in Q
Cash Flow
Operating Cash Flow: $1,476m ($1,031m before Working Capital)
Free Cash Flow: $976m
My cash flow statements use different presentation & include many estimates for past Q line items but Operating Cash Flow & Free Cash Flow for Q4 uses Tesla definition.
My Cash Gross Profit Line = Gross Profit plus non cash cost addbacks for Depreciation, Warranty Reserve and Net Deferred Revenue
Net debt down $871m QoQ to $6,266m.
Net debt/EBITDA down to 2.6x from 4.4x at 4Q18.
Net recourse debt down more than half YoY to $1,765m from $3,702m at 4Q18. This includes $4,200m converts which are all in the money (but not convertible until 3 months before maturity).
Q4 Total Liquidity: $9,666m.
Including $6,233m unrestricted cash and $3,433m undrawn bank lines.
I would expect to see credit rating upgrades after Q4.