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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

The following are the returns on the Ontario companys stocks over the past five years: 7%, -12%, 11%, 38%, and 14% a. Calculate the arithmetic average, variance, and standard deviation on these stock...

Q:

1. Dollar Return Four months ago, you purchased 900 shares of LBM stock for $7.68 a share. Last month, you received a dividend payment of $.12 a share. Today, you sold the shares for $9.13 a share....

Q:

Download the data file at this link. The dataset contains the monthly stock prices of Amgen Inc with ticker AMGN and the S&P 500 Index with ticker AGSPC (we refer to the S&P 500 as the market) with...

Q:

1.Today, you sold 200 shares of Indian River Produce stock. Your total return on these shares is 6.2%. You purchased the shares one year ago at a price of $31.10 a share. You have received a total of...

Q:

e. Assume a third stock, Stock C, is available for inclusion in the portfolio. Stock C produced the following returns during the past five years: Year Stock C's Return, o 32.00% -11.75 10.75 32.25...

Q:

4. The Commercial Banking System, the Stock Market, and Credit a. Discuss its structure. For example, some major commercial banks are owned by the government and some are private. None are foreign...

Q:

Need Urgent Help with Question 3 and Question 9 of the attached document - Question 3 needs only ~400 words (also attaching an article which might be needed to answer question-3) My word count for...

Q:

Questions 1-6 on an excel spreadsheet. make sure that details for calculatoons are peovided to be able to follow your thiughts. the page. e Today is April 30, 2015, and you have just started your new...

Q:

Joshi was at a crossroads: should he borrow money to ramp up the growth of the business through new capacity building or see ServiceForce grow through more and more franchises? Evaluate financial...

Q:

Please answer all the parts of the finance case study. Part B: Capital Markets and Pricing Risk- Guided Case Study Today is December 30,2022, and you have just started your new job with a financial...

Q:

Record in T account form the transaction sin SE 5, assuming the periodic inventory system is used.

Q:

Create a cash flow sheet with Initial investment 100,000 resources expense : 5,000 labour cost: 10,000 maintenance cost : 3000 increase 2 warehouses (rental): 15,000 website development: 5,000...

Q:

A firm has a debt - equity ratio of 0 . 4 0 , a pretax cost of debt of 5 % , and an unlevered cost of capital of 1 2 % . What is the cost of equity if the tax rate is 2 2 % ?

Q:

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...