HomeMy WebLinkAboutHuntington Bank 4087000067 Dec 2013 THE HUNTINGTON NATIONAL BANK
PO BOX 155E
COLUMBUS, OH 432/6 I �I illaintErngt®a1
I'I'1l1II1III16 11110111111111i'Iplil'Ii"I!1IiIi1t 111I11I
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 12/01/2013 TO 12/31/2013
ACCOUNT NAME : CITY OF CARMEL, INDIANA
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTI:ON 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 H 12
lean rvmm 0770;
GP Huntington
CITY OF CARMEL, INDIANA PAGE 1
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 12/01/2013 TO 12/31/2013
SUMMARY OF INCOME CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 11/30/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
CASH DIVIDENDS 917.55 917.55
DISBURSEMENTS FOR THIS PERIOD
OTHER DISBURSEMENTS 917.55- 917.55-
ENDING BALANCE THIS ACCOUNTING PERIOD 12/31/2013 $ 0.00
SUMMARY OF PRINCIPAL CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 11/30/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
SALES AND MATURITIES 3,901,892.05
FROM OTHER SOURCES 917 .55 3,902,809.60
DISBURSEMENTS FOR THIS PERIOD
PURCHASES 3,211,969.78-
FOR OTHER PURPOSES 690,839.82- 3,902,809.60-
ENDING BALANCE THIS ACCOUNTING PERIOD 12/31/2013 $ 0.00
SUMMARY OF COST VALUE
ENDING BALANCE LAST ACCOUNTING PERIOD 11/30/2013 $ 4,505,232.83
ASSETS PURCHASED OR OTHERWISE ACQUIRED 3,211,969.78
ASSETS SOLD OR OTHERWISE DISPOSED OF 3,901,892.05-
ENDING BALANCE THIS ACCOUNTING PERIOD 12/31/2013 -COST VALUE- $ 3,815,310.56
IIIIIIIIIIIII11Ill 111 II IIIIIIIIIII
Ikunt'ngton
CITY OF CARMEL, INDIANA PAGE 2
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 12/01/2013 TO 12/31/2013
TOTAL MARKET VALUE OF ACCOUNT $ 3,815,310.56
0001240046 002 006 000 10 5 46032 30.321
1001141111M11011
CITY OF CARMEL, INDIANA PAGE 3
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 12/01/2013 TO 12/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
ENDING BALANCE LAST STATEMENT S 0.00 $ 0.00 $ 4,505,232.83
PERIOD 11/30/2013
12/02/2013
DIVIDEND ON HUNTINGTON 17. 18
COLLATERAL BACKED DEPOSIT
ACCOUNT PAYABLE 12/01/2013
EFFECTIVE 12/01/2013
DIVIDEND ON HUNTINGTON 900.37
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS PAYABLE
12/01/2013 EFFECTIVE 12/01/2013
TRANSFER TO PRINCIPAL ON 900.37-
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
EFFECTIVE 12/01/2013 FOR
REINVESTMENT
RECEIVED FROM INCOME ON 900.37
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
OHM II I II Ill IIHIll
• Hrintrgton
CITY OF CARMEL, INDIANA PAGE 4
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 12/01/2013 TO 12/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
12/03/2013
TRANSFERRED TO PRINCIPAL 17 . 18-
TRANSFERRED FROM INCOME 17. 18
12/04/2013
PAID TO ACE TECHNOLOGIES, LLC 2,790.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/03/2013. INVOICE #
0003633, JOB # J11002
PAID TO ACE TECHNOLOGIES, LLC 810.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/03/2013. INVOICE #
0003666, JOB # J11002
PAID TO ACE TECHNOLOGIES, LLC 450.00-
PAYMENT PER EXHIBIT 8,
DISBURSEMENT DIRECTION #23,
DATED 12/03/2013. INVOICE #
0003541, JOB # J11002
0001240046 003 006 000 10 5 46032 30,882
*011i Hauntargi®n
CITY OF CARMEL, INDIANA PAGE 5
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 12/01/2013 TO 12/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
12/04/2013
PAID TO CARMEL UTILITIES PAYMENT 78,453. 10-
PER EXHIBIT B, DISBURSEMENT
DIRECTION #23, DATED 12/03/2013.
INVOICE FOR PERIOD 9/14/13 -
11/22/13
PAID TO HACH COMPANY PAYMENT PER 5,240.00-
EXHIBIT B, DISBURSEMENT
DIRECTION #23, DATED 12/03/2013.
INVOICE #8573934
PAID TO JONES & HENRY ENGINEERS, 10,935.62-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/3/13. INVOICE # 63983
PROJECT # 00451-6770 SEWER REHAB
PAID TO JONES & HENRY ENGINEERS, 11 ,460.00-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/3/13. INVOICE # 63981
PROJECT # 00451-6531 WWTP
PAID TO JONES & HENRY ENGINEERS, 26,678.15-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/3/13. INVOICE # 63982
PROJECT # 00451-6733 106TH ST
111111111 11 III 1111111
• Huntington
CITY OF CARMEL, INDIANA PAGE 6
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 12/01/2013 TO 12/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
12/04/2013
PAID TO LAYNE CHRISTENSEN 22,310. 15-
COMPANY PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/03/2013. PAY APP # 2
PROJECT: DRILLING WELL 30
PAID TO MK BETTS ENGINEERING 244,050.30-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/03/2013. PAY APP # 8
INVOICE # 13-124.08
PAID TO TPI UTILITY CONSTRUCTION 286,595.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/03/2013. INVOICE # TPI
341
PAID TO UNITED CONSULTING 1,067.50-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #23,
DATED 12/3/13. PROJECT # 13-901
INVOICE # 1390101-10
0001240046 004 006 000 10 5 46032 30,663
• Huntington
CITY OF CARMEL, INDIANA PAGE 7
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 12/01/2013 TO 12/31/2013
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
NET CASH MANAGEMENT BUYS FOR THE PERIOD
DEPOSIT HUNTINGTON COLLATERAL 17. 18- 17. 18
BACKED DEPOSIT ACCOUNT
DEPOSIT HUNTINGTON CONSERVATIVE 3,211,952.60- 3,211,952.60
DEPOSIT ACCOUNT - CORPORATE
TRUST PLUS EFFECTIVE 12/01/2013
FOR REINVESTMENT
NET CASH MANAGEMENT SELLS FOR THE PERIOD
SOLD HUNTINGTON CONSERVATIVE 3,295,787.28 3,295,787.28-
DEPOSIT ACCOUNT - CORPORATE
TRUST PLUS
WITHDRAWAL HUNTINGTON COLLATERAL 606, 104.77 606, 104.77-
BACKED DEPOSIT ACCOUNT
ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 3,815,310.56
PERIOD 12/31/2013
III I III I 1111111111111111
Huntington
CITY OF CARMEL, INDIANA PAGE 8
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF DECEMBER 31, 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 15.8 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 CONSERVATIVE DEPOSIT 3,211,052.23 3,211,052.23 84.2 11,239 0.3
ACCOUNT - CORPORATE TRUST PLUS
TOTAL 3,211,052.23 3,211,052.23 11,239 0.3
ASSETS 3,815,310.56 3,815,310.56 100.0 15,468 0.4
CASH 0.00 0.00 0
TOTAL 3,815,310.56 3,815,310.56 15,468
0001240046 005 006 000 10 5 46032 30,884