Cities Index.
Attachment 3- Investment Portfolio Management Summary Report. September 2024

Mayor and City Council
November 20, 2024

Document
Attachment 3- Investment Portfolio Management Summary Report. September 2024
Meeting
November 20, 2024
Body
Mayor and City Council
Pages
1
Original file
417 KB
Text extracted from the city's file for reading and search. Open the original on sanbernardino.primegov.com. That file is the official record.

HARDING

CITY OF SAN BERNARDINO

CITY OF SAN BERNARDINO FINANCE DEPARTMENT
290 N D. ST
Portfolio Management SAN BERNARDINO, CA 92401
Portfolio Summary (909)384-5242
SUNDED IN 019 September 30, 2024
Par Market Book % of Days to YTM YTM
Investments Value Portfolio Term Maturity 360 Equiv. 365 Equiv.

Value Value
State Local Agency Investment Fund 81,125,891.10 81,125,891.10 81.125,891.10 23.72 1 0.200 0.203 Certificates of Deposit 500,000.00 470,357.73 500,000.00 0.15 1,826 724 1.036 1.050 Federal Agency Issues - Coupon 69,000,000.00 66,581,380.00 68.974,311.01 20.17 1,571 482 1.222 1.239 Money Market Funds 162,746,879.91 162,746,879.91 162,746,879.91 47.59 1 1 0.010 0.010 Corporate Notes 22,125,000.00 21,014, 140.00 22,110,572.85 6.47 1,747 513 1.064 1.079 Supranationals 6,500.000.00 6,392,185.00 6,502,923.44 1.90 1,634 714 1.663 1.686 341,997,771.01 338,330,833.74 341,960,578.31 100.00% 464 146 0.401 0.406 Investments
Cash and Accrued Interest
(pastor chan yed calculations) 100,027.00 100,027.00 100,027.00 1 1 0.000 0.000 Accrued Interest at Purchase 10,720.10 40,720.10
Subtotal 140,747.10 140,747.10
Total Cash and Investments 342,097,798.01 338,471,580.84 342,101,325.41 464 146 0.401 0.406 Total Earnings September 30 Month Ending Fiscal Year To Date Current Year 117,980.99 1,689,506.47
Average Daily Balance 340,756,371.77 358,200,875.25
Effective Rate of Return 0.42% 1.87%
"I certify that this report accurately reflects all pooled investments and is in conformity with the Investment Policy Statement approved by the Mayor and City Council." *Book Value is amortized Cost Basis
**Market Values provided by BNY Western Trust.

Camari AN 10/21/24
Reporting period 09/01/2024-09/30/2024 Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22 IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
September 30, 2024
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date
State Local Agency Investment Fund
SYS 10001 LOCAL AGENCY INVESTMENT FUND 07/01/2022 39,559,307.08 39,559,307.08 39,559,307.08 0.203 0.200 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 41,566,584.02 41.566,584.02 41,566,584.02 0.203 0.200 Subtotal and Average 81,125,891.10 81,125,891.10 81,125,891.10 81,125,891.10 0.200 1 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 235,663.80 250,000.00 1.150 1.134 727 09/28/2026 90348JT59 80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 234,693.93 250,000.00 0.950 0.937 721 09/22/2026 Subtotal and Average 500,000.00 500,000.00 470,357.73 500,000.00 1.036 724 Managed Pool Accounts
20008 20008 CALTRUST GOVT INVESTMENT FUND 07/01/2022 0.00 0.00 0.00 0.160 0.158 Subtotal and Average 0.00 0.00 0.00 0.00 0.000 0
Federal Agency Issues - Coupon
3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1,000,000.00 978,910.00 999,932.81 0.320 Aaa 0.334 132 02/10/2025 3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 Aaa 1,958,820.00 2,000,000.00 0.480 0.473 153 03/03/2025
3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 977,290.00 1,000,000.00 0.710 Aaa 0.700 182 04/01/2025 3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00 972,680.00 1,000,000.00 0.730 Aaa 0.720 230 05/19/2025
3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 947,830.00 999,669.44 0.950 Aaa 0.957 602 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 969,990.00 1,000,000.00 0.650 Aaa 0.641 251 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 966,360.00 1,000.000.00 0.740 Aaa 0.730 293 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 958,860.00 999,503.85 0.550 Aaa 0.594 350 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 979,600.00 999,896.30 0.480 Aaa 0.502 132 02/10/2025 3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 938,680.00 999,425.00 0.870 Aaa 0.888 700 09/01/2026 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 977,840.00 999,865.08

