5. Go to Yahoo Finance and obtain the monthly adjusted-closing prices for General Motors (GM) and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
5. Go to Yahoo Finance and obtain the monthly adjusted-closing prices for General Motors (GM) and the S&P500 Index (^GSPC) from 1st Jan 2016 to 1st Jan 2021 (both dates included). An Excel file with the raw data and workings should be submitted as supplementary materials for this question, in addition to the clear write-up in Word. [20 marks] a) Derive the monthly returns of GM and the Index. [1m] b) Assuming a monthly risk-free rate of 0.1%, create a column for the Excess monthly return for GM and another column for the Excess monthly return for the Index. [1m] c) Calculate the average monthly excess return and the standard deviation of the monthly excess returns for GM and the Index. [4m] d) Perform a Linear regression of the Excess monthly return for GM (dependent variable) and the Excess monthly return for the Index (independent variable).[1m] e) Highlight the cell in the Regression Output that shows the Beta of GM stock. [1m] f) Based on the Regression Output, is there alpha for GM stock? How do you know? [2m] g) From the ANOVA table output, calculate the (i) Systematic Variance, (ii) Unsystematic Variance and (iii) Total Variance of GM Stock? [6m] h) Using the values in (g), derive the R-square value for the regression (check that it matches the regression output!) [2m] i) Using the R-square, derive the Beta of GM (check that it matches the regression output!) [2m] 5. Go to Yahoo Finance and obtain the monthly adjusted-closing prices for General Motors (GM) and the S&P500 Index (^GSPC) from 1st Jan 2016 to 1st Jan 2021 (both dates included). An Excel file with the raw data and workings should be submitted as supplementary materials for this question, in addition to the clear write-up in Word. [20 marks] a) Derive the monthly returns of GM and the Index. [1m] b) Assuming a monthly risk-free rate of 0.1%, create a column for the Excess monthly return for GM and another column for the Excess monthly return for the Index. [1m] c) Calculate the average monthly excess return and the standard deviation of the monthly excess returns for GM and the Index. [4m] d) Perform a Linear regression of the Excess monthly return for GM (dependent variable) and the Excess monthly return for the Index (independent variable).[1m] e) Highlight the cell in the Regression Output that shows the Beta of GM stock. [1m] f) Based on the Regression Output, is there alpha for GM stock? How do you know? [2m] g) From the ANOVA table output, calculate the (i) Systematic Variance, (ii) Unsystematic Variance and (iii) Total Variance of GM Stock? [6m] h) Using the values in (g), derive the R-square value for the regression (check that it matches the regression output!) [2m] i) Using the R-square, derive the Beta of GM (check that it matches the regression output!) [2m]
Expert Answer:
Related Book For
Principles of Corporate Finance
ISBN: 978-0072869460
7th edition
Authors: Richard A. Brealey, Stewart C. Myers
Posted Date:
Students also viewed these finance questions
-
Leaders must never ask subordinates to violate their beliefs with _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ .
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Analyze how HR can help organizations manage benefits thus contributing to profitability. Examine the impact of legally required benefits and discretionary benefits on a company's budget Explain how...
-
All of the following represent trends shaping HR over the past decade, according to our reading, except: Organizations are spending more on the expansion of physical office space Employees are...
-
Let P be the point (2, 3, - 2) and O the point (7, - 4, 1). (a) Find the midpoint of the line segment connecting P and Q. (b) Find the point on the line segment connecting P and Q that is 3/4 of the...
-
The rights of shareholders are established only in the articles of incorporation. (True/False)
-
Write \(y(t)=3 \cos 2 t-4 \sin 2 t\) in the form \(y(t)=A \cos (2 \pi f t+\phi)\).
-
Horizontal analysis refers to changes of financial statement numbers and ratios across two or more years. Vertical analysis refers to financial statement amounts expressed each year as proportions of...
-
A portfolio has three (3) stocks: LASCO, PRVN, and EPLY. Theportfolio has 45% of the funds in LASCO which has a 24% expectedreturn; 20% is invested in PRVN with an expected return of 8%; thebalance 2...
-
Please pick an example of a human rights problem that you think is important in the world right now. This can be within Pakistan, or anywhere else in the world: Your answer should have three overall...
-
The way in which society's resources are distributed has long been of major concern to economists, directly affecting as it does the level of social welfare. Changes in the size and distribution of...
-
Consider the following gaming scenario. You paid $10 to play the game. In the game, you must choose between two options: A) 89% chance of getting $900; 10% chance of losing $200; 1% chance of not...
-
Assume that 30% of the profit from incremental sales is refunded to customers who filed complaints within the money-back guarantee period. Why do things like product quality and money-back guarantees...
-
All assignments in this course are untimed and open book/notes/computer. In this assignment, you will do a short, informal, research journal. ( On Westlaw or findlaw.com) Why a journal? We are often...
-
State the domain for each function below. 3x-9 a. f(x) = x-3x 4x+20 b. g(x) =
-
XOR is 1 if x and y are the complements of each other. Using truth table or Boolean postulates, prove that XOR is: a. Commutative: x+y=y+x a. Associative: xyz)=(xy) z=x+y+z
-
Fill in each blank so that the resulting statement is true. 83 + 103 = ______ .
-
The appendix summarizes several problems with Chapter 11 bankruptcy. Which of these problems could be mitigated by negotiating a prepackaged bankruptcy?
-
Suppose that the cash flows from Nodhead's new supermarket are as follows: a. Recalculate economic depreciation. Is it accelerated or decelerated? b. Rework Tables 12.7 and 12.8 to show the...
-
You own 500 acres of timberland, with young timber worth $40,000 if logged now. This represents 1,000 cords of wood worth $40 per cord net of costs of cutting and hauling. A paper company has offered...
-
1. Benzaquin had a radio talk show in Boston. On the program, he complained about an incident earlier in the day, in which state trooper Fleming had stopped his car, apparently for lack of a proper...
-
3. Fifteen-year-old Terri Stubblefield was riding in the back seat of a Ford Mustang II when the car was hit from behind. The Mustang was engulfed in a ball of fire, and Terri was severely burned....
-
2. Caldwell, carrying a large purse, was shopping in a K-Mart store. A security guard observed her look at various small items such as stain, hinges, and antenna wire. On occasion she bent down out...
Study smarter with the SolutionInn App