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 Jan 05, 2002 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 10.75 68.90 1.75 Dec-01 2.09 Jun-03
INTC 6.99 35.79 0.48 Dec-01 0.62 Dec-02
CSCO 4.55 20.83 0.14 Jan-01 0.39 Jul-03
QCOM 4.01 50.41 0.95 Dec-01 1.36 Sep-03
ORCL 2.97 15.45 0.44 Nov-01 0.51 May-03
DELL 2.33 29.59 0.65 Jan-02 0.74 Jan-03
MXIM 2.24 59.35 0.91 Dec-01 1.03 Jun-03
AMGN 2.21 55.62 1.19 Dec-01 1.41 Dec-02
IMNX 1.70 27.65 0.29 Dec-01 0.31 Dec-02
XLNX 1.69 45.71 0.36 Dec-01 0.39 Mar-03
VRTS 1.64 48.21 0.65 Dec-01 0.64 Dec-02
AMAT 1.60 45.22 0.59 Jan-02 1.37 Oct-02
SUNW 1.58 13.93 0.00 Dec-01 0.24 Jun-03
LLTC 1.51 43.51 0.89 Dec-01 0.82 Jun-03
CEFT 1.50 32.22 0.59 Dec-01 0.76 Dec-02
PSFT 1.46 40.08 0.57 Dec-01 0.72 Dec-02
SEBL 1.43 32.70 0.46 Dec-01 0.47 Dec-02
CMCSK 1.34 34.90 -1.28 Dec-01 -1.08 Dec-02
WCOM 1.31 14.61 0.72 Dec-01 0.64 Dec-02
FLEX 1.20 27.03 0.71 Dec-01 0.91 Mar-03
GENZ 1.20 55.29 1.18 Dec-01 1.47 Dec-02
EBAY 1.16 68.50 0.47 Dec-01 0.75 Dec-02
ALTR 1.12 24.70 0.33 Dec-01 0.25 Dec-02
JDSU 1.11 10.02 0.11 Dec-01 0.06 Jun-03
BBBY 1.10 33.81 0.68 Nov-01 0.89 Feb-03
KLAC 1.04 55.49 2.06 Dec-01 1.34 Jun-03
PAYX 1.04 35.61 0.73 Nov-01 0.86 May-03
SANM 1.02 22.15 0.54 Dec-01 1.09 Sep-03
CHIR 0.97 44.72 0.95 Dec-01 1.15 Dec-02
AAPL 0.96 23.69 0.57 Dec-01 0.66 Sep-03
NXTL 0.96 11.30 -2.01 Dec-01 -1.50 Dec-02
NVDA 0.93 69.62 1.01 Jan-02 1.31 Jan-03
GMST 0.92 24.30 -1.25 Dec-01 -1.16 Dec-02
BMET 0.91 29.90 0.87 Nov-01 1.08 May-03
INTU 0.91 40.46 0.91 Jan-01 1.22 Jul-03
MEDI 0.90 46.69 0.69 Dec-01 1.02 Dec-02
SBUX 0.90 22.11 0.49 Dec-01 0.65 Sep-03
COST 0.89 42.13 1.30 Nov-01 1.68 Aug-03
IDPH 0.88 64.77 0.59 Dec-01 0.91 Dec-02
CHKP 0.86 45.37 1.23 Dec-01 1.29 Dec-02
BGEN 0.85 57.42 1.90 Dec-01 1.96 Dec-02
CTAS 0.84 49.32 1.34 Nov-01 1.64 May-03
FISV 0.83 41.85 1.07 Dec-01 1.37 Dec-02
USAI 0.82 27.00 -0.38 Dec-01 -0.52 Dec-02
NTAP 0.78 26.73 0.07 Jan-02 0.20 Apr-03
BRCD 0.76 37.44 0.20 Jan-02 0.53 Oct-03
ERTS 0.70 62.96 0.29 Dec-01 1.42 Mar-03
BRCM 0.67 48.80 -0.33 Dec-01 -0.13 Dec-02
ADBE 0.64 35.90 0.98 Nov-01 1.17 Nov-02
DISH 0.59 28.59 -0.38 Dec-01 0.60 Dec-02
VRSN 0.59 36.31 0.65 Dec-01 1.18 Dec-02
NVLS 0.55 44.79 1.35 Dec-01 0.15 Dec-02
ADLAC 0.53 31.71 -3.06 Dec-01 -4.14 Dec-02
BEAS 0.52 18.85 0.31 Jan-02 0.33 Jan-03
CIEN 0.51 16.47 0.32 Jan-02 0.14 Oct-03
ERICY 0.50 5.83 -0.19 Dec-01 0.03 Dec-02
MLNM 0.48 24.05 -0.53 Dec-01 -0.74 Dec-02
PCAR 0.47 66.66 2.09 Dec-01 2.41 Dec-02
SPLS 0.47 18.44 0.63 Jan-02 0.75 Jan-03
GILD 0.46 61.40 -1.15 Dec-01 -0.06 Dec-02
Weighted average CY01 PE = 62.1
Forward PE (circa Mar-03) = 48.0
Notes:
1) The 60 stocks used in the calculation account for 86.3% 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 again seem to be discounting a hefty recovery
7) Earnings estimates were pretty similar to previous time I updated this table. Prices are higher and the weightings have changed slightly. |
