The URL can be used to link to this page

Home My WebLink About10/7/2015 - STAFF REPORTS - 2.G.Imo- PALMS.. iy G V N +f c oS °fbaoc° cIFORe�P Citv Council Staff Report DATE: October 7, 2015 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF AUGUST 31. 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 August 31, 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 $120,776,480 plus $16,087,084 bond issue capital projects, reserve and debt service funds. There is an additional $1,280,747 in various miscellaneous/trust accounts. The market value of the invested cash is $120,845,925. RECOMMENDATION: Receive and File Treasurer's Investment Report as of August 31, 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. 3 L_\ City Council Staff Report October 7, 2015— Page 2 Treasurer's Investment Report as of August 31, 2015 The weighted average maturity (WAM) of the portfolio is 374.32 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 n Geoffrey I�hl, Director of Finance and Treasurer Attachments: Treasurer's Investment Report 02 CITY OF PALM SPRINGS TREASURER'S MONTHLY REPORT SUMMARY OF INVESTMENTS August 31, 2015 10n Call Deposits Adiusted Basis Cateeory Total Percentaee Checking Account $ 3,104.670 CalTrustShortTerm 31,852,103 CalTrust MidTemt 5,427,912 State Pool 34.103.101 $ 74,487,786 6L67% Short Temt Investments ( 1 year or less) U.S. Gov't Agencies 42,491,500 Time Deposits 400,000 42,891,500 35.5106 Medium Tenn Investments II (I year to 3 years) U.S. Gov't Agencies 2.998,594 Time Deposits 398,600 3 397,194 2.81% Long Temi Investments (3 year to 5 years) 0 0 0.00" o $ 120,776,480 100.00% treasrep 09i 16/2015 :.3 TREASURER'S MONTHLY REPORT DETAIL OF INVESTMENTS August 31, 2015 ear ce,mom pm,ha.c Nima ,, kuc0 Ne110pheall Da,: \raid .\dm,led (meeon nnama mil" Plml Qo Value Rate Rem Dpts [I" Call Ddm In Moont, 1n N� (Ira Ba,n Total M4rke3 \'Blare Source NbaketYgluy IOU Cnll Da,", C'h,,,mg-Baal of Anlen,d 5 3,ln4,n7U NA AAA demand N\ 1 None MIA5711 E 3, 10i,n7o Bank of AIU,aa, IIn91A CATmU Sh,ntTerm 31 iW 1100 vanehle NA demand N\ 1 n,1rva 318521/13 3 l,13S,91I Ca)Tlnal 11 ()a UOI CalTnnt Mid rend 5N1rCon) ,muh1, NA demand N\ 1 082'. 1427,912 5,4u5078 Cal❑uat IUIOO al4 L,.,al A,m, B„nt Flmd F AIFI 3401100110 eawNc N,A demand NA 1 03301. 34, 103, 1'11 34,115923 LAIF IS is;III 73 Mµ file 74487,78n 744n1,W 81 ill I'_x Short Term Imeatmenta ear meal LI S Go, t Aeencv SecunOe, Federal Home ].Iran Mnngage C orpnonrna U 13ge NA U_';'_U, 15 0211018 OS_'0'li 9114 11110 a 0 Ban4 of N}'Mellen 99x 71U Federal Fa C Ueda BUnl "rm INS, nOlt "a N.'A .315,11 .18r15117 n9ol 15 715 098a,, 1r97,1101I 1997 t40 H16 ofNN Mellon 1098 ion kedcral Home L.,n Hart/ L,,)O Am I.W. N,A 0918 12 09 1817 neat 15 741- I UUa. 1999.IIa0 1 094 100 Bank of NNN1e11nn 1 999 36U k,danl Fann C 0 do 6,ud, 20110,01 al 110"a NA U_^_n113 1)11018 09011, 9.4 1 ❑a. 1..000,U00 2000,240 B.m, of Nl M,IImI 2.01,0220 kedaral Noma Loan Han, I01100m, 0875'. NA 05,29,13 05,19 Is amiol I" InU' 0871'. Ip1rO,000 9998'0 Ban,.I Nl Mcllaa Id10043U F,d91,1 H0nr, Luau Ban, 1 u0g0m, I of". N A 02/12 ❑ 02,12; 18 11 IS1, 896 1 04aa I'low,Wo 096 720 Bank al N]' Mcllnn 91,1_70 kedual Nalaral Mong.m, A,,,rdu0u :000,0m, 1m.. NA UJ'_I 13 U512118 IL_I li 994 103°a :000,UO0 IQ971n1I Bonk of Nl' Mcllnn 198631_0 F,d,Ial Hain, Luan Mong,m, Cm pmdh0n I(IOU PW I'95.. N,A 05/21/15 0521❑0 11;'1'11 1715 In25a. I00,0)0 991140 Bank ul NY Mcllnn "12 n70 Fedeul Form C ndrt Bad, 51111,00m IW^. NA 052nll1 022(r18 II''615 Bin 109aa 5OU U0n 499855 Ban, UI NN Mallon 499'118 Federal Faml Credit Banl SUgUW 098aa NA A?1111 11,27!17 11"7,11 819 098'. 500000 49968E Ban6,d NN Me11or1 51w 0711 Federal N,un.l Mortgage Asaoclatma Ipn1!000 120a. NA U32T19 02271N 11 '7 11 911 121).. ImIn OW IOul 280 Bank Ut NN Mell.,n I1, Kl xlu Federal Home Loan Bank IUCg00u 0SUaa N'.\ Ire 12/13 On l'_IN Ira ❑,II 101n o80°. IWU OW 10001'O Ban, of NN Mellon I,m0lea FederO Home Loan Nlongage Corporatwn 2 unm UUO 1 Wu.. N A IH 20 12 09121 17 0910'11 711 1 0n°. _ In1n tiler _ 0WOOn Bank or NN Mcllnn _ 11r3 410 Federal Hoare Lean Mortgage Cm,matwn :00u," I2na. NA 111 21) 11 OVIU Is 092011 9C 11_0". 2Wn art 1r 1998 Oro Bank a NN Mellon IT14 1,41' Federal Home Loan Bmrk : uagUW 1 UOaa N A 1a, 21n 11 On 211 IN 1)9 ^n 11 1 ON 1 UU.. 1 a)g,000 1 999 78U Bank of NI Mellon '_ WW 41nr Federal] tome Loan Mortgage Corporatwn 1.00 UUU 125a. NA 1H 2111 0921,18 092511 111_I 1'i.. I00,000 100E 64U Bank Or NN Mellon IWI 3W Federal Home Loan Ntao,ge Corporator 2.00 WO 1 04°a N'A W 21 G 09127 17 n'; 27 11 )ix 1 (W. '_ 1 I0U'IOU 20U1 300 Bank.I NN Mellon 2 002 540 Federal Nauonal Mortgage Ass,KmIron 2,000,00t, 1 Wla. N A Ion "r G n9;'7 17 09/27,11 75x 1 07.. 2 nnO,U U 1, 998 7'U Bank of NN ' Mellon '_ 001 3a1 Federal l tome Loan Mongame C m,manIm I000W0 I85a. NA 01,30,11 03;3nC0 (),1 11) 11 1n13 181.. 1 .00,600 In01_Un Bank w NY Mellon 999 man Federal Home Loan Moo,,ma CUrpurahon lall" 000 IUUaa NA UI 1113 01111 Is IU'1111 864 Ion'. IOUs WU 997,86U Bank of Nl Mellon 9o4370 Federal Home Loan Mortgage Cmpuratum 2uno No IO5aa NA U1 In 11 01111 Is lo9a li 869 105a. 200E UUU 206 6'h Bank of NN Mail.. 2.00od20 Federal Ham, Lean Mortgage Corporation ? On l WU I Ka. N A 0191 11 C4123'I8 "'1 11 Sax 1 Ii.. 2 UUU WO 1 995 7'U Bank a NY Mellon 1 non 980 Federal Nahnnal Mmgege Aa,vlahon 4,mm,00U 103'. N.A np3041 n1130'I8 1U/311;1i Ott In,. 4U0u WU 4,0U4'81, Bank of NY Mellon 4003110 Federal] fume Loan Bank Innopm IOUP. NA nl, Wit nlnWIS 1491111, Sxi I0n°. IUOU.0 195,050 Bank of NY Mallon 998 n't Federal 1[Ume Loan Bank 1 ungUm 1 25a. N;A u72915 07¢420 01 ^9nn 1 794 1 2,o. 997 SUn 1191140 Bank .f NY Mellon 11 Federal ]tome Loan Mortgage Corporatwn 1 Call.0" 1 ill'. N.A n7g91Is (17,'9120 W 8b In 1 794 l in.. I UUU WO 1 0nl xtln Bank It NY \l,llon 0 Federal National Mortgage Aaao.Iatwn SUo"mm l W. NA 01„2 11 n2;'D 18 W±n_2 In 9nn I nn°. no WU 41n n115 Bank of NY \fellan 4al,005 Federal Hem, Lam Bank 1 ana W0 1 Lon. N.A 03'114 15 09 W I8 WIN It, I l00 1 40°. 1 000000 199 340 Bank et NY Mellon 1 000 41n Federal Home Loan Mortgage Corporatwn Irmo WW 125a. NA 113;109/11 marl 18 01.119 In ',,I I'_i°. luau WU IUUI,550 Bank.t NY Mellon Iun258n Federal Nanenal M.Ogage AaaaaaWo. i0000n IL'P. NA 0511095 11519,18 a•:I811a 991 112i.. 100000 4- 3C Bank .I NY Mellon 499195 Federal Nmenal Mortgage Aswnmmn IOU 000 IOU=a NIA no, I5115 121511 1a, trio Nil 1no.. 500000 SW,'_UU Bank of NY Mellon 499770 Federal l[ome Loan Bank I!1100,000 125'. N'A 014915 a7;1920 o12911, 17114 121a. 1On0IOU 998 ISO Bank of NY Mellra 0 12 500 U00 42 4,r IOU 42,465 31r 1.471 215 U.", . to"ol, d ILA I 11nn ear IPrin love,)ow, I vor le„1 Turn IhW„11. GC C ap Reia11 Bank CD GE Cap Bank CD INfednlm TPrm Imoel.enp I I year m 3 yev zl Tn1e Dgmvn Cloldm:m Sa.h, Bank CD Do,o... B" CD I. 1 Io,1 Aeen:, S,,uage, Federal Porn Ciedu Bank Fednal N,uo-1 MmIK'lye A - ,I FIf.ino C'ulpnravon I MCD �Tul,d In• e•teA CA, lu , TREASURER'S MONTI ILY REPOR I' DI; I AIL OF 1NVES I MFNTS August 31, 2015 Par Canpol Pumha,e klmur,n Fi ,1 Nea 0pu9na1 Dal, Lela Adluaed Cal Su0' On onl.l Pfmr IAr \'iluc Rae Re me Dam Dale Cal( m Nr� o N� l uzl H 11.1 Ima1 Nladxt \aloe S9uae NLdel Velu, 200.nn0 135°. NA 720.12 720 to N4 K4 135'. 1_09 g0l. 201331 Ba,k of NY Mellon 201443 200 d011 135°. NA 7,,201] 7'_0/10 NA 324 135•. Zoo UOU 2(11"1 Bank of N)M:,Ilon 1a1193 100 UUU 41 000 �11' 002 4n2 980 2011 IIUU 1 81. N A T 25 12 ] 2AII N 4 nM 1 &Y. 1i8 o0o 2UI,o51 BvA v N\ Mellon 21.1 794 10u 0nn 170'.. NIA 7121,12 72u 11 NA 05 19U°• ZU,, WO 210,'_14 Bank uINN McIWn _U. 38; 400,000 3YF u00 illo 9.0 407 17H 501, llau 111fO. NA ua 22, 11 01,2219 (11-17 Idu UoP. 100 unn qvB WS lj MofNY Mellon 4og 4+0 2 nnn 000 1 W. NA 031_113 11: 12H 113'11,18 924 1io°. 2001"Onu 1999420 Hook nINN MJInn 2na130 5UU,000 9W0 NA 0411m88 nJlno 18 N.d 949 91 498594 o119.2 Dm)k of Anronca nI JA )nngnnn 2998,59q 3, Ino 391 2oM 803 $ 11'14M e30 S 121171n490 S 12n8JS92• $ 1211281f1U Curren) Waner Ponfuha Yield o12°. n.a.. TREASURER'S MONTHLY REPORT MISCELLANEOUS AND TRUST ACCOUNTS August 31, 2015 Yield Par Value Coupon Rating Maturitv to Maturity JTotal Invested Cash I $ 120,776,480 $ Miscellaneous Accounts Petty Cash Trust & Agency - Bank of America Downpayment Assistance (Housing Fund) - Bank of America Workers Compensation - Bank of America General Liability - Bank of America 1930's General Store Museum - Bank of America On -Line Credit Card Fire Inspection Fees -Bank of America On -Line Credit Card Transportation Permits -Bank of America (Total Cash Deposited treasrcp 09/16/2015 C C. Adjusted Cost Basis Cateeory Total 120,776,480 $ 120,776,480 3,950 N/A N/A open None 3,950 1,106,806 N/A N/A open None 1,106,806 33,903 0.15°a N/A open 0.15% 33,903 64,135 N/A N/A open None 64.135 30,000 N/A N/A open None 30,000 10,136 N/A N/A open None 10,136 29,698 N/A N/A open None 29,698 2,119 N/A N/A open None 2.119 1,280,747 S 122,057,227 1998 Airport PFC Inoesco Goverment & Agcn ry Pmate 2002 Pm kutp Structure Cash Imesco Government & Agency Private 200b Airport PFC Imesco Government & Agency Pm ate 2007 Refunding Lease Re%enue Bonds Imesco Government & Agency Pmate 2007A&B 7 ax Allucatnm Bonds Imesco f overnment & Agenc} Pmate 2007C I ar Allocupon Bonds Imesco Goverment & Agencv Private 2009.Aopon PFC Refunding Imesco Go,ernntent & Agenc} Pnvate trea.., 99, IO2015 TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS August 31, 2015 Par Coupon Yield Adjusted Categury Value Hate Rahn e Matun to Maturrb Cost Basis 1 utal 1,133,297 variable AAA open 001, 1,133,297 1,133,297 3 3 L506 vanable AAA open n 01' 1,506 1,509 1 411,210 variable AAA open 002'. 1 141 210 1,141 210 ll variable AAA open 00I.. u 0 368276 tarrable AAA open 00I.. 3b8276 368,276 185225 unable AAA open 001°a 185,225 185.225 t,09.507 raroble AAA open 00T 6119,507 b09.507 I menu onp I Pnur'Ju Market Value Source Market Vnlue 1,133,297 Bank of NY Mel Ion 1, 15Y,095 3 Bank of NY Mellon 3 1 506 Bank of NY Mellon 1 331 1 141 210 Bank of NY Mellon 2,356,674 0 US Bank 0 368,276 US Rank 3b8272 1852_'S ❑S Bank 340 221 609507 Bank of NY Mellon 609.467 2012 Duttnlutvn Ret naLtalton Leme Re,cnue Bond Reserve Invesco Government & Agency Prix ate 2012 2014 Convention Center Furst Ameucan Government Obhganon 2014 Merged Ptolect 1 & 2 Housing Refunding Farm Amcncan Government Obligation 2015 Reaswsment District No 2015-1 First American Goternment Obligation 2015 I oval Measure A Sales Tax Furst American (in%ernment Obligation Chevron C4Gen Lease Proceeds Cash Funds With Century Golf Totals ucastep TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS Auaust 31,2015 Pat Coupon Yield Adjusted Categun Imemu only I Prior Qlr Value Rate Rating Maturm to Malunn Cost Basis Tolal Market Value Source Market Value 3,190,718 turnable AAA open 001". 3 190 719 3140718 Bank or NY Mellon 3,140506 3,190 718 12,671 tanable AAA open Ool°o 1201 12.671 US Bank 12A71 12 671 357,930 tanable AAA open ()01°0 357930 397,4311 US Bank 419,486 357,430 781428 tanable AAA itpen oIt P. 781428 781,428 US Bank 288020 781,4'_8 6,i96p64 venahle AAA open 001°a 6,596,u64 b,596,064 IIS Bank 6 595 998 6 596.UW 79.{ 975 N A N.!A demand None 754.975 754 97, Deutsche Bank 754.975 751,47i 954,273 N,A N/A demand None 954,273 954,273 Century Golf 1,337,946 a54,273 16,087,084 16,087,1084 S 17 434 671 TREASURER'S MONTHLY REPORT CALCULATION OF INVESTMENT LIMITATIONS August 31, 2015 By Maturity: Minimum Maximum Current Mo. 1 day to 365 days N/A N/A 97.19% 1 year to 3 years N/A 50.00% 2.81% 3 years to 5 years N/A 30.00% 0.00% By Type of Investment: Bankers Acceptance - in total N/A 20.00% 0.0000 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.66% 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.0006 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 I Year N/A 50.00% 26.37% Money Market Mutual Funds - More than 1 Year N/A 25.00% 4.49% LAIF N/A 100.00% 28.24% U.S. Government Agencies N/A 60.00% 37.66% U.S. Treasury Notes/Bonds N/A 100.00% 0.00% treasrep 091 W2015 C. CO