The aim is to discuss/calculate a "fair value"
for the NASDAQ 100 using analysis of earnings of the
index components. We can also discuss bear market
and bull market values.
This first post is maintained from time to time
with a table of the index components. The table
is updated with the following values:
1) % weighting that each stock has in the index
2) A recent price
3) Current year earnings
4) Forward Earnings based on estimates
Here is the Nov 18, 2001 version of these values. I have
used Friday's closing prices and the earnings
estimates shown at Yahoo finance.
Ticker Weight Price CY01 Earnings Forward Earnings
MSFT 11.27 65.75 1.79 Dec-01 2.09 Jun-03
INTC 6.67 30.63 0.47 Dec-01 0.57 Dec-02
QCOM 4.97 60.08 0.95 Dec-01 1.36 Sep-02
CSCO 4.84 20.02 0.10 Jan-02 0.40 Jul-03
ORCL 3.16 14.55 0.44 Nov-01 0.52 May-03
AMGN 2.56 56.52 1.19 Dec-01 1.40 Dec-02
DELL 2.44 26.60 0.64 Jan-02 0.74 Jan-03
MXIM 2.29 54.10 0.91 Dec-01 0.99 Jun-03
IMNX 1.77 26.02 0.29 Dec-01 0.30 Dec-02
SUNW 1.75 13.39 0.03 Dec-01 0.23 Jun-03
CMCSK 1.58 38.23 -1.23 Dec-01 -1.03 Dec-02
XLNX 1.53 36.72 0.35 Dec-01 0.37 Mar-03
AMAT 1.51 39.26 0.37 Jan-02 1.38 Oct-02
CEFT 1.50 28.82 0.59 Dec-01 0.76 Dec-02
VRTS 1.43 38.90 0.65 Dec-01 0.64 Dec-02
WCOM 1.42 14.48 0.72 Dec-01 0.63 Dec-02
GENZ 1.34 55.22 1.18 Dec-01 1.48 Dec-02
JDSU 1.32 11.60 -0.11 Dec 01 0.09 Jun-03
PSFT 1.29 32.36 0.57 Dec-01 0.72 Dec-02
CHIR 1.26 51.51 0.95 Dec-01 1.16 Dec-02
SEBL 1.25 25.00 0.46 Dec-01 0.47 Dec-02
ALTR 1.23 25.02 0.33 Dec-01 0.25 Dec-02
PAYX 1.18 35.89 0.74 Nov-01 0.92 May-03
LLTC 1.16 41.06 0.92 Dec-01 0.83 Jun-03
BBBY 1.13 30.77 0.68 Nov-01 0.88 Feb-03
EBAY 1.12 60.00 0.47 Dec-01 0.74 Dec-02
FLEX 1.10 24.02 0.72 Dec-01 0.92 Mar-03
GMST 1.02 25.54 -1.25 Dec-01 -1.16 Dec-02
KLAC 1.02 49.98 2.06 Dec-01 1.30 Jun-03
IDPH 1.02 67.61 0.59 Dec-01 0.90 Dec-02
INTU 1.01 39.97 0.92 Jan-02 1.21 Jul-03
BMET 0.95 28.92 0.86 Nov-01 1.06 May-03
SBUX 0.93 17.50 0.48 Dec-01 0.62 Sep-03
COST 0.93 42.13 1.30 Nov-01 1.68 Aug-03
BGEN 0.92 54.96 1.90 Dec-01 1.96 Dec-02
NXTL 0.92 10.95 -2.01 Dec-01 -1.52 Dec-02
MEDI 0.90 43.06 0.69 Dec-01 1.02 Dec-02
AAPL 0.87 18.97 0.57 Dec-01 0.63 Sep-03
FISV 0.86 39.57 1.07 Dec-01 1.27 Dec-02
CHKP 0.86 39.36 1.23 Dec-01 1.29 Dec-02
CTAS 0.84 44.75 1.34 Nov-01 1.66 May-03
VRSN 0.78 45.23 0.65 Dec-01 1.16 Dec-02
NVDA 0.75 52.49 1.01 Jan-02 1.31 Jan-03
ERTS 0.70 54.12 0.28 Dec-01 1.43 Mar-03
ADBE 0.68 31.90 1.16 Nov-01 1.04 Nov-02
CIEN 0.68 19.42 0.47 Jan-02 0.38 Oct-03
BRCM 0.68 45.81 -0.33 Dec-01 -0.13 Dec-02
USAI 0.66 20.89 -0.40 Dec-01 -0.35 Dec-02
MLNM 0.64 29.46 -0.55 Dec-01 -0.75 Dec-02
BRCD 0.64 29.47 0.18 Jan-02 0.28 Oct-02
DISH 0.58 25.83 -0.40 Dec-01 0.62 Dec-02
GILD 0.58 68.26 -1.16 Dec-01 -0.16 Dec-02
SANM 0.56 19.60 0.53 Dec-01 0.87 Sep-03
BEAS 0.53 16.42 0.31 Jan-02 0.34 Jan-03
NVLS 0.51 38.89 1.34 Dec-01 0.51 Dec-02
HGSI 0.51 44.78 -0.73 Dec-01 -1.13 Dec-02
SPLS 0.51 17.97 0.63 Jan-02 0.75 Jan-03
NTAP 0.50 15.95 0.07 Jan-02 0.20 Apr-03
AMCC 0.48 15.87 -0.04 Dec-01 -0.08 Mar-03
RFMD 0.48 27.02 -0.06 Dec-01 0.27 Mar-03
Weighted average CY01 PE = 58.8
Forward PE (circa Mar-03) = 45.3
Notes:
1) The 60 stocks used in the calculation account for 88.6 % of the weighting
2) CY 01 includes all quarters up to Nov-01, Dec-01 or Jan-02
3) Forward earnings end date varies for each company according to accounting year
4) Pro-forma figures as per Yahoo Finance are used
5) Analyst estimates as per Yahoo Finance are used
6) Future earnings estimates seem to be discounting a hefty recovery except for semi equips |
