Please help with Excel Workbook for this Finance problem, Thank you!

1. Consider a portfolio with $21,000 invested in Biogen, Inc. (BIIB) common stock, $71,000 invested in Netflix, Inc. (NFLX) common stock, and $158,000 invested in Regeneron Pharmaceuticals Inc. (REGN) common stock.

a. Use Yahoo! Finance to find monthly adjusted closing prices for each of the stocks in the portfolio and the Standard and Poor's 500 Index (^GSPC) from 07/07/2014 to 07/07/2022 and save them into a single Excel worksheet then calculate monthly holding period returns for the portfolio and the Standard and Poor's 500 Index.

b. Calculate the variance-covariance matrix for this portfolio. Do not include the Standard and Poor's 500 Index in the matrix.

c. What is the portfolio's annual variance of returns? What is its annual standard deviation of returns?

d. Calculate the beta for each individual asset in the portfolio.

e. What is the portfolio's beta?