Spreadsheet: 59675d1260266400-v-lookup-provide-no-figure-vlookup
Sheet: Sheet3 (2)

NIIVAR No | NIIVAR | NIIVAR Value Stream | NIIVAR Amount | CB No | CB_Consol | CB_Consol Value Stream | CB_Consol Amount
1 | OVERDRAFTS - CLEAN | CCPL | 38.42893482324059 | 1 | UNSECURED LENDING OTHERS (01#02151) | CCPL | 38.6294435958912 |  | -0.2005087726506076
 | OTHER LOANS - UNSECURED | CCPL | 0.2005087726506027 |  | UNSECURED LENDING OTHERS (01#02151) | CCPL | 0 |  | 0.2005087726506027
2 | OVERDRAFTS - CASH BACKED | WM | 29.6285723340963 | 2 | CASH BACKED (01#0415_01) | WM | 29.62857233409629 |  | 0
3 | MORTGAGES | Mortgages | 327.9563786442292 | 3 | MORTGAGE LOANS (Excl MOA) (01#0405_01) | Mortgages | 327.9563786442292 |  | 0
4 | MORTGAGE OD | Mortgages | 14.6878223940378 | 4 | MORTGAGE OVERDRAFT (01#00720) | Mortgages | 14.6878223940378 |  | 0
5 | PERSONAL LOANS | CCPL | 1335.195073225223 | 5 | INSTALLMENT LOANS-RET (01#00095) | CCPL | 1335.195073225224 |  | 0
6 | OTHER LOANS - SECURED | WM | 1.575547547001267 | 6 | SECURED PERSONAL LOANS (01#0410_02) | CCPL | 1.575547547001267 |  | 0
7 | CARDS | CCPL | 2516.429578034142 | 9 | CREDIT CARD-ACQUIRING (00010) | CCPL | 0 |  | 2516.429578034142
8 | CARDS | CCPL | 0 | 10 | CREDIT CARD-ISSUING (01#00005) | CCPL | 2564.70341863107 |  | -2564.70341863107
9 | AUTO LOANS | Auto | 0.01866195462328767 | 11 | AUTO LOANS (01#0410_01) | Auto | 0.01866195462328767 |  | 0
10 | READY CREDIT | CCPL | 0 | 12 | UNSECURED LENDING OTHERS (03#02151) | SME | 85.25596060863867 |  | -85.25596060863867
11 | NON INTEREST CURRENT ACCOUNT | CTB | 45.05946121956102 | 13 | INSTALLMENT LOANS-RET (03#00095) | SME | 114.7974960074788 |  | -69.73803478791777
12 | CURRENT ACCOUNT (Interest Bearing) | CTB | 3.381555386382431 | 14 | PERSONAL OVERDRAFTS-RET (03#00600) | SME | 3.308745993127589 |  | 0.07280939325484281
13 | CHEQUE AND SAVE | CTB | 15.93616154727651 | 15 | MORTGAGE (03#0405) | SME | 145.2215468025553 |  | -129.2853852552788
14 | SAVINGS ACCOUNTS | CTB | 111.7807296895787 | 16 | TERM LNS (03#0413_01) | SME | 0 |  | 111.7807296895787
15 | ACC INTEREST PAYABLE | CTB | 0 | 17 | BFS OVERDRAFTS (03#00935) | SME | 16.86851622998715 |  | -16.86851622998715
16 | BND FIXED DEPOSITS | CTB | 25.03697542304339 | 18 | SME OTH SECURED LOANS (03#0415_03) | SME | 0.4247339056089364 |  | 24.61224151743445
17 | PREPAID CARD | CCPL | 0 | 19 | OTHER AMS FEES (03#0505_04) | SME | 0 |  | 0
18 | PCD | WM | -160.4413125405925 | 20 | FX_ (03#1005_02) | SME | 0 |  | -160.4413125405925
19 | ADHOC DEPOSITS | CTB | 7.812088672113652 | 21 | IMPORT TRADE (03#0805_01) | SME | 18.28898608786936 |  | -10.47689741575571
20 | FOREIGN CURRENCY DEPOSITS | WM | 142.4725689161115 | 22 | GUARANTEES TRADE_ (03#0805_08) | SME | 0 |  | 142.4725689161115
21 | OTHER LOANS - UNSECURED | SME | 80.63523564567639 | 23 | REVOLVING CREDITS (01#00700) | CCPL | 0 |  | 80.63523564567639
22 | SECURED OD | SME | 16.86851622998715 | 24 | CURRENT ACCOUNTS-RET_ (03#0505_01) | SME | 247.0739262171684 |  | -230.2054099871812 | 23
23 | SECURED ORL | SME | 0.4247339056089364 | 25 | SAVINGS ACCOUNTS-RET (03#00035) | SME | 0.029245701773671 |  | 0.3954882038352654 | 1
24 | MORTGAGES | SME | 136.169581534382 | 26 | TIME DEPOSITS-RET_ (03#0505_03) | SME | 25.76817892636314 |  | 110.4014026080188
25 | MORTGAGE OD | SME | 9.051965268173307 | 27 | CURRENT ACCOUNTS-RET_ (01#0505_01) | CTB | 64.37717815322017 |  | -55.32521288504687
26 | BIL | SME | 114.7974960074788 | 28 | CURRENT ACCOUNTS-RET_ (01#0505_01) | CTB | 0 |  | 114.7974960074788
27 | WC: UNSECURED OD | SME | 3.308745993127588 | 29 | CURRENT ACCOUNTS-RET_ (01#0505_01) | CTB | 0 |  | 3.308745993127588
28 | OTHER UNSEC LENDING | SME | 4.620724962962295 | 30 | SAVINGS ACCOUNTS-RET (01#00035) | CTB | 111.7807296895787 |  | -107.1600047266164
29 | WC : CONTRACT FINANCING | SME | 0 | 31 | ?? |  | 0 |  | 0
30 | Trust Receipt | SME | 18.28898608786936 | 32 | TIME DEPOSITS-RET_ (01#0505_03) | CTB | 175.3216330112686 |  | -157.0326469233993
31 | SME LOANS | SME | 0 | 33 | ALM - CUSTOMER DEPOSITS (01#1005_05) | CTB | 0.02567155367172344 |  | -0.02567155367172344
32 | NIB BCA | SME | 247.3226621057492 | 34 | PREMIUM CURRENCY INVESTMENTS (01#1005_06) | WM | -160.4413125405925 |  | 407.7639746463417
33 | NIB FCA | SME | -0.6801647595474297 | 35 | TIME DEPOSITS-RET_ (01#0505_03) | CTB | 0 |  | -0.6801647595474297
34 | IB BCA | SME | 0.4312766609428382 | 36 | TIME DEPOSITS-RET_ (01#0505_03) | CTB | 0 |  | 0.4312766609428382
35 | IB FCA | SME | 0.0001522100237583333 | 37 | OTHER DEFINED PRODUCTS (01#00585) | WM | 0 |  | 0.0001522100237583333
36 | SAVINGS ACCOUNTS | SME | 0.029245701773671 | 38 | OTHER AMS FEES (01#0505_04) | CTB | 0 |  | 0.029245701773671
37 | BND FIXED DEPOSITS | SME | 12.85624672101406 | 39 | TRANSACTIONAL FX (01#1005_01) | WM | 0 |  | 12.85624672101406
38 | ADHOC DEPO | SME | 9.15474998459795 | 40 | INSURANCE SERVICES (01#00540) | WM | 0 |  | 9.15474998459795
39 | PCI | SME | 0 | 41 | UNIT TRUSTS (01#00545) | WM | 0 |  | 0
40 | FOREIGN CURRENCY DEPOSITS | SME | 3.757182220751153 | 42 | STRUCTURED  NOTES (01#01305) | WM | 0 |  | 3.757182220751153
41 |  |  |  | 43 | STRUCTURED DEPOSITS (01#1005_03) | WM | 0 |  | 0
 |  |  |  |  |  |  | 5160.49615467389 |  | -5160.49615467389
 |  |  | 5112.19664252329 |  |  |  | 5160.49615467389 |  | -48.29951215060009
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  | 5112.222314076962 |  | Total CB [NAME] |  | 5160.49615467389 |  | -48.27384059692849
 |  |  | -0.02567155367160012 |  |  |  | 0
 |  |  |  |  | 10
 |  |  |  |  | 1