Financial Modelling - MACT5390
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.
Total contact hours: 36
Private study hours: 114
Total study hours: 150
Method of assessment
This is primarily a practical model. The majority of the reading will be provided by specific lecture notes.
See the library reading list for this module (Canterbury)
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 3 above.
Credit level 6. Higher level module usually taken in Stage 3 of an undergraduate degree.
- ECTS credits are recognised throughout the EU and allow you to transfer credit easily from one university to another.
- The named convenor is the convenor for the current academic session.
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.