Fill in the spreadsheet below to calculate the portfolio return and risk between Zenon and Dynamics, given the 10 years of annual returns for each stock, and portfolio weights of 50/50.
a. How would your answer change if the weights were 40 percent for Zenon and 60 percent for Dynamics?
b. How would your answer change if the weights were 30 percent for Zenon and 70 percent for Dynamics?
Zenon Dynamics
"Expected
Return
Variance"
"Standard Deviation
Covariance"
Weight for Zenon 50% Weight for Dynamics 50%
Expected Portfolio Return Portfolio Variance Portfolio Standard Deviation

Lenon Dynamics Dynam Ret 7 7 3 1