CITY OF SAN BERNARDINO
CITY OF SAN BERNARDINO FINANCE DEPARTMENT
Portfolio Management 290 N D. ST
SAN BERNARDINO, CA 92401
Portfolio Summary (909)384-5242
CONDEMN ANY October 31, 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 82,087,958.10 82,087,958.10 82,087,958.10 23.59 1 0.200 0.203 Certificates of Deposit 500,000.00 472,948.98 500,000.00 0.14 1,826 693 1.036 1.050 Federal Agency Issues - Coupon 67,000,000.00 64,981,095.00 66,976,363.60 19.25 1,585 464 1.237 1.254 Money Market Funds 169,731,596.57 169,731,596.57 169,731,596.57 48.79 1 1 0.010 0.010 Corporate Notes 22,125,000.00 21,126,517.50 22,109,673.96 6.36 1,747 482 1.064 1.079 Supranationals 6,500,000.00 6,431,860.00 6,501,532.95 1.87 1,634 683 1.663 1.686 347,944,554.67 344,831,976.15 347,907,125.18 100.00% 450 135 0.390 0.396 Investments
Cash and Accrued Interest
Passbook/Checking 25,412,092.00 25,412,092.00 25,412,092.00 1 0.000 0.000 Accined enterest a please)
40,720.10 40,720.10
Subtotal 25,452,812.10 25,452,812.10
Total Cash and Investments 373,356,646.67 370,284,788.25 373,359,937.28 450 135 0.390 0.396 Total Earnings October 31 Month Ending Fiscal Year To Date Current Year 116,579.03 3,396,983.10
Average Daily Balance 343,177,094.31 354,414,393.87
Effective Rate of Return 0.40% 2.84%
"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.
CATHA FAN FORETIMIEINERN DIRECTOR OF INANCE & MENT 11118/24 Reporting period 10/01/2024-10/31/2024 Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32 IE (PRF PM1) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Portfolio Details - Investments
October 31, 2024
Average Purchase Stated YTM Days to Maturity
CUSIP Investment# Issuer Balançe 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 40,028,438.49 40,028,438.49 40,028,438.49 0.203 SYS10003 0.200
10003 LOCAL AGENCY INVESTMENT FUND 07/01/2022 42,059,519.61 42,059,519.61 42,059,519.61 0.203 0.200 Subtotal and Average 81,684,510.65 82,087,958.10 82,087,958.10 82,087,958.10 0.200 1 Certificates of Deposit
856285XL0 80057 STATE BANK OF INDIA 09/28/2021 250,000.00 236,005.13 250,000.00 1.150 90348JT59 1,134 696 09/28/2026
80056 UBS FINANCE COMMERCIAL PAPER 09/22/2021 250,000.00 236,943.85 250,000.00 0.950 0.937 690 09/22/2026 Subtotal and Average 500,000.00 500,000.00 472,948.98 500,000.00 1.036 693 Managed Pool Accounts
20008 20008 CALTRUST GOVT INVESTMENT FUND 07/01/2022 0.00 0.00 0.00 0.160 0.158 1 Subtotal and Average 0.00 0.00 0.00 0.00
0.000
Federal Agency Issues - Coupon
3133EMQGO 30605 FEDERAL FARM CREDIT BANK 02/10/2021 1.000.000.00 984,060.00 999,948.44 0.320 101 02/10/2025 Aaa 0.334
3133EMSC7 30608 FEDERAL FARM CREDIT BANK 03/03/2021 2,000,000.00 1,968,300.00 2,000,000.00 0.480 0.473 122 03/03/2025 Aaa
3133EMUP5 30613 FEDERAL FARM CREDIT BANK 04/01/2021 1,000,000.00 982,510.00 1,000,000.00 0.710 Aaa 0.700 151 04/01/2025
3133EMZW5 30630 FEDERAL FARM CREDIT BANK 05/19/2021 1,000,000.00 978,010.00 0.730 1,000,000.00 Aaa 0.720 19905/19/2025
3133EMB76 30634 FEDERAL FARM CREDIT BANK 05/26/2021 1,000,000.00 953,030.00 999,686.11 0.950 Aaa 0.957 571 05/26/2026 3133EMF98 30642 FEDERAL FARM CREDIT BANK 06/09/2021 1,000,000.00 975,480.00 1,000,000.00 0.650 Aaa 0.641 220 06/09/2025 3133EMU91 30655 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 972,050.00 1,000,000.00 0.740 Aaa 0.730 262 07/21/2025 3133EL7K4 30656 FEDERAL FARM CREDIT BANK 07/21/2021 1,000,000.00 967,140.00 999,546.99 0.550 Aaa 0.594 319 09/16/2025 3133EMZ70 30664 FEDERAL FARM CREDIT BANK 08/26/2021 1,000,000.00 984,620.00 999,920.42 0.480 101 02/10/2025 Aaa 0.502
3133EM3T7 30665 FEDERAL FARM CREDIT BANK 09/01/2021 1,000,000.00 945,680.00 999,450.00 0.870 Aaa 0.888 669 09/01/2026 3133EM5VO 30672 FEDERAL FARM CREDIT BANK 09/21/2021 1,000,000.00 982,750.00 999,888.89 0.560 Aaa 0.581 140 03/21/2025 3133ENDC1 30682 FEDERAL FARM CREDIT BANK 11/03/2021 1,000,000.00 950,390.00 1,000,000.00 1,330 732 11/03/2026 Aaa 1.312
3133EMH21 30683 FEDERAL FARM CREDIT BANK 11/04/2021 1,000,000.00 952,340.00 995,780.85 0.900 Aaa 591 06/15/2026
1.152
3133EMH21 30689 FEDERAL FARM CREDIT BANK 11/22/2021 1,000,000.00 952,340.00 995,197.91 0.900 Aaa 1.189 591 06/15/2026 3133ENFN5 30691 FEDERAL FARM CREDIT BANK 11/30/2021 1,000,000.00 952,840.00 1,000,000.00 1.540 Aaa 1.519 759 11/30/2026 3133ENGC8 30692 12/01/2021 1,000,000.00 961,900.00 1,000,000.00 1.320 Aaa 1.302 577 06/01/2026
3133ENHV5 30699 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 959,900.00 1,000,000.00 1,390 1.371 Aaa 598 06/22/2026
3133ENJC5 30700 FEDERAL FARM CREDIT BANK 12/22/2021 1,000,000.00 946,210.00 1,000,000.00 1.290 Aaa 1.272 781 12/22/2026 3133ENKG4 30703 FEDERAL FARM CREDIT BANK 01/11/2022 1,000,000.00 950,030.00 1,000,000.00 1.470 Aaa 1.450 801 01/11/2027 3130AL6L3 30606 FEDERAL HOME LOAN BANK 02/26/2021 2,000,000.00 1,920,060.00 2,000,000.00 0.750 Aaa 0.579 482 02/26/2026 3130ALLAO 30610 FEDERAL HOME LOAN BANK 03/24/2021 1,000,000.00 973,410.00 1,000,000.00 0.700 Aaa 0.690 235 06/24/2025 Portfolio CITY
Run Date: 11/12/2024 - 14:32 AP
PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 2
Portfolio Details - Investments
October 31, 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
3130ALRM8 30614 FEDERAL HOME LOAN BANK 03/29/2021 1,000,000.00 993,670.00 1,000,000.00 0.600 Aaa 0.592 28 11/29/2024 3130ALLP7 30617 FEDERAL HOME LOAN BANK 03/26/2021 1,000,000.00 982,950.00 999,952.48 0.650 Aaa 0.654 136 03/17/2025 3130ALV68 30620 FEDERAL HOME LOAN BANK 03/30/2021 1,000,000.00 958,610.00 1,000,000.00 1.030 Aaa 1.016 514 03/30/2026 3130AM4D1 30623 FEDERAL HOME LOAN BANK 04/28/2021 1,000,000.00 979,320.00 1,000,000.00 0.750 Aaa 0.740 178 04/28/2025 3130AML.J9 30632 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 964,460.00 1,000,000.00 0.810 Aaa 0.799 390 11/26/2025 3130AMK92 30633 FEDERAL HOME LOAN BANK 05/26/2021 1,000,000.00 993,650.00 1,000,000.00 0.550 Aaa 0.542 25 11/26/2024 3130AMMT6 30640 FEDERAL HOME LOAN BANK 06/10/2021 1,000,000.00 974,730.00 1,000,000.00 0.690 Aaa 0.681 221 06/10/2025 3130AMSY9 30643 FEDERAL HOME LOAN BANK 06/29/2021 1,000,000.00 971,070.00 1,000,000.00 0.800 Aaa 0.789 332 09/29/2025 3130AMTZ5 30645 FEDERAL HOME LOAN BANK 06/28/2021 1,000,000.00 963,640.00 1,000,000.00 0.750 Aaa 0.740 392 11/28/2025 3130AMUD2 30653 FEDERAL HOME LOAN BANK 07/13/2021 1,000,000.00 955,870.00 1,000,000.00 0.850 Aaa 0.838 514 03/30/2026 3130ANBU3 30654 FEDERAL HOME LOAN BANK 07/29/2021 1,000,000.00 978,930.00 1,000,000.00 0.700 Aaa 0.690 179 04/29/2025 3130ANJ35 30658 FEDERAL HOME LOAN BANK 08/26/2021 1,000,000.00 959,370.00 1,000,000.00 0.700 Aaa 0.690 482 02/26/2026 3130ANKG4 30659 FEDERAL HOME LOAN BANK 08/27/2021 1,000,000.00 947,880.00 1,000,000.00 1.000 Aaa 0.986 664 08/27/2026 3130ANQJ2 30662 FEDERAL HOME LOAN BANK 08/25/2021 1,000.000.00 970.860.00 1,000,000.00 0.750 Aaa 0.740 328 09/25/2025 3130ANJU5 30668 FEDERAL HOME LOAN BANK 09/01/2021 1,000,000.00 984.000.00 999,972.73 0.520 Aaa 0.521 116 02/25/2025 3130AKN85 30669 FEDERAL HOME LOAN BANK 09/10/2021 1,000.000.00 957.830.00 997,788.22 0.550 Aaa 0.725 445 01/20/2026 3130AP4S1 30673 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 961,680.00 1,000,000.00 0.825 Aaa 0.814 424 12/30/2025 3130AP6D2 30674 FEDERAL HOME LOAN BANK 09/30/2021 1,000,000.00 945,830.00 1,000,000.00 1.000 Aaa 0.986 698 09/30/2026 3130APCH6 30675 FEDERAL HOME LOAN BANK 09/29/2021 1,000,000.00 949,230.00 1,000,000.00 1.125 Aaa 1.110 697 09/29/2026 3130APHA6 30676 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 951,310.00 1,000,000.00 1.250 Aaa 1.110 726 10/28/2026 3130APHT5 30678 FEDERAL HOME LOAN BANK 10/26/2021 1,000,000.00 948,770.00 1,000,000.00 1.200 Aaa 1.184 724 10/26/2026 3130APGP4 30679 FEDERAL HOME LOAN BANK 10/28/2021 1,000,000.00 947,640.00 1,000,000.00 1,150 Aaa 1.134 726 10/28/2026 3130APWE1 30685 FEDERAL HOME LOAN BANK 11/30/2021 1,000,000.00 944,570.00 1,000,000.00 1.500 Aaa 1.479 754 11/25/2026 3130APVB8 30686 FEDERAL HOME LOAN BANK 11/22/2021 1,000,000.00 978,550.00 1,000,000.00 1.000 Aaa 0.986 202 05/22/2025 3130APXP5 30688 FEDERAL HOME LOAN BANK 11/23/2021 1,000,000.00 979,330.00 1,000,000.00 1,150 Aaa 1.134 203 05/23/2025 3130AQBE2 30694 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 953,900.00 1,000,000.00 1.650 Aaa 1.627 789 12/30/2026 3130AQET6 30701 FEDERAL HOME LOAN BANK 12/30/2021 1,000,000.00 948,550.00 1,000,000.00 1,400 Aaa 1.381 789 12/30/2026 3130B06E4 30706 FEDERAL HOME LOAN BANK 02/26/2024 2,000,000.00 2,017,000.00 2,000,000.00 5.000 4.932 1,022 08/20/2027 3134GVT99 30581 FEDERAL HOME LOAN MORTGAGE CRP 06/30/2020 1,000,000.00 974,480.00 1,000,000.00 0.650 Aaa 0.641 241 06/30/2025 3134GXHD9 30615 FEDERAL HOME LOAN MORTGAGE CRP 03/24/2021 1,000,000.00 960,680.00 998,312.46 0.700 Aaa 0.839 417 12/23/2025 3134GWB70 30663 FEDERAL HOME LOAN MORTGAGE CRP 08/19/2021 500,000.00 484,075.00 499,674.43 0.625 Aaa 0.691 318 09/15/2025 3134H1UK7 30707 FEDERAL HOME LOAN MORTGAGE CRP 02/26/2024 2,000,000.00 2,001,360.00 2,000,000.00 5.000 4.931 1,575 02/23/2029 31422BYS3 30650 FARMER MAC 06/23/2021 1,500,000.00 1,470,060.00 1,499,787.22 0.650 Aaa 0.670 178 04/28/2025 31422BA26 30690 FARMER MAC 11/23/2021 1,000,000.00 977,670.00 997,603.82 0.675 Aaa 1.105 199 05/19/2025 31422XQV7 30693 FARMER MAC 12/06/2021 1,000,000.00 992,690.00 999,875.56 0.770 Aaa 0.888 35 12/06/2024 3136G4ZF3 30585 FEDERAL NATIONAL MORTGAGE ASSO 07/22/2020 1,000,000.00 970,800.00 1,000,000.00 0.600 Aaa - 0.592 263 07/22/2025 Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 3
Portfolio Details - Investments
October 31, 2024
Average Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Date Par Value Market Value Book Value Balance Rate Moody's 360 Maturity Date
Federal Agency Issues - Coupon
3136G4C43 30588 FEDERAL NATIONAL MORTGAGE ASSO 08/14/2020 1,000,000.00 969,780.00 1,000,000.00 0.650 Aaa 0.641 286 08/14/2025
3136G45C3 30600 FEDERAL NATIONAL MORTGAGE ASSO 10/27/2020 1,000,000.00 966,450.00 1,000,000.00 0.540 0.533 360 10/27/2025 Aaa
3135GA2N0 30602 FEDERAL NATIONAL MORTGAGE ASSO 11/04/2020 1,000,000.00 965,880.00 1,000,000.00 0.550 Aaa 0.542 368 11/04/2025 3135G06B4 30697 FEDERAL NATIONAL MORTGAGE ASSO 12/15/2021 1,000,000.00 967,140.00 993,977.07 0.560 : 10/22/2025 3135GAPL9 Aaa 1.177 355
30708 FEDERAL NATIONAL MORTGAGE ASSO 02/26/2024 2,000,000.00 2,003,730.00 5.150 5.079 847 02/26/2027 2,000,000.00
Subtotal and Average 68,491,543.23 67,000,000.00 64,981,095.00 66,976,363.60 1.237 464
Money Market Funds
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 07/01/2022 169,731,596.57 169,731,596.57 169,731,596.57
0.010 0.010 1
Subtotal and Average 162,972,193.35 169,731,596.57 169,731,596.57 169,731,596.57 0.010 1 Corporate Notes
023135BX3 30628 AMAZON.COM INC 05/13/2021 1,000,000.00 956,030.00 999,032.15 1.000 1.051 023135BQ8 A1 557 05/12/2026
30680 AMAZON.COM INC 10/19/2021 1,000,000.00 976,600.00 999,237.52 0.800 A1 0.919 214 06/03/2025 06048WK66 30603 BANK OF AMERICA CORPORATION 01/25/2021 2,000,000.00 1,896,140.00 1,998,834.84 0.850 A2 0.810 417 12/23/2025 06048WK82 30622 BANK OF AMERICA CORPORATION 04/14/2021 1,500,000.00 1,413,405.00 1,487,246.95 0.750 A2 1.354 451 01/26/2026 06048WM31 30637 BANK OF AMERICA CORPORATION 05/28/2021 1,000,000.00 947,370.00 1,000,000.00 1.250 A2 1.233 573 05/28/2026 14912L6G1 30624 CATERPILLAR FINL SERVICE 04/26/2021 1,000,000.00 996,600.00 1,002,094.21 3.250 A2 0.691 30 12/01/2024 14913R2K2 30660 CATERPILLAR FINL SERVICE 08/09/2021 1,625,000.00 1,558,342.50 1,625,894.37 0.900 A2 0.846 486 03/02/2026 24422EVR7 30648 JOHN DEERE CAPITAL CORP 06/17/2021 1,000,000.00 952,900.00 1,000,520.89 1.050 A2 1.003 593 06/17/2026 24422EVW6 30677 JOHN DEERE CAPITAL CORP 10/13/2021 1,000,000.00 948,080.00 1,000,097.50 1.300 A2 1.277 711 10/13/2026 24422EVR7 30687 JOHN DEERE CAPITAL CORP 11/17/2021 1,000,000.00 952,900.00 994,807.68 1.050 593 06/17/2026 A2 1.361
38150AG82 30646 GOLDMAN SACHS GROUP INC. 06/16/2021 1,000,000.00 946,120.00 1,000,000.00 1.400 A2 1.381 592 06/16/2026
38150AGW9 30657 GOLDMAN SACHS GROUP INC. 07/30/2021 1,000,000.00 938,330.00 1,000,000.00 1,450 A2 1.430 636 07/30/2026 48128GU40 30582 J.P. MORGAN CHASE & CO 06/23/2020 1,000,000.00 968,830.00 1,000,000.00 1.050 234 06/23/2025 A2 1.036
48128GV56 30595 J.P. MORGAN CHASE & CO 08/18/2020 1,000,000.00 958,860.00 1,000,000.00 0.800 A2 0.789 290 08/18/2025
48128G3G3 30625 J.P. MORGAN CHASE & CO 04/30/2021 2,000,000.00 1,904,640.00 2,000,000.00 1.200 A2 1.184 545 04/30/2026 48128G4R8 30661 J.P. MORGAN CHASE & CO 08/17/2021 1,000,000.00 940,390.00 1,000,000.00 1.150 A2 1.134 654 08/17/2026 89236THP3 30607 TOYOTA MOTOR CREDIT CORP 02/24/2021 1,000,000.00 965,370.00 999,933.97 0.800 A1 349 10/16/2025 91324PEC2 0.796
30629 UNITEDHEALTH GROUP INC 05/20/2021 1,000,000.00 956,060.00 1,000,734.55 1.150 A3 1.086 560 05/15/2026 931142ER0 30670 WAL-MART STORES NOTE 09/17/2021 1,000,000.00 949,550.00 1,001.239.33 1.050 Aa2 0.969 685 09/17/2026 Subtotal and Average 22,110,094.40 22,125,000.00 21,126,517.50 22,109,673.96 1.064 482 Portfolio CITY
Run Date: 11/12/2024 - 14:32 AP
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 4
Portfolio Details - Investments
October 31, 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
Supranationals
4581X0EN4 30713 FIDELITY INSTL GOVT 657 02/26/2024 2,000,000.00 2,038,400.00 2,000,000.00 4.125 4.068 1,567 02/15/2029 459058HT3 30609 INTL BK RECON & DEVELOPMENT 02/26/2021 1,500,000.00 1,486,770.00 1,503,616.01 1.625 Aaa 0.434 75 01/15/2025 459058JB0 30635 INTL BK RECON & DEVELOPMENT 05/27/2021 1,000,000.00 979,510.00 1,000,290.88 0.625 Aaa 0.555 172 04/22/2025 459058JS3 30667 INTL BK RECON & DEVELOPMENT 08/31/2021 1,000,000.00 959,630.00 997,626.06 0.650 Aaa 0.829 466 02/10/2026 45950VPY6 30631 INTL FINANCE CORP 05/28/2021 1,000,000.00 967,550.00 1,000,000.00 0.750 Aaa 0.642 560 05/15/2026 Subtotal and Average 6,502,207.45 6,500,000.00 6,431,860.00 6,501,532.95 1.663 683 Total and Average 343,177,094.31 347,944,554.67 344,831,976.15 347,907,125.18 0.390 135 Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 5
Portfolio Details - Cash
October 31, 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 25,412,092.00 25,412,092.00 25,412,092.00
0.000 1
Average Balance 0.00 Accrued Interest at Purchase 40,720.10 40,720.10 1 Subtotal 25,452,812.10 25,452,812.10
Total Cash and Investments 343,177,094.31 373,356,646.67 370,284,788.25 373,359,937.28 0.390 135 Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32
PM (PRF_PM2) 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management
Activity By Type
October 1, 2024 through October 31, 2024
Stated Transaction Purchases Redemptions
CUSIP Investment# Issuer Rate Date or Deposits or Withdrawals Balance State Local Agency Investment Fund (Monthly Summary)
SYS 10001 LOCAL AGENCY INVESTMENT FUND 0.203 469,131.41 0.00 SYS10003 10003 LOCAL AGENCY INVESTMENT FUND 0.203 492,935.59 0.00 Subtotal 962,067.00 0.00 82,087,958.10
Certificates of Deposit
Subtotal 500,000.00
Managed Pool Accounts (Monthly Summary)
Subtotal 0.00
Federal Agency Issues - Coupon
3133ENBM1 30681 FEDERAL FARM CREDIT BANK 0.630 10/21/2024 0.00 1,000,000.00 3130APJ22 30684 FEDERAL HOME LOAN BANK 0.660 10/28/2024 0.00 1,000,000.00 Subtotal 0.00 2,000,000.00 66,976,363.60
Money Market Funds (Monthly Summary)
SYS20002 20002 WELLS FARGO GOVT MONEY MARKET 0.010 18,202,299.36 11,217,582.70 Subtotal 18,202,299.36 11,217,582.70 169,731,596.57
Passbook/Checking Accounts (Monthly Summary)
SYS10002 10002 WELLS FARGO BANK 64,595,049.35 39,282,984.35 Subtotal 64,595,049.35 39,282,984.35 0.00
Corporate Notes
Subtotal 22,109,673.96
Supranationals
Subtotal 6,501,532.95
Total 83,759,415.71 52,500,567.05 347,907,125.18
Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32 PM (PRF_PM3) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Activity Summary
October 2023 through October 2024
Yield to Maturity Number
Number
Tota 360 365 of Investments of Investments
Invested Equivalent Equivalent Purchased
Redeemed Days
118 323,041,925.84 0.360 0.365 1
117 320,178,429.38 0.362 0.368 1
327,063,582.50 0.348 0.353 3
342,446,651.22 0.327 0.331 2
342,540,656.88 0.324 0.329 1
348,821,805.89 0.315 0.320 3
364,146,715.85 0.405 0.411 0 1
378,848,930.32 0.283 0.287
386,813,697.68 0.368 0.373 5
July 347,715,257.09 0.408 0.413
1 341,366,643.61 0.411 0.417
341,960,578.31 0.401 0.406
95 347,907,125.18 0.390 0.396
108 347,142,461.52 0.362% 0.367% 2
Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32
PM (PRF_PM4) 7.3.11
Report Ver. 7.3.11
CITY OF SAN BERNARDINO
Portfolio Management Page 1
Interest Earnings Summary
October 31, 2024
October 31Month Ending Fiscal Year To Date
CD/Coupon/Discount Investments:
Interest Collected 74,262.71 463,466.77
Plus Accrued Interest at End of Period 360,385.42 369,385.42 Less Accrued Interest at Beginning of Period 333,299.75) • C 417,522.43) Less Accrued Interest at Purchase During Period 0.00) 0.00) Interest Earned during Period 101,348.38 415,329.76
Adjusted by Premiums and Discounts -236.79 -758.17
Adjusted by Capital Gains or Losses 0.00 0.00
Earnings during Periods 101,111.59 414,571.59
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 1,633,661.10 4,671,911.90
Plus Accrued Interest at End of Period -125,585.54 -125,585.54 Less Accrued Interest at Beginning of Period 1,492,608.12) ( 1,563,914.85) Interest Earned during Period 15,467.44 2,982,411.51
Total Interest Earned during Period 116,815.82 3,397,741.27 Total Adjustments from Premiums and Discounts -236.79 -758.17 Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 116,579.03 3,396,983.10
Portfolio CITY
AP
Run Date: 11/12/2024 - 14:32
PM (PRF_PM6) 7.3.11
Report Ver. 7.3.11