The URL can be used to link to this page

Home My WebLink About319991 12/21/2017 y ur..44N,y CITY OF CARMEL, INDIANA VENDOR: 371726 CHECK AMOUNT: $***1 13,197.19 d ONE CIVIC SQUARE REGIONS EQUIPMENT FINANCE r ,?� CARMEL, INDIANA 46032 PO BOX 2545 CHECK NUMBER: 319991 BIRMINGHAM AL 35202-2545 CHECK DATE: 12/21/17 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 2201 4353099 820259 97,394.47 OTHER RENTAL & LEASES 2201 R4353099 34175 820259 15,802.72 SIGN TRUCK VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor# REGIONS BANK IN SUM OF$ CITY OF CARMEL _. C�61 An invoice or bill to be properly itemized must show:kind of service,where performed,dates service 4L 3` 5 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. i Payee $15,802.72 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Street Department Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 34175 820259 43-530.99 $15,802.72 1 hereby certify that the attached invoice(s),or 12/1/17 820259 $15,802.72 2201 Encumbered 2201 2201 2201 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Wednesday, December 13,2017 Huffman, Dave Director I hereby certify that the attached invoice(s),or bill(s), is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer Al. 16L EG 101 N N�S REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202-2546 Page Number 1 of ,2 '�IIII�II�II��IIII11�'��IIII�III�'lllll�ll��ll�I��II��I��II Invoice Date 12/01/2017 Invoice Number. 82025920259 0000091 01 SP 0.460001 Invoice Due Date 01/15/2018 Attn: LINDA HARVEY Total Current Due 136,082.57 CITY OF CARMEL, INDIANA Total Amt 136,082.57 ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 136,082.57 051-0013163-003 Invoice Description; 1 HARRIER CFS TRAILER MOUNTED BREATHING AIR COMPRESSOR; INTEGRATED 100FT. SPRING REWIND HOSE REEL W/ Purchase Order: Termination Date: 02/15/2022 Contract Activit From Date To Date #of Days Int Rate Int Accrual Int Pymt Payment Prin Bal Accrual Type 04/30/2017 05/31/2017 31 1.72 1,916.56 0.00 0.00 1,294,000.00 Monthend 05/31/2017 06/30/2017 30 1.72 1,854.73 0.00 0.00 1,294,000.00 Monthend 06/30/2017 07/11/2017 10 1.72 618.24 0.00 -54.90 1,293,945.10 Payment 07/11/2017 07/15/2017 4 1.72 247.29 -14,961.50 -121,121.07 1,172,824.03 Payment 07/15/2017 07/15/2017 0 1.72 0.00 0.00 0.00 1,172,824.03 Involcing 07/15/2017 07/31/2017 17 1.72 952.59 0.00 0.00 1,172,824.03 Monthend 07/31/2017 08/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend 08/31/2017 09/30/2017 30 1.72 1,681.05 0.00 0.00 1,172,824.03 Monthend 09/30/2017 10/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend 10/31/2017 11/30/2017 30 1.72 1,681.05 0.00 0.00 1,172,824.03 Monthend 11/30/2017 12/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend 12/31/2017 01/15/2018 14 1.72 784.49 0.00 0.00 1,172,824.03 Invoicing Current Char es Desc Due Date Amount Due Tax Late Charge Total Due Principal(Fixed;Pymt) 01/1512018 125,771.63 125,771.63 Interest 01/15/2018 10,310.94 10:310:94 p Please Detach and Return with Payment REGIONS EQUIPMENT FINANCE CORPORATION Equipment Finance Payment A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-003 REGIONS CAPITAL ADVANTAGE,INC WIRE INSTRUCTIONS Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 820259 AACCOUN�T#0107024142 Total Amount Due 136,082.57 I11-IIIII4N,I 1111 'nlrr'lillllll�lhl��l��l��llllu�'I Amount Enclosed LOAN AMORTIZATION Ddu e : deet rel 360/365/actual day calculations.......Actual/360 Average life........2.962 years Interest rate...........1.72000000% debt ending date takedowns service. interest principal balance 0.11612597 11/14/2016 150,267.00 - - - 150,267.00. 7/15/2017 - 15;802.72 1,744.60 14,058:12 136,208.88 . 1,197.43 14,605.29 121,603.59 7/15/2018 - 15,802.72 1,051.60 14,751.12 106,852.47 1/15/2019 - 15,802.72 939.35 14,863.37 91,989.10 7/15/2019 - 15,802.72 795.50 151007.22 76,981.88 1/15/2020 - 15,802.72 676.76 15,125.96 61,855.92 7/15/2020 - 15,802.72 537.87 15,264.85 46,591.07 1/.15/2021 - 15,802.72 409:59- 15;393:13 31,197:93 , 7/15/2021. - 15,802.72 269.79 15,532.93 15,665.01 1/15/2022 - 15,802.72 137.71 15,665.01 - TOTAL 150,267.00 158,027.20 7,760.20 150,267.00 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201 (Rev.1995) ALLOWED 20 ACCOUNTS PAYABLE VOUCHER Vendor� 3 1j 1a t0 REGIONS BANKIN SUM OF$ CITY OF CARMEL 1 I� �P.t An invoice or bill to be properly itemized must show:kind of service,where performed,dates service rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. Payee $97,394.47 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Street Department Terms Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 820259 43-530.99 $97,394.47 1 hereby certify that the attached invoice(s),or 12/1/17 820259 $97,394.47 2201 2201 2201 2201 bill(s)is(are)true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except Wednesday, December 13,2017 Huffman, Dave Director I hereby certify that the attached invoice(s),or bill(s), is(are)true and correct and I have audited same in accordance with IC 5-11-10-1.6 20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer " Y& I 0 i � �'� ��S REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202-2545 Page Number 1 of 2 Invoice Date 12/01/2017 '11111�1i1111'1111111'111111111111'illll'11'111'I'11111"'I'1"11 Invoice Number 820259 '6 0000091 01 SP o.4so ooi Invoice Due Date 01/15/2018 Attn: LINDA HARVEY Total Current Due 136,082.57 CITY OF CARMEL, INDIANA Total Amt 136,082.57 ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 136,082.57 051-0013163-003 Invoice Description: 1 HARRIER CFS TRAILER MOUNTED BREATHING AIR COMPRESSOR; INTEGRATED 100FT. SPRING REWIND HOSE REEL W/ Purchase Order: Termination Date: 02/15/2022 Contract Activit From Date To Date #of Days Int Rate Int Accrual Int Pymt Payment Prin Bal Accrual Type 04/30/2017 05/31/2017 31 1.72 1,916.56 0.00 0.00 1,294,000.00 Monthend 05/31/2017 06/30/2017 30 1.72 1,854.73 0.00 0.00 1,294,000,00 Monthend 06/30/2017 07/11/2017 10 1.72 618.24 0.00 -54.90 1,293,945.10 Payment 07/11/2017 07/15/2017 4 1.72 247.29 -14,961.50 -121,121.07 1,172,824.03 Payment 07/15/2017 07/15/2017 0 1.72 0.00 0.00• 0.00 1,172,824.03 Invoicing 07/15/2017 07/31/2017 17 1.72 952.59 0.00 0.00 1,172,824.03 Monthend 07/31/2017 08/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend 08/31/2017 09/30/2017 30 1.72 1,681.05 0.00 0.00 1,172,824.03 Monthend 09/30/2017 10/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend 10/31/2017 11/30/2017 30 1.72 1,681.05 0.00 0.00 1,172,824.03 Monthend 11/30/2017 12/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend 112/31 017 01/15/2018 1 14 1.72 784.49 0.00 0.00 1,172,824.03 Invoicing Current.Char es Desc Due Date Amount Due Tax Late Charge Total Due Principa (FixediPymt) 01/15/2018 125,771.63 125,771.63 Interest 01/15/2018 10,310.94 1013110:94 Please Detach and Return with Payment REGIONS EQUIPMENT FINANCE CORPORATION Equipment Finance Payment A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-003 REGIONS CAPITAL ADVANTAGE,INC WIRE IN Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 820259 AACCOUNT#0107024142 Total Amount Due 136,082.57 111'nill�'��Qi1�Bit(i�iilrr'Iih1111tI1�I�IIIl1�11111n1'I ��) 3��.y1-- -- Amount Enclosed t i I w LOAN AMORTIZATION C1'umm"� ®r apt..sait�o x- 360/365/actual day calculations.......Actual/360 Average life........2.962 years Interest rate...........1.72000000% debt ending date takedowns service, interest. principal balance 0.705374034 11/14/2016 912,754.00 - - - 912,754.00 7/15/2017 - 95,989.11 10,597.07 85,392.04 827,361.96 TfT�S?/2Qs 7,273.43 88,715.68 738,646.28 7/15/2018 - 95,989.11 6,387.65 89,601.46 649,044.81 1/15/2019 - 95,989.11 5,705.83 90,283.29 558,761.53 7/15/2019 - 95,989.11 4,83105 91,157.07 467,604.46 1/15/2020 - 95,989.11 4,11036 91,878.35 375,726.11 7/15/2020 - 95,989:11'. 3,267:.15_'- 92,721.97 283,004.14 1/15/2021 - 95,989.11 2,487.92, 93;501.19 189,502.95 - 7/15/2021 - 95,989.11 1,638.78 94,350.33 95,152.62 1%15/2022 - 95,989.11 836.50 95,152.62 - TOTAL 912,754.00 959,891.13 47,137.13 912,754.00 LOAN AMORTIZATION tree en - ur�Qs�g Vehic t w Flat e; ru k i 360/365/actual day calculations........Actua1/360 Average life........2.962 years Interest rate...........1.72000000% debt ending date takedowns service interest principal balance 0.010327241 11/14/2016 $13,363.45 - - - 13,363.45 7/15/2017 - 1,405.36 155.15 1,250.21 12,113.24 r.08 05.3' 106.49 1,298.87 10,814.37 7/15/2018 - 1, .36 93.52 1,311.84 9,502.54 1/15/2019 - 1,405.36 83.54 1,321.82 8,180.72 7/15/2019 - 1,405.36 70.75 1,334.61 6,846:10 1/15/2020 - 1,405.36 60.18 1,345.17 5,500.93 T115/2020 - 1,405.36 47:83 1,357 52 4,143.41 _ -1j�13/2021 - 1,405.36 36.43 1,368:93 2,774.48 7/15/2021 - 1,405.36 23.99 1,381.36 1,393.11 1/15/2022 - 1,40.5.36 1.2.25 1,393.11 (0.00) TOTAL 13,363.45 14,053.58 690.13 13,363.45