BFC5936 Financial modelling
Faculty of Business and Economics
BFC5936 Financial modelling is a level 5, 6-credit-point, postgraduate unit from the Faculty of Business and Economics, offered in 2024 in Semester 1 and Semester 2 at Clayton. It needs BFC5925 and BFC5935.
- Credit points
- 6
- Offered in 2024
- Semester 1, Semester 2
- Clayton
- Assessment
- No exam
- 1 task
- Workload
- 144 hours
- per semester
The 2027 handbook has no page for BFC5936. This is its 2024 entry, the latest one.
Reviews
No reviews yetNo reviews yet. Be the first to review BFC5936.
Requisites
Before BFC5936
Prohibitions
You can't enrol if you have passed any of these.
Prerequisites
Pass these before you enrol.
After BFC5936
No unit lists BFC5936 as a prerequisite in the 2024 handbook.
Enrolment rules
If you do not meet the prerequisites you must be granted permission by the Chief Examiner to undertake this unit.
Overview
This unit aims to develop your financial modelling skills using Excel. Topics include the development and application of financial spreadsheets, data and sensitivity analysis, portfolio optimisation, and financial models. The subject will also introduce you to Visual Basic programming in financial modelling.
Offerings in 2024
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| Second semester | Clayton | On campus |
Assessment
- Within semester assessment100%
Learning outcomes
When you finish this unit, you should be able to:
- 1
introduce the concept and principles of financial modelling and develop the skill set required.
- 2
use Excel to effectively model financial problems and handle financial data
- 3
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.
Workload and teaching
- Seminars12 hours
- Tutorials24 hours
- Teaching approachActive learning
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. You are expected to complete all pre-class activities prior to your scheduled class, and post-class activities should be completed after your scheduled class. Learning activities may include a combination of teacher directed, peer directed and online engagement activities.
This unit engages you in actively applying your knowledge, skills and attributes in interactive, collaborative and reflective activities.
Learning resources
Recommended resources
Financial Modeling by Simon Benninga is recommended
Contacts
- Chief Examiners
- Associate Professor Paul Lajbcygier
Common questions
What are the prerequisites for BFC5936?
You need BFC5925 and BFC5935 before you enrol. Enrolment rules also apply.
When is BFC5936 offered?
In 2024, BFC5936 runs in Semester 1 and Semester 2 at Clayton.
How much work is BFC5936?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does BFC5936 have an exam?
No. BFC5936 has 1 assessment task and no exam.