Reference no: EM132634882

Given below is hypothetical data on two stocks and the market data.

The market data already includes dividends paid during the year.

Stock 1 Stock 2 Market Index

Year Stock Price Dividend Stock Price Dividend (Includes Dividends)

2013: K25.88 K1.73 K73.13 K4.50 17,495.97
2012: 22.13 1.59 78.45 4.35 13,178.55
2011: 24.75 1.50 73.13 4.13 13,019.97
2010: 16.13 1.43 85.88 3.75 9,651.05
2009: 17.06 1.35 90.00 3.38 8,403.42
2008: 11.44 1.28 83.63 3.00 7,058.96

Required:

Calculate the Returns on the three securities for each year (Years, as Rows; Security Names as Columns).

ii. Determine and explain the following for each security by referring to part (i) above:

o The appropriate Annual Average Return
o The Total risk exposure
o The Downside deviation (Semi deviation)
o The relationship between Stock 1 and the market, as well as Stock 2 and the market