Can I get the data table used for below? Somehow I could not find the data match the answer thus could not experiment to learn. Pls advice.

QUESTION 3 (25 MARKS) a) Download the monthly stock price for the Inari Berhad and Hibiscus Berhad, together with FBM KLCI for the last 3 years. For each stock, calculate: i) Average yearly rate of return ii) Standard deviation iii) Beta (15 marks) b) Assume a portfolio of the two selected stocks with Inari (60%) and Hibiscus Berhad (40%), recommend your finding based on i) Portfolio return ii) Portfolio risk. (10 marks)

a. i.

Inari Berhad: 3-year average return = (3.35-1.62)/1.62 * 100% = 107.91%

Hibiscus Berhad: 3-year average return = (2.68-1.40)/1.40 * 100% = 90.57%

FBM KLCI: 3-year average return = (1770.73-1648.07)/1648.07 * 100% = 7.21%

ii.

Inari Berhad: 3-year standard deviation = sqrt((0.22^2*2 + 0.54^2*1)/3) = 0.41

Hibiscus Berhad: 3-year standard deviation = sqrt((0.30^2*2 + 0.54^2*1)/3) = 0.47

FBM KLCI: 3-year standard deviation = sqrt((129.67^2*2 + 107.03^2*1)/3) = 11.49

iii.

Inari Berhad: 3-year beta = (0.41^2+0.54^2)/(3*11.49^2) = 0.0074

Hibiscus Berhad: 3-year beta = (0.47^2+0.54^2)/(3*11.49^2) = 0.0082

b.

i.

The portfolio return is the weighted average of the individual stock returns:

Portfolio return = (0.6*107.91% + 0.4*90.57%) = 99.72%

ii.

The portfolio risk is the weighted average of the individual stock risks:

Portfolio risk = (0.6*0.41 + 0.4*0.47) = 0.43