2 Day Financial Modeling & Analysis Course, Johannesburg - The Vair Companies

June 14, 2010 - PRLog -- 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.

Dates: 13-14 July, 2010

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.

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.)

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

Outline:
Part 1   Introduction to Excel
Part 2   Introduction to Financial Statements
Part 3   Introduction of a Pro Forma Model
Part 4   Assets: Purchasing versus Leasing
Part 5   Operational Worksheets
Part 6   Debt
Part 7   Coding Full Financial Statements
Part 8   Discussion on Valuation
Part 9   Discounted Cash-Flow Modeling
Part 10   Using the Model to Price the Asset
Part 11   Monte Carlo Simulation Analysis

More Information
Please visit our website for a detailed syllabus and registration information http://vaircompanies.com

Contact Us
Toll Free: +1 866 410 VAIR (8247) within the United States & Canada
International: +1 770 853 0362
E-mail: info@vaircompanies.com

# # #

About The Vair Companies

The Vair Companies is an international advisory and training firm that conducts quantitative financial courses worldwide. Our interactive and intensive "live" workshops are taught by active project developers and financial advisors who use the techniques imparted in class to drive real-time deals. As such, we teach our students the same real-world methods and best practices that we employ on behalf of our advisory clients.

Course topics include Financial Modeling (beginner-to-advanced), Project Finance, PPP, M&A, Risk Analysis and Corporate Governance. Vair offers financial training in three formats: public, private and executive education training. Whether 1.) An individual seeking financial modeling training through open-enrollment courses, 2.) An organization in need of customized in-house training, or 3.) An MBA program looking to enhance its current curriculum, Vair can deliver high-caliber finance courses to meet your specific training needs.