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 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Jack Avon 2015

Authors and Affiliations

  • Jack Avon
    • 1
  1. 1.SurreyUnited Kingdom

Personalised recommendations