Question 5 (35 points) Assume that you are trying to construct a portfolio of five assets: S&P 500 Index, NASDAQ Composite Index, FTSE 100 Index, BIST 100 Index and cash. We assume that the cash is invested in a money market account whose return is the 1-day federal fund rate. The times series for the "Total Return" are given for each asset between 1988 and 2022. You have to submit the excel file showing all the calculations for this question. Year FTSE 100 NASDAQ S&P 500 BIST 100 381.40 1988 1793.10 1989 2422.70 454.80 1990 2143.50 373.80 1991 2493.10 586.34 1992 2846.50 676.95 1993 3418.42 776.80 1994 3065.54 751.96 1052.13 1995 3689.26 1996 4118.51 1291.03 277.72 3.96 353.4 15.42 330.22 35.79 417.09 44.16 435.71 38.83 466.45 188.84 459.27 284.27 615.93 393.37 740.74 921.34 h MM 100.00 108.45 116.38 121.53 125.08 128.78 135.80 143.41 150.99

Assume that you are trying to construct a portfolio of five assets: S\&P 500 Index, NASDAQ Composite Index, FTSE 100 Index, BIST 100 Index and cash. We assume that the cash is invested in a money market account whose return is the 1-day federal fund rate. The times series for the "Total Return" are given for each asset between 1988 and 2022. You have to submit the excel file showing all the calculations for this question. (a) (5 points) Use the geometric mean of the yearly returns to estimate the expected yearly return for each asset. (b) (5 points) Determine the covariance matrix between the yearly returns of these four assets. (c) (25 points) Construct a portfolio consisting of these five assets using Markowitz's MeanVariance model. Solve the model for values of r between 4% and 30% (with increments of 2% ) to draw the efficient frontier. Also provide the composition of the portfolio for each r value. (Assume that short-selling is not allowed) Assume that you are trying to construct a portfolio of five assets: S\&P 500 Index, NASDAQ Composite Index, FTSE 100 Index, BIST 100 Index and cash. We assume that the cash is invested in a money market account whose return is the 1-day federal fund rate. The times series for the "Total Return" are given for each asset between 1988 and 2022. You have to submit the excel file showing all the calculations for this question. (a) (5 points) Use the geometric mean of the yearly returns to estimate the expected yearly return for each asset. (b) (5 points) Determine the covariance matrix between the yearly returns of these four assets. (c) (25 points) Construct a portfolio consisting of these five assets using Markowitz's MeanVariance model. Solve the model for values of r between 4% and 30% (with increments of 2% ) to draw the efficient frontier. Also provide the composition of the portfolio for each r value. (Assume that short-selling is not allowed)