Spreadsheet Modelling in Finance Course of MFin at University of Hong Kong

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: , , , , , , , , , , ,

Leave a Reply

Fixed Income Securities & Interest Rate Modelling Course of MFin at University of Hong Kong

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

Fixed Income Securities & Interest Rate Modelling Course of MFin at University of Hong Kong

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

Credit Risk Course of MFin at University of Hong Kong

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

Risk Management Course of MFin at University of Hong Kong

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

Mathematical Techniques of Finance I Course of MFin at University of Hong Kong

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

Mathematical Techniques of Finance Course of MFin at University of Hong Kong

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

Real estate finance Course at University of Hong Kong

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.

Financial Services Regulations Course of MFin at University of Hong Kong

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

Experiencing Hong Kong Course for Faculty of Business City University of Hong Kong

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

Economics for Financial Analysis Course of MFin at University of Hong Kong

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

Advanced Option Pricing Model Course of MFin at University of Hong Kong

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

Financial Engineering Course of MFin at University of Hong Kong

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

The economic system of Hong Kong Course at University of Hong Kong

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

Real Options and Dynamic Corporate Finance Course of MFin at University of Hong Kong

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

Introduction to finance Course at University of Hong Kong

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