Advanced Topics

Mastered the Core skills? Take the next steps

Upcoming Courses

MORE DATES

Coming soon!

Upcoming Courses

MORE DATES

Coming soon!

Learn techniques we teach around the world...

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 Finance 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.

What you will learn?

  • Advanced LBO Topics
  • Advanced M&A Topics
  • Advanced Modeling Topics
  • Other Advanced Topics
What you will learn?
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

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.

What Does A Day Look Like?
Course Details

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

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.

How Do You Like To Learn?

In-Person Training

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 Training

Course Pricing

$400 USD per session*

* register at least 30 days in advance

Standard registration inside 30 days:
$500 USD per session

– Group rates available
– Discounts offered to existing clients

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.

See what our students say

Training The Street Certification

Unlock your career potential

Training The Street has been teaching the biggest finance firms for over 20 years. To help unlock your career potential, we offer certificates to provide the recognition you deserve.

After you finish your course, you will receive a certificate which can be easily added to your LinkedIn profile.

Clients We Work With

Training The Street Academy Self Study Courses

Can't Attend A Live Course?
Try Our Self-Study.

  • Proven curriculum used by our top finance, consulting, and corporate clients
  • Same experienced instructors
  • Learn at your own pace