FINC616-25S1 (C) Semester One 2025

Financial Modelling

15 points

Details:
Start Date: Monday, 17 February 2025
End Date: Sunday, 22 June 2025
Withdrawal Dates
Last Day to withdraw from this course:
  • Without financial penalty (full fee refund): Sunday, 2 March 2025
  • Without academic penalty (including no fee refund): Sunday, 11 May 2025

Description

Application of spreadsheet tools to financial decision-making and analysis

The main goal of this course is to combine a deeper understanding of selected topics in corporate finance and portfolio models with spreadsheet skills using EXCEL at a level appropriate for financial analysts.

Learning Outcomes

The objectives of the course are:
1. to have a deeper knowledge of financial analysis using EXCEL
2. to have in-depth knowledge of calculating weighted average cost of capital for a corporation
3. to have in-depth knowledge of building a pro forma financial model
4. to have in-depth knowledge of valuation based on the discounted cash flow approach
5. to have in-depth knowledge of portfolio analysis using EXCEL
6. to have a deeper knowledge of the Black-Litterman approach to portfolio optimisation
7. to be able to compute different Value at Risk measures
8. to be able to conduct event studies in finance using EXCEL
9. to be able to perform Monte Carlo simulations using EXCEL
10. to be able to effectively demonstrate how to present a problem/issue/situation/scenario

Prerequisites

Subject to approval of the Head of Department

Restrictions

Equivalent Courses

Timetable 2025

Students must attend one activity from each section.

Lecture A
Activity Day Time Location Weeks
01 Tuesday 11:00 - 12:00 A2 Lecture Theatre
17 Feb - 6 Apr
28 Apr - 1 Jun
Lecture B
Activity Day Time Location Weeks
01 Thursday 11:00 - 12:00 A2 Lecture Theatre
17 Feb - 6 Apr
28 Apr - 1 Jun
Computer Lab A
Activity Day Time Location Weeks
01 Friday 11:00 - 12:00 Rehua 008 Computer Lab
17 Feb - 6 Apr
28 Apr - 1 Jun
02 Friday 15:00 - 16:00 Ernest Rutherford 464 Computer Lab
17 Feb - 6 Apr
28 Apr - 1 Jun
03 Monday 10:00 - 11:00 Ernest Rutherford 464 Computer Lab
24 Feb - 6 Apr
28 Apr - 1 Jun
04 Monday 12:00 - 13:00 Ernest Rutherford 212 Computer Lab
24 Feb - 6 Apr
28 Apr - 1 Jun

Course Coordinator / Lecturer

Kuntal Das

Assessment

Assessment Due Date Percentage 
Assignments 10%
Group Project 25%
Lab Test 25%
Final Exam 40%


To pass this course you must not only achieve a final grade of 50% or higher, but also achieve a weighted average grade of at least 45% across all invigilated assessments.

Assessment In Te Reo Māori
In recognising that Te Reo Māori is an official language of New Zealand, the University provides for students who may wish to use Te Reo Māori in their assessment. If you intend to submit your work in Te Reo Māori you are required to do the following:

Read the Assessment in Te Reo Māori Policy and ensure that you meet the conditions set out in the policy.
This includes, but is not limited to, informing the Course Coordinator 1) no later than 10 working days after the commencement of the course that you wish to use Te Reo Māori and 2) at least 15 working days before each assessment due date that you wish to use Te Reo Māori.

Indicative Fees

Domestic fee $1,130.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-25S1 (C) Semester One 2025
Previous year