0OH^ co<t»0>
u ^
(Df. << I-
^
OQAk
(D
•..»
^
w»v E
V. CT3
(0
Q- co(D
Q
c(D
CQ0
co
0 LL
0 ^°
3 0
^
0 £
t
p
CL
c
<D
0)
y>
c
^f-
CN
0 Csl
(V)
^
0)
<
0) W -^
w w 0^a5 a) -0)
+- J3.^
(0
£ >'a?
i'1^J^s
ilL
^11?
C (T5 d)
X: "
0 ro -'0)
c:
^:
^^^ ^
0)Q
u ^ E
%£ CO 0)
m?3
(0
i£.^^
S 'i -o §
^ .50
0 ^ .°' a?
^s'^£0 ,ro '£ ^
'aii-i12£ i^N^
Plj
^.E o
8 ^
I5
s-^
C 0)
ro Ec ^^0)
^1
's ^i ^
C (U
a? a
11 ? s
0 0
(U
Q
0)
0 (0
c
G'
E
^1 •
(U /\<^t
^
^
0)
^--^
0 ^ ^>1
x
>,
c:
0 CITY OF MANHATTAN BEACH
Portfolio Management
August 1, 2024 through August 31, 2024
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
Maturity
Term
YTM
360 Equiv.
YTM
365 Equiv.
LAIF 21,517,532.23 118.46 4.516121,517,532.2321,517,532.23 4.579 Medium Term Notes 23,104,361.26 1,66219.82 3.8191,09523,262,060.0024,000,000.00 3.872 Federal Agency Issues - Coupon 26,839,715.57 1,57623.02 3.10974326,887,020.0027,000,000.00 3.152 Treasury Securities - Coupon 45,127,299.65 1,60938.71 2.38284244,418,840.0046,000,000.00 2.415 116,588,908.71 100.00%
Investments
116,085,452.23118,517,532.23 1,315 714 3.228 3.273
Cash
(not included in yield calculations)
Passbook/Checking 4,817,146.70 1 0.00014,817,146.704,817,146.70 0.000 121,406,055.41Total Cash and Investments 120,902,598.93123,334,678.93 1,315 714 3.228 3.273 Current Year
August 31
273,513.39
Fiscal Year To Date
578,018.65
Total Earnings Month Ending
__________________________________________________ ____________________
CITY OF MANHATTAN BEACH,
Portfolio CITY
CP
Reporting period 08/01/2024-08/31/2024
Run Date: 10/08/2024 - 23:09 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
LAIF
4.579Local Agency Invest. Fund3000 21,517,532.23 21,517,532.23 4.57921,517,532.23SYS3000 1 21,517,532.2321,517,532.2321,517,532.23Subtotal and Average 4.579 1 Medium Term Notes
4.905APPLE INCMTN0112 1,000,000.00 943,931.65 09/12/20272.90010/25/2022 968,640.00 AA+037833DB3 1,106
4.171APPLE INCMTN0121 1,000,000.00 992,446.00 05/10/20284.00006/12/2023 1,003,420.00 AA+037833ET3 1,347
1.963AMAZON.COM LLCMTN0111 1,000,000.00 981,907.34 05/12/20261.00002/24/2022 948,680.00 AA023135BX3 618
4.282AMAZON.COM LLCMTN0116 1,000,000.00 966,354.70 08/22/20273.15002/09/2023 975,630.00 AA023135BC9 1,085
4.342AMAZON.COM LLCMTN0129 1,000,000.00 962,290.00 04/13/20293.45007/12/2024 977,320.00023135CG9 1,685
1.850BANK OF NY MELLOMTN0109 1,000,000.00 1,011,205.00 10/24/20242.10002/10/2020 995,540.00 A06406RAL1 53
4.410BANK OF NY MELLOMTN0118 1,000,000.00 967,997.71 01/29/20283.40004/14/2023 969,360.00 A06406RAF4 1,245
4.690COLGATE-PALM COMTN0123 2,000,000.00 1,992,460.00 03/01/20284.60007/10/2023 2,035,820.00 AA-194162AR4 1,277
3.743COSTCO COMPANIESMTN0117 1,000,000.00 931,869.54 06/20/20271.37504/14/2023 930,450.00 A+22160KAN5 1,022
3.765COSTCO COMPANIESMTN0119 1,000,000.00 931,086.17 06/20/20271.37504/18/2023 930,450.00 A+22160KAN5 1,022
4.593Johnson & JohnsonMTN0113 1,000,000.00 896,074.87 09/01/20270.95010/25/2022 916,940.00 AAA478160CP7 1,095
3.880Johnson & JohnsonMTN0114 1,000,000.00 911,850.46 09/01/20270.95012/22/2022 916,940.00 AAA478160CP7 1,095
1.890COCA-COLA COMTN0108 1,000,000.00 993,679.00 09/06/20241.75012/12/2019 999,690.00 A+191216CL2 5
4.374COCA-COLA COMTN0124 1,000,000.00 882,607.15 03/15/20281.00007/10/2023 903,250.00 A+191216DD9 1,291
3.556COCA-COLA COMTN0126 1,000,000.00 896,438.27 03/15/20281.00002/05/2024 903,250.00 A+191216DD9 1,291
4.163MICROSOFT CORPMTN0115 1,000,000.00 978,929.29 02/06/20273.30012/22/2022 984,480.00 AAA594918BY9 888
0.950MERCK & CO INCMTN0110 1,000,000.00 991,420.00 02/24/20260.75010/05/2021 949,890.00 A+58933YAY1 541
4.210MERCK & CO INCMTN0120 1,000,000.00 992,917.00 05/17/20284.05006/12/2023 999,820.00 A+58933YBH7 1,354
5.044PepsicoMTN0125 1,000,000.00 980,093.27 05/15/20284.45011/02/2023 1,013,990.00 A+713448FR4 1,352
4.493TOYOTA MOTOR CREDITMTN0127 1,000,000.00 1,008,418.76 01/05/20294.65002/05/2024 1,011,800.0089236TLL7 1,587
4.650TOYOTA MOTOR CREDITMTN0130 1,000,000.00 1,000,000.00 01/05/20294.65007/12/2024 1,011,800.0089236TLL7 1,587
4.183WALMART INCMTN0122 1,000,000.00 937,273.08 09/17/20261.05006/12/2023 942,050.00 AA931142ER0 746
4.349WALMART INCMTN0128 1,000,000.00 953,112.00 07/08/20293.25007/12/2024 972,850.00931142EN9 1,771 23,104,361.2623,262,060.0024,000,000.00Subtotal and Average 3.872 1,095 Federal Agency Issues - Coupon
3.850FARMER MACFAC0304 1,000,000.00 1,000,000.00 02/14/20283.85002/14/2023 1,002,030.0031422XW99 1,261
1.870FED FARM CR BKFAC0294 1,000,000.00 997,642.00 08/22/20251.80002/24/2022 973,090.00 AA+3133ENPX2 355
2.747FED FARM CR BKFAC0296 2,000,000.00 2,021,594.07 03/22/20273.15004/11/2022 1,967,500.00 AA+3133EJDV8 932
3.250FED FARM CR BKFAC0301 1,000,000.00 991,127.44 11/18/20240.87506/17/2022 990,830.003133ENEJ5 78
4.550FED FARM CR BKFAC0303 1,000,000.00 998,356.00 07/27/20264.50010/27/2022 1,008,640.003133ENV72 694
4.860FED FARM CR BKFAC0309 1,000,000.00 1,000,600.00 11/01/20284.87511/02/2023 1,041,480.00 AA+3133EPA47 1,522 Portfolio CITY
CP
Run Date: 10/08/2024 - 23:09 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
4.527FED FARM CR BKFAC0311 2,000,000.00 2,023,573.04 04/30/20294.75005/08/2024 2,080,740.003133ERDH1 1,702
1.771Federal Home Loan BankFAC0285 2,000,000.00 2,004,515.18 09/13/20242.87512/11/2019 1,998,660.003130A2UW4 12
1.871Federal Home Loan BankFAC0293 1,000,000.00 995,852.00 09/12/20251.75002/24/2022 973,750.00 AA+3130A8ZQ9 376
4.343Federal Home Loan BankFAC0302 1,000,000.00 934,623.29 06/12/20260.87510/24/2022 946,430.003130AN4T4 649
4.048Federal Home Loan BankFAC0306 1,000,000.00 975,013.99 03/12/20273.00006/12/2023 978,670.00 AA+3130A3DU5 922
4.483Federal Home Loan BankFAC0307 1,000,000.00 984,533.05 06/09/20284.00007/10/2023 1,008,360.00 AA+3130AWC24 1,377
4.861Federal Home Loan BankFAC0308 1,000,000.00 995,280.00 09/08/20284.75011/02/2023 1,035,100.00 AA+3130AXEL8 1,468
4.514Federal Home Loan BankFAC0310 2,000,000.00 2,013,840.13 03/09/20294.62505/09/2024 2,070,140.003130B13J4 1,650
2.722Federal Home Loan MortgageFAC0298 2,000,000.00 1,943,414.62 09/23/20250.37505/13/2022 1,918,080.00 AA+3137EAEX3 387
1.700Fannie MaeFAC0286 2,000,000.00 1,993,020.00 10/15/20241.62512/11/2019 1,991,440.00 AA+3135G0W66 44
1.500Fannie MaeFAC0287 2,000,000.00 2,011,260.00 10/15/20241.62502/07/2020 1,991,440.00 AA+3135G0W66 44
3.597Fannie MaeFAC0305 1,000,000.00 915,277.45 10/08/20270.75004/14/2023 911,000.003135G05Y5 1,132
1.763Tennessee Valley AuthorityFAC0295 1,000,000.00 990,779.81 05/15/20250.75002/24/2022 972,690.00 AA+880591EW8 256
2.894Tennessee Valley AuthorityFAC0299 1,000,000.00 1,049,413.50 11/01/20256.75005/13/2022 1,026,950.00 AA+880591CJ9 426 26,839,715.5726,887,020.0027,000,000.00Subtotal and Average 3.152 743 Treasury Securities - Coupon
0.561US TREASURYUST0036 1,000,000.00 996,637.25 06/30/20250.25005/28/2021 966,020.00912828ZW3 302
0.591US TREASURYUST0039 1,000,000.00 996,542.18 06/30/20250.25008/11/2021 966,020.00912828ZW3 302
1.058US TREASURYUST0047 1,000,000.00 992,734.35 05/31/20250.25012/08/2021 968,660.00912828ZT0 272
1.001US TREASURYUST0051 1,000,000.00 1,003,906.25 02/28/20251.12512/09/2021 982,310.00912828ZC7 180
2.665US TREASURYUST0054 2,000,000.00 1,942,665.19 01/31/20271.50004/08/2022 1,892,420.00912828Z78 882
3.287US TREASURYUST0057 1,000,000.00 962,656.44 08/15/20261.50006/17/2022 954,450.009128282A7 713
3.285US TREASURYUST0059 1,000,000.00 975,290.12 05/15/20272.37509/01/2022 962,700.00912828X88 986
3.295US TREASURYUST0060 1,000,000.00 975,011.88 05/15/20272.37509/01/2022 962,700.00912828X88 986
3.241US TREASURYUST0062 1,000,000.00 922,684.54 06/30/20270.50009/01/2022 912,150.00912828ZV5 1,032
4.180US TREASURYUST0064 1,000,000.00 940,644.20 10/31/20261.62510/25/2022 953,240.00912828YQ7 790
3.747US TREASURYUST0066 1,000,000.00 954,216.88 08/15/20272.25002/09/2023 957,190.009128282R0 1,078
0.576US TREASURYUST0037 2,000,000.00 1,992,499.32 07/31/20250.25005/28/2021 1,926,180.0091282CAB7 333
0.620US TREASURYUST0038 1,000,000.00 995,505.14 08/31/20250.25005/28/2021 960,090.0091282CAJ0 364
0.601US TREASURYUST0040 1,000,000.00 996,228.70 07/31/20250.25008/11/2021 963,090.0091282CAB7 333
0.586US TREASURYUST0041 1,000,000.00 995,729.88 08/31/20250.25008/11/2021 960,090.0091282CAJ0 364
0.658US TREASURYUST0042 1,000,000.00 995,884.44 11/30/20250.37508/09/2021 953,590.0091282CAZ4 455
0.681US TREASURYUST0043 1,000,000.00 995,194.98 07/31/20250.25010/05/2021 963,090.0091282CAB7 333
0.707US TREASURYUST0044 2,000,000.00 1,986,800.82 10/31/20250.25010/05/2021 1,909,620.0091282CAT8 425
0.907US TREASURYUST0045 1,000,000.00 992,500.00 08/31/20260.75010/05/2021 939,490.0091282CCW9 729 Portfolio CITY
CP
Run Date: 10/08/2024 - 23:09 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Treasury Securities - Coupon
0.892US TREASURYUST0046 1,000,000.00 994,414.00 07/31/20260.62510/05/2021 939,100.0091282CCP4 698
1.191US TREASURYUST0048 1,000,000.00 991,815.34 05/31/20260.75012/09/2021 945,510.0091282CCF6 637
1.176US TREASURYUST0049 1,000,000.00 993,675.72 06/30/20260.87512/09/2021 945,660.0091282CCJ8 667
1.210US TREASURYUST0050 1,000,000.00 992,487.39 09/30/20260.87512/09/2021 940,310.0091282CCZ2 759
1.678US TREASURYUST0052 2,000,000.00 1,961,979.95 09/30/20250.25002/24/2022 1,914,920.0091282CAM3 394
2.581US TREASURYUST0053 1,000,000.00 965,661.46 10/31/20261.12504/08/2022 943,050.0091282CDG3 790
2.750US TREASURYUST0055 1,000,000.00 996,500.00 04/15/20252.62505/16/2022 988,070.0091282CEH0 226
3.187US TREASURYUST0056 1,000,000.00 946,618.08 07/31/20260.62506/17/2022 939,100.0091282CCP4 698
3.302US TREASURYUST0058 1,000,000.00 947,668.91 09/30/20260.87506/17/2022 940,310.0091282CCZ2 759
3.300US TREASURYUST0061 1,000,000.00 997,755.04 06/30/20273.25009/01/2022 985,310.0091282CEW7 1,032
3.309US TREASURYUST0063 1,000,000.00 984,738.49 07/31/20272.75009/01/2022 971,020.0091282CFB2 1,063
3.787US TREASURYUST0065 1,000,000.00 969,708.53 07/31/20272.75012/22/2022 971,020.0091282CFB2 1,063
3.804US TREASURYUST0067 2,000,000.00 1,982,503.95 01/31/20283.50002/09/2023 1,982,040.0091282CGH8 1,247
4.816US TREASURYUST0068 1,000,000.00 985,413.83 08/31/20284.37511/01/2023 1,022,620.0091282CHX2 1,460
3.750US TREASURYUST0069 2,000,000.00 2,020,691.46 01/31/20294.00002/02/2024 2,020,240.0091282CJW2 1,613
4.430US TREASURYUST0070 1,000,000.00 992,220.00 02/28/20294.25005/08/2024 1,021,170.0091282CKD2 1,641
4.474US TREASURYUST0071 1,000,000.00 987,053.69 03/31/20294.12505/08/2024 1,015,780.0091282CKG5 1,672
4.421US TREASURYUST0072 1,000,000.00 1,009,000.00 04/30/20294.62505/08/2024 1,037,340.0091282CKP5 1,702
4.123US TREASURYUST0073 1,000,000.00 940,330.00 05/31/20292.75007/12/2024 956,640.0091282CES6 1,733
4.147US TREASURYUST0074 1,000,000.00 961,700.00 06/30/20293.25007/12/2024 977,700.0091282CEV9 1,763
4.062US TREASURYUST0075 1,000,000.00 892,031.25 10/31/20281.37507/12/2024 908,830.0091282CDF5 1,521 45,127,299.6544,418,840.0046,000,000.00Subtotal and Average 2.415 842 Total and Average 118,517,532.23 3.273 714116,085,452.23 116,588,908.71 Portfolio CITY
CP
Run Date: 10/08/2024 - 23:09 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Stated
RateMarket Value
August 31, 2024
Portfolio Details - Cash
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Money Market Fund
0.000UNION BANK39901 4,817,146.70 4,817,146.704,817,146.70SYS39903-39902 1 Subtotal and Average
Total Cash and Investments 123,334,678.93 3.273 714
1 120,902,598.93 121,406,055.41
Portfolio CITY
CP
Run Date: 10/08/2024 - 23:09 PM (PRF_PM2) 7.3.11
City of Manhattan Beach
Investment Portfolio Summary
As of August 31, 202
4 PORTFOLIO PROFILE Aug 31, 2024 Jul 31, 2024 Jun 30, 2024 May 31, 2024 Apr 30, 2024 Total Book Value (Excluding Trust Funds) $116,588,909 $127,590,866 $133,526,549 $135,224,288 $127,197,886 Increase/(Decrease) from Prior Period (11,001,958) (5,935,682) (1,697,740) 8,026,402 10,253,791 Percentage Change (8.6%) (4.4%) (1.3%) 6.3% 8.8%
Average Yield to Maturity (365 Days) 3.273% 3.258% 3.238% 3.179% 3.055% Increase/(Decrease) from Prior Period 0.014% 0.021% 0.059% 0.124% (0.021%)
PORTFOLIO ALLOCATIONS
By Security Value (Par) Percent Par YTM Time Horizon Percent LAIF* $21,517,532 18.16% 4.579% Next 12 months 34%
Medium Term Notes 24,000,000 20.3% 3.872% Months 13-24 17% Federal Agencies 27,000,000 22.8% 3.152% Months 25-36 18% U.S. Treasuries 46,000,000 38.8% 2.415% Months 37-48 15% Total $118,517,532 100.0% 3.271% Months 49-60 16%
*LAIF YTM as of August 31, 2024 BAD Total 100.0%
RECENT ACTIVITY
Security Date of Activity Maturity Date Purchase (Par) Maturing/Call YTM WMT - 3.25% Coupon 7/12/2024 7/8/2029 1,000,000 4.349%
AMZN - 3.45% Coupon 7/12/2024 4/13/2029 1,000,000 4.342% TOYOTA - 4.65% Coupon 7/12/2024 1/5/2029 1,000,000 4.650% T - 4.11% Coupon 7/12/2024 5/31/2029 1,000,000 4.123%
T - 4.11% Coupon 7/12/2024 6/30/2029 1,000,000 4.147%
T - 4.14% Coupon 7/12/2024 10/31/2028 1,000,000 4.062%
Total Purchases $6,000,00 0 4.279%
Matured: FNMA - 1.75% Coupon 7/2/2024 7/2/2024 2,000,000 1.526% Matured: FNMA - 1.75% Coupon 7/2/2024 7/2/2024 1,000,000 0.259% Matured: FHLB - 1.5% Coupon 8/15/2024 8/15/2024 1,000,000 Matured: DIS - 1.75% Coupon 8/30/2024 8/30/2024 2,000,000 Matured: T - 1.875% Coupon 8/31/2024 8/31/2024 2,000,000 Total Maturing/Calls $8,000,000 0.414%
City of Manhattan Beach
Investment Portfolio Summary
As of August 31, 202
4 3‐Month 6 ‐Month 2 ‐Year 5 ‐Year 10 ‐Year
June 2024 5.51% 5.37% 4.74% 4.32% 4.31%
July 2024 5.43% 5.25% 4.50% 4.16% 4.25%
August 2024 5.30% 4.96% 3.97% 3.71% 3.87%
Portfolio 3.273% 3.273% 3.273% 3.273% 3.273%
LAIF 4 579% 4 579% 4 579% 4 579% 4 579%
Portfolio, 3.273%
LAIF, 4.579%
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
US Treasuries Yield Curve
www.treas.gov
Monthly yields are interpolated by the Treasury from the daily yield curve.
CITY OF MANHATTAN BEACH HELD TO MATURITY
Portfolio Maturity Structure Rolling 60 Months
September 2024 through August 2029
Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Mth Mat. YTM Inv Call Amt Sep 24 9/6/24 1.9% KO 9/6/24 $1.0M Sep 25 9/12/25 1.87% FHLB nc $1.0M Sep 26 9/30/26 1.21% T nc $1.0M Sep 27 9/12/27 4.91% AAPL nc $1.0M Sep 28 9/8/28 4.86% FHLB nc $1.0M 9/13/24 1.8% FHLB nc $2.0M 9/23/25 2.72% FHLM C nc $2.0M 9/30/26 3.30% T nc $1.0M 9/1/27 4.59% JNJ nc $1.0M 9/30/25 1.68% T nc $2.0M 9/17/26 4.18% WMT nc $1.0M 9/1/27 3.88% JNJ nc $1.0M Oct 24 10/15/24 1.7% FNMA nc $2.0M Oct 25 10/31/25 0.71% T nc $2.0M Oct 26 10/31/26 2.58% T nc $1.0M Oct 27 10/8/27 3.60% FNMA nc $1.0M Oct 28 10/31/28 4.06% T nc $1.0M 10/15/24 1.5% FNMA nc $2.0M 10/31/26 4.18% T nc $1.0M
10/24/24 1.9% BK 9/6/24 $1.0M
Nov 24 11/18/24 3.3% FFCB nc $1.0M Nov 25 11/30/25 0.66% T nc $1.0M Nov 26 Nov 27 Nov 28 11/1/28 4.86% FFCB nc $1.0M 11/1/25 2.89% TVA nc $1.0M
Dec 24 Dec 25 Dec 26 Dec 27 Dec 28
Jan 25 Jan 26 Jan 27 1/31/27 2.67% T nc $2.0M Jan 28 1/29/28 4.41% BK nc $1.0M Jan 29 1/5/29 4.49% TOYOT A nc $1.0M 1/31/28 3.80% T nc $2.0M 1/31/29 3.75% T nc $2.0M
1/5/29 4.65% TOYOT A nc $1.0M
Feb 25 2/28/25 1.0% T nc $1.0M Feb 26 2/24/26 0.95% MRK MW: 10 $1.0M Feb 27 2/6/27 4.16% MSFT nc $1.0M Feb 28 2/14/28 3.85% FAMC A nc $1.0M Feb 29 2/28/29 4.43% T nc $1.0M Mar 25 Mar 26 Mar 27 3/22/27 2.75% FFCB nc $2.0M Mar 28 3/1/28 4.69% CL nc $2.0M Mar 29 3/31/29 4.47% T nc $1.0M 3/12/27 4.05% FHLB nc $1.0M 3/15/28 4.37% KO nc $1.0M 3/9/29 4.51% FHLB nc $2.0M 3/15/28 3.56% KO nc $1.0M
Apr 25 4/15/25 2.8% T nc $1.0M Apr 26 Apr 27 Apr 28 Apr 29 4/13/29 4.34% AMZN nc $1.0M 4/30/29 4.42% T nc $1.0M
4/30/29 4.53% FFCB nc $2.0M
May 25 5/15/25 1.8% TVA nc $1.0M May 26 5/31/26 1.19% T nc $1.0M May 27 5/15/27 3.28% T nc $1.0M May 28 5/10/28 4.17% AAPL nc $1.0M May 29 5/31/29 4.12% T nc $1.0M 5/31/25 1.1% T nc $1.0M 5/12/26 1.96% AMZN nc $1.0M 5/15/27 3.29% T nc $1.0M 5/17/28 4.21% MRK nc $1.0M 5/15/28 5.04% PEP nc $1.0M
Jun 25 6/30/25 0.6% T nc $1.0M Jun 26 6/30/26 1.18% T nc $1.0M Jun 27 6/20/27 3.74% COST nc $1.0M Jun 28 6/9/28 4.48% FHLB nc $1.0M Jun 29 6/30/29 4.15% T nc $1.0M 6/30/25 0.6% T nc $1.0M 6/12/26 4.34% FHLB nc $1.0M 6/30/27 3.24% T nc $1.0M 6/30/27 3.30% T nc $1.0M
6/20/27 3.76% COST nc $1.0M
Jul 25 7/31/25 0.6% T nc $2.0M Jul 26 7/31/26 0.89% T nc $1.0M Jul 27 7/31/27 3.31% T nc $1.0M Jul 28 Jul 29 7/8/29 4.35% WMT nc $1.0M 7/31/25 0.6% T nc $1.0M 7/31/26 3.19% T nc $1.0M 7/31/27 3.79% T nc $1.0M 7/31/25 0.7% T nc $1.0M 7/27/26 4.55% FFCB nc $1.0M
Aug 25 8/31/25 0.6% T nc $1.0M Aug 26 8/31/26 0.91% T nc $1.0M Aug 27 8/15/27 3.75% T nc $1.0M Aug 28 8/31/28 4.82% T nc $1.0M Aug 29 8/31/25 0.6% T nc $1.0M 8/15/26 3.29% T nc $1.0M 8/22/27 4.28% AMZN nc $1.0M 8/22/25 1.9% FFCB nc $1.0M
Total By Year (excl LAIF) $22.0m $19.0m $21.0m $17.0m $18.0m Average YTM 1.4% 2.1% 3.4% 4.3% 4.4%
% of Total Securities (excl LAIF) 23% 20% 22% 18% 19%
% of Total Investments (incl LAIF) 37% 16% 18% 14% 15%
Total Securities 82%
$97.0M
LAIF 18% $21.5M
Total Investments 100% $118.5M
Shaded rows indicate months with significant cash inflows.
City of Manhattan Beach
Investment Policy Compliance Chart
As of August 31, 202
4 Instrument % of Total Limit Compliant? Limit Compliant? Limit Compliant? Local Agency Investment Fund (LAIF) $21,517,532 18.2% $75,000,000 Yes Treasury Securities
US Treasury $46,000,000 38.8% 5 Years Yes
Total U.S. Treasuries (40) TRUE $46,000,000 38.8%
Medium Term (Corporate) Notes
Coca-Cola 3,000,000 2.5% 5.0% Yes 5 Years Yes
Amazon 3,000,000 2.5% 5.0% Yes 5 Years Yes
Costco 2,000,000 1.7% 5.0% Yes 5 Years Yes
Walmart 2,000,000 1.7% 5.0% Yes 5 Years Yes
Colgate-Palmolive 2,000,000 1.7% 5.0% Yes 5 Years Yes
Pepsi Cola 1,000,000 0.8% 5.0% Yes 5 Years Yes
Total Consumer Goods Secto
r $13,000,000 10.0% 10.0% Yes
Bank of NY 2,000,000 1.7% 5.0% Yes 5 Years Yes
Toyota Motor Credit Corp 2,000,000 1.7% 5.0% Yes 5 Years Yes Total Financial Sector $4,000,000 3.4% 10.0% Yes
Johnson & Johnson 2,000,000 1.7% 5.0% Yes 5 Years Yes
Merck 2,000,000 1.7% 5.0% Yes 5 Years Yes
Total Pharmaceuticals Sector $4,000,000 3.4% 10.0% Yes
Apple Inc 2,000,000 1.7% 5.0% Yes 5 Years Yes
Microsoft Corp 1,000,000 0.8% 5.0% Yes 5 Years Yes
Total Technology Sector $3,000,000 2.5% 10.0% Yes
Total Medium Term Notes (23) TRUE $24,000,000 20.3% 20.0% No* Federal Agencies
Federal Home Loan Bank (FHLB) $9,000,000 7.6% 33.3% Yes 5 Years Yes Federal Farm Credit (FFCB) 8,000,000 6.8% 33.3% Yes 5 Years Yes Fannie Mae (FNMA) 5,000,000 4.2% 33.3% Yes 5 Years Yes
Freddie Mac (FHLMC) 2,000,000 1.7% 33.3% Yes 5 Years Yes Frarmer Mac (FAMCA) 1,000,000 0.8% 33.3% Yes 5 Years Yes Tennessee Valley Authority (TVA) 2,000,000 1.7% 33.3% Yes 5 Years Yes Total Federal Agencies (20) TRU
E $27,000,000 22.8% 60.0% Yes
Total Portfolio $118,517,532 100.0%
Dollar Compliance Percentage Compliance Term Compliance Temporary Suspension
*Per the City's Investment Policy, the percentage of Medium Term Notes (MTN) was in compliance when all securities were purchased. A temporary decrease in the LAIF balance caused the percentage of MTNs to be over 20% of the total portfolio at month-end.
Investments Book Value
LAIF $21,517,532.23
Treasury Securities 45,127,299.65
Government Agency Issues 26,839,715.57
Medium Term Notes 23,104,361.26
Subtotal Investments $116,588,908.71
Investments In Transit (Cash Received 9/3/24) 2,001,379.86 Demand Deposit/Petty Cash
Cash in Bank $4,817,146.70
Petty Cash 2,280.41
$4,819,427.11
Subtotal City Cash & Investments $123,409,715.68
Bond Funds Held in Trust
Police Fire Refunding 1,844.73
Fire Station 2 COPs 308.85
Marine Ave Park Refunding 0.14
Metlox & Water/Wastewater Refunding 278.57
Utility Assessment Districts 2,602,173.81
Pension Obligation Bonds 2,408.84
Subtotal Bonds Held in Trust $2,607,014.94
Investment Trust Funds
PARS Pension Rate Stabilization Trust 3,736,905.49
Treasurer's Balance $129,753,636.11
CITY OF MANHATTAN BEACH
TREASURER'S REPORT
August 31, 2024
Subtotal Demand Deposit