Modeling Functions and Tools

  • Jack Avon


I have been asked often if there is a certain group of Excel functions, routines, and tools that are essential for financial modelers. It’s a tricky question because on the one hand, there are certain functions that are a must. But on the other, modeling is a strange beast and very often situations arise that require some thinking outside of the box. When these situations occur, modelers may need to ditch the must-have functions and either create their own or use a totally new function. This versatility is something that separates the good modeler from the exceptional modeler.


Cash Flow Model User Exact Match Start Date Cell Reference 

Copyright information

© Jack Avon 2015

Authors and Affiliations

  • Jack Avon
    • 1
  1. 1.SurreyUnited Kingdom

Personalised recommendations