Loading...
HomeMy WebLinkAbout6/3/2015 - STAFF REPORTS - 2.G. PALM Sa ;OQ 'Pi y V N A f f cq41FOR0�PA City Council Staff Report DATE: June 3, 2015 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF APRIL 30, 2015 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 April 30, 2015. 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 $119,417,275 plus $18,589,882 bond issue capital projects, reserve and debt service funds. There is an additional $1 ,305,675 in various miscellaneous/trust accounts. The market value of the invested cash is $119,592,761. RECOMMENDATION: Receive and File Treasurer's Investment Report as of April 30, 2015. 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 June 3, 2015— Page 2 Treasurer's Investment Report as of April 30, 2015 The weighted average maturity WAM of the portfolio is 387.87 days. The 9 9 Y � ) p Y 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. Kehl, Director of Finance and Treasurer Attachments: Treasurer's Investment Report 02 CITY OF PALM SPRINGS TREASURER'S MONTHLY REPORT SUMMARY OF INVESTMENTS April 30, 2015 On Call Deposits Adjusted Basis Category Total Percentage Checking Account $ 7,626,634 CalTrust ShortTerm 23,308,347 CalTrust MidTerm 8,915,475 State Pool 33,078,626 $ 72,929,081 61.07% Short Term Investments (1 year or less) U.S.Gov't Agencies 42,991,000 Corporate Notes 0 Time Deposits 200,000 43,191,000 36.17% Medium Term Investments (1 year to 3 ears) U.S. Gov't Agencies 2,498,594 Time Deposits 798,600 3,297,194 2.76% Long Term Investments (3 ear to 5 ears) 0 0 0.00% $ 119,417,275 100.00% treasrep 05/18/2015 O W TREASURER'S MONTHLY REPORT DETAIL OF INVESTMENTS April 30,2015 rur cwP+l rwuMs AMtwp Fl.amdu!(m.urxl unc odd niy ru lad oregnn Im.m.,m lrl rum Qo Veluo tf_alk St... 1"ll Id, Crll Jill, I.N l�le' In Macon n. C-I Xaru l Ma�A�l'e log 5.�r a Ale�ke�l Y'ulg Qr CA Dvlwaila CMkil,-Still of Ammiu 8 INI6614 N. .. "it N/A as -.�_. S nl�()! RauA nl.\nrcna li. Ce1Tmn 91wnTam 2".WO .mliRl NM danu�nd VIA pIll 21i 11¢:q 11...Iul .V LIill CilTma Mldrttm Iiti O uneM, NIA 1--,! VIA 1 1I%9. XYI'GS s ILL 4-Ill I III—L 1,%.:It I-1 AN.,ilrvan I LIL.1ll 11,111, 11, ri Fla` N/A .Itil ll N/A I_1;L. II'li 1;Ill IAll I I'I11r1 I2,126.634 •...a J.>tl +2 nil 1.-In M Jfi,.]S gMn fem.Invellnrellll 11 a or leal I15 G,Vl.AvlrFr Bt.um'Iva YtIkm111—Im",Rank IINI% Nlq IIY/151N 11115119 IN/I3/IS 1 I11% I 13arrl of NY M,11hl I qll 7 111 F,dadlil NulivI MnBtnJLill, Atrclallav U 2"I10% NIA OWIUI1 I'llI 1A110.111 R IWY. U 0 11 CNY Mdlrm L"IN., Fil lam l.wll Bad N.MIN;"1.1y O d11 NIA USN9112 R111 S,I JSAI I111 15- RSSA IIN111.RRU 9•14 530 Ili I NY Nalll nr YY9`!n Fdvul Nan-Ill CIIdII ReN I.00i' o I181, N/A 11.115112 Nil I"17 151111115 .' 1185% 999,IIRV 11,l 11 11I1 I1-1 nY NY vdi- IIxIn 11 TI Yi IU. L—L Rtnk 2 0.l. 0 9flX NIA V%/I SIII ",'1111 R$/01/11 0.1% 1.901 WO 1117'01 RarlA of NY Mal l.nr I it,111. Fddril Fumc Lann Bnd I'l21 r I� N/A 02121,11 Itil lm Oiq 1115 A)2 ISu% f I'll1111 2ILI,I00 Rank of NY III IP16'Nl RNemlIT.— G1 Bad 2UU0.1gU LI5% N/A @,71,13 R➢2111 USmIlI1 1!15 112% All1xx1 1Til42U 1111NYMdFm lit Fekrll ill.— tltN LROO ROo 1 N/A RSR9113 1,111111 115/1/1113 1,115 1175•. I,IIOOi MIR UnA i NY Mdl.m Irx 1n II'll I Illlll Jill Futnl HomcI—Pallk I1111 11(I 125% N/A T_11:11Y Il lll9 rd,.,IS I!119 IRS/. IJN10111. "11'I1 Ii II NY 1111111 1 ..n Fnk al11 Juan Mutl Ill lnllnn LUIg00n 1,111 N/A 11,15 112011, UL`J1111 I u3 IIS. I 1 .I. lY.l`n Rurlk ul Nl'Mall.m I,dillll li l MlvlyuMe Avsmnllun ,111.11 itill IRi% NIA II$/21113 R51II11n 11112I'll!I I.1II IUi% 291,it11 IVY_Nll FunA e I NYM,[I,,l IYX'l a•+nI Awknll NMmul Mmlgap,1,-I,11w !111().pRl1 1Ilild WA U61'X112 ISIT/I% "I'll 1 11 111ne. 9Ytl olio n r1 Ii,114 in NY Md1I.n iI Fiillil Ni im,IM l.lik r\ssaiouon $,IIIIp,000 I.NT% N/A Iltl/21112 1112111. /1112115 i 1111% jnIll I'll, anril'_11 13.in4 it NY Mall mr gnu111,11 FIMLI II,.—l.wm Mll I11t1il O 01.1 N. I1 1: pWlx111 11r.11.1111 1139 r 2"I'llR11, 2111",1 Rsnk,,NY Mdl.". nl 11,11 FMvuIIII•nx'Lrrun Muuptgc 111 lion 2.RI111,0011 IIN1% V/q Ilyl`N 12 r xiV11 R412111I3 8IJ 1211, 1, 1 1111_,SJr1 111 of NY Ilan _ _n 19/ •It'll I% + r . . Fubal floorI Y.Irill t'�ryurr l.un 10OQORR 1 111•/. Nil CILN,ILI 11 p2/2R110 I._ 1.li 1" 1 I1,, 1�RRRINIR ]i11111 IIII Rnr1A Il NY11,11'. 2.11,211. I'l lHans l.rav RaM 2.OM A0R 125% N/A IM110115 O6IN/I1 Rb2Rlli I.I41 121,t 19YR Fill IIN211u 1nL1NY Mdlnn II%IL 111. FWnxl Humcl Jun YUlnpage trmuration 121�ORO 1E5°. ,1'LA n3gPli n9nylk IN^Slli I_LJ 12Pe 11 mRt%FI Inn'17Gn it u40l NY M,11- 1till 1.311 Vl, lIt-1—I Milt OIM1.000 1..1% 11% R1136/IS IIl121/I1 1112611A IA61 1114% 1 LRl2]2U RanL uI NY Mall lnr I III IqI ricid 'it LookWr ld—it".. 3111N1 R1111 11,11 N/A .11,2111. 1191xil fl 116'2/IIS 9R1 I oY4 2111.0"11 a11N 911 Runk of NY MdIm1 1 , F�.tI It m'11MMo ,,1.,lrn 2RKlolR I(S1% N. IlI,,i 119/d F•1) .v ",li, I11% 11 .lxxi 1 9Nr1 Rmlk of NY Mt111n1 IY d., FILL I H—1.Ian MORga pe C., lion U11.00R Iii NIA II I11,11 Rl/11/2R R611 Ills I;IV6 Itl5% IIJOIt it IRL2660 Ran4 of NY Mill.1 In42.i5u Fit H,l-l.mn Mmlg,Cnirt—filn OrH1.R0R Ifq% N/A Rllll/13 "I/11/19 117,11/I5 9%r MITI% 1.I'll,Ill, 9W ILI Rmlk of NY M,111111 'l Fit Hmx�I M rit,gu CaL,lial ine 221g000 1-115%Ill N/A IrlllUli ll1 s/19 OI11 A Ill 1115'% 21N In Uq lil9.id1 Snd If NY WILL,, Irill9211 rddt Hmw No—I mMor14t4e Cuiyrvlim II)Ip 111111 111% N/A Ri125113 Rill n'1123IIS 149I Iii 2WR.IpR I.Y9lltlIX:0 Blil lNYMcllmr L99n Yx11 Fdlaxl....I—Boin@,A)$oaWUV11 4.I11 XI.RRY IUl% NM RI111113 11,31,18 0]I3 Rll3 I.11116 123X I..R . 9.1 240 I'll of NY MI 1.11 41. fidditdill Noll LML, I,I.Alll 1WN, N/A n111N15 112,i111. 11]11115 I'll 11.1%1 Ip00 M11 199R,IJ11 III NY Mdlm 998 41IR FMYu1 Ii..L.L.Bie Aa mali nn I ISKII I 141.1 N. RL141il 'I'l P SARI/IS 1 22, 1 111-1 I11R0 I'lltill IAIII L 4111I It 13a ilk,J NY MI... I'll I'll FWaollill, wuBad 1R1%I,Run 121% N/A IO 5 'I'll o3/n4/I6 12D I2R% 1 1 1u 1Ol flu 1It 1k,I NY%1,IA nr Inn15%n I'MYal llmu Lmn Mono At Comauliw ImXlpnn lI5`b F/A %1on115 U1N Y/IN u11u 9n6 IOJ! 125°�. lunryln.0 10o I�2nn NurA of NY,Mvll mr I It"?YU 4;I.Toou 42IY1iorin 12,111 I'll, li1111111 17nu3 it C..rm ,Nil, cmn,ml Ylm oa orvla I.....cm I 2l%[ouR a.HI. 111nM w11111d R411111, NIA II" o T.,. n I ,n Rmd.u1 N1',MvIHm 1 lMV.O(X) U I1 iu 11 l ixlll Tinr DvP.uily Nly lit $W,RRO 1.15% NI -IRl112 7117111 Nln NH I11.1 2Y1,110U 21`U Mtn hunk of N\Mall- 2t I16I•r 2.IN, 211J.JIM ILL."1 tun 1.111 MeG run lean lm'nlmenla (l yarlulvvnl Time Upoail Buall Nank t:IJ 2W ORR I'i5% V/A IRN12 Irz0/I1 141A 1,- 115% 2RO 00o 201750 Ilmrk.If Nl'MJil 201,899 GE Cep Rerl4 LI, 2N1,0RR 111% NLA '12N12 ]/2NI6 N/A 1"1 dill Rn 201,750 IL d'nI NY 11,11,1. 201,899 Cm ILmn Sil Sunk CD IMI.0011 191.1 NI ]/R YI] 7"111I N,A 1 Ill 201 Il..nk"1 Nl'Mall.m 5R 20<,2 Uzcou Rini, W CD 2l1gl IIPo NIA '1126112 7'111!,1 NIA NI% IXII, ill 111111 203575 Rmlk of Nl'M.IIm• 203.I90 %Illllllul 4Y!fill it I IS U.B.[im'I Agmv Fehrel Ne-I MnnQepe Al— 2 ill 11R9b NIA I I 111 i ii,2,11 1111 1 1117 t till 2.u0400n _ .. [.I hank el NY M111.m 2n11151n Ivxlcup(.....um SRILII IIT. Nil I8 ill IS it 11.= 11,.% 111 19 1 ,1 Almzu lu 11Y znonpoI 2; x5w ua1 11Y O Tolel lntwlW C'axE 3 III 9i 5 119 AI:2r3 S 119.312 I'll ; 116]Y1.121 1 �v .1 I'll TREASURER'S MONTHLY REPORT MISCELLANEOUS AND TRUST ACCOUNTS April 30, 2015 Yield Adjusted Par Value Coupon Rating Maturi to Maturiry Cost Basis Category Total Total Invested Cash $ 119,417,275 $ 119,417,275 $ 119,417,275 Miscellaneous Accounts Petty Cash 3,950 N/A N/A open None 3,950 Trust&Agency-Bank of America 1,050,373 N/A N/A open None 1,050,373 Downpayment Assistance(Housing 33,886 0.15% N/A open 0.15% 33,886 Fund)-Bank of America Workers Compensation-Bank of America 77,135 N/A N/A open None 77.135 General Liability-Bank of America 30,000 N/A N/A open None 30,000 1930's General Store Museum-Bank of America 8,246 N/A N/A open None 8.246 On-Line Credit Card Fire Inspection Fees 96,541 N/A N/A open None 96,541 -Bank of America On-Line Credit Card Transportation Permits 5,543 N/A N/A open None 5.543 1,305,675 -Bank of America Total Cash Deposited $ 120,722,951 treasrep 05/18/2015 O C.n TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS April 30, 2015 Par Coupon Yield Adjusted Category (memo only) Prior Qtr Value Rate Rating Maturitv to Maturity Cost Basis Tom] Markel Value Source Market Value 1998 Airport PFC lnvesco Government&Agency Private 1,037,277 variable AAA open 001% 1037.277 L037.277 Bank ofNY Mellon 976,449 1,037,277 2002 Parking Structure Cash 3 3 3 Bank ofNY Mellon 3 Invesco Government&Agency Private L331 variable AAA open 0.01% 1,331 1,331 Bank ofNY Mellon 1,331 334 2004 Assessment District 161 lnvesco Government&Agency Private 3 variable AAA open 0 02% 3 3 Bank ofNY Mellon 522,074 3 2004 Assessment District 162 Invesco Government&Agency Private 2 variable AAA open 0.02% 2 2 Bank ofNY Mellon 227,629 0 2005 Assessment District 164 Invesco Government&Agency Private l variable AAA open 0.02% 1 1 Bank ofNY Mellon 470,692 1 2006 Airport PFC Invesco Government&Agency Private 1,766,478 variable AAA open 0.01 0 1,766,478 1,766,478 Bank ofNY Mellon 1 F41 469 766 478 2007 Refunding Lease Revenue Bonds Invesco Government&Agency Private 0 variable AAA open 001% 0 0 US Bank 1,300069 0 2007A&B Tax Allocation Bonds Invesco Government&Agency Private 368,269 variable AAA open 0.01% 368,269 368,269 US Rank 368.267 368,269 measrep 05/18/2015 0 TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS April 30,2015 Par Coupon Yield Adjusted Category (memo only) Prior Or Value Rate Ratio e Maturity to Maturity Cost Basis Total Market Value Source Market Value 2007C Tax Allocation Bonds Invesco Government&Agency Private 340,218 variable AAA open 001% 340,218 340,218 US Bank 340,216 340,218 2008 Airport PFC Refunding Invesco Government&Agency Private 609,363 variable AAA open 0,02% 609,363 609,363 Bank of NY Mellon 609,358 609,363 2012 Downtown Revitalization Lease Revenue Bond Reserve Invesco Government&Agency Private 3,189,955 variable AAA open 0.01% 3,189,955 3,189,955 Bankof NYMellon 3,189928 3,189,955 2012/1014 Convention Center First American Government Obligation 1,418,539 variable AAA open 001% 1418539 1,418,539 US Bank 12,677 1,418,539 2014 Merged Project I&2/Housing Refunding First American Government Obligation 419,481 variable AAA open 0.01% 419,481 419,481 US Bank 419479 419,481 2015 Reassesment District No.2015-t First American Government Obligation 288,023 288,023 289,023 US Bank 0 288,023 2015 Local Measure A Sales Tax First American Government Obligation 6,595,953 6,595,953 6,59 i,953 US Bank 0 6,595,953 ChevrowCOGen Lease Proceeds Cash 935,305 935,305 935,305 Deutsche Bank 1,142,120 935,305 Funds With Century Golf 1,619,681 1,619,681 1619,681 Century Golf 1505,051 1,619,681 Totals 19,589,992 18,599,992 $ 12,732,912 treasrep 05/18/2015 TREASURER'S MONTHLY REPORT CALCULATION OF INVESTMENT LIMITATIONS April 30, 2015 I By Maturity: Minimum Maximum Current Mo. 1 day to 365 days N/A N/A 97.24% 1 year to 3 years N/A 50.00% 2.76% 3 years to 5 years N/A 30.00% 0.00% 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.84% 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.00% Corporate Notes -by issuer N/A 5.00% 0.00% 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% 19.52% Money Market Mutual Funds - More than 1 Year N/A 25.00% 7.47% LAIF N/A 100.00% 66.16% U.S. Government Agencies N/A 60.00% 38.09% U.S. Treasury Notes/Bonds N/A 100.00% 0.00% tma mp 05/18/2015 O 00