Finance and Economics Discussion Series: 2012-49 Screen Reader version
♣
Can Macro Variables Used in Stress Testing Forecast the Performance of Banks?
Luca Guerrieri and Michelle Welch
Figure 2: Total Net Chargeoffs: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0458738 |
0.045525 |
0.0449217 |
0.0442846 |
0.0438737 |
0.0420787 |
0.0448381 |
0.0443554 |
0.0512644 |
2 step |
0.0733355 |
0.0711103 |
0.0684081 |
0.0665432 |
0.0648896 |
0.0600351 |
0.0635286 |
0.0615533 |
0.0844897 |
3 step |
0.0988851 |
0.0930348 |
0.08774 |
0.0840516 |
0.0806185 |
0.073507 |
0.0789454 |
0.0751574 |
0.115832 |
4 step |
0.1245815 |
0.1194219 |
0.111688 |
0.1063896 |
0.1004592 |
0.0898643 |
0.0953171 |
0.0908323 |
0.1530112 |
5 step |
0.1525687 |
0.145696 |
0.1356534 |
0.1287755 |
0.1204855 |
0.1056365 |
0.1103107 |
0.1065036 |
0.1901885 |
6 step |
0.1767141 |
0.1724475 |
0.1595886 |
0.1520731 |
0.1421201 |
0.1209359 |
0.123453 |
0.1212602 |
0.2277674 |
7 step |
0.1985317 |
0.1982525 |
0.1820768 |
0.175477 |
0.1645975 |
0.1354614 |
0.1364879 |
0.1362468 |
0.26434 |
8 step |
0.2166956 |
0.2227909 |
0.2030267 |
0.1980415 |
0.1873501 |
0.1490326 |
0.1480719 |
0.1504488 |
0.3000735 |
9 step |
0.22959 |
0.2161081 |
0.2013464 |
0.1953965 |
0.1874027 |
0.1602659 |
0.1594389 |
0.1615978 |
0.2717324 |
Average forecast |
0.153126 |
0.1487431 |
0.1386467 |
0.1339552 |
0.1275905 |
0.1114748 |
0.1119653 |
0.1126157 |
0.1896682 |
Figure 2: Total Net Chargeoffs: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0458738 |
0.0465622 |
0.0461285 |
0.0459273 |
0.0460557 |
0.0445184 |
0.0485932 |
0.048345 |
0.0512644 |
2 step |
0.0733355 |
0.0729008 |
0.0704831 |
0.0691535 |
0.068239 |
0.0638321 |
0.0688259 |
0.0679058 |
0.0844897 |
3 step |
0.0988851 |
0.0952422 |
0.0903034 |
0.0871629 |
0.0845471 |
0.0779885 |
0.0846586 |
0.0827216 |
0.115832 |
4 step |
0.1245815 |
0.1217082 |
0.1144045 |
0.1096075 |
0.1045434 |
0.0948836 |
0.1020002 |
0.0991866 |
0.1530112 |
5 step |
0.1525687 |
0.147811 |
0.1382519 |
0.1317714 |
0.1242955 |
0.1107696 |
0.117431 |
0.1150647 |
0.1901885 |
6 step |
0.1767141 |
0.1741985 |
0.1618586 |
0.15458 |
0.1453278 |
0.126073 |
0.1313595 |
0.1296837 |
0.2277674 |
7 step |
0.1985317 |
0.199524 |
0.1838836 |
0.1773274 |
0.1669731 |
0.1404068 |
0.1447389 |
0.1446135 |
0.26434 |
8 step |
0.2166956 |
0.2238752 |
0.2046863 |
0.1996383 |
0.1893784 |
0.1540479 |
0.1569705 |
0.1590211 |
0.3000735 |
9 step |
0.22959 |
0.2179652 |
0.2038317 |
0.197988 |
0.1906179 |
0.1656391 |
0.1685192 |
0.1708943 |
0.2717324 |
Average forecast |
0.153126 |
0.1503455 |
0.1406759 |
0.1362177 |
0.1304403 |
0.1157329 |
0.1185604 |
0.1197941 |
0.1896682 |
Figure 3: Pre-Provision Net Revenue: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0727797 |
0.0671655 |
0.066953 |
0.0678493 |
0.0683496 |
0.0680308 |
0.0699866 |
0.0664038 |
0.0682783 |
2 step |
0.0736953 |
0.0708962 |
0.0710276 |
0.0730539 |
0.0736328 |
0.072719 |
0.0766607 |
0.0705279 |
0.0724413 |
3 step |
0.0860357 |
0.0794093 |
0.079461 |
0.0811811 |
0.0816963 |
0.0805876 |
0.0862764 |
0.0779015 |
0.08064 |
4 step |
0.0869938 |
0.0830945 |
0.0830162 |
0.0850788 |
0.0856462 |
0.0840977 |
0.0939465 |
0.0800106 |
0.0841435 |
5 step |
0.0891572 |
0.0871672 |
0.0874065 |
0.0895445 |
0.0898475 |
0.08899 |
0.0992599 |
0.0859028 |
0.0874347 |
6 step |
0.096081 |
0.0896121 |
0.09029 |
0.092455 |
0.0926395 |
0.0921847 |
0.1031798 |
0.0900116 |
0.089603 |
7 step |
0.0917667 |
0.0921178 |
0.0934627 |
0.0956483 |
0.0958526 |
0.0959054 |
0.1079331 |
0.093761 |
0.0912319 |
8 step |
0.1029553 |
0.0945989 |
0.0966124 |
0.0988526 |
0.0992806 |
0.0996853 |
0.1111684 |
0.0973384 |
0.0930759 |
9 step |
0.0915575 |
0.0963374 |
0.0982781 |
0.1004551 |
0.1004773 |
0.1008078 |
0.1134125 |
0.0981058 |
0.0953358 |
Average forecast |
0.0699556 |
0.0639134 |
0.0649502 |
0.0665359 |
0.066622 |
0.0667022 |
0.0761637 |
0.064163 |
0.0632836 |
Figure 3: Pre-Provision Net Revenue: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0727797 |
0.0674806 |
0.0673264 |
0.0682763 |
0.0689151 |
0.0687843 |
0.0709812 |
0.0675923 |
0.0682783 |
2 step |
0.0736953 |
0.0715248 |
0.071773 |
0.0739787 |
0.0748538 |
0.0742688 |
0.0788652 |
0.0730246 |
0.0724413 |
3 step |
0.0860357 |
0.0803954 |
0.0805674 |
0.0825562 |
0.0835236 |
0.0829143 |
0.0895462 |
0.0815615 |
0.08064 |
4 step |
0.0869938 |
0.0843597 |
0.0843717 |
0.0867617 |
0.0878635 |
0.0869673 |
0.0979154 |
0.0844648 |
0.0841435 |
5 step |
0.0891572 |
0.0885878 |
0.0889516 |
0.0914164 |
0.0922802 |
0.0921396 |
0.103909 |
0.0907362 |
0.0874347 |
6 step |
0.096081 |
0.0911281 |
0.0919781 |
0.0944652 |
0.0952389 |
0.0955731 |
0.1081682 |
0.0953059 |
0.089603 |
7 step |
0.0917667 |
0.0937373 |
0.0953198 |
0.0978123 |
0.0986455 |
0.099631 |
0.1133359 |
0.0997829 |
0.0912319 |
8 step |
0.1029553 |
0.0964622 |
0.0987577 |
0.1014237 |
0.1026049 |
0.1040947 |
0.1175599 |
0.1044645 |
0.0930759 |
9 step |
0.0915575 |
0.0983795 |
0.1006182 |
0.1032443 |
0.1040804 |
0.1055518 |
0.1201073 |
0.1058663 |
0.0953358 |
Average forecast |
0.0699556 |
0.0656583 |
0.0669127 |
0.068909 |
0.0697074 |
0.0706897 |
0.0816079 |
0.0705126 |
0.0632836 |
Figure 4: Net Interest Margin: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0226479 |
0.0228571 |
0.0234034 |
0.0237641 |
0.0235499 |
0.0241045 |
0.0246913 |
0.0246005 |
0.0229845 |
2 step |
0.0300023 |
0.0293166 |
0.030062 |
0.0303531 |
0.0300467 |
0.0311858 |
0.0336814 |
0.0314028 |
0.0302006 |
3 step |
0.037169 |
0.0352122 |
0.0359129 |
0.0364937 |
0.0360816 |
0.037805 |
0.042309 |
0.0381013 |
0.0365303 |
4 step |
0.0458892 |
0.0424149 |
0.042779 |
0.0433234 |
0.0431405 |
0.0449742 |
0.0500068 |
0.0464005 |
0.0439487 |
5 step |
0.0486827 |
0.0429011 |
0.0429284 |
0.0434175 |
0.0438849 |
0.0453805 |
0.0504792 |
0.048725 |
0.0450947 |
6 step |
0.0536431 |
0.0465631 |
0.0466245 |
0.0474134 |
0.0487225 |
0.0499638 |
0.0548161 |
0.0545455 |
0.0485811 |
7 step |
0.0574405 |
0.0504514 |
0.0505153 |
0.0517426 |
0.0540551 |
0.0550946 |
0.0600159 |
0.0612278 |
0.0521521 |
8 step |
0.0606426 |
0.0542622 |
0.0542681 |
0.0562946 |
0.0594314 |
0.0603613 |
0.0645427 |
0.0685761 |
0.0558047 |
9 step |
0.0647458 |
0.0610109 |
0.0608603 |
0.063377 |
0.0668251 |
0.0681724 |
0.0716442 |
0.0773124 |
0.0624408 |
Average forecast |
0.0454249 |
0.0390289 |
0.0388268 |
0.040198 |
0.0409377 |
0.0418001 |
0.0465578 |
0.0445504 |
0.0407285 |
Figure 4: Net Interest Margin: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0226479 |
0.0229064 |
0.0233922 |
0.0238493 |
0.0235643 |
0.0239389 |
0.0243769 |
0.0245256 |
0.0229845 |
2 step |
0.0300023 |
0.0296601 |
0.0302939 |
0.0309241 |
0.0305442 |
0.0313929 |
0.033691 |
0.0322197 |
0.0302006 |
3 step |
0.037169 |
0.0357076 |
0.0362676 |
0.0374377 |
0.036997 |
0.0383147 |
0.0424655 |
0.0397196 |
0.0365303 |
4 step |
0.0458892 |
0.0430043 |
0.0432418 |
0.0445975 |
0.0445347 |
0.0459905 |
0.0507074 |
0.0490661 |
0.0439487 |
5 step |
0.0486827 |
0.0434364 |
0.0433282 |
0.0449213 |
0.0455609 |
0.046536 |
0.0512544 |
0.0520542 |
0.0450947 |
6 step |
0.0536431 |
0.0467615 |
0.0466498 |
0.0485685 |
0.0500151 |
0.0504786 |
0.054942 |
0.0574931 |
0.0485811 |
7 step |
0.0574405 |
0.0502954 |
0.0501416 |
0.0525292 |
0.0549437 |
0.0549869 |
0.0592359 |
0.063833 |
0.0521521 |
8 step |
0.0606426 |
0.0536763 |
0.0534001 |
0.056574 |
0.0598017 |
0.059643 |
0.0627216 |
0.0709593 |
0.0558047 |
9 step |
0.0647458 |
0.0598384 |
0.0593185 |
0.0627429 |
0.0661793 |
0.0661506 |
0.0668332 |
0.0781948 |
0.0624408 |
Average forecast |
0.0454249 |
0.0391662 |
0.0387858 |
0.041089 |
0.0418984 |
0.0421482 |
0.0463902 |
0.0469282 |
0.0407285 |
Figure 5: Tier-1 Capital Ratio: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.211233 |
0.1740386 |
0.1631614 |
0.1639593 |
0.1619509 |
0.1523158 |
0.1527415 |
0.1535632 |
0.2016589 |
2 step |
0.3876438 |
0.3197143 |
0.2957338 |
0.2916055 |
0.2862641 |
0.2680176 |
0.2635767 |
0.2688584 |
0.3746234 |
3 step |
0.5651176 |
0.4635757 |
0.4349285 |
0.4301257 |
0.4206891 |
0.4044625 |
0.4110711 |
0.4037044 |
0.5284068 |
4 step |
0.7379703 |
0.613802 |
0.5872689 |
0.5845449 |
0.5726144 |
0.5652011 |
0.5754091 |
0.569182 |
0.6739709 |
5 step |
0.8928946 |
0.7546438 |
0.7314562 |
0.7321056 |
0.7167441 |
0.7189495 |
0.7286792 |
0.7278029 |
0.8073559 |
6 step |
1.044952 |
0.8973632 |
0.878323 |
0.8842978 |
0.8686948 |
0.8795221 |
0.8875462 |
0.8982182 |
0.9384545 |
7 step |
1.188876 |
1.042335 |
1.023205 |
1.032445 |
1.016337 |
1.032353 |
1.037717 |
1.063934 |
1.08298 |
8 step |
1.321736 |
1.179082 |
1.158778 |
1.169263 |
1.154662 |
1.171446 |
1.168187 |
1.221032 |
1.221602 |
9 step |
1.439877 |
1.316587 |
1.298193 |
1.310592 |
1.296024 |
1.304282 |
1.230261 |
1.380485 |
1.338616 |
Average forecast |
0.9708003 |
0.8514286 |
0.8330783 |
0.8342944 |
0.8222224 |
0.8285596 |
0.805549 |
0.852193 |
0.8888543 |
Figure 5: Tier-1 Capital Ratio: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.211233 |
0.1743886 |
0.1634875 |
0.1638435 |
0.1624719 |
0.1520108 |
0.1503223 |
0.1532568 |
0.2016589 |
2 step |
0.3876438 |
0.3203835 |
0.2966722 |
0.2918278 |
0.2878549 |
0.2679685 |
0.2591195 |
0.2685064 |
0.3746234 |
3 step |
0.5651176 |
0.4626115 |
0.4340552 |
0.4276361 |
0.4195019 |
0.3988699 |
0.3947422 |
0.3951296 |
0.5284068 |
4 step |
0.7379703 |
0.6093932 |
0.5825286 |
0.5769866 |
0.5655364 |
0.550616 |
0.5432028 |
0.5461987 |
0.6739709 |
5 step |
0.8928946 |
0.745331 |
0.7212145 |
0.7175568 |
0.7009321 |
0.6919807 |
0.6746285 |
0.6865239 |
0.8073559 |
6 step |
1.044952 |
0.881753 |
0.8610803 |
0.8611135 |
0.8423463 |
0.8387484 |
0.8099483 |
0.8364881 |
0.9384545 |
7 step |
1.188876 |
1.021079 |
0.9996664 |
1.001458 |
0.9805031 |
0.9796842 |
0.9399084 |
0.9853899 |
1.08298 |
8 step |
1.321736 |
1.153523 |
1.130347 |
1.132066 |
1.11144 |
1.108382 |
1.050298 |
1.128531 |
1.221602 |
9 step |
1.439877 |
1.28707 |
1.265697 |
1.26852 |
1.246044 |
1.235232 |
1.098016 |
1.278502 |
1.338616 |
Average forecast |
0.9708003 |
0.8398487 |
0.8202627 |
0.8171504 |
0.80279 |
0.7989951 |
0.7486342 |
0.8081394 |
0.8888543 |
Figure 8: Total Net Chargeoffs - Using FR-Y9C Form Data: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0995246 |
0.0951438 |
0.0959445 |
0.0937092 |
0.088968 |
0.0930539 |
0.1047853 |
0.0911431 |
0.099742 |
2 step |
0.1659796 |
0.1614394 |
0.1557187 |
0.1480731 |
0.1386307 |
0.1361612 |
0.1552791 |
0.1322052 |
0.1866903 |
3 step |
0.2381341 |
0.2347967 |
0.2211675 |
0.2112413 |
0.1968912 |
0.184899 |
0.2006484 |
0.1823181 |
0.284235 |
4 step |
0.2972256 |
0.2980514 |
0.2765386 |
0.2660287 |
0.2470261 |
0.2238538 |
0.2348718 |
0.2212975 |
0.3723283 |
5 step |
0.3400498 |
0.3494712 |
0.3253722 |
0.3139375 |
0.2899263 |
0.258501 |
0.2668239 |
0.2543098 |
0.4451993 |
6 step |
0.3824977 |
0.4015529 |
0.3755286 |
0.3622689 |
0.3332495 |
0.2915049 |
0.2953685 |
0.2861936 |
0.5168574 |
7 step |
0.4009522 |
0.432769 |
0.4013222 |
0.3898504 |
0.3586228 |
0.3056239 |
0.3076231 |
0.303193 |
0.5666837 |
8 step |
0.402245 |
0.4521741 |
0.4138298 |
0.4060894 |
0.3759934 |
0.3144391 |
0.3203306 |
0.3116869 |
0.6009232 |
9 step |
0.3588088 |
0.4097106 |
0.3789368 |
0.3760064 |
0.3544331 |
0.3109962 |
0.3279962 |
0.3034888 |
0.5102435 |
Average forecast |
0.2850059 |
0.3129235 |
0.2918532 |
0.2843064 |
0.2670473 |
0.2392603 |
0.2497101 |
0.2354145 |
0.3939368 |
Figure 8: Total Net Chargeoffs - Using FR-Y9C Form Data: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0995246 |
0.0954914 |
0.0962625 |
0.0941156 |
0.0894557 |
0.0936353 |
0.1054593 |
0.0920519 |
0.099742 |
2 step |
0.1659796 |
0.162552 |
0.1568185 |
0.1494083 |
0.1402589 |
0.137843 |
0.1571232 |
0.1349965 |
0.1866903 |
3 step |
0.2381341 |
0.2367916 |
0.2232781 |
0.213827 |
0.200068 |
0.1883173 |
0.2045994 |
0.1877278 |
0.284235 |
4 step |
0.2972256 |
0.3002602 |
0.2790194 |
0.2690688 |
0.2507464 |
0.2282915 |
0.2407203 |
0.228052 |
0.3723283 |
5 step |
0.3400498 |
0.3511671 |
0.3274204 |
0.3164451 |
0.2929611 |
0.2625316 |
0.2728386 |
0.2604406 |
0.4451993 |
6 step |
0.3824977 |
0.4023324 |
0.3766952 |
0.363746 |
0.3351027 |
0.2951696 |
0.3020969 |
0.29183 |
0.5168574 |
7 step |
0.4009522 |
0.4326421 |
0.4016751 |
0.3903935 |
0.3594396 |
0.3095021 |
0.316068 |
0.3097278 |
0.5666837 |
8 step |
0.402245 |
0.4518566 |
0.4141617 |
0.4066171 |
0.3768256 |
0.3192193 |
0.3308992 |
0.3200791 |
0.6009232 |
9 step |
0.3588088 |
0.4109445 |
0.3811169 |
0.3789084 |
0.3581141 |
0.318249 |
0.341972 |
0.3164137 |
0.5102435 |
Average forecast |
0.2850059 |
0.3140016 |
0.2932827 |
0.2860736 |
0.2692053 |
0.242932 |
0.2560535 |
0.2412983 |
0.3939368 |
Figure 9: Total Net Chargeoffs - Aggregate of All U.S. Commercial Banks: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0447398 |
0.0425196 |
0.0429372 |
0.0419758 |
0.0413712 |
0.0415749 |
0.0435802 |
0.0427879 |
0.0461888 |
2 step |
0.0669124 |
0.0606808 |
0.0585124 |
0.0567203 |
0.0547514 |
0.0521694 |
0.0552394 |
0.0532292 |
0.072334 |
3 step |
0.0923948 |
0.0823649 |
0.0781254 |
0.0750782 |
0.0718515 |
0.067949 |
0.0729387 |
0.0687031 |
0.1017415 |
4 step |
0.1137209 |
0.1021715 |
0.0948796 |
0.0906633 |
0.085836 |
0.0794197 |
0.085437 |
0.0796883 |
0.1312902 |
5 step |
0.1398358 |
0.1259212 |
0.1171769 |
0.1122244 |
0.1060827 |
0.0975258 |
0.102311 |
0.0973942 |
0.1629509 |
6 step |
0.1619646 |
0.1486276 |
0.1365502 |
0.1313612 |
0.1241294 |
0.1090619 |
0.112438 |
0.1080335 |
0.1955053 |
7 step |
0.1827076 |
0.1725873 |
0.1568983 |
0.152639 |
0.1450283 |
0.1224947 |
0.1239352 |
0.1213425 |
0.2292058 |
8 step |
0.1985497 |
0.1934077 |
0.1734287 |
0.1707649 |
0.1641917 |
0.1331641 |
0.1331548 |
0.1319865 |
0.2597798 |
9 step |
0.2114889 |
0.1910355 |
0.1771471 |
0.1742733 |
0.1683619 |
0.1447401 |
0.1435166 |
0.1431222 |
0.2381855 |
Average forecast |
0.1411026 |
0.1298751 |
0.1203318 |
0.1172021 |
0.1125254 |
0.1006756 |
0.1022067 |
0.0996619 |
0.1647343 |
Figure 9: Total Net Chargeoffs - Aggregate of All U.S. Commercial Banks: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0447398 |
0.0430677 |
0.0435506 |
0.0428031 |
0.0424657 |
0.0427795 |
0.0454644 |
0.0446457 |
0.0461888 |
2 step |
0.0669124 |
0.0617494 |
0.0596994 |
0.0581821 |
0.0565994 |
0.0542094 |
0.0580748 |
0.0566147 |
0.072334 |
3 step |
0.0923948 |
0.0839151 |
0.0798697 |
0.0771606 |
0.0744392 |
0.070875 |
0.0767691 |
0.0735156 |
0.1017415 |
4 step |
0.1137209 |
0.10409 |
0.0971308 |
0.0933209 |
0.089133 |
0.0834089 |
0.0908429 |
0.0860776 |
0.1312902 |
5 step |
0.1398358 |
0.1279722 |
0.1196521 |
0.1151176 |
0.1096485 |
0.102152 |
0.1089159 |
0.1047005 |
0.1629509 |
6 step |
0.1619646 |
0.1506741 |
0.1391259 |
0.1343315 |
0.1277848 |
0.1143849 |
0.1204935 |
0.1164046 |
0.1955053 |
7 step |
0.1827076 |
0.1745275 |
0.159442 |
0.1555344 |
0.1485777 |
0.1283302 |
0.1332598 |
0.1307069 |
0.2292058 |
8 step |
0.1985497 |
0.1953205 |
0.1760134 |
0.1736704 |
0.1677216 |
0.139432 |
0.1435699 |
0.1421263 |
0.2597798 |
9 step |
0.2114889 |
0.1935196 |
0.1802736 |
0.1778606 |
0.1727599 |
0.1514357 |
0.1547508 |
0.1540786 |
0.2381855 |
Average forecast |
0.1411026 |
0.1315046 |
0.1223486 |
0.1195236 |
0.11536 |
0.1047093 |
0.1084769 |
0.1062137 |
0.1647343 |
Figure 10: Total Net Chargeoffs - Shortened Sample Ending in 2007Q4: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0366087 |
0.0405834 |
0.0401978 |
0.0402866 |
0.0404599 |
0.03816 |
0.0391574 |
0.0411936 |
0.0456121 |
2 step |
0.0514737 |
0.0583291 |
0.0575178 |
0.0571886 |
0.0569499 |
0.0512137 |
0.0491344 |
0.0546485 |
0.0678929 |
3 step |
0.0640393 |
0.0687694 |
0.0673129 |
0.0656435 |
0.0649931 |
0.0575792 |
0.0559438 |
0.0615861 |
0.0822685 |
4 step |
0.0825556 |
0.0844881 |
0.0826046 |
0.0786601 |
0.0774847 |
0.0705556 |
0.0696134 |
0.0742258 |
0.1008414 |
5 step |
0.1083253 |
0.1002128 |
0.0968291 |
0.0899545 |
0.0883614 |
0.0814828 |
0.0798507 |
0.0856263 |
0.1203213 |
6 step |
0.137485 |
0.1203803 |
0.1154339 |
0.1067984 |
0.1048092 |
0.0976003 |
0.0939074 |
0.1003786 |
0.1437445 |
7 step |
0.1654276 |
0.1400356 |
0.1338968 |
0.1245337 |
0.1214579 |
0.1121134 |
0.1054058 |
0.1154657 |
0.166985 |
8 step |
0.1918355 |
0.1591788 |
0.1532481 |
0.1433087 |
0.1390064 |
0.1279637 |
0.1174458 |
0.1319502 |
0.1884158 |
9 step |
0.2198864 |
0.1794113 |
0.1737318 |
0.1638143 |
0.1578371 |
0.1447611 |
0.135087 |
0.1476821 |
0.2104896 |
Average forecast |
0.1316975 |
0.1140334 |
0.1105786 |
0.1045275 |
0.101798 |
0.0951138 |
0.088938 |
0.098331 |
0.1321907 |
Figure 10: Total Net Chargeoffs - Aggregate of All U.S. Commercial Banks: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0366087 |
0.0418209 |
0.041652 |
0.0422546 |
0.0430632 |
0.0410881 |
0.0438544 |
0.0458641 |
0.0456121 |
2 step |
0.0514737 |
0.060297 |
0.0597987 |
0.0600643 |
0.0606483 |
0.0554579 |
0.0556333 |
0.0615677 |
0.0678929 |
3 step |
0.0640393 |
0.0711078 |
0.0699944 |
0.0688899 |
0.06909 |
0.0622548 |
0.0623246 |
0.0694316 |
0.0822685 |
4 step |
0.0825556 |
0.0869267 |
0.0853892 |
0.081967 |
0.081615 |
0.0751452 |
0.0755799 |
0.0820774 |
0.1008414 |
5 step |
0.1083253 |
0.1026943 |
0.0996806 |
0.093282 |
0.0924542 |
0.0859816 |
0.0854097 |
0.0934782 |
0.1203213 |
6 step |
0.137485 |
0.122825 |
0.118257 |
0.1099919 |
0.1086838 |
0.101853 |
0.0993479 |
0.1077408 |
0.1437445 |
7 step |
0.1654276 |
0.142474 |
0.1367209 |
0.1276413 |
0.1252104 |
0.1163305 |
0.1107765 |
0.1228691 |
0.166985 |
8 step |
0.1918355 |
0.1616438 |
0.1561 |
0.1463986 |
0.1427722 |
0.1322848 |
0.1232139 |
0.1394721 |
0.1884158 |
9 step |
0.2198864 |
0.1819712 |
0.1767039 |
0.1669949 |
0.1617911 |
0.1494163 |
0.1413884 |
0.1557323 |
0.2104896 |
Average forecast |
0.1316975 |
0.1160878 |
0.1129439 |
0.1072414 |
0.1051734 |
0.0988734 |
0.0940788 |
0.1048811 |
0.1321907 |
Figure 11: Total Net Chargeoffs - 60 Quarter Estimation Window: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0532064 |
0.0481065 |
0.0475964 |
0.0462768 |
0.046081 |
0.0480115 |
0.0510282 |
0.0486305 |
0.0514967 |
2 step |
0.0883669 |
0.0775364 |
0.0746977 |
0.0726801 |
0.0707307 |
0.0717919 |
0.0770491 |
0.0719973 |
0.0884344 |
3 step |
0.120701 |
0.1075874 |
0.101564 |
0.0984096 |
0.0944168 |
0.0924488 |
0.0968236 |
0.0937823 |
0.1286075 |
4 step |
0.1527875 |
0.1442572 |
0.1358653 |
0.1318928 |
0.1253897 |
0.1174472 |
0.1172858 |
0.1196647 |
0.1765852 |
5 step |
0.1846872 |
0.182963 |
0.1725782 |
0.1673608 |
0.1586699 |
0.1444468 |
0.1389424 |
0.1470647 |
0.2261267 |
6 step |
0.2142254 |
0.2222586 |
0.2095695 |
0.2025794 |
0.1922629 |
0.1706767 |
0.1560038 |
0.1750377 |
0.2767459 |
7 step |
0.2411619 |
0.2592178 |
0.2435416 |
0.235272 |
0.2242016 |
0.1945946 |
0.1721177 |
0.1999465 |
0.325961 |
8 step |
0.2633067 |
0.2926156 |
0.2735578 |
0.264233 |
0.2530999 |
0.214905 |
0.1861771 |
0.2212992 |
0.3731096 |
9 step |
0.279939 |
0.2856934 |
0.2702478 |
0.2637929 |
0.2544318 |
0.2281182 |
0.1989341 |
0.2336323 |
0.3456493 |
Average forecast |
0.1865453 |
0.1909322 |
0.1812674 |
0.176 |
0.1693333 |
0.1543925 |
0.1436031 |
0.1577527 |
0.2316243 |
Figure 11: Total Net Chargeoffs - 60 Quarter Estimation Window: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.0532064 |
0.0482855 |
0.0477978 |
0.0464489 |
0.0461387 |
0.0481006 |
0.0511709 |
0.0486723 |
0.0514967 |
2 step |
0.0883669 |
0.0779638 |
0.0751647 |
0.0731471 |
0.0710915 |
0.072249 |
0.0777055 |
0.0725634 |
0.0884344 |
3 step |
0.120701 |
0.1084468 |
0.1025621 |
0.0995206 |
0.0955714 |
0.0938559 |
0.0987437 |
0.0957608 |
0.1286075 |
4 step |
0.1527875 |
0.1451848 |
0.1369978 |
0.1331816 |
0.1268279 |
0.1193962 |
0.1203193 |
0.1224295 |
0.1765852 |
5 step |
0.1846872 |
0.1836108 |
0.1734284 |
0.1683565 |
0.1598068 |
0.1461899 |
0.1423929 |
0.1494762 |
0.2261267 |
6 step |
0.2142254 |
0.2224213 |
0.2098777 |
0.2029621 |
0.1926863 |
0.1717552 |
0.159419 |
0.1764044 |
0.2767459 |
7 step |
0.2411619 |
0.2587922 |
0.2431785 |
0.2348927 |
0.223719 |
0.1947408 |
0.1750142 |
0.1999034 |
0.325961 |
8 step |
0.2633067 |
0.2918231 |
0.2727544 |
0.2633316 |
0.2519645 |
0.2141534 |
0.1882048 |
0.2199374 |
0.3731096 |
9 step |
0.279939 |
0.2849098 |
0.269434 |
0.262878 |
0.2532682 |
0.2269697 |
0.2000656 |
0.2317743 |
0.3456493 |
Average forecast |
0.1865453 |
0.1910871 |
0.1815154 |
0.1763074 |
0.1696665 |
0.1551546 |
0.1459824 |
0.1587783 |
0.2316243 |
Figure 12: Total Net Chargeoffs - 80 Quarter Estimation Window: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. A: Forecast combinations using the change in unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.065601 |
0.0734923 |
0.0676769 |
0.0688654 |
0.0657225 |
0.0593869 |
0.0524053 |
0.0595996 |
0.0878481 |
2 step |
0.1163834 |
0.1345368 |
0.1230278 |
0.1253751 |
0.1179826 |
0.1055881 |
0.0933049 |
0.1047305 |
0.1617002 |
3 step |
0.1677078 |
0.1877698 |
0.1747968 |
0.1780833 |
0.167913 |
0.1519185 |
0.1350497 |
0.1524643 |
0.2219442 |
4 step |
0.2179517 |
0.22815 |
0.2155292 |
0.2195583 |
0.2078888 |
0.1879745 |
0.1667031 |
0.1897784 |
0.2663504 |
5 step |
0.2648595 |
0.2604006 |
0.2487988 |
0.252894 |
0.2407263 |
0.2188927 |
0.1956305 |
0.221562 |
0.2997633 |
6 step |
0.3087828 |
0.2847547 |
0.2725737 |
0.2756796 |
0.2630978 |
0.2379719 |
0.2135557 |
0.2405645 |
0.3270413 |
7 step |
0.3500851 |
0.3036631 |
0.2901711 |
0.291583 |
0.2784479 |
0.2515423 |
0.2271023 |
0.2557861 |
0.3485765 |
8 step |
0.3845613 |
0.3173679 |
0.3028005 |
0.3024158 |
0.288776 |
0.261501 |
0.2374689 |
0.2677347 |
0.3640698 |
9 step |
0.4151442 |
0.3364604 |
0.3210368 |
0.3191692 |
0.3046004 |
0.2761756 |
0.2498105 |
0.2843893 |
0.385634 |
Average forecast |
0.2696627 |
0.2422081 |
0.2301956 |
0.229733 |
0.2177431 |
0.1968102 |
0.1761995 |
0.1992411 |
0.2787434 |
Figure 12: Total Net Chargeoffs - 80 Quarter Estimation Window: Root Mean Squared Errors for Forecast Combinations and for Random Walk Model. B: Forecast combinations using the level of unemployment
Root Mean Squared Error |
Random Walk |
-1 |
-2 |
-3 |
-4 |
-5 |
-6 |
-7 |
-8 |
1 step |
0.065601 |
0.0731515 |
0.0672862 |
0.0683353 |
0.065041 |
0.0585503 |
0.0514162 |
0.0583773 |
0.0878481 |
2 step |
0.1163834 |
0.1331246 |
0.1213152 |
0.1232296 |
0.1151939 |
0.1017159 |
0.0877961 |
0.0989806 |
0.1617002 |
3 step |
0.1677078 |
0.1853988 |
0.1719144 |
0.1744675 |
0.1632189 |
0.1453226 |
0.1251084 |
0.1426746 |
0.2219442 |
4 step |
0.2179517 |
0.2250125 |
0.2117283 |
0.214773 |
0.2016772 |
0.1793184 |
0.1534583 |
0.1769238 |
0.2663504 |
5 step |
0.2648595 |
0.2564232 |
0.2439929 |
0.2468303 |
0.2328529 |
0.2079639 |
0.1787538 |
0.2052603 |
0.2997633 |
6 step |
0.3087828 |
0.2803015 |
0.2672313 |
0.2689304 |
0.2543738 |
0.226043 |
0.1951687 |
0.2227532 |
0.3270413 |
7 step |
0.3500851 |
0.2985483 |
0.284083 |
0.2839497 |
0.268641 |
0.2382599 |
0.2068583 |
0.2359254 |
0.3485765 |
8 step |
0.3845613 |
0.3114901 |
0.2958311 |
0.2937416 |
0.2776833 |
0.246478 |
0.2146734 |
0.2451979 |
0.3640698 |
9 step |
0.4151442 |
0.3295567 |
0.3128915 |
0.3091209 |
0.2917908 |
0.258881 |
0.2238689 |
0.2584094 |
0.385634 |
Average forecast |
0.2696627 |
0.2391471 |
0.2265873 |
0.2251557 |
0.211882 |
0.1889822 |
0.1644874 |
0.1875034 |
0.2787434 |
Figure 13a: Forecasts and Confidence Intervals of Banking Conditions Conditional on CCAR 2012 Macro Scenarios
No-change |
Chargeoffs: Level |
Chargeoffs: Change |
0.0458738 |
0.0608369 |
0.0521519 |
0.0733355 |
0.0830382 |
0.0709515 |
0.0988851 |
0.101685 |
0.0890756 |
0.1245815 |
0.1207551 |
0.1063142 |
0.1525687 |
0.1371169 |
0.121346 |
0.1767141 |
0.1510888 |
0.1331688 |
0.1985317 |
0.1670652 |
0.1466569 |
0.2166956 |
0.181419 |
0.1585055 |
0.22959 |
0.1923369 |
0.1687538 |
0.153126 |
0.1346456 |
0.1186672 |
Figure 13b: Forecasts and Confidence Intervals of Banking Conditions Conditional on CCAR 2012 Macro Scenarios
No-change |
PPNR: Level |
PPNR: Change |
0.0727797 |
0.0714621 |
0.0695476 |
0.0736953 |
0.0819566 |
0.0772141 |
0.0860357 |
0.094294 |
0.0876409 |
0.0869938 |
0.104481 |
0.0967365 |
0.0891572 |
0.1131838 |
0.1036896 |
0.096081 |
0.1202201 |
0.1097134 |
0.0917667 |
0.1278459 |
0.1160049 |
0.1029553 |
0.1323812 |
0.1183715 |
0.0915575 |
0.1349879 |
0.1201976 |
0.0699556 |
0.0921174 |
0.080994 |
Figure 13c: Forecasts and Confidence Intervals of Banking Conditions Conditional on CCAR 2012 Macro Scenarios
No-change |
NIM : Level |
NIM: Change |
0.0226479 |
0.0255417 |
0.0256355 |
0.0300023 |
0.0364138 |
0.0351014 |
0.037169 |
0.0474 |
0.0451565 |
0.0458892 |
0.0585654 |
0.0544226 |
0.0486827 |
0.0621484 |
0.0562211 |
0.0536431 |
0.0679328 |
0.0608604 |
0.0574405 |
0.0746202 |
0.0673078 |
0.0606426 |
0.0809789 |
0.073339 |
0.0647458 |
0.0827461 |
0.0807387 |
0.0454249 |
0.0555594 |
0.0504196 |
Figure 13d: Forecasts and Confidence Intervals of Banking Conditions Conditional on CCAR 2012 Macro Scenarios
No-change |
Tier 1 K Ratio: Level |
Tier 1 K Ratio: Change |
0.211233 |
0.1510124 |
0.1589893 |
0.3876438 |
0.2495028 |
0.2684968 |
0.5651176 |
0.3735248 |
0.423223 |
0.7379703 |
0.5002736 |
0.591988 |
0.8928946 |
0.5986294 |
0.7435213 |
1.044952 |
0.7078108 |
0.9086676 |
1.188876 |
0.8313319 |
1.074679 |
1.321736 |
0.9341554 |
1.222355 |
1.439877 |
0.9812216 |
1.304189 |
0.9708003 |
0.672979 |
0.8162341 |