The URL can be used to link to this page

Home My WebLink AboutAgenda Report - August 20, 2003 E-03AGENDA TITLE: .Accept the Quarterly Investment Account report as required by law S 564 MEETING DATE- August 20, 2403 I EP D Deputy Treasurer RECOMMENDE D AUTON- That the City Council by motion/action accept the quarterly report of the City of Lodi pooled. money investment account as required by S]3564. BACKGROLFND INFORMATION: The investment report is currently included in the monthly executive report distributed. to Council. SB564 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 format. 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 and conforms to guide lines set forth by the CMTA investment report cornrnittee. The Finance Department will continue to include the investment report rnonthy as part of the executive report. FUNDING: Nome. Vicky McAt e Finance Director/Treasurer City cf Lodi 212 W. Rre St. Lodi, Cid 952.0 (209)333-6500 ;nvestmants fflar Valaxe Market value ask Vatue % Of Porftfio Term fey$ t� matuft Y7 M aaw. Y �3� 365 Equiv. Lolcal A9900y invaStmant Funds 11,945,665.92 11,946,6a6.92 11,948;685.92 71.81 1 1 1.953 1,980 C f�afes oft it -Funk 1,300,E 00;00 X1.300,000.00 1,3Cio,tFpO.ii(1 7.79 209 130 ?.413 1.433 ra5sbtxakiCh tieagA=u $,437,527.47 3,437,527.47 3,437,527.47 21.80 1 1 0.000 0.00 Investments 16,686,213.39 16,686,213.0 16¢ ,213.35 1W 17 . 11 1,509 1.529 ?9 3arnings -----.. ......... - .... ......... ...... ......... Mune 30 oath .ming ....... .... _. _.. ......_ _. ....._ .. . ...... .. ......... F Yes To .... ......... ..... Fief Year Ending ---- --- _ _. Cum Year 0,976.11 303,020.54 303,020.64 Average Daffy Balance 16, ,279.24 15,682,184.12 Effective Rate of Retum 1.42% 1.91% Based on the approved i to the int the bay 1s adhered to, i quiddyy is 7 ab$e for ft r 30 days. Union Bank of California is the source of marker vataaabon. Marcda Mmne dadwaflader, Revmus Trew. Paffdio CITY AC Run M± ie 07/bW2003 - 70:3.6 PM (PRF PMI) SYn7Rspt V5.01f City of Lodi Portfolio Management Qv June 30, 2003 Average Pwcha Stated YTM Days toatUrdl CUS1P inv mew # issuef Balance a fear Value Market Value Sook ue Rate ody�'s Maturity Date Local Agency Westment Funds LA€1^ 'swo L-ocz! Agemy tovest. fwn4 11,040,203.03 11,040,203,03 11,00;x.03 i-sw 1,953 1 Lp9C 4'ool Local kg y iry Fisted (LPIC) 90802,0$ 9£f3,482,89 9 ,492•#9 1,980 1.353 1 Subtotal. and Average I I'MAM,82 1, a92 11,948,81W,92 11,848TS85,92 1 Certifies of Deposit - Oank WEST 59 8ankathe West 04117/2003 100, . ?fpm it 100,000-00 1,190 1.190 293 04/17/2004 57 Bank of America IV1712002 100,0W.40 3:w, .00 100,000.00 1.300 1.300 169 1211€£2003 FM 9£7 Farmers and Merobants Bank 04126/20W 1,0 AGD= 1,wo,=,00i,owoo.0,00 1,400 1,400 114 10a23I2t 3 LORI 58 Bank of Lodi F 04/0112003 1w,0M.00 1W . 3 100,000.00 I'm 1 89 09128/2003 Subtotal and Average 1,3w,.t . 1, o.0 1,300,ODD.00 I's --: m 1.443 130 PassbookfChecking Accounts Pa CCt 4= Bank of America 07101r2002 253,W9.03 253,M,03 253,380-03 0,0w 1 4000 f armaTs & Mwohants 3,153,63&.44 3,183; .44 3,183,638.44 O.flO&3 1 Subtotal and Average 4,756,5/.32 3,4S7,627 A7 3 7,627.47 3AZ7,627.47 0.000 1 4'oW Investmert asp€! Average 18,x,279�A 30, ;213:39 lis ,21S.�w9 19 243.39 9.5 11 Portfolio CITY AC Run i3aw 07107i2isQ3 - 10:35 EM (PRF—PM2) SYMRew V5.01f City of Lodi Portfolio Managements Portfolio Details - Cash June 3, 2003 Average pu a fated YTM Days to cusip Investment # r Balance Doe Flay Value Market Va4ut Book Value Rate Mo y's aw Katuffty TSI Cads and lnwWments 4 ,275.24 Ufa 213.29 is ,233.39 16, ,213$ 39 I.Sw 19 Paso CITY AC Run Hake: f)Fi M(M3 - 34:36 PM (PRF_PPA2) SymRept V,9 -01f City of Lodi Porffofio Management Investment Activity Y, y Type June 1, 2003 through June 30, 2003 Stated Transaction pufcNises Ssie aturitles CUSIF mveslnwnt # issuer Rate Date or ersiis or . ra a9s Balance Local Agency Investnent Funds IMonthly la ry) subtotal PassbooklChecking Accounts (Monthly ry) BACK 4003 Bank of Amwica 40M Farmers & Merchants Subtotal ail 3,677..82 10,9550,4$6.73 11,341,1SC35 1'1.,541;1 84.35 445,606.47 12,257,M.76 12,705,715.23 12,705,715.23 3,437,5VA7 FTI 'moi EkIi ; Um Poo folio CITY AC Run Late O77&k-'0'3& PIA (PRF -PW) SynRept V5.01f City of Lodi Portfoho Management HE U� Run E)ate: 07JO712OW - 1 O'U Average 9 16,706,724,57 2AW119 2.0350/6 2.444 1 0 82 23 Portfolio CITY AC PM (PRF_PM4) SYMRSpt V5 Olt ------------ yiew to maturity manaw Number Number month Number of TOW 380 Pool of Securities of securities Average Average End Year securnies invested EquNalem EquivxIant pate purchased Matured j SOW Term Days to Maturity June 2092 10 16,-99,650.78 2.769 2.807 2,760 0 0 144 74 Jujy 2002 8 15, 1 14,3BO.20 2,407 2,440 2.750 1 1 87 28 Augu,-A 2002 8 17,709,502,46 2.054 2,G63 2.750 0 0 74 20 septen*er 20.02 8 12,183,102.24 2.430 2.464 2,750 0 108 24 October 2002 8 14,537,535.82 1-9w 1,994 2.63D 2 2 91 29 November 2002 a 12,026,947-82 2.377 2.410 2.630 0 0 109 29 December 2002 9 14,147,608 . 12 2.031 2.059 2.630 1 0 95 23 January 203 9 14,999,531.80 1.767 1.1192 2.370 0 0 90 17 February 2003 9 17,129,142A4 1.879 1. 2,310 0 0 79 11 March 2003 a 17,242,1 -903 7.867 1.833 2,310 0 0 79 7 April 2003 9 97,437,91:50 1.638 1.660 11980 3 2 78 16 May 2003 a 18,050,764,27 1394 1.414 1.980 0 1 16 12 June 2003 a 16,e86,213,39 1.509 1.529 7. 11 0 0 17 11 Run E)ate: 07JO712OW - 1 O'U Average 9 16,706,724,57 2AW119 2.0350/6 2.444 1 0 82 23 Portfolio CITY AC PM (PRF_PM4) SYMRSpt V5 Olt City of Lodi Portfolio Management Dist6bw-4_e,n,5f Iny"tmz-FVis By Type June 2002 through June 2003 Repurchase Agreements Federal Agency issues -Coupon Treasury unities - Coupon moi Backed secw - -- kers ce ances rtizing Romme=Ul paw Diss. ----------------------- Federal Agency Dom. 4kmortizing Treasury Mcounts 4kmodizing Misceftaneous Di is -Anwrtizinq Portfolio Cliff° AC Faun Date: 07107=3 -13,55 PM 4PRF_PM5) SymR%A V5.011 June . uty AuWvst ptember October Novefnber cernabw January Febfuuy mamh e W -y jw4t Average Investment Type 2= 2= 2= Z= z= z= 2= 2= Ww 2= 2OW 2= by Period Local racy Investment Funds 69.2 64.8 55.3 59.9 50.7 61.3 52.1 49.4 57.8 57.4 57.1 66.2 71.6 59.4% atm Of .. - ------ 7.7 -----_____.____..__ 7.9 6.3 .____.. _--- 9:9 -- 83 --------________... 10.0 ._ 9.2 -- .7 ---____. 7.6 7.5 _ --- 7.6 --. _______m__. 7.2 _ __ ._-- T8 ------_-- ----8.2% extiates of Deposit - S & L kMg s 11.2 20:5 32.2 21.!D 34.1 ----- 203 31.6 35,2 ._-- - 25.7 .. 23.1 - .. _._- 29.1 -- 26.6 20.6 26.3% ----- -- - C ate: i T rte ._._....-------- 6,0 6.7 &7 --- 6.3 -_---- TO ____ _...___ 8.4 ___._____ 7.2 6.8 5.9 3:9 5.9 Repurchase Agreements Federal Agency issues -Coupon Treasury unities - Coupon moi Backed secw - -- kers ce ances rtizing Romme=Ul paw Diss. ----------------------- Federal Agency Dom. 4kmortizing Treasury Mcounts 4kmodizing Misceftaneous Di is -Anwrtizinq Portfolio Cliff° AC Faun Date: 07107=3 -13,55 PM 4PRF_PM5) SymR%A V5.011 Earnings during Period 1,530.84 89,99499 Pass Through Securities, Interest Coliected fts Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Less Accrued Interest at Purcwhase During Period interest Earned during Period Adjusted by Premiums and Di aunts Adjusted by Capital Gains or Losses Earnings during Period Cashichecking Accounts. Interest Collected Plus Accrued Interest at End of Period Less Accrued Is at Beginning of Period Interest Earned during Period Total Interest Eamed duftg Period ...... . . . . . . . . . . . . . . . . . . Pun Date: 07107r2M3 - 10:36 0.00 0,00 a0a) 0,00) OW O,OD 10,00 MR 0-00 OW 0-00) a0G) 0.00 0.00 Q-00 wil PoFtfogo CITY AC PM (PRSPMB) SyrnRept VS 01 f Portfolio Management Page 7 Interest Earnings Summary June 30, 2003 June 30 Month Ending Fiscal Year ToOke CDICoupoWlDiscount tnvestrnents: Interest Collected 111.95 U0,292,55 Pius Accrued Interest at End of Period 3,095,12 3jM5.12 Less Accrued Interest at Beginning of Period 1,67623) 44,359.26P) Less Accrued Interest at Purchase During Period 0,00) 0,00) Interest Earned during Period 1,530,84 79,028.35 Adjusted by Premiums and Dis-munts 0,00 10,966-61 Adjusted by Capital Gains w Losses 0.00 OW Earnings during Period 1,530.84 89,99499 Pass Through Securities, Interest Coliected fts Accrued Interest at End of Period Less Accrued Interest at Beginning of Period Less Accrued Interest at Purcwhase During Period interest Earned during Period Adjusted by Premiums and Di aunts Adjusted by Capital Gains or Losses Earnings during Period Cashichecking Accounts. Interest Collected Plus Accrued Interest at End of Period Less Accrued Is at Beginning of Period Interest Earned during Period Total Interest Eamed duftg Period ...... . . . . . . . . . . . . . . . . . . Pun Date: 07107r2M3 - 10:36 0.00 0,00 a0a) 0,00) OW O,OD 10,00 MR 0-00 OW 0-00) a0G) 0.00 0.00 Q-00 wil PoFtfogo CITY AC PM (PRSPMB) SyrnRept VS 01 f June 30, 2003 Amount Percent Of Portfolio 11, ,685.92 71.608133% 1,300,000.00 T79G863% $3,437,527.47 M6010041/16 0.000000% 0,000000% 0.000000% 16,686,213.39 100-0011/0 Gorporate Medium Terra Treasury Securities - Note Federal Agervoy issues - Coupon Coup nae ..,,, $3,43.7,527.47 PassbookfChenckir Accounts 21% $1,300,0WOO rrfcates of tsit - Bank 8% $11,W,555.92 Agency;nvestment Fund 71% OLocW Agency Investment Fund $11,M,685:92 IMCAitftales of Deposit - Bark 1, �,=.00 PassbooVChercking Accounts $3,437,527.47 GCorato mum Term Note Treasury Securities - Coup 0 Federal Agency :Issues - Gags �00Z s I � qO p�SIAON 0 60'8+ 6c, t- 91,0- `t- 9I°0- 0t !36'1- 0 SZ10+ 85'f- 06'0- 0 9I."O+ £Y°0+ 80'0`x' - --------- 0 9VO- 0 ZO'O+ WOMA IIDNVII:) a9vima:3uga I 00°001 T£9`9bo,ts 0 0 60`8 DOL OL£`17 Stl*8 I8r`895`v 68'£ 9954001`Z Q'0g at" 6'81 q [[fi� ZL06 tZ`O gg i O I£9 51°0I 560'9WS 56°SI 561`OZ9`8 0 0 0 0 t7L'O OOO,iIO 99`51 t zy,58568 9£°9 tv"sa,£ CS, I I 098WZ`9 0 0 19,01 / 09�,`9£G`5 0 0 ZWO 005'L61 INK)HAd IN-101AI EOOZ `Ii ,.Ipw (sadS,L llv) lujo L sasupindiH pasiaAa 51100.1 palood spuog a4u.iodao,) JwIH .iade,l le l �atr ttto "v K, NI) SI!Sod3u a l'L sajoK Saar oasrG 93ua V leaapad SaSu'panda saauej ai3N7 sAa3lueg Sajo�,T -Juv€1 silso€la(l jo al ;ai;lana suo no3 S aua 3V l'eeaapaA S UatiIUIJAOf) 1910,L , sdpjS Sad€)N spu€ u SIMI 1111MtU-3A s ) (U31,L) Wo 0003 01'IOJ,L'9 d INH1033V ,I.NMVI.SHA NI N,,IN ! H'100d 3HJ, 10 SISA'-IVNV VINHOJI'IV�) do Hilvils HHHasvaHl SAGIrlaDKV allil d State iri1i Pooled Money Investment Account MarketValuation 3131103 pL jy Dills $ 497,500,319.42 $ 499,201,736.10 $ 499,262.000.00 IVR Nates $ 5,736,360,421.16 $ 5,735,483,521.97 $ 5,825,817,500M $ 69,701,5$3.50 '2deCa A enC BA $ 370,592,259.72 $ 370,571,195.66 $ 368,310,504.96 $ 1,051,172.09 MBS $ 433,554,403.64 $ 433,554.403.64 $ 431.661,074.15 $ 2,222,632.75 Bons A $ 2,631,287,689.67 $ 2,6531,046,023,00 $ 2,6589,297,333.00 $ 37,602,6124.09 Floaters � $ � $ $ $ Discount Nates $ 8,620,194,515.84 $ 8,653,849,040.36 $ 8,656,858,441 .20 NA FHLM PG $ 5,472,752.54 $ 5,472,75254 $ 6,014,617.03 $ 87,977.09 aNMA $ 631,416,54 $ 631,416.54 $ 74.2,878.11 $ 6,275.50 3anktances $�,..... $ $ .� NR Sank Notes $ � 400,000,000. $ 400,000,000.00 $ 400,043,782.00 $ 1,275,611.11 ?� $ T 8,585,124,083.24 $ 8,585,124,083.24 $ 8,586,645,116.70 $ 32,858,772.27 �ommerdai Paper $ 10,240,071,762.37 $ 10.262,084,215.14 $ 10,263,752,918.23 NA Floaters $ 313,415,866.28 $ 313,415,866.28 $ 310.735,340.00 $ 622,396.98 Bonds $ 1,757,149,716.10 $ 1,785,164,185.15 $ 1,821,766,723.27 $ 29,708,106.12 Fie urchas� R cements $ $ NA Revere Fie urchase $ a $ e $ m $ - Time Deposits AB 55 & GF Loans $ $ 5,486,095,000.00 8,939,180,836.32 $ $ 5,486,095,000.00 8,939,180,836.32 $ $ 5,486,095,000.00 8,939,180,836.32 NA NR T—CT`AL ry-- $ 54,046,631,042.84 $ 54,1 00,874,275.95 $ 54,286,184,364.97 $ 175,137,151.50 Fair Value Including Accrued Interest $ 54,461,321,516.47 Repurchase Agreements, Time Deposits, AB 55 & General Fund bans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). The value of each participating dollar equals the flair value divided by the amortized cast (1.6)03425270). As an example: if an agency has an account balance of $20,000,000.00, thea the agency would report its participation in the LAIF valued at $20,068,505.40 or $20,000,000,00 x 1.003425270. 12 devised March 31, 2003