Cities Index.
Investment Portfolio for the Month Ending June 30, 2022

Manhattan Beach City Council
August 16, 2022

Document
Investment Portfolio for the Month Ending June 30, 2022
Meeting
August 16, 2022
Body
Manhattan Beach City Council
Pages
4
Original file
863 KB
Text extracted from the city's file for reading and search. Open the original on legistar.granicus.com. That file is the official record.

City of Manhattan Beach
Finance Department
Investment Portfolio
June 2022
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
June 1, 2022 through June 30, 2022
Portfolio Summary
% of
Portfolio
Book
ValueInvestments
Market
Value
Par
Value
Days to
Maturity
Term
YTM
360 Equiv.

YTM
365 Equiv.

LAIF 48,000,000.00 136.03 0.849148,000,000.0048,000,000.00 0.861 Medium Term Notes 12,938,861.86 1,6259.71 2.25262812,647,910.0013,000,000.00 2.284 Federal Agency Issues - Coupon 35,083,296.38 1,45626.33 2.14871034,499,890.0035,000,000.00 2.178 Treasury Securities - Coupon 37,212,691.00 1,51527.93 1.6191,01935,773,440.0038,000,000.00 1.641 133,234,849.24 100.00%
Investments
130,921,240.00134,000,000.00 965 533 1.542 1.564
Cash
(not included in yield calculations)
Passbook/Checking 4,636,710.90 1 0.00014,636,710.904,636,710.90 0.000 137,871,560.14Total Cash and Investments 135,557,950.90138,636,710.90 965 533 1.542 1.564 Current Year
June 30
143,985.37
Fiscal Year To Date
1,362,847.80 1,362,847.80
Fiscal Year EndingTotal Earnings Month Ending
__________________________________________________ ____________________ STEVE S. CHARELIAN, FINANCE DIRECTOR
Portfolio CITY
CP
Reporting period 06/01/2022-06/30/2022
Run Date: 08/03/2022 - 09:46 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63

YTM
365

Page 1 ends

Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2022
Portfolio Details - Investments
Issuer
Portfolio Management

CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
LAIF

0.861Local Agency Invest. Fund3000 48,000,000.00 48,000,000.00 0.86107/01/2018 48,000,000.00SYS3000 1 48,000,000.0048,000,000.0048,000,000.00Subtotal and Average 0.861 1 Medium Term Notes

3.060APPLE INCMTN0096 1,000,000.00 998,215.34 09/12/20222.10004/23/2018 999,500.00 AA+037833DC1 73

3.298APPLE INCMTN0098 1,000,000.00 993,212.52 05/03/20232.40005/22/2018 994,220.00 AA+037833AK6 306

1.963AMAZON.COM LLCMTN0111 1,000,000.00 962,522.34 05/12/20261.00002/24/2022 909,410.00 AA023135BX3 1,411

1.951BANK OF NY MELLOMTN0106 1,000,000.00 1,009,011.00 08/16/20232.20009/09/2019 989,450.00 A06406FAD5 411

1.850BANK OF NY MELLOMTN0109 1,000,000.00 1,011,205.00 10/24/20242.10002/10/2020 967,650.00 A06406RAL1 846

1.977Walt DisneyMTN0107 2,000,000.00 1,990,531.60 08/30/20241.75012/12/2019 1,927,400.00 A-254687FK7 791

1.890COCA-COLA COMTN0108 1,000,000.00 993,679.00 09/06/20241.75012/12/2019 976,950.00 A+191216CL2 798

2.025MICROSOFT CORPMTN0104 1,000,000.00 999,000.00 08/08/20232.00007/01/2019 990,140.00 AAA594918BQ6 403

0.950MERCK & CO INCMTN0110 1,000,000.00 991,420.00 02/24/20260.75010/05/2021 906,080.00 A+58933YAY1 1,334

2.640ORACLE CORPMTN0103 1,000,000.00 995,436.00 10/15/20222.50005/13/2019 997,860.00 A68389XAP0 106

3.461TOYOTA MOTOR CREDITMTN0099 1,000,000.00 999,500.00 09/20/20233.45009/21/2018 1,002,510.00 A+89236TFN0 446

