Bell City Council
August 28, 2024

4866-9516-8722v1/201014-0001
ATTACHMENTS:

1. Good Faith Estimates

2. Resolution of the Board of Directors First District Consolidated Oversight Board

3. Draft Resolution of the Successor Agency to the Bell Community Redevelopment Agency

4. Form of Indenture of Trust

5. Form of Escrow Agreement

6. Form of Bond Purchase Agreement

7. Form of Continuing Disclosure Agreement

Stradling Draft of June 28, 2024
4887-3658-3627v3/201014-0001
RESOLUTION NO. OB-24-02

A RESOLUTION OF THE LO S ANGELES COUNTY FIRST

SUPERVISORIAL DISTRICT CONSOLIDATED OVERSIGHT

BOARD APPROVING THE ISSUANCE AND SALE OF TAX

ALLOCATION REFUNDING BONDS BY THE SUCCESSOR
AGEN

CY TO THE BELL COMMUNITY REDEVELOPMENT

AGENCY AND AUTHORIZING CERTAIN OTHER ACTIONS IN

CONNECT

ION THEREWITH
WHEREAS, t
he First Supervisorial District Consolidated Oversight Board (the “Oversight Board”) is an agency created to oversee the Successor Agency to the Bell Community Redevelopment Agency (the “Successor Agency”); and WHEREAS, the Bell Community Redevelopment Agency (the “Prior Agency”) was a public body, corporate and politic, duly created, established and authorized to transact business and exercise its powers under and pursuant to the provisions of the Community Redevelopment Law (Part 1 of Division 24 of the Health and Safety Code of the State of California) (the “ Law”), and the powers of the Prior Agency included the power to issue bonds for any of its corporate purposes; and
WHEREAS, the Redevelopment Plan for the Bell Redevelopment Project Area was adopted and approved, and amended from time to time, in compliance with all requirements of the Law, and all requirements of law for and precedent to the adoption and approval of the Redevelopment Plan, as amended, have been duly complied with; and WHEREAS, the Prior Agency previously issued the $27,925,000 Bell Community Redevelopment Agency Bell Redevelopment Project Area Tax Allocation Refunding Bonds Issue of 2003 (the “Prior Bonds”); and
WHEREAS, on June 28, 2011, the California Legislature adopted ABx1 26 (the “Dissolution Act”) and ABx1 27 (the “Opt-in Bill”); and WHEREAS, the California Supreme Court subsequently upheld the provisions of the Dissolution Act and invalidated the Opt-in Bill resulting in the dissolution of the Prior Agency as of February 1, 2012; and
WHEREAS, the powers, assets and obligations of the Prior Agency were transferred on February 1, 2012 to the Successor Agency to the Bell Community Redevelopment Agency (the “Successor Agency”); and
WHEREAS, on or about June 27, 2012, AB1484 was adopted as a trailer bill in connection with the 2012-13 California Budget; and
WHEREAS, California Health and Safety Code Section 34177.5(a)(1) authorizes successor agencies to refund outstanding bonds or other indebtedness provided that:
(i) the total interest cost to maturity on the refunding bonds or other indebtedness, plus the principal amount of the refunding bonds or other indebtedness, does not exceed the total remaining interest cost to maturity on the bonds or other indebtedness to be refunded, plus

2 4887-3658-3627v3/201014-0001
the remai
ning principal of the bonds or other indebtedness to be refunded; and (ii) the principal amount of the refunding bonds or other indebtedness does not exceed the amount required to defease the bonds or other indebtedness to be refunded, to establish customary debt service reserves and to pay related costs of issuance; and WHEREAS, California Health and Safety Code Section 34177.5(a)(1) further provides that a successor agency may pledge to the refunding bonds or other indebtedness the revenues pledged to the bonds or other indebtedness being refunded, and that pledge, when made in connection with the issuance of such refunding bonds or other indebtedness, shall have the same lien priority as the pledge of the bonds or other obligations to be refunded, and shall be valid, binding, and enforceable in accordance with its terms; and WHEREAS, the Successor Agency now desires to authorize and approve the issuance of tax allocation refunding bonds (the “ 2024 Bonds”) in an aggregate principal amount sufficient to refund all or a portion of the Prior Bonds, and to irrevocably set aside a portion of the proceeds of such 2024 Bonds in a separate segregated trust fund which will be used to refund the outstanding Prior Bond s being refunded, to pay costs in connection with the issuance of the 2024 Bonds and to make certain other deposits as required by the Indenture (as defined below); and
WHEREAS, the 2024 Bonds shall be secured by a pledge of property tax revenues as authorized by California Health and Safety Code Section 34177.5(a)(1), pursuant to the provisions of Article 11 of Chapter 3 of Part 1 of Division 2 of Title 5 of the California Government Code (the “Bond Law”); and
WHEREAS, this Oversight Board desires to approve all matters relating to the issuance and sale of the 2024 Bonds as required by Sections 34177.5 (f) and 34180 of the Health and Safety Code of the State of California.

NOW THEREFORE, THE LOS ANGELES COUNTY FIRST SUPERVISORIAL

DISTRICT CONSOLIDATED OVERSIGHT BOARD DOES HEREBY RESOLVE AND FIND AS FOLLOWS:

SECTION 1. Each of the foregoing recitals is true and correct.

SECTION 2. The issuance by the Successor Agency of the 2024 Bonds in an aggregate principal amount sufficient to refund all or a portion of the Prior Bonds for the purpose of achieving debt service savings in accordance with Health & Safety Code Section 34177.5(a)(1) and the pledge to the 2024 Bonds of property tax revenues pursuant to the Indenture approved by Section 3 of the Successor Agency Resolution (as authorized by California Health and Safety Code Section 34177.5(a)(1)) is hereby approved. The 2024 Bonds may be issued as taxable or tax-exempt bonds as a single issue, or from time to time in separate series, as the Successor Agency shall determine. The approval of the issuance of the 2024 Bonds by the Successor Agency and the Oversight Board shall constitute the approval of each and every separate series of 2024 Bonds and the sale of the 2024 Bonds at a public or private sale.

SECTION 4. The Successor Agency is authorized and directed to prepare, approve and execute such other documents, including, as necessary, a Bond Purchase Agreement ,

3 4887-3658-3627v3/201014-0001
a private placement memorandum, a Preliminary Official Statement and final Official Stat
ement, a Continuing Disclosure Agreement , an Escrow Agreement for the Prior Bonds and any addi
tional agreements as may be required to carry out the purposes hereof without the need for any further approval from the Oversight Board.

SECTION 5. The Chair of the Oversight Board and the other officers and members of staf
f having responsibility for the affairs of the Oversight Board are hereby authorized and directed to execute such documents and certificates as they determine are necessary or appropriate to assist the Successor Agency in the issuance of the 2024 Bonds.

SECTION 6. Pursuant to the provisions of California Health and Safety Code Secti
on 34177.5(f), the Successor Agency is expressly authorized to recover its related cost
s in connection with the transaction approved hereby, irrespective of whether the 2024 Bonds are issued.

SECTION 6. This Resolution shall take effect in accor dance with Health and Safety Code Section 34179(h).

PASSED, APPROVED AND ADOPTED this 27 th
day of August, 2024 by the
following vote:

Ayes:

Noes:

Abstain:

Absent:

Steve Koffroth, Chair
Los Angeles County First Supervisorial
District Consolidated Oversight Board
ATTEST:

Deputy Clerk
Los Angeles County First Supervisorial
District Consolidated Oversight Board

Successor Agency to the Bell Community
Redevelopment Agency
Issuance and Sale of Tax Allocation Refunding Bonds
Wednesday, August 28th, 2024
Presented By:

Michael L. Antwine II, City Manager

Bond Team:
•Financial Advisor
• Willdan Financial Services
•Underwriter/Placement Agent
• Raymond James
•Fiscal Consultant
• HDL
•City Staff
• City Manager and Finance Director
•Bond Counsel
• Stradling Yocc a Carlson Rauth

History and Background
 City wants to refinance: Bell Community Redevelopment Agency Bell Redev
elopment Project Area Tax Allocation Refunding Bonds Issue of 2003 (the “Prior Bonds”) currently outstanding in the amount of $7,045,000 and maturing in 2033
 The Agency believes that the following properties (all located in the City of Bell) were acq
uired using proceeds of the Prior Bonds: 7020 Atlantic Ave., 7030 Atlantic Ave., 4738 Florence., 4560 Gage Ave., 6414 Clarkson Ave., 4472 Gage Ave., 6415 Atlantic Ave., 4014 Gage Ave., and 4022 Gage Ave. (collectively, the “Properties”).  Purpose for this financing is to refinance tax-ex empt bonds whose proceeds purchased real estate property with taxable bonds.  Taxable bonds afford the successor agency the flexibility to sell properties to pr
ivate parties without triggering a taxable event.
 The successor agency properties can be sold to encourage redevelopment without a taxable event if new deal is taxable. The sold properties will be redeveloped into taxable properties which will generate revenue benefits (property tax, sales tax, etc).

Pros & Cons
Factors that influenced how/why we are moving forwards
with the deal
 Disposition of Real Property
 It would be very cumbersome, restrictive and unrealistic & reduce the feas
ibility of projects for which the City desired to utilize any real property purchased with the Tax-Exempt bonds for a private purpose related to Economic Development
 Savings
 The new transaction will have annual cashflow savings not net present valu
e (NPV) savings and will meet the refunding provisions of AB 26 law  Other participating taxing entities will benefit from annual debt service saving
s and property sales

Financial Analysis
 Why Taxable?
 Successor Agency statute with respect to TAB refunding bonds doesn’t require NPV savings.  The principle & interest to maturity on refunding bonds has to be less than the principal & interest to matu
rity on the refunded bonds (bonds to be taken out).
 City can’t issue more than refinancing the existing debt (this is the test). The gross savings, the nomin
al cashflow savings satisfies this test. Savings can be gross not NPV  We will use reserve fund as part of available cash to finance the deal in order to potentially create cashf
low savings
 If the Bonds remain outstanding as tax-ex empt the City can’t sell these properties for taxable purposes.
 The proposed taxable refinancing is not primarily based on potential savings to the city. The primary purp
ose is to allow the City to sell properties purchased with Tax Exempt Bond funds for a future Economic Development purpose.
 These properties once sold will be able to generate property tax and sales tax revenue to the City.

Financial Analysis - continued
 Public Sale vs. Private Placement
 Public Issuance Process:
 Take longer to complete
 Costs more based on additional processed required
 Ability to reach out to more financial institutions and investors for lowest interest rat
e.
 Private Placement Process:
 solicit several Banks (5 to 6 institutions)
 present them with information (coverage, etc.)
 they respond with rate they are willing to purchase a placement directly from SA  deals shorter than 20-15 years, no larger than 20-30million, usually lower.

Appropriate for this deal.
 Current Private Placement offers are more favorable than public offering  Capital One-dec lined, Webster Bank-prelim rate (mid-4s)  Will solicit more bids after receiving Fiscal Consultant report

Important Dates & Anticipated Timeline
• Approval by the LA County Oversight Board on August 27th • Approving documents by the Successor Agency on August 28th • HDL - Fiscal Consultant hired
DOF
has 65 day waiting period
 Public sale during timeframe- fini sh fiscal consultant report and POS
 Private Placement- we need t o have the fiscal consultant report for bank bids (part of credit package we send out for bids)

Development Impact Fee Study
City of Bell

2 What is a Development
Impact Fee?
1One-time charge
Imposed at building permit stage
Imposed on all development projects within
a defined geographic area
Not a special tax or assessment
Not subject to Proposition 218
approval requirements

Mitigation Fee Act Findings
(Govt. Code §66001)
 Key findings
‒ Need: Development need for facilities
 Benefit: Development use of revenue
 Rough Proportionality: Fee amount
development’s share of facility costs
 Other findings
 Purpose of fee
 Use of fee revenue
3

Business Confidential - Willdan
AB 602
 Technical changes:
o Residential fees should be charged
per
square foot, unless findings are
supported that justify another metric
o Large jurisdictions shall adopt a
capi
tal improvement plan as a part
of the nexus study
o Nexus study should identify level of
ser
vice
o If fees are increasing, review the
ass
umptions of the original nexus
study and evaluate the amount of
fees collected under the original fee
 Requires local jurisdictions
to make certain information
available on website:
o Current impact fee schedule
o Nexus studies
o Annual AB1600 reports
o Five-Year AB1600 reports
 Changes to impact fee
adoption process:
o Prior to adoption of
developm
ent fees, an impact
fee nexus study needs to be
adopted with 30 days notice

Business Confidential - Willdan
Sheetz Decision
 The Supreme Court held that legislatively adopted
exactions like fee programs are not exempt from
constitutional scrutiny (nexus and proportionality)
 The Court did not evaluate whether El Dorado
County’s nexus analysis met those requirements
 The case has been remanded to California courts
for further proceedings

Impact Fee Approach
Final Report
Planned Facilities
& Costs
Funding &
Financing
Implementation
Strategy
Cost Allocation &
Fee Schedule
Public Hearing
& Adoption
Facility Standards
Existing Development
& Facilities
Future Growth
6

Impact Fee Categories
 Park and Recreation Facilities
 Parking In-lieu
 Public Protection Facilities
 Sewer Facilities
 General Government Facilities
 Transportation Facilities

Maximum Justified Fees

Fee Per Home or Commercial Increment

Fee Comparison, SF Residential

Questions

CITY OF BELL

DEVELOPMENT IMPACT FEE NEXUS STUDY

DRAFT

JUNE 12, 2024

Oakland Office Corporate Office Other Regional Offices
66 Franklin Street 27368 Via Industria Aurora, CO
Suite 300 Suite 200 Orlando, FL
Oakland, CA 94607 Temecula, CA 92590 Phoenix, AZ
Tel: (510) 832-0899 Tel: (800) 755-6864 Plano, TX
Fax: (888) 326-6864
Washington, DC
www.willdan.com

This page intentionally left blank.

i

TABLE OF CONTENTS
EXECUTIVE SUMMARY .................................................................................... 3 Background and Study Objectives 3
Facility Standards and Costs 3
Use of Fee Revenues 4
Development Impact Fee Schedule Summary 4

1. INTRODUCTION .................................................................................... 5 Public Facilities Financing in California 5
Study Objectives 5
Fee Program Maintenance 6
Study Methodology 6
Types of Facility Standards 6
New Development Facility Needs and Costs 7
Organization of the Report 8

2. GROWTH FORECASTS .......................................................................... 9 Land Use Types 9
Impact Fees for Accessory Dwelling Units 9
Existing and Future Development 10
Occupant Densities 11

3. TRANSPORTATION FACILITIES ............................................................. 13 Trip Demand 13
Trip Demand Growth 14
Existing Facilities 15
Fee per Trip Demand Unit 15
Planned Projects 16
Fee Schedule 16

4. PARKS AND RECREATION FACILITIES .................................................. 18 Service Population 18
Existing Park and Recreation Facilities Inventory 18
Parkland and Park Facilities Unit Costs 19
Parkland and Park Facility Standards 20
Mitigation Fee Act 20
Quimby Act 21
City of Bell Parkland and Park Facilities Standards 21
Facilities Needed to Accommodate New Development 21
Parks and Recreation Facilities Cost per Capita 22
Use of Fee Revenue 23
Fee Schedule 24

5. GENERAL GOVERNMENT FACILITIES ................................................... 26 Service Population 26
Existing Facilities Inventory 27

City of Bell Development Impact Fee Nexus Study
ii

Cost Allocation 28
Fee Revenue Projection 28
Capital Improvement Plan 28
Fee Schedule 29

6. PARKING FACILITIES .......................................................................... 30 Parking Requirements 30
Parking Facilities Unit Costs 30
Use of Fee Revenue 31
Fee Schedule 31

7. PUBLIC SAFETY FACILITIES ................................................................ 33 Service Population 33
Existing Facility Inventory 34
Planned Facilities 34
Cost Allocation 35
Existing Level of Service 35
Fee Revenue Projection 35
Fee Schedule 36

8. SEWER FACILITIES ............................................................................. 37 Sewer Demand 37
EDU Generation by New Development 37
Existing Facilities 38
Facility Needs and Costs 38
Cost per EDU 40
Fee Schedule 40

9. AB 602 REQUIREMENTS .................................................................... 42 Compliance with AB 602 42
66016.5. (a) (2) - Level of Service 42
66016.5. (a) (4) – Review of Original Fee Assumptions 42 66016.5. (a) (6) – Capital Improvement Plan 42

10. IMPLEMENTATION ............................................................................... 43 Impact Fee Program Adoption Process 43
Inflation Adjustment 43
Reporting Requirements 43
Programming Revenues and Projects with the CIP 45

11. MITIGATION FEE ACT FINDINGS .......................................................... 46 Purpose of Fee 46
Use of Fee Revenues 46
Benefit Relationship 46
Burden Relationship 47
Proportionality 47

3 Executive Summary
This report summarizes an analysis of development impact fees needed to support future development in the City of Bell through 2045. It is the City’s intent that the costs representing future development’s share of public facilities and capital improvements be imposed on that development in the form of a development impact fee, also known as a public facilities fee. The public facilities and improvements included in this analysis are divided into the fee categories listed below:
§ Transportation Facilities
§ Parks and Recreation Facilities
§ General Government Facilities
§ Parking Facilities
§ Public Safety Facilities
§ Sewer Facilities
Background and Study Objectives
The primary policy objective of a development impact fee program is to ensure that new development pays the capital costs associated with growth. Although growth also imposes operating costs, there is not a similar system to generate revenue from new development for services. The primary purpose of this report is to calculate and present fees that will enable the City to expand its inventory of public facilities, as new development creates increases in service demands.

The City collects public facilities fees under authority granted by the Mitigation Fee Act (the Act), contained in California Government Code Sections 66000 et seq . Th is report provides the necessary findings required by the Act for adoption of the fees presented in the fee schedules contained herein.

Facility Standards and Costs
There are three approaches commonly used to calculate facilities standards and allocate the costs of planned facilities to accommodate growth in compliance with the Mitigation Fee Act requirements in this study.

The existing inventory approach is based on a facility standard derived from the City’s existing level of facilities and existing demand for services. This approach results in no facility deficiencies attributable to existing development. This approach is often used when a long-range plan for new facilities is not available. Future facilities to serve growth will be identified through the City’s two - year CIP and budget process and/or completion of a new facility master plan. This approach is used to calculate the general government and parks and recreation facilities fees in this report.

The planned facilities approach allocates costs based on the ratio of planned facilities that serve new development to the increase in demand associated with new development. This approach is appropriate when specific planned facilities that only benefit new development can be identified, or when the specific share of facilities benefiting new development can be identified. This approach is also used to support a specific demand standard identified by policy in a City’s General Plan. This approach is used for the transportation facilities fees in this report.

City of Bell Development Impact Fee Nexus Study

4 The system plan approach is based on a master facility plan in situations where specific needed facilities serve both existing and new development. This approach allocates existing and planned facilities across existing and new development to determine new development’s fair share of facility needs. This approach is used when it is not possible to differentiate the benefits of new facilities between new and existing development. This approach is used to calculate the public safety fee in this report.

Use of Fee Revenues
Impact fee revenue must be spent on new facilities or expansion of current facilities to serve new development. Facilities can be generally defined as capital acquisition items with a useful life greater than five years. Impact fee revenue can be spent on capital facilities to serve new development, including but not limited to land acquisition, construction of buildings, construction of infrastructure, the acquisition of vehicles or equipment , information technology, software licenses and equipment.

In that the City cannot predict with certainty how and when development within the City will occur during the planning horizon assumed in this study, the City may need to update and revise the project lists funded by the fees documented in this study. Any substitute projects should be funded within the same facility category, and the substitute projects must still benefit and have a relationship to new development. The City could identify any changes to the projects funded by the impact fees when it updates the CIP. The impact fees could also be updated if significant changes to the projects funded by the fees are anticipated.

Development Impact Fee Schedule Summary
Table E.1 summarizes the development impact fees that meet the City’s identified needs and comply with the requirements of the Mitigation Fee Act.

Table E.1: Maximum Justified Impact Fee Summary
Land Use Traffic Facilities
Parks and
Recreation
Facilities 1
General
Government
Parking In
Lieu Public Safety Sewer
Total
(Onsite
Parking)2
Residential - Fee per Square Foot
Single Family $7.55 $3.02 $1.18 $50.18 $1.39 $1.01 $14.15 Multifamily $10.12 $4.63 $1.80 $100.36 $2.13 $2.02 $20.70 Nonresidential - Fee per 1,000 Sq. Ft.

Commercial $21.19 $0.00 $0.35 $112.91 $0.12 $0.91 $22.57 Office $21.19 $0.00 $0.54 $112.91 $0.18 $1.14 $23.05
Industrial $12.99 $0.00 $0.19 $112.91 $0.06 $0.45 $13.69 Sources: Tables 3.5, 4.9, 5.5.
1 Mitigation Fee Act fee shown. Quimby fees in lieu of parkland dedication only apply to development occurring in subdivisions. Quimby in-lieu fees are $16.86 psf37,884 for single family units and $23.50 psf for multifamily units.
2 Assumes that development project provides parking onsite. Maximum justified fee of $28,122 in-lieu of providing one space onsite. Refer to City's municipal code parking standards for detailed parking requirements.

5 1. Introduction
This report presents an analysis of the need for public facilities to accommodate new development in the City of Bell. This chapter provides background for the study and explains the study approach under the following sections:
§ Public Facilities Financing in California;
§ Study Objectives;
§ Fee Program Maintenance;
§ Study Methodology; and
§ Organization of the Report.

Public Facilities Financing in California
The changing fiscal landscape in California during the past 40 years has steadily undercut the financial capacity of local governments to fund infrastructure. Three dominant trends stand out:
§ The passage of a string of tax limitation measures, starting with Proposition 13 in 1978 and continuing through the passage of Proposition 218 in 1996; § Declining popular support for bond measures to finance infrastructure for the next generation of residents and businesses; and
§ Steep reductions in federal and state assistance.

Faced with these trends, many cities and counties have had to adopt a policy of “growth pays its own way.” This policy shifts the burden of funding infrastructure expansion from existing ratepayers and taxpayers onto new development. This funding shift has been accomplished primarily through the imposition of assessments, special taxes, and development impact fees also known as public facilities fees. Assessments and special taxes require the approval of property owners and are appropriate when the funded facilities are directly related to the developing property. Development impact fees, on the other hand, are an appropriate funding source for facilities that benefit all development jurisdiction -wide. Development impact fees need only a majority vote of the legislative body for adoption.

Study Objectives
The primary policy objective of a public facilities fee program is to ensure that new development pays the capital costs associated with growth. The primary purpose of this report is to establish impact fees for the City based on the most current available facility plans and growth projections.

The maximum justified fees will enable the City to expand its inventory of public facilities as new development leads to increases in service demands.

The City can collect public facilities fees under authority granted by the Mitigation Fee Act (the Act), contained in California Government Code Sections 66000 et seq. This report provides the necessary findings required by the Act for adoption of the fees presented in the fee schedules presented in this report.

Bell is forecast to see moderate growth through this study’s planning horizon of 2045. This growth will create an increase in demand for public services and the facilities required to deliver them.

Given the revenue challenges described above, Bell has decided to use a development impact fee program to ensure that new development funds its share of facility costs associated with growth. This report makes use of the most current available growth forecasts and facility plans to

City of Bell Development Impact Fee Nexus Study

6 update the City’s existing fee program to ensure that the fee program accurately represents the facility needs resulting from new development.

Fee Program Maintenance
Once a fee program has been adopted it must be properly maintained to ensure that the revenue collected adequately funds the facilities needed by new development. To avoid collecting inadequate revenue, the inventories of existing facilities and costs for planned facilities must be updated periodically for inflation, and the fees recalculated to reflect the higher costs. The use of established indices for each facility included in the inventories (land, building s, and equipment), such as the Engineering News-Record, is necessary to accurately adjust the impact fees. For a list of recommended indices, see Chapter 10.

While fee updates using inflation indices are appropriate for annual or periodic updates to ensure that fee revenues keep up with increases in the costs of public facilities, it is recommended to conduct more extensive updates of the fee documentation and calculation when significant new data on growth forecasts and/or facility plans become available. For further detail on fee program implementation, see Chapter 10.

Study Methodology
Development impact fees are calculated to fund the cost of facilities required to accommodate growth. The six steps followed in this development impact fee study include:

1. Estimate existing development and future growth: Identify a base year for existing development and a growth forecast that reflects increased demand for public facilities;

2. Identify facility standards: Determine the facility standards used to plan for new and expanded facilities;

3. Determine facilities required to serve new development: Estimate the total amount of planned facilities, and identify the share required to accommodate new development;

4. Determine the cost of facilities required to serve new development: Estimate the total amount and the share of the cost of planned facilities required to accommodate new development;

5. Calculate fee schedule: Allocate facilities costs per unit of new development to calculate the development impact fee schedule. Calculate fees per square foot of residential by dividing fee per unit by average unit square footage; and

6. Identify alternative funding requirements: Determine if any non -fee funding is required to complete projects.

