Presented in association with

Taught by Charles T. "Chip" Haskell, Jr, Managing Director of The Vair Companies and Internationally-Renowned Financial Modeling Instructor.

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

Part 1 – Introduction to Excel
Part 2 – Introduction to Financial Statements
Part 3 – Introduction of a Pro Forma Model
Part 4 – Purchase versus Lease
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 Using Palisade @RISK 5.0

Vair Training courses are held at world-class international venues. Registration fees include morning coffee/tea, networking lunches and afternoon refreshments. Course materials are provided electronically on-site. Detailed venue descriptions, times and logistics are included with post-registration materials and documents.