2.634TOYOTA MOTOR CREDITMTN0101 1,000,000.00 995,129.06 10/18/20232.25003/26/2019 986,740.00 A+89236TDK8 474 12,938,861.8612,647,910.0013,000,000.00Subtotal and Average 2.284 628 Federal Agency Issues - Coupon

2.708FED FARM CR BKFAC0271 2,000,000.00 1,998,598.80 02/16/20232.57002/16/2018 1,998,320.00 AA+3133EJDE6 230

3.000FED FARM CR BKFAC0276 2,000,000.00 1,990,360.00 06/19/20232.89010/02/2018 1,999,920.00 AA+3133EJSD2 353

2.840FED FARM CR BKFAC0278 2,000,000.00 2,005,564.87 07/24/20233.08012/12/2018 1,999,700.00 AA+3133EJK57 388

1.870FED FARM CR BKFAC0294 1,000,000.00 997,642.00 08/22/20251.80002/24/2022 962,250.00 AA+3133ENPX2 1,148

2.747FED FARM CR BKFAC0296 2,000,000.00 2,037,426.79 03/22/20273.15004/11/2022 1,998,420.00 AA+3133EJDV8 1,725

2.625FED FARM CR BKFAC0297 2,000,000.00 2,000,000.00 05/16/20242.62505/16/2022 1,986,840.00 AA+3133ENWP1 685

3.250FED FARM CR BKFAC0301 1,000,000.00 944,835.84 11/18/20240.87506/17/2022 950,150.003133ENEJ5 871

2.357Federal Home Loan BankFAC0268 2,000,000.00 2,001,325.94 12/09/20222.50001/10/2018 2,001,720.00 AA+3130A3KM5 161

1.771Federal Home Loan BankFAC0285 2,000,000.00 2,049,048.42 09/13/20242.87512/11/2019 1,991,720.003130A2UW4 805

1.470Federal Home Loan BankFAC0289 1,000,000.00 1,001,306.00 08/15/20241.50002/07/2020 968,480.00 AA+3130AGWK7 776

0.312Federal Home Loan BankFAC0291 1,000,000.00 1,051,883.06 06/14/20242.87502/04/2021 996,410.00 AA+3130A1XJ2 714

1.871Federal Home Loan BankFAC0293 1,000,000.00 995,852.00 09/12/20251.75002/24/2022 959,620.00 AA+3130A8ZQ9 1,169

3.230Federal Home Loan BankFAC0300 1,000,000.00 990,620.00 06/28/20242.75006/17/2022 994,210.003130ASDS5 728

2.722Federal Home Loan MortgageFAC0298 2,000,000.00 1,851,447.42 09/23/20250.37505/13/2022 1,834,580.00 AA+3137EAEX3 1,180

1.700Fannie MaeFAC0286 2,000,000.00 1,993,020.00 10/15/20241.62512/11/2019 1,938,080.00 AA+3135G0W66 837

1.500Fannie MaeFAC0287 2,000,000.00 2,011,260.00 10/15/20241.62502/07/2020 1,938,080.00 AA+3135G0W66 837

1.526Fannie MaeFAC0288 2,000,000.00 2,010,053.35 07/02/20241.75002/07/2020 1,954,820.00 AA+3135G0V75 732 Portfolio CITY
CP
Run Date: 08/03/2022 - 09:46 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 YTM
365

Page 2 ends

Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2022
Portfolio Details - Investments
Issuer
Portfolio Management

CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Federal Agency Issues - Coupon

0.259Fannie MaeFAC0290 1,000,000.00 1,030,532.13 07/02/20241.75002/04/2021 977,410.00 AA+3135G0V75 732

0.499Fannie MaeFAC0292 1,000,000.00 1,032,548.30 09/12/20232.87502/04/2021 999,910.00 AA+3135G0U43 438

2.793Tennessee Valley AuthorityFAC0277 2,000,000.00 1,997,700.69 08/15/20221.87512/12/2018 1,999,620.00 AA+880591EN8 45

2.493Tennessee Valley AuthorityFAC0279 1,000,000.00 999,186.02 08/15/20221.87502/14/2019 999,810.00 AA+880591EN8 45

