FINAN303-23G (HAM)

Computer Modelling in Finance

15 Points

Edit Header Content
The University of Waikato
Academic Divisions
Division of Management
School of Accounting, Finance and Economics

Staff

Edit Staff Content

Convenor(s)

Lecturer(s)

Administrator(s)

: denise.martin@waikato.ac.nz

Placement/WIL Coordinator(s)

Tutor(s)

Student Representative(s)

Lab Technician(s)

Librarian(s)

: yilan.chen@waikato.ac.nz

You can contact staff by:

  • Calling +64 7 838 4466 select option 1, then enter the extension.
  • Extensions starting with 4, 5, 9 or 3 can also be direct dialled:
    • For extensions starting with 4: dial +64 7 838 extension.
    • For extensions starting with 5: dial +64 7 858 extension.
    • For extensions starting with 9: dial +64 7 837 extension.
    • For extensions starting with 3: dial +64 7 2620 + the last 3 digits of the extension e.g. 3123 = +64 7 262 0123.
Edit Staff Content

What this paper is about

Edit What this paper is about Content
This paper enables students to understand financial modelling and its usefulness in financial decision making. It ensures that students have skills in financial problem solving from a corporate perspective using Excel functions and VBA.
Edit What this paper is about Content

How this paper will be taught

Edit How this paper will be taught Content
The objective of this paper is to equip students with financial modelling skills using a computer spreadsheet, including generic skills such as performing sensitivity analyses, running simulations and solving valuation problems in finance. The paper will also introduce students to more advanced programming techniques in financial modelling, including defining often used financial functions and performing complex tasks with Excel and VBA.
Edit How this paper will be taught Content

Required Readings

Edit Required Readings Content
https://rl.talis.com/3/waikato/lists/466463B8-0962-1C0C-35E6-42925DECD181.html
Edit Required Readings Content

You will need to have

Edit You will need to have Content

According to the university points system, students are expected to spend 150 hours in total on a 15-point paper.

The workload the paper places on you will depend on your preferences, what you want to achieve and the constraints you face.

Edit You will need to have Content

Learning Outcomes

Edit Learning Outcomes Content

Students who successfully complete the course should be able to:

  • Analyse, summarise and prepare raw data [LO2]
    Linked to the following assessments:
  • Apply, interpret and communicate the results of the models developed [LO4]
    Linked to the following assessments:
  • Develop simple computer models to solve financial problems [LO3]
    Linked to the following assessments:
  • Understand the principles of specific statistical techniques [LO1]
    Linked to the following assessments:
Edit Learning Outcomes Content
Edit Learning Outcomes Content

Assessments

Edit Assessments Content

How you will be assessed

Edit How you will be assessed Content
The application for special consideration can be found under Files. Further information is available at
http://www.waikato.ac.nz/sasd/examinations/exams3.shtml
Edit How you will be assessed Content

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0. There is no final exam. The final exam makes up 0% of the overall mark.

The internal assessment/exam ratio (as stated in the University Calendar) is 100:0 or 0:0, whichever is more favourable for the student. The final exam makes up either 0% or 0% of the overall mark.

Component DescriptionDue Date TimePercentage of overall markSubmission MethodCompulsory
1. Individual Assignment 1
1 Dec 2023
5:00 PM
30
  • Online: Submit through Moodle
2. Test 1
4 Dec 2023
5:00 PM
30
  • Online: Submit through Moodle
3. Test 2
13 Dec 2023
1:00 PM
30
  • Online: Submit through Moodle
4. Class Participation
15 Dec 2023
5:00 PM
10
  • In Class: In Lab
Assessment Total:     100    
Failing to complete a compulsory assessment component of a paper will result in an IC grade
Edit Assessments Content