319990 12/21/17 �...._.+�° CITY OF CARMEL, INDIANA VENDOR: 361405 �✓
g 6 `il ONE CIVIC SQUARE REGIONS BANK CHECK AMOUNT: $****88,388.75*
CARMEL, INDIANA 46032 CHECK NUMBER: 319990
SZp'l.�iS�sCHECK DATE: 12/21/17
DEPARTMENT ACCOUNT _ PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION
1110 4352600 820258 58,772.00 AUTOMOBILE LEASE
1110 4353099 820258 15,497.02 OTHER RENTAL & LEASES
1110 4353099 820259 14,119.73 OTHER RENTAL & LEASES
VOUCHER NO. WARRANT NO. Prescribed by State Board of Accounts City Form No.201(Rev.1995)
ALLOWED 20
Vendor# 361405 ACCOUNTS PAYABLE VOUCHER
REGIONS BANK IN SUM OF$ CITY OF CARMEL
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
Payee
$58,772.00
Purchase Order#
ON ACCOUNT OF APPROPRIATION FOR
Carmel Police 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 43-526.00 $58,772.00 1 hereby certify that the attached invoice(s),or 12/1/17 820258 lease payment $58,772.00
1110 101 1110 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
` s Wednesday, December 13,2017
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
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# 361405 ALLOWED 20 ACCOUNTS PAYABLE VOUCHER
REGIONS BANK IN SUM OF$ CITY OF CARMEL
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
Payee
$29,616.75
ON ACCOUNT OF APPROPRIATION FOR Purchase Order#
Carmel Police Terms
Date Due
PO# ACCT# DATE INVOICE# DESCRIPTION
DEPT# INVOICE# Fund# AMOUNT Board Members DEPT# FUND# (or note attached invoice(s)or bill(s)) AMOUNT
820259 43-530.99 $14,119.73 1 hereby certify that the attached invoice(s),or 12/1/17 820259 lease payment $14,119.73
1110 101 1110 101
820258 43-530.99 $15,497.02 bill(s)is(are)true and correct and that the 12/1/17 820258 lease payment $15,497.02
1110 1 101 1 materials or services itemized thereon for 1110 1 101
which charge is made were ordered and
received except
` Wednesday, December 13,2017
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
Cost distribution ledger classification if claim paid motor vehicle highway fund. Clerk-Treasurer
t11 i v
REGIONS EQUIPMENT FINANCE
P.O.BOX 2545
BIRMINGHAM,AL 35202.2545
Page Number 1 of 2
Invoice Date 12/01/2017
Invoice Number 4www858
0000090 01 SP OA60 001 Invoice Due Date 01/15/2018
Attn: LINDA HARVEY Total Current Due 166,723.77
CITY OF CARMEL INDIANA Total Amt 166,723.77
ONE CIVIC SOME Total Tax 0.00
CARMEL IN 46032-2584 Total Late Charges 0.00
Total Amount Due 166,723.77
051-0013163002 Invoice Description: (18)2016113 FORD EXPLORER POLICE AWD 4DR
Purchase Order:
Z Termination Date: 01/16/2021
Contract Activit
From Date To Date #of Das Int Rate Int Accrual Int P mt 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 1 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
i,
`5 N S REGIONS EQUIPMENT FINANCE
P.O.BOX 2545
BIRMINGHAM,&35202-2545
Page Number 1 of 2
Invoice Date 12/01/2017
Invoice Number 01082G23�
;�' 0000091 01 SP o.4so 001 Invoice Due Date 01/15/2018
'$ Attn: LINDA HARVEY Total Current Due 136,082.57
CITY OF CARMEL, INDIANA TotalAmt 136,082.57
ONE CIVIC SQUARE Total Tax 0.00
CARMEL IN 46032-2584 Total Late Charges 0.00
Total Amount Due 136,082.57
051-0013163--gem
In oice Description:
SPRING REWIND NOSE MOUNTED
WED BREATHING AIR COMPRESSOR;
Sc� Purchase Order:
Termination Date: 02/15/2022
Contract Activi
From Date To Date #of Das Int Rate Int Accrual Int P mt Payment. Prin Bal Accrual Type
04/30/2017 05/31/2017 31 1.72 1,916.56 0.00 0.00 1,294,000.00 Monthend
05/31/2017 06/30/2017 30 1.72 1,854.73 0.00 0.00 1,294,000.00 Monthend
06/30/2017 07/11/2017 - 10 1.72 618.24 0.00 -54.90 1,293,945.10 Payment
07/11/2017 07/15/2017 4 1.72 247.29 -14,961.50 -121,121.07 1,172,824.03 Payment
07/15/2017 07/15/2017 0 1.72 0.00 0.00 0.00 1,172,824.03 Invoicing
07/15/2017 07/31/2017 17 1.72 952.59 0.00 0.00 1,172,824.03 Monthend
07/31/2017 08/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend
08/31/2017 09/30/2017 30 1.72 1,681.05 0.00 0.00 1,172,824.03 Monthend
09/30/2017 10/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend
10/31/2017 11/30/2017 30 1.72 1,681.05 0.00 0.00 1,172,824.03 Monthend
11/30/2017 12/31/2017 31 1.72 1,737.08 0.00 0.00 1,172,824.03 Monthend
12/31/2017 01/15/2018 14 1.72 784.49 0.00 0.00 1,172,824.03 Invoicing
Current Char es
Desc Due Date Amount Due Tax Late Charge Total Due
Principa 1.663
Fixed Pymt) 01/15/2018 125,771.63 125,770
Interest 01/15/2018 10,310.94 10 310.94
LOAN' .A,MORTIZA,TI.ON
S.hnrdorlem 3 Ra.r6carl P_nlir.Q
Interest.calculations..........:.......................Actual/MG
Average life.....................................................2.609 years
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/1 /2018 - Q 4,016.93 70,252.09 433,543.37
7/15/2018 - 74,269.02 3,400.43 701868: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,7.48:66 72,520.36 146;792'.84
7/15/.2020 - 74,269.02 1,157.71 73,111.31 73,681:53
1/15/2021 - 74,269.02 587.49 73,681.53 0.00
TOTAL 64.1,910.00 668,421.17 26,511.17 641,910.00
LO'.A.N AMORTIZATL'O'N
Police``::
c � 3.
360/365/actual day calculations.......Actual/360
Average life:.......2.962 years.
Interest rate...........1.72000000%
debt. ending
date. takedowns service 'interest principal balance
0.103758539
11/14/2016 134,263:55 - - - 134,263.55
7/15%2017 - 14,119.73 1,558.80 12;560:93 121,702;62
- Wj%.L'119.Wk3ff 1,069:90 13,049.83 1081652.79
7/1512018 - 14,11933 939:61 13,180:12 95,472.67
1/15/2019 - 14,119.73 839.31 13,280.42 82,192.25
7/15/2019 - 14,119.73. 710.78 13,408:95 68,783.30
1/15/2020 - 14,119.73 604:68 -'13;815.05 55,268.26
7/15/2020 - 14,119.73 480.59 13,639:14' - 41,629.11
= 1/15/2021 - 14,119.73 365.97 13;753.76'- 27,875.35
7/15/2021- - 14,119.73 241.06 -13,878.67 13,996.68
1/15/2022 - 14,119.73 123.05 13,996.68 0.00
TOTAL 134,263'.55 141,197.29., 6,933.74 1341263.55