Academic Catalog

BA4839 FINANCIAL MODELING WITH SPREADSHEET

Course Code: 3124839
METU Credit (Theoretical-Laboratory hours/week): 3(3-0)
ECTS Credit: 6.0
Department: Business Administration
Language of Instruction: English
Level of Study: Undergraduate
Course Coordinator: Assoc.Prof.Dr. ÝLKAY ÞENDENÝZ YÜNCÜ
Offered Semester: Fall Semesters.
Prerequisite: Set 1: 3122802
Set 2: 3160381
Set 3: 3110311
Set 4: 3110312
Set 5: 3122803
Set 6: 3125802
Set 7: 9700521
One of the sets above should be completed before taking BA4839 FINANCIAL MODELING WITH SPREADSHEET .

Course Content

Provide students with the knowledge to apply the theories they have learned using spreadsheets. The students who know the essentials of corporate finance theories should also be able to solve the financial models numerically in order to enhance their knowledge in the field. The lecture includes models in the area of corporate finance, financial statement analysis, portfolio theory and duration. These models will be explained and then the models will be implemented numerically by using spreadsheets. This lecture will help the undergrad students to enhance their theoretical and practical knowledge related to the financial modelling.