Financial Modelling

AY2019/2020 Semester 2

This course explicitly applies finance theories to solve various problems in financial management and investments. Microsoft Excel is a primary tool for implementation. The course enables students to perform financial analysis and to make financial decisions through financial models created with the use of Excel. Students will have ample opportunities to practice numerical analyses and graphical illustrations that arise out of applications in finance such as forecasting financial statement, estimating costs of capital, constructing efficient portfolio, computing covariance matrix, measuring value at risk, pricing options & real options, and fixed-income analytics. Though the course extensively uses Excel, its focus is still finance applications.