Waterfall Forensics.

Prime fixed-rate RMBS

Wells Fargo Mortgage Backed Securities 2007-9

424B5 filed 2007-06-28, acc 0001193125-07-145193

machine-encoded from the prospectus by the extraction pipeline and tied out over 5 periods (2007-08-27 to 2007-12-26); not yet expert-verified

Backtested periods

5

2007-08-27 to 2007-12-26

Comparison points within $1

97.4%

270 points

Max principal delta

$0.99

interest $660.13 · balance $1.00

What the encoder found in the filings

  • dropped I-A-8, I-A-9, II-A-3: never reported by the trustee, so not part of the deal as issued
  • I-A-PO: draft face 1,245,029.00 -> reported 1,245,029.10 (pinned from the remittance Original Balance)
  • II-A-PO: draft face 938,785.00 -> reported 938,785.09 (pinned from the remittance Original Balance)
  • B-6: draft face 752,453.00 -> reported 752,453.60 (pinned from the remittance Original Balance)
  • group 1 has 9 senior classes (I-A-1, I-A-2, I-A-3, I-A-4, I-A-5, I-A-6, I-A-7, I-A-PO, I-A-R); assumed pro rata, but the contract may pay them as components — check the tie-out
  • group 2 has 3 senior classes (II-A-1, II-A-2, II-A-PO); assumed pro rata, but the contract may pay them as components — check the tie-out
  • exchangeable certificates left out of the tie-out (their rows duplicate the underlying classes): I-A-8, I-A-9, II-A-3
  • class names aligned across report formats: 1-A-7->I-A-7, I-A-P->I-A-PO, II-A-P->II-A-PO
  • backtest window starts at deal month 2 (2007-08-27); state initialized from that report's reported beginning balances. Floor-provision 'initial' fractions are pinned from this window's first period, not closing — inert for this window (floors cannot bind while subordination is growing).

Capital structure · original faces

I-A-1
$268,800,000.00
I-A-2
$51,400,000.00
I-A-3
$6,900,000.00
I-A-4
$1,840,000.00
I-A-5
$39,090,000.00
I-A-6
$1,000,000.00
I-A-7
$20,480,000.00
I-A-PO
$1,245,029.10
I-A-R
$100.00
II-A-1
$336,660,000.00
II-A-2
$4,317,000.00
II-A-PO
$938,785.09
B-1
$13,909,000.00
B-2
$1,504,000.00
B-3
$1,503,000.00
B-4
$752,000.00
B-5
$752,000.00
B-6
$752,453.60

viridian = senior (per-pool) · burgundy = cross-collateralized subordinates

Worst remaining deltas · computed vs reported

interest

2007-12-26II-A-1-660.13
2007-12-26I-A-2-110.33
2007-12-26I-A-7-45.39
2007-12-26I-A-1-12.46
2007-12-26II-A-2-8.91

principal

2007-12-26I-A-2-0.99
2007-12-26I-A-7+0.99
2007-09-25I-A-1+0.01
2007-10-25I-A-1-0.01
2007-11-26I-A-1-0.01

ending balance

2007-12-26I-A-7-1.00
2007-12-26I-A-2+1.00
2007-12-26B-6-0.03
2007-12-26I-A-3+0.02
2007-10-25B-3-0.02