Need to learn outside of “business hours”? Designed for the working professional
Learn techniques we teach around the world...
Developed with the working professional in mind, this 8 session course covers Financial Statement Analysis, Valuation, Financial Modeling, and Specialized Modeling. Each session runs from 6:30pm to 10:00pm (ET).
Case study based curriculum provides hands-on, real world, practical applications of the standards and methods that a professional needs.
Led by our experienced instruction team of former practitioners, you get a unique blend of industry insight combined with a passion for teaching. The average TTS instructor has been part of the team for 8.5 years.
What you will learn:
Financial Statement Analysis
Comparables Analysis
Excel Best Practices and Efficiencies
Financial Modeling
Merger Consequences Analysis
Leveraged Buyout Analysis
Agenda
Financial Statement Analysis:
- Analyzing a company’s income statement, balance sheet and cash flow statement
- Why bankers stress the importance of EBIT and EBITDA
- Calculation and decoding of financial ratios
- Normalizing for non-recurring items
- Calculating margins, growth rates, credit ratios
- Interpreting footnotes and management discussions & analysis
Public Comparables Analysis:
- Choosing a peer group and gathering public information (sources and SEC documents overview)
- Spreading comparables – calculating Market and Enterprise Value, normalizing for non-recurring items, inputting the numbers, LTM, calculating multiples
Acquisition Comparables Analysis:
- Choosing a deal list
- Concept of control premiums and synergies
- Sample transaction list
Discounted Cash Flow Analysis:
- Strengths and considerations of a DCF analysis
- Deriving a weighted average cost of capital (WACC)
- Discounting unlevered free cash flows
- Estimating the terminal value (exit multiple vs. perpetuity growth rate approach)
- Determining the valuation range
Modeling Best Practices:
- Establishing modeling standards of consistency, efficiency and clarity
- Introduction to short-cut keys and other Excel settings for efficiency
- Creating flexible formulas, calculations and projections
- Auditing financial models
Building an Integrated Financial Model:
- Setting up and road mapping the modeling process
- Efficiencies with entering and analyzing historical financials
- Projecting revenues and operating performance
- Constructing the balance sheet and cash flow statement
- Forecasting operating/working capital
Building an Integrated Financial Model – continued:
- Projecting PP&E and intangible assets
- Calculating cash flow from investing activities
- Forecasting other long-term items
- Building a detailed equity & shares schedule
- Understanding the core accounting relationships when building an integrated model
- Debt & interest schedule
- Setting up a “cash sweep” for excess cash and building complex deficit financing options
Trouble Shooting Your Model:
- Controlling for circular references, balancing models, and making the model “deal ready”
- Constructing and utilizing data tables to perform sensitivity analysis
- Using your model in a “real world” deal situation including a DCF application
Merger Consequences Analysis:
- Overview of purchase accounting
- Allocating the purchase price and creation of goodwill
- Sample merger consequences impact: transaction assumptions, sources and uses, opening balance sheet, pro-forma income statement
- M&A transaction considerations (stock vs. cash, social issues, etc.) and their impact on the financial statements
- Break-even synergies and PE analysis
- Key concepts and analysis: accretion / dilution, pro forma leverage and coverage ratios
Leveraged Buyout Analysis:
- Concept of an LBO and de-leveraging
- LBO math
- Capital structure determination
- Utilizing a revolving credit facility and cash sweep
- The characteristics of the different debt instruments
- Differing viewpoints for LBO constituents
- Internal rate of return analysis
- Mechanics of constructing an LBO model
How Do You Like To Learn?
Flexible Learning Options
Our courses are available in both in-person or virtual classroom formats. If you learn better in your own space or traveling isn’t convenient, virtual is great solution. Either way, you get the skills and support you need to succeed.
Course Details
What’s Included
Instructor-led classroom training
Ongoing instructor support
One-year online access to course materials, Excel files, and these self-study courses for additional reference and review:
• Financial Statement Analysis
• Corporate Valuation
• Excel Best Practices
• Financial Modeling
• M&A Modeling
• LBO Modeling
Schedule
Tuesdays and Thursdays from 6:30pm – 10pm.
Prerequisites
There are no prerequisites for this course.
What Does A Day Look Like?
Whether you join us in-person or virtually, the classroom is a combination of microlectures and hands-on exercises that ensure retention levels are high and students stay engaged. You’ll use some of the most innovative Excel based learning tools available, providing instant performance feedback as well as the opportunity for as many “reps” as you need to be “desk ready”.
Who Is This Course For?
- Industry professionals who want to improve their finance skill-set to enhance their job responsibilities, build job security, and increase the possibility of promotion
- Students who want to complement their course work with practical corporate valuation and financial modeling knowledge before starting as an analyst or associate
- Prospective lateral hires looking to gain a competitive advantage in advancing their career or securing a job in the financial services industry (private equity, investment banking, hedge funds, research, asset management, etc.)
– Group rates available
– Discounts offered to existing clients
Standard registration inside 30 days:
$3,800 per day
Cancellation Policy
Cancellations up to 14 days before the workshop will receive a full refund. Cancellations within 14 days of a course will not be refunded. TTS reserves the right, at its sole discretion, to cancel a course. If TTS cancels a course, payments are refunded in full.
Questions? Please contact info@trainingthestreet.com for more information.
Can't Attend A Live Course?
Learn Online
- Proven curriculum used by our top finance, consulting, and corporate clients
- Same experienced instructors
- Learn at your own pace