QUESTION 4 The table below shows historical return for the two types of security assets in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
QUESTION 4 The table below shows historical return for the two types of security assets in 5 years period. These two assets are grouped under one portfolio. Years 2016 2017 Return for Stock T (%) 12 10 -4 1 2020 8 Based on the table above : (**for questions a,b,c,d and f show calculation manually**) Return for Stock M (%) 20 -15 2018 2019 19 14 21 a) Calculate the average rate of return for each stock during 5 years period. b) Calculate the average rate of return for each year. c) Calculate the average rate of return for the portfolio. d) Calculate the standard deviation for each stock and portfolio. e) Calculate the correlation. (Shows the calculation in Excel format) f) Calculate beta for each stock. g) If you are a portfolio manager and this is the portfolio that the client want to invest the funds into, explain the areas you use to discuss further about this portfolio. (25 marks) QUESTION 4 The table below shows historical return for the two types of security assets in 5 years period. These two assets are grouped under one portfolio. Years 2016 2017 Return for Stock T (%) 12 10 -4 1 2020 8 Based on the table above : (**for questions a,b,c,d and f show calculation manually**) Return for Stock M (%) 20 -15 2018 2019 19 14 21 a) Calculate the average rate of return for each stock during 5 years period. b) Calculate the average rate of return for each year. c) Calculate the average rate of return for the portfolio. d) Calculate the standard deviation for each stock and portfolio. e) Calculate the correlation. (Shows the calculation in Excel format) f) Calculate beta for each stock. g) If you are a portfolio manager and this is the portfolio that the client want to invest the funds into, explain the areas you use to discuss further about this portfolio. (25 marks)
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided below a Calculate the average rate of return for each stock during 5 years period Stock T Average rate of return for Stock T 12 10 4 1 8 5 112 St... View the full answer
Related Book For
Ethical Obligations and Decision Making in Accounting Text and Cases
ISBN: 978-1259969461
5th edition
Authors: Steven M. Mintz, Roselyn E. Morris
Posted Date:
Students also viewed these finance questions
-
Explain your answers to the following questions about the PSLRA: a. Do you believe the standard for liability under the PSLRA better protects auditors from legal liability than the standards which...
-
suppose Southern Mechanics has different demand forecast as follows: Please develop aggregate plan Forecast 1 2 3 4 5 6 Total 14 150 200 350 400 500/200 1,800
-
Consider the following data 12 14 12 11 14 13 12 812 14 12 11 14 13 12 8 Copy Data Step 2 of 3 Determine the median of the given data
-
Tell whether the given side lengths of a triangle can represent a right triangle. 36, 48, and 60
-
USA Today (October 14, 2002) reported that 36% of adult drivers admit that they often or sometimes talk on a cell phone when driving. This estimate was based on data from a representative sample of...
-
In Problem simplify by writing each expression as a simple or single fraction reduced to lowest terms and without negative exponents. (x- 2) (x + 3)3/2 + (x + 3)-/2 1.
-
Question: Splash is a California corporation that develops resorts. Lawrence, a Splash owner-executive, is hoping to land a $700 million dollar contract with a developing country in Southeast Asia....
-
The following data have been extracted from the records of Riddle Co.: Required: a. Calculate the missing costs. b. Calculate the cost formula for mixed cost using the highlow method. c. Calculate...
-
(Related to Checkpoint 9.3) (Bond valuation relationships) You own a bond that pays $100 in annual interest, with a $1,000 par value. It matures in 20 years. The marker's required yield to maturity...
-
1. Which aspect of the French revolution most disturbed commentators? 2. How would you align each of these writers on a spectrum running from extreme right to extreme left in politics? 3. How would...
-
Members of the board of directors of Safe Zone have received the following operating income data for the year ended May 31, 2018: (Click the icon to view the operating income data.) Members of the...
-
How do structuralist approaches elucidate the underlying systems of signs and symbols that shape cultural meaning and social behavior ?
-
Last Chance Mine (LCM) purchased a coal deposit for $1,667,600. It estimated it would extract 18,950 tons of coal from the deposit. LCM mined the coal and sold it, reporting gross receipts of $1.32...
-
what are the steps to the theoretical orientation in health psychology?
-
Pharoah Inc. has beginning work in process $28,800, direct materials used $268,800, direct labor $246,400, total manufacturing overhead $201,600, and ending work in process $35,200. What are the...
-
1. Explain the differences between fixed and flexible budgets and their relevance in evaluating operational performance. (8 marks) 2. Describe the two main objectives of working capital management?...
-
2-Quiz i 1 Stolton and Bright are partners in a business they started two years ago. The partnership agreement states that Stolton should receive a salary allowance of $11,700 and that Bright should...
-
Could the owner of a business prepare a statement of financial position on 9 December or 23 June or today?
-
Read the following statements made by Warren Buffet in a letter to shareholders included in the Berkshire Hathaway 2017 Annual Report. Should the external auditors have a role in responding to its...
-
Students who engage in cheating usually rationalize their behavior via what? a. Ethical relativism b. Situation ethics c. Cultural values d. Responsibility
-
In the discussion of loyalty in this chapter, a statement is made that your ethical obligation is to report what you have observed to your supervisor and let her take the appropriate action. We point...
-
You will compute the (Fourier) convolution of two box functions of the same width. Recall that the box function is given by \[f_{a}(x)= \begin{cases}1, & |x| \leq a \\ 0, & |x|>a\end{cases}\]...
-
Define the integrals \(I_{n}=\int_{-\infty}^{\infty} x^{2 n} e^{-x^{2}} d x\). Noting that \(I_{0}=\sqrt{\pi}\), a. Find a recursive relation between \(I_{n}\) and \(I_{n-1}\). b. Use this relation...
-
Find the Laplace transform of the following functions: a. \(f(t)=9 t^{2}-7\). b. \(f(t)=e^{5 t-3}\). c. \(f(t)=\cos 7 t\) d. \(f(t)=e^{4 t} \sin 2 t\). e. \(f(t)=e^{2 t}(t+\cosh t)\). f. \(f(t)=t^{2}...
Study smarter with the SolutionInn App