HomeMy WebLinkAboutJune 2012 4087000012THE HUNTINGTON NATIONAL BANK
PO BOX 1558
COLUMBUS, OH 43216
1' 1' 1PIII" 1111111PP1IP111111. jIt111 ,11111IP1IPP1111.1111.11P1111
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 06/01/2012 TO 06/30/2012
ACCOUNT NAME: ATLAS EXCAVATING, INC. AND
CITYOF CARMEL BD OF PUBLIC WORKS
RET ESC (COLLEGE AVE WATER TRAN)
ACCOUNT NUMBER: 4087000012
TRUST ADMINISTRATOR: KIMBERLEE WILSON
TELEPHONE NUMBER: 317- 229 -4094
Huntington
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 VALLE ANO ESTIMATED INCOME FIGURES ARE NOT GUARANTEED, BUT DO COME FROM RELIABLE SOURCES.
FORMAT # 12
le!m PP MAIL 07(04
ATLAS EXCAVATING, INC. AND
CITYDF CARMEL BD OF PUBLIC WORKS
RET ESC (COLLEGE AVE WATER TRAN)
ACCOUNT NUMBER 4087000012
CASH STATEMENT FROM 06/01/2012 TO 06/30/2012
SUMMARY OF INCOME CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 05/31/2012
RECEIPTS FOR THIS PERIOD
CASH DIVIDENDS
DISBURSEMENTS FOR THIS PERIOD
OTHER DISBURSEMENTS
ENDING BALANCE THIS ACCOUNTING PERIOD 06/30/2012
*SD Huntington
PAGE I
S 0.00
4.34 4.34
4.34- 4.34-
0.00
SUMMARY OF PRINCIPAL CASH
ENDING BALANCE LAST ACCOUNTING PERIOD 05/31/2012 S 0.00
RECEIPTS FOR THIS PERIOD
FROM OTHER SOURCES 71,057.88 71,057.88
DISBURSEMENTS FOR THIS PERIOD
PURCHASES 71,057.88- 71,057.88 -
ENDING BALANCE THIS ACCOUNTING PERIOD 06/30/2012 S 0.00
SUMMARY OF COST VALUE
ENDING BALANCE LAST ACCOUNTING PERIOD 05/31/2012
ASSETS PURCHASED OR OTHERWISE ACQUIRED
ENDING BALANCE THIS ACCOUNTING PERIOD 06/30/2012 -COST VALUE-
TOTAL MARKET VALUE OF ACCOUNT S 141,899.75
S 70,837.53
71,062.22
S 141,899.75
POSTING
DATE
DESCRIPTION
Illlllllll
1111111111
ATLAS EXCAVATING, INC. AND
CITYOF CARMEL BD OF FUBLIC WORKS
RET ESC (COLLEGE AVE WATER IRAN)
ACCOUNT NUMBER 4087000012
SCHEDULE OF TRANSACTIONS
FROM 06/01/2012 TO 06/30/2012
11
IIIIII 11111
INCOME PRINCIPAL
CASH CASH
IN�II Huntington
PAGE 2
COST VALUE
ENDING BALANCE LAST STATEMENT $ 0.00 S 0.00 $ 70,837.53
PERIOD 05/31/2012
06/01/2012
DIVIDEND ON HUNTINGTON
COLLATERAL BACKED DEPOSIT
ACCOUNT PAYABLE 06/01/2012
06/11/2012
RECEIVED FROM REGIONS TRUST
DEPOSIT CHECK FROM REGIONS TRUST
REPRESENTS RETAINAGE DEPOSIT PER
APPLICATION #2
NET CASH MANAGEMENT BUYS FOR THE PERIOD
4.34
DEPOSIT HUNTINGTON COLLATERAL 4.34 -
BACKED DEPOSIT ACCOUNT
71,057.88
71,057.88- 71,062.22
ENDING BALANCE THIS STATEMENT $ 0.00 $ 0.00 $ 141,899.75
PERIOD 06/30/2012
0001090535 002 004 000 10 5 46032 32,340
ATLAS EXCAVATING, INC. AND
CITYOF CARMEL BD OF PUBLIC WORKS
RET ESC (COLLEGE AVE WATER TRANS
ACCOUNT NUMBER 4087000012
SCHEDULE OF PRINCIPAL ASSETS
AS OF JUNE 30, 2012
I Harntongtan
PAGE 3
COST UNIT MARKET EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
CASH MANAGEMENT FUNDS- TAXABLE
HUNTINGTON COLLATERAL BACKED 141,895.41
DEPOSIT ACCOUNT
TOTAL
141,895.41 100.0 114 0.1
141,895.41 141,895.41
114 0.1
ASSETS 141,895.41 141,895.41 100.0 114 0.1
CASH 0.00 0.00 0
TOTAL 141,895.41 141,895.41 114
111 1111111111111111
ATLAS EXCAVATING, INC. AND
CITYOF CARMEL BD OF PUBLIC WORKS
RET ESC (COLLEGE AVE WATER TRAM)
ACCOUNT NUMBER 4087000012
SCHEDULE OF INCOME ASSETS
AS OF JUNE 30, 2012
CASH MANAGEMENT FUNDS- TAXABLE
HUNTINGTON COLLATERAL BACKED
DEPOSIT ACCOUNT
TOTAL
ASSETS
CASH
III
IN�II Huntington
PAGE 4
COST UNIT MARKET % EST YIELD
VALUE PRICE VALUE MKT INCOME MKT
4.34 4.34 100.0 0
4.34 4.34 0 0.0
4.34 4.34 100.0 0
0.00 0.00 0
TOTAL 4.34 4.34 0
0001090535 003 004 000 10 5 46032 32.341