| Area: | Department of Mathematics and Statistics | 
	| Credits: | 25.0 | 
	| Contact Hours: | 3.0 | 
|  | 
	| ** The tuition pattern below provides details of the types of classes and their duration. This is to be used as a guide only. For more precise information please check your unit outline. ** | 
|  | 
	| Lecture: | 1 x 1 Hours Weekly | 
	| Practical: | 1 x 2 Hours Weekly | 
|  | 
	| Syllabus: | Introduction to financial modeling, using real world models. The development process - understand, design, build, test, implement and maintain excel as a modelling tool. Design principles & the user interface. Workshop - design (benefit projection modelling). The analytical process (using workers compensation insurance as an example). Workshop - analysis (workers compensation insurance modelling). Completion - testing, security and maintenance. Introduction to modelling using VBA, and advanced VBA techniques. Working with data in excel. Stochastic asset/liability modeling. Workshop - stochastic (stochastic asset/liability modelling). | 
|  | 
	| ** To ensure that the most up-to-date information about unit references, texts and outcomes appears, they will be provided in your unit outline prior to commencement. ** | 
|  | 
  | Field of Education: | 81101 Banking and Finance | 
    | Funding Cluster: | 02 - Accounting, Administration, Economics, Commerce | 
    | SOLT (Online) Definitions*: | Informational *Extent to which this unit or thesis utilises online information
 | 
    | Result Type: | Grade/Mark | 
	| Availability | 
	| Availability Information has not been provided by the respective School or Area. Prospective students should contact the School or Area listed above for further information. |