Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Integrated In Text/Document Formulas

Request Demo
  • Edited

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.

1

Comments

4 comments

Date Votes

Please sign in to leave a comment.