Kaplan
Kaplan Hong Kong Youtube Channel Kaplan Hong Kong Google+ Page Kaplan Hong Kong Facebook Page
Professional Development
Kaplan Financial offers a comprehensive range of short public courses that focus on practitioners at all levels in all areas of the financial industry, as well as a logical progression of development. Our courses address both core knowledge and practice but are also up to date and reflect the latest developments in a fast changing world.

 

Why Choose Kaplan Financial?

Experience
We have delivered a substantial number of courses to thousands of delegates from graduates and new hires to senior executives from multinationals, banks and financial institutions across Asia. Our success is based on the delivery of practical and contemporary courses focused on this region.

Trainers
All of our in-house financial markets trainers have strong academic backgrounds plus practical work experience in the financial markets. Our faculty combines professional expertise in areas as diverse as Fund Management, Corporate Finance, Alternative Investments, Derivatives, Technical Analysis and Foreign Exchange. This hands-on experience gives them the ability to bring the learning to life and incorporate real-life and relevant scenarios within the classroom environment.
 
Prof Development
 
Excel Modelling for Financial Analysis: Public Equities


 
Date
27 – 28 June 2015 (1.5 day), Hong Kong              
Duration 1.5 days          
Time
9am-5pm 
Venue
Kaplan E-Tech Centre Campus (Causeway Bay MTR Exit A)
Language
English

This 1.5-day course is suitable for anyone involved in the areas of security and market analysis, particularly those who are moving into or are currently junior buy-side analysts.

Prerequisites
-
Able to read and understand financial statements and footnotes
-Have general knowledge of basic financial ratios
-Have previous experience using Microsoft Excel
Attendance
Certificates of Attendance will be issued to individuals who have completed the course.

Why attend this course? 

Guided by an experienced analyst, delegates will:

-Build a company financial model from scratch using publicly available information
-Navigate and modify a model built by someone else
-Make earnings forecasts
-Derive a company valuation
-Receive models and work through case studies


Who should attend? 

This is an introductory series to equip professionals who has 1-3 years of experience in banking and finance, including:

-Financial analyst
-Investment banking analyst
-Portfolio analyst
-Fund analyst
-Business analyst
-Financial manager
-Realtionship Manager

Presenter    Yeeman Chin, CFA

Yeeman has more than 10 years of experience in financial services as sell-side equity analyst, and buy-side equity analyst, and as an audit accountant. Her core expertise is equity research, and she was also involved in several capital market deals. She started with KPMG as an audit accountant and moved on to equity research at Macquarie Securities, where her team was named #1 Asia Metals and Mining research team by Institutional Investor in 2010. She moved to the buy-side in 2010 with SAC Capital Advisors as a long/short equity analyst. Her most current role is Analyst /Vice President with Lombard Odier, covering Asia/China consumer stocks for the US$1bn Emerging Consumer fund.
Yeeman is a CFA Charterholder and holds a Masters in Finance (with Distinction) from INSEAD. She is fluent in English, Mandarin and Cantonese.
Through the use of excel models and tools, Yeeman designs this hands-on course to highlight guidelines and present the applicability of the principles in real life. Upon completion of the course, delegates should be able to apply the tools immediately at their workplace. 

Course Outline 

Day One   

Introduction to financial modeling and methodology

-What is a financial model and what are its main purposes?
-Key components and inputs of a model
-What makes a good model?
Modeling best practices

-Formatting and layout of your model - make sure you know which numbers are actuals, estimates and assumptions
-Adding checks and preventing errors
-Circularity of the model

Modeling public equities

-
Specific modeling considerations when working with public companies
       -Information is more limited (public information only)
        -Detail v.s. ongoing ease of maintenance
-Sources of information
-Perspective of a minority investor
-Compare companies in the same industry

Useful excel shortcut keys and functions

-
Absolute and relative cell referencing
-Linking between workbooks
-Editing formulas
-Formula auditing
-Paste special
-Formatting shortcuts
-Freeze columns/split screen

Build a sample company model from scratch

Delegates have a choice between a consumer or resources/utilities company
 
-Build out the rest of the PNL statement
-Forecast costs and gross profit section
-Identify and forecast revenue drivers
-Analyze historical financial statements what do they tell us about this company/industry?
-Decide what information to keep and what to simplify
-Gather and assess the information that is available
úOperating costs
úDepreciation
úInterest expense (linked to balance sheet)
úAssociates
úIncome tax
úMinority interest
-Forecast balance sheet and cash flow
úWorking capital requirements
úFixed assets, capital expenditure and depreciation
úCash management and forecasted net debt
 úDividend policy

 DAY TWO

