We were tasked with building a data-intensive monthly financial model spanning 6 years, handling over 100,000 rows of sales data. The use of long-range formulas across such a dataset made the workbook painfully slow to calculate. We decided to challenge some of the conventional financial modelling best practices, just to see if they could be bent (carefully!) in favor of performance.