Waterfall Forensics.

Tie-out heatmap

Sequoia Mortgage 2010-H1

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.

57

periods replayed

98.4%

of 1,110 points within one dollar

18

points off by more than a dollar

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

The exception queue

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

DateClassFigureComputedReportedΔ
2014-09-25A-IOinterest0.002,396.902396.90
2014-09-25A-1interest15,286.7012,889.852396.85
2014-10-27A-IOinterest0.002,395.252395.25
2014-10-27A-1interest12,961.3210,566.092395.23
2014-11-25A-IOinterest0.002,227.892227.89
2014-11-25A-1interest11,611.979,384.102227.87
2014-12-26A-IOinterest0.002,225.212225.21
2014-12-26A-1interest11,597.749,372.542225.20
2015-01-26A-IOinterest0.002,174.962174.96
2015-01-26A-1interest10,837.818,662.862174.95
2015-02-25A-IOinterest0.002,173.082173.08
2015-02-25A-1interest10,828.458,655.382173.07
2015-03-25A-IOinterest0.002,169.862169.86
2015-03-25A-1interest10,812.428,642.572169.85
2015-04-27A-1interest10,803.768,635.642168.12
2015-04-27A-IOinterest0.002,168.122168.12
2015-05-26A-IOinterest0.002,163.242163.24
2015-05-26A-1interest10,779.438,616.212163.22

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