The URL can be used to link to this page

Home My WebLink AboutHuntington 4087000067 October 2013 THE HUNTINGTON NATIONAL BANK PO BOX 1558 �pq� COLUMBUS. OH 43216 :+ ?unt ;t t o I'I'IIIII"IIIIIIIuiIIiIIIIII�IIIIII'IIIIII'II"IIII'IIII'IIIIIiI 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 10/01/2013 TO 10/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 41111 -3,11ittirigliwo CITY OF CARMEL, INDIANA PAGE 1 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 CASH STATEMENT FROM 10/01/2013 TO 10/31/2013 SUMMARY OF INCOME CASH ENDING BALANCE LAST ACCOUNTING PERIOD 09/30/2013 $ 0.00 RECEIPTS FOR THIS PERIOD CASH DIVIDENDS 789.47 789.47 DISBURSEMENTS FOR THIS PERIOD OTHER DISBURSEMENTS 789.47- 789.47- ENDING BALANCE THIS ACCOUNTING PERIOD 10/31/2013 $ 0.00 SUMMARY OF PRINCIPAL CASH ENDING BALANCE LAST ACCOUNTING PERIOD 09/30/2013 $ 0.00 RECEIPTS FOR THIS PERIOD SALES AND MATURITIES 399,568.00 FROM OTHER SOURCES 1,289.47 400,857.47 DISBURSEMENTS FOR THIS PERIOD PURCHASES 200,573.47- FOR OTHER PURPOSES 200,284.00- 400,857.47- ENDING BALANCE THIS ACCOUNTING PERIOD 10/31/2013 $ 0.00 SUMMARY OF COST VALUE ENDING BALANCE LAST ACCOUNTING PERIOD 09/30/2013 $ 5, 104,440.33 ASSETS PURCHASED OR OTHERWISE ACQUIRED 200,573.47 ASSETS SOLD OR OTHERWISE DISPOSED OF 399,568.00- ENDING BALANCE THIS ACCOUNTING PERIOD 10/31/2013 -COST VALUE- $ 4,905,445.80 Il II III II III II I I 1 III I I II II III 10 Huntington CITY OF CARMEL, INDIANA PAGE 2 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 CASH STATEMENT FROM 10/01/2013 TO 10/31/2013 TOTAL MARKET VALUE OF ACCOUNT $ 4,905,445.80 0001224404 002 007 000 10 5 46032 19,092 CITY OF CARMEL, INDIANA PAGE 3 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF TRANSACTIONS FROM 10/01/2013 TO 10/31/2013 POSTING INCOME PRINCIPAL DATE DESCRIPTION CASH CASH COST VALUE ENDING BALANCE LAST STATEMENT $ 0.00 $ 0.00 $ 5, 104,440.33 PERIOD 09/30/2013 10/01/2013 DIVIDEND ON HUNTINGTON 21.94 COLLATERAL BACKED DEPOSIT ACCOUNT PAYABLE 10/01/2013 DIVIDEND ON HUNTINGTON 767.53 CONSERVATIVE DEPOSIT ACCOUNT - CORPORATE TRUST PLUS PAYABLE 10/01/2013 TRANSFER TO PRINCIPAL ON 767.53-- HUNTINGTON CONSERVATIVE DEPOSIT ACCOUNT - CORPORATE TRUST PLUS FOR REINVESTMENT RECEIVED FROM INCOME ON 767.53 HUNTINGTON CONSERVATIVE DEPOSIT ACCOUNT - CORPORATE TRUST PLUS FOR REINVESTMENT DEPOSIT HUNTINGTON CONSERVATIVE 767.53- 767.53 DEPOSIT ACCOUNT - CORPORATE TRUST PLUS FOR REINVESTMENT IIIIIII II IIIII II IIIfIIHII III 01 Huntington CITY OF CARMEL, INDIANA PAGE 4 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF TRANSACTIONS FROM 10/01/2013 TO 10/31/2013 POSTING INCOME PRINCIPAL DATE DESCRIPTION CASH CASH COST VALUE 10/02/2013 TRANSFERRED TO PRINCIPAL 21.94- TRANSFERRED FROM INCOME 21.94 10/21/2013 DEPOSIT FOR HUNTINGTON FEES FROM 500.00 CK 224528 INVOICE A06665-4087000067 FOR PERIOD ENDING 5/31/13 FEE PAYMENT TO HUNTINGTON 500.00- INVOICE A06665-4087000067 FOR PERIOD ENDING 5/31/13 10/23/2013 SOLD HUNTINGTON CONSERVATIVE 199,784.00 199,784.00- DEPOSIT ACCOUNT - CORPORATE TRUST PLUS ON 10/23/2013 PAID TO DEIST INDUSTRIES, INC 13,536.00- PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE #25125 0001224404 003 007 000 10 5 46032 19.093 IIN1 /Mem otl • CITY OF CARMEL, INDIANA PAGE 5 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF TRANSACTIONS FROM 10/01/2013 TO 10/31/2013 POSTING INCOME PRINCIPAL DATE DESCRIPTION CASH CASH COST VALUE 10/23/2013 PAID TO CULY CONTRACTING PAYMENT 14,939.93- PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE# 0000001302 PAID TO CULY CONTRACTING PAYMENT 19,301.32- PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE # 0000001300 PAID TO HACH CO PAYMENT PER 2,910.00- EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE # 8499180 PAID TO JONES & HENRY ENGINEERS, 2,862.00- LTD. PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE #63811 PROJECT# 00451-6788 PAID TO JONES & HENRY ENGINEERS, 12,538.00- LTD. PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE #63809 PROJECT # 00451-6733 Illlllllllllll0 Illlll.H II l • Huntington CITY OF CARMEL, INDIANA PAGE 6 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF TRANSACTIONS FROM 10/01/2013 TO 10/31/2013 POSTING INCOME PRINCIPAL DATE DESCRIPTION CASH CASH COST VALUE 10/23/2013 PAID TO JONES & HENRY ENGINEERS, 26,282.04- LTD. PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE #63806 PROJECT # 00451-6531 PAID TO JONES & HENRY ENGINEERS, 8,723.52- LTD. PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE #63810 PROJECT # 00451-6770 PAID TO LAYNE CHRISTENSEN CO. 91,202.85- PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. APPLICATION # 1 PAID TO UNITED CONSULTING 1,125.00- PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. PROJECT 13-901 INVOICE # 1390101-08 0001224404 004 007 000 10 5 46032 19,094 00I Huntington CITY OF CARMEL, INDIANA PAGE 7 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF TRANSACTIONS FROM 10/01/2013 TO 10/31/2013 POSTING INCOME PRINCIPAL DATE DESCRIPTION CASH CASH COST VALUE 10/23/2013 PAID TO XYLEM WATER SOLUTIONS 1,742.65- PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE # 07751552 PAID TO XYLEM WATER SOLUTIONS 1,749. 10- PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE # 07751778 PAID TO WESSLER ENGINEERING 2,871.59- PAYMENT PER EXHIBIT B, DISBURSEMENT DIRECTION #21, DATED 10/23/2013. INVOICE # 25838 I1110 IIIIIIIII I IIIIIIDIII IN�Is Huntington CITY OF CARMEL, INDIANA PAGE 8 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF TRANSACTIONS FROM 10/01/2013 TO 10/31/2013 POSTING INCOME PRINCIPAL DATE DESCRIPTION CASH CASH COST VALUE NET CASH MANAGEMENT BUYS FOR THE PERIOD DEPOSIT HUNTINGTON COLLATERAL 199,805.94- 199,805.94 BACKED DEPOSIT ACCOUNT NET CASH MANAGEMENT SELLS FOR THE PERIOD WITHDRAWAL HUNTINGTON COLLATERAL 199,784.00 199,784.00- BACKED DEPOSIT ACCOUNT ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 4,905,445.80 PERIOD 10/31/2013 0001224404 005 007 000 10 5 46032 19,095 Huntington CITY OF CARMEL, INDIANA: PAGE 9 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF PRINCIPAL ASSETS AS OF OCTOBER 31, 2013 COST UNIT MARKET % EST YIELD VALUE PRICE VALUE MKT INCOME MKT CERTIFICATES OF DEPOSIT-HUNTINGTON 1,007,097.22 HUNTINGTON NATIONAL BANK CD 1,007,097.22 100.00 1,007,097.22 20.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 12.3 4,230 0.7 #07403011880 .7% 01/10/2014 TOTAL 1,611,355.55 1,611,355.55 11,279 0.7 CASH MANAGEMENT FUNDS-TAXABLE HUNTINGTON COLLATERAL BACKED 825,039.44 825,039.44 16.8 248 0.0 DEPOSIT ACCOUNT HUNTINGTON CONSERVATIVE DEPOSIT 2,469,050.81 2,469,050.81 50.3 8,642 0.4 ACCOUNT - CORPORATE TRUST PLUS TOTAL 3,294,090.25 3,294,090.25 8,889 0.3 ASSETS 4,905,445.80 4,905,445.80 100.0 20, 169 0.4 CASH 0.00 0.00 0 IIIII 1111111111 11111111 11011 • Huntington CITY OF CARMEL, INDIANA PAGE 10 SEWAGE WORKS REVENUE BONDS OF 2012 - CONSTRUCTION FUND ACCOUNT NUMBER 4087000067 SCHEDULE OF PRINCIPAL ASSETS AS OF OCTOBER 31, 2013 COST UNIT MARKET % EST YIELD VALUE PRICE VALUE MKT INCOME MKT TOTAL 4,905,445.80 4,905,445.80 20, 169 0001224404 006 007 000 10 5 46032 19,096