6 points, SCA Band 3, 0.125 EFTSL
Postgraduate - Unit
Refer to the specific census and withdrawal dates for the semester(s) in which this unit is offered.
- Second semester 2019 (On-campus)
Students must have passedand or equivalent, or be granted permission by the Chief Examiner to undertake this unit.
This unit aims to develop students' financial modelling skills using Excel. Topics include the development and application of financial spreadsheets, solving valuation problems in finance, data and sensitivity analysis, portfolio optimisation, simulations, and financial models. The paper will also introduce students to Visual Basic programming in financial modelling.
The learning goals associated with this unit are to:
- introduce the concept and principles of financial modelling and develop the skill set required.
- use Excel to effectively model financial problems and handle financial data
- apply critical thinking, problem solving and presentation skills to individual and/or group activities dealing with modelling in finance and demonstrate in an individual summative assessment task the acquisition of a comprehensive understanding of the topics covered in BFC5936.
Within semester assessment: 60% + Examination: 40%
Minimum total expected workload to achieve the learning outcomes for this unit is 144 hours per semester typically comprising a mixture of scheduled learning activities and independent study. Independent study may include associated readings, assessment and preparation for scheduled activities. The unit requires on average three/four hours of scheduled activities per week. Scheduled activities may include a combination of teacher directed learning, peer directed learning and online engagement.
See also Unit timetable information