Cities Index.
Agenda, first session

Indian Wells City Council
February 17, 2022

Document
Agenda, first session
Meeting
February 17, 2022
Body
Indian Wells City Council
Pages
28
Original file
416 KB
Text extracted from the city's file for reading and search. Open the original on portal.laserfiche.com. That file is the official record.

City of Indian Wells
2/17/2022
44-950 Eldorado Drive,
Indian Wells
File #:035-22 Item #:P.

January 6, 2022, City Council Meeting Minutes
RECOMMENDED ACTION:

Council APPROVES the January 6, 2022, City Council Meeting Minutes.

City of Indian Wells Printed on 2/11/2022Page 1 of 1
powered by Legistar™149

Un
o
f
f
i
c
i
a
l
City Council
Meeting Minutes
Thursday, January 6, 2022
1:30 PM
Welcome to a meeting of the Indian Wells City Council. All documents for public review are available for public inspection at City Hall reception, 44-950 Eldorado Drive, Indian Wells during normal business hours.

Members of the Public who wish to speak during public comment or on a particular item should fill out a blue slip and submit it to the City Clerk. Comments will be limited to 3 minutes. Speaker will be alerted when their time is up. Speakers are then to return to their seats and no further comments will be permitted.

In accordance with State Law, remarks during public comment are to be limited to subjects within the City's jurisdiction. Remarks on other agenda items will be limited to those items. Remarks from those seated or standing in the back of the chambers will not be permitted. All those wishing to speak including City and Staff need to be recognized by the Mayor before speaking. Please turn off all communication devices (phones) or put them on non-audible mode (vibrate) so as not to cause a disruption in the Council proceedings.

VIA VIDEOCONFERENCE
150

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes

1.CONVENE THE CITY COUNCIL AND FINANCE AUTHORITY JOINT

MEETING, PLEDGE OF ALLEGIANCE AND ROLL CALL
Mayor Reed convened the City Council/Finance Authority Joint Meeting of the City of Indian Wells at 1:30 p.m. on January 6, 2022 via zoom/teleconference.

Mayor Reed, Mayor Pro Tem Griffith, Council Member Sanders, Council Member Muzik, Council Member Balocco

Present: 5 -

2. APPROVAL OF THE FINAL AGENDA
City Manager Christopher Freeland requested Consent Item #7D - Update on Efforts to Improve Maintenance and Landscape Along Right-of-Way of Highway 111 at Miles Avenue be pulled for a further update to be provided by staff. Mr. Freeland recommended General Business Item #9C - Introduction of Proposed Ordinance relating to Recreational Vehicle (RV) Parking be pulled for further discussion and recommended the creation of a two Council Member Ad-Hoc Committee to assist staff and the City Attorney in drafting revisions to the Municipal Code relating to RV parking.

A motion was made by Mayor Pro Tem Griffith, seconded by Mayor Reed to Approve the Agenda as Amended. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES: 0

3. PROCLAMATIONS AND PRESENTATIONS
A.Indian Wells Golf Resort Update by General Manager Sven Wiedenhaupt
Indian Wells General Manager Sven Wiedenhaupt gave an overview of the Golf Resort accomplishments and challenges over the last six months. Mr. Wiedenhaupt thanked the Council and staff for their support. Finance Director Kevin McCarthy provided a detailed Golf Resort financial performance update.

B.Coachella Valley Public Cemetery District Presentation by Trustee Dr. Bruce Underwood and General Manager Josh
Bonner
Coachella Valley Public Cemetery District Trustee Dr. Bruce Underwood and General Manager Josh Bonner provided an overview of the services available at the Cemetery District.

C.Senate Bill 1383 Update by Burrtec Waste Management Vice President Frank Orlett
Burrtec Waste Management Vice President Frank Orlett and Municipal Marketing Manager Clara Vera gave a detailed overview of Senate Bill 1383 organic waste recycling requirements, implementation, and time line for compliance.

4. PUBLIC COMMENTS
Mr. Patrick Overturf, resident, submitted a written public comment, expressing concerns relating to vehicles speeding on Highway 111 and the lack of police enforcement.

Page 1 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes

5.CITY MANAGER'S REPORTS
City Manager Christopher Freeland gave an overview of the various projects in the City and the Indian Wells Golf Resort. Mr. Freeland reported a new City project webpage is being launched on the City's website where regular updates and status of projects will be made available to the community. He further reported the City Council Annual Strategic Planning Session is scheduled to be held on Wednesday, January 26, 2022 at 9:00 a.m. in person subject to change depending on the increase in COVID-19 variant cases. He stated the Council Strategic discussion would not include the Indian Wells Golf Resort matters, as the City intends to have a separate meeting once the Golf Master Plan has been completed. He further thanked the residents for participating in the Golf Master Plan community meetings. He congratulated Code Enforcement Officer/Building Inspector Wes Remaklus for obtaining his Master Code Professional certification.

6. CITY ATTORNEY REPORTS AND COMMENTS
City Attorney Todd Leishman reported a Special Council closed session was held today at 1:00 p.m. to discuss items listed on the posted agenda, no reportable action was taken which, under the Brown Act, would be required to be publicly reported.

7. CITY COUNCIL CONSENT CALENDAR
A.Findings to Hold Remote Teleconference/Virtual Meetings and Hybrid (i.e., In-Person and Teleconference/Virtual) Meetings for All City Legislative Bodies, in Accordance with Assembly Bill 361 It was determined to APPROVE remote teleconference/virtual and hybrid meetings for all City legislative bodies by finding that a statewide state of emergency is currently in place and that state and local officials have imposed or recommended measures to promote social distancing in connection with COVID-19; and
AUTHORIZE City Manager to implement teleconference/virtual or hybrid public meetings as needed in accordance with Assembly Bill 361.

This Recommendation was Approved.

B.Cooperative Agreement for Operation and Maintenance of Traffic Signal and Safety Lighting
It was determined to APPROVE a cooperative agreement with the City of La Quinta for the Operation and Maintenance of a Traffic Signal and Safety Lighting; and AUTHORIZE and DIRECT the City Manager or designee to execute the agreement.

This Recommendation was Approved.

Page 2 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes
C.Authorization to Apply for the Tree City USA Program
It was determined to AUTHORIZE and DIRECT the City Manager or designee to complete and submit an application for the Arbor Day Foundation Tree City USA Program; and INSTRUCT the City Attorney’s Office to develop a Municipal Tree Ordinance that meets the needs of the City and satisfies the Tree City USA requirements.

This Recommendation was Approved.

E.Supplemental Appropriation for Pavilion Glass Door
Replacement at the Indian Wells Golf Resort
It was determined to APPROVE supplemental appropriation of $86,934 for Pavilion Door Replacement at the Indian Wells Golf Resort.

This Recommendation was Approved.

F.Supplemental Appropriation for Code Enforcement Legal Services for Fiscal Year 2021-22
It was determined to APPROVE supplemental appropriation of $75,000 for legal services relating to short-term residential rental code enforcement activities.

This Recommendation was Approved.

G.December 16, 2021, City Council Joint Meeting Minutes It was determined to APPROVE the December 16, 2021, City Council Joint Meeting Minutes.

The Minutes were Approved.

Approval of the Consent Agenda
A motion was made by Council Member Sanders, seconded by Council Member Balocco, that this be Approved the Consent Agenda. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES: 0

Page 3 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes
D.Update on Efforts to Improve Maintenance & Landscaping Along Right-of-Way of Highway 111 at Miles Avenue
Mr. Larry Bonafide, resident, spoke in support for landscape improvements along right-of-way of Highway 111 at Mile Ave.

City Manager Christopher Freeland gave an overview of staff efforts on landscape improvements along right-of-way of Highway 111 at Miles Ave. There were concerns expressed over the increase of complaints due to stockpiled soil and the lack of landscaping efforts from the two lot owners for properties located on Highway 111 and Miles Avenue.

It was determined to APPROVE and AUTHORIZE funding not to exceed $130,000 for landscape improvements along the Right-of-Way of Highway 111 at Miles Avenue.

A motion was made by Council Member Sanders, seconded by Council Member Muzik, that this Recommendation be Approved. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES:0

8. CITY COUNCIL PUBLIC HEARINGS
A.Approval of documents relating to the Not to Exceed $15.5 Million issuance of Indian Wells Financing Authority Lease Revenue Bonds (Solar and Infrastructure Projects), Series 2022 to provide funding for the Renewable Energy Generation
Program and other City capital improvements.

Mayor Reed opened the public hearing at 3:22 p.m. to hear testimony in favor of or against Resolution No. 2022-01 hearing none, Mayor Reed closed the public hearing.

It was determined to ADOPT Resolution No. 2022-01 to read as follows:

RESOLUTION NO. 2022-01

A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF INDIAN WELLS AUTHORIZING THE

EXECUTION AND DELIVERY BY THE CITY OF A GROUND LEASE, A LEASE AGREEMENT, AN

INDENTURE, A BOND PURCHASE AGREEMENT AND A CONTINUING DISCLOSURE CERTIFICATE IN

CONNECTION WITH THE ISSUANCE OF INDIAN WELLS FINANCING AUTHORITY LEASE REVENUE BONDS (SOLAR AND INFRASTRUCTURE PROJECTS), SERIES 2022, APPROVING THE ISSUANCE OF SUCH BONDS IN AN AGGREGATE PRINCIPAL AMOUNT OF NOT TO EXCEED $15,500,000,

AUTHORIZING THE DISTRIBUTION OF AN OFFICIAL STATEMENT IN CONNECTION WITH THE

OFFERING AND SALE OF SUCH BONDS AND AUTHORIZING THE EXECUTION OF NECESSARY

DOCUMENTS AND CERTIFICATES AND RELATED ACTIONS
A motion was made by Council Member Sanders, seconded by Council Member Muzik, that this Resolution be Adopted. The motion carried by the following vote:

Page 4 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes
AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES:0

9. CITY COUNCIL GENERAL BUSINESS
A.Annual Review of FPPC Gift Restrictions, City Ticket Distribution Policy, and City Campaign Contribution Reporting Requirement City Attorney Todd Leishman suggested to revise the current Council ticket policy in light of recent changes in State legislation that requires the City to avoid the disproportion use of tickets.

It was the CONSENSUS of the City Council to RECEIVE and FILE this informational report.

This Recommendation was Received and Filed.

B.Proposed Ordinance Amending Section 1.20.150 and Chapter

5.20 of the Indian Wells Municipal Code and Finding the Action to Be Exempt from CEQA
Mr. John Nelson, submitted a written comment relating the proposed Short-Term rental ordinance.

City Clerk Angelica Avila stated Mr. Nelson requested to speak relating to this matter, however Mr.

Nelson was not present at today's meeting.

It was determined to INTRODUCE to read by title only, discuss, and further reading waved, amending Section 1.20.150 and Chapter 5.20 of the Indian Wells Municipal Code; and FIND the action to be exempt from CEQA.

A motion was made by Mayor Reed, seconded by Council Member Sanders, that this Ordinance be Introduced For First Reading. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES:0

Page 5 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes
C.Proposed Ordinance Adding Section 11.36.125 and Amending Various Sections of the Municipal Code for Purposes of
Clarifying Restrictions on the Parking and Storage of
Recreational Vehicles Within the City
Ms. Rocky Randall, resident, spoke in support of increasing the time allowed for Recreation Vehicle parking.

It was determined to AUTHORIZE the formation of a Recreation Vehicle Ad Hoc Committee compromised of Council Member Sanders and Council Member Muzik to review and make recommendations to the Council at a future meeting.

A motion was made by Council Member Balocco, seconded by Mayor Pro Tem Griffith, that this Recommendation be Approved As Amended. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES: 0
D.Proposed Ordinance Amending Indian Wells Municipal Code Adopting Mandatory Organic Waste Disposal Reduction
Requirements Under Senate Bill (SB) 1383
It was determined to INTRODUCE to read by title only and further reading waved, amending various sections of the Municipal Code for purposes of code maintenance and clarifying the intent of existing regulation of recreational vehicle parking and storage requirements; and FIND the action to be exempt from CEQA.

A motion was made by Council Member Sanders, seconded by Mayor Pro Tem Griffith, that this Ordinance be Introduced For First Reading. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES: 0

10. FINANCE AUTHORITY GENERAL BUSINESS

Page 6 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes
A.Approval of documents relating to the Not to Exceed $15.5 Million issuance of Indian Wells Financing Authority Lease Revenue Bonds (Solar and Infrastructure Projects), Series 2022 to provide funding for the Renewable Energy Generation
Program and other City capital improvements.

It was determined to ADOPT Resolution FA No. 2022-01 to read as follows:

RESOLUTION fa NO. 2022-01

A RESOLUTION OF THE BOARD OF DIRECTORS OF THE INDIAN WELLS FINANCING AUTHORITY

AUTHORIZING THE EXECUTION AND DELIVERY OF A GROUND LEASE, A LEASE AGREEMENT, AN

INDENTURE, AND A BOND PURCHASE AGREEMENT IN CONNECTION WITH THE ISSUANCE OF

INDIAN WELLS FINANCING AUTHORITY LEASE REVENUE BONDS (SOLAR AND INFRASTRUCTURE PROJECTS), SERIES 2022, AUTHORIZING THE ISSUANCE OF SUCH BONDS IN AN AGGREGATE PRINCIPAL AMOUNT OF NOT TO EXCEED $15,500,000, AUTHORIZING THE DISTRIBUTION OF AN

OFFICIAL STATEMENT IN CONNECTION THEREWITH AND AUTHORIZING THE EXECUTION OF NECESSARY DOCUMENTS AND CERTIFICATES AND RELATED ACTIONS.

A motion was made by Council Member Sanders, seconded by Council Member Muzik, that this Resolution be Adopted. The motion carried by the following vote:

AYES:Reed, Griffith, Sanders, Muzik, Balocco5 -
NOES:0

11. COUNCIL MEMBERS' REPORTS AND COMMENTS
A. Council Member Balocco
No report.

B. Council Member Muzik
No report.

C. Council Member Sanders
No report.

D. Mayor Pro Tem Griffith
No report.

E. Mayor Reed
No report.

Page 7 ends

Un
o
f
f
i
c
i
a
l
January 6, 2022City Council Meeting Minutes

12.ADJOURNMENT
At 3:48 p.m., Mayor Reed ADJOURNED the City Council meeting to a regularly scheduled meeting of the City Council to be held at 1:30 p.m. on February 17, 2022 in the City Hall Council Chamber.

Respectfully Submitted,
_____________________________
Angelica Avila, CMC
City Clerk
This council meeting may be viewed on the City's website at http://www.cityofindianwells.org/cityhall/citycouncil/viewmeetings.asp and the complete agenda packets are available on the City's website at http://www.cityofindianwells.org/cityhall/cagaends.asp

Page 8 ends

City of Indian Wells
2/17/2022
44-950 Eldorado Drive,
Indian Wells
File #:031-22 Item #:Q.

Indian Wells City Council
Staff Report - Finance February 17, 2022 City Treasurer’s Report for October 2021
RECOMMENDED ACTIONS:

Council RECEIVES and FILES the City Treasurer’s Report for October 2021.

DISCUSSION:

Attached are the monthly cash balance and investment reports for the month of October 2021.

Investments reflected in this report are “Marked-to-Market”, meaning the market value of City’s investments is updated monthly. This method provides a clear depiction of the value of the City’s portfolio subject to the performance of the investment market. The City of Indian Wells continues to maintain prudent fiscal reserves and minimize un-invested cash.

Cash and Investments
As of October 31, 2021:
·The City’s cash and investments totaled $65,119,137.66. ·The City’s portfolio earned a 1.170% rate of return.

Treasurer’s Certification
Compliance - The City Treasurer certifies the City’s cash and investments presented in this Report are in compliance with the City’s investment policy and with legal requirements of State of California Government Code section 53600.

Liquidity - The City Treasurer certifies the City’s portfolio is sufficient to meet its financial obligations for the next six months. The investment portfolio will remain sufficiently liquid to meet all operating requirements, which might be reasonably anticipated. This is accomplished by striving to have securities mature at the same time cash is needed to meet anticipated demands (static liquidity). Additionally, since all possible cash demands cannot be anticipated, the portfolio consists largely of securities with active secondary or resale markets (dynamic liquidity).

Fiscal Prudence
When investing, reinvesting, purchasing, acquiring, exchanging, selling, or managing public funds, a trustee shall act with care, skill, prudence, and diligence under the circumstances then prevailing, including, but not limited to, the general economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity City of Indian Wells Printed on 2/11/2022Page 1 of 2
powered by Legistar™159

File #:031-22 Item #:Q.
economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity with those matters would use in the conduct of funds of a like character and with like aims, to safeguard the principal and maintain the liquidity needs of the City.

