Text document along with Excel or other program files used for data analysis, ONLY ONE PAGES OF WRITING. ONLY Look into second presentation data from excel. The report should summarize everything you...

Firstly, we obtained historical data from Yahoo finance for the estimation of the daily return. (Adj. close Period 28-10-2020 to 04-12-2020) After collecting the data, we employed the formula to determine the daily return of each company included in the portfolio.
Formula: (Closing Price-Opening Price) / (Opening Price)
Average return of the portfolio calculation, we have summed up all the daily returns of each company (period 28-10-2020 to 04-12-2020) and with the help of average formula in the excel we computed the average daily return of the portfolio i.e. 0.1164%. For beta calculation we have used slope function, Y axis = Portfolio daily return and for X axis we took S&P daily return. Beta = 0.477, Beta of 0.5 (Approx.) means that the fluctuations of the Portfolio are technically approximately 50 percent of the variations of the index (Less volatile against Benchmark) Daily variance was detected using the Stdev.s Excel formula and values (daily return of the portfolio) i.e. 1.88%.
    Company
    Return
    Apple
    9.94%
    Microsoft
    5.76%
    Amazon
    -0.01%
    Target
    12.77%
    Walmart
    6.33%
    Duke
    0.19%
    Zoom
    -20.54%
    Adobe
    6.35%
    Alphabet
    20.53%
    Shopify
    2.65%
    Next Era
    -2.61%
    Dominion
    -4.91%
    McDonalds
    -1.84%
    Overall
    2.6627%
Formula: (Closing Price-Opening Price) / (Opening Price)
We have been provided $ 10.000.000.00 for the investment, listed above is the overall return on the investment i.e. 2.6627% or Portfolio final value 10,22,010.74.
Index: S&P has given Total Return of 13.09%. (For the Index average daily return and volatility, we followed the same procedure as we did earlier for the calculation of portfolio) As per the above evaluation, we have found that the Index had...