Financial Modeling

Financial Modeling

Overview
This intensive workshop is designed to develop financial modeling skills through actual hands-on
construction of a financial model. Each participant will build their own interactive financial model from
“scratch” to practice blending accounting, finance and Excel skills.
The completed product is a dynamic model with 5 years of projections and 3 years of historical data,
containing the following detailed statements and schedules:

• Income statement, balance sheet and cash flow statement
• Working capital schedule
• Depreciation schedule
• Intangibles amortization schedule
• Shareholders’ equity schedule with a share repurchase table
• Debt and interest schedule with a “cash sweep”
• Detailed ratio worksheet
In addition, the workshop will cover the following advanced modeling topics:
• Understanding and controlling circular references
• Balancing a model
• Sensitivity analysis to match expected financial performance
• Fundamentals of creating data tables
• Adding a discounted cash flow valuation worksheet
Constructing the model will entail creating the logic and formulas to project 5 years of financial
performance.

Learning Methodology
Through practical examples and annotated Excel guides, the lectures will discuss theories, approaches
and applications of financial modeling. The participants will have the opportunity to construct a model of
their own to apply the lessons learned in the lectures.
Personal one-on-one assistance will be available to answer questions and give guidance while the
participants are working on the computers. During computer time, Training The Street will supplement
the lectures with tips and hints on Excel best practices for financial modeling.

Target Audience
This intensive workshop will benefit any professional who will be required to create financial projections,
especially for MBA candidates interested in:
• Working in the financial services industry (investment banking, consulting, research, asset
management, private equity, brokerage, sales & trading, insurance, etc.)
• Working in the corporate or strategic development group or finance department of a corporation
• Enhancing the learning experience in finance and financial statement analysis classes
• Working in marketing, brand management or operations for a corporation and being responsible
for a product or divisional budget, projections and profit/loss statement