CITY OF LAGUNA NIGUEL
CITY COUNCIL AGENDA ITEM
To: Honorable Mayor and Council Members
FROM: Tamara S. Letourneau, City Manager
DATE: March 7, 2023
SUBJECT: Investment Report as of December 31, 2022
RECOMMENDATION
Staff recommends that the City Council receive and file the City of Laguna Niguel Investment Report as of December 31, 2022.
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 December 2022 to December 2021.
Portfolio Balance December 2022 December 2021 Difference Balance $62,840,006.70 $55,081,189.39 $7,758,817.31
• From November 2022 to December 2022, the City's total cash and investments had a net increase of $4,910,667.27, going from $57,929,339.43 to $62,840,006.70. Cash receipts were higher than the prior month, primarily due to the second and third installments of secured property tax payments received totaling $7,311,274.56. Cash outlay was lower than in the prior month which included the $1,600,000 payment to CaPERS and $1,000,000 contributed to PARS.
• The percentage of pooled investments increased from 42.26% to 46.93%.
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, decreased from 570 days to 506 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.007% to 2.173%. The net yield of OCIP increased from 2.350% to 2.766%, which is reflected in the Summary of Investment Data - Investment Trends on page 8 of the Investment Report. The net yield for July through November 2022 is reported by the County of Orange in the schedule on page 7 and will no longer be used to report the net yield. • The average weighted yield of City investments, including investment pools, increased from 1.966% to 2.065%. 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.065% 3.990% 4.730% 4.760% 2.766% 2.173%
The monthly Investment Report as of December 31, 2022, is attached.
ALTERNATIVES CONSIDERED
1. The City Council can choose not to receive and file the City of Laguna Niguel Investment Report as of December 31, 2022.
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.
Jamasas Retoureau Kristin Joreo
Tamara S. Letourneau Kristin Forier
City Manager Interim Finance Director
Attachments:
A. Monthly Investment Report as of December 31, 2022
ATTACHMENT A
Investment Report as of December 31, 2022
CITY OF LAGUNA NIGUEL
INVESTMENT REPORT
as of
December 31, 2022
Kristin Forier
INTERIM FINANCE DIRECTOR
March 7, 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-21
PARS Statement 22
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 December 31, 2022, 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.
Janasa Soletoureau KristinFarien
Tamara S. Letourneau Kristin Forier
City Manager Interim Finance Director
City of Laguna Niguel
Summary of Cash and Investments
12/31/22
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 3,132,618.44 4.99% 3,132,618.44 US Bank Money Market Variable 105,919.48 0.17% 20.00% 105,919.48 Local Agency Investment Fund 2.173% 28,433,336.85 45.25% Lesser of $40 million or 55% $ 27,904,171.35 Orange County Investment Pool 2.766% 1,052,671.57 1.68% Lesser of $40 million or 55% 1,052,671.57 Federal Home Loan Mortgage Corporation: 8.26% 25.00%
3134GV5R5 7/15/2020 7/15/2024 0.570% 0.610% 1,000,000.00 937,560.00 3137EAEPO 1/29/2021 2/12/2025 1.500% 1.590% 4,188,112.71 3,769,120.00 Federal National Mortgage Association: 13.76% 25.00%
3135G05X7 1/29/2021 8/25/2025 0.375% 0.420% 8,645,922.29 7,846,443.00 Federal Farm Credit Banks: 6.36% 25.00%
3133ENVD9 4/26/2022 4/26/2027 2.875% 3.020% 3,995,360.00 3,807,880.00 Federal Home Loan Banks: 19.55% 25.00%
3130AJTF6 7/14/2020 7/14/2025 0.740% 0.810% 1,000,000.00 907,600.00 3130AJTX7 7/21/2020 7/21/2025 0.720% 0.790% 625,000.00 566,525.00 3130AMFS6 8/12/2021 6/12/2026 0.750% 0.840% 2,001,415.36 1,781,380.00 3130A8XY4 10/18/2021 9/11/2026 1.875% 2.040% 4,665,690.00 4,132,260.00 3130ATBLO 9/19/2022 12/8/2023 3.625% 3.670% 3,991,360.00 3,947,680.00
47.92% 60.00%
Total City Investments Including Investment Pools $ 62,840,006.70 100.00% $ 59,894,428.84 Restricted for Specific Use
PARS 115 Pension Trust -1.670% $ 2,000,000.00 3.18% 20.00% $ 1,902,146.97 Average weighted maturity of Investments, excluding Investment Pools: 1,002 days Average weighted maturity of investments, including Investment Pools: 506 days Average weighted yield of Investments, excluding investment Pools 1.919% Average weighted yield of Investments, including Investment Pools 2.065% * 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 01/18/23
PMIA Average Monthly Quarterly Performance
Effective Yields(1) Quarter Ended 12/31/22
December 2.173 LAIF Apportionment Rate(2). 2.07
November 2.007 LAIF Earnings Ratio(2) 0.00005680946709337 October 1.772 LAIF Fair Value Factor: 0.981389258
PMIA Daily):
MIA Quarter to Date
MIA Average Life(
Pooled Money Investment Account
Monthly Portfolio Composition (1)
12/31/22
$199.6 billion
Corporate
Commercial Bonds
Time Paper 0.27%
Deposits 3.95%. Loans
2.58% 0.19%
Certificates of
Deposit/Bank Notes.
6.26%
Agencies
20.08%
Treasuries
66.67%
Chart does not include $3,466,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).
(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
12/31/2022
Carrying Cost Plus
Description Accrued Interest Purch. Amortized Cost Fair Value Accrued Interest United States Treasury:
Bills $ 35,572,298,376.73|$ 35,896,965,984.48 $ 35,813,625,000.00 NA Notes $ 96,336,543,012.97 $ 96,327,058,254.86 $ 93,171,299,000.00 $ 287,620,426.50 Federal Agency:
SBA $ 338,889,007.89 $ 338,889,007.89 $ 338,773,080.09 $ 1,004,954.08 MBS-REMICs $ 3,465,697.68 $ 3,465,697.68 $ 3,425,155.69 $ 15,470.20 Debentures $ 9,096,582,571.99 $ 9,096,520,766.45 8,886,499,200.00 $ 26,924,215.25 Debentures FR $ - $ $
Debentures CL $ 2,900,000,000.00 2,900,000,000.00 2,833,516,000.00 $ 26,791,810.50 Discount Notes $ 25,325,736,041.68 $ 25,562,614,902.86 25,510,373,000.00 NA Supranational Debentures $ 2,426,390,203.78 $ 2,425,759,648.22 $ 2,338,151,100.00 $ 7,376,541.50 Supranational Debentures FR $ - $ $ $
CDs and YCDs FR $ $ $ $
Bank Notes $ 100,000,000.00 $ 100,000,000.00 $ 99,990,832.29 $ - 1,541,666.67 CDs and YCDs $ 12,400,000,000.00 $ 12,400,000,000.00 $ 12,382,893,375.51 $ 124,083,166.66 Commercial Paper $ 7,895,772,944.44 $ 7,975,413,013.94 $ 7,970,181,986.08 NA Corporate:
Bonds FR $ $ - $
Bonds $ 530,321,150.56 $ 530,164,414.45 $ 503,140,960.00 $ 4,279.027.65 Repurchase Agreements $ $ $ $
: • •
Reverse Repurchase $ $ - $ $
Time Deposits $ 5,144,000,000.00 $ 5,144,000,000.00 $ 5,144,000,000.00 NA PMIA & GF Loans $ 376,811,000.00 $ 376,811,000.00 $ 376,811,000.00 NA TOTAL $ 198,446,810,007.72 $ 199,077,662,690.83 195,372,679,689.66 $ 479,637,279.01 Fair Value Including Accrued Interest : 195,852,316,968.67 Repurchase Agreements, Time Deposits, PMIA & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost).
The value of each participating dollar equals the fair value divided by the amortized cost (0.981389258).
As an example: if an agency has an account balance of $20,000,000.00, then the agency would report its participation in the LAIF valued at $19.627,785.16 or $20,000,000.00 x 0.981389258. 4 California State Treasurer
Fiona Ma, cPA
Local Agency Investment Fund January 04, 2023
P.O. Box 942809
Sacramento, CA 94209-0001 LAIF Home
(916) 653-3001 PMIA Average Monthly Yields
CITY OF LAGUNA NIGUEL
TREASURER
30111 CROWN VALLEY PARK WAY
LAGUNA NIGUEL, CA 92677
Tran Type Definitions
Account Number:
December 2022 Statement
Web
Effective Transaction Type Tran Confirm Confirm
Date Date Number Number Authorized Caller Amount
12/29/2022 12/28/2022 RD 1719739 N/A KRISTIN FORIER 5,000,000.00 Account Summary
Total Deposit: 5,000,000.00 Beginning Balance: 23,433,336.85 Total Withdrawal: 0.00 Ending Balance: 28,433,336.85
5 COUNTY OF ORANGE
OR SANCE COUNT
OFFICE OF THE TREASURER-TAX COLLECTOR
Shari L. Freidenrich, CPA, CCT, CPFA, ACPFIM
P. O. BOX 4515
SANTA ANA, CA 92702-4515
LIFOR
octreasurer.com/publicfunds
December 31, 2022
CITY OF LAGUNA NIGUEL
Attn: Eric Hendrickson, Finance Director
30111 Crown Valley Parkway
Laguna Niguel, CA 92677
Fund Number
DECEMBER 2022 STATEMENT
INVESTMENT BALANCE IN OCIP
Transactions
Transaction Transaction Description Authorized Signer Amount Date
12/01/2022 November 2022 Investment Admin Fee $ (47.66) 12/29/2022 September 2022 Interest Paid $ 2,971.24
Summary
Total Deposit: $ 2,971.24 Beginning Balance: $ 1,049,747.99 Total Withdrawal: $ (47.66) Ending Balance: $ 1,052,671.57 6 OF
ORAN, OFFICE OF THE TREASURER-TAX COLLECTOR CALGE COUNT SHARI L. FREIDENRICH, CPA, CCMT, CPFA, ACPFIM
P.O. Box 4515
CALIFORNI SANTA ANA, CA 92702-4515
octreasurer.com/publicfunds
ORANGE COUNTY INVESTMENT POOL
APPORTIONMENT YIELDS & BASIS POINT FEES
Monthly Apportionment Monthly Apportionment Charged Basis Actual Basis FY 22/23 Date 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 Monthly Apportionment Monthly Apportionment Charged Basis Actual Basis FY 21/22 Date Year 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
Monthly Apportionment Monthly Apportionment Charged Basis Actual Basis FY 20/21 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.9 5.0
0.802% November 2020 0.899% 0.840% 5.9 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
INCREASE NET CHANGE INCREASE
(DECREASE) (DECREASE) NET CHANGE%
Orange County Investment Pool (OCIP)
End Of Month Market Value' 6,780,544,665 6,274,423,603 506,121,062 8.07% 6,188,116,076 592,428,589 9.57% End Of Month Book Value!? 6,878,820,237 6,388,490,979 490,329,258 7.68% 6,199,174,761 679,645,476 10.96% Monthly Average Balance12 7,455,529,661 6,263,822,194 1,191,707,467 19.03% 6,913,018,256 542,511,405 7.85% Year-To-Date Average Balance 5,989,186,801 5,695,918,229 293,268,572 5.15% 5,543,054,862 446,131,939 8.05% Monthly Accrued Earnings? 18,094,769 12,549,253 5,545,516 44.19% 2,416,877 15,677,892 648.68% Monthly Net Yield? 2.766% 2.350% 0.416% 17.70% 0.338% 2.428% 718.34% Year-To-Date Net Yield? 1.723% 1.448% 0.274% 18.93% 0.471% 1.252% 265.73% Annual Estimated Gross Yield° 2.500% 2.500% 0.000% 0.00% 0.523% 1.977% 378.01% Weighted Average Maturity (WAM)® 199 234 (35) -14.96% 356 (157) -44.10% Orange County Educational Investment Pool (OCEIP)
End Of Month Market Value!4 8,351,331,628 6,759,999,601 1,591,332,027 23.54% 6,444,849,088 1,906,482,540 29.58% End Of Month Book Value! 8,473,072,525 6,883,259,501 1,589,813,024 23.10% 6,456,385,285 2,016,687,240 31.24% Monthly Average Balance* 7,291,108,209 6,551,746,482 739,361,727 11.28% 5,348,961,521 1,942,146,688 36.31% Year-To-Date Average Balance* 6,514,782,972 6,359,517,924 155,265,047 2.44% 5,108,959,104 1,405,823,868 27.52% Monthly Accrued Earnings? 17,600,484 13,125,739 4,474,745 34.09% 2,041,514 15,558,970 762.13% Monthly Net Yield? 2.766% 2.366% 0.400% 16.91% 0.378% 2.388% 631.75% Year-To-Date Net Yield? 1.677% 1.426% 0.251% 17.61% 0.480% 1.197% 249.34% Annual Estimated Gross Yield 2.500% 2.500% 0.000% 0.00% 0.531% 1.969% 370.81% Weighted Average Maturity (WAM)® 200 235 (35) -14.89% 356 (156) -43.82% 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 slightiy below book values. The OCIP and OCEIP have sufficient liquidity to meet projected cash flow needs.
2 The OCIP End Of Month Book Value is higher than the prior year, and the Monthly Average Balance is higher than the prior month due to higher general fund (COVID related) balances. 3 The OCIP and OCEIP Monthly Accrued Earnings, Monthly Net Yields and Year-To-Date Net Yields are higher than the prior month and year primarily due to purchases at higher interest rates. 4 The OCEIP End of Month Market Value, End of Month Book Value and Monthly Average Balances are higher than the prior month and year, and the Year-To-Date Average Balance is higher than the prior year both due to an increase bond proceeds and additional funding for new District programs by federal and state governments. 5 The OCIP and OCEIP Annual Estimated Gross Yields are higher than the prior year due to continued higher vields from short-term rate increases. The OCIP and OCEIP Annual Estimated Gross Yields for December 2021 are reported at the actual annual gross vields for FY 21 6 The OCIP and OCEIP WAM decreased from the prior month and year due to shorter term purchases as the FOMG is expected to increase short-term rates for the next several months.
ORANGE COUNTY TREASURER-TAX COLLECTOR
ORANGE COUNTY INVESTMENT FUND (OCIF)
ORANGE COUNTY TREASURER'S POOL (OCT) AND SPECIFIC INVESTMENT ACCOUNTS (1) FOR THE MONTH AND QUARTER ENDED: December 31, 2022
OCT INVESTMENT STATISTICS - By Reporting Entity
Average Days to Daily Yield as of Current NAV
Maturity 12/31/2022
DESCRIPTION CURRENT BALANCES
MARKET Value $ 6,780,544,665 200 2.912% 2.821% 2.351% 0.9857(2) COST (Capital) $ 6,856,059,380
Orange County Investment Pool (OCIP) MONTHLY AVG Balance $ 7,455,529,661 QUARTERLY AVG Balance $ 6,525,615,313
BOOK Value S 6,878,820,237
MARKET Value $ 8,351,331,628 200 2.912% 2.821% 2.357% 0.9857(2) COST (Capital) $ 8,444,955,901
Drange County Educational Investmen
Pool (OCEIP) MONTHLY AVG Balance $ 7,291,108,209
QUARTERLY AVG Balance $ 6,683,352,124
BOOK Value $ 8,473,072,525
NVESTMENT STATISTICS - Specific Investment Accounts
DESCRIPTION CURRENT BALANCE BY SPECIFIC INVESTMENT
Specific Investment
Funds: MARKET Value $ 108,641,701 Fund Market Value Book Value Current NAV John Wayne Airport Investment Fund (JWA) COST (Capital) $ 112,185,815 Fountain Valley School District Fund 40 (FVSD) MONTHLY AVG Balance s 112,167,226 JWA $ 54,191,708 $ 54,181,384 1.0002 CCCD Series 2017E Bonds (CCCD) QUARTERLY AVG Balance $ 112,011,931 FVSD 33,138,956 34,658,771 0.9561 BOOK Value $ 111,629,298 CCCD 21,311,037 22,789,143 0.9351
OCIF TOTALS
INVESTMENTS CASH
OCIP $ 6,856,059,380
OCEIP 8,444,955,901
Specific Investment 112,185,815 Cash 26,416,958
Totals $ 15.413.201,096 26,416,958
Total Assets in the County Treasury 15,439,618,054
KEY POOL STATISTI
INTEREST RATE YIELD WEIGHTED AVERAGE MATURITY (WAM)
OCIP - YTD NET YIELD 1.723% OCIP 200
OCEIP - YTD NET YIELD 1.677% OCEIP 200
JOHN WAYNE AIRPORT - MONTHLY GROSS YIELD 4.030% JOHN WAYNE AIRPORT 90-DAY T-BILL YIELD - MONTHLY AVERAGE 4.305% LGIP (Standard & Poors) 22 9 ORANGE COUNTY TREASURER - TAX COLLECTOR
BY INVESTMENT TYPE AT MARKET VALUE - By Percentage Holdings December 31, 2022
100%
90%
80%
70%
50%
40%
30%
0%
Orange County Investment Pool Orange County Educational Investment Pool John Wayne Airport Investment Fund Orange County Investment Pool Orange County Educational Investment Pool John Wayne Airport Investment Fund In Thousands In Thousands In Thousands
TU. S. GOVERNMENT AGENCIES 3,993,585 58.90% LU.S. GOVERNMENT AGENCIES 4,899,164 58,66% LU.S. GOVERNMENT AGENCIES 53,976 99.60% U.S. TREASURIES 1,592.219 23.48% U.S. TREASURIES 1,972,278 23.61% MONEY MARKET MUTUAL FUNDS 216 0.40% MONEY MARKET MUTUAL FUNDS 1,045,401 15.42% MONEY MARKET MUTUAL FUNDS 1,294,903 15.51% MUNICIPAL DEBT 115,905 1.71% MUNICIPAL DEBT 143,572 1.72% •LOCAL AGENCY INVESTMENT FUND 33.435 0.49% • LOCAL AGENCY INVESTMENT FUND 41.415 0.50% $ 6.780.545 100.00% 8,351,332 100.00% 54.192 100.00%
24416
00--M -UC-UU -365-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
MARKET VALUE SUMMARY
Current Period
12/01/22 to 12/31/22
Change: 18,407.48
Beginning Market Value $27,783,960.00 $36,000,000
Taxable Interest 43,929.60 $30,000,000
Long Term Gains/Losses 0.02 $24,000,000
Short Term Gains/Losses 0.11
Change in Investment Value -25,522.25 $18,000,000
$12,000,000
Ending Market Value $27,802,367.48
$6,000,000
$0
Beginning Ending
MV MV
$27,783,960.00 $27,802,367.48
12 $473,905.28 100.00 $27,802,367.48 Total Market Value 469,600.00 99.60 27,696,448.00 Taxable Bonds
4,305.28 0.40 105,919.48 Cash & Equivalents
Annual Income Total Market Value Assets
Estimated % of Current Period
ASSET SUMMARY
December 1, 2022 to December 31, 2022 ACCOUNT NUMBER:
CITY OF LAGUNA NIGUEL
usbank
0220657-00-04007-04
00--M -UC-UU -365-04
24416
13 $43,929.60 Total Current Period Income
43,929.60 Taxable Interest
Current Period
Income Received
INCOME SUMMARY
December 1, 2022 to December 31, 2022 ACCOUNT NUMBER:
CITY OF LAGUNA NIGUEL
usbank
0220657-00-04007-04
00--M -UC-UU -365-04
24416
14 $0.00 Ending Cash 12/31/2022
-43,929.73 Net Money Market Activity
0.13 Capital Gain Distributions
43,929.60 Taxable Interest
$0.00 Beginning Cash 12/01/2022
Cash
CASH SUMMARY
December 1, 2022 to December 31, 2022 ACCOUNT NUMBER:
CITY OF LAGUNA NIGUEL
usbank
0220657-00-04007-04
00--M -UC-UU -365-04
24416
24416
00--M -UC-UU -365-04
0220657-00-04007-04
usbank.
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
ASSET DETAIL
Security Description Percent
Unrealized of Total Estimated Estimated
Shares/Face Amt Market Value Tax Cost Gain/Loss Portfolio Annual Income Current Yield Cash & Equivalents
Cash/Money Market
First American Government - 31846V567
Oblig Fa CIZ
#3676
105,919.480 1.0000 105,919.48 105,919.48 0.00 0.4 4,305.28 4.06 Total Cash/Money Market $105,919.48 $105,919.48 $0.00 0.4 $4,305.28 5 Total Cash & Equivalents $105,919.48 $105,919.48 $0.00 0.4 $4,305.28 Taxable Bonds
US Government Issues
FHLMC - 3137EAEPO
1.500 02/12/2025
4,000,000.000 94.2280 3,769,120.00 4,188,112.71 -418,992.71 13.6 60,000.00 1.59 FHLMC MTN - 3134GV5R5
0.570 07/15/2024
1,000,000.000 93.7560 937,560.00 1,000,000.00 -62,440.00 3.4 5,700.00 0.61 FNMA - 3135G05X7
0.375 08/25/2025
8,700,000.000 90.1890 7,846,443.00 8,645,922.29 -799,479.29 28.2 32,625.00 0.42 Federal Farm Credit Bks - 3133ENVD9
2.875 04/26/2027
4,000,000.000 95.1970 3,807,880.00 3,995,360.00 -187,480.00 13.7 115,000.00 3.02 Federal Home Loan Bks - 3130AJTX7
0.720 07/21/2025
625,000.000 90.6440 566,525.00 625,000.00 -58,475.00 2.0 4,500.00 0.79 24416
00--M -UC-UU -365-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
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 Federal Home Loan Bks - 3130AJTF6
0.740 07/14/2025
1,000,000.000 90.7600 907,600.00 1,000,000.00 -92,400.00 3.3 7,400.00 0.81 Federal Home Loan Bks - 3130AMFS6
0.750 06/12/2026
2,000,000.000 89.0690 1,781,380.00 2,001,415.36 -220,035.36 6.4 15,000.00 0.84 Federal Home Loan Bks - 3130A8XY4
1.875 09/11/2026
4,500,000.000 91.8280 4,132,260.00 4,665,690.00 -533,430.00 14.9 84,375.00 2.04 519625 1202023n Bks - 3130ATBLO
4,000,000.000 98.6920 3,947,680.00 3,991,360.00 -43,680.00 14.2 145,000.00 3.67 Total US Government Issues $27,696,448.00 $30,112,860.36 -$2,416,412.36 99.6 $469,600.00 Total Taxable Bonds $27,696,448.00 $30,112,860.36 -$2,416,412.36 99.6 $469,600.00 Total Assets $27,802,367.48 $30,218,779.84 -$2,416,412.36 100.0 $473,905.28 Estimated Current Yield 1.70
ASSET DETAIL MESSAGES
Time of trade execution and trading party (if not disclosed) will be provided upon request. 24416
00- -M -UC-UU -365-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
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 eamed by your investments and they provide no guarantee of what your investments may earn in the future. 17 24416
00--M -UC-UU -365-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
TRANSACTION DETAIL
Date
Posted Activity Description Cash Tax Cost
Beginning Balance 12/01/2022 $0.00 $30,174,850.11
12/01/22 Asset Income Interest Earned On 179.60
Interest From 0bF22 TO 11/30/22
12/08/22 Asset Income Interest Earned On 36,250.00
F HL B Deb 3.625% 12/08/23
0.009062 USD/$1 Pv On 4,000,000 Par Value Due 12/8/22
12/12/22 Asset Income Interest Eamed On 7,500.00
FH L B Deb 0.750% 6/12/26
0.00375 USD/$1 Pv On 2,000,000 Par Value Due 12/12/22
D12/21/22 Cash Receipt Cash Receipt 0.02
Short-Term Capital Gain Div
First Am Govt Ob Fd CIZ
Stog Payable 12/21/22
12/22/22 Cash Receipt Cong Term Capital Gain Div 0.11
First Am Govt Ob Fd CIZ
Ltcg Payable 12/21/22
Purchase Combined Purchases For The Period 12/ 1/22 - 12/31/22 Of -43,929.73 43,929.73 First Am Gort Ob Fd CIZ
Ending Balance 12/31/2022 $0.00 $30,218,779.84
24416
00--M -UC-UU -365-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
SALE/MATURITY SUMMARY
Settlement Estimated
Date Description Tax Cost Proceeds Gain/Loss
Cash and Equivalents
First American Government
Oblig Fa CIZ
#3676
FGZXX
12/21/22 Cash Receipt 0.02 0.02
Short-Term Capital Gain Div
Stcg Payable 12/21/22
12/22/22 Cash Receipt 0.11 0.11
Long-Term Capital Gain Div
Ltcg Payable 12/21/22
Total First American Government Oblig Fd $0.00 $0.13 $0.13 Total Cash and Equivalents $0.00 $0.13 $0.13
Total Sales & Maturities $0.00 $0.13 $0.13
SALE/MATURITY SUMMARY MESSAGES
Estimates should not be used for tax purposes
24416
0220-57-00-0-007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
BOND SUMMARY
60% 1
40%
30%
20%
10%
0% - 2025 2026 2027
2022 2023 2024
Percentage of
Par Value Market Value Category
MATURITY
2022 0.00 0.00
2023 3,947,680.00 14.26
2024 10000000 937,560.00 3.39
2025 14,325,000.00 13,089,688.00 47.26
2026 5,913,640.00 21.35
2027 4,00.000.00 3,807,880.00 13.74
Total of Category $29,825,000.00 $27,696,448.00 100.00
MOODY'S RATING
Aaa 28,825,000.00 26,758,888.00 96.61
N/A 1,000,000.00 937,560.00 3.39
Total of Category $29,825,000.00 $27,696,448.00 100.00
24416
00--M -UC-UU -365-04
0220657-00-04007-04
usbank
CITY OF LAGUNA NIGUEL
ACCOUNT NUMBER: December 1, 2022 to December 31, 2022
BOND SUMMARY (continued)
Percentage of
Par Value Market Value Category
S&P RATING
AA+ 28,825,000.00 26,758,888.00 96.61
N/A 1,000,000.00 937,560.00 3.39
Total of Category $29,825,000.00 $27,696,448.00 100.00
BOND SUMMARY MESSAGES
Data 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 12/1/2022 to 12/31/2022 Tamara Letourneau
City Manager
City of Laguna Niguel
30111 Crown Valley Parkway
Laguna Niguel, CA 92677
Account Summary
Balance as of Balance as o
12/1/2022 Contributions Earnings Expenses Distributions Transfers 12/31/202 Source
PENSION $1,935,359.42 $0.00 -$32,329.43 $883.02 $0.00 $0.00 $1,902,146.97 Totals S1,935,359.42 $0.00 -S32,329.43 $883.02 $0.00 $0.00 $1,902,146.97 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
1-Month 3-Months 1-Year 3-Years 10-Years Plan's Inception Date Source
PENSION -1.67% 3.53% -13.29% 5/26/2020
Information as provided by US Bank, Trustee for PARS; Not FDIC Insured; No Bank Guarantee; May Lose Value Past performance does not guarantee future results. Performance returns may not reflect the deduction of applicable fees, which could reduce returns. Information is deemed reliabie but may be subject to change.
Investment Retur: Annualized rate of retur is the retum on an investment over a period other than one year multiplied or divided to give a comparable one-ycar retum.
Account balances are inclusive of Trust Administration. Trustee and Investment Management fees Headquarters - 4350 Von Karman Ave, Suite 100, Newport Beach, CA 92660 800.540.6369 Fax 949.250.1250 www.pars.org 22