HomeMy WebLinkAboutHuntington 40870000067 Jan 2014 THE HUNTINGTON NATIONAL BANK
PO BOX 1558 11e �}
COLUMBUS, OH 43216 IIII Hunhrigton
I'I'VIII'1I1II1111811 IiII1I1IIIIII'IIIIIIi1I1111i1111111IIIIIII
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 01/01/2014 TO 01/31/2014
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 W 12
form TRMAIL 07J0O
9
Huntington
CITY OF CARMEL, INDIANA PAGE 1
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 01/01/2014 TO 01/31/2014
SUMMARY OF INCOME CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 12/31/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
CASH DIVIDENDS 927.65
INTEREST 2, 150. 15 3,077.80
DISBURSEMENTS FOR THIS PERIOD
OTHER DISBURSEMENTS 3,077.80- 3,077.80-
ENDING BALANCE THIS ACCOUNTING PERIOD 01/31/2014 $ 0.00
SUMMARY OF PRINCIPAL CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 12/31/2013 $ 0.00
RECEIPTS FOR THIS PERIOD
SALES AND MATURITIES 1,326,451.27
FROM OTHER SOURCES 3,077.80 1,329,529.07
DISBURSEMENTS FOR THIS PERIOD
PURCHASES 607,336.13-
FOR OTHER PURPOSES 722, 192.94- 1,329,529.07-
ENDING BALANCE THIS ACCOUNTING PERIOD 01/31/2014 $ 0.00
SUMMARY OF COST VALUE
ENDING BALANCE LAST ACCOUNTING PERIOD 12/31/2013 $ 3,815,310.56
ASSETS PURCHASED OR OTHERWISE ACQUIRED 607,336. 13
IIIII IiIIII III1 IIHIIIIIH I II III •m v tin 1s li!r f^, -
CITY OF CARMEL, INDIANA PAGE 2
SEWAGE WORKS REVENUE BONDS OF
2012 — CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
CASH STATEMENT FROM 01/01/2014 TO 01/31/2014
SUMMARY OF COST VALUE
ASSETS SOLD OR OTHERWISE DISPOSED OF 1,326,451.27—
ENDING BALANCE THIS ACCOUNTING PERIOD 01/31/2014 —COST VALUE— $ 3,096, 195.42
TOTAL MARKET VALUE OF ACCOUNT $ 3,096, 195.42
0001248641 002 006 000 10 5 46032 18,879
OR Huntington
CITY OF CARMEL, INDIANA PAGE 3
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 01/01/2014 TO 01/31/2014
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
ENDING BALANCE LAST STATEMENT $ 0.00 $ 0.00 $ 3,815,310.56
PERIOD 12/31/2013
01/02/2014
DIVIDEND ON HUNTINGTON 1.49
COLLATERAL BACKED DEPOSIT
ACCOUNT PAYABLE 01/01/2014
EFFECTIVE 01/01/2014 TAX
EFFECTIVE 12/31/2013
DIVIDEND ON HUNTINGTON 769.77
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS PAYABLE
01/01/2014 EFFECTIVE 01/01/2014
TAX EFFECTIVE 12/31/2013
DIVIDEND ON HUNTINGTON 156.39
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS PAYABLE
01/01/2014 EFFECTIVE 01/01/2014
TAX EFFECTIVE 12/31/2013
TRANSFER TO PRINCIPAL ON 156.39-
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
EFFECTIVE 01/01/2014 FOR
REINVESTMENT
II I I III I II II 111 l 111 I IIl 1 1 11111 I I
OM Huntington
CITY OF CARMEL, INDIANA PAGE 4
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 01/01/2014 TO 01/31/2014
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
01/02/2014
RECEIVED FROM INCOME ON 156.39
HUNTINGTON CONSERVATIVE DEPOSIT
ACCOUNT - CORPORATE TRUST PLUS
FOR REINVESTMENT
PAID TO UNITED CONSULTING 295.00-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #24,
DATED 01/02/2014. PROJECT#13-901
INVOICE# 1390101-11
PAID TO MK BETTS ENGINEERING 426,215.60-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #24,
DATED 01/02/2014. APPLICATION
#9, INVOICE # 13-124.09
0001248641 003 006 000 10 5 46032 18.880
oil Huntington
CITY OF CARMEL, INDIANA PAGE 5
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 01/01/2014 TO 01/31/2014
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
01/03/2014
TRANSFERRED TO PRINCIPAL 771.26--
TRANSFERRED FROM INCOME 771.26
01/10/2014
INTEREST ON 604,258.33 UNITS 2, 150. 15
HUNTINGTON NATIONAL BANK CD
#07403011880 .7% 01/10/2014
PAYABLE 01/10/2014
MATURED 604,258.33 UNITS 604,258.33 604,258.33-
HUNTINGTON NATIONAL BANK CD
#07403011880 .7% 01/10/2014
01/13/2014
TRANSFERRED TO PRINCIPAL 2, 150. 15-
TRANSFERRED FROM INCOME 2, 150.15
II II 1l III III.IIIIIII I,IIIII I
Q � • gel }tt ton
CITY OF CARMEL, INDIANA PAGE 6
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 01/01/2014 TO 01/31/2014
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
01/30/2014
PAID TO MK BETTS ENGINEERING 243,643.82-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #25,
DATED 01/30/14. APPLICATION #10
INVOICE #13. 124-10
PAID TO OGLETREE, DEAKINS, NASH, 595.00-
SMOAK PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #25,
DATED 01/30/14. INVOICE #1178432
PAID TO MILLER PIPELINE CORP. 19,734.38-
PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #25,
DATED 01/30/14. INVOICE #369005
PAID TO JONES & HENRY ENGINEERS, 11,679.53-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #25,
DATED 01/30/2014. INVOICE #64048
PAID TO JONES & HENRY ENGINEERS, 6,203.75-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #25,
DATED 01/30/2014. INVOICE #64049
0001248641 004 006 000 10 5 46032 18,881
IPII Huntington
CITY OF CARMEL, INDIANA PAGE 7
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 01/01/2014 TO 01/31/2014
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
01/30/2014
PAID TO JONES & HENRY ENGINEERS, 9,945.86-
LTD. PAYMENT PER EXHIBIT B,
DISBURSEMENT DIRECTION #25,
DATED 01/30/2014. INVOICE #64050
PAID TO HACH COMPANY PAYMENT PER 1,940.00-
EXHIBIT B, DISBURSEMENT
DIRECTION #25, DATED 01/30/2014.
INVOICE #8613971
PAID TO HACH COMPANY PAYMENT PER 1,940.00-
EXHIBIT B, DISBURSEMENT
DIRECTION #25, DATED 01/30/2014.
INVOICE #8650731
NET CASH MANAGEMENT BUYS FOR THE PERIOD
DEPOSIT HUNTINGTON CONSERVATIVE 607,336. 13- 607,336. 13
DEPOSIT ACCOUNT - CORPORATE
TRUST PLUS EFFECTIVE 01/01/2014
FOR REINVESTMENT
11111111111111111111111
101 Huntington
CITY OF CARMEL, INDIANA PAGE 8
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF TRANSACTIONS
FROM 01/01/2014 TO 01/31/2014
POSTING INCOME PRINCIPAL
DATE DESCRIPTION CASH CASH COST VALUE
NET CASH MANAGEMENT SELLS FOR THE PERIOD
WITHDRAWAL HUNTINGTON 722, 192.94 722,192.94-
CONSERVATIVE DEPOSIT ACCOUNT -
CORPORATE TRUST PLUS
ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 3,096,195.42
PERIOD 01/31/2014
0001248641 005 006 000 10 5 46032 18,882
e
�w Huntington
CITY OF CARMEL, INDIANA PAGE 9
SEWAGE WORKS REVENUE BONDS OF
2012 - CONSTRUCTION FUND
ACCOUNT NUMBER 4087000067
SCHEDULE OF PRINCIPAL ASSETS
AS OF JANUARY 31, 2014
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
CASH MANAGEMENT FUNDS-TAXABLE
HUNTINGTON CONSERVATIVE DEPOSIT 3,096,195.42 3,096, 195.42 100.0 10,837 0.3
ACCOUNT - CORPORATE TRUST PLUS
TOTAL • 3,096, 195.42 3,096, 195.42 10,837 0.3
ASSETS 3,096, 195.42 3,096,195.42 100.0 10,837 0.3
CASH 0.00 0.00 0
TOTAL 3,096, 195.42 3,096,195.42 10,837