{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Page1","Page2","Page3","Print"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":81,"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":"Page1","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,3,2,4],[48,6,48,7]]}
[]
[null,null,null,null," Capital Adequacy (CA) Return\nfor British Columbia Credit Unions"]
[null,null,null,"[Enter Credit Union Name]",null," ","Credit Union"]
[null,null,null,null,"as at [Date]"]
[null,null,"Line",null,null,null,"Annual Financial & Statistical Return"]
[null,null,"#","Account Name","$ Amount",null,"(AFSR) Line Numbers & Instructions"]
[null,"SUMMARY",null,null,null,null," ",null," "]
[null,null," "]
[null,null,900,"Capital Base",{"$f":"E53","v":0},"l",{"$f":"\"CA Return Line \"&C53&\" from below\"","v":"CA Return Line 132 from below"}]
[null,null,901,"Total Risk Weighted Assets (RWA)",{"$f":"Page3!H60","v":0},"l",{"$f":"\"CA Return Line \"&Page3!C60&\" from Page 3\"","v":"CA Return Line 316 from Page 3"}]
[null,null,902,"Capital Adequacy Ratio - %",{"$f":"IF(E9=0,\" \",E9/E10)","v":" "},"l","Capital Base divided by RWA"]
[null,null,null," "]
[null,"CAPITAL BASE",null,null,null,null," ",null," "]
[null,null,"Primary Capital"]
[null,null,101,"Equity Shares - Membership",null,"l","2191"]
[null,null,{"$f":"C15+1","v":102},"Equity Shares - Investment, Net of Discount",null,"l","2192 less 2193"]
[null,null,{"$f":"C16+1","v":103},"Equity Shares - Transaction, Net of Discount",null,"l","2194 less 2195"]
[null,null,104,"Equity Shares - Preferred, Net of Discount",null,"l","2196 less 2197"]
[null,null,105,"Equity Shares - Other, Net of Discount",null,"l","2198 less 2199"]
[null,null,106,"CUDIC / SCCU Subordinated Debt, Net of Discount"," ","l","2250 less 2255"]
[null,null,107,"Credit Union's Retained Earnings"," ","l","2230"]
[null,null,{"$f":"C21+1","v":108},"Deferred Income Tax (Asset)/Liability"," ","l","add 2240 or deduct 1390",null,null," "]
[null,null,109,"Contributed Surplus"," ","l","2208"]
[null,null,{"$f":"C23+1","v":110},"Other Primary Capital",null,"l","2260",null,null," "]
[null,null,{"$f":"C24+1","v":111},"Dividends to be Paid as Primary Capital",null,"l","2270"]
[null,null,{"$f":"C25+1","v":112},"Total Primary Capital",{"$f":"SUM(E15:E25)","v":0},"l",{"$f":"\"sum of CA Return Lines \"&C15&\" to \"&C25","v":"sum of CA Return Lines 101 to 111"}]
[null,null,"Secondary Capital"]
[null,null,{"$f":"C26+1","v":113},"Proportion of System Retained Earnings x 50%"," ","l","provided by FICOM"]
[null,null,{"$f":"C28+1","v":114},"Equity Shares - Investment, Net of Discount",null,"l","2271 less 2272"]
[null,null,115,"Equity Shares - Transaction, Net of Discount",null,"l","2273 less 2274"]
[null,null,116,"Equity Shares - Preferred, Net of Discount",null,"l","2276 less 2277"]
[null,null,117,"Equity Shares - Other, Net of Discount",null,"l","2278 less 2279"]
[null,null,118,"Other Debt Capital, Net of Discount"," ","l","2290 less 2295",null,null," "]
[null,null,119,"Other Secondary Capital",null,"l","2296"]
[null,null,120,"Dividends to be Paid as Secondary Capital",null,"l","2300"]
[null,null,121,"Total Secondary Capital",{"$f":"SUM(E28:E35)","v":0},"l",{"$f":"\"sum of CA Return Lines \"&C28&\" to \"&C35","v":"sum of CA Return Lines 113 to 120"}]
[null,null,122,"Total Eligible Secondary Capital",{"$f":"IF(E36>E26,E26,E36)","v":0},"l",{"$f":"\"lesser of CA Return Lines \"&C36&\" and \"&C26","v":"lesser of CA Return Lines 121 and 112"}]
[null,null,"Deductions from Capital"]
[null," ",{"$f":"C37+1","v":123},"Goodwill and Other Intangible Assets (Incl. in Inv. Value)"," ","l","included in 6300",null,null," "]
[null,null,{"$f":"C39+1","v":124},"Goodwill and Other Intangible Assets (Not Incl. in Inv. Value)",null,"l","included in 6300"]
[null,null,{"$f":"C40+1","v":125},"Investment - Banks, Trust or Deposit Business"," ","l","included in 6310",null,null," "]
[null,null,{"$f":"C41+1","v":126},"Invest. - Insurance Business, Venture Cap. Corp., etc."," ","l","included in 6310",null,null," "]
[null,null,127,"Excess Investment in Prescribed Businesses"," ","l","6320"]
[null,null,128,"Other",null,"l","6330"]
[null,null,129,"Total Deductions from Capital",{"$f":"SUM(E39:E44)","v":0},"l",{"$f":"\"CA Return Lines \"&C39&\" to \"&C44","v":"CA Return Lines 123 to 128"}]
[]
[null,null,{"$f":"C45+1","v":130},"Total Capital Available",{"$f":"+E26+E37-E45","v":0},"l",{"$f":"\"CA Return Lines \"&C26&\" plus \"&C37&\" less \"&C45","v":"CA Return Lines 112 plus 122 less 129"}]
[]
[null,null,{"$f":"C47+1","v":131},"CU Ret. Earnings plus Cont. Surplus divided by 35%",{"$f":"IF(E21=\" \",\" \",(E21+E23)/0.35)","v":" "},"l",{"$f":"\"sum of CA Return Lines \"&C21&\" and \"&C23&\" divided by 35%\"","v":"sum of CA Return Lines 107 and 109 divided by 35%"},null,null," "]
[]
[null,null,{"$f":"\"Capital Base is the Lesser of Line \"&C47&\" or Line \"&C49&\":\"","v":"Capital Base is the Lesser of Line 130 or Line 131:"}]
[]
[null,null,{"$f":"C49+1","v":132},"CAPITAL BASE",{"$f":"+MIN(E47,E49)","v":0},"l",{"$f":"\"lesser of CA Return Lines \"&C47&\" or \"&C49","v":"lesser of CA Return Lines 130 or 131"}]

{"sheet":"Page2","index":1,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[37,8,37,9],[42,8,42,9],[59,8,59,9],[2,3,2,6],[24,8,24,9],[30,8,30,9],[31,8,31,9],[32,8,32,9]]}
[]
[null," ",null,null,null,"Capital Adequacy (CA) Return\nfor British Columbia Credit Unions"]
[null,null,null,"[Enter Credit Union Name]",null,null,null,null,"Credit Union"]
[null,null,null,null,"as at [Date]"]
[null,null,"Line",null,"Unweighted","Risk","Risk Weighted",null,"Annual Financial & Statistical Return   "]
[null,null,"#","Account Name","  $ Amount  x","Factor","=   $ Value",null,"(AFSR) Line Numbers & Instructions   "]
[null,"BALANCE SHEET ASSETS",null,null,null,null,null,null," "]
[null,null,"Cash, Liquidity & Other Investments",null,null,null,null,"Unweighted Column Reference"]
[null,null,201,"Cash"," ",0,{"$f":"IF(E9=\" \",\" \",E9*F9)","v":" "},"l","1010"]
[null,null,{"$f":"C9+1","v":202},"Central 1 - Operating Account"," ",0," ","l","1020 plus 1090*"]
[null,null,{"$f":"C10+1","v":203},"Central 1 - Deposits"," ",0," ","l","1030 plus 1090* plus 1097**"]
[null,null,{"$f":"C11+1","v":204},"Guaranteed Security Instruments"," ",0,{"$f":"IF(E12=\" \",\" \",E12*F12)","v":" "},"l","1040 plus 1090* plus 1097**"]
[null,null,{"$f":"C12+1","v":205},"Other Deposits"," ",0.2," ","l","1050 plus 1090* plus 1097**"]
[null,null,{"$f":"C13+1","v":206},"Debt Security Instruments"," ",0.2," ","l","1060 plus 1090* plus 1097**"]
[null,null,"Commercial Paper:"]
[null,null,{"$f":"C14+1","v":207},"AAA to AA (low) or R1 (high)"," ",0.2," ","l","1070 plus 1090* plus 1097**"]
[null,null,{"$f":"C16+1","v":208},"A (high) to A (low) or R1 (middle)"," ",0.5," ","l","1071 plus 1090* plus 1097**"]
[null,null,{"$f":"C17+1","v":209},"BBB (high) to BB (low) or R1 (low) to R2 (low) / Unrated"," ",1," ","l","1072 plus 1090* plus 1097**"]
[null,null,{"$f":"C18+1","v":210},"Below BB (low) or Below R2 (low)"," ",1.5," ","l","1073 plus 1090* plus 1097**"]
[]
[null,null,247,"Securities Secured by Mortgages: Guaranteed by CMHC"," ",0,{"$f":"IF(E21=\" \",\" \",E21*F21)","v":" "},"l","1078 plus 1090* plus 1097**"]
[null,null,248,"Securities Secured by Mortgages: Other"," ",1," ","l","1079 plus 1090* plus 1097**"]
[null,null,214,"Other Liquidity Investments"," ",1," ","l","1080 plus 1090* plus 1097**"]
[null,null,{"$f":"C23+1","v":215},"CU Centrals Equity Shares & CUDIC Deb."," ",1," ","l","1140"]
[null,null,{"$f":"C24+1","v":216},"Total Cash, Liquidity & Other Invest.",{"$f":"SUM(E9:E24)","v":0},null,{"$f":"SUM(G9:G24)","v":0},"l",{"$f":"\"1100 plus 1140 or sum of CA Return Lines \"&C9&\" to \"&C24","v":"1100 plus 1140 or sum of CA Return Lines 201 to 215"}]
[null,null,"Loans & Leases"]
[null,null,{"$f":"C25+1","v":217},"Pers. R/E Secured: Insured"," ",0,{"$f":"IF(E27=\" \",\" \",E27*F27)","v":" "},"l","1150 plus 1290* plus 1300** "]
[null,null,{"$f":"C27+1","v":218},"Comm. R/E Secured: Insured"," ",0,{"$f":"IF(E28=\" \",\" \",E28*F28)","v":" "},"l","1210 plus 1290* plus 1310**"]
[null,null,{"$f":"C28+1","v":219},"Securitizations: Pers. & Comm. R/E Secured: Insured"," ",0," ","l","1284 plus 1286 plus 1290* plus 1300**  plus 1310**"]
[null,null,"Personal R/E Res. ≤ 75% of FMV:"]
[null,null,{"$f":"C29+1","v":220},"Current or Past Due ≤ 90 Days, Net of Prov."," ",0.35,{"$f":"IF(E31=\" \",\" \",E31*F31)","v":" "},"l","included in 1160 and in 1288 plus 1290* plus 1300** "]
[null,null,222,"Past Due > 90 Days, Net of Spec. Prov. ≥ 20%"," ",0.5,{"$f":"IF(E32=\" \",\" \",E32*F32)","v":" "},"l","included in 1160 and in 1288 plus 1290* plus 1300** ",null,null,null," "]
[null,null,{"$f":"C32+1","v":223},"Past Due > 90 Days, Net of Spec. Prov. < 20%"," ",1,{"$f":"IF(E33=\" \",\" \",E33*F33)","v":" "},"l","included in 1160 and in 1288 plus 1290* plus 1300** ",null,null,null," "]
[null,null,"All Other Loans & Leases - Current or Past Due ≤ 90 Days, Net of Provision and Past Due > 90 Days, Secured Portion:"]
[null,null,{"$f":"C33+1","v":224},"Fully Sec. by Dep. with DTI or OECD Central Bank"," ",0.2,{"$f":"IF(E35=\" \",\" \",E35*F35)","v":" "},"l","included in 1180 plus 1250 plus 1290* plus 1300**  plus 1310**"]
[null,null,{"$f":"C35+1","v":225},"Guar. By Gov't or Fully Sec. by Dep. & Gov't Sec."," ",0,{"$f":"IF(E36=\" \",\" \",E36*F36)","v":" "},"l","included in 1180 plus 1250 plus 1290* plus 1300**  plus 1310**"]
[null,null,226,"Comm. Unsecured: Governments & Municipalities"," ",0," ","l","1270 plus 1290* plus 1310**"]
[null,null,227,"Pers. R/E Res. >75% of FMV"," ",0.75,{"$f":"IF(E38=\" \",\" \",E38*F38)","v":" "},"l","included in 1170 and in 1288 plus 1290* plus 1300**"]
[null,null,228,"Pers. Otherwise Sec: Leases"," ",0.75,{"$f":"IF(E39=\" \",\" \",E39*F39)","v":" "},"l","1187 plus 1290* plus 1300**"]
[null,null,229,"Pers. Otherwise Sec: All Others"," ",0.75," ","l","1190 plus 1290* plus 1300**"]
[null,null,230,"Pers. Unsecured"," ",0.75," ","l","1200 plus 1290* plus 1300**"]
[null,null,{"$f":"C41+1","v":231},"Comm. R/E Res. ≤ 75% of FMV"," ",0.35,{"$f":"IF(E42=\" \",\" \",E42*F42)","v":" "},"l","included in 1220 plus 1290* plus 1310**"]
[null,null,232,"Other Commercial Loans & Leases"," ",1,{"$f":"IF(E43=\" \",\" \",E43*F43)","v":" "},"l","sum (incl. in 1220,1230,1240,1257,1260,1280,1289,1290*) plus 1310**",null,null,null," "]
[null,null,"All Other Loans & Leases - Past Due > 90 Days, Unsecured Portion, Net of Specific Provision:"]
[null,null,{"$f":"C43+1","v":233},"Net of Specific Provision ≥ 20%"," ",1,{"$f":"IF(E45=\" \",\" \",E45*F45)","v":" "},"l",{"$f":"\"split between CA Return Lines \"&$C$35&\" to \"&$C$43","v":"split between CA Return Lines 224 to 232"}]
[null,null,{"$f":"C45+1","v":234},"Net of Specific Provision < 20%"," ",1.5,{"$f":"IF(E46=\" \",\" \",E46*F46)","v":" "},"l",{"$f":"\"split between CA Return Lines \"&$C$35&\" to \"&$C$43","v":"split between CA Return Lines 224 to 232"}]
[null,null,{"$f":"C46+1","v":235},"Total Loans & Leases",{"$f":"SUM(E27:E46)","v":0},null,{"$f":"SUM(G27:G46)","v":0},"l",{"$f":"\"1320 or sum of CA Return Lines \"&C27&\" to \"&C46","v":"1320 or sum of CA Return Lines 217 to 234"}]
[null,null,"Other Assets"]
[null,null,{"$f":"C47+1","v":236},"Premises & Equipment - Net"," ",1,{"$f":"IF(E49=\" \",\" \",E49*F49)","v":" "},"l",{"$f":"\"1330 less assets incl. in CA Return Line \"&C54","v":"1330 less assets incl. in CA Return Line 241"}]
[null,null,{"$f":"C49+1","v":237},"Prop. Acq. in Settle. of Loans & Leases - Net"," ",1," ","l","1350"]
[null,null,238,"Prop. Held for Investments - Net"," ",1.5," ","l","1360"]
[null,null,239,"Equity Investments <10% Ownership"," ",1,{"$f":"IF(E52=\" \",\" \",E52*F52)","v":" "},"l",{"$f":"\"1370 less assets incl. in CA Return Line \"&C54","v":"1370 less assets incl. in CA Return Line 241"}]
[null,null,240,"Equity Investments ≥10% Ownership"," ",1," ","l",{"$f":"\"1380 less assets incl. in CA Return Line \"&C54","v":"1380 less assets incl. in CA Return Line 241"}]
[null,null,241,"Deductions from Capital"," ",0," ","l",{"$f":"\"sum of CA Return Lines \"&Page1!C39&\" to \"&Page1!C42","v":"sum of CA Return Lines 123 to 126"}]
[null,null,242,"Derivative Financial Instruments"," ",0," ","l",1407]
[null,null,243,"Deferred Income Tax Debit"," ",1," ","l",1390]
[null,null,244,"All Other Assets"," ",1,{"$f":"IF(E57=\" \",\" \",E57*F57)","v":" "},"l","1410"]
[null,null,245,"Total Other Assets",{"$f":"SUM(E49:E57)","v":0},null,{"$f":"SUM(G49:G57)","v":0},"l",{"$f":"\"1420 or sum of CA Return Lines \"&C49&\" to \"&C57","v":"1420 or sum of CA Return Lines 236 to 244"}]
[]
[null,null,{"$f":"C58+1","v":246},"TOTAL ASSETS",{"$f":"+E25+E47+E58","v":0},null,{"$f":"+G25+G47+G58","v":0},"l",{"$f":"\"1430 or sum of CA Return Lines \"&C25&\", \"&C47&\", \"&C58","v":"1430 or sum of CA Return Lines 216, 235, 245"}]
[null,null,null,null,null,null,null,null,"* includes accrued interest allocation"]
[null,null,null,null,null,null,null,null,"** includes allowance allocation"]

