Click to Login

Example: Total household debt (2-quarters ahead)

NY Fed HHDC total debt from monthly FRED metrics at t−6 months

This model estimates Total household debt 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.

  • UNRATE: civilian unemployment rate for the month six months before the quarter being forecasted
  • FEDFUNDS: effective federal funds rate for that same month
  • DSPIC96: real disposable personal income (chained 2017 dollars) for that same month
  • CSUSHPISA: S&P/Case-Shiller U.S. National Home Price Index for that same month

Our regression model is

HHDEBT_estimated(t) = UNRATE * 0.091286471 + FEDFUNDS * 0.093350567 + DSPIC96 * 0.000510602 + CSUSHPISA * 0.025148393 + 0.300635925

and yields R^2 = 89.8% as of October 2023 (n = 80 quarters) in-sample on paired actuals through 2023Q4.
On later paired actuals the same frozen coefficients yield R^2 = 86.8% as of April 2026 (n = 10 quarters) out of sample.

Coefficients are ordinary least squares on complete lagged pairs from 2004 through 2023Q4. Later dates, including the period shown as a forecast, use those frozen coefficients. On the leftover paired actuals that frozen fit beats predicting the holdout mean. The first R² above is in-sample through 2023Q4; the second is out-of-sample on later paired actuals.

Tabular Data

