Welcome to Tesla Motors Club
Discuss Tesla's Model S, Model 3, Model X, Model Y, Cybertruck, Roadster and More.
Register

Near-future quarterly financial projections

This site may earn commission on affiliate links.
I have capex at 200m, ex-China. I don't know how they'll account for China. They guided 500m capex for a 150k/year factory. That's non-sensical. I suspect it's build-to-suit lease or something that will show up as PP&E but not capex. Maybe 10-Q will shed some light.

Tesla could have gotten a deal like NIO: the Shanghai government is financing and building the factory building, the roads, all utilities etc. and leases it back under very favorable terms: NIO got zero lease payments for the first two years? (Of course NIO's factory was scrapped, but not due to Shanghai.)

If this is true (which it might not be), then Tesla would only have to pay for the equipment, which they estimated to be 25%-35% of the Model 3 capex.

So if we take Model 3 capex of $2b-$3b, scale it from 500k/year to 150k/year, and apply 25%-35% we get a capex range of $150m-$315m.

So $500m total doesn't sound unreasonable, and would be covered by the first 25% of the $2b China loan. So I don't think China Q1 will draw on net cash at all - but it might reduce FCF.

I don't know how they plan to achieve 25%-35% capex compared to the Model 3. I believe the biggest Model 3 capex were the ~800 robots - a quarter of which is still 200 - so they either:
  • plan to use a lot more manual labor (not unreasonable in China),
  • or Grohmann starts manufacturing their own robots. (Not sure this is possible without bigger capex though.)
  • or they will buy robots and save on other factors,
  • or they won't be able to keep capex guidance. :D
 
we do differ on thoughts on margin.
my counter: on model 3 they had trouble improving margins in q4. since then they cut prices, introduced lower-end models, and dealt with numerous delivery snafus. the lower unit count means the delivery infrastructure utilization was suboptimal vs last quarter. all of these factors produce drags on margin that are hard to overcome.
on model s/x i don't have a good idea of how much fixed cost depreciation or labor are in cogs, but again the combination of a price cut, fewer units, and suboptimal utilization of production infrastructure would all be margin drags.
there's a potential benefit from autopilot software upgrades as those get lumped into automotive sales afaik. so you could have some offset to margins from the one-time autopilot upgrades, assuming they don't separate that out as a one time item (i would expect not).

i doubt this will be a very popular model, but at least people can use it as a starting point from which to insert their own assumptions.

cash and balance sheets are extremely difficult to model and i would expect meaningful variances. on balance sheet, operating lease vehicles could decline due to more leased vehicles running off vs. leased this quarter.

on cash, i have not included an effect of drawing on inventory or other credit lines. it is possible ending cash balances fare better if they draw lines. tesla in general has a lot of large pieces that can affect the final cash that are hard to model - even cash from ops can be wildly moved by changes in how they pay suppliers.

i haven't been spending as much time on tesla lately so i apologize in advance for any errors. please reply if you see them. thanks.

Thank you for creating this model.

One number that sticks out is the Model 3 ASP, at 53500.

A significant fraction of this quarter's deliveries evidently happened in the EU, where the ASP is significantly higher.

The cheapest Model 3 in Norway+France started at around 51k Euro, in Germany at around 53k Euro, in other EU countries the starting price was closer to 57k Euro. Indications are that a significant fraction had some kind of hardware options added with more uncertainty regarding software options (AEP/FSD).

I no longer have the Q1 base price for China, I believe that the Q1 base price prior to offering the SR variant were even higher than the EU one.

Naturally, the shipping cost would also be higher for the international sales (which would also incur tariffs), but maybe not much higher than East coast deliveries.

Still I think that trying to estimate the prices, shipping costs and delivery numbers for international deliveries into account could provide a more accurate Model 3 ASP.
 
  • Informative
  • Like
Reactions: neroden and Thekiwi
we do differ on thoughts on margin.
my counter: on model 3 they had trouble improving margins in q4. since then they cut prices, introduced lower-end models, and dealt with numerous delivery snafus. the lower unit count means the delivery infrastructure utilization was suboptimal vs last quarter. all of these factors produce drags on margin that are hard to overcome.
on model s/x i don't have a good idea of how much fixed cost depreciation or labor are in cogs, but again the combination of a price cut, fewer units, and suboptimal utilization of production infrastructure would all be margin drags.
there's a potential benefit from autopilot software upgrades as those get lumped into automotive sales afaik. so you could have some offset to margins from the one-time autopilot upgrades, assuming they don't separate that out as a one time item (i would expect not).

i doubt this will be a very popular model, but at least people can use it as a starting point from which to insert their own assumptions.

cash and balance sheets are extremely difficult to model and i would expect meaningful variances. on balance sheet, operating lease vehicles could decline due to more leased vehicles running off vs. leased this quarter.

on cash, i have not included an effect of drawing on inventory or other credit lines. it is possible ending cash balances fare better if they draw lines. tesla in general has a lot of large pieces that can affect the final cash that are hard to model - even cash from ops can be wildly moved by changes in how they pay suppliers.

i haven't been spending as much time on tesla lately so i apologize in advance for any errors. please reply if you see them. thanks.

s deliveries
x deliveries
s+x deliveries
3 deliveries
3 production
lease s/x % veh
avg price s+x
avg price model 3
revenue
auto sales ex 3
auto sales mod 3
auto leasing
1 time autopilot
zev credits
total auto
energy storage
solarcity
grohmann
services/other
total revenue
cost of revenue
auto sales ex 3
auto sales mod 3
auto leasing
total auto
energy storage
solarcity
grohmann
services & other
total cost of rev
gross profit
auto gaap ex 3 gm
auto-zev ex 3 gm
model 3 gm
auto-zev incl 3 gm
storage gm
scty gm
grohmann gm
services gm
opex
tesla r&d
tesla sg&a
1 time costs
solarcity r&d
solarcity sg&a
total opex
op income
interest inc
interest exp
scty interest
other income exp
1time scty gain
pretax income
income tax
net income
non-cont int.
net inc to common
basic shares
diluted shares
diluted gaap eps
gaap net income
+ stock based comp
+ one time scty
non-gaap net income
non-gaap diluted eps
dio
dpo
balance sheet
current assets
cash & eq.
restricted cash
accts rcvbl
inventory
prepaids+other
total current assets
op lease vehicles
solar energy sys
pp&e
intangible assets
goodwill
mypower rcvbls
restricted cash
other assets
total assets
current liabiliites
accts payable
accrued liabs+other
deferred revenue
resale value guar
cust deposits
curr debt+leases
curr solar bonds
total current liabs
lt debt+leases
solar bonds
rel party conv debt
deferred revenue
resale value guar
other lt liabilities
comm stk warrants
capital lease oblg
total liabilities
commits/contings
rdmbl ncis in subs
conv senior notes
nci in subsidiaries
common equity
cash flow statement
cash flows from ops
net loss
dep/amortization
stock-based comp
am of debt discount
inv write-down
loss on disposals
forex loss (gain)
loss on acq scty
non-cash int/other
chgs in op as/lb
accts rcbl
inv / op leases
prepaids/other ca
mypower rcvbls + other
accts pybl/accr liabs
deferred revenue
customer deposits
other lt liabs
net cash from ops
cash flows from inv
pp&e purchases
purchase solar sys
net cash from inv
cash flows from fin
stock issued
debt issued
debt repayments
rel pty solar repaids
coll lease borrowing
stock option excrs
capital lease paids
stock+debt issue cost
investment by nci in subs
dist to nci in subs
buyouts of nci in subs
net cash from fin
forex effect
net change in cash
cash & eq start
cash & eq end
[TD2] luv q1-19e [/TD2][TD2] Dec-18 [/TD2][TD2] Sep-18 [/TD2][TD2] Jun-18 [/TD2] [TD2]6,050[/TD2][TD2]13,500[/TD2][TD2]14,495[/TD2][TD2]10,939[/TD2] [TD2]6,050[/TD2][TD2]14,107[/TD2][TD2]13,215[/TD2][TD2]11,380[/TD2] [TD2] 12,100 [/TD2][TD2] 27,607 [/TD2][TD2] 27,710 [/TD2][TD2] 22,319 [/TD2] [TD2] 50,900 [/TD2][TD2] 63,359 [/TD2][TD2] 56,065 [/TD2][TD2] 18,449 [/TD2] [TD2] 62,950 [/TD2][TD2] 60,000 [/TD2][TD2] 53,239 [/TD2][TD2] 28,578 [/TD2] [TD2] 0.13 [/TD2][TD2] 0.13 [/TD2][TD2] 0.09 [/TD2][TD2] 0.11 [/TD2] [TD2] 103.00 [/TD2][TD2] 106.00 [/TD2][TD2] 104.80 [/TD2][TD2] 105.14 [/TD2] [TD2] 53.50 [/TD2][TD2] 55.75 [/TD2][TD2] 56.78 [/TD2][TD2] 55.80 [/TD2] [TD2]1,084,281[/TD2][TD2]2,540,646[/TD2][TD2]2,642,647[/TD2][TD2]2,088,411[/TD2] [TD2]2,723,150[/TD2][TD2]3,532,057[/TD2][TD2]3,183,389[/TD2][TD2]1,029,454[/TD2] [TD2]253,202[/TD2][TD2]249,748[/TD2][TD2]220,461[/TD2][TD2]239,816[/TD2] [TD2]35,000[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]0[/TD2][TD2]768[/TD2][TD2]52,269[/TD2][TD2]0[/TD2] [TD2] 4,095,633 [/TD2][TD2] 6,323,219 [/TD2][TD2] 6,098,766 [/TD2][TD2] 3,357,681 [/TD2] [TD2]185,500[/TD2][TD2]131,497[/TD2][TD2]105,317[/TD2][TD2]111,651[/TD2] [TD2]237,600[/TD2][TD2]240,000[/TD2][TD2]294,000[/TD2][TD2]262,757[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]550,000[/TD2][TD2]531,157[/TD2][TD2]326,330[/TD2][TD2]270,142[/TD2] [TD2] 5,068,733 [/TD2][TD2] 7,225,873 [/TD2][TD2] 6,824,413 [/TD2][TD2] 4,002,231 [/TD2] [TD2]947,532[/TD2][TD2]1,850,532[/TD2][TD2]1,875,125[/TD2][TD2]1,546,610[/TD2] [TD2]2,219,367[/TD2][TD2]2,807,985[/TD2][TD2]2,530,794[/TD2][TD2]983,129[/TD2] [TD2]136,729[/TD2][TD2]127,731[/TD2][TD2]119,283[/TD2][TD2]136,915[/TD2] [TD2] 3,303,629 [/TD2][TD2] 4,786,248 [/TD2][TD2] 4,525,202 [/TD2][TD2] 2,666,654 [/TD2] [TD2]185,500[/TD2][TD2]160,706[/TD2][TD2]124,754[/TD2][TD2]146,343[/TD2] [TD2]166,320[/TD2][TD2]168,000[/TD2][TD2]205,800[/TD2][TD2]183,930[/TD2] [TD2]10,999[/TD2][TD2]11,000[/TD2][TD2]11,000[/TD2][TD2]11,000[/TD2] [TD2]687,500[/TD2][TD2]657,019[/TD2][TD2]433,992[/TD2][TD2]375,374[/TD2] [TD2] 4,353,948 [/TD2][TD2] 5,782,973 [/TD2][TD2] 5,300,748 [/TD2][TD2] 3,383,301 [/TD2] [TD2] 714,785 [/TD2][TD2] 1,442,900 [/TD2][TD2] 1,523,665 [/TD2][TD2] 618,930 [/TD2] [TD2]21.0%[/TD2][TD2]29.1%[/TD2][TD2]31.6%[/TD2][TD2]27.7%[/TD2] [TD2]21.0%[/TD2][TD2]29.1%[/TD2][TD2]30.3%[/TD2][TD2]27.7%[/TD2] [TD2]18.5%[/TD2][TD2]20.5%[/TD2][TD2]20.5%[/TD2][TD2]4.5%[/TD2] [TD2]18.6%[/TD2][TD2]24.3%[/TD2][TD2]25.2%[/TD2][TD2]20.6%[/TD2] [TD2]0.0%[/TD2][TD2]-22.2%[/TD2][TD2]-18.5%[/TD2][TD2]-31.1%[/TD2] [TD2]30.0%[/TD2][TD2]30.0%[/TD2][TD2]30.0%[/TD2][TD2]30.0%[/TD2] [TD2]-100.0%[/TD2][TD2]-100.0%[/TD2][TD2]-100.0%[/TD2][TD2]-100.0%[/TD2] [TD2]-25.0%[/TD2][TD2]-23.7%[/TD2][TD2]-33.0%[/TD2][TD2]-39.0%[/TD2] [TD2]300,000[/TD2][TD2]306,297[/TD2][TD2]315,848[/TD2][TD2]341,129[/TD2] [TD2]500,000[/TD2][TD2]522,452[/TD2][TD2]599,876[/TD2][TD2]610,759[/TD2] [TD2]140,000[/TD2][TD2]5,615[/TD2][TD2]26,184[/TD2][TD2]103,434[/TD2] [TD2]45,000[/TD2][TD2]50,000[/TD2][TD2]35,000[/TD2][TD2]45,000[/TD2] [TD2]140,000[/TD2][TD2]145,000[/TD2][TD2]130,000[/TD2][TD2]140,000[/TD2] [TD2] 1,125,000 [/TD2][TD2] 1,029,364 [/TD2][TD2] 1,106,908 [/TD2][TD2] 1,240,322 [/TD2] [TD2] -410,215 [/TD2][TD2] 413,536 [/TD2][TD2] 416,757 [/TD2][TD2] -621,392 [/TD2] [TD2]6,000[/TD2][TD2]7,348[/TD2][TD2]6,907[/TD2][TD2]5,064[/TD2] [TD2]-122,000[/TD2][TD2]-121,723[/TD2][TD2]-122,220[/TD2][TD2]-110,582[/TD2] [TD2]-53,000[/TD2][TD2]-53,000[/TD2][TD2]-53,000[/TD2][TD2]-53,000[/TD2] [TD2]-12,000[/TD2][TD2]-14,205[/TD2][TD2]22,876[/TD2][TD2]50,911[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2] -591,215 [/TD2][TD2] 231,956 [/TD2][TD2] 271,320 [/TD2][TD2] -728,999 [/TD2] [TD2]19,999[/TD2][TD2]21,878[/TD2][TD2]16,647[/TD2][TD2]13,707[/TD2] [TD2] -611,214 [/TD2][TD2] 210,078 [/TD2][TD2] 254,673 [/TD2][TD2] -742,706 [/TD2] [TD2]0[/TD2][TD2]70,595[/TD2][TD2]-56,843[/TD2][TD2]-25,167[/TD2] [TD2] -611,214 [/TD2][TD2] 139,483 [/TD2][TD2] 311,516 [/TD2][TD2] -717,539 [/TD2] [TD2]173,000[/TD2][TD2]172,026[/TD2][TD2]170,893[/TD2][TD2]169,997[/TD2] [TD2]180,000[/TD2][TD2]179,026[/TD2][TD2]178,196[/TD2][TD2]169,997[/TD2] [TD2] -3.40 [/TD2][TD2] 0.78 [/TD2][TD2] 1.75 [/TD2][TD2] -4.22 [/TD2] [TD2]-611,214[/TD2][TD2]139,483[/TD2][TD2]311,516[/TD2][TD2]-717,539[/TD2] [TD2]208,000[/TD2][TD2]205,313[/TD2][TD2]204,728[/TD2][TD2]197,344[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]-403,214[/TD2][TD2]344,796[/TD2][TD2]516,244[/TD2][TD2]-520,195[/TD2] [TD2] -2.24 [/TD2][TD2] 1.93 [/TD2][TD2] 2.90 [/TD2][TD2] -3.06 [/TD2] [TD2] 72.00 [/TD2][TD2] 49.13 [/TD2][TD2] 57.05 [/TD2][TD2] 89.67 [/TD2] [TD2] 55.00 [/TD2][TD2] 53.72 [/TD2][TD2] 61.92 [/TD2][TD2] 81.73 [/TD2] [TD2]2,119,615[/TD2][TD2]3,685,618[/TD2][TD2]2,967,504[/TD2][TD2]2,236,424[/TD2] [TD2]150,000[/TD2][TD2]192,551[/TD2][TD2]158,627[/TD2][TD2]146,822[/TD2] [TD2]888,764[/TD2][TD2]949,022[/TD2][TD2]1,155,001[/TD2][TD2]569,874[/TD2] [TD2]3,435,444[/TD2][TD2]3,113,446[/TD2][TD2]3,314,127[/TD2][TD2]3,324,643[/TD2] [TD2]360,646[/TD2][TD2]365,671[/TD2][TD2]325,232[/TD2][TD2]422,034[/TD2] [TD2] 6,954,468 [/TD2][TD2] 8,306,308 [/TD2][TD2] 7,920,491 [/TD2][TD2] 6,699,797 [/TD2] [TD2]1,953,755[/TD2][TD2]2,089,758[/TD2][TD2]2,186,137[/TD2][TD2]2,282,047[/TD2] [TD2]6,238,682[/TD2][TD2]6,271,396[/TD2][TD2]6,301,537[/TD2][TD2]6,340,031[/TD2] [TD2]11,728,475[/TD2][TD2]11,330,077[/TD2][TD2]11,246,295[/TD2][TD2]10,969,348[/TD2] [TD2]361,502[/TD2][TD2]290,414[/TD2][TD2]291,476[/TD2][TD2]300,406[/TD2] [TD2]60,237[/TD2][TD2]60,237[/TD2][TD2]65,226[/TD2][TD2]64,284[/TD2] [TD2]414,548[/TD2][TD2]421,548[/TD2][TD2]422,897[/TD2][TD2]434,841[/TD2] [TD2]400,000[/TD2][TD2]398,219[/TD2][TD2]396,835[/TD2][TD2]399,992[/TD2] [TD2]570,000[/TD2][TD2]571,657[/TD2][TD2]431,819[/TD2][TD2]419,254[/TD2] [TD2] 28,681,667 [/TD2][TD2] 29,739,614 [/TD2][TD2] 29,262,713 [/TD2][TD2] 27,910,000 [/TD2] [TD2]2,624,297[/TD2][TD2]3,404,451[/TD2][TD2]3,596,984[/TD2][TD2]3,030,493[/TD2] [TD2]2,345,076[/TD2][TD2]2,094,253[/TD2][TD2]1,990,095[/TD2][TD2]1,814,979[/TD2] [TD2]586,126[/TD2][TD2]630,292[/TD2][TD2]570,920[/TD2][TD2]576,321[/TD2] [TD2]450,000[/TD2][TD2]502,840[/TD2][TD2]604,949[/TD2][TD2]674,255[/TD2] [TD2]965,000[/TD2][TD2]792,601[/TD2][TD2]905,838[/TD2][TD2]942,129[/TD2] [TD2]2,600,000[/TD2][TD2]2,567,699[/TD2][TD2]2,106,538[/TD2][TD2]2,020,685[/TD2] [TD2]100,000[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]82,500[/TD2] [TD2] 9,670,499 [/TD2][TD2] 9,992,136 [/TD2][TD2] 9,775,324 [/TD2][TD2] 9,141,362 [/TD2] [TD2]8,600,000[/TD2][TD2]9,401,053[/TD2][TD2]9,669,879[/TD2][TD2]9,510,696[/TD2] [TD2]100[/TD2][TD2]100[/TD2][TD2]100[/TD2][TD2]100[/TD2] [TD2]2,519[/TD2][TD2]2,519[/TD2][TD2]2,634[/TD2][TD2]2,594[/TD2] [TD2]879,190[/TD2][TD2]990,873[/TD2][TD2]950,126[/TD2][TD2]795,820[/TD2] [TD2]650,000[/TD2][TD2]328,926[/TD2][TD2]455,762[/TD2][TD2]584,857[/TD2] [TD2]2,981,250[/TD2][TD2]2,710,403[/TD2][TD2]2,555,319[/TD2][TD2]2,607,458[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2] 22,783,558 [/TD2][TD2] 23,426,010 [/TD2][TD2] 23,409,144 [/TD2][TD2] 22,642,887 [/TD2] [TD2]402,943[/TD2][TD2]555,964[/TD2][TD2]551,264[/TD2][TD2]539,536[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]900,000[/TD2][TD2]834,397[/TD2][TD2]793,467[/TD2][TD2]821,156[/TD2] [TD2] 4,595,166 [/TD2][TD2] 4,923,243 [/TD2][TD2] 4,508,838 [/TD2][TD2] 3,906,421 [/TD2] [TD2]-611,214[/TD2][TD2]210,078[/TD2][TD2]254,673[/TD2][TD2]-742,706[/TD2] [TD2]457,411[/TD2][TD2]496,737[/TD2][TD2]502,825[/TD2][TD2]485,255[/TD2] [TD2]208,000[/TD2][TD2]205,313[/TD2][TD2]204,728[/TD2][TD2]197,344[/TD2] [TD2]35,000[/TD2][TD2]37,857[/TD2][TD2]46,454[/TD2][TD2]35,074[/TD2] [TD2]31,134[/TD2][TD2]25,289[/TD2][TD2]13,885[/TD2][TD2]27,552[/TD2] [TD2]25,000[/TD2][TD2]28,722[/TD2][TD2]13,789[/TD2][TD2]66,613[/TD2] [TD2]10,000[/TD2][TD2]5,103[/TD2][TD2]-12,799[/TD2][TD2]-41,476[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]20,000[/TD2][TD2]26,414[/TD2][TD2]16,408[/TD2][TD2]9,669[/TD2] [TD2]60,258[/TD2][TD2]189,371[/TD2][TD2]-587,594[/TD2][TD2]70,633[/TD2] [TD2]-185,994[/TD2][TD2]61,548[/TD2][TD2]-57,795[/TD2][TD2]-822,487[/TD2] [TD2]0[/TD2][TD2]-50,593[/TD2][TD2]63,662[/TD2][TD2]-45,193[/TD2] [TD2]-15,000[/TD2][TD2]-145,010[/TD2][TD2]-2,953[/TD2][TD2]-1,863[/TD2] [TD2]-579,331[/TD2][TD2]94,853[/TD2][TD2]718,277[/TD2][TD2]591,737[/TD2] [TD2]75,000[/TD2][TD2]122,244[/TD2][TD2]176,920[/TD2][TD2]61,702[/TD2] [TD2]172,399[/TD2][TD2]-106,156[/TD2][TD2]-33,449[/TD2][TD2]-24,439[/TD2] [TD2]0[/TD2][TD2]85,734[/TD2][TD2]92,308[/TD2][TD2]42,484[/TD2] [TD2] -297,337 [/TD2][TD2] 1,234,561 [/TD2][TD2] 1,391,281 [/TD2][TD2] -129,664 [/TD2] [TD2]-625,000[/TD2][TD2]-324,978[/TD2][TD2]-510,271[/TD2][TD2]-609,813[/TD2] [TD2]-30,000[/TD2][TD2]-28,923[/TD2][TD2]-49,494[/TD2][TD2]-67,400[/TD2] [TD2] -655,000 [/TD2][TD2] -365,009 [/TD2][TD2] -560,965 [/TD2][TD2] -682,817 [/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2]100,000[/TD2][TD2]2,229,598[/TD2][TD2]903,348[/TD2][TD2]1,267,746[/TD2] [TD2]-930,000[/TD2][TD2]-2,135,815[/TD2][TD2]-842,526[/TD2][TD2]-879,328[/TD2] [TD2]0[/TD2][TD2]0[/TD2][TD2]-82,500[/TD2][TD2]0[/TD2] [TD2]100,000[/TD2][TD2]-216,081[/TD2][TD2]-142,568[/TD2][TD2]-113,426[/TD2] [TD2]75,000[/TD2][TD2]75,777[/TD2][TD2]94,874[/TD2][TD2]31,053[/TD2] [TD2]-30,000[/TD2][TD2]-74,938[/TD2][TD2]-57,685[/TD2][TD2]-29,395[/TD2] [TD2]-12,000[/TD2][TD2]-9,852[/TD2][TD2]-1,450[/TD2][TD2]-758[/TD2] [TD2]75,000[/TD2][TD2]70,837[/TD2][TD2]113,260[/TD2][TD2]179,333[/TD2] [TD2]-50,000[/TD2][TD2]-48,793[/TD2][TD2]-68,966[/TD2][TD2]-56,603[/TD2] [TD2]0[/TD2][TD2]-3,036[/TD2][TD2]0[/TD2][TD2]0[/TD2] [TD2] -672,000 [/TD2][TD2] -112,309 [/TD2][TD2] -84,218 [/TD2][TD2] 398,622 [/TD2] [TD2]58,334[/TD2][TD2]47,937[/TD2][TD2]-6,370[/TD2][TD2]-22,611[/TD2] [TD2] -1,566,003 [/TD2][TD2] 805,180 [/TD2][TD2] 739,728 [/TD2][TD2] -436,470 [/TD2] [TD2] 3,685,618 [/TD2][TD2] 2,967,504 [/TD2][TD2] 2,236,424 [/TD2][TD2] 2,665,673 [/TD2] [TD2] 2,119,615 [/TD2][TD2] 3,685,618 [/TD2][TD2] 2,967,504 [/TD2][TD2] 2,236,424 [/TD2]

Curious as to how you are coming up with a drop in Model 3 margins when the majority of Q1 units were European & China deliveries with only high end SKUs, and production increased quarter over quarter.
 
I'm onboard with $2250 Model 3 ASP decline. They hoped high ASP overseas shipments would offset the US mix shift, but that hope died with the hasty 2/28 SR+ launch and price cuts. You have Model 3 COGS dropping from $44,300 per car in Q4 to $43,600 in Q1. That sounds reasonable -- production volume barely grew so there were no fixed cost gains. The low hanging scrappage and parts cost fruit has been harvested, thus Musk's "Game of Pennies".

I don't understand your "Auto Sales ex-3" COGS, though. 947.5m vs. 1084.3m revenue gives me 12.6% GM, not 21%. It also looks like 90k COGS per S/X vs. a more reasonable 75k in Q4. Low volume should only inflate COGS ~2k per car. What am I missing here?

I'd probably set one-time costs at 100m vs. 140m. This layoff was similar size to Q2's. Lease terminations could add to it, though.

Thanks for doing this. I'll have more questions after I sift through the cash flows.
Agreed.

ASP on Euro/Chinese models are likely actually higher, but ASP on US models is significantly lower, so it's basically the percentage of US models which determines this; it might even be lower than luvb2b's guess.

I also think one-time FSD revenue is much too low: luvb2b is essentially assuming that only 12000 "old car owners" decided to "pull the trigger", which is unlikely IMO. I'd bet on more like 100,000 "old car owners" deciding that FSD now has actual features and therefore buying it. We know that the take rate when it was first offered was minimal, under 10%. Now that it's useful, I think over half of "old" car owners will buy it -- so 100000 may be an underestimate. Anyway, this would be a very large difference in income -- a positive surprise, I guess. Since we have no way of getting an accurate estimate of how many "old car owners" pulled the trigger, this is going to be a massive uncertainty in net income and cash flow. 100K cars, it could be 300 million dollars; 200K cars, it could be 600 million dollars.

My conclusion is that this one element alone -- FSD purchases by car owners who had their cars before March started and FSD started having features -- is uncertain enough that we really can't project income or cash flow. It dwarfs a lot of the other numbers.

TE numbers are ultra hard to project, but I personally expect higher revenue than luvb2b expects. No way of telling COGS though, they've carefully buried it in with the accounting mess of the solar business.

I expect a drop in S/X lease percentage. I think there was a rush on them in the fourth quarter due to the tax credit expiration. People who bought/leased S and X in the US in the first quarter are going to be people who are paying no attention to money (and therefore ignored the tax credit expiration), or people who were enticed by FSD features perhaps; that is likely to include relatively few people who lease.

TLDR: I think the variance and uncertainty in major numbers makes trying to guess the Q1 financials impossible.

I'm not going to make a prediction, other than "They have plenty of cash for working needs and will be fine going into Q2".
 
Thank you for creating this model.

One number that sticks out is the Model 3 ASP, at 53500.

A significant fraction of this quarter's deliveries evidently happened in the EU, where the ASP is significantly higher.

The cheapest Model 3 in Norway+France started at around 51k Euro, in Germany at around 53k Euro, in other EU countries the starting price was closer to 57k Euro. Indications are that a significant fraction had some kind of hardware options added with more uncertainty regarding software options (AEP/FSD).

The 51k Euro number you quote for example in France includes a significant Value Added Tax (about 8k), so isn’t what’s left to Tesla in that case 43k for ASP calculation purposes?
 
I don't think that's correct. They report income from credits separately, so the ASP is the ASP...

No. It's included in automotive revenue. They do split that up separately later. But everyone's model here does just revenue = ASP * # of units for automotive revenue on non-ZEV credits, therefore whatever money those credits bring in must be accounted through the ASP.
 
  • Informative
Reactions: neroden
I don't think that's correct. They report income from credits separately, so the ASP is the ASP...
Automotive sales and leasing revenue includes credits. They break out revenue with ZEV excluded in a separate section of the earnings reports so someone looking at trend data won't be thrown off by a big ZEV sale that happens in one quarter vs. another. They don't break out GHG credit revenue this way because they recognize it upon sale of the car vs. sale of the credit.
 
Q2: No tax credit hangover in the US. Instead, tax credit expiration pullforward of demand.

(There will be another US tax credit hangover in Q3, which I expect to be equally ugly to Q1.)

This affects Models S and X especially.

Quite a different falloff though: in Q4->Q1 it was $3750 reduction, whereas in Q2->Q3 it will be 50% smaller at $1875. I also wonder if many will assume Tesla will make a price adjustment again in July to partially compensate (like they did in early January). Alternatively it might be that SR doesn’t actually start shipping in volume until July (so effectively the cheapest car in July will be cheaper than the cheapest car you could get in June, even with the lower tax credit )
 
  • Informative
Reactions: neroden
Quite a different falloff though: in Q4->Q1 it was $3750 reduction, whereas in Q2->Q3 it will be 50% smaller at $1875. I also wonder if many will assume Tesla will make a price adjustment again in July to partially compensate (like they did in early January). Alternatively it might be that SR doesn’t actually start shipping in volume until July (so effectively the cheapest car in July will be cheaper than the cheapest car you could get in June, even with the lower tax credit )
I doubt there will be much of a price reduction - esp. in SR/SR+. If they do - then we know they are not getting enough orders ;)

