KTTA4150 Excel-applications in Finance (2 cr)

Contents

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

Course themes are related to the following UN Sustainable Development Goals:

SDG 4: Quality Education: Learning to apply Excel to financial models contributes to quality education by providing practical and applicable skills. Students gain proficiency in using a widely-used tool for financial analysis and decision-making.

SDG 8: Decent Work and Economic Growth: Proficiency in financial modeling enhances employability, especially in roles that require data analysis and financial decision-making skills. This can contribute to economic growth and the creation of decent jobs.

SDG 9: Industry, Innovation, and Infrastructure: Financial modeling skills contribute to innovation and efficiency in financial practices. This can be applied to infrastructure financing and investment decision-making, supporting sustainable development in various industries.

Completion

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):

-Problem-solving.

-Analytic, systematic thinking skills.

Benninga, S. 2008. Financial Modeling. The MIT Press.
AND/OR
Helbæk, M., Løvaas, R. and Mjølhus, J. 2013. Financial modelling and asset valuation with Excel. Routledge.