Waterfall Forensics.

Prime fixed-rate RMBS

Wells Fargo Mortgage Backed Securities 2007-11

424B5 filed 2007-07-31, acc 0001193125-07-166764

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

98.4%

990 points

Max principal delta

$0.03

interest $1085457.09 · balance $0.05

What the encoder found in the filings

  • dropped A-1, A-45, A-46, A-47, A-48, A-49, A-60, A-71, A-72, A-73, A-74, A-75, A-76, A-77, A-78, A-79, A-80, A-81, A-82, A-83, A-84, A-85, A-86, A-87, A-88, A-89, A-90, A-91, A-92, A-93, A-94, A-95, A-96, A-97, A-63: never reported by the trustee, so not part of the deal as issued
  • A-PO: draft face 20,185,589.00 -> reported 20,185,589.08 (pinned from the remittance Original Balance)
  • B-6: draft face 7,909,686.00 -> reported 7,909,686.76 (pinned from the remittance Original Balance)
  • group 1 has 57 senior classes (A-2, A-3, A-4, A-5, A-6, A-8, A-9, A-10, A-12, A-13, A-14, A-15, A-16, A-18, A-19, A-20, A-21, A-22, A-23, A-24, A-25, A-26, A-27, A-28, A-29, A-30, A-31, A-32, A-33, A-34, A-35, A-36, A-37, A-38, A-40, A-41, A-42, A-43, A-44, A-51, A-52, A-54, A-55, A-56, A-57, A-58, A-59, A-64, A-65, A-66, A-67, A-68, A-69, A-70, A-98, A-PO, A-R); 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): A-1, A-45, A-46, A-47, A-48, A-49, A-60, A-63, A-71, A-72, A-73, A-74, A-75, A-76, A-77, A-78, A-79, A-80, A-81, A-82, A-83, A-84, A-85, A-86, A-87, A-88, A-89, A-90, A-91, A-92, A-93, A-94, A-95, A-96, A-97
  • window starts at deal month 1 (2007-08-27); earlier reports are not in the machine-readable run

Capital structure · original faces

A-2
$100,000,000.00
A-3
$195,570,000.00
A-4
$50,000,000.00
A-5
$50,000,000.00
A-6
$150,000,000.00
A-8
$77,243,000.00
A-9
$19,760,000.00
A-10
$213,119,142.00
A-12
$35,519,858.00
A-13
$500,000.00
A-14
$78,009,000.00
A-15
$71,383,000.00
A-16
$166,179,428.00
A-18
$27,696,572.00
A-19
$238,724,000.00
A-20
$1,000,000.00
A-21
$1,000,000.00
A-22
$1,000,000.00
A-23
$1,000,000.00
A-24
$1,000,000.00
A-25
$1,000,000.00
A-26
$1,000,000.00
A-27
$1,000,000.00
A-28
$1,000,000.00
A-29
$1,000,000.00
A-30
$1,000,000.00
A-31
$1,000,000.00
A-32
$1,000,000.00
A-33
$1,000,000.00
A-34
$1,000,000.00
A-35
$39,276,000.00
A-36
$395,120,000.00
A-37
$281,128,000.00
A-38
$197,154,857.00
A-40
$32,859,143.00
A-41
$35,036,000.00
A-42
$32,060,000.00
A-43
$144,559,000.00
A-44
$236,827,000.00
A-51
$43,559,000.00
A-52
$195,192,000.00
A-54
$32,532,000.00
A-55
$339,000.00
A-56
$60,368,000.00
A-57
$55,241,000.00
A-58
$156,014,000.00
A-59
$154,285,714.00
A-64
$25,714,286.00
A-65
$27,203,000.00
A-66
$29,358,000.00
A-67
$6,775,000.00
A-68
$74,400,000.00
A-69
$1,956,000.00
A-70
$544,000.00
A-98
$50,000,000.00
A-PO
$20,185,589.08
A-R
$100.00
B-1
$79,096,000.00
B-2
$23,729,000.00
B-3
$15,819,000.00
B-4
$7,910,000.00
B-5
$3,955,000.00
B-6
$7,909,686.76

viridian = senior (per-pool) · burgundy = cross-collateralized subordinates · IO classes (A-7, A-11, A-17, A-39, A-50, A-53, A-61, A-62, A-99) accrue on senior notionals

Worst remaining deltas · computed vs reported

interest

2007-08-27A-44-1085457.09
2007-09-25A-44-1082215.01
2007-10-25A-44-1078190.60
2007-11-26A-44-1073384.56
2007-12-26A-44-1067797.93

principal

2007-09-25A-52-0.03
2007-09-25A-10-0.03
2007-09-25A-44+0.02
2007-10-25A-10-0.02
2007-10-25A-44-0.02

ending balance

2007-10-25A-10+0.05
2007-11-26A-10+0.05
2007-09-25B-6-0.05
2007-10-25B-6-0.04
2007-12-26A-10+0.04