31-Jan-11	-2.2%	-2.1%	0.5%
28-Feb-11	2.8%	0.1%	0.4%
31-Mar-11	0.5%	0.5%	0.5%
30-Apr-11	2.2%	2.3%	0.4%
31-May-11	-0.8%	1.4%	0.5%
30-Jun-11	-2.0%	0.2%	0.5%
31-Jul-11	-2.0%	1.5%	0.4%
31-Aug-11	-0.3%	3.5%	0.5%
30-Sep-11	-3.6%	-2.1%	0.5%
31-Oct-11	9.3%	2.8%	0.5%
30-Nov-11	1.6%	0.0%	0.5%
31-Dec-11	-2.4%	0.7%	0.5%
31-Jan-12	5.7%	2.1%	0.5%
29-Feb-12	1.7%	0.2%	0.4%
31-Mar-12	-1.4%	0.1%	0.5%
30-Apr-12	2.8%	1.8%	0.5%
31-May-12	-3.6%	0.0%	0.5%
30-Jun-12	1.9%	3.3%	0.4%
31-Jul-12	2.7%	4.0%	0.5%
31-Aug-12	2.7%	0.1%	0.5%
30-Sep-12	1.6%	0.9%	0.4%
31-Oct-12	4.2%	-0.6%	0.5%
30-Nov-12	2.6%	0.9%	0.4%
31-Dec-12	3.2%	2.3%	0.4%
31-Jan-13	3.2%	0.1%	0.4%
28-Feb-13	-1.9%	0.7%	0.4%
31-Mar-13	1.2%	0.2%	0.4%
30-Apr-13	-2.5%	4.1%	0.5%
31-May-13	8.5%	-4.6%	0.4%
30-Jun-13	-5.7%	-1.5%	0.4%
31-Jul-13	4.4%	-0.7%	0.5%
31-Aug-13	2.6%	-1.3%	0.4%
30-Sep-13	5.1%	3.9%	0.4%
31-Oct-13	3.6%	0.4%	0.4%
30-Nov-13	-1.1%	-1.4%	0.4%
31-Dec-13	3.0%	1.1%	0.5%

Required:

1) Your presentation must show your graph (based on your results using the data provided) in which you clearly indicate the minimum variance portfolio and the optimal portfolio clearly indicate the Capital Market Line. Use standard deviation and beta as your risk statistics ensuring that each are presented in separate graphs.

2) Show your recommended optimal portfolio based on the use of the Beta constraints indicated by the Trustees.

3) Motivate your final proposed optimal portfolio that you believe will best meet the needs of the Fund.

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I tried to solve this question and i got this: formula ( stdv.s (), Average () ). I got stdv.s: 3.33%, 1.89%, 0.03 and Average:1.3%, 0.7%, 0.4%

The following data is provided: Monthly returns which include those for three assets classes for the three-year period to the end of December 2013. The Cape Retirement Fund may only invest in the asset classes for which returns have been provided. The Investment Consultants and Trustees of the Fund have indicated that the risk and return requirements of the Fund indicate that exposures (weights) to the asset classes must, at all times, be constrained as follows: Equities (ALSI) Bonds (ALBI) Cash (STEFI) Minimum 30% 5% 5% Maximum 75% 40% 20% Also, a composite benchmark, against which the fund will be measured, will be constructed according to the following weights to the asset classes: Equities (ALSI) Bonds (ALBI) Cash (STEFI) 30% 10% Total exopsure 100% 60% You and your team) have been appointed as the portfolio manager for the fund and must present your proposal as to how you will construct the investment to ensure an optimal portfolio. The portfolio construction will be based on an asset allocation mix that will apply to the whole period (i.e. one optimal asset allocation must be determined for the three-year period). Since you are aware of the several weaknesses in optimisation models, particularly the potential error maximising, you have decided to generate/simulate at least one thousand different possible allocations to the asset classes (ensuring that the constraints are adhered to) to examine the possible return and risk profiles of the different asset class allocations. The Trustees have insisted that you use Beta (as per the CAPM model) and standard deviation as your risk measures relative to the benchmark portfolio. In addition, they insist that the portfolio Beta (relative to the benchmark portfolio) may not vary by more than 0.30 above or below the Beta of the benchmark portfolio. H | M N P R SA Cash SA Equity SA Bond 75 401 S T U V SA Equity SA Bond SA Cash Rescaled to get 100% Summed SA Cash SA Equity SA Bond 20 Paste special values 5 Upper Bound Lower Bound Summed 30 5 68% 31% 16% 65% 40% 14% 119% 1 55% 34% 12% 100% The following data is provided: Monthly returns which include those for three assets classes for the three-year period to the end of December 2013. The Cape Retirement Fund may only invest in the asset classes for which returns have been provided. The Investment Consultants and Trustees of the Fund have indicated that the risk and return requirements of the Fund indicate that exposures (weights) to the asset classes must, at all times, be constrained as follows: Equities (ALSI) Bonds (ALBI) Cash (STEFI) Minimum 30% 5% 5% Maximum 75% 40% 20% Also, a composite benchmark, against which the fund will be measured, will be constructed according to the following weights to the asset classes: Equities (ALSI) Bonds (ALBI) Cash (STEFI) 30% 10% Total exopsure 100% 60% You and your team) have been appointed as the portfolio manager for the fund and must present your proposal as to how you will construct the investment to ensure an optimal portfolio. The portfolio construction will be based on an asset allocation mix that will apply to the whole period (i.e. one optimal asset allocation must be determined for the three-year period). Since you are aware of the several weaknesses in optimisation models, particularly the potential error maximising, you have decided to generate/simulate at least one thousand different possible allocations to the asset classes (ensuring that the constraints are adhered to) to examine the possible return and risk profiles of the different asset class allocations. The Trustees have insisted that you use Beta (as per the CAPM model) and standard deviation as your risk measures relative to the benchmark portfolio. In addition, they insist that the portfolio Beta (relative to the benchmark portfolio) may not vary by more than 0.30 above or below the Beta of the benchmark portfolio. H | M N P R SA Cash SA Equity SA Bond 75 401 S T U V SA Equity SA Bond SA Cash Rescaled to get 100% Summed SA Cash SA Equity SA Bond 20 Paste special values 5 Upper Bound Lower Bound Summed 30 5 68% 31% 16% 65% 40% 14% 119% 1 55% 34% 12% 100%