HomeMy WebLinkAboutHuntington 4087000067 July 2013 THE HUNTINGTON NATIONAL BANK
PO BOX 1558
COLUMBUS, OH 43216 0 d 1J A,Auld tain
CITY OF CARMEL, INDIANA
ATTN: CINDY SHEEKS
ONE CIVIC SQUARE
CARMEL IN 46032-2584
C A S H A C T I V I T Y S T A T E M E N T
ACCOUNTING PERIOD
FROM 07/01/2013 TO 07/31/2013
ACCOUNT NAME: CITY OF CARMEL. INDIANA
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER: 4087000067
TRUST ADMINISTRATOR: KIMBERLEE WILSON
TELEPHONE NUMBER: 317-229-4094
THE HUNTINGTON FUNDS ARE AFFILIATED WITH THE HUNTINGTON NATIONAL BANK. MUTUAL FUNDS, INCLUDING THE
HUNTINGTON FUNDS, ARE NOT INSURED OR GUARANTEED BY THE FEDERAL DEPOSIT INSURANCE CORPORATION OR BY
ANY OTHER GOVERNMENT AGENCY OR GOVERNMENT-SPONSORED AGENCY OF THE FEDERAL GOVERNMENT OR THE STATE.
* MARKET VALUE AND ESTIMATED INCOME FIGURES ARE NOT GUARANTEED, BUT DO COME FROM RELIABLE SOURCES.
FORMAT N 12
form TRMAIL 0)(09
untington
CITY OF CARMEL, INDIANA PAGE 1
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 07/01/2013 TO 07/31/2013
SUMMARY OF INCOME CASH ---
ENDING BALANCE LAST ACCOUNTING PERIOD 06/30/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
CASH DIVIDENDS 275.74
INTEREST 30,363.60 30,639.34
DISBURSEMENTS FOR THIS PERIOD
OTHER DISBURSEMENTS 30,639.34- 30,639.34-
ENDING BALANCE THIS ACCOUNTING PERIOD 07/31/2013 $ 0.00
SUMMARY OF PRINCIPAL CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 06/30/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
SALES AND MATURITIES 2,043,232.85
FROM OTHER SOURCES 30,639.34 2,073,872. 19
DISBURSEMENTS FOR THIS PERIOD
PURCHASES 1,530,639.34-
FOR OTHER PURPOSES 543,232.85- 2,073,872. 19-
ENDING BALANCE THIS ACCOUNTING PERIOD 07/31/2013 $ 0.00
SUMMARY OF COST VALUE
ENDING BALANCE LAST ACCOUNTING PERIOD 06/30/2013 $ 6,626, 119.40
ASSETS PURCHASED OR OTHERWISE ACQUIRED 1,530,639.34
IIII III IIIIIIII 1 1E11 IIII,l
Huntington
CITY OF CARMEL, INDIANA PAGE 2
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 07/01/2013 TO 07/31/2013
SUMMARY OF COST VALUE
ASSETS SOLD OR OTHERWISE DISPOSED OF 2,043,232.85-
ENDING BALANCE THIS ACCOUNTING PERIOD 07/31/2013 -COST VALUE- $ 6,113,525.89
TOTAL MARKET VALUE OF ACCOUNT $ 6, 113,525.89
0001205239 002 009 000 20 5 46032 19,616
Ii ors®
CITY OF CARMEL, INDIANA PAGE 3
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
ENDING BALANCE LAST STATEMENT $ 0.00 $ 0.00 $ 6,626, 119.40
PERIOD 06/30/2013
07/01/2013
DIVIDEND ON HUNTINGTON 23.68
COLLATERAL BACKED DEPOSIT
ACCOUNT PAYABLE 07/01/2013
DIVIDEND ON HUNTINGTON 252.06
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS PAYABLE
07/01/2013
TRANSFER TO PRINCIPAL ON 252.06-
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
RECEIVED FROM INCOME ON 252.06
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
DEPOSIT HUNTINGTON CONSERVATIVE 252.06- 252.06
DEPOSIT ACCOUNT - CORPORATE
TRUST PLUS FOR REINVESTMENT
EMI! I 1111111111011
IN�I Huntington
CITY OF CARMEL, INDIANA PAGE 4
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/02/2013
TRANSFERRED TO PRINCIPAL 23.68-
TRANSFERRED FROM INCOME 23.68
07/03/2013
PAID TO GRAYBAR PAYEMNT PER 1,539.54-
EXHIBIT B, DISBURSEMENT
DIRECTION #17, DATED 7/3/13.
INVOICE #966787402
PAID TO GRAYBAR PAYEMNT PER 6,314.31-
EXHIBIT B, DISBURSEMENT
DIRECTION #17, DATED 7/3/13.
INVOICE #966741563
PAID TO GRAYBAR PAYEMNT PER 6,322.83-
EXHIBIT B, DISBURSEMENT
DIRECTION #17, DATED 7/3/13.
INVOICE #966773216
PAID TO GRAYBAR PAYEMNT PER 636.02-
EXHIBIT B, DISBURSEMENT
DIRECTION #17, DATED 7/3/13.
INVOICE #967029817
0001205239 003 009 000 20 5 46032 19,617
CITY OF CARMEL, INDIANA PAGE 5
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/03/2013
PAID TO JDH CONTRACTING, INC. 84,251.45-
PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #44269
PAID TO JONES & HENRY ENGINEERS, 16,524. 18-
LTD. PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #63508
PAID TO JONES & HENRY ENGINEERS, 29,262.90-
LTD. PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #63505
PAID TO JONES & HENRY ENGINEERS, 4,242.00-
LTD. PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #63506
PAID TO JONES & HENRY ENGINEERS, 12,691.75-
LTD PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #63507
II III 1111111 1111IiH II i
10 Huntington
CITY OF CARMEL, INDIANA PAGE 6
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/03/2013
PAID TO KIRBY RISK CORPORATION 2,097.88-
PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #
5106844149.001
PAID TO M.K. BETTS ENGINEERING 139,255.75-
PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #12-238.09
PAID TO M.K. BETTS ENGINEERING 50, 145.30-
PAYEMNT PER EXHIBIT B,
DISBURSEMENT DIRECTION #17,
DATED 7/3/13. INVOICE #13-124.03
0001205239 004 009 000 20 5 46032 19,618
1041 t !
CITY OF CARMEL, INDIANA PAGE 7
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/10/2013
INTEREST ON 1,500,000 UNITS 9,781.67
HARRIS BANK PUBLIC FUND CD .65%
07/10/2013 PAYABLE 07/10/2013
MATURED 1,500,000 UNITS HARRIS 1,500,000.00 1,500,000.00-
BANK PUBLIC FUND CD .65%
07/10/2013
07/11/2013
TRANSFERRED TO PRINCIPAL 9,781.67-
TRANSFERRED FROM INCOME 9,781.67
07/18/2013
INTEREST ON 1,400,000 UNITS 9,226.38
HUNTINGTON NATIONAL BANK CD
#07403011864 .65% 09/10/2013
PAYABLE 07/11/2013
PURCHASED 9,226.38 UNITS 9,226.38- 9,226.38
HUNTINGTON NATIONAL BANK CD
#07403011864 .65% 09/10/2013 ON
07/11/2013 AT 100.00
111111111111111E1E
Huntington
CITY OF CARMEL, INDIANA PAGE 8
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/18/2013
INTEREST ON 1,000,000 UNITS 7,097.22
HUNTINGTON NATIONAL BANK CD
#07403011877 .7% 11/08/2013
PAYABLE 07/11/2013
PURCHASED 7,097.22 UNITS 7,097.22- 7,097.22
HUNTINGTON NATIONAL BANK CD
#07403011877 .7% 11/08/2013 ON
07/11/2013 AT 100.00
INTEREST ON 600,000 UNITS 4,258.33
HUNTINGTON NATIONAL BANK CD
#07403011880 .7% 01/10/2014
PAYABLE 07/11/2013
PURCHASED 4,258.33 UNITS 4,258.33- 4,258.33
HUNTINGTON NATIONAL BANK CD
#07403011880 .7% 01/10/2014 ON
07/11/2013 AT 100.00
0001205239 005 009 000 20 5 46032 19,619
101 11,tr
CITY OF CARMEL, INDIANA PAGE 9
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/19/2013
TRANSFERRED TO PRINCIPAL 20,581.93-
TRANSFERRED FROM INCOME 20,581.93
07/31/2013
PAID TO CARMEL UTILITIES PAYMENT 11,206.77-
PER EXHIBIT B, DISBURSEMENT
DIRECTION #18, DATED 7/30/13.
PAID TO JONES & HENRY ENGINEERS, 4,662.00-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #63563
PAID TO JONES & HENRY ENGINEERS, 13,427.80-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #63565
PAID TO JONES & HENRY ENGINEERS, 12, 165.00-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #63564
If H�iII� I1I Iii1111011E1
INS Huntington
CITY OF CARMEL, INDIANA PAGE 10
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/31/2013
PAID TO JONES & HENRY ENGINEERS, 17,529.12-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #63561
PAID TO JONES & HENRY ENGINEERS, 687.85-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #63504
PAID TO M. K. BETTS ENGINEERING 108,939.60-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #
13-124.04
PAID TO OGLETREE DEAKINS PAYMENT 714.00-
PER EXHIBIT B, DISBURSEMENT
DIRECTION #18, DATED 7/30/13.
INVOICE #1112906
PAID TO SEILER INSTRUMENT & MFG. 9,593.00-
CO. INC. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #296364
ORDER # CO-273733
0001205239 006 009 000 20 5 46032 19,620
unto ',df
CITY OF CARMEL, INDIANA PAGE 11
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
07/31/2013
PAID TO UNITED CONSULTING 4,328.80--
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE
#1390101-06
PAID TO WAVELENGTH FIBER OPTICS 3,900.00-
LLC PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. QUOTE# 131105
PAID TO SEILER INSTRUMENT & MFG. 2,795.00-
CO. INC. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #18,
DATED 7/30/13. INVOICE #296920
ORDER # CO-274362
II 1111 II III III IN IIII
• Huntingt®n
CITY OF CARMEL, INDIANA PAGE 12
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 07/01/2013 TO 07/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
NET CASH MANAGEMENT BUYS FOR THE PERIOD
DEPOSIT HUNTINGTON COLLATERAL 1,509,805.35- 1,509,805.35
BACKED DEPOSIT ACCOUNT
NET CASH MANAGEMENT SELLS FOR THE PERIOD
WITHDRAWAL HUNTINGTON COLLATERAL 543,232.85 543,232.85-
BACKED DEPOSIT ACCOUNT
ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 6, 113,525.89
PERIOD 07/31/2013
0001205239 007 009 000 20 5 46032 19,621
untongton
CITY OF CARMEL, INDIANA PAGE 13
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF JULY 31, 2013
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
CERTIFICATES OF DEPOSIT-HUNTINGTON
1,409,226.38 HUNTINGTON NATIONAL BANK CD 1,409,226.38 100.00 1,409,226.38 23. 1 9, 160 0.6
#07403011864 .65% 09/10/2013
1,007,097.22 HUNTINGTON NATIONAL BANK CD 1,007,097.22 100.00 1,007,097.22 16.5 7,050 0.7
#07403011877 .7% 11/08/2013
604,258.33 HUNTINGTON NATIONAL BANK CD 604,258.33 100.00 604,258.33 9.9 4,230 0.7
#07403011880 .7% 01/10/2014
TOTAL 3,020,581.93 3,020,581.93 20,439 0.7
CASH MANAGEMENT FUNDS-TAXABLE
HUNTINGTON COLLATERAL BACKED 1,865,976.78 1,865,976.78 30.5 560 0.0
DEPOSIT ACCOUNT
HUNTINGTON CONSERVATIVE DEPOSIT 1,226,967. 18 1,226,967. 18 20.1 3,067 0.3
ACCOUNT - CORPORATE TRUST PLUS
TOTAL 3,092,943.96 3,092,943.96 3,627 0.1
ASSETS 6, 113,525.89 6, 113,525.89 100.0 24,067 0.4
CASH 0.00 0.00 0
III II III III II I II I I I I H I I H
1 Huntington
CITY OF CARMEL, INDIANA PAGE 14
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF JULY 31, 2013
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
TOTAL 6, 113,525.89 6,113,525.89 24,067
0001205239 008 009 000 20 5 46032 19,622