The URL can be used to link to this page

Home My WebLink AboutAgenda Report - February 5, 2003 E-03CzTY OF LoDl AGE NDATITLE, Accept the Quarterly Investment Account report as required by law 5564 MEETINW-v D; TE- February 5, 2003 PREPARED BY: Deputy Treasurer RECOMME,NDFD ACTION: That the City Council by motion/action accept the quarterly report of the City of Lodi pooled money investment account as required by SJ3564. i BACKGROUND fNFORMATIts The investment report is currently included in the monthly executive report distributed to Council. 5 56 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. In addition to the quarterly report on investments in the City of Lodi pooled money investment account, a breakdown Treasury Inventory by type has been included in a chart for t. Also included is the most current report of the Local Agency Summary of Investment Data and the State of California pooled money investment account market valuation. The City of Lodi maintains membership in the California Municipal Treasurers Association an .contour to guide lines set forth by the C.MTA investment report cone-nittee. The Finance Department will continue to include the investment report monthly as part of the executive report. FUNDING: None. OMEEM VickyM�PcA hie Finance Director/Treasurer 100M3W= VEW TV MOVE POWSunmwry December 31, 2002 Rur, iiaie. 01)20!2003 - 1413 city ofs' 212 W, Pone St Lcd, CA 95240 (209) 00 YTM 368 E €quN, £laf Market Book of 1.843 Dns to l v Value Vain Value Portfogo Tem Locai Aoamy Investment.Funds 7,x,732:42 � 7,368,732.42 � 7,366,732.42 32.177 1 ? ceitfmates of Deposit - Barak 9.19 2133 13� Past ecldng Awmints 4,4 .634:79 4i4BS,634.79 4,465,634;79 31:56 1 9 CqpofateMedium Term Note9,42{�,i�1Q.UQ 1;t�3fi;931.50 1,015,240.91 7.18 T1,03� 139 Investments � 14,162,3-6-7 14,16%2,78.81 .............. 14,1470A2 1:Q . ..... 96 23 T m - . ..:2... ...- December 31 Month EndingMaar --- --- ... To ........ --- _---------- CwW9 Y r 22,47e.22 160,933-69 Averap NRylance 12,141,034180 14,495,316.01 Effective Rate of Ratum Z18% 2. . la Rur, iiaie. 01)20!2003 - 1413 city ofs' 212 W, Pone St Lcd, CA 95240 (209) 00 YTM 368 E €quN, YT 366-EqUIV, 2-594 2.430 1.315 1.843 O:E O O.Qw 7,151 1.250 2"1 2;059 Patfolio CrTy A PRA (Pi�F_r"'hA4) sympew_ V6,01f PortfolioCity of Lodi Management 2= - Ave!, -age Purchase ed Y7M Dayzto Maturfty LUMP 4atvem eett # 1"Uer hal*me Date Par Value Market VaNe ftokWue Rate WmdYs M maturity Data Dace#'Agency Inveshnent Funds LAP Iwo L 4Agency.lnvest. Fund 5,12 ,01:3'.32 5,12 ,ii33.32 5,126003.;32 2. 2.5 4 1 L*— IWI L=al AqwnoyimRind;t, j 2,24o.ji .14 224D,719,10 2,240,719.10 2.M 2,594 1 Subtotal and Average 7,3M,732A2 7„$K732,42 7, . ,7 2 _ 7, .. 2 z5% 1 CerMcates of Depot - Bank WEST 52 5ank of the West 0*17 100,000.00 100,0 .00 100,0MM 2.220 2.220 1CG D4/1712003 57 Bank of Amen 12/1712002 1 t ; 100;0:05 100, .1 1. 3 1. $60 12117=3F -W 19a rarrtaom&marchanu IW23t2 2 1,i AMOO 1,QiY, 1,i :41P7 1. (7 I.Wo 115 NaV2003 LOOJ 55 Bank of Lodi IDIO 2 10DOD.00 » _ 100,0W.W ._ --1 lbopw,00 -- 2,0$0 2.4 ! 9D G410112003 Subtotal andAvera€ge 1,248, 'i.10 1,3wQW.00 .0Q 1,300,waoo BACK 403 Bank of Aniar¢ca 07101121 2 217,W9.01 217,839;01 217,539:01 Oma 1 4000 Farmers & Membants 4,247;795.78 4,247,79 .78 4,243,795..78 4.000 1 Subtatai and Average 2,611,15ue 4,4 VS 4,06, :79 4, � 0 � � 1 36962GSY1 35 i^ wi is capW in 0612712i SuWoW and Average 1,014,756,99 Total investments aria Avera Rtm Date 044., ai20D3 -14:13 SAW AAA 7.151 935 0511912003 1,036;931:69 1,015,mql 7.351 138 14$ Po tfefl s CITY AC PM (PRF_PMi2) SymRspt V5.01s City of Lodi PqrVollo .... December 31, f ve age Purchase Stated YTM Day to OUSIP investmwft 0 issuer Salance Date Par value Market Value Sook Value a May's Sw Matwity Total Cash and Ime-stments IZI4IvM4AO 14,IS2,367,21 14,3 ;27$:8`+ °#4,147, .12 2.031 23 Run €wa: 01F2W2043 - 14:13 Fodf fio OfTY AC RM fpRF_f'M2) ^SYMRept v5vf Genificates of Deposit - Bank BA 57 Bank Df Amerjga OM subtotal PasabooMbecking Accounts (Monthly Sumwy) BACK 4w3 SaAR of Ampdra 4WD Farmem & Merthentr. Sublotal MMMMMBE�� a R : QIMP2903 - 14.13 1,300 12)1712002 ............ ------------------ OM 1,3wQW,00 398,79819 11,517,157.78 15,67'1 .. . . . ........ 4, .79 .. - 1,015,240,91 9,861,M87 14,147jWS.12 Poftfalio CITY AC PM �PRF_PW) SYMRept VIE'rOlf City of Lodi PortfolloManagement 1"YeAtuto* A;*4:.SuMMAFY Deoember 2001 through0ecember 2002 w= PMffGHO CITY AC Run Date', 0112aDG3 - 14,33 PM (PRF _PWS SymRept V5.011 ywd to Mwuft Managed Number NumberWnth Number of TE" Pool ;)f Secuftes of set.UTAWS Average Average End Year Semmifies antedEquivaiew Equwaterd Rata Ph-ased urc Mat ur . ed I Soid Term Days to ftaturfty 2001 12 17ica.1,531.0D 3693 3144 3.755 0 0 197 102 2002 12 21,305,358.93 3.171 3,215 3,070 1 1 1-% 75 Februwy M2 1.2 21.,321,23139 3.OW 3-078 3D70 .0 0 156 68 2902 11 17,216,235.35 3,071 3.114 2,99D 0 1 153 76 April 2002 10 23,765,4613.5 ZM 2.M 2.W1 2 3 103 54 may 2002 10 19,6M,834.44 2,655 2.691 2.861 1 1 124 69 June 2M 10 16,9M,65Gn 2-769 2.807 2-760 0 0 144 74 July 2002 8 15,114,28.20 2. 37 Z440 2.750 1 1 87 26 August 2002 a 17,709,502,46 2,054 z 1750 0 0 74 20 September 20,02 8 12,183,102,24 2AM 2.464 2.750 0 0 IM 24 October 2002 8 14, 7,W5.5.2 i'M 1:994 2,630 2 2 91 29 November 2002 8 1.2,0 ,947.82 2377 2.410 2,WD 0 0 109 29 Decealber 202 9 14,147, .12 2.031 2,059 2,6M 1 0 96 23 Average 19 17j47,731A4 2,6140% 2.661% 2.897 1 1 123 52 PMffGHO CITY AC Run Date', 0112aDG3 - 14,33 PM (PRF _PWS SymRept V5.011 City of Lodi Portfoli.. ,. Distribution. qflpvpiOrpo� By Type December 2001 through December 2=5 Run Dvte: 01;2=003-14:1 a AC PM (PRF-PM5) SymRopt W5.01f December januafy re*$dTuawy mach wt May Ame jwy A&Qust Septembev Wer Noverniw DeceMA7rew Mwagre Invesixmw Type 2M 20M 2W2 2002 2= 20M 2= 2W2 20M 2M 2= 2DW 2= by perwd Local cy: ve tFunds 57.4 63.9 59.5 66.1 58.8 67.0 692 _ . 54.8 3 9 50,7 _. 613 52.1 __.._ ._ 83.5% -- -_-- _._ -_ ........____.__.. #' �. _._ 133 _ 16 1o.;3 .. 13.4 5.5 ..___ - 6.6 7.7 -- 7;9 6.6 9 8.3 100 9:2 _ 93 Certfficates of it ..S & L - s 11,5 13.2 15.7 8:9 27.3 .1 ax ; 11.2 205 $22 21.9 341 20.3 31 6 .. _ 20.2% _ _ - .---_ __ Corpqrafti -- -------. 5.9 .-_ _ _ . . - ------------------------------ 4.7 -_---_,_ --- - - ---- 4.7 - 5.6 - _... 4.2 S.1 ..6.G? 6.7 X5.7 _,_..--____-- .3 -� --------------------------- -- 7.0 ----- 8,4 -.._.--- . 7.2 61% .------- Commercial Paper - Interest _ _ __..-- --_- ___ ____-__._._-___- ---- cc > , - ------------------ ___11.7 11.7 9.4 9.4 5.8 4.2 5.1 -_, .9 Run Dvte: 01;2=003-14:1 a AC PM (PRF-PM5) SymRopt W5.01f Earnings during Period Pass Through Securffiev. rote Go5ected Pius Accrued Interest at End of Period Less Accrued Interest at Beginning of Perk>d Less Accrued Interest at Purchase musing Period Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capitai Gains or Losses 0.00 Q00 0.00) 0.00) I 0,00 0.00 0,00) -0.00) I Earnings, during PeTiod OM OM CastdChacklng Accounts. Portfolio Management Interest.Earnings Summary December 31, 2002 42,762.53 42,762.53 Dw"nbff 31 Month.EadhV Fiscal Year To to C=ouponascaunt invesumnts: Interest Earned dwiW.Pedod .. . . ...... .. . .. . . 14,469.18 Interest Codi fed 555,78 68,401.22 Rus.Accrusd interest. at End of Period 21,119W 21,119.G3 Less Accrued interest at Begin" of Period 14,7;34.26) 44, ,29) Less Accrued Interestat Purchase During Pe6od 0,00) 22,47922 Interest Earned during Period 61972.45 45.,161 86 Adjusted by Premiums and Discounts 1,034,59 6,2D7.62 Adjusted by Capitai Gains or Losses Om O. Earnings during Period Pass Through Securffiev. rote Go5ected Pius Accrued Interest at End of Period Less Accrued Interest at Beginning of Perk>d Less Accrued Interest at Purchase musing Period Interest Earned during Period Adjusted by Premiums and Discounts Adjusted by Capitai Gains or Losses 0.00 Q00 0.00) 0.00) I 0,00 0.00 0,00) -0.00) I Earnings, during PeTiod OM OM CastdChacklng Accounts. Interest Collected Plus Accrued Interest at End of Period 42,762.53 42,762.53 Less Accrued Interest at Beginning ofFeriod 28,293:35) 99,=,64) Interest Earned dwiW.Pedod .. . . ...... .. . .. . . 14,469.18 109,564,31 Total Werast Earned during Period 21,4441.63 164,'726,17 Total Adjustments from Premiums and Discounts 1,034.50 6,207m ToW Cap iW Gains iw Losses 0 . .00 046 Total Earnings duringftrlod 22,47922 ,933.69 Run Dow OIJ2MV05 - 14:13 PGrtfboo VTY AC PM (PRF PW) SyrnRW, V5.0" BY TYPE December 31, 2002 Amount Percent of Portfolio $7,366,732A2 52.063005OXt $1,3.00�000.00 9;1:85742% $4,465,634.79 31.5..53978% $1,020,000.00 7.207275"/o 0.0=00% /® T1-4,152,367-21100,00% $1,020,000.00 Federal AWcy Issues - Cowat-a Me&hm Term Coupon Note GIA, Treasury Securft coupon, 0% $4,465,634.79 PassbooklCherckmg Accounts 32% e � Ceftfflcates of Dt - Q $7,M,732,42 Local Agency Investment Fug 69% ,o. .at AQency fnves#nent Fund $7,366,732A2 SCeftcatee of QeperA -.Bank $1,300l .00 ow 8 Passbook/Chercking Accounts $4,465,634-79 ZCowzte Medium TermNot . e $1 i=,OW.00 UTreasury Sec aril - Coupon ClFedera# Agency imeS - Coupon PHILIP ANC SLID TREASURER STATE OF CALIFORNIA INVESTMENT DIVISION SELECTED INVESTMENT DATA ANALYSIS OF THE POOLED MONEY INVESTMENT ACCOUNT PORTFOLIO (000 OMITTED) ixELREAECERM Government Bills onds Nates Strips Total Governments Federal Agency Coupons Certificate of Deposits Beak Nates Bankers' Acceptances Repurchases Federal Agency Discount Nates Tirne Deposits G NMI As Commerical Paper FHLNIC Corporate Bonds Pooled Moans GF Loans Reversed Repurchases Total (All Types) September 30, 2002 PERCENTAGE CHA G E R M AMOUNT PERCENT PRIOR MON` `I -I 991,399 2.22 -0.12 0 0 0 5,923,896 1.3,25 +0.29 0 0 0 6,915,295 15.47 +0.17 4,877,776 1.0.91 +0.35 4,870,056 10.90 +039 865,088 .1.94 -1.21 0 0 0 0 0 0 3,459,672 7.74 -1.96 5,094,290 11.40 +0A8 728 0 0 10,455,514 23.40 +3.03 6,655 0.01 0 2,384,630 5.34 -0,01 3,004,937 6.72 +0.75 2,858,500 6.40 -2.39 ____(105267-5) (0.23) 0 44,687,516 100.00 Average life of Portfolio as .of September 30, 2002 is 188 Days 5 Revised Septembor 30, 2002 State of California Pooled Money Investment Account Market Valuation 9/30/0.2 em —gM— 7 -0, 7777M N-5 'Mu r 6 are's Bills Notes Federal Aciencv: $ $ ---------- 991,399,138,04 $ 996,134.,444.06 5,923,896,093.11 $ 5,919,553,545-83 $ $ 996,560,000.00 6,039,332,500.00 $ NA 61,281,826,50 SBA r $ 312,691,268,99 $ 312,634,357,04 $ 312,139,714.96 $ 1,173,281,58 MBS Bonds $ $ 559,693,310,49 $ 559,693,310,49 4,005,391,754.99 $ 4,003,177,692.48 $ $ 566,237,836.10 4,077;694,737.50 $ $ 2,848,4133,44 53,624,640.79 Floaters Disownt Notes FHLMC PC C NMA $ $ $ $ $ 3,459,672,442,73 $ 3,477,135,427,42 6,.654,726,10 $ 6,654,726,10 728.43932 $ 728,439,82 $ $ $ $ - 3,479,143,531.60 7,280,327.53 857,497.20 $ $ $ NA 106,988.70 7,227,27 Bai i kem; Aoc $ $ $ NA Bank Notes CDs $ $ 865,088,464.26 $ 864,985,890.65L 4,870,054,820-26 $ 4,870,054:820.26 $ 865,063,425.35 4,870,249:794.90 $ $ 3,933,247,23 21,544,219.40 ColllmarSIILEa, '10,455,514,095,90 $ '10,481,377,565.41 $ 10A82599,117,94 NA Floaters $ 445,63975238 $ 445,639,752.78 $ 439,338,258,34 $ 1,029,920.18 Bonds $ 1,938,989,410.81 $ 1,936,422,476.53 $ 1,962,123,561,31 $ 33,894,119.48 $ $ $ NA ReverseEc�rchase $ 105,625,0000 $ j125,625,000,00j_j 105,625,000.00) $ 0,989.58) 5,094,290,000.00 $ 5,094,290,000.00 $ 5,094,290,0001.00 NA AB 55 & GF Loans $ 5,863,437,09022 $ 5,863,437,090-22 $ 5,863,437,090,22 NA E OTAL mm 53 44.687. 1-808 726,294,539.09 $ 444,950),822,392.95� —178,6��4296�499 Fair Value Including Accrued Interest $ 45,129,465;357.94 Repurchase Agreements, Time Deposits, AB 55 & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). The vaWe of each participating dollar equals the fair vakie divided by the amortized cost (1.005020041). As an example. if an agency has an account balance of $20,000,000,00, then the agency would report its participation in the LAIF valued at $20,100,400.83 or $20,000,000.00 x 1.005020041, 1.2 Revised September 30, 2002 .. .. .. .......... . .. .... .