Waterfall Forensics.

Tie-out heatmap

Wells Fargo Mortgage Backed Securities 2006-AR6 Trust

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.

9

periods replayed

98.5%

of 540 points within one dollar

8

points off by more than a dollar

I-A-1I-A-RII-A-1II-A-2III-A-1III-A-2IV-A-1IV-A-2V-A-1V-A-2VI-A-1VI-A-2VII-A-1VII-A-2B-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

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

DateClassFigureComputedReportedΔ
2006-04-25VII-A-1interest3,271,281.103,271,284.363.26
2006-06-26VII-A-1interest3,241,580.413,241,577.422.99
2006-10-25VII-A-1interest3,190,973.433,190,976.342.91
2006-05-25VII-A-1interest3,258,048.783,258,046.292.49
2006-09-25VII-A-1interest3,200,609.763,200,607.452.31
2006-04-25III-A-1interest1,369,695.981,369,694.861.12
2006-06-26III-A-1interest1,349,183.761,349,184.881.12
2006-12-26III-A-1interest1,281,273.411,281,272.401.01

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