Item 4ACity of Atlantic Beach
FINANCIAL REPORT
MAY 2010
Current
05/31 /10
Cash Balances
Fund(s)
General
Tree Replacement
Convention Development Tax
Local Option Gas Tax
Better Jax 1/2 Cent Sales Tax
Police Training, Forfeiture & Grants
Community Development Block Grant
Debt Service
Capital Projects
Utility
Sanitation
Building Code Enforcement
Storm Water
Pension -Police
Pension -General
Morgan Stanley Smith Barney Unrealized Gains
Total
Total Restricted Cash
Total Unrestricted Cash
Prior
04/30/10
$5,478,055
8, 890
48, 098
181,413
488,119
65, 373
(100)
48,606
1,218,041
3,516,415
577, 861
48, 707
3,410,641
26,438
55,762
0
$15,172,319
$5, 334, 321
3,989
42,253
180, 238
465,194
31,292
26,120
54,164
1,297,686
3,483,326
582, 514
51,751
3, 289, 514
21, 947
83,217
166, 784
$15,114,310
$7,482,752
$7,631,558
Cash and Investments
Account
Prior
04/30/10
Current
05/31 /10
Bank of America -Depository
Federal National Mortgage Association Bonds
US Treasury Notes
US Treasury Notes
Federal Farm Credit Bank Consolidated Bonds
Federal Home Loan Mortgage Corporation
Federal Home Loan Bank Consolidated Bonds
Morgan Stanley Smith Barney Cash Balance
SBA -Florida Prime
Cash on Hand
Police Pension Investments
General Pension Investments
Subtotal
Subtotal
Total
$10,929,698
0
1,122, 276
2, 009, 081
1,108,143
0
0
0
221
2,900
15,172,319
5,953,628
10,066,806
16,020,434
$31,192,753
$7,743,577
1,008,440
1,120, 080
2,065,620
1,129, 792
1,011,630
1,009,060
22,975
236
2,900
15,114,310
5, 734, 395
9, 549, 968
15,284,363
AGENDA ITEM # 4A
JiJNE 28, 2010
Dollar
Change
($143,734)
(4, 901)
(5, 845)
(1,175)
(22, 925)
(34,081)
26,220
5, 558
79, 645
(33, 089)
4, 653
3,044
(121,127)
(4,491)
27,455
166, 784
($58,009)
Dollar Rate of
Change Return
($3,186,121) 0.300
1,008,440 3.100
(2,196) 4.625
56,539 3.625
21,649 4.875
1, 011, 630 4.000
1, 009, 060 4.300
22,975 N/A
15 0.270
0 N/A
(58,009)
(219,232) 1.550 (1)
(516,838) 1.560 (1)
(736,071)
$30,398,673 ($794,080)
(1) YTD rate of return through 03/31/10
I
~ tiV G1V LH 11 CM iF 4 A
I
I ~
!
i ~ I JU NE 28, 2010
i
,
I
%
1
,
,
I ~
I ~i
~ O
d1 N
M
I ~ ~
W
~ ~
0
0
1
t i
I
~
~ ~
N
i r ~
'
II
O G ~ O r et ~ ~' N M ~~ M
~ H ~" V- r I
a
z
- Oa I
I a
z
Q
J
J I
~
O t- I -
~
~
~ --- --
°r'
O ~
~
I -
~ -
~ ~
i
i ~ J O
OD
i r
~
Wz Q
~
? Q
z ~ ~
I Z
o J
Z i
~} I ~ I ; I~ ~ N I
i ~
~ I I N
Z J V
w ~
~ I=
V V
iN ~ i d
. ?~ 'I li
-~ J J W '- ~ ~ W ~
~ -
-
-
~_ -
-
-.
O
0
0
0
0
0
0
0
0
0
0
'
0
o o
w o
'
~ 0
o 0
0 0
0 0
0
~
~
~
-
~ 0
o
_
o
o
, ~
~
~
~
_
°o
_
;°o
- c+-
a
W i ~~
0
^ ~
0
^ ~
00
w ~
M N
NI ~
M
w ~
r ~ o
Q O f
i o
IM o
0 o
0 ~
00 ~
~ ~;
~ o
i~ o
001
I
OI
~
i t~0
O~ 409
~ tOO
M ~
M 01 ',
r t~D
00 °
N > Q1
Z~ ~ r
~ ~
I O
O f~
N r~
Lp ',
! I 0
M 0
t0 ' N
I ui ~
O
M
~
~
O r
~
N
r
N
h
~
O
i
O
, 1
~
r
r
I
~ N !RI fA I fA ~
Q ~ i
>
~I ~
~ , , o
a
!, ~
~
~ ~I i
~ ~
o ~
~
o I
,
i ~~
I
I
, ~~
Q o
I
O
- z
~
.
i
~"' w;
~
Z
I- ~
O o
o
I 0
0 01
0 0
0 o
0
, ~ i
I
~
~
~
~
~
l ,
I - -
i - ,_
~
~
Z
Z ~ O
~ ~ o
°o r
o o
~° an
~ cc ;
a
~I i I
Q ~ i Z o~ ti ~ o ° LLJ
Z'~ i ~ ~ ~ ~,
N M B O o
i
O M ~.... ~ ~
l i ~
Z
O
~ . W
=
n/ ~
}~.
~ 0 O'
~ ~
~ O
O~
~ O
O O
~Cl O
N O
N
~ O
O O
O O
O t
O;
O'
~ O
O 0
~ OH
O O
O O
O O
O O
O O
O I
;
~
~
Q
/~ ~
~
~ I.f.
Q I ~ ~ O
N ti
~ f~
t0
M O
tfy
~ 1~
P
N ~fl ~
N
l0 1~
O'
N~ 00
~
tp 00
00
O O
01
f t0
~
Lp 1p
00
M r
07 tp
N O
M ~
r ~
~ O
00 O
~Cl
~ ~C '
Of i
lCi ~
~ ~
N I
el'
N
eF
N ~ ~.
r i
r
~ r N r N
I N~ M r
N
C O ~ ~ EH, EA f~R f+9 fi? ? ~ i
° ~ ° ~
li
~ ~i ~ ~ ~ v
w
, ,
' l
~ W
~~' ~ o N
I a
~
a
w
~
~
~ ~
--
7
_
~
~-
~
- - -
~
--
_
-
~
_
- -
~
-
~
~
~
-
~
!
~
-
~
,
~
.
~
~
`~
~
~
o ~
I
I
o I
' ~o~ ~ ~' ~ ~I ~ w
J ~~
~ a
~
I
I.
,
I
~
i
~
'
~
-
-
-
--- ~
Wr
O
N
O
N
N
O I
~
'
'
~
M
I
O Os ~
a r r ~ ~ N O h r N r r h 0l ~ I
r _-_
W
i i W N M 0 ~ ~ ~
I M Z i I
I ~
m
~
CO
h
I ~ H
, ~ ~ i I ~ i
I ? I ~ I
i I r -- -JQ - --- -- - - ~ r -- i __ i. J~ -
O , ~ y ~ I I z ~ 'I ~
N f- ~ o z ~ i ; o p'I
z0 ~ ~ o ~ ~ iw- cn a w ~ a I I
W
}
-
H
p wl
ZI
~ ~
~
~
Q W
Z D
~ J
Q
Q
C7
~
2
~ tL
Z Q
~
fA
Z
~ i
~
r
r J
~
Q J'
a
( _J
rL XX
LL1
Q J
a Q
J J
Q fn
-
~
"~
Q
Q
O
z
~
z
U
lwt
l
N Q~
~
1
F-' Q
w
W ~
w
O V
m
w - Q
'+-
W J
a
= ~
z U
~ Q
c~ U
~
v~ V
- C)
z V
z ~
z
m
C9 ~ ~
H V
w
a W
~~
~
Q .
~
>-
J
W ~'
Q
~ I
u.l
~
'
~
I
~
~
J
C9 w
J
a
O
~
~
~ ~
W
x I'
J
0
am
3 0
- ~
~ W
~ ~
~ ~
~
V
Q
2
v
Q
2
v ~
-
LL
O
O
O
J~
O ~
Z
~
~
a
~ Q y
z V W
?
~
H,
=
!
~
,
I
W
z
~
w
0
~
I
z
w rn
w
O
O
O ~
w w
J
w
w ~
J
O z
- ~
w
w a
w t)
t) z
w
(7 z
w
~ I
C9i
~ in o ~; c~ 0 , v~ z a c,~ c) c~ a w ~ ~ a a ~ o ~ a o a _
cn wl o ~: