Waterfall Forensics.

Tie-out heatmap

Wells Fargo Mortgage Backed Securities 2006-3 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.

10

periods replayed

98.3%

of 600 points within one dollar

10

points off by more than a dollar

A-1A-2A-3A-4A-5A-6A-7A-8A-9A-10A-11A-12A-POA-RB-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

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

DateClassFigureComputedReportedΔ
2006-03-27A-3interest340,170.99355,635.1515464.16
2006-04-25A-3interest339,542.28354,981.0515438.77
2006-05-25A-3interest338,799.47354,201.1515401.68
2006-06-26A-3interest338,029.16353,382.0715352.91
2006-07-25A-3interest336,257.62351,550.1115292.49
2006-08-25A-3interest334,836.24350,056.7115220.47
2006-09-25A-3interest333,015.18348,152.1315136.95
2006-11-27A-3interest333,011.55348,148.5015136.95
2006-10-25A-3interest332,978.53348,115.4715136.94
2006-12-26A-3interest326,544.72341,387.5414842.82

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