CITY OF LAGUNA NIGUEL
CITY COUNCIL AGENDA ITEM
1989
To: Honorable Mayor and Council Members
FROM: Tamara S. Letourneau, City Manager
DATE: April 4, 2023
SUBJECT: Investment Report as of February 28, 2023
RECOMMENDATION
Staff recommends that the City Council receive and file the City of Laguna Niguel Investment Report as of February 28, 2023.
BACKGROUND
The City Investment Policy requires the City Manager to submit an Investment Report monthly to the City Council that contains a summary of investment transactions, including investment types, percent of portfolio, yield, purchase date, maturity date, issuer or institution, par and dollar amount invested, market value, source of market valuation, the portfolio's average weighted yield and maturity, and a description of any local agency funds or investments under the management of contracted parties.
Submission of, and the City Council's action of receiving and filing this Report, addresses the City Council's goal of fiscal sustainability.
ANALYSIS
The following table compares the portfolio balance as of February 2023 to February 2022.
Portfolio Balance February 2023 February 2022 Difference Balance $62,206,740.60 $58,149,112.52 $4,057,628.08
• From January 2023 to February 2023, the City's total cash and investments had a net decrease of $5,049,625.53, going from $67,256,366.13 to $62,206,740.60. The cash outlay exceeded receipts for the month, which is the main reason for the decrease. The City received the first installment of property tax in lieu of vehicle license fees totaling $3,668, 172.50 in January and no such installments in February. The decrease in receipts coupled with payments to the County of Orange for January and February 2023 law enforcement services totaling $2,790,539.84 are the main drivers for the month-to-month change. • The percentage of pooled investments decreased from 47.01% to 46.81%.
Pooled investments include the Local Agency Investment Fund (LAIF) and the Orange County Investment Pool (OCIP).
• The average weighted maturity of City investments, including investment pools, increased from 474 days to 479 days. The average weighted maturity of City investments, including investment pools, is calculated as follows: Sum of days left until maturity of each individual investment multiplied by the cost of each individual investment divided by the total portfolio at cost, excluding cash in bank.
• The net yield of LAIF increased from 2.425% to 2.624%. The net yield of OCIP increased from 2.887% to 3.085%.
• The average weighted yield of City investments, including investment pools, increased from 2.195% to 2.304%. The City's average weighted yield of City investments, including investment pools, is calculated by taking the total investment earnings divided by the total portfolio at cost, excluding cash in bank. A comparison of the City's average weighted yield to short-term and long- term benchmarks is presented below.
City Portfolio Benchmark Comparisons
Average 5-Year 1-Year 6-Month OCIP LAIF
Weighted Treasury Treasury Treasury
Yield
2.304% 4.180 % 5.020% 5.170% 3.085% 2.624%
The monthly Investment Report as of February 28, 2023, is attached.
ALTERNATIVES CONSIDERED
1. The City Council can choose not to receive and file the City of Laguna Niguel Investment Report as of February 28, 2023.
FISCAL REVIEW
There is no fiscal impact as a result of this action.
CONCLUSION
The City Investment Policy requires the submittal of a monthly Investment Report. Staff recommends that the City Council receive and file this Report.
Vimas & Betonsan
Tamara S. Letourneau Trevor Agrelius
City Manager Finance Director
Attachments:
A. Monthly Investment Report as of February 28, 2023
ATTACHMENT A
Investment Report as of February 28, 2023
CITY OF LAGUNA NIGUEL
INVESTMENT REPORT
as of
February 28, 2023
amara S. Letournea
ITY MANAGEF
Trevor Agrelius
FINANCE DIRECTOR
April 4, 2023
CITY OF LAGUNA NIGUEL
INVESTMENT REPORT
TABLE OF CONTENTS
Statement of Compliance/Non-Compliance 1
Report of Cash and Investments 2
LAIF Investment Reports 3-5
OCIP Investment Reports 6-10
US Bank Statement 11-20
PARS Statement 21
City of Laguna Niguel
Statement of Compliance/Non-Compliance with the City's Investment Policy The undersigned officers of the City of Laguna Niguel hereby certify that:
As of February 28, 2023, the City was in compliance with the Investment Policy adopted at the July 19, 2022 Regular City Council Meeting.
Sufficient investment liquidity from cash and cash equivalents and anticipated revenues are available to meet the City's budgeted expenditure requirements for the next six months.
In An
Tamara S. Letourneau Trevor Agrelius
City Manager Finance Director
1 City of Laguna Niguel
Summary of Cash and Investments
2/28/23
Settlement Maturity Coupon Percent of Maximum Allowable Market Description Date Date Rate Yield Cost Portfolio Per Investment Policy Value Petty Cash/Change Drawers 2,600.00 0.00% ' 2,600.00
US Bank Checking Account 2,808,666.11 4.52% $ 2,808,666.11 US Bank Money Market 4.330% 161,726.43 0.26% 20.00% 161,726.43 Local Agency Investment Fund 2.624% 28,064,574.18 45.12% Lesser of $40 million or 55% $ 27,542,271.63 Orange County Investment Pool 3.085% 1,056,313.52 1.70% Lesser of $40 million or 55% $ 1,056,313.52 Federal Home Loan Mortgage Corporation: 8.34% 25.00%
3134GV5R5 7/15/2020 7/15/2024 0.570% 0.610% 1,000,000.00 938,030.00 3137EAEPO 1/29/2021 2/12/2025 1.500% 1.600% 4,188,112.71 3,754,920.00 Federal National Mortgage Association: 13.90% 25.00%
3135G05X7 1/29/2021 8/25/2025 0.375% 0.420% 8,645,922.29 7,822,953.00 Federal Farm Credit Banks: 6.42% 25.00%
3133ENVD9 4/26/2022 4/26/2027 2.875% 3.050% 3,995,360.00 3,765,080.00 Federal Home Loan Banks: 19.75% 25.00%
3130AJTF6 7/14/2020 7/14/2025 0.740% 0.820% 1,000,000.00 905,960.00 3130AJTX7 7/21/2020 7/21/2025 0.720% 0.800% 625,000.00 565,600.00 3130AMFS6 8/12/2021 6/12/2026 0.750% 0.850% 2,001,415.36 1,774,040.00 3130A8XY4 10/18/2021 9/11/2026 1.875% 2.050% 4,665,690.00 4,109,940.00 3130ATBLO 9/19/2022 12/8/2023 3.625% 3.670% 3,991,360.00 3,952,440.00
48.41% 60.00%
Total City Investments Including Investment Pools $ 62,206,740.60 100.00% $ 59,160,540.69 Restricted for Specific Use
PARS 115 Pension Trust 4.37% 2,000,000.00 3.22% 20.00% $ 1,940,249.53 Average weighted maturity of Investments, excluding Investment Pools: 943 days Average weighted maturity of Investments, including Investment Pools: 479 days Average weighted yield of Investments, excluding Investment Pools 1.928% Average weighted yield of Investments, including Investment Pools 2.304% * Market value of City investments is provided by US Bank NOTE: Market value disclosure is for informational purposes only. City policy is to hold all investments to maturity; therefore, any unrealized gain or loss reflected between the cost and market value of an investment will not be realized.
PMIA/LAIF Performance Report
as of 03/09/23
PMIA Average Monthly Quarterly Performance
Effective Yields(1) Quarter Ended 12/31/22
February 2.624 LAIF Apportionment Rate(2). 2.07
January 2.425 LAIF Earnings Ratiol). 0.00005680946709337 December 2.173 LAIF Fair Value Factor' 0.981389258
PMIA Daily. 2.29
PMIA Quarter to Date( 1.98
PMIA Average Life ( 287
Pooled Money Investment Account
Monthly Portfolio Composition (1)
02/28/23
$200.5 billion
Corporate
Commercial Bonds
Time Paper 0.24%
Deposits 4.25%. Loans
2.62% .0.19%
Certificates of
Deposit/Bank Notes
6.21%
Agencies.
21.68%
Treasuries
64.81%
Chart does not include $3,158,000.00 in mortgages, which equates to 0.002%. 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 CaPERS 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:
(2) State of California, Office of the Treasurer
(2) State of Calfiornia, Office of the Controller
3 State of California
Pooled Money Investment Account
Market Valuation
2/28/2023
Carrying Cost Plus
Description Accrued Interest Purch. Fair Value Accrued Interest United States Treasury:
Bills $ 35,472,002,381.05 $ 35,826,707,500.00 NA
Notes $ 94,479,803, 125.60 $ 91,357,303,500.00 $ 237,482,814.00 Federal Agency:
SBA $ 327.908,914.39 $ 327,687,031.65 67 69 972,554.95
MBS-REMICS $ 3,157,960.37 $ 3,107,406.75 14,094.88
Debentures 10,519,944,660.97 10,309,828,600.00 36,864,682.20 Debentures FR - $
EA CA CA CA 23,082,730.00
Debentures CL 2,550,000,000.00 2,465,101.500.00 $
Discount Notes 26,993,358,722.23 27,267.863.500.00 NA
Supranational Debentures 3.076.127,648.22 $ 2,985,206,700.00 $ 10,609,111.90 Supranational Debentures FR $ - -
CDs and YCDs FR $ $
Bank Notes 200,000,000.00 $ 199,684,401.36 $ 1,107,638.89 CDs and YCDs 6A tA EA 12,250,000,000.00 $ 12,240,290,356.81 $ 135,955,874.98 Commercial Paper 8,523,061,958.32 $ 8,610,681,333.30 NA Corporate:
Bonds FR $ $ $
Bonds 475,106,188.63 446,727,560.00 $ 2,887,277.98
Repurchase Agreements $
Reverse Repurchase $ $
Time Deposits 5,254,000,000.00 5,254,000,000.00 NA
PMIA & GF Loans 376,839,000.00 $ 376,839,000.00 NA
TOTAL $ 200,501.310,559.78 $ 197.671,028,389.87 $ 448,976,779.78 Fair Value Including Accrued Interest $ 198,120,005, 169.65 Repurchase Agreements, Time Deposits, PMIA & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). 4 California State Treasurer
Fiona Ma, CPA
Local Agency Investment Fund March 01, 2023
P.O. Box 942809
Sacramento, CA 94209-0001 LAIF Home
(916) 653-3001 MIA Average Monthly
Yields
CITY OF LAGUNA NIGUEL
TREASURER
30111 CROWN VALLEY PARK WAY
LAGUNA NIGUEL, CA 92677
Tran Type Definitions
Account Number:
February 2023 Statement
Effective Transaction Tran Confirm Confirm
Number Number Authorized Caller Amount
2/22/2023 2/21/2023 RW 1724120 N/A KRISTIN FORIER -2,500,000.00 Account Summary
Total Deposit: 0.00 Beginning Balance: 30,564,574.18
Total Withdrawal: -2,500,000.00 Ending Balance: 28,064,574.18 5 COUNTY OF ORANGE
OFFICE OF THE TREASURER-TAX COLLECTOR INGE COUNTE
Shari L. Freidenrich, CPA, CCT, CPFA, ACPFIM
P. O. BOX 4515
SANTA ANA, CA 92702-4515
LIFOR
octreasurer.com/publicfunds
February 28, 2023
CITY OF LAGUNA NIGUEL
Attn: Eric Hendrickson, Finance Director
30111 Crown Valley Parkway
Laguna Niguel, CA 92677
Fund Number :
FEBRUARY 2023 STATEMENT
INVESTMENT BALANCE IN OCIP
Transactions
Transaction Transaction Description Authorized Signer Amount Date
02/01/2023 January 2023 Investment Admin Fee (26.97)
02/27/2023 November 2022 Interest Paid 2,068.24
Summary
Total Deposit: $ 2,068.24 Beginning Balance: $ 1,054,272.25 Total Withdrawal: $ (26.97) Ending Balance: $ 1,056,313.52 6 OF
ORT OFFICE OF THE TREASURER-TAX COLLECTOR BALLGE COUNT
SHARI L. FREIDENRICH, CPA, CCMT, CPFA, ACPFIM
CO
P.O. Box 4515
CALIFORN SANTA ANA, CA 92702-4515
octreasurer.com/publicfunds
ORANGE COUNTY INVESTMENT POOL
APPORTIONMENT YIELDS & BASIS POINT FEES
FY 22/23 Date Monthly Apportionment Monthly Apportionment Charged Basis Actual Basis Year
Gross Yield Net Yield Point Fees Point Fees
YTD July 2022 0.848% (1) 0.793% (1) 5.5
GROSS August 2022 1.055% (1) 1.000% (1) 5.5
YIELD September 2022 1.280% (1) 1.225% (1) 5.5
1.503% October 2022 1.827% (1) 1.772% (1) 5.5
November 2022 2.405% 2.350% 5.5
YTD NET
YIELD
1.448%
Note: Effective December 1, 2022, reporting of Apportionment Yields is no longer being reported for the Orange County Investment Pool and yields are only being reported for the Orange County Treasurer's Pool (OCTP). See the OCT report for December 2022 to June 2023 gross and net yields.
FY 21/22 Year Monthly Apportionment Monthly Apportionment Charged Basis Actual Basis Date Gross Yield Net Yield Point Fees Point Fees
July 2021 0.593% 0.535% 5.8
YTD August 2021 0.575% 0.517% 5.8
GROSS September 2021 0.562% 0.504% 5.8
YIELD October 2021 0.514% 0.456% 5.8
0.523% November 2021 0.515% 0.457% 5.8
December 2021 0.396% 0.338% 5.8 Not Yet
January 2022 0.402% 0.344% 5.8 Available
February 2022 0.439% 0.381% 5.8
YTD NET March 2022 0.462% 0.404% 5.8
YIELD April 2022 0.513% (1) 0.455% (1) 5.8
0.471% May 2022 0.614% (1) 0.594% (1) 2.0
June 2022 0.722% (1) 0.702% (1) 2.0
FY 20/21 Monthly Apportionment Monthly Apportionment Charged Basis Actual Basis Date Year Gross Yield Net Yield Point Fees
Point Fees
July 2020 1.223% 1.164% 5.9 5.0
YTD August 2020 1.144% 1.085% 5.9 5.0
GROSS September 2020 1.060% 1.001% 5.9 5.0
YIELD October 2020 0.956% 0.897% 5.0
0.802% November 2020 0.899% 0.840% 5.0
December 2020 0.767% 0.708% 5.9 5.0
January 2021 0.694% 0.635% 5.9 5.0
February 2021 0.803% 0.744% 5.9 5.0
YTD NET March 2021 0.624% 0.565% 5.9 5.0
YIELD April 2021 0.539% 0.480% 5.9 5.0
0.752% May 2021 0.562% 0.503% 5.9 5.0
June 2021 0.598% 0.588% 1.0 5.0
(1) Revised gross and net yields based on adjustments to interest income Mission: Ensure safe and timely receipt, deposit, collection and investment of public funds.
ORANGE COUNTY TREASURER-TAX COLLECTOR
SUMMARY OF INVESTMENT DATA
INVESTMENT TRENDS
FEBRUARY 2023 INCREASE NET CHANGE INCREASE
JANUARY 2023 (DECREASE) FEBRUARY 2022 (DECREASE) NET CHANGE% Orange County Investment Pool (OCIP)
End Of Month Market Value' 6,231,723,672 5,961,992,475 269,731,197 4.52% 5,991,013,935 240,709,737 4.02% End Of Month Book Value! 6,326,347,517 6,046,419,256 279,928,261 4.63% 6,033,341,535 293,005,982 4.86% Monthly Average Balance 6,060,966,431 6,480,334,588 (419,368,157) -6.47% 5,816,142,612 244,823,819 4.21% Year-To-Date Average Balance 6,059,552,728 6,059,350,771 201,958 0.00% 5,621,265,941 438,286,787 7.80% Monthly Accrued Earnings? 14,596,699 16,133,489 (1,536,791) -9.53% 1,994,182 12,602,517 631.96% Monthly Net Yield? 3.085% 2.887% 0.198% 6.86% 0.381% 2.704% 709.70% Year-To-Date Net Yield? 2.035% 1.900% 0.135% 7.11% 0.435% 1.600% 368.08% Annual Estimated Gross Yield* 2.500% 2.500% 0.000% 0.00% 0.523% 1.977% 378.01% Weighted Average Maturity (WAM)S 198 202 -1.98% 359 (161) -44.85% Orange County Educational Investment Pool (OCEIP)
End Of Month Market Value a 7,673,600,099 7,935,708,761 (262,108,662) -3.30% 5,810,316,399 1,863,283,700 32.07% End Of Month Book Value's 7,790,940,072 8,049,052,605 (258,112,533) -3.21% 5,853,022,011 1,937,918,061 33.11% o Monthly Average Balance? 7,820,686,765 8,142,349,426 (321,662,661) -3.95% 6,003,631,864 1,817,054,901 30.27% Year-To-Date Average Balance? 6,881,466,753 6,747,292,465 134,174,287 1.99% 5,373,923,689 1,507,543,064 28.05% Monthly Accrued Earnings? 18,840,351 20,323,703 (1,483,352) -7.30% 2,156,291 16,684,060 773.74% Monthly Net Yield 3.085% 2.887% 0.198% 6.86% 0.403% 2.682% 665.50% Year-To-Date Net Yield? 2.043% 1.886% 0.157% 8.31% 0.441% 1.602% 363.21% Annual Estimated Gross Yield* 2.500% 2.500% 0.000% 0.00% 0.531% 1.969% 370.81% Weighted Average Maturity (WAM)S 198 202 -1.98% 372 (174) -46.77% 1 Market values provided by Bloomberg and Northern Trust. Market values for OCIP and OCEIP are lower than book values. Short-term rates have risen sharply causing the market values on these pools to be slightly below book values. The OCIP and OCEIP have sufficient 2 The OCIP and OCEIP Monthly Accrued Earnings, Monthly net Yields and Year-To-Date Net Yields are higher than the prior year, primarily due to purchases at higher interest rates, with the FOM raising short-term rates by 3.75% since June 1, 2022. 3 The OCEIP End of Month Market Value, End of Month Book Value, Monthly Average Balance and Year-To-Date Average Balance are all higher than the prior year due to additional funding for new District programs by federal and state governments. 4 The OGIP and OCEIP Annual Estimated Gross Yields are higher than the prior year due to continued higher yields from short-term rate increases. The CIP and OCEIP Annual Estimated Gross Yields for February 2022 are reported at the actual annual gross yields for FY 5 The DIP and OCEIP WAM decreased from the prior year due to shorter term purchases as the FOMC is expected to increase shorterm rates for the next several months.
ORANGE COUNTY TREASURER-TAX COLLECTOR
ORANGE COUNTY INVESTMENT FUND (OCIF)
ORANGE COUNTY TREASURER'S POOL (OCTP) AND SPECIFIC INVESTMENT ACCOUNTS (' FOR THE MONTH ENDED: February 28, 2023
OCTP INVESTMENT STATISTICS - By Reporting Entity®
Average Days to Marutty Daily Vold as of 22282023 MONTHLY Gross Hold Current NAV
DESCRIPTION CURRENT BALANCES
MARKET Value $ 6,231,723,672 198 3.193% 3.115% 0.985(2) Orange County Investment Pool (OCIP) COST (Capital) $ 6,291,380,746 MONTHLY AVG Balance $ 6,060,966,431
BOOK Value s 6,326,347,517
MARKET Value $ 7,673,600,099 198 3.193% 3.115% 0.985(2) Orange County Educational Investment COST (Capital $ 7,747,614,621 Pool (OCEIP) MONTHLY AVG Balance $ 7,820,686,765
BOOK Value $ 7,790,940,072
INVESTMENT STATISTICS - Specific Investment Accounts?)
DESCRIPTION CURRENT BALANCE BY SPECIFIC INVESTMENT
Specific Investment Fund Market Value Book Value Current NAV Funds:
Pension Prepayment-CEO (PP-CEO/*) MARKET Value $ 551,622,536 PP-CEO 497,032,694 501,045,266 0.9920 Fountain Valley School District Fund 40 (FVSD) COST (Capital) $ 557,292,581 FVSD 33,087,674 34,628,483 0.9555 CCCD Series 2017E Bonds (CCCD) MONTHLY AVG Balance $ 557,250,507 CCCD 21,502,167 22,998,643 0.9349 John Wayne Airport Investment Fund (JWA) BOOK Value S 558,672,392 JWA N/A
OCIF TOTALS
INVESTMENTS YEAR-TO-DATE EARNINGS
OCIP 6,291,380,746 OCIP 85,515,638
OCEIP 7,747,614,621|OCEIP 96,838,206
Specific Investment 557,292,581
Cash 49,123,301
Total Assets in the County Treasury $ 14,645,411,249 Total OCTP Year-To-Date Earnings Is 182,353,844
KEY POOL STATISTICS
INTEREST RATE YIELD WEIGHTED AVERAGE MATURITY (WAM)
OCIP - YTD NET YIELD 2.035% OCTP 198
OCEIP - YTD NET YIELD 2.043% LGIP (Standard & Poors) 27 80-DAY T-BILL YIELD - MONTHLY AVERAGE 4.755%
(1) Reported in compliance with Government Code Section 53646(b)(1), with with IPS requiring at least quarterly reporting per Government Code Section Section (d), in Section Vil of this report 2) The current OCT level NAVs for OCIP and OCEIP have both decreased slightly to 0.965. Short-term rates continue to rise causing the market values on OCIP, OCEIP, PPCEO, FVSD an CCD to stay below book values. The OCIP, OCEIP, FVSD and CCCD have sufficient liquidity to meet projected cash flow needs. PP-CEO rounds to 1.000 and has sufficient liquidity to me cash flow needs.
(3) Specific Investment Account set up in January, 2023 for plan sponsor pension payments authorized by CEO. 9 ORANGE COUNTY TREASURER - TAX COLLECTOR
BY INVESTMENT TYPE AT MARKET VALUE - By Percentage Holdings February 28, 2023
100%
90%
80%
70%
60%
50%
40%
20%
10%
0%
Orange County Investment Pool Orange County Educational Investment Pool Orange County Investment Pool Orange County Educational Investment Pool In Thousands In Thousands
U.S. GOVERNMENT AGENCIES 3,613,760 57.99% •IU.S. GOVERNMENT AGENCIES 4,477,616 58.35% U.S. TREASURIES 1,505,886 24.16% U.S. TREASURIES 1,818,100 23.69% MONEY MARKET MUTUAL FUNDS 1,021,832 16.40% MONEY MARKET MUTUAL FUNDS 1,266,065 16.50% MUNICIPAL DEBT 57,982 0.93% MUNICIPAL DEBT 71,842 0.94% I LOCAL AGENCY INVESTMENT FUND 32.264 0.52% I LOCAL AGENCY INVESTMENT FUND 39.977 0.52% $ 6,231.724 100.00% 7.673,600 100.00%
19118
00--M -UC-UU -060-04
0220657-00-04007-04
usbank.
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
MARKET VALUE SUMMARY
Current Period
02/01/23 to 02/28/23
Beginning Market Value Change: -331,348.20
$28,082,037.63 $36,000,000
Taxable Interest 46,693.55
$30,000,000
Change in Investment Value -378,041.75
$24,000,000
Ending Market Value $27,750,689.43 $18,000,000
$12,000,000
$6,000,000
$O-
Beginning Ending
MV MV
$28,082,037.63 $27,750,689.43
12 $476,609.48 100.00 $27,750,689.43 Total Market Value 469,600.00 99.40 27,588,963.00 Taxable Bonds
7,009.48 0.60 161,726.43 Cash & Equivalents
Annual Income Total Market Value Assets
Estimated % of Current Period
ASSET SUMMARY
February 1, 2023 to February 28, 2023 ACCOUNT NUMBER:
CITY OF LAGUNA NIGUEL
usbank.
0220657-00-04007-04
0D--M -UC-UU -060-04
19118
13 $46,693.55 Total Current Period Income
46,693.55 Taxable Interest
Current Period
Income Received
INCOME SUMMARY
February 1, 2023 to February 28, 2023 ACCOUNT NUMBER:
CITY OF LAGUNA NIGUEL
usbank.
0220657-00-04007-04
00- -M -UC-UU -060-04
19118
14 $0.00 Ending Cash 02/28/2023
-46,693.55 Net Money Market Activity
46,693.55 Taxable Interest
$0.00 Beginning Cash 02/01/2023
Cash
CASH SUMMARY
February 1, 2023 to February 28, 2023 ACCOUNT NUMBER:
CITY OF LAGUNA NIGUEL
usbank.
0220657-00-04007-04
00--M -UC-UU -060-04
19118
02057000400-04
usbank.
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
ASSET DETAIL
Security Description Percent
Unrealized of Total Estimated Estimated
Shares/Face Amt Price Market Value Tax Cost Gain/Loss Portfolio Annual Income Current Yield Cash & Equivalents
Cash/Money Market
First American Government - 31846V567
Oblig Fd CIZ
161,726.430 1.0000 161,726.43 161,726.43 0,00 0.6 7,009.48 4.33 Total Cash/Money Market $161,726.43 $161,726.43 $0.00 0.6 $7,009.48 Total Cash & Equivalents $161,726.43 $161,726.43 $0.00 0.6 $7,009.48 Taxable Bonds
US Government Issues
FHLMC - 3137EAEPO
1.500 02/12/2025
4,000,000.000 93.8730 3,754,920.00 4,188,112.71 -433,192.71 13.5 60.000.00 1.60 FHLMC MTN - 3134GV5R5
0.570 07/15/2024
1,000,000.000 93.8030 938,030.00 1,000,000.00 -61,970.00 3.4 5,700.00 0.61 FNMA - 3135G05X7
0.375 08/25/2025
8,700,000.000 89.9190 7,822,953.00 8,645,922.29 -822,969.29 28.2 32,625.00 0.42 Federal Farm Credit Bks - 3133ENVD9
2.875 04/26/2027
4,000,000.000 94.1270 3,765,080.00 3,995,360.00 -230,280.00 13.6 115,000.00 3.05 Federal Home Loan Bks - 3130AJTX7
0.720 07/21/2025
625,000.000 90.4960 565,600.00 625,000.00 -59,400.00 2.0 4,500.00 0.80 19118
022057-0-0407-04
usbank.
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
ASSET DETAIL (continued)
Security Description Percent
Unrealized of Total Estimated Estimated
Shares/Face Amt Price Market Value Tax Cost Gain/Loss Portfolio Annual Income Current Yield
0.40 07042025 BKS - 3130AUTF
1,000,000.000 90.5960 905,960.00 1,000,000.00 -94,040.00 3.3 7,400.00 0.82
0.750 061212028n BKs - 3130AMF56
2,000,000.000 88.7020 1,774,040.00 2,001,415.36 -227,375.36 6.4 15,000.00 0.85 1875 09 1212an Bks - 3130A8X4
4,500,000.000 91.3320 4,109,940.00 4,665,690.00 -555,750.00 14.8 84,375.00 2.05 5025 12032023n BKs - 3130ATBLO
4,000,000.000 98.8110 3,952,440.00 3,991,360.00 -38,920.00 14.2 145,000.00 3.67 Total US Government Issues $27,588,963.00 $30,112,860.36 -$2,523,897.36 99.4 $469,600.00 Total Taxable Bonds $27,588,963.00 $30,112,860.36 -$2,523,897.36 99.4 $469,600.00 Total Assets $27,750,689.43 $30,274,586.79 -$2,523,897.36 100.0 $476,609.48 Estimated Current Yield 1.71
ASSET DETAIL MESSAGES
Time of trade execution and trading party (if not disclosed) will be provided upon request. 19118
OD--M -UC-UU -060-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
ASSET DETAIL MESSAGES (continued)
Estimated Current Yield and Estimated Annual Income are estimates provided for informational purposes only and should not be relied on for making investment, trading, or tax decisions. The estimates may not represent the actual value earned by your investments and they provide no guarantee of what your investments may earn in the future. 17 19118
0220857-0004007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
TRANSACTION DETAIL
Date
Posted Activity Description Cash Tax Cost
Beginning Balance 02/01/2023 $0.00 $30,227,893.24
02/01/23 Asset Income Interest Earned On 381.05
First Am Govt Ob Fd CIZ
Interest From 1/1/23 To 1/31/23
02/13/23 Asset Income Interest Earned On 30,000.00
FHLMC 1.500% 2/12/25
0.0075 USD/$1 Pv On 4,000,000 Par Value Due 2/12/23
02/27/23 Asset Income Interest Earned On 16,312.50
F N MA 0.375% 8/25/25
0.001875 USD/$1 Pv On 8,700,000 Par Value Due 2/25/23
Purchase Combined Purchases For The Period 2/ 1/23 - 2/28/23 Of -46,693.55 46,693.55 First Am Govt Ob Fd CI Z
Ending Balance 02/28/2023 $0.00 $30,274,586.79
19118
0220-57-00-0-067-04
usbank.
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
BOND SUMMARY
60% |
50%
40%
30%
20%
10%
0%
2023 2024 2025 2026 2027
Percentage of
Par Value Market Value Category
MATURITY
2023 4,000,000.00 3,952,440.00 14.33
2024 1,000,000.00 938,030.00 3.41
2025 14,325,000.00 13,049,433.00 47.30
2026 6,500,000.00 5,883,980.00 21.32
2027 4,000,000.00 3,765,080.00 13.64
Total of Category $29,825,000.00 $27,588,963.00 100.00
MOODY'S RATING
Aaa 28,825,000.00 26,650,933.00 96.60
N/A 1,000,000.00 938,030.00 3.40
Total of Category $29,825,000.00 $27,588,963.00 100.00
19118
02257-00-0400-04
usbank.
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: February 1, 2023 to February 28, 2023
BOND SUMMARY (continued)
Percentage of
Par Value Market Value Category
S&P RATING
AA+ 28,825,000.00 26,650,933.00 96.60
N/A 1,000,000.00 938,030.00 3.40
Total of Category $29,825,000.00 $27,588,963.00 100.00
BOND SUMMARY MESSAGES
Bata contained within this section excluded Mutual Funds, Exchange Traded Funds, and Closed Ended Funds.
PUBLIC
AGENCY PARS
RETIREMENT
SERVICES
CITY OF LAGUNA NIGUEL Account Report for the Period
PARS Post-Employment Benefits Trust 2/1/2023 to 2/28/2023 Tamara Letourneau
City Manager
City of Laguna Niguel
30111 Crown Valley Parkway
Laguna Niguel, CA 92677
Account Summary
Balance as of Balance as of
Source 2/1/2023 Contributions Earnings Expenses Distributions Transfers 2/28/2023 PENSION $1,984,369.53 $0.00 -$43,179.45 $940.55 $0.00 $0.00 $1,940,249.53 Totals S1,984,369.53 $0.00 -$43,179.45 $940.55 $0.00 $0.00 $1,940,249.53 Investment Selection
Source
PENSION Moderately Conservative HighMark PLUS
Investment Objective
Source
The dual goals of the Moderately Conservative Strategy are current income and moderate capital appreciation. The major portion of the assets is PENSION committed to income-producing securities. Market fluctuations should be expected.
Investment Return
Annualized Return
Source 1-Month 3-Months 1-Year 3-Years 5-Years 10-Years Plan's Inception Date PENSION -2.18% 0.39% -7.76% 5/26/2020
Information as provided by US Bank, Trustee for PARS; Not FDIC Insured; No Bank Guarantee; May Lose Value Account balances are inclusive of Trust Administration, Trustee and Investment Management fees Headquarters - 4350 Von Karman Ave., Suite 100, Newport Beach, CA 92660 www.pars.org 21