Spreadsheet: 39483d1237683324-sumproduct-function-project-book
Sheet: Sheet1

No. | Symbol | Company | Industry Segment | Number of Shares Purchased | Date of Purchase | Purchase Price (per share) | Total Commission paid | Total Cost (including commission) | Price per share (incl commission) | Current Market Price of the Stock | Current Total Market Value of Stock | Percentage of Total Portfolio | Holding Period (Years) | Annualized Gain (loss) percent | Market Capitalization (Millions of $) | Market Cap Classification | EPS | P/E Ratio
3 | ABT | Abbott Laboratories (ABT) | Drugs | 56 | 2004-05-18 00:00:00 | 40.23 | 18.99 | 2271.63 | 40.56482142857142 | 47.53 | 2661.68 | 0.03203655157638302 | 4.844444444444444 | 32.03928754115719 |  |  | 3.13 | 16
4 | AURD | Accuride Corporation | Auto | 80 | 2005-11-14 00:00:00 | 13.96 | 19.95 | 1135.55 | 14.194375 | 0.25 | 20 | 0.0002407242912475055 | 3.355555555555556 |  |  |  | -9.22 | 0
5 | ADM | Archer Daniels Midland Company | Foods | 90 | 2006-05-24 00:00:00 | 30.76 | 20.35 | 2787.15 | 30.96833333333333 | 28.14 | 2532.6 | 0.03048291700067162 | 2.827777777777778 |  |  |  | 3.92 | 7.3
11 | AMD | Advanced Micro Devices, Inc. | Computers | 100 | 2001-06-01 00:00:00 | 29.6 | 20.75 | 2978.75 | 29.7875 | 2.96 | 296 | 0.003562719510463081 | 7.808333333333334 |  |  |  | -5.1 | 0
12 | AOB | American Oriental Bioengineering, Inc. | Drugs | 55 | 2006-01-13 00:00:00 | 7.03 | 18.95 | 405.4 | 7.370909090909092 | 4.03 | 221.65 | 0.00266782695775048 | 3.191666666666667 |  |  |  | 0.61 | 6.9
13 | ABII | APP Pharmaceuticals, Inc. (ABII) | Drugs | 142 | 2004-05-18 00:00:00 | 7.84 | 22.43 | 1132.03 | 7.972042253521127 | 48.24 | 6850.08 | 0.08244903264943562 | 4.844444444444444 |  |  |  | -6.91 | 0
14 | ARM | ArvinMeritor Inc. (ARM) | Auto | 120 | 2006-02-14 00:00:00 | 8.78 | 21.55 | 1072.35 | 8.93625 | 1 | 120 | 0.001444345747485033 | 3.105555555555556 |  |  |  | -14.95 | 0
15 | ATAC | Aftermarket Technology Corp. (ATAC) | Auto | 50 | 2006-10-19 00:00:00 | 25.56 | 18.75 | 1296.75 | 25.935 | 9.8 | 490.0000000000001 | 0.005897745135563885 | 2.425 |  |  |  | -1.36 | 0
17 | AZN | AstraZeneca plc (AZN) | Drugs | 89 | 2005-05-12 00:00:00 | 24.12 | 20.31 | 2165.43 | 24.33067415730337 | 32.79 | 2918.31 | 0.03512540531952538 | 3.861111111111111 |  |  |  | 4.2 | 8
27 | BWA | BorgWarner Inc. (BWA) | Auto | 110 | 2005-09-11 00:00:00 | 37.84 | 21.15 | 4181.150000000001 | 38.01045454545455 | 19.85 | 2183.5 | 0.02628107449694641 | 3.530555555555555 |  |  |  | -0.34 | 0
30 | BCAHY | Brilliance China Automotive Hldg. (BCAHY) | Auto | 90 | 2006-03-10 00:00:00 | 26.25 | 20.35 | 2381.25 | 26.45833333333333 | 5.05 | 454.5 | 0.005470459518599561 | 3.033333333333333 |  |  |  | 1.25 | 4.2
33 | CMDXF | Computer Modelling Group Ltd. | Computers | 30 | 2005-03-15 00:00:00 | 12.91 | 18.75 | 406.05 | 13.535 | 7.46 | 223.8 | 0.002693704819059587 | 4.019444444444445 |  |  |  | 0.63 | 11.7
36 | CPB | Campbell Soup Company | Foods | 55 | 2006-01-30 00:00:00 | 23.03 | 18.95 | 1285.4 | 23.37090909090909 | 26.36 | 1449.8 | 0.01745010387253167 | 3.144444444444444 |  |  |  | 2.99 | 15.6
40 | CVR | Chicago Rivet & Machine Co. (CVR) | Auto | 45 | 2005-12-20 00:00:00 | 32.74 | 18.75 | 1492.05 | 33.15666666666667 | 12.5 | 562.5 | 0.006770370691336091 | 3.255555555555556 |  |  |  | -0.13 | 0
44 | DAI | Daimler AG (DAI) | Auto | 50 | 2002-12-06 00:00:00 | 33.85 | 18.75 | 1711.25 | 34.225 | 29.53 | 1476.5 | 0.01777147080134709 | 6.294444444444444 |  |  |  | 1.77 | 13
45 | DDS | Dillard's, Inc. | Retail | 65 | 2005-05-28 00:00:00 | 21.67 | 19.35 | 1427.3 | 21.95846153846154 | 5.47 | 355.55 | 0.004279476087652528 | 3.816666666666667 |  |  |  | -3.27 | 0
53 | F | Ford Motor Co. (F) | Auto | 90 | 2005-12-20 00:00:00 | 24.74 | 20.35 | 2245.35 | 24.94833333333333 | 2.51 | 225.9 | 0.002718980869640574 | 3.255555555555556 |  |  |  | -6.39 | 0
55 | M | Macy's Inc | Retail | 90 | 2005-04-09 00:00:00 | 40.56 | 20.35 | 3669.15 | 40.76833333333333 | 8.76 | 788.4 | 0.009489351560976666 | 3.952777777777778 |  |  |  | 0.66 | 13.7
60 | FSYS | Fuel Systems Solutions, Inc. (FSYS) | Auto | 35 | 2005-09-08 00:00:00 | 8.31 | 18.75 | 309.6 | 8.845714285714287 | 11.29 | 395.15 | 0.004756110184322589 | 3.538888888888889 |  |  |  | 1.48 | 7.4
63 | GIS | General Mills | Foods | 35 | 2001-08-31 00:00:00 | 44.34 | 18.75 | 1570.65 | 44.87571428571429 | 47.29 | 1655.15 | 0.01992174053291543 | 7.561111111111111 |  |  |  | 3.26 | 14.6
64 | GM | General Motors Corporation (GM) | Auto | 75 | 2005-09-11 00:00:00 | 35.74 | 19.75 | 2699.25 | 35.99 | 2.87 | 215.25 | 0.002590795184551278 | 3.530555555555555 |  |  |  | -54.58 | 0
67 | GNTX | Gentex Corp. (GNTX) | Auto | 40 | 2004-06-11 00:00:00 | 12.74 | 18.75 | 528.35 | 13.20875 | 9.39 | 375.6 | 0.004520802189628153 | 4.780555555555556 |  |  |  | 0.43 | 21
70 | GSK | [NAME] plc (GSK) | Drugs | 20 | 2002-05-15 00:00:00 | 48.1 | 18.75 | 980.75 | 49.0375 | 29 | 580 | 0.006981004446177659 | 6.852777777777778 |  |  |  | 2.43 | 12.1
74 | HAYZ | Hayes Lemmerz International In (HAYZ) | Auto | 40 | 2006-02-06 00:00:00 | 8.74 | 18.75 | 368.35 | 9.20875 | 0.13 | 5.2 | 6.258831572435143e-05 | 3.127777777777778 |  |  |  | -1.15 | 0
77 | HMC | Honda Motor Co. Ltd. (HMC) | Auto | 50 | 2005-04-30 00:00:00 | 24.63 | 18.75 | 1250.25 | 25.005 | 23.38 | 1169 | 0.01407033482341669 | 3.894444444444444 |  |  |  | -20.62 | 0
78 | HNZ | H.J. Heinz Company | Foods | 50 | 2002-02-28 00:00:00 | 40.77 | 18.75 | 2057.25 | 41.145 | 33.4 | 1670 | 0.0201004783191667 | 7.061111111111111 |  |  |  | 2.96 | 11.2
81 | HPQ | Hewlett-Packard Company | Computers | 15 | 2006-06-10 00:00:00 | 30.54 | 18.75 | 476.85 | 31.79 | 29.1 | 436.5 | 0.005253807656476808 | 2.783333333333333 |  |  |  | 3.2 | 9.1
85 | IBM | International Business Machines Corp. | Computers | 55 | 2005-11-26 00:00:00 | 98.19 | 18.95 | 5419.2 | 98.53090909090909 | 92.66 | 5096.3 | 0.0613401602742331 | 3.322222222222222 |  |  |  | 8.96 | 10.3
91 | [NAME] | Sun Microsystems, Inc. | Computers | 45 | 2005-08-18 00:00:00 | 10.01 | 18.75 | 469.2 | 10.42666666666667 | 8.63 | 388.35 | 0.004674263925298438 | 3.594444444444445 |  |  |  | -2.45 | 0
92 | JCI | Johnson Controls Inc. (JCI) | Auto | 20 | 2004-06-11 00:00:00 | 34.78 | 18.75 | 714.35 | 35.7175 | 11.34 | 226.8 | 0.002729813462746712 | 4.780555555555556 |  |  |  | 0.21 | 49.6
93 | JCP | J.C. Penney Company, Inc. | Retail | 15 | 2001-08-14 00:00:00 | 26.49 | 18.75 | 416.1 | 27.74 | 17.69 | 265.35 | 0.003193809534126279 | 7.605555555555555 |  |  |  | 2.57 | 7.1
94 | JNJ | Johnson & Johnson (JNJ) | Drugs | 20 | 2005-10-09 00:00:00 | 45.31 | 18.75 | 924.95 | 46.2475 | 50.06 | 1001.2 | 0.01205065801985012 | 3.452777777777778 |  |  |  | 4.56 | 11.1
96 | K | Kellogg Company | Foods | 25 | 2005-09-17 00:00:00 | 67.66 | 18.75 | 1710.25 | 68.41 | 36.67 | 916.75 | 0.01103419970005753 | 3.513888888888889 |  |  |  | 2.98 | 12.4
98 | KFT | Kraft Foods Inc. | Foods | 15 | 2006-08-22 00:00:00 | 26.26 | 18.75 | 412.65 | 27.51 | 22.16 | 332.4 | 0.004000837720533541 | 2.583333333333333 |  |  |  | 1.91 | 18.4
100 | KSS | [NAME]'s Corporation | Retail | 100 | 2006-06-30 00:00:00 | 90.55 | 20.75 | 9073.75 | 90.7375 | 41.17 | 4117 | 0.04955309535329901 | 2.727777777777778 |  |  |  | 2.89 | 14.2
101 | LEA | Lear Corp. (LEA) | Auto | 120 | 2005-06-05 00:00:00 | 18.75 | 21.55 | 2268.75 | 18.90625 | 1.33 | 159.6 | 0.001920979844155094 | 3.797222222222222 |  |  |  | -8.94 | 0
103 | LLY | Eli Lilly & Co. (LLY) | Drugs | 48 | 2008-01-24 00:00:00 | 51.32 | 18.75 | 2482.11 | 51.710625 | 31.83 | 1527.84 | 0.01838941005697944 | 1.161111111111111 |  |  |  | -1.89 | 0
105 | BMY | Bristol-Myers Squibb Co. (BMY) | Drugs | 110 | 2005-05-12 00:00:00 | 14.31 | 21.15 | 1592.85 | 14.48045454545455 | 20.83 | 2291.3 | 0.02757857842677046 | 3.861111111111111 |  |  |  | 2.63 | 13.3
106 | MLR | Miller Industries Inc. (MLR) | Auto | 45 | 2006-05-05 00:00:00 | 17.45 | 18.75 | 804 | 17.86666666666667 | 6.13 | 275.85 | 0.00332018978703122 | 2.880555555555556 |  |  |  | 0.31 | 20.1
107 | MRK | Merck & Co. Inc. (MRK) | Drugs | 68 | 2005-01-19 00:00:00 | 15.74 | 19.47 | 1089.07 | 16.01573529411765 | 26.04 | 1770.72 | 0.02131276584988914 | 4.175 |  |  |  | 3.63 | 7.4
108 | MSFT | Microsoft | Computers | 120 | 2005-04-06 00:00:00 | 23.12 | 21.55 | 2793.15 | 23.27625 | 17.14 | 2056.8 | 0.02475608611189347 | 3.961111111111111 |  |  |  | 1.87 | 9.1
111 | NVGN | Novogen Limited (NVGN) | Drugs | 84 | 2006-04-16 00:00:00 | 12.65 | 20.11 | 1081.35 | 12.87321428571429 | 1.68 | 141.12 | 0.001698550599042398 | 2.933333333333333 |  |  |  | -0.65 | 0
112 | NVS | Novartis AG (NVS) | Drugs | 75 | 2006-04-16 00:00:00 | 17.46 | 19.75 | 1328.25 | 17.71 | 37.79 | 2834.25 | 0.03411364112341211 | 2.933333333333333 |  |  |  | 3.59 | 10.7
114 | OSK | Oshkosh Truck Corporation | Auto | 43 | 2005-10-17 00:00:00 | 49.51 | 18.75 | 2147.68 | 49.94604651162791 | 6.76 | 290.68 | 0.003498686848991244 | 3.430555555555555 |  |  |  | 0.25 | 26.6
115 | PCAR | PACCAR Inc | Auto | 87 | 2005-07-27 00:00:00 | 69.77 | 20.23 | 6088.74 | 69.98551724137931 | 26.03 | 2264.61 | 0.02725733186010067 | 3.652777777777778 |  |  |  | 2.78 | 9.4
116 | PFE | Pfizer Inc. (PFE) | Drugs | 52 | 2005-10-02 00:00:00 | 14.16 | 18.83 | 755.07 | 14.52057692307692 | 13.7 | 712.4 | 0.008574599254236145 | 3.472222222222222 |  |  |  | 1.2 | 12
123 | RACK | Rackable Systems, Inc. | Computers | 64 | 2006-09-25 00:00:00 | 18.08 | 19.31 | 1175.87 | 18.37296875 | 3.92 | 250.88 | 0.003019645509408709 | 2.491666666666667 |  |  |  | -1.84 | 0
126 | SDA | Sadia S.A. (ADR) | Foods | 94 | 2006-03-05 00:00:00 | 23.28 | 20.51 | 2207.07 | 23.47946808510638 | 3.8 | 357.2 | 0.004299335841680447 | 3.047222222222222 |  |  |  | -0.3 | 0
127 | SGMS | Scientific Games Corp. | Computers | 92 | 2007-12-04 00:00:00 | 31.77 | 20.43 | 2941.59 | 31.97380434782609 | 14.75 | 1357 | 0.01633314316114325 | 1.3 |  |  |  | 0.06 | 228.4
129 | SHLD | Sears Holdings Corporation | Retail | 68 | 2005-05-20 00:00:00 | 95.92 | 19.47 | 6541.31 | 96.19573529411765 | 40.09 | 2726.12 | 0.03281216524278249 | 3.838888888888889 |  |  |  | 0.51 | 78.2
130 | BAYRY | Bayer Schering Pharma AG (BAYRY) | Drugs | 65 | 2005-05-31 00:00:00 | 194.3 | 19.35 | 12648.25 | 194.5884615384615 | 46.45 | 3019.25 | 0.03634034081745154 | 3.811111111111111 |  |  |  | 7.97 | 10.9
131 | SKS | Saks Incorporated | Retail | 25 | 2005-11-05 00:00:00 | 25.17 | 18.75 | 648 | 25.92 | 1.69 | 42.25 | 0.0005085300652603553 | 3.380555555555556 |  |  |  | -1.12 | 0
132 | SLE | Sara Lee Corp. | Foods | 45 | 2005-03-30 00:00:00 | 11.52 | 18.75 | 537.15 | 11.93666666666667 | 8.09 | 364.05 | 0.004381783911432719 | 3.977777777777778 |  |  |  | -0.35 | 0
133 | SMP | Standard Motor Products Inc. (SMP) | Auto | 64 | 2005-11-02 00:00:00 | 35.41 | 19.31 | 2284.99 | 35.70296875 | 2.43 | 155.52 | 0.001871872088740603 | 3.388888888888889 |  |  |  | -1.23 | 0
134 | SNY | Sanofi-Aventis (SNY) | Drugs | 86 | 2006-06-08 00:00:00 | 26.78 | 20.19 | 2321.83 | 26.99802325581395 | 27.74 | 2385.64 | 0.02871407490858495 | 2.788888888888889 |  |  |  | 1.93 | 14.7
135 | SORL | SORL Auto Parts, Inc. (SORL) | Auto | 97 | 2005-04-30 00:00:00 | 14.74 | 20.63 | 1448.53 | 14.93329896907217 | 1.7 | 164.9 | 0.001984771781335683 | 3.894444444444444 |  |  |  | 0.71 | 2.3
136 | SPAR | Spartan Motors, Inc. | Auto | 84 | 2006-06-12 00:00:00 | 19.27 | 20.11 | 1637.43 | 19.49321428571429 | 3.95 | 331.8 | 0.003993615991796116 | 2.777777777777778 |  |  |  | 1.32 | 2.9
137 | [NAME] | Sun Microsystems, Inc. | Computers | 92 | 2005-08-18 00:00:00 | 9.1 | 20.43 | 855.9499999999999 | 9.303804347826086 | 8.63 | 793.96 | 0.009556272913943472 | 3.594444444444445 |  |  |  | -2.45 | 0
140 | TEN | Tenneco Inc. (TEN) | Auto | 64 | 2005-12-21 00:00:00 | 35.41 | 19.31 | 2284.99 | 35.70296875 | 2.7 | 172.8 | 0.002079857876378447 | 3.252777777777778 |  |  |  | -8.94 | 0
141 | TM | Toyota Motor Corp. (TM) | Auto | 64 | 2006-10-19 00:00:00 | 74.56 | 19.31 | 4790.59 | 74.85296875 | 62.2 | 3980.8 | 0.04791376292990349 | 2.425 |  |  |  | 4.17 | 15.2
143 | TRW | TRW Automotive Holdings Corp. (TRW) | Auto | 57 | 2005-06-05 00:00:00 | 18.47 | 19.03 | 1071.54 | 18.79894736842105 | 4.38 | 249.66 | 0.003004961327642611 | 3.797222222222222 |  |  |  | -7.72 | 0
146 | UL | Unilever plc (ADR) | Foods | 63 | 2003-03-03 00:00:00 | 35.11 | 19.27 | 2230.68 | 35.40761904761904 | 18.21 | 1147.23 | 0.01380830643239379 | 6.052777777777778 |  |  |  | 2.27 | 8.1
148 | VOLVY | AB Volvo (VOLVY) | Auto | 36 | 2006-05-25 00:00:00 | 56.7 | 18.75 | 2059.95 | 57.22083333333333 | 5.5 | 198 | 0.002383170483350304 | 2.825 |  |  |  | 0.58 | 9
150 | WAG | Walgreens | Retail | 98 | 2003-03-17 00:00:00 | 30.89 | 20.67 | 3045.97 | 31.08132653061225 | 24.05 | 2356.9 | 0.02836815410206228 | 6.013888888888889 |  |  |  | 2.12 | 11.3
154 | WMCO | Williams Controls Inc. (WMCO) | Auto | 69 | 2005-02-12 00:00:00 | 24.76 | 19.51 | 1727.19 | 25.03173913043478 | 5 | 345 | 0.00415249402401947 | 4.111111111111111 |  |  |  | 0.75 | 6.7
155 | WMT | Walmart | Retail | 20 | 2006-04-13 00:00:00 | 27.99 | 18.75 | 578.55 | 28.9275 | 49.95 | 999 | 0.0120241783478129 | 2.941666666666667 |  |  |  | 3.39 | 15
156 | WNC | Wabash National Corporation | Auto | 50 | 2003-10-17 00:00:00 | 18.67 | 18.75 | 952.2500000000001 | 19.045 | 0.66 | 33 | 0.0003971950805583841 | 5.430555555555555 |  |  |  | -4.15 | 0
157 | WYE | [NAME] (WYE) | Drugs | 110 | 2005-10-02 00:00:00 | 14.85 | 21.15 | 1652.25 | 15.02045454545454 | 42.27 | 4649.700000000001 | 0.05596478685067632 | 3.472222222222222 |  |  |  | 3.27 | 13
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | Total Market Value | 83082.6