finance essay! 2 pages!

profileoptimus
finance_table_2.xlsx

Sheet1

Bu701
stock symbol original # of share (08/31/16) original purchase price current price(12/8/16) percent change purchase market value current market value percent change percent dividend yield
Apple Inc. AAPL 1100 $111.59 $112.12 0.47% $122,749.00 $123,332.00 0.47% 1.99%
Pandora Media Inc P 2000 $13.98 $13.84 -1.00% $27,960.00 $27,680.00 -1.00%
Wal-Mart Stores Inc. WMT 200 $72.21 $71.23 -1.36% $14,442.00 $14,246.00 -1.36% 2.84
Carnival Corp. CCL 1000 $47.86 $52.93 10.59% $47,860.00 $52,930.00 10.59% 2.55%
FaceBook Inc FB 100 $127.42 $118.91 -6.68% $12,742.00 $11,891.00 -6.68%
JD.com Inc. JD 500 $26.53 $26.97 1.66% $13,265.00 $13,485.00 1.66%
Amazon.com,inc AMZN 650 $831.38 $767.17 -7.72% $540,397.00 $498,660.50 -7.72%
Nike Inc NKE 500 $54.78 $51.56 -5.88% $27,390.00 $25,780.00 -5.88% 1.25%
Costco Wholesale Corp. COST 500 $152.11 $157.59 3.60% $76,055.00 $78,795.00 3.60% 1.11%
eBay Inc. EBAY 200 $32.36 $29.42 -9.09% $6,472.00 $5,884.00 -9.09%
Finish Line Inc. FINL 10 $23.89 $24.36 1.97% $238.90 $243.60 1.97% 1.65%
Alphabet Inc. GOOGL 100 $803.25 $795.17 -1.01% $80,325.00 $79,517.00 -1.01%
Celgene Corp. CELG 100 $107.90 $113.06 4.78% $10,790.00 $11,306.00 4.78%
Summit Therapeutics PLC ADR SMMT 50 $17.23 $9.98 -42.08% $861.50 $499.00 -42.08%
total purchase $981,547.40 $944,249.10 -3.80% ..
cash 18,452.60 18452.6 0.00%
total portfolio $1,000,000.00 $962,701.70 -3.73%
S&P 500 date 981547.4/2,170.95=452.13
31-Aug 8-Dec 452.13*2,246.19=1,015,569.88
2,170.95 2,246.19
1,015,569.88-944,249.10=71,320.78
portfolio underperformed by $71,320.78

Sheet2

Sheet3