Agenda packet — Vallejo City Council, July 26, 2022 (part 2 of 5)

Condensed investment information as of June 30, 2022, is as follows:

Par Value Fair Value Cost Basis
Description of
Portfolio
of Portfolio of Portfolio
Percentage of
Portfolio
City of Vallejo:

Local Agency Investment Fund $73,135,065.63 $73,135,065.63 $73,135,065.63 44.66% U.S. Federal Agency Bonds $25,875,000.00 $24,833,311.77 $26,145,287.70 15.16% U.S. Treasury Securities $30,300,000.00 $28,863,327.05 $30,649,767.57 17.62% Corporate Medium-Term Notes $22,825,000.00 $21,932,594.14 $23,202,993.70 13.39% Asset Backed Securities $11,141,364.31 $10,888,936.36 $11,150,062.30 6.65% Negotiable Certificates of Deposit $1,000,000.00 $994,510.00 $1,000,050.43 0.61% Collateralized Mortgage
Obligations
$800,000.00 $796,250.40 $860,562.50 0.49%
Money Market Mutual Funds $2,320,176.09 $2,320,176.09 $2,320,176.09 1.42% Total $167,396,606.03

$163,764,171.44 $168,463,965.92 100.00%

Footnote: In accordance with Government Code Section 53646, the Fair Value of the Local Agency Investment Fund (LAIF) shown above represents the value from the June 30, 2022, LAIF statement and has not been adjusted by the “Amortized Cost Factor” which is used in adjusting the statement balance to the actual “Fair Value” balance.

Condensed earnings and return information as of June 30, 2022, is as follows:

Current Quarter Fiscal Year-to-Date
Portfolio Investment Earnings:

City of Vallejo1 $454,064 $1,653,430

Net Change in Portfolio Fair Value
Balance2:

City of Vallejo -$785,000 $914,188

Approximate Portfolio rate-of-return:

City of Vallejo - Yield to maturity3 1.19%

BENCHMARK COMPARISON RATE-OF-RETURN4:

Date: July 26, 2022
Subject: CITY TREASURER’S INVESTMENT REPORT

Page 3 ends

Local Agency Investment Fund 0.32%

2-Year U.S. Treasury Note Yield 2.957%

Footnotes:

1. The City records interest income on a cash basis, whereas the attached statement uses the accrual basis. Since the accrual basis includes interest income earned but not received, there is a timing difference in recording the interest income between the City’s books and the attached statement. This difference will be trued up at fiscal year-end.

2. The “Net Change in Portfolio Fair Value Balance” is primarily a measure of the difference in the inflows and outflows of funds held in the LAIF account during the period. The change is primarily due to the timing of the receipt of property tax revenues, which are received in December and April of each year, and the timing of the City making withdrawals in the ordinary course of business to pay expenses.

3. Yield to Maturity is the interest income the portfolio will earn for the next twelve months expressed as a percentage. Yield to maturity assumes no changes during that twelve month period.

4. These are the performance benchmarks stated in the City’s Investment Policy.

COMPLIANCE

All investment transactions were executed in accordance with the California Government Code and the City’s and Investment Policies. In accordance with California Government Code section 53646(b)(3), staff believes that the investments and budgeted revenues for the City will provide sufficient cash flow to meet the anticipated cash flow requirements of each entity for the next six months.

Pooled cash and investments book balances are adjusted annually to reflect fair value as required by Generally Accepted Accounting Principles. The term fair value was formerly known as market value and became effective with the mandatory implementation of GASB 31 in fiscal year 1998. The attached investment schedules meet these requirements.

It should be noted that this is an investment portfolio report and does not include bank checking account deposits for the City. The Housing Authority is not required to file a quarterly report because it does not have any reportable investments since it closed its investment account and transferred all funds to its bank account, which is covered by a general depository agreement, as required by HUD.

FISCAL IMPACT
There is no fiscal impact from this report. The City's portfolio had total investment earnings of $ 454,064 during the three-month period ending June 30, 2022. In addition, the portfolio also had a Date: July 26, 2022
Subject: CITY TREASURER’S INVESTMENT REPORT

Page 4 ends

cumulative fair value versus cost value unrealized, non-cash loss of approximately ($1,137,096) during the three-month period as of June 30, 2022. Fair value fluctuates from one period to another depending on the changes in interest rates and the supply and demand for bonds at a particular time. Therefore, there is often a difference between the cost value (the value at the time of purchase) and the fair value (the market value of the same security at a certain later period), creating an unrealized gain or loss.

ENVIRONMENTAL REVIEW
This action is exempt from the California Environmental Quality Act (CEQA) because it is not a project which has a potential for resulting in either a direct physical change in the environment, or a reasonably foreseeable indirect physical change in the environment, pursuant to CEQA Guideline section 15378.

ATTACHMENTS

1. City of Vallejo Economic and Account Analysis 6-30-22

2. Chandler Monthly Statement - Account 262 - 6-30-22

CONTACT
Rekha Nayar, Finance Director, (707) 648-4592
[email protected]
CHANDLER ASSET MANAGEMENT, INC. | 800.317.4747 | www.chandlerasset.com

INVESTMENT REPORT
Period Ending June 30, 2022
City of Vallejo
SECTION 1 Economic Update
SECTION 2 Account Profile
Table of Contents As of June 30, 2022
1 SECTION |
Section 1 |
Economic Update
2 Economic Update



Financial markets a re experiencing heightened volatility and tighter conditions as central banks employ more restrictive monetary policies to combat persistent inflation. The conflict between Russia and Ukraine has exacerbated inflationary pressures, particularly with energy and commodities, and strict COVID lockdowns in China are intensifying distressed supply chains. Inflation is weighing heavily on consumer sentiment and beginning to impact discretionary spending. Labor markets remain strong, but wage gains are not keeping up with inflation. While we expect the Fed to continue to tighten monetary policy, the FOMC has very little margin for error as it attempts to combat inflation without pushing the economy into a recession. We continue to believe the risk of an economic slowdown later this year has increased. Over the near- term, we expect financial market volatility to remain intensified and conditions to remain tighter with persistent inflation, geopolitical risk, supply chain bottlenecks, and the Fed's shift to a more hawkish monetary policy.

At the June meeting, persistently high inflation led the Federal Open Market Committee (FOMC) to announce a 0.75% federal funds rate increase to 1.50%- 1.75%. Federal Reserve Chair Powell indicated the committee may raise rates by 50 or 75 bps at the July meeting and continue to tighten as needed to dampen inflation. The Fed will continue shrinking its $9 trillion balance sheet by $47 billion per month as of June, increasing to $95 billion in September. We anticipate additional rates hikes as the Fed remains “committed” to the 2% long-term inflation target. In the second half of the year, monetary policy will be dependent on how the economy responds to tighter conditions.

