CMS Case Study
On Balance Sheet Liquidity Calculation
02/28/22 12,734 25,542 199,200 10,926 248,401
01/31/22 12,929 21,919 223,170
12/31/21
11/30/21 14,056 22,505 197,370 24,654 258,584
10/31/21
09/30/21
08/31/21 10,562 65,264 167,429 13,060 256,315
07/31/21 10,212 93,727 139,695 17,300 260,934
06/30/21
05/31/21
04/30/21 11,293 117,992 112,439
03/31/21
02/28/21 12,134 146,722 45,826
Cash & non-interest bearing bank balances
7,413
9,208
8,373
9,169
7,545
9,542
Interest bearing bank balances
34,489 212,376 25,353 279,630
45,549 193,564 21,905 270,227
45,826 187,408 67,334 308,941
94,123 137,305
118,488 111,901
151,173 60,309
Unpledged Securities
(Under)Over Collateralized Securities Pledging Postion
(9,517)
8,874
8,136
7,990
4,702
(1,808)
248,501
249,471
246,070
249,714
225,726
202,874
Total Deposits including Brokered
835,203
815,150
810,697
776,993
776,983
766,035
710,828
712,066
705,938
703,145
706,393
678,340
656,344
Liquid Assets/Deposits (Target 15%)
29.74%
30.49%
34.49%
33.28%
34.78%
40.33%
36.06%
36.64%
35.34%
35.00%
35.35%
33.28%
30.91%
Total Assets
987,023
970,869
964,860
940,440
907,568
896,832
843,720
839,830
830,395
829,440
817,367
790,352
774,832
Liquid Assets/Assets (Target 10%)
25.17%
25.60%
28.98%
27.50%
29.77%
34.45%
30.38%
31.07%
30.04%
29.67%
30.55%
28.56%
26.18%
Made with FlippingBook PDF to HTML5