FINC3017 Asset Allocation and Portfolio construction
Report 1
Course Id: FINC3017
1.0 Introduction
The following report seeks make a summary of the maximal weights of a portfolio created from five equity EFTs. The five EFTs are: eFunds Australian Large(ALARGE), ASMALL (eFunds Australian SmallCaps), US100 (eFunds US Top 100), ASIA100 (eFunds Asia (exJapan) Top 100) and eFunds Emerging Markets Top 500 (EM500). Upon creation of the optimal Portfolio for the two investors (Kendall and Morgan), the expected performance for each investor is calculated and necessary advisory offered to the investors. From the provided expected returns and the volatility of the five EFTs, we are expected to calculate the expected utility that each investor will attain upon investing in a single EFT and make recommendations regarding the best Single EFT to invest in. The provided data is also used to calculate the optimum weights for a portfolio which will maximize the utility of the two investors. To come up with optimal risky portfolio, we will use the Markowitz portfolio theory. The transaction costs taxes and the potential fees have not been put into consideration in this case.
The utility function is U=E (R) where A is represents the risk aversion coefficient for the investor. Kendall Lee has a risk aversion coefficient is 6.5 while that of Morgan Numer is 3.5. The expected utility of the two investors is calculated as follows.
Kendall Lee Utility function is = E (R) 
The expected Utility of Kendall (E ()) of the five scenario when he invests on each single EFTs is
ETF 
Kendal Lee Expected Utility 
ALARGE 
0.02591875 
ASMALL 
0.16344325 
US100 
0.071912 
ASIA100 
0.015608 
EM500 
0.215308 
From the calculated expected utility, Kendall Lee chooses the EFT with the optimal utility. US100 (eFunds US Top 100) has the highest expected utility of the five EFTs.
Morgan Numer utility function is = E (R) . The five scenarios in case where the Morgan invests in each EFT presented in the table below. From the expected utility of Morgan, ASMALL (eFunds Australian SmallCaps) has the highest expected utility of 0.106568. If Morgan is to invest in a single EFT, he will have to choose an asset which maximizes the highest expected value. In this case Morgan invests in ASMALL (eFunds Australian SmallCaps).
ETF 
Morgan Numer Expected Utility 
ALARGE 
0.03816175 
ASMALL 
0.106568 
US100 
0.049288 
ASIA100 
0.073012 
EM500 
0 
In modern portfolio theories, creating a mix of highly volatile assets (assets with high standard deviation) and low volatile assets (assets with lower standard deviation) helps to reduce the risk associated with a portfolio. This aspect of creating a combination of assets with different risks in different sectors and geographical areas is called diversification. Diversification of portfolio helps reduce the diversifiable risks and boost the return of an investment.
Based on the importance of diversification it is advisable for Kendall and Morgan to consider it. There is need to construct a portfolio which will generate high returns and help reduce the risks associated with investing in a single EFT. To construct a portfolio with the optimal risk, the Markowitz Portfolio theory is used. Theses portfolio utilizes covariance matrices to create a portfolio.
The Variances and standard deviations of the five EFTs are presented below.
EFT 
Variance 
Stdev 
ALARGE 
0.024025 
0.155 
ASMALL 
0.083521 
0.289 
US100 
0.023104 
0.152 
ASIA100 
0.043264 
0.208 
EM500 
0.094864 
0.308 
From the standard deviation and the correlation matrix a variance covariance matrix can be calculated
0.155 
0 
0 
0 
0 

0 
0.289 
0 
0 
0 

A = 
0 
0 
0.152 
0 
0 
0 
0 
0 
0.208 
0 

0 
0 
0 
0 
0.308 
The correlation matrix is presented below as the Matrix B
1 
0.89 
0.78 
0.73 
0.64 

B = 
0.89 
1 
0.64 
0.65 
0.58 
0.78 
0.64 
1 
0.69 
0.47 

0.73 
0.65 
0.69 
1 
0.85 

0.64 
0.58 
0.47 
0.85 
1 
The variancecovariance matrix is obtained by A*B*A. The varianceCovariance Matrix obtained from the above operation is given below.
0.024025 
0.04 
0.018 
0.024 
0.030554 

C = 
0.039868 
0.084 
0.028 
0.039 
0.051627 
0.018377 
0.028 
0.023 
0.022 
0.022004 

0.023535 
0.039 
0.022 
0.043 
0.054454 

0.030554 
0.052 
0.022 
0.054 
0.094864 
To calculate the portfolio allocation to each asset EFTs using Markowitz theory we will use the excel solver and maximize the Sharpe ratio which on the hand maximizes the utility of each investor.
Kendall Optimum Portfolio
To create this portfolio the following assumption were made.
Under the above conditions the optimal portfolio for Kendall has the following weights.
EFTs 
E (R) 
ALARGE 
0.104 
ASMALL 
0.108 
US100 
0.147 
ASIA100 
0.125 
EM500 
0.093 
The variancecovariance matrix as calculated before is given
The weights are calculated using solver as given below
From the above table the portfolio consists of 40% ,5%,40%,10%,5% for ALARGE,ASMALL,US100,ASIA100 and EM500 respectively. This portfolio is the one that will optimize the Sharpe ratio which also means that the utility of Kendall is maximized. The portfolio mean and standard deviation are calculated using the weight matrix and the EFT expected return matrix.
Portfolio Mean 
0.12295 
Portfolio standard deviation 
0.154735 
Sharpe ratio 
0.794586 
Kendall Utility 
0.045136 
For the weights to be determined, the Sharpe ratio is maximized
For the case of Morgan, the conditions for constructing the optimum portfolio was under the following conditions.
Morgan optimum portfolio is determined below
Morgan optimum portfolio weights are 20%, 10%, 50%, 10% and 10% for the EFTs ALARGE, ASMALL, US100, ASIA100 and EM500 respectively. The portfolio mean, standard deviation and the Sharpe ratio as well as the expected utility of the constructed portfolio are presented below
The recommended portfolio does not necessarily require shot selling. Short selling is a strategy used by traders and portfolio managers to speculate portfolio and investment so as to decide whether to sell or hold a portfolio. Short selling helps to hedge downside risks resulting from holding an asset or portfolio for a long period of time. In the case of the above portfolio and in line with the Kendall’s investment experience, it is not advisable to short sell since it is an optimal portfolio.
The 5ETF portfolio that recommendable to invest in the case of Morgan is.
Weights 

