Best practice financial modelling in Excel has always been to enter your formulas in blocks. Enter a formula, then copy this across and possibly down also, making sure you have your absolute and relative references set correctly.
This is very useful because it is faster to build a model, easier to enter lots of formulas, less error-prone and easier to audit, all very desirable things when you’re constructing a financial model!
Excel’s dynamic array functions take this concept to a whole new level because they automatically copy themselves.
The dynamic array functionality has improved recently & now, with a bit of thought & planning, it can be applied to building a full financial model.
Come and see how these new functions are dramatically revolutionising financial modelling in Excel with a practical example of a full 3-way model where all formulas automatically copy themselves just by changing the number of periods.
Agenda:
- Introduction to Dynamic Array functions
- Application to financial modelling:
o Income statement
o Balance sheet
o Cash flow
- Considerations and questions to consider
**Free event** with drinks & nibbles provided afterwards by Access Analytic