In June, yields rose, and the curve flattened. The 2-year Treasury yield soared 40 basis points to 2.96%, the 5-year Treasury yield increased 22 basis points to 3.04%, and the 10-year Treasury yield rose 17 basis points to 3.02%. The spread between the 2-year and 10-year Treasury yield fell to 6 basis points at June month-end, down from 29 basis points at May month-end, and down significantly from 122basis points one year ago. The spread between 3-month and 10-year treasuries is wider at about 135 basis points but continues to compress with each Fed rate hike. The shape of the curve bears watching but does not indicate a high probability of an imminent recession. 3 Source: US Department of Labor Source: US Department of Labor Employment
The U.S. economy a dded 372,000jobs in June, and job gains in May were revised down to 384,000from 390,000. Trends in employment remain strong, with the three-month moving average payrolls at 375,000and the six-month moving average at 457,000.Hiring was led by education and health services, followed by professional and business services, and leisure and hospitality. The unemployment rate remained unchanged at 3.6% for the fourth month, and the U-6 underemployment rate, which includes those who are marginally attached to the labor force and employed part time for economic reasons, declined to a seasonally adjusted 6.7% rate. Average hourly earnings rose 5.1% year-over-year in June, easing from a revised 5.3% year-over-year gain in May, which reflects a continuing, slow deceleration in wage growth that could help ease broad cyclical price pressures. The labor participation rate decreased to 62.2%from 62.3%, suggesting a slower pace for workers returning to the labor market despite higher wages.
-5,000
-4,000
-3,000
-2,000
-1,000
0 1,000
2,000
3,000
4,000
5,000
MOM Change In (000's)
Nonfarm Payroll (000's)
Non-farm Payroll (000's)
3 month average (000's)

0.0%

4.0%

8.0%

12.0%

16.0%

20.0%

24.0%
Unemployment Rate
Underemployment Rate (U6)
Unemployment Rate (U3)
Rate (%)
4 Source: US Department of Labor Source: US Department of Commerce Inflation
The Consumer Price Index (CPI) hit a 40-year high in May with broad-based price increases for most goods and services. Headline CPI was up

8.6% year-over-year in May, up from 8.3% year-over-year in April. Core CPI (CPI less food and energy) was up 6.0% in May, down from 6.2% in April. Shelter, food, and gasoline were the largest contributors to the increase. The Personal Consumption Expenditures (PCE) index was up

6.3% year-over-year in May, unchanged from April. Core PCE was up 4.7% year-over-year in May, versus up 4.9% year-over-year in April.

Persistently elevated levels of inflation are likely to keep the Federal Reserve on the path of tightening monetary policy as long as they continue to run well above the Fed’s longer-run target of around 2.0%.

0.0%

1.0%

2.0%

3.0%

4.0%

5.0%

6.0%

7.0%

8.0%

9.0%
Personal Consumption Expenditures (PCE)
PCE Price Deflator YOY % Change
PCE Cor e Deflator Y OY % Change
YOY( %) Change

0.0%

1.0%

2.0%

3.0%

4.0%

5.0%

6.0%

7.0%

8.0%

9.0%
Consumer Price Index (CPI)
CPI YOY % Change
Core CPI YOY % Change
YOY( %) Change
5 Retail sales fell 0.3% in May from downwardly revised +0.7% April numbers, led by a significant decline in auto sales. Amid high inflation, consumers are showing softer demand for goods and are spending more on services. Retail sales growth is at risk as consumers dip into savings and assume more debt. On a year-over-year basis, retail sales were up 8.1% in May versus up 7.8% revised in April. The Consumer Confidence index fell to 98.7 in June from a downwardly revised 103.2 in May. U.S. consumer savings rates are declining, and the wealth effect is waning from recent financial market declines. While the average consumer still has capacity to spend from accumulated savings, higher wages, and credit lines, consumer balance sheets and discretionary spending decisions are increasingly pressured by elevated gas, food, and shelter costs.

Source: US Department of Commerce Source: The Conference Board -10.0%

0.0%

10.0%

20.0%

30.0%

40.0%

50.0%

60.0%
Retail Sales YOY % Change
YOY (%) Change
80 90
100
110
120
130
140
Index Level
Consumer Confidence
Consumer
6 Source: The Conference Board Source: Federal Reserve Bank of Chicago Economic Activity
The Conference Board’s Leading Economic Index (LEI) decreased 0.4% month-over-month in May, following a 0.4% decline in April. On a year- over-year basis, the LEI was up 3.0% in May versus up 4.4% in April. The May monthly decline was fueled by tumbling stock prices, a slowdown in housing construction, and gloomier expectations. The index remains near historical highs, but the decline suggests weaker economic activity is likely in near term. Likewise, the Chicago Fed National Activity Index (CFNAI) fell to +0.01in May after a downwardly revised 0.40in April. On a 3-month moving average basis, the CFNAI decreased to 0.20 in May from 0.40 in April. -8.00
-6.00
-4.00
-2.00

0.00 2.00

4.00 6.00
Chicago Fed National Activity Index (CFNAI)
3 Month Average
-1.0%
-0.5%

0.0%

0.5%

1.0%

1.5%

2.0%

2.5%
Leading Economic Indicators (LEI)
MOM ( %) Change
7 Source: US Department of Commerce Source: S&P
Housing
0 200
400
600
800
1000
1200
1400
1600
1800
2000
MOM Change (In Thousands of Units)
Housing Starts
Multi Family Housing Starts
Single Family Housing Starts

0.0%

3.0%

6.0%

9.0%

12.0%

15.0%

18.0%

21.0%

24.0%
S&P/Case-Shiller 20 City Composite Home Price Index
YOY( %) Change
Total housing starts declined 14.4% to an annual rate of 1,549,000in May, from a revised 1,810,000in units in April. Single-family home starts fell by 9.2% and multi-family fell 23.7% month-over-month. On a year-over-year basis, total housing starts decreased 3.5%, driven by multi- family. According to the Case-Shiller 20-City home price index, home prices were up 21.2% in April versus 21.1% year-over-year in March, setting another new record. While tight supply has continued to support prices, rising mortgage rates and affordability could be headwinds to further price growth.
8 Source: Institute for Supply Management Source: Federal Reserve Manufacturing
The Institute for Suppl y Management (ISM) manufacturing index dropped sharply to a two-year low of 53.0in June from 56.1in May. Readings above 50.0 are indicative of expansion in the manufacturing sector. The decline was primarily driven by weakness in new orders due to softening consumer demand, supply constraints, and labor shortages. On a month-over-month basis, the Industrial Production index rose 0.2% in May, following a revised 1.4% increase in April. Capacity utilization rose to 79.0% in May, from a 78.9%revised April level. Although capacity utilization remains below its longer-run average of 79.6%, it is running above the pre-pandemic level of 76.3%. 40 42
44 46
48 50
52 54
56 58
60 62
64 66
Institute of Supply Management Purchasing Manager Index

EXPANDING

CONTRACTING
-20.0%
-15.0%
-10.0%
-5.0%

0.0%

5.0%

10.0%

15.0%

20.0%
Industrial Production
YOY( %) Change
9 Source: US Department of Commerce Source: US Department of Commerce 6/21 9/21 12/21 3/22

7.9% 1.4% 1.8% 1.2%
-0.7% 2.1% 5.8% 0.9%
-0.2% -1.3% -0.2% -3.2%
-0.4% -0.4% -0.3% -0.5%

0.0% 0.5% -0.2% -0.1%

6.7% 2.3% 6.9% -1.6%
Components of GDP
Federal Government Expenditures
State and Local (Consumption and Gross
Investment)
Net Exports and Imports
Total
Gross Private Domestic Investment
Personal Consumption Expenditures
-35.0%
-30.0%
-25.0%
-20.0%
-15.0%
-10.0%
-5.0%

0.0%

5.0%

10.0%

15.0%

20.0%

25.0%

30.0%

35.0%
Gross Domestic Product (GDP)
GDP QOQ % Change
GDP YOY % Change
Gross Domestic Product (GDP)
According to the t hird estimate, first quarter 2022GDP contracted at an annualized rate of 1.6%, revised down from the second estimate of a

1.5% decline, and following fourth quarter 2021growth of 6.9%. The weaker reading reflects a downgrade for growth in personal consumption expenditures from 3.1% to 1.8%. The most significant contributor to the decline was a widening of the trade deficit. The consensus estimate calls for 3.0% growth in the current quarter and 2.5% growth for 2022. 10 Federal Reserve
Source: Federal Reserve Source: Bloomberg
At the June m eeting, persistently high inflation led the Federal Open Market Committee (FOMC) to announce a 0.75% federal funds rate increase to 1.50% - 1.75%. Federal Reserve Chair Powell indicated the committee may raise rates by 50 or 75 bps at the July meeting and continue to tighten as needed to dampen inflation. Dot plot projections rose significantly from March, with the median fed funds target rate at

3.4% by the end of this year and 3.8% in 2023. The Fed will continue shrinking its $9 trillion balance sheet by $47 billion per month beginning this month, increasing to $95 billion in September. We anticipate additional rates hikes as the Fed remains “committed” to the 2% long-term inflation target. Although the FOMC views the economy as strong, the committee downgraded their economic outlook as trends cool later this year from tightening conditions.

0.00%

0.25%

0.50%

0.75%

1.00%

1.25%

1.50%

1.75%

2.00%

2.25%

2.50%

2.75%
Effective Federal Funds Rate
Yield (%)
2,000,000
3,000,000
4,000,000
5,000,000
6,000,000
7,000,000
8,000,000
9,000,000
10,000,000
Federal Reserve Balance Sheet Assets
In $ millions
11 Source: Bloomberg Source: Bloomberg

0.0%

0.5%

1.0%

1.5%

2.0%

2.5%

3.0%

3.5%
US Treasury Note Yields
2-Year
5-Year
10-Year
Yield (%)

0.0%

0.5%

1.0%

1.5%

2.0%

2.5%

3.0%

3.5%
US Treasury Yield Curve
Jun-22
Mar-22
Jun-21
Yield (%)
Bond Yields
At the end of June, the 2-year Treasury yield was 271basis points higher, and the 10-Year Treasury yield was about 155 basis points higher, year- over-year. The spread between the 2-year Treasury yield and 10-year Treasury yield fell to 6 basis points at June month-end, down from 29 basis points at May month-end, which is narrow compared to the average historical spread (since 2003)of about 130 basis points. The spread between 3-month and 10-year treasuries is wider at about 135 basis points but continues to compress with each Fed rate hike. The shape of the curve bears watching but does not indicate a high probability of an imminent recession. 12 Section 2|SECTION |
Section 2 |
Account Profile
13 Objectives
Chandler Asset Management Performance Objective
The performance objective for the portfolio is to earn a total rate of return through a market cycle that is equal to or above the return on the benchmark index.

Investment Objectives
The investment objectives for the City of Vallejo, in order of priority, are to provide safety to ensure the preservation of capital in the overall portfolio, provide sufficient liquidity for cash needs, and a market rate of return consistent with the investment program.

Strategy
In order to achieve this objective, the portfolio invests in high-quality fixed income securities that comply with the investment policy and all regulations governing the funds.

As of June 30, 2022
14 Compliance As of June 30, 2022
Category Standard Comment
Treasury Bills, Notes, Bonds N o lim itations; 5 ye ars m ax m aturity Complies U.S. Agenci es/ Government
Sponsored Enterprises (GSEs)
50% maximum; Allowable securities include: 1) Issues which are backed by the full faith and credit of the U.S., and 2) Issues which are implicitly backed by the full faith and credit of the U.S. and/or are in conservatorship. Complies Municipal Bonds (California) "A" rated category or better by a NRSRO; 10% maxi mum Complies Municipal Bonds (Non-California) "A" rated category or better by a NRSRO; 10% maxi mum; 5% max per i ssuer Complies Banker’s Acceptances "A-1" rated or better by a NRSRO; or "A" long-term debt rated category or better by a NRSRO; 5% maximum, $1million max per commercial bank; 180 days max maturity Complies Commerci al Paper
"Prime" quality commercial paper of the highest rating or "A-1" rated or better by one NRSRO; Issued by corporations with long-term debt rating of "A" or better by a NRSRO; Notes are secured promissory notes of industrial corporations, utilities and bank holding companies. Issuer must be a corporation organized and operating in the U.S. with assets >$500 million; 25% maximum; $1million max per issuing corporation; 10% max of the outstanding commercial paper of any issuer; 270 days max maturity Complies
Corporate Medi um Term Notes "A" rated category or higher by a NRSRO; 30% maximum; 5% max per issuer; Issued by corporations organized and operating in the U.S. or by depository institutions licensed by the U.S. Complies Negoti abl e Certi fi cates of Deposi t
(NCD)
No rating required if amount of the NCD is covered by FDIC insured limit; If above FDIC insured limit, requires "A-1" short-term rated or better by a NRSRO; or "A" long-term rated issuer or better by a NRSRO; 30% maximum; Issued by a nationally or state-chartered bank or a state or federal association, a state or federal credit union, or by a federally-licensed or state-licensed branch of a foreign bank.

Complies
Certi fi cates of Deposi t (CDs)
5% maximum with first $250k FDIC insured; CDs with a face value >$250k must be collateralized to 110% of the CD value by othe r e ligible se curitie s; A ll institutions m ust (1) have a m inim um of $100 m illion in asse ts; (2) have a demonstrated history of positive earnings; and (3) must carry a minimum 3.5% equity ratio and hold that ratio for at least one year prior to the City's investment. All institutions must be located within the State of California; For collate ralize d or N CDs, institution m ust have a m inim um $1 billion in asse ts.

Complies
Mortgage-Backed, Asset-Backed
Se curitie s, Collate ralize d Mortgage
Obligations
"AA" rated or better by a NRSRO; 20% maximum (combined with ABS/MBS/CMO) Complies Money Market Mutual Funds and
Mutual Funds
"AAA" or highest rating by two NRSROs; SEC registered > 5 years with AUM >$500 million; 10% maximum in Money Market Funds; 10% maximum in Mutual Funds; 5% max per issuer; 4 years max maturity Complies Repurchase Agreements 20% maximum; 102% Collateralized; 1 year max maturity; Not used by Investment Adviser Complies Local Agency Investment Fund (LAIF) Up to statutory limit maximum; 15 transactions limit per month Complies City of Vallejo
Assets managed by Chandler Asset Management are in full compliance with state law and with the Client's investment policy. 15 Compliance As of June 30, 2022
Category Standard Comment
Local Government Investment
Pools(LGIP) Max lim it allowe d by the pool Complies
Supranationals Prohibited Complies
Equity Securities
Prohibited; Equity securities received as a gift, through bankruptcies or as payment in lieu of monies due the City, shall be sold unless received through a gift or bequest with restrictions on its sale. If the stock has no market value or if the cost of se lling it e xce e ds the m arke t value , the stock will be writte n off or m onitore d pe riodically to be sold w
hen a break-even market val ue can be real i zed.

Complies
Prohibited
Mortgage deri ved Interest-onl y stri ps ; Zero i nterest accrual securi ti es; Compl ex Deri vati ves such as Range Notes or Inverse Floaters; Auction-rate preferred securities; Leveraged investing; Option and Future contracts; Taking short positions; Equity Securities (common or preferred stocks) Complies
Social Re sponsibility No investment is to be made in a company that receives more than 51% of its gross revenues from the production or manufacture of fossil fuels, weapons, manufacturing, cigarettes, alcohol, or gaming products Complies Max Per Issuer 5% max per i ssuer of the portfol i o (except U.S. Treasuri es, Agenci es, LAIF, Money Market Funds) C omplies Max Per A sset Class 50% max per asset cl ass of the portfol i o (except U.S. Treasuri es and Pool s) Complies Max Per Outstanding Issue 5% max of any total outstanding issue Complies Wei ghted Average Maturi ty 3 years Complies
Maxi mum maturi ty 5 years Complies
City of Vallejo
Assets managed by Chandler Asset Management are in full compliance with state law and with the Client's investment policy. 16 Portfolio Characteristics
City of Vallejo
06/30/22 03/31/22
Benchmark* Portfolio Portfolio
Average Maturity (yrs) 2.61 2.77 2.75
Average Modified Duration 2.51 2.43 2.46
Average Purchase Yield n/a 1.38% 1.32%
Average Market Yield 2.98% 3.15% 2.33%
Average Quality** AAA AA/Aa1 AA/Aa1
Total Market Value 90,950,642 91,787,572
*ICE BofA 1-5 Yr US Treasury & Agency Index
**Benchmark is a blended rating of S&P, Moody’s, and Fitch. Portfolio is S&P and Moody’s respectively.

As of June 30, 2022
17 City of Vallejo
Sector Distribution
ABS

12.0%
Agency

27.4%
CMO

0.9%
Corporate

24.2%
Money Market
Fund

2.6%
Negotiable CD

1.1%
US Treasury

31.8%
June 30, 2022 March 31, 2022
ABS

10.3%
Agency

32.8%
CMO

0.9%
Corporate

23.7%
Money Market
Fund

0.2%
Negotiable CD

1.1%
US Treasury

31.2%
As of June 30, 2022
18 Earning CY 2020-21
Investment Performance
City of Vallejo
As of June 30, 2022
Source: City of Vallejo Monthly Investment Report. Interest earnings include accrued interest and realized gains and losses on amortized cost.

Investment Earnings
July 2021 134,993
August 2021 1 27,997
September 2021 117,410
October 2021 120,552
November 2021 123,773
December 2021 131,117
January 2022 100,961
February 2022 99,892
March 2022 118,666
April 2022 101,377
May 2022 110,092
June 2022 117,028
Total 1,403,858
Change in Fair Value
Unrealized Gain/Loss Position 6/30/2021 1,537,070
Unrealized Gain/Loss Position 6/30/2022 ( 4,102,336)
Change in Fair Value (5,639,405)
19 Total Rate of Return Annualized Since Inception December 31, 2001 Total rate of return: A measure of a portfolio’s performance over time. It is the internal rate of return, which equates the beginning value of the portfolio with the ending value; it includes interest earnings, realized and unrealized gains and losses in the portfolio.

Investment Performance
City of Vallejo
-5.00%
-4.00%
-3.00%
-2.00%
-1.00%

0.00%

1.00%

2.00%

3.00%
3 months 12 months 2 years 3 years 5 years 10 years Since Inception City of Vallejo ICE BofA 1-5 Yr US Treasury & Agency Index City of Vallejo Book Return California Local Agency Fund Annualized
TOTAL RATE OF RETURN 3 months 12 months 2 years 3 years 5 years 10 years Since Inception
City of Vallejo -0.89% -4.45% -2.19% 0.17% 1.03% 1.02% 2.58% ICE BofA 1-5 Yr US Treasury & Agency Index -0.81% -4.60% -2.45% 0.04% 0.91% 0.90% 2.40% City of Vallejo Book Return 0.34% 1.49% N/A N/A N/A N/A N/A California Local Agency Fund 0.17% 0.35% 0.44% 0.93% 1.28% 0.84% 1.59% As of June 30, 2022
20 Purchase Yield as of 06/30/22 = 1.38%

0.00 0.50

1.00 1.50

2.00 2.50
Percent (%)
Historical Average Purchase Yield
City of Vallejo
As of June 30, 2022
21 Important Disclosures
2022 Chandler Asset Management, Inc, An Independent Registered Investment Adviser.

Information contained herein is confidential. Prices are provided by ICE Data Services Inc (“IDS”), an independent pricing source. In the event IDS does not provide a price or if the price provided is not reflective of fair market value, Chandler will obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures . Our valuation procedures are also disclosed in Item 5 of our Form ADV Part 2A.

Performance results are presented gross-of-advisory fees and represent the client’s Total Return. The deduction of advisory fees lowers performance results. These results include the reinvestment of dividends and other earnings. Past performance may not be indicative of future results. Therefore, clients should not assume that future performance of any specific investment or investment strategy will be profitable or equal to past performance levels. All investment strategies have the potential for profit or loss. Economic factors, market conditions or changes in investment strategies, contributions or withdrawals may materially alter the performance and results of your portfolio.

Index returns assume reinvestment of all distributions. Historical performance results for investment indexes generally do not reflect the deduction of transaction and/or custodial charges or the deduction of an investment management fee, the incurrence of which would have the effect of decreasing historical performance results. It is not possible to invest directly in an index.

Source ICE Data Indices, LLC ("ICE"), used with permission. ICE permits use of the ICE indices and related data on an "as is" basis; ICE, its affiliates and their respective third party suppliers disclaim any and all warranties and representations, express and/or implied, including any warranties of merchantability or fitness for a particular purpose or use, including the indices, index data and any data included in, related to, or derived therefrom. Neither ICE data, its affiliates or their respective third party providers guarantee the quality, adequacy, accuracy, timeliness or completeness of the indices or the index data or any component thereof, and the indices and index data and all components thereof are provided on an "as is" basis and licensee's use it at licensee's own risk. ICE data, its affiliates and their respective third party do not sponsor, endorse, or recommend chandler asset management, or any of its products or services.

This re port is provided for informational purposes only and should not be construed as a specific investment or legal advice. The information contained herein was obtained from sources believed to be reliable as of the date of publication, but may become outdated or superseded at any time without notice. Any opinions or views expressed are based on current market conditions and are subject to change. This report may contain forecasts and forward-looking statements which are inherently limited and should not be relied upon as indicator of future results. Past performance is not indicative of future results. This report is not intended to constitute an offer, solicitation, recommendation or advice regarding any securities or investment strategy and should not be regarded by recipients as a substitute for the exercise of their own judgment.

Fixed income investments are subject to interest, credit and market risk. Interest rate risk: the value of fixed income investments will decline as interest rates rise. Credit risk: the possibility that the borrower may not be able to repay interest and principal. Low rated bonds generally have to pay higher interest rates to attract investors willing to take on greater risk. Market risk: the bond market in general could decline due to economic conditions, especially during periods of rising interest rates.

Ratings information have been provided by Moody’s, S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee its accuracy.

Security level ratings for U.S. Agency issued mortgage-backed securities (“MBS”) reflect the issuer rating because the securities themselves are not rated. The issuing U.S. Agency guarantees the full and timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P, Moody’s and Fitch respectively.

As of June 30, 2022
22 Benchmark Disclosures
ICE BofA 1-3 Yr US Treasury Index
The ICE BofA 1-3 Year US Treasury Index tracks the performance of US dollar-denominated sovereign debt publicly issued by the US government in its domestic market. Qualifying securities must have at least one year remaining term to final maturity and less than three years remaining term to final maturity, a fixed coupon schedule, and a minimum amount outstanding of $1 billion. Qualifying securities must have at least 18 months to final maturity at the time of issuance.

ICE BofA 1-5 Yr US Treasury & Agency Index
The ICE BofA 1-5 Year US Treasury & Agency Index tracks the performance of US dollar denominated US Treasury and nonsubordinated US agency debt issued in the US domestic market. Qualifying securities must have an investment grade rating (based on an average of Moody’s, S&P and Fitch). Qualifying securities must have at least one year remaining term to final maturity and less than five years remaining term to final maturity, at least 18 months to maturity at time of issuance, a fixed coupon schedule, and a minimum amount outstanding of $1 billion for sovereigns and $250 million for agencies.

As of June 30, 2022
23 MONTHLY ACCOUNT STATEMENT
City of Vallejo Consolidated - Account #262
JUNE 1, 2022 THROUGH JUNE 30, 2022
Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Please see Important Disclosures.

CHANDLER

ASSET MANAGEMENT
chandlerasset.com
Chandler Team:

For questions about your account, please call (800) 317-4747, or contact
[email protected]

ACCOUNT SUMMARY
Beg. Values
as of
5/31/22
End Values
as of
6/30/22
Market Value
164,251,740
163,764,171
Accrued Interest
406,019
446,798
Total Market Value
164,657,759
164,210,969
Income Earned
144,577
159,503
Cont/WD
Par
167,217,297
167,396,606
Book Value
167,743,572
167,866,507
Cost Value
168,247,273
168,463,966

TOP ISSUERS
Local Agency Investment Fund

44.6%
Government of United States

17.6%
Federal National Mortgage Assoc

6.3%
Federal Home Loan Bank

5.6%
Federal Home Loan Mortgage Corp

3.5%
Wells Fargo Adv Tsy Plus Money

1.4%
Hyundai Auto Receivables

1.2%
Bank of America Corp

1.0%
Total

81.2%

PORTFOLIO CHARACTERISTICS
Average Modified Duration

1.34 Average Coupon

1.35%
Average Purchase YTM

1.19%
Average Market YTM

2.16%
Average S&P/Moody Rating
AA/Aa1
Average Final Maturity

1.53 yrs
Average Life

1.40 yrs

CREDIT QUALITY (S&P)

MATURITY DISTRIBUTION

SECTOR ALLOCATION
Portfolio Summary
As of June 30, 2022
City of Vallejo Consolidated
Account #262

PERFORMANCE REVIEW
Annualized

TOTAL RATE OF RETURN
1M
3M
YTD
1YR
2YRS
3YRS
5YRS
10YRS
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 1 ends

Holdings Report
As of June 30, 2022
City of Vallejo Consolidated
Account #262
CUSIP
Security Description
Par Value/Units
Purchase Date
Book Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
ABS
14042WAC4
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
40,131.80
05/21/2019

2.50%
40,123.67
40,129.31
100.04

2.07%
40,146.21

44.77 0.02%

16.90 Aaa / AAA
AAA

1.38 0.08
43813RAC1
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
207,377.43
02/19/2020

1.62%
207,336.79
207,359.72

99.37 3.08%
206,077.38

92.74 0.13%
(
1,282.34
)
Aaa / NR
AAA

1.81 0.43
89232HAC9
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
447,000.16
06/17/2020

0.68%
457,302.12
451,941.63

99.56 2.91%
445,039.17
329.79

0.27%
(
6,902.46
)
Aaa / AAA
NR

1.88 0.35
65479JAD5
Nissan Auto Receivables Owner
2019
-C
A
3 1.93%
Due
7/15/2024
120,157.96
10/16/2019

1.94%
120,151.61
120,155.22

99.70 2.98%
119,799.29
103.07

0.07%
(
355.93
)
Aaa / AAA
NR

2.04 0.29
14041NFU0
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
500,000.00
08/28/2019

1.74%
499,874.10
499,945.90
100.00

1.70%
500,014.00
382.22

0.30%

68.10 NR / AAA
AAA

2.13 0.11
47789KAC7
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
247,106.13
03/04/2020

1.11%
247,091.02
247,098.88

98.99 3.46%
244,605.91
120.81

0.15%
(
2,492.97
)
Aaa / NR
AAA

2.13 0.43
89237VAB5
Toyota Auto Receivables Trust
2020
-C
A
3 0.44%
Due
10/15/2024
90,616.51
07/21/2020

0.44%
90,609.54
90,612.72

98.63 3.28%
89,378.33

17.72 0.05%
(
1,234.39
)
Aaa / AAA
NR

2.30 0.48
43813KAC6
Honda Auto Receivables Trust
2020-3

A
3 0.37%
Due
10/18/2024
413,384.42
09/22/2020

0.38%
413,323.69
413,357.64

98.19 3.38%
405,898.03

55.23 0.25%
(
7,459.61
)

NR / AAA
AAA

2.30 0.60
47787NAC3
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
139,926.32
07/14/2020

0.52%
139,905.00
139,916.88

98.35 3.33%
137,619.91

31.72 0.08%
(
2,296.97
)
Aaa / NR
AAA

2.38 0.58
58769KAD6
Mercedes-Benz Auto Lease Trust
2021
-
B A
3 0.4%
Due
11/15/2024
460,000.00
06/22/2021

0.40%
459,965.27
459,978.98

96.81 3.55%
445,336.58

81.78 0.27%
(
14,642.40
)

NR / AAA
AAA

2.38 1.02
09690AAC7
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
290,000.00
09/08/2021

0.34%
289,970.07
289,980.48

97.07 3.49%
281,500.97

15.95 0.17%
(
8,479.51
)
Aaa / NR
AAA

2.49 0.93
92290BAA9
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
690,000.00
08/04/2020

0.48%
689,855.10
689,915.41

98.43 3.17%
679,143.54

99.09 0.41%
(
10,771.87
)
Aaa / NR
AAA

2.65 0.58
36265MAC9
GM Financial Auto Lease Trust
2022-1

A
3 1.9%
Due
3/20/2025
640,000.00
02/15/2022

1.91%
639,994.50
639,995.39

97.35 3.70%
623,016.32
371.56

0.38%
(
16,979.07
)
Aaa / NR
AAA

2.72 1.50
05601XAC3
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025
305,000.00
01/11/2022

1.11%
304,954.40
304,963.74

96.55 3.84%
294,475.98

55.92 0.18%
(
10,487.76
)

NR / AAA
AAA

2.74 1.27
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 2 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
ABS
44891RAC4
Hyundai Auto Receivables Trust
2020
-C
A
3 0.38%
Due
5/15/2025
490,663.58
10/20/2020

0.39%
490,550.58
490,607.88

97.91 3.53%
480,405.28

82.87 0.29%
(
10,202.60
)

NR / AAA
AAA

2.88 0.66
89240BAC2
Toyota Auto Receivables Owners
2021
-
A A
3 0.26%
Due
5/15/2025
215,000.00
02/02/2021

0.27%
214,960.10
214,978.02

97.65 3.47%
209,942.99

24.84 0.13%
(
5,035.03
)
Aaa / NR
AAA

2.88 0.73
36266FAC3
GM Financial Auto Lease Trust
2022-2

A
3 3.42%
Due
6/20/2025
390,000.00
05/03/2022

3.45%
389,959.32
389,961.91

99.49 3.74%
388,008.27
407.55

0.24%
(
1,953.64
)

NR / AAA
AAA

2.98 1.71
47788UAC6
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
250,000.00
03/02/2021

0.37%
249,951.95
249,969.42

96.15 3.93%
240,377.00

40.00 0.15%
(
9,592.42
)
Aaa / NR
AAA

3.21 1.08
44933LAC7
Hyundai Auto Receivables Trust
2021
-A
A
3 0.38%
Due
9/15/2025
405,000.00
04/20/2021

0.38%
404,957.39
404,973.81

96.59 3.80%
391,186.26

68.40 0.24%
(
13,787.55
)

NR / AAA
AAA

3.21 1.00
44934KAC8
Hyundai Auto Receivables Trust
2021
-B
A
3 0.38%
Due
1/15/2026
840,000.00
07/20/2021

0.39%
839,814.61
839,869.34

96.00 3.62%
806,400.84
141.87

0.49%
(
33,468.50
)

NR / AAA
AAA

3.55 1.25
43815GAC3
Honda Auto Receivables Trust
2021-4

A
3 0.88%
Due
1/21/2026
310,000.00
11/16/2021

0.89%
309,934.65
309,946.73

95.37 3.78%
295,657.23

75.78 0.18%
(
14,289.50
)
Aaa / NR
AAA

3.56 1.62
47789QAC4
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026
390,000.00
07/13/2021

0.52%
389,965.21
389,974.21

94.89 3.90%
370,083.87

90.13 0.23%
(
19,890.34
)
Aaa / NR
AAA

3.71 1.53
44935FAD6
Hyundai Auto Receivables Trust
2021
-C
A
3 0.74%
Due
5/15/2026
220,000.00
11/09/2021

0.75%
219,950.90
219,960.51

95.56 3.57%
210,221.44

72.36 0.13%
(
9,739.07
)

NR / AAA
AAA

3.88 1.59
43815BAC4
Honda Auto Receivables Trust
2022-1

A
3 1.88%
Due
5/15/2026
500,000.00
02/15/2022

1.89%
499,924.80
499,932.98

96.81 3.55%
484,034.00
417.78

0.30%
(
15,898.98
)
Aaa / AAA
NR

3.88 1.94
05602RAD3
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026
325,000.00
05/10/2022

3.23%
324,983.10
324,983.76

98.96 4.46%
321,615.13
173.88

0.20%
(
3,368.63
)
Aaa / AAA
NR

4.16 0.85
89238FAD5
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026
335,000.00
04/07/2022

2.95%
334,992.16
334,992.68

98.78 3.57%
330,928.12
436.24

0.20%
(
4,064.56
)
Aaa / AAA
NR

4.21 1.95
362554AC1
GM Financial Securitized Term
2021-4

A
3 0.68%
Due
9/16/2026
235,000.00
10/13/2021

0.68%
234,994.01
234,995.23

94.95 4.17%
223,121.22

66.58 0.14%
(
11,874.01
)
Aaa / AAA
NR

4.22 1.47
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 3 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
ABS
47787JAC2
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026
305,000.00
03/10/2022

2.34%
304,932.53
304,938.17

97.45 3.74%
297,231.35
314.49

0.18%
(
7,706.82
)
Aaa / NR
AAA

4.22 1.82
380146AC4
GM Financial Auto Receivables
2022-1

A
3 1.26%
Due
11/16/2026
200,000.00
01/11/2022

1.27%
199,982.62
199,984.96

95.68 4.09%
191,354.00
105.00

0.12%
(
8,630.96
)

NR / AAA
AAA

4.38 1.55
362585AC5
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027
300,000.00
04/05/2022

3.13%
299,937.30
299,941.26

99.09 3.60%
297,282.90
387.50

0.18%
(
2,658.36
)
Aaa / AAA
NR

4.64 1.90
02582JJT8
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027
840,000.00
05/17/2022

3.42%
839,814.19
839,820.69

99.89 3.46%
839,034.84
1,265.60

0.51%
(
785.85
)

NR / AAA
AAA

4.88 2.68
Total ABS
11,141,364.31

1.37%
11,150,062.30
11,145,183.46

3.49%
10,888,936.36
5,973.24

6.63%
(
256,247.10
)
Aaa / AAA
AAA

3.22 1.22
AGENCY
313382AX1
FHLB Note

2.125%
Due
3/10/2023
500,000.00
03/23/2018

2.73%
486,065.00
498,059.88

99.68 2.59%
498,407.00
3,276.04

0.31%
347.12
Aaa / AA+
AAA

0.69 0.68
313383QR5
FHLB Note

3.25%
Due
6/9/2023
500,000.00
08/28/2018

2.87%
508,335.00
501,638.34
100.30

2.92%
501,504.00
993.06

0.31%
(
134.34
)
Aaa / AA+
NR

0.94 0.92
3137EAEN5
FHLMC Note

2.75%
Due
6/19/2023
500,000.00
07/16/2018

2.88%
497,090.00
499,428.68

99.74 3.03%
498,675.00
458.33

0.30%
(
753.68
)
Aaa / AA+
AAA

0.97 0.95
3135G05G4
FNMA Note

0.25%
Due
7/10/2023
1,035,000.00
07/08/2020

0.32%
1,032,774.75
1,034,239.96

97.35 2.88%
1,007,592.17
1,229.06

0.61%
(
26,647.79
)
Aaa / AA+
AAA

1.03 1.01
313383YJ4
FHLB Note

3.375%
Due
9/8/2023
700,000.00
10/30/2018

3.08%
709,317.00
702,280.64
100.51

2.93%
703,581.90
7,415.63

0.43%
1,301.26
Aaa / AA+
NR

1.19 1.15
3135G0U43
FNMA Note

2.875%
Due
9/12/2023
645,000.00
09/12/2018

2.96%
642,355.50
644,364.97
100.04

2.84%
645,262.52
5,614.64

0.40%
897.55
Aaa / AA+
AAA

1.20 1.16
3130A0F70
FHLB Note

3.375%
Due
12/8/2023
900,000.00
Various

2.75%
925,664.50
907,527.78
100.57

2.97%
905,110.20
1,940.63

0.55%
(
2,417.58
)
Aaa / AA+
AAA

1.44 1.39
3135G0V34
FNMA Note

2.5%
Due
2/5/2024
700,000.00
02/25/2019

2.59%
697,172.00
699,085.01

99.36 2.91%
695,492.70
7,097.22

0.43%
(
3,592.31
)
Aaa / AA+
AAA

1.60 1.54
3130A1XJ2
FHLB Note

2.875%
Due
6/14/2024
680,000.00
Various

1.96%
709,321.60
691,484.18

99.72 3.02%
678,103.48
923.20

0.41%
(
13,380.70
)
Aaa / AA+
NR

1.96 1.88
3133EKWV4
FFCB Note

1.85%
Due
7/26/2024
500,000.00
08/13/2019

1.65%
504,828.00
502,018.79

97.97 2.87%
489,853.00
3,982.64

0.30%
(
12,165.79
)
Aaa / AA+
AAA

2.07 2.00
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 4 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
AGENCY
3130A2UW4
FHLB Note

2.875%
Due
9/13/2024
500,000.00
10/10/2019

1.58%
530,505.00
513,650.10

99.67 3.03%
498,368.00
4,312.50

0.31%
(
15,282.10
)
Aaa / AA+
AAA

2.21 2.10
3135G0W66
FNMA Note

1.625%
Due
10/15/2024
500,000.00
11/08/2019

1.80%
495,850.00
498,069.18

97.00 2.99%
484,979.50
1,715.28

0.30%
(
13,089.68
)
Aaa / AA+
AAA

2.30 2.22
3130A3GE8
FHLB Note

2.75%
Due
12/13/2024
1,850,000.00
02/26/2020

1.26%
1,977,594.50
1,915,291.07

99.38 3.01%
1,838,591.05
2,543.75

1.12%
(
76,700.02
)
Aaa / AA+
NR

2.46 2.35
3135G0X24
FNMA Note

1.625%
Due
1/7/2025
1,835,000.00
01/08/2020

1.69%
1,829,146.35
1,832,044.29

96.64 3.02%
1,773,294.46
14,412.40

1.09%
(
58,749.83
)
Aaa / AA+
AAA

2.53 2.42
3137EAEP0
FHLMC Note

1.5%
Due
2/12/2025
2,040,000.00
02/13/2020

1.52%
2,038,429.20
2,039,176.30

96.21 3.02%
1,962,606.48
11,815.00

1.20%
(
76,569.82
)
Aaa / AA+
AAA

2.62 2.52
3130A4CH3
FHLB Note

2.375%
Due
3/14/2025
1,750,000.00
03/19/2020

1.18%
1,851,097.50
1,804,825.95

98.15 3.09%
1,717,689.75
12,353.30

1.05%
(
87,136.20
)
Aaa / AA+
AAA

2.71 2.58
3130AJHU6
FHLB Note

0.5%
Due
4/14/2025
1,900,000.00
05/28/2020

0.50%
1,899,601.00
1,899,771.94

93.34 3.01%
1,773,511.30
2,031.94

1.08%
(
126,260.64
)
Aaa / AA+
AAA

2.79 2.73
3135G03U5
FNMA Note

0.625%
Due
4/22/2025
805,000.00
04/22/2020

0.67%
803,341.70
804,067.21

93.60 3.02%
753,450.22
964.32

0.46%
(
50,616.99
)
Aaa / AA+
AAA

2.81 2.75
3135G04Z3
FNMA Note

0.5%
Due
6/17/2025
2,020,000.00
06/17/2020

0.54%
2,015,818.60
2,017,519.59

92.85 3.04%
1,875,590.20
392.78

1.14%
(
141,929.39
)
Aaa / AA+
AAA

2.97 2.90
3137EAEU9
FHLMC Note

0.375%
Due
7/21/2025
1,075,000.00
07/21/2020

0.48%
1,069,646.50
1,071,724.50

92.34 3.02%
992,629.20
1,791.67

0.61%
(
79,095.30
)
Aaa / AA+
AAA

3.06 2.99
3135G05X7
FNMA Note

0.375%
Due
8/25/2025
1,700,000.00
08/25/2020

0.47%
1,692,044.00
1,694,979.52

91.94 3.08%
1,562,932.40
2,231.25

0.95%
(
132,047.12
)
Aaa / AA+
AAA

3.16 3.08
3137EAEX3
FHLMC Note

0.375%
Due
9/23/2025
1,560,000.00
09/23/2020

0.44%
1,555,304.40
1,556,962.28

91.79 3.06%
1,431,994.20
1,592.50

0.87%
(
124,968.08
)
Aaa / AA+
AAA

3.24 3.16
3135G06G3
FNMA Note

0.5%
Due
11/7/2025
1,680,000.00
11/09/2020

0.57%
1,673,985.60
1,675,954.07

91.91 3.06%
1,544,093.04
1,260.00

0.94%
(
131,861.03
)
Aaa / AA+
AAA

3.36 3.28
Total Agency
25,875,000.00

1.27%
26,145,287.70
26,004,164.23

3.00%
24,833,311.77
90,347.14

15.18%
(
1,170,852.46
)
Aaa / AA+
AAA

2.42 2.35
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 5 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration
CMO
3137BFE98

FHLMC K
041
A
2 3.171%
Due
10/25/2024
800,000.00
07/01/2021

0.72%
860,562.50
842,168.31

99.53 3.32%
796,250.40
2,114.00

0.49%
(
45,917.91
)
Aaa / AAA
AAA

2.32 2.11
Total CMO
800,000.00

0.72%
860,562.50
842,168.31

3.32%
796,250.40
2,114.00

0.49%
(
45,917.91
)
Aaa / AAA
AAA

2.32 2.11

CORPORATE
037833DC1
Apple Inc Callable Note Cont
8/12/2022

2.1%
Due
9/12/2022
625,000.00
09/12/2017

2.23%
621,206.25
624,848.17

99.95 2.34%
624,688.75
3,973.96

0.38%
(
159.42
)
Aaa / AA+
NR

0.20 0.20
931142EK5
Wal-Mart Stores Callable Note Cont
5/26/2023

3.4%
Due
6/26/2023
600,000.00
Various

3.35%
601,410.40
600,257.59
100.31

3.06%
601,833.00
283.33

0.37%
1,575.41
Aa
2 / AA
AA

0.99 0.89
06051GHF9
Bank of America Corp Callable Note
1 X
3/5/2023

3.55%
Due
3/5/2024
1,150,000.00
Various

2.11%
1,200,715.00
1,160,809.32

99.71 3.55%
1,146,639.70
13,154.72

0.71%
(
14,169.62
)
A
2 / A-
AA-

1.68 1.60
89114QCB2
Toronto Dominion Bank Note

3.25%
Due
3/11/2024
1,100,000.00
06/05/2020

0.99%
1,191,586.00
1,141,350.64

99.50 3.56%
1,094,453.80
10,923.61

0.67%
(
46,896.84
)
A
1 / A
AA-

1.70 1.62
023135BW5
Amazon.com Inc Note

0.45%
Due
5/12/2024
755,000.00
05/10/2021

0.50%
753,897.70
754,315.09

95.16 3.14%
718,434.60
462.44

0.44%
(
35,880.49
)
A
1 / AA
AA-

1.87 1.83
747525AT0
Qualcomm Inc Callable Note Cont
3/20/2024

2.9%
Due
5/20/2024
1,150,000.00
12/05/2019

2.16%
1,184,626.50
1,163,912.63

99.63 3.10%
1,145,759.95
3,798.19

0.70%
(
18,152.68
)
A
2 / A
NR

1.89 1.82
02665WCZ2
American Honda Finance Note

2.4%
Due
6/27/2024
1,150,000.00
Various

2.31%
1,154,431.00
1,152,021.33

97.77 3.57%
1,124,394.10
306.67

0.68%
(
27,627.23
)
A
3 / A-
A

1.99 1.92
79466LAG9
Salesforce.com Inc Callable Note Cont
7/15/2022

0.625%
Due
7/15/2024
190,000.00
06/29/2021

0.64%
189,903.10
189,934.31

94.71 3.33%
179,951.66
547.57

0.11%
(
9,982.65
)
A
2 / A+
NR

2.04 1.99
78013XZU5
Royal Bank of Canada Note

2.55%
Due
7/16/2024
1,150,000.00
Various

2.26%
1,164,978.75
1,156,488.26

97.73 3.71%
1,123,854.76
13,440.62

0.69%
(
32,633.50
)
A
1 / A
AA-

2.05 1.95
14913Q3B3
Caterpillar Finl Service Note

2.15%
Due
11/8/2024
650,000.00
02/19/2020

1.83%
659,256.00
654,628.00

97.10 3.44%
631,119.45
2,057.43

0.39%
(
23,508.55
)
A
2 / A
A

2.36 2.26
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 6 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration

CORPORATE
90331HPL1
US Bank NA Callable Note Cont
12/21/2024

2.05%
Due
1/21/2025
1,150,000.00
01/16/2020

2.10%
1,147,550.50
1,148,746.42

96.14 3.64%
1,105,637.60
10,477.78

0.68%
(
43,108.82
)
A
1 / AA-
AA-

2.56 2.44
00440EAS6
Chubb INA Holdings Inc Note

3.15%
Due
3/15/2025
1,150,000.00
02/24/2021

0.83%
1,255,961.00
1,220,831.85

98.33 3.80%
1,130,755.90
10,666.25

0.70%
(
90,075.95
)
A
3 / A
A

2.71 2.54
06367WB85
Bank of Montreal Note

1.85%
Due
5/1/2025
1,150,000.00
03/24/2021

1.15%
1,182,257.50
1,172,302.28

94.88 3.77%
1,091,162.55
3,545.83

0.67%
(
81,139.73
)
A
2 / A-
AA-

2.84 2.71
14913R2V8
Caterpillar Financial Service Note

3.4%
Due
5/13/2025
445,000.00
05/10/2022

3.44%
444,434.85
444,460.12

99.83 3.46%
444,253.74
2,017.33

0.27%
(
206.38
)
A
2 / A
A

2.87 2.70
61747YEA9
Morgan Stanley Callable Note Cont
5/30/2024

0.79%
Due
5/30/2025
1,240,000.00
05/26/2021

0.77%
1,240,658.30
1,240,420.62

93.30 3.66%
1,156,939.84
843.54

0.71%
(
83,480.78
)
A
1 / A-
A

2.92 2.83
78015K7H1
Royal Bank of Canada Note

1.15%
Due
6/10/2025
400,000.00
12/22/2021

1.43%
396,240.00
396,794.61

92.60 3.83%
370,417.20
268.33

0.23%
(
26,377.41
)
A
1 / A
AA-

2.95 2.85
63743HFE7
National Rural Utilities Note

3.45%
Due
6/15/2025
685,000.00
Various

3.55%
683,003.05
683,103.22

99.64 3.58%
682,543.59
3,741.81

0.42%
(
559.63
)
A
2 / A-
A

2.96 2.77
46647PBF2
JP Morgan Chase & Co Callable Note
1 X
10/15/2024

2.301%
Due
10/15/2025
1,150,000.00
11/13/2020

0.93%
1,210,363.50
1,185,381.13

95.31 3.95%
1,096,101.80
5,586.32

0.67%
(
89,279.33
)
A
2 / A-
AA-

3.30 3.11
46647PBK1
JP Morgan Chase & Co Callable Note
Cont
4/22/2025

2.083%
Due
4/22/2026
500,000.00
09/16/2021

1.17%
515,945.00
512,488.22

93.59 4.25%
467,954.00
1,996.21

0.29%
(
44,534.22
)
A
2 / A-
AA-

3.81 3.58
91324PEC2
United Health Group Inc Callable Note
Cont
4/15/2026

1.15%
Due
5/15/2026
1,245,000.00
Various

1.41%
1,231,472.05
1,233,068.24

90.77 3.73%
1,130,026.74
1,829.45

0.69%
(
103,041.50
)
A
3 / A+
A

3.88 3.72
89236TJK2
Toyota Motor Credit Corp Note

1.125%
Due
6/18/2026
810,000.00
06/15/2021

1.13%
809,643.60
809,717.38

90.43 3.74%
732,446.55
329.06

0.45%
(
77,270.83
)
A
1 / A+
A+

3.97 3.81
06051GJD2
Bank of America Corp Callable Note
Cont
6/19/2025

1.319%
Due
6/19/2026
500,000.00
09/16/2021

1.23%
501,675.00
501,327.27

90.83 4.18%
454,135.50
219.83

0.28%
(
47,191.77
)
A
2 / A-
AA-

3.97 3.79
931142ER0
Wal-Mart Stores Callable Note Cont
08/17/2026

1.05%
Due
9/17/2026
240,000.00
09/08/2021

1.09%
239,546.40
239,617.69

91.05 3.34%
218,531.28
728.00

0.13%
(
21,086.41
)
Aa
2 / AA
AA

4.22 4.05
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 7 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration

CORPORATE
87612EBM7
Target Corp Callable Note Cont
12/15/2026

1.95%
Due
1/15/2027
545,000.00
01/19/2022

1.99%
544,073.50
544,154.07

92.89 3.66%
506,269.58
4,634.77

0.31%
(
37,884.49
)
A
2 / A
A

4.55 4.24
808513BY0
Charles Schwab Corp Callable Note
Cont
2/3/2027

2.45%
Due
3/3/2027
1,000,000.00
Various

2.76%
985,444.30
986,298.68

93.40 4.01%
933,951.00
8,030.56

0.57%
(
52,347.68
)
A
2 / A
A

4.68 4.31
084664CZ2
Berkshire Hathaway Callable Note Cont
2/15/2027

2.3%
Due
3/15/2027
1,095,000.00
03/07/2022

2.30%
1,094,791.95
1,094,804.26

94.59 3.56%
1,035,783.50
7,415.58

0.64%
(
59,020.76
)
Aa
2 / AA
A+

4.71 4.37
023135CF1
Amazon.com Inc Callable Note Cont
03/13/2027

3.3%
Due
4/13/2027
750,000.00
04/25/2022

3.34%
748,702.50
748,749.04

98.22 3.71%
736,677.00
5,362.50

0.45%
(
12,072.04
)
A
1 / AA
AA-

4.79 4.35
927804GH1
Virginia Electric Power Corp Callable
Note Cont.
4/15/2027

3.75%
Due
5/15/2027
250,000.00
05/16/2022

3.82%
249,220.00
249,233.36

99.15 3.94%
247,877.00
807.29

0.15%
(
1,356.36
)
A
2 / BBB+
A

4.88 4.40
Total Corporate
22,825,000.00

1.81%
23,202,993.70
23,010,063.80

3.60%
21,932,594.14
117,448.98

13.43%
(
1,077,469.66
)
A
1 / A
A+

2.87 2.71
LAIF
90LAIF$00
Local Agency Investment Fund State
Pool
73,135,065.63
Various

0.94%
73,135,065.63
73,135,065.63

1.00 0.94%
73,135,065.63
125,261.16

44.61%

0.00 NR / NR
NR

0.00 0.00
Total LAIF
73,135,065.63

0.94%
73,135,065.63
73,135,065.63

0.94%
73,135,065.63
125,261.16

44.61%

0.00 NR / NR
NR

0.00 0.00

MONEY MARKET FUND
94975H312
Wells Fargo Advantage Treasury Plus
MMF
2,320,176.09
Various

0.99%
2,320,176.09
2,320,176.09

1.00 0.99%
2,320,176.09

0.00 1.41%

0.00 Aaa / AAA
NR

0.00 0.00
Total Money Market Fund
2,320,176.09

0.99%
2,320,176.09
2,320,176.09

0.99%
2,320,176.09

0.00 1.41%

0.00 Aaa / AAA
NR

0.00 0.00
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 8 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration

NEGOTIABLE CD
86959RTW0
Svenska Handelsbanken NY Yankee CD

0.255%
Due
10/14/2022
1,000,000.00
10/15/2021

0.25%
1,000,050.43
1,000,014.55

99.45 2.13%
994,510.00
1,834.58

0.61%
(
5,504.55
)
P-
1 / A-
1 +
F-
1 +

0.29 0.29
Total Negotiable CD
1,000,000.00

0.25%
1,000,050.43
1,000,014.55

2.13%
994,510.00
1,834.58

0.61%
(
5,504.55
)
Aaa / AAA
AAA

0.29 0.29

US TREASURY
912828V80
US Treasury Note

2.25%
Due
1/31/2024
1,450,000.00
Various

0.81%
1,524,039.06
1,482,619.31

98.94 2.94%
1,434,593.75
13,608.77

0.88%
(
48,025.56
)
Aaa / AA+
AAA

1.59 1.53
912828W48
US Treasury Note

2.125%
Due
2/29/2024
550,000.00
04/10/2019

2.29%
545,939.45
548,616.91

98.71 2.92%
542,909.95
3,906.42

0.33%
(
5,706.96
)
Aaa / AA+
AAA

1.67 1.61
912828W71
US Treasury Note

2.125%
Due
3/31/2024
500,000.00
04/23/2019

2.36%
494,472.66
498,041.06

98.60 2.95%
493,008.00
2,670.77

0.30%
(
5,033.06
)
Aaa / AA+
AAA

1.75 1.69
912828X70
US Treasury Note
2%
Due
4/30/2024
2,000,000.00
Various

1.43%
2,045,894.53
2,020,366.54

98.33 2.94%
1,966,640.00
6,739.13

1.20%
(
53,726.54
)
Aaa / AA+
AAA

1.84 1.78
912828WJ5
US Treasury Note

2.5%
Due
5/15/2024
2,000,000.00
Various

1.00%
2,125,234.37
2,054,997.41

99.18 2.95%
1,983,672.00
6,385.87

1.21%
(
71,325.41
)
Aaa / AA+
AAA

1.88 1.81
912828YH7
US Treasury Note

1.5%
Due
9/30/2024
2,000,000.00
Various

1.37%
2,010,562.50
2,005,481.48

96.82 2.97%
1,936,484.00
7,540.99

1.18%
(
68,997.48
)
Aaa / AA+
AAA

2.25 2.18
9128283J7
US Treasury Note

2.125%
Due
11/30/2024
2,000,000.00
Various

1.50%
2,058,496.09
2,029,236.32

98.02 2.98%
1,960,390.00
3,599.73

1.20%
(
68,846.32
)
Aaa / AA+
AAA

2.42 2.33
912828J27
US Treasury Note
2%
Due
2/15/2025
1,850,000.00
02/27/2020

1.07%
1,932,888.67
1,893,866.11

97.52 2.99%
1,804,038.60
13,900.55

1.11%
(
89,827.51
)
Aaa / AA+
AAA

2.63 2.51
9128283Z1
US Treasury Note

2.75%
Due
2/28/2025
700,000.00
03/05/2020

0.69%
770,519.53
737,700.83

99.38 2.99%
695,625.00
6,434.10

0.43%
(
42,075.83
)
Aaa / AA+
AAA

2.67 2.53
912828ZC7
US Treasury Note

1.125%
Due
2/28/2025
1,500,000.00
Various

0.50%
1,541,923.83
1,524,649.68

95.27 2.98%
1,429,101.00
5,640.28

0.87%
(
95,548.68
)
Aaa / AA+
AAA

2.67 2.59
91282CAZ4
US Treasury Note

0.375%
Due
11/30/2025
2,000,000.00
12/28/2020

0.38%
1,999,453.13
1,999,620.20

91.44 3.03%
1,828,828.00
635.25

1.11%
(
170,792.20
)
Aaa / AA+
AAA

3.42 3.35
91282CBC4
US Treasury Note

0.375%
Due
12/31/2025
2,000,000.00
01/27/2021

0.39%
1,998,125.00
1,998,666.23

91.25 3.03%
1,824,922.00

20.38 1.11%
(
173,744.23
)
Aaa / AA+
AAA

3.51 3.43
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 9 ends

Gain/Loss
Moody/S&P
Fitch
Maturity
Duration

US TREASURY
91282CBT7
US Treasury Note

0.75%
Due
3/31/2026
1,500,000.00
03/30/2021

0.91%
1,487,988.28
1,490,994.50

91.96 3.03%
1,379,472.00
2,827.87

0.84%
(
111,522.50
)
Aaa / AA+
AAA

3.75 3.64
91282CBW0
US Treasury Note

0.75%
Due
4/30/2026
1,000,000.00
04/29/2021

0.89%
993,398.44
994,942.18

91.79 3.03%
917,891.00
1,263.59

0.56%
(
77,051.18
)
Aaa / AA+
AAA

3.84 3.72
91282CCP4
US Treasury Note

0.625%
Due
7/31/2026
1,000,000.00
08/10/2021

0.82%
990,507.81
992,202.28

90.81 3.03%
908,125.00
2,607.04

0.55%
(
84,077.28
)
Aaa / AA+
AAA

4.09 3.97
91282CCW9
US Treasury Note

0.75%
Due
8/31/2026
2,250,000.00
Various

0.97%
2,226,699.22
2,229,961.59

91.15 3.02%
2,050,926.75
5,640.28

1.25%
(
179,034.84
)
Aaa / AA+
AAA

4.17 4.04
91282CDG3
US Treasury Note

1.125%
Due
10/31/2026
3,000,000.00
Various

1.27%
2,979,511.72
2,981,893.43

92.31 3.03%
2,769,258.00
5,686.15

1.69%
(
212,635.43
)
Aaa / AA+
AAA

4.34 4.17
912828Z78
US Treasury Note

1.5%
Due
1/31/2027
500,000.00
03/30/2022

2.46%
478,320.31
479,449.08

93.50 3.03%
467,519.50
3,128.45

0.29%
(
11,929.58
)
Aaa / AA+
AAA

4.59 4.35
91282CEN7
US Treasury Note

2.75%
Due
4/30/2027
2,500,000.00
Various

3.23%
2,445,792.97
2,446,366.00

98.80 3.01%
2,469,922.50
11,582.88

1.51%
23,556.50
Aaa / AA+
AAA

4.84 4.48
Total US Treasury
30,300,000.00

1.23%
30,649,767.57
30,409,671.14

3.00%
28,863,327.05
103,818.50

17.64%
(
1,546,344.09
)
Aaa / AA+
AAA

3.14 3.02

TOTAL PORTFOLIO
167,396,606.03

1.19%
168,463,965.92
167,866,507.21

2.16%
163,764,171.44
446,797.60
100.00%
(
4,102,335.77
)
Aa
1 / AA
AAA

1.53 1.34

TOTAL MARKET VALUE PLUS ACCRUED
164,210,969.04
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 10 ends

Transaction Ledger
As of June 30, 2022
City of Vallejo Consolidated
Account #262
Transaction
Type
Settlement
Date
CUSIP
Quantity
Security Description
Price
Acq/Disp
Yield
Amount
Interest
Pur/Sold
Total Amount
Gain/Loss

ACQUISITIONS
Purchase
06/01/2022
94975H312
225.41
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
225.41

0.00 225.41

0.00 Purchase
06/07/2022
91282CEN7
1,200,000.00
US Treasury Note

2.75%
Due
4/30/2027

98.805

3.01%
1,185,656.25
3,407.61
1,189,063.86

0.00 Purchase
06/08/2022
94975H312
1,005,406.60
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
1,005,406.60

0.00 1,005,406.60

0.00 Purchase
06/08/2022
94975H312
15,187.50
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
15,187.50

0.00 15,187.50

0.00 Purchase
06/09/2022
94975H312
8,125.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
8,125.00

0.00 8,125.00

0.00 Purchase
06/10/2022
94975H312
2,300.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
2,300.00

0.00 2,300.00

0.00 Purchase
06/13/2022
94975H312
25,437.50
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
25,437.50

0.00 25,437.50

0.00 Purchase
06/14/2022
91282CEN7
1,300,000.00
US Treasury Note

2.75%
Due
4/30/2027

96.934

3.43%
1,260,136.72
4,371.60
1,264,508.32

0.00 Purchase
06/14/2022
94975H312
482,005.31
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
482,005.31

0.00 482,005.31

0.00 Purchase
06/14/2022
94975H312
9,775.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
9,775.00

0.00 9,775.00

0.00 Purchase
06/15/2022
94975H312

46.58 Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%

46.58 0.00

46.58 0.00
Purchase
06/15/2022
94975H312

75.00 Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%

75.00 0.00

75.00 0.00
Purchase
06/15/2022
94975H312
716.67
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
716.67

0.00 716.67

0.00 Purchase
06/15/2022
94975H312
153.33
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
153.33

0.00 153.33

0.00 Purchase
06/15/2022
94975H312
169.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
169.00

0.00 169.00

0.00 Purchase
06/15/2022
94975H312
128.25
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
128.25

0.00 128.25

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 11 ends

ACQUISITIONS
Purchase
06/15/2022
94975H312
266.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
266.00

0.00 266.00

0.00 Purchase
06/15/2022
94975H312
135.67
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
135.67

0.00 135.67

0.00 Purchase
06/15/2022
94975H312
589.67
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
589.67

0.00 589.67

0.00 Purchase
06/15/2022
94975H312
1,661.10
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
1,661.10

0.00 1,661.10

0.00 Purchase
06/15/2022
94975H312
18,484.13
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
18,484.13

0.00 18,484.13

0.00 Purchase
06/15/2022
94975H312
9,494.75
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
9,494.75

0.00 9,494.75

0.00 Purchase
06/15/2022
94975H312
9,725.40
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
9,725.40

0.00 9,725.40

0.00 Purchase
06/15/2022
94975H312
21,840.33
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
21,840.33

0.00 21,840.33

0.00 Purchase
06/15/2022
94975H312
15,985.32
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
15,985.32

0.00 15,985.32

0.00 Purchase
06/15/2022
94975H312
52,553.73
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
52,553.73

0.00 52,553.73

0.00 Purchase
06/15/2022
94975H312
7,835.72
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
7,835.72

0.00 7,835.72

0.00 Purchase
06/16/2022
94975H312
817.96
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
817.96

0.00 817.96

0.00 Purchase
06/16/2022
94975H312
783.33
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
783.33

0.00 783.33

0.00 Purchase
06/16/2022
94975H312
133.17
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
133.17

0.00 133.17

0.00 Purchase
06/16/2022
94975H312
775.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
775.00

0.00 775.00

0.00 Purchase
06/16/2022
94975H312
210.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
210.00

0.00 210.00

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 12 ends

ACQUISITIONS
Purchase
06/17/2022
94975H312
5,050.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
5,050.00

0.00 5,050.00

0.00 Purchase
06/18/2022
94975H312
4,556.25
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
4,556.25

0.00 4,556.25

0.00 Purchase
06/19/2022
94975H312
10,172.50
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
10,172.50

0.00 10,172.50

0.00 Purchase
06/21/2022
94975H312
270.25
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
270.25

0.00 270.25

0.00 Purchase
06/21/2022
94975H312
227.33
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
227.33

0.00 227.33

0.00 Purchase
06/21/2022
94975H312
1,013.33
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
1,013.33

0.00 1,013.33

0.00 Purchase
06/21/2022
94975H312
30,788.62
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
30,788.62

0.00 30,788.62

0.00 Purchase
06/21/2022
94975H312
21,712.67
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
21,712.67

0.00 21,712.67

0.00 Purchase
06/24/2022
94975H312
1,482.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
1,482.00

0.00 1,482.00

0.00 Purchase
06/26/2022
94975H312
10,200.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
10,200.00

0.00 10,200.00

0.00 Purchase
06/27/2022
94975H312
13,800.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
13,800.00

0.00 13,800.00

0.00 Purchase
06/27/2022
94975H312
279.58
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
279.58

0.00 279.58

0.00 Purchase
06/27/2022
94975H312
1,130.19
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
1,130.19

0.00 1,130.19

0.00 Purchase
06/27/2022
94975H312

79.75 Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%

79.75 0.00

79.75 0.00
Purchase
06/27/2022
94975H312
2,114.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
2,114.00

0.00 2,114.00

0.00 Purchase
06/28/2022
94975H312
707,145.60
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
707,145.60

0.00 707,145.60

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 13 ends

ACQUISITIONS
Purchase
06/30/2022
94975H312
3,750.00
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.99%
3,750.00

0.00 3,750.00

0.00 Subtotal
5,004,814.50
4,950,607.47
7,779.21
4,958,386.68

0.00 Short Sale
06/07/2022
94975H312
-1,189,063.86
Wells Fargo Advantage Treasury Plus
MMF

1.000
-1,189,063.86

0.00 -1,189,063.86

0.00 Subtotal
-1,189,063.86
-1,189,063.86

0.00 -1,189,063.86

0.00 TOTAL ACQUISITIONS
3,815,750.64
3,761,543.61
7,779.21
3,769,322.82

0.00 DISPOSITIONS
Closing
Purchase
06/08/2022
94975H312
-1,189,063.86
Wells Fargo Advantage Treasury Plus
MMF

1.000
-1,189,063.86

0.00 -1,189,063.86

0.00 Subtotal
-1,189,063.86
-1,189,063.86

0.00 -1,189,063.86

0.00 Sale
06/08/2022
912828P38
1,000,000.00
US Treasury Note

1.75%
Due
1/31/2023

99.922

2.63%
999,218.75
6,187.85
1,005,406.60
4,553.12
Sale
06/08/2022
94975H312
1,189,063.86
Wells Fargo Advantage Treasury Plus
MMF

1.000

0.34%
1,189,063.86

0.00 1,189,063.86

0.00 Sale
06/14/2022
3135G0T94
1,000,000.00
FNMA Note

2.375%
Due
1/19/2023

99.993

2.82%
999,930.00
9,565.97
1,009,495.97
2,201.20
Sale
06/14/2022
912828T91
750,000.00
US Treasury Note

1.625%
Due
10/31/2023

98.070

2.87%
735,527.34
1,490.32
737,017.66
-2,543.41
Subtotal
3,939,063.86
3,923,739.95
17,244.14
3,940,984.09
4,210.91
Call
06/28/2022
69353RFE3
700,000.00
PNC Bank Callable Note Cont
6/28/2022

2.45%
Due
7/28/2022
100.000

2.14%
700,000.00
7,145.60
707,145.60

0.00 Subtotal
700,000.00
700,000.00
7,145.60
707,145.60

0.00 Paydown
06/15/2022
02582JJT8

0.00 American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027
100.000

0.00 1,661.10
1,661.10

0.00 Paydown
06/15/2022
14041NFU0

0.00 Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
100.000

0.00 716.67
716.67

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 14 ends

DISPOSITIONS
Paydown
06/15/2022
14042WAC4
18,361.78
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
100.000
18,361.78
122.35
18,484.13

0.00 Paydown
06/15/2022
44891RAC4
9,336.42
Hyundai Auto Receivables Trust
2020
-C
A
3 0.38%
Due
5/15/2025
100.000
9,336.42
158.33
9,494.75

0.00 Paydown
06/15/2022
44933LAC7

0.00 Hyundai Auto Receivables Trust
2021
-A
A
3 0.38%
Due
9/15/2025
100.000

0.00 128.25
128.25

0.00 Paydown
06/15/2022
44934KAC8

0.00 Hyundai Auto Receivables Trust
2021
-B
A
3 0.38%
Due
1/15/2026
100.000

0.00 266.00
266.00

0.00 Paydown
06/15/2022
44935FAD6

0.00 Hyundai Auto Receivables Trust
2021
-C
A
3 0.74%
Due
5/15/2026
100.000

0.00 135.67
135.67

0.00 Paydown
06/15/2022
47787JAC2

0.00 John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026
100.000

0.00 589.67
589.67

0.00 Paydown
06/15/2022
47787NAC3
9,661.83
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
100.000
9,661.83

63.57 9,725.40

0.00 Paydown
06/15/2022
47788UAC6

0.00 John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
100.000

0.00 75.00

75.00 0.00
Paydown
06/15/2022
47789KAC7
21,594.02
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
100.000
21,594.02
246.31
21,840.33

0.00 Paydown
06/15/2022
47789QAC4

0.00 John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026
100.000

0.00 169.00
169.00

0.00 Paydown
06/15/2022
58769KAD6

0.00 Mercedes-Benz Auto Lease Trust
2021
-
B A
3 0.4%
Due
11/15/2024
100.000

0.00 153.33
153.33

0.00 Paydown
06/15/2022
65479JAD5
15,766.71
Nissan Auto Receivables Owner
2019
-C
A
3 1.93%
Due
7/15/2024
100.000
15,766.71
218.61
15,985.32

0.00 Paydown
06/15/2022
89232HAC9
51,863.63
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
100.000
51,863.63
690.10
52,553.73

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 15 ends

DISPOSITIONS
Paydown
06/15/2022
89237VAB5
7,799.63
Toyota Auto Receivables Trust
2020
-C
A
3 0.44%
Due
10/15/2024
100.000
7,799.63

36.09 7,835.72

0.00 Paydown
06/15/2022
89240BAC2

0.00 Toyota Auto Receivables Owners
2021
-
A A
3 0.26%
Due
5/15/2025
100.000

0.00 46.58

46.58 0.00
Paydown
06/16/2022
362554AC1

0.00 GM Financial Securitized Term
2021-4

A
3 0.68%
Due
9/16/2026
100.000

0.00 133.17
133.17

0.00 Paydown
06/16/2022
362585AC5

0.00 GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027
100.000

0.00 775.00
775.00

0.00 Paydown
06/16/2022
380146AC4

0.00 GM Financial Auto Receivables
2022-1

A
3 1.26%
Due
11/16/2026
100.000

0.00 210.00
210.00

0.00 Paydown
06/16/2022
43815BAC4

0.00 Honda Auto Receivables Trust
2022-1

A
3 1.88%
Due
5/15/2026
100.000

0.00 783.33
783.33

0.00 Paydown
06/16/2022
89238FAD5

0.00 Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026
100.000

0.00 817.96
817.96

0.00 Paydown
06/21/2022
02582JJT8

0.00 American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027
100.000

0.00 0.00

0.00 0.00
Paydown
06/21/2022
14041NFU0

0.00 Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
100.000

0.00 0.00

0.00 0.00
Paydown
06/21/2022
362554AC1

0.00 GM Financial Securitized Term
2021-4

A
3 0.68%
Due
9/16/2026
100.000

0.00 0.00

0.00 0.00
Paydown
06/21/2022
36265MAC9

0.00 GM Financial Auto Lease Trust
2022-1

A
3 1.9%
Due
3/20/2025
100.000

0.00 1,013.33
1,013.33

0.00 Paydown
06/21/2022
43813KAC6
30,651.71
Honda Auto Receivables Trust
2020-3

A
3 0.37%
Due
10/18/2024
100.000
30,651.71
136.91
30,788.62

0.00 Paydown
06/21/2022
43813RAC1
21,405.72
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
100.000
21,405.72
306.95
21,712.67

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 16 ends

DISPOSITIONS
Paydown
06/21/2022
43815GAC3

0.00 Honda Auto Receivables Trust
2021-4

A
3 0.88%
Due
1/21/2026
100.000

0.00 227.33
227.33

0.00 Paydown
06/21/2022
92290BAA9

0.00 Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
100.000

0.00 270.25
270.25

0.00 Paydown
06/24/2022
36266FAC3

0.00 GM Financial Auto Lease Trust
2022-2

A
3 3.42%
Due
6/20/2025
100.000

0.00 1,482.00
1,482.00

0.00 Paydown
06/27/2022
05601XAC3

0.00 BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025
100.000

0.00 279.58
279.58

0.00 Paydown
06/27/2022
05602RAD3

0.00 BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026
100.000

0.00 1,130.19
1,130.19

0.00 Paydown
06/27/2022
09690AAC7

0.00 BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
100.000

0.00 79.75

79.75 0.00
Paydown
06/27/2022
3137BFE98

0.00 FHLMC K
041
A
2 3.171%
Due
10/25/2024
100.000

0.00 2,114.00
2,114.00

0.00 Subtotal
186,441.45
186,441.45
15,236.38
201,677.83

0.00 TOTAL DISPOSITIONS
3,636,441.45
3,621,117.54
39,626.12
3,660,743.66
4,210.91

OTHER TRANSACTIONS
Interest
06/08/2022
3130A0F70
900,000.00
FHLB Note

3.375%
Due
12/8/2023

0.000
15,187.50

0.00 15,187.50

0.00 Interest
06/09/2022
313383QR5
500,000.00
FHLB Note

3.25%
Due
6/9/2023

0.000
8,125.00

0.00 8,125.00

0.00 Interest
06/10/2022
78015K7H1
400,000.00
Royal Bank of Canada Note

1.15%
Due
6/10/2025

0.000
2,300.00

0.00 2,300.00

0.00 Interest
06/13/2022
3130A3GE8
1,850,000.00
FHLB Note

2.75%
Due
12/13/2024

0.000
25,437.50

0.00 25,437.50

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 17 ends

OTHER TRANSACTIONS
Interest
06/14/2022
3130A1XJ2
680,000.00
FHLB Note

2.875%
Due
6/14/2024

0.000
9,775.00

0.00 9,775.00

0.00 Interest
06/17/2022
3135G04Z3
2,020,000.00
FNMA Note

0.5%
Due
6/17/2025

0.000
5,050.00

0.00 5,050.00

0.00 Interest
06/18/2022
89236TJK2
810,000.00
Toyota Motor Credit Corp Note

1.125%
Due
6/18/2026

0.000
4,556.25

0.00 4,556.25

0.00 Interest
06/19/2022
06051GJD2
500,000.00
Bank of America Corp Callable Note
Cont
6/19/2025

1.319%
Due
6/19/2026

0.000
3,297.50

0.00 3,297.50

0.00 Interest
06/19/2022
3137EAEN5
500,000.00
FHLMC Note

2.75%
Due
6/19/2023

0.000
6,875.00

0.00 6,875.00

0.00 Interest
06/26/2022
931142EK5
600,000.00
Wal-Mart Stores Callable Note Cont
5/26/2023

3.4%
Due
6/26/2023

0.000
10,200.00

0.00 10,200.00

0.00 Interest
06/27/2022
02665WCZ2
1,150,000.00
American Honda Finance Note

2.4%
Due
6/27/2024

0.000
13,800.00

0.00 13,800.00

0.00 Interest
06/30/2022
91282CBC4
2,000,000.00
US Treasury Note

0.375%
Due
12/31/2025

0.000
3,750.00

0.00 3,750.00

0.00 Subtotal
11,910,000.00
108,353.75

0.00 108,353.75

0.00 Dividend
06/01/2022
94975H312
5,423,158.27
Wells Fargo Advantage Treasury Plus
MMF

0.000
225.41

0.00 225.41

0.00 Subtotal
5,423,158.27
225.41

0.00 225.41

0.00 TOTAL OTHER TRANSACTIONS
17,333,158.27
108,579.16

0.00 108,579.16

0.00 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 18 ends

Income Earned
As of June 30, 2022
City of Vallejo Consolidated
Account #262
CUSIP
Security Description
Trade Date
Settle Date
Units
Book Value: Begin
Book Value: Acq
Book Value: Disp
Book Value: End
Prior Accrued
Inc. Received
Ending Accrued
Total Interest
Accr. Of Discount
Amort. Of Premium
Net Accret/Amort
Income Earned
Total Income

FIXED INCOME
00440EAS6
Chubb INA Holdings Inc
Note

3.15%
Due
03/15/2025
02/24/2021
02/26/2021
1,150,000.00
1,222,982.61

0.00 0.00
1,220,831.85
7,647.50

0.00 10,666.25
3,018.75

0.00 2,150.76
(
2,150.76
)
867.99
867.99
023135BW5
Amazon.com Inc
Note

0.45%
Due
05/12/2024
05/10/2021
05/12/2021
755,000.00
754,284.91

0.00 0.00
754,315.09
179.31

0.00 462.44
283.13

30.18 0.00

30.18 313.31
313.31
023135CF1
Amazon.com Inc
Callable Note Cont
03/13/2027

3.3%
Due
04/13/2027
04/25/2022
04/27/2022
750,000.00
748,727.56

0.00 0.00
748,749.04
3,300.00

0.00 5,362.50
2,062.50

21.48 0.00

21.48 2,083.98
2,083.98
02582JJT8
American Express Credit Trust
2022-2
A

3.39%
Due
05/17/2027
05/17/2022
05/24/2022
840,000.00
839,815.56

0.00 0.00
839,820.69
553.70
1,661.10
1,265.60
2,373.00

5.13 0.00

5.13 2,378.13
2,378.13
02665WCZ2
American Honda Finance
Note

2.4%
Due
06/27/2024
Various
Various
1,150,000.00
1,152,104.75

0.00 0.00
1,152,021.33
11,806.67
13,800.00
306.67
2,300.00

37.99 121.41
(

83.42 )
2,216.58
2,216.58
037833DC1
Apple Inc
Callable Note Cont
8/12/2022

2.1%
Due
09/12/2022
09/12/2017
09/14/2017
625,000.00
624,785.77

0.00 0.00
624,848.17
2,880.21

0.00 3,973.96
1,093.75

62.40 0.00

62.40 1,156.15
1,156.15
05601XAC3
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
03/25/2025
01/11/2022
01/19/2022
305,000.00
304,962.02

0.00 0.00
304,963.74

55.92 279.58

1.72 0.00

1.72 281.30
281.30
05602RAD3
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
08/25/2026
05/10/2022
05/18/2022
325,000.00
324,983.31

0.00 0.00
324,983.76
376.73
1,130.19
173.88
927.34

0.45 0.00

0.45 927.79
927.79
06051GHF9
Bank of America Corp
Callable Note
1 X
3/5/2023

3.55%
Due
03/05/2024
Various
Various
1,150,000.00
1,162,122.19

0.00 0.00
1,160,809.32
9,752.64

0.00 13,154.72
3,402.08

0.00 1,312.87
(
1,312.87
)
2,089.21
2,089.21
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 19 ends

1.319%
Due
06/19/2026
09/16/2021
09/20/2021
500,000.00
501,364.00

0.00 0.00
501,327.27
2,967.75
3,297.50
219.83
549.58

0.00 36.73
(

36.73 )
512.85
512.85
06367WB85
Bank of Montreal
Note

1.85%
Due
05/01/2025
03/24/2021
03/26/2021
1,150,000.00
1,172,948.72

0.00 0.00
1,172,302.28
1,772.92

0.00 3,545.83
1,772.91

0.00 646.44
(
646.44
)
1,126.47
1,126.47
084664CZ2
Berkshire Hathaway
Callable Note Cont
2/15/2027

2.3%
Due
03/15/2027
03/07/2022
03/15/2022
1,095,000.00
1,094,800.84

0.00 0.00
1,094,804.26
5,316.83

0.00 7,415.58
2,098.75

3.42 0.00

3.42 2,102.17
2,102.17
09690AAC7
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
09/08/2021
09/15/2021
290,000.00
289,979.40

0.00 0.00
289,980.48

15.95 79.75

1.08 0.00

1.08 80.83

80.83 14041NFU0
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
08/15/2024
08/28/2019
09/05/2019
500,000.00
499,943.81

0.00 0.00
499,945.90
382.22
716.67
382.22
716.67

2.09 0.00

2.09 718.76
718.76
14042WAC4
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
05/21/2019
05/21/2019
40,131.80
58,489.73

0.00 18,361.78
40,129.31

65.25 122.35

44.77 101.87

1.36 0.00

1.36 103.23
103.23
14913Q3B3
Caterpillar Finl Service
Note

2.15%
Due
11/08/2024
02/19/2020
02/21/2020
650,000.00
654,789.25

0.00 0.00
654,628.00
892.85

0.00 2,057.43
1,164.58

0.00 161.25
(
161.25
)
1,003.33
1,003.33
14913R2V8
Caterpillar Financial Service
Note

3.4%
Due
05/13/2025
05/10/2022
05/13/2022
445,000.00
444,444.65

0.00 0.00
444,460.12
756.50

0.00 2,017.33
1,260.83

15.47 0.00

15.47 1,276.30
1,276.30
3130A0F70
FHLB
Note

3.375%
Due
12/08/2023
Various
Various
900,000.00
907,957.94

0.00 0.00
907,527.78
14,596.87
15,187.50
1,940.63
2,531.26

0.00 430.16
(
430.16
)
2,101.10
2,101.10
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 20 ends

2.875%
Due
06/14/2024
Various
Various
680,000.00
691,966.71

0.00 0.00
691,484.18
9,069.02
9,775.00
923.20
1,629.18

0.00 482.53
(
482.53
)
1,146.65
1,146.65
3130A2UW4
FHLB
Note

2.875%
Due
09/13/2024
10/10/2019
10/11/2019
500,000.00
514,158.80

0.00 0.00
513,650.10
3,114.58

0.00 4,312.50
1,197.92

0.00 508.70
(
508.70
)
689.22
689.22
3130A3GE8
FHLB
Note

2.75%
Due
12/13/2024
02/26/2020
02/27/2020
1,850,000.00
1,917,477.16

0.00 0.00
1,915,291.07
23,741.67
25,437.50
2,543.75
4,239.58

0.00 2,186.09
(
2,186.09
)
2,053.49
2,053.49
3130A4CH3
FHLB
Note

2.375%
Due
03/14/2025
03/19/2020
03/20/2020
1,750,000.00
1,806,492.39

0.00 0.00
1,804,825.95
8,889.76

0.00 12,353.30
3,463.54

0.00 1,666.44
(
1,666.44
)
1,797.10
1,797.10
313382AX1
FHLB
Note

2.125%
Due
03/10/2023
03/23/2018
03/26/2018
500,000.00
497,828.91

0.00 0.00
498,059.88
2,390.63

0.00 3,276.04
885.41
230.97

0.00 230.97
1,116.38
1,116.38
313383QR5
FHLB
Note

3.25%
Due
06/09/2023
08/28/2018
08/29/2018
500,000.00
501,781.64

0.00 0.00
501,638.34
7,763.89
8,125.00
993.06
1,354.17

0.00 143.30
(
143.30
)
1,210.87
1,210.87
313383YJ4
FHLB
Note

3.375%
Due
09/08/2023
10/30/2018
10/31/2018
700,000.00
702,438.29

0.00 0.00
702,280.64
5,446.88

0.00 7,415.63
1,968.75

0.00 157.65
(
157.65
)
1,811.10
1,811.10
3133EKWV4
FFCB
Note

1.85%
Due
07/26/2024
08/13/2019
08/14/2019
500,000.00
502,098.90

0.00 0.00
502,018.79
3,211.81

0.00 3,982.64
770.83

0.00 80.11
(

80.11 )
690.72
690.72
3135G03U5
FNMA
Note

0.625%
Due
04/22/2025
04/22/2020
04/24/2020
805,000.00
804,039.93

0.00 0.00
804,067.21
545.05

0.00 964.32
419.27

27.28 0.00

27.28 446.55
446.55
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 21 ends

0.5%
Due
06/17/2025
06/17/2020
06/19/2020
2,020,000.00
2,017,450.81

0.00 0.00
2,017,519.59
4,601.11
5,050.00
392.78
841.67

68.78 0.00

68.78 910.45
910.45
3135G05G4
FNMA
Note

0.25%
Due
07/10/2023
07/08/2020
07/10/2020
1,035,000.00
1,034,178.99

0.00 0.00
1,034,239.96
1,013.44

0.00 1,229.06
215.62

60.97 0.00

60.97 276.59
276.59
3135G05X7
FNMA
Note

0.375%
Due
08/25/2025
08/25/2020
08/27/2020
1,700,000.00
1,694,848.66

0.00 0.00
1,694,979.52
1,700.00

0.00 2,231.25
531.25
130.86

0.00 130.86
662.11
662.11
3135G06G3
FNMA
Note

0.5%
Due
11/07/2025
11/09/2020
11/12/2020
1,680,000.00
1,675,854.99

0.00 0.00
1,675,954.07
560.00

0.00 1,260.00
700.00

99.08 0.00

99.08 799.08
799.08
3135G0T94
FNMA
Note
Due
01/19/2023
Various
Various

0.00 997,593.98

0.00 997,728.80

0.00 8,708.33
9,565.97

0.00 857.64
134.82

0.00 134.82
992.46
992.46
3135G0U43
FNMA
Note

2.875%
Due
09/12/2023
09/12/2018
09/14/2018
645,000.00
644,321.48

0.00 0.00
644,364.97
4,069.32

0.00 5,614.64
1,545.32

43.49 0.00

43.49 1,588.81
1,588.81
3135G0V34
FNMA
Note

2.5%
Due
02/05/2024
02/25/2019
02/26/2019
700,000.00
699,038.01

0.00 0.00
699,085.01
5,638.89

0.00 7,097.22
1,458.33

47.00 0.00

47.00 1,505.33
1,505.33
3135G0W66
FNMA
Note

1.625%
Due
10/15/2024
11/08/2019
11/12/2019
500,000.00
497,999.97

0.00 0.00
498,069.18
1,038.19

0.00 1,715.28
677.09

69.21 0.00

69.21 746.30
746.30
3135G0X24
FNMA
Note

1.625%
Due
01/07/2025
01/08/2020
01/10/2020
1,835,000.00
1,831,948.01

0.00 0.00
1,832,044.29
11,927.50

0.00 14,412.40
2,484.90

96.28 0.00

96.28 2,581.18
2,581.18
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 22 ends

0.00 0.00
842,168.31
2,114.00
2,114.00
2,114.00
2,114.00

0.00 1,537.12
(
1,537.12
)
576.88
576.88
3137EAEN5
FHLMC
Note

2.75%
Due
06/19/2023
07/16/2018
07/17/2018
500,000.00
499,380.13

0.00 0.00
499,428.68
6,187.50
6,875.00
458.33
1,145.83

48.55 0.00

48.55 1,194.38
1,194.38
3137EAEP0
FHLMC
Note

1.5%
Due
02/12/2025
02/13/2020
02/14/2020
2,040,000.00
2,039,150.48

0.00 0.00
2,039,176.30
9,265.00

0.00 11,815.00
2,550.00

25.82 0.00

25.82 2,575.82
2,575.82
3137EAEU9
FHLMC
Note

0.375%
Due
07/21/2025
07/21/2020
07/23/2020
1,075,000.00
1,071,636.45

0.00 0.00
1,071,724.50
1,455.73

0.00 1,791.67
335.94

88.05 0.00

88.05 423.99
423.99
3137EAEX3
FHLMC
Note

0.375%
Due
09/23/2025
09/23/2020
09/25/2020
1,560,000.00
1,556,885.05

0.00 0.00
1,556,962.28
1,105.00

0.00 1,592.50
487.50

77.23 0.00

77.23 564.73
564.73
362554AC1
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
09/16/2026
10/13/2021
10/21/2021
235,000.00
234,995.09

0.00 0.00
234,995.23

66.58 133.17

0.14 0.00

0.14 133.31
133.31
362585AC5
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
02/16/2027
04/05/2022
04/13/2022
300,000.00
299,939.75

0.00 0.00
299,941.26
387.50
775.00
387.50
775.00

1.51 0.00

1.51 776.51
776.51
36265MAC9
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
03/20/2025
02/15/2022
02/23/2022
640,000.00
639,995.18

0.00 0.00
639,995.39
371.56
1,013.33
371.56
1,013.33

0.21 0.00

0.21 1,013.54
1,013.54
36266FAC3
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
06/20/2025
05/03/2022
05/11/2022
390,000.00
389,960.39

0.00 0.00
389,961.91
741.00
1,482.00
407.55
1,148.55

1.52 0.00

1.52 1,150.07
1,150.07
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 23 ends

0.00 0.00
199,984.96
105.00
210.00
105.00
210.00

0.43 0.00

0.43 210.43
210.43
43813KAC6
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
09/22/2020
09/29/2020
413,384.42
444,005.65

0.00 30,651.71
413,357.64

59.33 136.91

55.23 132.81

3.70 0.00

3.70 136.51
136.51
43813RAC1
Honda Auto Receivables
2020-1
A
3 1.61%
Due
04/22/2024
02/19/2020
02/26/2020
207,377.43
228,762.73

0.00 21,405.72
207,359.72
102.32
306.95

92.74 297.37

2.71 0.00

2.71 300.08
300.08
43815BAC4
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
05/15/2026
02/15/2022
02/23/2022
500,000.00
499,931.06

0.00 0.00
499,932.98
417.78
783.33
417.78
783.33

1.92 0.00

1.92 785.25
785.25
43815GAC3
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
01/21/2026
11/16/2021
11/24/2021
310,000.00
309,945.07

0.00 0.00
309,946.73

75.78 227.33

1.66 0.00

1.66 228.99
228.99
44891RAC4
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
05/15/2025
10/20/2020
10/28/2020
490,663.58
499,940.37

0.00 9,336.42
490,607.88

84.44 158.33

82.87 156.76

3.93 0.00

3.93 160.69
160.69
44933LAC7
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
09/15/2025
04/20/2021
04/28/2021
405,000.00
404,972.67

0.00 0.00
404,973.81

68.40 128.25

1.14 0.00

1.14 129.39
129.39
44934KAC8
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
01/15/2026
07/20/2021
07/28/2021
840,000.00
839,864.48

0.00 0.00
839,869.34
141.87
266.00
141.87
266.00

4.86 0.00

4.86 270.86
270.86
44935FAD6
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
05/15/2026
11/09/2021
11/17/2021
220,000.00
219,959.23

0.00 0.00
219,960.51

72.36 135.67

1.28 0.00

1.28 136.95
136.95
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 24 ends

2.301%
Due
10/15/2025
11/13/2020
11/17/2020
1,150,000.00
1,186,649.27

0.00 0.00
1,185,381.13
3,381.19

0.00 5,586.32
2,205.13

0.00 1,268.14
(
1,268.14
)
936.99
936.99
46647PBK1
JP Morgan Chase & Co
Callable Note Cont
4/22/2025

2.083%
Due
04/22/2026
09/16/2021
09/20/2021
500,000.00
512,853.37

0.00 0.00
512,488.22
1,128.29

0.00 1,996.21
867.92

0.00 365.15
(
365.15
)
502.77
502.77
47787JAC2
John Deere Owner Trust
2022
-A A
3 2.32%
Due
09/16/2026
03/10/2022
03/16/2022
305,000.00
304,936.59

0.00 0.00
304,938.17
314.49
589.67
314.49
589.67

1.58 0.00

1.58 591.25
591.25
47787NAC3
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
07/14/2020
07/22/2020
139,926.32
149,577.53

0.00 9,661.83
139,916.88

33.91 63.57

31.72 61.38

1.18 0.00

1.18 62.56

62.56 47788UAC6
John Deere Owner Trust
2021
-A A
3 0.36%
Due
09/15/2025
03/02/2021
03/10/2021
250,000.00
249,968.32

0.00 0.00
249,969.42

40.00 75.00

1.10 0.00

1.10 76.10

76.10 47789KAC7
John Deere Owner Trust
2020
-A A
3 1.1%
Due
08/15/2024
03/04/2020
03/11/2020
247,106.13
268,691.97

0.00 21,594.02
247,098.88
131.36
246.31
120.81
235.76

0.93 0.00

0.93 236.69
236.69
47789QAC4
John Deere Owner Trust
2021
-B A
3 0.52%
Due
03/16/2026
07/13/2021
07/21/2021
390,000.00
389,973.43

0.00 0.00
389,974.21

90.13 169.00

0.78 0.00

0.78 169.78
169.78
58769KAD6
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024
06/22/2021
06/29/2021
460,000.00
459,977.85

0.00 0.00
459,978.98

81.78 153.33

1.13 0.00

1.13 154.46
154.46
61747YEA9
Morgan Stanley
Callable Note Cont
5/30/2024

0.79%
Due
05/30/2025
05/26/2021
06/01/2021
1,240,000.00
1,240,438.67

0.00 0.00
1,240,420.62

27.20 0.00
843.54
816.34

0.00 18.05
(

18.05 )
798.29
798.29
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 25 ends

3.45%
Due
06/15/2025
Various
Various
685,000.00
683,050.53

0.00 0.00
683,103.22
1,772.44

0.00 3,741.81
1,969.37

52.69 0.00

52.69 2,022.06
2,022.06
65479JAD5
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
07/15/2024
10/16/2019
10/23/2019
120,157.96
135,921.45

0.00 15,766.71
120,155.22
116.59
218.61
103.07
205.09

0.48 0.00

0.48 205.57
205.57
69353RFE3
PNC Bank
Callable Note Cont
6/28/2022

Due
07/28/2022
07/02/2019
07/05/2019

0.00 700,156.55

0.00 700,000.00

0.00 5,859.58
7,145.60

0.00 1,286.02

0.00 156.55
(
156.55
)
1,129.47
1,129.47
747525AT0
Qualcomm Inc
Callable Note Cont
3/20/2024

2.9%
Due
05/20/2024
12/05/2019
12/09/2019
1,150,000.00
1,164,577.25

0.00 0.00
1,163,912.63
1,019.03

0.00 3,798.19
2,779.16

0.00 664.62
(
664.62
)
2,114.54
2,114.54
78013XZU5
Royal Bank of Canada
Note

2.55%
Due
07/16/2024
Various
Various
1,150,000.00
1,156,749.19

0.00 0.00
1,156,488.26
10,996.88

0.00 13,440.62
2,443.74

0.00 260.93
(
260.93
)
2,182.81
2,182.81
78015K7H1
Royal Bank of Canada
Note

1.15%
Due
06/10/2025
12/22/2021
12/27/2021
400,000.00
396,705.15

0.00 0.00
396,794.61
2,185.00
2,300.00
268.33
383.33

89.46 0.00

89.46 472.79
472.79
79466LAG9
Salesforce.com Inc
Callable Note Cont
7/15/2022

0.625%
Due
07/15/2024
06/29/2021
07/12/2021
190,000.00
189,931.67

0.00 0.00
189,934.31
448.61

0.00 547.57

98.96 2.64

0.00 2.64
101.60
101.60
808513BY0
Charles Schwab Corp
Callable Note Cont
2/3/2027

2.45%
Due
03/03/2027
Various
Various
1,000,000.00
986,057.74

0.00 0.00
986,298.68
5,988.89

0.00 8,030.56
2,041.67
240.94

0.00 240.94
2,282.61
2,282.61
87612EBM7
Target Corp
Callable Note Cont
12/15/2026

1.95%
Due
01/15/2027
01/19/2022
01/24/2022
545,000.00
544,138.77

0.00 0.00
544,154.07
3,749.15

0.00 4,634.77
885.62

15.30 0.00

15.30 900.92
900.92
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 26 ends

3.25%
Due
03/11/2024
06/05/2020
06/09/2020
1,100,000.00
1,143,354.71

0.00 0.00
1,141,350.64
7,944.44

0.00 10,923.61
2,979.17

0.00 2,004.07
(
2,004.07
)
975.10
975.10
89232HAC9
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
05/15/2024
06/17/2020
06/19/2020
447,000.16
504,620.48

0.00 51,863.63
451,941.63
368.05
690.10
329.79
651.84

0.00 815.22
(
815.22
)
(
163.38
)
(163.38)
89236TJK2
Toyota Motor Credit Corp
Note

1.125%
Due
06/18/2026
06/15/2021
06/18/2021
810,000.00
809,711.52

0.00 0.00
809,717.38
4,125.94
4,556.25
329.06
759.37

5.86 0.00

5.86 765.23
765.23
89237VAB5
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
07/21/2020
07/27/2020
90,616.51
98,411.88

0.00 7,799.63
90,612.72

19.25 36.09

17.72 34.56

0.47 0.00

0.47 35.03

35.03 89238FAD5
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
09/15/2026
04/07/2022
04/13/2022
335,000.00
334,992.48

0.00 0.00
334,992.68
436.24
817.96
436.24
817.96

0.20 0.00

0.20 818.16
818.16
89240BAC2
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
05/15/2025
02/02/2021
02/08/2021
215,000.00
214,976.96

0.00 0.00
214,978.02

24.84 46.58

1.06 0.00

1.06 47.64

47.64 90331HPL1
US Bank NA
Callable Note Cont
12/21/2024

2.05%
Due
01/21/2025
01/16/2020
01/21/2020
1,150,000.00
1,148,706.20

0.00 0.00
1,148,746.42
8,513.19

0.00 10,477.78
1,964.59

40.22 0.00

40.22 2,004.81
2,004.81
9128283J7
US Treasury
Note

2.125%
Due
11/30/2024
Various
Various
2,000,000.00
2,030,229.63

0.00 0.00
2,029,236.32
116.12

0.00 3,599.73
3,483.61

0.00 993.31
(
993.31
)
2,490.30
2,490.30
9128283Z1
US Treasury
Note

2.75%
Due
02/28/2025
03/05/2020
03/06/2020
700,000.00
738,863.24

0.00 0.00
737,700.83
4,864.81

0.00 6,434.10
1,569.29

0.00 1,162.41
(
1,162.41
)
406.88
406.88
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 27 ends

0.00 0.00
1,893,866.11
10,834.25

0.00 13,900.55
3,066.30

0.00 1,370.82
(
1,370.82
)
1,695.48
1,695.48
912828P38
US Treasury
Note
Due
01/31/2023
05/30/2018
05/31/2018

0.00 994,508.08

0.00 994,665.63

0.00 5,849.45
6,187.85

0.00 338.40
157.55

0.00 157.55
495.95
495.95
912828T91
US Treasury
Note
Due
10/31/2023
11/29/2018
11/30/2018

0.00 737,763.06

0.00 738,070.75

0.00 1,059.78
1,490.32

0.00 430.54
307.69

0.00 307.69
738.23
738.23
912828V80
US Treasury
Note

2.25%
Due
01/31/2024
Various
Various
1,450,000.00
1,484,309.43

0.00 0.00
1,482,619.31
10,905.04

0.00 13,608.77
2,703.73

0.00 1,690.12
(
1,690.12
)
1,013.61
1,013.61
912828W48
US Treasury
Note

2.125%
Due
02/29/2024
04/10/2019
04/11/2019
550,000.00
548,548.67

0.00 0.00
548,616.91
2,953.63

0.00 3,906.42
952.79

68.24 0.00

68.24 1,021.03
1,021.03
912828W71
US Treasury
Note

2.125%
Due
03/31/2024
04/23/2019
04/24/2019
500,000.00
497,949.09

0.00 0.00
498,041.06
1,799.86

0.00 2,670.77
870.91

91.97 0.00

91.97 962.88
962.88
912828WJ5
US Treasury
Note

2.5%
Due
05/15/2024
Various
Various
2,000,000.00
2,057,409.58

0.00 0.00
2,054,997.41
2,309.79

0.00 6,385.87
4,076.08

0.00 2,412.17
(
2,412.17
)
1,663.91
1,663.91
912828X70
US Treasury
Note
2%
Due
04/30/2024
Various
Various
2,000,000.00
2,021,279.83

0.00 0.00
2,020,366.54
3,478.26

0.00 6,739.13
3,260.87

30.85 944.14
(
913.29
)
2,347.58
2,347.58
912828YH7
US Treasury
Note

1.5%
Due
09/30/2024
Various
Various
2,000,000.00
2,005,681.53

0.00 0.00
2,005,481.48
5,081.96

0.00 7,540.99
2,459.03
180.14
380.19
(
200.05
)
2,258.98
2,258.98
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 28 ends

1.5%
Due
01/31/2027
03/30/2022
03/31/2022
500,000.00
479,081.00

0.00 0.00
479,449.08
2,506.91

0.00 3,128.45
621.54
368.08

0.00 368.08
989.62
989.62
912828ZC7
US Treasury
Note

1.125%
Due
02/28/2025
Various
Various
1,500,000.00
1,525,409.69

0.00 0.00
1,524,649.68
4,264.60

0.00 5,640.28
1,375.68

0.00 760.01
(
760.01
)
615.67
615.67
91282CAZ4
US Treasury
Note

0.375%
Due
11/30/2025
12/28/2020
12/29/2020
2,000,000.00
1,999,611.07

0.00 0.00
1,999,620.20

20.49 0.00
635.25
614.76

9.13 0.00

9.13 623.89
623.89
91282CBC4
US Treasury
Note

0.375%
Due
12/31/2025
01/27/2021
01/28/2021
2,000,000.00
1,998,634.94

0.00 0.00
1,998,666.23
3,149.17
3,750.00

20.38 621.21

31.29 0.00

31.29 652.50
652.50
91282CBT7
US Treasury
Note

0.75%
Due
03/31/2026
03/30/2021
03/31/2021
1,500,000.00
1,490,797.15

0.00 0.00
1,490,994.50
1,905.74

0.00 2,827.87
922.13
197.35

0.00 197.35
1,119.48
1,119.48
91282CBW0
US Treasury
Note

0.75%
Due
04/30/2026
04/29/2021
04/30/2021
1,000,000.00
994,833.72

0.00 0.00
994,942.18
652.17

0.00 1,263.59
611.42
108.46

0.00 108.46
719.88
719.88
91282CCP4
US Treasury
Note

0.625%
Due
07/31/2026
08/10/2021
08/11/2021
1,000,000.00
992,045.39

0.00 0.00
992,202.28
2,089.09

0.00 2,607.04
517.95
156.89

0.00 156.89
674.84
674.84
91282CCW9
US Treasury
Note

0.75%
Due
08/31/2026
Various
Various
2,250,000.00
2,229,566.62

0.00 0.00
2,229,961.59
4,264.61

0.00 5,640.28
1,375.67
394.97

0.00 394.97
1,770.64
1,770.64
91282CDG3
US Treasury
Note

1.125%
Due
10/31/2026
Various
Various
3,000,000.00
2,981,550.30

0.00 0.00
2,981,893.43
2,934.79

0.00 5,686.15
2,751.36
343.13

0.00 343.13
3,094.49
3,094.49
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 29 ends

2.75%
Due
04/30/2027
Various
Various
2,500,000.00

0.00 2,445,792.97

0.00 2,446,366.00

0.00 (
7,779.21
)
11,582.88
3,803.67
573.03

0.00 573.03
4,376.70
4,376.70
91324PEC2
United Health Group Inc
Callable Note Cont
4/15/2026

1.15%
Due
05/15/2026
Various
Various
1,245,000.00
1,232,815.38

0.00 0.00
1,233,068.24
636.33

0.00 1,829.45
1,193.12
266.34

13.48 252.86
1,445.98
1,445.98
92290BAA9
Verizon Owner Trust
2020
-B A

0.47%
Due
02/20/2025
08/04/2020
08/12/2020
690,000.00
689,912.78

0.00 0.00
689,915.41

99.09 270.25

2.63 0.00

2.63 272.88
272.88
927804GH1
Virginia Electric Power Corp
Callable Note Cont.
4/15/2027

3.75%
Due
05/15/2027
05/16/2022
05/31/2022
250,000.00
249,220.43

0.00 0.00
249,233.36

26.04 0.00
807.29
781.25

12.93 0.00

12.93 794.18
794.18
931142EK5
Wal-Mart Stores
Callable Note Cont
5/26/2023

3.4%
Due
06/26/2023
Various
Various
600,000.00
600,281.24

0.00 0.00
600,257.59
8,783.34
10,200.00
283.33
1,699.99

1.62 25.27
(

23.65 )
1,676.34
1,676.34
931142ER0
Wal-Mart Stores
Callable Note Cont
08/17/2026

1.05%
Due
09/17/2026
09/08/2021
09/17/2021
240,000.00
239,610.24

0.00 0.00
239,617.69
518.00

0.00 728.00
210.00

7.45 0.00

7.45 217.45
217.45
Total Fixed Income
89,041,364.31
90,704,296.94
2,445,792.97
3,616,906.63
89,511,479.00
329,470.83
140,200.66
317,669.92
128,399.75
5,221.93
26,926.21
(
21,704.28
)
106,695.47
106,695.47

CASH & EQUIVALENT
3130AJHU6
FHLB
Note

0.5%
Due
04/14/2025
05/28/2020
05/29/2020
1,900,000.00
1,899,765.22

0.00 0.00
1,899,771.94
1,240.28

0.00 2,031.94
791.66

6.72 0.00

6.72 798.38
798.38
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 30 ends

0.255%
Due
10/14/2022
10/15/2021
10/15/2021
1,000,000.00
1,000,018.70

0.00 0.00
1,000,014.55
1,622.08

0.00 1,834.58
212.50

0.00 4.15
(

4.15 )
208.35
208.35
94975H312
Wells Fargo
Advantage Treasury Plus MMF
Various
Various
2,320,176.09
1,004,425.45
1,315,750.64

0.00 2,320,176.09

0.00 225.41

0.00 0.00

0.00 225.41
225.41
Total Cash & Equivalent
5,220,176.09
3,904,209.37
1,315,750.64

0.00 5,219,962.58
2,862.36
225.41
3,866.52
1,229.57

6.72 4.15

2.57 1,232.14
1,232.14

LOCAL AGENCY INVESTMENT FUND
90LAIF$00
Local Agency Investment Fund
State Pool
Various
Various
73,135,065.63
73,135,065.63

0.00 0.00
73,135,065.63
73,685.89

0.00 125,261.16
51,575.27

0.00 0.00

0.00 51,575.27
51,575.27
Total Local Agency Investment Fund
73,135,065.63
73,135,065.63

0.00 0.00
73,135,065.63
73,685.89

0.00 125,261.16
51,575.27

0.00 0.00

0.00 51,575.27
51,575.27

TOTAL PORTFOLIO
167,396,606.03
167,743,571.94
3,761,543.61
3,616,906.63
167,866,507.21
406,019.08
140,426.07
446,797.60
181,204.59
5,228.65
26,930.36
(
21,701.71
)
159,502.88
159,502.88
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 31 ends

1.625%
Due
1/7/2025

0.00 14,909.38
14,909.38
07/10/2022
Interest
3135G05G4
1,035,000.00
FNMA Note

0.25%
Due
7/10/2023

0.00 1,293.75
1,293.75
07/15/2022
Dividend
90LAIF$00
6,654,427,151.43
Local Agency Investment Fund State Pool

0.00 125,261.13
125,261.13
07/15/2022
Interest
79466LAG9
190,000.00
Salesforce.com Inc Callable Note Cont
7/15/2022

0.625%
Due
7/15/2024

0.00 593.75
593.75
07/15/2022
Interest
87612EBM7
545,000.00
Target Corp Callable Note Cont
12/15/2026

1.95%
Due
1/15/2027

0.00 5,048.06
5,048.06
07/15/2022
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,204.86

46.58 10,251.44
07/15/2022
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
07/15/2022
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,338.62

59.47 7,398.09
07/15/2022
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
07/15/2022
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024

0.00 153.33
153.33
07/15/2022
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
07/15/2022
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
27,787.39
618.35
28,405.74
07/15/2022
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
3,283.31

83.94 3,367.25
07/15/2022
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025

0.00 128.25
128.25
07/15/2022
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026

0.00 266.00
266.00
07/15/2022
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,677.82
193.25
4,871.07
07/15/2022
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
18,888.44
716.67
19,605.11
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 32 ends

0.00 589.67
589.67
07/15/2022
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,181.42
226.51
9,407.93
07/15/2022
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,220.31

33.23 3,253.54
07/15/2022
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
07/15/2022
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
07/15/2022
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,447.83
155.38
24,603.21
07/15/2022
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025

0.00 75.00

75.00 07/16/2022
Interest
78013XZU5
1,150,000.00
Royal Bank of Canada Note

2.55%
Due
7/16/2024

0.00 14,662.50
14,662.50
07/16/2022
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
07/16/2022
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
07/16/2022
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
07/18/2022
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,256.80
127.46
24,384.26
07/20/2022
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
07/20/2022
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,431.88
270.25
21,702.13
07/20/2022
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
07/21/2022
Interest
3137EAEU9
1,075,000.00
FHLMC Note

0.375%
Due
7/21/2025

0.00 2,015.63
2,015.63
07/21/2022
Interest
90331HPL1
1,150,000.00
US Bank NA Callable Note Cont
12/21/2024

2.05%
Due
1/21/2025

0.00 11,787.50
11,787.50
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 33 ends

0.00 FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
07/21/2022
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
07/21/2022
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,884.06
278.23
9,162.29
07/25/2022
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
07/25/2022
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
07/25/2022
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
07/25/2022
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024

0.00 79.75

79.75 07/26/2022
Interest
3133EKWV4
500,000.00
FFCB Note

1.85%
Due
7/26/2024

0.00 4,625.00
4,625.00
07/31/2022
Interest
912828Z78
500,000.00
US Treasury Note

1.5%
Due
1/31/2027

0.00 3,750.00
3,750.00
07/31/2022
Interest
91282CCP4
1,000,000.00
US Treasury Note

0.625%
Due
7/31/2026

0.00 3,125.00
3,125.00
07/31/2022
Interest
912828V80
1,450,000.00
US Treasury Note

2.25%
Due
1/31/2024

0.00 16,312.50
16,312.50
JUL 2022
163,602.74
220,611.77
384,214.51
08/05/2022
Interest
3135G0V34
700,000.00
FNMA Note

2.5%
Due
2/5/2024

0.00 8,750.00
8,750.00
08/12/2022
Interest
3137EAEP0
2,040,000.00
FHLMC Note

1.5%
Due
2/12/2025

0.00 15,300.00
15,300.00
08/15/2022
Interest
912828J27
1,850,000.00
US Treasury Note
2%
Due
2/15/2025

0.00 18,500.00
18,500.00
08/15/2022
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
3,170.26

77.07 3,247.33
08/15/2022
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 34 ends

0.00 153.33
153.33
08/15/2022
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
27,050.25
579.91
27,630.16
08/15/2022
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
08/15/2022
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
08/15/2022
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
08/15/2022
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,456.80
147.63
24,604.43
08/15/2022
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025

0.00 128.25
128.25
08/15/2022
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025

0.00 75.00

75.00 08/15/2022
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
08/15/2022
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
18,915.52
689.59
19,605.11
08/15/2022
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026

0.00 266.00
266.00
08/15/2022
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
08/15/2022
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,688.34
185.73
4,874.07
08/15/2022
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,341.49

56.35 7,397.84
08/15/2022
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,206.66
218.10
9,424.76
08/15/2022
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,221.49

32.05 3,253.54
08/15/2022
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,208.18

44.37 10,252.55
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 35 ends

0.00 210.00
210.00
08/16/2022
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
08/16/2022
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
08/18/2022
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,264.28
119.98
24,384.26
08/20/2022
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
08/20/2022
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
08/20/2022
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,440.27
261.86
21,702.13
08/21/2022
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,895.98
266.31
9,162.29
08/21/2022
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
08/25/2022
Interest
3135G05X7
1,700,000.00
FNMA Note

0.375%
Due
8/25/2025

0.00 3,187.50
3,187.50
08/25/2022
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
08/25/2022
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
08/25/2022
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024

0.00 79.75

79.75 08/25/2022
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
08/31/2022
Interest
912828ZC7
1,500,000.00
US Treasury Note

1.125%
Due
2/28/2025

0.00 8,437.50
8,437.50
08/31/2022
Interest
91282CCW9
2,250,000.00
US Treasury Note

0.75%
Due
8/31/2026

0.00 8,437.50
8,437.50
08/31/2022
Interest
912828W48
550,000.00
US Treasury Note

2.125%
Due
2/29/2024

0.00 5,843.75
5,843.75
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 36 ends

2.75%
Due
2/28/2025

0.00 9,625.00
9,625.00
AUG 2022
162,859.52
93,064.45
255,923.97
09/03/2022
Interest
808513BY0
1,000,000.00
Charles Schwab Corp Callable Note Cont
2/3/2027

2.45%
Due
3/3/2027

0.00 12,250.00
12,250.00
09/05/2022
Interest
06051GHF9
1,150,000.00
Bank of America Corp Callable Note
1 X
3/5/2023

3.55%
Due
3/5/2024

0.00 20,412.50
20,412.50
09/08/2022
Interest
313383YJ4
700,000.00
FHLB Note

3.375%
Due
9/8/2023

0.00 11,812.50
11,812.50
09/10/2022
Interest
313382AX1
500,000.00
FHLB Note

2.125%
Due
3/10/2023

0.00 5,312.50
5,312.50
09/11/2022
Interest
89114QCB2
1,100,000.00
Toronto Dominion Bank Note

3.25%
Due
3/11/2024

0.00 17,875.00
17,875.00
09/12/2022
Interest
3135G0U43
645,000.00
FNMA Note

2.875%
Due
9/12/2023

0.00 9,271.88
9,271.88
09/12/2022
Maturity
037833DC1
625,000.00
Apple Inc Callable Note Cont
8/12/2022

2.1%
Due
9/12/2022
625,000.00
6,562.50
631,562.50
09/13/2022
Interest
3130A2UW4
500,000.00
FHLB Note

2.875%
Due
9/13/2024

0.00 7,187.50
7,187.50
09/14/2022
Interest
3130A4CH3
1,750,000.00
FHLB Note

2.375%
Due
3/14/2025

0.00 20,781.25
20,781.25
09/15/2022
Interest
00440EAS6
1,150,000.00
Chubb INA Holdings Inc Note

3.15%
Due
3/15/2025

0.00 18,112.50
18,112.50
09/15/2022
Interest
084664CZ2
1,095,000.00
Berkshire Hathaway Callable Note Cont
2/15/2027

2.3%
Due
3/15/2027

0.00 12,592.50
12,592.50
09/15/2022
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025

0.00 128.25
128.25
09/15/2022
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026

0.00 266.00
266.00
09/15/2022
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,344.37

53.23 7,397.60
09/15/2022
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 37 ends

42.16 10,253.66
09/15/2022
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
3,056.76

70.44 3,127.20
09/15/2022
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
09/15/2022
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024

0.00 153.33
153.33
09/15/2022
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
26,310.01
542.49
26,852.50
09/15/2022
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
18,942.63
662.48
19,605.11
09/15/2022
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
09/15/2022
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025

0.00 75.00

75.00 09/15/2022
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
09/15/2022
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
09/15/2022
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,465.76
139.89
24,605.65
09/15/2022
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,231.98
209.66
9,441.64
09/15/2022
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,222.68

30.86 3,253.54
09/15/2022
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
09/16/2022
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
09/16/2022
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 38 ends

0.00 775.00
775.00
09/17/2022
Interest
931142ER0
240,000.00
Wal-Mart Stores Callable Note Cont
08/17/2026

1.05%
Due
9/17/2026

0.00 1,260.00
1,260.00
09/18/2022
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,271.76
112.50
24,384.26
09/20/2022
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
09/20/2022
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,448.67
253.46
21,702.13
09/20/2022
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
09/21/2022
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
09/21/2022
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,907.91
254.38
9,162.29
09/23/2022
Interest
3137EAEX3
1,560,000.00
FHLMC Note

0.375%
Due
9/23/2025

0.00 2,925.00
2,925.00
09/25/2022
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
09/25/2022
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
09/25/2022
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
09/25/2022
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024

0.00 79.75

79.75 09/30/2022
Interest
912828W71
500,000.00
US Treasury Note

2.125%
Due
3/31/2024

0.00 5,312.50
5,312.50
09/30/2022
Interest
912828YH7
2,000,000.00
US Treasury Note

1.5%
Due
9/30/2024

0.00 15,000.00
15,000.00
09/30/2022
Interest
91282CBT7
1,500,000.00
US Treasury Note

0.75%
Due
3/31/2026

0.00 5,625.00
5,625.00
SEP 2022
787,112.92
187,147.12
974,260.04
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 39 ends

3.3%
Due
4/13/2027

0.00 12,375.00
12,375.00
10/14/2022
Interest
3130AJHU6
1,900,000.00
FHLB Note

0.5%
Due
4/14/2025

0.00 4,750.00
4,750.00
10/14/2022
Maturity
86959RTW0
1,000,000.00
Svenska Handelsbanken NY Yankee CD

0.255%
Due
10/14/2022
1,000,000.00
2,578.33
1,002,578.33
10/15/2022
Interest
46647PBF2
1,150,000.00
JP Morgan Chase & Co Callable Note
1 X
10/15/2024

2.301%
Due
10/15/2025

0.00 13,230.75
13,230.75
10/15/2022
Interest
3135G0W66
500,000.00
FNMA Note

1.625%
Due
10/15/2024

0.00 4,062.50
4,062.50
10/15/2022
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026

0.00 266.00
266.00
10/15/2022
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
10/15/2022
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,347.24

50.11 7,397.35
10/15/2022
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,257.37
201.20
9,458.57
10/15/2022
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
10/15/2022
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,709.46
170.63
4,880.09
10/15/2022
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,223.86

29.68 3,253.54
10/15/2022
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,214.81

39.95 10,254.76
10/15/2022
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
18,969.78
635.33
19,605.11
10/15/2022
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025

0.00 75.00

75.00 10/15/2022
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024

0.00 153.33
153.33
10/15/2022
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 40 ends

0.00 135.67
135.67
10/15/2022
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,942.81

64.05 3,006.86
10/15/2022
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
10/15/2022
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,474.74
132.14
24,606.88
10/15/2022
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025

0.00 128.25
128.25
10/15/2022
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
25,566.63
506.10
26,072.73
10/15/2022
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
10/16/2022
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
10/16/2022
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
10/16/2022
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
10/18/2022
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,279.24
105.02
24,384.26
10/20/2022
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
10/20/2022
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
10/20/2022
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,457.07
245.06
21,702.13
10/21/2022
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
10/21/2022
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,919.86
242.43
9,162.29
10/22/2022
Interest
46647PBK1
500,000.00
JP Morgan Chase & Co Callable Note Cont
4/22/2025

2.083%
Due
4/22/2026

0.00 5,207.50
5,207.50
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 41 ends

0.625%
Due
4/22/2025

0.00 2,515.63
2,515.63
10/25/2022
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
10/25/2022
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024

0.00 79.75

79.75 10/25/2022
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
10/25/2022
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
10/31/2022
Interest
91282CBW0
1,000,000.00
US Treasury Note

0.75%
Due
4/30/2026

0.00 3,750.00
3,750.00
10/31/2022
Interest
912828X70
2,000,000.00
US Treasury Note
2%
Due
4/30/2024

0.00 20,000.00
20,000.00
10/31/2022
Interest
91282CDG3
3,000,000.00
US Treasury Note

1.125%
Due
10/31/2026

0.00 16,875.00
16,875.00
OCT 2022
1,161,362.87
100,070.66
1,261,433.53
11/01/2022
Interest
06367WB85
1,150,000.00
Bank of Montreal Note

1.85%
Due
5/1/2025

0.00 10,637.50
10,637.50
11/07/2022
Interest
3135G06G3
1,680,000.00
FNMA Note

0.5%
Due
11/7/2025

0.00 4,200.00
4,200.00
11/08/2022
Interest
14913Q3B3
650,000.00
Caterpillar Finl Service Note

2.15%
Due
11/8/2024

0.00 6,987.50
6,987.50
11/12/2022
Interest
023135BW5
755,000.00
Amazon.com Inc Note

0.45%
Due
5/12/2024

0.00 1,698.75
1,698.75
11/13/2022
Interest
14913R2V8
445,000.00
Caterpillar Financial Service Note

3.4%
Due
5/13/2025

0.00 7,565.00
7,565.00
11/15/2022
Interest
912828WJ5
2,000,000.00
US Treasury Note

2.5%
Due
5/15/2024

0.00 25,000.00
25,000.00
11/15/2022
Interest
91324PEC2
1,245,000.00
United Health Group Inc Callable Note Cont
4/15/2026

1.15%
Due
5/15/2026

0.00 7,158.75
7,158.75
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 42 ends

3.75%
Due
5/15/2027

0.00 4,296.88
4,296.88
11/15/2022
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
11/15/2022
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
11/15/2022
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,350.12

46.99 7,397.11
11/15/2022
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,377.79

75.00 10,452.79
11/15/2022
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
11/15/2022
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024

0.00 153.33
153.33
11/15/2022
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,218.14

37.73 10,255.87
11/15/2022
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
11/15/2022
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,483.71
124.39
24,608.10
11/15/2022
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
18,996.97
608.14
19,605.11
11/15/2022
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
11/15/2022
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,282.83
192.71
9,475.54
11/15/2022
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,225.04

28.50 3,253.54
11/15/2022
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
11/15/2022
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,828.41

57.89 2,886.30
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 43 ends

0.00 266.00
266.00
11/15/2022
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,720.05
163.06
4,883.11
11/15/2022
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
24,820.13
470.73
25,290.86
11/16/2022
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
11/16/2022
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
11/16/2022
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
11/18/2022
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,286.73

97.53 24,384.26
11/20/2022
Interest
747525AT0
1,150,000.00
Qualcomm Inc Callable Note Cont
3/20/2024

2.9%
Due
5/20/2024

0.00 16,675.00
16,675.00
11/20/2022
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,465.48
236.65
21,702.13
11/20/2022
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
11/20/2022
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
11/21/2022
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,931.83
230.46
9,162.29
11/21/2022
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
11/25/2022
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
11/25/2022
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
11/25/2022
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024

0.00 79.75

79.75 Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 44 ends

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
11/30/2022
Interest
61747YEA9
1,240,000.00
Morgan Stanley Callable Note Cont
5/30/2024

0.79%
Due
5/30/2025

0.00 4,898.00
4,898.00
11/30/2022
Interest
91282CAZ4
2,000,000.00
US Treasury Note

0.375%
Due
11/30/2025

0.00 3,750.00
3,750.00
11/30/2022
Interest
9128283J7
2,000,000.00
US Treasury Note

2.125%
Due
11/30/2024

0.00 21,250.00
21,250.00
NOV 2022
192,240.74
128,716.41
320,957.15
12/08/2022
Interest
3130A0F70
900,000.00
FHLB Note

3.375%
Due
12/8/2023

0.00 15,187.50
15,187.50
12/09/2022
Interest
313383QR5
500,000.00
FHLB Note

3.25%
Due
6/9/2023

0.00 8,125.00
8,125.00
12/10/2022
Interest
78015K7H1
400,000.00
Royal Bank of Canada Note

1.15%
Due
6/10/2025

0.00 2,300.00
2,300.00
12/13/2022
Interest
3130A3GE8
1,850,000.00
FHLB Note

2.75%
Due
12/13/2024

0.00 25,437.50
25,437.50
12/14/2022
Interest
3130A1XJ2
680,000.00
FHLB Note

2.875%
Due
6/14/2024

0.00 9,775.00
9,775.00
12/15/2022
Interest
63743HFE7
685,000.00
National Rural Utilities Note

3.45%
Due
6/15/2025

0.00 14,507.73
14,507.73
12/15/2022
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
24,070.49
436.39
24,506.88
12/15/2022
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
12/15/2022
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
12/15/2022
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
12/15/2022
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,492.68
116.64
24,609.32
12/15/2022
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,260.42
121.52
21,381.94
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 45 ends

71.89 10,453.05
12/15/2022
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,353.00

43.86 7,396.86
12/15/2022
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,308.36
184.20
9,492.56
12/15/2022
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
12/15/2022
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,226.22

27.32 3,253.54
12/15/2022
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,221.46

35.52 10,256.98
12/15/2022
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,713.55

51.98 2,765.53
12/15/2022
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
12/15/2022
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024

0.00 153.33
153.33
12/15/2022
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,024.20
580.91
19,605.11
12/15/2022
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026

0.00 266.00
266.00
12/15/2022
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
12/15/2022
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,730.67
155.47
4,886.14
12/16/2022
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
12/16/2022
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
12/16/2022
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
12/17/2022
Interest
3135G04Z3
2,020,000.00
FNMA Note

0.5%
Due
6/17/2025

0.00 5,050.00
5,050.00
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 46 ends

1.125%
Due
6/18/2026

0.00 4,556.25
4,556.25
12/18/2022
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,294.22

90.04 24,384.26
12/19/2022
Interest
06051GJD2
500,000.00
Bank of America Corp Callable Note Cont
6/19/2025

1.319%
Due
6/19/2026

0.00 3,297.50
3,297.50
12/19/2022
Interest
3137EAEN5
500,000.00
FHLMC Note

2.75%
Due
6/19/2023

0.00 6,875.00
6,875.00
12/20/2022
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
12/20/2022
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,473.88
228.25
21,702.13
12/20/2022
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
12/21/2022
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,943.82
218.47
9,162.29
12/21/2022
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
12/25/2022
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
12/25/2022
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
12/25/2022
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
12/25/2022
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024

0.00 79.75

79.75 12/26/2022
Interest
931142EK5
600,000.00
Wal-Mart Stores Callable Note Cont
5/26/2023

3.4%
Due
6/26/2023

0.00 10,200.00
10,200.00
12/27/2022
Interest
02665WCZ2
1,150,000.00
American Honda Finance Note

2.4%
Due
6/27/2024

0.00 13,800.00
13,800.00
12/31/2022
Interest
91282CBC4
2,000,000.00
US Treasury Note

0.375%
Due
12/31/2025

0.00 3,750.00
3,750.00
DEC 2022
191,494.13
137,324.94
328,819.07
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 47 ends

1.625%
Due
1/7/2025

0.00 14,909.38
14,909.38
01/10/2023
Interest
3135G05G4
1,035,000.00
FNMA Note

0.25%
Due
7/10/2023

0.00 1,293.75
1,293.75
01/15/2023
Interest
87612EBM7
545,000.00
Target Corp Callable Note Cont
12/15/2026

1.95%
Due
1/15/2027

0.00 5,313.75
5,313.75
01/15/2023
Interest
79466LAG9
190,000.00
Salesforce.com Inc Callable Note Cont
7/15/2022

0.625%
Due
7/15/2024

0.00 593.75
593.75
01/15/2023
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,227.41

26.13 3,253.54
01/15/2023
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,051.47
553.64
19,605.11
01/15/2023
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,598.24

46.30 2,644.54
01/15/2023
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
01/15/2023
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
01/15/2023
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,333.95
175.67
9,509.62
01/15/2023
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
01/15/2023
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026

0.00 266.00
266.00
01/15/2023
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
01/15/2023
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,355.88

40.74 7,396.62
01/15/2023
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,384.54

68.77 10,453.31
01/15/2023
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
01/15/2023
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,501.67
108.88
24,610.55
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 48 ends

Cash Flow Report
As of June 30, 2022
City of Vallejo Consolidated
Account #262
Payment Date
Transaction Type
CUSIP
Quantity
Security Description
Principal Amount
Income
Total Amount
01/15/2023
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,267.32
114.79
21,382.11
01/15/2023
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,741.32
147.86
4,889.18
01/15/2023
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
23,317.67
403.10
23,720.77
01/15/2023
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024
35,365.16
153.33
35,518.49
01/15/2023
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
01/15/2023
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,224.77

33.31 10,258.08
01/16/2023
Interest
78013XZU5
1,150,000.00
Royal Bank of Canada Note

2.55%
Due
7/16/2024

0.00 14,662.50
14,662.50
01/16/2023
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
01/16/2023
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
01/16/2023
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
01/18/2023
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,301.71

82.55 24,384.26
01/20/2023
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
01/20/2023
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,482.29
219.84
21,702.13
01/20/2023
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
01/21/2023
Interest
3137EAEU9
1,075,000.00
FHLMC Note

0.375%
Due
7/21/2025

0.00 2,015.63
2,015.63
01/21/2023
Interest
90331HPL1
1,150,000.00
US Bank NA Callable Note Cont
12/21/2024

2.05%
Due
1/21/2025

0.00 11,787.50
11,787.50
01/21/2023
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,955.82
206.47
9,162.29
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 49 ends

0.00 227.33
227.33
01/25/2023
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
01/25/2023
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
01/25/2023
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
01/25/2023
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
24,134.56

79.75 24,214.31
01/26/2023
Interest
3133EKWV4
500,000.00
FFCB Note

1.85%
Due
7/26/2024

0.00 4,625.00
4,625.00
01/31/2023
Interest
912828Z78
500,000.00
US Treasury Note

1.5%
Due
1/31/2027

0.00 3,750.00
3,750.00
01/31/2023
Interest
91282CCP4
1,000,000.00
US Treasury Note

0.625%
Due
7/31/2026

0.00 3,125.00
3,125.00
01/31/2023
Interest
912828V80
1,450,000.00
US Treasury Note

2.25%
Due
1/31/2024

0.00 16,312.50
16,312.50
JAN 2023
250,243.78
92,717.81
342,961.59
02/05/2023
Interest
3135G0V34
700,000.00
FNMA Note

2.5%
Due
2/5/2024

0.00 8,750.00
8,750.00
02/12/2023
Interest
3137EAEP0
2,040,000.00
FHLMC Note

1.5%
Due
2/12/2025

0.00 15,300.00
15,300.00
02/15/2023
Interest
912828J27
1,850,000.00
US Treasury Note
2%
Due
2/15/2025

0.00 18,500.00
18,500.00
02/15/2023
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,510.65
101.12
24,611.77
02/15/2023
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026
41,963.44
266.00
42,229.44
02/15/2023
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,387.91

65.66 10,453.57
02/15/2023
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,078.77
526.34
19,605.11
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 50 ends

40.87 2,523.33
02/15/2023
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
02/15/2023
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
22,561.69
370.84
22,932.53
02/15/2023
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
02/15/2023
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
02/15/2023
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,358.76

37.61 7,396.37
02/15/2023
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,359.62
167.11
9,526.73
02/15/2023
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
02/15/2023
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024
35,368.40
141.54
35,509.94
02/15/2023
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,228.59

24.95 3,253.54
02/15/2023
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
02/15/2023
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,228.10

31.09 10,259.19
02/15/2023
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,274.24
108.05
21,382.29
02/15/2023
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
02/15/2023
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,751.99
140.23
4,892.22
02/16/2023
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
02/16/2023
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 51 ends

0.00 210.00
210.00
02/18/2023
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,309.20

75.06 24,384.26
02/20/2023
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
02/20/2023
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
02/20/2023
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,490.71
211.42
21,702.13
02/21/2023
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,967.83
194.46
9,162.29
02/21/2023
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
02/25/2023
Interest
3135G05X7
1,700,000.00
FNMA Note

0.375%
Due
8/25/2025

0.00 3,187.50
3,187.50
02/25/2023
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
24,140.40

73.11 24,213.51
02/25/2023
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
02/25/2023
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
02/25/2023
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
02/28/2023
Interest
912828W48
550,000.00
US Treasury Note

2.125%
Due
2/29/2024

0.00 5,843.75
5,843.75
02/28/2023
Interest
91282CCW9
2,250,000.00
US Treasury Note

0.75%
Due
8/31/2026

0.00 8,437.50
8,437.50
02/28/2023
Interest
9128283Z1
700,000.00
US Treasury Note

2.75%
Due
2/28/2025

0.00 9,625.00
9,625.00
02/28/2023
Interest
912828ZC7
1,500,000.00
US Treasury Note

1.125%
Due
2/28/2025

0.00 8,437.50
8,437.50
FEB 2023
291,462.76
92,258.63
383,721.39
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 52 ends

2.45%
Due
3/3/2027

0.00 12,250.00
12,250.00
03/05/2023
Call
06051GHF9
1,150,000.00
Bank of America Corp Callable Note
1 X
3/5/2023

3.55%
Due
3/5/2024
1,150,000.00
20,412.50
1,170,412.50
03/08/2023
Interest
313383YJ4
700,000.00
FHLB Note

3.375%
Due
9/8/2023

0.00 11,812.50
11,812.50
03/10/2023
Maturity
313382AX1
500,000.00
FHLB Note

2.125%
Due
3/10/2023
500,000.00
5,312.50
505,312.50
03/11/2023
Interest
89114QCB2
1,100,000.00
Toronto Dominion Bank Note

3.25%
Due
3/11/2024

0.00 17,875.00
17,875.00
03/12/2023
Interest
3135G0U43
645,000.00
FNMA Note

2.875%
Due
9/12/2023

0.00 9,271.88
9,271.88
03/13/2023
Interest
3130A2UW4
500,000.00
FHLB Note

2.875%
Due
9/13/2024

0.00 7,187.50
7,187.50
03/14/2023
Interest
3130A4CH3
1,750,000.00
FHLB Note

2.375%
Due
3/14/2025

0.00 20,781.25
20,781.25
03/15/2023
Interest
084664CZ2
1,095,000.00
Berkshire Hathaway Callable Note Cont
2/15/2027

2.3%
Due
3/15/2027

0.00 12,592.50
12,592.50
03/15/2023
Interest
00440EAS6
1,150,000.00
Chubb INA Holdings Inc Note

3.15%
Due
3/15/2025

0.00 18,112.50
18,112.50
03/15/2023
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
03/15/2023
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,519.64

93.36 24,613.00
03/15/2023
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,281.15
101.32
21,382.47
03/15/2023
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,361.65

34.48 7,396.13
03/15/2023
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,391.29

62.54 10,453.83
03/15/2023
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
03/15/2023
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,762.68
132.59
4,895.27
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 53 ends

0.00 817.96
817.96
03/15/2023
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,231.43

28.87 10,260.30
03/15/2023
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024
35,371.64
129.76
35,501.40
03/15/2023
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
21,802.53
339.63
22,142.16
03/15/2023
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,106.12
498.99
19,605.11
03/15/2023
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
03/15/2023
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
03/15/2023
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,366.23

35.68 2,401.91
03/15/2023
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
03/15/2023
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026
41,967.28
252.71
42,219.99
03/15/2023
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,385.36
158.53
9,543.89
03/15/2023
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,229.77

23.77 3,253.54
03/16/2023
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
03/16/2023
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
03/16/2023
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
03/17/2023
Interest
931142ER0
240,000.00
Wal-Mart Stores Callable Note Cont
08/17/2026

1.05%
Due
9/17/2026

0.00 1,260.00
1,260.00
03/18/2023
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,316.70

67.56 24,384.26
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 54 ends

0.00 1,013.33
1,013.33
03/20/2023
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,499.13
203.00
21,702.13
03/20/2023
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
03/21/2023
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
03/21/2023
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,979.86
182.43
9,162.29
03/23/2023
Interest
3137EAEX3
1,560,000.00
FHLMC Note

0.375%
Due
9/23/2025

0.00 2,925.00
2,925.00
03/25/2023
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
03/25/2023
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
03/25/2023
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
03/25/2023
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
24,146.23

66.47 24,212.70
03/31/2023
Interest
91282CBT7
1,500,000.00
US Treasury Note

0.75%
Due
3/31/2026

0.00 5,625.00
5,625.00
03/31/2023
Interest
912828W71
500,000.00
US Treasury Note

2.125%
Due
3/31/2024

0.00 5,312.50
5,312.50
03/31/2023
Interest
912828YH7
2,000,000.00
US Treasury Note

1.5%
Due
9/30/2024

0.00 15,000.00
15,000.00
MAR 2023
1,940,718.69
179,744.24
2,120,462.93
04/13/2023
Interest
023135CF1
750,000.00
Amazon.com Inc Callable Note Cont
03/13/2027

3.3%
Due
4/13/2027

0.00 12,375.00
12,375.00
04/14/2023
Interest
3130AJHU6
1,900,000.00
FHLB Note

0.5%
Due
4/14/2025

0.00 4,750.00
4,750.00
04/15/2023
Interest
3135G0W66
500,000.00
FNMA Note

1.625%
Due
10/15/2024

0.00 4,062.50
4,062.50
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 55 ends

2.301%
Due
10/15/2025

0.00 13,230.75
13,230.75
04/15/2023
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
04/15/2023
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,394.67

59.42 10,454.09
04/15/2023
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,133.51
471.60
19,605.11
04/15/2023
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,249.53

30.73 2,280.26
04/15/2023
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,528.63

85.60 24,614.23
04/15/2023
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026
41,971.13
239.42
42,210.55
04/15/2023
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,411.17
149.93
9,561.10
04/15/2023
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
04/15/2023
Paydown
58769KAD6
460,000.00
Mercedes-Benz Auto Lease Trust
2021
-B A
3 0.4%
Due
11/15/2024
35,374.89
117.96
35,492.85
04/15/2023
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
21,040.18
309.47
21,349.65
04/15/2023
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
04/15/2023
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,288.06

94.58 21,382.64
04/15/2023
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
04/15/2023
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,364.53

31.35 7,395.88
04/15/2023
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026

0.00 169.00
169.00
04/15/2023
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,773.39
124.93
4,898.32
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 56 ends

22.58 3,253.54
04/15/2023
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
04/15/2023
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,234.75

26.66 10,261.41
04/16/2023
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
04/16/2023
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
04/16/2023
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
04/18/2023
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,324.20

60.06 24,384.26
04/20/2023
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
04/20/2023
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
04/20/2023
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,507.55
194.58
21,702.13
04/21/2023
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
8,991.91
170.38
9,162.29
04/21/2023
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026

0.00 227.33
227.33
04/22/2023
Interest
3135G03U5
805,000.00
FNMA Note

0.625%
Due
4/22/2025

0.00 2,515.63
2,515.63
04/22/2023
Interest
46647PBK1
500,000.00
JP Morgan Chase & Co Callable Note Cont
4/22/2025

2.083%
Due
4/22/2026

0.00 5,207.50
5,207.50
04/25/2023
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025

0.00 279.58
279.58
04/25/2023
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
04/25/2023
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 57 ends

59.83 24,211.90
04/30/2023
Interest
91282CEN7
2,500,000.00
US Treasury Note

2.75%
Due
4/30/2027

0.00 68,750.00
68,750.00
04/30/2023
Interest
91282CDG3
3,000,000.00
US Treasury Note

1.125%
Due
10/31/2026

0.00 16,875.00
16,875.00
04/30/2023
Interest
912828X70
2,000,000.00
US Treasury Note
2%
Due
4/30/2024

0.00 20,000.00
20,000.00
04/30/2023
Interest
91282CBW0
1,000,000.00
US Treasury Note

0.75%
Due
4/30/2026

0.00 3,750.00
3,750.00
APR 2023
289,971.13
165,367.38
455,338.51
05/01/2023
Interest
06367WB85
1,150,000.00
Bank of Montreal Note

1.85%
Due
5/1/2025

0.00 10,637.50
10,637.50
05/07/2023
Interest
3135G06G3
1,680,000.00
FNMA Note

0.5%
Due
11/7/2025

0.00 4,200.00
4,200.00
05/08/2023
Interest
14913Q3B3
650,000.00
Caterpillar Finl Service Note

2.15%
Due
11/8/2024

0.00 6,987.50
6,987.50
05/12/2023
Interest
023135BW5
755,000.00
Amazon.com Inc Note

0.45%
Due
5/12/2024

0.00 1,698.75
1,698.75
05/13/2023
Interest
14913R2V8
445,000.00
Caterpillar Financial Service Note

3.4%
Due
5/13/2025

0.00 7,565.00
7,565.00
05/15/2023
Interest
91324PEC2
1,245,000.00
United Health Group Inc Callable Note Cont
4/15/2026

1.15%
Due
5/15/2026

0.00 7,158.75
7,158.75
05/15/2023
Interest
927804GH1
250,000.00
Virginia Electric Power Corp Callable Note Cont.
4/15/2027

3.75%
Due
5/15/2027

0.00 4,687.50
4,687.50
05/15/2023
Interest
912828WJ5
2,000,000.00
US Treasury Note

2.5%
Due
5/15/2024

0.00 25,000.00
25,000.00
05/15/2023
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,398.05

56.30 10,454.35
05/15/2023
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026
16,939.43
169.00
17,108.43
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 58 ends

0.00 817.96
817.96
05/15/2023
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,238.08

24.44 10,262.52
05/15/2023
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,160.93
444.18
19,605.11
05/15/2023
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,132.38

26.02 2,158.40
05/15/2023
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026

0.00 135.67
135.67
05/15/2023
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
05/15/2023
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,437.05
141.30
9,578.35
05/15/2023
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,232.14

21.40 3,253.54
05/15/2023
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
05/15/2023
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026
41,974.98
226.13
42,201.11
05/15/2023
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,537.62

77.83 24,615.45
05/15/2023
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,294.98

87.84 21,382.82
05/15/2023
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,784.14
117.25
4,901.39
05/15/2023
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
20,274.62
280.36
20,554.98
05/15/2023
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
05/15/2023
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,367.42

28.22 7,395.64
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 59 ends

0.00 133.17
133.17
05/16/2023
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
05/16/2023
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
05/18/2023
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,331.70

52.56 24,384.26
05/20/2023
Interest
747525AT0
1,150,000.00
Qualcomm Inc Callable Note Cont
3/20/2024

2.9%
Due
5/20/2024

0.00 16,675.00
16,675.00
05/20/2023
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
05/20/2023
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
05/20/2023
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,515.97
186.16
21,702.13
05/21/2023
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026
14,056.42
227.33
14,283.75
05/21/2023
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
9,003.98
158.31
9,162.29
05/25/2023
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025
27,585.46
279.58
27,865.04
05/25/2023
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
24,157.90

53.19 24,211.09
05/25/2023
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
05/25/2023
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
05/26/2023
Call
931142EK5
220,000.00
Wal-Mart Stores Callable Note Cont
5/26/2023

3.4%
Due
6/26/2023
220,000.00
3,116.67
223,116.67
05/30/2023
Interest
61747YEA9
1,240,000.00
Morgan Stanley Callable Note Cont
5/30/2024

0.79%
Due
5/30/2025

0.00 4,898.00
4,898.00
05/31/2023
Interest
91282CAZ4
2,000,000.00
US Treasury Note

0.375%
Due
11/30/2025

0.00 3,750.00
3,750.00
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 60 ends

2.125%
Due
11/30/2024

0.00 21,250.00
21,250.00
MAY 2023
567,801.38
131,314.25
699,115.63
06/08/2023
Interest
3130A0F70
900,000.00
FHLB Note

3.375%
Due
12/8/2023

0.00 15,187.50
15,187.50
06/09/2023
Maturity
313383QR5
500,000.00
FHLB Note

3.25%
Due
6/9/2023
500,000.00
8,125.00
508,125.00
06/10/2023
Interest
78015K7H1
400,000.00
Royal Bank of Canada Note

1.15%
Due
6/10/2025

0.00 2,300.00
2,300.00
06/13/2023
Interest
3130A3GE8
1,850,000.00
FHLB Note

2.75%
Due
12/13/2024

0.00 25,437.50
25,437.50
06/14/2023
Interest
3130A1XJ2
680,000.00
FHLB Note

2.875%
Due
6/14/2024

0.00 9,775.00
9,775.00
06/15/2023
Interest
63743HFE7
685,000.00
National Rural Utilities Note

3.45%
Due
6/15/2025

0.00 11,816.25
11,816.25
06/15/2023
Paydown
89232HAC9
447,000.16
Toyota Auto Receivable Own
2020
-A A
3 1.66%
Due
5/15/2024
19,505.84
252.32
19,758.16
06/15/2023
Paydown
14041NFU0
500,000.00
Capital One Execution Trust
2019
-A
2 A
2 1.72%
Due
8/15/2024
19,188.39
416.72
19,605.11
06/15/2023
Paydown
14042WAC4
40,131.80
Capital One Prime Auto Trust
2019-1
A
3 2.51%
Due
11/15/2023
2,014.76

21.56 2,036.32
06/15/2023
Paydown
47787JAC2
305,000.00
John Deere Owner Trust
2022
-A A
3 2.32%
Due
9/16/2026

0.00 589.67
589.67
06/15/2023
Paydown
47789KAC7
247,106.13
John Deere Owner Trust
2020
-A A
3 1.1%
Due
8/15/2024
9,463.01
132.65
9,595.66
06/15/2023
Paydown
02582JJT8
840,000.00
American Express Credit Trust
2022-2
A

3.39%
Due
5/17/2027

0.00 2,373.00
2,373.00
06/15/2023
Paydown
43815BAC4
500,000.00
Honda Auto Receivables Trust
2022-1
A
3 1.88%
Due
5/15/2026

0.00 783.33
783.33
06/15/2023
Paydown
47787NAC3
139,926.32
John Deere Owner Trust
2020
-B A
3 0.51%
Due
11/15/2024
7,370.30

25.09 7,395.39
06/15/2023
Paydown
47789QAC4
390,000.00
John Deere Owner Trust
2021
-B A
3 0.52%
Due
3/16/2026
16,940.98
161.66
17,102.64
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 61 ends

94.38 35,475.75
06/15/2023
Paydown
89237VAB5
90,616.51
Toyota Auto Receivables Trust
2020
-C A
3 0.44%
Due
10/15/2024
3,233.33

20.21 3,253.54
06/15/2023
Paydown
89238FAD5
335,000.00
Toyota Auto Receivables OT
2022
-B A
3 2.93%
Due
9/15/2026

0.00 817.96
817.96
06/15/2023
Paydown
89240BAC2
215,000.00
Toyota Auto Receivables Owners
2021
-A A
3 0.26%
Due
5/15/2025
10,241.40

22.22 10,263.62
06/15/2023
Paydown
44891RAC4
490,663.58
Hyundai Auto Receivables Trust
2020
-C A
3 0.38%
Due
5/15/2025
24,546.62

70.06 24,616.68
06/15/2023
Paydown
44934KAC8
840,000.00
Hyundai Auto Receivables Trust
2021
-B A
3 0.38%
Due
1/15/2026
41,978.82
212.84
42,191.66
06/15/2023
Paydown
47788UAC6
250,000.00
John Deere Owner Trust
2021
-A A
3 0.36%
Due
9/15/2025
10,401.41

53.19 10,454.60
06/15/2023
Paydown
44933LAC7
405,000.00
Hyundai Auto Receivables Trust
2021
-A A
3 0.38%
Due
9/15/2025
21,301.91

81.09 21,383.00
06/15/2023
Paydown
44935FAD6
220,000.00
Hyundai Auto Receivables Trust
2021
-C A
3 0.74%
Due
5/15/2026
10,982.59
135.67
11,118.26
06/15/2023
Paydown
65479JAD5
120,157.96
Nissan Auto Receivables Owner
2019
-C A
3 1.93%
Due
7/15/2024
4,794.90
109.56
4,904.46
06/16/2023
Paydown
362554AC1
235,000.00
GM Financial Securitized Term
2021-4
A
3 0.68%
Due
9/16/2026

0.00 133.17
133.17
06/16/2023
Paydown
362585AC5
300,000.00
GM Financial Securitized ART
2022-2
A
3 3.1%
Due
2/16/2027

0.00 775.00
775.00
06/16/2023
Paydown
380146AC4
200,000.00
GM Financial Auto Receivables
2022-1
A
3 1.26%
Due
11/16/2026

0.00 210.00
210.00
06/17/2023
Interest
3135G04Z3
2,020,000.00
FNMA Note

0.5%
Due
6/17/2025

0.00 5,050.00
5,050.00
06/18/2023
Interest
89236TJK2
810,000.00
Toyota Motor Credit Corp Note

1.125%
Due
6/18/2026

0.00 4,556.25
4,556.25
06/18/2023
Paydown
43813KAC6
413,384.42
Honda Auto Receivables Trust
2020-3
A
3 0.37%
Due
10/18/2024
24,339.20

45.06 24,384.26
06/19/2023
Interest
06051GJD2
500,000.00
Bank of America Corp Callable Note Cont
6/19/2025

1.319%
Due
6/19/2026

0.00 3,297.50
3,297.50
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 62 ends

2.75%
Due
6/19/2023
500,000.00
6,875.00
506,875.00
06/20/2023
Paydown
36265MAC9
640,000.00
GM Financial Auto Lease Trust
2022-1
A
3 1.9%
Due
3/20/2025

0.00 1,013.33
1,013.33
06/20/2023
Paydown
92290BAA9
690,000.00
Verizon Owner Trust
2020
-B A

0.47%
Due
2/20/2025
21,524.40
177.73
21,702.13
06/20/2023
Paydown
36266FAC3
390,000.00
GM Financial Auto Lease Trust
2022-2
A
3 3.42%
Due
6/20/2025

0.00 1,111.50
1,111.50
06/21/2023
Paydown
43813RAC1
207,377.43
Honda Auto Receivables
2020-1
A
3 1.61%
Due
4/22/2024
9,016.06
146.23
9,162.29
06/21/2023
Paydown
43815GAC3
310,000.00
Honda Auto Receivables Trust
2021-4
A
3 0.88%
Due
1/21/2026
14,059.69
217.03
14,276.72
06/25/2023
Paydown
05601XAC3
305,000.00
BMW Vehicle Lease Trust
2022-1
A
3 1.1%
Due
3/25/2025
27,613.73
254.30
27,868.03
06/25/2023
Paydown
3137BFE98
800,000.00

FHLMC K
041
A
2 3.171%
Due
10/25/2024

0.00 2,114.00
2,114.00
06/25/2023
Paydown
09690AAC7
290,000.00
BMW Vehicle Lease Trust
2021-2
A
3 0.33%
Due
12/26/2024
24,163.74

46.55 24,210.29
06/25/2023
Paydown
05602RAD3
325,000.00
BMW Vehicle Owner Trust
2022
-A A
3 3.21%
Due
8/25/2026

0.00 869.38
869.38
06/26/2023
Maturity
931142EK5
380,000.00
Wal-Mart Stores Callable Note Cont
5/26/2023

3.4%
Due
6/26/2023
380,000.00
6,460.00
386,460.00
06/27/2023
Interest
02665WCZ2
1,150,000.00
American Honda Finance Note

2.4%
Due
6/27/2024

0.00 13,800.00
13,800.00
06/30/2023
Interest
91282CBC4
2,000,000.00
US Treasury Note

0.375%
Due
12/31/2025

0.00 3,750.00
3,750.00
JUN 2023
1,738,062.45
129,916.46
1,867,978.91
TOTAL
7,736,933.11
1,658,254.12
9,395,187.23
Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 63 ends

Important Disclosures
City of Vallejo Consolidated
Account #262
Chandler Asset Management, Inc.
;͞
Chandler
͟Ϳ
is an SEC registered investment adviser. For additional information about our firm, please see our current disclosures (Form ADV). To obtain a copy of our current disclosures, you may contact your client service representative by calling the number on the front of this statement or you may visit our website at www.chandlerasset.com.

Information contained in this monthly statement is confidential and is provided for informational purposes only and should not be construed as specific investment or legal advice. The information contained herein was obtained from sources believed to be reliable as of the date of this statement, but may become outdated or superseded at any time without notice.

Custody:

Your qualified custodian bank maintains control of all assets reflected in this statement and we urge you to compare this statement to the one you receive from your qualified custodian. Chandler does not have any authority to withdraw or deposit funds from/to the custodian account.

Valuation:

Prices are provided by IDC, an independent pricing source. In the event IDC does not provide a price or if the price provided is not reflective of fair market value, Chandler will obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures. Our valuation procedures are also disclosed in Item 5 of our Form ADV Part 2A.

Performance:

Performance results are presented gross-of-advisory fees and represent the client ͛
s Total Return. The deduction of advisory fees lowers performance results. These results include the reinvestment of dividends and other earnings. Past performance may not be indicative of future results. Therefore, clients should not assume that future performance of any specific investment or investment strategy will be profitable or equal to past performance levels. All investment strategies have the potential for profit or loss. Economic factors, market conditions or changes in investment strategies, contributions or withdrawals may materially alter the performance and results of your portfolio.

Source ice Data Indices, LLC ("ICE"), used with permission. ICE PERMITS USE OF THE ICE INDICES AND RELATED DATA ON AN "AS IS" BASIS; ICE, ITS AFFILIATES AND THEIR RESPECTIVE

THIRD PARTY SUPPLIERS DISCLAIM ANY AND ALL WARRANTIES AND REPRESENTATIONS, EXPRESS AND/OR IMPLIED, INCLUDING ANY WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE, INCLUDING THE INDICES, INDEX DATA AND ANY DATA INCLUDED IN, RELATED TO, OR DERIVED THEREFROM. NEITHER ICE DATA, ITS AFFILIATES OR

THEIR RESPECTIVE THIRD PARTY PROVIDERS GUARANTEE THE QUALITY, ADEQUACY, ACCURACY, TIMELINESS OR COMPLETENESS OF THE INDICES OR THE INDEX DATA OR ANY COMPONENT THEREOF, AND THE INDICES AND INDEX DATA AND ALL COMPONENTS THEREOF ARE PROVIDED ON AN "AS IS" BASIS AND LICENSEE'S USE IS AT LICENSEE'S OWN RISK. ICE DATA, ITS AFFILIATES AND THEIR RESPECTIVE THIRD PARTY DO NOT SPONSOR, ENDORSE, OR RECOMMEND CHANDLER, OR ANY OF ITS PRODUCTS OR SERVICES.

Ratings:

Ratings information have been provided by Moody
͛
s, S&P and Fitch through data feeds we believe to be reliable as of the date of this statement, however we cannot guarantee its accuracy.

Security level ratings for U.S. Agency issued mortgage-backed securities ;͞
MBS
͟Ϳ
reflect the issuer rating because the securities themselves are not rated. The issuing U.S. Agency guarantees the full and timely payment of both principal and interest and carries a AA+/Aaa/AAA by S&P, Moody ͛
s and Fitch respectively.

Execution Time: 7/8/2022 10:49:43 AM
Chandler Asset Management - CONFIDENTIAL

Page 64 ends

CONSENT CALENDAR 8.F.

DATE: July 26, 2022
TO: Mayor and Members of the City Council
FROM: Melissa L. Tigbao, Public Works Director
SUBJECT: ADOPT A RESOLUTION AMENDING THE FY 2022-23 CAPITAL IMPROVEMENT PROJECT BUDGET FOR PW9432: RADAR FEEDBACK SIGNS/RE-STRIPING

RECOMMENDATION
Adopt a Resolution to amend the FY2022-2023 Capital Improvement Project budget to recognize $55,000 of grant funding from the Solano Transportation Authority and appropriate expenditure budget to PW9432: Radar Feedback Signs / Re-striping Project.

REASONS FOR RECOMMENDATION
The City of Vallejo has been awarded two grants, totaling $55,000, from the Solano Transportation Authority.

An amendment to the FY2022-2023 CIP Budget is necessary to recognize the awarded grant revenue and allocate expenditure budget so project work can commence. This is the second step in the two-step process to amend the FY 2022-23 Capital Improvement Program (CIP) Budget.

BACKGROUND AND DISCUSSION
Solano Transportation Authority (STA) is responsible for countywide transportation planning, programming transportation funds, managing and providing transportation programs and services, delivering transportation projects, and setting transportation priorities. STA awarded the City two grants for work on crosswalk safety and walk/bike safety. The first grant agreement, executed in September 2021, is for $25,000 and will be used to re-stripe crosswalks and/or bike routes in the Dan Mini Elementary School area. The second grant agreement, executed in June 2021, is for $30,000 and will be used for the same type of work in the Loma Vista Elementary School area.

Approval of the Resolution will be the second step in the two-step process to amend the 2022-23 fiscal year Capital Improvement Project budget by recognizing grant revenue of $55,000 and appropriating expenditure funds to the Radar Feedback Signs / Re-striping Project (PW9432). The notice of intent to amend the budget was presented to City Council at the regular City Council meeting held on July 12, 2022.

FISCAL IMPACT
The recommended appropriation / allocation and expenditure amendment to the Capital Improvement Project budget for PW9432: Radar Feedback Signs / Re-striping Project is as follows:

Radar Feedback Signs / ReStriping (PW9432) Revenues Expenditures Grant / Reimbursements (Fund #221)
(Re-striping Dan Mini area)
$25,000
Grant / Reimbursements (Fund #221)
(Re-striping Loma Vista area)
$30,000
Site Improvements (#221) $55,000

Date: July 26, 2022
Subject: ADOPT A RESOLUTION AMENDING THE FY 2022-23 CAPITAL IMPROVEMENT PROJECT BUDGET FOR PW9432: RADAR FEEDBACK SIGNS/RE-STRIPING

Page 2 ends

TOTALS $55,000 $55,000

ATTACHMENTS

1. Resolution - Amend CIP Budget $55k (PW9432) - 7.26.22 cc2 dm2 CAO

2. Please_DocuSign_STA_-_Dan_Mini_Crosswalk_Saf

3. Loma Vista- VCUSD- SR2S Micro Grant Cycle 2 Agreement Form (3)-mt

CONTACT
Melissa L. Tigbao, Public Works Director, (707) 648-4085 [email protected]
RESOLUTION NO. 22- _____

RESOLUTION OF THE CITY COUNCIL OF THE CITY OF VALLEJO AMENDING THE CAPITAL IMPROVEMENT PROJECT BUDGET FOR FISCAL YEAR 2022-2023 TO

RECOGNIZE TWO AWARDED GRANTS AND ALLOCATE EXPENSES FOR THE GRANTS INTO PW9432: RADAR FEEDBACK SIGNS / RE-STRIPING PROJECT WHEREAS, Solano Transportation Authority (STA) is responsible for countywide transportation planning, programming transportation funds, managing and providing transportation programs and services, delivering transportation projects and setting transportation priorities; and WHEREAS, STA awarded the City of Vallejo two grants totaling $55,000 for work on crosswalk safety and walk / bike safety; and
WHEREAS, the first grant for $25,000 was executed in September, 2021, and funding will be used in the Dan Mini Elementary School area; and
WHEREAS, the second grant for $30,000 was executed in June, 2022, and funding will be used in the Loma Vista Elementary School area; and
WHEREAS, in order for the staff to start the work and for the City to be reimbursed for the work, the grant needs to be recognized by City Council and the funds need to be allocated to the PW9432:

Radar Feedback Signs / Re-striping Project; and
WHEREAS, the Capital Improvement Project PW9432: Radar Feedback Signs / Re-striping Project needs to have the expenditures increase in the total amount of $55,000; and WHEREAS, City Charter Section 703 permits the transfer of unappropriated funds by City Council upon one week’s written notice of intention to do so; and WHEREAS, a Notice of Intention to amend the Capital Improvement Project budget for PW9432:

Radar Feedback Signs / Re-striping Project was provided to the City Council on July 12, 2022.

NOW, THEREFORE BE IT RESOLVED that the City Council of the City of Vallejo does hereby approve the amendment of the FY 2022-2023 Capital Improvement Project budget to allocate the Grant / Reimbursement Fund #221 balance as follows:

PW9432: Radar Feedback Signs / Re-striping Project Revenues Expenditures Capital Grant and Contribution Fund (#221)
Grant Reimbursement
Site Improvements

$55,000
$55,000

Adopted by the City Council of the City of Vallejo at a regular meeting held on July 26, 2022 with the following vote:

AYES:

NOES:

ABSENT:

ABSTAIN:
______________________________________

ROBERT MCCONNELL, MAYOR
ATTEST:
______________________________________
DAWN G. ABRAHAMSON, CITY CLERK
Sep 23, 2021 12:45 PM, 864830349
Contract and Routing Form

Date Originated:

Finance Department ∙ 555 Santa Clara Street ∙ Vallejo ∙ CA ∙ 94590 ∙ 707.648.4592 Department: Public Works Departments, Engineering
Staff Contact: Mark Helmbrecht, [email protected] Contract Type: Grant Agreement
Vendor: Solano Transportation Authority

Contract Not to Exceed Amount: 25000.00
Contract Start Date: Oct 01, 2021 End Date: Jun 30, 2023 Option to Extend: N/A
Authority to Contract: Department Director

Attachments are uploaded for review here: https://bit.ly/vContracts

Approved Pre-Requisition Form

Insurance
I have uploaded additional files.No
DocuSign Envelope ID: DC094B6D-B302-4F58-840D-7C1F2465D1C0 Contract and Routing Form
Signature Page
Department Initial Date Comment
Originating Department/Division

Risk Manager
Finance Director
City Attorney's Office

City Clerk

Return executed contract to: Mark Helmbrecht
DocuSign Envelope ID: DC094B6D-B302-4F58-840D-7C1F2465D1C0 9/23/2021
9/23/2021
9/24/2021
10/5/2021
10/5/2021
1 SR2S Micro-Grant Program Acceptance Agreement
Project Name: City of Vallejo - Dan Mini Crosswalk Safety Project Funding Total: $25,000 The SR2S Micro-Grant may only be used to complete the Project listed above; as per the submitted grant application and SR2S Advisory Committee approval. The Project Applicant agrees to: (1) Use the dispersed SR2S grant money for the Project as stated in the application; (2) Return any unused funds or funds not used for the Project as described; 3) Comply with Terms and Conditions listed below; (4) Follow Project Reporting Requirements, including submission of a final report within 30 days of concluding the project and a 3-month progress report for projects longer than 3 months.

Included in the reports will be a summary of the progress of the Project, a budget outlining how all funds have been spent, and an update on metrics for success. Failure to comply with these requirements will result in termination of the grant and return of the remaining monies to the SR2S Program; and (5) By signing below, you agree to abide by the terms and conditions contained in this SR2S Micro-Grant Agreement.

Name of Primary Contact Mark Helmbrecht
Each individual signing this Agreement directly and expressly warrants that (s)he has been given and has received and accepted authority to sign and execute the Agreement on behalf of the ____________________ City or School District.

Printed Name _____________________________ Signature _________________________________ Title _______________________________ Agency __________________________________ Date _______________________________

TERMS AND CONDITIONS

1. INVOICES: Invoices must be in duplicate and completely itemized services provided.

2. TAXES: The STA is subject to California Sales Tax.

3. PAYMENT: Payment for the material/services on this Micro Grant will be made after the entire order is delivered or services are completed to the satisfaction of the STA, unless otherwise outlined in Applicant’s Micro-Grant Application.

4. WARRANTY: Seller warrants that the goods and services provided by seller will conform to applicable specifications, descriptions, or samples and will be merchantable, of good workmanship and material, and free from defect.
9/29/21
City of Vallejo
Public Works Director
Terrance Davis
City of Vallejo
DocuSign Envelope ID: DC094B6D-B302-4F58-840D-7C1F2465D1C0

2 5. INDEMNITY: Recipient and STA agree to defend, indemnify, and hold harmless the other, its officers, agents, and employees against any claim, loss or liability arising out of or resulting in any way from the willful or negligent acts or omissions of Recipient or STA, its officers, agents, employees, suppliers, and contractors in the performance of this Micro-Grant.

6. NON DISCRIMINATION: Recipient shall not discriminate against any employee or applicant for employment because of race, creed, sex, color or national origin and shall insure compliance with all provisions of Executive Order No. 11246 (as amended by executive order no. 11375). Failure to comply shall be considered cause for terminating this Micro-Grant.

7. INSURANCE: Recipient shall maintain insurance against claims for injuries to person or damages to property that may arise from the performance of such labor and/or services by seller or its agents, employees, or subcontractors as follows: (a) General liability-$1,000,000 per occurrence for bodily injury, personal injury, and property damage; (b) Automobile liability-$1,000,000 per accident for bodily injury and property damage; (c) Workers’ Compensation as required by State statutes. Both policies (a) and (b) shall contain, or be endorsed to contain, that the STA is covered as an insured with respect to liability resulting from the performance of such labor or services. Upon request, seller shall furnish STA with original certificates and endorsements effecting coverage required by this clause issued by and insurance company authorized to conduct business in California.

8. SAFETY: All labor and/or services provided will conform to all applicable health and safety requirements under Title 8, California Code of Regulations (Cal/OSHA).

9. ENTIRE AGREEMENT. This Micro-Grant Agreement constitutes the entire agreement between Recipient and STA for the Project listed above.

DocuSign Envelope ID: DC094B6D-B302-4F58-840D-7C1F2465D1C0 1 SR2S Micro-Grant Program Acceptance Agreement
Project Name: Loma Vista Walk/Bike Safety First Project Funding Total: $30,000.00 The SR2S Micro-Grant may only be used to complete the Project listed above; as per the submitted grant application and SR2S Advisory Committee approval. The Project Applicant agrees to: (1) Use the dispersed SR2S grant money for the Project as stated in the application; (2) Return any unused funds or funds not used for the Project as described; 3) Comply with Terms and Conditions listed below; (4) Follow Project Reporting Requirements, including submission of a final report within 30 days of concluding the project and a 3-month progress report for projects longer than 3 months.

Name of Primary Contact ____________________________
Each individual signing this Agreement directly and expressly warrants that (s)he has been given and has received and accepted authority to sign and execute the Agreement on behalf of the ____________________ City or School District.

TERMS AND CONDITIONS

1. INVOICES: Invoices must be in duplicate and completely itemized services provided.

2. TAXES: The STA is subject to California Sales Tax.

06.30.2022
2 5. INDEMNITY: Recipient and STA agree to defend, indemnify, and hold harmless the other, its officers, agents, and employees against any claim, loss or liability arising out of or resulting in any way from the willful or negligent acts or omissions of Recipient or STA, its officers, agents, employees, suppliers, and contractors in the performance of this Micro -Grant.

7. INSURANCE:

Recipient shall maintain insurance against claims for injuries to person or damages to property that may arise from the performance of such labor and/or services by seller or its agents, employees, or subcontractors as follows: (a) General liability-$1,00 0,000 per occurrence for bodily
injury, personal injury, and property damage; (b) Automobile liability-$1,000,000 per accident for bodily injury and property damage; (c) Workers’ Compensation as required by State statutes. Both policies (a) and (b) shall contain, or be endorsed to contain, that the STA is covered as an insured with respect to liability resulting from the performance of such labor or services. Upon request, seller shall furnish STA with original certificates and endorsements effecting coverage required by this clause issued by and insurance company authorized to conduct business in California.

8. SAFETY: All labor and/or services provided will conform to all applicable health and safety requirements under Title 8, California Code of Regulations (Cal/OSHA).

9. ENTIRE AGREEMENT. This Micro-Grant Agreement constitutes the entire agreement between Recipient and STA for the Project listed above.

CONSENT CALENDAR 8.G.

DATE: July 26, 2022
TO: Mayor and Members of the City Council
FROM: Shawny K. Williams, Chief of Police
SUBJECT: AUTHORIZE THE CITY MANAGER TO EXECUTE A MEMORANDUM OF

UNDERSTANDING WITH COMMUNITY-BASED ORGANIZATION THE LEAVEN

RECOMMENDATION
Authorize the City Manager to execute the attached Memorandum of Understanding with the community- based organization The Leaven, in an amount not to exceed $299,800 for activities related to the Byrne Criminal Justice Innovation Grant.

REASONS FOR RECOMMENDATION
The Leaven is a local non-profit that revitalizes communities through early education intervention and is the primary partner/sub-recipient of the Byrne Criminal Justice Innovation grant received by the City of Vallejo Police Department. A memorandum of understanding is required to allow The Leaven to perform and receive funding for approved grant activities.

BACKGROUND AND DISCUSSION
In December 2021, the City of Vallejo Police Department was one of the 20 agencies selected for the Fiscal Year 2021 Byrne Criminal Justice Innovation Program (BCJI). Funding received through the grant will be used to fund "Project HOPE"; the Leaven is the primary partner for Project HOPE. Project HOPE will support three learning centers located directly in apartment complexes in hotspot neighborhoods. These learning centers will offer after-school programming with role models, tutoring, enrichment, and service referrals. Creating year- round opportunities for positive interaction and programming for youth in after-school hours and summer.

The Leaven learning centers provide the foundation for all Project HOPE programming and will offer enrichment and opportunities to over 225 children (75 annually) year-round, and instill a sense of community in youth and family participants.

FISCAL IMPACT
Funding for this agreement in amount not to exceed $299,800 will be paid in full by the Byrne Criminal Justice Innovation Grant. There is no net fiscal impact on the general fund.

ATTACHMENTS

1. Leaven MOU CAO Stamp

Date: July 26, 2022
Subject: AUTHORIZE THE CITY MANAGER TO EXECUTE A MEMORANDUM OF

UNDERSTANDING WITH COMMUNITY-BASED ORGANIZATION THE LEAVEN

Page 2 ends

CONTACT
Shawny K. Williams, Chief of Police (707) 648-4540
[email protected]
Approved as to form:

By: for
Veronica Nebb, City Attorney

CITY OF VALLEJO

BYRNE CRIMINAL JUSTICE INNOVATION PROGRAM

MEMORANDUM OF AGREEMENT
WITH LEAVEN KIDS, INC., GREATER VALLEJO RECREATION DISTRICT

AND THE CITY OF VALLEJO
This Byrne Criminal Justice Innovation Program Memorandum of Agreement (“Agreement”) is made at Vallejo, California, dated for reference this day of , by and between the City of Vallejo, a California municipal corporation (”City”), and Greater Vallejo Recreation District (“GVRD”), a government agency separate from the City that provides parks and recreation programs for children, families, and seniors in Vallejo, and Leaven Kids, Inc., (“Agency”) a community-based organization that provides after-school programming for youth. City, GVRD, and Agency (separately “Party” and collectively “Parties”) agree as follows:

RECITALS
WHEREAS, City received funding from the Department of Justice (DOJ) for a grant awarded through the Byrne Criminal Justice Innovation (BCJI) Program; and WHEREAS, City and GVRD both recognize the BCJI program to be an excellent opportunity to work together to benefit Vallejo residents, address urgent public safety needs in the community, and reduce violent crime; and
WHEREAS, City desires to engage Agency as a BCJI sub awardee and City will provide funds not to exceed $299,800 for the purpose of the Agency accomplishing the scope of services described in Exhibit A. Agency will utilize space within GVRD’s Norman C. King Community Center located at 545 Magazine St., Vallejo, California (the “Center”) and provide site fees not to exceed $900 per month, for 24 months, or a total of $18,900. This Memorandum of Understanding (MOU) sets forth the respective roles and responsibilities of the Parties related to the support of BCJI Project HOPE. The Parties acknowledge that the unique circumstances of individual cases may give rise to issues not addressed by this MOU, which may necessitate further discussion and agreement. This MOU meets the requirements of 29 CFR § 553.105 A. Project Description

The City shall reimburse Agency for all allowable costs and expenses incurred in providing the program (also referred to as the “Scope of Services”), as set forth in Exhibit A of this Agreement and incorporated herein by this reference. The program, allowable costs and expenses, are agreed to by all parties. The program, allowable costs, and expenses may be amended upon agreement of both parties. GVRD agrees that the Agency can perform its proposed services at the Center. Agency proposes to utilize the Center _______ days per week for ______ hours to provide high-quality afterschool programming for youth at-risk of exposure to crime and violence.

Additionally, Agency and GVRD agree that the Center will be used as available for community engagement events and family education workshops.

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 2 of 20 ends

Agency shall follow the mandatory DOJ requirements due to the interaction of Agency personnel, contractors, employees, volunteers and subcontractors with minors. The Agency as the recipient, shall ensure that all personnel who have contact with minors meet the requirements set forth in Exhibit D which is attached hereto and incorporated herein by this reference. For purposes of Exhibit D, the Agency shall also be known as the recipient.

B. Project and Agreement Term
The term of this Agreement shall be effective 08/01/2022 and expire on 09/30/2024.

C. Project Implementation

1. The City hereby grants to the Agency an amount not to exceed $299,800 on condition that the Grant Funds be expended for the eligible costs and purposes of the Project as described in Exhibit A of this Agreement and pursuant to all other terms and conditions set forth herein. The Scope of Services includes deliverables and estimated costs for each deliverable. Agency is bound hereby to complete each deliverable listed in the Scope of Services and will be solely responsible for fees that result from use of the Center during the term of this Agreement.

2. The Agency shall complete the Project by 09/30/2024. Requests for project extensions must be in writing to the City no later than 90 days before the project end date.

3. The Agency certifies that Project HOPE does and will continue to comply with all laws and regulations which apply to the Project, including, but not limited to, legal requirements for construction contracts and workers’ compensation, building codes, environmental laws (including but not limited to the California Environmental Quality Act), health and safety codes, and disabled access laws.

4. GVRD hereby rents to Agency space at the Center to carry out Project HOPE activities as described in Exhibit A at a fee not to exceed $900 per month.

5. Agency shall obtain the City’s written approval for any change or deviation from the original Scope of Services set forth in Exhibit A, including changes to any of the deliverables or costs identified therein. Any modification to the Project or Scope of Services must also comply with all current laws and regulations and all other requirements of this Agreement, and the Project must be completed with available funding from the Agency and funds provided under this Agreement.

Any request for changes or deviations to the Scope of Services shall be requested in writing to the City. The City shall review any request for changes or deviations presented therein and promptly notify the Agency of the City’s decision.

6. All actions and approvals required to be taken by the City under this Agreement shall be approved by either the City Council, the City Manager or his/her designee.

7. The Agency will conduct pre-program assessments and provide the City with programmatic data throughout the term of this Agreement so that the City can evaluate program successes and impacts.

8. The City will collect crime and arrest data for the locations listed above to analyze crime rates City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 3 of 20 ends

and program impacts throughout the term of this Agreement.

D. Project Costs, Requests for Payment, Advances

1. The Agency agrees to use all Grant Funds provided by the City, under the terms of this Agreement, solely for the Project herein described.

2. Grant Funds provided to the Agency under this Agreement shall be disbursed for eligible costs within 30 days of the Agency submitting quarterly invoices for costs associated with the Project to the City.

4. Grant Funds under this Agreement must be expended within the term of this Agreement.

5. Except as otherwise provided herein, Agency shall expend Grant Funds only in the manner described herein.

6. City will not pay for Project costs with any other grants.

7. Regardless of any other provisions herein, City shall not provide payment to the Agency in excess of the Agency’s actual BCJI Program expenses. Furthermore, the City shall not reimburse the Agency for expenses that exceed the amount allocated to the Agency.

8. The Agency is liable for repayment of disallowed costs. Disallowed costs may be identified through audits, monitoring, or other means. The Agency shall be afforded the opportunity to respond to any adverse findings which may lead to disallowed costs.

E. Payment Process and Documentation

1. All Requests for Payments must be submitted using a completed Request for Payment Form attached as Exhibit B which is incorporated herein by this reference. This form must be accompanied by 1) an itemized list of all expenditures according to Project Budget Categories, and 2) supporting documentation that clearly identifies the expenditure(s) in relation to the Project Budget Categories set forth in Exhibit A. Payment requests may not be submitted more often than quarterly.

2. If the Request for Payment Form is incomplete, inadequate or inaccurate, the City may withhold all or a portion of the payment request until all required information is received or corrected. Any penalties whatsoever imposed on the Agency by a government agency or a contractor for any reason whatsoever are the responsibility of the Agency and are not reimbursable under this Agreement.

F. Project Review and Documentation.

The Agency shall submit progress reports as described in Exhibit C which is incorporated herein by this reference.

G. Subrecipient Monitoring
The Agency shall perform all monitoring and reporting requirements of subrecipients, if any, in accordance with 2.CFR.200. Details regarding the subrecipient monitoring plan are set forth in Exhibit E which is incorporated herein by this reference.

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 4 of 20 ends

H. Project Termination

1. Prior to the completion of the Project, either Party may terminate this Agreement by providing the other Party with thirty (30) days’ written notice.

2. If the City terminates this Agreement prior to the project completion date stated in Section B, the Agency shall take all reasonable measures to prevent further costs to the City hereunder. The City shall be responsible for any reasonable and non-cancelable obligations incurred by the Agency under this Agreement prior to the date of the notice to terminate, but only up to the undisbursed balance of funding authorized in this Agreement and only for authorized expenses.

I. Financial Records

1. The Agency shall establish an official file for the Project. The file shall contain adequate documentation of all actions that are taken with respect to the Project.

2. The Agency shall keep separate and complete accounting records for receipt, deposit, and payment of all Project funds, including interest.

3. The Agency agrees that adequate supporting documentation shall be maintained in sufficient detail to provide an audit trail which will permit tracing transactions from support documentation to the accounting records to the financial reports and billings.

4. The Agency shall maintain books, records, documents, and other evidence sufficient to reflect properly the amount, receipt, and disposition of all Project funds, including non-City funds, interest earned, and any matching funds by the Agency and the total cost of the Project. Time and effort reports shall also be required for consultants and contractors. Adequate supporting documentation shall be maintained by consultants and contractors in sufficient detail to provide an audit trail which will permit tracing transactions from the invoices to the financial statement, to the accounting records, and to the supporting documentation.

5. The Agency shall use applicable Generally Accepted Accounting Principles, unless otherwise agreed to by the City.

J. Audit Requirements
The City reserves the right to call for a program audit or a financial audit at any time during the term of this Agreement and for two years following termination of this Agreement. Within ten (10) working days of a request by the City, Agency shall furnish, at its own expense, legible copies of all materials deemed pertinent to the request. At any time, the City may disallow all or part of the cost of any activity or action which it determines to be out of compliance with the terms and conditions of this Agreement.

K. Assignment
Except as expressly provided by written agreement between the Parties, this Agreement is not assignable by Agency or GVRD either in whole or in part.

L. No Agency Agreement
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 5 of 20 ends

In carrying out this Agreement, the Agency and GVRD and its agents and employees shall be deemed to be acting in an independent capacity with respect to the City, and not as the officers, employees, or agents of the City or the State.

M. Liability and Insurance

1. Agency and GVRD shall defend, indemnify, and save harmless the City (including its inspectors, project managers, trustees, officers, elected officials, appointed officials, agents, members, employees, affiliates, consultants, subconsultants, volunteers and representatives), and each of them, of and from any and all claims, demands, suits, causes of action, damages, costs, expenses, attorneys' fees, losses, or liability, in law or in equity, of every kind and nature whatsoever arising out of, or in connection with, the Agency or GVRD’s operations to be performed under this Agreement, including, but not limited to:

A. Personal injury (including, but not limited to, bodily injury, emotional injury or distress, sickness, or disease) or death to persons, including, but not limited to, any employees or agents of the Agency, the City, or any subcontractor, or damage to property of anyone including the work itself (including loss of use thereof), caused or alleged to be caused in whole or in part by any negligent act or omission of Agency, GVRD, the City, or anyone directly or indirectly employed by them, or anyone for whose acts they may be liable; B. Penalties threatened, sought, or imposed on account of the violation of any law, order, citation, rule, regulation, standard, ordinance, or statute, caused by the action or inaction of the Agency;
C. Alleged infringement of any patent rights which may be brought arising out of the Agency or GVRD’s work;
D. Claims and liens for labor performed or materials used or furnished to be used on the job, including all incidental or consequential damages from such claims or liens; E. Agency or GVRD’s failure to fulfill any of the covenants set forth in this Agreement; F. Failure of the Agency or GVRD to comply with the provisions of this Agreement relating to insurance; and,
G. Any violation or infraction by the Agency or GVRD of any law, order, citation, rule, regulation, standard, ordinance, or statute in any way relating to the occupational, health, or safety of employees.

The indemnities set forth in this section shall not be limited by the insurance requirements set forth in this Agreement.

The Agency's indemnification of the City will not include indemnification for claims which arise as the result of the active negligence of the City, or the sole negligence or willful misconduct of the City, its agents, servants or independent contractors who are directly responsible to the City, or for defects in design furnished by such persons.

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 6 of 20 ends

The indemnification provisions set forth above shall survive the termination of this Agreement.

2. Insurance shall conform to the following requirements: the Agency shall procure and maintain for the duration of this Agreement, insurance against claims for injuries to persons or damages to property which may arise from or in connection with the performance of the work hereunder by the Agency, its agents, representatives, employees, volunteers or subcontractors. Such insurance shall not be construed to relieve the Agency of any liability in excess of such coverage.

A. Minimum Scope of Insurance Coverage shall be at least as broad as:

1. Insurance Services Office form number GL 0002 (Ed. 1/73) covering Comprehensive General Liability and Insurance Services Office from number GL 0404 covering Broad Form Comprehensive General Liability; or Insurance Services Office Commercial General Liability coverage ("occurrence" form CG 0001).

2. Insurance Services Office form number CA 0001 (Ed. 1/78) covering Automobile Liability, code 1 "any auto" and endorsement CA 0025.

3. Workers' Compensation insurance as required by the Labor Code of the State of California and Employers Liability insurance.

B. Minimum Limits of Insurance
The Agency shall maintain limits no less than:

1. General Liability: $2,000,000 combined single limit per occurrence for bodily injury, personal injury and property damage. If Commercial General Liability Insurance or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be twice the required occurrence limit.

2. Automobile Liability: $1,000,000 combined single limit per accident for bodily injury and property damage.

3. Workers' Compensation and Employers Liability: Workers' compensation limits as required by the Labor Code of the State of California and Employers Liability limits of $1,000,000 per accident.

C. Deductibles and Self Insured Retention
Any deductibles or self-insured retention must be declared to and accepted by the City. At the option of the City, either the insurer shall reduce or eliminate such deductibles or self-insured retention as respects the City, its officers, officials, elected officials, appointed officials, employees and volunteers; or the Agency shall procure a bond guaranteeing payment of losses and related investigations, claim administration and defense expenses.

D. Other Insurance Provisions
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 7 of 20 ends

The policies are to contain, or be endorsed to contain the following provisions:

1. General Liability and Automobile Liability Coverage
i. The City, its officers, officials, elected officials, appointed officials, employees and volunteers are to be covered as insured as respects: liability arising out of activities performed by or on behalf of the Agency, including the insured's general supervision of the Agency; products and completed operations of the Agency, premises owned, occupied or used by the Agency. The coverage shall contain no special limitations on the scope of protection afforded to the City, its officers, officials, elected officials, appointed officials, employees or volunteers. ii. The Agency's insurance coverage shall be primary insurance as respects the City, its officers, officials, elected officials, appointed officials, employees, and volunteers. Any insurance or self- insurance maintained by the City, its officers, officials, elected officials, appointed officials, employees or volunteers shall be excess of the Agency's insurance and shall not contribute with it.
iii. Any failure to comply with reporting provisions of the policies shall not affect coverage provided to the City, its officers, officials, elected officials, appointed officials, employees or volunteers.
iv. The Agency's coverage applies separately to each insured against whom claim is made or suit is brought, except with respect to the limits of the insurer's liability.

2. Workers' Compensation and Employers Liability Coverage The insurer shall agree to waive all rights of subrogation against the City, its officers, officials, elected officials, appointed officials, employees and volunteers for losses arising from work performed by the Agency for the City.

3. All Coverage
Each insurance policy required by this clause shall be endorsed to state that coverage shall not be suspended, voided, canceled by either party, reduced in coverage or in limits except after thirty (30) days' prior written notice has been given to the City.

E. Acceptability of Insurers
Insurance is to be placed with insurers with a Best's rating of no less than A:VII.

F. Verification of Coverage
Agency shall furnish the City with certificates of insurance and with original endorsements effecting coverage required by this section. The certificates and endorsements for each insurance policy are to be signed by a person authorized by that insurer to bind coverage on its behalf. All certificates and endorsements are to be received and accepted by the City before work commences. The City reserves the right to require complete, certified copies of all required insurance policies, at any time.

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 8 of 20 ends

G. Subcontractors
The Agency shall include all subcontractors as insured under its policies or shall furnish separate certificates and endorsements for each subcontractor. All coverage for subcontractors shall be subject to all of the requirements stated herein.

The Agency shall ensure that all subcontractors include the City as additional insured.

N. Nondiscrimination
The Agency shall not discriminate against any person on the basis of sex, race, color, ancestry, religious creed, national origin, physical disability, mental disability, medical condition, age, marital status, military status, sexual orientation or gender selection in the performance of the services set forth in this Agreement.

O. Severability
If any provision of this Agreement or the application thereof is held invalid, that invalidity shall not affect other provisions or applications of this Agreement which can be given effect without the invalid provision or application, and to this end the provisions of this Agreement are severable.

P. Waiver
No term or provision hereof will be considered waived by either Party, and no breach is excused or consented to by either Party, unless such waiver or consent is in writing and signed on behalf of the Party against whom the waiver is asserted. No express or implied consent by either Party to, waiver of, or failure of a Party to enforce its rights with respect to a breach by the other Party shall constitute consent to or, waiver of any subsequent or other breach by the other Party.

Q. Time of the Essence
Time is of the essence with respect to the Completion Date as set forth in Section B of this Agreement. With respect to all other dates set forth herein, the Agency shall use its best efforts to accomplish the tasks by the specified dates.

R. Amendment
This Agreement may be amended by mutual agreement in writing between the Parties. Any request by the Agency for amendments must be in writing stating the amendment request and reason for the request. The Agency shall make requests in a timely manner and in no event less than thirty (30) days before the effective date of the proposed amendment.

S. Notices
All notices or instruments required to be given or delivered by law or this Agreement shall be in writing and shall be effective upon receipt thereof and shall be by personal service or delivered by depositing the same in any United States Post Office, registered or certified mail, postage prepaid, addressed to:

City: Bonnie Mirante
Administrative Manager
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 9 of 20 ends

Vallejo Police Department
111 Amador Street
Vallejo, CA 94590
(707) 648-5565
[email protected]
Agency: Leaven Kids, Inc.
2220 Boyton Ave., Suite A
Fairfield, CA 94533
GVRD: Gabriel Lanusse
General Manager
Greater Vallejo Recreation District
395 Amador St.

Vallejo, CA 94590
T. List of Exhibits
Exhibit A – Scope of Services
Exhibit B – Request for Payment Form
Exhibit C – Progress Report Form
Exhibit D – Determination of suitability required, in advance, for certain individuals who may interact with participating minors
Exhibit E - Subrecipient Monitoring Plan
U. Entire Agreement
This Agreement, and the attached exhibits, constitute the entire Agreement between the parties hereto relating to the Project and may not be modified except by an instrument in writing signed by the parties hereto.
(signatures on next page)
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 10 of 20 ends

IN WITNESS WHEREOF, the parties have entered into this Agreement on the day and year first hereinabove appearing.

LEAVEN KIDS, INC. CITY OF VALLEJO
By:

MARK LILLIS
Executive Director
DATE: ____________________
_______________________
Vallejo Business License #

GREATER VALLEJO RECREATION

DISTRICT
By:

GABRIEL LANUSSE
DATE:
(City Seal)
By:

MICHAEL MALONE
City Manager
DATE:
________________________
ATTEST:

DAWN G. ABRAHAMSON
City Clerk
APPROVED AS TO CONTENT:
_____
SHAWNY K. WILLIAMS
Chief of Police
APPROVED AS TO FORM:

VERONICA A. F. NEBB
City Attorney
APPROVED AS TO INSURANCE:

ARMOND SARKIS
Risk Manager

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 11 of 20 ends

EXHIBIT A

THE LEAVEN

SCOPE OF SERVICES
A. Program Description:

Project provides academic tutoring, mentoring, and referrals to trauma-informed social and supportive services at the Leaven Learning Centers located at Maine Street, Sereno Drive, and a new location as set forth in the Agreement. Project provides staffing to ensure centers are open and available to students and their families in targeted locations identified as high crime “hotspots.”
B. Program Budget:

Year 1 Year 2 Year 3 Total
Personnel 33,800 67,600 67,600
Supplies 34,950 47,200
68,750 114,800
Breakdown of budget costs - to be amended as necessary throughout the grant period, and MOU will be updated and executed accordingly.

YEAR 1

PERSONNEL
Site Director (Maine) $4,500
Site Director (Sereno) $4,500
Site Director (Norman King) $11,500
Asst. Site Director $9,000
Executive Director $2,500
Payroll Taxes $1,800
$33,800.00

SUPPLIES
Equipment, Site Costs, and
Supplies
$22,550 New location furnishing including tables,
chairs, cabinets, STEAM Equipment,
educational materials and equipment, on-site
fees, including for Center use.

Parent Education Program $5,000 Includes workshops, seminars, and education on early intervention, childhood
behaviors, assistance on accessing
resources, among others.

Telephone $900 Telephone for site directors $50 per month for each director
Field Trips $1,250 New location which will include educational and positive programming for participants
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 12 of 20 ends

and will cover costs of programming,
transportation, admission, among others.

Community Events $3,250 Includes family engagement and workshops, movie nights for youth and families,
neighborhood engagement and social
activities, arts and craft events, among
others.

Volunteer Recruitment &
Training
$2,000 Recruitment will include a social media
campaign, printed materials for flyers, and
training sessions for new volunteers.
34,950
YEAR 2

PERSONNEL
Site Director $9,000 Existing location: Maine
Site Director $9,000 Existing Location: Sereno
Site Director $23,000 New location: Norman King
Asst. Site Director $18,000 New location: Norman King
Supervisor $5,000 New location: Norman King
Payroll Taxes $3,600
$67,600.00

SUPPLIES
Equipment, Site Costs, and
Supplies
$22,400 New location furnishing upkeep and
maintenance, STEAM Equipment
maintenance, computer replacement,
educational materials and equipment, on-site
fees, including for Center use.

Parent Education Program $10,000 Includes workshops, seminars, and education on early intervention, childhood
behaviors, assistance on accessing
resources, among others.

Telephone $1,800 Telephone for site directors $50 per month for each director
Field Trips $2,500 New location which will include educational and positive programming for participants
and will cover costs of programming,
transportation, admission, among others.

Community Events $6,500 Includes family engagement and workshops, movie nights for youth and families,
neighborhood engagement and social
activities, arts and craft events, among
others.

Volunteer Recruitment &
Training
$4,000 Recruitment will include a social media
campaign, printed materials for flyers, and
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 13 of 20 ends

training sessions for new volunteers.
$47,200.00
YEAR 3

SUPPLIES
Equipment and Supplies $26,100 Direct programming materials including robotics equipment, on-site fees, including
for Center use.

General Insurance $1,000 New location insurance
Auto Maintenance & Mileage $1,000 Reimbursed at the Federal Rate Office Supplies $1,000 Supplies necessary to manage and implement program.

Parent Education Program $10,000 Includes workshops, seminars, and education on early intervention, childhood
behaviors, assistance on accessing
resources, among others.

Community Events $6,500 Includes family engagement and workshops, movie nights for youth and families,
neighborhood engagement and social
activities, arts and craft events, among
others.

Volunteer Recruitment &
Training
$4,000 Recruitment will include a social media
campaign, printed materials for flyers, and
training sessions for new volunteers.
$53,900.00

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 14 of 20 ends

EXHIBIT B

REQUEST FOR PAYMENT
“Quarterly Financial Status Reports” will be due quarterly and act as a request for payment. The City will email the Agency an excel file for this mandatory reporting along with the schedule of due dates for each reporting period. Information regarding financial reports and reimbursements should be emailed to [email protected].

Sample Report Format:

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 15 of 20 ends

EXHIBIT C

PROGRESS REPORT
Progress report information will be detailed in an addendum to this contract at a later date once the BCJI Action Plan has been accepted and required data collection is determined by BCJI research partners.

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 16 of 20 ends

EXHIBIT D
Determination of suitability required, in advance, for certain individuals who may interact with participating minors

1. Advance determination regarding suitability. The recipient (and any subrecipient at any tier) may not permit any covered individual to interact with any participating minor in the course of activities under the award, unless the recipient or subrecipient first has made a written determination of the suitability of that individual to interact with participating minors, based on current and appropriate information as described in paragraph 3.E., and taking into account the factors and considerations described in paragraph 4.

2. Updates and reexaminations
A. The recipient (or subrecipient) must, at least every five years, update the searches described in paragraph 3.E.1. and 2., reexamine the covered individual's suitability determination in light of those search results, and, if appropriate, modify or withdraw that determination.

B. The recipient also must reexamine a covered individual's suitability determination upon learning of information that reasonably may suggest unsuitability and, if appropriate, modify or withdraw that determination.

3. Definitions
A. "Covered individual" means any individual (other than a participating minor, as defined in this condition, or a client of the recipient (or subrecipient)) who is expected, or reasonably likely, to interact with any participating minor (other than the individual's own minor children). A covered individual need not have any particular employment status or legal relationship with the recipient (or subrecipient). Such an individual might be an employee of a recipient (or subrecipient), but also might be (for example) a consultant, contractor, employee of a contractor, trainee, volunteer, or teacher.

B. "Participating minor." All individuals under 18 years of age within the set of individuals described in the scope section of this condition as it appears on the award document are participating minors.

C. "Interaction" includes physical contact, oral and written communication, and the transmission of images and sound and may be in person or by electronic (or similar) means. But "interaction” does not include--
(1) brief contact that is both unexpected by the recipient (or subrecipient) and unintentional on the part of the covered individual -- such as might occur when a postal carrier delivers mail to an administrative office.
(2) personally-accompanied contact -- that is, infrequent or occasional contact (for example, by someone who comes to make a presentation) in the presence of an accompanying adult, pursuant to written policies and procedures of the recipient (or subrecipient) that are designed to ensure that -- throughout the contact -- an appropriate adult who has been determined to be suitable pursuant to this condition will closely and personally accompany, and remain continuously within view and earshot of, the covered individual.

City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 17 of 20 ends

D. "Activities under the award." Whether paid for with federal funds from the award, "matching” funds included in the OJP-approved budget for the award, or "program income" for the award as defined by the (DOJ) Part 200 Uniform Requirements), activities under the award include both-- (1) activities carried out under the award by the recipient (or subrecipient); and (2) actions taken by an entity or individual pursuant to a procurement contract under the award or to a procurement contract under a subaward at any tier.

E. "Current and appropriate information"
In addition to information resulting from checks or screening required by applicable federal, state, tribal, or local law, and/or by the recipient's (or subrecipient's) written policies and procedures, current and appropriate information includes the results of all required searches listed below, each of which must be completed no earlier than six months before the determination regarding suitability.
(1) Public sex offender and child abuse websites/registries A search (by current name, and, if applicable, by previous name(s) or aliases), of the pertinent and reasonably- accessible federal, state, and (if applicable) local and tribal sex offender and child abuse websites/public registries, including--
(a) the Dru Sjodin National Sex Offender Public Website (www.nsopw.gov); (b) the website/public registry for each state (and/or tribe, if applicable) in which the individual lives, works, or goes to school, or has lived, worked, or gone to school at any time during the past five years; and
(c) the website/public registry for each state (and/or tribe, if applicable) in which the individual is expected to, or reasonably likely to, interact with a participating minor in the course of activities under the award.
(2) Criminal history registries and similar repositories of criminal history records For each individual at least 18 years of age who is a covered individual under this FY 2019 award, a fingerprint search (or, if the recipient or subrecipient documents that a fingerprint search is not legally available, a name-based search, using current and, if applicable, previous names and aliases) -- encompassing at least the time period beginning five calendar years preceding the date of the search request -- of pertinent state (and, if applicable, local and tribal) criminal history registries or similar repositories, including-- (a) the criminal history registry for each state in which the individual lives, works, or goes to school, or has lived, worked, or gone to school at any time during the past five years; and (b) the criminal history registry for each state in which he or she is expected to, or reasonably likely to, interact with a participating minor in the course of activities under the award.

4. Factors and considerations in determinations regarding suitability In addition to the factors and considerations that must or may be considered under applicable federal, state, tribal, or local law, and under the recipient's (or subrecipient's) written policies and procedures, in making a determination regarding suitability, the recipient (or subrecipient) must City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 18 of 20 ends

consider the current and appropriate information described in paragraph 3.E.

In particular (unless applicable law precludes it), with respect to either an initial determination of suitability or a subsequent reexamination, the recipient (or subrecipient) may not determine that a covered individual is suitable to interact with participating minors in the course of activities under the award if the covered individual--
A. Withholds consent to a criminal history search required by this condition.

B. Knowingly makes (or made) a false statement that affects, or is intended to affect, any search required by this condition.

C. Is listed as a registered sex offender on the Dru Sjodin National Sex Offender Public Website;
D. To the knowledge of the recipient (or subrecipient), has been convicted -- whether as a felony or misdemeanor -- under federal, state, tribal, or local law of any of the following crimes (or any substantially equivalent criminal offense, regardless of the specific words by which it may be identified in law):
(1) sexual or physical abuse, neglect, or endangerment of an individual under the age of 18 at the time of the offense;
(2) rape/sexual assault, including conspiracy to commit rape/sexual assault; (3) sexual exploitation, such as through child pornography or sex trafficking; (4) kidnapping;
(5) voyeurism; or
E. Is determined by a federal, state, tribal, or local government agency not to be suitable.

5. Administration; rule of construction
A. The requirements of this condition are among those that must be included in any subaward (at any tier), and must be monitored. They apply as of the date of acceptance of this award, and throughout the remainder of the period of performance.

B. The recipient is to contact the DOJ awarding agency with any questions regarding the requirements of this condition and must not allow a covered individual to interact with a participating minor until such questions are answered.

C. Award funds may be obligated for the reasonable, necessary, and allocable costs (if any) of actions designed to ensure compliance with this condition, provided that such funds would not supplant non-federal funds that would otherwise be available for such costs.

D. Nothing in this condition shall be understood to authorize or require any recipient, any subrecipient at any tier, or any person or other entity, to violate any federal, state, tribal, or local law, including any applicable civil rights or nondiscrimination law.

More information found at: https://www.ojp.gov/funding/explore/interact-minors City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 19 of 20 ends

EXHIBIT E
Subrecipient Monitoring Plan
The City of Vallejo will be responsible for collecting, aggregating, and submitting all required reports and performing necessary subrecipient monitoring activities to ensure Project H.O.P.E. is compliant with all relevant federal guidelines, including BCJI program guidance, the Office of Justice Programs Financial Guide, and The Office of Management and Budget (OMB) requirements.

The purpose of this plan establishes a monitoring system that defines subrecipient monitoring.

The City of Vallejo as fiscal agent, is responsible for monitoring subrecipient activities to provide reasonable assurance that the subrecipient administers federal awards in compliance with the OMB Circular A-133, Audits of States, Local Governments and Non-Profits Organizations; for ensuring required audits are performed and requiring subrecipient to take prompt corrective action on any audit finding: and for evaluating the impact of subrecipient activities on its ability to comply with applicable federal regulations.

City of Vallejo Responsibilities
1) Award Identification
a. The City of Vallejo will provide the following information to subrecipients at the time of award announcement:
i.Award name and year
ii.Name of federal awarding agency
iii.CFDA title & number
iv.Whether or not award is Research & Development
v.Amount of award as allocated by the BCJI, and any adjustments to that allocation b. The City of Vallejo will provide the following information to subrecipient at the time funds are forwarded:
i.Award name, number, and year
ii.Description of scope of work/budget
iii.Legal requirements as outlined by the grant agreement signed by the City of Vallejo and BCJI Program
2) Grant Requirement Notification
a. The following requirements will be outlined in the MOU between the subrecipients. i.Reporting requirements, including but not limited to:

