Malayan Banking Berhad (1155.KL)DateOpenHighLowCloseVolumeJul-228.578.868.558.86103443700Aug-228.879.038.88.97171577000Sep-228.959.038.528.58199409500Oct-228.588.88.418.59167666200Nov-228.68.848.388.63237633600Dec-228.658.798.538.7138060300Jan-238.78.878.648.74157411200Feb-238.748.858.68.8145823100Mar-238.88.818.268.57178908900Apr-238.578.738.558.6697928100May-238.668.788.558.65174045100Jun-238.68.798.558.63135267700Jul-238.658.838.658.861769300Public Bank Berhad (1295.KL)DateOpenHighLowCloseVolumeJul-224.344.694.334.64220264200Aug-224.624.714.574.71300366600Sep-224.644.724.184.23397784800Oct-224.234.524.164.47385517100Nov-224.454.614.254.5466570500Dec-224.54.554.234.32400596200Jan-234.324.344.244.24302933000Feb-234.244.244.14.13336150100Mar-234.134.163.884441680400Apr-234.024.043.883.89208995300May-233.894.033.813.81284428800Jun-233.823.953.783.85314415600Jul-233.864.013.843.99110031000

You are currently working as an analyst at Financial Consulting Bhd. Your supervisor has instructed you to form an equity fund portfolio that consists of TWO (2) banks, namely Maybank Bhd & Public Bank Bhd. The portfolios have a total fund size of RM10 million. Before you can start with your analysis, you have to collect monthly stock prices of each stock in your portfolio over the last 12 months.

You are required to:

(a) Describe the background (operation, management team, market, etc) of the banks

(10 marks)

(b)Compute the monthly stock return of each stock in your portfolio in each of the last 12 months. Show your answers in organized tabular format.

Based on a review of the return data, decide which investment appears to be riskier.

(20 marks)

(c)Compute the average monthly stock return and standard deviation of returns of each stock over the last 12 months.

(30 marks)

(d)Compute covariance and correlation between each possible pair of stocks in your portfolio.

(10 marks)

(e)Compute the portfolios return and standard deviation assuming funds are split equally in each of the two banks stocks.

(10 marks)

(f)Recommend which you will invest stock separately or combine (portfolio) based on the above calculation (part b,c,d, and e).

(10 marks)

(g)You are required to use correct writing skills, including grammar, spelling, sentence structure, citation of references, and sources of information. etc.

(10 marks