0.560 Aaa 0.581 171 03/21/2025
3133ENBM1 30681 FEDERAL FARM CREDIT BANK 10/21/2021 993,360.00 999,947.22 0.630 0.716 20 10/21/2024 Aaa
3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 943,070.00 1,000,000.00 1,330 Aaa 1.312 763 11/03/2026 3133ЕМH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 945,440.00 995,564.12 0.900 Aaa 1.152 622 06/15/2026 31ЗЗЕМH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 945,440.00 994,951.22 0.900 Aaa 1.189 622 06/15/2026 3133ENFN5 30691 FEDERAL FARM CREDIT BANK 11/30/2021 945,640.00 1,000,000.00 1.540 1.519 790 11/30/2026 Aaa
3133ENGC8 30692 FEDERAL FARM CREDIT BANK 12/01/2021 954,450.00 1,000,000.00 1.320 Aaa 1.302 608 06/01/2026 3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 953,330.00 1,000,000.00 1.390 Aaa 1.371 629 06/22/2026 3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 938,770.00 1,000,000.00 1.290 Aaa 1.272 812 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 942,720.00 1,000,000.00 1.470 Aaa 1.450 832 01/11/2027 3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,900,820.00 2,000,000.00 0.750 Aaa 0.579 513 02/26/2026 Portfolio CITY
Run Date: 10/03/2024 - 12:22 AP
PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
September 30, 2024
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date
Federal Agency Issues - Coupon
3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 967,730.00 1,000,000.00 0.700 Aaa 0.690 266 06/24/2025 3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 989,380.00 1,000,000.00 0.600 Aaa 0.592 5911/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 978,040.00 999,942.00 0.650 Aaa 0.654 167 03/17/2025 3130ALV68 30620 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 951,810.00 1,000,000.00 1.030 Aaa 1.016 545 03/30/2026 3130AM4D1 30623 FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 974,130.00 1,000,000.00 0.750 Aaa 0.740 209 04/28/2025 3130AMLJ9 30632 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 957,960.00 1,000,000.00 0.810 Aaa 0.799 421 11/26/2025 3130AMK92 30633 FEDERAL HOME LOAN BANK 05/26/2021 1,000.000.00 989,910.00 1,000,000.00 0.550 Aaa 0.542 56 11/26/2024 3130AMMT6 30640 FEDERAL HOME LOAN BANK 06/10/2021 1,000,000.00 969,160.00 1,000,000.00 0.690 Aaa 0.681 252 06/10/2025 3130AMSY9 30643 FEDERAL HOME LOAN BANK 06/29/2021 1,000,000.00 965,030.00 1,000,000.00 0.800 Aaa 0.789 363 09/29/2025 3130AMTZ5 30645 FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 957,090.00 1,000,000.00 0.750 Aaa 0.740 423 11/28/2025 3130AMUD2 30653 FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 949,100.00 1,000,000.00 0.850 Aaa 0.838 545 03/30/2026 3130ANBU3 30654 FEDERAL HOME LOAN BANK 07/29/2021 1.000.000.00 973,700,00 1,000,000.00 0.700 Aaa 0.690 210 04/29/2025 3130ANJ35 30658 FEDERAL HOME LOAN BANK 1,000,000.00 1,000,000.00 0.700 Aaa 0.690 513 02/26/2026 3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 1,000,000.00 1.000 Aaa 0.986 695 08/27/2026 3130ANQJ2 30662 FEDERAL HOME LOAN BANK 08/25/2021 1,000,000.00 1,000,000.00 0.750 Aaa 0.740 359 09/25/2025 3130ANJU5 30668 FEDERAL HOME LOAN BANK 09/01/2021 1,000,000.00 999.965.55 0.520 Aaa 0.521 147 02/25/2025 3130AKN85 30669 FEDERAL HOME LOAN BANK 09/10/2021 1,000.000.00 950,960.00 997,637.08 0.550 Aaa 0.725 476 01/20/2026 3130AP4S1 30673 FEDERAL HOME LOAN BANK 09/30/2021 1,000.000.00 1,000,000.00 0.825 Aaa 0.814 455 12/30/2025 3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 938,360.00 1,000,000.00 1.000 Aaa 0.986 729 09/30/2026 3130APCH6 30675 FEDERAL HOME LOAN BANK 09/29/2021 1,000,000.00 940,900.00 1,000,000.00 1.125 Aaa 1.110 728 09/29/2026 3130APHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 1.250 Aaa 1.110 757 10/28/2026 3130APHT5 30678 FEDERAL HOME LOAN BANK 10/26/2021 1,000,000.00 1.200 Aaa 1.184 755 10/26/2026 3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 1.150 Aaa 1.134 757 10/28/2026 3130APJ22 30684 FEDERAL HOME LOAN BANK 11/08/2021 1,000,000.00 999,955.34 0.660 Aaa 0.710 27 10/28/2024 3130APWE1 30685 FEDERAL HOME LOAN BANK 11/30/2021 1,000,000.00 1,000,000.00 1.500 Aaa 1.479 785 11/25/2026 3130APVB8 30686 FEDERAL HOME LOAN BANK 11/2212021 1,000,000.00 973,270.00 1,000,000.00 1.000 Aaa 0.986 233 05/22/2025 3130APXP5 30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000,000.00 974,220.00 1,000,000.00 1.150 Aaa 1.134 234 05/23/2025 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 946,670.00 1,000,000.00 1.650 Aaa 1.627 820 12/30/2026 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 941,150.00 1,000,000.00 1.400 Aaa 1.381 820 12/30/2026 3130B06E4 30706 FEDERAL HOME LOAN BANK 02/26/2024 2,000,000.00 2,011,500.00 2,000,000.00 5.000 4.932 1,053 08/20/2027 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 968,170.00 1,000,000.00 0.650 Aaa 0.641 272 06/30/2025 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 956,850.00 998,189.58 0.700 Aaa 0.839 448 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 479,835.00 499,643.33 0.625 Aaa 0.691 349 09/15/2025 3134H1UK7 30707 FEDERAL HOME LOAN MORTGAGE CRP 02/26/2024 2,000,000.00 2,000,240.00 2,000,000.00 5.000 4.931 1,606 02/23/2029 31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,461,285.00 1,499,751.15 0.650 Aaa 0.670 209 04/28/2025 31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 972,290.00 997,240.76 0.675 Aaa 1.105 230 05/19/2025 Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22
PM (PRF_PM2) 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
September 30, 2024
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date
Federal Agency Issues - Coupon
31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 989,080.00 999,768.89 0.770 Aaa 0.888 66 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 965,000.00 1,000,000.00 0.600 Aaa 0.592 294 07/22/2025 3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 963,190.00 1,000,000.00 0.650 Aaa 0.641 317 08/14/2025 3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 960,020.00 0.540 391 10/27/2025 1,000,000.00 Aaa 0.533
3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 959,500.00 1,000,000.00 0.550 0.542 Aaa 399 11/04/2025
3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 960,790.00 993,462.29 0.560 Aaa 1.177 386 10/22/2025 3135GAPL9 30708 FEDERAL NATIONAL MORTGAGE ASSO 02126/2024 2,000,000.00 2,001,940.00 2,000,000.00 5.150 5.079 878 02/26/2027 Subtotal and Average 770,906,637.12 69,000,000.00 66,581,380.00 68,974,311.01

