Financial Spreadsheeting

Subject FNCE90026 (2016)

Note: This is an archived Handbook entry from 2016.

Credit Points: 6.25
Level: 9 (Graduate/Postgraduate)
Dates & Locations:

This subject is not offered in 2016.
Time Commitment: Contact Hours: One 3-hour lecture per week for 6 weeks
Total Time Commitment:

Estimated total time commitment of 60 hours per semester
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.

Subject
Study Period Commencement:
Credit Points:
Not offered in 2016
12.50
Not offered in 2016
12.50
Corequisites:

None
Recommended Background Knowledge:

None
Non Allowed Subjects:

None
Core Participation Requirements:

For the purposes of considering requests for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Students Experiencing Academic Disadvantage Policy, academic requirements for this subject are articulated in the Subject Description, Subject Objectives, Generic Skills and Assessment Requirements for this entry.

The University is dedicated to provide support to those with special requirements. Further details on the disability support scheme can be found at the Disability Liaison Unit website: http://www.services.unimelb.edu.au/disability/

Contact

TBC

Subject Overview:

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.
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.
Assessment:
  • One 2-hour end-of-semester examination (50%)
  • Computer oriented assignments (50%)
Prescribed Texts:

You will be advised of prescribed texts by your lecturer.
Breadth Options:

This subject is not available as a breadth subject.
Fees Information: Subject EFTSL, Level, Discipline & Census Date
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

Download PDF version.