Waterfall Forensics.

Tie-out heatmap

Sequoia Mortgage Trust 2013-2

Every comparison the backtest ever made, on one screen: one column per distribution date, one row per class, colored by the worst absolute delta across interest, principal, and ending balance. The near-uniform field is the point. The few cells that broke a dollar are listed below, worst first.

154

periods replayed

94.9%

of 3,077 points within one dollar

157

points off by more than a dollar

AB-1B-2B-3B-4B-5A-IO1A-IO2
2014201520162017201820192020202120222023202420252026
exact to the centwithin a pennywithin a dollarover a dollarno comparisonhover any cell for its worst delta

The exception queue

157 of 3,077 comparisons sit more than a dollar from the trustee's figure. This is the entire list. Of the rest, 1,876 matched to the exact cent and 860 differed by cents, rounding-sized and never compounding.

DateClassFigureComputedReportedΔ
2024-06-25B-5interest19,933.8018,256.561677.24
2024-07-25B-5interest20,432.0322,064.991632.96
2024-06-25Ainterest71,374.6972,162.02787.33
2024-06-25A-IO2interest43,218.1743,694.82476.65
2024-06-25A-IO1interest23,842.3524,105.35263.00
2024-06-25B-1interest5,036.305,091.8555.55
2024-06-25B-2interest4,349.974,397.9547.98
2024-06-25B-3interest2,289.262,314.5125.25
2024-06-25B-4interest1,945.921,967.3821.46
2020-07-27B-5ending balance6,653,748.766,653,745.043.72
2020-08-25B-5ending balance6,653,748.766,653,745.043.72
2020-09-25B-5ending balance6,653,748.766,653,745.043.72
2020-10-26B-5ending balance6,653,748.766,653,745.043.72
2020-11-25B-5ending balance6,653,748.766,653,745.043.72
2020-12-28B-5ending balance6,653,748.766,653,745.043.72
2021-01-25B-5ending balance6,653,748.766,653,745.043.72
2021-02-25B-5ending balance6,653,748.766,653,745.043.72
2021-03-25B-5ending balance6,653,748.766,653,745.043.72
2021-04-26B-5ending balance6,653,748.766,653,745.043.72
2021-05-25B-5ending balance6,653,748.766,653,745.043.72
2021-06-25B-5ending balance6,653,748.766,653,745.043.72
2021-07-26B-5ending balance6,653,748.766,653,745.043.72
2021-08-25B-5ending balance6,653,748.766,653,745.043.72
2021-09-27B-5ending balance6,653,748.766,653,745.043.72
2021-10-25B-5ending balance6,653,748.766,653,745.043.72
2021-11-26B-5ending balance6,653,748.766,653,745.043.72
2021-12-27B-5ending balance6,653,748.766,653,745.043.72
2022-01-25B-5ending balance6,653,748.766,653,745.043.72
2022-02-25B-5ending balance6,653,748.766,653,745.043.72
2022-03-25B-5ending balance6,653,748.766,653,745.043.72
2022-04-25B-5ending balance6,653,748.766,653,745.043.72
2022-05-25B-5ending balance6,653,748.766,653,745.043.72
2022-06-27B-5ending balance6,653,748.766,653,745.043.72
2022-07-25B-5ending balance6,653,748.766,653,745.043.72
2022-08-25B-5ending balance6,653,748.766,653,745.043.72
2022-09-26B-5ending balance6,653,748.766,653,745.043.72
2022-10-25B-5ending balance6,653,748.766,653,745.043.72
2022-11-25B-5ending balance6,653,748.766,653,745.043.72
2022-12-27B-5ending balance6,653,748.766,653,745.043.72
2023-01-25B-5ending balance6,653,748.766,653,745.043.72
2023-02-27B-5ending balance6,653,748.766,653,745.043.72
2023-03-27B-5ending balance6,653,748.766,653,745.043.72
2023-04-25B-5ending balance6,653,748.766,653,745.043.72
2023-05-25B-5ending balance6,653,748.766,653,745.043.72
2023-06-26B-5ending balance6,653,748.766,653,745.043.72
2023-07-25B-5ending balance6,653,748.766,653,745.043.72
2023-08-25B-5ending balance6,653,748.766,653,745.043.72
2023-09-25B-5ending balance6,653,748.766,653,745.043.72
2023-10-25B-5ending balance6,653,748.766,653,745.043.72
2023-11-27B-5ending balance6,653,748.766,653,745.043.72
2023-12-26B-5ending balance6,653,748.766,653,745.043.72
2024-01-25B-5ending balance6,653,748.766,653,745.043.72
2024-02-26B-5ending balance6,653,748.766,653,745.043.72
2024-03-25B-5ending balance6,653,748.766,653,745.043.72
2024-04-25B-5ending balance6,653,748.766,653,745.043.72
2024-05-28B-5ending balance6,653,748.766,653,745.043.72
2024-06-25B-5ending balance6,653,748.766,653,745.043.72
2024-07-25B-5ending balance6,653,748.766,653,745.043.72
2024-08-26B-5ending balance6,653,748.766,653,745.043.72
2024-09-25B-5ending balance6,653,748.766,653,745.043.72
2024-10-25B-5ending balance6,653,748.766,653,745.043.72
2024-11-25B-5ending balance6,653,748.766,653,745.043.72
2024-12-26B-5ending balance6,653,748.766,653,745.043.72
2025-01-27B-5ending balance6,653,748.766,653,745.043.72
2025-02-25B-5ending balance6,653,748.766,653,745.043.72
2025-03-25B-5ending balance6,653,748.766,653,745.043.72
2025-04-25B-5ending balance6,653,748.766,653,745.043.72
2025-05-27B-5ending balance6,653,748.766,653,745.043.72
2025-06-25B-5ending balance6,653,748.766,653,745.043.72
2025-07-25B-5ending balance6,653,748.766,653,745.043.72
2025-08-25B-5ending balance6,653,748.766,653,745.043.72
2025-09-25B-5ending balance6,653,748.766,653,745.043.72
2025-10-27B-5ending balance6,653,748.766,653,745.043.72
2025-11-25B-5ending balance6,653,748.766,653,745.043.72
2025-12-26B-5ending balance6,653,748.766,653,745.043.72
2026-01-26B-5ending balance6,653,748.766,653,745.043.72
2026-02-25B-5ending balance6,653,748.766,653,745.043.72
2026-03-25B-5ending balance6,653,748.766,653,745.043.72
2026-04-27B-5ending balance6,653,748.766,653,745.043.72
2026-05-26B-5ending balance6,653,748.766,653,745.043.72
2026-06-25B-5ending balance6,653,748.766,653,745.043.72
2026-07-27B-5ending balance6,653,748.766,653,745.043.72
2026-08-25B-5ending balance6,653,748.766,653,745.043.72
2026-09-25B-5ending balance6,653,748.766,653,745.043.72
2020-02-25B-5ending balance6,653,748.766,653,745.053.71
2020-03-25B-5ending balance6,653,748.766,653,745.053.71
2020-04-27B-5ending balance6,653,748.766,653,745.053.71
2020-05-26B-5ending balance6,653,748.766,653,745.053.71
2020-06-25B-5ending balance6,653,748.766,653,745.053.71
2017-10-25B-5ending balance6,666,769.786,666,766.083.70
2018-01-25B-5ending balance6,653,748.766,653,745.063.70
2018-02-26B-5ending balance6,653,748.766,653,745.063.70
2018-03-26B-5ending balance6,653,748.766,653,745.063.70
2018-04-25B-5ending balance6,653,748.766,653,745.063.70
2018-05-25B-5ending balance6,653,748.766,653,745.063.70
2018-06-25B-5ending balance6,653,748.766,653,745.063.70
2018-07-25B-5ending balance6,653,748.766,653,745.063.70
2018-08-27B-5ending balance6,653,748.766,653,745.063.70
2018-09-25B-5ending balance6,653,748.766,653,745.063.70
2018-10-25B-5ending balance6,653,748.766,653,745.063.70
2018-11-26B-5ending balance6,653,748.766,653,745.063.70
2018-12-26B-5ending balance6,653,748.766,653,745.063.70
2019-01-25B-5ending balance6,653,748.766,653,745.063.70
2019-02-25B-5ending balance6,653,748.766,653,745.063.70
2019-03-25B-5ending balance6,653,748.766,653,745.063.70
2019-04-25B-5ending balance6,653,748.766,653,745.063.70
2019-05-28B-5ending balance6,653,748.766,653,745.063.70
2019-06-25B-5ending balance6,653,748.766,653,745.063.70
2019-07-25B-5ending balance6,653,748.766,653,745.063.70
2019-08-26B-5ending balance6,653,748.766,653,745.063.70
2019-09-25B-5ending balance6,653,748.766,653,745.063.70
2019-10-25B-5ending balance6,653,748.766,653,745.063.70
2019-11-25B-5ending balance6,653,748.766,653,745.063.70
2019-12-26B-5ending balance6,653,748.766,653,745.063.70
2020-01-27B-5ending balance6,653,748.766,653,745.063.70
2017-11-27B-5ending balance6,653,748.766,653,745.073.69
2017-12-26B-5ending balance6,653,748.766,653,745.073.69
2017-06-26B-5ending balance6,718,116.566,718,112.943.62
2017-07-25B-5ending balance6,705,355.696,705,352.073.62
2017-09-25B-5ending balance6,679,703.746,679,700.133.61
2017-08-25B-5ending balance6,692,551.246,692,547.643.60
2017-05-25B-5ending balance6,730,827.676,730,824.073.60
2017-04-25B-5ending balance6,743,493.196,743,489.803.39
2017-03-27B-5ending balance6,756,116.186,756,113.053.13
2017-02-27B-5ending balance6,768,708.206,768,705.242.96
2017-01-25B-5ending balance6,781,397.846,781,394.992.85
2016-12-27B-5ending balance6,793,994.426,793,991.642.78
2016-11-25B-5ending balance6,806,549.336,806,546.602.73
2016-06-27B-5ending balance6,867,842.796,867,840.282.51
2016-07-25B-5ending balance6,855,657.686,855,655.172.51
2016-09-26B-5ending balance6,831,348.446,831,345.932.51
2016-10-25B-5ending balance6,818,975.856,818,973.342.51
2016-08-25B-5ending balance6,843,522.196,843,519.682.51
2016-05-25B-5ending balance6,880,009.266,880,006.802.46
2016-04-25B-5ending balance6,892,129.886,892,127.422.46
2016-03-25B-5ending balance6,904,178.656,904,176.232.42
2016-02-25B-5ending balance6,916,180.996,916,178.622.37
2015-11-25B-5ending balance6,951,888.566,951,886.362.20
2015-12-28B-5ending balance6,939,973.106,939,970.912.19
2016-01-25B-5ending balance6,928,104.436,928,102.252.18
2015-07-27B-5ending balance6,999,054.786,999,052.672.11
2015-09-25B-5ending balance6,975,565.866,975,563.752.11
2015-10-26B-5ending balance6,963,759.246,963,757.132.11
2015-08-25B-5ending balance6,987,330.796,987,328.692.10
2015-06-25B-5ending balance7,010,686.277,010,684.431.84
2015-05-26B-5ending balance7,022,213.517,022,211.801.71
2015-04-27B-5ending balance7,033,750.117,033,748.611.50
2015-02-25B-5ending balance7,056,757.167,056,755.771.39
2015-03-25B-5ending balance7,045,258.287,045,256.901.38
2015-01-26B-5ending balance7,068,233.867,068,232.531.33
2014-12-26B-5ending balance7,079,675.997,079,674.771.22
2014-11-25B-5ending balance7,091,065.577,091,064.391.18
2014-10-27B-5ending balance7,102,384.847,102,383.711.13
2014-09-25B-5ending balance7,113,627.257,113,626.121.13
2014-08-25B-5ending balance7,124,817.637,124,816.511.12
2014-07-25B-5ending balance7,135,968.527,135,967.401.12
2014-06-25B-5ending balance7,147,071.227,147,070.151.07

state rolls forward on computed values only — reported figures are never fed back in, so an engine error would compound rather than hide