HomeMy WebLinkAboutHuntington 4087000607 Nov 2013 THE HUNTINGTON NATIONAL BANK
PO BOX 1558
COLUMBUS, OH 43216 Huntington
I'I'11111"I11111111111111I111111111'II1111111111I1id11111111111
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 11/01/2013 TO 11/30/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 1f 12
form TPMAII.07109
01 01 Htun�i i n
CITY OF CARMEL, INDIANA PAGE 1
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 11/01/2013 TO 11/30/2013
SUMMARY OF INCOME CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 10/31/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
CASH DIVIDENDS 796.96
INTEREST 2,349.89 3,146.85
DISBURSEMENTS FOR THIS PERIOD
OTHER DISBURSEMENTS 3, 146.85- 3, 146.85-
ENDING BALANCE THIS ACCOUNTING PERIOD 11/30/2013 $ 0.00
---SUMMARY OF PRINCIPAL CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 10/31/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
SALES AND MATURITIES 2,235,517.04
FROM OTHER SOURCES 3, 146.85 2,238,663.89
DISBURSEMENTS FOR THIS PERIOD
PURCHASES 1,835,304.07-
FOR OTHER PURPOSES 403,359.82- 2,238,663.89-
ENDING BALANCE THIS ACCOUNTING PERIOD 11/30/2013 $ 0.00
SUMMARY OF COST VALUE
ENDING BALANCE LAST ACCOUNTING PERIOD 10/31/2013 $ 4,905,445.80
ASSETS PURCHASED OR OTHERWISE ACQUIRED 1,835,304.07
II Mall IIIIIIIIIIIIIIII
Sl Huntington
CITY OF CARMEL, INDIANA PAGE 2
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 11/01/2013 TO 11/30/2013
SUMMARY OF COST VALUE
ASSETS SOLD OR OTHERWISE DISPOSED OF 2,235,517.04-
ENDING BALANCE THIS ACCOUNTING PERIOD 11/30/2013 -COST VALUE- $ 4,505,232.83
TOTAL MARKET VALUE OF ACCOUNT $ 4,505,232.83
0001232638 002 007 000 10 5 46032 19,166
1001 Huntington
CITY OF CARMEL, INDIANA PAGE 3
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
ENDING BALANCE LAST STATEMENT $ 0.00 $ 0.00 $ 4,905,445.80
PERIOD 10/31/2013
11/01/2013
DIVIDEND ON HUNTINGTON 20.86
COLLATERAL BACKED DEPOSIT
ACCOUNT PAYABLE 11/01/2013
DIVIDEND ON HUNTINGTON 776. 10
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS PAYABLE
11/01/2013
TRANSFER TO PRINCIPAL ON 776. 10-
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
RECEIVED FROM INCOME ON 776.10
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
DEPOSIT HUNTINGTON CONSERVATIVE 776. 10- 776.10
DEPOSIT ACCOUNT - CORPORATE
TRUST PLUS FOR REINVESTMENT
11 11111111111111111111111111
ell' am
CITY OF CARMEL, INDIANA PAGE 4
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
11/04/2013
TRANSFERRED TO PRINCIPAL 20.86-
TRANSFERRED FROM INCOME 20.86
11/07/2013
PURCHASED HUNTINGTON 825,060.00- 825,060.00
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS ON
11/07/2013
11/08/2013
INTEREST ON 1,007,097.22 UNITS 2,349.89
HUNTINGTON NATIONAL BANK CD
#07403011877 .7% 11/08/2013
PAYABLE 11/08/2013
MATURED 1,007,097.22 UNITS 1,007,097.22 1,007,097.22-
HUNTINGTON NATIONAL BANK CD
#07403011877 .7% 11/08/2013
0001232638 003 007 000 10 5 46032 19.167
IN�h Huntingt®n
CITY OF CARMEL, INDIANA PAGE 5
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
11/12/2013
TRANSFERRED TO PRINCIPAL 2,349.89-
TRANSFERRED FROM INCOME 2,349.89
11/13/2013
PAID TO ANDRITZ SEPARATION INC. 27,907.30-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #
8480039788
PAID TO JONES & HENRY ENGINEERS, 3,945.97-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #63808
PROJECT # 00451-6714
PAID TO JONES & HENRY ENGINEERS, 3,491.50-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #63878
PROJECT # 00451-6770 SEWER REHAB
IIIIIIIIIIIIIIII IIIII1II11II111III I
• Huntington
CITY OF CARMEL, INDIANA PAGE 6
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
11/13/2013
PAID TO JONES & HENRY ENGINEERS, 23,761.00-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #63877
PROJECT # 00451-6733 106TH ST
PAID TO JONES & HENRY ENGINEERS, 797.99-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #63876
PROJECT # 00451-6714 106TH ST
PAID TO JONES & HENRY ENGINEERS, 14,560.94-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #63874
PROJECT # 00451-6531 WWIP
PAID TO MK BETTS ENGINEERING 252,412.43-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. APPLICATION #7
INVOICE # 13-124.07
0001232638 004 007 000 10 5 46032 19,168
• Huntington
CITY OF CARMEL, INDIANA PAGE 7
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
11/13/2013
PAID TO RED ZONE ROBOTICS, INC. 26,715.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #
RZ9308
PAID TO TPI UTILITY CONSTRUCTION 24,750.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE # TPI
356
PAID TO UNITED CONSULTING 562.50-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. PROJECT#13-901
INVOICE # 1390101-09
PAID TO CULY CONTRACTING, INC 5, 115.25-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #
0000001369
PAID TO CULY CONTRACTING PAYMENT 10,784.94-
PER EXHIBIT B, DISBURSEMENT
DIRECTION #22, DATED 11/12/2013.
INVOICE # 0000001372
11 111 IiIIII011IIII lH IIII
CITY OF CARMEL, INDIANA PAGE 8
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
11/13/2013
PAID TO CULY CONTRACTING, INC 3,405.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE #
0000001373
PAID TO GRAVELIE EXCAVATING, 5, 150.00-
INC. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #22,
DATED 11/12/2013. INVOICE DATED
09/16/2013
NET CASH MANAGEMENT BUYS FOR THE PERIOD
DEPOSIT HUNTINGTON COLLATERAL 1,009,467.97- 1,009,467.97
BACKED DEPOSIT ACCOUNT
0001232638 005 007 000 10 5 46032 19.169
• Huntington
CITY OF CARMEL, INDIANA PAGE 9
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 11/01/2013 TO 11/30/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
NET CASH MANAGEMENT SELLS FOR THE PERIOD
SOLD HUNTINGTON COLLATERAL 825,060.00 825,060.00-
BACKED DEPOSIT ACCOUNT
WITHDRAWAL HUNTINGTON COLLATERAL 403,359.82 403,359.82-
BACKED DEPOSIT ACCOUNT
ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 4,505,232.83
PERIOD 11/30/2013
IIIIIf11III11I1111111E111 11111111
CITY OF CARMEL, INDIANA PAGE 10
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF NOVEMBER 30, 2013
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
CERTIFICATES OF DEPOSIT-HUNTINGTON
604,258.33 HUNTINGTON NATIONAL. BANK CD 604,258.33 100.00 604,258.33 13.4 4,230 0.7
#07403011880 .7% 01/10/2014
TOTAL 604,258.33 604,258.33 4,230 0.7
CASH MANAGEMENT FUNDS-TAXABLE
HUNTINGTON COLLATERAL BACKED 606,087.59 606,087.59 13.5 182 0.0
DEPOSIT ACCOUNT
HUNTINGTON CONSERVATIVE DEPOSIT 3,294,886.91 3,294,886.91 73. 1 11,532 0.3
ACCOUNT - CORPORATE TRUST PLUS
TOTAL 3,900,974.50 3,900,974.50 11,714 0.3
ASSETS 4,505,232.83 4,505,232.83 100.0 15,944 0.4
CASH 0.00 0.00 0
TOTAL 4,505,232.83 4,505,232.83 15,944
0001232638 006 007 000 10 5 46032 19,170