The main difference between Q1 & Q2 - in terms of delivery (and production) would be the initial scaling problems in EU/China have been solved. So it should go smoother. With production any problems associated with change over to SR+ or to international editions are behind us.

If b2b's $600M GAAP loss is correct, they need about $200M GAAP profit in Q2 to be able to get into S&P. This makes Q2 very important.
 
  • Love
Reactions: neroden
Now that it's useful, I think over half of "old" car owners will buy it -- so 100000 may be an underestimate.
I'd be very surprised if half the owners were paying attention and willing to spend $3+ in those couple of weeks. I'd be happy to see about 50k. BTW, we don't even know what % paid $5k (AP+FSD, like me) and just $2k (because they already had AP).
 
  • Like
Reactions: neroden
Agreed.

ASP on Euro/Chinese models are likely actually higher, but ASP on US models is significantly lower, so it's basically the percentage of US models which determines this; it might even be lower than luvb2b's guess.

I also think one-time FSD revenue is much too low: luvb2b is essentially assuming that only 12000 "old car owners" decided to "pull the trigger", which is unlikely IMO. I'd bet on more like 100,000 "old car owners" deciding that FSD now has actual features and therefore buying it. We know that the take rate when it was first offered was minimal, under 10%. Now that it's useful, I think over half of "old" car owners will buy it -- so 100000 may be an underestimate. Anyway, this would be a very large difference in income -- a positive surprise, I guess. Since we have no way of getting an accurate estimate of how many "old car owners" pulled the trigger, this is going to be a massive uncertainty in net income and cash flow. 100K cars, it could be 300 million dollars; 200K cars, it could be 600 million dollars.

