Category Archives: Best Practices

One of the most common mistake in model development is the lack of clear distinction between inputs and calculations. Even worse are inputs hidden within formulas. Let’s look at the following simple example which computes the present value of two distinct scenarios. Without looking at each cell, one can only guess what are the inputs. [...]