Your transaction is in progress.
Please Wait...
Course Details
KTO KARATAY UNIVERSITY
İktisadi, İdari ve Sosyal Bilimler Fakültesi
Programme of Business Administration
Course Details
Course Code Course Name Year Period Semester T+A+L Credit ECTS
00971322 Financial Modeling by Excel 4 Autumn 7 3+0+0 4 4
Course Type Elective
Course Cycle Bachelor's (First Cycle) (TQF-HE: Level 6 / QF-EHEA: Level 1 / EQF-LLL: Level 6)
Course Language Turkish
Methods and Techniques -
Mode of Delivery Face to Face
Prerequisites -
Coordinator Prof. Osman OKKA
Instructor(s) -
Instructor Assistant(s) -
Course Content
The course begins with an introduction to the basic functions of Excel for financial modelling. Analysing financial statements, editing data, creating formulas and effective use of Excel functions are covered. Modelling of financial statements such as balance sheet, income statement and cash flow statement, ratio analysis, trend analysis, forecasting models, budgeting, risk analysis and sensitivity analysis are focused. Students learn scenario analysis, financial projections, company valuation models and data visualisation techniques in Excel. This content helps students to develop Excel-based financial modelling skills and to analyse financial analyses they may encounter in business life.
Objectives of the Course
This course aims to teach students financial modelling processes through Excel applications. It is aimed to develop basic financial modelling techniques and Excel skills to support financial decision making and analysis processes. Students learn to create financial models such as financial statement analysis, cash flow forecasting, budgeting, valuation, risk analysis. This course provides competencies in financial analysis, data visualisation and simulating complex financial situations.
Contribution of the Course to Field Teaching
Basic Vocational Courses
Specialization / Field Courses
Support Courses X
Transferable Skills Courses
Humanities, Communication and Management Skills Courses
Weekly Detailed Course Contents
Week Topics
1 Introduction and Basic Functions of Excel for Financial Modelling
2 Modelling of Financial Statements: Balance Sheet
3 Modelling of Financial Statements: Income Statement
4 Modelling of Financial Statements: Statement of Cash Flows
5 Ratio Analyses and Financial Performance Indicators
6 Forecasting Models and Trend Analysis
7 Midterm Exam and Application Study
8 Budgeting and Financial Projections
9 Valuation Models: Discounted Cash Flow (DCF) Analysis
10 Sensitivity Analysis and Scenario Analysis
11 Risk Analysis and Monte Carlo Simulation
12 Data Visualisation and Presentation with Graphics
13 Macros and Automation
14 Comprehensive Project Study and Implementation
Textbook or Material
Resources Finansal Modelleme - Excel Anlatımlı/Serdar Kaya
Evaluation Method and Passing Criteria
In-Term Studies Quantity Percentage
Attendance - -
Laboratory - -
Practice - -
Field Study - -
Course Specific Internship (If Any) - -
Homework - -
Presentation - -
Projects - -
Seminar - -
Quiz - -
Listening - -
Midterms 1 40 (%)
Final Exam 1 60 (%)
Total 100 (%)
ECTS / Working Load Table
Quantity Duration Total Work Load
Course Week Number and Time 14 3 42
Out-of-Class Study Time (Pre-study, Library, Reinforcement) 14 4 56
Midterms 1 12 12
Quiz 0 0 0
Homework 0 0 0
Practice 0 0 0
Laboratory 0 0 0
Project 0 0 0
Workshop 0 0 0
Presentation/Seminar Preparation 0 0 0
Fieldwork 0 0 0
Final Exam 1 10 10
Other 0 0 0
Total Work Load: 120
Total Work Load / 30 4
Course ECTS Credits: 4