CO3105:03
Financial Modelling
| Townsville, Cairns | HECS Band 2 |
26 hours lectures, 12 hours tutorials, 12 hours workshops. Semester 1.
This subject will focus on the principles and practice of financial modelling; the design and development of computer-based financial models for planning, control and decision making in the accounting and finance environment. Emphasis will be placed on the learning of the effective and efficient use of applications software in accounting and finance, especially spreadsheets.
Learning Objectives:
- ability to understand and apply the general principles of financial modelling;
- ability to develop a sound knowledge and understanding of the features of the Microsoft Excel electronic spreadsheet software package in terms of modelling financial/business strategies;
- ability to demonstrate competence at an advanced level in the design of financial models in a spreadsheet environment, including defined input areas, validating input and simple navigation;
- ability to understand the fundamentals of relational databases and demonstrate an ability to create a relational database using MS Access at an introductory level.
Assessment by mid-semester test (20%); submitted assignments and projects (40%); end-of-semester examination (40%).