Loading...
HomeMy WebLinkAboutAgenda Report - January 19, 2005 (43)AGENDA ITEM E-13 CITY OF LODI COUNCIL COMMUNICATION ,m AGENDA TITLE: Accept the Quarterly Investment Account report as required by law SB 564 MEETING DATE: January 19, 2005 PREPARED BY: Finance Director/Treasurer RECOMMENDED ACTION: That the City Council by motion/action accept the quarterly report of the City of Lodi pooled money investment account as required by SB 564. BACKGROUND INFORMATION: SB 564 required local agency treasurers to submit a report on investments at a public meeting. The City of Lodi has an investment policy, which is submitted to council for approval on an annual basis. Copies of the policy are available in the Finance Department. City of Lodi maintains membership in the California Municipal Treasurers Association and conforms to guide lines set forth by the CMTA investment report committee. FUNDING: None Prepared by Maxine Cadwallader, Revenue Manager JK/mmc Attachment APPROVED: James Krueger Finance Director/Treasurer Janet Keeter, Interim City Manager City of Loi 212 W. Pine St. 40 Portfolio Management Loch, A M (209)3ss Portfolio Summary December 31, 2004 Marcella Maxine Cadwallader, revenue Manager Run Dais: 01/0512005 • 10:11 Portfolio CITY AC PM (PRF -PMI) Syn -Rapt V6.21 Rsport Vsr. 5..00 Par Market Book % of flays to 7TM YTM investments Valve Value Valise Portfolio Term maturl 360 Equiv. 365 Equiv. L=t Agency 1nveStment Funds 23,763,073.13 23,763,07313 23.763,073,13 77.16 1 1 1.953 1.980 cefli tcates of Deposit - Sank 200,000.00 200,000100 200,000.00 0.65 366 229 1.770 1.795 PassbookfCheeking Acmunts .6,826,999-27 6,826,999.27 6.826,999.27 22.17 1 1 O'Ow 0.000 Investments � 30,°790 072.40 10€9.00% � 3 2 lZ19 1.540 30,790,072 40 30,790,072.40 Total F-arnings December 31 Month Ending _. Fiscal Year To Date Current Year 30,094.40 147,917,00 Average Dally Balance 24,773,323,36 24,928,886,42 Effective Rate of Return 1.43% 1.19% Based on the approved budget and to the extent the budget is adhered to, 11quidity 1s available for the next Six months. Union Bank of California is the Source of market valuation. Marcella Maxine Cadwallader, revenue Manager Run Dais: 01/0512005 • 10:11 Portfolio CITY AC PM (PRF -PMI) Syn -Rapt V6.21 Rsport Vsr. 5..00 City of Lodi Portfolio Management Page 2 Portfolio Details - Investments December 31, 2004 Average purchase Stated YTM Days to Matwity CUSIP Investment 41 issuer Balance Date Per Value Market Value Beak Value Rate Moody's 36.0 Maturity Bate Local Agency ]"Vestment Funds Farmers & Mefchants 6,624,242,03 6,624,242,03 6,624,242-03 0.000 1 LA1F 1000 Local Agency invest. Fund 23,ii60,490K3;t14 23,060,£;00.00 23,06G1;OCO[ 00 1.980 1.953 1 LPI[ I D04 Local Agency Inv Fuad (1 -PIC) 703,673.13 703;073.13 703,073,13 1.980; 1.953 1 Subtotal and Average 18,151,861.77 23,763,073.13 23,753,073.13 23,'763,4173.13 .30,790,072.40 4.963 i Certificates of Deposit- Bank SYS72fitEST 72 Sank o3 the Wesl 04/1712404 144,€300.00 1(10,4013.0(9 144;13114 oo 1.03€1 1.090 106 W17rZ%5 SYS75 75 Barak of America 12/17/2404 1£9[},044:00 100,t>£34.{r0 100.,OW.00 2.4503 2.450 352 12119=5 Subtotal and Average 200,000.030 2131},0{30.00 200, 00 � 2WID I0.0 1.770 229 PassbookXhack#ng Accounts BAr,K 40t3 Bank of America 41(0112404 171,695.62 171,695.62 171,695.52 4. 1 SYS4000 4000 Farmers & Mefchants 6,624,242,03 6,624,242,03 6,624,242-03 0.000 1 F & M PAYROLL 74 Farmers & Merchants Payroil 113101/2044 31,061_£2 31,061.62 � 31,061.62 4.0110 1 Subtotal and Average 8,421,461.59 6,626,393.27 5,826,999.27 5,826,993.27 0,wo 1 Total and Average 24,773,323.35 30,790,072.40 30,790,072.40 .30,790,072.40 1.519 2 Run Dais: 01/05/2035 - 10:11 Portfollo CITY AC PM (PflF_PM2) Syn -Rept V6.21 R&POn Ver. 5.00 City of Lodi Portfolio Management Page Activity BY Type December 1, 2004 through December 31, 2004 Stated Transaction Purchases Redemptions CUSip investment issuer Rede Date or Deposits or Withdrawals Balance Loom Agency Investment Funds (M0 th1Y Summary) iAiF low Local Agency Invest. Fund 1.98ti 9,�,t36f1.00 3,002,017.22 Subtotal 9,OOi%,0(i0.:00 3,(*2,017.22 23,763,073.13 Certificates of Deposit - Barak SYS88BA 68 Bank of America 1.050 12.11712004 0,00 100,W0.00 SYS75 75 Bank € f America 2450 12MV20134 � T 101),OWW Subtotal 10p,Ota0.0(9 100,OOU.QO 200,0M00 passtsaokfChecking Accoonts (Monthly Summary) BACK 4003 Bank of Ame6ca 0.00 314.91 SYS4000 4000 Farmers $ Memhants 22,806.667.57 22,386,214,46 F & M PAYROLL 74 Farmers & Mer ants PWoll 301,76196 302,$46.56 Subtotal 23,108,431.53 22,689,375.33 6,826,999.27 Total 32,208,431.53 25,791,393.15 30,790,072,40 Run Oate'. 0110512005 • 14:11 Poftlfo CITY IAC PAA (PRF_PM3) SynASPI Y5.21 Raport Ver, 5M city of .,; Portfolio Management Activity Average 8 24,398,OiF1.$9 1.148% 1.164% 1.820 1 1 109 6 Portfolio CITY AC Run ©ate: 01/05/2005 - t 0:# t PM (.PRF PM4) Syn -AO t X16.21 svport ve;- 5,00 - ywd to fe mursty _ Managed Slumber Number month Numi elrof Tota! 360 365 pori of Investments of Investments Average Average End Year 6eeaaratles Invested EgWvate it Etgestvsiesd hate I'umhased Redeemed Teresa Days to maturfty December 2003 8 18,486,744.43 1.188 1.205 1.630 1 1 16 10 January 2004 8 24,505,234.71 1.12t 1.141 1.530 0 0 12 6 February 2004 8 25,233,845.42 1.1193 1.108 1.530 0 0 12 4 March 2004 8 24,182,795.48 1.141 1.156 1.530 1 1 12 4 April 2€104 8 22,736,185.55 1.211 1.227 1.530 2 2 13 12 May 2004 8 24,749,985.76 1:077 1.092 1.474 0 0 12 9 June 2004 a 24,704,427.13 1-062 1,077 1.450 0 0 12 8 July 2004 8 22,523,593.60 0.992 1.005 1.4501 1 0 13 6 August 2004 8 26,584,137.20 0.841 €1.852 1,450 0 0 11 4 September 2004 7 23,07$,628.54 1.108 1.123 1-580 0 1 12 3 October 2004 7 25,225,379.317 1.373 3.190 1.890 1 1 4 2 November 2404 7 24,373,034.02 1.396 1.416 1.93fl 0 0 4 2 December 2004 7 30,794,.072.40 1.519 1.540 1.980 1 1 3 2 Average 8 24,398,OiF1.$9 1.148% 1.164% 1.820 1 1 109 6 Portfolio CITY AC Run ©ate: 01/05/2005 - t 0:# t PM (.PRF PM4) Syn -AO t X16.21 svport ve;- 5,00 City of s: Portfolio Management Distribution of Investments By Type fgrx f! t- r F Page 6 Run pate: 01105!2(905 - 1#3:1 i .Portfolio CITY AC AAA {PRF„PM5) SrrAept V529 Report Ver. 5.00 December January February March April May Jane July AuguW September Gctober November December A -rage Security Type 2003 2004 2004 2004 204 2OG4 2004 2004 2004 2004 2004 2004 2004 by Period Local Agency Investment Funds 69.2 707.8 68.8 77.8 76.4 70.4 74.5 65.3 55.3 63,7 62.5 72.9 77.2 6a.895 Certificates of Deposit - Bank 7.0 5.3 5.2 5.4 5.7 5.3 5.3 5.8 4.9 5.2 0.8 0.8 0,7 4A% Certificates .of Deposit - S & L Passbook/Checking Accounts 23.7 23.9 26.7 22.8 17.9 24.4 24.2 29.0 39.8 31.1 36.7 26.3 22.2 26.5°/9 Corporate Medium Terra dote Commercial Paper - Interest Bearing Repurchase Agreements Federal Agency Issues - Coupon Treasury :Securities - Coupon Mortgage Backed Securities BarikersAcceptarices -Amortizing Commercial Paper Disc. -Amortizing Federal Agency Disc. -Amort€zirng Treasury Discounts -Amortizing Miscellaneous Discounts -Amortizing Run pate: 01105!2(905 - 1#3:1 i .Portfolio CITY AC AAA {PRF„PM5) SrrAept V529 Report Ver. 5.00 Portfolio Management Page Interest Earnings Summary interest Coiiected December 31, 2004 0.00 December 31 Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Less Accrued Interest at Beginning of Period interest Collected 242.61 6,342.02 Plus Accrued interest at End of Period 49.75 49.75 Less Accrued interest at Beginning of Period ( 49.75) ( 1,976.83) Less Accrued Interest at Purchase During Period ( 0.00} { 0.00) interest Earned during Period 242.61 4,414.94 Adjusted by Premiums and Discounts 0.00 0.000 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 242.61 4,434.34 Pass Through Securities: interest Coiiected 0.00 0.00 Plays Accrued Interest at End .of Period 1l. DO 0.00 Less Accrued Interest at Beginning of Period { 0.00) { 0,00) Less Accrued interest at Purchase During Period { 0.00) 4 0.00) Interest Earned during Period 0.00 f1.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.09 0.00 Earnings during Periods � 0.00 0,00 - CaWChecking Accounts: Interest Collected 0.00 127,400.27 Plus Accrued Interest at End of Period 83,570.52 83,670,52 Less Accrued Interest at Beginning of Period { 53,818.73) { 67,568.73) interest Earned during Period 29,851.79 f 43,502.06 Total interest Earned during Period 30,094.40 147,917.410 Total Adjustments from Premiums and Discounts 0.€31) 13.®0 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 30,094,4€1 147,917.00 Run Dass. 0;1£35!2005 - 10'.11 Portfolio CITY AC PM (PAF_PM6) SymR&pi V6.21 Repon ver. 5.003