TYPE OF COURSE UNIT	Elective Course
LEVEL OF COURSE UNIT	Bachelor's Degree
YEAR OF STUDY	-
SEMESTER	-
NUMBER OF ECTS CREDITS ALLOCATED	5
NAME OF LECTURER(S)	Assistant Professor Gökhan Kılıç
LEARNING OUTCOMES OF THE COURSE UNIT	At the end of this course, the students; 1) Make financial calculations using MS Excel program. 2) Make risk and return calculations using MS Excel program. 3) Analyze financial statements using MS Excel program. 4) Prepare financial statements using MS Excel program. 5) Do portfolio management using MS Excel program.
MODE OF DELIVERY	Face to face
PRE-REQUISITES OF THE COURSE	No
RECOMMENDED OPTIONAL PROGRAMME COMPONENT	None
COURSE DEFINITION	In this course, it is aimed that students will be able to make financial decisions using MS Excel and calculate the risks and returns of these decisions. For this purpose, the course covers MS Excel applications, analysis of financial statements, finance mathematics, portfolio management.
COURSE CONTENTS	WEEK TOPICS 1st Week Compound Annual Interest Calculations, Present Value Calculation, Choosing Different Payment Alternatives 2nd Week Calculation of Installment Amount for Loans, Repayment Table for Equal Installment Loans, Repayment Tables for Principal Equal Installment Loans 3rd Week Sensitivity Analysis 4th Week Break-even Analysis of Investments 5th Week The Importance of Break-even Analysis in Investments 6th Week Valuation Techniques in Investments 7th Week Investment Analysis Criteria and Application in Excel 8th Week Midterm 9th Week Discounted Cash Flow Models and Excel Applications 10th Week Portfolio Management in Excel 11th Week Portfolio Management in Excel 12th Week Portfolio Management in Excel 13th Week Portfolio Management in Excel 14th Week Portfolio Management in Excel
RECOMENDED OR REQUIRED READING	Lecture Notes
PLANNED LEARNING ACTIVITIES AND TEACHING METHODS	Lecture,Discussion,Questions/Answers,Presentation
ASSESSMENT METHODS AND CRITERIA	Quantity Percentage(%) Mid-term 1 30 Project 1 30 Total(%) 60 Contribution of In-term Studies to Overall Grade(%) 60 Contribution of Final Examination to Overall Grade(%) 40 Total(%) 100
ECTS WORKLOAD	Activities Number Hours Workload Midterm exam 1 1,5 1,5 Preparation for Quiz Individual or group work 14 3 42 Preparation for Final exam 1 40 40 Course hours 13 3 39 Preparation for Midterm exam 1 20 20 Laboratory (including preparation) Final exam 1 1,5 1,5 Homework Project 1 2 2 Total Workload 146 Total Workload / 30 4,86 ECTS Credits of the Course 5
LANGUAGE OF INSTRUCTION	Turkish
WORK PLACEMENT(S)	No