Background
Staff provides Council with a monthly update to the Treasurer’s Report. The Report presents the City’s cash activity and investment portfolio and provides reconciliation between investment balances and the General Ledger. Specifically, the report provides information on the types of investments, dates of maturities, costs, updated market value of securities, and rates of interest earned in the portfolio.

The City maintains a written investment policy in compliance with legal requirements of Government Code section 53600 and governs the investments made by the City. It is the policy of the City of Indian Wells to invest public funds in a manner that will provide the maximum security with the highest investment return while meeting the daily cash flow demands of the City. The investments purchased by the City are consistent with the City’s investment policy and are allowable under current legislation of the State of California.

The City invests in U.S. treasuries, federal agency securities, medium term corporate notes, municipal bonds, federally insured certificates of deposit, and overnight cash investments. Criteria for selecting investments in order of priority are:
(1) safety, (2) liquidity and (3) yield.

ATTACHMENT:

1. City Treasurer’s Report
City of Indian Wells Printed on 2/11/2022Page 2 of 2
powered by Legistar™160

NET CASH & INVESTMENT SUMMARY OCTOBER 2O2T
October
202L
October
2020UNRESTRICTED FUNDS

GENERAL FUND
101- GENERAL

TOTAL GENERAL FUND

RESTRICTED FUNDS

SPECIAL REVENUE FUNDS
202 - TRAFFIC SAFETY
203 - PUBLTC SAFETY 1/2 CENT SALES TAX
204 - MEASURE UAU
209 - F.A.M.D. #1
210 - SCAQMD (VEHTCLE REG.)
211 - AB 3229 COPS FUNDING
214 - GAS TAX 2103 MAINTENANCE
215 - GAS TAX 2105 MAINTENANCE
216 - GAS TAX 2106 CONSTRUCT/MAINT
217 - GAS TAX 2107 MAINTENANCE
218 - GAS TAX 2107.5 ENG./ADMIN
219 - GAS TAX RMRA
228 - EMERG. UPGRADE SERVICES
247 - AB 939 RECYCLING FUND
248 - SOLID WASTE
251 - STREET LIGHTING DISTRICT 2OOO-1
253- INDIAN WELLS VILI.AS OPERANONS
254- MOUNTAIN VIEW VILI.AS OPERATIONS
256- HOUSING AUTHORITY
271 . ELDOMDO DRIVE LLMD
272 - MONTECITO/STARDUST LLMD
273 - CASA DORADO LLMD
274 -THE COVE LLMD
27s - SH 111/rWGR (ENTMNCE) LLMD
276 - CLUBIIW LANE LLMD
277 - COLONY LLMD
278 - COLONY COV ESTATES LLMD
279 . DESERT HORIZONS LLMD
2BO - MOUNTAIN GATE LLMD
281 - MOUNTAIN GATE ESTATES LLMD
282 - VILI.AGIO LLMD
283 - VAIDYA LLMD
284 - CLUB, SOUTH OF 111 LLMD
285 - MONTELENA LLMD
286 - SUNDANCE LLMD
287 - PROVINCE LLMD
2BB - PROVINCE DBAD

TOTAL SPECIAL REVENUE FUNDS

CAPITAL PROJECT FUNDS
314 - PARK-IN-LIEU FEES
315 - CITYWIDE PUBLIC IMPROVEMENT FEE
316 - CAPITAL IMPROVEMENT
319 - ART IN PUBLIC PLACES
321 - HIGHWAY 111 CIRCULATION IMP FEE

TOTAL CAPITAL PROJECT FUNDS
$3,180,215.77 $5,519,517.81
3,LBO,2r5.77
6,963.99
13,225.36
rtr,229.33
2,569,296.53
t2,226.66
69,618.18
11,763.65
5,8L4.67
4,46t.04
4,9r3.r2
1,843.83
266,829.56
3,457,700.86
53r,784.78
263,061.51
13,353.68
1,388,769.81
2,166,09r.54
L4,684,692.50
59,393.11
2,215.66
4,097.46
3,352.44
1L8,470.87
r2,8r7.40
87,8L9.24
60,874.22
63,198.39
99,176.20
54,555.87
262,687.99
36,928.2r
25,595.20
69,888.54
838.78
77,409.03
5,519,517.81
281.16
T,879.L6
23,355.10
2,548,49O.43
rt,766.96
143,870.81

0.00 0.00

0.00 0.00
1,340.33
165,086.37
3,550,994.24
570,443.99
272,898.3r
12,095.63
1,390,549.81
2,168,868.54
14,599,0r9.22
59,939.95

0.00 3,724.98
3,279.67
4r,5L8.26
10,051.88
72,8t2.42
60,2L4.97
58,670.4r
91,066.48
51,643.00
254,439.96
35,691.03
20,608.62
50,L46.87
L,234.33
78,2L7.58
594 743.07 613 92s.sB
27,2L7,7OL.28

0.00 14,937.00
3,396,150.84
r72,750.54

0.70 26,968,125.05
0,00
84,703.26
8,682,038.96
151,335.23

0.70 8,918,078.15
10:12 4M21912022T:\Common\bank\Treasurer's Report\Cash 1 0Oct 2 1 -draft 3,583,839.08
ATTACHMENT #1
161

