Use stock data fromtidyquantpackage to answer this question.

Create 5 new portfolios with the following weights

Portfolio 1 2 3 4 5

AMZN 0.25 0.4 0.1 0.20.5

VMW 0.25 0.2 0.5 0.10.1

MSFT 0.25 0.3 0.2 0.40.3

AMD 0.25 0.1 0.2 0.30.1

The baseline stock for this portfolio is S&P 500 (^GSPC). Use stock data from January 1, 2010 till January 1, 2021. Use monthly returns.

Which portfolio has the highest beta?

A. Portfolio 3

B. Portfolio 1

C. Portfolio 4

D. Portfolio 5