iBusiness
Vol.10 No.03(2018), Article ID:86619,9 pages
10.4236/ib.2018.103007

A Fractional Programming Problem for Bank Asset and Liability Management

Ch. Ankhbayar, R. Enkhbat*

Business School, National University of Mongolia, Ulaanbaatar, Mongolia

Copyright © 2018 by authors and Scientific Research Publishing Inc.

This work is licensed under the Creative Commons Attribution International License (CC BY 4.0).

http://creativecommons.org/licenses/by/4.0/

Received: June 8, 2018; Accepted: August 10, 2018; Published: August 13, 2018

ABSTRACT

The purpose of the paper is to present an Asset Liability Management (ALM) technique which uses a fractional programming model to determine the balance sheet of a commercial bank in Mongolia. We examine the balance sheet of a commercial bank introducing some common ratios used in the Bank. Numerical results were done in case of Mongolia in Central Bank.

Keywords:

Asset and Liability Management, Banking, A Fractional Programming Problem

1. Introduction

Bank asset and liability management is defined as the simultaneous planning of all asset and liabilitypositions on the bank’s balance sheet under consideration of the different bank management objectives and legal, managerial and market constraints, for the purpose of mitigating interest rate risk, providing liquidity and enhancing the value of the bank [1] .

The central problem of ALM revolves around the bank’s balance sheet and the main question is that what should be the composition of a bank’s assets and liabilities on average given the corresponding returns and costs, in order to achieve certain goals, such as maximization of the bank’s gross revenue. This need has led banks to determine their optimal balance among profitability, risk, liquidity and other uncertainties. The optimal balance between these factors cannot be found without considering important interactions that exist between the structure of a bank’s liability and capital and the composition of its assets [2] .

Looking to the past, asset and liability management models can be classified in several approaches [3] . The first, based on Markowitz’s [4] theory of portfolio selection, assumes that returns are normally distributed and that bank managers utilize risk-averse utility functions. However, the model omits trading activity, matching assets and liabilities, transaction costs, and other similar features. The second approach is a linear programming model, proposed by Chambers and Charnes [5] . They were concerned with formulating, exploring and interpreting the use and construction which may be derived from a mathematical programming model which expresses more realistically than past efforts the actual conditions of current operations. However, this approach will not generate an optimal solution to the total problem, but rather acts as a deterministic simulation to observe portfolio behavior under various economic conditions [6] .

The third approach is dynamic programming, proposed by Samuelson [7] , Merton [8] , and Eppen and Fama [9] , who modeled of asset problems. These models are dynamic and account for the inherent uncertainty of the problem. However, given the small number of financial instruments that can be analyzed simultaneously, they are of limited use in practice. The fourth approach is a stochastic linear programming with simple recourse, which is also called linear programming under uncertainty. This technique explicitly characterizes each realization of the random variables by a constraint and leads to large problems in realistic situations. Cohen and Thore [10] viewed their model more as a tool for sensitivity analysis (in the aggregate) than a normative decision tool. The computational intractability and the perceptions of the formulation precluded consideration of problems other than those that were limited both in terms of time periods and in a number of variables and realizations.

The fifth, Eatman and Sealey [11] developed a multi-objective linear programming model for commercial bank balance sheet management considering profitability and solvency objectives subject to policy and managerial constraints. Indeed, Kusy and Ziemba [3] employed a multi-period stochastic linear program with simple recourse to model the management of assets and liabilities in banking while maintaining computational feasibility. Their results indicate that the proposed ALM model is theoretically and operationally superior to a corresponding deterministic linear programming model and that the computational effort required for its implementation is comparable to that of the deterministic model.

The sixth, Giokas and Vassiloglou [12] developed a goal-programming model for bank asset and liability management. Conventional linear programming is unable to deal with this kind of problem, as it can only handle a single goal in the objective function. Goal programming is the most widely used approach that solves large-scale multi-criteria decision making problem. Expansion of this approach is Kosmidou and Zopounidis [13] model, which determines the optimal balance among profitable, risk, liquidity and other uncertainties by considering several goals, such as the maximization of returns, the minimization of risk, the maintenance of a desirable level of liquidity and solvency, the expansion of deposits and loans.

