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 yo...

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style0 msonumberformatGeneral textaligngeneral verticalalignbottom whitespacenowrap msorotate0 msobackgroundsourceauto msopatt ...

Fill in the spreadsheet below to calculate the portfolio return and risk between Zenon and Dynamics, given

Question:

Fill in the spreadsheet below to calculate the return and risk between Zenon and Dynamics, given the 10 years of annual returns for each stock, and 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 Return Variance Standard Deviation

Fill in the spreadsheet below to calculate the portfolio return

Portfolio
A portfolio is a grouping of financial assets such as stocks, bonds, commodities, currencies and cash equivalents, as well as their fund counterparts, including mutual, exchange-traded and closed funds. A portfolio can also consist of non-publicly...