please Create a document a exel document with 10 different stocks investing $10,000 and each one of them.

on the excel document please state

The opening and closing price

and the amount invested,

the value and the realize return.

(doesnt have to be accurate)

You have $100,000 to invest in ten stocks, $10,000 in each (no mutual funds). You may not alter your selections during the semester, and cash is not an option. (Sorry; the purpose of this assignment is not to teach trading. Additional material will be added as the semester progresses.) Select an Internet source and set up a watch account. Possible websites with information on companies include the following:

I need help finding the realized return and the value of each stock. In the screenshot it shows how much I invested the opening price in the closing price of each stock

1. t found beta coefficients for each stock from Yahoo Finance. The portfolio beta coefficient based on 5-year beta coefficients oblained from Yahoo finance ia: 1.2(0.1)+1.63(0.1)+0.18(0.1)+1(0.1)+1.14(0.1)+1.17(0.1)+0.75(0.1)+1.38(0.1)+1.98(0.1)+1.19(0.1)=1.16 2. A portfolio beta coefficient of 1.16 indicates that the portfolio is slightly more volatile than the market. and wil earn slightly higher returns than the market during market increases, and 1. t found beta coefficients for each stock from Yahoo Finance. The portfolio beta coefficient based on 5-year beta coefficients oblained from Yahoo finance ia: 1.2(0.1)+1.63(0.1)+0.18(0.1)+1(0.1)+1.14(0.1)+1.17(0.1)+0.75(0.1)+1.38(0.1)+1.98(0.1)+1.19(0.1)=1.16 2. A portfolio beta coefficient of 1.16 indicates that the portfolio is slightly more volatile than the market. and wil earn slightly higher returns than the market during market increases, and