An approach to building a financial model for the purposes of planning resource products of the corporate segment in commercial banks

Abstract

Subject. The paper considers planning of resource products in the corporate business segment of a commercial bank. Objectives. The aim is to develop a model for planning financial results generated by attracted time deposit accounts and demand accounts of the corporate business segment in a commercial bank. Methods. I employ mathematical, statistical, and econometric methods and applied programming methods (SARIMA model for planning the profile of resource products of corporate clients, taking into account seasonality; the Ward's method for clustering corporate clients to create a pattern of financial behavior; SQL language for building uniquely designed models of resource product planning). Results. I identified the main drivers, algorithms and pricing principles of resource products. On their basis, I developed my own models for planning financial results from attracting time deposit accounts and demand accounts of the corporate business segment in a commercial bank. The uniquely designed planning models were tested on the basis of the medium-sized corporate business segment of one of the largest Russian commercial banks. Conclusions. The use of proprietary models enables to increase the accuracy of financial planning. The definition of a corporate client as the main driver contributes to the construction of a customer-oriented corporate customer service system, develops an incentive system, and allows to create additional incentives to increase cross-sales of banking products.