Asset Allocation Finance Specialist Wanted -- 3

Asset Allocation This project is concerned with investigating the reliability of the mean-variance approach in a practical asset-allocation setting. The data supplied in the Excel spreadsheet covers USD annual stock returns for 21 countries, plus US Bond returns and US Treasury Bill returns. The assignment covers a number of tasks. The data is split into 2 sub-periods: SUB1 covers the years 1950-1982, while SUB2 covers the years 1983-2014. General rules: (i) No short selling or borrowing allowed in the asset allocations, (ii) risk return graphs have portfolio average returns on the vertical axis and portfolio return standard deviation on the horizontal axis. (ii) all report answers are to be provided in the space provided on the sheet named ‘Report’ in the spreadsheet file provided. (Hint: do the calculations required on the relevant sub-period sheets, and then copy what is needed to the ‘Report’ sheet.)