Course Aim

This course is designed to

  •   enhance some basic knowledge in excel
  •   master financial mathematics concepts learned in MFM2123 in excel.

Intended Learning Outcomes:

By the end of this course, the students should be able to calculate the prices of a swaps in excel:

  • calculate forward interest rates in excel
  • deal with Futures and foreign exchange bond in excel
  • handle various types of options in risk management using excel.