Financial Analysts, Investment & Evaluation Professionals, Business Development Planners, Mergers & Acquisitions Specialists, Accountants, Valuation Professionals

Beginner-to-Intermediate

Financial Statement Modeling and Analysis demonstrates efficient model creation and how these financial models should guide commercial discussions. Participants learn how to "negotiate off the financial model." Most financial analyses use some form of 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 key" 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 the financial statements to always produce a correctly balanced Balance Sheet. Finally, the class will use this model as a guide to commercial issues, negotiation strategies and financial statement analysis. This course is indispensable to the effective use of financial spreadsheets for any industry or sector.

This course takes a practical "learn by doing" modular approach. The course structure for each module follows a four-step pattern: 1) teaching of the material, 2) spreadsheet exercise, 3) review of the exercise; then, 4) follow-up with a question and answer session. Each successive module builds upon the previous exercise. Each participant will be given problem and answer files to insure course fluidity for every student's level.

This course will use methodologies to:

• Identify the model-type for analysis
• Create models that are easy to navigate without forfeiting robustness
• Use that model to assist your decision-making process

(NB: A working knowledge of financial accounting is helpful but not essential. A precourse packet will be sent to give an overview to some basic accounting principles.)

Vair Training courses are held at world-class international venues. Registration fees include morning coffee/tea, networking lunches and afternoon refreshments. Course materials are provided electronically on-site. Detailed venue descriptions, times and logistics are included with post-registration materials and documents.