Financial Spreadsheeting

Subject FNCE90026 (2011)

Note: This is an archived Handbook entry from 2011.

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

This subject has the following teaching availabilities in 2011:

April, Parkville - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period not applicable
Assessment Period End not applicable
Last date to Self-Enrol not applicable
Census Date not applicable
Last date to Withdraw without fail not applicable

September, Parkville - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period not applicable
Assessment Period End not applicable
Last date to Self-Enrol not applicable
Census Date not applicable
Last date to Withdraw without fail not applicable


Timetable can be viewed here. For information about these dates, click here.
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:
Semester 1, Semester 2
12.50
Semester 1, Semester 2
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/

Coordinator

Assoc Prof Howard Chan, Dr Jonathan Dark

Contact

Graduate School of Business and Economics
Level 4, 198 Berkeley Street
Telephone: +61 3 8344 1670
Online Enquiries
Web: www.gsbe.unimelb.edu.au


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.
Objectives: 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
Related Course(s): Master of Applied Finance

Download PDF version.