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 2020 in Semester 1, Winter and Semester 2 at Clayton. It needs BFC5925 and BFC5935 and unlocks 1 unit.
- Credit points
- 6
- Offered in 2020
- Semester 1, Winter, Semester 2
- Clayton
- Assessment
- No exam
- 1 task
- Workload
- 144 hours
- per semester
This is the 2020 handbook entry. See the 2024 entry.
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
1 unit list BFC5936 as a prerequisite or corequisite.
Enrolment rules
Students who have not passed BFC5925 and BFC5935 must be granted permission by the Chief Examiner to undertake this unit.
Overview
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.
Offerings in 2020
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| Winter semester (Extended) | 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
- Lectures12 hours
- Laboratories24 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. 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.
Learning resources
Recommended resources
Financial Modeling” by Simon Benninga is recommended
Technology resources
The only Faculty approved calculators permitted in tests and examinations for all Australian campuses and locations is the HP10bII+ or Casio FX82 (any suffix).
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.
What can I take after BFC5936?
BFC5936 is a prerequisite or corequisite for 1 unit, including BFF5340.
When is BFC5936 offered?
In 2020, BFC5936 runs in Semester 1, Winter 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.