Financial Modelling - MA539

Location Term Level Credits (ECTS) Current Convenor 2019-20
Canterbury Spring
View Timetable
6 15 (7.5) MR J Millett


Co-requisites: MA533 Contingencies II





This module is split into two parts: 1. An introduction to the practical experience of working with the financial software package, PROPHET, which is used by commercial companies worldwide for profit testing, valuation and model office work. The syllabus includes: overview of the uses and applications of PROPHET, introduction on how to use the software, setting up and performing a profit test for a product , analysing and checking the cash flow results obtained for reasonableness, using the edit facility on input files, performing sensitivity tests , creating a new product using an empty workspace by selecting the appropriate indicators and variables for that product and setting up the various input files, debugging errors in the setting up of the new product, performing a profit test for the new product and analysing the results. 2. An introduction to financial modelling techniques on spreadsheets which will focus on documenting the process of model design and communicating the model's results. The module enables students to prepare, analyse and summarise data, develop simple financial and actuarial spreadsheet models to solve financial and actuarial problems, and apply, interpret and communicate the results of such models.


This module appears in:

Contact hours

36 hours

Method of assessment

100% coursework

Indicative reading

See the library reading list for this module (Canterbury)

Learning outcomes

The intended subject specific learning outcomes. On successfully completing the module students will be able to:

1 demonstrate skills in specific actuarial software and information technology (e.g. PROPHET);
2 understand the principles of specific actuarial mathematics techniques;
3 develop simple actuarial computer models to solve actuarial problems;
4 interpret and communicate the results of the models derived in 8.3.

The intended generic learning outcomes. On successfully completing the module students will be able to:

1 use a logical mathematical approach to solving problems;
2 communicate material competently in writing;
3 apply relevant computing skills.

University of Kent makes every effort to ensure that module information is accurate for the relevant academic session and to provide educational services as described. However, courses, services and other matters may be subject to change. Please read our full disclaimer.