Weaving Business Forecasts into Spreadsheet-Based Financial Projections
This two-day workshop is for professionals in valuation, corporate finance, planning and budgeting, investment banking, asset management, fixed income research, and equity research. It will help you weave business and financial forecasts into spreadsheet-based projections of financial statements. These projections will help you value a business, test future scenarios, and will give you an integrated view of a business. The workshop will also discuss tools and techniques to make you more efficient and effective in developing models.
Please consider taking the one-day seminar "Valuation of Companies" that follows this seminar. Participants have told us that they found the knowledge gained in that seminar quite helpful when modeling and projecting financial statements. Rest assured, that this seminar stands on its own and attending the other one-day seminar is not necessary to grasp the material covered in this seminar.
- A laptop with Excel 2010 or above is required to build models.
- A working knowledge of Excel is required (advanced knowledge of Excel, such as macros, is not needed for this course).
- A good knowledge of accounting topics such as indirect cash flows, leases, taxes, and options.
5/23-5/24/2017 Las Vegas
Venue and Hotel Details
- Introduction to modeling and design: Components of a financial statement model; Skills needed for modeling; Excel overview; Design choices
- Efficient modeling and best practices
- Building blocks of models and step-wise development: Enterprise activities
- Forecasting EBITDA by forecasting sales and operating expenses
- Forecasting working capital requirements for future business activity
- Forecasting capital expenditures, PP&E, and depreciation
- Non-current operating assets and liabilities: Modeling multi-period effects: When revenues are collected over multiple periods, or expenses are incurred over multiple periods
- Forecasting reserves and allowances
- Modeling current and deferred taxes
- Building blocks: Financing activities
- Understanding and forecasting enterprise free cash flows: Contrasting three approaches to measurement of free cash flows: cash-flow budgeting, equity valuation, and credit risk analysis
- Forecasting funding needs and interest expense
- Ensuring that the firm meets its debt-to-equity ratio constraints or debt-to-EBITDA constraints
- Meeting seasonal funding needs via revolving line of credit
- Overview of integrated models and their drivers
- Cost of capital and risk
- Growth and terminal values
Baseline understanding of U.S. GAAP Accounting
Level of Knowledge:
Field of Study:
Group Live, Instructor-Led Course
Dan Gode, Co-founder, Almaris E-Learning Systems.
“Excellent instructor and easily one of the best corporate training classes I've attended. I will recommend my entire staff take this course.” - Controller, Large Nursing and Rehabilitation Care Provider
* Discounts cannot be combined and must be applied at time of initial registration.
** Tuition price includes daily breakfast, lunch, and morning and afternoon refreshments.
CFA Institute CE Qualified Activity
As a participant in the CFA Institute Approved-Provider Program, KPMG Learning has determined that this program qualifies for 13.5 credit hours. If you are a CFA Institute member, CE credit for your participation in this program will be automatically recorded in your CE tracking tool.