logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
StatAnalytica ExpertSociology
(5/5)

674 Answers

Hire Me
expert
Robert DLaw
(4.8/5)

967 Answers

Hire Me
expert
Kate DugganNursing
(4/5)

680 Answers

Hire Me
expert
Kyle BaileyFinance
(4/5)

740 Answers

Hire Me
EViews
(5/5)

The excess return on a portfolio of two industry stocks from Fama and French, namely, consumer goods and services, and health.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

PURPOSE

The Individual Assignment relates to the following Learning Outcomes:

   • Apply econometric methods to modelling, analysing and forecasting financial data

   • Demonstrate and explain different estimation methodologies.

   • Critically evaluate empirical econometric work.

These learning outcomes support development of the following Graduate Capabilities:

   • Discipline Specific Knowledge and Skills

   • Critical, Analytical and Integrative Thinking

   • Effective Communication

SUBMISSION

   • The assignment must be submitted via Turnitin by 4pm on Thursday 15 October 2020. The submission link is available on iLearn under the “Assignment” tab from 5pm on Monday 12 October 2020.

   • No extensions will be granted, except in cases where an application for “Special Consideration” has been made and approved.

   • Late submission will incur a penalty of 10% per day of total available marks.

   • Submissions will not be accepted beyond 96 hours past submission deadline.

   • You can only submit ONCE to Turnitin. See the” After-submission checklist” (on page 2) for what you need to check after submitting.

   • Note: there is no “expected” range for similarity reports. You may get a high or low number. The issue is this: Have you produced your own work? The similarity report allows the lecturer to quickly check your submission against others for originality. A high similarity report will be a problem if you have not quoted your sources, or included more quotes than your own work, or your work is substantially the same as another’s. Check this link for more information: https://www.plagiarism.org/article/quoting-material

   • Marks will be assigned based on the quality of the responses to each question and in line with the rubric at the end of this document. 

PLAGIARISM

   • Avoid plagiarism. The consequence of plagiarism is a zero mark.

   • You may work with other students at the preparatory stage. However, the final version of the assignment should be written in your own words.

   • Note that Turnitin will compare your submission against others’ as well as internet sources and any submission you have made in previous sessions in any unit.

   • Get familiarised with the academic honesty policy:

DOCUMENT PREPARATION CHECKLIST

    Submit your assignment with the file name: FamilyName_GiveName_Student ID_Econ3034Assignment. For example: Smith_Mary_12345678_Econ3034Assignment

    All questions involving calculations must show all steps involved to arrive at your answer.

    You have used Equation Editor. In MS Word go to: “Insert” then “Equation”.

    All questions requiring a written response must include all relevant reasoning.

    All written answers are typed and then saved as a pdf. You cannot submit a hand written document.

    You can NOT submit a pages (Mac) document.

    You can NOT submit photos of your assignment. It must be written using word processing software and then saved and submitted as a pdf.

    All answers are presented in the same sequence as the questions in the assignment.

    All answers are written in full sentences and in clear language.

    All answers are proofread and grammatical errors and typos are minimised.

    Your submission should be in size 12 font.

    The master document is saved as a pdf file of less than 40MB.

    If you try to submit, and get a message that reads “Error M14:11” or similar, then you have tried to upload a Word document. Save as a pdf and re-submit.

    Include page numbers.

    Do not include appendices.  Do not go beyond 15 pages.  

AFTER-SUBMISSION CHECKLIST

    I have double-checked whether the document was properly uploaded.

    I have seen my originality report.

    I have received the Turnitin receipt via email.

The EViews workfile “Assignment_S2_2020_Workfile.wf1” located under “Assignment” heading on iLearn contains six monthly return series for the period January 1980 – February 2020 (482 observations). We do not include the returns for the most recent months as they may have an undue influence on the analysis due to the severe economic effects of the pandemic. (Note: Please see the document ‘How to save images from AppStream’ on our iLearn site under Assignment in order to obtain an image of a table or graph in EViews.)

The following monthly return series appear in the file:

A. The excess return on a portfolio of two industry stocks from Fama and French, namely, consumer goods and services, and health.

   • cnsmr rf _ (Average monthly excess return on a stock portfolio comprising firms which operate in the provision of consumer goods and services, both in retail and wholesale. The consumer goods industry stocks are listed on U.S. exchanges and the return is in excess of the U.S. risk free rate).

   • hlth rf _ (Average monthly excess return on a portfolio of health industry stocks. The stocks in the health industry are listed on U.S. exchanges and the return is in excess of the U.S. risk free rate). 

B. Returns on four pricing factors from Fama and French.

   • mkt rf _ (Excess return on a weighted portfolio of all stocks in the U.S. market. It is the U.S. Market Risk Premium).

   • hml (High minus Low. It is the average monthly return on a portfolio of High Book-to-Market (Value) stocks less the average monthly return on a portfolio of Low Book-to-Market (Growth) stocks).

   • smb (Small minus Big. It is the average monthly return on a portfolio of small capitalization stocks less the average monthly return on a portfolio of large (big) capitalization stocks).

   • rmw (Robust minus Weak. It is the average monthly return on a portfolio of stocks for firms with robust operating profitability less the average monthly return on a portfolio of stocks for firms with weak operating profitability).  

Note: All of the returns are expressed in percent, e.g. 2.65% is represented by 2.65, not by 0.0265.

Answer the following questions based on this dataset:

1. What sign would you expect the estimated coefficient on each factor to have in a regression of a portfolio return on the four factors? (Hint: To read about the factors, hml and smb, search under Fama-French three factor model and to read about rmw,search under Fama-French five factor model) (6 marks)

