City of Manhattan Beach
Finance Department
Investment Portfolio
April 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.
CITY OF MANHATTAN BEACH
Portfolio Management
April 1, 2024 through April 30, 2024
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
Maturity
Term
YTM
360 Equiv.
YTM
365 Equiv.
LAIF 33,162,565.44 126.07 4.213133,162,565.4433,162,565.44 4.272 Medium Term Notes 22,061,040.45 1,65917.34 3.5911,04121,612,290.0023,000,000.00 3.641 Federal Agency Issues - Coupon 30,773,703.53 1,44824.19 2.55553230,184,540.0031,000,000.00 2.591 Treasury Securities - Coupon 41,200,576.78 1,59132.39 2.07980839,322,040.0042,000,000.00 2.108 127,197,886.20 100.00%
Investments
124,281,435.44129,162,565.44 1,154 571 3.013 3.055
Cash
(not included in yield calculations)
Passbook/Checking 8,282,882.42 1 0.00018,282,882.428,282,882.42 0.000 135,480,768.62Total Cash and Investments 132,564,317.86137,445,447.86 1,154 571 3.013 3.055 Current Year
April 30
247,738.15
Fiscal Year To Date
2,361,962.62
Total Earnings Month Ending
__________________________________________________ ____________________
CITY OF MANHATTAN BEACH,
Portfolio CITY
CP
Reporting period 04/01/2024-04/30/2024
Run Date: 05/31/2024 - 13:45 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
LAIF
4.272Local Agency Invest. Fund3000 33,162,565.44 33,162,565.44 4.27207/01/2018 33,162,565.44SYS3000 1 33,162,565.4433,162,565.4433,162,565.44Subtotal and Average 4.272 1 Medium Term Notes
4.905APPLE INCMTN0112 1,000,000.00 935,170.97 09/12/20272.90010/25/2022 933,940.00 AA+037833DB3 1,229
4.171APPLE INCMTN0121 1,000,000.00 992,446.00 05/10/20284.00006/12/2023 966,480.00 AA+037833ET3 1,470
1.963AMAZON.COM LLCMTN0111 1,000,000.00 977,061.09 05/12/20261.00002/24/2022 919,910.00 AA023135BX3 741
4.282AMAZON.COM LLCMTN0116 1,000,000.00 961,004.74 08/22/20273.15002/09/2023 941,600.00 AA023135BC9 1,208
1.850BANK OF NY MELLOMTN0109 1,000,000.00 1,011,205.00 10/24/20242.10002/10/2020 983,990.00 A06406RAL1 176
4.410BANK OF NY MELLOMTN0118 1,000,000.00 963,528.81 01/29/20283.40004/14/2023 936,660.00 A06406RAF4 1,368
4.690COLGATE-PALM COMTN0123 2,000,000.00 1,992,460.00 03/01/20284.60007/10/2023 1,978,160.00 AA-194162AR4 1,400
3.743COSTCO COMPANIESMTN0117 1,000,000.00 920,408.34 06/20/20271.37504/14/2023 894,610.00 A+22160KAN5 1,145
3.765COSTCO COMPANIESMTN0119 1,000,000.00 919,493.19 06/20/20271.37504/18/2023 894,610.00 A+22160KAN5 1,145
1.977Walt DisneyMTN0107 2,000,000.00 1,997,086.66 08/30/20241.75012/12/2019 1,974,900.00 A-254687FK7 121
4.593Johnson & JohnsonMTN0113 1,000,000.00 879,680.02 09/01/20270.95010/25/2022 877,820.00 AAA478160CP7 1,218
3.880Johnson & JohnsonMTN0114 1,000,000.00 897,944.31 09/01/20270.95012/22/2022 877,820.00 AAA478160CP7 1,218
1.890COCA-COLA COMTN0108 1,000,000.00 993,679.00 09/06/20241.75012/12/2019 987,080.00 A+191216CL2 128
4.374COCA-COLA COMTN0124 1,000,000.00 866,778.90 03/15/20281.00007/10/2023 863,230.00 A+191216DD9 1,414
4.060COCA-COLA COMTN0126 1,000,000.00 885,190.00 03/15/20281.00002/05/2024 863,230.00 A+191216DD9 1,414
4.163MICROSOFT CORPMTN0115 1,000,000.00 974,877.23 02/06/20273.30012/22/2022 957,850.00 AAA594918BY9 1,011
0.950MERCK & CO INCMTN0110 1,000,000.00 991,420.00 02/24/20260.75010/05/2021 924,450.00 A+58933YAY1 664
4.210MERCK & CO INCMTN0120 1,000,000.00 992,917.00 05/17/20284.05006/12/2023 965,670.00 A+58933YBH7 1,477
5.044PepsicoMTN0125 1,000,000.00 977,524.66 05/15/20284.45011/02/2023 981,990.00 A+713448FR4 1,475
4.440TOYOTA MOTOR CREDITMTN0127 1,000,000.00 1,009,170.00 01/05/20294.65002/05/2024 976,750.0089236TLL7 1,710
4.183WALMART INCMTN0122 1,000,000.00 921,994.53 09/17/20261.05006/12/2023 911,540.00 AA931142ER0 869 22,061,040.4521,612,290.0023,000,000.00Subtotal and Average 3.641 1,041 Federal Agency Issues - Coupon
3.850FARMER MACFAC0304 1,000,000.00 1,000,000.00 02/14/20283.85002/14/2023 966,110.0031422XW99 1,384
1.870FED FARM CR BKFAC0294 1,000,000.00 997,642.00 08/22/20251.80002/24/2022 957,850.00 AA+3133ENPX2 478
2.747FED FARM CR BKFAC0296 2,000,000.00 2,025,552.25 03/22/20273.15004/11/2022 1,905,100.00 AA+3133EJDV8 1,055
2.625FED FARM CR BKFAC0297 2,000,000.00 2,000,000.00 05/16/20242.62505/16/2022 1,997,740.00 AA+3133ENWP1 15
3.250FED FARM CR BKFAC0301 1,000,000.00 979,554.54 11/18/20240.87506/17/2022 975,680.003133ENEJ5 201
4.550FED FARM CR BKFAC0303 1,000,000.00 998,356.00 07/27/20264.50010/27/2022 987,810.003133ENV72 817
4.860FED FARM CR BKFAC0309 1,000,000.00 1,000,600.00 11/01/20284.87511/02/2023 1,005,170.00 AA+3133EPA47 1,645
1.771Federal Home Loan BankFAC0285 2,000,000.00 2,015,648.49 09/13/20242.87512/11/2019 1,981,480.003130A2UW4 135 Portfolio CITY
CP
Run Date: 05/31/2024 - 13:45 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
1.470Federal Home Loan BankFAC0289 1,000,000.00 1,001,306.00 08/15/20241.50002/07/2020 988,880.00 AA+3130AGWK7 106
0.312Federal Home Loan BankFAC0291 1,000,000.00 1,012,086.41 06/14/20242.87502/04/2021 996,860.00 AA+3130A1XJ2 44
1.871Federal Home Loan BankFAC0293 1,000,000.00 995,852.00 09/12/20251.75002/24/2022 955,430.00 AA+3130A8ZQ9 499
3.230Federal Home Loan BankFAC0300 1,000,000.00 990,620.00 06/28/20242.75006/17/2022 995,510.003130ASDS5 58
4.343Federal Home Loan BankFAC0302 1,000,000.00 917,860.03 06/12/20260.87510/24/2022 917,680.003130AN4T4 772
4.048Federal Home Loan BankFAC0306 1,000,000.00 970,093.32 03/12/20273.00006/12/2023 949,120.00 AA+3130A3DU5 1,045
4.483Federal Home Loan BankFAC0307 1,000,000.00 982,571.07 06/09/20284.00007/10/2023 971,090.00 AA+3130AWC24 1,500
4.861Federal Home Loan BankFAC0308 1,000,000.00 995,280.00 09/08/20284.75011/02/2023 999,280.00 AA+3130AXEL8 1,591
2.722Federal Home Loan MortgageFAC0298 2,000,000.00 1,920,422.82 09/23/20250.37505/13/2022 1,871,900.00 AA+3137EAEX3 510
1.700Fannie MaeFAC0286 2,000,000.00 1,993,020.00 10/15/20241.62512/11/2019 1,966,660.00 AA+3135G0W66 167
1.500Fannie MaeFAC0287 2,000,000.00 2,011,260.00 10/15/20241.62502/07/2020 1,966,660.00 AA+3135G0W66 167
1.526Fannie MaeFAC0288 2,000,000.00 2,002,534.24 07/02/20241.75002/07/2020 1,987,200.00 AA+3135G0V75 62
0.259Fannie MaeFAC0290 1,000,000.00 1,007,696.46 07/02/20241.75002/04/2021 993,600.00 AA+3135G0V75 62
3.597Fannie MaeFAC0305 1,000,000.00 902,331.73 10/08/20270.75004/14/2023 871,010.003135G05Y5 1,255
1.763Tennessee Valley AuthorityFAC0295 1,000,000.00 985,511.13 05/15/20250.75002/24/2022 954,120.00 AA+880591EW8 379
2.894Tennessee Valley AuthorityFAC0299 1,000,000.00 1,067,905.04 11/01/20256.75005/13/2022 1,022,600.00 AA+880591CJ9 549 30,773,703.5330,184,540.0031,000,000.00Subtotal and Average 2.591 532 Treasury Securities - Coupon
1.493US TREASURYUST0035 2,000,000.00 2,005,451.48 08/31/20241.87502/07/2020 1,976,960.009128282U3 122
0.561US TREASURYUST0036 1,000,000.00 994,955.86 06/30/20250.25005/28/2021 944,380.00912828ZW3 425
0.591US TREASURYUST0039 1,000,000.00 994,813.27 06/30/20250.25008/11/2021 944,380.00912828ZW3 425
1.058US TREASURYUST0047 1,000,000.00 988,771.27 05/31/20250.25012/08/2021 947,890.00912828ZT0 395
1.001US TREASURYUST0051 1,000,000.00 1,003,906.25 02/28/20251.12512/09/2021 966,320.00912828ZC7 303
2.665US TREASURYUST0054 2,000,000.00 1,931,568.13 01/31/20271.50004/08/2022 1,826,640.00912828Z78 1,005
3.287US TREASURYUST0057 1,000,000.00 953,869.72 08/15/20261.50006/17/2022 925,160.009128282A7 836
3.285US TREASURYUST0059 1,000,000.00 970,992.75 05/15/20272.37509/01/2022 930,160.00912828X88 1,109
3.295US TREASURYUST0060 1,000,000.00 970,666.12 05/15/20272.37509/01/2022 930,160.00912828X88 1,109
3.241US TREASURYUST0062 1,000,000.00 909,798.63 06/30/20270.50009/01/2022 873,590.00912828ZV5 1,155
4.180US TREASURYUST0064 1,000,000.00 927,925.10 10/31/20261.62510/25/2022 922,810.00912828YQ7 913
3.747US TREASURYUST0066 1,000,000.00 946,891.58 08/15/20272.25002/09/2023 921,480.009128282R0 1,201
0.576US TREASURYUST0037 2,000,000.00 1,989,046.34 07/31/20250.25005/28/2021 1,881,260.0091282CAB7 456
0.620US TREASURYUST0038 1,000,000.00 993,583.36 08/31/20250.25005/28/2021 937,070.0091282CAJ0 487
0.601US TREASURYUST0040 1,000,000.00 994,488.10 07/31/20250.25008/11/2021 940,630.0091282CAB7 456
0.586US TREASURYUST0041 1,000,000.00 993,899.83 08/31/20250.25008/11/2021 937,070.0091282CAJ0 487
0.658US TREASURYUST0042 1,000,000.00 994,431.89 11/30/20250.37508/09/2021 928,280.0091282CAZ4 578 Portfolio CITY
CP
Run Date: 05/31/2024 - 13:45 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
April 30, 2024
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Treasury Securities - Coupon
0.681US TREASURYUST0043 1,000,000.00 992,977.28 07/31/20250.25010/05/2021 940,630.0091282CAB7 456
0.707US TREASURYUST0044 2,000,000.00 1,981,851.13 10/31/20250.25010/05/2021 1,859,840.0091282CAT8 548
0.907US TREASURYUST0045 1,000,000.00 992,500.00 08/31/20260.75010/05/2021 907,970.0091282CCW9 852
0.892US TREASURYUST0046 1,000,000.00 993,073.36 07/31/20260.62510/05/2021 908,130.0091282CCP4 821
1.191US TREASURYUST0048 1,000,000.00 989,680.21 05/31/20260.75012/09/2021 916,210.0091282CCF6 760
1.176US TREASURYUST0049 1,000,000.00 992,094.65 06/30/20260.87512/09/2021 916,290.0091282CCJ8 790
1.210US TREASURYUST0050 1,000,000.00 990,817.92 09/30/20260.87512/09/2021 908,160.0091282CCZ2 882
1.678US TREASURYUST0052 2,000,000.00 1,946,771.93 09/30/20250.25002/24/2022 1,866,720.0091282CAM3 517
2.581US TREASURYUST0053 1,000,000.00 958,303.20 10/31/20261.12504/08/2022 911,060.0091282CDG3 913
2.750US TREASURYUST0055 1,000,000.00 996,500.00 04/15/20252.62505/16/2022 975,670.0091282CEH0 349
3.187US TREASURYUST0056 1,000,000.00 933,806.42 07/31/20260.62506/17/2022 908,130.0091282CCP4 821
3.302US TREASURYUST0058 1,000,000.00 936,039.78 09/30/20260.87506/17/2022 908,160.0091282CCZ2 882
3.300US TREASURYUST0061 1,000,000.00 997,755.04 06/30/20273.25009/01/2022 953,480.0091282CEW7 1,155
3.309US TREASURYUST0063 1,000,000.00 982,263.65 07/31/20272.75009/01/2022 937,340.0091282CFB2 1,186
3.787US TREASURYUST0065 1,000,000.00 964,796.40 07/31/20272.75012/22/2022 937,340.0091282CFB2 1,186
3.804US TREASURYUST0067 2,000,000.00 1,980,062.64 01/31/20283.50002/09/2023 1,910,080.0091282CGH8 1,370
4.816US TREASURYUST0068 1,000,000.00 983,663.49 08/31/20284.37511/01/2023 984,690.0091282CHX2 1,583
3.750US TREASURYUST0069 2,000,000.00 2,022,560.00 01/31/20294.00002/02/2024 1,937,900.0091282CJW2 1,736 41,200,576.7839,322,040.0042,000,000.00Subtotal and Average 2.108 808 Total and Average 129,162,565.44 3.055 571124,281,435.44 127,197,886.20 Portfolio CITY
CP
Run Date: 05/31/2024 - 13:45 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Stated
RateMarket Value
April 30, 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 8,282,882.42 8,282,882.4207/01/2018 8,282,882.42SYS39903-39902 1 Subtotal and Average
Total Cash and Investments 137,445,447.86 3.055 571
1 132,564,317.86 135,480,768.62
Portfolio CITY
CP
Run Date: 05/31/2024 - 13:45 PM (PRF_PM2) 7.3.11
City of Manhattan Beach
Investment Portfolio Summary
As of April 30, 2024
PORTFOLIO PROFILE Apr 30, 2024Mar 31, 2024 Feb 29, 2024 Jan 31, 2024Dec 31, 2023 Total Book Value (Excluding Trust Funds)$127,197,886$116,944,095 $119,938,925# $114,017,044 $113,762,069 Increase/(Decrease) from Prior Period 10,253,791 (2,994,830) 5,921,881 254,974 (1,719,966) Percentage Change 8.8% (2.6%) 5.2% 0.2% (1.5%)
Average Yield to Maturity (365 Days) 3.055% 2.940% 2.934% 0 2.839% 2.820% Increase/(Decrease) from Prior Period 0.115% 0.006% 0.115% 0.018% (0.021%)
PORTFOLIO ALLOCATIONS
By Security Value (Par) Percent Par YTMTime Horizon Percent LAIF* $33,162,565 25.68% 4.272%Next 12 months 43%
Medium Term Notes 23,000,000 17.8% 3.640%Months 13-24 16% Federal Agencies 31,000,000 24.0% 2.591%Months 25-36 15% U.S. Treasuries 42,000,000 32.5% 2.108%Months 37-48 17% Total $129,162,565 100.0% 3.052%Months 49-60 8%
*LAIF YTM as of April 30, 2024 BAD Total 100.0%
RECENT ACTIVITY
Security Date of ActivityMaturity DatePurchase (Par)Maturing/Call YTM FHLB - 4.75% Coupon 11/2/2023 9/8/2028 1,000,000 4.860% FFCB - 4.875% Coupon 11/2/2023 11/1/2028 1,000,000 4.861% T - 4.375% Coupon 11/1/2023 8/31/2028 1,000,000 4.770%
T - 4% Coupon 2/8/2024 1/31/2029 2,000,000 3.750%
KO - 1% Coupon 2/2/2024 3/15/2028 1,000,000 4.060%
TOYOTA - 4.65% Coupon 2/5/2024 1/5/2029 1,000,000 4.440% Total Purchases $7,000,000 4.356%
Matured: TMC - 2.25% Coupon 10/18/2023 10/18/2023 1,000,000 2.634% Matured: T - 1.375% Coupon 8/31/2023 8/31/2023 1,000,000 2.432% Matured: T - 2.125% Coupon 2/29/2024 2/29/2024 1,000,000 2.234% Matured: T - 2.125% Coupon 3/31/2024 3/31/2024 1,000,000 2.240% Total Maturing/Calls $4,000,000 2.385%
City of Manhattan Beach
Investment Portfolio Summary
As of April 30, 2024
3-Month 6-Month 2-Year 5-Year 10-YearFebruary 20245.44% 5.28% 4.54% 4.19% 4.21%March 20245.47% 5.36% 4.59% 4.20% 4.21%April 20245.44% 5.38% 4.87% 4.56% 4.54%Portfolio3.055% 3.055% 3.055% 3.055% 3.055%LAIF4.272%4.272%4.272%4.272%4.272%Portfolio, 3.055%LAIF, 4.272%0.00%1.00%2.00%3.00%4.00%5.00%6.00%US Treasuries Yield Curvewww.treas.govMonthly yields are interpolated by the Treasury from the daily yield curve.
CITY OF MANHATTAN BEACH HELD TO MATURITY
Portfolio Maturity Structure Rolling 60 Months
May 2024 through April 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 May 245/16/24 2.6% FFCB nc $2.0MMay 255/15/25 1.76% TVA nc $1.0MMay 265/31/26 1.19% T nc $1.0MMay 275/15/27 3.28% T nc $1.0MMay 285/10/28 4.17% AAPL nc $1.0M 5/31/25 1.06% 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.03% PEP nc $1.0M
Jun 24 6/14/24 0.3% FHLB nc $1.0MJun 25 6/30/25 0.56% T nc $1.0MJun 26 6/30/26 1.18% T nc $1.0MJun 27 6/20/27 3.74% COSTnc $1.0MJun 28 6/9/28 4.48% FHLB nc $1.0M 6/28/24 3.2% FHLB nc $1.0M 6/30/25 0.59% 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% COSTnc $1.0M
Jul 24 7/2/24 1.5% FNMA nc $2.0MJul 25 7/31/25 0.58% T nc $2.0MJul 26 7/31/26 0.89% T nc $1.0MJul 27 7/31/27 3.31% T nc $1.0MJul 28 7/2/24 0.3% FNMA nc $1.0M 7/31/25 0.60% 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.68% T nc $1.0M 7/27/26 4.55% FFCB nc $1.0M
Aug 248/15/24 1.5% FHLB nc $1.0MAug 258/31/25 0.62% T nc $1.0MAug 268/31/26 0.91% T nc $1.0MAug 278/15/27 3.75% T nc $1.0MAug 288/31/28 4.82% T nc $1.0M 8/30/24 2.0% DIS 7/30/24 $2.0M 8/31/25 0.59% T nc $1.0M 8/15/26 3.29% T nc $1.0M 8/22/27 4.28% AMZN nc $1.0M 8/31/24 1.5% T nc $2.0M 8/22/25 1.87% FFCB nc $1.0M
Sep 24 9/6/24 1.9% KO 9/6/24 $1.0MSep 25 9/12/25 1.87% FHLBnc $1.0MSep 26 9/30/26 1.21% T nc $1.0MSep 27 9/12/27 4.91% AAPLnc $1.0MSep 28 9/8/28 4.86% FHLB nc $1.0M 9/13/24 1.8% FHLB nc $2.0M 9/23/25 2.72% FHLMC 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% FNMAnc $2.0MOct 25 10/31/25 0.71% T nc $2.0MOct 26 10/31/26 2.58% T nc $1.0MOct 27 10/8/27 3.60% FNMAnc $1.0MOct 28 10/15/24 1.5% FNMAnc $2.0M 10/31/26 4.18% T nc $1.0M
10/24/24 1.9% BK 9/6/24 $1.0M
Nov 2411/18/24 3.3% FFCBnc $1.0MNov 2511/30/25 0.66% T nc $1.0MNov 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.0MJan 28 1/29/28 4.41% BK nc $1.0MJan 29 1/5/29 4.44%TOYOTA nc $1.0M 1/31/28 3.80% T nc $2.0M 1/31/29 3.75% T nc $2.0M
Feb 25 2/28/25 1.0% T nc $1.0MFeb 26 2/24/26 0.95% MRKMW: 10 $1.0MFeb 27 2/6/27 4.16% MSFTnc $1.0MFeb 28 2/14/28 3.85%FAMCA nc $1.0MFeb 29 Mar 25 Mar 26 Mar 27 3/22/27 2.75% FFCBnc $2.0MMar 28 3/1/28 4.69% CL nc $2.0MMar 29 3/12/27 4.05% FHLBnc $1.0M 3/15/28 4.37% KO nc $1.0M
3/15/28 4.06% KO nc $1.0M
Apr 25 4/15/25 2.8% T nc $1.0M Apr 26 Apr 27 Apr 28 Apr 29 Total By Year (excl LAIF) $23.0m $21.0m $20.0m $22.0m $10.0m Average YTM 1.8% 1.2% 2.8% 3.9% 4.5%
% of Total Securities (excl LAIF) 24% 22% 21% 23% 10%
% of Total Investments (incl LAIF) 43% 16% 15% 17% 8%
Total Securities 74% $96.0M
LAIF 26% $33.2M
Total Investments 100% $129.2M
Shaded rows indicate months with significant cash inflows.
City of Manhattan Beach
Investment Policy Compliance Chart
As of April 30, 2024
Instrument % of Total Limit Compliant? Limit Compliant? Limit Compliant? Local Agency Investment Fund (LAIF) $33,162,565 25.7% $75,000,000 Yes Treasury Securities
US Treasury $42,000,000 32.5% 5 Years Yes
Total U.S. Treasuries (35)TRUE $42,000,000 32.5%
Medium Term (Corporate) Notes
Coca-Cola 2,000,000 1.5% 5.0% Yes 5 Years Yes
Amazon 2,000,000 1.5% 5.0% Yes 5 Years Yes
Costco 2,000,000 1.5% 5.0% Yes 5 Years Yes
Walmart 1,000,000 0.8% 5.0% Yes 5 Years Yes
Colgate-Palmolive 2,000,000 1.5% 5.0% Yes 5 Years Yes
Pepsi Cola 1,000,000 0.8% 5.0% Yes 5 Years Yes
Coca-Cola 1,000,000 0.8% 5.0% Yes 6 Years Yes
Toyota Moto Credit Corp 1,000,000 0.8% 5.0% Yes 6 Years Yes Total Consumer Goods Sector $12,000,000 9.3% 10.0% Yes
Bank of NY 2,000,000 1.5% 5.0% Yes 5 Years Yes
Total Financial Sector $2,000,000 1.5% 10.0% Yes
Johnson & Johnson 2,000,000 1.5% 5.0% Yes 5 Years Yes
Merck 2,000,000 1.5% 5.0% Yes 5 Years Yes
Total Pharmaceuticals Sector $4,000,000 3.1% 10.0% Yes
Apple Inc 2,000,000 1.5% 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.3% 10.0% Yes
Walt Disney Co 2,000,000 1.5% 5.0% Yes 5 Years Yes
Total Communication Services Sector $2,000,000
Total Medium Term Notes (21)TRUE $23,000,000 17.8% 20.0% Yes Federal Agencies
Federal Home Loan Bank (FHLB) $10,000,000 7.7% 33.3% Yes 5 Years Yes Federal Farm Credit (FFCB) 8,000,000 6.2% 33.3% Yes 5 Years Yes Fannie Mae (FNMA) 8,000,000 6.2% 33.3% Yes 5 Years Yes
Freddie Mac (FHLMC) 2,000,000 1.5% 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.5% 33.3% Yes 5 Years Yes Total Federal Agencies (24)TRUE $31,000,000 24.0% 60.0% Yes Total Portfolio $129,162,565 100.0%
Dollar Compliance Percentage Compliance Term Compliance Temporary Suspension
Investments Book Value
LAIF $33,162,565.44
Treasury Securities 41,200,576.78
Federal Agency Issues-Coupon 30,773,703.53
Medium Term Notes 22,061,040.45
Subtotal Investments $127,197,886.20
Demand Deposit/Petty Cash
Cash in Bank $8,282,882.42
Petty Cash 2,280.41
$8,285,162.83
Subtotal City Cash & Investments $135,483,049.03
Bond Funds Held in Trust
Police Fire Refunding $1,622.95
Fire Station 2 COPs 673.61
Marine Ave Park Refunding 1.02
Metlox & Water/Wastewater Refunding 1,600.47
Utility Assessment Districts 1,158,275.68
Pension Obligation Bonds 11,159.04
Subtotal Bonds Held in Trust $1,173,332.77
Investment Trust Funds
PARS Pension Rate Stabilization Trust 3,473,403.98
Treasurer's Balance $140,129,785.78
CITY OF MANHATTAN BEACH
TREASURER'S REPORT
April 30, 2024
Subtotal Demand Deposit
April 4.272
March 4.232
February 4.122
January 4.012
December 3.929
November 3.843
PMIA Average Life(1): 226
LAIF Fair Value Factor(1): 0.994191267
PMIA Daily(1): 4.22
PMIA Quarter to Date(1): 4.12
LAIF Apportionment Rate(2): 4.30
LAIF Earnings Ratio(2): 0.00011755619077389
LAIF Administrative Cost(1)*: 0.27
Treasuries
58.43%
Agencies
22.59%
Certificates of
Deposit/Bank Notes
8.84%
Time
Deposits
2.99%
Commercial
Paper
6.54%
Corporate
Bonds
0.41%
Loans
0.20%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) 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 law 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 subsequent fiscal year.
Source:
(1) State of California, Office of the Treasurer
(2) State of Calfiornia, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 5/15/24
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 03/31/24
Chart does not include $1,969,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
4/30/24
$171.5 billion