FINC616-23S1 (C) Semester One 2023

Financial Modelling

15 points

Start Date: Monday, 20 February 2023
End Date: Sunday, 25 June 2023
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Sunday, 5 March 2023
  • Without academic penalty (including no fee refund): Sunday, 14 May 2023


Application of spreadsheet tools to financial decision-making and analysis

This course is designed to equip students with a deeper understanding of selected topics in corporate finance and portfolio models with spreadsheet skills at a level appropriate for financial analysts.

Learning Outcomes

  • At the end of this course, a successful student will be able to:
  • apply methods and models for discounting for time and risk in valuation

  • use mean-variance analysis to model the diversification of risk and asset pricing

  • apply spreadsheet methodology to event studies and measuring Value at Risk

  • apply spreadsheet functions and VBA (Visual Basic for Applications) in finance
  •  apply modelling techniques to finance, including sensitivity analysis, goal seeking, simulation and optimisation
  •  effectively present a problem/issue/situation/scenario


Subject to approval of the Head of Department


Equivalent Courses


Alan Stent


Assessment Due Date Percentage  Description
Assignment 5% Posted week 9, due week 10.
Assignments 5% posted week 3, due week 4.
Extra assignment 15% Posted wek 5, due week 9.
Final Exam 35%
Lab Test 20%
Lab Test 20%

Indicative Fees

Domestic fee $1,037.00

* All fees are inclusive of NZ GST or any equivalent overseas tax, and do not include any programme level discount or additional course-related expenses.

For further information see Department of Economics and Finance .

All FINC616 Occurrences

  • FINC616-23S1 (C) Semester One 2023