KTTA4150 Excel-applications in Finance (2 cr)

Open the course unit brochure on Sisu

Study level:

Intermediate studies

Grading scale:

Pass - fail

Language:

Finnish

Responsible organisation:

Jyväskylä University School of Business and Economics

Curriculum periods:

2020-2021, 2021-2022, 2022-2023

Description

Contents

The course gives an introduction to modeling of financial models with Excel and covers corporate finance, portfolio models, option pricing and bonds.

Completion

Course is completed by self-studying the course literature and solving the required assignments.

Spring term, 4. period and summer.

Learning outcomes

At the end of the lecture course student is expected to be able to
- model basic financial models with Excel.
- analyze the empirical results.
- use Excel and VBA as tools to manipulate data.

Contents of the course are related to the following working life skills (generic skills):

-Problem-solving.

-Analytical thinking.

Description of prerequisites

Aineopintotason tiedot rahoituksesta. Kvantitatiiviset perusvalmiudet.

Study materials

Benninga, S. 2008. Financial Modeling. The MIT Press.
JA/TAI
Vaihekoski, M. 2004. Rahoitusalan sovellukset ja Excel. Wsoy.
JA/TAI
Helbæk, M., Løvaas, R. and Mjølhus, J. 2013. Financial modelling and asset valuation with Excel. Routledge.

Completion methods

Method 1

Evaluation criteria:

Independently done required assingments.

Time of teaching:

Period 5

Select all marked parts

Parts of the completion methods

Independent study (2 cr)

Type:

Independent study