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.