Spreadsheet: 214613d1361002199-help-needed-related-to-excel-vba-macros-final
Sheet: TOP 5 DQ

 |  |  |  |  |  |  |  |  | Current Month |  | Prior Month |  | Current Month |  | Prior Month |  | Current Month
Family Name | Loan Structure | Deal Name | Asset Type | CBSA | Current Balance | CUSIP | MARKET VALUE | PORTFLIO NAME | Pay Status | WO Strategy | Pay Status | WO Strategy | SS Transfer Date | Master [NAME] | SS Transfer Date | Master [NAME] | Base Outcome | Base Loss | Base Severity | Base Default Date | Base Resolution Date
[NAME] | FM-A | pcc-2003-1 | CON | la | 670 | 6 | 29 | ran | current | resolved | current | resolved | 3/14/2012 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM-B | pcc-2003-1 | CON | la | 670 | 6 | 29 | ran | current | resolved | current | resolved | 3/14/2013 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM-C | pcc-2003-1 | CON | la | 670 | 6 | 29 | ran | current | resolved | current | resolved | 6/14/2012 | 8/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM-A | pcc-2003-1 | CON | la | 670 | 7 | 30 | ra | current | resolved | current | resolved | 3/14/2015 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM-B | pcc-2003-1 | CON | la | 670 | 7 | 30 | ra | current | resolved | current | resolved | 3/14/2016 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM-C | pcc-2003-1 | CON | la | 670 | 7 | 30 | ra | current | resolved | current | resolved | 6/14/2012 | 8/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM | [NAME] | CON | la | 1270 | 8 | 31 | r | current | resolved | current | resolved | 10/14/2012 | 11/14/2012 | 3/14/2012 | 3/14/2012 | extension | 20 | 30 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM | [NAME] | CON | la | 1270 | 9 | 32 | jatinder | current | resolved | current | resolved | 10/14/2012 | 11/14/2012 | 3/14/2012 | 3/14/2012 | extension | 20 | 30 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
[NAME] | FM | [NAME] | CON | la | 1270 | 10 | 33 | jatin | current | resolved | current | resolved | 10/14/2012 | 11/14/2012 | 3/14/2012 | 3/14/2012 | extension | 20 | 30 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A7A | WB 2007-C33 | CON | new york | 130 | 1 | 24 | vij | current | resolved | current | resolved | 3/14/2021 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A5A | WB 2007-C34 | CON | new york | 130 | 1 | 24 | vij | current | resolved | current | resolved | 3/14/2022 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A5B | WB 2007-C35 | CON | new york | 130 | 1 | 24 | vij | current | resolved | current | resolved | 3/14/2023 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 100 | 300 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A7B | WB 2007-C36 | CON | new york | 130 | 1 | 24 | vij | current | resolved | current | resolved | 3/14/2024 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 200 | 400 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A7A | WB 2007-C37 | CON | new york | 130 | 2 | 25 | viji | current | resolved | current | resolved | 3/14/2025 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A5A | WB 2007-C38 | CON | new york | 130 | 2 | 25 | viji | current | resolved | current | resolved | 3/14/2026 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A5B | WB 2007-C39 | CON | new york | 130 | 2 | 25 | viji | current | resolved | current | resolved | 3/14/2027 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 100 | 300 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A7B | WB 2007-C40 | CON | new york | 130 | 2 | 25 | viji | current | resolved | current | resolved | 3/14/2028 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 200 | 400 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A7A | WB 2007-C41 | CON | new york | 130 | 3 | 26 | vijen | current | resolved | current | resolved | 3/14/2029 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A5A | WB 2007-C42 | CON | new york | 130 | 3 | 26 | vijen | current | resolved | current | resolved | 3/14/2030 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A5B | WB 2007-C43 | CON | new york | 130 | 3 | 26 | vijen | current | resolved | current | resolved | 5/14/2012 | 4/14/2012 | 3/14/2012 | 3/14/2012 | extension | 100 | 300 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A7B | WB 2007-C44 | CON | new york | 130 | 3 | 26 | vijen | current | resolved | current | resolved | 6/14/2012 | 7/14/2012 | 3/14/2012 | 3/14/2012 | extension | 200 | 400 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A1A | GE 2007-C1 | CON | new york | 120 | 4 | 27 | [NAME] | current | resolved | current | resolved | 3/14/2012 | 3/14/2012 | 3/18/2012 | 3/18/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A2A | GE 2007-C1 | CON | new york | 120 | 4 | 27 | [NAME] | current | resolved | current | resolved | 3/14/2012 | 3/14/2012 | 3/19/2012 | 3/23/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A2B | GE 2007-C1 | CON | new york | 120 | 4 | 27 | [NAME] | current | resolved | current | resolved | 3/14/2035 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 500 | 700 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
666 fifth avenue | FM-A1B | GE 2007-C1 | CON | new york | 120 | 4 | 27 | [NAME] | current | resolved | current | resolved | 3/14/2036 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 600 | 800 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
sofitel | FM | che2001 | CON | ch1 | 900 | 12 | 35 | meen | current | resolved | current | resolved | 3/14/2037 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
sofitel | FM | che2001 | CON | ch1 | 900 | 13 | 36 | [NAME] | current | resolved | current | resolved | 3/14/2038 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
sofitel | FM | che2001 | CON | ch1 | 900 | 11 | 34 | meena | current | resolved | current | resolved | 3/14/2039 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
skyhopper | FM-A | che2022 | CON | ch22 | 200 | 38 | 61 | kamal | current | resolved | current | resolved | 3/14/2040 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
skyhopper | FM-B | che2022 | CON | ch22 | 200 | 38 | 61 | kamal | current | resolved | current | resolved | 3/14/2041 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
skyhopper | FM | che2025 | CON | ch22 | 400 | 41 | 64 | purshottam | current | resolved | current | resolved | 3/14/2042 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
skyhopper | FM | che2025 | CON | ch22 | 400 | 42 | 65 | pursh | current | resolved | current | resolved | 3/14/2043 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
skyhopper | FM | che2025 | CON | ch22 | 400 | 43 | 66 | pur | current | resolved | current | resolved | 3/14/2044 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00
airindia | FM | che2019 | CON | ch19 | 720 | 35 | 58 | shefali | current | resolved | current | resolved | 3/14/2012 | 3/14/2012 | 3/14/2012 | 3/14/2012 | extension | 0 | 0 | 2012-01-02 00:00:00 | 2012-03-02 00:00:00