Finetuning your earning and balance sheet forecasts

-Which are the most important drivers for the company’s earnings and valuation?
-Which key drivers did you have to make educated guesses/assumptions?
-How do you justify your assumption?
-Where do you think are the key uncertainties and risks to your forecast?
-Is the output consistent with your expectations? If not, investigate why and check the model

Company valuation using the financial model

-Calculation of per share data, market capitalization and enterprise value, as well as common pitfalls
-Relative v.s. absolute valuation methods
-Relative valuation using valuation multiples (e.g. PE, EVEBITDA, Dividend yield, P/B etc)
-Discounted cash flow (DCF) and terminal value



To register, please download the enrollment from

For enquiries, please contact Ms Carina Yuen at 2116- 3425 (direct line) or Ms Janet Sin at 2116 3424 (direct line) or email hkfmkt@kaplan.com.
* SFC licensees must undertake a minimum of 5 hours per calendar year for each SFC regulated activity. Corporations are held primarily responsible for ensuring the fulfillment of the requirement. Coverage of subjects relevant to the individuals’ functions and which may help to enhance their functional performance would meet the CPT purpose. The Academic and Accreditation Advisory Committee (AAAC) of the SFC does not endorse any training courses whether provided internally or externally. It is up to the Corporations to decide whether the training meets the CPT purpose and proper records should be kept for inspection upon request.

# The modules B &C are in the process of getting accreditation from The Law Society of Hong Kong for CPD points. Please check the application result with Kaplan before registration if this is a concern.
   
 Short Courses


Short Courses on selected topics are offered from time to time throughout the year.  New courses are added regularly, so please check this page regularly for updates.

Financial Statement for Non-Financial Professionals    Date TBC
   
Corporate Finance  
Valuation and Investment Analysis
Equity Analysis
Introduction to Capital Budgeting
Corporate Valuation
Kaplan Research and Analysis Program
Date TBC
Date TBC
Date TBC
Date TBC
Date TBC
Customer Relationship Management  
Introduction to Wealth Management
Understanding Economic Cycles and Performance of Various Asset Classes
Communicate House Views to Clients
Dealing with Significant Market Events
Date TBC
Date TBC
Date TBC
Date TBC
Derivatives  
Introduction to Derivatives
Introduction to Credit Derivatives
Introduction to Equity Derivatives
Equity Swaps
Interest Rate Swaps/Derivatives
Derivatives for Relationship Managers
Hedging, Trading and Pricing Options
Date TBC
Date TBC
Date TBC
Date TBC
Date TBC
Date TBC
Date TBC
Financial Modeling  
Financial Modeling with Excel
Intermediate Financial Modeling
Valuation Modeling
Date TBC
Date TBC
Date TBC
Financial Analysis/Financial Reporting  
Introduction to Financial Statements
Financial Statement Analysis
Financial Shenanigans
Using Financial Ratio to Access Financial Strength of Listed Companies
Date TBC
Date TBC
Date TBC
Date TBC
Fixed Income  
Debt Investment
Introduction to Bonds and Fixed Income
Fixed Income Analysis
Date TBC
Date TBC
Date TBC
General Finance  
Valuing Financial Assets – Stock, Bonds and Derivatives
Introduction to the Financial Markets and Banking
Introduction to Financial Maths
Basic knowledge of economics
Date TBC
Date TBC
Date TBC
Date TBC
Insurance  
Introduction to Insurance
Date TBC
Investment Banking  
Introduction to Capital Markets
Introduction to Equity
Introduction to Hedge Funds and Alternative Investments
Overview of the Investment Banking Business
Forecasting Stock Prices: Cash Flow Models and Price Multiples
Date TBC
Date TBC
Date TBC
Date TBC
Date TBC
Portfolio Management  
Portfolio Theory and Product Returns
Date TBC
Risk Management  
Mechanics and Applications of Long/Short Hedge Funds
Implementation of Value-at-Risk in Financial Institutions
Date TBC
Date TBC
Regulatory and Compliance  
Overview of Legal and Regulatory Framework for Securities and Futures Industry
Insider Dealing and an Overview of the Securities and Futures Ordinance
Know Your Client and Detection of Money Laundering
Date TBC
Date TBC
Date TBC
Treasury  
Introduction to FX
Date TBC
Industry Specific Financial Training  
Legal
Insurance
Real Estate
Transportation and Logistics
Date TBC
Date TBC
Date TBC
Date TBC

 
 In-House Training

 
