The URL can be used to link to this page

Home My WebLink About319990 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