Computer Applications in Finance (MAN411) Course Detail

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

Pre-requisite Course(s)
N/A

Course Language	English
Course Type	Elective Courses
Course Level	Bachelor’s Degree (First Cycle)
Mode of Delivery	Face To Face
Learning and Teaching Strategies	Lecture, Demonstration, 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; 1. Have proficiency in utilizing fundamental Excel formulas and functions for various calculations 2. Show competence in pricing financial securities, including T-bills, bonds, stocks, and others, using Excel 3. 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 4. 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. Beninga, S. (2014). Financial Modelling (4th Ed.) London, England: The MIT Press.

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	They acquire the skills to understand, explain, and use the basic concepts and methods of economics.
2	Acquires macro-economic analysis skills.
3	Acquire microeconomic analysis skills.
4	Understands the formulation and implementation of economic policies at local, national, regional and/or global levels.
5	Learn different approaches to the economy and economic issues.
6	Learn qualitative and quantitative research techniques in economic analysis.
7	Improving the ability to use modern software, hardware and/or other technological tools.
8	Develops intra-disciplinary and inter-disciplinary team work skills.
9	Contributes to open-mindedness by encouraging critical analysis, discussion, and/or lifelong learning.
10	Develops a sense of work ethics and social responsibility.
11	Develops communication skills.
12	Improving the ability to effectively apply knowledge and skills in at least one of the following areas: Economic policy, public policy, international economic relations, industrial relations, monetary and financial relations

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