Loading...
HomeMy WebLinkAbout9/5/2007 - STAFF REPORTS - 2.H. Fpp,LM SA4 iy c U N 4 ie c e� 4LIFORN`P City Council Staff Report DATE: September 5, 2007 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF JULY 31, 2007 FROM: Craig A. Graves, City Treasurer BY: Department of Finance and Treasury SUMMARY Attached is the Treasurer's Investment Report as of July 31, 2007. The report includes the face value and coupon rate (if applicable) of the investments and the source for the market value estimate. Also included is information on the investments of Bond Issue reserve funds, and on loan repayment programs managed by a bank. RECOMMENDATION: Receive and File Treasurer's Investment Report as of July 31, 2007 STAFF ANALYSIS: The attached monthly Treasurer's Investment Report is for the period ending July 31, 2007_ The report includes the face value and coupon rate (if applicable) of the investments and the source for the market value estimate. Also included is information on the investments of Bond Issue reserve funds, and on loan repayment programs managed by a bank. The investments, in type, maturity and as a percentage of the total portfolio, are in compliance with the existing City Council-approved investment policy with one exception: the FICO notes ($500,000, 4/16/18, 9.8%) exceed the 5 year limitation on maturities (Detail of Investments, Long Term Investments, Mortgage Pass Thru's). The investment in question was purchased prior to the adoption of the 5-year limitation. Since it appears to represent no additional risk either because of credit-worthiness or liquidity, earlier councils decided to allow it to be retained in the investment pool because the yield is higher than attainable under current market conditions. We recommend that this exception to the policy be continued. State law requires this report to be submitted within 30 days of the end of the quarter. Because all of the City's bank accounts may not be completely reconciled, there may be minor adjustments to the cash on hand in the checking account and to the valuation of the bond issue's money market investments. All other amounts are actual. ITEM NO, a City Council Staff Report September 5, 2007-- Page 2 Treasurer's Investment Report as of July 31, 2007 The weighted average maturity (WAM) of the portfolio is 453.61 days. The maximum WAM allowed by the Investment Policy is 1095 days. The current portfolio and expected revenue cash flow will be sufficient to meet budgeted expenditure requirements for the next six months and the foreseeable future thereafter. FISCAL IMPACT: None /icfA. G ar ves, City Treasurer Attachments: Treasurer's Investment Report QQQQQ� rreasrep CITY OF PALM SPRINGS 8/28/2007 TREASURER'S MONTIILY REPORT SUMMARY OF INVESTMENTS JULY 31, 2007 On Call Deposits Adjusted Basis Carccory TOG91 Percentage Checking Account S 1,092,112 Srare Pool 34.190,000 S 35,282,112 37.59% Short Tenn Investments (I year or Icss Corporate Notes 1,983,760 Mortgage Pass-Thms 725,424 Time Deposits 5,514,000 U.S.Gov'[Agencies 91500,000 U-S.Treasury Notes 498,490 18.221.674 19.41% Medium Term Investments (1 year to 3 ears) Mongagc Pass-Thins 6.387,037 U.S.Gov't Agencies 22.197.731 28,584,768 30.45% Long Term Investments (3 years to 5 years) Corporate Notes 1,990,270 Mortgage Pass-Thrus 2,040,924 U.S Gov LAgencies 7,742,872 11,774,066 12.54% S 93,862,620 100.GQTI *Some investments made prior to the implementation of We current Investment Policy exceed die 5 year limit 0000012 Iarsr°R TREASURER'S MONTHLY REPORT V28RWi DETAIL OF INVESTMENTS JULY 31, 2007 Caupoa Yield ASdje—d Irr¢o onl}) Pr=QIr Par Valsz Rare Raring hf lry I.ASuunry Cml B.is Tuml \Urkd Value Sours hfarkm%rate- On CA31 D.6u,in: Chtt iag-Bade or Arturra 5 NIA ramb'e AAA oxn 4.63% $ 1.0T_,112 $ S 1,092,112 $ 960,360 Leal Ag�my lnrrt,l Fund(LA1F) 34,[90,CW ranab� NIA qxa 5265; 3;,190,CP] 34,174.S'd LA1F 35J90,000 35,232,112 5'a0 Tvm lusc•unenls I1 or lrs,) Cmpor.Ie Nwu Rear SI a,Co 1,000.000 4 00% AA1 01131M8 4.345 m,vo W2,390 BNY IN.I.Tr 9 ,m Wells F.,Cempaay 1.0m OW 350% AA] OSAWms M3S W3,090 985,540 BNY%V�..,Tr 983,010 1,983,i60 T{oay�e Pass Th:a1 Fo1 ml Hu�a L�rtAfmrg>oe C.W,1 un 2,6D3,D3❑ 4.00% NIA CGOMB 482% i25,423 729,360 BNY 4Varerrt Tr 808,118 Tme I "Ift R, ,424 Wmhuamn klurt Bank 1Lihrary Truer) sm.13 516% AAA 09 NAR 5.16% 500,000 S ,C00 W.lungw Niel SW,CO.I 4Vmhlnemn Muw Bank[Llhrary Traa) WSW 5.20% AAA IR'01 5.M% 500,000 sw m Wash,nglm M.al 0 Washaglon Munml Bank(Lihray 7T s) LWO,DD3 5.27% AAA 10rMw 5.273 I.M.W 1,D3(1,003 Washmgl.hlum] D CD Aaeum Rcguvy Sm ix(CDARS) 48D.DW 5.m% AAA 01a4ACs 5,0% 4M,000 4W."O Palm Baer)Mal Bank 0 Wmhmgloa.tfulual Bea. 1,000,CW 5.24% AAA 0llib 4 524% 1,0m,DB0 1,C00,000 wi bu-AglonM IA I.M.CW Washmgloc Manuel Bauk 1,0W,❑00 5.244 AAA 02,b51A4 524% [,CJ3,pB0 1,010,01)) R'.s "IMMunal 1,D30,0D0 CID Aceourr R hi y (CHAM) 91D.w 5.354 AAA O7117108 5 50% 940,D]0 940,0W M.D.:i Nat Bet D CB A .ax R�guir}Scrrwe(CH.SRS) 94,000 5.15% AAA 0712sm8 5 SOS 94,CW 94,00 PAm DY a Nat Ise ❑ 5,514,Op1 11 S Gov't Agency Sa�nres FFdem1 F.Redo BaA 1pm,000 3.94% NIA D mm? 3.94% 0 a BNY W.wrn Tr 997,507 Feral N.IionA biongue Aim lmon I,C 3,030 3.5D% NIA 1CV12fW 3.50% 1,OW,W0 996,250 BNY Welern Tr 990,938 F� .l Hertz Lawn Bait 5W,CV3 4 76% NIA IM6AR 4.767, 590.w 49%219 BIVY%Vniern Tr 498,591 Federal flame Laan Bark LCCG,PYJ 5.00% NIA 11RSf0] S.W7, 1,000,0u0 998,750 BNY W.I.Tr %S8 438 Fx&W Home Los Bank L000.1W 5.10% NIA 12a&r07 S.10b 1,008,000 999.065 Bh'Y%Ve Ih Tr 999,375 Fed,,J Home U.Bad* 5W.I)DO 4.V.% NIA 00108 4.30% 500,000 49 .500 BNY W.:.n 496,"119 Feft J Humc Lnm Bad. 1,0W,C)0 S.CY% NIA 0208M 5.04m 1,C-N.m W8,75D BNY%V 'r..Tr 939,375 FedeJ Nanuml h1mg.ge As karma L,W,DDO i.�% T'IA 6 IDW 5.25% 1,DD3,D]0 599.609 BNY Wuxm Tr I'm'" Federal Nome L Bank 1.ODO,DO0 4.D2% NIA 0511P108 4 D2�. LON,DI] 990,625 BNY%5a,m Tr 988,750 Fed"Home Ism Bad. 2,000.000 50% N!A WINDS 550% 0 0 BNY Nesrrm Tr 2,Wl,250 FJad Home Len Mwgaga CaMamlvn I.M.OW 5.2519 NIA 06127m8 5 25% 1,mo,CN 999,8i4 BNY lYesu:rn Tr 959,760 Fai.rzl Hoax Lert BEA ].MB000 5.3D% WA M123638 5.3D% LM.DW 1,0W,625 BNY%Vmrn Tr 0 FMeal H.—Hm B.1, 5001000 4.38% NIA MfBAG8 4 38% 500,0D0 496,563 BNY Wmwrn Tr 345,938 � 4.SD3,Dl3 d Fig .r,�rep TREASURER'S MONTHLY REPORT s+zan_oav DETAIL OF INVESTMENTS JULY 31, 2007 CouFan Yield Adlvlcd (memo md') Prior Qv Paz Value Bale Baong 66turny m Miss'[ Cast Basa Cstpiy Toul Market Yalue Svdr.e 6farkel Ve3ue U S.Tee..,Nales U S.Tress M .: 98a,625 3.62% WA 06+30M 4.76% 0 B BNY W.W.Tr 996,450 U S.T.e,Niue 598,4W d.25% NIA ]0 HAR 4 2a% 498,490 4W,219 BNY N'esara Tr 497,813 499.40 Medium Term lnve .---,u fl arta3 ] 6forlpge Pass-"P.>L Federl Hoc-La,a.lforlgage Carporlion 465,030 4.03% WA 0&ffilms 5.56% 132,973 145.162 BNY 1L'e,lern Tr 163,075 Federl Hoe-Loon rlforlgage Carpmalton I-,W.G3 4.03% N!A 09,'p11A9 5.431A 450,196 456.M BNYWe,lera Tr SW,571 Fed,d Hmo Laen Mortgage Carpmmiwa 1 SKM 4,0% N!A WPM 5.87% 49LM 491,679 BN We,lern Tr 558 776 Federal Hom Loa Sfongage Carpamiwn 3 OC❑,CW 5 0.3% N!A 02,YR+09 5 M% 255,523 255,412 BNY We,mrn Tr 2W.083 Federal Hoer Loa 6fone,e Ca,mi.wn 2 315,1W 4 10% N!A 03l01N9 4 88% 865 296 86g679 BNY Welern Tr 938,N3 Fed.-rat Hoot Lam Moneage Corporation 480,1� 4 W% N!A pl101N9 5 10% 237,094 238,134 BNY Wslmn Tr 252,978 Federal Horx Lawn 6foneagx Corporalwn 540,1W Mo% KIA MOM 4 79% 332,=09 332,888 BNY W.,ern Tr 352,377 Federal Horz Lain idoogagx Corpralwn 570,CQ3 d.SO% N!A CArG I.N9 5 37% 372 774 375,817 BNY W'e;lern Tr 407,599 Faisal HorzL en Moon,Coryoratwn 30g0,CW 5.50% NIA IOYI.B 543% 3A4473 305,344 BNY WY fern Tr ❑ Fede d Nalio al Mecegi eAssemalwn 2,700,0M 4.50% NIA 0110lflo 4 9l% 616,156 613,202 BNYW.ie n Tr f ,3139 Fedral Naliom!Meceg>e Assccmlwn 25C❑,C0J 4.aO% N!A OMIfl0 446% 658,A1 5:3,Wl BNY W.!.sn Tr W4,576 Federal Horn.La-n Nfo ,ge C'orpomlwn ]4SS,W3 4.50% N!A 0 Iflo 5.22% 443 839 43,627 BNY Wu.m Tr 475,9L4 Fied.1 NNmm!6lxtgucA,.,.Iion 1,000,103 4.W% N!A 03, 1VID 5.12% 383,671 391,169 BNY W,-' Tr 0 Frd.d Hmcx Laa Mortgage Coryor lion 2 28C,P)3 4.50% NIA OS,YII+1C 5.29% 832,735 839,726 BNY 4Ve•• Tr WA,667 6,387,DR U S.Gorr Agency S urrie3 Fed y Home Laa Bank ],0C❑,CO] a.W% NIA CBNS,UB 5 00% 1 M.03a 990.438 BNY lYuan"!Y W7,813 Fa4.,1 Home L..Bank ],OCO,LO] a.32`4 NIA 09N M 5 32% 1 0 .W3 1,CW,313 BNY 4Vesreto Tr 1,CC❑,625 Ft&ml Hmre Lai Bank 750,CW S.CO% NIA lOn7rU8 5 00% 750,032 7d8,594 BNY W...Tr 747,891 Federal F: Credit R•-h 1,000,CCV 3.95% NIA lOat'08 3.133% 1,WI.DM 986,250 BNY lS'u¢m Tr 903,7A Fedetnl Homz Las Ba" 1,OOO,CO3 4.W% NIA I1717A7a 4.00% 1,C01,0]] W.1113 BI:Y l5'esrero Tr 985,313 F.&.1 Home Lam Ba 1,000,CW 5 U% NIA 02A35A19 5.2 % I.M.W] 9 ,375 DRY l5'espro Tr 0 F ral Home Lom Bank l,0❑O'M 4 23% NIA 0271OM9 4.23% 1,000,0m 9e9,063 DRY N'csmrn Tr 986,075 F'.l Hom.Loan Baal ],000,CC0 5.21% NIA 02127M 5.r% 1.CCO,OA 1,000,000 BNY Western Tr 99., ml Home lam Mixge a Corp rlion ],000,CP] 3.38%° NIA ❑4715109 3.65% 969,2. 974,689 BNY Wesiera Tr 971.250 N,C.l Home lash Bent 1,000,11fA 5 50% NIA O MiA39 5.50% 1,000,CW QXO.00❑ BNY Weslcra Tr 999,175 F,e,.l Home l.cvn Berl 1,000.uBo 5 50% MA Wl17N9 5.50% 1.M.1c0 969,688 BNY YYulern Tr 0 Nd'Ml Nwa al Almov.Aa.a Whin I,OW,OCO 4 01% WA 10'O M 5.10% 976,196 920,DBB BNY We.lern Tr 0 Fe&ta111ame L M,gaec V.aPawl. I,OB0,000 S.COY NIA ]❑R 9 5.12% 996.975 994,375 BNY W'e,tern Tr 9ak,110 Fe&m1 Faro Cade A.,!, 1,H00,0C❑ 4.25% NIA llll&09 4.25% 1,OC❑,CW 933.438 BNY%Valan Tr 983,438 Fed.m1 Home Lion Berl SOG.O 0 5 C❑% NIA 1IPSA19 5.G3% 5W.M :97.01 BNY W'�i.Tr 497,188 17 d&nl Home Iran Bak 1,W0,000 4 3C% NIA 12MIA39 4.30% ],OCO,CC0 984,053 BNY WV tsn Tr 93,063 Federal MtImal Mal,agr Assxurioo I,W0,000 5 25% NIA 12+d&09 a.38% 997,1C0 998,750 BNY WY iun Tr ❑ Federal Home l R I,O]0,000 4.35% NIA 02=10 4 31% I,00R000 983,438 BNY Wu..Tr 9M,iM3 Fxdaal home L Mmrapge CnTa.tl o i.MO w 550% N+A 03,riu110 0 50%% 1,000,000 998,940 BNY 1Vutm Tr 559,310 Fedcml Farm Cred-1 Bank 1,CW,0g0 4.80% N+A O .%flo 5.2519 988,28E 990,aO BNY Wuaa-n Tr 0 l� Fed[d Fmm CYedr1 Bank 2,CO3,0g0 555% N+A 071W10 5.55% 2,000,000 2.M,63 BNY Wes¢ra Tr 0 Fedcrd Home L. ,Hart I,0)7 M 55C% MA 07/23/10 5 5C% I,OmB 000 WO.418 BNY 1%,sa Tr 959w 22,197.A] Q O �n e�caP TREASURER'S MONTHLY REPORT aaar2m7 DETAIL OF INVESTMENTS JULY 31, 2007 Cwpon YOU Ad,. d [uvmo only) Ptmr Q,r Par Value fte Bain, M�ruriry ra M_mmy Cx C -.o TVA meta [Value Source N a a Yalu, Irani Ter.Invxsnn,a [3 .yrs 105 Barr) Co r.!e Noes SBC Gemmu.almm.ra I,OD3.000 5 30% A2 3111511D 5 l7% 1,O0f,1A 99558D BNY W.Wl Tr 0 Gedrt Salo Gmup,lre 1.0m oW 5 W A AA] 01115111 517, 986,1241 981,i 19 SKY W'eslern Tr 94d,9L] I,M,2iV hlxgaie Pa<s-'ITrus FM,rA Home Lam bfan,agx Carpmalmn 1,3N ouo 5 W% NIA 09M I1lD 5 35% �53,537 454,986 SKY N'man Tr 0 Feder.]Hame Lam Bank 7]S,OW 2 7a% NIA 1812511D 4 88% 559,93fi 553,152 SKY WYs Tr 55i,]03 FedeW Home L n blon,agx Carpo.mn 1.035.552 5 50% NIA anUL[ 5 24% 4M.4& 492,245 SKY W'cslran Tr 0 Federr)Hame Loin Nfw,,x Corpo.uen 695,000 4 W% WA (Y.63[11[ 5 22 a 412,335 413,541 WXY W'esem Tr 0 Feder l Home Lom.Sfon,age Ca,m.lum 200,000 3 50% NIA 05M III l 5 37% 118,653 318,339 MY W'esem Tr 127,322 2,010,924 17.5 Gav'1 A,.y securui�s FMeal Hame Lam B.& 750,OW 5 30S NIA 121151ID 5 40% 747.638 748,828 BYY We -.-n Tr 0 FMeml Nam.11dergags AsmcWW 1,C6{OW 538% MA 07MVIL 547% 996.640 W5,625 BVY Wc,e-m Tr 0 FM-z ][ome Loa HaNk ],CV],ODD 550% MA OW1Vll 5SD% 1,000,00] 999,(183 BYY Ww,.Tr 0 FMcWI[.me Loa Bale 2,WgOW 550% WfA 07/27111 550% 2,ODD,W] 2,010." BYY Wc ,ra Tr 0 FM.WI[.me la Bank ],NO,OW 550% VIA 0712711[ 35D% 1,WO,W] 1,1115,000 BNY We•,L Tr 0 Fm.rz Home Lan Bfon,agx Corporation ],oD],ODO 5 61% VfA W111112 5 65% 1,SW,CN 1,495,T10 BYY W,•,L Tr 1,491,Bb Fimucrn,Cp-Fortia7(F[CO) nW,OW 930% NIA 0.IVWIH 98DA 498,541 676.875 NWl.Hank 69I,65a 7JU.M, Total lnv�lw G h $ 93.862.620 5 93,831,659 5 i$617,590 Q cn TREASURER'S MONTHLY REPORT [scrimp MISCELLANEOUS AND TRUST ACCOUNTS 812812DD7 JULY 31, 2007 Yield Adjusted Par Value Coupon Haling Maturity to Maturity Cost Basis Category Total Total Invested Cash $ 93.862,620 $ 93,862,620 $ 93,862,620 Miscellaneous Accounts Petry Cash 3,125 NIA NIA open none 3,125 Revolvine Fund-Bank of America 17,696 NIA NIA open none 17,696 Trust&Agency-Bank of America 1,517,960 NIA NIA open none 1,517,960 Downpayment Assistance(Housine Fund) -Washington Mutual 33,545 variable NIA open 0.25% 33,545 Workers Compensation-Bank of America 4,206 NIA NIA open none 4,206 General Liability-Bank of America 25,576 NIA NIA open none 25,576 1,602,107 Deposits Held In Trust Time Deposits (FDIC Insured) Downey 5&L(Cat Cyn Country Club) 67,986 4.93% NIA 2/11/2008 5.01% 67,986 Downey 5&L(Donovan BequesL) 14,393 4.93% NIA 214124108 5.01% 14,393 Downey 5&L(Palmer Cable TV) 5,240 4.97% NIA 1118124108 4.97% 5,240 Guaranty Bank (Coyote Springs Apt) 18,890 4.91% NIA 6/24/2008 5.0051 18,89D 106,509 Total Cash Deposited $ 95,571,236 CCa Cr] TREASURER'S MONTHLY REPORT o-usrep BOND ISSUE RESERVE, DEBT SERVICE &RELATED FUNDS osrzFm7 JULY 31, 2007 Coupoo Yield AdP wd [mcso only) Pror Qir Paz Valoe IL-v Ra l g blamnly m Mamnly Cn•r Basis Czegory Taut Mazkcr%raba S.. Markel Value 19911➢7MLAA Ccmvearirn Cuw AM Govcrnruro]&Ap.y PoafWirare 253,207 variable AAA open 4.888 253,207 25 ,M BNY W'esnm Tr 269,894 AIG luvrslmenl Agrccn:m 1,280,673 53" AAA IDDIM 5.36% 1,28$671 1,280,673 B}ry Urmcm Tr 1,28],673 AIG]nve,imml ABreemvi 1,290,000 6.68% AAA IYOV21 60% I?A7,000 1,290,C00 BUY%Vea nTr 1,2A7,000 iMM Iavn5VM Agree^."" 3,300,902 a58% AAA IIA155 5.585 3,3W,402 3,100,402 BUY W.=Tr 3,303,502 6.124,282 IWIM6 A,rpoa Cash 0 0 0 BNY W. .Tr 0 AL4f Sborz Temr forest Trsy Pnvj 1,165,9(A variable AAA op-n 4.88% 1,165,961 1,165,9M BUY W.w.h 1,4M,152 1,165,9W ]931101 Scrirs B-F3oarag AL Gu,..ri&Au.,Poal PnvaL 352,912 variable AAA nFrn 4.88% 352,9:2 b2,912 BNY W.B.Tr 4,192 AIG lnssmvl Agmewu 468,105 5n% AAA CRll1123 5.229. 4fig,105 468,105 BNY W.w.Tr 4M,105 821,047 I Scnu A&B A l Go.erumem&ASmy Po Mui, 3,26A.521 Hi W AAA N. 4.889, 3,26A,521 3.2W,521 BNY 4Veniem Tr 3,326,343 MBIA Nses Tom+Agrcuncnr 1,651,456 5 17% AAA 09.N1134 5.17R 1.01,456 3,651,456 BNY Wa cm Tr 1.651,454 4,935,977 3596 Mo1L IP Capiul Fm!Gft,Prajccl AIDS Ga•mmmcnl&ASm y Pertf Fm.!c 2363 variable AAA open 4 FRS 2,563 2,563 B1'Y{9euem Tr 1,171,862 AMBAC I vo7 . I Agree M 1,729.699 6A0 o AA G1101f27 6 40S 1,729,689 1,729,699 OW Werem Tr 1,729,689 1,712 252 1998 Anpon GAM AIG Inve<mnm Ap. Rpc,v 561,221 5 70% AAA OVO1l28 5.70% 563,221 561,221 ➢14Y Wwc Tr 563,231 AB.I Govcmmml&AVcq Puar Pnvare 158,344 r.ible AAA open 4.88% 158.344 158,343 ➢NY Wwr .Tr 144,195 719,565 Q Q Q TREASURER'S MONTHLY REPORT vusrcp BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS av2g m 7ULY 31, 2007 Caaynn yield Ad;otd (m:mo u7ly) Pnor Qlr Par Value R.le R-ies Mawnty m Mammy Co•r 11ssis Cacegory T.W mmkx Vamx Sosce M kc[Vale± 1990 Anpou PTC MG lnseslmrot A, -Maw 049,728 5 70',11 AAA O[A)IJ29 5.70% 849,728 849,7m BNY WE,Lz Tr 849.728 AA1 Gorrmm,p&Agmcy No(J a m 241,493 vxdabl• AAA opcn 4 90% 241,493 241,493 BUY W.k.Tr 231.112 1,09L,221 1998 Na14P[e apiw W'�aarer AAf Goremmem&Agmcy ftM Mule 144,655 r.JiaB[e AAA open 4 811% 04,665 304,665 BIW W.W.h 548.613 104,665 L998 Asrusn-=m Dhvia 151 A&B ARf Gorcruanco[&Agem Aorzf Pava[e 3G7,M] sud-.ble AAA o-2a 4.08% 307,96I 3D7,M1 BNYIYcicrn Tr 303,358 301.96E POOL Ass.-s m Ui,wn 157A58 AR.f G�emmen[&Agency Pumf Pfi are L74,666 ra,,,blr AAA ogm 4 88% L79.668 179,E68 MY Wc[ern Tr L76,980 179,65g 2WZ Pukmg 9mcmrc Cash 3 3 1 BNY Wesmm Tr 3 AN Gosemm;m&Agm,Pan(Pneam 15,245 rariabfe AAA oIm. 4.898 35.245 15,245 BUY Wumm Tr 41,433 35.248 2004,Ss•cs..L Dwrit[161 AAf Ga•.cmmeu&Ayrncy Ponf Pride 4LE,188 vadav- AAA open 4888 418.189 418,109 BNY Wamm Tr 411,918 4111,108 2G01 Ass. ,m➢uma 162 Cuh 0 0 0 BW Urnwm Tr 0 AB.1 &Agerey P.r Pdvm: 224.114 s iable AAA cp:n 4.68$ 2J 14 224,1[4 BUY Wwo Tr 277.06 224,114 2005 A•s,,. m Ossmim 1W AM Goverrwcnl&.Agency Nff Pdra¢ 370,ID3 vmaable RAA oN. 489% 370,1W 37a,100 BNY We,mm Tr 56E,873 37DJW T�Is 5 [8,410.5] $ 18,4L0,251 S 20,036,858 Q 0 Q treasrep TREASURER'S MONTHLY REPORT 09/29/07 CALCULATION OF INVESTMENT LIMITATIONS 7ULY 31, 2007 Allowable Percentages By Maturity: Minimum Maximum Current Mo. 1 day to 365 days $8,000,000 NIA $53,503,786 1 year to 3 years 0.00% 50.00% 30.45% 3 years to 5 years 0.00% 30.00% 12.01% over 5 years N/A NIA 0.53% By Type of Investment: Bankers Acceptance - in total NIA 40.00% 0.00% Bankers Acceptance - single bank NIA 20.00% 0.00% Commercial Paper NIA 15.00% 0.00% Certificates of Deposit NIA 30.00% 4.26% Corporate Notes N/A 20.00% 4.23% Money Market Mutual Funds NIA 10.00% 0.00% Mortgage Pass Tbru's NIA 10.00% 9.75% o U.S. Government Agencies NIA 50.00% 42.02% CD U.S. Treasury Notes/Bonds NIA NIA 0.53% Calcularion of Weighted Avg Maturity MaLUM Currcnt No. of Days X Cosr Date Date Days 39,294 39,295 39,294 1 1,092,112 39,295 39,294 1 34,190,000 39,478 39,294 184 182,283,280 39,542 39,294 248 246,286,320 39,600 39,294 306 221,979,762 39,329 39294 35 17,500,000 39,356 39,294 62 31,000,000 39,373 39,794 79 79,000,000 39,471 39,294 177 84,960,000 39,483 39,294 189 189,000,000 39,483 39,294 189 189,000,000 39,646 39,294 352 330,880,000 39,653 39,294 359 33,746,000 39,240 39,294 -54 0 39,367 39,294 73 73,000,000 39,381 39,294 87 43,500,000 39,414 39,294 120 120,000,000 39,444 39,294 150 150,000,000 39,477 39,294 183 91,500,000 39,506 39,294 212 212,000,000 39,548 39.294 254 254,000,000 39,609 39,294 315 315,000,000 39,612 39,294 318 0 39,626 39,294 332 332,000,000 39,652 39,294 358 35$,000,000 39.654 39,294 360 180,000,000 0©Q0�1 Calculation of Weighted Avg Maturity Mature Current No. of Days X Cost Date Date Days 39,263 39,294 -31 0 39,386 39,294 92 45,861,080 3%661 39,294 367 52,471,124 39,692 39,294 398 179,178,191 39,753 39,294 459 225,597,082 39,845 39,294 551 140,793,294 39,873 39,294 579 501,006,592 39,904 39,294 610 144,627,316 39,965 39,294 671 223,046,741 40,057 39,294 763 284,426,310 40,087 39,294 793 241,447,470 40,179 39,294 885 545,297,945 40,210 39,294 916 603,094,959 40,210 39,294 916 406,556,771 40,238 39,294 944 362,184,990 40,299 39,294 1,005 $36,898,022 39,668 39,294 374 374,000,000 39,696 39,294 402 402,000,000 39,748 39,294 454 340,500,000 39,750 39,294 456 456,000,000 39,769 39,294 475 475,000,000 39,849 39,294 555 555,000,000 39,854 39,294 560 560,000,000 39,871 39,294 577 577,000,000 39,918 39,294 624 617,310,720 39,937 39,294 643 643,000,000 40,011 39,294 717 717,000,000 40,093 39,294 799 779,980,604 40,112 39,294 818 915,443,750 40,135 39,294 841 841,000,000 40,142 39,294 848 424,000,000 40,148 39,294 854 854,000,000 40,175 39,294 881 878,445,100 40,231 39,294 937 937,000,000 40,242 39,294 948 948,000,000 40,303 39,294 1,009 997,174,520 40,375 39,294 1,081 2,162,000,000 40,382 39,294 1,088 1,088,000,000 000012 Calculation of Weighted Avg Maturity Mature Current No- of Days X Cost Date Date Days 40,497 39,294 1,203 1,207,992,450 40,558 39,294 1,264 1,246,455,680 40,422 39,294 1,129 511,589,330 40,476 39,294 1,182 661,844,009 40,575 39,294 1,281 635,970.551 40,634 39,294 1,340 552,529,222 40,664 39,294 1,370 162,554,199 40,527 39,294 1,233 921,837,038 40,725 39,294 1,431 1,426,191,840 40,735 39,294 1,441 1,441,000,000 40,751 39,294 1,457 2,914,000,000 40,751 39,294 1,457 1,457,000,000 40,953 39,294 1,659 2,488,500,000 43,196 39,294 3,902 1,945,513,788 42,577,238,160 Total Investments at Cost 93,862,620 WAM in Days 453,61 U©VV�tiD