1. FIRST CYCLE - BACHELOR'S DEGREE
  2. FACULTY OF ECONOMICS & ADMINISTRATIVE SCIENCES
  3. BUSINESS ADMINISTRATION DEPARTMENT
  4. 201 BUSINESS ADMINISTRATION
Course Information Course Learning Outcomes Course's Contribution To Program ECTS Workload Course Details
Print

COURSE INFORMATION
Course CodeCourse TitleL+P HourSemesterECTS
UTFB 327APPLIED FINANCIAL ANALYSIS3 + 07th Semester5

COURSE DESCRIPTION
Course Level Bachelor's Degree
Course Type Elective
Course Objective This course aims to apply corporate finance and capital market methods using Microsoft Excel functions and calculation procedures within the framework of the basic principles of finance theory.
Course Content Basic Use of Microsoft Excel, Use of Financial Functions, Time Value of Money Applications, Capital Budgeting Methods, Financial Analysis Techniques, Analysis of Capital and Money Market Instruments
Prerequisites ISLE 329 FINANCIAL MANAGEMENT - I
ve ISLE 330 FINANCIAL MANAGEMENT - II
Corequisite No the corequisite of lesson.
Mode of Delivery Face to Face

COURSE LEARNING OUTCOMES
1To have knowledge about the basic use and functions of Microsoft Excel
2Practically using Microsoft Excel for various financial problems and needs.

COURSE'S CONTRIBUTION TO PROGRAM
Data not found.

ECTS ALLOCATED BASED ON STUDENT WORKLOAD BY THE COURSE DESCRIPTION
ActivitiesQuantityDuration (Hour)Total Work Load (Hour)
Course Duration (14 weeks/theoric+practical)14342
Hours for off-the-classroom study (Pre-study, practice)14342
Assignments166
Mid-terms12020
Final examination12020
Total Work Load

ECTS Credit of the Course





130

5
COURSE DETAILS
 Select Year   


 Course TermNoInstructors
Details 2023-2024 Fall1İLHAN KÜÇÜKKAPLAN
Details 2023-2024 Fall1OSMAN VAROL


Print

Course Details
Course Code Course Title L+P Hour Course Code Language Of Instruction Course Semester
UTFB 327 APPLIED FINANCIAL ANALYSIS 3 + 0 1 Turkish 2023-2024 Fall
Course Coordinator  E-Mail  Phone Number  Course Location Attendance
Prof. Dr. İLHAN KÜÇÜKKAPLAN ikkaplan@pau.edu.tr İİBF A0017 %70
Goals This course aims to apply corporate finance and capital market methods using Microsoft Excel functions and calculation procedures within the framework of the basic principles of finance theory.
Content Basic Use of Microsoft Excel, Use of Financial Functions, Time Value of Money Applications, Capital Budgeting Methods, Financial Analysis Techniques, Analysis of Capital and Money Market Instruments
Topics
WeeksTopics
1 General Excel Interface
2 Basic Functions and Uses
3 Financial Ratios
4 Time Value of Cash Flows-1
5 Time Value of Cash Flows-2
6 Interest Concept and Calculations
7 Annuity Calculations
8 Capital Budgeting Methods-1
9 Capital Budgeting Methods-2
10 Maturity and Date Calculations
11 Analysis of Money Market Instruments
12 Analysis of Capital Market Instruments-2
13 Analysis of Capital Market Instruments-2
14 Portfolio Theory
Materials
Materials are not specified.
Resources
Course Assessment
Assesment MethodsPercentage (%)Assesment Methods Title
Final Exam60Final Exam
Midterm Exam40Midterm Exam
L+P: Lecture and Practice
PQ: Program Learning Outcomes
LO: Course Learning Outcomes