Waterfall Forensics.

Tie-out heatmap

Wells Fargo Mortgage Backed Securities 2007-6 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.

8

periods replayed

97.6%

of 336 points within one dollar

8

points off by more than a dollar

A-1A-2A-3A-4A-5A-6A-POA-RB-1B-2B-3B-4B-5B-6
2007
exact to the centwithin a pennywithin a dollarover a dollarno comparisonhover any cell for its worst delta

The exception queue

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

DateClassFigureComputedReportedΔ
2007-12-26A-3interest39,332.0959,663.0220330.93
2007-11-26A-3interest39,328.7656,144.3416815.58
2007-09-25A-2interest235,999.11244,062.728063.61
2007-10-25A-3interest39,334.2445,971.976637.74
2007-05-25A-2interest235,947.01236,733.70786.70
2007-08-27A-2interest236,080.32236,867.01786.70
2007-06-25A-2interest236,170.89236,957.58786.69
2007-07-25A-2interest235,976.46236,763.15786.69

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