"""""The assignment is to spend $100,000 on the purchase of these 5 stocks.""""""

1.Purchase your stocks by entering the number of shares you have elected to buy. You must equally diversify among the 5 different stocks, make sure that the weights are close to 20%. This is calculated by the amount of the individual investment divided by the total investment. (all are currently set to 1 so you will need to change this)

2. You must go to Yahoo Finance and locate the sector and the yearly dividend for each stock. Once you have located this information simply enter it into the designated cell in the spreadsheet.

Weight	Ticker Symbol	# of Shares ?	Security Description	Nov. 18th Closing Price	Current Value	Sector ?	Dividend?
18%	HD	1	Home Depot	$ 79.67	$ 79.67
10%	WFC	1	Wells Fargo Company	$ 43.41	$ 43.41
21%	JNJ	1	Johnson & Johnson	$ 94.30	$ 94.30
31%	BA	1	Boeing Corp	$ 138.36	$ 138.36
21%	XOM	1	Exxon Mobile	$ 95.45	$ 95.45
100%		5			$ 451.19