## Internal

IC212: Financial Modelling

# IC212: Financial Modelling

Module code: IC212

Module provider: ICMA Centre; Henley Business School

Credits: 20

Level: Level 2 (Intermediate)

When you'll be taught: Semester 1

Module convenor: Dr Gita Persand, email: gita.persand@icmacentre.ac.uk

Module co-convenor: Dr Yoke Yue Kan, email: y.y.kan@henley.edu.my

Pre-requisite module(s):

Co-requisite module(s):

Pre-requisite or Co-requisite module(s):

Module(s) excluded:

Placement information: na

Available to visiting students: Yes

Last updated: 28 May 2024

## Overview

Module aims and purpose

This module aims to put various finance theories, which were studied at Part 1 Introductory Finance, into practice with the use of Microsoft Excel functions, hence providing students with an opportunity to apply their theoretical knowledge, when using Excel, to solve some real-life financial problems. Students will be able to implement the concept of capital budgeting, time value of money, construct portfolios, run regressions in order to estimate the Capital Asset Pricing Models, and calculate the prices of bonds, stocks and options among others.

The module lead at the University of Reading Malaysia is Dr Yoke Yue Kan.

Module learning outcomes

By the end of the module, it is expected that students will be able to:

• apply the functions of Microsoft Excel to the financial concepts that were studied in Part 1 IC102 Introductory Finance.
• solve practical financial problems in areas of Finance such as Asset and Derivative Pricing, Portfolio Management, Time Value of Money, and the Capital Asset Pricing Model.
• gain teamwork skills while working on the group project as well as time management skills when taking the practical test.

Module content

1. Statistical analysis and time series regression
2. Financial arithmetic and the time value of money
3. Equities
4. Bonds
5. Portfolio Management
6. Capital Asset Pricing Model
7. Project – Portfolio Optimisation/Bond Immunisations
8. Options pricing
9. Mock Test
10. Revision

## Structure

Teaching and learning methods

Teaching for both the lectures and seminars take place in a computer lab as students will need access to Excel to undertake their learning activities.

Lectures are interactive - Module Convenor demonstrate how to apply the financial concepts on Excel first before students would replicate them. Students will call the Module Convenor to their computers if they are facing any challenges while working with Excel.

Students are given seminar questions in advance, and they have to make an attempt at those questions on Excel before the seminars. The Teaching Assistants will be helping them if they are unable to answer those questions during the seminars.

The Module Convenor and Teaching Assistants are available throughout the semester to help students during their office hours. This can be face-to-face or online.

This module may be taught in a different Semester if you are studying at our campus in Malaysia.

For students studying at our campus in Malaysia: This module may be taught in a different semester and the breakdown of study hours may differ to those set out in the Study Hours table (please refer to the Module Handbook for the correct breakdown). In addition, you will be required to complete an additional 40 hours of study, taking the total number of study hours to 240 for this module. This is to comply with the Malaysian Quality Agency (MQA).

Study hours

At least 35 hours of scheduled teaching and learning activities will be delivered in person, with the remaining hours for scheduled and self-scheduled teaching and learning activities delivered either in person or online. You will receive further details about how these hours will be delivered before the start of the module.

Scheduled teaching and learning activities  Semester 1  Semester 2  Summer
Lectures 20
Seminars 8
Tutorials
Project Supervision
Demonstrations
Practical classes and workshops
Supervised time in studio / workshop
Scheduled revision sessions 2
Feedback meetings with staff 5
Fieldwork
External visits
Work-based learning

Self-scheduled teaching and learning activities  Semester 1  Semester 2  Summer
Directed viewing of video materials/screencasts 5
Participation in discussion boards/other discussions 5
Feedback meetings with staff 3
Other
Other (details)

Placement and study abroad  Semester 1  Semester 2  Summer
Placement

Please note that the hours listed above are for guidance purposes only.

Independent study hours  Semester 1  Semester 2  Summer
Independent study hours 152

Please note the independent study hours above are notional numbers of hours; each student will approach studying in different ways. We would advise you to reflect on your learning and the number of hours you are allocating to these tasks.

Semester 1 The hours in this column may include hours during the Christmas holiday period.

Semester 2 The hours in this column may include hours during the Easter holiday period.

Summer The hours in this column will take place during the summer holidays and may be at the start and/or end of the module.

## Assessment

Requirements for a pass

40% weighted average mark of individual and group assignments

Summative assessment

Type of assessment Detail of assessment % contribution towards module mark Size of assessment Submission date Additional information
Practical skills assessment Practical 40 3.5 hours test Semester 1 Week 12 This task assesses the students' depth of knowledge of Excel applications in Finance.
Written coursework assignment Group Project 60 1,500-word count for the report Semester 1 Week 2 of Assessment period This task assesses students' ability to work in a team, complete a task on Excel before writing a report on the findings.

Penalties for late submission of summative assessment

The Support Centres will apply the following penalties for work submitted late:

Assessments with numerical marks

• where the piece of work is submitted after the original deadline (or any formally agreed extension to the deadline): 10% of the total marks available for that piece of work will be deducted from the mark for each working day (or part thereof) following the deadline up to a total of three working days;
• the mark awarded due to the imposition of the penalty shall not fall below the threshold pass mark, namely 40% in the case of modules at Levels 4-6 (i.e. undergraduate modules for Parts 1-3) and 50% in the case of Level 7 modules offered as part of an Integrated Masters or taught postgraduate degree programme;
• where the piece of work is awarded a mark below the threshold pass mark prior to any penalty being imposed, and is submitted up to three working days after the original deadline (or any formally agreed extension to the deadline), no penalty shall be imposed;
• where the piece of work is submitted more than three working days after the original deadline (or any formally agreed extension to the deadline): a mark of zero will be recorded.

Assessments marked Pass/Fail

• where the piece of work is submitted within three working days of the deadline (or any formally agreed extension of the deadline): no penalty will be applied;
• where the piece of work is submitted more than three working days after the original deadline (or any formally agreed extension of the deadline): a grade of Fail will be awarded.

The University policy statement on penalties for late submission can be found at: https://www.reading.ac.uk/cqsd/-/media/project/functions/cqsd/documents/qap/penaltiesforlatesubmission.pdf

You are strongly advised to ensure that coursework is submitted by the relevant deadline. You should note that it is advisable to submit work in an unfinished state rather than to fail to submit any work.

Formative assessment

Formative assessment is any task or activity which creates feedback (or feedforward) for you about your learning, but which does not contribute towards your overall module mark.

Ongoing feedback throughout the lectures and seminars.

Mock test at the end of Semester 1.

## Reassessment

Type of reassessment Detail of reassessment % contribution towards module mark Size of reassessment Submission date Additional information
Written coursework assignment Project 100 1,500 word count During the University resit period This is an individual project, based on the same topic and content as the group project.