The URL can be used to link to this page

Home My WebLink AboutAgenda Report - August 4, 1999 E-03AGENDA TITLE: Investment Account Disclosure MEETING DATE: August 4, 1999 PREPARED BY: Deputy 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 SB564. BACKGROUND 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 committee. The Finance Department will continue to include the investment report monthly as part of the executive report. FUNDING: None. 0-;-� (k'C Vicky McAthie Finance Director/Treasurer _Type of Security Local Agency Investment Fund Certificates of Deposit - Bank Passbook/Chercking Accounts Treasury Securities - Coupon Federal Agency Issues - Coupon BREAKDOWN OF TREASURY INVENTORY BY TYPE June 1999 Amount Percent of Portfolio $19,300,000.00 63.579394% $1,200,000.00 3.953123% $2,355,747.07 7.760465% $0.00 0.000000% $7,500,000.00 24.707018% $30,355,747.07 100.00% Maximum Maturitv Indefinite 5 years Indefinite 5 years 5 years -Aoue6e 6ugediaiped goes of pel!ew aq uoos ll!m la)loed uoileilsi6ei aouaialuoo ayl -uoissIwwoo A.josinpy luawlsanuI 19 igao eiujol!leo ayl to joloajia anilnoax3 `zado-1 o6nH Pus iamseail ale3S Alndaa ;aiyo `lsned uilsu>i `-oo Pus syoeS `uewpIoo SOI yoJeasaa oiwouoo3 's'n jo aopaiia Pus joloaaia 6ul5aueW 'Aelpnd a weill!M `sepiIeBuy diliyd jainseajl alelS apniout ll!m sieNseds lsen6 s,jeeA siyl aaluaa uoiluanuoo oluaweJoeS aul Is -w-d O£=Z of w -e o£:6 woil '666L '6 jegoloo uo prey eq ll!m eouejaluoo pund luawlsanuI AoueBV leoo-I jenuuy eyl -Aepij3 y6noiyi Aepuow •w•d gt:p Alun uedo wewaj ll!m pus smog sseuisnq sli 6uipua4xe sl d1dl 'uoilippe ul 'aouenpe ui step ual of do suoiloesuejl jol jo sseuisnq s,Aep lxeu ayl jol aq ll!m -w-d g �:y gBnojyl ,w*e oo:0 6 io4e ueMel suoiloesuej„L -are 00:01 of -w -e o£:L wal slemejpgi!m pus slisodep ldeme of mopuim uoiloesuejl ,Aep awes„ ay; 6uipuelxe sl JIVI ayl '666 L 'L aunt 6uiuui6eq '4 aaQasa3IIo`J 1nuw SIMOIR ssamsna amv panj JU9M .saeaI OUag► Ie3WI tAOCINIAA .LVa 3MVS 6661 SGMZJLXR 3I" 6661 `1 F T)JEW Pas!^aN Z Z '509 L9KW' L x 00'000'000'OZ$ jo ' L L'O£Z'600'OZ$ le penlen =IIHI aLp ul uogeaplpea sll podai pinom Abus5e eqj uaLp '00'000'000'oZ$ jo soueleg lun000e ue sey Aoua6e ue p :aldwexa ue sy (905&91b000'L) lsoo pazlpowe a4a Aq PaP!A!P amen ale} ay; slenba jelloP 6ugedplped pea jo amen alll -(lsoo 6ull(Leo) amen Nooq ollogpod le paweo aie sluauJm6e esey;undaa as maj pue 'sueol pun j lemwJ '8 $5 eb 'sllsodea awl 'slug mAV eseynmdaa t9'Ss£`ro9's1,9'E£ S lsalalul pen=t/ 6ulpnpul anleA me j l 8 Ol 8L' LS £66 L6'Li8 6Lf 91,9 E L9 LEti EE s IVIOI 0 5.1007WREWIM I m7qgfLfgOsl,)ase �:!Wanea VN 9L0 L 6 16 1 6 JwItd 18103MIM VN 9£9 L9'006 LL 9ES L9-926 LLWSC9 Z s EUVOI Jo T 99 ev VN 000 E60 £60 000 049 £60sy aw1 1!N VN VN VN SPARGes M9433naski GOT L£ 690 2Z S 96 4L 6Z0 S L V& S 88'960 906 L L 1,L T 1, '490 8 L l L Z4' L9 W 9L' 849 SS8 t 99'1►S gWgWt S OC'*ZS'6Ct Z98 4 Sao LO' L 9 OS' O L '£90 -GZVr—T OVM191, UO l IMPOW 9LIL6TVN,O-t----y WON ws, LOL S 66'L LZIOS ML L —SPmv NN 00,01M LL9 99 f 098 99 s UILO K4 99 s muwklwv waluve VN 0076Z S 090 4 9£'tL9 1,90 0 'ESO 8 L 686 s2ION Woos, 0 'LW" W* t MUL 8l 5 £Z'i1961, LL rig 6L LL s OdOWIHd 1,6-91,9 96' 18 90*OWL"'EU S ISETTEWER s vas O1r'£88 8L S LO'COV61, 1, Z S GL'Mg LL8 1. 1 SL'Z6S LLS 1, s VANJ gg* LK S 66'96► L E9 9L'£SL O£S Z9 9 'ESL OES Z9 s SSW 0CM91101 s 00'009SL 69l s 00'000 OL L '000 000 OL 1, sJOPOIA S£'ZL Z£ S 06'696 Z£Z Z1,0 £ f SCOWOUSLO-T—T S£'LLZ 049 SLO £ spuoS FJapad 09'9£119999 QO'OSL 6£8 £ S L8' L49 SL4 SZS £ S L '£L£ £1,0 LZS £ s saloN WN 9E' 1,1,9 8Zi 96 L E sir' 19011,0"961, t S ECESZ SS8 4 l £ s sills n0531sams Pavan »` ..mgg .v s64M uogenjen IOIJew jun000V Iuaw;Sanu1 Asuow pelood e.IuJOJ!IB3 10 ejejS City of Lodi Portfolio Management Portfolio Summary June 30,1999 City of Lodi 212 W. Pine St. Lodi, CA 95240 (209)339-68W Investmeltts Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 123,165.73 1,492,834.52 1,492,834.52 Average Dally Balance Effective Rate of Return 29,653,834.76 5.05% Marcella Maxine Cadwallader Date Based on the approved budget and to the extent the budget is adhered to, liquidity is available for t1w next three to sb(months. Union Revenue Managed)eputy Tram. Bank of California is the source of market valuation, Run Date: 0711311999 -12:15 Portfolio CITY AP PM (PRF _PM 1) 6ymRept V5.01 Report Ver. 5.00 Per Market Book % of Days to YTM 360 YTM 365 Value Value Value Portfolio Term Maturity Equiv. Equiv. Local Agency Investment Funds 19,300,000.00 19,300,000.00 19,300,000.00 63.58 1 1 5.049 5.119 Certificates of Deposit - Bank 1,200,000.00 1,200,000.00 1,200,000.00 3.95 365 185 4.144 4.202 Passbook/CheokingAccounts 2,355,747.07 2,355,747.07 2,355,747.07 7.76 1 1 1.027 1.042 Federal Agency Issues - Coupon 7,500,000.00 7,412,415.00 7,500,000.00 24.71 1,169 1,050 5.652 5.731 Total Investments and Averages 30,355,747.07 30,268,162.07 30,365,747.07 100.00% 304 267 4.850 4.917 Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 123,165.73 1,492,834.52 1,492,834.52 Average Dally Balance Effective Rate of Return 29,653,834.76 5.05% Marcella Maxine Cadwallader Date Based on the approved budget and to the extent the budget is adhered to, liquidity is available for t1w next three to sb(months. Union Revenue Managed)eputy Tram. Bank of California is the source of market valuation, Run Date: 0711311999 -12:15 Portfolio CITY AP PM (PRF _PM 1) 6ymRept V5.01 Report Ver. 5.00 CUSIP Investment# Issuer City of Lodi Portfolio Management Portfolio Details - Investments June 30, 1999 Average Purchase Balance Date Par Value Market Value Page 2 Stated YTM 365 Days to Maturity Book Value Rate Equiv. Maturity Date Local Agency Investment Funds 1000 Local Agency Invest Fund 11 12,700,000.00 12,700,000.00 12,700,000.00 5.119 SAO 1 1001 Local Agency Inv Fund (LPIC) 3133MBWC4 6,600,000.00 6,600,000.00 6,600,000.00 5.119 5.119 1 6.040 Subtotal and Average 20,985,613.07 1,257 12/09!2002 19,300,000.00 19,300,000.00 19,300,000.00 07/0911998 5.119 1 Certificates of Deposit - Bank 5.910 5.910 739 07/09/2001 3133WLKO 10 Feredal Home Loan Bank (call) 02!2611999 1,000,000.00 13 Central Sierra Bank 04/15/1999 100,000.00 100,000.00 100,000.00 3.510 3.559 291 04/17/2000 7 Farmers and Merchants Bank 12/21/1998 1,000,000.00 1,000,000.00 1,000.000.00 4.150 4.208 173 12121/1999 9 Guaranty Federal Bank 01/11/1999 100,000.00 100,000.00 100,000.00 4.720 4.788 194 01/11/2000 Fannie Mae callable note Subtotal and Average 1,200,000.00 1,000,000.00 1,200,000.00 1,200,000.00 1,200,000.00 5.760 4.202 185 Passbook/Checking Accounts Fannie Mae callable note 12H5/1998 1,000,000.00 987,660.00 1,000,000.00 5.350 5.350 900 12/172001 4003 Bank of America 07/01/1998 164,858.01 164,858.01 164,858.01 0.000 1 4000 Farmers & Merchants 2,190,889.06 2,190,889.06 2,190,889.06 1.120 1.120 1 Subtotal and Avenge 1,134,888.37 2,366,747.07 2,356,747.07 2,356,747.07 1.042 1 Federal Agency Issues - Coupon 3133M7SQO 11 Federal Home Loan Bank 03/0811999 1,000,000.00 987,500.00 1,000,000.00 5.570 5.570 981 03/08/2002 3133MBWC4 14 Federal Home Loan Bank 08!09/1999 1,000,000.00 989,370.00 1,000,000.00 6.040 6.040 1,257 12/09!2002 3133M4TB9 1 Fersdal Home Loan Bank (call) 07/0911998 500,000.00 497,735.00 500,000.00 5.910 5.910 739 07/09/2001 3133WLKO 10 Feredal Home Loan Bank (call) 02!2611999 1,000,000.00 982,030.00 1,000,000.00 5.550 5.550 1,152 08/26/2002 3133M93F7 15 Feredal Home Loan Bank (call) 06/28/1999 1,000,000.00 995,780.00 1,000,000.00 6.175 6.175 1,093 08/282002 3133WN07 5 Feredal Home Loan Bank (call) 12/03/1998 1,000,000.00 983,750.00 1,000,000.00 5.580 5.580 1,068 06/03/2002 31364GR43 12 Fannie Mae callable note 05/17/1999 1,000,000.00 988,590.00 1,000,000.00 5.760 5.760 1,051 05/17/2002 31364GLG2060 8 Fannie Mae callable note 12H5/1998 1,000,000.00 987,660.00 1,000,000.00 5.350 5.350 900 12/172001 Subtotal and Average 6,333,333.33 7,500,000.00 7,412,415.00 7,500,000.00 5.731 1,050 Total Investments and Avenge 29,653,634.76 30,355,747.07 30,268,162.07 30,365,747.07 Run Date: 0711311999.12:15 4.917 267 Portfolio CITY AP PM (PRF PM2) SymRept V5,01 Report Ver. 5.00 City of Lodi I Run bete: 07113/1699 -12:15 Portfdio CITY AP PM (PRF_PM3) Sym Rept V5.01 Report Ver. 5.00 Portfolio Management Pae 3 g Investment ActivityB Type Y YP June 1, 1999 through June 30,1999 Stated Transaction Purchases SeleslMaturitles CUSIP Investment / Issuer Rate Date or Deposita or Withdrawals Balance Local Agency Invesboent Funds (Monthly Summary) 1000 local Agency kemst Fund 5.119 0.00 65,800.81 1001 Local Agency Inv Fund (LPIC) 5.119 1,400,000.00 4,718,395.17 Subtotal 1,400,000.00 4,784,195.98 19,300,MM Certiflcabs of Deposit - Bank Subtotal 1,200,000.00 PassbooklCheaking Accounts (Monthly Summary) 4003 Bank of America 1,581,468.57 1,592,034.25 4000 Farmers d Merchants 1.120 9,947,396.78 8,673,871.82 Subtotal 11,528,863.35 10,265,906.07 2,355,747.07 Federal Agency Issues - Coupon 3133M8WC4 14 Federal Home Loan Bank 6.040 06/09/1999 1,000,000.00 0.00 3133M93F7 15 Feredai Home loan Bank (call) 6.175 0512811999 1,000,000.00 0.00 Subtotal 2,000,000.00 0.00 7,500,000.00 Total 14,828,863.35 15,050,102.06 30,355,747.07 I Run bete: 07113/1699 -12:15 Portfdio CITY AP PM (PRF_PM3) Sym Rept V5.01 Report Ver. 5.00 City of Lodi Month End Year Number of Securities Total Invested Portfolio Management Investment Activity Summary June 1998 through June 1999 Yield to Maturity Managed 380 355 Pool Equivalent Equivalent Rate Number of Securities Purchased Number of Securhles Matured I Sold Average Tenn Page 4 Average Days to Maturity June 1998 13 31,662,836.07 5.578 5.655 5.673 1 0 142 123 July 1998 14 26,383,809.36 5.579 5.644 5.672 5 0 192 162 August 1998 13 27,624,854.96 5.416 5.480 5.672 0 1 163 133 September 1998 13 27,101,627.55 5.240 5.302 5.652 1 1 166 131 October 1998 12 26,256,791.43 5.298 5.360 5.640 0 1 170 129 November 1998 11 25,689,259.39 5.303 5.367 5.640 0 1 146 108 December 1998 12 30,093,074.92 4.741 4.795 5.492 3 2 191 169 January 1998 12 29,653,471.34 5.213 5.274 5.460 1 1 192 166 February 1999 13 29,294,246.16 5.098 5.168 5.210 1 0 239 207 March 1999 14 27,704,197.72 4.940 5.009 5.136 1 0 293 250 April 1999 14 31,211,557.89 4.799 4.865 5.119 1 1 260 216 May 1999 13 30,476,985.77 4.950 5.019 5.119 1 2 225 196 June 1999 15 30,355,747.07 4.850 4.917 5.119 2 0 304 267 Average 13 28,625,266.13 5.154% 5.220% 5.431 1 1 206 174 Patfdio CITY AP Run Date: 07/1311999-12:15 PM (PRF PM4) Sym Rept V5.01 Repan Ver. 5.00 City of Lodi Portfolio Management Distribution of Investments By Type June 1998 through June 1999 Page 5 June July August September October November December January February March April May June Average InvestrnentType 1888 1998 1888 1996 1998 1898 1888 1988 1998 1989 1999 1999 1999 by Period Local Agency Investment Funds 84.0 78.8 78.2 74.2 75.4 77.9 65.8 _ 77.0 75.1 66.8 66.9 74.4 63.6 73.7% Cettifie11 of Deposit - Bank 4.1 4.9 4.7 4.8 4.6 4.5 4.0 4.0 4.1 4.3 3.8 3.9 4.0 4.3% Certificates of Deposit - S dr L _ -._... -- --- _PassbooktChscking Accounts 0.9 1.1 4.4 8.1 6.7 6.3 15.3 3.9 2.0 5.4 8.4 3.6 7.8 5.7% Commercial Paper - Interest Bearing Repurchase Agreements -- _ Federal Agency Issues - Coupon 11.1 15.2 12.7 12.9 13.3 11.3 _ 15.0 15.1 18.8 23.5 _ 20.8 18.1 24.7 16.3% _Treasury Securities - Coupon _ Mortgage Backed securities Bankers Acceptances ,Amortizing - - CommerMal Paper Disc. -Amortizing Federal Agency Disc. -Amortizing - ---------- Treasury Discounts -Amortizing - _- - ---- -�- - - Miscellaneous Discounts Amortizing - ---- --- Portfolio CITY AP Run Date: 07/1311999-1 2:15 PM (PRF PM5) Sym Rept V5.01 Report Ver. 5.00 City of Lodi Portfolio Management Page 6 Interest Earnings Summary June 30,1999 June 30 Month Ending Fiscal Year To Date CD/CouponlDiscount Investments: Interest Collected 66,644.29 304,810.27 Plus Accrued Interest at End of Period 69,889.77 69,889.77 Less Accrued Interest at Beginning of Period ( 102,546.69) ( 43,136.17) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 33,987.37 331,563.87 Adjusted by Premiums and Discounts 0.00 448.65 Adjusted by Capital Gains or Losses 0.00 997.02 Earnings during Period 33,987.37 330,118.20 --- --- pass Through Securities: .----- _ ---- ---- Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued interest at Purchase During Period { 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 A4usted by Capital Gains or losses 0.00 0.00 Earnings during Period 0.00 0.00 Cash/Checking Accounts: Interest Collected 814.50 1,294,832.29 Plus Accrued Interest at End of Penrod 266,520.36 266,520.36 Less Accrued Interest at Beginning of Period ( 178,156.50) ( 396,636.33) Interest Earned during Period 89,178.36 1,162,716.32 Total Interest Earned during Period 123,165.73 1,494,280.19 Total Adjustments from Premiums and Discounts 0.00 X48.65 Total Capital Gains or Losses 0.00 -947.02 Total Earnings during Period Run Dole: 07/131900 -12:15 123,165.73 1,492,834.52 Portfolio CITY AP PM (PRF PM6) SymRept V5.01 Report Ver. 5.00