Use Excel Sheet $.$ You have $$100,000$ to invest in the stock market. you must choose at least $10$ investments to buy with your $$100,000.$ The purchases can be stocks, ETF $($Exchange traded funds$),$ or mutual funds. At least $1$ investment must be a mutual fund. Being within a few thousand of $$100,000$ is fine. Each purchase must be worth between $$2,500$ and $$50,000$ in the portfolio. The portfolio MUST be diversified, meaning that the investments must come from at least $5$ different industries or sectors in the economy $1.$ List the names of the investments $($Johnson & Johnson, Nike, etc$).2.$ List the ticker symbol for each investment $($Facebook $=$ FB$,$ Fidelity $500$ Index Fund $=$ FXAIX, etc$).3.$ For each share: a$.$ List the number of shares purchased. b$.$ List the purchase price for one share. The purchase price will be the OPENING PRICE on the day that you begin your $10-$day window. $4.$ Include a $$4\mathrm{.}95$ fee for each purchase of stock$/$ETF or a $$19\mathrm{.}99$ fee for each purchase of a mutual fund. This is a flat fee and is constant, whether you buy $100$ shares or $10,000$ shares. $5.$ Create a column and calculate the total cost to purchase each investment. $6.$ If you did not spend all $$100,000,$ include the leftover amount as $$Cash$$ in a separate row and assume it does not earn any interest during the $10$ days. $7.$ Create a column for P$/$E ratio $($Price to Earnings$)$ by looking up the ratio in the stock quote. $8.$ Compute the earnings per share for each stock using the purchase price and P$/$E ratio and enter the earnings in a new column. $9.$ Create columns for the ten business days in this project. $($Label them as Day $1,$ Day $2,$ Day $3,...,$ Day $10.)$ In these columns, you will enter the CLOSING PRICE of the stock for each day. This is the only sheet where you will enter the prices. All other sheets will link to the first sheet. $10.$ Complete $($even if not correct$)$ Checkpoint $1$ on time. $$ Checkpoint $2$: $(45$ points$)$ Due $2/27.$ Create a spreadsheet for each day of this project which is linked to the first worksheet. You will format just one of these and then use the Move or Copy Sheet command to make carbon copies. $11.$ Label the sheet tab for each day $($Day $1,$ Day $2,$ etc$).12.$ Each sheet will include the opening price and the closing price for each security. Note: The opening price on Day $$n$$ is equal to the closing price from Day $$n $1.$ Link these from Sheet $1.13.$ Include a column for each security$$s total price change from the previous day in dollars. $14.$ Include a column for each security$$s relative price change from the previous day in percent. $15.$ Include a column for each security$$s total price change from the ORIGINAL purchase price in dollars. $16.$ Include a column for each security$$s relative price change from the ORIGINAL purchase price in percent. $17.$ Create a column that calculates the total value of each security at the end of that day. $($Combination of closing price and number of shares owned.$)18.$ Calculate the SUM of the column above to get the total portfolio value. $($Be sure to include the cash.$)19.$ Link the total portfolio value cell on each sheet to a table on Sheet $1.20.$ Compute the total percent gain $($or loss$)$ for your entire portfolio value relative to the original cost. Make this cell highly visible by changing the font color and highlighting the cell. $21.$ Complete $($even if not correct$)$ Checkpoint $2$ on time. $$ Checkpoint $322.$ On each daily worksheet, create a nicely labeled pie chart showing all the securities you own and the percentage for each of the total portfolio. $23.$ Insert a LINE GRAPH on the FIRST WORKSHEET that shows the total portfolio value over the $10$ days of this project. $24.$ Complete $($even if not correct$)$ Checkpoint $3$ on time.