MFIN6002A
Spreadsheet Modelling in Finance
Chau, Michael
General Information
This course is intended to introduce spreadsheet (MS Excel) as a financial modeling tool and understand its capabilities and limitations. It is designed to teach students to apply Visual Basic for Applications (VBA) to automate spreadsheet applications and extend the functionality of the spreadsheet. Numerical derivative pricing by implementing models in VBA will be illustrated. Examples include Black-Scholes formula, Greeks Parameters, Binomial Tree and Monte Carlo Methods. Statistical computations with application to Risk Management will also be demonstrated. This course will also explore to optimize the computational power of Excel through the C API.
Extra Information
Re-titled from “Computer Concepts, Programming and Applications” to “Spreadsheet Modelling in Finance” with effect from 2007-08 academic year.
Tags: Chau, Courses, Excel, Extra, Faculty of Economics, formula, Hong Kong, MFin, Monte Carlo Methods, programming, Scholes, University of Hong Kong
Category : University of Hong Kong
Leave a Reply
MFIN7012A
Fixed Income Securities & Interest Rate Modelling
General Information
“Fixed Income Securities” covers bonds, loans, swaps, and all financial instruments relating to interest rates. These securities make up a very substantial proportion of all investment and financing. In this course we will learn about the design, functions and modelling of these securities. We will also learn how these many instruments are related to each other, and how to manage the risk associated with them. We will also see how the Hong Kong market and the US market are related to each other.
Extra Information
Equivalent to MFIN6005 Fixed Income Securities and Their
MFIN7012B
Fixed Income Securities & Interest Rate Modelling
4
Gao, Xiaohui
General Information
“Fixed Income Securities” covers bonds, loans, swaps, and all financial instruments relating to interest rates. These securities make up a very substantial proportion of all investment and financing. In this course we will learn about the design, functions and modelling of these securities. We will also learn how these many instruments are related to each other, and how to manage the risk associated with them. We will also see how the Hong Kong market and the US market are related to each other.
Extra Information
Equivalent to MFIN6005 Fixed Income
MFIN7011
Credit Risk
8
Tang, Dragon
General Information
A comprehensive analysis of credit risk measurement and credit derivatives. Topics include credit events, expected default frequency, expected exposure, loss given default, default correlation, KMV, Credit Metrics, credit ratings performance and migration, total return swaps, credit default swaps, basket default swaps, credit spread forwards and options, exotic credit derivatives, credit-linked notes, and collateralized debt obligations.
Extra Information
equivalent to MFIN6016 Seminar in Credit Risk Management
Prerequisites:
1. Spreadsheet Modelling in Finance;
2. Derivative Securities; and
3. Fixed Income Securities & Interest Rating Modelling
MFIN6012A
Risk Management
4
Tse, Maurice K.S.
General Information
This course is to provided a comprehensive analysis and measure of market, credit, liquidity, operations, model and other risks. Techniques such as Value-at-Risk methods, forcasting volatilities and correlations, Monte Carlo simulations, stress testing, Riskmetrics and their limitations will also be discussed. Examples and applications of these techniques to various financial instruments will be introduced. The course will also address compliance functions of dervatives departments.
Extra Information
Prerequisites:
1. Spreadsheet Modelling in Finance; and
2. Derivative Securities
MFIN7001B
Financial Statement Analysis and Business Ethical Standards
3
Chan, Derek K. W.
General Information
This course introduces the fundamental concepts and techniques related to financial statement preparation and analysis. The accounting system is the information process used to record and report on economic activies of enterprises. Gaining an understanding of how economic activity is measured, and how it is reported, gives us the power to utilise that information to make our necessary decisions. Ethical and professional standards which those employed in the practice of financial analysis and investment mangement should know, understand, and apply will also be covered.
Extra Information
Equivalent to
MFIN7008
Mathematical Techniques of Finance II
6
Carverhill, A.P.
General Information
This course further develops the course Mathematical Techniques of Finance I, and applies them to practical market situations. In particular, we analyze recent equity basket structures, and commodity spread options. Also, we will analyze the smile effect in equity options, and study how to apply the Monte Carlo method to valuing American options. Also, we will study some advanced fixed income models and related market instruments.
Extra Information
Equivalent to MFIN6010 Numerical Methods
Prerequisites:
1. Mathematical Techniques of Finance I; and
2. Fixed Income Securities and Interest Rate Modelling
MFIN7013
Seminar in Commercial
FINA0805 Real estate finance
Semester : 2
For Student of Year : 2 & 3
An introduction to real estate economics, mortgage market, real estate auctions in Hong Kong, pre-sale market in Hong Kong, pricing of land and residential/commercial properties, mortgage-backed securities and mortgage company.
MFIN7004
Financial Services Regulations
Hsu, Berry
General Information
This course provides students with the legal background necessary to comply with the regulatory requirements in banking and finance. It covers the legal aspects of corporate governance, the legal framework of banking and finance, and financial products, including derivatives. This course also provides students with background on market access in financial services, as China embarks on liberalization of its financial markets as a member of the WTO.
Extra Information
Equivalent to MFIN6011 Derivatives: Law & Regulation
FB2801 Experiencing Hong Kong
Course Aims & Objectives:
The aims of this course are to enhance students understanding of the formation of cultures and subcultures; awareness of the formation of Hong Kong culture and it's subcultures. Upon completion of the course, students should have gained:
First hand experiences of different aspects of Hong Kong culture
Insights on the development of Hong Kong's many subcultures, and how they affect the livelihood of Hong Kong people
Perception of the cultural development of Hong Kong in the future
Units: 1
Level: A/B
Keyword Syllabus:
Concepts and definitions of culture and the making of Hong Kong culture. The power of media in the
MFIN7007A
Economics for Financial Analysis
1
Luk, Y.F.
General Information
This module provides the foundation in economics that is essential in financial analysis. The major topics include microeconomics, macroeconomics and international economics: consumer choice, costs and the supply of goods and services, competitive market structure, the role of government in the economy, national income accounting, business cycles, aggregate demand/supply, fiscal and monetary policies, the level and structure of interest rates, the role of expectations in economic analysis, economic growth, comparative advantages and international trade, international finance and foreign exchange markets. Appropriate references will be made to current issues in Hong Kong, the
MFIN7017
Advanced Option Pricing Model
6-7
Tse, Raymond
General Information
This course brings together the practical and theoretical knowledge taught in the other derivatives and risk management courses in the MFIN program to introduce some of the state-of-the-art option pricing models. The course dwells on the original insights of various authors for exotic option pricing and option pricing models with volatility smiles. In addition to the plain-vanilla European option model, the course discusses the continuous and discrete barrier, lookback, Asian, American, excursion option pricing models. It also discusses the jumps and stochastic volatility option pricing models, including the latest option pricing models
MFIN7009
Financial Engineering
7
Zhang, Jin
General Information
Financial engineering is the design, development, and implementation of innovative financial products and of financial processes in the major market segments of currency, interest rates, equities, and commodities, for trading, investment, hedging, and risk management, using methods developed in finance, economics, mathematics, physics, and computational science. Potential topics include, but are not limited to, credit risk derivatives, insurance derivatives, exotic derivatives, volatility calibration, implementation of trading systems using Reuters, and advanced term structural models.
Extra Information
Prerequisite:
Mathematical Techniques of Finance I
ECON0603 The economic system of Hong Kong
Semester : 2
For Student of Year : 2 & 3
The course provides a comprehensive discussion of the salient aspects of the Hong Kong economy. Topics include Hong Kong's national income accounting and economic development, the monetary system and exchange rate regime, the financial system, public finance and fiscal policy, external trade and foreign investment, economic relations with the Mainland, the labour market and employment, the property market and housing policy, regulation of public utilities and competition policy, industrial development and policy, and income distribution. Emphasis will be given to both economic analysis and institutional
MFIN7016
Real Options and Dynamic Corporate Finance
6
Wong, Keith K.P.
General Information
This course provides a synthesis of modern corporate finance and real option analysis (ROA). ROA explicitly takes into account the flexibility of managerial decisions at the future date in response to the arrival of new information. Using the framework of ROA, this course examines the dynamic aspects of various corporate financial decisions. Topics include capital budgeting, capital structure, managerial compensation, risk management, mergers and acquisitions, and bankruptcy and reorganization. Basic mathematical tools of game theory, stochastic calculus, dynamic programming, and contingent claims analysis are introduced and extensively used. This
FINA1002 A Introduction to finance
Semester : 2
For Student of Year : 1
An introduction about the basic aspects of financial management: managing the company's sources and uses of funds as well as a general understanding of the key issues involving the raising and using of long term funds. There will be extensive use of a spreadsheet software (Excel) in lectures and its use is also expected in homework assignments. After finishing the course, students should have a basic knowledge of financial statements and cash flows, an understanding of the major securities used in the financing of companies. They would also be