Loading...
HomeMy WebLinkAbout1/7/2015 - STAFF REPORTS - 2.H. PALM g A p4� Z c V N ,r AOq/StO x C441FORO City Council Staff Report DATE: January 7, 2015 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF NOVEMBER 30, 2014 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 November 30, 2014. 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 $106,302,109 plus $14,598,746 bond issue capital projects, reserve and debt service funds. There is an additional $1,212,348 in various miscellaneous/trust accounts. The market value of the invested cash is $106,385,685. RECOMMENDATION: Receive and File Treasurer's Investment Report as of November 30, 2014. 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. ITEM NO.-� City Council Staff Report January 7, 2015— Page 2 Treasurer's Investment Report as of November 30, 2014 The weighted average maturity (WAM) of the portfolio is 503.55 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 02 CITY OF PALM SPRINGS TREASURER'S MONTHLY REPORT SUMMARY OF INVESTMENTS November 30, 2014 On Call Deposits Adjusted Basis Category Total Percenta¢e Checking Account $ 6,609,196 CalTrust ShortTerm 13,277,779 CalTrust MidTerm 12,886,188 State Pool 27,040,751 $ 59,813,915 56.27% Short Term Investments (1 year or less) U.S.Gov't Agencies 41,991,000 Corporate Notes 1,000,000 Time Deposits 200,000 43,191,000 40.63% Medium Term Investments (1 year to 3 ears) Time Deposits 798,600 798,600 0.75% Long Term Investments (3 yearto 5 ears) U.S.Gov't Agencies 2,498,594 2,498,594 2.35% $ 106,302,109 100.00% treasrep 12/22/2014 O W TREASURER'S MONTHLY REPORT DETAIL OF INVESTMENTS November 30,2014 Par Coupal PurcMu M.I.o. R,S,`Ncxt OPO..I b;s Yield AEj.St Categm Imam.nahI Prior Ole Y11YG ELf B@SLng .- D& Cali Date So Maturio. IO Mang. SbSLg.aa. TTjUgI Mint V.ly{ Rea Mark,(Wo Un Cell De Its Citecdn8-Bank of America I 66091% N/A AAA dnm,nd N/A 1 None 660_1 W. 5 Lfi0219fi B.M.fAmnnca v,tl51.311 Carron SM1wffelm 13(OP.SO. aan.ble N/A demand NIA I 012% 13Y2JJT) 11,284.5Il CalTmst I'.215.157 Caffwl MWTerm 121... .1,10 N/A Cemand N/A 1 095% 1288nJ. 121190.107 ('a1Tms 12 S28%Si Loral All,tram Fwtl(LAIFI 21'OIIOOW amble N/A Crn.nd N/A 1 112n1% 29,W0.751 27,IW5el,13 LAIF 2103237. f4t0$1l6 511.kl$915 59SOMO W7 62992,I17 SMn Term lmeumma (I © mlmsl U.S.CovY Agefep'Sawilies Felkral Home Loan Bark 0 200% N/A 0808/14 09,WN 0 2U0'/. II 11 Bank of NY Mellon 2.1.U,3411 Federal Bom<Loan Malgage,Cwpwmnn 0 2.1%. N/A 07/24114 U744/1, 0 201CL 0 U Dank ofNY Mellon 2.W2,4MI1 F[Mal H.Loan Eud 0 185"/. N/A 01/30I14 Olaw19 a Ik5% 0 0 BOM of NY Mellon 19?6680 Feduel H.Lon.MM,,Corporation U 2.03% N/A BY'l 4 OW'2Nq'1 U 2.U5% U 0 Dark of NY Mellon `W8.1%n Fedanl Hone lean Bank I,0001,00 1145% N/A OS/19/13 05101111 MOU14 526 045% LIKKI,IIW SIMI Bank ol'NY Mellon 990.19U F,daal Farm CrNil Park 1 OfN1,OW 0.95% N/A 08,15112 0V0117 IVOI114 809 035% 999,np1 IW.NIJ Bank of NY Mellon 998.125 Pfdenl Form CoAn Book ZOW)w 0SSI% N/A O8/11/12 OM15117 IVOU14 .1 O'SeA I99'1,000 1.1117,060 Ban efNY Mellon I992.%O Fetleral Home L .Bank 2000,. 1.1. NIA 09/I8112 09/IR'I2 12/o1/14 IU23 IUD°/. 1!M,OW IMN.,%O an&efNY Mc11m 1!1911211 Fedcnl F.-Crdil Bank 1000.000 1.12% N/A 0212NI3 OVDS18 12/01/N 1.178 112% 2000.OW 21MX1120 Bank efNY Mellon 1R21I Federal Home Loan Bank 20uOUM1 20P. N/A Oad1,1. .411'119 IL01/H 1_e92 2e7% 2W011.1 2,1.11.211U BEM of NY Mellon 19e6.1211 Pe4nI H.ICnn Bark, LOpglBp O75% MA 05/21/13 US/29/18 11OU14 1276 1175% LIwgUOe .7813 Bank cf NY Mellon 992.1,11, Federal Hanel nBank 1,IIU0., 11B . N/A OVIV13 ON12,N I11I2/14 1,29n 0tl1rv. If10U.1100 PN.450 Bank.NY Mellon 991Sm Fcdaal Hon,loan M.,,Cgpomlron 2000,OW LW% N/A 16120112 09/20/19 I12W14 1,025 100% 2000,IIW 2,Ole060 Bank MNY Mellon Imm.Mel Fehral Home Lon Mortgage Capormnn 2,000,OOO 1.20°. N/A 0121VI3 03/2NI. IV20,14 I30f, 120% 20.0"1. IwI8.720 Bank of NY Mellon 1!N2n%n Federal H.Linn BWc 200pMn IW% N/A ./20113 06120118 1120I4 I218 1.0% 19,1.B. 111)6480 Bank.1 NY Mellon I ISO,980 Federal Hare Loan Men,,Corporation 2.110W , LWX N/A (612I/12 09/rIll IY27II4 1,032 104% 1000.00, IV)68M Bank ofNY Mellon 19H_1411 Fudval Nalbrel Mm8a8e M,,alim L(k)(000 107% N/A 01,271[2 O9/2]11] I2122I14 L032 Her/. 2OKION, I!YN Sold Bank of NY Mellon 1,1..660 FN,nl Hone tan MmlBage Ca....Son 1.000W0 100% N/A 01/11/I3 01/11/18 01111,15 1138 100% IOw1,OW 995.SBO Bank of NY Mellon IM720 Federal Hem,Iran Bank 2,000,NO ISO% N/A O7;IS/14 VIINI9 OU15/15 1,68% 20WP 2WO(Sg1 1111140l BankofNY Molina IW,1211 PeMml Han,loan Mmgg Copoml6n 2W0,000 105% N/A OPINI3 01/IWI% OPIW15 LI43 105% 1.000.OW I1Y)N960 Bank of NY Mellon I1keie0 Federal Honef .Mo,11,Cwponlun 2W(k. 1.0% N/A 04/25/13 OJ251IB 01I2VPS 1142 113% 2.000.000 1e0l 660 Bank of NV Mellon 1175,WO Fcd,nl National Mmpp AsmaOan 4.00k,000 103% MA ONNY0 Ilirlill% 0WOW L157 103% 4011111)(1 3,976920 Bank NNY Mellon 3.14O.1180 Fednal Done Loan Bank 1,000000 1,00% N/A 01/3o1I3 OIO1418 0100/15 1.157 InOft I...B. 114211 Bank oI NY Mellon 988110 Federal R.Loan Blink IWOM%1 105% N/A O21IL13 OL12/18 02112/15 1190 1.5% 1.0011OW 995,130 Bank of NY Mellon 9. k1l Petl,ml lrounal Mmipp Mieckukon 2000,0W 10% WA 01,211[3 05/11,19 II121/15 1268 103% 2WgUW 1992,1SO] BankofNY Mdlon 1I.B41I Federal Notnnal Maley M-Um 1.000,U0, L.% N/A OA28/12 OW2%119 OW."S 1.2 1 OS,. "am 998,390 Bank of NY Mellon 992020 Federal Nnlbnal Maepp Meocation 2.000.O00 L10% WA W/VVI2 08128117 11L28/15 LW2 I1W. IOSHI ODO 20112400 Bank a NY Mellon 1.994.820 F,d,nl Bolunal Mor",Ass ... 2,0000W 21W% N/A IW3W14 I14OUl19 14130,15 1M2 21,,% 20OOOSM 2,UI LOGO Bank a NY Mellon 2Ol.180 - 421100Mp 41.991 U1111 41,e26.911 48,6k).145 Corporal,Noun Gmeul Ekc¢ic Capital Corpanicn 000. O.]%AI/M. fed 13112 04/13/IS N/A IN 073% IIM0.0W IOOI670 Bank of NY Mellon 1.0,7'80 1.000,00 1000000 I OU1.690 1 02_380 Tien Depalla AII,Duke CD 211DAIb LIS% N/A 729/12 I27,115 N/A 21, 115% 2ngOW 200.000 BeMof NY Mal- 211,nW No.non 210,001, 2110,00ro 21k.,O. novinep 1m��ou lA TREASURER'S MONTHLY REPORT DETAIL OF INVESTMENTS November 30,2014 Par Coupon Purchase maturity TirsteNvxt Optional Days Yield Adjusted Care, , (menu only) Pnor Otr Value lisle Rsline L1014 Dart Call 19�1y tom Cost Bass Tidal Market Volne Smnpe MarkH Value MMium Term Inveshnents I year to 3 yaana) Time Deposits GE Cap Retail Bank CD 200,000 1.35% N/A 7120/12 72o/I6 N/A 598 135% 200,000 202,"0 Bank cf NY Mellon 202,158 GE Cap Bank CD 200,000 1.35% N/A 7/20/¢ 7120116 N/A 598 1.35% 200.000 202,460 Bank of NY Mellon 202,158 Goldman Sachs Bank CD 200,000 1.Sn% N/A W25/12 7125,1117 NIA 969 1.80% 198,600 20g435 Bank of NY Mellon 203.235 Discover Bank CD 200,000 1]0% N/A 7/26112 7/26117 N/A 969 170% 200,000 203,908 Bank of NY Mellon 202,678 800000 793600 913,261 910,229 Lon,Tenn Investment (3 years ro 5 veers) U.S.Oovt Agency Securities Federal National Men,.,,Associullan 2,000000 110% N/A 03/12/13 03/12,118 03/12/18 1.199 110% 2,000.OD0 1993,260 Bankef NYMellon 1972,480 Finandn,Corybmalon(FICO) 500,o00 9.80. N/A 04/06/89 04106,18 N/A 1.223 980% 493,594 640.674 Bankor Amenca 641178 2,500,000 2,498 594 2,631,1134 :614,619 Toad Invested Cash S 105,409,196 S 106.302.109 E 106,195.685 S 116.309,149 usrcy M2212014 4= Vs TREASURER'S MONTHLY REPORT MISCELLANEOUS AND TRUST ACCOUNTS November 30, 2014 Yield Adjusted Par Value Coupon Rating Maturity to Maturity Cost Basis Category Total Total Invested Cash $ 106,302,109 $ 106,302,109 $ 106,302,109 Miscellaneous Accounts Petty Cash 3,950 N/A N/A open None 3,950 Trust&Agency-Bank of America 1,047,090 N/A N/A open None 1,047,090 Downpayment Assistance(Housing 33,865 0.15% N/A open 0.15% 33,865 Fund)-Bank of America Workers Compensation-Bank of America 35,502 N/A N/A open None 35,502 General Liability-Bank of America 30,000 N/A N/A open None 30,000 1930's General Store Museum-Bank of America 10,797 N/A N/A open None 10,797 On-Line Credit Card Fire Inspection Fees 47,933 N/A N/A open None 47,933 -Bank of America On-Line Credit Card Transportation Permits 3,212 N/A N/A open None 3,212 1,212,348 -Bank of America Total Cash Deposited $ 107,514,457 treasrep 12/22/2014 O C7 TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS November 30, 2014 Par Coupon Yield Adjusted Category (memo only) Prior Qtr. value Rate Ram Maturity to MatureCost Basis Total Markel Value Source Market Value 2012/2014 Convention Center First American Government Obligation 199 variable AAA open 0,01% 199 199 US Bank 14,182 199 1991/01.Series B-Housing Invesco Government&Agency Private 9 variable AAA open 0,02% 9 9 Bank of NY Mellon 9 9 2004A/B,Merged Project n I/92 Invesco Government&Agency Private 113 variable AAA open 0.01% 113 113 BankofNYMellon 303 113 2007A,B,&C Tax Allocation Bonds Invesco Government&Agency Private 10 variable AAA open 0,01% 10 10 Bank of NY Mellon 10 10 1998 Airport PFC Invesco Government&Agency Private 2,309,565 variable AAA open 0.01°ro 2,308,565 2,308,565 Bank o}'NY'Mellon 1,197,746 2,308,565 2002 Parking Structure Cash 3 3 3 Bank of NY Mellon 3 Invesco Government&Agency Private 172 variable AAA open 0 01% 172 172 Bank of NY Mellon 1520 175 2004 Assessment District 161 GE Capital Bank CD 200,000 1 70% N/A 01 17/2019 1.70% 200,000 201,020 Bank of NY Mellon 200,458 Goldman Sachs Bank CD 100,000 1.90% N/A 01/22i2019 190% 100,000 101,810 Bank of NY Mellon 100,589 Invesco Government&Agency Private 97,398 variable AAA open 0 02% 97,398 97.398 Bank of NY Mellon 97,397 397,398 2004 Assessment District 162 Goldman Sachs Bank CD 90,000 190% N/A 01/21/2019 1.90% 90,000 91629 Bank ofNY Mellon 90530 Invesco Government&Agency Private 67,684 variable AAA open 0.02% 67,694 67,684 Bank of NY Mellon 67.683 157,684 treasrep 12222014 0 TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS November 30, 2014 Par Coupon Yield Adjusted Category (memo only) Prior Qtr. Value Rate Ratine Majority to Maturity Cost Basis Total Market Value Source Market Value 2005 Assessment District 164 GE Capital Retail Bank CD 200,000 1.90% N/A 01/17/2019 1.90% 200,000 203,608 Bank of NY Mellon 201,175 Goldman Sachs Bank CD 50,000 1.90% N/A 01/22/2019 1 90% 50,000 50,905 Bank of NY Mellon 50,295 Invesco Government&Agency Private 119,093 variable AAA open 0.02% 119,093 119,093 Bank of NY Mellon 119,091 369,093 2006 Airport PFC Invesco Government&Agency Private 1,515,561 variable AAA open 0.02% 1,515,561 1.515 561 Bank of NY Mellon 1,271,861 1,51 561 2007 Refunding Lease Revenue Bonds Invesco Government&Agency Private 0 variable AAA open 0.01% 0 0 Bank of NY Mellon 296,069 0 2008 Airport PFC Refunding Invesco Government&Agency Private 618,377 variable AAA open 0.02% 619,377 618,377 Bank of NY Mellon 618,377 618,377 2012 Downtown Revitalization Lease Revenue Bond Reserve Invesco Government&Agency Private 4,140,805 variable AAA open 0,01% 4,140,805 4,140,805 Bank of NY Mellon 3,189 774 4,140 805 2014 Merged Project) &2/Housing Refunding First American Government Obligation 4,256 variable AAA open 0 01% 4,256 4,256 US Bank 11615 4,256 Chevron/CoGen Lease Proceeds Cash 4,726,535 40726.535 4,726,535 Deutsche Bank 5,908.164 4,726 535 Funds With Century Golf 359,966 359,966 359,966 Century Golf 371,034 359,966 Totals 14,598,746 14,607,718 $ 13 807,884 treasrep 12/22/2014 O OD TREASURER'S MONTHLY REPORT CALCULATION OF INVESTMENT LIMITATIONS November 30, 2014 By Maturity: Minimum Maximum Current Mo. 1 day to 365 days N/A N/A 96.90% 1 year to 3 years N/A 50.00% 0.75% 3 years to 5 years N/A 30.00% 2.35% By Type of Investment: Bankers Acceptance - in total N/A 20.00% 0.00% Bankers Acceptance - by issuer N/A 5.00% 0.00% Commercial Paper N/A 15.00% 0.00% Time Deposits N/A 10.00% 0.94% Negotiable Certificates of Deposit - in total N/A 30.00% 0.00% Negotiable Certificates of Deposit - by issuer N/A 5.00% 0.00% Corporate Notes- in total N/A 20.00% 0.19% Corporate Notes-by issuer N/A 5.00% 0.19% CA State or City Bonds/Local Agency Bonds- in total N/A 15.00% 0.00% CA State or City Bonds/Local Agency Bonds-by issuer N/A 5.00% 0.00% Money Market Funds N/A 10.00% 0.00% Money Market Mutual Funds - Less than 1 Year N/A 50.00% 12.49% Money Market Mutual Funds - More than 1 Year N/A 25.00% 12.12% LAIF N/A 100.00% 54.08% U.S. Government Agencies N/A 60.00% 41.85% U.S. Treasury Notes/Bonds N/A 100.00% 0.00% treasrep 12/22/2014 0 co