1.763Tennessee Valley AuthorityFAC0295 1,000,000.00 969,705.09 05/15/20250.75002/24/2022 935,330.00 AA+880591EW8 1,049

2.894Tennessee Valley AuthorityFAC0299 1,000,000.00 1,123,379.66 11/01/20256.75005/13/2022 1,114,490.00 AA+880591CJ9 1,219 35,083,296.3834,499,890.0035,000,000.00Subtotal and Average 2.178 710 Treasury Securities - Coupon

2.681US TREASURYUST0027 2,000,000.00 1,998,854.10 07/31/20222.00012/12/2018 2,001,400.00912828XQ8 30

2.510US TREASURYUST0028 1,000,000.00 999,603.40 07/31/20222.00002/14/2019 1,000,700.00912828XQ8 30

2.525US TREASURYUST0029 1,000,000.00 987,069.26 07/31/20231.25002/14/2019 981,950.00912828S92 395

2.432US TREASURYUST0030 1,000,000.00 987,472.35 08/31/20231.37502/14/2019 981,520.009128282D1 426

2.201US TREASURYUST0031 1,000,000.00 998,810.51 09/30/20221.75003/25/2019 999,840.00912828L57 91

2.250US TREASURYUST0032 1,000,000.00 991,406.25 10/31/20222.00003/25/2019 999,560.009128283C2 122

2.234US TREASURYUST0033 1,000,000.00 995,039.06 02/29/20242.12505/13/2019 986,410.00912828W48 608

2.240US TREASURYUST0034 1,000,000.00 994,687.50 03/31/20242.12505/13/2019 985,270.00912828W71 639

1.493US TREASURYUST0035 2,000,000.00 2,017,666.34 08/31/20241.87502/07/2020 1,952,900.009128282U3 792

0.561US TREASURYUST0036 1,000,000.00 989,911.69 06/30/20250.25005/28/2021 920,700.00912828ZW3 1,095

0.591US TREASURYUST0039 1,000,000.00 989,626.54 06/30/20250.25008/11/2021 920,700.00912828ZW3 1,095

1.058US TREASURYUST0047 1,000,000.00 976,882.03 05/31/20250.25012/08/2021 922,770.00912828ZT0 1,065

1.001US TREASURYUST0051 1,000,000.00 1,003,906.25 02/28/20251.12512/09/2021 951,800.00912828ZC7 973

2.665US TREASURYUST0054 2,000,000.00 1,898,276.95 01/31/20271.50004/08/2022 1,867,340.00912828Z78 1,675

3.287US TREASURYUST0057 1,000,000.00 927,509.56 08/15/20261.50006/17/2022 939,140.009128282A7 1,506

0.576US TREASURYUST0037 2,000,000.00 1,978,687.40 07/31/20250.25005/28/2021 1,836,320.0091282CAB7 1,126

0.620US TREASURYUST0038 1,000,000.00 987,818.02 08/31/20250.25005/28/2021 915,630.0091282CAJ0 1,157

0.601US TREASURYUST0040 1,000,000.00 989,266.30 07/31/20250.25008/11/2021 918,160.0091282CAB7 1,126

0.586US TREASURYUST0041 1,000,000.00 988,409.68 08/31/20250.25008/11/2021 915,630.0091282CAJ0 1,157

0.658US TREASURYUST0042 1,000,000.00 990,074.24 11/30/20250.37508/09/2021 913,360.0091282CAZ4 1,248

0.681US TREASURYUST0043 1,000,000.00 986,324.18 07/31/20250.25010/05/2021 918,160.0091282CAB7 1,126

0.707US TREASURYUST0044 2,000,000.00 1,967,002.06 10/31/20250.25010/05/2021 1,822,500.0091282CAT8 1,218

0.907US TREASURYUST0045 1,000,000.00 992,500.00 08/31/20260.75010/05/2021 910,230.0091282CCW9 1,522

0.892US TREASURYUST0046 1,000,000.00 989,051.44 07/31/20260.62510/05/2021 906,880.0091282CCP4 1,491

1.191US TREASURYUST0048 1,000,000.00 983,274.82 05/31/20260.75012/09/2021 914,960.0091282CCF6 1,430

