This session is targeted at model builders or management responsible for modelling supervision. It canvasses key approaches to laying out models effectively to assist the end user to comprehend them and to make them easier to audit and review.

It constructs a high-level business valuation model which includes a discounted cash flow analysis. It allows for multiple scenarios in which a variable number of historical years can be entered and in which assumptions for future years can be keyed only where a change is required. It demonstrates an approach that permits multiple scenarios of two dimensional assumption sets to be managed. Sensitivity techniques involving the use of Data Tables are demonstrated.

An emphasis is placed on using consistent layout and formatting, naming conventions and simplified formulas to simplify construction, audit and use. It is a hands-on session that builds a simplified sample model and demonstrates and discusses the techniques and methodologies used.

Ideally, participants will already have experience building flexible forecasting or business valuation models.