Question 4-6

Yahoo finance

Portfolio A and B:

Returns = Average Return A * Wa + Average Return B * Wb

0086491 *.5 + 0.013975 * .5 = 1.131%

Variance of Portfolio = V_p = W_a² * S_a² + W_b² *S_b² + 2*W_a*W_b* Covariance.P(a, b)

Where W is weight and S = Standard Deviation and square of standard deviation is variance

Portfolio A,B

Variance (A,B) = 0.5² *0.05071² + 0.5² * 0.04872 + 2 * .5 * .5 * 0.000588 = 0.1530%

Standard Deviation = sqrt (variance) = 3.910 %

Similiarly Expected Return, VAriance and Standard Deviation of All portfolios can be calculated =

Need answer for question 4 to question 6.

NEED ANSWER FOR QUESTION 4 5 6.

QUESTION3 PORTFOLIO ANALYSIS (35 Marks) Suppose you are considering an investment in a two-factor portfolio. You wanted to analyse the stock return data for five years from 21t August 2013 to 20th August 2018, of four companies listed on the New Zealand Stock Exchange (www.nzx.com). In any of the possible two-factor portfolio, the weight of each security in the portfolio will be 50%. The possible portfolio combinations are A&B, B&C; A&C; C&D; A&D and B&D Four companies A. B. C. D. Abano Healthcare Group Limited (ABA) Ryman Healthcare Limited (RYM) Briscoe Group Limited (BGP) Hallenstein Glasson Holdings Limited (HLG) Calculate stock returns for the above four companies for the period from 21t August 2013 to 20h August 2018. Stock return can be calculated using the formulae: RA (P: P)/P). To obtain the stock price data, go to or Required 1. Determine, using the appropriate Excel function (see f) the average monthly return, the standard 4 marks) 2. Determine, using the appropriate Excel function the covariance between securities A&B; B&C; A&C (4 marks) deviation, and variance for each of the companies. (Use 60 month returns data and use Excel functions "Variance P" and "Standard Deviation P.") C&D; A&D and B&D. (Use the 60 months returns data and use Excel function "COVARIANCE P.") 3. Using two-factor portfolio equations, calculate the portfolio returns and risks (both standard deviation and variance) for the following portfolios: a. A and B b. B and C c. Aand C d. Cand D e. A and D f. B and D (12 marks) 4. By computing the ratio of () select the best investment that you should undertake, assuming you (4 marks) 5. Draw a portfolio graph (showing Risk on the X-axis and Return on the Y-axis) for the investment are a risk averse investor. Explain the rationale for your choice of investment. portfolio that you have chosen in (4) above for a range of investment weights that you could choose from (ie, You could invest 0% in one company and 100% in the other or 5% in one company and 95% in the other and so on). Determine from the portfolio graph, the minimum risk that you could obtain for this portfolio and the respective weightings that should be invested in each of the securities in the portfolio 6 marks) Determine the betas for the four securities by regressing the returns of each of the company on the returns for the S&P/NZx50 Index (close) for the same period. The S&P/NZX50 index data can be obtained from https://finance.yahoo.com/auote/%5EN250history pe%5ENZ50 6. (Regression Calculation: Go to Dota > Data Analysis and choose regression. The compony returns constitute the index returns the X input. Alternatively, the slope" found in fx) also represents Beta. If Dato Analysis does not appear, can add the tool It is available in Excel. Go to File > Options and choose Add-ins and go to Manage, then select click on the drop-down button and select Excel Add-ins, then click on Go. Select Analysis Toolpak and OK.J Explain what the values of the betas (the slope coefficients in the regression) indicate and discuss the factors that might explain the differences in the values of the betas of the four companies