1. Quarterly Financial Status Reports

2. Quarterly Reports and Performance Metrics.
ii.Legal requirements as outlined by the grant guidance, including but not limited to:

1. Non-Supplanting of State and Local Funds

2. Civil Rights Compliance

3. Anti-Lobbying Act

4. National Environmental Policy Act (NEPA) DOJ Information Technology Standards

5. Compliance with Office of Justice Program Financial Guide

6. Government Performance and Results Act (GPRA)

7. Federal Funding Accountability and Transparency Act (FFATA)

8. Records Retention Requirements
City of Vallejo BCJI Grant Agreement – Leaven Kids, Inc. and Greater Vallejo Recreation District

Page 20 of 20 ends

3) Subrecipient Monitoring Activities
a. Each Fiscal Year, the City of Vallejo will perform an on-site visit once (1) every year the BCJI Program is active:
i.To review financial and programmatic records
ii.To observe operations
iii.To inspect facilities to ensure compliance with program requirements iv.To interview staff to ensure they are informed of and carry out program policy and regulations b. Monitoring follow-up is done to ascertain corrective action has been done for any problems or deficiencies that may have been identified. c. The subrecipient is required to submit a complete inventory of all equipment purchased with BCJI funds for each year. The City of Vallejo will select the items from the inventory list to check and ensure equipment is maintained in accordance with DOJ guidelines. d. Desk review of financial records, to include:
i.Purchasing records for items selected as part of the inventory check, including support documentation for any sole source contract and suspension and debarment checks on vendors. ii.Review of billings and the supporting documentation accompanying the quarterly financial status report to be selected at random.
e. A monitoring visit checklist will be completed during the visit documenting the inventory check and desk review and a copy provided to the subrecipient at the time of the visit. f. Within 2 weeks of the monitoring visit, the City of Vallejo will provide a follow up letter indicating:
i.Whether or not the subrecipient was found to be in compliance with DOJ guidelines. ii.Any corrective actions to be taken, if appropriate.
g. The monitoring visit checklist and follow up letter will be maintained by the City of Vallejo in the appropriate grant files.

