Contact Us

Advanced Topics

Mastered the Core skills?  Take the next steps

icons_white

Instructor-led courses, learn in-person or virtually

Learn techniques we teach around the world...

In response to requests for more intermediate and advanced level training, we have taken our most popular advanced training sessions, and packaged them into an Advanced Topics series. The series is specifically designed for those with prior work experience in valuation and financial modeling or who have attended our Valuation and Financial Modeling workshops. Each session is ~2.5 hours in duration.

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.

Advanced LBO Topics

Advanced M&A Topics

Advanced Modeling Topics

Other Advanced Topics

Clients We Work With:

Instruction3

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.

VIRTUAL SQUARE

Course Details

What’s Included
Instructor-led classroom training

Ongoing instructor support
One-year online access to course materials, Excel files, and related self-study courses for additional reference and review

Session Schedule
2:30 pm to 5:00 pm (Eastern Time – NYC) 

Prerequisites
Participants must have prior work experience in valuation and financial modeling or have completed one of TTS’s Valuation and Financial Modeling workshops. Participants are also expected to be proficient with Excel.

What Does A Session 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. 

Session Agendas


Complexities with Modeling Debt Session (2.5 hours):

  • Overview of Complexities
  • Enhancements with Modeling Debt Instruments
  • Multiple Layers of Debt
  • Multiple “Cash Sweeps”
  • Modeling LIBOR floors
  • Commitment Fees
  • Covenants

PIK’s, Warrants, and Recaps Session (2.5 hours):

  • Overview of PIK’s, Warrants, and Recaps
  • “Payment-in-Kind” (PIK) Instruments
  • Mezzanine Financing with Warrants
  • Conceptual Understanding and Motivations of “Recapitalization Analysis”
    • Leveraged Recap
    • Special Cash Dividend
    • Share Repurchase


Public Market Separation Techniques Session (2.5 hours)
:

  • Introduction to Subsidiary Redeployment
  • Equity Carve-Outs
  • Spin-Offs
  • “Reverse Morris Trust” Structure
  • Split-Offs
  • Split-Ups
  • Tracking Stocks
  • Cash Rich Split-Off

Divestitures & Acquisition Structure Alternatives Session (2.5 hours):

  • Overview of Alternatives
  • Divestitures:
    • Impact on Financial Statements
    • Modeling Considerations
  • Asset Purchase:
    • Advantages and Disadvantages
    • Valuing the Tax Savings Stream
    • Deferred Tax Impact
  • Stock Purchase
  • Section 338/338(h)(10) Elections
  • Comparing Asset Purchase vs. Stock Purchase


Advanced Troubleshooting and Switches Sessions (2.5 hours)
:

  • How to quickly fix a broken model (controlling for #VALUE & #REF errors)
  • CIRC switches
  • How to build scenarios / sensitivities into a model (CHOOSE & OFFSET functionality)
  • Creating summary output (e.g., self-referencing circular IF statement)
  • Advanced Data Table complexities


Deferred Taxes Sessions (2.5 hours)
:

  • Deferred Tax Liabilities
  • Deferred Tax Assets
  • Deferred Taxes Created in Purchase Accounting
  • Modeling Deferred Taxes
  • Case Studies of Financial Disclosure
  • DTLs from Equity Investments
  • Primer on NOLs and Valuation Allowance

Incorporate Investments Sessions (2.5 hours):

  • Overview of Intercorporate Investments
  • Equity Method (Equity Investments):
    • Overview and Introduction
    • Impact on Financial Statements
    • Case Study of Financial Disclosures
    • Modeling Considerations
    • Valuation Considerations
  • Minority Interest (Noncontrolling Interests):
    • Overview and Introduction
    • Impact on Financial Statements
    • Case Study of Financial Disclosures
    • Modeling Considerations
    • Valuation Consideration

Course Pricing

$400 per session*

* register at least 14 days in advance

– Group rates available
– Discounts offered to existing clients

Standard registration inside 14 days:
$500 per session

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