BE314-5-SP-CO:
Financial Modelling
2016/17
Essex Business School
Colchester Campus
Spring
Undergraduate: Level 5
Current
15
-
Requisites for this module
(BE300 or EC111 or IA712) and BE313
(none)
(none)
(none)
BE333
BSC N420 Accounting and Finance,
BSC N422 Accounting and Finance (Including Placement Year),
BSC NN43 Accounting and Finance (Including Foundation Year),
BSC NNK3 Accounting and Finance (Including Year Abroad),
BSC N390 Banking and Finance,
BSC N392 Banking and Finance (Including Placement Year),
BSC NH90 Banking and Finance (Including Year Abroad),
BSC N300 Finance,
BSC N301 Finance (Including Foundation Year),
BSC N302 Finance (Including Year Abroad),
BSC N304 Finance (Including Placement Year)
This Module is intended to bring to life some of the theories that are introduced during BE300. With extensive use of spreadsheets (Excel) students will be able to use real data to analyse financial models. Applications will include asset pricing and risk management. An important component of the Module shall be the use of basic statistical concepts to test hypotheses relating to financial models.
MODULE AIMS
to familiarise students with techniques for handling financial data
to build a bridge between financial theories and practice
to introduce students to applied statistics with financial applications
MODULE OUTCOMES
After completing this Module students should be able to:
1. Examine and manipulate data using Excel
2. Estimate and interpret simple regressions
3. Estimate financial models using Excel
4. Understand the principles of regression analysis
5. Conduct appropriate hypothesis tests of financial models
No information available.
No information available.
No additional information available.
There shall be weekly two hour lectures and weekly one hour workshops. During the workshops you will be taken through examples using Excel.
Each workshop shall consist of a number of tasks that relate to the preceding lectures. Although teaching staff will be available to answer queries you will nevertheless be expected to work independently during these workshops. Should you fail to complete all tasks for a given workshop you are advised to continue with the tasks in your own time. If you continue to have difficulties you should make use of the lecturers' office hours.
Assessment items, weightings and deadlines
| Coursework / exam |
Description |
Deadline |
Coursework weighting |
| Written Exam |
EXCEL ASSIGNMENT |
|
|
| Exam |
Main exam: 120 minutes during Summer (Main Period)
|
Exam format definitions
- Remote, open book: Your exam will take place remotely via an online learning platform. You may refer to any physical or electronic materials during the exam.
- In-person, open book: Your exam will take place on campus under invigilation. You may refer to any physical materials such as paper study notes or a textbook during the exam. Electronic devices may not be used in the exam.
- In-person, open book (restricted): The exam will take place on campus under invigilation. You may refer only to specific physical materials such as a named textbook during the exam. Permitted materials will be specified by your department. Electronic devices may not be used in the exam.
- In-person, closed book: The exam will take place on campus under invigilation. You may not refer to any physical materials or electronic devices during the exam. There may be times when a paper dictionary,
for example, may be permitted in an otherwise closed book exam. Any exceptions will be specified by your department.
Your department will provide further guidance before your exams.
Overall assessment
Reassessment
Module supervisor and teaching staff
Sina Erdal and Mark Hallam
ebsugcol@essex.ac.uk
Yes
Yes
No
Dr Apostolos Kourtis
The University of East Anglia
Senior Lecturer in Finance
Available via Moodle
Of 85 hours, 22 (25.9%) hours available to students:
63 hours not recorded due to service coverage or fault;
0 hours not recorded due to opt-out by lecturer(s).
Disclaimer: The University makes every effort to ensure that this information on its Module Directory is accurate and up-to-date. Exceptionally it can
be necessary to make changes, for example to programmes, modules, facilities or fees. Examples of such reasons might include a change of law or regulatory requirements,
industrial action, lack of demand, departure of key personnel, change in government policy, or withdrawal/reduction of funding. Changes to modules may for example consist
of variations to the content and method of delivery or assessment of modules and other services, to discontinue modules and other services and to merge or combine modules.
The University will endeavour to keep such changes to a minimum, and will also keep students informed appropriately by updating our programme specifications and module directory.
The full Procedures, Rules and Regulations of the University governing how it operates are set out in the Charter, Statutes and Ordinances and in the University Regulations, Policy and Procedures.