{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Summary Submission Cover Sheet","Income Statement Worksheet","Balance Sheet Worksheet","Capital Worksheet","Retail Balance Projections","Retail Loss Projections","Retail Repurchase Worksheet","Retail ASC 310-30 Worksheet","Retail Fair Value Worksheet","Securities CUSIPs Worksheet","Securities Worksheet 1","Securities Worksheet 2","Securities Worksheet 3","Securities Worksheet 4","Trading Worksheet","Counterparty Risk Worksheet","Op Risk Scenario Inputs","Projected Op Risk Losses","PPNR Projections Worksheet","PPNR NII Worksheet","PPNR Metrics Worksheet"],"not_rendered":{"external_links":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Summary Submission Cover Sheet","index":0,"n_rows":38,"n_cols":4,"rows_kept":38,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[11,3,11,6],[19,1,19,4],[21,1,21,11]]}
["Summary Submission Cover Sheet"]
["Dodd-Frank Act Annual Stress Test Reporting Template for Covered Banks with Total Consolidated Assets of $50 Billion or More"]
["All Covered Banks are expected to complete a version of the Summary template for each required scenario - Baseline, Adverse, and Severely Adverse. "]
[]
["Covered Banks should complete all relevant cells in the corresponding worksheets, including this cover page.  Covered Banks should not complete any shaded cells."]
["Please ensure that the data submitted in this Summary Template match what was submitted in other data templates."]
["Please do not change the structure of this workbook."]
["Please note that unlike Call Report reporting, all actual and projected income statement figures should be reported on a quarterly basis, and not on a cumulative basis."]
["Any questions should be directed to XXXXX@fdic.gov."]
[]
[]
[null,"Bank Name:"]
[]
[null,"Certificate Number: "]
[null,"Source:",null,"Bank"]
[null,"Submission Date (MM/DD/YYYY):"]
[null,"When Received:",null,{"$f":"NOW()","v":"2012-10-18T18:31:16.400"}]
[]
[null,"Please indicate the scenario associated with this submission using the following drop-down menu:"]
[null,"Baseline"]
[null,"Briefly describe the scenario below:"]
[]
[]
[]
[]
["Baseline"]
["Adverse"]
["Severely Adverse"]
["Bank Additional Scenario 1"]
["Bank Additional Scenario 2"]
["Bank Additional Scenario 3"]
["Bank Additional Scenario 4"]
["Bank Additional Scenario 5"]
["Bank Additional Scenario 6"]
["Bank Additional Scenario 7"]
["Bank Additional Scenario 8"]
["Bank Additional Scenario 9"]
["Bank Additional Scenario 10"]

