Click to Login

Example: Credit card 90+ delinquency (2-quarters ahead)

NY Fed HHDC credit-card transition into 90+ days late from bank card delinquency, the card rate, and consumer debt service at t−6 months

This model estimates Quarterly share of credit-card balances newly 90+ days late two quarters ahead (six months) using the New York Fed Household Debt and Credit report and FRED prints dated six months earlier. The New York Fed series is quarterly; the six-month horizon is two HHDC quarters.

  • DRCCLACBS: commercial-bank credit-card delinquency rate for the quarter six months before the quarter being forecasted
  • TERMCBCCALLNS: commercial-bank credit-card interest rate (all accounts) for that same month
  • CDSP: consumer debt-service payments as a percent of disposable personal income for that same quarter

Our regression model is

CC90_estimated(t) = DRCCLACBS * 1.625873220 + TERMCBCCALLNS * 0.206456254 + CDSP * -0.054947388 + -2.072265988

and yields R^2 = 95.6% as of April 2026 (n = 90 quarters) in-sample on the latest paired actuals and estimates.

Coefficients are ordinary least squares on every complete lagged pair from 2004 through the latest actual, including the COVID and post-COVID years. That full-sample fit is a better statistical model of the printed series than one built only on pre-COVID data. A regression trained on the first 70% of paired samples (through 2019) and scored on the last 30% (2019–2026) does worse on that later window than predicting the holdout mean. The R² above is in-sample on the full window, including the period shown as a forecast; it is not an out-of-sample validation score.

Tabular Data

