Financial Statement Modeling and Analysis with Excel and Palisade @RISK 5.0 demonstrates how financial models should guide commercial discussions. Therefore, 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 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 the financial statements to always produce a correctly balanced Balance Sheet. The class will use this model as a guide to commercial issues, negotiation strategies and financial statement analysis.
Finally, by employing Palisade @RISK software, the course demonstrates the power of Monte Carlo simulation analysis, creating a dynamic decision-making tool, elevating past 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.)
For more info:
Tel. +1 866 410 VAIR(8247)
www.vaircompanies.com
Start Date Monday, September 08, 2008
End Date Tuesday, September 09, 2008
Posted by Vair Training on Wednesday, August 06, 2008 20:22
Location New York City
Category Training Courses
Feeds RSS and Email Alerts