Toronto, ON -- (SBWIRE) -- 12/02/2010 -- Financial Modeling and Analysis teaches students how to conceive of and build a financial model from beginning-to-end, followed by due diligence. This course demonstrates how financial models guide commercial discussions. Participants will learn how to negotiate off the financial model.

This course will utilize a Discounted Cash Flow ("DCF") pro forma approach derived from a full suite of financial statements: 1) Income Statement, 2) Statement of Retained Earnings, 3) Balance Sheet and, 4) Statement of Cash Flow. Participants use "hot keys" and page-setup techniques to build a fully integrated pro forma DCF model from a list of assumptions. The "mouseless" Excel techniques employed dramatically reduce model coding time. Next, delegates learn how to integrate all financial statements to produce a correctly-balanced Balance Sheet, without circularities. The class will use this model as a guide to review commercial issues, negotiate strategies and analyze financial ratios. Finally, the course demonstrates the power of Monte Carlo simulation analysis creating a dynamic decision-making tool and elevating beyond simple static input and output spreadsheets.

Dates: Jan 11-12, 2011

Course Participants Include:
Financial Analysts, Investment & Evaluation Professionals, Business Development Planners, Mergers & Acquisitions Specialists, Accountants, Valuation Professionals

This course is indispensable to the effective use of financial spreadsheets for any industry or sector. (NB: A working knowledge of financial accounting is helpful but not essential.)

This course will be followed by by a 2-day Public-Private Partnership Advanced Modeling with Legal Analysis course, also led by Vair Head Trainer, Charles "Chip" Haskell and Torys Partner and PPP-specialized attorney, Jonathan Weisz.

For more information please visit our website http://vaircompanies.com