Enhanced Core: Financial Modeling and Corporate Valuation
This rigorous technical training course is specifically developed for new and lateral hires, with the sole purpose to get them desk-ready. Over the last two decades, Training The Street’s Core Comprehensive course has become the industry standard for live technical training.
The Enhanced format incorporates robust features that have traditionally only been available to our on-site training clients. These newly available features include:
- TTS Resource Center – Through their unique login, each participant will have access to our web based learning environment, which includes; access to training content (including over 500 support videos), online assessments, and a classroom portal that enhances instructor and student interaction.
- Performance Tracking – Through the Resource Center, participants have the ability to track and compile a record of their personal performance throughout training. This record of performance can be provided to the participant’s sponsoring firm.
- Fundamentals of Financial Accounting and Analysis SmartBook® – Participants will be provided with access to the course prior to training. This allows participants to be “level set” prior to live instruction; serving as a refresher for some participants and getting those with little to no accounting background up to speed. These materials also serve as an excellent reference post training.
- Online Assessments – Prior to training, participants will complete an accounting pre-instruction assessment to ensure a base level of accounting skills*. Throughout live training, daily mastery quizzes ensure that participants are on track, retaining important learning objectives. Once live classroom instruction is complete, TTS will administer a comprehensive final examination to measure the participant’s overall learning.
- Online Video Content – Participants will have 24/7 access to core video content, knowledge check videos, and advanced video content via the TTS Resource Center.
- Evening Assignments – Assignments will be graded with instructors’ comments and feedback. A Teaching Associate will be present to answer questions on these assignments.
- Post Training Support – Once participants leave the classroom, the learning continues. Participants will have access to the TTS Core Video Library through March 31st of the following year. So when its late in evening and they can’t remember how to calculate diluted shares outstanding using the Treasury Stock Method, there is a reliable, 24/7 resource to get what they need. For a listing of video topics, view this PDF
* The accounting pre-instruction assessment ties back to specific pages in the Fundamentals of Financial Accounting and Analysis SmartBook® for follow-up and reinforcement.
Live Instruction: TTS’s live 5 Day Enhanced Core Comprehensive Financial Modeling and Corporate Valuation course explores the modeling and valuation techniques commonly used by Wall Street firms. The proven curriculum provides practical application of the standards and methods that a practitioner needs to be a top performer. Led by our team of experienced instructors, all of whom are former practitioners, the primary focus of the training is to teach participants the practical applications of the theoretical methodologies. Participants will blend accounting, finance, and Excel skills into the construction of three interactive models from “scratch” (3 statement, M&A, and LBO) over the 5 days intense days of training.
- Early Registration: $6,000 for full course (register at least 3 weeks in advance)
- Standard Registration: $7,000 for full course
- Group rates are available
- Discounts offered to existing clients
Enhanced Brochure and Outline
Overview of valuation methodologies and fundamental concepts
Public Comparables Analysis:
Overview of Acquisition Comparables Analysis:
- Choosing the appropriate peer group
- Gathering public information
- Calculating market and enterprise value
- Normalizing for non-recurring items
- Calculating latest twelve months (LTM)
- Calculating relevant multiples
- Deriving an implied valuation range
- Analyzing multiples and a comparables universe
- Exercise: “Spreading public comparables” for the case company
Discounted Cash Flow Analysis:
- Choosing the appropriate deal list
- How control premiums and synergies impact multiples
- Sources of public information
- 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 based on DCF analysis
- Exercise: Adding DCF output to a 3-statement model for the case company
- Imputing valuation ranges
- Creating a “Football field” for the case company based on different valuation methodologies
Mastery Quiz: Comparables and DCF
Overview and introduction to financial modeling
Excel best practices and efficiencies
Construction and Application of:
Troubleshooting the Model:
- Core statements
- Working capital schedule
- Depreciation schedule
- Amortization schedule
- Other long-term items schedule
- Equity schedule
- Shares outstanding schedule
- Debt and interest schedule
Utilizing the Finished Product:
Advanced Sensitivity Analysis:
- Understanding and controlling for circular references
- Balancing the model
- Making the model “deal ready”
- Adding scenarios to the model
- Creating a toggle for cases and naming cells
Mastery Quiz: Financial Modeling
Merger Consequences Analysis:
Exercise: Building an M&A model for a potential acquisition of the case company
- Concept of affordability analysis
- Overview of SFAS 141/142 and IFRS 3
- Purchase accounting overview
- Creation of goodwill and write-ups, including possible incremental D&A
- Opening balance sheet and purchase accounting adjustments
- Pro forma income statement
- Accretion/dilution analysis
- Credit rating considerations
- M&A transaction considerations(stock vs. cash, social issues, etc)
- Asset vs. stock purchase
- Tax deductibility of goodwill
- Section 338 election
Mastery quiz: Merger consequences
Leveraged Buyout Analysis:
Exercise: Constructing an LBO model for the case company
- What makes a good LBO candidate?
- Concept of value creation via de-leveraging, operational improvements and “multiple expansion”
- Sources of funding for an LBO
- Differing viewpoints for LBO constituents
- Purchase price determination
- Debt capacity and financing options (Pro rata facilities, institutional facilities, mezzanine capital)
- Sponsors equity and internal rate of return (IRR)
- Fundamentals of “recapitalization accounting”
- Mechanics of constructing an LBO model
The typical training day, which will start promptly at 9am, will include approximately 6-8 hours of live instruction and exercises, followed by 2-3 hours of evening assignments (recommended to be completed on site). A Teaching Associate will be on site to answer questions about coursework or assignments in the evening. There will be no evening assignments on the last day of the course (Friday) when class will finish at approximately 5pm.
There are no prerequisites for this course.
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 reserve the right, at its sole discretion, to cancel a course. If TTS cancels a course, payments are refunded in full.
Please contact firstname.lastname@example.org for more information.