PLEASE SHOW EXCEL FORMULA USED! THANK YOU!
5. Append Foreclosure Step (extract from the foreclosure comment). The field should be blank or "n/a" for loans not in foreclosure i.e.: "This Loan is in Step: Service" --> Service Foreclosure Foreclos ure Comment Seller Name Loan Amount Annual Rate Term (Years) Payment Payments Made Current Balance Loan Type Agency Delinquency (Months) Status Loan Loan Number Foreclosure Step This Loan is in Step: Judgment This Loan is in Step: n/a 83449837 Shanna's Loan Headquarters 30 $1,740.84 $209,030.94 VA GNMA 1 280,000 6.34% 191 6 90+ Y 41209504 Shanna's Loan Headquarters 5 90+ 30 $1,939.55 $351,086.24 UCONV 2 370,000 4.79% 322 FNMA N $44,813.44 USDA $17,124.13 VA 25055860 Shanna's Loan Headquarters This Loan is in Step: n/a This Loan is in Step: n/a 6.14 % 20 $1,521.82 210,000 32 GNMA 0 Current N 61173887 Shanna's Loan Headquarters 120,000 $797.69 4 6.99% 30 23 GNMA 0 Current N 51398733 Shanna's Loan Headquarters 350,000 20 $2,312.44 $262,240.88 UCONV This Loan is in Step: n/a 5 5.01% 154 FNMA 0 Current This Loan is in Step: n/a 76906141 Shanna's Loan Headquarters 10 $2,256.64 $97,491.96 ICONV 5 90+ 6 220,000 4.28% 47 FHLMC N 10 $4,001.77 This Loan is in Step: n/a 49304139 Shanna's Loan Headquarters $249,924.91 USDA 5 90+ 7 330,000 7.99% 81 GNMA N 3.78 % 23473039 Shanna's Loan Headquarters $744.03 $148,986.33 USDA 3 90+ This Loan is in Step: n/a 8 160,000 30 317 GNMA N 53651842 Shanna's Loan Headquarters 370,000 30 $2,135.07 $131,649.11 ICONV FHLMC This Loan is in Step: n/a This Loan is in Step: Referral This Loan is in Step: n/a 9 5.65% 73 4 90+ N 30 $1,388.64 $164,464.10 VA 10 77159777 Shanna's Loan Headquarters 240,000 5.67% 174 GNMA 9 90+ Y 66573753 Shanna's Loan Headquarters 4.02% 30 $1,148.78 $80,496.12 UCONV 11 240,000 80 FNMA 2 30-60 10 $1,480.52 $873.98 $108,455.42 FHA 4 90+ 12. 35312476 Shanna's Loan Headquarters 120,000 8.39% 103 GNMA N This Loan is in Step: n/a This Loan is in Step: Judgment $30,586.38 FHA. 9 90+ 13 95991315 Shanna's Loan Headquarters 150,000 3.55% 20 37 GNMA Y $99,429.35 FHA 30278425 Shanna's Loan Headquarters 100,000 $585.46 This Loan is in Step: Sale 14 3.61 % 20 238 GNMA 8 90+ Y 89078715 Shanna's Loan Headquarters 210,000 10 $1,941.48 $54,852.86 FHA This Loan is in Step: n/a This Loan is in Step: n/a 15 2.10% 29 GNMA 0 Current N 66655583 Shanna's Loan Headquarters 10 $4,590.00 $98,233.27 UCONV 1 30-60 16 390,000 7.31% 23 FNMA N 23457613 Shanna's Loan Headquarters 240,000 20 $1,296.44 $230,832.92 UCONV 4 90+ This Loan is in Step: n/a This Loan is in Step: n/a 17 2.71% 228 FNMA 68418670 Shanna's Loan Headquarters 20 $1,495.25 $95,777.09 USDA 18 280,000 2.58% 69 GNMA 0 Current N This Loan is in Step: Referral 310,000 20 $1,683.10 $171,148.14 VA 19 77337678 Shanna's Loan Headquarters 2.77% 116 GNMA 10 90+ 8.04 % 3.88% 20 $2,517.14 $130,651.59 USDA GNMA This Loan is in Step: n/a 20 66901329 Shanna's Loan Headquarters 300,000 64 1 30-60 N This Loan is in Step: n/a GNMA 10 $2,013.78 $82,463.81 FHA 21 14201616 Shanna's Loan Headquarters 200,000 44 5 90+ N 33480177 Shanna's Loan Headquarters 340,000 20 $2,070.33 $295,308.48 VA This Loan is in Step: Referral 22 4.06% 195 GNMA 9 90+ 216.437 25 ICON 20201502 channa'e Loan Hasdauartare. 10 CA 20A AO Thie Loan ie in Sten: na 23. 260.000 7 56% 61 CHIMC 2 ana N
