FINC616-21S1 (C) Semester One 2021

Financial Modelling

15 points

Details:
Start Date: Monday, 22 February 2021
End Date: Sunday, 27 June 2021
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Sunday, 7 March 2021
  • Without academic penalty (including no fee refund): Friday, 14 May 2021

Description

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

Pre-requisites

Subject to approval of the Head of Department

Restrictions

Equivalent Courses

Timetable 2021

Students must attend one activity from each section.

Lecture A
Activity Day Time Location Weeks
01 Wednesday 09:00 - 11:00 A6 Lecture Theatre
22 Feb - 4 Apr
26 Apr - 6 Jun
Computer Lab A
Activity Day Time Location Weeks
01 Friday 11:00 - 12:00 Ernest Rutherford 464 Computer Lab
22 Feb - 28 Mar
26 Apr - 6 Jun
02 Thursday 15:00 - 16:00 Jack Erskine 010 Computer Lab
22 Feb - 4 Apr
26 Apr - 6 Jun

Examination and Formal Tests

Test A
Activity Day Time Location Weeks
01 Tuesday 18:30 - 20:30 Ernest Rutherford 212 Computer Lab
29 Mar - 4 Apr
02 Tuesday 18:30 - 20:30 Rehua 008 Computer Lab
29 Mar - 4 Apr
03 Tuesday 18:30 - 20:30 Ernest Rutherford 464 Computer Lab
29 Mar - 4 Apr
Test B
Activity Day Time Location Weeks
01 Wednesday 18:30 - 20:30 Ernest Rutherford 464 Computer Lab
31 May - 6 Jun
02 Wednesday 18:30 - 20:30 Rehua 008 Computer Lab
31 May - 6 Jun
03 Wednesday 18:30 - 20:30 Ernest Rutherford 212 Computer Lab
31 May - 6 Jun

Course Coordinator

Kuntal Das

Assessment

Assessment Due Date Percentage  Description
Assignments 20% 2 x 10%
Final Exam 40%
Lab Test 20%
Lab Test 20%

Indicative Fees

Domestic fee $992.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-21S1 (C) Semester One 2021