KTTA4150 Excel-applications in Finance (2 cr)
The course gives an introduction to modeling of financial models with Excel and covers corporate finance, portfolio models, option pricing and bonds.
Course is completed by self-studying the course literature and solving the required assignments.
Spring term, 4. period and summer.
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):
Description of prerequisites
Vaihekoski, M. 2004. Rahoitusalan sovellukset ja Excel. Wsoy.
Helbæk, M., Løvaas, R. and Mjølhus, J. 2013. Financial modelling and asset valuation with Excel. Routledge.