Loading...
HomeMy WebLinkAboutProposed Final Amortization Schedule from DEQ after 2 million down paymentDATE O3_01_22 DEPT OF ENVIRONMENTAL QUAL]TY AMORTIZATION SCHEDULE LOAN NUMBER: REXBURG NAME: PMT FREQ: 2 YEAR: Y ORIG-LOAN-DATE : 03-IB-22 NEXT-PMT-DATE: 09-I8-22 PMT-TYPE: B CUR-BALANCE: 7 ,425,549 .2I INTR RATE: 1.7500 NO OF PMTS: 60 PMT AMOUNT: I59,636.59 CITY OF REXBURG #DW1s02 NO. PMT-DATE DAYS AMOUNT INTEREST RUN 3-0'7-22 AT 13227 PAGE 1 PRINCI PAL BAIANCE 001 09-78-22 r59 , 636 .59 159,636.59 r59,636.59 159, 636.59 3r9,273.78 759 , 636 .59 159, 636.59 379,213.I8 759 , 636 .59 r59 , 636 .59 379,273.18 759 , 636 .59 I59 , 636 .59 3r9,273.18 I59 , 636 .59 759,636.59 3r9 ,213 .r8 159 , 636 .59 I59 , 636 .59 3r9,273. 1B I59 , 636 .59 759 , 636 .59 3r9,273.18 r59 , 636 .59 1,59 , 636 .59 3r9,273.18 65,507.58 65, 507 . 58 63,622.61 63,830.16 721 ,452. B3 62,300 .34 62 , 126 .21 124, 426.67 60 ,261 .74 60,389.41 120 , 656 .55 5B, 543.53 58 , 622 .03 II7 ,765.55 56,189.62 56 ,823 .58 rr3,673.20 55,308.78 54,996.20 110,304.98 53,r97.44 53 ,734 .02 106,325 .46 5r,343 .41 5r,239 .rr r02, 582 .58 94,729.0r 94 , r29 .0I 96 ,0r3 .92 95,806.43 I9I ,820 .35 91 ,335 .25 91 ,5]-0 .32 L94,846.51 99 ,369 . 45 99 ,241 .18 r98,616.63 101,093.06 101,014.56 202,I01.62 r02 ,8 46 .91 I02,8 13.01 205 , 659 .98 704,321.8r r04,640.39 208,968 .20 r06,445. 15 106,502 .51 2r2 , 941 .12 1_08 ,293 .12 108, 397 . 4B 276,690 .60 1 ,33r, 420 .20 'l ,235 , 406 .28'7,I39,599.85 'l ,042,263 .60 6,944,153.28 6t845,383.83 6,146,136.65 6 | 645 ,043 .59 6 , 544 ,029 .03 6, 44\ | IB2 .06 6, 338, 369. 05 6,234 ,04r .24 6,I29,400. B5 6,022, 955.70 5,976, 453. 13 5,808,160.01 5 , 699 ,7 62 .53 184 IB4 002 003 181 184 03-18-23 09-78-23 004 005 IB2 184 Q3-78-24 09-78-24 03-18-25 09-18-25 03-r8-26 09-rB-26 36s 366 365 35s 365 782 184 366 365 006 007 181 184 008 009 181 184 010 011 181 784 03-18-27 09-78-27 03-18-28 09-1,8-28 012 013 014 015 181 184 03-r8-29 09-rB-29 181 184 03-18-30 09-18-30 016 017 365 NO. PMT-DATE DAYS AMOUNT INTEREST PRINCI PAL BAIANCE 018 019 181 784 03-18-31 09-18-31 03-18-32 09-rB-32 r59 , 636 .59 159, 636.59 3r9 ,213 .rB r59 , 636 .59 159, 636.59 319,213.18 r59 , 636 .59 r59 , 636 .59 3r9,213.1,8 t En a-a trnl-Jv, oJo. Jv 159, 636.59 379,273. 18 159,636.59 159,636.59 3r9,2't3.rB 159, 636 . 59 ]-59 , 636 .59 379 ,213 .tB 759 , 636 .59 159, 636.59 3r9,273. 1B r59 , 636 .59 r59 , 636 .59 3r9 ,213 .18 159, 636.59 r59 , 636 .59 3r9,273. 1B r59,636.59 759 , 636 .59 3r9,273.18 159,636.59 159 , 636 .59 31"9,213.rB 49 , 463 .0r 49,310.89 98,113.90 41 ,872 .20 47, 351 . 10 95, 163.30 45,604.65 45,354.55 90 , 959 .20 A- a^a aa1tJrozJ.JJ 43 ,322 .90 86,946 .23 4r,601 .r'7 4r ,255 .55 82 ,862 .12 39 ,'11 4 .72 39,153.78 18,921 .90 3't ,469.85 37, 013. 15 14,483.00 35,345.54 34,834.89 70,180.43 33,183.89 32,618 .34 65 , 802 .23 31, 155. 43 30, 364 . 35 67 , 519 .18 28 ,'l 41 . 44 28 ,069 .23 56, 816 .61 110,173.58 110,325.70 220,499.28 rr]-,824 .39 7r2,285.49 224,1,09.88 tt4 , 037 .9 4 rr4 , 282 .0 4 228 ,31,3 .98 a 1a n 1a ^aJ-J-OTULJ.Z\) ]-16 ,3r3 .69 232 ,326 .95 rr? ,029 .42 118, 381.04 236,410.46 rr9 ,862 . 41 r20 , 482 .8I 240 ,345.28 722,166.14 122,623 .44 244,"t 90.18 124,291.05 124,801.70 249 ,092 .'7 5 726,452.10 r2-1 ,078 .25 253,470.95 1_28,481.16 r29,212.24 25't ,1 53 . 40 130,889.15 131,567.36 262,456.51 5,589,588.95 5,419,263.25 5,361, 438. B6 5 ,255 ,753 .31 5tI47,721.43 5,026,839.39 A 61 d Oaa 1a.)rJrvtozQ.rJ 4,194,5r2.44 4,616,483.02 4, 558, 101 . 98 4, 438 ,239 .5r 4,3r1 ,156.10 4,795,589.96 4,0'12,966 .52 3,948,6'75.4'7 3,823,813.77 3,691,42r.01 3,570 ,402.82 3, 44r,92r .66 3 ,3r2 , 649 . 42 3,181,160.21 3,050 ,792.9r 36s 020 02r r82 184 181 IB4 161t_ol- 184 181 184 366 022 023 03-18-33 09-18-33 365 vz+ 025 na I d a AuJ-r-o-J+ 09-18-34 365 026 027 03-18-3s 09-18-35 365 028 029 L6Z 184 03-18-36 09-18-36 366 030 031 181 184 03-18-37 09-18-37 365 032 033 181 184 782 184 03-18-38 09-18-38 034 035 181 184 03-18-39 09-18-39 03-18-40 09-18-40 365 365 036 037 181 184 03-18-41 09-18-41 366 038 039 365 NO. PMT-DATE DAYS AMOUNT INTEREST PRINCIPAL BALANCE 040 04r 181 184 03-18-42 09-rB-42 03-18-43 09-18-43 759,636.59 1.59 , 636 .59 3r9,213.I8 159, 636.59 759,636.59 3r9,213 .rB I59 , 636 .59 159,636.59 3I9,213.78 r59 , 636 .59 159, 636.59 3I9,273.18 759 , 635 .59 r59 , 636 .59 379 | 213 .I8 159 , 636 .59 I59,636.59 3r9,213.18 r59 , 636 .59 759 , 636 .59 379,273. 1B I59 , 636 .59 I59 , 636 .59 3r9,213 .rB 759 , 636 .59 759 , 636 .59 3r9,273.18 159,636.59 r59 , 636 .59 3r9,2.'13 .18 r59 , 635 .96 159, 635.96 26,469 .82 25 ,'7 33 .1 6 52 ,203 .58 24t752.I1 23,351.25 41 ,509 .42 27,9r4.19 20 , 940 .03 42,854 .22 19,395.00 18,479.26 31 ,87 4 .26 16,953.00 1,5,97 5.24 32,928.24 74 , 468 .01 13,421 .2I 27 ,895 .28 12 ,005 .43 r0 , 834 .91 22,840.40 9,361 .00 8,196.59 11,563.59 6,148.74 5,511. B3 72 ,260..51 4,084.46 2,179.89 6,864.35 r ,380 .94 1,380.94 133,166.71 133,902. B3 261 ,069 .60 135,484.42 736,219.34 2'tr,'t63.16 r31,122.40 r3B , 696 .56 2'76,478.96 r40 ,241 .59 141, 157 .33 2BI ,398 .92 742 , 683 .59 143,661.35 286 ,344 .94 r45 , 168 .52 I46,209. 3B 297t311 .90 r41 ,63I.1_6 148, B 07.62 296,432.18 I50 ,269 .59 151,440.00 30I,1 09.59 I52,8 B7 . B5 r54 , r24 .16 307,0I2.6r l_55, 552 . 13 155,856.70 3I2, 408 . B3 1,58 ,255 .02 I5B , 255 .02 2,9r'7 ,026.r4 2 ,1 83 , I23 .3I 2,641, 638 .89 2 t 5rr, 359.55 2,313,631.15 2,234,940.59 2 , 094 , 699 .00 1, 953 , 541 .61 1,810,858.08 I,661 ,196.13 7,522 | 028 .27 r,315,818.83 r ,228 , r]l .61 r,019,386.05 929 , 116 .46 111 t676.46 624t188.6I 410,663.85 315,1II.'72 758 ,255 .02 042 043 181 184 36s 365 366 365 36s 365 044 045 IB2 184 03-18-44 09-r8-44 03-18-45 09-18-45 046 047 181 184 048 049 181 184 03-18-4 6 09-18-46 03-18-47 09-rB-41 03-18-48 09-18-48 050 051 181 784 052 053 782 184 366 054 055 181 184 181 IB4 03-18-49 09-18-49 36s 056 057 03-18-50 09-18-50 058 059 181 184 36s 03-18-51 09-18-51 365 060 03-18-52 IB2 782 958 9,518,794.71 2,I52,645.56 '7,425,549.2I 3 As oF DArE: l6s h6 lroz lowrsoz MMDD yyyy LoanNo: Loan No lowtsoz Loan Class IDL * Loan Type IDTSB Total PrincipalDue Total lnterest Due Total Fees Due Total Payment Due ICITY OF RExBURG Date Payment Due $535,946.86 lurn LOAN PAY.OFF AMOUNTS $306,255.35 lnterest Per Day $426.17295$9,424,696.86 $0.00 $229,691.51 $8,888,750.00 / $535,946.86 $0.00 Current Balance Accrued lnt + Fees Unapplied Funds Net Payoff Balance Close a tt 4 2 DE Q Lo a n Le d g e r DW 1 5 O 2 70 2 2 CI T Y OF RE X B U R G Lo a n # Cu s t # Cu s t o m e r Na m e TC As O f Da e De s o i p t i o n D 08 / 1 6 1 2 0 1 6 ff i 1 n 0 7 1 2 3 / M 08 1 1 6 1 2 0 1 6 MA R K - D O W N TR A N S A C T I O N D 10 t 2 4 t 2 0 1 6 #2 1 2 8 1 5 4 4 0 1 M 1U 2 4 N O 1 6 MA R K - D O W N TR A N S A C T I O N D O2 t 1 5 t 2 0 ' t 7 #3 1 2 8 2 9 3 0 9 5 M O2 N 5 N O 1 7 MA R K . D O W N TR A N S A C T I O N D O6 n 8 n O 1 7 *4 12 8 6 0 2 0 0 4 M O6 N 8 N O 1 7 MA R K . D O W N TR A N S A C T I O N D Og 1 2 n O 1 7 #5 12 8 6 9 2 6 1 2 M 09 1 1 2 1 2 0 1 7 MA R K . D O W N TR A N S A C T I O N D 02 t 1 3 t 2 0 1 8 12 8 8 7 1 9 6 4 M O\ I 1 A 2 O 1 7 MA R K . D O W N TR A N S A C T I O N D 10 t 1 1 t 2 0 1 8 #7 A 1 2 9 2 7 8 E 7 8 D 10 t 1 1 t 2 0 1 8 #7 8 1 2 9 2 7 8 8 7 8 M 1U 1 1 n U 8 MA R K O O W N TM N S A C T I O N 78 D O7 t 2 3 t 2 0 1 9 12 9 7 3 2 7 3 6 f f i M O7 N 3 I 2 O 1 9 MA R K - D O W N TM N S A C T I O N #8 D 12 t 0 / . n 0 1 9 ' 1 2 9 8 8 4 5 8 5 # 9 M 1A O 4 I 2 O 1 } MA R K . D O W N TR A N S A C T I O N #9 D 05 t 2 8 t 2 0 2 0 02 1 6 6 4 6 0 4 # 1 0 A M OS a A 2 O a O IV | A R K - D O W N TR A N S #1 0 A D As t 2 8 1 2 0 2 0 02 1 6 6 4 6 0 4 # 1 0 8 D 03 ] / o 2 t 2 0 2 2 02 3 1 2 7 A 6 4 # 1 1 Or i g i n a l Lo a n Am o u n t 95 6 , 4 4 6 _ 0 0 -1 9 0 , 5 3 5 . 0 0 1, 1 8 / . , 2 i l . O O -2 3 s , 9 1 8 . 0 0 87 4 , 4 9 5 . 0 0 -1 7 4 , 4 O . A O 89 5 , 3 1 7 - 0 0 -1 7 8 , 3 5 8 . 0 0 45 8 , 7 7 1 . 0 0 -9 1 , 3 9 3 . 0 0 94 , 2 2 5 . 0 0 72 5 , 5 2 7 . O O -1 6 3 , 3 0 4 . 0 0 1, 8 0 4 , 8 1 2 . 0 0 -3 5 9 , 5 4 0 . 0 0 57 5 , 2 3 7 . O O -1 1 4 , 5 9 4 . 0 0 1, 3 3 9 , 9 2 9 . 0 0 4M , 1 0 5 . 0 0 68 8 , 5 8 7 . 0 0 70 6 , 6 8 1 . 0 0 In t Pa i d To Da l e Cu r r e n t Ba l a n c e Fr o m 07 / 0 1 / 2 0 0 5 to 03/03/2022 fn t Ma t u r i i g Lo a n Ra t e Da t e Of f i e e r g1ss5 Tvne IO2 DL DISB Tr a n s # 00 0 0 7 2 1 ' 1 00 0 0 7 2 1 6 00 0 0 7 3 2 4 00 0 0 7 3 2 8 00 0 0 7 5 8 2 00 0 0 7 5 8 7 00 0 0 7 7 9 1 00 0 0 7 7 9 6 00 0 0 7 9 1 6 oo o a 7 9 2 2 00 0 0 8 1 95 00 0 0 8 1 99 00 0 0 8 7 3 8 00 0 0 8 7 3 9 00 0 0 8 7 4 0 00 0 0 9 2 s 4 00 0 0 9 4 6 5 00 0 0 9 4 8 3 00 0 0 9 4 8 4 00 0 0 9 7 9 0 00 0 0 9 7 9 1 00 0 0 9 7 9 2 00 0 1 12 3 5 En t r e d 08 / 1 6/ 2 0 1 6 08 t 1 6 t 2 0 1 6 10 n 4 t 2 0 1 6 10 t 2 4 t 2 0 1 6 o2 t 1 5 t 2 0 1 7 02 t 1 5 t 2 0 1 7 46 t 2 8 t 2 0 1 7 o6 t 2 8 n o 1 7 09 h i l 2 0 1 7 og t 1 2 1 2 0 1 7 02 t 1 3 t 2 0 1 8 o2 n 3 n o 1 8 10 t 1 1 t 2 0 1 8 10 t 1 1 t 2 0 ' t 8 10 t 1 1 t 2 0 1 8 07 p 5 n o 1 9 07 t 2 3 t 2 0 1 9 12 t 0 4 t 2 0 ' t 9 12 n 4 n f f i 9 05 t 2 8 t 2 0 2 0 05 n 8 n o 2 0 05 n 8 n a 2 0 03 n 2 r 2 0 2 2 3, 7 6 8 , 6 9 3 . 0 0 4, 2 2 7 , 4 6 4 . 0 0 4, 1 36 , 0 7 1 .0 0 4, 2 3 0 , 2 9 6 . 0 0 4, 9 5 5 , 8 2 3 . 0 0 4, 7 9 2 , 5 1 9 . 0 0 6, 5 9 7 , 3 3 1 . 0 0 6, 2 3 7 , 7 9 1 . 0 0 6, 8 1 3 , 0 2 8 . 0 0 6, 6 9 8 , 4 3 4 . 0 0 8, 0 3 8 , 3 6 3 . 0 0 7, 6 3 4 , 2 5 8 . 0 0 8, 3 2 2 , 8 4 5 . 0 0 Un a p p l i e d 0.00 0.00 0.00 o-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.00Accrued Inl 0.00 0.00 2,108.00 o.00 7,669.07 0.00 14,994.51 0.00 11,120.02 0.00 27,8m.38 0.00 47,593.15 0.00 0.00 65,486.82 0.00 40.o75.67 0.00 ffi,523"77 0.00 0.00 256,583.05 11 , 1 0 0 , 0 m . 0 0 0 3 t o 2 n a 2 2 8, 8 8 8 , 7 5 0 . 0 0 1 . 7 5 0 0 0 6 t 1 5 t 2 0 , 4 5 Pr i n c i p a l In t e r e s t Pr i o r Ba l a n c e Da y s Ra t e Pm t Sh o r t 79 5 , 7 1 9 . 0 0 0. 0 0 0. 0 0 0 1. 7 5 0 0 0 00 -1 5 6 , 5 1 7 . 0 0 0. 0 0 79 5 , 7 1 9 . 0 0 0 1. 7 5 0 0 0. 0 0 0. 0 0 63 7 , 2 0 2 . 0 0 69 1. 7 5 0 0 0. 0 0 1, 5 9 3 , 6 4 8 . 0 0 0 1. 7 5 0 0 0. 0 0 1, 4 0 3 , 1 13 . 0 0 11 4 1. 7 5 0 0 0. 0 0 2, 5 8 7 , 3 6 7 . 0 0 0 1. 7 5 0 0 0. 0 0 2, 3 5 1 , 4 4 9 . 0 0 13 3 1. 7 5 0 0 0. 0 0 3, 2 2 5 , 9 4 4 . 0 0 01 . 7 5 0 0 0. 0 0 3, 0 5 1 , 7 3 4 . 0 0 76 1. 7 5 0 0 0. 0 0 3, 9 4 7 , 0 5 1 . 0 0 0 1. 7 5 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 15 4 0 24 0 0 0 28 5 0 13 4 0 17 6 0 0 64 3 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 75 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 0- 0 0 0. 0 0 Th u n d a y , Ma r c h 03 , 2 0 2 2 Page I of 2 Tr a n s # En t r e d 00 0 1 1 2 3 6 03 t 0 2 t 2 0 2 2 To t a l Di s b u r s e m e n t s To t a l Pa y m e n t s To t a l Ca p i t a l i z e d ln t e r e s t To t a l Fo r g i v e n TC As Of Da t e De s c r i p t i o n M A3 I A 2 2 O 2 2 MA R K D O W N TM N S A C T I O N #1 1 Pr i n c i p a l -1 4 0 , 7 7 6 . 0 0 11 ,1 0 0 , 0 0 0 . 0 0 0. 0 0 0. 0 0 -2 , 2 1 1 , 2 5 0 . 0 0 In t e r e s l 0. 0 0 Pm t Sh o r t 0. 0 0 Unapplied 0.00Accraed Int 0.00 Pr i o r Ba l a n c e Da y s Ro t e 9, 0 2 9 , 5 2 6 . 0 0 0 1. 7 5 0 0 0. 0 0 0. 0 0 0. 0 0 0. 0 0 529,984.44 529,980.44 0.00 0.00 Th a n d a y , Ma r c h 03 , 2 0 2 2 Page 2 of2