BFF5255 Modelling in finance
Faculty of Business and Economics
BFF5255 Modelling in finance is a level 5, 6-credit-point, postgraduate unit from the Faculty of Business and Economics, offered in 2020 in Semester 1 and Semester 2 at Caulfield. It has no prerequisites and unlocks 1 unit.
- Credit points
- 6
- Offered in 2020
- Semester 1, Semester 2
- Caulfield
- Assessment
- No exam
- 1 task
- Workload
- 144 hours
- per semester
This is the 2020 handbook entry. See the 2023 entry.
Reviews
No reviews yetNo reviews yet. Be the first to review BFF5255.
Requisites
Before BFF5255
Prohibitions
You can't enrol if you have passed any of these.
After BFF5255
1 unit list BFF5255 as a prerequisite or corequisite.
Enrolment rules
Students must be enrolled in course B6001 or B6003.
Overview
This unit focuses on the skills and techniques required in financial modelling using Excel and VBA. Important financial models in corporate finance, investment and portfolio analysis, option valuations and risk management, and management and modification of databases for financial and investment analysis are discussed.
Offerings in 2020
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Caulfield | On campus |
| Second semester | Caulfield | On campus |
Assessment
- Within semester assessment100%
Learning outcomes
When you finish this unit, you should be able to:
- 1
develop skills in analyzing and handling raw data
- 2
design and implementation of financial models in the use of Excel and Visual Basic, and effectively summarize the assumptions, implications and results of spreadsheet models
- 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 BFF5255.
Workload and teaching
- Seminars36 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
Required resources
Students will need to be able to access a computer with Microsoft Excel in order to complete assessments in this unit.
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
- Dr Daniel Chai
Common questions
What are the prerequisites for BFF5255?
BFF5255 has no prerequisites, but enrolment rules apply.
What can I take after BFF5255?
BFF5255 is a prerequisite or corequisite for 1 unit, including BFF5340.
When is BFF5255 offered?
In 2020, BFF5255 runs in Semester 1 and Semester 2 at Caulfield.
How much work is BFF5255?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does BFF5255 have an exam?
No. BFF5255 has 1 assessment task and no exam.