To me the most challenging (and interesting) aspect of financial modelling is the eradication of circular references. A circular reference is caused when a cell is calculated by looking at itself, either directly or indirectly. It is very easy to introduce circular references into models and, in most cases, they are caused by the modeller introducing an illogical argument.
Continue reading “Why should circular references and iterative macros not be used?”