Waterfall Forensics.

Tie-out heatmap

Sequoia Mortgage Trust 2012-5

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.

98

periods replayed

99.5%

of 1,806 points within one dollar

9

points off by more than a dollar

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

The exception queue

9 of 1,806 comparisons sit more than a dollar from the trustee's figure. This is the entire list. Of the rest, 1,275 matched to the exact cent and 331 differed by cents, rounding-sized and never compounding.

DateClassFigureComputedReportedΔ
2022-01-25B-5interest10,087.0711,708.051620.98
2021-01-25B-5interest9,972.138,687.581284.55
2021-01-25Ainterest80,603.6081,307.54703.94
2021-01-25A-IOinterest44,587.8244,977.21389.39
2020-11-25B-5interest11,118.4610,868.04250.42
2021-01-25B-1interest13,317.8313,434.14116.31
2021-01-25B-2interest8,293.838,366.2772.44
2021-01-25B-3interest5,780.275,830.7550.48
2021-01-25B-4interest4,021.404,056.5235.12

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