Applied financial modelling focuses primarily on modelling for corporate financial decisions using excel in a lab setting. It is expected to cover the use of most built-in excel financial functions, some macros, and several essential utilities such as conditional formatting, goal seek, data tables, pivot tables, power pivot and data utilities, solver, random numbers, arrays, and matrix operations for financial decision making. The course is expected to require significant cooperative work in groups, use of approved online resources such as Bloomberg terminals, company reports, cases and Microsoft Excel. Weekly hours: 3 Lecture hoursPermission of the department required. Prerequisite(s): COMM 363.3 and COMM 367.3.
Applied financial modelling focuses primarily on modelling for corporate financial decisions using excel in a lab setting. It is expected to cover the use of most built-in excel financial functions, some macros, and several essential utilities such as conditional formatting, goal seek, data tables, pivot tables, power pivot and data utilities, solver, random numbers, arrays, and matrix operations for financial decision making. The course is expected to require significant cooperative work in groups, use of approved online resources such as Bloomberg terminals, company reports, cases and Microsoft Excel. Weekly hours: 3 Lecture hoursPermission of the department required. Prerequisite(s): COMM 363.3 and COMM 367.3.
