The URL can be used to link to this page

Home My WebLink About9/5/2012 - STAFF REPORTS - 2.M. P P lM Spf �y V N c n a °novvrt°` c4`1F00%% City Council Staff Report DATE: September 5, 2012 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF JUNE 30, 2012 FROM: Geoffrey S. Kiehl, Director of Finance and Treasurer BY: Department of Finance and Treasury SUMMARY Attached is the Treasurer's Investment Report as of June 30, 2012. The report includes the face value and coupon rate (if applicable) of the investments and the source for the market value estimate. The City's total invested cash is $102,944,239 plus $19,645,251 in bond issue capital projects, reserve and debt service funds. The market value of the invested cash is $103,224,219. RECOMMENDATION: Receive and File Treasurer's Investment Report as of June 30, 2012. STAFF ANALYSIS: The attached 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, debt service and related funds. 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, U.S. Govt. Agency Securities). 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 ITEM NO. Z.M City Council Staff Report September 5, 2012— Page 2 Treasurer's Investment Report as of June 30, 2012 under current market conditions. We recommend that this exception to the policy be continued. The weighted average maturity (WAM) of the portfolio is 93 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 Geoffrey S. kiehl, Director of Finance and Treasurer Attachments: Treasurer's Investment Report 2 treasrep CITY OF PALM SPRINGS 7/24/2012 TREASURER'S MONTHLY REPORT SUMMARY OF INVESTMENTS June 30, 2012 On Call Deposits Adjusted Basis Category Total Percentage Checking Account $ 3,332,356 Heritage Money Market Fund 393 CalTrustShortTerm 42,049,141 CalTrust MidTenn 18,048,756 State Pool 15,000 $ 63,445,645 61.63% Short Term Investments (1 year or less) U.S.Gov't Agencies 34,000,000 34,000,000 33.03% Medium Term Investments (1 year to 3 years) U.S.Gov't Agencies 4,000,000 4,000,000 3.89% Long Tenn Investments (3 year to 5 years) Corporate Notes 1,000,000 U.S.Gov't Agencies 498,594 1,498,594 1.46% $ 102,944,239 100.00% *Some investments made prior to the implementation of the current Investment Policy exceed the 5 year limit 3 uwarw TREASURER'S MONTHLY REPORT 7/2412012 DETAIL OF INVESTMENTS June 30,2012 Coupon Mnurm,or Yield Adjmmd Imemo onp'1 Prior Cr. Par Value Ram Bating Cell Bate to Mama,, Con Bonn Crucial,Total Market Value Source Market Value at Cell Dmorshr Checking-Bank of America 5 N/A N/A AAA open None It 3332356 f 3332,351, Bank of Ammica 2M9.114 Belittle Marc,Mardect Fund N/A .0109 393 393 CvlT,mu 3113 CaITmn ShmlTpme N/A N/A open 0.440% 42.049,141 42,035,147 Conran 36,0381,47 CeITro51 MiJTerm N/A N/A open 1010% I8,048,756 1&033,629 CnITmn 11,982.T14 Leul Aganry mess,Fund!fLAIF) 15.000 vatlable N/A open 035g$ 11 No Is OD, LAW 15.112, 61.G5,45 $hen term C18Im'GMw13 I vwr Or I U.S.OOJI Agenq Serward FMerel Farm Credit Bank 2,000,000 1"'u. N/A 04/I81IE 1 2000,000 2000.IW Bank of NY Mellon 1995,5211 FNeml National Morale Aavairuim I,000.000 235. N/A (9120/12 253% U u Bonk ofNY Mellon LOW IMO Federal Hone Lon.Bank 2,000,000 102% N/A 05/03/12 102% 2,00..0 2,000.IW Bank of NY Mellon 1,"e,441) Fall He.Loon Bank. 1000UUo 12^ N/A 05/07/12 120% I,MONO LOW.120 Bank ofNY Mellor 99I969 Federal H.Lmn Morale Conmmtim 2000.0. 175% N/A 051OW12 115% 0 0 Bonk aFNY Mellen 2.108O Federal Henrc L.Morlgage Copotnticen 1000.OW I%Wa N/A 05N9/12 IXPe 0 11 Bank ofNY Mellon ILO1363 Fdernl Ham Loan Bank 2.00000 125% N/A 05/11/12 1,25e 0 0 Bank of NY Mellon 0 Federal Natiaal Morlgage Asrcimial 2.000,000 145: WA 05tl0/12 145% 0 0 Bank of NY Mellon 201401111 Federal Hero Lan Man,,Capomtion 2000.UW 2.30rr N/A 0W13112 23mOr 0 0 Bank OfNY Mellon 1.001]bo Federal National Morlgage Annaioi0n 1,000000 1.301/. N/A 06/15/12 I30% 0 0 Bank ofNY Mellon 200786n Federal Home Loan Bad, IIIIX101r 131W. WA 07/lVr2 13tYq IOrm'ON I An.N1 BmkofNY Mellon U Fdernl Farm Crdil Bank 2,W0,OW 175% N/A nK115112 175% 2,OOnn00 2010320 Bank of NY Mellon 2,MIX.o4u FMaal To.Credit Bank 2,000,00(1 LHFb N/A OW22/12 151W/ 2,0111,Oo, 2.014t,6uu Bonk of NY Mellon 2,11u9$611 Federal Hams Lau Bank 2,000,000 IOo% NIA 18124/12 100M. 2,WO,WO 2,001875 Nadir of NY Mellon II Federal Famt Credit Bad, 2jmO.OW 1.5M/. NIA umm/12 LMY. 2WON. 2.II111X60 Bank of NY Mallon 21r192110 Federal Hone Lan Bonk 2.000,000 0.50% N/A 09/13/12 0.50% 2,000.000 I,W1,71RO Bald cf NY Mellon 0 Federal Maw Loon Bank 200,000 1150% WA 119/14/12 05(,tk 211W,W0 19111.940 Bud Of NY Mellon u Federal Normal M.,,,,Amo im. IW0000 Ias% N/A 10)17112 165% 1 000 W0 1003940 Bank of NY Mellon 0 Federal National Mortgage Asaaiaion 1.011010 1375% NIA 10/19/12 1375Y 2Wormod 2.0111.900 Bank ofNY Mellon 2000.920 Federal Nmimul Morlgage Aeemoutton 2,000.000 190t% NIA 10124/12 1,7O% 2 O0,OOO 2009.040 Bank Of NY Mellon 2,00,8211 Federal Nolmml Morogo Aaralallon 10u0000 1.5M/. NIA 11/23/12 11^ Lamari0 LOM.141, Bulk of NY Mellon 10116240 Federal National Mal&K Amccutim 1,.O,Ool1 05VL N/A 11/23/12 050% 1,000,ON 999p60 Brink of NY Mellon 11 Federal Neltral]Mutilator Asomeatior 1.000,0.0 0.50% N/A 11/27/12 0.50% 1000.000 LOOO,090 Bonk orNY Mellon o Federal National Mortgage Aoaccuumn I um ON 040% N/A 11/2W12 040% 1000000 1.000430 Bank ofNY Mellon o Federal National Morlgage Association 2.000W0 1$25% NIA 03/28/13 1.125% 2,000 NO 2.0R).940 Bank cfNY Mellon 193,7.0 Federal National Momgega Amoremim I,Od000 25OAr N/A 04/18/13 250% 1.000,000 L015.850 Bonk of NY Mellon 1,1122.11 it Federal Natural Mortgage Anaimia 2,000.000 10^ N/A W/OA13 1001'. 2,000.W0 L9%140 Bank of NY Mellon 0 Federal National Mor,ap Momentum 2,000,000 100% N/A 0107/I3 I110% 2000,. 2 50 7211 Bank of NY Milmn 0 34,000000 treemer TREASURER'S MONTHLY REPORT 9n4n012 DETAIL OF INVESTMENTS June 30,2012 Cougm Maturity or Yield Adjumad (memo omy) Priur Qu Par Value Rate Ruing Cull Date to Maturity Cult Bead Category Trial Markel Vuluu Sou", Market Value Medium Term Invntmenta (1 in a 3 oars) U.S.Guv t Agency Securities Federal Home Wan Mortgage Cm-mmul0n 2,000,000 1,125% NIA 02124A4 I.125% 2.000.000 2,013,140 Bank of NY Mellon 1.986.520 Federal National Mungage Aaociatiot 2,000.000 1.100% NIA 03120114 1.100% 2.000.000 2,011.040 Bank of NY Mellon 2,001,250 4.000,000 Wng Term]motmem 3 ears toy care) U.S.Grv't Agency Securities Financing Corpmailu(FICO) 500.000 9.80% NIA 04106118 9.80% 4%,594 728,051 Bankof America 724.612 Cullman Noma General Electric Capital Corymation 1.000.000 1.20% A11AA+ 04113115 1,20% 110001000 99I,960 Bankot NY Mellon 0 ],498,594 E 102.944.239 S 103,224.219 E 88.864,626 Toal InvntW Caah alndudn the 4rllnwing dumnita mf nomCay funds: Principal Internt Tod] Pa]m Springu Himorical Sociuy 250.000 55,200 305.200 I ul TREASURER'S MONTHLY REPORT treasrep MISCELLANEOUS AND TRUST ACCOUNTS 7/24/2012 June 30, 2012 Yield Adjusted Par Value Coupon Rating Maturity to Maturity Cost Basis Category Total Total Invested Cash S 102,944,239 $ 102,944,239 S 102,944,239 Miscellaneous Accomrts Petty Cash 4,000 N/A N/A open None 4,000 Revolving Fund-Bank ofAmenca 20,000 N/A N/A open None 20,000 Trust&Agency-Bank of America 889,931 N/A N/A open None 889,931 Downpayment Assistance(Housing Fund)-JP Morgan Chase 33,781 0.10% N/A open 0.15% 33,781 Workers Compensation-Bank of America 6,378 N/A N/A open None 6,378 General Liability-Bank of America 28,718 N/A N/A open None 28,719 1930's General Store Museum-Bank of America 4,812 N/A N/A open None 4,812 On-Line Credit Card Fire Inspection Fees 52,291 N/A N/A open None 52,291 -Bank of America On-Line Credit Card Transportation Permits 7,053 N/A N/A open None 7,053 1,046,963 -Bank of America Total Cash Deposited S 103 991,202 TREASURER'S MONTHLY REPORT aeamep BOND ISSUE RESERVE,DEBT SERVICE&RELATED FUNDS 7/24/2012 June 30,2012 Coupon Vold Acjmled (memo ork) Poor"I Par Valm Bad, Rung mmurd, to Mawr., COA Basir Calegon Tool Markel Value Sonra Marker Vo,e 200,1/2012 Connotation Center Im'eom Garmm-mr,&A,.Front, 137 OR variable qAA open U11% 137028 137027 Book of NY Mellon 21,363 Federal Home Loan Morgtgage Corporation 5,4650ku 4.123% N/A 9@7/13 193% 5,869R4g 1,724,150 Parker NY Mellon to 5.9UP 6.U114,92] 1991/Ol Saner B-Hwaing Inwco Guvmmrmd h Attorney P... 421059 marble AM rpm 11,02% 421,039 421019 Book of NY Mellon 38558 Federal Home Loan Bank 4200W 4625% N/A 10/10/12 138% 45MOS 425,184 Bank of NY Mellon 434314 824,2W I9N/M Series A&B Imceco Gormunenl Ar Agewy Private 1.96k443 rumble AM open 0.02% 1.9WA43 1904443 Book of NY Mellon 34,11)L Federal Home Lan Mortgage Colpmallml 965.000 4.125% WA W27113 1,93% 1,036,134 1uM760 Bankof NY Mellen IJ126.90 Federal Home Lmn Mmua,Cmpmamar 5II0181 4.123% N/A 9127,13 193% 613,0I 598079 Bank of NY Mellon 6076" 3,553,668 1998 AtWo PFC lnw¢o Government h Agmcy Private 435994 lariobl, qpA rn,a UOP. 435994 435994 Bank of NY Mellon 612521 U.S.Toom,Note 918,F(m 1373% N/A 3115/13 155% 913374 925,564 Bank of NY Mallon 131,I'll 134'1,369 2001 M,ommenl 8iaviet 1311159 Invpco Governed&Agmg Pr iv are 165408 amirble AAA .,on 0,02% 165409 165408 Bank ol'NY Mell. 167672 1654108 2002 Puking Structure Cmh 3 3 3 Bank of NY Mc11a 3 hawser Govemmem A Attorney Private 2413 vmioble AAA open 001'L 27I3 2213 Bank of NY Mellen 2496 t 216 TREASURER'S MONTHLY REPORT Boorep BOND ISSUE RESERVE,DEBT SERVICE&RELATED FUNDS - 7/2412012 June 30,2012 Coupon Yield Adjusted or...any) Prior Qn Par Value Rne Baling Mmerut, Io Manor, Coal Bssia Camgon To.[ Markel Value Source Markel Vsluc 2004 Anvoasm.l District 161 Imes.Govemmem@A,-e,Private 9113M .,.able AM open 0Q% MI338 MI 23M Bank ofNY Mellon 75]50 Bay Bank Netiwlal Aes.lalian Ohio 108,1100 430% N/A 1210/12 1Kit% 115,105 1KID Bank of NY Mellon 111.422 CIT Wait Salt Lakc CiP,Utah 205 Iran 305% N/A 1119/13 LBAL 211607 20]711] Back of NY Mellen 211921Y 407.911 2004 Aasosmnenl District 162 Ines.Crowmmenl&Agency Privare 69 152 ,.,.able AM crash 001'/. to 152 09.952 Bank of NY Mellon 61A24 Caphel One Bark USA National Association 88,000 4.15% NIA 315/13 LMII% 99846 89966 Book of NY Mellon 91,215 163.292 2.05 Assessm.l Banner 164 I.—,.Gel artisan&Agency Private 10.143 s ariable AAA open 1102% 10g143 104143 Bank of NY Mellon 17342 Citiama Back.File(Michigan 2451g0 I.5% NIA 314113 IPIY. 245347 241000 Bank of NY Mellon 215000 Capital One Bra&USA National Aawciaion 25,000 4.15% N/A 3/5/13 I,g1Yb 26,661 25.559 Bankof NY Mellon 25913 372.151 20ho Airport PFC Invesco Gaa'crnmaal&Agency Private 1,164.984 ."able AAA area OOY. 1,1449M4 1.1IAM4 BankofNY Mellon M42491 US.Tion.,No. 855.000 1325% NIA 3115113 1.55% MP'.2 M621145 BankofNY Indian M62192 2,013,675 211112 Merged Project XI k 02 to,—.Govmlmrnl&Agency Private 0 satiable AAA open 001% 0 0 Bark of NY Mellon 112K517 0 2002 Refunding Lease Ro'rnoe Ranks broar,o Gocernmem&Agency Private 4 ....able AAA ail. 0111% 4 4 Bark of NY Mellon I 4 2008 Airypt PFC Refunding Insilco Government&Agency Private I3U7 .riable AAA ry1rn 11112% 12.432 R432 Bank of NY Mellon 12432 Federal Home Lwn Mortgage Corpamim 603 U1M1 4.125L N/A 9127/13 1.93% M74511 Or 594 Bark ofN,Mellon W1,719 659A87 Resew.for 2012 DmvnGive Revilai,shas L sc Rcvcn.Board Caah 3204,343 variable AAA open 001% 3,204.343 3214 343 Bank of NY Mellon 1 3,204343 Folds with C.mry Golf 890,393 M20,593 970,593 Century Golf 986.416 8]0 593 To.[. S 19,.5,251 5 19425X38 S 5I4,X99,994 00 TREASURER'S MONTHLY REPORT CALCULATION OF INVESTMENT LIMITATIONS June 30, 2012 treasrep 07/24/12 Allowable Percentages By Maturity: Minimum Maximum Current Mo. 1 day to 365 days $8,000,000 N/A $97,445,645 1 year to 3 years 0.00% 50.00% 3.89% 3 years to 5 years 0.00% 30.00% 0.97% over 5 years N/A N/A 0.48% By Type of Investment: Bankers Acceptance - in total N/A 40.00% 0.00% Bankers Acceptance- single bank N/A 20.00% 0.00% Commercial Paper N/A 15.00% 0.00% Certificates of Deposit N/A 30.00% 0.00% Corporate Notes N/A 20.00% 0.97% Money Market Mutual Funds N/A 10.00% 0.00% Mortgage Pass Thrus N/A 10.00% 0.00% U.S. Government Agencies N/A 60.00% 37.40% U.S. Treasury Notes/Bonds N/A N/A 0.00% to Calculation of Weighted Avg Maturity Mature Current No.of Days X Cost Date Dale Days 41,060 41,061 41,060 1 3,332,356 41,061 41,060 1 393 41,061 41,060 1 42,049,141 41MI 41,060 1 18.048,756 41,061 41,060 1 15,000 41,017 41,060 43 -86,000,000 41,019 41,060 41 0 41,032 41,060 -28 -56,000,000 41,036 41,060 -24 -24,000,000 41,038 41,060 -22 0 41,039 41,060 -22 0 41,040 41,060 -20 0 41,059 41,060 -1 0 41,073 41,060 13 0 41,075 41,060 15 0 41,102 41,060 42 42,000,000 41,136 41,060 76 152,000,000 41,143 41,060 83 166,000,000 41,145 41,060 85 170,000,000 41,158 41,060 98 196,000,000 41,165 41,060 105 210,000,000 41,166 41,060 106 212,000,000 41,199 41,060 139 139,000,000 41,201 41,060 141 292,000,000 41,206 41,060 146 292,000,000 41236 41,060 176 176,000,000 41,236 41,060 176 176,000,000 41,240 41,060 180 180,000,000 41,241 41,060 181 181,000,000 41,361 41,060 301 602,000,000 41,382 41,060 322 322,000,000 41,431 41,060 371 742,000,000 41,432 41,060 372 744,000,000 41,694 41,060 634 1,268,000,000 41,718 41,060 658 1,316,000,000 43,196 41,060 2,136 1,064,996,784 42,124 41,060 1,064 1,064,000,000 Total at Cost 9,594,442,429 WAM m Days 102,944,239 93.20 10 QpLM S.o ;oF 4� Z c V N ~�fIOYAiEV e10 'Cg11FORt' City Council Staff Report DATE: September 5, 2012 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF JULY 31, 2012 FROM: Geoffrey S. Kiehl, Director of Finance and Treasurer BY: Department of Finance and Treasury SUMMARY Attached is the Treasurer's Investment Report as of July 31, 2012. The report includes the face value and coupon rate (if applicable) of the investments and the source for the market value estimate. The City's total invested cash is $101,434,547 plus $18,555,404 in bond issue capital projects, reserve and debt service funds. The market value of the invested cash is $103,719,718. RECOMMENDATION: Receive and File Treasurer's Investment Report as of July 31, 2012. STAFF ANALYSIS: The attached 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, debt service and related funds. 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, U.S. Govt. Agency Securities). 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 11 City Council Staff Report September 5, 2012 — Page 2 Treasurer's Investment Report as of July 31, 2012 under current market conditions. We recommend that this exception to the policy be continued. The weighted average maturity (WAM) of the portfolio is 107.58 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 Geoffrey S.Riehl, Director of Finance and Treasurer Attachments: Treasurer's Investment Report 12 treasrep CITY OF PALM SPRINGS 8/27/2012 TREASURER'S MONTHLY REPORT SUMMARY OF INVESTMENTS July 31, 2012 On Call Deposits Adjusted Basis Category Total Percentage Checking Account $ 3,710,020 Heritage Money Market Fund 393 CalTrust ShortTerm 40,068,455 CalTrust MidTerm 18,063,735 State Pool 15,000 $ 61,857,603 60.98% Short Term Investments (1 year or less) U.S.Gov't Agencies 33,079,750 33,079,750 32.61% Medium Term Investments (1 year to 3 years) Corporate Notes 1,000,000 Time Deposits 200,000 U.S.Govt Agencies 4,000,000 5,200,000 5.13% Long Term Investments (3 year to 5 years) Time Deposits 798,600 U.S.Gov't Agencies 498,594 1,297,194 1.28% $ 101,434,547 100.00% *Some investments made prior to the implementation of the current Investment Policy exceed the 5 year limit 13 "morp TREASURER'S MONTHLY REPORT 0./27n012 DETAIL OF INVESTMENTS July 31,2012 Conpan Mamrirtw Yield Aa{ualm NON-119 Pnar,Ql,. Par Value Rate Rmin6 Call Onm IO Motera, Cost Basis Category Tolnl Market Value Source Make,Vabm (,Gallo oaiu Cbaekin8'Bank of Antrat s N/A N/A AAA open Nonn $ 191 U.@0 6 3710ON Bank of Ainerlea 3332I56 Hedlage Matte,Market Fund N/A .010% 343 393 CalTtwt 3,3 Offma,SbwtTam' N/A N/A No. .390% 1406Xdp5 12.103f2l Cut1 42fg394] ceffLarall stm,[ram N/A N/A open 0363% IN.1163/2.15 IX.f115 it. Cvl'fmst 10.103.620 Loral Agency[meet Pnntl(LAIP) ISJIIIII amiable N/A open 0363%. I5.111111 IS,OIX LAIF IS.nIX 61 MS]6V3 Short Term lmxmmetas (I v,m or leas) US Gw11 Agrney Somnlirs Federal Farm Credit Bank I'm O 11 1119'/. N/.9 04/1&12 109Ye 11 0 Bonk of NY Mellon 311011.1(10 Federal Home Loan Bank, 2,t100.0Un ID2% NIA (15103/12 1.112% U 0 Bank ofNY Mallon 2.0110,10 Federal Home Loon Bank 1000.001, 1211% NA 05/07/12 120% 0 o Bank mNY Mellon 111111),IN Federal Hame Loan Bank 1jN.M 13Ui, N/A 07/I2/12 13Oi. 0 0 Bank ofNY Mellon IIW02411 Federal Farm Credb NA 2,WQ000 171% N/A 0.115112 175% 2.000,0110 2,0010611 Bank of NY Mellon 2,011912(l Foetal Farm Credit Ben: 2.I)SYSA, 1 U% N/A 118/22/12 1.50% 2000.0ll 200L4911 Bonk ofNY Mellon 2,110y.6nn Federal Home Lean Bed, 2000000 1OUN, N/A 1OV24/12 ILO% 2,000,110Il 2,000,960 Bank of NY Mellon 2001X95 Federal Farm Coal Bwlk 2,000L00 1111% N/A 119/O6/12 ISO% 2,000 ON 2.0112,SAO Bank dNY Mellon 2N4.611 Pder.1 Horne Lwn Batik ]N).000 0 51M6 N/A 0113112 o Sr% 2.000.0011 2.oW 441) Bank of NY Mellon Loao,714. Focal Horne Loom Bank 2,000,00 050%. N/A 09/14/12 050% 2000.000 2.000440 Bank of NY Mellon 1910.X41) Federal Natlovl Mwlgirp AsaOcimion 1,000.000 1,65% N/A I0/19/12 165% 1O00000 1002,940 BankofNY Mellon LOIR110 Federal Natural Marlgage Aasaimmn 2000.00n 1.375% N/1 lo/19/12 I375% 20000011 20WS20 Bunkof NY Mellon 2WS.700 Federal National Mwlguge Moreialion 2,OWWO 1]M/. N/A IN24112 1 7IPM1 2.000,001, 20no,120 Bank Of NY Mellon 2008 IH(l Federal No,.-[Mean"As...lon 1,000,000 1.50% N/A II/23f@ Soto 1.000.11011 I0I13.490 Bank of NY Mellon I004.1AO Federal Normal Marlgage Armoilaon 1000,000 050% N/A 11/23/12 050% 1.000,00U 1,000.180 Bank of NY M,11m, '119,660 Federal Natlarel Mortgage Aa m. LOOSON 0.50% N/A 11/27/12 05.% 100.mill IOW 6. Bank of NY Mellon I Alto,o911 Federal National Mount Asrwlmion IBn0000 040% N/A 11/2WU 1140% 1,000,01I1, 1,01011.5110 Bank of NY Mellon Lrall410 Federal National MO,.,Anealemer 2.000,000 1.125% N/A 0/28/13 1.125% 2000001) 2,011,620 Bank of NY Mallon 2 001)940 PWeral Nutinnm Momgago Amoeiallon LWI1.NO 2.50% N/A (4/18/U 250% 1,00t),1100 I1'14 SO' Bank of NY Millon E11I5,850 Federal Normand Mmt,r,Aasaia. E,000ON 100% N/.4 M106113 In1Y. 20000no 2O45X0 Bank of NY Mellon I!C15J40 Federal National M.,,Aawnmicn 2,000.0N1 1,110% N/A 06/07/13 I,IIC. 2,000.111111 2.I111R41m Bank of NY Milo 2005720 Federal Home Loon MO,t,o,Coryomtinn 5,000,000 200% N/A 07AST13 2.00% 5,UT9,9511 5,074,OSO Bank of NY Mellon 0 33L24.950 I"d 1� nasr<p TREASURER'S MONTHLY REPORT an/22/2012 DETAIL OF INVESTMENTS July 31,2012 Conoco means,of YIAd Mrvsmd (nemo..it,) pnnr Qu. Par VOW, Raw Raul, Cell Dale to Mamriry Cost Be- Coup,Total Market Value 5nntce make,Value MWium Term lnveemenu (I verso J.eevl CoI Naa General Elteve,Coplml Carporelien 1000.0110 120% AI/AM N113/I5 120Y. 1004WII SaN 71a Bank ofNY Mellon 4VI?LO 1 U1111,LIla Tim,Depail, Ally Bank CD 200,01111 1.11% N/A 7127115 115% 200.0Un Mot 01111 11 U.S.Get l A,.,Securities 2f111,a110 Federal Hume Loon MorlgoV Corporation 2000000 113% N/A 02/24/14 1.125% 2,00001, 2019500 Bank.(NY Mellon 21111.I10 Rawest Naliorel Wife,Association 3000000 I ONi NIA 03120/14 11 DV/. 20og0Ua 2,1112211, Bank ofNY Mellon 31111!It 4,00g000 IgnB Term lm'afinent J veers l01 xaeal Time Depmils GE C,Remil Bank CD 200,000 135% N/A 7)20/16 1.35% 200.000 20'", U GE Cap Bank CD 210_000 1,35% N/A 7120/16 135% 200MI 2115,S99 0 GOldmsn SacFU Bank CD 200,000 1,50% N/A 7/25/19 1SM 198,600 21011111 a Dissever Real,CD 20U,001I 1,90% N/A 7126117 170% 200000 NO(It 7 U NXtW U.5 Ga,%Awncy Seeautin Cases.,Coepyelion(FICOI 500011) 1X0% N/A (4/06/IS Y50% 498,594 721914 Bonk of Amenea 72R(D1 495594 S Tout Invented CIA 101434.347 5 10171//118 5' I'll 221211) 'includes lM follso in&depots ofion-City funds. Pri1¢ipal Intend, Total Pal.Spnngs Hinmicel S,a,,w 250000 55409 305,409 TREASURER'S MONTHLY REPORT treasrep MISCELLANEOUS AND TRUST ACCOUNTS 08/272012 July 31, 2012 Yield Adjusted Par Value Coupon Rating Maturity to Maturity Cost Basis Category Total Total Invested Cash $ 101,434,547 $ 101,434,547 $ 101 434,547 Miscellaneous Accounts Petty Cash 4,000 N/A N/A open None 4,000 Revolving Fund-Bank of America 20,000 N/A N/A open None 20,000 Trust&Agency-Bank of America 899,722 N/A N/A open None 899.722 Dovmpayment Assistance(Housing Fund)-JP Morgan Chase 33,784 0.10% N/A open 0_I5% 33,784 Workers Compensation-Bank of America 11,231 N/A N/A open None 11,231 General Liability-Bank of America 30,000 N/A N/A open None 30,000 1930's General Store Museum-Bank of America 4,812 N/A N/A open None 4,812 On-Line Credit Card Fire Inspection Fees 61,663 N/A N/A open None 61,663 -Bank of America On-Line Credit Card Transportation Permits 7,555 N/A N/A open None 7,555 1072,767 -Bank of America Total Cash Deposited S 102,507,314 TREASURER'S MONTHLY REPORT nem.ep BOND ISSUE RESERVE,DEBT SERVICE&RELATED FUNDS m8/2712012 July 31,2012 Conpon Yleld Adinam (memo onk) Pnor Qla Par Value Rare Bonn, Mourn, Io Mollin, Con Part, Ca¢gort Tool Minor VnL¢ Swore Mickel Value 20M/2012 Convocation Cenru Inruco 0ownunonl&A,—Pnvam D7D80 'arable AM open 0019. 137 on't 13),1199 Bank of NY Mellon 13I,o)] Federal Home Lnn Magterip CO1miximen 1.465,000 4.125% N/A 9/22/I3 193% 5S61.848 1710.9211 Bank of NY Mellon 5.J24.130 6 INIJ Y29 1991/ol Set-B-Hwa., Innsw He—...nl&Agency Priwle 421.066 'unable AAA opn 0I2% 421PLfi 421,06, Bank of NY Mellon J21,IR9 FMcrnl Home Latin BMA 420,000 L625% N/A 10/1(1/12 1 I8%. 433,205 423641 Bank of NY Mellon 4251a, 874.771 1994/04 Series A&B Imxaco Goarmnem&A,l Pri'au 19W674 variable AM o,o 002% 1901474 1Y04,474 Bank of NY Mellon 1?a4441 FNmtl Home Lnn Malting Corpcummir 965 000 4.123% N/A 9/29/13 1113: 1036.134 I MR435 Bank oFNY Mill. 10111,9611 Pedernl Ham,Loin Mail,.,Unification 591.0110 4,125% N/A 9k7/13 IVTP. 613101 596901 Bmd:of Nt'Milln 598 11]] 3,553,G9) 1 Wit Auprr PFC Imaeco Goannnul&Ayalcy Prime 264.387 variable AAA op,n 002% 2643nG 264389 Home of NY Mellon 435.944 US.Tormry Nate 918,000 1.375% N/A 3115113 1.55% 913 174 924848 Bank of NY Mellon 92551A I.IA]62 2001 uncoment District 157/158 Imreseo Govxnumenl&Agency Prn'are t65,411 'ratable AM open 0nZ% 165,411 165,411 Bank of NY Mellon 11".mom 165.411 2002 ProUnS Structure Ca[F 3 3 3 Bank of Nl Mellon Io,cxco Goo comment&Agency Prix am, 217634 'mmble AM open it of% 217634 217,634 Bank of NY Mellon 2]13 217637 mearrep TREASURER'S MONTHLY REPORT 0.127/2012 DETAIL OF INVESTMENTS July 31,2012 Coupon MBmrlry or Yiold Adjusted (memo only) Prior QIr Pa Value Row Rating Call Dam Io Marine, Coo,Be- Comgon Towl Mark,,Valao Source i Vah¢ 20M Ao—r ml Nor me1161 Inverco Goeemmenl&Agmq Psivelo 84.337 lariable AAA open 002% 84357 84357 Bank of NY Mallon 81.238 Key Bank Normal Assocroion.Oblo 111 43UM, N/A 12/20/12 1811% 113,In, 1119.584 Bank of NY Mellon Ino wal CIT Bank,Salt Lake City,Utah 205000 305% NA II28I13 IXT. 211402 207445 Bank of NY Mellon 2077P2 411,071) 2004 Assessment Dintic1162 In—Govermnaat&Agrncv Private 69953 variable AAA .,on 1101% 69959 6'1"1 Bank of Nl'Mellon 64912 Capital One Bank USA National Anwiation 91 415% N/A 315/13 190"' 93,846 N9.959 Bank of NY Mellon tl9ve6 163.298 2005 Aareaemenl Dinrid 11.4 Imesw(ka, &A,.Private 100512 unable AAA open 11 U2% IOU 117 100,117 Bonk ofNY Minion 11m.H3 Citlmm Ben,plan,Michigan 245.1100 195% N)A 3/4113 11 245349 24111011 Bnnkof NY Mellon 24111110 Capital One Bunk USA National Asixalion 2501111 4.15% N/A 3/5/13 11 26,661 25.IOU Baok of NY Mellon 2111-1 yn 525 20aer Siefert Pi frow.CrovttOmem&Agency Privalo 198.891 variable AAA On 002Y 118.891 119811 Bank of NY Mellon 1164984 U S.Treasury Now 855,1 1305% N/A 115113 151% YOU 1.92 861378 Bank of NY Mellon 8621H5 1114A582 20117 Mni Projccl kl&12 lnvnoo GavcnuneoI&Awry Privalo 0 vonnble AAA oPon U,UI% 0 n Bank of NY Mellon 0 2007 Refunding Lone Romue Balls 11 lorewo Govemmenl&Away Private 4 ♦oritble AAA open OW% 4 4 Bank of NY Mellon 4 4 2009 Arr on PFC Refunding Invawo Gommnenl&Agency Prier. 12417 oroblo AAA open 002% 12.417 12,419 Balk of NY Mallon 12439 Fedi Bome Loan Mor,r,Capamiwl 603.000 4.125% N/A 9/22/I3 193% 6-2450 111.141 Bank of NY Mellon I'll 65'>,W Rears for 2012 Dmmloon Sinai Lcaw Rosoae Bond Cash 3,1802111 vanrble AAA open 3,11O&NU 3.188111, Bank wNY Mellon 1304143 3.1882tt) Funds WiJI C..GOP 716.121 216.121 716A21 Cenmrt Golf 8tLL593 ]IL.121 Torok S IP 511AW S Is 313955 S M9.425.818 TREASURER'S MONTHLY REPORT CALCULATION OF INVESTMENT LIMITATIONS July 31, 2012 treasrep 08/27/12 Allowable Percentages By Maturity: Minimum Maximum Current Mo. 1 day to 365 days $8,000,000 N/A $94,937,353 1 year to 3 years 0.00% 50.00% 5.13% 3 years to 5 years 0.00% 30.00% 5.91% over 5 years N/A N/A 0.49% By Type of Investment: Bankers Acceptance- in total N/A 40.00% 0.00% Bankers Acceptance- single bank N/A 20.00% 0.00% Commercial Paper N/A 15.00% 0.00% Time Deposits N/A 30.00% 0.98% Corporate Notes N/A 20.00% 0.99% Money Market Mutual Funds N/A 10.00% 0.00% Mortgage Pass Thrus N/A 10.00% 0.00% U.S. Government Agencies N/A 60.00% 37.05% U.S. Treasury Notes/Bonds N/A N/A 0.00% tb Calculation of Weighted Avg Maturity Mature Covent No.of Days X Cost Date Date Days 41,121 41.122 41,121 1 3,710,020 41,122 41,121 1 393 41,122 41,121 1 40,068.455 41,122 41.121 1 18,M3,735 41,122 41,121 1 15.000 41,017 41,121 -104 0 41,032 41,121 -89 0 41,036 41,121 -95 0 41,102 41.121 -19 0 41.136 41,121 15 30,000.000 41,143 41,121 22 4g000,000 41,145 41,121 24 48,000.000 41,159 41,121 37 74,000,000 41,165 41,121 44 88,000,000 41,166 41.121 45 90,000.000 41,199 41,121 78 78,000,000 41,201 41,121 80 160,000,000 41,206 41,121 85 170,000,000 41,236 41,121 115 115,000,000 41236 41,121 115 115,000,000 41,240 41,121 119 119,000,000 41,241 41.121 120 120,000.000 41,361 41,121 240 480,000,000 41,382 41,121 261 261,000,000 41,431 41,121 310 620,000,000 41,432 41,121 311 622,000,0W 41,462 41,121 341 1,732,194,750 42,107 41,121 986 986,000,000 42,212 41,121 1,W1 218,200,000 41,694 41,121 573 1,146,OW,000 41,718 41,121 597 1,194,000,000 42,571 41,121 1,450 290,000,000 42,571 41,121 1,450 290,000,000 42,941 41,121 1,820 361,452,000 42,942 41,121 1,921 364100,000 43,196 41,121 2,075 1,034,582,550 Total lnvmInents at Cost 10,912,486,903 WAM in Days 101,434,547 107.58 20