O'Reilly logo

Mastering Cash Flow and Valuation Modelling by Alastair Day

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2

Functions

Categories

Finance

Mathematics

Time

Lookup

Logic

Text

Other functions

Summary

File: MCFM_Functions.xls

The last chapter emphasised the use of clear short formulas as part of a basic modelling standard which can be audited and understood easily. Formula constructions such as IF, IF, IF … tend to be difficult to understand and prone to simple errors. While there are around 450 functions in Excel, most of them are not applicable to cash flow modelling. The Excel file for this chapter contains lists in alphabetical and subject order together with a list of Analysis ToolPak functions to serve as an overall reference (Figure 2.1). The latter are more advanced functions which are not always available with a ‘typical’ installation of ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required