CONSENT CALENDAR 8.H.

DATE: July 26, 2022
TO: Mayor and Members of the City Council
FROM: Melissa L. Tigbao, Public Works Director
SUBJECT: ADOPT RESOLUTION ACCEPTING THE SUBDIVISION IMPROVEMENTS FOR THE WATERSTONE PHASE 1C (BORDONI RANCH) SUBDIVISION AS COMPLETE AND

AUTHORIZING THE CITY CLERK TO FILE A NOTICE OF COMPLETION WITH THE

OFFICE OF THE RECORDER FOR THE COUNTY OF SOLANO

RECOMMENDATION
Adopt the resolution accepting the subdivision improvements for the Waterstone Phase 1C (Bordoni Ranch) subdivision as complete and authorizing the City Clerk to file a Notice of Completion with the Office of the Recorder for the County of Solano.

REASONS FOR RECOMMENDATION
The Developer, KB Homes South Bay, Inc., has completed the improvements for the Waterstone Phase 1C per the Phase 1C Subdivision Improvement Agreement executed on June 28, 2017. The Developer has requested that the City accept the subdivision and release the security bonds. The City Engineer has determined that the work has been completed in accordance with the plans and specifications.

BACKGROUND AND DISCUSSION
On July 24, 2012, the City Council approved Resolution 12-115 N.C. authorizing the City Manager to sign the Master Subdivision Improvement Agreement and all subsequent Subdivision Improvement Agreements for the Waterstone Subdivision. On June 28, 2017, the Subdivision Improvement Agreement for Waterstone Phase 1C Subdivision was signed by the City Manager.

