Continuing Education Events | Networking Events | Social Events | Career Development | Free Events | Event Calendar | HKSFA Best Research Report Competition | HKSFA-HKEX Portfolio Management Competition 2017 | Congratulations to the top 5 University Teams in Hong Kong Final 2018-19 of CFA Institute Research Challenge! | Adverse Weather Policy


[CANCELLED] Advanced Financial Analysis Series - Advanced Financial Modelling – Core Model [Complete] | Event Code: 181003W |
Date | 03-Oct-2018 |
Time | 08:45 a.m. - 5:00 p.m. |
Venue | HKSFA Office, 14/F, BOC Group Life Assurance Tower, 136 Des Voeux Road Central, Hong Kong |
Speaker(s) | Mr. Hamilton Lin, CFA President Wall St. Training |
Fee |
HKSFA Member(s) at HK$2,500.0/person CFA Candidate(s) at HK$4,000.0/person Guest(s) and Non-member(s) at HK$4,000.0/person |
This seminar is qualified for | 6.5 CPT hour(s), 6.5 CE hour(s), 6.5 RBV CPD hour(s) |
Remarks |
|
Event Details |
Add to Calendar HKSFA is proud to present our “Advanced Financial Analysis Series" held in conjunction with Wall Street Training & Advisory. This Series of workshops builds upon and expands our prior successful and popular Financial Analysis Series and will provide practical, Excel-based career-enhancing programmes related to financial modelling, projection modelling, fundamental analysis, mergers & acquisitions and leveraged buyouts. This series of hands-on workshops will consist of the following full-day, extended programmes:
Highlights of this Workshop: ADVANCED FINANCIAL MODELLING – CORE MODEL Build a fully integrated financial statement projection model with income statement projections, a self-balancing balance sheet, an automated cash flow statement, and the balancing cash flow sweep/debt schedule. While knowledge of advanced accounting concepts is not required for this course, you should possess knowledge of basic accounting ratios and a basic understanding of how the major financial statements are inter-related. Emphasis is placed on the integration of the major financial statements and becoming experts in Excel. Incorporate different methodologies to forecasting the different types of assets on the balance sheet and compare and contrast with projecting liabilities. Learn how to balance a model utilizing the debt sweep and the revolver and not using any “plugs”. Appreciate the danger of and properly control for circular references. Avoid messy nested “if” statements!! You will leave the classroom with a fully constructed model that can be customized and applied to other companies. The final model is a fully scalable model that can be added upon. Learning Objectives:
Rating - Advanced Highly focused technical presentations of interest to participants with a high level of technical knowledge in the subject area. About Wall Street Training & Advisory: |