Waterfall Forensics.

Tie-out heatmap

Sequoia Mortgage Trust 2013-3

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

95.8%

of 3,542 points within one dollar

150

points off by more than a dollar

A-1A-2B-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

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

DateClassFigureComputedReportedΔ
2022-12-27A-IO2interest56,694.2757,471.49777.22
2022-12-27B-5interest17,932.7917,671.03261.76
2017-06-26B-5ending balance6,030,741.726,030,737.644.08
2017-07-25B-5ending balance6,018,616.196,018,612.114.08
2017-08-25B-5ending balance6,006,438.016,006,433.944.07
2017-09-25B-5ending balance5,994,236.915,994,232.854.06
2017-10-25B-5ending balance5,994,236.915,994,232.854.06
2017-11-27B-5ending balance5,994,236.915,994,232.854.06
2017-12-26B-5ending balance5,994,236.915,994,232.854.06
2018-01-25B-5ending balance5,994,236.915,994,232.854.06
2018-02-26B-5ending balance5,994,236.915,994,232.854.06
2018-03-26B-5ending balance5,994,236.915,994,232.854.06
2018-04-25B-5ending balance5,994,236.915,994,232.854.06
2018-05-25B-5ending balance5,994,236.915,994,232.854.06
2018-06-25B-5ending balance5,994,236.915,994,232.854.06
2018-07-25B-5ending balance5,994,236.915,994,232.854.06
2018-08-27B-5ending balance5,994,236.915,994,232.854.06
2018-09-25B-5ending balance5,994,236.915,994,232.854.06
2018-10-25B-5ending balance5,994,236.915,994,232.854.06
2018-11-26B-5ending balance5,994,236.915,994,232.854.06
2018-12-26B-5ending balance5,994,236.915,994,232.854.06
2019-01-25B-5ending balance5,994,236.915,994,232.854.06
2019-02-25B-5ending balance5,994,236.915,994,232.854.06
2019-03-25B-5ending balance5,994,236.915,994,232.854.06
2019-04-25B-5ending balance5,994,236.915,994,232.854.06
2019-05-28B-5ending balance5,994,236.915,994,232.854.06
2019-06-25B-5ending balance5,994,236.915,994,232.854.06
2019-07-25B-5ending balance5,994,236.915,994,232.854.06
2019-08-26B-5ending balance5,994,236.915,994,232.854.06
2019-09-25B-5ending balance5,994,236.915,994,232.854.06
2019-10-25B-5ending balance5,994,236.915,994,232.854.06
2019-11-25B-5ending balance5,994,236.915,994,232.854.06
2019-12-26B-5ending balance5,994,236.915,994,232.854.06
2020-01-27B-5ending balance5,994,236.915,994,232.854.06
2020-02-25B-5ending balance5,994,236.915,994,232.854.06
2020-03-25B-5ending balance5,994,236.915,994,232.854.06
2020-04-27B-5ending balance5,994,236.915,994,232.854.06
2020-05-26B-5ending balance5,994,236.915,994,232.854.06
2020-06-25B-5ending balance5,994,236.915,994,232.854.06
2020-07-27B-5ending balance5,994,236.915,994,232.854.06
2020-08-25B-5ending balance5,994,236.915,994,232.854.06
2020-09-25B-5ending balance5,994,236.915,994,232.854.06
2020-10-26B-5ending balance5,994,236.915,994,232.854.06
2020-11-25B-5ending balance5,994,236.915,994,232.854.06
2020-12-28B-5ending balance5,994,236.915,994,232.854.06
2021-01-25B-5ending balance5,994,236.915,994,232.854.06
2021-02-25B-5ending balance5,994,236.915,994,232.854.06
2021-03-25B-5ending balance5,994,236.915,994,232.854.06
2021-04-26B-5ending balance5,994,236.915,994,232.854.06
2021-05-25B-5ending balance5,994,236.915,994,232.854.06
2021-06-25B-5ending balance5,994,236.915,994,232.854.06
2021-07-26B-5ending balance5,994,236.915,994,232.854.06
2021-08-25B-5ending balance5,994,236.915,994,232.854.06
2021-09-27B-5ending balance5,994,236.915,994,232.854.06
2021-10-25B-5ending balance5,994,236.915,994,232.854.06
2021-11-26B-5ending balance5,994,236.915,994,232.854.06
2021-12-27B-5ending balance5,994,236.915,994,232.854.06
2022-01-25B-5ending balance5,994,236.915,994,232.854.06
2022-02-25B-5ending balance5,994,236.915,994,232.854.06
2022-03-25B-5ending balance5,994,236.915,994,232.854.06
2022-04-25B-5ending balance5,994,236.915,994,232.854.06
2022-05-25B-5ending balance5,994,236.915,994,232.854.06
2022-06-27B-5ending balance5,994,236.915,994,232.854.06
2022-07-25B-5ending balance5,994,236.915,994,232.854.06
2022-08-25B-5ending balance5,994,236.915,994,232.854.06
2022-09-26B-5ending balance5,994,236.915,994,232.854.06
2022-10-25B-5ending balance5,994,236.915,994,232.854.06
2022-11-25B-5ending balance5,994,236.915,994,232.854.06
2022-12-27B-5ending balance5,994,236.915,994,232.854.06
2023-01-25B-5ending balance5,994,236.915,994,232.854.06
2023-02-27B-5ending balance5,994,236.915,994,232.854.06
2023-03-27B-5ending balance5,994,236.915,994,232.854.06
2023-04-25B-5ending balance5,994,236.915,994,232.854.06
2023-05-25B-5ending balance5,994,236.915,994,232.854.06
2023-06-26B-5ending balance5,994,236.915,994,232.854.06
2023-07-25B-5ending balance5,994,236.915,994,232.854.06
2023-08-25B-5ending balance5,994,236.915,994,232.854.06
2023-09-25B-5ending balance5,994,236.915,994,232.854.06
2023-10-25B-5ending balance5,994,236.915,994,232.854.06
2023-11-27B-5ending balance5,994,236.915,994,232.854.06
2023-12-26B-5ending balance5,994,236.915,994,232.854.06
2024-01-25B-5ending balance5,994,236.915,994,232.854.06
2024-02-26B-5ending balance5,994,236.915,994,232.854.06
2024-03-25B-5ending balance5,994,236.915,994,232.854.06
2024-04-25B-5ending balance5,994,236.915,994,232.854.06
2024-05-28B-5ending balance5,994,236.915,994,232.854.06
2024-06-25B-5ending balance5,994,236.915,994,232.854.06
2024-07-25B-5ending balance5,994,236.915,994,232.854.06
2024-08-26B-5ending balance5,994,236.915,994,232.854.06
2024-09-25B-5ending balance5,994,236.915,994,232.854.06
2024-10-25B-5ending balance5,994,236.915,994,232.854.06
2024-11-25B-5ending balance5,994,236.915,994,232.854.06
2024-12-26B-5ending balance5,994,236.915,994,232.854.06
2025-01-27B-5ending balance5,994,236.915,994,232.854.06
2025-02-25B-5ending balance5,994,236.915,994,232.854.06
2025-03-25B-5ending balance5,994,236.915,994,232.854.06
2025-04-25B-5ending balance5,994,236.915,994,232.854.06
2025-05-27B-5ending balance5,994,236.915,994,232.854.06
2025-06-25B-5ending balance5,994,236.915,994,232.854.06
2025-07-25B-5ending balance5,994,236.915,994,232.854.06
2025-08-25B-5ending balance5,994,236.915,994,232.854.06
2025-09-25B-5ending balance5,994,236.915,994,232.854.06
2025-10-27B-5ending balance5,994,236.915,994,232.854.06
2025-11-25B-5ending balance5,994,236.915,994,232.854.06
2025-12-26B-5ending balance5,994,236.915,994,232.854.06
2026-01-26B-5ending balance5,994,236.915,994,232.854.06
2026-02-25B-5ending balance5,994,236.915,994,232.854.06
2026-03-25B-5ending balance5,994,236.915,994,232.854.06
2026-04-27B-5ending balance5,994,236.915,994,232.854.06
2026-05-26B-5ending balance5,994,236.915,994,232.854.06
2026-06-25B-5ending balance5,994,236.915,994,232.854.06
2026-07-27B-5ending balance5,994,236.915,994,232.854.06
2026-08-25B-5ending balance5,994,236.915,994,232.854.06
2026-09-25B-5ending balance5,994,236.915,994,232.854.06
2017-05-25B-5ending balance6,042,791.366,042,787.314.05
2017-04-25B-5ending balance6,054,793.186,054,789.154.03
2017-03-27B-5ending balance6,066,720.986,066,717.013.97
2017-01-25B-5ending balance6,090,534.366,090,530.453.91
2017-02-27B-5ending balance6,078,587.716,078,583.813.90
2016-12-27B-5ending balance6,102,410.926,102,407.073.85
2016-11-25B-5ending balance6,114,262.076,114,258.303.77
2016-09-26B-5ending balance6,137,690.196,137,686.623.57
2016-10-25B-5ending balance6,126,005.166,126,001.603.56
2016-08-25B-5ending balance6,149,327.796,149,324.553.24
2016-07-25B-5ending balance6,160,976.276,160,973.143.13
2016-01-25B-5ending balance6,229,642.076,229,639.102.97
2016-02-25B-5ending balance6,218,342.366,218,339.402.96
2016-03-25B-5ending balance6,206,988.496,206,985.542.95
2016-04-25B-5ending balance6,195,586.176,195,583.232.94
2016-05-25B-5ending balance6,184,103.376,184,100.432.94
2016-06-27B-5ending balance6,172,562.276,172,559.342.93
2015-07-27B-5ending balance6,296,388.916,296,386.062.85
2015-08-25B-5ending balance6,285,376.726,285,373.872.85
2015-09-25B-5ending balance6,274,321.746,274,318.902.84
2015-10-26B-5ending balance6,263,227.606,263,224.772.83
2015-11-25B-5ending balance6,252,082.206,252,079.372.83
2015-12-28B-5ending balance6,240,888.116,240,885.302.81
2015-05-26B-5ending balance6,318,218.906,318,216.192.71
2015-06-25B-5ending balance6,307,317.826,307,315.122.70
2015-04-27B-5ending balance6,329,067.706,329,065.082.62
2014-11-25B-5ending balance6,382,564.346,382,561.942.40
2014-12-26B-5ending balance6,371,936.266,371,933.862.40
2015-01-26B-5ending balance6,361,267.076,361,264.682.39
2015-02-25B-5ending balance6,350,599.566,350,597.182.38
2015-03-25B-5ending balance6,339,887.096,339,884.712.38
2014-10-27B-5ending balance6,393,146.506,393,144.282.22
2014-09-25B-5ending balance6,403,663.946,403,661.912.03
2014-08-25B-5ending balance6,414,143.186,414,141.701.48
2014-07-25B-5ending balance6,424,575.886,424,574.671.21
2014-06-25B-5ending balance6,434,952.806,434,951.591.21

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