Virtual Meetup: Full 3-way Financial Modelling using Dynamic Arrays

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.
Watch to hear from financial modelling specialist, Jeff Robson to 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.
★ Download the Excel model file ► plumsolutions....
★ Follow Jeff Robson on LinkedIn ► / jeffrobson
★ Check out Access Analytic ►accessanalytic...
★ Register for a Virtual Meetup ► plumsolutions....

[@CarlHorn]

I like the DATE function trick for end of month! And I hadn't heard of SCAN! Dynamic array formulas are awesome. Thanks 🙂

[@mypage9331]

This is very good. One comment : most of the future numbers dont change. How do I incorporate changes in array values for future years?

[@plumsolutions]

If you change the input assumptions, the values in future years will automatically change with an array formula in the same way as they do with ordinary formulas.