FE5001 - Econometrics and Financial Modelling (2020/21)
|Module specification||Module approved to run in 2020/21|
|Module title||Econometrics and Financial Modelling|
|Module level||Intermediate (05)|
|Credit rating for module||30|
|School||Guildhall School of Business and Law|
|Total study hours||300|
|Running in 2020/21||
The first half of this module focuses on Econometrics, and deals with the theory and application of the Classical Linear Regression Model (CLRM), providing a firm grounding in the theory of Ordinary Least Squares (OLS) and an appreciation of its limitations. It provides a theoretical understanding of the causes, consequences and detection of, and remedies for, the violation of the assumptions of the classical linear regression model. It develops knowledge and skills to use standard statistical/econometric software package (e.g. EViews) and apply techniques to economics, finance and banking problems and models.
The second half of this module focuses on Financial Modelling, and involves the use of EViews and Excel and other relevant software to construct financial models including valuation and portfolio models.
The module provides students with the knowledge and skills to design, undertake, and evaluate empirical work within economics, finance and banking.
Students are encouraged to reflect and draw on their diverse socio-cultural
backgrounds and experiences.
Equality is promoted by treating everyone with equal dignity and worth, while also raising aspirations and supporting achievement for people with diverse requirements, entitlements and backgrounds
A range of transferable and subject specific skills are developed, in particular: self- assessment and reflection; peer assessment; written; IT; applied analysis; subject research; problem solving; data and quantitative; analytical and critical thinking.
Review of statistics: probability distributions, sampling theory, estimation, confidence intervals, hypothesis testing and applications to economic, finance and banking. LO1
Correlation and regression analysis: applications to economics and finance. LO1
Introduction to Econometrics: economic theory versus empirics. LO1
The Classical Linear Regression Model: Ordinary Least Squares estimation and assumptions. LO1
Linear regression model estimation and hypothesis testing LO2
Multiple Regression Model, estimation and hypothesis testing. LO2
Functional form and dummy variables LO2
Violations of the assumptions of the classical linear regression model: causes, consequences, tests and solutions for multi-collinearity and misspecification errors. LO2
Use IT to access sources of relevant economic and financial information, and transform into usable information relevant to the analysis of economics, finance and banking. LO2
Development of intermediate knowledge of spreadsheets, using workbooks and solving problems by analysing data. Using and interpreting the output of dedicated econometric software (e.g. EViews), conducting appropriate econometric tests, and writing reports analysing econometric problems. LO2
Financial Modelling involving the implementation of financial models in Excel. Basic and advanced models in the areas of corporate finance such as valuation models for securities, Optimal vale of investment portfolios, pricing options, and measurement of value at risk (VAR) in Excel spreadsheets. LO3
Examination of the technical aspects of EViews and Excel as tools of Financial Modelling for data analysis and measuring value of financial assets at risk exposure. LO4
Balance of independent study and scheduled teaching activity
Learning consists of ‘formal’ class room learning directed by the teaching team, and reflective independent learning. The formal learning involves lectures, seminars and computer-workshops while the independent learning consists of reading of the course material, working on weekly exercises including computing assignments using software (for example EViews) and coursework that involves undertaking econometric analysis and writing a report, and preparing for the final written exam.
The module is delivered in a three-hour session each week which comprises a two-hour lecture, and a one-hour seminar or a one-hour computer workshop. In the seminar students present their solution(s) to the problems set and raise questions on the lecture material. In the computer workshop students undertake empirical analysis using IT software. The seminar and the workshop provide opportunities for active and reflective learning, and also formative feedback. A virtual learning environment (WebLearn) supports blended learning by providing module handbook, lecture notes, seminar materials, IT workshop exercises, past test and exam papers with guideline answers, coursework brief with assessment and grading criteria, EViews videos and other learning material.
All activities provide students with knowledge and understanding of econometrics, statistics and financial modelling. The weekly exercises and the coursework give students such diverse skills as working independently, problem solving, writing concisely and clearly, retrieving secondary data from various online sources and describing and exploring them using econometric software and spreadsheets.
Professional and transferable skills are developed in lectures and seminars, and through independent directed learning and assessment. Skills development is enhanced through working cooperatively solving economic problems.
Initiative and independence is developed progressively through the module such that students are required to take greater responsibility of their work.
On successful completion of this module students will be able to:
1. Demonstrate a broad knowledge and a systematic understanding of statistics;
correlation and linear regression analysis; hypothesis testing and application to
economics, finance and banking.
2. Produce evidence, collect, analyse and interpret data and explain regression results; test hypotheses; evaluate regression models and use dedicated statistical and econometric software such as Excel and EViews.
3. Employ financial Models including security valuation, portfolio selection and pricing options using EViews, Excel and other relevant software.
4. Apply theoretical and practical knowledge for the analysis of financial data and risk management.
The summative assessments and feedback practices are informed by reflection, consideration of professional practice, and subject-specific knowledge and educational scholarship.
There are TWO summative assessments consisting of an individual coursework (1500 words econometric report) in week 15 assessing learning outcomes 1 and 2, and an individual coursework (2,000 words) assessing learning outcomes 3 and 4 in relation to financial modelling.
Through the summative assessments, students are provided with opportunities to develop an understanding of, and the necessary skills to demonstrate, good academic practice.
The first coursework is an independent piece of work requiring the application of knowledge gained on the module. The coursework is based on a computing assignment that applies econometric and other quantitative methods to a particular economic/ finance/ banking model using dedicated econometric software. Students write a report and are assessed on their knowledge and skills in designing, executing and evaluating empirical work within a range of economic and financial contexts.
A feed-forward strategy is used to provide early feedback to students to improve their final submission. Use of the feedforward strategy and class discussion of a detailed grading and assessment criteria create an opportunity for dialogue between students and staff and promote shared understanding of the basis on which academic judgements are made.
The second coursework develops students’ ability in financial modelling. Detailed information on requirements and guidance will be delivered within the teaching weeks. This coursework is due in week 27. Students will receive timely, constructive and developmental feedback.
The coursework assess the student’s knowledge and understanding of quantitative analysis and methods applied to economics, finance and banking. Subject research, written communication; data and quantitative analysis; critical thinking; problem solving and IT skills and ability to apply specialist econometric and financial modelling software packages such as Eviews/Excel/SPSS are developed and assessed.
During seminars students receive formative feedback on their knowledge and understanding of quantitative techniques and analysis by working though exercises and problems which they prepare before the session. This preparation and feedback provides support for students when they later tackle problems set in summative assessments.
Through the summative assessments, students are provided with opportunities to develop an understanding of, and the necessary skills to demonstrate, good academic practice. Written communication, analytical, critical thinking, problem solving, quantitative and interpreting skills are assessed.
All the information about processes of marking and moderating marks, timing of assessments and deadlines for feedback provision are clearly articulated in the module boklet and communicated to students through Weblearn as well.
1. Asteriou, D and Hall S G (2016). Applied econometrics, 3rd ed., Palgrave Macmillan
This is an E-BOOK. Hard copies are available at Aldgate 330.015195 AST
2. Benninga, S. (2014) Financial Modelling 4th Edition, MIT Press, London.
Aldgate 332.015118 BEN
3. Brooks, C. (2014) Introductory Econometrics for Finance, 3rd Edition, Cambridge
University Press, Cambridge. Earlier editions are available as E-BOOK and hard
copies at Aldgate 332.015118 BRO
4. Barrow, M. (2013) Statistics for economics, accounting and business studies, 6th
ed., FT Prentice Hall. This is an E-BOOK. Hard copies available at Holloway Rd and
Aldgate 519.502433 BAR
5. Bradley, T. (2007). Essential statistics for economics, business and management, John Wiley & Sons Ltd. Aldgate 519.5 BRA
6. Dougherty, C. (2016). Introduction to econometrics, 5th edition, Oxford.
Aldgate 330.015195 DOU
7. Gujarati, D. N. (2015). Econometrics by example, 2nd ed., Palgrave MacMillan
This is an E-BOOK. Hard copies of earlier editions are available at Aldgate
8. Gujarati, D.N. and Porter D. (2010). Essentials of econometrics, 4th ed., McGraw
Hill. Aldgate 330.015195 GUJ
9. Gujarati, D.N. and Porter D. (2014). Basic econometrics, 6th ed., McGraw Hill
Earlier editions are available at Aldgate 330.015195 GUJ
10. Keller, G. (2012). Managerial statistics, 9th ed., South Western Cengage learning
11. Oakshott, Les (2016). Essential quantitative methods for business, management
and finance, 6th ed. Palgrave Macmillan. This is also available as an E-Book. Hard
copies are available at 658.0015195 OAK Holloway Rd and Aldgate
12. Waters, Donald (2011) Quantitative methods for business, 5th ed., FT Prentice Hall,
This book is available as E-BOOK.
13. Wooldridge, J. M. (2016). Introduction to econometrics, 4th ed., South Western
College Publishing. This is an E-BOOK. Earlier editions are available as hard copies
at Aldgate 330.015195 WOO