Question: code : 0QNK , ONZT , OLG5 QUESTION 1 Calculate the average annual returns (AAR), the standard deviation (SD) of the annual returns and the

code : 0QNK , ONZT , OLG5

QUESTION 1 Calculate the average annual returns (AAR), the standard deviation (SD) of the annual returns and the coefficient of variations (CV) for Stocks A, B, C for the period of 2016 to 2020. (Calculations must be done manually. Show all workings) (15 marks) QUESTION 2 Calculate the correlation coefficient between the daily returns of the stocks below using excel spreadsheet: (a) Stock A and Stock B (b) Stock A and Stock C (c) Stock B and Stock C (6 marks) QUESTION 1 Calculate the average annual returns (AAR), the standard deviation (SD) of the annual returns and the coefficient of variations (CV) for Stocks A, B, C for the period of 2016 to 2020. (Calculations must be done manually. Show all workings) (15 marks) QUESTION 2 Calculate the correlation coefficient between the daily returns of the stocks below using excel spreadsheet: (a) Stock A and Stock B (b) Stock A and Stock C (c) Stock B and Stock C (6 marks)

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!

Question 2 a)Using the formula given below, calculate the annual returns and standard deviation of annual returns for the following portfolios (Calculations must be done manually. Show all workings)...

AAR for Stock A: -0.0735 AAR for Stock B: 0.0799 SDP for Stock A: 0.2084 SDP for Stock B; 0.6376 a) Using the formula given below, calculate the annual returns and standard deviation of annual...

Below are the link of the Stock A & B that choosen. From the Stock A & B, please help me to answer below question from year 2013-2017. Prudential -...

From the first question that been answered. Please help to answer second question Thank you Prdential SD = 30.45% Tesco SD = 32.46% Explanation: Prudential Plc. Annual Return (R), Average Annual...

Total Return of stock A -2.71334 Total Return of Stock B -2.92913 Question 2 a)Using the formula given below, calculate the annual returns and standard deviation of annual returns for the following...

Question: The work below is not the work of a tutor. I am submitting these problems for the first time. The work is my own. It is just me, the problems, and my text book. The work that I have...

please help me answer question by excel 1. Each team member will pick a company to analyze. That way, teams with 5 members will be working with portfolios of 5 different stocks, and teams with 4...

question 5 only. please show all work and formula used. please don't use excel to solve. 1. What are the two sources of investment returns? Which kinds of investment returns have potential tax...

The stock of Foundations of Finance Inc. trades at $40 a share. Its end-of-year price and dividend will depend on the state of the economy by the end of the year as follows: Stock price $50 Dividend...

MJK LTD is a manufacturing entity that produces and sells a single product called jumpa. Below are the details relating to one unit of Jumpa; Direct Materials; X- 4kgs at K25 / kg Y- 5 litres at K20/...

In thick-walled cylinder, the radial displacement of the surfaces makes use of the equation = Explain this equation and show how the equation is derived (2 marks) A thick-walled concrete drainpipe...

Under the _ _ _ _ _ _ _ , sellers must ship orders within the time promised in their advertisements. If no time period is promised, sellers must either ship the order within 3 0 days or send the...

Relevant information and assumptions: The DecorIdeas Company manufactures hand-crafted natural wood display cupboards. Currently the company makes only one size of display cupboard, which is 60-inch...

4. How comfortable are you with introducing yourself to people? What kind of impression do you think you give others? (You may want to check your self-assessment by asking a trusted source what kind...

5. Under what circumstances is introducing yourself to someone you dont know a good idea? When is introducing yourself not such a good idea?

5. What can you learn from this person that will help you to gain power and use it constructively for your own benefit and for the organizations benefit? (In some cases, this might involve learning...