309022 (v.1) Practical Financial Modelling 502

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 modelling, using real world models. The development process - understand, design, build, test, implement and maintain. Using Excel as a modelling tool. Design principles and 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 modelling. 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:

010199 Mathematical Sciences not elsewhere classified

Funding Cluster:

04 - Mathematics, Statistics

SOLT (Online) Definitions*:

Informational
*Extent to which this unit or thesis utilises online information

Result Type:

Grade/Mark

Availability

Year	Location	Period	Internal	Partially Online Internal	Area External	Central External	Fully Online
2005	Bentley Campus	Semester 2	Y

Area External	refers to external course/units run by the School or Department or offered by research.
Central External	refers to external and online course/units run through the Curtin Bentley-based Distance Education Area
Partially Online Internal	refers to some (a portion of) learning provided by interacting with or downloading pre-packaged material from the Internet but with regular and ongoing participation with a face-to-face component retained. Excludes partially online internal course/units run through the Curtin Bentley-based Distance Education Area which remain Central External
Fully Online	refers to the main (larger portion of) mode of learning provided via Internet interaction (including the downloading of pre-packaged material on the Internet). Excludes online course/units run through the Curtin Bentley-based Distance Education Area which remain Central External