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.
In the interest of sharing, I though to post some screenshots of the model that I keep. I've included the the last two and upcoming three quarters. I've broken the screenshots down in revenue/costs and profit(loss) statement. I do not have a comprehensive cash estimation model as @luvb2b has, but she certainly inspired me so I will do it (someday). You'll see it's a good bit more conservative (attentive participants would expect this from me) but the conclusion is still the same. Q3 will see a very small profit (small enough that it still could go the other way) but Q4 will certainly be in the black.

View attachment 313204

View attachment 313205

View attachment 313206
Curious why you think MS/X ASP in Q3/Q4 would be lower than Q1/Q2. I suspect that the tax incentive phase-out would give MS/X ASP a similar boost as to M3 in Q3/Q4.
 
No, clearly he doesn't think that, since he refers to Q3/Q4, when the full tax incentive is (presumed to be) still in force. What he means, I believe, is that people will take the $7.5k and apply it to buying more accessories.
Yes, knowing the tax credit will be reduced in Q1 2019, more M3 P3/AWD buyers are ordering in 2018, allowing Tesla to go with a higher ASP mixture for M3 in Q3/Q4 of 2018. Similar effect should apply to MS/X IMO.
 
Troy is "pretty sure". One discrepancy is the deliveries to canada that the photos by @K_Dizzle contest. We are talking about 4k vehicles, I think. Troy was estimating hundreds to canada and @K_Dizzle 's photos suggest thousands.

LOVE @K_Dizzle - one of the best Twitter accounts. His "goal post" GIF is forever engrained in TSLA history.

Deliveries to Canada may surprise, which is why I think Elon is confident about "rude awakening" with respect to Goldman's note.
 
Curious why you think MS/X ASP in Q3/Q4 would be lower than Q1/Q2. I suspect that the tax incentive phase-out would give MS/X ASP a similar boost as to M3 in Q3/Q4.

Because of more sales out of inventory. It's been a repeating pattern as far as I can see. Quarters in which inventory is built up see slighly higher ASP. Quarters when they sell down inventory see lower ASP (makes sense really). With production fixed at 25k and the first half of the quarter lower than 25k sales, logically inventory is being built up. Tesla will right this balance in Q3 and Q4 with sales numbers significantly above 25k, partially by having more generous out of inventory sales. That's the mechanism that I think will be in play this year.
 
Because of more sales out of inventory. It's been a repeating pattern as far as I can see. Quarters in which inventory is built up see slighly higher ASP. Quarters when they sell down inventory see lower ASP (makes sense really). With production fixed at 25k and the first half of the quarter lower than 25k sales, logically inventory is being built up. Tesla will right this balance in Q3 and Q4 with sales numbers significantly above 25k, partially by having more generous out of inventory sales. That's the mechanism that I think will be in play this year.
Good point, the counter point is that I don't see a lot of inventory for them to sell. AFAIK Tesla sold something like 6k cars from inventory in Q4'17 to help with the cash situation. In Q1'18 I see that they replenished 1388 into inventory (24728 produced + 2520 transit overhang - 4060 transit - 21800 delivery). If Q2 is similar, they have not come close to replenishing the inventories that they sold off in Q4'17. I just don't see them having a lot of inventory to sell in 2H'18.
 
Good point, the counter point is that I don't see a lot of inventory for them to sell. AFAIK Tesla sold something like 6k cars from inventory in Q4'17 to help with the cash situation. In Q1'18 I see that they replenished 1388 into inventory (24728 produced + 2520 transit overhang - 4060 transit - 21800 delivery). If Q2 is similar, they have not come close to replenishing the inventories that they sold off in Q4'17. I just don't see them having a lot of inventory to sell in 2H'18.

They went into this year with a potential inventory overhang of 6768 Model S/X units (difference between historically reported total running production and delivery minus transit). So 8000 at the end of the quarter. I am wagering that they'll add more to the inventory this quarter as well. That should potentially put them well over 10k Model S/X in inventory. Now some of those cars may have been used for testing purposes and what not. And they're likely not willing to sell below a critical amount of cars needed for loaner duty and so on. Still, I think there will be enough inventory to go around.
 
  • Informative
