Waterfall Forensics.

Tie-out heatmap

Wells Fargo Mortgage Backed Securities 2006-AR10

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.

6

periods replayed

98.2%

of 396 points within one dollar

7

points off by more than a dollar

I-A-1I-A-2I-A-RII-A-1II-A-2III-A-1III-A-2IV-A-1IV-A-2V-A-1V-A-2V-A-3V-A-4V-A-5V-A-6V-A-7B-1B-2B-3B-4B-5B-6
2006
exact to the centwithin a pennywithin a dollarover a dollarno comparisonhover any cell for its worst delta

The exception queue

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

DateClassFigureComputedReportedΔ
2006-10-25I-A-1interest2,281,711.772,281,709.722.05
2006-11-27I-A-1interest2,248,434.552,248,436.121.57
2006-07-25IV-A-1interest1,573,942.481,573,944.001.52
2006-11-27IV-A-1interest1,509,504.051,509,505.261.21
2006-09-25I-A-1interest2,297,844.682,297,845.831.15
2006-07-25I-A-1interest2,357,987.682,357,988.721.04
2006-10-25IV-A-1interest1,526,851.921,526,852.951.03

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