Handbook home
Financial Spreadsheeting (FNCE90026)
Graduate courseworkPoints: 6.25Not available in 2019
Overview
Fees | Look up fees |
---|
MS Excel features including formulae and ranges, altering worksheet appearance, workbook management, transferring data, analysis and manipulation tools. Visual Basic for Applications including user defined functions and macros. Application of programming to a range of financial problems.
Intended learning outcomes
On successful completion of this subject students should be able to:
- Use many of the advanced, built-in features of Microsoft Excel;
- Explain the principles of object orientated programming;
- Integrate various programming structures and concepts to build complex programs;
- Design computer programs that implement solutions in an efficient and effective manner;
- Apply financial modelling techniques to a variety of problems in finance;
- Implement various finance modelling algorithms in the form of Visual Basic for Applications programs.
Generic skills
On successful completion of this subject, students should have improved the following generic skills:
- Oral communication
- Written communication
- Collaborative learning
- Problem solving
- Team work
- Statistical reasoning
- Application of theory to practice
- Interpretation & analysis
- Critical thinking
- Synthesis of data and other information
- Evaluation of data and other information
- Using computer software
- Accessing data and other information from a range of sources
Last updated: 3 November 2022
Eligibility and requirements
Prerequisites
FNCE90019 Principles of Finance, FNCE90020 Derivative Securities (may be taken concurrently with this subject). This subject is only available to those students who would satisfy the entry criteria for the Master of Applied Finance.
Code | Name | Teaching period | Credit Points |
---|---|---|---|
FNCE90019 | Principles of Finance | Not available in 2024 |
12.5 |
FNCE90020 | Derivative Securities | Not available in 2024 |
12.5 |
Corequisites
None
Non-allowed subjects
None
Inherent requirements (core participation requirements)
The University of Melbourne is committed to providing students with reasonable adjustments to assessment and participation under the Disability Standards for Education (2005), and the Assessment and Results Policy (MPF1326). Students are expected to meet the core participation requirements for their course. These can be viewed under Entry and Participation Requirements for the course outlines in the Handbook.
Further details on how to seek academic adjustments can be found on the Student Equity and Disability Support website: http://services.unimelb.edu.au/student-equity/home
Last updated: 3 November 2022
Assessment
Additional details
- One 2-hour end-of-semester examination (50%)
- Computer oriented assignments (50%)
Last updated: 3 November 2022
Dates & times
Not available in 2019
Time commitment details
Estimated total time commitment of 85 hours per semester
Last updated: 3 November 2022
Further information
- Texts
Prescribed texts
You will be advised of prescribed texts by your lecturer.
- Available through the Community Access Program
About the Community Access Program (CAP)
This subject is available through the Community Access Program (also called Single Subject Studies) which allows you to enrol in single subjects offered by the University of Melbourne, without the commitment required to complete a whole degree.
Entry requirements including prerequisites may apply. Please refer to the CAP applications page for further information.
- Available to Study Abroad and/or Study Exchange Students
This subject is available to students studying at the University from eligible overseas institutions on exchange and study abroad. Students are required to satisfy any listed requirements, such as pre- and co-requisites, for enrolment in the subject.
Last updated: 3 November 2022