Reactions: Waiting4M3
My Q2 2018 Estimates:
  • 27,443 Model 3 production in Q2 2018 (Expected accuracy: 95%)
  • 23,756 Model S+X production in Q2 2018 (Expected accuracy: 92%)
  • 15,814 Model 3 deliveries in Q2 2018 (Expected accuracy: 85%)
  • 11,269 Model S deliveries in Q2 2018 (Expected accuracy: 85%)
  • 9,674 Model X deliveries in Q2 2018 (Expected accuracy: 85%)
  • 14,512 Model 3 deliveries in the US in Q2 2018 (Expected accuracy: 85%)
  • 1,302 Model 3 deliveries in Canada in Q2 2018 (Expected accuracy: 85%)
  • 205,121 US sales at the end of Q2 2018. (Expected accuracy: 96%)
Most people believe that I'm wrong on the 200K calculation but I have to go with what the data shows. If it's wrong, it will demonstrate that it's difficult to estimate deliveries. Generally speaking, estimating deliveries is a lot more difficult than estimating production because a ship might not have arrived yet in Europe or Asia or they might have decided to add more cars to the new inventory fleet. Lot's of things can affect deliveries. Estimating production is easier because of VINs.

Predicting the 200K is really difficult because it turned into a close call. Initially, it looked like they would exceed 200K by 15K. However, Tesla dramatically lowered the deliveries in June. If you look at the table here, it shows 3472 US deliveries for June. In addition, insideEVs calculation is much closer to 200K than mine and they are known to over-estimate the number by 2-3%. I could be 96% accurate and still wrong. They might have managed to postpone 200K to Q3. It's a close call.

The actual numbers for the first 5 items on the list will be released by Tesla in a few days. I will measure the accuracy in percentage. I don't think Tesla will release the Model 3 US and Canada delivery numbers but I added those just in case they decided to release them.
 
It's quite shocking how low your estimate for Model 3 deliveries this quarter is and yet all the numbers together still tally up to 205k reached this quarter. Not blaming you, as you said, you have to go by what the data shows. The shock is really from the data. Personally I am still hoping that deliveries will be better on the M3 for two reasons that are at least possible 1) Severe underreporting from Canada. This would introduce a bias in the numbers. Possibly adds a few thousand deliveries 2) gaming the 200k rule by massively delivering this saturday, which would count the cars Q2 for accounting purposes but would only count them as titled in Q3 for the 200k fed credit threshold. Possibly another 1000 cars could be tricked this way.

I have never been more curious for the 10-K for quarterly deliveries release.
 
I created the following spreadsheet to compare different estimates by forum members. I have read somewhere that the average estimate of a community is usually pretty accurate. About 1h 40min left until the survey closes for this quarter:

Spreadsheet: Q2 2018 Tesla production and delivery estimates
Google form: Click here to add your estimate by the end of today (30 June), Pacific Time
Yes, for example VERY SHORT-LIVED THREAD: Your best #s for 3Q16 Delivery Numbers.

My estimate for Model 3 produced going purely by one VIN sighting and assuming all sequencially produced with gaps totaling only 300-400 to that VIN is 37,149, so average 33,370 & median 33,931.
 
Last edited:
So, per Electrek, the official numbers:
Produced 28578 Model 3, Delivered 18,440 Model 3. 11166 in transit
Net reservations for Model 3 end of quarter -- 420,000.

Produced 24761 Model S/X combined, Delivered 10,930 Model S, Delivered 11,370 Model X. 3892 in transit.

Tesla releases official production numbers: 53,339 vehicles including 28,578 Model 3’s in Q2, 6,000 per week next month

Now let the speculation begin on the Canada/US split of Model 3. I'm pretty sure the Canadian numbers are really high.
 
@luvb2b


given 0% margin it is unlikely that the 6.5k fewer 3s affects your I/S right?


Probably a nominal affect on cash flow as inventory will be higher from all the capped costs. Maybe 100m max.


So excited for the Update letter!


Congrats to longs on the production milestone!
 
  • Like
Reactions: dakh
Here are the scores of the Q2 2018 Tesla production and delivery estimates survey. You can find the spreadsheet here. @yak-55's overall accuracy was 95.9% which I think is excellent. @Bokonon's both Model 3 estimates were amazingly accurate. 99.9% and 99%, wow!

U6jJ2N8.png