Aimed at finance professionals seeking techniques to manage sets of complex criteria in models, this workshop demonstrates techniques for structuring and implementing complex table-driven assumptions for cash flow type models.

Given some starting assumptions, it builds a sample construction cash flow from scratch, implementing scenarios in which the costs are variable as to amount, timing, phasing and in which the cash flows can be automatically allocated on an S Curve basis. Finally it implements sensitivity analysis to allow the comparison of all scenarios within the one model.

Participants should be familiar with more complex formulas, the use of Data Tables, data validation, IF, MATCH and INDEX functions. Some familiarity with array formulas and the LET function would be an advantage.