In past five years, Calculate the average return ( by averaging the percentage c
ID: 2790660 • Letter: I
Question
In past five years,
Calculate the average return ( by averaging the percentage change of stock in previous month) and
the standard deviation of the percentage change ( for risk level) and
the discount model.
The stocks are
1.Sunny Optical Tecnology (Group) Co Ltd. (2382.HK)
2.Asia cement (China) Holdings Corporations (0743.HK)
3.China Eastern Airlines Corp Ltd (SH600115)
4.Western Digital Corp. (WDS.US)
5.Wheelock & Co Ltd HK (0020.HK)
You can download monthly returns data at www.finance.yahoo.com
How to:
Use the price in the "Adj Close" column to compute monthly returns as follows:
Rit = (Adj close t - adj close t1)/Adj close t1
Compute the average monthly return by using the "average function
Compute the standard deviation by using the "stdev" function.
The excel sheets are here:
https://drive.google.com/drive/folders/1xxHhdVXDY3giHBiTVdBDLBMQdlZIZlFo?usp=sharing
Explanation / Answer
The Mean Returns and Standard Deviation of the monthly returns over the past 5 years for the stocks is tabulated below -
Company Name Mean Return (Monthly) Standard Deviation (Monthly) Sunny Optical Tecnology (Group) Co Ltd. 4.90% 11.40% Asia cement (China) Holdings Corporations -0.80% 10.09% China Eastern Airlines Corp Ltd 0.07% 12.54% Western Digital Corp. 1.14% 8.87% Wheelock & Co Ltd HK 0.55% 7.03%