The last approach is stochastic integer programming problem proposed by Schultz and Tiedermann [14] . The logical constraints in the portfolio impose upper bounds on the number of classes of assets to be considered in the portfolio and the number of assets to be traded in any time period. They also force conditional lower bounds on the volume to be traded in periods. Then, they claim that the stochastic continuous programming problem is converted to a stochastic integer programming problem. Most authors consider the problem with only continuous variables, see Kouwenberg and Zenios [15] , and Ziemba and Mulvey [16] .

ALM models have been developed by a mixed approach since the 2006. Escudero and Garin [17] developed on multistage stochastic integer programming for incorporating logical constraints in asset and liability management under uncertainty, where the 0 - 1 variables and the continuous variables appear at any stage. Zeng and Li [18] investigated continuous-time asset liability management under benchmark and mean-variance criteria in a jump diffusion market. The benchmark model was solved by employing the stochastic dynamic programming and its results are extended to the mean-variance model by adopting the duality theory. Mohammand and Sherafati [19] did an attempt to propose a model for optimizing liquidity management with goal programming perspective and integrating goal programming with fuzzy AHP.

The purpose of this paper is to develop a new type of a fractional programming problem for the bank asset liability management into a deterministic environment based on some common ratios.

2. Problem Formulation

The paper presents a new ALM methodology in a deterministic environment in order to choose strategic directions in a commercial bank’s financial plan. The formulation is based on a balance sheet information and 14 structural variables. 7 variables correspond to assets and another 7 variables to liabilities. In Table 1, we show these variables.

In order to formulate our model, we need to introduce the following ratio variables as follows:

v 1 = A 1 + A 2 + A 3 + A 4 L 1 + L 2 + L 3 + L 4 + L 5 , v 2 = A 5 A , v 3 = L 2 L 1 + L 2 + L 3 + L 4 + L 5 ,

v 4 = A 1 + A 2 + A 3 + A 4 A , v 5 = L 4 A , v 6 = A 5 + A 4 L 1 + L 2 + L 3 , v 7 = A 4 A ,

v 8 = L 1 + L 3 L , v 9 = L 4 L , v 10 = E L .

where v1: liquidity ratio, v2: total loans to total assets ratio, v3 and v8: stability and instability ratio of deposit, respectively, v4: liquidity asset ratio, v5: due to banks and financial sector to total assets ratio, v6: earning assets to total assets ratio, v7: financial investment ratio, v9: due to banks and financial sector to total liabilities ratio, v10: capital sufficiency.

Table 1. The decision variables.

Remark 1. If asset and liability management committee approve, then the following inequalities hold:

L 2 L 1 + L 3 , L 1 + L 2 L 4 , A 1 + A 2 + A 3 + A 4 L 4 , L 2 A 1 + A 2 + A 3 + A 4 ,

A 5 A 1 + A 2 + A 3 + 2 A 4 , A 6 + A 7 E , A 6 + A 7 A 4 , L 5 + L 6 E .

Remark 2. Based onremark 1, themain ratio variablessatisfy the following inequalities:

v 1 v 4 , v 3 v 8 , v 6 v 2 + v 7 , v 9 v 5 , v 8 v 9 ,

v 4 v 5 , v 3 v 4 , v 2 v 4 + v 7 .

Remark 3. It can be checked that if A 6 + A 7 A 4 then v 2 + v 4 + v 7 1 .

Proof: Indeed, this implies from Remark 1 and Remark 2;

A 5 A + A 1 + A 2 + A 3 + A 4 A + A 4 A = 1 ( A 6 + A 7 A 4 A ) 1.

Remark 4. If L 5 + L 6 E then v 3 + v 8 + v 9 + v 10 1 .

Proof: Taking into account that L = L 1 + L 2 + L 3 + L 4 + L 5 + L 6 ,we have

v 3 + v 8 + v 9 + v 10 = L 2 L 1 + L 2 + L 3 + L 4 + L 5 + L 1 + L 3 L + L 4 L + E L L 2 + L 1 + L 3 + L 4 + E L = L L 5 L 6 + E L = 1 + E L 5 L 6 L 1.

