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.