Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
_ 4(c)--Treasurer's Report - March 2024
� � �' � � � � � � ' � �' � � ' � ` CITY OF REDDING REPORT TO THE CITY COUNCIL MEETING DATE: June 4,2024 FROM: Greg Robinett, Director of ITElVI NO. 4(c) Finance/City Treasurer ***APPROVED BY*** � � � cs,z cr i t,S�' Fcrs , 'it�attei:L'ity"I"������rres 5`�'3i?(i'� t�trE� , tiS �:Y .���`?�/?C}?, grobinett@cityofredding.org btippin@cityofredding.org SUBJECT: 4(c)--City of Redding Treasurer's Report for March 2024 Recommendation Accept the City of Redding Treasurer's Reports for the First, Second, and Third Quarters of Fiscal Year 2023-2024. Fiscal Impact There is no fiscal impact to accepting these reports. Alte�native Action The City Council (Council) could choose to not accept the reports and provide alternate direction to staff. Background/Analysis Attached are the Treasurer's Quarterly Reports for the months ending September 2023, December 2023 and March 2024. Also included are the Portfolio Management Report, and a summary of the City of Redding's (City) portfolio for the respective periods. For comparative purposes,prior period information is also reported. The City's portfolio meets the requirements of Investment Policy No. 408. Market values for securities are obtained from US Bank Institutional Trust and Custody Department. The Treasurer's accountability total may be measured against the Finance Department's cash reconciliation report. The effective monthly rate of return for Treasurer-managed funds in the month ending March 2024 was 2.75 percent, a gain of 40 basis points from June 2023. The Fiscal Year 2023-24 rate of return at March 2024 was 2.76 percent, a gain of 93 basis points from June 2023. A basis point equals one one-hundredth of one percent, or 0.01 percent. Report to Redding City Council May 29,Z024 Re: 4(c)--Treasurer's Report-March 2024 Page 2 In July 2023, the City began using the new Oracle ERP system, and due to this �ransition staff had to revise current procedures used to produce accurate Treasurer's Reports. Since July 2023, staff has been working with the project implementation team to develop accurate reporting tools for reporting cash and investment accounts from the Oracle system. Due to the time delay in this process, a Treasurer's report has been created for Quarter 1 (July — September), Quarter 2 (October — December) and Quarter 3 (January — March) of Fiscal Year 2023-24. It should be noted that beginning with Apri12024, we will begin reporting monthly again. Investment activity in the portfolio from July 2024 to March 2024 included the maturity of multiple Federal Agency Coupons and two Medium Term Notes, the purchase of two Federal. Agency Coupons as well as reinvestment of monies in the California Asset Management Program (CAMP) account. CAMP has held a consistently higher monthly yield over Local. Agency Investment Fund and Treasury Markets, ending March 2024 at 5.48 percent. Additionally, transfers between CAMP and the Demand Deposit Account have been made for large payments, such as the Ca1PERS prepayment, and in order to accommodate cash flow needs. The Treasurer's Accountability changed from $293,244,802 in June 2023 to $300,286,605 an increase of$7,041,803. The City Treasurer respectfully recommends the Council accept the attached Treasurer's Report for September 2023, December 2023, and March 2024 noting a Total Treasurer's Accountability of $300,286,605 at March 2024 and an organizational total of $315,135,423, which includes assets held by the City as Successor Agency to the Redding Redevelopment Agency, as well as Entity and Trustee accounts. Environmental Review This is not a project defined under the California Environmental Quality Act, and no further action is required. Council Prior�ity/City ManageN Goals This is a routine operational item. Attachments Treasurer's Report FY 2023-2024 Q1 Treasurer's Report FY 2023-2024 Q2 Treasurer's Report FY 2023-2024 Q3 TREASURER'S REPORT JULY, AUGUST, SEPTEMBER 2023 Demand Deposit Accounts June 2023 FY 2023-2024 QTR 1 US Bank General Account 21,015,395.86 18,654,861.55 Imprest Retirement Contributions 100.00 100.00 Treasurer Credit Card 14,741.38 78,113.46 Utility Credit Card 18,771.63 330,908.42 �ibrary Merchant Account 546.36 475.21 DDAAccount (lncluded in lnvestmentAccounts)* (22,118,294.98) (19,537,823.07) Total Demand Deposit Accounts $ (1,068,739.75) $ (473,364.43) Investment Accounts *DDA Account 22,118,294.98 19,537,823.07 Certificates of Deposit 3,000,000.00 3,000,000.00 California Asset Management Fund 65,000,000.00 53,373,689.24 Local Agency Investment Fund -City 10,038,966.88 1,004,203.79 Treasury Coupon Securities 29,845,870.78 29,859,286.06 Commercial Paper- Medium Term Notes 25,596,828.76 25,509,724.64 Federal Agency Coupon Securities 132,958,953.17 133,053,505.51 Money Market Accounts 3,878,412.89 3,908,512.25 Municipal Bonds 1,883,191.29 1,881,669.22 Total Investments at Historical Cost $ 294,320,518.75 $ 271,128,413.�8 Accrued Purchased Interest (6,976.67) (0.00) Total Accrued Purchased Interest $ (6,976.67) $ (0.00) TOTAL TREASURER'S ACCOUNTABILITY $ 293,244,802.33 $ 270,655,049.35 REDDING JOINT POWERS FINANCING AUTHORITY US BANK-TRUSTEE June 2023 FY 2023-2024 QTR 1 2013 Wastewater- Held in Trust-Series A Revenue Fund - N/A Interest Fund - N/A Principal Fund - N/A Surplus Fund - N/A $ - $ - 2013 Caqital Projects-Series B and Series C Revenue Fund 25.01 0.10 Interest Fund 439.25 204,859.30 Principal Fund 0.62 565,000.00 Rebate Fund - - $ 464.88 $ 769,859.40 2015 Electric- Held in Trust-Series A Revenue Fund - - Interest Fund 748.48 757.26 Principal Fund 2,074.49 2,098.81 $ 2,822.97 $ 2,856.07 2017 Electric Refundinq -Series A Interest Fund 1,072.51 1,085.35 Principal Fund 4,470.80 4,524.33 Surplus Fund - - $ 5,543.31 $ 5,609.68 2018 Electric Refundinq-Series A Interest Fund 699.71 708.09 Prinicipal Fund 2,919.29 2,954.25 Surplus Fund - - $ 3,619.00 $ 3,662.34 2019 Caqital Proiects-Series A Revenue Fund 3,198.28 13.07 Interest Fund 156.77 411,394.39 Principal Fund 545.23 2.23 Acquisition Fund 10,615.60 - 2039 A Term - Sinking AC - - 2044 A Term -Sinking AC - - $ 14,515.88 $ 411,409.69 2020 Wastewater System -Series A&B Debt Service Fund - - Interest Fund 1,068.25 1,080.78 Principal Fund 4,514.49 4,567.42 Surplus Fund - - Refunding Fund - - $ 5,582.74 $ 5,648.20 Total Funds Held in Trust $ 32,548.78 $ 1,199,045.38 -2- RELATED ENTITIES June 2023 FY 2023-2024 QTR 1 SUCCESSOR AGENCY FOR REDDING REDEVE�OPMENT US Bank RRA Account 133,681.58 569,892.26 Subtotal Demand Deposit Accounts $ 133,681.58 $ 569,892.26 Trust Accounts US Bank- Fiscal Agent Canby/Hilltop/Cypress Project Tax Alloc Bonds Series A 2,234,409.79 - US Bank-Trustee Market Street Project Series 2003 424,431.46 - SHASTEC Project Series 2006 1,027,833.41 5,632.00 Subtotal Trust Accounts $ 3,686,674.66 $ 5,632.00 Investment Accounts �ocal Agency Investment Fund 4,701,165.12 4,027,186.39 Subtotal Investment Accounts $ 4,701,165.12 $ 4,027,186.39 Total Redding Redevelopment Agency $ 8,521,521.36 $ 4,602,710.65 HOUSING AUTHORITY US Bank Housing Checking Account 1,563,523.09 1,748,995.67 FSS Escrow Account 231,765.47 236,457.59 Subtotal Demand Deposit Accounts $ 1,795,288.56 $ 1,985,453.26 Investment Accounts Local Agency Investment Fund 982,621.20 990,335.94 Subtotal Investment Accounts $ 982,621.20 $ 990,335.94 Total Housing Authority $ 2,777,909.76 $ 2,975,789.20 REDDING AREA BUS AUTHORITY US Bank Checking Account 1,011,614.16 1,060,129.83 Cornerstone Bank- Designated Veterans Punch Cards 10.00 10.00 Subtotal Demand Deposit Accounts $ 1,011,624.16 $ 1,060,139.83 Investment Accounts Local Agency Investment Fund 1,209,286.80 618,788.24 Subtotal Investment Accounts $ 1,209,286.80 $ 618,788.24 Total Redding Area Bus Authority $ 2,220,910.96 $ 1,678,928.07 TOTAL FUNDS OF RE�ATED ENTITIES $ 13,520,342.08 $ 9,257,427.92 (Includes RRA Trust Accounts) TOTAL JPFA FUNDS HELD IN TRUST $ 32,548.78 $ 1,199,045.38 TOTAL CITY OF REDDING FUNDS $ 293,244,802.33 $ 270,655,049.35 GRAND TOTAL CITY OF REDDING FUNDS, FUNDS HELD IN TRUST 8� FUNDS OF RE�ATED ENTITIES $ 306,797,693.19 $ 281,111,522.65 -3- I Investments by Type at September 30,2023 Monthly Yield Comparisons Year Ended September 30,2023 Monthly Rate of Return Fiscal Yr Rate of Return —�-2-Yr Treasury Municipal 5-Yr Treasury LAIF CAMP Bonds DDA C.D.s 0.69% 4.42% 1.11% Califot'nia 5.750 � r ��f��{ _`' Asset Mgmt 5,500 � ���`������� ��' FUnd � lif}��, P,���;�%{� {�ti�{7.,;" Money Market 19.69°/a 5.250 �i�}��� �� �3iz{ { 1.44°/a 5,000 �7s�,�s�� � t��� ,z�t ; �� ;zi��ii����j���� ��f�ts . 4.750 � t t�Ir11i1��',� rtS'�z 4.500 I���,�,,, u � rt �AIF {`'t it tr�t45�'�r`� �r.- 0.37% 0 4 250 ��.F,�� �t YIELD /o � i�� ` _ ?{��� 4 000 ,z� t � 77,rtr ,?r��� a 7 � ,f S''4iT�ji{���� t 3.7�0 � TI'28SUC�l i f i�{r��t��#��f°� � it us� i��S�i �;� ���������#�� COU OIl 3.SOO Y k � 4 n i Federal SeCU�t1eS 3.250 z�����, '� � � tr�t�t� �� �� ff 'i' �`��' J�r�� s Agency 11.01% 3.000 <� '�,,, '� s ��'t�x��� , p�Sj ���� � ii t t t� Coupons }� 4'�}t£ J t! �t�tZ, � }��I�������r����i�i�I���rMI��R��l ��4�1�f�� t t nt�is o ��'��{V��'I'14�4�i��rllii� 41��� vi�, 49.07/0 �I'iY�u! GiP� ii4�lliii�'Citi�Vllfli�iGf,�i� 2.750 t��2i`��` � t � #r�,�'}� i I i� ��i�p � �y�I.i� r�F�ir , _ .y s �tsr£{�t`�7i��#� � 2.500 Medium Term ����`r` s �{�{s���'r��'a � �� Notes 2.250 � - - ,tzt„��,s„���t�� �. s 9.41% 2.000 1.750 - � : � s7�'��'r��j���f� � f�i'`��'� 1.500 � t` ����f;Sz £t �f?���r�� , �Inclusive of Demand Deposit Accounts 5 4� ��ff�t�y1�Y���t��� � r�?k�s, 1.250 �r�� �,,��,�, �. OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP Maturities by Fiscal Year at September 30,2023 September 2023 39.s9% W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W� These graphs depict investment activity from July 1, 2023 through �"�� Se tember 30, 2023. Due to the be innin of a new fiscal ear, the ��zo,000,000 ���'� p g� g Y FY Rate of Return matches to July as it is the first month of the year. Portfolio value dropped by $25 million, which was primarily due to the $,00,000,000 �r;Y 6.79% annual PERS obligation prepayment of $23 million. Transfers of$9.5 ; ? million and $13.5 million from LAIF and CAMP were made to �so,000,000 � �'� �5.49% ��.020�o accommodate this payment. During the first quarter of FY 23-24, ; �....................................................................................................................... there were no new investment purchases, or investment maturities. �� Investment activity included transfers to and from the general account �so,000,000 &P3 �����,�� for cash flow purposes. ���a �40,000,000 �, � The effects of this investment activity on portfolio diversification, as depicted in the pie chart, was a decrease of 2.39 paint in CAMP and � �.��% 2.77 point decrease in LAIF. �so,000,000 ' 0.00% � Portfolio Liquidity as noted in the bar graph indicates the majority of $o f j liquidity in the current year due to 23/24 maturities 2023/24 2024/25 2025/26 2026/27 2027/28 2028/29 � IT �" � � �=� - c�Tv aF�E�Q�rv� .: :, ` �I QF �EdQ'N� Treasurer's Office � Portfolio Mana ement aa7 cy�r�s�a�� � Redding. Redding,CA 96001 � a� � I � +� � f� 1.-.�' Portfolia Summary t�3o��zs-alss : .... . . ���L�mF1�r a7Va GLJL.�.J� Invesiments �`�s Market Baeak °>Q of Days to YTM Y1'M Yalue Value Vaiue Portfaiio Maturity Term 960 Equiv. 365 Equiv. Certificates of Deppsit-Bank 3,d00.400:00 3,444.Q00.00 3,QOQ,400.40 1.11 724 1,826 1.4d0 1.t114 California Asset Management FUnd 53,373,fi89.24 53,373,689.24 53,373,689.24 'f9.fi9 1 ? 5.474 5:550 tNedium Terrn Notes 25;OQO,Q00.4Q 24,487.225.�(l 25,509.724,C4 9.4i 577 1,fi6fi 1.497 1:518 Fetleral Agency Coupon Securities '133,76U,d40:00 125.774,176.3Q 133;053,505.51 49.07 711 1,344 2.332 2:364 Treasury CouponSecurities 30,ODO,OOO.OQ �7;024,3Q0.00 28,859,286.66 11.01 9$5 1,$17 p:8B6 p;89$ Municipal Bonds 1.$70,ODQ'.00 1;719,483.70 1,$81,fi69.22 0.69 7U1 1,825 0,907 0.920 LAIF-Local Agency Investiment Fund 1,0(34,203:79 i3OD4,203.79 1,qOq,203.79 4.37 1 1 3.534 3.583 Overnight Sweeps&DDA flecounts 19,537,BZ3:07 19;537,823.07 19,537,823.07 7.21 7 1 0.740 0.750 Investment Money Market Accounts 3,908,512.25 3,908,512.25 3:908,512.25 1.A4 1 1 3.233 3.278 271�454;228.35 269,423,413.35 271,128,413:78 100.00°la S26 i,05Q 2.59'1 2:627 Investments Tatal Earnings September 3d Month End€ng Fiscai Yearfia Date Current Year 590,506.60 1.$26,937:67 Average Claily Baiance 27d,273,628.28 278,939,$60.49 E#fective Ra#e of Return 2.82%0 2.6D%c Pursuant ta City ot Redtling,[2esolution No.97-19,this report shows idle funds i�vested`maturing at interv�ls tiuring the year: The LAfF account offers avaiiable funds for expenditure needs on a same day basis. The Gieyaf Redding has sufkicient funds to caver expenditures during the next 6 monihs. `Governmeni Code sections 16429.1,53601,53601.1,and 53&35 NISTORfGAL RATE t�F RETtJRN: FY 90/91 7:72 FY 97l98 6;04 FY" 04/05 3.07 FY 11112 1.40 FY 18/19 1�79 FY 91/92 6:39 Fi' 98/99 5.61 FY 05/06 3:64 FY 12/13 0.$6 FY 19/20 9:87 FY 92193 5.06 FY 9910Q 5:94 FY �6IQ7 4:59 FY' 13/14 0.92 fV 20/21 d;78 FY g3/94 4.59 FY 00/01 6:31 FY 47/(18 4;65 FY 141i5 3.1b FY 21/22 0.73 FY 94/95 5:54 FY 01102 4:98 FY 081�9 3;71 FY 15/'16 1�10 FY 95/96 5.92 FY 02J03 4;02 FY 09110 2.74 FY 16/17 1.26 FY 56/97 5:90 FY -03/04 2�97 fY 10/T'1 1.93 F`( 17/18 1:51 . , ������� GREG R BI t�TT,GITY TREASURER Reporting period p9/01/2023-08t90/2023 PortFolio CITY AG Run�.Date:05122/202&�-ti8�:d4. .. PM.(PRF_PM1)7,3.1�1 Report Var.7.3:11 CITY OF REDDING Portfolio Management Page 1 Interest Earnings Summary September 30, 2023 September 30Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 383,560.51 1,027,053.06 Plus Accrued Interest at End of Period 758,695.79 758,695.79 �ess Accrued Interest at Beginning of Period ( 831,636.62) ( 853,878.32) �ess Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 310,619.68 931,870.53 Adjusted by Premiums and Discounts 8,675.50 26,318.10 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 319,295.18 958,188.63 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 264,458.53 1,145,804.61 Pius Accrued Interest at End of Period 281,742.98 281,742.98 Less Accrued Interest at Beginning of Period ( 274,990.09) ( 558,798.55) Interest Earned during Period 271,211.42 868,749.04 Total Interest Earned during Period 581,831.10 1,800,619.57 Total Adjustments from Premiums and Discounts 8,675.50 26,318.10 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 590,506.60 1,826,937.67 Portfolio CITY AC Run Date:05/02/2024-16:31 PM(PRF_PM6)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 1 Activity Summary September 2022 through September 2023 Yieid to Maturity Managed Number Number Month Number of Total 360 365 Pool of Investments of Investments Average Average End Year Securities Invested Equivaient Equivalent Rate Purchased Redeemed Term Days to Maturity Septembee 2022 57 279,197,611.73 1.543 1.564 0.000 1 0 1,015 716 October 2022 60 282,461,680.53 1.717 1.741 0.000 3 0 1,039 723 November 2022 61 274,165,550.67 1.812 1.837 0.000 1 1 1,088 750 December 2022 63 271,028,298.50 1.933 1.959 0.000 3 1 1,103 752 January 2023 63 291,386,902.66 1.935 1.962 0.000 1 2 996 665 February 2023 61 291,359,716.55 1.973 2.000 0.000 0 1 971 623 March 2023 60 287,501,970.26 2.040 2.068 0.000 0 0 983 611 April 2023 61 286,300,240.74 2.112 2.142 0.000 1 0 994 600 May 2023 61 282,425,731.52 2.067 2.095 0.000 0 0 1,008 587 June 2023 62 294,320,518.75 2.631 2.668 0.000 1 0 967 544 July 2023 62 270,815,984.45 2.516 2.551 0.000 0 0 1,051 569 August 2023 62 273,694,345.98 2.537 2.573 0.000 0 0 1,040 541 September 2023 62 271,128,413.78 2.591 2.627 0.000 0 0 1,050 525 Average 61 281,214,382.01 2.108% 2.138% 0.000 1 0 1,023 631 Portfolio CITY AC Run Date:05/02/2024-16:31 PM(PRF_PM4)7.3.11 Report Ver.7.3.91 CITY OF REDDING Portfolio Management Page 1 Activity By Type September 1, 2023 through September 30, 2023 Stated Transaction Purchases Redemptions CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance Certificates of Deposit-Bank Subtotai 3,000,000.00 Caiifornia Asset Management Fund (Monthly Summary) 9999 9999 PFM 5.550 4,495,592.17 5,245,897.71 Subtotal 4,495,592.17 5,245,897.71 53,373,689.24 Medium Term Notes Subtotai 25,509,724.64 Federal Agency Coupon Securities Subtotai 133,053,505.51 Treasury Coupon Securities Subtotai 29,859,286.06 Municipal Bonds Subtotal 1,881,669.22 LAIF-Local Agency Investment Fund Subtotai 1,004,203.79 Overnight Sweeps&DDA Accounts USB 9400 910 US BANK 0.750 37,768,415.26 39,595,987.27 Subtotai 37,768,415.26 39,595,987.27 19,537,823.07 Investment Money Market Accounts SYS606 606 FIVE STAR BANK 3.434 10,246.52 0.00 Subtotal 10,246.52 0.00 3,908,512.25 Total 42,274,253.95 44,841,884.98 271,128,413.78 Portfolio CITY AC Run Date:O5/02/2024-16:31 PM(PRF_PM3)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 1 Portfolio Details - Investments September 30, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Vaiue Rate S&P 360 Maturity Date Certificates of Deposit-Bank SYS 30031 50514 REDDING BANK OF COMMERCE 09/24/2020 3,000,000.00 3,000,000.00 3,000,000.00 1.000 A 1.000 724 09(24/2025 Subtotai and Average 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 1.000 724 California Asset Management Fund 9999 9999 PFM 53,373,689.24 53,373,689.24 53,373,689.24 5.550 5.474 1 Subtotai and Average 54,765,651.26 53,373,689.24 53,373,689.24 53,373,689.24 5.474 1 Medium Term Notes 037833BZ2 50543 APP�E 01/21/2022 5,000,000.00 4,678,450.00 5,096,724.56 2.450 AAA 1.677 1,038 08l04/2026 06406HCS6 50504 Bank of NY Mellon 03/17/2020 5,000,000.00 4,954,550.00 5,026,118.35 3.650 A 2.023 126 02(04/2024 24422EUE7 50505 BANK OF AMERICA 03/17/2020 5,OOQ000.00 4,868,900.00 5,123,325.06 3.450 A 1.647 529 03(13/2025 594918BJ2 50515 MICROSOFT 11/20/2020 5,000,000.00 4,825,050.00 5,250,715.87 3.125 AA 0.670 764 11/03(2025 89114QCK2 50513 Toronto Dominion Bank 09/15(2020 2,500,000.00 2,278,175.00 2,502,384.33 0.750 A 0.690 711 09/11/2025 91159HHG8 50508 US BANK T&C 03l23/2020 2,500,000.00 2,476,100.00 2,510,456.47 3.700 AA 2.308 121 01l30/2024 Subtotai and Average 25,523,758.08 25,000,000.00 24,081,225.00 25,509,724.64 1.497 577 Federal Agency Coupon Securities 3133EM6E7 50535 FEDERA�FARM CREDIT BANK 09/28/2021 5,000,000.00 4,447,150.00 5,000,000.00 0.940 AA 0.927 1,093 09l28/2026 3133ENDC1 50538 FEDERA�FARM CREDIT BANK 11/03/2021 2,000,000.00 1,800,780.00 2,000,000.00 1.330 AAA 1.312 1,129 11/03/2026 3133ENLY4 50544 FEDERA�FARM CREDIT BANK 01/25/2022 3,OOQ000.00 2,946,540.00 3,OOQ000.00 1.040 AAA 1A26 116 01(25/2024 3133ENMQ0 50547 FEDERA�FARM CREDIT BANK 02/04/2022 3,000,000.00 2,831,370.00 2,995,041.52 1.310 AAA 1.417 491 02/03(2025 3133ENMZ0 50548 FEDERA�FARM CREDIT BANK 02/04(2022 3,000,000.00 2,925,150.00 2,999,229.01 1.200 AAA 1.235 185 04/03/2024 3133ENQV5 50550 FEDERA�FARM CREDIT BANK 03l10l2022 5,000,000.00 4,747,300.00 5,000,000.00 1.870 AA 1.844 526 03/10/2025 3133ENSZ4 50553 FEDERAL FARM CREDIT BANK 04/01(2022 2,500,000.00 2,333,375.00 2,500,000.00 2.750 AAA 2712 1,278 04/01/2027 3133EN3M0 50569 FEDERA�FARM CREDIT BANK 12/05/2022 2,000,000.00 1,984,040.00 2,004,711.11 4.625 AAA 4.353 431 12/05/2024 3130AKQ74 50520 FED HOME LOAN BANK 01/22/2021 2,500,000.00 2,255,650.00 2,500,000.00 0.625 AA 0.616 844 01122/2026 3130AKPN0 50521 FED HOME LOAN BANK 01/29/2021 2,500,000.00 2,260,225.00 2,500,000.00 0.600 AA 0.592 851 01/29/2026 3130ALGJ7 50525 FED HOME LOAN BANK 03/23/2021 4,875,000.00 4,423,233.75 4,875,000.00 1.000 AA 0.986 904 03(23/2026 3130ALDN1 50526 FED HOME LOAN BANK 03/16/2021 5,000,000.00 4,510,900.00 5,000,000.00 0.800 AA 0.789 897 03/16(2026 3130ALXP4 50528 FED HOME LOAN BANK 04/28(2021 2,500,000.00 2,270,925.00 2,500,000.00 1.200 AA 1.184 940 04/28/2026 3130APQ84 50537 FED HOME LOAN BANK 11l23/2021 3,000,000.00 2,711,970.00 3,000,000.00 1.500 AAA 1.479 1,149 11l23/2026 3130APYK5 50540 FED HOME LOAN BANK 12/14(2021 3,000,000.00 2,813,640.00 3,000,000.00 1.150 AAA 1.134 530 03/14/2025 3130ARPB1 50556 FED HOME LOAN BANK 04J28/2022 5,000,000.00 4,763,450.00 5,000,000.00 3.500 AAA 3.452 1,305 04/28/2027 3130ARYA3 50557 FED HOME LOAN BANK 05i26/2022 3,000,000.00 2,889,720.00 3,000,000.00 4.000 AAA 3.945 1,333 05l26/2027 3130ASKB4 50560 FED HOME LOAN BANK 06/29/2022 4,000,000.00 3,971,080.00 4,000,000.00 3.350 AAA 3.304 89 12(29/2023 3130ASQP7 50561 FED HOME LOAN BANK 07/28/2022 2,000,000.00 1,959,040.00 2,000,000.00 3.625 AAA 3.575 485 01(28/2025 Portfolio CITY AC Run Date:05/02/2024-16:31 PM(PRP_PM2)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 2 Portfolio Details - Investments September 30, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Vaiue Rate S&P 360 Maturity Date Federal Agency Coupon Securities 3130ATAH0 50567 FED HOME LOAN BANK 10/18/2022 4,000,000.00 3,960,080.00 3,982,739.57 3.640 AAA 4.563 166 03(15/2024 3130AU2Q6 50571 FED HOME LOAN BANK 12/19/2022 2,000,000.00 1,996,920.00 2,000,823.33 5.000 AAA 4.737 79 12/19(2023 3130AQV26 50573 FED HOME LOAN BANK 04/13(2023 4,000,000.00 3,849,560.00 3,893,626.11 1.610 AAA 4.547 339 09/04/2024 3134GWUG9 50546 FED HOME LOAN MTG CORP 02l03/2022 735,000.00 670,415.55 720,989.22 0.570 AAA 1.542 724 09l24/2025 3134GW6C5 50549 FED HOME LOAN MTG CORP 02/07(2022 2,000,000.00 1,768,680.00 1,940,717.90 0.800 AAA 1785 1,123 10/28/2026 3134GXMT8 50551 FED HOME LOAN MTG CORP 03/25/2022 5,000,000.00 4,770,450.00 5,000,000.00 2.250 AAA 2.219 541 03/25/2025 3134GW6C5 50552 FED HOME LOAN MTG CORP 03i23/2022 3,000,000.00 2,653,020.00 2,850,805.83 0.800 AAA 2.488 1,123 10l28/2026 3134GXQV9 50554 FED HOME LOAN MTG CORP 04/25/2022 4,150,000.00 4,006,742.00 4,150,000.00 3.100 AAA 3.058 572 04(25/2025 3134GW4C7 50555 FED HOME LOAN MTG CORP 04/06/2022 3,000,000.00 2,653,260.00 2,826,922.12 0.800 AAA 2.775 1,122 10(27/2026 3134GXVF8 50558 FED HOME LOAN MTG CORP 06/23/2022 3,000,000.00 2,909,130.00 3,000,000.00 3.000 AAA 2.959 449 12/23(2024 3134GXYE8 50559 FED HOME LOAN MTG CORP 06/2812022 3,000,000.00 2,941,380.00 2,992,435.00 3.100 AAA 3.407 271 06/28/2024 3134GXH56 50562 FED HOME LOAN MTG CORP 07l28l2022 3,000,000.00 2,932,740.00 3,000,000.00 4.000 AAA 3.947 605 05/28/2025 3134GXR89 50563 FED HOME LOAN MTG CORP 08/25(2022 3,000,000.00 2,910,480.00 3,000,000.00 4.375 AAA 4.315 1,424 08/25/2027 3134GY6H0 50570 FED HOME LOAN MTG CORP 12/16/2022 2,000,000.00 1,984,200.00 2,003,018.06 5.500 AAA 5.351 807 12/16/2025 3136G4S61 50511 FEDERA�NATL MTG ASSN 08/25/2020 5,000,000.00 4,582,750.00 5,000,000.00 0.660 AA 0.651 694 08125/2025 3135GA3W9 50516 FEDERA�NATL MTG ASSN 11/25/2020 2,500,000.00 2,270,725.00 2,500,000.00 0.600 AA 0.592 786 11/25/2025 3135GA3Z2 50517 FEDERA�NATL MTG ASSN 11/25/2020 2,500,000.00 2,270,725.00 2,500,000.00 0.600 AA 0.592 786 11(25/2025 3135GA5R8 50518 FEDERA�NATL MTG ASSN 12/18/2020 5,000,000.00 4,524,700.00 5,000,000.00 0.625 AA 0.616 809 12/18(2025 3135G06G3 50519 FEDERA�NATL MTG ASSN 01/19/2021 5,000,000.00 4,555,400.00 5,000,931.44 0.500 AA 0.484 768 11/07/2025 3135G06V0 50564 FEDERA�NATL MTG ASSN 09l16l2022 3,000,000.00 2,930,970.00 2,986,900.42 4.125 AAA 4.311 697 08l28/2025 3135G03U5 50566 FEDERAL NATL MTG ASSN 10/18/2022 3,000,000.00 2,794,350.00 2,829,614.87 0.625 AAA 4.459 569 04/22/2025 3135GADU2 50572 FEDERA�NATL MTG ASSN 01/26/2023 3,000,000.00 2,991,960.00 3,000,000.00 5.000 AAA 4.932 117 01/26/2024 Subtotai and Average 133,037,845.73 133,760,000.00 125,774,176.30 133,053,505.51 2.332 771 Treasury Coupon Securities 91282CBQ3 50522 TREASURY NOTE 03/01/2021 5,000,000.00 4,514,450.00 4,974,354.45 0.500 0.707 881 02/28/2026 91282CBQ3 50523 TREASURY NOTE 03/08/2021 5,000,000.00 4,514,450.00 4,964,412.30 0.500 0.791 881 02/28(2026 91282CBT7 50527 TREASURY NOTE 03/31/2021 2,000,000.00 1,815,160.00 1,991,883.90 0.750 0.904 912 03/31/2026 91282CBW0 50530 TREASURY NOTE 05l13/2021 5,000,000.00 4,521,900.00 4,987,010.48 0.750 0.841 942 04l30/2026 91282CCW9 50534 TREASURY NOTE 08/31(2021 5,000,000.00 4,476,350.00 4,987,241.58 0.750 0.828 1,065 08/31/2026 91282CCW9 50536 TREASURY NOTE 09/28/2021 5,000,000.00 4,476,350.00 4,966,681.73 0.750 0.971 1,065 08/31/2026 91282CDQ1 50541 TREASURY NOTE 01i05/2022 3,000,000.00 2,705,640.00 2,987,701.62 1.250 1.362 1,187 12l31/2026 Subtotai and Average 29,857,171.69 30,000,000.00 27,024,300.00 29,859,286.06 0.886 985 Portfolio CITY AC Run Date:05/02/2024-1631 PM(PRP_PM2)7.3.11 CITY OF REDDING Portfolio Management Page 3 Portfolio Details - Investments September 30, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Vaiue Rate S&P 360 Maturity Date Municipal Bonds 35981VAZ3 50512 FULLERTONREDEVELOPMENTAGENCY 09/02/2020 1,87Q000.00 1,719,483.70 1,881,669.22 1.221 AA 0.907 701 09(01/2025 Subtotai and Average 1,881,914.44 1,870,000.00 1,719,483.70 1,881,669.22 0.907 701 LAIF-Local Agency Investment Fund 1000 601 STATE OF CALIF POOL 04l01/2013 1,004,203.79 1,004,203.79 1,004,203.79 3.534 3.534 1 Subtotai and Average 1,004,203.79 1,004,203.79 1,004,203.79 1,004,203.79 3.534 1 Overnight Sweeps&DDA Accounts USB 9400 910 US BANK 07/01/2019 19,537,823.07 19,537,823.07 19,537,823.07 0.750 0.740 1 Subtotai and Average 21,304,476.01 19,537,823.07 19,537,823.07 19,537,823.07 0.740 1 Investment Money Market Accounts SYS609 609 CORNERSTONE BANK 08/01/2013 250,000.00 250,000.00 250,000.00 1.000 0.986 1 SYS606 606 FIVE STAR BANK 06/30(2013 3,658,512.25 3,658,512.25 3,658,512.25 3.434 3.387 1 SYS608 608 FIVE STAR BANK 06l30l2013 0.00 0.00 0.00 2.624 2.588 1 Subtotai and Average 3,898,607.28 3,908,512.25 3,908,512.25 3,908,512.25 3.233 1 Total and Average 274,273,628.28 271,454,228.35 259,423,413.35 271,128,413.78 2.591 525 Portfolio CITY AC Run Date:05/02/2024-16:31 PM(PRP_PM2)7.3.11 City of Redding Earnin s Histo $700,000 � � � � $600;000 - $500,000 - - - `i� �, �,<� �� $400,000 r� ��,, ... ::� !� o,".. � $300;000 �` � � ° �� � " � �.N M 1� y.y 1� O �� tO O ~ t0 �.<O M � � . � ��, . . , r :W � t�0 N � � � � � � NY H3 �. �Z�����Q .,...�� � O ~ �.� �� � �. e� a _" w �, p fV ' � � ify pp..: N _ d, _7 fq V; . � ..LL � .:� � .. N �....n � � (A fA � � �. . :�y 1n O p> f0 M .,, , . �. 17i � y O M � i"$'F ' �x. . � .o � M c� » ,t,e 7%�� ,t � $100,000 a i� �' y"'- �"� c�v `� d' 'g � 4�, ��i: �;,,.y �i�� � � vi � �.ri �; °D �.� c�t. � �� I .; �..y�,� t, , M M ., ':H' w� c��'�� c��°Q� ��� ���� c�'� ���' �.� ce ��� ��� ���� o`°�� ��''Q£ t�``°�� ��`�' t�¢� ��'� ��� a`� c`� ��`� ��� c°�°e� o�e e�� �ac ���o a P � �� 5 �� �e c,'� �� �� ao z`o �� „�Q. e� �� �� �,.��' eQ�.e oti�`�oti�o ti°�� ti°�� ti�����'a��ti��� ti��� ��`v�ti°��oti��eti���oa���°oti�oeti°��,ti°��� `�°�� �a� ti��� ti��� �o� ����oti�� ti ti <ti ti ti �v City of Redding Book Value Histo $300;000,000 �^ � � ��--���� $295,000,000 $290,OOO,d00 ��� $285,000,000 ��� ����` t�.; � $280,000,000 "��' „ „�e��, a� �y �,,; r �n � �,t�„� �� � n� o�� �ti.,���'s ��o $275,000,000 r,��s, ; �.- � �o�°o� � �u°i�i� °�'., � cv c�n � � � � �' o �'�" � �� �270,���,��� . � �� � " — � , — N — N . � — _ p'� _'__ � � . �� a. .. N = r' V� � fR�. fR�� a0�: � el' �'ct .. . 6� 47 �� � �y 00 � � �� $265,000,000 c�'o � N � — o�o' - � e06.� � � o�o� u�i � � i c ;�,, ,.};� u„f i r;i � {�'.�u � � � n $260,000,000 ��, ,,,..t, � � x s;� o�" c�v i $255,000,000 x, � � c < + � .o� �� ,�e �e �� ' �,c� ,c �� � y�. .oe �o,� ,�e� �,�o'� �� �fi �� ,�tv �Eo Q,� a �c� ��� �o,`� , ,�ec° ti���P titi�e� ���o ti�'�o, titiO�G ���,a ����� ti���� ���� `�'���� `�'���' ���� ���P ��e� �o �L �O �o �L `L `L �o`L � � � � � � ��a� � CITY OF REDDING CITY OF REDDING Treasurer's otece Received Interest 777 Cypress Ave � � � � � � � � � � Sorted by Issuer Redding, Red�530)225-4099 vj Received September 1, 2023 - September 30, 2023 Security Par Current Interest Issuer CUSIP Investment# Type Vaiue Rate Date Due Date Received Amount Due Amount Received Variance BANK OF AMERICA 24422EUE7 50505 MTN 5,000,000.00 3.450 09/13/2023 09l13/2023 86,250.00 86,250.00 - Subtotal 86,250.00 86,250.00 FEDERAL FARM CREDIT BANK 3133ENQV5 50550 FAC 5,000,000.00 1.870 09/10/2023 09/11/2023 46,750.00 46,750.00 - 3133EM6E7 50535 FAC 5,000,000.00 0.940 09/28/2023 09/28/2023 23,500.00 23,500.00 - Subtotal 70,250.00 70,250.00 FED HOME LOAN BANK 3130AQV26 50573 FAC 4,000,000.00 1.610 09(0412023 09/04/2023 32,200.00 32,200.00 - 3130ATAH0 50567 FAC 4,OOQ000.00 3.640 09/15/2023 09/15/2023 72,800.00 72,800.00 - 3130ALDN1 50526 FAC 5,000,000.00 0.800 09/16l2023 09/16/2023 20,000.00 20,000.00 - 3130ALGJ7 50525 FAC 4,875,000.00 1.000 09/23/2023 09/26(2023 24,375.00 24,375.00 - Su btotal 149,375.00 149,375.00 FED HOME LOAN MTG CORP 3134GWUG9 50546 FAC 735,000.00 0.570 09(24/2023 09/24/2023 2,094.75 2,094.75 - 3134GXMT8 50551 FAC 5,000,000.00 2.250 09/25l2023 09/25/2023 56,250.00 56,250.00 - Subtotal 58,344.75 58,344.75 REDDING BANK OF COMMERCE SYS 30031 50514 BCD 3,000,000.00 1.000 09l24/2023 09/24/2023 2,583.33 2,465.76 -117.57 Subtotai 2,583.33 2,465.76 Toronto Dominion Bank 89114QCK2 50513 MTN 2,500,000.00 0.750 09/11/2023 09l11/2023 9,375.00 9,375.00 - Subtotal 9,375.00 9,375.00 TREASURY NOTE 91282CBT7 50527 TRC 2,000,000.00 0.750 09/30/2023 09/30/2023 7,500.00 7,500.00 - Subtotal 7,500.00 7,500.00 Total 383,678.08 383,560.51 Totai Cash Overpayment 0.00 Total Cash Shortfall -117.57 Portfolio CITY AC Run Date:05/02/2024-1634 RI(PRF_RI)7.3.11 Report Ver.7.3.11 CITY OF REDDING Received interest Received September 1,2023-September 30,2023 Page 2 Security Par Current Interest Issuer CUSIP Investment# Type Value Rate Date Received Amount Received Cash Accounts PFM 9999 9999 PA1 53,123,994.78 5.550 09l01/2023 245,897.71 Subtotal 245,897.71 CORNERSTONE BANK SYS609 609 RR4 250,000.00 1.000 09/30/2023 205.48 Subtotal 205.48 FIVE STAR BANK SYS606 606 RR4 3,648,265.73 3.434 09/30/2023 10,246.52 Subtotai 10,246.52 US BANK USB 9400 910 RR3 21,365,395.08 0.750 09/30/2023 8,108.82 Subtotal 8,108.82 Total 264,458.53 Portfolio CITY AC Run Date:05/02/2024-1634 RI(PRF_RI)7.3.11 Report Ver.7.3.11 � � � � � � � •�`���� CITY OF REDDING � `'` �� CITY OF REDDING Treasurer's office Interest Earnings 777 Cypress Ave Redding, Redding,CA 96001 � � � � � � � � 1 � Sorted by Fund - Fund (530)225-4199 September 1, 2023 - September 30, 2023 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Vaiue Book Value Book Value Date Rate Yieid Earned Accretion Earnings Fund:OTHER 9999 9999 050 PA1 53,373,689.24 54,123,994.78 53,373,689.24 5.550 5.613 249,694.46 0.00 249,694.46 1000 601 050 RRP 1,004,203.79 1,004,203.79 1,004,203.79 3.534 3.582 2,956.14 0.00 2,956.14 SYS606 606 050 RR4 3,658,512.25 3,648,265.73 3,658,512.25 3.434 3.417 10,246.52 0.00 10,246.52 SYS609 609 050 RR4 250,000.00 250,000.00 250,000.00 1.000 1.000 205.48 0.00 205.48 USB 9400 910 050 RR3 19,537,823.07 21,365,395.08 19,537,823.07 0.750 0.462 8,108.82 0.00 8,108.82 Subtotal 77,824,228.35 80,391,859.38 77,824,228.35 4.105 271,271.42 0.00 271,211.42 Fund: POOLED CASH 91282CDQ1 50541 100 TRC 3,000,000.00 2,987,390.79 2,987,701.62 12/31/2026 1.250 1.372 3,057.06 310.83 3,367.89 91282CCW9 50534 100 TRC 5,000,000.00 4,986,882.19 4,987,241.58 08/31/2026 0.750 0.842 3,090.66 359.39 3,450.05 91282CBQ3 50523 100 TRC 5,000,000.00 4,963,200.46 4,964,412.30 02/28/2026 0.500 0.802 2,060.44 1,211.84 3,272.28 91282CBT7 50527 100 TRC 2,OOQ000.00 1,991,616.92 1,991,883.90 03/31/2026 0.750 0.914 1,229.50 266.98 1,496.48 91282CBQ3 50522 100 TRC 5,000,000.00 4,973,481.16 4,974,354.45 02/28/2026 0.500 0.718 2,060.44 873.29 2,933.73 91282CBW0 50530 100 TRC 5,000,000.00 4,986,596.80 4,987,010.48 04/30/2026 0750 0.847 3,057.06 413.68 3,47074 91282CCW9 50536 100 TRC 5,000,000.00 4,965,743.19 4,966,681.73 08/31/2026 0.750 0.987 3,090.66 938.54 4,029.20 24422EUE7 50505 100 MTN 5,OOQ000.00 5,130,412.71 5,123,325.06 03(13/2025 3.450 1.728 14,375.00 -7,087.65 7,287.35 SYS 30031 50514 100 BCD 3,000,000.00 3,000,000.00 3,000,000.00 09/24l2025 1.000 0.246 607.45 0.00 607.45 3135G06G3 50519 100 FAC 5,000,000.00 5,000,968.40 5,000,931.44 11/07/2025 0.500 0.498 2,083.33 -36.96 2,046.37 3135GA3Z2 50517 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 11/25/2025 0.600 0.608 1,250.00 0.00 1,250.00 3135GA5R8 50518 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 12/18/2025 0.625 0.634 2,604.16 0.00 2,604.16 3136G4S61 50511 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 08/25/2025 0.660 0.669 2,750.00 0.00 2,750.00 3135GA3W9 50516 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 11l25/2025 0.600 0.608 1,250.00 0.00 1,250.00 3135GADU2 50572 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 01/26(2024 5.000 5.069 12,500.00 0.00 12,500.00 3135G06V0 50564 100 FAC 3,000,000.00 2,986,328.39 2,986,900.42 08(28/2025 4.125 4.434 10,312.50 572.03 10,884.53 3135G03U5 50566 100 FAC 3,000,000.00 2,820,503.36 2,829,614.87 04/22l2025 0.625 4.604 1,562.50 9,111.51 10,674.01 3130APYK5 50540 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 03/14/2025 1.150 1.166 2,875.00 0.00 2,875.00 3130ASK64 50560 100 FAC 4,000,000.00 4,000,000.00 4,000,000.00 12/29/2023 3.350 3.397 11,166.66 0.00 11,166.66 3130AQV26 50573 100 FAC 4,000,000.00 3,891,019.54 3,893,626.11 09/04/2024 1.610 4.675 5,366.67 9,583.24 14,949.91 3130AU2Q6 50571 100 FAC 2,000,000.00 2,001,140.00 2,000,823.33 12/19/2023 5.000 4.874 8,333.33 -316.67 8,016.66 Portfolio CITY AC Run Date:OS/0212024-17:06 IE(PRF_IE)7.3.11 Report Ver.7.3.11 CITY OF REDDING Interest Earnings Page 2 September 1,2023-September 30,2023 Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yieid Earned Accretion Earnings Fund: POOLED CASH 3130ATAH0 50567 100 FAC 4,000,000.00 3,979,582.17 3,982,739.57 03/15/2024 3.640 4.675 12,133.33 3,157.40 15,290.73 3130ARYA3 50557 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 05/26/2027 4.000 4.056 10,000.00 0.00 10,000.00 3130ASQP7 50561 100 FAC 2,000,000.00 2,000,000.00 2,000,000.00 01/28/2025 3.625 3.675 6,041.67 0.00 6,041.67 3130ARPB1 50556 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 04/28/2027 3.500 3.549 14,583.33 0.00 14,583.33 3130APQB4 50537 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 11(23(2026 1.500 1.521 3,750.00 0.00 3,750.00 3130ALGJ7 50525 100 FAC 4,875,000.00 4,875,000.00 4,875,000.00 03/23/2026 1.000 1.014 4,062.50 0.00 4,062.50 3130AKPN0 50521 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 01/29l2026 0.600 0.608 1,250.00 0.00 1,250.00 3130AKQ74 50520 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 01/22/2026 0.625 0.634 1,302.08 0.00 1,302.08 3130ALDN1 50526 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03/16/2026 0.800 0.811 3,333.34 0.00 3,333.34 3130ALXP4 50528 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 04/28/2026 1.200 1.217 2,500.00 0.00 2,500.00 3133ENSZ4 50553 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 04/01/2027 2.750 2.788 5,729.17 0.00 5,729.17 3133EN3M0 50569 100 FAC 2,000,000.00 2,005,044.44 2,004,711.11 12l05/2024 4.625 4.475 7,708.34 -333.33 7,375.01 3133ENDC1 50538 100 FAC 2,000,000.00 2,000,000.00 2,000,000.00 11(03(2026 1.330 1.348 2,216.67 0.00 2,216.67 3133ENQV5 50550 100 FAC 5,000,000.00 5,OOQ000.00 5,000,000.00 03/10/2025 1.870 1.896 7,791.67 0.00 7,791.67 3133EM6E7 50535 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 09/28/2026 0.940 0.953 3,916.67 0.00 3,916.67 3133ENMZ0 50548 100 FAC 3,000,000.00 2,999,101.93 2,999,229.01 04/03/2024 1.200 1.269 3,000.00 127.08 3,127.08 3133ENLY4 50544 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 01/25/2024 1.040 1.054 2,600.00 0.00 2,600.00 3133ENMQ0 50547 100 FAC 3,000,000.00 2,994,732.90 2,995,041.52 02/03/2025 1.310 1.456 3,275.00 308.62 3,583.62 3134GW6C5 50549 100 FAC 2,000,000.00 1,939,111.34 1,940,717.90 10/28/2026 0.800 1.845 1,333.33 1,606.56 2,939.89 3134GXH56 50562 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 05l28/2025 4.000 4.056 10,000.00 0.00 10,000.00 3134GY6H0 50570 100 FAC 2,000,000.00 2,003,131.94 2,003,018.06 12(16(2025 5.500 5.498 9,166.66 -113.88 9,052.78 3134GXR89 50563 100 FAC 3,000,000.00 3,OOQ000.00 3,000,000.00 08/25/2027 4.375 4.436 10,937.50 0.00 10,937.50 3134GXYE8 50559 100 FAC 3,000,000.00 2,991,585.00 2,992,435.00 06/28/2024 3.100 3.498 7,750.00 850.00 8,600.00 3134GXVF8 50558 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 12/23/2024 3.000 3.042 7,500.00 0.00 7,500.00 3134GWUG9 50546 100 FAC 735,000.00 720,399.71 720,989.22 09/24/2025 0.570 1.585 349.12 589.51 938.63 3134GW4C7 50555 100 FAC 3,OOQ000.00 2,822,227.42 2,826,922.12 10/27/2026 0.800 2.886 2,000.00 4,694.70 6,694J0 3134GXQV9 50554 100 FAC 4,150,000.00 4,150,000.00 4,150,000.00 04/25/2025 3.100 3.143 10,720.83 0.00 10,720.83 3134GW6C5 50552 100 FAC 3,000,000.00 2,846,762.63 2,850,805.83 10l28/2026 0.800 2.583 2,000.00 4,043.20 6,043.20 3134GXMT8 50551 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03(25(2025 2.250 2.281 9,375.00 0.00 9,375.00 91159HHG8 50508 100 MTN 2,500,000.00 2,513,092.56 2,510,456.47 01/30/2024 3.700 2.456 7,708.33 -2,636.09 5,072.24 594918BJ2 50515 100 MTN 5,000,000.00 5,260,717.84 5,250,715.87 11/03l2025 3.125 0.698 13,020.83 -10,001.97 3,018.86 037833BZ2 50543 100 MTN 5,000,000.00 5,099,561.05 5,096,724.56 08/04/2026 2.450 1.759 10,208.33 -2,836.49 7,371.84 06406HCS6 50504 100 MTN 5,000,000.00 5,032,488.68 5,026,118.35 02/04/2024 3.650 2.137 15,208.33 -6,370.33 8,838.00 89114QCK2 50513 100 MTN 2,500,000.00 2,502,486.51 2,502,384.33 09/11/2025 0.750 0.710 1,562.50 -102.18 1,460.32 35981VAZ3 50512 100 MUN 1,870,000.00 1,882,176.57 1,881,669.22 09/01/2025 1.221 0.902 1,90273 -507.35 1,395.38 Subtotal 193,630,000.00 193,302,486.60 193,304,185.43 2.010 310,619.68 8,675.50 319,295.18 Portfolio CITY AC Run Date:OS/0212024-17:06 IE(PRF_IE)7.3.11 Report Ver.7.3.11 CITY OF REDDING Interest Earnings Page 3 September 1,2023-September 30,2023 Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yieid Earned Accretion Earnings Total 271,454,228.35 273,694,345.98 271,128,413.78 2.625 581,831.10 8,675.50 590,506.60 Portfolio CITY AC Run Date:OS/0212024-17:06 IE(PRF_IE)7.3.11 Report Ver.7.3.11 � � � � � � CITY OF REDDING C T eaOsu eEs�OffN e Amortization Schedule 777 Cypress Ave � � � � � � � �� � � Redding, Redding,CA 96001 September 1, 2023 - September 30, 2023 (530)225-4199 Sorted By Security Type - Fund Investment# Maturity Date Beginning Par Value Amounts Amortized - --- - - - Purchase Original Premium Ending And Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Value As of 09/01/2023 This Period Through 09/30/2023 Through 09/30/2023 Medium Term Notes 50543 100 08l04/2026 5,000,000.00 5,154,400.00 154,400.00 5,096,724.56 -54,838.95 -2,836.49 -57,675.44 96,724.56 APPLE 2.450 99,561.05 50504 100 02/04(2024 5,000,000.00 5,296,645.00 296,645.00 5,026,118.35 -264,156.32 -6,370.33 -270,526.65 26,118.35 Bank of NY Mellon 3.650 32,488.68 50505 100 03/13/2025 5,000,000.00 5,424,313.81 424,313.81 5,123,325.06 -293,901.10 -7,087.65 -300,988.75 123,325.06 BANK OF AMERICA 3.450 130,41271 50515 100 11/03/2025 5,000,000.00 5,594,450.00 594,450.00 5,250,715.87 -333,732.16 -10,001.97 -343,734.13 250,715.87 M ICROSOFT 3.7 25 260,717.84 50513 100 09i11/2025 2,500,000.00 2,506,117.50 6,117.50 2,502,384.33 -3,630.99 -102.18 -3,733.17 2,384.33 Toronto Dominion Bank 0.750 2,486.51 50508 100 01/30(2024 2,500,000.00 2,621,875.00 121,875.00 2,510,456.47 -108,782.44 -2,636.09 -111,418.53 10,456.47 US BANK T&C 3.700 13,092.56 Subtotal 26,597,801.31 1,597,801.31 25,509,724.64 -1,059,041.96 -29,034.71 -1,088,076.67 509,724.64 538,�59.35 Federal Agency Coupon Securities 50547 100 02/03/2025 3,000,000.00 2,988,900.00 -11,100.00 2,995,041.52 5,832.90 308.62 6,141.52 -4,958.48 FEDERAL FARM CREDIT BANK 1.310 -5,267.10 50548 100 04/03/2024 3,000,000.00 2,996,700.00 -3,300.00 2,999,229.01 2,401.93 127.08 2,529.01 -770.99 FEDERAL FARM CREDIT BANK 1.200 -898.07 50569 100 12/05(2024 2,000,000.00 2,008,000.00 8,000.00 2,004,711.11 -2,955.56 -333.33 -3,288.89 4,711.11 FEDERAL FARM CREDIT BANK 4.625 5,044.44 50567 100 03l15l2024 4,000,000.00 3,946,640.00 -53,360.00 3,982,739.57 32,942.17 3,157.40 36,099.57 -17,260.43 FED HOME LOAN BANK 3.640 -20,417.83 50571 100 12/19/2023 2,OOQ000.00 2,003,800.00 3,800.00 2,000,823.33 -2,660.00 -316.67 -2,976.67 823.33 FED HOME LOAN BANK 5.000 1,140.00 50573 100 09/04/2024 4,000,000.00 3,839,960.00 -160,040.00 3,893,626.11 44,082.87 9,583.24 53,666.11 -106,373.89 FED HOME LOAN BANK 1.610 -115,957.13 50546 100 09/24/2025 735,000.00 709,238.25 -25,761.75 720,989.22 11,161.46 589.51 11,750.97 -14,010.78 FED HOME LOAN MTG CORP 0.570 -14,600.29 50549 100 10/28/2026 2,000,000.00 1,908,908.00 -91,092.00 1,940,717.90 30,203.34 1,606.56 31,809.90 -59,282.10 FED HOME LOAN MTG CORP 0.800 -60,888.66 50552 100 10l28/2026 3,000,000.00 2,776,950.00 -223,050.00 2,850,805.83 69,812.63 4,043.20 73,855.83 -149,194.17 FED HOME LOAN MTG CORP 0.800 -153,237.37 Portfolio CITY AC Run Date:O5/02/2024-16:48 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 CITY OF REDDING Amortization Schedule Page 2 September 1,2023-September 30,2023 Investment# Maturity Date Beginning Par Value Amounts Amortized - - -- -- Purchase Original Premium Ending And Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principai or Discount Book Value As of 09/01I2023 This Period Through 09/30l2023 Through 09/30(2023 Federal Agency Coupon Securities 50555 100 10/27/2026 3,000,000.00 2,743,200.00 -256,800.00 2,826,922.12 79,027.42 4,694.70 83,722.12 -173,077.88 FED HOME LOAN MTG CORP 0.800 -177,772.58 50559 100 06l28/2024 3,000,000.00 2,979,600.00 -20,400.00 2,992,435.00 11,985.00 850.00 12,835.00 -7,565.00 FED HOME LOAN MTG CORP 3.100 -8,415.00 50570 100 12/1612025 2,000,000.00 2,004,100.00 4,100.00 2,003,018.06 -968.06 -113.88 -1,081.94 3,018.06 FED HOME LOAN MTG CORP 5.500 3,131.94 50519 100 11/07/2025 5,000,000.00 5,002,129.00 2,129.00 5,000,931.44 -1,160.60 -36.96 -1,197.56 931.44 FEDERAL NATL MTG ASSN 0.500 968.40 50564 100 08/28/2025 3,000,000.00 2,979,750.00 -20,250.00 2,986,900.42 6,578.39 572.03 7,150.42 -13,099.58 FEDERAL NATL MTG ASSN 4.125 -13,671.61 50566 100 04i22/2025 3,000,000.00 2,725,440.00 -274,560.00 2,829,614.87 95,063.36 9,111.51 104,174.87 -170,385.13 FEDERAL NATL MTG ASSN 0.625 -179,496.64 Subtotal 41,613,315.25 -1,121,684.75 42,028,505.51 381,347.25 33,843.01 415,190.26 -706,494.49 -740,337.50 Treasury Coupon Securities 50522 100 02/28/2026 5,000,000.00 4,946,875.00 -53,125.00 4,974,354.45 26,606.16 873.29 27,479.45 -25,645.55 TREASURY NOTE 0.500 -26,518.84 50523 100 02/28/2026 5,000,000.00 4,926,562.50 -73,437.50 4,964,412.30 36,637.96 1,211.84 37,849.80 -35,587.70 TREASURY NOTE 0.500 -36,799.54 50527 100 03/31/2026 2,000,000.00 1,983,750.00 -16,250.00 1,991,883.90 7,866.92 266.98 8,133.90 -8,116.10 TREASURY NOTE 0.750 -8,383.08 50530 100 04/30(2026 5,000,000.00 4,975,000.00 -25,000.00 4,987,010.48 11,596.80 413.68 12,010.48 -12,989.52 TREASURY NOTE 0.750 -13,403.20 50534 100 08l31/2026 5,000,000.00 4,978,125.00 -21,875.00 4,987,241.58 8,757.19 359.39 9,116.58 -12,758.42 TREASURY NOTE 0.750 -13,117.81 50536 100 08/31/2026 5,OOQ000.00 4,943,750.00 -56,250.00 4,966,681.73 21,993.19 938.54 22,93173 -33,318.27 TREASURY NOTE 0.750 -34,256.81 50541 100 12/31/2026 3,000,000.00 2,981,132.81 -18,867.19 2,987,701.62 6,257.98 310.83 6,568.81 -12,298.38 TREASURY NOTE 1.250 -12,609.21 Subtotal 29,735,195.31 -264,804.69 29,859,286.06 119,716.20 4,374.55 124,090.75 -140,713.94 -145,088.49 Municipal Bonds 50512 100 09l01/2025 1,870,000.00 1,897,414.20 27,414.20 1,881,669.22 -15,237.63 -507.35 -15,744.98 11,669.22 FUILERTON REDEVELOPMENT 1.221 12,176.57 Subtotal 1,897,414.20 27,414.20 1,881,669.22 -15,237.63 -507.35 -15,744.98 11,669.22 12,176.57 Portfolio CITY AC Run Date:O5/02/2024-16:48 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 CITY OF REDDING Amortization Schedule Page 3 September 1,2023-September 30,2023 Investment# Maturity Date Beginning Par Value Amounts Amortized - - -- -- Purchase Original Premium Ending And Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principai or Discount Book Value As of 09/01I2023 This Period Through 09/30l2023 Through 09/30(2023 Totai 99,843,�26.07 238,726.07 99,279,185.43 -573,216.14 8,675.50 -564,540.64 -325,814.57 -334,490.07 Portfolio CITY AC Run Date:05/02/2024-16:48 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 � J 'f' Y � � '' ='� GITY OF REDDING - . �i�� �F �E���N�7 E��'T'E� T�easurer's Office �' 777 Cypress Ave ' Portfalio Matta�ement ��aa�n�, Redding,CA 960Q1 � �, l� I � � � N ! �' Portfalia Summary cs�o�2�5-4�ss �.7��?t£m[k�r a3Wy GVGJ It1V2StmetttS Far Marketi Sook °fo of Days to YTM YTPA Value Value Vatue Portfiolio Term Maturity 36U Equiv; 365 Equiv: �SS Essrow Account 238,457.59 23&.4b7:59 236;457:59 2.56 1 1 4:Q10 0:070 SuccessarAgency MM Account b69;892.26 589,892:26 5fi9;892:26 6;16 1 1 0.838 d.850 LAIF-Loca9 Agency lnvestment Fund 5;636,31D:57 5,636;310:57 5,638;310:57 6b.92 1 T 3.534 3,583 Overnight Sweeps&DDA Accoun4s 2;808,735.50 2,809,135.50 2,$09.135;5Q 3d:36 1 1 0.592 0.600 9,25'1,795.92 9.251,795.92 9,251,795.92 100;00°fo 1 1 2:385 2.418 Inves#menfs fiofal Earnings September 30 Month Ending Fisca!Yese To Date Current Year 1$.965.59 62,054.18 Average Daily Balance 8,255,806.38 9,289;2E3.67 EffeCtive Rate of Return 2:79°{0 2.65°fo ����: y GREG RO IIV TT,CITY TREASURER F2eporting pericsd 09/�112023-09/30t2023 Portfoi�o ENTY CP Run Date:OS/10/2U24-14:A�1 :PM(PRF PM1j 7.3.1�1��� Report Ver.7.3:71 CITY OF REDDING ENTITIES Portfolio Management Page 1 Interest Earnings Summary September 30, 2023 September 30Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 �ess Accrued Interest at Beginning of Period ( 0.00) ( 0.00) �ess Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 �ess Accrued Interest at Beginning of Period ( 0.00) ( 0.00) �ess 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 1,259.87 57,917.34 Plus Accrued Interest at End of Period 60,679.58 60,679.58 �ess Accrued Interest at Beginning of Period ( 42,973.86) ( 56,542.74) Interest Earned during Period 18,965.59 62,054.18 Total Interest Earned during Period 18,965.59 62,054.18 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 18,965.59 62,054.18 Portfolio ENTY CP Run Date:05/10/2024-14:41 PM(PRF_PM6)7,3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Activity Summary September 2022 through September 2023 Yieid to Maturity Managed Number Number Month Number of Total 360 365 Pool of Investments of Investments Average Average End Year Securities Invested Equivaient Equivalent Rate Purchased Redeemed Term Days to Maturity Septembee 2022 7 8,864,656.30 1.183 1.200 0.000 0 0 1 1 October 2022 7 8,896,739.43 1.289 1.307 0.000 0 0 1 1 November 2022 7 8,650,538.12 1.538 1.560 0.000 0 0 1 1 December 2022 7 9,356,531.33 1.475 1.496 0.000 0 0 1 1 January 2023 8 9,541,879.98 1.918 1.945 0.000 1 0 1 1 February 2023 8 9,582,454.67 2.043 2.071 0.000 0 0 1 1 March 2023 8 9,527,732.76 2.201 2.231 0.000 0 0 1 1 April 2023 8 9,455,553.26 2.251 2.282 0.000 0 0 1 1 May 2023 8 10,153,765.38 2.212 2.242 0.000 0 0 1 1 June 2023 8 9,833,667.42 2.387 2.420 0.000 0 0 1 1 July 2023 8 10,265,149.97 2.418 2.451 0.000 0 0 1 1 August 2023 8 8,428,358.46 2.681 2.718 0.000 0 0 1 1 September 2023 8 9,251,795.92 2.385 2.418 0.000 0 0 1 1 Average 8 9,369,909.46 1.999% 2.026% 0.000 0 0 1 1 Portfolio ENTY CP Run Date:05/10/2024-14:41 PM(PRF_PM4)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Activity By Type September 1, 2023 through September 30, 2023 Beginning Stated Transaction Purchases Redemptions Ending CUSIP Investment# Issuer Balance Rate Date or Deposits or Withdrawals Balance FSS Escrow Account (Monthly Summary) 9442 5201 US BANK FSS ESCROW 0.010 9,211.94 25,722.33 Subtotal 252,967.98 9,211.94 25,722.33 236,457.59 Successor Agency MM Account (Monthly Summary) SYS6002 6002 US BANK SUCCESSOR AGENCY 0.850 435,537.46 88.30 Subtotal 134,443.10 435,537.46 88.30 569,892.26 LAIF-Local Agency Investment Fund SYS7000 7000 Local Agency Inv Fund RABA 3.534 0.00 600,000.00 Subtotai 6,236,310.57 0.00 600,000.00 5,636,310.57 Overnight Sweeps&DDA Accounts SYS5002 5002 US BANK HOUSING AUTHORITY 0.600 1,490,110.52 1,197,583.32 SYS 7002 7002 US BANK RABA 0.600 1,254,659.58 542,688.09 Subtotal 1,804,636.81 2,744,770.10 1,740,271.41 2,809,135.50 Total 8,428,358.46 3,189,519.50 2,366,082.04 9,251,795.92 Portfolio ENTY CP Run Date:O5/10/2024-14:41 PM(PRF_PM3)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Portfolio Details - Investments September 30, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Vaiue Rate N�oody's 365 Maturity Date FSS Escrow Account 9442 5201 US BANK FSS ESCROW 236,457.59 236,457.59 236,457.59 0.010 0.010 1 Subtotai and Average 252,417.63 236,457.59 236,457.59 236,457.59 0.010 1 Successor Agency MM Account SYS6002 6002 US BANK SUCCESSOR AGENCY 569,892.26 569,892.26 569,892.26 0.850 0.850 1 Subtotai and Average 148,958.07 569,892.26 569,892.26 569,892.26 0.850 1 LAIF-Local Agency Investment Fund SYS6000 6000 LAIF-COR-Successor to RRA 04/01/2013 4,027,186.39 4,027,186.39 4,027,186.39 3.534 3.583 1 SYS7000 7000 Local Agency I�v Fund RABA 04/01/2013 618,788.24 618,788.24 618,788.24 3.534 3.583 1 SYS5000 5000 Local Agency Inv Fund Housing 04/01/2013 990,335.94 990,335.94 990,335.94 3.534 3.583 1 Subtotai and Average 6,016,310.57 5,636,310.57 5,636,310.57 5,636,310.57 3.583 1 Overnight Sweeps&DDA Accounts SYS 7003 Cornersto�e Bank RABA Punch 01l01/2023 10.00 10.00 10.00 0.000 1 SYS5002 5002 US BANK HOUSING AUTHORITY 07/01(2019 1,748,995.67 1,748,995.67 1,748,995.67 0.600 0.600 1 SYS 7002 7002 US BANK RABA 07/01/2019 1,060,129.83 1,060,129.83 1,060,129.83 0.600 0.600 1 Subtotai and Average 1,838,120.10 2,809,135.50 2,809,135.50 2,809,135.50 0.600 1 Total and Average 8,255,806.38 9,251,795.92 9,251,795.92 9,251,795.92 2.418 1 Portfolio ENTY CP Run Date:05/10/2024-14:41 PM(PRF_PM2)7.3.11 Report Ver.7.3.11 � � � � � � � •�`���� CITY OF REDDING � ` CITY OF REDDING ENTITIES Treasurer's office Interest Earnings 777 Cypress Ave Redding, Redding,CA 96001 � � � � � � � � 1 � Sorted by Fund - Fund (530)225-4199 September 1, 2023 - September 30, 2023 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Vaiue Book Value Book Value Date Rate Yieid Earned Accretion Earnings Fund: ENTITY GF SYS5000 5000 GF RRP 990,335.94 990,335.94 990,335.94 3.534 3.582 2,915.31 0.00 2,915.31 SYS6000 6000 GF RRP 4,027,186.39 4,027,186.39 4,027,186.39 3.534 3.582 11,855.08 0.00 11,855.08 SYS7000 7000 GF RRP 618,788.24 1,218,788.24 618,788.24 3.534 2.935 2,940.20 0.00 2,940.20 SYS 7002 7002 GF RR2 1,060,129.83 348,158.34 1,060,129.83 0.600 1.133 324.09 0.00 324.09 9442 5201 GF PA1 236,457.59 252,967.98 236,457.59 0.010 0.128 26.56 0.00 26.56 SYS5002 5002 GF RR2 1,748,995.67 1,456,468.47 1,748,995.67 0.600 0.704 842.21 0.00 842.21 SYS6002 6002 GF PA2 569,892.26 134,443.10 569,892.26 0.850 0.562 62.14 0.00 62.14 SYS 7003 GF RR2 10.00 10.00 10.00 0.00 0.00 0.00 Subtotal 9,251,795.92 8,428,358.46 9,251,795.92 2.738 18,965.59 0.00 18,965.59 Totai 9,251,795.92 8,428,358.46 9,251,795.92 2.738 18,965.59 0.00 18,965.59 Portfolio ENTY CP Run Date:OS/1012024-14:46 IE(PRF_IE)7.3.11 Report Ver.7.3.11 � � � � � � ��a� � CITY OF REDDING ENTITIES CiT easu eEDOffi e Received Interest 777 Cypress Ave � � � � � � � � � � Sorted by Security Type Redding, Red�530)225-4099 vj Received September 1, 2023 - September 30, 2023 Security Par Current Interest Security Type CUSIP Investment# Type Vaiue Rate Date Received Amount Received Cash Accounts FSS Escrow Account 9442 5201 PA1 252,967.98 0.010 09/30/2023 30.47 Subtotal 30.47 Successor Agency MM Account SYS6002 6002 PA2 134,443.10 0.850 09/30/2023 63.10 Subtotai 63.10 Overnight Sweeps&DDA Accounts SYS5002 5002 RR2 1,456,468.47 0.600 09l30/2023 842.21 SYS 7002 7002 RR2 348,158.34 0.600 09/30/2023 324.09 Subtotal 1,166.30 Total 1,259.87 Portfolio ENTY CP Run Date:05/10/2024-14:46 RI(PRF_RI)7.3.11 Report Ver.7.3.11 City of Redding, Entities Earnings History � $25,000 ��� �� � $20,000 i;�y�, $15,000 ,nr }„ �'�' ;',, ��.._ } f�; �� � h>�� }�r;. h �� $10,000 r� ��� �N � e,,, v 'ao ��0,, � � ���r� �rn � , €, � r` ��:et „ �� � M � � R1 � OO 1� �V�J�Q�� i!3 ��. � p�p��, � � O ���. r ' O �� � .:.� a- ,,.: �.. O oo', oo � ,��, �t". �'3'� rn �v n �i"' G M tCi .,� ' M � ' .���tf) M d. if'� �� � , � �� '�j e�' c� c`1 � �. �� � v� �� , c'� ' �. �� ' �,��' �� +�� �� t�� ��'r ��• �� �� �� os�� �'�� �.��°� �� �� ��c1 �� t�'.� Q�� �� �� �� gJy ��� p� o�� ��+� �a� ��a �� �,P �` 3� �`� �� e��. ��, a�r� eve ��� ��^p �� ,�P �. �� �� �,� e��, ti���oti�c`o`��O tia���,��� ti��� ryp`L �'ory`��'�ty`L �p`L�o�`i•��,.L����`y���������o�,����� �o�� �o� �a�� �o�� �o��o������ `L `L �L �• �L �L City of Redding, Entities Book Value History $12,000,000 ������ $10,000,000 � yc��Q�Q�flVV �r,i 1 p�i �izfi�4'i ��',S,z% �,.�.` , ,«''�.'� y,..�� t$r,t� x,+t,a , t t"tr � c h. �`t?� t t. S ''"" ,�,(':, . $6,000,000 � o �n cn cn ti c�'o � ao : . � � � M M � 0�0 d' h i�( � M � � ' � co co n : ��. tf� ,. <p" � N 1� IA e- � M � � M N . $4,000,000 a°'o atOo aa'o �' � � � � �r � ss v os" � � � � � � � � � � � , ' � � �Z�����Q�V , z(<,fi' i`{�'f �r1,:�t� t�}r�',# '`�u� tx{��%� „��N?s`� �,ul+i b � ' �pna.� �t�'�`t� j�, iz` �' � } �t� r�„tf�, J �tG+" .sti'3 J�� �'`. ��,� �� �t''� p�''c �� �� r �� � t,, �,� `c��t ��� ��� �,�o�a ��� G�� ��� ��t� ��to ��Q �� ��.� ����� PJ�� eQ�e� `L���� p`L�'��� �.d��o 'p`1.`ti�o p`b`�'�e �,4�'�� �y��'�� `L��� �'�� `1'��� q'��� `ti��' �L��'� p`ti`�� �L rL �L , �L TREASURER'S REPORT OCTOBER, NOVEMBER, DECEMBER 2023 Demand Deposit Accounts FY 2023-2024 QTR 1 FY 2023-2024 QTR 2 US Bank General Account 18,654,861.55 15,517,015.28 Imprest Retirement Contributions 100.00 100.00 Treasurer Credit Card 78,113.46 43,072.65 Utility Credit Card 330,908.42 211,353.40 �ibrary Merchant Account 475.21 633.96 DDAAccount (lncluded in lnvestmentAccounts)* (19,537,823.07) (17,028,627.69) Total Demand Deposit Accounts $ (473,364.43) $ (1,256,452.40) Investment Accounts *DDA Account 19,537,823.07 17,028,627.69 Certificates of Deposit 3,000,000.00 3,000,000.00 California Asset Management Fund 53,373,689.24 74,205,418.15 Local Agency Investment Fund - City 1,004,203.79 1,036,848.99 Treasury Coupon Securities 29,859,286.06 29,872,701.34 Commercial Paper- Medium Term Notes 25,509,724.64 25,422,620.51 Federal Agency Coupon Securities 133,053,505.51 127,155,161.19 Money Market Accounts 3,908,512.25 3,942,300.70 Municipal Bonds 1,881,669.22 1,880,147.14 Total Investments at Historical Cost $ 271,128,413.78 $ 283,543,825.71 Accrued Purchased Interest (0.00) (0.00) Total Accrued Purchased Interest $ (0.00) $ (0.00) TOTAL TREASURER'S ACCOUNTABI�ITY $ 270,655,049.35 $ 282,287,373.31 RELATED ENTITIES FY 2023-2024 QTR 1 FY 2023-2024 QTR 2 SUCCESSOR AGENCY FOR REDDING REDEVELOPMENT US Bank RRA Account 569,892.26 588,776.99 Subtotal Demand Deposit Accounts $ 569,892.26 $ 588,776.99 Trust Accounts US Bank-Trustee Market Street Project Series 2003 - - SHASTEC Project Series 2006 5,632.00 - Subtotal Trust Accounts $ 5,632.00 $ - Investment Accounts Local Agency Investment Fund 4,027,186.39 4,066,215.65 Subtotal Investment Accounts $ 4,027,186.39 $ 4,066,215.65 Total Redding Redevelopment Agency $ 4,602,710.65 $ 4,654,992.64 HOUSING AUTHORITY US Bank Nousing Checking Account 1,748,995.67 1,826,246.00 FSS Escrow Account 236,457.59 214,620.38 Subtotal Demand Deposit Accounts $ 1,985,453.26 $ 2,040,866.38 Investment Accounts Local Agency Investment Fund 990,335.94 999,266.39 Subtotal Investment Accounts $ 990,335.94 $ 999,266.39 Total Housing Authority $ 2,975,789.20 $ 3,040,132.77 REDDING AREA BUS AUTHORITY US Bank Checking Account 1,060,129.83 1,490,484.95 Cornerstone Bank- Designated Veterans Punch Cards 10.00 6,216.10 Subtotal Demand Deposit Accounts $ 1,060,139.83 $ 1,496,701.05 Investment Accounts Local Agency Investment Fund 618,788.24 629,131.15 Subtotal Investment Accounts $ 618,788.24 $ 629,131.15 Total Redding Area Bus Authority $ 1,678,928.07 $ 2,125,832.20 TOTAL FUNDS OF RELATED ENTITIES $ 9,257,427.92 $ 9,820,957.61 (Includes RRA Trust Accounts) TOTA�JPFA FUNDS HELD IN TRUST $ 1,199,045.38 $ 7,169.91 TOTA�CITY OF REDDING FUNDS $ 270,655,049.35 $ 282,287,373.31 GRAND TOTAL CITY OF REDDING FUNDS, FUNDS HELD IN TRUST& FUNDS OF RELATED ENTITIES $ 281,111,522.65 $ 292,115,500.83 -3- REDDING JOINT POWERS FINANCING AUTHORITY US BANK-TRUSTEE FY 2023-2024 QTR 1 FY 2023-2024 QTR 2 2013 Capital Proiects- Series B and Series C Revenue Fund 0.10 0.14 Interest Fund 204,859.30 544.91 Principal Fund 565,000.00 1,496.07 Rebate Fund - - $ 769,859.40 $ 2,041.12 2015 Electric- Held in Trust- Series A Revenue Fund - - Interest Fund 757.26 853.33 Principal Fund 2,098.81 14.48 $ 2,856.07 $ 867.81 2017 Electric Refunding - Series A Interest Fund 1,085.35 1,157.09 Principal Fund 4,524.33 32.18 Surplus Fund - - $ 5,609.68 $ 1,189.27 2018 Electric Refunding-Series A Interest Fund 708.09 754.81 Prinicipal Fund 2,954.25 21.01 Surplus Fund - - $ 3,662.34 $ 775.82 2019 Capital Projects- Series A Revenue Fund 13.07 17.89 Interest Fund 411,394.39 1,090.21 Principal Fund 2.23 3.05 Acquisition Fund - - 2039 A Term -Sinking AC - - 2044 A Term -Sinking AC - - $ 411,409.69 $ 1,111.15 2020 Wastewater Svstem -Series A&B Debt Service Fund - - Interest Fund 1,080.78 1,153.24 Principal Fund 4,567.42 31.50 Surplus Fund - - Refunding Fund - - $ 5,648.20 $ 1,184.74 Total Funds Held in Trust $ 1,199,045.38 $ 7,169.91 -2- Iinvestments by Type at December 31,2023 Monthly Yield Comparisons Year Ended December 31,2023 Monthly Rate of Return Fiscal Yr Rate of Return —�-2-Yr Treasury Municipal 5-Yr Treasury LAIF CAMP Bonds DDA C.D.s 5.750 0.66% 4A2% 1.06% i f Ft�'�,'s f�t4�, 5,500 'f���`��' � � - Money Market 5.250 ' 1���� f� ` ������ 1.39% CAMP � ii 5�3��}� �t��'s 4';_� a 5,000 26.16/o �ttY t�r��� s � `�' 4.750 ` �'�`` ; rui r,,-��, t��t) t t0�������, , {t�1(�{ ;�,": ���,� 4.500 , � ��� 4.250 � � "'��'�# ,�s�,� � YIELD% °� �.,il��l�Sr�" ����t�'�'r '. 'f�srl,i 4 000 ' �� _ ______ ;�,��' ��i� t`� � ��ts�' LAIF 3,750 i,is�� ��� r{ + � _' 7 3 "�tt� ��i %�fk� Federal �# �� '>,����� t.rf5r,i���s 0.37% 3,500 ! � zi t� jt��������f). /�g@IIC�/ ` � ,',�t �t �.� ��t7�{,:, . ��;tt{���r;ssjz�cf7 Coupons �� ,r ,= 3.250 ''} `��� ��� 44.84% s���{i�� ' �tyit��l�§������a , �t �ss �` 4Y� i��IrF��'�Y'! i+��,f�'itrl.tit"'�,; � Y �� '�l+ �' � r`p��`� �Treasary 3.000 �a� �� � : i,� i�i�+��r��� CoupOn 2.750 � ��f��;�`��'�������' �, ., ._�.... � ,� � � ' Securities 2��� r ' ' ' � 10.54% �,�`S`�' ... ��tkt������U�t���j^1'r t 2.250 Medium Term ' ` '�} ���,,j�������r�s�r �,a = Notes 2.000 - ,t „�i��, {�� 1.750 '����'��l'�'� �� ���t.=''' $.97% � � . �y�ti , r 1,500 � � 't���i��r������� ��1�{;� � " �Inciusive ofi Demand Deposit Accounts �t ',t ,,,;r��t���)�' � ' kj��{�:_ 1.250 ��;.,�tjs�,}�,� ��,��� ' � 1�.,�A�� JAN FEB MAR APR MAY JUN JU� AUG SEP OCT NOV DEC Maturities by Fiscal Year 42.22% at December 31,2023 December 2023 � ��� These graphs depict investment activity from October �, 2023 �,Zo,000,000 �°�� through December 31, 2023. Investment activity during this period included the maturity of two Federal Agency Coupons and transfers $,00,000,000 25.61% between CAMP and the general account to accommodate cash flow �����'> ����µ needs. Portfolio yield, as depicted in the line graph, shows a �� �4$2��a consistent increase in both the city's monthly and yearly yields. 2 Yr �80,000,00o r � �6.29% and 5 Yr Treasury Markets have been declining since October 2023. t�=� �so,000,000 � ��` The effects of this investment activity on portfolio diversification, as ' depicted in the pie chart, was a decrease of 4.23 in Federal Agency � Coupons and a decrease of 1.2 in the DDA Account, which is �40,000,000 ���� � � _ primarily offset by an increase of 6.47 points in CAMP. � ,� �.os% Portfolio Liquidity as noted in the bar graph indicates the majority of �zo,000,000 ' ` 0.00% liquidity in the current year due to 2023/24 maturities. Current year �t � increased by 2.63 points, while subsequent years decreased $o � 4 respectively. 2023/24 2024/25 2025/26 2026/27 2027/28 2028/29 � I T 'r` � � --:` �ai �y pg �s GITY C}F REDDING itITY�V� REDDI�V TI'82SUt�P�S C}ffiG@ �5,- �'di"�fb�i0 �It"!c► �171t�'Ct�' 77�CypressAve ` � Redding, Redding,CA 960(I1 � A � [ � {� � fi� I ��' Portfolio Summ�ry t��o)��s-��ss , December 31, 2023 Par Market Baok °Io of ��Y��o Y'f M YTM IttVe&tments V�lu� u�gU� Value Poeffi'alio Maturity Term 3fiQ Equiv. 365 Equiv, Certificates of Deposit-Bank 3;00O,OOQ.QO 3,000,000.00 3,OO�,QOQ.d4 i.06 S32 1;826 1.Q00 1.014 Califomia Assax Management Fund 7d,205,418.15 74;245;418:15 74;2d5;4t8.�15 26,17 1 1 5:474 5:550 Medium Term Notes 2S;QOD��DO.QQ 24,081,225.00 25,422,624:51 8:97 486' 1,Bfi6 �:497 1:61$ Federa!Agency Coupon Securities 127,760;044.00 919;806,178:3Q 127,155,161.19 44:85 649 9,385 2:285 2;2gg Treasury Goupon Securities 30,OOQ,000.04 27,024;300:06 29,872,701:34 10;54 893 1;817 0:886 4.898 Municipal Bonds 1,870;Oq0.0� 1,719;483.70 1,680,147:14 0;&s 609 1;825 0:9d7 p.920 lAIF-Local Agency InvestmentFund 1,03fi,84B.99 1;49fi,648:99 1,038,848.99 4:37 i 1 3.929 3,964 Ovemigi�t Sweeps&DDAAccounts 17;028,627.&9 17,028,627,69 17;a28,B27.fi9 5.01 1 1 0.740 0:750 investment Money Market Aecaun#s 3,942,3�0.70 3;942;304.74 3;942,3Q0.70 1.39 1 1 3.813 3;fi63 283,843,195.53 271,84A,380.53 283,543,825.71 10p.QQ°do 440 994 2.801 2.840 Investments Total Earnings December 31 Month Ending Fisca!Year To Date Current Year 689,434:86 9�788,843.75 Average paily Balance 285,286,412.1$ 28Q,310,639.08 Effective Ra#e of Return 2.85°lm 2.68°Pff Pursuan#4o City of Redtling;Resalution No.97-19,this report shows idle funds invested"maturing afiinteruais during the year. fihe LAIF account offers avaiiable funds for expenditure rreeds on a samie day pasis; The City of Redding hassufficient funds 1a cover expenditures during the next 6 months. `Goverrsment Code sectians 16429.1,53601,53601,1,and 53635 HBSTORIGAL RATE UF RETURRI: FY 9l7t91 7.72 FY 97/98 6.04 FY 04/p6 3.0� FY 11/12 1:40 Fl` 18119 1.79 F'( 91l92 6.39 FY 98/99 5:61 FY 05/O8 3:64 FY 12/13 0:88 FY 19/20 1.8? FY 92/93 5.06 FY 99/QQ b.94 FY 06/07 4.59 Fti' 13l14 0.92 FY 2Q/21 4.78 FY 93194 4.59 FY 00lD1 6.31 FY D7108 4:65 FY 14l15 1,10 FY 21/22 0:73 FY 94/95 5.54 FY 01J02 4:98 FY 08/09 3:71 FY 15/16 1.10 FY 95196 5.92 FY Q2/03 4A2 FY 09/1Q 2,74 FY 16117 1:26 FY 96/97 5.90 FY D3/04 2;87 FY 10t11 1.93 FY 17/18 1;61 . ��Z>"2.�Z.t/ GREG OB NE1�f;GITY TREASURER Reporting period 12/07l2023-12A31/2423 Portfolio GBTY AG Run Date:OS/46/202A�-�15_O6 RM(PRF PM1)7:3:11 � Report Ver:7:3.11 CITY OF REDDING Portfolio Management Page 1 Interest Earnings Summary December 31, 2023 December 31Month Ending Fiscal Year To Date CD/CouponlDiscount Investments: Interest Collected 363,840.75 1,876,657.52 Plus Accrued interest at End of Period 843,963.97 843,963.97 Less Accrued Interest at Beginning of Period ( 898,662.88) ( 853,878.32) Less Accrued Interest at Purchase During Period ( 0.00) ( 0.00} Interest Earned during Period 309,141.84 1,866,743.17 Adjusted by Premiums and Discounts 8,947.97 52,762.85 Adjusted by Capital Gains or�osses 0.00 0.00 Earnings during Periods 318,089.81 1,919,506.02 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�osses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 336,653.32 2,070,073.62 Plus Accrued Interest at End of Period 358,062.66 358,062.66 Less Accrued Interest at Beginning of Period ( 323,370.93) ( 558,798.55) Interest Earned during Period 371,345.05 1,869,337.73 Total Interest Earned during Period 680,486.89 3,736,080.90 Total Adjustments from Premiums and Discounts 8,947.97 52,762.85 Total Capital Gains or�osses 0.00 0.00 Totai Earnings during Period 689,434.86 3,788,843.75 Portfolio CITY AC Run Date:05/06/2024-15:19 PM(PRF_PM6)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 1 Activity Summary December 2022 through December 2023 Yield to Maturity p�anaged Number Number Month Number of Total 360 365 Pool of Investments of Investments Average Average End Year Securities Invested Equivalent Equivalent Rate Purchased Redeemed Term Days to Maturity December 2022 63 271,028,298.50 1.933 1.959 0.000 3 1 1,103 752 January 2023 63 291,386,902.66 1.935 1.962 0.000 1 2 996 665 February 2023 61 291,359,716.55 1.973 2.000 0.000 0 1 971 623 March 2023 60 287,501,970.26 2.040 2.068 0.000 0 0 983 611 April 2023 61 286,300,240.74 2.112 2.142 0.000 1 0 994 600 May 2023 61 282,425,731.52 2.067 2.095 0.000 0 0 1,008 587 June 2023 62 294,320,518.75 2.631 2.668 0.000 1 0 967 544 Juiy 2023 62 270,815,984.45 2.516 2.551 0.000 0 0 1,051 569 August 2023 62 273,694,345.98 2.537 2.573 0.000 0 0 1,040 541 September 2023 62 271,128,413.78 2.591 2.627 0.000 0 0 1,050 525 October 2023 62 275,326,800.21 2.658 2.695 0.000 0 0 1,034 495 November 2023 62 286,405,619.03 2.844 2.883 0.000 0 0 994 456 December 2023 62 283,543,825.71 2.801 2.840 0.000 0 2 994 440 Average 62 281,941,412.93 2.357% 2.390% 0.000 0 0 1,014 570 Portfolio CITY AC Run Date:05106/2024-15:19 PM(PRF_PM4)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management l�►CtlVlt g T @ Page 1 y y Yp December 1, 2023 through December 31, 2023 Stated Transaction Purchases Redemptions CUSIP investment# Issuer Rate Date or Deposits or Withdrawals Balance Certificates of Deposit-Bank Subtotai 3,000,000.00 California Asset Management Fund (Monthly Summary) 9999 9999 PFM 5.550 665,368.35 317,094.68 Subtotai 665,368.35 317,094.68 74,205,418.15 Medium Term Notes Subtotai 25,422,620.51 Federal Agency Coupon Securities 3130ASKB4 50560 FED HOME LOAN BANK 3.350 12/29/2023 0.00 4,000,000.00 3130AU2Q6 50571 FED HOME�OAN BANK 5.000 12/19/2023 0.00 2,000,000.00 Subtotai 0.00 6,000,000.00 127,155,161.19 Treasury Coupon Securities Subtotai 29,872,701.34 Municipal Bonds Subtotai 1,880,147.14 LAIF-Local Agency Investment Fund Subtotai 1,036,848.99 Overnight Sweeps&DDA Accounts USB 9400 910 US BANK 0.750 34,565,944.70 31,796,798.88 Subtotai 34,565,944.70 31,796,798.88 17,028,627.69 Investment Money Market Accounts SYS606 606 FIVE STAR BANK 3.843 11,839.22 0.00 Subtotai 11,839.22 0.00 3,942,300.70 Total 35,243,152.27 38,113,893.56 283,543,825.71 Portfolio CITY AC Run Date:05/06/2024-15:19 PM(PRF_PM3)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 1 Portfolio Details - Investments December 31, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Date Certificates of Deposit-Bank SYS 30031 50514 REDDING BANK OF COMMERCE 09(24(2020 3,000,000.00 3,000,000.00 3,000,000.00 1.000 A 1.000 632 09/24/2025 Subtotal and Average 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 1.000 632 California Asset Management Fund 9999 9999 PFM 74,205,418.15 74,205,418.15 74,205,418.15 5.550 5.474 1 Subtotai and Average 73,868,379.11 74,205,418.15 74,205,418.15 74,205,418.15 5.474 1 Medium Term Notes . . . _ 037833BZ2 50543 APPLE 01/21/2022 5,000,000.00 4,678,450.00 5,088,215.06 2.450 AAA 1.677 946 08/04/2026 06406HCS6 50504 Bank of NY Mellon 03l17/2020 5,000,000.00 4,954,550.00 5,007,007.36 3.650 A 2.023 34 02/04/2024 24422EUE7 50505 BANK OF AMERICA 03(17(2020 5,000,000.00 4,868,900.00 5,102,062.12 3.450 A 1.647 437 03/13/2025 594918BJ2 50515 MICROSOFT 11/20/2020 5,000,000.00 4,825,050.00 5,220,709.98 3.125 AA 0.670 672 11/03/2025 89114QCK2 50513 Toronto Dominion Bank 09/15/2020 2,500,000.00 2,278,175.00 2,502,077.77 0.750 A 0.690 619 09/11l2025 91159HHG8 50508 US BANK T&C 03/23/2020 2,500,000.00 2,476,100.00 2,502,548.22 3.700 AA 2.308 29 01/30/2024 Subtotai and Average 25,436,204.10 25,000,000.00 24,081,225.00 25,422,620.51 1.497 486 Federal Agency Coupon Securities _ . 3133EM6E7 50535 FEDERAL FARM CREDIT BANK 09/28/2021 5,000,000.00 4,447,150.00 5,000,000.00 0.940 AA 0.927 1,001 09/28/2026 3133ENDC1 50538 FEDERAL FARM CREDIT BANK 11l03/2021 2,000,000.00 1,800,780.00 2,000,000.00 1.330 AAA 1.312 1,037 11/03/2026 3133ENLY4 50544 FEDERAL FARM CREDIT BANK 01(25(2022 3,000,000.00 2,946,540.00 3,000,000.00 1.040 AAA 1.026 24 01/25/2024 3133ENMQ0 50547 FEDERAL FARM CREDIT BANK 02/04/2022 3,000,000.00 2,831,370.00 2,995,967.38 1.310 AAA 1.417 399 02/03/2025 3133ENMZ0 50548 FEDERAL FARM CREDIT BANK 02/04/2022 3,000,000.00 2,925,150.00 2,999,610.27 1.200 AAA 1.235 93 04/03/2024 3133ENQV5 50550 FEDERAL FARM CREDIT BANK 03/10/2022 5,000,000.00 4,747,300.00 5,000,000.00 1.870 AA 1.844 434 03110/2025 3133ENSZ4 50553 FEDERAL FARM CREDIT BANK 04J01/2022 2,500,000.00 2,333,375.00 2,500,000.00 2.750 AAA 2.712 1,186 04/01l2027 3133EN3M0 50569 FEDERAL FARM CREDIT BANK 12/05/2022 2,000,000.00 1,984,040.00 2,003,711.11 4.625 AAA 4.353 339 12(05/2024 3130AKQ74 50520 FED HOME LOAN BANK 01/22/2021 2,500,000.00 2,255,650.00 2,500,000.00 0.625 AA 0.616 752 01/22/2026 3130AKPN0 50521 FED HOME LOAN BANK 01l29/2021 2,500,000.00 2,260,225.00 2,500,000.00 0.600 AA 0.592 759 01/29/2026 3130ALGJ7 50525 FED HOME�OAN BANK 03(23(2021 4,875,000.00 4,423,233.75 4,875,000.00 1.000 AA 0.986 812 03/23/2026 3130ALDN1 50526 FED HOME�OAN BANK 03/16/2021 5,000,000.00 4,510,900.00 5,000,000.00 0.800 AA 0.789 805 03/16/2026 3130ALXP4 50528 FED HOME LOAN BANK 04/28l2021 2,500,000.00 2,270,925.00 2,500,000.00 1.200 AA 1.184 848 04/28/2026 3130APQB4 50537 FED HOME LOAN BANK 11/23/2021 3,000,000.00 2,711,970.00 3,000,000.00 1.500 AAA 1.479 1,057 11(23/2026 3130APYK5 50540 FED HOME�OAN BANK 12/14/2021 3,000,000.00 2,813,640.00 3,000,000.00 1.150 AAA 1.134 438 03/14l2025 3130ARPB1 50556 FED HOME�OAN BANK 04/28/2022 5,000,000.00 4,763,450.00 5,000,000.00 3.500 AAA 3.452 1,213 04(28/2027 3130ARYA3 50557 FED HOME LOAN BANK 05l26/2022 3,000,000.00 2,889,720.00 3,000,000.00 4.000 AAA 3.945 1,241 05/26/2027 3130ASQP7 50561 FED HOME LOAN BANK 07l28/2022 2,000,000.00 1,959,040.00 2,000,000.00 3.625 AAA 3.575 393 01/28/2025 3130ATAH0 50567 FED HOME�OAN BANK 10(18/2022 4,000,000.00 3,960,080.00 3,992,211.76 3.640 AAA 4.563 74 03/15/2024 3130AQV26 50573 FED HOME�OAN BANK 04/13/2023 4,000,000.00 3,849,560.00 3,922,375.81 1.610 AAA 4.547 247 09/04/2024 3134GWUG9 50546 FED HOME LOAN MTG CORP 02/03l2022 735,000.00 670,415.55 722,757.76 0.570 AAA 1.542 632 09/24l2025 Portfolio CITY AC Run Date:05/06/2024-15:19 PM(PRF_PM2)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 2 Portfolio Details - Investments December 31, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Date Federal Agency Coupon Securities 3134GW6C5 50549 FED HOME�OAN MTG CORP 02(07(2022 2,000,000.00 1,768,680.00 1,945,537.59 0.800 AAA 1.785 1,031 10/28/2026 3134GXMT8 50551 FED HOME�OAN MTG CORP 03/25/2022 5,000,000.00 4,770,450.00 5,000,000.00 2.250 AAA 2.219 449 03/25/2025 3134GW6C5 50552 FED HOME LOAN MTG CORP 03/23/2022 3,000,000.00 2,653,020.00 2,862,935.44 0.800 AAA 2.488 1,031 10/28/2026 3134GXQV9 50554 FED HOME LOAN MTG CORP 04/25/2022 4,150,000.00 4,006,742.00 4,150,000.00 3.100 AAA 3.058 480 04(25/2025 3134GW4C7 50555 FED HOME�OAN MTG CORP 04/06/2022 3,000,000.00 2,653,260.00 2,841,006.22 0.800 AAA 2.775 1,030 10/27l2026 3134GXVF8 50558 FED HOME�OAN MTG CORP 06/23/2022 3,000,000.00 2,909,130.00 3,000,000.00 3.000 AAA 2.959 357 12(23/2024 3134GXYE8 50559 FED HOME LOAN MTG CORP 06/28/2022 3,000,000.00 2,941,380.00 2,994,985.00 3.100 AAA 3.407 179 06/28/2024 3134GXH56 50562 FED HOME LOAN MTG CORP 07l28/2022 3,000,000.00 2,932,740.00 3,000,000.00 4.000 AAA 3.947 513 05/28/2025 3134GXR89 50563 FED HOME�OAN MTG CORP 08(25(2022 3,000,000.00 2,910,480.00 3,000,000.00 4.375 AAA 4.315 1,332 08/25/2027 3134GY6H0 50570 FED HOME�OAN MTG CORP 12(16/2022 2,000,000.00 1,984,200.00 2,002,676.39 5.500 AAA 5.351 715 12/16/2025 3136G4S61 50511 FEDERAL NATL MTG ASSN 08/25l2020 5,000,000.00 4,582,750.00 5,000,000.00 0.660 AA 0.651 602 08/25/2025 3135GA3W9 50516 FEDERAL NATL MTG ASSN 11/25/2020 2,500,000.00 2,27Q725.00 2,500,000.00 0.600 AA 0.592 694 11(25/2025 3135GA3Z2 50517 FEDERAL NAT�MTG ASSN 11/25/2020 2,500,000.00 2,270,725.00 2,500,000.00 0.600 AA 0.592 694 11/25l2025 3135GA5R8 50518 FEDERAL NATL MTG ASSN 12/18/2020 5,000,000.00 4,524,700.00 5,000,000.00 0.625 AA 0.616 717 12(18/2025 3135G06G3 50519 FEDERAL NATL MTG ASSN 01/19/2021 5,000,000.00 4,555,400.00 5,000,820.55 0.500 AA 0.484 676 11/07/2025 3135G06V0 50564 FEDERAL NATL MTG ASSN 09l16/2022 3,000,000.00 2,930,970.00 2,988,616.53 4.125 AAA 4.311 605 08/28/2025 3135G03U5 50566 FEDERAL NAT�MTG ASSN 10(18/2022 3,000,000.00 2,794,350.00 2,856,949.38 0.625 AAA 4.459 477 04/22/2025 3135GADU2 50572 FEDERAL NAT�MTG ASSN 01/26/2023 3,000,000.00 2,991,960.00 3,000,000.00 5.000 AAA 4.932 25 01/26/2024 Subtotal and Average 131,913,428.92 127,760,000.00 119,806,176.30 127,155,161.19 2.265 649 Treasury Coupon Securities 91282CBQ3 50522 TREASURY NOTE 03/01/2021 5,000,000.00 4,514,450.00 4,977,032.53 0.500 0.707 789 02/28l2026 91282CBQ3 50523 TREASURY NOTE 03/08/2021 5,000,000.00 4,514,450.00 4,968,128.61 0.500 0.791 789 02(28/2026 91282CBT7 50527 TREASURY NOTE 03/31/2021 2,000,000.00 1,815,160.00 1,992,702.63 0750 0.904 820 03/31/2026 91282CBW0 50530 TREASURY NOTE 05l13/2021 5,000,000.00 4,521,900.00 4,988,279.10 0.750 0.841 850 04/30/2026 91282CCW9 50534 TREASURY NOTE 08(31/2021 5,000,000.00 4,476,350.00 4,988,343.72 0.750 0.828 973 08/31/2026 91282CCW9 50536 TREASURY NOTE 09/28/2021 5,000,000.00 4,476,350.00 4,969,559.93 0.750 0.971 973 08/31/2026 91282CDQ1 50541 TREASURY NOTE 01/05/2022 3,000,000.00 2,705,640.00 2,988,654.82 1.250 1.362 1,095 12/31l2026 Subtotal and Average 29,870,514.06 30,000,000.00 27,024,300.00 29,872,701.34 0.886 893 Municipal Bonds 35981VAZ3 50512 FU�LERTON REDEVELOPMENTAGENCY 09/02/2020 1,870,000.00 1,719,483.70 1,880,147.14 1.221 AA 0.907 609 09(01/2025 Subtotai and Average 1,880,384.46 1,870,000.00 1,719,483.70 1,880,147.74 0.907 609 LAIF-Local Agency Investment Fund 1000 601 STATE OF CALIF POOL 04/01/2013 1,036,848.99 1,036,848.99 1,036,848.99 3.929 3.929 1 Subtotal and Average 1,036,848.99 1,036,848.99 1,036,848.99 1,036,848.99 3.929 1 Portfolio CITY AC Run Date:05/06/2024-15:19 PM(PRF_PM2)7.3.11 CITY OF REDDING Portfolio Management Page 3 Portfolio Details - Investments December 31, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Date Overnight Sweeps&DDA Accounts USB 9400 910 US BANK 07(01/2019 17,028,627.69 17,028,627.69 17,028,627.69 0.750 0.740 1 Subtotai and Average 14,348,809.15 17,028,627.69 17,028,627.69 17,028,627.69 0.740 1 Investment Money Market Accounts SYS609 609 CORNERSTONE BANK 08/01/2013 250,000.00 25Q000.00 250,000.00 1.000 0.986 1 SYS606 606 FIVE STAR BANK 06/30/2013 3,692,300.70 3,692,300.70 3,692,300.70 3.843 3.790 1 SYS608 608 FIVE STAR BANK 06/30/2013 0.00 0.00 0.00 2.624 2.588 1 Subtotai and Average 3,930,843.39 3,942,300.70 3,942,300.70 3,942,300.70 3.613 1 Total and Average 285,285,412.18 283,843,195.53 271,844,380.53 283,543,825.71 2.801 440 Portfolio CITY AC Run Date:05/06/2024-15:19 PM(PRF_PM2)7.3.11 City of Redding Earnin s Histo $soo,0oa � � � � �700,000 $600,000 � $500,000 ;,_ ts��. �,.t �. $400,000 - -- -- �,: n,� �. � � M M � r�� � � � � rn $300,000 � — � N M °' � �- - o � � � �,i.. .�,� � �� .O LL � t0 .�O M � � � � � � Vi, � �..1. �„ ��.� � �.N tD �. �!f �:t0 �!f ��. � iH ,: Vi � $ZOO;OOO ^ � °' O ~ � � � ' � � � �' qy �.O 1tJ �: O �N � � N ..0 � �: �� � ��� � � N �..1� �I' �. 7 iH fg �. ; �. � ' � o � �o in M y} �' ' �, k : � Y�t �o � '��.M M , � tA' �. ,���' ,�t5 �aI � $100,000 m � �" N�� � w +� ,< �,}z. °ti�� _ N � N � �� � � `��c1 cG,c ��� �� �� J`� ���. �,Q� o�ae� �,a�� �,a�� �m� t��� �c,'� Q�`', a� �� ,�,�� ' o��`' ��°e �a�'�' �'oe� �'oe� ��,�o � t`� cD �� � J� �.e �w �� c,� a�. z� �S� �Q- �` �.� �y ��o, e�,�e p��, o�e e�e o��, ory`L��p`y`L���,q' ���,`l' '�p�,� o�`LQ'�c�e�`a��,� ��� �Oe orLn��o��� Qry"� �4�' �o`L3 �O`L3 �Or�' oy"� �� ory� �� �O ry `L `L �yp`L �, �p`L �p`L �, �y `L `L �,p`L +y �,p`L �,p`L City of Redding ' Book Value Histo $300;0OO,OdO ���� $295,000,000 '; $290,000,000 ' �� $285,000,000 �� `��`��� � � ;�,i�s, �e a ���� $280,000,000 � {'`�'� ���T,� ��� �r,.ar, � M i � tn � � � R C �`�'``l;f', Cg . t�+,,," , $275,00�,�0� � � � N � M � � M �. M : � ��.: �.�C� �.' :.��. .:tn :0�0 �� �' ���. � �� � I � � � ry, ,(�,sr..e O :!'j , $Z7O,000,000 ' ^} N N ;__ ti �_ M _ _ N . � _ t; ,, —__ _ � �' d, ; .. �., t�i5 . � � � N. N , ��.y ��;�„ � � � � M, $265,000,000 � . � � - � c00•t --- ,cr'�- rn a�o" M `� N � N ;#ri � t# 4,`�'�2 t0 N :�Y " 4A �� rl' O � � t ai: , OD t+'! � h- 3'}< 4. �" b t� r t,i � � �,'`k, $260,000,000 � n ri. R � $255,000,000 � t ' p�i � l C ,e�,�'e ���,pe ����� e�i��c1 �`u,� P��� ��� ���� ,J�� J�Jy�. ���.Q G���,� ,��,ae Ge�,oe �°' oe 3� �� `�� o`�� ti`� ti`� oti� 3� 5e� 3� �° O�' ti��� ti��� �a� ��� ��� � �o �o � ��� ti��� ��� ti��� ti��� � � � � � � w ,.'� �� CITY OF REDDING CITY OF REDDING Treasurer's ottice Received Interest 777 Cypress Ave Redding, Redding,CA 96001 � � � � � � � � � SOt"t@C� b�/ �SSU@C (530)225-4199 ' ° Received December 1, 2023 - December 31, 2023 Security Par Current Interest Issuer CUSIP Investment# Type Value Rate Date Due Date Received Amount Due Amount Received Variance FEDERA�FARM CREDIT BANK 3133EN3M0 50569 FAC 2,000,000.00 4.625 12(05/2023 12/05/2023 46,250.00 46,250.00 - Subtotal 46,250.00 46,250.00 FED HOME LOAN BANK 3130APYK5 50540 FAC 3,000,000.00 1.150 12/14/2023 12/14/2023 17,250.00 17,250.00 - 3130AU2Q6 50571 FAC 0.00 5.000 12/19l2023 12/19/2023 50,000.00 50,000.00 - 3130ASKB4 50560 FAC 0.00 3.350 12/29l2023 12/29/2023 67,000.00 67,000.00 - S u btot a I 134,2 50.00 134,250.0 0 FED HOME LOAN MTG CORP 3134GY6H0 50570 FAC 2,000,000.00 5.500 12/16/2023 12l16/2023 55,000.00 55,000.00 - 3134GXVF8 50558 FAC 3,000,000.00 3.000 12/23/2023 12/23/2023 45,000.00 45,000.00 - 3134GXYE8 50559 FAC 3,000,000.00 3.100 12/2812023 12/28/2023 46,500.00 46,500.00 - Subtotal 146,500.00 146,500.00 FEDERAL NATL MTG ASSN 3135GA5R8 50518 FAC 5,000,000.00 0.625 12/18/2023 12l18l2023 15,625.00 15,625.00 - Subtotal 15,625.00 15,625.00 REDDING BANK OF COMMERCE SYS 30031 50514 BCD 3,000,000.00 1.000 12(24/2023 12/24/2023 2,500.00 2,465.75 -34.25 Subtotal 2,500.00 2,465.75 TREASURY NOTE 91282CDQ1 50541 TRC 3,000,000.00 1.250 12(31l2023 12/31/2023 18,750.00 18,750.00 - S u btot a I 18,7 50.00 18,750.0 0 Totai 363,875.00 363,840.75 Totai Cash Overpayment 0.00 Total Cash Shortfall -34.25 Portfolio CITY AC Run Date:05/06/2024-15:15 RI(PRF_RI)7.3.11 Report Ver.7.3.11 CITY OF REDDING Received Interest Received December 1,2023-December 31,2023 Page 2 Security Par Current Interest issuer CUSIP Investment# Type Value Rate Date Received Amount Received Cash Accounts PFM 9999 9999 PA1 73,857,144.48 5.550 12/01/2023 317,094.68 Subtotal 317,094.68 CORNERSTONE BANK SYS609 609 RR4 250,000.00 1.000 12/31/2023 212.33 Subtotal 212.33 FIVE STAR BANK SYS606 606 RR4 3,680,461.48 3.843 12/31/2023 11,839.22 Subtotal 11,839.22 US BANK U5B 9400 910 RR3 14,259,481.87 0.750 12/31/2023 7,507.09 Subtotal 7,507.09 Totai 336,653.32 PortFolio CITY AC Run Date:05/06/2024-15:18 RI(PRF_RI)7.3.11 Report Ver.7.3.11 � � � � � � ��-�,'. ��°���� CITY OF REDDING , � CITY OF REDDING Treasurer's ottice Interest Earnings 777CypressAve Redding, Redding,CA 96001 � � � � � �� � � �� � '� � Sorted by Fund - Fund �s3o�2z5-4�ss ' December 1, 2023 - December 31, 2023 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund:OTHER 9999 9999 050 PA1 74,205,418.15 73,857,144.48 74,205,418.15 5.550 5.552 348,273.67 0.00 348,273.67 1000 601 050 RRP 1,036,848.99 1,036,848.99 1,036,848.99 3.929 3.989 3,512.74 0.00 3,512.74 SYS606 606 050 RR4 3,692,300.70 3,680,461.48 3,692,300.70 3.843 3.787 11,839.22 0.00 11,839.22 SYS609 609 050 RR4 250,000.00 250,000.00 250,000.00 1.000 1.000 212.33 0.00 212.33 USB 9400 910 050 RR3 17,028,627.69 14,259,481.87 17,028,627.69 0.750 0.620 7,507.09 0.00 7,507.09 Subtotal 96,213,195.53 93,083,936.82 96,213,195.53 4.697 371,345.05 0.00 371,345.05 Fund:POOLED CASH 91282CDQ1 50541 100 TRC 3,000,000.00 2,988,333.63 2,988,654.82 12/31/2026 1.250 1.372 3,160.09 321.19 3,481.28 91282CCW9 50534 100 TRC 5,OOQ000.00 4,987,972.34 4,988,343.72 08/31/2026 0.750 0.842 3,193.68 371.38 3,565.06 91282CBQ3 50523 100 TRC 5,000,000.00 4,966,876.38 4,968,128.61 02/28l2026 0.500 0.802 2,129.12 1,252.23 3,381.35 91282CBT7 50527 100 TRC 2,000,000.00 1,992,426.75 1,992,702.63 03/31(2026 0.750 0.914 1,270.50 275.88 1,546.38 91282CBQ3 50522 100 TRC 5,000,000.00 4,976,130.14 4,977,032.53 02(28l2026 0.500 0717 2,129.12 902.39 3,031.51 91282CBW0 50530 100 TRC 5,000,000.00 4,987,851.63 4,988,279.10 04/30/2026 0.750 0.855 3,193.68 427.47 3,621.15 91282CCW9 50536 100 TRC 5,000,000.00 4,968,590.10 4,969,559.93 08/31/2026 0.750 0.987 3,193.68 969.83 4,163.51 24422EUE7 50505 100 MTN 5,000,000.00 5,109,149.77 5,102,062.12 03/13/2025 3.450 1.679 14,375.00 -7,087.65 7,287.35 SYS 30031 50514 100 BCD 3,000,000.00 3,000,000.00 3,000,000.00 09/24/2025 1.000 1.014 2,583.33 0.00 2,583.33 3135G06G3 50519 100 FAC 5,OOQ000.00 5,000,857.51 5,OOQ820.55 11/07l2025 0.500 0.482 2,083.33 -36.96 2,046.37 3135GA3Z2 50517 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 11/25l2025 0.600 0.589 1,250.00 0.00 1,250.00 3135GA5R8 50518 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 12/18(2025 0.625 0.613 2,604.16 0.00 2,604.16 3136G4S61 50511 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 08/25/2025 0.660 0.648 2,750.00 0.00 2,750.00 3135GA3W9 50516 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 11/25/2025 0.600 0.589 1,250.00 0.00 1,250.00 3135GADU2 50572 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 01/26/2024 5.000 4.906 12,500.00 0.00 12,500.00 3135G06V0 50564 100 FAC 3,000,000.00 2,988,044.49 2,988,616.53 08/28/2025 4.125 4.289 10,312.50 572.04 10,884.54 3135G03U5 50566 100 FAC 3,000,000.00 2,847,837.88 2,856,949.38 04/22/2025 0.625 4.413 1,562.50 9,111.50 10,674.00 3130APYK5 50540 100 FAC 3,OOQ000.00 3,000,000.00 3,OOQ000.00 03/14/2025 1.150 1.128 2,875.00 0.00 2,875.00 3130ASKB4 50560 100 FAC 0.00 4,000,000.00 0.00 12/29l2023 3.350 3.397 10,422.22 0.00 10,422.22 3130AQV26 50573 100 FAC 4,000,000.00 3,912,792.57 3,922,375.81 09/04(2024 1.610 4.499 5,366.67 9,583.24 14,949.91 3130AU2Q6 50571 100 FAC 0.00 2,OOQ190.00 0.00 12(19l2023 5.000 4.876 5,000.00 -190.00 4,810.00 3130ATAH0 50567 100 FAC 4,OOQ000.00 3,989,054.36 3,992,211.76 03/15/2024 3.640 4.513 12,133.33 3,157.40 15,290.73 3130ARYA3 50557 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 05/26/2027 4.000 3.925 10,000.00 0.00 10,000.00 3130ASQP7 50561 100 FAC 2,000,000.00 2,000,000.00 2,000,000.00 01/28/2025 3.625 3.557 6,041.67 0.00 6,041.67 Portfolio CITY AC Run Date:05/06/2024-1532 IE(PRF_IE)7.3.11 Report Ver.7.3.11 CITY OF REDDING Interest Earnings Page 2 December 1,2023-December 31,2023 Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund:POOLED CASH 3130ARPB1 50556 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 04/28/2027 3.500 3.434 14,583.33 0.00 14,583.33 3130APQB4 50537 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 11/23/2026 1.50� 1.472 3,750.00 0.00 3,750.00 3130ALGJ7 50525 100 FAC 4,875,000.00 4,875,000.00 4,875,000.00 03/23/2026 1.000 0.981 4,062.50 0.00 4,062.50 3130AKPN0 50521 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 01/29/2026 0.600 0.589 1,250.00 0.00 1,250.00 3130AKQ74 50520 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 01/22l2026 0.625 0.613 1,302.08 0.00 1,302.08 3130ALDN1 50526 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03/16/2026 0.800 0.785 3,333.34 0.00 3,333.34 3130ALXP4 50528 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 04/28/2026 1.200 1.177 2,500.00 0.00 2,500.00 3133ENSZ4 50553 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 04/0112027 2.750 2.698 5,729.17 0.00 5,729.17 3133EN3M0 50569 100 FAC 2,000,000.00 2,004,044.44 2,003,711.11 12(05/2024 4.625 4.333 7,708.34 -333.33 7,375.01 3133ENDC1 50538 100 FAC 2,000,000.00 2,OOQ000.00 2,000,000.00 11/03(2026 1.33� 1.305 2,216.67 0.00 2,216.67 3133ENQV5 50550 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03/10/2025 1.870 1.835 7,791.67 0.00 7,791.67 3133EM6E7 50535 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 09/28/2026 0.940 0.922 3,916.67 0.00 3,916.67 3133ENMZ0 50548 100 FAC 3,000,000.00 2,999,483.18 2,999,610.27 04/03/2024 1.200 1.228 3,000.00 127.09 3,127.09 3133ENLY4 50544 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 01/25/2024 1.040 1.020 2,600.00 0.00 2,600.00 3133ENMQ0 50547 100 FAC 3,000,000.00 2,995,658.76 2,995,967.38 02/03/2025 1.310 1.409 3,275.00 308.62 3,583.62 3134GW6C5 50549 100 FAC 2,000,000.00 1,943,931.03 1,945,537.59 10/2812026 0.800 1.781 1,333.33 1,606.56 2,939.89 3134GXH56 50562 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 05/28/2025 4.000 3.925 10,000.00 0.00 10,000.00 3134GY6H0 50570 100 FAC 2,000,000.00 2,002,790.28 2,002,676.39 12l16(2025 5.50� 5.322 9,166.66 -113.89 9,052.77 3134GXR89 50563 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 08(25/2027 4.375 4.293 10,937.50 0.00 10,937.50 3134GXYE8 50559 100 FAC 3,000,000.00 2,994,135.00 2,994,985.00 06/28/2024 3.100 3.382 7,750.00 850.00 8,600.00 3134GXVF8 50558 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 12/23/2024 3.000 2.944 7,500.00 0.00 7,500.00 3134GWUG9 50546 100 FAC 735,000.00 722,168.25 722,757.76 09/24/2025 0.570 1.530 349.13 589.51 938.64 3134GW4C7 50555 100 FAC 3,000,000.00 2,836,311.52 2,841,006.22 10/27/2026 0.800 2.779 2,000.00 4,694.70 6,694.70 3134GXQV9 50554 100 FAC 4,150,000.00 4,150,000.00 4,150,000.00 04/2512025 3.100 3.042 10,720.83 0.00 10,720.83 3134GW6C5 50552 100 FAC 3,000,000.00 2,858,892.24 2,862,935.44 10/28/2026 0.800 2.489 2,000.00 4,043.20 6,043.20 3134GXMT8 50551 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03l25(2025 2.25� 2.208 9,375.00 0.00 9,375.00 91159HHG8 50508 100 MTN 2,500,000.00 2,505,184.30 2,502,548.22 01/30/2024 3.700 2.384 7,708.33 -2,636.08 5,072.25 5949186J2 50515 100 MTN 5,000,000.00 5,230,711.95 5,220,709.98 11/03/2025 3.125 0.680 13,020.83 -10,001.97 3,018.86 037833BZ2 50543 100 MTN 5,000,000.00 5,091,051.56 5,088,215.06 08/04l2026 2.450 1.705 10,208.33 -2,836.50 7,371.83 06406HCS6 50504 100 MTN 5,000,000.00 5,013,377.69 5,007,007.36 02/04/2024 3.650 2.076 15,208.33 -6,370.33 8,838.00 89114QCK2 50513 100 MTN 2,500,000.00 2,502,179.96 2,502,077.77 09/11/2025 0.750 0.687 1,562.50 -102.19 1,460.31 35981VAZ3 50512 100 MUN 1,870,000.00 1,880,654.50 1,880,147.14 09/0112025 1.221 0.874 1,902.72 -507.36 1,395.36 Subtotal 187,630,000.00 193,321,682.21 187,330,630.18 1.950 309,141.84 8,947.97 318,089.81 Total 283,843,195.53 286,405,619.03 283,543,825.71 2.846 680,486.89 8,947.97 689,434.86 Portfolio CITY AC Run Date:05/06/2024-15:32 IE(PRF_IE)7.3.11 Report Ver.7.3.11 � � � � � � �, ���� CITY OF REDDING CITY OF REDDING Treasurer's ottice Amortization Schedule 777 Cypress Ave � � � � � � � � Redding, Redding,CA 96001 , � December 1, 2023 - December 31, 2023 (530)225-4199 Sorted By Security Type - Fund Investment# Maturity Date Beginning Par Value Amounts Amortized - Purchase Original Premium Ending qnd Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Value As of 12101/2023 This Period Through 12/31/2023 Through 12/31/2023 Medium Term Notes 50543 100 08/04/2026 5,000,000.00 5,154,400.00 154,400.00 5,088,215.06 -63,348.44 -2,836.50 -66,184.94 88,215.06 APPLE 2.450 91,051.56 50504 100 02/04/2024 5,000,000.00 5,296,645.00 296,645.00 5,007,007.36 -283,267.31 -6,370.33 -289,637.64 7,007.36 Bank of NY Mellon 3.650 13,377.69 50505 100 03(13/2025 5,000,000.00 5,424,313.81 424,313.81 5,102,062.12 -315,164.04 -7,087.65 -322,251.69 102,062.12 BANK OF AMERICA 3.450 109,149.77 50515 100 11l03/2025 5,000,000.00 5,594,450.00 594,450.00 5,220,709.98 -363,738.05 -10,001.97 -373,740.02 220,709.98 MICROSOFT 3.125 230,711.95 50513 100 09/11/2025 2,500,000.00 2,506,117.50 6,117.50 2,502,077.77 -3,937.54 -102.19 -4,039.73 2,077.77 Toronto Dominion Bank 0.750 2,179.96 50508 100 01/30/2024 2,500,000.00 2,621,875.00 121,875.00 2,502,548.22 -116,690.70 -2,636.08 -119,326.78 2,548.22 US BANK T&C 3.700 5,184.30 Subtotal 26,597,801.31 1,597,801.31 25,422,620.51 -1,146,146.08 -29,034.72 -1,175,180.80 422,620.51 451,655.23 Federal Agency Coupon Securities 50547 100 02/03/2025 3,000,000.00 2,988,900.00 -11,100.00 2,995,967.38 6,758.76 308.62 7,067.38 -4,032.62 FEDERAL FARM CREDIT BANK 1.310 -4,341.24 50548 100 04/03/2024 3,000,000.00 2,996,700.00 -3,300.00 2,999,610.27 2,783.18 127.09 2,910.27 -389J3 FEDERAL FARM CREDIT BANK 1.200 -516.82 50569 100 12/05/2024 2,000,000.00 2,008,000.00 8,000.00 2,003,711.11 -3,955.56 -333.33 -4,288.89 3,711.11 FEDERAL FARM CREDIT BANK 4.625 4,044.44 50567 100 03/15/2024 4,000,000.00 3,946,640.00 -53,360.00 3,992,211.76 42,414.36 3,157.40 45,57176 -7,788.24 FED HOME�OAN BANK 3.640 -10,945.64 50571 100 12/19/2023 2,000,000.00 2,003,800.00 3,800.00 0.00 -3,610.00 -190.00 -3,800.00 0.00 FED HOME�OAN BANK 5.000 190.00 50573 100 09(04(2024 4,000,000.00 3,839,960.00 -160,040.00 3,922,375.81 72,832.57 9,583.24 82,415.81 -77,624.19 FED HOME LOAN BANK 1.610 -87,207.43 50546 100 09l24/2025 735,000.00 709,238.25 -25,761.75 722,757.76 12,930.00 589.51 13,519.51 -12,242.24 FED HOME�OAN MTG CORP 0.570 -12,831.75 50549 100 10/28/2026 2,000,000.00 1,908,908.00 -91,092.00 1,945,537.59 35,023.03 1,606.56 36,629.59 -54,462.41 FED HOME�OAN MTG CORP 0.800 -56,068.97 50552 100 10/28/2026 3,000,000.00 2,776,950.00 -223,050.00 2,862,935.44 81,942.24 4,043.20 85,985.44 -137,064.56 FED HOME LOAN MTG CORP 0.800 -141,107.76 50555 100 10/27/2026 3,000,000.00 2,743,200.00 -256,800.00 2,841,006.22 93,111.52 4,69470 97,806.22 -158,993.78 FED HOME�OAN MTG CORP 0.800 -163,688.48 Portfolio CITY AC Run Date:05/06/2024-15:30 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 CITY OF REDDING Amortization Schedule Page 2 December 1,2023-December 31,2023 investment# Maturity Date Beginning Par Value Amounts Amortized - - - - - Purchase Original Premium Ending And Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Vaiue As of 12101/20?3 This Period Through 12/31/2023 Through 12/31/2023 Federal Agency Coupon Securities 50559 100 06/28/2024 3,000,000.00 2,979,600.00 -20,400.00 2,994,985.00 14,535.00 850.00 15,385.00 -5,015.00 FED HOME�OAN MTG CORP 3.100 -5,865.00 50570 100 12/16/2025 2,000,000.00 2,004,100.00 4,100.00 2,002,676.39 -1,309.72 -113.89 -1,423.61 2,676.39 FED HOME LOAN MTG CORP 5.500 2,790.28 50519 100 11/07/2025 5,000,000.00 5,002,129.00 2,129.00 5,000,820.55 -1,271.49 -36.96 -1,308.45 820.55 FEDERAL NAT�MTG ASSN 0.500 857.51 50564 100 08(28/2025 3,000,000.00 2,979,750.00 -20,250.00 2,988,616.53 8,294.49 572.04 8,866.53 -11,383.47 FEDERAL NATL MTG ASSN 4.125 -11,955.51 50566 100 04l22t2025 3,000,000.00 2,725,440.00 -274,560.00 2,856,949.38 122,397.88 9,111.50 131,509.38 -143,050.62 FEDERAL NAT�MTG ASSN 0.625 -152,162.12 Subtotal 41,613,315.25 -1,121,684.75 40,130,161.19 482,876.26 33,969.68 516,845.94 -604,838.81 -638,808.49 Treasury Coupon Securities 50522 100 02/28/2026 5,000,000.00 4,946,875.00 -53,125.00 4,977,032.53 29,255.14 902.39 30,157.53 -22,967.47 TREASURY NOTE 0.500 -23,869.86 50523 100 02/28/2026 5,000,000.00 4,926,562.50 -73,437.50 4,968,128.61 40,313.88 1,25223 41,566.11 -31,871.39 TREASURY NOTE 0.500 -33,123.62 50527 100 03/31/2026 2,000,000.00 1,983,750.00 -16,250.00 1,992,702.63 8,676.75 275.88 8,952.63 -7,297.37 TREASURY NOTE 0.750 -7,573.25 50530 100 04/30/2026 5,000,000.00 4,975,000.00 -25,000.00 4,988,279.10 12,851.63 427.47 13,279.10 -11,720.90 TREASURY NOTE 0.750 -12,148.37 50534 100 08/31/2026 5,000,000.00 4,978,125.00 -21,875.00 4,988,343.72 9,847.34 371.38 10,218.72 -11,656.28 TREASURY NOTE 0.750 -12,027.66 50536 100 08/31/2026 5,000,000.00 4,943,750.00 -56,250.00 4,969,559.93 24,840.10 969.83 25,809.93 -30,440.07 TREASURY NOTE 0.750 -31,409.90 50541 100 12/31/2026 3,000,000.00 2,981,132.81 -18,867.19 2,988,654.82 7,200.82 321.19 7,522.01 -11,345.18 TREASURY NOTE 1.250 -11,666.37 Suhtotal 29,735,195.31 -264,804.69 29,872,701.34 132,985.66 4,520.37 137,506.03 -127,298.66 -131,819.03 Municipal Bonds 50512 100 09/01/2025 1,870,000.00 1,897,414.20 27,414.20 1,880,147.14 -16,759.70 -507.36 -17,267.06 10,147.14 FU�LERTON REDEVELOPMENT 1.221 10,654.50 Subtotal 1,897,414.20 27,414.20 1,880,147.14 -16,759.70 -507.36 -17,267.06 10,147.14 10,654.50 Totai 99,843,726.07 238,726.07 97,305,630.18 -547,043.86 8,947.97 -538,095.89 -299,369.82 -308,317.79 Portfolio CITY AC Run Date:05/06/2024-1530 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 � ITY � � �=+� GfTY OF REQDING � - �y� C,ITY C3F REDDING ENTITIES T�easure�'s otece `� 777 Gypress Aue . .' Pottfofio Man�tgement ��ad��g; �ea���g:cassao� � � L 1' � � � �I I "� Porfifolio Summary (sso�zz�-a,ss °' December 3°1, 2023 pa� Markef Book °la o$ beyS to YTM YTM investments vatue Value Value Portfolin Term Maturity 3GtI'Equiv. 365 Equiv: FSSEscrowAccount 214,620.36 2id,624.38 214;82D;38 2.19 1 1 0,010 A.010 Successor Agency,MM Account 588;776.99 588,776:89 b88.776:99 6:00 1 1 0.838 b:85d LAIF-Loca!AgencyJnveStmeni Fund 5,694;613.19 S;fi94;613.19 5,694;613:19 57i98 1 1 3:929 3:984 Ovemight Sweeps-&DDR Accounts 3.322,9A7A5 3,322,947:05 3,322,947:05 33:84 1 1 0.591 0.599 8.82Q,957.61 9,$2Q957.61 9,820,957.61 1Q0.4Q°lo 1 1 g.529 2.564 Investments Tota1 Earnings December 31 Manth Ending Fiscal Year To Date Current Year 2Q,T72.Q1 123,556:23 Average aaify Balance 9,533,452,.84 9,357,092'.26 Effective Rate of Return 2.57°la 2.62°la �� �l ��� GREG R B ETT,CiTY TREASURER Reporting peri4d 12l01/2Q23-12l31/2023 Por[folio ENTY CP Run Date:05114/2624-9fi;15- RM{PRF_PM1}7.3.11 Report Ver.7.3:t1 CITY OF REDDING ENTITIES Portfolio Management Page 1 Interest Earnings Summary December 31, 2023 December 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 �ess Accrued Interest at Beginning of Period ( 0.00) ( 0.00) �ess Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 �ess Accrued Interest at Beginning of Period ( 0.00) ( 0.00) �ess 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 1,441.01 120,511.50 Plus Accrued Interest at End of Period 59,587.47 59,587.47 �ess Accrued Interest at Beginning of Period ( 40,256.47) ( 56,542.74) Interest Earned during Period 20,772.01 123,556.23 Total Interest Earned during Period 20,772.01 123,556.23 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 20,772.01 123,556.23 Portfolio ENTY CP Run Date:05/10/2024-16:15 PM(PRF_PM6)7,3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Activity Summary December 2022 through December 2023 Yieid to Maturity Managed Number Number Month Number of Total 360 365 Pool of Investments of Investments Average Average End Year Securities Invested Equivaient Equivaient Rate Purchased Redeemed Term Days to Maturity December 2022 7 9,356,531.33 1.475 1.496 0.000 0 0 1 1 January 2023 8 9,541,879.98 1.918 1.945 0.000 1 0 1 1 February 2023 8 9,582,454.67 2.043 2.071 0.000 0 0 1 1 March 2023 8 9,527,732.76 2.201 2.231 0.000 0 0 1 1 April 2023 8 9,455,553.26 2.251 2.282 0.000 0 0 1 1 May 2023 8 10,153,765.38 2.212 2.242 0.000 0 0 1 1 June 2023 8 9,833,667.42 2.387 2.420 0.000 0 0 1 1 July 2023 8 10,265,149.97 2.418 2.451 0.000 0 0 1 1 August 2023 8 8,428,358.46 2.681 2.718 0.000 0 0 1 1 September 2023 8 9,251,795.92 2.385 2.418 0.000 0 0 1 1 October 2023 8 9,447,318.50 2.447 2.481 0.000 0 0 1 1 November 2023 8 9,523,869.35 2.535 2.570 0.000 0 0 1 1 December 2023 8 9,820,957.61 2.529 2.564 0.000 0 0 1 1 Average 8 9,553,002.66 2.268% 2.299% 0.000 0 0 1 1 Portfolio ENTY CP Run Date:05/10/2024-16:15 PM(PRF_PM4)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Activity By Type December 1, 2023 through December 31, 2023 Beginning Stated Transaction Purchases Redemptions Ending CUSIP Investment# Issuer Balance Rate Date or Deposits or Withdrawals Balance FSS Escrow Account (Monthly Summary) 9442 5201 US BANK FSS ESCROW 0.010 7,506.30 43,805.23 Subtotal 250,919.31 7,506.30 43,805.23 214,620.38 Successor Agency MM Account (Monthly Summary) SYS6002 6002 US BANK SUCCESSOR AGENCY 0.850 7,378.38 81.48 Subtotal 581,480.09 7,378.38 81.48 588,776.99 LAIF-Local Agency Investment Fund Subtotai 5,694,613.19 5,694,613.19 Overnight Sweeps&DDA Accounts SYS5002 5002 US BANK HOUSING AUTHORITY 0.600 1,102,700.90 1,070,910.08 SYS 7002 7002 US BANK RABA 0.600 839,832.12 545,532.65 Subtotai 2,996,856.76 1,942,533.02 1,616,442.73 3,322,947.05 Totai 9,523,869.35 1,957,417.70 1,660,329.44 9,820,957.61 Portfolio ENTY CP Run Date:O5/10/2024-16:15 PM(PRF_PM3)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Portfolio Details - Investments December 31, 2023 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Vaiue Rate N�oody's 365 Maturity Date FSS Escrow Account 9442 5201 US BANK FSS ESCROW 214,620.38 214,620.38 214,620.38 0.010 0.010 1 Subtotai and Average 249,748.38 214,620.38 214,620.38 214,620.38 0.010 1 Successor Agency MM Account SYS6002 6002 US BANK SUCCESSOR AGENCY 588,776.99 588,776.99 588,776.99 0.850 0.850 1 Subtotai and Average 581,715.47 588,776.99 588,776.99 588,776.99 0.850 1 LAIF-Local Agency Investment Fund SYS6000 6000 LAIF-COR-Successor to RRA 04/01/2013 4,066,215.65 4,066,215.65 4,066,215.65 3.929 3.984 1 SYS7000 7000 Local Agency I�v Fund RABA 04/01/2013 629,131.15 629,131.15 629,131.15 3.929 3.984 1 SYS5000 5000 Local Agency Inv Fund Housing 04/01/2013 999,266.39 999,266.39 999,266.39 3.929 3.984 1 Subtotai and Average 5,694,613.19 5,694,613.19 5,694,613.19 5,694,613.19 3.984 1 Overnight Sweeps&DDA Accounts SYS 7003 Cornersto�e Bank RABA Punch 01l01/2023 6,216.10 6,216.10 6,216.10 0.000 1 SYS5002 5002 US BANK HOUSING AUTHORITY 07/01(2019 1,826,246.00 1,826,246.00 1,826,246.00 0.600 0.600 1 SYS 7002 7002 US BANK RABA 07/01/2019 1,490,484.95 1,490,484.95 1,490,484.95 0.600 0.600 1 Subtotai and Average 3,007,375.80 3,322,947.05 3,322,947.05 3,322,947.05 0.599 1 Total and Average 9,533,452.84 9,820,957.61 9,820,957.61 9,820,957.61 2.564 1 Portfolio ENTY CP Run Date:05/10/2024-16:15 PM(PRF_PM2)7.3.11 Report Ver.7.3.11 � � � � � � � •�`���� CITY OF REDDING � ` CITY OF REDDING ENTITIES Treasurer's office Interest Earnings 777 Cypress Ave Redding, Redding,CA 96001 � � � � � � � � 1 � Sorted by Fund - Fund (530)225-4199 December 1, 2023 - December 31, 2023 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Vaiue Book Value Book Value Date Rate Yieid Earned Accretion Earnings Fund: ENTITY GF SYS5000 5000 GF RRP 999,266.39 999,266.39 999,266.39 3.929 3.990 3,386.25 0.00 3,386.25 SYS6000 6000 GF RRP 4,066,215.65 4,066,215.65 4,066,215.65 3.929 3.990 13,780.68 0.00 13,780.68 SYS7000 7000 GF RRP 629,131.15 629,131.15 629,131.15 3.929 3.990 2,132.17 0.00 2,132.17 SYS 7002 7002 GF RR2 1,490,484.95 1,196,185.48 1,490,484.95 0.600 0.552 560.62 0.00 560.62 9442 5201 GF PA1 214,620.38 250,919.31 214,620.38 0.010 0.088 18.76 0.00 18.76 SYS5002 5002 GF RR2 1,826,246.00 1,794,455.18 1,826,246.00 0.600 0.533 812.32 0.00 812.32 SYS6002 6002 GF PA2 588,776.99 581,480.09 588,776.99 0.850 0.164 81.21 0.00 81.21 SYS 7003 GF RR2 6,216.10 6,216.10 6,216.10 0.00 0.00 0.00 Subtotal 9,820,957.61 9,523,869.35 9,820,957.61 2.568 20,772.01 0.00 20,772.01 Totai 9,820,957.61 9,523,869.35 9,820,957.61 2.568 20,772.01 0.00 20,772.01 Portfolio ENTY CP Run Date:OS/1012024-16:19 IE(PRF_IE)7.3.11 Report Ver.7.3.11 � � � � � � ��a� � CITY OF REDDING ENTITIES CiT easu eEDOffi e Received Interest 777 Cypress Ave � � � � � � � � � � Sorted by Security Type Redding, Red�530)225-4099 vj Received December 1, 2023 - December 31, 2023 Security Par Current Interest Security Type CUSIP Investment# Type Vaiue Rate Date Received Amount Received Cash Accounts FSS Escrow Account 9442 5201 PA1 250,919.31 0.010 12/31/2023 18.15 Subtotal 18.15 Successor Agency MM Account SYS6002 6002 PA2 581,480.09 0.850 12/31/2023 49.92 Subtotai 49.92 Overnight Sweeps&DDA Accounts SYS5002 5002 RR2 1,794,455.18 0.600 12/31/2023 812.32 SYS 7002 7002 RR2 1,196,185.48 0.600 12/31/2023 560.62 Subtotal 1,372.94 Total 1,441.01 Portfolio ENTY CP Run Date:05/10/2024-16:19 RI(PRF_RI)7.3.11 Report Ver.7.3.11 City of Redding, Entities Earnings History � $25,000 ��� �� � $20,000 ,,, r,}F 7 sr;. $15,000 �� � {„ y;� , „ t�t , j?.. r, . , .� . er ; n � $10,000 ��.. � c, � cMc ,� � � rn �l' � �. aG .I�. T o0 . `,"� � eY . a— � . �la� d,��. pry :.� � �. ti'J �� � 00 h � �VrJ�O�� 13S �. � p�p � �. � O �— � . ��, ,. � i yy C7Y :V�' � � � � a0 . Oi � �, y��, r ��i�,; };b, � G4t�.. � {4.,j }'t� ,`� , . � ,M - >�`� . �M1 . � � d,� '�� t" •�`'' �d �� �� `� ' t� � �� �`''` ��'�� �a�� 'a�� '�`�� �a� ��� c,`� i� � ' �� �`''` c��'�� ��� 'a`�� 'oe� �� �,�� ��� �,Q a� �� �.� �g ,�� G,�a �� vfi �.a ,�c �+,, Q.Q �� �,� �� �o, ,�� ��,o �cc; �� �a t�'� ' �` `l, �` � `1, ' Q- e� O o� ,�c, �� �g e�` 3 �` J 3 P eQ O o� e� �o�`L�o�`L ��`L`t' �,p`L �Orl'`L�o�;L tj,�`L�p`L�'o��,��o`Lil'o��C�o��O��ry"��o�`� ,�0�,`3 rL09' �p`L3 ryp`L3 �0`1'�o�y"�0��5�oryg�������0 `l, `l, R, `i, `L `1, City of Redding, Entities Book Value History $12,000,000 �� � � ��� $10,OOC�,000 � $8,000,000 ����` " „`�� rr�is,� ��s��' ��,��;�' `�a{�G �r^f,�� ` '� �rk�Pr3ts i�"���� r�?1;�r� {t`�i�t ?�l� �. �,,. �, ,R,,,��x� P��2?r� $6,000,000 n � � � a, a, � � cM� a°°o_ v n v�i ri c° 'u� ao ti i � °' �: :� tt) ' <p" � N t� t(j e�— M N M a= h. �'j . � �. $4,000,000 c`�o � oi ai ai c�i" �r �°' s+ v oNi" � a' °�'� � � ur Ftt ur Esr � � y� �y �sr � � �2,����0�� �S,''E�'; faj';� SF��'"r`� °`tiit' s�z,�tr �r'r�#Y �4,7.�� ,f<: rr"d'e. H,� J;ar' �#�'�'�� s�r`fi�t � 4i� �,�c ��c �� ��� �� ,�� � �� ���, ' ,o�� ��c ��c ��c a'��� e��fi ���� ��''�� ��` 3PQ ���� ���� `��� P��, ���e,�` ���� o'��� v�eco `L���� `L���� ���� �'��� �0�� ��� �o� ��� �o� �4�� `Ld��� ���� `L4��� `L���O TREASURER'S REPORT JANUARY, FEBRUARY, MARCH 2O24 Demand Deposit Accounts FY 2023-2024 QTR 2 FY 2023-2024 QTR 3 US Bank General Account 15,517,015.28 11,208,574.66 Imprest Retirement Contributions 100.00 851,939.09 Treasurer Credit Card 43,072.65 29,153.61 Utility Credit Card 211,353.40 323,725.09 �ibrary Merchant Account 633.96 651.49 DDAAccount (lncluded in lnvestmentAccounts)* (17,028,627.69) (13,319,850.29) Total Demand Deposit Accounts $ (1,256,452.40) $ (905,806.35) Investment Accounts *DDA Account 17,028,627.69 13,319,850.29 Certificates of Deposit 3,000,000.00 3,000,000.00 California Asset Management Fund 74,205,418.15 104,998,064.32 Local Agency Investment Fund -City 1,036,848.99 1,047,234.66 Treasury Coupon Securities 29,872,701.34 29,885,970.78 Commercial Paper- Medium Term Notes 25,422,620.51 17,852,980.05 Federal Agency Coupon Securities 127,155,161.19 125,232,794.90 Money Market Accounts 3,942,300.70 3,979,321.69 Municipal Bonds 1,880,147.14 1,878,625.07 Total Investments at Historical Cost $ 283,543,825.71 $ 301,194,841.76 Accrued Purchased Interest (0.00) (2,430.56) Total Accrued Purchased Interest $ (0.00) $ (2,430.56) TOTAL TREASURER'S ACCOUNTABILITY $ 282,287,373.31 $ 300,286,604.85 REDDING JOINT POWERS FINANCING AUTHORITY US BANK-TRUSTEE FY 2023-2024 QTR 2 FY 2023-2024 QTR 3 2013 Capital Projects-Series B and Series C Revenue Fund 0.14 - Interest Fund 544.91 192,563.33 Principal Fund 1,496.07 5.71 Rebate Fund - - $ 2,041.12 $ 192,569.04 2015 Electric- Held in Trust-Series A Revenue Fund - - Interest Fund 853.33 863.57 Principal Fund 14.48 14.66 $ 867.81 $ 878.23 2017 Electric Refundinq-Series A Interest Fund 1,157.09 1,171.41 Principal Fund 32.18 32.59 Surplus Fund - - $ 1,189.27 $ 1,204.00 2018 Electric Refundinq-Series A Interest Fund 754.81 764.16 Prinicipal Fund 21.01 21.27 Surplus Fund - - $ 775.82 $ 785.43 2019 Capital Proiects-Series A Revenue Fund 17.89 0.07 Interest Fund 1,090.21 411,397.91 Principal Fund 3.05 1,155,000.01 Acquisition Fund - - 2039 A Term -Sinking AC - - 2044 A Term -Sinking AC - - $ 1,111,15 $ 1,566,397,99 2020 Wastewater System -Series A& B Debt Service Fund - - Interest Fund 1,153.24 1,167.08 Principal Fund 31.50 31.88 Surplus Fund - - Refunding Fund - - $ 1,1$4,74 $ 1,19$,96 Total Funds Held in Trust $ 7,169.91 $ 1,763,033.65 -2- RELATED ENTITIES FY 2023-2024 QTR 2 FY 2023-2024 QTR 3 SUCCESSOR AGENCY FOR REDDING REDEVE�OPMENT US Bank RRAAccount 588,776.99 980,150.06 Subtotal Demand Deposit Accounts $ 588,776.99 $ 980,150.06 Trust Accounts US Bank-Trustee Market Street Project Series 2003 - - SHASTEC Project Series 2006 - - Subtotal Trust Accounts $ - $ - Investment Accounts Local Agency Investment Fund 4,066,215.65 4,107,061.95 Subtotal Investment Accounts $ 4,066,215.65 $ 4,107,061.95 Total Redding Redevelopment Agency $ 4,654,992.64 $ 5,087,212.01 HOUSING AUTHORITY US Bank Housing Checking Account 1,826,246.00 3,236,497.54 FSS Escrow Account 214,620.38 175,834.94 Subtotal Demand Deposit Accounts $ 2,040,866.38 $ 3,412,332.48 Investment Accounts �ocal Agency Investment Fund 999,266.39 1,009,305.17 Subtotal Investment Accounts $ 999,266.39 $ 1,009,305.17 Total Housing Authority $ 3,040,132.77 $ 4,421,637.65 REDDING AREA BUS AUTHORITY US Bank Checking Account 1,490,484.95 2,935,273.03 Cornerstone Bank- Designated Veterans Punch Cards 6,216.10 6,216.10 Subtotal Demand Deposit Accounts $ 1,496,701.05 $ 2,941,489.13 Investment Accounts Local Agency Investment Fund 629,131.15 635,445.31 Subtotal Investment Accounts $ 629,131.15 $ 635,445.31 Total Redding Area Bus Authority $ 2,125,832.20 $ 3,576,934.44 TOTAL FUNDS OF RELATED ENTITIES $ 9,820,957.61 $ 13,085,784.10 (Includes RRA Trust Accounts) TOTAL JPFA FUNDS HELD IN TRUST $ 7,169.91 $ 1,763,033.65 TOTAL CITY OF REDDING FUNDS $ 282,287,373.31 $ 300,286,604.85 GRAND TOTA�CITY OF REDDING FUNDS, FUNDS HE�D IN TRUST& FUNDS OF RE�ATED ENTITIES $ 292,115,500.83 $ 315,135,422.60 -3- Monthly Yield Comparisons Year Ended March 31,2024 Investments by Type at March 31,2024 Monthly Rate of Return Fiscal Yr Rate of Return —�-2-Yr Treasury 5-Yr Treasury LAIF =CAMP Municipal 5.750 �� Bonds DDA C.D.s �� f3 }�t�7Fi4i�i�Ji�ri�`A t f���a��) 5, 0.62% 0 1.00% 5,500 - 4 � r� ; y'�,��... �„r..�.._.:�,_ _ 4.42/o {t,�t r�� . � � 5.250 ,t� ��, `z Money Market 5.000 �t � F��€�xl�� �� � ���, � 1.32% �t �r���?ktnt����'� ���, 4.750 t{''�t�?rh'�i�' �'�� 4.500 ''�� � rpt ; CAMP �},� g zt , , � � �� �z� 34.86% �.....�4 250 � ,��7t� F �;� , Ki�. 'i ; YIELD /o �- �t s�i ��}s r � ���si,���1 �{€idty � � a)� �:i 4 000 �a s, - a�t� }���r 3,750 �w��a ir�� �� � F{�It�iil��, { �, � ,, $y�l�s 3,500 rt€n� „ , , t;i��t�s���, � t . �t j it �,�tiur.����,�rt,a�,��'t>r,��� LAIF z��� � �rttz��is� , � 0 3,250 �r � t�r11i7rs' �.� �.35�0 ��r�,�+.s�, t �:'1�7+ikt{s tif�f����4������. Federal 3.000 r�r,�,f�G<s Coupo s �s�=�t.,,^A��„ 2.750 ��t�t�� r��t� � 41.58%a Treasury 2 500 '`'' ,'3� {r� ;sf �� Coupon `t`z'�f����� � 2.250 '� Securities ;���t�t��'<�'����"° � �� Medium Term � � l,��l�� � ''�{ Notes 9.92% 2.000 �,'.�i,l`.�����t{� ����� � �� � �t���r�� �Inclusive of Demand Deposit Accounts 5•93°�a 1.750 � } t t${t;,���������� �t�,r,, , 1.500 ' APR MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR Maturities by Fiscal Year at March 31,2024 March 2024 42.94% W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W�W� These graphs depict investment activity from January 1, 2024 through �"�� March 31, 2024. Investment activit durin this eriod included the $140,000,000 ����� y � � maturity of two Federal Agency Coupons, and two Medium Term Notes � totaling $17.5 million in maturities. Additionally two Federal Agency $120,000,000 � Coupons were purchased in the amount of $8 million and transfers 24.10% between CAMP and the general account were made to accommodate $,00,000,000 � cash flow needs. Portfolio yield, as depicted in the line graph, shows a r , �� �3.s�% 15.34% slight increase in both the city's monthly and yearly yields with a decline in �80,000,000 � monthly yield in March. 2Yr and 5Yr Treasury Markets have been slightly � . increasing since January 2024. Sso,000,000 � . �' `' ' ° The effects of this investment activity on portfolio diversification, as s4o,000,000 � . ; ;%�' ,� .,,,,,,,. .,,,,,,. ,,...,,,. ...«.... depicted in the pie chart, was a decrease of 3.26 in Federal Agency 9x j�,� ' �.00% 2 65��° Coupons, a decrease of 1.59 in the DDA Account, and a decrease to $zo,000,000 a Medium Term Notes of 3.04, which is primarily offset by an increase of ` 8.71 points in CAMP. � so t` " `� 2023/24 2024/25 2025/26 2026l27 Zoz�iza 2ozsizs Portfolio Liquidity as noted in the bar graph indicates the majority of liquidity in the current year due to 2023/24 maturities. Maturities shifted into 2028/2029 due to purchases in February 2024 � IT �* � � � .==-'" CBTY OF REDDBNG � ='0. CITY QF RED�ING Treasurer"s C}ifice PQC�'�O'10 �t1c'� �t71t�'t'lt 777 Cypress Ave , � Redding; F;edding,GA 960U1 � � �. C � � � �1 I � P�rtfolio Summ�ry t�3o�zzs-a�ss ��-� Mar�h 31, 2024 � fnvestmen#s Par Market Book °fe af Days to YTM YTM Value Vaiue Value PortFofio Maturity Term 360 Equiv. 365 Equiv. Certificates af Deposif-Bank 3,004,QOO:pO 3,OOQ,OOOAO 3;000,040.40 1.OQ 541 i,826 1.000 1.014 Caiifamia Asset Managemenf F`und iO4,9HB,d64:32 104;996,p64,32 '104;998,064.32 34:86 1 1 5.405 5:480 MediumTermNates 17,500,�00;00 16,65d;S75,00 17,652;980.d5 5.93 585 1,771 1:238 1.255 federai Ageiicy Coupot�Securities 125,7fi0,000A0 117,884,434.97 125;232,734.90 41.58 884 1,480 2:296 2.326 Treasury Caupon Securities 3D,OOO,ODQ:00 27,024,304.00 29,885,970.78 9.92 802 1;817 6.886 0:898 Municipal Bonds 1,870,600:OQ 1.�19,4$3.7Q 1,878,6?5.97 4.62 518 1,825 0.807 0:820 LABF-Local flgency Investmenf Funcl 1,047,234.66 1;047,234.66 1;047,234.66 0.35 1 1 4:232 4:291 Overnight Sweeps 8 dDR Accou�ts 13,318,950.29 13;319.850.29 13,319,850.29 4.42 1 1 Q.744 0:75Q Investmsnt Maney Market Accounts 3,879,321.fi9 3,978,321,68 3,979,321.89 1,92 1 1 3.872 3:926 30l,47d,d70.96 289,623,264.63 3Q1;194,841.76 't00.Q0°l� 4Q7 931 3.114 3.158 Investments Tetal Earnings March 31 Nlonth Ending FEscal Year To Qate Current Yea� 698,324.45 5;95F�807.94 Average Daily Balance 298,488,768.95 286,769,680.04 Effective Rate of Re#urn 2,75% 2:IS°I4 Pursuantto City of Redtling,Resolution No.97-19,this report sfiows idle funds inuested"maturing at interva(s durir�g the year. The LAIF accaunt offers available funds for expenditure needs an a seme day basis; The City af Redding has sufifieienffiunds ta cove�expendifures during the next 6 months. �Gavernment Code sections 16429.1;63601.53601.1,and 53635 HISTORIGAL RATE OF RETURNs FY 90/91 7.72 FY 97/98 S.d4 FY D4/05 3.07 FY 11/12 1.40 FY 18/19 1.79 FY 91/92 6.39 FY 98l99 5.61 FY 05/06 3.64 FY 12l13 �.86 FY 9 9(20 7.87 FY $2/83 5.Q6 FY 99/04 5.94 FY 46/07 4.59 FY 13/14 0.92 FY 2d/21 0.78 FY 93194 4:59 FY 00l07 6.31 FY 07/D8 4.6� Fl( 14/15 1:10 FY 21122 0:73 FY 94/95 5.54 FY 01f02 4.98' FY 0$/09 3.71 FY 95118 1.10 FY 95/86 5.92 FY 02103 4.02 FY 09/10 2.74 FY 16/17 1.26 FY 96l97 5.84 FY 03/Q4 2.97 FY 10!'1'{ 1.93 FY 17118 1.61 .:_---� ,.� ����'� '�� � GREG OBINETT,GITY TREASUREFt Reporting periool 08t09/2024-03131/3Q24 Portfalio CITY AC Run Date:05/09/2424.-10:b0: . PM(PRF PM1}7:3:11� Report.Ver.�7.3�,11 CITY OF REDDING Portfolio Management Page 1 Interest Earnings Summary March 31, 2024 March 31Month Ending Fiscal Year To Date CD/CouponlDiscount Investments: Interest Collected 383,471.80 2,903,691.94 Plus Accrued interest at End of Period 574,650.58 574,650.58 Less Accrued Interest at Beginning of Period ( 765,805.98) ( 853,878.32) Less Accrued Interest at Purchase During Period ( 0.00) ( 2,430.56) Interest Earned during Period 192,316.40 2,622,033.64 Adjusted by Premiums and Discounts 16,899.66 96,352.91 Adjusted by Capital Gains or�osses 0.00 0.00 Earnings during Periods 209,216.06 2,718,386.55 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�osses 0.00 0.00 Earnings during Periods 0.00 0.00 Cash/Checking Accounts: Interest Collected 450,399.05 3,318,114.66 Plus Accrued Interest at End of Period 475,105.28 475,105.28 Less Accrued Interest at Beginning of Period ( 436,395.94) ( 558,798.55) Interest Earned during Period 489,108.39 3,234,421.39 Total Interest Earned during Period 681,424.79 5,856,455.03 Total Adjustments from Premiums and Discounts 16,899.66 96,352.91 Total Capital Gains or�osses 0.00 0.00 Totai Earnings during Period 698,324.45 5,952,807.94 Portfolio CITY AC Run Date:05/09/2024-10:50 PM(PRF_PM6)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 1 Activity Summary March 2023 through March 2024 Yield to Maturity p�anaged Number Number Month Number of Total 360 365 Pool of Investments of Investments Average Average End Year Securities Invested Equivalent Equivalent Rate Purchased Redeemed Term Days to Maturity March 2023 60 287,501,970.26 2.040 2.068 0.000 0 0 983 611 April 2023 61 286,300,240.74 2.112 2.142 0.000 1 0 994 600 May 2023 61 282,425,731.52 2.067 2.095 0.000 0 0 1,008 587 June 2023 62 294,320,518.75 2.631 2.668 0.000 1 0 967 544 Juiy 2023 62 270,815,984.45 2.516 2.551 0.000 0 0 1,051 569 August 2023 62 273,694,345.98 2.537 2.573 0.000 0 0 1,040 541 September 2023 62 271,128,413.78 2.591 2.627 0.000 0 0 1,050 525 October 2023 62 275,326,800.21 2.658 2.695 0.000 0 0 1,034 495 November 2023 62 286,405,619.03 2.844 2.883 0.000 0 0 994 456 December 2023 62 283,543,825.71 2.801 2.840 0.000 0 2 994 440 January 2024 60 300,991,774.19 2.881 2.921 0.000 0 3 913 395 February 2024 59 299,120,784.10 3.085 3.128 0.000 2 1 944 429 March 2024 58 301,194,841.76 3.114 3.158 0.000 0 1 931 407 Average 61 285,597,757.73 2.606% 2.642% 0.000 0 1 993 508 Portfolio CITY AC Run Date:05l09/2024-10:50 PM(PRF_PM4)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management l�►CtlVlt g T @ Page 1 y y Yp March 1, 2024 through March 31, 2024 Stated Transaction Purchases Redemptions CUSIP investment# Issuer Rate Date or Deposits or Withdrawals Balance Certificates of Deposit-Bank Subtotai 3,000,000.00 California Asset Management Fund (Monthly Summary} 9999 9999 PFM 5.480 8,894,131.58 2,429,619.10 Subtotai 8,894,131.58 2,429,619.10 104,998,064.32 Medium Term Notes Subtotai 17,852,980.05 Federal Agency Coupon Securities 3130ATAH0 50567 FED HOME LOAN BANK 3.640 03/15/2024 0.00 4,000,000.00 Subtotai 0.00 4,000,000.00 125,232,794.90 Treasury Coupon Securities Subtotai 29,885,970.78 Municipal Bonds Subtotai 1,878,625.07 LAIF-�ocal Agency Investment Fund Subtotai 1,047,234.66 Overnight Sweeps&DDA Accounts USB 9400 910 US BANK 0.750 38,390,921.87 38,811,241.50 Subtotai 38,390,921.87 38,811,241.50 13,319,850.29 investment Money Market Accounts SYS606 606 FIVE STAR BANK 4.122 12,965.15 0.00 Subtotai 12,965.15 0.00 3,979,321.69 Total 47,298,018.60 45,240,860.60 301,194,841.76 Portfolio CITY AC Run Date:05/09/2024-10:50 PM(PRF_PM3)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 1 Portfolio Details - Investments March 31, 2024 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Date Certificates of Deposit-Bank SYS 30031 50514 REDDING BANK OF COMMERCE 09(24(2020 3,000,000.00 3,000,000.00 3,000,000.00 1.000 A 1.000 541 09/24/2025 Subtotal and Average 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 1.000 541 California Asset Management Fund 9999 9999 PFM 104,998,064.32 104,998,064.32 104,998,064.32 5.480 5.405 1 Subtotai and Average 100,096,923.21 104,998,064.32 104,998,064.32 104,998,064.32 5.405 1 Medium Term Notes __ . 037833BZ2 50543 APPLE 01/21/2022 5,000,000.00 4,678,450.00 5,079,705.57 2.450 AAA 1.677 855 08/04/2026 24422EUE7 50505 BANK OF AMERICA 03l17/2020 5,000,000.00 4,868,900.00 5,080,799.18 3.450 A 1.647 346 03/13/2025 5949186J2 50515 MICROSOFT 11(20(2020 5,000,000.00 4,825,050.00 5,190,704.09 3.125 AA 0.670 581 11/03/2025 89114QCK2 50513 Toronto Domi�ion Bank 09/15/2020 2,500,000.00 2,278,175.00 2,501,771.21 0.750 A 0.690 528 09/11/2025 Subtotal and Average 77,862,348.13 17,500,000.00 16,650,575.00 77,852,980.05 1.238 585 Federal Agency Coupon Securities 3133EM6E7 50535 FEDERAL FARM CREDIT BANK 09/28/2021 5,000,000.00 4,447,150.00 5,000,000.00 0.940 AA 0.927 910 09/28l2026 3133ENDC1 50538 FEDERAL FARM CREDIT BANK 11/03/2021 2,000,000.00 1,800,780.00 2,000,000.00 1.330 AAA 1.312 946 11(03/2026 3133ENMQ0 50547 FEDERAL FARM CREDIT BANK 02l04/2022 3,000,000.00 2,831,370.00 2,996,893.23 1.310 AAA 1.417 308 02/03/2025 3133ENMZ0 50548 FEDERAL FARM CREDIT BANK 02l04l2022 3,000,000.00 2,925,150.00 2,999,991.53 1.200 AAA 1.235 2 04/03/2024 3133ENQV5 50550 FEDERAL FARM CREDIT BANK 03(10(2022 5,000,000.00 4,747,300.00 5,000,000.00 1.870 AA 1.844 343 03/10/2025 3133ENSZ4 50553 FEDERAL FARM CREDIT BANK 04/01/2022 2,500,000.00 2,333,375.00 2,500,000.00 2.750 AAA 2.712 1,095 04/01/2027 3133EN3M0 50569 FEDERAL FARM CREDIT BANK 12/05/2022 2,000,000.00 1,984,040.00 2,002,711.11 4.625 AAA 4.353 248 12/05/2024 3130AKQ74 50520 FED HOME LOAN BANK 01/22/2021 2,500,000.00 2,255,650.00 2,500,000.00 0.625 AA 0.616 661 01/22/2026 3130AKPN0 50521 FED HOME�OAN BANK 01/29/2021 2,500,000.00 2,260,225.00 2,500,000.00 0.600 AA 0.592 668 01/29l2026 3130ALGJ7 50525 FED HOME�OAN BANK 03/23/2021 4,875,000.00 4,423,233.75 4,875,000.00 1.000 AA 0.986 721 03(23/2026 3130ALDN1 50526 FED HOME LOAN BANK 03/16/2021 5,000,000.00 4,510,900.00 5,000,000.00 0.800 AA 0.789 714 03/16/2026 3130ALXP4 50528 FED HOME LOAN BANK 04/28/2021 2,500,000.00 2,270,925.00 2,500,000.00 1.200 AA 1.184 757 04/28/2026 3130APQB4 50537 FED HOME�OAN BANK 11(23(2021 3,000,000.00 2,711,970.00 3,000,000.00 1.500 AAA 1.479 966 11/23/2026 3130APYK5 50540 FED HOME�OAN BANK 12(14/2021 3,000,000.00 2,813,640.00 3,000,000.00 1.150 AAA 1.134 347 03/14/2025 3130ARPB1 50556 FED HOME LOAN BANK 04/28/2022 5,000,000.00 4,763,450.00 5,000,000.00 3.500 AAA 3.452 1,122 04/28/2027 3130ARYA3 50557 FED HOME LOAN BANK 05/26/2022 3,000,000.00 2,889,720.00 3,000,000.00 4.000 AAA 3.945 1,150 05(26/2027 3130ASQP7 50561 FED HOME�OAN BANK 07/28/2022 2,000,000.00 1,959,040.00 2,000,000.00 3.625 AAA 3.575 302 01/28l2025 3130AQV26 50573 FED HOME�OAN BANK 04/13/2023 4,000,000.00 3,849,560.00 3,951,125.51 1.610 AAA 4.547 156 09(04/2024 3130AYXU5 50574 FED HOME LOAN BANK 02l15/2024 4,000,000.00 4,000,000.00 4,000,000.00 4.450 4.389 1,778 02/12/2029 3134GWUG9 50546 FED HOME LOAN MTG CORP 02l03/2022 735,000.00 670,415.55 724,526.31 0.570 AAA 1.542 541 09/24/2025 3134GW6C5 50549 FED HOME�OAN MTG CORP 02(07(2022 2,000,000.00 1,768,680.00 1,950,357.27 0.800 AAA 1.785 940 10/28/2026 3134GXMT8 50551 FED HOME�OAN MTG CORP 03/25/2022 5,000,000.00 4,770,450.00 5,000,000.00 2.250 AAA 2.219 358 03/25/2025 3134GW6C5 50552 FED HOME LOAN MTG CORP 03/23/2022 3,000,000.00 2,653,020.00 2,875,065.05 0.800 AAA 2.488 940 10/28/2026 Portfolio CITY AC Run Date:05/09/2024-10:50 PM(PRF_PM2)7.3.11 Report Ver.7.3.11 CITY OF REDDING Portfolio Management Page 2 Portfolio Details - Investments March 31, 2024 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Date Federal Agency Coupon Securities 3134GXQV9 50554 FED HOME�OAN MTG CORP 04(25(2022 4,150,000.00 4,006,742.00 4,150,000.00 3.100 AAA 3.058 389 04/25/2025 3134GW4C7 50555 FED HOME�OAN MTG CORP 04/06/2022 3,000,000.00 2,653,260.00 2,855,090.31 0.800 AAA 2.775 939 10/27/2026 3134GXVF8 50558 FED HOME LOAN MTG CORP 06/23l2022 3,000,000.00 2,909,130.00 3,000,000.00 3.000 AAA 2.959 266 12/23/2024 3134GXYE8 50559 FED HOME LOAN MTG CORP 06/28/2022 3,000,000.00 2,941,380.00 2,997,535.00 3.100 AAA 3.407 88 06(28/2024 3134GXH56 50562 FED HOME�OAN MTG CORP 07/28/2022 3,000,000.00 2,932,740.00 3,000,000.00 4.000 AAA 3.947 422 05/28l2025 3134GXR89 50563 FED HOME�OAN MTG CORP 08/25/2022 3,000,000.00 2,910,480.00 3,OOQ000.00 4.375 AAA 4.315 1,241 08(25/2027 3134GY6H0 50570 FED HOME LOAN MTG CORP 12l16/2022 2,000,000.00 1,984,200.00 2,002,334.72 5.500 AAA 5.351 624 12/16/2025 3134H1SK0 50575 FED HOME LOAN MTG CORP 02l14/2024 4,000,000.00 3,976,838.67 3,976,838.67 4.375 4.462 1,775 02/09/2029 3136G4S61 50511 FEDERAL NAT�MTG ASSN 08(25(2020 5,000,000.00 4,582,750.00 5,000,000.00 0.660 AA 0.651 511 08/25/2025 3135GA3W9 50516 FEDERAL NAT�MTG ASSN 11/25/2020 2,500,000.00 2,270,725.00 2,500,000.00 0.600 AA 0.592 603 11/25/2025 3135GA3Z2 50517 FEDERAL NATL MTG ASSN 11/25/2020 2,500,000.00 2,270,725.00 2,500,000.00 0.600 AA 0.592 603 11/25/2025 3135GA5R8 50518 FEDERAL NATL MTG ASSN 12/18/2020 5,000,000.00 4,524,700.00 5,000,000.00 0.625 AA 0.616 626 12(18/2025 3135G06G3 50519 FEDERAL NAT�MTG ASSN 01/19/2021 5,000,000.00 4,555,400.00 5,000,709.67 0.500 AA 0.484 585 11/07l2025 3135G06V0 50564 FEDERAL NATL MTG ASSN 09/16/2022 3,000,000.00 2,930,970.00 2,990,332.63 4.125 AAA 4.311 514 08(28/2025 3135G03U5 50566 FEDERAL NATL MTG ASSN 10/18/2022 3,000,000.00 2,794,350.00 2,884,283.89 0.625 AAA 4.459 386 04/22/2025 Subtotai and Average 127,024,231.05 125,760,000.00 117,884,434.97 125,232,794.90 2.296 684 Treasury Coupon Securities 91282CBQ3 50522 TREASURY NOTE 03/01/2021 5,000,000.00 4,514,450.00 4,979,681.51 0.500 0.707 698 02/28/2026 91282CBQ3 50523 TREASURY NOTE 03/08/2021 5,000,000.00 4,514,450.00 4,971,804.52 0.500 0.791 698 02/28/2026 91282CBT7 50527 TREASURY NOTE 03/31/2021 2,000,000.00 1,815,160.00 1,993,512.46 0.750 0.904 729 03(31/2026 91282CBW0 50530 TREASURY NOTE 05/13/2021 5,000,000.00 4,521,900.00 4,989,533.92 0.750 0.841 759 04/30l2026 91282CCW9 50534 TREASURY NOTE 08/31/2021 5,000,000.00 4,476,350.00 4,989,433.87 OJ50 0.828 882 08(31/2026 91282CCW9 50536 TREASURY NOTE 09/28/2021 5,000,000.00 4,476,350.00 4,972,406.84 0750 0.971 882 08/31/2026 91282CDQ1 50541 TREASURY NOTE 01l05/2022 3,000,000.00 2,705,640.00 2,989,597.66 1.250 1.362 1,004 12/31/2026 Subtotai and Average 29,883,783.51 30,000,000.00 27,024,300.00 29,885,970.78 0.886 802 Municipal Bonds . .. . 35981VAZ3 50512 FULLERTON REDEVELOPMENTAGENCY 09/02/2020 1,870,000.00 1,719,483.70 1,878,625.07 1.221 AA 0.907 518 09/01l2025 Subtotai and Average 1,878,862.38 1,870,000.00 1,719,483.70 1,878,625.07 0.907 518 LAIF-Local Agency Investment Fund 1000 601 STATE OF CALIF POOL 04/01/2013 1,047,234.66 1,047,234.66 1,047,234.66 4.232 4232 1 Subtotai and Average 1,047,234.66 1,047,234.66 1,047,234.66 1,047,234.66 4.232 1 Overnight Sweeps&DDA Accounts USB 9400 910 US BANK 07(01/2019 13,319,850.29 13,319,850.29 13,319,850.29 0.750 0.740 1 Portfolio CITY AC Run Date:05/09/2024-10:50 PM(PRF_PM2)7.3.11 CITY OF REDDING Portfolio Management Page 3 Portfolio Details - Investments March 31, 2024 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Date Subtotai and Average 13,726,611.22 13,319,850.29 13,319,850.29 13,319,850.29 0.740 1 Investment Money Market Accounts SYS609 609 CORNERSTONE BANK 08/01/2013 250,000.00 250,000.00 250,000.00 1.000 0.986 1 SYS606 606 FIVE STAR BANK 06/30/2013 3,729,321.69 3,729,321.69 3,729,321.69 4.122 4.066 1 SYS608 608 FIVE STAR BANK 06/30/2013 0.00 0.00 0.00 2.624 2.588 1 Subtotai and Average 3,966,774.77 3,979,321.69 3,979,321.69 3,979,321.69 3.8�2 1 Totai and Average 298,486,768.95 301,474,470.96 289,623,264.63 301,194,841.76 3.114 407 Portfolio CITY AC Run Date:05/09/2024-10:50 PM(PRF_PM2)7.3.11 CITY OF REDDING Portfolio Management Page 4 Portfolio Details - Cash March 31, 2024 Average Purchase Stated YTM Days to CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate S8P 360 Maturity Average Balance 0.00 0 Total Cash and Investments 298,486,768.95 301,474,470.96 289,623,264.63 301,194,841.76 3.114 407 Portfolio CITY AC Run Date:05/09/2024-10:50 PM(PRF_PM2)7.3.11 City of Redding Earnin s Histo $soo,0oa � � � � �700,000 $600,000 �, Y=' <,�„a � � `"` ��� $500,000 � - �°�'{ — }h, tss,, �r„,. . �4��,��� � � � —jr t, ;. , � `_' �n u� �„` M . 7 ..M C�0 <F .Nj N M h b h �: ;�,. Ss r � �� � � N � ' � . M �. pp O �� O V' O N 1� � : O� ". �300,000 ,.�, :,.,, ' a°'o N M � � n --o - �- � w `�' �„ v t� � : � � ;0 �� t0 �.<O M .. � � � � �� � �. ,^ ' � N N t0 �!f f0 �!f � 1H Vi . . ' � O h � <I' 01 � � � tg $ZOO,OOO � O � O M o N � ; � � � � O � �. M .� �. V iH Hy ;Y,,p }J�� . (H n M � ,, 'i J;i f �,i Y � $100,000 � � .,, ,� .�, ,, t,;= 4! � $0 a� ��� ���� �c},���' �������,�a�'`�� ��'a`���cr'�'e���,a�������<c,'� �,.Qi� a� ���'' ���� ��o��` �e�`a���,�o�a��'ec�`a�'�����'���a�'�t�a�a�°� �,� �y� �,`L P � eQ O o� e� �a �e ,,,�` �,"3 g�` ��s y`� �P ��� �O �o� a�c, �S�r ��e �� `LD�I' `LO�' �'� �yo`L7"oty`LG' ry4�i'`�' o�y`L�o�,`y� ry4�'`� �O`y`� �,4� �'4 `L�� `L�� �'� �,�� 0`y`� �,4�' �`b`� �`b�' ,�,4�' �,0�' �1,�� �y �y ; �L �L rL rL City of Redding ' Book Value Histo $305;0OO,OdO ���� $300;000,000 $295,000,000 ` - - - — — $290,000,000 - {'�#" — ?,;l'r ''`?t''s}" �� $2$5,000,000 ' �'������ ' r„4., �rn v v $280,000,000 � �� �,���, .,_ r�rf, ��— r' - - — r�.,�� - ��� o � .. � � � � � 4 0 �� �, o' � � `f t $275,00O,OOd � � -�— N ._ �' __ M _ � � � __ rn � � M , r' p" , nM„ .... �j �. .:�1j CO fi} �:N ff} O . � $Z�O,OOO,OOO ' c, `" ' M __ �ri c°'.� ` v — v { . , N �.' , �p" , � .. Ef? ' � ''�f`;. � '�p uy Ef? $265,000,000 `� 80 ao � .. , m�� � .. � � . � � _._,_. � .., �.,,---._. �,�_— ��.___.. N�. _ :� .tJi�. .._._.�. � t`s� `._.._.�.j�U;t,} 'r1 i,::?,�. ,y,�;'y,:,i ,�i 00. M���. � h,. ;"�.,k .. �260�����0�� ,;<�,v� hl'""' � �. .C'G# �"` $255,000,000 ' � i� � � ' ef ,�z ,pe� ,pv�t; � ' �,c1 ,c ���� �tc,'� PQ �� �� ���� ���5 �e��0 ��°`' e�c� e�c� ��� ��� �a�o �� �� ti3 �e� �� �3 �P �e� �a �o� oe� ��� ��� ti°�� ti°� �� `��� ti�� �� ti°� o`�� ti°� oti� oti� ti°� ti°� ti°�� ti ti ti � � � � � � w ,.'� �� CITY OF REDDING CITY OF REDDING Treasurer's ottice Received Interest 777 Cypress Ave Redding, Redding,CA 96001 � � � � � � � � � SOt"t@C� b�/ �SSU@C (530)225-4199 ° Received March 1, 2024 - March 31, 2024 Security Par Current Interest Issuer CUSIP Investment# Type Value Rate Date Due Date Received Amount Due Amount Received Variance BANK OF AMERICA 24422EUE7 50505 MTN 5,000,000.00 3.450 03113/2024 03/13/2024 86,250.00 86,250.00 - Subtotal 86,250.00 86,250.00 FEDERAL FARM CREDIT BANK 3133ENQV5 50550 FAC 5,000,000.00 1.870 03/10/2024 03(10/2024 46,750.00 46,750.00 - 3133EM6E7 50535 FAC 5,000,000.00 0.940 03/28/2024 03/28/2024 23,500.00 23,500.00 - Subtotal 70,250.00 70,250.00 FED HOME LOAN BANK 3130AQV26 50573 FAC 4,000,000.00 1.610 03/0412024 03/04/2024 32,200.00 32,200.00 - 3130ATAH0 50567 FAC 0.00 3.640 03/15/2024 03(15/2024 72,800.00 72,800.00 - 3130ALDN1 50526 FAC 5,000,000.00 0.800 03/16/2024 03/16/2024 20,000.00 20,000.00 - 3130ALGJ7 50525 FAC 4,875,000.00 1.000 03/23l2024 03/23i2024 24,375.00 24,375.00 - S u btot a I 149,375.00 149,37 5.00 FED HOME LOAN MTG CORP 3134GWUG9 50546 FAC 735,000.00 0.570 03/24/2024 03/24/2024 2,09475 2,094.75 - 3134GXMT8 50551 FAC 5,000,000.00 2.250 03/25/2024 03(25/2024 56,250.00 56,250.00 - Subtotal 58,344.75 58,344.75 REDDING BANK OF COMMERCE SYS 30031 50514 BCD 3,000,000.00 1.000 03/24/2024 03(24/2024 2,416.67 2,377.05 -39.62 Subtotal 2,416.67 2,377.05 Toronto Dominion Bank 89114QCK2 50513 MTN 2,500,000.00 0.750 03/11/2024 03/11/2024 9,375.00 9,375.00 - Subtotal 9,375.00 9,375.00 TREASURY NOTE 91282CBT7 50527 TRC 2,000,000.00 0.750 03/31/2024 03/31/2024 7,500.00 7,500.00 - Subtotal 7,500.00 7,500.00 Totai 383,511.42 383,471.80 Total Cash Overpayment 0.00 Totai Cash Shortfall -39.62 PortFolio CITY AC Run Date:05/09/2024-11:17 RI(PRF_RI)7.3.11 Report Ver.7.3.11 CITY OF REDDING Received Interest Received March 1,2024-March 31,2024 Page 2 Security Par Current Interest issuer CUSIP Investment# Type Value Rate Date Received Amount Received Cash Accounts PFM 9999 9999 PA1 104,533,551.84 5.480 03/01/2024 429,619.10 Subtotal 429,619.10 CORNERSTONE BANK SYS609 609 RR4 250,000.00 1.000 03/31/2024 211.75 Subtotal 211.75 FIVE STAR BANK SYS606 606 RR4 3,716,356.54 4.122 03(31/2024 12,965.15 Subtotal 12,965.15 US BANK USB 9400 910 RR3 13,740,169.92 0.750 03/31/2024 7,603.05 Subtotal �,603.05 Totai 450,399.05 PortFolio CITY AC Run Date:05/09/2024-11:17 RI(PRF_RI)7.3.11 Report Ver.7.3.11 � � � � � � ��-�,'. ��°���� CITY OF REDDING , � CITY OF REDDING Treasurer's ottice Interest Earnings 777CypressAve Redding, Redding,CA 96001 � � � � � �� � � �� � '� � Sorted by Fund - Fund �s3o�2z5-4�ss ' March 1, 2024- March 31, 2024 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund:OTHER 9999 9999 050 PA1 104,998,064.32 98,533,551.84 104,998,064.32 5.480 5.551 464,512.48 0.00 464,512.48 1000 601 050 RRP 1,047,234.66 1,047,234.66 1,047,234.66 4.232 4.290 3,815.96 0.00 3,815.96 SYS606 606 050 RR4 3,729,321.69 3,716,356.54 3,729,321.69 4.122 4.108 12,965.15 0.00 12,965.15 SYS609 609 050 RR4 250,000.00 250,000.00 250,000.00 1.000 0.997 211.75 0.00 211.75 USB 9400 910 050 RR3 13,319,850.29 13,740,169.92 13,319,850.29 0.750 0.652 7,603.05 0.00 7,603.05 Subtotal 123,344,470.96 117,287,312.96 123,344,470.96 4.910 489,108.39 0.00 489,108.39 Fund:POOLED CASH 91282CDQ1 50541 100 TRC 3,000,000.00 2,989,276.47 2,989,597.66 12/31/2026 1.250 1.384 3,193.68 321.19 3,514.87 91282CCW9 50534 100 TRC 5,OOQ000.00 4,989,062.50 4,989,433.87 08/31/2026 0.750 0.833 3,158.97 371.37 3,530.34 91282CBQ3 50523 100 TRC 5,000,000.00 4,970,552.29 4,971,804.52 02/28l2026 0.500 0.795 2,105.98 1,252.23 3,358.21 91282CBT7 50527 100 TRC 2,000,000.00 1,993,236.58 1,993,512.46 03/31(2026 0.750 0.913 1,270.49 275.88 1,546.37 91282CBQ3 50522 100 TRC 5,000,000.00 4,978,779.11 4,979,681.51 02(28l2026 0.500 0711 2,105.98 902.40 3,008.38 91282CBW0 50530 100 TRC 5,000,000.00 4,989,106.45 4,989,533.92 04/30/2026 0.750 0.855 3,193.68 427.47 3,621.15 91282CCW9 50536 100 TRC 5,000,000.00 4,971,437.01 4,972,406.84 08/31/2026 0.750 0.978 3,158.97 969.83 4,128.80 24422EUE7 50505 100 MTN 5,000,000.00 5,087,886.82 5,080,799.18 03/13/2025 3.450 -18.273 -71,875.00 -7,087.64 -78,962.64 SYS 30031 50514 100 BCD 3,000,000.00 3,000,000.00 3,000,000.00 09/24/2025 1.000 1.014 2,583.33 0.00 2,583.33 3135G06G3 50519 100 FAC 5,OOQ000.00 5,000,746.63 5,OOQ709.67 11/07l2025 0.500 0.482 2,083.33 -36.96 2,046.37 3135GA3Z2 50517 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 11/25l2025 0.600 0.589 1,250.00 0.00 1,250.00 3135GA5R8 50518 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 12/18(2025 0.625 0.613 2,604.16 0.00 2,604.16 3136G4S61 50511 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 08/25/2025 0.660 0.648 2,750.00 0.00 2,750.00 3135GA3W9 50516 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 11/25/2025 0.600 0.589 1,250.00 0.00 1,250.00 3135G06V0 50564 100 FAC 3,000,000.00 2,989,760.59 2,990,332.63 08/28/2025 4.125 4.287 10,312.50 572.04 10,884.54 3135G03U5 50566 100 FAC 3,000,000.00 2,875,172.39 2,884,283.89 04/22/2025 0.625 4.371 1,562.50 9,111.50 10,674.00 3130APYK5 50540 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 03/14/2025 1.150 1.128 2,875.00 0.00 2,875.00 3130AQV26 50573 100 FAC 4,OOQ000.00 3,941,542.28 3,951,125.51 09/04/2024 1.610 4.466 5,366.67 9,583.23 14,949.90 3130AYXU5 50574 100 FAC 4,000,000.00 4,000,000.00 4,000,000.00 02/12l2029 4.450 4.366 14,833.33 0.00 14,833.33 3130ATAH0 50567 100 FAC 0.00 3,998,526.55 0.00 03/15(2024 3.640 4.653 5,662.22 1,473.45 7,135.67 3130ARYA3 50557 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 05(26/2027 4.000 3.925 10,000.00 0.00 10,000.00 3130ASQP7 50561 100 FAC 2,000,000.00 2,000,000.00 2,000,000.00 01/28/2025 3.625 3.557 6,041.67 0.00 6,041.67 3130ARPB1 50556 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 04/28/2027 3.500 3.434 14,583.33 0.00 14,583.33 3130APQ64 50537 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 11/23/2026 1.500 1.472 3,750.00 0.00 3,750.00 Portfolio CITY AC Run Date:05/09/2024-11:19 IE(PRF_IE)7.3.11 Report Ver.7.3.11 CITY OF REDDING Interest Earnings Page 2 March 1,2024-March 31,2024 Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Value Book Value Book Value Date Rate Yield Earned Accretion Earnings Fund:POOLED CASH 3130ALGJ7 50525 100 FAC 4,875,000.00 4,875,000.00 4,875,000.00 03/23/2026 1.000 0.981 4,062.50 0.00 4,062.50 3130AKPN0 50521 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 01/29(2026 0.60� 0.589 1,250.00 0.00 1,250.00 3130AKQ74 50520 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 01/22/2026 0.625 0.613 1,302.08 0.00 1,302.08 3130ALDN1 50526 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03/16/2026 0.800 0.785 3,333.34 0.00 3,333.34 3130ALXP4 50528 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 04/28l2026 1.200 1.177 2,500.00 0.00 2,500.00 3133ENSZ4 50553 100 FAC 2,500,000.00 2,500,000.00 2,500,000.00 04/01/2027 2.750 2.698 5,729.17 0.00 5,729.17 3133EN3M0 50569 100 FAC 2,000,000.00 2,003,044.44 2,002,711.11 12/05/2024 4.625 4.335 7,708.34 -333.33 7,375.01 3133ENDC1 50538 100 FAC 2,000,000.00 2,000,000.00 2,000,000.00 11/0312026 1.330 1.305 2,216.67 0.00 2,216.67 3133ENQV5 50550 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03/10/2025 1.870 1.835 7,791.67 0.00 7,791.67 3133EM6E7 50535 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 09/28(2026 0.94� 0.922 3,916.67 0.00 3,916.67 3133ENMZ0 50548 100 FAC 3,000,000.00 2,999,864.44 2,999,991.53 04(03/2024 1.200 1.227 3,000.00 127.09 3,127.09 3133ENMQ0 50547 100 FAC 3,000,000.00 2,996,584.62 2,996,893.23 02/03/2025 1.310 1.408 3,275.00 308.61 3,583.61 3134GW6C5 50549 100 FAC 2,000,000.00 1,948,750.71 1,950,357.27 10/28l2026 0.800 1.776 1,333.33 1,606.56 2,939.89 3134H1SK0 50575 100 FAC 4,000,000.00 3,976,399.45 3,976,838.67 02/09/2029 4.375 4.448 14,583.34 439.22 15,022.56 3134GXH56 50562 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 05/28/2025 4.000 3.925 10,000.00 0.00 10,000.00 3134GY6H0 50570 100 FAC 2,000,000.00 2,002,448.61 2,002,334.72 12/16/2025 5.500 5.323 9,166.66 -113.89 9,052.77 3134GXR89 50563 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 08/25/2027 4.375 4.293 10,937.50 0.00 10,937.50 3134GXYE8 50559 100 FAC 3,000,000.00 2,996,685.00 2,997,535.00 06l28(2024 3.10� 3.379 7,750.00 850.00 8,600.00 3134GXVF8 50558 100 FAC 3,000,000.00 3,000,000.00 3,000,000.00 12(23/2024 3.000 2.944 7,500.00 0.00 7,500.00 3134GWUG9 50546 100 FAC 735,000.00 723,936.79 724,526.31 09/24/2025 0.570 1.527 349.12 589.52 938.64 3134GW4C7 50555 100 FAC 3,000,000.00 2,850,395.61 2,855,090.31 10/27/2026 0.800 2.765 2,000.00 4,694.70 6,694.70 3134GXQV9 50554 100 FAC 4,150,000.00 4,150,000.00 4,150,000.00 04/25/2025 3.100 3.042 10,720.83 0.00 10,720.83 3134GW6C5 50552 100 FAC 3,000,000.00 2,871,021.84 2,875,065.05 10/28/2026 0.800 2.478 2,000.00 4,043.21 6,043.21 3134GXMT8 50551 100 FAC 5,000,000.00 5,000,000.00 5,000,000.00 03/2512025 2.250 2.208 9,375.00 0.00 9,375.00 594918BJ2 50515 100 MTN 5,000,000.00 5,200,706.06 5,190,704.09 11/03/2025 3.125 0.683 13,020.83 -10,001.97 3,018.86 037833BZ2 50543 100 MTN 5,000,000.00 5,082,542.07 5,079,705.57 08/04(2026 2.45� 1.708 10,208.33 -2,836.50 7,371.83 89114QCK2 50513 100 MTN 2,500,000.00 2,501,873.40 2,501,771.21 09(11/2025 0.750 0.687 1,562.50 -102.19 1,460.31 35981VAZ3 50512 100 MUN 1,870,000.00 1,879,132.43 1,878,625.07 09/01/2025 1.221 0.874 1,902.73 -507.36 1,395.37 Subtotal 178,130,000.00 181,833,471.14 177,850,370.80 1.371 192,316.40 16,899.66 209,216.06 Total 301,474,470.96 299,120,784.10 301,194,841.76 2.769 681,424.79 16,899.66 698,324.45 Portfolio CITY AC Run Date:05/09/2024-11:19 IE(PRF_IE)7.3.11 Report Ver.7.3.11 � � � � � � �, ���� CITY OF REDDING CITY OF REDDING Treasurer's ottice Amortization Schedule 777 Cypress Ave � � � � � � � � Redding, Redding,CA 96001 , � March 1, 2024 - March 31, 2024 (530)225-4199 Sorted By Security Type - Fund Investment# Maturity Date Beginning Par Value Amounts Amortized - Purchase Original Premium Ending qnd Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Value As of 03101/2024 This Period Through 03/31/2024 Through 03/31/2024 Medium Term Notes 50543 100 08/04/2026 5,000,000.00 5,154,400.00 154,400.00 5,079,705.57 -71,857.93 -2,836.50 -74,694.43 79,705.57 APPLE 2.450 82,542.07 50505 100 03/13/2025 5,000,000.00 5,424,313.81 424,313.81 5,080,799.18 -336,426.99 -7,087.64 -343,514.63 80,799.18 BANK OF AMERICA 3.450 87,886.82 50515 100 11/03/2025 5,000,000.00 5,594,450.00 594,450.00 5,190,704.09 -393,743.94 -10,001.97 -403,745.91 190,704.09 MICROSOFT 3.125 200,706.06 50513 100 09l11/2025 2,500,000.00 2,506,117.50 6,117.50 2,501,771.21 -4,244.10 -102.19 -4,346.29 1,771.21 Toronto Dominion Bank 0.750 1,873.40 Subtotal 18,679,281.31 1,179,281.31 17,852,980.05 -806,272.96 -20,028.30 -826,301.26 352,980.05 373,008.35 Federal Agency Coupon Securities 50547 100 02/03/2025 3,000,000.00 2,988,900.00 -11,100.00 2,996,893.23 7,684.62 308.61 7,993.23 -3,106.77 FEDERAL FARM CREDIT BANK 1.310 -3,415.38 50548 100 04/03/2024 3,000,000.00 2,996,700.00 -3,300.00 2,999,991.53 3,164.44 127.09 3,291.53 -8.47 FEDERAL FARM CREDIT BANK 1.200 -135.56 50569 100 12/05(2024 2,000,000.00 2,008,000.00 8,000.00 2,002,711.11 -4,955.56 -333.33 -5,288.89 2,711.11 FEDERAL FARM CREDIT BANK 4.625 3,044.44 50567 100 03/15/2024 4,000,000.00 3,946,640.00 -53,360.00 0.00 51,886.55 1,473.45 53,360.00 0.00 FED HOME�OAN BANK 3.640 -1,473.45 50573 100 09/04/2024 4,000,000.00 3,839,960.00 -160,040.00 3,951,125.51 101,582.28 9,583.23 111,165.51 -48,874.49 FED HOME LOAN BANK 1.610 -58,457.72 50546 100 09/24/2025 735,000.00 709,238.25 -25,761.75 724,526.31 14,698.54 589.52 15,288.06 -10,473.69 FED HOME�OAN MTG CORP 0.570 -11,063.21 50549 100 10/28/2026 2,000,000.00 1,908,908.00 -91,092.00 1,950,357.27 39,842.71 1,606.56 41,449.27 -49,642.73 FED HOME�OAN MTG CORP 0.800 -51,249.29 50552 100 10(28/2026 3,000,000.00 2,776,950.00 -223,050.00 2,875,065.05 94,071.84 4,043.21 98,115.05 -124,934.95 FED HOME�OAN MTG CORP 0.800 -128,978.16 50555 100 10l27/2026 3,000,000.00 2,743,200.00 -256,800.00 2,855,090.31 107,195.61 4,694.70 111,890.31 -144,909.69 FED HOME�OAN MTG CORP 0.800 -149,604.39 50559 100 06/28/2024 3,000,000.00 2,979,600.00 -20,400.00 2,997,535.00 17,085.00 850.00 1�,935.00 -2,465.00 FED HOME�OAN MTG CORP 3.100 -3,315.00 50570 100 12/16/2025 2,000,000.00 2,004,100.00 4,100.00 2,002,334.72 -1,651.39 -113.89 -1,765.28 2,334.72 FED HOME LOAN MTG CORP 5.500 2,448.61 50575 100 02/09/2029 4,000,000.00 3,973,720.00 -26,280.00 3,976,838.67 248.89 439.22 688.11 -25,591.89 FED HOME�OAN MTG CORP 4.375 -26,031.11 Portfolio CITY AC Run Date:05/09/2024-10:49 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 CITY OF REDDING Amortization Schedule Page 2 March 1,2024-March 31,2024 investment# Maturity Date Beginning Par Value Amounts Amortized Purchase Original Premium Ending And Unamortized Amount Amortized Amt Amortized Amount Unamortized Issuer Fund Amort.Date Current Rate Principal or Discount Book Vaiue As of 03101/2024 This Period Through 03/31/2024 Through 03/31/2024 Federal Agency Coupon Securities 50519 100 11/07/2025 5,000,000.00 5,002,129.00 2,129.00 5,000,709.67 -1,382.37 -36.96 -1,419.33 709.67 FEDERAL NAT�MTG ASSN 0.500 746.63 50564 100 08/28/2025 3,000,000.00 2,979,750.00 -20,250.00 2,990,332.63 10,010.59 572.04 10,582.63 -9,667.37 FEDERAL NATL MTG ASSN 4.125 -10,239.41 50566 100 04/22/2025 3,000,000.00 2,725,440.00 -274,560.00 2,884,283.89 149,732.39 9,111.50 158,843.89 -115,716.11 FEDERAL NAT�MTG ASSN 0.625 -124,827.61 Subtotal 43,583,235.25 -1,151,764.75 40,207,794.90 589,214.14 32,914.95 622,129.09 -529,635.66 -562,550.61 Treasury Coupon Securities 50522 100 02/28/2026 5,000,000.00 4,946,875.00 -53,125.00 4,979,681.51 31,904.11 902.40 32,806.51 -20,318.49 TREASURY NOTE 0.500 -21,220.89 50523 100 02/28/2026 5,000,000.00 4,926,562.50 -73,437.50 4,971,804.52 43,989.79 1,252.23 45,242.02 -28,195.48 TREASURY NOTE 0.50� -29,447.71 50527 100 03/31/2026 2,000,000.00 1,983,750.00 -16,250.00 1,993,512.46 9,486.58 275.88 9,762.46 -6,487.54 TREASURY NOTE 0.750 -6,763.42 50530 100 04/30/2026 5,000,000.00 4,975,000.00 -25,000.00 4,989,533.92 14,106.45 427.47 14,533.92 -10,466.08 TREASURY NOTE 0.750 -10,893.55 50534 100 08/31/2026 5,000,000.00 4,978,125.00 -21,875.00 4,989,433.87 10,937.50 371.37 11,308.87 -10,566.13 TREASURY NOTE 0.750 -10,937.50 50536 100 08l31/2026 5,000,000.00 4,943,750.00 -56,250.00 4,972,406.84 27,687.01 969.83 28,656.84 -27,593.16 TREASURY NOTE 0.750 -28,562.99 50541 100 12/31/2026 3,000,000.00 2,981,132.81 -18,867.19 2,989,597.66 8,143.66 321.19 8,464.85 -10,402.34 TREASURY NOTE 1.250 -10,723.53 Subtotai 29,735,195.31 -264,804.69 29,885,970.78 146,255.10 4,520.37 150,775.47 -114,029.22 -118,549.59 Municipal Bonds 50512 100 09(01/2025 1,870,000.00 1,897,414.20 27,414.20 1,878,625.07 -18,281.77 -507.36 -18,789.13 8,625.07 FULLERTON REDEVELOPMENT 1.221 9,132.43 Subtotal 1,897,414.20 27,414.20 1,878,625.07 -18,281.77 -507.36 -18,789.13 8,625.07 9,132.43 7otai 93,895,126.07 -209,873.93 89,825,370.80 -89,085.49 16,899.66 -72,185.83 -282,059.76 -298,959.42 Portfolio CITY AC Run Date:05/09/2024-10:49 AS(PRF_ASW)7.3.11 Report Ver.7.3.11 _::. � IT '� � � =- �� CITY OF REDDING __, � � "�' CITY OF REDDINCa ENTITIE.S Treas�rer's otr�� �C)rt'fO�IA M�t'!� �'�1'1�Tlf 777 Cypress Ave ` � Redding. Redciing,CA 96001 � � � I � � � � � �` Portfalio Summary t�3c�7�zs-a,ss ` ' March 31; 2024 Far Market Baok %of' Days to YTM Yi'M IttveS$tttePltS tPalue Value Vatue Portfalio Teem Maturity' 36Q Equiv. 965 Equiv: FSS Escrow Account 175,834.94 175,834.94 175;834.94 1.34 1 7 O.a10 4.010 Successnr Agency MM Accounc 980;1SOA& 98U.150.06 9$0,15Q:06 7;49 1 1 0:838 O.B50 LAIF-Local Agency Investment Fund 5,751;812.43 5,751,812.43' 5,751,812:43 43:95 1 1 4.232 4.297 C7vemight Swe2ps&DbA Accoqnts b,177;986:67 6:177;986.67 6,177;986;67 47,21 `! 1 0.591 O.S39 13;G1$5.784.10 13,0$5�7$4.10 13,�85.784.10 100,d4°la 1 1 2.202 2.233 Investments TotaB Earnings Ntarcfi 31 Month Ending Fiseal Year Ta Date Current Year 22.4d9.72 189,323A2 Average CtaiBy Balance 71,884,226.23 9,833.785.Q3 Effective Rate of Return 2.22%0 2.56°l0 � .�-.� �w�� �°`�����y GREG O INETT;CITY TRERSt112ER Reporting periad 4S/01/2024-03131/202d Portfolio ENTY CP Run Date:4511012024-1fi�40 ��'iPRF_PM1)7.3.11 Repqrt Ver.7_3:11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Interest Earnings Summary March 31, 2024 March 31Month Ending Fiscal Year To Date CD/Coupon/Discount Investments: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 �ess Accrued Interest at Beginning of Period ( 0.00) ( 0.00) �ess Accrued Interest at Purchase During Period ( 0.00) ( 0.00) Interest Earned during Period 0.00 0.00 Adjusted by Capital Gains or Losses 0.00 0.00 Earnings during Periods 0.00 0.00 Pass Through Securities: Interest Collected 0.00 0.00 Plus Accrued Interest at End of Period 0.00 0.00 �ess Accrued Interest at Beginning of Period ( 0.00) ( 0.00) �ess 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 1,504.65 182,087.09 Plus Accrued Interest at End of Period 63,778.67 63,778.67 �ess Accrued Interest at Beginning of Period ( 42,873.60) ( 56,542.74) Interest Earned during Period 22,409.72 189,323.02 Total Interest Earned during Period 22,409.72 189,323.02 Total Capital Gains or Losses 0.00 0.00 Total Earnings during Period 22,409.72 189,323.02 PortFolio ENTY CP Run Date:05/10/2024-16:40 PM(PRF_PM6)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Activity Summary March 2023 through March 2024 Yieid to Maturity Managed Number Number Month Number of Total 360 365 Pool of Investments of Investments Average Average End Year Securities Invested Equivaient Equivaient Rate Purchased Redeemed Term Days to Maturity March 2023 8 9,527,732.76 2.201 2.231 0.000 0 0 1 1 April 2023 8 9,455,553.26 2.251 2.282 0.000 0 0 1 1 May 2023 8 10,153,765.38 2.212 2.242 0.000 0 0 1 1 June 2023 8 9,833,667.42 2.387 2.420 0.000 0 0 1 1 July 2023 8 10,265,149.97 2.418 2.451 0.000 0 0 1 1 August 2023 8 8,428,358.46 2.681 2.718 0.000 0 0 1 1 September 2023 8 9,251,795.92 2.385 2.418 0.000 0 0 1 1 October 2023 8 9,447,318.50 2.447 2.481 0.000 0 0 1 1 November 2023 8 9,523,869.35 2.535 2.570 0.000 0 0 1 1 December 2023 8 9,820,957.61 2.529 2.564 0.000 0 0 1 1 January 2024 8 10,572,938.17 2.467 2.501 0.000 0 0 1 1 February 2024 8 11,844,174.30 2.318 2.350 0.000 0 0 1 1 March 2024 8 13,085,784.10 2.202 2.233 0.000 0 0 1 1 Average g 10,093,158.86 2.387% 2.420% 0.000 0 0 1 1 Portfolio ENTY CP Run Date:05/10/2024-16:40 PM(PRF_PM4)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Activity By Type March 1, 2024 through March 31, 2024 Beginning Stated Transaction Purchases Redemptions Ending CUSIP Investment# Issuer Balance Rate Date or Deposits or Withdrawals Balance FSS Escrow Account (Monthly Summary) 9442 5201 US BANK FSS ESCROW 0.010 6,214.18 13.59 Subtotal 169,634.35 6,214.18 13.59 175,834.94 Successor Agency MM Account (Monthly Summary) SYS6002 6002 US BANK SUCCESSOR AGENCY 0.850 152.10 93.88 Subtotal 980,091.84 152.10 93.88 980,150.06 LAIF-Local Agency Investment Fund Subtotai 5,751,812.43 5,751,812.43 Overnight Sweeps&DDA Accounts SYS5002 5002 US BANK HOUSING AUTHORITY 0.600 2,752,704.13 1,435,080.53 SYS 7002 7002 US BANK RABA 0.600 454,126.81 536,399.42 Subtotai 4,942,635.68 3,206,830.94 1,971,479.95 6,177,986.67 Totai 11,844,174.30 3,213,197.22 1,971,587.42 13,085,784.10 Portfolio ENTY CP Run Date:O5/10/2024-16:40 PM(PRF_PM3)7.3.11 Report Ver.7.3.11 CITY OF REDDING ENTITIES Portfolio Management Page 1 Portfolio Details - Investments March 31, 2024 Average Purchase Stated YTM Days to Maturity CUSIP Investment# Issuer Balance Date Par Value Market Value Book Vaiue Rate N�oody's 365 Maturity Date FSS Escrow Account 9442 5201 US BANK FSS ESCROW 175,834.94 175,834.94 175,834.94 0.010 0.010 1 Subtotai and Average 169,834.37 175,834.94 175,834.94 175,834.94 0.010 1 Successor Agency MM Account SYS6002 6002 US BANK SUCCESSOR AGENCY 980,150.06 980,150.06 980,150.06 0.850 0.850 1 Subtotai and Average 980,093.72 980,150.06 980,150.06 980,150.06 0.850 1 LAIF-Local Agency Investment Fund SYS6000 6000 LAIF-COR-Successor to RRA 04/01/2013 4,107,061.95 4,107,061.95 4,107,061.95 4.232 4291 1 SYS7000 7000 Local Agency I�v Fund RABA 04/01/2013 635,445.31 635,445.31 635,445.31 4.232 4.291 1 SYS5000 5000 Local Agency Inv Fund Housing 04/01/2013 1,009,305.17 1,009,305.17 1,009,305.17 4.232 4.291 1 Subtotai and Average 5,751,812.43 5,751,812.43 5,751,812.43 5,751,812.43 4.291 1 Overnight Sweeps&DDA Accounts SYS 7003 Cornersto�e Bank RABA Punch 01l01/2023 6,216.10 6,216.10 6,216.10 0.000 1 SYS5002 5002 US BANK HOUSING AUTHORITY 07/01(2019 3,236,497.54 3,236,497.54 3,236,497.54 0.600 0.600 1 SYS 7002 7002 US BANK RABA 07/01/2019 2,935,273.03 2,935,273.03 2,935,273.03 0.600 0.600 1 Subtotai and Average 4,982,485.71 6,177,986.67 6,177,986.67 6,177,986.67 0.599 1 Total and Average 11,884,226.23 13,085,784.10 13,085,784.10 13,085,784.10 2.233 1 Portfolio ENTY CP Run Date:05/10/2024-16:40 PM(PRF_PM2)7.3.11 Report Ver.7.3.11 � � � � � � � •�`���� CITY OF REDDING � ` CITY OF REDDING ENTITIES Treasurer's office Interest Earnings 777 Cypress Ave Redding, Redding,CA 96001 � � � � � � � � 1 � Sorted by Fund - Fund (530)225-4199 March 1, 2024- March 31, 2024 Yield on Beginning Book Value Adjusted Interest Earnings Security Ending Beginning Ending Maturity Current Annualized Interest Amortization/ Adjusted Interest CUSIP Investment# Fund Type Par Vaiue Book Value Book Value Date Rate Yieid Earned Accretion Earnings Fund: ENTITY GF SYS5000 5000 GF RRP 1,009,305.17 1,009,305.17 1,009,305.17 4.232 4.291 3,678.15 0.00 3,678.15 SYS6000 6000 GF RRP 4,107,061.95 4,107,061.95 4,107,061.95 4.232 4.291 14,967.13 0.00 14,967.13 SYS7000 7000 GF RRP 635,445.31 635,445.31 635,445.31 4.232 4.291 2,315.72 0.00 2,31572 SYS 7002 7002 GF RR2 2,935,273.03 3,017,545.64 2,935,273.03 0.600 0.256 654.88 0.00 654.88 9442 5201 GF PA1 175,834.94 169,634.35 175,834.94 0.010 0.093 13.45 0.00 13.45 SYS5002 5002 GF RR2 3,236,497.54 1,918,873.94 3,236,497.54 0.600 0.466 760.13 0.00 760.13 SYS6002 6002 GF PA2 980,150.06 980,091.84 980,150.06 0.850 0.024 20.26 0.00 20.26 SYS 7003 GF RR2 6,216.10 6,216.10 6,216.10 0.00 0.00 0.00 Subtotal 13,085,784.70 11,844,174.30 13,085,784.70 2.228 22,409.72 0.00 22,409.72 Totai 13,085,784.10 11,844,174.30 13,085,784.10 2.228 22,409.72 0.00 22,409.72 Portfolio ENTY CP Run Date:OS/1012024-16:43 IE(PRF_IE)7.3.11 Report Ver.7.3.11 � � � � � � ��a� � CITY OF REDDING ENTITIES CiT easu eEDOffi e Received Interest 777 Cypress Ave � � � � � � � � � � Sorted by Security Type Redding, Red�530)225-4099 vj Received March 1, 2024- March 31, 2024 Security Par Current Interest Security Type CUSIP Investment# Type Vaiue Rate Date Received Amount Received Cash Accounts FSS Escrow Account 9442 5201 PA1 169,634.35 0.010 03/31/2024 13.59 Subtotal 13.59 Successor Agency MM Account SYS6002 6002 PA2 980,091.84 0.850 03/31/2024 76.05 Subtotai 76.05 Overnight Sweeps&DDA Accounts SYS5002 5002 RR2 1,918,873.94 0.600 03/31/2024 760.13 SYS 7002 7002 RR2 3,017,545.64 0.600 03/31/2024 654.88 Subtotal 1,415.01 Total 1,504.65 Portfolio ENTY CP Run Date:05/10/2024-16:44 RI(PRF_RI)7.3.11 Report Ver.7.3.11 City of Redding, Entities Earnings History � $25,000 ��� �� � $20,000 �.� ,,r ,,a S�:� c„ �;�+ (1; $15,000 „�, $�s ' 1,, �. ..t, ; d' N t,>3 � : � O � 1.. .. h $10,000 N M O� �' � O� O ' 7 ��� � '�.n 0O � ��� :pp N N . a,� � �.. � �. ,:e- . d i`'� . d' �. � �. �!1 � � Co h @ � � � � �' �V.r7,0�� � O O� � �' . Oi � � .., �a ;>.t t� � ,,l'�':< �ti�a` �� ,• O ��00 OD �' ,�t #' � 3:}a . M � et 1`� t�� � � Y'1 y,,, �� t� v �� ��'` ��'�� 'o�` `Qe�' 'p�� a� �� or t�' � �� ��'` `°�` �a'�` `o'�`` `o`''�' �� �a� or Q �.� � � � � �,o fi fi � c� c � �� � � o, �,'� �,o �fi c� s t c P � �� � v '� c, �e �� �t� �U�U �� �Q` e�` �� �S Q,.� ��w �o ���, eG� ��t� ��� �a `Lo`L�'�,o`l'`Y�,o`l''L �La`L�o`L`�,otiL�'��p`Ln"o�,rL�o�,�Lp�p`y`��p�L���o�'`� `Lp`L �,oR'� �,0`1'� �Ln`L�b`�`�0�,�5�p`L3 o��r�o��4�p`L��o�LD� �o`L�` `L `l, `L `L `L `L < City of Redding, Entities Book Value History $14,000,000 ����$12,000,000 � � ��� $10,000,000 � ���� � <�� ��,� �_., � $8,00O,OOd m,,< 7� a�t,r�zF�� �a' ��� �'r�' �2�tth� �tg�'���:fi et ,,,sr:r' �i'r �}��y,�? lt�,,.� ;r t � �, � ; .. ,.,. ..�� .�, .� }"c4i tr dC � . � . $6,000,000 � ernn � ti <° � e° � crno � °' a' M er n �n r� m ,ui eo rn rn c�i co n, M OO h r . . � �. M N M P n M N � P EA . $4,000,000 w � v ' 0 00 a ao N � ,n o0 o Es, � � � � � � � � � � � � � s�r +P2�0�0�0�� � ,i t � „f� ,f,.�.g r;�.�t'� ��„{i. „f�t', irfi�: s�xri >ib<<;�+ �r�:. �-,y: ty<<��r,.� <<�Gi; '�V �a �'\ '�.. t�� ��. t � � ��. ��.a�� �ic�� ���` a� 3�� ���� �����` �e�`� G,�o'o� ��'�Q e�'�'� ���� �t�`�� �tor �� , �� �� �tS` �� ry"� �Q. �e� �p �oJ �eo ��� ���, e1` `Lo`y� `t'�� �'� `L�� `Lo`� `�'o `L�� O`1'`� `yo`t' O�'`� O`l'`� `yo`�' `Lo`�' �'��� ,, �1, �t, �t,