{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Recommended Action Plan","Decision Model Rules","Test of Resilience","Summary Sheet","Insolvency Output","Interest Rate Output","Liquidity Output","Share Risks","Credit Risk-5","Credit Risk-4","Credit Risk-3","Credit Risk-2","Credit Risk-1","Interest Rate Input","Liquidity Input","Credit Input"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":290,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Recommended Action Plan","index":0,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[41,2,42,2],[41,3,42,3],[45,3,45,6],[39,2,40,2],[39,3,40,3],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
[null,null,"Rating","Zone"]
["Result of WAR MATRIX (Test-I)",{"$f":"'Test of Resilience'!I18","v":20},{"$f":"IF(B5>80,1,IF(B5>70,2,IF(B5>60,3,IF(B5>40,4,5))))","v":5}]
["Result of WIR MATRIX (Test-II)",{"$f":"'Test of Resilience'!H26","v":0},{"$f":"IF(B6<15%,1,IF(B6<25%,2,IF(B6<45%,3,IF(B6<60%,4,5))))","v":1}]
["WAR-WIR MATRIX",null,null,"WAR-WIR"]
[]
["Risk Factors","Recommended Action Plan"]
["1. Interest Risk –Increase in Interest Rate ",{"$f":"'Test of Resilience'!J9","v":"Submission of: Three Year Capital Management Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes."}]
["2. Credit Risk"]
["         – increase in NPLs ",{"$f":"'Test of Resilience'!J11","v":"Submission of: Three Year Capital Management Plan\nRecovery Plan of NPL"}]
["         – Downward shift in all Categories ",{"$f":"'Test of Resilience'!J12","v":"Submission of: Three Year Capital Management Plan\nRecovery Plan of NPL"}]
["         – Fall in the VES ",{"$f":"'Test of Resilience'!J13","v":"Submission of: Three Year Capital Management Plan\nIncrease Securities"}]
["         – Increase in NPLs’ under B/L category in 2 sectors  ",{"$f":"'Test of Resilience'!J14","v":"Submission of: Three Year Capital Management Plan\nCredit Diversification Plan"}]
["         – Increase in NPLs’ due to Top large loan borrowers  ",{"$f":"'Test of Resilience'!J15","v":"Submission of: Three Year Capital Management Plan"}]
["3. Equity price Risk – Fall in Stock Prices ",{"$f":"'Test of Resilience'!J16","v":"Submission of: Three Year Capital Management Plan\nPolicy for Investment in Shares"}]
["4. Liquidity Shock",{"$f":"'Test of Resilience'!J17","v":"Monitor strictly any downturn of performance indicators."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Single Shock","Scenario Total","WAR","Weight"]
[null,"G",1,"WAR≥ 80%","Scenario 1",0.6]
[null,"Y",0.8,"60%≤WAR<80%","Scenario 2",0.3]
[null,"R",0,"WAR<60%","Scenario 3",0.1]
[]
[]
[]
[]
[]
[null,null,"Zone","Single Shock","Rating","Scenario Total"]
[null,null,"G",1,1,"WAR≥ 80%"]
[null,null,"Y",0.8,2,"70%≤WAR<80%"]
[null,null,null,null,3,"60%≤WAR<70%"]
[null,null,"R",0,4,"40%≤WAR<60%"]
[null,null,null,null,5,"WAR<40%"]
[]
[]
[null,null,null,"WAR"]

{"sheet":"Decision Model Rules","index":1,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,0,4,1],[5,0,5,1],[3,0,3,1],[8,0,9,1],[8,2,8,4],[55,4,55,7],[10,0,12,0],[44,11,44,13],[49,3,50,3],[49,4,50,4],[51,3,52,3],[51,4,52,4]]}
["Name of the Institution :",null,{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",null,{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
[null,null,null,"Rating","Zone"]
["Result of WAR MATRIX (Test-I)",null,{"$f":"'Test of Resilience'!I18","v":20},{"$f":"IF(C5>80,1,IF(C5>70,2,IF(C5>60,3,IF(C5>40,4,5))))","v":5}]
["Result of WIR MATRIX (Test-II)",null,{"$f":"'Test of Resilience'!H26","v":0},{"$f":"IF(C6<15%,1,IF(C6<25%,2,IF(C6<45%,3,IF(C6<60%,4,5))))","v":1},null,null,null,null,null,null,null,null,0.1,0.11]
[]
["WAR-WIR MATRIX",null,null,null,null,null,null,null,null,null,null,null,1,0.8,0.6]
["WAR-WIR Matrix",null,"WAR"]
[null,null,"Green","Yellow","Red",null,null,null,null,null,null,null,{"$f":"#REF!*100*$M$8","v":{"$error":"#REF!"}},{"$f":"#REF!*100*$N$8","v":{"$error":"#REF!"}},{"$f":"M10*$O$8","v":{"$error":"#REF!"}}]
["WIR","Green",{"$f":"IF(AND(C5>80,C6<15%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(C5>60,C5=80,C6<15%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(C5<=60,C6<15%),'Credit Input'!C2,\"-\")","v":0},null,null,null,null,null,null,null,{"$f":"#REF!*100*$M$8","v":{"$error":"#REF!"}},{"$f":"#REF!*100*$N$8","v":{"$error":"#REF!"}},{"$f":"M11*$O$8","v":{"$error":"#REF!"}}]
[null,"Yellow",{"$f":"IF(AND(C5>80,C6>=15%,C6<45%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(C5>60,C5=80,C6>=15%,C6<45%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(C5<=60,C6>=15%,C6<45%),'Credit Input'!C2,\"-\")","v":"-"},null,null,null,null,null,null,null,{"$f":"#REF!*100*$M$8","v":{"$error":"#REF!"}},{"$f":"#REF!*100*$N$8","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,"Red",{"$f":"IF(AND(C5>80,C6>=45%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(C5>60,C5=80,C6>=45%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(C5<=60,C6>=45%),'Credit Input'!C2,\"-\")","v":"-"},null,null,null,null,null,null,null,{"$f":"#REF!*100*$M$8","v":{"$error":"#REF!"}},{"$f":"#REF!*100*$N$8","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C14*100*$M$8","v":0},{"$f":"C14*100*$N$8","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I8*0.8-34.57*0.2","v":-6.9140000000000006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R27/2","v":-3.4570000000000003}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Single Shock","Scenario Total","WAR","Weight"]
[null,null,"G",1,"WAR≥ 80%","Scenario 1",0.6]
[null,null,"Y",0.8,"60%≤WAR<80%","Scenario 2",0.3]
[null,null,"R",0,"WAR<60%","Scenario 3",0.1]
[]
[null,null,null,null,null,null,null,null,null,null,"Risk Shocks in Stress Testing"]
[null,null,null,null,null,null,null,null,null,null,"Risk Factors","HWAR"]
[]
[null,null,null,null,null,null,null,null,null,null,"1. Interest Risk –Increase in Interest Rate ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes.","Three Year Capital Management Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes."]
[null,null,null,"Zone","Single Shock","Rating","Scenario Total",null,null,null,"2. Credit Risk"]
[null,null,null,"G",1,1,"WAR≥ 80%",null,null,null,"         – increase in NPLs ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nRecovery Plan of NPL","Three Year Capital Management Plan\nRecovery Plan of NPL"]
[null,null,null,"Y",0.8,2,"70%≤WAR<80%",null,null,null,"         – Downward shift in NPLs’ Categories ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nRecovery Plan of NPL","Three Year Capital Management Plan\nRecovery Plan of NPL"]
[null,null,null,null,null,3,"60%≤WAR<70%",null,null,null,"         – Downward shift in all Categories ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nRecovery Plan of NPL","Three Year Capital Management Plan\nRecovery Plan of NPL"]
[null,null,null,"R",0,4,"40%≤WAR<60%",null,null,null,"         – Fall in the VES ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nIncrease Securities","Three Year Capital Management Plan\nIncrease Securities"]
[null,null,null,null,null,5,"WAR<40%",null,null,null,"         – Increase in NPLs’ under B/L category in 2 sectors  ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nCredit Diversification Plan","Three Year Capital Management Plan\nCredit Diversification Plan"]
[null,null,null,null,null,null,null,null,null,null,"         – Increase in NPLs’ due to Top large loan borrowers  ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan","Three Year Capital Management Plan"]
[null,null,null,null,null,null,null,null,null,null,"3. Equity price Risk – Fall in Stock Prices ","Monitor strictly any downturn of performance indicators.","Three Year Capital Management Plan\nPolicy for Investment in Shares","Three Year Capital Management Plan\nPolicy for Investment in Shares"]
[null,null,null,null,"WAR",null,null,null,null,null,"4. Liquidity Shock","Monitor strictly any downturn of performance indicators.","Liquidity Contingency Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes.","Liquidity Contingency Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes."]

{"sheet":"Test of Resilience","index":2,"n_rows":64,"n_cols":17,"rows_kept":64,"cut":false,"hidden":false,"merged":[[42,10,42,12],[57,2,58,2],[57,3,58,3],[59,2,60,2],[59,3,60,3],[63,3,63,6],[30,3,32,3],[5,8,6,8],[5,9,6,9],[7,2,7,3],[7,4,7,5],[7,6,7,7],[17,2,17,3],[17,4,17,5],[17,6,17,7],[28,3,29,4],[25,1,25,2],[22,1,24,2],[21,1,21,7],[28,1,32,2],[28,5,28,7],[4,0,4,7],[5,0,6,0],[5,1,6,1],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Test-I : WAR MATRIX"]
["Risk Shocks in Stress Testing"]
["Risk Factors",null,"Minor",null,"Moderate",null,"Major",null,"HWAR","RAP",null,0.1,0.12]
[null,null,"Zone","Score","Zone","Score","Zone","Score",null,null,null,1,0.8,0.6]
[null,"Weight",{"$f":"F38","v":0.5},null,{"$f":"F39","v":0.3},null,{"$f":"F40","v":0.2},null,{"$f":"SUM(C8,E8,G8)","v":1}]
["1. Interest Risk –Increase in Interest Rate ",0.1,{"$f":"'Summary Sheet'!B14","v":0},{"$f":"IF(C9<$L$6,0,IF(C9<$M$6,100*B9*$C$39,100*B9))","v":0},{"$f":"'Summary Sheet'!C14","v":0},{"$f":"IF(E9<$L$6,0,IF(E9<$M$6,100*B9*$C$39,100*B9))","v":0},{"$f":"'Summary Sheet'!D14","v":0},{"$f":"IF(G9<$L$6,0,IF(G9<$M$6,100*B9*$C$39,100*B9))","v":0},{"$f":"D9*$F$38+F9*$F$39+H9*$F$40","v":0},{"$f":"IF(I9<=N9,M45,IF(I9<=M9,L45,K45))","v":"Submission of: Three Year Capital Management Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes."},null,{"$f":"B9*100*$L$7","v":10},{"$f":"B9*100*$M$7","v":8},{"$f":"L9*$N$7","v":6}]
["2. Credit Risk",{"$f":"SUM(B11:B15)","v":0.60000000000000009},null,{"$f":"SUM(D11:D15)","v":0},null,{"$f":"SUM(F11:F15)","v":0},null,{"$f":"SUM(H11:H15)","v":0},0,null,null,60.000000000000007,48.000000000000007,{"$f":"L10*$N$7","v":36}]
["         – increase in NPLs ",0.1,{"$f":"'Summary Sheet'!B22","v":0},{"$f":"IF(C11<$L$6,0,IF(C11<$M$6,100*B11*$C$39,100*B11))","v":0},{"$f":"'Summary Sheet'!C22","v":0},{"$f":"IF(E11<$L$6,0,IF(E11<$M$6,100*B11*$C$39,100*B11))","v":0},{"$f":"'Summary Sheet'!D22","v":0},{"$f":"IF(G11<$L$6,0,IF(G11<$M$6,100*B11*$C$39,100*B11))","v":0},0,{"$f":"IF(I11<=N11,M47,IF(I11<=M11,L47,K47))","v":"Submission of: Three Year Capital Management Plan\nRecovery Plan of NPL"},null,10,8,6]
["         – Downward shift in all Categories ",0.1,{"$f":"'Summary Sheet'!B29","v":0},0,{"$f":"'Summary Sheet'!C29","v":0},0,{"$f":"'Summary Sheet'!D29","v":0},0,0,{"$f":"IF(I12<=N12,M48,IF(I12<=M12,L48,K48))","v":"Submission of: Three Year Capital Management Plan\nRecovery Plan of NPL"},null,10,8,6]
["         – Fall in the VES ",0.05,{"$f":"'Summary Sheet'!B36","v":0},0,{"$f":"'Summary Sheet'!C36","v":0},0,{"$f":"'Summary Sheet'!D36","v":0},0,0,"Submission of: Three Year Capital Management Plan\nIncrease Securities",null,5,4,3]
["         – Increase in NPLs’ under B/L category in 2 sectors  ",0.15,{"$f":"'Summary Sheet'!B43","v":0},0,{"$f":"'Summary Sheet'!C43","v":0},0,{"$f":"'Summary Sheet'!D43","v":0},0,0,"Submission of: Three Year Capital Management Plan\nCredit Diversification Plan",null,15,12,9]
["         – Increase in NPLs’ due to Top large loan borrowers  ",0.2,{"$f":"'Summary Sheet'!B54","v":0},0,{"$f":"'Summary Sheet'!C54","v":0},0,{"$f":"'Summary Sheet'!D54","v":0},0,0,"Submission of: Three Year Capital Management Plan",null,20,16,12]
["3. Equity price Risk – Fall in Stock Prices ",0.1,{"$f":"'Summary Sheet'!B68","v":0},0,{"$f":"'Summary Sheet'!C68","v":0},0,{"$f":"'Summary Sheet'!D68","v":0},0,0,"Submission of: Three Year Capital Management Plan\nPolicy for Investment in Shares",null,10,8,6]
["4. Liquidity Shock",0.2,{"$f":"CONCATENATE('Summary Sheet'!B79,\" \",\"-\",\" \",'Summary Sheet'!B80,\" \",\"-\",\" \",'Summary Sheet'!B81)","v":"1 - 1 - 1"},{"$f":"IF(SUM('Summary Sheet'!B79:B81)<2,0,IF(SUM('Summary Sheet'!B79:B81)<3,100*B17*$C$39,100*B17))","v":20},{"$f":"CONCATENATE('Summary Sheet'!C79,\" \",\"-\",\" \",'Summary Sheet'!C80,\" \",\"-\",\" \",'Summary Sheet'!C81)","v":"1 - 1 - 1"},{"$f":"IF(SUM('Summary Sheet'!C79:C81)<2,0,IF(SUM('Summary Sheet'!C79:C81)<3,100*B17*$C$39,100*B17))","v":20},{"$f":"CONCATENATE('Summary Sheet'!D79,\" \",\"-\",\" \",'Summary Sheet'!D80,\" \",\"-\",\" \",'Summary Sheet'!D81)","v":"1 - 1 - 1"},{"$f":"IF(SUM('Summary Sheet'!D79:D81)<2,0,IF(SUM('Summary Sheet'!D79:D81)<3,100*B17*$C$39,100*B17))","v":20},20,"Monitor strictly any downturn of performance indicators.",null,{"$f":"B17*100*$L$7","v":20},{"$f":"B17*100*$M$7","v":16},12]
["VWAR",{"$f":"SUM(B9,B10,B16,B17)","v":1},{"$f":"SUM(D17,D16,D10,D9)","v":20},null,{"$f":"SUM(F17,F16,F10,F9)","v":20},null,{"$f":"SUM(H17,H16,H10,H9)","v":20},null,{"$f":"C18*F38+E18*F39+G18*F40","v":20}]
[]
[]
["Test-II : WIR MATRIX"]
[null,"Risk Shocks in Stress Testing"]
[null,"Risk Factors",null,null,"Minor","Moderate","Major","WIR"]
[null,null,null,null,"Zone","Zone","Zone"]
[null,null,null,"Weight",0.5,0.3,0.2,null,null,null,null,null,null,null,null,null,{"$f":"I18*0.8-34.57*0.2","v":9.0859999999999985}]
[null,"1. Credit Risk shocks–Increase in NPL",null,null,{"$f":"'Summary Sheet'!B106","v":0},{"$f":"'Summary Sheet'!C106","v":0},{"$f":"'Summary Sheet'!D106","v":0},{"$f":"E26*E25+F26*F25+G26*G25","v":0},null,null,null,null,null,null,null,null,{"$f":"Q25/2","v":4.5429999999999993}]
[]
[]
[null,null,null,"WAR-WIR Matrix",null,"WAR"]
[null,null,null,null,null,"Green","Yellow","Red"]
[null,null,null,"WIR","Green",{"$f":"IF(AND(I18>=80,H26<10%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(I18>=60,I18<80,H26<10%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(I18<60,H26<10%),'Credit Input'!C2,\"-\")","v":0}]
[null,null,null,null,"Yellow",{"$f":"IF(AND(I18>=80,H26>=10%,H26<40%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(I18>=60,I18<80,H26>=10%,H26>=10%,H26<40%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(I18<60,H26>=10%,H26<40%),'Credit Input'!C2,\"-\")","v":"-"}]
[null,null,null,null,"Red",{"$f":"IF(AND(I18>=80,H26>=40%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(I18>=60,I18<80,H26>=40%),'Credit Input'!C2,\"-\")","v":"-"},{"$f":"IF(AND(I18<60,H26>=40%),'Credit Input'!C2,\"-\")","v":"-"}]
[]
[]
[]
[null,null,"Single Shock","Scenario Total","WAR","Weight"]
[null,"G",1,"WAR≥ 80%","Scenario 1",0.5]
[null,"Y",0.8,"60%≤WAR<80%","Scenario 2",0.3]
[null,"R",0,"WAR<60%","Scenario 3",0.2]
[]
[null,null,null,null,null,null,null,null,null,"Risk Shocks in Stress Testing"]
[null,null,null,null,null,null,null,null,null,"Risk Factors","HWAR"]
[null,null,null,null,null,null,null,null,null,null,"G","Y","R"]
[null,null,null,null,null,null,null,null,null,"1. Interest Risk –Increase in Interest Rate ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes.","Submission of: Three Year Capital Management Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes."]
[null,null,null,null,null,null,null,null,null,"2. Credit Risk"]
[null,null,null,null,null,null,null,null,null,"         – increase in NPLs ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan\nRecovery Plan of NPL","Submission of: Three Year Capital Management Plan\nRecovery Plan of NPL"]
[null,null,null,null,null,null,null,null,null,"         – Downward shift in all Categories ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan\nRecovery Plan of NPL","Submission of: Three Year Capital Management Plan\nRecovery Plan of NPL"]
[null,null,null,null,null,null,null,null,null,"         – Fall in the VES ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan\nIncrease Securities","Submission of: Three Year Capital Management Plan\nIncrease Securities"]
[null,null,null,null,null,null,null,null,null,"         – Increase in NPLs’ under B/L category in 2 sectors  ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan\nCredit Diversification Plan","Submission of: Three Year Capital Management Plan\nCredit Diversification Plan"]
[null,null,null,null,null,null,null,null,null,"         – Increase in NPLs’ due to Top large loan borrowers  ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan","Submission of: Three Year Capital Management Plan"]
[null,null,null,null,null,null,null,null,null,"3. Equity price Risk – Fall in Stock Prices ","Monitor strictly any downturn of performance indicators.","Recommendation: Three Year Capital Management Plan\nPolicy for Investment in Shares","Submission of: Three Year Capital Management Plan\nPolicy for Investment in Shares"]
[null,null,null,null,null,null,null,null,null,"4. Liquidity Shock","Monitor strictly any downturn of performance indicators.","Recommendation: Liquidity Contingency Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes.","Submission of: Liquidity Contingency Plan\nEnsure proper compliance of ALM Guidelines\nALCO meeting minutes."]
[]
[]
[null,null,"Zone","Single Shock","Rating","Scenario Total"]
[null,null,"G",1,1,"WAR≥ 80%"]
[null,null,"Y",0.8,2,"70%≤WAR<80%"]
[null,null,null,null,3,"60%≤WAR<70%"]
[null,null,"R",0,4,"40%≤WAR<60%"]
[null,null,null,null,5,"WAR<40%"]
[]
[]
[null,null,null,"WAR"]

{"sheet":"Summary Sheet","index":3,"n_rows":112,"n_cols":6,"rows_kept":112,"cut":false,"hidden":false,"merged":[[55,0,55,3],[2,0,2,1],[8,0,8,3],[9,0,10,0],[16,0,16,3],[17,0,18,0],[83,0,83,3],[96,0,96,1],[101,0,101,3],[63,0,64,0],[23,0,23,3],[24,0,25,0],[30,0,30,3],[31,0,32,0],[38,0,39,0],[37,0,37,3],[48,0,48,3],[49,0,50,0],[62,0,62,3],[70,0,70,1],[75,0,75,3],[76,0,77,0]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
["Current Scenario"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0}]
["Risk Weigheted Assets (RWA) (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"IF(B5<>0,B4/B5,0)","v":0}]
[]
["1. Interest Rate Risk",null,null,"(BDT in Crore)"]
["                           Interest Rate Risk"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,0.02,0.04,0.06]
["Revised Capital ",{"$f":"'Interest Rate Output'!B19","v":0},{"$f":"'Interest Rate Output'!C19","v":0},{"$f":"'Interest Rate Output'!D19","v":0}]
["Revised RWA ",{"$f":"'Interest Rate Output'!B20","v":0},{"$f":"'Interest Rate Output'!C20","v":0},{"$f":"'Interest Rate Output'!D20","v":0}]
["Revised CAR",{"$f":"'Interest Rate Output'!B21","v":0},{"$f":"'Interest Rate Output'!C21","v":0},{"$f":"'Interest Rate Output'!D21","v":0},null,{"$f":"B14*100","v":0}]
[]
["2. Credit Risk"]
["CR-1: Credit Risk-Increase in NPL (UC Directly Downgraded to BL)"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"'Credit Input'!C56","v":0.02},{"$f":"'Credit Input'!D56","v":0.05},{"$f":"'Credit Input'!E56","v":0.1}]
["Revised Capital ",{"$f":"'Credit Risk-1'!B30","v":0},{"$f":"'Credit Risk-1'!C30","v":0},{"$f":"'Credit Risk-1'!D30","v":0}]
["Revised RWA ",{"$f":"'Credit Risk-1'!B31","v":0},{"$f":"'Credit Risk-1'!C31","v":0},{"$f":"'Credit Risk-1'!D31","v":0}]
["Revised CAR",{"$f":"'Credit Risk-1'!B32","v":0},{"$f":"'Credit Risk-1'!C32","v":0},{"$f":"'Credit Risk-1'!D32","v":0}]
[]
["CR-2: Credit Risk-Downward Shift in Loans (STD to SMA, SMA to SS, SS to DF & DF to BL)"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"'Credit Input'!F56","v":0.05},{"$f":"'Credit Input'!G56","v":0.1},{"$f":"'Credit Input'!H56","v":0.15}]
["Revised Capital ",{"$f":"'Credit Risk-2'!B22","v":0},{"$f":"'Credit Risk-2'!C22","v":0},{"$f":"'Credit Risk-2'!D22","v":0}]
["Revised RWA ",{"$f":"'Credit Risk-2'!B23","v":0},{"$f":"'Credit Risk-2'!C23","v":0},{"$f":"'Credit Risk-2'!D23","v":0}]
["Revised CAR",{"$f":"'Credit Risk-2'!B24","v":0},{"$f":"'Credit Risk-2'!C24","v":0},{"$f":"'Credit Risk-2'!D24","v":0}]
[]
["CR-3: Credit Risk-Fall in the Value of Eligible Securities"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"'Credit Input'!I56","v":0.1},{"$f":"'Credit Input'!J56","v":0.25},{"$f":"'Credit Input'!K56","v":0.5}]
["Revised Capital ",{"$f":"'Credit Risk-3'!B18","v":0},{"$f":"'Credit Risk-3'!C18","v":0},{"$f":"'Credit Risk-3'!D18","v":0}]
["Revised RWA ",{"$f":"'Credit Risk-3'!B19","v":0},{"$f":"'Credit Risk-3'!C19","v":0},{"$f":"'Credit Risk-3'!D19","v":0}]
["Revised CAR",{"$f":"'Credit Risk-3'!B20","v":0},{"$f":"'Credit Risk-3'!C20","v":0},{"$f":"'Credit Risk-3'!D20","v":0}]
[]
[{"$f":"CONCATENATE(\"CR-4: Credit Risk-Increase of NPLs in the\", \" \",VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,2,FALSE),\" \",\"Sector\",\" \",\"&\",\" \",\"in the\",\" \",VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,2,FALSE),\" \",\"Sector\")","v":"CR-4: Credit Risk-Increase of NPLs in the Trade and Commerce Sector & in the Garments and Knitwear Sector"}]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"'Credit Input'!L56","v":0.05},{"$f":"'Credit Input'!M56","v":0.1},{"$f":"'Credit Input'!N56","v":0.15}]
["Revised Capital ",{"$f":"'Credit Risk-4'!B30","v":0},{"$f":"'Credit Risk-4'!C30","v":0},{"$f":"'Credit Risk-4'!D30","v":0}]
["Revised RWA ",{"$f":"'Credit Risk-4'!B31","v":0},{"$f":"'Credit Risk-4'!C31","v":0},{"$f":"'Credit Risk-4'!D31","v":0}]
["Revised CAR",{"$f":"'Credit Risk-4'!B32","v":0},{"$f":"'Credit Risk-4'!C32","v":0},{"$f":"'Credit Risk-4'!D32","v":0}]
[]
[]
[]
["Signature",null,null,"Signature"]
["Head Of Risk Management",null,null,"Managing Director"]
["CR-5: Credit Risk-Increase of NPLs Due to Top 10 Borrowers"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!O56,\" \",\" \",\"Borrowers\")","v":"Top 3  Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!P56,\" \",\" \",\"Borrowers\")","v":"Top 5  Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!Q56,\" \",\" \",\"Borrowers\")","v":"Top 10  Borrowers"}]
["Revised Capital ",{"$f":"'Credit Risk-5'!B33","v":0},{"$f":"'Credit Risk-5'!C33","v":0},{"$f":"'Credit Risk-5'!D33","v":0}]
["Revised RWA ",{"$f":"'Credit Risk-5'!B34","v":0},{"$f":"'Credit Risk-5'!C34","v":0},{"$f":"'Credit Risk-5'!D34","v":0}]
["Revised CAR",{"$f":"'Credit Risk-5'!B35","v":0},{"$f":"'Credit Risk-5'!C35","v":0},{"$f":"'Credit Risk-5'!D35","v":0}]
[]
["Combined Shocks (All of the Credit Shocks)"]
["Magnitude of Shock","Minor","Moderate","Major"]
["Revised Capital ",{"$f":"$B$4-('Credit Risk-1'!B29+'Credit Risk-2'!B21+'Credit Risk-3'!B17+'Credit Risk-4'!B29+'Credit Risk-5'!B32)","v":0},{"$f":"$B$4-('Credit Risk-1'!C29+'Credit Risk-2'!C21+'Credit Risk-3'!C17+'Credit Risk-4'!C29+'Credit Risk-5'!C32)","v":0},{"$f":"$B$4-('Credit Risk-1'!D29+'Credit Risk-2'!D21+'Credit Risk-3'!D17+'Credit Risk-5'!D32)","v":0}]
["Revised RWA ",{"$f":"$B$5-('Credit Risk-1'!B29+'Credit Risk-2'!B21+'Credit Risk-3'!B17+'Credit Risk-4'!B29+'Credit Risk-5'!B32)","v":0},{"$f":"$B$5-('Credit Risk-1'!C29+'Credit Risk-2'!C21+'Credit Risk-3'!C17+'Credit Risk-4'!C29+'Credit Risk-5'!C32)","v":0},{"$f":"$B$5-('Credit Risk-1'!D29+'Credit Risk-2'!D21+'Credit Risk-3'!D17+'Credit Risk-4'!D29+'Credit Risk-5'!D32)","v":0}]
["Revised CAR",{"$f":"IF(B59<>0,B58/B59,0)","v":0},{"$f":"IF(C59<>0,C58/C59,0)","v":0},{"$f":"IF(D59<>0,D58/D59,0)","v":0}]
[]
["3. Equity Price Risk"]
["Equity Price Risk"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"'Credit Input'!R56","v":0.1},{"$f":"'Credit Input'!S56","v":0.25},{"$f":"'Credit Input'!T56","v":0.5}]
["Revised Capital ",{"$f":"'Share Risks'!B14","v":0},{"$f":"'Share Risks'!C14","v":0},{"$f":"'Share Risks'!D14","v":0}]
["Revised RWA ",{"$f":"'Share Risks'!B15","v":0},{"$f":"'Share Risks'!C15","v":0},{"$f":"'Share Risks'!D15","v":0}]
["Revised CAR",{"$f":"'Share Risks'!B16","v":0},{"$f":"'Share Risks'!C16","v":0},{"$f":"'Share Risks'!D16","v":0}]
[]
["4. Liquidity Risk"]
["Current Scenario ( 1 = Satisfactory, 0 = Unsatisfactory)"]
["Negative gap during 1-90 days time buckets",{"$f":"IF('Liquidity Output'!B11<-15%,0,IF('Liquidity Output'!C11<-15%,0,IF('Liquidity Output'!D11<-15%,0,1)))","v":1},null,"1 = Satisfactory"]
["Cumulative gap up to 1 year",{"$f":"IF('Liquidity Output'!F13>15%,0,IF('Liquidity Output'!F13<-15%,0,1))","v":1},null,"0 = Unsatisfactory"]
["Counter balancing capacity up to 1 year",{"$f":"IF('Liquidity Output'!B12<0,0,IF('Liquidity Output'!C12<0,0,IF('Liquidity Output'!D12<0,0,IF('Liquidity Output'!E12<0,0,IF('Liquidity Output'!F12<0,0,1)))))","v":1}]
[]
["Liquidity Risk"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,{"$f":"'Liquidity Input'!B110","v":0.05},{"$f":"'Liquidity Input'!C110","v":7.0000000000000007E-2},{"$f":"'Liquidity Input'!D110","v":0.1}]
["Negative gap during 1-90 days time buckets",{"$f":"IF('Liquidity Output'!$B$19<-15%,0,IF('Liquidity Output'!$C$19<-15%,0,IF('Liquidity Output'!$D$19<-15%,0,1)))","v":1},{"$f":"IF('Liquidity Output'!$B$27<-15%,0,IF('Liquidity Output'!$C$27<-15%,0,IF('Liquidity Output'!$D$27<-15%,0,1)))","v":1},{"$f":"IF('Liquidity Output'!$B$35<-15%,0,IF('Liquidity Output'!$C$35<-15%,0,IF('Liquidity Output'!$D$35<-15%,0,1)))","v":1}]
["Cumulative gap up to 1 year",{"$f":"IF('Liquidity Output'!$F$21>15%,0,IF('Liquidity Output'!$F$21<-15%,0,1))","v":1},{"$f":"IF('Liquidity Output'!$F$29>15%,0,IF('Liquidity Output'!$F$29<-15%,0,1))","v":1},{"$f":"IF('Liquidity Output'!$F$37>15%,0,IF('Liquidity Output'!$F$37<-15%,0,1))","v":1}]
["Counter balancing capacity up to 1 year",{"$f":"IF('Liquidity Output'!$B$20<0,0,IF('Liquidity Output'!$C$20<0,0,IF('Liquidity Output'!$D$20<0,0,IF('Liquidity Output'!$E$20<0,0,IF('Liquidity Output'!$F$20<0,0,1)))))","v":1},{"$f":"IF('Liquidity Output'!$B$28<0,0,IF('Liquidity Output'!$C$28<0,0,IF('Liquidity Output'!$D$28<0,0,IF('Liquidity Output'!$E$28<0,0,IF('Liquidity Output'!$F$28<0,0,1)))))","v":1},{"$f":"IF('Liquidity Output'!$B$36<0,0,IF('Liquidity Output'!$C$36<0,0,IF('Liquidity Output'!$D$36<0,0,IF('Liquidity Output'!$E$36<0,0,IF('Liquidity Output'!$F$36<0,0,1)))))","v":1}]
[]
[]
["Combined Shocks (Interest Rate Risks, Credit Risks & Equity Price Risks)"]
["Magnitude of Shock","Minor","Moderate","Major"]
["Revised Capital ",{"$f":"$B$4-('Credit Risk-1'!B29+'Credit Risk-2'!B21+'Credit Risk-3'!B17+'Credit Risk-4'!B29+'Credit Risk-5'!B32+'Share Risks'!B13-'Interest Rate Output'!B18-'Interest Rate Output'!B17)","v":0},{"$f":"$B$4-('Credit Risk-1'!C29+'Credit Risk-2'!C21+'Credit Risk-3'!C17+'Credit Risk-4'!C29+'Credit Risk-5'!C32+'Share Risks'!C13-'Interest Rate Output'!C18-'Interest Rate Output'!C17)","v":0},{"$f":"$B$4-('Credit Risk-1'!D29+'Credit Risk-2'!D21+'Credit Risk-3'!D17+'Credit Risk-4'!D29+'Credit Risk-5'!D32+'Share Risks'!D13-'Interest Rate Output'!D18-'Interest Rate Output'!D17)","v":0}]
["Revised RWA ",{"$f":"$B$5-('Credit Risk-1'!B29+'Credit Risk-2'!B21+'Credit Risk-3'!B17+'Credit Risk-4'!B29+'Credit Risk-5'!B32+'Share Risks'!B13-'Interest Rate Output'!B18-'Interest Rate Output'!B17)","v":0},{"$f":"$B$5-('Credit Risk-1'!C29+'Credit Risk-2'!C21+'Credit Risk-3'!C17+'Credit Risk-4'!C29+'Credit Risk-5'!C32+'Share Risks'!C13-'Interest Rate Output'!C18-'Interest Rate Output'!C17)","v":0},{"$f":"$B$5-('Credit Risk-1'!D29+'Credit Risk-2'!D21+'Credit Risk-3'!D17+'Credit Risk-4'!D29+'Credit Risk-5'!D32+'Share Risks'!D13-'Interest Rate Output'!D18-'Interest Rate Output'!D17)","v":0}]
["Revised CAR",{"$f":"IF(B87<>0,B86/B87,0)","v":0},{"$f":"IF(C87<>0,C86/C87,0)","v":0},{"$f":"IF(D87<>0,D86/D87,0)","v":0}]
[]
[]
[]
[]
[]
["Signature",null,null,"Signature"]
["Head Of Risk Management",null,null,"Managing Director"]
[{"$f":"'Insolvency Output'!A4","v":"Insolvency Ratio"}]
["Current Scenario"]
[{"$f":"'Insolvency Output'!A10","v":"Infection Ratio (NPL to Loans)"},{"$f":"'Insolvency Output'!B10","v":0}]
[{"$f":"'Insolvency Output'!A11","v":"Critical Infection Ratio (CIR)"},{"$f":"'Insolvency Output'!B11","v":0}]
[{"$f":"'Insolvency Output'!A12","v":"Insolvency Ratio"},{"$f":"'Insolvency Output'!B12","v":0}]
[]
["Insolvency Ratio after Shocks"]
["Magnitude of Shock","Minor","Moderate","Major"]
[{"$f":"'Insolvency Output'!A10","v":"Infection Ratio (NPL to Loans)"},{"$f":"'Insolvency Output'!B30","v":0},{"$f":"'Insolvency Output'!C30","v":0},{"$f":"'Insolvency Output'!D30","v":0}]
[{"$f":"'Insolvency Output'!A11","v":"Critical Infection Ratio (CIR)"},{"$f":"'Insolvency Output'!B31","v":0},{"$f":"'Insolvency Output'!C31","v":0},{"$f":"'Insolvency Output'!D31","v":0}]
[{"$f":"'Insolvency Output'!A12","v":"Insolvency Ratio"},{"$f":"'Insolvency Output'!B32","v":0},{"$f":"'Insolvency Output'!C32","v":0},{"$f":"'Insolvency Output'!D32","v":0}]
[]
[]
[]
[]
["Signature",null,null,"Signature"]
["Head Of Risk Management",null,null,"Managing Director"]

{"sheet":"Insolvency Output","index":4,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,0,4,1],[15,0,15,3]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Insolvency Ratio"]
["Basic Information"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0}]
["Total Loan (BDT in Crore)",{"$f":"'Credit Input'!C43","v":0}]
["Total NPL (BDT in Crore)",{"$f":"SUM('Credit Input'!J43:K43,'Credit Input'!M43:N43,'Credit Input'!P43:Q43)","v":0}]
["Total of NPL and Regulatory Capital",{"$f":"B6+B8","v":0}]
["Infection Ratio (NPL to Loans)",{"$f":"IF(B7<>0,B8/B7,0)","v":0}]
["Critical Infection Ratio (CIR)",{"$f":"IF(B7<>0,B9/B7,0)","v":0}]
["Insolvency Ratio",{"$f":"IF(B11<>0,B10/B11,0)","v":0}]
[]
[]
[]
["Combined Shocks"]
["Magnitude of Shock","Minor","Moderate","Major"]
["Increase of NPL after CR-1",{"$f":"'Credit Risk-1'!B24","v":0},{"$f":"'Credit Risk-1'!C24","v":0},{"$f":"'Credit Risk-1'!D24","v":0}]
["Increase of NPL after CR-2",{"$f":"('Credit Risk-2'!$C$13+'Credit Risk-2'!$C$14)*'Credit Risk-2'!B18","v":0},{"$f":"('Credit Risk-2'!$C$13+'Credit Risk-2'!$C$14)*'Credit Risk-2'!C18","v":0},{"$f":"('Credit Risk-2'!$C$13+'Credit Risk-2'!$C$14)*'Credit Risk-2'!D18","v":0}]
["Increase of NPL after CR-4",{"$f":"'Credit Risk-4'!B24","v":0},{"$f":"'Credit Risk-4'!C24","v":0},{"$f":"'Credit Risk-4'!D24","v":0}]
["Increase of NPL after CR-5",{"$f":"'Credit Risk-5'!B31","v":0},{"$f":"'Credit Risk-5'!C31","v":0},{"$f":"'Credit Risk-5'!D31","v":0}]
["Revised Regulatory Capital after CR-1",{"$f":"'Credit Risk-1'!B30","v":0},{"$f":"'Credit Risk-1'!C30","v":0},{"$f":"'Credit Risk-1'!D30","v":0}]
["Revised Regulatory Capital after CR-2",{"$f":"'Credit Risk-2'!B22","v":0},{"$f":"'Credit Risk-2'!C22","v":0},{"$f":"'Credit Risk-2'!D22","v":0}]
["Revised Regulatory Capital after CR-4",{"$f":"'Credit Risk-4'!B30","v":0},{"$f":"'Credit Risk-4'!C30","v":0},{"$f":"'Credit Risk-4'!D30","v":0}]
["Revised Regulatory Capital after CR-5",{"$f":"'Credit Risk-5'!B33","v":0},{"$f":"'Credit Risk-5'!C33","v":0},{"$f":"'Credit Risk-5'!D33","v":0}]
["Increase of NPL",{"$f":"(B18+B19+B20+B21)/4","v":0},{"$f":"(C18+C19+C20+C21)/4","v":0},{"$f":"(D18+D19+D20+D21)/4","v":0}]
["Revised NPL",{"$f":"$B$8+B26","v":0},{"$f":"$B$8+C26","v":0},{"$f":"$B$8+D26","v":0}]
["Revised Regulatory Capital",{"$f":"(B22+B23+B24+B25)/4","v":0},{"$f":"(C22+C23+C24+C25)/4","v":0},{"$f":"(D22+D23+D24+D25)/4","v":0}]
["Total of NPL & Regulatory Capital",{"$f":"B27+B28","v":0},{"$f":"C27+C28","v":0},{"$f":"D27+D28","v":0}]
["Revised Infection Ratio (Revised NPL to Loans)",{"$f":"IF($B$7<>0,B27/$B$7,0)","v":0},{"$f":"IF($B$7<>0,C27/$B$7,0)","v":0},{"$f":"IF($B$7<>0,D27/$B$7,0)","v":0}]
["Revised Critical Infection Ratio ",{"$f":"IF($B$7<>0,B29/$B$7,0)","v":0},{"$f":"IF($B$7<>0,C29/$B$7,0)","v":0},{"$f":"IF($B$7<>0,D29/$B$7,0)","v":0}]
["Revised Insolvency Ratio",{"$f":"IF($B$31<>0,B30/B31,0)","v":0},{"$f":"IF($B$31<>0,C30/C31,0)","v":0},{"$f":"IF($B$31<>0,D30/D31,0)","v":0}]

{"sheet":"Interest Rate Output","index":5,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,3,5],[13,0,13,3],[14,0,15,0]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Particulars","Maturitywise Distribution of Assets-Liabilities"]
[null,"1 to 30/31 day (One month)","Over 1 month to 2 months","Over 2 months to 3 months","Over 3 months to 6 months","Over 6 months to 1 year"]
[1,2,3,4,5,6]
["A. TOTAL RATE SENSITIVE LIABILITIES (A)",{"$f":"'Interest Rate Input'!B18","v":0},{"$f":"'Interest Rate Input'!C18","v":0},{"$f":"'Interest Rate Input'!D18","v":0},{"$f":"'Interest Rate Input'!E18","v":0},{"$f":"'Interest Rate Input'!F18","v":0}]
["B. TOTAL RATE SENSITIVE ASSETS (B)",{"$f":"'Interest Rate Input'!B30","v":0},{"$f":"'Interest Rate Input'!C30","v":0},{"$f":"'Interest Rate Input'!D30","v":0},{"$f":"'Interest Rate Input'!E30","v":0},{"$f":"'Interest Rate Input'!F30","v":0}]
["C. MISMATCH",{"$f":"B8-B7","v":0},{"$f":"C8-C7","v":0},{"$f":"D8-D7","v":0},{"$f":"E8-E7","v":0},{"$f":"F8-F7","v":0}]
["D. CUMULATIVE MISMATCH",{"$f":"B9","v":0},{"$f":"B10+C9","v":0},{"$f":"C10+D9","v":0},{"$f":"D10+E9","v":0},{"$f":"E10+F9","v":0}]
["E. MISMATCH (%)",{"$f":"IF(B7<>0,(B8-B7)/B7,0)","v":0},{"$f":"IF(C7<>0,(C8-C7)/C7,0)","v":0},{"$f":"IF(D7<>0,(D8-D7)/D7,0)","v":0},{"$f":"IF(E7<>0,(E8-E7)/E7,0)","v":0},{"$f":"IF(F7<>0,(F8-F7)/F7,0)","v":0}]
[null,null,null,null,null,null,{"$f":"20700-19725","v":975}]
[]
["                           Interest Rate Risk"]
["Magnitude of Shock","Minor","Moderate","Major"]
[null,0.02,0.04,0.06]
["Change in the Value of Bond Portfolio (BDT in Crore)",{"$f":"-('Liquidity Input'!$C$102*'Liquidity Input'!$I$102*'Interest Rate Output'!B16)","v":0},{"$f":"-('Liquidity Input'!$C$102*'Liquidity Input'!$I$102*'Interest Rate Output'!C16)","v":0},{"$f":"-('Liquidity Input'!$C$102*'Liquidity Input'!$I$102*'Interest Rate Output'!D16)","v":0}]
["Net Interest Income (BDT in Crore)",{"$f":"$F$10*B16","v":0},{"$f":"$F$10*C16","v":0},{"$f":"$F$10*D16","v":0}]
["Revised Regulatory Capital (BDT in Crore)",{"$f":"'Credit Input'!$C$8+('Interest Rate Output'!B17+'Interest Rate Output'!B18)","v":0},{"$f":"'Credit Input'!$C$8+('Interest Rate Output'!C17+'Interest Rate Output'!C18)","v":0},{"$f":"'Credit Input'!$C$8+('Interest Rate Output'!D17+'Interest Rate Output'!D18)","v":0}]
["Risk Weighted Assets (BDT in Crore)",{"$f":"'Credit Input'!$C$9","v":0},{"$f":"'Credit Input'!$C$9","v":0},{"$f":"'Credit Input'!$C$9","v":0}]
["Revised CAR (%)",{"$f":"IF(B20<>0,B19/B20,0)","v":0},{"$f":"IF(C20<>0,C19/C20,0)","v":0},{"$f":"IF(D20<>0,D19/D20,0)","v":0}]

{"sheet":"Liquidity Output","index":6,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,0,4,0],[3,1,3,9]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,"(Amount in crore)"]
["Particulars","Maturitywise Distribution of Assets-Liabilities"]
[null,"1 to 30/31 day (One month)","Over 1 month to 2 months","Over 2 months to 3 months","Over 3 months to 6 months","Over 6 months to 1 year","Over 1 year to 3 years","Over 3 years to 5 years","Over 5 years","Total"]
[1,2,3,4,5,6,7,8,9,10]
["A. TOTAL OUTFLOWS (A)",{"$f":"'Liquidity Input'!B33","v":0},{"$f":"'Liquidity Input'!C33","v":0},{"$f":"'Liquidity Input'!D33","v":0},{"$f":"'Liquidity Input'!E33","v":0},{"$f":"'Liquidity Input'!F33","v":0},{"$f":"'Liquidity Input'!G33","v":0},{"$f":"'Liquidity Input'!H33","v":0},{"$f":"'Liquidity Input'!I33","v":0},{"$f":"'Liquidity Input'!J33","v":0}]
["B. TOTAL INFLOWS (B)",{"$f":"'Liquidity Input'!B56","v":0},{"$f":"'Liquidity Input'!C56","v":0},{"$f":"'Liquidity Input'!D56","v":0},{"$f":"'Liquidity Input'!E56","v":0},{"$f":"'Liquidity Input'!F56","v":0},{"$f":"'Liquidity Input'!G56","v":0},{"$f":"'Liquidity Input'!H56","v":0},{"$f":"'Liquidity Input'!I56","v":0},{"$f":"'Liquidity Input'!J56","v":0}]
["C. MISMATCH",{"$f":"B8-B7","v":0},{"$f":"C8-C7","v":0},0,0,0,0,0,0,0]
["D. CUMULATIVE MISMATCH",{"$f":"B9","v":0},{"$f":"B10+C9","v":0},0,0,0,0,0,0]
["E. MISMATCH (%)",{"$f":"IF(B7<>0,(B8-B7)/B7,0)","v":0},{"$f":"IF(C7<>0,(C8-C7)/C7,0)","v":0},0,0,0,0,0,0,0]
["F. CUMULATIVE COUNTER BALANCING CAPACITY (AFTER MISMATCH)",{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!B10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!C10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!D10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!E10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!F10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!G10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!H10","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)+'Liquidity Output'!I10","v":0},{"$f":"'Liquidity Output'!J9","v":0},null,100,{"$f":"L12*0.95","v":95},{"$f":"M12*0.95","v":90.25},{"$f":"N12*0.95","v":85.737499999999997},81.450624999999988,77.378093749999991,73.509189062499985,69.833729609374984,66.342043128906226]
[null,null,null,null,null,{"$f":"IF(SUM(B7:F7)<>0,F10/SUM(B7:F7),0)","v":0},null,null,null,null,{"$f":"20700-19725","v":975},null,{"$f":"100*(0.95)^8","v":66.342043128906241}]
[{"$f":"CONCATENATE(\"Scenario 1\",\"-\",\"Shock of\",\" \",'Liquidity Input'!B110*100,\"\",\"%\")","v":"Scenario 1-Shock of 5%"}]
["A. TOTAL OUTFLOWS (A)",{"$f":"$B$7+$C$7*'Liquidity Input'!B110","v":0},{"$f":"$C$7*(1-'Liquidity Input'!$B$110)+$D$7*'Liquidity Input'!$B$110","v":0},{"$f":"$D$7*(1-'Liquidity Input'!$B$110)+$E$7*'Liquidity Input'!$B$110","v":0},{"$f":"$E$7*(1-'Liquidity Input'!$B$110)+$F$7*'Liquidity Input'!$B$110","v":0},{"$f":"$F$7*(1-'Liquidity Input'!$B$110)+$G$7*'Liquidity Input'!$B$110","v":0},{"$f":"$G$7*(1-'Liquidity Input'!$B$110)+$H$7*'Liquidity Input'!$B$110","v":0},{"$f":"$H$7*(1-'Liquidity Input'!$B$110)+$I$7*'Liquidity Input'!$B$110","v":0},{"$f":"$I$7*(1-'Liquidity Input'!$B$110)","v":0},{"$f":"SUM(B15:I15)","v":0}]
["B. TOTAL INFLOWS (B)",{"$f":"$B$8*(1-'Liquidity Input'!$B$110)","v":0},{"$f":"$C$8*(1-'Liquidity Input'!$B$110)+$B$8*'Liquidity Input'!$B$110","v":0},{"$f":"$D$8*(1-'Liquidity Input'!$B$110)+$C$8*'Liquidity Input'!$B$110","v":0},{"$f":"$E$8*(1-'Liquidity Input'!$B$110)+$D$8*'Liquidity Input'!$B$110","v":0},{"$f":"$F$8*(1-'Liquidity Input'!$B$110)+$E$8*'Liquidity Input'!$B$110","v":0},{"$f":"$G$8*(1-'Liquidity Input'!$B$110)+$F$8*'Liquidity Input'!$B$110","v":0},{"$f":"$H$8*(1-'Liquidity Input'!$B$110)+$G$8*'Liquidity Input'!$B$110","v":0},{"$f":"$I$8+$H$8*'Liquidity Input'!$B$110","v":0},{"$f":"SUM(B16:I16)","v":0}]
["C. MISMATCH",{"$f":"B16-B15","v":0},{"$f":"C16-C15","v":0},0,0,0,0,0,0,0]
["D. CUMULATIVE MISMATCH",{"$f":"B17","v":0},{"$f":"B18+C17","v":0},{"$f":"C18+D17","v":0},0,0,0,0,0]
["E. MISMATCH (%)",{"$f":"IF(B15<>0,(B16-B15)/B15,0)","v":0},{"$f":"IF(C15<>0,(C16-C15)/C15,0)","v":0},0,0,0,0,0,0,0]
["F. CUMULATIVE COUNTER BALANCING CAPACITY (AFTER HAIRCUT & MISMATCH)",{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!B18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!C18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!D18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!E18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!F18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!G18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!H18","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$B$110)+'Liquidity Output'!I18","v":0}]
[null,null,null,null,null,{"$f":"IF(SUM(B15:F15)<>0,F18/SUM(B15:F15),0)","v":0}]
[{"$f":"CONCATENATE(\"Scenario 2\",\"-\",\"Shock of\",\" \",'Liquidity Input'!C110*100,\"\",\"%\")","v":"Scenario 2-Shock of 7%"}]
["A. TOTAL OUTFLOWS (A)",{"$f":"$B$7+$C$7*'Liquidity Input'!C110","v":0},{"$f":"$C$7*(1-'Liquidity Input'!C110)+$D$7*'Liquidity Input'!C110","v":0},{"$f":"$D$7*(1-'Liquidity Input'!C110)+$E$7*'Liquidity Input'!C110","v":0},{"$f":"$E$7*(1-'Liquidity Input'!C110)+$F$7*'Liquidity Input'!C110","v":0},{"$f":"$F$7*(1-'Liquidity Input'!C110)+$G$7*'Liquidity Input'!C110","v":0},{"$f":"$G$7*(1-'Liquidity Input'!C110)+$H$7*'Liquidity Input'!C110","v":0},{"$f":"$H$7*(1-'Liquidity Input'!C110)+$I$7*'Liquidity Input'!C110","v":0},{"$f":"$I$7*(1-'Liquidity Input'!C110)","v":0},{"$f":"SUM(B23:I23)","v":0}]
["B. TOTAL INFLOWS (B)",{"$f":"$B$8*(1-'Liquidity Input'!C110)","v":0},{"$f":"$C$8*(1-'Liquidity Input'!C110)+$B$8*'Liquidity Input'!C110","v":0},{"$f":"$D$8*(1-'Liquidity Input'!C110)+$C$8*'Liquidity Input'!C110","v":0},{"$f":"$E$8*(1-'Liquidity Input'!C110)+$D$8*'Liquidity Input'!C110","v":0},{"$f":"$F$8*(1-'Liquidity Input'!C110)+$E$8*'Liquidity Input'!C110","v":0},{"$f":"$G$8*(1-'Liquidity Input'!C110)+$F$8*'Liquidity Input'!C110","v":0},{"$f":"$H$8*(1-'Liquidity Input'!C110)+$G$8*'Liquidity Input'!C110","v":0},{"$f":"$I$8+$H$8*'Liquidity Input'!C110","v":0},{"$f":"SUM(B24:I24)","v":0}]
["C. MISMATCH",{"$f":"B24-B23","v":0},{"$f":"C24-C23","v":0},0,0,0,0,0,0,0]
["D. CUMULATIVE MISMATCH",{"$f":"B25","v":0},{"$f":"B26+C25","v":0},0,0,0,0,0,0]
["E. MISMATCH (%)",{"$f":"IF(B23<>0,(B24-B23)/B23,0)","v":0},{"$f":"IF(C23<>0,(C24-C23)/C23,0)","v":0},0,0,0,0,0,0,0]
["F. CUMULATIVE COUNTER BALANCING CAPACITY (AFTER HAIRCUT & MISMATCH)",{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!B26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!C26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!D26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!E26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!F26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!G26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!H26","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$C$110)+'Liquidity Output'!I26","v":0}]
[null,null,null,null,null,{"$f":"IF(SUM(B23:F23)<>0,F26/SUM(B23:F23),0)","v":0}]
[{"$f":"CONCATENATE(\"Scenario 3\",\"-\",\"Shock of\",\" \",'Liquidity Input'!D110*100,\"\",\"%\")","v":"Scenario 3-Shock of 10%"}]
["A. TOTAL OUTFLOWS (A)",{"$f":"$B$7+$C$7*'Liquidity Input'!D110","v":0},{"$f":"$C$7*(1-'Liquidity Input'!D110)+$D$7*'Liquidity Input'!D110","v":0},{"$f":"$D$7*(1-'Liquidity Input'!D110)+$E$7*'Liquidity Input'!D110","v":0},{"$f":"$E$7*(1-'Liquidity Input'!D110)+$F$7*'Liquidity Input'!D110","v":0},{"$f":"$F$7*(1-'Liquidity Input'!D110)+$G$7*'Liquidity Input'!D110","v":0},{"$f":"$G$7*(1-'Liquidity Input'!D110)+$H$7*'Liquidity Input'!D110","v":0},{"$f":"$H$7*(1-'Liquidity Input'!D110)+$I$7*'Liquidity Input'!D110","v":0},{"$f":"$I$7*(1-'Liquidity Input'!D110)","v":0},{"$f":"SUM(B31:I31)","v":0}]
["B. TOTAL INFLOWS (B)",{"$f":"$B$8*(1-'Liquidity Input'!D110)","v":0},{"$f":"$C$8*(1-'Liquidity Input'!D110)+$B$8*'Liquidity Input'!D110","v":0},{"$f":"$D$8*(1-'Liquidity Input'!D110)+$C$8*'Liquidity Input'!D110","v":0},{"$f":"$E$8*(1-'Liquidity Input'!D110)+$D$8*'Liquidity Input'!D110","v":0},{"$f":"$F$8*(1-'Liquidity Input'!D110)+$E$8*'Liquidity Input'!D110","v":0},{"$f":"$G$8*(1-'Liquidity Input'!D110)+$F$8*'Liquidity Input'!D110","v":0},{"$f":"$H$8*(1-'Liquidity Input'!D110)+$G$8*'Liquidity Input'!D110","v":0},{"$f":"$I$8+$H$8*'Liquidity Input'!D110","v":0},{"$f":"SUM(B32:I32)","v":0}]
["C. MISMATCH",{"$f":"B32-B31","v":0},{"$f":"C32-C31","v":0},0,0,0,0,0,0,0]
["D. CUMULATIVE MISMATCH",{"$f":"B33","v":0},{"$f":"B34+C33","v":0},0,0,0,0,0,0]
["E. MISMATCH (%)",{"$f":"IF(B31<>0,(B32-B31)/B31,0)","v":0},{"$f":"IF(C31<>0,(C32-C31)/C31,0)","v":0},0,0,0,0,0,0,0]
["F. CUMULATIVE COUNTER BALANCING CAPACITY (AFTER HAIRCUT & MISMATCH)",{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!B34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!C34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!D34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!E34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!F34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!G34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!H34","v":0},{"$f":"('Liquidity Input'!$B$104*0.5+'Liquidity Input'!$B$105*0.2)*(1-'Liquidity Input'!$D$110)+'Liquidity Output'!I34","v":0}]
[null,null,null,null,null,{"$f":"IF(SUM(B31:F31)<>0,F34/SUM(B31:F31),0)","v":0}]

{"sheet":"Share Risks","index":7,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Required Information"]
["Regulatory Capital (BDT in Crore)",{"$f":"'Credit Input'!C8","v":0}]
["Risk Weigheted Assets (RWA) (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"'Credit Input'!C10","v":0}]
["Total Exposure in Stock Market (BDT in Crore)",{"$f":"'Liquidity Input'!J43","v":0}]
["Provision Surplus/Shortfall (BDT in Crore)",{"$f":"'Credit Input'!C11","v":0}]
[]
["Fall in Stock Prices"]
["Magnitude of Shock",{"$f":"'Credit Input'!R56","v":0.1},0.25,0.5]
["Fall in the stock prices(BDT in Crore)",{"$f":"$B$8*B12","v":0},{"$f":"$B$8*C12","v":0},{"$f":"$B$8*D12","v":0}]
["Revised Capital(BDT in Crore)",{"$f":"IF(B13>=$B$9,$B$5-(B13-$B$9),$B$5)","v":0},{"$f":"IF(C13>=$B$9,$B$5-(C13-$B$9),$B$5)","v":0},{"$f":"IF(D13>=$B$9,$B$5-(D13-$B$9),$B$5)","v":0}]
["Revised Risk Weighted Assets(BDT in Crore)",{"$f":"IF(B13>=$B$9,$B$6-(B13-$B$9),$B$6)","v":0},{"$f":"IF(C13>=$B$9,$B$6-(C13-$B$9),$B$6)","v":0},{"$f":"IF(D13>=$B$9,$B$6-(D13-$B$9),$B$6)","v":0}]
["Revised CAR",{"$f":"IF(B15<>0,B14/B15,0)","v":0},{"$f":"IF(C15<>0,C14/C15,0)","v":0},{"$f":"IF(D15<>0,D14/D15,0)","v":0}]

{"sheet":"Credit Risk-5","index":8,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Required Information"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0}]
["Risk Weigheted Assets (RWA) (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"IF(B6<>0,B5/B6,0)","v":0}]
["Total Loan to Top 10 Borrowers (BDT in Crore)",{"$f":"'Credit Input'!C48","v":0}]
["Total Loans for which Eligible Securities Held (BDT in Crore)",{"$f":"'Credit Input'!C49","v":0}]
["Total Loans for which No Eligible Securities Held (BDT in Crore)",{"$f":"'Credit Input'!C50","v":0}]
["Value of Eligible Security (BDT in Crore)",{"$f":"'Credit Input'!C51","v":0}]
["Current Provisions (BDT in Crore)",{"$f":"(('Credit Input'!D43+'Credit Input'!E43)*'Credit Input'!C61+('Credit Input'!G43+'Credit Input'!H43)*'Credit Input'!D61+('Credit Input'!J43+'Credit Input'!K43-'Credit Input'!L43)*'Credit Input'!E61+('Credit Input'!M43+'Credit Input'!N43-'Credit Input'!O43)*'Credit Input'!F61+('Credit Input'!P43+'Credit Input'!Q43-'Credit Input'!R43)*'Credit Input'!G61)","v":0}]
["Provision Surplus/Shortfall (BDT in Crore)",{"$f":"'Credit Input'!C11","v":0}]
[]
["Loans without ES"]
["Magnitude of Shock",{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!O56,\" \", \"Borrowers\")","v":"Top 3 Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!P56,\" \", \"Borrowers\")","v":"Top 5 Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!Q56,\" \", \"Borrowers\")","v":"Top 10 Borrowers"}]
["Total Loans Disbursed to (BDT in Crore)",{"$f":"IF('Credit Input'!O56=10,('Credit Input'!$C$50),IF('Credit Input'!O56=9,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50+'Credit Input'!$K$50+'Credit Input'!$L$50),IF('Credit Input'!O56=8,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50+'Credit Input'!$K$50),IF('Credit Input'!O56=7,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50),IF('Credit Input'!O56=6,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50),IF('Credit Input'!O56=5,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50),IF('Credit Input'!O56=4,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50),IF('Credit Input'!O56=3,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50),IF('Credit Input'!O56=2,('Credit Input'!$D$50+'Credit Input'!$E$50),'Credit Input'!$D$50)))))))))","v":0},{"$f":"IF('Credit Input'!P56=10,('Credit Input'!$C$50),IF('Credit Input'!P56=9,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50+'Credit Input'!$K$50+'Credit Input'!$L$50),IF('Credit Input'!P56=8,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50+'Credit Input'!$K$50),IF('Credit Input'!P56=7,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50),IF('Credit Input'!P56=6,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50),IF('Credit Input'!P56=5,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50),IF('Credit Input'!P56=4,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50),IF('Credit Input'!P56=3,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50),IF('Credit Input'!P56=2,('Credit Input'!$D$50+'Credit Input'!$E$50),'Credit Input'!$D$50)))))))))","v":0},{"$f":"IF('Credit Input'!Q56=10,('Credit Input'!$C$50),IF('Credit Input'!Q56=9,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50+'Credit Input'!$K$50+'Credit Input'!$L$50),IF('Credit Input'!Q56=8,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50+'Credit Input'!$K$50),IF('Credit Input'!Q56=7,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50+'Credit Input'!$J$50),IF('Credit Input'!Q56=6,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50+'Credit Input'!$I$50),IF('Credit Input'!Q56=5,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50+'Credit Input'!$H$50),IF('Credit Input'!Q56=4,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50+'Credit Input'!$G$50),IF('Credit Input'!Q56=3,('Credit Input'!$D$50+'Credit Input'!$E$50+'Credit Input'!$F$50),IF('Credit Input'!Q56=2,('Credit Input'!$D$50+'Credit Input'!$E$50),'Credit Input'!$D$50)))))))))","v":0}]
["Increase in NPL (BDT in Crore)",{"$f":"B17*0.8","v":0},{"$f":"C17*0.8","v":0},{"$f":"D17*0.8","v":0}]
["Increase in Provisions \n",{"$f":"B18-(B18*'Credit Input'!$C$61)","v":0},{"$f":"C18-(C18*'Credit Input'!$C$61)","v":0},{"$f":"D18-(D18*'Credit Input'!$C$61)","v":0}]
[]
["Loans with ES"]
["Magnitude of Shock",{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!O56,\" \", \"Borrowers\")","v":"Top 3 Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!P56,\" \", \"Borrowers\")","v":"Top 5 Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!Q56,\" \", \"Borrowers\")","v":"Top 10 Borrowers"}]
["Total Loans Disbursed to (BDT in Crore)",{"$f":"IF('Credit Input'!O56=10,('Credit Input'!$C$49),IF('Credit Input'!O56=9,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49+'Credit Input'!$K$49+'Credit Input'!$L$49),IF('Credit Input'!O56=8,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49+'Credit Input'!$K$49),IF('Credit Input'!O56=7,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49),IF('Credit Input'!O56=6,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49),IF('Credit Input'!O56=5,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49),IF('Credit Input'!O56=4,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49),IF('Credit Input'!O56=3,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49),IF('Credit Input'!O56=2,('Credit Input'!$D$49+'Credit Input'!$E$49),'Credit Input'!$D$49)))))))))","v":0},{"$f":"IF('Credit Input'!P56=10,('Credit Input'!$C$49),IF('Credit Input'!P56=9,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49+'Credit Input'!$K$49+'Credit Input'!$L$49),IF('Credit Input'!P56=8,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49+'Credit Input'!$K$49),IF('Credit Input'!P56=7,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49),IF('Credit Input'!P56=6,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49),IF('Credit Input'!P56=5,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49),IF('Credit Input'!P56=4,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49),IF('Credit Input'!P56=3,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49),IF('Credit Input'!P56=2,('Credit Input'!$D$49+'Credit Input'!$E$49),'Credit Input'!$D$49)))))))))","v":0},{"$f":"IF('Credit Input'!Q56=10,('Credit Input'!$C$49),IF('Credit Input'!Q56=9,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49+'Credit Input'!$K$49+'Credit Input'!$L$49),IF('Credit Input'!Q56=8,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49+'Credit Input'!$K$49),IF('Credit Input'!Q56=7,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49+'Credit Input'!$J$49),IF('Credit Input'!Q56=6,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49+'Credit Input'!$I$49),IF('Credit Input'!Q56=5,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49+'Credit Input'!$H$49),IF('Credit Input'!Q56=4,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49+'Credit Input'!$G$49),IF('Credit Input'!Q56=3,('Credit Input'!$D$49+'Credit Input'!$E$49+'Credit Input'!$F$49),IF('Credit Input'!Q56=2,('Credit Input'!$D$49+'Credit Input'!$E$49),'Credit Input'!$D$49)))))))))","v":0}]
["Value of Eligible Securities (BDT in Crore)",{"$f":"IF('Credit Input'!O56=10,('Credit Input'!$C$51),IF('Credit Input'!O56=9,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51+'Credit Input'!$K$51+'Credit Input'!$L$51),IF('Credit Input'!O56=8,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51+'Credit Input'!$K$51),IF('Credit Input'!O56=7,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51),IF('Credit Input'!O56=6,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51),IF('Credit Input'!O56=5,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51),IF('Credit Input'!O56=4,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51),IF('Credit Input'!O56=3,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51),IF('Credit Input'!O56=2,('Credit Input'!$D$51+'Credit Input'!$E$51),'Credit Input'!$D$51)))))))))","v":0},{"$f":"IF('Credit Input'!P56=10,('Credit Input'!$C$51),IF('Credit Input'!P56=9,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51+'Credit Input'!$K$51+'Credit Input'!$L$51),IF('Credit Input'!P56=8,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51+'Credit Input'!$K$51),IF('Credit Input'!P56=7,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51),IF('Credit Input'!P56=6,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51),IF('Credit Input'!P56=5,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51),IF('Credit Input'!P56=4,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51),IF('Credit Input'!P56=3,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51),IF('Credit Input'!P56=2,('Credit Input'!$D$51+'Credit Input'!$E$51),'Credit Input'!$D$51)))))))))","v":0},{"$f":"IF('Credit Input'!Q56=10,('Credit Input'!$C$51),IF('Credit Input'!Q56=9,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51+'Credit Input'!$K$51+'Credit Input'!$L$51),IF('Credit Input'!Q56=8,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51+'Credit Input'!$K$51),IF('Credit Input'!Q56=7,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51+'Credit Input'!$J$51),IF('Credit Input'!Q56=6,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51+'Credit Input'!$I$51),IF('Credit Input'!Q56=5,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51+'Credit Input'!$H$51),IF('Credit Input'!Q56=4,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51+'Credit Input'!$G$51),IF('Credit Input'!Q56=3,('Credit Input'!$D$51+'Credit Input'!$E$51+'Credit Input'!$F$51),IF('Credit Input'!Q56=2,('Credit Input'!$D$51+'Credit Input'!$E$51),'Credit Input'!$D$51)))))))))","v":0}]
["Increase in NPL(BDT in Crore)",{"$f":"B23*0.8","v":0},{"$f":"C23*0.8","v":0},{"$f":"D23*0.8","v":0}]
["Increase in Provisions (after adjustment of eligible securities) (BDT in Crore)",{"$f":"(B23-B24)*0.8-B23*0.8*'Credit Input'!$C$61","v":0},{"$f":"(C23-C24)*0.8-C23*0.8*'Credit Input'!$C$61","v":0},{"$f":"(D23-D24)*0.8-D23*0.8*'Credit Input'!$C$61","v":0}]
[]
["Loans Total"]
["Magnitude of Shock",{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!O56,\" \", \"Borrowers\")","v":"Top 3 Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!P56,\" \", \"Borrowers\")","v":"Top 5 Borrowers"},{"$f":"CONCATENATE(\"Top\",\" \",'Credit Input'!Q56,\" \", \"Borrowers\")","v":"Top 10 Borrowers"}]
["Total Loans Disbursed to (BDT in Crore)",{"$f":"B17+B23","v":0},{"$f":"C17+C23","v":0},{"$f":"D17+D23","v":0}]
["Increase in NPL(BDT in Crore)",{"$f":"B18+B25","v":0},0,0]
["Increase in Provisions (BDT in Crore)",{"$f":"IF((B19+B26)>=$B$13,(B19+B26)-$B$13,0)","v":0},{"$f":"IF((C19+C26)>=$B$13,(C19+C26)-$B$13,0)","v":0},{"$f":"IF((D19+D26)>=$B$13,(D19+D26)-$B$13,0)","v":0}]
["Revised Capital(BDT in Crore)",{"$f":"$B$5-B32","v":0},{"$f":"$B$5-C32","v":0},{"$f":"$B$5-D32","v":0}]
["Revised Risk Weighted Assets(BDT in Crore)",{"$f":"$B$6-B32","v":0},{"$f":"$B$6-C32","v":0},{"$f":"$B$6-D32","v":0}]
["Revised CAR",{"$f":"IF(B34<>0,B33/B34,0)","v":0},{"$f":"IF(C34<>0,C33/C34,0)","v":0},{"$f":"IF(D34<>0,D33/D34,0)","v":0}]

{"sheet":"Credit Risk-4","index":9,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[18,1,18,2],[20,1,20,2],[8,0,9,0],[3,0,3,1],[19,1,19,2]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Basic Information"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0},null,null,{"$f":"VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,2,FALSE)","v":"Trade and Commerce"}]
["Risk Weigheted Assets (RWA) (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"IF(B6<>0,B5/B6,0)","v":0}]
[]
["Particulars","Sector of Highest Loan","Sector of 2nd Highest Loan"]
[null,{"$f":"VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,2,FALSE)","v":"Trade and Commerce"},{"$f":"VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,2,FALSE)","v":"Garments and Knitwear"},null,null,null,null,{"$f":"CONCATENATE(\"Loan Disbursed to\", \" \",VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,2,FALSE),\" \",\"Sector\")","v":"Loan Disbursed to Trade and Commerce Sector"}]
["Loan Disbursed to (BDT in Crore)",{"$f":"VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE)","v":0},{"$f":"VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE)","v":0}]
["Total NPL (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,11,FALSE)+VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,12,FALSE)+VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,14,FALSE)+(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,15,FALSE)+(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,17,FALSE)+(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,18,FALSE)))))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,11,FALSE)+VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,12,FALSE)+VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,14,FALSE)+(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,15,FALSE)+(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,17,FALSE)+(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,18,FALSE)))))),0)","v":0}]
["Total STD with ES (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,5,FALSE))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,5,FALSE))),0)","v":0}]
["Total STD without ES (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,6,FALSE))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,6,FALSE))),0)","v":0}]
["Value of Eligible Security Against STD (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,7,FALSE))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,7,FALSE))),0)","v":0}]
["Total SMA with ES (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,8,FALSE))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,8,FALSE))),0)","v":0}]
["Total SMA without ES (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,9,FALSE))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,9,FALSE))),0)","v":0}]
["Value of Eligible Security Against SMA (BDT in Crore)",{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,10,FALSE))),0)","v":0},{"$f":"IF(VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(21,'Credit Input'!$AB$17:$AT$38,10,FALSE))),0)","v":0}]
["Current Provisions (BDT in Crore)",{"$f":"(('Credit Input'!D43+'Credit Input'!E43)*'Credit Input'!C61+('Credit Input'!G43+'Credit Input'!H43)*'Credit Input'!D61+('Credit Input'!J43+'Credit Input'!K43-'Credit Input'!L43)*'Credit Input'!E61+('Credit Input'!M43+'Credit Input'!N43-'Credit Input'!O43)*'Credit Input'!F61+('Credit Input'!P43+'Credit Input'!Q43-'Credit Input'!R43)*'Credit Input'!G61)","v":0}]
["Provision Surplus/Shortfall (BDT in Crore)",{"$f":"'Credit Input'!C11","v":0}]
["NPL to Loans",{"$f":"IF(SUM(B11:C11)<>0,(SUM(B12:C12))/(SUM(B11:C11)),0)","v":0}]
[]
["Magnitude of Shock",{"$f":"'Credit Input'!L56","v":0.05},{"$f":"'Credit Input'!M56","v":0.1},{"$f":"'Credit Input'!N56","v":0.15}]
["Increase in NPL(BDT in Crore)",{"$f":"($B$13+$B$14+$B$16+$B$17+$C$13+$C$14+$C$16+$C$17)*B23","v":0},{"$f":"($B$13+$B$14+$B$16+$B$17+$C$13+$C$14+$C$16+$C$17)*C23","v":0},{"$f":"($B$13+$B$14+$B$16+$B$17+$C$13+$C$14+$C$16+$C$17)*D23","v":0}]
["Revised NPL(BDT in Crore)",{"$f":"$B$12+$C$12+B24","v":0},{"$f":"$B$12+$C$12+C24","v":0},{"$f":"$B$12+$C$12+D24","v":0}]
["Revised NPL to Loans Ratio",{"$f":"IF(SUM($B$11:$C$11)<>0,(B25)/(SUM($B$11:$C$11)),0)","v":0},{"$f":"IF(SUM($B$11:$C$11)<>0,(C25)/(SUM($B$11:$C$11)),0)","v":0},{"$f":"IF(SUM($B$11:$C$11)<>0,(D25)/(SUM($B$11:$C$11)),0)","v":0},{"$f":"(B25)/165","v":0}]
["Extra Provision for Loans without ES (BDT in Crore)",{"$f":"($B$14+$C$14+$B$17+$C$17)*B23-($B$14*'Credit Input'!$C$61+$C$14*'Credit Input'!$C$61+$B$17*'Credit Input'!$D$61+$C$17*'Credit Input'!$D$61)*B23","v":0},{"$f":"($B$14+$C$14+$B$17+$C$17)*C23-($B$14*'Credit Input'!$C$61+$C$14*'Credit Input'!$C$61+$B$17*'Credit Input'!$D$61+$C$17*'Credit Input'!$D$61)*C23","v":0},{"$f":"($B$14+$C$14+$B$17+$C$17)*D23-($B$14*'Credit Input'!$C$61+$C$14*'Credit Input'!$C$61+$B$17*'Credit Input'!$D$61+$C$17*'Credit Input'!$D$61)*D23","v":0}]
["Extra Provision for Loans with ES (BDT in Crore)",{"$f":"($B$13+$C$13+$B$16+$C$16-$B$15-$C$15-$B$18-$C$18)*B23-($B$13*'Credit Input'!$C$61+$C$13*'Credit Input'!$C$61+$B$16*'Credit Input'!$D$61+$C$16*'Credit Input'!$D$61)*B23","v":0},{"$f":"($B$13+$C$13+$B$16+$C$16-$B$15-$C$15-$B$18-$C$18)*C23-($B$13*'Credit Input'!$C$61+$C$13*'Credit Input'!$C$61+$B$16*'Credit Input'!$D$61+$C$16*'Credit Input'!$D$61)*C23","v":0},{"$f":"($B$13+$C$13+$B$16+$C$16-$B$15-$C$15-$B$18-$C$18)*D23-($B$13*'Credit Input'!$C$61+$C$13*'Credit Input'!$C$61+$B$16*'Credit Input'!$D$61+$C$16*'Credit Input'!$D$61)*D23","v":0}]
["Increase in Provisions \n",{"$f":"IF((B27+B28)>=$B$20,(B27+B28)-$B$20,0)","v":0},{"$f":"IF((C27+C28)>=$B$20,(C27+C28)-$B$20,0)","v":0},{"$f":"IF((D27+D28)>=$B$20,(D27+D28)-$B$20,0)","v":0}]
["Revised Capital(BDT in Crore)",{"$f":"$B$5-B29","v":0},{"$f":"$B$5-C29","v":0},{"$f":"$B$5-D29","v":0}]
["Revised Risk Weighted Assets(BDT in Crore)",{"$f":"$B$6-B29","v":0},{"$f":"$B$6-C29","v":0},{"$f":"$B$6-D29","v":0}]
["Revised CAR",{"$f":"IF(B31<>0,B30/B31,0)","v":0},{"$f":"IF(C31<>0,C30/C31,0)","v":0},{"$f":"IF(D31<>0,D30/D31,0)","v":0}]

{"sheet":"Credit Risk-3","index":10,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Required Information"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0}]
["Risk Weigheted Assets (RWA) (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"IF(B6<>0,B5/B6,0)","v":0}]
["VES for SS Loan (BDT in Crore)",{"$f":"'Credit Input'!L43","v":0}]
["VES for DF Loan (BDT in Crore)",{"$f":"'Credit Input'!O43","v":0}]
["VES for BL Loan (BDT in Crore)",{"$f":"'Credit Input'!R43","v":0}]
["Current Provisions (BDT in Crore)",{"$f":"(('Credit Input'!D43+'Credit Input'!E43)*'Credit Input'!C61+('Credit Input'!G43+'Credit Input'!H43)*'Credit Input'!D61+('Credit Input'!J43+'Credit Input'!K43-'Credit Input'!L43)*'Credit Input'!E61+('Credit Input'!M43+'Credit Input'!N43-'Credit Input'!O43)*'Credit Input'!F61+('Credit Input'!P43+'Credit Input'!Q43-'Credit Input'!R43)*'Credit Input'!G61)","v":0}]
["Provision Surplus/Shortfall (BDT in Crore)",{"$f":"'Credit Input'!C11","v":0}]
[]
[]
["Magnitude of Shock",{"$f":"'Credit Input'!I56","v":0.1},{"$f":"'Credit Input'!J56","v":0.25},{"$f":"'Credit Input'!K56","v":0.5}]
["Weighted Amount of Eligible Securities (BDT in Crore)",{"$f":"$B$8*'Credit Input'!$E$61+$B$9*'Credit Input'!$F$61+$B$10*'Credit Input'!$G$61","v":0},{"$f":"$B$8*'Credit Input'!$E$61+$B$9*'Credit Input'!$F$61+$B$10*'Credit Input'!$G$61","v":0},{"$f":"$B$8*'Credit Input'!$E$61+$B$9*'Credit Input'!$F$61+$B$10*'Credit Input'!$G$61","v":0}]
["Increase in Provisions (BDT in Crore)",{"$f":"IF(($B$8*B15*'Credit Input'!$E$61+$B$9*B15*'Credit Input'!$F$61+$B$10*B15*'Credit Input'!$G$61)>=$B$12,($B$8*B15*'Credit Input'!$E$61+$B$9*B15*'Credit Input'!$F$61+$B$10*B15*'Credit Input'!$G$61)-$B$12,0)","v":0},{"$f":"IF(($B$8*C15*'Credit Input'!$E$61+$B$9*C15*'Credit Input'!$F$61+$B$10*C15*'Credit Input'!$G$61)>=$B$12,($B$8*C15*'Credit Input'!$E$61+$B$9*C15*'Credit Input'!$F$61+$B$10*C15*'Credit Input'!$G$61)-$B$12,0)","v":0},{"$f":"IF(($B$8*D15*'Credit Input'!$E$61+$B$9*D15*'Credit Input'!$F$61+$B$10*D15*'Credit Input'!$G$61)>=$B$12,($B$8*D15*'Credit Input'!$E$61+$B$9*D15*'Credit Input'!$F$61+$B$10*D15*'Credit Input'!$G$61)-$B$12,0)","v":0}]
["Revised Capital (BDT in Crore)",{"$f":"$B$5-B17","v":0},{"$f":"$B$5-C17","v":0},{"$f":"$B$5-D17","v":0}]
["Revised Risk Weighted Assets (BDT in Crore)",{"$f":"$B$6-B17","v":0},{"$f":"$B$6-C17","v":0},{"$f":"$B$6-D17","v":0}]
["Revised CAR %",{"$f":"IF(B19<>0,B18/B19,0)","v":0},{"$f":"IF(C19<>0,C18/C19,0)","v":0},{"$f":"IF(D19<>0,D18/D19,0)","v":0}]

{"sheet":"Credit Risk-2","index":11,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Basic Information"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0}]
["Risk Weigheted Assets (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"IF(B6<>0,B5/B6,0)","v":0}]
["Current Provision (BDT in Crore)",{"$f":"(('Credit Input'!D43+'Credit Input'!E43)*'Credit Input'!C61+('Credit Input'!G43+'Credit Input'!H43)*'Credit Input'!D61+('Credit Input'!J43+'Credit Input'!K43-'Credit Input'!L43)*'Credit Input'!E61+('Credit Input'!M43+'Credit Input'!N43-'Credit Input'!O43)*'Credit Input'!F61+('Credit Input'!P43+'Credit Input'!Q43-'Credit Input'!R43)*'Credit Input'!G61)","v":0}]
["Provision Surplus/Shortfall",{"$f":"'Credit Input'!C11","v":0}]
[]
[]
["Particulars","STD","SMA","SS","DF"]
["Loans with ES (BDT in Crore)",{"$f":"'Credit Input'!D43","v":0},{"$f":"'Credit Input'!G43","v":0},{"$f":"'Credit Input'!J43","v":0},{"$f":"'Credit Input'!M43","v":0}]
["Loans without ES (BDT in Crore)",{"$f":"'Credit Input'!E43","v":0},{"$f":"'Credit Input'!H43","v":0},{"$f":"'Credit Input'!K43","v":0},{"$f":"'Credit Input'!N43","v":0}]
["Value of Eligible Security (BDT in Crore)",{"$f":"'Credit Input'!F43","v":0},{"$f":"'Credit Input'!I43","v":0},{"$f":"'Credit Input'!L43","v":0},{"$f":"'Credit Input'!O43","v":0}]
[]
[]
["Magnitude of Shock",{"$f":"'Credit Input'!F56","v":0.05},{"$f":"'Credit Input'!G56","v":0.1},{"$f":"'Credit Input'!H56","v":0.15}]
["Extra Provisions for Loans without ES (BDT in Crore)",{"$f":"($B$14*'Credit Input'!$D$61+$C$14*'Credit Input'!$E$61+$D$14*'Credit Input'!$F$61+$E$14*'Credit Input'!$G$61)*B18-($B$14*'Credit Input'!$C$61+$C$14*'Credit Input'!$D$61+$D$14*'Credit Input'!$E$61+$E$14*'Credit Input'!$F$61)*B18","v":0},{"$f":"($B$14*'Credit Input'!$D$61+$C$14*'Credit Input'!$E$61+$D$14*'Credit Input'!$F$61+$E$14*'Credit Input'!$G$61)*C18-($B$14*'Credit Input'!$C$61+$C$14*'Credit Input'!$D$61+$D$14*'Credit Input'!$E$61+$E$14*'Credit Input'!$F$61)*C18","v":0},{"$f":"($B$14*'Credit Input'!$D$61+$C$14*'Credit Input'!$E$61+$D$14*'Credit Input'!$F$61+$E$14*'Credit Input'!$G$61)*D18-($B$14*'Credit Input'!$C$61+$C$14*'Credit Input'!$D$61+$D$14*'Credit Input'!$E$61+$E$14*'Credit Input'!$F$61)*D18","v":0}]
["Extra Provisions for Loans with ES (BDT in Crore)",{"$f":"($B$13*'Credit Input'!$D$61+($C$13-$C$15)*'Credit Input'!$E$61+($D$13-$D$15)*'Credit Input'!$F$61+($E$13-$E$15)*'Credit Input'!$G$61)*B18-($B$13*'Credit Input'!$C$61+$C$13*'Credit Input'!$D$61+($D$13-$D$15)*'Credit Input'!$E$61+($E$13-$E$15)*'Credit Input'!$F$61)*B18","v":0},{"$f":"($B$13*'Credit Input'!$D$61+($C$13-$C$15)*'Credit Input'!$E$61+($D$13-$D$15)*'Credit Input'!$F$61+($E$13-$E$15)*'Credit Input'!$G$61)*C18-($B$13*'Credit Input'!$C$61+$C$13*'Credit Input'!$D$61+($D$13-$D$15)*'Credit Input'!$E$61+($E$13-$E$15)*'Credit Input'!$F$61)*C18","v":0},{"$f":"($B$13*'Credit Input'!$D$61+($C$13-$C$15)*'Credit Input'!$E$61+($D$13-$D$15)*'Credit Input'!$F$61+($E$13-$E$15)*'Credit Input'!$G$61)*D18-($B$13*'Credit Input'!$C$61+$C$13*'Credit Input'!$D$61+($D$13-$D$15)*'Credit Input'!$E$61+($E$13-$E$15)*'Credit Input'!$F$61)*D18","v":0}]
["Increase in Provisions (BDT in Crore)",{"$f":"IF((B19+B20)>=$B$9,B19+B20-$B$9,0)","v":0},{"$f":"IF((C19+C20)>=$B$9,C19+C20-$B$9,0)","v":0},{"$f":"IF((D19+D20)>=$B$9,D19+D20-$B$9,0)","v":0}]
["Revised Capital (BDT in Crore)",{"$f":"$B$5-B21","v":0},{"$f":"$B$5-C21","v":0},{"$f":"$B$5-D21","v":0}]
["Revised Risk Weighted Assets (BDT in Crore)",{"$f":"$B$6-B21","v":0},{"$f":"$B$6-C21","v":0},{"$f":"$B$6-D21","v":0}]
["Revised CAR %",{"$f":"IF(B23<>0,B22/B23,0)","v":0},{"$f":"IF(C23<>0,C22/C23,0)","v":0},{"$f":"IF(D23<>0,D22/D23,0)","v":0}]

{"sheet":"Credit Risk-1","index":12,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[8,0,8,1],[3,0,3,1]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
["Basic Information"]
["Regulatory Capital (BDT in Crore )",{"$f":"'Credit Input'!C8","v":0}]
["Risk Weigheted Assets (RWA) (BDT in Crore)",{"$f":"'Credit Input'!C9","v":0}]
["Capital Adequacy Ratio (CAR)",{"$f":"IF(B6<>0,B5/B6,0)","v":0}]
[]
["Required Information"]
["Total Loan (BDT in Crore)",{"$f":"'Credit Input'!C43","v":0}]
["Total NPL (BDT in Crore)",{"$f":"SUM('Credit Input'!J43:K43,'Credit Input'!M43:N43,'Credit Input'!P43:Q43)","v":0}]
["Total STD Loan with ES (BDT in Crore)",{"$f":"'Credit Input'!D43","v":0}]
["Total STD Loan without ES (BDT in Crore)",{"$f":"'Credit Input'!E43","v":0}]
["Value of Eligible Security Against STD (BDT in Crore)",{"$f":"'Credit Input'!F43","v":0}]
["Total SMA Loan with ES (BDT in Crore)",{"$f":"'Credit Input'!G43","v":0}]
["Total SMA Loan without ES (BDT in Crore)",{"$f":"'Credit Input'!H43","v":0}]
["Value of Eligible Security Against SMA (BDT in Crore)",{"$f":"'Credit Input'!I43","v":0}]
["Current Provisions (BDT in Crore)",{"$f":"(('Credit Input'!D43+'Credit Input'!E43)*'Credit Input'!C61+('Credit Input'!G43+'Credit Input'!H43)*'Credit Input'!D61+('Credit Input'!J43+'Credit Input'!K43-'Credit Input'!L43)*'Credit Input'!E61+('Credit Input'!M43+'Credit Input'!N43-'Credit Input'!O43)*'Credit Input'!F61+('Credit Input'!P43+'Credit Input'!Q43-'Credit Input'!R43)*'Credit Input'!G61)","v":0}]
["Provision Surplus/Shortfall",{"$f":"'Credit Input'!C11","v":0}]
["NPL to Loans",{"$f":"IF(B10<>0,B11/B10,0)","v":0}]
[]
["Result"]
["Magnitude of Shock",{"$f":"'Credit Input'!C56","v":0.02},{"$f":"'Credit Input'!D56","v":0.05},{"$f":"'Credit Input'!E56","v":0.1}]
["Increase in NPL (BDT in Crore)",{"$f":"($B$12+$B$13+$B$15+$B$16)*B23","v":0},{"$f":"($B$12+$B$13+$B$15+$B$16)*C23","v":0},{"$f":"($B$12+$B$13+$B$15+$B$16)*D23","v":0}]
["Revised NPL (BDT in Crore)",{"$f":"$B$11+B24","v":0},{"$f":"$B$11+C24","v":0},{"$f":"$B$11+D24","v":0}]
["Revised NPL to Loans Ratio",{"$f":"IF($B$10<>0,B25/$B$10,0)","v":0},{"$f":"IF($B$10<>0,C25/$B$10,0)","v":0},{"$f":"IF($B$10<>0,D25/$B$10,0)","v":0}]
["Extra Provisions for Loans without ES (BDT in Crore)",{"$f":"($B$13+$B$16)*B23-($B$13*'Credit Input'!$C$61+$B$16*'Credit Input'!$D$61)*B23","v":0},{"$f":"($B$13+$B$16)*C23-($B$13*'Credit Input'!$C$61+$B$16*'Credit Input'!$D$61)*C23","v":0},{"$f":"($B$13+$B$16)*D23-($B$13*'Credit Input'!$C$61+$B$16*'Credit Input'!$D$61)*D23","v":0}]
["Extra Provisions for Loans with ES (BDT in Crore)",{"$f":"($B$12+$B$15-$B$14-$B$17)*B23-($B$12*'Credit Input'!$C$61+$B$15*'Credit Input'!$D$61)*B23","v":0},{"$f":"($B$12+$B$15-$B$14-$B$17)*C23-($B$12*'Credit Input'!$C$61+$B$15*'Credit Input'!$D$61)*C23","v":0},{"$f":"($B$12+$B$15-$B$14-$B$17)*D23-($B$12*'Credit Input'!$C$61+$B$15*'Credit Input'!$D$61)*D23","v":0}]
["Increase in Provisions (BDT in Crore)",{"$f":"IF((B27+B28)>=$B$19,B27+B28-$B$19,0)","v":0},{"$f":"IF((C27+C28)>=$B$19,C27+C28-$B$19,0)","v":0},{"$f":"IF((D27+D28)>=$B$19,D27+D28-$B$19,0)","v":0}]
["Revised Capital (BDT in Crore)",{"$f":"$B$5-B29","v":0},{"$f":"$B$5-C29","v":0},{"$f":"$B$5-D29","v":0}]
["Revised Risk Weighted Assets (BDT in Crore)",{"$f":"$B$6-B29","v":0},{"$f":"$B$6-C29","v":0},{"$f":"$B$6-D29","v":0}]
["Revised CAR",{"$f":"IF(B31<>0,B30/B31,0)","v":0},{"$f":"IF(C31<>0,C30/C31,0)","v":0},{"$f":"IF(D31<>0,D30/D31,0)","v":0}]

{"sheet":"Interest Rate Input","index":13,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[[4,0,5,0],[4,1,4,9]]}
["Name of the Institution :",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date:",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[]
[null,null,null,null,null,null,null,null,null,"(Amount in crore)"]
["Particulars","Projected Figure"]
[null,"1 to 30/31 day (One month)","Over 1 month to 2 months","Over 2 months to 3 months","Over 3 months to 6 months","Over 6 months to 1 year","Over 1 year to 3 years","Over 3 years to 5 years","Over 5 years","Total"]
[1,2,3,4,5,6,7,8,9,10]
["A. Rate SENSITIVE LIABILITIES"]
["1. Notes, bonds & debentures",{"$f":"SUM(B10:B11)","v":0},{"$f":"SUM(C10:C11)","v":0},0,0,0,0,0,0,0]
["(a) Plain vanilla bonds/debentures",{"$f":"'Liquidity Input'!B14","v":0},{"$f":"'Liquidity Input'!C14","v":0},{"$f":"'Liquidity Input'!D14","v":0},{"$f":"'Liquidity Input'!E14","v":0},{"$f":"'Liquidity Input'!F14","v":0},{"$f":"'Liquidity Input'!G14","v":0},{"$f":"'Liquidity Input'!H14","v":0},{"$f":"'Liquidity Input'!I14","v":0},{"$f":"SUM(B10:I10)","v":0}]
["(b) Bonds/debentures with embedded options",{"$f":"'Liquidity Input'!B15","v":0},{"$f":"'Liquidity Input'!C15","v":0},{"$f":"'Liquidity Input'!D15","v":0},{"$f":"'Liquidity Input'!E15","v":0},{"$f":"'Liquidity Input'!F15","v":0},{"$f":"'Liquidity Input'!G15","v":0},{"$f":"'Liquidity Input'!H15","v":0},{"$f":"'Liquidity Input'!I15","v":0},{"$f":"SUM(B11:I11)","v":0}]
["2. Deposits",{"$f":"SUM(B13:B14)","v":0},{"$f":"SUM(C13:C14)","v":0},0,0,0,0,0,0,0]
["(a) Term deposits from public",{"$f":"'Liquidity Input'!B17","v":0},{"$f":"'Liquidity Input'!C17","v":0},{"$f":"'Liquidity Input'!D17","v":0},{"$f":"'Liquidity Input'!E17","v":0},{"$f":"'Liquidity Input'!F17","v":0},{"$f":"'Liquidity Input'!G17","v":0},{"$f":"'Liquidity Input'!H17","v":0},{"$f":"'Liquidity Input'!I17","v":0},{"$f":"SUM(B13:I13)","v":0}]
["(b) Term deposits from Banks/Fls",{"$f":"'Liquidity Input'!B18","v":0},{"$f":"'Liquidity Input'!C18","v":0},{"$f":"'Liquidity Input'!D18","v":0},{"$f":"'Liquidity Input'!E18","v":0},{"$f":"'Liquidity Input'!F18","v":0},{"$f":"'Liquidity Input'!G18","v":0},{"$f":"'Liquidity Input'!H18","v":0},{"$f":"'Liquidity Input'!I18","v":0},{"$f":"SUM(B14:I14)","v":0}]
["3. Bank borrowings",{"$f":"SUM(B16:B17)","v":0},{"$f":"SUM(C16:C17)","v":0},0,0,0,0,0,0,0]
["(a) SOD",{"$f":"'Liquidity Input'!B20","v":0},{"$f":"'Liquidity Input'!C20","v":0},{"$f":"'Liquidity Input'!D20","v":0},{"$f":"'Liquidity Input'!E20","v":0},{"$f":"'Liquidity Input'!F20","v":0},{"$f":"'Liquidity Input'!G20","v":0},{"$f":"'Liquidity Input'!H20","v":0},{"$f":"'Liquidity Input'!I20","v":0},{"$f":"SUM(B16:I16)","v":0}]
["(b) Long term loans",{"$f":"'Liquidity Input'!B21","v":0},{"$f":"'Liquidity Input'!C21","v":0},{"$f":"'Liquidity Input'!D21","v":0},{"$f":"'Liquidity Input'!E21","v":0},{"$f":"'Liquidity Input'!F21","v":0},{"$f":"'Liquidity Input'!G21","v":0},{"$f":"'Liquidity Input'!H21","v":0},{"$f":"'Liquidity Input'!I21","v":0},{"$f":"SUM(B17:I17)","v":0}]
["A. TOTAL RATE SENSITIVE LIABILITIES (A)",{"$f":"SUM(B9,B12,B15)","v":0},{"$f":"SUM(C9,C12,C15)","v":0},0,0,0,0,0,0,0]
["B. RATE SENSITIVE ASSETS"]
["1. Balances with banks (Except Current A/C)",{"$f":"SUM(B21:B22)","v":0},{"$f":"SUM(C21:C22)","v":0},0,0,0,0,0,0,0]
["(a) Deposit/Short-term deposits",{"$f":"'Liquidity Input'!B39","v":0},{"$f":"'Liquidity Input'!C39","v":0},{"$f":"'Liquidity Input'!D39","v":0},{"$f":"'Liquidity Input'!E39","v":0},{"$f":"'Liquidity Input'!F39","v":0},{"$f":"'Liquidity Input'!G39","v":0},{"$f":"'Liquidity Input'!H39","v":0},{"$f":"'Liquidity Input'!I39","v":0},{"$f":"SUM(B21:I21)","v":0}]
["(b) Money at call & short notice",{"$f":"'Liquidity Input'!B40","v":0},{"$f":"'Liquidity Input'!C40","v":0},{"$f":"'Liquidity Input'!D40","v":0},{"$f":"'Liquidity Input'!E40","v":0},{"$f":"'Liquidity Input'!F40","v":0},{"$f":"'Liquidity Input'!G40","v":0},{"$f":"'Liquidity Input'!H40","v":0},{"$f":"'Liquidity Input'!I40","v":0},{"$f":"SUM(B22:I22)","v":0}]
["2. Investments",{"$f":"B24","v":0},{"$f":"C24","v":0},0,0,0,0,0,0,0]
["(a) Investments in Bonds & Securities",{"$f":"'Liquidity Input'!B42","v":0},{"$f":"'Liquidity Input'!C42","v":0},{"$f":"'Liquidity Input'!D42","v":0},{"$f":"'Liquidity Input'!E42","v":0},{"$f":"'Liquidity Input'!F42","v":0},{"$f":"'Liquidity Input'!G42","v":0},{"$f":"'Liquidity Input'!H42","v":0},{"$f":"'Liquidity Input'!I42","v":0},{"$f":"SUM(B24:I24)","v":0}]
["3. lease Finance & Loans (performing)",{"$f":"SUM(B26:B29)","v":0},{"$f":"SUM(C26:C29)","v":0},0,0,0,0,0,0,0]
["(a) Lease finance",{"$f":"'Liquidity Input'!B45","v":0},{"$f":"'Liquidity Input'!C45","v":0},{"$f":"'Liquidity Input'!D45","v":0},{"$f":"'Liquidity Input'!E45","v":0},{"$f":"'Liquidity Input'!F45","v":0},{"$f":"'Liquidity Input'!G45","v":0},{"$f":"'Liquidity Input'!H45","v":0},{"$f":"'Liquidity Input'!I45","v":0},{"$f":"SUM(B26:I26)","v":0}]
["(b) Home Loan",{"$f":"'Liquidity Input'!B46","v":0},{"$f":"'Liquidity Input'!C46","v":0},{"$f":"'Liquidity Input'!D46","v":0},{"$f":"'Liquidity Input'!E46","v":0},{"$f":"'Liquidity Input'!F46","v":0},{"$f":"'Liquidity Input'!G46","v":0},{"$f":"'Liquidity Input'!H46","v":0},{"$f":"'Liquidity Input'!I46","v":0},{"$f":"SUM(B27:I27)","v":0}]
["(c) Term loan",{"$f":"'Liquidity Input'!B47","v":0},{"$f":"'Liquidity Input'!C47","v":0},{"$f":"'Liquidity Input'!D47","v":0},{"$f":"'Liquidity Input'!E47","v":0},{"$f":"'Liquidity Input'!F47","v":0},{"$f":"'Liquidity Input'!G47","v":0},{"$f":"'Liquidity Input'!H47","v":0},{"$f":"'Liquidity Input'!I47","v":0},{"$f":"SUM(B28:I28)","v":0}]
["(d) Corporate loans/short term loans ",{"$f":"'Liquidity Input'!B48","v":0},{"$f":"'Liquidity Input'!C48","v":0},{"$f":"'Liquidity Input'!D48","v":0},{"$f":"'Liquidity Input'!E48","v":0},{"$f":"'Liquidity Input'!F48","v":0},{"$f":"'Liquidity Input'!G48","v":0},{"$f":"'Liquidity Input'!H48","v":0},{"$f":"'Liquidity Input'!I48","v":0},{"$f":"SUM(B29:I29)","v":0}]
["B. TOTAL RATE SENSITIVE ASSETS (B)",{"$f":"SUM(B20,B23,B25)","v":0},{"$f":"SUM(C20,C23,C25)","v":0},0,0,0,0,0,0,0]
["C. MISMATCH (B-A)",{"$f":"B30-B18","v":0},{"$f":"C30-C18","v":0},0,0,0,0,0,0,0]
["D. CUMULATIVE MISMATCH",{"$f":"B31","v":0},{"$f":"B32+C31","v":0},{"$f":"C32+D31","v":0},0,0,0,0,0]
["E. C AS PERCENTAGE OF A",{"$f":"IF(B18<>0,B31/B18,0)","v":0},{"$f":"IF(C18<>0,C31/C18,0)","v":0},0,0,0,0,0,0,0]
[]
["First Line of Defense (BDT Crore)",100]
["Second Line of Defense (BDT Crore)",50]
[]
[]
[]
["SHOCKS","Minor","Moderate","Major"]
[null,0.03,0.05,0.06]

{"sheet":"Liquidity Input","index":14,"n_rows":110,"n_cols":15,"rows_kept":110,"cut":false,"hidden":false,"merged":[[4,0,5,0],[4,1,4,9]]}
[]
["Name of the FI",":",{"$f":"IF('Credit Input'!C1=\"\",\"\",'Credit Input'!C1)","v":""}]
["Reporting Base Date",":",{"$f":"'Credit Input'!C3","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"(Amount in crore)"]
["Particulars"]
[null,"1 to 30/31 day (One month)","Over 1 month to 2 months","Over 2 months to 3 months","Over 3 months to 6 months","Over 6 months to 1 year","Over 1 year to 3 years","Over 3 years to 5 years","Over 5 years","Total"]
[1,2,3,4,5,6,7,8,9,10]
["A. Outflows "]
["1. Capital",{"$f":"SUM(B10:B11)","v":0},{"$f":"SUM(C10:C11)","v":0},0,0,0,0,0,0,{"$f":"SUM(B9:I9)","v":0}]
["(a) Equity and perpetual preference shares",null,null,null,null,null,null,null,null,{"$f":"SUM(B10:I10)","v":0}]
["(b) Non-perpetual preference shares",null,null,null,null,null,null,null,null,{"$f":"SUM(B11:I11)","v":0}]
["2. Reserves and surplus",null,null,null,null,null,null,null,null,{"$f":"SUM(B12:I12)","v":0}]
["3. Notes, bonds & debentures",{"$f":"SUM(B14:B15)","v":0},{"$f":"SUM(C14:C15)","v":0},0,0,0,0,0,0,{"$f":"SUM(B13:I13)","v":0}]
["(a) Plain vanilla bonds/debentures",null,null,null,null,null,null,null,null,{"$f":"SUM(B14:I14)","v":0}]
["(b) Bonds/debentures with embedded options",null,null,null,null,null,null,null,null,0]
["4. Deposits",{"$f":"SUM(B17:B18)","v":0},{"$f":"SUM(C17:C18)","v":0},0,0,0,0,0,0,0]
["(a) Term deposits from public",null,null,null,null,null,null,null,null,0]
["(b) Term deposits from Banks/Fls",null,null,null,null,null,null,null,null,0]
["5. Bank borrowings",{"$f":"SUM(B20:B21)","v":0},{"$f":"SUM(C20:C21)","v":0},0,0,0,0,0,0,0]
["(a) SOD",null,null,null,null,null,null,null,null,0]
["(b) Long term loans",null,null,null,null,null,null,null,null,0]
["6. Current liabilities and provisions",{"$f":"SUM(B23:B27)","v":0},{"$f":"SUM(C23:C27)","v":0},0,0,0,0,0,0,0]
["(a) Short term loans",null,null,null,null,null,null,null,null,0]
["(b) Accounts payable",null,null,null,null,null,null,null,null,0]
["(c) Advance income received",null,null,null,null,null,null,null,null,0]
["(d) Interest payable on bonds/deposits",null,null,null,null,null,null,null,null,0]
["(e) Provisions ",null,null,null,null,null,null,null,null,0]
["7. Contingent Liabilities",{"$f":"SUM(B29:B31)","v":0},{"$f":"SUM(C29:C31)","v":0},0,0,0,0,0,0,0]
["(a) Letters of credit/guarantees",null,null,null,null,null,null,null,null,0]
["(b) Loan commitments, pending disbursal",null,null,null,null,null,null,null,null,0]
["(c) Lines of credit committed to other institutions",null,null,null,null,null,null,null,null,0]
["8. Others",null,null,null,null,null,null,null,null,0]
["A. TOTAL OUTFLOWS (A)",{"$f":"SUM(B9,B12,B13,B16,B19,B22,B28,B32)","v":0},{"$f":"SUM(C9,C12,C13,C16,C19,C22,C28,C32)","v":0},0,0,0,0,0,0,0]
["B. INFLOWS",null,null,null,null,null,null,null,null,0]
["1. Cash",null,null,null,null,null,null,null,null,0]
["2. Remittance in transit",null,null,null,null,null,null,null,null,0]
["3. Balances with banks",{"$f":"SUM(B38:B40)","v":0},{"$f":"SUM(C38:C40)","v":0},0,0,0,0,0,0,0]
["(a) Current account",null,null,null,null,null,null,null,null,0]
["(b) Deposit/Short-term deposits",null,null,null,null,null,null,null,null,0]
["(c) Money at call & short notice",null,null,null,null,null,null,null,null,0]
["4. Investments",{"$f":"SUM(B42:B43)","v":0},{"$f":"SUM(C42:C43)","v":0},0,0,0,0,0,0,0]
["(a) Investments in Bonds & Securities",null,null,null,null,null,null,null,null,0]
["(a) Investments in Shares",null,null,null,null,null,null,null,null,0]
["5. lease Finance & Loans (performing)",{"$f":"SUM(B45:B48)","v":0},{"$f":"SUM(C45:C48)","v":0},0,0,0,0,0,0,0]
["(a) Lease finance",null,null,null,null,null,null,null,null,0]
["(b) Home Loan",null,null,null,null,null,null,null,null,0]
["(c) Term loan",null,null,null,null,null,null,null,null,0]
["(d) Corporate loans/short term loans ",null,null,null,null,null,null,null,null,0]
["6. Non-performing loans",null,null,null,null,null,null,null,null,0]
["7. Fixed assets (excluding assets on lease)",null,null,null,null,null,null,null,null,0]
["8. Other Assets:",{"$f":"SUM(B52:B54)","v":0},{"$f":"SUM(C52:C54)","v":0},0,0,0,0,0,0,0]
["(a) Intangible assets & other non-cash flow items",null,null,null,null,null,null,null,null,0]
["(b) Interest and other Income receivable",null,null,null,null,null,null,null,null,0]
["(c) Others ",null,null,null,null,null,null,null,null,0]
["9. Others",null,null,null,null,null,null,null,null,0]
["B. TOTAL INFLOWS (B)",{"$f":"SUM(B35,B36,B37,B41,B44,B49,B50,B51,B55)","v":0},{"$f":"SUM(C35,C36,C37,C41,C44,C49,C50,C51,C55)","v":0},0,0,0,0,0,0,{"$f":"SUM(B56:I56)","v":0}]
["C. MISMATCH (B-A)",{"$f":"B56-B33","v":0},{"$f":"C56-C33","v":0},0,0,0,0,0,0,0]
["D. CUMULATIVE MISMATCH",{"$f":"B57","v":0},{"$f":"B58+C57","v":0},{"$f":"C58+D57","v":0},0,0,0,0,0]
["E. C AS PERCENTAGE OF A",{"$f":"IF(B33<>0,B57/B33,0)","v":0},{"$f":"IF(C33<>0,C57/C33,0)","v":0},0,0,0,0,0,0,0]
[]
["Structure of the Bond Portfolio","Face Value","Present Value","Settlement","Maturity","Coupon","Yield","Frequency","Duration","Remarks"]
[null,null,{"$f":"IF(OR(J62=\"\",B62=\"\"),\"\",IF(J62=\"Asset\",B62/100*PRICE(D62,E62,F62,G62,100,H62,1),-B62/100*PRICE(D62,E62,F62,G62,100,H62,1)))","v":""},{"$f":"IF(B62=\"\",\"\",$C$3)","v":""},null,null,null,null,{"$f":"IF(OR(D62=\"\",E62=\"\",F62=\"\",G62=\"\",H62=\"\"),\"\",DURATION(D62,E62,F62,G62,H62,1))","v":""},null,null,null,null,null,"Asset"]
[null,null,"","",null,null,null,null,"",null,null,null,null,null,"Liability"]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,"",null,null,null,null,{"$f":"IF(L99=\"Asset\",1,0)","v":0},"Liability"]
[null,null,"","",null,null,null,null,""]
[null,null,"","",null,null,null,null,""]
["Total/Average",{"$f":"SUM(B62:B101)","v":0},{"$f":"SUM(C62:C101)","v":0},null,null,null,null,null,{"$f":"IF(C102=\"\",\"\",IF(C102<>0,SUMPRODUCT(C62:C101,I62:I101)/$C$102,0))","v":0}]
[]
["First Line of Defense (BDT Crore)",null,"SOD"]
["Second Line of Defense (BDT Crore)",null,"short-term loan, commercial paper, bill discounting facility"]
[]
[]
[]
["SHOCKS","Minor","Moderate","Major"]
[null,0.05,7.0000000000000007E-2,0.1]

{"sheet":"Credit Input","index":15,"n_rows":61,"n_cols":48,"rows_kept":61,"cut":false,"hidden":false,"merged":[[53,8,53,10],[53,11,53,13],[53,14,53,16],[14,43,14,45],[53,17,53,19],[14,31,14,33],[14,34,14,36],[14,37,14,39],[14,40,14,42],[13,2,13,17],[14,15,14,17],[14,12,14,14],[14,9,14,11],[14,6,14,8],[14,3,14,5],[0,0,0,1],[2,0,2,1],[1,0,1,1],[59,0,60,1],[45,2,45,12],[14,2,15,2],[45,0,46,0],[45,1,46,1],[53,0,55,1],[53,2,53,4],[53,5,53,7],[5,0,6,0],[5,1,6,1],[5,2,6,2],[13,0,15,0],[13,1,15,1]]}
["Name of the Institution:"]
["Acronym of the name:"]
["Reporting Base Date:"]
[]
["Table: 1 ","Basic Information"]
["Sl. No","Particulars","Amount in \nBDT Crore "]
[]
[1,"Regulatory Capital"]
[2,"Risk Weighted Assets"]
[3,"CAR %",{"$f":"IF(C9<>0,C8/C9,0)","v":0}]
[4,"Provision Surplus/Shortfall*"]
[null,"*Which is not adjusted in Regulatory Capital"]
["Table: 2","Sector Wise Credit Portfolio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(22,$AB$17:$AE$38,4,FALSE)","v":0}]
["Sl. No","Particulars","Amount in BDT Crore "]
[null,null,"Total","STD",null,null,"SMA",null,null,"SS",null,null,"DF",null,null,"BL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STD",null,null,"SMA",null,null,"SS",null,null,"DF",null,null,"BL"]
[null,null,null,"Loans with ES","Loans without ES","Value of Eligible Security","Loans with ES","Loans without ES","Value of Eligible Security","Loans with ES","Loans without ES","Value of Eligible Security","Loans with ES","Loans without ES","Value of Eligible Security","Loans with ES","Loans without ES","Value of Eligible Security",null,null,null,null,null,null,null,null,null,"Place","Sector","R","Total","LES","L","ES","LES","L","ES","LES","L","ES","LES","L","ES","LES","L","ES","PL","NPL"]
[1,"Trade and Commerce",{"$f":"SUM(D17:E17,G17:H17,J17:K17,M17:N17,P17:Q17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Provision",{"$f":"IF(AD17>AD17,1,0)+IF(AD17>AD18,1,0)+IF(AD17>AD19,1,0)+IF(AD17>AD20,1,0)+IF(AD17>AD21,1,0)+IF(AD17>AD22,1,0)+IF(AD17>AD23,1,0)+IF(AD17>AD24,1,0)+IF(AD17>AD25,1,0)+IF(AD17>AD26,1,0)+IF(AD17>AD27,1,0)+IF(AD17>AD28,1,0)+IF(AD17>AD29,1,0)+IF(AD17>AD30,1,0)+IF(AD17>AD31,1,0)+IF(AD17>AD32,1,0)+IF(AD17>AD33,1,0)+IF(AD17>AD34,1,0)+IF(AD17>AD35,1,0)+IF(AD17>AD36,1,0)+IF(AD17>AD37,1,0)+IF(AD17>AD38,1,0)+1","v":22},"Trade and Commerce",{"$f":"C17+0.22","v":0.22},{"$f":"C17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,4,FALSE),((VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,9,FALSE)+VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,11,FALSE)+VLOOKUP(22,'Credit Input'!$AB$17:$AT$38,13,FALSE))),0)","v":0}]
[2,"Industry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D43*C61+G43*D61+(J43-L43)*E61+(M43-O43)*F61+(P43-R43))","v":0},{"$f":"IF(AD18>AD17,1,0)+IF(AD18>AD18,1,0)+IF(AD18>AD19,1,0)+IF(AD18>AD20,1,0)+IF(AD18>AD21,1,0)+IF(AD18>AD22,1,0)+IF(AD18>AD23,1,0)+IF(AD18>AD24,1,0)+IF(AD18>AD25,1,0)+IF(AD18>AD26,1,0)+IF(AD18>AD27,1,0)+IF(AD18>AD28,1,0)+IF(AD18>AD29,1,0)+IF(AD18>AD30,1,0)+IF(AD18>AD31,1,0)+IF(AD18>AD32,1,0)+IF(AD18>AD33,1,0)+IF(AD18>AD34,1,0)+IF(AD18>AD35,1,0)+IF(AD18>AD36,1,0)+IF(AD18>AD37,1,0)+IF(AD18>AD38,1,0)+1","v":21},"Garments and Knitwear",{"$f":"C19+0.21","v":0.21},{"$f":"C19","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"A) Garments and Knitwear",{"$f":"SUM(D19:E19,G19:H19,J19:K19,M19:N19,P19:Q19)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD19>AD17,1,0)+IF(AD19>AD18,1,0)+IF(AD19>AD19,1,0)+IF(AD19>AD20,1,0)+IF(AD19>AD21,1,0)+IF(AD19>AD22,1,0)+IF(AD19>AD23,1,0)+IF(AD19>AD24,1,0)+IF(AD19>AD25,1,0)+IF(AD19>AD26,1,0)+IF(AD19>AD27,1,0)+IF(AD19>AD28,1,0)+IF(AD19>AD29,1,0)+IF(AD19>AD30,1,0)+IF(AD19>AD31,1,0)+IF(AD19>AD32,1,0)+IF(AD19>AD33,1,0)+IF(AD19>AD34,1,0)+IF(AD19>AD35,1,0)+IF(AD19>AD36,1,0)+IF(AD19>AD37,1,0)+IF(AD19>AD38,1,0)+1","v":20},"Textile",{"$f":"C20+0.2","v":0.2},{"$f":"C20","v":0},{"$f":"D20","v":0},{"$f":"E20","v":0},{"$f":"F20","v":0},{"$f":"G20","v":0},{"$f":"H20","v":0},{"$f":"I20","v":0},{"$f":"J20","v":0},{"$f":"K20","v":0},{"$f":"L20","v":0},{"$f":"M20","v":0},{"$f":"N20","v":0},{"$f":"O20","v":0},{"$f":"P20","v":0},{"$f":"Q20","v":0},{"$f":"R20","v":0}]
[null,"B) Textile",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD20>AD17,1,0)+IF(AD20>AD18,1,0)+IF(AD20>AD19,1,0)+IF(AD20>AD20,1,0)+IF(AD20>AD21,1,0)+IF(AD20>AD22,1,0)+IF(AD20>AD23,1,0)+IF(AD20>AD24,1,0)+IF(AD20>AD25,1,0)+IF(AD20>AD26,1,0)+IF(AD20>AD27,1,0)+IF(AD20>AD28,1,0)+IF(AD20>AD29,1,0)+IF(AD20>AD30,1,0)+IF(AD20>AD31,1,0)+IF(AD20>AD32,1,0)+IF(AD20>AD33,1,0)+IF(AD20>AD34,1,0)+IF(AD20>AD35,1,0)+IF(AD20>AD36,1,0)+IF(AD20>AD37,1,0)+IF(AD20>AD38,1,0)+1","v":19},"Jute and Jute-Products",{"$f":"C21+0.19","v":0.19},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"C) Jute and Jute-Products",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD21>AD17,1,0)+IF(AD21>AD18,1,0)+IF(AD21>AD19,1,0)+IF(AD21>AD20,1,0)+IF(AD21>AD21,1,0)+IF(AD21>AD22,1,0)+IF(AD21>AD23,1,0)+IF(AD21>AD24,1,0)+IF(AD21>AD25,1,0)+IF(AD21>AD26,1,0)+IF(AD21>AD27,1,0)+IF(AD21>AD28,1,0)+IF(AD21>AD29,1,0)+IF(AD21>AD30,1,0)+IF(AD21>AD31,1,0)+IF(AD21>AD32,1,0)+IF(AD21>AD33,1,0)+IF(AD21>AD34,1,0)+IF(AD21>AD35,1,0)+IF(AD21>AD36,1,0)+IF(AD21>AD37,1,0)+IF(AD21>AD38,1,0)+1","v":18},"Food Production and Processing Ind.",{"$f":"C22+0.18","v":0.18},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"D) Food Production and Processing Ind.",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD22>AD17,1,0)+IF(AD22>AD18,1,0)+IF(AD22>AD19,1,0)+IF(AD22>AD20,1,0)+IF(AD22>AD21,1,0)+IF(AD22>AD22,1,0)+IF(AD22>AD23,1,0)+IF(AD22>AD24,1,0)+IF(AD22>AD25,1,0)+IF(AD22>AD26,1,0)+IF(AD22>AD27,1,0)+IF(AD22>AD28,1,0)+IF(AD22>AD29,1,0)+IF(AD22>AD30,1,0)+IF(AD22>AD31,1,0)+IF(AD22>AD32,1,0)+IF(AD22>AD33,1,0)+IF(AD22>AD34,1,0)+IF(AD22>AD35,1,0)+IF(AD22>AD36,1,0)+IF(AD22>AD37,1,0)+IF(AD22>AD38,1,0)+1","v":17},"Plastic Industry",{"$f":"C23+0.17","v":0.17},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"E) Plastic Industry",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD23>AD17,1,0)+IF(AD23>AD18,1,0)+IF(AD23>AD19,1,0)+IF(AD23>AD20,1,0)+IF(AD23>AD21,1,0)+IF(AD23>AD22,1,0)+IF(AD23>AD23,1,0)+IF(AD23>AD24,1,0)+IF(AD23>AD25,1,0)+IF(AD23>AD26,1,0)+IF(AD23>AD27,1,0)+IF(AD23>AD28,1,0)+IF(AD23>AD29,1,0)+IF(AD23>AD30,1,0)+IF(AD23>AD31,1,0)+IF(AD23>AD32,1,0)+IF(AD23>AD33,1,0)+IF(AD23>AD34,1,0)+IF(AD23>AD35,1,0)+IF(AD23>AD36,1,0)+IF(AD23>AD37,1,0)+IF(AD23>AD38,1,0)+1","v":16},"Leather and Leather-Goods",{"$f":"C24+0.16","v":0.16},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"F) Leather and Leather-Goods",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD24>AD17,1,0)+IF(AD24>AD18,1,0)+IF(AD24>AD19,1,0)+IF(AD24>AD20,1,0)+IF(AD24>AD21,1,0)+IF(AD24>AD22,1,0)+IF(AD24>AD23,1,0)+IF(AD24>AD24,1,0)+IF(AD24>AD25,1,0)+IF(AD24>AD26,1,0)+IF(AD24>AD27,1,0)+IF(AD24>AD28,1,0)+IF(AD24>AD29,1,0)+IF(AD24>AD30,1,0)+IF(AD24>AD31,1,0)+IF(AD24>AD32,1,0)+IF(AD24>AD33,1,0)+IF(AD24>AD34,1,0)+IF(AD24>AD35,1,0)+IF(AD24>AD36,1,0)+IF(AD24>AD37,1,0)+IF(AD24>AD38,1,0)+1","v":15},"Iron, Steel and Engineering",{"$f":"C25+0.15","v":0.15},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"G) Iron, Steel and Engineering",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD25>AD17,1,0)+IF(AD25>AD18,1,0)+IF(AD25>AD19,1,0)+IF(AD25>AD20,1,0)+IF(AD25>AD21,1,0)+IF(AD25>AD22,1,0)+IF(AD25>AD23,1,0)+IF(AD25>AD24,1,0)+IF(AD25>AD25,1,0)+IF(AD25>AD26,1,0)+IF(AD25>AD27,1,0)+IF(AD25>AD28,1,0)+IF(AD25>AD29,1,0)+IF(AD25>AD30,1,0)+IF(AD25>AD31,1,0)+IF(AD25>AD32,1,0)+IF(AD25>AD33,1,0)+IF(AD25>AD34,1,0)+IF(AD25>AD35,1,0)+IF(AD25>AD36,1,0)+IF(AD25>AD37,1,0)+IF(AD25>AD38,1,0)+1","v":14},"Pharmaceuticals and Chemicals",{"$f":"C26+0.14","v":0.14000000000000001},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"H) Pharmaceuticals and Chemicals",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD26>AD17,1,0)+IF(AD26>AD18,1,0)+IF(AD26>AD19,1,0)+IF(AD26>AD20,1,0)+IF(AD26>AD21,1,0)+IF(AD26>AD22,1,0)+IF(AD26>AD23,1,0)+IF(AD26>AD24,1,0)+IF(AD26>AD25,1,0)+IF(AD26>AD26,1,0)+IF(AD26>AD27,1,0)+IF(AD26>AD28,1,0)+IF(AD26>AD29,1,0)+IF(AD26>AD30,1,0)+IF(AD26>AD31,1,0)+IF(AD26>AD32,1,0)+IF(AD26>AD33,1,0)+IF(AD26>AD34,1,0)+IF(AD26>AD35,1,0)+IF(AD26>AD36,1,0)+IF(AD26>AD37,1,0)+IF(AD26>AD38,1,0)+1","v":13},"Cement and Allied Industry",{"$f":"C27+0.13","v":0.13},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"I) Cement and Allied Industry",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD27>AD17,1,0)+IF(AD27>AD18,1,0)+IF(AD27>AD19,1,0)+IF(AD27>AD20,1,0)+IF(AD27>AD21,1,0)+IF(AD27>AD22,1,0)+IF(AD27>AD23,1,0)+IF(AD27>AD24,1,0)+IF(AD27>AD25,1,0)+IF(AD27>AD26,1,0)+IF(AD27>AD27,1,0)+IF(AD27>AD28,1,0)+IF(AD27>AD29,1,0)+IF(AD27>AD30,1,0)+IF(AD27>AD31,1,0)+IF(AD27>AD32,1,0)+IF(AD27>AD33,1,0)+IF(AD27>AD34,1,0)+IF(AD27>AD35,1,0)+IF(AD27>AD36,1,0)+IF(AD27>AD37,1,0)+IF(AD27>AD38,1,0)+1","v":12},"Telecommunication and IT",{"$f":"C28+0.12","v":0.12},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"J) Telecommunication and IT",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD28>AD17,1,0)+IF(AD28>AD18,1,0)+IF(AD28>AD19,1,0)+IF(AD28>AD20,1,0)+IF(AD28>AD21,1,0)+IF(AD28>AD22,1,0)+IF(AD28>AD23,1,0)+IF(AD28>AD24,1,0)+IF(AD28>AD25,1,0)+IF(AD28>AD26,1,0)+IF(AD28>AD27,1,0)+IF(AD28>AD28,1,0)+IF(AD28>AD29,1,0)+IF(AD28>AD30,1,0)+IF(AD28>AD31,1,0)+IF(AD28>AD32,1,0)+IF(AD28>AD33,1,0)+IF(AD28>AD34,1,0)+IF(AD28>AD35,1,0)+IF(AD28>AD36,1,0)+IF(AD28>AD37,1,0)+IF(AD28>AD38,1,0)+1","v":11},"Paper, Printing and Packaging",{"$f":"C29+0.11","v":0.11},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"k) Paper, Printing and Packaging",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD29>AD17,1,0)+IF(AD29>AD18,1,0)+IF(AD29>AD19,1,0)+IF(AD29>AD20,1,0)+IF(AD29>AD21,1,0)+IF(AD29>AD22,1,0)+IF(AD29>AD23,1,0)+IF(AD29>AD24,1,0)+IF(AD29>AD25,1,0)+IF(AD29>AD26,1,0)+IF(AD29>AD27,1,0)+IF(AD29>AD28,1,0)+IF(AD29>AD29,1,0)+IF(AD29>AD30,1,0)+IF(AD29>AD31,1,0)+IF(AD29>AD32,1,0)+IF(AD29>AD33,1,0)+IF(AD29>AD34,1,0)+IF(AD29>AD35,1,0)+IF(AD29>AD36,1,0)+IF(AD29>AD37,1,0)+IF(AD29>AD38,1,0)+1","v":10},"Glass, Glassware and Ceramic Ind",{"$f":"C30+0.1","v":0.1},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"L) Glass, Glassware and Ceramic Ind",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD30>AD17,1,0)+IF(AD30>AD18,1,0)+IF(AD30>AD19,1,0)+IF(AD30>AD20,1,0)+IF(AD30>AD21,1,0)+IF(AD30>AD22,1,0)+IF(AD30>AD23,1,0)+IF(AD30>AD24,1,0)+IF(AD30>AD25,1,0)+IF(AD30>AD26,1,0)+IF(AD30>AD27,1,0)+IF(AD30>AD28,1,0)+IF(AD30>AD29,1,0)+IF(AD30>AD30,1,0)+IF(AD30>AD31,1,0)+IF(AD30>AD32,1,0)+IF(AD30>AD33,1,0)+IF(AD30>AD34,1,0)+IF(AD30>AD35,1,0)+IF(AD30>AD36,1,0)+IF(AD30>AD37,1,0)+IF(AD30>AD38,1,0)+1","v":9},"Ship Manufacturing Industry",{"$f":"C31+0.09","v":0.09},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"M) Ship Manufacturing Industry",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD31>AD17,1,0)+IF(AD31>AD18,1,0)+IF(AD31>AD19,1,0)+IF(AD31>AD20,1,0)+IF(AD31>AD21,1,0)+IF(AD31>AD22,1,0)+IF(AD31>AD23,1,0)+IF(AD31>AD24,1,0)+IF(AD31>AD25,1,0)+IF(AD31>AD26,1,0)+IF(AD31>AD27,1,0)+IF(AD31>AD28,1,0)+IF(AD31>AD29,1,0)+IF(AD31>AD30,1,0)+IF(AD31>AD31,1,0)+IF(AD31>AD32,1,0)+IF(AD31>AD33,1,0)+IF(AD31>AD34,1,0)+IF(AD31>AD35,1,0)+IF(AD31>AD36,1,0)+IF(AD31>AD37,1,0)+IF(AD31>AD38,1,0)+1","v":8},"Electronics and Electrical Products",{"$f":"C32+0.08","v":0.08},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"N) Electronics and Electrical Products",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD32>AD17,1,0)+IF(AD32>AD18,1,0)+IF(AD32>AD19,1,0)+IF(AD32>AD20,1,0)+IF(AD32>AD21,1,0)+IF(AD32>AD22,1,0)+IF(AD32>AD23,1,0)+IF(AD32>AD24,1,0)+IF(AD32>AD25,1,0)+IF(AD32>AD26,1,0)+IF(AD32>AD27,1,0)+IF(AD32>AD28,1,0)+IF(AD32>AD29,1,0)+IF(AD32>AD30,1,0)+IF(AD32>AD31,1,0)+IF(AD32>AD32,1,0)+IF(AD32>AD33,1,0)+IF(AD32>AD34,1,0)+IF(AD32>AD35,1,0)+IF(AD32>AD36,1,0)+IF(AD32>AD37,1,0)+IF(AD32>AD38,1,0)+1","v":7},"Power, Gas, Water & Sanitary Service",{"$f":"C33+0.07","v":7.0000000000000007E-2},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"O) Power, Gas, Water & Sanitary Service",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD33>AD17,1,0)+IF(AD33>AD18,1,0)+IF(AD33>AD19,1,0)+IF(AD33>AD20,1,0)+IF(AD33>AD21,1,0)+IF(AD33>AD22,1,0)+IF(AD33>AD23,1,0)+IF(AD33>AD24,1,0)+IF(AD33>AD25,1,0)+IF(AD33>AD26,1,0)+IF(AD33>AD27,1,0)+IF(AD33>AD28,1,0)+IF(AD33>AD29,1,0)+IF(AD33>AD30,1,0)+IF(AD33>AD31,1,0)+IF(AD33>AD32,1,0)+IF(AD33>AD33,1,0)+IF(AD33>AD34,1,0)+IF(AD33>AD35,1,0)+IF(AD33>AD36,1,0)+IF(AD33>AD37,1,0)+IF(AD33>AD38,1,0)+1","v":6},"Transport and Aviation",{"$f":"C34+0.06","v":0.06},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"P)Transport and Aviation",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD34>AD17,1,0)+IF(AD34>AD18,1,0)+IF(AD34>AD19,1,0)+IF(AD34>AD20,1,0)+IF(AD34>AD21,1,0)+IF(AD34>AD22,1,0)+IF(AD34>AD23,1,0)+IF(AD34>AD24,1,0)+IF(AD34>AD25,1,0)+IF(AD34>AD26,1,0)+IF(AD34>AD27,1,0)+IF(AD34>AD28,1,0)+IF(AD34>AD29,1,0)+IF(AD34>AD30,1,0)+IF(AD34>AD31,1,0)+IF(AD34>AD32,1,0)+IF(AD34>AD33,1,0)+IF(AD34>AD34,1,0)+IF(AD34>AD35,1,0)+IF(AD34>AD36,1,0)+IF(AD34>AD37,1,0)+IF(AD34>AD38,1,0)+1","v":5},"Agriculture",{"$f":"C36+0.05","v":0.05},{"$f":"C36","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Industry Total",0,{"$f":"SUM(D19:D34)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD35>AD17,1,0)+IF(AD35>AD18,1,0)+IF(AD35>AD19,1,0)+IF(AD35>AD20,1,0)+IF(AD35>AD21,1,0)+IF(AD35>AD22,1,0)+IF(AD35>AD23,1,0)+IF(AD35>AD24,1,0)+IF(AD35>AD25,1,0)+IF(AD35>AD26,1,0)+IF(AD35>AD27,1,0)+IF(AD35>AD28,1,0)+IF(AD35>AD29,1,0)+IF(AD35>AD30,1,0)+IF(AD35>AD31,1,0)+IF(AD35>AD32,1,0)+IF(AD35>AD33,1,0)+IF(AD35>AD34,1,0)+IF(AD35>AD35,1,0)+IF(AD35>AD36,1,0)+IF(AD35>AD37,1,0)+IF(AD35>AD38,1,0)+1","v":4},"Housing",{"$f":"C37+0.04","v":0.04},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[3,"Agriculture",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD36>AD17,1,0)+IF(AD36>AD18,1,0)+IF(AD36>AD19,1,0)+IF(AD36>AD20,1,0)+IF(AD36>AD21,1,0)+IF(AD36>AD22,1,0)+IF(AD36>AD23,1,0)+IF(AD36>AD24,1,0)+IF(AD36>AD25,1,0)+IF(AD36>AD26,1,0)+IF(AD36>AD27,1,0)+IF(AD36>AD28,1,0)+IF(AD36>AD29,1,0)+IF(AD36>AD30,1,0)+IF(AD36>AD31,1,0)+IF(AD36>AD32,1,0)+IF(AD36>AD33,1,0)+IF(AD36>AD34,1,0)+IF(AD36>AD35,1,0)+IF(AD36>AD36,1,0)+IF(AD36>AD37,1,0)+IF(AD36>AD38,1,0)+1","v":3},"Merchant Banking",{"$f":"C39+0.03","v":0.03},{"$f":"C39","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,"Housing",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD37>AD17,1,0)+IF(AD37>AD18,1,0)+IF(AD37>AD19,1,0)+IF(AD37>AD20,1,0)+IF(AD37>AD21,1,0)+IF(AD37>AD22,1,0)+IF(AD37>AD23,1,0)+IF(AD37>AD24,1,0)+IF(AD37>AD25,1,0)+IF(AD37>AD26,1,0)+IF(AD37>AD27,1,0)+IF(AD37>AD28,1,0)+IF(AD37>AD29,1,0)+IF(AD37>AD30,1,0)+IF(AD37>AD31,1,0)+IF(AD37>AD32,1,0)+IF(AD37>AD33,1,0)+IF(AD37>AD34,1,0)+IF(AD37>AD35,1,0)+IF(AD37>AD36,1,0)+IF(AD37>AD37,1,0)+IF(AD37>AD38,1,0)+1","v":2},"Margin Loan",{"$f":"C40+0.02","v":0.02},{"$f":"C40","v":0},{"$f":"D40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[5,"Others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD38>AD17,1,0)+IF(AD38>AD18,1,0)+IF(AD38>AD19,1,0)+IF(AD38>AD20,1,0)+IF(AD38>AD21,1,0)+IF(AD38>AD22,1,0)+IF(AD38>AD23,1,0)+IF(AD38>AD24,1,0)+IF(AD38>AD25,1,0)+IF(AD38>AD26,1,0)+IF(AD38>AD27,1,0)+IF(AD38>AD28,1,0)+IF(AD38>AD29,1,0)+IF(AD38>AD30,1,0)+IF(AD38>AD31,1,0)+IF(AD38>AD32,1,0)+IF(AD38>AD33,1,0)+IF(AD38>AD34,1,0)+IF(AD38>AD35,1,0)+IF(AD38>AD36,1,0)+IF(AD38>AD37,1,0)+IF(AD38>AD38,1,0)+1","v":1},"Others",{"$f":"C41+0.01","v":0.01},{"$f":"C41","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"A) Merchant Banking",{"$f":"SUM(D39:E39,G39:H39,J39:K39,M39:N39,P39:Q39)","v":0}]
[null,"B) Margin Loan",{"$f":"SUM(D40:E40,G40:H40,J40:K40,M40:N40,P40:Q40)","v":0}]
[null,"C) Others",{"$f":"SUM(D41:E41,G41:H41,J41:K41,M41:N41,P41:Q41)","v":0}]
[null,"Others Total",{"$f":"SUM(D42:E42,G42:H42,J42:K42,M42:N42,P42:Q42)","v":0},{"$f":"SUM(D39:D41)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P39:P41)","v":0},{"$f":"SUM(Q39:Q41)","v":0},{"$f":"SUM(R39:R41)","v":0}]
[null,"Grand Total",{"$f":"SUM(D43:E43,G43:H43,J43:K43,M43:N43,P43:Q43)","v":0},{"$f":"SUM(D17,D35,D36,D37,D42)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P17,P35,P36,P37,P42)","v":0},{"$f":"SUM(Q17,Q35,Q36,Q37,Q42)","v":0},{"$f":"SUM(R17,R35,R36,R37,R42)","v":0}]
[]
["Table: 3","Top 10 Borrowers STD Loans/Leases"]
["Sl. No","Particulars","Amount in BDT Crore "]
[null,null,"Total ","B1","B2","B3","B4","B5","B6","B7","B8","B9","B10"]
[null,"Total Loans/Leases (Top 10 Borrowers)",{"$f":"SUM(C49:C50)","v":0},0,0,0,0,0,0,0,0,0,0]
[1,"Loans/Leases for which \nEligible Security is held",{"$f":"SUM(D49:Q49)","v":0}]
[2,"Loans/Leases for which \nEligible Security is not held",{"$f":"SUM(D50:Q50)","v":0}]
[3,"Value of Eligible Security",{"$f":"SUM(D51:Q51)","v":0}]
[]
[]
["SHOCKS To Be Applied",null,"Increase in NPLs \n(To B/L)",null,null,"Downward Shift in All Categories",null,null,"Fall in ES",null,null,"Increase of NPLs to B/L \nof 2 Major Sectors",null,null,"Increase of NPLs \nDue to Top 10 Borrowers",null,null,"Fall in the Value of Share"]
[null,null,"Minor","Moderate","Major","Minor","Moderate","Major","Minor","Moderate","Major","in 2 Major Sectors","Moderate","Major","Minor","Moderate","Major","Minor","Moderate","Major"]
[null,null,0.02,0.05,0.1,0.05,0.1,0.15,0.1,0.25,0.5,0.05,0.1,0.15,3,5,10,0.1,0.25,0.5]
[]
[]
[]
["Existing Rate of Provision",null,"STD","SMA","SS","DF","BL"]
[null,null,0.01,0.05,0.2,0.5,1]