ALARGE 
20% 
ASMALL 
10% 
US100 
50% 
ASIA100 
10% 
EM500 
10% 
The net sector and geography exposure in the optimal portfolio identified for Kendall inQ2
Sector 
Exposure 
Financials 
22.86% 
Materials 
9.77% 
Health Care 
9.96% 
Industrials 
7.79% 
Real Estate 
5.50% 
Consumer Discretionary 
8.56% 
Consumer Staples 
6.17% 
Energy 
4.67% 
Communication 
8.53% 
Information Technology 
13.70% 
Utilities 
2.50% 
The Geographical exposure of Kendall’s optimal portfolio identified in Question 2
Geography(Country) 
Exposure 
Australia 
45.00% 
United States of America 
40.0% 
China 
5.32% 
South Korea 
2.79% 
Hong Kong 
1.89% 
Taiwan 
2.21% 
Singapore 
0.61% 
India 
0.46% 
Brazil 
0.40% 
South Africa 
0.29% 
Russian Federation 
0.23% 
Thailand 
0.17% 
Mexico 
0.13% 
Malaysia 
0.11% 
Indonesia 
0.11% 
Saudi Arabia 
0.07% 
Philippines 
0.06% 
Poland 
0.05% 
Qatar 
0.05% 
Estonia 
0.05% 
Argentina 
0.01% 
If the investors allocates part of the portfolio to cash and Assuming the cash investment is the risk free rate and earn 3.75% p.a and there is no limit to borrowing and lending of the cash.
Weights 
ALARGE 
ASMALL 
US100 
ASIA100 
EM500 

0.183204 
ALARGE 
0.024025 
0.039868 
0.018377 
0.023535 
0.030554 
0.1 
ASMALL 
0.039868 
0.083521 
0.028114 
0.039073 
0.051627 
0.5 
US100 
0.018377 
0.028114 
0.023104 
0.021815 
0.022004 
0.116796 
ASIA100 
0.023535 
0.039073 
0.021815 
0.043264 
0.054454 
0.1 
EM500 
0.030554 
0.051627 
0.022004 
0.054454 
0.094864 
Portfolio Mean 
0.124678 
Portfolio standard deviation 
0.157444 
Risk free rate 
0.0375 
Sharpe ratio 
0.553708 
Kendall Utility 
0.044115 
Weights 
ALARGE 
ASMALL 
US100 
ASIA100 
EM500 

0.183204 
ALARGE 
0.024025 
0.039868 
0.018377 
0.023535 
0.030554 
0.1 
ASMALL 
0.039868 
0.083521 
0.028114 
0.039073 
0.051627 
0.5 
US100 
0.018377 
0.028114 
0.023104 
0.021815 
0.022004 
0.116796 
ASIA100 
0.023535 
0.039073 
0.021815 
0.043264 
0.054454 
0.1 
EM500 
0.030554 
0.051627 
0.022004 
0.054454 
0.094864 
1 
Portfolio Mean 
0.1272527 
Portfolio standard deviation 
0.1633631 
Risk free rate 
0.0375 
Sharpe ratio 
0.5494064 
Morgan Utility 
0.0805496 
1.3 Conclusion
After the calculating the expected utility the two investors would choose only one ETF. This will be based on the optimal utility. The choice of one ETF will pose serious risk to any investor. Choice of one ETL exposes the investor to loss in case of future uncertainties. Moreover, if an ETF is chosen and it performs poorly, it will drain the capital of the investor. To reduce these risks, diversification is called for. To come up with an optimal risk portfolio the Markowitz Portfolio Theory was applied. Diversification of a portfolio implied that the portfolio created was spread through various sectors and a number of geographical areas. The geographical and sector concentration exposure of the portfolio shows the portions of the assets in different sectors and countries. In case of any sector or geography attached risk, it will not affect the whole portfolio. This reduces losses and retains the capital of the investors.
Bibliography
Bodie, Z., Kane, A. and Marcus, A. (2014). Investments. 10th ed. New York: McGrawHill Education.
Brinson, G., Hood, L. and Beebower, G. (1986). Determinants of Portfolio Performance. Financial Analysts Journal, 42(4)
Capaul, C., Rowley, I. and Sharpe, W. (1993). International Value and Growth Stock Returns. Financial Analysts Journal, 49(1)
Davidow, A. (2014). Fundamentally weighted indexing: Weighing the difference. [online] Charles Schwab & Co., Inc. Available at:http://www.schwab.com/public/file/P6353249/Fundamentally_Weighted_Indexing_Weighing_the_Difference_retail.pdf [Accessed 06 Sep. 2019].
Malkiel, B. (2003). Passive Investment Strategies and Efficient Markets. European Financial Management, 9(1), pp.110.
Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak: Sheryl. Read More
Follow Us