My conclusion is that this one element alone -- FSD purchases by car owners who had their cars before March started and FSD started having features -- is uncertain enough that we really can't project income or cash flow. It dwarfs a lot of the other numbers.

TE numbers are ultra hard to project, but I personally expect higher revenue than luvb2b expects. No way of telling COGS though, they've carefully buried it in with the accounting mess of the solar business.

I expect a drop in S/X lease percentage. I think there was a rush on them in the fourth quarter due to the tax credit expiration. People who bought/leased S and X in the US in the first quarter are going to be people who are paying no attention to money (and therefore ignored the tax credit expiration), or people who were enticed by FSD features perhaps; that is likely to include relatively few people who lease.

TLDR: I think the variance and uncertainty in major numbers makes trying to guess the Q1 financials impossible.

I'm not going to make a prediction, other than "They have plenty of cash for working needs and will be fine going into Q2".

Will Model Y deposits show up in any way, shape, or form on Tesla's balance sheet during the quarterly report? And is there any way some of the revenue from the fleet pooling with Fiat shows up in Q1 or will that necessarily be further down the road? Fiat Chrysler pools fleet with Tesla to avoid EU emissions fines - Phoneweek
 
Will Model Y deposits show up in any way, shape, or form on Tesla's balance sheet during the quarterly report? And is there any way some of the revenue from the fleet pooling with Fiat shows up in Q1 or will that necessarily be further down the road? Fiat Chrysler pools fleet with Tesla to avoid EU emissions fines - Phoneweek

The payment from the fleet pooling with Fiat Chrysler is a complete wild card. We have no idea what the payment schedule is, we only know that the amount is a super vague "hundreds of millions".

I conclude that I have absolutely no way to project Q1 numbers and shouldn't bother. Too many unquantifiable wild cards (ZEV, Fiat Chrysler, FSD uptake, Y deposits, lease rates on S/X, TE ramp-up, etc.) I think I can safely say cash flow will be between -1 billion and +1 billion and earnings the same. Maybe.

We'll hopefully have more information going into Q2 financials.
 
It would be in FCA’s best financial interest to not pay a single lump sum to Tesla in one quarter no? I think it’s a matter of when the deadline is and what they could get away with as far as spreading the payments apart until then.

I don’t think I would count on Q1 having a huge impact yet but yeah hard to say at this point.