Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda Packet 010710
; ARCH WE COPY CITY CLERK SPECIAL MEETING ATASCADERO CITY COUNCIL Thursday, January 7, 2010 9:00 a.m. City Hall — Council Chambers 6907 EI Camino Real, Atascadero AGENDA ROLL CALL. C. MANAGEMENT REPORTS. 1 City Treasurer Retorts ■ Fiscal Impact: There'is a savings of about 64 staff hours or roughly $3,000 per year if Council switches from monthly reporting to quarterly reporting ■ Recommendations. Council 1 Review and file City Treasurer's Reports prepared quarterly for the periods April 2008 through June 2009, and monthly for the periods July through November, 2009 2 Direct staff to prepare quarterly reports instead of monthly reports and return with a modified Investment Policy reflecting this change [Administrative Services] PUBLIC COMMENT ADJOURNMENT STATE OF CALIFORNIA ) COUNTY OF SAN LUIS OBISPO ) CITY OF ATASCADERO ) I,Victoria Randall,Deputy City Clerk of the City of Atascadero, declare under penalty of perjury that on December 30, 2009, the foregoing notice for the January 7, 2010 Special Meeting was posted on the doors of the Atascadero City Hall, 6907 EI Camino Real, Atascadero, CA 93422.1 low Victoria Randall,Deputy City Clerk 1 C-1 } 01/07/10 Isis r Is a rj CAD Atascadero City Council Staff Report - Administrative Services Department City Treasurer's Reports RECOMMENDATIONS Council 1 Review and file City Treasurer's Reports prepared quarterly for the periods April 2008 through June 2009, and monthly for the periods July through November, 2009 2 Direct staff to prepare quarterly reports instead of monthly reports and return with a modified Investment Policy reflecting this change REPORT IN BRIEF The City Treasurer is elected by the voters of Atascadero every four years The Treasurer's primary responsibility is to invest the City's funds considering safety, liquidity and yield Staff supports the Treasurer in conducting their responsibilities in a variety of ways One of which is in preparing the Treasurer's Report. Along with internal asset management, staff prepares external Treasurer's Reports for Council review and approval Treasurer's Reports provide a record of the municipal funds on hand and how they are invested at given points in time Historically, these have been done monthly, however, the economic downturn caused a reorganization in staffing assignments, focus, and workloads and the Treasurer's Reports were switched to a quarterly reporting basis in April 2008 When the City Council Finance Committee met in July 2009, staff was directed to continue to prepare reports on a monthly basis The quarterly Treasurer's Reports for the periods ending June 2008, September 2008, December 2008, March 2009, and June 2009 are attached to this staff report, along with the monthly reports for the periods ending July through November 2009 DISCUSSION The City of Atascadero has legal, ethical, and fiduciary obligations to the citizens of 1%8W Atascadero to preserve and grow the City's cash and investments These obligations 2 are taken very seriously by the elected City Treasurer and staff, and prudent and adequate steps are outlined and followed to ensure the safety, liquidity and yield of these assets One of the key pieces of this puzzle is the City's Investment Policy This Policy governs internal procedures surrounding investments of the organization's assets, specifies permissible types of transactions, and above all, ensures the safety of the City's assets The ultimate goal of the Policy is to enhance the economic status of the City while protecting its pooled cash While the final responsibility for investment activity resides with the City Council, idle cash management and investment transactions are the responsibility of the City Treasurer or designee The Treasurer ensures that City funds are invested in a manner consistent with the Policy and that they achieve maximum safety, liquidity and yield In accordance with the requirements of the Investment Policy, monthly Treasurer's Reports are prepared The Reports indicate • Investments by type • The name, amount and maturity of each investment instrument • The balance of cash and investments at a point in time • The purchases and sales or maturities of investments • Proportion of assets held in different types of investment instruments • The liquidity of the portfolio as dictated by maturing investments • The yield of the individual investments, as well as the yield of the entire portfolio In addition to the transparency provided by the Treasurer's Reports, there are multiple other internal and external controls that work in concert with the Investment Policy to ensure safety to the City's assets Some of these checks and balances include • Monthly reconciliations of the cash and investments held by the City o One staff member reconciles monthly the City's bank account o A different staff member prepares a monthly investment reconciliation and Treasurer's Report o A third staff member reviews the Treasurer's Report and reconciliations o The Director of Administrative Services reviews the reconciliarions, monitors investment activitiy, and approves the Reports o The City Treasurer reviews and approves the Report • All cash and investment accounts are reviewed annually by an independent audit firm as part of the City's annual audit process • Staff participates in conference calls with Local Agency Investment Fund (LAIF) • City Treasurer and staff receive email alerts from Federal Deposit Insurance Corporation on bank closures • City Treasurer and staff are in communication with the City's investment broker • Government Accounting Standards Board requirements are met • State and Federal legislation. 3 Although the City's Policy requires the preparation of a monthly Treasurer's Report, there are no other regulations outside of the City that require it The State of California has been inconsistent in legislation governing municipal investment reporting At one time, the State code required periodic investment reports. However, the State has since changed the code and this is no longer required The State code does not mandate investment reporting, nor does it impose any liability for failure to report. Specifically California Government Code §53646(b)(1) states that the City Treasurer "may render a quarterly report to the chief executive officer, the internal auditor, and the legislative body of the local agency " Subdivision (d) of that code section further states that "the legislative body of a local agency may elect to require the report specified in subdivision (b) to be made on a monthly basis instead of quarterly " However, this same code section's final subdivision asserts (h) In recognition of the state and local interest served by the actions made optional in subdivisions (a) and (b), the Legislature encourages the local agency officials to continue taking the actions formerly mandated by this section However, nothing in this subdivision may be construed to impose any liability on a local agency that does not continue to take the formerly mandated action Essentially, subdivision (h) indicates that the California Government Code encourages investment reporting, but does not require it. Similarly, Government Code §53646(g) used to require local government agencies to submit their second and fourth quarter investment reports to the California Debt and Investment Advisory Commission of the State Treasurer's office Because this requirement sunset on January 1, 2007, it is also no longer applicable to local agencies. As indicated earlier, the Treasurer's Reports are one way of communicating investment information to the Council City staff have been preparing Treasurer's reports since City's inception in 1979 The reports are prepared by the Administrative Services Department. The department is also responsible for• • City budget/reporting • Accounts payable • Cash receipts/accounts receivable • Payroll • Budget preparation • Annual audits • Budget monitoring . Assessment District administration • Grants management • Maintaining accounts • Fiscal analysis of programs and • Banking and bank reconciliations proposals • Financial analysis and forecasts • Business license renewal . Expense and revenue tracking • Workers' compensation . City credit card management • Employee benefits • Cell phone management • Litigation management • Interdepartment office supplies • City Hall rehabilitation project • Travel policy compliance • Internal and external requests for • Fixed assets 4 information • Purchase order review and • Preparation of state mandated compliance reports 4 state controller's reports, . Coordination of various statement of indebtedness, AB1389 state/federal compliance audits Statement of Pass-Throughs, • Deposit/ bond administration Annual Housing and Community • Maintenance of internal controls Development Report and training These monthly reports were submitted to Council through April 2008 About that time, the reality of the economic storm had begun to sink in Substantial staff resources were focused on the Council's highest priorities of budgeting, fiscal analysis, financial reporting, forecasting, and the second appeal to FEMA on the Historic City Hall The internal controls remained in place, as did the continuation of monthly reconciliation and monitoring of cash and investments However, with staff resources intently focused on weathering the economic storm and focusing on fiscal priorities, staff compensated by preparing quarterly reports instead of monthly reports However, these reports that covered the period April 2008 through June 2009 were not brought to Council because the Investment Policy still required them monthly It was the intent of staff in Summer 2008 to request the Finance Committee and Council to change the reporting requirements of the Treasurer's Report from monthly to quarterly to make the most effective use of limited staff time However, the focus remained on Council priorities, namely keeping the budget balanced and scrutinizing expenses and cost savings alternatives, and, therefore, the revision of the Investment Policy that governed the Treasurer's Report requirements was not brought to the Finance Committee until July 2009 The Finance Committee elected not to change the Investment Policy at that time, and indicated that monthly reports were preferred Staff set aside other priorities to prepare monthly Treasurer's Reports for the period of July 2009 through November 2009 Since staff had already prepared quarterly reports for the quarters ended June 2008 through June 2009, those are presented here as is in the interest of staff ,resource conservation As a result of the monthly report preparation, additional overtime has been paid and less time has been available to focus on other fiscal priorities As indicated in the current Policy, the Treasurer, the City Manager and the Director of Administrative Services carry the day to day responsibility to maximize the City's assets and ensure safety, liquidity and yield These individuals receive critical investment data as it becomes available so any necessary actions can be taken The City's investments other than LAIF are typically medium term, stretching out between one and five years The information provided on a quarterly report is therefore not significantly different than information prepared on the monthly report. Additionally, the Treasurer's Report was specifically created to report on a particular period of time in the past. It does not indicate current data, nor does is forecast what should be invested in for the future While the City has historically prepared monthly Treasurer's Reports, the new reality is 5 that there just aren't enough staff resources to prepare the lengthy formal report on a "l monthly basis and still properly manage all of the other Council fiscal priorities Transparency continues to be maintained with the quarterly reports All of the monthly investment and banking statements remain public records and are available at City Hall for Council or community viewing Staff is therefore requesting that Council consider changing the Investment Policy to reflect required quarterly reporting instead of monthly reporting Certainly if Council identifies monthly formal reporting as a top priority, staff will prepare the reports as requested However, because of the staff resource limitations, staff would then request direction from Council regarding which of the other tasks that are now being performed are less of a priority and can be discontinued FISCAL IMPACT There is a savings of about 64 staff hours or roughly $3,000 per year if Council switches from monthly reporting to quarterly reporting ATTACHMENTS 1 April 2008—June 2008 Quarterly Treasurer's Report 2 July 2008 —September 2008 Quarterly Treasurer's Report NOW 3 October 2008— December 2008 Quarterly Treasurer's Report 4 January 2009 — March 2009 Quarterly Treasurer's Report 5 April 2009 — June 2009 Quarterly Treasurer's Report 6 July 2009 Treasurer's Report 7 August 2009 Treasurer's Report 8 September 2009 Treasurer's Report 9 October 2009 Treasurer's Report 10 November 2009 Treasurer's Report 6 Attachment 1 1918 Y 1978 (AI1Eg4� For the Quarter Ended Atascadero City Council June 30, 2008 Staff Report - City Treasurer June 2008 Investment Report RECOMMENDATION Council approve the City Treasurer's report for April through June 2008 REPORT IN BRIEF Cash and Investments Checking $ 605,204 Money Market Accounts 1 Certificates of Deposit 6,803,592 Government Securities 5,491,638 LAIF 26,773,582 ;fir, Cash with Fiscal Agents 126,731 Cash in Banks at June 30 2008 $ 39,800,748 Deposits in Transit - Outstanding Checks (227,038) Cash and Investments at June 30 2008 $ 39,573,710 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 04/29/08 Warren Bank CD $ 100,000 04/29/11 04/30/08 Capmark Bank CD 100,000 04/30/13 04/30/08 Discover Bank CD 100,000 04/30/13 05/02/08 River Cities Bank CD 100 000 11/02/11 05/14/08 Advanta Bank CD 100,000 05/14/13 05/14/08 First Bank of Idaho CD 100,000 11/14/12 05/21/08 American Comm'ty Bank CD 100,000 11/21/12 05/22/08 FFCB#31331YP61 gov't security 500,000 05/15/13 05/27/08 Citizens Bank CD 100,000 05/27/11 05/30/08 Medallion Bank CD 100,000 05/11/11 06/24/08 FNMA#3136F9UP6 gov't security 500,000 06/24/11 06/30/08 FNMA#3136F9UE1 gov't security 364,635 06/30/11 Page 1 of 13 8 Investment Activity(continued) Securities Matured Maturity Date Description Type Original Cost Amount Matured 04/04/08 Amcore Bank CD $ 97,000 $ 97,000 04/07/08 Discover Bank CD 97,540 98,000 05/13/08 First Security Group Bank CD 97,359 98,000 05/21/08 FHLMC#3128X1 CD7 gov't security 300,000 300,000 06/04/08 Gold Bank CD 98,000 98,000 06/06/08 Minnwest Bank CD 98,000 98,000 06/19/08 Doral Bank CD 98 000 98,000 Securities Sold/Called Prior to Maturity- Transaction/ Original Cost/ Gain/(Loss) Tran Date Description /Type Maturity Sale Price on Call Full Call Federal Home Loan Bank $ 345,000 $ 345 000 $ - 04/10/08 government security 07/10/08 Full Call Fed Home Loan Mtg Corp 298,950 300,000 1,050 04/18/08 government security 04/18/11 Full Call Shore Bank 100,000 100,000 - 04/23/08 certificate of deposit 10/23/12 Full Call First Banking Center 100,000 100,000 - 04/25/08 certificate of deposit 10/25/12 Full Call Commerce Bank 97,000 97,000 - 05/13/08 certificate of deposit 11/13/09 Full Call FHLB #3133XMV65 500,000 500,000 - 05/21/08 government security 11/21/12 Full Call Provident Bank of MD 96,022 99,000 2,978 05/30/08 certificate of deposit 05/28/10 Full Call Banco Bilbao 96,111 97,000 889 06/30/08 certificate of deposit 06/28/10 Full Call Meridian Bank 99,000 99,000 - 06/30/08 certificate of deposit 12/29/09 Other Reportable Activities None 9 Page 2 of 13 CITY OF ATASCADERO TREASURER'S REPORT CASH& INVESTMENTS ACTIVITY SUMMARY FOR THE QUARTER ENDING JUNE 30, 2008 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at April 1, 2008 $ 258,603 $ 34,154,240 $ 126,260 $ 34,539,103 Receipts 11,613,633 197,921 471 11,812,025 Disbursements (6,550,380) - - (6,550,380) Transfers In 8,517,983 13,234,635 - 21,752,618 Transfers Out (13,234,635) (8,517,983) - (21,752,618) Balance per Banks at June 30, 2008 $ 605,204 $ 39,068,813 $ 126,731 39,800,748 Deposits in Transit - *woof Outstanding Checks (227,038) Adjusted Treasurer's Balance $ 39,573,710 Page 3 of 13 10 Z Q 10 M o o `O o �O 00 M OD �O V1 M Q Q V1 a M ^ ^ N ^ Q �O N1 .-• �• h h W N D: O^ a lO O a N O a a a a o0 N Q 00 00 V a Cl a w 10 C, a a a a a a o a a a a a a ��GG b9 b9 N ^ a O O M O a O O O O O O O O O oo 10 O O M O a O O O O O O O O O vt Q O O �O O Vt O O O O O O O O O a a Q a \D a a Vi Vl r r a a a V) a a a a O a a a a a a O � N Uz � o �v U �Y ti 0. q O O M O O O O O O O O O O O 0o O O O M O O O O O O o O O O O O O O O o O o O U j rn a rn vQ rn rn C, C, o rn rn rn rn rn rn N 69 q o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a yi \ N N o0o Voi ON O lO b b h q !Y co � o U o � � N o W o 0 0 0 0 0 o 0 0 0 0 0 0 0 0 O Vt O Vl O O O Z N M M M eel Q M Q Q Q M M M M raj 'Moe _ O , � U \ W V a t. lo lo lo o' E' o� o o � o 0 0 on a a FF W W W W W W W W W W W W O O O O O O O F O O O O O O tz: U V U U U d U U U U U U U U C7 U U U U U U W VJ M e+t M M Ml Vl M h •ct < Q Q Q Q Q V Q = o o p N a o o Q N M r\1 O a o a y o a+ U o Oa E ^ ° Z a .° dz CU p a p� d ° 3 u o d d a o¢ ° ? ° a•- v] a F Z t m a # Ia. o 2 o S �i abi E E o 3a e d xz Uw w wu vv ¢ o wx wt� ° v 'ww d Cm o0 00 00 00 0o ao ao ON cy o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 rz O_ N M O lo Ol N M r\O+1 O �L 11 N a 4� \ M ao 0 r �0 0o M o 0o r r r N r 0 o rn It rn ..• o o � � � a,C, rn C, a o. a, rn rn e M 0. 0 0 0 0 o M v o0 0 0 Cl 0 0 0 Cl C. 0 0 0 0 0 0 o r ao 0 0 0 0 C' 0 0 0 C 0 oo r o 0 0 0 0 0 0 0 W Ly r r r' v v o0 00 0o v r r roo r' 0 r p o, rn o rn o a N rn a ol a rn rn of rn rn o. 4 Ln O Ln U � 4 C 0 0 0 0 0 0 0 0 0 0 o O o 0 0 o O 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 C C Ci O o 0 C C 0 0 0 0 0 0 U j rn O\ C, C\ a o o rn rn rn ol rn rn rn rn rn rn q o 0 0 o a e o o e o e e o e o 0 0 v a a M �0 Vl Vl V1 V1 V1 �O Vl O N M N N 0\ T O � M M M Now U 4 � (r N o C M �D Vi V'i Vl r Vl N r O N M N N U O? O o r+1 M M M M N M M M V V 7 R V M M O DO C G L y U � cyC� Ln r r �, o 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 W w w w w w w w w w w w w w w w 0 0 0 0 0 c 0 0 0 0 0 0 0 0 0 0 « °❑q❑q' « «�yy « « « « « « U 0 U U U 0 G U U U V V U U U U U w w w^ w^ w^ GG tv w f f f f f f > f f f f f f f f f f d U u u u u U U U U U � U v U U U U U U U U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C-4 M O O 10 N - M M O O O N p N M fn a — \0O 3 3 r rn rn a 0 0 0 0 0 -- 0 0 0 0 0 0 0 0 0 0 4 CL 0 Y U e \ Y w d C M 0PQ u 00 Y ,y h a , es cn �L'Z e a ry�ry e o S 0.1 o ¢ o a q 0 7 a z E U C� O x O W zo �o� U « Y E d n Y U o .ted.. c bo i Y ty a°Z E [n o f a p u « a 3 p m a v .H. W o W no. 3y U*' L) Fa U WU a«1N zcn 3fn acn z o r°nC] UVn w [= 0. C11rn rn rn o. a o, a rn rn rn o. rn rn oy o, o, rn N N M r+1 i�l M 7 < Yt Vl b 1O �O t� C7\ O O O O O O O O O O O O O O O O O 12 e � � 00 o vi rn m M M r vi o+ vi 10 M C\ 10 �o 0o N GO oo M oo vl N r N O Ch r r W h Vi N N b h h b N O' r Vl ty D of o, rn rn o 0 0. rn rn o, rn - o, rn rn rn rn o J of 0 0 0 0 0 0 0 0 o O O O o 0 0 0 0 o O o 0 0 0 0 0 o Cl O o 0 0 0 0 0 0 o Oo 0 0 o O o 0 0 0 0 0 0 0 0 Lt, LV r - o; o o r' ao - - w 0 p ! o, o, rn o 0 0 rn rn rn o, o rn o, rn o. o. O El OLl U ` � W O rY 4 G 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 C. 0 0 0 0 0 0 0 0 0 0 o O o O o 0 0 o O o o O o o O o C 0 0 0 o O o V j rn a a o o rn a a rn rn o a rn rn rn rn o e � 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ci o v o 0 o o9 O v o n o 0 0 O V1 Vl O O N Vl r N M N Q M N M M UC � o � v1 E� N e p^ Q o o e o e o e e o e e o e o 0 o e we o� O O O O O O O N O N O O O 'V y p w � 0 o y 0 0 0 0 0 0 0 '� 0 0 0 0 0 0 W w w w w w w w w w w w w w w w w � 0 0 0 0 0 0 0 0 0 o q o 0 0 0 0 0 w w w w w w w w tr. w U U u u iv v u cv u u u v u U Ve M O e\+1 f, of O .-. [�` [�` N M Q 10 10 O O O O O O O O O O O O O a eu a y93 t 0 On ias n ed w d z r go °o o zw > O = a 9 a C7 w 3 0 a o °o Z a d Q 44c > j T 5 v 5, °o a v Y 5 0aeo:3 o u 6 � u V w o 1 u C o H3 xca Uo 3v, ww °.a3 dw wx xx 3v wU wv, u � xx ww 3x rn o, a a N O — N m 10 10 ol O O O O O O O O O O O O O 13 N 00 N m Vl v N D\ N N M V'1 00 M h D\ O, 10 O, O, 69 Z 7 O O m O O O O O O 10 0 o 0 0 o r o 0 0 lo 40 w v oo 0, 0 0 0 .+i o o M o 0 0 Ln Ll O U � o 0 ty U 4 A � 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 o O o 0 0 0 0 o O o 0 0 0 0 C 0 0 0 0 0 O O O� N O O a e a o 0 o e e o 0 0 0 o 0 0 0 O J v n v o 0 0 v o0 0 o M o 0 o v o v v It v It �n gt4yo N Z o W e e e e e o 0 0 o e o a o 0 o e o 0 [„ pa vi vi vi vi O O O O O O o O o O �n r V1 m V1 O N OO O O O O N ee O � (� O O O O O O O O O O ry' U u y N U U U Q Q A A A Q Q y Q (n Q Q (n V] n 4 C O O q O O w O O O O O � G q C EN wSpto ^"y Y w O 0 U u 12 > > o 0 0o y U U U U U U V U C7 U U C7 C7 t7 hv� �n vi vi r r oo �D �O �0 0o r o0 oa o0 0o r Q o o O o o O o 0 o O O o O o o O o EW„ r m v •- o r o. o r o v o O O O O O O O O O O O O O 4 00 U c y U ��✓1 m df F F S .7p a � ew r S >C a a E aF Y = Q a EM" aM o � ty o aU n CO 0U ,'den a m � u '>. � # z � �y o u V. ac ac a, o y a V u w y F m a cd L" 4 aC i 'n cn En a wv mw wan wcwU wU a \N-� N N Vt Vl Vl CD C O O O O O O O C>O O O O O O O 14 Q h N N N h Q Q h N O N N V O O vt vii N O O h r ^ Q N N N m LT4 41 ro b T O h r M Yl Vt rl h N v O Oo to o0 _N h Q Q M o0 O o0 00 �O O O h r M W to Vt .-» m to h N w 0o m M h O` b O, O O, O, c, O Cl cl O, O Ol °, O. O Q, O, O, Q Q v Q N Q 69 F O O O O O O O p Cl o O O O O O O Z O O o O O O O O O O O O O O O p OO O� O O O O O O O O O O O O O O O O O O O, O, O O O O OLl L41 O �U U � W U ^ �Y 4 A 0 0 o 0 0 0 0 0 o O o o o 0 0 0 0 O o o O O O p O o o O o O o O o 0 0 o O o p c 0 0 c c c 0 o O O o 0 W Cl C. 0 °a,, rn o 0 0 0 0 0 0 0 0 0 o 0 J ds In 0 0 o 0 0 o 0 0 0 o 0 0 0 00 0 0 p E. o rn o o M o 0 o v to o 0 0 0 0 a s � o Q vi fn N ,a h r v� N v, C � o v � a Z M cFil 00 o o e o 0 0 o o 0 0 0 c e o 0 O O O O ti O M O O O Vi vl O O O O O N O M N M ,O �D ,O r h Y1 N Q n. •� 0 ; � U ti W O a o o o 0 0 c ° a ° ° ° $. wEn Q Q w Q ti A Q A Q A A [` 4 O p o O o O C O o o O O G O F O U tr. U U U U U U U U U �: w- w^ � eq kc; > > > > { > v U u u u c7 U u 0 u u U v v c7 U � k7 0o h oo r r n n o0 0o r h r h ao 00 00 00 0 0 0 0 0 0 0 o O O o p o C o o O VE� N ,a P .\» w O N N M N N N M o N M O N N M ry Q n N ^ o0 oo O O o n N ^ Q O O O �--� O D O O O O O 4 7 G L L in Y O Y O Y Q Y a U Y Y 0 CO paa �_ � b eao a �'o e Z S ' Y a r a 9 z � > lk a u a ° I3 "9 5o w 'a a y d rA w > �1- �a3 w7v 3 u5 wz � w � waC a3 w � � � wu oo O O 15 O h v o c e N o 0 V �o � o 00 -• ..• a ol O N N M M 'G to vi �pppp CD I2I.� O O O r r Wi !I O O O 10 `Ool N N ti O 'GG vi O Ln [. F O M M U 6 ti v v w N 06 Qk, -a r a A H V ti U_ O O O \O 7 U i V OO O N r n O O W w O O O of a o p > o d � � p a o °� R O N b 0 Q Z d 0 rn v o Q a �`�O O C O U 3 � N y O O O 4 x O w U � r\ o 0p q Y Q 0. ti b F o > m a [ N ti p mcn > b p > d 0 0 0 a 3 U .: F 16 City of Ataseadero Investments by Type June 2008 Government Securities Cash with Other Certificates 14% Fiscal Agent 0/a n of Deposit 1% 17% i LAIF (' 68% Investment June 2008 LAT $ 26,773,582 Certificates of Deposit 6,803,592 Government Securities 5,491,638 Cash with Fiscal Agent 126,731 Other 1 $ 39,195,544 17 Page 10 of 13 City of Ataseadero Investments by Maturity June 2008 One Month to One Year One to Wit 7% Five Years One Month 24% 1% On Demand 68% Investment June 2008 On Demand $ 26,773,583 Within One Month 92,469 One Month to One Year 2,879,188 One to Five Years 9,323,573 $ 39,068,813 Page 11 of 13 18 City of Atascadero Investments by Custodial Agent June 2008 Union Bank 31% Bank of New York 1% Other 0% State of California 68% Custodial Agent June 2008 State of California $ 26,773,582 Other 54,634 Union Bank 12,240,597 Bank of New York 126,731 $ 39,195,544 19 Page 12 of 13 City of Ataseadero Investment Yield vs. 2-fear Treasury Yield For the Quarter Ended June 30, 2008 6.00% 5.00% ms!µ 4.00% 777 3.00% 2.00% - k 1.00% .J.00% 01 QA OA PIA O� O� 01 O� ZOO o� 0 ,Lo ti� ,Lo ,LO ry0 rtio r10 LO ,Lo ryo le 61� °c �o ��o �c�`� �tio� eF� eF� ��a ,o��a �.ac PQ �• hoc P 09 City Yield --0a2 Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield June 2007 48 4.23% July 2007 482% 412% August 2007 482% 387% September 2007 482% 374% October 2007 477% 3 71% November 2007 4 71% 342% December 2007 463% 330% January 2008 455% 2.87% February 2008 4 31% 2.50% March 2008 402% 2.19% April 2008 373% 2.39% May 2008 345% 2.63% 1%w June 2008 335% 2.86% Page 13 of 13 20 Attachment 2 '�Mwwr° 1918 , 1979 For the Quarter Ended Atascadero City Council September 30, 2008 Staff Report - City Treasurer September 2008 Investment Report RECOMMENDATION Council approve the City Treasurer's report for July through September 2008 REPORT IN BRIEF Cash and Investments Checking $ 926,185 Money Market Accounts 1 Certificates of Deposit 7,114,375 Government Securities 5,291 638 LAIF 23,347,631 ,,, Cash with Fiscal Agents 84,238 Cash in Banks at September 30 2008 $ 36,764,068 Deposits in Transit - Outstanding Checks (544,055) Cash and Investments at September 30, 2008 $ 36,220,013 Investment Investment Activit Securities Purchased Purchase Date Description Type Cost Maturity Date 07/16/08 Sallie Mae Bank CD $ 99,950 07/16/10 07/17/08 Washington Mutual Bank CD 100,000 07/16/10 New South Federal 07/18/08 Savings Bank CD 100,000 07/19/10 07/23/08 Key Bank National Assn CD 100,000 07/23/10 07/23/08 United Commerial Bank CD 100,000 07/23/10 North Milwaukee State 08/08/08 Bank CD 100,000 08/04/10 08/08/08 1 st Pacific Bank CD 100,000 08/09/10 08/13/08 Homestreet Bank CD 100,000 08/13/10 Page 1 of 13 22 Investment Activity (continued) Securities Matured Maturity Date Description Type Original Cost Amount Matured 07/25/08 Citizen's Comm'ty Bank CD $ 92,469 $ 95,000 08/06/08 Treasury Bank CD 99,000 99,000 08/08/08 Washington Trust Bank CD 99,000 99,000 09/17/08 Independent Bankers Bank CD 99,000 99,000 Securities Sold/Called Prior to Maturity, Transaction/ Original Cost/ Gain / (Loss) Tran Date Description /Type Maturity Sale Price on Call Full Call Fed Home Loan Mtg Corp $ 200,000 $ 200,000 $ - 07/07/08 government security 01/07/09 Full Call ANB Financial Nat'l Ass'n 100,000 100,000 - 08/13/08 certificate of deposit 10/17/12 Other Reportable Activities None 23 Page 2 of 13 CITY OF ATASCADERO TREASURER'S REPORT CASH&INVESTMENTS ACTIVITY SUMMARY FOR THE QUARTER ENDING SEPTEMBER 30, 2008 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at July 1, 2008 $ 605,204 $ 39,068,813 $ 126,731 $ 39,800,748 Receipts 5,399,852 199,351 537 5,599,740 Disbursements (8,420,704) - (215,716) (8,636,420) Transfers In 8,459,469 4,944,950 172,686 13,577,105 Transfers Out (5,117,636) (8,459,469) - (13,577,105) Balance per Banks at September 30, 2008 $ 926,185 $ 35,753,645 $ 84,238 36,764,068 Deposits in Transit - Now Outstanding Checks (544,055) Adjusted Treasurer's Balance $ 36,220,013 Page 3 of 13 24 b M — v ` o 10 v'i m oo O h R O O N N b aD b O b r^1 ._. rn vi vi r r r r a r vi vi O\ D\ T U vt 0` O\ C7, J ry vv rn o 0 0 0 0 0 0 0 0 0 h o 0 0 0 0 0 0 o m o 0 0 O [y a o• O� vi vi r r r v r v-, vi v o. rn o, rn a rn ol of ol rn ol vi o. rn rn O � N �' 69 °v a o O O O O O O O O O O O rm o C 0 0 0 0 0 0 0 0 o M o 0 0 o 0 0 0 0 0 0 0 0 0 0 0, o 0 0 ol a a a a ol a N M Q c o o O e o 0 0 o O O O a e o a F, J 0 0 0 0 lt� e o o N o W O 4 N U � o E•' W ,o e C c �c •� h N — �o �o �o �o vi M �o v, v, �n v m v v m e+i rn m ri ni �+i .moi m m m ti v 0 0 0 0 0 0 0 0 0 0 0 0 0 R R 0. 0. R d N J N U N J N J N u N u u W N Q Q Q Q Q Q Q A A Q Q Q Q Q Q o W W W 4r W W W W W U O O O O O O O O O O O O O O O oo Q a p T U U U U U J J U U U J U U J U « _ 12 f f U Y d U N J J N U d J d J U U hh M v t v v v v et v m v v v Q o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 cl O O 7 V V e c G O N r\ lo n ^ N N N m m M rf O O O O O O O O O O O O O L � Y L O Y W O °a P7 w Y a G d D a CQ z 7 e c w [� 0 9 E 0 a 7 o z 2 E 0 a`o9° z" Uu 1 W � wC7 °. 0 wa W a° 3En LnQ a v a z oo m oo rn rn o, a ol rn rn a rn a o, a n O o 0 0 0 0 0 0 0 0 0 0R 0 0 m b N O �V �D O\ Q c G O N_ m \ N O O O O O ^ O O O O O 25 G h rn F e — e r 0, oo c = ^ oc C V j V O y U M h Oo DD M o, C V1 0\ M Q\ 00 O+ O W :Z4o o v oo v (71C, a,r r r r Co oo o 0 0 O+ O O� O� O. � O� O� O� O� OON Ch O. T f O O M h oo O O O O O O O O O O O O O O C, r o0 0 o O O 0 0 0 o O O o 0 0 0 N oo r O O O O O O O O O O O O O O O W o0 00 0 of O O O, N P U a 0, O Cl) Cl O � 4 A � 0 00 0 0 0 0 o O o Cl o 0 0 0 0 Cl 0 0 0 o O o 0 0 0 0 0 0 0 0 0 o O 0 0 0 0 0 0 0 0 0 0 0 o O o 0 o O Vj o o C, ol rn a, C, rn (71 C, a, or, C, a ol o 0 4 G e o o o 0 o e e o 0 o e o a o e o rn O n n n n v o O Cl v Cl 0 0 Vt vt ,U 0 tv 'v Udo^ cqy o 0 0 0 o e e o 0 0 0 0 0 0 0 0 0 0 z y 0 0 o LT4 -Q D, 'C L v1 L o 0 0 0 0 Z a a a a a a a a a a a a Cl u v u u u u u u u u u u u u W A NW w w w w w w w w w w w w w w w w � o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U U U U U U U U U U U U U U U U f > f f f f f f f f f f f f f u 0 u v u u u u v u u u u v U u x (y O O O O O o O O O O O O O O O O O Eti N M a M O O ,O N O ,O O N V O N ^ O \t \1 O O O N Q 0 Q o o a rn rn rn o ^ N 0 0 0 0 0 0 0 o O o O 4 � a o i0 0 ° In cn r-4 cd a -0. � d � Y o °: � ai 4 � `m � x U � � a no a, i° •Y'� a" U W U H 7 "3 PW. v�i a u a 'Sa a 9 d ° d boo o u � z Ov v� A Urn w �•- Gaw F3 xm UO 3v, w` w W rn a o, rn o, rn a o, o, rn rn rn rn rn o, o, o, 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 A O O O 0 O 0 O O O O O O O O O ^ 26 �3 Q ;7 p N 00 h V M O Q M O C, M K zz- � z M M r N Q Or M Q Q o, 1O Cl Q T `O N Q Q Vl F� W O m m a rt Vl r oo r C [y 10Q r' Q 10 10 r - C, of o: r o+ C, oCC Dy o, o, o, rn rn ^ C, C, a, rn rn rn o, rn rn o, o vj 0 0 0 0 0 0 0 0 Cl 0 0 0 0 0 0 0 0 0 0 0 0 C, 0 0 0 0 0 ,n o 0 0 0 0 0 Z o 0 0 0 C 0 0 0 C o rn o C o O o 0 40 W m 0o vi r o r o0 0o rn o 0 m 0 0 0 C, o• o, o, rn o o, rn rn rn 0, o o a o 0 0 Ln In O Z 2 2 � ❑ ❑ � c 1c � � � 2 2 `a 2 � � O 4 A 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C C 0 0 0 0 0 0 o O o 0 0 0 U j rn rn rn rn rn o rn a rn rn o 0 o rn o 0 0 vi O o o o 0 0 0 0 0 o e o a o a e o 0 C, 0 �n Cl vi o 0o vi vi o 0 0 0 C4 0 � -r4 .. o h W e n o n o O o o v o n n n o 0 0 0 w -Q, C �i O O O N h r N M N Q N N ^ M N N N l Q i'. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a a a a a a a a a O A Q Q Q V) C5 (5 O O Q A Q O Q Q W w w w w w w w w w w w w wo 0 0 0 o p o 0 0 0 0 0 0 0 o wo 0 a cai a a a U U U U U U U U U U U U U U U ta E w w^ � w f f f f f f f f f f f f f f f u u u u u o u u u u u u u u u u u U U U U U 0 U U U U U U U U U U U h eo 0 0 [W. o_ o r N rn oo rn e r m o M M N M '? 10 Cl O O O O O O O O O O O O O O O O 4 _ Y a a ° o 0.1 Rat Y a m m p Y C u Y Y Z cn O k+ a Pa e 4 1 con o ° F ¢ o .°. a a Q f a � � A ` > as Y aQ oe o � °o q ` qqd *0 ' rya Wa3 � d x � °aU A d aEi � � ° � o •0 4 d T2 �_ o ° o ❑ O F o0 0 E p° u U w o u $ -" w �' ` a� �q'° �j d' v a a U v� 'c pa C1 u d •7 taJ .+ p 'Q aS Q T+ :7 y �. YT C a w x x x 3 w cn V ¢� x n 3 w z ° w w Y u a A 3 [�. o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a - - ^ - - - ;25 ;Ba o Q N N O N \ ^ N O ^ — N N N r\ q = M Q o 10 r r r r r r O O O O O O O O O O O O O O O O O 27 O N �o p 00 V G n O\ �O P M M N C N M e, N v � oo a• � e r V F.v 00 7 M N Q O O R V U M m 00 OO 00 r cl� DD N b F� f" �D V1 V1 M - m r 00 00 V 7 00 O �1 O� U O� N o0 r v'1 U O� O� r r r 00 00 P U o. N D` O\ O U O\ D, P P N a b O\ e , ^ 69 O O O ? O O r O O O O O O O N O O ' O O O V O O m o O O O O O — O O C C� o o V1 O O O 0o O O O r O o O L� 0 0 o V oo r O, 0 0 o m r o o m o 0 O U ti by A \0 A 10 A A M A A A O A A A W A A v c c a c Z N c h 0. A 0 0 0 0 0 o O O Cl 0 C. 0 0 0 0 0 0 0 o O o 0 o O o 0 0 0 0 0 0 Cl 0 0 0 0 0 0 C C 0 0 C C C 0 0 0 o O O W j O O O N O\ D` O O O O O\ o+ U O 14 N e 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 J v, o o o 0 0 o M o 0 O Wa0 0 e v a v v v v v v n v v m v e c poo r. H O F 0 0 0 0 0 0 0 0 C 0 0 0 0 0 c O Vl O O — O C O O O � q'� N N N ^ vl �D r vl Vl m �/1 O N oO O — O d r � � fe. O � a O O O O OO O O O O R R R R R R R w Q QC6Q Q VJ Q Q Q Q Q Q Q 0 4U w w w w w w w w w w w O O O F O O P O O wO O O O O G O o h [� •°+ .°. .°+ nv .°. .°.+ v .°.. .v. A.Id G yrr A w w w w w w w w w w d w d t: d d o m o u v u d d o m o U U U C7 U U C7 U U U U U C7 U C7 U U h oo ao v� �n vi �n r r oo �D �O �D oo r m o0 e o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o0 0o m Oa rn N oo v ^ o r rn o r o Q o0 op 00 ^ oo Ol O Cl O O O O O O O O O O O a L Y O ° U A Y s s s >C bb y ° u p7 V Y ,`� C F" o o °" °: a°i �' i 3 aQ 6 9 � =' � oa ocn v> a = v � a a � Z � .. � x � wU hW wrn wU C7 � Uw �" � UU zU wU 33114 [�. o 0 0 0 0 0 0 0 0 o, �n r � e O O '+ ^ O ^ N N �� O\ N N -• N M 00 00 00 00 00 � N N ^ N N V vl vl e Q O O O O O 0 O ^ O O O O O 0 O O O 28 b N M ti e � 00 a O O a N O^ Ol Iq IL oo N v1 T vi O Q\ r b r-: oo � Q` O Q` r, o w o oe of O rn a W N � O p D\ a 10 y � � e p o o o p o c po 0 o po 0 O LL w O � 00 O pp C7\ C7\ a � N a Oi O �1 U tc� U v �G 4 A o 0 0 0 00 00 0 O O O O O O O P O O O O pO p O C> p O p O O p O O p O O O O O O O a LL e J b9 v O 0 10 0 h h a ' ID O < N O F W o 0 o a a ^ v It n A ? N o 0 0 0 0LQ 0 o oN 10 10 10 0 Ln 0 O h a F Z � o � D rn A w o ° ° ❑ d E: � a C �.��.. �'�" `` y o ani dU �j U � O o U o o C7 V U U U U U U r r r o 0 0 c o O ,__, ., o rn o N Lonr O O ,. N ^ M N N _ N NO N10O O N p O 4 a o � 0 o m U ° x im °° x c C l 1 `A „�T N q C 2 w m ° " p G 02a u c o ? E M 3 ez o � ss oCq �� a � a d A ZM z x x a 9 3 P.93, 06 Ci —�� � � 3 � � ,� > a � n � ti � P. vim" '' u y � u � � d •~°• �'L � � � u E. °o d � � � �nin �" � WU UC7 e Q p O 29 � r 00 00 Q h Cl `� W go � O a d IIA y p N, v, rn ao p9 rn N1 a N tl0 'L j o o oo O N Z O O O O N O N N N R, W O O H tn A N cl 4coo00 p c t a' Q O00 p O N y N a -- 44i, '�.. O1 N O c e o W N 10, O -.21O- CG � ¢ Cl —ts z Y :tz10 o o b U CP � cOi O � O U O O N O ~ h o 'o v o n 'te a -CO w �O+ F P`O+ r A 'A 0.W �t ry vi r Is F Q o p City of Ataseadero Investments by Type September 2008 Government Securities Cash with 14% Fiscal Agent Other 0% Certificates 1% of Deposit 20% LAIF 65% Investment September 2008 LAIF $ 23,347,631 Certificates of Deposit 7,114,375 Government Securities 5,291 638 Cash with Fiscal Agent 84,238 Other 1 $ 35,837,883 31 Page 10 of 13 City of Ataseadero Investments by Maturity September 2008 One Month One to to One Year Five Years Within 7% 27% One Month ---''-- 1% a On Demand 65% Investment September 2008 On Demand $ 23,347,632 Within One Month 195,599 One Month to One Year 2,672,891 One to Five Years 9,537,523 $ 35,753,645 Page 11 of 13 32 City of Atascadero Investments by Custodial Agent September 2008 Union Bank 34% i i 3-R�d�t8 'if E 6 i Ea New York Other t` 0% State of California 65% Custodial Agent September 2008 State of California $ 23,347 631 Other 54,936 Union Bank 12,351 078 Bank of New York 84,238 $ 35,837,883 33 Page 12 of 13 City of Atascadero Investment Yield vs. 2-Year Treasury Yield For the Quarter Ended September 30, 2008 6.00% 5.00% 4.00% 3.00% \V1, 'Y t- f h 2.00% .. .. 1.00% 0.00% o� rood e�oo1 `�oo� `001 r�oo� �ryooe `ryoo� rp O g O 0m ---0--City Yield --a--2-Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield September 2006 458% 388% December 2006 466% 3 91% March 2007 472% 3.88% June 2007 483% 4.23% September 2007 4.82% 374% December 2007 463% 330% March 2008 402% 219% June 2008 335% 2.86% September 2008 3.33% 243% Page 13 of 13 34 Attachment 3 �1i1Mt+'' y9ia . ie�s (ADEM/ For the Quarter Ended A tascadero City Council December 31, 2008 Staff Report - City Treasurer December 2008 Investment Report RECOMMENDATION Council approve the City Treasurer's report for October through December 2008 REPORT IN BRIEF Cash and Investments Checking $ 1 227 901 Money Market Accounts 1 Certificates of Deposit 8 049 016 Government Securities 3,173 056 LAIF 26 058,474 Cash with Fiscal Agents 84,343 Cash in Banks at December 31, 2008 $ 38,592,791 Deposits in Transit - Outstanding Checks (273,174) Cash and Investments at December 31, 2008 $ 38,319,617 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 10/09/08 GE Money Bank CD $ 98,000 10/12/10 10/15/08 Morgan Stanley Bank CD 98 000 10/15/10 10/15/08 International City Bank CD 97,000 10/15/10 10/15/08 1st Bank of Lexington CD 98,000 10/15/10 10/15/08 Sterling Savings Bank CD 98,000 10/15/10 10/24/08 Copper Star Bank CD 99,000 10/25/10 11/20/08 New Frontier Bank CD 97,000 05/09/11 11/26/08 The Park Avenue Bank CD 99,000 05/26/11 12/10/08 1st Bank of Puerto Rico CD 99,000 12/12/11 12/10/08 Imperial Capital Bank CD 97,000 12/09/11 12/12/08 Huntington National Bank CD 97,000 12/13/10 12/31/08 Irwin Union Bank & Trust CD 150,000 05/18/09 Page 1 of 13 36 Investment Activity (continued) Securities Matured Maturity Date Description Type Original Cost Amount Matured 10/06/08 Royal Bank America CD $ 96 598 $ 97,000 10/22/08 Community Bank Plymouth CD 99,000 99,000 12/30/08 1st Nat'l Bank of the South CD 97,000 97,000 Securities Sold/Called Prior to Maturity- Transaction / Original Cost/ Gain / (Loss) Tran Date Description/Type Maturity Sale Price on Call Full Call Fed Home Loan Mtg Corp $ 298,335 $ 300,000 $ 1,665 10/06/08 10/06/11 Full Call Federal Home Loan Bank 400,000 400 000 - 10/22/08 10/22/12 Full Call Federal Home Loan Bank 401,900 400,000 (1 900) 12/12/08 12/12/11 Full Call Fed Home Loan Mtg Corp 153,712 161,000 7,288 12/19/08 05/15/11 Full Call Fed National Mtg Assn 364,635 365,000 365 12/30/08 06/30/11 ( Full Call Fed Home Loan Mtg Corp 500,000 500,000 - 12/31/08 12/15/12 Other Reportable Activities None 37 Page 2 of 13 CITY OF ATASCADERO TREASURER'S REPORT CASH& INVESTMENTS ACTIVITY SUMMARY FOR THE QUARTER ENDING DECEMBER 31, 2008 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at October 1, 2008 $ 926,185 $ 35,753,645 $ 84,238 $ 36,764,068 Receipts 9,105,489 181,082 105 9,286,676 Disbursements (7,457,953) - - (7,457,953) Transfers In 6,981,180 8,327,000 - 15,308,180 Transfers Out (8,327,000) (6,981,180) - (15,308,180) Balance per Banks at December 31, 2008 $ 1,227,901 $ 37,280,547 $ 84,343 38,592,791 Deposits in Transit - %w Outstanding Checks (273,174) Adjusted Treasurer's Balance $ 38,319,617 Page 3 of 13 38 0.•+ � � K h O ^ N N y O ^ r ^ a a a a 6'f O O 06 ~ U NO o 0 O N °, 'r 69 a 0 W ^ 0 0 0 0 g po o p p a a a o 0 o s o 0 �• ry v a a a O p a O �O d3 A ki ^110 M M v r o ^ v 16 Qn 0 0 Z � O K '� C b w0 .O0 10= r cy u q q q Q v a o [r o c o > w «y « a° ° ° o o o Q Q q rn Q .r. V U ry N « « « °tz tr- w w w wq ro uU U U U U U U U U U U U U (oIIQI � v U Q c ❑ � b rn o � � o o `r � a o v O O p Cl C'4 N O p O NO Y ♦. C Fo dJ w v Y v V a e x a w V Vo a � u iW .� w d r�r C L'z C bl N t0 Q d 4 O .d z R' ;C z V U 2 Z x Q O ►F7 E yx�, ? y ° c o Uta � y x O a g w V ° Q O W X, U k 0. W a°. 3Cl) `n a a V U U f N N _OC a0 O O O a cla Q 2 V \ N O O O O O ch O Oa N a = O O O N .�-. O O Lti O O O OOry '� p O p O o o O O O 39 rn m a,CD O K N a � IT r oNo 0 M O Oi D\ Nl p0 oo N V O N Nt N N N W T lr 06 W C+ oo T D` O` e o 0 o p o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o p o: o o " rn fr O O O O O p p O r I - W W O\ D U U (� Fr N C Iz C U q. 0 0 0 p o 0 Cl0 C o p 0 0 0 0 0 0 0 0 0 0 a 0 0 0 0 0 0 0 0 o r rz rn 0 p rn rn q o o rw r rn rn o+ W w o ° ° rn C, Cl)Olrn v � Q � w � Q w N c c e c o o e o p o 0 z I 0 0 N M oLn a O O 'p p O G 0• a a G N u 'o o p, y N u Q Q .D Q � � Q Q Q w pol W q A Q Q Qw o 0 0 o O tm It •. U � � U U V U V U U U U � U U o 0 0 0 0 vi 7 O p O Q, b 10 Q W O� p O O O N O N O O 19 O O 4 x e W Fq N z a cz Y F L C A r � I °w San w y u ca -0a d a d o C 4 > d ' x v F m $ d m � ° � e 9 y •� �= � m � T � F a o m '� r VO 3 � wm .a3 Qw `i 3 �, ate, � z o � z U p al O O O O N O ^ ^ 0 0 40 1 N O N O N r 0\ O 0 r vt �D vl �D Vl b O `D O 7 r D7 r T 00 r iD oo r r N o7 r V ` N e Z 10 N V V1 10 N \O V1 N r O. - O r m h b v1 b � W C N u9 O O O O O O O O O O O O O O O O O O O o O O O O 0 O O O O O O o o O O O CIL O O O O O O O O O Ly o0 h r O h r m - a o O OD O O 0 0 0 D\ o� of O o, of T V, of O O o+ O O O O O O � UZ k�i U � A 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o o O o o O o 0 0 0 0 0 0 0 0 0 0 0 o O o C C 0 U w� rn rn a, o rn rn rn 1:1o 0 o ol o 0 0 0 0 W � C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 In o 0 o 0 0 WCD N We O O O O N Om N N N O O N N N N h v a v v e v v v v v v v v v U ti W U hee c c Q c �c c �c c e c c c 2 C 0 0 0 '� 0 0 0 0 0 0 0 0p 0 o 0 0 0 Z u u d u aai N Oi r v u Ii' ami' u 6i' a0.i aQi W w w w w w w w w w w w ww 0 0 0 0 0 0 0 0 0 0 0 0 N N N U U U U U U U U U U u tr. w a w^ w u u u u u u u u v v v w E. rn r N rn m N rn r o0 o m m m ao 00 O O N N N O N N N O O O 0 O O O O O O O O O O O O O O O O O Y VM W 3 N Y p p y .` Y % p C3 E Y eo a a Q Q w . S 0 w a C1 OW s Y C1 a p� a' co O w A ° F 0.1 C0 Q o m a N Y h � CQ 4 0 °o s w # W A o , ; S T a c w a° U on y u v o 0 0 ° PZ u F° °o T� u �' x 3 a4on > y A wx xx 3U W U Wvn u 2 xx va, 3 w z1 w yo 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 O N N -^ N O N .\�-. �' \ N fry V b b r r r r r r C, r r r 00 00 Q ClO O O O O O O O O O O O O O O O O 41 � .... vi ni ni - - ^ ^ -- -= ni •- ni ni ri rr e Z �D C lr D, O O o0 � W r N ? r 00 vl �O r �D Y1 O\ O. O o, of Ol O` U e � O V 0 Cl Cl O o O O 0 r O O O O O 0 Z 0 v O O O o 0 0 0 o m O o o O - 0 C, "0 0 0 0 C C C C C� C o C o 00 0 WO W o a oo r o0 00 I m pi rn o o o ri T D` O\ ol Ln Ll \ bq _N �O N \ed ed N cd N H �d Al ty NN N `N p N V ti 4q O O O O p p p p p O O O O O O O O O O O O 0 p O O O O O O O O O O O O O O O O O O O O O O O O O O O O V O It N C, C, ol 0` O+ C, T OPi O -4O ol O O a T e - A a o 0 0 0 0 o a o e e e o 0 o e o O I\ W O Vl ON N O h O O_ W M R O W O o � v h v v c v v v v v v v �; v v v, �•, t4 � W ti - 1 � • �, o vi �n �n o �n vi �n o o �n o vi o vi o o d W O �' � N .-. V't �D N N O •-• N .-- r Vl ao Vl m vt O � O � � e Z \ o o Q o 0 0 0 0 0 o 0 0 0 0 0 a a a a a a a u u g u O O O O O O O O p O O O W O O � E w - w "- w �- w t w w w °^ f > > v W o 0 0 0 0 0 0 0 0 0 0 0 j Q m rn o 0 0 0 0 0 NIt0 0 0 p 0 0 4 Y Y c +, "Is V h K d w u U U a W d m Y Z x Y W y A o 0 d a m o0 tr. .°.� rnrn Ucn wU C7 ".0 G UEn o t2 vi vt �n N O m O r e .-. ... ... o . a (� N O e Q pp pp o0 U O O O O O N � O 3 O ItO \ O O O O G 42 �O OC .-• 00 Q N �D 00 M O — C O� �+1 v1 h Zl V �O O M r M Vl 00 f M O M 00 M Vl Vl oo O O r O r O nl O� U O N N •1. vl O 0, O O O O O O� O O U D\ O O O O of 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 Z o 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O W O 0` V1 Vl o O O O O O\ T O O O O O � c 1c c a 2 c c U 0. C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C. 0 0 o O o 0 0 0 0 0 0 0 0 o O o 0 0 0 o O o O o 0 0 0 o O o O o C U N O O O O o O Ol Obi O O O O W C o a o 0 0 0 0 o 0 0 o e o 0 0 0 0 O o n O O O n o o n 7 N ^ O O O oo ^ V1 M h ti n Wti o a o o 0 0 0 0 o o a o o W N O O O O pip O O O N V O � v O O O O O � O O O O O O O O O O U d N d d d 0. CU 0 0 0 0 0 r 0 0 0 0 0 0 0 0 0 0 Wa .4 1 a w c w w w w tz t w w 1 ' 'f 'f f 'f f 'f 'f f>o o wf u u o d u v u C7 U U U U U C7 U U U U V U U U U U W v] �o ao 00 00 00 00 00 00 00 0o r r o0 0o r r h r rn o 10 o. N V vt Vt �O vt p N O 41 9 yW a° s m a 3 no ° U a W o a m a y JU O N U E y v n O ` x a # d U a a o .� �- u W °� a o a `„ �• .A. o .v 0.t 3 = .0 wu a3 E � w � 3 � uo wz was ¢ 3 uncn Q N O O \ N M ry ry O b 43 N O � M r a a W h N •J C7 O W �'! � � O M � a o a M a n 0 oo O O ,po eel 0 o O Q M W N O p W 00 F O O Q 14 IP A G W 33 O �,� p "'- dam' 'nr• m t p w Q p o 0 0 o r= y p 0 O � O Q LY p O O `•' R A e Q 3 N o o 'a v a 70 c p N a N A On O y d Q p r a n G N w F a � e„ a � � •o W a q p H a 3 Gi. G AJ U� �w Ems-• 2' `t ;� ?�' � V �" \ � .. .� ami A o � � � �, •� A y V U w A w W W o u cl H s�•a ,at, � cp O a N O N u. O O 0 � � �• a v M ,on a0 O F4 F M o p ^ O C City of Atascadero Investments by Type December 2008 Certificates Government of Deposit Securities Cash with Other 22% 8% Fiscal Agent 0% 1% LAIF 69% Investment December 2008 LAIF $ 26,058 474 Certificates of Deposit 8,049,016 Government Securities 3,173,056 Cash with Fiscal Agent 84,343 Other 1 $ 37,364,890 45 Page 10 of 13 City of Atascadero Investments by Maturity December 200E One Month Within to One Year One Month 7% One to 1% Five Years -- 22% On Demand 70% Investment December 2008 On Demand $ 26,058,475 Within One Month 485,000 One Month to One Year 2,637,131 One to Five Years 8,099,941 $ 37,280,547 Page 11 of 13 46 City of Atascadero Investments by Custodial Agent December 2008 Union Bank 30% Other Bank of New York 0% 1% State of California 69% Custodial Agent December 2008 State of California $ 26,058,474 Other 55,176 Union Bank 11,166,897 Bank of New York 84,343 $ 37,364,890 47 Page 12 of 13 City of Ataseadero Investment Field vs. 2-Year 'Treasury Yield For the Quarter Ended December 31, 2008 6.00% 5.00% 4.00% 3.00% 2.00% 1.00% 0.00% s% Z% cP —a—City Yield --4--2 Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield December 2006 466% March 2007 472% 388% June 2007 483% 4.23% September 2007 482% 374% December 2007 463% 3.30% March 2008 402% 219% June 2008 335% 2.86% September 2008 3.33% 243% December 2008 2.93% 1 41% Nftw Page 13 of 13 48 Attachment 4 �i 1918 � 1979 CADF�►� For the Quarter Ended Atascadero City Council March 31, 2009 Staff Report - City Treasurer March 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for January through March 2009 REPORT IN BRIEF Cash and Investments Checking $ 602,633 Money Market Accounts 1 Certificates of Deposit 7,665,148 Government Securities 2,223,056 LAIF 27,609 320 Cash with Fiscal Agents 84308 Cash in Banks at March 31, 2009 $ 38 184 466 Deposits in Transit - Outstanding Checks (498,032) Cash and Investments at March 31, 2009 $ 37,686,434 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 01/08/09 Goldman Sachs Bank CD $ 97,000 12/30/11 01/09/09 Anchor Bank CD 97 000 01/10/11 01/09/09 Boston Private Bank&Trust CD 97,000 01/09/12 01/14/09 Integra Bank CD 98,000 01/14/11 01/14/09 Layton State Bank CD 97,000 01/14/11 01/16/09 Nexity Bank CD 97,000 07/15/11 01/16/09 Frontier Bank CD 97,000 01/17/12 01/27/09 Silverton Bank CD 97,000 01/27/11 01/28/09 First Regional Bank CD 97,000 01/28/11 01/30/09 Bankers Trust Company CD 97,000 01/30/12 Page 1 of 13 50 Investment Activity (continued) Securities Matured Maturity Date Description Type Original Cost Amount Matured 01/14/09 Cedar Rapids Bank & Trust CD $ 99 000 $ 99,000 01/16/09 American National Bank CD 99 000 99,000 01/29/09 Eurobank Puerto Rico CD 95,000 95,000 01/30/09 Interstate Net Bank CD 97,000 97,000 01/30/09 Founders Trust Bank CD 95,000 95,000 02/04/09 Western Bank CD 97,000 97,000 02/04/09 First Signature Bank CD 97 000 97,000 02/04/09 Fireside Thrift CD 97 000 97 000 03/05/09 Camden National Bank CD 97 000 97,000 03/10/09 Community Bank CD 95,000 95,000 03/12/09 Morton Community Bank CD 95,000 95,000 03/13/09 Capital One Bank CD 98,293 100,000 Securities Sold/Called Prior to Maturity- Transaction/ Original Cost/ Gain / (Loss) Tran Date Description /Type Maturity Sale Price on Call Call Federal Home Loan Bank $ 400 000 $ 400,000 $ - 01/07/09 government security 01/07/13 Call Federal Home Loan Bank 300,000 300 000 - 01/28/09 government security 01/28/13 Call Cole Taylor Bank 93,810 97 000 3 190 01/31/09 certificate of deposit 01/31/11 Call Federal Home Loan Bank 250,000 250 000 - 02/24/09 government security 02/24/11 Call Magnet Bank 100,000 100,000 - 03/24/09 certificate of deposit 01/24/11 Other Reportable Activities None 51 Page 2 of 13 CITY OF ATASCADERO TREASURER'S REPORT CASH& INVESTMENTS A CTIVITY SUMMAR Y FOR THE Q UARTER ENDING MARCH 31, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at January 1,2009 $ 1,227,901 $ 37,280,547 $ 84,343 $ 38,592,791 Receipts 5,155,478 151,081 3 5,306,562 Disbursements (5,694,561) - (20,326) (5,714,887) Transfers In 5,485,103 5,551,000 20,288 11,056,391 Transfers Out (5,571,288) (5,485,103) - (11,056,391) Balance per Banks at March 31, 2009 $ 602,633 $ 37,497,525 $ 84,308 38,184,466 Deposits in Transit - Outstanding Checks (498,032) Adjusted Treasurer's Balance $ 37,686,434 Page 3 of 13 52 00 N N N r vl r r r O O N i N N eT M `C M N O r N V vt O r 1p N vi C, vi o0 o vi r r r o0 0o ao vi o0 00 00 of of ol D a, C, U v a ol C, V M Q Q N 69 O ^ h oo O O O O O O O O O O O O O N r oo O O C C O O O C O O O O O ^ C O O M o0 1� O O O O O O O Or' 01 D\ O O W rn o0 0 C, o U vi r r l; C, r r I r r" N h o D\ O� D\ T V1 D\ Q\ 0 -LI N Z \ by S O 4 O CD ^ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N O O O O O O O O O t+l O C O O O O O O O C Vj O of O1 a, (71 T D\ D` a, of V1 ol of o, V ^ N w Q o 0 0 o 0 0 0 o e o e o 0 0 o e Q {� V N N •-^ O D, h O O O � a O W o U C N n o Z V . W V F ? C F G C C C C F C F C b o 0 0 0 0 0 0 0 0 0 0 0 0 0 v u v u u v u v u v v C .o w w w w w ww w w w w � o o O o 0 0 0 � 0 0 0 0 0 0 C T C U V U U U U U U V U U U U o ' f f f f f f f f f f f f f o v u v u v v v v v v u v u V) U U U U U U U U U U U V U U QW h h v oo v v v �n vl e v M v o. v CD _O vl N �n 10 10 \D r O O O Cl O O O O O O O C L �y O O V •o Y L e O Cc C en x e m U c Y d (y mL wd .7U maC HO' zo OY O rmnQ cn E 13 m O, C\ 0` ON ol T o, O� W O O OO O O O O O O O O O O \O O O N � O P a o, o Z O o O O O O O o O O O O O O 53 � u N r 'V 00 10 m \p V O N O r N r N o0 10 0% Ofi b rl r 10 P b r r D` r lO �O W W T N N 00 o O r P N a T O 14 O a O O D\ of O of of N Ol U O O O O O O e vi O Cl O Cl O O O O O O O O O O O O O Z O o O O O O O O O O O O O - O O O O O O O C O O O O O O O O O� O O O O W rn o o r' - ao vi r" o r r - w o� o O o0 C, O O U oh U C� O of of of o` o\ tn O �W v ` C 0 0 0 o O O O o 0 0 0 0 0 0 0 o O o 0 0 o O o O o o O o 0 0 0 0 0 0 0 0 0 0 o O C o 0 0 o O o 0 0 0 0 0 W rn o o r o0 0o h r o r r x o0 0 0 0 00 Uo 0 o rn a a rn o o rn o 0 of 0 0 o rn R sv O h O O O N h r N rl N O N N W O a v o v v v v v v v v e e v v v v v W o ~ V N ^� O O O �n O h O O O Vt o vi O �/1 vt vl O vi O Oul � LQO h C V ett wt: 41 O O O O O O O O � O O O O O O O O v v u v v v v v v v v v v ti W w w w w w w w ww w w w 4 0 0 0 0 0 0 0 o c o 0 0 0 0 0 0 0 cd 0 0 ° W U U U U U U UC V U U V U U U V w d w L:. w o v U v v U U U U 0 u u U U U W Q W v r r vi vi vi vi vi vi vi o �n �n o0 00 0o vi 0 0 0 0 0 0 0 0 0 0 ^ 0 0 0 0 0 0 10 O ^ o% C 10 10 O O r t� (� r n r r O O O o O O O O O O O O C s e R 0 r w m N W m < E w "> c a m eo a � � � mw v' ¢ •ate z � w z � = my •� Y � v r � A d s z Y nCa7 � m s � aY c O F K U m W o v v w W 3c U v v E u v Q o z m � 5u c ai % u m y U V) ,� m m n E o 7 $ DO i > m o `o d Q .. _ ° o ca q ° j u > > v o 3 v w w 3 a w i; x x x . U w U m y U a` x x v a z w w o a o 0 0 0 0 0 0 0 0 0 0 0 0 0 N m O �O �o O O O O O O O O O O O O O O 54 C v] r 1(1 r V1 N V 1 10 m V' O 00 C V o 0o v m ^ 0 0o N r r o r r vt N ao a r ao r o e r V oo vt r vt �O v vt �o m �0 0 00 v v o v m r oo m o E. W r r o 0o r r N N m o0 0�o vt r oo r �O V O O O O O O m O O O O O+ O O O ^ O e 69 O O O O O O Q O O O O O O O O r O O O O O O O O O m O O O O O O O `D O O O O O O O O O W O O o O O\ P P Ol O\tn P O O �Ct U � � \` iZ, N N \V N N N 10 N N A A m N N N r!1 A O 4 O o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C C C C 0 0 0 0 0 0 0 0 0 C o O VO O O O O O N Q` 0\ 0` D` T T O O 69 Q o a e o 0 0 0 0 0 0 o a o e e o 0 O � J O O O O O vt h O h h O O O O N N W O V O vl V � 'aT Vt V V O V v V R V V C 0\ Q Z M Ir O O O O O � vt O vt vt vt O O Vt O � � t3 h 0 0 0 0 0 0 'C o 0 o 0 cc 0 0 0 '� o N V L d N U y U L U L U U 4. Q O O O O O O C O O O O O O O O F O uN N E id U U u V U U C7 U U U V U V U U C7 U W W m oo r o0 00 0o vt vt vi o0 00 00 00 00 00 �n r 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 m m m co 0o m 01 O� r U h V1 V1 v1 et N N � � Y W � b ,� L7 C u Q '�-' � Y `° z � �' .J Y F"' m f' L' •x � � o F �+ h dE c;U o o z E H ez � 3 mU almn m 0. cs � � •� Q m ¢ cX.mm eF. O e v V c ro o 3 E n e G C G V # Y C Y N V b O pp u �y # V L% t •= L 3 `° GC] E °' w sc�c Y w .� iu.� .cCL. V > V V G N V O w O O U d O G Rt J W ry O .. L X •� O O O •O U) b W Ci n C� n v .c � w � L-0 'A U n [i U C9 tio 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 � e N N r\1 O O •-- — •-- O ^ ^ ry Q O O O O O O O Pz O O O O O O O O N N 55 N �_! O cl, P V0 N1 O T hl r L•1 � O^ � v hl \ O N M J � ! °O oo M 10 N hj O NO O O °Op N of CD e y o 0 0 0 Cl 0 0 00 0 0 0 o p po p o 0 0 0 o ol o rn F. O O O O r 0 O+ T N � � j K Q O O OCD O O O 4 O O O 0 O 0 O 0 O 0 of O O O O O O Oh O rn O o a V � c c o p O 00 W e c o vl O O o ' ' p O � °' '� � ♦y V K Q o ° o o I-R `° v In o O Cl A, , O c O M I `^ o M <r w hq O N N N M W ti C M v tr N � C .. � L' •o ° a � R v CC U v p Q `y O N � � O O O O O e W o 00 ° 14 N c ~O O O 4 c N Vi Q Y C C W O Y CN V R C N Cc � h ie Y. m7•7 � � ° o u � ? L ° O YU Co p y Z C1 ub U c � -d U h T Gcz G Y C Q OP h N O N O O O O O N �. 5 N �•,� N v V O O• N NO � M � V.� W � `+ a e � Z m `c rn N W OO r O O O oa b �° O °� O e va o 0 0 o o 0 0 0 0 o g o 0 0 0 0 o p o 0 0 0 0 0 0 o a o 0 0 � � o O � F h h �G U 0 0 0 0 0 0 0 O o p o 0 o p o O O O O O � p0 O 00 Op 00 � � 00 00 O O ol P p0 T � a o e o 0 0 Q Cl It lo W o \ vry Q e e c O O O N O w N F � C C lo � F G ! o n ¢ ° u q q q q o to o o a o a u u a q Q q o o 0 o u y U q Q w0 p O U a� w N U U a�i u U U U U w m O o x Ell E^ o 0 0 o 0 0 0 V erz = o a o a 0 a y W � CC Y °u Z a1 a o U w s o > c w to C tit o N U t pa 4 E F = ° a F 8 = « 'y > c c a qn a c u y o u a` ° E c a i 3 o S m u eo Q q t u � c E c u E h � VC7 V Gl (7 wvaw "z o ON 4 N O p O Q ~O Cl O ^O p C;7 \ \ — a # L'4 r ® # 5 � bm � Q � bJD \ r / § CD m J � § § r /0 / (/ / \\ \ q f k y 4 ® k 7 $ ¥ \ _ ( @ A -w � \ ± � ® ( > ) \ 4 ± T \ \ \ b — 0 \ � Cl £ / \ \ j ) K} 58 City of Atascadero Investments by Type March 2009 Government Cash with Certificates Securities Fiscal Agent of Deposit 6% 1% Other 20% _ 7 0% Ar LAIF ' 73% Investment March 2009 LAIF $ 27 609,320 Certificates of Deposit 7 665 148 Government Securities 2,223 056 Cash with Fiscal Agent 84,308 Other 1 $ 37,581,833 ( 10,00 59 Page 10 of 13 City of Atascadero Investments by Maturity March 2009 Within One Month One Month to One Year I% 5% One to Five Years 20% On Demand 74% Investment March 2009 On Demand $ 27,609,321 Within One Month 389,663 One Month to One Year 1,959 410 One to Five Years 7,539,131 $ 37,497,525 Page 11 of 13 60 City of Atascadero Investments by Custodial Agent March 2009 Union Bank 26% Other o keit i; t 4 {i r+e!¢iBtctt¢tct if: j1s ti ¢+ 0/o -t i; [ ¢ ¢¢ i�5; 'is' ��t� �i".-�t.1 it{,eM¢ e 4 3 4 g 3 z''6g4t Bank of New York r3 E �, 33.h"st ,•3:i.!' e t""it'(`Ine¢�5�`t4 e, � .V�t... 1% =t��+s'$g3�s�;��l�i.���{i�,z���?1 ��,i�t�•a;iy���' �hSj#ttf � i 2�EEES7 State of California 14,00, 73% Custodial Agent March 2009 State of California $ 27,609,320 Other 55 411 Union Bank 9,832,794 Bank of New York 84,308 $ 37,581,833 61 Page 12 of 13 City of Atascadero Investment field vs 2-Fear Treasury Yield For the Quarter Ended March 31, 2009 6.00% 5.00% 4.00% 3.00% 2.00% 1.00% 000% r�oo1 ��001 A 1 �eQ Qe �eQ Oe —City Yield --o-2 Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield March 2007 4 72% 388% June 2007 483% 4.23% September 2007 482% 374% December 2007 463% 330% March 2008 402% 2 19% June 2008 335% 286% September 2008 333% 243% December 2008 293% 1 41% March 2009 244% 139% Page 13 of 13 62 Attachment 5 leis ■ X7-9 CADF�/ For the Quarter Ended Atascadero City Council June 30, 2009 Staff Report - City Treasurer June 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for April through June 2009 REPORT IN BRIEF Cash and Investments Checking $ 393,684 Money Market Accounts 1 Certificates of Deposit 6,937,577 Government Securities 924,181 LAI F 32,719,992 Cash with Fiscal Agents 84,308 Cash in Banks at June 30, 2009 $ 41,059,743 Deposits in Transit - Outstanding Checks (148,091) Cash and Investments at June 30 2009 $ 40,911,652 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date American Express 05/20/09 Centurion Bank CD $ 97,000 05/21/12 05/20/09 CIT Bank CD 97,000 05/20/11 05/20/09 GE Capital Financial Inc. CD 97,000 05/20/11 Securities Matured Maturity Date Description Type Original Cost Amount Matured 04/06/09 Federal Home Loan Mtg gov't security $ 298,875 $ 300,000 04/16/09 Bank of Oklahoma CD 90,788 95,000 05/05/09 Nat'l Bank of S Carolina CD 98,000 98,000 05/18/09 Irwin Union Bank & Trust CD 150,000 150,000 05/19/09 Washington Savings Bk CD 95,000 95,000 06/03/09 Pacific Capital Bank CD 97,000 97,000 06/30/09 Hibernia National Bank CD 97,000 97,000 06/30/09 Old Harbor Bank CD 97,000 97,000 Page 1 of 12 64 Investment Activity (continued) Securities Sold/Called Prior to Maturity- Transaction / Original Cost/ Gain/(Loss) Tran Date Description /Type Maturity Sale Price on Call Call ' First Bank of Idaho $ 100,000 $ 100,000 $ - 04/29/09 certificate of deposit 11/14/12 ' Paid in full as a result of assumption agreement with U S Bank Call 2 Silverton Bank 97,000 97,000 - 05/07/09 certificate of deposit 01/27/11 2 Paid in full as a result of FDIC receivership Call Federal Farm Credit Bank 500,000 500 000 - 05/15/09 government security 05/15/13 Call 3 New Frontier Bank 97,000 97,000 - 06/11/09 certificate of deposit 05/09/11 3 Paid in full as a result of FDIC receivership Call Federal Nat'l Mtg Assn 500,000 500 000 06/24/09 government security 06/24/11 Other Reportable Activities None 65 Page 2 of 12 CITY OF ATASCADERO TREASURER'S REPORT CASH& INVESTMENTS ACTIVITY SUMMARY FOR THE QUARTER ENDING JUNE 30, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at April 1, 2009 $ 602,633 $ 37,497,525 $ 84,308 $ 38,184,466 Receipts 9,389,276 130,889 - 9,520,165 Disbursements (6,644,888) - - (6,644,888) Transfers In 6,157,663 9,111,000 - 15,268,663 Transfers Out (9,111,000) (6,157,663) - (15,268,663) Balance per Banks at June 30, 2009 $ 393,684 $ 40,581,751 $ 84,308 41,059,743 Deposits in Transit - Outstanding Checks (148,091) Adjusted Treasurer's Balance $ 40,911,652 Page 3 of 12 66 o m r n o \o o o0 oc N ON o r v vi r oo �a oo v o lc N ` v Q � o 0o O N N O r < V1 r oo �U oo O F. W Ic 'o r" D 10 o, rn rn o, rn o 0 o a rn o, rn rn r N O O O r O O O O O O 0 O O O O O, O O O N O O O O O O O O O O O cl O O O lO O O O O O O O O O O O Ly Ol oo r r Vl r r r 01 O O r o0 00 V1 r Q P O. O, vt O, U ol O, O O O. O` D\ Q\ O\ Qrn � U � 14 ti va w O �Y aq N -- O O O r O O O O O O O O O O O O` Cl O O N O O O O Cl O O O O O O O\ O O O O O O O O O O C O O O CW.1 P ol Ch C C7, C, U O O T a O\ P fA CrCL.yo U 4 0 Lo� N n Q 0 0 0 0 0 0 0 0 0 0 o a o 00 Mh O O O 0 0 o vi C O o / h W v t1 o O O O O O O O O O O O O O O a Ot= tq T U U V U U U U V U U U U V aU V V 00 f e u co U U U U U U U U U U U U U U U e W � a v m v rn v v r r .n vi vi v� vi 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C� r 01 01 t+l Ol O+ O ^ a .\N. N N m V O O O O O O O O O O O a Y Y ° a Y W to) D O 0 A Y Y w e0 h o C ` m a v u o n C7 60 01 K V 0.W1 ¢ GC O v d a 6o C7 ai is o a; `u,' F°Qo�. .b E If .m s at°i g i boo ro U w [- rn ¢ A a F• 3 x a, U O C O O O O O C> ON O O O0_ O O O O O O O O N M O O .. O ^ ^ ^ 0 a O ^ a a a m 7 i O O O O O O O O O O O 67 W V] t{ rl l/1 V1 Vl N G r 00 N O rn 1 �o lo r 0o lD 1► j � V1 CD U 00 r M C �/t to h N O N E. W rn .- O of N O� Cl O O N O C vi 0 0 0 0 0 0 0 0 Cl 0 0 0 0 0 o v o Z o 0 0 0 o v o 0 0 0 0 0 0 0 o a o 0 0 0 0 0 0, o o p o C C C O W o r o0w o; 0 0 - 0 0 0 0 0 o v o0 p O, O. of O, Q\ O O U O O O O O O N O\ 40 Ln uz � o 4 C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cl 0 0 0 0 Cl 0 0 0 0 0 0 0 0 0 0 0 0 Cl 0 0 0 C C O o 0 0 C 0 0 0 0 0 0 OCD O N P 0 0 0 0 o e o e e o 0 o e e e a a e O LQ Q C ij o Er 'v p^ W o e o o e o 0 0 C 0 o 0 0 o vi o o f = E4 o v c v v v v v v e v n v v v kn v U r W O a 0 0 0 0 0 0 0 0 0 0 o Z w v W W Q Q A A A A A A A A A A A Q A w w w w w w w w w w O O O O O O O O O O O O O O G O U U U V U U U U U U U U U U U Z c w w^ w tr w' w^ ''-E w w- w o Q IQR 0 ^ 0 0 0 0 0 0 0 0 0 0 0 0 o 0 1" Er N 01 00 N D\ r Nol N N O O O M O N N O O O O O O O O O O O O O O O O O a 4'Q O N Y Z Q E a a Re ° .°. � h a0.r1 Z � ._ 0.1 a Y ° d 01, U ` o � o a� °o° c zaQ m L w ax E H o Z w m E � M dw u a a GO _ o a; 3 ao u u a U W 0.l u d w w o 3 pa, Q E i3 Is w � P7v U � xx m 3 a, z 4 W W kU A n 3 x Z n xv wU vow ti o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 H Q o 10 r [- r r r r m 00 w o0 00 O O O O O O O O Cl O O O o O O O 68 10 D\ N N o0 D\ nl N N N V ` — 7 N — �• oo O .-• N D, V O v1 vt oo �O O\ N a V F 0 lc 0o vt oo Co O O v1 V v'1 �O o0� W N oo Ow O h o0 h O O O O U O O O N w O O O O O O O O O O O O O O O O O O O O m O O O O O O O O O O O O O O O O Vt O O O O O O O O O m m m - O\ o, O O r w r O p O o, U o, a T o\ of O T O T o+ Q O a O O � v Z jZ c 2 `c 1c 2 2 2 2 2 2 c Z °v O O O O O O O O o O O O O O O O O O O O O O O O O O O O O O O o O O o O O o Ci C 0 C C 0 0 C C o O o C Vj ol a o� of o\ of of N O of O 0\ Q` Q, T O, O 69 ° o C o 0 0 0 0 0 0 0 0 o e o O o e o o �O N N O ^ N oo Vl oo vt v/ h b O m 7 V '7 R K tit O N N N N h Ml ° � Q Q O V � Ln N o 0 0 o w V \ W �., 0 0 0 0 0p, 0p o o 0 0 0 0 0 00, 0 0p Z N U U N U U U U U N U N N N U CQ1 N W Q Q Q Q Q Q Q h Q Q Q Q Q Q Q Q Q W W W W W WW W W W o 0 0 0 0 0 o c o 0 0 0 0 0 0 0 o w w w w t= w w c w w w u u u u u v u o u u u u u u u u u U U U U U U U C7 U U U V U U U U U Q W � m ro m ao 00 0o v� h m h a a rn rn � m 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ol N O \ \ N \ O O O O O O O tm 12 a Y � Y °1 Y o Y q P7 m a a o Cl. Y eo W 50 c `-� �, U �q m ° •a• H o° PS v o0o adi c GG Vl !% G r C. ` " o O U d O W a .� w .� v, � v � mc�i � � xU u � a � � w a � w .3 zU 33 o .• o 0 0 0 0 0 0 0 0 cy o hO N V1 h h h N O Al i+l N q O� O O O O O O ^ N N \ N N V O O O O O O O 69 of N O v M h M M U b J ti V 49 N �O r Vt V N �/1 ✓t Ol h �o 00 o h vi vi �n o h M o lo 10 aO of O O cl T O O O T O U O Cl O� O� O D\ O O H J C iH O O O O O O O O O O O O O O O O O Z O O O O O O O O O O Cl O O O O O O O O O O O O O O O O O O O O O O O �i Ly r h C, O O h O h of h r r O r vi vi O O. T a O O C, O D\ Ol of U 0` O Q\ of O, Un Ll U ` � O C C 0 o O o o O o 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O O O o o O 0 0 0 0 o O o 0 C 0 o O o 0 0 0 0 ty r rn o o o r o+ Vp o ol rn o 0 ON o rn o, o, o, o 0 o rn rn rn sv q o e a e o e o o 0 0 o e o 0 0 0 +l vi o vi o 0 o O 09 o O Cl 0 00 ^ o W O N N K 7 M V M O M N M C N M v v A Ly O U fy! o 0 4Oc1 e o 0 o ee o o e o o e o o e o 0 0 0 0 0 �n o 0 O O O O O O O O O O OO O O O O O a a a a a a a a a a a a v u u u A A A A A A A A A A A A A A A A �i k1 w w w w w w w ww w w w w w w O O O O o O O o O U U UU U U U U U U V U U U U V tG W W 47 tG W �C. 4: W W 4. 4t= v u u u u u u u u u u u u u u U U U U U U U U U U U V U U V U U ho. o, w oo ro rn m m ao —0 rn rn m o. rn r r iy o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U O O O O O O O O O O O O O O Y ° P7 a° � O L Y O d w Pa ° h o U o 04 O v u � Y � � pp °o u `° � ❑ a U U ° °" ° u W � � 3 ° � F^ ? °� u a °o .� eo U c ` _d cui `° ° w yt a a"0i ani o u -Y 3 0.0. or� a_ 3 3 M n o o �o > a0 ee u E o u a o oam ww3 paA Q � uv wz N N N N N N N N N N N N M O O izi O hiz O O O O O O ^ O O O O O O O 70 { O` d � " N N •/� N h d OC rdn N � O Ki 4 � T 00 i.7 Cl r O to p O O O O O O L7, OO O W OD y O � v� 6 e0 a N w V o a w Qo o O O O O W o o c m es c U u U T \ o ^� o o = d O Ln Fr n un Od 4 O R W N F4 � O O e°a � c rail ?" d gyp,h y`^�•• o ''e °� � 3 � � � 5.� o.4 A °' < � m � d � ani r � a cn r+ a d NN•' � d .n ;n 3 Ebyy. N " d O N City of Ataseadero Investments by Type June 2009 Cash with Certificates Government Fiscal Agent of Deposit Securities 1% 17% 2% Other 0% 1F LAIF 80% Investment June 2009 LAIF $ 32,719,992 Certificates of Deposit 6,937,577 Government Securities 924,181 Cash vnth Fiscal Agent 84,308 Other 1 $ 40,666,059 *40K Page 9 of 12 72 City of Ataseadero Investments by Maturity June 2009 Within One Month One Month 1% to One Year 5% One to Five Years 14% On Demand 80% Investment June 2009 On Demand $ 32,719,993 Within One Month 98,000 One Month to One Year 1,921,627 One to Five Years 5,842,131 $ 40,581,751 73 Page 10 of 12 City of Atascadero Investments by Custodial Agent June 2009 Other Union Bank 0% 19% Bank of New York 1% State of California 80% Custodial Agent June 2009 State of California $ 32,719,992 Other 55,628 Union Bank 7,806,131 Bank of New York 84,308 $ 40,666,059 Page 11 of 12 74 City of Atascadero Investment Yield vs. 2-Year Treasury Yield For the Quarter Ended June 30, 2009 6.00% - _ t t 5.00% k YF s 4.00°/p 3.00% , f , ':,,F s i F 2.00% {F r " ^ ,f .c S 1.00% �1111� f 0.00°/D `ry�� m gmQ 00 �mQ O City Yield --G-2 Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield June 2007 4 83% 4.23% September 2007 482% 374% December 2007 463% 3.30% March 2008 402% 219% June 2008 3.35% 2.86% September 2008 3.33% 2.43% December 2008 2.93% 1 41% March 2009 2.44% 1.39% June 2009 1 91% 146% 75 Page 12 of 12 Attachment 6 -e ■e e p M-79 CADF� Atascadero City Council July 2009 Staff Report - City Treasurer July 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for July 2009 REPORT IN BRIEF Cash and Investments Checking $ 408 691 Money Market Accounts 1 Certificates of Deposit 8540,647 Government Securities 924,181 LAI F 29,986,502 Cash with Fiscal Agents 84,308 Cash in Banks at July 31, 2009 $ 39,944,330 Deposits in Transit - Outstanding Checks (622,319) Cash and Investments at July 31, 2009 $ 39,322,011 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 07/09/09 GE Money Bank CD $ 150,000 07/09/12 07/15/09 American Express CD 150,000 07/16/12 Centurion Bank 07/17/09 The National Bank of South CD 250,000 07/18/11 Carolina 07/17/09 First Business Bank CD 250,000 07/17/12 07/22/09 Barclay's Bank CD 250,000 07/22/11 07/22/09 Mercantile Bank of CD 250,000 10/21/11 Michigan 07/24/09 U S Century Bank CD 250,000 07/22/11 07/24/09 EagleBank CD 250,000 07/24/12 Page 1 of 14 76 investment Activity (continued) Securities Matured Maturity Date Description Type Original Cost Amount Matured 07/01/09 Soy Capital Bank & Trust CD $ 98,000 $ 98,000 Securities Sold/Called Prior to Maturity- Transaction / Original Cost/ Gain / (Loss) Tran Date Description /Type Maturity Sale Price on Call Full Call Centennial Bank 99,000 99 000 - 07/30/09 Certificate of Deposit 11/30/09 Other Reportable Activities None ( 77 Page 2 of 14 CITY OF ATASCADERO TREASURER'S REPORT CASH&, INVESTMENTS A CTIVITY SUMMAR Y FOR THE MONTH ENDING JUL Y 31, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at July 1, 2009 $ 393,684 $ 40,581,751 $ 84,308 $ 41,059,743 Receipts 1,671,698 116,580 - 1,788,278 Disbursements (2,903,691) - - (2,903,691) Transfers In 3,877,000 2,630,000 - 6,507,000 Transfers Out (2,630,000) (3,877,000) - (6,507,000) Balance per Banks at July 31, 2009 $ 408,691 $ 39,451,331 $ 84,308 39,944,330 Deposits in Transit - Outstanding Checks (622,319) Adjusted Treasurer's Balance $ 39,322,011 Page 3 of 14 78 N O O 00 O O O O O O O O Er C O C C, o O O O O O Cl O z O O c O O G O O O O O WO Wr r - r r r o o r 00 oo 00 C, rn rn rn rn o o rn rn o o� W o, OW N 69 m c0 ad cd cd c0 cd 03 \N cd cd co �C C W U e N -- Cl O 00 O O O Cl O O o Cl Cl O O U Cl O O O O O O O v� O O �c O O O O O Cl O o r r v r r r o o r 00 00 V W7 oo rn o. In rn rn rn o o rn rn rn o. jN 6R Q o 0 0 0 0 o e o 0 0 0 0 'J V cn O V% O O00 O O O CD O Cn O > U ON O O� 0o Vl r O O M M V' M M V 7 V V W [. m 0 0 0 0 0 0 0 0 0 0 0 cn O V'1 O O O O Vl o cn e � � C, C, O Q\ 00 W cn �n O O O M M ^' V M M V V CY V 7 0 Q O W V U c0 R cd cC cd cC t0 cC cC cC c0 cC cO 44 ti E.i O O O O O O O O O O O O z a a a U v a a a a o a a d � W ;, q Q Q Q Q q Q Q q Q Q ,��` p •d w w w w w w w w w w w U o 0 0 0 0 0 0 0 0 0 0 > w a a a s ca m v a m ti y p C C C C C C n U U U U U U U U U U U W V K M V U V r r Vl V1 vl W o 0 0 0 0 0 0 0 0 0 0 O N O O O N A M O N O O� ON M C, C, O .\N-� N N O O Cl O O O O O Y C z � Y 0 -� d � •c w on � ►7, j � E-� Y RC C � Fry [-+ � w c U y ] Y � ¢ W e a h w y Y y a > cc c a mU d a - � ¢ �°. Q v se 'v o � a 00 4) L w $ a .S = cca �o a U w1>1 c .a v b Py d r S bo.a OR U o Gr�i 6ray a d s S u o L d 6 > u � ¢ Aa H3 CCw 3 � ww .a3 Qw wx v W a o` a rn o. C, o, o, ON o 0 0 o 0 0 0 0 0 0 0 Ell 'a - O O O N rA Q O -+ N N O (, h C� a\ O OO, CN O N N C O O O O O O O O 79 CD O o 0 Cl C. 0 0 0 0 o O c h o 0 0 0 0 c o v, 0 0 0 o c 0 0 0 0 0 o c o 0 0 0 0 0 Ct W n r o r- r 00 00 C, 0 0 00 C. 0 o1 rn o o, Cl rn rn o, 0 0 0 0 0 W � � O j ti ss 0. e 0 0 o O o o O O o 0 0 0 0 0 0 o O o 0 Cl 0 O O 0 0 O 0 0 0 0 0 o O o 0 O o Cl 0 W) r o r r 00 00 O o 0 00 0 0 V j CN o, o o` rn a` o, 0 0 0 C, 0 0 W � W) J 1.19 Q o 0 0 0 0 0 0 0 0 0 0 0 0 y O O O O vl O W vl O O O N n 1- N M N V N N M N N W 0 0 0 a 0 0 0 0 0 0 0 0 0 O O O O O O O O N /1 l- N M N 7 N N M N N mm ca 0 cd co c0 c0 �C ca v a � a a � z o � � v Dti [r o o 0 0 0 0 0 0 0 0 0 0 U ti Z a a a a a a a a a a u n U N U N U N N N N N N N N W Q Q Q Q Q Q Q Q Q Q Q Q w w w w w w w w w w w w 0 0 0 0 0 0 0 0 0 0 0 0 U U U U U U U U U U U U 0 v U V 0 U U U U U U U U U U W � n vi n vi o v� �n o0 00 0o v-i o0 00 O, N O, 00 N U ,O !� 00 O m M ,D [- [� t� i� r h n r r O O O O O O O O O O O O O 0. ur°°n G1 O z Q Q y O s a Y pa c d pa 4 a p o d o c u �G tij z � 0.nl z o � o c zpQ cc a o z O F, W w x E o A en C7 Y = w r y c m y Z A y cc c ° c - i u c o °�' u y a`a cd ai p > °' c ccd xx 3v wu m vas xx � 3w z � ww xu x � CD 0 0 0 0 0 0 0 0 0 0 0 0 Ir M r h O, 00 N Vl �O ,O O M M 0 0 0 0 0 0 0 0 0 0 0 0 0 80 C O G O O O C 00 Ol G 0 d C> o 00 r Q 0 0 a 00 ,o 0 O C Q oo a O p V a O C N C:) cC co z � R � p o p o. o, p O o 0oo 0 00 CyCi O O oo Ol 00„ r- � O O O p o0 O+ O O O o un \ O N d CA ,z q o n N ct rCl .ZT C N d >+ c In 10 d Ir O N +n cc 3 lL c v� d C W VI oo r n a N O W a p Q y u w U U H 2 Q V W W w a y U N U U O Fes- 'c o U oo a v N d C} o Zlio Cl Z U U o In O o 0 0 pp Otol O op O W O y O E^ Cl oo O C4 a O C ol lo c y w ccn d v� a�n itn c � c o a m q "bn Not tAw o N g a a C o u O :6r, O O O M OC p F-+ W o �? Q o 0 E. n oO p 4-• q o O O G � O O O O G O Q p O O O p r G O. r O, O O W Ov O p CT r O r O F. u o0 0` 'r m Gt Wol @ 4 @ m L O Z @ @ @ G O Q O O O C) O O O 00 o6 Ol O p' r O� O p p0 O a, 0 C O N O n N o e c p r N o N N \ .on O v Q 0 c p rn c-.1 o o <t o O oo rl w d c vi O V o O M N ti O `n vN r c p ' N N @ o p W O03 Cd <t @ r @ @ Z @ d @ O F. @Cd o W a W m m o o afli pv ol U w U U U o ol o (71 C7 of o `r N N o Q. few c. 4 G G d y cd as � � tV...., '+�• C6 � U a e3 � y @ � Pt O � C4cs o X p O � N M es �j cyd o N d iy J o m a t y > eO O C O W U ,..• � C N N O O oo O CD 0 0 0 o O o 0 Cl Cl O_ Cl o !. O O O C O O Cl O OC O O Z O O C O O O O o O O O O C-- CD o o r o 0 Cl O o r rn r r r- o o rn vi n o rn rn rn o rn N N N N oz (� ro ro ro ro ro ro ro ro ca ro ro ro ro WV 0. ~ e O C O O O O O O O C O O O Cl O O O O O O Cl Cl O O O O O O O O O O C O O O O Cl O 0 o r o 0 'C=4' 0 o r- o r r- r V a O O O, N N N N O � a\ of of O\ Fig A o 0 0 0 0 o a o 0 0 0 0 0 Cl O�v1 O O O O O C O � O O O U O O 00 oo O t� O V V M N N M V M N M W o 0 0 o e o 0 0 0 o e e o O O Cl h O O O 00 O O O O y+ O O O O� O� ON O oo O t� O V 'a' M N -+ --� 7 M V M N M q w o W V � C4 cc c0 coro ro co ro ro co ro ca ro ca O \' r. •� Vl •N .N -t4 4 •4 .N •� •N •N N Ur1 E� O O O O O O O O O O O O O W a a o a a a a a u o a v a W Q Q Q Q Q Q Q Q Q Q q q Q 0 0 0 0 0 0 0 0 0 0 0 0 m m m m m ro a m m m m m m U U U U U U U U U U U U U �:. w w w •w' w w w w �:, w w w r t: C C t: t: X t: U N N N N N N N U N N U U U U U U U U U U U U U U U W CW o0 00 o ON ON rn rn 00 00 0o ON rn ON .y f- O N V N N O O ookn ►J O O Cl Cl Cl O O O O O O 4 W C h Gtl pD L Z U e e Y U ] W C e Y Caed b as o w e ev d rob wLO a aCi w c S U °a ai °' tiL 3 W .� E u e zca z � aa3 � Q c7 a3 C N N .5 d c� t7 ��' of d O d F, � ro cd O O O L > ►. �.7 W cn U' cn O O O O O O O p 83 O O O O O O p p O O O G O G O O G O O C) O O O O O O G Cl O O\ o a G O G G O C=l D, O G G p N Z O Q 6 O A Q A A A Lld Z A A t �L A p O O O O Cl GO O O O O ^ O O G Ott O^ L'+ O O O� vi O• O O O O) O O O O kr N CD p O r.. ,iy •-� W o � 0 c [" EA d a O pc-4 10 Q d c� } c O cy In � N c Q W o O D N A N ° M � G d N A d w co A A F4 z A W A A Q W •O 4 p' p p �'"' O y '� ti 2, W Q w O � A J V.+ �• N U oo J LH U C U N o o N N po o rn o n r o 0 W op 0 0 of c G v� o o r o W ClO N r O O Kr A O O C G ad fSi O O gyp ' C6 c w w O a c 0 OC -1 o w °� m vs En fs0 En tb dU to N N N es Qa G1 N 1y N 3 N rn N ^IT N pry N N ap Cl N lO r O O N O E O N r O 00 [. O O GG 0 M O Cl � t�f Z O O G O M M ll �O LL w O O O O V V kn O O O O O V1 00 00 M C V7 O ON O W M M z C:) Cl $\ N v ON bA �' U O O O O O O O 0 U U a o 0 0 0 00 00 M C ) (° > o a W o� v CD U o e n .o a� a r n q 4�j a W V d w S E 5 Ln n o U cl. m W A A A A o 4,, U U U U U Z w w^ Al cn •3 ro a� N o O o o CC M O O V 2 G N t\ M c,.. 'fl aQ O Cl O O 4 c N o • U O y � r w � ° o c v O A ° Y V r4 .0 0. v ,-+ W Y U w � � � Ca 'b Ca H � w � o �•"^ � � u O U ��+ y o 43 UC7 U Al on 4 a N o o v -0 q ca w w ¢ 3 u H 85 City of Ataseadero Investments by Type July 2009 Cash with Certificates Government Fiscal Agent of Deposit Securities 1% 21% 2% Other 0% LAIF 76% Investment July 2009 LAIF $ 29,986,502 Certificates of Deposit 8,540,647 Government Securities 924,181 Cash with Fiscal Agent 84,308 Other 1 $ 39,535,639 Vftw Page 11 of 14 86 City of Atascadero Investments by Maturity July 2009 One Month to One Year 7% One to Five Years 17% On Demand 76% Investment July 2009 On Demand $ 29,986,503 Within One Month - One Month to One Year 2,813,648 One to Five Years 6,651,180 $ 39,451,331 87 Page 12 of 14 City of Ataseadero Investments by Custodial Agent July 2009 Union Bank 24% Other 0% Bank of New York 1% State of California 75% Custodial Agent July 2009 State of California $ 29,986,502 Other 55,698 Union Bank 9409,131 Bank of New York 84,308 $ 39,535,639 Page 13 of 14 88 City of Atascadero Investment Yield vs. 2-Year Treasury Yield For the Month Ended July 31, 2009 6.00% 5.00% 4.00% 3.00% 2.00% 1.00% / l 'Moot 0.00% �� tiA pec �e< City Yield --w-2-Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield September 2007 482% 374% December 2007 463% 330% March 2008 402% 2.19% June 2008 335% 2.86% September 2008 333% 2.43% December 2008 2.93% 1 41% March 2009 2.44% 139% June 2009 1 91% 146% July 2009 167% 132% 89 Page 14 of 14 Attachment 7 1918 , 1978 Atascadero City Council August 2009 Staff Report - City Treasurer August 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for August 2009 REPORT IN BRIEF Cash and Investments Checking $ 1424,529 Money Market Accounts 1 Certificates of Deposit 9,290 721 Government Securities 924 181 LAIF 27 456,502 Cash with Fiscal Agents 229,949 Cash in Banks at August 31, 2009 $ 39,325,883 Deposits in Transit - Outstanding Checks (936,613) Cash and Investments at August 31, 2009 $ 38,389,270 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 08/24/09 Columbus Bank &Trust CD $ 250,000 02/24/12 08/26/09 Lake Forest Bank &Trust CD 250,000 08/27/12 08/26/09 North Shore Community CD 250 000 08/27/12 Bank &Trust Securities Matured None Securities Sold/Called Prior to Maturity, None NW Other Reportable Activities None Page 1 of 13 90 CITY OF ATASCADERO TREASURER'S REPORT CASH& INVESTMENTS A CTIVITY SUMMAR Y FOR THE MONTH ENDING A UGUST 31, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at August 1, 2009 $ 408,691 $ 39,451,331 $ 84,308 $ 39,944,330 Receipts 1,543,803 73 - 1,543,876 Disbursements (2,162,323) - - (2,162,323) Transfers In 3,375,000 1,595,001 145,641 5,115,642 Transfers Out (1,740,642) (3,375,000) - (5,115,642) Balance per Banks at August 31, 2009 $ 1,424,529 $ 37,671,405 $ 229,949 39,325,883 Deposits in Transit _ Outstanding Checks (936,613) ww Adjusted Treasurer's Balance $ 38,389,270 91 Page 2 of 13 0 0 S 0 O d 6 pp O q O C 00 O` O C q f., a. G O p of� G C 0 0o r o Ol o r rn O O r In [r v A 2 A vz to C vsL d N hva ed U , vs 1.9 It Cd @ 0 0 'Z. q C p O co rn O p o C, r a, ti O G G O 4e r o o q o r r a o O v, C-4 o r- Cl o Cl z v v 7 V3 c C oo c e c O Q, M o p M \ O 7' o Ol a Q M 7 M o O O .er o O oo et c C a M v� O M A cs a' M H A W LO A to r ce W � o• W � Ey � � � � .. m O � a �i �+ N �Vj � ✓ ''in O d a Q O N 2 +tea o U U rn o N N o N O M C � O CID u- 0. d A U OY i ai CA d a> p °may° °• 7 3 � W C:) 0 wC ed eye d s3 � � o O p`l N (nd G a ol o w N r4 o F o ri W F' CY, O` C, c O + O p O d Ems- q r CD 0 0 0 0 0 o O O o 0 0 0 0 o 0 0 0 0 0 n o Cl Cl O o o O 0 0 0 0 0 o rn o 0 0 0 0 0 0 O W r o r r 00 o0 C, 0 0 00 0 0 0 0 orn o rn orn o` o. o. 0 0 0, 0 0 0 0 O U o c ca w � e O o 0 0 0 o O O o Cl 0 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 0 O Cl O O O O O O O O O O O O r o r r oo m 0 0 0 00 0 0 0 0 U w' a, o C, C, C, C, Orn o 0 o o 0 o O ss A o 0 0 0 0 0 0 0 0 0 0 0 0 0 J O O v1 O O 00 O O Cl In vl r N M N 7 N N ^ M N N N N C' C' It h V w 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Er O OIn O v1 O v1 O O O O vi N aT V V d' 'ct 7 V V Ct V V O � C4cc a Q W Er W h a O � Q (. o�U C 0 0 0 0 0 0 0 0 0 0 ti Z v a a a SZ. a a a a a a a a U N N U U N d N U N N N N GU q � q G1 q q q q q q q q q q w w w w w w w w w w w w w O O o O o o O o a id id ro A ro c0 cC td itf id id as c6 U U U U U U U U U U U U U ti > C C C C X C C a� o U C7 U U U U U U U U U U U U W � h vi o h � o0 00 0o vi ao 0o r o0 0 0 0 ^ 0 0 0 0 0 0 0 0 0 0 O\ 00 M M 00 � N N N O ^ ^ � •-- ^ N \ N O O r r 00 00 O O O O O O O O O O O O O O 4 c c � d � W C C •p C C O oa d Y m 'w q cn r. yco� ow o o a C7 ea C U u x .2e; F r z O E N °' o z 2 Ay 'N `c eu 0 3 Oy q "� L N h U b Qa y w Z L 3U wU 0 vd xx 3a z � ww � 02 ;D V) 3x z W o 0 0 0 0 0 0 0 0 0 0 0 0 0 N 00 N M C O M M O V e A v o �o r r r [� r r r r r r o0 0 Cl Cl O o 0 0 0 0 0 0 0 0 0 93 0 O O O G � � p OG O. O O O oc O� 0 o x c o r o` 00 rn d O 00 CT O a O r Cl O C O oo O, Ul kn cn 03 a CD � OJ G a O O O p C) r o o m p a o a o W V o 0 0 00 rn N C) 0 0 06 rn 0. o r rn G o 0 00 rn p O 00 of p Cl. r OO 00 a O O v Oh C) O N ti o °o r? a o o N O a c O N a ro W d or, Ct p o Z z c3 Q' p r�j1 �fi p v Q qw o R o U U 0 4'- � q " y � v � ^� V 00 00 CD C4 00 ON". C;y y tq G o U 00 o ra c'4 d U 00 o n Cl w U 00 0 ,n U r o n o W 00 p O V] w 2 Q � O Cl. CS O p a vs osco R X O U U o ;� �✓ ,19 U c3 6 E y w c �0+� p6 r d a� ❑ C w ,y o o w U rn U o rl r� a (7r p r F gyp,. C+ W �i �, cn O q �`'... F+ �_ � Iv O SO.6 . d v', m p N N •- �+ o O N d O !t O, O O O cn 00 C O 00 O O 00 O 0 0 00 0 0 0 0 O C" N p O O p � O p O 0 0o rn o C, C, o p of 0 o c r o 0 0 o a� F o o 6 A c. w o rn A a A > -z A U Z A A A A O O ►fir � O O O O p O N U p O C, O c:> CD cr, O G p O o O o p rn O O p C a p Cl o c- rn p0 0ol o 0 p r rn o rn o o0 v o p N 0 0 o M o o o O N Y Eft 00 N e in O O N Wr "d' c vi C-4 N ,, . 03 D. A A p• d Q �p o• d Q Q o N � U � � � U U 4=�tz -e. k, N U U Q O 00 U () 00O t� ol 10 O [U n o0 O U U 0 o N n o 0 q O p N r O Q� O` 00 r. O e5 6` O C N c.1 O E W c 0 c o _ o Q F N O O p rA U e c3 0 0 � q to 0 Vl c v as es Y O � KwW p � COD m i .� w c! LC ca Pa ai in W pU CAd = C ,, Ucn Q W 0 o N oo N o Z U 3 j ago a` !Cc! n O r 00 O d O c1 3. O t3' N O O O NO � q � O O O a p C O O O p G r n d O p O a O N C O O O a, o r O O O p r T O O O p Z O N A G *r A A O O O O p D O N W V o 0 0 d rn O O O O Ol p p a. r rn rn 0 0 0_ o rn 0 0p o ^ CD N 0 W a N o O w W a N e 'O N M p o o r_ M c O O N c 0 o 04 M \ O D c p O M o O ^ N as � D` O O N c ✓� M � o O O M A G o C4 A u A Q M �j ✓, y O N Q w O N J W � Vj 'Q •�n � � (] o ami � v t.^. � w U w U O O N U of O D U 00 0 00 o r- o 0CD 0 0 0 o 04 Ow d ao C4 o y d re U s o C h pa U W C� 25 cm S le W 642 d c w 7 U V Q V) c Q g :. Ga b ~i c o W cm co N rn v p zf ' � s•y W� N o O ^ 4� Q o 0 0 O C O � p O O p O O O O p O O O p d O O O O O O Q O 00 O O O O O O C v F-. O O p N cd c0 O O O O C> O O O O O 0.y q O O O O O O O O O O O O O v� p O p N O p n N O N o 0 Q o 0 0 ^ a o n r .y c c v. �O a a o u \ -I a q o O 'fi N a p �/? a a N o o c o r) cn a c O N a A w \ p r M N ,•- W (,aloof Z ~ os N o Q y' �„• o a Q O W Q $ oo- � (� Ow o a� -' � w •� d U ay v w o,� ro - U a, o ;� v u U O0 0 � w U U o d o ^r u: ani U O v Uoo co c� o o 0 N N o N N Z;� r aO O to,) ol a q o o p Y e y� U ¢ cs cd 4 4 � w. w a 7•' � � 7 W Ya a' o ❑ a O � a pa � o a o U a w c v Z. W P Kl 'ai A P a F� CSC cp �• 03 p A O ad d U C V v A w � 'U •�, a � w w � 8 aai z o d � �^ r SO c-A In VA es O N � [=- N o0 •-• C N pp O r NooO 'o C o Pte• A o 0 rn v� Q d d• N tN"y �": G �O N N M ✓ N G �• T w 7 O m � � o e � A U O v ' 9 -a v IT. o 0 v Ry tw an a A W o c a y F" rp s G 7 I G 34 Q g R y 00 d � V N y O C4 o w Q o tit cl T M' O y tNd U 9 Q Q d <+ Q A N N e 03 moo d 7 D City of Ataseadero Investments by Type August 2009 Agent Government Cash with Securities Fiscal A Certificates of Deposit Secur2% g 25% 1% Other 0% LAIF 72% Investment August 2009 LAIF $ 27,456,502 Certificates of Deposit 9,290,721 Government Securities 924,181 Cash with Fiscal Agent 229,949 Other 1 $ 37,901,354 99 Page 10 of 13 City of Ataseadero (investments by Maturity August 2009 NOW One Month to One Year Within One Montt 8% 1% One to Five Years 18% On Demand 73% Investment August 2009 On Demand $ 27,456,503 Withm One Month 443,771 One Month to One Year 2,992,594 One to Five Years 6,778,537 $ 37,671,405 Page 11 of 13 100 City of Ataseadero Investments by Custodial Agent August 2009 1401 Union Bank 27% Other 0% Bank of New York 1% State of California w 72% Custodial Agent August 2009 State of California $ 27,456,502 Other 55,772 Union Bank 10,159,131 Bank of New York 229,949 $ 37,901,354 101 Page 12 of 13 City of Ataseadero Investment Field vs. 2-Year Treasury Field For the Month Ended August 31,2009 6.00% 5.00% 4.00% 3.00% 2.00% 1.00% P 0.00% �`ryopl g � � O Jce�oo �e�ooo� e City Yield ---0+•-2-Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield September 2007 3.74% December 2007 463% 330% March 2008 402% 2.19% June 2008 335% 2.86% September 2008 333% 2.43% December 2008 2.93% 1 41% March 2009 244% 139% June 2009 1 91% 146% July 2009 167% 132% NOW August 2009 163% 1 41% Page 13 of 13 102 Attachment 8 1918 ■ 1978 C"lDFR11/ Atascadero City Council September 2009 Staff Report - City Treasurer September 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for September 2009 REPORT IN BRIEF Cash and Investments Checking $ 1,372,793 Money Market Accounts 1 Certificates of Deposit 8,902,788 Government Securities 924 181 SAIF 25,836 502 Cash with Fiscal Agents 79,622 Cash in Banks at September 30, 2009 $ 37,115,887 Deposits in Transit - Outstanding Checks (835,086) Cash and Investments at September 30, 2009 $ 36,280,801 Investment Activity Securities Purchased None Securities Matured Maturity Date Description Type Original Cost Amount Matured 09/01/09 CIT Bank CD $ 97,000 $ 97,000 09/01/09 Flagstar Bank CD 97,000 97,000 09/22/09 Delta Trust & Bank CD 97,000 97,000 09/30/09 The Peoples Bank CD 97,000 97,000 Securities Sold/Called Prior to Maturity- None aturityNone err' Other Reportable Activities None Page l of 12 104 CITY OF ATASCADERO TREASURER'S REPORT CASH& INVESTMENTS ACTIVITY SUMMARY FOR THE MONTH ENDING SEPTEMBER 30, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at September 1, 2009 $ 1,424,529 $ 37,671,405 $ 229,949 $ 39,325,883 Receipts 588,355 67 - 588,422 Disbursements (2,648,091) - (150,327) (2,798,418) Transfers In 2,823,000 815,000 - 3,638,000 Transfers Out (815,000) (2,823,000) - (3,638,000) Balance per Banks at September 30, 2009 $ 1,372,793 $ 35,663,472 $ 79,622 37,115,887 Deposits in Transit - Outstanding Checks (835,086) ( ' Adjusted Treasurer's Balance $ 36,280,801 (10000, 105 Page 2 of 12 0 M0 O V M a rn r °. rn o 0 / r ^ to rn o. C rn rn j I rn a `° jC� o 0 00 0 0 " o o o 0 0 o O o m m v+ o o ol 00 0 00` h m °, rn 0 0 00 0 0 0^ �" rn o of N o 0 o r o 0 0 o rn rn O � hIty N A G 0 0 0 0o q 4 q o 0 0 N '�- O O dO• oo W yr °' �' vi 0 o r rn rn 0 0 0 0 ol W a, o Q � N `l o e � O A c e o O N 4 e O N M V CD It N � sy 1•' 7 rn e o 0 o n 2 v Fy Ln _ z O ZrZI Id Z ¢ En tr_ w w o v U U U W FLam_ L=' i" y v U U C7 U N m cn N O O uo h r O O ON r2O 0 O O C � G is in pp tod ° ca 4 ¢ ° X y 15: Q > z U > > a m roId U ° a U y O M N r0 p O D. a m o 0 0o p o 0 0 0 aW d A o 0 0 0 Q t] N O N Q N n0 h V r w N r �O N DD M lo v rn o o+ p r N t W � Z Ir t:14 vi 7 C Y1 vl h M �O N N N O N N M N N N Q O O O U (A O O O OO O O O O O V O O O O f� v1 O O Cl O O O O O O 7 O O p O O O O O o O� O O �D O O O O O W Oi O O W O O O O O O V r o0 m r O\ O O O\ O O O O O O N D` T O• C7, P Ln CO) U � (` o w m aC nt A A N N ro b� 10 W U IDC ti ID, A va 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Cl Cl O o o O o 0 C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 O O O Ol O O O O O O N O, Or+ U ol P Vi q o o a 0 e o 0 0 0 0 0 o e o 0 0 O [„ W oo vi vi O O O O O O vi vi In p v� �n W N N ^ Cl! N N N N N N -^ Vl IO N N O W w O o v v v e v <r h v 'IT c v v r a a v C N In O Q F" w o 0 0 00 0 0 0 0 a o 0 0 e e o O N O O N O O t" h O h q u v v u v v v v u v v u v v u v W A A A A A A A A A A v Q A Q Q Q O O O O O O O 0 O O 0 O C O O 0 O O O itl N N u u u �E tC W td N Ttl itl ttl N U U U U U U U U U U U U U U U w w- w w wE e: �e r r r r r r e e > c c r u u u u u u u v u v v u u w QW o0 0o ao vi o0 0o r m m oo � vi vi 0o m o0 V e b r ap Cl M n1 M OO 00 M Ol O, V1 Vl O O O O O O O O O O O O q Y G � N Y W ao a Y QQ �7 C � o u fir. Sryry4 O YQ U WN Ca f� W C 3 a A 8 d Q G r-1 C y 00 Eon 3a zW W � l`twrr�` W o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0ZZ rn o h vi Q n t- C r r t- r w o0 0`0 0 o 0 0 0 0 0 0 0 0 0 0 107 N O O rn O M .V r p' r C ori 00 m cl Q: U ,U oc N N N O T \ err' O CI 0 {� p, p, O' ,p O c0 ty� W O O O, M CO C, m n op N o, o, o, o, o o rn 0, o vi 0 o O n o 0 0 0 0 Cl 0 0 0 0 o O f. o O o m o 0 0 0 0 0 0 0 0 0 0 0 0 0 C ,n o 0 0 0` C 0 0 0 0 0, C C , WO W m 00 oo; o r o noo r r n o r m o: rn o, rn rn o rn o o, o+ o+ o, rn o o, o. rn O U � � N eE ,d r+l ctl ,tl � A A N ,E N m N N ttl O aq O O O O O O O O O O O O O O Cl O O O O O O O O O 0 O O O O 0 O O O O O O O O O O O O O O O, O O O 00 00 0� o o o r` oo r" U j o, rn C, o 0 0, o rn rn o, o. o, o o+ o, o, vJ �1 v, 0 0 0 0 vJ o 0 0 v, `v, o o W O O V m -It N N N N h M N N O A a o N O h O O O -It O y 4 CL V .Z. WV w w w w w w w w w w w w w �L o 0 o F o 0 0 0 0 0 0 0 0 0 0 0 um U 0 id eC m m m E U U U U U U U U U U U U U u u u o u u d u u u u u u u u v U U U C7 U U U U U U U U U U U U x W o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N 0 N N O O O O O O O O a D Y Y q 13 4 W r ¢ e °o Y c 00 K+, W Q L O C uti a � u oO aw P7 0 mC7 o d V� W m ;q u a o w ai x C — v ED m o o w U V-) w U CA U U n Q S w a ' w a z U 3 3 U v) CW7 x F+ > O O O O O O 0 O O O 108 W `I C N Q O h vl N �D h O� 00 1� M 00 a0 O NO M m •--• v � m m M ^ '� � ^' v K O N V O m O Ch 00 10 "J O iA O O O O O O O O O O O Cl O O O O ZO O O O O O O O O O O Cl O O O O o w O O r O O O O O r a r r r O N O a, o O Ol to� h O �1 O ti C A 0 0 0 0 0 0 0 0 0 o O o 0 0 0 0 O o O o 0 o O o 0 0 0 0 0 C. 0 0 0 C 0 o O o o O o 0 0 C 0 C 0 0 0 0 0 0 0 0 o V `w�' O O T N N N N O O, O, O� Ol U O T N w � q o 0 0 0 o e o o e a o o e e e o 0 0 0 0 0 0 w — o 0 o rn ON o 0 ON o p Ci„ O CIn E, O F. ^n o O v v o 0 o v o 0 0 0 Cl 0 0 Cl o rn rn o 0 m -- o n o �n rn a �y k4e er N N 'V K G] A. O Q RR A R AA W R \R \R R \R R A A A R 8. 8. a 8. 8. K 8 w w w w w w w � w w w w � o O o O O O U O O O O 0 O O O O O itl A N R A A A A R A R itl A U U U U U U U U U V U U v U U r C t C C C C C C C C C d d d U U U U U U U U U U U U U U U U C w o0 m rn rn rn rn rn m m m o o rn m rn o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 jQ O O O O O O O O ^ O O O O O O 4 A 0 e a ps 6 -oda a z _ m is a s w a aS U c A A A x cm o a o aLi o «y y4 $ ° a o x 6 a Uw Elm) Z, z, � w3 DA A a3 � � {T A c7 � as m° w` w 3 � aao -uU Q h n 0 n 0 O ^ f\3 N N N O O O O O O O O O O O 109 C h o• oo c o a c r y a� of O, P N T Vt 10 � z rw D` M G G M �/t o• �/1 r• h Q+ O M b T oc r- 0o R N o0 7 00 O: oo Vt Vt vl r• r O' V O O O Vi O O O O O O O O O O O O o O O O i O O O O O O O O O O O O O O O O O O O O O O O O O G• O O O Gig Iii n O O O O O O O Cl O O O Cl O O, O O O O O O O � h W O 4 ti C A 0 o O o 0 0 0 0 0 o O O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C 0 G. O o 0 0 0 0 o O r o 0 0 0 Cl o 0 0 0 0 0 0 Cl A e e o 0 0 0 0 0 0 0 0 o e o 0 0 O � Lj� .-• `O V1 V1 h M M M N M �D �O [� �!1 V R O O M N N N N N N y O N � O O h h O O O h r N N Q ol U \ w R RR R R R R R R R R R \R R R R R ti CL rL & S S W A A A A A A A A A A A A A A A A W W W W W W W W W W W W W W W W W (liyyV' O O O O O O O O O O O O O O O O y U U « U U « « « U « « « « « « « R R R R R R R R R td S U U U U U U U U U U U U U U U U c r c t� r t: c W o. rn o. o+ rn o. rn y oo n r r C> 00 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 U Q Q p C N N N M N N N M y ` j O h r r r r o0 00 00 W vi N N N O O O O O O O O O O O O O ^ ^ ^ s s F ° ° aS R a C1 Ci s ° a •` •� 0.1 o Y w V O a ° Y 00 0 v a yPI UCl C Ws ex us �° y a w �° � v 93 as u � A � a ° 2 ; OQ d a ao ra Y Y E " °' o m m y % 9 W 2 y R a s R R o o a o 6 W 0 d V � � a � w ww as z3 uc� wz Q3 cn n a u � c� Act N N N N N N N N N N N N M M M .% O� �O 1� ? r � � •� O O � M O O N O (, v1 !� 1� r r• 00 00 oG ao ^ N a .`N. 7 R T O O O O O O O O O O O O C 110 § � � Iwo � § $ � * � ± ` @ § / f10 ¥ § & \CD \ b § _ 10 r cr, ƒ/ ) u0 / Gq S ° � § 2 � ƒ � j }\ co \ ( \ tt $ \ 2 \ { } w k ) ) u A \ { ƒ 40, - 7 - f d � § i \ k / ) ) ) / Rq t ® B k \ \ ! 3 _ _ Dt / % k 2 # § u = 4 } ]] ] City of Ataseadero Investments by Type September 2009 Cash with Certificates Government Fiscal Agent of Deposit Secu2/oorities I% 25% Other o% § H.I:. T) _ CFiz LAIF 72% Investment September 2009 LAIF $ 25,836,502 Certificates of Deposit 8,902,788 Government Securities 924 181 Cash with Fiscal Agent 79,622 Other 1 $ 35,743,094 Page 9 of 12 1 1 2 City of Atascadero Investments by Maturity September 2009 One Month Within to One Year One Month 8% One to 1% Five Years > \ 19% On Demand '"Nov 72% Investment September 2009 On Demand $ 25,836,502 Withm One Month 97,000 One Month to One Year 3,048,433 One to Five Years 6,681,537 $ 35,663,472 1 1 3 Page 10 of 12 City of A►taseadero Investments by Custodial Agent September 2009 Union Bank 27% Other ` g 0% 5 Bank of New York ]% State of California 72% Custodial Agent September 2009 State of California $ 25,836,502 Other 55,839 Union Bank 9771,131 Bank of New York 79,622 $ 35,743,094 Page 11 of 12 114 City of Ataseadero Investment Yield vs. 2-Year Treasury Yield For the Month Ended September 30, 2009 6.00% 5.00% 4.00% 3.00% 4 i 2.00% 1.00% 0.00% ^ ., -.. n n OJ �J VZ VOO nO� nO0 /l�O n�O e�,oe e�oe `e61 eQti ea Q�e eye �S` PJA Seco 5 O 5e p �eQ City Yield -- +2-Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield September 2007 —4 82% —' 3 74% December 2007 463% 330% March 2008 402% 2.19% June 2008 335% 2.86% September 2008 333% 2.43% December 2008 2.93% 1 41% March 2009 2.44% 139% June 2009 1 91% 146% July 2009 167% 132% August 2009 163% 1 41% September 2009 154% 130% . 115 Page 12 of 12 Attachment 9 1918 . 1979 Atascadero City Council October 2009 Staff Report - City Treasurer October 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for October 2009 REPORT IN BRIEF Cash and Investments Checking $ 623 056 Money Market Accounts 1 Certificates of Deposit 10 000 846 Government Securities 924 181 LAIF 23 337,904 Cash with Fiscal Agents 79,622 Cash in Banks at October 31 2009 $ 34,965,610 Deposits in Transit - Outstanding Checks (527,627) Cash and Investments at October 31, 2009 $ 34,437,983 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 10/07/09 United Community Bank CD $ 150 000 10/09/12 10/07/09 Citibank, NA CD 250,000 10/09/12 10/07/09 Carolina First Bank CD 250,000 10/07/11 10/07/09 Discover Bank CD 150,000 10/09/12 10/07/09 Security Federal Bank CD 250,000 04/09/12 10/30/09 Beach Community Bank CD 245,000 10/30/12 Securities Matured Maturity Date Description Type Original Cost Amount Matured 10/06/09 Heartland Bank &Trust CD $ 97,000 $ 97,000 Page l of 14 116 Investment Activity (continued) Securities Sold/Called Prior to Maturity, Transaction / Original Cost/ Gain / (Loss) Tran Date Description /Type Maturity Sale Price on Call Full Call Warren Bank $ 100,000 $ 100,000 - 10/07/09 Certificate of Deposit 04/29/11 Bank in FDIC Receivership Other Reportable Activities None 117 Page 2 of 14 CITY OF ATASCADERO TREASURER'S REPORT CASH& IN VES TMENTSACTI VITYSUMMARY FOR THE MONTH ENDING OCTOBER 31, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at October 1, 2009 $ 1,372,793 $ 35,663,472 $ 79,622 $ 37,115,887 Receipts 2,058,404 66,460 - 2,124,864 Disbursements (4,275,141) - - (4,275,141) Transfers In 3,572,000 2,105,000 - 5,677,000 Transfers Out (2,105,000) (3,572,000) - (5,677,000) Balance per Banks at October 31, 2009 $ 623,056 $ 34,262,932 $ 79,622 34,965,610 Deposits in Transit - Outstanding Checks (527,627) Adjusted Treasurer's Balance $ 34,437,983 Page 3 of 14 118 0 C) 0 O O o0 D• O r O O o l a n O 0^ n O` O O O O 06 T O � 0 o r a o• p rn In Ln c Om U 0 Cd ° a o O 00 rn a aWG o 0 00CD ° n o 0 •- 0 0, r o. a o^ p rn o p o cr C:) V ►� N O O c 0 o 'ry O o p o a o a c O w. 0 CD o r O E- caN 0 @ 0 pv y p Uvs ¢ o l avi p O a> FQ. 'Z, w 2 ... v Q, v p �., o u is � �• O pl Q p o a> O V O Thi O d C7 V Z W W A o V In O O In o r ca w o V n o Q N w o O r o p 0 o a O e{ N rl O Q W R r`a o u A a c Q Z o 0 4 cs d A >ma � •y nda mom " z d Fo W W > o .C .o v � m3y � xx 3 0 � � cd w � d � C •� � � � � d o O c cn of M O ct O oO O M O C O 7;jN O O Id E•+ Q •� SL 0 C O O O O O 5 O N O� p O O � O O •-+ p d p O 0 O o p CD p p oo p r O O O F- C a, O R S:. W 6 J03 4 F N W �-. k.A R O A O O p 00 al p p p N r O O' 00 O O O O D O OO O O O � p r' o 0 r .a Cl IT In o c viN. a dj N a c p N +r c o o �^ 'n• ' ' v� a r d o o o � p a A N t V a o c p N d: 6 0 o N vi e .n r? a cs o •n r a m � � o p W c n r a v ca d eu F v a R a K W td R R to � a td LIS y conn CD W) p r J t U o 00 O M O 00 O r r O d U o 00 0 00 00 p 0 0 o cM4a � o 00 O oo N r O 'rnr r O C4 '" p co es DA x 03 m F � � F � Cd,? � a=a � Ga U y d• � p v, o O p O o J-) [� CD T E"".., W o ,x. � w '� o •� C H t 3 Pa Q d W U W G ? V� cI as Q 00 c O Q. 00 p am �9) o � 3 a p x o r 0 00 0 cn ao O 0 0 o N o 0 E� A 0 p G 0 0 0 0 O O O r O G Om O O O 00 Q O 00 O r ¢ 0 o v o C O p O O O p G O C. C� G O C? 00 Cr O C O 06 C, o6o6vo G aE 0 0 �. G © pC p 06 W U o 0 o r o cq p o G o rn C'^ p C> O �-- O.- n �i o 0 0_ o 0 p o 0 0 0 0 0 oo 0_ rn O G O O D N O 0 o r rn � 00 rn 00 O 0 W ii1 rn a vti a � M � n N � o o O° a 0 N N N d c O n N W d o o r v N N d o ° R A W c O d d Id woof o 0. w 0. � ca ,. v, o p• ami a� - F' W o a p Q o eoi v tJ~ Q rl o o o d w o °1-01m v w �: v � wMu, ° a � U � •� v � 2 U V n O N N ^G 00 N_ N f O oC O d N O N r W 0o 0 o In o E" C7, '• co G c w U es ccpa � os a ^� N61 u' ai v o dul d 'a W C V y w aC°i a cid Q u� a G; C � C.7 A o tn � v � w o 0 r o o tn O .-+ M M N � O C4 V-1 C4 7+ o o o 0 H A o o r 0 O O 00 p c" O p p O Q O N O O^ O N Q O N N p O O O O C d` A O r a A r a o Z O A Iz 113 q A A 0 0 0 CD o, t- oo O, o o 0 o p o p p o NC-4 O^ O GY, .fppr O O O^ O� N N p O p N O O p O O p 00 cy, O 00 c W o' c � °° 0 o a M o p O r o a o e O In 00 p N q M �fl c O O O a a` N 0 o O O to 113 q W c 'r W O N N A �- A C4 to A w A o Q Cw o v J w v �►• Z W WCD o d ` U ao 0 o 0 ol U 00 o p r o O r Q•, OLn o 'oa r o V Q' oN o O S C q o co cc o x ca a c% Q 0 ca w' U L V.H L G G CD W ✓ c6 U C 4 x cc Ce~ � Tes 1 Vwi °UWA m ~ W E e fA a c a� fi c 4 6 V? o U i � x ez mco 3 � Ga J H � (� `.�• ,., r N N � � a U � �, C O H p � o 0 e M 0 0 0 o c o 0 0 C) 0 o P o O O O O a N O P O CD O O O O P P N N r - N N r o o r rn r rn rn d03LIZ O3 03 m Z, � � Z 0 0 0 P P P OP O O N N N a o a o 0 0 o P a 0 00 C 0 r � N PO p O O O, N o r rn o r rn 0 � o � N CA ° N c O rj o O O N c o O O� rj N o O V W o N o o kr� N N o O O N 0 o O Q N 0 o O kn rj f„ o clt cC > co (Iolo o O � id ca o OIL, q L� ?+ $ v U U o 0 v] E•. U 4+ ool V CT O C N C U O O ol U V o ao o o r o P 4� O O N o p O pl oo O O P C •�.r O O ~O O = OS O y G. o •� E' cV too 4. JA es p ...•, o C e � � aha ¢ � sr�d U �V � �d�. a � .moo y wa+ d �, � o'. � a a ¢ � � � •,. .� `' � was W U y N w > 3 ca Q U U N .N-• d' N r4 r- r, ^ N O N o O `r N ^? o r o 0 O O O G C. O" O O O O" N CD G p O^ O A Ol VI W J m tq 0 Cl O O 2, o0 o p o O o o a o 0 0 W Ln p o o d a o 0 0, o O p O^ O N p O O" OO O r P O .n N o 0 O O, N n d c? 4on c•? N o � v ¢ t'n O N �° o r4. N ec SVS co fl,mo N t" Er rA W IS O � O a` � Q O ✓ � ti. N U o $ U w41 A chi t: In CP v U y o U � r cn vt sr o N o r H N CP ca e � O as W Q sa F c0ol ca o °n ° E r3 ccQ u aU, O '� o i O a E oo = Rcn W O a G fl,P+ en c- C4N d cn U N o N ° O N r rn O O k l Q M d N p p 4 roN~o 0 Q IT @ ] « 4 & � ) / $ 10 f In � § j j \ § § ol \ u� \ / fn G / E ƒ § 0 ^ ^ £\ { \ / 'IT4 — t3 $ \ / o ® 4 # s \ ,ca \ \ \ / � \ § 3 e \ \ W \ ] i ( S » \ z T / \ \ 2 \ k \ \ o g a \ \ / % ƒ � :3 n 7 IC,@ / � ƒ \ 40. o \ ` } / u / 43 ,its / ( 5 , \ 2 \ \\ � § c e ( \ § u \ \ \ 125 City of Atascadero Investments by Type October 2009 Cash with Government Fiscal Agent Certificates Securities 1% of Deposit 2% 29% Other 0% LAIF 68% Investment October 2009 LAIF $ 23,337,904 Certificates of Deposit 10,000,846 Government Securities 924 181 Cash with Fiscal Agent 79,622 Other 1 $ 34,342,554 *ftv- Page 11 of 14 126 City of Atascadero Investments by Maturity October 2009 One Month to One Year One to 11% Five Years --_�_ 21% On Demand l 68% Investment October 2009 On Demand $ 23,337,905 Within One Month _ One Month to One Year 3,636 490 One to Five Years 7,288,537 $ 34,262,932 127 Page 12 of 14 City of Atascadero Investments by Custodial Agent October 2009 Union Bank 31% Bank of New York Other 1% 0% State of California 68% Custodial Agent October 2009 State of California $ 23,337,904 Other 55,897 Union Bank 10,869 131 Bank of New York 79,622 $ 34,342,554 Page 13 of 14 128 City of Ataseadero Investment Yield vs. 2-Year Treasury Yield For the Month Ended October 31, 2009 5.00% 4.50% 4.00% 3.50% r 3.00% 2.50% 2.00% T E ,s _ 1.50% .. ... . .: .�:, . .F 1.00% 0.50% 0.00% O� 00 O� 00 O� O°' O°� O°' O°' & cTLO TLO f f ,LO LO �O LO �O O O pP' acct JOS' pec pec cot JC0 J\� J5t p�c�' �et�' peGeF �` � c,�Q�eF peGe� �a � � POS eQ`eF OG�o 5 --4—City Yield ---w.+2-Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield December 2007 463% 330% March 2008 402% 2.19% June 2008 335% 2.86% September 2008 333% 2.43% December 2008 2.93% 1 41% March 2009 244% 139% June 2009 1 91% 146% July 2009 167% 132% August 2009 163% 1 41% September 2009 154% 130% October 2009 149% 130% 129 Page 14 of 14 Attachment 10 1913 . 1976 Atascadero City Council November 2009 Staff Report - City Treasurer November 2009 Investment Report RECOMMENDATION Council approve the City Treasurer's report for November 2009 REPORT IN BRIEF Cash and Investments Checking $ 415 022 Money Market Accounts 1 Certificates of Deposit 10,880,905 Government Securities 924,181 LAIF 22,447,904 Cash with Fiscal Agents 79 622 Cash in Banks at November 30 2009 $ 34,747,635 Deposits in Transit - Outstanding Checks (246,308) Cash and Investments at November 30 2009 $ 34,501,327 Investment Activity Securities Purchased Purchase Date Description Type Cost Maturity Date 11/03/09 Bridgeview Bank Group CD $ 245,000 11/02/12 11/06/09 Business First Bank CD 245,000 11/06/09 11/12/09 Securant Bank & Trust CD 245,000 11/13/12 11/25/09 American Express Bank CD 245,000 11/26/12 Securities Matured Maturity Date Description Type Original Cost Amount Matured None Page I of 14 130 Investment Activity (continued) Securities Sold/Called Prior to Maturity Transaction / Original Cost/ Gain / (Loss) Tran Date Description /Type Maturity Sale Price on Call Full Call United Commercial Bank $ 100 000 $ 100,000 - 11/06/09 Certificate of Deposit 07/23/10 Bank in FDIC receivership Other Reportable Activities None 131 Page 2 of 14 CITY OF ATASCADERO TREASURER'S REPORT CASH&z INVESTMENTS A CTIVITY SUMMAR Y FOR THE MONTH ENDING NOVEMBER 30, 2009 CHECKING FISCAL ACCOUNT INVESTMENTS AGENT TOTALS Balance per Banks at November 1, 2009 $ 623,056 $ 34,262,932 $ 79,622 $ 34,965,610 Receipts 1,771,783 59 - 1,771,842 Disbursements (1,989,817) - - (1,989,817) Transfers In 1,780,000 1,770,000 - 3,550,000 Transfers Out (1,770,000) (1,780,000) - (3,550,000) Balance per Banks at November 30, 2009 $ 415,022 $ 34,252,991 $ 79,622 34,747,635 Deposits in Transit - `' we' Outstanding Checks (246,308) Adjusted Treasurer's Balance $ 34,501,327 Page 3 of 14 132 c o c d C, o0 0 00 0 0 ( n or- 00 00 OO o6 T p p i rn 0 0 o A O U N A Z Q A Efl L A O O O O„ Z 0 �- e p o o OO 0 p o r rn U N o O N V e N a V4 0 O N, a e p O c O a t O O a A 03 VI A 'N O W a W A Z a c°i p n W rG v p ,� p N c0 n"i U tai U U v C4 H m u w f c`o G p O O O Ul W A r O OVto j A i^1 = q °' d C A p s .a is d F C Col p F 'u o eta at Cal r y o u CVi d? P� CaJ y 7 7 Z W �► O y 0% O H `° -t t p w d ``d ci u F^ W a v� y 0 J C W v o K u w a .5 v y C in d x o d a ` W 14, d v �c {s, x v O o N 00 C o Cld v ov m 3 � o oIn N o a , p o o �. o o cn o � w P CD O p O O- CD O O G C d Ol CD G O, O N O O O O a N O O O C O C G G O O C_ O O 00 O C v G O O` 4- o a, G zrn Lt W O ° to) O ° Ln 113 ° o c G o 0 D o 0 0 000 Q o 0 o O W U 0 0 rn rn C:) C p P O O O p O O p O P O O O � O O O 00 O r O r O C O O Q W W f e Q c f N � d vq v, r! ¢ o O N d O d o O NrA n c M c °`roi O Q o 0o N W a v d o 0 o N d y+ o0 o N a d c O N n -er W 4r o N, a A n Iz Cl. o w U �= rd) o °o Q A o E" Mw 0.1 o NO p v v w O y 'z, v �' Y •� o a v A v' o � � ? r 'N O RN �•` Ay. O N td � � � N N O J o p a o U o U v {� J L:+ •� y U oo � O O O U U U r o oc o 0 0 U o0 0 00 0 0`0 n O fn O oo O 0o O �+'� O oo O 00 O p N oo O O (� O @og C GQ t ,4 U r C d� R Kn Is ca 44 2 is ° d os 44 vs C5 cr 0. a d ani �• W '� x 'd c N `° a, A c d w� V ) � � du x z G N A N m m > > m 10 W W rn o rn oo x `" o 4 oo o 0 o C 'o 0 0o O O " M oo O �. o o o 0 r o Qp o 0 ti O O O O O O O p O t'•, O p r / r Cl O O a`' 1 O M O O 0d O� 0 .0 �. F. 03 c cti �-. CAa w td `G d O Z � O O P � O O r ►• O O O � O � Q` W ch O a O r rn x O P O P a n, GCS- p o o r.. o O P C„ O O p O O O O C) O O p, O O a O 06 O N O O oo of O r a, W 0 o O ►7 o vi O o 0 0 a N 0000 n N 0 o O v M d e o O o4In d \ O N N ti O •- d d � 'n N N A W o �, ,.,, d Ey �, •; -eC d � 63co ca W Fr � Q rF'• p` Z, A Q p Q rD (� � .0 2, v N � fl• N p Q � N � y Q o r p o 0 N ?Q" v cdo v w o U U rn o 0 Y U U r o w o r o a .r, o O N ^ N i O C O 00 O N N 00 p Cy W oo O aIn O 0 U � a rL A r' m C d g ee tj pG w de °o 0. W Pa 4'" �+' •a � � � o f � � �y `� CG � O � Lai � w� �' ,o} �, U c A `n -25 m o oo r o 0 O In N O r+ � O � p o G O O o q c cCp ° Cl CDr ° O � O CTS O O O G O O � N O O OC r O o � O d q � O ^ W � m 4. A A p j tz c R Z Z O do q r rn q o o rn W V d o N cei xN D rl d c:> p d N OO- O CD p O cA O 00 T q r p r O ^ o r O c O W Q oo ^ W a o p a o O o a o � o O O N oo a T N rW.. N o � N o O M N o c ov-i O ~G o A W c p N a 13 CG N � v3 C P� 4-. o 03cy, 03 ozi N � � a � q � •� o � p w. o a� Z d > oo q O 401 o oc O h o v, •a � Q p o � R o +�. � a� U N ^ D` U o0 o r- 04 O O z. =- O O [ t- c� - c::> W rn o .o N ^ o W p N ^ O J d b0 ¢+ It 06 Pa ca cid p U0 s t a+ es4Qj '�s w U oo N r [- A o 0 0 0 0 0 o �- o oo �^ o p O O N O � O O p N ctl vy o. o CD ol O o N N W U ao 0 0 CD O O p of N � c O o .n Cy j c N N c c O .p ri N M M N o N o0 0 a N N W O N a a N N r M c p N c O O N Nrn a a N O [-. m m $ d w O w v ca v� F- In o � �' p oN� Q 0 -4 obo U� C " o � z pol 2 10W c-I o a U o Y N r0 U oo -T oo O O d 10 Q H oas A o O p. 0 � � o d H d o �. �. , � V d �j m •- ,s o a oa o v oe U o G .0o fs a) O ea d N N Ca N, i N p C O a o o W tib 3 rn c`- o N 4 N O O N "I O `n O N O rl Q O 7- r C � o F• Q •- 4, C) G O O C O � O O p O O C O Q N p G C N p O O N RS In 113 G C O Z to rn N N O � m vca m co G O O O N O O O O O O O O CD o- re O O O N N N N O Or O r o d b O r c O O C-4c W) C Irl Q o 1 n a W °• o •o cT o c t In N 0 o N N C4 c v I Q a ° O N C1 N N o 4 n cn N vN " @ o d NA m _a q W o N C N Cd Q H otd -,a o R Z r G Q W p o Z `a c w Q o m MIS' E" �- ►. •v, O ami p 4' O °'' U �' •L' 4t1 2 E cai Rw o °� c�ai ,r, C> ei U o p M �..� O y U W •.� N U 00p � N rN, cr, Z U ocn U o o r r o rp o 'IV N p q p l G Cfl C6. U. o O J r � c Er '' H � p � •*Gea CA �. U d O •�} °� 4� a W 7 p a' w Y) `' tea.� � � � � �� a a o v U � .� •� G o u � � 3 d rn cC .p N q 3 ty W N w A t7 N C N a O f p O G O O O O N N h O O O O O N N Z O O O U �o lD `^? w O O O G M ro ca O W M M v O 00 U ovo 0o N E•-' 211, th ti w ae � a ti U U O O O O O N N N O O O O `D N N 00 O O O O O O O M O, M VO O O O N M M E L'I Y ,X ti 69 69 ws y b > O y O '% C) v v U o Lv a v v v v o .oma, G' ai .c b .per' U Y T CY td Oi T} vaz o a d o t�. o 0 0 0 U ►. � v a� a� a� 4 0 0 o o o ai j U U U U U o=. w U V U U [- y > � o0 00 00 00 � � � • W o 0 0 0 � p •� LO D C Q o 0 0 0 o w • U O y � O > o0 o O U EZUU � W Q e Q e v y ro O cc y UC7 U 4 dA 45 asx o w 7 .a Q O O O O > d m 139 City of Ataseadero Investments by 'Type November 2009 Cash with Government Fiscal Agent Securities 1% Certificates 3% of Deposit Other 31% 0% LAIF 65% Investment November 2009 LAIF $ 22,447,904 Certificates of Deposit 10,880,905 Government Securities 924,181 Cash with Fiscal Agent 79,622 Other 1 $ 34,332,613 Page 11 of 14 140 City of Atascadero Investments by Maturity November 2009 One Month One to Within to One Year Five Years One Month 10% 24% 1% >� \v On Demand 65% Investment November 2009 On Demand $ 22,447,905 Within One Month 200 000 One Month to One Year 3,336,549 One to Five Years 8,268,537 $ 34,252,991 141 Page 12 of 14 City of Ataseadero Investments by Custodial Agent November 2009 Union Bank 34% Bank of New York 1% Other 0% State of California 65% Custodial Agent November 2009 State of California $ 22,447,904 Other 55,956 Union Bank 11,749,131 Bank of New York 79,622 $ 34,332,613 Page 13 of 14 142 City of Ataseadero Investment Yield vs. 2-Year Treasury Yield For the Quarter Ended September 30, 2009 5.00% 4.50% 4.00% 3.50% 3.00% r 2.50% A 2.00% 1.50% t ' 1.00% 4 0.50% 0.00% c�op1 ti��b .oe ac�r Joe ,oec ,oec c�`o Jae pec pec Oe �eQ Oe 5eQ �o� -City Yield --r---2-Yr Treasury Weighted Portfolio Yield 2-Yr Treasury Weighted Portfolio City Yield Yield December 2007 463% 330% March 2008 402% 2.19% June 2008 335% 2.86% September 2008 333% 2.43% December 2008 293% 1 41% March 2009 2.44% 139% June 2009 1 91% 146% September 2009 154% 130% November 2009 146% 1 19% 143 Page 14 of 14