WST Training
WST Training
WST Training
+1 (212) 537-6631
+1 (212) 656-1221 (fax)
info@wallst-training.com
Wall St. Training provides professional financial training solutions Wall St. Training offers a wide variety of topics ranging from Basic
to Wall Street through hands-on classroom training and customized to Advanced levels. Our courses are designed for participants with
corporate training programs for financial analysts. All of our various backgrounds, from students and entry-level professionals
courses take a hands-on, interactive, practical, non-theoretical to professionals with some work experience to professionals in the
approach and is exactly how it is done on Wall Street. midst of a career transition.
Wall St. Training is a registered trademark and servicemark of HL Capital Partners, Ltd.
Wall St. Training Hamilton Lin, CFA
+1 (212) 537-6631 2 Founder & CEO
info@wallst-training.com www.wallst-training.com
3-DAY CURRICULUM
The following is our 3-day financial modeling training curriculum designed and targeted specifically for
professionals in finance and accounting.
In addition to this live seminar, all participants receive access to applicable courses via our online video-
based content. Prerequisites are meant to be done prior to the first day of live training and are available
before and after the training. Post-training supplements replicate live training content as a review and
refreshers to hone the concepts learned and are highly recommended as add-ons after training.
These are intensive financial modeling training programs based off our training to
large Wall Street investment banks and asset managers and are meant to
challenge, teach and inspire you, not put you to sleep!
Benefits
Become extremely fast and efficient with Excel; apply these skills in many finance and related classes
Instill and encourage you to apply thought and reasoning when building financial models
Get on-going support from WST & participate in live forums & discussions
Bridge the gap between academic theory and the textbook with practical, real-world application
Enables you to take on more challenging tasks during summer programs, e.g. building financial models
Be better prepared for any full-time or post-MBA position at boutique investment firms or firms with
little to no formal training programs
Wall St. Training is a registered trademark and servicemark of HL Capital Partners, Ltd.
Wall St. Training Hamilton Lin, CFA
+1 (212) 537-6631 3 Founder & CEO
info@wallst-training.com www.wallst-training.com
DAY 1: ADVANCED FINANCIAL MODELING
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:
• Build an integrated set of financials, including income statement, balance sheet & cash flow
• Learn how to balance a model utilizing debt sweep, no “plugs” and the danger of circular references
• Become super-efficient in Excel through intensive use of keyboard shortcuts and best practices
Learning Goals:
5-Year Financial Statement Projection Model:
• How do you project a company’s Income Statement from revenues and expenses down to Net Income?
• What are the different methodologies to forecasting the different types of assets on the balance sheet and how do
they compare and contrast with projecting liabilities?
• How do you project the shareholders’ equity account?
• What is the importance of financial ratios in building the balance sheet projections?
• How do you approach building an integrated cash flow statement?
• How do you build each component of the cash flow statement and why is cash the last item to project?
Supporting Schedules:
• Incorporate calculation and payment of dividends into your integrated financial model
• Emulate announced share repurchase program by estimating implied price and shares repurchased
Wall St. Training is a registered trademark and servicemark of HL Capital Partners, Ltd.
Wall St. Training Hamilton Lin, CFA
+1 (212) 537-6631 4 Founder & CEO
info@wallst-training.com www.wallst-training.com
DAY 2: SEGMENT BUILD-UP & SENSITIVITY MODELING
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 detailed growth
• Analyze and break down growth based on publicly available data and inputs from 10K filing
• Incorporate and remove effect of growth from non-core items such as foreign exchange rate 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 of growth drivers
• For instance, for a retailer, calculate Sales / Sq Foot / Type of Store, which captures: (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)
Wall St. Training is a registered trademark and servicemark of HL Capital Partners, Ltd.
Wall St. Training Hamilton Lin, CFA
+1 (212) 537-6631 5 Founder & CEO
info@wallst-training.com www.wallst-training.com
DAY 3: CORPORATE VALUATION
How can you tell if a company is undervalued or overvalued? Is the current stock price the only measure of value? Why
would one company command a higher or lower premium than its direct competitor? This course takes a practical,
tangible, and non-theoretical approach to examining how corporations are valued and the major analytical tools that
are used. Go beyond the academic theory of financial ratios and apply fundamental analysis and real-world methods of
evaluating a company’s intrinsic value. Gain insight into relative valuation methodologies (trading comps, deal comps) to
fundamental valuation (discounted cash flow analysis, break-up / sum of the parts valuation). Coverage goes beyond the
academic theory of financial ratios to the practical application of fundamental analysis, offering alternative, real-world
methods of evaluating a company's intrinsic value. The Course includes a crucial primer to Corporate Finance and its
non-theoretical application.
Learning Objectives:
• How to value a company (trading comps, deal comps, DCF, LBO, break-up and asset valuation)
• Importance of Enterprise Value, EBITDA, capital structure, leverage and WACC
• Analyze valuation multiples and ratios; why are PE ratios sub-optimal as a valuation metric?
• Practical, non-theoretical application of introduction to corporate finance
Learning Goals:
Introduction to Valuation and Corporate Finance:
• How much is a company worth? Why is the current stock price not an accurate indication of value?
• How do you tell if a company is under-valued or over-valued?
• Why would one company command a higher or lower premium than its direct competitor?
• What is the importance between enterprise value and equity value?
• TEV: what is the correct treatment of minority interest and capital leases from a standalone valuation aspect vs. credit
perspective vs change of control
• What is the relevance of capital structure and leverage on a company’s value?
• Why and how is corporate finance so critical to managing a firm’s profitability?
Wall St. Training is a registered trademark and servicemark of HL Capital Partners, Ltd.
Wall St. Training Hamilton Lin, CFA
+1 (212) 537-6631 6 Founder & CEO
info@wallst-training.com www.wallst-training.com
DAY 4: VALUATION MODELING
Valuation Modeling
Format: 100% Excel Duration: ½ – ¾ Day
Layer on a fundamental valuation model by constructing a discounted cash flow analysis on top of your projection
model. Continue with relative valuation by building a basic trading comps analysis analyzing the industry valuation
multiples. Incorporate all of the analyses together in a summary valuation analysis. This Excel-based class provides a
non-academic, real-world, hands-on primer to the quantitative and technical aspects of valuation modeling. You will
leave the classroom with a template model that is scalable and applicable to other companies immediately.
Learning Objectives:
• Construct a discounted cash flow analysis including present value of free cash flows and terminal value
• Build basic comparables comps analysis
• Integrate model to complete valuation analysis
Learning Goals:
Fundamental Valuation Modeling:
• Construct a discounted cash flow analysis (simple and complex version)
• Estimate unlevered free cash flow (free cash flow to firm)
• Estimate terminal value using multiples approach and perpetuity growth approach
• Weighted average cost of capital (WACC) analysis that supports the DCF (estimate discount rate)
• Calculate from enterprise value down to equity value and ultimately down to stock price per share
• Build reference range and football field to summarize valuation (after trading comps)
Wall St. Training is a registered trademark and servicemark of HL Capital Partners, Ltd.
Wall St. Training Hamilton Lin, CFA
+1 (212) 537-6631 7 Founder & CEO
info@wallst-training.com www.wallst-training.com