2. Estimate the following regression for the excess return on the portfolio of consumer goods stocks for the full sample 1980m01 to 2020m02 and include a table of results from EViews. 1 2 3 4 5 _ _ t tt t t cnsmr rf mkt rf hml smb rmw u =+ + + + + ββ β β β Are the estimated coefficients on the factors statistically significant at the 5% level? (2 marks)

3. Estimate the following regression for the excess return on the portfolio of health stocks for the full sample 1980M01 to 2020M02 and include a table of results from EViews. 1 2 3 4 5 _ _ t tt t t hlth rf mkt rf hml smb rmw u =+ + + + + ββ β β β Are the estimated coefficients on the factors statistically significant at the 5% level? (2 marks)

4. Compare the corresponding signs on the estimated coefficients on all the factors in both regressions (i.e. for consumer goods and health portfolio regressions). What does this comparison suggest about the average characteristics of stocks in the consumer good and health industries? (Hint: For example, are stocks in the consumer goods industry value stocks on average, etc?) (8 marks)

5. Is the estimate of β1 statistically significant at the 5% level in each of the regressions? How do you interpret this result? (4 marks)

6. Perform White’s test (with no cross product terms) for heteroscedasticity in the estimated residuals from each regression. (Write out the null and alternative hypotheses of the test, explain and provide the EViews output showing the results, and clearly state the conclusion of the test. Use a 5% significance level). (4 marks)

7. In view of the results of White’s test, should you be concerned about heteroscedasticity and if so, what should you do, and would that change any of the conclusions you reached in earlier questions. (4 marks).

The EViews workfile “Assignment_S2_2020_Workfile.wf1” contains data on the Australian term spread. This series is shown as spread au _ in the workfile. The spread is defined as the yield on 10-year Australian Government Bonds less the yield on 3-month Australian Bank Accepted Bills, expressed in percent per year, e.g. 1.60% is represented by 1.60, not by 0.0160. The data is obtained from the Reserve Bank of Australia website. The data are monthly for the period January 1980 – February 2020 (482 observations).

8. Using EViews, plot the term spread with a line chart (and with a horizontal line for the x-axis on the graph). Identify the episodes in the graph when the term spread is negative. What was about to happen to the Australian economy soon after these episodes? (Hint: With EViews10, click on the series spread au _ and the data appears. Choose View, then Graph and for graph type: select Basic and for specific: select Line and Symbol. Click O.K. and the graph appears without the horizontal xaxis line. ‘Freeze’ the graph by clicking on Freeze and then O.K. The ‘frozen’ graph comes up. Right click anywhere in the frozen graph and you will see a list of options. Select ‘Add lines and Shading’. Then for Type, select line and for Orientation, select Horizontal-left axis, and for Data Value under Position, type in 0. Click O.K. You will now have the horizontal axis shown in your graph. In EViews11, the horizontal axis will automatically appear). (4 marks)

9. Conduct an ADF unit-root test on the series spread au _ . Be careful to properly state the null and alternative hypothesis for the test. Also conduct a KPSS unit root test and be sure to state the null and alternative hypothesis for the test. Are the results from both tests consistent with each other? (6 marks)

10. Compute the ACF and PACF for the series spread au _ for the first twelve lags using EViews. Comment on the pattern of the ACF and PACF and what they may say about the time series process for spread au _ . (4 marks)

11. Consider the three models where t y denotes the spread i.e. spread au _ .

Model 1: t t tt 1 11 11 yc y u u =+ + + φ θ − −

Model 2: t t tt 2 11 2 2 yc y y u =+ + + φ φ − −

Model 3: t t t tt 3 11 2 2 33 yc y y y u

Estimate each model in EViews, comment of the significance of the coefficients (apart from the constant) and select the best model using the Akaike Information Criteria (AIC) and the Schwarz Bayesian Information criteria (SBIC). (Hint: Sample sizes need to be the same when comparing models with AIC or SBIC. That is, estimate the models over the sample period 1980m04 to 2020m02 (i.e. beginning in December 1980). In the equation estimation box, change 1980m01 to 1980m04). (6 marks)

12. Using EViews, compute the ACF and PACF (the first 12 lags) of the residuals of the preferred model, estimated from the sample running from 1980m04 to 2020m02. Comment on the results. (2 marks)

13. Estimate Model 2 for the sample 1980m04 to 2017m12 and generate a dynamic forecast for the period 2018m01 to 2020m02. (Hint: First estimate Model 2 being sure to specify 1980m04 2017m12 in the estimation settings box. Having estimated the model, select the forecast tab, select dynamic forecast, set the forecast sample to 2018m01 to 2020m02, and in the forecast name box, type spread auf _ which saves the dynamic forecasts on the workfile under this series name).

(i) Explain what is meant by a dynamic forecast. (2 marks)

(ii) EViews generates a graph for the dynamic forecasts you generated together with the two-standard error band. Present this graph and comment on the convergence or otherwise of the forecast values and on the behaviour of the two-standard error band.

(3 marks) (iii) Graph the actual spread au _ series and the dynamic forecast of the spread series i.e. spread auf _ on the same graph for the period 2018m01 to 2020m02. Comment on the graph. (Hint: Click on Quick/Sample and change the sample to 2018m01 2020m02. Then click on Object/New Object/Group and OK. In the list of series box, type spread au _ and spread auf _ and click O.K. Then click on View/Graph to graph both series together). (3 marks)

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme