So far in the previous chapters, we have looked into the structuring on financial models and working through best practice paradigms. In this chapter, we will focus primarily on the detail of creating and using formula. Excel contains a bewildering number of functions, and it’s nigh on impossible for anyone how to use each and every function. In fact, there is no point because what really matters is not how to use a function but when to use it.
The focus in this chapter is about those functions and formulas that are typically most helpful to financial modeling and would be used ...