Curricula Guides
x !
Archived Curricula Guide 2014–2016
Curricula Guide is archieved. Please refer to current Curricula Guides
LT013070 LRS25/TKM9 Financial modeling and simulation 6 ECTS
Organised by
Accounting and Finance
Person in charge
Mika Vaihekoski
Planned organizing times
Period(s) I II III IV
2015–2016 X
Preceding studies
Completion of the courses LR05, TKMY3, and TKM7/LRS22/KT35 Ekonometrian peruskurssi (Econometrics 1) or similar is strongly recommended.

Learning outcomes

The aim of the course is to deepen students' knowledge on the application of the financial theory in practice. Moreover, the course aims to teach students how to use Excel to solve financial questions and how to build financial models.

Contents

Building models with Excel for the questions in corporate finance, investment analysis, bond and stock pricing, portfolio management, derivatives, and simulation. Basics of Excel's Visual Basic for Applications macro language.

Teaching methods

Teaching method Contact Online
Lectures 24 h 0 h

Lectures/computer lab exercises 24 h in English (4 hours/week, Vaihekoski).

Modes of study

Option 1
Available for:
  • Degree Programme Students
  • Other Students
  • Doctoral Students
  • Exchange Students
Project / practical work
  • In English
Exercise(s)
  • In English
Participation in classroom work
  • In English

Home assignments and final project.

Evaluation and evaluation criteria

Numeric 0-5.
60% of the grade will be based on the home assignments and 40% of the grade will be based on the final project.

Recommended year of study

4th

THE COURSE IS OFFERED EVERY OTHER YEAR.

Study materials

1. VAIHEKOSKI, MIKA, Rahoitusalan sovellukset ja Excel. WSOY 2004 tai uudempi. 951-0-29067-X.
2. BENNINGA, SIMON, Financial Modeling. The MIT Press 2008 (3rd edition) or newer, 0262026287.
Supplementary material for the course.
Other material required and/or distributed by the lecturer.

Belongs to following study modules

Department of Accounting and Finance
Valinnaiset opinnot (Quantitative Methods in Management)
Department of Accounting and Finance
Department of Accounting and Finance
Department of Accounting and Finance
Turku School of Economics
Department of Accounting and Finance
Department of Accounting and Finance
Valinnaiset opintojaksot (Accounting and Finance)
Department of Accounting and Finance
Valinnaiset opintojaksot (Accounting and Finance)
Department of Accounting and Finance
Department of Accounting and Finance

Open enrolments

Dec 4, 2017 - Dec 17, 2017
2015–2016
Teaching
Archived Teaching Schedule. Please refer to current Teaching Shedule.
Implementation details are unavailable.
Department of Accounting and Finance
Accounting and Finance
Quantitative Methods in Management
Business Law