Co-requisites: MA533 Contingencies II
OverviewThis 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:
Method of assessment
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.