Use the Tab and Up, Down arrow keys to select menu items.
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.
At the end of this course, a successful student will be able to:apply methods and models for discounting for time and risk in valuationuse mean-variance analysis to model the diversification of risk and asset pricingapply spreadsheet methodology to event studies and measuring Value at Riskapply 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
Students must attend one activity from each section.
Domestic fee $1,037.00
International Postgraduate fees
* 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