A typical financial model has formulas left, right, top and bottom. Brimming with cell references located close by or far end of the sheet or a foreign sheet. Well not all models are built as per FAST ;) So modellers / auditors face challenges in checking formulas and identifying it's composition. Unfortunately excel doesn't provide a good method to navigate through far off references.

How an easy self review can be conducted with map file of the workbook, explained here with details on what kind errors can be detected. It is gold standard in detecting formula inconsistency, which plagues many models. So, as a manager this is a must have utility for your team involved with financial models build or review.

Why do financial models become more complex? Have you come across the situation where after doing the complex calculations you realize that it is of no use? Should you include everything all kinds calculations, balance, permutation / combinations without knowing the end goal of the model?