Loading...
HomeMy WebLinkAbout320281 01/04/18 CITY OF CARMEL, INDIANA VENDOR: 371726 h•; b 31 ONE CIVIC SQUARE REGIONS EQUIPMENT FINANCE CHECK AMOUNT: $***308,394.61* x =� CARMEL, INDIANA 46032 PO BOX 2545 CHECK NUMBER: 320281 BIRMINGHAM AL 35202-2545 CHECK DATE: 01/04/18 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 1207 4353099 30,805.39 OTHER RENTAL & LEASES 604 5023990 58,173.30 OTHER EXPENSES 652 5023990 28,761.87 OTHER EXPENSES 102 R4465003 101127 24,310.33 AMBULANCE PAYMENT 1205 4467099 01152018 3,434.04 OTHER EQUIPMENT 2200 4465001 820258 2,601.28 CARS & TRUCKS 2201 4465001 820258 38,855.89 CARS & TRUCKS 1205 4467099 821355 42,361.88 OTHER EQUIPMENT 1110 4467099 823248 2,382.76 OTHER EQUIPMENT 2201 4465001 823248 55,494.31 CARS & TRUCKS 1115 4462800 823249 6,102.27 SPECIAL PROJECTS 1192 4465001 JAN2018 12,976.78 CARS & TRUCKS 1192 4467099 JAN2018 2,134.51 OTHER EQUIPMENT VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM, AL 35202-2545 Payee $30,805.39 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Brookshire Golf Course 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 821355 43-530.99 $30,805.39 1 hereby certify that the attached invoice(s),or 12/10/17 821355 Lease $30,805.39 1207 101 Prior Year 1207 101 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 Monday,January 08,2018 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 20Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer APA,AEG-1-ONS REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM.AL 35202-2545' Pagoi Number 1 of 2 Ill u"11: 1 .1 Invoice Date 1;2/10/2017 .Ir.1 ��� 'r...I. I .IIu IIIIII'I'I'I''I"I:�Illlll'I Invoice Number• 821355 Invoice Due Date 01/1,5/2018 090022s 01 SP- �0.460 Doi TotaL.Current Due 12:2,058,19_ Attn LINDA HARVEY` CITY O,F- G'ARME'L INDIANA; ToWAmt 122;05819. ONE CIVIC SQUARE Total Tax 0.00 CARMEL" iN 46032=25'84 - Total'Late Charges 0.00, Total"Amount Due 122,058:19 051-0013.163-004 EXPANSIONrNODE,EOXACQVIS16N SECURITY'AV.EQUIPMENT, pl NAND1CAP LIFT; NUTANIX V Purchase Order` Termination Date:. 01/16/2022 Contract Activit From Date To.Date #'.of Days., Int-Rate Int Accrual Int Pymt Payment; ,Prin'Bal Accrual Tye 05/31/2017 06(30/2017 '. 30 2:14 " 2;05618 0.00 0.00 1,153,000 00 Monthend" 06/30/20.17 07./15/2017 14' -2:14 959:55 -10,143,:83 -111,914:36 1,041,085 64 Payment •07/15/2017 0711:5/2017 0 214 0.00. 0.00- 0.00 1,041,08564 Invoicing `07/15/2017 071,31/2017 17 2:14 1,052.07 0.0,0. 0.00: 1,041,085.6.4. Monthend 107/31/2017 08/31/2017 .' 31 2.144 1;918:49 0.00' .0.00 1.;041,085.6`4 Monthend - 08/31/2017 09/30/2017. 30 2;14 1,856:60 0.00 0.00° 1•;041,085 64 Monthend 09/30/20.17 10/31/2017 31. 2;14 1,918.49 0.00 0:00' 1;041,085.64' Monthend 1'0/31!2017 11/30/2017 30 2.1:4 1.;856:60 0:00- 0.00 1•,041,085:64 Monthend' - 11/30/2,01;7 . 1.2131/2017 31. 2-14 1.;918.49 OM . 0 00: 1:04'1,085:64 M_ onthend 12/3i/2017 0.1/15/2018 14: .2.1.4 866:4:1 0.00 0.00'.' 1.,0:41,085.64 Invoicing. ; Current Char..es Doc: Due:pate Amount pue Tax Late Charge Total Due', Principal(Fixed-Pymt) 011152018 I 11.0,671.03. 1'10;671:03 Interest 0171512018. " 11387)6 11387:16 Please Detach and Return with Payment Aft REG-10 EQUIPMENT FINANCE CORP0AATION EC uiphi.eht Finat1C0 Pay/ hent A/R Name. CITY OF,CARMEL, INDIANA k6ntiact,Number 05,1-0013:1`63-00,4 --- REGIONS'CAPITAL ADVANTAGE,_INC WIRE INSTRUCTIONS Invoice D6 Date: 01;/15/2018. I ABA#'062000019. Invoice Number. 821.355." ACCOUNT#0107024142 Total AmoUn_f D,ue 1223,058:19 liii�i�li�l���i ,T�j,i llll,i, 111.1111111-1111'!1111111�l Amount Enclosed Schedule 4 -'Golf Course Annual Annual Annual Option Payment Principal Principal lnterest Interest Total Payment Principal. Purchase Due Date '.Payment,_ Total Payment: Total Payment __ Total _, Balance Price 02%16%17- - - 290,997:38_ 01/15/18_ 27 931.28 — 2,8.7.4.11 _J. 30,80539; 234;838:14 c.. �— 07/15/18 28;278:6.6 56,209'.94 2,526.73 5,400.84: 30,805 39." _ 61,610.78;. 1206,559:48 01/15/19, 28,546.092,-259:30 30,8,0$.39 178;013.39 07/15/19, 28,890:06'; 57,436:15 1,91533 4;174:63•,;-_, 30;80539 _ 81,61038: :149,12134 01/15[20 29,174.31 ;1;63108 30,805.39 -119,949:02 07/15/20 29;507.67 '58,681.98 1,-297:71 2;928.79' _ 30;805.38 61,610.77 90,441.35 01/15/21 29,816:16 989:23 30;805:39 '60,625.19 07%15/21- 30;153:10 59,969:26, , 652.29 1641:52 30,805:39 61,610:78 30,472:09 01/15/22, 30,472:09. 30,47109 83330 333.30'' 30;805.39 30,805:39' - Totals $ 296;997.38 $ 17;056:50 $ 308;053:89 ,Lease.Schedule#4-Golf Coarse Description.- Telephone.System:Equipmen't' Mowers-4 Sprayer Aerator Debris.elower Tractor VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM, AL 35202-2545 Payee $38,855.89 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# 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 820258 44-650.01 $38,855.89 1 hereby certify that the attached invoice(s),or 12/1/17 820258 $38,855.89 2201 2201 Prior Year 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 Tuesday,January 02,2018 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 REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL35202-2645 Page Number 1 of 2 'llll'll'll'llllllllrillllilll'I'll"Ill�rllllll"I"IIII'I'l'I'I Invoice Date 12/01/2017 Invoice Number 82025820258 �• Invoice Due Date 01/15/2018 000009001 SP 0.460001 Total Current Due 166,723.77 Attn: LINDA HARVEY Total Amt 166,723.77 CITY OF CARMEL, INDIANA ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 166,723.77 051-0013 1 63-002 Invoice Description: (18) 2016 113 FORD EXPLORER POLICE AWD 4DR Purchase Order: Termination Date: 01/16/2021 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.56 1,729.64 0.00 0.00 1,287,576.65 Monthend 05/31/2017 06/30/2017 30 1.56 1,673.85 0.00 0.00 1,287,576.65 Monthend 06/30/2017 07/15/2017 14 1.56 781.13 -10,098.88 -156,624.89 1,130,951.76 Payment 07/15/2017 07/15/2017 0 1.56 0.00 0.00 0.00 1,130,951.76' Invoicing 07/15/2017 07/31/2017 17 1.56 833.13 0.00 0.00 1,130,951.76 Monthend 07/31/2017 08/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 08/31/2017 09/30/2017 30 1.56 1,470.24 0.00 0.00 1,130,951.76 Monthend 09/30/2017. 10/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 10/31/2017 11/30/2017 30 1.56 1,470.24 0.00 0.00 1,130,951.76 Monthend 11/30/2017 12/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 12/31/2017 1 01/15/2018 1 14 1.56 686.11 0.00 0.00 1,130,951.76 Invoicing Current Char es Desc Due Date Amount Due Tax Late Charge Total Due Principal(Fixed Pymt) 01/15/2018 157,706.29 157,706.29 Interest 01/15/2018 9,017.48 9,017.48 Please Detach and Return with Payment IREGIONS EQUIPMENT FINANCE CORPORATION Equipment Finance Payment i I A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-002 REGIONS CAPITAL ADVANTAGE,INC WIRE INSTRUCTIONS Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 820258 ACCOUNT#0107024142 Total Amount Due 166,723.77 'rdr�l�u'f�i"ull��ll'llr�h'I°Ilhlllrlli""rrll 38,855. Amount Enclosed 1 LOAN AMORTIZATION { ` Q eAWu[e ., treet G� Interest calculations.................................Actual/360 Averagelife.....................................................2.609 years Interest rate.....................................................1.56000000% debt ending date takedowns service interest principal balance 6/16/2016 335,833.00 - - - 335,833.00 1/15/2017 - 38,855.89 3,099.74 35,756.16 300,076.84 7/15/2017 - 38,855.89 2,353.60 36,502.29 263,574.55 / - A='5,83'- M 2,101.57 36,754.33 226,820.22 7/15/2018 - 38,855.89 1,779.03 37,076.87 189,743.36 1/15/2019 - 38,855.89 1,512.89 37,343.01 152,400.35 7/15/2019 - :38,855.89 1,195.33 37,660.57 114,739.78 1/15/2020 - '38,855.89 914.86 37,941.04 76,798.74 7/15/2020 - 38,855.89 605.69 38,250.21 38,548.53 1/15/2021 - 38,855.89 307.36 38,548.53 0.00 TOTAL 335,833.00 349,703.05 13,870.05 335,833.00 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201 (Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER IN SUM of$ CITY OF CARMEL REGIONS EQUIPMENT FINANCE PO BOX 2545 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. BIRMINGHAM, AL 35202-2545 Payee $55,494.31 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Street Department Terms Date Due P.O# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 823248 44-650.01 $55,494.31 1 hereby certify that the attached invoice(s),or 12/27/17 823248 $55,494.31 2201 2201 Prior Year 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,January 03,2018 Lunn,Amy Admin Assistant 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 20Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer AREGIONS REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202.2645 Page Number 1 of 1- Illr II r Invoice Date. 12/27/2017 1I I� I�II fill III 1II�IJLII���I ��I Invoice Number 823248 0000136 01 SP 0.460 001 Invoice Due Date 01/15/2018 Attn: .CHRISTINE PAULEY Total Current Due 93,814.67 CITY: OF CARMEL INDIANA Total Amt 93,814.67 ONE CIVIC SQUAlkETotal Tax 1 0.00 CARMEL IN 46032-2584 Total.Late Charges 0.00 Total Amount Due 93,814.67 001-0013163-006 Invoice Description: 1.9 VEHICLES,A VACUUM SWEEPER,AND COMPUTER EQUIPMENT Purchase.Order: Termination Date: 07/15/2022 Current Char es Desc Due Date Amount Due Tax Late Charge Total Due. Renta 01 15/2018 93,814.67 93,A14.67 Invoice Message PLEASE CONTACT USAT-1-866-545-1758 WE APPRECIATE YOUR BUSINESS Please Detach and Return with Payment AIRILEGIONS EQUIPMENT FINANCE CORPORATION Equipment f=inance Payment A/R Flame CITY OF CARMEL, INDIANA Contract Plumber 001-0013163-006 REGIONS.BANK C/O REGIONS EQUIPMENT FINANCE Invoice Due Date 01/15/2018 P.O.BOX 11407 Invoice Number 823248 BIRMINGHAM,AL 35246-1001 Total.Amount Due 93,814.67 Amount Enclosed _�51��4,3 SCHEDULE NU.6 TO MASTER GOVERNMENTALL'LEASE AGREEMENT Dated August-9,.2017 by and between City of Carmel;Indiana and REGIONS EQUIPMENT FINANCE CORPORATION SCHEDULE OF PAYMENTS reet `epaaet'merft Principal Interest Payment Purchase Option Period Date Funding Component Component Amount Price 0 8/9/2017 $ 516;774.00 $ 516,774.00 1 —fi El/20 8] $ 49,445.82 $ 6,048.50 $ L,254 M.y $ 467.;328.18 .2 7/15/2018 $ 49,183.05 $ 6,311.27 $ 55,494.31 $ 418,145:13 3. 1/15/2019 $ 49,847.26 $ 5,647;05 $ 55,494.31 $ 368,297.87 4 7/15/2019 $ 50;520.45 $ 4,973.87 $ 55,494.31 $ 317,777.43 5 1/15/2020 $ 51,202.73. $ 4,291.59 $ 55,494.31 $ 266,574.70 6 7/15/2020 $ 511894.22 $ 3;600:10 $ 55,494.31 $ 214,680.48 7 1/15/2021 $ 52,595.05 $ 2,899:26 $ 55,494.31 $ 162,085.43 8 7/15/2021 $ 53,30S.35 $. 2,188.97 $ 55,494.31 $ 108,780.08 9 1/15/2022 $ 54,025.23 $ 1,469:08 $ 55,494.31 $ 541754.85 10 7/15/2022 $ 54,754:85" $ 739.4T $ 55,494.31 $ - This amortization schedule is provided for informational purposes only. For payoff quotes contact Regions Equipment Finance Corporation at 1-866-545-1758. APR E G M 1 Q1 S REGIONS EOUIPMENT FINANCE P.O.9OX 2545 BIRMINGHAM.AL 35202-2545 Page Number 1 of 2 Invoice Date 12/10/2017 III 1111 I ( III I III I I III ! III 1 [l u I Invoice Number 821355 0000226 01 SP 0.460 001 Invoice Due Date 01/15/2018 Attn: LINDA HARVEY Total Current Due 122,058.1-9 CITY OF CARMEL, INDIANA Total Amt 122,058.19 ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 122,058.19 051-0013163-004 Invoice Description: FORD F-250 AMBULANCE,AV EQUIPMENT, HANDICAP LIFT, NUTANIX VDI EXPANSION NODE, EXACQVISIbN SECURITY Purchase Order: Termination Date: 01/16/2022 Contract Activit From Date To Date #of Days I Int Rate Int Accrual Int Pymt, Payment Prin Bal Accrual Type 05/31/2017 66/30%2017 30 2.14 2,056.18 0.00 0.00 1,153,000.00 Monthend 06/30/2017 07/15/2017 14 2.14 959.55 -10,143.83 -111,914.36 1,04.1,085.64 Payment 07/15/2017 07/15/2017 0 2.14 0.00 0.00 0.00 1,041;085.64 Invoicing 07/15/2017 07/31/2017 17 2.14 1,052.07 0.00 0.00 1,041,085.64 Monthend 07/31/2017 09131/2017 31 2.14 1,918.49 0.00 0.00 1,041,085.64 Monthend 08/3112017 09/30/2017 30 2.14 1,856.60 0.00 0.00 1,041,085.64 Monthend 09/30/2017 10/31/2017 31 2.14 1,918.49 0.00 0.00 1,041,085:64 Monthend 10/31/2017 11130/2017 30 2.14 1,856.60 0.00 0.00 1,041,085.64 Monthend 11/30/2017 12/31/2017 31 2.14 1,918.49 0.00 0.00 1,041,085.64 Monthend 12/31/2017 01/15/2018 14 2.14 866.41 1 0.00 0.00 1,041,085.64 lnvoicing Current Char es Desc Due Date I Amount Due Tax Late Charge Total Due Principal (Fixed Pymt) 01/15/2018 110,671.03 110,671.03 Interest 01/15/2018 11,387.16 11387.16 R7 �+ Please Detach and Return with Payment EGFONS EQUIPMENT FINANCE CORPORATION Equipment Finance Payment A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-004 REGIONS CAPITAL ADVANTAGE,INC WIRE INSTRUCTIONS Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 821355 ACCOUNT#0107024142 Total Amount Due 122,058.19 Tlf`j'j,111111,1r11u„II,III,�IIuIIlhlllill Amount Enclosed Schedule 4 -City Council Annual Annual Annual Option Payment Principal Principal Interest Interest Total Payment Principal Purchase Due Date Payment Total Payment Total Payment Total Balance Price 02/16/17 400,163.60 -- ,- ; 07/,115/17 38 817.54 38 817.5•'. { -3!.5441.34 3,544.34. 42,361.88 42.361.88 1 361,346.O6 01/15/18 38;409:56 3,952.32 -42,361.88. 322,936.50 07/15/18 38,887.26 77,296.82 3,474.62 7,426.94 42,361.88 84,723.76 284,049.24 01/15/19 39,25.5.01 3,,106.87 42,361.88 244,794.23 07/15/19 39;728.03 78,983.04 2,633.85 5,740.72 42,361.88 84,723.76 205,066.21 01/15/20 40,118.91 2,242.97 42,361.88 164,947.29 07/15/20 40,577.33 80,696.24 1,784:55 4,027.52 42,361.88 84,723.76 124,369.96 01/15/21 41,001.55 1,360.33 42,361.88 83,368.41 07/15/21 41,464.88 82,466.43 . 897.00 2,257.33 42,361.88 84,723.76 41,903.53 01/15/22 41,903.55 41,903,55 458.33 458.33 42,361.88 42,361.88 - Totals $ 400,163.60 $ 23,455.17 $ 423,618.77 Lease Schedule#4-City Council Description: Audio Video Equipment VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) I Vendor# -1.,U10 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER 3'�� REGIONS$ANK raVW IOAJAT-� IN SUM OF$ CITY OF CARMEL —FD i�Qx A S q$ An invoice or bill to be properly itemized must show:kind of service,where performed,dates service -Jq f-fAM .3'5002—" rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. Payee $42,361.88 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# General Administration 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 821355 44-670.99 $42,361.88 1 hereby certify that the attached invoice(s),or 1/4/18 821355 $42,361.88 1205 101 1205 101 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 Thursday,January 04,2018 Crider,James Administration 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 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# Z6+40S �Z-1& ALLOWED 20 ACCOUNTS PAYABLE VOUCHER ?j'?( REGIONS-&kW r-QV(P r1A1Yq JG6— IN SUM OF$ CITY OF CARMEL c-eR e'+*��� '?O 9?,p)c Z$4""//5An invoice or bill to be properly itemized must show:kind of service,where performed,dates service 19NE W131ANA SQUARE 81611 FE 705 Al— rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. �nNAP0 IC IAI d 7rt4-- ?JS�Z�ZS�S I I QD'rl"�TV7'ST•T7 00� Payee $3,434.04 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# General Administration 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 01152018 44-670.99 $3,434.04 1 hereby certify that the attached invoice(s),or 1/15/18 01152018 Auto Lease $3,434.04 1205 101 1205 101 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,January '03,2018 Crider,James Administration 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 AOL R iEG I O L V_S REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,Al 35202-2545 Page Number 1 of 2 I ,I „ I III 1111 I I IIll.[Mll IIII, ,I,I IIII„I„ invoice Date 12/10/2017 I1 I Invoice Number 821355 0000226 01 SP 0.460 001 Invoice Due Date 01/15/2018 Attn: LINDA HARVEY Total Current Due 122,058.19 CITY OF CARMEL, INDIANA Total Amt 122,058.19 ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total-Amount Due 122,058.19 051-0018163-004 Invoice Description: FORD F-250 AMBULANCE, AV EQUIPMENT, HANDICAP LIFT, NUTANIX VDI EXPANSION NODE, EXACCIVISIbN SECURITY Purchase Order: Termination Date: 01/16/2022 Contract Activit From Date To Date #of Days. Int Rate Int Accrual Int Pymt, Payment Prin Bal I Accrual Type 05/31/2017 06/30/2017 30 2.14 2,056.18 0.00 0.00 1,153,000.00 Monthend 06/30/2017 07/15/2017 14 2.14 959.55 -10,143.83 -111,914.36 1,041,085.64 Payment 07/15/2017 '07/15/2017 0 2.14 0.00 0.00 0.00 1,041,085:64 Invoicing 07/15/2017 07/31/2017 17 2.14 1,052.07 0.00 0.00 1,041,085.64 Monthend 07/31/2017 09/31/2017 31 2.14 1,918.49 0.00 0.00 1,041,085.64 Monthend 08/31/2017 09/30/2017 30 2.14 1,856:60 0.00 0.00 1,041,085.64 Monthend 09/30/2017 10/31/2017 31 2.14 1,918.49 0.00 0.00 1,041;085.64 Monthend 10/31/2017 11/30/2017 30 2.14 1,856.60, 0.00 0.00 1,041,085.64 Monthend 11/30/2017 12/31/2017 31 2.14 1,918.49 0.00 0.00 1,041;085.64 Monthend 12/31/2017 01/15/2018 .14 2.14 866.41 i 0.00 0.00 1,041,085.64 Invoicing Current.Char es Desc Due Date I Amount Due Tax Late Charge Total Due Principal (Fixed Pymt) 01/15/2018 110,671.03 110,671.03 Interest 01/1512018 11,387.16 1 11387.16 REGEONS Please Detach and Return with Payment EQUIPMENT FINANCE CORPORATION Equipment Finance Payment A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-004 REGIONS CAPITAL ADVANTAGE,INC WIRE INSTRUCTIONS Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 821.355 AC�C�OQUN�T#0;107024142 Total Amount Due 122,058.19 1111,�III�ll�llryll��"11,111111,1,�I11„11�I11��111111111111111 - - Amount Enclosed Schedule 4. -Administration Annual Annual Annual Option Payment Principal Principal Interest Interest Total Payment Principal Purchase Due Date Payment Total Payment Total Payment Total Balance Price 02/16/17 32,439.00 3,1 287.32.) 287.32 _ 3,434'.04' 3,434.04 -29,292.28 01/15/18 3,113.65 320.39' 3,434.04 26,178.63 07/15/18 3,152.37 6,266.02 281.67 602.06 3,434.04 6,868:08 23,026.26 01/15/19 3;182.18 251.86 3,434.04 19,844.08 07/15/19 3,220.53 6,402.71 213.51 465.37 3,434.04 6,868.08 16;623.56 01/15/20 3,252.21 181.82. 3,434.03 13,371.34 07/15/20 3,289.37 6,541.58 144.66 326.48 3,434.03 6,868.06 10,081.97 01/15/21 3,32176 110.27 3,434.03 6,758.21 07/15/21 .3;361.32 6,685.08 72.71 182.98 3,434.03 6,868.06 3,396.88 01/15/22 3,396.88 3,396.88 37:15_ 37.15 30434.03 3,434.03 - Totals $ 32;439:00 $ 1,901.38 $ 34,340.38 Lease Schedule#4-Administration Description: Ford F-250 Voucher No. Warrant No. ACCOUNTS PAYABLE DETAILED ACCOUNTS MUNICIPAL WATER DEPT. ACCT. NO. CARMEL, INDIANA Favor Of Total Amount of Voucher $ Deductions na- ao �3 -oo F3i �1� Amount of Warrant $ nJ u Month of VOUCHER RECORD Acct. No. Source of Supply Water Treatment Transmission and Dist. Customer Accounts Administrative and General e Operation-Maintenance l� A— Utility Plant in Service Constr.Work in Progress Materials and Supplies Customers Deposits Total Allowed Board of Control Filed Official Title BOYCE FORMS•SYSTEMS 1-800-382-8702 325 Voucher No. Warrant No. ACCOUNTS PAYABLE DETAILED ACCOUNTS MUNICIPAL WASTEWATER UTILITY ACC . NOT CARMEL, INDIANA 37� 17 a(p Favor Of r Cifarow5 Total Amount of Voucher $ Deductions oa-a yo (Xg103 - 4273--do Amount of Warrant g�V��� U'? Month of 3Q""�` 0 VOUCHER RECORD Acct.No. Collection S stem Pumping Treatment&Disposal Customer Accounts .1 r a Administrative&General 4r) Reclaimed Water Treatment Reclaimed Water Distribution - Total Allowed Board Members Filed BOYCE FORMS•SYSTEMS 1-800-382-8702 325 LOAN AMORTIZATION Water 2016 debt ending date Funding service interest principal balance 1/15/2018 27,757.60 1,501.30 26,256.30 162,034.23 Water 2017 debt ending date Funding service interest principal balance 1/15/2018 30,415.70 3,315.10 27,100.60 256,136.40 Prin 02-2240-00 53,356.90 Int 00-4273-00 4,816.40 58,173.30 58,173.30 LOAN AMORTIZATION Sewer 2016 debt ending date Funding service interest principal balance 1/15/2018 23,239.97 1,256.96 21,983.01 135,662.72 Sewer 2017 debt ending date Funding service interest principal balance 1/15/2018 5,521.90 601.85 4,920.05 46,500.95 Prin 02-2240-00 26,903.06 Int 00-4273-00 1,858.81 28,761.87 28,761.87 REGIONSEQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202.2645 Page Number ILL I h� III ,�III��I III �J�� I I� lI Invoice Date . 12/01./201-7 II I II I IIIII I I III I h I I V I I I Invoice Number 820258 0000090 01 SP .•0.460 001 . Invoice Due Date . 01/15/2018 Attn:. LINDA :HARVEY : Total Current Due 166,723.77 CITY OFCARMEL INDIANA Total Amt 166;723:77 ONE CIVIC .SOUAAE. Total-Tax. -0.00 CARMEL IN-46032-2584 Total Late Charges_ 0.00 - Total Amount Due 1665723.77 051-0013163-002 Invoice Description: (18)2016.113 FORD EXPLORER_POLICE,AWD4DR Purchase Order: Termination-Date: "01116/2021 Contract Activitv From Date To Date #of Das Int Rate int-Accrual Int P mt Payment Pr in Bal Accrual Type 04/30/2017 05/31/2017 . 31 1:56 1,729.64 0.00 0.00 -1,287,576.65 Monthend 05/31/2017., 06/30/2017 30 1.56 1,673.85 0.00 - 0.00 - 1,287,576.65 Monthend 06/30/2017 07/15/2017- 14 1.56 781.13 -10,098.88 --156,624.89 -1;130.,951.76 Payment 07%15/2017 .07/15/2017 . 0 i.56 . 0.00 0,00, 0.00 _..1,130,9.51.76. Invoicing 07/15/2017 07/31/20.17 17 1.56 833.13 0:00 0.00 . 1,130,951.76 Monthend 07/31/2017 08/31/2017- 31 - 1.56 1;519.25 0.00 0.00 1,130,951.76 Monthend 08/31/2017 09/30/2017. 30 1.56 1,470.24. 0.00 • 0.00 1,130,951.76 Monthend 09/30/2017 10/31/2012 - .31 1.56 1,519.25. .0.00 0.00 1,130,951.76 Monthend 1.0/31/2017 11130/2017 30 1.56. 1,470.24 0.00 0.00 . 1,130,951-.76 -Monthend 11/30/2017 12/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 12/31/2017 01/15/2018. 14 1.56 686.11 0:00 0.00.1- 1,130,951.76 Invoicing Current Char es Desc Due Date Amount Due Tax Late Charge• Total Due Principal(Fixed Pymt). 01 152018 157,706.29 157,706.29 Interest 01/15/20118 9 017.48 91017.48 Please Detach and Return with Payment REGIONS EQUIPMENT FINANCE CORPORATION Equipment Finance Payment I A/R Name CITY-OF CARMEL, INDIANA Contract Number .051-0013163-002 REGIONS CAPITAL ADVANTAGE,INC WIRE.INSTRLICTIONS. ' Invoice Due Date . 01/15/2018 ABA#062000019 Invoice Number 820258 -ACCOUNT#0.107024142 Total Amount Due 166,723.77: iillli��li.11r�li�lulllli�lrirl,,,,l,l�q Amount Enclosed LOAN AMORTIZATION Schedule 2,Water Interest calculations.....::.....................:....Actual/360 Average life::::.::............:::...:.............::............2.609 years . Interest rate.....................................................1.56000000 debt ending date takedowns service interest principal balance 6/16/2016. 2391910.00 - - - 239;910.00 1/15/2017 - 27,757.60 2,214.37 25,543:23 214,366:77 7/15/2017 - 27,757.60 1,681.35 26,076.25 188,290.52 �/1s5120�1i8 - Z�7�►757760A 1,501.30 26,256.30 162,034.23 7/15/2018 - 27,757.60 1,270.89 26,486.71 . 135,547.51 1/15/2019 - 27,757.60 1,080.77 26,676:83 108,870.68 7/15/2019 27,757.60 85191 26,903.69 81,966.99 - 1/15/2020 - 27,757.60 653.55 27;104.05 54;862.94 7/15/2020 - 27,757.60 432.69 27,324.91 27,538.03 1/15/2021 - 27,757.60 219.57. 27,538.03 TOTAL 239,910.00 249,818.39 9,908.39 239,910.00 L.O.AN AMORTIZATION Schedule 2,Sewer Interest calculations...::............................Actual/360 Average life.:..................... ....2.609 years. Interest rate'.....................................................1.56000000 debt ending . . date takedowns service interest principal balance 6/16/2016 200;864.00 - - - 200;864.00 1/15/2017 231239.97 1,853.97 21,386.00 179,478.00 7/15/2017 - 23,239:97 1,407.71 21,832.27_ 157,645.73 1►/2�5��20 8 - Q�3,?!-3.9 9r 10256.96 21,983.01 1351662.72 7/15/2018 - 23,239.97 1,064.05 22,175.93 113,486.79 1/15/2019 - 23;239.97 904.87 22,335.11 91,151.68 7/15/2019 - 23,239.97 71433. 22,525.04 68,626.64 1/15/2020 - 23,239.97 547.18 22,692.79 45;933.85 7/15/2020 - 23,239.9.7 362.26 22,877.71 23,056.14 . 1/15/2021 - 23,239.97 183.83 23,056.14. 0.00 TOTAL 200,864.00 209,159.77 8,295.77 200,864.00 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM,AL 35202-2545 Payee $2,601.28 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Enaineerina Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 820258 44-650.01 $2,601.28 I hereby certify that the attached invoice(s),or 12/1/17 820258 Engineering Vehicle Lease Payment-2017 $2,601.28 2200 2200 Prim-Year 2200 2200 Escape 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 Thursday,January 04,2018 Jeremy Kashman 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— Clerk-Treasurer 20Clerk-Treasurer REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202.2545 '2700- 14yLS0Qr Page Number 1 of 2 III I. I I III ��1114�1 III ..I.. I I. .I Invoice Date 12/01/2017 '�� I �� 111111 "� 1 III I II I I I III Invoice Number 820258 tv; Invoice Due Date 01/15/2018 Attn o of SP o.aso Total Current Due 166,723.77 CITY LINDA HARVEY OF CARMEL, INDIANA Total Amt 166,723.77 CITY ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 166,723.77 051-0013163-002 Invoice Description: (18)2016 113 FORD EXPLORER POLICE AWD 4DR Purchase Order: Termination Date: 01/16/2021 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.56 1,729.64 0.00 0.00 1,287,576.65 Monthend 05/31/2017 06/30/2017 30 1.56 1,673.85 0.00 0.00 1,287,576.65 Monthend 06/30/2017 07/15/2017 14 1.56 781.13 -10,098.88 -156,624.89 1,130,951.76 Payment 07/15/2017 07/15/2017 0 1.56 0.00 0.00 0.00 1,130,951.76 Invoicing 07/15/2017 07/31/2017 17 1.56 833.13 0.00 0.00 1,130,951.76 Monthend 07/31/2017 08/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 08/31/2017 09/30/2017 30 1.56 1,470.24 0.00 0.00 1,130,951.76 Monthend 09/30/2017 10/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 10/31/2017 11/30/2017 30 1.56 1,470.24 0.00 0.00 1,130,951.76 Monthend 11/30/2017 12/31/2017 31 1.56 1,519.25 0.00 0.00 1,130,951.76 Monthend 12/31/2017 01/15/2018 14 1.56 686.11 0.00 0.00 1,130,951.76 Invoicing Current Charges Desc Due Date Amount Due Tax Late Charge Total Due Principal(Fixe Pymt) 01/15/2018 157,706.29 157,706.29 Interest 01/15/2018 9,017.48 9,017.48 ALG N Please Detach and Return with Payment EQUIPMENT FINANCE CORPORATION Equipment Finance Payment i A/R Name CITY OF CARMEL, INDIANA Contract Number 051-0013163-002 REGIONS CAPITAL ADVANTAGE,INC WIRE INSTRUCTIONS Invoice Due Date 01/15/2018 ABA#062000019 Invoice Number 820258 ACCOUNT#0107024142 Total Amount Due 166,723.77 ll�1'yniull��ll'llr�4'I°Illnlh'Ih°"1'1'11 . �g Amount Enclosed LOAN AMORTIZATION Schedule 2,Water Interest calculations.................................Actual/360 Average life...............................................,.,....2.609 years Interest rate.....................................................1.5600000.0 yo debt ending date takedowns service interest principal balance 6/16/2016 239,910.00 - - - .239,910.00 1/15/2017 - 27,757.60 2,214.37 251543.23 214,366.77 7/15/2017 - 27,757.60 1,681.35 26,0.26.25 188,290.52. 1/15/2018 - 27757'60.-' 1,501.30 26,256.30 162,.0134.23 7/15/2018 - 27:757.60 1,270.89 26;486.71 135,547.51 1/15/2019 - 27,75.7.60 -1,080.77 26,676.83 108,870.68 7/15/.2019 - 27,757.60 853.91 261903.69 81,966.99 1/15/2020 - 27,757:60 653.55 27,104.05 54,862,94 7/15/2020 - 27,757.60 432.69 27,324.91 27;538..03 1/15/2021 - 27,757.60 219..57 27,53.8.03 0.00 TOTAL 239,910.00 249;818.39 9,908.3.9 239,910.00 LOAN AMORTIZATION Schedule 2, Engineering Interest calcu.lations.................................Actual/360 Average life......................::......:..............1.....<.2.609 years Interest rate.,.............. ......... .....................1.5600000.0% debt, ending date takedowns. service 'interest principal balance 6/16/.2016: 22,483.00 - - - 22,483.00 1/15/2017 - 2,601.28 207.52. 2,393.77 20,089..23 7/15/2017 - 2,601.28 157:57 2,443.72 17„645.52 x]/15/2018 - 2,601 I 14.0.69 2,460.59 15,184:93 �'�gi.,een"I v eL-x C, 7/15/2018. - 2,601,28 119..10 2,482.18 12,702.74 1/15/2019 - 2;60.1.28 101.28 2,500;00 10,20234 - 7/15/2019 - 2,601.28 80:02 2,521.26 7,681.48 :. 1/15/2020 - 2,601:28 61:25-.°'. 2540.04 5,141.44 7/15/2020 - 2,601.28 40.55 2,560:74 2,580.71 1/15/2021 - 2,60128 20.58 2,580.71 0.0.0 TOTAL 22,48.3.00 23,411:56. 928.56 22,483.00 LOAN AMORTIZATION Schedule 2,Sewer Interest calculations............................. Actual./,360 Average life.......................................................2.609 years Interest rate......4.:.4.................:........................1.5600000.0% :debt ending date takedowns service interest: principal balance 5/16/2016 200,864.00 - - - 200;864.00 1/.15/2017 - 23,239.97 1,853:97 21,386.00 1791478:00 7/15/2017 - 23,239.9.7 1,407.71 21,832.27 157;645:73. 1J15/2Q18 - 2-x,239.97 f' 1,256.96 21,983.01 135,662.72 7/15/2018 - 231239.97 1,054.05 22,175.93 113,486.79 1/15/2019 - 23,239.97 % 904.87 22,335.11 91,151.68 7/15/2019 - 23,239:97 :•714.93 22,525.04 68,626.64 1/15/2020 - 23,239.9.7 547:18 22,692.79, 451933.85 7/15/2020 - 23,239.97 362.26 22,877.71 23;056.14 1/15J2Q21 - 23,239.97 1.83.83 23.,056:14 0.00 TOTAL 200,864.00 209.,159.77 :8;295.77 .200,864.00 LOAN AMORTIZATMN Schedule 2;Street�`'' Interest calculations.................................Actual/360 Averagelife. ........._ ........ .............................2.609 years. Interest rate...:.................i-.............................1.56000000 debt ending date takedowns service interest principal balance. 6/16/2016 335,833.00 335,833.00 1/15/2017 - 38,855:89 3,099.74 35,75.6:16 300;076:84 7/15/2017 38;855;89 2,353,60 36,502.29 263,57455 4w110 ,,,. - 38;855:$9 fry 2,101.57 36;75433 2261820.22 7/15/2018 38,855.89 1,779.03 37076;87 189,743.36 1/15/2019. - 38,855.89 1,512:89 37;343.01 152,400.35 7/15/2019 - - ;38,855.89 1;195.33 37,660.57 114,739.78 1/15/2020 - `38,855.89 914.86 37,941.04 76,798.74 7/15/2020 - 38,855.89 605.69 38,250.21 38;548.53 1JI5/2021 - 38,855.89 .307.36 38,548.5.3 0.00 TOTAL 335,833.00 349,703.05 13,870:05 335,833.00 LOAN AMORTIZATION Schedule 2_Revised Police- interest calculations......:..:.:..:..................Actual/360. Average life.....................................................2.609 yearn Interest rate....:...........................................:....1.56000000 debt . ending. date takedowns service interest principal balance. 6/16/2016 . 641,910.00 - - - 641,910.00 1/15/2017 - 74,269.02 5,924.83 68,,344.19 573,565.81 7/15/2017 - 74,269:02 4,498.67 69;770:35 503,795.46 1/15/2018< - "74;269O2µ, 4,016.93 70252.09 433,543.37 7/15/2018 - 74,269.02 3;400.43 70,868:59 .362,674.77 1/15/2019 - 74,269.02 2,891.73 71,377:29 291,297.48 7/15/2019 - 74,269.02 2;284.74 71,984.28 219,313.21 1/15/2020 :. - . 74;269:02 1,748.66 72;520.36 146;792.84 - 7/15/2020 - 74,269.02 1,157,71 731111.31 73,681.53 1/15/202.1 - 74,269.02 587.49 731681.53 0.00 TOTAL 641,910.00 668,421.17 26,511:17 641,910.00 VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM,AL 35202-2545 Payee $24,310.33 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Carmel Fire Date Due PO# ACCT# DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 101127 0 44-650.03 $24,310.33 1 hereby certify that the attached invoice(s),or 1/4/18 0 $24,310.33 1120 Encumbered 102 1120 102 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 Thursday,January 04,2018 David Haboush Fire Chief 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 Clerk-Treasurer VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM,AL 35202-2545 Payee $2,382.76 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Terms Carmel Police Date Due PO# ACCT#, DATE INVOICE# DESCRIPTION DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT 823248 44-670.99 $2,382.76 1 hereby certify that the attached invoice(s),or 1/3/18 823248 lease payment $2,382.76 1110 101 j 1110 101 bill(s)is(are)true and correct and that the ;I materials or services itemized thereon for which charge is made were ordered and received except Wednesday,January 03,2018 Jim Barlow Chief 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— Clerk-Treasurer 20Clerk-Treasurer A5Z RL" 10 NIS REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202.2545 Page Number 1 of 1 I I I I III. I II III II�I�II�II II Invoice Date 12/27/2017 I'I III ' II"III II II II I II I I IIII III I Invoice Number 823248 0000136018P OA60 001 Invoice Due Date 01/15/2018 Attn: CHRISTINE PAULEY Total Current Due 93,814.67 CITY OF CARMELINDIANA Total Amt 93,814.67 ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 93,814.67 001-0013163-006 Invoice Description: 19 VEHICLES,A VACUUM SWEEPER,AND COMPUTER EQUIPMENT Purchase Order: Termination Date: 07/15/2022 Current Char es Desc Due Date Amount Due Tax Late Charge Total Due Rental 01/16/2018 93 8 . .67 93,01A.67 Invoice Message PLEASE CONTACT US AT 1-866-545-1758 WE APPRECIATE YOUR BUSINESS r S C Please Detach and Retum with Payment A& REGIONS EQUIPMENT FINANCE CORPORATION Equipment Finance Payment A/R Name CITY OF CARMEL,INDIANA Contract Number 00.1-0013163-006 REGIONS BANK C/O REGIONS EQUIPMENT FINANCE Invoice Due Date 01/15/2018 P.O.BOX 11407 Invoice Number 823248 BIRMINGHAM,AL 35246-1001 Total Amount Due 93,814.67 VIII""Inhlul'II'lu'III'h'll'll'dlllllllllll'I'I"u"'ll 2 3�Z---�1 - Amount Enclosed 1 `� .SCHEDULE N04 TO MASTER GOVERNMENTAL LEASE AGREEMENT Dated August 9,2017 by and between City of Carmel,Indiana and REGIONS EQUIPMENT FINANCE CORPORATION SCHEDULE OF PAYMENTS Police Department-Computers Principal Interest Payment; Purchase Option Period Date Funding Component Component Amount =. Price 0 8/9/2017 $ 22,188.71 $ 22,188.71 1 1/15/2018 $ 2,123.05 $ 259.70 $ 2,382.76 $ 20,065.66 2 7/15/2018 $ 2,111.77 "$ 270.99 $ 2,382.76 $ 17,953.89 3 1/15/2019 $ 2,140.29 $ 242.47 $ 2,382.76 $ 15,813.59 4 7/15/2019 $ 2,169.19 $ 213.56 $ 2,382.76 $ 13,644.40 5 1/15/2020 $ 2,198.491 $ 184.27 $ 2,382.76 $ 11,445.91 6 7/15/2020 $ 2,228.18 $ 154.58 $ 2,382.76 $ 9,217.73 7 1/15/2021 $ 2,258.27 $ 124.49 $ 2,382.76 $ 6,959.46 8 7/15/2021 $ 2,288.77 $ 93.99 $ 2,382.76 $ 4,670.69 9 1/15/2022, $ 2,319.68 $ 63.08 $ 2,382.76 $ 2,351.01 10 7/15/2022 $ 2,351.01 $ 31.75 $ 2,382.76 $ - This amortization schedule is provided for informational purposes only. For payoff quotes contact Regions Equipment Finance Corporation at 1-866-545-1758. `V1 O • n Prescribed by State Board of Accounts City Form No.201 (Rev.1995) VOUCHER NO. WARRANT NO. . ALLOWED 20 . Vendor# ACCOUNTS. CH ER IN SUM OF.$ CITY OF CARMEL REGIONS_9A�l v G�nft r j li CORPORATE TRUST DEPT An invoice or bill to be properly itemized must show:kind of service,where performed,dates service ONE INDIANA SQUARE SUITE 705 rendered,by whom,rates per day,number of hours,rate per hour,number of units,price per unit,etc. INDIANAPOLIS, IN 46204 ayee :. $6,102.27:. ON ACCOUNT OF,APPROPRIATION FOR Purchase Order# ICS. :. Terms Date Due PO# ACCT# DATE. INVOICE# DESCRIPTION. DEPT#' INVOICE#: Fund#. AMOUNT B tuber :: DEPT# FUND# (or note attached:invoice(s)or.bill(s)) AMOUNT. oard.Me s 823249 44-628.00 $6,102.27 .: I hereby certify that the attached invoice(s),or 12/27/17 823249 $6,102.27. 1115" 101 Prior Year 1115 101 bill(s).is(are)true and correct and that the R materials or services itemized thereon for which charge is made were ordered and received except Wednesday,January 3;2018 Arnone, Janet Admin Assistant I hereby certify that the attached invoice(s),or bill(s),is(are)true and correct and I have s accordance w I 0 1 audited same in ac danc with C 5-1.1-1 6- . 20 Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk_ Treasurer SCHEDULEN0.1 TO MASTER GOVERNMENTAL LEASE AGREEMENT Dated August 9,2017 by and between City of Carmel,Indiana and REGIONS EQUIPMENT FINANCE CORPORATION SCHEDULE OF PAYMENTS .eUartmento I;TC'hrist i 111M Principal Interest., Payment Purchase Option Period . Date Funding Component: ; Component, Amount. Price 0 10/13/2017 $. 571000.00 $ .. 571000.00 e1 1/35/2018 $. 5,698.63' 40364 $ ji 6102 N `$ 51,30137 2 7/15/2018 $ 5,39.1.49 710:78 .$ 6,102:27 $ A5,909.88,: 3 1/15/2019 $- 51466,19 636:08 $ 6,10127 , $ 40,443.69 4 : 7/15/2019.: $ 5,541;92. 56035. $ .6,102.27 $ 34,901.76 5 1/15/2020 $ 5,618:71 483.56 $ 5,102.27 '$ 29;283.05 6. 7/15/2020 $ 5,696.56 405.72 $ 6,102.27, $ 23,586.56: 7 1/15/2021 $ 5,775:48 3209 $ 6,102.27 $ 17,811:01 8 - :7/15/20211 $, 5,855.50 246:77' $ 6,102:27 $ 11,955.51 9 1/15/2022 '$ 5,936:63 .165.64 $ 6;102:27 $ 6,018.88 10 7/15/2022_. . .. $ 6,018. .6;102:27 $88 83.39 $ - This amortization schedule Is provided for •informational purposes only. :For payoff_quotes contact Regions Equipment Finance Corporation - at 1466-646-1768. -�,fir,r�;^��7 —; ANT— E I `�l�e`. REGIONS EQUIPMENT FINANCE P.O.BOX 2545 BIRMINGHAM,AL 35202-2545 Page Number 1 of 1 Invoice Date I'lll�llll'll"II'I'��I��"'I'���IIIIIIII�I'lll'll�llllll"IIIIII 12/ 27/2017 Invoice Number 823249 0000137 01 SP 0.460 001 Invoice Due Date 01/15/2018 Attn: CHRISTINE PAULEY Total Current Due 21,205.45 CITY OF CARMEL, INDIANA Total Amt 21,205.45 ONE CIVIC SQUARE Total Tax 0.00 CARMEL IN 46032-2584 Total Late Charges 0.00 Total Amount Due 21,205.45 001-0013163-007 Invoice Description: 6 vehicles,computer equipment,5 dero biker lockers Purchase Order: . Termination Date: 07/18/2022 Current Char es Deso Due Date Amount Due Tax Late Charge Total Due Renta 01/15/2016 21,205.45 21,205.45 Invoice Message PLEASE CONTACT US AT 1-866-545-1758 WE APPRECIATE YOUR BUSINESS VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201 (Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM, AL 35202-2545 Payee $12,976.78 Purchase Order# ON ACCOUNT OF APPROPRIATION FOR Dept of Community Service 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 Jan 18 44-650.01 $12,976.78 1 hereby certify that the attached invoice(s),or 1/3/18 Jan 18 Jan 2018 payment $12,976.78 1192 101 1192 101 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,January 03,2018 Mike Hollibaugh Director 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 120— Cost 20Cost distribution le�-__. _lassification if claim paid motor vehicle highway fund. Clerk-Treasut'er i SCHEDULE NO.7 TO MASTER GOVERNMENTAL LEASE AGREEMENT Dated August 9,2017 by and between City of Carmel,Indiana and s' REGIONS EQUIPMENT FINANCE CORPORATION -SCHEDULE OF PAYMENTS Principal Interest Payment Purchase Option Period Date Funding Component Component Amount Price 0 10/13/2017 $ 121,213.25 $ 121,213.25 —115618=' $ 12,118.41 858.37 $1 j� 7,7$ $ 109,094.84 2 7/15/2018 $ 11,465.27 1,511.51 $ 12,976.78 $ 97,629.57 3 1/15/2019 $ 11,624.12 1,352.66 $ 12,976.78 $ 86,005.45 4 7/15/2019 $ 1-1,785.17 1,191.61 $ 12,976.78 $ 74,220.28 5 1/15/2020 $ 11,948.46 1,028.32 $ 12,976.78 $ 62,271.82 6 7/15/2020 $ 12,114.00 862.78 $ 12,976.78 $ 50,157.82 7-. 1/15/2021 $ 12,281 84' • 694.93 $ 12,976.78 $ 37,875.98 8 7/15/2021 $ 12,45101 524.77 $ 12,976.78 $ 25,423.97 9 1/15/2022 $ 1.2,624.53 352.25 $ 12,976.78 $ 12,799.45 10 7/15/2022 $ 12,799.45 177.33 $ 12,976.78 $ - This amortization schedule is provided for iinformational purposes only. For payoff quotes contact Regions Equipment Finance Corporation at 1-866-545-1758. i i I i_ i R .I VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201 (Rev.1995) Vendor# 371726 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER REGIONS EQUIPMENT FINANCE IN SUM OF$ CITY OF CARMEL PO BOX 2545 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. BIRMINGHAM, AL 35202-2545 Payee $2,134.51 ON ACCOUNT OF APPROPRIATION FOR Purchase Order# Dept'of Community Service 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 Jan 2018 44-670.99 $2,134.51 1 hereby certify that the attached invoice(s),or 1/3/18 Jan 2018 Bike Locker Jan 2018 Lease Payment $2,134.51 1192 101 1192 101 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, January 03, 2018 Mike Hollibaugh 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 lec_ assification if claim paid motor vehicle highway fund. Clerk-Treasurer SCHEDULE NO.7 TO MASTER GOVERNMENTAL LEASE AGREEMENT Dated August 9,2017 by and between City of Carmel,Indiana and REGIONS EQUIPMENT FINANCE CORPORATION SCHEDULE OF PAYMENTS enar merit=of-'C�oi uric n ty SAY tn�e-Bike Loeker-/Persoi:.Counter Principal Interest Payment Purchase Option Period Date Fundins Component Component Amount Price 0 10/13/2017 $ 19,938.00 $ 19,938.00 $ 1,993.32 141.19 $ 62kT-4Vf1�7$ 17,944.68 2 7/15/2018 $ 1,885.89 248.62 $ 2,134.51 $ 16,058.79 3 1/15/2019 $ 1,912.02 222.49 $ 2,134.51 $ 14,146.78 4 7/15/2019 $ 1,938.51 196.00 $ 2,134.51 $ 12,208.27 5 1/15/2020 $ 1,965.37 169.15 $ 2,134.51 $ 10,242.90 6 7/15/2020 $ 11992.60 141.92 $ 2,134.51 $ 8,250.31 7 1/15/2021 $ 2,020.20 114.31 $ 2,134.51 $ 6,230.11 8 7/15/2021 $ 2,048.19 86.32 $ 2,134.51 $ 4,181.91 9 1/15/2022 $ 2,076.57 57.94 $ 2,134.51 $ 2,105.34 I 10 7/15/2022 $ 2,105.34 29.17 $ 2,134.51 $ - i This amortization schedule is provided for informational purposes only. For payoff quotes contact Regions Equipment Finance Corporation at 1-866-545-1758.