CITY OF INDIAN WELLS
NET CASH & INVESTMENT SUMMARY OCTOBER 2021
PAGE 2
RESTRICTED FUNDS (Cont.T

REPLACEMENT FUNDS
326 - BUILDINGS CAPITAL RESERVE
327 - BRIDGES CAPITAL RESERVE
328 - MEDIANS & PARKWAYS CAPITAL RESERVE
329 - STORM DMINS CAPITAL RESERVE
330 - TRAFFIC SIGNALS CAPITAL RESERVE
331 - TMFFIC SIGNALS CAPITAL RESERVE
332 - CITY STREETS CAPITAL RESERVE
333 . CITY VEHICLES CAPITAL RESERVE

TOTAL REPLACEMENT FUNDS

SUCCESSOR AGENCY FUNDS
4s3 - RDA (WHTTEWATER)
456 - RDA OBLIGATION RETIREMENT

TOTAL SUCCESSOR AGENCY FUNDS

ENTERPRISE FUNDS
560 - INDIAN WELLS GOLF RESORT

TOTAL ENTERPRISE FUNDS

INTERNAL SERVICE FUNDS
601 - OPEB BENEFIT FUND

TOTAL INTERNAL SERVICE FUNDS

RESERVE FUNDS
602 - COMPENSATED ABSENCES

TOTAL RESERVE FUNDS

TRUST & AGENCY FUNDS
732 - SPECIAL DEPOSITS

TOTAL TRUST & AGENCY FUNDS

TOTAT ALL FUNDS

FISCAL AGENTS
253 - INDIAN WELLS VILLAS
254 - MOUNTAIN VIEW VILLAS
453 - UNION BANK OF CALIFORNIA TRUSTEE
560 - INDIAN WELLS GOLF RESORT
601 - PARS SECTION 115 TRUST

TOTAT FISCAL AGENTS
October
2021
October
2020
t,743,602.80
I,792,873.00
t,427,07I.07
720,640.00
592,199.00
540,817.00
L9,664,37r.00
124,081.00
L,433,279.80
1,720,036.00
1,368,793.07
691,510.00
568,899.00
518,468.00
18,868,106.00
1r8,244.00
26,605$54.87
2,392,663.40

0.00 25,287,335.87
236,028.96

0.00 2,392$63.4O

0.00 236,028.96

0.00 0.00
473 836.38
473,836.38
227 629.37
o.00
227,629.37
606,841.00 607 620.00
606,841.00
934,885.10
607,620.0O
339,764.s3
934,885.10
64,995,636.88
339,764.53
68,LO4,O99.74
420,583.59
854,606.53

17.69 t,478,978.43
960,779.8I
208,825.50
407,687.24
9,207.67
411,508.13
784,469.9t

TOTAL ALL FUNDS & FISCAL AGENTS

UNRESTRICTED FUNDS

RESTRICTED FUNDS
3,714t966.O5
$ 68,710,602.93
3,18O,215.77
65,530,387.16
$ 68,710,602.93
1,821,698.45
$ 69,925,798.19
5,519,517.81
64,406,290.39
$ 69,9 25,798.19
TlCommon\bank\Treasurer's Report\Cash 1 0Oct 2 1 -draft 10:12 AM21912022162

Tlcommonuan$ank rcmrcilialion ly2&021.lo_RPT,Ocl Eank R€dd21 pootd 5:O3PM 2lal2o22 Reconciliation Report - City Held Cash
Department
Bank Chffking & SGp
1 2
3 6,
4I
19 2t
Pacific Wstern Bank - Accb. Payable x*-**3411
Pacific W6tem Bank - Payrcll x*-**1752
Pacific W6tern Bank - Ambulance x*-****7937
Pacific Wstern Bank - Public Funds MltlA **-****5054
Union Bank of CA - Swftp Invgtment ***-***0121
US Bank Money Market - Inv6tment
Petty Cash

0.00 0.00

0.00 500,754.02
2,000.00
82,975.29
2,23s,098.31
425
430
437
438
441
442
443
'l4s45'
460
4634il
465
473
44082
444
483
a85
446
498
499
501
507
512
513
514
515
516
517
514
519
520
521
s22
525
s/r8
550
557
/r8a
/ra9
490
523
,24
526
533
s38
549
556
458
537
531
Managed P@l AKunts
Certifi6t6 of lrepGit
Certifi@te of Depcit{apital One Bank 14042REU1
Certifi@te of Deposit-Medallion Bank Utah 5840385T9
Cedifi@te of Deposit{Blc Bank, USA 74267cW1
Certifi@te of Deposit-EverBank FL 29976D2N9
Certificate of Deposit-American Exprs Bank 02587CFG0
Certifl@te of Deposit-American Exp6 Gnturion 025870566
Certifi cate of Deposit-Synchrony Bank 87164WRD2
Certificale of Deposit{ity National Bank I7801GBR9
CertifiGte of Depcit-Morgan Stanley B€nk 617471VF53
Certificate of Deposit-Allegiane Bank Tes 01748DB,B
Certifi€G of Deposit{itiBank NA 17312QH69
Certificah of Deposit{oldman Sachs Bank 38148PG43
Certificate of Deposit-Sallie Mae 795450N84
Certificate of Deposit-First National Bank of America 32l10YLK Certificte of Deposit-Disover Bank 254673UL8
Cetifi@te of Deposit-Barclays Bank Delaware 06740K1.1N4 CertifiGte of Deposit{onenity Capital Bank 20033A1486
Certifi@te of Deposit-UsB Bank USA 9034SJFF2
CertifiGte of Deposit-Morgan Stanley Bank 61760AM3
Certifi6te of Deposit-Merrick Bank 59013J4x4
Certificte of Deposit-RlA Federal Credit Union 7496224L0 Certifrcate of Depcit-Capital One Bank 14042TAY3
Certificate of Deposit-Bankw6t 06652CHA2
Certificate of Deposit-Wells Fargo Natl Bank West 949495AQ8 Certificate of D€pGit-BMW Bank North Ameri@ 05580AVX9
Cedilicate of Deposit-Nicolet Nation Bank 654062J22
Certificate of Deposit-Live Oak Bankinq Company 538036181 Grtificate of Deposit-Alma Bank 0200808X4
Certificate of Deposit-State Bank of India 855285TP8
Certifiate of Deposit-First Natl Bank of llccregor TX 321 l2tJDl Certifi@te of Deposit{enteEtate Bank 15201QDE4
Certifi@te of Deposit-Northwgt Bank 66736A8V0
CertifiGte of Deposit-Encore Bank 29250148E4
Certifi@te of D€posit-First Freedom Bank 32027MM9
Certificte of Deposit-Pacific Wst€rn gank 59505YRL5
Certifi6te of D€posit-Bank of Barcda 06063HMS9
Certifi@te of Deposit-Toyota Financial Sgs Eank 89235MKY6 Certifi€te of Deposit€renstate Credit Union 3957318L1
Certifl@te of Deposit-Pentagon Federal Credit Union 709621AS 247,000.00
250,000.00
2s0,000.00
250,000.00
2s0,000.00
250,000.00
250,000.00
250,000.00
2s0,000.00
245,000.00
2s0,000.00
250,000.00
2s0,000.00
248,000.00
2s0,000.00
250,000.00
2s0,000.00
250,000.00
2s0,000.00
250,000.00
249,000.00
247,000.@
249,000.00
249,000.00
250,000.00
250 000.00
250,000.00
250,000.00
248,000.00
249,000.00
248,000.00
249,000.00
249,000.00
249,000.00
248,000.00
249,000.00
250,000.00
250,000.00
249,000.00
1,000,000.00
1,000,000.00
Amazon,com Inc. 023135AW6
JP l'lorgan Cha* 481288A87
Wells Fargo 95001D6U9
Bank of New York Mellon Corp 05405MN7
tlonteb€llo C.A Pens Oblig AA 612285A85
lP l4organ Cha* Bank NA 45532FRU1
JP Morgan Chas 48128G2Q2
Bank ofAmerica MTN 06048WM31
Bank of Americ I'ITN 06048WM72
Natomas C-A Sch@l District 63877NMM6
Total Pmled Cash and Invgtnents
Fair Value Increa* (over cost)
Outstanding Warrants/Wire Transfe6
OuEtanding Payroll Warranb/Wire Transfe6
Deposib in Transit
D€posit in Transit
Deposit in Transit
Deposit in Transit
Deposit in Transit
Cr€dit card in Transit
988,501.15
886,170.01
1,013,255.05
1,058,531.01
1,000,000.00
2,000,000.00
1,000,000.00
Federal Agend l$u6
43r506 Fed. Farm Credit Bank 3133ELKS2 3,000,000.0052, Fed. Nat'l Morlgage Ass. 3135G4C43 2,000,000.00529 Fed. Farm Credit Bank 3133E1280 2,000,000.00530 Fed. Farm Credit Bank 3134GWCG9 1,000,738.26532 Fed. Nat'l Mortgage Ass 3135cA223 2.OOO,OO0.00534 Fed. Farm Credit Bank 3130At3S1 1,O0O,O0O.OO535 Fed. Farm Crcdit Bank 3130A16G4 1,000,000.00536 Fed. Farm Credit Bank 3130AL5J8 2,000,000.00539 Fed. Farm Credit Bank 3130ALDN1 2,000,000.00541 Fed. Farm Credit Bank 3130ALHZ0 1,000,000.00542 Fed. Farm Credit Bank 3130AL152 1,000,000.00544 Fed. Farm Credit Bank 3130ALMM3 2,000,000.00545 Fed. Farm Credit Bank 3130A1W67 1,000,000.00551 Fed. Farm Credit Bank 3130AMW57 2,000,000.00552 Fed. Farm Credit Bank 3133EMH21 2,000,000.00553 Fed. Farm Credit Bank 3133EM167 2,000,000.00554 Fed. Farm Credit Eank 3133E!1N99 2,000,000.00555 Fed. Farm Credit Bank 3133EMW73 3,000,000.00 MuniciDal Bonds
oixon CA Unified Sch@l Dislrict 255551KY5 503,707.52
300,000.00
items
Outstandlng ltems
(1,817.24)
(3,240.11)
(2,989.12)
(123.01)

0.00 435.00
(510,627.s2)

0.00 394,867.22
$ 64,995,636.88
163

INDIAN.. WELLS The City of Indian Wells
Portfolio Management
Portfolio Summary
October 3'1,2021
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CA.L"i i:ORN IA
lnvestments
Bank Certificates of Deposit
Managed Pool Accounts - LAIF
lvloney Market Sweep/Checking Account
Negotiable CD's
Medium Term CorpoEte Notes
Federal Agency lssues - Callables
Miscellaneous Securities - Coupon
lnvestments
Total Earnings
Current Year
Average Daily Balance
Effective Rate of Return
The above
Kevin
Par Market
Value
3,563,820.25
3,742,045.84
4,422,586.44
6,384,867.70
10,833,590.39
34,688,070.00
1,276,247 .40
Book
Value
3,490,000.00
3,742,045.84
4,422,586.44
6,232,000.00
1 0,943,061.60
35,000,736.26
1,288,707.52
%of
PorHolio
Days to
Maturity
YTM
360 Equiv.

YTM
365 Equiv.Value
3,490,000.00
3,742,O45.84
4,422,586.44
6,232,000.00
1 0,893,000.00
35,000,000.00
I,285,000.00
Term
cJb

5.75 6.79

9.57 16.80

53.75 1.98

2.473

0.200
o.122

1.768
't.777

0.940
'1.456

2.507
o.203

0.'124

1.792

1.802

0.953

1.476
1,826
1 1
1 ,718
1,686
1,795
1,436
308
'l
1 1,047
1,164
1,399
722
6s,064,632.28 64,911,228.02 6s,119,137.66 't 00.00% 1,539 1,079 1j54 1.170 October 31 Month Ending
168,205.57
65,640,960.49

3.020/"
, cash flow from revenue and maturing investments will be sufficient to cover expenditures for the next six months. All securities are "Markedto-Market" on a monthly basis.

Reporting petiod'l OlOl 12021 -1 Ol31 12021 Portfolio Clry AP
Pr, (PRF_PM1) 7.3.0
Report Ver. 7.3.6.1
Di
Run Dale: 1112312021 - 12t26 No fiscal year history available 164

YTM Days to
360 Maturitv
Page I
Maturity
Date
Average
Balance
3,490,000.00
2,779,416.81
3,457,312.63
Purchase
Date
03131t2020
07n2t2020
Par Value
245,000.00
250,000.00
250,000.00
247,OOO.OO
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
3,490,000.00
3,742,O45.84
000
3,742,045.84
4,422,586.44
250,000.00
249,000.00
Market Value
252,278.95
253,247.50
253,247.50
247,330.94
252,222.50
258,997.50
252,942.50
252,260.00
259,740.32
259,945.00
250,837.50
257,237.50
260,132.50
253,320.00
3,563,820.2s
3,742,O45.84

0.00 3,742,045.84
4,422,586.44
255,297.50
248,208.18
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
October 31,2021
CUSIP lnvestment #
Bank Certificates of Deposit
0't 748DBA3
02587DS66
02s87CFG0
14042REU 1
74267GVI1
1731 2QH69
1 7801 GBR9
29976D2N9
321 1 0YLK9
38148PG43
5840385T9
61 747MF63
795450N84
87164WRD2
Negotiable CD's
0200808X4
06063HM59
lssuer
Allegiance Bank Texas
American Express Centurion
American Express Bank FSB
Capital One Bank CD
CIBC Bank USA

CITIBANK NA
City National Bank
Everbank FL
First National Bank of America
Goldman Sachs Bank
Medallion Bank Utah
Morgan Stanley Bk NA
Sallie Mae
Synchrony Bank
Stated
Book Value Rate Fitch
245,000.00
250,000.00
250,000.00
247,0QO.O0
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
3,490,000.00

2.600

2.400

2.400

2.000

2.200

2.850

2.1 00

2.250

3.150

3.000

2.050

2.650

3.050

2.400
o2to7no23
05t2412022
05t2412022
1112312021
03ROt2022
03t2912023
05t31t2022
03t29t2022
0712012023
04t25t2023
1212912021
o1tl1t2023
0412512023
0512612022
460
442
441
425
437
463
445
438
473
464
430
457
465
443
o2to7t2018
05t24t2017
o5t24t2017
1112312016
03t30t2017
03t29t2018
0513012017
03t29t2017
0712012018
0412512018
12t29t2016
01t11t2018
o425no18
0512612017
071o112019
071o112019

2.564

2.367

2.367

1.973

2.170

2.811

2.071

2.219

3.107

2.959

2.O22

2.614

3.008

2.367
463
204
204
22 149
513
211
148
626
540
58 436
540
206
Subtotal and Average
Managed Pool Accounts - LAIF
SYS2I 21 LAIF - City
SYS23 23 LAIF - Redevelopment
Subtotal and Average
Money Market Sweep/Checking Account
3,742,O45.84

0.00 3,742,045.84
4,422,586.M
250,000.00
249,000.00
o.203

0.233

0.200

0.230

2.473 308

0.200

0.122
SYSl
SYS6
SYST
SYSs
SYS2
SYS3
SYS4
SYS19
SYS5
07to1t2019
07to1t2019
08t31t2021
07t01t2019
07t01t2019
1,601 ,757 .82

0.00 500,754.O2
2,235,O98.31

0.00 0.00
82,976.29
2,000.00

0.00 I ,601 ,757.82

0.00 5QO,754.O2
2,235,098.31

0.00 0.00
82,976.29
2,000.00

0.00 1,601 ,757 .82

0.00 500,754.O2
2,235,098.31

0.00 0_00
82,976.29
2,000.00

0.00 0.247

0.000
o.247

0.000

0.000

0.000
o.247

0.000

0.000
1 b
7 8
2 ?
4 19
5 Pacific Western Bank
Pacific Western Bank-Ambulance
Pacific Western-PublicFundsMMA
US Bank Money Nlarket
Pacific Western - Acct Payable
Pacifi c Western-Payroll
Union Bank-Checking
Petty Cash
WestAmerica Bank
Subtotal and Average

0.250

0.250

0.250
1,243 0312812025

1.359 0712212025
Portfolio CITY
AP
PM (PRF PM2) 7.3.0Run Date: 11D312O21 - 12:26
515
525
Alma Bank
Bank of Baroda

1.400

0.700

1.380

0.690
Report Ver. 7.3.6.1165

INDIAN '.,WELLS The City of lndian Wells
Amortization Schedule
October 1, 2021 - October 31, 2021
Sorted By Fund - Fund
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489
Amount Amortized Amt Amortized Amount Unamortized
This Period Throuqh 1OI3'll2O21 Throuqh 1OB12O21
CAL ORh.IIA
lnvestment #
lssuer
Maturity Date Beginning ParValue
Fund Amort. Date Current Rate
Purchase
Principal
962,940.00
1,975,880.00
1 ,018,830.00
990,250.00
504,655.00
1,001,000.00
869,960.60
1,O79,720.00
968,240.00
9,371,475.60
9,371,475.60
Original Premium
or Discount
-37,060.00
-24,120.00
1 8,830.00
-9,750.00
4,655.00
1,000.00
-23,039.40
79,720.00
-31.760.00
-21,524.40
-2',t,524.40
Ending
Book Value
Amounts Amortized
And Unamortized
Lc 6l'llll0'llrir4
fund
489 1
Amazon.com lnc.
495 1
Apple, lnc.
524 1
Bank of New York Mellon Corp
488 1
Chevron Corp
537 1
Dixon CA unified School Dist
530 1
Fed. Home Loan Mtg Corp
490 1
JPMorgan Chase & Co
526 1
Montebello CA Pens Oblig AA
487 1
Oracle Corp
02t22t2023
05t03t2023
04t24t2025
06t24t2023
0810112024
0413012025
01t1512023
06t0112025
10t't5t2022
1,000,000.00

2.400
2,000,000.00

2.400
1,000,000.00

1.600
1,000,000.00

3.191
500,000.00
o.672
988,501.1 5

0.00 1 ,013,255.05
996,504.38
503,707.52
1,000,736.26
886,170.01
1 ,058,631.01

0.00 6,447,505.38
6,447,505.38
24,828.74
-12,231.26
14,598.51
-9,521.49
-5,257.59
13,572.41
6,O77.54
-3,672.46
-835.1 3
3,819.87
-246.20
753.80
15,737.30
-7,302.10
-19,725.47
59,994.53
23,305.74
-8,454.26
58,483.44
36,959.04
58,483.44
36,959.04
732.41
116.52
-317.36
176.44
-112.35
-17.54
472.11
1,363.52
158.23
-154.66
-154.66
25,561.15
14,715.O3
-5,574.95
6,254.34
-947.4A
-263.74
16,209.41
-21,088.99
23,463.97
58,328.78
54328.78
1,000,000.00

0.650
893,000.00

2.972
1,000,000.00

2.503
1,000,000.00

2.500
Subtotal
Total
-11 ,498.85

0.00 13,255.05
-3,495.62
3,707.52
736.26
-6,829.99
58,631.01

0.00 54,505.38
54,s0s.38
Portfolio CITY
AP
AS (PRF_ASW) 7.2.1
Report Ver. 7.3.6.1
RunDale: lng2o21 - 11:42
166

The Gity of lndian Wells
Portfolio Management
Portfolio Details - Investments
October 31,2021
Page2
YTM Days to MaturityAverage Purchase Stated
CUSIP lnvestrnent #
Negotiable CD's
06652CH42
06740KMN4
055804VX9
14042T4Y3
1 5201 QDE4
200334M86
254673UL8
29260M8E4
32027B4M9
321 12UDRg
39573LBLl
5380361D4
5901 3J4X4
617604RM3
654062J22
66736ABV0
69506YR15
709621AS1
7496224LO
856285TF8
89235MKY6
90348JFF2
949495AQ8
Medium Term Corporate Notes
0231354W6 489
06048\ /1\1131 549
06048\ ,/lvl72 556
06406RAN7 524
1667644H3 488
4A12ABAB7 490
48128G2Q2 538
46632FRU1 533
612285AE6 526
95001D6U9 523
lssuer
Bankwest lnc.

Barclays BanUDelaware

BMW BANK NORTH AMERICA
Capital One Bank USA NA
Centerstate Bank NA
Comenity Capital Bank
Dismver Bank

ENCORE BANK
First Freedom Bank
First Natl Bank of Mccregor TX
Greenstate Credit Union
Live Oak Banking Company
Merrick Bank
Morgan Stanley Private Bank
Nicolet National Bank
Northwest Bank
Pacific Western Bank CA CD
Pentagon Federal Credit Union
RIA Federal Credit Union
State Bank of lndia NY, NY CD
Toyota Financial Sgs Bk
UBS Bank USA
Wells Fargo Natl Bk West
Subtotal and Average
249,000.00
250,000.00
250,000.00
247,OOO.OO
248,000.00
250,000.00
250,000.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
249,000.00

2.000

3.250
1 .550

2.300

1.250

3.450

3.300

1.150

1.100
1 .350

0.900

1.400

3.400

3.400

1.400

1.200

1.250

0.900

2.500

1.600

0.900

3.500
1 900
07t26t2019
10t24t2018
03131t2020
07t1812019
04t30t2020
101301201a
101031201a
0413012020
0413012020
0412a12020
06t16t202'l
03t31t2020
1112012018
1110812018
03t31t2020
04t3012020
0413012020
09t29t2021
0612412019
04t29t2020
04t2212021
1013012018
01t28t2020
Par Value
249,000.00
250,000.00
250,000.00
247,000.00
248,000.00
250,000.00
250,000.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
249,000.00
6,232,000.00
Market Value
257,929.14
257,605.00
256,570.00
2s7,675.34
252,062.24
264,797.50
263,642.50
252,294.27
251,985.51
253,945.14
249,170.00
255,315.00
259,650.00
258,232.50
255,31 0.00
252,655.32
252,062.24
247,182.30
259,562.54
255,063.04
249,650.00
264,997.50
254,OO4.90
5,384,867.70
Book Value
5,232,000.00
Ei+^h
501
482
512
499
518
444
480
520
521
517
550
514
486
485
513
519
522
557
498
516
548
483
507

1.973

3.205
't.529

0.000

1.233

3.403

3.255
I .135

1.086

1.332

0.888

1.342

3.356

3.352

1.3A2

1.184

1.233

0.888

2.464

1.574

0.888

3.454

1.875

3.303

1.233
I la4
1 .190

3.375

3.610

0.789

0.690

0.819

2.959
998
1,246
968
1,276
728
701
911
911
1,274
1,688
1,246
445
372
1,246
1,276
1,276
1,793
785
1,275
1,633
725
442
478
1,669
1,732
1,270
600
440
1,578
1,543
'l,308
545
07t26t2024
10t24t2022
o3R112025
06t26t2024
0413012025
1013012023
10to3no23
0413012024
0413012024
04t28t2025
06t16t2026
0313112025
ut20n023
11t0812022
03t31t2025
04t30t2025
04t30t2025
0912912026
12t26t2023
04t29t2025
0412212026
10t2712023
0111712023
6,320,709.68 1.768 'l,047
Amazon.com lnc.

Bank of America MTN A
Bank of America MTN A
Bank of New York Mellon Corp
Chevron Corp
JP|\ilorgan Chase & Co
JPMorgan Chase & Co
JP Morgan Chase Bank NA
Montebello CA Pens Oblig AA
Wells Fargo & Company
1210412018
05t28t2021
0713012021
0511412020
1112012018
1212112018
0212612021
0112212021
07 t17 t2020
04t30t2020
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
893,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
1,023,990.00
955,680.00
975,1 90.00
1,014,450.00
1,036,300.00
897,670.39
968,740.00
1,933,860.00
1,027,950.00
999,760.00
988,501.15
1,000,000.00
1,000,000.00
I ,013,255.05
996,504.38
886,'r 70.0'r
1,000,000.00
2,000,000.00
1,058,631 .01
1,000,000.00

2.400

1.250

1.200

1.600

3.191

2.972

0.800

0.700

2.503

2.150
02t22t2023
05t28t2026
0713012026
0412412025
0612412023
01t1512023
0212612026
0112212026
o6t01t2025
04t30t2023
Portfolio CITY
AP
Pr\, (PRF_PM2) 7.3.0RunDale: II12312O21 - 12:26
167

CUSIP lnvestment #
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
October 31,2021
Purchase
Date
Stated
Book Value p.+a Fitch
10,943,061.60

Page 3 ends

YTM Days to Maturity
360 Mafirrifw

1.777 1,154
Federal Agency lssues - Callables
lssuer
Subtotal and Average
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Mig Corp
Fed. Home Loan Mtg Corp
Fed. Nat'l Mortgage Assoc
Fed. Nat'l Mortgage Assoc
31 33ELKS2
31 33ELZ80
31 33EMH21
31 33EML67
31 33EMN99
3133EMW/3
3t 30AL3S1
31 30AL6G4
31 30AL6J8
31 3OALDNl
31 3OALHZO
31 30ALJ62
31 3OALMM3
3130A1W67
31304MW57
3134GA4A9
3'134GWCGe
31 36G4C43
3135Gp223
0210312020
07129t2020
0611712021
06t22t2021
06t30t2021
0712812021
02/1712021
o2n5l2o21
02t24t2021
03/16no21
0311812021
03t24t2021
oa30no21
04t22t2021
0613012021
02t28t2017
0713012020
08114t2020
1'v17 t2020
01t16t2018
o2t14/2021
10101t2020
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
't,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,736.26
2,000,000.00
2,000,000.00
35,000,736.25
485,000.00
503,707.52
300,000.00
1,288,707.52
65,1 1 9,1 37.56
o2t03t2025
07t2912025
0611512026
0612212026
06t30t2025
07t28t2026
02t17t2026
02t25t2026
02t24t2026
0311612026
o6ha2025
03t24t2026
0313012026
04t22t2026
0613012026
02t28t2022
04t30t2025
08t14t2025
11t17t2025
506
529
552
553
554
555
534
535
536
539
541
542
544
546
551
431
530
527
532
Average
Balenca
11,516,597.46
Par Value
10,893,000.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
35,000,000.00
485,000.00
500,000.00
300,000.00
1,285,000.00
65,064,632.28
Market Value
10,833,590.39
3,012,360.00
1,977,560.00
1,969,360.00
1,972,600.00
1,989,240.00
2,958,480.00
982,320.00
982,580.00
1,966,900.00
1,976,580.00
988,640.00
990,1 60.00
1,983,420.00
996,1 60.00
1,976,200.00
3,017,970.00
991,720.00
1,985,440.00
1,970,380.00
34,688,070.00
485,698.40
494,290.OO
296,259.00
1,276,247.40
64,911,228.O2

1.700

0.580

0.900

0.800

0.740

0.870

0.625

0.600

0.625

0.800

0.530

0.875

1.000

1.100

0.650

2.000

0.650

0.650

0.560

1.677
o.572

0.888

0.789

0.730

0.858

0.616

0.592
o.ois'

0.789

0.523

0.863

0.986

1.08s

0.967

1.973

0.621

0.641

0.552
1,190
'r,366
1,687
1,694
1,337
1 ,730
1,569
1 ,577
1,576
1,596
1,325
1,604
1 ,610
1,633
't,702
119
1,276
1,382
1,477
Subtotal and Average 36,678,'163.84
Miscellaneous Securities - Coupon
1397028N3 458 capistrano school district
255651KY6 537 Dixon CA Unified School Dist
63877NMM6 531 Natomas CA Sch DistAA Insured
Subtotal and Average 1,2AA,760.07
Total and Average 65,640,960.49

2.450
o.672
'1 .'100

2.786

0.395

1.085

0.940 1,399

1.456 722

1.'.ts4 1,079
30 1210112021
1,OO4 0810112024
1,369 08t01t2025
Portfolio CITY
AP
Pr\t (PRF_Pt\r2) 7.3.0Run Date. 1112312021 - 12:26
168

'74.ti{- i\iINDIAN ,):'WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells C492210
(760)346-2489CALITORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Daily Balance
of Return
Agency
Reporting period 1 0/01 /2O21 -'l0l3'l 12021
201 4, 201 5, 2O'l 6, 2020 Series
Portfolio Management
Portfolio Summary
October 31,2021
Par Market
Value

9.69 9.69

9.69 100_00

9.69 100.00%
Book
Value
%ot
Portfolio
Days to
Maturity
YTM
360 Equiv.
0_000

0.000

YT'II,I
365 Equiv.
0_000

0.000
Portfolio 14A
CP
PM (PRF_PMl) 7.3.0
Report Ver 7.3.6.'1
Value

9.69 9.69
October 3l Month Ending
Term

0.00 ,t 2.59

0.00%
Run Date: 11D3DO21 - 14.02 No fiscal year history available 169

cusrP lnvestment #
Money Market Sweep/Checking Account
lssuer
2014A Bonds Reserve
All Bond Series Principal
All Bond Series lnterest
All Bond Series Debt Svc
Cost Of lssuance Escrow
Subtotal and Average
Total and Average
28 zo
25 27
1 Average

12.59 12.59
07to1no19
07t01t2019
07 t0112019
07to1t2019
07t01t2019
2O1 4, 2015, 2016, 2020 Series
Portfolio Management
Portfolio Details - Investments
October 31,2021
Purchase
Date Par Value
Page I
YTM Days to MaturityStated
Book Value F!.f. Fitch

9.69 9.69

1.00 0.03

0.00 8.66

0.00 1.00

0.03 0.00

8.66 0.00
Market Value

1.00 0.03

0.00 8.66

0.00 9.69

9.69 0.000

0.000

0.000

0.000

0.000
SYS28
SYS26
SYS25
SYS27
SYS24

9.69 9.69

0.000

0.000
Portfolio 144
CP
PM (PRF_PM2) 7.3.0Run Oate: 11f2a2021 - 14:02
Report Ver. 7.3.6.1170

-rd,/
..l{-.\ii
INDIAN ''F WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CALITORNIA
lnvestments Value
Money Market Sweepichecking Account
lnvestments
'1.00

1.00 Totqf Eqrningg october 31 ltilon!! !n{r1g
Current Year 0.00
Average Daily Balance 1.00
of Return 0.00o/o
Agency
Reporting period I 0/01/2021 -'l 0131 12021
Par
2015 A Bonds
Portfolio Management
Portfolio Summary
October 31,2021
Market
Value
Book
Value Term
Days to
Maturity

1.00 1.00
%of
Portfolio

1.00 100.00

1.00 100.00%
YTM
360 Equiv.

0.000
1 0.000
YTM
365 Equiv.

0.000

0.000
Portfolio 15A
CP
PM (PRF_PMl) 7.3.0
Report Ver 7.3.6.1
1 Rtn Dane: 11D3DA1 - 13S No fiscal year history available 171

2015 A Bonds
Portfolio Management
Portfolio Details - lnvestments
October 31,2021
Purchase
Datelgsuer
2015AReserve
UBC Cost Of lssuance Escrow
Fitch
YTM Daysto
355 Maturitv
Page {
Maturity
D.fa
SYS27
SYS22
CUSIP lnvestment #
Money Market Sweep/Checking Account
27 22
Subtotal and Average
Total and Average
oa13112021
07t41t2019

1.00 0.00

1.00 0.00
'1.00

0.00 0.000

0.000
Average
Brlance

1.00 .r.00
Par Value

1.00 1.00
Market Value

1.00 r.00
Stated
BookValue Refe
L00

1.00 0.000

0.000
1 Portfolio 15A
CP
PM (PRF_Prvr2) 7.3.0Run Date: 11/232021 - 13:56
Report Ver. 7.3.6.1172

.l-i-.i,
INDIAN.i.WELLS

CALIFORNIA
2016 A Bonds
Portfolio Management
Portfolio Summary
October 3'1,2021
Market
Value

1.00 1.00
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489
Par Book
Vrlrrc
%of
Portfolio
Days to
Maturity
YTM
360 Equiv.

0.000

0.000
YTM
355 Equiv.

0.000

0.000
Portfolio 164
CP
PM (PRF_PMl) 7.3.0
Report Ver. 7.3.6.1
lnvestments
Money Market Sweep/Checking Account
lnvestments
rotal EqTilgs
Current Year
Average Daily Balance
of Return
Reporting period'10101 12021 -1 0131 I 202'l
Value

1.00 1.00
October3l Month Ending

0.00 1.00

0.00%
Term
1 .00 100.00

1.00 r00.00%11
Run Date: 1 1/2312021 - 14:06 No fiscal year history available 173

SYS28
SYS33
lssuer
UBC Cost Of lssuance Escrow
Union Bank Reserve Account
Subtotal and Average
Total and Average
Stated
Book Value Rafe

1.00 1.00

Page 1 ends

YTM Days to Maturity
Fitch 365 Maturit\t l)rf.

0.000

0.000
Portfolio 164
CP
PM (PRF_PM2) 7.3.0
2016 A Bonds
Portfolio Management
Portfolio Details - lnvestments
October 31,2021
Purchase
DateCUSIPlnvestment #
Money Market Sweep/Ghecking Account
Average
Balance

1.00 1.00
071o1t2019
0710112019
Par Value

1.00 1.00
Market Value

1.00 1.00
2 0.00

1.00 0.00

1.00 0_00
'1_00

0.000

0.000
Run Dale: 1112312021 - 14:oG
Report Ver. 7.3.6.1174

INDIAN
i-* '' i
.-{ .. lj..} WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA 92210
(760)346-2489CALIFOIINIA
lnvestments
Money Market Sweep/Checking Account
Investments
Total Earnings
Par
2020 A Bonds
Portfolio Management
Portfolio Summary
October 31,2021
Martet
Value
October 3l
Value

1.00 1.00
Month Ending

0.00 1.00

0.00%
Book
Value
ilo oI
Portfolio
Days to
Matudty
YTM
360 Equiv.

0.000

0.000
Term
YTM
365 Equiv.

0.000

0.000
Portfolio 20A
CP
PM (PRF_PMl) 7.3.0
Report VeL 7.3.6.1

1.00 1.00
1 .00 100_00

1.00 100.00%1
Current Year
Average Daily Balance
of Return
Reporting petiod 10101 12021 -1 0131 12021
/
Run Dale. 11D3DO21 - 14:07 No fiscal year history available 175

2020 A Bonds
Portfolio Management
Portfolio Details - lnvestments
October 31,2021
Purchase
Date Par Value
06130n020
06130t2020
{.00

1.00 Stated
Book Value Ra1g Fitch

1.00 1.00

Page 1 ends

CUSIP lnvestnent #lssuer
Money Market Sweep/Checking Account
SYSI 1 2020 A Bonds COI
SYS2 2 2020 A Bonds Reserve
Subtotal and Average
Total and Average
Average
Balance

1.00 1.00

0.00 1.00

0.00 '1.00

0.00 1.00

0.000

0.000
Market Value

1.00 1.00
YTM Daysto
365 Maturitv

0.000

0.000
Maturity
Dafe
Portfolio 20A
CP
PM (PRF_PM2) 7.3.0Run Dale: 1112312021 - 14:07
Report Ver. 7.3.6.1176

City of Indian Wells
2/17/2022
44-950 Eldorado Drive,
Indian Wells
File #:032-22 Item #:R.

Indian Wells City Council
Staff Report - Finance February 17, 2022 City Treasurer’s Report for November 2021
RECOMMENDED ACTIONS:

Council RECEIVES and FILES the City Treasurer’s Report for November 2021.

DISCUSSION:

Attached are the monthly cash balance and investment reports for the month of November 2021.

Investments reflected in this report are “Marked-to-Market”, meaning the market value of City’s investments is updated monthly. This method provides a clear depiction of the value of the City’s portfolio subject to the performance of the investment market. The City of Indian Wells continues to maintain prudent fiscal reserves and minimize un-invested cash.

Cash and Investments
As of November 30, 2021:
·The City’s cash and investments totaled $64,737,188.27. ·The City’s portfolio earned a 1.175% rate of return.

Treasurer’s Certification
Compliance - The City Treasurer certifies the City’s cash and investments presented in this Report are in compliance with the City’s investment policy and with legal requirements of State of California Government Code section 53600.

Liquidity - The City Treasurer certifies the City’s portfolio is sufficient to meet its financial obligations for the next six months. The investment portfolio will remain sufficiently liquid to meet all operating requirements, which might be reasonably anticipated. This is accomplished by striving to have securities mature at the same time cash is needed to meet anticipated demands (static liquidity). Additionally, since all possible cash demands cannot be anticipated, the portfolio consists largely of securities with active secondary or resale markets (dynamic liquidity).

Fiscal Prudence
When investing, reinvesting, purchasing, acquiring, exchanging, selling, or managing public funds, a trustee shall act with care, skill, prudence, and diligence under the circumstances then prevailing, including, but not limited to, the general economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity City of Indian Wells Printed on 2/11/2022Page 1 of 2
powered by Legistar™177

File #:032-22 Item #:R.
economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity with those matters would use in the conduct of funds of a like character and with like aims, to safeguard the principal and maintain the liquidity needs of the City.

Background
Staff provides Council with a monthly update to the Treasurer’s Report. The Report presents the City’s cash activity and investment portfolio and provides reconciliation between investment balances and the General Ledger. Specifically, the report provides information on the types of investments, dates of maturities, costs, updated market value of securities, and rates of interest earned in the portfolio.

The City maintains a written investment policy in compliance with legal requirements of Government Code section 53600 and governs the investments made by the City. It is the policy of the City of Indian Wells to invest public funds in a manner that will provide the maximum security with the highest investment return while meeting the daily cash flow demands of the City. The investments purchased by the City are consistent with the City’s investment policy and are allowable under current legislation of the State of California.

The City invests in U.S. treasuries, federal agency securities, medium term corporate notes, municipal bonds, federally insured certificates of deposit, and overnight cash investments. Criteria for selecting investments in order of priority are:
(1) safety, (2) liquidity and (3) yield.

ATTACHMENT:

1. City Treasurer’s Report
City of Indian Wells Printed on 2/11/2022Page 2 of 2
powered by Legistar™178

NET CASH & INVESTMENT SUMMARY NOVEMBER 2021
November
202tUNRESTRICTED FUNDS

GENERAL FUND
101- GENERAL

TOTAL GENERAL FUND

RESTRICTED FUNDS

SPECIAL REVENUE FUNDS
202 - TMFFIC SAFETY
203 - PUBLIC SAFETY 1/2 CENT SALES TAX
204 - MEASURE UA''
209 - F.A.M.D. #1
210 - SCAQMD (VEHTCLE REG.)
211 - AB 3229 COPS FUNDING
214 - GAS TAX 2103 MAINTENANCE
215 - GAS TAX 2105 MAINTENANCE
216 - GAS TAX 2106 CONSTRUCT/MAINT
217 - GAS TN<2T07 MAINTENANCE
218 - GAS TAX 2107.5 ENG,/ADMIN
219 - GAS TAX RMRA
228 - EMERG. UPGRADE SERVICES
247 - AB 939 RECYCLING FUND
248 . SOLID WASTE
251 - STREET LIGHTING DISTRICT 2OOO-1
253- INDIAN WELLS VILLAS OPERATIONS
254- MOUNTAIN VIEW VILLAS OPERATIONS
256- HOUSING AUTHORITY
271 - ELDORADO DRIVE LLMD
272 - MONTECITO/STARDUST LLMD
273 - CASA DOMDO LLMD
274 -THE COVE LLMD
275 - SH 111/rWGR (ENTRANCE) LLMD
276 - CLUBIIW LANE LLMD
277 - COLONY LLMD
278 - COLONY COV ESTATES LLMD
279 - DESERT HORIZONS LLMD
2BO - MOUNTAIN GATE LLMD
281 - MOUNTAIN GATE ESTATES LLMD
282 - VILLAGIO LLMD
283 - VAIDYA LLMD
284 - CLUB, SOUTH OF 111 LLMD
285 - MONTELENA LLMD
286 - SUNDANCE LLMD
287 - PROVINCE LLMD
2BB - PROVINCE DBAD

TOTAL SPECIAL REVENUE FUNDS

CAPITAL PROJECT FUNDS
314 - PARK-IN-LIEU FEES
315 - CITYWIDE PUBLIC IMPROVEMENT FEE
316 - CAPITAL IMPROVEMENT
319 - ART IN PUBLIC PI-ACES
321 - HIGHWAY 111 CIRCULATION IMP FEE

TOTAL CAPITAL PROJECT FUNDS
$
November
2020
.92$ 4,751,008.85
4,751r009.95
8,550.24
t5,745.74
t33,240.95
2,547,000.35
12,226.66
77,95t.5I
18,I72.59
tr,09L.42
8,564.96
10,605.13
1,943.93
275,828.46
3,473,32r.08
522,59L38
260,284.88
t3,255.4r
1,388,769.81
2,L66,09r.54
14,626,067.92
55,824.51
820.r2
3,729.34
3,159.31
93,049,08
11,013.57
83,012.87
59,901.94
58,661.20
96,054.43
53,533.21
254,472.20
36,584.51
25,176.52
64,460.53
7r7.67
77,055.40
593,786.02
27,L42,2L6.19

0.00 17,426.00
2,008,302.58
r72,750.54

0.70 5,355,399.92

0.00 2,r2r.83
49,582.82
2,t97,593.20
1L,777.96
t39,3O7.t4

0.00 0.00

0.00 0.00
t,r74.67
L65,235.37
3,696,L7L.34
562,313.84
286,959.62
12,105.91
1,391,806.81
2,r70,828.54
t4,565,872.06
56,326.79

0.00 3,838.45
3,243.39
57,651.69
8,677.42
68,224.38
58,987.87
60,833.62
88,793.46
50,798.95
247,189.49
35,420.82
20,613.99
45,844.30
1,605.07
77,942.22
613 543.10
26t752,386.L2

0.00 87,27r.26
8,667,903.43
r5I,472.23

0.70 8,906,647.62
T:\Common\bank\Treasurer's Report\Cash 1 0Nov 2 1 -draft 2'198;479.82
9:35 AM2lgl2o22
ATTACHMENT #1
179

CITY OF INDIAN WELLS
NET CASH & INVESTMENT SUMMARY NOVEMBER 2021
PAGE 2
RESTRICTED FUNDS (Cont.'l

REPLACEMENT FUNDS
326 - BUILDINGS CAPITAL RESERVE
327 - BRIDGES CAPITAL RESERVE
328 - MEDIANS & PARKWAYS CAPITAL RESERVE
329 - STORM DMINS CAPITAL RESERVE
330 - TMFFIC SIGNALS CAPITAL RESERVE
331 - TRAFFIC SIGNALS CAPITAL RESERVE
332 - CITY STREETS CAPITAL RESERVE
333 . CITY VEHICLES CAPITAL RESERVE

TOTAL REPLACEMENT FUNDS

SUCCESSOR AGENCY FUNDS
4s3 - RDA (WHTTEWATER)
456 - RDA OBLIGATION RETIREMENT

TOTAL SUCCESSOR AGENCY FUN DS

ENTERPRISE FUNDS
560 - INDIAN WELLS GOLF RESORT

TOTAL ENTERPRISE FUNDS

INTERNAL SERVICE FUNDS
601 - OPEB BENEFIT FUND

TOTAL INTERNAL SERVICE FUNDS

RESERVE FUNDS
602 - COMPENSATED ABSENCES

TOTAL RESERVE FUNDS

TRUST &AGENCY FUNDS
732 - SPECIAL DEPOSITS

TOTAL TRUST &AGENCY FUNDS

TOTAL ALL FUNDS

FISCAT AGENTS
253 - INDIAN WELLS VILLAS
254 - MOUNTAIN VIEW VILLAS
453 - UNION BANK OF CALIFORNIA TRUSTEE
560 - INDIAN WELLS GOLF RESORT
601 - PARS SECflON 115 TRUST

TOTAL FISCAL AGENTS

TOTAL ALL FUNDS & FISCAL AGENTS

UNRESTRICTED FUNDS

RESTRICTED FUNDS
3,825,689.09 2,126,246.72
$ 68,895,815.72 $ 69,834,396.01
November
202L
L,743,602.80
7,792,873.00
r,427,07r.07
720,640.00
592,199.00
540,817.00
19,664,371.00
124,081.00
November
2,.020
L,434,575.80
1,72r,59I.00
1,370,030.07
692,135.00
568,899.00
518,937.00
18,885,161.00
118,865.00
26$O5,654.87
2,392,663.40

0.00 25,310,193.87
236,24t.96

0.00 2,392,663.4O

0.00 236,24t.96

0.00 0.00
439,639.81 185,615.02
o.00
439,639.81
606,841.00
185,615.02
608,169.00
606,841.00
933,622.69
608,169.00
353,505.78
933,622.69
65,070,126.63
353,505.78
67,7O8,L49.29
469,252.84
930,456.36

17.69 r,478,978.43
946,983.77
249,954.38
458,t28.34
9,207.98
565,013.52
843,942.50
4,751,008.85
64,144,806.87
5,355,389.92
64,479,006.O9
$ 08,81E,'815.72 $ 69,834,396.01
T:\Common\bank\Treasurer's Report\Cash 1 0Nov 21-dnft 9:35 4M21912022180

Tloomnoiuanruank ru€rcilialion ly?ro021 t 1_8PT_Nov Bank BoNov 2 I pool€d A:5AAM 2N2O22 Bank Reconciliation Report - City Held Gash
Department
Bank Chskins & Swep
1 2
3 6
7 4
8 19
2l
Pacific W6tern Bank - Accts, Payable *t-**3411
Pacific Wgtern Bank - Payrcll x*-**1752
Pacific Wstern Bank - Ambulance **-****7937
Pacific Western Bank - Public Funds MMA *r-*r**5064
Union Eank of CA - Swep Inv6tment ***-***0121
l.JS gank Money Market - Inv6tment
Petty Cash

0.00 r,780.94

0.00 500,856.92
!13,244.22
37,994.07
2,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
245,000.00
2s0,000.00
250,000.00
2s0,000.00
248,000.00
2s0,000.00
250,000.00
2s0,000.00
250,000_00
2s0 000.00
250,000.00
249,000.00
247,000.00
249,000.00
249,000.00
2s0,000.00
250,000.00
249,000.00
248,000.00
430
43'
438
441
442
443
445
457
450
463
454
465
47t
480
4424/t
443
445
446
498
499
501
507
512
513
514
515
516
51,
518
519
520
521
s22
525
5rr8
550
557
488
449
490
523
524
s26
533
s38
549
556
4ll
506
52'
529
530
532
514
535
536
539
54r
542
5'14
546
551
552
553
554
555
Certilictg of D€ffilt
Gdificate of Deposit{Blc Bank, USA 74267GW1
Grtificate of Deposit-EverBank FL 29976D2N9
Certifi@te of Deposit-Ameri@n Exprs Bank 02587CFG0
Certificate of Depcit-Ameri6n Exp6 Centurion 025870566
Certificate of Deposit-Synchrcny Bank 87154WRD2
Certificate of Dep6it{ity National Eank 17801G8R9
Certificate of Deposit-Morgan Stanley Bank 51747MF63
Certifi€te of Deposit-Allegiance Bank Tqas 01748D8A3
Certificate of Deposit{iti8ank NA 17312QH69
Certificate of Deposit€oldman Sachs Bank 38148PG43
Certificate of Deposit-Sallie Mae 795450N84
Certificte of Dep6it-First National Bank ofAmerica 32110Y1K Certifi@te of Deposit-Disover Bank 254573uL9
Certificate of Deposit-Barclays Bank Delaware 06740K1'1N4 Certifi@te of Deposit{omenity Gpitrl Bank 20033AM85
Certificate of D€posit-USB Bank USA 90348JFF2
Certifi@te of Deposit-MoEan Stanley gank 51750ARM3
Certifl6te of Deposit-Merrick Bank 59013J4x4
Certifi@te of Deposit-RlA Federal Credit union 749522AL0 Certifi6te of Deposit{apibl One Bank 14042TAY3
Certifi@te of Deposit-Bankw6t 06552CHA2
Certifi6le of Deposit-Wells Fargo Natl Bank Wst 9494954Q9 Certifi@te of Deposit-BMw Bank North America 05580At/X9 Certifi@te of Deposit-Nicolet Nation Bank 554062J22
CertifiGte of Deposit-Live Oak Banking Company 538036181 Certifi@te of Deposit-Alma Bank 0200808X4
Certifi@te of Deposit-Sbte Bank of India 856285TP8
Certifi@te of Deposit-First Natl Bank of MccregorTX 32112UD| CertifiGte of Deposit{ente6tate Bank 15201Q0E4
Certificate of Deposit-Northwgt Bank 66735A8V0
Certificate of Deposit-Encore Bank 29260M8E4
Certinete of Deposit-First Freedom Bank 320278AM9
Certificate of Deposit-Pacific W6tern Bank 69506YRI5
Grtificate of Deposit-Bank of 8arcda 06063HF1S9
Certificate of Deposit-Toyota Financial Sgs Bank 89235MKY6 Certificate of Deposit€renstate Credit Union 395731811
Certificate of Deposit-Pentaqon Federal Credit union 709521A5 250,000.00
250,000.00
248,000.00
249,000.00
249,000.00
249,000.00
248,000.00
249,000.00
250,000.00
250,000.00
249,000.00
Medium Tem Cormrat€ Not6
Amazon.com Inc.023135AW6 989,233.56
JP Morgan Chas 481288A87 885,642.13
Wells Fargo 95001D6U9 1,000,000.00
Bank of New York Mellon Corp 06405MN7 1,012,937.69
Montebello C.A Pens Oblig AA 612285AE6 1,057,257.50
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
Federal Agend l$u6
Fed. Farm Credit Bank 3133ELKS2
Fed. Natl Mortgage Asw. 3136G,1C43
Fed. Farm Credit Bank 3133E1280
Fed. Farm Credit Eank 3134GWCG9
Fed. Nafl Mortgage Ass 3135GA223
Fed. Farm Credit Bank 3130A1351
Fed. Farm Crcdit Bank 3130A16G4
Fed. Farm Credit gank 3130A16J8
Fed. Farm Credit Eank 3130ALDN1
Fed. Farm Credit Bank 3130ALHZ0
Fed. Farm Crcdit Bank 3130AU52
Fed. Farm Credit Bank 3130ALP1|Y3
Fed. Farm Credit Bank 3130A1W67
Fed. Farm Crcdit Bank 3130AMW57
Fed. Farm Credit Bank 3133EMH21
Fed. Farm Credit Bank 3133EN1167
Fed. Farm Crcdit Bank 3133E!1N99
Fed. Farm Credit Bank 3133EMW73
Munlclpal Bonds
JP Morgan Chas Bank NA 46632FRU1
JP l4organ Chare 48128G2Q2
Bank of America I'ITN 06Ol8Wl'131
Bank of America l4TN 06048w!172
3,000,000-00
2,000,000.00
2,000,000.00
1,000,718.71
2,000,000.00
1,000 000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
(55,205.01)

0.00 (1,81t.24)
(118.00)
(100.00)
4,888.00
10,942,762.t1
395,290.51
$ 65,070,126.63
458
537
531
Dixon C.A Unifled Sch@l Distrid 255651KY6
Natomas CA Sch@l District 63877N1VM6
503,595.17
300,000.00
it€ms
Outstandlng It€ms
Total P@led Cash and Invstments
Fair Value Incr@s (over cost)
Outstanding Warrants/Wire Transfe6
Oubtanding Payrcll Waranb/Wire Transfe6
Deposits in Transit
D€posit in Transit
Deposit in Transit
Credit Card in Transit

0.00 181

:*i --:. ,/"'ai
INDIAN,)'"wELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CALITORN IA
lnvestments
Bank Certificates of Deposit
Managed Pool Accounts - LAIF
Money Market Sweep/Checking Account
Negotiable CD's
Medium Term Corporate Notes
Federal Agency lssues - Callables
Miscellaneous Securities - Coupon
The City of lndian Wells
Portfolio Management
Portfolio Summary
November 30,2021
Par Market
Value
3,308,055.37
6,242,O45.84
1,788,066.44
6,352,741.90
10,821,706.82
34,587,440.00
1,274,884.00
64,374,940.37
Term
3,243,000.00
6,242,045.84
1,788,066.44
6,232,000.00
10,942,762.11
35,000,718.71
1,288,s95.17
64,737,188.27 100.00% 1,541
Book
Value
%ot
Portfolio
Days to
Maturity
YTM
360 Equiv.
1,059 1.159
YTM
365 Equiv.

1.175
Portfolib CITY
AP
PM (PRF-PM1) 7.3.0
Report Ver. 7.3.6.1
Valua
3,243,000.00
6,242,O45.84
1,788,066.44
6,232,000.00
'10,893,000.00
35,000,000.00
1,285,000.00

5.01 9.64

2.76 9.63

16.90 54.O7

1.99 1,826
1 1
1,718
1,686
1,79s
1,436

2.546

0.203
o.244

1.792

1.802

0.953

1.476
300
1 1
1,O17
1,134
1,369
692

2.511

0.200
o.241

1.768

1.777

0.940

1.456
54,683,112.28
lnvestments
Total Earnings Noveqbgr3o Month Ending
Current Year 62,255.65
Average Daily Balance 65,771,898.48
Rate of Return
Kevin
Reporting petiod'l 1 101 12021 -1'l 1301202'l

1.15%
cash flow from revenue and maturing investments will be sufficient to cover expenditures for the next six months. All securities are "Marked-to-Market" on a monthly basis Finance
Run Date: o1125f2o22 - 17:59 No fiscal year history available 182

The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
November 30,2021
Purchase
Date Par Value
Stated
Book Value p'ta Fitch

Page 1 ends

YTM Days to Maturity
CUSIP lnvestment #
Bank Certificates of Deposit
01 748DBA3
02587DS66
02587CFG0
74267GVT1
1 73 1 2QH69
1 7801 GBR9
29976D2N9
321 1 0YLK9
38148PG43
5840385T9
61 747MF63
795450N84
87164WRD2
Negotiable CD's
0200808X4
06063HMS9
06652CHA2
lssuer
Allegiance Bank Texas
American Express Centurion
American Express Bank FSB
CIBC Bank USA

CITIBANK NA
City National Bank
Everbank FL
First National Bank of America
Goldman Sachs Bank
Medallion Bank Utah
Morgan Stanley Bk NA
Sallie Mae
Synchrony Bank
460
442
441
437
463
445
438
473
464
430
457
465
443
Average
3,424,133.33
4,548,712.51
4,334,769.11
o21o712018
o5t24t2017
05t24t2017
03t30t2017
03n9t2018
0513012017
03n912017
07n0nu8
041251201A
12t29t2016
011111201A
04125t201A
0512612017
071o112020
245,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
3,243,000.00
6,242,O45.84

0.00 6,242,O45.84
1,788,066.44
250,000.00
249,000.00
249,000.00
Market Value
251,548.85
252,707.50
252,707.50
251,702.50
258,215.00
252,420.00
251,730.00
258,971.52
259,142.50
250,382.50
256,472.50
259,317.50
252,737.50
3,308,0s5.37
6,242,045.84

0.00 6,242,045.84
1,'132,190.29

0.00 500,856.92
37,994.07

0.00 1,780.94
113,244.22
2,000.00

0.00 1,788,066.44
253,627.50
246,223.65
257,O57.64
245,000,00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
3,243,000.00
6,242,045.84
0_00
6,242,045.84
1,132,190.29

0.00 500,856.92
37,994.07

0.00 1,74O.94
113,244.22
2,000.00

0.00 1,788,066.44
250,000.00
249,000.00
249,000.00

2.600

2.400

2.400

2.200

2.850

2.100

2.250

3.150

3.000

2.050

2.650

3.050

2.400

2.564

2.367

2.367

2.170

2.811

2.071

2.219

3.107

2.959

2.022

2.614

3.008

2.367
433
174
174
119
483
181
118
596
510
28 406
510
176
02t07t2023
o512412022
0512412022
0313012022
03t29t2023
05t31t2022
0312912022
0712012023
04t25n023
1212912021
01t11t2023
04t25t2023
o5t26t2022
Subtotal and Average
Managed Pool Accounts - LAIF
SYS21 21 LAIF - City
SYS23 23 LAIF - Redevelopment
Subtotal and Average
Money Market Sweep/Checking Account

0.203

0.233

2.511 300

0.200

0.230

0.200 1

0.247
0_000
o.247

0.000

0.000

0.000

0.247

0.000

0.000

0.241
SYSl
SYS6
SYST
SYSS
SYS2
SYS3
SY54
SYS19
SYS5
1j32,190.29

0.00 500,856.92
37,994.07

0.00 1,740.94
113,244.22
2,000.00

0.00 'l
6 7
I
2 J
4 19
5 Pacific Western Bank
Pacific Western Bank-Ambulance
Pacifi c Western-PublicFundsMMA
US Bank Money Market
Pacific Western - Acct Payable
Pacif ic Western-Payroll
Union Bank-Checking
Petty Cash
WestAmerica Bank
Subtotal and Average

0.250

0.250
08,31t2021
07to1t2020
07to1t2020

0.250
5'15
525
501
07t01t2020
0710112020
0313112020
07D212020
0712612019
1,213 03t28t2025
'1,329 07t22t2025
968 07t26t2024
Portfolio CITY
AP
PM (PRF_PM2) 7.3.0RunDale: 0112512022 - 17:59
Alma Bank
Bank of Baroda
Bankwest lnc.

1.400

0.700
2 000
1 _380

0.690

1.973
Report Ver. 7.3.6.1183

Stated
Book Value p.ra Fifch
Page2
YTM Days to Maturity
350 M.+rrriiwCUSIPlnvestment #
Negotiable CD's
06740KMN4
055804VX9
14042TAY3
I 5201 QDE4
200334M86
254673U18
29260M8E4
3202784M9
321 12UDR9
395731811
5380361D4
5901 3J4X4
617604RM3
654062J22
6673648V0
69506YR15
709621AS1
749622A.L0
856285TF8
89235MKY6
90348JFF2
949495AQ8
Medium Term Corporate Notes
0231 354\ /6
06048\ A/131
06048VVt\^72
06406RAN7
1 667644H3
4A12ABAB7
48128G2Q2
46632FRU1
61 228sAE6
95001 D6U9
lssuer
Barclays Bank/Delaware

BMW BANK NORTH AMERICA
Capital One Bank USA NA
Centerstate Bank NA
Comenity Capital Bank
Discover Bank

ENCORE BANK
First Freedom Bank
First Nati Bank of Mccregor TX
Greenstate Credit Union
Live Oak Banking Company
Merrick Bank
Morgan Stanley Private Bank
Nicolet National Bank
Northwest Bank
Pacific Western Bank CA CD
Pentagon Federal Credit Union
RIA Federal Credit Union
State Bank of lndia NY, NY CD
Toyota Financial Sgs Bk
UBS Bank USA
Wells Fargo Natl Bk West
Subtotal and Average
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
November 30,2021
482
512
499
518
484
480
520
521
517
550
514
486
485
513
519
522
557
498
516
548
483
507
Average
Brlanae
6,232,000.00
Purchase
Date Par Value
250,000.00
250,000.00
247,000.00
248,000.00
250,000.00
250,000.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
249,000.00
5,232,000.00
Market Value
256,710.00
254,847.50
256,815.78
250,308.88
264,O75.00
262,902.50
251,813.70
251,514.90
252,162.30
247,195.OO
253,627.50
25a,720.OO
257,322.50
253,627.50
250,904.85
250,308.88
245,548.46
259,012.29
253,220.40
247,520.OO
264,260.00
253,414.77
5,352,741.90
1,020,900.00
957,440.00
976,670.00
1 ,010,340.00
1 ,033,010.00
895,446.82
970,290.00
1,937,000.00
1,026,140.OO
994,470.00
10t24t2018
0313112020
0711812019
0413012020
10B0nu8
10103t2018
04t30t2020
04t3012020
0412a12020
06t16t2021
o3t31t2020
11l20no1a
11lOAl201A
03t31t2020
04t30t2020
04t30t2020
09t29t2021
0612412019
04t29t2020
04t22t2021
1013012018
0112812020
250,000.00
250,000.00
247,OOO.OO
248,000.00
250,000.00
250,000.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
249,000.00
6,232,000.00
10t24t2022
o3n112025
06t26t2024
0413012025
1013012023
10to3t2023
04t30t2024
0413012024
0u28n025
0611612026
oa31no25
01t20t2023
1110A12022
03t31n025
0413012025
o413012025
09n9t2026
12n6t2023
04t29t2025
04n2t2026
10t27t2023
01t17t2023

3.250

1.550

2.300

1.250

3.450

3.300

1.150

1.100

1.350

0.900

1.400

3.400

3.400

1.400
'l.200

1.250

0.900

2.500

1.600

0.900

3.500

1.900

3.205

1.529

0.000

1.233

3.403

3.255
1 .135

1.086

1.332

0.888

1.382

3.356

3.352

1.382
't.184

1.233

0.888

2.468

1.578

0.888

3.454

1.875
327
1,216
oae
1,246
698
671
881
881
1,244
1,658
't,216
415
342
1,216
1,246
1,246
1,763
755
1,245
'1,603
695
412

1.768 1,017
489
549
556
524
488
490
538
533
526
523
Amazon.mm lnc.

Bank of America MTN A
Bank oiAmerica MTN A
Bank of New York Mellon Corp
Chevron Corp
JPMorgan Chase & Co
JPMorgan Chase & Co
JP Morgan Chase Bank NA
Montebello CA Pens Oblig AA
Wells Fargo & Company
12tO4t2018
05t29t2021
07130t2021
05l'1412020
11t20t2018
12n1t201A
02126n021
01t2212021
0711712020
Q413012020
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
893,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
989,233.56
'1,000,000.00
'1,000,000.00
1,012,937.69
996,681.23
886,642.1 3
1,000,000.00
2,000,000.00
1,057 ,267 .50
1,000,000.00

2.400

1.250

1.200

1.600

3.191

2.972

0.800

0.700

2.503

2.150

3.303

1.233

1.184

1.190

3.375

3.6'10

0.789

0.690

0.819

2.959
448
1 ,639
1,702
1,240
570
410
1,548
1 ,513
1,278
515
02t22t2023
05t24t2026
0713012026
04t24t2025
0612412023
01t15t2023
0212612026
01t22t2026
061o112025
0413012023
Portfolio CITY
AP
PIV (PRF_Pl\il2) 7.3.0Run Dale: 0112512022 - 17:59
184

CUSIP lnvestment #
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
November 30,2021
Purchase
Dale Par Value
10,893,000.00

Page 3 ends

Stated YTM Days to Maturity
Book Value p.ra Fitch 360 Mrfrrritv
10,942,762.11 1.777 1,134
lssuer
Subtotal and Average
Fed. Farm Credit Bank
Fed. Fann Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Mtg Corp
Fed. Home Loan Mtg Corp
Fed. Nat'l Mortgage Assoc
Fed. Nat'l Mortgage Assoc
Subtotal and Average
Total and Average
Average
Flrl.n^a
10,942,906.87
35,000,727.19
1,288,649.48
65,771,898.48
Market Value
10,821,706.82
Federal Agency lssues - Callables
31 33ELKS2
3'l33ELZ80
31 33EMH21
31 33EML67
31 33EMN99
3133EMW73
31 30AL3S1
31 30AL6G4
31 30AL6J8
31 3OALDN 1
31 30ALHZ0
31 3oALJ62
3,13OALMM3
313041\M7
3130AMW57
31 34GA4A9
3134GWCG9
31 36G4C43
3135GA223
506
529
552
553
554
555
534
535
536
539
541
542
544
546
551
431
530
527
532
02to3t2020
07t29t2020
06t17 t2021
0612212021
06R0t2021
07t28t2021
02t17t2021
02n5t2021
02n412021
0311612021
03t18t2021
03t24t2021
03/30n021
0422n021
0613012021
0212812017
0713012020
0811412020
11t1712020
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
I,000.000.00
'1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00

1.700

0.580

0.900

0.800

0.740

0.870

0.625

0.600

0.625

0.800

0.530

0.875

1.000

1.100

0.650

2.000

0.650

0.650

0.560
1,160
1,336
1,657
1,664
1,307
1,700
1,539
1,547
1,546
1,566
1,295
1,574
1,580
1,603
1,672
89 1,246
1,3s2
'l,447
3,009,270.00
1,963,820.00
'1,974,640.00
'1,969,260.00
'I,970,960.00
2,954,070.00
980,650.00
980,880.00
1,963,440.00
1,973,020.00
979,920.00
988,440.00
1,979,960.00
994,640.00
1,973,000.00
3,013,800.00
989,870.00
1,967,980.00
1,959,820.00
34,587,440.00
485,000.00
493,925.00
295,959.00
1,274,A84.00
64,374,940.37
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00- 1,ooo,ooo.oo
2,000,000.00
3,000,000.00
1,000,718.7'l
2,000,000.00
2,000,000_00
35,000,718.71
485,000.00
503,595.17
300,000.00
1,288,595.17
64,737,188.27

1.677

0.572

0.888

0.789

0.730

0.858

0.616

0.592

0.616

0.789
o.523

0.863

0.986

1.085

0.967

1.973
o.621

0.641
o.552
02t03t2025
07t29t2025
06t15t2026
0612212026
06t30t2025
07t2812026
02t17t2026
o2n512026
02t24t2026
0311612026
06t18t2025
0312412026
0313012026
04t22n026
0613012026
0212812022
0413012025
oa/14t2025
1111712025
35,000,000.00
485,000.00
500,000.00
300,000.00
1,285,000.00
54,683,112.28

0.940 1,359
Miscellaneous Securities - Coupon
1 397028N3
255651 KY6
63877NMM6
capistrano school district
Dixon CA Unified School Dist
Natomas CA Sch Dist AA lnsured
Subtotal and Average
458
537
531
o1t16t2018
02t18t2021
1010112020

2.450
o.672
1 .100

2.786

0.395

1.085
0 't2t01t2021
974 08t01t2024
1,339 0AUn025

1.456 692

1.1s9 1,059
Portfolio CITY
AP
PM (PRF_Pt\42) 7.3.0Run Dale: 01 DS|2O22 - 17 :59
185

INDIAN WELLS 2015 A Bonds
Portfolio Management
Portfolio Summary
November 30,2021
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA.922'!O
(760)346-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnYestments
Total Earnings
Current Year
Average Daily Balance
Effective of Retum
Kevin
Reporting period 11 lO1 12021 -1 1l3Ol2O21
Par illartet
Value
't _00

1.00 Portfolio

1.00 100.00

1.00 {00.00%
Book
Vtlue
olo ol Days to
hturity
YTM
360 Equiv.

0.000

0.000
365 Equiv.

0.000

0.000
Portfolio 154
CP
PM (PRF_PMl) 7.3.0
ReportVer 7.3.6.1
Value
't.00

1.00 November 30 Month Endins
Term
1 0.00
{.00

0.00%
RunD e:o2n7nt?2-@27 No fiscal year history available
186

2015 A Bonds
Portfolio Management
Portfolio Details - lnvestments
November 30,2021
Purchaee
Date ParValue
Stated
BookValue Rare Fitch

1.00 1.00
YTil Dayrto
365 llatutitv
Page I
ilaturity
DtiecustPlnveetment#lsSuer
Money Market Swsep/Checking Account
SYS27 27 2015 A Reserve
SYS22 22 UBC Cost Of lssuance Escrow
SuHotal and Average
Total and Average
Average
Balance
L00
L00
oal31no21
07nlPO20

1.00 0.00

1.00 0,00

0.000
0_000
ilarket Value

1.00 0.00
r.00

1.00 1.00

1.00 0,000

0.000
I
Portfolio 15A
CP
PM (PRF_PM2) 7.3.0RunDale: O2N7l2t2. - @:27
Report Ver 7.3.6.1187

l:l- ttr1d..{-iINDIAN\]i WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
2016 A Bonds
Portfolio Management
Portfolio Summary
November 30,2021
Par ilarket
Vrlue

1.00 r.00
olo of
Portfolio

1.00 100.00
r.00 100.00%
Book
Valua
Days to
tulaturw
YTiI
350 Equiv.

0.000

0.000
365 Equiv.
0_000

0.000
Portfolio 16A
CP
PM (PRF_PMl) 7_3.0
ReportVer 7.3.6.1
Value
'1.00
r.00
November 30 llllonth Ending
Term
1 Current Year
Average Daily Balance
Effective Rate of Retum
Kevin McCarthy, Agency Treasurer
Reporting period 11 l0l 12021 -1ll30l2021

0.00 1.00

0.00%
Run Oa''e: O2n7l2o22 - @:29 No fiscal year history available 188

CUSIP lnvestment #
lUoney ilarket Srveep/Checking Account
SYS28
SYS33 2
Subtotal and Average
Total and Average
2016 A Bonds
Portfolio Management
Portfolio Details - lnvestments
November 30,2021
Purchase
Dele ParValue

1.00 1.00
07nli2020
07n1no20

0.00 1_00

0.00 't _00

0.00 1.00
Page I
Stated YTM lrays to Uatudty
BOOkValue F,*. Fitch 365 lraturitu n.L

0.000

0.000
r.00 0.000
r.00 0.000 1
Portfolio 16A
CP
PM (PRF_PM2) 7.3.0
lssuer
UBC Cost Of lssuance EscrEw
Union Bank Reserve Account
Average
R.l.n.6

1.00 1.00
lllarket Value

1.00 1.00
RunOed'e: O2n7Dg22 - @:29
Report Ver. 7.3.6.1189

-T*r
tl*SiINDIAN TJ) WELLS

CALIFORNIA
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA9221O
(760)346-2489
2020 A Bonds
Portfolio Management
Portfolio Summary
November 30,2021
Par Market
Velue

1.00 1.00

1.00 100.00
t.00 ,t00.000/o
Book
Value
olo of
Portfolio
Days to
ilatudty
YTi'
360 Equiv.

0.000

0.000
YTII
365 Equiv.
0_000

0.000
Portfolio 20A
CP
PM (PRF_PMl) 7.3.0
Report Ver 7.3.6.1
Investments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Balance
of Return
Kevin Agency
Reporting perlod 11 IOl 12021 -11l30l202l
Value

1.00 1.00
November 30 Month Ending
Term

0.00 r.00

0.00%
Run Datat O2DTDOD - E.#No fiscal year history available 190

2O2O A Bonds
Portfolio Management
Portfolio Details - Investments
November 30,2021
Purchase
Date ParValue
Stated
Bookvalue Rate Fltch

0.00 1.00

1.00 1.00
Page I
CUSIP lnvestment #
Money ilarket $reep/Checking Account
sYsl
sYs2 2
Subtotal and Average
Total and Average
laauer
2020 A Bonds COI
2020 A Bonds Reserve
Average
Balancs

1.00 r.00
07n\PO20
07n1no20
YTU Daysto
355 taturitv

0.000

0.000

0.000

0.000
taturity
Dete
Portfolio 20A
CP
PM (PRF_PM2) 7.3.0
Merl(et Value

0.00 1.00

1.00 1,00

0.00 '1.00

1.00 r,00
Run Date: 02,/07/2@2 - 09:38
Report Ver. 7.3.6.1191

i4t
d* rr/INDIAN\]) WELLS City of lndian Wells
44-950 Eldorado Drive
lndian \A/ells C492210
(760)346-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earninos
201 4, 201 5, 201 6, 2020 Series
Portfolio Management
Portfolio Summary
November 30,2021
Par Market
Valua

9.69 9.69

9.69 100_00

9.69 100.00%
Book
Valua
%ot
Portfolio
Dayr to
illaturity
YTII
350 Equiv.

0.000

0.000
YTif
365 Equiv.

0.000

0.000
Portfolio 144
CP
PM (PRF_PM't) 7.3.0
Report Ver 7.3.6.1
Value

9.69 9.69
November 30 lUlonth Endinq
Tarm
Current Year
Average Daily Balance
Effective ol Return
Reporting pefiod 1'l lO1 12021 -111301202'l

0.00 9.69

0.00%
RunDate:O2n7Pg2. -@:25 No fiscal year history available 192

2O1 4, 201 5, 2016, 2020 Series
Portfolio Management
Portfolio Details - lnvestments
November 30,2021
Purchaae
Date ParValue
Shted
BookValue Rrie

1.00 0.03

0.00 8.66

0.00 9169

9.69 Page I
YTM ltays to Maturtty
Fitch 365 ilaturitv Daa

0.000

0.000

0.000

0.000

0.000

0.000

0.000 I
Portfolio 14A
CP
PM (PRF_PM2) 7.3.0
sYs28
sYs26
sYs25
sYs27
SYS24
CUSIP lnvestment #
Money l[arket Sweep/Checking Account
2A
26 25
27 1
Subtotal and Average
Total and Average
lssuer
20144 Bonds Reserve
All Bond Series Principal
All Bond Series lnbrest
All Bond Series Debt Svc
Cost Of lssuance Escrofl
Average
Balance

9.69 9.69
07t01t2020
07t01t2020
07to1no20
07n1n020
07to1Do20

1.00 0.03

0.00 8.66

0.00 ilartet Value

1.00 0.03

0.00 8.66

0.00 9.69

9.69 9.69

9.69 Run Dale: O2o7PO2. - @'.25
Report Ver. 7.3.6.1193

City of Indian Wells
2/17/2022
44-950 Eldorado Drive,
Indian Wells
File #:033-22 Item #:S.

Indian Wells City Council
Staff Report - Finance February 17, 2022
City Treasurer’s Report for December 2021
RECOMMENDED ACTIONS:

Council RECEIVES and FILES the City Treasurer’s Report for December 2021.

DISCUSSION:

Attached are the monthly cash balance and investment reports for the month of December 2021.

Investments reflected in this report are “Marked-to-Market”, meaning the market value of City’s investments is updated monthly. This method provides a clear depiction of the value of the City’s portfolio subject to the performance of the investment market. The City of Indian Wells continues to maintain prudent fiscal reserves and minimize un-invested cash.

Cash and Investments
As of December 31, 2021:
·The City’s cash and investments totaled $66,132,127.39. ·The City’s portfolio earned a 1.130% rate of return.

Treasurer’s Certification
Compliance - The City Treasurer certifies the City’s cash and investments presented in this Report are in compliance with the City’s investment policy and with legal requirements of State of California Government Code section 53600.

Liquidity - The City Treasurer certifies the City’s portfolio is sufficient to meet its financial obligations for the next six months. The investment portfolio will remain sufficiently liquid to meet all operating requirements, which might be reasonably anticipated. This is accomplished by striving to have securities mature at the same time cash is needed to meet anticipated demands (static liquidity). Additionally, since all possible cash demands cannot be anticipated, the portfolio consists largely of securities with active secondary or resale markets (dynamic liquidity).

Fiscal Prudence
When investing, reinvesting, purchasing, acquiring, exchanging, selling, or managing public funds, a trustee shall act with care, skill, prudence, and diligence under the circumstances then prevailing, including, but not limited to, the general economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity City of Indian Wells Printed on 2/11/2022Page 1 of 2
powered by Legistar™194

File #:033-22 Item #:S.
economic conditions and the anticipated needs of the City, that a prudent person acting in a like capacity and familiarity with those matters would use in the conduct of funds of a like character and with like aims, to safeguard the principal and maintain the liquidity needs of the City.

Background
Staff provides Council with a monthly update to the Treasurer’s Report. The Report presents the City’s cash activity and investment portfolio and provides reconciliation between investment balances and the General Ledger. Specifically, the report provides information on the types of investments, dates of maturities, costs, updated market value of securities, and rates of interest earned in the portfolio.

The City maintains a written investment policy in compliance with legal requirements of Government Code section 53600 and governs the investments made by the City. It is the policy of the City of Indian Wells to invest public funds in a manner that will provide the maximum security with the highest investment return while meeting the daily cash flow demands of the City. The investments purchased by the City are consistent with the City’s investment policy and are allowable under current legislation of the State of California.

The City invests in U.S. treasuries, federal agency securities, medium term corporate notes, municipal bonds, federally insured certificates of deposit, and overnight cash investments. Criteria for selecting investments in order of priority are:
(1) safety, (2) liquidity and (3) yield.

ATTACHMENT:

1. City Treasurer’s Report
City of Indian Wells Printed on 2/11/2022Page 2 of 2
powered by Legistar™195

NET CASH & INVESTMENT SUMMARY DECEMBER 2021
December
202t
December
2020UNRESTRICTED FUNDS

GENERAL FUND
101- GENERAL

TOTAL GENERAL FUND

RESTRICTED FUNDS

SPECIAL REVENUE FUNDS
202 - TRAFFIC SAFETY
203 - PUBLTC SAFETY 1/2 CENT SALES TAX
204 - MEASURE ''A''
209 - F.A.M.D. #1
210 - SCAQMD (VEHTCLE REG.)
211 - AB 3229 COPS FUNDING
214 - GAS TAX 2103 MAINTENANCE
215 - GAS TAX 2105 MAINTENANCE
216 - GAS TAX 2106 CONSTRUCT/MAINT
217 - GAS TAX 2107 MAINTENANCE
218 - GAS TAX 2107.5 ENG./ADMIN
219 - GAS TAX RMRA
228 - EMERG. UPGRADE SERVICES
247 - AB 939 RECYCLING FUND
248 - SOLID WASTE
251 - STREET LIGHTING DISTRICT 2OOO.1
253- INDIAN WELLS VILLAS OPERATIONS
254. MOUNTAIN VIEW VILLAS OPERATIONS
256- HOUSINGAUTHORIW
271 - ELDORADO DRIVE LLMD
272 - MONTECITO/STARDUST LLMD
273 - CASA DORADO LLMD
274 -THE COVE LLMD
275 - SH 111/rWGR (ENTRANCE) LLMD
276 - CLUBIIW LANE LLMD
277 - COLONY LLMD
278 - COLONY COV ESTATES LLMD
279 - DESERT HORIZONS LLMD
280 - MOUNTAIN GATE LLMD
281 - MOUNTAIN GATE ESTATES LLMD
282 - VILLAGIO LLMD
283 - VAIDYA LLMD
284 - CLUB, SOUTH OF 111 LLMD
285 - MONTELENA LLMD
286 - SUNDANCE LLMD
287 - PROVINCE LLMD
288 - PROVINCE DBAD

TOTAL SPECIAL REVENUE FUNDS

CAPITAL PROJECT FUNDS
314 - PARK.IN-LIEU FEES
315 - CITYWIDE PUBLIC IMPROVEMENT FEE
316 - CAPITAL IMPROVEMENT
319 - ART IN PUBLIC PLACES
321 . HIGHWAY 111 CIRCULATION IMP FEE

TOTAL CAPITAL PROJECT FUNDS
$6,270,546.83 $5.2 00,221.77
6,27OF46.83 s,200,22'-.77
9,772.69
18,796.34
I54,233.43
2,167,843.38
t4,0r0.I7
94,618.r7
t8,r72.59
rt,09L.42
8,564.86
10,605.13
1,843.83
284,506.L7
3,476,L03.r0
522,948.34
258,118.96
t3,255.4L
1,388,769.81
2,t66,09L.54
14,554,750.28
53,543.34

0.00 3,729.34
3,159.31
71,930.09
9,480.73
79,0rr.92
58,649.58
58,661.20
93,545.02
52,7L3.4L
247,576.35
36,333.54
24,580.69
59,896.57
7r7.67
77,055.40
593,786.02

0.00 2,8t8.79
49,783.92
2,143,200.40
13,594.47
734,729.47

0.00 0.00

0.00 0.00
1,009.00
I74,026.56
3,700,3L4.49
560,137.80
272,5r4.98
12,115.91
I,392,962.8I
2,L72,632.54
14,454,839.48
55,648.53

0.00 3,84t.45
3,246.39
47,50L.84
8,590.01
67,999.99
58,854.89
60,884.62
88,858.96
49,737.r3
236,442.84
35,433.39
20,62r.30
45,696.38
r,606.07
78,007.22
614,053.10
26,699,465.79

0.00 39,827.00
L,735,347.L3
L86,782.7r

0.70 26,561,704.7L

0.00 92,326.26
8,626,747.76
153,647.2t

0.70 8,872,721.93
10:06 A.M21912022T:\Common\bank\Treasurer's Report\Cash 1 0Dec 2 1 -draft 1,96tp57.54
ATTACHMENT #1
196

CITY OF INDIAN WELLS
NET CASH & INVESTMENT SUMMARY DECEMBER 2021
PAGE 2
RESTRICTED FUNDS (Cont.)

REPLACEMENT FUNDS
326 - BUILDINGS CAPITAL RESERVE
327 - BRIDGES CAPITAL RESERVE
328 - MEDIANS & PARKWAYS CAPITAL RESERVE
329 - STORM DMINS CAPITAL RESERVE
330 . TMFFIC SIGNALS CAPITAL RESERVE
331 - TRAFFIC SIGNALS CAPITAL RESERVE
332 - CITY STREETS CAPITAL RESERVE
333 - CITY VEHICLES CAPITAL RESERVE

TOTAL REPLACEMENT FUNDS

SUCCESSOR AGENCY FUNDS
4s3 - RDA (WHTTEWATER)
456 - RDA OBLIGATION RETIREMENT

TOTAL SUCCESSOR AGENCY FUNDS

ENTERPRISE FUNDS
560 - INDIAN WELLS GOLF RESORT

TOTAL ENTERPRISE FUNDS

INTERNAL SERVICE FUNDS
601 - OPEB BENEFIT FUND

TOTAL INTERNAL SERVICE FUNDS

RESERVE FUNDS
602 - COMPENSATED ABSENCES

TOTAL RESERVE FUNDS

TRUST & AGENCY FUNDS
732 - SPECIAL DEPOSITS

TOTAL TRUST & AGENCY FUNDS

TOTAL ALL FUNDS

FISCAL AGENTS
253 - INDIAN WELLS VILLAS
254 - MOUNTAIN VIEW VILI.AS
453 - UNION BANK OF CALIFORNIA TRUSTEE
560 - INDIAN WELLS GOLF RESORT
601 - PARS SECTION 115 TRUST

TOTAL FISCAL AGENTS

TOTAL ALL FUNDS & FISCAL AGENTS

UNRESTRICTED FUNDS

RESTRICTED FUNDS
448,881.28
930,795.28

17.69 r,478,978.43
970 480.51
3,829r153.19 2F44F87.64
$ 6e,768,012.19 $ 59,641,038.97
December
2021
I,743,602.80
r,792,873.00
r,427,07L.07
720,640.00
592,199.00
540,817.00
19,664,37t.00
124,081.00
December
2020
1,435,767.80
t,723,02I.00
1,37t,L68.07
692,7L0.00
568,899.00
519,368.00
18,900,851.00
1L9,437.00
26,605$54.87
2,392,663.40

0.00 25,331,22'-.87
236,437.96

0.00 2,392$63.4O

0.00 236,437.96

0.00 0.o0
439,309.81

0.00 747,347.63
439,309.81
606,841.00
147,347.63
608,674.00
606,841.OO
963,4L9.76
608,674.00
338,321.36
963,4L9,76
65,938,859.OO
338,321.36
296,651.2367,
252,633.54
479,977.16
9,209.29
735,519.39
867,049.28
6,270F46.83
63,497,465.36
5,2OO,22L.77
64,44O,9L7.IO
$ 69,641,038.87
T:\Common\bank\Treasurer's Report\Cash 1 0D ec 21 -d"afl $12,19
10:06 AM21912022197

T \Common\banruank r66ncilialion ly2M02t12 nPT D€c Sank n€cDac 21 Fot€d 1O:O7 AM Zgl2O22 Reconciliation Report - City Held Cash
Department
Bank ChEking & SweD
I
2 I
6 7
4 I
19 2t
Pacific Wstern Bank - Swtrp **-**1117
Pacific W6tern Bank - Accb. Payable **-**3411
Pacific W6tern Bank - Payrcll **-**1752
Pacific Wgtern Bank - Ambulance **-****7937
Pacific Wstern Bank - Public Funds MI,lA **-****5064
Ljnion Bank of CA - Swtrp Inv6tment ***-**10121
US Bink Money Market - Invstment
Petty Cash
Aqency
CertifiGte of oeposit-American Exp6 Bank 02587CFG0
Certificate of Deposit-American Exprs Centurion 02587DS56 Certifi@te of Deposit-Synchrcny Bank 87164WRD2
Certifi@te of Deposittity National Bank 17801c8R9
Certifi@te of Deposit-Morgan Stanley Eank 61747!1F53
Certificte of Deposit-Allegiance Bank Tqas 01748D8A3
Certificte of Deposit{itiBank NA 17312QH69
Certifiete of Deposit{oldman Sachs Bank 38148PG43
Certificate of Deposit-Sallie Mae 795450N84
Certificate of Deposit-Fi6t National Bank ofAmerica 32110Y1K Certifiate of Deposit-Disover gank 254673U18
Certificate of Deposit-Barclays Bank Delaware 06740KMN4 Certificat€ of D€posit{omenity Capital Bank 20033AM86
Cedificate of Deposit-UsB Bank USA 90348tFF2
Certificate of Deposit-Morgan Stanley Bank 61750ARM3
certificte of Deposit-Menick Bank 5901314x4
Certifi@te of Deposit-RlA Federal Credit Union 749522AL0 CertifiGte of Deposit{apital One gank 14042TAY3
Certifi@te of Deposit-Bankwst 06652CHA2
Certifi@te of Deposit-Wells Fargo Natl Bank W6t 949495AQ8 Certifi6te of Deposit-BMw Bank North America 05580AVX9
Certifr@le of Deposit-Nislet Nation Bank 654062122
Certificate of Deposit-Live Oak Banking Company 5380361D1 Cedificate of Deposit-Alma Bank 0200808X4
Certificate of Deposit-State Eank of India 855285TP8
Certifi@te of D€posit-First Natl Bank of Mccregor TX 32112U01 Grtifi€te of Deposit{ente6tate Bank 15201QDE4
certifi@te of Deposit-Northwgt Bank 66736A8V0
Certifiete of Deposit-Encore Bank 29250M8E4
Certifi@te of Deposit-First Fredom Bank 320279AM9
Certilicte of Deposit-Pacific Wstern Bank 69506YR15
Certifi6te of DeFpsit-gank of Baroda 06053HMS9
Certifi@te of Depcit-Toyota Financial Sgs Bank 89235MKy5 CertifiGte of Deposit{renstate Credit Union 39573L8L1
Certificate of Deposit-Pentagon Federal Credit Union 709521A5 Amazon.com Inc. 023135AW5
JP l4organ Chas 481288487
Wells Fargo 95001D51.J9
Bank of New York Mellon Corp 06406MN7
Montebello CA Pens Oblig AA 612285AE5
JP Morgan Chare Bank NA 46632FRU1
JP Morgan Chas 48128c2Q2
Bank ofAmeri@ MTN 06048W1Y31
Bank ofAmerica MTN 05048wM72
Fed. NaUl lYortgage Asss. 3136G4C43
Fed. Farm Credit Bank 3133E1280
Fed. Farm Credit Bank 313tlGWCG9
Fed. Nafl Mortgage A$ff 3135GA223
Fed. Farm Credit Eank 3130A1351
Fed. Farm Credit Bank 3130A16c4
Fed. Fam Credit Bank 3130A16J8
Fed. Farm Credit Bank 3130ALDN1
Fed. Farm Credit Bank 3130ALHZ0
Fed. Farm Credit Bank 3130AU62
Fed. Farm Credit Bank 3130A1M143
Fed. Farm Credit Bank 3130A1W67
Fed, Farn Credit Bank 3130A14W57
Fed. Farm Crcdit Bank 3133EMH21
Fed. Farm Credit Bank 3133EM167
Fed. Farm Ccdit Bank 3133EMN99
Fed. Farm Credit B€nk 3133EMW73
r,152,U4.32
500,953.26
30,834.90
2,000.00

0.00 0.00

0.00 11,992.47
437
438
441
442
443
445
457
460
463
46 45s
413
48082M
483
445
'185498
499
501
so7
512
513
514
515
516
5t7
518
519
520
521
522
s25
5i|a
550
557
/r8a
489
490
523
524
526
533
538
549
556
431
505
s2,
529
530
532
534
535
s35
539
541
5,42
544
546
551
552
553
554
55s
537
531
Certifi6t6 of DeMlt
Certificate of Deposit-EverBank FL 29975D2N9 250,000.00 250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
24s,000.00
250,000,00
2s0,000,00
250,000.00
248,000.00
250,000.00
2s0,000.00
250,000.00
2s0,000.00
250,000.00
250,000.00
249,000.00
247,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
249,000.00
248,000.00
249,000.00
249,000_00
249,000.00
248,000.00
249,000.00
250,000.00
2s0,000.00
249,000.00
Medlsm Tem Cproorate Not6
989,95s.97
887,114.25
1,000,000.00
1,012,620.33
1,055,903.99
2,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
Fed€ral Agenry I$u6
Fed. Farm Crcdit Bank 3133ELKS2 3,000,000.00
2,000,000.00
2,000,000,00
1,000,701.17
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
MunicifEl Botrds
Dixon CA Unified Sch@l District 255651KY6
Nalomas Cl Sch@l District 53877NMM5
items
Total P@led Cash and Inegtn.nts
Fair Value Incr@s (over cost)
Outstanding Warranb/Wire Transfe6
Oubtanding Payroll Warrants/Wire Transfe6
DeposiE if, Transit
Deposit in Transit
Deposit in Transit
Deposit in Transit
Deposit in Transit
Deposit in Transit
Deposit in Transit
Deposit in Transit
Dep6it in Transit
Credit card in Transit
(576,549.771

0.00 (1,817.24)
(118.00)
(2,560.73)
(81s.00)
(1,s46.82)
(10,288.79)
9,089,s6
395,720.00
$ 6193E 8s9,00
(334.74)
(427.12)
(3,619.74)
Outstanding ltems
Rsnciled Bank Balane
nnn 198

INDIAN WELLS The City of lndian Wells
Portfolio Management
Portfolio Summary
December 31,2021
*,\IIFORNIA
lnvestments
Bank Certificates of Deposit
Managed Pool Accounts - LAIF
Money Market Sweep/Checklng Account
Negotiable CD's
Medium Term Corporate Notes
Federal Agency lssues - Callables
Miscellaneous Securities - Coupon
lnvestments
Total Earnings
Current Year
Average Daily Balance
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760\346-2489

YTM YTM
365 Equiv.360 Equiv.

Par Market
Value
3,050,216.71
8,462,045.84
1,698,434.95
6,341,288.04
1 0,787,666.1 7
34,528,1 80.00
787,599.00
65,655,430.71
Book
Value
2,993,000.00
8,462,045.84
1,698,434.95
6,232,000.00
10,942,462.61
35,000,701.17
803,482.82
%oI
Portfolio Term
Days to
MaturityValue
2,993,000.00
8,462,045.84
1,698,434.95
6,232,000.00
10,893,000.00
35,000,000.00
800,000.00
66,078,480.79
December 31 Month Ending
61,870.23
65,130,842.60

1.12%

4.53 12.80

2.57 9.42

16.55 52.93

1.21 1,826
1 1
1,718
1,686
1,795
1,449
292
1 1
986
1,103
1,338
1,079

2.552

0.209

0.242

1.768

1.778

0.940

0.652
66,132,127.39 100.00% 1,491 1,010 1.114

2.587

0.212

0.245

1.792

1.80?
n ort

0.662
1 .130
Portfolio CITY
AP
PM (PRF_PM1)7.3.0
Report Ver. 7.3.6.1
Rate of Return
cash flow from revenue and maturing investments will be sufficient to cover expenditures for the next six months. All securities are "Marked-to-Market" on a monthly basis.

Director
Reportin g period 12101 12021 -12131 12021
Run Date: 0'1/2612022 - 08:06 No fiscal year history available 199

The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
December 31,2021
Purchase
Date
Stated
BookValue p.ra

Page 1 ends

YTM Days to Maturity
Fitch 360 Maturitv Ileta
CUSIP lnvestment #
Bank Certificates of Deposit
01 748DBA3
02587DS66
02587CFG0
74267Gl/I1
1 73 1 2QH69
1780'1GBR9
29976D2N9
321 1oYLK9
38148PG43
61747MF63
795450N84
87164WRD2
0200808X4
06063HMS9
06652CH42
06740KMN4
LAI
LAI
460
442
441
437
463
445
438
473
464
457
465
443
21 ZJ
lssuer
Allegiance Bank Texas
American Express Centurion
American Express Bank FSB
CIBC Bank USA

CITIBANK NA
City National Bank
Everbank FL
First National Bank of America
Goldman Sachs Bank
Morgan Stanley Bk NA
Sallie Mae
Average
Brlance
3,218,806.45
7,',t32,368.42
1,785,175.10
o21o712018
0512412017
0512412017
03/30t20't7
03129t2018
05130t2017
0312912017
0712012018
0412512018
0111112018
04125t2018
05t26t2017
Par Value
245,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
250,000.00
250,000.00
250,000.00
250,000.00
2,993,000.00
8,462,045.84

0.00 8,462,045.84
1,152,644.32

0.00 500,963.26
30,834.90

0.00 0.00
11,992.47
2,000.00

0.00 1,698,434.95
250,000.00
249,000.00
249,000.00
250,000.00
Market Value
250,965.75
252,147.50
252,147.50
251,202.50
257,510.00
251,940.00
251,220.00
258,1 1 0.96
258,380.00
255,870.00
258,545.00
252,177.50
3,050,215.71
8,462,045.84
U.UIJ
8,462,045.84
1,152,644.32

0.00 500,963.26
30,834.90

0.00 0.00
11,992.47
2,000.00

0.00 1,698,434.95
253,542.50
246,129.03
256,656.75
255,977.50
245,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
248,000.00
250,000.00
250,000.00
250,000.00
250,000.00
2,993,000.00
8,462,045.84

0.00 8,462,045.84
1,152,644.32

0.00 500,963.26
30,834.90

0.00 0.00
11,992.47
2,000.00

0.00 1,698,€4.95
250,000.00
249,000.00
249,000.00
250,000.00

2.600

2.400

2.400

2.200

2.850

2.100

2.250

3.150

3.000

2.650

3.050

2.400

2.564

2.367

2.367

2.170

2.811

2.071

2.219

3.107

2.959

2.614

3.008

0.209

0.230

0.247

0.000

0.247

0.000

0.000

0.000

0.247

0.000

0.000
402
143
143
88 452
150
87 565
479
375
479
145
020712023
0512412022
0512412022
03t30t2022
0312912023
0513112022
03t29t2022
07t20t2023
0412512023
0111112023
04125t2023
0512612022
Managed Pool Accounts - LAIF
SYS21
SYS23
Money Market Sweep/Checking Account
SYSl
SYS6
SYST
SYSS
SYS2
SYS3
SYS4
SYS19
SYS5
Subtotal and Average
Negotiable CD's
Synchrony Bank
Subtotal and Average
Alma Bank
Bank of Baroda
BankWest lnc.

Pacific Western Bank
Pacific Western Bank-Ambulance
Pacific Western-PublicFundsMMA
US Bank Money Market
Pacific Western - Acct Payable
Pacific Western-Payroll
Union Bank-Checking
Petty Cash
WestAmerica Bank

2.552 292
City
Redevelopment
Subtotal and Average
F
F
0710112020
08t31t2021
0710112020
0710112020
0710112020
0710112020
03t31t2020
07122t2020
0712612019
10t24t2018

0.212

0.233

0.250

0.250

0.250

1.400

0.700

2.000

3.250

1.380

0.690

1.973

3.205

0.209 1
1 b
7 I
2 J
4 19

0.242
515
525
501
482
1,182 03t28t2025
1,298 0712212025
937 0712612024
296 1012412022
Portfolio CITY
AP
PM (PRF-PM2) 7.3.0Run Date:01/2612022 - 10:37
Barclays Bank/Delaware
Report Ver. 7.3.6.1200

CUSIP lnvestment #
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
December 31,2021
Purchase
Date
Stated
BookValue D-.a

Page 2 ends

YTM Days to Maturitylssuer

BMW BANK NORTH AMERICA
Capital One Bank USA NA
Centerstate Bank NA
Comenity Capital Bank
Discover Bank

ENCORE BANK
First Freedom Bank
First Natl Bank of Mccregor TX
Greenstate Credit Union
Live Oak Banking Company
Merrick Bank
Mo!'gan Stanley Private Bank
Nicolet National Bank
Northwest Bank
Pacific Western Bank CA CD
Pentagon Federal Credit Union
RIA Federal Credit Union
State Bank of lndia NY, NY CD
Toyoia Financial Sgs Bk
UBS Bank USA
Wells Fargo Natl Bk Wesi
Subtotal and Average
Average
B2lenca
6,232,000.00
03R'v2020
07/18t2019
04R012020
1013012018
1010312018
04130t2020
o413012020
o412812020
0611612021
0313112020
1112012018
11108t2018
0313112020
04R012020
0413012020
0912912021
0612412019
0412912020
o412212021
10t30t2018
o112812020
250,000.00
247,000.00
248,000.00
250,000.00
250,000.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
249,000.00
250,000.00
247,000.00
248,000.00
250,000.00
250,000.00
249,000.00
249,000.00
249,000.00
250,000.00
250,000.00
250,000.00
250,000.00
250,000.00
249,000.00
248,000.00
249,000.00
249,000.00
248,000.00
250,000.00
250,000.00
249,000.00
03R112025
0612612024
0413012025
1013012023
1010312023
0413012024
0413012024
04128t2025
0611612026
03t31t2025
0112012023
1110812022
0313112025
04R0t2025
0413012025
0912912026
1226t2023
a412912025
0412212026
10127t2023
0111712023
Par Value Market Value
254,725.00
256,299.55
250,212.16
263,007.50
261,885.00
251,402.85
251 ,1 1 6.50
252,047.76
246,562.50
253,537.50
257,972.50
256,562.50
253,537.50
250,817.70
250,212.16
244,776.96
258,120.87
253,054.24
246,962.50
263,187.50
252,981.51
6,Ul,28A.O4
1,018,560.00
962,490.00
956,740.00
1,009,180.00
1,029,620.00
893,616.1 7
966,770.00
1,930,260.00
1,022,210.00
998,220.00
Fitch
Negotiable GD's
0558OAVX9
14042rAY3
15201 0DE4
20033AM86
254673U18
29260t\,,lBE4
320278AM9
321 12UDR9
395731811
5380361D4
59013J4X4
6 1 760ARM3
654062J22
66736ABV0
69506YR15
709621AS1
7496224L0
856285TF8
89235MKY6
90348JFF2
94949sAQ8
512
499
518
484
480
520
521
550
514
486
485
513
519
JZZ
557
498
516
548
483
507
489
s49
556
524
488
490
538
516
523

1.550

2.300

1.250

3.450

3.300

1.150

1.100

1.350

0.900

1.400

3.400

3.400

1.400

1.200

1.250

0.900

2.500

1.600

0.900

3.500

1.900

1.529

0.000

1.233

3.403

3.255

1.135

1.086

1.332

0.888

1.382

3.356

3.352
't.382

1.184

1.233

0.888

2.468

1.578

0.888

3.454

1.875
1,185
907
1,215
667
640
850
850
1,213
't,627
1,185
384
311
'1 ,185
1,215
1,215
1,732
724
1,214
1,572
664
381
Medium Term Corporate Notes
023135AW6
06048WM31
06048Wrvr72
06406RAN7
1 667644H3
481 28BA87
48128G202
46632FRU1
612285AE6
95001 D6U9
Amazon.com lnc.

Bank of America MTN A
Bank of America MTN A
Bank of New York Mellon Corp
Chevron Corp
JPMorgan Chase & Co
JPMorgan Chase & Co
JP Morgan Chase Bank NA
Montebello CA Pens Oblig AA
Wells Fargo & Company

2.400

1.250

1.200

1.600

3.191

2.972

0.800

0.700

2.503

2.150
417
1,608
1,671
1,209
539
379
1,517
1,482
1,247
484
1210412018
0512812021
0713012021
0511412020
1112012018
1212112018
0212612021
0112212021
0711712020
0413012020
6,232,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
1,000,000.00
893,000.00
1,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00

1.768 986

3.303

1.233

1.'184

1.190

3.375

3.610

0.789

0.690

0.819

2.959

1.77a 1,103
02122t2023
0512812026
0713012026
04t24t202s
0612412023
0111512023
0212612026
0112212026
06t0112025
0413012023
6,232,000.00
989,965.97
1,000,000.00
1,000,000.00
1,012,620.33
996,858.07
887,114.25
1,000,000.00
2,000,000.00
1,055,903.99
1,000,000.00
Portfolio CITY
AP
PM (PRF_PM2) 7.3.0Run Dale:0112612022 - 10:37
Subtotal and Average 10,942,602.70 1 0,893,000.00 1 0,787,666.17 10,s42,462.61 201

Stated
BookValue p*a

Page 3 ends

YTM Days to Maturity
Fitch 360 Maturitv Defa
CUSIP lssuer
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Farm Credit Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Bank
Fed. Home Loan Mtg Corp
Fed. Home Loan Mtg Corp
Fed. Nat'l Mortgage Assoc
Fed. Nai'l Mortgage Assoc
Subtotal and Average
Total and Average
lnvestment #
The City of lndian Wells
Portfolio Management
Portfolio Details - lnvestments
December 31,2021
Purchase
Date Par Value Market Value
Federal Agency lssues - Callables
3133ELKS2 506
3133E1280 529
3133EMH21 552
3133EM167 553
3133EI'"4N99 554
3133EMW73 555
3130AL3S1 534
3130A16G4 535
3130A16J8 536
3130ALDN1 539
3130ALHZ0 541
3130A1J62 542
3130ALMM3 544
3130A1W67 546
3130AMW57 551
3134GA4A9 431
3134GWCG9 530
3136G4C43 527
3135GA223 532
Average
Balrnce
35,016,3s4.56
803,535.37
65,1 30,842.60
0210312020
0712912020
0611712021
06122t2021
0613012021
07128t2021
0211712021
02125t2021
0212412021
03t16t2021
0311812021
03124t2021
0313012021
0412?/2021
0613012021
02t28t2017
0713012020
08t14t2020
1111712020
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
3,003,510.00
1,958,620.00
1,966,420.00
1,966,400.00
1,967,760.00
2,951,520.00
979,230.00
979,550.00
1,960,780.00
1,967,620.00
978,100.00
987,390.00
1,977,980.00
994,060.00
1,971,580.00
3,008,100.00
988,260.00
1,964,660.00
1,956,640.00
3,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
2,000,000.00
3,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
2,000,000.00
1,000,000.00
1,000,000.00
2,000,000.00
1,000,000.00
2,000,000.00
3,000,000.00
1,000,701.17
2,000,000.00
2,000,000.00
0210312025
0712912025
06115t2026
0612212026
0613012025
0712812026
0211712026
02t25t2026
0212412026
0311612026
0611812025
0312412026
03t30t2026
0412212026
06t30t2026
0212812022
0413012025
08t14t2025
1111712025

1.700

0.580

0.900

0.800

0.740

0.870

0.625

0.600

0.625

0.800

0.530

0.875

1.000

1.100

0.650

2.000

0.650

0.650

0.s60

0.672

1.100

1.677

0.572

0.888

0.789

0.730

0.858

0.616

0.592

0.616

0.789

0.523

0.863

0.986

1.085

0.967

1.973

0.621

0.641

0.552
1,129
1,305
I ,bzo
I,OJJ
1,276
1,669
1,508
I,CtO
1,515
1,535
1,264
1,543
1,549
1,572
1,641
58 1,215
1,321
1,416
Miscellaneous Securities - Coupon
25565 1 KY6
63877NMM6
Dixon CA Unified School Dist
Natomas CA Sch Dist AA lnsured
Subtotal and Average
537
531
o211812021
't010112020
35,000,000.00
500,000.00
300,000.00
800,000.00
66,078,480.79
34,528,180.00
492,540.00
295,059.00
787,599.00
65,655,430.71
35,000,701.1 7
503,482.82
300,000.00
803,482.82
56,132,127.39

0.940 1,338

0.395

1.085

0.652 1,079

1.114 1,010
943 08t0112024
1,308 08/01/2025
Portfolio CITY
AP
PM (PRF_PM2) 7.3.0Run Date:0112612022 - 10:37
202

-_ |'/1-: /
.( i.r/
INDIAN T) WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells C4922'lO
(760)346-2489CALI FOR,NIA
lnYestments
Money Market Sweep/Checking Account
lnvestments
Total Earninqs
Current Year
Average Daily Balance
of Return
Agenry
Reporting period'12101 I2O2'l -12131 12021
2015 A Bonds
Portfolio Management
Portfolio Summary
December 31,2021
Par ilar*et
Value
't.00
r.00

1.00 100.00
r.00 100.00%
Book
Value
o/o ol
Poltfolio
Days to
Matudty 360 Equiv.

0.000

0.000
YTM
365 Equiv.

0.000

0.000
Portfolio 15A
CP
PM (PRF_PM1) 7-3.0
Report Ver 7.3.6.1
Value

1.00 1.00
December 3l Month Ending
Term
'l1

0.00 {.00

0.00%
Run Date: O2n7nO22 - N:6 No fiscal year history available 203

2015 A Bonds
Portfolio Management
Portfolio Details - lnvestments
December 31,2021
Purcha3a
Date ParValue
Page I
Stated YTll Daysto itaturity
Bookvalue Rah Fitch 365 ilafitntv DrteCUSIPlnveStnent # toney tarket Sweep/Checking Account
lssuer
2015 A Reserve
UBC Cost Of lssuance Escrow
Subtotal and Average
Total and Average
sYs27
SYS22
27 22
Average
Balanca

1.00 1.00
oa/3l12021
07to1no20

1.00 0.00

1.00 1.00
tarket Value
'1.00
0_00

1.00 1.00

1.00 0.00

0.000

0.000

1.00 r.00

0.000

0.000 1
Portfolio 15A
CP
PM (PRF_PM2) 7.3.0Run Aade: O2n7 ngz. - @'.55
ReportVer 7.3.6.1204

11ij_.i/
INDIAN il'WELLS
rn'estments Par Market
Value Value

CALIFORNIA
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Avemge Daily Balance
of Return
Reporting period 12101 12021 4?i31 l202'l

1.00 1.00
December 31 Month Ending
2016 A Bonds
Portfolio Management
Portfolio Summary
December 31,2021

1.00 1-00
Book
Value
Vn of
Portfolio Term
Days to
Itaturity
City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489
YTiI YTM
360 Equiv. 365 Equiv.

0.000 0.000
1 0.000 0.000
Portfolio 164
CP
PM (PRF_PMl) 7.3.0
Reporl Ver. 7.3.6.1

1.00 100.00

1.00 100.00%1

0.00 1.00

0.00%
RunDdte: O2D7PO22 - @:fi No fiscal year history available 205

custP lnvestment #lesuer
toney illarket Srveep/Checking Account
SYS28 1 UBC Cost Of lssuance Escront
SYS33 2 Union Bank Reserve Account
Subtotel and Average
Total and Average
Ave]?ge
Brhhe

1.00 1.00
2016 A Bonds
Portfolio Management
Portfolio Details - Investments
December 31,2021
Putchaee
Date ParValue
07to1no20
07to1t2020

1.00 1.00
tarket Value
r.00

1.00 Page I
YTii Daysto ilaturityStated
BookValue 8.6
1,00

1.00 Fitch 365 ll*rrttlv

0.00 1.00

0.00 1.00

0.00 1.00

0.000

0.000

0.000

0.000
1 Portfolio 16A
CP
PM (PRF_PM2) 7.3.0RunDa[e:0AO7f2@2 -@:58
RepodVer 7.3.6.1206

-: r*1(-. .r'INDIAN \ WELLS City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)346-2489CALITORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Daily Balance
of Return
Reporting pefiod 12101 1202'l -1213112021
2020 A Bonds
Portfolio Management
Portfolio Summary
December 31,2021
Par Martet
Value

1.00 1.00

1.00 100.00

1.00 100.00%
Book
Value
olo of
Portfolio
Days to
Maturity
YTM
350 Equiv.

0.000

0.000
YTM
365 Equiv.

0.000

0.000
Portfolio 20A
CP
PM (PRF_PM1) 7.3.0
Report Vsr. 7.3.6.1
Value

1.00 1.00
December 3l Month Ending
Term
11 0.00
't.00

0.00%
Run Da'.e: O2n7 f2g22 - 1O:4'l No fiscal year history available 207

CUSIP lnvestmenl #lssuer
toney tarket SvrEeprGhecking Account
SYSI 1 2020 A Bonds COt
SYS2 2 2020 A Bonds Reserve
Subtotal and Average
Total and Average
Average
Balanm

1.00 1.00
07n112020
oTlo'1t2020
lUarket Value

1.00 1.00
2020 A Bonds
Portfolio Management
Portfolio Details - Investments
December 31,2021
PurEhase
Date ParValue
Steted
BookValue D'k Fitch

Page 1 ends

YTil Days to Maturity
365 llaftrrilw

0.000

0.000

0.000

0.000
Portfolio 20A
CP
PM (PRF_PM2) 7.3.0

0.00 1.00

1.00 r.00

0.00 1.00

0.00 1.00

1.00 1,00
Run Dal€: OUOI f2V2 -'lO:41
Report Ver. 7.3.6.1208

INDIAN LS 201 4, 2015, 201 6, 2020 Series
Portfolio Management
Portfolio Summary
December 31,2021
ELW City of lndian Wells
44-950 Eldorado Drive
lndian Wells CA92210
(760)U6-2489CALIFORNIA
lnvestments
Money Market Sweep/Checking Account
lnvestments
Total Earnings
Current Year
Average Daily Balance
of Return
Agency
Reporting peraod'l2l0'l 12021 -1431 12021
Par llarket
Value

9.69 9.69

9.69 100.00

9.69 100.00%
360 Equiv.

0.000
1 0.000
YTM
365 Equiv.

0.000

0.000
Portfolio 14A
CP
PM (PRF_PMl) 7.3.0
Report Ver. 7.3.6.1
Book
Value
%ot
Portfolio T6rm
Days to
MaturityValue

9.69 9.69
December 3l luonth Ending
1 0.00

9.69 0.00%
RunDane: O2fr7nt22 - @:53 No fiscal year history available 209

Aver"geCUSIP lnvestnant# lsauer Bahnce
llloney tarket Srrreep/Checking Account
2O1 4, 2015, 2016, 2020 Series
Portfolio Management
Portfolio Details - lnvestments
December 31,2021
Purchase
Date ParValue
Page I
llarket Value

1.00 0.03

0.00 8.66

0.00 9.69

9.69 Stated
Bookvalue Rate

9.69 9.69
YTM Daysto
365 Maturitv

0.000

0.000

0.000

0.000

0.000

0.000

0.000
Maturrity
Dete
1 Portfolio 14A
CP
PM (PRF_PM2) 7.3.0
Fitch
sYs28
sYs26
sYs2s
SYS27
sYs24
2014A Bonds Reserve
All Bond Series Principal
All Bond Series lnterest
All Bond Series Debt Svc
Cost Of lssuance Escrw
Subtotal and Average
Total and Average
28 26
25 27
1 07to1t2020
07101t2020
07n\no20
07tuno20
071o112020

1.00 0.03

0.00 8.66

0.00 1.00

0.03 0.00

8.66 0.00

9.69 9.69

9.69 9.69
Run Oate: 02107/2022 - 09:53
Repo,t Ver 7.3.6.1210

← All documents from this meeting