Remark 5. If A 6 + A 7 E then

v 2 + v 4 v 5 v 9 .

Proof: We have the following obvious equalities and inequalities:

v 2 + v 4 = A 5 A + A 1 + A 2 + A 3 + A 4 A = A ( A 6 + A 7 ) A = 1 A 6 + A 7 A 1 E A = L A = L 4 A L 4 L = v 5 v 9 .

3. Auxiliary Results

Lemma1. For v 1 , v 2 , , v 9 , we have

v 10 = v 1 v 3 v 4 ( v 9 v 5 ( v 2 + v 7 v 6 ) v 8 ) 1.

Proof: For the variables v 1 , v 3 , v 4 , v 5 , v 6 , we can write the following expression

v 1 v 3 v 4 = A 1 + A 2 + A 3 + A 4 L 1 + L 2 + L 3 + L 4 + L 5 L 2 L 1 + L 2 + L 3 + L 4 + L 5 A 1 + A 2 + A 3 + A 4 A = A L 2 ,

and

v 9 v 5 = L 4 L L 4 A = A L .

Indeed, denoting by D = L 1 + L 2 + L 3 , we get

v 2 + v 7 v 6 = A 5 A + A 4 A A 5 + A 4 D = D A .

Substituting all above expressions into formula of v 10 , we have

v 10 = A L 2 ( A L D A L 1 + L 3 L ) 1 = A L 2 ( L 1 + L 2 + L 3 L L 1 + L 3 L ) 1 = A L 1 = E L .

Lemma 2. For v 1 , v 2 , , v 9 , we have the connection:

v 1 = v 4 v 3 v 2 + v 7 v 6 v 8 v 5 v 9 .

Proof: From the definition of v 1 , we have

v 1 = A 1 + A 2 + A 3 + A 4 L 1 + L 2 + L 3 + L 4 + L 5 A A L 2 L 2 = v 4 v 3 A L 2 .

If we use D = L 1 + L 2 + L 3 , then L 2 is expressed as

L 2 = D L 3 L 1 = A 5 + A 4 v 6 L 3 L 1 = A v 6 A 5 + A 4 A L L 3 + L 1 L = A v 6 ( v 2 + v 7 ) L v 8 .

Consequently, we have

v 1 = v 4 v 3 A A v 6 ( v 2 + v 7 ) L v 8 = v 4 v 3 1 v 6 ( v 2 + v 7 ) L A L 3 L 3 v 8 = v 4 v 3 v 2 + v 7 v 6 v 8 v 5 v 9 .

which proves the lemma.

Lemma 3. For v 5 , v 9 , we have

v 5 v 9 = 1 1 + v 10 .

Proof: Substituting to v 5 , v 9 ,

v 9 v 5 = A L = 1 1 E L L A = 1 1 v 10 v 5 v 9 ,

If reducing it, then proves the lemma.

Lemma 4. If L 6 / A 0 , then

v 4 v 1 + 1 1 + v 10 0.

Proof: Substituting to v 10 ,

E = v 10 ( L 1 + L 2 + L 3 + L 4 + L 5 + L 6 ) = v 10 ( A E ) ,

and we obtain

E A = v 10 1 + v 10 .

In other words,

L 1 + L 2 + L 3 + L 4 + L 5 + L 6 A = 1 v 10 1 + v 10 ,

or

L 1 + L 2 + L 3 + L 4 + L 5 A = v 4 v 1 ,

Then, we get proof the lemma.

4. Formulation of a Fractional Programming

Now we consider the problem of maximizing a capital sufficiency subject to liquidity ratio, leverage, liquidity asset ratio and loan portfolio ratio, total deposits ratio, total liabilities ratio, and combine ratio.

f = v 1 v 2 v 9 + v 1 v 7 v 9 v 1 v 5 v 6 v 8 v 3 v 4 v 5 v 6 v 3 v 4 v 5 v 6 max ,

subject to constraints:

g 1 = v 1 v 2 v 9 + v 1 v 7 v 9 v 1 v 5 v 6 v 8 v 3 v 4 v 6 v 9 = 0 ,