1.222 482
Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 162,746,879.91 162,746,879.91 162,746,879.91 0.010 0.010 - I-
Subtotal and Average 159,272,597.50 162,746,879.91 162,746,879.91 162,746,879.91 0.010 Corporate Notes
023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000,000.00 948,670.00 998,979.46 1.000 A1 1.051 588 05/12/2026 023135BQ8 30680 AMAZON.COM INC 10/19/2021 1,000,000.00 972,810.00 999,129.62 0.800 A1 0.919 245 06/03/2025
06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,893,920.00 1,998,750.00 0.850 A2 0.810 448 12/23/2025 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,419,000.00 1,486,387.20 0.750 A2 1.354 482 01/26/2026 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 937,560.00 1,000,000.00 1.250 604 05/28/2026 A2 1.233
14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1,000,000.00 995,060.00 1,004,188.42 3.250 A2 0.691 61 12/01/2024 14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,544,790.00 1,625,950.16 0.900 A2 0.846 517 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 945,200.00 1,000,547.56 1.050 A2 1.003 624 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 941,050.00 1,000,101.67 1.300 A2 1.277 742 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 945,200.00 994,541.87 1.050 A2 1.361 624 06/17/2026 38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 941,440.00 1,000,000.00 1.400 A2 1.381 623 06/16/2026 38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 934,720.00 1,000,000.00 1.450 A2 1.430 667 07/30/2026 48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 964,090.00 1,000,000.00 1.050 A2 1.036 265 06/23/2025 48128GV56 30595 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 953,470.00 1,000,000.00 0.800 A2 0.789 321 08/18/2025 48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,892,680.00 2,000,000.00 1.200 A2 1.184 576 04/30/2026 48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 933,760.00 1,000,000.00 1.150 A2 1.134 685 08/17/2026 89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 959,920.00 999,928.23 0.800 A1 0.796 380 10/16/2025 91324PEC2 30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 948,800.00 1,000,774.33 1.150 A3 1.086 591 05/15/2026 931142ER0 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 942,000.00 1.001.294.33 1.050 Aa2 0.969 716 0917/2026 Subtotal and Average 22,444,339.60 22,125,000.00 21,014,140.00 22,110,572.85 1.064 513 Portfolio CITY
Run Date: 10/03/2024 - 12:22 AP
PM (PRF_PM2) 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
September 30, 2024
Average Purchase Stated YTM Daysto Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date
Supranationals
4581X0EN4 30713 FIDELITY INSTL GOVT 657 02/26/2024 2,000,000.00 2,025,780.00 2,000,000.00 4.125 4.068 1,598 02/15/2029 459058HT3 30609 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,481,685.00 1,505, 110.63 1.625 Aaa 0.434 106 01/15/2025 459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 974,620.00 1,000,341.91 0.625 Aaa 0.555 203 04/22/2025 459058JS3 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 949,500.00 997,470.90 0.650 Aaa 0.829 497 02/10/2026 45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 960,600.00 1.000.000000 0.750 Aaa 0.642 591 05/15/2026 Subtotal and Average 6,503,572.22 6,500,000.00 6,392,185.00 6,502,923.44 1.663 714 Total and Average 340,756,371.77 341,997,771.01 338,330,833.74 341,960,578.31 0.401 146 Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22
PM (PRF_PM2) 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Cash
September 30, 2024
Average Purchase Stated YTM Days to
CUSIP Investment# Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Passbook/Checking Accounts
SYS10002 10002 WELLS FARGO BANK 07/01/2022 100,027.00 100,027.00 100,027.00 0.000 1 Average Balance 0.00 Accrued Interest at Purchase 40,720.10 40,720.10 1 Subtotal 140,747.10 140,747.10
Total Cash and Investments 340,756,371.77 342,097,798.01 338,471,580.84 342, 101,325.41 0.401 146 Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22
PM (PRF_PM2) 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management

