HomeMy WebLinkAbout320386 01/05/2018 '-L4q
CITY OF CARMEL, INDIANA VENDOR: 371726
y
�b ONE CIVIC SQUARE REGIONS EQUIPMENT FINANCE CHECK AMOUNT: $****27,719.96*
CARMEL, INDIANA 46032 PO BOX 2545 CHECK NUMBER: '320386
9yiroN-`0,r BIRMINGHAM AL 35202-2545 CHECK DATE: 01/05/18
DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION.
1115 4463201 820257 12,907.70 HARDWARE
1115 4463201 821355 12,453.00 HARDWARE
1115 4465001 821356 2,359.26 CARS & TRUCKS
Prescribed by State Board of Accounts City Form No.201 (Rev.1995)
VOUCHER NO. WARRANT NO.
ALLOWED 20 ACCOUNTS PAYABLE VOUCHER
Vendor# -361485 "3 '7[
REGIONS 5��VP Jf1 IN SUM oI $ CITY OF CARMEL
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.
INinlA LAR_o r��
Payee
$27,719.96
Purchase Order#
ON ACCOUNT OF'APPROPRIATION FOR
ICS 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
820257 44-63201 $12,907.70 1 hereby certify that the attached invoice(s),or 12/1/17 820257 $12,907.70
1115 101 Prior Year 1115 101
821356 44-650.01 $2,359.26 bill(s)is(are)true and correct and that the 12/10/17 821356 $2,359.26
1115 101 1 Prior Year materials or services itemized thereon for 1115 1 101
821355 I 44-632.01 I $12,453.00 12/10/17 I 821355 I I $12,453.00
1115 101 Prior Year which charge is made were ordered and 1115 101
received except
:Thursday, December.21,2017
Renick,Timothy
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
--
120-
Cost
20Cost distribution ledger classification if claim paid motor vehicle highway fund.
Clerk-Treasurer
it
j�
�T I
A . U I O S REGIONS EQUIPMENT FINANCE
P.O.;Box 2545
BIRMINGHAM;AL 35202-2545
Page Number 1.of .2
Invoice Date - 12/10%2017
Invoice Number 821356
0000225 01 SR `0.460 001 Invoice Due Date 01/15/2018
Attn: - LINDA HARVEY Total Current Due 91,204.83
,CITY OF CARMEL INDIANA Total Amt 91,204.83
ONE CIVIC SOUAAE Total Tax 0.00
CARMEL IN '46032-2584 Total Late Charges 0;00:
Total Amount Due 91,204.83
051-001.3163--005 Invoice Description: ONE 1 FORD EXPLORER, MOBILE DATA COMPUTERS.WITH_MOUNTS FOR TH
POLICE DEPARTMENT, EMERGENCY OPERAT
Purchase Order:,
Termination Date: 02/15/2022
.Contract Activit
Froin Date To.Date #.of Days. Int Rate:: Int Accrual Int Pymt Payment ;P.rin Bal Accrual Type
:05/15/2017. 05/31`/2017 17 2.14 875.33 0.00_ 0.00 866,187.04 Monthend
05/31/2017: 06/30/2017 30 12.14 1',544.70- 0.00 0.00 866,187.04 Monthend
06/30/2017 07/15/2011 14 2.-14 720.86 - -3,707.28 -87,497.55 778,689.49 Payment
07/15/2017 07/15/2017 . 0 2.1.4 0.00 0.00 0.00 778,689:49 Invoicing
07/15/2017 -07/31'/2017 17 2.14 786.91 0.00 0.00 778,689.49 Monthend
07/31/2017 '08/31/2017 31. 2.1.4 1,434.95 0.00 . 0.0.0 778;689:49 Monthend
08/31/2017 09/30/2017 30 2.14 1,388.66 0.00 0.00. 778,689.49 Monthend
09[30/2017 10/31/2017 31 2.14 1,434.95 0.00 0.00 . 778,689.49 Monthend,
10/31/2017 11/30/2017 . 30 2.14. 1388.66 . .0.00 0,00 778,689.49 Monthend
11130/2017 12/31%20.17. 31: 214:.. 1;434.95 0.00 0.00 :: 770,689.49 Monthend
12/3112017 01/15/2018 14 2:14 648.04 0.00 0.00 778,689.49 : In
Current:Char es
Desc Due Date -. Amount Due Tax Late Charge ' Total Due
rincipa- Fixe. Pymt : 01/15/2019 82,687.65 82, ..65
Interest 01/i 5/2018 8,517.18 17.18:
��5
AM& E G"I1`V S . REGIONS EQUIPMENT FINANCE
P.O.BOX 2545 ,
BIRMINGHAM,AL 35202-2545
Page Number '1 of 2 .
. ...I. . .I. I !III ..L. II Invoice Date 12/10/2017..
II�_III�.II I I IIII I IIIII III. I I I I. I III II 1 Invoice Number 821355
1:000 1 2601 SP •0:460001-_.
Invoice Due'Date 01/15/2018
Attn
LINDA HARVEY Total Current Due 1;22,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-0.013163-004 Evoke D scription.FORD F-250 A SECURITY'AV EQUIPMENT; HANDICAP LIFT, NUTAN
Purchase Order:
Termination Date; 91/16/2022
Contract=Activit
From bate 'To Date #:of.Days: -_ Int-Rate Int Accrual Int Pynit Pa ment Prin Bal AccrualType
05/31/2011 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:1.4 959.55 40;143:83 111,914.36 1,041,085.64 Payment.
-07/15/2017 '0711.5/2017 0 2.14 0:00 0.00 0.00 1,041;085.64 -Invoicing-
07/1501_7
Invoicin
07/15/2017 07/31/2017 17 2;14 1,052.07 0.00.. 0.00 1,041,085.64 Monthend
- 07/31/2017 08/31/2017 : : 3-1 2.14: 1;91:8:49 0:00.. 0.00 1,041;085.64 : . Monthend
08/31/2017 09/30/2017 30: 2:14 1;856.60 OA0 0:00- 1,041,,085.64 Monthend
09130/201.7 . 10/3112017. 31 2:14 1:918.49:. 0.00 0.00 : 1,041,085.64 Monthend
10/31/201.7 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 190411085.64 Monthend
12/31/2017 01/15/2018 14 2.14. 866:41 9.90 0.00 1,041,085.64. Invoicing
Current Char es _ .
Desc Due Date Amount Due Tax Late Charge Total Due
Principal(Fixed-Pymt) 01/.15/2018 110,67.103 110 .03
Interest 0.171512018. 11 387:16 . 41;387:16
5
3.
17-
Schedule 4 -information Systems
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 117,635.00
" 15 ,...,,.. 1M =11R Ms � p 0F 941932.76.
_
07/15/18 11,431.58 22,722:73 1,021.42- 2;183.27 12;453.00 24,906:00 83,5.01.18
01/15/19. 11,539:69.. 913:32 12,453..01: „ 71,9.61.49,
07/15/19- 11,67834 23,218:43 774.27 1,687.59 12,453.01 24,906.02 60;282.76
01/15120 11,793.65 659.36. 12,453c01 48,489_;10
07/15/20 11,928:41' 23,722.06 524:60 .1;183.96 12,453.01 24;906.02 36;560.69
01/15/21 12,053:11: 399.89 12,453.00" 24,507.58
07/15/21 121189:32 24,242.43 263.69 663.58 12;453.01 24,906.01 12,318.26
01/15/22 121:31827 12,,318':27 134.73. 134.73 . 12,453.00. 12,453.00' ..
Totals $ 117,635:00 $ 6,895.05 $ 124,530.05 ..
Lease Schedule,#4 Information Systems
Description::
IS,Hardware
Security Camera:DVRs-3
fi
y
I
€# !< t I i
�1..5
REGIONS EQUIPMENT FINANCE
P.O.BOX 2545
BIRMINGHAM,AL 35202.2545
Page Number 1 of 2
I. rr r II. I I III I I Il��lr Invoice Date 12/01/2017
Invoice Number 820257
t ; Invoice Due Date 01/15/2018
0000s2 of SP o.4so oot Attn: LINDA HARVEY Total Current Due 12,907.70
CITYOF CARMELINDIANA Total Amt 12,907.70
CITY ,
ONE CIVIC SQUARE Total Tax 0.00
CARMEL IN 46032-2584 Total Late Charges 0.00
Total Amount Due 12,907.70
c
051-0013163-001 Invoice Description: MIRAZON AND MATRIX HARDWARE
Purchase Order:
Termination Date: 02/15/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.65 141.31 0.00 0.00 99,458.99 Monthend
05/31/2017 06/30/2017 30 1.65 136.76 0.00 0.00 99,458.99 Monthend
06/30/2017 07/15/2017 14 1.65 63.82 -838.78 -12,068.92 87,390.07 Payment
07/15/2017 07/15/2017 0 1.65 0.00 0.00 0.00 87,390.07 Invoicing
07/15/2017 07/31/2017 17 1.65 68.09 0.00 0.00 87,390.07 Monthend
07/31/2017 08/31/2017 31 1.65 124.17 0.00 0.00 87,390.07 Monthend
08/31/2017 09/30/2017 30 1.65 120.16 0.00 0.00 87,390.07 Monthend
09/30/2017 10/31/2017 31 1.65 124.17 0.00 0.00 87,390.07 Monthend
10/31/2017 11/30/2017 30 1.65 120.16 0.00 0.00 87,390.07 Monthend
11/30/2017 12/31/2017 31 1.65 124.17 0.00 0.00 87;390.07 Monthend
12/31/2017 01/15/2018 14 1.65 56.08 0.00 0.00 87,390.07 Invoicing
Current Char es
Desc Due Date Amount Due Tax Late Charge Total Due
Principal(Fixed Pymt) 01/15/2018 12,170.62 12,170.62
Interest 01/15/2018 737.08 737.08
i
REGIONS
Please Detach and Return with Payment
EQUIPMENT FINANCE CORPORATION Equipment Finance Payment
A/R Name CITY OF CARMEL, INDIANA
Contract Number 051-0013163-001
REGIONS CAPITAL ADVANTAGE, INC
WIRE INSTRUCTIONS Invoice Due Date 01/15/2018
ABA#062000019 Invoice Number 820257
ACCOUNT#0107024142 Total Amount Due 12,907.70
RE ION BAN
I�I I III I II III I� II��II I� II Amount Enclosed `)D`7.70
Schedule 5 -Information Systems
Annual Annual Annual Option
Payment Principal Principa[ Interest 7interesi Total „Payment 'Principal Purchase
Due Date Payment Total. Payment Total Payment Total Balance Price
02/16/17 22,406.28.
_ 21680 .:-: �. 2159'26T 17,998.93
07/15/18 2,168.68 4,311:14 190.58 407.38 2;359.26: 4;718.52 15,830:25
01/15/19. 2,188.86. 170:40: 2,359:27 13,641.39
07/15/19 2`,214.82 4,403.68 144.44 814.84 2,359.26 4,718.53 11;426.58.
01/15/20 2,236.26 123.00 2;359.26 9,19031
07/15/20 2,261.41 4,497.67 97.85 220.85 21359.26 4,718.52 6,928.90
01/15/21 2,284.68 74:58, 2,359.26. 4,644.22
07/15/21 2,310.09 4,59437 '49.18 123.76- .2,359.27 4,718.53' 2,334.13
01/15/22 2,334:14 2,334:14•. 25.12 25:12: 2;359.26 2,359.26; -
Totals $ 22,406.28 $ 1,186.33 $. :.23,592.61:
Lease Schedule.#5-Information Systems
Description:
Ford Explorer
A.
:.. ..