{"sheet":"Income Statement Worksheet","index":1,"n_rows":136,"n_cols":19,"rows_kept":136,"merged":[[0,0,0,18],[1,0,1,18],[2,6,2,14],[2,16,2,18],[92,5,92,14]]}
[{"$f":"'Summary Submission Cover Sheet'!$D$15&\" Income Statement Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Income Statement Worksheet:  in Baseline"}]
[{"$f":"IF('[1]Summary Submission Cover Sheet'!D16=\"\",\"\",'[1]Summary Submission Cover Sheet'!D16)","v":""}]
[{"$nulls":5},"Actual in $Millions","Projected in $Millions",{"$nulls":9},"Sums in $Millions"]
["Item",null,null,"Notes",null,"Q3 2012","Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014",null,2013,2014,"9-Quarter"]
[]
[null,"LOAN LOSSES"]
[1,"First Lien Mortgages",{"$nulls":4},{"$f":"SUM('[1]Retail Loss Projections'!C5,'[1]Retail Loss Projections'!C12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!D5,'[1]Retail Loss Projections'!D12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!E5,'[1]Retail Loss Projections'!E12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!F5,'[1]Retail Loss Projections'!F12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!G5,'[1]Retail Loss Projections'!G12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!H5,'[1]Retail Loss Projections'!H12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!I5,'[1]Retail Loss Projections'!I12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!J5,'[1]Retail Loss Projections'!J12)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!K5,'[1]Retail Loss Projections'!K12)","v":0},null,{"$f":"SUM(H7:K7)","v":0},{"$f":"SUM(L7:O7)","v":0},{"$f":"SUM(G7,H7:K7,L7:O7)","v":0}]
[{"$f":"A7+1","v":2},"Second / Junior Lien Mortgages",null,{"$f":"\"Sum of items \"&A9&\" and \"&A10","v":"Sum of items 3 and 4"},null,null,{"$f":"SUM(G9:G10)","v":0},0,0,0,0,0,0,0,0,null,0,0,0]
[3,"Closed-End Junior Liens",{"$nulls":14},0,0,0]
[4,"HELOCs",{"$nulls":14},0,0,0]
[5,"C&I Loans",null,{"$f":"\"Sum of items \"&A12&\" to \"&A14","v":"Sum of items 6 to 8"},null,null,{"$f":"SUM(G12:G14)","v":0},0,0,0,0,0,0,0,0,null,0,0,0]
[6,"Large Commercial Credits",{"$nulls":14},0,0,0]
[7,"Small Business (Graded)",{"$nulls":14},0,0,0]
[8,"Small Business (Scored/Delinquency Managed)",{"$nulls":4},{"$f":"SUM('[1]Retail Loss Projections'!C21,'[1]Retail Loss Projections'!C22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!D21,'[1]Retail Loss Projections'!D22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!E21,'[1]Retail Loss Projections'!E22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!F21,'[1]Retail Loss Projections'!F22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!G21,'[1]Retail Loss Projections'!G22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!H21,'[1]Retail Loss Projections'!H22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!I21,'[1]Retail Loss Projections'!I22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!J21,'[1]Retail Loss Projections'!J22)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!K21,'[1]Retail Loss Projections'!K22)","v":0},null,0,0,0]
[9,"CRE Loans",null,{"$f":"\"Sum of items \"&A16&\" to \"&A18","v":"Sum of items 10 to 12"},null,null,{"$f":"SUM(G16:G18)","v":0},0,0,0,0,0,0,0,0,null,0,0,0]
[10,"Construction",{"$nulls":14},0,0,0]
[11,"Multifamily",{"$nulls":14},0,0,0]
[12,"Nonfarm, Non-residential",{"$nulls":14},0,0,0]
[13,"Credit Cards",{"$nulls":4},{"$f":"'[1]Retail Loss Projections'!C14","v":0},{"$f":"'[1]Retail Loss Projections'!D14","v":0},{"$f":"'[1]Retail Loss Projections'!E14","v":0},{"$f":"'[1]Retail Loss Projections'!F14","v":0},{"$f":"'[1]Retail Loss Projections'!G14","v":0},{"$f":"'[1]Retail Loss Projections'!H14","v":0},{"$f":"'[1]Retail Loss Projections'!I14","v":0},{"$f":"'[1]Retail Loss Projections'!J14","v":0},{"$f":"'[1]Retail Loss Projections'!K14","v":0},null,0,0,0]
[14,"Other Consumer",null,{"$f":"\"Sum of items \"&A21&\" to \"&A23","v":"Sum of items 15 to 17"},null,null,{"$f":"SUM(G21:G23)","v":0},0,0,0,0,0,0,0,0,null,0,0,0]
[15,"Auto Loans",{"$nulls":4},{"$f":"SUM('[1]Retail Loss Projections'!C18,'[1]Retail Loss Projections'!C19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!D18,'[1]Retail Loss Projections'!D19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!E18,'[1]Retail Loss Projections'!E19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!F18,'[1]Retail Loss Projections'!F19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!G18,'[1]Retail Loss Projections'!G19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!H18,'[1]Retail Loss Projections'!H19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!I18,'[1]Retail Loss Projections'!I19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!J18,'[1]Retail Loss Projections'!J19)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!K18,'[1]Retail Loss Projections'!K19)","v":0},null,0,0,0]
[16,"Student Loans",{"$nulls":4},{"$f":"SUM('[1]Retail Loss Projections'!C20)","v":0},{"$f":"'[1]Retail Loss Projections'!D20","v":0},{"$f":"'[1]Retail Loss Projections'!E20","v":0},{"$f":"'[1]Retail Loss Projections'!F20","v":0},{"$f":"'[1]Retail Loss Projections'!G20","v":0},{"$f":"'[1]Retail Loss Projections'!H20","v":0},{"$f":"'[1]Retail Loss Projections'!I20","v":0},{"$f":"'[1]Retail Loss Projections'!J20","v":0},{"$f":"'[1]Retail Loss Projections'!K20","v":0},null,0,0,0]
[17,"Other ",{"$nulls":4},{"$f":"SUM('[1]Retail Loss Projections'!C23,'[1]Retail Loss Projections'!C24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!D23,'[1]Retail Loss Projections'!D24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!E23,'[1]Retail Loss Projections'!E24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!F23,'[1]Retail Loss Projections'!F24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!G23,'[1]Retail Loss Projections'!G24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!H23,'[1]Retail Loss Projections'!H24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!I23,'[1]Retail Loss Projections'!I24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!J23,'[1]Retail Loss Projections'!J24)","v":0},{"$f":"SUM('[1]Retail Loss Projections'!K23,'[1]Retail Loss Projections'!K24)","v":0},null,0,0,0]
[18,"Other Loans",null,{"$f":"\"Sum of items \"&A25&\" to \"&A29","v":"Sum of items 19 to 23"},null,null,{"$f":"SUM(G25:G29)","v":0},0,0,0,0,0,0,0,0,null,0,0,0]
[19,"Loans to foreign governments",{"$nulls":14},0,0,0]
[20,"Agricultural loans",{"$nulls":14},0,0,0]
[21,"Securities Lending",{"$nulls":14},0,0,0]
[22,"Loans to depositories and other financial institutions",{"$nulls":14},0,0,0]
[23,"All other loans",{"$nulls":14},0,0,0]
[24,"Total Loan Losses","is_total_loans",{"$f":"\"Sum of items \"&A7&\", \"&A8&\", \"&A11&\", \"&A15&\", \"&A19&\", \"&A20&\", and \"&A24&\" B47 - riad4605\"","v":"Sum of items 1, 2, 5, 9, 13, 14, and 18 B47 - riad4605"},null,null,{"$f":"SUM(G7,G8,G11,G15,G19,G20,G24)","v":0},0,0,0,0,0,0,0,0,null,0,0,0]
[]
[null,"COMMITMENTS AND CONTINGENT OBLIGATIONS"]
[{"$f":"A30+1","v":25},"   Total Commitment and Contingent Losses",{"$nulls":14},{"$f":"SUM(H33:K33)","v":0},{"$f":"SUM(L33:O33)","v":0},{"$f":"SUM(G33,H33:K33,L33:O33)","v":0}]
[]
[null,"SECURITIES"]
[{"$f":"A33+1","v":26},"Other-than temporary impairment — Held to Maturity (HTM) Securities",{"$nulls":4},{"$f":"SUM('[1]Securities Worksheet 1'!E74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!H74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!K74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!N74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!Q74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!T74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!W74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!Z74)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!AC74)","v":0},null,{"$f":"SUM(H36:K36)","v":0},{"$f":"SUM(L36:N36)","v":0},{"$f":"SUM(G36,H36:K36,L36:N36)","v":0}]
[{"$f":"A36+1","v":27},"Other-than temporary impairment — Available for Sale (AFS) Securities",{"$nulls":4},{"$f":"SUM('[1]Securities Worksheet 1'!E37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!H37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!K37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!N37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!Q37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!T37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!W37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!Z37)","v":0},{"$f":"SUM('[1]Securities Worksheet 1'!AC37)","v":0},null,{"$f":"SUM(H37:K37)","v":0},{"$f":"SUM(L37:O37)","v":0},{"$f":"SUM(G37,H37:K37,L37:O37)","v":0}]
[{"$f":"A37+1","v":28},"Total Securities",null,{"$f":"\"Sum of items \"&A36&\" and \"&A37","v":"Sum of items 26 and 27"},null,null,{"$f":"SUM(G36:G37)","v":0},0,0,0,0,{"$f":"SUM(L36:L37)","v":0},0,0,0,null,{"$f":"SUM(H38:K38)","v":0},{"$f":"SUM(L38:O38)","v":0},{"$f":"SUM(G38,H38:K38,L38:O38)","v":0}]
[]
[null,"TRADING ACCOUNT"]
[{"$f":"A38+1","v":29},"Trading MTM Losses",null,"Match 9-Quarter Sum with Trading Worksheet Item 9",{"$nulls":12},{"$f":"SUM(H41:K41)","v":0},{"$f":"SUM(L41:O41)","v":0},{"$f":"SUM(G41,H41:K41,L41:O41)","v":0}]
[{"$f":"A41+1","v":30},"Trading Incremental Default Losses",null,"Match 9-Quarter Sum with Counterparty Risk Worksheet Item 4",{"$nulls":12},{"$f":"SUM(H42:K42)","v":0},{"$f":"SUM(L42:O42)","v":0},{"$f":"SUM(G42,H42:K42,L42:O42)","v":0}]
[{"$f":"A42+1","v":31},"Counterparty Credit MTM Losses",null,"Match 9-Quarter Sum with Counterparty Risk Worksheet Item 1",{"$nulls":12},{"$f":"SUM(H43:K43)","v":0},{"$f":"SUM(L43:O43)","v":0},{"$f":"SUM(G43,H43:K43,L43:O43)","v":0}]
[{"$f":"A43+1","v":32},"Counterparty Incremental Default Losses",null,"Match 9-Quarter Sum with Counterparty Risk Worksheet Item 2",{"$nulls":12},{"$f":"SUM(H44:K44)","v":0},{"$f":"SUM(L44:O44)","v":0},{"$f":"SUM(G44,H44:K44,L44:O44)","v":0}]
[{"$f":"A44+1","v":33},"Total Trading and Counterparty",null,{"$f":"\"Sum of items \"&A41&\", \"&A42&\", \"&A43&\", and \"&A44","v":"Sum of items 29, 30, 31, and 32"},null,{"$f":"SUM(F41:F44)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H45:K45)","v":0},{"$f":"SUM(L45:O45)","v":0},{"$f":"SUM(G45,H45:K45,L45:O45)","v":0}]
[]
[null,"OTHER LOSSES"]
[{"$f":"A45+1","v":34},"Other losses (describe in supporting documentation)",{"$nulls":14},{"$f":"SUM(H48:K48)","v":0},{"$f":"SUM(L48:O48)","v":0},{"$f":"SUM(G48,H48:K48,L48:O48)","v":0}]
[]
[{"$f":"A48+1","v":35},"Total Losses",null,{"$f":"\"Sum of items \"&A30&\", \"&A33&\", \"&A38&\", \"&A45&\", and \"&A48","v":"Sum of items 24, 25, 28, 33, and 34"},null,{"$f":"SUM(F30,F33,F38,F45,F48)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H50:K50)","v":0},{"$f":"SUM(L50:O50)","v":0},{"$f":"SUM(G50,H50:K50,L50:O50)","v":0}]
[]
[null,"ALLOWANCE FOR LOAN and LEASE LOSSES"]
[{"$f":"A50+1","v":36},"ALLL, prior quarter","is_alllprev",{"$nulls":3},{"$f":"F57","v":0},{"$f":"G57","v":0},0,0,0,0,0,0,0]
[{"$f":"A53+1","v":37},"Provisions during the quarter","is_provision","riad4230",{"$nulls":12},{"$f":"SUM(H54:K54)","v":0},{"$f":"SUM(L54:O54)","v":0},{"$f":"SUM(G54,H54:K54,L54:O54)","v":0}]
[{"$f":"A54+1","v":38},"Net charge-offs during the quarter",null,{"$f":"\"Item \"&A30","v":"Item 24"},null,{"$f":"F30","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H55:K55)","v":0},{"$f":"SUM(L55:O55)","v":0},{"$f":"SUM(G55,H55:K55,L55:O55)","v":0}]
[{"$f":"A55+1","v":39},"Other ALLL Changes",null,"riadc233 less riad5523",null,{"$f":"F57-(F53+F54-F55)","v":0},{"$nulls":10},{"$f":"SUM(H56:K56)","v":0},{"$f":"SUM(L56:O56)","v":0},{"$f":"SUM(G56,H56:K56,L56:O56)","v":0}]
[{"$f":"A56+1","v":40},"ALLL, current quarter","is_alll",{"$f":"\"Items \"&A53&\" and \"&A54&\" less item \"&A55&\" = riad3123\"","v":"Items 36 and 37 less item 38 = riad3123"},null,null,{"$f":"SUM(G53:G54,G56)-G55","v":0},{"$f":"SUM(H53:H54,H56)-H55","v":0},0,0,0,0,0,0,0]
[]
[null,"PRE-PROVISION NET REVENUE"]
[{"$f":"A57+1","v":41},"Net interest income","is_netintinc","PPNR Projections Worksheet Item11",null,null,{"$f":"'[1]PPNR Projections Worksheet'!F27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!G27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!H27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!I27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!J27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!K27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!L27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!M27","v":0},{"$f":"'[1]PPNR Projections Worksheet'!N27","v":0},null,{"$f":"SUM(H60:K60)","v":0},{"$f":"SUM(L60:O60)","v":0},{"$f":"SUM(G60,H60:K60,L60:O60)","v":0}]
[{"$f":"A60+1","v":42},"Noninterest income","is_nonintinc","PPNR Projections Worksheet Item 22",null,null,{"$f":"'[1]PPNR Projections Worksheet'!F61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!G61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!H61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!I61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!J61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!K61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!L61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!M61","v":0},{"$f":"'[1]PPNR Projections Worksheet'!N61","v":0},null,{"$f":"SUM(H61:K61)","v":0},{"$f":"SUM(L61:O61)","v":0},{"$f":"SUM(G61,H61:K61,L61:O61)","v":0}]
[{"$f":"A61+1","v":43},"Noninterest expense","is_nonintexp","PPNR Projections Worksheet Item 31",null,null,{"$f":"'[1]PPNR Projections Worksheet'!F80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!G80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!H80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!I80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!J80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!K80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!L80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!M80","v":0},{"$f":"'[1]PPNR Projections Worksheet'!N80","v":0},null,{"$f":"SUM(H62:K62)","v":0},{"$f":"SUM(L62:O62)","v":0},{"$f":"SUM(G62,H62:K62,L62:O62)","v":0}]
[{"$f":"A62+1","v":44},"Pre-Provision Net Revenue",null,{"$f":"\"Items \"&A60&\" and \"&A61&\" less item \"&A62","v":"Items 41 and 42 less item 43"},null,{"$f":"SUM(F60:F61)-F62","v":0},{"$f":"SUM(G60:G61)-G62","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(H63:K63)","v":0},{"$f":"SUM(L63:O63)","v":0},{"$f":"SUM(G63,H63:K63,L63:O63)","v":0}]
[]
[null,"CONDENSED INCOME STATEMENT"]
[{"$f":"A63+1","v":45},"Pre-Provision Net Revenue",null,{"$f":"\"Item \"&A63","v":"Item 44"},null,{"$f":"F63","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H66:K66)","v":0},{"$f":"SUM(L66:O66)","v":0},{"$f":"SUM(G66,H66:K66,L66:O66)","v":0}]
[{"$f":"A66+1","v":46},"Provisions during the quarter",null,{"$f":"\"Item \"&A54&\" = riad4230\"","v":"Item 37 = riad4230"},null,{"$f":"F54","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0]
[47,"Total Trading and Counterparty",null,{"$f":"\"Item \"&A45","v":"Item 33"},null,{"$f":"F45","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0]
[48,"Other Losses, including goodwill impairment and fair value adjustment for firm's own debt. (Describe in supporting documentation)",null,{"$f":"\"Item \"&A48","v":"Item 34"},null,{"$f":"F48","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0]
[49,"One time income and (expense) items not included in PPNR",null,"PPNR Projections Worksheet, Item 36 minus Item 37",null,null,{"$f":"'[1]PPNR Projections Worksheet'!F87-'[1]PPNR Projections Worksheet'!F88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!G87-'[1]PPNR Projections Worksheet'!G88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!H87-'[1]PPNR Projections Worksheet'!H88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!I87-'[1]PPNR Projections Worksheet'!I88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!J87-'[1]PPNR Projections Worksheet'!J88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!K87-'[1]PPNR Projections Worksheet'!K88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!L87-'[1]PPNR Projections Worksheet'!L88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!M87-'[1]PPNR Projections Worksheet'!M88","v":0},{"$f":"'[1]PPNR Projections Worksheet'!N87-'[1]PPNR Projections Worksheet'!N88","v":0},null,0,0,0]
[50,"Realized Gains (Losses) on held-to-maturity securities","is_htm","riad3521",{"$nulls":12},0,0,0]
[51,"Realized Gains (Losses) on available-for-sale securities","is_afs","riad3196",{"$nulls":12},0,0,0]
[52,"Memo: Provision for unfunded off-balance sheet credit exposures",null,"To build/decrease Item 47 (rconb557) in Balance Sheet."]
[{"$f":"A73+1","v":53},"Income (loss) before taxes and extraordinary items","is_pretaxextrainc",{"$f":"\"Sum of items \"&A66&\", \"&A70&\", \"&A71&\", and \"&A72&\", less items \"&A67&\", \"&A68&\", and \"&A69&\" =riad4301\"","v":"Sum of items 45, 49, 50, and 51, less items 46, 47, and 48 =riad4301"},null,null,{"$f":"SUM(G66,G70,G71,G72)-SUM(G67:G69)","v":0},{"$f":"SUM(H66,H70,H71,H72)-SUM(H67:H69)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(H74:K74)","v":0},{"$f":"SUM(L74:O74)","v":0},{"$f":"SUM(G74,H74:K74,L74:O74)","v":0}]
[]
[{"$f":"A74+1","v":54},"Applicable income taxes (foreign and domestic)","is_taxes","riad4302",{"$nulls":12},{"$f":"SUM(H76:K76)","v":0},{"$f":"SUM(L76:O76)","v":0},{"$f":"SUM(G76,H76:K76,L76:O76)","v":0}]
[{"$f":"A76+1","v":55},"Income (loss) before extraordinary items and other adjustments","is_preextrainc",{"$f":"\"Item \"&A74&\" less item \"&A76&\" =riad4300\"","v":"Item 53 less item 54 =riad4300"},null,null,{"$f":"G74-G76","v":0},{"$f":"H74-H76","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(H77:K77)","v":0},{"$f":"SUM(L77:O77)","v":0},{"$f":"SUM(G77,H77:K77,L77:O77)","v":0}]
[]
[{"$f":"A77+1","v":56},"Extraordinary items and other adjustments, net of income taxes","is_extra","riad4320",{"$nulls":12},{"$f":"SUM(H79:K79)","v":0},{"$f":"SUM(L79:O79)","v":0},{"$f":"SUM(G79,H79:K79,L79:O79)","v":0}]
[{"$f":"A79+1","v":57},"Net income (loss) attributable to bank and minority interests","is_minornetinc",{"$f":"\"Sum of items \"&A77&\" and \"&A79&\" = riadg104\"","v":"Sum of items 55 and 56 = riadg104"},null,null,{"$f":"SUM(G77,G79)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(H80:K80)","v":0},{"$f":"SUM(L80:O80)","v":0},{"$f":"SUM(G80,H80:K80,L80:O80)","v":0}]
[]
[{"$f":"A80+1","v":58},"Net income (loss) attributable to minority interests","is_minorinc","riadg103",{"$nulls":12},{"$f":"SUM(H82:K82)","v":0},{"$f":"SUM(L82:O82)","v":0},{"$f":"SUM(G82,H82:K82,L82:O82)","v":0}]
[{"$f":"A82+1","v":59},"Net income (loss) attributable to bank","is_netinc","Item 57 less item 58 = riad4340 (must match item 4 on the Capital Worksheet)",null,null,{"$f":"G80-G82","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(H83:K83)","v":0},{"$f":"SUM(L83:O83)","v":0},{"$f":"SUM(G83,H83:K83,L83:O83)","v":0}]
[]
[{"$f":"A83+1","v":60},"Effective Tax Rate (%)",null,{"$f":"\"Item \"&A76&\" divided by item \"&A77&\", multiplied by 100\"","v":"Item 54 divided by item 55, multiplied by 100"},null,{"$f":"IFERROR(F76/F77*100,\"-na-\")","v":"-na-"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,{"$f":"IFERROR(Q76/Q77*100,\"-na-\")","v":{"$error":"#NAME?"}},{"$f":"IFERROR(R76/R77*100,\"-na-\")","v":{"$error":"#NAME?"}},{"$f":"IFERROR(S76/S77*100,\"-na-\")","v":{"$error":"#NAME?"}}]
[]
[null,"REPURCHASE RESERVE/LIABILITY FOR REPS AND WARRANTIES"]
[{"$f":"A85+1","v":61},"Reserve, prior quarter",{"$nulls":14},{"$f":"SUM(H88:K88)","v":0},{"$f":"SUM(L88:O88)","v":0},{"$f":"SUM(G88,H88:K88,L88:O88)","v":0}]
[{"$f":"A88+1","v":62},"Provisions during the quarter (included in PPNR or other revenue)",{"$nulls":14},{"$f":"SUM(H89:K89)","v":0},{"$f":"SUM(L89:O89)","v":0},{"$f":"SUM(G89,H89:K89,L89:O89)","v":0}]
[{"$f":"A89+1","v":63},"Net charges during the quarter",{"$nulls":14},{"$f":"SUM(H90:K90)","v":0},{"$f":"SUM(L90:O90)","v":0},{"$f":"SUM(G90,H90:K90,L90:O90)","v":0}]
[{"$f":"A90+1","v":64},"Reserve, current quarter",null,{"$f":"\"Items \"&A88&\" and \"&A89&\" less item \"&A90","v":"Items 61 and 62 less item 63"},null,{"$f":"F88+F89-F90","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H91:K91)","v":0},{"$f":"SUM(L91:O91)","v":0},{"$f":"SUM(G91,H91:K91,L91:O91)","v":0}]
[]
[{"$f":"A91+1","v":65},"Line item of PPNR Submission Worksheet where repurchase provision is recorded"]
[]
[]
[]
[null,"The following cells provide checks of the internal consistency of the projected capital schedules.  Please ensure that these cells are all \"TRUE\" before the worksheet is submitted."]
[null,"Second / Junior Lien Mortgages",{"$nulls":4},{"$f":"G8=SUM('[1]Retail Loss Projections'!C8,'[1]Retail Loss Projections'!C13)","v":true},{"$f":"H8=SUM('[1]Retail Loss Projections'!D8,'[1]Retail Loss Projections'!D13)","v":true},{"$f":"I8=SUM('[1]Retail Loss Projections'!E8,'[1]Retail Loss Projections'!E13)","v":true},{"$f":"J8=SUM('[1]Retail Loss Projections'!F8,'[1]Retail Loss Projections'!F13)","v":true},{"$f":"K8=SUM('[1]Retail Loss Projections'!G8,'[1]Retail Loss Projections'!G13)","v":true},{"$f":"L8=SUM('[1]Retail Loss Projections'!H8,'[1]Retail Loss Projections'!H13)","v":true},{"$f":"M8=SUM('[1]Retail Loss Projections'!I8,'[1]Retail Loss Projections'!I13)","v":true},{"$f":"N8=SUM('[1]Retail Loss Projections'!J8,'[1]Retail Loss Projections'!J13)","v":true}," "]
[null,"Trading MTM Losses",{"$nulls":16},{"$f":"S41='[1]Trading Worksheet'!C14","v":true}]
[null,"Trading Incremental Default Losses",{"$nulls":16},{"$f":"S42='[1]Counterparty Risk Worksheet'!C9","v":true}]
[null,"Counterparty Credit MTM Losses",{"$nulls":16},{"$f":"S43='[1]Counterparty Risk Worksheet'!C4","v":true}]
[null,"Counterparty Incremental Default Losses",{"$nulls":16},{"$f":"S44='[1]Counterparty Risk Worksheet'!C6","v":true}]
[null,"Net income attributable to bank",{"$nulls":3},{"$f":"F83='Capital Worksheet'!F10","v":true},{"$f":"G83='Capital Worksheet'!G10","v":true},{"$f":"H83='Capital Worksheet'!H10","v":true},{"$f":"I83='Capital Worksheet'!I10","v":true},{"$f":"J83='Capital Worksheet'!J10","v":true},{"$f":"K83='Capital Worksheet'!K10","v":true},{"$f":"L83='Capital Worksheet'!L10","v":true},{"$f":"M83='Capital Worksheet'!M10","v":true},{"$f":"N83='Capital Worksheet'!N10","v":true},{"$f":"O83='Capital Worksheet'!O10","v":true},{"$f":"P83='Capital Worksheet'!P10","v":true},{"$f":"Q83='Capital Worksheet'!Q10","v":true},{"$f":"R83='Capital Worksheet'!R10","v":true},{"$f":"S83='Capital Worksheet'!S10","v":true}]
{"$rows_empty":17}
[null,"Other Non-Interest Expense"]
[null,"Non-Interest Income - Retail and Small Business"]
[null,"Non-Interest Income - Commercial Lending"]
[null,"Non-Interest Income - Investment Banking"]
[null,"Non-Interest Income - Sales and Trading"]
[null,"Non-Interest Income - Investment Management"]
[null,"Non-Interest Income - Investment Services"]
[null,"Non-Interest Income - Treasury Services"]
[null,"Non-Interest Income - Insurance Services"]
[null,"Non-Interest Income - Retirement / Corporate Benefits Products"]
[null,"Non-Interest Income - Corporate / Other"]
[null,"Operational Risk Expense"]
[null,"Litigation and Penalties Expense"]
[null,"Professional and Outside Service Expense"]
[null,"Other: Provide Explanation in the Memo"]
[null,"N/A"]

{"sheet":"Balance Sheet Worksheet","index":2,"n_rows":92,"n_cols":15,"rows_kept":92,"merged":[[0,0,0,14],[1,0,1,14],[2,6,2,14],[5,0,5,14],[61,0,61,14],[70,0,70,14],[83,0,83,14]]}
[{"$f":"'Summary Submission Cover Sheet'!D15&\" Balance Sheet Worksheet: \"&'Summary Submission Cover Sheet'!D12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Balance Sheet Worksheet:  in Baseline"}]
[{"$f":"IF('[1]Summary Submission Cover Sheet'!D16=\"\",\"\",'[1]Summary Submission Cover Sheet'!D16)","v":""}]
[{"$nulls":5},"Actual in $Millions","Projected in $Millions"]
["Item",null,null,"Notes",null,"Q3 2012","Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014"]
[]
["Assets"]
[]
[null,"SECURITIES"]
[{"$f":"A8+1","v":1},"Held to Maturity (HTM)","bs_htm","riad1754"]
[{"$f":"A9+1","v":2},"Available for Sale (AFS)","bs_afs","riad1773"]
[{"$f":"A10+1","v":3},"Total Securities",null,{"$f":"\"Sum of items \"&A9&\" and \"&A10","v":"Sum of items 1 and 2"},null,null,{"$f":"SUM(G9:G10)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"LOANS"]
[{"$f":"A11+1","v":4},"Real Estate Loans","bs_lnre",{"$f":"\"Sum of items \"&A15&\", \"&A16&\", \"&A19&\", \"&A24&\", and \"&A25&\" = rcfd1410\"","v":"Sum of items 5, 6, 9, 14, and 15 = rcfd1410"},null,null,{"$f":"SUM(G15,G16,G19,G24,G25)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"A14+1","v":5},"First Lien Mortgages (In Domestic Offices)","bs_first","rcon5367",null,null,{"$f":"SUM('[1]Retail Balance Projections'!C6,'[1]Retail Balance Projections'!C12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!D6,'[1]Retail Balance Projections'!D12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!E6,'[1]Retail Balance Projections'!E12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!F6,'[1]Retail Balance Projections'!F12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!G6,'[1]Retail Balance Projections'!G12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!H6,'[1]Retail Balance Projections'!H12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!I6,'[1]Retail Balance Projections'!I12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!J6,'[1]Retail Balance Projections'!J12)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!K6,'[1]Retail Balance Projections'!K12)","v":0}]
[6,"Second / Junior Lien Mortgages (In Domestic Offices)",null,{"$f":"\"Sum of items \"&A17&\" and \"&A18","v":"Sum of items 7 and 8"},null,null,{"$f":"SUM(G17:G18)","v":0},0,0,0,0,0,0,0,0]
[7,"Closed-End Junior Liens","bs_closed","rcon5368",null,null,{"$f":"'[1]Retail Balance Projections'!C18","v":0},{"$f":"'[1]Retail Balance Projections'!D18","v":0},{"$f":"'[1]Retail Balance Projections'!E18","v":0},{"$f":"'[1]Retail Balance Projections'!F18","v":0},{"$f":"'[1]Retail Balance Projections'!G18","v":0},{"$f":"'[1]Retail Balance Projections'!H18","v":0},{"$f":"'[1]Retail Balance Projections'!I18","v":0},{"$f":"'[1]Retail Balance Projections'!J18","v":0},{"$f":"'[1]Retail Balance Projections'!K18","v":0}]
[8,"HELOCs","bs_heloc","rcon1797",null,null,{"$f":"'[1]Retail Balance Projections'!C24","v":0},{"$f":"'[1]Retail Balance Projections'!D24","v":0},{"$f":"'[1]Retail Balance Projections'!E24","v":0},{"$f":"'[1]Retail Balance Projections'!F24","v":0},{"$f":"'[1]Retail Balance Projections'!G24","v":0},{"$f":"'[1]Retail Balance Projections'!H24","v":0},{"$f":"'[1]Retail Balance Projections'!I24","v":0},{"$f":"'[1]Retail Balance Projections'!J24","v":0},{"$f":"'[1]Retail Balance Projections'!K24","v":0}]
[9,"CRE Loans (In Domestic Offices)",null,{"$f":"\"Sum of items \"&A20&\" to \"&A22","v":"Sum of items 10 to 12"},null,null,{"$f":"SUM(G20:G22)","v":0},0,0,0,0,0,0,0,0]
[10,"Construction","bs_const","rconf158 + rconf159"]
[11,"Multifamily","bs_multi","rcon1460"]
[12,"Nonfarm, Non-residential","bs_nfnr","rconf160 + rconf161"]
[13,"Owner-Occupied","bs_nfnr_ownocc","rconf160"]
[14,"Loans Secured by Farmland (In Domestic Offices)","bs_farm","rcon1420"]
[15,"Real Estate Loans Not in Domestic Offices","bs_fgnre",{"$f":"\"rcfd1410 less items \"&A15&\", \"&A16&\", \"&A19&\", and \"&A24","v":"rcfd1410 less items 5, 6, 9, and 14"}]
[16,"C&I Loans",null,{"$f":"\"Sum of items \"&A27&\" to \"&A29","v":"Sum of items 17 to 19"},null,{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":0},0,{"$f":"SUM(I27:I29)","v":0},0,0,0,0,0,0]
[17,"Large Commercial Credits"]
[18,"Small Business (Graded)"]
[19,"Small Business (Scored/Delinquency Managed)",{"$nulls":4},{"$f":"SUM('[1]Retail Balance Projections'!C72,'[1]Retail Balance Projections'!C78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!D72,'[1]Retail Balance Projections'!D78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!E72,'[1]Retail Balance Projections'!E78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!F72,'[1]Retail Balance Projections'!F78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!G72,'[1]Retail Balance Projections'!G78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!H72,'[1]Retail Balance Projections'!H78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!I72,'[1]Retail Balance Projections'!I78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!J72,'[1]Retail Balance Projections'!J78)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!K72,'[1]Retail Balance Projections'!K78)","v":0}]
[20,"Credit Cards","bs_cards","rcfdb538",null,null,{"$f":"SUM('[1]Retail Balance Projections'!C42,'[1]Retail Balance Projections'!C48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!D42,'[1]Retail Balance Projections'!D48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!E42,'[1]Retail Balance Projections'!E48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!F42,'[1]Retail Balance Projections'!F48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!G42,'[1]Retail Balance Projections'!G48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!H42,'[1]Retail Balance Projections'!H48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!I42,'[1]Retail Balance Projections'!I48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!J42,'[1]Retail Balance Projections'!J48)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!K42,'[1]Retail Balance Projections'!K48)","v":0}]
[21,"Other Consumer",null,{"$f":"\"Sum of items \"&A32&\" to \"&A34","v":"Sum of items 22 to 24"},null,null,{"$f":"SUM(G32:G34)","v":0},0,0,0,0,0,0,0,0]
[22,"Auto Loans","bs_auto","rcfdk137",null,null,{"$f":"SUM('[1]Retail Balance Projections'!C54,'[1]Retail Balance Projections'!C60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!D54,'[1]Retail Balance Projections'!D60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!E54,'[1]Retail Balance Projections'!E60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!F54,'[1]Retail Balance Projections'!F60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!G54,'[1]Retail Balance Projections'!G60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!H54,'[1]Retail Balance Projections'!H60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!I54,'[1]Retail Balance Projections'!I60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!J54,'[1]Retail Balance Projections'!J60)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!K54,'[1]Retail Balance Projections'!K60)","v":0}]
[23,"Student Loans",{"$nulls":4},{"$f":"'[1]Retail Balance Projections'!C66","v":0},{"$f":"'[1]Retail Balance Projections'!D66","v":0},{"$f":"'[1]Retail Balance Projections'!E66","v":0},{"$f":"'[1]Retail Balance Projections'!F66","v":0},{"$f":"'[1]Retail Balance Projections'!G66","v":0},{"$f":"'[1]Retail Balance Projections'!H66","v":0},{"$f":"'[1]Retail Balance Projections'!I66","v":0},{"$f":"'[1]Retail Balance Projections'!J66","v":0},{"$f":"'[1]Retail Balance Projections'!K66","v":0}]
[24,"Other ",null,"Include rcfdf162",null,null,{"$f":"SUM('[1]Retail Balance Projections'!C84,'[1]Retail Balance Projections'!C90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!D84,'[1]Retail Balance Projections'!D90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!E84,'[1]Retail Balance Projections'!E90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!F84,'[1]Retail Balance Projections'!F90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!G84,'[1]Retail Balance Projections'!G90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!H84,'[1]Retail Balance Projections'!H90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!I84,'[1]Retail Balance Projections'!I90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!J84,'[1]Retail Balance Projections'!J90)","v":0},{"$f":"SUM('[1]Retail Balance Projections'!K84,'[1]Retail Balance Projections'!K90)","v":0}]
[25,"Other Loans",null,{"$f":"\"Sum of items \"&A36&\" to \"&A41","v":"Sum of items 26 to 31"},null,null,{"$f":"SUM(G36:G41)","v":0},0,0,0,0,0,0,0,0]
[26,"Loans to Foreign Governments","bs_fgngov","rcfd2081"]
[27,"Agricultural Loans","bs_agric","rcfd590"]
[28,"Obligations of states and political subdivisions",null,"rcfd2107"]
[29,"Securities Lending","bs_seclend","rcon1545"]
[30,"Loans to nondepository financial institutions","bs_dep","rconj454"]
[31,"All Other Loans and Leases","bs_othoth","rconj451 + rcon2165 + rconf163"]
[32,"Total Loans and Leases","bs_total_loans",{"$f":"\"Sum of items \"&A14&\", \"&A26&\", \"&A30&\", \"&A31&\", and \"&A35","v":"Sum of items 4, 16, 20, 21, and 25"},null,null,{"$f":"SUM(G14,G26,G30,G31,G35)","v":0},0,0,0,0,0,0,0,0]
[]
[{"$f":"A42+1","v":33},"Unearned Income on Loans","bs_unearnedinc","rcfd2123"]
[{"$f":"A44+1","v":34},"Allowance for Loan and Lease Losses","bs_alll","rcfd3123"]
[{"$f":"A45+1","v":35},"Loans and Leases (Held for Investment and Held for Sale), Net of Unearned Income and Allowance for Loan and Lease Losses ","bs_loans_net",{"$f":"\"Item \"&A42&\" less items \"&A44&\" and \"& A45&\" = rcfd5369 + rcfdb529\"","v":"Item 32 less items 33 and 34 = rcfd5369 + rcfdb529"},null,null,{"$f":"G42-G44-G45","v":0},0,0,0,0,0,0,0,0]
[]
[null,"TRADING"]
[{"$f":"A46+1","v":36},"Trading Assets","bs_trading","rcfd3545"]
[]
[null,"INTANGIBLES"]
[{"$f":"A49+1","v":37},"Goodwill","bs_goodwill","rcfd3163"]
[{"$f":"A52+1","v":38},"Mortgage Servicing Rights","bs_msr","rcfd3164"]
[{"$f":"A53+1","v":39},"Purchased Credit Card Relationships and Nonmortgage Servicing Rights","bs_pccr","rcfdb026"]
[{"$f":"A54+1","v":40},"All Other Identifiable Intangible Assets","bs_othintang","rcfd5507"]
[{"$f":"A55+1","v":41},"Total Intangible Assets","bs_intang",{"$f":"\"Sum of items \"&A52&\" to \"&A55","v":"Sum of items 37 to 40"},null,null,{"$f":"SUM(G52:G55)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"OTHER"]
[{"$f":"A56+1","v":42},"Other Assets","bs_othass","rcfd0081 + rcfd0395 + rcfd0397 + rconb987 + rcfdb989 + rcfd2145 + rcfd2150 + rcfd2130 + rcfd3656 + rcfd2160"]
[{"$f":"A59+1","v":43},"Total Assets","bs_total_assets",{"$f":"\"Sum of items \"&A11&\", \"&A46&\", \"&A49&\", \"&A56&\", and \"&A59&\" = rcfd2170\"","v":"Sum of items 3, 35, 36, 41, and 42 = rcfd2170"},null,null,{"$f":"SUM(G11,G46,G49,G56,G59)","v":0},0,0,0,0,0,0,0,0]
[]
["Liabilities"]
[]
[{"$f":"A60+1","v":44},"Deposits","bs_deposits","rcon6631 + rcon6636 + rcfn6631 + rcfn6636"]
[{"$f":"A64+1","v":45},"Trading Liabilities","bs_tradliab","rcfd548"]
[{"$f":"A65+1","v":46},"Subordinated Notes Payable to Unconsolidated Trusts Issuing TruPS and TruPS Issued by Consolidated Special Purpose Entities","bs_subnote","bhckc699"]
[{"$f":"A66+1","v":47},"Other Liabilities","bs_othliab","rconb993 + rcfdb995 + rcfd3190 "]
[{"$f":"A67+1","v":48},"Memo: Allowance for off-balance sheet credit exposures","bs_obs_allowance","rconb557"]
[{"$f":"A68+1","v":49},"Total Liabilities","bs_total_liab",{"$f":"\"Sum of items \"&A64&\" to \"&A67&\" = rcfd2948\"","v":"Sum of items 44 to 47 = rcfd2948"},null,null,{"$f":"SUM(G64:G67)","v":0},0,0,0,0,0,0,0,0]
[]
["Equity Capital"]
[]
[{"$f":"A69+1","v":50},"Perpetual Preferred Stock and Related Surplus","bs_pref","rcfd3838"]
[{"$f":"A73+1","v":51},"Common Stock (Par Value)","bs_common","rcfd3230"]
[52,"Surplus (Exclude All Surplus Related to Preferred Stock)","bs_surplus","rcfd3839"]
[53,"Retained Earnings","bs_re","rcfd3632"]
[54,"Accumulated Other Comprehensive Income (AOCI)","bs_aoci","rcfdb530"]
[55,"Other Equity Capital Components","bs_othequity","rcfda130"]
[56,"Total Bank Equity Capital","bs_bhc_equity",{"$f":"\"Sum of items \"&A73&\" to \"&A78&\" = rcfd3210\"&\" (must equal item 12 of the RI-A section on the Capital Worksheet)\"","v":"Sum of items 50 to 55 = rcfd3210 (must equal item 12 of the RI-A section on the Capital Worksheet)"},null,null,{"$f":"SUM(G73:G78)","v":0},0,0,0,0,0,0,0,0]
[]
[{"$f":"A79+1","v":57},"Noncontrolling (Minority) Interests in Consolidated Subsidiaries","bs_minorint","rcfd3000"]
[{"$f":"A81+1","v":58},"Total Equity Capital","bs_total_equity",{"$f":"\"Sum of items \"&A79&\" and \"&A81&\" = rcfdg105\"","v":"Sum of items 56 and 57 = rcfdg105"},null,null,{"$f":"SUM(G79,G81)","v":0},0,0,0,0,0,0,0,0]
[]
["Other"]
[]
[{"$f":"A82+1","v":59},"Unused Commercial Lending Commitments and Letters of Credit","bs_commit","rcfd164 + rcfdf165 + rcfd457 + rcfdj458 + rcfdj459 + rcfd3819 + rcfd3821 + rcfd3411"]
[]
[]
[]
[null,"The following cells provide checks of the internal consistency of the projected schedules.  Please ensure that these cells are all \"TRUE\" before the worksheet is submitted."]
[null,"Bank Equity Capital",{"$nulls":3},{"$f":"F79='Capital Worksheet'!F23","v":true},{"$f":"G79='Capital Worksheet'!G23","v":{"$error":"#REF!"}},{"$f":"H79='Capital Worksheet'!H23","v":{"$error":"#REF!"}},{"$f":"I79='Capital Worksheet'!I23","v":{"$error":"#REF!"}},{"$f":"J79='Capital Worksheet'!J23","v":{"$error":"#REF!"}},{"$f":"K79='Capital Worksheet'!K23","v":{"$error":"#REF!"}},{"$f":"L79='Capital Worksheet'!L23","v":{"$error":"#REF!"}},{"$f":"M79='Capital Worksheet'!M23","v":{"$error":"#REF!"}},{"$f":"N79='Capital Worksheet'!N23","v":{"$error":"#REF!"}},{"$f":"O79='Capital Worksheet'!O23","v":{"$error":"#REF!"}}]
[null,"Balance Sheet",null,"Check Formula:",null,{"$f":"F60=F69+F82","v":true},true,true,true,true,true,true,true,true,true]

{"sheet":"Capital Worksheet","index":3,"n_rows":144,"n_cols":19,"rows_kept":144,"merged":[[0,0,0,18],[1,0,1,18],[2,6,2,14],[2,16,2,18],[108,1,111,16],[114,1,117,16],[119,1,119,16],[131,1,134,16]]}
[{"$f":"'Summary Submission Cover Sheet'!D15&\" Capital Worksheet: \"&'Summary Submission Cover Sheet'!D12&\" in \"&'Summary Submission Cover Sheet'!$B$20","v":"Bank Capital Worksheet:  in Baseline"}]
[{"$f":"IF('[1]Summary Submission Cover Sheet'!D16=\"\",\"\",'[1]Summary Submission Cover Sheet'!D16)","v":""}]
[{"$nulls":5},"Actual in $Millions","Projected in $Millions",{"$nulls":9},"Sums in $Millions"]
["Item",null,null,"Notes",null,"Q3 2012","Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014",null,2013,2014,"9-Quarter"]
[]
[null,"Schedule HI-A—Changes in Bank Holding Company Equity Capital"]
[1,"Total bank equity capital most recently reported for the end of previous QUARTER","rk_equityprev","riad3217",null,null,{"$f":"F19","v":0},{"$f":"G19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"H7","v":{"$error":"#REF!"}},{"$f":"L7","v":{"$error":"#REF!"}},{"$f":"G7","v":0}]
[{"$f":"A7+1","v":2},"Effect of changes in accounting principles and corrections of material accounting errors","rk_acctchanges","riadb507",{"$nulls":12},{"$f":"H8","v":0},{"$f":"L8","v":0},{"$f":"G8","v":0}]
[{"$f":"A8+1","v":3},"Balance end of previous QUARTER as restated (sum of items 1 and 2)","rk_equityrestatedprev","riadb508",null,null,{"$f":"SUM(G7:G8)","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"H9","v":{"$error":"#REF!"}},{"$f":"L9","v":{"$error":"#REF!"}},{"$f":"G9","v":0}]
[4,"Net income (loss) attributable to bank ","rk_netinc",{"$f":"\"Must match item \"&'Income Statement Worksheet'!A83&\" on the Income Statement Worksheet = riad4340\"","v":"Must match item 59 on the Income Statement Worksheet = riad4340"},{"$nulls":12},{"$f":"SUM(H10:K10)","v":0},{"$f":"SUM(L10:O10)","v":0},{"$f":"SUM(G10,H10:K10,L10:O10)","v":0}]
[5,"Sale, conversion, acquisition, or retirement of capital stock, net (excluding treasury stock transactions)","rk_treassale","riad509",{"$nulls":12},{"$f":"SUM(H11:K11)","v":0},{"$f":"SUM(L11:O11)","v":0},{"$f":"SUM(G11,H11:K11,L11:O11)","v":0}]
[6,"Treasury stock transactions, net","rk_treaspurch","riadb510",{"$nulls":12},0,0,0]
[7,"Changes incident to business combinations, net","rk_combo_net","riad4356",{"$nulls":12},0,0,0]
[8,"Cash dividends declared on preferred stock","rk_prefdiv","riad4470",{"$nulls":12},0,0,0]
[9,"Cash dividends declared on common stock","rk_commondiv","riad44760",{"$nulls":12},0,0,0]
[10,"Other comprehensive income","rk_aoci","riadb511",{"$nulls":12},0,0,0]
[11,"Change in the offsetting debit to the liability for Employee Stock Ownership Plan (ESOP) debt guaranteed by the bank holding company","rk_esopliab","bhck4591",{"$nulls":12},0,0,0]
[12,"Other transactions with parent holding company (not included above)","rk_othadj","riad4415",{"$nulls":12},0,0,0]
[13,{"$f":"\"Total bank equity capital end of current period (sum of items \"&A9&\", \"&A10&\", \"&A11&\", \"&A13&\", \"&A16&\", \"&A17&\", \"&A18&\", less items \"&A12&\", \"&A14&\", \"&A15&\")\"","v":"Total bank equity capital end of current period (sum of items 3, 4, 5, 7, 10, 11, 12, less items 6, 8, 9)"},"rk_equitycurr",{"$f":"\"Must match item \"&'Balance Sheet Worksheet'!A78&\" on the Balance Sheet Worksheet = riad3210\"","v":"Must match item 55 on the Balance Sheet Worksheet = riad3210"},null,null,{"$f":"SUM(G9,G10,#REF!,#REF!,#REF!,#REF!,G11,G13,G16,G17,G18)-SUM(G12,G14,G15)","v":{"$error":"#REF!"}},{"$f":"SUM(H9,H10,#REF!,#REF!,#REF!,#REF!,H11,H13,H16,H17,H18)-SUM(H12,H14,H15)","v":{"$error":"#REF!"}},{"$f":"SUM(I9,I10,#REF!,#REF!,#REF!,#REF!,I11,I13,I16,I17,I18)-SUM(I12,I14,I15)","v":{"$error":"#REF!"}},{"$f":"SUM(J9,J10,#REF!,#REF!,#REF!,#REF!,J11,J13,J16,J17,J18)-SUM(J12,J14,J15)","v":{"$error":"#REF!"}},{"$f":"SUM(K9,K10,#REF!,#REF!,#REF!,#REF!,K11,K13,K16,K17,K18)-SUM(K12,K14,K15)","v":{"$error":"#REF!"}},{"$f":"SUM(L9,L10,#REF!,#REF!,#REF!,#REF!,L11,L13,L16,L17,L18)-SUM(L12,L14,L15)","v":{"$error":"#REF!"}},{"$f":"SUM(M9,M10,#REF!,#REF!,#REF!,#REF!,M11,M13,M16,M17,M18)-SUM(M12,M14,M15)","v":{"$error":"#REF!"}},{"$f":"SUM(N9,N10,#REF!,#REF!,#REF!,#REF!,N11,N13,N16,N17,N18)-SUM(N12,N14,N15)","v":{"$error":"#REF!"}},{"$f":"SUM(O9,O10,#REF!,#REF!,#REF!,#REF!,O11,O13,O16,O17,O18)-SUM(O12,O14,O15)","v":{"$error":"#REF!"}},null,{"$f":"K19","v":{"$error":"#REF!"}},{"$f":"O19","v":{"$error":"#REF!"}},{"$f":"O19","v":{"$error":"#REF!"}}]
[]
[null,"Schedule HC-R—Regulatory Capital"]
[null,"Tier 1 capital"]
[{"$f":"A19+1","v":14},"Total bank equity capital",null,{"$f":"\"Item \"&A19&\" =rcfd3210\"","v":"Item 13 =rcfd3210"},null,null,{"$f":"G19","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"A23+1","v":15},"Net unrealized gains (losses) on available-for-sale securities (if a gain, report as a positive value; if a loss, report as a negative value)","rk_afssecgain","rcfd8434"]
[16,"Net unrealized loss on available-for-sale equity securities (report loss as a positive value)","rk_afseqtyloss","rcfda221"]
[17,"Accumulated net gains (losses) on cash flow hedges (if a gain, report as a positive value; if a loss, report as a negative value)","rk_cashgain","rcfd4336"]
[18,"Nonqualifying perpetual preferred stock","rk_nonqual_pref","rcfdb588"]
[19,"Qualifying noncontrolling (minority) interests in consolidated subsidiaries","rk_qual_minorint","rcfdb589"]
[20,"Qualifying restricted core capital elements (other than cumulative perpetual preferred stock)","rk_qual_core","bhckg215"]
[21,"Qualifying mandatory convertible preferred securities of internationally active bank holding companies","rk_qual_convert","bhckg216"]
[22,"Disallowed goodwill and other disallowed intangible assets","rk_disallow_intang","riadb590"]
[23,"Cumulative change in fair value of all financial liabilities accounted for under a fair value option that is included in retained earnings and is attributable to changes in the bank holding company's own creditworthiness (if a net gain, report as a positive value; if a net loss, report as a negative value)","rk_fvchange","riadf264"]
[24,{"$f":"\"Subtotal (sum of items \"&A23&\", \"&A28&\", less items \"&A24&\", \"&A25&\", \"&A26&\", \"&A27&\", \"&A31&\", \"&A32&\")\"","v":"Subtotal (sum of items 14, 19, less items 15, 16, 17, 18, 22, 23)"},"rk_tier1subtot","riadc227",null,null,{"$f":"SUM(G23,G28,G29,G30)-SUM(G24,G25,G26,G27,G31,G32)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[25,"Disallowed servicing assets and purchased credit card relationships","rk_disallow_servass","rcfdb591"]
[26,"Disallowed deferred tax assets","rk_disallow_dta","rcfd5610"]
[27,"Other additions to (deductions from) Tier 1 capital**","rk_othtier1","rcfdb592"]
[28,{"$f":"\"Tier 1 capital (sum of items \"&A33&\" and \"&A36&\", less items \"&A34&\" and \"&A35&\")\"","v":"Tier 1 capital (sum of items 24 and 27, less items 25 and 26)"},"rk_tier1","rcfd8274",null,null,{"$f":"SUM(G33,G36)-SUM(G34,G35)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[{"$f":"A37+1","v":29},"Total risk-weighted assets","rk_rwa","rcfda223"]
[]
[]
[null,"REGULATORY CAPITAL AND RATIOS"]
[{"$f":"A39+1","v":30},"Tier 1 Common Capital***","rk_tier1_comm"]
[{"$f":"A43+1","v":31},"Tier 1 Capital","rk_tier1","rcfd8274"]
[{"$f":"A44+1","v":32},"Total Risk-Based Capital","rk_totalrbc","rcfd3792"]
[{"$f":"A45+1","v":33},"Risk-Weighted Assets",null,{"$f":"\"Item \"&A39&\" = rcfda223\"","v":"Item 29 = rcfda223"},null,null,{"$f":"G39","v":0},0,0,0,0,0,0,0,0]
[{"$f":"A46+1","v":34},"Average Total Assets for Leverage Capital Purposes","rk_avgass","rcfda224"]
[]
[{"$f":"A47+1","v":35},"Tier 1 Common Ratio (%)",null,"Tier 1 Common/RWA*100",null,{"$f":"IF(ISERROR(F43/F46*100),0,F43/F46*100)","v":0},{"$f":"IF(ISERROR(G43/G46*100),0,G43/G46*100)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"A49+1","v":36},"Tier 1 Ratio (%)",null,"Tier 1 Capital/RWA*100",null,{"$f":"IF(ISERROR(F44/F46*100),0,F44/F46*100)","v":0},{"$f":"IF(ISERROR(G44/G46*100),0,G44/G46*100)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"A50+1","v":37},"Total Risk-Based Capital Ratio (%)",null,"Total Risk-Based Capital/RWA*100",null,{"$f":"IF(ISERROR(F45/F46*100),0,F45/F46*100)","v":0},{"$f":"IF(ISERROR(G45/G46*100),0,G45/G46*100)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"A51+1","v":38},"Tier 1 Leverage Ratio (%)",null,"Tier 1 Capital/Average Total Assets*100",null,{"$f":"IF(ISERROR(F44/F47*100),0,F44/F47*100)","v":0},{"$f":"IF(ISERROR(G44/G47*100),0,G44/G47*100)","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Schedule HC-R — Memoranda"]
[null,"Preferred stock (including related surplus) eligible for inclusion in Tier 1 capital:"]
[{"$f":"A52+1","v":39},"Noncumulative perpetual preferred stock","rk_pref_noncum","bhck5479"]
[{"$f":"A56+1","v":40},"Other noncumulative preferred stock eligible for inclusion in Tier 1 capital (e.g., REIT preferred securities)","rk_pref_other_noncum","bhckc498"]
[{"$f":"A57+1","v":41},"Other cumulative preferred stock eligible for inclusion in Tier 1 capital (excluding TruPS)","rk_pref_cum","bhcka507"]
[null,"Treasury stock (including offsetting debit to the liability for ESOP debt):"]
[{"$f":"A58+1","v":42},"In the form of perpetual preferred stock","rk_treas_pref","bhck5483"]
[{"$f":"A60+1","v":43},"In the form of common stock","rk_treas_common","bhck5484"]
[null,"Restricted core capital elements included in Tier 1 capital:"]
[{"$f":"A61+1","v":44},"Qualifying Class B noncontrolling (minority) interest","rk_restrict_classb","bhckg219"]
[{"$f":"A63+1","v":45},"Qualifying Class C noncontrolling (minority) interest)","rk_restrict_classc","bhckg220"]
[{"$f":"A64+1","v":46},"Qualifying cumulative perpetual preferred stock","rk_restrict_pref_cum","bhck5990"]
[{"$f":"A65+1","v":47},"Qualifying TruPS","rk_restrict_qual_trups","bhckc502"]
[{"$f":"A66+1","v":48},"Goodwill net of any associated deferred tax liability","rk_goodwill_net","bhckg221"]
[]
[null,"Schedule HC-F—Other Assets"]
[{"$f":"A67+1","v":49},"Net deferred tax assets","rk_dta_net","rcfd2148"]
[]
[null,"Schedule HC-G—Other Liabilities"]
[{"$f":"A70+1","v":50},"Net deferred tax liabilities","rk_dtl_net","rcfd3049"]
[]
[null,"Schedule HC-M—Memoranda"]
[{"$f":"A73+1","v":51},"Total number of bank holding company common shares outstanding","rk_commonshrs","bhck3459"]
[null,"Issuances associated with the U.S. Department of Treasury Capital Purchase Program:"]
[{"$f":"A76+1","v":52},"Senior perpetual preferred stock or similar items","rk_tarp_pref","bhckg234"]
[{"$f":"A78+1","v":53},"Warrants to purchase common stock or similar items","rk_tarp_warr","bhckg235"]
[]
[null,"Disallowed Deferred Tax Assets Calculation (Schedule HC-R Instructions)"]
[{"$f":"A79+1","v":54},"(a) Enter the tier 1 subtotal",null,{"$f":"\"Item \"&A33","v":"Item 24"},null,null,{"$f":"G33","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"A82+1","v":55},"(b) Enter 10% of the tier 1 subtotal",null,{"$f":"\"10% of Item \"&A82","v":"10% of Item 54"},null,null,{"$f":"0.1*G82","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[56,"(c) Enter the amount of of deferred tax assets to be used when calculating the regulatory capital limit"]
[57,{"$f":"\"Enter any optional adjustment made to item \"&A70&\" in item \"&A84&\" as allowed in the FR Y-9C instructions\"","v":"Enter any optional adjustment made to item 49 in item 56 as allowed in the FR Y-9C instructions"},null,{"$f":"\"Item \"&A70&\" less item \"&A84","v":"Item 49 less item 56"},null,null,{"$f":"G70-G84","v":0},0,0,0,0,0,0,0,0]
[58,"(d) Enter the amount of taxes previously paid that the bank holding company could recover through loss carrybacks if the bank holding company’s temporary differences (both deductible and taxable) fully reverse at the report date****"]
[59,"(e) Amount of deferred tax assets that is dependent upon future taxable income",null,{"$f":"\"max(item \"&A84&\" less item \"&A86&\", 0)\"","v":"max(item 56 less item 58, 0)"},null,{"$f":"MAX(F84-F86,0)","v":0},{"$f":"MAX(G84-G86,0)","v":0},0,0,0,0,0,0,0,0]
[60,"(f) Enter the portion of (e) that the bank holding company could realize within the next 12 months based on its projected future taxable income. Future taxable income should not include net operating loss carryforwards to be used during the next 12 months or existing temporary differences that are expected to reverse over the next 12 months"]
[61,"(g) Enter minimum of (f) and (b)",null,{"$f":"\"min(item \"&A88&\", item \"&A83&\")\"","v":"min(item 60, item 55)"},null,{"$f":"MIN(F88,F83)","v":0},{"$f":"MIN(G88,G83)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[62,{"$f":"\"(h) Subtract (g) from (e), cannot be less than 0 (must equal item \"&A35&\")\"","v":"(h) Subtract (g) from (e), cannot be less than 0 (must equal item 26)"},null,{"$f":"\"max(item \"&A87&\" less item \"&A89&\", 0)\"","v":"max(item 59 less item 61, 0)"},null,{"$f":"MAX(F87-F89,0)","v":0},{"$f":"MAX(G87-G89,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[63,{"$f":"\"Future taxes paid used to determine item \"&A88","v":"Future taxes paid used to determine item 60"}]
[64,{"$f":"\"Future taxable income consistent with item \"&A88&\"*****\"","v":"Future taxable income consistent with item 60*****"}]
[]
[null,"Supplemental Capital Action Information (report in $Millions unless otherwise noted)******"]
[{"$f":"A92+1","v":65},"Cash dividends declared on common stock"]
[{"$f":"A95+1","v":66},"Common shares outstanding (Millions)"]
[{"$f":"A96+1","v":67},"Common dividends per share ($)",null,{"$f":"\"Item \"&A95&\" divided by item \"&A96","v":"Item 65 divided by item 66"},null,{"$f":"IF(ISERROR(F95/F96),0,F95/F96)","v":0},{"$f":"IF(ISERROR(G95/G96),0,G95/G96)","v":0},0,0,0,0,0,0,0,0]
[]
[{"$f":"A97+1","v":68},"Issuance of common stock for employee compensation"]
[{"$f":"A99+1","v":69},"Other issuance of common stock"]
[{"$f":"A100+1","v":70},"Total issuance of common stock",null,{"$f":"\"Sum of items \"&A99&\" and \"&A100","v":"Sum of items 68 and 69"},null,{"$f":"SUM(F99:F100)","v":0},{"$f":"SUM(G99:G100)","v":0},0,0,0,0,0,0,0,0]
[]
[{"$f":"A101+1","v":71},"Share repurchases to offset issuance for employee compensation"]
[{"$f":"A103+1","v":72},"Other share repurchase"]
[{"$f":"A104+1","v":73},"Total share repurchases",null,{"$f":"\"Sum of items \"&A103&\" and \"&A104","v":"Sum of items 71 and 72"},null,{"$f":"SUM(F103:F104)","v":0},{"$f":"SUM(G103:G104)","v":0},0,0,0,0,0,0,0,0]
[]
[]
["(*)","Please break out and explain below other adjustments to equity capital:"]
[]
[]
[]
[]
[]
["(**)","Please break out and explain below other additions to (deductions from) Tier 1 capital:"]
[]
[]
[]
[]
[]
["(***)","Tier 1 common is calculated as Tier 1 capital less non-common elements, including perpetual preferred stock and related surplus and minority interest in subsidiaries.  "]
[]
["(****)",{"$f":"\"The carryback period is the prior two calendar tax years plus any current taxes paid in the year-to-date period.  Please provide disaggregated data for item \"&A86&\" as follows:\"","v":"The carryback period is the prior two calendar tax years plus any current taxes paid in the year-to-date period.  Please provide disaggregated data for item 58 as follows:"}]
[null,"Taxes paid during fiscal year ended 2009"]
[null,"Taxes paid during fiscal year ended 2010"]
[null,"Taxes paid during the 9 months ended 9/30/11"]
[]
["(*****)",{"$f":"\"Please provide historical data related to item \"&A92&\" as follows:\"","v":"Please provide historical data related to item 64 as follows:"}]
[null,"Income (loss) reported to IRS on Schedule M3 (line 30) for fiscal year ended 2009"]
[null,"Income (loss) reported to IRS on Schedule M3 (line 30) for fiscal year ended 2010"]
[]
["(******)","Please reconcile the Supplemental Capital Action and HI-A projections (i.e., allocate the capital actions among the HI-A buckets):"]
[]
[]
[]
[]
[]
[null,"The following cells provide checks of the internal consistency of the projected schedules.  Please ensure that these cells are all \"TRUE\" before the worksheet is submitted."]
[null,"RI-A bank equity capital vs bank equity capital",{"$nulls":3},{"$f":"F19='Balance Sheet Worksheet'!F78","v":true},{"$f":"G19='Balance Sheet Worksheet'!G78","v":{"$error":"#REF!"}},{"$f":"H19='Balance Sheet Worksheet'!H78","v":{"$error":"#REF!"}},{"$f":"I19='Balance Sheet Worksheet'!I78","v":{"$error":"#REF!"}},{"$f":"J19='Balance Sheet Worksheet'!J78","v":{"$error":"#REF!"}},{"$f":"K19='Balance Sheet Worksheet'!K78","v":{"$error":"#REF!"}},{"$f":"L19='Balance Sheet Worksheet'!L78","v":{"$error":"#REF!"}},{"$f":"M19='Balance Sheet Worksheet'!M78","v":{"$error":"#REF!"}},{"$f":"N19='Balance Sheet Worksheet'!N78","v":{"$error":"#REF!"}},{"$f":"O19='Balance Sheet Worksheet'!O78","v":{"$error":"#REF!"}}]
[null,"Disallowed DTA",{"$nulls":3},{"$f":"F35=F90","v":true},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[]
[]
["y"]
["n"]

{"sheet":"Retail Balance Projections","index":4,"n_rows":94,"n_cols":11,"rows_kept":94,"merged":[[0,1,0,10],[2,2,2,10]]}
[null,{"$f":"\"Bank Retail Balance Projections Submission Worksheet: \"&'Summary Submission Cover Sheet'!D12&\" in \"&'Summary Submission Cover Sheet'!$B$20","v":"Bank Retail Balance Projections Submission Worksheet:  in Baseline"}]
[]
[null,null,"Projected in $Millions"]
["Item",null,"Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014"]
[null,"1st Mortgage (Domestic)"]
[1,"       Balances"]
["1.a","       New originations"]
["1.b","       Paydowns"]
["1.c","       Asset Purchases"]
["1.d","       Asset Sales"]
[null,"1st Lien HELOAN (Domestic)"]
[2,"       Balances"]
["2.a","       New originations"]
["2.b","       Paydowns"]
["2.c","       Asset Purchases"]
["2.d","       Asset Sales"]
[null,"Closed-End Junior Liens (Domestic)"]
[3,"       Balances"]
["3.a","       New originations"]
["3.b","       Paydowns"]
["3.c","       Asset Purchases"]
["3.d","       Asset Sales"]
[null,"HELOC (Domestic)"]
[4,"       Balances"]
["4.a","       New originations"]
["4.b","       Paydowns"]
["4.c","       Asset Purchases"]
["4.d","       Asset Sales"]
[null,"1st Lien Mortgages (International)"]
[5,"       Balances"]
["5.a","       New originations"]
["5.b","       Paydowns"]
["5.c","       Asset Purchases"]
["5.d","       Asset Sales"]
[null,"2nd Lien Mortgages (International)"]
[6,"       Balances"]
["6.a","       New originations"]
["6.b","       Paydowns"]
["6.c","       Asset Purchases"]
["6.d","       Asset Sales"]
[null,"Card (Domestic)"]
[7,"       Balances"]
["7.a","       New originations"]
["7.b","       Paydowns"]
["7.c","       Asset Purchases"]
["7.d","       Asset Sales"]
[null,"Card (International)"]
[8,"       Balances"]
["8.a","       New originations"]
["8.b","       Paydowns"]
["8.c","       Asset Purchases"]
["8.d","       Asset Sales"]
[null,"Auto Loan/Lease (Domestic)"]
[9,"       Balances"]
["9.a","       New originations"]
["9.b","       Paydowns"]
["9.c","       Asset Purchases"]
["9.d","       Asset Sales"]
[null,"Auto Loan/Lease (International)"]
[10,"       Balances"]
["10.a","       New originations"]
["10.b","       Paydowns"]
["10.c","       Asset Purchases"]
["10.d","       Asset Sales"]
[null,"Student Loan "]
[11,"       Balances"]
["11.a","       New originations"]
["11.b","       Paydowns"]
["11.c","       Asset Purchases"]
["11.d","       Asset Sales"]
[null,"Small Business Loan - Scored (Domestic)"]
[12,"       Balances"]
["12.a","       New originations"]
["12.b","       Paydowns"]
["12.c","       Asset Purchases"]
["12.d","       Asset Sales"]
[null,"Small Business Loan - Scored (International)"]
[13,"       Balances"]
["13.a","       New originations"]
["13.b","       Paydowns"]
["13.c","       Asset Purchases"]
["13.d","       Asset Sales"]
[null,"Other Consumer Loan (Domestic)"]
[14,"       Balances"]
["14.a","       New originations"]
["14.b","       Paydowns"]
["14.c","       Asset Purchases"]
["14.d","       Asset Sales"]
[null,"Other Consumer Loan (International)"]
[15,"       Balances"]
["15.a","       New originations"]
["15.b","       Paydowns"]
["15.c","       Asset Purchases"]
["15.d","       Asset Sales"]

{"sheet":"Retail Loss Projections","index":5,"n_rows":24,"n_cols":11,"rows_kept":24,"merged":[[0,1,0,10],[2,2,2,10]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Retail Loss Projections Submission Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Retail Loss Projections Submission Worksheet:  in Baseline"}]
[]
[null,"Loan Losses in $Millions","Projected in $Millions"]
["Item",null,"Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014"]
[1,"First Lien Mortgages (In Domestic Offices)",{"$f":"SUM(C6:C7)","v":0},{"$f":"SUM(D6:D7)","v":0},0,0,0,0,0,0,0]
[{"$f":"A5+1","v":2},"1st Mortgage (Domestic)"]
[{"$f":"A6+1","v":3},"1st Lien HELOAN (Domestic)"]
[4,"Second / Junior Lien Mortgages (In Domestic Offices)",{"$f":"SUM(C9:C10)","v":0},{"$f":"SUM(D9:D10)","v":0},0,0,0,0,0,0,0]
[5,"Closed-End Junior Liens (Domestic)"]
[6,"HELOC (Domestic)"]
[7,"Mortgages (International)",{"$f":"SUM(C12:C13)","v":0},0,0,0,0,0,0,0,0]
[8,"1st Lien Mortgages (International)"]
[9,"2nd Lien Mortgages and HELOCs (International)",null," "]
[10,"Credit Cards",{"$f":"SUM(C15:C16)","v":0},0,0,0,0,0,0,0,0]
[11,"Card (Domestic)"]
[12,"Card (International)"]
[13,"Other Consumer",{"$f":"SUM(C18:C24)","v":0},{"$f":"SUM(D18:D24)","v":0},0,0,0,0,0,0,0]
[14,"Auto Loan/Lease (Domestic)"]
[15,"Auto Loan/Lease (International)"]
[16,"Student Loan "]
[17,"Small Business Loan - Scored (Domestic)"]
[18,"Small Business Loan - Scored (International)"]
[19,"Other Consumer Loan (Domestic)"]
[20,"Other Consumer Loan (International)"]

{"sheet":"Retail Repurchase Worksheet","index":6,"n_rows":112,"n_cols":11,"rows_kept":112,"merged":[[0,0,0,10],[3,0,4,0],[3,1,3,9],[25,0,26,0],[25,1,25,10],[31,0,32,0],[31,1,31,9],[53,0,54,0],[53,1,53,10],[59,0,60,0],[59,1,59,9],[81,0,82,0],[81,1,81,10],[87,0,88,0],[87,1,87,9],[109,0,110,0],[109,1,109,10]]}
[{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Mortgage Repurchase Submission Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Mortgage Repurchase Submission Worksheet:  in Baseline"}]
[]
["Table A.1  LOANS SOLD TO GSEs"]
["$Millions","Vintage (Bank Baseline Scenario only)"]
[null,2004,2005,2006,2007,2008,2009,2010,"2011&12","Unallocated","Total"]
["Original UPB"]
["Outstanding UPB (Excluding UPB Exempted or Settled)"]
["Delinquency Status as of 3Q"]
["Current "]
["Current, Previously Delinquent"]
["Current and Modified"]
["Past due 30 to 90 days"]
["Past due 90+ days"]
["Net Credit Loss Realized to-date"]
["Estimated Lifetime Net Credit Losses"]
["Repurchased UPB"]
["Repurchase Loss to-date"]
["Settlements/Make-Whole Payments to-date"]
["Repurchase Requests Outstanding"]
["Repurchase Reserve"]
["Litigation Reserve for Rep and Warrant Issues"]
["Projected Future Repurchase Losses"]
[]
[]
["Table A.2  Loss Projections for LOANS SOLD TO GSEs"]
["$Millions","Projected in $Millions"]
[null,"Q4-2012","Q1-2013","Q2-2013","Q3-2013","Q4-2013","Q1-2014","Q2-2014","Q3-2014","Q4-2014","2015 or Later"]
["Projected Future Repurchase Losses"]
[]
[]
["Table B.1 LOANS SECURITIZED "]
["$Millions","Vintage (BHC Baseline Scenario only)"]
[null,2004,2005,2006,2007,2008,2009,2010,"2011&12","Unallocated","Total"]
["Original UPB"]
["Outstanding UPB (Excluding UPB Exempted or Settled)"]
["Delinquency Status as of 3Q"]
["Current "]
["Current, Previously Delinquent"]
["Current and Modified"]
["Past due 30 to 90 days"]
["Past due 90+ days"]
["Net Credit Loss Realized to-date"]
["Estimated Lifetime Net Credit Losses"]
["Repurchased UPB"]
["Repurchase Loss to-date"]
["Settlements/Make-Whole Payments to-date"]
["Repurchase Requests Outstanding"]
["Repurchase Reserve"]
["Litigation Reserve for Rep and Warrant Issues"]
["Projected Future Repurchase Losses"]
[]
[]
["Table B.2  Loss Projections for SECURITIZED LOANS"]
["$Millions","Projected in $Millions"]
[null,"Q4-2012","Q1-2013","Q2-2013","Q3-2013","Q4-2013","Q1-2014","Q2-2014","Q3-2014","Q4-2014","2015 or Later"]
["Projected Future Repurchase Losses"]
[]
[]
["Table C.1  WHOLE LOANS SOLD"]
["$Millions","Vintage (BHC Baseline Scenario only)"]
[null,2004,2005,2006,2007,2008,2009,2010,"2011&12","Unallocated","Total"]
["Original UPB"]
["Outstanding UPB (Excluding UPB Exempted or Settled)"]
["Delinquency Status as of 3Q"]
["Current "]
["Current, Previously Delinquent"]
["Current and Modified"]
["Past due 30 to 90 days"]
["Past due 90+ days"]
["Net Credit Loss Realized to-date"]
["Estimated Lifetime Net Credit Losses"]
["Repurchased UPB"]
["Repurchase Loss to-date"]
["Settlements/Make-Whole Payments to-date"]
["Repurchase Requests Outstanding"]
["Repurchase Reserve"]
["Litigation Reserve for Rep and Warrant Issues"]
["Projected Future Repurchase Losses"]
[]
[]
["Table C.2  Loss Projections for WHOLE LOANS SOLD"]
["$Millions","Projected in $Millions"]
[null,"Q4-2012","Q1-2013","Q2-2013","Q3-2013","Q4-2013","Q1-2014","Q2-2014","Q3-2014","Q4-2014","2015 or Later"]
["Projected Future Repurchase Losses"]
[]
[]
["Table D.1  TOTAL LOANS SOLD"]
["$Millions","Vintage (BHC Baseline Scenario only)"]
[null,2004,2005,2006,2007,2008,2009,2010,"2011&12","Unallocated","Total"]
["Original UPB"]
["Outstanding UPB (Excluding UPB Exempted or Settled)"]
["Delinquency Status as of 3Q"]
["Current "]
["Current, Previously Delinquent"]
["Current and Modified"]
["Past due 30 to 90 days"]
["Past due 90+ days"]
["Net Credit Loss Realized to-date"]
["Estimated Lifetime Net Credit Losses"]
["Repurchased UPB"]
["Repurchase Loss to-date"]
["Settlements/Make-Whole Payments to-date"]
["Repurchase Requests Outstanding"]
["Repurchase Reserve"]
["Litigation Reserve for Rep and Warrant Issues"]
["Projected Future Repurchase Losses"]
[]
[]
["Table D.2  Loss Projections for TOTAL LOANS SOLD"]
["$Millions","Projected in $Millions"]
[null,"Q4-2012","Q1-2013","Q2-2013","Q3-2013","Q4-2013","Q1-2014","Q2-2014","Q3-2014","Q4-2014","2015 or Later"]
["Projected Future Repurchase Losses"]

{"sheet":"Retail ASC 310-30 Worksheet","index":7,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[0,0,0,11],[5,3,5,11]]}
[{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"ASC 310-30 Credit Mark Submission Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank ASC 310-30 Credit Mark Submission Worksheet:  in Baseline"}]
[]
["                               ","Bank to complete the table below for ASC 310-30 (SOP03-3) Purchased Impaired loans in each Retail portfolio under each stress scenario."]
["                               ","Provide actual information for Q3 2012 (in the BHC Baseline Scenario only) and projected information for the period of Q4 2012 to Q4 2014.  "]
[]
[{"$nulls":3},"Projected in $Millions"]
[null,"<PORTFOLIO>","3Q 2012","4Q 2012","1Q 2013","2Q 2013","3Q 2013","4Q 2013","1Q 2014","2Q 2012","3Q 2014","4Q 2014"]
[1,"$ Unpaid Principal Balance"]
[2,"$ Credit Mark Usage"]
[3,"$ ASC 310-30 (SOP-03-3) Reserve Usage"]
[4,"$ Ending Credit Marks"]
[5,"$ Ending ASC 310-30 (SOP-03-3) Reserves"]

{"sheet":"Retail Fair Value Worksheet","index":8,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[0,1,0,6],[5,2,5,3],[5,5,5,6]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Retail Loan Fair Value and Held for Sale Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Retail Loan Fair Value and Held for Sale Worksheet:  in Baseline"}]
[]
[null,"Covered Bank to complete the tables below for retail Held for Investment loans measured at fair value and Held for Sale loans as of 3Q 2012."]
[]
[]
[null,null,"Held for Investment Loans Measured at Fair Value",null,null,"Loans Held for Sale"]
[null,"$Millions","Fair Value ","Unpaid Principal Balance ",null,"Carrying Value","Unpaid Principal Balance"]
[1,"1st Lien Mortgage"]
[2,"HELOC"]
[3,"Credit Card"]
[4,"Auto Loan / Lease"]
[5,"Student Loan"]
[6,"Small Business Loan - Scored"]
[7,"Other Consumer Loan"]

{"sheet":"Securities CUSIPs Worksheet","index":9,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[0,0,0,9],[3,0,3,9]]}
[{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"AFS and HTM Securities CUSIP Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank AFS and HTM Securities CUSIP Worksheet:  in Baseline"}]
[]
["Projected Other-Than-Temporary Impairment (OTTI) for Available-for-Sale (AFS) Securities and Held-to-Maturity (HTM) Securities by CUSIP"]
["For each CUSIP that incurred losses, please state the CUSIP and the amount of loss projected (over the entire forecast horizon).  Create a separate line item for each CUSIP. Total projected losses should reconcile to the total sum of projected losses provided in Securties Worksheet 1."]
["Please provide responses in USD millions."]
[]
["CUSIP","Actual 9/30/2012\nAmortized Cost","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI"]
[]
["GRAND TOTAL",{"$f":"SUM(B8:B8)","v":0},{"$f":"SUM(C8:C8)","v":0},{"$f":"SUM(D8:D8)","v":0},{"$f":"SUM(E8:E8)","v":0}]

{"sheet":"Securities Worksheet 1","index":10,"n_rows":76,"n_cols":29,"rows_kept":76,"merged":[[0,1,0,28],[3,1,3,28],[4,2,4,4],[4,5,4,7],[4,8,4,10],[4,11,4,13],[4,14,4,16],[4,17,4,19],[4,20,4,22],[4,23,4,25],[4,26,4,28],[37,1,37,17],[38,1,38,17],[41,2,41,4],[41,5,41,7],[41,8,41,10],[41,11,41,13],[41,14,41,16],[41,17,41,19],[41,20,41,22],[41,23,41,25],[41,26,41,28],[74,1,74,17],[75,1,75,17]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"AFS and HTM Securities Worksheet 1: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank AFS and HTM Securities Worksheet 1:  in Baseline"}]
[]
[null,"Securities Worksheet 1: Projected Other-Than-Temporary Impairment (OTTI) for Available-for-Sale (AFS) and Held-to-Maturity (HTM) Securities by Portfolio"]
[null,"For each stress scenario used, please provide the credit loss portion and non-credit loss portion of projected OTTI (for relevant portfolios) for the quarters detailed in the table below. \nPlease provide responses in USD millions.  Values should be quarterly, not cumulative.\n"]
[null,null,"Projected Q4 2012",null,null,"Projected Q1 2013",null,null,"Projected Q2 2013",null,null,"Projected Q3 2013",null,null,"Projected Q4 2013",null,null,"Projected Q1 2014",null,null,"Projected Q2 2014",null,null,"Projected Q3 2014",null,null,"Projected Q4 2014"]
[null,"AFS Securities","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI","Credit Loss Portion","Non- Credit Loss Portion","Total OTTI"]
[1,"Agency RMBS",null,null,{"$f":"SUM(C7:D7)","v":0},null,null,{"$f":"SUM(F7:G7)","v":0},null,null,{"$f":"SUM(I7:J7)","v":0},null,null,{"$f":"SUM(L7:M7)","v":0},null,null,{"$f":"SUM(O7:P7)","v":0},null,null,{"$f":"SUM(R7:S7)","v":0},null,null,{"$f":"SUM(U7:V7)","v":0},null,null,{"$f":"SUM(X7:Y7)","v":0},null,null,{"$f":"SUM(AA7:AB7)","v":0}]
[2,"Auction Rate Securities",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[3,"CDO",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[4,"CLO",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[5,"CMBS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[6,"Common Stock (Equity)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[7,"Total Consumer ABS (excl HEL ABS)*",{"$f":"SUM(C14:C17)","v":0},{"$f":"SUM(D14:D17)","v":0},0,{"$f":"SUM(F14:F17)","v":0},{"$f":"SUM(G14:G17)","v":0},0,{"$f":"SUM(I14:I17)","v":0},{"$f":"SUM(J14:J17)","v":0},0,{"$f":"SUM(L14:L17)","v":0},{"$f":"SUM(M14:M17)","v":0},0,{"$f":"SUM(O14:O17)","v":0},{"$f":"SUM(P14:P17)","v":0},0,{"$f":"SUM(R14:R17)","v":0},{"$f":"SUM(S14:S17)","v":0},0,{"$f":"SUM(U14:U17)","v":0},{"$f":"SUM(V14:V17)","v":0},0,{"$f":"SUM(X14:X17)","v":0},{"$f":"SUM(Y14:Y17)","v":0},0,{"$f":"SUM(AA14:AA17)","v":0},{"$f":"SUM(AB14:AB17)","v":0},0]
[8,"Auto ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[9,"Credit Card ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[10,"Student Loan ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[11,"Other ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[12,"Corporate Bonds (Domestic)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[13,"Corporate Bonds (Foreign)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[14,"Total Domestic Non-Agency RMBS (incl HEL ABS) ",{"$f":"SUM(C21:C29)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"Alt-A (Option ARM)",null,null,{"$f":"SUM(C21:D21)","v":0},null,null,{"$f":"SUM(F21:G21)","v":0},null,null,{"$f":"SUM(I21:J21)","v":0},null,null,{"$f":"SUM(L21:M21)","v":0},null,null,{"$f":"SUM(O21:P21)","v":0},null,null,{"$f":"SUM(R21:S21)","v":0},null,null,{"$f":"SUM(U21:V21)","v":0},null,null,{"$f":"SUM(X21:Y21)","v":0},null,null,{"$f":"SUM(AA21:AB21)","v":0}]
[16,"Alt-A FRM",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[17,"Alt-A ARM",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[18,"Closed-End Second",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[19,"HELOC",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[20,"Scratch & Dent",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[21,"Subprime",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[22,"Prime Fixed",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[23,"Prime ARM",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[24,"Foreign RMBS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[25,"Municipal Bonds",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[26,"Mutual Funds",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[27,"Preferred Stock (Equity)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[28,"Sovereign Bonds",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[29,"US Treasuries & Agencies",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[30,"Other**",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[31,"GRAND TOTAL",{"$f":"SUM(C7:C13,C18:C20,C30:C36)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"*Please include auto ABS, credit card ABS and student loan ABS and other ABS that is not home equity, CDO or CLO ABS."]
[null,"** For 'Other' AFS securities, please provide name of security type in row 30 above (currently labeled \"Other\").  Please add additional rows if necessary.  If adding additional rows, please ensure that grand totals sum appropriately."]
[]
[]
[null,null,"Projected Q4 2012",null,null,"Projected Q1 2013",null,null,"Projected Q2 2013",null,null,"Projected Q3 2013",null,null,"Projected Q4 2013",null,null,"Projected Q1 2014",null,null,"Projected Q2 2014",null,null,"Projected Q3 2014",null,null,"Projected Q4 2014"]
[null,"HTM Securities","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI","Credit Loss Portion of OTTI","Non- Credit Loss Portion of OTTI","Total OTTI"]
[32,"Agency RMBS",null,null,{"$f":"SUM(C44:D44)","v":0},null,null,{"$f":"SUM(F44:G44)","v":0},null,null,{"$f":"SUM(I44:J44)","v":0},null,null,{"$f":"SUM(L44:M44)","v":0},null,null,{"$f":"SUM(O44:P44)","v":0},null,null,{"$f":"SUM(R44:S44)","v":0},null,null,{"$f":"SUM(U44:V44)","v":0},null,null,{"$f":"SUM(X44:Y44)","v":0},null,null,{"$f":"SUM(AA44:AB44)","v":0}]
[33,"Auction Rate Securities",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[34,"CDO",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[35,"CLO",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[36,"CMBS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[37,"Common Stock (Equity)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[38,"Total Consumer ABS (excl HEL ABS)*",{"$f":"SUM(C51:C54)","v":0},{"$f":"SUM(D51:D54)","v":0},0,{"$f":"SUM(F51:F54)","v":0},{"$f":"SUM(G51:G54)","v":0},0,{"$f":"SUM(I51:I54)","v":0},{"$f":"SUM(J51:J54)","v":0},0,{"$f":"SUM(L51:L54)","v":0},{"$f":"SUM(M51:M54)","v":0},0,{"$f":"SUM(O51:O54)","v":0},{"$f":"SUM(P51:P54)","v":0},0,{"$f":"SUM(R51:R54)","v":0},{"$f":"SUM(S51:S54)","v":0},0,{"$f":"SUM(U51:U54)","v":0},{"$f":"SUM(V51:V54)","v":0},0,{"$f":"SUM(X51:X54)","v":0},{"$f":"SUM(Y51:Y54)","v":0},0,{"$f":"SUM(AA51:AA54)","v":0},{"$f":"SUM(AB51:AB54)","v":0},0]
[39,"Auto ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[40,"Credit Card ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[41,"Student Loan ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[42,"Other ABS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[43,"Corporate Bonds (Domestic)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[44,"Corporate Bonds (Foreign)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[45,"Total Domestic Non-Agency RMBS (incl HEL ABS) ",{"$f":"SUM(C58:C66)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[46,"Alt-A (Option ARM)",null,null,{"$f":"SUM(C58:D58)","v":0},null,null,{"$f":"SUM(F58:G58)","v":0},null,null,{"$f":"SUM(I58:J58)","v":0},null,null,{"$f":"SUM(L58:M58)","v":0},null,null,{"$f":"SUM(O58:P58)","v":0},null,null,{"$f":"SUM(R58:S58)","v":0},null,null,{"$f":"SUM(U58:V58)","v":0},null,null,{"$f":"SUM(X58:Y58)","v":0},null,null,{"$f":"SUM(AA58:AB58)","v":0}]
[47,"Alt-A FRM",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[48,"Alt-A ARM",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[49,"Closed-End Second",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[50,"HELOC",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[51,"Scratch & Dent",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[52,"Subprime",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[53,"Prime Fixed",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[54,"Prime ARM",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[55,"Foreign RMBS",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[56,"Municipal Bonds",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[57,"Mutual Funds",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[58,"Preferred Stock (Equity)",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[59,"Sovereign Bonds",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[60,"US Treasuries & Agencies",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[61,"Other**",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[62,"GRAND TOTAL",{"$f":"SUM(C44:C50,C55:C57,,C67:C73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"*Please include auto ABS, credit card ABS and student loan ABS and other ABS that is not home equity, CDO or CLO ABS."]
[null,"** For 'Other' HTM securities, please provide name of security type in row 61 above (currently labeled \"Other\").  Please add additional rows if necessary.  If adding additional rows, please ensure that grand totals sum appropriately."]

{"sheet":"Securities Worksheet 2","index":11,"n_rows":38,"n_cols":11,"rows_kept":38,"merged":[[0,1,0,10],[3,1,3,10],[4,3,4,7],[36,1,36,10],[37,1,37,10]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"AFS and HTM Securities Worksheet 2: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank AFS and HTM Securities Worksheet 2:  in Baseline"}]
[]
[null,"Securities Worksheet 2: Methodology for Determining Projected Other-Than-Temporary Impairment (OTTI) for Available-for-Sale (AFS) and Held-to-Maturity (HTM) Securities by Portfolio"]
[null,"When stating the criteria for determining OTTI, please provide detail on the criteria used.  For example, if a price-based threshold is used, please state the threshold value."]
[{"$nulls":3},"Collateral Assumptions\nPlease state high-level simple average assumptions (where relevant) used for determining OTTI impairment.  Please provide a numerical response.",{"$nulls":4},"Security Assumptions\nPlease state what type of security assumptions (where relevant) are used for determining OTTI impairment.  Please provide a qualitative response."]
[null,"AFS and HTM Securities","Criteria for determining OTTI including quantitative threshold value\n(e.g., price-based threshold, ratings-based threshold, cash flow model-based expected losses)","Probability of Default","Loss Severity","Roll Rate Assumptions","Cumulative/ Projected Lifetime Loss Rate \n(% Original Balance)","Prepayment Rate","Discount Rate\n(e.g., book price/purchase price; other (please specify))","If employing a third-party model (e.g., third party cash flow, credit and/or prepayment model), please specify the vendor model(s) used and purpose","How often are securities normally tested for impairment?"]
[1,"Agency RMBS"]
[2,"Auction Rate Securities"]
[3,"CDO"]
[4,"CLO"]
[5,"CMBS"]
[6,"Common Stock (Equity)"]
[7,"Total Consumer ABS (excl HEL ABS)*"]
[8,"Auto ABS"]
[9,"Credit Card ABS"]
[10,"Student Loan ABS"]
[11,"Other ABS"]
[12,"Corporate Bonds (Domestic)"]
[13,"Corporate Bonds (Foreign)"]
[14,"Total Domestic Non-Agency RMBS (incl HEL ABS) "]
[15,"Alt-A (Option ARM)"]
[16,"Alt-A FRM"]
[17,"Alt-A ARM"]
[18,"Closed-End Second"]
[19,"HELOC"]
[20,"Scratch & Dent"]
[21,"Subprime"]
[22,"Prime Fixed"]
[23,"Prime ARM"]
[24,"Foreign RMBS"]
[25,"Municipal Bonds"]
[26,"Mutual Funds"]
[27,"Preferred Stock (Equity)"]
[28,"Sovereign Bonds"]
[29,"US Treasuries & Agencies"]
[30,"Other**"]
[null,"*Please include auto ABS, credit card ABS and student loan ABS and other ABS that is not home equity, CDO or CLO ABS."]
[null,"** For 'Other' AFS and HTM securities, please provide name of security type in row 30 above (currently labeled \"Other\").  Please add additional rows if necessary.  "]

{"sheet":"Securities Worksheet 3","index":12,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[0,1,0,5],[2,1,2,5],[3,1,3,5],[37,1,37,5],[38,1,38,5]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\" AFS and HTM Securities Worksheet 3: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank  AFS and HTM Securities Worksheet 3:  in Baseline"}]
[]
[null,"Securities Worksheet 3: Methodology and Assumptions for Determining Estimated Fair Market Values"]
[null,"Covered Banks should estimate and provide fair market values of AFS securities based on a re-pricing of 09/30/2012 positions.  Firms should also provide the primary market variables used for determination of estimated fair market values, high-level description of methodology, and assumptions by portfolio.  If the format is insufficient, please include an attachment.  "]
[]
[null,"AFS Securities","Estimated Post-Shock Fair Market Value","Primary Market Variable(s) Used for Determination of Estimated Post-Shock Fair Value","High-Level Description of Methodology\n(Please describe the process for determining post-shock fair market values.  Please describe how changes (absolute or relative) in the primary market pricing variables were applied to MM/DD/YYYY positions to determine estimated post-shock fair market values.)","Major Assumption(s)"]
[1,"Agency RMBS"]
[2,"Auction Rate Securities"]
[3,"CDO"]
[4,"CLO"]
[5,"CMBS"]
[6,"Common Stock (Equity)"]
[7,"Total Consumer ABS (excl HEL ABS)*",{"$f":"SUM(C14:C17)","v":0}]
[8,"Auto ABS"]
[9,"Credit Card ABS"]
[10,"Student Loan ABS"]
[11,"Other ABS"]
[12,"Corporate Bonds (Domestic)"]
[13,"Corporate Bonds (Foreign)"]
[14,"Total Domestic Non-Agency RMBS (incl HEL ABS) ",{"$f":"SUM(C21:C29)","v":0}]
[15,"Alt-A (Option ARM)"]
[16,"Alt-A FRM"]
[17,"Alt-A ARM"]
[18,"Closed-End Second"]
[19,"HELOC"]
[20,"Scratch & Dent"]
[21,"Subprime"]
[22,"Prime Fixed"]
[23,"Prime ARM"]
[24,"Foreign RMBS"]
[25,"Municipal Bonds"]
[26,"Mutual Funds"]
[27,"Preferred Stock (Equity)"]
[28,"Sovereign Bonds"]
[29,"US Treasuries & Agencies"]
[30,"Other**"]
[31,"GRAND TOTAL",{"$f":"SUM(C7:C13,C18:C20,C30:C36)","v":0}]
[null,"*Please include auto ABS, credit card ABS and student loan ABS and other ABS that is not home equity, CDO or CLO ABS."]
[null,"** For 'Other' AFS securities, please provide name of security type in row 30 above (currently labeled \"Other\").  Please add additional rows if necessary.  "]

{"sheet":"Securities Worksheet 4","index":13,"n_rows":40,"n_cols":11,"rows_kept":40,"merged":[[0,1,0,10],[4,1,4,10],[5,4,5,9],[6,4,6,8],[38,1,38,9],[39,1,39,10]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"AFS and HTM Securities Worksheet 4: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank AFS and HTM Securities Worksheet 4:  in Baseline"}]
[]
[null,"Securities Worksheet 4: Actual 09/30/2012 AFS and HTM Fair Market Value Sources by Portfolio"]
[]
[null,"Provide information on actual 09/30/2012 fair market values.\n"]
[{"$nulls":4},"If using a proprietary model, please state the principal model input and assumption\n(e.g., discount rate, PD, loss severity, etc.) "]
[{"$nulls":4},"Collateral Assumptions\nPlease state high-level simple average assumptions (where relevant).  Please provide a numerical response.",{"$nulls":4},"Security Assumptions\nPlease state what type of security assumptions (where relevant).  Please provide a numerical response."]
[null,"AFS and HTM Securities","Principal Market Value Source \n(e.g., 3rd party vendor(s), proprietary model, other)","If relevant, please provide 3rd party vendor(s)","Probability of Default","Loss Severity","Roll Rate Assumptions","Cumulative/ Projected Lifetime Loss Rate \n(% Original Balance)","Prepayment Rate","Simple Average Discount Rate","How often are securities normally marked (e.g., daily, etc.)?"]
[1,"Agency RMBS"]
[2,"Auction Rate Securities"]
[3,"CDO"]
[4,"CLO"]
[5,"CMBS"]
[6,"Common Stock (Equity)"]
[7,"Total Consumer ABS (excl HEL ABS)*"]
[8,"Auto ABS"]
[9,"Credit Card ABS"]
[10,"Student Loan ABS"]
[11,"Other ABS"]
[12,"Corporate Bonds (Domestic)"]
[13,"Corporate Bonds (Foreign)"]
[14,"Total Domestic Non-Agency RMBS (incl HEL ABS) "]
[15,"Alt-A (Option ARM)"]
[16,"Alt-A FRM"]
[17,"Alt-A ARM"]
[18,"Closed-End Second"]
[19,"HELOC"]
[20,"Scratch & Dent"]
[21,"Subprime"]
[22,"Prime Fixed"]
[23,"Prime ARM"]
[24,"Foreign RMBS"]
[25,"Municipal Bonds"]
[26,"Mutual Funds"]
[27,"Preferred Stock (Equity)"]
[28,"Sovereign Bonds"]
[29,"US Treasuries & Agencies"]
[30,"Other**"]
[null,"*Please include auto ABS, credit card ABS and student loan ABS and other ABS that is not home equity, CDO or CLO ABS."]
[null,"** For 'Other' AFS and HTM securities, please provide name of security type in row 30 above (currently labeled \"Other\").  Please add additional rows if necessary.  "]

{"sheet":"Trading Worksheet","index":14,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[0,0,0,8]]}
[{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Trading, PE & Other Fair Value Exposures: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Trading, PE & Other Fair Value Exposures:  in Baseline"}]
[null,"Effective date: XXXX, 2012"]
[]
[null,"P/L Results in $Millions"]
[null,null,"Firmwide Total"]
[1,"Equity"]
[{"$f":"A6+1","v":2},"FX"]
[{"$f":"A7+1","v":3},"Rates"]
[4,"Commodities"]
[5,"Securitized Products"]
[6,"Other Credit"]
[7,"Private Equity"]
[8,"Other Fair Value Assets"]
[{"$f":"A13+1","v":9},"Total",{"$f":"SUM(C6:C13)","v":0}]
[]
[null,"Subcomponents"]
[{"$f":"A14+1","v":10},"Cross-Gamma"]
[{"$f":"A17+1","v":11},"Correlation"]
[{"$f":"A18+1","v":12},"CVA Hedges"]
[]
[]
[]
[null,"The categories above (Equities, FX, Rates, etc.) are NOT meant to denote lines of business"]
[null,"or desks, but rather firmwide totals by risk stripe."]
[]
[null,"\"Other Credit\" is defined as the contribution from all credit products other than those"]
[null,"specified on the \"Securitized Products\" worksheet."]

{"sheet":"Counterparty Risk Worksheet","index":15,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[0,1,0,3]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"CCR Losses Submission Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank CCR Losses Submission Worksheet:  in Baseline"}]
[]
[null,"$Millions\nLosses should be reported as a positive value."]
[1,"Counterparty Credit MTM Losses (CVA losses)"]
[]
[2,"Counterparty Incremental Default Losses (CCR IDR)"]
[3,"Impact of CCR IDR hedges (as defined in the Instructions)"]
[]
[4,"Trading Incremental Default Losses (Trading IDR)"]
[5,"Trading Incremental Default losses from securitized products"]
[6,"Trading Incremental Default losses from other credit sensitive instruments"]
[null,"Consistency check",{"$f":"(C9)=(C10+C11)","v":true}]

{"sheet":"Op Risk Scenario Inputs","index":16,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[0,1,0,15],[2,1,4,15],[6,14,6,15],[7,2,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[8,2,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[9,2,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[10,2,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[11,2,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[12,2,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[12,14,12,15],[13,2,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[14,2,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[15,2,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[16,2,16,5],[16,6,16,7],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15],[17,2,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[18,1,18,13],[18,14,18,15],[20,14,20,15]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Summary of Scenario Inputs Contributing to Bank Operational Loss Projection: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Summary of Scenario Inputs Contributing to Bank Operational Loss Projection:  in Baseline"}]
[]
[null,"For the inputs into each scenario, provide the type of data, a brief description of the loss events (including events from an operational risk scenario analysis process), the impacted business line(s), the event type, any associated frequency and severity data, and the contribution of those events to the operational loss projection.  Provide total figures from Q4 2012 through Q4 2014. "]
[]
[]
[]
[null,"Type of Data","Brief Description",{"$nulls":3},"Business Line",null,"Event Type",null,"Frequency",null,"Severity ($Mil)"]
{"$rows_empty":11}
[null,"TOTAL",{"$nulls":12},{"$f":"SUM(O8:P18)","v":0}]
[]
[{"$nulls":14},"TOTAL SHOULD AGREE TO THE PROJECTED \"OPERATIONAL RISK EXPENSE\" AMOUNT INCLUDED IN LINE 26 IN THE PPNR PROJECTIONS WORKSHEET"]

{"sheet":"Projected Op Risk Losses","index":17,"n_rows":9,"n_cols":10,"rows_kept":9,"merged":[[0,1,0,9],[2,1,2,9],[7,2,7,5],[7,6,7,9]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Projected Quarterly Operational Risk Losses Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Projected Quarterly Operational Risk Losses Worksheet:  in Baseline"}]
[]
[null,"Provide any supporting information including statistical results, data, summary tables, and additional descriptions in a separate document and cross reference the document to the respective question/item."]
[]
[null,"The sum of the quarterly data provided must equal the total for each scenario in the Op Risk Scenario Inputs Worksheet"]
[]
[null,"Projected Operational Risk Losses"]
[null,"$Million","2013 Projections",{"$nulls":3},"2014 Projections"]
[null,"Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014"]

{"sheet":"PPNR Projections Worksheet","index":18,"n_rows":118,"n_cols":26,"rows_kept":118,"merged":[[0,1,0,13],[1,1,1,13],[4,1,4,4],[6,6,6,9],[6,10,6,13]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"PPNR Submission Worksheet: \"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank PPNR Submission Worksheet:  in Baseline"}]
[null,"Instructions: Banks are to complete non shaded cells only; all shaded cells with embedded formulas will self populate.  For items designated as supplementary, Bank are to complete the items as designated in the instructions. Flow quarterly items should be reported by quarter, and not on a cumulative basis."]
[null,"WARNING: MACROS MUST BE ENABLED TO USE THIS SCHEDULE"]
[null,"Specify reporting designation for net interest income HERE"]
[null,"Please indicate if deposits are one-third or more of total liabilities"]
[{"$nulls":15},"Amounts in $Mil",null,null,"THIS COLUMN HAS BEEN HIDDEN BECAUSE THE APPROPRIATE PERIODS TO CAPTURE IS UNKNOWN"]
[null,"Amounts in $ Mil",null,"Call Report Codes",null,"Projected ","2013 Projections",{"$nulls":3},"2014 Projections",{"$nulls":4},2009,2010,null,2010]
[null,"Net Interest Income by Business Segment:",{"$nulls":3},"Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014",{"$nulls":6},2013,2014]
[1,"Retail and Small Business",{"$nulls":3},{"$f":"SUM(F10,F16)","v":0},{"$f":"SUM(G10,G16)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(J9:M9)","v":0},{"$nulls":3},{"$f":"SUM(G9:J9)","v":0},{"$f":"SUM(K9:N9)","v":0}]
[null,"Domestic (7)",{"$nulls":3},{"$f":"SUM(F11:F15)","v":0},{"$f":"SUM(G11:G15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$nulls":3},{"$f":"SUM(G10:J10)","v":0},{"$f":"SUM(K10:N10)","v":0}]
["1A","Credit Cards (7)",{"$nulls":13},{"$f":"SUM(F11:I11)","v":0},{"$f":"SUM(J11:M11)","v":0},{"$nulls":3},0,0]
["1B","Mortgages (7)",{"$nulls":13},0,0,{"$nulls":3},0,0]
["1C","Home Equity (7)",{"$nulls":13},0,0,{"$nulls":3},0,0,{"$nulls":3},"Specify reporting designation for net interest income HERE"]
["1D","Retail and Small Business Banking (7)",{"$nulls":13},0,0,{"$nulls":3},0,0,{"$nulls":3},"Primary Net Interest Income"]
["1E","Other Retail and Small Business (7)",{"$nulls":13},0,0,{"$nulls":3},0,0,{"$nulls":3},"Supplementary Net Interest Income"]
["1F","International Retail and Small Business (7)",{"$nulls":13},0,0,{"$nulls":3},0,0]
[2,"Commercial Lending",{"$nulls":13},0,0,{"$nulls":3},0,0]
[3,"Investment Banking",{"$nulls":13},0,0,null,{"$f":"SUM(J18:M18)","v":0},null,0,0]
[4,"Sales and Trading",{"$nulls":13},0,0,null,{"$f":"SUM(J19:M19)","v":0},null,0,0,{"$nulls":3},"Please indicate if deposits are one-third or more of total liabilities"]
[5,"Investment Management",{"$nulls":13},0,0,{"$nulls":3},0,0,{"$nulls":3},"Yes, deposits are one-third or more of total liabilities"]
[6,"Investment Services",{"$nulls":13},0,0,null,{"$f":"SUM(J21:M21)","v":0},null,0,0,{"$nulls":3},"No, deposits are less than one-third of total liabilities"]
[7,"Treasury Services",{"$nulls":13},0,0,{"$nulls":3},0,0]
[8,"Insurance Services",{"$nulls":13},0,0,{"$nulls":3},0,0]
[9,"Retirement / Corporate Benefits Products",{"$nulls":13},0,0,{"$nulls":3},0,0]
[10,"Corporate / Other",{"$nulls":13},0,0,null,{"$f":"SUM(J25:M25)","v":0},null,0,0]
[]
[11,"Total Net Interest Income (1)",{"$nulls":3},{"$f":"SUM(F9,F17:F25)","v":0},{"$f":"SUM(G9,G17:G25)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(P11:P25)","v":0},{"$f":"SUM(Q11:Q25)","v":0},null,{"$f":"SUM(S23:S25)","v":0},null,{"$f":"SUM(G27:J27)","v":0},{"$f":"SUM(K27:N27)","v":0}]
[]
[null,"Non Interest Income by Business Segment:"]
[12,"Retail and Small Business",{"$nulls":3},{"$f":"SUM(F31,F36)","v":0},{"$f":"SUM(G31,G36)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(F30:I30)","v":0},{"$f":"SUM(J30:M30)","v":0},null,{"$f":"SUM(J30:M30)","v":0},null,{"$f":"SUM(G30:J30)","v":0},{"$f":"SUM(K30:N30)","v":0}]
[null,"Domestic",{"$nulls":3},{"$f":"SUM(F32:F35)","v":0},{"$f":"SUM(G32:G35)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(P32:P35)","v":0},{"$f":"SUM(Q32:Q35)","v":0},{"$nulls":3},0,0]
["12A","Credit Cards",{"$nulls":13},{"$f":"SUM(F32:I32)","v":0},{"$f":"SUM(J32:M32)","v":0},{"$nulls":3},0,0]
["12B","Mortgages and Home Equity",{"$nulls":13},0,0,{"$nulls":3},0,0]
["12C","Retail and Small Business Banking",{"$nulls":13},0,0,{"$nulls":3},0,0]
["12D","Other Retail and Small Business",{"$nulls":13},0,0,{"$nulls":3},0,0]
["12E","International Retail and Small Business",{"$nulls":13},0,0,{"$nulls":3},0,0]
[13,"Commercial Lending",{"$nulls":13},0,0,{"$nulls":3},0,0]
[14,"Investment Banking",{"$nulls":3},{"$f":"SUM(F39:F43)","v":0},{"$f":"SUM(G39:G43)","v":0},0,0,0,0,0,0,0,{"$nulls":4},{"$f":"SUM(J38:M38)","v":0},null,0,0]
["14A","Advisory",{"$nulls":13},{"$f":"SUM(F39:I39)","v":0},{"$f":"SUM(J39:M39)","v":0},null,{"$f":"SUM(J39:M39)","v":0},null,0,0]
["14B","Equity Underwriting",{"$nulls":13},{"$f":"SUM(F40:I40)","v":0},{"$f":"SUM(J40:M40)","v":0},{"$nulls":3},0,0]
["14C","Debt Underwriting",{"$nulls":13},{"$f":"SUM(F41:I41)","v":0},{"$f":"SUM(J41:M41)","v":0},{"$nulls":3},0,0]
["14D","Corporate Lending",{"$nulls":13},{"$f":"SUM(F42:I42)","v":0},{"$f":"SUM(J42:M42)","v":0},null,{"$f":"SUM(J42:M42)","v":0},null,0,0]
["14E","Merchant Banking / Private Equity",{"$nulls":13},{"$f":"SUM(F43:I43)","v":0},{"$f":"SUM(J43:M43)","v":0},null,{"$f":"SUM(J43:M43)","v":0},null,0,0]
[15,"Sales and Trading (10)",{"$nulls":3},{"$f":"SUM(F45:F48)","v":0},{"$f":"SUM(G45:G48)","v":0},0,0,0,0,0,0,0,{"$nulls":4},{"$f":"SUM(J44:M44)","v":0},null,0,0]
["15A","Equities",{"$nulls":13},{"$f":"SUM(F45:I45)","v":0},{"$f":"SUM(J45:M45)","v":0},null,{"$f":"SUM(J45:M45)","v":0},null,0,0]
["15B","Fixed Revenues",{"$nulls":13},{"$f":"SUM(F46:I46)","v":0},{"$f":"SUM(J46:M46)","v":0},{"$nulls":3},0,0]
["15C","Commodities",{"$nulls":13},{"$f":"SUM(F47:I47)","v":0},{"$f":"SUM(J47:M47)","v":0},{"$nulls":3},0,0]
["15D","Prime Brokerage",{"$nulls":13},{"$f":"SUM(F48:I48)","v":0},{"$f":"SUM(J48:M48)","v":0},{"$nulls":3},0,0]
[16,"Investment Management",{"$nulls":3},{"$f":"SUM(F50:F51)","v":0},{"$f":"SUM(G50:G51)","v":0},0,0,0,0,0,0,0,{"$nulls":6},0,0]
["16A","Asset Management",{"$nulls":13},{"$f":"SUM(F50:I50)","v":0},{"$f":"SUM(J50:M50)","v":0},{"$nulls":3},0,0]
["16B","Wealth Management / Private Banking",{"$nulls":13},{"$f":"SUM(F51:I51)","v":0},{"$f":"SUM(J51:M51)","v":0},{"$nulls":3},0,0]
[17,"Investment Services",{"$nulls":3},{"$f":"SUM(F53:F55)","v":0},{"$f":"SUM(G53:G55)","v":0},0,0,0,0,0,0,0,{"$nulls":4},{"$f":"SUM(J52:M52)","v":0},null,0,0]
["17A","Asset Servicing",{"$nulls":13},{"$f":"SUM(F53:I53)","v":0},{"$f":"SUM(J53:M53)","v":0},{"$nulls":3},0,0]
["17B","Issuer Services",{"$nulls":13},0,0,{"$nulls":3},0,0]
["17C","Other Investment Services",{"$nulls":13},0,0,{"$nulls":3},0,0]
[18,"Treasury Services",{"$nulls":13},0,0,{"$nulls":3},0,0]
[19,"Insurance Services",{"$nulls":13},0,0,null,{"$f":"SUM(J57:M57)","v":0},null,0,0]
[20,"Retirement / Corporate Benefits Products",{"$nulls":13},0,0,{"$nulls":3},0,0]
[21,"Corporate / Other",{"$nulls":13},0,0,null,{"$f":"SUM(J59:M59)","v":0},null,0,0]
[]
[22,"Total Non-Interest Income (2) (3)",{"$nulls":3},{"$f":"F30+F37+F38+F44+F49+F52+F56+F57+F58+F59","v":0},{"$f":"G30+G37+G38+G44+G49+G52+G56+G57+G58+G59","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(F61:I61)","v":0},{"$f":"SUM(J61:M61)","v":0},null,{"$f":"SUM(S45:S59)+SUM(S30:S38)","v":0},null,{"$f":"SUM(G61:J61)","v":0},{"$f":"SUM(K61:N61)","v":0}]
[]
[23,"Optional Immaterial Segment Revenues (9)",{"$nulls":18},{"$f":"SUM(G63:J63)","v":0},{"$f":"SUM(K63:N63)","v":0}]
[]
[24,"Total Revenues",{"$nulls":3},{"$f":"F27+F61+F63","v":0},{"$f":"G27+G61+G63","v":0},0,0,0,0,0,0,0,0,0,0,{"$nulls":3},{"$f":"SUM(G65:J65)","v":0},{"$f":"SUM(K65:N65)","v":0}]
[]
[null,"Non Interest Expense by Business Segment:"]
[25,"Compensation Expense (8)",{"$nulls":3},{"$f":"SUM(F70:F73)","v":0},{"$f":"SUM(G70:G73)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(F68:I68)","v":0},{"$f":"SUM(J68:M68)","v":0},null,{"$f":"SUM(J68:M68)","v":0},null,{"$f":"SUM(G68:J68)","v":0},{"$f":"SUM(K68:N68)","v":0}]
[null,"Base Pay",{"$nulls":3},{"$f":"SUM(F70:F72)","v":0},{"$f":"SUM(G70:G72)","v":0},0,0,0,0,0,0,0,{"$nulls":6},0,0]
["25A","Salary Expense (cash incl. deferred)",{"$nulls":13},{"$f":"SUM(F70:I70)","v":0},{"$f":"SUM(J70:M70)","v":0},{"$nulls":3},0,0]
["25B","Benefits Expense",{"$nulls":13},0,0,{"$nulls":3},0,0]
["25C","Stock Based Compensation",{"$nulls":13},0,0,null,{"$f":"SUM(J72:M72)","v":0},null,0,0]
["25D","Variable Pay (cash and stock, current and deferred)",{"$nulls":13},0,0,{"$nulls":3},0,0]
[26,"Operational Risk Expense",{"$nulls":3},{"$f":"'[1]Projected Op Risk Losses'!B10","v":0},{"$f":"'[1]Projected Op Risk Losses'!C10","v":0},{"$f":"'[1]Projected Op Risk Losses'!D10","v":0},{"$f":"'[1]Projected Op Risk Losses'!E10","v":0},{"$f":"'[1]Projected Op Risk Losses'!F10","v":0},{"$f":"'[1]Projected Op Risk Losses'!G10","v":0},{"$f":"'[1]Projected Op Risk Losses'!H10","v":0},{"$f":"'[1]Projected Op Risk Losses'!I10","v":0},{"$f":"'[1]Projected Op Risk Losses'!J10","v":0},null,0,0,{"$nulls":3},0,0]
[27,"Litigation Expense & Penalties (list only if not included in item 26)",{"$nulls":13},0,0,{"$nulls":3},0,0]
[28,"Occupancy Expense",{"$nulls":18},0,0]
[29,"Professional and Outside Service Expense",{"$nulls":18},0,0]
[30,"Other Non-Interest Expense (4)(5)",{"$nulls":13},{"$f":"SUM(F78:I78)","v":0},{"$f":"SUM(J78:M78)","v":0},null,{"$f":"SUM(J78:M78)","v":0},null,0,0]
[]
[31,"Total Non-Interest Expense (2) (4)",{"$nulls":3},{"$f":"SUM(F70:F78)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(P70:P78)","v":0},{"$f":"SUM(Q70:Q78)","v":0},null,{"$f":"SUM(S68:S78)","v":0},null,{"$f":"SUM(G80:J80)","v":0},{"$f":"SUM(K80:N80)","v":0}]
[]
[32,"Projected PPNR [item 24 - item 31] (6)",{"$nulls":3},{"$f":"F65-F80","v":0},{"$f":"G65-G80","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(F82:I82)","v":0},{"$f":"SUM(J82:M82)","v":0},null,{"$f":"S27+S61-S80","v":0},null,{"$f":"SUM(G82:J82)","v":0},{"$f":"SUM(K82:N82)","v":0}]
[]
[33,"Valuation Adjustment for firm's own debt under fair value option (FVO)",{"$nulls":13},{"$f":"SUM(F84:I84)","v":0},{"$f":"SUM(J84:M84)","v":0},null,{"$f":"SUM(J84:M84)","v":0},null,{"$f":"SUM(G84:J84)","v":0},{"$f":"SUM(K84:N84)","v":0}]
[34,"Loss resulting from trading shock exercise (if applicable) (11)",{"$nulls":3},{"$f":"'[1]Income Statement Worksheet'!G68","v":0},{"$f":"'[1]Income Statement Worksheet'!H68","v":0},{"$f":"'[1]Income Statement Worksheet'!I68","v":0},{"$f":"'[1]Income Statement Worksheet'!J68","v":0},{"$f":"'[1]Income Statement Worksheet'!K68","v":0},{"$f":"'[1]Income Statement Worksheet'!L68","v":0},{"$f":"'[1]Income Statement Worksheet'!M68","v":0},{"$f":"'[1]Income Statement Worksheet'!N68","v":0},{"$f":"'[1]Income Statement Worksheet'!O68","v":0},null,{"$f":"SUM(F85:I85)","v":0},{"$f":"SUM(J85:M85)","v":0},null,{"$f":"SUM(J85:M85)","v":0},null,{"$f":"SUM(G85:J85)","v":0},{"$f":"SUM(K85:N85)","v":0}]
[35,"Goodwill Impairment",null,"RIADC216",{"$nulls":11},{"$f":"SUM(F86:I86)","v":0},{"$f":"SUM(J86:M86)","v":0},null,{"$f":"SUM(J86:M86)","v":0},null,{"$f":"SUM(G86:J86)","v":0},{"$f":"SUM(K86:N86)","v":0}]
[{"$f":"A86+1","v":36},"One Time Items - Revenues (2)",{"$nulls":3},{"$f":"SUM(F95:F97)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(F87:I87)","v":0},{"$f":"SUM(J87:M87)","v":0},null,{"$f":"SUM(J87:M87)","v":0},null,{"$f":"SUM(G87:J87)","v":0},{"$f":"SUM(K87:N87)","v":0}]
[{"$f":"A87+1","v":37},"One Time Items - Expenses (2)",{"$nulls":3},{"$f":"SUM(F99:F101)","v":0},{"$f":"SUM(G99:G101)","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(F88:I88)","v":0},{"$f":"SUM(J88:M88)","v":0},null,{"$f":"SUM(J88:M88)","v":0},null,{"$f":"SUM(G88:J88)","v":0},{"$f":"SUM(K88:N88)","v":0}]
[]
[]
["Footnotes to the PPNR Submission Worksheet"]
["(1)","Amount should equal item 37 of the Net Interest Income Worksheet, if completed. "]
["(2)","One-time items are material non-recurring and infrequent items.  Exclude such items from items 22-23 and 31 and report in items 36 and 37. Examples of one time items include gains or losses on sales of business lines, gains or losses on extinguishment of debt, gains or losses on mergers / joint ventures, etc. Break out these excluded items here:"]
[null,"One Time Items - Revenues"]
[{"$nulls":20},{"$f":"SUM(G95:J95)","v":0},{"$f":"SUM(K95:N95)","v":0}]
[{"$nulls":20},{"$f":"SUM(G96:J96)","v":0},{"$f":"SUM(K96:N96)","v":0}]
[{"$nulls":20},{"$f":"SUM(G97:J97)","v":0},{"$f":"SUM(K97:N97)","v":0}]
[null,"One Time Items - Expense"]
[{"$nulls":20},{"$f":"SUM(G99:J99)","v":0},{"$f":"SUM(K99:N99)","v":0}]
[{"$nulls":20},{"$f":"SUM(G100:J100)","v":0},{"$f":"SUM(K100:N100)","v":0}]
[{"$nulls":20},{"$f":"SUM(G101:J101)","v":0},{"$f":"SUM(K101:N101)","v":0}]
["(3)","Excludes Valuation Adjustment for firm's own debt under fair value option (FVO) and trading shock loss in items 33 and 34. "]
["(4)","Excludes Goodwill Impairment included in item 35 "]
["(5)","Provide a further break out of significant items included in Other Non-Interest Expense:"]
[{"$nulls":20},{"$f":"SUM(G105:J105)","v":0},{"$f":"SUM(K105:N105)","v":0}]
[{"$nulls":20},{"$f":"SUM(G106:J106)","v":0},{"$f":"SUM(K106:N106)","v":0}]
[{"$nulls":20},{"$f":"SUM(G107:J107)","v":0},{"$f":"SUM(K107:N107)","v":0}]
[{"$nulls":20},{"$f":"SUM(G108:J108)","v":0},{"$f":"SUM(K108:N108)","v":0}]
["(6)","By definition, PPNR will calculate as Net Interest Income plus Non-Interest Income less Non-Interest Expense for both material and immaterial segments, excluding items broken out in items 33-37. Other items, such as one time items (included in note 2 above), will be separately considered. "]
["(7)","Complete on a best efforts basis if the worksheet has been designated as \"Supplementary Net Interest Income\""]
["(8)","Report commissions in category which is most consistent with internal reporting practice and provide supporting documentation and data in the accompanying memo for FR Y-14A."]
["(9)","See instructions for guidance on related thresholds."]
["(10)","Exclude result of trading shock exercise (where applicable), as it is reported in item 34"]
["(11)","BHCs should not report changes in value of the MSR asset or hedges within the trading book"]
[]
[null,"The following cells provide checks of the internal consistency of the PPNR Template schedules. Please ensure that these cells are all \"TRUE,\" or \"N/A\" before the worksheet is submitted."]
[null,"Net Interest Income agrees between worksheets",{"$nulls":3},{"$f":"IF('[1]PPNR NII Worksheet'!D89=0,\"N/A\",'[1]PPNR Projections Worksheet'!F27='[1]PPNR NII Worksheet'!D89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!E89=0,\"N/A\",'[1]PPNR Projections Worksheet'!G27='[1]PPNR NII Worksheet'!E89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!F89=0,\"N/A\",'[1]PPNR Projections Worksheet'!H27='[1]PPNR NII Worksheet'!F89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!G89=0,\"N/A\",'[1]PPNR Projections Worksheet'!I27='[1]PPNR NII Worksheet'!G89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!H89=0,\"N/A\",'[1]PPNR Projections Worksheet'!J27='[1]PPNR NII Worksheet'!H89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!I89=0,\"N/A\",'[1]PPNR Projections Worksheet'!K27='[1]PPNR NII Worksheet'!I89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!J89=0,\"N/A\",'[1]PPNR Projections Worksheet'!L27='[1]PPNR NII Worksheet'!J89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!K89=0,\"N/A\",'[1]PPNR Projections Worksheet'!M27='[1]PPNR NII Worksheet'!K89)","v":"N/A"},{"$f":"IF('[1]PPNR NII Worksheet'!L89=0,\"N/A\",'[1]PPNR Projections Worksheet'!N27='[1]PPNR NII Worksheet'!L89)","v":"N/A"}]
[null,"Immaterial revenues are less than or equal to 10% of total revenue",{"$nulls":3},{"$f":"IF(F65=0,\"N/A\",IF(F63/F65>10%,FALSE,TRUE))","v":"N/A"},{"$f":"IF(G65=0,\"N/A\",IF(G63/G65>10%,FALSE,TRUE))","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A",{"$f":"IF(O65=0,\"N/A\",IF(O63/O65>10%,\"10% Cap Exceeded!\",\"OK\"))","v":"N/A"},{"$f":"IF(P65=0,\"N/A\",IF(P63/P65>10%,\"10% Cap Exceeded!\",\"OK\"))","v":"N/A"},{"$f":"IF(Q65=0,\"N/A\",IF(Q63/Q65>10%,\"10% Cap Exceeded!\",\"OK\"))","v":"N/A"}]

{"sheet":"PPNR NII Worksheet","index":19,"n_rows":102,"n_cols":12,"rows_kept":102,"merged":[[0,1,0,11],[1,1,1,11],[4,1,4,3],[5,1,5,3],[7,4,7,7],[7,8,7,11]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"Net Interest Income Worksheet:\"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank Net Interest Income Worksheet: in Baseline"}]
[null,"Instructions: All Banks for which deposits comprise one-third or more of total liabilities for any reported period must complete this worksheet. Banks are to complete non shaded cells only; all shaded cells with embedded formulas will self populate.  For items designated as supplementary, Banks are to complete the items as designated in the instructions. Flow quarterly items should be reported by quarter, and not on a cumulative basis."]
[]
[null,"WARNING: MACROS MUST BE ENABLED TO USE THIS SCHEDULE"]
[null,{"$f":"IF(CHOICE=PRIMARY_CHOOSE,\"Specify reporting designation for net interest income on PPNR Submission Worksheet\",IF(CHOICE=PRIMARY_SUBMISSION,PRIMARY_NII,PRIMARY_SUBMISSION))","v":"Specify reporting designation for net interest income on PPNR Submission Worksheet"}]
[null,{"$f":"IF(DEPOSIT_LIMIT=NII_MANDATORY,\"Deposits more than one-third of liabilities: mandatory reporting\",IF(DEPOSIT_LIMIT=NII_OPTIONAL,\"Deposits less than one-third of liabilities: optional reporting\",\"Please indicate on the PPNR Submission worksheet if deposits are one-third or more of total liabilities\"))","v":"Please indicate on the PPNR Submission worksheet if deposits are one-third or more of total liabilities"}]
[]
[{"$nulls":3},"Projected ","2012 Projections",{"$nulls":3},"2013 Projections"]
[null,"Average Interest-Bearing Asset Balances ($ Mil) (1)",null,"Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014"]
[1,"First Lien Mortgages"]
[2,"Second / Junior Lien Mortgages"]
["2A","Closed-End Junior Liens (5)"]
["2B","Home Equity Lines Of Credit (HELOCs) (5)"]
[3,"C&I Loans"]
[4,"CRE Loans"]
[5,"Credit Cards"]
[6,"Other Consumer"]
["6A","Auto Loans (5)"]
["6B","Student Loans (5)"]
["6C","Other (5)"]
["6D","Small Business (Scored/Delinquency Managed) (5)"]
[7,"Other Loans & Leases"]
[8,"Interest-Bearing Securities (AFS, HTM, and/or Trading Assets) "]
[9,"Deposits with Banks & Other "]
[]
[null,"Average Rates Earned (%)"]
[10,"First Lien Mortgages"]
[11,"Second / Junior Lien Mortgages"]
["11A","Closed-End Junior Liens (5)"]
["11B","HELOCs (5)"]
[12,"C&I Loans"]
[13,"CRE Loans"]
[14,"Credit Cards"]
[15,"Other Consumer"]
["15A","Auto Loans (5)"]
["15B","Student Loans (5)"]
["15C","Other  (5)"]
["15D","Small Business (Scored/Delinquency Managed) (5)"]
[16,"Other Loans & Leases"]
[17,"Interest-Bearing Securities  (AFS, HTM, and/or Trading)"]
[18,"Deposits with Banks & Other "]
[]
[19,"Interest Income from above",null,{"$f":"IF(CHOICE=PRIMARY_NII,(D10*D27+D12*D29+D13*D30+D14*D31+D15*D32+D16*D33+D18*D35+D19*D36+D20*D37+D21*D38+D22*D39+D23*D40+D24*D41)/4,(D10*D27 + D11*D28 + D14*D31 + D15*D32 + D16*D33 + D17*D34 + D22*D39 + D23*D40 + D24*D41)/4)","v":0},0,0,0,0,0,0,0,0]
[20,"Other Interest Income (2) "]
[]
[21,"Total Interest Income ",null,{"$f":"D43+D44","v":0},{"$f":"E43+E44","v":0},0,0,{"$f":"H43+H44","v":0},0,0,0,0]
[]
[null,"Average Interest-Bearing Liability Balance ($ Mil)"]
[22,"Customer Deposits-Domestic"]
["22A","Non-Interest-Bearing Demand (5)"]
["22B","Money Market Accounts (5)"]
["22C","Savings (5)"]
["22D","NOW, ATS, and other Transaction Accounts (5)"]
["22E","Time Deposits (5)"]
[23,"Customer Deposits-Foreign"]
["23A","Foreign Deposits (5)"]
["23B","Foreign Deposits-Time (5)"]
[24,"Fed Funds, Repos, & Other Short Term Borrowing"]
["24A","Fed Funds (5)"]
["24B","Repos (5)"]
["24C","Other Short Term Borrowing (5)"]
[25,"Trading Liabilities"]
[26,"Subordinated Notes Payable to Unconsolidated Trusts Issuing Trust Preferred Securities (TruPS) and TruPS Issued by Consolidated Special Purpose Entities"]
[27,"All Other Long Term Debt"]
[]
[null,"Average Liability Rates (%)"]
[28,"Customer Deposits-Domestic"]
["28A","Non-Interest-Bearing Demand (5)"]
["28B","Money Market Accounts (5)"]
["28C","Savings (5)"]
["28D","Negotiable Order of Withdrawal (NOW), Automatic Transfer Service (ATS), and other Transaction Accounts (5)"]
["28E","Time Deposits (5)"]
[29,"Customer Deposits-Foreign"]
["29A","Foreign Deposits (5)"]
["29B","Foreign Deposits-Time (5)"]
[30,"Fed Funds, Repos, & Other Short Term Borrowing"]
["30A","Fed Funds (5)"]
["30B","Repos (5)"]
["30C","Other Short Term Borrowing (5)"]
[31,"Trading Liabilities"]
[32,"Subordinated Notes Payable to Unconsolidated Trusts Issuing TruPS and TruPS Issued by Consolidated Special Purpose Entities"]
[33,"All Other Long Term Debt"]
[]
[34,"Interest Expense from above",null,{"$f":"IF(CHOICE=PRIMARY_NII,(D50*D68+D51*D69+D52*D70+D53*D71+D54*D72+D56*D74+D57*D75+D59*D77+D60*D78+D61*D79+D62*D80+D63*D81+D64*D82)/4,(D49*D67 + D55*D73 + D58*D76 + D62*D80 + D63*D81 + D64*D82)/4)","v":0},0,0,0,0,0,0,0,0]
[35,"Other Interest Expense (3) "]
[]
[36,"Total Interest Expense ",null,{"$f":"D84+D85","v":0},0,0,0,0,0,0,0,0]
[]
[37,"Total Net Interest Income (4)",null,{"$f":"D46-D87","v":0},{"$f":"E46-E87","v":0},0,0,0,0,0,0,0]
[]
["Footnotes to the Net Interest Income Worksheet"]
["(1)","Exclude nonaccrual loans, reporting these balances in item 56 of the PPNR Metrics Worksheet. Include purchased credit impaired loans."]
["(2)","Break out and explain nature of significant items included in Other Interest Income."]
[]
[]
[]
["(3)","Break out and explain nature of significant items included in Other Interest Expense."]
[]
[]
[]
["(4)","Amount should equal item 11 of the PPNR Submission Worksheet."]
["(5)","Complete on a best efforts basis if the worksheet has been designated as \"Supplementary Net Interest Income\""]

{"sheet":"PPNR Metrics Worksheet","index":20,"n_rows":176,"n_cols":18,"rows_kept":176,"merged":[[0,1,0,16],[3,6,3,14],[4,7,4,10],[4,11,4,14],[4,16,4,17],[162,1,162,14],[168,1,168,14]]}
[null,{"$f":"'Summary Submission Cover Sheet'!$D$15&\" \"&\"PPNR Metrics Worksheet:\"&'Summary Submission Cover Sheet'!$D$12&\" in \"&'Summary Submission Cover Sheet'!B20","v":"Bank PPNR Metrics Worksheet: in Baseline"}]
[null,"Instructions: Banks are to complete non shaded cells only.  Flow quarterly items should be reported by quarter, and not on a cumulative basis. "]
[null,"WARNING: MACROS MUST BE ENABLED TO USE THIS SCHEDULE"]
[]
[{"$nulls":6},"Projected ","2012 Projections",{"$nulls":3},"2013 Projections",{"$nulls":4},"Amounts "]
[null,null,"Call Report Codes",null,"Units",null,"Q4 2012","Q1 2013","Q2 2013","Q3 2013","Q4 2013","Q1 2014","Q2 2014","Q3 2014","Q4 2014",null,2013,2014]
[null,"Metrics by Business Segment (6)"]
[null,"Retail and Small Business Segment"]
[null,"Domestic"]
[null,"Credit Cards"]
[1,"Credit Card Interchange Revenues - Gross (exclude charge cards) (12)",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H11:K11)","v":0},{"$f":"SUM(L11:O11)","v":0}]
[2,"Credit Card Purchase Volume (exclude charge cards) (12)",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H12:K12)","v":0},{"$f":"SUM(L12:O12)","v":0}]
[null,"Mortgages"]
[3,"Average Third-Party Residential Mortgages Serviced (7) (8)",null,null,"$ Mil"]
[4,"Production Revenues - Gross (1)",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H15:K15)","v":0},{"$f":"SUM(L15:O15)","v":0}]
[5,"Servicing Revenue - Net (2) ",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H16:K16)","v":0},{"$f":"SUM(L16:O16)","v":0}]
[null,"Retail and Small Business Banking"]
[6,"Debit Card Interchange - Gross",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H18:K18)","v":0},{"$f":"SUM(L18:O18)","v":0}]
[7,"Debit Card Purchase Volume",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H19:K19)","v":0},{"$f":"SUM(L19:O19)","v":0}]
[null,"International Retail and Small Business (3)"]
[8,"Credit Card Revenues (3)",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H21:K21)","v":0},{"$f":"SUM(L21:O21)","v":0}]
[null,"Investment Banking Segment"]
[9,"Compensation - Total",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H23:K23)","v":0},{"$f":"SUM(L23:O23)","v":0}]
[10,"Compensation - Variable Pay (cash and stock, current and deferred)",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H24:K24)","v":0},{"$f":"SUM(L24:O24)","v":0}]
[null,"Advisory"]
[11,"Average Fee Rate (7)",null,null,"%"]
[12,"Deal Volume",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H27:K27)","v":0},{"$f":"SUM(L27:O27)","v":0}]
[13,"Number of Deals",null,null,"#",{"$nulls":11},{"$f":"SUM(H28:K28)","v":0},{"$f":"SUM(L28:O28)","v":0}]
[14,"Market Share (5) (7)",null,null,"%"]
[null,"Equity Underwriting"]
[15,"Average Fee Rate (7)",null,null,"%"]
[16,"Deal Volume",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H32:K32)","v":0},{"$f":"SUM(L32:O32)","v":0}]
[17,"Market Share (5) (7)",null,null,"%"]
[null,"Debt Underwriting"]
[18,"Average Fee Rate (7)",null,null,"%"]
[19,"Deal Volume",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H36:K36)","v":0},{"$f":"SUM(L36:O36)","v":0}]
[20,"Market Share (5) (7)",null,null,"%"]
[null,"Corporate Lending"]
[21,"Average Fee Rate (7)",null,null,"%"]
[22,"Deal Volume",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H40:K40)","v":0},{"$f":"SUM(L40:O40)","v":0}]
[23,"Market Share (5) (7)",null,null,"%"]
[null,"Merchant Banking / Private Equity"]
[24,"AUM",null,null,"$ Mil",{"$nulls":11},{"$f":"K43","v":0},{"$f":"O43","v":0}]
[null,"Sales and Trading Segment"]
[25,"Total Proprietary Trading Revenues",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H45:K45)","v":0},{"$f":"SUM(L45:O45)","v":0}]
[26,"Compensation - Total",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H46:K46)","v":0},{"$f":"SUM(L46:O46)","v":0}]
[27,"Compensation - Variable Pay (cash and stock, current and deferred)",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H47:K47)","v":0},{"$f":"SUM(L47:O47)","v":0}]
[null,"Equities"]
[28,"Commission and Fees",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H49:K49)","v":0},{"$f":"SUM(L49:O49)","v":0}]
[29,"Average Asset Balance (7)",null,null,"$ Mil"]
[null,"Fixed Revenues"]
[30,"Commission and Fees",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H52:K52)","v":0},{"$f":"SUM(L52:O52)","v":0}]
[31,"Average Asset Balance (7)",null,null,"$ Mil"]
[null,"Commodities"]
[32,"Commission and Fees",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H55:K55)","v":0},{"$f":"SUM(L55:O55)","v":0}]
[33,"Average Asset Balance (7)",null,null,"$ Mil"]
[null,"Prime Brokerage"]
[34,"Average Client Balances (7)",null,null,"$ Mil"]
[35,"Transaction Volume",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H59:K59)","v":0},{"$f":"SUM(L59:O59)","v":0}]
[null,"Investment Management Segment"]
[null,"Asset Management"]
[36,"AUM - Total",null,null,"$ Mil",null,{"$f":"SUM(G63+G64)","v":0},{"$f":"SUM(H63+H64)","v":0},0,0,0,0,0,0,0,null,{"$f":"K62","v":0},{"$f":"O62","v":0}]
[37,"AUM - Equities",null,null,"$ Mil",{"$nulls":11},{"$f":"K63","v":0},{"$f":"O63","v":0}]
[38,"AUM - Other",null,null,"$ Mil",{"$nulls":11},{"$f":"K64","v":0},{"$f":"O64","v":0}]
[39,"Net Inflows/Outflows",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H65:K65)","v":0},{"$f":"SUM(L65:O65)","v":0}]
[null,"Wealth Management/Private Banking"]
[40,"AUM",null,null,"$ Mil",{"$nulls":11},{"$f":"K67","v":0},{"$f":"O67","v":0}]
[41,"Net Inflows/Outflows",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H68:K68)","v":0},{"$f":"SUM(L68:O68)","v":0}]
[42,"Number of Financial Advisors ",null,null,"#",{"$nulls":11},{"$f":"K69","v":0},{"$f":"O69","v":0}]
[null,"Investment Services Segment "]
[null,"Asset Servicing"]
[43,"Assets under Custody and Administration",null,null,"$ Mil",{"$nulls":11},{"$f":"K72","v":0},{"$f":"O72","v":0}]
[44,"Securities Lending Revenue ",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H73:K73)","v":0},{"$f":"SUM(L73:O73)","v":0}]
[null,"Issuer Services"]
[45,"Number of Deals Administered",null,null,"#",{"$nulls":11},{"$f":"SUM(H75:K75)","v":0},{"$f":"SUM(L75:O75)","v":0}]
[null,"Treasury Services Segment"]
[46,"Average Interest Rate Spread between Loan and Deposit Yields (10)",null,null,"%"]
[]
[null,"Firm Wide Metrics"]
[47,"Number of Employees","BHCK4150",null,"#",{"$nulls":11},{"$f":"K80","v":0},{"$f":"O80","v":0}]
[null,"Revenues - International",null,null,"$ Mil",{"$nulls":11},{"$f":"SUM(H81:K81)","v":0},{"$f":"SUM(L81:O81)","v":0}]
[48,"Revenues - APAC (4)",null,null,"$ Mil",{"$nulls":11},0,0]
[49,"Revenues - EMEA (4)",null,null,"$ Mil",{"$nulls":11},0,0]
[50,"Revenues - LatAm (4)",null,null,"$ Mil",{"$nulls":11},0,0]
[51,"Revenues - Canada (4)",null,null,"$ Mil",{"$nulls":11},0,0]
[52,"Revenues - Domestic ",null,null,"$ Mil",null,{"$f":"'[1]PPNR Projections Worksheet'!F65-G81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!G65-H81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!H65-I81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!I65-J81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!J65-K81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!K65-L81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!L65-M81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!M65-N81","v":0},{"$f":"'[1]PPNR Projections Worksheet'!N65-O81","v":0},null,0,0]
[53,"OREO Balances","BHCK2150",null,"$ Mil",{"$nulls":11},{"$f":"K87","v":0},{"$f":"O87","v":0}]
[]
[null,"Metrics for Net Interest Income Worksheet (Required only for BHCs that were required to complete the Net Interest Income Worksheet)"]
[54,"Nonaccrual Loan Balance","BHCK5526-BHCK3507",null,"$ Mil",{"$nulls":11},{"$f":"K90","v":0},{"$f":"O90","v":0}]
[55,"Carrying Value of Purchased Credit Impaired (PCI) Loans","BHCKC780",null,"$ Mil",{"$nulls":11},{"$f":"K91","v":0},{"$f":"O91","v":0}]
[56,"Net Accretion of discount on PCI Loans included in interest Revenues",null,null,"$ Mil",{"$nulls":11},{"$f":"K92","v":0},{"$f":"O92","v":0}]
[]
[null,"Metrics for Primary Net Interest Income "]
[null,"Quarter End Weighted Average Life of Assets (9)"]
[57,"First Lien Mortgages",null,null,"months"]
[58,"Closed-End Junior Liens",null,null,"months"]
[59,"HELOCs",null,null,"months"]
[60,"C&I Loans",null,null,"months"]
[61,"CRE Loans",null,null,"months"]
[62,"Credit Cards",null,null,"months"]
[63,"Auto Loans",null,null,"months"]
[64,"Student Loans",null,null,"months"]
[65,"Other (13)",null,null,"months"]
[66,"Small Business (Scored/Delinquency Managed)",null,null,"months"]
[67,"Other Loans & Leases",null,null,"months"]
[68,"Interest-Bearing Securities (AFS, HTM, and/or Trading)",null,null,"months"]
[]
[null,"Quarter End Weighted Average Life of Liabilities (9)"]
[69,"Domestic Time Deposits",null,null,"months"]
[70,"Foreign Deposits-Time",null,null,"months"]
[71,"Fed Funds ",null,null,"months"]
[72,"Repos",null,null,"months"]
[73,"Other Short Term Borrowing",null,null,"months"]
[74,"Trading Liabilities",null,null,"months"]
[75,"Subordinated Notes Payable to Unconsolidated Trusts Issuing TruPS and TruPS Issued by Consolidated Special Purpose Entities",null,null,"months"]
[76,"All Other Long Term Debt",null,null,"months"]
[]
[null,"Retail Deposit Repricing Beta in a \"Normal Environment\" (11)",{"$nulls":4},"For upward rate movements","For downward rate movements","Assumed Floor"]
[77,"Money Market Accounts  "]
[78,"Savings"]
[79,"NOW, ATS, and other Transaction Accounts"]
[80,"Time Deposits"]
[]
[]
[null,"Metrics for Supplementary Net Interest Income "]
[null,"Quarter End Weighted Average Life of Assets (9) (14)"]
[81,"First Lien Mortgages",null,null,"months"]
[82,"Second / Junior Lien Mortgages",null,null,"months"]
["82A","Closed-End Junior Liens",null,null,"months"]
["82B","Home Equity Lines Of Credit (HELOCs)",null,null,"months"]
[83,"C&I Loans",null,null,"months"]
[84,"CRE Loans",null,null,"months"]
[85,"Credit Cards",null,null,"months"]
[86,"Other Consumer",null,null,"months"]
["86A","Auto Loans ",null,null,"months"]
["86B","Student Loans",null,null,"months"]
["86C","Other",null,null,"months"]
["86D","Small Business (Scored/Delinquency Managed)",null,null,"months"]
[87,"Other Loans & Leases",null,null,"months"]
[88,"Interest-Bearing Securities (AFS, HTM, and/or Trading Assets)",null,null,"months"]
[{"$nulls":4},"months"]
[null,"Quarter End Weighted Average Life of Liabilities (9) (14)"]
[89,"Domestic Time Deposits",null,null,"months"]
[90,"Foreign Deposits-Time"]
[91,"Fed Funds, Repos, & Other Short Term Borrowing",null,null,"months"]
["91A","Fed Funds",null,null,"months"]
["91B","Repos",null,null,"months"]
["91C","Other Short Term Borrowing ",null,null,"months"]
[92,"Trading Liabilities",null,null,"months"]
[93,"Subordinated Notes Payable to Unconsolidated Trusts Issuing Trust Preferred Securities (TruPS) and TruPS Issued by Consolidated Special Purpose Entities",null,null,"months"]
[94,"All Other Long Term Debt",null,null,"months"]
[]
[null,"Retail Deposit Repricing Beta in a \"Normal Environment\" (11)",{"$nulls":4},"For upward rate movements","For downward rate movements","Assumed Floor"]
[95,"Money Market Accounts  "]
[96,"Savings"]
[97,"NOW, ATS, and other Transaction Accounts"]
[98,"Time Deposits"]
[]
[null,"Footnotes to the PPNR Metrics Worksheet"]
[null,"(1) Revenues associated with residential mortgage production, including originations, sales of mortgage loans, and related hedging activities.  Do not include impact from repurchase provisions related to representations and warranties."]
[null,"(2) Revenues associated with servicing residential mortgage loans held by others, MSRs, and related hedging activities."]
[null,"(3) Provide metrics data for all quarters, but only if International Retail and Small Business Segment revenues exceeded 5% of Total Retail and Small Business Segment and Total Retail and Small Business revenue exceeded 5% of total revenues in any of the last four actual quarters requested in the PPNR schedule.  "]
[null,"(4) Provide regional breakouts for all quarters but only if international revenue exceeded 5% of the total revenue in any of the last four actual quarters requested in the PPNR schedule."]
[null,"(5) The market share is a percent of a global market defined as the total dollar volume of deals."]
[null,"(6) See instructions for guidance on related thresholds."]
[null,"(7) Annual numbers for all average balances, average rates, and all market shares should be reported only if the annual averages are not equal to a simple average of the four quarters for a given year."]
[null,"(8) Average oustanding principal balance fo residential mortgage loans the BHC services for others."]
[null,"(9) The Weighted Average Life should be calculated based on the expected remaining lives, inclusive of behavioral assumptions.  It should reflect the weighted average of time to principal actual repayment (as modeled) for all positions in that portfolio, rounded to the nearest monthly term."]
[null,"(10) A spread between the interest rates charged on loans (e.g. working capital loans) and interest rates paid on Treasury Services customer deposit balances."]
[null,"(11) A rate movement in an environment where the repricing assumption assumed by each of the major deposit products is not restricted by a cap, floor, or zero."]
[null,"(12) Include revenues earned on BHC issued cards as well as a result of a partnership agreement."]
[null,"(13) Corresponds to line item 6C Other on the Net Interest Income worksheet"]
[null,"(14) Complete on a best efforts basis if the worksheet has been designated as \"Supplementary Net Interest Income\""]
[]
[null,"Do international revenues exceed 5% of total revenues?",{"$nulls":4},{"$f":"IF('[1]PPNR Projections Worksheet'!F65=0,\"N/A\",IF(G81/'[1]PPNR Projections Worksheet'!F65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!G65=0,\"N/A\",IF(H81/'[1]PPNR Projections Worksheet'!G65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!H65=0,\"N/A\",IF(I81/'[1]PPNR Projections Worksheet'!H65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!I65=0,\"N/A\",IF(J81/'[1]PPNR Projections Worksheet'!I65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!J65=0,\"N/A\",IF(K81/'[1]PPNR Projections Worksheet'!J65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!K65=0,\"N/A\",IF(L81/'[1]PPNR Projections Worksheet'!K65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!L65=0,\"N/A\",IF(M81/'[1]PPNR Projections Worksheet'!L65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!M65=0,\"N/A\",IF(N81/'[1]PPNR Projections Worksheet'!M65>5%,\"Yes\", \"No\"))","v":"N/A"},{"$f":"IF('[1]PPNR Projections Worksheet'!N65=0,\"N/A\",IF(O81/'[1]PPNR Projections Worksheet'!N65>5%,\"Yes\", \"No\"))","v":"N/A"}]