Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Date SA Equity SA Bond SA Cash31-Mar-00 30-Apr-00 -6.1% -0.5% 0.8%31-May-00 -1.0% 1.3% 0.9%30-Jun-00 5.7% 2.2% 0.8%31-Jul-00 0.8% 3.4% 0.8%31-Aug-00 9.8% 1.8% 0.9%30-Sep-00 -1.9% 1.1%

image text in transcribed
Date SA Equity SA Bond SA Cash31-Mar-00 30-Apr-00 -6.1% -0.5% 0.8%31-May-00 -1.0% 1.3% 0.9%30-Jun-00 5.7% 2.2% 0.8%31-Jul-00 0.8% 3.4% 0.8%31-Aug-00 9.8% 1.8% 0.9%30-Sep-00 -1.9% 1.1% 0.8%31-Oct-00 -1.4% 0.1% 0.9%30-Nov-00 -4.2% 3.2% 0.8%31-Dec-00 6.5% 3.5% 0.9%31-Jan-01 9.5% 2.7% 0.9%28-Feb-01 -0.1% 4.2% 0.8%31-Mar-01 -8.2% -1.7% 0.9%30-Apr-01 10.1% 1.6% 0.7%31-May-01 4.2% 2.1% 1.0%30-Jun-01 -1.6% 5.5% 0.8%31-Jul-01 -6.8% 2.2% 0.9%31-Aug-01 5.4% 0.1% 0.8%30-Sep-01 -9.2% 1.5% 0.7%31-Oct-01 6.1% 2.1% 0.8%30-Nov-01 11.1% 1.7% 0.7%31-Dec-01 11.4% -5.0% 0.8%31-Jan-02 -1.0% -1.7% 0.8%28-Feb-02 5.3% -0.9% 0.7%31-Mar-02 1.9% -2.0% 0.8%30-Apr-02 0.4% 6.2% 0.9%31-May-02 1.8% 2.3% 0.9%30-Jun-02 -4.7% 0.3% 0.9%31-Jul-02 -13.1% 4.2% 1.0%31-Aug-02 5.1% -0.7% 1.0%30-Sep-02 -1.5% 0.1% 0.9%31-Oct-02 -0.6% 1.8% 1.1%30-Nov-02 2.2% 4.8% 1.0%31-Dec-02 -2.8% 0.8% 1.1%31-Jan-03 -5.0% 2.7% 1.1%28-Feb-03 -4.3% 1.1% 1.0%31-Mar-03 -7.9% 0.9% 1.0%30-Apr-03 -1.7% 1.4% 1.1%31-May-03 14.1% 2.8% 1.1%30-Jun-03 -2.2% 2.4% 1.0%31-Jul-03 5.7% 0.1% 1.1%31-Aug-03 5.1% -0.1% 0.9%30-Sep-03 -2.9% 2.7% 1.0%31-Oct-03 9.8% 1.8% 0.9%30-Nov-03 -0.2% 0.8% 0.7%31-Dec-03 6.9% 0.1% 0.8%31-Jan-04 4.6% -1.0% 0.7%29-Feb-04 0.5% 1.0% 0.6%31-Mar-04 -1.4% -0.2% 0.7%30-Apr-04 -2.4% -0.8% 0.6%31-May-04 0.3% 0.1% 0.6%30-Jun-04 -2.7% 1.1% 0.7%31-Jul-04 2.2% 2.0% 0.6%31-Aug-04 8.7% 3.5% 0.7%30-Sep-04 5.7% 1.3% 0.6%31-Oct-04 -0.6% 2.2% 0.6%30-Nov-04 7.3% 2.2% 0.7%31-Dec-04 1.4% 3.1% 0.6%31-Jan-05 1.4% 1.5% 0.6%28-Feb-05 5.5% 2.0% 0.6%31-Mar-05 -0.9% -3.7% 0.7%30-Apr-05 -5.2% 2.1% 0.6%31-May-05 9.8% -0.1% 0.6%30-Jun-05 3.0% 2.7% 0.6%31-Jul-05 7.2% 1.0% 0.5%31-Aug-05 2.1% 0.0% 0.6%30-Sep-05 10.0% 0.1% 0.5%31-Oct-05 -2.4% 0.6% 0.5%30-Nov-05 2.1% 2.4% 0.6%31-Dec-05 8.0% 2.0% 0.6%31-Jan-06 9.2% 1.0% 0.6%28-Feb-06 -3.2% 0.8% 0.5%31-Mar-06 7.1% -0.2% 0.6%30-Apr-06 4.2% 1.2% 0.5%31-May-06 -2.7% -1.1% 0.7%30-Jun-06 3.4% -3.6% 0.6%31-Jul-06 -1.5% 0.7% 0.6%31-Aug-06 5.4% 0.0% 0.6%30-Sep-06 2.3% 1.4% 0.6%31-Oct-06 4.6% 3.1% 0.6%30-Nov-06 2.7% 0.9% 0.6%31-Dec-06 4.2% 1.5% 0.7%31-Jan-07 2.2% 0.7% 0.7%28-Feb-07 1.5% 1.4% 0.6%31-Mar-07 6.4% -0.4% 0.7%30-Apr-07 3.5% 1.5% 0.7%31-May-07 1.7% -1.1% 0.7%30-Jun-07 -1.0% -2.1% 0.7%31-Jul-07 1.0% 0.3% 0.8%31-Aug-07 0.7% 0.7% 0.8%30-Sep-07 5.0% 2.3% 0.7%31-Oct-07 4.8% 1.6% 0.9%30-Nov-07 -3.2% -1.6% 0.8%31-Dec-07 -4.4% 0.9% 0.8%31-Jan-08 -5.6% -0.5% 1.0%29-Feb-08 12.5% -0.8% 0.8%31-Mar-08 -3.0% -0.5% 0.9%30-Apr-08 4.2% -0.7% 0.9%31-May-08 3.7% -2.5% 0.9%30-Jun-08 -4.4% -1.7% 0.9%31-Jul-08 -8.7% 8.5% 1.1%31-Aug-08 0.3% 1.3% 0.9%30-Sep-08 -13.2% 2.4% 1.0%31-Oct-08 -11.6% -0.5% 1.0%30-Nov-08 1.3% 4.6% 0.9%31-Dec-08 1.5% 6.9% 1.0%31-Jan-09 -4.2% -2.4% 0.9%28-Feb-09 -9.9% -2.9% 0.8%31-Mar-09 11.0% 0.0% 0.9%30-Apr-09 1.6% 1.0% 0.8%31-May-09 10.3% -0.4% 0.7%30-Jun-09 -3.1% -0.2% 0.7%31-Jul-09 10.1% 1.3% 0.7%31-Aug-09 3.2% 1.6% 0.7%30-Sep-09 0.2% 0.1% 0.6%31-Oct-09 6.0% -0.2% 0.6%30-Nov-09 2.1% 0.1% 0.6%31-Dec-09 2.9% 1.2% 0.6%31-Jan-10 -3.5% 0.3% 0.6%28-Feb-10 0.4% 2.0% 0.6%31-Mar-10 7.9% 2.1% 0.6%30-Apr-10 -0.1% 1.3% 0.6%31-May-10 -5.1% -0.4% 0.6%30-Jun-10 -3.2% 0.3% 0.6%31-Jul-10 8.0% 4.1% 0.6%31-Aug-10 -3.6% 3.0% 0.6%30-Sep-10 8.7% 0.8% 0.5%31-Oct-10 3.6% 1.0% 0.5%30-Nov-10 -0.5% -2.0% 0.5%31-Dec-10 6.2% 1.7% 0.5%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%31-Jan-14 -2.4% -3.2% 0.4%28-Feb-14 4.9% 2.4% 0.4%31-Mar-14 1.8% 1.8% 0.5%30-Apr-14 2.7% 0.3% 0.5%31-May-14 1.6% 1.2% 0.5%30-Jun-14 2.8% 1.0% 0.5%31-Jul-14 0.9% 1.0% 0.5%31-Aug-14 -0.5% 2.8% 0.5%30-Sep-14 -2.6% -1.6% 0.5%31-Oct-14 1.0% 3.4% 0.5%30-Nov-14 0.5% 2.4% 0.5%31-Dec-14 -0.2% -1.6% 0.5%31-Jan-15 3.1% 6.5% 0.5%28-Feb-15 4.1% -2.8% 0.5%31-Mar-15 -1.3% -0.5% 0.5%30-Apr-15 4.7% -0.5% 0.5%31-May-15 -4.0% -0.7% 0.5%30-Jun-15 -0.8% -0.2% 0.5%31-Jul-15 0.5% 1.0% 0.5%31-Aug-15 -3.6% 0.1% 0.5%30-Sep-15 1.0% -0.1% 0.5%31-Oct-15 7.6% 1.3% 0.5%30-Nov-15 -3.9% -1.0% 0.5%31-Dec-15 -1.7% -6.7% 0.5%31-Jan-16 -3.0% 4.6% 0.5%29-Feb-16 0.6% -0.8% 0.5%

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

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

C) Motivate yourr final proposed optimal portfolio that youu believe will best meet the needs of the Fund.

image text in transcribed
Question: The following data is provided: Monthly returns which include those for three assets classes for the six-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% Maximum 75% 40% 209 Also, a composite benchmark, against which the fund will be measured, will be constructed according to the following weights to the asset classes: Equities Total (ALSO) Bonds (ALBI)| Cash (STEFI) exopsure 60% 30% 10% 100% 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 6-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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Company Valuation Playbook Invest With Confidence

Authors: Charles Sunnucks

1st Edition

1838470816, 978-1838470814

Students also viewed these Finance questions

Question

what is a ethical dilemma that walmart is dealing with ?

Answered: 1 week ago