Waterfall Forensics.

Tie-out heatmap

Sequoia Mortgage Trust 2011-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.

50

periods replayed

98.1%

of 912 points within one dollar

17

points off by more than a dollar

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

The exception queue

17 of 912 comparisons sit more than a dollar from the trustee's figure. This is the entire list. Of the rest, 654 matched to the exact cent and 163 differed by cents, rounding-sized and never compounding.

DateClassFigureComputedReportedΔ
2013-12-26A-IOinterest47,000.9749,440.232439.26
2012-05-25A-IOinterest164,638.25163,882.06756.19
2013-06-25A-IOinterest69,048.3368,323.54724.79
2012-04-25A-IOinterest171,168.12170,735.60432.52
2012-06-25A-IOinterest155,011.46154,806.67204.79
2012-11-26A-IOinterest117,028.60116,905.31123.29
2012-07-25A-IOinterest148,105.13148,026.7378.40
2011-11-25A-IOinterest199,880.02199,824.5055.52
2013-01-25A-IOinterest101,540.76101,491.0149.75
2013-02-25A-IOinterest91,986.1091,942.1843.92
2012-03-26A-IOinterest180,089.37180,053.1736.20
2012-01-25A-IOinterest190,229.58190,194.4035.18
2012-02-27A-IOinterest185,310.42185,278.5431.88
2011-12-27A-IOinterest193,094.49193,062.6831.81
2012-12-26A-IOinterest106,584.49106,564.7919.70
2013-11-25A-IOinterest48,974.0348,966.747.29
2013-12-26A-1interest279,142.22279,148.606.38

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