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
-
Consider the relation instance COURSE_OFFERED (Course, Teacher, Text) a. Does COURSE_OFFERED possess a multi-valued dependency? If the answer is yes, show how this multi-valued dependency occurs. How...
-
The following is the Balance Sheet of X Co. Ltd. as on 31.12.2015: I. EQUITY AND LIABILITIES (1) Shareholders' Funds: (a) Share Capital (b) Reserves and Surplus -- General Reserve Profit and Loss...
-
The price of a non-dividend paying stock is \($19\) and the price of a three-month European call option on the stock with a strike price of \($20\) is \($1.\) The risk-free rate is 4% per annum. What...
-
Christine Dandra owns a catering company that serves food and beverages at exclusive parties and business functions. Dandras business is seasonal, with a heavy schedule during the summer months and...
-
Sid needs 0.8 meters of canvas material to make a carry-all bag for his wheelchair. If canvas is $11.64 per meter, how much will Sid spend? (Note that $11.64 per meter is the same as $11.64 for one...
-
Consider the information for Evans, Inc. when the company entered bankruptcy proceedings: Account Balance per Books Dr (Cr) Cash $30,500 Accounts receivable 600,000 Inventory 100,000 Prepaid expenses...
-
Based on the table below, the Total Debt to Total Asset ratio is: Income Statement Balance Sheet Sales $20,000,000 Assets: Cost of Goods Sold 8,000,000 Cash $ 5,000,000 12,000,000 Marketable...
-
An insurer must have adequate capital to support the risk it assumes. Which one of the following is an alternative to raising additional capital to expand the assumption of risk? Available answer...
-
The upfront mortgage insurance premium (MIP) on an FHA loan is calculated based on ______. Unset starred question The base loan amount The base loan amount divided by 12 The property's appraised...
-
5 things/topics or more that you have learned in the class Caot78 or Quicbook. Write 5 to 6 sentences per topic. 1. Company Setup: 2. Transaction Entry and Management: 3. Bank Reconciliation: 4....
-
Mike estimates that college tuition at State University will be $25,000 per year in five years. If Mike can earn six percent compounded semi-annually, how much must he deposit today in order to fund...
-
Describe how the normal distribution is or is not helpful in analyzing portfolio outcomes.
-
What's your diagnosis of the breach at Target was Target particularly vulnerable or simply unlucky? Then using the Gap analysis, discuss which technical or organizational actions or decisions would...
-
Borrowing costs should be recognised as an expense and charged to the profit and loss account of the period in which they are incurred : A. If the borrowing costs relate to qualifying asset B. If the...
-
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...
-
a. Find the Laplace transform of the given function. Use Table 2.2 when applicable. b. Confirm the result of (a) in MATLAB. \(t^{2} \sin \left(\frac{1}{2} t ight)\) TABLE 2.2 Laplace Transform Pairs...
-
a. Express the signal in terms of unit-step functions. b. Find the Laplace transform of the expression in (a) by using the shift on \(t\)-axis. \(g(t)\) in Figure 2.16 FIGURE 2.16 Signal in Problem...
-
a. Express the signal in terms of unit-step functions. b. Find the Laplace transform of the expression in (a) by using the shift on \(t\)-axis. \(g(t)\) in Figure 2.15 FIGURE 2.15 Signal in Problem...
Study smarter with the SolutionInn App