The cash cow premise is that operating leverage will result once M3 production achieves planned volumes. The size of the cow depends on execution between 3Q18 through 2Q19. The biggest variable may be how quickly M3 GM% can improve.
My guess at the rest of 2018 follows; 2019 is more difficult to project, partly because I think Tesla will begin M3 leases in NA in 1Q19 and partly because the US FIT credit will be in phase-down mode after 4Q18. I've attached a spreadsheet link at the end of the table for those wanting to see the formulas (and change them and/or the assumptions)
QUARTER] |
ASSUMPTIONS |
S &X DELIVERIES |
M3 DELVERIES |
S & X % LEASED |
S & X ASP |
S & X GM % |
M3 % LEASED |
M3 ASP |
M3 GM % |
ZEV CREDIT SALES |
GHG/CAFE CREDIT SALES |
SOLAR MW |
ENERGY STORAGE MWH |
REVENUE |
S & X SALES |
M3 SALES |
AUTO LEASING |
ENERGY GEN/STOR |
SERVICES & OTHER |
REVENUE TOTAL |
COST OF REVENUE |
S & X SALES |
M3 SALES |
AUTO LEASING |
ENERGY GEN/STOR |
SERVICES & OTHER |
COST OF REVENUE TOTAL |
GROSS PROFIT |
R&D |
SG&A |
|
INTEREST INCOME |
INTEREST EXPENSE |
OTHER (EXPENSE) INCOME |
TAXES |
NET (LOSS)/ INCOME |
NCI LAYOFF |
NET (LOSS)/INCOME SH |
[TD2]
1Q18 A
[/TD2][TD2]
2Q18 E
[/TD2][TD2]
3Q18 E
[/TD2][TD2]
4Q18 E
[/TD2][TD2]
TOTAL 2018
[/TD2]
[TD2]21,815[/TD2][TD2]22,000[/TD2][TD2]27,500[/TD2][TD2]28,685[/TD2][TD2]100,000[/TD2]
[TD2]8,182[/TD2][TD2]37,500[/TD2][TD2]55,000[/TD2][TD2]72,500[/TD2][TD2]173,182[/TD2]
[TD2]0.08[/TD2][TD2]0.09[/TD2][TD2]0.10[/TD2][TD2]0.10[/TD2][TD2]0.09[/TD2]
[TD2]$102.70[/TD2][TD2]$100.00[/TD2][TD2]$105.00[/TD2][TD2]$105.00[/TD2][TD2]$103.180[/TD2]
[TD2]0.215[/TD2][TD2]0.22[/TD2][TD2]0.24[/TD2][TD2]0.25[/TD2][TD2]23.31%[/TD2]
[TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2][TD2]0[/TD2]
[TD2]$55.04[/TD2][TD2]$55.00[/TD2][TD2]$60.00[/TD2][TD2]$60.00[/TD2][TD2]$57.51[/TD2]
[TD2]-0.1034[/TD2][TD2]-0.12[/TD2][TD2]0.075[/TD2][TD2]0.125[/TD2][TD2]4.89%[/TD2]
[TD2]$50,314[/TD2][TD2]0[/TD2][TD2]$125,000[/TD2][TD2]$150,000[/TD2][TD2]$325,314[/TD2]
[TD2]$30,015[/TD2][TD2]$30,000[/TD2][TD2]$35,000[/TD2][TD2]$40,000[/TD2][TD2]$135,015[/TD2]
[TD2]76[/TD2][TD2]85[/TD2][TD2]92.5[/TD2][TD2]100[/TD2][TD2]353.5[/TD2]
[TD2]373[/TD2][TD2]275[/TD2][TD2]362.5[/TD2][TD2]390[/TD2][TD2]1,400.5[/TD2]
[TD2]$2,141,497[/TD2][TD2]$2,054,000[/TD2][TD2]$2,758,750[/TD2][TD2]$2,900,733[/TD2][TD2]$9,854,980[/TD2]
[TD2]$450,337[/TD2][TD2]$2,062,500[/TD2][TD2]$3,300,000[/TD2][TD2]$4,350,000[/TD2][TD2]$10,162,837[/TD2]
[TD2]$173,436[/TD2][TD2]$170,000[/TD2][TD2]$177,500[/TD2][TD2]$185,00[/TD2][TD2]$705,936[/TD2]
[TD2]$410,022[/TD2][TD2]$380,000[/TD2][TD2]$413,529[/TD2][TD2]$447,059[/TD2][TD2]$1,650,610[/TD2]
[TD2]
$263,412
[/TD2][TD2]
$300,000
[/TD2][TD2]
$341,670
[/TD2][TD2]
$389,128
[/TD2][TD2]
$1,294,210
[/TD2]
[TD2]
$3,438,705
[/TD2][TD2]
$4,966,500
[/TD2][TD2]
$6,991,449
[/TD2][TD2]
$8,271,919
[/TD2][TD2]
$23,668,574
[/TD2]
[TD2]$1,618,017[/TD2][TD2]$1,578,720[/TD2][TD2]$1,975,050[/TD2][TD2]$2,033,049[/TD2][TD2]$7,204,837[/TD2]
[TD2]$496,092[/TD2][TD2]$2,310,000[/TD2][TD2]$3,052,500[/TD2][TD2]$3,806,250[/TD2][TD2]$9,665,652[/TD2]
[TD2]$104,496[/TD2][TD2]$102,430[/TD2][TD2]$111,468[/TD2][TD2]$120,506[/TD2][TD2]$438,900[/TD2]
[TD2]$375,363[/TD2][TD2]$335,000[/TD2][TD2]$381,532[/TD2][TD2]$434,526[/TD2][TD2]$1,526,421[/TD2]
[TD2]
$380,969
[/TD2][TD2]
$405,000
[/TD2][TD2]
$570,127
[/TD2][TD2]
$674,545
[/TD2][TD2]
$2,030,
641[/TD2]
[TD2]
$2,975,747
[/TD2][TD2]
$4,731,150
[/TD2][TD2]
$6,090,677
[/TD2][TD2]
$7,068,877
[/TD2][TD2]
$20,866,451
[/TD2]
[TD2]
$462,957
[/TD2][TD2]
$235,350
[/TD2][TD2]
$900,773
[/TD2][TD2]
$1,203,043
[/TD2][TD2]
$2,893,154
[/TD2]
[TD2]$367,096[/TD2][TD2]$379.944[/TD2][TD2]$393,242[/TD2][TD2]$407,006[/TD2][TD2]$1,547,289[/TD2]
[TD2]$686,404[/TD2][TD2]$710,428[/TD2][TD2]$735,293[/TD2][TD2]$761,028[/TD2][TD2]$2,893,154[/TD2]
[TD2]$5,214[/TD2][TD2]$5,300[/TD2][TD2]$5,300[/TD2][TD2]$5,300[/TD2][TD2]$21,114[/TD2]
[TD2]-$149,546[/TD2][TD2]-$160,000[/TD2][TD2]-$171,185[/TD2][TD2]-$183,151[/TD2][TD2]-$663,882[/TD2]
[TD2]-$37,716[/TD2][TD2]-$35,000[/TD2][TD2]-$32,480[/TD2][TD2]-$30,141[/TD2][TD2]-$135,336[/TD2]
[TD2]$5,605[/TD2][TD2]$5,000[/TD2][TD2]$5,000[/TD2][TD2]$5,000[/TD2][TD2]$20,605[/TD2]
[TD2]
-$777,414
[/TD2][TD2]
-$1,050,323
[/TD2][TD2]
-$431,727
[/TD2][TD2]
-$178,584
[/TD2][TD2]
-$2,438,047
[/TD2]
[TD2]-$75,076[/TD2][TD2]-$85,000[/TD2][TD2]-$96,236[/TD2][TD2]-$108,957[/TD2][TD2]-$365,269[/TD2]
[TD2]-$702,338[/TD2][TD2]-$965,323[/TD2][TD2]-$335,491[/TD2][TD2]-$69,627[/TD2][TD2]-$2.072,778[/TD2]