Logical and Structural-Based Calculations

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 ...

Get The Handbook of Financial Modeling: A Practical Approach to Creating and Implementing Valuation Projection Models now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.