ASSIGNMENT 1 B8F306/05 PORTFOLIO MANAGEMENT Answer ALL questions QUESTION 14 MARKS AD Young worth w esteck ALAM MARTINOURCES (ALAM) and DATAREP HOLDINGS BERHAD DATAP The following return for the stocks of ALAM DATAPRP DATN BBBBBBBBBB 23.75 2635 a) Use Excel to create a spreadsheet that calculates anual portfolio returns for an equally weighted portfolio of ALAM and DATAPRO.Calculate the average annual return for both stocks and the portfolio 17 marks b) Use the table of annual returns for ALAM and DATAPRP to create an Excel spreadsheet that calculates the standard deviation of annual returns for ALAM and DATAPRP using the below information Companies Alocation of Fund DATAPRP RM50,000 Total Allocation RM100,000 RM50,000 1 1 c) Use the table of annual returns in (a) for ALAM and DATAPRP to create an Excel spread the calculates the correlation coefficient for ALAM and DATAPRP (10 marks ASSIGNMENTS 30/OS PORTFOLIO MANAGEMENT the of f or ALAM and DATAPRP terance 11.00, 0.001 10.75, 0.251 10.50 0.50 10.30, 0.70 (1 mark! Calculate the portfolio Mandard deviation avocated with each portfolio composition You will need to use the standard deviations found previously for ALAM and DATAPRP and the correlation coefficient 15 marks Create an ecel spreadsheet the graph the portfolio return and standard deviation combinations found ind for ALAM and DATAPRP's. TOTAL MARKS: 45 MARKS