FN285 Financial Modelling and Dealing Homework
Length: 1,250 words.
Purpose:
Its purpose is to provide you with an opportunity to appropriately apply the econometric techniques to model financial relationships using time series data and to interpret the results correctly.
In completing this homework you should demonstrate:
a. Competence in the use of EViews;
b. Data collection skills and an ability to transform data into correct form for econometric analysis in finance;
c. Skills in presenting and interpreting summary statistics;
d. Skills in interpreting regression output;
e. An ability to test the classical assumptions of the regression modeland,
f. An ability to present results in a professional manner.
The Task (marks allocation for sub-tasks are shown in parentheses):
Your task is to model a linear financial relationship based on the arbitrage pricing theory (APT) - a brief explanation of the theory is required.
Your model should include3 variables and be of the form:
Yt = α + β1X1t + β2X2t+ ut ut ~ N(0, σ2)
You will collectmonthly data on: the prices for a stock; the S&P500 prices; Treasury bill yields for three months maturity;and, the consumer price index in the USA, to model.
Relevant data is available from: Yahoo Finance, FRED (The Federal Reserve Bank of St. Louis), IMF and the World Bank.
Specifically, you should:
a. Comment on what you intend to do and the arbitrage pricing theory (APT) that underpins the model you will be estimating.
b. Give a brief account on the source of your data and make the necessary data transformation.
c. Investigate the variables included in your model. Present in a table and interpret the respective summary statistics.
d. Estimate the model and test if it conforms to three ofthe classical OLS assumptions for the residuals: homoscedasticity; no serial correlation and normality. You are required to undertake any corrections that are feasibly possible.
e. Carefully specify the hypotheses for testing the individual coefficients and the F-test for overall significance .
f. Interpret the R2, adj. R2 and F statistics.
g. Interpret the estimated coefficients in terms of their signs, significance and impact on the dependent variable.
h. All source material - websites, textbooks and lecture notes, articles and data sources - should be correctly referenced.
i. The report should be structured following the order of the tasks performed. The results should be presented in an appropriate format (note: cutting and pasting of EViews output is not advisable and should be avoided).
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.
References
Data Websites
World Bank:
IMF:
Yahoo Finance:
Federal Reserve Economic Data (FRED):
Texts
Asteriou, D. and S. Hall. Applied Econometrics, Palgrave Macmillan.
Barrow, M. Statistics for Economics, Accounting and Business Studies, Pearson.
Brooks, C. Introductory Econometrics for Finance, Cambridge University Press.