BFF5936 Financial modelling
Faculty of Business and Economics
BFF5936 Financial modelling is a level 5, 6-credit-point, postgraduate unit from the Faculty of Business and Economics, offered in 2027 in Semester 1 and Semester 2 at Caulfield. It needs BFC5925, BFC5935, BFF5925 or BFF5935.
- Credit points
- 6
- Offered in 2027
- Semester 1, Semester 2
- Caulfield
- Assessment
- Exam 50%
- and 1 other task
- Workload
- 144 hours
- per semester
Reviews
No reviews yetNo reviews yet. Be the first to review BFF5936.
Requisites
Before BFF5936
Prerequisites
Pass these before you enrol.
Prohibitions
You can't enrol if you have passed any of these.
After BFF5936
No unit lists BFF5936 as a prerequisite in the 2027 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.
Offerings in 2027
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Caulfield | On campus |
| Second semester | Caulfield | On campus |
Assessment
- Portfolio50%
- Examination50%
Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.
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 BFF5936.
Workload and teaching
- Tutorials12 hours
- Seminars24 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
Technology resources
There may be an additional cost associated with purchasing a physical and/or virtual calculator. Specific details will be provided in the Learning Management System by commencement of Orientation week.
Contacts
- Chief Examiners
- Associate Professor Paul Lajbcygier
Common questions
What are the prerequisites for BFF5936?
You need BFC5925, BFC5935, BFF5925 or BFF5935 before you enrol. Enrolment rules also apply.
When is BFF5936 offered?
In 2027, BFF5936 runs in Semester 1 and Semester 2 at Caulfield.
How much work is BFF5936?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does BFF5936 have an exam?
Yes. The exam is worth 50% of the final mark, alongside 1 other task.