The URL can be used to link to this page

Home My WebLink About2021 City Treasurer - Investment Summary Report City of Huntington Beach File #: 21-781 MEETING DATE: 11/2/2021 REQUEST FOR CITY COUNCIL ACTION SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Oliver Chi, City Manager PREPARED BY: Alisa Backstrom, City Treasurer Subject: Receive and File the City Treasurer's September 2021 Quarterly Investment Summary Report Statement of Issue: Receive and file the City Treasurer's Quarterly Investment Report for September 2021, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not applicable. Recommended Action: Receive and file the City Treasurer's Quarterly Investment Report for September 2021, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or critique the Quarterly Investment Report. Analysis: Not applicable. Environmental Status: Not applicable. Strategic Plan Goal: Non Applicable - Administrative Item Attachment(s1: 1 . Treasurer's Quarterly Investment Report for September 2021 2. Treasurer's PowerPoint Presentation for September 2021 City of Huntington Beach Page 1 of 1 Pnnted on 1027f2021 ._..f--27 ._,a.... CITY OF HUNTINGTON BEACH OFFICE OF THE CITY TREASURER QUARTERLY INVESTMENT REPORT - POOLED PORTFOLIO PERIOD ENDED: SEPTEMBER 30, 2021 PREPARED BY: ALISA BACKSTROM, MBA, CCMT, CPFIM CITY TREASURER COLIN STEVENS, MPP TREASURY ASSOCIATE 28 INVESTMENT PORTFOLIO SUMMARY: AS OF: September 30, 2021 Investment Type in 000's Market Value Book Value % of Portfolio Federal Agency Issues $ 94,899 $ 94,052 34% Local Agency Investment Fund (LAIF) $ 12,666 $ 12,666 5% Treasury Securities $ 23,914 $ 23,738 9% Medium Term Notes - Supranationals $ 35,420 $ 35,251 13% Corporate Bonds $ 42,816 $ 42,114 15% OC Investment Pool $ 65,422 $ 65,422 24% US Bank Money Market Sweep 5,044 5,044 2% TOTAL $ 280,181 $ 278,287 100% The market value of $280.2 million remains above the book value of $278.3 million. However, as interest rates rise, the prices of those securities purchased at lower than current market rates will go down. The largest holding is currently Federal Agencies at 34% followed by the Orange County Investment Pool at 24%. CUSTODY BANK ACCOUNT CHANGE DUE TO SALE BY UNION BANK: At the beginning of the quarter, US Bank purchased all of the assets of Union Bank Custody. Hence, the portfolio's custody account now resides at US Bank. US Bank does not automatically transfer excess funds to our existing operating bank account at Union Bank. This is why there is a new money market sweep fund shown above. It is planned in the future that excess funds will be immediately wired back to the Union Bank operating account and most likely, the sweep account will not hold a balance in the future. The funds in the sweep as of 9/30 were reinvested at the beginning of October. 29 INVESTMENT PORTFOLIO ACTIVITY: MONTHLY ACTIVITY: September 2021 Investment Type Purchases/ Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues $ - $ 5,000 Local Agency Investment Fund (LAIF) * $ - $ 5,000 Treasury Securities $ 11 ,000 $ - Medium Term Notes - Supranationals $ - $ - Corporate Bonds $ - $ 2,909 OC Investment Pool * $ 32 $ 3 US Bank Money Market Sweep $ 13,128 $ 8,122 TOTAL $ 24,160 $ 21 ,034 *Includes Interest Income QUARTERLY ACTIVITY: July 1 to September 30, 2021 Investment Type Purchases/ Calls/Maturities/ _C$ in 000's) Deposits Withdrawals Federal Agency Issues $ - $ 18,000 Local Agency Investment Fund (LAIF) * $ 39 $ 29,000 Treasury Securities $ 11 ,000 $ - Medium Term Notes - Supranationals $ 5,000 $ - Corporate Bonds $ - $ 2,909 OC Investment Pool * $ 92 $ 7 US Bank Money Market Sweep $ 18,326 $ 13,282 TOTAL $ 34,457 $ 63,198 *Includes Interest Income 30 INVESTMENT PORTFOLIO EARNINGS: AS OF: September 30, 2021 Total Earnings Month: September Fiscal YTD Current Year $ 235,824 $ 782,094 Current Budget $ 100,000 $ 300,000 Last Year Actual $ 296,311 $ 965,808 Average Daily Balance $ 271,196,913 $ 281,427,379 Effective Rate of Return 1 .06% 1 .10% Benchmark * 0.14% nla * 12-month moving average of interpolated 1.5-year treasury Due to the lower interest rates, the effective rate of return of the portfolio has been falling as securities with higher than market interest rates have been called or matured, and funds must be investment at the current lower rates. For example, $10 million of Federal Agency securities with a yield of 1.875% matured over the quarter. The rates available for appropriate reinvestment opportunities were under 1%. 31 The following chart shows the 2- and 5-year Treasury rates for the period September 30, 2019 to September 30, 2021 . The 2-year Treasury continues to remain near the historic low, ending the quarter at .24%. The 5-year Treasury has climbed somewhat since the beginning of 2021 , ending the third quarter at .86%. However, as compared to rates prior to the Covid- 19 outbreak, interest rates remain extremely low. These Treasury rates are proxies for the type of rates the portfolio will obtain upon investment. Treasury Rates 1.7 1.mo Lem n1 1.60 1.ma en 1.50 1.40 1.30 1.20 1.10 m 1.00 5= 0.00 s.em ,� o.e2o e.me ev.1a o.eo >eo 0.70 0.00 e e. 0 0.50 0.40 0.30 »o ZY 0220 a.2.n 0.20 0.2m glen o.uo oue 0 em n.m a.n° o.vo 0.10 2-year Treasury 5-year Treasury 32 COMPLIANCE: The portfolio is in conformity with all relevant State regulations and the City's Investment Policy statement as approved by the City Council on February 1, 2021 . The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations. MAXIMUM SPECIFIED% MINIMUM QUALITY INVESTMENT TYPE MAXIMUM MATURITY OF PORTFOLIO/MAXIMUM REQUIREMENTS IN COMPLIANCE? PERISSUER State Obligations-- CA And Others 5 years None/10% "A" Rating YES U.S. Treasury Obligations 5 years None None YES U.S. Government Agency Obligations 5 years None None YES IBRD, IFC, IADB 5 years 10% "AA" Rating YES Corporate Notes 5 years 30%/10% "A" Rating YES Local Agency Investment Fund (LAIF) N/A Up to$75,000,000 None YES Orange County Investment Pool (OCIP) NIA Up to$75,000,000 None YES Maximum Maturities I No more than 50%of portfolio maturing over 4 years. YES (Compliance is as of purchase.) 33 ECONOMIC AND MARKET SUMMARY: MARKET SUMMARY: JUNE 30, 2021 - SEPTEMBER 30, 2021 Fed Funds 2-Yr. 10-Yr. As of: Rate Treasury Treasury S&P 500 DJIA 6/30/2021 0.00 - 0.25 % 0.25% 1.45% $ 4,297.50 $ 34,502.51 9/30/2021 0.00 - 0.25 % 0.28% 1.52% 4,307.54 $ 33,843.92 %Change none 12.00% 4.83% 0.23% -1.91% The Federal Open Market Committee (FOMC) met in September to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that because of progress on vaccinations and strong policy support, indicators of economic activity and employment have continued to strengthen. Additionally, they highlighted that the sectors most adversely affected by the pandemic have improved in recent months, but the rise in COVID-19 cases has slowed their recovery. They stated, "Overall financial conditions remain accommodative, in part reflecting policy measures to support the economy and the flow of credit to U.S. households and businesses." Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 1.52%, up from 1.45% from the end of the previous quarter, for a 4.83% increase quarter-over-quarter. The S&P 500 increased by 0.23% while the DJIA fell 1.91% respectively, over the same period. Employment: Total nonfarm payroll employment rose by 194,000 in September, and the unemployment rate decreased to 4.8 percent. Notable job gains occurred in leisure and hospitality, professional and business services, retail trade, and in transportation and warehousing. NOTE: The above Treasury Rates are from the U.S. Department of the Treasury, Resource Center. They are the"Treasury Yield Curve Rates,"which is defined as follows: These rates are commonly referred to as "Constant Maturity Treasury" rates, or CMTs. Yields are interpolated by the Treasury from the daily yield curve. This curve, which relates the yield on a security to its time to maturity is based on the closing market bid yields on actively traded Treasury securities in the over-the- counter market. These market yields are calculated from composites of indicative, bid-side market quotations (not actual transactions) obtained by the Federal Reserve Bank of New York at or near 3:30 PM each trading day. The CMT yield values are read from the yield curve at fixed maturities, currently 1, 2, 3 and 6 months and 1, 2, 3, 5, 7, 10, 20, and 30 years. This method provides a yield for a 10 year maturity, for example, even if no outstanding security has exactly 10 years remaining to maturity. 34 City of Huntington Beach City of Huntington Beach 2000 Main St. Portfolio Management Huntington Beach, , ` Portfolio Summary September 30, 2021 Par Market Book %of Days to YTM YTM Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv. Federal Agency Issues-Coupon 94,000,000.00 94,898,890.00 94,052,212.80 33.80 1,589 1,182 1,215 1.232 Local Agency Investment Funds 12,66G 416.23 12,666;t16.23 12,566416.23 4.55 1 1 0.203 0.206 Treasury Securities-Coupon 24.000.000.00 23,914,140,00 23,737,531.80 8.53 1,576 1.322 1.034 1.048 Medium Term Notes-Supras 35,000,000.00 3542.0,060.00 35.251,303 77 12.67 1464 1,046 1.006 1.020 Corporate Bonds 41,684,000.00 42,815,951 A9 42,114,089.69 15.13 1,239 451 2.287 2.319 ORANGE COUNTY POOL 65421.875 47 65 421,875,47 65 421,87547 23.51 1 1 0.554 0.562 US Bank Swoop First AM Gov 5.043 750.00 5,W3,750.00 5,043 750.00 1.81 1 1 0.020 0.020 277,816,041.70 280,181,083.19 278,287,179.76 100.00% 1,045 713 1.112 1.128 Investments Cash and Accrued Interest Accrued Interest at Purchase 10,859.71 10,859.71 Subtotal 10,859.71 10,859.71 Total Cash and Investments 277,816,041.70 280,191,942.90 278,298,039.47 1,045 713 1.112 1.128 Total Earnings September 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 235.823.96 782.093.79 Current Budget 100.000.00 300,000.00 1.200.000.00 Last Year Actual 296.310.51 965,80848 3403.369.60 Average Daily Balance 271,196,912.63 281,427,379.19 Effective Rate of Return 1.06% 1.10% I certify that this report accurately reflects all City pooled investments and is in conformity with all Stale laws and the investment policy statement filed with the City Council on February 1,2021.A copy of this policy is available at the office of the City Clerk.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market Values provided by US Bank Custody. Alisa Backstrom,CITY TREASURER Reporting period 09/01/2021-09/30/2021 Portfolio CITY AP Run Data:1p20r2021 1219 Pht(PRF_PM 1)7.3.11 R.roS, .,.7.3.11 City of Huntington Beach Portfolio Management Page Portfolio Details - Investments September 30, 2021 Average- Pumhase Stated YTM Days In Maurity CUSIP Invesmlen M Isucr Balance Data Par Value Markel Value Book Value Rate S&P 365 Maturity Data Federal Agency Issues-Coupon 3133ECI I%5 4292 Federal Farm Credit Rank 05123/2019 5,000,000.00 5,221,200.00 5,002,753.06 2.260 AA 2.23E 894 03/1312024 3133EKTG1 4296 Federal Farm Cradle Rank 07101/2019 5,000,000.00 5,064,150.00 4,997,43L50 1,750 1.821 273 07/01/2022 313383QRS 4281 Federal Ilene Loan thank 12/20/2018 5.000,000.00 5.254,050.00 5,040,054.69 3.250 2.743 616 06/0912023 3130AFW%1 4285 Federal H lame Loan Bank 0212.612.019 5.000.000.00 5,19.1,400.00 5,000.000.00 2.550 Z.550 606 05130/2023 313OAKN36 4320 1 camel Herne loan Rank 01/15/2021 5,000.000,00 4.946,150.00 4,995,711.11 0.525 0.545 1,567 01115/2026 3130AKN85 4321 Federal Home Loan Bank 0112012.021 5.000.000.00 4,931,750.00 4,997.848.61 0,550 0,560 1,572 01120/2026 313OAKUS3 4322 Federal Home Loan Bank 01/2B2021 5,000,000,00 4.940.700.00 5,000,000.00 0.500 0.500 1,580 01128/2026 3130AMDL3 4327 Federal Home Loan Bank 05125120ZI 5,000.000.00 4.994.200.00 5.000.000.00 0.800 0.000 1,393 0712.5/2025 3130AMJN3 4328 Federal Ilame Loan Bank 05126/202.1 5,000,000.00 4.991,750.00 5.000,000.00 1,030 1.030 1.698 05126/2026 3130AMQ54 4331 Federal Home Loan Bank 06/1612021 5.000,000.00 4,990.950.00 5.000,000.00 0.700 0.700 1,446 09116/2025 3130AMQGZ 4332 Federal Home Lon.Bank 06/1412021 5.000.000.00 4.990,900.00 5.000.000.00 0.625 0.625 1,260 03114/2025 3130ALEY6 4333 Federal I Iona;l.oa.thank OGIIO12021 5.000,000.00 4.975.150.00 5,000,000.00 0.800 O.BQO 1,615 031041202E 3130AMWG5 4334 Federal Nome Loan Bank 0613012021 5,000,000.00 4,987,150.00 5,000,000.00 0,500 0,500 1,186 12/301202.4 313OAMFS6 4335 Fedeal Ilome Lem Batik 0641712021 5,000,000.00 4,963.100.00 4.971,738.1E 0,750 0,873 1.715 061121202E 3130AMXJG 433E Federal Ilonm Lam Rank 06/3012021 5,000,000.00 4.993.650.00 5.000.000.00 0.500 0.500 1.095 09130/2024 31371iAEN5 4287 Federal Ilama Loan Mat Cori) 0310B12019 3.000,000.00 3,128.820.00 3,014,557.69 2.750 2.450 626 06/19/2023 3137EAEN5 4288 Fedmal 11oe;Lam Mel Cori) 03/1412019 3.000.000.00 3.128.820.00 3,015,206.42 2.750 2.437 62.6 06/19/2023 313500043 4289 Fed,Nm I Mort,Assoc. 03/15/2019 5,000.000.00 5.253,550.00 5,037.542.73 2.875 ZA65 711 09/12/2023 3135GA2Z3 431E Fed.Net'I Mort.Assoc. 01/11/2021 3.000,000.00 2,978.700.00 3,002,808.59 0.560 0.537 1.508 11/17/2025 3135GO4Z3 4329 Fed.Nat'l Mort.Assoc. 05/102021 5,000.000.00 4,969,750.00 4,976.554.24 0.500 0.628 1.355 06/17/2025 Subtotal and Average 98.887,354.14 94,000,000.00 94,898,890.00 94,052.212.80 1,232 1.182 Local Agency Investment Funds SYS982 982 Lail City 12,666,416.23 12.666.416.23 12,G66,416.23 0.206 0.206 1 Subtotal and Avenge 14.666,416.23 12.666,416,23 12,666.416.23 12,666,416.23 0,206 1 Treasury Securities- Coupon 91282BY117 429B US Ima%ury Notes 12/05/2019 5.GO01000.00 5,1.16,300.00 4.986,320.2.7 1.500 AAA 1.595 1,095 09/3012024 91282SP79 4299 US Tmasmy Notes 12105/2019 3,000,000.00 3.056,490.00 2,996,933.87 1.500 AAA 1.574 515 02/2812023 912B2.CAB7 4330 US Treasury Notes 05119/2021 5,000,000.00 4,904,300.00 4,931,053.19 0,250 0.615 1,399 07/3112025 91282CCW9 4339 US Treasury Notes 09123/2021 1.000,000.00 989,300.00 993,279.95 0.750 0.890 1,79508/3112026 91282CAJO 4340 US Treasury Notes 09/27/2071 5,000,000.00 4,897,850.00 4,906,511.51 0.250 0.735 1,430 08/3112.025 91282CCP4 4341 US Treasury Note% 09/30/2021 5,000,000.00 4,919.900.00 4,923,43307 0.625 0,950 1,76407/3112026 Submml and Average 13,996,499.32 24,000,000.00 Z3.914,140.00 23,737,531.80 1.048 1,322 Porltolio CIl Y AP Ran nmc-1m2a202I.12:10 NM IPRf_VM217.9.11 36 Rehr,Ver.7.3.11 City of Huntington Beach Portfolio Management Paget Portfolio Details - Investments September 30, 2021 Average Purchase Stated YTM Days to Maltney CUSIP Investment 0 Issuor Balance Date Par Value Market Value Ronk Value gate S&P 365 Malu oy Date Medium Term Notes-Supras - 45818WB%3 4290 InlarAmencan Dev.Bank 03/28/2019 4,000.000.00 4.182.800,00 4,040,947.22 2.870 2.270 657 07/2012023 45818WBY7 4291 Inm-Amaican Dev.Bank 03/28/2019 5,000,000.00 5.245.000.00 5,061.147.81 2.960 2.271 684 08/16/2023 45818WCTI 4312 Inter-American Dev.Bank 04/29/2020 G.000.000.00 6,090,GG0.00 6.083,087.89 1.600 0.550 486 01/30/2023 459058JLB 4319 In11 Blk Recon R Development 01/12/2021 5.000,000,00 4.933.250.00 4.997,662.6G 0.500 AAA 0.512 1,488 10/28/2025 45905611V2 4323 h111 Bk ReconR Development 04/23/2021 1,000,000.00 5.135.750.00 5,155,008.13 1.500 AAA 0,425 1,062 08128/2024 45906M21.4 4324 Intl Bk Recon R Development 04/30/2021 5,000,000.00 4,908,000.00 4,952,710.84 0.650 AAA 0.870 1,607 02/24/2026 459058JE4 4338 Intl Bk Recon R Devr-loprnent 07/30/7021 5,000000.00 4.924.600.00 4,960,739.22 0.375 AAA 0.583 1.396 0712812.025 StAnolal and Avoiagc 35,257,324.39 35,000,000.00 35.420,060.00 35,251,303.77 1.020 1.046 Corporate Bonds 037833DF7 4313 Apple Inc. 04/2912020 5,000,000.00 5,129.450.00 5.103,309.65 2.400 0.720 469 01/13/2023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5.211.900.00 5,051.069.05 3.191 AA 2.528 631 06/24/2.023 254687CRS 4300 Disney 12/16/2019 2,875,000,DO 3.081,885.00 2,981.153.85 4.000 2.070 730 10/01/2023 437076BGB 4293 Herne Depot Inc 0512.12019 5,000,000.00 5,069.850.00 5.004.691.81 2.625 A 2.474 243 06/01/2022 45920011G9 4274 IBM CorP 09/28/2018 3,000,000,00 3.039,990.00 2.966.485.90 1.875 A 3,257 304 08/01/2022 71344BC%4 4280 PEPSICO INC 12/21/2018 5,000000,00 5,090,250.00 4.997.742.69 3.100 3.160 289 07/17/2022 882508BAl 4279 Texas lastnnnent,Inc 12/21/2018 5,000000.00 5,045.150.00 4.964.048.37 1.850 3.564 226 05/15/2022 904764AW7 4286 Unilever 0310112019 SD00.000,00 5,050,250.00 4.982.967.92 2.2.00 2.802 216 05/05/2022 9033111NV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,106,880.00 2.059.220.16 3.400 AA 1.671 661 07/24/2023 9 1 1 5 91111xl 4325 US Bank NA Cincinnati 04/30/2021 3.809.000.00 3,990,3.6.49 4,003,400.29 2.400 0.528 1.033 07/30/2024 Subtotal and Average 42.119,807.66 41,684,000.00 42,815,951.49 42,11.4,089.69 2.319 451 ORANGE COUNTY POOL OCPI 01 Orange Comity II1Velt P001 65,421,875A7 65.421.875.47 65.421.875.47 0562 0.562 1 Subtotal an<I Avem9e 65,390,791.40 65,421,875.47 65,421,875.47 65,421,87S.•17 0.562 1 US Bank Sweep First AM Gov FAMI 02 First American 08101/2021 5,043.7 50 00 5,043,750.00 5,043.750.00 0.02.0 0.020 1 Sub101al and Average 878,719.48 5.043,750.00 5,0.13,750.00 5,043,750,00 0,020 1 Total and Average 271,196,912.63 277,816,041.70 280,181,083.19 278,287.179.76 1.128 713 Porttolio CIT Y All aun nn, 1m2a2021.12:19 PM(I'Itl'_PM2)7.3.11 37 City of Huntington Beach Portfolio Management Page Portfolio Details - Cash September 30, 2021 Average Purchase Slated YTM Daysto CUSIP Investment I Issuer Balance Date Par Value Market Value Book Value Rmr. S&P 385 Maturity Average Balance 0.00 Accmml Interest a1 Purchase 10,859.71 10,859.71 0 Subtotal 10,859.71 10.859.7I Total Cash and Investments 271,196,912.63 277,816,041.70 280,191,942.90 278,298,039.47 1.128 713 Portfolio C I T Y AP R.,()ive.Ia2a2021.12.19 PM IPar PM2)7.3 11 38 City of Huntington Beach Portfolio Management Pa ge1 Activity By Type September 1, 2021 through September 30, 2021 Slated Irausaction Purchases Redemptions CUSIP Invest..lent 0 Issuer Rate Dale or Deposits of Withdrawals Balance Federal Agency Issues-Coupon 3130AMX09 4337 federal I1ome Loan Bonk 1,100 09/3012021 0.00 5,000,000.00 Subtotal 0.00 5,000,000.00 94.052.212.80 Local Agency Investment Funds (Monthly SUlumary) SYS982 982 Lad Cay 0.206 0,00 5.000.000.00 Sublot:d 0,00 5,000,000.00 12,666,416.23 Treasury Securities-Coupon — 91282CCW9 4339 US Treasury Notes 0.750 09/2312021 993,250.00 0.00 91202CAJO 4340 US Treasury Notes 0.250 0912.712021 4,906,250,00 0,00 91282CCP4 4341 US Treasury Noun 0.G25 09130/2021 4,923,389.60 0.00 Sub08al 10,822,889.60 0.00 23,737,531.80 Medium Term Notes-Suprls Su total 35,251,303.77 Corporate Bonds 37555BAU7 4315 Gilead Sciences 4.400 09/01IZ021 0.00 2,909,439.99 Subtotal 0.00 2,909,439,99 42.114.089.69 ORANGE COUNTY POOL (Monthly Summary) OCP7 01 Orange County Invest Pool 0562 32,155.93 3.224A3 Subtotal 32A55.93 3,224.43 65,421,875A7 US Bank Sweep First AM Gov (Monthly Summary) FAM1 02 First Arrlerican 0.020 13,128,458.31 8,1ZZ,208.31 Subtotal 13,126,458.31 8,122,208.31 5.043.750.00 Total 23,983,503.84 21,034,872.73 278.287.179.7E Portfolio CITY AP Run Dale 11V N2(121 12:19 PMV1'_PMI)7.3,11 Repurl W,7.3,11 City of Huntington Beach Portfolio Management Page 1 Activity Summary September 2020 through September 2021 Y1011 to WIL"Ity - - - -- -- -- -- Managed Number Number Month Number of Average 360 365 Pool of Investments of Investments Awnago Average CM year Sopalhoti Balance 6r uivulenl f_t uiv:denl I 1 Rau: Purrh0sed Redeemed lcrm Dtrys to Maturity September 2020 39 2 25,4 47,508.77 1.594 1.616 0.685 0 1 935 606 October 2020 38 216,81 5J 17.12 1.629 1.652 0.620 0 6 885 516 November 2020 32 205,158,091.48 1,491 1.512 0.576 0 1 725 396 December 2020 31 221,313,362.71 1.387 1,406 0.540 0 0 680 355 January 2021 36 245,184,705.47 1.292 1.310 0.458 5 2 798 474 February 2021 34 244,848,561.08 1.338 1.356 0.407 0 0 821 471 March 2021 34 241,726,743.55 1.272 1.290 0.357 0 1 812 451 April 2021 37 245,258,735.71 1.187 1,203 0.339 4 0 833 488 May 2021 41 272,220,547.80 1.102 1.117 0.315 4 1 832 529 June 2021 47 299,541,338.17 1.096 1.111 0.262 7 1 965 667 July 2021 47 294,084,830.06 1.128 1.144 0.221 1 2 1,019 705 August 2021 46 278,670,379.83 1.133 1A49 0.221 1 1 1,032 711 Septernber 2021 48 271,196,912.63 1.112 1.128 0.206 3 2 1,045 713 Average 39 250,947,654.67 1.289% 1.307% 0.401 2 1 876 545 Portfolio CITY AP R Dam'IN2012021-12:1J PM IPRr_PMd)7.3,11 4Q:1„xl Vrv.7.3.11 City of Huntington Beach Portfolio Management Pagel Interest Earnings Summary September 30, 2021 September 301VIonth Ending Fiscal Year To Date CD/Coupon/Discount Investments: - Interest Collected 243.538.83 889,496.89 Plus Accrued Interest at End of Period 666,282.09 666,282.09 Less Accrued Interest at Beginning of Period ( 659,599.13) ( 764,664.92) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 250,221.79 791,114.06 Adjusted by Premiums and Discounts .25,660.71 -94,031.58 Adjusted by Capital Gains or Losses -21,439.99 .21.439.99 Earnings during Periods 203.121.09 675,642.49 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0,00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 32,158.74 131,507.86 Plus Accrued Interest at End of Period 15,148.28 15,148.28 Less Accrued Interest at Beginning of Period ( 14,604,15) ( 40,204.84) Interest Earned during Period 32,702.87 106.451.30 Total Interest Earned during Period 282,924.66 897,565.36 Total Adjustments from Prerniurns and Discounts .25,660.71 -94,031.58 Total Capital Gains or Losses -21.439.99 -21,439.99 Total Earnings during Period 235.823.96 782,093.79 Portfolio CITY AP R.n b:nc:1 WZW2021 12:19 PM(1,111' mi)7.3 11 441�1 Wn.7.3,11 ooa�.\\NVESJMFy� State of California W n Pooled Money Investment Account o � �c Market Valuation 9/30/2021 Carrying Cost Plus Description Accrued Interest Purch. Amortized Cost Fair Value Accrued Interest United States Treasury: Bills S 56,178,200,257.59 S 56,190,154,704.02 $ 56,190,711,000.00 NA Notes $ 64,903,468,222.78 S 64,898,238,504.73 S 64,882,239,000.00 S 96,896,205.00 Federal Agency: SBA S 389,722,901.42 S 389,722,901.42 S 390,563,174.44 $ 165,306.70 MBS-REMICs S 8,242,650.31 S 8,242,650.31 S 8,623,428.04 $ 37,961.86 Debentures S 9,877,200,898.64 $ 9,876,875,537.54 $ 9,876,830,100.00 $ 9,519,348.90 Debentures FIR S - $ - S - $ - Debentures CL $ 1,100,000,000.00 S 1,100,000,000.00 S 1,097,313,000.00 S 923,444.00 Discount Notes $ 15,471,384,294.40 S 15,473,204,097.13 S 15,472,922,250.00 NA Su ranational Debentures S 1,820,961,152.12 S 1,819,806,638.22 S 1,816,063,500.00 $ 5,542,182.50 Su ranational Debentures FIR $ 150,005,722.97 S 150,005,722.97 S 150,017,723.77 S 15,371.87 CDs and YCDs FIR S 100,000,000.00 $ 100,000,000.00 S 100,000,000.00 S 7,166.67 Bank Notes $ 50,000,000.00 S 50,000,000.00 S 49,983,680.43 S 16,527.78 CDs and YCDs S 14,100,000,000.00 S 14,100,000,000.00 S 14,099,163,132A8 S 5,531,263.95 Commercial Paper S 10,063,885,800.03 $ 10,066,693,445.87 $ 10,066,706,706.27 NA Corporate: Bonds FIR $ S $ S Bonds S 164,758,989.17 S 164,612,550.28 $ 163,795,910.00 S 803,887.31 Repurchase Agreements S S $ - S - Reverse Repurchase S - S - S - $ - Time Deposits S 3,911,500,000.00 5 3,211,500,000.00 S 3,911,500,000.00 NA PMIA & GF Loans S 775,298,000.00 S 775,298,000.00 S 775,298,000.00 NA TOTAL S 179,064,628,889.43 1 S 179,074,354,752.49 S 179,051,730,605.43 S 119,458,666.54 Fair Value Including Accrued Interest S 179,171,189,271.97 Repurchase Agreements, Time Deposits, PMIA &General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). The value of each participating dollar equals the fair value divided by the amortized cost (0.999873661). As an example: if an agency has an account balance of 520,000,000.00, then the agency would report its participation in the LAIF valued at$19,997,473.21 or$20,000,000.00 x 0.999873661. 42 Statement of Cash Receipts and Disbursements and Summary of Cash by Fund 0Finance Department September 2021 Cash Receipts and Disbursements August 2021 September 2021 Receipts General Fund Property Tax $ 107,878 $ 1,148,137 Local Sales Tax 3,729,154 4,268,907 Public Safety Sales Tax 267,093 235,927 Transient Occupancy Tax(TOT) 2,139,111 1,624,948 Utility Users Tax(UUT) 1,605,008 1,517,723 Other Revenue 6,901,249 4,363,482 Total General Fund Revenue 14,749 493 13,159,123 Total All Other Funds Revenue 11,974,918 29,773,266 Total Receipts $ 26.724,412 $ 42,932,389 Disbursements General Fund Personnel Services (12,323,999) (23,284,375) Operating Expenses (4,508,651) (3,511,735) Capital Expenditures - - Non-Operating Expenses (945,227) - Total General Fund Disbursements (17,777,877) (26,796,110) Total All Other Funds Disbursements (18,956,596) (16,753,730) Total Disbursements (36,734,474) (43,549,840) Net Change in Cash Flow $ (10,010,062) $ (617,451) Summary of Cash by Fund August 2021 September 2021 General Fund $ 66,766,290 5 53,129,303 General Fund Other 5,671,888 3,131,344 Capital Projects Funds 26,675,603 25486,604 Debt Service Funds 19,209,597 35,764,690 Enterprise Funds 75,630,145 76,915,178 Trust and Agency Funds 10,809,445 8,669,076 Internal Service Funds 29,019,743 28,810,952 Special Revenue Funds 50,331,115 51,589,227 General Ledger Cash Balances $ 284,113,824 $ 283,496,374 Total wsh will differ from investment portfolio total due to outstanding checks andlor other timing differences. Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 43 City of Huntington Beach City of Huntington Beach 2000 Main St. Portfolio Management Huntington Beach, Portfolio Summary August 31, 2021 Par Market Book 8G of Days to YTM YTM I1Veti111LL ItS Value Value Value Pordolio Penn Maturity 360 Equi, 365 Eq.., Federal Agency Issues-Coupon 99,000,000.00 100,195,e110.00 99,055,953.50 3597 1,601 1,240 1.209 1.226 Local Agency 6wesvnent Funds 17,666,416.23 17,666,416.23 17,666,416.23 6 42. 1 1 0.218 0.221 Treasury Securities Coupon 13,000,Doo.00 13.158.180.00 12,912,275.47 4,69 1.540 1.106 1,199 1.216 Medium Tenn Notes 35,000,000.00 35.584.160.00 35,263,760.23 12.81 1,464 1,076 1.006 1.020 Corporate Bonds 44.578000.00 45,797.252,35 45.035,350L96 16.35 1,197 456 2,227 2.258 ORANGE COUNTY POOL 65,392,943.97 65,392,943.97 65,392,943.97 23.75 1 1 0,567 0.575 US Bank Sweep first AM Gov 37,500.00 37.500.00 37.500.00 0.01 1 1 0.020 0.020 274,668,860.20 277,832,332.55 275,364,209.36 100.00% 1,032 711 1,133 1.149 In Ve51r11eutS Cash and Accrued Interest Accrued Interest at Purchase 14,937.51 14,937.51 Subtotal 14.937.51 14,937.51 Tolal Cash and Investments 274,668,860,20 277,847,270.06 275,379,146.87 1,032 711 1,133 1.149 Total Earnings August 31 Month Ending Fiscal Year To Dale Fiscal Year Ending Current Year 267,048.48 546,267.06 Current Budget 100,000.00 200,000.00 1,200,000.00 Last Year Actual 321,646.08 669,497.97 3.403.369.60 Average Daily Balance 278.67O,379.83 286,377,604.95 Effective R.102 of Return 1.13% 1.12% 1 certify that this report accurately reflects all City pooled investments and is in conformity with all Slate laws and the investment policy statement filed with the City Council on February 1.2021.A copy of this policy is available at the office of the City Clerk.The investment program herein shown provides sufficient cash Now liquidity to meet the next six month's obligations. Market Values provided by Union Bank via Interactive Data Corporation. Alisa Backstrom, CITY TREASURER Reporting period 08/01/2021-08/31/2021 Portfolio CITY AP Run Ilan:091.100021 11129 PM IVRF_PM117.3.11 Rgwn 44 7.3 11 City of Huntington Beach Portfolio Management Page Portfolio Details - Investments August 31, 2021 Avenge Pun:hnse Stated YTM Days to Maturity CUSIP Investment N h:wer Balance Data Par Value M:u kel V:dun Book Value Rate S&P 365 Maturity Date Federal Agency Issues-Coupon 3133ECIIX5 4292 Fednml Farm Credit flank 05/23/2019 5.000.000.00 5.242.750,00 5,002,846.71 2.260 AA 2..236 924 03/13/2024 3133EKTGI 4296 Fetlonl Farm Credit(lank 07/01/2019 5,000,000.00 5,070,600.00 4,997.152.78 1.750 1.821 303 07/01/2022 313383QR5 4281 Federal Home loan flank 12/20/2018 5.000,000.00 5.270,150.00 5.042.031,08 3.250 2.743 646 06/09/2073 313OAFWX1 4285 Federal Home Loan Bank 02/26/2019 5.000.000.00 5.208,150.00 5,000,000.00 2.550 2.550 636 05/30/2023 313OAKN36 4320 Federal llonro Loan Bank 01/15/2021 5,000,000.00 4,964,950.00 4,995.627.78 0.525 Q545 1.597 01/15/2.026 313OAKN85 4321 Federal Home.Loan Bank 01/20/2021 5,000,000.00 4,967,700.00 4,997.806.94 0.550 O.SGO 1.602 01/20/2026 3130AKUS3 432.2 Federal litre Loan Bank 01/28/2021 5,000,000.00 4.960,500.00 5.000,000.00 0.500 0.500 1,610 01/2B/2026 3130AMDL3 432.7 Fadmal(lame Loan Bank 05/25/2021 5.000.000.00 5.001,550.00 5.000.000.00 0,800 0.800 1.423 07/25/2025 3130AMJN3 4320 Fedeml flame Loan Bank 05/2612021 5.01.00 5.000,950.00 5,000,000.00 1.030 1,030 1.728 05/2612.026 3130AMQ54 4331 Federal l lome Loan Bank OGM 612021 5.000.000.00 5,007,300.00 5.000.000.00 0.700 0.700 1.476 09116/2.025 3130AM062 4332 Federal llome Loan Bank 06/1412021 5.000,000.00 4,998.700.00 5,000.000.00 0.625 0 625 1.290 03114/2025 3130ALEY6 4333 Federal Ilome Loan Bank 06/1012021 5,000,000.00 4,989,550.00 5,000.000.00 0.800 0,800 1_645 0310412.026 3130AMWGS 4334 Forler:d Iloran Loan Bank 06/3012021 5,000.000.00 4,994,950.00 5,000.000.00 0,500 0.500 1,216 12/30/2024 3130AMFS6 4335 Federal Ilome Loan Bank 06117/2021 5,000,000.00 4,998,650.00 4.971,236.77 0.750 0,873 1.745 06112/2026 3130AMXJ6 4335 Federal Ilome Loan Bank OW3012021 5,000,000.00 4,99ll 950.00 5,000,000.00 0.500 0.500 1,125 09130/2024 3130AMXD9 4337 Federal Iloine Loan Bank 0613012021 5.000.000.00 5,000,500.00 5.000.000.00 1.100 1.100 1,763 06/3012026 31371f AEN5 4287 Federal Home Loan Mort Core 03/0812019 3,000,000.00 3,136.770.00 3.015,264.37 2.750 2.450 656 06/1912.023 3137EAEN5 4288 Federal Ilontc Loam Mori Cori) 03/1412019 3,000,000.00 3,136,170.00 3,015,944.60 2.750 2.437 656 06/19/2023 3135GOU43 4289 Fed.Nnl'I Mori.Assoc. 03/1512019 5,000.000.00 5.268,200.00 5.039,149.41 2.875 2.465 741 09112/2023 3135GA2.Z3 4318 Fed.Nial Mort,Assoc. 01/11/2021 3.000,000.00 2,991.090.00 3.002,865.29 0.560 0537 1,538 11/17/2025 3135GO4Z3 4329 Fed,Will Mort Assoc. 05/14/2021 5.000,000.00 4,987.150.00 4,976,027.77 0.500 0,628 1.385 06/17/2025 Subtotal and Avernga 101.638.421.47 09.000.000.00 100.195,880.00 99,055,953.50 1,226 1,240 Local Agency 1l1VGSU1101ll Funds - SYS982. 982 Lail City 17.666,416.2.3 17.666,416.23 17,666,41G.23 0.221 0.221 1 Subtotal and Avenge 18.440,609.78 17.666,416.23 17,666,416.23 17,666,416.23 0.221 1 I reasury SeCU11005-Coupon 912828YH7 4293 US Treasury Note, 12/052019 5.000.000.00 5,165,800.00 4.985,945.49 1.500 AAA 1,595 1,125 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3.000,000.00 3.060.030.00 2.996,755.27 1.500 AAA 1.574 545 02/2.8/2.02.3 91282CAB7 4330 US Treasury Notes 05/19/2021 5.000.000.00 4.931,450.00 4,9Z9.574.71 0.250 0,615 1,429 07/31/2025 Subtotal and Avmage 12,911259,52 13,000.000.00 13,158,180.00 12,912.275A7 1.216 1,106 Medium Tenn Notes 45818WBX3 4290 Intia-American Dev.Bank 03/28/2019 4,0W,000.00 4,197.360.00 4,042.840.00 2.870 2.270 687 0712.012023 45818WBYI 4291 Inter-Ammicmi Dev.flank 03/28/2019 5.000,000.00 5,264,200.00 5,063,BG5.49 2.960 2.271 714 08/1612023 Portfolio CITY AP Ron De" 0a13012021.11:29 PM IPRI'_NM217.3.11 45 Reixxi Ver.7.3.11 City of Huntington Beach Portfolio Management Paget Portfolio Details - Investments August 31, 2021 Avpraye Purchase Staled YTM Daryl to Maturity CUSIP Investment 9 Issuer Balance Dan., Part Value Market Value 600k Value Raw S&P 365 Malurily Can, Medium Term Notes 45818WCTI 4312 loll',-Auunicl111 De,Dank 042912.020 6,000,000.00 6,103.500.00 G.088,291.73 1.600 0.550 516 0113012023 459058A.8 4319 Intl Bk Recon R Development 01/1212021 5,ODO,W0.00 4,962.850.00 4,997,614.86 0.500 AAA 0.512 1.518 10/2812025 459056HV2 4323 Intl Bk Recon B Development 04/2312021 5,000,000.00 5.155.050.00 5,159,449.63 1.500 AAA 0.425 1,092 08/282024 45906M21 4 4324 Intl Bk Roaon 8 Development 003012021 5,000,000.00 4,952.300.00 4,951.81065 0.650 AAA 0.870 1,1337 02/24/2026 459058JI74 4338 Intl Bk Recon 8 Development 07/3012021 5,000,000.00 4,948,900.00 4,959,883.87 0.375 AAA 0.583 1.426 07/2812025 Subtotal and Average 35,269,592.22 35,000,000.00 35,5B4,160.00 35,263,760.2.3 1.020 1.076 Corporate B011rlti 037833DE7 4313 Apple Inc. 0412.912020 5,000.000.00 5,131.200.00 5,110,018.07 2.400 0.720 499 01/13/2023 166764AH3 4294 Chevron Corp 05/2412019 5,000,00(1.00 5.226,800.00 5.053,52B.23 3.191 AA 2,528 661 0612412023 2.54687CR5 4300 Disney 12/1612019 2,875,000.00 3,085,766.25 2,985,576.92 4.000 2.070 760 10/0112023 37555BAU7 4315 Gilead Sciences 04/3012020 2,888,000.00 2,8138.000.00 2,909,439.99 4.400 1.387 91 12/0112021 4370766156 4293 Horm:Depot Inc 05/2412019 5,000,000.00 5,081,600.00 5,005.278.29 2.625 A 2A74 273 06/0112022 45920011G9 4274 IBM Corp 09/2812018 3,000.000.00 3.04G.590.00 2,963,134.49 1.875 A 3.257 234 08JO112022. 713448C%4 4280 PEPSICO INC 12/2112018 5,000,000.00 5.103,150.00 4,997.505,91 3.100 3.160 319 07117/2022 B82508BA7 4279 Texas lnsbumenls Inc 12/2112018 5.000,000.00 5,051,550.00 4,959,233.42. 1.850 3.564 256 0511512022 904764AW7 4286 Unilever 03/0112.019 5,00D,000.00 5.059,000.00 4,980,580.24 2.200 2.802 246 05/0512022 90331HNV1 4306 US Bank NA Cincinnati 02/2112020 2.000.000.00 2,113,100.00 2.061,940.84 3.400 AA 1.671 691 07/24/2023 91159HH%1 4325 US Bank NA Cincinnati 0413012021 3,809.000.00 4,010.4913.10 4,009,123.56 2.400 0.528 1.063 0713012024 Subtotal and Avenge 45.044,242.43 4.1,572.000.00 4 5,797,2 52.35 45,035,359.96 2.258 456 Of2ANGE COUNTY POOL OCPI 01 Orange County Invest Pool 65,392,943.97 65.392,943.97 65,392,943.97 0.575 0.575 1 Sub crud and Averule. 65,363,835.07 65,392,943.97 65,392,943.97 65,392.943,97 0.575 1 US Bank Sweep First AM Gov FAMI 02 Firs[A....n rau 08/0112021 37.500.00 37,500.00 37,500.00 0,020 0,020 1 Subtotal;m<I Average 2.419.35 37,500.00 37,500.00 37,500,00 0.020 1 Total and Average 278.670.379.83 274,668,8G0.20 277,832,332.55 275,364,209.36 1,149 711 Portfolio CITY AP Ihin Orti..0913aza21 11 29 nM(PRI' PM2)7.3.11 46 City of Huntington Beach Portfolio Management Page Portfolio Details - Cash August 31, 2021 Avcraye Porclwse Stated YIM Days to CUSIP Investment a Issuer Balance Date Par Value Mark.![Value Book Value Raw S&P 365 Maturity Average Balance 0,00 ACQOCI Inures)at Purchase 14,937.51 14.937.51 0 Submtal 14,937.51 14,937.51 I out Cash and Iovesunen15 278,670,379.83 274,668,860.20 277,847,270.06 275,379,146.87 1.149 711 Portfolio CITY AP uwi nac:WM2021 11 29 PM(1'Itl'yM1)7.1.11 47 City of Huntington Beach Portfolio Management Activity By Type Pane 3 August 1, 2021 through August 31, 2021 Slated Transaction Purchases Rudenlp0ons CUSIP Investment N Issuer Rate Date or Oeposas or Withdrawals Balance Federal Agency Issues- Coupon 3134G92Y2 4250 14Mcral Flume Loan Mon Corp 1,875 08/17/2021 0.00 5,000,W0.00 Subtotal 0.00 5,000,000.00 99,055,953.50 Local Agency Investment Funds (Monthly Summary) SYS982 982 Lail City 0.22.1 0.00 6,000,000.00 Subtotal 0.00 6,000,000.00 17,666,416.Z3 Treasury Securities-Coupon Subtotal 12,912,275.47 Medium Term Notes Subtot:d 35,263,7W.23 Corporate Bonds Subonat 45,035,359.06 ORANGE COUNTY POOL (Monthly Summary) OCPI 01 Orange County Invest Pool 0.575 31,22.7.55 3.223.02 Subtotal 31,2.27.55 3.223.02 65,392,943.97 US Bank Sweep First AM Gov (Monthly Sunvnnry) PAM1 02 fiat American 0.020 5,197,126.00 5,159,626.00 sotn"I d 5,197,126.00 5.159.626.00 37.500.00 T uud 5,228,353.55 16,162,849.02. 27 5,364.209.36 Portfolio CITY AP R.tLtic:M13N2021 11:29 W(1441_PM3)7.3.11 ri".Vnr.13.11 City of Huntington Beach Portfolio Management page Activity Summary August 2020 through August 2021 Yield to Mal'alty Managed Number Number Month Nurn la,of Avcrl9e 360 365 Pool of Investments of Investments Avemgc Average End Year Sena os Balance Equivalent Equivalent Rate Purchased Redoeme<I Turrn flays to Maluray August 2020 40 238,570,893.05 1.582 1.604 0.784 0 1 917 621 September 2020 39 225,447,508.77 1.594 1.616 0.685 0 1 935 606 October 2020 38 216,B15,117.12 1.629 1.652 0.620 0 6 885 516 November 2020 32 205,158,091.48 1.491 1.512 0.576 0 1 725 396 December 2020 31 221,313,362.71 1.387 1.406 0.540 0 0 680 355 January 2021 36 245,184,705.47 1.292 1.310 0.458 5 2 798 474 February 2021 34 244,848,561.08 1M8 1.356 0.407 0 0 821 471 March 2021 34 241,726,743.55 1.272 1.290 0.357 0 1 812 451 April 2021 37 245,258,735.71 1.187 1.203 0.339 4 0 833 488 May 2021 41 272,220,547.80 1.102 1A17 0.315 4 1 832 529 June 2021 47 290,541,338.17 1.096 1.111 0,262 7 1 965 667 July 2021 47 294,084,830.06 1.132 1.148 0.262 1 2 1.019 705 August 2021 46 278,670,379.83 1.133 1.149 0.221 1 1 1,032 711 Average 39 248.444,732.07 1.326% 1.344% 0.448 2 1 866 538 Portfolio CITY AP Run bat",e913tl2W 1-11-.29 PM(f Rb PM4)7.3.11 Rclmrt Vw.7A.11 City of Huntington Beach Portfolio Management Page Interest Earnings Summary August 31, 2021 August 311VIonth Ending Fiscal Year To Date CDICoupon/Discount Investments: Interest Collected 210,354.06 645,958.06 Plus Accrued Interest at End of Period 659,599.13 659,599.13 Less Accrued Interest at Beginning of Period ( 604,910.11) ( 764,664.92) Less Accrued Interest at Purchase- During Period ( 0.00) ( 0.00) Interest Earned during Period 265.043.08 540,892.27 Adjusted by Premiurns and Discounts -33,376.75 -68,370.87 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 231,666.33 472,521.40 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 31.227.55 99.349.12 Plus Accrued Interest at Eric]of Period 14.601.38 14,601.38 Less Accrued Interest at Beginning of Period ( 10.446.78) ( 40,204.84) Interest Earned during Period 35,382.15 73,745.66 Total Interest Earned(]tiring Period 300.425.23 614,637.93 Total Adjustments from Premiums and Discounts -33,376.75 -68,370.87 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 267,048.48 546,267.06 Portfolio CITY AP Run Duw:W13e12071 I:79 1'M(1'10r PMG)7.3,11 R Qr(W,.7.3.11 �o�EytNVESI,HFyv State of California c Pooled Money Investment Account Market Valuation 8/31/2021 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Bills S 60,078,370,143.61 S 60,089,880,500.00 NA Notes $ 60,998,985,911.35 S 61,030,182,500.00 S 83,107,709.50 Federal Agency: SBA S 397,327,909.05 $ 398,232,393.99 S 168,584.22 MBS-REMICs $ 8,584,731.55 S 8,983,275.91 S 39,496.64 Debentures S 9,031,220,254.41 S 9,033,552,490.00 S 8,565,525.56 Debentures FIR S - S - S Debentures CL $ 1,200,000,000.00 S 1,199,591,000.00 S 1,059,224.00 Discount Notes S 14,721,306,633.33 S 14,723,243,750.00 NA Su ranational Debentures S 1,974,696,354.19 S 1,969,864,000.00 S 4,939,748.00 Supranational Debentures FIR $ 150,012,560.81 S 150,024,561.94 S 34,705.41 CDs and YCDs FIR $ 300,000,000.00 S 300,001,000.00 S 55,151.20 Bank Notes $ 50,000,000.00 S 49,959,560.18 S 12,361.11 CDs and YCDs S 14,250,000,000.00 S 14,249,800,866.00 S 6,012,013.89 Commercial Paper $ 8,814,411,834.74 S 8,817,998,190.24 NA Corporate: Bonds FIR S - $ - S Bonds S 140,297,832.40 S 139,825,910.00 S 509,734.98 Repurchase Agreements $ S S Reverse Repurchase S S - S Time Deposits S 3,805,000,000.00 S 3,805,000,000.00 NA PMIA & GF Loans S 764,052,000.00 S 764,052,000.00 NA TOTAL S 176,684,266,165.44 S 176,730,191,998.26 1 S 104,504,254.51 Fair Value Including Accrued Interest S 176,834,696,252.77 Repurchase Agreements, Time Deposits, PMIA& General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). 51 0 Statement of Cash Receipts and Disbursements and Summary of Cash by Fund +.-; : Finance Department August 2021 Cash Receipts and Disbursements July 2021 August 2021 Receipts General Fund Property Tax $ 816,898 5 107,878 Local Sales Tax 4,635,064 3,729,154 Public Safety Sales Tax 212,665 267,093 Transient Occupancy Tax(TOT) 1,693,417 2,139,111 Utility Users Tax(UUT) 1,561,786 1,605,008 Other Revenue 14,641,865 6,901,249 Total General Fund Revenue 23,561,696 14,749,493 Total All Other Funds Revenue 22,752,466 11,974,918 Total Receipts S 46,314,161 S 26,724,412 Disbursements General Fund Personnel Services (19,551,241) (12,323,999) Operating Expenses (3,097,137) (4,508,651) Capital Expenditures - - Non-Operating Expenses (2,148,796) (945,227) Total General Fund Disbursements (24,797,174) (17,777,877) Total All Other Funds Disbursements (40,188,489) (18,956,596) Total Disbursements (64,985,663) (36,734,474) Net Change in Cash Flow $ (18.671,501) $ (10,010,062) Summary of Cash by Fund July 2021 August 2021 General Fund $ 75,762,287 $ 72,733,903 General Fund Other 5,636,231 5,614,360 Capital Projects Funds 23,959,968 23,016,666 Debt Service Funds 19,576,520 18,712,402 Enterprise Funds 74,587,031 75,351,871 Trust and Agency Funds 12,705,127 10,564,566 Internal Service Funds 30,470,042 27,722,398 Special Revenue Funds 51,426,978 50,397,956 General Ledger Cash Balances $ 294,124,184 S 284,114,122 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 52 , City of Fluntington Beach City of Huntington Beach 2000 Main St. Portfolio Management nntingten Belch' 7 ' Portfolio Summary July 31, 2021 Par Market Book %nl Days to Y TM YTM Investments Value Value Value Portfolio Tenn Maturi ly 360 Eq...v. 365 Equiv. Fede,al Agency Issues-Coupon 104.000.000.00 105,325,890,00 104.059,996,51 36.34 1,597 1,211 1.233 1.250 Local Agency Investment Funds 23.666.416,23 23,666,416.23 23,666,416.23 8.27 1 1 0.258 0.262 Treasury Securities Coupon 13.000,0DO.00 13,180.840,00 12.,910,175.85 4.51 1.5.40 1,137 1.200 1.216 Medium Tcun Notes 35.000.000,00 35,656,810,00 35.276.216.65 12.32 1,464 1.107 1.006 1.020 Corporate Bonds 44.572.000.00 45,882,652AO 45,054,336,90 15.74 1.196 488 2.226 2.257 ORANGE COUN I Y POOL 65,364,939,44 65,364,939.44 65,364,939.44 2.2.82 1 1 0.590 0.598 285,603,355.67 289,077,548.07 286,332,081.58 100,00% 1,019 705 1.132 1.148 Investments Cash and Accrued Interest Accrued Interest at Purchase 36,083.45 36,083.45 Subtotal 36,083.45 36,083,45 Total Cash and Investments 285,603,355.67 289,113,631.52 286,3613,165.03 1,019 705 1.132 1.148 Total Earnings July 31 Month Ending Fiscal Year To Date Fiscal Year Endinq Curront Year 280,508.26 280,508.26 �—-- - - ---- - - _— Current Budget 100,000.00 100,000.00 1,200,000.00 Last Year Actual 347,651.89 347.851.89 3,403,369.60 Average Daily Balance 294,084,830.06 294,084,830.06 Effective Rate of Return 1.12% 1.12% 1 certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 1, 2021.A copy of this policy is ovailahle at the office of the City Clerk.'fhe investment program herein shown provides sufficient cash flow liquidity 10 meet the next six rnonth•s obligations. Market Values provided by Union Bank via Interactive Data Corporation. Alisa Backstrore,CITY TREASURER Reporting period 07101/2021-07131/2021 Portfolio CITY AP Run har, (YV2312021-10:27 VM In10_I'Ml)),3.11 Relwrl Na.7.3.11 City of Huntington Beach Portfolio Management Page Portfolio Details - Investments July 31, 2021 Avr,rage Purchase Staled YTM Days to Maturity CUSIP Investment s Issuer Balance Date Par Value Market Value Book Vnlue Rate S&P 365 Maturity Date Federal Agency Issues-Coupon 31331iCHX5 4292 Federal Farm Credit Bank 05/23/2019 5.000,000.00 5,253,950.00 5,002.940.35 2.260 AA 2.23E 955 03/13/2024 3133EKTGI 4296 Fodeod Farm Credit Bank 07/01/2019 5,000,000.00 5.077,550.00 4,996.868.06 1.750 1.821 334 07/01/2022 313383ORS 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,282..350.00 5,044,007.4E 3.250 2.743 677 06109/2023 3130AFWXI 4Z85 Fr:der-.d Home Loan Bank 021261?019 5,000,000.00 5,218,450.00 5,0W,000,0O 2.550 2.550 667 05/30/2023 313OAKN36 4320 Feder-,)Home Loan Bank 01/15/2021 5,000,000,D) 4,970,700,00 4,995,544.44 0,525 0.545 1,628 017151202E 3130AKNO5 4321 Federal Hale Loan Bank 01/20/2021 5.000,000,00 4,972.800.00 4,997.765.28 0.550 0.560 1.633 011201202E 313OAKUS3 4322. Federal Ilonlo Loan Bank 01/28/2021 5,000,000.00 4,967.250,00 5.000.000.00 0.500 0.500 1,641 01128/202G 3130AMD13 4327 Federal Home Loan Bank 05/25/2021 5.D00,000.00 5,000,400.00 5.000.000,00 0.800 0.800 1.454 07/25/2025 3130AM3N3 4328 1 inderal Home Loan Bank 05/26/202.1 5,000,000.00 5,005,850.00 5,000,000.00 1.030 1,030 1,759 05/26/2026 3130AMQ54 4331 Federal fiction Loan 13ank 06/16/2021 5,000,000.00 5,012.400.00 5,000,000.00 0,700 0.700 1,507 09/16/2025 3130AMQGZ 4332 Federal Home Loan Bank 06/14/2021 5,000,000.00 4,998,800.00 5.000.000.00 0.625 0.G25 1,321 03/14/2025 3130ALEYB 4333 Pedeml Home Loan Bank 06/10/2021 5,000,000.00 4.995,700.00 5.000.000.00 0.800 O.B00 1,67E 0 3104/20 2 6 3130AMW65 4334 Federal Home Loan Rank 06/30/2021 5.000,000.00 4,996,900.00 5.0w.000.00 0.500 0.500 1.247 12/30/2024 3130AMFS6 4335 Federal home Loan Bank 06/17/2021 5,000,000.00 5.005.350.00 4,970,735.38 0.750 0.873 1.77E 0 611 212 0 2E 3130AMXJ6 4336 Federal Hanne Loam Bank 06/30/2021 5,000,000.00 5.000.900.00 5.000.000.00 0.500 0.500 1.156 09/30/2024 3130AMXD9 4337 Federal Horan I.oan Bank 06/30/2021 5.000,000.00 5.004.300.00 5.000,000.00 1.100 1.100 1.794 061301202E 3134G92Y2 4258 Federal Home Loan Mort Corp 06/14/2017 5.000,000.00 5,003,750.00 5.000,302.33 1.875 AA 1.733 16 08/17/2021 3137EAEN5 4287 Fdwal l later,Loan Mort Carp 03/08/2019 3,OOQ000,00 3.144,210.00 3,015,971.06 2.750 2,450 687 06/19/2023 3137EAEN5 4288 Federal home Loan Mort Corp 03/14/2019 3.000.D00.00 3.144,210.00 3,016,682.78 2.750 2.437 687 06/192023 3135GOB43 4289 Fed.Nat'l Mort.Assoc. 03/15/2019 5,000,000.00 5.281.350.00 5.040,756,09 2M75 2,465 772 09/12/2023 3135GA2Z3 4318 Fed,Nail Mort Assnc. 01/11/2021 3.000.000.00 2,995.170.00 3,002,921.99 0.560 0.537 1,569 11/17/2025 3135GO4Z3 4329 Fed.Nat'l Mort.Assoc. 05/1Q202.1 5,000,000.00 4.993,550.00 4,975,501.29 0.500 0,628 1,416 06/17/2025 Subtotal and Average 111.062,223.39 104,000,0D0.00 105.325,890.00 104,059,996.51 1.250 1,211 Local Agency Investment Funds - SYSE82 982 Lail City 23,666,416.23 23,666,416.23 23,666,416.23 0.262 0,262 1 Subtotal and Averngo 29,068,087.3E 23,666,416.23 23,666,416.23 23.666,416.23 0,262 1 Treasury Socurilies-Coupon - 91Z828YI17 4298 US Trr,asury Notes 12/05/2019 5.000,DOO.00 5,175,400,00 4.985.558.21 1.500 AAA 1.595 1.15E 09/3012024 912B28P79 4299 US huasury Nolen 12/05/2019 3,000,000,00 3.064,440.00 2.996.570.70 1.500 AAA 1.574 576 02/2BI2023 91282CAB7 4330 US Imaany Notes 05/19/2021 5,000,000,00 4,941,000.00 L928,04604 0.250 0.615 1,460 07/31/2025 Sl11H01ll and Avmago 12.909.159.90 13,000,000.00 13,180,840.00 12,910,175.85 1.216 1,137 Medium Term Notes 45818WBX3 4290 Inter-American Dev.Bank 03/28/2019 4.000,000,00 4,208,000.00 4,044,732.78 2.870 2.270 718 07/20/2023 Portfolio CFI Y AP koo Ontc0812W2021 1027 Ph11PRF_PM11 7.3.11 54 keen Vm,7.3.11 City of Huntington Beach Portfolio Management Paget Portfolio Details - Investments July 31, 2021 Average Purchase Stated YTM Dnys to Maturity CUSIP Investment M Issuer Balance Date Par Valoc Market Value Book Val ua Rite S&P 365 Maturity D;rtu Medium Term Notes 4581OWBY1 4291 Into,American De,Bank 03128/2019 5,000,000.00 5,217,G50.00 5,066,583.17 Z.960 2.271 745 08/1612023 45fl18WC 11 4312 InIm-Arowicen Dev.Bank 04129/2020 6,000,000.00 6,110,760.00 6.093.495.56 1.600 0,550 547 01/3012023 4590581L8 4319 Intl Bk Rucon F Development 01/12/2021 5,000,000.00 4,967,550.00 4,997,567.06 0.500 AAA 0.512 1,549 10/2812025 45905611V2 4323 Intl Bk Recon K Development 04/23/2021 5,000,000.00 5,163,350D0 5,163,891.12 1.500 AAA 0.425 1.123 0812812024 45906M2L4 432.4 Intl Bk Recon 8 Development 04/30/2021 5,000,000.00 -1,976,500,00 4.950.918A5 0.650 AAA 0,870 1,668 02/241202.6 459058.114 4338 Intl 131,Rucon F Development 07/30/2021 5,000.000.00 4,953,000.00 4.959.0Z8.51 0.375 AAA 0.583 1,457 07/28/2025 Subtotal and Average 30,643,362.3A 35.000.000.00 35.656.870,00 35,276.276.65 1A20 1,107 Corporate Bonds - 037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,142,800,00 5.116.726,49 2.400 0.720 530 01/1312023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000,00 5,237,150,00 5,055,987.41 3.191 AA 2.528 692 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,094.47750 2,990.000.00 4.000 2.070 791 1010112023 375558AU7 4315 Gilead Sciences 04/30/2020 2.888.000.00 2.897.2.99.36 2.916.586.65 4.400 1.387 122 12/01/2021 437076BG6 4293 Home Depot Inc 05/24/2019 5.000.000.00 5,091.500.00 5.005,864.77 2.625 A 2.474 304 06/01/2022 4592001AG9 4274 113M Carp 09/28/2018 3,000,000.00 3.048.450.00 2.959.783.08 1A75 A 3.257 365 08/01/20Z2 713448C%4 4280 PEPSICO INC 12/21/2010 5,000.000.00 5.117.450.00 4.997.269.13 3.100 3.160 350 07117/2022 BUZ50011AI 4279 Teeas Instrwnanls Inc 12/21/2018 5,000.000.00 5,060.000.00 4.954,418.46 1.850 3.564 287 051152022 904764AW7 4286 Unilever 03/01/2019 5.000.000.00 5,064,100.DO 4.978,192.57 2.200 2.802 277 0510512022. 903311INVI 430G US Bank NA Cincinnati 02/21/2020 2,000.000.00 2,118,320DO 2,064,661.52 3.400 AA 1.671 722 07124/2023 91159HHX1 4325 US Bank NA Cincinrttdi 04/30/2021 3,809,000.00 4.011,105.54 4,014,846.82 2AD0 0.52.8 1.094 0713017..024 Subtulal and Avurage 45,063,219.38 44,572,000.00 45,882.652.40 45,054,336.90 2.257 488 ORANGE_ COUNTY POOL OCI'1 01 Omnge County Invest Pool 65,364,939.44 65.364,939.44 G5,364,939A4 0.598 0.598 1 Subtotal and Avemga 65,338.777.69 65.364,939.44 65,364,939.44 65,364,939.44 0,598 1 Total and Average 294,084,830.06 285,603,355.G7 289,077,548.07 286,332.,081.58 1,148 705 Portfolio CITY AP Run hale,W?N2021.102) 1'M(PItP PM2)7.3.11 55 City of Huntington Beach Portfolio Management Page Portfolio Details - Cash July 31, 2021 Average Purchase Swett YTM Days to CUSP Investment I IsSucr Balance Date. Per Value Market Value Book Value Raw S&P 365 Maturity Ave,age Balk,...:u 0.00 Accreelt Inteust at Purchase 36.083.45 36,083.45 0 Subtotal 36,OEI3A5 36,083.45 Total Cash and Investments 294,084,830.06 285.603.355.67 289,113,631.52. 286,368,165.03 1.148 705 Portlolio CITY AP R.01,[¢00/23/2021 10.2] PM(PIO_PM2)]_].11 56 City of Huntington Beach Portfolio Management Page 1 Activity By Type July 1, 2021 through July 31, 2021 Staled Irulsaction Purchases Redemptions C1.1511, Investment k Issuer Rare Date or Deposits or Withdrawals Balance Federal Agency Issues-Coupon 3130AMGR8 4326 redend Monte Loan 13ank 0.780 07/30/2021 0.00 3.000.000.00 3134G9N9.4 4257 Federal Home Loan Mort Corp 1.875 07/271202.1 0.00 5,000,000.130 Subtotal 0.00 8,000,000.00 104,059,996.51 Local Agency Investment Funds (Monthly Surnmary) SYS982 982 Lail City 0.262 39.156.78 18.000.000.00 Subtotal 39,156.78 18,000.000,00 23,666,416.23 Treasury Securities-Coupon Subtotal 12,910,175.85 Medium Terra Notes 459058JE4 4338 lull l3k Recon 8 Devalopmr:nt 0.375 07/30/2021 4,959,000.00 OAO Subtotal 4.959.000.00 0.00 35,276,2.16.65 Corporate Bonds Subtotal 45,054336.90 ORANGE COUNTY POOL (Monthly Summary) OCPI Ol Orange County Invest Pool 0.598 28.96.1.79 537.51 Subtotal 28.964.79 53/.51 65,364,939.44 total 5,027,121.57 26,000,537.51 286,332,08158 Portfolio CITY AP Rtm hale:0W73)Z011.10'.27 PM(tCPzT_PM3)7.3.11 1h.'Iw0 Ve,.7.3.11 City of Huntington Beach Portfolio Management page 1 Activity Summary July 2020 through July 2021 Yield to Maturity Managed Number Number Month Number of Average 360 365 Pool of Investments of Invesbnents Average Average End Year Securities Balance Equev:dent Equivalent Rate Pure-hasrxl Retlevnu•d Ienn Days to Maturity July 2020 40 264.073,523.48 1.610 1.632 0.920 0 0 920 652 August 2020 40 238,570,893.05 1.582 1.604 0,784 0 1 917 621 September 2020 39 225.447,508.77 1.594 1.616 0.685 0 1 935 606 October 2020 38 216,B15,117.12 1.629 1.652 0.620 0 6 885 516 November 2020 32 205,158,091.48 1.491 L512 0.576 0 1 725 396 DOCOMber 2020 31 221.313,362.71 1.387 1.406 0.540 0 0 680 355 January 2021 36 245,184,705.47 1.292 1.310 0.458 5 2 798 474 February 2021 34 244,B48,561.08 1.338 1.356 OA07 0 0 821 471 March 2021 34 241,726,743.55 1.272 1.290 0.357 0 1 812 451 April 2021 37 245,258,735.71 1.187 1.203 0.339 4 0 833 488 May 2021 41 272,220,547.80 1.102 1.117 0.315 4 1 832 529 June 2021 47 299,541,338.17 1.096 1.111 0.262 7 1 965 667 July 2021 47 294,084,830.06 1.132 1.148 0.262 1 2 1,019 705 Average 3B 247,302,048.88 1.362% 1,381% 0.502 2 1 857 533 Portfolio CITY AP R m Rvc 0W7512021-1027 I'M II"§'_PM417.3.11 R,.,.l Vnr.7.3.11 City of Huntington Beach Portfolio Management Page 1 Interest Earnings Summary July 31, 2021 July 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 435,604.00 435,604.00 Plus Accrued Interest at End of Period 604,910.11 604,910.11 Less Accrued Interest at Beginning of Period ( 764,664.92) ( 764,664.92) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 275,849.19 275,849.19 Adjusted by Premiums and Discounts -34,994.12 -34,994.12 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 240,855.07 240,855.07 Pass Through Securities Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0,00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 68,121.57 68,121.57 Plus Accrued Interest at End of Period 11,736.46 11.736.46 Less Accrued Interest at Beginning of Period ( 40,20,L84) ( 40,204.84) Interest Earned during Period 39,653.19 39,653.19 Total Interest Earned during Period 315,502.38 315,502.38 Total Ac justrnents from Prerniurns and Discounts -34,994.12 .34,994.12 1 otal Capital Gains or Losses 0.00 0.00 Total Earnings during Period 280,508.26 280.508.26 Portfolio CITY AP Imn natn:(IIVZ:V]f1P.10,2? 1'M IPRI I'M6)7.3.11 RA ;,vn,.7.3,11 �oa�y1NVEST,yFy� State of California W I9c Pooled Money Investment Account o ; Market Valuation 7/31/2021 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Bills S 68,827,483,166.06 S 68,839,482,500.00 NA Notes S 59,313,228,865.01 S 59,376,861,500.00 S 127,851,835.50 Federal Agency: SBA S 408,364,270.94 S 409,316,689.13 S 173,615.20 MBS-REMICs S 9,379,367.90 S 9,847,314.28 S 43,276.48 Debentures S 8,631,651,654.08 S 8,636,670,970.00 S 8,269,066.19 Debentures FIR S - S - $ Debentures CL S 1,200,000,000.00 S 1,200,188,000.00 S 1,105,055.00 Discount Notes S 13,296,360,912.45 S 13,298,438,500.00 NA Su ranational Debentures S 1,774,742,651.40 S 1,771,449,000.00 S 5,302,612.50 Supranational Debentures FIR S 150,012,560.81 S 150,026,562.44 S 18,392.51 CDs and YCDs FIR S 300,000,000.00 $ 300,006,000.00 S 41,812.92 Bank Notes $ 50,000,000.00 S 49,947,108.46 S 8,055.56 CDs and YCDs S 13,600,000,000.00 $ 13,599,698,194.96 S 6,067,291.69 Commercial Paper S 9,303,798,675.01 1 S 9,307,991,111.16 NA Corporate: Bonds FR S S - S - Bonds S 112,891,605.90 S 112,005,250.00 S 269,145.85 Repurchase Agreements S - S S Reverse Repurchase S - S S Time Deposits S 3,835,500,000.00 S 3,835,500,000.00 NA PMIA& GF Loans S 747,545,000.00 S 747,545,000.00 NA TOTAL I S 181,560,958,729.56 S 181,644,973,700.43 S 149,150,159.40 Fair Value Including Accrued Interest S 181,794,123,859.83 Repurchase Agreements, Time Deposits, PMIA& General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). 60 Statement of Cash Receipts and Disbursements and Summary of Cash by Fund Finance Department July 2021 Cash Receipts and Disbursements June 2021 July 2021 Receipts General Fund Property Tax 5 459,817 $ 816,898 Local Sales Tax 3,796,658 4,635,064 Public Safety Sales Tax 257,642 212,665 Transient Occupancy Tax(TOT) 882,922 1,693,417 Utility Users Tax(UUT) 1,286,324 1,561,786 Other Revenue 7,132,556 14,641,865 Total General Fund Revenue 13,815,918 23,561,696 Total All Other Funds Revenue 18,353,183 22,752,466 Total Receipts S 32,169,100 $ 46,314,161 Disbursements General Fund Personnel Services (10,986,945) (19,551,241) Operating Expenses (2,689,842) (3,097,137) Capital Expenditures (2,620) - Non-Operating Expenses (4,208) (2,148,796) Total General Fund Disbursements (13,683,615) (24,797,174) Total All Other Funds Disbursements (15,636,921) (40,188,489) Total Disbursements (29,320,537) (64,985,663) Net Change in Cash Flow S 2,848,564 $ (18,671,501) Summary of Cash by Fund June 2021 July 2021 General Fund $ 76,581,926 5 75,346,447 General Fund Other 3,923,461 5,657,016 Capital Projects Funds 25,672,252 23,918,216 Debt Service Funds 19,446,204 19,532.055 Enterprise Funds 87,177,854 74,363,009 Trust and Agency Funds 14,792,033 12,684,193 Internal Service Funds 32,173,432 30,339,493 Special Revenue Funds 52,245,959 51,501,191 General Ledger Cash Balances $ 312,013,121 $ 293,341,620 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records. The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio. This statement is prepared in compliance with the City's Charter. 61 CITY OF HUNTINGTON BEACH QUARTERLY INVESTMENT REPORT CITY TREASURER, ALISA BACKSTROM , MBA, CCMT, CPFIM QUARTER ENDED : SEPTEMBER 30, 2021 62 INVESTMENT PORTFOLIO - SUMMARY: AS OF: September 30, 2021 Investment Type $ in 000's Market Value Book Value Federal Agency Issues $ 94, 899 $ 94,052 Local Agency Investment Fund (LAIF) $ 12,666 $ 12, 666 Treasury Securities $ 23, 914 $ 23, 738 Medium Term Notes - Supranationals $ 35,420 $ 35, 251 Corporate Bonds $ 42, 816 $ 42, 114 OC Investment Pool $ 65,422 $ 65, 422 US Bank Money Market Sweep $ 5,044 $ 5,044 TOTAL $ 280, 181 $ 278, 287 63 INVESTMENT PORTFOLIO - INVESTMENTS BY TYPE : r 34% 24% 15% 13% 9 0 L %� 2% ■ Federal Agencies ■ OC Investment Pool Corporate Bonds ❑ MTN-Supras Treasuries ■ LAIF MM Sweep 64 INVESTMENT PORTFOLIO - QUARTERLY ACTIVITY: July 1 to September 30, 2021 Investment Type Purchases/ Calls/Maturities/ ($ in 000's) Deposits Withdrawals Federal Agency Issues $ - $ 18,000 Local Agency Investment Fund (LAIF) * $ 39 $ 29,000 Treasury Securities $ 11 ,000 $ - Medium Term Notes - Supranationals $ 5,000 $ - Corporate Bonds $ - $ 2,909 OC Investment Pool * $ 92 $ 7 US Bank Money Market Sweep $ 18, 326 $ 13, 282 TOTAL $ 34,457 $ 63, 198 *Includes Interest Income 65 INVESTMENT PORTFOLIO A . ❑ Sept 2021 : $235,824 ; :: Current Year - Month ❑ vs. budget: $100,000 � ' ,r ❑ Through 9130: $782,094 � �', Current Fiscal Year-to-date ❑ vs. budget: $300,000 ❑ Sept 2021 : 1 .06% ' Effective Rate of Return - ❑ Fiscal Year-to-date: 1 .10% ' Benchmark ❑ SeptW,41YA MINE, ❑ 12-month moving average 1 .5-year Treasury . ;; 66 INTEREST RATES - US TREASURY RATES SEPTEMBER 30, 2019 - SEPTEMBER 30, 2021 1.70 5-year US Treasury (top) 1-00 2-year US Treasury (bottom) 1.5 140 1.30 1.20 1.10 a 1-� O.so 0.86% 0.70 0.60 a. 0.40 030 0.20 o.lo .@ +d .@ .@ /e Ja .@ .e .@ l� l� ld ltT le lT LV ld Ape. e f ld y I l@ ld 67 SELECTED INVESTMENT POLICY COMPLIANCE REQUIREMENTS: MAXIMUM SPECIFIED INVESTMENT TYPE MAXIMUM % OF PORTFOLIO/ MINIMUM QUALITY IN MATURITY MAXIMUM PER REQUIREMENTS COMPLIANCE? ISSUER U.S. Treasury Obligations 5 years None None YES U.S. Government 5 years None None YES Agency Obligations Supranationals 5 years 10% "AA" Rating YES Corporate Notes 5 years 30%/10% "A" Rating YES Local Agency Investment Fund N/A Up to $75,000,000 None LAIF YES Orange County Investment Pool N/A Up to $75,000,000 None OCIP) YES Maximum Maturities No more than 50% of portfolio maturing over 4 years. YES (Requirements are at purchase) 68 SUMMARY: ii Safety — No principal losses o Liquidity — Sufficient funds for operations Market rate of return — 1 .06% September, 1 .10% Fiscal Year-to- date Prudently managed — No compliance issues i o Positive contributor to City — Earnings of $782,094 fiscal year-to- date to be utilized for operating expenses 69 Ai99ow✓TD 6-0-1 IPEr�/tt8�11j City of Huntington Beach File #: 21-545 MEETING DATE: 8/3/2021 REQUEST FOR CITY COUNCIL ACTION SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Oliver Chi, City Manager PREPARED BY: Alisa Backstrom, City Treasurer Subject: Receive and File the City Treasurer's June 2021 Quarterly Investment Summary Report Statement of Issue: Receive and file the City Treasurer's Quarterly Investment Report for June 2021, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not applicable. Recommended Action: Receive and file the City Treasurer's Quarterly Investment Report for June 2021, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or critique the Quarterly Investment Report. Analysis: Not applicable. Environmental Status: Not applicable. Strategic Plan Goal: Non Applicable - Administrative Item Attachment(s): 1. Treasurer's Quarterly Investment Report for June 2021 2. Treasurer's PowerPoint Presentation for June 2021 City of Huntington Beach Page 1 of 1 Pnnted on 7128/2021 ..e e:l$,ej s.A - City of Huntington Beach Quarterly Investment Report June 2021 Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer Colin Stevens, MPP Treasury Associate is PORTFOLIO SUMMARY AS OF: June 30, 2021 Investment Type $ in 000's Market Value Book Value % of Portfolio Federal Agency Issues $ 113,064 $ 112,065 36.5% Local Agency Investment Fund (LAIF) $ 41,627 $ 41,627 13.5% Treasury Securities $ 13,128 $ 12,908 4.2% Medium Term Notes $ 30,616 $ 30,331 9.90/0 Corporate Bonds $ 45,968 $ 45,073 14.7% OC Investment Pool 65,336 65,336 21.2% TOTAL $ 309,739 $ 307,340 100% As of June 30, 2021 , the market value of the portfolio was higher than the book value of the portfolio at $309.7 million versus $307.3 million, respectively. This was due to the overall decrease in market interest rates in the first half of the year, which served to increase the prices (value) of some of the existing securities in the portfolio purchased prior to the downturn in rates. Currently, funds within this portfolio are invested in federal agency securities, corporate bonds, the International Bank of Reconstruction and Development ("IBRD"), the Inter-American Development Bank ("IADB"), U.S. Treasury Securities, the State of California's pooled account (Local Agency Investment Fund "LAIF"), and the Orange County Investment Pool ("OCIP"). Only the investment types allowed under California Government Code Section 56301 and the City's Investment Policy Statement are utilized. The largest holding by security type at month-end was federal agency securities at approximately 37% of the total overall portfolio. This was followed by the Orange County Investment Pool at 21% of the total portfolio as of June 30, Due to the decrease in market interest rates, some Federal Agencies within the portfolio were called. Over the past year, rates within the LAIF and OCIP accounts have moved down more slowly than the market overall. As such, additional cash has been maintained in these pooled accounts to obtain a higher yield (with overnight liquidity). However, as the yield on these pooled portfolios has been moving toward market rates, funds above and beyond the city's established liquidity minimums will be invested in other investment types where appropriate. 20 PORTFOLIO BREAKOUT BY TYPE - BOOK VALUE of Total Portfolio q . PORTFOLIO EARNINGS AS OF: June 30, 2021 Total Earnings Month: June Fiscal YTD Current Year S 274,009 S 3,430,150 Current Budget S 100,000 S 1,900,000 Last Year Actual S 385,980 S 5,062,272 Average Daily Balance $ 299,541,338 $ 243,328.717 Effective Rate of Return 1.110. 1 .41% Benchmark' 0.13% nla 12-month moving average of interpolated 1.5-year treasury Earnings for the month of June 2021 were $274,009, a decrease of 40% from the same month in the prior year. This was due to the sharp downturn in interest rates that occurred over 2020. 21 To put this downturn into context, the 2-year U.S. Treasury yield at the beginning of 2020 was 1.58%, versus 0.11% at the beginning of 2021. Fiscal year-to-date earnings of $3,430,150 were down from the same period during the previous year by 47%. In the first half of 2021, the 2-year U.S. Treasury yield has been consolidating in a range between 0.09% - 0.28%, thus is was expected that we have seen a decrease in earnings and yield as bonds are called, and as new funds must be invested at the current lower rates. The effective rate of return for the month was 1.11%, with a fiscal year-to-date return of 1.41%. As the Federal Reserve has kept rates near zero throughout most of the year, the benchmark rate fell accordingly. The benchmark of the 12-month moving average of the interpolated 1.5- year U.S. Treasury was 0.13% at the end of June. As the portfolio maintains securities purchased when rates were higher, the rate of return will fall more slowly than that of the benchmark. PORTFOLIO ACTIVITY: MONTH - JUNE MONTHLY ACTIVITY: June 2021 Investment Type Purchases/ Calls/Maturities/ $ In 000's Deposits Withdrawals Federal Agency Issues $ 34,970 $ 5,000 Local Agency Investment Fund (LAIF)* $ 19,000 Medium Term Notes - IADBIIBRD Corporate Bonds Treasury Securities OC Investment Pool* $ 35 (a) 3 TOTAL $ 35,005 $ 24,003 'Includes Interest Income a Admin Fee PORTFOLIO ACTIVITY: QUARTER QUARTERLY ACTIVITY: April 1 to June 30, 2021 Investment Type Purchases/ Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues $ 53,000 $ 5,000 Local Agency Investment Fund (LAIF)* $ 21,042 $ 19,000 Medium Term Notes- IADB/IBRD $ 10,000 Corporate Bonds $ 3,809 $ 5,000 Treasury Securities $ 5,000 OC Investment Pool * $ 117 (a) 10 TOTAL $ 92,968 $ 29,010 'Includes Interest Income a Admin Fee 22 COMPLIANCE The portfolio is in conformity with all relevant State regulations and the City's Investment Policy statement as approved by the City Council on February 1, 2021 . The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations. MAXIMUM INVESTMENT MAXIMUM SPECIFIED % MINIMUM QUALITY IN TYPE MATURITY PORTFOLIO/ REQUIREMENTS COMPLIANCE MAXIMUM PER ISSUER Commercial Paper 270 days 25%/10% Al, "A" Rating YES State Obligations— CA And Others 5 years None/10% "A" Rating YES U.S.Treasury Obligations 5 years None None YES U.S. Government Agency Obligations 5 years None None YES IBRD, IFC, IADB 5 years 10% "AA" Rating YES Corporate Notes 5 years 30%/10% "A" Rating YES Local Agency Investment Fund N/A Up to $75,000,000 None LAIF YES Orange County Investment Pool N/A Up to $75,000,000 None OCIP YES Maximum Maturities No more than 50%of portfolio maturing over 4 years. YES SUPPLEMENTAL INFORMATION ADDITIONAL ACCOUNT BALANCES: Ending Balance Market Values: 3/31/2021 Total Deferred Compensation Plan Balances $177,920,129 CaIPERS Retiree Medical Trust Account $34,571 ,100 US Bank Supplemental Pension Trust Account $70,798,622 PARS Post Employment Benefits 115 Trust Account $9,895,133 Bond Reserve Accounts $6,949,000 (Due to delay in statement receipt,amounts are from previous quarter end) 1 ) CalPERS OPEB CERBT Account: This account provides for post-retirement medical insurance for eligible retirees. As of the most recent Actuarial Valuation Report, the funded status of the Total OPEB liability was 90%. The fund is managed by CaIPERS and had a net rate of return as of 6/30/20 of 5.45%. 2) Supplemental Pension Trust: This is a defined benefit retirement plan for employees hired prior to 1997 and is a closed plan. The funds are managed by U.S. Bank according to the investment policy established by the Supplemental Pension Board. As of the most recent Actuarial Valuation Report of 6/30/19, the plan was approximately 90% funded. 3) PARS 115 Trust: On May 2, 2016, the City Council authorized the City's participation in a tax-exempt, IRS Section 115 Trust to enhance paying down the City's unfunded 23 liabilities. Such funds are maintained through the Public Agency Retirement Services Pension Rate Stabilization Program (PARS PRSP) and are legally restricted for use in administering the City's defined benefit pension plan. In June of 2021 , the City deposited an additional $1 ,000,000 into this account. 4) Bond Reserve Accounts: These are reserve accounts required by the City's various bond agreements. Investments of debt proceeds held by bond trustee are governed by provisions of the debt agreements, rather than the general provisions of the California Government Code or the City's investment policy. ECONOMIC AND MARKET OVERVIEW MARKET SUMMARY: MARCH 31, 2021 - JUNE 30, 2021 Fed Funds 2-Yr. 10-Yr. As of: Rate Treasury Treasury S&P 500 DJIA 3/31/2021 0.00 - 0.25 % 0.16% 1.74% $ 3,972.69 $ 32,981.55 6/30/2021 0.00 - 0.25 % 0.25% 1.45% 4,297.50 34,502.51 %Change none 56.25% -16.67% 8.17% 4.61% The Federal Open Market Committee (FOMC) met in June to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that vaccinations have reduced the spread of COVID-19 in the United States. Additionally, they highlighted that the sectors most adversely affected by the pandemic remain weak but have shown improvement. They stated, "Inflation has risen, largely reflecting transitory factors. Overall financial conditions remain accommodative, in part reflecting policy measures to support the economy and the flow of credit to U.S. households and businesses." Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 1 .45%, down from 1.74% from the end of the previous quarter, for a 16.67% decrease quarter- over-quarter. The S&P 500 and DJIA increased by 8.17% and 4.61% respectively, over the same period. Employment: Total nonfarm payroll employment rose by 850,000 in June, and the unemployment rate was little changed at 5.9 percent. Notable job gains occurred in leisure and hospitality, public and private education, professional and business services, retail trade, and other services. 24 2Yr Tsy 5Yr Tsy 0 10Yr Tsy Treasury Rates Monthly Averages 1.70 +.ua +Cyr Tay 1.60 sad 1.50 1.40 1.30 1.20 1.10 c 1.00 g os a 0.90 Oslo a.am IT,ry Chad w aam a.am 0.80 a.1oa 0.70 a a.uo on 0.60 a. 0.50 0.40 am aim a.am as.o 0.30 02" o.ne aim 0.20 o'aa a.na mny one ohm C.+w aam aeon Dead a,w Cem o.+m a.m o+m 0.10 0 o e o 0 0 0 25 CityHuntingtonof Beach Quarterly Investment Report . . . Quarter Ending: June 2021 Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer 1 / ' • • ❖ Ongoing public health crisis continued to cause volatility within economy and financial markets ❖ Unemployment rate for June up slightly to 5.9% ❖ Some concerns of inflation expressed by Federal Reserve / CPI up .9% in June ❖ Continued historically low U.S. Treasury Rates: 2-Year U.S. Treasury at 6/30: 0.25% 5-Year U.S. Treasury at 6/30: 0.87% 27 r.Tr T.Y 1.6o t 2Yr Tsy .A 1.60 � 5Yr Tsy 1.40 10Yr Tsy 1.30 1.20 Slight uptick in 5- '.10 year Treasury1. I °° during 2"d quarter 1 o.. 0.60 0.970 a..tl rvr nY C 0.60 0.>0 ° aA 0.60 o. 0.50 2-year Treasury I 0.40 °'•O o.s.o has remained 11 o.a.o 0.30 V.1°° 0,210 O.>M flat 0.20 O.r.O O.r1O fVr T.Y 0.)00 O.rtl 0.1.0 O.1)O 0.1 r0 Y.1.0 O.r]O O.rtl O.1W 0.1.0 °.r]0 0.10 28 Investment Type / Market Value: • Federal Agencies - $113.1MM • LAIF - $41 .6MM • Treasury Securities - $13.1MM Po 1 1 Summary • IADB/IBRD - $30.6MM As of 6/30/21 • Corporate Bonds - $46.OMM • OCIP - $65.3MM TOTAL PORTFOLIO: $309.7MM 29 OC Investment Pool 21% Investments Federal Agency Issues 37% by Type Corporate Bonds 15% As of June 30, Local Agency 2021 Investment Fund(LAIF) 13% n MediumTertnNotes Treasury Securities 1096 4% 1 � MONTHLY ACTIVITY: June 2021 Investment Type Purchases/ Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues $ 34,970 $ 5,000 Local Agency Investment Fund (LAIF) * $ 19,000 Medium Term Notes - IADB/IBRD Corporate Bonds Treasury Securities OC Investment Pool * $ 35 (a) 3 TOTAL $ 359005 $ 24,003 *Includes Interest Income (a) Admin Fee 31 I QUARTERLY ACTIVITY: April 1 to June 30, 2021 Investment Type Purchases/ Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues $ 531000 $ 51000 Local Agency Investment Fund (LAIF) * $ 219042 $ 192000 Medium Term Notes - IADB/IBRD $ 10,000 Corporate Bonds $ 39809 $ 5,000 Treasury Securities $ 51000 OC Investment Pool * $ 117 (a) 10 TOTAL $ 92,968 $ 29,010 *Includes Interest Income (a) Admin Fee 32 Current Year - Month ❑ June 2021 : $274,009 ❑ vs. budget: $100,000 Current Fiscal Year ❑ Through 6/30: $3,430,150 2020121 ❑ vs. budget: $1,900,000 Effective Rate of Return ❑ June 2021: 1 .11% ❑ 20/21 Fiscal Year: 1.41% Benchmark ❑ June 2021 : 0.13% ❑ 12-month moving average 1.5-year Treasury 33 Selected Investment Policy Compliance Requirements MAXIMUM INVESTMENT MAXIMUM SPECIFIED % MINIMUM QUALITY IN TYPE MATURITY PORTFOLIO/ REQUIREMENTS COMPLIANCE MAXIMUM PER ISSUER Commercial Paper 270 days 25%/10% Al , "A" Rating YES State Obligations-- o CA And Others 5 years None/10/o "A" Rating YES U.S. Treasury 5 years None None YES Obligations U.S. Government 5 years None None YES Agency Obligations IBRD, IFC, IADB 5 years 10% -AA- Rating YES Corporate Notes 5 years 30%/10% "A" Rating YES Local Agency Investment Fund N/A Up to $75,000,000 None LAIF YES Orange County Investment Pool N/A Up to $75,000,000 None OCIP YES Maximum Maturitiesi No more than 50%of portfolio maturing over years. YES The portfolio is in compliance with all relevant State regulations and the City's Investment Policy. 34 If 0 Safety — No principal losses Liquidity — Sufficient funds for operating needs Effective Rate of Return — June: 1 .11 %, FY20/21 : 1 .41 % C� Prudently managed — No compliance issues Positive contributor to City — Earned $3.4MM for FY20/21 towards City's operational expenses, etc. 35 (PE W2-SOA/- H/3SENT) City of Huntington Beach File #: 21 -257 MEETING DATE: 5/3/2021 REQUEST FOR CITY COUNCIL ACTION SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Oliver Chi, City Manager PREPARED BY: Alisa Backstrom, City Treasurer Subject: Receive and File the City Treasurer's March 2021 Quarterly Investment Summary Report Statement of Issue: Receive and File the City Treasurer's Quarterly Investment Report for March 2021 , pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not applicable. Recommended Action: Receive and File the City Treasurer's Quarterly Investment Report for March 2021, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or critique the quarterly report. Analysis: Pursuant to Section 17 0 of the City's Investment Policy. the City Treasurer must submit a quarterly investment report to the City Council. Attached to this staff report are the Quarterly Investment Report for the quarter ending March 31 , 2021 . along with a PowerPoint presentation Environmental Status: Not applicable Strategic Plan Goal: Non Applicable - Administrative Item Attachment(s): 1. Treasurer's Quarterly Investment Report for March 2021 2. Treasurer's Quarterly PowerPoint for March 2021 City of Huntington Beach Page 1 of 2 Pnnteo on 428/2021 ....,..:13 _-.. . File #: 21-257 MEETING DATE: 5/3/2021 City of Huntington Beach Page 2 of 2 Printed on 4/28/2021 omerec L4 LegistaC- Cott' of Huntington Beach Quarterly Mvestment Report March 2021 Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer Colin Stevens, MPP Treasury Associate 15 PORTFOLIO SUMMARY AS OF: March 31, 2021 Investment Type $ in 000's Market Value Book Value % of Portfolio Federal Agency Issues $ 65,327 $ 64,141 26.4% Local Agency Investment Fund(LAIF) $ 39,586 $ 39,685 16.3% Treasury Securities $ 8,247 $ 7,980 3.3% Medium Term Notes $ 20,589 $ 20,241 8.3% Corporate Bonds $ 47,187 $ 46,097 18.9% OC Investment Pool 65,229 65,229 26.8% TOTAL $ 246,164 $ 243,273 100% As of March 31, 2020, the market value of the portfolio was higher than the book value of the portfolio at $246.2 million versus $243.3 million, respectively. This was due to the overall decrease in market interest rates over the past three months,which served to increase the prices (value) of some of the existing securities in the portfolio purchased prior to the downturn in rates. Currently, funds within this portfolio are invested in federal agency securities, corporate bonds, the International Bank of Reconstruction and Development ("IBRD"), the Inter-American Development Bank ("IADB"), U.S. Treasury Securities, the State of California's pooled account (Local Agency Investment Fund "LAIF"), and the Orange County Investment Pool ("OCIP"). Only the investment types allowed under California Government Code Section 56301 and the City's Investment Policy Statement are utilized. The largest holding by security type at month-end was the Orange County Investment Pool at approximately 27% of the total overall portfolio. This was followed by federal agencies at 26% of the total portfolio as of March 31, Due to the decrease in market interest rates, some Federal Agencies within the portfolio were called. Over the past year, rates within the LAIF and OCIP accounts have moved down more slowly than the market overall. As such, additional cash has been maintained in these pooled accounts to obtain a higher yield (with overnight liquidity). However, as the yield on these pooled portfolios has been moving toward market rates, funds above and beyond the city's established liquidity minimums will be invested in other investment types where appropriate. i I i 16 PORTFOLIO BREAKOUT BY TYPE - BOOK VALUE % of Total Portfolio i J� I I ' PORTFOLIO EARNINGS AS OF: March 31, 2021 Total Earnings Month: March Fiscal YTD Current Year $ 261,545 $ 2,632,945 Current Budget $ 100,000 $ 1,600,000 Last Year Actual $ 437,478 $ 3,830,742 Average Daily Balance $ 241,726,743 $ 233,693,950 Effective Rate of Return 1.27% 1.50% Benchmark" 0.14% nla '12-month moving average of Interpolated 1.5-year treasury Earnings for the month of March 2021 were $261,545, a decrease of 40% from the same month in the prior year. This was due to the sharp downturn in interest rates that occurred over 2020. To put this downturn into context, the 2-year U.S. Treasury yield at the beginning of 2020 was 1.58%, versus 0.11% at the beginning of 2021. Fiscal year-to-date earnings of$2,632,945 were 17 down from the same period during the previous year by 31%. It was expected that we have seen a decrease in earnings and yield as bonds are called and as new funds must be invested at the current lower rates. The effective rate of return for the month was 1.27%, with a fiscal year-to-date return of 1.50%. As the Federal Reserve has kept rates near zero throughout most of the year, the benchmark rate fell accordingly. The benchmark of the 12-month moving average of the interpolated 1.5- year U.S. Treasury was 0.14% at the end of March. As the portfolio maintains securities purchased when rates were higher, the rate of return will fall more slowly than that of the benchmark. PORTFOLIO ACTIVITY: MONTH - MARCH MONTHLY ACTIVITY: March 2021 Investment Type Purchases/ Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues Local Agency Investment Fund (LAIF)* $ 5,000 Medium Term Notes -IADB/IBRD Corporate Bonds $ 3,710 Treasury Securities OC Investment Pool* $ 49 3 TOTAL $ 5,049 $ 3,713 'Includes Interest Income PORTFOLIO ACTIVITY: QUARTER QUARTERLY ACTIVITY: January 1 to March 31 , 2021 Investment Type Purchases/ Calls/Maturities/ $ In 000's Deposits Withdrawals Federal Agency Issues $ 18,000 $ 3,000 Local Agency Investment Fund (LAIF) * $ 5,034 $ 7,000 Medium Term Notes-IADB/IBRD $ 5,000 Corporate Bonds $ 5,136 Treasury Securities OC Investment Pool* $ 130 10,010 TOTAL $ 28,164 $ 25,146 "Includes Interest Income 18 COMPLIANCE The portfolio is in conformity with all relevant State regulations and the City's Investment Policy statement as approved by the City Council on February 1, 2021. The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations. MAXIMUM INVESTMENT MAXIMUM SPECIFIED O/ MINIMUM,QUALITY 1N TYPE MATURITY PORTFOLIO!MAXIMUM.P.ER REQUIREMENTS COMPLIANCE, ISSUER Commercial Paper 270 days 26%110% Al, "A" Rating YES State Obligations— CA And Others 5 years None/1 D°h "A" Rating YES U.S.Treasury Obligations 6yeara None None YES U.B.Government A enc Obligations 6 years None None YES IBRD,IFC,IADB 6 years 10% "AA" Rating YES Corporate Notes 6 years 30%110% "A" Rating YES Local Agency Investment Fund N/A Up to $75,000,000 None LAIF YES Orange County Investment Pool NIA Up to $76,000,000 None OCIP YES 111axlmum Maturities No more than 50%of portfolio maturing over 4 years. YES SUPPLEMENTAL INFORMATION ADDITIONAL ACCOUNT BALANCES: Ending Balance Alarlret Values: 1 213112 0 2 0" 1) CalPERS OPEB CERBT Account $34,649,512 2) US Bank Supplemental Pension Trust Account $70,304,528 3) PARS Post Employment Benefits 115 Trust Account $9,590,864 4) Bond Reserve Accounts $8,109,206 ' Duo to delay In statement recol t.omounle aro from previous quarter end 1) CalPERS OPEB CERBT Account: This account provides for post-retirement medical insurance for eligible retirees. As of the most recent Actuarial Valuation Report (6/30/19), the funded status of the Total OPEB liability was 90%. The fund is managed by CalPERS and had a net rate of return as of 6/30/20 of 5.45%. 2) Supplemental Pension Trust: This is a defined benefit retirement plan for employees hired prior to 1997 and is a closed plan. The funds are managed by U.S. Bank according to the investment policy established by the Supplemental Pension Board. As of the most recent Actuarial Valuation Report of 6/30/19, the plan was approximately 90% funded. 19 3) PARS 115 Trust: On May 2, 2016, the City Council authorized the City's participation in a tax-exempt, IRS Section 115 Trust to enhance paying down the City's unfunded liabilities. Such funds are maintained through the Public Agency Retirement Services Pension Rate Stabilization Program (PARS PRSP) and are legally restricted for use in administering the City's defined benefit pension plan. In November of 2020, the City deposited an additional $1,000,000 into this account. 4) Bond Reserve Accounts: These are reserve accounts required by the City's various bond agreements. Investments of debt proceeds held by bond trustee are governed by provisions of the debt agreements, rather than the general provisions of the California Government Code or the City's investment policy. ECONOMIC AND MARKET OVERVIEW MARKET SUMMARY: DECEMBER 31, 2020 - MARCH 31, 2021 Fed Funds 2-Yr. 10-Yr. As of: Rate Treasury Treasury S&P 500 DJIA 12/31/2020 0.00-0.25% 0.13% 0.93% $ 3,766.07 $ 30,606.48 3131/2021 0.00-0.25% 0.16% 1.74% 3.972.89 32,981.55 % Change none 23.08% 87.10% 5.77% 7.76% The Federal Open Market Committee (FOMC) met in March to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that the ongoing public health crisis will continue to weigh on economic activity, employment, and inflation in the near term. Additionally, they highlighted that indicators of economic activity and employment have turned up in recent months, although the sectors most adversely affected by the pandemic still remain weak. They stated, "The Committee would be prepared to adjust the stance of monetary policy as appropriate if risks emerge that could impede the attainment of the Committee's goals." Fixed Income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 1.74%, up from 0.93%from the end of the previous quarter, for a 87.10% increase quarter-over- quarter. The S&P 500 and DOW increased by 5.77% and 7.76% respectively, over the same period. Employment: Total nonfarm payroll employment rose by 916,000 in March, and the unemployment rate declined to 6.0 percent. Notable job gains occurred in leisure and hospitality as pandemic-related restrictions eased across the country. Nearly two-thirds of the increase was related to food services. 20 �—7Yr Tsy —�OYr Tsy —d— IOYr Tsy Treasury Rates Monthly Averages 1.00 1.610 1.60 1.60 1.00 1.70 1oY,f y t 1.10 1.10 0 00 0.0 +,0.90 Dew oP0 i 0.920 OAO 0.110 0.710 0.10 0,610 D6 o6w of 0.60 >6w 6r.T. 0.6 0.60 041A on 0.40 f6 0Aw a]+o 0.00 0.1" 0.214 02ro 20 0.20 0.170 0.110 0.If0 0.100 0,140 o_Ilo Olio 0.40 0.If0 for20 0.1w O.IlO 0.10 r—T—r— s s s s While the 5-year U.S. Treasury has seen a nice uptick in yields, the 2-year U.S. Treasury has remained flat. And while the yields offered by the LAIF and OC Pool pooled accounts lagged the previous downturn in rates, they have begun to move down. However, they continue to offer higher rates than most other allowable investments (with maturities less than four years). 21 �s cw a Hizon9wn elan ` City of Huntington Beach z6DD west. Portfolio Management nurvp'an Beae1, Portfolio Summary January 31,2021 Yv WAN 9enY %al OMb YiN YtM InvOEntyntt VaFa Vaal. V. w Pen1Ne Txm MWWry MEq— ME,.,. idary/,percy Ivan-Lwpn 4,Wf1,0.tl.CU 65.A06,22000 M.156,wW 2S.T LUG w IA95 1.719 teal Aaacy lmesar,au F9rGa .t56s,.ea.n 41.s65,aa9.2o .1.sa5.am.n ton 1 1 0152 0MA To.m35u.aaa-Lwym "003009.00 8,306,250.00 7,97ATW0 320 t,sa3 1119 1.566 I.su Mad.T.Ran 20.o0,000.00 20,>9e,»om n�fi0.9n.sa ..1. 1.53 1.W9 1.256 1.312 caFaan amlm 49n100000 fit,lv.tun .%&W,5a146 m.02 1.163 510 22M In! D (x cm POOL 69.1}9,T1.1. 61,139,211.18 66.139.274.16 28.16 1 t onM 069a 2411,197,763.41 282,281,68820 2a8,9T1,6T6S9 t00.GY% 293 474 IM2 1.31D Investments Cesb and AMMW I Wonst A�Werest at Nn:hase 1,81AAS >.fisau Schaal T.Ata so 1.55aa Total coon aW ln..Innurts 248,197,T6341 252.789.327.59 248,929,334.0 793 Oa 1."2 1.310 Total Esmings Jan.,y 31 Mu1tn Ending Fiscal You To DWa Fiscal You EnEing C,uenl You 261,21691 2.056.M,12 C wa swow 100.00000 1,a00.000.00 1900.fY1 M La51 You AUual 462.932.41 2,957,175.77 5223.73002 Aveage lA0y Rala.. 245,18a,205a7 231p63,WD.30 Eft IN.Reta of RAW. 1.2M 1.51% 1 roNty 05a1 Ws ropM acanteq refe al Cdy paplea Br esimeMa and u to eonfomtity aan aA Sate to s and It1e Y19elane3e pn6ry Ata cur ent Med v Oro CRY Cound can Feb ry 1,2021.A ca of Otis pofCy 1.o Ihable at 01e oft¢of Inc City Cork Tne nnest I plopmm fYuM anovn Ponnd.6 MCMnl tun Bow M311d0y W nKet me neat am otorM's obfgaMON. wnat Vahc provided by UNu1 Bens.ia Into tl5e Data Cor awallon Aha eaisban.CITY TREASURER Reporting period 01I01M21-0123112021 Porth9io C2TY M ten W.p'122T1.1]o: W 1Ao- .o. Pyv1 Ve.116, 22 City of Huntington Beach Portfolio Management pag.I Portfolio Details-Investments January 31,2021 Anlp. Pu2tw. 91+IaE rn oay.b wGMy CU9V Inr.aNym. bs R pat. P.ryaW. WMt vsr Bua Vuu. Ral, SIP 3"WNrty pale F.6etal Aganry Isaum-C0up0n 5IMECHYS IIV FNad Finn,CWd suJ OS IWI/ S.OM.OW.00 5,]12TN.CO S.W3,50220 2,260 M 2396 "IN Wtl'M. 3133ERTGt aM FaGmal Fnnt Cre016an1 0)Nt/LO19 5,000,000.00 5,I15,0=00 1995,159,72 17M 1,821 S150igIM22 3IINIOR5 4291 Fa6va11b1m lmn 0a 1y2VOIS 5.0wnW 00 5,W,OM.m 1.055,66SIB 32M 2.7y &N 06`()9FA23 313 FWXI 421S FeMFI Nosy tun Ban. =&M19 5.000.OWAO S,2TT,1N.W S,Mww 2,5W ISSO M60L II 31N 1. a29T Fe nll WIn 8anY ns,77mu, S,COO,Om.W 5.057,450W 5,007,Y29a0 I'M I IN W11R021 31NANNu 5220 FaOval H.tan 8anr 0111S 21 sm,nDOW !9/5.7OOW 4,..1,.— 0325 pNS I," 1)1I1512026 31u N65 4321 FaOnal.tan Bnnl 01W21721 5,000,OW02 !9%SW,W AAV 51S 70 O,SW 0.NO 1.014 01R 26 31WAMJ53 a122 Fwrl W, Loa1,S.N 01R6R021 5.".oIx.W 091,ON.00 sm,OW.W 0.500 05W 1322 01,IM26 11.G9NM 1257 Ftln.11brctan ValCv2 W,4=1) s=.W0.00 S.W.Wsw $=.WIS 1.a)5 M 1,TM Its UaTM21 31UGV2I QN F.brtl Fgnv lDN Mwl Cop WIWD" S,WO.OW.00 5.WT.I2000 5.00,703 53 1.675 M 1.733 IV W1712021 313E EN5 a207 Fa mNone tpan MM Cmp WOM019 3,000, .W 1,165,10000 ],0]0211.16 2.750 3a50 NA W112023 313)EAENS aM. F4rY Msne larl Ypn Cv9 =1.19 3,0DC=On ].M"WW 3021,111A3 2.762 2,537 as Wl9 n 1115GOW3 a200 F..Nsn Wrt Aanc =1S,2019 5,0NAW00 5353,SSL.W 5,050,3%I7 2L75 2465 953 W121M23 3113 1 .310 F. Ibtt Aucc 0111 2D21 IW0,000On Im,w 100321ZM O.MO O,N) t)N 11117TA25 Subobl..A.nra9a 66122176l MpW.000D0 66}m,2A.00 S.,IY.562.M 1.719 Ma Local Agency ln9 uucnt Funds S559R W2 WC.1 . S65AS92] .,.NsM9.2] 1136'"113 oASS 0459 I 0o61oW a1W aa.rp. a1,Y9?S14 .1Sa6Am33 .,.S Ns 3 aly3.M53] 0..0 1 T1.mury S.curnks-Coupon 912326Y VW US T.e N. 129YMti 5,000.OW,W 5,223M.00 1903,290..0 1SW MA 15.5 1,3]) O9f3M021 9123uPM 4299 US T.0 N. 12W2019 30:O.WO.00 3.W,EW00 IN5AS1D9 1.500 MA 1,574 757 O2r2E2023 UtunudW Arai 1,516Au19 6000,OWm C10S.2Nm 7a71.761L6 IAV 1.119 M.Ekm TOM Noum .u10vf1!f] .No Irum-Mwran prv.Dan. pYl 10 .0W,.w 4.N3,TM,W 1,OSS,081A8 2.070 22T0 099 OTRWN23 4MIMUr1 .Ml ftov n nD San! OY2dA19 50W001W 5,31I250,W 5,06],.SO2b 2m0 z271 9u W162023 .SSI N T1 .312 InWAmevn D.r.U6 d?]12020 6.NO=.Go "IsI m 6,121,710.57 1SW 0550 72S 01=2023 'INN41.6 4319 Ins On R.I De.WTrn 01,12fIVI I.WO.000m 4s%4,W0W 4997,21037 0WC MA 0}12 l?u 1W2NN25 SuOtolal.n6A—I,, 19,112.316,16 20,WO.OWm ID106.17Om nasax,S. 1317 1.00 Corporan 80 uls 0])811,RI 4M2 AFp.Oc CM 17 SOO,.w ssew W 5,010901.1S 2.8N M 1.Nu M CSW8131 .ITIIDE2 4]13 AppvO d(19/20M S.OW.000.W 5,201,950w 5,158.9:).DO 2..W 01M 711 0111Y2023 PonfrA.Cm' AP Ru1 .91 GulinF GlO�i]n City of Huntington Beach Portfolio Management P".2 Portfolio Details-Investments January 31,2021 A»rty. PurclW sY,n. rn pryam W .y CUSO' Invee•m• Y•urr B pM• PV Vtlu• Wr41Vyw pock VJu Pas• y( W P l6f lurtly ph Corponu Bonds 166]64NI] 1291 C.Cv OSQY 19 dow,=o. 5,1112000.00 S.OM?42.52 3,191 M 25h S}] osn S 2]•612CRS OCO Oianey IWIY 19 2.625,Op].0o ].137.150]$ ]016,5]SA6 .000 2.020 972 1041g 37%5 W 1115 Gi•M Sore DU x Zen. do 2,95f.S1224 2.959.46662 1100 1l67 ]051101=21 432076005 420] Man.p•pYlrc DYN2019 5.000000A0 S'"'diV.O] SON,=62 2525 A 2426 KS ONGIM22 G59]OO.G9 1211 IM Cap M 1016 3.0odw.00 ].OSO.]•0.00 ;9]9,67162 1.625 A ].257 516 0100IMM 21146C%4 A280 PEPSICOINC I2 Ino16 5,0ododd de 5.15].naw 5.100 1160 53, 07117mn 662504M1 OTf Temlbrv.. 1=1=15 5000000A0 S.10d.00.00 •,925,52525 IMO ]SG 4060Y15IM22 9W2M6'M •256 UN OW01 12 S,00000000 S"..000.00 1.M'SM,52 2.200 2.502 •SS OdPO2 3 9d761/SL 1312 Un 0`30=0 1.710,000 DO ],22],5M 10 3 220,526.f6 2.250 0.222 49 012WO21 90331Hwi f]06 US OxnI NA Circ d O212Y2020 2000WOoo 21s6.S50.00 2,050,21361 3100 M 1.671 90] 07aV = SuotoYI•n6 A. . 5000o'"T.30 41.173AWA0 S1,1]],16531 0,850.1334A 2351 W ORANGE COUN'3Y POOL O p, 01 p w cont,M ovY 65,139.27118 win 2211. 15,139,22!16 OSM 069r I S.odool odAr.n9• ]Q916)13N ff.139pU1 Sf,l]f,311.L 16.136,S4.10 0.6Y 1 TOW vW lv.np• 246.I84,203A2 ]0}97.71341 25;]91,6n.50 14.f21,b6tf 1J10 .21 POMofo CITY AP 6�n m p>'nxa: uo: v.legr_owl2 f 6 3a City of Huntington Beach Portfolio Management P.v 3 Portfolio Details-Cash January 31,2021 Aranga hrtnaaa ]b Y CaYab CU50' InnaNUMR bawr pab RryaWa MarYetVWa Beoh Vaba RanA, 68P ]"ti lW,rtlry AVRnga Babnu 0A0 ArouG NOaa�n PUNuaa "Ms. 7,W.11 0 9ylcftl T,W,ba ),0]].]i TK CaaO aW b�M ]a0.1µ,)OSA] M.117,MAI 15 MAVA] 20,07$A] Q10 pa PaL'oAo cnV RNPA.O]M1YM)1 1501 RI )]C 25 City of Huntington Beach Portfolio Management Paa,5 Activity By Type January 1,2021 through January 31,2021 BbbC Tnn.. Pu.. aaYan Fuaw CUSS' hmYMm6 bwer Rab Was wOapwlb YI WIWIawN a9N^"9 Fadonu A"ncy lawn-Cwpon 3130A s 1320 F.w NMI Lwn Oun 0525 OIIl WO21 4,995,000.W am 3130A 6S 4321 Fa . N l Oant 0150 01 f 2021 1001.500.DO am 312 XUSS On FaaenO na lYnBuiu O.SW 01I22`2021 acuacuum OM 3IYGUST3 930N Ftl l t NwlC p IJ75 01.W I 0,00 1,000.OW.00 3133GASZ3 a314 F.,San N 0."a .1I1021 SC6l..1aw am eYeuYy 1T,n6Jaom 2.000.aw" u,tgyaa Local Ap9nry lnry stmant Fun& (MonUtly Summary) SY5932 n2 :aa Cq 0�58 N,3m. am Subnbl P.In.M am 91y6M9A3 Tn50aury 9atuNllas-Coupon Sumo,I Ttn.Im" teedlum Telm Notes 95WSS 9519 FS M Raral SCevtlprwN QSN 01/12 21 9,597,2.10.00 am SuC f 91592350-00 0m iafm,sn.se C OIpOratO Boole J1555' M aa'6 G4aE 9Gacu 1500 01g 021 0m 1!25.101e7 SupbLl am 1,91f,t OTJ' aSARMa.4 ORANGE COUNTY POOL (MCa3hlr Summary) GCPI 01 Glarq.C.w Siren Pat2 0695 53.54395 10.005.513.19 Suatabl 22,U" t0A03.613.19 65,1]S,2Tl.tS TYW aa,mmA .:, 1434,621.01 W,e]1J7S Portloao CRY AP Pin Ow=24V21..taln aI su-owa .O a ..,"A' 26 City of Huntington Beach Portfolio Management Page 1 Activity Summary January 2020 through January 2021 weroxnurM_ W.Id NNibr Mempr YenM Nu W AwR ]W u6 ppy .1 lw .. 0Mw.rm Awrpa A`^reYa Eip Yw 6 udI Bab. Eq.N . E.0 .t Rab WrtMM Reeaemae T.. Days W Y ,a, Janlwry M20 48 251787.638.58 2.117 2.146 1.W67 1 2 1,043 592 February 2020 49 2A.2N.023.87 2.115 2,145 1.912 3 2 1,108 569 WmN M20 Q 245,631,098.T2 2.143 2.173 1.787 0 6 1,D16 660 Apr9 2020 51 245,648,12694 1.862 1.893 1.646 ID 3 958 685 Wy 2020 48 V6.251.912.39 1.791 1.816 1.363 D 2 943 668 June 2020 47 268.106.206.25 1.602 1.624 1.217 1 2 809 591 JOY 2020 40 254,W1521ae 1.610 1.632 0.920 0 0 920 652 Au9Da1 2020 40 238,570.893.05 1.582 1.604 0.284 0 1 917 621 6Rptember 2020 39 M.W.508. 2 1.5D4 1.616 0.685 0 1 935 606 Octaba] 2020 38 216,815.117.12 1.620 1.652 0.620 0 6 885 518 November Z020 32 205.ISB,O91.a8 1.491 1.512 0.S 5 0 1 725 398 December 2020 31 221,313.36221 1381 1,4W 0.S O 0 0 680 355 January 2021 w 245.184,70647 1292 1.310 0.458 5 2 798 474 A-., 42 242,830,33152 1.7M 1.233% 1.114 2 3 903 626 P0r0060 CITY AP 4.n Or Ov1I]f@I.11G1 N l o W I]Jn W[m W.]SCI 27 City of Huntington Beach Portfolio Management Page 1 Interest Earnings Summary January 31,2021 January 3161onO Ending Fool Year To Data C01COuyOnl11scount lnwtrnerds: Intemst CW,,Iod ]8'1.692.50 2,079,238.15 PIU3 Amued Intere$1 Of Ere of Perin 853,852.BT M.852.82 i.e..Acwed Wereat at ea9lnwg of Period ( 762,026.0% ( 292.361.15) Leas ACOtCd Ir terest at PYrtl1Il39 Dwug Period ( 0.M) ( D.00) DOcreal Earned awing Period 2M,517.0 1,W,726.27 Mj zt.E Iry Prerniwe are Dismwas 40,1 M,26 -29e.194.42 Mp oted 0y Ca"Go.or Lm.ea 4.107.87 25.5]5.59 Eanvgs dwug Periods M1.218.95 1.673.1M a4 Pass Tnmu9a securities: Nteml Coaected 0.00 am PBu Accrued tMere31 at End of Perea (tw O.DO Leas Aatued Wernt at Bepwmg of PWOol ( 000) ( 0.M) Less Aeon y Werest at P,a 3 Dwtrg PWod ( 0.00) ( 0,00) trttereti Earned during Pend 0.00 0.00 Adjusted 0y PreMwm end Dnaants 0.00 0.00 Ad snbal try CapiW Caine or Losses 0.00 0.00 E..ns awing Peroda 0.00 0.00 Ca3NCMoain9 Arsounta: Interest Co0w 66.954 39 S 5.153.73 Pfin Massed Wernt at E m of Pend 78,081.59 78,W1.59 Less Amved Interest at Degcadig of Pend ( a7,066.02) ( 241,652.34) brl..V ftm during Period 57969.96 381,582.98 TOW Worn Earned duMg Period 313,M.W 2,322,311.M Total Adlueonenta from Premiums and Olscounts 40,130.26 . 9,f94.42 Total Capital GaBw Or Losses 4.101.a7 M,0&59 Total Eamings during Period 264,246.91 2,054,62142 Ponfolo CITY AP P,nea aYt]nQ`.r3.a• CY�_�1]Sri a.aay..roe+ 28 oo �1NVE5T,}rF�� State of California Pooled Money Investment Account Market Valuation �'�'r.uaum.• ,c 1/31/2021 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Bills $ 43,016,868,322.06 $ 43,036,499,500.00 NA Notes $ 30,448,168,575.01 $ 30,639,943,500.00 $ 110,537,124.50 Federal Agency: SBA $ 449,271,012.06 $ 445,182,475.90 S 190,991.90 MBS-REMICs S 12,369,723.03 $ 12,987,966.73 $ 57,286.73 Debentures S 3.549.907 951.30 $ 3,561,699,010.00 $ 6,078,759.59 Debentures FIR S - $ - $ - Debentures CL S 500,000,000.00 $ 500,024,000.00 $ 930 388.00 Discount Notes $ 15,523,629,902.60 S 15,530,388,830.00 NA Su ranalional Debentures $ 417,755,642.96 $ 417,720,400.00 $ 1,645,744.75 Su ranalional Debentures FR $ 150 065,910.68 $ 150,121,981.20 $ 28,774.30 CDs and YCDs FIR $ 300,000,000.00 $ 300,072,000.00 $ 104,868.42 Bank Notes $ - $ $ - CDs and YCDs $ 16,050,000,000.00 $ 16,050,125,657.09 $ 12,312,902.80 Commercial Paper $ 8,293,678,777.75 $ 8,297,507,298.63 NA Corporate: Bonds FIR $ - $ - $ Bonds $ $ $ Repurchase Agreements $ $ - $ Reverse Repurchase $ - $ S Time Deposits $ 4,288,500,000.00 $ 4,288,500,000.00 NA PMIA&GF Loans $ 693,695,000.00 $ 693,695,000.00 NA TOTAL 1 $ 123,693,910 817.45 1 $ 123,924,467 619.55 1 $ 131 886 840.99 Fair Value Including Accrued Interest $ 124,056,354,460.54 Repurchase Agreements,Time Deposits,AB 55&General Fund loans,and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). 29 Statement of Cash Receipts and Disbursements and Summary of Cash by Fund 0Finance Department January 2021 Cash Receipts and Disbursements December 2020 January 2021 Receipts General Fund Property Tax $ 23,531,268 $ 14,515,216 Local Sales Tax 3,282,385 3,178,964 Public Safety Sales Tax 236,271 201,345 Transient Occupancy Tax(TOT) 2,933,333 375,609 Utility Users Tax(UUT) 1,470,389 1,545,805 Other Revenue 657,460 3,539,862 Total General Fund Revenue 32,111,106 23,356,801 Total All Other Funds Revenue 25,360,240 9,364,649 Total Receipts S 57,471,346 $ 32,721,449 Dlsburscmonts General Fund Personal Services (14,165,520) (10,705,167) Operating Expenses (1,651,578) (2,531,839) Capital Expenditures - - Non-Operating Expenses (330,125) (4,208) i Total General Fund Disbursements (16,147,224) (13,241,215) Total Ali Other Funds Disbursements (21,480,301) (15,715,753) Total Disbursements (37,627,525) (28,956,968) $ 256.830.465 Net Change in Cash Flow $ 19.843.821 $ 3.764,482 Summary of Cash by Fund December 2020 January 2021 - General Fund 30,869,901 $ 40,985,487 - General Fund Other 4,890,761 5,064,362 - Capital Projects Funds 23,865,252 23,163,253 - Debt Service Funds 15,969,807 16,463,505 - Enterprise Funds 91,055,460 87,636,236 - Trust and Agency Funds 15,097,4213 14,322,807 - Internal Service Funds 30,701,379 28,855,954 - Special Revenue Funds 40,615,995 40,338,861 - General Ledger Cash Balances $ 253,065,983 $ 256,830,465 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above Information was obtained from the City's accounting system records.The above information Includes receipts from maturing Investments and payments for purchased investments In the city Investment portfolio.This statement Is prepared In compliance with the City's Charter, 30 0Cay of Hun*n Im eeatl 200 City of Huntington Beach Iwi,ia Portfolio Management HunUvWn Been. Portfolio Summary February 28,2021 P., ISarbt e k %W rJFYFm rn rn lrt.mL w ww VaN. wu. PpTdb Tm WGNY 360 EquIv. NS EqU . F.M1raIAq.FCY luw'Cnry NOm.Om 00 M.SW.4WW M,1{9 YSt�1 M.S+ ON 9N 1.393 1.716 LYal Ap.rcy Nwftmem FUMF N,363 tpp 33 N,SIS.Ma.D N.Sa3.b935 1419 1 1 0,101 0407 i�Yury 6eturtkf.fdron 9.CW.W000 a,]U.160.m ].9n] ,59 3" 1.N3 1.091 1.566 1.567 ll.,fun lvm NOm IU.000.Om 00 N,W,.,W,w M.M1,311,13 a37 1,153 1,W1 1.M 1]1] Cvlvn;p 51013,W.71 1%127.4133.0 M.N 1.133 Na znl 2252 OPANGE CQINIY POOL 63,16],]6631 63.1a3,71111.21 65,Ia1.7a41 M.p1 1 1 0-IW D661 Ial,2a;TT].M Sa5,1]0,061.13 24l,916,392.00 100.00X 921 471 1.339 1.M6 WvaStrmNe Lae and AeerlNed irilt.t Pmisd lmmeal at VurWse 7,6N49 ]AUAD yAtdsl 16.:5,M 7.6Un Tetel Case and lri e. anM 2e1,242.2"l 265,1T1,720A6 2e1,996,0a6.99 921 471 1.339 1.256 T=I Eamirlgs Fabaary 20 Mon01 Folding Flaml Yper To Date Flscal Year Ending C.Year 251.741.67 2,322."0A9 Covent wl 100.000.00 1,500,000.00 1,900,000.00 UV Year A0fu01 a63,01839 3,600,193.15 5,23%. 9.41 Avenge Dally BatmN L ,W,561.06 332,669,t90.M Eex1M Ran of R.W m 1.43 1.6 I rad:b DW Wa mpof ernpateo r 6 a City poobd trmspnens art0 o m nKulnty wo eg Stale laws end 0,brvanem putty an:emela Elect wN 01e City Caac9 w Fe r,1.2021.A rap,Df elu pohy Is eva M at 01e o of dte Coy Clerk.Tee imlarnleg program earapt Yww11 provides sul69enl rase Dow Botid9y W meat me M4 ah m rs o00ga5 M. Markel VaOts 19'bad0-0 DY UNon Hank via lxtti five Data Corpaatbn. Anse eadsaont,Cr Y THE URIA ReponNg pe OM`II0214WJ=21 Pordo90 CRY AP M On o3a+/d41.mn PY 1PgF w+l YSo p.9mv..na+ 31 City of Huntington Beach Portfolio Management Pago 1 Portfollo Details-Investments February 28,20211 A�vnn,. .SIP 4., P., sUAInval" 8,Io.V.I. S&P nh, Q,Il FoodMI Agenc,UI;Uft-COUdOA 313MCIt)(45 4M FeIdInil Fann C.sa�� W�19 S'�'Ww 5.003.011,55 2 As 12M 1.108 =1=021 313%EWtGI M F I F.C.� OMIMI, S.DDoodow 5.10G.M00 A.WS4�44 1.7w 1121 "1 OTMIMM 313�ft 4"1 F�H—.� 1�18 s00000:w 5's,%.Sp).W S.W'500�7 3= Z743 5N �3 3130A�I �20 Fsdsn�.U,sn E" *�q soodmoo 6 X7.100 00 S.W.W.00 2.SSO 7.560 an 0930=?3 31�1� Ini F.A�L. �7=11 6'='OwW 5.0,ouaw 6.005"I"Is 2.260 ."a 102 W1.1 31�15 13M F�� oI1IVXQI S 000000 w 1913,1 W'W 4,995,127.70 0,52, o�5 .,-&I Gv'swd 31�!S 41?1 sedans.L.E.k 01�1 S�00000doo 4,218 Mood 4,997.5M." 0550 OZ61) 1,7M OV�M 31� 13M F Uno B'n", 01�1=1 6.000.000 w 4.92�4.900,00 SoDow.00 01500 a SO() 1.10, 01� 31UG9� �267 F� L-.Mon ml�i7 5.000.00ow 3'QSA.1 so N 5002,053,47 1.173 M 1.7n IA3 0727AIG21 31�Gov? M F. UsI. IVN)I7 5.DQ0'dddM 4.031.700 N 5mmu" I.V5 M 16, W11=21 3137� 42t7 F. t.na,I�co� �1. s000�do 3,171,721)N I 019.��. 21w 14W w wls=t3 3137�S .2S& Fedens L.Lton C� =1�19 1.000=00 3.,7..720 W 3.020,31165 2'?Sd 1.37 8`0 W:14= 311SCICIP,' �as Fso�Nn.� =114ZO11 5.00(3.00`300 LnSASO DO 5,046.719.2 2,375 24dS M wll� 31�� 1318 Fwd�N�M�U. 0111IM21 3.00d... 2,946760M 3,=,201,60 0.560 0537 1.7n IIAT� S.Iotsbtl..A,ntnig. "'152AS's, ".M'naosa Wlo.�.w 1.711 'M L�j AgenCy ln�nt Funds SYSM2 NZ t-ic' n o�7 0,407 1 S..j 37,471.14437 1"JUISAIX) 34,535,68*.21 UAs,.8'.M 0,07 1 Tm*s.ne Sac.hUss-C.."n 11�8y� M US T...�N.. 12A)SQ019 5 00ofX)O On 5.1KODow 4.9.,646.79 1'1504) i19S 1,344 MOW?4 21MOP79 M US T.�N. 12W2019 3.00dood'do 3,0110.15000 2.615.659 W I W 1574 Tn ow� 3.14o4s....-nn,s I�Aodm sa".1"M 7,$T9,W.6I I'm 110111 MotUu.Te.N.tvS .50'.A� 4M �n oman,,Ug I NX)=00 M.. os�".'n 2670 2 2N 87, oia=an ISSITABY, 4NI tnwn� �19 5.000.D0ow 5"Sr'Sond S'DS)"11.5s 2%0 7.271 us 05`16421)n .112 McI'Aine.�Rsnk o`� "Ood'00ow 1.143.M= 6.112.51.73 1 BOD C.550 7W Oln�a 13's b`1 U�a�t 0111�1 s0000dood 4 923,2W.W 4,2117.M&V 0 SDO 0,512 I.7G2 IWOQOM S.bto.I..A�rxl. ='W.Ow 0 1�17 I..I Co�W Bonds 037.3�1 �2152 �17 fi'�Dod on S.W3150.00 5 W7 621J. X.SO 1.M a �311 5000.00000 5,96.65000 5,10MU 2.400 0. "1 O"Imm Ponlao C1W AU, City of Huntington Beach Portfolio Management P.ae 2 Portfolio Details-Investments February 28,2021 A ^0 UN., nvcna.. amw rn G.99m w6 cusm m 1m.n1• Is— P.V.N. Wlul e va. m. e6 w6k us s w m9 5 GO.P094 Bonds 1067N .39. C.C =1=16 5 00000AIA S zs"sdo 0 5,066.261 SS 1.19, M 2.525 M5 0SQV 2N66]CR$ .Sdo Onnn, 1]]16=19 2615.00100 31A.S5]]5 5012.115.30 �= 2.070 W imim25 3]5556AU] .315 GM Saes' M]3M020 2000.00dC0 2,94.2,01 295 AWN ..M 1.301 VS 1=1=1 4]0]60G6 4293 ..onoilrc 415424.1. SOW,000.W SI37,150.03 5,006,]9].15 2A25 A 2114 47 0601=22 t55200.G9 V'i ism 062YNt3 3,000 OOLLOO 3,020120W 2W3,025.03 1.075 A 1257 516 0 ll= TI3..6C] .250 PEPSICO INC I=IMIS S.MO,W000 51]o.on 1955085.23 5100 3IN SW 0]17=n 5525055A1 I", T.inP6unenb Oc IwImi. 6.OMfL0.00 5,05],95000 49]0].321 1ASO Iw ... OWLS 022 00.25.AW] 1256 UN ' Mimi, 5,000 00 5,107,000.00 �.96525.10 2100 1202 430 OS $O . 90.]5.AL' 1317 UNee, om,,im20 3,713.00000 2,I15,M20 1,714,35522 2150 0.22] 21 G12'[11021 WS2IHWI .31M US Sank NA Cwn.O MVM0 2.000.NX.00 2.139,IW.W 3.M,2.21 1.00 M 1071 075022Y 3 S.bb [end Avenq. .9"S'.6d0 4,433,WOM 65016A6].]t .OJSl,6X4 2152 45 ORANGE COUNTY PODL MPI 01 Owns co nn me+I PW 6S.163.705.21 65.10,70021 95,153,7521 0503 0503 5u51oua.n0 Awnp. t9,f4,93t0. 65.193p58.11 6,163,79031 tLIOVLAI OA03 1 Tool.nd..V 2M".SSIN 2.1,2.2,2]].4 2.S1T0061.15 2.1,926,39200 123t Rf P.mmia,CRY AP 33 City of Huntington Beach Portfolio Management P9 ) Portfolio Details-Cash February 28,2021 •,.np• wmnn• awae rn oq•m CU51P Nr•atm•ttt• Nwr p•t• P•rVW WM1N V91oa BootVW. pM• 91P ]6S MnuNv •r•rp•a.dM• 0119 ImuM INwrt•1 Pu I,e• 7,l51.09 )659 59 9 SUGbW ).651.99 7,85999 Total Cult 2416MAWA9 U" 471 Poatao GnY PP •u,IL.matmxt-am Pu lPpf_WSI]a9 34 City of Huntington Beach Portfolio Management PeB e1 Activity By Type February 1,2021 through February 28,2021 SUW TnnMctlon Purtlu�m RRinpbom CUw N... Wun R. 0b wWpoaib dNVltl4wab BRBWR Fadarei Aganry M.U.-Couoon 9uGN01 H.14.b61/1 Local Agency Inve ent Fulls (I nttlty Summary) b SW2 M LY C4 047 OW 7,W000000 6WNYI ODO iAm.WO.W NAN,U3.2] Treasury Secudi -Loup buMubl i,bi9,]0{SS Ns01um Tenn NW. Su0bb1 20,L51,2ttd3 Lo)porete Bonds Syllml UA2)A]SU ORANGE COUNTY POOL(ftn"Summary) CCPt 01 Cvup co- bred Pod O.CO] 4,ON.]b 351,w 5.M U,Oala 5Aum 65,142.7Wt T0W U,pa.]6 i,oWAfas2 SNAR,HLOO POdfolO CIP! AP mn oa m'J4/!mt.ma vu(Vas!Wl I"nwn+vs.Lxm 35 City of Huntington Beach Portfolio Management P.9.1 Activity Summary February 2020 through February 2021 ram m um,my Me w N.�, Nunn Mo.0 Na�e..m A.Nnp. D6e 26c Pom ma...e..m am..,mv.n A....9• AM F] r.v e—•,Atis D.anc. FquaJem EquMNnt p.a VurtNW ReSeeeaO T.— DM.Nkuu r F.b , 2020 49 250.2 .W3.82 2.115 2. 45 1.912 3 2 1,106 889 Wmh 2020 Q 245,831,D98.n 24A3 2.123 1.787 0 6 1.018 600 Apm 2020 51 245.8.8,128.9. 1.882 1.893 1.810 10 3 950 885 May 2D20 T0,251,922.39 1.791 1.818 1.383 0 2 W3 666 Jum 2D20 42 208.108.20675 t802 1.62e 1.212 1 2 809 591 July 2020 40 2 ,023,5=.48 1.810 1.632 0.92D 0 0 no 852 August 202D 40 238,520,893.05 1.582 1.fi 0781 D 1 917 821 S pnmb.r 2020 N 225,u7,509.11 1.59. 1.816 0.685 0 1 935 000 Oct , 2020 38 210.8i5,112.12 1,629 1.W 0.82D 0 6 e85 516 November 2020 32 N5,158.091.M 1,491 1,512 0.5 e 0 t 225 396 W .mb.r 2020 31 221,313,38271 1.U7 1.1 05.0 D 0 w 355 January 2021 M 245.16.,206,47 1.292 1.310 04M 5 2 296 .24 Feb., 2021 ]+ 2U,M8,581J% 1.338 1.356 0a07 D 0 821 421 Av. , 41 242,113,211. 3 1."9% 1.622% D.99a 1 2 am 866 P9rRObp CRY AD Rno.A ovJ+r..¢+.roa eu lvn._nr.11�9 e.omv..rss. 3e City of Huntington Beach Portfolio Management Pape 1 Interest Earnings Summary February 28,2021 Fe Wary Month EMIng Ftra1 Veer To Date CDICoupoNDlscount IrrvesOnenu: (merest Coiectecl 18],p00a0 2,276736.75 Pan Acmed Merest al Ertl of Period ]12,5]9 u 712.519.H Less Am,sO Weresl at Beg of Pence ( W3,95217) L-es;AAra„ed wemt at PIaU,aae Dos Perm ( 0ao) 1 0.00) Interest arr ed dum,g Period 255,226.7 2.198.4ss.0,L Hnl,mrm by Premims"dram a9.507.e2 a3a,o0z.w Adj.aea by Csgtal Gobs or Loss. 0.00 28.515.59 Eami,gs dui,Periods 215.919.15 1 H9,028.59 Pm Tbrn.,h 89curhies: Inleresl ColleUW ew 000 Pon ACQOep mlorest of End of Period 0.00 0,00 less Adfiued lM t al Begirt.,of Period ( ew) ( 0.00) Lou Aolaued Imerml At PUWse Durft Period ( efe) ( 0.00) INcrest Eemed dung Pence Oa0 0a0 Adbatee by Prer 6 and Dismums 0.00 0.00 AGpmee Dy Ce"Gain or trade Oa0 0.00 Earriinps df M Peiods ew 0.00 CnNCIrcUN Aeceuma: Ir'l.t G Vod 48.028.38 593.182 09 Plus AfS11KE"eml ai Erd of Period 81.882.55 81,88 m la••AKtued Weresl al Beglmig of Period ( 78.081.50) I 241,652.31) Inlamst Eerred cl i PemO 51.029.32 a33A 12.30 Total Inlereat Esmad purl.,Period 301,55a.09 ;629,a87.34 Total Adjmlmenn imm Premiums and Dtwounn 49,807.62 Ab1,00iW Total Cnpital(fain or Losses ew 26,5]5,59 Toml EamiriV duri,p Period 20],]111447 2,322.H0.89 Portfolio CRY AP m.o0 om,me,-m a w o+._wm rso eso,v..r.sa 1 37 �o��,j 1nVFS),�F�� State of California W Pooled Money Investment Account Market Valuation 'w"4 uoui0', 2/28/2021 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Bills $ 43,170,201,363.08 S 43,190,546,500.00 NA Notes $ 29 845 413,644.53 $ 30,012,425,500.00 $ 71,053,930.50 Federal Agency: S13A $ 438,808,221.44 $ 434,764,905.88 $ 186,739.08 MBS-REMICs $ 11,772,067.72 $ 12,358,396.60 $ 54.637.34 Debentures $ 3,874,852,220.39 $ 3,883,257,390.00 $ 5,268,175.41 Debentures FR $ - $ $ - Debentures CL $ 600,000,000.00 $ 598,742,000.00 $ 197,056.00 Discount Notes S 14,075,433,660.81 $ 14,081,053,680.00 NA Su ranalional Debentures $ 770,582,759.62 $ 769,064,950.00 $ 2,562,773.75 Su ranalional Debentures FIR $ 200,109,832.56 $ 200,141,474.18 $ 86,720.84 CDs and YCDs FIR $ 300,000,000.00 $ 300,069,000.00 $ 150,943.19 Bank Notes $ - $ - $ - CDs and YCDs $ 15,150,00 ,000.00 $ 15,149,230,774.92 $ 7,307,291.66 Commercial Paper $ 10,342,429,152.73 $ 10,345,923,180.54 NA Corporate: Bonds FIR $ - $ - $ - Bonds $ 14,966,250.00 S 14,787,750.00 $ 6,708.30 Repurchase Agreements $ - $ - $ - Reverse Repurchase $ $ - $ - Time Deposits $ 4,229,500,000.00 $ 4,229,500,000.00 NA PMIA&GF Loans $ 693,695,000.00 $ 693,695,000.00 NA TOTAL 1 $ 123,717,764,172.88 1 $ 123,915,560,502.12 $ 86,874,976.07 Fair Value Including Accrued Interest $ 124,002,435,478.19 Repurchase Agreements, Time Deposits, AB 55&General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). 38 ,,,,_� Statement of Cash Receipts and Disbursements and Summary of Cash by Fund Finance Department February 2021 Cash Receipts and Disbursements January 2021 February 2021 Receipts General Fund Property Tax S 14,515,216 $ 73,522 Local Sales Tax 3,178,964 4,400,343 Public Safety Sales Tax 201,345 198,888 Transient Occupancy Tax(TOT) 375,609 361,304 Utility Users Tax(UUT) 1,545,805 1,492,201 Other Revenue 3,539,862 4,462,752 Total General Fund Revenue 23,356,801 10,989,010 Total All Other Funds Revenue 9,354,649 9,243,150 Total Receipts S 32,721,449 S 20,232,160 Disbursements General Fund Personal Services (10,705,167) (10,062,574) Operating Expenses (2,531,839) (3,277.246) Capital Expenditures - - Non-Operating Expenses 14,208) (259,856) Total General Fund Disbursements (13,241,215) (13,599,676) Total All Other Funds Disbursements (15,715,753) (12,841,706) Total Disbursements (26,956,968) (26,441,391) Not Change in Cash Flow $ 3,764,482 $ (6,209,222) Summary of Cash by Fund January 2021 February 2021 General Fund 41,272,237 $ 38,661,571 General Fund Other 5,067,050 5,089,042 Capital Projects Funds 23,183,990 22,173,310 Debt Service Funds 16,475,349 16,283,582 Enterprise Funds 87,726,690 88,569,572 Trust and Agency Funds 14,334,971 12,276,430 Internal Service Funds 28,882,506 27,749,507 Special Revenue Funds 40,119,962 40,050,521 General Ledger Cash Balances $ 257.062,756 $ 250,853,535 Total cash will differ from Investment portfolio total due to outstanding checks and/or other liming differences. Note: Above information was obtained from the City's accounting system records.The above Information Includes receipts from maturing Investments and payments for purchased investments In the city Investment portfolio.This statement is prepared In compliance with the City's Charter. 39 City of Hm Wton Beach City of Huntington Beach 2000 Main S6 Portfolio Management Portfolio Summary March 31,2021 aar W. Bonk %0 dar.m Y1s1 nr6 InvKhnOniL wme Vdua Valu9 Pprtldb Term WNMy .HO EpuN. Sa.S EpuN. F.al.yercylawn-Cnupn br,0o00.'V.00 65,136,60.10 64.141.N0.61 26.37 t,53o Wa 1.645 I.7I3 tmll{eKy lmutmenl FwW 19,363,16a.23 3.4.565.e69 t 19,565p6121 16v 1 1 0312 019 Trufury Scwaw-fad a,000.W.00 63b.910N 7,910,57a e3 1. 1,543 1M 1.566 1361 YdunTemlNdvs =am.t W.00 M."An.00 ",W..52 612 1A53 1000 1.Y11 1,316 Ccey nt aWs a5,263.00000 47.IW,SW.74 46096.S13.00 9an 1.2N 495 2.L3 2.375 ORANGE CWIT'FC 65.2M,1929e 65Y19,e92.)1 63,229,e92.i1 2181 1 I n615 0621 2a;517,961.97 246,164,176.71 243,2v4,20010 100.00% 812 451 1.272 1.290 Investnents Cash and A=Ma6 IMJrast Afin1M 0 hhd M P1nCu5a 16tS.89 7.6u 69 S,bhnal 2.63689 2.698.H Total Lash and Investments 242,577,931.97 246,171,Mso 213,2a1,359.69 612 e51 1.2T2 1.290 Tool Eamings Mar6h 31 Month Ending Fiscal Year To Data Foul Year Ending Cwrera Year 251.5a523 2,M2,94p.91 C.1 Bleget 100,000.00 1,800,1100.00 1,900p00.00 fart YBar Aralpl 437.4T 12 3,930,741.97 5A62,27189 Avenge Dail,Bids. 2e1,726,T,1 . 5 233,693,950.46 ERectiva Rate of Rahn. 1.2m 1.54% I mr4l,that inis report atcrostel,rands a9 cny Pooled irveetmertla and is it conl9rmty wo al Ste,Mvn 9nd the ilaestmala policy a,thnYnl end wh 01e CM CwwA on Femdery 1,2021.A miry of this policy Is ava9at*at 01e of6w Of 010 City Clerk.The 9restrrcnt Wg2ram herein S.provides.u. ht rash 0vx 6Rudity 0 meet the rcat s monEh'.oEOgatlau. Merkel VaMes th rnded by Upon Bank vi9 W696c9ve D6,Co wwbn. Aftsa Ba6kstrwn.CITY TREASURER Reponn panod 0301ra021-0 111021 Paddia,CITY M sandy ONYIW I..ew FR IPRFJUO r.3o RWIlb.I161 40 City of Huntington Beach Portfolio Management PAge 1 Portfolio Details-Investments March 31,2021 •wn9. w.au. Par VY CU R. rn Omm rrtuln 9P Nrwtnan• ft. MarYN V,Iw Sock VYw yp Jl54aevM NO Federal Agwsy Issues-Coupon 31nEC.5 AM F.OrI Fern S,OO ,Ixx.w 5.273.9501O 5OSI]I].91 2.2W M 23b 1,077OLI3202, SIJJENTGI AM Fadyy Ism Cn4l Emt O)AIM19 500OW,W S,1 W.SOO.CO 4095.M.17 1)50 +.02, AM 07MVM[ SIJJOJONS A201 FMwYH Lwn Senk 1) la 5'.'Wa,Op 5,321,2ww 5051,91299 3.250 2,743 199 dd5V,O] JINNFAXI A2" Fs1,nl.1pm tN 0Y I% S,WO,000.CO 5,253450.W 5."."w 2.660 2,SW 769 OYJNN22 ,IWA1'MS AM F.H lbn 6N .1.12 50M,000.w 5,021,n&W SW5603.76 2.. 1w )I O lInO21 31W". am Fad.Nan.Bank 0111YN21 5,009000w !0 ..110.M 4,1952+311 0.525 0.5A5 1,75001115,102L llx4 65 A321 FFdW Nan lum tM 0111WIRl SW.00w 4,909,950.M A,99,M81 Ono 0.560 1.75501R 25 31JOA11S3 43N Fadatl.Ldn Bent 01(t6RJ21 5.000OO)w 4,693.300.OJ 5000,43C0O0 0.%l 0.%0 1.TJ OIROIAM 3n4GW% 4257 F.Mama.YorlCap W14M17 S,ttO,000.00 5.025,000.0] 5.002.N6.50 ISIS M 1.M III 07MQIl21 313AG92y2 And FadaNl l NalCad ONla=17 S.OW.000,W S.M2,7OO.W 54W2.509.)9 Lan M tM In O ITOM 3137EMNS A297 Fa0eY Nara LYn YMCM 01 19 J.OW.OW.W 3.166})0W 3018,)9T.)9 2.250 2AW 6W (,,9Q= 313)EIENS AM. Fw,NMow LwnW (UAP OYI411011 1,000,000.W S+W.nO.W 3,0196 Aa 2.750 L13) 6W O lI n 3InGOW3 And Fad.NAM Mv;Naac OVISF213I9 S,OW,000.W 53m.lw.W 5D4I.152AI SA75 2465 69A 01l2 3 2135GF321 old Fad.NalAl tA„¢ 01111=21 3W0.Ow.W 2.9A0,N0W 3WI,14684 on O.nz IAa111111=s UtAtnW aN AwraO. 64,144}W33 4.Ow,Ow.W b.]26.6W.00 u,141}NA1 1.715 1O6 L.OGI Agency lnvei0nml Funda SYSM M3 IJCry 30}65.lwn J9.Se"9.23 39.566.09.23 0,W 0352 1 Suebyl and Awr,} 35.563,2]l.1) 19A56.A89S] 35.f96,A3S33 35.595.4913 0162 1 Tramury SecurlOws-Coupon 912628"7 AM US Trenuly Ndn +2AYA+9 50W.OW.0 51)0,)0.W !BU,OJA or 1.500 MA 1515 1.271 W9M32A 9+20 PI, Am USTredvyN +2mY 19 3.000.=(a) 3.026.2W.W 2.2115.04A 6 1AW MA vn, 69a 02aarS02i SUS1daI.w Awn9. 7,97,.601.13 S0WA00w 82A6As0.00 )A)9A26,3 IAS) tOw Madlum Teym NOua A5616V4G1 AM 4M.Mu,vn dv.Bank 03262L19 A.=OW.w !.5.=W A052.30362 2.e70 2270 040 01/t . .5616N911 AM Yaar.4nendl DCv.S.nk 0Y26r20+9 5w0W0.0 52+1,6.50.w 5,07,Am.W 2.w 2221 U7 OdnMM A5016V.CT1 .11, trat rtan Oay.Bank WSM020 6Ow.=N 6,135,420.0 6,11411090 1.6W 0.:A 00 01130(A33 A590w" 4319 WSa Pwcana0.Mmen1 01112A021 S.w ,cm,w ,,,X nOw A,992,37567 aSW MA 0.512 16111U26'N25 Sualaal arW Av,n9a 3112A6,0fa]9 20AW000.00 20,516,210M 202al..-S 1,316 I,000 Corporao Ronda 0)63]Mt AM A drA, ON 17 S,M,w,N 5,011.4Wm 5'O.'e0.16 2650 M +.940 350SW2L2t W)03JDE) A313 AOpaec OA?9/ S.Ow,O w 5,10A,2W.w S,I,3,S60.16 2.W 03M 652 01nY2R23 Pond CnY AP ea1D..prnaml.1.a 9v rFra_P1m r10 N WAV&l City of Huntington Beach Portfolio Management P.O.2 Portfolio Details-Investments March 31,2021 Awn, Pumlaaa ataW Ylu Banm wNM' CUSP C,w6trllunl• wur 1 pn Par Va6u wrbt Nau El.Y Value Par, SAP ]66 wN2y Win CorpOnU BOBEa 1561b.I115 .Ma C.Clop OY3V3019 S,000,OOOW 5,370,1WW 5.065,62..1! 3.10, M 15. .1. O amn 2Y661CW I= D" 1L16ROI. Z17SOW 3.113.962.0 3,CO1693.31 .ON LO10 913 I=,== 325556AV1 131S G4eW saalum DV3NM9'1 ;a".000.W 2,93I,M.24 3,915,173.w 4IN 1,337 214 IMIM21 U]0)6BG6 a293 H.o,eepat I- W2II7019 5,0O.OW.W S,t25,aW.W 1.W621067 3625 A L47. aM 06O1.T022 IS22WHGO 122. IBVC OL'IMOta 3.0W.Mw 3,Wa,4W.W 29461n as 1.875 A S2S2 467 OMI1022 21Na6C%a 4250 PEPSICO WC 1.11301a S,WO.OW.W 5,104,CN.W 4,996]22.01 3.IW 31" 17202112R022 N2um, 42r9 TenelniTnenO Lc 1L2%Wig S.WO.OW.W S,OM,SSO.W 4,935,11I.6a I 3.554 am OYIS'N22 9M264A'M 4225 UNeMr 01 ,=I, 5,OW,ONw 1,096,)W.W 4,966.6a1.07 L21X 2.N2 399 Owwon N331NNV1 45011 US BniN Cr 02111.'A20 2.OW0W.W 3.IY,SMIW 2.055.25 34W M 1.671 a4 0I14,7023 6udoblaM Awrya b419A&A: 45.263A09.00 Q.186,6WAa 46pN,666.W L226 Is O0.ANGE COUNTY POOL OCPI 01 oaayaC yNw1 Wd 05,229!1224 a6.229i92.74 63.229,.92.24 0524 0524 I SUOmnIaM Awn, 6S,lUla2da 4S,2..41LT4 WM...Va 6L22S.432.24 0.621 1 TdalaM Awn, 241.336j42.06 24LMAIA9 2WIGI.176.11 M,VA,M= 1.290 "I Portion CnY AP mn Or pnvnl-1.n ru ry+r wn r>O 42 City of Huntington Beach Portfolio Management PAp 3 Portfolio Details•Cash March 31,2021 Arn9e Rol6A9M mA BM 1A CUSP her, peb Pv Va Marts Vehw BonevJ Rale %P ]66 tlYUNv A—,e BeMAu AM An NMag.P 7.658.19 7.656.69 a S. 7.A566e 2,656.69 TAM[CW aM Nva[(men0 S11,226,7A346 242,M,361.97 266,171,62[66 212.29113.66 f]W A61 PO&OID CRY AP aN CWe 0u,5g62��L IA ou�PRf_IY21)A 43 City of Huntington Beach Portfolio Management Page 1 Activity By Type March 1,2021 through March 01,2021 SbW T,ansscp PurtNpw av0xnp[Mne CUSm Imwtmunlf W,ac a.. Ua1u oc 0.p—na uVA1Mr h 8elance FaftnU Agency Issues-Coupon suM l 4.ttl,]4e11 Local Agency Imealmanl Funs (Yaawely Summary) Snrex N2 l.acry o.3S7 s,ocO,03coo 000 suM l sA00,a00S0 am 1,06Ns.23 Tmasuny Secur cs-Caupon SumobI }AnA}tca Me01um To.N.M SuatGal ID2411 A, Corporate Ben" %N} XlO 1317 unw 2.70 MY 21 Om 3,}IO,OW.00 Suatclal Sm I.110A0a.00 afA%.S,00 ORANGE COUNTY POOL (Monmly Summary) pLpt 01 Onryec Wa,nu Pod aex. UeSS.}o 3,2U,26 suhnnal asA54.1s 3.1v.xe ".M.MU IDtal A".,U.79 2172RH15 2UF•IIDOm Pgtt0s0 CRy AP au+pas pnvnn-tc oe w ryas wx1}AA p.ponv.,use 44 City of Huntington Beach Portfolio Management pa9p I Activity Summary March 2020 through March 2021 YW bNa4ultY Yuuptl NurtApr NumWr Warm NunAer pl •vtnpp ]{0 llf Mel dinvwMNp dNvnprcnu •nr •wra9u fvG Yuar 6tturiWp 6>unrJ EpulwNnt CpuNaled RLe purcGaW RMopmM Tmm Dayub WNrky Marty 2020 47 245.831,M9 n 2.143 2.1" 1.787 0 6 1015 660 April 2020 51 2a5.M$128.P 1.867 1.89.3 1.648 t0 3 9M 886 May M20 411 276.251.9n.39 1.791 1.816 1� 0 2 943 866 JU. 2020 O 268,106,206.75 I'M2 1.624 1217 1 7 IM 591 JuM 2020 40 2 ,073.523A6 1610 1,632 0.920 0 0 920 652 Au9un 2020 b 238,570.893.D5 i.M2 1.B 0.7M 0 1 917 621 Upwordw, 2020 n 225,aa7,508.n 1.5" 1.816 0685 0 1 9M 808 October 2020 U 216,815,117.12 1.629 1.852 D620 0 6 885 516 Npvambar 2020 32 205.15 W. Q 1 A91 1,512 0.576 0 1 725 396 Dpc Wr 2020 31 ni.313.362.71 1.387 LAW D.W 0 0 680 365 January 2021 36 245,184,705.0 1.292 1.310 DA58 5 2 7" 474 Fpb.ry 2021 3a 2M.M6.581.08 1.308 1.356 0A07 0 0 821 471 March 2021 3a 241,7n.743.55 1,272 1.290 0357 D 1 812 451 •.uPpp a0 261,M8,251.n 1.W% 1.606% 0.674 1 2 663 550 POnbfp CITY M Mn Gu ON'lAYlf.1a2 Pp pR[_PaN11 a0 pvnvr.7la.� 45 City of Huntington Beach Portfolio Management angel Interest Earnings Summary March 31,2021 Na]ch 311donth Ending Fncal Yee,To Data COMoui,mW iscWnt IrIK6Unent6: Interest Cameo 239.367.50 2,515,624.25 PWs A=nx,d Inderest at En of Pella 12)297.24 T2T,29714 Less ATJuea imereal at segcrvrg of Pena ( 712,579.m) ( 792,]61.15) Leis AmuM Werest at RaWsa During Pe,laa ( 0.00) ( am) Ill aat Eernoa aua,g Pella 254,10.3C 2,IKWI.3 AO.Idd try Prem4am and gardatts -37,Bt9.n -371 W." Aapctcl by Captal Gam or I-oases g.00 28,3i 5.59 Earrings aunlg Penoas 216,219.5T 2,1DE248.16 Pau TNough 9acurltln: aae,nt Caseectl 0m 0.00 Plus Acmred 1mem31 W En of Pena 0.00 000 Lass Ayuea Irso e5t a1 B gag ug o1 POMa ( 6.0a) ( g.0a) Less A[pYea Edema!at Pu loud Dunrg Perm ( 0.00) ( 0.00) Imeresl Earned aura,Perga o.o0 0 N Ad,6K t by Ple]nvms all Dncouw 0.00 0.00 AdprslW by Capdal Gam m Losses 0.00 0.00 EB NW or"Pmoas D.Do O.DD CastVChacking Amounts: InferestcW d 40,958.79 6a2,tAp.88 PM Amrued Interest at End of Pena 127,200.21 127,208.21 Less Ace uea Incresl at aeguaung of Period ( 1306a1.3a) ( 241,852.3a) In:artal Eames durt,Period 45.325.66 5V,696.26 Total Intan at Earned during Parod 299,430.96 2,918,257.09 Total Adlusttnants from Premiums and Discounts 42,665.23 471,667.TT Tots1 CapIM Gains or Lossn D.w 26.V&59 Total Earnings during Pedod 261,5a5 23 2,632,9a1.91 P aso CITY AP M W riPf_Pla ,to 9gol Vim.]Jdt 46 �oat,E tNVESTyf�9 State of California W Pooled Money Investment Account Market Valuation 3/31/2021 Carrying Cost Plus Description Accrued Interest Purch. Amortized Cost Falr Value Accrued Interest United States Treasury: Bills $ 42,371,427,061.33 $ 42,386,167,504.27 $ 42,394,001,500.00 NA Notes $ 34,202,768,902.61 $ 34,199,307,567.32 $ 34,350,877,500.00 $ 77,660,969.60 Federal Agency: SBA $ 430,882,898.56 $ 430,882,898.56 $ 426,901,230.13 $ 183.183.66 MBS-REMICs $ 10,914,640.74 $ 10,914,640.74 $ 11,455,602.70 $ 50,572.13 Debentures $ 4,617,914,812.55 $ 4,616,241,436.15 $ 4,623,536,650.00 $ 6,528,067.50 Debentures FR $ - $ - $ $ - Debentures CL $ 500,000,000.00 $ 500,000,000.00 $ 498,031,000.00 $ 360,389.00 Discount Notes $ 13,676,588,570.50 $ 13,680,511,421.91 $ 13,681,807,880.00 NA Su ranational Debentures $ 946,090,189.30 $ 945,751,647.64 $ 944,944,800.00 $ 2,605,773.50 Su ranational Debentures FR $ 200,054,814.69 $ 200,054,814.69 $ 200,100,339.85 S 73,545.08 CDs and YCDs FR $ 400,000,000.00 $ 400,000,000.00 $ 400,014,000.00 $ 52,862.59 Bank Notes $ $ - $ - $ - CDs and YCDs $ 14,700,000,000.00 $ 14,700,000,000.00 $ 14,699,439,806.13 $ 8,104,736.15 Commercial Paper $ 9,742,973,999.96 $ 9,745,946,875.03 $ 9,745,873,276.40 NA Corporate: Bonds FR $ $ $ $ Bonds $ 14,967,211.12 $ 14,967,211.12 $ 14,708,550.00 $ 15,458.40 Repurchase Agreements $ - $ - $ - $ - Reverse Repurchase $ $ - $ - $ - Time Deposits $ 4,219,500,000.00 $ 4,219,500,000.00 $ 4,219,500,000.00 NA PMIA& GF Loans $ 693,695,000.00 $ 693,695,000.00 $ 693.695.000.00 NA TOTAL $ 126,727,778,101.36 1 $ 126,743,941,017.43 $ 126904887;135.21 $ 95,635,557.51 Fair Value Including Accrued Interest $ 127,000,522,692.72 Repurchase Agreements,Time Deposits,AB 55&General Fund loans, and Reverse Repurchase agreements are carded at portfolio book value(carrying cost). The value of each participating dollar equals the fair value divided by the amortized cost(1.001269853). As an example: if an agency has an account balance of$20,000,000.00, then the agency would report its participation in the LAW valued at$20.025,397.05 or$20,000.000.00 x 1.001269853. 47 Statement of Cash Receipts and Disbursements and Summary of Cash by Fund * Finance Department March 2021 Cash Receipts and Disbursements February 2021 March 2021 Receipts General Fund Property Tax $ 73,522 $ 4,624,561 Local Sales Tax 4,400,343 2,890,117 Public Safety Sales Tax 198,888 252,765 Transient Occupancy Tax(TOT) 361,304 398,905 Utility Users Tax(UUT) 1,492,201 1,633,851 Other Revenue 4,462,752 5,491,835 Total General Fund Revenue 10,989,010 15,292,034 Total All Other Funds Revenue 9,243,150 12,309,482 Total Receipts $ 20,232,160 S 27,601,516 Disbursements General Fund Personal Services (10,062,574) (10,639,123) Operating Expenses (3,277,246) (2,725,260) Capital Expenditures - - Non-Operating Expenses (259,856) (4,208) Total General Fund Disbursements (13,599,676) (13,368,591) Total All Other Funds Disbursements (12,841,706) (9,819,414) Total Disbursements (26,441,381) (23,188,005) Not Change In Cash Flow $ (6,209,222) $ 4,413,510 Summary of Cash by Fund February 2021 March 2021 General Fund 38,661,571 $ 40,585,013 General Fund Other 5,089,042 5,039,737 Capital Projects Funds 22,173,310 21,868,328 Debt Service Funds 16,283,582 16,759,436 Enterprise Funds 88,569,572 90,745,405 Trust and Agency Funds 12,276,430 11,573,401 Internal Service Funds 27,749,507 27,185,952 Special Revenue Funds 40,050,521 41,509,774 General Lodger Cash Balances $ 250,853.535 $ 255,267,046 Total cash will differ from investment portfolio total due to outstanding checks and/or other liming differences. Note: Above information was obtained from the Cltys accounting system records.The above Information includes receipts from maturing investments and payments for purchased Investments In the city Investment portfolio.This statement is prepared in compliance with the Cilys Charter. 48 City of Huntington Beach Quarterly Investment Report Quarter Ending: March 31, 2021 PREPARED BY: ` ''ALIS'A;BACKSTROM, iMBA, CCMT, CPFIM i CITY TREASURER COLIN'STEVENS, MPP TREASURY ASSOCIATE ❑ Congress passed $1.9 trillion fiscal ' 1 stimulus package ❑ Economic optimismtwith rising vaccinations and increased fiscal stimulus ❑ Unemployment rate to 6.0% for March, from peak of 14.7% ° V"p`il'ILi yyy ❑ March Consumer Confidence Index EAata � yy ��Zti, a ,S�t� . fF� jar"tfi tto 109.7 its highest reading in a year 50 ❑ Equity Markets YTD first quarter s 2021 : S&P up 5.8% L ' DJIA up 7.8% ❑ Federal Reserve held rates stable « s � G1_ at 0-0.25% (since March, 2020) . «� p ;��,;; �}' , ❑ Longer-term Treasury yields rose ``° �� with increased economic optimism i > , 4 r, r while 2-year remained fairly flat r��'1. dF ?� Ell 51 b]. l ] r 'CF •t�• Y 4: ;V� fiS t�F A � f�!I''1L'�I• t2YrTsy Treasury Rates Monthly Averages SY`Tsy 3/31/20 — 3/31/21 —Q-- 10Yr Tsy At 3/31/21: ,. .xt 2-year Treasury: 0.16% �3 r .' r`yr4`. m o 10 year Treasury: 1.74/0 N� 4 R �d 7Yf° <}� rl sty. ;. 2-yr. Treasury t3'r'�t;r;ai' dr remains flat jY .ti �"�� 'l S ZM' ra • R • R e at • • R • 4 F F F Per Section 53600.5 - ,, r + F City Treasurer's Primary Objectives: p • © _ _ ® F ® p k 1 Y ,r 1. Safety of Principal ' 2 . Maintain Liquidity 3 . Market Rate of Return (through budgetary/economic cycles) In this order of priorityr tC �' �fl. �t�..:it3Y� 57 �'L L Per Section 53601 - �'� Specific Allowable Investments include: 1. U.S. Treasuries 2. Federal Agencies: r oFNMA oFHLB o FFCB �x � d44 _i : oFHLMC 3. Corporate Bonds "A" rated and above . � � - < ` • ' 4,• sa V E i4t{'.rL j` 9 ..k4t IL. �g r ♦ 't—FCs'61�L.'}'9. I i.Sl 4C3'# I�t.�,. i 1 iAnvestrnejnt . . . • a y ��porat�folio'=�is� 5 �x: _ N CaIiforniaY'; � y, - , faug-vernrment� Y; GbLdibsS36 ; ps:: ;; > ✓yet--se� - �p � P tom, Snt� YL�,, .F 43 >� }a i.�S! , • . . , - • • - : • � , : Additional Investment Limitations 1 � 4 © ®'. ® ® per Code: Applicability differs according to security type f rC�2{:ir 1'a .•.zf: i J' wT, �y3aS.' ''�Mtr � s ari:aryw� ❑ Maximum maturity of 5 years ❑ Maximum percentage of portfolio ❑ Minimum quality rating requirements ❑ Maximum per issuer requirements L 56 Investment Policy LJ Certified by California Municipal Treasurers Association LJ Reviewed Annually by Treasurer and Investment Advisory Board, Adopted by City Council LJ Must Follow Government Codes — can be more restrictive -'I"k Investment Strategy Per CDIAC "Local Agency Investment Guidelines": ❑ Buy and Hold / Passive investment strategy: Investments are purchased with the intent to hold until maturity ❑ However, market forces or operational needs may occasionally require exchange or sale before maturity ❑ Prudent investment management = Continuous analysis and fine tuning of investment portfolio Portfolio Summary As of 3/31/21 Investment Type $ in 000's Market Value Book Value Federal Agency Issues $ 65,327 $ 64,141 Local Agency Investment Fund (LAIF) $ 39,585 $ 39,585 Treasury Securities $ 8,247 $ 7,980 Medium Term Notes $ 20,589 $ 20,241 Corporate Bonds $ 47,187 $ 46,097 OC Investment Pool 65,229 65,229 TOTAL $ 246,164 $ 243,273 Investments by Type As of 3/31/21 OC Investment� Federal Agency Pool Issues 27% I 27% Local Agency Investment Fund (LAIF) Corporate Bonds' i6% 19% Treasury Securities Medium Term I 3% {Notes Portfolio Earnings As of 3/31/21 Total Earnings Month: March Fiscal YTD Current Year $ 261 ,545 $ 2,632,945 Current Budget $ 100,000 $ 1,600,000 Last Year Actual $ 437,478 $ 3,830,742 Average Daily Balance $ 241,726,743 $ 233,693,950 Effective Rate of Return 1.27% 1.50% Benchmark* 0.1_4% nla ' 12-month moving average of interpolated 1.5-year treasury . F Monthly Activity March 2020 Investment Type Purchases) Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues Local Agency Investment Fund (LAIF) * $ 5,000 Medium Term Notes-IADBIIBRD Corporate Bonds $ 3,710 Treasury Securities OCInvestment Pool* $ 49 3 TOTAL $ 5,049 $ 3,713 *Includes Interest Income �(ir,1j 'r7 Quarterly Activity January - March 2021 Investment Type Purchases/ Calls/Maturities/ $ in 000's Deposits Withdrawals Federal Agency Issues $ 18,000 $ 3,000 Local Agency Investment Fund (LAIF) * $ 5,034 $ 7,000 Medium Term Notes- IADB/IBRD $ 5,000 Corporate Bonds $ 5,136 Treasury Securities OC Investment Pool * $ 130 10,010 TOTAL $ 28,164 $ 25,146 `Includes Interest Income 51 '�. ^, b � N::,- -� y< h�.'t 'j-.1� Y�F yt��„SX << - .` .'It} �9 i : ll •-i Selected Compliance Requirements MAXIMUM INVESTMENT MAXIMUM SPECIFIED %OF MINIMUM QUALITY IN TYPE MATURITY PORTFOLIOI MAXIMUM PER REQUIREMENTS COMPLIANCE ISSUER Commercial Paper 270 days 25%H0% Al, "A" Rating YES State Obligations— 5 years None110% 'A' Rating YES CA And Others U.S.Treasury Obligations 1 Syeara None None YES U.S.Government Aciency Obligations 5years None None YES IBRO,IFC,IADB 5 years 10% "AA" Rating YES Corporate Notes 5 years 30%110% "A' Rating YES Local Agency Investment Fund NIA Up to $75,000,000 None LAIF YES Orange County Investment Pool NIA Up to $75,000,000 None OCIP YES Maximum Maturities No more than 50%of portfolio maturing over 4 years. YES No issues of non-compliance _, ,_;r; �, f° t 1y4 ❑Safety — No principal losses ❑ Liquidity — Sufficient funds for ik s. ii3 c�Xr k . y operating needs ❑ Effective Rate of Return - r % March 1 . 27% FYTD 1 . 50% t_ t ❑ Prudently managed — No compliance issues ❑ Positive contributor to City — ` ` � �' 1 Earnings offset taxpayer funds 65 QU ESTION S ? //-)�/a GJ, J . 19PPRa vt_" 7-D ryr r,_ � City of Huntington Beach File #: 21-051 MEETING DATE: 2/1/2021 REQUEST FOR CITY COUNCIL ACTION SUBMITTED TO: Honorable Mayor and City Council Members SUBMITTED BY: Oliver Chi, City Manager PREPARED BY: Alisa Backstrom, City Treasurer Subject: Receive and File the City Treasurer's December 2020 Quarterly Investment Summary Report Statement of Issue: Receive and File the City Treasurer's Quarterly Investment Report for December 2020, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Financial Impact: Not applicable. Recommended Action: Motion to receive and file the City Treasurer's Quarterly Investment Report for December 2020, pursuant to Section 17.0 of the Investment Policy of the City of Huntington Beach. Alternative Action(s): Deny or critique the quarterly report. Analysis: Not applicable. Environmental Status: Not applicable. Strategic Plan Goal: Strengthen long-term financial and economic sustainability Attachment(s): 1 . Treasurer's Quarterly Investment Report for December 2020 2. Treasurer's PowerPoint Presentation for December 2020 City of Huntington Beach Page 1 of 1 Printed on 1/27/2021 powered LegistarTO City of Huntington Beach Quarterly Investment Report December 2020 e �n lilt I t Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer Colin Stevens, MPP Treasury Associate 25 PORTFOLIO SUMMARY AS OF: December 30, 2020 %of Portfolio Investment Type (based on In 000's Market Value Book Value book value) Federal Agency Issues $ 50,982 $ 49„168 20.5% Local Agency Investment Fund(LAIF) $ 41,561 $ 41,551 17.3%Q Treasury Securities $ 8,324 $ 7,978 3.3% Medium Term Notes-IADB $ 15,730 $ 15,274 64% Corporate Bonds $ 52,643 $ 51,309 21.3% OC Investment Pool 75,11 i} 75,110 31 2% TOTAL $ 244,340 $ 240,390 100% As of December 30, 2020, the market value of the portfolio was higher than the book value of the portfolio at $244.3 million versus $240.4 million, respectively. This was due to the overall decrease in market interest rates over the past three months, which served to increase the prices (value) of some of the existing securities in the portfolio purchased prior to the downturn in rates. Currently, funds within this portfolio are invested in federal agency securities, corporate bonds, the Inter-American Development Bank ("IADB"), U.S. Treasury Securities, the State of California's pooled account (Local Agency Investment Fund "LAIF"), and the Orange County Investment Pool ("OCIP"). Only the investment types allowed under California Government Code Section 56301 and the City's Investment Policy Statement are utilized. The largest holding by security type at month-end was the Orange County Investment Pool at approximately 31%p of the total overall portfolio. This was followed by corporate bonds at 21% of the total portfolio as of December 31. Due to the decrease in market interest rates, some Federal Agencies within the portfolio have been called. As rates within the LAW and OCIP accounts have moved down more slowly than the market overall, such additional cash has currently been maintained in these pooled accounts to obtain a higher yield with overnight liquidity. 26 PORTFOLIO BREAKOUT BY TYPE - BOOK VALUE % of Total Portfolio Local Agency f PORTFOLIO EARNINGS AS OF: December 30, 2020 Total Earnings Month: December Fiscal YTD Current Year $ 272,920 $ 1,836,598 Current Budget $ 150,000 $ 1,300,000 Last Year Actual $ 422,171 $ 2,494,244 Average Daily Balance $ 221,313,363 $ 228,707,216 Effective Rate of Return 1.45% 1.59% Benchmark* 0.42% nfa .12-month moving average of interpolated 1.5-year treasury Earnings for the month of December, 2020 were $272,920, a decrease of 34% from the same month in the prior year. This was due to the sharp downturn in interest rates that occurred over 2020. Fiscal year-to-date earnings of $1,836,598 were down from the same period during the previous year by 26%. It was to be expected that we have seen a decrease in earnings and yield as bonds are called and as new funds must be invested at the current lower rates. The 2- 27 year U.S. Treasury (which is a proxy for the return on investments in which the portfolio may purchase) has remained at historic lows, ending the year at 0.13%. The effective rate of return for the month was 1.45%, with a fiscal year-to-date return of 1.59%. As the Federal Reserve has kept rates near zero throughout most of the year, the benchmark rate fell accordingly. The benchmark of the 12-month moving average of the interpolated 1.5- year U.S. Treasury was 0.42% at the end of December. As the portfolio maintains securities purchased when rates were higher, the rate of return will fall more slowly than that of the benchmark. PORTFOLIO ACTIVITY: MONTH - DECEMBER MONTHLY ACTIVITY: December 2020 Investment Type Purchases/ Calls/Maturities) $ In 000's Deposits Withdrawals Federal Agency Issues Local Agency Investment Fund (LAIF)* $ 34,000 $ 19,000 Medium Term Notes- IADB/IBRD Corporate Bonds Treasury Securities OC Investment Pool * $ 32 TOTAL $ 34,032 $ 19,000 *Includes Interest Income PORTFOLIO ACTIVITY: QUARTER QUARTERLY ACTIVITY: October 1 to December 30, 2020 Investment Type Purchases/ Calls/Maturities/ $ In 000's Deposits Withdrawals Federal Agency Issues $ 27,050 Local Agency Investmentfund (LAIF)* $ 67,090 $ 53,000 Medium Term Notes- IADB/IBRD Corporate Bonds $ 2,500 Treasury Securities OC Investment Pool * $ 35,11.8 (a) 4 TOTAL $ 102,208 $ 82,554 *Includes Interest Income a Administrative Fee 28 COMPLIANCE The portfolio is in conformity with all relevant State regulations and the City's Investment Policy statement as approved by the City Council on February 3, 2020. The investment program herein shown provides sufficient cash flow liquidity to meet the next six months' obligations. MAXIMUM INVESTMENT MAXIMUM PORTFOLIO/SPECIFIED%OF MINIMUM QUALITY IN COMPLIANCE TYPE MATURITY REQUIREMENTS MAXIMUM PER ? ISSUER Commercial Paper 270 days 250A/10% Al, -A" Rating YES State Obligations— CA And Others 5 years None/i O°.6 "A" Rating YES U.S.Treasury Obligations 5 years None None YES U.S. Government Agency Obligations 5 years None None YES IBRD, IFC, IADB 5 years 10% -AA- Rating YES Corporate Notes 5 years 30%110% -A- Rating YES Local Agency Investment Fund NIA Up to $75,000,000 None LAIF YES Orange County Investment Pool NIA NIA None OCIP YES Maximum Maturities No more than 50^/,,of portfolio maturing over 4 years. YES SUPPLEMENTAL INFORMATION Ending ADDITIONAL ACCOUNT BALANCES market value: Balance 9-30-20 * Total Deferred Compensation Plan Balances $163,083,864 CalPERS Retiree Medical Trust Account $31,800,175 US Bank Supplemental Pension Trust Account $63,586,712 PARS Post Employment Benefits 115 Trust Account $7,839,718 Bond Reserve Accounts $8,270,338 'Certain statements not available for current quarter so previous quarter is reported 29 ECONOMIC AND MARKET OVERVIEW MARKET SUMMARY: SEPTEMBER 30, 2020 - CECEMBER 31, 2020 Fed Funds 2-Yr. 10-Yr. As of: Rate Treasury Treasury S&P 500 DJIA 9/30/2020 0.00-0.25% 0.13% 0.69% $ 3,363.00 $ 27,781.70 12/31/2020 0.00-0.25% 0.13% 0.93% 3,756.07 30,606.48 %Change none none 34.78% 11.69% 10.17% The Federal Open Market Committee (FOMC) met in December to discuss the current state of the economy and to examine potential future interest rate adjustments. They concluded that the ongoing public health crisis will continue to weigh on economic activity, employment, and inflation in the near term. Additionally, they determined that the health crises poses considerable risks to the economic outlook over the medium term. They stated, "The Committee will continue to monitor the implications of incoming information for the economic outlook, and would be prepared to adjust the stance of monetary policy as appropriate if risks emerge that could impede the attainment of the Committee's goals." Fixed income / Equity Markets: The yield on the 10-year U.S. Treasury finished the quarter at 0.93%, up from 0.69% from the end of the previous quarter, for a 34.8% increase quarter-over- quarter. The 2-year U.S. Treasury continued to remain near historic lows throughout the quarter. The S&P 500 and DOW increased by 11.69% and 10.17% respectively, over the same period. Employment: Total nonfarm payroll employment declined by 140,000 in December, and the unemployment rate was unchanged at 6.7 percent. Notable job gains occurred in professional and business services, retail trade, and construction. 30 --�'2Yr Tsy " 5Yr Tsy —0 10Yr Tsy Treasury Rates Monthly Averages 1.90 1.860 1.80 .760 1.70 1-6 0 L61 1.60 E60 - D 1.50 1.40 1.30 1.20 v 1.10 1.00 !OYr Tsy 0.4l0 e 0.90 0.TO 0.870 ti 0. 80 O.MO 0.7J0 0.70 60 0.670 0 0 0.960 _62b 0.60 0.50 6Yr Tsy 0 4Q 390 0.390 OADO OIUO 0-340 0.340 0 30 0.280 0.270 0.270 220 2Yr Tsy O.ZO 0.170 0100 0,160 0.140 0.l�0 OA6D 0.1T0 0.1<0 0.10 p 4 p N ev- a a a a a p 31 City of Huntington Beach City of Huntington Beach 2000 Main St. Portfolio Management Huntington Beach, Portfolio Summary ` October 31, 2020 Par Market Book %of Days to YTM YTM Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv. Federal Agency Issues-Coupon 54,000,000.00 56,117,900.00 54,183,776.83 27.87 1,494 844 2.099 2.128 Local Agency Investment Funds 25,551,098.29 25,551,098.29 25,551,098.29 13.14 1 1 0.612 0.620 Treasury Securities-Coupon 8,000,000.00 8,329,600.00 7,977,093.00 4A0 1,543 1,211 1.566 1.587 Medium Term Notes 15,000,000.00 15,761,600.00 15,293,140.21 7.87 1,356 931 1.558 1.580 Corporate Bonds 50,899,000.00 52,800,659.81 51,361,126.73 26.42 1,130 595 1206 2.236 ORANGE COUNTY POOL 40,041,585.78 40,041,585.78 40,041,585.78 20.60 1 1 0.943 0.956 193,491,684.07 198,602,443.88 194,407,820.84 100.00% 885 516 1.629 1.652 Investments Total Earnings October 31 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 325,176.52 1,290,413.04 Current Budget 200,000.00 1,000,000.00 1,900,000.00 Last Year Actual 399,508.95 1,670,233.40 5,155,399.59 Average Daily Balance 216,816,117.12 236,314,396.80 Effective Rate of Return 1.77% 1.62% 1 certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 3,2020.A copy of this policy is available at the office of the City Clerk.The investment program herein shown provides sufficient.cash flow liquidity to meet the next six month's obligations. Market Values provided by Union Bank via Interactive Data Corporation. Alisa Backstrom,CITY TREASURER Reporting period 1 0101/2 0 20-1 0/31120 2 0 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF_PM1)7.3.0 Report Ver.7.3.6.1 32 City of Huntington Beach Portfolio Management Page 1 Portfolio Details -Investments October 31, 2020 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Federal Agency Issues-Coupon 3133ECHX5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,331,550.00 5,003,783.12 2.260 AA 2.236 1,228 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,129,700.00 4,994,305.56 1.750 1.821 607 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,385,900.00 5,061,794.90 3.250 2.743 950 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,292,400.00 5,000,000.00 2.550 2.550 940 05/30/2023 3130A1W95 4297 Federal Home Loan Bank 06/27/2019 5,000,000.00 5.064,200.00 5,012,234.37 2.250 1.840 222 06/11/2021 3134G9N94 4257 Federal Home Loan Mort Corp 06/14/2017 5,000,000.00 5,064,300.00 5,005,360.98 1.875 AA 1.723 268 07/27/2021 3134G92Y2 4258 Federal Horne Loan Mort Corp 06/14/2017 5,000,000.00 5,067,150.00 5,005,404.13 1.875 AA 1.733 289 08/17/2021 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,198,330.00 3,022,331.21 2.750 2.450 960 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,198,330.00 3,023,326.36 2.750 2.437 960 06/19/2023 3134GU5T3 4304 Federal Home Loan Mort Corp 01/30/2020 3,000,000.00 3,007,440.00 3,000,000.00 1.875 1.875 1,550 01/29/2025 3135GDU43 4289 Fed.Nat'l Mort.Assoc. 03/15/2019 5,000,000.00 5,375,900.00 5,055,216.20 2.875 2.465 1,045 09/12/2023 3136G4UM3 4307 Fed.Nat'l Mort.Assoc. 02/25/2020 5,000,000.00 5,002,700.00 5,000,000.00 1.800 AA 1.800 1,485 11/25/2024 Subtotal and Average 71,641,231.08 64,000,000.00 56,117,900.00 54,183,776.83 2.128 844 Local Agency Investment Funds SYS982 982 Laif City 25,551,098.29 25,551,098.29 25,551,098.29 0.620 0.620 1 Subtotal and Average 29,478,095.74 25,551,098.29 26,551,098.29 25,651,098.29 0.620 1 Treasury Securities-Coupon 91282BYH7 4298 US Treasury Notes 12105/2019 5,000,000.00 5,236,900.00 4,982,147.64 1.500 AAA 1.595 1,429 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,092,700.00 2,994,945.36 1.500 AAA 1.574 849 02/28/2023 Subtotal and Average 7,976,816.30 8,000,000.00 8,329,600.00 7,977,093.00 1.587 1,211 Medium Term Notes 45818WBX3 4290 Inter-American Dev.Bank 03/28/2019 4,000,000.00 4.260.040.00 4,061.767.84 2.870 2.270 991 07/20/2023 45818WBY1 4291 Inter-American Dev.Bank 03/28/2019 5,000,000.00 5,336.200.00 5,091,042.30 2.960 2.271 1.018 08/16/2023 45818WCT1 4312 Inter-American Dev.Bank 04/29/2020 6,000,000.00 6,165,360.00 6,140,330.07 1.600 0.550 820 01/30/2023 Subtotal and Average 15,297,736.36 15,000,000.00 16,761,600.00 15,293,140.21 1.680 931 Corporate Bonds 037833AR1 4262 Apple Inc. 06/26/2017 5,000,000.00 5,067,650.00 5,021,408.09 2.850 AA 1.980 186 05/06/2021 037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,216,450.00 5,177,102.26 2.400 0.720 803 01/13/2023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,323,400.00 5,078,120.07 3.191 AA 2.528 965 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,144,301.25 3,029,807.69 4.000 2.070 1,064 10/01/2023 375558AU7 4315 Gilead Sciences 04/30/2020 2,888,000.00 2,985,267.84 2,980,906.61 4.400 1.387 395 12/01/2021 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF_PM2)7.3.0 Report V 1 7.3.6.1 City of Huntington Beach Portfolio Management Page 2 Portfolio Details -Investments October 31, 2020 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate SAP 365 Maturity Date Corporate Bonds 375558AQ6 4316 Gilead Sciences 04/30/2020 1,426,000.00 1,435,867,92 1,441,703.23 4.500 1.821 151 04/01/2021 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,180,900.00 5,011,143.05 2.625 A 2.474 577 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,086,970.00 2,929,620.39 1.875 A 3.257 638 08/01/2022 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,206,300.00 4,995,138,10 3.100 3A60 623 07/17/2022 882508BAl 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,114,660.00 4,911,083.91 1.850 3.564 560 05/15/2022 904764AWI 4286 Unilever 03/01/2019 5,000,000.00 5,135,650.00 4,956,703.50 2.200 2.802 550 05/05/2022 904764AZO 4317 Unilever 04/30/2020 3,710,000.00 3,746,912.80 3,739,242.17 2.750 0.727 141 03/22/2021 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,157,340.00 2,089,147.66 3.400 AA 1.671 995 07/24/2023 Subtotal and Average 52,417,172.78 50,899,000.00 52,800,659.81 51,361,126.73 2.236 595 ORANGE COUNTY POOL OCP1 01 Orange County Invest Pool 40,041,585.78 40,041,585.78 40,041,585.78 0.956 0.956 1 Subtotal and Average 40,004,064.86 40,041,585.78 40,041,585.78 40,041,585.78 0.956 1 Total and Average 216,815,117.12 193,491,684.07 198,602,443.88 194,407,820.84 1.652 516 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF PM2)7.3.0 34 City of Huntington Beach Portfolio Management Page 3 Portfolio Details -Cash October 31, 2020 Average Purchase Stated YTM Days to CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Average Balance 0.00 0 Total Cash and investments 216,815,117.12 193,491,684.07 198,602,443.88 194,407,820.84 1.652 516 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF_PM2)7.3.0 35 City of Huntington Beach Portfolio Management Page 1 Activity By Type October 1, 2020 through October 31, 2020 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues-Coupon 3134GVLK2 4308 Federal Home Loan Mort Corp 1.000 10/21/2020 0.00 4,550,000.00 3134GVLQ9 4309 Federal Home Loan Mort Corp 1.050 10/23/2020 0.00 5,000,000.00 3134GVNH7 4310 Federal Home Loan Mort Corp 0.650 10/27/2020 0.00 2,500,529.75 3134GVNH7 4311 Federal Home Loan Mort Corp 0.650 10/27/2020 0.00 5,002,119.01 3134GVPV4 4314 Federal Home Loan Mort Corp 0.625 10/30/2020 0.00 5,000,000.00 Subtotal 0.00 22,052,648.76 54,183,776.83 Local Agency Investment Funds (Monthly Summary) SYS982 982 La"rf City 0.620 17,090,219.93 19,000,000.00 Subtotal 17,090,219.93 19,000,000.00 25,551,098.29 Treasury Securities-Coupon Subtotal 7,977,093.00 Medium Term Notes Subtotal 15,293,140.21 Corporate Bonds 46625HRT9 4283 JP Morgan 2.400 10/14/2020 0.00 2,489,437.88 Subtotal 0.00 2,489,437.88 51,361,126.73 ORANGE COUNTY POOL (Monthly Summary) 0CP1 01 Orange County Invest Pool 0.956 47,762.03 1,943.72 Subtotal 47,762.03 1,943.72 40,041,585.78 Total 17,137,981.96 43,644,030.36 194,407,820.84 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF_PM3)7.3.0 Report Ver.7.3.6.1 36 City of Huntington Beach Portfolio Management Page 1 Activity Summary October 2019 through October 2020 Yield to Maturity Managed Number Number Month Number of Average 360 365 Pool of Investments of Investments Average Average End Year Securities Balance Equivalent Equivalent Rate Purchased Redeemed Term Days to Maturity October 2019 45 213,459,526.87 2.204 2.235 2.190 0 1 1,272 699 November 2019 44 214,597,017.12 2.207 2.238 2.103 0 1 1,203 647 December 2019 49 225,972,763.68 2.161 2.191 2.043 6 2 1,171 685 January 2020 48 253,767,638.58 2.117 2.146 1.967 1 2 1,043 597 February 2020 49 250,234,023.87 2.115 2.145 1.912 3 2 1,106 669 March 2020 47 245,831,098.72 2.143 2.173 1.787 0 6 1,016 660 April 2020 51 245,648,128.94 1.867 1.893 1.648 10 3 958 685 May 2020 48 276,251,972.39 1.791 1.816 1.363 0 2 943 666 June 2020 47 268,106.206.75 1.602 1.624 1.217 1 7 809 591 July 2020 40 264,073,523.48 1.610 1.632 0.920 0 0 920 652 August 2020 40 238,570,893.05 1.582 1.604 0.784 0 1 917 621 September 2020 39 225,447,508.77 1.594 1.616 0.685 0 1 935 606 October 2020 38 216,815,117.12 1.629 1.652 0.620 0 6 885 516 Average 45 241,430,153.88 1.894% 1.920% 1.480 2 3 1,014 638 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF_PM4)7.3.0 Report Ver.7.3.6.1 37 City of Huntington Beach Portfolio Management Page 1 Interest Earnings Summary October 31, 2020 October 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 193,912.97 1,005,358.25 Plus Accrued Interest at End of Period 953,126.36 953,126.36 Less Accrued Interest at Beginning of Period ( 868,889.31) ( 792,361.15) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 278,150.02 1,166,123.46 Adjusted by Premiums and Discounts -42,489.28 -168,027.70 Adjusted by Capita(Gains or Losses 41,512.23 35,683.46 Earnings during Periods 277,172.97 1,033,779.22 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0,00 Cash/Checking Accounts: Interest Collected 137,981.96 407,551.03 Plus Accrued Interest at End of Period 90,735.13 90,735.13 Less Accrued Interest at Beginning of Period ( 180,713.54) ( 241,652.34) Interest Earned during Period 48,003.55 256,633.82 Total Interest Earned during Period 326,153.57 1,422,757.28 Total Adjustments from Premiums and Discounts -42,489.28 -168,027.70 Total Capital Gains or Losses 41,512.23 35,683.46 Total Earnings during Period 325,176.52 1,290,413.04 Portfolio CITY AP Run Date:01/19/2021-13:05 PM(PRF_PM6)7.3.0 Report Ver.7.3.6.1 38 �.�O\%ffst'�F State of California Pooled Money Investment Account 0 Market Valuation Ffj�tft]U10�S�+ 10/31/2020 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Bills $ 31,281,869,967.46 $ 31,338,887,000.00 NA Notes $ 23,880,369,444.67 $ 24,159,992,000.00 $ 106,505,626.00 Federal Agency: SBA $ 473,858,243.22 $ 469,640,790.08 $ 201,333.40 MBS-REMICs $ 14,762,598.67 $ 15,546,931.64 $ 68,429.31 Debentures $ 2,547,721,580.69 $ 2,561,583,300.00 $ 5,684,210.09 Debentures FR $ - $ - $ Debentures CL $ 725,000,000.00 $ 724,916,250.00 $ 2,374,498.50 Discount Notes $ 13,969,902,444.44 $ 13,975,036,200.00 NA Su ranational Debentures $ 417,080,815.94 $ 417,766,250.00 $ 610,083.75 Su ranational Debentures FIR $ 150,097,007.00 $ 150,107,576.85 $ 30,240.72 CDs and YCDs FIR $ 600,000,000.00 $ 600,112,000.00 $ 288,842.73 Bank Notes $ - $ - $ - CDs and YCDs $ 13,900,405,817.10 $ 13,899,974,556.10 $ 14,648,680.56 Commercial Paper $ 7,442,815,819.44 $ 7,447,250,833.35 NA Corporate: Bonds FIR $ - $ $ Bonds $ - $ $ Repurchase Agreements $ $ $ - Reverse Repurchase $ - $ - $ Time Deposits $ 4,782,500,000.00 $ 4,782,500,000.00 NA AB 55&GF Loans $ 690,043,000.00 $ 690,043,000.00 NA TOTAL $ 100,876,426,738.63 $ 101,233,356,688.02 $ 130,411,945.06 Fair Value Including Accrued Interest $ 101,363,768,633.08 Repurchase Agreements,Time Deposits, AB 55&General Fund loans,and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). 39 ` Statement of Cash Receipts and Disbursements and Summary of Cash by Fund Finance Department ` October 2020 Cash Receipts and Disbursements September 2020 October 2020 Receipts General Fund Property Tax $ 954,406 $ 148,847 Local Sales Tax 3,609,238 3,983,249 Public Safety Sales Tax 201,279 193,306 Transient Occupancy Tax(TOT) 309,660 812,919 Utility Users Tax(UUT) 1,564,180 1,616,767 Other Revenue 4,059,995 3,521,403 Total General Fund Revenue 10,698,759 10,276,491 Total All Other Funds Revenue 11,746,740 11,414,673 Total Receipts $ 22,445,498 $ 21,691,164 Disbursements General Fund Personal Services (11,634,847) (10,485,779) Operating Expenses (3,985,369) (4,424,044) Capital Expenditures Non-Operating Expenses (4,208) (4,208) Total General Fund Disbursements (15,624,425) (14,914,031) Total All Other Funds Disbursements (13,407,871) (14,045,518) Total Disbursements (29,032,297) (28,959,549) Net Change in Cash Flow $ (6,586,798) $ (7,268,385) Summary of Cash by Fund September 2020 October 2020 General Fund 16,031,731 $ 11,394,191 General Fund Other 5,954,055 5,962,485 Capital Projects Funds 29,065,388 28,921,106 Debt Service Funds 11,678,476 11,619,816 Enterprise Funds 86,272,354 87,483,550 Trust and Agency Funds 9,964,043 9,110,422 Internal Service Funds 33,226,248 32,346,306 Special Revenue Funds 44,107,009 42,193,044 General Ledger Cash Balances $ 236,299,305 $ 229,030,920 * Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 40 City of Huntington Beach City of Huntington Beach 2000 Main St. Portfolio Management Huntington Beach, Portfolio Summary November 30, 2020 Par Market Book %,of Days to YTM YTM Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv. Federal Agency Issues-Coupon 49,000,000.00 51,051,100.00 49,176,097.93 21.82 1,469 749 2.132 2.161 Local Agency Investment Funds 26,551,098.29 26,551,098.29 26,551,098.29 11.78 1 1 0.568 0.576 Treasury Securities-Coupon 8,000,000.00 8,326,710.00 7,977,646.40 3.54 1,543 1,181 1.566 1.587 Medium Tenn Notes 15,000,000.00 15,745,800.00 15,283,325.91 6.78 1,356 901 1.558 1.580 Corporate Bonds 50,899,000.00 52,737,164.41 51,335,039.07 22.77 1,130 565 2.207 2.237 ORANGE COUNTY POOL 75,078,465.54 75,078,465.54 75,078,465.54 33.31 1 1 0.887 0.899 224,528,563.83 229,490,338.24 225,401,673.14 100.00% 725 396 1.491 1.512 Investments Total Earnings November 30 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 273,264.84 1,563,677.88 Current Budget 150,000.00 1,150,000.00 1,900,000.00 Last Year Actual 401,839.55 2,072,072.95 5,155,399.59 Average Daily Balance 205,158,091.48 230,205,317.33 Effective Rate of Return 1.62% 1.62% 1 certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 3,2020.A copy of this policy is available at the office of the City Clerk.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market Values provided by Union Bank via Interactive Data Corporation. Alisa Backstrom,CITY TREASURER Reporting period 11/01/2020-11130/2020 Portfolio CITY AP Run Date:01/192021-13:08 PM(PRF PM1)7.3.0 Report Ver.7.3.6.1 41 City of Huntington Beach Portfolio Management Page 1 Portfolio Details - Investments November 30, 2020 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Federal Agency Issues-Coupon 3133ECHX5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,327,900.00 5,003,689.48 2.260 AA 2.236 1,198 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/01/2019 5,000,000.00 5,124,000.00 4,994,690.28 1.750 1.821 577 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,376,450.00 5.059,818.52 3.250 2.743 920 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,285,850.00 5,000,000.00 2.550 2.550 910 05/30/2023 313OA1 W95 4297 Federal Home Loan Bank 06/27/2019 5,000,000,00 5,055,550,00 5,010,566.05 2.250 1.840 192 06/11/2021 3134G9N94 4257 Federal Home Loan Mort Corp 06114/2017 5,000,000.00 5,059,150.00 5,004,774.11 1.875 AA 1.723 238 07/27/2021 3134G92Y2 4258 Federal Home Loan Mort Corp 06/14/2017 5,000,000.00 5,062,400.00 5,004,837.26 1.875 AA 1.733 259 08/17/2021 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,193.170.00 3,021,624.53 2.750 2.450 930 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,193,170.00 3,022,588.18 2.750 2.437 930 06/19/2023 3134GU5T3 4304 Federal Home Loan Mort Corp 01/30/2020 3,000,000.00 3,005,160,00 3,000,000.00 1.875 1.875 1,520 01/29/2025 3135GOU43 4289 Fed.Nat'l Mort.Assoc. 03/15/2019 5,000,000.00 5,368,300.00 5,053,609.52 2.875 2.465 1,015 09/12/2023 Subtotal and Average 53,179,809.41 49,000,000.00 51,051,100.00 49,176,097.93 2.161 749 Local Agency Investment Funds SYS982 982 Lail City 26,551,098.29 26,551,098.29 26,551,098.29 0.576 0.576 1 Subtotal and Average 12,484,431.62 26,551,098.29 26,551,098.29 26,561,098.29 0.576 1 Treasury Securities-Coupon 912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 5,236,350.00 4.982,522.43 1.500 AAA 1.595 1.399 09/30/2024 91282BP79 4299 US Treasury Notes 12/05/2019 3.000,000.00 3,090,360.00 2,995,123.97 1.500 AAA 1.574 819 02/28/2023 Subtotal and Average 7,977,378.92 8,000,000.00 8,326,710.00 7,977,646.40 1.587 1,181 Medium Term Notes 45818WBX3 4290 Inter-American Dev.Bank 03/28/2019 4,000,000.00 4,254,680.00 4,059,875.05 2,870 2.270 961 07/20/2023 45818WBY1 4291 Inter-American Dev.Bank 03/28/2019 5,000,000.00 5,329.300.00 5,088,324.62 2.960 2.271 988 08/16/2023 45818WCT1 4312 Inter-American Dev.Bank 04/29/2020 6,000,000.00 6,161,820.00 6,135,126.24 1.600 0.550 790 01/30/2023 Subtotal and Average 15,288,069.49 15,000,000.00 15,745,800.00 15,283,325.91 1.580 901 Corporate Bonds 037833AR1 4262 Apple Inc. 06/26/2017 5,000,000.00 5.055,650.00 5,017,936.51 2.850 AA 1.980 156 05/06/2021 037833DE7 4313 Apple Inc. 04/29/2020 5,000.000.00 5,215,700.00 5,170,393,84 2.400 0.720 773 01/13/2023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,331,200.00 5,075,660.88 3.191 AA 2.528 935 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,139,126.25 3,025,384.62 4,000 2.070 1,D34 10/01/2023 375558AU7 4315 Gilead Sciences 04/30/2020 2,888,000.00 2,973,167,12 2,973,759.94 4.400 1.387 365 12/01/2021 375558AQ6 4316 Gilead Sciences 04/30/2020 1,426.000,00 1,430,620.24 1,438,562.59 4,500 1.821 121 04/01/2021 Portfolio CITY AP Run Date:01/1912021-13:08 PM(PRF PM2)7.3.0 Report V%J.3.6.1 City of Huntington Beach Portfolio Management Page 2 Portfolio Details - Investments November 30, 2020 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Corporate Bonds 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,167,850.00 5,010,556.58 2.625 A 2.474 547 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,079,980.00 2,932,971.80 1.875 A 3.257 608 08/01/2022 713448CX4 4280 PEPSICO INC 12121/2018 5,000,000.00 5,208,450.00 4,995,374.88 3.100 3.160 593 07/17/2022 882508BA1 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,112,950.00 4,915,898.86 1.850 3.564 530 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,127,500.00 4,959,091.17 2.200 2.802 520 05/05/2022 904764AZO 4317 Unilever 04/30/2020 3,710,000.00 3,737,750.80 3,733,020A3 2750 0.727 111 03/22/2021 90331HNV1 4306 US Bank NA Cincinnati 02/21/2020 2,000,000.00 2,157,220.00 2,086,426.97 3.400 AA 1.671 965 07/24/2023 Subtotal and Average 51,347,648.11 50,899,000.00 52,737,164.41 51,335,039.07 2.237 565 ORANGE COUNTY POOL OCP1 01 Orange County Invest Pool 75,078,465.54 75,078,465.54 75,078,465.54 0.899 0.899 1 Subtotal and Average 64,880,753.93 75,078,465.54 75,078,466.54 75,078,465.54 0.899 1 Total and Average 205,158,091.48 224,528,563.83 229,490,338.24 225,401,673.14 1.512 396 Portfolio CITY AP Run Date:01/19/2021-13:08 PM(PRF_PM2)7.3.0 43 City of Huntington Beach Portfolio Management Page 1 tYY Type Activity B T e November 1, 2020 through November 30, 2020 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues-Coupon 3136G4UM3 4307 Fed.Nat'l Mort.Assoc. 1.800 11/25/2020 0.00 5,000,000.00 Subtotal 0.00 6,000,000.00 49,176,097.93 Local Agency Investment Funds (Monthly Summary) SYS982 982 Laif City 0.576 16,000,000.00 15,000,000.00 Subtotal 16,000,000.00 16,000,000.00 26,551,098.29 Treasury Securities-Coupon Subtotal 7,977,646.40 Medium Term Notes Subtotal 16,283,325.91 Corporate Bonds Subtotal 51,335,039.07 ORANGE COUNTY POOL (Monthly Summary) OCP1 01 Orange County Invest Pool 0.899 35,038,889.93 2,010,17 Subtotal 35,038,889.93 2,010.17 75,078,466.54 Total 51,038,889.93 20,002,010.17 226,401,673.14 Portfolio CITY AP Run pate:01/19/2021-13:08 PM(PRF PM3)7.3.0 Report Ver,7.3,6.1 44 City of Huntington Beach Portfolio Management Page 1 Activity Summary November 2019 through November 2020 Yield to Maturity Managed Number Number Month Number of Average 360 365 Pool of investments of Investments Average Average End Year Securities Balance Equivalent Equivalent Rate Purchased Redeemed Term Days to Maturity November 2019 44 214,597,017.12 2.207 2.238 2.103 0 1 1,203 647 December 2019 49 225,972,763.68 2.161 2.191 2.043 6 2 1,171 685 January 2020 48 253,767,638.58 2.117 2.146 1.967 1 2 1,043 597 February 2020 49 250,234,023.87 2.115 2.145 1.912 3 2 1,106 669 March 2020 47 245,831,098.72 2.143 2.173 1.787 0 6 1,016 660 April 2020 51 245,648,128.94 1.867 1.893 1.648 10 3 958 685 May 2020 48 276,251,972.39 1.791 1.816 1.363 0 2 943 666 June 2020 47 268,106,206.75 1.602 1.624 1.217 1 7 809 591 July 2020 40 264,073,523.48 1.610 1.632 0.920 0 0 920 652 August 2020 40 238,570,893.05 1.582 1.604 0.784 0 1 917 621 September 2020 39 225,447,508.77 1.594 1.616 0.685 0 1 935 606 October 2020 38 216,815,117.12 1.629 1.652 0.620 0 6 885 516 November 2020 32 205,158,091.48 1.491 1.512 0.576 0 1 725 396 Average 44 240,871,890.16 1.839% 1.865% 1.356 2 3 972 615 Portfolio CITY AP Run Date:01/19/2021-13:08 PM(PRF PM4)7.3.0 Report Ver.7.3.6.1 45 City of Huntington Beach Portfolio Management Page 1 Interest Earnings Summary November 30, 2020 November 30Month Ending Fiscal Year To Date CD/Coupon]Discount Investments: Interest Collected 281,250.00 1,286,608.25 Plus Accrued Interest at End of Period 934,255.03 934,255.03 Less Accrued Interest at Beginning of Period { 953,126.36) ( 792,361.15) Less Accrued Interest at Purchase During Period ( 0.()0) ( 0.00) Interest Earned during Period 262,378.67 1,428,502.13 Adjusted by Premiums and Discounts -43,027.46 -211,055.16 Adjusted by Capital Gains or Losses 0.00 35,683.46 Earnings during Periods 219,351.21 1,253,130.43 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 38,889.93 446,440.96 Plus Accrued Interest at End of Period 105,758.83 105,758.83 Less Accrued Interest at Beginning of Period { 90,735.13) ( 241,652.34) Interest Earned during Period 53,913.63 310,547.45 Total Interest Earned during Period 316,292.30 1,739,049.58 Total Adjustments from Premiums and Discounts -43,027.46 -211,055.16 Total Capital Gains or Losses 0.00 35,683.46 Total Earnings during Period 273,264.84 1,563,677.88 Portfolio CITY AP Run Date:01/19/2021-13:08 PM(PRF PM6)7.3.0 Report Ver.7.3.6.1 46 �o��y�NVEST�Fy� State of California Pooled Money Investment Account o C Market Valuation F,r��OUtDity i\ 11/30/2020 Carrying Cost Plus Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury: Bills $ 32,742,129,853.61 $ 32,789,170,000.00 NA Notes $ 24,387,013,378.01 $ 24,639,427,500.00 $ 114,368,992.50 Federal Agency: SBA $ 469,372,167.75 $ 465,167,833.37 $ 199,301.34 MBS-REMICs $ 13,553,331.34 $ 14,239,058.12 $ 62,819.19 Debentures $ 2,597,627,445.92 $ 2,610,586,840.00 $ 5,624,359.41 Debentures FR $ - $ - $ - Debentures CL $ 725,000,000.00 $ 724,677,000.00 $ 2,129,499.25 Discount Notes $ 13,070,638,400.02 $ 13,076,429,000.00 NA Su ranational Debentures $ 419,066,797.22 $ 418,723,150.00 $ 1,673,911.75 Su ranational Debentures FR $ 150,097,007.00 $ 150,144,131.17 $ 68,241.14 CDs and YCDs FR $ 500,000,000.00 $ 500,052,000.00 $ 319,227.14 Bank Notes S $ - $ - CDs and YCDs $ 14,400,405,817.10 $ 14,399,430,260.29 $ 13,855,875.04 Commercial Paper $ 8,293,210,861.12 $ 8,296,808,617.97 NA Corporate: Bonds FR $ - $ - $ Bonds $ - $ - $ Repurchase Agreements $ - $ - $ Reverse Repurchase $ - $ Time Deposits $ 4,541,500,000.00 $ 4,541,500,000.00 NA AB 55&GF Loans $ 690,043,000.00 $ 690,043,000.00 NA TOTAL $ 102,999,658,059.09 $ 103,316,398,390.92 $ 138,302,226.76 Fair Value Including Accrued Interest $ 103,454,700,617.68 Repurchase Agreements,Time Deposits,AB 55&General Fund loans,and Reverse Repurchase agreements are carried at portfolio book value(carrying cost). 47 Statement of Cash Receipts and Disbursements and Summary of Cash by Fund Finance Department ' November 2020 Cash Receipts and Disbursements October 2020 November 2020 Receipts General Fund Property Tax $ 148,847 $ 10,923,634 Local Sales Tax 3,983,249 3,986,058 Public Safety Sales Tax 193,306 190,830 Transient Occupancy Tax(TOT) 812,919 693,962 Utility Users Tax(UUT) 1,616,767 1,711,591 Other Revenue 3,521,403 3,577,518 Total General Fund Revenue 10,276,491 21,083,592 Total All Other Funds Revenue 11,414,673 10,613,933 Total Receipts $ 21,691,164 $ 31,697,525 Disbursements General Fund Personal Services (10,485,779) (13,041,632) Operating Expenses (4,424,044) (4,462,360) Capital Expenditures (56,764) Non-Operating Expenses (4,208) (70,142) Total General Fund Disbursements (14,914,031) (17,630,899) Total All Other Funds Disbursements (14,045,518) (10,303,287) Total Disbursements (28,959,549) (27,934,186) Net Change in Cash Flow $ (7,268,385) $ 3,763,339 Summary of Cash by Fund October 2020 November 2020 General Fund 11,394,191 $ 14,846,884 General Fund Other 5,962,485 5,928,790 Capital Projects Funds 28,921,106 28,253,244 Debt Service Funds 11,619,816 12,792,868 Enterprise Funds 87,483,550 89,398,432 Trust and Agency Funds 9,110,422 8,631,182 Internal Service Funds 32,346,306 31,383,327 Special Revenue Funds 42,193,044 41,559,532 General Ledger Cash Balances $ 229,030,920 $ 232,794,260 Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 48 City of Huntington Beach City of Huntington Beach 2000 Main St. Portfolio Management Huntington Beach, Portfolio Summary December 31, 2020 Par Market Book %of Days to YTM YTM Investments Value Value Value Portfolio Term Maturity 360 Equiv. 365 Equiv. Federal Agency Issues-Coupon 49,000,000.00 50,981,660.00 49,168,419.03 20.45 1,469 718 2.132 2.161 Local Agency Investment Funds 41,551,098.29 41,551,098.29 41,551,098.29 17.28 1 1 0.533 0.540 Treasury Securities-Coupon 8,000,000.00 8,324,100.00 7,978,218.24 3.32 1,543 1,150 1.566 1.587 Medium Term Notes 15,000,000.00 15,730,000.00 15,273,511,61 6.35 1,356 870 1.558 1.580 Corporate Bonds 50,899,000m 52,643,234.60 51,308,951.43 21.34 1,130 534 1207 2.238 ORANGE COUNTY POOL 75,110,223.92 75,110,223.92 75,110,223.92 31.25 1 1 0.756 0.767 239,560,322.21 244,340,316.81 240,390,422.52 100.00% 680 355 1.387 1.406 Investments Total Earnings December 31 Month Ending Fiscal Year To Date Fiscal Year Ending Current Year 272,920.45 1,836,598.33 Current Budget 150,000.00 1,300,000.00 1,900,000.00 Last Year Actual 422,171.41 2,494,244.36 5,155,399.59 Average Daily Balance 221,313,362.71 228,707,216.28 Effective Rate of Return 1.45% 1.59% 1 certify that this report accurately reflects all City pooled investments and is in conformity with all State laws and the investment policy statement filed with the City Council on February 3,2020.A copy of this policy is available at the office of the City Clerk.The investment program herein shown provides sufficient cash flow liquidity to meet the next six month's obligations. Market Values provided by Union Bank via Interactive Data Corporation. Alisa Backstrom,CITY TREASURER Reporting period 12/01/2020-1213112020 Portfolio CITY AP Run Date:01t2012021-13:38 PM(PRF_PM1)7.3.0 Report Ver.7.3.6.1 49 City of Huntington Beach Portfolio Management Page 1 Portfolio Details - Investments December 31, 2020 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Federal Agency Issues-Coupon 3133ECHX5 4292 Federal Farm Credit Bank 05/23/2019 5,000,000.00 5,319,550.00 5,003,595.84 2.260 AA 2.236 1.167 03/13/2024 3133EKTG1 4296 Federal Farm Credit Bank 07/0112019 5,000,000.00 5,121,650.00 4,994.875.00 1.750 1.821 546 07/01/2022 313383QR5 4281 Federal Home Loan Bank 12/20/2018 5,000,000.00 5,370,200,00 5,057,842.14 3.250 2.743 889 06/09/2023 3130AFWX1 4285 Federal Home Loan Bank 02/26/2019 5,000,000.00 5,281,600.00 5,000,000.00 2.550 2.550 879 05/30/2023 3130A1 W95 4297 Federal Home Loan Bank 06/27/2019 5,000,000.00 5,045,650.00 5,008,897.73 2.250 1.840 161 06/11/2021 3134G9N94 4257 Federal Home Loan Mort Corp 06/14/2017 5,000,000.00 5,050,400.00 5,004,167.23 1.875 AA 1.723 207 07/27/2021 3134G92Y2 4258 Federal Home Loan Mort Corp 06/14/2017 5,000,000.00 5,053,750.00 5,004,270.39 1.875 AA 1.733 228 08/17/2021 3137EAEN5 4287 Federal Home Loan Mort Corp 03/08/2019 3,000,000.00 3,189,510.00 3,020,917.85 2.750 2.450 899 06/19/2023 3137EAEN5 4288 Federal Home Loan Mort Corp 03/14/2019 3,000,000.00 3,189,510.00 3,021,850.01 2.750 2.437 899 06/19/2023 3134GU5T3 4304 Federal Home Loan Mort Corp 01/30/2020 3,000,000.01) 3,002,340.00 3,000,000.00 1.875 1.875 1,489 01/29/2025 3135GOU43 4289 Fed.Nat'l MorL Assoc. 03/15/2019 5,000,000.00 5,357,500.00 5,052,002.84 2.875 2.465 984 09/12/2023 Subtotal and Average 49,172,010.77 49,000,000.00 50,981,660.00 49,168,419.03 2.161 718 Local Agency Investment Funds SYS982 982 Laif City 41,551,098.29 41,551,098.29 41,551,098.29 0.540 0.540 1 Subtotal and Average 22,486,682.16 41,551,098.29 41,551,098.29 41,551,098.29 0.540 1 Treasury Securities-Coupon 912828YH7 4298 US Treasury Notes 12/05/2019 5,000,000.00 5,235,750.00 4,982,909.71 1.500 AAA 1.595 1,368 09/30/2024 912828P79 4299 US Treasury Notes 12/05/2019 3,000,000.00 3,088,350.00 2,995,308.53 1,500 AAA 1.574 788 02/28/2023 Subtotal and Average 7,977,941.54 8,000,000.00 8,324,100.00 7,978,218.24 1.587 1,150 Medium Term Notes 45818WBX3 4290 Inter-American Dev.Bank 03/28/2019 4,000,000.00 4,249,360.00 4,057,982.27 2.870 2.270 930 07/20/2023 45818WBY1 4291 Inter-American Dev.Bank 03/28/2019 5,000,000.00 5,322,600.00 5,085,606.94 2.960 2.271 957 08/16/2023 45818WCTI 4312 Inter-American Dev.Bank 04/29/2020 6,000,000.00 6,158,040.00 6,129,922.40 1.600 0.550 759 01/30/2023 Subtotal and Average 16,278,107,76 15,000,000.00 16,730,000.00 15,273,511.64 1.680 870 Corporate Bonds 037833AR1 4262 Apple Inc. 06/26/2017 5,000,000.00 5,040,650.00 5,014,464.93 2.850 AA 1.980 125 05/06/2021 037833DE7 4313 Apple Inc. 04/29/2020 5,000,000.00 5,212,850.00 5,163,685.42 2.400 0.720 742 01/13/2023 166764AH3 4294 Chevron Corp 05/24/2019 5,000,000.00 5,317,800.00 5,073,201.70 3.191 AA 2.528 904 06/24/2023 254687CR5 4300 Disney 12/16/2019 2,875,000.00 3,145,940.00 3,020.961.54 4.000 2.070 1,003 10/01/2023 375558AU7 4315 Gilead Sciences 04/30/2020 2,888,000.00 2,967,131.20 2,966,613.2E 4.400 1.387 334 12/01/2021 375558AQ6 4316 Gilead Sciences 04/30/2020 1,426.000.00 1,426,000.00 1,435.421.94 4.500 1.821 90 04/01/2021 Portfolio CITY AP Run Date:0120/2021-13:38 PM(PRF_PM2)7.3.0 Report Vg67.3.6.1 City of Huntington Beach Portfolio Management Page 2 Portfolio Details - Investments December 31, 2020 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Date Corporate Bonds 437076BG6 4293 Home Depot Inc 05/24/2019 5,000,000.00 5,156,100.00 5,009,970.10 2.625 A 2.474 516 06/01/2022 459200HG9 4274 IBM Corp 09/28/2018 3,000,000.00 3,083,130.00 2,936,323.21 1.875 A 3.257 577 08/01/2022 713448CX4 4280 PEPSICO INC 12/21/2018 5,000,000.00 5,194,650.00 4,995,611.66 3.100 3.160 562 07/17/2022 882508SAl 4279 Texas Instruments Inc 12/21/2018 5,000,000.00 5,100,250.00 4,920,713.81 1.850 3.564 499 05/15/2022 904764AW7 4286 Unilever 03/01/2019 5,000,000.00 5,120,600.00 4,961,478.85 2.200 2,802 489 05/05/2022 904764AZO 4317 Unilever 04/30/2020 3,710,000.00 3,730,553.40 3,726,798.70 2.750 0.727 80 03/22/2021 90331HNV1 4306 US Bank NA Cincinnati 02121/2020 2,000,000.00 2,147,580.00 2,083,706.29 3.400 AA 1.671 934 07/24/2023 Subtotal and Average 51,321,153.72 60,899,000.00 52,643,234.60 51,308,951.43 2.238 534 ORANGE COUNTY POOL 0CP1 01 Orange County Invest Pool 75,110,223,92 75,110,223.92 75,110,223.92 0.767 0.767 1 Subtotal and Average 75,077,566.76 75,110,223.92 75,110,223.92 75,110,223.92 0.767 1 Total and Average 221,313,362.71 239,560,322.21 244,340,316.81 240,390,422.52 1.406 355 Portfolio CITY AP Run Date:012012021-13:38 PM(PRF_PM2)7.3.0 51 City of Huntington Beach Portfolio Management Page 1 Activity By Type December 1, 2020 through December 31, 2020 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Federal Agency Issues-Coupon Subtotal 49,168,419.03 Local Agency Investment Funds (Monthly Summary) SYS9B2 982 Laff City 0.540 34,000,000.00 19,000,000.00 Subtotal 34,000,000.00 19,000,000.00 41,551,098.29 Treasury Securities-Coupon Subtotal 7,978,218.24 Medium Term Notes Subtotal 15,273,511.61 Corporate Bonds Subtotal 51,308,951.43 ORANGE COUNTY POOL (Monthly Summary) OCP1 01 Orange County Invest Pool 0.767 31,758.38 0.00 Subtotal 31,758.38 0.00 76,110,223.92 Total 34,031,768.38 19,000,000.00 240,390,422.52 Portfolio CITY AP Run Date:01/20/2021-13:38 PM(PRF PM3)7.3.0 Report Ver.7.3.6.1 52 City of Huntington Beach Portfolio Management Page 1 Activity Summary December 2019 through December 2020 Yield to Maturity Managed Number Number Month Number of Average 360 365 Pool of Investments of investments Average Average End Year Securities Balance Equivalent Equivalent Rate Purchased Redeemed Term Days to Maturity December 2019 49 225,972,763.68 2.161 2.191 2.043 6 2 1,171 685 January 2020 48 253,767,638.58 2.117 2.146 1.967 1 2 1,043 597 February 2020 49 250,234,023.87 2.115 2.145 1.912 3 2 1,106 669 March 2020 47 245,831,098.72 2.143 2.173 1.787 0 6 1,016 660 April 2020 51 245,648,128.94 1.867 1.893 1.648 10 3 958 685 May 2020 48 276,251,972.39 1.791 1.816 1.363 0 2 943 666 June 2020 47 268,106,206.75 1.602 1.624 1.217 1 7 809 591 July 2020 40 264,073,523.48 1.610 1.632 0.920 0 0 920 652 August 2020 40 238,570,893.05 1.582 1.604 0.784 0 1 917 621 September 2020 39 225,447,508.77 1.594 1.616 0.685 0 1 935 606 October 2020 38 216,815,117.12 1.629 1.652 0.620 0 6 885 516 November 2020 32 205,158,091.48 1.491 1.512 0.576 0 1 725 396 December 2020 31 221,313,362.71 1.387 1.406 0.540 0 0 680 356 Average 43 241,330,156.76 1,776% 1.801% 1.236 2 3 931 592 Portfolio CITY AP Run Date:01/20/2021-13:38 PM(PRF_PM4)7.3.0 Report Ver.7.3.6.1 53 City of Huntington Beach Portfolio Management Page 1 Interest Earnings Summary December 31, 2020 December 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 428,936.00 1,715,544.25 Plus Accrued Interest at End of Period 762,028.09 762,028.09 Less Accrued Interest at Beginning of Period ( 934,265.03) ( 792,361.15) Less Accrued Interest at Purchase During Period { 0.00) ( 0.00) Interest Earned during Period 256,709.06 1,685,211.19 Adjusted by Premiums and Discounts -43,009.00 -254,064.16 Adjusted by Capital Gains or Losses 0.00 35,683.46 Earnings during Periods 213,700.06 1,466,830.49 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 Less Accrued Interest at Beginning of Period ( 0.00) ( 0.00) Less Accrued Interest at Purchase During Period { 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Premiums and Discounts 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 31,758.38 478,199.34 Plus Accrued Interest at End of Period 133,220.84 133,220.84 Less Accrued Interest at Beginning of Period ( 105,758.83) { 241,652.34) Interest Earned during Period 59,220.39 369,767.84 Total Interest Earned during Period 315,929.45 2,054,979.03 Total Adjustments from Premiums and Discounts -43,009.00 -254,064.16 Total Capital Gains or Losses 0.00 35,683.46 Total Earnings during Period 272,920.45 1,836,598.33 Portfolio CITY AP Run Date:0120/2021-13:38 PM(PRF_PM6)7.3.0 Report Ver.7.3.6.1 54 \NVEST':Fyn State of California W o Pooled Money Investment Account Market Valuation 12/31/2020 Ffy'lIOU101�v� Carrying Cost Plus Description Accrued Interest Purch. Amortized Cost Fair Value Accrued Interest United States Treasury: Bills $ 35,405,712,930.37 $ 35,432,444,038.95 $ 35,437,534,000.00 NA Notes $ 22,978,289,919.79 $ 22,975,600,175.26 $ 23,203,472,000.00 $ 87,687,683.50 Federal Agency: SBA $ 457,313,707.11 $ 457,313,707.11 $ 453,196,763.66 $ 194,387.40 MBS-REMICs $ 13,009,086.19 $ 13,009,086.19 $ 13,667,627.97 $ 60,269.69 Debentures $ 2,847,411,888.51 $ 2,847,280,694.06 $ 2,860,796,440.00 $ 5,309,372.25 Debentures FR $ 50,004,819.33 $ 49,999,902.66 $ 49,999,902.66 $ 7,000.00 Debentures CL $ 500,000,000.00 $ 500,000,000.00 $ 499,778,000.00 $ 675,389.00 Discount Notes $ 15,173,292,694,21 $ 15,178,921,383.10 $ 15,179,217,080.00 NA Supranational Debentures $ 418,341,915.19 $ 417,532,042.97 $ 418,199,950.00 $ 2,285,076.75 Supranational Debentures FR $ 150,065,91D.68 $ 150,065,910.68 $ 150,116,479.89 $ 71,271.38 CDs and YCDs FR $ 300,000,000.00 $ 300,000,000,00 $ 300,031,000.00 $ 55,330.75 Bank Notes $ - $ - $ - $ - CDs and YCDs $ 15,150,OOD,000.00 $ 15,150,000,0D0.00 $ 15,149,513,647.63 $ 14,168,375.02 Commercial Paper $ 8,843,502,722.19 $ 8,847,289,347.29 $ 8,847,888,754.14 NA Corporate: Bonds FR $ $ - $ - $ - Bonds $ - $ - $ - $ - I ,Repurchase Agreements $ $ - $ - $ Reverse Repurchase $ $ - $ $ Time Deposits $ 4,396,500,000.00 $ 4,396,500,000.00 $ 4,396,500,000.00 NA PMIA&GF Loans $ 691,023,000.00 $ 691,023,000.00 $ 691,023,000.00 NA TOTAL $ 107,374,468,593.57 $ 107,406,979,2BB.27 $ 107,650,934,645.95 $ 110,514,155.74 Fair Value Including Accrued Interest $ 107,761,448,801.69 Repurchase Agreements, Reverse Repurchases, Time Deposits, and PMIA& General Fund loans are carried at portfolio book value(carrying cost). The value of each participating dollar equals the fair value divided by the amortized cost(1.002271318). As an example: if an agency has an account balance of$20,000,00D.00,then the agency would report its participation in the LAIF valued at$20,045,426.35 or$20,000,000.00 x 1.002271318. 55 Statement of Cash Receipts and Disbursements and 110 Summary of Cash by Fund Finance Department ' December 2020 Cash Receipts and Disbursements November 2020 December 2020 Receipts General Fund Property Tax $ 10,923,634 $ 23,531,268 Local Sales Tax 3,986,058 3,282,385 Public Safety Sales Tax 190,830 236,271 Transient Occupancy Tax(TOT) 693,962 2,933,333 Utility Users Tax(UUT) 1,711,591 1,470,389 Other Revenue 3,577,518 657,460 Total General Fund Revenue 21,083,592 32,111,106 Total All Other Funds Revenue 10,613,933 25,360,240 Total Receipts $ 31,697,525 $ 57,471,346 Disbursements General Fund Personnel Services (13,041,632) (14,165,520) Operating Expenses (4,462,360) (1,651,578) Capital Expenditures (56,764) Non-Operating Expenses (70,142) (330,125) Total General Fund Disbursements (17,630,899) (16,147,224) Total All Other Funds Disbursements (10,303,287) (21,480,301) Total Disbursements (27,934,196) (37,627,525) Net Change in Cash Flow $ 3,763,339 $ 19,843,821 Summary of Cash by Fund November 2020 December 2020 General Fund 14,852,035 $ 30,815,917 General Fund Other 5,928,287 4,885,954 Capital Projects Funds 28,253,244 23,824,598 Debt Service Funds 12,792,868 15,948,198 Enterprise Funds 89,311,206 90,896,427 Trust and Agency Funds 8,714,565 1S,073,982 Internal Service Funds 31,382,945 30,647,782 Special Revenue Funds 41,559,109 40,545,223 General Ledger Cash Balances $ 232,794,260 $ 252,638,081 * Total cash will differ from investment portfolio total due to outstanding checks and/or other timing differences. Note: Above information was obtained from the City's accounting system records.The above information includes receipts from maturing investments and payments for purchased investments in the city investment portfolio.This statement is prepared in compliance with the City's Charter. 56 City of Huntington Beach Quarterly Investment Report 000 Quarter Ending: December 2020 Prepared by: Alisa Backstrom, MBA, CCMT, CPFIM City Treasurer ❖ Ongoing public health crisis continues to negatively affect economic activity and employment ❖ Unemployment rate for December remained unchanged at 6.7% ❖ Federal Reserve maintained Fed Funds rate at 0.00%-0.25% ❖ Historically low U.S. Treasury Rates: 12 31 19 12 31 20 % 2-Year Treasury: 1.58% 0.13% 192% 10-Year Treasury: 1.92% 0.93% 152% 58 A . Treasury Rates 1.90 l.9so 1.80 Teo 1_TO 1.e9a 1.610 1-Go seo 0 7.56 1.40 g 1.30 1.20 1.10 1 0-yr 1OYr T9y 0.930 O_9O o. o o.H a H O.Bo O."G O.73a 0.70 eea o.ma o.eso o'er -es o O 60 0 5-yr 0.50 a. eO SY•Tsy 0.40 39a v.390 o.3.v 0.] o O.3f0 O.3Aa 0 30 Q.mo o."o o.z o o nr r.y a.19a 0,2Q O.17O 0.190 0.140 OAJ 0.150 0.170 . o a.A3a 0.10 2-yr N ti y ^ N Investment Type / Market Value: • Federal Agencies - $51.OMM • LAIF - $41.6MM • Treasury Securities - $8.3MM Portfolio Summary • MTN (IAD B) - $15.7MM As o • Corporate Bonds - $52.6MM • OCIP - $75MM TOTAL PORTFOLIO: $244.3MM OC Investment Federal Agency Pool Issues 31% 21% k 3 Local Agency Investment Fund (LAIF) 17% Corporate Bonds Treasury 21% w Securities 3% Medium Term Notes - IADB 7% 61 In Ic ivi Quarterly Activity : Purchases/Deposits: Purchases/Deposits: $34 million LAIF deposits $67.1 million LAIF deposits Total: $34 million $35.1 million OCIP deposits Total: $102.2 million million LAIF withdrawalsCalls/Maturities: Total: • $Z7.1 million Federal Agencies 62 • $53 million LAIF withdrawals • $2.5 million Corporate Bonds Total: $82.6 million V: oil Current Year - Month ❑ December 2020: $272,920 ❑ vs. budget: $150,000 Current Fiscal Year ❑ Through 12/31: $1,836,598 2020/21 ❑ vs. budget: $1,300,000 Effective Rate of Return ❑ December 2020: 1.45% ❑ YTD Fiscal Year: 1.59% Benchmark ❑ December 2020: 0.42% ❑ 12-month moving average 1.5-year Treasury Selected Investment PolicyCompliance MAXIMUM SPECIFIED INVESTMENT TYPE MAXIMUM % OF PORTFOLIO/ MINIMUM QUALITY IN MATURITY MAXIMUM PER REQUIREMENTS COMPLIANCE? ISSUER U.S. Treasury 5 years None None YES Obligations U.S. Government 5 years None None YES Agency Obligations IBRD, IFC, IADB 5 years 10% "AA" Rating YES Corporate Notes 5 years 30%/10% "A" Rating YES Local Agency Investment Fund N/A Up to $75,000,000 None LAIF YES Maximum Maturities No more than 50% of portfolio maturing over 4 years. YES The portfolio is in compliance with all relevant State regulations and the City's Investment Policy. 64 Safety — No principal losses Liquidity — Sufficient funds for operating needs Effective Rate of Return - December 1.45% Prudently managed — No compliance issues ,. Positive contributor to City — Payment of operational expenses 65