$320$ Assignment $4-$ Efficient Diversification.xlsx

Download

Page

$1$

of $2$

ZOOM

$3.$ Calculate the portfolio return and risk based on the $40/60$ allocation between stock and bond

$4.$ Calculate the return covariance between stock and bond fund

$\backslash$table$[[,,,,$folio,$],[,,$Stocks,$40\%,$Bond,$60\%],[,,$Deviatio,m Mean,,$],[$Scenario$,$Probabil ity,Stocks,Bonds,Product of Dev. $($S$320$ Assignment $4-$ Efficient Diversification.xlsx

Download

Page

$1$

of $2$

ZOOM

$3.$ Calculate the portfolio return and risk based on the $40/60$ allocation between stock and bond

$4.$ Calculate the return covariance between stock and bond fund

$\backslash$table$[[,,,,$folio,$],[,,$Stocks,$40\%,$Bond,$60\%],[,,$Deviatio,m Mean,,$],[$Scenario$,$Probabil ity,Stocks,Bonds,Product of Dev. $($

$($Answer all highlighted portion and elaborate on how to input calculatuon excel sheet. Thanks!$)$