Date UNRATE(t−6) FEDFUNDS(t−6) DSPIC96(t−6) CSUSHPISA(t−6) HHDEBT_actual(t) HHDEBT_estimated(t) HHDEBT_estimated(t) − HHDEBT_actual(t)
2027-01-01
(2027Q1)
4.1 3.63 18415.4 333.235 18.797
2026-10-01
(2026Q4)
4.3 3.64 18231.9 331.451 18.6777
2026-07-01
(2026Q3)
4.3 3.64 18322.5 331.947 18.7364
2026-04-01
(2026Q2)
4.45 4.09 18168.4 328.837 18.7705 18.6352 -0.1353 (-0.7%)
2026-01-01
(2026Q1)
4.3 4.33 18144.4 326.924 18.784 18.5836 -0.2004 (-1.1%)
2025-10-01
(2025Q4)
4.2 4.33 18190.1 328.157 18.7757 18.6288 -0.1469 (-0.8%)
2025-07-01
(2025Q3)
4.0 4.33 17955.6 328.788 18.585 18.5067 -0.0783 (-0.4%)
2025-04-01
(2025Q2)
4.1 4.83 17914.4 324.505 18.388 18.4337 0.0457 (0.2%)
2025-01-01
(2025Q1)
4.2 5.33 17862.8 321.645 18.203 18.3912 0.1882 (1.0%)
2024-10-01
(2024Q4)
3.9 5.33 17747.2 319.137 18.036 18.2418 0.2058 (1.1%)
2024-07-01
(2024Q3)
3.7 5.33 17679.6 315.651 17.943 18.1013 0.1583 (0.9%)
2024-04-01
(2024Q2)
3.9 5.33 17435.9 313.24 17.796 17.9345 0.1385 (0.8%)
2024-01-01
(2024Q1)
3.5 5.12 17305.2 306.548 17.687 17.6434 -0.0436 (-0.2%)
2023-10-01
(2023Q4)
3.4 4.83 17149.6 300.068 17.503 17.3647 -0.1383 (-0.8%)
2023-07-01
(2023Q3)
3.5 4.33 16911.9 297.228 17.291 17.1344 -0.1566 (-0.9%)
2023-04-01
(2023Q2)
3.6 3.08 16480.2 298.766 17.063 16.8451 -0.2179 (-1.3%)
2023-01-01
(2023Q1)
3.5 1.68 16264.8 303.383 17.047 16.7114 -0.3356 (-2.0%)
2022-10-01
(2022Q4)
3.7 0.33 16146.3 300.275 16.899 16.465 -0.434 (-2.6%)
2022-07-01
(2022Q3)
4.0 0.08 16235.8 286.047 16.505 16.1569 -0.3481 (-2.1%)
2022-04-01
(2022Q2)
4.5 0.08 16775.8 273.62 16.154 16.1658 0.0118 (0.1%)
2022-01-01
(2022Q1)
5.4 0.1 16968.0 262.554 15.842 16.0696 0.2276 (1.4%)
2021-10-01
(2021Q4)
6.1 0.07 17406.3 248.999 15.576 16.0136 0.4376 (2.8%)
2021-07-01
(2021Q3)
6.4 0.09 18207.3 239.609 15.243 16.2157 0.9727 (6.4%)
2021-04-01
(2021Q2)
6.9 0.09 16573.6 229.654 14.957 15.1769 0.2199 (1.5%)
2021-01-01
(2021Q1)
10.2 0.09 17202.9 219.248 14.644 15.5377 0.8937 (6.1%)
2020-10-01
(2020Q4)
14.8 0.05 18015.3 216.79 14.559 16.3069 1.7479 (12.0%)
2020-07-01
(2020Q3)
3.6 1.55 15842.8 214.99 14.353 14.27 -0.083 (-0.6%)
2020-04-01
(2020Q2)
3.6 1.83 15718.1 211.715 14.266 14.1501 -0.1159 (-0.8%)
2020-01-01
(2020Q1)
3.7 2.4 15581.4 209.21 14.3 14.0796 -0.2204 (-1.5%)
2019-10-01
(2019Q4)
3.7 2.42 15534.2 207.496 14.145 14.0143 -0.1307 (-0.9%)
2019-07-01
(2019Q3)
4.0 2.4 15536.3 206.512 13.952 14.0161 0.0641 (0.5%)
2019-04-01
(2019Q2)
3.8 2.19 15274.1 205.06 13.86 13.8079 -0.0521 (-0.4%)
2019-01-01
(2019Q1)
3.8 1.91 15184.7 202.876 13.668 13.6812 0.0132 (0.1%)
2018-10-01
(2018Q4)
4.0 1.69 15007.2 200.627 13.544 13.5317 -0.0123 (-0.1%)
2018-07-01
(2018Q3)
4.0 1.41 14886.6 198.278 13.512 13.3849 -0.1271 (-0.9%)
2018-04-01
(2018Q2)
4.2 1.15 14748.6 194.76 13.293 13.22 -0.073 (-0.5%)
2018-01-01
(2018Q1)
4.3 1.15 14660.2 191.436 13.211 13.1004 -0.1106 (-0.8%)
2017-10-01
(2017Q4)
4.4 0.9 14509.3 188.697 13.148 12.9402 -0.2078 (-1.6%)
2017-07-01
(2017Q3)
4.7 0.65 14373.7 186.773 12.955 12.8266 -0.1284 (-1.0%)
2017-04-01
(2017Q2)
4.9 0.4 14235.4 183.721 12.839 12.6742 -0.1648 (-1.3%)
2017-01-01
(2017Q1)
4.8 0.39 14160.1 180.836 12.725 12.5531 -0.1719 (-1.4%)
2016-10-01
(2016Q4)
5.1 0.37 14106.2 178.741 12.576 12.4984 -0.0776 (-0.6%)
2016-07-01
(2016Q3)
4.8 0.34 14121.1 177.245 12.35 12.4382 0.0882 (0.7%)
2016-04-01
(2016Q2)
5.0 0.12 13996.9 174.763 12.287 12.3101 0.0231 (0.2%)
2016-01-01
(2016Q1)
5.2 0.13 13905.7 172.129 12.252 12.2165 -0.0355 (-0.3%)
2015-10-01
(2015Q4)
5.4 0.12 13842.0 170.279 12.116 12.1548 0.0388 (0.3%)
2015-07-01
(2015Q3)
5.7 0.11 13797.7 168.613 12.065 12.1167 0.0517 (0.4%)
2015-04-01
(2015Q2)
5.7 0.09 13550.7 166.627 11.853 11.9388 0.0858 (0.7%)
2015-01-01
(2015Q1)
6.2 0.09 13386.8 164.571 11.851 11.849 -0.002 (0.0%)
2014-10-01
(2014Q4)
6.2 0.09 13270.2 163.376 11.827 11.7595 -0.0675 (-0.6%)
2014-07-01
(2014Q3)
6.6 0.07 13079.5 161.92 11.71 11.6601 -0.0499 (-0.4%)
2014-04-01
(2014Q2)
7.2 0.09 12974.6 159.233 11.632 11.5956 -0.0364 (-0.3%)
2014-01-01
(2014Q1)
7.3 0.09 12941.8 155.595 11.65 11.4965 -0.1535 (-1.3%)
2013-10-01
(2013Q4)
7.6 0.15 12893.4 151.51 11.521 11.402 -0.119 (-1.0%)
2013-07-01
(2013Q3)
8.0 0.14 12845.5 146.817 11.28 11.2952 0.0152 (0.1%)
2013-04-01
(2013Q2)
7.8 0.16 13142.0 143.59 11.153 11.349 0.196 (1.8%)
2013-01-01
(2013Q1)
8.2 0.16 12999.8 141.659 11.231 11.2643 0.0333 (0.3%)
2012-10-01
(2012Q4)
8.2 0.14 13116.5 139.143 11.341 11.2588 -0.0822 (-0.7%)
2012-07-01
(2012Q3)
8.3 0.08 12967.5 136.596 11.31 11.1222 -0.1878 (-1.7%)
2012-04-01
(2012Q2)
8.8 0.07 12791.9 137.94 11.384 11.111 -0.273 (-2.4%)
2012-01-01
(2012Q1)
9.0 0.07 12805.6 139.728 11.4363 11.1813 -0.255 (-2.2%)
2011-10-01
(2011Q4)
9.1 0.1 12721.3 140.004 11.5368 11.1571 -0.3797 (-3.3%)
2011-07-01
(2011Q3)
9.1 0.17 12740.1 141.512 11.6612 11.2111 -0.4501 (-3.9%)
2011-04-01
(2011Q2)
9.4 0.19 12592.5 142.524 11.7295 11.1905 -0.539 (-4.6%)
2011-01-01
(2011Q1)
9.4 0.18 12554.2 144.984 11.7544 11.2319 -0.5225 (-4.4%)
2010-10-01
(2010Q4)
9.9 0.2 12447.1 146.399 11.7132 11.2603 -0.4529 (-3.9%)
2010-07-01
(2010Q3)
9.8 0.11 12285.8 147.396 11.8444 11.1854 -0.659 (-5.6%)
2010-04-01
(2010Q2)
10.0 0.12 12193.2 147.85 11.943 11.1688 -0.7742 (-6.5%)
2010-01-01
(2010Q1)
9.5 0.16 12218.7 148.407 12.1169 11.1539 -0.963 (-7.9%)
2009-10-01
(2009Q4)
9.0 0.15 12320.0 147.947 12.1661 11.1475 -1.0186 (-8.4%)
2009-07-01
(2009Q3)
7.8 0.15 12361.5 151.505 12.279 11.1486 -1.1304 (-9.2%)
2009-04-01
(2009Q2)
6.5 0.97 12240.5 158.326 12.4072 11.2162 -1.191 (-9.6%)
2009-01-01
(2009Q1)
5.8 2.01 12188.7 163.563 12.5296 11.3547 -1.1749 (-9.4%)
2008-10-01
(2008Q4)
5.0 2.28 12100.8 168.332 12.6699 11.3819 -1.288 (-10.2%)
2008-07-01
(2008Q3)
5.0 3.94 12137.1 173.131 12.6754 11.6761 -0.9993 (-7.9%)
2008-04-01
(2008Q2)
4.7 4.76 12080.4 176.622 12.5991 11.7841 -0.815 (-6.5%)
2008-01-01
(2008Q1)
4.7 5.26 12066.4 179.109 12.5365 11.8861 -0.6504 (-5.2%)
2007-10-01
(2007Q4)
4.5 5.25 12052.8 183.009 12.3716 11.9581 -0.4135 (-3.3%)
2007-07-01
(2007Q3)
4.6 5.25 11956.6 184.515 12.1325 11.956 -0.1765 (-1.5%)
2007-04-01
(2007Q2)
4.4 5.25 11853.7 183.197 11.8498 11.852 0.0022 (0.0%)
2007-01-01
(2007Q1)
4.7 5.24 11746.9 183.068 11.4953 11.8207 0.3254 (2.8%)
2006-10-01
(2006Q4)
4.7 4.79 11744.4 184.33 11.3133 11.8092 0.4959 (4.4%)
2006-07-01
(2006Q3)
4.7 4.29 11651.8 182.322 11.1114 11.6647 0.5533 (5.0%)
2006-04-01
(2006Q2)
5.0 3.78 11428.7 178.03 10.7471 11.4226 0.6755 (6.3%)
2006-01-01
(2006Q1)
5.0 3.26 11387.1 172.861 10.3818 11.2228 0.841 (8.1%)
2005-10-01
(2005Q4)
5.2 2.79 11304.2 167.503 10.0022 11.0202 1.018 (10.2%)
2005-07-01
(2005Q3)
5.3 2.28 11226.5 161.288 9.7921 10.7857 0.9936 (10.1%)
2005-04-01
(2005Q2)
5.5 1.76 11282.5 155.751 9.4918 10.6448 1.153 (12.1%)
2005-01-01
(2005Q1)
5.5 1.26 11240.5 151.339 9.2067 10.4657 1.259 (13.7%)
2004-10-01
(2004Q4)
5.6 1.0 11153.3 146.593 9.0416 10.2867 1.2451 (13.8%)
2004-07-01
(2004Q3)
5.7 1.0 11051.2 141.647 8.833 10.1193 1.2863 (14.6%)
2004-04-01
(2004Q2)
6.0 1.01 10982.3 137.533 8.46 10.009 1.549 (18.3%)
2004-01-01
(2004Q1)
6.2 1.01 10991.1 133.777 8.2893 9.9373 1.648 (19.9%)