Consider the data for Coles-Myers in the files cmi.xls. The files contain 4 variables from 1984Q1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the data for Coles-Myers in the files "cmi.xls". The files contain 4 variables from 1984Q1 to 2003Q3. Variable Name P DIVY ALLORD DELBILL Description Coles-Myer Share Price Index Coles-Myer Dividend Yield ALL ORDS-SFE-SPI 200 AUSTRALIA DEALER BILL 90 DAY- MIDDLE RATE Construct a model for the excess returns to shares of Coles-Myers as follows: EXCOLES = ₁ + 0₂ EXMKT+U (1) where, DELB = LOG(1 + DELBILL/400) EXCOLES = LOG(P/P(-1)) - DELB EXMKT = LOG(ALLORD/ALLORD(-1)) - DELB (a) Looking at the variables EXCOLES and EXMKT, what do these variables measure? [1] (b) Plot the excess returns of Coles Myer shares. Copy and paste your graph. [1] Visually make an assessment of sub-sample periods where you think it is reasonable to expect the parameters of the model to have remained constant. [2] (c) Estimate the above CAPM Model in equation (1). Copy and paste the regression output. [1] Write down the regression estimates and interpret the results. [2] (d) Perform a test to assess the stability of the CAPM parameters by using the break date of 1989Q1. Copy and paste your test results. [1] State the null and alternative hypotheses. What is your conclusion? [3] (e) Repeat your analysis in part (d) but use the break date of 1998Q1. Copy and paste your results and state your conclusion. [1.1] (f) Based on your results in part (d) and (e), is your answer in (c) robust to structural breaks? [1] (g) is the residual in regression (1) free from autocorrelation at lag order 10? Copy and paste your results and explain your findings.[1.1] (h) is the residual in regression (1) homoskedastic? Copy and paste your results and explain your findings.[1,1] (i) Is the residual in regression (1) normally distributed? Copy and paste your results and explain your findings.[1,1] Consider the data for Coles-Myers in the files "cmi.xls". The files contain 4 variables from 1984Q1 to 2003Q3. Variable Name P DIVY ALLORD DELBILL Description Coles-Myer Share Price Index Coles-Myer Dividend Yield ALL ORDS-SFE-SPI 200 AUSTRALIA DEALER BILL 90 DAY- MIDDLE RATE Construct a model for the excess returns to shares of Coles-Myers as follows: EXCOLES = ₁ + 0₂ EXMKT+U (1) where, DELB = LOG(1 + DELBILL/400) EXCOLES = LOG(P/P(-1)) - DELB EXMKT = LOG(ALLORD/ALLORD(-1)) - DELB (a) Looking at the variables EXCOLES and EXMKT, what do these variables measure? [1] (b) Plot the excess returns of Coles Myer shares. Copy and paste your graph. [1] Visually make an assessment of sub-sample periods where you think it is reasonable to expect the parameters of the model to have remained constant. [2] (c) Estimate the above CAPM Model in equation (1). Copy and paste the regression output. [1] Write down the regression estimates and interpret the results. [2] (d) Perform a test to assess the stability of the CAPM parameters by using the break date of 1989Q1. Copy and paste your test results. [1] State the null and alternative hypotheses. What is your conclusion? [3] (e) Repeat your analysis in part (d) but use the break date of 1998Q1. Copy and paste your results and state your conclusion. [1.1] (f) Based on your results in part (d) and (e), is your answer in (c) robust to structural breaks? [1] (g) is the residual in regression (1) free from autocorrelation at lag order 10? Copy and paste your results and explain your findings.[1.1] (h) is the residual in regression (1) homoskedastic? Copy and paste your results and explain your findings.[1,1] (i) Is the residual in regression (1) normally distributed? Copy and paste your results and explain your findings.[1,1]
Expert Answer:
Answer rating: 100% (QA)
a EXCOLES and EXMKT variables measure the following EXCOLES Excess returns to shares of ColesMyers It represents the logarithmic difference between th... View the full answer
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date:
Students also viewed these mathematics questions
-
Consider the data for Business Weeks top U.S. MBA programs in the MBA Data sheet of the file P10_21.xlsx. Use these data to estimate a multiple regression model to assess whether there is a...
-
Consider the data for Specialty Department Stores presented in P15-29B. Requirements 1. Prepare a common-size income statement and balance sheet for Specialty. The first column of each statement...
-
Consider the data for Ryan Company in Exhibit. Assume all sales are on credit. 1. Compute the following ratios for the years 20X2 and 20X3: a. Percentage of net income to stockholders equity (ROE) b....
-
Mike and Linda are a married couple who file jointly and have $100,000 of taxable income. They have three dependent children who are full-time students in 2022. Mike and Linda provided $8,000 of...
-
The half-life of titanium-44 is 60.0 y. A sample of titanium contains 0.600 g of titanium-44. How much remains after 240.0 y?
-
Here is a question that a panel of judges decided: Can a company patent how it makes a peanut butter and jelly sandwich? More specifically, in this instance, judges considered whether J. M. Smuckers...
-
Trevor Ltd manufactures and sells four products A, B, C and D. The selling prices, variable costs, and number of machine hours required to produce each product are as follows. Each of the four...
-
The income statement and additional data of Bolton Travel Products, Inc., follow: Additional data: a. Acquisition of plant assets was $130,000. Of this amount, $75,000 was paid in cash and $55,000 by...
-
A shipping company owns two types of trucks, type A and type B. Each type A truck has 20m3 of refrigerated space and 30m3 of unrefrigerated space, while each type B truck has 20m3 of cooled space and...
-
Clovis Company recently issued $500,000 (face value) bonds to finance a new construction project. The company's chief accountant prepared the following bond amortization schedule: Required: 1....
-
What type of economic and political systems prevail in Pakistan? Explain bright and dark sides of the system for a businessman. Support your answers with sufficient examples and references.
-
Some cultures are not comfortable saying no to their leader. Find examples and explain why this is so. Conversely, which cultures find it easier to say no?
-
Figure G-22 is a photograph of an outcrop in the Transantarctic Range of Antarctica. The view shows a cross section of beds of coarse conglomerate and finer-grained conglomerate. The arrow points to...
-
What is organic growth? What are the other options for international growth?
-
In what ways does e-business differ from traditional exporting of goods and services?
-
What is a call loan? How did call loans contribute to economic recessions?
-
What are your three most important personal and professional priorities regarding the completion of your dissertation research and life beyond graduation? Why are these important to you and the...
-
Chao, Louis, and Mari, unrelated individuals, own all of the shares of Cerise Corporation. All three shareholders have been active in the management of Cerise since its inception. In the current...
-
Let X and Y represent the number of Dell and HP laptop computers, respectively, sold per month from online sites. The file S04_28.xlsx contains the probabilities of various combinations of monthly...
-
The file P10_66.xlsx contains monthly cost accounting data on overhead costs, machine hours, and direct material costs. This problem will help you explore the meaning of R2 and the relationship...
-
The time it takes you to swim 100 yards in a race is normally distributed with mean 62 seconds and standard deviation 2 seconds. In your next five races, what is the probability that you will swim...
-
The treatment of outflows on account of dividend and interest is highly debatable as to their activity classification. Give a serious thought to the issue and express your opinion about the best...
-
Reliance Industries Ltd. is the biggest private sector company in India. The following fact sheet about the company and its peer group, as extracted from Capitaline Plus database is reproduced in the...
-
Consider the same setting as Problem 18, but suppose instead 80% of the shareholders redeem their shares, and no warrants are exercised. Data from problem 18 a. What is the amount of cash per share...
Study smarter with the SolutionInn App