Build your own interactive three statement financial model from “scratch”, blending accounting, finance, and Excel skills.
Fast Track: Financial Modeling
Instructor-led courses, learn in-person or virtually
Learn techniques we teach around the world...
Training The Street’s 2 Day Fast Track training is an intensive course that teaches participants how to build their own interactive financial model from “scratch”, blending accounting, finance, and Excel skills.
Through a mixture of guided lecture and micro exercises, the modeling 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.
Excel Best Practices and Efficiencies
Financial Modeling
Troubleshooting the Model
Utlizing the Finished Product
Advanced Sensitivity Analysis
Agenda
Overview and introduction to financial modeling
Excel best practices and efficiencies
Construction and Application of:
- Core statements
- Working capital schedule
- Depreciation schedule
- Amortization schedule
- Other long-term items schedule
- Equity schedule
- Shares outstanding schedule
- Debt and interest schedule
Troubleshooting the Model:
- Understanding and controlling for circular references
- Balancing the model
- Making the model “deal ready”
Utilizing the Finished Product:
- Data tables
Advanced Sensitivity Analysis:
- Adding scenarios to the model
- Creating a toggle for cases and naming cells
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 reinforcement and learning:
• Excel Best Practices
• Financial Modeling
Schedule
9:00 am to 5:00 pm each day with an hour lunch around noon and shorter breaks throughout the day.
Prerequisites
Fundamental knowledge of financial accounting: TTS recommends our self-study book, Fundamentals of Financial Accounting and Analysis. For additional information please visit TTSAcademy.com
What Does A Day Look Like?
Whether you join us in-person or virtually, the classroom is a combination of micro-lectures 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?
- Financial services professionals (investment banking, consulting, research, asset management, private equity, brokerage, sales & trading, insurance, etc.)
- Corporate/strategic development or finance team members
- Individuals responsible for product or divisional budgets, projections, and profit/loss statements
– Group rates available
– Discounts offered to existing clients
Standard registration inside 14 days:
$2,500
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
- Same experienced instructors
- Proven curriculum used by our top finance, consulting, and corporate clients
- Learn at your own pace