Financial Modelling
BASIC DATA
course listing
A - main register
course code
MEF3010
course title in Estonian
Finantsmodelleerimine
course title in English
Financial Modelling
course volume CP
-
ECTS credits
6.00
to be declared
yes
assessment form
Examination
teaching semester
spring 1
language of instruction
Estonian
English
Study programmes that contain the course
code of the study programme version
course compulsory
TVTB12/25
no
Structural units teaching the course
ME - Department of Economics and Finance
Course description link
Timetable link
View the timetable
Version:
VERSION SPECIFIC DATA
course aims in Estonian
Anda ülevaade finantsmodelleerimise põhimõtetest, vahenditest ning rakendamise võimalustest rahanduse probleemide kontekstis; arendada üliõpilase finantsmodelleerimise oskusi.
course aims in English
To provide an overview of financial modelling principles, tools and application possibilities in the context of finance problems; to develop students' financial modelling skills.
learning outcomes in the course in Est.
Üliõpilane:
- omab ülevaadet finantsmodelleerimise põhimõtetest, selleks kasutatavatest vahenditest ning nende rakendamise võimalustest rahanduse probleemide kontekstis;
- oskab finantsmodelleerimise tehnikaid praktikas rakendada.
learning outcomes in the course in Eng.
The student:
- has an overview of financial modelling principles, financial modelling tools and their application possibilities in the context of finance problems;
- is able to apply financial modelling techniques in practice.
brief description of the course in Estonian
Modelleerimise põhimõtted - mudeli disain; stuktuur ja planeerimine; mudeli loomine; tulemuste presenteerimine; mudeli kontroll. Finantsmodelleerimises kasutatavad Exceli abivahendid ja nende rakendused - finantsfunktsioonid; Goal Seek ja Solver (sh optimaalse investeeringute portfelli koostamine); maatriksid, muud funktsioonid ning risttabelid; analüüsi pakett. Finantsplaanide ja ettevõtte väärtuse modelleerimine Excelis - kasumiaruande prognoos; bilansi prognoos; rahavoogude prognoos; finantssuhtarvude prognoos; vaba rahavoo prognoos (FCFF, FCFE); ettevõtte väärtuse hindamine vaba rahavoo, varade ning väärtussuhtarvude abil. Riski modelleerimine ja simulatsioonid Excelis. Tehniline analüüs, aktsiate tootlus, portfelli tootlus, riski modelleerimine, intressimäära ja võlakirja hinna modelleerimine.
brief description of the course in English
Principles of modelling - model design; model structure and planning; model building; presentation of results; model auditing. Excel tools used in financial modelling and their applications - financial functions (incl. present and future value calculations, investment project appraisal indicators, loan repayment schedule); Goal Seek and Solver; matrix calculations, other functions and pivot tables; analysis toolpack. Modelling of financial plans and company value in Excel - income statement forecasting, balance sheet forecasting; cash flow forecasting; forecasted financial ratios; free cash flow forecasting (FCFF, FCFE); company valuation based on free cash flow, assets and enterprise value multiples. Risk modelling and simulations in Excel. Technical analysis, stock returns, portfolio returns, risk modelling, modelling of interest rates and bond prices.
type of assessment in Estonian
-
type of assessment in English
-
independent study in Estonian
koduste ülesannete lahendamine, materjalide lugemine
independent study in English
solving home assignments, reading materials
study literature
"Rees, M. ""Financial Modelling in Practice : A Concise Guide for Intermediate and Advanced Level "", 2011, Wiley
Ang, C.S. ""Analyzing Financial Data and Implementing Financial Models Using R "", 2015, Springer"
study forms and load
daytime study: weekly hours
5.0
session-based study work load (in a semester):
lectures
0.0
lectures
-
practices
0.0
practices
-
exercises
5.0
exercises
-
lecturer in charge
-
LECTURER SYLLABUS INFO
semester of studies
teaching lecturer / unit
language of instruction
Extended syllabus or link to Moodle or to home page
2024/2025 spring
Tõnn Talpsepp, ME - Department of Economics and Finance
English
    display more
    2023/2024 spring
    Tõnn Talpsepp, ME - Department of Economics and Finance
    English
      MEF3010 extended syllabus.pdf 
      2022/2023 spring
      Tõnn Talpsepp, ME - Department of Economics and Finance
      English
        MEF3010 extended syllabus.pdf 
        2021/2022 spring
        Tõnn Talpsepp, ME - Department of Economics and Finance
        English
          Assessment criteria_MEF3010_Eng.pdf 
          Course description in Estonian
          Course description in English