Financial Modeling & Analysis Workshop - Ottawa 2010
September 21 - 22, 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.
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.)
More Information
Please visit our website for a detailed syllabus and registration information http://vaircompanies.com
Contact Us
Toll Free: +1 866 410 VAIR begin_of_the_skype_highlighting +1 866 410 VAIR end_of_the_skype_highlighting (8247) within the United States & Canada
International: +1 770 853 0362
E-mail: [email protected]
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.)
More Information
Please visit our website for a detailed syllabus and registration information http://vaircompanies.com
Contact Us
Toll Free: +1 866 410 VAIR begin_of_the_skype_highlighting +1 866 410 VAIR end_of_the_skype_highlighting (8247) within the United States & Canada
International: +1 770 853 0362
E-mail: [email protected]
Venue
Sorry, this event is quite new so we couldn't find any venue information.
Please check again in the near future.
Please check again in the near future.
Related events
Financial Modeling & Analysis Workshop - Ottawa September 21 - 22, 2010
