This hands-on courses focus on how to use Microsoft Excel to implement the various financial models taught in the finance programme. Topics include financial statement analysis, leasing, efficient frontier estimation, beta estimation, bond pricing and duration, option pricing, Monte Carlo simulation, Risk models such as Value at Risk (VaR). Students will also learn how to use Macro and VBA in the course.

CILO-1: Collect, organize and classify real-world financial data. CILO-2: Develop appropriate financial models to analyze data. CILO-3: Interpret the results from the model analysis and draw appropriate conclusion and recommendation.