Course Information
SemesterCourse Unit CodeCourse Unit TitleT+P+LCreditNumber of ECTS CreditsLast Updated Date
3BNS 275Financial Applications with Excel2+0+02327.10.2026
Course Details
Language of Instruction Turkish
Level of Course Unit Associate Degree
Department / Program Banking and Insurance
Type of Program Formal Education
Type of Course Unit Elective
Course Delivery Method Face To Face
Objectives of the Course To teach the financial functions and analytical tools of Excel through practical applications, and to enable students to perform loan, bond, portfolio, and financial statement calculations using spreadsheets.
Course Content Basic and advanced spreadsheet functions. Financial functions: PMT, NPV, IRR, FV, and PV. Preparing loan amortization schedules. Bond valuation. Financial statement analysis. Portfolio return and risk calculations. Pivot tables and data analysis. Charts and reporting. Scenario and sensitivity analysis. Applied studies with banking and insurance data.
Course Methods and Techniques Hands-on instruction in the computer laboratory, practical applications with sample datasets, assignments, and examinations.
Prerequisites and co-requisities None
Course Coordinator None
Name of Lecturers Asist Prof.Dr.
Assistants None
Work Placement(s) No

Recommended or Required Reading
Resources Microsoft Excel online support and training resources (support.microsoft.com).

Course Category
Mathematics and Basic Sciences %80
Social Sciences %100

Planned Learning Activities and Teaching Methods
Activities are given in detail in the section of "Assessment Methods and Criteria" and "Workload Calculation"

Assessment Methods and Criteria
In-Term Studies Quantity Percentage
Mid-terms 1 % 40
Final examination 1 % 60
Total
2
% 100

 
ECTS Allocated Based on Student Workload
Activities Quantity Duration Total Work Load
Course Duration 14 2 28
Assignments 14 3 42
Mid-terms 1 8 8
Final examination 1 12 12
Total Work Load   Number of ECTS Credits 3 90

 
Course Learning Outcomes: Upon the successful completion of this course, students will be able to:
NoLearning Outcomes
1 Uses basic and advanced functions of spreadsheets.
2 Performs calculations using financial functions such as PMT, NPV, IRR, FV, and PV.
3 Prepares loan amortization schedules and conducts bond valuations.
4 Applies financial statement analysis as well as portfolio return and risk calculations in spreadsheets.
5 Analyzes and reports banking and insurance data using pivot tables, charts, scenario analysis, and sensitivity analysis.

 
Weekly Detailed Course Contents
WeekTopicsStudy MaterialsMaterials
1 Introduction to Spreadsheets and Basic Functions Reading Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
2 Advanced Functions: Logical, Lookup, and Reference Functions Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
3 Time Value of Money: FV and PV Functions Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
4 PMT Function and Annuity Calculations Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
5 Investment Evaluation using NPV and IRR Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
6 Preparing Loan Amortization Schedules Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
7 Bond Valuation Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
8 Midterm Exam
9 Financial Statement Analysis Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
10 Portfolio Return and Risk Calculations Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
11 Pivot Tables and Data Analysis Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
12 Charts and Reporting Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
13 Scenario and Sensitivity Analysis Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
14 Applied Studies with Banking and Insurance Data Students are expected to review in advance the topics covered in the previous week and those to be addressed in the upcoming week, utilizing printed and digital resources as well as online content. Benninga, S., Financial Modeling, MIT Press. Winston, W. L., Microsoft Excel Data Analysis and Business Modeling, Microsoft Press.
15 Final Examination

 
Recommended Optional Programme Components
BNS 249 Financial Modeling
Contribution of Learning Outcomes to Programme Outcomes
P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 P11 P12 P13 P14
All 3 4 3 5 2 2
C1
C2
C3
C4
C5

  Contribution: 1: Very Slight 2:Slight 3:Moderate 4:Significant 5:Very Significant