HomeMy WebLinkAboutItem 4.05 Invest Report 3rd QtrG~~~ OF DU~~~2
///~~~ ~\
19 (~i= =7,~),SZ
~```~"/%
~~LIFOR~~
STAFF REPORT C I T Y C L E R K
DUBLIN CITY COUNCIL File #^0?~] Q^-3~~
DATE: May 3, 2011
TO: Honorable Mayor and City Councilmembers
FROM: ~~Joni Pattillo, City Manager
~
SUBJECT: City Treasurer's Investment Report for 3rd Quarter 2010-2011
Prepared By: Paul S. Rankin, Administrative Services Director
EXECUTIVE SUMMARY:
The City's investment portfolio totals $96,536,664 (par value). As of March 31, 2011, funds
were invested at an average yield of 1.469%. The portfolio includes both discretionary and
restricted funds and the balance will fluctuate throughout the year: The report presented
provides background on the City investment portfolio as well as the investment results as of
March 31, 2011.
FINANCIAL IMPACT:
Investments are made in accordance with the City Investment Policy and State Law. Interest
earned is apportioned between the Funds (i.e. General Fund, Gas Tax Fund, etc) based upon
the proportionate share of the total cash 6alance. The current earning rate is slightly above the
1.37% projection which was developed with the mid-year budget adjustments. Actual revenue
results wi{{ also be impacted by fluctuations in the Total Funds invested.
RECOMMENDATION:
Receive the Quarterly Investment~Report.
O~Y ~
Submitted By:
Administrative Services Director
~
~
Reviewed
Assistant City anager
DESCRIPTION:
The format of the quarterly report consists of the following components:
Section I - Portfolio Information
• Portfolio Summary (Includes the Par Value; Market Value; and Yield)
• Portfolio Details (Includes a listing of individual securities and investments)
• Investments By Type (Includes a listing of Federal Securities including call
date if applicable)
Section II - Investment Charts
Section III - Listing of Investment Transactions by Month
. s
` Page 1 of 4 ITEM NO. ~• ~
3rd QUARTER RESULTS
As shown on the Portfolio Summary the total investments as of March 31, 2011 were
approximately $96.5 million. The "Yield to Maturity" was calculated at 1.469% and the weighted
average maturity of the portfolio was 535 days (1.47 years). The report also displays the
weighted average maturity based on the "Call Date". If all securities were assumed to be called
the portfolio average maturity drops to 1.2 years (422 days).
The Market Value as of March 31, 2011 was $668,111 more than the Par Value (Par Value =
$96,536,664 and Market Value =$97,204,774). The Par Value is the "face value" or principal
amount at maturity of the note or bond. The typical investment approach used by the City is to
hold investments until maturity. The City does not actively sell securities prior to their maturity.
In the current market, the premature liquidation of a security would result in less interest income
upon reinvestment, diluting any gain achieved from . selling the investment prior to its stated
maturity. ~
The following Table displays the comparative results based on information in the Portfolio
Summary for the most recent five quarters. This allows for a comparison to the most recent
quarter as well as the same three month period one year ago.
As noted in Table 1, the total portfolio is approximately $2 million more than one year ago. The
total portfolio will fluctuate between fiscal years based upon: planned expenditures, fluctuations
in revenue collected, and differences in timing of both revenue and expenditures
The average maturity of the investments held. has increased over the past quarter from 472
days to 535 days. When comparing to a year ago, the ~average maturity of the portfolio has
increased from 367 days to 535 days. Comparing the interest rate earned the rates have
stopped declining and the most recent quarterly results are essentially flat with the previous
quarter (1.47% compared to 1.48% respectively). The rates continue to be well below what the
City earned one year ago.
INVESTMENT ACTIVITY DURING THE THIRD QUARTER
This section of the report discloses changes in individual securities,due to Maturities, Called
Securities, and New Investments. A total of $ 6,655,000 in securities either matured or were
called during the quarte~. As shown below two transactions were due to maturing investments,
and one security was called prior to the stated maturity date.
Page 2 of 4
Table 1: COMPARISON OF PORTFOLIO MEASURES
Most Recent Five Quarters
TABLE 2: INVESTMENTS MATURED DURING THE THIRD QUARTER
4~~> > k
~ T k . e,..; ~~ 1/al °u~e~at~~~
~
„~ _, __
~ Maturi._ ~~ Maturity~
Date ._,.~
/ ~~ , ; ; ~f fi~~'~
.,w ~ ~,:
~Cou on~Rate~~
FFCB $ 2,000,000 2/1/2011 5.05%
FFCB $ 1,655,000 3/9/2011 4.85%
Total $ 3,655,000
Two new investments with a combined par value of $7,000,000 were purchased during the third
quarter.
TABLE 4: INVESTMENTS PURCHASED DURING THE THIRD QUARTER
None of the securities which were purchased have call provisions as shown in the Table above.
The effective yield is more than the stated coupon for the securities purchased, as they were
purchased at a discount. For example, the second security shown in the Table above indicates
a"coupon rate" of 1.375% and an effective yield of 1.493°/o. The $4,000,000 face value bonds
were purchased for $3,984,080 and factoring this in results in a slightly increased yield.
Securities can sell for either ~a premium or discount depending on the market on the day the
security is purchased. The "premium" or "discount" is allocated. over the life of the investment in
the City accounting records.
COMPOSITION OF PORTFOLIO
Section II of the Report contains charts which assist with reviewing the portfolio. The Charts
focus on key factors to monitor including the investment maturities as well as the composition of
the portfolio. The following are key highlights of the portfolio:
• At March 31, 2011 39.30% of the portfolio was immediately available in the Local Agency
Investment Fund (LAIF) and Money Market instruments; this is 4.41% less than reported
as of December 31, 2010.
Page 3 of 4
TABLE 3: INVESTMENTS CALLED DURING THE THIRD QUARTER
* FHLB = Federal Home Loan Bank; FFCB = Federal Farmers Credit Bank; FNMA = Federal
National Mortgage Association or "Fannie Mae"
• Federal Agency Securities represented 60.6% of the Portfolio, which is a 4.31 % increase
from the percentage reported as of December 31, 2010.
• There was diversity in the issuers of the federal securities held in the portfolio. A total of
four different issuers were represented. (FHLB - 69%; FFCB-9%, FHLMC-10% and
FNMA-12%).
• 44% of the funds are invested for one year or less compared to 48% reported in this
category as of December 31, 2010. .
• 18% of the funds are invested in securities with maturities of 3 years or more, compared
to 10% reported in this category as of December 31, 2010.
MONTHLY TRANSACTIONS
Section III of the Report provides a list of transactions related to investments in the City portfolio
for each month of the third quarter (January,~ February and March). This schedule provides
compliance with.the Government Code requirement to disclose monthly transaction data. It is
incorporated as part of the quarterly investment report rather than individual monthly reports.
RECENT TRENDS COMPARED TO BUDGET
As part of the mid-year budget adjustments a revision was made to the projected revenue
earned from investments. In the adjusted Budget it was assumed that LAIF would generate a
rate of at least 0.50%. As noted below the rate for the third quarter did achieve this threshold.
The following Table shows the trend relatively flat trend in short-term rates at LAIF over the past
year. -
TABLE 5: Local Agency Investment Fund (LAIF) Quarterly Rate
The current trend in the market has been a continued climate of low interest rates. Most
projections do not anticipate a rapid change in interest rates and the low rates are expected for
at least the ne~ year. -
NOTICING REQUIREMENTS/PUBLIC OUTREACH: None
ATTACHMENTS:
1. Quarterly Investment Report for the Period Ending
March 31, 2011 ~ ,
Page 4 of 4
i~
~~
CITY OF DUBLIN
QUARTERLY INVESTMENT REPORT
Third Quarter Fiscal Year 2010-2011
March 31, 2011
Report Prepared April 19, 2011
Report Presented To City Council May 3, 2011
Section I - Portfolio Information
• Portfolio Summary (Includes the Par Value; Market
Value; and Yield)
• Portfolio Details (Includes a listing of individual
securities and investments)
• Investments By Type (Listing of Federal Securities
including cail date if applicable)
Section II - Investment Charts
Section III - Listing of Monthly Investment Transactions
y.5 ~-3-I I
ATTACHMENT 1
.,a ~U ' CITY OF DUBLIN
19~ `~"~k ~,: Portfolio Management
~~~ Portfolio Summary
~` ~: `%':
`.~ r R~ March 31, 2011
Par Market Book % of Term / Days to YTM/C
Investments Value Value Va1ue Portfolio Days Mat./Call 365 Equiv.
Money Market 30,529.59 30,529.59 30,529.59 0.03 1 1 0.020
LAIF 37,942,705.58 37,942,705.58 37,942,705.58 39.30 1 1 0.520
Calif Asset Mgt Pgm (CAMP) 63,428.51 63,428.51 63,428.51 0.07 1 1 0.180
Federal Agency Coupon 58,500,000.00 59,168,110.00 58,447,283.38 60.60 883 695 2.086
Total / Average $96,536,663.68 $97,204,773.68 $96,483,947.06 100.00% 535 422 1.469%
Cash and Accrued Interest
Accrued Interest ~'~ 269,254.17 269,254.17
Total Cash and $96,536,663.68 $97,474,027.85 $96,753,201.23 535 422 1.469%
Investments Value
The schedule of investments, including the dates of maturity, provide adequate cash flow liquidity to meet anticipated expenditures over the next six months. The
investments and schedule of investments are in compliance with the City of Dublin Investment Policy, and all applicable laws and regulations.
~,~ .s~f ~ `~ 20
PAUL S. RANKIN, ADMINISTRATIVE SERVICES DIRECTOR DATE
(1) Accrued Interest represents the portion of interest earned as of the end of the quarter, that will be paid in a future month. Federal Securities typically pay interest twice a year
(6 month intervals).
~
~
~
City of Dublin
Portfolio Management
Portfolio Details - Investments
March 31, 2011
CUSIP Investment #
Issuer Purchase
Par Value
Market Value
Book Value Coupon Days To Days To YTM @ Maturity
Date Rate Maturity Call/Mat Cost Date
t;. . . ,. ~,au ~.,.~. ~ ;r .~.w...~ ., ~.
LpC~I GOVBCP-t118t)# 1t1YA5trit8nf
_.. _.~..r.w. rt.,.~.,.,_._.~.,~~.w.., ~,,; . ..~~
-Ot71~`: =~,, , , -~ < .~. ., ,, ~..a~ ~
,....._~~»~ ,,.~~ ~~tt~~~~
y ,, ~;' ~ ~
M ,
a ~ .; , ~
~' z~.
,~ .~.~;,~ F~
~rr~~` ~: ~,.,..,
~ `~ y., ~~ '
~,,. ~:.
.~
~,
~ ~
' ., s:~
,"
. ~a~"~?"~`, . .
y~~
CAMP California Asset Management Program 11/3/2008 63,428.51 63,428.51 63,428.51 0.18 1 1 0.18 N/A
LAIF LAIF 11/26/2008 37,942,705.58 37,942,705.58 37,942,705.58 0.52 1 1 0.52 N/A
.. ,,,_.sx... ~....e...a~x~;,~ac ~ - .,~,;m, , . ....
Sub.Totall- e e.;
Av ra ~~
. . ~,..~ .,....~~ ..~.. ,.,9, .,.; ~ ~ . .
~ ~ ~~~g ~x _
.: ,~_.:.. ,; ~.. ,,,~ ..,. . ,.~~ ,~:«_<.... ....
M~ : ~~
. ; .
.:.;~..~`...z~,. ... . .. f .:. :~ ), y. . _
;. ,. ,.
, ~,, 3$ t106 '[34 09
.,. ., a.~m., .~......x ..~ , .... ~. , q ........
~ r,; , ,
,:~38 QUB 734.09
..,~..,_,r,.,~ .r:,.,..,.> ,. , .. ... .. . , z ..,.:
~ ,
38 00& ~ 34 09
,. ._ ., ,yw~ .,. f«~~......,..,..~,. "'~ ~ y :..... .
~
~ ..{i:618
~.~r aa , ....:a,.~..~ ....... . . 1'
~, 1
~ . , > „. ie,.. . . ., ,n t
~,~ ;` 1
w.:~,> ~.,«:~ , ,~,~, . • :,. ,....:. ,
tl~51943
..~4-.... +,. „ , .,,,,..~ .
~:-
~. ,.."
. . ,F,. <--.
.., ~~ ..~.
i
A~ ~
,~~7 M
~~~'r
, a . .~9 , . .~.Y. , ~
31331XWU2
, ..
'rGY ^
.;. ~:v..a?.3r: .. " .. .
~
, ~.~ ~ ~.~ ~~~ , 6 , ,~
10049
.... .
;;i"~. ~.' •
.v k;':
-a~ . .. Y. .. ~• '.
<. ~~''~
. .,., .n . .. Y.: . '
., ~~ n ~~~ ~~
FFCB
y:.
'.~
.
:~u 6 ,rNS
8/31/2007
.. .
~.),
i~
~~,.
:.~,... ....° ~!>~'
1,000,000.00
..,y,,
9
.~ .
. ~;:
1,003,130.00
'~:~': ,.-
z~..a~
.
~:~,~:•~~~, -
~
1,000,030.23 4
~ ', Y
r,':` ,
.~~~~ ~~,~
.8
.
.
~ ~:s.
-
...:_ Fa.
25
~
, ry' ~
, .F...n '
25 x %4wc...
_~: t ,5"
q,
.~:,
,,~
,,, ._~.
4.75026
. ":..
..'- ...U
`~;
.
4/25/2011
3133XQ4C3 10065 FHLB 4/3/2008 3,000,000.00 3,088,320.00 3,005,213.22 3.5 344 344 3.3003 3%9/2012
3133XYF91 10089 FHLB 5/10/2010 4,000,000.00 4,039,640.00 4,000,000.00 1.25 ' 515 515 1.25 8/27/2012
3133XYUR4 10091 FHLB 6/30/2010 3,000,000.00 3,019,140.00 3,000,000.00 1.05 518 518 1.05 8/30/2012
313371 PY6 10097 FHLB 12/23/2010 4,000,000.00 3,988,800.00 3,984,950.00 0.55 613 64 0.77712 12/3/2012
3136FPM61 10098 FNMA 12/28/2010 4,000,000.00 3,988,720.00 4,000,000.00 0.875 638 89 0.875 12/28/2012
3133XYVW2 10092 FHLB 6/25/2010 3,000,000.00 ~3,024,270.00 3,000,000.00 1.25 697 697 1.25 2/25/2013
3128X1EJ2 10084 FHLMC 10/14/2008 3,000,000.00 3,210,540.00 3,014,369.06 4.25 783 783 4.00207 5/22/2013
3128X7WV2 10074 FHLMC 6/10/2008 3,000,000.00 3,021,030.00 2,996,301.56 4.05 802 71 4.11273 6/10/2013
3133XRFL9 10077 FHLB 7/25/2008 3,000,000.00 3,211,830.00 2,999,905.33 4.25 806 806 4.25023 6/14/2013
3133XYK53 10090 FHLB 5/21/2010 3,000,000.00 3,036,870.00 3,000,000.00 1.65 874 874 1.65 8/21/2013
3133XD6A4 10082 FHLB 9/26/2008 3,000,000.00 3,231,540.00 3,024,742.40 4.375 897 897 4.00007 9/13/2013
31331J6A6 10094 FFCB 12/23/2010 4,000,000.00 3,998,880.00 3,999,345.33 1.3 998 998 1.30616 12/23/2013
313371 BQ8 10093 FHLB 10/14/2010 3,000,000.00 2,953,260.00 3,000,000.00 1 1110 197 1 4/14/2014
313371MU7 10096 FHLB 12/21/2010 4,000,000.00 ~ 3,899,680.00 3,944,870.13 1 1149 1149 1.45083 5/23/2014
313370JS8 10100 FHLB 3/22/2011 4,000,000.00 3,959,400.00 3,984,194.62 1.375 1261 1261 1.49304 9/12/2014
3133XW2R9 10087 FHLB 12/30/2009 ~ 1,500,000.00 1,531,350.00 1,500,000.00 1.5 1370 274 2.95539 12/30/2014
3136FPHZ3 10099 FNMA 1/20/2011 3,000,000.00 2,974,110.00 2,997,384.83 2 1642 1642 2.02019 9/28/2015
3133725D2
~~ ~ ..a...w ~~
~ ~ . :
5ub 'Total /,:Ave
_. ,..~ _ ~
~ 10095
+w ': .~~x'.. ...
~ . ,.:.,,.a, .., ~... ~.
~a e , , . ~
... . .~ . , .
9 ~~ .. FHLB
.,.,:~~ ^K,;.~:~.,':. . ...,; ~p~.
~6. . .~.'m'. .;''~. ,,,,. ..~ .. . .
p. ., ~ . ~ ~~,
_ _ ~~` y a
~,_.~ ,_ ., .,,.,.~ .,~ _. . ~..~s~ti ~ ,: ~. 12/21/2010
rs~ ::'...~~
~"`~._: ~'~,
~
~ ~;W
~~~~,.. , ~ 2,000,000.00
>3.~k,,,. .. ~..........,
x _.... .. R. ~
~, 68 500 04Q.QQ
~. ,_ ~...A,~ . 1,987,600.00
;:r.. . .. ..:..: . . ....
...,:r .. <:.. . Y. _
~ . ;.-69 Si&8 ,?I10-QQ
~._ _.~, . ~> ~ 1,995,976.67
...~ ~...... z . :.....
.,C''A.. . ~ ~., :.. . P. . ..
,,~58 . 7 •283.3 ,
~~. .4:~, ~ .~
_.. e~ ., 2.125
. ~ .,e.:..
5 ~.. ~. £
, 3
~2 ~ 't
~, 1726
..~:r...~...,...,.. ;
:,s#"~.,a .,.: ~ .. .
.. .:.,
~~. ~ 8~$~3
. ,. 1726
. ~...
r:`"9. : .
~~~95 2.17009
,,..<.... . ,:
>,,:. ~ . .
~ ,~ t
~. ?,086~1~ 12/21/2015
.,. _.....~.
:: Y2, F ::'6' `c?.~
..;• ~ ,
,'~
~,.
Total / Average 96,536,663.68 97,204,773.68 96,483,947.06 1.435 535 422 1.46868
~~
~
~.
City of Dublin Investments By Type (March 31, 2011)
CUSIP
, ~-
US~A~ enc ~~ ..
~.~
~_.~. ~.~ ..~.~.
31331XWU2 Investment
#
_
~ > :~ ~ ,_
~ ~~_,.
0049
Issuer
: ~~w~~.
FCB Face
Amount/Shares
~
;: ,~~~
~ ~
~_ ~_ .~. .~
1,000,000.00
Cost Price
~~~~
,
~~ n
~
, ~
100.159
Book Value
_
~: ,~
,
~. ~~
~.~.
R ._
1,000,139.05 Coupon
Rate
w
. . ~
4.8 Maturity
Date
,
,.
~.;~. ~ ~~
~ .,
4/25/2011 Next Call
Date
~,
. ~~_ ~~~'
,,. ~_~-~, Next Call
Price
,~... . .
~~
.
31331 J6A6 10094 FFCB 4,000,000.00 99.982 3,999,285.33 1.3 12/23/2013
FFCB Total a,Q~~1;y(~C~Q,~J~p,:
3133XQ4C3 10065 FHLB 3,000,000.00 100.728 3,006,601:36 3.5 3/9/2012
3133XYF91 10089 FHLB 4,000,000.00 100 4,000,000.00 1.25 8/27/2012
3133XYUR4 10091 FHLB 3,000,000.00 100 3,000,000.00 1.05 8/30/2012
313371 PY6 10097 FHLB 4,000,000:00 99.5625 3,982,700.00 0.55 12/3/2012 3/3/2011 100
3133XYVW2 10092 FHLB 3,000,000.00 100 3,000,000.00 1.25 2/25/2013
3133XRFL9 10077 FHLB 3,000,000.00 99.993 2,999,894.58 4.25 6/14/2013
3133XYK53 10090 FHLB 3,000,000.00 100 3,000,000.00 1.65 8/21/2013
3133XD6A4 10082 FHLB 3,000,000.00 101.671 3,027,267.13 4.375 9/13/2013
313371 BQ8 10093 FHLB 3,000,000.00 100 3,000,000.00 1 4/14/2014 10/14/2011 100
313371 MU7 10096 ~ FHLB 4,000,000.00 98.5 3,940,487.01 1 5/23/2014 2/23/2011 100
313370JOS8 10100 FHLB 4,000,000.00 99.602 3,984,194.62 1.375 9/12/2014
3133XW2R9 10087 FHLB 1,500,000.00 100 1,500,000.00 1.5 12/30/2014 12/30/2011 100
3133725D2 10095 FHLB 2,000,000.00 99.787 1,995,763.67 2.125 12/21/2015
FHLB Total ' ~t?ti5~t2 ,~Q ~ ~~`~ ~`
3128X1 EJ2 10084 FHLMC 3,000,000.00 101.03 3,016,046.38 4.25 5/22/2013
3128X7WV2 10074 FHLMC 3,000,000.00 99.71875 2,995,879.69 4.05 6/10/2013 6/10/2011 100
FHLMC Total ~ ~pQp ~O~~~l~0i~
3136FPM61 10098 FNMA 4,000,000.00 100 4,000,000.00 0.875 12/28/2012 6/28/2011 100
3136FPHZ3 10099 FNMA 3,000,000.00 99.909 2,997,384.83 2 9/28/2015
FNMATotal ~;~~; C~~,f~,~p=:~ph-
Grand Total 58,500,000.00
ISSUERS: FFCB = Federal Farm Credit Bank; FHLB = Federal Home Loan Bank;.
FHLMC = Federal Home Loan Mortgage Corporation ("Freddie Mac"); FNMA = Federal National Mortgage Association ("Fannie Mae")
--~-
~
~
~
~~ i~
QUARTERLY INVESTMENT REPORT
Third Quarter Fiscal Year 2010-2011
March 31, 2011
Section II - Investment Charts
INVESTMENT CHARTS FOR THE QUARTER ENDING MARCH 31, 2011 ~ 1
~
INVESTMENTS BY TYPE (March 31, 2011)
MONEY MARKET
.03%
-.x,;., ~°,x:~
'
'
~
~Y
.~~ ~ ~.~ LAIF
'
"~ ~' 39.3%
~
~
~:~~
~
y'
~~~
'
~
FIDFRAL `
~
~ -~.
~sa~
S 'TiCUR1TIGS' ~
~
'~a
"~ r.;•
60.6%
CAMP
.07%
INVESTMENT CHARTS FOR THE QUARTER ENDING MARCH 31, 2011 ` ~'
~
March 31, 2011 - Portfolio Maturities
$40,000,000
$38,036,664
000
000
$35
,
,
$30
000
000
,
,
$25
000
000
,
,
$20
000
000
,
,
$15
000
000 ~. ~
000
000
$19
,
, $18,000,000 ,
,
$10
000
000 $12,500,000
,
,
$4,000,000 = $S,OOQ000
$5
000
000 ~~`
,
, -
$0
No Maturiry (1 Yr or Less) (1 Yr - 2 Yr) (2 Yr - 3 Yr) (3 Yr - 4 Yr) (4 Yr - 5 Yr)
Date
~ i~
~
QUARTERLY INVESTMENT REPORT
Third Quarter Fiscal Year 2010-2011
March 31, 2011
Section III -
Listing of Monthly Investment Transactions
City of Dublin
Cash / Checking Activity Report
January 1, 2011 - January 31, 2011
Issuer Transaction
Date Comment Deposits Withdrawals Interest Received Balance
GaC~f~or
n~a"~A~ss~t
.Mana~e~ment~
Pro ~ r
a m~` C~AMP~
(
~ 63
400
51
~
,
„
~ ..;
,,~
,
,
.
California Asset Mana ement Pro ram 1/31/2011 Interest on account 9.42 63,409.93
Subtotal and Ending Balance
: ~ ~
~ _
~
: ~ ~
~"~, „
~
`~.~
~~ YO~f10
~~ ~p~{~t! "
~
~
;
r ~~42~
c
F ~`~ ~63~40~ 93 '
~
,
~~ ,
~~~. ,
,
~ ~~
. ~_.,~..~ ~. , ~ , ~„
~N~ .,~.~ ~,..,,_~T~-
_~:
~ a~ ~,~,,._~~~ ~~~~ ~ ~ ~
3F~,tC~G~''l~. ~ ~.~,~~~t~~~~i'1!'y1E~Il~~ ~~C~~d~l0 F ~ 1~~' 35,101.15
Fidelit US Government Portfolio MM 1/14/2011 Interest on inv# 10088 24,375.00 59,476.15
Fidelit US Government Portfolio MM 1/14/2011 Full call inv# 10088 3,000,000.00 3,059,476.15
Fidelit US Government Portfolio MM 1/20/2011 Accrued int aid inv#10099 18,666.67) 3,040,809.48
Fidelit US Government Portfolio MM 1/20/2011 Purchase of inv# 10099 (2,997,270.00) 43,539.48
Fidelit US Government Portfolio MM 1/26/2011 UB Fee collected 875.00 44,414.48
Fidelit US Government Portfolio MM 1/26/2011 Pa mt of fees 875.00) 43,539.48
Subtotal and Ending Balance
~-~~~F~ ; .~.~ ~.~~: ~ ~ ~ .~» ~~z:~;~R ~ ,;:~~ 45,058,699.35
LAI F 1/25/2011 565,000.00 45,623,699.35
LAI F 1/27/2011 700, 000.00) 44,923,699.35
~ , ,~ ~
Subtotal and Ending Balance ~~~ '~~ ~~ ~~ ~ '"~65 ~pp:t~4' ~ ~ ~7'pQ'ppn pp ~t}~40~ ,44~92~ 699 35~
a~E '`,~,. ~~=~., ~,~,~ .a~. r~,~~~ ,~.~,~~: ~~ o,~;:~,~e~..,. ~~
TOTAL 3,590,250.00 (3,716,811.67) 9.42 45,030,648.76
~
~
City of Dublin
Cash / Checking Activity Report
February 1, 2011 - February 28, 2011
Issuer Transaction Comment Deposits Withdrawals Interest Received Balance
Date
L~~I1tf3C1111~ASSSt~MAt18''° @!11@I~#~PC~+D ~'~171~tC~i~IMP}~~ 63,409.93
California Asset Management Program 2/28/2011 Interest on account 8.83 63,418.76
Subtotal and Ending Balance -~;~ ~r ; ~~ ~ `" ~ ;~ ' {~~~(t ~ Q~ ~}~ ~$~ ; ~~g~g~
~ .,. __ , ~ ~~~, ~ ~~ _ : ~ , ~ ~. »~~ ~.,~ ;~9~„' ~~ ~r.
~Fif~@~1#y~~U$~~O„„Y~@t'C,11T1~t't'~~ROI"~~O~it}~~~ `~ ~~. ~ ~~ 43,539.48
Fidelit US Government Portfolio MM 2/1/2011 Interest on account 21.33 43,560.81
Fidelit US Government Portfolio MM 2/1/2011 Interest on inv# 10037 50,500.00 94,060.81
Fidelit US Government Portfolio MM 2/1/2011 Matured inv# 10037 2,000,000.00 2,094,060.81
Fidelit US Government Portfolio MM 2/25/2011 Interest on inv# 10092 18,750.00 2,112,810.81
Fidelit US Government Portfolio MM 2/28/2011 Interest on inv# 10089 25,000.00 2,137,810.81
Subtotal and Ending Balance ~~ :F f~ '~ ~ r~' ~ ~ .~; ;; 2~0~4~ 5t~,00~ ~ ~~ t} .00 ,~~Z'I~3 ~`~~'1~~~', ~1hp 81~
~,.
~:r~~~ :. ~~,~~ . r ~ ~~ ,s ~~~~ :. ~'~'~ ~ ~ ~ ~', ~ 44,923,699.35
LAI F 2/4/2011 930, 000.00 45, 853,699.35
LAI F 2/16/2011 (7,000,699.35) 38, 853,000.00
~~F 38,853,000.00
LAI F 38,853,000.00
Subtotal and Ending Balance ~'~: '~ ~4.~~ ..~~, ~, ~: ~m ~~ ~ ~~ .., . ~, :~93'Q~C1Q D0~ ,, .:{~~~00~~6~9 ~5~~ ,~ ~~~C10p~~~, ~.8:`853:O:Ot1~4t~~
TOTAL 3,024,250.00 (7,000,699.35) 30.16 41,054,229.57
0'
~
City of Dublin
Cash / Checking Activity Report
March 1, 2011 - March 31, 2011
Issuer Transaction Comment Deposits Withdrawals Interest Received Balance
Date
~8~1'~OCI111 ASS~e~ Managem,ent=t~rograr~~{~~QM~} r~
~. ,.~,~,~ ~ ' 63,418.76
California Asset Mana ement Pro ram 3/31/2011 Interest on account 9.75 63,428.51
Subtotal and Ending Balance
~If~E3~l~y,~'.a'~'~~~11/@CC~ltl'1~81 ~U~~O~10~~ .,,~`~x ,,,,~~~~,:~n' 2,137,810.81
Fidelit US Government Portfolio MM 3/1/2011 Interest on account 19.00 2,137,829.81
Fidelit US Government Portfolio MM 3/9/2011 Interest on inv# 10055 40,133.75 2,177,963.56
Fidelit US Government Portfolio MM 3/9/2011 Interest on inv# 10065 52,500.00 2,230,463.56
Fidelit US Government Portfolio MM 3/9/2011 Maturit of inv# 10055 1,655,000.00 3,885,463.56
Fidetit US Government Portfolio MM 3/14/2011 Interest on inv# 10082 65,625.00 3,951,088.56
Fidelit US Government Portfolio MM 3/22/2011 Accrued int inv# 10100 (1,527.78) 3,949,560.78
Fidelit US Government Portfolio MM 3/22/2011 Purchase of inv# 10100 (3,984,080.00) (34,519.22)
Fidelit US Government Portfolio MM 3/23/2011 Transfer in from LAIF 35,000.00 480.78
Fidelit US Government Portfolio MM 3/28/2011 Interest on inv# 10099 30,000.00 30,480.78
Fidelit US Government Portfolio MM 3/31/2011 interest on account 48.81 30,529.59
Subtotal and Endin Balance
9 ~~`
~~ ° ~~y~_ ~ ~ ~ ~ ~ ; "~~ ~~
~ Er. ~ k ~ " ~
~~; 1,$78,~5~,8 75 ~°. ~ ~ ~
~.r. 3,9~,5,~Q° .78 , ~ ;
~67,$1~~ '~~~ ~ ~ g
:,~, ~~~,~30,529~59~
Subtotal and Ending Balance
TOTAL
5,538,258.75 (8,608,607.78) 52,783.14 38,036,663.68
~