Loading...
HomeMy WebLinkAbout9/6/2017 - STAFF REPORTS - 1.A. �OQ PALM SpA �Z F, O V N IipRA'R. CgIIFo;t City Council Staff Report DATE: September 6, 2017 CONSENT CALENDAR SUBJECT: TREASURER'S INVESTMENT REPORT AS OF June 30, 2017 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, 2017. 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 $158,464,870 plus $10,739,213 bond issue capital projects, reserve and debt service funds. There is an additional $2,296,912 in various miscellaneous/trust accounts. The market value of the invested cash is $157,925,759. RECOMMENDATION: Receive and File Treasurer's Investment Report as of June 30, 2017. 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 September 6, 2017— Page 2 Treasurer's Investment Report as of June 30, 2017 The weighted average maturity (WAM) of the portfolio is 421.17 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 2� Geoff yer S Kiehl, Director of Finance and Treasurer Attachments: Treasurer's Investment Report 012 CITY OF PALM SPRINGS TREASURER'S MONTHLY REPORT SUMMARY OF INVESTMENTS June 30, 2017 On Call Deposits Adjusted Basis Category Total Percentage Checking Account $ 40,775,575 CalTrust ShortTerm 28,827,876 State Pool 31,970,375 $ 101,573,826 64.10% Short Term Investments (1 year or less) U.S.Gov't Agencies 53,494,000 Time Deposits 398,600 53,892,600 34.01% Medium Term Investments (1 year to 3 ears) U.S.Govt Agencies 2,998,444 2,998,444 1.89% Long Term Investments wear to 5 years) 0 0 0.00% $ 158,464,870 100.00% treasrep 8/15/2017 c:) W Total Investment Allocation $158,464,870 City of Palm Springs As of06/30/2017 25 Checking Account ■ 0.3% .� 20.2% 25.7% z CalTrust ShortTerm ill U.S. Gov't Agencies State Pool 18.2% II! 35.65,41 i ■Time Deposits TREASURER'S MONTHLY REPORT DETAIL OF INVESTMENTS June 30,2017 Par Coupon mood""S&P Purchase Maturity First/Next Optional Days Yield Adjusted Category (memo only) Prior Qtr. Value Rate Ratimi Data Date Call Date to Maturity to Maturity Cost Basis Total Market Value Market Value On Call Deposits Checking-Bank of America $ 40,775,575 N/A NIA Demand N/A 1 None 40,775.575 $ 40,775,575 22,876,913 CalTmst Shm,Tenn $ 27,500,000 variable N/A Demand N/A I 110% 28827,876 $ 28,812,947 29,744,829 Local Agency Invest Fund(LAIF) S 31,50Q000 variable N/A Demnnd N/A 1 0,978% 31970,375 $ 31,936,508 31,883,036 99,775,575 101,573,926 101,525,030 83,504,777 Short Term Investments (I year or less) U.S.Gov't Agency Securities Federal Farm Credit Bank 0 0.625% Ana/AA+ 0522/15 0522/17 05122/17 - 0625% 0 0 499,910 Federal National Mortgage Association 0 1.125% Aaa/AA+ 0226/16 02/26/21 05/26/17 - 1,125% 0 0 498,070 Federal National Mortgage.Association 500,000 1.25% Ana/AA1 08/09/16 0224/20 M/01/17 969 1.25% 500,000 493460 493030 Federal National Mortgage Association 500,000 1.50% Aaa IAA+ 02/24/16 1124/20 06/01/17 1,243 1.50% 500,000 496,130 496,360 Federal Farm Credit Bank 500,000 1.58% Ana/AA+ 051171]6 02/17/21 06./01117 1,328 1.58% 500,000 495,515 493,755 Federal Home Loan Bank 1000,000 150% Ass/AA+ 09112/16 1011212l 06/12/17 1,565 150% 1000000 983,520 979,160 Federal Home Loan Bank 500,000 1.25% Ass AA+ 081091]6 0822119 06/22/17 783 1.25% 500,000 494075 494,460 Federal National Mortgage.Association 1,000,000 1.20% Aaa/AA+ 08/03/16 02/24/20 06/24/17 969 1.20% 1,000,000 986,520 985,630 Federal Home Loan Mortgage Corporation 1,000,000 1 40% Aaa I AA+ 0929/16 102721 06/27/17 1,580 1.40% 1,000 000 977,550 973,600 Federal Home Loan Bank 1,000,000 1.63% Aaa/AA+ 1129116 12/28/21 06/28/17 - L63% 0 0 998,930 Federal Home Loan Bank 1,000,000 2.00% Aaa/AA+ 1113W16 12/30/21 06/30A 7 - 2 00/ 0 0 998,040 Federal Home loan Mortgage Corporation 1,000,000 1.50% Aaa/AA+ 09/12/16 09/30/21 06/30/17 1,553 150% 1,000,000 992,130 989,420 Federal Farm Credit Bank 1,000,000 1.12% Aaa/AA+ 06120116 06/27/19 07/27/17 727 1-12% 1,000,000 988.710 989,320 Federal National Mortgage Association 1000,000 1.125% Aaa!AA+ 07/27i16 0727/21 07/27/17 1,489 1.125% 1,000,000 996.910 983,560 Federal Home Loan Bank 1,000,000 1.00% Aaa/AA+ 04/29/16 04/29/21 07/28/17 1,399 1.00% 998,500 993,600 991,480 Federal Home Loan Mortgage Corporation 1,000,000 1.13% Ana/AA+ 10/12/16 10/28/21 0728/17 1,581 1.13% 1,000,000 999,340 996,770 Federal Home Loan Mortgage Corporation 1,000,000 1.05% Aaa/AA+ 10/12/16 10/28/21 07I28/17 1,581 105% 1000,000 979,100 974,680 Federal National Mortgage Association 1,000,000 1.10% Aaa/AA+ 06/20/16 06/28/19 07/28/17 729 1,10% 1,000,000 968 000 988,520 Federal Home Loan Bank 1,000,000 1.25% Aaa/AA+ 10/24/16 11/08/21 W08/17 1,592 1.25% 1,000,000 996,450 987960 Federal Home Loan Bank 1,000,000 1.25% Aaa/AA+ 10/13/16 11/10,21 08/10/17 1,594 1.25% 1,000,000 999,790 986,240 Federal Home Loan Mortgage Corporation 1000.000 155% Ana/AA+ 10/11116 11/10/21 08/10!17 1,594 1.55% 1,000,000 982.450 978910 Federal Farm Credit Bank 500,000 1 08% Aaa/AA+ 08/04/16 08115/19 08/15/17 776 1 08% 500,000 494,875 496,125 Federal Home Loan Mortgage Corporation 1,000,000 L 10% Aaa/AA+ 10/25/16 05/15/19 08/15/17 684 1.10% 1,000,000 1,000,670 1,000,710 Federal Home Loan Bank 1,000,000 L05% Ass/AA+ 10/25/16 11/15/21 08/15!17 1,599 105% 1,000,000 994,900 992,620 Federal Home Loan Mortgage Corporation 1,000,000 1.00% Aaa/AA- 10/20/16 11/15/19 08/15.!17 868 1 00% 1,000,000 993,690 991 930 Federal Home Loan Mortgage Corporation 1000000 1.25% Asa i AA- 07/19/16 08/16.21 08/16117 1508 125% 1,000,000 988,540 965,560 Federal Home Loa.Bank 1,000,000 100% Aaa/AA+ 10/20/16 11/1620 08/16/17 1,215 100% 1,000,000 991,980 989,010 Federal Home Loan Bank 1,000,000 1.25% Ana i AA+ 10/18/16 11/1721 08/17/17 1,601 1 25% 1,000,000 987,410 983,740 Federal Home Loan Mortgage Corporation 1,000,000 1.50a1. Aaa/AA+ 10/17/16 11/10/21 09/18/17 1,614 1.50% 1,000,000 986670 993,490 Federal National Mortgage Association 2,000,000 1.03% Aaa i AA+ 0921113 05/21/18 08/21/17 325 103% 2,000,000 1995,140 1989,190 Federal Home Loan Mortgage Corporation 1,000,000 1300/6 Aaa i AA+ 10/24/16 11/22/21 08MA7 1,606 1.30% 1,000,000 988,030 985,150 Federal Home Loan Book 1,000,001) 130% Aaa/AA- 10/26/16 11/2321 08/23/17 1607 130% 1,000,000 988,720 985,270 Federal Home Loan Mortgage Corporation 500,000 1.30% Aaa/AA+ 08/09/16 08/23/19 08/23/17 784 130% 500,000 497,310 497,135 Federal National Mortgage Association 1000000 LIO% Ass AA+ 08/03/16 09/23/19 08/23/17 784 1,10% 1,000,000 490,260 990,020 Federal National Mortgage Association 1000,000 1,13% Asa AA-� 08/03.!16 11/24/20 OBY24117 1.243 1,13% 1,000,000 981910 977,910 Federal National Mortgage Association 1000,000 100% Aaa/AA+ 09/03/16 08/24/21 09/24/17 1,516 1.00% 1,000,000 996,800 992,120 Federal Home Loan Mortgage Corporation 1000,000 100% Aaa/AA+ 08/08/16 08/24/21 08/24/17 1516 100% 1,000,000 995,520 992,710 treasmP 8il5/2017 TREASURER'S MONTHLY REPORT DETAIL OF INVESTMENTS June 30,2017 Par Coupon Mandy's/S&P Purchase Maturity First/Next Optional Days Yield Adjusted Category (memo only) Prior Qu. Value Rate Rating Date Irate Call Date to Maturiry to Maturity Cost Basis Total Market Value Market Value Short Term Investments(Continued) (1 year or less) U.S.Gov't Agency Securities(Continued) Federal National Mortgage Association 1,000,000 1.40% Aaa/AA+ 08/03/16 09/25/21 OW25/17 1,517 140% 1,000,000 978,240 969,770 Federal Home Loan Mortgage Corporation 1,000,000 1.50% An/AA+ 05/25/16 05/25/21 08/25/17 1,425 1.50% 1 00Q000 994,740 981,570 Federal Home Loan Bank 500,000 t 25% Am/AA+ 05/25/16 05/25/21 08/25/17 1,425 1.25% 500,000 494,860 493,205 Federal Home Loan Mortgage Corporation 500.000 1.25% An/AA+ 05/25/16 05/25/21 08/25/17 1,425 1.25% 500,000 494,625 493,220 Federal Home Loan Bank 500,000 1.125% Ann/AA+ 05/27/15 05/27/21 08/25/17 1,427 1.125% 499,000 496,125 494,330 Federal Home Loan Mortgage Corporation 2,000,000 1.50-1. Aas/AA+ 07/18/16 09/25/21 08/25/17 1,517 1.50% 2000,000 1,976,900 1,970,980 Federal Home Loan Bank 100(1,000 155% Aaa/AA+ 11/02/16 I1/26/21 08/26/17 1,610 155% 1,000,000 992,320 988,9(10 Federal National Mortgage Association 500,000 1,00% Aaa/AA+ 0D26/16 0226121 08,26/17 1,337 1 000/4 500,0()0 499,435 499,960 Federal National Mortgage Association 500,000 140% Aaa/AA+ 02/26/16 11/26/19 08/26/17 879 140% 500,000 496,295 495,820 Federal Home Loan Mortgage Corporation 500,000 L25% Aas/AA+ 02/26/16 02/26/21 0826117 1,337 1 25% 500,000 495,960 494,345 Federal National Mortgage Association 2,000000 1.25% Aaa/AAI 08/04/16 08/29/20 08/29/17 1,155 125% 2,ODO,000 1,967,600 1949,020 Federal Farm Credit Bank 1000,000 1 30% An/AA+ 06/06/16 06/06/19 09/06/17 706 1 30% 1,000,000 991,720 992,600 Federal Home Loan Mortgage Corporation 1,000,000 1 25% Am/AA+ 06/09/16 06/09/21 09/09/17 1,440 1,25% 1,000,000 994,770 992,090 Federal Home Loan Mortgage Corporation 1,000,000 1.85% Aaa/AA+ 11/15/16 12/14/21 09/14/17 1,628 1.85% 1,000,000 997,580 995,660 Federal Home Loan Bank 1000,000 1.25% Aaa/AA+ 06/16/16 06,116/21 09/16/17 1447 1.25% 998,500 988,090 994,470 Federal Home Loan Mortgage Corporation 1,DDo,uoo 100% Aaa/AA+ I M N16 06/16/20 09/16/17 1,082 1.00% 1,000,000 997,890 996,780 Federal Home Loan Mortgage Corporation 2,000,000 1.00% Am l AA+ 09/20/12 09/20/17 09/20/17 82 1.00% 2,000,000 2,001,380 2,001,340 Federal National Mortgage Association 500,000 1.375% An/AA+ 03/30/16 03/30/21 09,130/17 1,369 1 375% 500,000 494,110 492,235 Federal Fart Credit Bank 1,000,000 1.12% Am/AA+ 10/,19/16 10/11/19 10/11/17 833 1 12% 999,250 988,590 989,400 Federal National Mortgage Association 100OX0 117% Aaa/AA+ 10/25/16 11/15/19 11/15/17 868 1.17% 998,750 986,760 985,590 Federal Home Loan Bank 1000,000 100% Aaa/AA+ 10/26/16 11/17121 11/17/17 1601 1"/0 1000,000 995550 992,840 Federal Home Loan Mortgage Corporation 1000,000 INit. Aaa/AA+ 11/01/16 11/29/19 I1/29/t7 882 1.200/. L000.000 988.250 986,920 Federal Home Loan Bank 1,000,000 1.70% Aaa/AA+ 11/17/16 12/0821 12/08117 1,622 1.70% 1,000,001) 996,280 993,430 55 50(iw0 53 494,000 52,97i 625 54,930,980 Time Deposits Goldman Sachs Bank CD 200,000 1801/. FDIC 7/25/12 7/25/17 N/A 25 1.80% 198600 200,114 200649 Discover Bank CD 200,000 1,70% FDIC 7/26/12 7126/17 N/A 26 1.7(% 200,000 200,126 200,686 400,000 398,600 400,240 401334 Medium Term Investments (t year to 3 years) U.S.Gov'!Agency Securities Federal National Mortgage Association 2,000,000 110% Aaa/AA- 03/12/13 03/12/18 03/12/18 255 110% 2,000,000 1.997,520 1,999,300 Financing Corporation(FIC.0) 500,000 9.80"/ Am l AA+ 04/06,188 04/06/18 N/A 280 980% 498,594 532,134 543,110 Federal Farm Credit Bank 500,0W 103% Aaa/AA+ 02/24/16 02/12/19 N/A 592 1.03% 499,850 497,210 497,715 3000000 2,999,444 3,026,964 3,040,125 Total Invested Cash $ 159,675,575 $159,464 870 $ 157,925,759 $ 141,777,216 treasrep 8/15/2017 p to TREASURER'S MONTHLY REPORT MISCELLANEOUS AND TRUST ACCOUNTS June 30, 2017 Yield Adjusted � Par Value Coupon 94ing Maturity to Maturity Cost Basis Cateeory Total Total Invested Cash $ 158,464,870 $ 158,464,870 $ 158,464,870 Miscellaneous Accounts % Petty Cash 3,950 N/A N/A open None 3,950 or� 'Dust&Agency-Bank of America 1,956,467 N/A N/A open None 1,956,467 Downpayment Assistance(Housing Fund) 34,012 0.002 N/A open 0.20% 34,012 -Bank of America Workers Compensation-Bank of America 111,040 N/A N/A open None 111,040 General Liability-Bank of America 26,048 N/A N/A open None 26,048 1930's General Store Museum-Bank of America 15.221 N/A N/A open None 15,221 On-Line Credit Card Fire Inspection Fees 143,067 N/A N/A open None 143,067 -Bank of America On-Line Credit Card Transportation Permits 7,108 N/A N/A open None 7,108 2,296,912 -Bank of America Total Cash Deposited $ 160,761,782 treasrep 8/15/2017 O TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE& RELATED FUNDS June 30,2017 Par Coupon Yield Adjusted Category (memo only) Prior Qtr. Value Rate Racine Maturity to Maturity Cost Basis Total Market Value Source Market Value 1998 Airport PFC Invesco Government&Agency Private 981,996 variable AAA open 0.01% 991,996 981,996 US Bank 829,025 981,996 2006 Airport PFC Invesco Government&Agency Private 2,439,718 variable AAA open 0.01% 2,439,718 2,439,718 US Bank 1,652,259 2,439,718 2007 Refunding Lease Revenue Bonds First American Government Obligation 0 variable AAA open 0.01% 0 0 US Bank 1,084,969 0 2007A&B Tax Allocation Bonds First American Government Obligation 13 variable AAA open 0.01% 13 13 US Bank 13 13 2007C Tax Allocation Bonds First American Government Obligation 6 variable AAA open 0.01% 6 6 US Bank 6 6 2008 Airport PFC Refunding Invesco Government&Agency Private 592,067 variable AAA open 0.01% 592,067 5()2,067 US Bank 591,170 592,067 2012 Downtown Revitalization Lease Revenue Bond Reserve Invesco Government&Agency Private 3,203,660 variable AAA open 0.01% 3,203,660 3,203,660 US Bank 3,197,957 3,203,660 treasrep 8/15/2017 TREASURER'S MONTHLY REPORT BOND ISSUE RESERVE, DEBT SERVICE & RELATED FUNDS June 30, 2017 Par Coupon Yield Adjusted Category (memo only) Prior Qtr. Value Rate Raft Maturity to Maturity Cost Basis Total Market Value Source Market Value 2012/2014 Convention Center First American Government Obligation 12,764 variable AAA open 0.01% 12,764 12,764 US Bank 12,691 12,764 2014 Merged Project 1&2/Housing Refunding First American Government Obligation 492,939 variable AAA open 0.01% 492,939 492,939 US Bank 492,528 492,939 2015 Reassesment District No 2015-1 First American Government Obligation 274,641 variable AAA open 0.01% 274,641 274,641 US Bank 274,411 274,641 2015 Local Measure A Sales Tax First American Government Obligation 1,114,250 variable AAA open QOl% 1,114,250 1,114,250 US Bank 1,113,147 1,114,250 2015 Refunding Lease Revenue Bonds First American Government Obligation 8 variable AAA open 0.01% 8 8 US Bank 0 8 2017 Refunding Lease Revenue Bonds First American Government Obligation 8,686 variable AAA open 0.01% 8,686 8,686 US Bank 0 8,686 Chevron/CoGen Lease Proceeds Cash 716,877 N/A N/A demand None 716,877 716,877 Deutsche Bank 716,877 716,877 Funds With Century Golf 901,588 N/A N/A demand None 901,588 901,588 Century Golf 1,185,312 901,588 Totals 10,739,213 10,739,213 $ 11,150,353 treasrep 8/15/2017 C) CD TREASURER'S MONTHLY REPORT CALCULATION OF INVESTMENT LIMITATIONS June 30, 2017 By Maturity: Minimum Maximum Current Mo. l day to 365 days N/A N/A 98.11% 1 year to 3 years N/A 50.00% 1.89% 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.25% 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% 18.19% Money Market Mutual Funds - More than 1 Year N/A 25.00% 0.00% LAW N/A 100.00% 20.18% U.S. Government Agencies N/A 60.00% 35.65% U.S. Treasury Notes/Bonds N/A 100.00% 0.00% treasrep 8/15/2017 F-+ Q Calculation of Weighted Avg Maturity Mature Current No.of Days X Cost Dale Due Days 6/3 2017 7/112017 6/302o17 1 40,775,575 7/1i2017 6/302017 1 28,827,876 7/1i2017 6/302017 1 31,970,375 522i2017 6/302017 0 0 526/2017 6/30,2017 0 0 2/24i2020 6/302017 969 484,500,000 11/24i202O O02017 1,243 621,500,000 2/17/2021 6/302017 1,329 664,000,000 10/12i2021 6/302017 1.565 1,565,000,000 8/22/2019 6/302017 783 391,500,000 2/24/2020 6/302017 969 969,000,000 10/27/2021 6/302017 1580 1,580,000,000 12/29/2021 6/300017 1,642 0 12/30/2021 6/300017 1,644 0 9/30/2021 6/300017 1553 1,553,000,000 6/27i2019 6/302017 727 727,000,000 7/2 712 0 2 1 6/302017 1488 1,488,000,000 4282021 6/302017 1,398 1,395,903,000 1028/2021 6/302017 1,581 1,581,000,000 10/28i2021 6/302017 1'581 1,581.000,000 6/28/2019 6/302017 728 729,000,000 1182021 6/302017 1,592 1,592,000,000 11/1 Oi2021 6f30/2017 1,594 1,594,000,000 11i 10/2021 6/30/2017 1,594 1,594,000.000 8/15/2019 6/302017 776 389,000,000 5/15/2019 6302017 684 684,000,000 11/15/2021 6/302017 1,599 1,599,000,000 11/15/2019 613O2017 868 868,000,000 8/16/2021 6/302017 1509 1,508,000,000 II/152020 61302017 1235 1235,000,000 11/1 M021 6/3020 f7 1,601 1,601,000,D0o 1129/2021 6/302017 1,614 1,614,000,000 5212018 6/302017 325 650,000,000 1122/2021 6/302017 1,606 1,606,000,000 1123/2021 6/302017 1,607 1,607,000,000 8/232019 6/302017 784 392,000.000 8/23i2019 6/302017 784 784,000,000 1124i2020 6/302017 1,243 1.243,000,000 824i2021 6/302017 1,516 1,516,000,000 8242021 6/30 V I7 1.516 1,516,000,000 825/2021 61302017 1,5n 1,517,000,000 5/25/2021 6/302017 1,425 425,000,000 525/2021 6/302017 1,425 712,500 000 5/25/2021 6/302017 1425 712,500,000 5272021 6/302017 1427 712,073 000 8/25/2021 6/302017 1,517 3,034,000,000 11/26/2021 6/302017 1,61D 1,610,000,000 2/26/2021 6i302017 1,337 669,500,000 11/2N2019 6/302017 879 439,500.000 2/262021 6/302017 1,337 669.500,000 8/28/2020 6/302017 1,155 2,310,000,000 6/6/2019 6/302017 706 706.000,000 5/9/2021 6/302017 1,440 1,440,000,000 12/14/2021 6/302017 1,629 1,629,000,000 6/16/2021 6/302017 1,447 1,444,829,500 6/16,2020 61302017 1,082 1,082,000,000 9/20/2017 6/302017 82 164,OOQ000 3/30/2021 6/302017 1,369 684,5M,DOO 10/11/2019 6/302017 833 832,375.250 11,15/2019 6/302017 868 866,915,000 11/172021 6/302017 1,601 1,601,000,000 11/29/2019 6/302017 882 882,000,000 12/8/2021 6/302017 1,622 1,622,000,000 7/25,2017 6/302017 25 4,961,000 7/26/2017 61302017 26 5,200,000 3/12/2018 6/302017 215 510,000,000 4/6/2018 6/302017 280 139,6W,320 2/12/2019 6/302017 592 295,911,200 66,740,852,096 Total Investments at Cost 158.464,970 t WAM in Days 421.17 1