Directions: Update the data with your recommendations for the blue cells, then use Solver to determine the minimum variance portfolio
Desired Annual Portfolio Expected Return
Realized Annual Portfolio Expected Return
Realized Annual Portfolio Expected Standard Deviation
Desired Portfolio Return
Realized Portfolio Return
Choose the index for each asset class, type the name below and paste in the relevant returns.
Choose the dates you think are most relevant for calculating expected returns and risk (use 20 years of data).
Attachment:- Assignment.rar