Download monthly price data from Dec $31,2013$ to Jan $31,2024$ for the following $5$ stocks and $1$ index. $(30$ points$)$

NFLX

NVDA

PFE

LUV

WMT

$^$RUI

$2.$ For each stock and the Russell $1000$:

Calculate the Average Return, Standard Deviation, Skew, and Kurtosis. $(10$ points$)$

Estimate the Betas $(10$ points$)$

Determine the percentages of systematic risk and nonsystematic risk $(10$ points$)$

Estimate annual E$[$ret$],$ annual Standard Deviation, and Sharpe Ratio $(10$ points$)$

$3.$ Create an equal$-$weighted portfolio of the $5$ stocks:

Repeat Step $2$ for the equal$-$weighted portfolio $(10$ points$)$

$4.$ Use Solver to find the weights for the:

Optimal Portfolio $(5$ points$)$

Global Minimum$-$Variance Portfolio $(5$ points$)$

Record results using Copy $+$ Paste Values $(5$ points$)$

$5.$ Submit your spreadsheet with the Equal weights in place $(5$ points$)$