Page 1 ends

Activity By Type
September 1, 2024 through September 30, 2024
Stated Transaction Purchases Redemptions
CUSIP Investment # Issuer Rate Date or Deposits or Withdrawal Balance State Local Agency Investment Fund (Monthly Summary)
Subtotal 81,125,891.10
Certificates of Deposit
Subtotal 500,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
3130AP4R3 30671 FEDERAL HOME LOAN BANK 0.500 09/30/2024 1,000,000.00 3130AQBH5 30695 FEDERAL HOME LOAN BANK 1.100 09/30/2024 1,000,000.00 Subtotal 0.00 2,000,000.00 68,974,311.01
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 15,175,799.82 11,581,714.57 Subtotal 15,175,799.82 11,581,714.57 162,746,879.91
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 43,596,653.03 43,496,626.03 Subtotal 43,596,653.03 43,496,626.03 0.00
Corporate Notes
037833DM9 30561 APPLE INC 1.800 09/11/2024 0.00 1,000,000.00 Subtotal 0.00 1,000,000.00 22,110,572.85
Supranationals
Subtotal 6,502,923.44
Total 58,772,452.85 58,078,340.60 341,960,578.31
Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
September 2023 through September 2024
Yield to Maturity Number
Number
Number of 360 365 of Investment of Investments Average
End Securities Equivalent Equivalent 'urchaser
Redeemed Days to Maturity
118 321,937,855.76 0.362 0.367
118 323,041,925.84 0.360 0.365 1
117 320,178,429.38 0.362 0.368 0 1
116 327,063,582.50 0.348 0.353 3
113 342,446,651.22 0.327 0.331 2
111 342,540,656.88 0.324 0.329 0
110 348,821,805.89 0.315 0.320 0 3
111 364,146,715.85 0.405 0.411 0 1 181
106 378,848,930.32 0.283 0.287 135
106 386,813,697.68 0.368 0.373 153
101 347,715,257.09 0.408 0.413 161
100 341,366,643.61 0.411 0.406 155
98 341,960,578.31 0.401 146
110 345,144,825.41 0.360% 0.365% 2 181
Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22 PM (PRF PM4) 7.3.11
Report Ver. 7.3.11

CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
September 30, 2024
September 30Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:

Interest Collected 2,577,001.03 2,886,704.06
Plus Accrued Interest at End of Period -2,155,200.25 -2,155,200.25 Less Accrued Interest at Beginning of Period 318,514.13) 417,522.43) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 103,286.65 313,981.38
Adjusted by Premiums and Discounts -150.55 -521.38
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 103,136.10 313,460.00
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 655,940.22 3,038,250.80
Plus Accrued Interest at End of Period -98,289.48 -98,289.48 Less Accrued Interest at Beginning of Period 542,805.85) 1,563,914.85) Interest Earned during Period 14,844.89 1,376,046.47
Total Interest Earned during Period 118,131.54 1,690,027.85 Total Adjustments from Premiums and Discounts -150.55 -521.38 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 117,980.99 1,689,506.47
Portfolio CITY
AP
Run Date: 10/03/2024 - 12:22 PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11

← All documents from this meeting