Waterfall Forensics.

Tie-out heatmap

Sequoia Mortgage Trust 2013-7

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.

160

periods replayed

99.7%

of 3,654 points within one dollar

10

points off by more than a dollar

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

The exception queue

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

DateClassFigureComputedReportedΔ
2024-06-25B-5interest13,759.2812,081.371677.91
2024-07-25B-5interest14,182.6915,746.181563.49
2024-06-25A-2interest78,066.7278,989.89923.17
2024-06-25A-1interest27,208.2627,530.01321.75
2024-06-25A-IO2interest18,713.8118,935.02221.21
2024-06-25A-IO1interest5,441.655,506.0064.35
2024-06-25B-1interest4,067.474,115.5748.10
2024-06-25B-2interest3,841.313,886.7345.42
2024-06-25B-3interest3,276.393,315.1438.75
2024-06-25B-4interest1,281.841,297.0015.16

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