All sanitary sewer and storm drainage work in said developments has been completed in conformance with the improvement plans and specifications of the Vallejo Flood and Wastewater District. The City Engineer has determined that the subdivision improvements, which consist of onsite and offsite grading, street and sidewalk improvements, street monuments, streetlights, public water, and landscaping, have been completed in accordance with the plans and specifications and the obligations of the agreement have been met.

FISCAL IMPACT
Maintenance of all streets within the Waterstone Phase 1C Subdivision will be the responsibility of the City of Vallejo Public Works Department.

No other fiscal impacts are anticipated.

The Developer was not able to complete this project within the required two-year period. According to Resolution 02-55 N.C. the Developer must pay $32,072.55 to the City for Time Extension Fees prior to acceptance of this project. This fee is equal to ten percent (10%) per year of the original fees collected, starting two years after approval of the subdivision for construction. The Developer has paid this Time Extension Fee.

Date: July 26, 2022
Subject: ADOPT RESOLUTION ACCEPTING THE SUBDIVISION IMPROVEMENTS FOR THE WATERSTONE PHASE 1C (BORDONI RANCH) SUBDIVISION AS COMPLETE AND

AUTHORIZING THE CITY CLERK TO FILE A NOTICE OF COMPLETION WITH

THE OFFICE OF THE RECORDER FOR THE COUNTY OF SOLANO

