Trial Balance

Reviews
Shared by: vivi07
Categories
Tags
Stats
views:
17
rating:
not rated
reviews:
0
posted:
11/6/2009
language:
English
pages:
0
Schedule 1 - Portfolio Reconciliation Explanation of Differences Shortage/ Surplus Fannie Mae Loan # Per Lender's Records F/S Fixed Installment 13,234.68 Loan Count 22 Unpaid Principal 1,365,224.24 4000291001 4000307010 134143752 1370790133 00044406575 1044257689 1028153019 F/S S S S S F S N/A N/A 39.22 39.72 (1,000.00) 135.28 49.20 N/A N/A N/A N/A -1 N/A 1 47.91 N/A 432.49 N/A 342.29 2,590.53 80.30 (111,632.97) 122.55 346.33 688.33 941.19 468.96 N/A Per Fannie Mae 12,498.10 22 1,254,530.65 5,121.50 Shortage/Surplus Balance to be carried forward to Line 1, Schedule 3 RUN DATE: 07/20/99 RUN TIME: 13:59:09 REPORT: LRR01201 FANNIE MAE LENDER REPORTING SYSTEM LENDER RECAP REPORT SECTION I: PORTFOLIO SUMMARY LOAN COUNT ACTUAL/ACTUAL BEGINNING BALANCES ENDING BALANCES TRANSFERS IN TRANSFERS OUT SCHEDULED/ACTUAL BEGINNING BALANCES ENDING BALANCES TRANSFERS IN TRANSFERS OUT SCHEDULED/SCHEDULED (MRS) BEGINNING BALANCES ENDING BALANCES TRANSFERS IN TRANSFERS OUT SCHEDULED/SCHEDULED (MBS) BEGINNING BALANCES ENDING BALANCES TRANSFERS IN TRANSFERS OUT TOTAL PORTFOLIO PROCDESSES BEGINNING BALANCES ENDING BALANCES TRANSFERS IN TRANSFERS OUT 22 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 22 0 0 MORTGAGE PAYMENT 13,165.84 12,498.10 0.00 0.00 ACTUAL UPB 1,244,618.94 1,254,530.65 0.00 0.00 SCHEDULED UPB N/A N/A N/A N/A UPB ACQUIRED 1,244,618.94 1,254,530.65 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 N/A N/A N/A N/A 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 13,165.84 12,498.10 0.00 0.00 1,244,618.94 1,254,530.65 0.00 0.00 0.00 0.00 0.00 0.00 1,244,618.97 1,254,530.65 0.00 0.00 RUN DATE: 07/20/99 RUN TIME: 13:59:09 FANNIE MAE LENDER REPORTING SYSTEM TRIAL BALANCE REPORT PART A. LOAN ACCOUNTING DATA REMITTANCE TYPE:ACTUAL INTEREST/ACTUAL PRINCIPAL PASS MORTGAGE LOAN NUMBER/ID 4000325378 72414 4000291001 227942 4000307010 402425094 1341431752 213131113 1370790133 3461860 1044257689 30288 1028153019 2303022 1020310946 50153239 1043811426 7107378 1450267898 3369329 1070053160 076284-9 1070053201 076334-2 1070053249 076361-5 1070053287 076384-7 1070053342 076417-5 1070053940 076503-2 1070053976 076535-4 1070054009 076553-7 1070054023 607.85 631.07 429.85 388.13 834.23 545.91 439.07 588.58 392.39 493.25 609.18 225.74 49.20 552.05 758.30 721.50 767.23 445.75 PAYMENT 445.96 LPI DATE 07/01/99 05/01/99 05/01/99 02/01/99 06/01/99 05/01/99 05/01/99 07/01/99 06/01/99 06/01/99 06/01/99 06/01/99 06/01/99 06/01/99 06/01/99 06/01/99 06/01/99 06/01/99 07/01/99 NOTE RATE 8.8750 7.5000 8.0000 8.3750 9.0000 9.1000 6.0000 8.7500 8.0000 7.5000 10.2500 10.2500 10.3750 10.7500 10.3750 10.6250 10.0000 9.6250 9.8750 ACTUAL UNPAID PRINC BALANCE 56,050.00 63,655.08 104,559.50 92,521.20 91,203.96 51,162.91 346.33 23,428.93 77,804.50 63,493.71 24,068.10 38,190.91 27,978.11 34,585.40 51,811.62 40,053.45 23,401.06 42,413.24 66,233.94 UNPAID PRINC BAL ACQUIRED 56,050.00 63,655.08 104,559.50 92,521.20 91,203.96 51,162.91 346.33 23,428.93 77,804.50 63,493.71 24,068.10 39,190.91 37,978.11 34,585.40 51,811.62 40,053.45 23,401.06 42,413.24 66,233.94 ACTION CODE ACTION DATE THRU RATE 8.5000 7.2500 7.7500 8.0000 8.5000 8.8500 5.5000 8.2500 7.6250 7.0000 9.8200 9.8200 9.8200 9.8200 9.8200 10.1250 9.6250 9.2500 9.5000 RUN DATE: 07/20/99 RUN TIME: 13:59:09 FANNIE MAE LENDER REPORTING SYSTEM TRIAL BALANCE REPORT 076519-8 1070054267 076552-9 1070054413 076450-6 1070054736 076385-4 TOTALS FOR REMITTANCE TYPE: ACTUAL INTEREST/ACTUAL PRINCIPAL MORTGAGE LOAN COUNT 22 PAYMENT 12,498.10 ACTUAL UNPAID PRINC BALANCE 1,254,530.65 UNPAID PRINC BALANCE ACQUIRED 1,265,530.65 1,639.40 06/01/99 0.0947 178,131.52 178,131.52 9.7000 429.84 06/01/99 0.0103 46,452.95 46,452.95 9.6250 503.62 10/01/97 9.6250 56,984.23 56,984.23 9.3750 XXX MORTGAGE COMPANY TRIAL BALANCE REPORT Loan Number 74214 227942 402425094 000213131113 3461860 0004406575 00000030288 0153239 000007107378 3369329 076284-9 076334-2 176361-5 076384-7 076417-5 076503-2 076535-4 076553-7 076519-8 076552-9 076450-6 076385-4 Total Count 22 Fannie Mae Number 40000325378 4000291001 4000307010 1341431752 1370790133 1111234567 1044257689 1020310946 1043811426 1450267898 1070053160 1070053201 1070053249 1070053287 1070053342 1070053940 1070053976 1070054009 1070054023 1070054267 1070054413 1070054736 Mortgage Payment LPI Actual Principal Balance 56,050.00 63,607.17 104,559.50 92,178.91 91,123.66 111,632.97 51,040.36 23,428.93 77,804.50 63,493.71 24,068.10 38,190.91 27,978.11 34,585.40 51,811.62 40,053.45 23,401.06 42,413.24 66,233.94 56,984.23 46,452.95 178,131.52 1,365,224.24 Note Rate 8.875 7.500 8.000 7.750 8.375 8.750 8.625 8.375 8.000 7.500 10.250 10.250 10.375 10.750 10.375 10.625 10.000 9.625 9.875 9.625 9.875 9.950 Servicing Delinquent dditional Prepaid A Fee Interest Principal Interest 0.375 0.250 0.250 0.450 0.500 0.375 0.500 0.500 0.375 0.500 0.430 0.430 0.555 0.930 0.555 0.500 0.375 0.325 0.375 0.250 0.250 0.250 Prepaid Principal 445.96 7/1/1999 445.75 7/1/1999 767.23 6/1/1999 682.28 6/1/1999 718.58 7/1/1999 1,000.00 7/1/1999 416.77 6/1/1999 225.74 7/1/1999 609.18 6/1/1999 493.25 6/1/1999 392.39 6/1/1999 588.58 6/1/1999 439.07 6/1/1999 545.91 6/1/1999 834.23 6/1/1999 388.13 6/1/1999 429.85 6/1/1999 631.07 6/1/1999 607.85 7/1/1999 503.62 10/1/1997 429.84 6/1/1999 1,639.40 6/1/1999 ####### 384.58 47.91 608.03 745.52 161.45 80.30 195.67 54.51 50.00 524.84 62.29 50.00 2,424.42 440.68 RUN DATE: 07/20/99 RUN TIME: 13:59:09 REPORT: LRR01401 FANNIE MAE LENDER REPORTING SYSTEM REMITTANCE UPDATE REPORT PART I SECTION B BEG/END BEG/END LOAN NUMBER POOL NUMBER INT RATE PASS THRU RATE BEG/END MORTGAGE PAYMENT BEG/END LPI DATE BEG/END ACTUAL UNPAID PRINCIPAL BAL BEG/END SCHED UNPAID PRINCIPAL BAL INTEREST PRINCIPAL 4000325378 74214 LAR REPORTED APPLIED DIFFERENCE PRIMARY MESSAGE: SECONDARY MESSAGE: LOAN FACTS 8.8750 8.5000 445.96 07/01/99 56,050.00 224.97 0.00 0.00 0.00 0.00 0.00 0.00 07/01/99 8.8750 8.5000 445.96 07/01/99 56,050.00 56,050.00 244.97 0.00 224.97 343 REJ NO PRINCIPAL REMITTED/NO LPI CHANGE;NO INTEREST DUE This is a loan-added purchase. The lender reported and remitted the interest collected from the borrower at settlement, causing an interest surplus. 4000291001 227942 LAR REPORTED APPLIED DIFFERENCE PRIMARY MESSAGE: SECONDARY MESSAGE: LOAN FACTS 7.5000 7.2500 445.78 05/01/99 63,655.08 07/01/99 7.5000 7.2500 445.75 05/01/99 63,607.17 63,655.08 384.00 0.00 384.58 47.91 0.00 47.91 334 - REJ - UPB MOVEMENT/POSSIBLE AMORT.ERROR The lender sold the loan to Fannie Mae with an LPI date of 5/99. The correct LPI date sold shoulod have been 6/99. There is no previous shortage/surplus on this loan. 4000307010 227942 LAR REPORTED APPLIED DIFFERENCE PRIMARY MESSAGE: SECONDARY MESSAGE: LOAN FACTS 8.0000 7.7500 767.23 05/01/99 104,559.50 06/01/99 8.0000 7.7500 767.23 05/01/99 104,559.50 104,559.50 0.00 0.00 0.00 0.00 0.00 0.00 342 REJ INVALID LPI DATE MOVEMENT The loan was sold to Fannie Mae with an LPI of 5/99. The lender currently reported an LPI date of 9/99. There is no previous shortage/surplus on this loan. 1341431752 213131113 8.3750 8.0000 721.50 02/01/99 92,521.20 RUN DATE: 07/20/99 RUN TIME: 13:59:09 REPORT: LRR01401 FANNIE MAE LENDER REPORTING SYSTEM REMITTANCE UPDATE REPORT REPORTED PAYMENT/RATE CHANGE PRIMARY MESSAGE: 321 REJ - INDEX VALUE NOT A PUBLISHED INDEX SECONDARY MESSAGE: EFFECTIVE DATE INDEX VALUE NEW INTEREST RATE PASS-THRU RATE NEW PAYMENT 3/1/1999 7.1000 7.7500 7.3000 682.28 APPLIED/PROJ* 3/1/1999 5.3500 * 8.1250 * 7.3000 * 705.72 * LAR REPORTED APPLIED DIFFERENCE 8.3750 8.0000 721.50 06/01/99 02/01/99 92,178.91 92,521.20 561.28 0.00 561.28 86.4 0.00 86.40 LOAN FACTS This lender is using the incorrect index to calculate the ARM change informaiton. The carry forward surplus is $1,942.85 1370790133 3461860 9.0000 8.5000 758.30 06/01/99 91,203.96 REPORTED APPLIED/PROJ* 7/1/1999 5.6200 * 8.3750 * 7.8750 * 718.58 * PAYMENT/RATE CHANGE PRIMARY MESSAGE: 351 REJ - NOTE RATE CHANGE PAST DUE SECONDARY MESSAGE: EFFECTIVE DATE INDEX VALUE NEW INTEREST RATE PASS-THRU RATE NEW PAYMENT LAR REPORTED APPLIED DIFFERENCE 9.0000 8.5000 758.30 07/01/99 06/01/99 91,123.66 91,203.96 608.03 0.00 608.03 80.30 0.00 80.30 LOAN FACTS The lender did not report the July ARM cahnge information. Lender records agree with Fannie Mae projections. 4406575 LAR REPORTED APPLIED DIFFERENCE PRIMARY MESSAGE: SECONDARY MESSAGE: LOAN FACTS 0.0000 0.0000 0.00 00/00 07/01/99 0.00 111,632.97 0.00 745.52 0.00 745.52 195.67 0.00 195.67 0.0000 0.0000 0.00 00/00 314 - REJ TRANSACTION FOR LAON NOT IN CURRENT PORTFOLIO This loan was erroneously removed in the previous cyc,e with an action code 71. There is no prior shortage/surplus on this loan. 1044257689 30288 9.1000 8.8500 552.05 05/01/99 51,162.91 REPORTED APPLIED/PROJ* RUN DATE: 07/20/99 RUN TIME: 13:59:09 REPORT: LRR01401 FANNIE MAE LENDER REPORTING SYSTEM REMITTANCE UPDATE REPORT PAYMENT/RATE CHANGE PRIMARY MESSAGE: 351 REJ - NOTE RATE CHANGE PAST DUE SECONDARY MESSAGE: EFFECTIVE DATE INDEX VALUE NEW INTEREST RATE PASS-THRU RATE NEW PAYMENT 6/1/1999 6.0800 8.6250 8.1250 416.77 6/1/1999 6.0800 * 8.5800 * 8.0800 * 414.74 * LAR REPORTED APPLIED DIFFERENCE 9.1000 8.8500 552.05 06/01/99 05/01/99 51,040.36 51,162.91 346.41 0.00 346.41 122.55 0.00 122.55 LOAN FACTS The note for this loan states the interst rate will be rounded to the nearest 1/8%. LASER's database has no rounding. 1028153019 2303022 LAR REPORTED APPLIED DIFFERENCE PRIMARY MESSAGE: SECONDARY MESSAGE: LOAN FACTS 6.0000 5.5000 49.20 05/01/99 346.33 00/00 6.0000 5.5000 49.20 05/01/99 0.00 346.33 0.00 0.00 0.00 0.00 0.00 0.00 313 REJ - LOAN NOT REPORTED This loan paid off and removed from the lender's records in the prior reporting period. However, the lender did not report the payoff on LASER RUN DATE: 07/20/99 RUN TIME: 13:59:09 REPORT LRR01401 FANNIE MAE LENDER REPORTING SYSTEM REMITTANCE UPDATE REPORT PART I. REMITTANCE TYPE: ACTUAL INTEREST/ACTUAL PRINCIPAL (WHOLE LOANS) SECTION A: PORTFOLIO SUMMARY LOAN COUNT MORTGAGE PAYMENT ACTUAL UNPAID PRINCIPAL BALANCE UNPAID PRINCIPAL BALANCE ACQUIRED 1. BEGINNING BALANCES 2. LOANS ADDED A. PURCHASES B. READDS C. SERVICING TRANSFERS D. SUBSTITUTIONS E. OTHER 3. LOANS REMOVED A. PAYOFFS B.FORECLOSURES C.REPURCHASES D. SERVICING TRANSFERS E. SUBSTITUTIONS F. SALES G. OTHER 4. FANNIE MAE ADJUSTMENTS 5. PAYMENT/RATE CHANGES 6. PRINCIPAL AMORTIZATION 7. ENDING BALANCES 8. INTEREST APPLIED 9. PRINCIPAL APPLIED 10. BUYDOWN FUNDS APPLIED 22 13,165.84 1,244,673.52 1,244,673.52 1 0 0 0 0 445.96 0.00 0.00 0.00 0.00 56,050.00 0.00 0.00 0.00 0.00 56,050.00 0.00 0.00 0.00 0.00 1 0 0 0 0 0 0 0 0 0 22 1,113.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 12,498.10 6,283.15 46,192.87 0.00 43,957.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,235.12 1,254,530.65 43,957.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,235.12 1,254,530.65

