FINM4033

Course Descriptions

This course aims to help students learn the essential knowledge of using Excel spreadsheet functions and some software as decision-making tools for formulating suitable solutions to solve real-world financial and economic problems in the financial industry, and gain hands-on experience and professional skills of using Excel worksheet functions, pivot table, charts and VBA macros (Visual Basic Applications) for the practical implementation of financial models. It covers standard financial models in the areas of corporate finance, financial statement simulation, portfolio problems, option, portfolio insurance, duration, and immunisation.

Prerequisite

MATH1083 Calculus II

Workload

Workload not available

Modules

Modules not available