As part of our Stress Testing Documentation process there are many instances where we reference % change that are often used throughout the presentation of our forecast results. My idea would be to incorporate a formula within the text where you could reference linked data to formulate a percentage change based on current and historical data. Our current process includes side of our desk % calculations that need to be updated for each stress cycle.
i.e. Total loan volumes grow by approximately $X.XXB or X.X% <-- (Formula) over the 9-quarters driven by increases in Residential Mortgage, TDAF, Credit Cards, C&I, and EXIM, partially offset by decline in CRE and HELOC.
I understand this can certainly be done by establishing another link but then the linking become a bit burdensome. Being able to provide a quick formula to create % changes on historical and current data would increase the efficiency in our process significantly. Please let me know if this makes sense.