CHAPTER 3

Modeling Functions and Tools

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.

In this chapter, I will cover the functions that are of immediate value to modeling. These functions are indispensable and as you ...

Get The Basics of Financial Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.