Loading...
Item 6 - City's Investment Report as of September 30, 2023December 5, 2023, Item #6AGENDA REPORT CityofPoway DATE: TO: FROM: CONTACT: SUBJECT: Summary: December 5, 2023 Honorable Mayor and Members of the City Council Judy B. Tran, Director of Finance ~ MehrnoushJamshidi, Finance Manager~ (858) 668-4426 or mjamshidi@poway.org City's Investment Report as of September 30, 2023 CITY COUNCIL Quarterly reports of investments are required to be presented to the City Council per California Government Code and the City's Investment Policy. Attached is the Investment Portfolio Report for the quarter ended September 30, 2023. Recommended Action: It is recommended the City Council accept and file the attached report. Discussion: Pursuant to Government Code Sec. 53646(b)(1) and the City's Investment Policy, the Director of Finance (i.e., City Treasurer) renders a quarterly investment report to the City Council concerning the investment portfolio's earnings and performance results. In accordance with the Investment Policy, the quarterly report includes information such as the investment type, issuer, date of maturity, par value, amount invested, current market value, and the source of the market value information. The City is in compliance with its adopted Investment Policy, and the City's investment program provides sufficient liquidity to meet its cash flow requirements for the next six months. The fair value of the City's investment portfolio as of September 30, 2023, was $138,815,708. It consisted of the following: REMAINDER OF PAGE INTENTIONALLY LEFT BLANK 1 of 31 December 5, 2023, Item #6Investment Portfolio Total Cash $127,179 Deposits at CalTRUST $23,438,607 Deposits at the Local Agency Investment Fund (LAIF) $38,662,184 U.S. Treasury Notes $29,342,353 U.S. Instrumentalities $25,698,281 Corporate Notes $21,547,103 Fair Value of Investment Portfolio as of September 30, 2023 $138,815,708 It is the City's practice to keep funds (including those identified to pay for Capital Improvement Projects) invested and earning interest until they are needed. In addition to changing market conditions, reductions in the fair value of the investment portfolio can also be reflected in payments for large capital projects as well as operational expenses. Due to year-end deadlines, there was an influx of invoices to be paid with FY 2022-23 funding in addition to other FY 2023-24 invoices paid through the end of September. The attached Investment Portfolio Report (Attachment B) and Investment Report (Attachment C) were prepared by the City's investment manager, Insight Investment, with input from the City's Finance Department. The Portfolio Report includes all investments while the Investment Report includes only those investments managed by Insight Investment. All City funds, including the General Fund, Water Fund, Wastewater Fund and others -except those identified in Attachment D, are pooled and invested, with earned interest allocated quarterly based on the average daily cash balance in each fund. The funds on deposit at LAIF and CalTRUST earn interest at variable rates. The interest rate for the month ending September 30, 2023, is estimated at 3.55% for LAIF, 4.78% for the CalTRUST short-term fund, and 3.74% for the CalTRUST medium-term fund. For fixed income securities, the difference between amortized cost and fair value is considered an unrealized gain or loss. A realized loss is when the principal of the security is redeemed before its maturity date at a fair ·value lower than its amortized cost value. The amortized cost value of the externally managed investment portfolio is $78,461,280; the fair value is $76,714,917 for an unrealized loss of $1,746,363 or 2.23% of the total amortized cost value. The source of the fair value information for the U.S. Treasury Notes, the U.S. Instrumentalities, Corporate Notes, and Municipal Bonds is Interactive Data Corporation. Also included with this report are recaps of the City's cash and investments held by fiscal agents, non-managed investments, and cash on hand. The total book value of the cash and investments held by our fiscal agent, U.S. Bank, at September 30, 2023, was $127,179. The source of the market value information for these investments was U.S. Bank. The total book value of the non-managed investments was $100,094 at September 30, 2023. The City's cash on hand at September 30, 2023 totaled $2,807,307. As of September 30, 2023, the balance of the City's Library Trust Fund is $261,979. For the Fiscal Year 2023-24 period ending September 30, 2023, $2,325 of interest earnings has been transferred to the General Fund. The City Transfers 90% of the Library Trust Fund's interest revenue to the General Fund on an annual basis to help offset library operating costs. 2 of 31 December 5, 2023, Item #6Environmental Review: This action is not subject to review under the California Environmental Quality Act (CEQA). Fiscal Impact: The externally managed investment portfolio earned interest of $138,390 for the month of September 2023, $137,271 for August 2023, and $139,170 for July 2023. Fees for investment services provided by Insight Investment during this period totaled $9,575. Public Notification: None. Attachments: A. Investment Statistics B. Investment Portfolio Report prepared by Insight Investment C. Investment Report prepared by Insight Investment D. City of Poway Investments and Cash with Fiscal Agent; General, Payroll, and Petty Cash Report at September 30, 2023 Reviewed/Approved By: WendfJ:aserman Assistant City Manager 3 of31 Reviewed By: Alan Fenstermacher City Attorney Approved By: c~ City Manager December 5, 2023, Item #6City of Poway Investment Statistics Separately Managed Investment Pools Fair Value: CalTRUST Short-Term Deposits CalTRUST Medium-Term Deposits September 2022 $ 11,409,244 11,232,705 28,523,955 June 2023 $ 11,753,031 11,488,838 46,903,235 September 2023 11,894,050 11,544,557 38,662,184 Deposits at the Local Agency Investment Fund (LAIF) Total Fair Value $ 51,165,904 $ 70,145,104 $ 62,100,791 Weighted Average Yield Effective Average Duration in days Weighted Average Maturity in days Externally Managed Investment Pools Fair Value: 1.75% 1 1 3.43% 1 1 3.82% 1 1 Cash $ 32,182 $ 130,418 $ 127,179 U.S. Treasury Notes U.S. Instrumentalities Corporate Bonds Total Fair Value Amortized Cost Value: Cash U.S. Treasury Notes U.S. Instrumentalities Corporate Bonds Total Amortized Cost Value Unrealized Gain (Loss) Unrealized Gain (Loss) Percentage Accrued Interest Earned Weighted Average Yield Effective Average Duration in years Weighted Average Maturity in years 28,001,371 25,240,127 21,214,999 74,488,679 32,182 28,984,175 25,943,209 21,862,328 76,821,895 (2,333,216) -3.04% 115,610 1.58% 1.22 1.33 28,980,315 25,612,868 21,609,722 76,333,322 130,418 29,733,715 26,098,763 22,048,935 78,011,831 (1,678,508) -2.15% 131,465 2.52% 1.76 1.93 29,342,353 25,698,281 21,547,103 76,714,917 127,179 30,061,698 26,236,861 22,035,542 78,461,280 (1,746,363) -2.23% 138,390 2.70% 1.75 1.91 Total Fair Value of Portfolio Assets $ 125,654,583 $ 146,478,426 $ 138,815,708 Weighted Average Yield Effective Average Duration in years Weighted Average Maturity in years Glossary of Yield Terminology 1.65% 0.72 0.79 2.96% 0.92 1.01 Coupon: A bond's coupon is the periodic interest payment made to the holder of the fixed income security during the life of the bond. Coupon payments can be made monthly, quarterly, or annually. Book Yield: The Book Yield is that rate of return that will make the present value of the future cash flows of a fixed income security equal to the price paid for the security. This assumes that the security will be held to its maturity. Current Yield: Annual rate of return on an investment expressed as a percentage. Current Yield of a fixed income security is the annualized earnings (coupon) divided by the bond's market value as of the valuation date. One Year Total Yield: The One Year Total Yield or One Year Return represents the portfolio's percentage change over a year's time, factoring in interest payments, changes in market value and reinvestment of distributions. 3.20% 0.97 1.06 Weighted Average Yield: The total yield on a bond portfolio divided by the number of bonds contained in ii, weighted for the size of each bond so that the yield of large holdings does not drown out the calculation of yields on small holdings. Yield to Maturity: The Yield to Maturity (YTM) or Market Yield to Maturity of a fixed income security is that rate of interest that will make the present value of the future cash flows equal to the market value as of the valuation date, assuming the bond is held to maturity. 4 of 31 ATTACHMENT A December 5, 2023, Item #6City of Poway Monthly Investment Portfolio Report September 30, 2023 Separately Managed Investment Pools % Return LAIF $ 38,662,184 62% 3.55% CalTrust -Short $ 11,894,050 19% 4.78% CalTrust -Medium $ 11,544,557 19% 3.74% Total Internally Managed $ 62,100,791 45% Weighted Average Yield 3.82% Days Effective Average Duration -Internal 1 Weighted Average Maturity -Internal 1 Externally Managed Assets % Return Cash $ 127,179 0% 3.50% Treasury Securities $ 29,342,353 38% 2.43% Instrumentality Securities $ 25,698,281 33% 2.79% Corporate Notes $ 21,547,103 28% 2.96% Total Externally Managed $ 76,714,916 55% Weighted Average Yield 2.70% Years Effective Average Duration -External 1.75 Weighted Average Final Maturity -External 1.91 Total Portfolio Assets % Return LAIF $ Ca IT rust -Short $ CalTrust -Medium $ Cash $ Treasury Securities $ Instrumentality Securities $ Corporate Notes $ Total Portfolio Assets $ Weighted Average Yield Effective Average Duration -Total Weighted Average Maturity-Total Portfolio Change Beginning Balance Ending Balance Assets values shown at Market 5 of31 38,662,184 28% 3.55% 11,894,050 9% 4.78% 11,544,557 8% 3.74% 127,179 0% 3.50% 29,342,353 21% 2.43% 25,698,281 19% 2.79% 21,547,103 16% 2.96% 138,815,708 3.20% Years 0.97 1.06 $ $ Ca IT rust -CalTrust -Short, 19% Securities 26% 139,811,963 138,815,708 ATTACHMENT B LAIF, 62% Cash, 0% Treasury Securities, 38% Instrumentality Securities, 33% CalTrust -Short CalTrust-12% Cash 0% December 5, 2023, Item #6AfTACHMENil" C December 5, 2023, Item #6Contents Fixed income market review Activity and performance summary Recap of securities held Maturity distribution of securities held Securities held GASB 40 -Deposit and investment risk disclosure Securities purchased Securities sold and matured Detail of return and interest received Transaction report Additional information 3 4 6 7 8 13 17 18 19 23 24 ..... M .... 0 " December 5, 2023, Item #6FIXED INCOME MARKET REVIEW As of September 30, 2023 Chart 1: The Federal Reserve forecast "higher for longer" interest rates 6 "--c-:::-.... _ 5 ?12.. 4 ' -.... .. -.... , : : : : , , , JidN#ii ....... , .... ', ...... (l) +-' 3 ro ~ Mbff M,iifi! ........ --V, "C C 2 ::, u.. "C (l) 1 u.. 0 2021 2022 2023 2024 2025 2026 --Fed Funds rate - - -Dots (Sep '23) - - -Dots (June '23) Source: Bureau of Labor Statistics, September 30, 2023 Chart 2: Core CPl's momentum continued to improve as energy pushed up headline CPI 12% (l) 10% +-' ~ 8% "C (l) 6% .!::l ro 4% ::, ~ " C .____, \ ,., ........... C 2% -~,· ro ,' ',,,,,' \ ..c +-' 0% • ' C 0 -2% E m -4% -6% 2019 2020 2021 2022 2023 --CPI -----Core CPI Source: Bureau of Labor Statistics, Insight calculations, September 30, 2023 CITY OF POWAY Economic Indicators and Monetary Policy The Federal Reserve kept the Fed Funds target rate on hold at 5.25% to 5.5% at the September meeting. However, the Committee continued to project another rate hike by the end of the year and adjusted the "dot plot" to reflect a slower pace of rate cuts than it did in at its June meeting (Chart 1 ). The Fed also significantly raised its economic growth forecasts. Chair Powell, nonetheless, stated the central bank will "proceed carefully". Headline CPI rose 0.6% month-on-month in August (up from 0.2% in July) driven primarily by higher energy prices. On a year-over-year basis, CPI rose 3.7% in August from 3.2%. However, core CPI painted a more benign picture, decreasing from 4.7% to 4.3% year-on-year, the slowest level since September 2021. Meanwhile, the 3-month annualized rate fell below 3%, improving from 3.1 % to 2.4% (Chart 2). Broad disinflationary trends are still evident across non-energy areas, although there were some blemishes, with non-durable goods and transportation (particularly private transportation) categories contributing positively, likely related to higher energy prices. The final estimate of Q2 GDP was unchanged at 2.1 % (equal to Q1 GDP growth). However, consumption was revised down and business investment was revised up. Labor market conditions remained tight overall. The unemployment rate unexpectedly increased from 3.5% to 3.8%, which was partly driven by the participation rate increasing from 62.6% to 62.8%. Wage growth continued to edge down, falling from 4.4% to 4.3% year-on-year. Job growth was also solid at 187,000 and would have been ~55,000 higher if not for Hollywood strikes and layoffs at a large trucking company. Congress faced the looming prospect of a government shutdown at the end of the month, given objections from a faction of Republicans in the House of Representatives over the required appropriations bills needed to keep the government funded. However, at the very end of the month, Congress passed a "continuing resolution" to keep the government funded for 45 days, buying until mid-November for a comprehensive agreement. Interest Rate Summary As the Federal Reserve projected a "higher for longer" interest rate path, long-end yields rose significantly, but short-end yields remained stable. At the end of September, the 3-month US Treasury bill yielded 5.46%, the 6-month US Treasury bill yielded 5.55%, the 2-year US Treasury note yielded 5.05%, the 5-year US Treasury note yielded 4.61 % and the 1 o-year US Treasury note yielded 4.57%. ... M .... 0 00 3 December 5, 2023, Item #6ACTIVITY AND PERFORMANCE SUMMARY For the period September 1, 2023 -September 30, 2023 Amortized cost Basis Activity summary Opening balance Income received Total receipts Total disbursements lnterportfolio transfers Total lnterportfollo transfers Realized gain (loss) Change in accruals from security movement Total amortization expense Total 01D/MKT accretion Income Return of capital Closing balance Ending fair value Unrealized gain (loss) 203,660.74 0.00 Comparative Bates of Beturn 1%} *Twelve * Six month trailing month trailing Fed Funds Overnight Repo Merrill Lynch 3m US Treas Bill Merrill Lynch 6m US Treas Bill ML 1 Year US Treasury Note ML 2 Year US Treasury Note ML 5 Year US Treasury Note * rates reflected are cumulative 4.60 4.61 4.69 4.77 4.93 4.48 3.85 2.54 2.55 2.55 2.52 2.56 2.28 1.99 78,222,036.23 203,660.74 0.00 0.00 0.00 0.00 (29,043.03) 64,626.12 0.00 78,461,280.06 76,714,916.43 (1,746,363.63) * One month 0.43 0.43 0.43 0.43 0.44 0.40 0.36 Detail of Amortized cost Basis Beturn Interest Accretion Realized earned (amortization} gain (loss) Cash and Cash Equivalents 419.35 0.00 0.00 Corporate Bonds 58,328.81 (4,464.06) 0.00 Government Agencies 44,304.84 14,331.19 0.00 Government Bonds 35,336.94 25,715.96 0.00 Total 138,389.94 35,583.09 0.00 summary of Amortized cost Basis Beturn tor the Period Interest earned Accretion (amortization) Realized gain (loss) on sales Total income on portfolio Average daily amortized cost Period return (%) YTD return (%) Weighted average final maturity in days CITY OF POWAY Total income 419.35 53,864.75 58,636.03 61,052.90 173,973.03 Total portfolio 138,389.94 35,583.09 0.00 173,973.03 78,392,986.03 0.22 1.79 697 ... M .... 0 en 4 December 5, 2023, Item #6ACTIVITY AND PERFORMANCE SUMMARY For the period September 1, 2023 -September 30, 2023 fair Value Basis Activity summary Opening balance Income received Total receipts Total disbursements lnterportfolio transfers Total lnterportfollo transfers Unrealized gain {loss) on security movements Change in accruals from security movement Return of capital Change in fair value for the period Ending fair value 203,660.74 0.00 CQmparative Bates Qf Beturn f%l *Twelve * Six month trailing month trailing Fed Funds Overnight Repo ICE Bofa 3 Months UST-BILL ICE Bofa 6m US Treas Bill ICE Bofa 1 Yr US Treasury Note ICE BofA US Treasury 1-3 ICE BofA US Treasury 1-5 * rates reflected are cumulative 4.60 4.61 4.47 4.59 3.68 2.47 2.13 2.54 2.55 2.50 2.40 1.63 0.17 (0.64) 76,718,925.78 203,660.74 0.00 0.00 0.00 0.00 0.00 (207,670.09) 76,714,916.43 * One month 0.43 0.43 0.46 0.45 0.34 (0.01) (0.34) Detail Qf fair Value Basis Beturn Interest Change in earned fair value Cash and Cash Equivalents 419.35 0.00 Corporate Bonds 58,328.81 (91,919.57) Government Agencies 44,304.84 (66,299.66) Government Bonds 35,336.94 (49,450.86) Total 138,389.94 (207,670.09) summary Qf fair Value Basis Beturn for the PeciQd Interest earned Change in fair value Total income on portfolio Average daily total value* Period return (%) YTD return (%) Weighted average final maturity in days * Total value equals market value and accrued interest CITY OF POWAY Total income 419.35 (33,590.76) (21,994.82) (14,113.92) (69,280.15) Total portfolio 138,389.94 (207,670.09) (69,280.15) 77,124,828.26 (0.09) 2.20 697 ... M .... 0 0 ... 5 December 5, 2023, Item #6RECAP OF SECURITIES HELD As of September 30, 2023 Cash and Cash Equivalents Corporate Bonds Government Agencies Government Bonds :•.J.11:"": Historical cost 127,179.39 22,519,748.00 26,260,440.59 29,876,340.52 \ Amortized cost 127,179.39 22,035,542.37 26,236,860.52 30,061,697.78 Fair value 127,179.39 21,547,102.98 25,698,280.66 29,342,353.40 Unrealized gain (loss) 0.00 (488,439.39) (538,579.86) (719,344.38) Weighted Percent average of final portfolio maturity (days) 736 738 635 0.16 28.58 33.33 37.92 Portfolio diversification {%) ■ Cash and Cash Equivalents ■ Corporate Bonds ■ GovernmentAgencies ■ Government Bonds Total 0.16 28.58 33.33 37.92 100.00 Weighted average effective duration (years) 0.00 1.75 1.87 1.64 CITY OF POWAY ... M ~ 0 ... ... 6 December 5, 2023, Item #6MATURITY DISTRIBUTION OF SECURITIES HELD As of September 30, 2023 Maturity ---Under 90 days 90 to 1 79 days 180 days to 1 year 1 to 2 years 2 to 3 years 3 to 4 years 4 to 5 years Over 5 years 16.00 14.00 E 12.00 .s ..., 10.00 "' 0 u 8.00 ;;; u 6.00 ·;;: 0 ..., 4.00 "' :i: 2.00 0.00 o'l>-f 0:,<::> 00' ,::? 0:,<::>'o o'l>-f ~O:, ...._'b<::> Maturity distribution J ,_.,.,fl) ,o o~'? (, ~q,'1> 'l, ..... ~ ~'? ~q; ":> 'l, ,s, Historic cost Percent 10,414,803.35 13.22 9,511,808.71 12.07 9,518,076.63 12.08 14,556,222.42 18.48 12,388,010.59 15.72 10,224,427.66 12.98 12, 170,359.14 15.45 0.00 0.00 . -., ~ ""-• : _::/~:?f{1.e}~,\2iitf~1:~~ ~'? ~q; i,. ":> ,o ~'? ~q; ½ i,.'-0 ~'? ~q; /-..½ d",., CITY OF POWAY .... M ~ 0 N .... 7 December 5, 2023, Item #6SECURITIES HELD CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity/ Par value or Historical cost Amortized cost Fair value Unrealized Total % Call date shares gain accrued Port (loss) interest cost Cash and Cash Equivalents Cash and Cash Equivalents 0.000 127,179.39 127,179.39 127,179.39 127,179.39 0.00 0.00 0.16 ----Total Cash and Cash Equivalents 127,179.39 127,179.39 127,179.39 127,179.39 0.00 0.00 0.16 ---Corporate Bonds 17325FA57 CITIBANK NA 3.65% 23JAN2024 (CALLABLE 23DEC23) 3.650 01/23/2024 1,400,000.00 1,484,224.00 1,404,905.68 1,390,371.30 (14,534.38) 9,510.28 1.88 12/23/2023 91159HHVS US BANCORP 3.375% OSFEB2024 (CALLABLE OSJAN24) 3.375 02/05/2024 1,900,000.00 1,999,636.00 1,906,150.37 1,881,853.48 (24,296.89) 9,796.88 2.54 01/05/2024 17275RAN2 CISCO SYSTEMS INC 3.625% 04MAR2024 3.625 03/04/2024 1,000,000.00 1,070,370.00 1,007,243.97 991,022.45 (16,221.52) 2,618.06 1.36 459200JY8 IBM CORP 3% 15MAY2024 3.000 05/15/2024 2,300,000.00 2,463,231.00 2,332,444.32 2,260,902.60 (71,541.72) 25,875.00 3.13 02665WCZ2 AMERICAN HONDA FINANCE 2.4% 27 JUN2024 2.400 06/27/2024 1,000,000.00 1,012,410.00 1,002,024.11 975,225.39 (26,798.72) 6,200.00 1.29 46647PAY2 JPMORGAN CHASE & CO 4.023% 05DEC2024 (CALLABLE 4.023 12/05/2024 2,000,000.00 2,207,640.00 2,012,007.65 1,991,118.72 (20,888.93) 25,702.50 2.80 OSDEC23) 12/05/2023 166764BW9 CHEVRON CORP 1.554% 11 MAY2025 (CALLABLE 1 .554 05/11/2025 1,800,000.00 1,715,436.00 1,754,591.79 1,693,558.98 (61,032.81) 10,800.30 2.18 11APR25) 04/11/2025 24422ETC3 JOHN DEERE CAPITAL CORP 3.4% 11SEP2025 3.400 09/11/2025 1,000,000.00 989,920.00 993,535.15 963,070.07 (30,465.08) 1,794.44 1.26 037833EB2 APPLE INC 0.7% 08FEB2026 (CALLABLE 08JAN26) 0.700 02/08/2026 1,200,000.00 1,096, 152.00 1,112,112.67 1,081,901.88 (30,210.79) 1,213.33 1.39 01/08/2026 06051GFX2 BANK OF AMERICA CORP 3.5% 19APR2026 3.500 04/19/2026 1,800,000.00 1,736,028.00 1,743,197.81 1,699,396.00 (43,801.81) 28,175.00 2.20 ... M .... 0 M ... 8 December 5, 2023, Item #6SECURITIES HELD CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity/ Par value or Historical cost Amortized cost Fair value Unrealized Total % Call date shares gain accrued Port (loss) interest cost Corporate Bonds 02665WBH3 AMERICAN HONDA FINANCE 2.3% 095EP2026 2.300 09/09/2026 1,100,000.00 1,034,869.00 1,044,150.83 1,007,104.93 (37,045.90) 1,475.83 1.31 037833DB3 APPLE INC 2.9% 12SEP2027 (CALLABLE 12JUN27) 2. 900 09/12/2027 1,300,000.00 1,234,987.00 1,245,101.85 1,200,433.34 (44,668.51) 1,885.00 1.57 06/12/2027 24422EWK1 JOHN DEERE CAPITAL CORP 4.15% 15SEP2027 4.150 09/15/2027 1,000,000.00 992,020.00 993,259.34 963,673.49 (29,585.85) 1,729.17 1.26 89236TKQ7 TOYOTA MOTOR CREDIT CORP 4.625% 1 2JAN2028 4.625 01/12/2028 1,100,000.00 1,091,585.00 1,092,555.40 1,074,402.19 (18,153.21) 11,022.92 1.39 194162AR4 COLGATE-PALMOLIVE CO 4.6% 01 MAR2028 (CALLABLE 4.600 03/01/2028 2,400,000.00 2,391,240.00 2,392,261.43 2,373,068.16 (19,193.27) 8,893.33 3.04 01 FEB28) 02/01/2028 iotal Corporate Bonds 22,300,000.00 22,519,748.00 22,035,542.37 21,547,102.98 (488,439.39) 146,692.04 28.58 • --Government Agencies 3133EKVB9 FEDERAL FARM CREDIT BANK 1.86% 170CT2023 1.860 10/17/2023 2,000,000.00 1,997,646.00 1,999,973.83 1,997,023.76 (2,950.07) 16,843.33 2.54 3133EJ2B4 FEDERAL FARM CREDIT BANK 3% 06DEC2023 3.000 12/06/2023 1,000,000.00 1,071,740.00 1,004,896.42 995,517.72 (9,378.70) 9,500.00 1.36 3130A3VC5 FEDERAL HOME LOAN BANK 2.25% 08DEC2023 2.250 12/08/2023 1,000,000.00 1,014,600.00 1,000,632.36 993,062.22 (7,570.14) 7,000.00 1.29 3135GOV34 FANNIE MAE 2.5% 05FEB2024 2.500 02/05/2024 1,750,000.00 1,820,547.50 1,757,745.22 1,731,672.20 (26,073.02) 6,684.03 2.31 3133EMRZ7 FEDERAL FARM CREDIT BANK 0.25% 26FEB2024 0.250 02/26/2024 1,250,000.00 1,246,747.50 1,249,510.45 1,224,307.08 (25,203.37) 295.14 1.58 3133EMBE1 FEDERAL FARM CREDIT BANK 0.3% 28MAR2024 0.300 03/28/2024 2,000,000.00 1,998,500.00 1,999,787.76 1,949,597.10 (50, 190.66) 33.33 2.54 (CALLABLE 060CT23) ... M .,_ 0 '<:I' ... 9 December 5, 2023, Item #6SECURITIES HELD CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity/ Par value or Historical cost Amortized cost Fair value Unrealized Total % Call date shares gain accrued Port (loss) interest cost Government Agencies 3135GOV75 FANNIE MAE 1.75% 02JUL2024 1.750 07/02/2024 2,000,000.00 2,007,920.00 2,001,248.83 1,944,723.96 (56,524.87) 8,555.56 2.55 3130AL2A1 FEDERAL HOME LOAN BANK 0.5% 1 OFEB2025 0.500 02/10/2025 1,000,000.00 1,002,860.00 1,000,000.00 934,119.44 (65,880.56) 694.44 1.27 (CALLABLE 1 ONOV23) 11/10/2023 3134A2HG6 FREDDIE MAC 0% 11 DEC2025 0.000 12/11/2025 1,000,000.00 895,930.00 907,525.45 889,228.56 (18,296.89) 0.00 1.14 3130ALHHO FEDERAL HOME LOAN BANK 0.96% 05MAR2026 0.960 03/05/2026 2,300,000.00 2,092,540.00 2,117,743.47 2,077,984.68 (39,758.79) 1,533.33 2.66 (CALLABLE 05NOV23) 10/05/2023 3130AWLZ1 FEDERAL HOME LOAN BANK 4.75% 12JUN2026 4.750 06/12/2026 1,100,000.00 1,096,612.00 1,096,696.95 1,094,425.01 (2,271.94) 11,611.11 1.39 3130APJH9 FEDERAL HOME LOAN BANK 1 % 280CT2026 (CALLABLE 1.000 10/28/2026 2,050,000.00 1,860,110.55 1,895,523.12 1,848,138.28 (47,384.84) 8,655.56 2.36 280CT23) #0006 10/28/2023 3130AQF65 FEDERAL HOME LOAN BANK 1.25% 21 DEC2026 1 .250 l 2/21/2026 2,300,000.00 2,055,763.00 2,106,179.66 2,053,800.46 (52,379.20) 7,906.25 2.61 3130ATHWO FEDERAL HOME LOAN BANK 4.125% 1 OSEP2027 4.125 09/10/2027 2,000,000.00 1,993,260.00 1,994,592.77 1,958,669.32 (35,923.45) 4,583.33 2.53 3133EPCG8 FEDERAL FARM CREDIT BANK 4.125% 01 DEC2027 4.125 12/01/2027 1,000,000.00 989,640.00 990,879.55 974,497.90 (16,381.65) 13,635.42 1.26 3130ATUS4 FEDERAL HOME LOAN BANK 4.25% 1 ODEC2027 4.250 12/10/2027 2,000,000.00 2,010,731.16 2,009,334.13 1,965,067.82 (44,266.31) 25,972.22 2.55 3133EN5N6 FEDERAL FARM CREDIT BANK 4% 06JAN2028 4.000 01/06/2028 1,100,000.00 1,105,292.88 1,104,590.55 1,066,445.15 (38,145.40) 10,266.67 1.40 Total Government Agencies 26,850,000.00 26,260,440.59 26,236,860.52 • 25,698,280.66 (538,579.86) 133,769.72 33.33 .... M .,_ 0 i.n .... 10 December 5, 2023, Item #6SECURITIES HELD CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity/ Par value or Historical cost Amortized cost Fair value Unrealized Total % Call date shares gain accrued Port (loss) interest cost Government Bonds 91282CDA6 USA TREASURY 0.25% 305EP2023 0.250 09/30/2023 1,500,000.00 1,485,761.72 1,500,000.00 1,500,000.00 0.00 1,875.00 1.89 912828T91 USA TREASURY 1.625% 31 OCT2023 1.625 10/31/2023 1,600,000.00 1,640,630.36 1,601,683.88 1,595,253.65 (6,430.23) 10,809.78 2.08 912828U57 USA TREASURY 2.125% 30NOV2023 2.125 11/30/2023 1,900,000.00 1,925,679.69 1,900,982.11 1,889,628.53 (11,353.58) 13,458.33 2.44 9128285P1 USA TREASURY 2.875% 30NOV2023 2.875 11/30/2023 1,100,000.00 1,151,566.19 1,104,303.06 1,095,377.48 (8,925.58) 10,541.67 1.46 91282CBEO USA TREASURY 0.125% 15JAN2024 0.125 01/15/2024 1,900,000.00 1,890,283.71 1,898,750.43 1,871,574.21 (27,176.22) 496.94 2.40 912828X70 USA TREASURY 2% 30APR2024 2.000 04/30/2024 2,000,000.00 2,036,015.63 2,004,574.44 1,960,625.00 (43,949.44) 16,630.44 2.58 912828YH7 USA TREASURY 1.5% 30SEP2024 1.500 09/3012024 1,000,000.00 1,032,304.69 1,010,317.20 962,031.25 (48,285.95) 7,500.00 1.31 912828YM6 USA TREASURY 1.5% 31 OCT2024 1.500 10/3112024 1,100,000.00 1,132,015.40 1,111,267.83 1,054,968.75 (56,299.08) 6,860.05 1.44 912828YYO USA TREASURY 1.75% 31 DEC2024 1.750 12/3112024 1,000,000.00 1,046,643.98 1,016,420.40 956,796.88 (59,623.52) 4,375.00 1.33 912828ZL7 USA TREASURY 0.375% 30APR2025 0.375 04/3012025 2,900,000.00 2,704,703.13 2,799,122.80 2,688,503.90 (110,618.90) 4,521.40 3.43 912828XZ8 USA TREASURY 2.75% 30JUN2025 2.750 06/30/2025 1,500,000.00 1,445,449.22 1,453,273.53 1,440,234.38 (13,039.15) 10,312.50 1.83 91282CAJO USA TREASURY 0.25% 31 AUG2025 0.250 08/31/2025 1,400,000.00 1,279,250.00 1,327,342.70 1,277,445.32 (49,897.38) 288.46 1.62 ... M .... 0 \0 ... -·-·------··-··-------·----~-----· -·· ·----------·---------------11 December 5, 2023, Item #6SECURITIES HELD As of September 30, 2023 Cusip Description Coupon Maturity/ Par value or Historical cost Call date shares Government Bonds 91282CAT8 USA TREASURY 0.25% 31 OCT2025 0.250 10/31/2025 1,200,000.00 1,086,046.88 91282CBC4 USA TREASURY 0.375% 31 DEC2025 0.375 12/31/2025 2,300,000.00 2,106, 124.89 91282CBT7 USA TREASURY 0. 75% 31 MAR2026 0.750 03/31/2026 1,400,000.00 1,243,707.82 91282CDQ1 USA TREASURY 1.25% 31 DEC2026 1 .250 1 2/31/2026 2,350,000.00 2,088,287.11 91282CFUO USA TREASURY 4.125% 31 OCT2027 4.125 10/31/2027 2,100,000.00 2,077,858.60 9128283F5 USA TREASURY 2.25% 15NOV2027 2.250 11/15/2027 1,100,000.00 1,030,523.22 91282CCH2 USA TREASURY 1.25% 30JUN2028 1.250 06/30/2028 1,700,000.00 1,473,488.28 Total Government Bonds 31,050,000.00 29,876,340.52 Amortized cost Fair value Unrealized gain (loss) 1,125,080.00 1,088,109.37 (36,970.63) 2, 172,045.54 2,079,253.91 (92,791.63) 1,288,519.72 1,266,015.63 (22,504.09) 2,146,254.97 2,105,085.94 (41,169.03) 2,078,323.51 2,055,292.97 (23,030.54) 1,041,767.79 1,000,398.43 (41,369.36) 1,481,667.87 1,455,757.80 (25,910.07) 30,061,697.78 29,342,353.40 (719,344.38) CITY OF POWAY Total % accrued Port interest cost 1,247.28 1.38 2,156.25 2.67 5,250.00 1.58 7,343.75 2.65 36,015.29 2.64 9,281.25 1.31 5,312.50 1.87 154,275.89 37.92 .... M .... 0 ,.... .... 12 December 5, 2023, Item #6GASB 40 -DEPOSIT AND INVESTMENT RISK DISCLOSURE CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity Call date S&P Moody Par value or Historical % Portfolio Market % Portfolio Effective date rating rating shares cost hist cost value mkt value dur (yrs) United States Treasury Note/Bond 91282CDA6 USA TREASURY 0.25% 0.250 09/30/2023 AA+ Aaa 1,500,000.00 1,485,761.72 1.89 1,500,000.00 1.96 0.01 912828T91 USA TREASURY 1.625% 1.625 10/31/2023 AA+ Aaa 1,600,000.00 1,640,630.36 2.08 1,595,253.65 2.08 0.09 912828U57 USA TREASURY 2.125% 2.125 11/30/2023 AA+ Aaa 1,900,000.00 1,925,679.69 2.44 1,889,628.53 2.46 0.17 9128285P1 USA TREASURY 2.875% 2.875 11/30/2023 AA+ Aaa 1,100,000.00 1,151,566.19 1.46 1,095,377.48 1.43 0.17 91282CBEO USA TREASURY 0.125% 0.125 01/15/2024 AA+ Aaa 1,900,000.00 1,890,283.71 2.40 1,871,574.21 2.44 0.29 912828X70 USA TREASURY 2% 2.000 04/30/2024 AA+ Aaa 2,000,000.00 2,036,015.63 2.58 1,960,625.00 2.56 0.57 912828YH7 USA TREASURY 1.5% 1.500 09/30/2024 AA+ Aaa 1,000,000.00 1,032,304.69 1.31 962,031.25 1.25 0.97 912828YM6 USA TREASURY 1.5% 1.500 10/31/2024 AA+ Aaa 1,100,000.00 1,132,015.40 1.44 1,054,968.75 1.38 1.04 912828YYO USA TREASURY 1.75% 1.750 12/31/2024 AA+ Aaa 1,000,000.00 1,046,643.98 1.33 956,796.88 1.25 1.21 912828ZL7 USA TREASURY 0.375% 0.375 04/30/2025 AA+ Aaa 2,900,000.00 2,704,703.13 3.43 2,688,503.90 3.50 1.53 912828XZ8 USA TREASURY 2.75% 2.750 06/30/2025 AA+ Aaa 1,500,000.00 1,445,449.22 1.83 1,440,234.38 1.88 1.66 91282CAJO USA TREASURY 0.25% 0.250 08/31/2025 AA+ Aaa 1,400,000.00 1,279,250.00 1.62 1,277,445.32 1.67 1.86 91282CAT8 USA TREASURY 0.25% 0.250 10/31/2025 AA+ Aaa 1,200,000.00 1,086,046.88 1.38 1,088,109.37 1.42 2.02 91282CBC4 USA TREASURY 0.375% 0.375 12/31/2025 AA+ Aaa 2,300,000.00 2,106, 124.89 2.67 2,079,253.91 2.71 2.18 91282CBT7 USA TREASURY 0.75% 0.750 03/31/2026 AA+ Aaa 1,400,000.00 1,243,707.82 1.58 1,266,015.63 1.65 2.41 91282CDQ1 USA TREASURY 1.25% 1.250 12/31/2026 AA+ Aaa 2,350,000.00 2,088,287.11 2.65 2,105,085.94 2.74 3.09 91282CFUO USA TREASURY 4.125% 4.125 10/31/2027 AA+ Aaa 2,100,000.00 2,077,858.60 2.64 2,055,292.97 2.68 3.63 9128283F5 USA TREASURY 2.25% 2.250 11/15/2027 AA+ Aaa 1,100,000.00 1,030,523.22 1.31 1,000,398.43 1.30 3.81 91282CCH2 USA TREASURY 1.25% 1.250 06/30/2028 AA+ Aaa 1,700,000.00 1,473,488.28 1.87 1,455,757.80 1.90 4.47 Issuer total 31,050,000.00 29,876,340.52 37.92 29,342,353.40 38.25 1.64 Federal Home Loan Banks 3130A3VC5 FEDERAL HOME LOAN 2.250 12/08/2023 AA+ Aaa 1,000,000.00 1,014,600.00 1.29 993,062.22 1.29 0.19 3130AL2A1 FEDERAL HOME LOAN 0.500 02/10/2025 11/10/2023 AA+ Aaa 1,000,000.00 1,002,860.00 1.27 934,119.44 1.22 1.33 3130ALHHO FEDERAL HOME LOAN 0.960 03/05/2026 10/05/2023 AA+ Aaa 2,300,000.00 2,092,540.00 2.66 2,077,984.68 2.71 2.27 M .... 0 00 ... 13 December 5, 2023, Item #6GASB 40 -DEPOSIT AND INVESTMENT RISK DISCLOSURE CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity Call date S&P Moody Par value or Historical % Portfolio Market % Portfolio Effective date rating rating shares cost hist cost value mkt value dur (yrs) Federal Home Loan Banks 3130AWLZ1 FEDERAL HOME LOAN 4.750 06/12/2026 AA+ Aaa 1,100,000.00 1,096,612.00 1.39 1,094,425.01 1.43 2.47 3130APJH9 FEDERAL HOME LOAN 1.000 10/28/2026 10/28/2023 AA+ Aaa 2,050,000.00 1,860,110.55 2.36 1,848,138.28 2.41 2.94 3130AQF65 FEDERAL HOME LOAN 1.250 12/21/2026 AA+ Aaa 2,300,000.00 2,055,763.00 2.61 2,053,800.46 2.68 3.06 3130ATHWO FEDERAL HOME LOAN 4.125 09/10/2027 AA+ Aaa 2,000,000.00 1,993,260.00 2.53 1,958,669.32 2.55 3.57 3130ATU54 FEDERAL HOME LOAN 4.250 12/10/2027 AA+ Aaa 2,000,000.00 2,010,731.16 2.55 1,965,067.82 2.56 3.72 Issuer total 13,750,000.00 13,126,476.71 16.66 12,925,267.23 16.85 2.69 Federal Farm Credit Banks Funding Corp 3133EKVB9 FEDERAL FARM CREDIT 1.860 10/17/2023 AA+ Aaa 2,000,000.00 1,997,646.00 2.54 1,997,023.76 2.60 0.05 3133EJ284 FEDERAL FARM CREDIT 3.000 12/06/2023 AA+ Aaa 1,000,000.00 1,071,740.00 1.36 995,517.72 1.30 0.18 3133EMRZ7 FEDERAL FARM CREDIT 0.250 02/26/2024 AA+ Aaa 1,250,000.00 1,246,747.50 1.58 1,224,307.08 1.60 0.40 3133EMBE1 FEDERAL FARM CREDIT 0.300 03/28/2024 AA+ Aaa 2,000,000.00 1,998,500.00 2.54 1,949,597.10 2.54 0.48 3133EPCG8 FEDERAL FARM CREDIT 4.125 12/01/2027 AA+ Aaa 1,000,000.00 989,640.00 1.26 974,497.90 1.27 3.72 3133EN5N6 FEDERAL FARM CREDIT 4.000 01/06/2028 AA+ Aaa 1,100,000.00 1,105,292.88 1.40 1,066,445.15 1.39 3.81 Issuer total 8,350,000.00 8,409,566.38 10.67 8,207,388.71 10.70 1.15 Federal National Mortgage Association 3135GOV34 FANNIE MAE 2.5% 2.500 02/05/2024 AA+ Aaa 1,750,000.00 1,820,547.50 2.31 1,731,672.20 2.26 0.35 3135GOV75 FANNIE MAE 1.75% 1.750 07/02/2024 AA+ Aaa 2,000,000.00 2,007,920.00 2.55 1,944,723.96 2.54 0.73 Issuer total 3,750,000.00 3,828,467.50 4.86 3,676,396.16 4.79 0.55 Colgate-Palmolive Co 194162AR4 COLGATE-PALMOLIVE CO 4.600 03/01/2028 02/01/2028 AA-Aa3 2,400,000.00 2,391,240.00 3.04 2,373,068.16 3.09 3.88 Issuer total 2,400,000.00 2,391,240.00 3.04 2,373,068.16 3.09 3.88 Apple Inc ... 037833EB2 APPLE INC 0.7% 0.700 02/08/2026 01/08/2026 AA+ Aaa M 1,200,000.00 1,096, 152.00 1.39 1,081,901.88 1.41 2.27 'c5 O'I ... 14 December 5, 2023, Item #6GASB 40 -DEPOSIT AND INVESTMENT RISK DISCLOSURE CITY OF POWAY As of September 30, 2023 Cusip Description Coupon Maturity Call date S&P Moody Par value or Historical % Portfolio Market % Portfolio Effective date rating rating shares cost hist cost value mkt value dur (yrs) Apple Inc 037833D63 APPLE INC 2.9% 2.900 09/12/2027 06/12/2027 AA+ Aaa 1,300,000.00 1,234,987.00 1.57 1,200,433.34 1.56 3.58 Issuer total 2,500,000.00 2,331,139.00 2.96 2,282,335.22 2.98 2.96 International Business Machines Corp 459200JY8 IBM CORP 3% 3.000 05/15/2024 A-A3 2,300,000.00 2,463,231.00 3.13 2,260,902.60 2.95 0.60 Issuer total 2,300,000.00 2,463,231.00 3.13 2,260,902.60 2.95 0.60 JPMorgan Chase & Co 46647PAY2 JPMORGAN CHASE & CO 4.023 12/05/2024 12/05/2023 A-A1 2,000,000.00 2,207,640.00 2.80 1,991,118.72 2.60 0.18 Issuer total 2,000,000.00 2,207,640.00 2.80 1,991,118.72 2.60 0.18 American Honda Finance Corp 02665WCZ2 AMERICAN HONDA 2.400 06/27/2024 A-A3 1,000,000.00 1,012,410.00 1.29 975,225.39 1.27 0.72 02665WBH3 AMERICAN HONDA 2.300 09/09/2026 A-A3 1, 100,000.00 1,034,869.00 1.31 1,007,104.93 1.31 2.76 Issuer total 2,100,000.00 2,047,279.00 2.60 1,982,330.32 2.58 1.75 John Deere Capital Corp 24422ETC3 JOHN DEERE CAPITAL 3.400 09/11/2025 A A2 1,000,000.00 989,920.00 1.26 963,070.07 1.26 1.84 24422EWK1 JOHN DEERE CAPITAL 4.150 09/15/2027 A A2 1,000,000.00 992,020.00 1.26 963,673.49 1.26 3.57 Issuer total 2,000,000.00 1,981,940.00 2.52 1,926,743.56 2.51 2.71 us Bancorp 91159HHVS US BANCORP 3.375% 3.375 02/05/2024 01/05/2024 A A3 1,900,000.00 1,999,636.00 2.54 1,881,853.48 2.45 0.35 Issuer total 1,900,000.00 1,999,636.00 2.54 1,881,853.48 2.45 0.35 Bank of America Corp 06051 GFX2 BANK OF AMERICA CORP 3.500 04/19/2026 A-A1 1,800,000.00 1,736,028.00 2.20 1,699,396.00 2.22 2.34 ,-M Issuer total 1,800,000.00 1,736,028.00 2.20 1,699,396.00 2.22 2.34 'c; 0 N 15 December 5, 2023, Item #6GASB 40 -DEPOSIT AND INVESTMENT RISK DISCLOSURE As of September 30, 2023 Cusip Description Coupon Maturity Call date S&P Moody Par value or Historical % Portfolio date rating rating shares cost hist cost Chevron Corp 166764BW9 CHEVRON CORP 1.554% 1.554 05/11/2025 04/11/2025 AA-Aa2 1,800,000.00 1,715,436.00 2.18 Issuer total 1,800,000.00 1,715,436.00 2.18 Citibank NA 17325FAS7 CITIBANK NA 3.65% 3.650 01/23/2024 12/23/2023 A+ Aa3 1,400,000.00 1,484,224.00 1.88 Issuer total 1,400,000.00 1 ,484,224.00 1.88 Toyota Motor Credit Corp 89236TKQ7 TOYOTA MOTOR CREDIT 4.625 01/12/2028 A+ A1 1,100,000.00 1,091,585.00 1.39 Issuer total 1,100,000.00 1,091,585.00 1.39 Cisco Systems Inc 17275RAN2 CISCO SYSTEMS INC 3.625 03/04/2024 AA-A1 1,000,000.00 1,070,370.00 1.36 Issuer total 1,000,000.00 1,070,370.00 1.36 Federal Home Loan Mortgage Corp 3134A2HG6 FREDDIE MAC 0% 0.000 12/11/2025 AA+ Aaa 1,000,000.00 895,930.00 1.14 Issuer total 1,000,000.00 895,930.00 1.14 Cash and Cash Equivalents CASH 0.000 127,179.39 127,179.39 0.00 Issuer total 127,179.39 127,179.39 0.00 Market % Portfolio value mkt value 1,693,558.98 2.21 1,693,558.98 2.21 1,390,371.30 1.81 1,390,371.30 1.81 1,074,402.19 1.40 1,074,402.19 1.40 991,022.45 1.29 991,022.45 1.29 889,228.56 1.16 889,228.56 1.16 127,179.39 0.17 127,179.39 0.17 CITY OF POWAY Effective dur (yrs) 1.54 1.54 0.31 0.31 3.77 3.77 0.42 0.42 2.13 2.13 0.00 0.00 .... M .,_ 0 .... N 16 December 5, 2023, Item #6SECURITIES PURCHASED For the period September 1, 2023 -September 30, 2023 Cusip Description / Broker Trade date Coupon Maturity/ Settle date Call date Gov'ernment Agencies 3130AWL21 FEDERAL HOME LOAN BANK 4.75% 09/06/2023 4.750 06/12/2026 WELLS FARGO SECURITIES, LLC 09/12/2023 ---~ Total Government Agencies Par value or Unit cost Principal shares cost 1,100,000.00 99.69 (1,096,612.00) 1,100,000.00 (1,096,612.00) CITY OF POWAY Accrued interest (8,998.61) (8,998.61) ~ I ... M .,_ 0 N N 17 December 5, 2023, Item #6SECURITIES SOLD AND MATURED For the period September 1, 2023 -September 30, 2023 Cusip Description / Broker Trade date Coupon Maturity/ Par value or Historical cost Settle date Call date shares Government Agencies 3135GOU43 FNMA TRANCHE 2.875% 09-12-2023 09/12/2023 2.875 (1,000,000.00) 1,039,050.00 09/12/2023 Total (Government Agencies) (1,000,000.00) 1,039,050.00 Amortized cost Price Fair value at at sale or sale or maturity maturity 1,000,000.00 0.00 1,000,000.00 1,000,000.00 1,000,000.00 CITY OF POWAY Realized gain (loss) 0.00 0.00 Accrued interest sold 0.00 0.00 ... M .... 0 M N 18 December 5, 2023, Item #6DETAIL OF RETURN AND INTEREST RECEIVED CITY OF POWAY For the period September 1, 2023 -September 30, 2023 Cusip Description Accretion Realized gain Change in fair Interest earned Interest received (amortization) (loss) value Cash Cash and Cash Equivalents 0.00 0.00 0.00 419.35 419.35 Total Cash 0.00 0.00 0.00 419.35 419.35 ------~~ Corporate Bonds 02665WBH3 AMERICAN HONDA FINANCE 2.3% 09SEP2026 1,582.13 0.00 (3,762.57) 2,038.05 12,650.00 02665WCZ2 AMERICAN HONDA FINANCE 2.4% 27JUN2024 (227.43) 0.00 1,852.75 1,933.33 0.00 037833EB2 APPLE INC 0.7% 08FEB2026 (CALLABLE 08JAN26) 3,109.22 0.00 (4,416.64) 676.66 0.00 037833DB3 APPLE INC 2.9% 12SEP2027 (CALLABLE 12JUN27) 1,158.19 0.00 (16,301.97) 3,036.94 18,850.00 06051GFX2 BANK OF AMERICA CORP 3.5% 19APR2026 1,854.26 0.00 (12,408.99) 5,075.00 0.00 166764BW9 CHEVRON CORP 1.554% 11MAY2025 (CALLABLE 11APR25) 2,344.66 0.00 359.14 2,253.30 0.00 17275RAN2 CISCO SYSTEMS INC 3.625% 04MAR2024 (1,411.16) 0.00 855.78 2,920.14 18,125.00 17325FAS7 CITIBANK NA 3.65% 23JAN2024 (CALLABLE 23DEC23) (1,773.14) 0.00 1,191.31 4,116.39 0.00 194162AR4 COLGATE-PALMOLIVE CO 4.6% 01 MAR2028 (CALLABLE 01 FEB28) 145.92 0.00 (34,935.89) 8,893.33 55,200.00 459200JY8 IBM CORP 3% 15MAY2024 (4,325.91) 0.00 3,112.77 5,558.33 0.00 24422ETC3 JOHN DEERE CAPITAL CORP 3.4% 11 SEP2025 276.67 0.00 (2,823.05) 2,738.88 17,000.00 24422EWK1 JOHN DEERE CAPITAL CORP 4.15% 155EP2027 141.91 0.00 (12,429.30) 3,343.06 20,750.00 46647PAY2 JPMORGAN CHASE & CO 4.023% 05DEC2024 (CALLABLE 05DEC23) (5,541.99) 0.00 1,547.82 6,481.50 0.00 89236TKQ7 TOYOTA MOTOR CREDIT CORP 4.625% 12JAN2028 144.83 0.00 (14,011.47) 4,098.27 0.00 91159HHV5 US BANCORP 3.375% 05FEB2024 (CALLABLE 05JAN24) (1,942.22) 0.00 250.74 5,165.63 0.00 -Total Corporate Bonds (4,464.06) 0.00 (91,919.57) 58,328.81 142,575.00 ~ M .... 0 '<:I' N ·--·---~· ➔---·-··-· ----·--19 December 5, 2023, Item #6DETAIL OF RETURN AND INTEREST RECEIVED CITY OF POWAY For the period September 1, 2023 -September 30, 2023 Cusip Description Accretion Realized gain Change in fair Interest earned Interest received (amortization) (loss) value Government Agencies 3135GOV75 FANNIE MAE 1.75% 02JUL2024 (137.74) 0.00 5,798.26 2,819.45 0.00 3135GOV34 FANNIE MAE 2.5% 05FEB2024 (1,858.86) 0.00 3,378.97 3,524.31 0.00 3133EMRZ7 FEDERAL FARM CREDIT BANK 0.25% 26FEB2024 100.59 0.00 5,150.84 251.74 0.00 3133EMBE1 FEDERAL FARM CREDIT BANK 0.3% 28MAR2024 (CALLABLE 060CT23) 35.77 0.00 8,240.84 483.33 3,000.00 3133EKVB9 FEDERAL FARM CREDIT BANK 1.86% 170CT2023 46.19 0.00 6,127.22 2,996.66 0.00 3133EJ2B4 FEDERAL FARM CREDIT BANK 3% 06DEC2023 (2,299.84) 0.00 2,404.13 2,416.67 0.00 3133EN5N6 FEDERAL FARM CREDIT BANK 4% 06JAN2028 (89.66) 0.00 (16,148.87) 3,544.45 0.00 3133EPCG8 FEDERAL FARM CREDIT BANK 4.125% 01 DEC2027 182.28 0.00 (14,669.26) 3,322.92 0.00 3130AL2A1 FEDERAL HOME LOAN BANK 0.5% 1 OFEB2025 (CALLABLE 1 ONOV23) 0.00 0.00 1,942.10 402.77 0.00 3130ALHHO FEDERAL HOME LOAN BANK 0. 96% 05MAR2026 (CALLABLE 05NOV23) 6,457.08 0.00 (7,597.91) 1,778.66 11,040.00 3130APJH9 FEDERAL HOME LOAN BANK 1 % 280CT2026 (CALLABLE 280CT23) #0006 4,182.59 0.00 (12,719 00) 1,651.39 0.00 3130AQF65 FEDERAL HOME LOAN BANK 1.25% 21 DEC2026 5,008.28 0.00 (16,305.64) 2,315.97 0.00 ·.; 3130A3VC5 FEDERAL HOME LOAN BANK 2.25% 08DEC2023 (278.98) 0.00 2,175.89 1,812.50 0.00 3130ATHWO FEDERAL HOME LOAN BANK 4.125% 1 OSEP2027 114.24 0.00 (11,687.32) 6,645.83 41,250.00 3130ATUS4 FEDERAL HOME LOAN BANK 4.25% 1 ODEC2027 (185.45) 0.00 (16,155.08) 6,847.22 0.00 3130AWLZ1 FEDERAL HOME LOAN BANK 4.75% 12JUN2026 84.95 0.00 (2,186.99) 2,612.50 0.00 3135GOU43 FNMA TRANCHE 2.875% 09-12-2023 (311.98) 0.00 786.74 878.47 14,375.00 3134A2HG6 FREDDIE MAC 0% 11 DEC2025 3,281.73 0.00 (4,834.58) 0.00 0.00 -n·-----Total Government Agencies 14,331.19 0.00 (66,299.66) 44,304.84 69,665.00 ... M .... 0 Lil N 20 December 5, 2023, Item #6DETAIL OF RETURN AND INTEREST RECEIVED For the period September 1, 2023 -September 30, 2023 Cusip Description Accretion (amortization) Government Bonds 91282CBEO USA TREASURY 0.125% 15JAN2024 350.35 91282CDA6 USA TREASURY 0.25% 30SEP2023 680.17 91282CAJO USA TREASURY 0.25% 31 AUG2025 3,109.44 91282CAT8 USA TREASURY 0.25% 31 OCT2025 2,949.60 912828ZL7 USA TREASURY 0.375% 30APR2025 5,235.84 91282CBC4 USA TREASURY 0.375% 31 DEC2025 4,664.20 91282CBT7 USA TREASURY 0. 75% 31 MAR2026 3,663.10 91282CCH2 USA TREASURY 1.25% 30JUN2028 3,775.20 91282CDQ1 USA TREASURY 1.25% 31 DEC2026 5,145.07 912828YH7 USA TREASURY 1.5% 305EP2024 (845.68) 912828YM6 USA TREASURY 1.5% 31 OCT2024 (851.47) 912828T91 USA TREASURY 1.625% 31 OCT2023 (1,629.56) 912828YYO USA TREASURY 1.75% 31 DEC2024 (1,075.57) 912828X70 USA TREASURY 2% 30APR2024 (644.28) 912828U57 USA TREASURY 2.125% 30NOV2023 (483.00) 9128283F5 USA TREASURY 2.25% 15NOV2027 1,159.23 912828XZ8 USA TREASURY 2.75% 30JUN2025 2,193.73 9128285P1 USA TREASURY 2.875% 30NOV2023 (2,116.26) Realized gain Change in fair (loss) value 0.00 7,941.39 0.00 6,141.06 0.00 (820.31 I 0.00 (1,312.50) 0.00 1,132.80 0.00 (4,761.72) 0.00 (4,593.74) 0.00 (21,250.00) 0.00 (14,320.31 I 0.00 1,875.00 0.00 1,417.97 0.00 5,191.15 0.00 781.26 0.00 4,765.62 0.00 5,066.03 0.00 (11,128.91 I 0.00 (2,812.50) 0.00 2,338.41 Interest earned 193.61 307.38 288.46 244.56 886.55 703.12 860.66 1,732.34 2,394.70 1,229.51 1,345.10 2,119.56 1,426.63 3,260.87 3,309.42 2,017.66 3,362.77 2,592.22 CITY OF POWAY Interest received 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 .... M .... 0 \l) N 21 December 5, 2023, Item #6DETAIL OF RETURN AND INTEREST RECEIVED Fqr the period September 1, 2023 -September 30, 2023 Cusip Description Government Bonds 91282CFUO USA TREASURY 4.125% 31 OCT2027 Total Government Bonds Accretion (amortization) 435.85 25,715.96 Realized gain (loss) 0.00 0.00 tJ[IIt: CITY OF POWAY Change in fair Interest earned Interest received value (25,101.56) (49,450.86) 7,061.82 35,336.94 0.00 0.00 ... rr, .... 0 " N 22 December 5, 2023, Item #6TRANSACTION REPORT FGr the period September 1, 2023 -September 30, 2023 Trade date Cusip Transaction Sec type Description Maturity Settle date 09/01/2023 194162AR4 Income Corporate Bonds COLGATE-PALMOLIVE CO 4.6% 03/01/2028 09/01/2023 09/04/2023 17275RAN2 Income Corporate Bonds CISCO SYSTEMS INC 3.625% 03/04/2024 09/04/2023 09/05/2023 3130ALHHO Income Government Agencies FEDERAL HOME LOAN BANK 03/05/2026 09/05/2023 09/06/2023 3130AWLZ1 Bought Government Agencies FEDERAL HOME LOAN BANK 06/12/2026 09/12/2023 09/09/2023 02665WBH3 Income Corporate Bonds AMERICAN HONDA FINANCE 09/09/2026 09/11/2023 09/10/2023 3130ATHWO Income Government Agencies FEDERAL HOME LOAN BANK 09/10/2027 09/10/2023 09/11/2023 24422ETC3 Income Corporate Bonds JOHN DEERE CAPITAL CORP 09/11/2025 09/11/2023 09/12/2023 037833DB3 Income Corporate Bonds APPLE INC 2.9% 12SEP2027 09/12/2027 09/12/2023 09/12/2023 3135GOU43 Income Government Agencies FNMA TRANCHE 2.875% 09/12/2023 09/12/2023 09!.)1'/2023 3135GOU43 Capital Change Government Agencies FNMA TRANCHE 2.875% 09/12/2023 09/12/2023 09/15/2023 24422EWK1 Income Corporate Bonds JOHN DEERE CAPITAL CORP 09/15/2027 09/15/2023 09/28/2023 3133EMBE1 Income Government Agencies FEDERAL FARM CREDIT BANK 03/28/2024 09/28/2023 09/30/2023 Income Cash and Cash Equivalents Cash ----~ -· ---·-------------·-Par value or Realized Principal shares gain(loss) 2,400,000.00 0.00 0.00 1,000,000.00 0.00 0.00 2,300,000.00 0.00 0.00 1,100,000.00 0.00 (1,096,612.00) 1,100,000.00 0.00 0.00 2,000,000.00 0.00 0.00 1,000,000.00 0.00 0.00 1,300,000.00 0.00 0.00 1,000,000.00 0.00 0.00 (1,000,000.00) 0.00 1,000,000.00 1,000,000.00 0.00 0.00 2,000,000.00 0.00 0.00 0.00 0.00 0.00 CITY OF POWAY Interest Transaction total 55,200.00 18,125.00 11,040.00 (8,998.61) 12,650.00 41,250.00 17,000.00 18,850.00 14,375.00 0.00 20,750.00 3,000.00 419.35 55,200.00 18,125.00 11,040.00 (1,105,610.61) 12,650.00 41,250.00 17,000.00 18,850.00 14,375.00 1,000,000.00 20,750.00 3,000.00 419.35 ... M .... 0 00 N 23 December 5, 2023, Item #6ADDITIONAL INFORMATION CITY OF POWAY As of September 30, 2023 Past performance is not a guide to future performance. The value of investments and any income from them will fluctuate and is not guaranteed (this may partly be due to exchange rate changes) and investors may not get back the amount invested. Transactions in foreign securities may be executed and settled in local markets. Performance comparisons will be affected by changes in interest rates. Investment returns fluctuate due to changes in market conditions. Investment involves risk, including the possible loss of principal. No assurance can be given that the performance objectives of a given strategy will be achieved. The information contained herein is for your reference only and is being provided in response to your specific request and has been obtained from sources believed to be reliable; however, no representation is made regarding its accuracy or completeness. This document must not be used for the purpose of an offer or solicitation in any jurisdiction or in any circumstances in which such offer or solicitation is unlawful or otherwise not permitted. This document should not be duplicated, amended, or forwarded to a third party without consent from Insight. This is a marketing document intended for professional clients only and should not be made available to or relied upon by retail clients Investment advisory services in North America are provided through two different SEC-registered investment advisers using the brand Insight Investment: Insight North America LLC (INA) and Insight Investment International Limited (IIIL). The North American investment advisers are associated with a broader group of global investment managers that also (individually and collectively) use the corporate brand Insight Investment and may be referred to as Insight, Insight Group or Insight Investment. INA is an investment adviser registered with the Securities and Exchange Commission (SEC), under the Investment Advisers Act of 1940, as amended. Registration with the SEC does not imply a certain level of skill or training. You may request, without charge, additional information about Insight. Moreover, specific information relating to Insights strategies, including investment advisory fees, may be obtained from INA's Form ADV Part 2A, which is available without charge upon request. Where indicated, performance numbers used in the analysis are gross returns. The performance reflects the reinvestment of all dividends and income. lNA charges management fees on all portfolios managed and these fees will reduce the returns on the portfolios. For example, assume that $30 million is invested in an account with INA, and this account achieves a 5.0% annual return compounded monthly, gross of fees, for a period of five years. At the end offive years that account would have grown to $38,500,760 before the deduction of management fees. Assuming management fees of 0.25% per year are deducted monthly from the account, the value at the end of the five year period would be $38,022,447. Actual fees for new accounts are dependent on size and subject to negotiation. INA's investment advisory fees are discussed in Part 2A of its Form ADV. Unless otherwise stated, the source of information is Insight. Any forecasts or opinions are Insight's own at the date of this document (or as otherwise specified) and may change. Material in this publication is for general information only and is not advice, investment advice, or the recommendation of any purchase or sale of any security. Insight makes no implied or expressed recommendations concerning the manner in which an account should or would be handled, as appropriate investment strategies depend upon specific investment guidelines and objectives and should not be construed to be an assurance that any particular security in a strategy will remain in any fund, account, or strategy, or that a previously held security will not be repurchased. It should not be assumed that any of the security transactions or holdings referenced herein have been or will prove to be profitable or that future investment decisions will be profitable or will equal or exceed the past investment performance of the securities listed. Please compare the information provided in this statement to the information provided in the statement received from your Custodian. For trading activity the Clearing broker will be reflected. In certain cases the Clearing broker will differ from the Executing broker. In calculating ratings distributions and weighted average portfolio quality, Insight assigns U.S Treasury and U.S agency securities a quality rating based on the methodology used within the respective benchmark index. When Moody's, S&P and Fitch rate a security, Bank of America and Merrill Lynch indexes assign a simple weighted average statistic while Barclays indexes assign the median statistic. Insight assigns all other securities the lower of Moody's and S&P ratings. Information about the indices shown here is provided to allow for comparison of the performance of the strategy to that of certain well-known and widely recognized indices. There is no representation that such index is an appropriate benchmark for such comparison. You cannot invest directly in an index and the indices represented do not take into account trading commissions and/or other brokerage or custodial costs. The volatility of the indices may be materially different from that of the strategy. In addition, the strategy's holdings may differ substantially from the securities that comprise the indices shown. The ICE BofA 3 Month UST-Bill index is an unmanaged market index of U.S. Treasury securities maturing in 90 days that assumes reinvestment of all income. The ICE BofA 6 Month UST-Bill index measures the performance of Treasury bills with time to maturity of less than 6 months. The ICE BofA 1-Year US Treasury Index is a one-security index comprised of the most recently issued 1-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 1-year note must be auctioned on or before the third business day before the last business day of the month. The ICE BofA 3-Year US Treasury Index is a one-security index comprised of the most recently issued 3-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 3-year note must be auctioned on or before the third business day before the last business day of the month. The ICE BofA 5-Year US Treasury Index is a one-security index comprised of the most recently issued 5-year US Treasury note. The index is rebalanced monthly. In order to qualify for inclusion, a 5-year note must be auctioned on or before the third business day before the last business day of the month. The ICE BofA 1-3 US Year Treasury Index is an unmanaged index that tracks the performance of the direct sovereign debt of the U.S. Government having a maturity of at least one year and less than three years. The ICE BofA 1-5 US Year Treasury Index is an unmanaged index that tracks the performance of the direct sovereign debt of the U.S. Government having a maturity of at least one year and less than five years. ... rt) .._ 0 °' N 24 December 5, 2023, Item #6ADDITIONAL INFORMATION As of September 30, 2023 Insight does not provide tax or legal advice to its clients and all investors are strongly urged to consult their tax and legal advisors regarding any potential strategy or investment. CITY OF POWAY Insight is a group of wholly owned subsidiaries ofThe Bank of New York Mellon Corporation. BNY Mellon is the corporate brand ofThe Bank of New York Mellon Corporation and may also be used as a generic term to reference the Corporation as a whole or its various subsidiaries generally. Products and services may be provided under various brand names and in various countries by subsidiaries, affiliates and joint ventures of The Bank of New York Mellon Corporation where authorized and regulated as required within each jurisdiction. Unless you are notified to the contrary, the products and services mentioned are not insured by the FDIC (or by any governmental entity) and are not guaranteed by or obligations ofThe Bank of New York Mellon Corporation or any of its affiliates. The Bank of New York Corporation assumes no responsibility for the accuracy or completeness of the above data and disclaims all expressed or implied warranties in connection therewith. © 2023 Insight Investment. All rights reserved. ... M .... 0 0 M 25 December 5, 2023, Item #6City of Poway Investments & Cash with Fiscal Agent; Non-Managed Investments; General, Payroll & Petty Cash September 2023 Part I Investments f:t Cash with Fiscal Agents Face Book Settlement :-v'i"";i~ r Days to I % of Total INVESTMENT DESCRIPTION i Date i Maturity i Maturity I Investment Value Value Market 11 Unrealized Value Gain(Loss) 1st Am Gov't Obligations Money Mkt Fd r 09/30/23J ~~s! ,--1 ! i 100.00%j I $488,798.69 ! I $488,798.69 $0.00 Average/Total Paying Agent or Uninvested Cash & DITs Total Investments and Cash with Fiscal Agent Non-Mana!;led Investments INVESTMENT DESCRIPTION County Pool I 1r--p 11 II I ;=. ==:J -, ----I I II Ii I r------1 ---·~-r II L Ir -II I ___ _.I f'va"ri"o-;:;~1 j 1 I. 100.00%1 I $488,798.69 I I $488,798.69 ;===~• I r ___ 1r II $488,798.69] ! $0.00 I ! $0.00 -----.. ·-·-·---:--1 r $488,798.691 -_ --·-1 ---Part II ' Settlement ~ Yield to I Days to r % of Total • Face 11 Book I I Market Unrealized I Date ; Maturity , Maturity I investment Value I Value Value Gain(Loss) ! : 09130123 I' 3.17%1! 1p 100.00%1 r s100,094_01 1 r· s100,094_01 1 i ($3,383.01il ! ' --n---· i;· I~ -··1r ---I II 1! -r 3:17%1, -N/A I ;'100...-00%1 ,-$100,094.01 ir-s100T94.01'l I -$96,711.00 p-~83mJl l , .. --------------__ --_-_ -_;:: __ ---( Average/Total Part Ill General, Payroll f:t Petty Cash f -·s~ok· ! Value l General Cash (Union Bank) ·---• ~--· --··11 $2,748,707.01 r·c-~--· -·-·-·--_-· ~--1 ' Payroll Cash (Union Bank) ,-• -, ·-------------• ---· --· -_' ---, r-sw:-oooyoJ ,----I Emergency Cash (Union Bank) ·••· -------~~---•--" m, ~., --• -1 r--$10,000.00! r I '. Grant Cash (Union Bank) ·-----·--• -· •• -· -·: -----... · • ---·----~ -----·-·1 i $0.00 j I I l Flexible Benefits Cash (Union Bank) ~-. ~ • --•• ·-· --Ir -$20,000.00 I -, ---_---------:--~1 ! Petty Cash ·-·-· -• ---··---• ·------------c ---:·--~ 11 -$8,600.00 I r--·-·· 1 Total Cash ---------·--_,. -------····-·---_-·-! !·-$2,807,307.01 I I ··-· -l ! D-----------____ ,._ -• . C 1-z w ~ J: u s ... M .... 0 ... M