Non members : To receive news from HKSFA
Please register here
Forgot password
Advanced Financial Analysis Series - Segment Build-up and Sensitivity Modeling [Complete] Event Code: 170309W
Date 09-Mar-2017
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
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)
  • Special Discount: 10% off for those who register for two (or more) workshops.
  • Only Visa and Master Card are accepted for online payment.
  • The fee includes course materials.
  • Classrooms are not equipped with computers, participants WILL HAVE to bring their own laptops.  Please bring Excel for PC installed (any version).  Macs will not be as effective as shortcut keys are different.
  • Please make sure your laptop has a working USB port to copy files at the beginning of class.

Event Details
HKSFA is proud to present our “Advanced Financial Analysis Series" held in conjunction with Wall St. Training. The Advanced Financial Analysis Series will provide practical, career-enhancing programs related to fundamental analysis, valuation and financial modeling. This series of hands-on workshops will consist of the following full-day programs:
·  Advanced Financial Modeling : Core Model
8th March 2017 (Wed)
·  Segment Build-up and Sensitivity Modeling
9th March 2017 (Thurs)
·  LBO Modeling & Debt Sweep Enhancements
10th March 2017 (Fri)
The goal of these programs is to improve and elevate the skill sets of the financial analyst and the investment professional. Heavy emphasis is placed on being as effective and efficient as possible with Excel. If you are interested in improving your financial modeling and valuation skills, or are in the midst of a career transition, these courses are for you!
Wall St. Training ( provides professional financial training solutions to Wall Street through hands-on classroom training and customized corporate training programs for financial analysis which take a hands-on, interactive, practical, non-theoretical approach. The instructor, Wall St. Training’s President and Founder, Hamilton Lin, CFA, has trained numerous major financial services firms including Bank of America/Merrill Lynch, Capital Group, CLSA, Credit Suisse, Deutsche Bank, Fidelity, GE Business Development & Private Equity, Goldman Sachs, Greenhill, ING, JPMorgan, Lazard, Morgan Stanley, Oppenheimer, TD Securities, TIAA-CREF, TPG, UOB, Wells Fargo, World Bank – IFC and many others. Wall St. Training also provides financial modeling training courses to most of the largest CFA Institute societies around the world.

Highlights of the Workshop:

Learn how to build detailed revenue and segment build-ups into your larger financial model. Many financial projection models are based off simple revenue growth rate and expense margin assumptions, resulting in reduced precision in the projection model. This course teaches various approaches to true, bottoms-up, fundamental analysis, from both an “account-by-account” and “business segment” basis (very detailed build-up vs. division by division). The results of build-up analysis roll-up into a consolidating income statement that feeds into the Income Statement revenue items.
Learning Goals:
Detailed Business Segment Build-Up:
  • Model out historical change in key drivers of growth and project future growth
  • Analyze and break down growth based on publicly available data and public filings
  • Incorporate and remove effect of growth from non-core items such as FX fluctuations
  • Project future detailed growth assumptions that roll up into larger projection model
  • Instead of just calculating 10% growth rate in revenue, dig into deeper layers
  • For a retailer, calculate Sales / Sq Foot / Type of Store, capturing: (i) number of stores (store count growth); (ii) size of each store (expansion and size creep); (iii) profitability of each sq foot and same store comps sales (YoY sales growth)

Operating & Division Segment Build-Up:
  • Calculate and analyze different operating segments to roll-up into IS
  • Adjust for extraordinary items by segment based on MD&A and disclosed footnotes
  • Extract, utilize and incorporate volume and pricing increases into operating segments
  • Project future revenue and segment income and allocate for corporate overhead
  • Estimate projected COGS and SG&A on the entire base after operating build-up

Detailed Account by Account Build-Up:
  • Project sources of revenue based on growth in number of accounts and customers
  • Model out revenue per account and associated commissions and expenses
  • Incorporate rate increases into model
  • Further enhance model via sensitivity & scenario modeling and analysis
  • Detailed build-up consolidates into Consolidating Income Statement which feeds IS

Sensitivity Analysis and Multiple Cases:
  • Layer sensitivity analysis on top of build-up to incorporate various assumptions/cases
  • Build multiple scenarios and cases, including Base Case, Optimistic & Pessimistic Cases
  • Toggle and sensitize profitability and cash flows based on various case assumptions
  • Understand difference between sensitivity and scenario analysis
  • Build one- and two-dimensional various data tables with varying degrees of sensitivity
*Workshop Rating - Advanced
Highly focused technical presentations of interest to participants with a high level of technical knowledge in the subject area.)

Click here to download the event flyer for further details.