{"sheet":"Page3","index":2,"n_rows":60,"n_cols":12,"rows_kept":60,"cut":false,"hidden":false,"merged":[[1,5,1,12],[2,6,2,12],[3,3,3,7],[53,9,53,11],[46,3,46,4],[52,9,52,11],[12,3,12,4],[52,3,52,4],[53,3,53,4]]}
[]
[null," ",null,null,null,"              Capital Adequacy (CA) Return"]
[null,null,null,null,null,null," for British Columbia Credit Unions"]
[null,null,null,"[Enter Credit Union Name]",null,null,null,null," Credit Union"]
[null,null,null,null,null,"as at [Date]"]
[null,null,"Line",null,null,"Unweighted",null,"Credit Conversion",null,"On Balance Sheet ",null,"Risk Weighted"]
[null,null,"#","Account Name",null,"$ Amount","x","Factor","x","Risk Weight","=","$ Value"]
[null,"OFF BALANCE SHEET EXPOSURES",null,null,null,null,null,null,null," "]
[null,null," "]
[null,null,301,"Guarantees of Indebtedness",null," ","x",1,"x"," ","=",{"$f":"IF(F10=\" \",\" \",F10*H10*J10)","v":" "}]
[null,null,302,"Letters of Credit",null," ","x",null,"x"," ","="," "]
[null,null,303,"Performance and Bid Bonds",null," ","x",0.5,"x",null,"="," "]
[null,null,304,"Commitments (Unconditionally Cancellable)",null," ","x",0,"x",null,"="," "]
[null,null,{"$f":"C13+1","v":305},"Commitments (Orig. Mat. ≤ 1 Year)",null," ","x",0.2,"x",null,"="," "]
[null,null,306,"Commitments (Orig. Mat. > 1 Year)",null," ","x",0.5,"x",null,"="," "]
[null,null,307,"Other (specify)",null," ","x",null,"x"," ","="," "]
[null,null,308,"Interest Rate Contracts",null,">>>>>>>>>>>>>>>> calculate below >>>>>>>>>>>>>>>>>>>",null,null,null,null,null,{"$f":"L31","v":0}]
[null,null,309,"Foreign Exchange Rate Contracts",null,">>>>>>>>>>>>>>>> calculate below >>>>>>>>>>>>>>>>>>>",null,null,null,null,null,{"$f":"L43","v":0}]
[null,null,310,"TOTAL OFF BALANCE SHEET EXPOSURES",null,null,null,null,null,null,null,{"$f":"SUM(L10:L18)","v":0}]
[null,null,null,null,null,null,null,null," "," "," "," "]
[null,null,"Interest Rate Contracts (i.e. SWAPS, Forward Rate Agreements, Swaptions, etc.)"]
[null,null,null,null,null,null,null,"Credit",null,"Off-Balance Sheet",null,"Risk"]
[null,null,null,null,null,null,null,"Conversion  ",null,"Risk Weight",null,"Weighted"]
[null,null,"Counterparty",null,"[ Positive Market Value","+ (Notional Principal","x","       Factor  )]","x","of Counterparty *","=","$ Value"]
[null,null,"Central 1",null," "," ","x",5.0000000000000001E-3,"x",0,"=",{"$f":"IF(F25=\" \",\" \",(E25+(F25*H25))*J25)","v":" "}]
[null,null,"Banks",null,null," ","x",5.0000000000000001E-3,"x",0.2,"=",{"$f":"IF(F26=\" \",\" \",(E26+(F26*H26))*J26)","v":" "}]
[null,null,null,null,null,null,"x",null,"x",null,"=",0]
[null,null,null,null,null,null,"x",null,"x",null,"=",0]
[null,null,null,null,null," ","x",null,"x",null,"="," "]
[null,null,null,null,null," ","x",null,"x",null,"="," "]
[null,null,"*  if Central 1 is the counterparty and transfers default risk of swap",null,null,null,null,null,null,null,{"$f":"\"Total Interest Rate Contracts (To Line \"&C17&\")\"","v":"Total Interest Rate Contracts (To Line 308)"},{"$f":"SUM(L25:L30)","v":0}]
[null,null,"    with Bank back to credit union then a risk weight of 0.2 would apply"]
[null,null,"Foreign Exchange Rate Contracts (i.e. Cross Currency Swaps, FX Forwards, etc.)"]
[null,null,null,null,null,null,null,"Credit",null,"Off-Balance Sheet",null,"Risk"]
[null,null,null,null,null,null,null,"Conversion  ",null,"Risk Weight",null,"Weighted"]
[null,null,"Counterparty",null,"[ Positive Market Value","+ (Notional Principal","x","       Factor  )]","x","of Counterparty *","=","$ Value"]
[null,null,"Central 1",null," "," ","x",5.0000000000000001E-3,"x",0,"=",{"$f":"IF(F37=\" \",\" \",(E37+(F37*H37))*J37)","v":" "}]
[null,null,"Banks",null,null," ","x",5.0000000000000001E-3,"x",0.2,"="," "]
[null,null,null,null,null,null,"x",null,"x",null,"=",0]
[null,null,null,null,null,null,"x",null,"x",null,"=",0]
[null,null,null,null,null," ","x",null,"x",null,"="," "]
[null,null,null,null,null," ","x",null,"x",null,"="," "]
[null,null,"*  if Central 1 is the counterparty and transfers default risk of swap",null,null,null,null,null,null,null,{"$f":"\"Total FX Rate Contracts (To Line \"&C18&\")\"","v":"Total FX Rate Contracts (To Line 309)"},{"$f":"SUM(L37:L42)","v":0}]
[null,null,"    with Bank back to credit union then a risk weight of 0.2 would apply"]
[]
[null,null,"Line",null,null,"Unweighted","Risk","Risk Weighted",null,"Annual Financial & Statistical Return"]
[null,null,"#","Account Name",null,"$ Amount  x","Factor","=  $ Value",null,"(AFSR) Line Numbers & Instructions"]
[null,"RISK WEIGHTED ASSETS"]
[null,null," "]
[null,null,"BALANCE SHEET ASSETS - RISK WEIGHTED",null,null,null,null,{"$f":"Page2!G60","v":0},"l",{"$f":"\"CA Return Line \"&Page2!C60&\" from Page 2\"","v":"CA Return Line 246 from Page 2"}]
[null,null,"OFF BALANCE SHEET EXPOSURES",null,null,null,null,{"$f":"Page3!L19","v":0},"l",{"$f":"\"4510 or CA Return Line \"&C19&\" above\"","v":"4510 or CA Return Line 310 above"}]
[null,null,"Concentration Risk Adjustments:"]
[null,null,317,"Excess Comm. Loans & Leases (>30% & ≤35%)",null," ",0.5,{"$f":"IF(F53=\" \",\" \",F53*G53)","v":" "},"l","(sum (1220,1230,1240,1257,1260,1280,1289,1290*) plus 1310) exceeding 30% up to 35% of 1430"]
[null,null,{"$f":"C19+1","v":311},"Excess Comm. Loans & Leases (>35%)",null," ",1,{"$f":"IF(F54=\" \",\" \",F54*G54)","v":" "},"l","(sum (1220,1230,1240,1257,1260,1280,1289,1290*) plus 1310) exceeding 35% of 1430"]
[null,null,{"$f":"C54+1","v":312},"Excess Investment in Land",null," ",1,{"$f":"IF(F55=\" \",\" \",F55*G55)","v":" "},"l","1360 exceeding 5% of 1430"]
[null,null,{"$f":"C55+1","v":313},"Excess Inv. in Single Land Parcels",null," ",1,{"$f":"IF(F56=\" \",\" \",F56*G56)","v":" "},"l","4520 exceeding 1% of 1430"]
[null,null,{"$f":"C56+1","v":314},"Excess 3rd & Subsequent Mortgages",null," ",1,{"$f":"IF(F57=\" \",\" \",F57*G57)","v":" "},"l","3rd & Sub. Mtgs. exceeding 2% of 1430"]
[null,null,{"$f":"C57+1","v":315},"Total Concentration Risk Adj.",null,{"$f":"SUM(F53:F57)","v":0},null,{"$f":"SUM(H53:H57)","v":0},"l",{"$f":"\"sum of CA Return Lines \"&C53&\", \"&C54&\" to \"&C57","v":"sum of CA Return Lines 317, 311 to 314"}]
[null,null,null,null,null,null,null,null,null,"* includes accrued interest allocation"]
[null,null,{"$f":"C58+1","v":316},"TOTAL RISK WEIGHTED ASSETS",null,null,null,{"$f":"SUM(H50,H51,H58)","v":0},"l",{"$f":"\"sum of CA Return Lines \"&Page2!C60&\", \"&C19&\", \"&C58","v":"sum of CA Return Lines 246, 310, 315"}]

{"sheet":"Print","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,11]]}
["NOTE: Macros must be enabled first before printing"]
[]
[]
[" Step 1","a)","If a Security Warning bar appears above this worksheet (similar to the one shown below)"]
[null,null," indicating \"Macros have been disabled,\" proceed to Step 2"]
[]
[]
[]
[]
[]
[]
[null,"b)","If no Security Warning bar appears above this worksheet,"]
[null,null,"proceed to Step 4"]
[]
[]
[" Step 2",null,"Press the \"Options...\" button on the Security Warning bar that appears above this worksheet,"]
[null,null,"and a Security Alert - Macro window will pop up."]
[]
[" Step 3",null,"On the Security Alert - Macro window, select \"Enable this content\" and click \"OK.\" "]
[null,null,"The Security Warning Bar and the Security Alert - Macro window will both disappear."]
[]
[" Step 4",null,"Click the \"Print CA Return\" button below:"]