Related docs
trial balance definition
Views: 311  |  Downloads: 7
TRIAL BALANCE SHEETS FOR
Views: 80  |  Downloads: 1
Trial Balance
Views: 64  |  Downloads: 1
Trial balance spreadsheet
Views: 1675  |  Downloads: 98
ERRORS NOT AFFECTING THE TRIAL BALANCE
Views: 41  |  Downloads: 0
Trial balance prepared
Views: 347  |  Downloads: 19
IC Trial Balance Reconciliation Certification
Views: 0  |  Downloads: 0
Trial Calendars
Views: 2  |  Downloads: 0
premium docs
Other docs by vivi07
 Students´ corner
Views: 222  |  Downloads: 0
시트1
Views: 165  |  Downloads: 0
高考资源网
Views: 70  |  Downloads: 0
高中單字
Views: 185  |  Downloads: 0
高一下第一次周练英语试卷
Views: 46  |  Downloads: 0
附件3:
Views: 125  |  Downloads: 0
開啟下載題目_答案 - 湯尼英日語
Views: 124  |  Downloads: 0
资料
Views: 148  |  Downloads: 0
英语阅读理解(五年)
Views: 52  |  Downloads: 0
英语赠言大全
Views: 144  |  Downloads: 0
英语试题集锦
Views: 83  |  Downloads: 0
英語 - 蘆洲心蘆中情
Views: 80  |  Downloads: 0