Olet täällä

Financial Modeling Using Excel

Financial Modeling Using Excel

Code: TOO2LK001E
Extent: 3 op
Timing: 2. Semester
Language: Finnish / English
Level: Professional studies
Type: Compulsory

Prerequisites

IT-Skills 1 and 2. Basics of Finance 1 and 2. Basic Excel skills is a must to be able to partisipate to the course.

Learning outcomes

Student knows the Excel from the financial perspective and is able to use it efficiently. Student is able to use the ready-made financial Excel functions and is able to explore and model for example the effect of the change of the coupon interest to the duration.

Contents

Course is as practical as possible and will have many different exercises, like:

  • Bond- and durationcalculators
  • Import values from external sources
  • Simple portfoliomanagement system
  • Currency position management system
  • REPO – calculators
  • DEPO – calculators

Due to the practical nature of the course a student must actively participate and do all the home exercises to be able to pass the exam at the end of the course.

Course materials

Lecture notes and other materials given by a teacher. Any basic financial Excel book is an asset.

Contact teachers

Christian Brade

Teaching and learning methods

Contact lessons, seft-study and exam.
The own learning assessment 1 h.

Accreditation of prior learning (APL)

Accreditation of prior learning (APL) is observed on the course according to separate instructions.

Assessment criteria

Students' performance is graded on the following scale: Excellent (5), Very good (4), Good (3), Satisfactory (2), Fair (1), Fail (0).

The assessment criterias are presented on scale 1 to 5.

Grade/
Object

1 (min. 40 %
of the objective)

3 (min. 70 %
of the objective)

5 (min. 90 %
of the objective)

Knowledge

Understands the basic concepts and principles of financial Excel.

Understands the concepts and principles of financial Excel.

Understands well the concepts and principles of financial Excel.

Skills

Is able to do some basic financial tasks using Excel.

Is able to do the basic financial tasks using Excel.

Is able to do many different financial tasks using Excel.

Competence

Acts well with Excel if gets some help.

Acts well with Excel without help.

Acts well and efficiently with Excel.

Assessment components and their respective weights

Examination 100 %
The assessment of one's own learning assignment does not impact your grade. The assignment is the same for all courses/modules and your answers will also be used for course/module development. The assignment is completed on an electronic form.