HomeMy WebLinkAboutHuntington Bank 4087000067 May 2013 THE HUNTINGTON NATIONAL BANK (�
PO OX 1
COLUMBUS,5OH 43216 INS Huntl� tan
I'I'IIIIIuI�III�IuuIhuIi IhiuiIIIII'llliIluIhhuhIi�dIIIhIhIIhI�
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 05/01/2013 TO 05/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 # 12
farm TRMAIL 07109
�� Hunhn �Gn
CITY OF CARMEL, INDIANA PAGE 1
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 05/01/2013 TO 05/31/2013
SUMMARY OF INCOME CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 04/30/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
CASH DIVIDENDS 297.76
INTEREST 6,456.71 6,754.47
DISBURSEMENTS FOR THIS PERIOD
OTHER DISBURSEMENTS 6,754.47- 6,754.47-
ENDING BALANCE THIS ACCOUNTING PERIOD 05/31/2013 $ 0.00
SUMMARY OF PRINCIPAL CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 04/30/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
SALES AND MATURITIES 1,603,212.43
FROM OTHER SOURCES 6,754.47 1,609,966.90
DISBURSEMENTS FOR THIS PERIOD
PURCHASES 1,406,754.47-
FOR OTHER PURPOSES 203,212.43- 1,609,966.90-
ENDING BALANCE THIS ACCOUNTING PERIOD 05/31/2013 $ 0.00
SUMMARY OF COST VALUE
ENDING BALANCE LAST ACCOUNTING PERIOD 04/30/2013 $ 7, 126, 161.28
ASSETS PURCHASED OR OTHERWISE ACQUIRED 1,406,754.47
IIII I II I, II 111111111111111
� i '- untie ton
CITY OF CARMEL, INDIANA PAGE 2
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 05/01/2013 TO 05/31/2013
SUMMARY OF COST VALUE
ASSETS SOLD OR OTHERWISE DISPOSED OF 1,603,212.43-
ENDING BALANCE THIS ACCOUNTING PERIOD 05/31/2013 -COST VALUE- $ 6,929,703.32
TOTAL MARKET VALUE OF ACCOUNT $ 6,929,703.32
0001189180 002 006 000 10 5 46032 20.944
A4a nnhhn03an
CITY OF CARMEL, INDIANA PAGE 3
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 05/01/2013 TO 05/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
ENDING BALANCE LAST STATEMENT $ 0.00 $ 0.00 $ 7, 126,161.28
PERIOD 04/30/2013
05/01/2013
DIVIDEND ON HUNTINGTON 297.76
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS PAYABLE
05/01/2013
TRANSFER TO PRINCIPAL ON 297.76-
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
RECEIVED FROM INCOME ON 297.76
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
DEPOSIT HUNTINGTON CONSERVATIVE 297.76- 297.76
DEPOSIT ACCOUNT - CORPORATE
TRUST PLUS FOR REINVESTMENT
IIIIIiI III I,IIII II IIIIIIrIIII, II
$ Huntington
CITY OF CARMEL, INDIANA PAGE 4
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 05/01/2013 TO 05/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
05/15/2013
INTEREST ON 1,400,000 UNITS 6,456.71
HARRIS BANK PUBLIC FUNDS CD .55%
05/10/2013 PAYABLE 05/10/2013
EFFECTIVE 05/10/2013
MATURED 1,400,000 UNITS HARRIS 1,400,000.00 • 1,400,000.00-
BANK PUBLIC FUNDS CD .55%
05/10/2013 EFFECTIVE 05/10/2013
05/16/2013
TRANSFERRED TO PRINCIPAL 6,456.71-
TRANSFERRED FROM INCOME 6,456.71
PAID TO AUBURN PLASTICS & 705.00-
RUBBER, INC. PER DISBURSEMENT
DIRECTION #15 DATED 05/15/2013,
PAYMENT PER INVOICE # 171723
PAID TO CHAPMAN ELECTRIC SUPPLY, 353.00-
INC. PER DISBURSEMENT DIRECTION
#15 DATED 05/15/2013, PAYMENT
PER INVOICE # 1074669
0001189180 003 006 000 10 5 46032 20,945
• Huntongton
CITY OF CARMEL, INDIANA PAGE 5
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 05/01/2013 TO 05/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
05/16/2013
PAID TO JONES & HENRY ENGINEERS 12,311.49-
LTD PER DISBURSEMENT DIRECTION
#15 DATED 05/15/2013, PAYMENT
PER INVOICE# 63328
PAID TO JONES & HENRY ENGINEERS 13,001.49-
LTD PER DISBURSEMENT DIRECTION
#15 DATED 05/15/2013, PAYMENT
PER INVOICE # 63330
PAID TO JONES & HENRY ENGINEERS 7,347.00-
LTD PER DISBURSEMENT DIRECTION
#15 DATED 05/15/2013, PAYMENT
PER INVOICE# 63331
PAID TO JONES & HENRY ENGINEERS 6,224.00-
LTD PER DISBURSEMENT DIRECTION
#15 DATED 05/15/2013, PAYMENT
PER INVOICE# 63332
PAID TO M.K. BETTS ENGINEERING & 3,039.30-
PER DISBURSEMENT DIRECTION #15
DATED 05/15/2013, PAYMENT PER
APPLICATION #2
11111111111011 .1 I IIII I11111
Huntongion
CITY OF CARMEL, INDIANA PAGE 6
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 05/01/2013 TO 05/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
05/16/2013
PAID TO UNITED CONSULTING PER 6,352.00-
DISBURSEMENT DIRECTION #15 DATED
05/15/2013, PAYMENT PER INVOICE
# 1390101-03
PAID TO W.T. BRYAN & ASSOCIATES, 800.00-
INC. PER DISBURSEMENT DIRECTION
#15 DATED 05/15/2013, PAYMENT
PER INVOICE #17654
PAID TO CARMEL UTILITIES PER 28,545.50-
DISBURSEMENT DIRECTION #15 DATED
05/15/2013, REIMBURSEMENT FOR
PAYROLL EXPENSES - CURT MANIFOLD
PAID TO M.K. BETTS ENGINEERING & 49,357.25-
PER DISBURSEMENT DIRECTION #15
DATED 05/15/2013, PAYMENT PER
APPLICATION #7 (106TH STREET
PUMP STATION)
PAID TO REDZONE ROBOTICS PER 75,176.40-
DISBURSEMENT DIRECTION #15 DATED
05/15/2013, PAYMENT PER INVOICE#
RZ9185
0001189180 004 006 000 10 5 46032 20,946
Huntington
CITY OF CARMEL, INDIANA PAGE 7
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 05/01/2013 TO 05/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
NET CASH MANAGEMENT BUYS FOR THE PERIOD
DEPOSIT HUNTINGTON COLLATERAL 1,406,456.71- 1,406,456.71
BACKED DEPOSIT ACCOUNT
NET CASH MANAGEMENT SELLS FOR THE PERIOD
WITHDRAWAL HUNTINGTON COLLATERAL 203,212.43 203,212.43-
BACKED DEPOSIT ACCOUNT
ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 6,929,703.32
PERIOD 05/31/2013
IIIIIl1111 II111III1IIIIIIIII
Huntington
CITY OF CARMEL, INDIANA PAGE 8
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF MAY 31, 2013
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
CERTIFICATES OF DEPOSIT-HUNTINGTON
1,400,000 HUNTINGTON NATIONAL BANK CD 1,400,000.00 100.00 1,400,000.00 20.2 9, 100 0.7
#07403011864 .65% 09/10/2013
1,000,000 HUNTINGTON NATIONAL BANK CD 1,000,000.00 100.00 1,000,000.00 14.4 7,000 0.7
#07403011877 .7% 11/08/2013
600,000 HUNTINGTON NATIONAL BANK CD 600,000.00 100.00 600,000.00 8.7 4,200 0.7
#07403011880 .7% 01/10/2014
TOTAL 3,000,000.00 3,000,000.00 20,300 0.7
CERTIFICATES OF DEPOSIT-OTHER
1,500,000 HARRIS BANK PUBLIC FUND CD .65% 1,500,000.00 100.00 1,500,000.00 21.6 9,750 0.7
07/10/2013
TOTAL 1,500,000.00 1,500,000.00 9,750 0.7
CASH MANAGEMENT FUNDS-TAXABLE
HUNTINGTON COLLATERAL BACKED 1,203,248.61 1,203,248.61 17.4 361 0.0
DEPOSIT ACCOUNT
HUNTINGTON CONSERVATIVE DEPOSIT 1,226,454.71 1,226,454.71 17.7 3,066 0.3
ACCOUNT - CORPORATE TRUST PLUS
0001189180 005 006 000 10 5 46032 20.947
• Huntington
CITY OF CARMEL, INDIANA PAGE 9
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF MAY 31, 2013
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
CASH MANAGEMENT FUNDS-TAXABLE
TOTAL 2,429,703.32 2,429,703.32 3,427 0. 1
ASSETS 6,929,703.32 6,929,703.32 100.0 33,477 0.5
CASH 0.00 0.00 0
TOTAL 6,929,703.32 6,929,703.32 33,477