City of Manhattan Beach
Finance Department
\I.Iii ) \ ."I
'NiNC
Investment Portfolio
June 2024
As Finance Director for the City of Manhattan Beach, I hereby certify that these investments are in compliance with the City's investment policy (unless otherwise noted). Sufficient liquidity has been maintained to meet budget expenditure requirements for the current six month period. o�,Jomr Onyx Jon \(Aug 6, 2024 13:52 PDT)
Onyx Jones, Interim Finance Director
Investments
Par
Value
LAIF 36, 162,565.44
Medium Term Notes 23,000,000.00
Federal Agency Issues - Coupon 31,000,000.00
Treasury Securities - Coupon 45,000,000.00
135, 162,565.44
Investments
Cash
Passbook/Checking 3,373,003.78
(not included in yield calculations)
Total Cash and Investments 138,535,569.22
Total Earnings June 30 Month Ending
Current Year 304,676.56
Reporting period 06/01/2024-06/30/2024
Run Date: 08/06/2024 - 09:58
CITY OF MANHATTAN BEACH
Portfolio Management
Portfolio Summary
June 1, 2024 through June 30, 2024
Market Book
Value Value
36, 162,565.44 36, 162,565.44
21,853,390.00 22, 188,230.94
30,470,210.00 30,841,134.01
42,769,190.00 44,334,618.26
131,255,355.44 133,526,548.65
3,373,003.78 3,373,003.78
134,628,359.22 136,899,552.43
%of
Portfolio Term
27.08 16.62 1,659
23.10 1,569
33.20 1,605
100.00% 1,171
1,171
Fiscal Year To Date Fiscal Year Ending
2,965,739.50 2,965,739.50
Days to
Maturity
1 981
702
814
596
596
YTM YTM
360 Equiv. 365 Equiv.
4.419 4.480
3.576 3.625
2.858 2.898
2.237 2.269
3.194 3.238
0.000 0.000
3.194 3.238
Portfolio CITY
CP
PM (PRF _PM1) 7.3.11
Report Ver. 7.3.11
CITY OF MANHATTAN BEACH
Portfolio Management Page 1
Portfolio Details - Investments
June 30, 2024
Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Date Par Value Market Value Book Value Rate S&P 365 Maturi!l Date LAIF
SYS3000 3000 Local Agency Invest. Fund 07/01/2018 36,162,565.44 36,162,565.44 36,162,565.44 4.480 4.480 --------- Subtotal and Average 36,162,565.44 36,162,565.44 36, 162,565.44 4.480 1 Medium Term Notes
037833DB3 MTN0112 APPLE INC 10/25/2022 1,000,000.00 944,440.00 943,931.65 2.900 AA+ 4.905 1,168 09/12/2027 037833ET3 MTN0121 APPLE INC 06/12/2023 1,000,000.00 979,230.00 992,446.00 4.000 AA+ 4.171 1,409 05/10/2028 023135BX3 MTN0111 AMAZON.COM LLC 02/24/2022 1,000,000.00 930,320.00 981,907.34 1.000 AA 1.963 680 05/12/2026 023135BC9 MTN0116 AMAZON.COM LLC 02/09/2023 1,000,000.00 949,540.00 966,354.70 3.150 AA 4.282 1,147 08/22/2027 06406RAL1 MTN0109 BANK OF NY MELLO 02/10/2020 1,000,000.00 989,300.00 1,011 ,205.00 2.100 A 1.850 115 10/24/2024 06406RAF4 MTN0118 BANK OF NY MELLO 04/14/2023 1,000,000.00 950,110.00 967,997.71 3.400 A 4.410 1,307 01/29/2028 194162AR4 MTN0123 COLGATE-PALM CO 07/10/2023 2,000,000.00 1,996,640.00 1,992,460.00 4.600 AA- 4.690 1,339 03/01/2028 22160KAN5 MTN0117 COSTCO COMPANIES 04/14/2023 1,000,000.00 908,330.00 931,869.54 1.375 A+ 3.743 1,084 06/20/2027 22160KAN5 MTN0119 COSTCO COMPANIES 04/18/2023 1,000,000.00 908,330.00 931,086.17 1.375 A+ 3.765 1,084 06/20/2027 254687FK7 MTN0107 Walt Disney 12/12/2019 2,000,000.00 1,986,600.00 1,999,271.68 1.750 A- 1.977 60 08/30/2024 478160CP7 MTN0113 Johnson & Johnson 10/25/2022 1,000,000.00 891,000.00 896,074.87 0.950 AAA 4.593 1,157 09/01/2027 478160CP7 MTN0114 Johnson & Johnson 12/22/2022 1,000,000.00 891,000.00 911,850.46 0.950 AAA 3.880 1,157 09/01/2027 191216CL2 MTN0108 COCA-COLA CO 12/12/2019 1,000,000.00 992,830.00 993,679.00 1.750 A+ 1.890 67 09/06/2024 191216DD9 MTN0124 COCA-COLA CO 07/10/2023 1,000,000.00 877,660.00 882,607.15 1.000 A+ 4.374 1,353 03/15/2028 191216DD9 MTN0126 COCA-COLA CO 02/05/2024 1,000,000.00 877,660.00 896,438.27 1.000 A+ 3.556 1,353 03/15/2028 594918BY9 MTN0115 MICROSOFT CORP 12/22/2022 1,000,000.00 964,600.00 978,929.29 3.300 AAA 4.163 950 02/06/2027 58933YAY1 MTN0110 MERCK & CO INC 10/05/2021 1,000,000.00 933,790.00 991,420.00 0.750 A+ 0.950 603 02/24/2026 58933YBH7 MTN0120 MERCK & CO INC 06/12/2023 1,000,000.00 978,970.00 992,917.00 4.050 A+ 4.210 1 ,416 05/17/2028 713448FR4 MTN0125 Pepsico 11/02/2023 1,000,000.00 993,430.00 980,093.27 4.450 A+ 5.044 1,414 05/15/2028 89236TLL7 MTN0127 TOYOTA MOTOR CREDIT 02/05/2024 1,000,000.00 987,770.00 1,008,418.76 4.650 4.493 1,649 01/05/2029 931142ER0 MTN0122 WALMART INC 06/12/2023 1,000,000.00 921,840.00 937,273.08 1.050 AA 4.183 808 09/17/2026 --------- Subtotal and Average 23,000,000.00 21,853,390.00 22, 188,230.94 3.625 981 Federal Agency Issues - Coupon
31422XW99 FAC0304 FARMER MAC 02/14/2023 1,000,000.00 978,610.00 1,000,000.00 3.850 3.850 1,323 02/14/2028 3133ENPX2 FAC0294 FED FARM CR BK 02/24/2022 1,000,000.00 965,460.00 997,642.00 1.800 AA+ 1.870 417 08/22/2025 3133EJDV8 FAC0296 FED FARM CR BK 04/11/2022 2,000,000.00 1,925,400.00 2,021,594.07 3.150 AA+ 2.747 994 03/22/2027 3133ENEJ5 FAC0301 FED FARM CR BK 06/17/2022 1,000,000.00 982,880.00 991,127.44 0.875 3.250 140 11/18/2024 3133ENV72 FAC0303 FED FARM CR BK 10/27/2022 1,000,000.00 993,650.00 998,356.00 4.500 4.550 756 07/27/2026 3133EPA47 FAC0309 FED FARM CR BK 11/02/2023 1,000,000.00 1,017,100.00 1,000,600.00 4.875 AA+ 4.860 1,584 11/01/2028 3133ERDH1 FAC0311 FED FARM CR BK 05/08/2024 2,000,000.00 2,029,060.00 2,023,573.04 4.750 4.527 1,764 04/30/2029 3130A2UW4 FAC0285 Federal Home Loan Bank 12/11/2019 2,000,000.00 1,989,660.00 2,004,515.18 2.875 1.771 74 09/13/2024 Portfolio CITY
CP
Run Date: 08/06/2024 - 09:58 PM (PRF _PM2) 7 .3.11
Report Ver. 7.3.11
CITY OF MANHATTAN BEACH
Portfolio Management Page2
Portfolio Details - Investments
June 30, 2024
Purchase Stated YTM Days to Maturity
CUSIP Investment # Issuer Date Par Value Market Value Book Value Rate S&P 365 Maturi!l Date Federal Agency Issues - Coupon
3130AGWK7 FAC0289 Federal Home Loan Bank 02/07/2020 1,000,000.00 995,090.00 1,001 ,306.00 1.500 AA+ 1.470 45 08/15/2024 3130A8ZO9 FAC0293 Federal Home Loan Bank 02/24/2022 1,000,000.00 964,380.00 995,852.00 1.750 AA+ 1.871 438 09/12/2025 3130AN4T4 FAC0302 Federal Home Loan Bank 10/24/2022 1,000,000.00 926,970.00 934,623.29 0.875 4.343 711 06/12/2026 3130A3DU5 FAC0306 Federal Home Loan Bank 06/12/2023 1,000,000.00 958,730.00 975,013.99 3.000 AA+ 4.048 984 03/12/2027 3130AWC24 FAC0307 Federal Home Loan Bank 07/10/2023 1,000,000.00 986,700.00 984,533.05 4.000 AA+ 4.483 1,439 06/09/2028 3130AXEL8 FAC0308 Federal Home Loan Bank 11/02/2023 1,000,000.00 1,013,560.00 995,280.00 4.750 AA+ 4.861 1,530 09/08/2028 3130B13J4 FAC0310 Federal Home Loan Bank 05/09/2024 2,000,000.00 2,018,820.00 2,013,840.13 4.625 4.514 1,712 03/09/2029 3137EAEX3 FAC0298 Federal Home Loan Mortgage 05/13/2022 2,000,000.00 1,890,240.00 1,943,414.62 0.375 AA+ 2.722 449 09/23/2025 3135G0W66 FAC0286 Fannie Mae 12/11/2019 2,000,000.00 1,979,380.00 1,993,020.00 1.625 AA+ 1.700 106 10/15/2024 3135G0W66 FAC0287 Fannie Mae 02/07/2020 2,000,000.00 1,979,380.00 2,011,260.00 1.625 AA+ 1.500 106 10/15/2024 3135G0V75 FAC0288 Fannie Mae 02/07/2020 2,000,000.00 1,999,780.00 2,000,027.87 1.750 AA+ 1.526 07/02/2024 3135G0V75 FAC0290 Fannie Mae 02/04/2021 1,000,000.00 999,890.00 1,000,084.57 1.750 AA+ 0.259 1 07/02/2024 3135G05Y5 FAC0305 Fannie Mae 04/14/2023 1,000,000.00 885,030.00 915,277.45 0.750 3.597 1,194 10/08/2027 880591EW8 FAC0295 Tennessee Valley Authority 02/24/2022 1,000,000.00 962,050.00 990,779.81 0.750 AA+ 1.763 318 05/15/2025 880591CJ9 FAC0299 Tennessee Valley Authority 05/13/2022 1,000,000.00 1,028,390.00 1,049,413.50 6.750 AA+ 2.894 488 11/01/2025 --------- Subtotal and Average 31,000,000.00 30,470,210.00 30,841,134.01 2.898 702 Treasury Securities - Coupon
9128282U3 UST0035 US TREASURY 02/07/2020 2,000,000.00 1,987,860.00 2,001,379.86 1.875 1.493 61 08/31/2024 912828ZW3 UST0036 US TREASURY 05/28/2021 1,000,000.00 953,100.00 996,637.25 0.250 0.561 364 06/30/2025 912828ZW3 UST0039 US TREASURY 08/11/2021 1,000,000.00 953,100.00 996,542.18 0.250 0.591 364 06/30/2025 912828ZT0 UST0047 US TREASURY 12/08/2021 1,000,000.00 956,220.00 992,734.35 0.250 1.058 334 05/31/2025 912828ZC7 UST0051 US TREASURY 12/09/2021 1,000,000.00 973,270.00 1,003,906.25 1.125 1.001 242 02/28/2025 912828278 UST0054 US TREASURY 04/08/2022 2,000,000.00 1,850,940.00 1,942,665.19 1.500 2.665 944 01/31/2027 9128282A7 UST0057 US TREASURY 06/17/2022 1,000,000.00 935,780.00 962,656.44 1.500 3.287 775 08/15/2026 912828X88 UST0059 US TREASURY 09/01/2022 1,000,000.00 941,800.00 975,290.12 2.375 3.285 1,048 05/15/2027 912828X88 UST0060 US TREASURY 09/01/2022 1,000,000.00 941,800.00 975,011.88 2.375 3.295 1,048 05/15/2027 912828ZV5 UST0062 US TREASURY 09/01/2022 1,000,000.00 888,560.00 922,684.54 0.500 3.241 1,094 06/30/2027 912828Y07 UST0064 US TREASURY 10/25/2022 1,000,000.00 933,870.00 940,644.20 1.625 4.180 852 10/31/2026 9128282R0 UST0066 US TREASURY 02/09/2023 1,000,000.00 934,340.00 954,216.88 2.250 3.747 1, 140 08/15/2027 91282CAB7 UST0037 US TREASURY 05/28/2021 2,000,000.00 1,899,300.00 1,992,499.32 0.250 0.576 395 07/31/2025 91282CAJ0 UST0038 US TREASURY 05/28/2021 1,000,000.00 946,130.00 995,505.14 0.250 0.620 426 08/31/2025 91282CAB7 UST0040 US TREASURY 08/11/2021 1,000,000.00 949,650.00 996,228.70 0.250 0.601 395 07/31/2025 91282CAJ0 UST0041 US TREASURY 08/11/2021 1,000,000.00 946,130.00 995,729.88 0.250 0.586 426 08/31/2025 91282CAZ4 UST0042 US TREASURY 08/09/2021 1,000,000.00 938,160.00 995,884.44 0.375 0.658 517 11/30/2025 91282CAB7 UST0043 US TREASURY 10/05/2021 1,000,000.00 949,650.00 995,194.98 0.250 0.681 395 07/31/2025 Portfolio CITY
CP
Run Date: 08/06/2024 • 09:58 PM (PRF _PM2) 7 .3.11
CITY OF MANHATTAN BEACH
Portfolio Management
Portfolio Details - Investments
June 30, 2024
Purchase
CUSIP Investment # Issuer Date Par Value Market Value
Treasury Securities - Coupon
91282CAT8 UST0044 US TREASURY 10/05/2021 2,000,000.00 1,879,620.00 91282CCW9 UST0045 US TREASURY 10/05/2021 1,000,000.00 919,690.00 91282CCP4 UST0046 US TREASURY 10/05/2021 1,000,000.00 919,920.00 91282CCF6 UST0048 US TREASURY 12/09/2021 1,000,000.00 927,380.00 91282CCJ8 UST0049 US TREASURY 12/09/2021 1,000,000.00 927,660.00 91282CCZ2 UST0050 US TREASURY 12/09/2021 1,000,000.00 920,350.00 91282CAM3 UST0052 US TREASURY 02/24/2022 2,000,000.00 1,885,780.00 91282CDG3 UST0053 US TREASURY 04/08/2022 1,000,000.00 922,850.00 91282CEHO UST0055 US TREASURY 05/16/2022 1,000,000.00 980,260.00 91282CCP4 UST0056 US TREASURY 06/17/2022 1,000,000.00 919,920.00 91282CCZ2 UST0058 US TREASURY 06/17/2022 1,000,000.00 920,350.00 91282CEW7 UST0061 US TREASURY 09/01/2022 1,000,000.00 964,880.00 91282CFB2 UST0063 US TREASURY 09/01/2022 1,000,000.00 949,530.00 91282CFB2 UST0065 US TREASURY 12/22/2022 1,000,000.00 949,530.00 91282CGH8 UST0067 US TREASURY 02/09/2023 2,000,000.00 1,936,960.00 91282CHX2 UST0068 US TREASURY 11/01/2023 1,000,000.00 998,830.00 91282CJW2 UST0069 US TREASURY 02/02/2024 2,000,000.00 1,969,220.00 91282CKD2 UST0070 US TREASURY 05/08/2024 1,000,000.00 995,510.00 91282CKG5 UST0071 US TREASURY 05/08/2024 1,000,000.00 989,810.00 91282CKP5 UST0072 US TREASURY 05/08/2024 1,000,000.00 1,011,480.00 Subtotal and Average 45,000,000.00 42,769, 190.00
Total and Average 135,162,565.44 131,255,355.44
Run Date: 08/06/2024 - 09:58
Stated
Book Value Rate
1,986,800.82 0.250
992,500.00 0.750
994,414.00 0.625
991,815.34 0.750
993,675.72 0.875
992,487.39 0.875
1,961,979.95 0.250
965,661.46 1.125
996,500.00 2.625
946,618.08 0.625
947,668.91 0.875
997,755.04 3.250
984,738.49 2.750
969,708.53 2.750
1,982,503.95 3.500
985,413.83 4.375
2,020,691.46 4.000
992,220.00 4.250
987,053.69 4.125
1,009,000.00 4.625
44,334,618.26
133,526,548.65
Pagel
YTM Days to Maturity
S&P 365 Maturi!l Date
0.707 487 10/31/2025
0.907 791 08/31/2026
0.892 760 07/31/2026
1.191 699 05/31/2026
1.176 729 06/30/2026
1.210 821 09/30/2026
1.678 456 09/30/2025
2.581 852 10/31/2026
2.750 288 04/15/2025
3.187 760 07/31/2026
3.302 821 09/30/2026
3.300 1,094 06/30/2027
3.309 1,125 07/31/2027
3.787 1,125 07/31/2027
3.804 1,309 01/31/2028
4.816 1,522 08/31/2028
3.786 1,675 01/31/2029
4.430 1,703 02/28/2029
4.474 1,734 03/31/2029
4.421 1,764 04/30/2029 ---------
2.269
3.238
814
596
Portfolio CITY
CP
PM (PRF _PM2) 7 .3.11
CUSIP Investment # Issuer
Money Market Fund
SYS39903-39902 39901 UNION BANK
Subtotal and Average
Total Cash and Investments
Run Date: 08/06/2024 - 09:58
CITY OF MANHATTAN BEACH
Portfolio Management
Portfolio Details - Cash
June 30, 2024
Purchase
Date Par Value Market Value
07/01/2018 3,373,003.78 3,373,003.78
138,535,569.22 134,628,359.22
Stated
Book Value Rate S&P
3,373,003.78
136,899,552.43
Page4
YTM Days to
365 Maturity
0.000
3.238
1 596
Portfolio CITY
CP
PM (PRF _PM2) 7 .3.11
PORTFOLIO PROFILE
Total Book Value (Excluding Trust Funds)
lncrease/(Decrease) from Prior Period
Percentage Change
Average Yield to Maturity (365 Days)
lncrease/(Decrease) from Prior Period
PORTFOLIO ALLOCATIONS
By Security
LAIF*
Medium Term Notes
Federal Agencies
U.S. Treasuries
Total
*LAIF YTM as of June 30, 2024
RECENT ACTIVITY
Security
FHLB - 4.625% Coupon
FFCB - 4.75% Coupon
T - 4.25% Coupon
T - 4.125% Coupon
T - 4.625% Coupon
Total Purchases
Matured: T- 2.125% Coupon
Matured: T- 2.125% Coupon
Matured: FFCB - 2.625% Coupon
Matured: FHLB - 2.875% Coupon
Matured: FHLB - 2.75% Coupon
Total Maturing/Ca/ls
Jun 30, 2024 May 31, 2024
$133,526,549 $135,224,288
(1,697,740) 8,026,402
(1.3%) 6.3%
3.238% 3.179%
0.059% 0.124%
Value (Par) Percent
$36, 162,565 26.75%
23,000,000 17.0%
31,000,000 22.9%
45,000,000 33.3%
$135,162,565 100.0%
Date of Activity Maturity Date
5/7/2024 3/9/2029
5/7/2024 4/30/2029
5/7/2024 2/28/2029
5/7/2024 3/31/2029
5/7/2024 4/30/2029
2/29/2024 2/29/2024
3/31/2024 3/31/2024
5/16/2024 5/16/2024
6/14/2024 6/14/2024
6/28/2024 6/28/2024
City of Manhattan Beach
Investment Portfolio Summary
As of .June 30, 2024
Apr 30, 2024 Mar 31, 2024 Feb 29, 2024
$127,197,886 $116,944,095 $119,938,925
10,253,791 (2,994,830) 5,921,881
8.8% (2.5%) 5.2%
3.055% 2.940% 2.934%
0.115% 0.006% (0.021%)
Par YTM Time Horizon Percent
4.480% Next 12 months 44%
3.625% Months 13-24 16%
2.898% Months 25-36 16%
2.267% Months 37-48 15%
3.235% Months 49-60 10%
Total 100.0%
Purchase (Par) Maturing/Call YTM
2,000,000 4.514%
2,000,000 4.527%
1,000,000 4.430%
1,000,000 4.474%
1,000,000 4.421%
$7,000,000 4.487%
1,000,000 2.234%
1,000,000 2.240%
2,000,000 2.625%
1,000,000 0.312%
1,000,000 3.230%
$6,000,000 2.211%
6 OOo/c 0
5.00%
4.00%
3.00%
2.00%
1.00%
0.00%
�April 2024
..,._May 2024
-June 2024
City of Manhattan Beach
Investment Portfolio Summary
As of June 30, 2024
US Treasuries Yield Curve
www.treas.gov ------------------------------------------------------------------------------------------------ •
------ - -
3-Month
5.44%
5.46%
5.51%
-- ---
6-Month
5.38%
5.42%
5.37%
-
•
2-Year
4.87%
4.86%
4.74%
-- - - - - - -
-=
5-Year
4.56%
4.50%
4.32%
-- - -- -LAIF, 4.480%
Portfolio, 3.238%
10-Year
4.54%
4.48%
4.31%
Monthly yields are interpolated by the Treasury from the daily yield curve.
CITY OF MANHATIAN BEACH
Portfolio Maturity Strudure
July 2024 through✓u-2029
Mth Mat. YTM Inv
Jul24 7/2/24 1.5% FNMA
7/2/24 0.3% FNMA
Aug24 8/15/24 1.5% FHLB
8/30/24 2.0% DIS
8/31/24 1.5% T
Sep24 9/6/24 1.9% KO
9/13/24 1.8% FHLB
Oct24 10/15/24 1.7% FNMA
10/15/24 1.5% FNMA
10/24/24 1.9% BK
Nov24 11/18/24 3.3% FFCB
Dec24
Jan 25
Feb25 2/28/25 1.0% T
Mar25
Apr25 4/15/25 2.8% T
May25 5/15/25 1.8% TVA
5/31/25 1.1% T
Jun25 6/30/25 0.6% T
6/30/25 0.6% T
Total By Year (excl LAIF)
Average YTM
% of Total Securities (excl LAIF)
% of Total Investments (incl LAIF)
Total Securities
LAIF
Total Investments
Call Amt
nc $2.0M
nc $1.0M
nc $1.0M
7/30/24 $2.0M
nc $2.0M
9/6/24 $1.0M
nc $2.0M
nc $2.0M
nc $2.0M
9/6/24 $1.0M
nc $1.0M
nc $1.0M
nc $1.0M
nc $1.0M
nc $1.0M
nc $1.0M
nc $1.0M
$23.0m
1.6%
23%
44%
73% $99.0M
27% $36.2M
100% $135.2M
Mth
Jul25
Aug25
Sep25
Oct25
Nov25
Dec25
Jan 26
Feb26
Mar26
Apr26
May26
Jun26
Shaded rows indicate months with significant cash inflows.
Mal YTM Inv Call Amt Mth Mal
7/31/25 0.58% T nc $2.0M Jul 26 7/31/26
7/31/25 0.60% T nc $1.0M 7/31/26
7/31/25 0.68% T nc $1.0M 7/27/26
8/31/25 0.62% T nc $1.0M Aug26 8/31/26
8/31/25 0.59% T nc $1.0M 8/15/26
8/22/25 1.87% FFCB nc $1.0M
9/12/25 1.87% FHLB nc $1.0M Sep26 9/30/26
9/23/25 2.72% FHLMC nc $2.0M 9/30/26
9/30/25 1.68% T nc $2.0M 9/17/26
10/31/25 0.71% T nc $2.0M Oct26 10/31/26
10/31/26
11/30/25 0.66% T nc $1.0M Nov26
11/1/25 2.89% TVA nc $1.0M
Dec26
Jan27 1/31/27
2124/26 0.95% MRK MW:10 $1.0M Feb27 216/27
Mar27 3/22127
3/12127
Apr27
5/31/26 1.19% T nc $1.0M May27 5/15/27
5/12/26 1.96% AMZN nc $1.0M 5/15/27
6/30/26 1.18% T nc $1.0M Jun27 6/20/27
6/12/26 4.34% FHLB nc $1.0M 6/30/27
6/30/27
6/20/27
$21.0m
1.5%
21%
16%
YTM Inv Call Amt Mth Mat. YTM Inv
0.89% T nc $1.0M Jul 27 7/31/27 3.31% T
3.19% T nc $1.0M 7/31/27 3.79% T
4.55% FFCB nc $1.0M
0.91% T nc $1.0M Aug27 8/15/27 3.75% T
3.29% T nc $1.0M 8/22/27 4.28% AMZN
1.21% T nc $1.0M Sep27 9/12/27 4.91% AAPL
3.30% T nc $1.0M 9/1/27 4.59% JNJ
4.18% WMT nc $1.0M 9/1/27 3.88% JNJ
2.58% T nc $1.0M Oct27 10/8/27 3.60% FNMA
4.18% T nc $1.0M
Nov27
Dec27
2.67% T nc $2.0M Jan 28 1/29/28 4.41% BK
1/31/28 3.80% T
4.16% MSFT nc $1.0M Feb28 2/14/28 3.85% FAMC,O
2.75% FFCB nc $2.0M Mar28 3/1/28 4.69% CL
4.05% FHLB nc $1.0M 3/15/28 4.37% KO
3/15/28 3.56% KO
Apr28
3.28% T nc $1.0M May28 5/10/28 4.17% AAPL
3.29% T nc $1.0M 5/17/28 4.21% MRK
5/15/28 5.04% PEP
3.74% COST nc $1.0M Jun28 6/9/28 4.48% FHLB
3.24% T nc $1.0M
3.30% T nc $1.0M
3.76% COST nc $1.0M
$22.0m
3.1%
22%
16%
Call Amt Mth Mat.
nc $1.0M Jul 28
nc $1.0M
nc $1.0M Aug 28 8/31/28
nc $1.0M
nc $1.0M Sep28 9/8/28
nc $1.0M
nc $1.0M
nc $1.0M Oct28
Nov28 11/1/28
Dec28
nc $1.0M Jan29 1/5/29
nc $2.0M 1/31/29
nc $1.0M Feb29 2/28/29
nc $2.0M Mar29 3/31/29
nc $1.0M 3/9/29
nc $1.0M
Apr29 4/30/29
4/30/29
nc $1.0M May29
nc $1.0M
nc $1.0M
nc $1.0M Jun 29
$20.0m
4.1%
20%
15%
HELD TO MATURITY
Rolling 60 Months
YTM Inv Call Amt
4.82% T nc $1.0M
4.86% FHLB nc $1.0M
4.86% FFCB nc $1.0M
4.49% TOYOT,O nc $1.0M
3.75% T nc $2.0M
4.43% T nc $1.0M
4.47% T nc $1.0M
4.51% FHLB nc $2.0M
4.42% T nc $1.0M
4.53% FFCB nc $2.0M
$1 3.0m
4.5%
13%
10%
City of Manhattan Beach
Investment Policy Compliance Chart
As o/June 30, 2024
Instrument
Local Agency Investment Fund (LAIF)
Treasury Securities
US Treasury
Total U.S. Treasuries (38)
Medium Term (Corporate) Notes
Coca-Cola
Amazon
Costco
Walmart
Colgate-Palmolive
Pepsi Cola
Coca-Cola
Toyota Moto Credit Corp
Total Consumer Goods Sector
Bank of NY
Total Financial Sector
Johnson & Johnson
Merck
Total Pharmaceuticals Sector
Apple Inc
Microsoft Corp
Total Technology Sector
Walt Disney Co
Total Communication Services Sector
Total Medium Term Notes (21)
Federal Agencies
Federal Home Loan Bank (FHLB)
Federal Farm Credit (FFCB)
Fannie Mae (FNMA)
Freddie Mac (FHLMC)
Frarmer Mac (FAMCA)
Tennessee Valley Authority (TVA)
Total Federal Agencies (23)
Total Portfolio
$36, 162,565
$45,000,000
$45,000,000
2,000,000
2,000,000
2,000,000
1,000,000
2,000,000
1,000,000
1,000,000
1,000,000
$12,000,000
2,000,000
$2,000,000
2,000,000
2,000,000
$4,000,000
2,000,000
1,000,000
$3,000,000
2,000,000
$2,000,000
$23,000,000
$10,000,000
8,000,000
8,000,000
2,000,000
1,000,000
2,000,000
$31,000,000
$135,162,565
Dollar Compliance Percentage Compliance Term Compliance % of Total Limit Compliant? Limit Compliant? Limit Compliant?
26.8% $75,000,000 Yes Temporary Suspension
33.3% 5 Years Yes
33.3%
1.5% 5.0% Yes 5 Years Yes
1.5% 5.0% Yes 5 Years Yes
1.5% 5.0% Yes 5 Years Yes
0.7% 5.0% Yes 5 Years Yes
1.5% 5.0% Yes 5 Years Yes
0.7% 5.0% Yes 5 Years Yes
0.7% 5.0% Yes 5 Years Yes
0.7% 5.0% Yes 5 Years Yes
8.9% 10.0% Yes
1.5% 5.0% Yes 5 Years Yes
1.5% 10.0% Yes
1.5% 5.0% Yes 5 Years Yes
1.5% 5.0% Yes 5 Years Yes
3.0% 10.0% Yes
1.5% 5.0% Yes 5 Years Yes
0.7% 5.0% Yes 5 Years Yes
2.2% 10.0% Yes
1.5% 5.0% Yes 5 Years Yes
17.0% 20.0% Yes
7.4% 33.3% Yes 5 Years Yes
5.9% 33.3% Yes 5 Years Yes
5.9% 33.3% Yes 5 Years Yes
1.5% 33.3% Yes 5 Years Yes
0.7% 33.3% Yes 5 Years Yes
1.5% 33.3% Yes 5 Years Yes
22.9% 60.0% Yes
100.0%
Investments
LAIF
CITY OF MANHATTAN BEACH
TREASURER'S REPORT
June 30, 2024
Treasury Securities
Federal Agency Issues-Coupon
Medium Term Notes
Subtotal Investments
Demand Deposit/Petty Cash
Cash in Bank
Petty Cash
Subtotal Demand Deposit
Subtotal City Cash & Investments
Bond Funds Held in Trust
Police Fire Refunding
Fire Station 2 COPs
Marine Ave Park Refunding
Metlox & Water/Wastewater Refunding
Utility Assessment Districts
Pension Obligation Bonds
Subtotal Bonds Held in Trust
Investment Trust Funds
PARS Pension Rate Stabilization Trust
Treasurer's Balance
Book Value
$36, 162,565.44
44,334,618.26
30,841,134.01
22,188,230.94
$133,526,548.65
$3,373,003.78
2,280.41
$3,375,284.19
$136,901,832.84
89,367.16
133,002.81
61,550.00
117,381.69
1, 167,546.22
1,021,982.65
$2,590,830.53
3,599,984.71
$143,092,648.08
PMIA/LAIF Performance Report
as of 7 /24/24
Quarterly Performance
Quarter Ended 06/30/24
PMIA Average Monthly
Effective Yieldsl11
LAIF Apportionment Rate12l:
LAIF Earnings Ratio12l:
LAIF Administrative Cost11l*:
LAIF Fair Value Factor11l:
PMIA Daily11l:
PMIA Quarter to Date11l:
PMIA Average Life11l:
4.55 0.00012419067099490
0.16 0.996316042
4.52 4.36
217
June
May
April
March
February
January
Pooled Money Investment Account
Monthly Portfolio Composition 111
6/30/24
Time
Deposits
2.84%
$178.0 billion
Corporate
Bonds
0.39%
Certificates of
Deposit/Bank Notes
8.68%
4.480
4.332
4.272
4.232
4.122
4.012
Treasuries
56.92%
Agencies
24.41%
Chart does not include $1,567,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.
Daily rates are now available here. View PMIA Daily Rates Notes: The apportionment rate includes interest earned on the Ca/PERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(l) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a). *The percentage of administrative cost equals the total administrative cost divided by the quarterly interest earnings. The I aw provides that administrative costs are not to exceed 5% of quarterly EARNINGS of the fund. However, if the 13 -week Daily Treasury Bill Rate on the last day of the fiscal year is below 1%, then administrative costs shall not exceed 8% of quarterly EARNINGS of the fund for the subseque nt fiscal year.
Source:
111 State of California, Office of the Treasurer
121 State of Calfiornia, Office of the Controller