Kaplan Financial can provide any of our public courses on an in-house basis or tailor training solutions to meet your precise training objectives. Please check out our Corporate Training page for more information.
 
 No Future Dates For Your Desired Public Courses?
Your desired topic is not listed above?
Kaplan Financial can schedule courses for small groups at mutually suitable times. Please complete the online enquiry form on the right to enable us to assess the level of interest for that topic. We will then place your name on our waiting list and will contact you as soon as we have received sufficient interest to run the course. A minimum of 6 participants is required to run a course. Scheduled courses may then be open to the public.
 

Kyle is the Director of Kaplan’s Financial Markets Division. He teaches and develops products for bespoke Financial Markets training programs. He has more than 10 years of working experience in the banking and securities industry. He was in management and sales roles at major global financial institutions like Merrill Lynch, HSBC, RBC Group and Citigroup in Canada, Singapore and Hong Kong. He has advised clients on a large range of investment products including equities, fixed income, trust units, pooled funds, derivatives and structured products. At International Planning Group Ltd. he provided estate planning to
private bank clients throughout South East Asia. Before joining Kaplan he was the VP, Complex Hybrid Products at DBS Bank.

Currently Kyle is also a Partner and Risk Manager at Avant Capital Management, which specializes in medium and small cap equities in the Greater China region. The firm aims to become early movers in under-researched and under-owned names.

Kyle was appointed a visiting professor at Ningbo University (PRC) in 2003. Kyle has been teaching master level courses in finance, investment and portfolio management at Royal Roads University in Canada and HKU SPACE. He received his BS degree from the University of Wisconsin and his MS and Ph.D. degrees from Cornell University.

Kyle is a certified Financial Risk Manager and has been a CFA Charter holder since 2004. He is also member of the Hong Kong Society of Financial Analysts and member of the Professional Risk Managers’ International Association.

 
 

Thomas has been training and teaching in the financial industry for over 8 years. He is praised for his ability to combine his academic knowledge, finance and accounting experience and time-tested examination techniques to provide students with the knowledge and ability to explore their potential to the fullest in both work and testing environment.

Thomas has spent over ten years in a US-based investment bank and a Big Four accounting firm. His work ranged from auditing and recruiting to syndication, project finance, and acquisition financing in Canada, US, Singapore, and Hong Kong. Thomas has also managed a technology company and overseen an investment trust prior to obtaining his doctorial degree.

Beside teaching CFA, Thomas is also a Kaplan trainer for CAIA, ACCA and HKICPA courses. He is currently a visiting Associate Professor in two universities in China, a finance and accounting lecturer in two local universities in Hong Kong. Thomas also conducts in-house training courses on financial markets, derivatives and structured products for a Swiss-based and a UK/ HK based global investment bank. Thomas is also an External Examiner for the Hong Kong Examinations and Assessment Authority.

Thomas received his Doctoral degree from the Hong Kong Polytechic University, an MBA from the University of Chicago, a Master of Professional Accounting from the University of Southern Queensland, and he is completing a Master of Financial Engineering in the National University of Singapore/ UC Berkeley program. Apart from his academic credentials, Thomas received his CFA charter in 1997. He has earned the PRM, FRM, and CAIA designations, a Certificate in Financial Forensics from the AICPA, and Certificates of Financial Engineering from NUS/ UC Berkeley. Thomas is also a Chartered Accountant (CA, Canada), CPA (US) and a CPA Australia member.

 
 
Ms. Esther Thng
CFA, BA, FRM,
MSocSci (Applied Econ)

Esther is a CFA charterholder and a member of Singapore Society of Financial Analysts. She graduated with honours and holds a Bachelor of Accountancy from the National University of Singapore. She also holds a Masters of Social Sciences (Applied Economics) from the National University of Singapore and was awarded the Lim Chong Yah gold medal for her excellent academic performance by the same University. She has extensive experience working in the financial sector in the areas of research, investment valuation, financial analysis and forecasting. Esther has been a full-time lecturer with Kaplan Financial since 2000. Esther is well-liked by her students and is known for her ability to translate difficult and complex concepts into easy to understand terms. She also lectures on Kaplan Financial’s corporate finance courses to both local and overseas clients. Her corporate clients include statutory bodies and well-known financial institutions.

