Mastered the Core skills? Take the next steps
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.
What you will learn:
Advanced LBO Topics
Advanced M&A Topics
Advanced Modeling Topics
Other Advanced Topics
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
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.
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 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.
– Group rates available
– Discounts offered to existing clients
Standard registration inside 30 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