Page 2 ends

The Developer also has provided three Warranty Bonds: (1) in the amount of $427,825.00, for in-tract improvements; (2) in the amount of $191,207.00 for off-site improvements; and (3) in the amount of $21,321.00 for public landscape improvements. The bonds are for a period of two years after acceptance by the City.

ENVIRONMENTAL REVIEW
The Environmental Impact Report for this development was certified by the City Council on July 26, 2005.

ATTACHMENTS

1. RESO Accepting Subdivision Improvements for Waterstone Phase 1C_CAO Stamp

2. Exhibit A to Resolution Accepting Subdivision Improvements for Waterstone Phase 1C

3. Location Map Waterstone Phase 1C-Bordoni Ranch

CONTACT
Melissa L Tigbao, Public Works Director, (707) 648-4085 [email protected]
RESOLUTION NO. 22- N.C.

A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF VALLEJO ACCEPTING THE SUBDIVSION IMPROVEMENTS FOR THE WATERSTONE PHASE 1C (BORDONI RANCH) SUBDIVISION

AS COMPLETE AND AUTHORIZING THE CITY CLERK TO FILE A NOTICE OF COMPLETION

WITH THE OFFICE OF THE RECORDER FOR THE COUNTY OF SOLANO WHEREAS, pursuant to the certain subdivision improvement agreement by and between the City of Vallejo and KB Homes South Bay, Inc. dated June 28, 2017, roadway and sidewalk improvements, street monuments, streetlights, public water, sewer, storm drain system and landscaping improvements, as detailed in the Exhibit A, attached hereto and incorporated herein by reference, were required to be constructed in and on the reserves and easements in and adjacent to the development known as Waterstone Unit 1C Subdivision in Vallejo, Solano County, California; and
WHEREAS, said subdivision improvements for the Waterstone Unit Phase 1C subdivision have been completed in accordance with the Plans and Specifications approved by the City Engineer; and WHEREAS, all sanitary sewer and storm drainage work in said developments have been completed in conformance with the improvement plans and specifications of the Vallejo Flood and Wastewater District, the same having been reviewed, inspected, acknowledged and approved by the District; and WHEREAS, developer KB Homes South Bay, Inc. was unable to complete this project within the required two- year period and, per City Council Resolution No.02-55, was required to pay and has paid $32,072.55 to the City of Vallejo for time extension fees.