g 2 = v 5 v 9 v 3 v 4 v 5 v 6 v 1 v 2 v 9 + v 1 v 7 v 9 v 1 v 5 v 6 v 8 = 0 ,

g 3 = v 2 + v 4 v 5 v 9 0 ,

g 4 = v 4 v 1 v 3 v 4 v 5 v 6 v 1 v 2 v 9 + v 1 v 7 v 9 v 1 v 5 v 6 v 8 0 ,

g 5 = v 3 + v 8 + v 9 + v 1 v 2 v 9 + v 1 v 7 v 9 v 1 v 5 v 6 v 8 v 3 v 4 v 5 v 6 v 3 v 4 v 5 v 6 1 0 ,

g 6 = v 2 + v 4 + v 7 1

( 1 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 1 0 0 0 1 1 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 1 1 0 0 0 0 0 0 1 1 0 0 0 0 0 0 1 0 1 0 0 1 0 0 ) ( v 1 v 2 v 3 v 4 v 5 v 6 v 7 v 8 v 9 ) ( 0 0 0 0 0 0 0 0 ) ,

v _ 1 v 1 v ¯ 1 , v _ 2 v 2 v ¯ 2 , v _ 3 v 3 v ¯ 3 ,

v _ 4 v 4 v ¯ 4 , v _ 5 v 5 v ¯ 5 , v _ 6 v 6 v ¯ 6 ,

v _ 7 v 7 v ¯ 7 , v _ 8 v 8 v ¯ 8 , v _ 9 v 9 v ¯ 9 .

where f: capital sufficiency from lemma 1, g1: liquidity ratio from lemma 2, g2: leverage from lemma 3, g3: liquidity asset ratio and loan portfolio ratio from remark 5, g4: total deposits ratio from lemma 4, g5: total liabilities ratio from remark 4, and g6: combine ratio from remark 3.

5. Numerical Results

The common ratio variables used in the specification of this model were taken directly as end of 2017 balance sheet of Top 5 commercial banks of Mongolia. We have shown the formulations below in Table 1, how to calculate these common ratios. Indeed, in Table 2, results are showed by calculation variables.

Top 5 commercial banks in Mongolia shares 86 percent of a commercial bank market. We have ranked highest to lowest in Table 2. The ratio variables are difference due to specific of the commercial banks. The last columns of this table are mean and standard deviation calculated by the common ratio variables of Top 5 commercial banks.

We use the following formulation to calculate upper and lower bound of this fractional programming model:

v ¯ i = m e a n ( i ) + 0.5 s t d e v ( i ) ,

v _ i = m e a n ( i ) 0.5 s t d e v ( i ) ,

i = 1 , 9 ¯ .

According to the formulation, the bounds found as follows:

0.483 v 1 0.544 , 0.432 v 2 0.507 , 0.340 v 3 0.429 ,

0.424 v 4 0.474 , 0.188 v 5 0.287 , 1.025 v 6 1.381 ,

0.122 v 7 0.211 , 0.203 v 8 0.281 , 0.209 v 9 0.312.

Table 2. The calculation variables.

Source: Audited report of individual commercial bank.

Optimal solutions found by MATLAB were v 10 * = 0.092 v 1 * = 0.522 , v 2 * = 0.502 , v 3 * = 0.340 , v 4 * = 0.429 , v 5 * = 0.208 , v 6 * = 1.232 , v 8 * = 0.281 and v 9 * = 0.239 .

6. Concluding Remarks

The problem of maximizing a capital sufficiency subject to the ratios of the bank indicators for the first time has been formulated a fractional programming problem. The problem is nonconvex hard optimization problem. Solution of this problem is very suitable for realistic situation and the bank asset and liability management can describe where we are going on the market by analyzing competition impacts.

Conflicts of Interest

The authors declare no conflicts of interest regarding the publication of this paper.

Cite this paper

Ankhbayar, Ch. and Enkhbat, R. (2018) A Fractional Programming Problem for Bank Asset and Liability Management. iBusiness, 10, 119- 127. https://doi.org/10.4236/ib.2018.103007

