PC Fast Track: Financial Modeling

Description

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.

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 you will learn

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