1500 word report,
data file is attached
a) Download the monthly data series from DataStream for the period between January 2000 and December 2019 for the following:
the share price from a company that has been randomly assigned to you,
(you will be provided with the name of the company assigned to you in the ‘Assessments’ folder in Introduction to Financial Econometrics site on DUO.)
the FTSE All Share Index (proxy for the market portfolio), and
the UK 3 Month Treasury Bill (proxy for the risk-free rate of return).
Note: the UK 3 Month Treasury Bill Interest Rate is given as an annual rate.
USING PCGIVE PROGRAM
Transform prices into log returns, plot the return data, report the sample statistics, and examine whether the log returns are normally distributed.
b) Carry out a test for stationarity in your company return and the market return. Carefully explain the test procedure and the importance of your results.
c) Identify an univariate time-series model for the estimation of your company’s return. Comment on the procedure adopted and pay particular attention to the identification, estimation and diagnostic stages of the modelling process.
In finance it is customary to explain the changes in the excess return on an asset as a linear function of the excess return on the market portfolio, i.e.,
where Rt is the excess return on a stock (with respect to the risk-free rate), RMt is the excess return on a market index (with respect to the risk-free rate).
Estimate the beta value of your company using the model described in equation (1) and check the adequacy of the model. (20 marks)
Construct an appropriate dummy variable and estimate a multiple regression model to investigate whether the result of British referendum to withdraw from the EU (‘Brexit’) has had an impact on your company’s return and its beta. (20 marks)
All results should be properly tabulated in the main body of the assignment along with any diagrams you deem appropriate. You should not include the raw software or EXCEL output. This should be reformulated into your own tables. Keep your answers as precise and concise as possible. You should properly reference any relevant econometric literature (theoretical and applied) referred to in the text.
You should include the raw data and return series for the first and last years in the sample (i.e. 2000 AND 2019) in an appendix