Event Title:

Organization:

  Business

  Business Event Calendar

Start Date:

  1/11/2011

End Date:

  1/12/2011

Start Time:

End Time:

Event Info: 

  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.

- Learn efficient modeling for specific financial analysis
- Build financial models to guide negotiations and decision-making
- Apply Excel shortcuts and hot keys to get you off the mouse
- Learn effective auditing techniques on existing models
- Employ Monte Carlo Simulations
- Engage in relevant commercial discussions with active project developer/financial advisor

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

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

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 details 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

Location:

  Torys, LLP

Room:

  Suite 3000

Address:

  79 Wellington Street West

Phone:

City:

  Toronto

State/Province:

  Ontario