Please solve by filling in the orange boxes using the data given. Please solve using excel formulas and show the formulas being used. Question $1$

You want to build a portfolio of the assets on the previous worksheet. However, you devise different strategies for building this portfolio. Each stratgy requires a different allocation of the assets of interest. To begin, fill in the information on each stock

Hint: I have named the ranges of each stock by their ticker

Hint: Use the INDIRECT function in all cells for a more advanced approach

Now deterine the Var$-$Cov Matrix of the $3$ assets above. Please round your results to $5$ decimal places $($please use population statistics when required$).$

Hint: I have called this range varcov

You have decided upon pursuing one of three strategies in building your portfolio. First is an equally weighted strategy, where each stock takes up equal weight in the portfolio. Second is a minimum risk stratgey where minimize overall portfolio risk while only taking long $($buy$)$ positions. The third is a maximum return stratgey where you attempt to maximize the overall return on the portfolio. Given these three stratgies, please find the relative weights of each asset and the risk and return of the resulting portfolio $($Solver would be a useful tool here$).$Equally WeightedMinimize Risk $($Long Only$)$Maximize Return