COURSE INTRODUCTION AND APPLICATION INFORMATION


Course Name
Financial Modelling
Code
Semester
Theory
(hour/week)
Application/Lab
(hour/week)
Local Credits
ECTS
FIN 605
Fall
3
0
3
10
Prerequisites
None
Course Language
English
Course Type
Required
Course Level
Third Cycle
Course Coordinator
Course Lecturer(s) -
Assistant(s) -
Course Objectives This course covers the frameworks and tools necessary to build advanced spreadsheet models for financial decision making. It is focused predominately on providing basic to intermediate financial modeling skills using Microsoft Excel and is specifically biased to those individuals seeking to learn new skills and develop a new understanding of financial modeling.
Learning Outcomes The students who succeeded in this course;
  • will be able to use Excel and similar spreadsheet programs in financial applications.
  • will be able to do financial models with the help of basic programming skills.
  • will be able to analyze the data by financial modeling.
  • will be able to do portfolio management and estimation, capital budgeting and risk measurement.
  • will be able to use data tables, scenario manager, database operations, pivot tables and charts, and other statistical builtin functions.
Course Content The financial models covered include portfolio management and estimation, capital budgeting, risk measurement, discounted cash flow models, and pricing of options. Basic financial concepts necessary to understand these models will be reviewed. Useful spreadsheet features such as data tables, scenario manager, database operations, pivot tables and charts, and other statistical builtin functions will be reviewed.

 



Course Category

Core Courses
Major Area Courses
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

 

WEEKLY SUBJECTS AND RELATED PREPARATION STUDIES

Week Subjects Related Preparation
1 Review of the Semester  
2 Review of the Semester  
3 Review of the Semester  
4 Review of the Semester  
5 Review of the Semester  
6 Review of the Semester  
7 Review of the Semester  
8 Review of the Semester  
9 Review of the Semester  
10 Review of the Semester  
11 Review of the Semester  
12 Review of the Semester  
13 Review of the Semester  
14 Review of the Semester  
15 Review of the Semester  
16 Review of the Semester  
Course Textbooks
References

 

EVALUATION SYSTEM

Semester Requirements Number Percentage
Participation
Laboratory / Application
Field Work
Quizzes / Studio Critiques
Homework / Assignments
Presentation / Jury
Project
Seminar / Workshop
Midterms / Oral Exams
Final / Oral Exam
Total

Contribution of Semester Work to Final Grade
Contribution of Final Work to Final Grade
Total

ECTS / WORKLOAD TABLE

Activities Number Duration (Hours) Workload
Course Hours
Including exam week: 16 x total hours
16
0
Laboratory / Application Hours
Including exam week: 16 x total hours
16
Study Hours Out of Class
Field Work
Quizzes / Studio Critiques
Homework / Assignments
Presentation / Jury
Project
Seminar / Workshop
Midterms / Oral Exams
Final / Oral Exam
    Total
0

 

COURSE LEARNING OUTCOMES AND PROGRAM QUALIFICATIONS RELATIONSHIP

#
Program Qualifications / Outcomes
* Level of Contribution
1
2
3
4
5
1 Developing scientific expertise and capabilities in the field of finance through using creative and critical thinking and research skills; innovatively contribute to the discipline by new ideas and definitions based on the graduate level qualifications.
2 Comprehending the interaction across various disciplines related to the field of finance, reaching at original conclusions by using new and complex analysis, synthesis and evaluation skills.
3 Developing and championing new approaches to contribute the field of finance through apprehending the research methods.
4 Contributing to the science of finance through developing new methods or implementing an existing method to a different field through investigating, comprehending, designing original topics.
5 Conducting independent research, analyzing scientific phenomenon through broad, deep and critical perspective, arriving at new syntheses and evaluations in the discipline of finance.
6 Publishing scientific articles in reputable refereed national and international journals, presenting papers in scientific conferences in the field of finance and its sub-disciplines.
7 Following, attending and organizing national and international events such as conferences, seminars and panels to keep up with developments and create new solutions to the problems in the field of finance.
8 Following pioneering and innovative theories and methods in the field of finance and implementing them in analysis and research.
9 Developing creative solutions to the social, scientific and ethical issues within the scope of finance and business life and extending values that supports these solutions.
10 Being able to use English fluently for both comprehending and publishing scientific publications and developing proper communication.

*1 Lowest, 2 Low, 3 Average, 4 High, 5 Highest

 

İzmir Ekonomi Üniversitesi | Sakarya Caddesi No:156, 35330 Balçova - İZMİR Tel: +90 232 279 25 25 | webmaster@ieu.edu.tr | YBS 2010