Tesla Valuation - March 2014
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEFGHIJKLMNOPQRST
1
NameDate of valuationRevenues in year 10Target Operating MarginSales/Capital RatioCost of capitalValue of equityValue per shareStock price on valuation dateAction (Buy, Sell (short), Watch in awe)
2
Oliver S4/14/201510,00012%1.558%$8,000$63.59$207ShortValued at 1x EV/Sales in yr10, less expected debt in yr10 ($2bn) with no time value of money (to be generous)
3
A3/25/201410000010108%17000$99.85$220Watch in awe
4
Don A4/5/2014800001558%230Short
5
5000104
6
Matthew Crews2/17/201550,0001528%$24,673.97$196.61$203.00Modified tax rate in year 3 to 24% -- stepped up from 0%; lowered revenue growth to 45% for first 5 years; increased amortization years for R&D to 7
7
Matthew Crews2/18/201550,000151.39.50%$18,636.00$148.49$204.00Lower StC ratio; Increased CoC; no value to gigafactory
8
9
10
September2014jjjj14660092625.9
11
August201415595914636895916.1
12
July201415602314635296716.2
13
June201415569414622194746.1
14
May201415561314581497996.3
15
April201415542114566997536.3
16
March2014156227145742104866.7
17
February2014155724145266104596.7
18
January2014155460145224102366.6
19
December2013154937144586103516.7
20
November2013155284144443108417
21
October2013154625143485111407.2
22
September2013155473144270112037.2
23
August2013155435144179112567.2
24
July2013155693144285114087.3
25
June2013155822144075117477.5
26
May2013155609143919116907.5
27
April2013155359143676116837.5
28
March2013155099143393117067.5
29
February2013155511143464120477.7
30
January2013155699143384123157.9
31
December2012155485143212122737.9
32
November2012155279143233120457.8
33
October2012155507143369121387.8
34
September2012155018142947120707.8
35
August2012154669142204124648.1
36
July2012154970142272126988.2
37
June2012155134142432127028.2
38
May2012154946142257126898.2
39
April2012154565141963126038.2
40
March2012154811142079127328.2
41
February2012154826141943128838.3
42
January2012154328141677126508.2
43
December2011153927140836130908.5
44
November2011154072140747133268.6
45
October2011153940140335136048.8
46
September2011154059140154139059
47
August2011153724139904138209
48
July2011153309139524137859
49
June2011153379139409139719.1
50
May2011153526139653138739
51
April2011153566139622139449.1
52
March2011153403139655137489
53
February2011153280139422138589
54
January2011153198139287139109.1
55
December2010153639139266143739.4
56
November2010154127139030150979.8
57
October2010153631139111145209.5
58
September2010153971139393145789.5
59
August2010154087139427146609.5
60
July2010153706139179145279.5
61
June2010153631139148144839.4
62
May2010154106139247148589.6
63
April2010154642139309153339.9
64
March2010153964138752152129.9
65
February2010153720138599151219.8
66
January2010153404138451149539.7
67
December2009153111138013150989.9
68
November2009153878138659152199.9
69
October20091537841384321535210
70
September2009153827138818150099.8
71
August2009154307139492148149.6
72
July2009154502139901146019.5
73
June2009154716140009147079.5
74
May2009154747140248144999.4
75
April2009154509140656138539
76
March2009154133140707134268.7
77
February2009154538141640128988.3
78
January2009154210142152120587.8
79
December2008154655143369112867.3
80
November2008154639144100105386.8
81
October2008154876144802100746.5
82
September200815457014507694946.1
83
August200815464114520394386.1
84
July200815446914553289375.8
85
June200815431314573785755.6
86
May200815430314590883955.4
87
April200815376914613276375
88
March200815390814608678225.1
89
February200815365314615674974.9
90
January200815406314637876855
91
December200715391814627376455
92
November200715383514659572404.7
93
October200715318314594672374.7
94
September200715341414624471704.7
95
August200715274914568270674.6
96
July200715305414590571494.7
97
June200715304114606369794.6
98
May200715267014590367664.4
99
April200715243514558668504.5
100
March200715305114632067314.4
Loading...
 
 
 
Sheet1
Sheet2