The key public policy issue in development impact fee studies is the identification of facility standards (step #2, above). Facility standards document a reasonable relationship between new development and the need for new facilities. Standards ensure that new development does not fund deficiencies associated with existing development.

Types of Facility Standards
There are three separate components of facility standards:
§ Demand standards determine the amount of facilities required to accommodate growth, for example, park acres per thousand residents, square feet of library space per capita, or gallons of water per day. Demand standards may also reflect a level of service such as the vehicle volume-to-capacity (V/C) ratio used in traffic planning.

City of Bell Development Impact Fee Nexus Study

7 § Design standards determine how a facility should be designed to meet expected demand, for example, park improvement requirements and technology infrastructure for City office space. Design standards are typically not explicitly evaluated as part of an impact fee analysis but can have a significant impact on the cost of facilities. Our approach incorporates the cost of planned facilities built to satisfy the City’s facility design standards.
§ Cost standards are an alternate method for determining the amount of facilities required to accommodate growth based on facility costs per unit of demand. Cost standards are useful when demand standards were not explicitly developed for the facility planning process. Cost standards also enable different types of facilities to be analyzed based on a single measure (cost or value ) and are useful when different facilities are funded by a single fee program. Examples include facility costs per capita, cost per vehicle trip, or cost per gallon of water per day.

New Development Facility Needs and Costs
Several approaches can be used to identify facility needs and costs to serve new development.

This is often a two -step process: (1) identify total facility needs, and (2) allocate to new development its fair share of those needs.

There are three common methods for determining new development’s fair share of planned facilities costs in this study: the existing inventory method, the planned facilities method, and the system plan method. Often the method selected depends on the degree to which the community has engaged in comprehensive facility master planning to identify facility needs.

The formula used by each approach and the advantages and disadvantages of each method is summarized below.

Existing Inventory Method
The existing inventory method allocates costs based on the ratio of existing facilities to demand from existing development as follows:

Current Value of Existing Facilities
Existing Development Demand
Under this method new development will fund the expansion of facilities at the same standard currently serving existing development. The existing inventory method results in no facility deficiencies attributable to existing development. This method is often used when a long -range plan for new facilities is not available. Future facilities to serve growth are identified through a biennial CIP and budget process, possibly after completion of a new facility master plan. This approach is used to calculate the general government and parks and recreation facilities fees in this report.

Planned Facilities Method
The planned facilities method allocates costs based on the ratio of planned facility costs to demand from new development as follows:

Cost of Planned Facilities
New Development Demand
This method is appropriate when planned facilities will entirely serve new development, or when a fair share allocation of planned facilities to new development can be estimated. This approach is appropriate when specific planned facilities that only benefit new development can be identified, or when the specific share of facilities benefiting new development can be identified. This approach is also used to support a specific demand standard identified by policy in a City’s General Plan. This approach is used for the transportation facilities fees in this report. = cost per unit of demand
= cost per unit of demand

City of Bell Development Impact Fee Nexus Study

8 System Plan Method
This method calculates the fee based on the value of existing facilities plus the cost of planned facilities, divided by demand from existing plus new development:

Value of Existing Facilities + Cost of Planned Facilities Existing + New Development Demand
This method is useful when planned facilities need to be analyzed as part of a system that benefits both existing and new development. It is difficult, for example, to allocate a new fire station solely to new development when that station will operate as part of an integrated system of fire stations that together achieve the desired level of service.

The system plan method ensures that new development does not pay for existing deficiencies.

Often facility standards based on policies such as those found in Comprehensive Plans are higher than the existing facility standards. This method enables the calculation of the existing deficiency required to bring existing development up to the policy -based standard. The local agency must secure non -fee funding for that portion of planned facilities required to correct the deficiency to ensure that new development receives the level of service funded by the impact fee.

This approach is used to calculate the public safety facilities fee in this report.

Organization of the Report
The determination of a public facilities fee begins with the selection of a planning horizon and development of growth projections for population and employment. These projections are used throughout the analysis of different facility categories and are summarized in Chapter 2.

Chapters 3 through 8 identify facility standards and planned facilities, allocate the cost of planned facilities between new development and other development, and identify the appropriate development impact fee for each of the following facility categories:
• Transportation Facilities
• Parks and Recreation Facilities
• General Government Facilities
• Public Safety Facilities
• Sewer Facilities
• Parking Facilities

Chapter 9 describes how this nexus study complies with the requirements of AB 602.

Chapter 10 details the procedures that the City must follow when implementing a development impact fee program. Impact fee program adoption procedures are found in California Government Code Sections 66016 through 66018.

The five statutory findings required for adoption of the maximum justified public facilities fees in accordance with the Mitigation Fee Act are documented in Chapter 11. = cost per unit of demand

9 2. Growth Forecasts
Growth projections are used as indicators of demand to determine facility needs and allocate those needs between existing and new development. This chapter explains the source for the growth projections used in this study based on a 2023 base year and a planning horizon of 2045.

Estimates of existing development and projections of future growth are critical assumptions used throughout this report. These estimates are used as follows:
§ The estimate of existing development in 2023 is used as an indicator of existing facility demand and to determine existing facility standards. § The estimate of total development at the 2045 planning horizon is used as an indicator of future demand to determine total facilities needed to accommodate growth and remedy existing facility deficiencies, if any. § Estimates of growth from 0223 through 2045 are used to (1) allocate facility costs between new development and existing development, and (2) estimate total fee revenues.

The demand for public facilities is based on the service population , dwelling units or nonresidential development creating the need for the facilities.

Land Use Types
To ensure a reasonable relationship between each fee and the type of development paying the fee, growth projections distinguish between different land use types. The land use types for which impact fees have been calculated for are defined below. § Residential dwelling units : All residential dwelling units including detached and attached one -unit dwellings ( Includes si ngle family homes and townhomes) and attached multifamily dwellings including duplexes and condominiums. Fees charged per square foot.
§ Commercial: All commercial, retail, educational, lodging, and service development. § Office: All general, professional, and medical office development. § Industrial: All warehouse, distribution, manufacturing, and other industrial development.

Some developments may include more than one land use type, such as a mixed-use development with both residential and commercial uses. In those cases, the facilities fee would be calculated separately for each land use type.

The City has the discretion to determine which land use type best reflects a development project’s characteristics for purposes of imposing an impact fee and may adjust fees for special or unique uses to reflect the impact characteristics of the use . If a project results in the intensification of use, at its discretion, the City can charge the project the difference in fees between the existing low intensity use and the future high intensity use.

Impact Fees for Accessory Dwelling Units
The California State Legislature recently amended requirements on local agencies for the imposition of development impact fees on accessory dwelling units (ADU) with Assembly Bill AB 68 in 2021. The amendment to California Government Code §65852.2(f)(2) stipulates that local agencies may not impose any impact fees on ADUs less than 750 square feet. ADU s greater

City of Bell Development Impact Fee Nexus Study

10 than 750 square feet can be charged impact fees in proportion to the size of the primary dwelling unit.

Calculating Impact Fees for Accessory Dwelling Units
For ADUs greater than 750 square feet, impact fees can be charged as a percentage of the single-family impact fee. The formula is:

In the case of an 800 square foot ADU and a 1,600 square foot primary r esidence, the impact fees would be 50 percent (800 square feet / 1,600 square feet = 50% ) of the single-family dwelling unit fee.

Existing and Future Development
Table 2.1 shows the estimated number of residents, dwelling units, employees, and building square feet in Bell, both in 2023 and in 2045 . The base year estimates of household residents and dwelling units is based upon data received from the California Department of Finance . The projection or residents is based on data from the Southern California Association of Governments (SCAG) Connect SoCal Demographic and Growth Forecast.

Base year employees were estimated based on the latest data from the US Census’ OnTheMap application and exclude local government (public administration) employees. Total projected workers were also identified in the SCAG Connect SoCal Demographic and Growth Forecast.

𝐴𝐷𝑈 𝑆𝑞𝑢𝑎𝑟𝑒 𝐹𝑒𝑒𝑡
𝑃𝑟𝑖𝑚𝑎𝑟𝑦 𝑅𝑒𝑠𝑖𝑑𝑒𝑛𝑐𝑒 𝑆𝑞𝑢𝑎𝑟𝑒 𝐹𝑒𝑒𝑡 × 𝑆𝑖𝑛𝑔𝑙𝑒 𝐹𝑎𝑚𝑖𝑙𝑦 𝐼𝑚𝑝𝑎𝑐𝑡 𝐹𝑒𝑒 = 𝐴𝐷𝑈 𝐼𝑚𝑝𝑎𝑐𝑡 𝐹𝑒𝑒

City of Bell Development Impact Fee Nexus Study

11 Table 2.1: Existing and New Development

Occupant Densities
All fees in this report are calculated based on dwelling units or building square feet. Occupant density assumptions ensure a reasonable relationship between the size of a development project, the increase in service population associated with the project, and the amount of the fee.

Occupant densities (residents per dwelling unit or workers per building square foot) are the most appropriate characteristics to use for most impact fees. The fee imposed should be based on the land use type that most closely represents the probable occupant density of the development.

The occupancy factors are shown in Table 2.2. The residential density factors are based on the most recent available data for Bell from California Department of Finance . The nonresidential occupancy factors are derived from data from the Institute of Traffic Engineers Trip Generation Manual, 11th Edition.
2023 2045 Increase
Residents 1 32,689 34,915 2,226
Dwelling Units2
Single Family 5,766 6,139 373
Multifamily 3,749 3,992 243
Total 9,515 10,131 616
Employment 3
Commercial 3,548 5,079 1,531
Office 4,572 6,545 1,973
Industrial 1,101 1,576 475
Total 9,221 13,200 3,979
1 Current population from California Department of Finance (DOF). Projection for 2045 calculated based on total single family and multifamily units in 2045, multiplied by estimates of 3.98 residents per single family unit and 3.05 residents per multifamily unit calculated from the 2022 American Community Survey data for Bell.

Sources: City of Bell Housing Element, 2021-2029; California Department of Finance (DOF), Table E-5, 2023; U.S. Census Bureau, OnTheMap Application, http://onthemap.ces.census.gov, 2023; Southern California Association of Governments (SCAG) Connect SoCal Demographics and Growth Forecast Technical Report, 2020; Willdan Financial Services.
2 Current values from DOF. Increase in new dwelling units assumes 28 new units per year, consistent with the annual dwelling unit increase assumed in the City's 2021-2029 Housing Element. Assumes existing ration of single family to multifamily units will be maintained. 3 Base year from US Census OnTheMap Application and excludes local government workers. Total in 2045 Identified in SCAG's Connect SoCal Demographic and Growth Forecast. Allocation to land uses at buildout based on current proportions.

City of Bell Development Impact Fee Nexus Study

12 Table 2.2: Occupant Density Assumptions

Residential
Single Family 3.98 Residents Per Dwelling Unit
Multifamily 3.05 Residents Per Dwelling Unit
Nonresidential
Commercial 2.12 Employees per 1,000 square feet
Office 3.26 Employees per 1,000 square feet
Industrial 1.16 Employees per 1,000 square feet
Sources: U.S. Census Bureau, 2022 American Community Survey 5-Year Estimates, Tables B25024 and B25033; ITE Trip Generation Manual, 11th Edition; Willdan Financial Services.

13 3. Transportation Facilities
This chapter details an analysis of the need for transportation facilities to accommodate new development. The chapter documents a reasonable relationship between new development and the impact fee for funding of these facilities.

Trip Demand
The need for transportation facilities is based on the trip demand placed on the system by development. A reasonable measure of demand is the number of average daily vehicle trips, adjusted for the type of trip. Vehicle trip generation rates are a reasonable measure of demand on the City’s system of street improvements across all modes because alternate modes (transit, bicycle, pedestrian) often substitute for vehicle trips.

The two types of trips adjustments made to trip generation rates to calculate trip demand are described below:
§ Pass-by trips are deducted from the trip generation rate. Pass -by trips are intermediates stops between an origin and a destination that require no diversion from the route, such as stopping to get gas on the way to work. § The trip generation rate is adjusted by the average length of trips for a specific land use category compared to the average length of all trips on the street system.

These adjustments allow for a holistic quantification of trip demand that takes trip purpose and length into account for fee calculation purposes.

Table 3.1 shows the calculation of trip demand factors by land use category based on the adjustments described above. Data is based on extensive and detailed trip surveys conducted in the Institute of Traffic Engineers (ITE) and by the San Diego Association of Governments (SANDAG). The trip rates come from ITE. The pass -by trip assumptions and trip length assumptions come from SANDAG. Data from SANDAG is used because t he surveys provide one of the most comprehensive databases available of trip generation rates, pass-by trips factors, and average trip length for a wide range of land uses.

City of Bell Development Impact Fee Nexus Study
14 Table 3.1: Trip Rate Adjustment Factors

Trip Demand Growth
The planning horizon for this analysis is 204 5. Table 3.2 lists the 2023 and 2045 land use assumptions used in this study. The trip demand factors calculated in are multiplied by the existing and future dwelling units and nonresidential square footage to determine the increase in trip demand attributable to new development.

Table 3.2: Land Use Scenario and Trip Demand

Primary
Trips1
Diverted
Trips1
Total
Excluding
Pass-by 1
Average
Trip
Length2
Adjust-
ment
Factor3 ITE Category
PM Peak
Hour
Trips4
Trip
Demand
Factor5
A B C = A + B D E = C x D F G = E x F
Residential
Single Family 86% 11% 97% 7.9 1.11 Single Family Housing (210) 1.00 1.11 Multifamily 86% 11% 97% 7.9 1.11 Apartment (220) 0.67 0.74 Nonresidential - per Employee
Commercial 47% 31% 78% 3.6 0.41 Shopping Center (820) 1.89 0.77 Office 77% 19% 96% 8.8 1.22 General Office (710) 0.45 0.55 Industrial 79% 19% 98% 9.0 1.28 General Light Industrial (110) 0.68 0.87 Nonresidential - per 1,000 Sq. Ft.

Commercial 47% 31% 78% 3.6 0.41 Shopping Center (820) 4.21 1.73 Office 77% 19% 96% 8.8 1.22 General Office (710) 1.42 1.73 Industrial 79% 19% 98% 9.0 1.28 General Light Industrial (110) 0.83 1.06 4 Trips per dwelling unit or per 1,000 building square feet. 5 The trip demand factor is the product of the trip adjustment factor and the trip rate.

Sources: San Diego Association of Governments, Brief Guide of Vehicular Traffic Generation Rates for the San Diego Region, April 2002; Institute of Traffic Engineers, Trip Generation, 10th Edition; Willdan Financial Services.
1 Percent of total trips. Primary trips are trips with no midway stops, or "links". Diverted trips are linked trips whose distance adds at least one mile to the primary trip. Pass-by trips are links that do not add more than one mile to the total trip. Based on SANDAG data. 2 In miles. Based on SANDAG data.
3 The trip adjustment factor equals the percent of non-pass-by trips multiplied by the average trip length and divided by the systemwide average trip length of 6.9 miles.

Trip 2023
Residential
Demand
Factor
Units /
Employees Trips
Units /
Employees Trips
Units /
Employees Trips
Residential - Dwelling Units
Single Family 1.11 5,766 6,400 373 414 6,139 6,814 Multifamily 0.74 3,749 2,788 243 181 3,992 2,969 Subtotal 9,515 9,188 616 595 10,131 9,783 Nonesidential - Employees
Commercial 0.77 3,548 2,749 1,531 1,187 5,079 3,936 Office 0.55 4,572 2,510 1,973 1,083 6,545 3,593 Industrial 0.87 1,101 958 475 414 1,576 1,372 Subtotal 9,221 6,217 3,979 2,684 13,200 8,901 Total 15,405 3,279 18,684

82.5% 17.5% 100%
Sources: Tables 2.1 and 3.1.

Growth 2023 to Buildout Total - Buildout

City of Bell Development Impact Fee Nexus Study
15 Existing Facilities
The City plans to use transportation facilities fee revenue to construct improvements to add capacity to the system of transportation facilities that serves new development. The City may only use impact fee revenue to provide facilities and intensify usage of existing facilities needed to serve new development. The City should program fee revenue to capacity expanding projects through its CIP and budget process. The City’s impact fee transportation CIP is shown in Table

3.3. Projects that are rehabbing or retrofitting existing facilities have been excluded from this list.

A share of each project corresponding with new development’s total share of trip demand at the planning horizon is allocated to new development through this impact fee. In total, approximately $3 million is allocated to new development through the impact fee.

Table 3.3: Transportation Project Costs and Allocation to New Development

Fee per Trip Demand Unit
Every impact fee consists of a dollar amount, representing the value of facilities, divided by a measure of demand. In this case, all fees are first calculated as a cost per trip demand unit. Then these amounts are translated into housing unit (cost per unit) and employment space (cost per 1,000 square feet) fees by multiplying the cost per trip by the trip generation rate for each land use category. These amounts become the fee schedule.

Table 3.4 displays the calculation of the cost per trip demand unit. The total cost allocated to new development from Table 3.3 is divided by the growth in trip demand from Table 3.2 to determine the cost per trip needed to accommodate new development. This figure drives the fee calculation.

Table 3.4: Cost per Trip for existing facilities

Quantity Unit cost
Total Replacement
Cost
Centerline Miles Streets 33.6 $ 2,053,571 69,000,000$ Traffic Signals 30 $200,000 6,000,000
Gage Avenue Bridge 30,000,000
Slauson Avenue Bridge 30,000,000
Florence Avenue Bridge 50,000,000
Total 185,000,000$
Sources: City of Bell Pavement Management Program Update 2022 - Final Report, May 2022; City of Bell; Willdan Financial Services.

Existing Facilities $ 185,000,000
Exisitng Trips 15,405
Cost per Trip 12,009$
Sources: Tables 3.2 and 3.3.

City of Bell Development Impact Fee Nexus Study
16 Planned Projects
The City plans to use transportation facilities fee revenue to construct improvements to add capacity to the system of transportation facilities that serves new development. The City may only use impact fee revenue to provide facilities and intensify usage of existing facilities needed to serve new development. The City should program fee revenue to capacity expanding projects through its CIP and budget process. The City’s impact fee transportation CIP is shown in Table

3.5. Projects that are rehabbing or retrofitting existing facilities have been excluded from this list.

Table 3.5: Planned Transportation Projects

Fee Schedule
Table 3. shows the maximum justified transportation facilities fee schedule. The City can adopt any fee up to these amounts. The maximum justified fees are based on the cost per trip identified in Table 3.4. The cost per trip is multiplied by the trip demand factors in Table 3.1 to determine a fee per unit of new development. The fee per dwelling unit is converted into a fee per square foot by dividing the fee per dwelling unit by the assumed average square footage of a dwelling unit.

The total fee includes a two percent (2%) administrative charge to fund costs that include: a standard overhead charge applied to all City programs for legal, accounting, and other departmental and administrative support, and fee program administrative costs including revenue collection, revenue, and cost accounting, mandated public reporting, and fee justification analyses.

In Willdan’s experience with impact fee programs, two percent of the base fee adequately covers the cost of fee program administration. The administrative charge should be reviewed and adjusted during comprehensive impact fee updates to ensure that revenue generated from the charge sufficiently covers, but does not exceed, the administrative costs associated with the fee program.

Total Project
Cost
Stop-Controlled Intersection Upgrade 214,300$
Florence Avenue Corridor Project 1,200,000
Traffic Signal Improvement Project 685,900
Total 2,100,200$
Sources: City of Bell Local Roadway Safety Plan, August 24, 2022; City of Bell; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
17 Table 3.6: Maximum Justified Transportation Facilities Impact Fee Schedule

A B C = A x B D = C x 0.02 E = C + D E / 1,000
PM Peak Fee
Land Use
Cost Per
Trip
Hour Trip
Rate Base Fee 1
Admin
Charge1, 2 Total Fee1
per Sq.

Ft.

Residential - per Dwelling Unit
Single Family 12,009$ 1.11 13,330$ 267$ 13,597$ 7.55$ Multifamily 12,009 0.74 8,931 179 9,110 10.12 Nonresidential - per Building Square Feet
Commercial 12,009$ 1.73 20,776$ 416$ 21,192$ 21.19$ Office 12,009 1.73 20,776 416 21,192 21.19 Industrial 12,009 1.06 12,730 255 12,985 12.99 1 Fee per dwelling unit, per 1,000 square feet of nonresidential.

Sources: Tables 3.1 and 3.4; Willdan Financial Services. 2 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

18 4. Parks and Recreation Facilities
The purpose of the parks and recreation facilities impact fee is to fund the parks and recreation facilities needed to serve new development. The maximum justified impact fee is presented based on the City’s existing park facility standards.

Service Population
Park and recreation facilities in Bell primarily serve residents. Therefore, demand for services and associated facilities is based on the City’s residential population. Table 4.1 shows the existing and future projected service population for park and recreation facilities.

Table 4.1: Park and Recreation
Facilities Service Population

Existing Park and Recreation Facilities Inventory
The City of Bell maintains several park and recreation facilities throughout the city. Table 4.2 summarizes the City’s existing parkland inventory in 2023. All facilities are located within the City limits. In total, the inventory includes a total of 12.27 acres of City-owned parkland.

Table 4.2: Parkland Inventory

Residents
Existing (2023) 32,689
Growth (2023 to Buildout) 2,226
Total (Buildout) 34,915
Source: Table 2.1.

Name
Developed
Acres
Treder Park 1.43
Ernest Debs Park 2.15
Camp Little Bear Park 1.18
Futsal Park 0.25
Pritchard Field 1.80
Biancini Park 0.25
Gage/Heliotrope Park 0.26
Veterans Park 3.26
Total - Parkland 10.58
Source: City of Bell.

City of Bell Development Impact Fee Nexus Study
19 Table 4.3 displays the City’s inventory of recreation centers and special use facilities, including community centers, park buildings and various other facilities. The total replacement cost of these facilities is divided by the existing park acres to determine an existing special use facilities cost per improved park acre.

Table 4.3: Recreation Centers and Special Use Facilities Inventory

Parkland and Park Facilities Unit Costs
Table 4.4 displays the unit costs necessary to develop parkland in Bell. The land cost assumption was based on an analysis of recent land sales within the City of Bell using data from CoStar. An estimate of $748,000 per acre for standard parkland improvements is based on the recent data from other Willdan clients. The land value is based on the weighted average of land sales in Bell provided by CoStar since 2017 , along with recent appraisals, and is consistent with the assumption used in other chapters of this report.

Inventory Units Unit Cost
Replacement
Cost
Treder Park Restroom 444 Sq. Ft. 350 155,400$ Treder Park Fire Tower 720 350 252,000$ Community Center 7,842 350 2,744,700$
Debs Park Office/Rec Center 1,413 350 494,550$ Veterans Park Club House 5,004 350 1,751,400$ Futsal Park Building (tech center) 5,000 350 1,750,000$ Pritchard Field Office/Restrooms 1,000 350 350,000$ Little Bear Park Office/Rec Ctr 3,978 Sq. Ft. 350 1,392,300 25,401 8,890,350$
Total Park Acres 10.58
Building and Special Use Facilities Cost per Acre 840,298$ Sources: City of Bell; Table 4.2, Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
20 Table 4.4: Park Facilities Unit Costs

Parkland and Park Facility Standards
Park facility standards establish a reasonable relationship between new development and the need for expanded parkland and park facilities. Information regarding the City’s existing inventory of existing parks facilities was obtained from City staff.

The most common measure in calculating new development’s demand for parks is the ratio of park acres per resident. In general, facility standards may be based on the Mitigation Fee Act (using a city’s existing inventory of parkland and park facilities), or an adopted policy standard contained in a master facility plan or general plan. Facility standards may also be based on a land dedication standard established by the Quimby Act
.1 In this case, the City will use the Mitigation
Fee Act to impose park impact fees for development not occurring in subdivisions and will use the Quimby Act for development occurring in subdivisions.

Mitigation Fee Act
The Mitigation Fee Act does not dictate use of a particular type or level of facility standard for public facilities fees. To comply with the findings required under the law, facility standards must not burden new development with any cost associated with facility deficiencies attributable to existing development.
2 A simple and clearly defensible approach to calculating a facility standard is to use the City’s existing ratio of park acreage per 1,000 residents. Under this approach, new development is required to fund new parkland and park facilities at the same level as existing residents have provided those same types of facilities to date.

1 California Government Code §66477.
2 See the Benefit and Burden findings in Background Report.

Cost
Per Acre
Share of
Total Costs
Improvements
Standard Park Improvements 1 748,000$
Building and Special Use Facilities 724,560
Subtotal 1,472,560$ 36%
Land Acquisition 2,600,000$ 64%
Total Cost per Acre 4,072,560$ 100%
1 Improvement costs are estimated at $748,000 per acre for site improvements (curbs, gutters, water, sewer, and electrical access), plus basic park and school field amenities such as basketball or tennis court, parking, tot lot, irrigation, turf, open green space, pedestrian paths, and picnic tables. Excludes special use facilities such as recreation centers, structures and pools.

Sources: San Diego County Parks and Recreation: Prototypical Park Cost Estimate; Table 4.3, Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
21 Quimby Act
The Quimby Act specifies that the dedication requirement must be a minimum of 3.0 acres and a maximum of 5.0 acres per 1,000 residents. A jurisdiction can require residential developers to dedicate above the three- acre minimum if the jurisdiction’s existing park standard at the time it adopted its Quimby Act ordinance justifies the higher level (up to five acres per 1,000 residents).

The standard used must also conform to the jurisdiction’s adopted general or specific plan standards.

The Quimby Act only applies to land subdivisions. The Quimby Act would not apply to residential development on future approved projects on single parcels, such as apartment complexes and other multifamily development.

The Quimby Act allows payment of a fee in lieu of land dedication. The fee is calculated to fund acquisition of the same amount of land that would have been dedicated.

The Quimby Act allows use of in -lieu fee revenue for any park or recreation facility purpose.

Allowable uses of this revenue include land acquisition, park improvements including recreation facilities, and rehabilitation of existing park and recreation facilities.

City of Bell Parkland and Park Facilities Standards
Table 4.5 shows the existing standard for improved park acreage per 1,000 residents based on the type of parkland. In total the City has an existing parkland standard of 0.38 acres per 1,000 residents, which allows the City to charge at 3.0 acres per 1,000 residents under the Quimby Act.

For development not subject to the Quimby Act, the fee analysis in this report will be based on maintaining a 0.38 acre per 1,000 service population standard as new development adds demand for parks in Bell.

Table 4.5: Park Facility Standards

Facilities Needed to Accommodate New Development
Table 4.6 shows the park facilities needed to accommodate new development at the existing standard and the Quimby standard, respectively. To achieve the standard by the planning horizon, depending on the amount of development subject to the Quimby Act, new development must fund the purchase and improvement of between 0.71 and 6.68 parkland acres, at a total cost ranging between $1.8 million and $17.4 million.

The facility standards and resulting fees under the Quimby Act are higher, because development will be charged to provide 3.0 acres of parkland per 1,000 residents, and 0.71 acres of improvements, whereas development not subject to the Quimby Act will be charged to provide only 0.71 acres of parkland per 1,000 service population, and 0.71 acres of improvements. Since the exact amount of development that will be subject to the Quimby fees is unknown at this time, Developed Park Acreage 10.58
Service Population (2023) 32,689
Existing Standard (Acres per 1,000 Residents) 0.32
Quimby Act Standard (Acres per 1,000 Residents) 3.00
Sources: Tables 4.1 and 4.2.

City of Bell Development Impact Fee Nexus Study
22 Table 4.6 presents the range of total facility costs that may be incurred depending on the amount of development occurring in subdivisions.

Table 4.6: Park Facilities to Accommodate New Development

Parks and Recreation Facilities Cost per Capita
Table 4.7 shows the cost per capita of providing new park facilities at the Quimby standard, and the existing facility standard. The cost per capita is shown separately for land and improvements.

The costs per capita in this table will serve as the basis of three fees:
• A Quimby Act Fee in -lieu of parkland dedication. This fee is payable by residential development occurring in subdivisions.
• A Mitigation Fee Act Fee for parkland acquisition. This fee is payable by residential development not occurring in subdivisions.
• A Mitigation Fee Act Fee for parkland improvements. This fee is payable by all residential development.

A development project pays either the Quimby Act Fee in-lieu of land dedication, or the Mitigation Fee Act Fee for land acquisition, not both. All development projects pay the Mitigation Fee Act Fees for park improvements.

Calculation Parkland Improvements Total Range1
Parkland (Quimby Act), Improvements (Mitigation Fee Act) 2 Facility Standard (acres/1,000 capita) A 3.00 0.32 Service Population Growth (2023 to Buildout) B 2,226 2,226 Facility Needs (acres) C = A x B/1000 6.68 0.71 Average Unit Cost (per acre) D $ 2,600,000 $ 748,000 Total Cost of Facilities E = C x D $ 17,368,000 $ 531,000 $ 17,899,000 Parkland and Improvements - Mitigation Fee Act 3
Facility Standard (acres/1,000 capita) A 0.32 0.32 Service Population Growth (2023 to Buildout) B 2,226 2,226 Facility Needs (acres) C = A x B/1000 0.71 0.71 Average Unit Cost (per acre) D $ 2,600,000 $ 748,000 Total Cost of Facilities E = C x D $ 1,846,000 $ 531,000 $ 2,377,000 Note: Totals have been rounded to the thousands.

Sources: Tables 4.1, 4.3, and 4.5.
1 Values in this column show the range of the cost of parkland acquisition and development should all development be either subject to the Quimby Act, or to the Mitigation Fee Act, respectively.
2 Cost of parkland to serve new development shown if all development is subject to the Quimby Act (Subdivisions of 50 units or more). Parkland charged at 3.0 acres per 1,000 residents; improvements charged at the existing standard. 3 Cost of parkland to serve new development shown if all development is subject to the Mitigation Fee Act. Parkland and improvements are charged at the existing standard.

City of Bell Development Impact Fee Nexus Study
23 Table 4.7: Park Facilities Cost per Capita

Use of Fee Revenue
The City can use park and recreation facilities fee revenue to purchase parkland and construct facilities to add to the system of park facilities that serves new development. The City may only use impact fee revenue to provide facilities and intensify usage of existing facilities needed to serve new development. The City should program fee revenue to capacity expanding projects through its CIP and budget process. The City’s current parks CIP is shown in Table 4.8. Note that the costs in Table 4. 8 do not drive the fee calculation. Rather, the costs shown in the table indicate the initial uses of park impact fee revenue. Additional projects will need to be identified to meet the City’s park standards as new development occurs.

Table 4.8: Park Facilities CIP

Improvements
Calculation Quimby Fee OR Impact Fee AND Impact Fee
Parkland Investment (per acre) A 2,600,000$ 2,600,000$ 1,472,560$ Existing Standard (acres per 1,000 capita) B 3.00 0.38 0.38 Total Cost Per 1,000 capita C = A x B 7,800,000$ 988,000$ 559,600$ Cost Per Resident D = C / 1,000 7,800$ 988$ 560$ Sources: Tables 4.4 and 4.5.

Land
Total Cost
Improvements
Gage & Heliotrope Park $3,000,000
Pritchard Field Park 9,000,000
Randolph Open Space Park 3,000,000
Riverdale Open Space Park 3,000,000
Nueva Vista Soccer Field 2,000,000
Veterans Baseball Stadium 4,000,000
Subtotal $24,000,000
Land Acquisition
Acres 3
Cost Per Acre 2,600,000$
Total Cost 7,800,000$
Subtotal 7,800,000$
Total Park Projects 31,800,000$
Source: City of Bell

City of Bell Development Impact Fee Nexus Study
24 Fee Schedule
To calculate fees by land use type, the investment in park facilities is determined on a per resident basis for parkland acquisition, and parkland improvements. T hese investment factors (shown in Table 4.7) are based on the unit cost estimates and the City’s existing facility standards.

Table 4.9 and Table 4.10 show the maximum justified park and recreation facilities fee based on the existing standard per capita under the Quimby Act and under the existing park standard under the Mitigation Fee Act, respectively. The investment per capita is converted to a fee per dwelling unit using the residential occupancy density factor from Table 2.2. The fee per dwelling unit is converted into a fee per square foot by dividing the fee per dwelling unit by the assumed average square footage of a dwelling unit.

The total fee includes an administrative charge to fund costs that include: (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue, and cost accounting, mandated public reporting, and fee justification analyses.

In Willdan’s experience with impact fee programs, two percent of the base fee adequately covers the cost of fee program administration. The administrative charge should be reviewed and adjusted during comprehensive impact fee updates to ensure that revenue generated from the charge sufficiently covers, but does not exceed, the administrative costs associated with the fee program.

Table 4.9: Maximum Justified Park and Recreation Facilities Fee Schedule Quimby

A B C = A x B D = C x 0.02 E = C + D
Cost Per Base Admin
Land Use Capita Density Fee Charge1 Total Fee Fee per sf Single Family
Parkland 7,800$ 3.98 31,044$ 621$ 31,665$ 17.59$ Improvements 508 3.98 2,022 40 2,062 1.15 Total 8,308$ 33,066$ 661$ 33,727$ 18.74$ Multifamily
Parkland 7,800$ 3.05 23,790$ 476$ 24,266$ 26.96$ Improvements 508 3.05 1,549 31 1,580 1.76 Total 8,308$ 25,339$ 507$ 25,846$ 28.72$ 1 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

Sources: Tables 2.2 and 4.7; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
25 Table 4.10: Maximum Justified Park and Recreation Facilities Fee Schedule – Mitigation Fee Act
A B C = A x B D = C x 0.02 E = C + D
Cost Per Base Admin
Land Use Capita Density Fee Charge1 Total Fee Fee per sf Single Family
Parkland 832$ 3.98 3,311$ 66$ 3,377$ 1.88$ Improvements 508 3.98 2,022 40 2,062 1.15 Total 1,340$ 5,333$ 106$ 5,439$ 3.02$ Multifamily
Parkland 832$ 3.05 2,538$ 51$ 2,589$ 2.88$ Improvements 508 3.05 1,549 31 1,580 1.76 Total 1,340$ 4,087$ 82$ 4,169$ 4.63$ 1 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

Sources: Tables 2.2 and 4.7; Willdan Financial Services.

26 5. General Government Facilities
The purpose of this fee is to ensure that new development funds its fair share of general government facilities. A fee schedule is presented based on the existing standard of general government facilities in the City of Bell to ensure that new development provides adequate funding to meet its needs.

Service Population
General government facilities serve both residents, visitors, and businesses. Therefore, demand for services and associated facilities are based on the City’s service population including residents, visitors, and workers.

Table 5.1 shows the existing and future projected service population for general government facilities. While specific data is not available to estimate the actual ratio of demand per resident to demand by businesses (per worker) for this service, it is reasonable to assume that demand for these services is less for one employee compared to one resident, because nonresidential buildings are typically occupied less intensively than dwelling units. The 0.31 -weighting factor for workers is based on a 40 -hour workweek divided by the total number of non- work hours in a week (128) and reflects the degree to which nonresidential development yields a lesser demand for general government facilities.

Table 5.1: General Government Facilities Service
Population

A B A x B = C
Persons
Weighting
Factor
Service
Population
Residents
Existing (2023) 32,689 1.00 32,689
New Development 2,226 1.00 2,226
Total (Buildout) 34,915 34,915
Workers
Existing (2023) 9,221 0.31 2,859
New Development 3,979 0.31 1,233
Total (Buildout) 13,200 4,092
Combined Residents and Weighted Workers
Existing (2023) 35,548
New Development 3,459
Total (Buildout) 39,007
Sources: Table 2.1; Willdan Financial Services.
1 Workers are weighted at 0.31 of residents based on a 40 hour work week out of a possible 128 non-work hours in a week (40/128 = 0.31)

City of Bell Development Impact Fee Nexus Study
27 Existing Facilities Inventory
The City’s general government facilities inventory is comprised of the City Hall, and the Public Works Yard. The replacement cost of these facilities was provided by the City. The land value is based on the weighted average of land sales since 2017 in Bell provided by CoStar. In total the City owns approximately $18.6 million worth of general government facilities. Table 5.2 displays the City’s existing inventory of general government facilities.

Table 5.2: Existing General Government Facilities Inventory

Inventory Units Unit Cost
Replacement
Cost
City Hall
Land 0.84 acres 2,600,000$ 2,176,000$
Building 9,115 sq. ft. 350 3,190,250 Subtotal 5,366,250$
Library
Land 0.46 acres 2,600,000$ 1,185,000$
Building 4,965 sq. ft. 350 1,737,750 Subtotal 2,922,750$
Bell House
Land 0.30 acres 2,600,000$ 779,000$
Building 3,264 sq. ft. 350 1,142,400 Subtotal 1,921,400$
City Yard
Land 0.93 acres 2,600,000$ 2,417,000$
Building 4,050 sq. ft. 350 1,417,500 Subtotal 3,834,500$
Bell Housing Authority Office
Land 0.46 acres 2,600,000$ 1,198,000$
Building 5,016 sq. ft. 350 1,755,600 Subtotal 2,953,600$
Vehicles and Equipment
Computer Network System and IT Resources 1,090,025$
Vehicles 475,000
Subtotal 1,565,025$
Total Value - Existing Facilities 18,563,525$
Sources: City of Bell; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
28 Cost Allocation
Table 5.3 shows the calculation of the existing facilities standard per capita for general government facilities. This cost is calculated by dividing the total existing value of all general government facilities by the existing service population. The cost per capita is multiplied by the worker weighting factor of 0.31 to determine the cost per worker.

Table 5.3: General Government Facilities
Existing Standard

Fee Revenue Projection
The City plans to use general government facilities fee revenue to construct improvements and acquire capital facilities and equipment to add capacity to the City’s general government facilities to serve new development. Table 5.4 shows the projected fee revenue based on the growth in service population identified in Table 5.1.

Table 5.4: Revenue Projection - Existing Standard

Capital Improvement Plan
The City should program fee revenue to capacity expanding projects through its CIP and budget process. The City’s general government facilities impact fee CIP is shown in Table 5.5. Note that the costs in Table 5.5 do not drive the fee calculation. Rather, the costs shown in the table indicate the initial uses of impact fee revenue. Additional projects will need to be identified to meet the City’s facility standards as new development occurs.

Value of Existing Facilities 18,563,525$
Existing Service Population 35,548
Cost per Capita 522$
Facility Standard per Resident 522$
Facility Standard per Worker 1 162
1 Based on a weighing factor of 0.31.

Sources: Tables 5.1 and 5.2.

Cost per Capita 522$
Growth in Service Population (2023 to Buildout) 3,459
Projected Fee Revenue 1,805,598$
Sources: Tables 5.1 and 5.3.

City of Bell Development Impact Fee Nexus Study
29 Table 5.5: General Government Facilities CIP

Fee Schedule
Table 5.6 shows the maximum justified general government facilities fee schedule. The City can adopt any fee up to this amount. The cost per capita is converted to a fee per unit of new development based on dwelling unit and employment densities (persons per dwelling unit or employees per 1,000 square feet of nonresidential building space). The fee per dwelling unit is converted into a fee per square foot by dividing the fee per dwelling unit by the assumed average square footage of a dwelling unit.

The total fee includes a two percent (2.0%) administrative charge to fund costs that include: a standard overhead charge applied to City programs for legal, accounting, and other departmental and administrative support, and fee program administrative costs including revenue collection, revenue and cost accounting and mandated public reporting.

In Willdan’s experience with impact fee programs, two percent of the base fee adequately covers the cost of fee program administration. The administrative charge should be reviewed and adjusted during comprehensive impact fee updates to ensure that revenue generated from the charge sufficiently covers, but does not exceed, the administrative costs associated with the fee program.

Table 5.6: Maximum Justified General Government Facilities Fee Schedule

Project Cost
City Hall $12,000,000
Public Works Corp Yard Facility 9,000,000
Bell Public Library 5,000,000
Bell Public Library 5,000,000
Total Cost - Planned Facilities $31,000,000
Sources: City of Bell; Willdan Financial Services.

A B C = A x B D = C x 0.02 E = C + D F = E / 1,000
Cost Per Admin Fee per
Land Use Capita Density Base Fee 1 Charge1, 2 Total Fee1 Sq. Ft.

Residential - per Dwelling Unit
Single Family 522$ 3.98 2,078$ 42$ 2,120$ 1.18$ Multifamily 522 3.05 1,592 32 1,624 1.80 Nonresidential - per 1,000 Sq. Ft.

Commercial 162$ 2.12 344$ 7$ 351$ 0.35$ Office 162 3.26 527 11 538 0.54 Industrial 162 1.16 188 4 192 0.19 1 Fee per dwelling unit or per 1,000 square feet of nonresidential.

Sources: Tables 2.2 and 5.3.
2 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

30 6. Parking Facilities
The purpose of the parking in -lieu fee is to provide developers with an option to pay an established fee rather than provide the parking spaces onsite required by the Bell Municipal Code zoning requirements. The cost of planned facilities to accommodate the parking spaces otherwise required on site as part of projects determines the maximum justified Parking In -Lieu Fee. This chapter presents the nexus analysis, showing the need and projected cost of parking facilities to maintain the overall parking availability in Bell in accordance with the zoning requirements.

Parking Requirements
Table 6.1 shows the City of Bell parking requirements for residential and nonresidential development. Refer to the City’s Municipal Code for the full requirements as specific by the municipal code.

Parking Facilities Unit Costs
Table 6.2 details the unit cost per parking space to develop multistory above ground parking structures in Bell. The municipal code mandated parking space of nine by twenty feet (9’ x 19’) requires 301 square feet of floor space and additional ninety square feet (90 square feet) of space for entries, exits, ramps and circulation. A prototypical four -story parking garage requires 75 square feet of land per parking space. Table 6.2 calculates typical construction cost in Los Angeles County for a multistory parking garage and land acquisition cost in the City of Bell to determine a facility unit cost per city parking space of $44,277.

Required Parking
Spaces per Unit 1
Dwelling Units
Single Family 2.0
Multifamily 2.0
Total
Building Square Feet (000s)
Commercial 2.5
Office 2.5
Industrial 2.5
Total
Table 6.1: Parking Requirements
1Cudahy Municipal Code requires one space per 400 square feet of Commercial.

Source: City of Bell.

City of Bell Development Impact Fee Nexus Study
31 Use of Fee Revenue
The City plans to use parking in lieu fee revenue to purchase land and construct improvements to add to parking space inventory. The City may only use parking in lieu fee revenue to provide facilities and intensify usage of existing facilities needed to serve new development.

Fee Schedule
Table 6.3 shows the maximum justified parking in -lieu fee schedule per required parking space.

The maximum justified fees are based on the cost per parking space shown in Table 6.2. The cost per space can be used to determine the fee for projects that meet a fraction of the on -site parking space requirement. The total fee includes a two percent ( 2%) administrative charge to fund costs that include: a standard overhead charge applied to all City programs for legal, accounting, and other departmental and administrative support, and fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

In Willdan’s experience with impact fee programs, two percent of the base fee adequately covers the cost of fee program administration. The administrative charge should be reviewed and adjusted during comprehensive impact fee updates to ensure that revenue generated from the charge sufficiently covers, but does not exceed, the administrative costs associated with the fee program.

Table 6.2: Parking Facility Unit Costs
Parking
Space 1
Unit Cost per
Sq. Ft.2
Total Cost
Per Space
Aboveground Parking Facility 3
Construction 301 Sq. ft. 132$ 39,786$
Land 75 Sq. ft. 60 4,492
Total 44,277$
2 WGI: Parking Stucture Cost Outlook, 2023. Assumes additional 35% soft costs. 1 Assumes 171 sqft (9' x 19') for standard parking spaces. Circulation and entry/exit assumes 130 square feet per space, total 301 square feet.
3 Prototypical 4 story parking structure, larger or smaller structure would change ratio of parking spaces to land use.

Sources: City of Bell; WGI; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
32 Table 6.3: Maximum Justified Parking In Lieu Fee Schedule A B C = A x B D = C x 0.02 E = C + D
Land Use
Cost Per
Space
Required
Spaces Base Fee 1
Admin
Charge1, 2 Total Fee1
Fee per
SqFt.

Residential - per Dwelling Unit
Single Family 44,277$ 2.0 88,554$ 1,771$ 90,325$ 50.18$ Multifamily 44,277 2.0 88,554 1,771 90,325 100.36 Nonresidential - per 1,000 Sq. Ft.

Commercial 44,277$ 2.5 110,693$ 2,214$ 112,907$ 112.91$ Office 44,277 2.5 110,693 2,214 112,907 112.91 Industrial 44,277 2.5 110,693 2,214 112,907 112.91 1 Fee per dwelling unit, per 1,000 square feet of nonresidential. 2 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

Sources: Tables 6.1 and 6.2; Willdan Financial Services.

33 7. Public Safety Facilities
The purpose of this fee is to ensure that new development funds its fair share of public safety facilities. A fee schedule is presented based on the system standard of public safety facilities in the City of Bell to ensure that new development provides adequate funding to meet its needs.

Service Population
Public safety facilities serve both residents and businesses. Therefore, demand for services and associated facilities are based on the City’s service population including residents and workers.

Table 7.1 shows the existing and future projected service population for public safety facilities.

While specific data is not available to estimate the actual ratio of demand per resident to demand by businesses (per worker) for this service, it is reasonable to assume that demand for these services is less for one employee compared to one resident, because nonresidential buildings are typically occupied less intensively than dwelling units. The 0.31 -weighting factor for workers is based on a 40-hour workweek divided by the total number of non-work hours in a week (128) and reflects the degree to which nonresidential development yields a lesser demand for public safety facilities.

Table 7.1: Public Safety Facilities Service
Population

A B A x B = C
Persons
Weighting
Factor
Service
Population
Residents
Existing (2023) 32,689 1.00 32,689
New Development 2,226 1.00 2,226
Total (Buildout) 34,915 30,607
Workers
Existing (2023) 9,221 0.31 2,859
New Development 3,979 0.31 1,233
Total (Buildout) 13,200 11,526
Combined Residents and Weighted Workers
Existing (2023) 35,548
New Development 3,459
Total (Buildout) 39,007
Sources: Table 2.1; Willdan Financial Services.
1 Workers are weighted at 0.31 of residents based on a 40 hour work week out of a possible 128 non-work hours in a week (40/128 = 0.31)

City of Bell Development Impact Fee Nexus Study
34 Existing Facility Inventory
The City’s public safety facilities inventory is comprised of a share of space at City Hall, support facilities, vehicles and trailers. Table 7.2 displays the City’s existing inventory of public safety facilities, including equipment and vehicles. In total the City owns $ 24.0 million worth of public safety facilities.

Table 7.2: Existing Public Safety Facilities Inventory

Planned Facilities
Table 7.3 summarizes the planned public safety facilities needed to serve the City, as identified by City staff. The City plans to expand and renew its public safety facilities, as well as purchase new vehicles and equipment and to make capacity expanding upgrades to its radio system and network programs. The total cost of the identified facilities is $18 million.

Inventory Units Unit Cost
Replacement
Cost
Police Station
Land 1.02 acres 2,600,000$ 2,657,000$
Building 11,127 sq. ft. 1,000 11,127,000 Subtotal 13,784,000$
Fire Station
Land 0.52 acres 2,600,000$ 1,357,000$
Building 5,685 sq. ft. 1,000 5,685,000 Subtotal 7,042,000$
Vehicles and Equipment
Equipment 1,100,000$
Vehicles 2,049,010
Subtotal 3,149,010$
Total Value - Existing Facilities 23,975,010$
Sources: City of Bell; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
35 Table 7.3: Planned Public Safety Facilities

Cost Allocation
Existing Level of Service
Table 7.4 shows the calculation of the existing facilities standard per capita for general government facilities. This cost is calculated by dividing the total existing value of all general government facilities by the existing service population. The cost per capita is multiplied by the worker weighting factor of 0.31 to determine the cost per worker.

Table 7.4: Existing Level of Service

Value of Existing Facilities $ 23,975,010
Existing Service Population 39,007

Cost per Capita $ 615

Facility Standard per Resident $ 615
Facility Standard per Worker1 191

1 Based on a weighing factor of 0.31.

Sources: Tables 7.1 and 7.2.

Fee Revenue Projection
The City plans to use public safety facilities fee revenue to construct improvements and acquire capital facilities and equipment to add to the system of public safety facilities to serve new development. Table 7.5 details a projection of fee revenue, based on the service population growth increment identified in Table 7.1. The City should program public safety facilities fee revenue to capacity expanding projects through its CIP and budget process.

The City will need to use alternative funding sources to fund existing development’s share of the planned public safety facilities. Potential sources of revenue include but are not limited to existing or new general fund revenues, existing or new taxes, and grants.

Project Cost
Police Station 10,000,000
Fire Station 8,000,000
Total Cost - Planned Facilities 18,000,000
Sources: City of Bell; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
36 Table 7.5: Revenue Projection - Existing Standard

Cost per Capita $ 522
Growth in Service Population (2023 to Buildout) 3,459 Projected Fee Revenue $ 1,805,598

Sources: Tables 7.1 and 7.3.

Fee Schedule
Table 7.6 shows the maximum justified public safety facilities fee schedule. The City can adopt any fee up to this amount. The cost per capita is converted to a fee per unit of new development based on dwelling unit and employment densities (persons per dwelling unit or employees per 1,000 square feet of nonresidential building space). The fee per dwelling unit is converted into a fee per square foot by dividing the fee per dwelling unit by the assumed average square footage of a dwelling unit.

The total fee includes a two percent (2.0%) administrative charge to fund costs that include: a standard overhead charge applied to City programs for legal, accounting, and other departmental and administrative support, and fee program administrative costs including revenue collection, revenue and cost accounting and mandated public reporting.

In Willdan’s experience with impact fee programs, two percent of the base fee adequately covers the cost of fee program administration. The administrative charge should be reviewed and adjusted during comprehensive impact fee updates to ensure that revenue generated from the charge sufficiently covers, but does not exceed, the administrative costs associated with the fee program.

Table 7.6: Public Safety Facilities Fee - Maximum Justified Fee Schedule

A B C = A x B D = C x 0.02 E = C + D
Cost Per Admin Fee per
Land Use Capita Density Base Fee 1 Charge1, 2 Total Fee1 Sq. Ft.

Residential - per Dwelling Unit
Single Family 615$ 3.98 2,448$ 49$ 2,497$ 1.39$ Multifamily 615 3.05 1,876 38 1,913 2.13 Nonresidential - per 1,000 Sq. Ft.

Commercial 191$ 2.12 405$ 8$ 413$ 0.12$ Office 191 3.26 623 12 635 0.18 Industrial 191 1.16 222 4 226 0.06 1 Fee per dwelling unit or per 1,000 square feet of nonresidential.

Sources: Tables 2.2 and 7.3.
2 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

37 8. Sewer Facilities
Sewer Demand
Estimates of new development and its consequent increased sewer demand provide the basis for calculating the sewer facilities fee. The need for sewer facilities improvements is based on the sewer demand placed on the system by development. A typical measure of demand is a flow generation rate, expressed as the number of gallons per day generated by a specific type of land use. Flow generation rates are a reasonable measure of demand on the City’s system of sewer improvements because they represent the average rate of demand that will be placed on the system per land use designation.

Table 8.1 shows the calculation of equivalent dwelling unit (EDU) demand factors based on flow generation by land use category. The flow generation estimates based on data from the City’s Wastewater Master Plan. EDU factors express water flow from each land use in terms of the flow generated by a single-family dwelling unit.

Table 8.1: Sewer Demand by Land Use

EDU Generation by New Development
Table 8.2 shows the estimated EDU generation from new development through 2045. The EDU factors from Table 8.1 are multiplied by the land use assumptions from Table 2.1 to estimate total EDUs in the base year, at the planning horizon and for new development. New development will generate approximately 2,744 new EDUs through 2045 , comprising 16.0% of sewer demand in the City at that time.

Land Use Type
Sewerage
Factor1 Density2
Sewerage
Factor per
DU or 1,000
Sq. Ft.

Equivalent
Dwelling
Unit (EDU)
Residential Dwelling Unit
Single Family 1 1.000 1.00 1.00 Multifamily 1 1.000 1.00 1.00 Nonresidential - per 1,000 Sq. Ft.

Commercial 2 4,000 0.50 0.50 Office 5 8,000 0.63 0.63
Industrial 5 20,000 0.25 0.25 1 Rate Study Factor for Demand from Rate Study.
2 Units of SF attributable to Sewerage Factor.

Sources: City of Bell, Sewer Rate Study; Willdan Financial Services.

City of Bell Development Impact Fee Nexus Study
38 Table 8.2: Sewer Facilities Equivalent Dwelling Units

Existing Facilities
Table 8.3 identifies the existing sewer facilities in the City, along with their age and depreciated value.

Table 8.3: Existing Sewer Facilities

Facility Needs and Costs
Table 8.4 identifies the planned sewer facilities to be funded by the fee. The new sewer facilities were all identified in the City’s Facility Plan. Since sewer facilities projects will benefit both existing development and new development, capacity expanding projects are allocated to new development based on new development’s share of sewer demand at the planning horizon.

Projects that do not expand capacity are not allocated to the impact fee.

Land Use EDU Factor
Units /
1,000 SF EDUs
Units /
1,000 SF EDUs
Units /
1,000 SF EDUs
Residential - per Dwelling Unit
Single Family 1.00 5,766 5,766 373 373 6,139 6,139 Multifamily 1.00 3,749 3,749 243 243 3,992 3,992 Subtotal 9,515 9,515 616 616 10,131 10,131 Nonresidential - per 1,000 Sq. Ft.

Commercial 0.50 3,548 1,774 1,531 766 5,079 2,540 Office 0.63 4,572 2,880 1,973 1,243 6,545 4,123 Industrial 0.25 1,101 275 475 119 1,576 394 Subtotal 9,221 4,929 3,979 2,128 13,200 7,057 Total 14,444 2,744 17,188

84.0% 16.0% 100%
Sources: Tables 2.1 and 8.1
2023 Growth 2023 to 2045 Total - 2045
Project
Year
Installed
Expected
Lifespan
Years in
Service
Current
Replacement
Value
Percent
Depreciated Depreciation
Remaining
Replacement
Cost
Cost Per
EDU
Existing Residential 60,000 lf 1920 100 104$ 34,424,419$ 100.0% 34,424,419 -$ Existing Residential 60,000 1940 100 84$ 34,424,419$ 84.0% 28,916,512 5,507,907$ Existing Residential 60,000 1960 100 64$ 34,424,419$ 64.0% 22,031,628 12,392,791$ Existing Industrial 5,230 lf 1975 100 49 3,000,662 49.0% 1,470,324 1,530,338$ Total 185,230 106,273,917$ 19,431,035$ $1,345
1 2019 costs adjusted for inflation to 2023 dollars using the Engineering News Record's Construction Cost Index.

Sources: City of Bell; Engineering News Record, Construction Cost Index; Table 8.1

City of Bell Development Impact Fee Nexus Study Update
39 Table 8.4: Sewer Facilities Allocation to New Development

Project Cost (2019) Cost (2023) 1
Allocation
to New
Developme
nt
Cost Allocated
to New
Development
Area 2 Sewer Main, Bypass, Traffic Control 1,131,799$ 1,352,989$ 17.0% 230,008$ Area 14 Sewer Main, Bypass, Traffic Control 1,248,000 1,491,899 17.0% 253,623 Area 33 Sewer Main, Bypass, Traffic Control 1,390,600 1,662,368 17.0% 282,603 Area 35 Sewer Main, Bypass, Traffic Control 2,481,350 2,966,286 17.0% 504,269 6,251,749$ 7,473,542$ 1,270,502$
1 2019 costs adjusted for inflation to 2023 dollars using the Engineering News Record's Construction Cost Index.

Sources: City of Bell; Engineering News Record, Construction Cost Index; Table 8.1

City of Bell Development Impact Fee Nexus Study

40 Cost per EDU
The cost of planned facilities allocated to new development in Table 8. is divided by the total growth in EDUs to determine a cost per EDU. Table 8.5 displays this calculation.

Table 8.5: Cost per EDU

Fee Schedule
The maximum justified fee for sewer facilities is shown in Table 8.6. The cost per EDU is converted to a fee per unit of new development based on the EDU factors shown in Table 8.1.

The fee per average dwelling unit is converted into a fee per square foot by dividing the fee per dwelling unit by the assumed average square footage of a dwelling unit.

The total fee includes an administrative charge to fund costs that include: (1) a standard overhead charge applied to all City programs for legal, accounting, and other departmental and administrative support, (2) capital planning, programming, project management costs associated with the share of projects funded by the facilities fee, and (3) fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses.

Existing
Depreciated Cost of Existing Facilities 19,431,035$
Exusting EDUs 14,444
Cost per EDU 1,345
Proposed
Cost Allocated to New Development 1,195,767$
Growth in EDUs (2023 to 2045) 2,744
Cost per EDU $436
Total cost per EDU 1,781$
Sources: Tables 8.2, 8.3 and 8.4

City of Bell Development Impact Fee Nexus Study
41 Table 8.6: Sewer Facilities Impact Fee Schedule
A B C = A x B D = C x 0.02 E = C + D E / Average
Cost Per
EDU EDU Factor Base Fee 1
Admin
Charge1, 2 Total Fee1
Fee per
Sq. Ft.3
Residential Dwelling Unit 4
Single Family 1,781$ 1.00 1,781$ 36$ 1,817$ 1.01 Multifamily 1,781 1.00 1,781 36$ 1,817 2.02 Nonresidential - per 1,000 Sq. Ft.

Commercial 1,781$ 0.50 891$ 18$ 909$ 0.91$ Office 1,781 0.63 1,122 22 1,144 1.14 Industrial 1,781 0.25 445 9 454 0.45 1 Fee per average sized dwelling unit or per 1,000 square feet of nonresidential building space.

Sources: Tables 8.1 and 8.4
2 Administrative charge of 2.0 percent for (1) legal, accounting, and other administrative support and (2) impact fee program administrative costs including revenue collection, revenue and cost accounting, mandated public reporting, and fee justification analyses. 3 Assumes an average of 1,602 square feet per dwelling unit in the State of California per the 2019 American Housing Survey. 4 Average EDU factor per residential dwelling unit weighted by projected single family and multifamily development.

42 9. AB 602 Requirements
On January 1, 2022, new requirements went into effect for California jurisdictions implementing impact fees. Among other changes, AB 602 added Section 66016.5 to, the Government Code, which set guidelines for impact fee nexus studies. Three key requirements from that section which concern the nexus study are reproduced here:
66016.5. (a) (2) When applicable, the nexus study shall identify the existing level of service for each public facility, identify the proposed new level of service, and include an explanation of why the new level of service is appropriate.
66016.5. (a) (4) If a nexus study supports the increase of an existing fee, the local agency shall review the assumptions of the nexus study supporting the original fee and evaluate the amount of fees collected under the original fee.
66016.5. (a) (6) Large jurisdictions shall adopt a capital improvement plan as a part of the nexus study.

Compliance with AB 602
The following sections describe this study’s compliance with the new requirements of AB 602. 66016.5. (a) (2) - Level of Service

1. For fees calculated under the existing standard methodology, the fees are calculated such that new development funds facilities at the existing level of service. These fee categories are general government and park and recreation facilities. The existing level of service in terms of the existing facility investment per capita shown in each corresponding chapter.

2. For the fees calculated under the system standard methodology, the maximum justified fees represent an increase in the facility level of service. The public safety facilities fees, transportation facilities fees and general plan update fees calculated under this methodology. The increased level of service is required to fund new development’s fair share of facilities identified by the City as necessary to serve the entire City . New development will not fund the entirety of the increase in level of service, rather, it will fund a share of the increased level of service represented by the planned facilities. The City will have to fund existing development’s share of the increase level of service through any other funding source.
66016.5. (a) (4) – Review of Original Fee Assumptions
This study is the first impact fee nexus study completed in Bell, so there are no fee assumptions to review.
66016.5. (a) (6) – Capital Improvement Plan
The Capital Improvement Plan for this nexus study is comprised of the identified planned facilities within each facility fee chapter. Planned facilities identified in this document are sourced from the City’s current adopted CIP and City staff. Adoption of this nexus study would approve the planned facilities identified herein as the Capital Improvement Plan for this nexus study.

43 10. Implementation
Impact Fee Program Adoption Process
Impact fee program adoption procedures are found in the California Government Code section 66016. Adoption of an impact fee program requires the City Council to follow certain procedures including holding a public hearing. Data, such as an impact fee report, must be made available at least 10 days prior to the public hearing. The City’s legal counsel should be consulted for any other procedural requirements as well as advice regarding adoption of an enabling ordinance and/or a resolution. After adoption there is a mandatory 60 -day waiting period before the fees go into effect.

Inflation Adjustment
The City can keep its impact fee program up to date by periodically adjusting the fees for inflation.

Such adjustments should be completed regularly to ensure that new development will fully fund its share of needed facilities. We recommend that the California Construction Cost Index (https://www.dgs.ca.gov/RESD/Resources/Page-Content/Real-Estate-Services-Division- Resources-List-Folder/DGS-California-Construction-Cost-Index-CCCI) be used for adjusting fees for inflation. The California Construction Cost Index is based on data from the Engineering News Record and is aggregated and made available for free by the State of California.

The fee amounts can be adjusted based on the change in the index compared to the index in the base year of this study (2023).

While fee updates using inflation indices are appropriate for periodic updates to ensure that fee revenues keep up with increases in the costs of public facilities, the City will also need to conduct more extensive updates of the fee documentation and calculation (such as this study) when significant new data on growth forecasts and/or facility plans become available. Note that decreases in index value will result in decreases to fee amounts.

Reporting Requirements
The City will comply with the annual and five -year reporting requirements of the Mitigation Fee Act. For facilities to be funded by a combination of public fees and other revenues, identification of the source and amount of these non -fee revenues is essential. Identification of the timing of receipt of other revenues to fund the facilities is also important.

Table 10.1 summarizes the annual and five -year reporting requirements identified in the Mitigation Fee Act.

City of Bell Development Impact Fee Nexus Study

44 Table 10.1: Mitigation Fee Act - Annual and Five-year Administrative Requirements CA Gov't Code
Section Timing Reporting Requirements 1
Recommended
Fee Adjustment
66001.(d)
The fifth fiscal year following the
first deposit into the account or
fund, and every five years
thereafter
(A) Identify the purpose to which the fee is to be put. (B) Demonstrate a reasonable relationship between the fee and the purpose for which it is charged.
(C) Identify all sources and amounts of funding anticipated to complete financing in incomplete improv ements.
(D) Designate the approximate dates on which supplemental funding is expected to be deposited into the appropriate account or fund.

Comprehensive
Update
66006. (b) Within 180 days after the last
day of each fiscal year
(A) A brief description of the type of fee in the account or fund. (B) The amount of the fee.
(C) The beginning and ending balance of the account or fund. (D) The amount of the fees collected and the interest earned. (E) An identification of each public improvement on which fees were expended including share funded by fees.
(F) An identification of an approximate date by which the construction of the public improv ement will commence.
(G) A description of any potential interfund transfers. (H) The amount of refunds made (if any).

Inflationary
Adjustment
1 Edited for brevity. Refer to the government code for full description.

Sources: California Government Code §6601 and §6606.

City of Bell Development Impact Fee Nexus Study
45 Programming Revenues and Projects with the CIP
The City maintains a Capital Improvement Program (CIP) to plan for future infrastructure needs.

The CIP identifies costs and phasing for specific capital projects. The use of the CIP in this manner documents a reasonable relationship between new development and the use of those revenues.

The City may decide to alter the scope of the planned projects or to substitute new projects if those new projects continue to represent an expansion of the City’s facilities and provide benefit to new development. If the total cost of facilities varies from the total cost used as a basis for the fees, the City should consider revising the fees accordingly.

46 11. Mitigation Fee Act Findings
Public facilities fees are one -time fees typically paid when a building permit is issued and imposed on development projects by local agencies responsible for regulating land use (cities and counties). To guide the widespread imposition of public facilities fees the State Legislature adopted the Mitigation Fee Act (the Act) with Assembly Bill 1600 in 1987 and subsequent amendments. The Act, contained in California Government Code Sections 66000 through 66025, establishes requirements on local agencies for the imposition and administration of fee programs.

The Act requires local agencies to document five findings when adopting a fee.

The five statutory findings required for adoption of the public facilities fees documented in this report are presented in this chapter and supported in detail by the preceding chapters. All statutory references are to the Act.

Purpose of Fee
§ Identify the purpose of the fee (§66001(a)(1) of the Act).

Development impact fees are designed to ensure that new development will not burden the existing service population with the cost of facilities required to accommodate growth. The purpose of the fees documented by this report is to provide a funding source from new development for capital improvements to serve that development. The fees advance a legitimate City interest by enabling the City to provide public facilities to new development.

Use of Fee Revenues
§ Identify the use to which the fees will be put. If the use is financing facilities, the facilities shall be identified. That identification may, but need not, be made by reference to a capital improvement plan as specified in §65403 or §66002, may be made in applicable general or specific plan requirements, or may be made in other public documents that identify the facilities for which the fees are charged (§66001(a)(2) of the Act).

Fees documented in this report, if enacted by the City, would be used to fund expanded facilities to serve new development. Facilities funded by these fees are designated to be located within the City limits . Fees addressed in this report have been identified by the City to be restricted to funding the following facility categories: transportation facilities, parks and recreation facilities, general government facilities, public safety facilities and general plan updates.

Benefit Relationship
§ Determine the reasonable relationship between the fees' use and the type of development project on which the fees are imposed (§66001(a)(3) of the Act).

The City will restrict fee revenue to the acquisition of land, construction of facilities , infrastructure and buildings, and purchase of related equipment, furnishings, vehicles, and services used to serve new development. Facilities funded by the fees are expected to provide a citywide network of facilities accessible to the additional residents and workers associated with new development.

Under the Act, fees are not intended to fund planned facilities needed to correct existing deficiencies. Thus, a reasonable relationship can be shown between the use of fee revenue and the new development residential and non-residential use classifications that will pay the fees.

City of Bell Development Impact Fee Nexus Study
47 Burden Relationship
§ Determine the reasonable relationship between the need for the public facilities and the types of development on which the fees are imposed (§66001(a)(4) of the Act).

Facilities need is based on a facility standard that represents the demand generated by new development for those facilities. For each facility category, demand is measured by a single facility standard that can be applied across land use types to ensure a reasonable relationsh ip to the type of development. For some facility categories service population standards are calculated based upon the number of residents associated with residential development and the number of workers associated with non-residential development. To calculate a single, per capita standard, one worker is weighted differently than one resident based on an analysis of the relative use demand between residential and non-residential development.

The standards used to identify growth needs are also used to determine if planned facilities will partially serve the existing service population by cor recting existing deficiencies. This approach ensures that new development will only be responsible for its fair share of planned facilities, and that the fees will not unfairly burden new development with the cost of facilities associated with serving the existing service population.

Chapter 2, Growth Forecasts provides a description of how service population and growth forecasts are calculated. Facility standards are described in the Facility Standard sections of each facility category chapter.

Proportionality
§ Determine how there is a reasonable relationship between the fees amount and the cost of the facilities or portion of the facilities attributable to the development on which the fee is imposed (§66001(b) of the Act).

The reasonable relationship between each facilities fee for a specific new development project and the cost of the facilities attributable to that project is based on the estimated new development growth the project will accommodate. Fees for a specific project are based on the project’s size. Larger new development projects can result in a higher service population resulting in higher fee revenue than smaller projects in the same land use classification. Thus, the fees ensure a reasonable relationship between a specific new development project and the cost of the facilities attributable to that project.

See Chapter 2, Growth Forecasts, or the Service Population sections in each facility category chapter for a description of how service populations or other factors are determined for different types of land uses. See the Fee Schedule section of each facility category chapter for a presentation of the maximum justified facilities fees.

Report Date: 8/28/24
Issuer / Book Market % of YTM
CUSIP Security Value Value * Portfolio (Market Y)
LAIF 19,692,427 19,692,427 64.00% 4.48%
See Attached Asset-Backed Security 966,496 962,893 3.20% 5.17% See Attached Agency Issues 1,196,201 1,174,539 3.82% 4.70% See Attached Agency CMBS 1,046,343 1,037,988 3.37% 4.91% See Attached Cash 2,938 2,938 0.01% 0.00%
See Attached Corporate 2,739,612 2,723,204 8.84% 5.31%
See Attached Money Market 81,354 81,354 0.27% 4.92%
See Attached Municipal Bonds 101,397 102,610 0.34% 4.81% See Attached Supranational 813,438 810,225 2.63% 4.86%
See Attached US Treasury 4,256,077 4,149,031 13.47% 4.93% Accrued Interest 71,094 0.24%
Totals 30,896,282$ 30,808,302$ 100%
Bank Account Balances:

Wells Fargo Bank Stagecoach Sweep General Checking: 12,087,215.76$ Wells Fargo Bank Commercial Checking Choice IV-Public Funds: 50,000.00 Wells Fargo Bank Bell Community Housing Authority Checking Account: 1 -
Wells Fargo Bank Payroll Account: 2
-
Wells Fargo Bank Worker's Compensation Account: 3
84,638.59
Charles Schwab OPEB Trust Account 304,280.24
Charles Schwab Pension Stabilization Trust Account 1,218,182.50 13,744,317.09$
The City's investment and banking liquidity is adequate for it to meet its expenditure requirements for the next 180 days. There have been no variances to the City Investment Policy. 1 The Bell Community Housing Authority Account - This bank account segregates the financial activities pertinent of the Housing Authority, Fund 90.

This bank account was transitioned to zero balance account (ZBA) status in 2013 and is reconciled to the City's General Ledger. 2 Payroll Account - This bank account segregates payroll activities. This bank account was transitioned to zero balance account (ZBA) status in 2013 and is reconciled to the City's General Ledger. 3 Workers' Compensation - This bank account was established for joint access by City Staff and the City's third -party administrator, AdminSure, to administer workers' compensation programming.

The account is reimbursed by bank transfers as necessary. 4 Charles Schwab OPEB Trust Account - This trust account was established to fund future OPEB Liabilities 5 Charles Schwab Pension Stabilization Trust Account - This trust account was established to fund future Pension Liabilities * Current market valuation is required for investments with maturities of more than twelve months. MV includes accrued interest earned as of 06/30/2024.

City of Bell Investment Report
LAIF Deposit and Core Investments
June 2024

MONTH FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24
JULY 25,320,562.61$ 27,158,657.80$ 36,441,274.21$ 34,062,482.19$ AUGUST 23,739,062.20 28,268,929.13 35,223,821.96$ 33,390,312.50$ SEPTEMBER 21,690,804.87 26,397,025.57 32,811,437.12$ 34,034,650.49$ OCTOBER 21,605,826.32 26,237,986.42 31,444,024.32$ 33,199,454.80$ NOVEMBER 22,017,659.98 25,741,196.73 31,238,472.56$ 32,354,418.96$ DECEMBER 24,124,656.89 28,966,073.71 33,614,575.25$ 33,684,522.39$ JANUARY 27,425,271.30 33,505,081.56 36,436,046.86$ 38,273,406.85$ FEBRUARY 25,221,695.57 33,233,351.99 37,509,622.83$ 38,028,343.35$ MARCH 25,161,017.39 32,837,890.46 36,515,694.26$ 37,364,491.38$ APRIL 25,811,974.54 34,829,178.84 37,952,579.87$ 39,401,701.82$ MAY 28,685,142.78 37,384,223.90 41,029,417.85$ 44,466,626.45$ JUNE 28,279,502.12 38,524,813.01 41,641,408.12$ 44,640,599.33$ * Current market valuation is required for investments with maturities of more than twelve months.

MV includes accrued interest earned as of 6/30/2024.

City of Bell
Historical Summary of Invested Funds & Bank Deposits

Report Date: 8/28/24
Issuer / Book Market % of YTM
Security Value Value * Portfolio (Purchase Y)
LAIF 682,020 682,020 100.00% 4.48%
Totals 682,020$ 682,020$ 100.00% Bank Account Balances:

Wells Fargo Bank Successor to RDA: 2,026,355.08$
* Current market valuation is required for investments with maturities of more than twelve months.

City of Bell Successor to Redevelopment Agency - This bank account segregates the financial activities of the Successor Agency and is reconciled to the City's General Ledger each month.

Bell Successor Agency Investment Report
June 2024
All Investments

MONTH FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24
JULY 2,652,039.24$ 2,634,143.35$ 2,596,401.97$ 2,926,113.98$ AUGUST 2,653,373.37 2,601,063.64 2,591,745.15$ 2,925,008.88$ SEPTEMBER 986,026.30 890,531.10 852,536.05$ 1,235,549.02$ OCTOBER 995,957.79 886,165.69 856,629.31$ 1,258,468.03$ NOVEMBER 995,957.04 876,829.70 843,758.80$ 1,257,061.62$ DECEMBER 995,914.01 873,108.41 841,336.47$ 1,499,506.53$ JANUARY 1,895,562.17 1,459,106.09 1,265,533.12$ 1,828,066.88$ FEBRUARY 1,747,081.95 1,325,546.77 1,262,014.62$ 1,832,707.67$ MARCH 1,140,655.41 1,014,355.71 1,077,986.33$ 1,662,581.99$ APRIL 1,144,094.97 1,000,743.36 1,073,088.31$ 1,670,505.06$ MAY 1,131,195.10 994,985.29 1,044,488.11$ 1,763,397.48$ JUNE 2,770,827.46 2,595,074.09 2,912,224.74$ 2,708,374.70$ * Current market valuation is required for investments with maturities of more than twelve months.

MV includes accrued interest earned as of 06/30/2024.

Community Redevelopment Agency / Successor Agency
Historical Summary of Invested Funds & Bank Deposits

STAGECOACH SWEEP
WELLS FARGO BANK, N.A.

P.O. BOX 63020

THIS STATEMENT COVERS 06/01/2024 THROUGH 06/30/2024

FOR QUESTIONS, PLEASE CALL YOUR CUSTOMER SERVICE OFFICER OR CUSTOMER CARE FOR BUSINESS (CC4B) SERVICE OFFICE AT 1-800-AT-WELLS (1-800-289-3557).

ALLSPRING TREASURY PLUS MMF A CLS

Transaction Detail

Date Description Amount
6-01-2024 Beginning Balance 11,955,590.07
6-03-2024 Next Day Sweep Purchase 6,983.54
6-03-2024 Reinvested Dividend 35,177.42
6-04-2024 Next Day Sweep Purchase 1,024,609.75
6-05-2024 Next Day Sweep Purchase 94,641.27
6-06-2024 Next Day Sweep Purchase 72,620.81
6-07-2024 Sweep Funds Return To DDA 375,680.28
6-10-2024 Sweep Funds Return To DDA 121,674.43
6-11-2024 Sweep Funds Return To DDA 28,015.79
6-12-2024 Next Day Sweep Purchase 12,838.61
6-13-2024 Next Day Sweep Purchase 24,513.32
6-14-2024 Sweep Funds Return To DDA 53,791.33
6-17-2024 Next Day Sweep Purchase 157,026.89
6-18-2024 Sweep Funds Return To DDA 351,389.14
6-20-2024 Sweep Funds Return To DDA 163,773.80
6-21-2024 Sweep Funds Return To DDA 463,277.59
6-24-2024 Next Day Sweep Purchase 67,323.06
6-25-2024 Next Day Sweep Purchase 140,372.50
6-26-2024 Sweep Funds Return To DDA 11,909.60
6-27-2024 Next Day Sweep Purchase 1,256.98
6-28-2024 Next Day Sweep Purchase 63,773.50
6-30-2024 Ending Balance 12,087,215.76

Daily Balance Information

Date Investment Balance Annualized Fund Yield Daily Dividend Factor Daily Accrual 06-01* 11,990,767.49 4.791 % .000131276 1,574.10
06-02* 11,990,767.49 4.791 % .000131276 1,574.10
06-03 11,997,751.03 4.780 % .000130974 1,571.39
06-04 13,022,360.78 4.775 % .000130835 1,703.78
06-05 13,117,002.05 4.775 % .000130846
1,716.31
06-06 13,189,622.86 4.775 % .000130849 1,725.85
06-07 12,813,942.58 4.779 % .000130951 1,678.00

SAN FRANCISCO, CA 94163 Page 1 of 2

CITY OF BELL

GENERAL FUND OPERATING

ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account Number - DDA

FUND SUMMARY

Dividends Earned YTD 161,437.30
Federal Withholding YTD .00
7-Day Simple Yield 4.78595 %
Federal Withholding .00

Beginning Balance 11,955,590.07
Prior Months Dividends Reinvested 35,177.42 +
Shares Purchased 1,665,960.23 +
Shares Redeemed 1,569,511.96 -
Ending Balance 12,087,215.76

Dividends Earned in Current Month 48,679.05
Funds Pending Redemption 25,656.07-

STAGECOACH SWEEP
Date Investment Balance Annualized Fund Yield Daily Dividend Factor Daily Accrual 06-08* 12,692,268.15 4.779 % .000130951 1,662.07
06-09* 12,692,268.15 4.779 % .000130951 1,662.07
06-10 12,692,268.15 4.756 % .000130309 1,653.92
06-11 12,664,252.36 4.773 % .000130769 1,656.09
06-12 12,677,090.97 4.774 % .000130811 1,658.30
06-13 12,701,604.29 4.781 % .000131013 1,664.08
06-14 12,647,812.96 4.776 % .000130866 1,655.17
06-15* 12,647,812.96 4.776 % .000130866 1,655.17
06-16* 12,647,812.96 4.776 % .000130866 1,655.17
06-17 12,804,839.85 4.778 % .000130906 1,676.23
06-18 12,453,450.71 4.777 % .000130892 1,630.06
06-19* 12,289,676.91 4.777 % .000130892 1,608.62
06-20 12,289,676.91 4.781 % .000130987 1,609.79
06-21 11,826,399.32 4.778 % .000130918 1,548.29
06-22* 11,826,399.32 4.778 % .000130918 1,548.29
06-23* 11,826,399.32 4.778 % .000130918 1,548.29
06-24 11,893,722.38 4.782 % .000131038 1,558.53
06-25 12,034,094.88 4.788 % .000131199 1,578.86
06-26 12,022,185.28 4.787 % .000131165 1,576.89
06-27 12,023,442.26 4.790 % .000131255 1,578.14
06-28 12,087,215.76 4.789 % .000131220 1,586.08
06-29* 12,061,559.69 4.789 % .000131220 1,582.72
06-30* 12,061,559.69 4.789 % .000131220 1,582.72
TOTAL MTD 48,679.08

* Indicates non-business day

THANK YOU FOR BANKING WITH WELLS FARGO.

MONEY MARKET MUTUAL FUNDS (EACH, A "MMMF") ARE NOT FDIC INSURED, HAVE NO BANK GUARANTY AND MAY LOSE VALUE.

An Investment in a MMMF is not insured by the Federal Deposit Insurance Corporation or any other government agency. Although the MMMF's seek to preserve the value of customer's investment at $1.00 per share, it is possible to lose money by investing in a MMMF.

Allspring Funds Management, LLC, a wholly owned subsidiary of Allspring Global Investments Holdings, LLC ("Allspring Global"), provides investment advisory and administrative services for the Allspring Funds?. Other subsidiaries of Allspring Global provide sub-advisory and other services for the funds. The funds are distributed by Allspring Funds Distributor, LLC, Member FINRA/SIPC, a subsidiary of Allspring Global.

This material must be accompanied or preceded by a current prospectus for name of the Fund(s) selected. Please read the prospectus carefully before investing.
06/01/2024 - 06/30/2024

Account Number - DDA

Choice IV-Public Funds {NIB}
Account number: June 1, 2024 - June 30, 2024 Page 1 of 7 Prior account number: 145398000
©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163

CITY OF BELL

GENERAL FUND OPERATING

ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance $50,000.00 $3,890,564.92 -$3,890,564.92 $50,000.00
Credits
Deposits
Effective
date
Posted
date Amount

Transaction detail
06/07 06/10 1,527.65 Reversal of Check Posted 6-07-24 Reposted 6-10-24 as Serial 0000083251 Our Ref: 6-07-24 00000000
06/18 06/20 1,074.76 Reversal of Check Posted 6-18-24 Refer to Maker Our Ref: 6-18-24 00000000 06/20 06/21 100.00 Reversal of Check Posted 6-20-24 Stale Date Our Ref: 6-20-24 00000000 06/20 06/21 50.00 Reversal of Check Posted 6-20-24 Stale Date Our Ref: 6-20-24 00000000 06/20 06/21 100.00 Reversal of Check Posted 6-20-24 Stale Date Our Ref: 6-20-24 00000000 $2,852.41 Total deposits
Electronic deposits/bank credits
Effective
date
Posted
date Amount

Transaction detail
06/03 19.11 Southern Califor Single 240603
Just*Energy*Uut*Payment*20240422000070U051024\
06/03 34.00 Cash Only Customer Deposit
06/03 136.63 06/03Bankcard Deposit -0328029700
06/03 146.67 Desktop Check Deposit
06/03 209.00 06/03Bankcard Deposit -0328029701
06/03 336.06 Cash Only Customer Deposit
06/03 2,104.77 Square Inc 240603P2 240603 L210875145907 City of Bell 06/03 3,840.96 Desktop Check Deposit
06/03 3,848.00 LA County Gen-Pymt 240529 500110 NTE*202405296162625 *A2400664811 *500110
06/03 26,187.96 LA County Gen-Pymt 240529 Pta-11600 NTE*202405296160894 *A2400663080 *Pta-11600
06/03 47,839.79 Southern Califor Single 240603 SCG*Uut*Payment*20240422000070U051324\ Sheet Seq = 0017963
Sheet 00001 of 00007

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 2 of 7 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount

Transaction detail
06/03 133,998.66 LA County Gen-Pymt 240529 Pta-11600 NTE*202405296160896 *A2400663082 *Pta-11600
06/03 857,064.59 LA County Gen-Pymt 240529 Pta-11600 NTE*202405296160895 *A2400663081 *Pta-11600
06/03 348.00 ZBA Funding Account Transfer From
06/04 2.00 06/04Bankcard Deposit -0328029701
06/04 164.19 06/04Bankcard Deposit -0328029700
06/04 546.00 06/04Bankcard Deposit -0328029701
06/04 660.84 06/04Bankcard Deposit -0328029700
06/04 699.64 Square Inc 240604P2 240604 L210875321851 City of Bell 06/04 3,573.25 Active Network, Registrati 000000006161805 Rmr*IV*13985562**141.66*141.66*0\Ref*PO*RN 001154
06/04 84,270.25 Apport St of CA Apsapports 053024 388 Bell City Treasurer 06/04 103,869.62 Desktop Check Deposit
06/05 16.00 06/05Bankcard Deposit -0328029701
06/05 26.25 06/05Bankcard Deposit -0328029701
06/05 103.87 Square Inc 240605P2 240605 L210875497999 City of Bell 06/05 569.99 06/05Bankcard Deposit -0328029700
06/05 641.15 06/05Bankcard Deposit -0328029700
06/05 41,148.37 Desktop Check Deposit
06/06 3.25 06/06Bankcard Deposit -0328029701
06/06 60.00 Cash Only Customer Deposit
06/06 211.25 06/06Bankcard Deposit -0328029701
06/06 805.45 06/06Bankcard Deposit -0328029700
06/06 1,469.13 Cash Only Customer Deposit
06/06 3,596.12 06/06Bankcard Deposit -0328029700
06/06 6,995.43 Desktop Check Deposit
06/06 16,537.35 LA County Gen-Pymt 240603 500110 NTE*202406036167492 *A2400671622 *500110
06/06 27,050.45 Square Inc 240606P2 240606 L210875679212 City of Bell 06/06 42,199.15
ZBA Funding Account Transfer From
06/06 375,680.28 Sweep Transfer From Investment
06/07 10.00 06/07Bankcard Deposit -0328029700
06/07 10.00 06/07Bankcard Deposit -0328029700
06/07 592.94 Square Inc 240607P2 240607 L210875875728 City of Bell 06/07 121,674.43 Sweep Transfer From Investment
06/10 2.25 06/10Bankcard Deposit -0328029701
06/10 157.91 Square Inc 240610P2 240610 L210876233362 City of Bell 06/10 275.00 06/10Bankcard Deposit -0328029700
06/10 592.45 Cash Only Customer Deposit
06/10 1,310.99 Cash Only Customer Deposit
06/10 12,182.95 Desktop Check Deposit
06/10 28,015.79 Sweep Transfer From Investment
06/11 20.00 06/11Bankcard Deposit -0328029701
06/11 218.00 06/11Bankcard Deposit -0328029701
06/11 542.02 06/11Bankcard Deposit -0328029700
06/11 615.06 Cash Only Customer Deposit
06/11 3,842.62 Square Inc 240611P2 240611 L210876410785 City of Bell 06/11 37,896.66 Desktop Check Deposit
Sheet Seq = 0017964
Sheet 00002 of 00007

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 3 of 7 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount

Transaction detail
06/12 170.30 06/12Bankcard Deposit -0328029700
06/12 340.00 Square Inc 240612P2 240612 L210876659585 City of Bell 06/12 352.60 Desktop Check Deposit
06/12 775.27 ZBA Funding Account Transfer From
06/13 45.00 Cash Only Customer Deposit
06/13 175.00 Ce Solutions D Operating Fgwap0000700919 Cagasuut2405 06/13 209.00 06/13Bankcard Deposit -0328029701
06/13 912.75 Cash Only Customer Deposit
06/13 1,722.00 Desktop Check Deposit
06/13 2,149.01 06/13Bankcard Deposit -0328029700
06/13 2,965.55 Square Inc 240613P2 240613 L210876844243 City of Bell 06/13 4,134.90 LA County Gen-Pymt 240610 500110 NTE*202406106176116 *A2400680528 *500110
06/13 5,001.69 Active Network, Registrati 000000006165566 Rmr*IV*13992950**5001.69*5001.69*0\Ref*PO*RN 0011
06/13 9,684.07 Ce Solutions D Operating Fgwap0000701004 Caelectricityuut2405 06/13 53,791.33 Sweep Transfer From Investment
06/14 10.00 06/14Bankcard Deposit -0328029700
06/14 148.52 Square Inc 240614P2 240614 L210877039909 City of Bell 06/14 340.00 Cash Only Customer Deposit
06/14 5,099.53 WT Fed#06300 Bank of America, N /Org=PMAm Corporation Aaf City of Bell Srf# 2024061400472974 Trn#240614143518 Rfb# May 24 Alarmfee
06/14 151,948.17 Southern Califor EDI Paymts 2406100001 003*240501***20^Dtm*003*240531***20^SE*15*98871^G
06/17 26.70 06/17Bankcard Deposit -0328029700
06/17 155.57 Desktop Check Deposit
06/17 221.64 Desktop Check Deposit
06/17 229.00 Cash Only Customer Deposit
06/17 854.17 Square Inc 240617P2 240617 L210877397185 City of Bell 06/17 351,389.14 Sweep Transfer From Investment
06/18 203.14
06/18Bankcard Deposit -0328029700
06/18 273.00 06/18Bankcard Deposit -0328029701
06/18 305.63 06/18Bankcard Deposit -0328029700
06/18 333.85 Cash Only Customer Deposit
06/18 2,875.65 Square Inc 240618P2 240618 L210877573998 City of Bell 06/18 70,603.23 Desktop Check Deposit
06/18 163,773.80 Sweep Transfer From Investment
06/20 9.00 06/20Bankcard Deposit -0328029701
06/20 20.00 06/20Bankcard Deposit -0328029701
06/20 70.88 Square Inc 240620P2 240620 L210877931645 City of Bell 06/20 184.58 Square Inc 240619P2 240619 L210877747748 City of Bell 06/20 461.31 06/20Bankcard Deposit -0328029700
06/20 1,975.88 06/20Bankcard Deposit -0328029700
06/20 3,063.11 Active Network, Registrati 000000006167461 Rmr*IV*13996403**3063.11*3063.11*0\Ref*PO*RN 0011
06/20 11,756.44 Desktop Check Deposit
06/20 19,998.64 LA County Gen-Pymt 240616 Pta-11600 NTE*202406166181446 *A2400690271 *Pta-11600
06/20 463,277.59 Sweep Transfer From Investment
Sheet Seq = 0017965
Sheet 00003 of 00007

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 4 of 7 Prior account number: 145398000
Electronic deposits/bank credits (continued)
Effective
date
Posted
date Amount

Transaction detail
06/21 4.00 06/21Bankcard Deposit -0328029700
06/21 16.00 06/21Bankcard Deposit -0328029701
06/21 30.00 06/21Bankcard Deposit -0328029701
06/21 100.00 Cash Only Customer Deposit
06/21 316.20 Square Inc 240621P2 240621 L210878126588 City of Bell 06/21 424.12 06/21Bankcard Deposit -0328029700
06/21 4,398.84 Desktop Check Deposit
06/21 79,772.75 Apport St of CA Apsapports 061724 388 Bell City Treasurer 06/21 99,770.77 ZBA Funding Account Transfer From
06/24 200.16 06/24Bankcard Deposit -0328029700
06/24 253.50 Square Inc 240624P2 240624 L210878472865 City of Bell 06/24 592.26 Cash Only Customer Deposit
06/24 1,598.13 Cash Only Customer Deposit
06/24 2,448.95 Amer Tower 1942 EDI Paymnt Jun 22 43Rent_40010702 427\Dtm*003*20240701\SE*19*000008640\GE*000001*06
06/24 3,954.45 Desktop Check Deposit
06/24 238,072.67 CA Dept Tax&Fee Cdtfa-Ltax 061924 19005 City of Bell 06/25 103.51 06/25Bankcard Deposit -0328029700
06/25 113.36 Cash Only Customer Deposit
06/25 127.21 Square Inc 240625P2 240625 L210878651228 City of Bell 06/25 209.00 06/25Bankcard Deposit -0328029701
06/25 273.00 06/25Bankcard Deposit -0328029701
06/25 363.55 06/25Bankcard Deposit -0328029700
06/25 11,909.60 Sweep Transfer From Investment
06/26 157.91 Square Inc 240626P2 240626 L210878825265 City of Bell 06/26 225.00 06/26Bankcard Deposit -0328029701
06/26 225.51 06/26Bankcard Deposit -0328029700
06/26 273.00 06/26Bankcard Deposit -0328029701
06/26 375.56 06/26Bankcard Deposit -0328029700
06/27 20.00 06/27Bankcard Deposit -0328029701
06/27 523.33 Square Inc 240627P2 240627 L210879086012 City of Bell 06/27 587.13 06/27Bankcard Deposit -0328029700
06/27 2,953.83 06/27Bankcard Deposit -0328029700
06/27 4,248.00 Active Network, Registrati 000000006170826 Rmr*IV*14002564**4248*4248*0\Ref*PO*RN 0011549 Ci
06/27 9,093.00 LA County Gen-Pymt 240624 500110 NTE*202406246190880 *A2400710658 *500110
06/27 70,241.77 Lacmta Corp Pmt 1214519
0241.77~Dtm|003|20240616~SE|33|0237~GE|0001|22531
06/28 15.00 06/28Bankcard Deposit -0328029701
06/28 132.00 06/28Bankcard Deposit -0328029700
06/28 174.38 06/28Bankcard Deposit -0328029700
06/28 749.80 Square Inc 240628P2 240628 L210879279834 City of Bell 06/28 25,656.07 Sweep Transfer From Investment
$3,887,712.51 Total electronic deposits/bank credits
$3,890,564.92 Total credits
Sheet Seq = 0017966
Sheet 00004 of 00007

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 5 of 7 Prior account number: 145398000
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount

Transaction detail
06/03 0.02 Bankcard Fee Adjustment - 0328029701
06/03 0.10 Bankcard Fee Adjustment - 0328029700
06/03 1,024,609.75 Sweep Transfer to Investment
06/04 3,017.52 WT Seq455015 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000068243297 Trn#240604455015 Rfb# 2928
06/04 94,641.27 Sweep Transfer to Investment
06/05 12,311.94 WT Seq456545 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000068275958 Trn#240605456545 Rfb# 2929
06/05 72,620.81 Sweep Transfer to Investment
06/06 3,131.74 ACH Prep Origintn - General Fund - File 2956000677 Coid 2956000677 06/06 449.58 < Business to Business ACH Debit - Calpers 1800 5686383552 100000017547358 06/06 173,215.47 < Business to Business ACH Debit - Calpers 1800 5686383552 100000017547355 06/06 293,070.96 ZBA Funding Account Transfer to
06/07 2,000.29 < Business to Business ACH Debit - Expertpay Expertpay xxxxx0677 City of Bell 06/07 115,413.15 ZBA Funding Account Transfer to
06/10 946.63 ZBA Funding Account Transfer to
06/10 639.50 ZBA Funding Account Transfer to
06/11 2,506.67 Client Analysis Srvc Chrg 240610 Svc Chge 0524 06/11 12,838.61 Sweep Transfer to Investment
06/12 0.67 Bankcard Discount Fee - 0328029701
06/12 0.95 Bankcard Discount Fee - 0328029701
06/12 1.14 Bankcard Discount Fee - 0328029700
06/12 1.86 Bankcard Fee - 0328029701
06/12 1.94 Bankcard Discount Fee - 0328029701
06/12 2.76 Bankcard Discount Fee - 0328029701
06/12 2.77 Bankcard Discount Fee - 0328029700
06/12 4.94 Bankcard Fee - 0328029700
06/12 28.86 Bankcard Interchange Fee - 0328029701
06/12 31.95
Bankcard Discount Fee - 0328029700
06/12 57.44 Bankcard Discount Fee - 0328029700
06/12 546.53 Bankcard Interchange Fee - 0328029700
06/12 10,282.51 WT Seq454204 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000068420610 Trn#240612454204 Rfb# 2930
06/12 24,513.32 Sweep Transfer to Investment
06/13 5,108.06 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542710 06/13 15,183.20 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542648 06/13 17,963.87 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542596 06/13 18,387.61 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542833 06/13 24,605.56 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542773 06/14 157,026.89 Sweep Transfer to Investment
06/17 9,132.51 WT Seq454067 City of Bell, Workers C /Bnf=City of Bell, Workers Compensation Srf# Gb00000068521419 Trn#240617454067 Rfb# 2931
06/18 19,983.50 ZBA Funding Account Transfer to
06/20 42,719.74 WT Fed#02575 US Bank, NA /Ftr/Bnf=U.S. Bank National Association Srf# Gw00000068590612 Trn#240620198452 Rfb# 2932
06/20 3,034.82 ZBA Funding Account Transfer to
06/20 281,787.33 ZBA Funding Account Transfer to
06/21 3,051.74 ACH Prep Origintn - General Fund - File 2956000677 Coid 2956000677 Sheet Seq = 0017967
Sheet 00005 of 00007

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 6 of 7 Prior account number: 145398000
Electronic debits/bank debits (continued)
Effective
date
Posted
date Amount

Transaction detail
06/21 2,000.29 < Business to Business ACH Debit - Expertpay Expertpay xxxxx0677 City of Bell 06/21 103,872.99 ZBA Funding Account Transfer to
06/21 67,323.06 Sweep Transfer to Investment
06/24 4,226.42 < Business to Business ACH Debit - AFLAC Columbus Achpmt 240622 80049400 Vw09033747801
06/24 4,937.31 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542731 06/24 14,192.51 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542667 06/24 17,584.11 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542614 06/24 18,908.82 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542856 06/24 22,058.17 < Business to Business ACH Debit - Calpers 3100 5686383552 100000017542795 06/24 8,875.77 ZBA Funding Account Transfer to
06/24 1,644.82 ZBA Funding Account Transfer to
06/24 140,372.50 Sweep Transfer to Investment
06/25 464.48 ZBA Funding Account Transfer to
06/26 1,256.98 Sweep Transfer to Investment
06/27 63,773.50 Sweep Transfer to Investment
06/28 4,027.25 ZBA Funding Account Transfer to
$2,920,395.46 Total electronic debits/bank debits
< Business to Business ACH: If this is a business account, this transaction has a return time frame of one business day from post date. This time frame does not apply to consumer accounts.

Checks paid
Number Amount Date Number Amount Date Number Amount Date 3251 1,527.65 06/07
81934 * 100.00 06/20
81978 * 50.00 06/20
82385 * 100.00 06/20
82541 * 5,677.68 06/17
82855 * 50.00 06/20
82944 * 77.00 06/14
83144 * 50.00 06/18
83202 * 675.00 06/11
83251 * 1,527.65 06/10
83259 * 54.79 06/07
83264 * 315.00 06/10
83278 * 50.00 06/24
83304 * 47,494.33 06/03
83305 10,688.75 06/25
83306 13,170.65 06/18
83308 * 172.50 06/10
83318 * 77.00 06/03
83319 1,120.00 06/17
83320 418.75 06/12
83329 * 50.00 06/20
83331 * 3,675.00 06/05
83332 500.00 06/10
83339 * 622.63 06/07
83341 * 157.27 06/18
83343 * 50.00 06/14
83357 * 30.00 06/10
83362 * 21,867.75 06/27
83363 61,560.00 06/20
83364 25,953.12 06/06
83365 12,732.88 06/05
83366 104.81 06/27
83367 54.00 06/27
83368 99.18 06/21
83369 1,735.24 06/17
83370 900.00 06/25
83371 747.34 06/17
83372 360.23 06/17
83373 1,802.73 06/20
83374 1,164.48 06/20
83375 546.46 06/18
83377 * 4,074.40 06/18
83378 900.00 06/24
83384 * 433.33 06/14
83390 * 10.00 06/24
83392 * 50.00 06/18
83393 77.00 06/04
83394 3,045.66 06/07
83400 * 139,722.08 06/17
83401 11,131.24 06/10
83403 * 20,678.00 06/17
83404 126,661.97 06/17
83405 26,270.25 06/18
83406 123.35 06/07
83407 1,946.23 06/06
83408 3,937.14 06/06
83409 1,852.23 06/06
83410 589.05 06/06
83411 139.44 06/18
83412 2,000.00 06/07
83413 112.85 06/07
83414 7,949.85 06/06
83415 1,030.49 06/06
83416 199.73 06/18
83417 5,700.00 06/20
83418 1,798.84 06/17
83419 842.82 06/17
83420 3,120.00 06/20
83421 80.00 06/18
83422 448.00 06/13
83423 929.78 06/17
83424 1,017.96 06/17
83425 180.00 06/14
83426 5,954.91 06/18
83427 366.13 06/20
Sheet Seq = 0017968
Sheet 00006 of 00007

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 7 of 7 Prior account number: 145398000
Checks paid (continued)
Number Amount Date Number Amount Date Number Amount Date 83428 5,477.03 06/17
83429 2,198.10 06/17
83430 141.32 06/18
83431 3,843.75 06/18
83432 139.47 06/20
83433 516.00 06/18
83434 561.92 06/18
83435 359.10 06/17
83437 * 4,999.00 06/21
83438 1,867.00 06/27
83439 3,953.85 06/20
83440 221.05 06/18
83441 4,820.86 06/17
83442 1,074.76 06/18
83443 940.80 06/17
83445 * 4,247.06 06/20
83447 * 232.22 06/20
83448 83.93 06/17
83449 1,611.00 06/17
83450 1,082.40 06/18
83451 4,500.00 06/28
83452 1,938.00 06/17
83453 417.00 06/21
83454 175.08 06/17
83455 780.00 06/20
83456 181.00 06/20
83457 3,089.26 06/21
83458 1,971.25 06/21
83459 113.28 06/20
83460 1,430.00 06/20
83461 177.60 06/18
83462 450.00 06/17
83463 338.36 06/21
83464 9,661.00 06/17
83465 300.00 06/24
83466 40,705.89 06/18
83467 13,197.12 06/20
83468 23,585.44 06/20
83469 71,200.00 06/18
83470 10,465.00 06/18
83471 17,056.36 06/20
83472 17,800.00 06/18
83473 2,503.75 06/10
83474 210.01 06/17
83475 2,435.45 06/10
83476 2,752.21 06/10
83477 415.31 06/12
83478 1,946.23 06/10
83479 617.41 06/11
83480 570.00 06/24
83481 1,050.00 06/10
83482 85.31 06/10
83484 * 932.67 06/11
83485 3,053.02 06/10
83486 2,794.50 06/10
83487 469.60 06/12
83488 50.00 06/11
83489 17.00 06/07
83490 1,425.87 06/12
83491 14,155.86 06/17
83492 28,888.86 06/20
83497 * 5,000.00 06/25
83499 * 10,000.00 06/18
83514 * 2,312.80 06/20
83515 110.88 06/21
83516 100.00 06/24
83517 4,431.26 06/21
83518 100.00 06/18
83519 96.48 06/24
83520 50.00 06/18
83521 56.00 06/21
83522 79.95 06/21
83523 50.00 06/18
83551 * 6,372.49 06/24
83552 1,499.72 06/24
83553 2,497.50 06/20
83554 2,497.50 06/24
83555 1,041.46 06/21
83556 1,915.50 06/24
83558 * 18,200.00 06/28
$970,169.46 Total checks paid

* Gap in check sequence.

$3,890,564.92 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
05/31 50,000.00
06/03 53,933.00
06/04 149,983.00
06/05 91,148.00
06/06 52,630.00
06/07 50,000.00
06/10 62,182.00
06/11 87,696.00
06/12 51,127.00
06/13 50,221.00
06/14 50,000.00
06/17 50,371.00
06/18 60,073.00
06/20 61,745.00
06/21 53,946.00
06/24 53,954.00
06/25 50,000.00
06/26 50,000.00
06/27 50,000.00
06/28 50,000.00
Average daily ledger balance $58,465.21
Sheet Seq = 0017969
Sheet 00007 of 00007

Commercial Checking Acct Public Funds
Account number: June 1, 2024 - June 30, 2024 Page 1 of 2 ©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163

CITY OF BELL
BCHA
6330 PINE AVE
BELL CA 90201-1221
Account summary
Commercial Checking Acct Public Funds
Account number Beginning balance Total credits Total debits Ending balance $0.00 $196,175.53 -$196,175.53 $0.00
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount

Transaction detail
06/03 348.00 121108250 Ccddeposit 240601 xxxxx0548 Bell Community Housing 06/06 555.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 720.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 770.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 835.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 970.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 985.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 1,620.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 2,380.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 4,315.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 5,020.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 5,755.00 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 14,111.53 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/06 20,147.76 Bell Properties Owner Paym 240604 Bell Properties City of Bell 06/10 946.63 ZBA Balance Account Transfer From
06/12 775.27 Desktop Check Deposit
06/18 19,983.50 ZBA Balance Account Transfer From
06/20 3,034.82 ZBA Balance Account Transfer From
06/21 50,000.00 Bell Properties Owner Paym 240620 Bell Properties City of Bell 06/21 50,000.00 Bell Properties Owner Paym 240620 Bell Properties City of Bell 06/24 8,875.77 ZBA Balance Account Transfer From
06/28 4,027.25 ZBA Balance Account Transfer From
$196,175.53 Total electronic deposits/bank credits
$196,175.53 Total credits
Sheet Seq = 0015590
Sheet 00001 of 00002

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 2 of 2 Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount

Transaction detail
06/03 348.00 ZBA Balance Account Transfer to
06/06 42,199.15 ZBA Balance Account Transfer to
06/12 775.27 ZBA Balance Account Transfer to
06/21 99,770.77 ZBA Balance Account Transfer to
$143,093.19 Total electronic debits/bank debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 8590 291.00 06/10
8606 * 17,325.00 06/18
8607 668.86 06/06
8608 9,283.99 06/06
8609 14.79 06/10
8610 5,985.88 06/06
8611 46.41 06/06
8612 942.40 06/18
8613 200.62 06/21
8614 436.00 06/18
8615 1,129.10 06/18
8616 4,027.25 06/28
8617 92.10 06/10
8618 548.74 06/10
8619 151.00 06/18
8621 * 8,633.99 06/24
8622 28.61 06/21
8623 3,034.82 06/20
8626 * 231.20 06/24
8627 10.58 06/24
$53,082.34 Total checks paid

* Gap in check sequence.

$196,175.53 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
05/31 0.00
06/03 0.00
06/06 0.00
06/10 0.00
06/12 0.00
06/18 0.00
06/20 0.00
06/21 0.00
06/24 0.00
06/28 0.00
Average daily ledger balance $0.00
Sheet Seq = 0015591
Sheet 00002 of 00002

Choice IV-Public Funds {NIB}
Account number: June 1, 2024 - June 30, 2024 Page 1 of 2 Prior account number: 145098007
©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163

CITY OF BELL

PAYROLL ACCOUNT

ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance $0.00 $796,893.23 -$796,893.23 $0.00
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount

Transaction detail
06/06 293,070.96 ZBA Balance Account Transfer From
06/07 115,413.15 ZBA Balance Account Transfer From
06/10 639.50 ZBA Balance Account Transfer From
06/20 281,787.33 ZBA Balance Account Transfer From
06/21 103,872.99 ZBA Balance Account Transfer From
06/24 1,644.82 ZBA Balance Account Transfer From
06/25 464.48 ZBA Balance Account Transfer From
$796,893.23 Total electronic deposits/bank credits
$796,893.23 Total credits
Debits
Electronic debits/bank debits
Effective
date
Posted
date Amount

Transaction detail
06/06 293,070.96 ACH Prep Origintn - City of Bell Pay - File 1956000677 Coid 1956000677 06/07 7,577.73 < Business to Business ACH Debit - Voya NAT Trst182 Spnsr P/R 240606 664486 0001 City of Bell
06/07 17,576.42 < Business to Business ACH Debit - Employment Devel EDD Eftpmt 80097165 Txp*80097165*01102*240607*T*000*T*1757642*T*17576
06/07 90,259.00 < Business to Business ACH Debit - IRS Usataxpymt 060724 270455940987391 City of Bell
06/20 281,787.33 ACH Prep Origintn - City of Bell Pay - File 1956000677 Coid 1956000677 06/21 7,560.00 < Business to Business ACH Debit - Voya NAT Trst182 Spnsr P/R 240620 664486 0001 City of Bell
Sheet Seq = 0017961
Sheet 00001 of 00002

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 2 of 2 Prior account number: 145098007
Electronic debits/bank debits (continued)
Effective
date
Posted
date Amount

Transaction detail
06/21 14,394.35 < Business to Business ACH Debit - Employment Devel EDD Eftpmt 80097165 Txp*80097165*01102*240621*T*000*T*1439435*T*14394
06/21 81,918.64 < Business to Business ACH Debit - IRS Usataxpymt 062124 270457314282976 City of Bell
$794,144.43 Total electronic debits/bank debits
< Business to Business ACH: If this is a business account, this transaction has a return time frame of one business day from post date. This time frame does not apply to consumer accounts.

Checks paid
Number Amount Date Number Amount Date Number Amount Date 40916 497.42 06/24
40917 639.50 06/10
40918 457.88 06/24
40919 689.52 06/24
40920 464.48 06/25
$2,748.80 Total checks paid

$796,893.23 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
05/31 0.00
06/06 0.00
06/07 0.00
06/10 0.00
06/20 0.00
06/21 0.00
06/24 0.00
06/25 0.00
Average daily ledger balance $0.00
Sheet Seq = 0017962
Sheet 00002 of 00002

Choice IV-Public Funds {NIB}
Account number: June 1, 2024 - June 30, 2024 Page 1 of 2 Prior account number: 145701262
©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163

CITY OF BELL

WORKERS COMPENSATION

ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance $82,742.27 $35,104.78 -$33,208.46 $84,638.59
Credits
Deposits
Effective
date
Posted
date Amount

Transaction detail
06/03 06/04 41.53 Reversal of Check Posted 6-03-24 Reposted 6-04-24 as Serial 0000017912 Our Ref: 6-03-24 00000000
06/14 06/17 318.77 Reversal of Check Posted 6-14-24 Refer to Maker Our Ref: 6-14-24 00000000 $360.30 Total deposits
Electronic deposits/bank credits
Effective
date
Posted
date Amount

Transaction detail
06/04 3,017.52 WT Seq455015 City of Bell, General F /Org=City of Bell Srf# Gb00000068243297 Trn#240604455015 Rfb# 2928
06/05 12,311.94 WT Seq456545 City of Bell, General F /Org=City of Bell Srf# Gb00000068275958 Trn#240605456545 Rfb# 2929
06/12 10,282.51 WT Seq454204 City of Bell, General F /Org=City of Bell Srf# Gb00000068420610 Trn#240612454204 Rfb# 2930
06/17 9,132.51 WT Seq454067 City of Bell, General F /Org=City of Bell Srf# Gb00000068521419 Trn#240617454067 Rfb# 2931
$34,744.48 Total electronic deposits/bank credits
$35,104.78 Total credits
Sheet Seq = 0049273
Sheet 00001 of 00002

©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.

Account number: June 1, 2024 - June 30, 2024 Page 2 of 2 Prior account number: 145701262
Debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 1791 41.53 06/03
17810 * 11.95 06/12
17864 * 580.00 06/14
17877 * 193.54 06/03
17892 * 580.00 06/14
17912 * 41.53 06/04
17914 * 193.54 06/03
17918 * 215.41 06/06
17922 * 910.00 06/11
17927 * 388.13 06/10
17939 * 580.00 06/14
17940 26.80 06/04
17941 973.50 06/03
17942 445.50 06/03
17943 580.00 06/04
17944 204.28 06/07
17945 35.74 06/03
17946 193.54 06/05
17947 422.60 06/14
17948 191.61 06/12
17949 198.31 06/05
17950 70.84 06/11
17951 458.30 06/06
17952 3,272.97 06/10
17953 23.44 06/11
17954 26.16 06/11
17955 52.86 06/11
17956 580.00 06/11
17957 267.80 06/10
17958 775.93 06/07
17959 1,026.60 06/14
17960 272.86 06/13
17961 124.47 06/13
17962 383.72 06/12
17963 642.22 06/13
17964 792.30 06/17
17965 505.98 06/10
17966 7.64 06/18
17967 236.68 06/14
17968 13.50 06/11
17969 2,564.35 06/17
17970 345.00 06/14
17971 1,680.00 06/20
17973 * 76.38 06/14
17974 329.98 06/13
17975 290.87 06/18
17976 137.23 06/25
17977 148.37 06/26
17978 101.50 06/20
17979 278.38 06/25
17980 580.00 06/17
17981 318.77 06/14
17981 318.77 06/25
17982 250.77 06/17
17983 137.09 06/24
17984 66.00 06/21
17985 990.00 06/21
17987 * 193.54 06/20
17988 422.19 06/25
17989 227.97 06/18
17990 313.50 06/24
17991 207.34 06/24
17992 143.17 06/24
17993 16.02 06/24
17994 332.36 06/24
17995 295.08 06/20
17996 900.00 06/28
17997 111.35 06/26
17998 124.52 06/27
17999 405.55 06/25
18000 209.70 06/24
18001 317.81 06/20
18002 267.80 06/24
18003 580.00 06/27
18004 13.50 06/21
18005 180.00 06/28
18007 * 76.61 06/24
18018 * 1,491.59 06/26
18019 69.63 06/27
18022 * 1,153.99 06/28
$33,208.46 Total checks paid

* Gap in check sequence.

$33,208.46 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
05/31 82,742.27
06/03 80,858.92
06/04 83,269.64
06/05 95,189.73
06/06 94,516.02
06/07 93,535.81
06/10 89,100.93
06/11 87,424.13
06/12 97,119.36
06/13 95,749.83
06/14 91,583.80
06/17 96,847.66
06/18 96,321.18
06/20 93,733.25
06/21 92,663.75
06/24 90,960.16
06/25 89,398.04
06/26 87,646.73
06/27 86,872.58
06/28 84,638.59
Average daily ledger balance $90,501.20
Sheet Seq = 0049274
Sheet 00002 of 00002

CITY OF BELL OPEB TRUST ACCOUNT
CAPACITY : CUSTODIAN
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 1

YOUR TRUST ADMINISTRATOR IS:

RBS ADVISOR TEAM
877-319-2782

Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011676 PDFE 001 ------ 667359

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 2

FDIC Insurance: Bank Sweep for Benefit Plans (BSBP), Schwab Bank Savings (SBS), and Schwab Bank Sweep for Employee Benefit Plans (SBSEBP) deposits, as applicable, held by Charles Schwab Trust Bank or another affiliated bank are insured by the Federal Deposit Insurance Corporation (FDIC). The maximum applicable insurance limit per depositor is $250,000 for all insurable capacities at each bank. The maximum applicable insurance limit for a retirement or other employee benefit plan will vary depending on the type of plan or arrangement. Please refer to the Charles Schwab Cash Features Disclosure Statement, Charles Schwab Trust Bank MMDA Terms and Conditions, or Charles Schwab Trust Bank's Disclosure Statement for Bank Sweep Program for Trust and Custody Accounts, as applicable.

FDIC insurance rules are complex. Neither Charles Schwab Trust Bank nor any other affiliated bank is responsible for monitoring any insured or uninsured portion of any deposit in BSBP,SBS, or SBSEBP. You should consult with your tax or legal advisor to determine applicable recordkeeping requirements and your available deposit insurance coverage or visit the FDIC website at www.fdic.gov.

Please note that cash positions at Charles Schwab & Co., Inc. in your plan's related Personal Choice Retirement Accounts (PCRAs) or Schwab Retirement Advisor Portfolio (SRAP) accounts which have been swept into BSBP are included on this statement. Cash balances in these accounts are deposited through BSBP in one or more of our affiliated banks. In very limited cases during extreme market conditions, some or all of the cash position in your plan's PCRAs or your plan's SRAP accounts may be temporarily swept into a money market mutual fund, which is not FDIC insured, but may be covered by SIPC insurance. Again, please review the applicable brokerage account agreements and Charles Schwab current Cash Features Disclosure Statement for more information. The total cash on this statement swept to BSBP has been allocated to the affiliated banks in the amounts listed below:

Total BSBP Deposits in Affiliated Banks As of (end of reporting period)

CHARLES SCHWAB BANK $2,904.89

(1221-1LMN)

Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011677

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 3

STATEMENT OF ACCOUNT
--------------------

S C H E D U L E S
-------------------

ACCOUNT SUMMARY 4

TRANSACTION DETAIL 5

ASSET SUMMARY 8

ASSET DETAIL 9

Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011678

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 4

ACCOUNT SUMMARY
---------------

RECEIPTS
========

EARNINGS FROM INVESTMENTS:

INTEREST 1.12 DIVIDENDS AND CAPITAL GAINS 1,586.33

TOTAL EARNINGS FROM INVESTMENTS 1,587.45

NET REALIZED GAINS & LOSSES:

TOTAL RECEIPTS 1,587.45

DISBURSEMENTS
=============
ADMINISTRATIVE EXPENSES:

FEES AND COMMISSIONS 83.33- TOTAL ADMINISTRATIVE EXPENSES 83.33-

TOTAL DISBURSEMENTS 83.33-

NET CHANGE 1,504.12

CHANGE IN NET ASSETS
UNREALIZED APPRECIATION 1,638.36

NET ASSETS AT BEGINNING OF PERIOD 301,137.76 NET CHANGE IN ASSETS FOR THE PERIOD 3,142.48 NET ASSETS AT END OF PERIOD 304,280.24 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011679

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 5

TRANSACTION DETAIL
------------------

DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------

05/31/24 BALANCES CARRIED FORWARD $2,847.43 $299,273.18

INTEREST
--------

06/17/24 CASH RECEIPT 1.12 0.00 82619761, (BKINT) BANK INTEREST
---------------- ----------------- ----------------- ----------------- TOTAL 1.12 0.00

---------------- ----------------- ----------------- ----------------- TOTAL INTEREST 1.12 0.00

DIVIDENDS AND CAPITAL GAINS
---------------------------

FIDELITY TOTAL BOND ETF
TICKER: FBND

06/03/24 CASH RECEIPT 529.12 0.00 82619761, (DIV) DIVIDEND

---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF 529.12 0.00

ISHARES CORE S&P 500 ETF
TICKER: IVV

06/17/24 CASH RECEIPT 109.56 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES CORE S&P 500 ETF 109.56 0.00

ISHARES EDGE HGH YLD
TICKER: HYDB

06/07/24 CASH RECEIPT 27.69 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES EDGE HGH YLD 27.69 0.00

ISHARES MSCI EAFE VALUE ETF
TICKER: EFV

06/17/24 CASH RECEIPT 297.93 0.00 82619761, (DIV) DIVIDEND
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011680

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 6

TRANSACTION DETAIL
------------------

DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------

---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EAFE VALUE ETF 297.93 0.00

ISHARES MSCI EMERGING MKT ETF
TICKER: EMXC

06/17/24 CASH RECEIPT 38.79 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EMERGING MKT ETF 38.79 0.00

ISHARES S&P 500 VALUE ETF
TICKER: IVE

06/17/24 CASH RECEIPT 13.57 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES S&P 500 VALUE ETF 13.57 0.00

ISHARES TIPS BOND ETF
TICKER: TIP

06/07/24 CASH RECEIPT 101.02 0.00 82619761, (DIV) DIVIDEND

---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TIPS BOND ETF 101.02 0.00

ISHARES US TREASURY BOND ETF
TICKER: GOVT

06/07/24 CASH RECEIPT 11.70 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES US TREASURY BOND ETF 11.70 0.00

PIMCO INCM FD INST CL
TICKER: PIMIX

06/28/24 CASH RECEIPT 398.49 0.00 82619761, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL PIMCO INCM FD INST CL 398.49 0.00

VANGUARD INTL DIVIDEND APRECTN ETF
TICKER: VIGI

06/25/24 CASH RECEIPT 58.46 0.00 82619761, (DIV) DIVIDEND
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011681

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 7

TRANSACTION DETAIL
------------------

DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------

---------------- ----------------- ----------------- ----------------- TOTAL VANGUARD INTL DIVIDEND APRECTN ETF 58.46 0.00

---------------- ----------------- ----------------- ----------------- TOTAL DIVIDENDS AND CAPITAL GAINS 1,586.33 0.00

FEES AND COMMISSIONS
-----------------------

06/20/24 CASH DISBURSEMENT 83.33- 0.00

TTEE/CUSTODIAN FEE/EXPENSE
82619761, (TPFEE) TRUSTEE FEE
---------------- ----------------- ----------------- ----------------- TOTAL FEES AND COMMISSIONS 83.33- 0.00

PURCHASES AND REINVESTMENTS
---------------------------

JP MORGAN EXCHG BETABUILDERS JP ETF
TICKER: BBJP

06/25/24 PURCHASED 19 UNITS 19.000 1,048.17- 1,048.17 TRADE DATE 6/24/24
19 UNITS AT $55.1667

---------------- ----------------- ----------------- ----------------- TOTAL JP MORGAN EXCHG BETABUILDERS JP ETF 19.000 1,048.17- 1,048.17

---------------- ----------------- ----------------- ----------------- TOTAL PURCHASES AND REINVESTMENTS 1,048.17- 1,048.17

06/30/24 BALANCES CARRIED FORWARD $3,303.38 $300,321.35 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011682

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 8

ASSET SUMMARY
-------------

BEGINNING ENDING ADJUSTED UNREALIZED

DESCRIPTION MARKET MARKET COST GAIN / LOSS ----------- ------ ------ ---- -----------

MUTUAL FUNDS 76,007.70 75,935.24 76,760.64 825.40-

UNIT INVESTMENT TRUSTS 222,282.63 225,041.62 223,560.71 1,480.91

CASH 2,847.43 3,303.38

----------------- ----------------- ----------------- ----------------- TOTAL INVESTMENTS 301,137.76 304,280.24 300,321.35 655.51 ================= ================= ================= ================= Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011683

CITY OF BELL OPEB TRUST ACCOUNT
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 9

ASSET DETAIL
------------

SHARES/ BEGINNING ENDING ADJUSTED UNREALIZED

UNITS DESCRIPTION MARKET MARKET COST GAIN / LOSS ------- ----------- ------ ------ ---- -----------

MUTUAL FUNDS
---------------------------------
7,245.729 PIMCO INCM FD INST CL 76,007.70 75,935.24 76,760.64 825.40- TICKER: PIMIX
MONTH END PRICE 10.4800
----------------- ----------------- ----------------- ----------------- 76,007.70 75,935.24 76,760.64 825.40-

UNIT INVESTMENT TRUSTS
---------------------------------
2,956.000 FIDELITY TOTAL BOND ETF 132,133.20 132,813.08 133,653.03 839.95- TICKER: FBND
MONTH END PRICE 44.9300

68.000 ISHARES CORE S&P 500 ETF 36,037.28 37,211.64 35,344.83 1,866.81 TICKER: IVV
MONTH END PRICE 547.2300

96.000 ISHARES EDGE HGH YLD 4,461.12 4,458.24 4,461.60 3.36- TICKER: HYDB
MONTH END PRICE 46.4400
194.000 ISHARES MSCI EAFE VALUE ETF 10,916.38 10,289.76 10,395.49 105.73- TICKER: EFV
MONTH END PRICE 53.0400

79.000 ISHARES MSCI EMERGING MKT ETF 4,495.10 4,676.80 4,478.91 197.89 TICKER: EMXC
MONTH END PRICE 59.2000

16.000 ISHARES S&P 500 VALUE ETF 2,945.92 2,912.16 2,932.87 20.71- TICKER: IVE
MONTH END PRICE 182.0100
139.000 ISHARES TIPS BOND ETF 14,831.30 14,842.42 14,808.64 33.78 TICKER: TIP

MONTH END PRICE 106.7800
197.000 ISHARES US TREASURY BOND ETF 4,414.77 4,446.29 4,450.19 3.90- TICKER: GOVT
MONTH END PRICE 22.5700

19.000 JP MORGAN EXCHG BETABUILDERS JP ETF 0.00 1,072.17 1,048.17 24.00 TICKER: BBJP
MONTH END PRICE 56.4300

6.000 VANGUARD INFORMATION TECHNOLOGY ETF 3,207.66 3,459.54 3,119.28 340.26 TICKER: VGT
MONTH END PRICE 576.5900
109.000 VANGUARD INTL DIVIDEND APRECTN ETF 8,839.90 8,859.52 8,867.70 8.18- TICKER: VIGI
MONTH END PRICE 81.2800
----------------- ----------------- ----------------- ----------------- 222,282.63 225,041.62 223,560.71 1,480.91 ----------------- ----------------- ----------------- ----------------- TOTAL 298,290.33 300,976.86 300,321.35 655.51 CASH 2,847.43 3,303.38 ----------------- -----------------
NET ASSETS 301,137.76 304,280.24 ================= =================
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000821-0011684

CITY OF BELL PEN STABILIZATION TRUST
CAPACITY : CUSTODIAN
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 1

YOUR TRUST ADMINISTRATOR IS:

RBS ADVISOR TEAM
877-319-2782

Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011685 PDFE 001 ------ 667359

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 2

FDIC Insurance: Bank Sweep for Benefit Plans (BSBP), Schwab Bank Savings (SBS), and Schwab Bank Sweep for Employee Benefit Plans (SBSEBP) deposits, as applicable, held by Charles Schwab Trust Bank or another affiliated bank are insured by the Federal Deposit Insurance Corporation (FDIC). The maximum applicable insurance limit per depositor is $250,000 for all insurable capacities at each bank. The maximum applicable insurance limit for a retirement or other employee benefit plan will vary depending on the type of plan or arrangement. Please refer to the Charles Schwab Cash Features Disclosure Statement, Charles Schwab Trust Bank MMDA Terms and Conditions, or Charles Schwab Trust Bank's Disclosure Statement for Bank Sweep Program for Trust and Custody Accounts, as applicable.

FDIC insurance rules are complex. Neither Charles Schwab Trust Bank nor any other affiliated bank is responsible for monitoring any insured or uninsured portion of any deposit in BSBP,SBS, or SBSEBP. You should consult with your tax or legal advisor to determine applicable recordkeeping requirements and your available deposit insurance coverage or visit the FDIC website at www.fdic.gov.

Please note that cash positions at Charles Schwab & Co., Inc. in your plan's related Personal Choice Retirement Accounts (PCRAs) or Schwab Retirement Advisor Portfolio (SRAP) accounts which have been swept into BSBP are included on this statement. Cash balances in these accounts are deposited through BSBP in one or more of our affiliated banks. In very limited cases during extreme market conditions, some or all of the cash position in your plan's PCRAs or your plan's SRAP accounts may be temporarily swept into a money market mutual fund, which is not FDIC insured, but may be covered by SIPC insurance. Again, please review the applicable brokerage account agreements and Charles Schwab current Cash Features Disclosure Statement for more information. The total cash on this statement swept to BSBP has been allocated to the affiliated banks in the amounts listed below:

Total BSBP Deposits in Affiliated Banks As of (end of reporting period)

CHARLES SCHWAB BANK $11,500.16

(1221-1LMN)

Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011686

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 3

STATEMENT OF ACCOUNT
--------------------

S C H E D U L E S
-------------------

ACCOUNT SUMMARY 4

TRANSACTION DETAIL 5

ASSET SUMMARY 8

ASSET DETAIL 9

Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011687

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 4

ACCOUNT SUMMARY
---------------

RECEIPTS
========

EARNINGS FROM INVESTMENTS:

INTEREST 5.02 DIVIDENDS AND CAPITAL GAINS 6,346.71

TOTAL EARNINGS FROM INVESTMENTS 6,351.73

NET REALIZED GAINS & LOSSES:

TOTAL RECEIPTS 6,351.73

DISBURSEMENTS
=============
ADMINISTRATIVE EXPENSES:

FEES AND COMMISSIONS 83.33- TOTAL ADMINISTRATIVE EXPENSES 83.33-

TOTAL DISBURSEMENTS 83.33-

NET CHANGE 6,268.40

CHANGE IN NET ASSETS
UNREALIZED APPRECIATION 6,537.63

NET ASSETS AT BEGINNING OF PERIOD 1,205,376.47 NET CHANGE IN ASSETS FOR THE PERIOD 12,806.03 NET ASSETS AT END OF PERIOD 1,218,182.50 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011688

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 5

TRANSACTION DETAIL
------------------

DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------

05/31/24 BALANCES CARRIED FORWARD $12,835.10 $1,196,075.07

INTEREST
--------

06/17/24 CASH RECEIPT 5.02 0.00 57933841, (BKINT) BANK INTEREST
---------------- ----------------- ----------------- ----------------- TOTAL 5.02 0.00

---------------- ----------------- ----------------- ----------------- TOTAL INTEREST 5.02 0.00

DIVIDENDS AND CAPITAL GAINS
---------------------------

FIDELITY TOTAL BOND ETF
TICKER: FBND

06/03/24 CASH RECEIPT 2,117.03 0.00 57933841, (DIV) DIVIDEND

---------------- ----------------- ----------------- ----------------- TOTAL FIDELITY TOTAL BOND ETF 2,117.03 0.00

ISHARES CORE S&P 500 ETF
TICKER: IVV

06/17/24 CASH RECEIPT 441.45 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES CORE S&P 500 ETF 441.45 0.00

ISHARES EDGE HGH YLD
TICKER: HYDB

06/07/24 CASH RECEIPT 110.78 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES EDGE HGH YLD 110.78 0.00

ISHARES MSCI EAFE VALUE ETF
TICKER: EFV

06/17/24 CASH RECEIPT 1,193.26 0.00 57933841, (DIV) DIVIDEND
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011689

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 6

TRANSACTION DETAIL
------------------

DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------

---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EAFE VALUE ETF 1,193.26 0.00

ISHARES MSCI EMERGING MKT ETF
TICKER: EMXC

06/17/24 CASH RECEIPT 154.67 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES MSCI EMERGING MKT ETF 154.67 0.00

ISHARES S&P 500 VALUE ETF
TICKER: IVE

06/17/24 CASH RECEIPT 55.13 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES S&P 500 VALUE ETF 55.13 0.00

ISHARES TIPS BOND ETF
TICKER: TIP

06/07/24 CASH RECEIPT 405.54 0.00 57933841, (DIV) DIVIDEND

---------------- ----------------- ----------------- ----------------- TOTAL ISHARES TIPS BOND ETF 405.54 0.00

ISHARES US TREASURY BOND ETF
TICKER: GOVT

06/07/24 CASH RECEIPT 46.87 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL ISHARES US TREASURY BOND ETF 46.87 0.00

PIMCO INCM FD INST CL
TICKER: PIMIX

06/28/24 CASH RECEIPT 1,587.08 0.00 57933841, (DIV) DIVIDEND
---------------- ----------------- ----------------- ----------------- TOTAL PIMCO INCM FD INST CL 1,587.08 0.00

VANGUARD INTL DIVIDEND APRECTN ETF
TICKER: VIGI

06/25/24 CASH RECEIPT 234.90 0.00 57933841, (DIV) DIVIDEND
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011690

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 05/31/24 TO 06/30/24
PAGE : 7

TRANSACTION DETAIL
------------------

DATE DESCRIPTION UNITS CASH INVESTMENTS GAIN/LOSS ---- ----------- ----- ---- ----------- ---------

---------------- ----------------- ----------------- ----------------- TOTAL VANGUARD INTL DIVIDEND APRECTN ETF 234.90 0.00

---------------- ----------------- ----------------- ----------------- TOTAL DIVIDENDS AND CAPITAL GAINS 6,346.71 0.00

FEES AND COMMISSIONS
-----------------------

06/20/24 CASH DISBURSEMENT 83.33- 0.00

TTEE/CUSTODIAN FEE/EXPENSE
57933841, (TPFEE) TRUSTEE FEE
---------------- ----------------- ----------------- ----------------- TOTAL FEES AND COMMISSIONS 83.33- 0.00

PURCHASES AND REINVESTMENTS
---------------------------

JP MORGAN EXCHG BETABUILDERS JP ETF
TICKER: BBJP

06/25/24 PURCHASED 109 UNITS 109.000 6,016.26- 6,016.26 TRADE DATE 6/24/24
109 UNITS AT $55.195

---------------- ----------------- ----------------- ----------------- TOTAL JP MORGAN EXCHG BETABUILDERS JP ETF 109.000 6,016.26- 6,016.26

---------------- ----------------- ----------------- ----------------- TOTAL PURCHASES AND REINVESTMENTS 6,016.26- 6,016.26

06/30/24 BALANCES CARRIED FORWARD $13,087.24 $1,202,091.33 Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011691

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 8

ASSET SUMMARY
-------------

BEGINNING ENDING ADJUSTED UNREALIZED

DESCRIPTION MARKET MARKET COST GAIN / LOSS ----------- ------ ------ ---- -----------

MUTUAL FUNDS 302,704.55 302,415.98 305,403.81 2,987.83-

UNIT INVESTMENT TRUSTS 889,836.82 902,679.28 896,687.52 5,991.76

CASH 12,835.10 13,087.24

----------------- ----------------- ----------------- ----------------- TOTAL INVESTMENTS 1,205,376.47 1,218,182.50 1,202,091.33 3,003.93 ================= ================= ================= ================= Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011692

CITY OF BELL PEN STABILIZATION TRUST
ACCOUNT NUMBER:

REPORTING PERIOD: 5/31/24 TO 6/30/24
PAGE : 9

ASSET DETAIL
------------

SHARES/ BEGINNING ENDING ADJUSTED UNREALIZED

UNITS DESCRIPTION MARKET MARKET COST GAIN / LOSS ------- ----------- ------ ------ ---- -----------

MUTUAL FUNDS
---------------------------------
28,856.487 PIMCO INCM FD INST CL 302,704.55 302,415.98 305,403.81 2,987.83- TICKER: PIMIX
MONTH END PRICE 10.4800
----------------- ----------------- ----------------- ----------------- 302,704.55 302,415.98 305,403.81 2,987.83-

UNIT INVESTMENT TRUSTS
---------------------------------
11,827.000 FIDELITY TOTAL BOND ETF 528,666.90 531,387.11 534,570.35 3,183.24- TICKER: FBND
MONTH END PRICE 44.9300
274.000 ISHARES CORE S&P 500 ETF 145,209.04 149,941.02 142,490.88 7,450.14 TICKER: IVV
MONTH END PRICE 547.2300
384.000 ISHARES EDGE HGH YLD 17,844.48 17,832.96 17,842.79 9.83- TICKER: HYDB
MONTH END PRICE 46.4400
777.000 ISHARES MSCI EAFE VALUE ETF 43,721.79 41,212.08 41,641.06 428.98- TICKER: EFV
MONTH END PRICE 53.0400
315.000 ISHARES MSCI EMERGING MKT ETF 17,923.50 18,648.00 17,853.03 794.97 TICKER: EMXC
MONTH END PRICE 59.2000

65.000 ISHARES S&P 500 VALUE ETF 11,967.80 11,830.65 11,917.31 86.66- TICKER: IVE
MONTH END PRICE 182.0100
558.000 ISHARES TIPS BOND ETF 59,538.60 59,583.24 59,449.32 133.92 TICKER: TIP

MONTH END PRICE 106.7800
789.000 ISHARES US TREASURY BOND ETF 17,681.49 17,807.73 17,815.62 7.89- TICKER: GOVT
MONTH END PRICE 22.5700
109.000 JP MORGAN EXCHG BETABUILDERS JP ETF 0.00 6,150.87 6,016.26 134.61 TICKER: BBJP
MONTH END PRICE 56.4300

22.000 VANGUARD INFORMATION TECHNOLOGY ETF 11,761.42 12,684.98 11,439.89 1,245.09 TICKER: VGT
MONTH END PRICE 576.5900
438.000 VANGUARD INTL DIVIDEND APRECTN ETF 35,521.80 35,600.64 35,651.01 50.37- TICKER: VIGI
MONTH END PRICE 81.2800
----------------- ----------------- ----------------- ----------------- 889,836.82 902,679.28 896,687.52 5,991.76 ----------------- ----------------- ----------------- ----------------- TOTAL 1,192,541.37 1,205,095.26 1,202,091.33 3,003.93 CASH 12,835.10 13,087.24 ----------------- -----------------
NET ASSETS 1,205,376.47 1,218,182.50 ================= =================
Charles Schwab Trust Bank, 2360 Corporate Circle, Henderson, NV 89074 Investment Products: Not FDIC Insured. No Bank guarantee. May lose value. JE897NP10000822-0011693

Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
July 09, 2024
LAIF Home
PMIA Average Monthly
Yields

CITY OF BELL

CITY TREASURER
6330 PINE A VENUE
BELL, CA 90201
Account Number:

June 2024 Statement
Tran Type Definitions
Account Summary
Total Deposit: 0.00 Beginning Balance: 19,692,427.18
Total Withdrawal: 0.00 Ending Balance: 19,692,427.18
7/9/24, 12:53 PM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1

June 4.480
May 4.332
April 4.272
March 4.232
February 4.122
January 4.012
LAIF Apportionment Rate(2): 4.30
LAIF Earnings Ratio(2): 0.00011755619077389
LAIF Administrative Cost(1)*: 0.27
PMIA Average Life(1): 226
LAIF Fair Value Factor(1): 0.994191267
PMIA Daily(1): 4.22
PMIA Quarter to Date(1): 4.12
Treasuries

56.98%
Agencies

23.22%
Certificates of
Deposit/Bank Notes

9.18%
Time
Deposits

3.14%
Commercial
Paper

6.84%
Corporate
Bonds

0.42%
Loans

0.22%
Notes: The apportionment rate includes interest earned on the CalPERS Supplemental Pension Payment pursuant to Government Code 20825 (c)(1) and interest earned on the Wildfire Fund loan pursuant to Public Utility Code 3288 (a). *The percentage of administrative cost equals the total administrative cost divided by the quarterly interest earnings. The law provides that administrative costs are not to exceed 5% of quarterly EARNINGS of the fund. However, if the 13-week Daily Treasury Bill Rate on the last day of the fiscal year is below 1%, then administrative costs shall not exceed 8% of quarterly EARNINGS of the fund for the subsequent fiscal year.

Source:
(1) State of California, Office of the Treasurer
(2) State of Calfiornia, Office of the Controller
PMIA Average Monthly
Effective Yields(1)
PMIA/LAIF Performance Report
as of 7/10/24
Daily rates are now available here. View PMIA Daily Rates Quarterly Performance
Quarter Ended 03/31/24
Chart does not include $1,943,000.00 in mortgages, which equates to 0.001%. Percentages may not total 100% due to rounding.

Pooled Money Investment Account
Monthly Portfolio Composition (1)
5/31/24
$162.3 billion

Choice IV-Public Funds {NIB}
Account number: June 1, 2024 - June 30, 2024 Page 1 of 1 Prior account number: 145998008
©2010 Wells Fargo Bank, N.A.

All rights reserved. Member FDIC.
(182)
Questions?
Call your Customer Service Officer or Client Services
1-800-AT WELLS (1-800-289-3557)
5:00 AM TO 6:00 PM Pacific Time Monday - Friday
Online: wellsfargo.com
Write: Wells Fargo Bank, N.A. (182)
PO Box 63020
San Francisco, CA 94163

CITY OF BELL

SUCCESSOR AGENCY

ATTN CITY TREASURER
6330 PINE AVE
BELL CA 90201-1221
Account summary
Choice IV-Public Funds {NIB}
Account number Beginning balance Total credits Total debits Ending balance $1,081,377.86 $952,519.00 -$7,541.78 $2,026,355.08
Credits
Electronic deposits/bank credits
Effective
date
Posted
date Amount

Transaction detail
06/03 949,519.00 LA County Gen-Pymt 240529 Pta-11602 NTE*202405296160897 *A2400663083 *Pta-11602
06/24 3,000.00 Cash Vault Deposit
$952,519.00 Total electronic deposits/bank credits
$952,519.00 Total credits
Debits
Checks paid
Number Amount Date Number Amount Date Number Amount Date 6126 6.00 06/06
6127 7,530.80 06/18
6128 3.61 06/24 6129 1.37 06/24
$7,541.78 Total checks paid

$7,541.78 Total debits
Daily ledger balance summary
Date Balance Date Balance Date Balance
05/31 1,081,377.86
06/03 2,030,896.86
06/06 2,030,890.86
06/18 2,023,360.06
06/24 2,026,355.08
Average daily ledger balance $1,965,026.08
Sheet Seq = 0017970
Sheet 00001 of 00001

Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
July 09, 2024
LAIF Home
PMIA Average Monthly
Yields

S/A CITY OF BELL FOR CITY OF BELL

COMMUNITY REDEVELOPMENT AGENCY

FINANCE DIRECTOR
6330 PINE A VENUE
BELL, CA 90201
Account Number:

June 2024 Statement
Tran Type Definitions
Account Summary
Total Deposit: 0.00 Beginning Balance: 682,019.62
Total Withdrawal: 0.00 Ending Balance: 682,019.62
7/9/24, 12:51 PM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1

MONTHLY ACCOUNT STATEMENT
City of Bell | Account # | As of June 30, 2024
CHANDLER ASSET MANAGEMENT | chandlerasset.com
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 at the end of the statement.

Chandler Team:

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

US Bank

CONFIDENTIAL | 2
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

PORTFOLIO SUMMARY
Portfolio Characteristics
Sector Allocation
Performance Review
Account Summary
Maturity Distribution
Top Issuers
Credit Quality
Total Rate of Return 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS Since Inception (07/01/17)
City of Bell 0.54% 0.98% 1.52% 4.91% 3.08% 0.97% 1.50% -- 1.65% Benchmark Return* 0.57% 0.94% 1.25% 4.54% 2.31% 0.41% 1.06% -- 1.33% Average Modified Duration 1.83
Average Coupon 2.96%
Average Purchase YTM 3.70%
Average Market YTM 5.01%
Average Quality AA
Average Final Maturity 2.15
Average Life 2.01
Beg. Values as of
06/01/2024
End Values as of
06/30/2024
Market Value 10,993,369.46 11,044,781.18
Accrued Interest 63,448.73 71,093.94
Total Market Value 11,056,818.19 11,115,875.12
Income Earned 31,586.80 31,321.12
Cont/WD 0.00 0.00
Par 11,283,015.44 11,305,874.83
Book Value 11,179,352.70 11,203,855.05
Cost Value 11,176,053.33 11,176,647.75
United States 37.57%
FHLMC 9.40%
Farm Credit System 4.78%
Federal Home Loan Banks 3.93%
Inter-American Development Bank 3.45%
International Bank for Recon and Dev 2.27%
Royal Bank of Canada 2.15%
PACCAR Inc 1.98%
*Periods over 1 year are annualized.

Benchmark: ICE BofA 1-3 Year US Treasury & Agency Index Secondary Benchmark:
*See Footnote
The credit quality is a weighted average calculation of the highest of S&P , Moody’s’ and Fitch

CONFIDENTIAL | 3
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes

AGENCY MORTGAGE SECURITIES (CMOS)
Max % (MV) 100.0 9.4 Compliant
Max Maturity (Years) 5.0 0.0 Compliant

ASSET BACKED SECURITIES
Max % (MV; Non Agency ABS & MBS) 20.0 8.7 Compliant
Max % Issuer (MV) 5.0 2.0 Compliant
Max Maturity (Years) 5.0 4.8 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant

BANKERS' ACCEPTANCES
Max % (MV) 40.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Days) 180 0.0 Compliant
Min Rating (A-1 by 1 or A- by 1) 0.0 0.0 Compliant

CERTIFICATE OF DEPOSIT PLACEMENT SERVICE (CDARS)
Max % (MV) 30.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant

CERTIFICATES OF DEPOSIT
Max % (MV) 30.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant

COMMERCIAL PAPER
Max % (MV) 25.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Days) 270 0.0 Compliant
Min Rating (A-1 by 1, A- by 1) 0.0 0.0 Compliant

CORPORATE MEDIUM TERM NOTES
Max % (MV) 30.0 24.8 Compliant
Max % Issuer (MV) 5.0 2.2 Compliant
Max Maturity (Years) 5 4 Compliant
Min Rating (A- by 1) 0.0 0.0 Compliant

FEDERAL AGENCIES
Max % (MV) 100.0 10.6 Compliant
Max % Issuer (MV) 25.0 4.8 Compliant
Max Maturity (Years) 5 4 Compliant

CONFIDENTIAL | 4
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes

LOCAL AGENCY INVESTMENT FUND (LAIF)
Max Concentration (MV) 75.0 0.0 Compliant

MONEY MARKET MUTUAL FUNDS
Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.7 Compliant Max % Issuer (MV) 20.0 0.7 Compliant
Min Rating (AAA by 2) 0.0 0.0 Compliant

MORTGAGE-BACKED SECURITIES (NON-AGENCY)
Max % (MV) 20.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5.0 0.0 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant

MUNICIPAL SECURITIES (ALL STATES)
Max % (MV) 30.0 0.9 Compliant
Max % Issuer (MV) 5.0 0.9 Compliant
Max Maturity (Years) 5.0 4.3 Compliant
Min Rating (A- by 1) 0.0 0.0 Compliant

MUTUAL FUNDS
Max % (MV; Money Market Fund & Mutual Fund) 20.0 0.7 Compliant Max % Issuer (MV) 10.0 0.7 Compliant
Max % Issuer (MV) 10.0 0.0 Compliant

NEGOTIABLE CERTIFICATES OF DEPOSIT (NCD)
Max % (MV) 30.0 0.0 Compliant
Max % Issuer (MV) 5.0 0.0 Compliant
Max Maturity (Years) 5 0.0 Compliant
Min Rating (A-1 by 1 or A- by 1 if > FDIC Limit) 0.0 0.0 Compliant

REPURCHASE AGREEMENTS
Max Maturity (Years) 1.0 0.0 Compliant

SUPRANATIONAL OBLIGATIONS
Max % (MV) 30.0 7.4 Compliant
Max % Issuer (MV) 10.0 3.5 Compliant
Max Maturity (Years) 5 4 Compliant
Min Rating (AA- by 1) 0.0 0.0 Compliant
U.S. TREASURIES
Max % (MV) 100.0 37.5 Compliant

CONFIDENTIAL | 5
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

STATEMENT OF COMPLIANCE
Rules Name Limit Actual Compliance
Status Notes
Max Maturity (Years) 5 3 Compliant

CONFIDENTIAL | 6
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

RECONCILIATION SUMMARY
Accrual Activity Summary
Fair Market Activity Summary
Month to Date Fiscal Year to Date
(07/01/2023)
Beginning Book Value 11,179,352.70 10,916,714.64
Maturities/Calls (500,000.00) (3,940,000.00)
Principal Paydowns (29,276.37) (470,404.25)
Purchases 1,068,795.35 10,062,754.63
Sales (522,791.80) (5,401,330.00)
Change in Cash, Payables, Receivables 1,918.05 1,655.58 Amortization/Accretion 5,857.13 35,940.58
Realized Gain (Loss) (0.00) (1,476.12)
Ending Book Value 11,203,855.05 11,203,855.05
Month to Date Fiscal Year to Date
(07/01/2023)
Beginning Market Value 10,993,369.46 10,554,158.75
Maturities/Calls (500,000.00) (3,940,000.00)
Principal Paydowns (29,276.37) (470,404.25)
Purchases 1,068,795.35 10,062,754.63
Sales (522,791.80) (5,401,330.00)
Change in Cash, Payables, Receivables 1,918.05 1,655.58 Amortization/Accretion 5,857.13 35,940.58
Change in Net Unrealized Gain (Loss) 26,909.37 203,482.02 Realized Gain (Loss) (0.00) (1,476.12)
Ending Market Value 11,044,781.18 11,044,781.18
Maturities / Calls
Month to Date (500,000.00)
Fiscal Year to Date (3,940,000.00)
Principal Paydowns
Month to Date (29,276.37)
Fiscal Year to Date (470,404.25)
Purchases
Month to Date 1,068,795.35
Fiscal Year to Date 10,062,754.63
Sales
Month to Date (522,791.80)
Fiscal Year to Date (5,401,330.00)
Interest Received
Month to Date 21,116.35
Fiscal Year to Date 276,035.71
Purchased / Sold Interest
Month to Date (3,297.57)
Fiscal Year to Date (11,937.26)

CONFIDENTIAL | 7
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
ABS
47788UAC6 JDOT 2021 A3 0.36 09/15/2025 3,585.98 03/02/2021

1.11%
3,585.29
3,585.83

99.37 4.93%
3,563.42

0.57 0.03%
(22.41)
Aaa/NA
AAA

1.21 0.14
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025 13,212.02 02/07/2023

5.43%
13,211.70
13,211.86

99.81 5.69%
13,187.37

11.36 0.12%
(24.49)
Aaa/AAA
NA

1.41 0.42
43815GAC3 HAROT 2021-4 A3 0.88
01/21/2026 13,985.14 11/16/2021

0.42%
13,982.19
13,984.46

97.97 4.64%
13,700.58

3.42 0.12%
(283.88)
Aaa/NA
AAA

1.56 0.55
47789QAC4 JDOT 2021-B A3 0.52
03/16/2026 13,232.47 07/13/2021

0.52%
13,231.29
13,232.22

98.07 4.81%
12,977.64

3.06 0.12%
(254.58)
Aaa/NA
AAA

1.71 0.45
44935FAD6 HART 2021-C A3 0.74
05/15/2026 9,450.26 11/09/2021

0.75%
9,448.15
9,449.74

98.36 4.11%
9,295.29

3.11 0.08%
(154.45)
NA/AAA
AAA

1.87 0.49
43815BAC4 HAROT 2022-1 A3 1.88
05/15/2026 34,055.61 02/15/2022

0.28%
34,050.49
34,054.06

98.11 4.63%
33,410.99

28.46 0.30%
(643.07)
Aaa/AAA
NA

1.87 0.70
43815PAC3 HAROT 2022-2 A3 3.73
07/20/2026 31,212.81 08/15/2022

3.87%
31,210.95
31,212.00

98.78 5.26%
30,832.58

42.04 0.28%
(379.42)
NA/AAA
AAA

2.05 0.83
47787JAC2 JDOT 2022 A3 0.36 09/15/2026 24,987.18 03/10/2022

2.34%
24,981.65
24,985.21

98.03 5.46%
24,495.65

25.76 0.22%
(489.56)
Aaa/NA
AAA

2.21 0.64
362554AC1 GMCAR 2021-4 A3 0.68
09/16/2026 11,181.68 10/13/2021

0.68%
11,181.39
11,181.60

97.67 4.17%
10,921.42

3.17 0.10%
(260.18)
Aaa/AAA
NA

2.21 0.69
380146AC4 GMCAR 2022-1 A3 1.26
11/16/2026 13,395.38 01/11/2022

1.24%
13,394.21
13,395.00

97.78 4.27%
13,098.63

7.03 0.12%
(296.37)
NA/AAA
AAA

2.38 0.76
379929AD4 GMALT 2023-3 A3 5.38
11/20/2026 10,000.00 08/08/2023

5.38%
9,998.80
9,999.12

99.93 5.51%
9,992.77

16.44 0.09%
(6.35)
NA/AAA
AAA

2.39 1.22
47800AAC4 JDOT 2022-B A3 3.74
02/16/2027 39,607.04 07/12/2022

3.77%
39,603.26
39,605.25

98.59 5.33%
39,048.59

65.84 0.35%
(556.66)
Aaa/NA
AAA

2.63 0.88
36269FAD8 GMALT 2024-1 A3 5.09
03/22/2027 65,000.00 02/08/2024

5.09%
64,991.88
64,992.86

99.52 5.46%
64,687.81
101.09

0.59%
(305.06)
NA/AAA
AAA

2.73 1.65
448979AD6 HART 2023-A A3 4.58
04/15/2027 50,000.00 04/04/2023

5.14%
49,995.12
49,996.61

99.12 5.24%
49,560.62
101.78

0.45%
(435.99)
NA/AAA
AAA

2.79 1.47
36265WAD5 GMCAR 2022-3 A3 3.64
04/16/2027 28,677.41 07/06/2022

3.93%
28,677.21
28,677.31

98.64 4.95%
28,286.86

43.49 0.26%
(390.45)
Aaa/NA
AAA

2.79 1.03
43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027 25,000.00 02/16/2023

5.09%
24,995.35
24,996.87

99.58 5.40%
24,895.53

35.00 0.23%
(101.34)
Aaa/NA
AAA

2.81 1.44
58770AAC7 MBART 2023-1 A3 4.51
11/15/2027 35,000.00 01/18/2023

4.56%
34,995.80
34,997.14

98.98 5.18%
34,644.41

70.16 0.31%
(352.73)
NA/AAA
AAA

3.38 1.54

CONFIDENTIAL | 8
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
362583AD8 GMCAR 2023-2 A3 4.47
02/16/2028 40,000.00 04/04/2023

4.51%
39,998.90
39,999.18

98.90 5.10%
39,558.60

74.50 0.36%
(440.58)
Aaa/AAA
NA

3.63 1.96
47787CAC7 JDOT 2023-C A3 5.48
05/15/2028 105,000.00 09/12/2023

5.40%
104,992.79
104,994.00
100.32

5.40%
105,339.79
255.73

0.95%
345.79
Aaa/NA
AAA

3.88 2.01
438123AC5 HAROT 2023-4 A3 5.67
06/21/2028 35,000.00 11/01/2023

5.74%
34,993.84
34,994.70
100.88

5.37%
35,308.58

55.13 0.32%
313.88
Aaa/NA
AAA

3.98 2.28
89239FAD4 TAOT 2023-D A3 5.54
08/15/2028 45,000.00 11/07/2023

6.30%
44,995.15
44,995.79
100.71

5.32%
45,321.43
110.80

0.41%
325.64
NA/AAA
AAA

4.13 2.51
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028 115,000.00 09/12/2023

5.29%
114,994.86
114,995.67
100.33

5.14%
115,380.50
267.31

1.04%
384.83
NA/AAA
AAA

4.21 2.03
89238DAD0 TAOT 2024-A A3 4.83
10/16/2028 60,000.00 01/23/2024

4.89%
59,987.99
59,989.06

99.36 5.13%
59,613.58
128.80

0.54%
(375.48)
Aaa/AAA
NA

4.30 2.62
448973AD9 HART 2024-A A3 4.99
02/15/2029 45,000.00 03/11/2024

5.05%
44,990.08
44,990.65

99.63 5.24%
44,834.53

99.80 0.41%
(156.12)
NA/AAA
AAA

4.63 2.05
02582JKH2 AMXCA 2024-1 A 5.23
04/16/2029 100,000.00 04/16/2024

5.30%
99,979.50
99,980.28
100.94

4.99%
100,936.04
232.44

0.91%
955.76
NA/AAA
AAA

4.79 2.53
Total ABS 966,582.97 4.55%
966,467.84
966,496.47

99.63 5.17%
962,893.20
1,786.29

8.72%
(3,603.27)
Aaa/AAA
AAA

3.47 1.74
AGENCY
3133ENKS8

FEDERAL FARM CREDIT
BANKS FUNDING CORP 1.125
01/06/2025
80,000.00 01/06/2022

1.20%
79,820.00
79,968.82

97.88 5.35%
78,300.08
437.50

0.71%
(1,668.74)
Aaa/AA+
AA+

0.52 0.50
3135G06G3 FEDERAL NATIONAL MORTGAGE
ASSOCIATION 0.5 11/07/2025 225,000.00 11/18/2020

0.52%
224,768.25
224,936.89

94.22 4.97%
212,005.19
168.75

1.92%
(12,931.69)
Aaa/AA+
AA+

1.36 1.32
3130AXU63 FEDERAL HOME LOAN BANKS

4.625 11/17/2026 160,000.00 11/16/2023

4.69%
159,716.80
159,775.46

99.90 4.67%
159,839.18
904.44

1.45%

63.72 Aaa/AA+
AA+

2.38 2.22
3133ERDS7 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.75 05/06/2027 225,000.00 06/25/2024

4.55%
226,206.00
226,200.22
100.37

4.61%
225,834.30
1,632.81

2.04%
(365.93)
Aaa/AA+
AA+

2.85 2.62
3133ERFJ5 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.5 05/20/2027 115,000.00 05/23/2024

4.79%
114,070.80
114,103.16

99.71 4.61%
114,665.32
589.38

1.04%
562.15
Aaa/AA+
AA+

2.89 2.67
3130ATS57 FEDERAL HOME LOAN BANKS 4.5
03/10/2028 275,000.00 03/21/2023

3.99%
281,206.75
279,609.75

99.88 4.53%
274,662.58
3,815.63

2.49%
(4,947.17)
Aaa/AA+
AA+

3.70 3.32
3133EPN50 FEDERAL FARM CREDIT BANKS
FUNDING CORP 4.25 12/15/2028 110,000.00 12/28/2023

3.89%
111,789.70
111,607.08

99.30 4.42%
109,231.98
207.78

0.99%
(2,375.10)
Aaa/AA+
AA+

4.46 4.01

CONFIDENTIAL | 9
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
Total Agency 1,190,000.00 3.45%
1,197,578.30
1,196,201.38

98.75 4.70%
1,174,538.63
7,756.28

10.63%
(21,662.75)
Aaa/AA+
AA+

2.71 2.49

AGENCY CMBS
3137BNGT5 FHMS K-054 A2 2.745
01/25/2026 175,000.00 02/15/2023

4.65%
166,174.81
170,363.61

96.46 5.22%
168,802.48
400.31

1.53%
(1,561.13)
Aaa/AA+
AAA

1.57 1.38
3137BVZ82 FHMS K-063 A2 3.43 01/25/2027 110,000.00 02/06/2024

4.48%
106,811.72
107,243.06

96.36 4.98%
105,994.27
314.42

0.96%
(1,248.78)
Aaa/AA+
AAA

2.57 2.27
3137FETN0 FHMS K-073 A2 3.35 01/25/2028 160,000.00 05/24/2023

4.27%
153,775.00
155,252.37

95.10 4.87%
152,163.66
446.67

1.38%
(3,088.71)
Aaa/AA+
AAA

3.57 3.18
3137FHPJ6 FHMS K-080 A2 3.926
07/25/2028 110,000.00 01/23/2024

4.45%
107,567.97
107,803.96

96.60 4.83%
106,263.56
359.88

0.96%
(1,540.39)
Aaa/AA+
AA+

4.07 3.65
3137FJEH8 FHMS K-081 A2 3.9 08/25/2028 105,000.00 09/15/2023

4.86%
100,553.91
101,266.99

96.48 4.82%
101,305.96
341.25

0.92%

38.98 Aaa/AA+
AAA

4.15 3.71
3137FJXV6 FHMS K-083 A2 4.05 09/25/2028 100,000.00 03/13/2024

4.53%
97,941.41
98,074.18

97.01 4.81%
97,005.90
337.50

0.88%
(1,068.28)
Aaa/AA+
AAA

4.24 3.78
3137H4BY5 FHMS K-746 A2 2.031
09/25/2028 110,000.00 10/03/2023

5.30%
94,625.78
96,933.63

89.35 4.86%
98,284.08
186.18

0.89%
1,350.45
Aaa/AA+
AAA

4.24 3.91
3137FKZZ2 FHMS K-088 A2 3.69 01/25/2029 110,000.00 01/18/2024

4.43%
106,343.36
106,663.80

95.51 4.79%
105,062.99
338.25

0.95%
(1,600.81)
Aaa/AA+
AA+

4.57 4.03
3137H5YC5 FHMS K-748 A2 2.26 01/25/2029 115,000.00 04/11/2024

4.94%
102,174.81
102,741.18

89.66 4.84%
103,104.88
216.58

0.93%
363.71
Aaa/AA+
AAA

4.57 4.15
Total Agency
CMBS 1,095,000.00 4.63%
1,035,968.77
1,046,342.76

94.87 4.91%
1,037,987.79
2,941.04

9.40%
(8,354.97)
Aaa/AA+
AAA

3.58 3.20
CASH
CCYUSD Receivable 2,938.09 --

0.00%
2,938.09
2,938.09

1.00 0.00%
2,938.09

0.00 0.03%

0.00 Aaa/AAA
AAA

0.00 0.00
Total Cash 2,938.09 0.00%
2,938.09
2,938.09

1.00 0.00%
2,938.09

0.00 0.03%

0.00 Aaa/AAA
AAA

0.00 0.00

CORPORATE
79466LAG9 SALESFORCE INC 0.625
07/15/2024 20,000.00 06/29/2021

0.64%
19,989.80
19,999.87

99.81 5.23%
19,961.57

57.64 0.18%
(38.30)
A1/A+
NA

0.04 0.04
91159HHX1 US BANCORP 2.4 07/30/2024 150,000.00 03/25/2021

0.66%
158,425.50
150,000.00

99.72 5.69%
149,583.53
1,510.00

1.35%
(416.47)
A3/A
A

0.08 0.08

CONFIDENTIAL | 10
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
69371RR40 PACCAR FINANCIAL CORP 0.5
08/09/2024 50,000.00 08/03/2021

0.52%
49,973.00
49,999.04

99.49 5.27%
49,742.61

98.61 0.45%
(256.43)
A1/A+
NA

0.11 0.11
78015K7C2 ROYAL BANK OF CANADA 2.25
11/01/2024 135,000.00 09/22/2020

0.70%
143,487.45
135,696.44

98.87 5.65%
133,476.54
506.25

1.21%
(2,219.90)
A1/A
AA-

0.34 0.33
69371RR57 PACCAR FINANCIAL CORP 0.9
11/08/2024 90,000.00 11/02/2021

0.90%
89,994.60
89,999.64

98.42 5.44%
88,573.55
119.25

0.80%
(1,426.09)
A1/A+
NA

0.36 0.35
06368LGU4 BANK OF MONTREAL 5.2
12/12/2024 135,000.00 03/25/2024

5.42%
134,781.30
134,862.05

99.84 5.56%
134,777.94
370.50

1.22%
(84.11)
A2/A-
AA-

0.45 0.44
89236TKN4 TOYOTA MOTOR CREDIT CORP

4.8 01/10/2025 130,000.00 01/10/2023

4.83%
129,910.30
129,976.25

99.70 5.39%
129,606.51
2,964.00

1.17%
(369.75)
A1/A+
A+

0.53 0.50
02665WEA5 AMERICAN HONDA FINANCE
CORP 1.5 01/13/2025 140,000.00 04/18/2024

5.54%
136,035.20
137,078.57

97.90 5.54%
137,054.38
980.00

1.24%
(24.18)
A3/A-
A

0.54 0.52
63743HFE7

NATIONAL RURAL UTILITIES

COOPERATIVE FINANCE CORP

3.45 06/15/2025
35,000.00 04/27/2022

3.46%
34,990.55
34,997.87

98.06 5.56%
34,319.40

53.67 0.31%
(678.47)
A2/A-
A

0.96 0.92
6174468C6 MORGAN STANLEY 4.0
07/23/2025 140,000.00 03/15/2024

5.31%
137,649.40
138,147.29

98.50 5.47%
137,903.55
2,457.78

1.25%
(243.73)
A1/A-
A+

1.06 1.01
931142EW9 WALMART INC 3.9 09/09/2025 30,000.00 09/06/2022

3.92%
29,979.00
29,992.98

98.56 5.15%
29,569.40
364.00

0.27%
(423.58)
Aa2/AA
AA

1.19 1.13
437076CR1 HOME DEPOT INC 4.0
09/15/2025 40,000.00 09/12/2022

4.01%
39,985.60
39,995.05

98.54 5.25%
39,417.37
471.11

0.36%
(577.68)
A2/A
A

1.21 1.15
20030NCS8 COMCAST CORP 3.95
10/15/2025 140,000.00 03/11/2024

4.94%
137,895.80
138,294.19

98.42 5.22%
137,792.57
1,167.44

1.25%
(501.61)
A3/A-
A-

1.29 1.23
46647PDM5 JPMORGAN CHASE & CO 5.546
12/15/2025 60,000.00 09/19/2023

5.98%
59,686.80
59,884.03

99.90 6.24%
59,938.69
147.89

0.54%

54.66 A1/A-
AA-

1.46 0.45
857477BR3 STATE STREET CORP 1.746
02/06/2026 35,000.00 02/02/2022

1.75%
35,000.00
35,000.00

97.57 5.84%
34,150.68
246.14

0.31%
(849.33)
A1/A
AA-

1.61 0.58
00440EAV9 CHUBB INA HOLDINGS LLC 3.35
05/03/2026 135,000.00 08/24/2023

5.19%
128,866.95
130,796.45

96.76 5.21%
130,631.91
728.63

1.18%
(164.54)
A3/A
A

1.84 1.75
61747YET8 MORGAN STANLEY 4.679
07/17/2026 60,000.00 07/18/2022

4.68%
60,000.00
60,000.00

99.02 6.32%
59,411.97
1,278.93

0.54%
(588.03)
A1/A-
A+

2.05 0.99
69371RS56 PACCAR FINANCIAL CORP 5.05
08/10/2026 80,000.00 12/08/2023

4.96%
80,172.00
80,136.40

99.90 5.10%
79,918.00
1,582.33

0.72%
(218.39)
A1/A+
NA

2.11 1.94
931142ER0 WALMART INC 1.05 09/17/2026 25,000.00 09/08/2021

1.09%
24,952.75
24,979.09

92.18 4.81%
23,045.93

75.83 0.21%
(1,933.16)
Aa2/AA
AA

2.22 2.14

CONFIDENTIAL | 11
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
89115A2V3 TORONTO-DOMINION BANK

5.264 12/11/2026 55,000.00 12/04/2023

5.26%
55,000.00
55,000.00

99.97 5.28%
54,981.02
160.84

0.50%
(18.98)
A1/A
AA-

2.45 2.26
78016HZT0 ROYAL BANK OF CANADA 4.875
01/19/2027 105,000.00 01/10/2024

4.88%
104,973.75
104,977.68

99.34 5.15%
104,303.96
2,303.44

0.94%
(673.72)
A1/A
AA-

2.56 2.32
06051GLE7 BANK OF AMERICA CORP 5.08
01/20/2027 135,000.00 08/22/2023

5.90%
132,557.85
133,423.70

99.40 5.93%
134,189.76
3,067.05

1.21%
766.05
A1/A-
AA-

2.56 1.44
037833CJ7 APPLE INC 3.35 02/09/2027 150,000.00 01/24/2023

4.09%
145,929.00
147,369.72

96.40 4.83%
144,601.15
1,982.08

1.31%
(2,768.57)
Aaa/AA+
NA

2.61 2.43
17275RBQ4 CISCO SYSTEMS INC 4.8
02/26/2027 60,000.00 02/21/2024

4.85%
59,922.00
59,930.97

99.73 4.91%
59,837.75
1,000.00

0.54%
(93.22)
A1/AA-
NA

2.66 2.43
857477CL5 STATE STREET CORP 4.993
03/18/2027 125,000.00 03/13/2024

4.99%
125,000.00
125,000.00

99.88 5.04%
124,848.83
1,785.69

1.13%
(151.17)
A1/A
AA-

2.71 2.48
665859AW4 NORTHERN TRUST CORP 4.0
05/10/2027 150,000.00 09/28/2022

4.74%
145,396.50
147,147.09

97.61 4.90%
146,421.03
850.00

1.33%
(726.06)
A2/A+
A+

2.86 2.65
14913UAL4 CATERPILLAR FINANCIAL
SERVICES CORP 5.0 05/14/2027 140,000.00 05/21/2024

4.93%
140,257.04
140,247.81
100.06

4.97%
140,086.41
913.89

1.27%
(161.40)
A2/A
A+

2.87 2.63
438516CJ3 HONEYWELL INTERNATIONAL
INC 4.95 02/15/2028 125,000.00 02/13/2023

4.44%
127,803.75
127,019.64
100.78

4.71%
125,980.30
2,337.50

1.14%
(1,039.34)
A2/A
A

3.63 3.16
58933YBH7 MERCK & CO INC 4.05
05/17/2028 30,000.00 05/08/2023

4.07%
29,975.70
29,981.17

97.90 4.65%
29,369.07
148.50

0.27%
(612.10)
A1/A+
NA

3.88 3.53
437076DC3 HOME DEPOT INC 4.75
06/25/2029 50,000.00 06/17/2024

4.90%
49,677.50
49,678.56

99.42 4.88%
49,708.84

39.58 0.45%

30.28 A2/A
A

4.99 4.39
Total Corporate 2,755,000.00 4.20%
2,748,269.09
2,739,611.51

98.86 5.31%
2,723,204.20
29,768.58

24.66%
(16,407.31)
A2/A
A+

1.73 1.50

MONEY MARKET
FUND
31846V203 FIRST AMER:GVT OBLG Y 81,353.77 --

4.92%
81,353.77
81,353.77

1.00 4.92%
81,353.77

0.00 0.74%

0.00 Aaa/
AAAm
AAA

0.00 0.00
Total Money
Market Fund 81,353.77 4.92%
81,353.77
81,353.77

1.00 4.92%
81,353.77

0.00 0.74%

0.00 Aaa/
AAAm
AAA

0.00 0.00

MUNICIPAL
BONDS

CONFIDENTIAL | 12
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
13063D7D4 CALIFORNIA STATE 5.5
10/01/2028 100,000.00 10/04/2023

5.12%
101,634.00
101,396.59
102.61

4.81%
102,610.00
1,375.00

0.93%
1,213.41
Aa2/AA-
AA

4.25 3.72
Total Municipal
Bonds 100,000.00 5.12%
101,634.00
101,396.59
102.61

4.81%
102,610.00
1,375.00

0.93%
1,213.41
Aa2/AA-
AA

4.25 3.72

SUPRANATIONAL
4581X0DZ8

INTER-AMERICAN
DEVELOPMENT BANK 0.5
09/23/2024
170,000.00 09/15/2021

0.52%
169,874.20
169,990.36

98.88 5.40%
168,098.73
231.39

1.52%
(1,891.63)
Aaa/AAA
NA

0.23 0.23
45950KCR9 INTERNATIONAL FINANCE CORP

1.375 10/16/2024 100,000.00 07/12/2021

0.54%
102,690.00
100,241.87

98.83 5.41%
98,826.01
286.46

0.89%
(1,415.86)
Aaa/AAA
NA

0.30 0.29
45950KDF4 INTERNATIONAL FINANCE CORP

4.375 01/15/2027 80,000.00 11/29/2023

4.49%
79,739.20
79,786.95

99.29 4.68%
79,430.61
1,613.89

0.72%
(356.34)
Aaa/AAA
NA

2.54 2.33
4581X0EM6

INTER-AMERICAN
DEVELOPMENT BANK 4.375
02/01/2027
215,000.00 12/05/2023

4.41%
214,817.25
214,849.43

99.28 4.67%
213,457.11
3,919.27

1.93%
(1,392.32)
Aaa/AAA
NA

2.59 2.37
459058KT9

INTERNATIONAL BANK FOR

RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
140,000.00 09/07/2023

4.54%
133,740.60
134,782.65

96.35 4.50%
134,895.73
2,300.28

1.22%
113.08
Aaa/AAA
NA

4.03 3.65
459058KW2

INTERNATIONAL BANK FOR

RECONSTRUCTION AND
DEVELOPM 4.625 08/01/2028
115,000.00 --

4.92%
113,575.80
113,786.45
100.45

4.50%
115,516.51
2,216.15

1.05%
1,730.06
Aaa/AAA
NA

4.09 3.62
Total
Supranational 820,000.00 3.23%
814,437.05
813,437.72

98.82 4.86%
810,224.70
10,567.43

7.34%
(3,213.01)
Aaa/AAA
NA

2.27 2.06

US TREASURY
912797GB7 UNITED STATES TREASURY
07/11/2024 80,000.00 02/26/2024

5.34%
78,455.00
79,885.56

99.85 4.86%
79,883.30

0.00 0.72%
(2.26)
P-1/A-1+
F1+

0.03 0.03
91282CCT6 UNITED STATES TREASURY 0.375
08/15/2024 250,000.00 08/25/2021

0.45%
249,443.36
249,976.91

99.38 5.30%
248,452.15
352.85

2.25%
(1,524.77)
Aaa/AA+
AA+

0.13 0.13
912797GL5 UNITED STATES TREASURY
09/05/2024 150,000.00 03/27/2024

5.31%
146,573.72
148,595.44

99.04 5.28%
148,564.74

0.00 1.35%
(30.70)
P-1/A-1+
F1+

0.18 0.18
912797KU0 UNITED STATES TREASURY
10/17/2024 200,000.00 04/18/2024

5.37%
194,808.82
196,902.50

98.44 5.31%
196,877.00

0.00 1.78%
(25.50)
P-1/A-1+
F1+

0.30 0.29
91282CDH1 UNITED STATES TREASURY 0.75
11/15/2024 225,000.00 11/18/2021

0.83%
224,437.50
224,929.43

98.31 5.35%
221,189.94
215.52

2.00%
(3,739.49)
Aaa/AA+
AA+

0.38 0.37

CONFIDENTIAL | 13
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
912796ZV4 UNITED STATES TREASURY
12/26/2024 250,000.00 05/29/2024

5.31%
242,589.84
243,719.01

97.47 5.31%
243,677.29

0.00 2.21%
(41.71)
P-1/A-1+
F1+

0.49 0.48
912828J27 UNITED STATES TREASURY 2.0
02/15/2025 250,000.00 06/25/2024

5.29%
244,902.34
245,011.26

97.96 5.36%
244,890.14
1,881.87

2.22%
(121.13)
Aaa/AA+
AA+

0.63 0.61
912828ZF0 UNITED STATES TREASURY 0.5
03/31/2025 125,000.00 03/25/2021

0.58%
124,609.38
124,927.11

96.57 5.21%
120,714.11
157.10

1.09%
(4,213.00)
Aaa/AA+
AA+

0.75 0.73
912828ZT0 UNITED STATES TREASURY 0.25
05/31/2025 250,000.00 02/25/2021

0.60%
246,337.89
249,213.41

95.62 5.19%
239,055.18

52.94 2.16%
(10,158.24)
Aaa/AA+
AA+

0.92 0.89
91282CEY3 UNITED STATES TREASURY 3.0
07/15/2025 260,000.00 06/23/2023

4.71%
251,417.97
255,663.21

97.90 5.10%
254,538.48
3,600.00

2.30%
(1,124.74)
Aaa/AA+
AA+

1.04 0.99
91282CAZ4 UNITED STATES TREASURY 0.375
11/30/2025 175,000.00 12/09/2020

0.41%
174,699.22
174,914.37

93.82 4.94%
164,178.71

55.58 1.49%
(10,735.66)
Aaa/AA+
AA+

1.42 1.38
9128286L9 UNITED STATES TREASURY 2.25
03/31/2026 275,000.00 --

3.11%
268,007.23
271,195.24

95.75 4.81%
263,312.50
1,555.33

2.38%
(7,882.74)
Aaa/AA+
AA+

1.75 1.68
912828R36 UNITED STATES TREASURY 1.625
05/15/2026 265,000.00 --

2.74%
256,468.75
259,967.43

94.41 4.77%
250,197.26
549.98

2.27%
(9,770.16)
Aaa/AA+
AA+

1.87 1.81
912828YG9 UNITED STATES TREASURY 1.625
09/30/2026 200,000.00 12/28/2021

1.24%
203,531.25
201,670.02

93.59 4.66%
187,179.69
816.94

1.69%
(14,490.34)
Aaa/AA+
AA+

2.25 2.16
912828U24 UNITED STATES TREASURY 2.0
11/15/2026 265,000.00 03/29/2022

2.55%
258,602.73
261,720.03

94.10 4.65%
249,369.14
676.90

2.26%
(12,350.89)
Aaa/AA+
AA+

2.38 2.27
91282CEF4 UNITED STATES TREASURY 2.5
03/31/2027 200,000.00 05/25/2022

2.73%
197,890.63
198,804.69

94.79 4.54%
189,570.31
1,256.83

1.72%
(9,234.38)
Aaa/AA+
AA+

2.75 2.60
912828X88 UNITED STATES TREASURY 2.375
05/15/2027 275,000.00 --

2.96%
267,540.04
270,665.27

94.18 4.56%
258,994.14
834.15

2.34%
(11,671.13)
Aaa/AA+
AA+

2.87 2.72
91282CFM8 UNITED STATES TREASURY 4.125
09/30/2027 260,000.00 10/26/2022

4.19%
259,278.91
259,524.62

98.87 4.50%
257,054.69
2,695.90

2.33%
(2,469.93)
Aaa/AA+
AA+

3.25 2.98
91282CGC9 UNITED STATES TREASURY 3.875
12/31/2027 100,000.00 05/25/2023

3.98%
99,578.13
99,679.08

98.08 4.47%
98,082.03

10.53 0.89%
(1,597.05)
Aaa/AA+
AA+

3.50 3.23
91282CGT2 UNITED STATES TREASURY 3.625
03/31/2028 240,000.00 04/19/2023

3.73%
238,828.13
239,112.18

97.19 4.45%
233,250.00
2,186.89

2.11%
(5,862.18)
Aaa/AA+
AA+

3.75 3.43
Total US Treasury 4,295,000.00 3.04%
4,228,000.84
4,256,076.77

96.64 4.93%
4,149,030.79
16,899.32

37.57%
(107,045.97)
Aaa/AA+
AA+

1.58 1.49
Total Portfolio 11,305,874.83 3.70%
11,176,647.75
11,203,855.05

96.99 5.01%
11,044,781.18
71,093.94
100.00%
(159,073.87)
Aa2/AA-
AA

2.15 1.83

CONFIDENTIAL | 14
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

HOLDINGS REPORT
Cusip Security Description Par Value/
Units
Purchase Date
Purchase Yield
Cost Value
Book Value
Mkt Price
Mkt YTM
Market Value
Accrued Int.
% of Port.

Gain/Loss
Moody's/
S&P/
Fitch
Maturity
Duration
Total Market
Value + Accrued 11,115,875.12

CONFIDENTIAL | 15
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss

ACQUISITIONS
Purchase 06/04/2024 31846V203 1,020.04 FIRST AMER:GVT OBLG Y 1.000 4.92% (1,020.04) 0.00 (1,020.04) 0.00 Purchase 06/11/2024 31846V203 1,447.60 FIRST AMER:GVT OBLG Y 1.000 4.91% (1,447.60) 0.00 (1,447.60) 0.00 Purchase 06/12/2024 31846V203 3,510.00 FIRST AMER:GVT OBLG Y 1.000 4.92% (3,510.00) 0.00 (3,510.00) 0.00 Purchase 06/14/2024 31846V203 253,593.75 FIRST AMER:GVT OBLG Y 1.000 4.91% (253,593.75) 0.00 (253,593.75) 0.00 Purchase 06/17/2024 31846V203 267,546.69 FIRST AMER:GVT OBLG Y 1.000 4.91% (267,546.69) 0.00 (267,546.69) 0.00 Purchase 06/17/2024 31846V203 5,726.17 FIRST AMER:GVT OBLG Y 1.000 4.91% (5,726.17) 0.00 (5,726.17) 0.00 Purchase 06/18/2024 31846V203 2,480.25 FIRST AMER:GVT OBLG Y 1.000 4.92% (2,480.25) 0.00 (2,480.25) 0.00 Purchase 06/20/2024 31846V203 343.57 FIRST AMER:GVT OBLG Y 1.000 4.92% (343.57) 0.00 (343.57) 0.00 Purchase 06/20/2024 31846V203 8,079.05 FIRST AMER:GVT OBLG Y 1.000 4.92% (8,079.05) 0.00 (8,079.05) 0.00 Purchase 06/21/2024 31846V203 1,971.36 FIRST AMER:GVT OBLG Y 1.000 4.92% (1,971.36) 0.00 (1,971.36) 0.00 Purchase 06/25/2024 437076DC3 50,000.00 HOME DEPOT INC 4.75 06/25/2029 99.355 4.90%
(49,677.50) 0.00 (49,677.50) 0.00
Purchase 06/25/2024 31846V203 2,291.03 FIRST AMER:GVT OBLG Y 1.000 4.92% (2,291.03) 0.00 (2,291.03) 0.00 Purchase 06/26/2024 3133ERDS7 225,000.00

FEDERAL FARM CREDIT

BANKS FUNDING CORP

4.75 05/06/2027
100.536 4.55% (226,206.00) (1,484.38) (227,690.38) 0.00 Purchase 06/26/2024 912828J27 250,000.00 UNITED STATES TREASURY

2.0 02/15/2025 97.961 5.29% (244,902.34) (1,813.19) (246,715.53) 0.00 Total Purchase 1,073,009.51 (1,068,795.35) (3,297.57) (1,072,092.92) 0.00 TOTAL
ACQUISITIONS 1,073,009.51 (1,068,795.35) (3,297.57) (1,072,092.92) 0.00

DISPOSITIONS
Maturity 06/14/2024 3130A1XJ2 (250,000.00) FEDERAL HOME LOAN BANKS 2.875 06/14/2024 100.000 2.88% 250,000.00 0.00 250,000.00 0.00 Maturity 06/15/2024 91282CCG4 (250,000.00) UNITED STATES TREASURY

0.25 06/15/2024 100.000 0.25% 250,000.00 0.00 250,000.00 0.00 Total Maturity (500,000.00) 500,000.00 0.00 500,000.00 0.00 Sale 06/10/2024 31846V203 (1,000.00) FIRST AMER:GVT OBLG Y 1.000 4.91% 1,000.00 0.00 1,000.00 0.00 Sale 06/25/2024 31846V203 (47,385.89) FIRST AMER:GVT OBLG Y 1.000 4.92% 47,385.89 0.00 47,385.89 0.00 Sale 06/26/2024 31846V203 (474,405.91) FIRST AMER:GVT OBLG Y 1.000 4.92% 474,405.91 0.00 474,405.91 0.00 Total Sale (522,791.80) 522,791.80 0.00 522,791.80 0.00

CONFIDENTIAL | 16
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
TOTAL
DISPOSITIONS (1,022,791.80) 1,022,791.80 0.00 1,022,791.80 0.00 OTHER
Coupon 06/01/2024 3137BNGT5 0.00 FHMS K-054 A2 2.745
01/25/2026 4.56% 400.31 0.00 400.31 0.00
Coupon 06/01/2024 3137BVZ82 0.00 FHMS K-063 A2 3.43
01/25/2027 4.47% 314.42 0.00 314.42 0.00
Coupon 06/01/2024 3137FETN0 0.00 FHMS K-073 A2 3.35
01/25/2028 4.24% 446.67 0.00 446.67 0.00
Coupon 06/01/2024 3137FHPJ6 0.00 FHMS K-080 A2 3.926
07/25/2028 4.44% 359.88 0.00 359.88 0.00
Coupon 06/01/2024 3137FJEH8 0.00 FHMS K-081 A2 3.9
08/25/2028 4.84% 341.25 0.00 341.25 0.00
Coupon 06/01/2024 3137FJXV6 0.00 FHMS K-083 A2 4.05
09/25/2028 4.53% 337.50 0.00 337.50 0.00
Coupon 06/01/2024 3137FKZZ2 0.00 FHMS K-088 A2 3.69
01/25/2029 4.42% 338.25 0.00 338.25 0.00
Coupon 06/01/2024 3137H4BY5 0.00 FHMS K-746 A2 2.031
09/25/2028 5.23% 186.18 0.00 186.18 0.00
Coupon 06/01/2024 3137H5YC5 0.00 FHMS K-748 A2 2.26
01/25/2029 4.93% 216.58 0.00 216.58 0.00
Coupon 06/11/2024 89115A2V3 0.00 TORONTO-DOMINION
BANK 5.264 12/11/2026 5.26% 1,447.60 0.00 1,447.60 0.00 Coupon
06/12/2024 06368LGU4 0.00 BANK OF MONTREAL 5.2
12/12/2024 5.42% 3,510.00 0.00 3,510.00 0.00
Coupon 06/14/2024 3130A1XJ2 0.00 FEDERAL HOME LOAN
BANKS 2.875 06/14/2024 2.88% 3,593.75 0.00 3,593.75 0.00 Coupon 06/15/2024 89240BAC2 0.00 TAOT 2021-A A3 0.26
05/15/2025 0.00% 0.13 0.00 0.13 0.00
Coupon 06/15/2024 47788UAC6 0.00 JDOT 2021 A3 0.36
09/15/2025 0.38% 1.38 0.00 1.38 0.00
Coupon 06/15/2024 91282CCG4 0.00 UNITED STATES TREASURY

0.25 06/15/2024 0.25% 312.50 0.00 312.50 0.00

CONFIDENTIAL | 17
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 06/15/2024 47789QAC4 0.00 JDOT 2021-B A3 0.52
03/16/2026 0.52% 6.52 0.00 6.52 0.00
Coupon 06/15/2024 44935FAD6 0.00 HART 2021-C A3 0.74
05/15/2026 0.76% 6.60 0.00 6.60 0.00
Coupon 06/15/2024 43815BAC4 0.00 HAROT 2022-1 A3 1.88
05/15/2026 1.90% 58.26 0.00 58.26 0.00
Coupon 06/15/2024 47787JAC2 0.00 JDOT 2022 A3 0.36
09/15/2026 2.34% 51.58 0.00 51.58 0.00
Coupon 06/15/2024 63743HFE7 0.00

NATIONAL RURAL

UTILITIES COOPERATIVE
FINANCE CORP 3.45
06/15/2025

3.46% 603.75 0.00 603.75 0.00
Coupon 06/15/2024 47800AAC4 0.00 JDOT 2022-B A3 3.74
02/16/2027 3.77% 130.44 0.00 130.44 0.00
Coupon 06/15/2024 46647PDM5 0.00 JPMORGAN CHASE & CO

5.546 12/15/2025 5.80% 1,663.80 0.00 1,663.80 0.00
Coupon 06/15/2024 58770AAC7 0.00 MBART 2023-1 A3 4.51
11/15/2027 4.56% 131.54 0.00 131.54 0.00
Coupon 06/15/2024 448979AD6 0.00 HART 2023-A A3 4.58
04/15/2027 4.63% 190.83 0.00 190.83 0.00
Coupon 06/15/2024 47787CAC7 0.00 JDOT 2023-C A3 5.48
05/15/2028 5.55% 479.50 0.00 479.50 0.00
Coupon 06/15/2024 02582JKD1 0.00 AMXCA 2023-3 A 5.23
09/15/2028 5.29%
501.21 0.00 501.21 0.00
Coupon 06/15/2024 89239FAD4 0.00 TAOT 2023-D A3 5.54
08/15/2028 5.62% 207.75 0.00 207.75 0.00
Coupon 06/15/2024 3133EPN50 0.00

FEDERAL FARM CREDIT

BANKS FUNDING CORP

4.25 12/15/2028

3.89% 2,337.50 0.00 2,337.50 0.00
Coupon 06/15/2024 89238DAD0 0.00 TAOT 2024-A A3 4.83
10/16/2028 4.89% 241.50 0.00 241.50 0.00
Coupon 06/15/2024 448973AD9 0.00 HART 2024-A A3 4.99
02/15/2029 5.05% 187.12 0.00 187.12 0.00
Coupon 06/15/2024 02582JKH2 0.00 AMXCA 2024-1 A 5.23
04/16/2029 5.29% 435.83 0.00 435.83 0.00

CONFIDENTIAL | 18
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Coupon 06/16/2024 362554AC1 0.00 GMCAR 2021-4 A3 0.68
09/16/2026 0.68% 6.97 0.00 6.97 0.00
Coupon 06/16/2024 380146AC4 0.00 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 15.40 0.00 15.40 0.00
Coupon 06/16/2024 36265WAD5 0.00 GMCAR 2022-3 A3 3.64
04/16/2027 3.67% 91.00 0.00 91.00 0.00
Coupon 06/16/2024 362583AD8 0.00 GMCAR 2023-2 A3 4.47
02/16/2028 4.51% 149.00 0.00 149.00 0.00
Coupon 06/18/2024 43815PAC3 0.00 HAROT 2022-2 A3 3.73
07/20/2026 3.76% 104.40 0.00 104.40 0.00
Coupon 06/20/2024 36266FAC3 0.00 GMALT 2022-2 A3 3.42
06/20/2025 0.00% 23.03 0.00 23.03 0.00
Coupon 06/20/2024 379929AD4 0.00 GMALT 2023-3 A3 5.38
11/20/2026 5.45% 44.83 0.00 44.83 0.00
Coupon 06/20/2024 36269FAD8 0.00 GMALT 2024-1 A3 5.09
03/22/2027 5.15% 275.71 0.00 275.71 0.00
Coupon 06/21/2024 43813GAC5 0.00 HAROT 2021-1 A3 0.27
04/21/2025 0.00% 0.01 0.00 0.01 0.00
Coupon 06/21/2024 43815GAC3 0.00 HAROT 2021-4 A3 0.88
01/21/2026 0.89% 11.46 0.00 11.46 0.00
Coupon 06/21/2024 43815JAC7 0.00 HAROT 2023-1 A3 5.04
04/21/2027 5.10% 105.00 0.00
105.00 0.00
Coupon 06/21/2024 438123AC5 0.00 HAROT 2023-4 A3 5.67
06/21/2028 5.75% 165.38 0.00 165.38 0.00
Coupon 06/25/2024 05593AAC3 0.00 BMWLT 2023-1 A3 5.16
11/25/2025 5.22% 63.99 0.00 63.99 0.00
Coupon 06/30/2024 91282CGC9 0.00 UNITED STATES TREASURY

3.875 12/31/2027 3.98% 1,937.50 0.00 1,937.50 0.00
Total Coupon 0.00 22,033.81 0.00 22,033.81 0.00
Custody Fee 06/25/2024 CCYUSD (91.60) Cash 0.00% (91.60) 0.00 (91.60) 0.00 Total Custody
Fee (91.60) (91.60) 0.00 (91.60) 0.00
Dividend 06/30/2024 31846V203 0.00 FIRST AMER:GVT OBLG Y 4.92% 1,000.59 0.00 1,000.59 0.00 Total Dividend 0.00 1,000.59 0.00 1,000.59 0.00

CONFIDENTIAL | 19
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Management
Fee 06/10/2024 CCYUSD (1,000.00) Cash 0.00% (1,000.00) 0.00 (1,000.00) 0.00 Total
Management
Fee (1,000.00) (1,000.00) 0.00 (1,000.00) 0.00
Principal
Paydown 06/15/2024 89240BAC2 602.58 TAOT 2021-A A3 0.26 05/15/2025 0.00% 602.58 -- 602.58 0.01
Principal
Paydown 06/15/2024 47788UAC6 1,020.16 JDOT 2021 A3 0.36 09/15/2025 0.38% 1,020.16 -- 1,020.16 0.00
Principal
Paydown 06/15/2024 47789QAC4 1,812.67 JDOT 2021-B A3 0.52 03/16/2026 0.52% 1,812.67 -- 1,812.67 (0.00)
Principal
Paydown 06/15/2024 44935FAD6 1,244.51 HART 2021-C A3 0.74 05/15/2026 0.76% 1,244.51 -- 1,244.51 0.00
Principal
Paydown 06/15/2024 43815BAC4 3,129.71 HAROT 2022-1 A3 1.88 05/15/2026 1.90% 3,129.71 -- 3,129.71 (0.00)
Principal
Paydown 06/15/2024 47787JAC2 1,692.20 JDOT 2022 A3 0.36 09/15/2026 2.34% 1,692.20 -- 1,692.20 0.00
Principal
Paydown 06/15/2024 47800AAC4 2,244.62 JDOT 2022-B A3 3.74 02/16/2027 3.77% 2,244.62 -- 2,244.62 0.00
Principal
Paydown 06/16/2024 362554AC1 1,125.31 GMCAR 2021-4 A3 0.68 09/16/2026 0.68% 1,125.31 -- 1,125.31 (0.00)
Principal
Paydown 06/16/2024 380146AC4
1,268.40 GMCAR 2022-1 A3 1.26
11/16/2026 1.27% 1,268.40 -- 1,268.40 (0.00)
Principal
Paydown 06/16/2024 36265WAD5 1,322.59 GMCAR 2022-3 A3 3.64 04/16/2027 3.67% 1,322.59 -- 1,322.59 (0.00)
Principal
Paydown 06/18/2024 43815PAC3 2,375.85 HAROT 2022-2 A3 3.73 07/20/2026 3.76% 2,375.85 -- 2,375.85 (0.00)
Principal
Paydown 06/20/2024 36266FAC3 8,079.05 GMALT 2022-2 A3 3.42 06/20/2025 0.00% 8,079.05 -- 8,079.05 (0.01)
Principal
Paydown 06/21/2024 43813GAC5 50.33 HAROT 2021-1 A3 0.27 04/21/2025 0.00% 50.33 -- 50.33 0.01
Principal
Paydown 06/21/2024 43815GAC3 1,639.18 HAROT 2021-4 A3 0.88 01/21/2026 0.89% 1,639.18 -- 1,639.18 (0.00)
Principal
Paydown 06/25/2024 05593AAC3 1,669.21 BMWLT 2023-1 A3 5.16 11/25/2025 5.22% 1,669.21 -- 1,669.21 (0.00)

CONFIDENTIAL | 20
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

TRANSACTION LEDGER
Transaction
Type
Settlement
Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/
Sold Total Amount Gain/Loss
Total Principal
Paydown 29,276.37 29,276.37 -- 29,276.37 (0.00)

TOTAL OTHER
TRANSACTIONS 28,184.77 51,219.17 0.00 51,219.17 (0.00)

CONFIDENTIAL | 21
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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

CASH & EQUIVALENTS
31846V203 FIRST AMER:GVT OBLG Y
81,353.77
56,136.06
548,009.51
(522,791.80)
81,353.77

0.00 1,020.04

0.00 1,020.04

0.00 0.00

0.00 1,020.04
1,020.04
CCYUSD Receivable
2,938.09
1,020.04

0.00 0.00
2,938.09

0.00 0.00

0.00 0.00

0.00 0.00

0.00 0.00

0.00 Total Cash & Equivalents 84,291.86
57,156.10
548,009.51
(522,791.80)
84,291.86

0.00 1,020.04

0.00 1,020.04

0.00 0.00

0.00 1,020.04 1,020.04

FIXED INCOME
00440EAV9 CHUBB INA HOLDINGS LLC

3.35 05/03/2026
08/24/2023
08/28/2023
135,000.00
130,608.51

0.00 0.00
130,796.45
351.75

0.00 728.63
376.88
187.94

0.00 187.94
564.81
564.81
02582JKD1 AMXCA 2023-3 A 5.23
09/15/2028
09/12/2023
09/19/2023
115,000.00
114,995.58

0.00 0.00
114,995.67
267.31
501.21
267.31
501.21

0.08 0.00

0.08 501.29
501.29
02582JKH2 AMXCA 2024-1 A 5.23
04/16/2029
04/16/2024
04/23/2024
100,000.00
99,979.94

0.00 0.00
99,980.28
232.44
435.83
232.44
435.83

0.34 0.00

0.34 436.17
436.17
02665WEA5 AMERICAN HONDA FINANCE
CORP 1.5 01/13/2025
04/18/2024
04/22/2024
140,000.00
136,631.41

0.00 0.00
137,078.57
805.00

0.00 980.00
175.00
447.16

0.00 447.16
622.16
622.16
037833CJ7 APPLE INC 3.35 02/09/2027
01/24/2023
01/26/2023
150,000.00
147,286.92

0.00 0.00
147,369.72
1,563.33

0.00 1,982.08
418.75

82.80 0.00

82.80 501.55
501.55

CONFIDENTIAL | 22
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
05593AAC3 BMWLT 2023-1 A3 5.16
11/25/2025
02/07/2023
02/15/2023
13,212.02
14,881.04

0.00 (1,669.21)
13,211.86

12.80 63.99

11.36 62.55

0.03 0.00

0.03 62.58

62.58 06051GLE7 BANK OF AMERICA CORP

5.08 01/20/2027
08/22/2023
08/24/2023
135,000.00
133,340.45

0.00 0.00
133,423.70
2,495.55

0.00 3,067.05
571.50

83.26 0.00

83.26 654.76
654.76
06368LGU4 BANK OF MONTREAL 5.2
12/12/2024
03/25/2024
03/27/2024
135,000.00
134,836.82

0.00 0.00
134,862.05
3,295.50
3,510.00
370.50
585.00

25.23 0.00

25.23 610.23
610.23
13063D7D4 CALIFORNIA STATE 5.5
10/01/2028
10/04/2023
10/11/2023
100,000.00
101,423.57

0.00 0.00
101,396.59
916.67

0.00 1,375.00
458.33

0.00 (26.98)
(26.98)
431.35
431.35
14913UAL4

CATERPILLAR FINANCIAL
SERVICES CORP 5.0
05/14/2027
05/21/2024
05/23/2024
140,000.00
140,254.91

0.00 0.00
140,247.81
330.56

0.00 913.89
583.33

0.00 (7.10)
(7.10)
576.23
576.23
17275RBQ4 CISCO SYSTEMS INC 4.8
02/26/2027
02/21/2024
02/26/2024
60,000.00
59,928.83

0.00 0.00
59,930.97
760.00

0.00 1,000.00
240.00

2.14 0.00

2.14 242.14
242.14
20030NCS8
COMCAST CORP 3.95
10/15/2025
03/11/2024
03/13/2024
140,000.00
138,185.53

0.00 0.00
138,294.19
706.61

0.00 1,167.44
460.83
108.65

0.00 108.65
569.48
569.48
3130A1XJ2 FEDERAL HOME LOAN BANKS

2.875 06/14/2024
03/24/2020
03/25/2020

0.00 250,163.32

0.00 (250,000.00)

0.00 3,334.20
3,593.75

0.00 259.55

0.00 (163.32)
(163.32)

96.23 96.23
3130ATS57 FEDERAL HOME LOAN BANKS

4.5 03/10/2028
03/21/2023
03/22/2023
275,000.00
279,712.34

0.00 0.00
279,609.75
2,784.38

0.00 3,815.63
1,031.25

0.00 (102.59)
(102.59)
928.66
928.66

CONFIDENTIAL | 23
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
3130AXU63 FEDERAL HOME LOAN BANKS

4.625 11/17/2026
11/16/2023
11/17/2023
160,000.00
159,767.70

0.00 0.00
159,775.46
287.78

0.00 904.44
616.67

7.75 0.00

7.75 624.42
624.42
3133ENKS8

FEDERAL FARM CREDIT
BANKS FUNDING CORP 1.125
01/06/2025
01/06/2022
01/11/2022
80,000.00
79,963.87

0.00 0.00
79,968.82
362.50

0.00 437.50

75.00 4.95

0.00 4.95

79.95 79.95
3133EPN50

FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.25
12/15/2028
12/28/2023
12/29/2023
110,000.00
111,636.69

0.00 0.00
111,607.08
2,155.69
2,337.50
207.78
389.58

0.00 (29.61)
(29.61)
359.97
359.97
3133ERDS7

FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.75
05/06/2027
06/25/2024
06/26/2024
225,000.00

0.00 226,206.00

0.00 226,200.22

0.00 (1,484.38)
1,632.81
148.43

0.00 (5.78)
(5.78)
142.66
142.66
3133ERFJ5

FEDERAL FARM CREDIT
BANKS FUNDING CORP 4.5
05/20/2027
05/23/2024
05/24/2024
115,000.00
114,077.61

0.00 0.00
114,103.16
158.13

0.00 589.38
431.25

25.55 0.00

25.55 456.80
456.80
3135G06G3

FEDERAL NATIONAL
MORTGAGE ASSOCIATION 0.5
11/07/2025
11/18/2020
11/19/2020
225,000.00
224,933.05

0.00 0.00
224,936.89

75.00 0.00
168.75

93.75 3.83

0.00 3.83

97.58 97.58
3137BNGT5 FHMS K-054 A2 2.745
01/25/2026
02/15/2023
02/21/2023
175,000.00
170,110.25

0.00 0.00
170,363.61
400.31
400.31
400.31
400.31
253.35

0.00 253.35
653.66
653.66
3137BVZ82 FHMS K-063 A2 3.43
01/25/2027
02/06/2024
02/09/2024
110,000.00
107,152.57

0.00 0.00
107,243.06
314.42
314.42
314.42
314.42

90.49 0.00

90.49 404.91
404.91
3137FETN0 FHMS K-073 A2 3.35
01/25/2028
05/24/2023
05/30/2023
160,000.00
155,141.01

0.00 0.00
155,252.37
446.67
446.67
446.67
446.67
111.36

0.00 111.36
558.03
558.03

CONFIDENTIAL | 24
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
3137FHPJ6 FHMS K-080 A2 3.926
07/25/2028
01/23/2024
01/26/2024
110,000.00
107,758.86

0.00 0.00
107,803.96
359.88
359.88
359.88
359.88

45.09 0.00

45.09 404.97
404.97
3137FJEH8 FHMS K-081 A2 3.9
08/25/2028
09/15/2023
09/20/2023
105,000.00
101,191.93

0.00 0.00
101,266.99
341.25
341.25
341.25
341.25

75.06 0.00

75.06 416.31
416.31
3137FJXV6 FHMS K-083 A2 4.05
09/25/2028
03/13/2024
03/18/2024
100,000.00
98,036.25

0.00 0.00
98,074.18
337.50
337.50
337.50
337.50

37.93 0.00

37.93 375.43
375.43
3137FKZZ2 FHMS K-088 A2 3.69
01/25/2029
01/18/2024
01/25/2024
110,000.00
106,602.96

0.00 0.00
106,663.80
338.25
338.25
338.25
338.25

60.84 0.00

60.84 399.09
399.09
3137H4BY5 FHMS K-746 A2 2.031
09/25/2028
10/03/2023
10/06/2023
110,000.00
96,676.25

0.00 0.00
96,933.63
186.18
186.18
186.18
186.18
257.38

0.00 257.38
443.56
443.56
3137H5YC5 FHMS K-748 A2 2.26
01/25/2029
04/11/2024
04/16/2024
115,000.00
102,517.61

0.00 0.00
102,741.18
216.58
216.58
216.58
216.58
223.57

0.00 223.57
440.15
440.15
362554AC1 GMCAR 2021-4 A3 0.68
09/16/2026
10/13/2021
10/21/2021
11,181.68
12,306.90

0.00 (1,125.31)
11,181.60

3.49 6.97

3.17 6.65

0.01 0.00

0.01 6.66

6.66 362583AD8 GMCAR 2023-2 A3 4.47
02/16/2028
04/04/2023
04/12/2023
40,000.00
39,999.16

0.00 0.00
39,999.18

74.50 149.00

74.50 149.00

0.02 0.00

0.02 149.02
149.02
36265WAD5 GMCAR 2022-3 A3 3.64
04/16/2027
07/06/2022
07/13/2022
28,677.41
29,999.90

0.00 (1,322.59)
28,677.31

45.50 91.00

43.49 88.99

0.01 0.00

0.01 89.00

89.00

CONFIDENTIAL | 25
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
36266FAC3 GMALT 2022-2 A3 3.42
06/20/2025
05/03/2022
05/11/2022

0.00 8,078.88

0.00 (8,079.06)

0.00 8.44

23.03 0.00

14.59 0.18

0.00 0.18

14.77 14.77
36269FAD8 GMALT 2024-1 A3 5.09
03/22/2027
02/08/2024
02/15/2024
65,000.00
64,992.65

0.00 0.00
64,992.86
101.09
275.71
101.09
275.71

0.22 0.00

0.22 275.93
275.93
379929AD4 GMALT 2023-3 A3 5.38
11/20/2026
08/08/2023
08/16/2023
10,000.00
9,999.09

0.00 0.00
9,999.12

16.44 44.83

16.44 44.83

0.03 0.00

0.03 44.86

44.86 380146AC4 GMCAR 2022-1 A3 1.26
11/16/2026
01/11/2022
01/19/2022
13,395.38
14,663.35

0.00 (1,268.40)
13,395.00

7.70 15.40

7.03 14.73

0.05 0.00

0.05 14.78

14.78 437076CR1 HOME DEPOT INC 4.0
09/15/2025
09/12/2022
09/19/2022
40,000.00
39,994.72

0.00 0.00
39,995.05
337.78

0.00 471.11
133.33

0.34 0.00

0.34 133.67
133.67
437076DC3 HOME DEPOT INC 4.75
06/25/2029
06/17/2024
06/25/2024
50,000.00

0.00 49,677.50

0.00 49,678.56

0.00 0.00

39.58 39.58

1.06 0.00

1.06 40.64

40.64 438123AC5 HAROT 2023-4 A3 5.67
06/21/2028
11/01/2023
11/08/2023
35,000.00
34,994.59

0.00 0.00
34,994.70

55.13 165.38

55.13 165.38

0.11 0.00

0.11 165.49
165.49
43813GAC5 HAROT 2021-1 A3 0.27
04/21/2025
02/17/2021
02/24/2021

0.00 50.32

0.00 (50.32)

0.00 0.00

0.01 0.00

0.01 0.00

0.00 0.00

0.01 0.01
43815BAC4 HAROT 2022-1 A3 1.88
05/15/2026
02/15/2022
02/23/2022
34,055.61
37,183.56

0.00 (3,129.71)
34,054.06

31.07 58.26

28.46 55.65

0.22 0.00

0.22 55.86

55.86

CONFIDENTIAL | 26
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
43815GAC3 HAROT 2021-4 A3 0.88
01/21/2026
11/16/2021
11/24/2021
13,985.14
15,623.53

0.00 (1,639.18)
13,984.46

3.82 11.46

3.42 11.06

0.12 0.00

0.12 11.18

11.18 43815JAC7 HAROT 2023-1 A3 5.04
04/21/2027
02/16/2023
02/24/2023
25,000.00
24,996.78

0.00 0.00
24,996.87

35.00 105.00

35.00 105.00

0.09 0.00

0.09 105.09
105.09
43815PAC3 HAROT 2022-2 A3 3.73
07/20/2026
08/15/2022
08/24/2022
31,212.81
33,587.75

0.00 (2,375.85)
31,212.00

45.24 104.40

42.04 101.20

0.10 0.00

0.10 101.30
101.30
438516CJ3 HONEYWELL INTERNATIONAL
INC 4.95 02/15/2028
02/13/2023
02/15/2023
125,000.00
127,066.49

0.00 0.00
127,019.64
1,821.88

0.00 2,337.50
515.63

0.00 (46.86)
(46.86)
468.77
468.77
448973AD9 HART 2024-A A3 4.99
02/15/2029
03/11/2024
03/20/2024
45,000.00
44,990.48

0.00 0.00
44,990.65

99.80 187.12

99.80 187.12

0.17 0.00

0.17 187.29
187.29
448979AD6 HART 2023-A A3 4.58
04/15/2027
04/04/2023
04/12/2023
50,000.00
49,996.51

0.00 0.00
49,996.61
101.78
190.83
101.78
190.83

0.10 0.00

0.10 190.93
190.93
44935FAD6 HART 2021-C A3 0.74
05/15/2026
11/09/2021
11/17/2021
9,450.26
10,694.15

0.00 (1,244.51)
9,449.74

3.52 6.60

3.11 6.19

0.09 0.00

0.09 6.29

6.29 4581X0DZ8

INTER-AMERICAN
DEVELOPMENT BANK 0.5
09/23/2024
09/15/2021
09/23/2021
170,000.00
169,986.92

0.00 0.00
169,990.36
160.56

0.00 231.39

70.83 3.44

0.00 3.44

74.28 74.28
4581X0EM6

INTER-AMERICAN
DEVELOPMENT BANK 4.375
02/01/2027
12/05/2023
12/12/2023
215,000.00
214,844.65

0.00 0.00
214,849.43
3,135.42

0.00 3,919.27
783.85

4.78 0.00

4.78 788.63
788.63

CONFIDENTIAL | 27
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
459058KT9

INTERNATIONAL BANK FOR

RECONSTRUCTION AND
DEVELOPM 3.5 07/12/2028
09/07/2023
09/11/2023
140,000.00
134,676.32

0.00 0.00
134,782.65
1,891.94

0.00 2,300.28
408.33
106.33

0.00 106.33
514.67
514.67
459058KW2

INTERNATIONAL BANK FOR

RECONSTRUCTION AND
DEVELOPM 4.625 08/01/2028 115,000.00
113,762.04

0.00 0.00
113,786.45
1,772.92

0.00 2,216.15
443.23

24.40 0.00

24.40 467.63
467.63
45950KCR9 INTERNATIONAL FINANCE
CORP 1.375 10/16/2024
07/12/2021
07/14/2021
100,000.00
100,309.69

0.00 0.00
100,241.87
171.88

0.00 286.46
114.58

0.00 (67.82)
(67.82)

46.77 46.77
45950KDF4 INTERNATIONAL FINANCE
CORP 4.375 01/15/2027
11/29/2023
12/06/2023
80,000.00
79,780.06

0.00 0.00
79,786.95
1,322.22

0.00 1,613.89
291.67

6.89 0.00

6.89 298.55
298.55
46647PDM5 JPMORGAN CHASE & CO

5.546 12/15/2025
09/19/2023
09/21/2023
60,000.00
59,863.19

0.00 0.00
59,884.03
1,534.39
1,663.80
147.89
277.30

20.83 0.00

20.83 298.13
298.13
47787CAC7 JDOT 2023-C A3 5.48
05/15/2028
09/12/2023
09/19/2023
105,000.00
104,993.88

0.00 0.00
104,994.00
255.73
479.50
255.73
479.50

0.13 0.00

0.13 479.63
479.63
47787JAC2 JDOT 2022 A3 0.36
09/15/2026
03/10/2022
03/16/2022
24,987.18
26,677.20

0.00 (1,692.20)
24,985.21

27.51 51.58

25.76 49.84

0.21 0.00

0.21 50.05

50.05 47788UAC6 JDOT 2021 A3 0.36
09/15/2025
03/02/2021
03/10/2021
3,585.98
4,605.93

0.00 (1,020.16)
3,585.83

0.74 1.38

0.57 1.22

0.05 0.00

0.05 1.27

1.27 47789QAC4 JDOT 2021-B A3 0.52
03/16/2026
07/13/2021
07/21/2021
13,232.47
15,044.85

0.00 (1,812.67)
13,232.22

3.48 6.52

3.06 6.10

0.05 0.00

0.05 6.15

6.15

CONFIDENTIAL | 28
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
47800AAC4 JDOT 2022-B A3 3.74
02/16/2027
07/12/2022
07/20/2022
39,607.04
41,849.70

0.00 (2,244.62)
39,605.25

69.57 130.44

65.84 126.71

0.16 0.00

0.16 126.87
126.87
58770AAC7 MBART 2023-1 A3 4.51
11/15/2027
01/18/2023
01/25/2023
35,000.00
34,997.07

0.00 0.00
34,997.14

70.16 131.54

70.16 131.54

0.07 0.00

0.07 131.61
131.61
58933YBH7 MERCK & CO INC 4.05
05/17/2028
05/08/2023
05/17/2023
30,000.00
29,980.77

0.00 0.00
29,981.17

47.25 0.00
148.50
101.25

0.40 0.00

0.40 101.65
101.65
6174468C6 MORGAN STANLEY 4.0
07/23/2025
03/15/2024
03/19/2024
140,000.00
138,003.67

0.00 0.00
138,147.29
1,991.11

0.00 2,457.78
466.67
143.62

0.00 143.62
610.29
610.29
61747YET8 MORGAN STANLEY 4.679
07/17/2026
07/18/2022
07/20/2022
60,000.00
60,000.00

0.00 0.00
60,000.00
1,044.98

0.00 1,278.93
233.95

0.00 0.00

0.00 233.95
233.95
63743HFE7

NATIONAL RURAL UTILITIES

COOPERATIVE FINANCE CORP

3.45 06/15/2025
04/27/2022
05/04/2022
35,000.00
34,997.69

0.00 0.00
34,997.87
556.79
603.75

53.67 100.63

0.18 0.00

0.18 100.81
100.81
665859AW4
NORTHERN TRUST CORP 4.0
05/10/2027
09/28/2022
09/30/2022
150,000.00
147,065.03

0.00 0.00
147,147.09
350.00

0.00 850.00
500.00

82.06 0.00

82.06 582.06
582.06
69371RR40 PACCAR FINANCIAL CORP 0.5
08/09/2024
08/03/2021
08/09/2021
50,000.00
49,998.30

0.00 0.00
49,999.04

77.78 0.00

98.61 20.83

0.74 0.00

0.74 21.57

21.57 69371RR57 PACCAR FINANCIAL CORP 0.9
11/08/2024
11/02/2021
11/08/2021
90,000.00
89,999.56

0.00 0.00
89,999.64

51.75 0.00
119.25

67.50 0.08

0.00 0.08

67.58 67.58

CONFIDENTIAL | 29
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
69371RS56 PACCAR FINANCIAL CORP

5.05 08/10/2026
12/08/2023
12/13/2023
80,000.00
80,141.71

0.00 0.00
80,136.40
1,245.67

0.00 1,582.33
336.67

0.00 (5.31)
(5.31)
331.35
331.35
78015K7C2 ROYAL BANK OF CANADA

2.25 11/01/2024
09/22/2020
09/24/2020
135,000.00
135,866.30

0.00 0.00
135,696.44
253.13

0.00 506.25
253.13

0.00 (169.86)
(169.86)

83.26 83.26
78016HZT0 ROYAL BANK OF CANADA

4.875 01/19/2027
01/10/2024
01/19/2024
105,000.00
104,976.96

0.00 0.00
104,977.68
1,876.88

0.00 2,303.44
426.56

0.72 0.00

0.72 427.28
427.28
79466LAG9 SALESFORCE INC 0.625
07/15/2024
06/29/2021
07/12/2021
20,000.00
19,999.59

0.00 0.00
19,999.87

47.22 0.00

57.64 10.42

0.28 0.00

0.28 10.70

10.70 857477BR3 STATE STREET CORP 1.746
02/06/2026
02/02/2022
02/07/2022
35,000.00
35,000.00

0.00 0.00
35,000.00
195.21

0.00 246.14

50.93 0.00

0.00 0.00

50.93 50.93
857477CL5 STATE STREET CORP 4.993
03/18/2027
03/13/2024
03/18/2024
125,000.00
125,000.00

0.00 0.00
125,000.00
1,265.59

0.00 1,785.69
520.10

0.00 0.00

0.00 520.10
520.10
89115A2V3 TORONTO-DOMINION BANK

5.264 12/11/2026
12/04/2023
12/11/2023
55,000.00
55,000.00

0.00 0.00
55,000.00
1,367.18
1,447.60
160.84
241.27

0.00 0.00

0.00 241.27
241.27
89236TKN4 TOYOTA MOTOR CREDIT
CORP 4.8 01/10/2025
01/10/2023
01/12/2023
130,000.00
129,972.56

0.00 0.00
129,976.25
2,444.00

0.00 2,964.00
520.00

3.69 0.00

3.69 523.69
523.69
89238DAD0 TAOT 2024-A A3 4.83
10/16/2028
01/23/2024
01/30/2024
60,000.00
59,988.85

0.00 0.00
59,989.06
128.80
241.50
128.80
241.50

0.21 0.00

0.21 241.71
241.71

CONFIDENTIAL | 30
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
89239FAD4 TAOT 2023-D A3 5.54
08/15/2028
11/07/2023
11/14/2023
45,000.00
44,995.71

0.00 0.00
44,995.79
110.80
207.75
110.80
207.75

0.08 0.00

0.08 207.83
207.83
89240BAC2 TAOT 2021-A A3 0.26
05/15/2025
02/02/2021
02/08/2021

0.00 602.56

0.00 (602.57)

0.00 0.07

0.13 0.00

0.06 0.02

0.00 0.02

0.08 0.08
91159HHX1 US BANCORP 2.4 07/30/2024
03/25/2021
03/29/2021
150,000.00
150,191.65

0.00 0.00
150,000.00
1,210.00

0.00 1,510.00
300.00

0.00 (191.65)
(191.65)
108.35
108.35
912796ZV4 UNITED STATES TREASURY
12/26/2024
05/29/2024
05/30/2024
250,000.00
242,660.41

0.00 0.00
243,719.01

0.00 0.00

0.00 0.00
1,058.59

0.00 1,058.59
1,058.59
1,058.59
912797GB7 UNITED STATES TREASURY
07/11/2024
02/26/2024
02/27/2024
80,000.00
79,542.22

0.00 0.00
79,885.56

0.00 0.00

0.00 0.00
343.33

0.00 343.33
343.33
343.33
912797GL5 UNITED STATES TREASURY
09/05/2024
03/27/2024
03/28/2024
150,000.00
147,957.00

0.00 0.00
148,595.44

0.00 0.00

0.00 0.00
638.44

0.00 638.44
638.44
638.44
912797KU0 UNITED STATES TREASURY
10/17/2024
04/18/2024
04/19/2024
200,000.00
196,042.08

0.00 0.00
196,902.50

0.00 0.00

0.00 0.00
860.42

0.00 860.42
860.42
860.42
9128286L9 UNITED STATES TREASURY

2.25 03/31/2026 275,000.00
271,016.34

0.00 0.00
271,195.24
1,048.16

0.00 1,555.33
507.17
214.03
(35.13)
178.91
686.08
686.08
912828J27 UNITED STATES TREASURY 2.0
02/15/2025
06/25/2024
06/26/2024
250,000.00

0.00 244,902.34

0.00 245,011.26

0.00 (1,813.19)
1,881.87

68.68 108.92

0.00 108.92
177.60
177.60

CONFIDENTIAL | 31
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
912828R36 UNITED STATES TREASURY

1.625 05/15/2026 265,000.00
259,746.38

0.00 0.00
259,967.43
198.93

0.00 549.98
351.05
282.58
(61.53)
221.05
572.10
572.10
912828U24 UNITED STATES TREASURY 2.0
11/15/2026
03/29/2022
03/30/2022
265,000.00
261,606.53

0.00 0.00
261,720.03
244.84

0.00 676.90
432.07
113.49

0.00 113.49
545.56
545.56
912828X88 UNITED STATES TREASURY

2.375 05/15/2027 275,000.00
270,541.19

0.00 0.00
270,665.27
301.72

0.00 834.15
532.44
124.09

0.00 124.09
656.52
656.52
912828YG9 UNITED STATES TREASURY

1.625 09/30/2026
12/28/2021
12/29/2021
200,000.00
201,731.05

0.00 0.00
201,670.02
550.55

0.00 816.94
266.39

0.00 (61.02)
(61.02)
205.37
205.37
912828ZF0 UNITED STATES TREASURY 0.5
03/31/2025
03/25/2021
03/29/2021
125,000.00
124,919.10

0.00 0.00
124,927.11
105.87

0.00 157.10

51.23 8.01

0.00 8.01

59.24 59.24
912828ZT0 UNITED STATES TREASURY

0.25 05/31/2025
02/25/2021
02/26/2021
250,000.00
249,142.76

0.00 0.00
249,213.41

1.71 0.00

52.94 51.23

70.65 0.00

70.65 121.88
121.88
91282CAZ4 UNITED STATES TREASURY

0.375 11/30/2025
12/09/2020
12/10/2020
175,000.00
174,909.40

0.00 0.00
174,914.37

1.79 0.00

55.58 53.79

4.97 0.00

4.97 58.76

58.76 91282CCG4 UNITED STATES TREASURY

0.25 06/15/2024
06/17/2021
06/18/2021

0.00 249,983.11

0.00 (250,000.00)

0.00 288.59
312.50

0.00 23.91

16.89 0.00

16.89 40.79

40.79 91282CCT6 UNITED STATES TREASURY

0.375 08/15/2024
08/25/2021
08/26/2021
250,000.00
249,961.52

0.00 0.00
249,976.91
275.58

0.00 352.85

77.27 15.39

0.00 15.39

92.66 92.66

CONFIDENTIAL | 32
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
91282CDH1 UNITED STATES TREASURY

0.75 11/15/2024
11/18/2021
11/19/2021
225,000.00
224,913.98

0.00 0.00
224,929.43

77.96 0.00
215.52
137.57

15.45 0.00

15.45 153.02
153.02
91282CEF4 UNITED STATES TREASURY 2.5
03/31/2027
05/25/2022
05/26/2022
200,000.00
198,768.94

0.00 0.00
198,804.69
846.99

0.00 1,256.83
409.84

35.75 0.00

35.75 445.59
445.59
91282CEY3 UNITED STATES TREASURY 3.0
07/15/2025
06/23/2023
06/26/2023
260,000.00
255,319.93

0.00 0.00
255,663.21
2,957.14

0.00 3,600.00
642.86
343.28

0.00 343.28
986.14
986.14
91282CFM8 UNITED STATES TREASURY

4.125 09/30/2027
10/26/2022
10/27/2022
260,000.00
259,512.59

0.00 0.00
259,524.62
1,816.80

0.00 2,695.90
879.10

12.02 0.00

12.02 891.12
891.12
91282CGC9 UNITED STATES TREASURY

3.875 12/31/2027
05/25/2023
05/26/2023
100,000.00
99,671.54

0.00 0.00
99,679.08
1,628.78

0.00 10.53
(1,618.25)

7.53 0.00

7.53 (1,610.71)
(1,610.71)
91282CGT2 UNITED STATES TREASURY

3.625 03/31/2028
04/19/2023
04/20/2023
240,000.00
239,092.72

0.00 0.00
239,112.18
1,473.77

0.00 2,186.89
713.11

19.46 0.00

19.46 732.57
732.57
931142ER0 WALMART INC 1.05
09/17/2026
09/08/2021
09/17/2021
25,000.00
24,978.31

0.00 0.00
24,979.09

53.96 0.00

75.83 21.88

0.78 0.00

0.78 22.65

22.65 931142EW9 WALMART INC 3.9
09/09/2025
09/06/2022
09/09/2022
30,000.00
29,992.49

0.00 0.00
29,992.98
266.50

0.00 364.00

97.50 0.48

0.00 0.48

97.98 97.98
Total Fixed Income 11,221,582.97
11,122,196.60
520,785.84
(529,276.37)
11,119,563.19
63,448.73
16,798.74
71,093.94
24,443.95
6,831.69
(974.56)
5,857.13
30,301.08 30,301.08

CONFIDENTIAL | 33
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

INCOME EARNED
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
TOTAL PORTFOLIO 11,305,874.83
11,179,352.70
1,068,795.35
(1,052,068.17)
11,203,855.05
63,448.73
17,818.78
71,093.94
25,463.99
6,831.69
(974.56)
5,857.13
31,321.12 31,321.12

CONFIDENTIAL | 34
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount JULY 2024
07/01/2024 Dividend 31846V203 0.00 1,000.59 1,000.59
07/01/2024 Coupon 91282CGC9 0.00 UNITED STATES TREASURY 3.875 12/31/2027 1,937.50 1,937.50 07/08/2024 Coupon 3133ENKS8 80,000.00 FEDERAL FARM CREDIT BANKS FUNDING CORP

1.125 01/06/2025 450.00 450.00
07/10/2024 Coupon 89236TKN4 130,000.00 TOYOTA MOTOR CREDIT CORP 4.8 01/10/2025 3,120.00 3,120.00 07/11/2024 Final Maturity 912797GB7 80,000.00 UNITED STATES TREASURY 07/11/2024 80,000.00 80,000.00 07/12/2024 Coupon 459058KT9 140,000.00 INTERNATIONAL BANK FOR RECONSTRUCTION AND DEVELOPM 3.5 07/12/2028 2,450.00 2,450.00
07/15/2024 Coupon 02582JKD1 115,000.00 AMXCA 2023-3 A 5.23 09/15/2028 501.21 501.21 07/15/2024 Coupon 02582JKH2 100,000.00 AMXCA 2024-1 A 5.23 04/16/2029 435.83 435.83 07/15/2024 Coupon 02665WEA5 140,000.00 AMERICAN HONDA FINANCE CORP 1.5 01/13/2025 1,050.00 1,050.00
07/15/2024 Coupon 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 53.35 53.35 07/15/2024 Principal Paydown 43815BAC4 34,055.61 HAROT 2022-1 A3 1.88 05/15/2026 2,996.89 2,996.89 07/15/2024 Coupon 448973AD9 45,000.00 HART 2024-A A3 4.99 02/15/2029 187.13 187.13 07/15/2024 Coupon 448979AD6 50,000.00 HART 2023-A A3 4.58 04/15/2027 190.83 190.83 07/15/2024 Coupon 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 5.83 5.83 07/15/2024 Principal Paydown 44935FAD6 9,450.26 HART 2021-C A3 0.74 05/15/2026 1,177.21 1,177.21 07/15/2024 Coupon 45950KDF4 80,000.00 INTERNATIONAL FINANCE CORP 4.375 01/15/2027 1,750.00 1,750.00
07/15/2024 Coupon 47787CAC7 105,000.00 JDOT 2023-C A3 5.48 05/15/2028 479.50 479.50 07/15/2024 Coupon 47787JAC2
24,987.18 JDOT 2022 A3 0.36 09/15/2026 48.03 48.03
07/15/2024 Principal Paydown 47787JAC2 24,987.18 JDOT 2022 A3 0.36 09/15/2026 2,178.86 2,178.86 07/15/2024 Coupon 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 1.08 1.08 07/15/2024 Principal Paydown 47788UAC6 3,585.98 JDOT 2021 A3 0.36 09/15/2025 980.13 980.13 07/15/2024 Coupon 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 5.73 5.73 07/15/2024 Principal Paydown 47789QAC4 13,232.47 JDOT 2021-B A3 0.52 03/16/2026 1,096.68 1,096.68 07/15/2024 Coupon 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 123.44 123.44 07/15/2024 Principal Paydown 47800AAC4 39,607.04 JDOT 2022-B A3 3.74 02/16/2027 2,008.51 2,008.51 07/15/2024 Coupon 58770AAC7 35,000.00 MBART 2023-1 A3 4.51 11/15/2027 131.54 131.54 07/15/2024 Coupon 79466LAG9 20,000.00 SALESFORCE INC 0.625 07/15/2024 62.50 62.50

CONFIDENTIAL | 35
City of Bell | Account # | As of June 30, 2024
Execution Time: 07/05/2024 07:52:37 AM Chandler Asset Management | [email protected] | www.chandlerasset.com | 800.317.4747

CASH FLOW REPORT
Payment Date Transaction Type CUSIP Quantity Security Description Principal Amount Income Total Amount 07/15/2024 Final Maturity 79466LAG9 20,000.00 SALESFORCE INC 0.625 07/15/2024 20,000.00 20,000.00 07/15/2024 Coupon 89238DAD0 60,000.00 TAOT 2024-A A3 4.83 10/16/2028 241.50 241.50 07/15/2024 Coupon 89239FAD4 45,000.00 TAOT 2023-D A3 5.54 08/15/2028 207.75 207.75 07/15/2024 Coupon 91282CEY3 260,000.00 UNITED STATES TREASURY 3.0 07/15/2025 3,900.00 3,900.00 07/16/2024 Coupon 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 6.40 6.40 07/16/2024 Principal Paydown 362554AC1 11,181.68 GMCAR 2021-4 A3 0.68 09/16/2026 988.12 988.12 07/16/2024 Coupon 362583AD8 40,000.00 GMCAR 2023-2 A3 4.47 02/16/2028 149.00 149.00 07/16/2024 Coupon 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 86.39 86.39 07/16/2024 Principal Paydown 36265WAD5 28,677.41 GMCAR 2022-3 A3 3.64 04/16/2027 2,015.20 2,015.20 07/16/2024 Coupon 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 14.05 14.05 07/16/2024 Principal Paydown 380146AC4 13,395.38 GMCAR 2022-1 A3 1.26 11/16/2026 1,152.50 1,152.50 07/17/2024 Coupon 61747YET8 60,000.00 MORGAN STANLEY 4.679 07/17/2026 1,403.70 1,403.70 07/18/2024 Coupon 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 96.80 96.80 07/18/2024 Principal Paydown 43815PAC3 31,212.81 HAROT 2022-2 A3 3.73 07/20/2026 2,307.65 2,307.65 07/19/2024 Coupon 78016HZT0 105,000.00 ROYAL BANK OF CANADA 4.875 01/19/2027 2,559.38 2,559.38 07/22/2024 Coupon 06051GLE7 135,000.00 BANK OF AMERICA CORP 5.08 01/20/2027 3,429.00 3,429.00 07/22/2024 Coupon 36269FAD8 65,000.00 GMALT 2024-1 A3 5.09 03/22/2027 275.71 275.71 07/22/2024 Coupon 379929AD4 10,000.00 GMALT 2023-3 A3 5.38 11/20/2026 44.83 44.83 07/22/2024 Coupon 438123AC5 35,000.00 HAROT 2023-4 A3 5.67 06/21/2028 165.38 165.38 07/22/2024 Coupon 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 10.26 10.26 07/22/2024 Principal Paydown 43815GAC3 13,985.14 HAROT 2021-4 A3 0.88 01/21/2026 1,477.32 1,477.32 07/22/2024 Coupon 43815JAC7 25,000.00 HAROT 2023-1 A3 5.04 04/21/2027 105.00 105.00 07/23/2024 Coupon 6174468C6 140,000.00 MORGAN STANLEY 4.0 07/23/2025 2,800.00 2,800.00 07/25/2024 Coupon 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 56.81 56.81 07/25/2024 Principal Paydown 05593AAC3 13,212.02 BMWLT 2023-1 A3 5.16 11/25/2025 2,246.88 2,246.88 07/25/2024 Coupon 3137BNGT5 175,000.00 FHMS K-054 A2 2.745 01/25/2026 400.31 400.31 07/25/2024 Coupon 3137BVZ82 110,000.00 FHMS K-063 A2 3.43 01/25/2027 314.42 314.42 07/25/2024 Coupon 3137FETN0 160,000.00 FHMS K-073 A2 3.35 01/25/2028 446.67 446.67 07/25/2024 Coupon 3137FHPJ6 110,000.00 FHMS K-080 A2 3.926 07/25/2028 359.88 359.88 07/25/2024 Coupon 3137FJEH8 105,000.00 FHMS K-081 A2 3.9 08/25/2028 341.25 341.25 07/25/2024 Coupon 3137FJXV6 100,000.00 FHMS K-083 A2 4.05 09/25/2028 337.50 337.50 07/25/2024 Coupon 3137FKZZ2 110,000.00 FHMS K-088 A2 3.69 01/25/2029 338.25 338.25