1.176US TREASURYUST0049 1,000,000.00 987,351.44 06/30/20260.87512/09/2021 918,010.0091282CCJ8 1,460

1.210US TREASURYUST0050 1,000,000.00 985,809.51 09/30/20260.87512/09/2021 913,280.0091282CCZ2 1,552 Portfolio CITY
CP
Run Date: 08/03/2022 - 09:46 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 YTM
365

Page 3 ends

Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2022
Portfolio Details - Investments
Issuer
Portfolio Management

CITY OF MANHATTAN BEACH
Days to
Maturity
S&PCUSIP Investment #
Purchase
Date
Treasury Securities - Coupon

1.678US TREASURYUST0052 2,000,000.00 1,901,147.87 09/30/20250.25002/24/2022 1,827,260.0091282CAM3 1,187

2.581US TREASURYUST0053 1,000,000.00 936,228.42 10/31/20261.12504/08/2022 921,760.0091282CDG3 1,583

2.750US TREASURYUST0055 1,000,000.00 996,500.00 04/15/20252.62505/16/2022 989,140.0091282CEH0 1,019

3.187US TREASURYUST0056 1,000,000.00 895,371.44 07/31/20260.62506/17/2022 906,880.0091282CCP4 1,491

3.302US TREASURYUST0058 1,000,000.00 901,152.39 09/30/20260.87506/17/2022 913,280.0091282CCZ2 1,552 37,212,691.0035,773,440.0038,000,000.00Subtotal and Average 1.641 1,019 Total and Average 134,000,000.00 1.564 533130,921,240.00 133,234,849.24 Portfolio CITY
CP
Run Date: 08/03/2022 - 09:46 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 YTM
365

Page 4 ends

Par Value Book Value
Stated
RateMarket Value
June 30, 2022
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,636,710.90 4,636,710.9007/01/2018 4,636,710.90SYS39903-39902 1 Subtotal and Average
Total Cash and Investments 138,636,710.90 1.564 533
1 135,557,950.90 137,871,560.14
Portfolio CITY
CP
Run Date: 08/03/2022 - 09:46 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 City of Manhattan Beach
Investment Portfolio Summary
As of June 30, 202
2 PORTFOLIO PROFILE Jun 30, 2022 May 31, 2022 Apr 30, 2022 Mar 31, 2022 Feb 28, 2022 Total Book Value (Excluding Trust Funds) $133,234,849 $128,525,189 $123,551,851 $120,690,830 $121,691,375 Increase/(Decrease) from Prior Period 4,709,661 4,973,338 2,861,021 (1,000,545) 5,809,143 Percentage Change 3.7% 4.0% 2.4% (0.8%) 5.0%
Average Yield to Maturity (365 Days) 1.564% 1.436% 1.325% 1.216% 1.188% Increase/(Decrease) from Prior Period 0.128% 0.111% 0.109% 0.028% 0.049%

PORTFOLIO ALLOCATIONS
By Security Value (Par) Percent Par YTM Time Horizon Percent LAIF* $48,000,000 35.82% 0.861% Next 12 months 49%
Medium Term Notes 13,000,000 9.7% 2.284% Months 13-24 11% Federal Agencies 35,000,000 26.1% 2.178% Months 25-36 17% U.S. Treasuries 38,000,000 28.4% 1.641% Months 37-48 15% Total $134,000,000 100.0% 1.564% Months 49-60 8%
*LAIF YTM as of June 30, 2022 GOOD Total 100.0%

