Download:
pdf |
pdfxx/xx/20xx
FDIC DFAST 10-50 - Summary Schedule
Summary Schedule for XYZ
FDIC CERT#####
(Dollar Amounts in Thousands)
Scenario Summaries
031 Call Rpt Item
041 Call Rpt Item
RIAD4635 - RIAD4605
RIAD4635 - RIAD4605
RIAD4074 + RIAD4079 RIAD4093
RIAD4340
Actual
Projected
As of 9/30
As of 12/31
Year 1: 2014 -- Projected (in the quarter)
Q1
Q2
Q3
Year 2: 2015 -- Projected (in the quarter)
Q4
Q5
Q6
Q7
Q8
Baseline Scenario
1
Total loan and lease net charge-offs
2
Pre-provision net revenue
3
Net income
RIAD4074 + RIAD4079 RIAD4093
RIAD4340
4
Allowance for loan and lease losses
RCFD3123
5
Total assets
RCFD2170
6
8
Total liabilities
Dividends,share repurchases, and sale,
conversion, acquisition, or retirement of capital
Total equity capital
9
Tier 1 risk-based capital ratio
7
10
11
Tier 1 leverage ratio
Total risk-based capital ratio
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
0
0
0
RCON3123
0
0
0
0
0
0
0
0
0
0
RCON2170
0
0
0
0
0
0
0
0
0
0
RCFD2948
RCON2948
0
0
0
0
0
0
0
0
0
0
(RIADB509 + RIADB510) (RIAD4470 + RIAD4460)
RCFDG105
(RIADB509 + RIADB510) (RIAD4470 + RIAD4460)
RCONG105
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Total Risk-based Capital
/ RWA) * 100
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Total Risk-based Capital
/ RWA) * 100
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
RIAD4635 - RIAD4605
RIAD4635 - RIAD4605
0
0
0
0
0
0
0
0
0
0
RIAD4074 + RIAD4079 RIAD4093
RIAD4340
0
0
0
0
0
0
0
0
0
0
Adverse Scenario
12
Total loan and lease net charge-offs
13
Pre-provision net revenue
14
Net income
RIAD4074 + RIAD4079 RIAD4093
RIAD4340
0
0
0
0
0
0
0
0
0
0
15
Allowance for loan and lease losses
RCFD3123
RCON3123
0
0
0
0
0
0
0
0
0
0
16
Total assets
RCFD2170
RCON2170
0
0
0
0
0
0
0
0
0
0
17
RCFD2948
RCON2948
0
0
0
0
0
0
0
0
0
0
(RIADB509 + RIADB510) (RIAD4470 + RIAD4460)
RCFDG105
(RIADB509 + RIADB510) (RIAD4470 + RIAD4460)
RCONG105
0
0
0
0
0
0
0
0
0
0
19
Total liabilities
Dividends,share repurchases, and sale,
conversion, acquisition, or retirement of capital
Total equity capital
20
Tier 1 risk-based capital ratio
21
Tier 1 leverage ratio
22
Total risk-based capital ratio
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Total Risk-based Capital
/ RWA) * 100
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Total Risk-based Capital
/ RWA) * 100
RIAD4635 - RIAD4605
RIAD4635 - RIAD4605
RIAD4074 + RIAD4079 RIAD4093
RIAD4340
18
0
0
0
0
0
0
0
0
0
0
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/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
0
0
0
0
Severely Adverse Scenario
23
Total loan and lease net charge-offs
24
Pre-provision net revenue
25
Net income
RIAD4074 + RIAD4079 RIAD4093
RIAD4340
26
Allowance for loan and lease losses
RCFD3123
RCON3123
0
0
0
0
0
0
0
0
0
0
27
Total assets
RCFD2170
RCON2170
0
0
0
0
0
0
0
0
0
0
28
RCFD2948
RCON2948
0
0
0
0
0
0
0
0
0
0
(RIADB509 + RIADB510) (RIAD4470 + RIAD4460)
RCFDG105
(RIADB509 + RIADB510) (RIAD4470 + RIAD4460)
RCONG105
0
0
0
0
0
0
0
0
0
0
30
Total liabilities
Dividends,share repurchases, and sale,
conversion, acquisition, or retirement of capital
Total equity capital
0
0
0
0
0
0
0
0
0
0
31
Tier 1 risk-based capital ratio
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Tier 1 leverage ratio
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
33
Total risk-based capital ratio
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Total Risk-based Capital
/ RWA) * 100
#DIV/0!
32
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Total Risk-based Capital
/ RWA) * 100
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
29
*Note: All values on this sheet will flow directly from the other schedules.
xx/xx/20xx
FDIC DFAST 10-50 - Baseline Scenario
Income Statement for XYZ
FDIC CERT#####
(Dollar Amounts in Thousands)
Income Statement Impacts
031 Call Rpt Item
041 Call Rpt Item
Actual
Projected
As of 9/30
As of 12/31
Year 1: 2014 -- Projected (in the quarter)
Q1
Q2
Q3
Year 2: 2015 -- Projected (in the quarter)
Q4
Q5
Q6
Q7
Q8
Net Charge-Offs
1
First lien mortgages
RIADC234 - RIADC217
RIADC234 - RIADC217
2
Closed-end junior liens
RIADC235 - RIADC218
RIADC235 - RIADC218
3
HELOCs
RIAD5411 - RIAD5412
RIAD5411 - RIAD5412
RIAD4638 - RIAD4608
4
C&I loans
(RIAD4645 + RIAD4646) (RIAD4617 + RIAD4618)
5
1-4 family construction loans
RIADC891 - RIADC892
RIADC891 - RIADC892
6
Other construction loans
RIADC893 - RIADC894
RIADC893 - RIADC894
7
Multifamily loans
RIAD3588 - RIAD3589
RIAD3588 - RIAD3589
8
Non-farm, non-residential owner occupied loans
RIADC895 - RIADC896
RIADC895 - RIADC896
9
Non-farm, non-residential other loans
RIADC897 - RIADC898
RIADC897 - RIADC898
10
Credit cards
RIADB514 - RIADB515
RIADB514 - RIADB515
11
Automobile loans
RIADK129 - RIADK133
RIADK129 - RIADK133
12
Other consumer
RIADK205 - RIADK206
RIADK205 - RIADK206
13
All other loans and leases
See instructions
See instructions
RIAD4635 - RIAD4605
RIAD4635 - RIAD4605
14
Total loan and lease net charge offs (sum of items 1 to 13)
15
Net interest income
RIAD4074
RIAD4074
16
Non-interest income
RIAD4079
RIAD4079
17
Non-interest expense
RIAD4093
RIAD4093
18
Pre-provision net revenue ( = item 15 + item 16 - item 17)
19
Provision for loan and lease losses
RIAD4230
RIAD4230
20
Realized gains (losses) on HTM securities
RIAD3521
RIAD3521
21
Realized gains (losses) on AFS securities
RIAD3196
RIAD3196
22
All other gains (losses)
See instructions
See instructions
23
Taxes
RIAD4302
RIAD4302
RIAD4340
RIAD4340
RIADJ319
RIADJ319
24
25
Net income (item 18 - item 19 + item 20 + item 21 + item 22 item 23)
Memoranda
Total other-than-temporary impairment (OTTI) losses
Itemize and describe amounts greater than 15% of non-interest income (item 16)
26
27
28
29
30
31
Itemize and describe amounts greater than 15% of non-interest expense (item 17)
32
33
34
35
36
37
Itemize and describe amounts greater than 15% of all other gains (losses) (item 22)
38
39
40
41
42
43
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
0
0
0
xx/xx/20xx
FDIC DFAST 10-50 - Baseline Scenario
Balance Sheet Statement for XYZ
FDIC CERT#####
(Dollar Amounts in Thousands)
Balance Sheet Statement Impacts
Loans (excluding FDIC Loss Sharing Agreements)
031 Call Rpt Item
041 Call Rpt Item
1 First lien mortgages
2 Closed-end junior liens
RCON5367 - RCONK173
RCON5367 - RCONK173
RCON5368 - RCONK174
RCON5368 - RCONK174
3 HELOCs
RCON1797 - RCONK172
RCON1797 - RCONK172
4 C&I loans
RCFD1763 + RCFD1764 RCFDK179
RCONF158 - RCONK169
RCON1766 - RCONK179
6 Other construction loans
RCONF159 - RCONK170
RCONF159 - RCONK170
7 Multifamily loans
8 Non-farm, non-residential owner occupied loans
RCON1460 - RCONK175
RCON1460 - RCONK175
5 1-4 family construction loans
RCONF160 - RCONK176
RCONF160 - RCONK176
RCONF161 - RCONK177
RCONF161 - RCONK177
RCFDB538 - RCFDK180
RCONB538 - RCONK180
11 Automobile loans
RCFDK137 - RCFDK181
RCONK137 - RCONK181
12 Other consumer
RCFDB539 + RCFDK207 RCFDK182
See instructions
RCONB539 + RCONK207 RCONK182
See instructions
14 Loans covered by FDIC loss sharing agreements
Sum of RCONK169 to
RCONK177 and Sum of
RCFDK178 to RCFDK183
Sum of RCONK169 to
RCONK183, excluding
RCONK178
15
RCFD2122
RCON2122
RCFD3123
RCON3123
RCFD0211 + RCFD1289 +
RCFD1294 + RCFDG300 +
RCFDG304 + RCFDG312 +
RCFDG316 + RCFDK142 +
RCFDK150
RCON0211 + RCON1289 +
RCON1294 + RCONG300 +
RCONG304 + RCONG312 +
RCONG316 + RCONK142 +
RCONK150
18 Securities issued by states and political subdivisions of U.S.
RCFD8496
RCON8496
19 Non-agency MBS and ABS securities
RCFDG308 + RCFDG320 + RCONG308 + RCONG320 +
RCFDK146 + RCFDK154 + RCONK146 + RCONK154 +
RCFDC026
RCONC026
20 All other HTM securities
RCFDG336 + RCFDG340 + RCONG336 + RCONG340 +
RCFDG344 + RCFD1737 + RCONG344 + RCON1737 +
RCFD1742
RCON1742
21
RCFD1754
RCON1754
RCFD1287 + RCFD1293 +
RCFD1298 + RCFDG303 +
RCFDG307 + RCFDG315 +
RCFDG319 + RCFDK145 +
RCFDK153
RCON1287 + RCON1293 +
RCON1298 + RCONG303 +
RCONG307 + RCONG315 +
RCONG319 + RCONK145 +
RCONK153
23 Securities issued by states and political subdivisions of U.S.
RCFD8499
RCON8499
24 Non-agency MBS and ABS securities
RCFDG311 + RCFDG323 + RCONG311 + RCONG323 +
RCFDK149 + RCFDK157 + RCONK149 + RCONK157 +
RCFDC027
RCONC027
Total loans and leases (sum of items 1 to 14)
16 Allowance for loan and lease losses
Securities
17 U.S. government obligation and obligations of GSE
Total securities (HTM) (sum of items 17-20)
22 U.S. government obligation and obligations of GSE
25 All other AFS securities
RCFDG339 + RCFDG343 + RCONG339 + RCONG343 +
RCFDG347 + RCFD1741 + RCONG347 + RCON1741 +
RCFD1746 + RCFDA511
RCON1746 + RCONA511
26
RCFD1773
RCON1773
27 Trading assets
28 Total intangible assets
RCFD3545
RCON3545
RCFD3163 + RCFD0426
RCON3163 + RCON0426
29 Other real estate owned
30 All other assets
RCFD2150
RCON2150
See instructions
See instructions
31
RCFD2170
RCON2170
Total securities (AFS) (sum of items 22-25)
Total assets (sum of items 15, 21, 26, 27-30, less item 16)
Projected
As of 9/30
As of 12/31
Year 1: 2014 -- Projected (in the quarter)
Q1
Q2
Q3
Year 2: 2015 -- Projected (in the quarter)
Q4
Q5
Q6
Q7
Q8
RCONF158 - RCONK169
9 Non-farm, non-residential other loans
10 Credit cards
13 All other loans and leases
Actual
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
0
0
0
0
0
0
0
0
0
0
0
0
0
xx/xx/20xx
FDIC DFAST 10-50 - Baseline Scenario
Balance Sheet Statement for XYZ
FDIC CERT#####
(Dollar Amounts in Thousands)
Balance Sheet Statement Impacts
031 Call Rpt Item
041 Call Rpt Item
RCON2200 - RCONJ474 RCONJ472 - RCON2343
RCONB993 + RCFDB995 +
RCFD3190 + RCON2343 +
RCONJ472 + RCONJ474 +
RCFN2200
RCON2200 - RCONJ474 RCONJ472 - RCON2343
RCONB993 + RCONB995 +
RCON3190 + RCON2343 +
RCONJ472 + RCONJ474
34 Trading liabilities
35 All other liabilities
RCFD3548
RCON3548
See instructions
See instructions
36
Total liabilities (sum of items 32 to 35)
RCFD2948
RCON2948
37 Perpetual preferred stock and related surplus
RCFD3838
RCON3838
38 Equity capital
RCFD3230 + RCFD3839 +
RCFD3632 + RCFDB530 +
RCFDA130 + RCFD3000
RCON3230 + RCON3839 +
RCON3632 + RCONB530 +
RCONA130 + RCON3000
39
RCFDG105
RCONG105
32 Retail funding
33 Wholesale funding
Total equity capital (sum of items 37 to 38)
Capital
40 Unrealized gains(losses) on AFS securities
41 Disallowed deferred tax asset
031 Call Rpt Item
041 Call Rpt Item
RCFD8434
RCON8434
RCFD5610
RCON5610
42 Tier 1 capital
43 Qualifying subordinated debt and redeemable preferred stock
RCFD8274
RCON8274
RCFD5306
RCON5306
44 Allowance includible in Tier 2 capital
45 Tier 2 capital
RCFD5310
RCON5310
RCFD5311
RCON5311
46 Total risk-based capital
47 Total capital
RCFD3792
RCON3792
RCFD3210
RCON3210
48 Risk-weighted assets
49 Total assets for leverage purposes
RCFDA223
RCONA223
RCFDL138
RCONL138
50 Tier 1 risk-based capital ratio
=(Tier 1 Capital / RWA) *
100
=(Tier 1 Capital / Total
Assets for Leverage
Purposes) * 100
=(Tier 1 Capital / RWA) * 100
52 Total risk-based capital ratio
=(Total Risk-based Capital /
RWA) * 100
=(Total Risk-based Capital /
RWA) * 100
Memoranda
53 Sale, conversion, acquisition, or retirement of capital stock
54 Cash dividends declared on preferred stock
RIADB509+RIADB510
RIADB509+RIADB510
RIAD4470
RIAD4470
55 Cash dividends declared on common stock
RIAD4460
RIAD4460
51 Tier 1 leverage ratio
=(Tier 1 Capital / Total Assets
for Leverage Purposes) * 100
Actual
Projected
As of 9/30
As of 12/31
0
0
Actual
Projected
As of 9/30
As of 12/31
Year 1: 2014 -- Projected (in the quarter)
Q1
Q2
0
0
0
0
Q3
Year 2: 2015 -- Projected (in the quarter)
Q4
Q5
Q6
0
0
0
0
0
0
0
0
Year 1: 2014 -- Projected (in the quarter)
Q1
Q2
Q3
Q7
Q8
0
0
0
0
0
0
Year 2: 2015 -- Projected (in the quarter)
Q4
Q5
Q6
Q7
Q8
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
| File Type | application/pdf |
| File Modified | 2013-10-24 |
| File Created | 2013-09-25 |