From Excel to App: Data Analytics and AI in Real Estate Financing

Project with R+V Insurance: Smart forecasts for construction financing

Real estate financing is part of the core business of many insurance companies. However, manual processes often still dominate this area – from the initial inquiry to risk reporting. In a joint project with R+V Versicherung, our data analytics and AI experts demonstrate how intelligent digitalization not only saves time and money, but also enables more informed decisions to be made.

R+V Versicherung is active as a lender in the construction sector. It grants loans for private residential property as well as commercial real estate such as shopping centers and office buildings. Reliable forecasts play a key role in risk control, especially when estimating repayment patterns.

»Fixed repayment rates are relatively easy to predict. Statistical methods are needed to take into account special repayments, terminations, or deferrals. With sufficient data, machine learning methods often provide better predictions«, explains Dr. Jörg Wenzel.

All Business Data at a Glance – In One Intuitive App

Until now, much of the business data at banks and insurance companies has been maintained in Excel spreadsheets – with high effort and limited evaluation options. In a new app that our team is developing together with R+V Versicherung, all relevant information on real estate financing is bundled in a central database and made available via a dashboard.

 

Employees can use it to quickly create, edit, and analyze business transactions. The entire financing portfolio can be viewed with just a few clicks, and annual reports and management reports can also be generated directly from the tool. Initial feedback from users shows that the application also impresses with its user-friendly interface.

 

Visualization as a Decision-Making Aid

Another highlight of the app is that it offers a wide range of interactive visualizations – from time series analyses and customer overviews to competitive comparisons. These help to present complex data sets in a compact form and reveal business-relevant patterns. This makes data analytics and AI a real decision-making aid and real estate financing more efficient, transparent, and future-proof.