RECENT ACTIVITY
Security Date of Activity Maturity Date Purchase (Par) Maturing/Call YTM FHLB - 2.75% Coupon 6/17/2022 6/28/2024 1,000,000 3.230% FFCB - 0.875% Coupon 6/17/2022 11/18/2024 1,000,000 3.250% T - 0.375% Coupon 6/17/2022 7/31/2026 1,000,000 3.187%
T - 1.5% Coupon 6/17/2022 8/15/2026 1,000,000 3.287%
T - 0.875% Coupon 6/17/2022 9/30/2026 1,000,000 3.302%
Total Purchases $5,000,00 0 3.251%
Matured: FFCB - 2.15% Coupon 3/15/2022 3/15/2022 1,000,000 1.894% Matured: FNMA - 1.875% Coupon 4/5/2022 4/5/2022 1,000,000 1.850% Called: MTN - 2.65% Coupon 4/22/2022 5/23/2022 1,000,000 1.883% Matured: MTN - 2.35% Coupon 5/16/2022 5/16/2022 1,000,000 3.193% Total Maturing/Calls $4,000,000 2.205%
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 City of Manhattan Beach
Investment Portfolio Summary
As of June 30, 202
2 FUNDS HELD IN TRUST Value
Police/Fire Refunding Bonds $107,632.65
Fire Station 2 COPs 139,498.61
Marine Avenue Refunding Bonds 75,151.14
Pension Obligation Bonds 1,038,299.52
Metlox & Water/Wastewater Refunding Bonds 161,193.12
UUAD Assessment Refunding Bonds 511,643.02
UUAD Assessment District 12 & 14 403,042.68
UUAD Assessment District 4 203,734.71
PARS Investment Trust 1,603,011.48
Total Funds Held in Trust $4,243,206.93
As of June 30, 2022
3‐Month 6 ‐Month 2 ‐Year 5 ‐Year 10 ‐Year
April 2022 0.76% 1.26% 2.54% 2.78% 2.75%
May 2022 0.99% 1.49% 2.62% 2.87% 2.90%
June 2022 1.54% 2.17% 3.00% 3.19% 3.14%
Portfolio 1.564% 1.564% 1.564% 1.564% 1.564%
LAIF 0 861% 0 861% 0 861% 0 861% 0 861%
Portfolio, 1.564%
LAIF, 0.861%

0.00%

0.50%

1.00%

1.50%

2.00%

2.50%

3.00%

3.50%
US Treasuries Yield Curve
www.treas.gov
Monthly yields are interpolated by the Treasury from the daily yield curve.

DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63

CITY OF MANHATTAN BEACH HELD TO MATURITY
Portfolio Maturity Structure Rolling 60 Months
July 2022 through June 2027
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 Jul 22 7/31/22 2.7% T nc $2.0M Jul 23 7/24/23 2.84% 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 7/31/22 2.5% T nc $1.0M 7/31/23 2.53% 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/25 0.68% T nc $1.0M
Aug 22 8/15/22 2.8% TVA nc $2.0M Aug 23 8/31/23 2.43% 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 8/15/22 2.5% TVA nc $1.0M 8/8/23 2.03% 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/16/23 1.95% 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 22 9/12/22 3.1% MTN MW: 7.5 $1.0M Sep 23 9/20/23 3.46% 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 9/30/22 2.2% T nc $1.0M 9/12/23 0.50% 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/30/25 1.68% T nc $2.0M
Oct 22 10/31/22 2.2% T nc $1.0M Oct 23 10/18/23 2.63% 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 10/15/22 2.6% MTN MW: 12.5 $1.0M 10/15/24 1.50% FNMA nc $2.0M 10/24/24 1.85% MTN 9/6/24 $1.0M
Nov 22 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 11/1/25 2.89% TVA nc $1.0M
Dec 22 12/9/22 2.4% FHLB nc $2.0M Dec 23 Dec 24 Dec 25 Dec 26 Jan 23 Jan 24 Jan 25 Jan 26 Jan 27 1/31/27 2.67% T nc $2.0M Feb 23 2/16/23 2.7% FFCB nc $2.0M Feb 24 2/29/24 2.23% 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 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/31/25 1.06% T nc $1.0M 5/12/26 1.96% MTN 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/28/24 3.23% FHLB nc $1.0M 6/30/25 0.59% T nc $1.0M
Total By Year (excl LAIF) $17.0m $15.0m $23.0m $20.0m $11.0m % of Total Securities (excl LAIF) 20% 17% 27% 23% 13%
% of Total Investments (incl LAIF) 49% 11% 17% 15% 8%
Total Securities 64% $86.0M
LAIF 36% $48.0M
Total Investments 100%
$134.0M
Shaded rows indicate months with significant cash inflows.

DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 City of Manhattan Beach
Investment Policy Compliance Chart
As of June 30, 202
2 Instrument % of Total Limit Compliant? Limit Compliant? Limit Compliant? Local Agency Investment Fund (LAIF) $48,000,000 35.8% $75,000,000 Yes Treasury Securities
US Treasury $38,000,000 28.4% 5 Years Yes
Total U.S. Treasuries (32) TRUE $38,000,000 28.4%
Medium Term (Corporate) Notes
Coca-Cola 1,000,000 0.7% 5.0% Yes 5 Years Yes
Amazon 1,000,000 0.7% 5.0% Yes 5 Years Yes
Total Consumer Goods Sector $2,000,000 1.5% 10.0% Yes
Toyota Motor Credit 2,000,000 1.5% 5.0% Yes 5 Years Yes Bank of NY 2,000,000 1.5% 5.0% Yes 5 Years Yes
Total Financial Sector $4,000,000 3.0% 10.0% Yes
Merck 1,000,000 0.7% 5.0% Yes 5 Years Yes
Total Pharmaceuticals Sector $1,000,000 0.7% 10.0% Yes
Apple Inc 2,000,000 1.5% 5.0% Yes 5 Years Yes
Microsoft Corp 1,000,000 0.7% 5.0% Yes 5 Years Yes
Oracle Corp 1,000,000 0.7% 5.0% Yes 5 Years Yes
Total Technology Sector $4,000,000 3.0% 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 (12) TRUE $13,000,000 9.7% 20.0% Yes Federal Agencies
Federal Home Loan Bank (FHLB) $8,000,000 6.0% 33.3% Yes 5 Years Yes Federal Farm Credit (FFCB) 12,000,000 9.0% 33.3% Yes 5 Years Yes Fannie Mae (FNMA) 8,000,000 6.0% 33.3% Yes 5 Years Yes
Freddie Mac (FHLMC) 2,000,000 1.5% 33.3% Yes 5 Years Yes Tennessee Valley Authority (TVA) 5,000,000 3.7% 33.3% Yes 5 Years Yes Total Federal Agencies (23) TRUE $35,000,000 26.1% 60.0% Yes Total Portfolio $134,000,000 100.0%
Dollar Compliance Percentage Compliance Term Compliance Temporary Suspension
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 Investments Book Value
LAIF $48,000,000.00
Treasury Securities 37,212,691.00
Federal Agency Issues-Coupon 35,083,296.38
Medium Term Notes 12,938,861.86
Subtotal Investments $133,234,849.24
Demand Deposit/Petty Cash
Cash in Bank $4,636,710.90
Petty Cash 2,383.70
$4,639,094.60
Subtotal City Cash & Investments $137,873,943.84
Bond Funds Held in Trust
Police Fire Refunding $107,632.65
Fire Station 2 COPs 139,498.61
Marine Ave Park Refunding 75,151.14
Metlox & Water/Wastewater Refunding 161,242.88
Utility Assessment Districts 1,118,420.41
Pension Obligation Bonds 1,038,299.52
Subtotal Bonds Held in Trust $2,640,245.21
Investment Trust Funds
PARS Pension Rate Stabilization Trust 1,603,011.48
Treasurer's Balance $142,117,200.53

CITY OF MANHATTAN BEACH

TREASURER'S REPORT
June 30, 2022
Subtotal Demand Deposit
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63 June 0.861
May 0.684
Apr 0.523
PMIA Quarter to Date(1): 0.69%
311PMIA Average Life(1):

0.75LAIF Apportionment Rate(2):

0.00002057622201151

0.987125414
LAIF Earnings Ratio(2):

LAIF Fair Value Factor(1):

PMIA Daily(1): 0.99%
Treasuries

68.02%
Agencies

18.90%
Certificates of
Deposit/Bank Notes

5.71%
Time
Deposits

1.90%
Commercial
Paper

4.91%
Corporate
Bonds

0.21%
Loans

0.35%
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 07/18/22
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 06/30/22
Chart does not include $4,693,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)
06/30/22
$234.5 billion
DocuSign Envelope ID: 28C41FF8-D9F0-49FE-A53D-ED66CA08BB63

← All documents from this meeting