1. Create workbook with multiple worksheets.

a. (5 points) The first sheet should list the names and symbols of the stocks/funds you purchased as well as the purchase price and the number of shares.The purchase price will be the opening price on ____________________.You may use the "1 Month Chart" to trace along the curve and get prices for any days you may have missed.

b. (5 points) Create column for the cost of buying each stock which should include the $9.95 fee to buy the shares for each company.

c. (5 points) Create column for the PE ratio (Price to Earnings) of each Stock by looking up PE ratio in the stock quote.Create column for the earnings per share for each stock, use the purchase price and PE of each stock to compute the earnings per share (do not look up EPS there should be a formula here).

d. (5 points) You are required to spend as much of the $100,000 as possible, being within a few dollars of $100,000 is fine.No one stock may be worth more than $50,000 of the portfolio or less than $2,500.

KEY STATS Day Low 155.75 Day High 156.98 Shares Out 5.2B Beta 1.20 52-Week Low 104.08 52-Week High 164.94 Dividend (TTM) 2.52 Div Amount 0.63 YTD % Chg 35.17 1 Year % Chg 34.61 Div Yield (TTM) 1.61% Ex Div Date 2017-08-10 10D Avg Vol 19.7M Market Cap 806.68 RATIOS/PROFITABILITY(TTM] EPS 8.82 EBITDA 70,206.00 Debt To Equity 81.813 Net Margin 20.87% P/E 17.75 Revenue 223.58 Gross Margin 38.5135 ROE 36.03% MORE