City of Manhattan Beach
Finance Department
Investment Portfolio
February 2023
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.
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63
CITY OF MANHATTAN BEACH
Portfolio Management
February 1, 2023 through February 28, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
Maturity
Term
YTM
360 Equiv.
YTM
365 Equiv.
LAIF 39,000,000.00 130.63 2.588139,000,000.0039,000,000.00 2.624 Medium Term Notes 15,511,056.45 1,66712.18 2.78381115,054,380.0016,000,000.00 2.821 Federal Agency Issues - Coupon 30,935,870.65 1,42924.30 2.24668829,717,350.0031,000,000.00 2.277 Treasury Securities - Coupon 41,880,289.09 1,58732.89 1.9581,08039,387,970.0043,000,000.00 1.985 127,327,216.19 100.00%
Investments
123,159,700.00129,000,000.00 1,073 622 2.321 2.353
Cash
(not included in yield calculations)
Passbook/Checking 11,353,073.95 1 0.000111,353,073.9511,353,073.95 0.000 138,680,290.14Total Cash and Investments 134,512,773.95140,353,073.95 1,073 622 2.321 2.353 Current Year
February 28
200,621.55
Fiscal Year To Date
1,427,099.73
Total Earnings Month Ending
__________________________________________________ ____________________ STEVE S. CHARELIAN, FINANCE DIRECTOR
Portfolio CITY
CP
Reporting period 02/01/2023-02/28/2023
Run Date: 04/10/2023 - 17:22 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
February 28, 2023
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
LAIF
2.624Local Agency Invest. Fund3000 39,000,000.00 39,000,000.00 2.62407/01/2018 39,000,000.00SYS3000 1 39,000,000.0039,000,000.0039,000,000.00Subtotal and Average 2.624 1 Medium Term Notes
3.298APPLE INCMTN0098 1,000,000.00 997,244.68 05/03/20232.40005/22/2018 995,280.00 AA+037833AK6 63
4.905APPLE INCMTN0112 1,000,000.00 917,649.61 09/12/20272.90010/25/2022 929,720.00037833DB3 1,656
1.963AMAZON.COM LLCMTN0111 1,000,000.00 967,368.59 05/12/20261.00002/24/2022 885,340.00 AA023135BX3 1,168
4.282AMAZON.COM LLCMTN0116 1,000,000.00 951,464.00 08/22/20273.15002/09/2023 933,690.00023135BC9 1,635
1.951BANK OF NY MELLOMTN0106 1,000,000.00 1,009,011.00 08/16/20232.20009/09/2019 986,090.00 A06406FAD5 168
1.850BANK OF NY MELLOMTN0109 1,000,000.00 1,011,205.00 10/24/20242.10002/10/2020 951,020.00 A06406RAL1 603
1.977Walt DisneyMTN0107 2,000,000.00 1,992,716.62 08/30/20241.75012/12/2019 1,900,840.00 A-254687FK7 548
4.593Johnson & JohnsonMTN0113 1,000,000.00 846,890.32 09/01/20270.95010/25/2022 855,780.00 AAA478160CP7 1,645
3.880Johnson & JohnsonMTN0114 1,000,000.00 870,132.01 09/01/20270.95012/22/2022 855,780.00 AAA478160CP7 1,645
1.890COCA-COLA COMTN0108 1,000,000.00 993,679.00 09/06/20241.75012/12/2019 959,880.00 A+191216CL2 555
2.025MICROSOFT CORPMTN0104 1,000,000.00 999,000.00 08/08/20232.00007/01/2019 986,890.00 AAA594918BQ6 160
4.163MICROSOFT CORPMTN0115 1,000,000.00 966,773.11 02/06/20273.30012/22/2022 955,410.00 AAA594918BY9 1,438
0.950MERCK & CO INCMTN0110 1,000,000.00 991,420.00 02/24/20260.75010/05/2021 884,860.00 A+58933YAY1 1,091
3.461TOYOTA MOTOR CREDITMTN0099 1,000,000.00 999,500.00 09/20/20233.45009/21/2018 990,360.00 A+89236TFN0 203
2.634TOYOTA MOTOR CREDITMTN0101 1,000,000.00 997,002.51 10/18/20232.25003/26/2019 983,440.00 A+89236TDK8 231 15,511,056.4515,054,380.0016,000,000.00Subtotal and Average 2.821 811 Federal Agency Issues - Coupon
3.850FARMER MACFAC0304 1,000,000.00 1,000,000.00 02/14/20283.85002/14/2023 979,890.0031422XW99 1,811
3.000FED FARM CR BKFAC0276 2,000,000.00 1,990,360.00 06/19/20232.89010/02/2018 1,988,080.00 AA+3133EJSD2 110
2.840FED FARM CR BKFAC0278 2,000,000.00 2,002,956.33 07/24/20233.08012/12/2018 1,982,580.00 AA+3133EJK57 145
1.870FED FARM CR BKFAC0294 1,000,000.00 997,642.00 08/22/20251.80002/24/2022 933,340.00 AA+3133ENPX2 905
2.747FED FARM CR BKFAC0296 2,000,000.00 2,033,468.61 03/22/20273.15004/11/2022 1,904,840.00 AA+3133EJDV8 1,482
2.625FED FARM CR BKFAC0297 2,000,000.00 2,000,000.00 05/16/20242.62505/16/2022 1,939,600.00 AA+3133ENWP1 442
3.250FED FARM CR BKFAC0301 1,000,000.00 956,408.74 11/18/20240.87506/17/2022 933,350.003133ENEJ5 628
4.550FED FARM CR BKFAC0303 1,000,000.00 998,356.00 07/27/20264.50010/27/2022 997,760.003133ENV72 1,244
1.771Federal Home Loan BankFAC0285 2,000,000.00 2,037,915.11 09/13/20242.87512/11/2019 1,936,240.003130A2UW4 562
1.470Federal Home Loan BankFAC0289 1,000,000.00 1,001,306.00 08/15/20241.50002/07/2020 949,770.00 AA+3130AGWK7 533
0.312Federal Home Loan BankFAC0291 1,000,000.00 1,038,617.51 06/14/20242.87502/04/2021 970,200.00 AA+3130A1XJ2 471
1.871Federal Home Loan BankFAC0293 1,000,000.00 995,852.00 09/12/20251.75002/24/2022 930,270.00 AA+3130A8ZQ9 926
3.230Federal Home Loan BankFAC0300 1,000,000.00 990,620.00 06/28/20242.75006/17/2022 968,680.003130ASDS5 485
4.343Federal Home Loan BankFAC0302 1,000,000.00 884,333.51 06/12/20260.87510/24/2022 889,680.003130AN4T4 1,199 Portfolio CITY
CP
Run Date: 04/10/2023 - 17:22 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
February 28, 2023
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon
2.722Federal Home Loan MortgageFAC0298 2,000,000.00 1,874,439.22 09/23/20250.37505/13/2022 1,797,420.00 AA+3137EAEX3 937
1.700Fannie MaeFAC0286 2,000,000.00 1,993,020.00 10/15/20241.62512/11/2019 1,895,820.00 AA+3135G0W66 594
1.500Fannie MaeFAC0287 2,000,000.00 2,011,260.00 10/15/20241.62502/07/2020 1,895,820.00 AA+3135G0W66 594
1.526Fannie MaeFAC0288 2,000,000.00 2,007,546.98 07/02/20241.75002/07/2020 1,913,140.00 AA+3135G0V75 489
0.259Fannie MaeFAC0290 1,000,000.00 1,022,920.24 07/02/20241.75002/04/2021 956,570.00 AA+3135G0V75 489
0.499Fannie MaeFAC0292 1,000,000.00 1,018,986.51 09/12/20232.87502/04/2021 987,750.00 AA+3135G0U43 195
1.763Tennessee Valley AuthorityFAC0295 1,000,000.00 974,973.77 05/15/20250.75002/24/2022 913,230.00 AA+880591EW8 806
2.894Tennessee Valley AuthorityFAC0299 1,000,000.00 1,104,888.12 11/01/20256.75005/13/2022 1,053,320.00 AA+880591CJ9 976 30,935,870.6529,717,350.0031,000,000.00Subtotal and Average 2.277 688 Treasury Securities - Coupon
2.525US TREASURYUST0029 1,000,000.00 993,037.29 07/31/20231.25002/14/2019 984,570.00912828S92 152
2.432US TREASURYUST0030 1,000,000.00 992,841.36 08/31/20231.37502/14/2019 981,950.009128282D1 183
2.234US TREASURYUST0033 1,000,000.00 995,039.06 02/29/20242.12505/13/2019 970,820.00912828W48 365
2.240US TREASURYUST0034 1,000,000.00 994,687.50 03/31/20242.12505/13/2019 968,160.00912828W71 396
1.493US TREASURYUST0035 2,000,000.00 2,013,594.72 08/31/20241.87502/07/2020 1,908,360.009128282U3 549
0.561US TREASURYUST0036 1,000,000.00 991,593.08 06/30/20250.25005/28/2021 903,980.00912828ZW3 852
0.591US TREASURYUST0039 1,000,000.00 991,355.45 06/30/20250.25008/11/2021 903,980.00912828ZW3 852
1.058US TREASURYUST0047 1,000,000.00 980,845.11 05/31/20250.25012/08/2021 905,780.00912828ZT0 822
1.001US TREASURYUST0051 1,000,000.00 1,003,906.25 02/28/20251.12512/09/2021 930,470.00912828ZC7 730
2.665US TREASURYUST0054 2,000,000.00 1,909,374.01 01/31/20271.50004/08/2022 1,797,340.00912828Z78 1,432
3.287US TREASURYUST0057 1,000,000.00 936,296.28 08/15/20261.50006/17/2022 907,580.009128282A7 1,263
3.285US TREASURYUST0059 1,000,000.00 962,398.01 05/15/20272.37509/01/2022 926,640.00912828X88 1,536
3.295US TREASURYUST0060 1,000,000.00 961,974.60 05/15/20272.37509/01/2022 926,640.00912828X88 1,536
3.241US TREASURYUST0062 1,000,000.00 884,026.81 06/30/20270.50009/01/2022 852,460.00912828ZV5 1,582
4.180US TREASURYUST0064 1,000,000.00 902,486.90 10/31/20261.62510/25/2022 908,130.00912828YQ7 1,340
3.747US TREASURYUST0066 1,000,000.00 933,828.13 08/15/20272.25002/09/2023 919,300.009128282R0 1,628
0.576US TREASURYUST0037 2,000,000.00 1,982,140.38 07/31/20250.25005/28/2021 1,801,880.0091282CAB7 883
0.620US TREASURYUST0038 1,000,000.00 989,739.80 08/31/20250.25005/28/2021 898,130.0091282CAJ0 914
0.601US TREASURYUST0040 1,000,000.00 991,006.90 07/31/20250.25008/11/2021 900,940.0091282CAB7 883
0.586US TREASURYUST0041 1,000,000.00 990,239.73 08/31/20250.25008/11/2021 898,130.0091282CAJ0 914
0.658US TREASURYUST0042 1,000,000.00 991,526.79 11/30/20250.37508/09/2021 893,280.0091282CAZ4 1,005
0.681US TREASURYUST0043 1,000,000.00 988,541.88 07/31/20250.25010/05/2021 900,940.0091282CAB7 883
0.707US TREASURYUST0044 2,000,000.00 1,971,951.75 10/31/20250.25010/05/2021 1,786,100.0091282CAT8 975
0.907US TREASURYUST0045 1,000,000.00 992,500.00 08/31/20260.75010/05/2021 882,580.0091282CCW9 1,279
0.892US TREASURYUST0046 1,000,000.00 990,392.08 07/31/20260.62510/05/2021 880,980.0091282CCP4 1,248 Portfolio CITY
CP
Run Date: 04/10/2023 - 17:22 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
February 28, 2023
Portfolio Details - Investments
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Treasury Securities - Coupon
1.191US TREASURYUST0048 1,000,000.00 985,409.95 05/31/20260.75012/09/2021 889,100.0091282CCF6 1,187
1.176US TREASURYUST0049 1,000,000.00 988,932.51 06/30/20260.87512/09/2021 891,250.0091282CCJ8 1,217
1.210US TREASURYUST0050 1,000,000.00 987,478.98 09/30/20260.87512/09/2021 884,610.0091282CCZ2 1,309
1.678US TREASURYUST0052 2,000,000.00 1,916,355.89 09/30/20250.25002/24/2022 1,792,960.0091282CAM3 944
2.581US TREASURYUST0053 1,000,000.00 943,586.68 10/31/20261.12504/08/2022 890,780.0091282CDG3 1,340
2.750US TREASURYUST0055 1,000,000.00 996,500.00 04/15/20252.62505/16/2022 956,950.0091282CEH0 776
3.187US TREASURYUST0056 1,000,000.00 908,183.10 07/31/20260.62506/17/2022 880,980.0091282CCP4 1,248
3.302US TREASURYUST0058 1,000,000.00 912,781.52 09/30/20260.87506/17/2022 884,610.0091282CCZ2 1,309
3.300US TREASURYUST0061 1,000,000.00 997,755.04 06/30/20273.25009/01/2022 959,490.0091282CEW7 1,582
3.309US TREASURYUST0063 1,000,000.00 977,313.97 07/31/20272.75009/01/2022 939,450.0091282CFB2 1,613
3.787US TREASURYUST0065 1,000,000.00 954,972.14 07/31/20272.75012/22/2022 939,450.0091282CFB2 1,613
3.804US TREASURYUST0067 2,000,000.00 1,975,695.44 01/31/20283.50002/09/2023 1,939,220.0091282CGH8 1,797 41,880,289.0939,387,970.0043,000,000.00Subtotal and Average 1.985 1,080 Total and Average 129,000,000.00 2.353 622123,159,700.00 127,327,216.19 Portfolio CITY
CP
Run Date: 04/10/2023 - 17:22 PM (PRF_PM2) 7.3.11
YTM
365
Par Value Book Value
Stated
RateMarket Value
February 28, 2023
Portfolio Details - Cash
Issuer
Portfolio Management
CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Money Market Fund
0.000UNION BANK39901 11,353,073.95 11,353,073.9507/01/2018 11,353,073.95SYS39903-39902 1 Subtotal and Average
Total Cash and Investments 140,353,073.95 2.353 622
1 134,512,773.95 138,680,290.14
Portfolio CITY
CP
Run Date: 04/10/2023 - 17:22 PM (PRF_PM2) 7.3.11
City of Manhattan Beach
Investment Portfolio Summary
As of February 28, 202
3 PORTFOLIO PROFILE Feb 28, 2023 Jan 31, 2023 Dec 31, 2022 Nov 30, 2022 Oct 31, 2022 Total Book Value (Excluding Trust Funds) $127,327,216 $124,465,943 $118,465,943 $124,553,045 $124,553,045 Increase/(Decrease) from Prior Period 2,861,273 6,000,000 (6,087,101) - (2,457,020) Percentage Change 2.3% 5.1% (4.9%) 0.0% (1.9%)
Average Yield to Maturity (365 Days) 2.353% 2.237% 2.157% 2.066% 1.991% Increase/(Decrease) from Prior Period 0.117% 0.080% 0.090% 0.076% 0.183%
PORTFOLIO ALLOCATIONS
By Security Value (Par) Percent Par YTM Time Horizon Percent LAIF* $39,000,000 30.23% 2.624% Next 12 months 40%
Medium Term Notes 16,000,000 12.4% 2.821% Months 13-24 18% Federal Agencies 31,000,000 24.0% 2.277% Months 25-36 17% U.S. Treasuries 43,000,000 33.3% 1.985% Months 37-48 12% Total $129,000,000 100.0% 2.352% Months 49-60 12%
*LAIF YTM as of February 28, 2023 GOOD Total 100.0%
RECENT ACTIVITY
Security Date of Activity Maturity Date Purchase (Par) Maturing/Call YTM T - 2.75% Coupon 12/20/2022 7/31/2027 1,000,000 3.787%
MTN - 0.95% Coupon 12/20/2022 9/1/2027 1,000,000 3.880% MTN - 3.3% Coupon 12/20/2022 2/6/2027 1,000,000 4.163%
MTN - 3.15% Coupon 2/9/2023 8/22/2027 1,000,000 4.282%
T - 2.25% Coupon 2/9/2023 8/15/2027 1,000,000 3.747%
T - 3.5% Coupon 2/9/2023 1/31/2028 2,000,000 3.804%
FAMCA - 3.85% Coupon 2/13/2023 2/14/2028 1,000,000 3.850% Total Purchases $8,000,00 0 3.915%
Matured: MTN - 2.5% Coupon 10/15/2022 10/15/2022 1,000,000 2.640% Matured: T - 2% Coupon 10/31/2022 10/31/2022 1,000,000 2.250% Matured: FHLB - 2.5% Coupon 12/9/2022 12/9/2022 1,000,000 2.357% Matured: FFCB - 2.57% Coupon 2/16/2023 2/16/2023 2,000,000 2.708% Total Maturing/Calls $5,000,000 2.532%
City of Manhattan Beach
Investment Portfolio Summary
As of February 28, 202
3 FUNDS HELD IN TRUST Value
Police/Fire Refunding Bonds $35.98
Fire Station 2 COPs 60.81
Marine Avenue Refunding Bonds 1.25
Pension Obligation Bonds 2,436.89
Metlox & Water/Wastewater Refunding Bonds 8,327.40
UUAD Assessment Refunding Bonds 512,323.66
UUAD Assessment District 12 & 14 403,578.84
UUAD Assessment District 4 204,036.73
PARS Investment Trust 2,831,122.30
Total Funds Held in Trust $3,961,923.86
As of February 28, 2023
3‐Month 6 ‐Month 2 ‐Year 5 ‐Year 10 ‐Year
December 2022 4.36% 4.71% 4.29% 3.76% 3.62%
January 2023 4.69% 4.80% 4.21% 3.64% 3.53%
February 2023 4.79% 4.97% 4.53% 3.94% 3.75%
Portfolio 2.353% 2.353% 2.353% 2.353% 2.353%
LAIF 2 624% 2 624% 2 624% 2 624% 2 624%
Portfolio, 2.353%
LAIF, 2.624%
0.00%
1.00%
2.00%
3.00%
4.00%
5.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
March 2023 through February 2028
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 Mar 23 Mar 24 3/31/24 2.24% T nc $1.0M Mar 25 Mar 26 Mar 27 3/22/27 2.75% FFCB nc $2.0M Apr 23 Apr 24 Apr 25 4/15/25 2.75% T nc $1.0M Apr 26 Apr 27 May 23 5/3/23 3.3% MTN MW: 15 $1.0M May 24 5/16/24 2.63% FFCB nc $2.0M May 25 5/15/25 1.76% 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 5/31/25 1.06% T nc $1.0M 5/12/26 1.96% MTN nc $1.0M 5/15/27 3.29% T nc $1.0M Jun 23 6/19/23 3.0% FFCB nc $2.0M Jun 24 6/14/24 0.31% FHLB nc $1.0M Jun 25 6/30/25 0.56% T nc $1.0M Jun 26 6/30/26 1.18% T nc $1.0M Jun 27 6/30/27 3.30% T nc $1.0M 6/28/24 3.23% 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 Jul 23 7/24/23 2.8% FFCB nc $2.0M Jul 24 7/2/24 1.53% FNMA nc $2.0M Jul 25 7/31/25 0.58% 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 7/31/23 2.5% T nc $1.0M 7/2/24 0.26% 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 23 8/31/23 2.4% T nc $1.0M Aug 24 8/15/24 1.47% FHLB nc $1.0M Aug 25 8/31/25 0.62% 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 8/8/23 2.0% MTN MW:12.5 $1.0M 8/30/24 1.98% MTN 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% MTN nc $1.0M 8/16/23 2.0% MTN 6/16/23 $1.0M 8/31/24 1.49% T nc $2.0M 8/22/25 1.87% FFCB nc $1.0M Sep 23 9/20/23 3.5% MTN nc $1.0M Sep 24 9/6/24 1.89% MTN 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% MTN nc $1.0M 9/12/23 0.5% FNMA nc $1.0M 9/13/24 1.77% 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% MTN nc $1.0M 9/30/25 1.68% T nc $2.0M 9/1/27 3.88% MTN nc $1.0M
Oct 23 10/18/23 2.6% MTN nc $1.0M Oct 24 10/15/24 1.70% 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/15/24 1.50% FNMA nc $2.0M 10/31/26 4.18% T nc $1.0M
10/24/24 1.85% MTN 9/6/24 $1.0M
Nov 23 Nov 24 11/18/24 3.25% FFCB nc $1.0M Nov 25 11/30/25 0.66% T nc $1.0M Nov 26 Nov 27 11/1/25 2.89% TVA nc $1.0M
Dec 23 Dec 24 Dec 25 Dec 26 Dec 27
Jan 24 Jan 25 Jan 26 Jan 27 1/31/27 2.67% T
nc $2.0M Jan 28 1/31/28 3.80% T nc $2.0M
Feb 24 2/29/24 2.2% T nc $1.0M Feb 25 2/28/25 1.00% T nc $1.0M Feb 26 2/24/26 0.95% MTN MW: 10 $1.0M Feb 27 2/6/27 4.16% MTN nc $1.0M Feb 28 2/14/28 3.85% FAMCA nc $1.0M Total By Year (excl LAIF) $13.0m $23.0m $22.0m $16.0m $16.0m % of Total Securities (excl LAIF) 14% 26% 24% 18% 18%
% of Total Investments (incl LAIF) 40% 18% 17% 12% 12%
Total Securities 70% $90.0M
LAIF 30% $39.0M
Total Investments 100%
$129.0M
Shaded rows indicate months with significant cash inflows.
City of Manhattan Beach
Investment Policy Compliance Chart
As of February 28, 202
3 Instrument % of Total Limit Compliant? Limit Compliant? Limit Compliant? Local Agency Investment Fund (LAIF) $39,000,000 30.2% $75,000,000 Yes Treasury Securities
US Treasury $43,000,000 33.3% 5 Years Yes
Total U.S. Treasuries (37) TRUE $43,000,000 33.3%
Medium Term (Corporate) Notes
Coca-Cola 1,000,000 0.8% 5.0% Yes 5 Years Yes
Amazon 2,000,000 1.6% 5.0% Yes 5 Years Yes
Total Consumer Goods Sector $3,000,000 2.3% 10.0% Yes
Toyota Motor Credit 2,000,000 1.6% 5.0% Yes 5 Years Yes Bank of NY 2,000,000 1.6% 5.0% Yes 5 Years Yes
Total Financial Sector $4,000,000 3.1% 10.0% Yes
Johnson & Johnson 2,000,000 1.6% 5.0% Yes 5 Years Yes
Merck 1,000,000 0.8% 5.0% Yes 5 Years Yes
Total Pharmaceuticals Sector $3,000,000 2.3% 10.0% Yes
Apple Inc 2,000,000 1.6% 5.0% Yes 5 Years Yes
Microsoft Corp 2,000,000 1.6% 5.0% Yes 5 Years Yes
Total Technology Sector $4,000,000 3.1% 10.0% Yes
Walt Disney Co 2,000,000 1.6% 5.0% Yes 5 Years Yes
Total Communication Services Sector $2,000,000
Total Medium Term Notes (15) TRUE $16,000,000 12.4% 20.0% Yes Federal Agencies
Federal Home Loan Bank (FHLB) $7,000,000 5.4% 33.3% Yes 5 Years Yes Federal Farm Credit (FFCB) 11,000,000 8.5% 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.6% 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.6% 33.3% Yes 5 Years Yes Total Federal Agencies (22) TRUE $31,000,000 24.0% 60.0% Yes Total Portfolio $129,000,000 100.0%
Dollar Compliance Percentage Compliance Term Compliance Temporary Suspension
Investments Book Value
LAIF $39,000,000.00
Treasury Securities 41,880,289.09
Federal Agency Issues-Coupon 30,935,870.65
Medium Term Notes 15,511,056.45
Subtotal Investments $127,327,216.19
Demand Deposit/Petty Cash
Cash in Bank $11,353,073.95
Petty Cash 2,771.41
$11,355,845.36
Subtotal City Cash & Investments $138,683,061.55
Bond Funds Held in Trust
Police Fire Refunding $35.98
Fire Station 2 COPs 60.81
Marine Ave Park Refunding 1.25
Metlox & Water/Wastewater Refunding 8,373.35
Utility Assessment Districts 1,119,939.23
Pension Obligation Bonds 2,436.89
Subtotal Bonds Held in Trust $1,130,847.51
Investment Trust Funds
PARS Pension Rate Stabilization Trust 2,768,175.79
Treasurer's Balance $142,582,084.85
CITY OF MANHATTAN BEACH
TREASURER'S REPORT
February 28, 2023
Subtotal Demand Deposit
February 2.624
January 2.425
December 2.173
PMIA Quarter to Date(1): 1.98
287PMIA Average Life(1):
2.07LAIF Apportionment Rate(2):
0.00005680946709337
0.981389258
LAIF Earnings Ratio(2):
LAIF Fair Value Factor(1):
PMIA Daily(1): 2.29
Treasuries
64.81%
Agencies
21.68%
Certificates of
Deposit/Bank Notes
6.21%
Time
Deposits
2.62%
Commercial
Paper
4.25%
Corporate
Bonds
0.24%
Loans
0.19%
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).
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 03/09/23
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 12/31/22
Chart does not include $3,158,000.00 in mortgages, which equates to 0.002%. Percentages may not total 100% due to rounding.
Pooled Money Investment Account
Monthly Portfolio Composition (1)
02/28/23
$200.5 billion