Date DRCCLACBS(t−6) TERMCBCCALLNS(t−6) CDSP(t−6) CC90_actual(t) CC90_estimated(t) CC90_estimated(t) − CC90_actual(t)
2026-07-01
(2026Q3)
2.91 20.99 5.2878 6.702
2026-04-01
(2026Q2)
2.95 21.11 5.4001 6.9995 6.7856 -0.2139 (-3.1%)
2026-01-01
(2026Q1)
2.99 21.3133 5.3557 7.1184 6.8951 -0.2233 (-3.1%)
2025-10-01
(2025Q4)
3.04 21.23 5.2982 7.1316 6.9623 -0.1693 (-2.4%)
2025-07-01
(2025Q3)
3.05 21.4033 5.3435 7.053 7.0119 -0.0411 (-0.6%)
2025-04-01
(2025Q2)
3.08 21.5667 5.433 6.9319 7.0895 0.1576 (2.3%)
2025-01-01
(2025Q1)
3.2 21.6767 5.3945 7.0388 7.3094 0.2706 (3.8%)
2024-10-01
(2024Q4)
3.22 21.5367 5.3185 7.1833 7.3172 0.1338 (1.9%)
2024-07-01
(2024Q3)
3.17 21.55 5.3964 7.0983 7.2344 0.1361 (1.9%)
2024-04-01
(2024Q2)
3.1 21.3767 5.4601 7.1757 7.0813 -0.0944 (-1.3%)
2024-01-01
(2024Q1)
2.95 21.0733 5.1316 6.8616 6.7928 -0.0688 (-1.0%)
2023-10-01
(2023Q4)
2.75 20.59 5.0369 6.3623 6.3731 0.0108 (0.2%)
2023-07-01
(2023Q3)
2.47 19.75 4.9857 5.7842 5.7472 -0.037 (-0.6%)
2023-04-01
(2023Q2)
2.26 18.1367 5.1134 5.0783 5.0657 -0.0126 (-0.2%)
2023-01-01
(2023Q1)
2.05 15.89 4.9891 4.5743 4.2672 -0.3071 (-6.7%)
2022-10-01
(2022Q4)
1.83 14.94 4.9917 4.0112 3.7133 -0.298 (-7.4%)
2022-07-01
(2022Q3)
1.69 14.5433 4.8441 3.6874 3.4119 -0.2756 (-7.5%)
2022-04-01
(2022Q2)
1.57 14.52 4.7993 3.3538 3.2144 -0.1394 (-4.2%)
2022-01-01
(2022Q1)
1.53 14.5633 4.7162 3.04 3.1629 0.1229 (4.0%)
2021-10-01
(2021Q4)
1.59 14.6567 4.642 3.2172 3.2838 0.0666 (2.1%)
2021-07-01
(2021Q3)
1.88 14.7167 4.2901 3.2377 3.787 0.5493 (17.0%)
2021-04-01
(2021Q2)
2.1 14.6267 4.9895 3.394 4.0877 0.6937 (20.4%)
2021-01-01
(2021Q1)
1.99 14.56 4.8415 3.7843 3.9032 0.1189 (3.1%)
2020-10-01
(2020Q4)
2.45 14.71 4.7115 4.1182 4.6892 0.571 (13.9%)
2020-07-01
(2020Q3)
2.69 15.0167 5.675 4.7327 5.0898 0.3571 (7.5%)
2020-04-01
(2020Q2)
2.61 14.9467 5.8094 5.0564 4.9379 -0.1185 (-2.3%)
2020-01-01
(2020Q1)
2.6 15.11 5.7495 5.3148 4.9586 -0.3562 (-6.7%)
2019-10-01
(2019Q4)
2.59 15.1167 5.6936 5.3171 4.9468 -0.3703 (-7.0%)
2019-07-01
(2019Q3)
2.54 14.97 5.6582 5.1589 4.8372 -0.3217 (-6.2%)
2019-04-01
(2019Q2)
2.54 14.6133 5.7511 5.1755 4.7585 -0.417 (-8.1%)
2019-01-01
(2019Q1)
2.52 14.3 5.7062 5.0428 4.6637 -0.3791 (-7.5%)
2018-10-01
(2018Q4)
2.5 13.97 5.7141 4.9898 4.5626 -0.4271 (-8.6%)
2018-07-01
(2018Q3)
2.5 13.4733 5.7206 4.8038 4.4597 -0.3441 (-7.2%)
2018-04-01
(2018Q2)
2.48 13.1333 5.8738 4.7587 4.3486 -0.41 (-8.6%)
2018-01-01
(2018Q1)
2.54 12.9767 5.8414 4.7226 4.4156 -0.307 (-6.5%)
2017-10-01
(2017Q4)
2.49 12.6933 5.7877 4.6436 4.2788 -0.3648 (-7.9%)
2017-07-01
(2017Q3)
2.4 12.4967 5.7444 4.6035 4.0942 -0.5093 (-11.1%)
2017-04-01
(2017Q2)
2.37 12.4433 5.8805 4.4223 4.0269 -0.3953 (-8.9%)
2017-01-01
(2017Q1)
2.29 12.3933 5.7788 4.0766 3.8921 -0.1845 (-4.5%)
2016-10-01
(2016Q4)
2.21 12.21 5.6986 3.708 3.7286 0.0207 (0.6%)
2016-07-01
(2016Q3)
2.15 12.28 5.6725 3.5086 3.647 0.1383 (3.9%)
2016-04-01
(2016Q2)
2.16 12.18 5.7121 3.5108 3.6404 0.1296 (3.7%)
2016-01-01
(2016Q1)
2.15 12.08 5.5528 3.6933 3.6122 -0.0811 (-2.2%)
2015-10-01
(2015Q4)
2.12 12.02 5.4622 3.7161 3.5561 -0.16 (-4.3%)
2015-07-01
(2015Q3)
2.11 11.9833 5.4406 3.8499 3.5334 -0.3165 (-8.2%)
2015-04-01
(2015Q2)
2.15 11.9333 5.4857 3.8042 3.5856 -0.2186 (-5.7%)
2015-01-01
(2015Q1)
2.2 11.8233 5.4166 3.758 3.648 -0.11 (-2.9%)
2014-10-01
(2014Q4)
2.26 11.83 5.3988 3.9196 3.7479 -0.1717 (-4.4%)
2014-07-01
(2014Q3)
2.32 11.8367 5.5011 3.8498 3.8412 -0.0086 (-0.2%)
2014-04-01
(2014Q2)
2.38 11.86 5.5813 3.7386 3.9392 0.2006 (5.4%)
2014-01-01
(2014Q1)
2.44 11.9033 5.4658 3.8697 4.0521 0.1823 (4.7%)
2013-10-01
(2013Q4)
2.53 11.9467 5.3884 3.9095 4.2116 0.3021 (7.7%)
2013-07-01
(2013Q3)
2.64 11.92 5.4861 4.0295 4.3795 0.35 (8.7%)
2013-04-01
(2013Q2)
2.71 11.9033 5.3488 4.2822 4.4975 0.2153 (5.0%)
2013-01-01
(2013Q1)
2.82 11.9867 5.4617 4.4136 4.6873 0.2738 (6.2%)
2012-10-01
(2012Q4)
2.92 12.1533 5.3538 4.5085 4.8902 0.3818 (8.5%)
2012-07-01
(2012Q3)
3.06 12.3467 5.432 4.8539 5.1535 0.2995 (6.2%)
2012-04-01
(2012Q2)
3.25 12.3333 5.6946 5.1919 5.4452 0.2533 (4.9%)
2012-01-01
(2012Q1)
3.45 12.4833 5.7389 5.4111 5.7989 0.3879 (7.2%)
2011-10-01
(2011Q4)
3.65 13.0733 5.6802 5.8704 6.2491 0.3787 (6.5%)
2011-07-01
(2011Q3)
3.82 13.44 5.8083 6.2614 6.5942 0.3328 (5.3%)
2011-04-01
(2011Q2)
4.14 13.49 6.0129 6.9045 7.1136 0.209 (3.0%)
2011-01-01
(2011Q1)
4.58 13.6733 6.0692 7.9893 7.8637 -0.1256 (-1.6%)
2010-10-01
(2010Q4)
5.1 13.98 6.139 9.2053 8.7686 -0.4366 (-4.7%)
2010-07-01
(2010Q3)
5.78 14.04 6.3753 10.2311 9.8736 -0.3575 (-3.5%)
2010-04-01
(2010Q2)
6.33 13.6367 6.5975 10.6342 10.6724 0.0381 (0.4%)
2010-01-01
(2010Q1)
6.49 13.58 6.6793 10.8006 10.9163 0.1157 (1.1%)
2009-10-01
(2009Q4)
6.77 13.2033 6.7051 10.9571 11.2924 0.3353 (3.1%)
2009-07-01
(2009Q3)
6.51 12.6567 6.8614 10.5075 10.7482 0.2407 (2.3%)
2009-04-01
(2009Q2)
5.64 12.0 6.896 10.196 9.1962 -0.9997 (-9.8%)
2009-01-01
(2009Q1)
4.8 11.92 6.7886 9.5605 7.8199 -1.7406 (-18.2%)
2008-10-01
(2008Q4)
4.9 12.0767 6.7028 8.705 8.0195 -0.6855 (-7.9%)
2008-07-01
(2008Q3)
4.77 12.5633 6.8641 8.1302 7.8998 -0.2304 (-2.8%)
2008-04-01
(2008Q2)
4.6 13.03 6.8946 7.6628 7.718 0.0552 (0.7%)
2008-01-01
(2008Q1)
4.41 13.5467 6.8592 7.2675 7.5177 0.2503 (3.4%)
2007-10-01
(2007Q4)
4.02 13.4433 6.9168 6.7461 6.8591 0.1131 (1.7%)
2007-07-01
(2007Q3)
3.98 13.3767 6.9782 6.5256 6.777 0.2514 (3.9%)
2007-04-01
(2007Q2)
3.95 13.2267 7.0526 6.3615 6.6931 0.3316 (5.2%)
2007-01-01
(2007Q1)
4.12 13.0933 7.0287 6.1799 6.9433 0.7634 (12.4%)
2006-10-01
(2006Q4)
4.13 13.2067 6.9365 5.8306 6.988 1.1575 (19.9%)
2006-07-01
(2006Q3)
3.86 13.06 7.0908 5.5942 6.5103 0.9161 (16.4%)
2006-04-01
(2006Q2)
3.54 12.5467 7.3069 5.6099 5.8722 0.2622 (4.7%)
2006-01-01
(2006Q1)
3.9 12.5767 7.2583 5.5121 6.4663 0.9542 (17.3%)
2005-10-01
(2005Q4)
3.67 12.5833 7.2393 5.7914 6.0948 0.3034 (5.2%)
2005-07-01
(2005Q3)
3.7 12.31 7.3038 6.2741 6.0836 -0.1905 (-3.0%)
2005-04-01
(2005Q2)
4.03 12.68 7.3684 6.3628 6.693 0.3302 (5.2%)
2005-01-01
(2005Q1)
4.07 12.91 7.4329 6.643 6.802 0.1589 (2.4%)
2004-10-01
(2004Q4)
4.15 12.6833 7.4974 7.0028 6.8817 -0.1211 (-1.7%)
2004-07-01
(2004Q3)
4.21 12.5633 7.562 7.1376 6.9509 -0.1867 (-2.6%)
2004-04-01
(2004Q2)
4.43 12.39 7.6265 7.339 7.2693 -0.0698 (-1.0%)
2004-01-01
(2004Q1)
4.24 12.3533 7.6911 7.7745 6.9493 -0.8253 (-10.6%)