Computer Applications in Finance (ISL411) Course Detail

Course Name	Course Code	Season	Lecture Hours	Application Hours	Lab Hours	Credit	ECTS
Computer Applications in Finance	ISL411	Area Elective	2	1	0	2.5	5

Pre-requisite Course(s)
N/A

Course Language	Turkish
Course Type	Elective Courses
Course Level	Bachelor’s Degree (First Cycle)
Mode of Delivery	Face To Face
Learning and Teaching Strategies	Lecture, Discussion, Drill and Practice.
Course Coordinator
Course Lecturer(s)	Asst. Prof. Dr. Naime USUL
Course Assistants
Course Objectives	This course focuses on pricing models for various financial instruments, including T-bills, bonds, stocks, and others, while also addressing methods for assessing their risk levels. Additionally, it provides instruction on employing basic statistical analysis techniques on financial data, encompassing time series and cross-sectional data, with practical application through computer software. Thus, it is an interactive course in financial modeling, primarily utilizing Microsoft Excel. Fundamental topics from introductory Finance courses are revisited and applied to reinforce proficiency in spreadsheet modeling.
Course Learning Outcomes	The students who succeeded in this course; Have proficiency in utilizing fundamental Excel formulas and functions for various calculations Show competence in pricing financial securities, including T-bills, bonds, stocks, and others, using Excel. Have ability to conduct basic statistical analysis on financial data, including the preparation of descriptive statistics for different data types such as time series and cross-section data Have capability to perform basic valuation and risk analysis on individual financial securities as well as portfolios.
Course Content	This course provides a foundational understanding for the practical application of financial theories using computer technology. Emphasizing the development of computer spreadsheet-based models, the course delves into interest calculations, financial instrument valuation, evaluation of financial projects, and the analysis of risk and return.

Weekly Subjects and Releated Preparation Studies

Week	Subjects	Preparation
1	Introduction to Excel	Basic features and interface of Excel should be understood.
2	Interest rate calculations-Continuous compounding	Formulas and methods for simple and compound interest calculations should be learned.
3	Present Value-Future Value Calculations	Basic concepts related to present value and future value calculations should be grasped.
4	IRR-MIRR-NPV	Calculations for internal rate of return, modified internal rate of return, and net present value should be researched.
5	Loan Amortization	Information on loan amortization calculations and methods should be gathered.
6	Loan Amortization Cont’d	Practical exercises on loan amortization should be conducted to reinforce applications.
7	Bond Valuation	Bond valuation techniques and methods should be learned.
8	Midterm	Previous topics should be reviewed and summarized for the midterm exam.
9	Bond Valuation Cont’d	Advanced information on bond valuation should be studied, and applications should be performed.
10	Stock Valuation	Methods and techniques for stock valuation should be learned.
11	Stock Valuation Cont’d	Applications and calculations related to stock valuation should be practiced.
12	Portfolio Theory- Calculating Efficient Portfolios	Information on portfolio theory and efficient portfolio calculations should be collected.
13	Estimating Beta and SML	Basic concepts related to beta estimation and the security market line should be learned.
14	CML and SML	Differences between the security market line and the capital market line should be understood.
15	CAPM application	Information on CAPM applications and calculations should be obtained.
16	Final Exam	All topics should be reviewed and revised in preparation for the final exam.

Sources

Course Book	1. İltir, C. (2021). Excelde Finans Uygulamaları, Seçkin Yayıncılık

Evaluation System

Requirements	Number	Percentage of Grade
Attendance/Participation	14	10
Laboratory	-	-
Application	2	30
Field Work	-	-
Special Course Internship	-	-
Quizzes/Studio Critics	-	-
Homework Assignments	-	-
Presentation	-	-
Project	-	-
Report	-	-
Seminar	-	-
Midterms Exams/Midterms Jury	1	25
Final Exam/Final Jury	1	35
Toplam	18	100

Percentage of Semester Work	65
Percentage of Final Work	35
Total	100

Course Category

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

The Relation Between Course Learning Competencies and Program Qualifications

#	Program Qualifications / Competencies	Level of Contribution
#	Program Qualifications / Competencies	1	2	3	4	5
1	Acquiring the skills of understanding, explaining, and using the fundamental concepts and methods of economics
2	Acquiring the skills of macro level economic analysis
3	Acquiring the skills of micro level economic analysis
4	Understanding the formulation and implementation of economic policies at the local, national, regional, and/or global level
5	Learning different approaches on economic and related issues
6	Acquiring the quantitative and/or qualitative techniques in economic analysis
7	Improving the ability to use the modern software, hardware and/or technological devices
8	Developing intra-disciplinary and inter-disciplinary team work skills
9	Acquiring an open-minded behavior through encouraging critical analysis, discussions, and/or life-long learning
10	Adopting work ethic and social responsibility
11	Developing the skills of communication.
12	Improving the ability to effectively implement the knowledge and skills in at least one of the following areas: economic policy, public policy, international economic relations, industrial relations, monetary and financial affairs.

ECTS/Workload Table

Activities	Number	Duration (Hours)	Total Workload
Course Hours (Including Exam Week: 16 x Total Hours)
Laboratory	14	3	42
Application	2	7	14
Special Course Internship
Field Work
Study Hours Out of Class	14	3	42
Presentation/Seminar Prepration
Project
Report
Homework Assignments
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury	1	13	13
Prepration of Final Exams/Final Jury	1	14	14
Total Workload			125