Financial Statement Modeling & Analysis
Posted by Vair Training on Wednesday, August 06, 2008
Start Date Monday, September 08, 2008
End Date Tuesday, September 09, 2008
Location
New York City
Full Details
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
Category
Training Courses