Loading...
HomeMy WebLinkAboutItem No. 09 - Monthly Investment Portfolio Report for May 2020 Consent Calendar City of San Bernardino Request for Council Action Date: June 17, 2020 To: Honorable Mayor and City Council Members From: Teri Ledoux, City Manager By:Paul Espinoza, Finance Director Subject: Monthly Investment Portfolio Report for May 2020 Recommendation It is recommended that the Mayor and City Council of the City of San Bernardino, California accept and file the Monthly Investment Portfolio Report for May 2020. Background requires that a monthly Investment Portfolio Report be prepared and submitted to the Mayor and City Council. The Director of confirm that the portfolio is in compliance w Discussion investment portfolio for the month ended May 31, 2020. full compliance with the California Government Code Section 53601, and there is sufficient cash flow from a combination of liquid and maturing securities, bank deposits, and income to meet the 2020-2025 Key Strategic Targets and Goals The acceptance and filing of the attached Investment Portfolio Report aligns with Key Target No. 1: Financial Stability by Implementing and maintaining and updating a fiscal accountability plan. Fiscal Impact None Conclusion It is recommended that the Mayor and City Council of the City of San Bernardino, California accept and file the Monthly Investment Portfolio Report for May 2020. Attachments Attachment 1 Investment Portfolio Management Summary Report Page 1 6778 Ward:All Synopsis of Previous Council Actions: None Page 2 AP YTM 1.3631.0401.9211.7601.8452.2022.5000.060 1.5441.544 365 Equiv. 290 N D. ST Report Ver. 7.3.3b Portfolio CITY (909)384-5242 PM (PRF_PM1) 7.3.0 YTM 1.3441.0261.8951.7361.8202.1722.4660.059 1.5231.523 360 Equiv. FINANCE DEPARTMENT CITY OF SAN BERNARDINO 111 SAN BERNARDINO, CA 92401 640324761 340340 1,1741,337 Days to Maturity 111 650650 Term 1,3391,4391,4451,2751,572 0.008.001.443.604.284.76 % of 49.5328.39 100.00% Portfolio Book Value 1,774.21 21,884.7221,884.72 2,004,853.364,994,139.445,940,000.006,605,108.94 68,780,949.2911,106,516.0639,427,750.04 138,861,091.34138,882,976.06 1.85% 1,834,241.94 107,516,785.34 May 31, 2020 Value Market 1,774.21 21,884.72 21,884.72 Fiscal Year To Date Portfolio Summary 2,016,470.005,088,680.006,233,442.196,605,108.94 68,780,949.2911,289,804.5939,956,897.00 Portfolio Management 139,973,126.22139,995,010.94 CITY OF SAN BERNARDINO Par 1.71% Value 1,774.21 2,000,000.005,000,000.005,940,000.006,605,108.94 176,930.90 68,780,949.2911,062,890.0039,425,000.00 Month Ending 138,815,722.44138,815,722.44 121,989,860.63 May 31 Reporting period 05/01/2020-05/31/2020 Run Date: 06/05/2020 - 15:28 Investments State Local Agency Investment FundManaged Pool AccountsCorporate NotesFederal Agency Issues - CouponSupranationalsTreasury Securities - CouponCertificates of DepositMoney Market Funds InvestmentsCash and Accrued InterestAccrued Interest at PurchaseSubtotalTotal Cash and InvestmentsTotal EarningsCurrent YearAverage Daily BalanceEffective Rate of Return"I certify that this report accurately reflects all pooled investments and is in conformity with the Investment Policy Statement approved by the Mayor and City Council on November 6, 2019.*Book Value is amortized Cost Basis**Market Values provided by BNY Western Trust.__________________________________________________ ____________________PAUL ESPINOZA, DIRECTOR OF FINANCE AP Date Page 1 Maturity 05/10/202309/11/202209/11/202410/30/202202/28/202508/16/202303/01/202112/23/202401/25/202310/22/202410/26/202012/13/202104/09/202102/10/202306/03/202412/16/202109/16/202109/11/202012/24/202011/29/202 111/29/202104/07/202106/11/202109/11/202001/29/2024 1111 Report Ver. 7.3.3b Portfolio CITY 832881273968147560312984563472102206546546310375102 1,0731,5631,7331,1711,6661,6041,1741,4631,337 PM (PRF_PM2) 7.3.0 Days to Maturity 360 YTM 1.3441.3441.0261.0261.9081.7321.7782.1522.2011.9041.1802.2711.7312.0961.8951.7261.5671.6181.6121.6470.8190.7731.1641.7811.9131.9261.6721.6872.5412.836 A AaAa AaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaa Moody's 1.3631.0401.9501.7001.8002.1002.0502.2001.6502.3002.6502.1251.7502.1101.6401.6001.6700.8300.7501.3751.5501.8751.8751.7501.8752.8752.875 Rate Stated 1,774.211,774.21 998,750.55998,890.00999,101.95999,569.44998,613.90999,009.45998,898.34 Book Value 1,000,441.251,000,000.001,000,000.002,016,571.741,003,371.231,000,000.001,088,491.291,000,000.001,000,000.002,015,663.591,000,000.001,000,000.001,000,000.001,000,527.001,000,447.971,001,631.211,000,7 98.771,000,000.00 68,780,949.2968,780,949.2911,106,516.06 1,774.211,774.21 988,980.00984,160.00 1,016,190.001,031,030.001,049,693.551,003,760.002,082,940.001,009,230.001,119,711.041,004,110.001,006,400.002,057,940.001,001,200.001,006,430.001,000,040.001,000,020.001,000,020.001,003,470.001,008,0 60.001,025,720.001,025,720.001,013,840.001,017,120.001,007,430.001,014,260.00 Market Value 68,780,949.2968,780,949.2911,289,804.59 1,774.211,774.21 Par Value 998,890.00 1,000,000.001,000,000.001,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,064,000.001,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,0 00.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.00 68,780,949.2968,780,949.2911,062,890.00 May 31, 2020 Date Portfolio Management Purchase Portfolio Details - Investments CITY OF SAN BERNARDINO 01/10/202012/10/201901/24/202010/30/201902/28/202010/16/201903/03/202012/23/201901/27/202010/22/201910/26/201712/31/201901/09/202002/11/202003/03/202003/16/202003/16/202011/02/201601/09/201701/19/201 702/14/201706/14/201706/22/201706/11/201801/29/2019 Balance Average 1,769.26 54,159,981.5511,107,237.30 Issuer LOCAL AGENCY INVESTMENT FUNDCALTRUST GOVT INVESTMENT FUNDAMERICAN HONDA FINANCE CORPAPPLE INCAPPLE INCBANK OF AMERICA CORPORATIONBANK OF AMERICA CORPORATIONBANK OF NEW YORK MELLON CORPJOHNSON & JOHNSONJ.P. MORGAN CHASE & COCHARLES SCHWAB CORPTOYOTA MOTOR CREDIT CORPFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL FARM CREDIT BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANK Subtotal and AverageSubtotal and AverageSubtotal and Average Investment #1000120008305593055430561305493056830547C30570305513056330548305363055530557305643056730571305723051630522305233052830534305353053930540C CUSIP State Local Agency Investment Fund SYS Managed Pool Accounts 20008 Corporate Notes 02665WDH1037833DL1037833DM906048WD7206048WH9406406FAD5478160BS248128GN97808513AT289236TGN9 Federal Agency Issues - Coupon 3133EHJ953133EH2T93133ELGK43133ELMD33133ELQU13133ELTM63133ELTL8313380WG8313381P253130AABG23130AABG23130AB5A0313379RB7313370US53130AFRQ2 Run Date: 06/05/2020 - 15:28 AP Date Page 2 Maturity 12/19/202212/23/202202/12/202503/25/202408/12/202101/26/202202/28/202209/16/202107/26/202104/26/202203/20/202407/13/202209/29/202003/29/202110/07/202110/07/202110/07/202110/07/202101/05/202201/05/202 208/21/202001/05/202203/29/202201/27/202301/28/202506/30/202008/31/202107/31/202107/31/202103/15/2021 8129 Portfolio CITY 931935437604637472420694772120301493493493493583583583666640970456425425287 1,7171,3931,3881,7021,337 PM (PRF_PM2) 7.3.0 Days to Maturity 360 YTM 1.7751.7951.7261.5291.3411.9782.0961.9731.9332.0422.8411.6271.2721.3321.4111.4011.3411.7161.9461.9941.7752.0142.1401.7361.7261.9131.8201.5011.9192.3482.5102.584 AaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaaAaa Moody's 1.8001.8201.7501.5501.1252.0002.1252.0001.8752.0002.8801.6501.2701.3501.3751.3751.3751.3752.0002.0001.8002.0002.1701.7502.0501.6252.0002.2502.2502.375 Rate Stated 997,283.32424,964.80999,059.68998,723.60999,938.54999,223.26999,411.66995,294.17999,676.25999,362.81998,551.98996,715.74998,146.34 Book Value 1,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,144.471,000,405.861,000,000.001,000,000.001,000,000.001,004,853.362,004,853.361,000,0 79.471,000,645.91 39,427,750.04 436,577.00 1,000,630.001,000,870.002,001,460.001,005,340.001,011,070.001,033,380.001,023,260.001,020,280.001,034,230.001,001,360.001,001,540.001,001,900.001,008,510.001,015,890.001,015,890.001,015,890.001,015,8 90.001,028,550.001,028,550.001,003,590.001,028,550.001,036,020.001,007,950.001,008,520.002,016,470.001,001,210.001,022,540.001,023,870.001,023,870.001,017,190.00 Market Value 39,956,897.00 Par Value 425,000.00 1,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,0 00.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.002,000,000.001,000,000.001,000,000.001,000,000.001,000,000.001,000,000.00 39,425,000.00 May 31, 2020 Date Portfolio Management Purchase Portfolio Details - Investments CITY OF SAN BERNARDINO 12/19/201912/31/201902/12/202003/25/202011/07/201601/30/201702/28/201703/16/201703/06/201711/06/201703/20/201901/13/202009/29/201609/29/201610/13/201610/31/201611/03/201611/18/201601/23/201702/02/201 702/21/201703/02/201703/29/201701/27/202003/03/202011/28/201602/21/201702/12/201806/04/201806/25/2018 Balance Average 2,004,896.13 40,105,814.75 Issuer FEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN BANKFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOFEDERAL NATIONAL MORTGAGE ASSOINTL BK RECON & DEVELOPMENTINTL BK RECON & DEVELOPMENTU.S. TREASURYU.S. TREASURYU.S. TREASURYU.S. TREASURYU.S. TREASURY Subtotal and AverageSubtotal and Average Investment #305523055630565305663051830525C30529C30530C3053130537C30541C3055830510C30512C30513305153051730519305243052630527C3053230533C30562305694000040001C400024000340004 CUSIP Federal Agency Issues - Coupon 3130AHPB33130AHRV73130AJ5F23130AJAX73137EAEC93134GAU443134GA5T73134GA5C43134G9M203134GBP553134GS5Q43134GUW553136G37C33136G4BD43135GOQ893135G0Q893135GOQ893135G0Q89 3135G0S383135G0S383136G4LA93135G0S383136G4MQ3 Supranationals 45905U5U4459058HV8 Treasury Securities - Coupon 912828XH8912828D72912828WY2912828WY29128284B3 Run Date: 06/05/2020 - 15:28 AP Date Page 3 Maturity 06/30/202112/01/202102/24/202205/30/202405/24/202104/15/202405/24/202206/03/202001/17/202306/04/202105/10/202101/31/202406/13/202402/13/202306/28/202201/13/202210/21/202102/22/202406/14/202102/23/202 201/18/202406/28/202006/17/2021 211 27 340 Portfolio CITY 324394548633357722960368343987757591507378632381761 1,4591,4141,3391,4731,3611,326 PM (PRF_PM2) 7.3.0 Days to Maturity 360 YTM 1.523 2.1721.7262.0222.1702.6142.8602.7122.4161.8253.1072.9102.8603.0082.5642.7122.7122.0221.6772.9592.9592.0223.1561.3011.7262.4660.0590.059 Moody's 1.7502.0502.2002.6502.9002.7502.4501.8503.1502.9502.9003.0502.6002.7502.7502.0501.7003.0003.0002.0503.2001.3011.7500.060 Rate Stated 248,000.00247,000.00247,000.00247,000.00246,000.00249,000.00249,000.00248,000.00245,000.00249,000.00246,000.00246,000.00247,000.00245,000.00245,000.00249,000.00247,000.00245,000.00249,000.00247,000.0 0500,000.00250,000.00249,000.00 Book Value 4,994,139.445,940,000.006,605,108.946,605,108.94 138,861,091.34 251,118.35252,967.52254,840.35270,275.58251,617.39272,847.55259,798.61248,058.16263,841.19254,821.07251,399.11271,077.54270,047.05261,686.90257,868.63255,630.99251,058.53269,950.78255,108.64254,177.5 2553,401.30250,000.00251,849.43 5,088,680.006,233,442.196,605,108.946,605,108.94 Market Value 139,973,126.22 Par Value 248,000.00247,000.00247,000.00247,000.00246,000.00249,000.00249,000.00248,000.00245,000.00249,000.00246,000.00246,000.00247,000.00245,000.00245,000.00249,000.00247,000.00245,000.00249,000.00247,000.0 0500,000.00250,000.00249,000.00 5,000,000.005,940,000.006,605,108.946,605,108.94 138,815,722.44 May 31, 2020 Date Portfolio Management Purchase Portfolio Details - Investments CITY OF SAN BERNARDINO 06/30/201612/01/201602/24/201705/30/201905/23/201804/29/201905/24/201906/03/201501/16/201906/04/201805/10/201801/31/201906/13/201902/13/201902/28/201901/13/201710/21/201602/22/201906/13/201802/23/201 701/18/201906/28/201806/17/2016 Balance Average 4,993,937.896,076,000.003,540,223.75 121,989,860.63 Issuer 1ST TECHNOLOGY FEDERAL CREDITAMERICAN EXPRESS CENTURION BKBMW BANKCAPITAL ONE NATIONAL ASSOCCITI BANK SALT LAKE CITY UTAHCOMENITY CAPITAL BANKEAGLE BANKCAPITAL ONE BANK USA NATLGOLDMAN SACHS GROUP INC.MEDALLION BANKMORGAN STANLEY BANKMORGAN STANLEY PRIVATE BANKMORGAN STANLEY PRIVATE BANKNORTHWESTERN BANKOXFORD BANK & TRUSTSTEARNS BANKSYNCHRONY BANKTIAA FSBUBS FINANCE COMMERCIAL PAPERWASHINGTON FIRST BK RESTONWELLS FARGO BK NAWELLS FARGO BANKWELLS FARGO BANKWELLS FARGO GOVT MONEY MARKET Total and Average Subtotal and AverageSubtotal and AverageSubtotal and Average Investment #800348003880041800548004380052800538002680046800448004280048800558004980051800398003680050800458004080047200338003320002 CUSIP Certificates of Deposit 33715LAD202587DM7005580AGK414042RLW917312QM2220033AU6127002YEP7140420RT938148P4B058404DCA761747MX6361760AVF361760AG52668015AL469140WAS4857894SK687165FNC487270LBU690348JC U2940727AH3949763WU616115078479497485W3 Money Market Funds SYS20002 Run Date: 06/05/2020 - 15:28 AP Page 4 0 340 Portfolio CITY PM (PRF_PM2) 7.3.0 Days to Maturity 360 YTM 1.523 Moody's Rate Stated 21,884.7221,884.72 Book Value 138,882,976.06 21,884.7221,884.72 Market Value 139,995,010.94 Par Value 138,815,722.44 May 31, 2020 Portfolio Details - Cash Date Portfolio Management Purchase Accrued Interest at PurchaseSubtotal CITY OF SAN BERNARDINO 0.00 Balance Average 121,989,860.63 Issuer Average Balance Total Cash and Investments Investment # CUSIP Run Date: 06/05/2020 - 15:28 AP Page 1 Report Ver. 7.3.3b Portfolio CITY PM (PRF_PM3) 7.3.0 Balance 1,774.21 2,004,853.364,994,139.445,940,000.006,605,108.94 68,780,949.2911,106,516.0639,427,750.04 138,861,091.34 0.000.00 750,000.00750,000.00248,000.00248,000.00 1,000,000.001,000,723.012,000,723.018,413,072.748,413,072.74 Redemptions 11,411,795.75 or Withdrawals 5.115.110.000.000.000.000.00 Purchases or Deposits 21,750,000.0021,750,000.0011,675,402.6211,675,402.6233,425,407.73 Date 05/01/202005/22/202005/18/2020 Activity By Type Transaction Portfolio Management 1.3631.0401.3752.5001.8000.060 Rate Stated CITY OF SAN BERNARDINO May 1, 2020 through May 31, 2020 Total SubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotalSubtotal IssuerLOCAL AGENCY INVESTMENT FUNDCALTRUST GOVT INVESTMENT FUNDFEDERAL HOME LOAN MORTGAGE CRPFEDERAL HOME LOAN MORTGAGE CRPJ.P. MORGAN CHASE & COWELLS FARGO GOVT MONEY MARKET Investment #10001200083052030543C8003720002 CUSIP State Local Agency Investment Fund (Monthly Summary)SYS Managed Pool Accounts (Monthly Summary)20008 Corporate NotesFederal Agency Issues - Coupon 3137EADR73134GTNN9 SupranationalsTreasury Securities - CouponCertificates of Deposit 48126XLB9 Money Market Funds (Monthly Summary)SYS20002 Run Date: 06/05/2020 - 15:28 AP 302302348340344474430452456467527431340401 Page 1 Average Report Ver. 7.3.3b Portfolio CITY PM (PRF_PM4) 7.3.0 Days to Maturity 745669792782795960869846826831898799650805 Term Average 59234022002833 Number Redeemed of Investments 31000706736003 Number Purchased of Investments Pool Rate 2.4502.4492.3792.3412.2802.1902.1032.0431.9671.9121.7301.6481.3632.066 Managed 365 1.818% 1.3721.3192.1052.0121.9981.9851.9721.9691.9291.8961.7841.7441.544 Equivalent Yield to Maturity 360 Activity Summary 1.3531.3012.0761.9841.9711.9571.9451.9421.9031.8701.7601.7201.5231.793% Portfolio Management Equivalent May 2019 through May 2020 CITY OF SAN BERNARDINO Total Invested 94,603,560.0691,198,209.0496,737,190.19 128,886,141.21124,896,967.11102,169,953.51100,006,961.73104,414,539.79116,512,135.33123,735,583.62117,383,961.74116,849,030.14138,861,091.34112,019,640.37 8577767369767478858892848180 Securities Number of Average Year 2019201920192019201920192019201920202020202020202020 MonthEnd MayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchAprilMay Run Date: 06/05/2020 - 15:28 AP 4.4%0.5%4.5%5.8%1.6%0.1% 23.9%20.8%38.3% Page 1 Average by Period Report Ver. 7.3.3b Portfolio CITY PM (PRF_PM5) 7.3.0 8.01.43.64.34.8 May 49.528.4 2020 9.51.74.35.32.9 April2020 40.935.5 9.51.74.35.33.9 2020 32.442.9 March 1.58.20.84.05.05.8 35.239.4 2020 February 4.27.80.94.35.33.4 34.839.3 2020 January 6.75.84.85.9 2019 35.841.0 December 4.25.26.4 2019 32.510.741.1 November 4.45.56.8 24.613.045.8 2019 October 5.36.5 23.725.738.9 2019 September 0.45.06.70.3 Portfolio Management 2019 49.937.8 May 2019 through May 2020 August CITY OF SAN BERNARDINO Distribution of Investments By Type 0.44.97.00.2 July 2019 49.537.9 0.30.24.05.40.2 57.332.6 2019 June 0.30.23.95.20.2 May 52.437.8 2019 Security TypeState Local Agency Investment FundManaged Pool AccountsNegotiable CD's - BankCorporate NotesFederal Agency Issues - CouponSupranationalsTreasury Securities - CouponCertificates of DepositTreasury Discounts -AmortizingMoney Market FundsCertificate Deposit-2Negotiable CDs -3 Run Date: 06/05/2020 - 15:28 AP Page 1 Report Ver. 7.3.3b Portfolio CITY PM (PRF_PM6) 7.3.0 0.000.000.000.000.000.00 5,688.215,688.21 -4,326.09-4,326.09 296,954.62768,000.21581,205.95768,714.05 1,018,588.491,064,165.771,065,527.891,832,879.821,834,241.94 ( 0.00)( 0.00)( 0.00) ( 251,377.34)( 580,492.11) Fiscal Year To Date 0.000.000.000.000.000.001.60 -723.01-723.01 -1,550.78-1,550.78 64,395.8675,500.29 289,135.44103,704.40101,430.61581,205.95179,204.69176,930.90 Month Ending ( 0.00)( 0.00)( 0.00) ( 249,826.90)( 505,707.26) May 31 May 31, 2020 Portfolio Management Interest Earnings Summary CITY OF SAN BERNARDINO Earnings during PeriodsEarnings during Periods Interest Earned during PeriodInterest Earned during PeriodInterest Earned during Period Total Earnings during Period CD/Coupon/Discount Investments:Interest CollectedPlus Accrued Interest at End of PeriodLess Accrued Interest at Beginning of PeriodLess Accrued Interest at Purchase During PeriodAdjusted by Premiums and DiscountsAdjusted by Capital Gains or LossesPass Through Securities:Interest CollectedPlus Accrued Interest at End of PeriodLess Accrued Interest at Beginning of PeriodLess Accrued Interest at Purchase During PeriodAdjusted by Premiums and DiscountsAdjusted by Capital Gains or LossesCash/Checking Accounts:Interest CollectedPlus Accrued Interest at End of PeriodLess Accrued Interest at Beginning of PeriodTotal Interest Earned during PeriodTotal Adjustments from Premiums and DiscountsTotal Capital Gains or Losses Run Date: 06/05/2020 - 15:28