# Portfolio Mangaemnet Skills

Autor: bshl7  •  August 11, 2017  •  Coursework  •  1,975 Words (8 Pages)  •  131 Views

Page 1 of 8

[pic 1]

 Chenglin Gao B533267 Hancheng Li B629233 Man Zhao B617170 Wen Zhang B533051

Introduction

This assignment will contain full analysis of the nine underlying security assets as forming a portfolio with FTSE 100 Index. Securities are analyzed and compared of the historical data from 2006 to 2012 by descriptive statistic tools. The second and third part use Markowitz procedure and Single index model to simulate portfolio in order to achieve the optimal risky portfolio. In addition, the final part summarizes the major findings through the two methods to simulate the portfolio and illustrate their implications for investors.

Normal Distribution Analysis

The descriptive statistics include mean, standard deviation, minimum and maximum return, skewness and kurtosis, which are derived by using Eviews. The variety statistics analysis tools can have corresponding meanings on investment. In portfolio analysis, mean is used to measure the expected return of individual assets or portfolio. The average return of FTSE100 is 0.0655% during the 6 years since 2006. Finance sector and tobacco had the lowest and highest figure that were -1.3932% and 1.1781% respectively.

Standard deviation (SD) is another basic mathematics measurement to quantify the risk of assets. The finance company possesses the highest SD that is 9.30 and the largest difference between the maximum and minimum returns. On the contrary, the SD of Utilities reaches 3.36, which indicates that the return of finance has the largest fluctuation among the nine securities. Utilities security has the lowest volatility during those years. According to Table 1, most of the securities have lower expected return and higher volatility than that of FTSE100.

Table 1. Descriptive Analysis

[pic 2]

From investment perspective, it is difficult to find a company whose return is perfectly consistent to normally distribution. Skewness and Kurtosis are common indicators to describe the normality of distribution. Skewness estimates the asymmetry of the probability distribution (Abramowitz, 1972). All the securities have the negative skewness, which indicates that they are asymmetry distribute. As for Kurtosis, it measures the "tailed-ness" of the probability distribution of a real-valued random variable, the test results also need to be compared with normal distribution. Besides, outliers can also be seen from the kurtosis figure. Except tobacco security, the rest have extreme outliers returns (kurtosis > 3.0). The abnormal fluctuation of securities and time-series of data sets could be the reason to drive the abnormal kurtosis.

Time-series of security returns often demonstrate volatility clustering. As noted by Mandelbrot (1963), "large changes tend to be followed by large changes”. In terms of the nine securities, there has a very high changing of volatility period around 2008, because the financial crisis around this period (Appendix 1). Through observation of the plot, the high volatility fluctuation of the return seems to start from a declining. The finance security shows a very high changing of volatilities. It means that the huge fluctuation of the security price lead to big uncertainty for investors.

As mentioned before, most of the securities are showing fat tail distribution in varies degrees. Normally, the ‘fatter’ the tail, the higher probability to receive extreme values, such as, the media and retailer security. And the utilities and tobacco security has a high level of fitness to normal distribution (Appendix 2). Through observations, the nine securities have various levels of return and SD. Hence, they could be used to form a portfolio by adjusting weight.

Mean Variance Optimization Model

In this case, the portfolio formed by 10 risky assets in different sectors. Portfolio manager uses the diversification strategies to diversify the systematic risk into a basket of securities. The long-constraint and long-short efficient frontier diagram can plot by Markowitz procedure. Furthermore, the optimal portfolio determines by excel solver to maximize the Sharp ratio.

In order to complete the preparatory work, using excel data analysis receiving the covariance matrix by monthly data excessed return sets of the 9 securities and FTSE 100 market index. Fill the covariance matrix with the symmetry, the result of covariance matrix is shown in Table 2. Noted that the monthly risk-free rate applies for 0.0067%[1], that is according to the 5 years UK Gilts yield.

Table 2. Covariance-Variance Matrix

 FTSE100 ELECTRICITY FINANCE LIFEINS MEDIA RETAILER TELECOM UTILITIES FOOD TOBACCO FTSE100 18.4700 7.1802 32.8560 27.9528 16.7117 16.1311 12.4063 8.4053 5.8703 6.3073 ELECTRICITY 7.1802 11.4863 11.2143 11.1426 4.8208 4.3900 4.3330 9.4076 4.1401 3.2425 FINANCE 32.8560 11.2143 85.5252 61.5216 33.5907 31.2206 19.8268 13.2475 3.9770 6.7105 LIFEINS 27.9528 11.1426 61.5216 58.7729 29.2892 24.4039 19.2438 12.8958 7.0607 10.7999 MEDIA 16.7117 4.8208 33.5907 29.2892 30.5312 20.9697 12.9105 6.0690 1.5981 4.7674 RETAILER 16.1311 4.3900 31.2206 24.4039 20.9697 36.6418 10.7546 5.2652 7.9749 2.8424 TELECOM 12.4063 4.3330 19.8268 19.2438 12.9105 10.7546 22.5209 6.1333 6.4597 4.0086 UTILITIES 8.4053 9.4076 13.2475 12.8958 6.0690 5.2652 6.1333 11.1517 5.7520 5.3070 FOOD 5.8703 4.1401 3.9770 7.0607 1.5981 7.9749 6.4597 5.7520 40.2982 17.0759 TOBACCO 6.3073 3.2425 6.7105 10.7999 4.7674 2.8424 4.0086 5.3070 17.0759 22.7690

For plotting portfolio’s efficient frontier, excel solver uses as the tool estimating the standard deviation. Sharpe ratio and weight of each security within the portfolio estimated by designed excessed returns (Table 3 and Table 4). The exact minimum variance point cannot be direct acquired by excel solver. The real MVP point can be estimated around someone numbers.

...

Download as:   txt (21.7 Kb)   pdf (1.1 Mb)   docx (1.2 Mb)
Continue for 7 more pages »
Only available on AllBestEssays.com