Logical-and Structural-Based Calculations

Abstract

In this chapter, I want to take a look at functions that fit into a specific part of modeling. I will be discussing functions that work with dates, lookup functions, mathematical functions, and also some functions that are specific to particular situations. I will also outline the functions that fit into various modeling structures and point out functions that modelers should be learning to use. In financial modeling, there are no defined methods of using functions; in fact, there are no prescribed functions for any given modeling situation. The functions that are used in models are instead a reflection of the modeler's skills, experience, and understanding of best practice modeling.