IT IS HEREBY RESOLVED that the City Council of the City of Vallejo finds that those roadway improvements and other works of improvement as described in Exhibit A are hereby accepted as complete on this day July 26, 2022 and that the City Clerk is hereby authorized and directed to file a notice of completion with the Office of the Recorder of Solano County, California.

Adopted by the Council of the City of Vallejo at a regular meeting held on July 26, 2022 with the following vote:

ATTACHMENT 2
C
1Waterstone Phase 1C
EH
CONSENT CALENDAR 8.I.

DATE: July 26, 2022
TO: Mayor and Members of the City Council
FROM: Gillian Hayes, Assistant City Manager
SUBJECT: ADOPT A RESOLUTION TO AMEND THE FISCAL YEAR 2022-23 GENERAL FUND

BUDGET ADDING A LIMITED-TERM SPECIAL ADVISOR TO THE CITY MANAGER TO

OVERSEE ECONOMIC DEVELOPMENT DIVISION

RECOMMENDATION
Adopt a resolution to amend the General Fund budget adding a limited-term position of Special Advisor to the City Manager to oversee the Economic Development Division, effective August 1, 2022 through August 1, 2023.

REASONS FOR RECOMMENDATION
In order to provide a better long-term solution to the City’s needs, and in recognition of the growth of the vital services required for the City’s economic development projects, staff is recommending amending the General Fund by adding one limited-term position (1 year) Special Advisor to the City Manager and removing 1 FTE Economic Development Manager and 1 FTE Landscape Inspector.

