Waterfall Forensics.

Tie-out heatmap

Wells Fargo Mortgage Backed Securities 2008-AR2

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

97.1%

of 280 points within one dollar

8

points off by more than a dollar

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

The exception queue

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

DateClassFigureComputedReportedΔ
2008-11-25A-1interest520,249.81486,685.3133564.50
2008-11-25A-IOinterest287,293.74320,858.1533564.41
2008-10-27A-1interest500,724.22534,105.8433381.62
2008-10-27A-IOinterest316,173.42282,792.3433381.08
2008-03-25A-IOinterest375,466.69394,204.9918738.30
2008-03-25A-1interest560,546.77541,809.2818737.49
2008-12-26A-IOinterest532,155.19523,356.188799.01
2008-12-26A-1interest262,785.56271,545.088759.52

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