TMC is an independent, primarily volunteer organization that relies on ad revenue to cover its operating costs. Please consider whitelisting TMC on your ad blocker and becoming a Supporting Member. For more info: Support TMC

Near-future quarterly financial projections

Discussion in 'TSLA Investor Discussions' started by luvb2b, May 23, 2018.

  1. Spacemanspliff

    Joined:
    Sep 11, 2018
    Messages:
    233
    Location:
    California
    Did this include the ship bound for japan or just purely china?

    To me it seems like grasping at straws to think they got more efficient at how to load and unload cars while also stuffing more cars on per ship. I'd like to know what they do during idle time.
     
  2. EVNow

    EVNow Well-Known Member

    Joined:
    Sep 5, 2009
    Messages:
    5,909
    Location:
    Seattle, WA
    #1942 EVNow, May 22, 2019
    Last edited: May 22, 2019
    Just China.

    Well, looks like Idle time has nothing to do with the particular ship. It is the time between a ship departing and the next ship coming. So, basically in Q1 within hours of a ship leaving the next ship would show up. Now a ship goes and then after 2 to 3 days the next ship comes.

    So, clearly they are spacing the ships out in Q2, but what this means I don't know.

    In general they should be able to load 2 ships a week, if they are making cars only for outside and the capacity is 3k or so. This is what they did in Q1. In Q2 they are loading about one in 5 days. So are they making cars for abroad 3 days a week ?
     
  3. gluu

    gluu Member

    Joined:
    Jan 18, 2018
    Messages:
    86
    Location:
    Chicago
    My read of the Tesla Carriers spreadsheet is that cars were mostly sent overseas in the first 2 months of production, then March was essentially only domestic production and delivery. This means in Q2 Month 1, deliveries outside of the 10k in transit went to North America, given that cars on ships seem to take about a month to get delivered, so the only possibility for manufacture and delivery in the same month would be in North America. This increase in domestic deliveries for month 1 is also a product of unwinding delivery hell. My guess is that April and May will see similar deliveries of 14k with a potential spike of SR+ deliveries in June due to the tax credit cliff and limited cell supply. This is why I estimate 14k a month deliveries to North America, and 30k to foreign countries assuming all the ships can get delivered.
     
  4. EVNow

    EVNow Well-Known Member

    Joined:
    Sep 5, 2009
    Messages:
    5,909
    Location:
    Seattle, WA
    #1944 EVNow, May 22, 2019
    Last edited: May 22, 2019
    To unwind the wave - Tesla needs to send about 15 to 17 ships of 3k each to reach 45k to 50k of shipments or one every 6 days - until GF3 (and then GF4) come online. Selling about the same in NA will given them about 100k deliveries a quarter or 400k a year.

    With a lag of 1 month in delivery, that means about 15k cars will always be in transit every quarter. In the US if the delivery takes 2 weeks, that would be some 7k. So, 22k cars in transit every quarter end. It is not bad compared to 33k in transit + inventory + floor cars we had at the end of Q1. To totally smooth out the delivery waves - they need to carry 30k or so in in inventory + transit. Good thing is this will not eat up any more cash in the coming quarters since they paid for it in Q1 (and we are all paying for it in SP fall).
     
    • Informative x 2
    • Helpful x 1
  5. Spacemanspliff

    Joined:
    Sep 11, 2018
    Messages:
    233
    Location:
    California

    You think they ship 20k M3's worldwide in all of Q2 via 10 ships? Granted that in transit 10k was probably 7-8kM3 and 2-3k S/X but that still implies a fairly low car to carrier ratio especially if you are going with 15k S/X.
     
  6. Spacemanspliff

    Joined:
    Sep 11, 2018
    Messages:
    233
    Location:
    California
    Eh, actually if they do 500 S/X a ship that’s 5,000 that probably fits the 15k S/X bill.

    For a note: Adam Jonas’s leaked call today he stated his estimates are 82k but he hears “whispers” of in the 70’s to high 70’s.
     
    • Like x 2
  7. heltok

    heltok Member

    Joined:
    Aug 12, 2014
    Messages:
    375
    Location:
    Sweden
    If we plug in the supposed leaked email numbers are we then looking at Q2 profits?
     
  8. Remus

    Remus Active Member

    Joined:
    Apr 14, 2016
    Messages:
    1,071
    Location:
    California
    #1948 Remus, May 23, 2019
    Last edited: May 23, 2019
    Guidance was 90k with gaap loss. And even with the email a "safer" estimate would be in the 80s. So probably still loss.

    But this and the California number makes me very optimistic about the long term demand, because Toyota first invaded California too, and went on to dominate the u.s. car market. It took Toyota two decades. Looks like I don't have to wait that long for Tesla to do the similar
     
    • Informative x 3
    • Like x 2
  9. gluu

    gluu Member

    Joined:
    Jan 18, 2018
    Messages:
    86
    Location:
    Chicago
    The stock is currently pricing a repeat of Q1. Looks like a good time to load up...
     
    • Like x 5
  10. Doggydogworld

    Doggydogworld Member

    Joined:
    Mar 4, 2019
    Messages:
    544
    Location:
    Texas
    Last quarter 16 ships carried ~25k Model 3s that got delivered in Q1 plus another ~5k that spilled into Q2. This quarter it looks like 11 or 12 ships will make the cutoff. Loading times have been similar, implying (12/16) * 30k = 22.5k Model 3s. If none of those spill over into Q3, that's 22.5k + 5k = 27.5k overseas Model 3s delivered in Q2. My estimate was 30k.

    I see Q1's 10.6k in transit as being 4k US Model 3s (mostly SR+) and 5k overseas split more or less evenly between China and Europe. The other 1.6k are S/X (several hundred fewer than the prior quarter).
     
    • Helpful x 1
    • Informative x 1
    • Disagree x 1
  11. Spacemanspliff

    Joined:
    Sep 11, 2018
    Messages:
    233
    Location:
    California
    Gotcha, whats your source for 30k overseas deliveries and what was your avg per carrier?
     
  12. Doggydogworld

    Doggydogworld Member

    Joined:
    Mar 4, 2019
    Messages:
    544
    Location:
    Texas
    Q1 Model 3s were 20k Europe and 5k+ China. Spillover into Q2 was 2.5k +/- for each Europe and China. So those 16 boats carried roughly 30k Model 3s. Source is the thread on this forum that shows European deliveries through April and a link posted on the Investor Roundtable thread the other day to a twitter bear with China numbers through April. I don't have the links to either handy, but someone else here might.
     
  13. kbM3

    kbM3 Active Member

    Joined:
    May 22, 2017
    Messages:
    1,180
    Location:
    Orlando
    Could have been clearer:

    OCF > CapEx.
     
    • Like x 1
  14. EVNow

    EVNow Well-Known Member

    Joined:
    Sep 5, 2009
    Messages:
    5,909
    Location:
    Seattle, WA
    I wonder - how much flexibility do they have in booking capex. Do they have to recognize it when the shipment lands or when they get the bill or ...

    Basically can they adjust the capex in a quarter depending on how much cash they got that quarter - knowing capex is ordered months in advance.
     
    • Informative x 1
  15. Doggydogworld

    Doggydogworld Member

    Joined:
    Mar 4, 2019
    Messages:
    544
    Location:
    Texas
    Capex is a cash flow line item, so it only appears when they finally pay the supplier. That can be a few quarters after construction occurs or machinery arrives.
     
    • Helpful x 2
    • Like x 1
  16. EVNow

    EVNow Well-Known Member

    Joined:
    Sep 5, 2009
    Messages:
    5,909
    Location:
    Seattle, WA
    Oh yes, until then it just sits in payables.

    So, Tesla probably has the flexibility to adjust their payment to match cash flow. Ofcourse if they have a really bad quarter like in Q1, they won't care. If they are close (like may be in Q2) - they can adjust the timing of the payment. I guess they can also negotiate the terms of payment.

    What I'm getting to is, only over a longer period we can determine whether Tesla is Op cash > Capex.
     
  17. neroden

    neroden Model S Owner and Frustrated Tesla Fan

    Joined:
    Apr 25, 2011
    Messages:
    14,492
    Location:
    Ithaca, NY, USA
    Seriously, do you really think ship loading time is really proportional to number of cars? I am pretty sure they could load more cars in the same number of days and just be more relaxed about it. All other evidence is more cars per ship Q2 than Q1 including a direct statement about it on the conference call.
     
    • Like x 1
  18. Doggydogworld

    Doggydogworld Member

    Joined:
    Mar 4, 2019
    Messages:
    544
    Location:
    Texas
    They load as fast as permitted under local regulations and union rules so they can get back on the water. They don't make money sitting in port.
     
  19. EVNow

    EVNow Well-Known Member

    Joined:
    Sep 5, 2009
    Messages:
    5,909
    Location:
    Seattle, WA
    #1959 EVNow, May 24, 2019
    Last edited: May 24, 2019
    Here is my latest iteration of rough p&l. With an optimistic 92k deliveries, I get a non-GAAP EPS of $0.06 and revenue of $6.5B.

    Yahoo finance avg analyst estimate today is : $-0.44 EPS (non-GAAP) and revenue of $6.22B.

    The main difference from last time is that I've increased the deliveries, but also in Q4 assuming no GF3 deliveries and yet 117k deliveries. That pushes ASP up from earlier. Also I've made some changes @Doggydogworld suggested. Pushed up Energy generation & storage as well as services.

    teslapandl.png
     
    • Informative x 7
  20. endofpetroleum

    endofpetroleum New Member

    Joined:
    May 19, 2019
    Messages:
    3
    Location:
    Canada
    Can someone explain how TSLA intends to handle its convertible notes? $900mi convertible paid out as cash this year, $600mi due in Nov, $1.3bi due early '21, $1bi due early '22.

    A quick analysis of how these obligations - assuming they are paid out in cash - will impact the company?
     

Share This Page

  • About Us

    Formed in 2006, Tesla Motors Club (TMC) was the first independent online Tesla community. Today it remains the largest and most dynamic community of Tesla enthusiasts. Learn more.
  • Do you value your experience at TMC? Consider becoming a Supporting Member of Tesla Motors Club. As a thank you for your contribution, you'll get nearly no ads in the Community and Groups sections. Additional perks are available depending on the level of contribution. Please visit the Account Upgrades page for more details.


    SUPPORT TMC