BACKGROUND AND DISCUSSION
As City management staff assesses our overall city staffing needs, we are embarking on a Recruitment and Retention Plan to address hiring qualifies staff and retaining them. At the same time, we are assessing vacant positions and increasing efficiencies in staffing. While this plan is underway, we are keenly aware of several key positions that cannot wait for the plan to be completed. Council has already been notified of the Communications dispatch staff needs, and now we are bringing this position, Special Advisor to the City Manager, for consideration as well, in order to keep moving forward the City’s most crucial work: Economic Development. Currently, the Assistant City Manager (ACM) is holding this position on top of the ACM position.

In order to provide a better long-term solution to the City’s needs, and in recognition of the growth in number of scope of the City’s active economic development projects and Economic Development being the City Council’s top goal for Fiscal Year 22-23, staff recommends adopting a resolution to amend the General Fund.

On July 12, 2022 the City Council was provided with notice of intent to amend the General Fund. Additionally, at that meeting the Council approved to adopt a resolution to amend the City’s Salary Plan by adding a limited- term position of Special Advisor to the City Manager for a period of 1 year, with the ability to extend no more than 5 years. This classification specification currently exists in the Unrepresented group.

Over the last year, there have been several positions that have been increasingly hard to recruit and fill. The Economic Development Manager has had a continuous recruitment without attaining an experienced applicant pool. Instead of filling a division manager position with an under-qualified person, City Management staff are recommending a Special Advisor to the City Manager position to be added to oversee the Economic Development Division. This will allow for more competitive pay to be offered for the highly technical position.

The Special Advisor to the City Manager position has existed the last couple of years in the City Manager’s Office, overseeing the Economic Development Division.

Date: July 26, 2022
Subject: ADOPT A RESOLUTION TO AMEND THE FISCAL YEAR 2022-23 GENERAL FUND

BUDGET ADDING A LIMITED-TERM SPECIAL ADVISOR TO THE CITY MANAGER

TO OVERSEE ECONOMIC DEVELOPMENT DIVISION

Page 2 ends

Vallejo City CouncilJuly 26, 2022

Vallejo City Council
July 26, 2022