“Kaplan has significant technical expertise and the distinct advantage of being able to see issues from a global industry perspective. The trainers deliver presentations in an entertaining and dynamic way that clearly appeals to our students.”
Financial Knowledge Manager, Barclays Bank PLC


Can attending a Kaplan Financial Professional Development course
fulfill my CPT (Continuous Professional Training) requirements?


Although Kaplan Financial cannot warrant that the attendance of this course would automatically be recognized by the Securities & Futures Commission (SFC), it is highly likely that Kaplan Financial courses can fulfill CPT requirements as they maintain and enhance delegates’ technical knowledge and professional expertise.

Please check directly with your employer as the corporate licensee of your SFC registration, who is responsible for determining whether a training course satisfies CPT requirements.

You will be required to keep all documentary evidence supporting your CPT activities for a minimum of 3 years.  We will issue a certificate of attendance to you upon payment of our prescribed fee confirming that you have indeed attended the course and will state the duration of the course.  We will only issue a certificate of attendance if you have signed in AND signed out before you leave the course.

For further details on fulfillment of CPT requirements, please refer to the Guidelines on Continuous Professional Training of the SFC.

For further details on minimum CPT hours required, please see SFC's licensing related FAQ Topic 3.


 


 
All information provided above is provided for information purposes only. Although every reasonable effort is made to present current and accurate information, Kaplan Financial does not assume any responsibility whatsoever for its accuracy and any future changes set forth by the SFC. In the event of discrepancy, the official information and decision from the SFC shall prevail.

Professional Development Online Short Courses



Kaplan Financial offers a comprehensive range of online modules that addresses core skills that market practitioners need every day. Each online module addresses both core knowledge and practice but is also current and reflects the latest developments in a fast changing world.



Highlights

  • Video Instruction in English (6 hours per module)                                                                   
  • Unlimited review during the 3-month subscription period  
  • Trainer's annotation captured
  • Practical exercises and case studies                      
  • Assessment test
  • Download course manual directly from online portal
  • CPT awarded*





Who should attend?

Legal l Accountants l Client Services l Compliance l Human Resources l
IT l Media l Public Relations l Operations l Sales & Marketing l Junior Analysts

Interpretation of Financial Statements
Become familiar with the basic concepts, standards, and practices of financial accounting

Debt and Equity Capital Markets
Understand global finance system, including the major individual and institutional players, and their roles and responsibilities

Features, characteristics, risks and returns

Equity Valuation and Ratio Analysis
Interpret different financial ratios

Analyze different approaches and methodologies for equity valuation

Practical application and integration of finance and accounting concepts to valuing companies from an investor's perspective

*CPT certificates will be granted to those participants who have:
     1. Watched all of the video content (based on time log in, log out and video clicks in the online portal)
     2. Achieved a score of 70% or above in assessment test


Course Instructor

Ronald Chan    (MBA, MAcc, CFA)

Ronald graduated from University of Waterloo, Canada, having read Mathematics. He went on to qualify as chartered accountant with KPMG Canada, specializing in private equity audits, financial reporting, financial analysis, and corporate finance. After he left KPMG, Ronald spent two years as an equities controller at Goldman Sachs in Hong Kong, where he performed financial analysis for different business sectors and prepared valuation reviews for financial instruments. He also spent 4 years in Aviva North America as Manager of Financial/Management Control. His responsibilities included management reporting, financial reporting, financial analysis, budgeting, market research, and advising on M&A and business risk. Previously he was manager of a leading accounting and consultancy firm in Hong Kong. He is responsible for conducting pre-IPO review for IPO sponsors, assessing listing applicants' readiness and compliance to the Hong Kong Stock Exchange listing rules, as well as advising clients on financial, operational and regulatory issues. 

Ronald received his Master of Accounting from University of Waterloo in 2002, and an MBA (finance specialization) from the Schulich School of Business at York University in 2007. Ronald has been a CFA Charter holder since 2006.


For course details, please download the brochure.
To register, please download the enrollment from.

For enquiries, please contact Ms Carina Yuen at 2116-3425 (direct line) or Ms Janet Sin at 2116-3424 (direct line) or email
hkfmkt@kaplan.com.


 

© 2012 Kaplan Financial. Professional Development.



COURSE SEARCH

SEARCH
ENQUIRY
  General Enquiry
TEL: 2526 3686    FAX: 2501 0589
EMAIL: hkfmkt@kaplan.com





NEWS


Bookmark and Share
Learn more about Kaplan's other products and services at Kaplan.com
Copyright © 2015 by Kaplan Hong Kong. All Rights Reserved.