Write the given assignment.

Strategic Asset Allocation (SAA).
For this part, number of words required is about 1000, a word document of IPS, and excel form should be provided.

My group Investment Objectives is Conservative Growth.

Strategic Allocation is based on ETSAC_InvestmentChoiceFlyer.pdf provided by lecturer.

The data has been provided 'AFM -2-2016-assignment data.xlsx'

My lecturer also explain as follows "Please note that I have provided index data in time series over 4 sheets. I have also provided an index for Hedge funds that you can use as a proxy for alternative investments.

Note that some data is in A$ (Australian Bonds and Equities) and the remaining in US$ (International Equities and Hedge funds). Also note that Hedge fund data is provided in returns, while the remaining in prices.

"Assignment Brief:
Your 4-member portfolio management team has recently been hired by the Board of Trustees of the Electricity Industry Superannuation Scheme to provide portfolio advice. The current IPS for the 3 schemes is also provided. The investment objectives (based on the last digit of the sum of the team's student numbers) are allocated to each team as follows:

Each team will also design a new asset allocation using the MV framework that fulfils the specified investment objectives. The asset allocation should look as follows:

Team Activities:
A strong team will be one that has a diversified skill set and knowledge base. Desired knowledge and skills include:

(i) Statistical and econometric background including the ability to manipulate data using Excel,

(ii) Understand the long term characteristics of the two core asset classes: Fixed Income Securities and Equities,

(iii) Ability to create and test a Strategic Asset Allocation (SAA),

(iv) Create an active Equity component and

(v) create an active Fixed Income Securities component. The team should also have the ability to write a report that is both academically and professionally complete.

Requirements:
Section 1: Strategic Asset Allocation (SAA). This section will require the team to create a strategic asset allocation for the investment scheme using historic data provided for the 5 asset classes/Sub-asset classes. The international equities will be provided as three benchmarks: Emerging markets, Developed markets ex US and the US market. The portfolio will be created such that (i) an allocation for each asset class is provided and (ii) the proportion between active and passive proportion for the domestic equity component is determined and (ii) the proportion between active and passive proportion for the Fixed Income Securities component is determined.

Attachment:- ETSAC-InvestmentChoiceFlyer.rar

Attachment:- AFM--2-2016-assignment-data.rar