ECTS - Computer Applications in Finance
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 Lecturer(s) |
|
| 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;
|
| 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 | |
|---|---|
| Major Area Courses | X |
| 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 | ||||
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 | ||
| 1 | Gains the ability to use knowledge by acquiring conceptual and practical understanding of all core functions of business. | |||||
| 2 | Identifies problems related to the field of business and effectively uses scientific approaches in problem-solving and decision-making processes. | X | ||||
| 3 | Demonstrates and analyzes the environmental, social, global impacts and legal consequences of practices related to core business functions. | |||||
| 4 | Analyzes information and reports relevant to businesses at national, regional, and global levels, and sets strategic goals based on the results obtained. | |||||
| 5 | Gains the ability to use, report, and interpret Business Information Systems and their sub-modules required for business management. | X | ||||
| 6 | Plans the necessary activities such as taking risks, securing resources, conducting market analysis, and preparing business plans for starting a new venture and ensuring its sustainability with innovative and creative thinking, and applies the acquired knowledge accordingly. | |||||
| 7 | Supports oneself and the organization in terms of innovation and continuous improvement, while being aware that the process of research and learning is lifelong and following scientific and technological developments related to business. | X | ||||
| 8 | Acquires the necessary leadership and managerial skills to achieve business objectives effectively and efficiently. | |||||
| 9 | Conducts scientific research in the field of business and reports the research findings to be used in managerial decision-making processes. | X | ||||
| 10 | Uses effective verbal, written, and visual communication methods to convey information related to the field of business in the language of instruction and professional English. | |||||
| 11 | Develops awareness of professional ethics, environmental sensitivity, sustainability, social responsibility, and cultural, societal, and universal values. | |||||
| 12 | Takes initiative in working effectively with different disciplines or multicultural teams, assuming responsibility, conducting risk analysis, adapting to change, and applying critical thinking and problem-solving skills. | X | ||||
| 13 | . | |||||
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 | ||