S&P 500 Intrinsic Valuation (Feb 2018)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Name (Can leave anonymous)DateS&P 500 Expected growth rate in Index EarningsT.Bond RateERPValue of Index% Under or Over ValueCurrent Value / Expected Value of IndexSummary for Group
2
Aswath Damodaran2/11/18$2,581.006.00%3.50%5.00%$2,700.00-4.41%0.96AverageMedian
3
Frane Mestrovic2/12/18$2,590.995.00%3.25%4.90%$2,619.00-1.07%0.99Expected Growth Rate =5.64%6.00%
4
Simone Bottari2/11/18$2,619.007.26%3.20%5.54%$2,491.005.14%1.05Expected T.Bond Rate =3.31%3.25%
5
Udit D2/12/18$2,619.008.00%3.50%5.50%$2,619.000.00%1.00ERP =5.08%5.00%
6
Steven S2/11/18$2,619.554.30%3.00%5.54%$2,619.000.02%1.00% Under or Over Value7.60%4.10%
7
Parrott V3/20$2,619.004.20%3.35%5.60%$1,921.0036.34%1.36
8
Wasilev W2/14/18$2,619.006.50%3.75%4.50%$2,817.00-7.03%0.93
Please review all Value of Index since someone overwrote my entry
9
John Alvarado2-15-18$2,621.006.50%2.87%5.0%$2,619.000.08%1.00
10
Karl Barranco2/11/18$2,620.006.05%4.12%5.13%$2,700.00-2.96%0.97
11
2/10/18$2,619.005.75%3.75%5.00%$2,700.00-3.00%0.97
12
Julian Bearman2/28$2,600.003.00%4.25%5.50%$1,557.0066.99%1.67
13
2/12$2,581.003.03%3.00%5.00%
14
Dmitry Kaplun2/11/18$2,619.007.26%3%5.00%$2,685.00-2.46%0.98
15
Paul-Hugo Thiboult2/11/18$2,619.557.52%2.83%5.54%$2,460.376.47%1.06
16
AM2-14-18$2,619.003.00%3.50%5.50%$1,993.4731.38%1.31
17
Flavien Coron2/11/2018$2,619.557.32%3.16%5.00%$2,677.45-2.16%0.98
18
Wilmar Ariza2/12/18$2,620.005.50%3.00%5.25%$2,556.002.50%1.03
19
Elvis Miglans2/23/2018$2,620.005.75%3.75%5.25%$2,334.0012.25%1.12
20
Felipe Mejia Mejia2/27$2,620.003.03%3.30%6.00%$2,176.0020.40%1.20
21
Rahul Anand2/10/18$2,620.007.26%3.00%5.54%$2,129.4523.04%1.23
(2% lng trm gr rt)
22
2/11/18$2,619.007.26%3%5.54%$2,419.468.25%1.08
23
JJ Jahania2/14$2,619.556.50%3%5.25%$2,292.1314.28%1.14
24
Nik P Reis3/2$2,619.553.25%3.3%4.25%$2,292.1314.28%1.14
25
Conor O'Keefe2/10/18$2,620.005.75%3.75%5.25%$2,334.0012.25%1.12
26
2/14/18$2,640.426.00%3.50%5.50%
27
Jesús Chavoya3/7$2,641.697.26%3%5%$2,685.73-1.64%0.98
28
Hady Medhat2/10/18$2,651.927.26%3.50%5%$2,639.240.48%1.00
29
Igor Ujevic2/10/18$2,656.004.00%3.50%5%$1,909.0039.13%1.39
30
Michele2/8/18$2,656.006.00%3.50%5.54%$2,253.5017.86%1.18
How do we know what cash yield Aswath used to calculate his value of index? I can't seem to get 2700, thanks
31
David Nickum2/11/18$2,656.006.00%2.75%5%$2,565.003.55%1.04
32
James Mirtschin2/10/18$2,656.006.50%3%5.54%$2,342.0013.41%1.13
33
Fredrik3/28$2,663.006.00%3.30%5.10%$2,450.358.68%1.09
34
Bettina2/11/18$2,663.004.00%3.30%5.00%
I thought that there would be a formula for column G, Value of Index? How can I calculate that?
35
Daniel S2/11/2018$2,672.005.62%3%5%$2,513.996.29%1.06
^^^ there's a another spreadsheet he release to calculate the value
36
William Q.2/16/18$2,698.638.00%5.00%4.00%$3,240.91-16.73%1.10
37
Ken M.2/11/18$2,721.008.67%3.00%5%$2,899.00-6.14%0.94
38
CCTC2/12/18$2,740.005.00%3.00%4.77%$2,339.4017.12%1.17
39
Taejin Kim2/11/18$2,734.635.00%2.75%5%$2,698.781.33%1.01
40
Carlos Cubillos2/10/18$2,732.007.26%2.87%5%$2,692.501.47%1.01
41
Andrew "Jake" Tisinger2/12$2,732.227.00%3%4.77%$2,796.41-2.30%0.98
42
Kanishk Dugar2/16/18$2,7037.50%3.30%4.80%$2,798-3.40%0.97
43
Chu2/10/18$2,744.285.00%3.50%4.5%$2,661.063.13%1.03
44
YF2/12/18$2,713.835.00%4.50%4.50%$2,570.315.58%1.06
45
Chanakaya2/16/18$2,6905.00%3.50%4%$2,570.314.66%1.05
46
PM2/12/18$2,6904.00%3.50%4%$2,570.314.66%1.05
47
P2/16/18$2,718-3.50%3%6%$2,570.315.75%1.06
48
Jordan H$2,610.087.68%2.78%5.32%$2,586.630.91%1.01
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Sheet1
Sheet2
Sheet3
 
 
Main menu