For years, leaders at community banks have been using spreadsheets to analyze their CRE loan portfolios and generate reports for management, board members, and auditors. While some larger banks were able to take advantage of new technologies and build their own more powerful proprietary systems, for most community banks spreadsheets were the best available option. But the landscape is changing, and there is a better option available that fits most community banks’ needs and budget.
Spreadsheets were the best choice because:
- They were the easiest way to import, organize, view, and manipulate data from the core system and other systems within the bank.
- They can hold massive amounts of data and handle the numerous calculations banks require.
- Each bank has a set of concentrations and ratios that are specific to them. An affordable solution that accommodated a bank’s unique needs wasn’t available.
- The graphing or visualization capabilities spreadsheets offer is helpful for reports.
- As economic and market factors change, pivot tables allow CRE lenders to view the data that is most relevant from month-to-month.
Technology advancements open new doors
While spreadsheets have effectively served the purpose for banks, technology advancements now make it possible to manage CRE portfolios in a more efficient and effective manner.
A few of the most relevant technology advancements include:
- Most core systems now allow for data to be easily extracted.
- Data mapping and storage technology make it easier to quickly derive value from a data export.
- SaaS models and cloud-based systems are faster and more scalable than spreadsheets.
- Data can be made interactive with products like Tableau and Power BI.
- Most security experts now agree that when properly managed, the safest way to store data that needs to be accessed by more than one party is in the cloud.
- Storing and backing up large amounts of data is now far more cost effective.
- Processing improvements have made evaluating large amounts of historical data fast enough to be commonplace.
Benefits of Finding the Right SaaS Solution
More time analyzing
When concentration reports are automated, more time can be spent exploring the results and better understanding the risk profile of the portfolio. CRE portfolios are often a material contributor to a bank’s revenue. Understanding how close we are to a regulatory threshold and being able to evaluate options quickly can mean more revenue for the bank.
Demonstrating to regulators that the bank proactively understands and is managing their risk profile can result in shorter audits and more flexible lending limits. Banks that have clear and consistent reports that allow them to drill in and show detail in a quick and consistent manner tend to have shorter audits and are granted more flexibility. The same tools that help management teams and boards stay on the same page and make sound strategic decisions, make it possible for auditors to understand and sign off on bank strategies.
What to look for when moving beyond spreadsheets
While some national banks have been able to leverage these technology advancements by hiring teams and building their own proprietary systems, most community banks are locked out of that path. Hiring the internal resources to build and maintain systems often proves to be cost prohibitive. Meanwhile, most off the shelf software does not meet key requirements for a community bank. So even if they have software in place, they end up pulling data into spreadsheets for deeper analysis.
The key elements to look for in a non-spreadsheet solution:
- Complex, industry-specific financial models must be built in and reliable. A software built specifically for the lending industry, by people who are focused on the lending industry’s challenges yields more reliable results than a broad-based solution.
- Configurability The software needs to allow an individual bank to measure and manage their specific policy-driven concentration limits and ratios. Most banks have a unique set of strategies and objectives. Those unique strategies set them apart and need to be measured and reported. Having the flexibility to generate bank-specific ratios and reports can prevent time-intensive manual work.
- The system must be highly secure. Clean SOC 2 Type II reports and systems that are designed by industry professionals who stay up to date on the latest in system security are essential.
For too long, spreadsheets have been the only viable option for community banks managing CRE loan portfolios. Now, the right SaaS solution can give banks deeper insight into their portfolios, open opportunities for increased revenue, shorten audits, automate monthly reporting, and save time spent finding and organizing data – all at a price point that works for community banks. It’s time to re-evaluate your CRE loan portfolio analysis solution.