CFM Assignment 2

Company: Dicker Data Limited (DDR)

Q1.Collect the data from "Yahoo Finance" and answer the following questions:

b.Calculate the return of share prices and market return (from market price index). Display the calculated returns along with the risk free rate of return (given in a separate excel file) in a table for two sub periods. Calculate and tabulate, (rj - Rf) and (rm - Rf)

c.Calculate the mean, standard deviation, variance and correlation coefficient for and separately (for two sub-period in a table-see next page) and comment on the result.