References

  1. 1. Gup, B.E. and Brooks, R. (1993) Interest Rate Risk Management. Irwin Professional Publishing, Burr Ridge.

  2. 2. Kosmidou, K. and Zopounidis, C. (2008) Generating Interest Rate Scenarios for Bank Asset Liability Management. Optimization Letters, 2, 157-169. https://doi.org/10.1007/s11590-007-0050-9

  3. 3. Kusy, I.M. and Ziemba, T.W. (1986) A Bank Asset and Liability Management Model. Operations Research, 34, 356-376. https://doi.org/10.1287/opre.34.3.356

  4. 4. Markowitz, H.M. (1959) Portfolio Selection, Efficient Diversification of Investments. John Wiley & Sons, New York.

  5. 5. Chambers, D. and Charnes, A. (1961) Inter-Temporal Analysis and Optimization of Bank Portfolios. Management Science, 7, 393-410. https://doi.org/10.1287/mnsc.7.4.393

  6. 6. Birge, J.R. (1983) The Value of the Stochastic Solution in Stochastic Linear Programs with Fixed Recourse. Mathematical Programming, 24, 314-325. https://doi.org/10.1007/BF01585113

  7. 7. Samuelson, P. (1969) Lifetime Portfolio Selection by Dynamic Stochastic Programming. Review of Economics and Statistics, 8, 239-246.

  8. 8. Merton, R.C. (1969) Lifetime Portfolio Selection under Certainty: Continuous Time Case. Review of Economics and Statistics, 3, 373-413.

  9. 9. Eppen, G.D. and Fama, E. F. (1971) Three Asset Cash Balance and Dynamic Portfolio Problems. Management Science, 17, 311-319. https://doi.org/10.1287/mnsc.17.5.311

  10. 10. Cohen, K.J. and Thore, S. (1970) Programming Bank Portfolio under Uncertainty. Journal of Bank Research, 2, 28-40.

  11. 11. Eatman, L. and Sealey, Jr. (1979) A Multi-Objective Linear Programming Model for Commercial Bank Balance Sheet Management. Journal of Bank Research, 9, 227-236.

  12. 12. Giokas, D. and Vassiloglou, M. (1991) A Goal Programming Model for Bank Assets and Liabilities. European Journal of Operations Research, 50, 48-60. https://doi.org/10.1016/0377-2217(91)90038-W

  13. 13. Kosmidou, K. and Zopounidis, C. (2002) A Multi-Objective Methodology for Bank Asset Liability Management. In: Pardalos, P.M. and Tsitsiringos, V.K., Eds., Financial Engineering, E-Commerce and Supply Chain, Kluwer Academic Publishers, Alphen aan den Rijn, 139-151.

  14. 14. Schultz, R. and Tiedemann, S. (2004) Risk Aversion via Excess Probabilities in Stochastic Programs with Mixed-Integers Recourse. SIAM Journal on Optimization, 14, 115-138. https://doi.org/10.1137/S1052623402410855

  15. 15. Kouwenberg, R. and Zenios, S. (2006) Stochastic Programming Models for Asset Liability Management. Handbook of Asset and Liability Management, Vol. 1. North-Holland, Amsterdam, 253-303.

  16. 16. Ziemba, W. and Mulvey, J. (1998) Worldwide Asset and Liability Modeling. Cambridge University Press, London.

  17. 17. Escudero, L.F. and Garin, A. (2009) On Multistage Stochastic Integer Programming for Incorporating Logical Constraints in Asset and Liability Management under Uncertainty. Computer Management Science, 6, 307-327. https://doi.org/10.1007/s10287-006-0035-7

  18. 18. Zeng, Y. and Li, Z. (2011) Asset Liability Management under Benchmark and Mean-Variance Criteria in a Jump Diffusion Market. Journal of Systems Science and Complex, 24, 317-327. https://doi.org/10.1007/s11424-011-9105-1

  19. 19. Mohammandi, R. and Sherafati, M. (2015) Optimization of Bank Liquidity Management Using Goal Programming and Fuzzy AHP. Research Journal of Recent Sciences, 4, 53-61.