HomeMy WebLinkAbout2023-09-26 FC Regular Meeting Agenda PacketCity of Palm Desert Page 1
FINANCE COMMITTEE
CITY OF PALM DESERT, CALIFORNIA
AGENDA
(HYBRID MEETING)
City Hall, North Wing Conference Room
73-510 Fred Waring Drive
Palm Desert, CA 92260
Pursuant to Assembly Bill 2449, this meeting will be conducted as a hybrid meeting and
there will be in-person access to this location.
•To participate via Zoom, use the following link: https://palmdesert.zoom.us/j/86405972508 or
call (213) 338-8477, Zoom Meeting ID: 864 0597 2508.
•Written public comment may also be submitted to mnance@palmdesert.gov. Emails received
by 4:00 p.m. the day prior to the meeting will be distributed to the Committee. Any
correspondence received during or after the meeting will be distributed to the Committee as
soon as practicable and retained for the official record. Emails will not be read aloud except
as an ADA accommodation.
1.CALL TO ORDER
2.ROLL CALL
3.ELECTION OF CHAIRPERSON AND VICE CHAIRPERSON OF THE FINANCE
COMMITTEE
4.NON-AGENDA PUBLIC COMMENT: This time has been set aside for the public to address
the Finance Committee on issues that are not on the agenda for up to three minutes. Because
the Brown Act does not allow the Committee to act on items not listed on the agenda,
members may briefly respond or refer the matter to staff for a report and recommendation at
a future meeting.
5.CONSENT CALENDAR: All matters listed on the Consent Calendar are considered routine
and may be approved by one motion. The public may comment on any items on the Consent
Agenda within the three-minute time limit. Individual items may be removed by Committee
Members for a separate discussion.
A.APPROVAL OF MINUTES
RECOMMENDATION: Approve the Finance Committee Special Meeting minutes of May
31st, 2023.
Tuesday
September 26, 2023
10:00 a.m.
Regular Meeting
Finance Committee Agenda September 26, 2023
City of Palm Desert Page 2
6.ACTION CALENDAR
A.FINANCE DIRECTOR’S REPORT FOR GENERAL FUND FINANCIAL REPORTS
RECOMMENDATION: Receive and file the General Fund Financial Reports for the year
ending June 30th, 2023, and month ending August 31st, 2023.
B.PARKVIEW OFFICE COMPLEX FINANCIAL REPORTS
RECOMMENDATION: Receive and file the Parkview Office Complex Financial Reports
for the year ending June 30th, 2023, and month ending August 31st, 2023.
C.DESERT WILLOW GOLF RESORT FINANCIAL REPORTS
RECOMMENDATION: Receive and file the Desert Willow Financial Reports for the year
ending June 30th, 2023, and month ending August 31st, 2023.
D.CITY TREASURER’S INVESTMENT REPORTS
RECOMMENDATION: Receive and file the City Treasurer’s Investment Reports for the
year ending June 30th, 2023, and month ending August 31st, 2023.
7.INFORMATIONAL REPORTS & COMMENTS
E.FINANCE COMMITTEE MEMBERS
F.CITY STAFF
1.Audit Services RFP (Subcommittee)
G.ATTENDANCE REPORT
8.ADJOURNMENT: The next Regular Meeting will be held on November 28, 2023, at 10:00 a.m.
Finance Committee Agenda September 26, 2023
City of Palm Desert Page 3
AFFIDAVIT OF POSTING
I hereby certify under penalty of perjury under the laws of the State of California that the
foregoing agenda for the Finance Committee was posted on the City Hall bulletin board and
City website not less than 72 hours prior to the meeting.
/s/ Michelle Nance
Recording Secretary
PUBLIC NOTICES
Agenda Related Materials: Pursuant to Government Code §54957.5(b)(2) the designated
office for inspection of records in connection with this meeting is the City’s City Clerk
Department, City Hall, 73-510 Fred Waring Drive, Palm Desert. Staff reports for all agenda
items and documents provided to a majority of the legislative bodies are available for public
inspection at City Hall and on the City’s website at www.palmdesert.gov.
Americans with Disabilities Act: It is the intention of the City of Palm Desert to comply with
the Americans with Disabilities Act (ADA) in all respects. If, as an attendee or a participant at
this meeting, or in meetings on a regular basis, you will need special assistance beyond what
is normally provided, the City will attempt to accommodate you in every reasonable manner.
Please contact the Office of the City Clerk, (760) 346-0611, at least 48 hours prior to the
meeting to inform us of your needs and to determine if accommodation is feasible.
[This page has intentionally been left blank.]
City of Palm Desert Page 1
FINANCE COMMITTEE
CITY OF PALM DESERT, CALIFORNIA
MINUTES
Click HERE to review the meeting audio.
Click HERE to access the meeting agenda packet.
1.CALL TO ORDER
A Special Meeting of the Finance Committee was called to order by Chair Leo on
Wednesday, May 31, 2023, at 1:00 p.m., in the North Wing Conference Room, City Hall,
located at 73-510 Fred Waring Drive, Palm Desert, California.
2.ROLL CALL
Present: Committee Members Carlos Garcia, Kathleen Kelly, Faith Messenger, Jake
Wuest, and Chair Robert Leo.
Absent: Committee Members Karen Alexander and Karina Quintanilla.
Liaisons: Derek White and Anthony Hernandez of Desert Willow Golf Resort.
City Staff
Present: Veronica Chavez, Director of Finance; John Ramont, Deputy Director of Finance;
Liberty Urban, Deputy Director of Finance; and Michelle Nance, Recording
Secretary.
3.NON-AGENDA PUBLIC COMMENT:
None.
4.CONSENT CALENDAR:
A.APPROVAL OF MINUTES
MOTION BY COMMITTEE MEMBER KELLY, SECOND BY COMMITTEE MEMBER
MESSENGER, CARRIED 5-0, to approve the Finance Committee Regular Meeting
minutes of January 24, 2023.
Wednesday
May 31, 2023
1:00 p.m.
Special Meeting
Item 5A-1
Finance Committee Minutes May 31, 2023
City of Palm Desert Page 2
ALL ACTIONS ARE DRAFT, PENDING APPROVAL OF THE MINUTES
5.ACTION CALENDAR
A.FINANCE DIRECTOR’S REPORTS
Finance Director Chavez presented the General Fund Financial Report for March and
April 2023 and responded to Committee Member inquiries.
MOTION BY COMMITTEE MEMBER WUEST, SECOND BY COMMITTEE MEMBER
GARCIA, CARRIED 5-0, to receive and file the General Fund Financial Report and the
Parkview Office Complex Financial Report for the months of March 2023.
MOTION BY COMMITTEE MEMBER MESSENGER, SECOND BY COMMITTEE
MEMBER WUEST, CARRIED 5-0, to receive and file the General Fund Financial Report
and the Parkview Office Complex Financial Report for the months of April 2023.
B.PARKVIEW OFFICE COMPLEX FINANCIAL REPORTS
Deputy Director Urban presented the Parkview Office Complex Reports for March and
April 2023 and responded to Committee Member inquiries.
MOTION BY COMMITTEE MEMBER GARCIA, SECOND BY COMMITTEE MEMBER
MESSGENGER, CARRIED 5-0, to receive and file the General Fund Financial Report
and the Parkview Office Complex Financial Report for the months of March and
April 2023.
C.DESERT WILLOW GOLF RESORT FINANCIAL REPORTS
Desert Willow Golf Resort General Manager White presented the Desert Willow Golf
Resort Financial Reports for March and April 2023 and responded to Committee Member
inquiries.
MOTION BY COMMITTEE MEMBER WUEST, SECOND BY COMMITTEE MEMBER
GARCIA, CARRIED 5-0, to receive and file the Desert Willow Financial Report for the
months of March and April 2023.
D.CITY TREASURER’S INVESTMENT REPORTS
Finance Director Chavez presented the City Treasurer’s Reports for March and April 2023
and responded to Committee Member inquiries.
MOTION BY COMMITTEE MEMBER MESSENGER, SECOND BY COMMITTEE
MEMBER GARCIA, CARRIED 5-0, to receive and file the City Treasurer’s Investment
Report for the months of March and April 2023.
Item 5A-2
Finance Committee Minutes May 31, 2023
City of Palm Desert Page 3
ALL ACTIONS ARE DRAFT, PENDING APPROVAL OF THE MINUTES
6.INFORMATIONAL REPORTS & COMMENTS
A.FINANCE COMMITTEE MEMBERS
In response to inquiry, Finance Director Chavez and Mayor Kelly explained the purpose
and uses of the special fund accounts and general fund reserves.
Committee Member Wuest commended staff on job well done with all the many changes
occurring in the Finance Department.
Chair Leo encouraged staff to present audit summaries rather than full reports to the
committee.
B.CITY STAFF
Finance Director Chavez noted cancellation of the July meeting.
C.ATTENDANCE REPORT – Report was provided; no action taken on this item.
7.ADJOURNMENT
The Finance Committee adjourned at 1:35 p.m.
Respectfully submitted,
Michelle Nance, Deputy Clerk I
Recording Secretary
ATTEST:
Veronica Chavez, Director of Finance
Staff Liaison
APPROVED BY THE FINANCE COMMITTEE: __/__/2023
Item 5A-3
[This page has intentionally been left blank.]
Monthly Financial Report
June 2023
CITY OF PALM DESERT
OVERVIEW
This report summarizes the City’s
financial performance for the
month ending June 30, 2023.
Financial analysis for this report is
provided for the General Fund
REVENUES TO DATE
As of June 30, 2023,
approximately $82.55M
or 114% of the General
Fund operating budget
revenue has been
received as detailed
below.
GENERAL FUND REVENUE
EXPLAINED
The total CY YTD Actual Revenue is slightly
less than PY Actual due to the $4.9M ARPA
Federal Funds received for lost revenue
related to the pandemic. The reduction to
Cannabis Tax also decreased the transfer in
amount compared to PY YTD.
The total CY YTD Actual Expenditures
exceeded PY Actual by approximately $15M,
and was $14.5M lower than CY budget.
The increased costs in CY are related to
Public Works and Capital Improvement
Projects in various stages of acquisition,
development, or construction during FY
2022/23.
Fire Services for FY 2022/23 increased
dramatically compared to PY. They were
also slightly higher than budget resulting
from County labor negotiations with Cal-
Fire. Staff anticipates this trend to continue
as milestones are reached within the labor
contract, as well as when the new fire station
begins to operate.
GENERAL FUNDSUMMARY
Item 6A- June 1
Monthly Financial Report
June 2023
CITY OF PALM DESERT
Page 2
Timing of expenditures vary throughout the
fiscal year.
Interfund Transfers Out are related to
programs and/or projects that may be funded
by the General Fund such as the Aquatic
Facility, Fire Services, Turf Rebates, Discover
Palm Desert, etc.
EXPENDITURES TO DATE
GENERAL FUND EXPENDITURES
This summary report is derived from
detailed financial information generated by
the City’s Finance Department. If you have
questions or would like additional
information on this report, please contact
the Finance Department via email at
vchavez@palmdesert.gov
PERFORMANCE SUMMARY
Item 6A- June 2
Monthly Financial Report
August 2023
CITY OF PALM DESERT
OVERVIEW
This report summarizes the City’s
financial performance for the
month ending August 31, 2023.
Financial analysis for this report is
provided for the General Fund
REVENUES TO DATE
As of August 31, 2023,
approximately $1.75M
or 2% of the General
Fund operating budget
revenue has been
received as detailed
below.
GENERAL FUND REVENUE
EXPLAINED
The first half of every fiscal year presents a
negative cash flow picture as our primary
revenue sources ramp up for the year for the
following reasons:
Property Tax is received in January/June.
Sales Tax is generally highest in Q4 and Q1.
Transient Occupancy Tax is also at its peak
in Q4 and Q1, as those times are considered
“season” for the desert. CY YTD Actual
reflects a slight decrease compared to PY
Actual and CY Budget. This is on trend with
current economic forecasts.
Budgets are approved as an annual total, so
for the purpose of this report YTD Budget is
calculated by percentage of PY YTD Actual.
General Govt costs include annual insurance
premiums in CY YTD. PY Actual was higher
due to adjustments from the Class and
Comp Study and COLA’s.
Expenditure variances may result from
timing differences in billing.
GENERAL FUNDSUMMARY
Item 6A- August 1
Monthly Financial Report
August 2023
CITY OF PALM DESERT
Page 2
Timing of expenditures vary throughout the
fiscal year.
General Government costs include insurance,
internal departments costs, homelessness
services, audit and contributions.
EXPENDITURES TO DATE
GENERAL FUND EXPENDITURES
This summary report is derived from
detailed financial information generated by
the City’s Finance Department. If you have
questions or would like additional
information on this report, please contact
the Finance Department via email at
vchavez@palmdesert.gov
PERFORMANCE SUMMARY
Item 6A- August 2
City of Palm Desert
Parkview Office Complex
Income Statement
for month and fiscal year to date
June 30, 2023
Fiscal year 2022-2023
June-23 June-23 #%YTD YTD #%
Budget Actual Variance Variance Budget Actual Variance Variance
Revenues*
Rental 62,500$ 111,681$ 49,181$ 178.69%750,000$ 981,637$ 231,637$ 130.88%
Total Revenues 62,500$ 111,681$ 49,181$ 178.69%750,000$ 981,637$ 231,637$ 130.88%
Expenses**
Tenant Improvements [1]11,422$ -$ (11,422)$ 0.00%137,060$ 14,950$ 122,110$ 10.91%
Repairs & Maintenance- Building 2,500$ 18,515$ 16,015$ 740.62%30,000$ 52,568$ (22,568)$ 175.23%
Repairs & Maintenance- Streets 1,667$ 376$ (1,291)$ 22.55%20,000$ 2,255$ 17,745$ 11.28%
Repairs & Maintenance- Other Equip 1,667$ -$ (1,667)$ 0.00%20,000$ -$ 20,000$ 0.00%
CAM Janitorial Services 13,740$ 9,783$ (3,957)$ 71.20%137,400$ 165,429$ (28,029)$ 120.40%
CAM Landscaping Services 2,642$ 4,600$ 1,958$ 174.13%26,417$ 25,300$ 1,117$ 95.77%
CAM Alarm 315$ -$ (315)$ 0.00%3,150$ 4,133$ (983)$ 131.21%
CAM Pest Control 171$ 341$ 171$ 0.00%1,705$ 2,046$ (341)$ 120.00%
CAM Utilities-Gas/Electric [2]1,175$ 6,839$ 5,664$ 582.07%79,100$ 83,200$ (4,100)$ 105.18%
CAM Utilities-Waste Disposal 820$ 1,154$ 334$ 140.69%8,200$ 9,323$ (1,123)$ 113.70%
CAM Utilities-Water 400$ 993$ 593$ 248.32%4,000$ 4,316$ (316)$ 107.90%
CAM Utilities-Telephone 750$ 1,006$ 256$ 134.17%7,500$ 6,276$ 1,224$ 83.68%
Total Expenses 37,267$ 43,608$ (6,341)$ 117.01%474,532$ 369,797$ 104,735$ 77.93%
Operating Income 25,233$ 68,073$ 42,841$ 269.78%275,468$ 611,841$ 336,372$ 222.11%
Equipment Replacement Reserve [3]-$ -$ -$ 0.00%-$ -$ -$ 0.00%
Net Income 25,233$ 68,073$ 42,841$ >100%275,468$ 611,841$ 336,372$ >100%
[1] Tenant improvements are completed at various times throughout the year.
[2] YTD overage in gas/electric covered by additional revenue received from rent increases at new lease signing.
[3] Funds are recorded to the equipment replacement reserve at yearend after the calculation of depreciation.
CAM charges are broken out for Finance Committee reporting purposes, but are all budgeted as "Common Area Maintenance." Budget overages in CAM line
items are often offset by budget savings in other CAM line items.
Note: This schedule does not include rents received into this enterprise fund for other City-owned buildings
**Above expenses include only operational budgets. An additional $1,497,600 and $300,000 are set aside in FY22/23 for capital improvements and transfers, respectively.
PARKVIEW FY23 Fin Committee WkshtReport Jun 2023 Page 1Item 6B-1
City of Palm Desert
Parkview Office Complex
Income Statement
for month and fiscal year to date
August 31, 2023
Fiscal year 2023-2024
August-23 August-23 #%YTD YTD #%
Budget Actual Variance Variance Budget Actual Variance Variance
Revenues*
Rental 62,500$ 109,168$ 46,668$ 174.67%125,000$ 216,452$ 91,452$ 173.16%
Total Revenues 62,500$ 109,168$ 46,668$ 174.67%125,000$ 216,452$ 91,452$ 173.16%
Expenses**
Tenant Improvements 10,833$ -$ (10,833)$ 0.00%130,000$ -$ 130,000$ 0.00%
Repairs & Maintenance- Building 2,500$ -$ (2,500)$ 0.00%30,000$ -$ 30,000$ 0.00%
Repairs & Maintenance- Streets 1,667$ -$ (1,667)$ 0.00%20,000$ -$ 20,000$ 0.00%
Repairs & Maintenance- Other Equip 1,667$ -$ (1,667)$ 0.00%20,000$ -$ 20,000$ 0.00%
CAM Janitorial Services 13,740$ -$ (13,740)$ 0.00%137,400$ -$ 137,400$ 0.00%
CAM Landscaping Services 2,642$ -$ (2,642)$ 0.00%26,417$ -$ 26,417$ 0.00%
CAM Alarm 315$ -$ (315)$ 0.00%3,150$ -$ 3,150$ 0.00%
CAM Pest Control 171$ -$ (171)$ 0.00%1,705$ -$ 1,705$ 0.00%
CAM Utilities-Gas/Electric [1]1,175$ 11,027$ 9,852$ 938.45%114,100$ 11,027$ 103,073$ 9.66%
CAM Utilities-Waste Disposal 820$ 834$ 14$ 101.66%8,200$ 1,667$ 6,533$ 20.33%
CAM Utilities-Water 400$ 251$ (149)$ 62.66%4,000$ 251$ 3,749$ 6.27%
CAM Utilities-Telephone 750$ 513$ (237)$ 68.44%7,500$ 513$ 6,987$ 6.84%
Total Expenses 36,679$ 12,624$ 24,054$ 34.42%502,472$ 13,458$ 489,014$ 2.68%
Operating Income 25,821$ 96,544$ 70,723$ 373.89%(377,472)$ 202,994$ 580,465$ -53.78%
Equipment Replacement Reserve -$ -$ -$ 0.00%-$ -$ -$ 0.00%
Net Income 25,821$ 96,544$ 70,723$ >100%(377,472)$ 202,994$ 580,465$ >100%
[1] Increase in electric bill due to Summer weather; amount paid includes July's billing.
CAM charges are broken out for Finance Committee reporting purposes, but are all budgeted as "Common Area Maintenance." Budget overages in CAM line
items are often offset by budget savings in other CAM line items.
Note: This schedule does not include rents received into this enterprise fund for other City-owned buildings
*Revenues do not include interest income, which is allocated at fiscal year-end. Several updated lease documents were approved by Council over the November-January
timeframe, which is expected to lead to increased revenues in the second half of the fiscal year.
PARKVIEW FY23-24 Finance Committee WkshtReport Aug 2023 Page 1
Item 6B-2
City of Palm Desert
Parkview Office Complex
Vacancy Rate Schedule by Suite
August 31, 2023
Rentable Square Feet:46,207
Square Feet Occupied:31,330
% Occupied:68%
% Vacant:32%
Suite No.Tenant Square Ft.
10-110 Advantec 1,250
10-113 Lift to Rise 720
10-117 Lift to Rise 1,227
10-120 State of California 1,000
10-123 Lift to Rise 758
10-126 ACT for Multiple Sclerosis 928
10-129 Congressman Ken Calvert 41st District 875
10-132 Anser Advisory 1,345
10-138 Golden Construction 488
10-201 State of California 766
10-212 State of California 1,104
10-220 Lift to Rise 1,240
20-100 State of California 15,233
20-102 State of California 4,396
Total Occupied Suites 31,330 sq/ft
Suite No.Tenant Square Ft.
10-101 Vacant 1,319
10-104 Vacant 1,380
10-118 Vacant -
10-135 Vacant 1,800
10-141 Vacant 421
10-209 Vacant 3,040
10-215 Vacant 5,833
10-219 Vacant 1,084
Total Vacant Suites 14,877 sq/ft
Vacancy Rate Summary
Occupied Suites
Vacant Suites
Item 6B-3
[This page has intentionally been left blank.]
Desert Willow Golf Resort
Standard Summary Income Statement MTD- June 2023
For the Twelve Months Ending June 30, 2023
MTD Revised % of MTD % of
Actual Budget Forecast Prior Year PY
REVENUES
Green Fees & Cart Fees 482,607 407,847 118%384,761 125%
Merchandise 60,539 49,663 122%48,689 124%
Other Pro Shop 15,751 12,900 122%12,900 122%
Range 2,800 1,735 161%1,735 161%
Food & Beverage 328,742 214,414 153%204,204 161%
Academy Merchandise 4,174 4,059 103%4,059 103%
Other Academy 13,429 14,207 95%14,207 95%
Other G&A Income 2,429 13,083 19%13,083 19%
---------------------------------------------------------------------------------------------------------------------------
TOTAL REVENUE 910,470 717,908 127%683,638 133%
---------------------------------------------------------------------------------------------------------------------------
COST OF SALES
Merchandise 28,418 24,831 114%22,230 128%
Academy 3,200 3,166 101%2,735 117%
Food & Beverage 74,051 72,901 102%59,418 125%
---------------------------------------------------------------------------------------------------------------------------
TOTAL COGS 105,668 100,898 105%84,383 125%
---------------------------------------------------------------------------------------------------------------------------
COGS - Merchandise %46.9%50.0%94%45.7%102.8%
COGS - Academy %76.7%78.0%98%67.4%113.7%
COGS - F&B %25.4%34.0%75%33.2%76.4%
PAYROLL
Course and Grounds 193,608 209,089 93%190,081 102%
Carts, Range, Starters, Etc.49,864 47,157 106%42,870 116%
Food and Beverage 242,705 196,960 123%175,857 138%
Pro Shop 70,352 69,713 101%63,375 111%
Clubhouse Services 18,951 18,030 105%16,391 116%
Academy 20,180 17,828 113%16,207 125%
General and Administrative 62,755 63,728 98%61,277 102%
Marketing 41,382 41,821 99%38,724 107%
---------------------------------------------------------------------------------------------------------------------------
TOTAL PAYROLL 699,796 664,326 105%604,781 116%
---------------------------------------------------------------------------------------------------------------------------
OPERATING EXPENSES
Course and Grounds 156,871 177,948 88%161,771 97%
Carts, Range, Starters, Etc.4,832 14,920 32%11,243 43%
Food and Beverage 55,590 46,974 118%44,737 124%
Pro Shop 9,698 25,483 38%6,599 147%
Clubhouse Services 55,133 74,863 74%41,292 134%
Academy 1,695 4,893 35%1,895 89%
General and Administrative 66,866 37,061 180%33,090 202%
Marketing 9,853 9,593 103%5,535 178%
---------------------------------------------------------------------------------------------------------------------------
TOTAL OPERATING EXPENSES 360,537 391,734 92%306,162 118%
---------------------------------------------------------------------------------------------------------------------------
TOTAL EXPENSES 1,166,002 1,156,958 101%995,326 117%
---------------------------------------------------------------------------------------------------------------------------
EBITDA (255,532)(439,050)58%(311,688)82%
------------------------------------------------------------------------------------------------------------FINANCE COMMITTEE FINANCIAL JUNE 2023
Item 6C-1
Desert Willow Golf Resort MTD- June 2023
Standard Summary Income Statement
For the Twelve Months Ending June 30, 2023
MTD Revised % of MTD % of
Actual Budget Forecast Prior Year PY
EBITDA (255,532)(439,050)58%(311,688)82%
---------------------------------------------------------------------------------------------------------------------------
MANAGEMENT FEES (221,667)(221,667)100%(236,383)94%
---------------------------------------------------------------------------------------------------------------------------
FINANCING ACITIVITY
Interest Expense - Debt (20,972)(3,000)699%21,997 -95%
Interest Expense - Leases (7,437)(4,519)165%(2,162)344%
Interest Income 18,683 30 62278%2,091 894%
---------------------------------------------------------------------------------------------------------------------------
TOTAL FINANCING ACTIVITY (9,726)(7,489)130%21,926 -44%
---------------------------------------------------------------------------------------------------------------------------
OTHER INCOME (EXPENSE)
Non-Operating Revenue 137,917 25,200 5.47 25,200 547%
Facility Rent (8,000)(8,000)100%(8,000)100%
Depreciation & Amortization (147,213)(92,710)159%(95,722)154%
Taxes (1,045)21 -4865%810 -129%
---------------------------------------------------------------------------------------------------------------------------
TOTAL OTHER INCOME (EXPENSE)(18,342)(75,489)24%(77,711)24%
---------------------------------------------------------------------------------------------------------------------------
NET INCOME (505,265)(743,694)68%(603,857)84%
========================================================================
Paid Rounds 8,583 3,498 245%6,879 125%
Other Rounds 388 61 637%196 198%
Total Rounds 8,971 3,559 252%7,075 127%
Revenue/Paid Rounds 106 75 141%99 107%
Revenue/Total Rounds 101 74 138%97 105%
Green Fees / Cart Fees per Paid Rounds 56 42 134%56 101%
Green Fees / Cart Fees per Total Rounds 54 41 130%54 99%
F&B Revenue/Total Rounds 37 21 173%29 127%
Merchandise Revenue/Total Rounds 8 9 92%9 93%
FINANCE COMMITTEE FINANCIAL JUNE 2023
Item 6C-2
Desert Willow Golf Resort
Standard Summary Income Statement YTD JUNE 2023
For the Twelve Months Ending June 30, 2023
YTD Revised % of YTD % of Forecast Rolling
Actual Budget Forecast Prior Year PY Budget 12 Months
REVENUES
Green Fees & Cart Fees 9,950,274 9,870,914 101%9,060,713 110%9,870,914 9,950,274
Merchandise 1,189,967 1,167,967 102%1,060,234 112%1,167,967 1,189,967
Other Pro Shop 489,034 478,841 102%482,003 101%478,841 489,034
Range 74,730 72,665 103%77,941 96%72,665 74,730
Food & Beverage 4,875,792 4,744,535 103%3,975,953 123%4,744,535 4,875,792
Academy Merchandise 90,049 85,296 106%64,932 139%85,296 90,049
Other Academy 365,365 356,923 102%323,023 113%356,923 365,365
Other G&A Income 44,230 49,772 89%37,621 118%49,772 44,230
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL REVENUE 17,079,440 16,826,914 102%15,082,421 113%16,826,914 17,079,440
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COST OF SALES
Merchandise 657,772 637,864 103%535,124 123%637,864 657,772
Academy 67,646 68,151 99%48,281 140%68,151 67,646
Food & Beverage 1,342,255 1,375,820 98%1,135,836 118%1,375,820 1,342,255
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL COGS 2,067,673 2,081,835 99%1,719,241 120%2,081,835 2,067,673
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COGS - Merchandise %55.3%54.6%101%50.5%109.5%54.6%653.3%
COGS - Academy %75.1%79.9%94%74.4%101.0%79.9%927.7%
COGS - F&B %30.7%29.0%106%31.5%97.4%29.0%390.4%
PAYROLL
Course and Grounds 2,194,666 2,209,889 99%1,965,215 112%2,209,889 2,194,666
Carts, Range, Starters, Etc.636,221 631,008 101%555,405 115%631,008 636,221
Food and Beverage 2,791,048 2,755,341 101%2,161,803 129%2,755,341 2,791,048
Pro Shop 683,412 676,522 101%630,480 108%676,522 683,412
Clubhouse Services 242,624 242,985 100%213,835 113%242,985 242,624
Academy 348,940 340,366 103%298,976 117%340,366 348,940
General and Administrative 552,579 561,038 98%563,015 98%561,038 552,579
Marketing 301,696 297,298 101%272,983 111%297,298 301,696
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL PAYROLL 7,751,186 7,714,446 100%6,661,711 116%7,714,446 7,751,186
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OPERATING EXPENSES
Course and Grounds 1,942,987 1,865,714 104%1,751,891 111%1,865,714 1,942,987
Carts, Range, Starters, Etc.115,318 115,385 100%98,741 117%115,385 115,318
Food and Beverage 691,563 651,363 106%462,081 150%651,363 691,563
Pro Shop 92,893 102,337 91%55,104 169%102,337 92,893
Clubhouse Services 595,562 587,787 101%538,431 111%587,787 595,562
Academy 36,112 40,708 89%29,109 124%40,708 36,112
General and Administrative 698,417 685,293 102%585,483 119%685,293 698,417
Marketing 96,261 113,892 85%103,663 93%113,892 96,261
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL OPERATING EXPENSES 4,269,113 4,162,481 103%3,624,504 118%4,162,481 4,269,113
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL EXPENSES 14,087,972 13,958,762 101%12,005,456 117%13,958,762 14,087,972
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
EBITDA 2,991,468 2,868,152 104%3,076,966 97%2,868,152 2,991,468
--------------------------------------------------------------------------------------------------------------------------------------------------------
FINANCE COMMITTEE FINANCIAL JUNE 2023
Item 6C-3
Desert Willow Golf Resort YTD JUNE 2023
Standard Summary Income Statement
For the Twelve Months Ending June 30, 2023
Revised
YTD Revised % of YTD % of Forecast Rolling
Actual Budget Forecast Prior Year PY Budget 12 Months
EBITDA 2,991,468 2,868,152 104%3,076,966 97%2,868,152 2,991,468
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MANAGEMENT FEES (459,578)(459,578)100%(465,550)99%( 459,578 ) (459,578)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
FINANCING ACITIVITY
Interest Expense - Debt (54,025)(21,308)254%(22,550)240%( 21,308 ) (54,025)
Interest Expense - Leases (63,231)(54,435)116%(35,371)179%( 54,435 ) (63,231)
Interest Income 118,833 63,743 186%4,858 2446%63,743 118,833
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL FINANCING ACTIVITY 1,576 (12,000)-13%(53,064)-3%( 12,000 ) 1,576
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OTHER INCOME (EXPENSE)
Non-Operating Revenue 213,517 100,800 212%100,800 212%100,800 213,517
Facility Rent (96,000)(96,000)100%(96,000)100%( 96,000 ) (96,000)
Depreciation & Amortization (1,224,975)(1,124,697)109%(1,135,771)108%( 1,124,697 ) (1,224,975)
Taxes (27,227)(23,587)115%(25,471)107%( 23,587 ) (27,227)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TOTAL OTHER INCOME (EXPENSE)(1,134,686)(1,143,484)99%(1,156,442)98%( 1,143,484 ) (1,134,686)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
NET INCOME 1,398,781 1,253,090 112%1,401,911 100%1,253,090 1,398,781
Paid Rounds 96,417 93,602 103%95,843 101%93,602 96,417
Other Rounds 2,153 1,764 122%2,727 79%1,764 2,153
Total Rounds 98,570 95,366 103%98,570 100%95,366 98,570
Revenue/Paid Rounds 177 180 99%157 113%180 177
Revenue/Total Rounds 173 176 98%153 113%176 173
Green Fees / Cart Fees per Paid Rounds 103 105 98%95 109%105 103
Green Fees / Cart Fees per Total Rounds 101 104 98%92 110%104 101
F&B Revenue/Total Rounds 49 50 99%40 123%50 49
Merchandise Revenue/Total Rounds 16 16 99%14 112%16 16
FINANCE COMMITTEE FINANCIAL JUNE 2023
Item 6C-4
Desert Willow Golf Resort
Standard Summary Income Statement MTD - August 2023
For the Two Months Ending August 31, 2023
MTD MTD % of MTD % of
Actual Budget Budget Prior Year PY
REVENUES
Green Fees & Cart Fees 211,546 212,484 100%208,529 101%
Merchandise 29,268 28,195 104%27,642 106%
Other Pro Shop 351,663 309,126 114%303,064 116%
Range 2,280 2,111 108%2,070 110%
Food & Beverage 145,655 124,419 117%121,680 120%
Academy Merchandise 1,205 863 140%846 142%
Other Academy 14,364 10,307 139%10,105 142%
Other G&A Income 8,811 4,000 220%4,000 220%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL REVENUE 764,791 691,506 111%677,937 113%
------------------------- ------------------------------------------------------------------------------------------------------------------
COST OF SALES
Merchandise 16,424 15,391 107%14,469 114%
Academy 1,025 673 152%610 168%
Food & Beverage 38,361 43,705 88%51,942 74%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL COGS 55,811 59,769 93%67,021 83%
------------------------- ------------------------------------------------------------------------------------------------------------------
COGS - Merchandise %56.1%54.6%102.8%52.3%107.2%
COGS - Academy %85.1%78.0%109.1%72.1%118.1%
COGS - F&B %29.3%39.8%73.6%49.1%59.6%
PAYROLL
Course and Grounds 176,939 183,657 96%186,645 95%
Carts, Range, Starters, Etc.41,189 38,670 107%39,463 104%
Food and Beverage 159,584 138,119 116%139,701 114%
Pro Shop 59,520 60,946 98%52,285 114%
Clubhouse Services 20,703 20,754 100%20,932 99%
Academy 9,903 7,994 124%6,960 142%
General and Administrative 45,560 46,070 99%44,438 103%
Marketing 17,915 17,371 103%16,604 108%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL PAYROLL 531,312 513,581 103%507,028 105%
------------------------- ------------------------------------------------------------------------------------------------------------------
OPERATING EXPENSES
Course and Grounds 99,583 133,171 75%128,237 78%
Carts, Range, Starters, Etc.4,703 5,481 86%5,883 80%
Food and Beverage 21,202 25,022 85%27,359 77%
Pro Shop 5,013 5,723 88%5,286 95%
Clubhouse Services 81,716 60,063 136%61,616 133%
Academy 2,336 2,959 79%3,631 64%
General and Administrative 49,582 45,183 110%49,648 100%
Marketing 9,892 12,880 77%6,862 144%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL OPERATING EXPENSES 274,027 290,482 94%288,523 95%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL EXPENSES 861,150 863,833 100%862,572 100%
------------------------- ------------------------------------------------------------------------------------------------------------------
EBITDA (96,359) (172,327)56%(184,635)52%
-------------------- --------------------------------------------------------------------------------------------------------
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-5
Desert Willow Golf Resort
Standard Summary Income Statement MTD - August 2023
For the Two Months Ending August 31, 2023
MTD MTD % of MTD % of
Actual Budget Budget Prior Year PY
EBITDA (96,359) (172,327)56%(184,635)52%
------------------------- ------------------------------------------------------------------------------------------------------------------
MANAGEMENT FEES (22,500)(21,667)104%(22,500)100%
------------------------- ------------------------------------------------------------------------------------------------------------------
FINANCING ACITIVITY
Interest Expense - Debt (3,333)(4,166)80%(2,927)114%
Interest Expense - Leases (7,141)(6,491)110%(272)2624%
Interest Income 19,589 4,420 443%4,367 449%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL FINANCING ACTIVITY 9,115 (6,237)-146%1,168 780%
------------------------- ------------------------------------------------------------------------------------------------------------------
OTHER INCOME (EXPENSE)
Non-Operating Revenue - - - - -
Facility Rent (8,000)(8,000)100%(8,000)100%
Depreciation & Amortization (120,955)(80,082)151%(95,722)126%
Taxes (12)(185)6%(2,550)0%
------------------------- ------------------------------------------------------------------------------------------------------------------
TOTAL OTHER INCOME (EXPENSE)(128,967)(88,267)146%(106,272)121%
------------------------- ------------------------------------------------------------------------------------------------------------------
NET INCOME (238,710) (288,497)83%(312,238)76%
============== ================================================================
Paid Rounds 3,622 3,788 96%3,826 95%
Other Rounds 346 338 102%340 102%
Total Rounds 3,968 4,126 96%4,166 95%
Revenue/Paid Rounds 211 183 116%177 119%
Revenue/Total Rounds 193 168 115%163 118%
Green Fees / Cart Fees per Paid Rounds 58 56 104%55 107%
Green Fees / Cart Fees per Total Rounds 53 51 104%50 107%
F&B Revenue/Total Rounds 37 30 122%29 126%
Merchandise Revenue/Total Rounds 11 9 118%9 121%
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-6
Desert Willow Golf Resort
Standard Summary Income Statement YTD - August 2023
For the Two Months Ending August 31, 2023
YTD YTD % of YTD % of Annual Rolling
Actual Budget Budget Prior Year PY Budget 12 Months
REVENUES
Green Fees & Cart Fees 456,657 527,662 87%519,582 88%9,689,934 9,887,349
Merchandise 60,237 66,356 91%65,055 93%1,024,999 1,185,149
Other Pro Shop 358,190 317,045 113%310,829 115%443,753 536,395
Range 4,300 4,406 98%4,320 100%74,571 74,710
Food & Beverage 251,383 233,973 107%229,312 110%4,542,220 4,897,863
Academy Merchandise 2,131 4,841 44%4,746 45%34,548 87,434
Other Academy 21,691 15,616 139%15,310 142%332,820 371,747
Other G&A Income 8,811 4,000 220%4,000 220%40,529 49,041
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL REVENUE 1,163,400 1,173,899 99%1,153,152 101%16,183,376 17,089,688
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
COST OF SALES
Merchandise 32,686 36,154 90%34,373 95%560,213 656,085
Academy 1,887 3,776 50%3,614 52%26,948 65,920
Food & Beverage 78,161 86,993 90%89,496 87%1,444,466 1,330,920
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL COGS 112,734 126,923 89%127,482 88%2,031,627 2,052,925
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
COGS - Merchandise %54.3%54.5%99.6%52.8%102.7%54.7%656.3%
COGS - Academy %88.6%78.0%113.5%76.1%116.3%78.0%956.7%
COGS - F&B %34.0%40.6%83.8%43.5%78.2%34.3%373.3%
PAYROLL
Course and Grounds 341,693 367,314 93%363,478 94%2,249,711 2,172,881
Carts, Range, Starters, Etc.85,022 77,340 110%81,358 105%636,724 639,885
Food and Beverage 308,120 278,690 111%269,169 114%2,643,163 2,829,999
Pro Shop 112,317 112,454 100%100,694 112%709,181 695,035
Clubhouse Services 39,062 41,507 94%41,657 94%249,025 240,029
Academy 16,779 18,023 93%17,201 98%318,591 348,518
General and Administrative 88,090 92,140 96%89,847 98%583,258 550,822
Marketing 34,480 35,075 98%34,740 99%283,449 301,436
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL PAYROLL 1,025,563 1,022,543 100%998,145 103%7,673,101 7,778,604
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
OPERATING EXPENSES
Course and Grounds 249,881 273,283 91%263,184 95%1,910,494 1,929,684
Carts, Range, Starters, Etc.8,373 11,329 74%11,742 71%101,317 111,949
Food and Beverage 38,081 46,095 83%51,926 73%522,637 677,717
Pro Shop 12,491 8,581 146%7,414 168%97,499 97,970
Clubhouse Services 164,667 125,975 131%124,153 133%603,338 636,076
Academy 5,631 6,332 89%6,717 84%32,457 35,026
General and Administrative 90,291 80,561 112%76,742 118%666,237 711,967
Marketing 13,266 20,681 64%12,852 103%163,985 96,676
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL OPERATING EXPENSES 582,681 572,837 102%554,730 105%4,097,964 4,297,064
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL EXPENSES 1,720,978 1,722,303 100%1,680,358 102%13,802,692 14,128,592
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
EBITDA (557,577) (548,404)102%(527,205)106%2,380,684 2,961,096
-------------------- ---------------------------------------------------------------------------------------------------------------------------- --------------------
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-7
Desert Willow Golf Resort
Standard Summary Income Statement YTD - August 2023
For the Two Months Ending August 31, 2023
YTD YTD % of YTD % of Annual Rolling
Actual Budget Budget Prior Year PY Budget 12 Months
EBITDA (557,577) (548,404)102%(527,205)106%2,380,684 2,961,096
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
MANAGEMENT FEES (45,000) (43,333)104%(44,167)102%(460,000) (460,411)
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
FINANCING ACITIVITY
Interest Expense - Debt (6,667)(8,332)80%(5,597)119%(50,000) (55,095)
Interest Expense - Leases (14,431) (13,116)110%(2,300)627%(70,594) (75,362)
Interest Income 39,240 8,840 444%7,480 525%53,040 150,593
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL FINANCING ACTIVITY 18,143 (12,608)-144%(417)-4349%(67,554)20,136
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
OTHER INCOME (EXPENSE)
Non-Operating Revenue - - - - - 101,100 213,517
Facility Rent (16,000) (16,000)100%(16,000)100%(96,000) (96,000)
Depreciation & Amortization (241,910) (160,164)151%(191,443)126%(1,095,273) (1,275,442)
Taxes (32)(234)13%(2,590)1%(22,856) (24,669)
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
TOTAL OTHER INCOME (EXPENSE)(257,941) (176,398)146%(210,033)123%(1,113,029) (1,182,594)
------------------------- ------------------------------------------------------------------------------------------------------------------------------------------- -------------------------
NET INCOME (842,376) (780,743)108%(781,822)108%740,101 1,338,227
============== ============================================================================== ==============
Paid Rounds 7,753 9,532 81%9,628 81%91,224 94,652
Other Rounds 586 487 120%490 120%2,169 2,133
Total Rounds 8,339 10,019 83%10,118 82%93,393 96,785
Revenue/Paid Rounds 185 123 150%120 154%177 2,119
Revenue/Total Rounds 180 117 154%114 158%173 2,069
Green Fees / Cart Fees per Paid Rounds 108 55 195%54 200%106 1,176
Green Fees / Cart Fees per Total Rounds 106 53 201%51 206%104 1,150
F&B Revenue/Total Rounds 1 23 4%23 4%0 9
Merchandise Revenue/Total Rounds 13 8 154%8 159%11 143
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-8
2018-2019 2019-2020 2020-2021 2021-2022 2022-2023 2023-2024
OPERATIONAL INCOME STATEMENT Actuals Actuals Actuals Actuals Actuals Estimated
Beginning Cash Balance 3,327,774 3,596,022 2,374,599 3,817,067 4,911,680 7,074,899
REVENUES
Green Fees & Cart Fees 7,080,240 5,582,594 7,481,139 9,060,713 9,950,274 9,689,934
Merchandise 809,498 713,947 785,205 1,060,234 1,189,967 1,024,999
Other Pro Shop 501,340 517,703 491,579 482,003 489,034 443,753
Range 43,827 35,476 67,454 77,941 74,730 74,571
Food & Beverage 2,869,768 2,216,719 2,181,902 3,975,953 4,875,792 4,542,220
Academy Merchandise 92,285 76,911 77,263 64,932 90,049 34,548
Other Academy 216,465 173,351 268,967 323,023 365,365 332,820
Other G&A Income 24,542 28,722 14,504 37,621 44,230 40,529
Transfer in from GF - - - - -
TOTAL REVENUE 11,637,965 9,345,423 11,368,013 15,082,421 17,079,440 16,183,376
EXPENDITURES
Cost of Good Sold 1,355,396 1,121,263 1,200,530 1,719,241 2,067,673 2,031,627
Payroll 5,264,339 5,171,186 5,410,712 6,661,711 7,736,206 7,673,101
Operating Expenses 3,086,672 2,954,736 2,918,415 3,624,504 4,251,906 4,097,964
Equipment/Leases 636,885 450,384 469,030 988,548 670,162 867,083
Other Expense 609,758 513,878 557,776 518,614 604,061 603,450
Loan Repayment from City ($1M still outstanding)- - - 500,000 500,000 500,000
Capital Improvement Plan
Firecliff Golf Course Renovation - - - - - 3,500,000
Annual DWGR Capital Replacement Expenditures 658,476 271,100 459,151 414,346 687,227 515,500
Annual Perimeter & DW Drive Expenditures 142,881 182,157 187,417 190,454 195,855 1,500,000
Total CIP 801,357 453,257 646,568 604,801 883,082 5,515,500
TOTAL EXPENDITURES 11,754,407 10,664,704 11,203,031 14,617,418 16,713,090 21,288,725
Net Surplus/(Deficit)(116,442) (1,319,281) 164,982 465,003 366,350 (5,105,349)
Transfer in from Capital Reserve 657,435 367,697 577,065 464,767 883,082 5,000,000
Accrual to Cash Basis Adjustment (272,745) (269,839) 700,421 164,843 913,787
OPERATIONS RESERVE PLAN/ANALYSIS
Ending DW Cash Balance/Reserve 3,596,022 2,374,599 3,817,067 4,911,680 7,074,899 6,969,550
Restricted for Outstanding Operational Loan 2,000,000 2,000,000 2,000,000 1,500,000 1,000,000 1,000,000
90 Day Operations Reserve 2,738,262 2,552,862 2,639,116 3,378,154 3,832,502 3,818,306
Reserve Surplus/(Deficit) *(1,142,240) (2,178,263) (822,049) 33,525 2,242,397 2,151,244
* - Risk to General Fund
*CIP Reserve is currently fully funded by Amenity Fee from TimeShares/Capital Reserve Fund Balance is held by the City.
Desert Willow Golf Resort
Budget and Cash Flow Analysis
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-9
DWGR
Round Mix Analysis
For the Month Ended August 31, 2023
Rounds Dollars
Category 2023/2024 %Budget %Variance 2022/2023 %Variance 2023/2024 %Budget %Variance 2022/2023 %Variance
Public Rack 1,367 38%1,218 32%149 1,230 32%137 90,378$ 43%80,298 38%10,080$ 78,724$ 38%11,654$
Residents 610 17%536 14%74 541 14%69 28,600$ 14%22,914 11%5,686$ 22,465$ 11%6,135$
Outings 295 8%448 12%(153) 453 12%(158) 18,102$ 9%28,988 14%(10,886)$ 28,420$ 14%(10,318)$
Wholesale 503 14%708 19%(205) 715 19%(212) 34,647$ 16%42,618$ 20%(7,971)$ 41,782$ 20%(7,135)$
Loyalty/Special 847 23%878 23%(31) 887 23%(40) 38,469$ 18%37,294$ 18%1,175$ 36,563$ 18%1,906$
Total 3,622 3,788 (166) 3,826 (204) 210,196$ 212,113$ (1,917)$ 207,954$ 2,242$
-4%-5%-1%1%
Comp/Employee 346 338 8 340 6 -$ -$ -$ -$
Total 3,968 4,126 (158) 4,166 (198) 210,196$ 212,113$ (1,917)$ 207,954$ 2,242$
2023/2024 Budget 2022/2023
Public Rack 66$ 66$ 64$
Residents 47$ 43$ 42$
Outings 61$ 65$ 63$
Wholesale 69$ 60$ 58$
Loyalty/Special 45$ 42$ 41$
Total 58.03$ 56.00$ 54.35$
Average Dollars per Round
G:\Finance\Derek White\My Documents\Analytics\ADR Analysis Monthly Reports\2023-2024\ADR analysis 23-24
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-10
DWGR
Round Mix Analysis
For the Two Months Ending August 31, 2023
Rounds Dollars
Category 2023/2024 %Budget %Variance 2022/2023 %Variance 2023/2024 %Budget %Variance 2022/2023 %Variance
Public Rack 2,676 35%2,822 30%(146) 2,850 30%(174) 172,134$ 38%191,067$ 36%(18,933)$ 187,321$ 36%(15,187)$
Residents 1,157 15%1,163 12%(6) 1,175 12%(18) 51,950$ 12%50,235 10%1,715$ 49,250$ 10%2,700$
Outings 1,106 14%1,345 14%(239) 1,359 14%(253) 75,672$ 17%84,218 16%(8,546)$ 82,567$ 16%(6,895)$
Wholesale 1,063 14%1,989 21%(926) 2,009 21%(946) 70,092 16%108,454$ 21%(38,362) 106,327 21%(36,235)
Loyalty/Special 1,751 23%2,213 23%(462) 2,235 23%(484) 78,409$ 17%92,786$ 18%(14,377)$ 90,967$ 18%(12,558)$
Total 7,753 9,532 (1,779) 9,628 (1,875) 448,257$ 526,761$ (78,504)$ 516,432$ (68,175)$
-19%-19%-15%-13%
Comp/Employee 586 487 99 490 96 -$ -$ -$ -$
Total 8,339 10,019 (1,680) 10,118 (1,779) 448,257$ 526,761$ (78,504)$ 516,432$ (68,175)$
2023/2024 Budget 2022/2023
Public Rack 64$ 68$ 66$
Residents 45$ 43$ 42$
Outings 68$ 63$ 61$
Wholesale 66$ 55$ 53$
Loyalty/Special 45$ 42$ 41$
Total 57.82$ 55.26$ 53.64$
Average Dollars per Round
G:\Finance\Derek White\My Documents\Analytics\ADR Analysis Monthly Reports\2023-2024\ADR analysis 23-24
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-11
Desert Willow/PDRFC
Statement of Cash Flows-Combined
Indirect Method Reconciliation
8/31/2023
Cash Flows from Operating Activities
Net Income (Loss)(842,376)
Adjustments to reconcile net loss to
net cash provided by operating activities
Depreciation & Amortization expense 241,910
Bad Debt expense -
Gain on disposal of assets -
(Increase) Decrease in assets
Accounts Receivable 107,858
Due from Employees -
Inventories (4,534)
Prepaid expenses (145,273)
Increase (Decrease) in liabilities
Accounts Payable 218,455
Accrued Liabilities (320,588)
Deferred Revenue 92,076
Interest -
Due to Affiliates 16,000.00
205,904
Net cash flows from operating activities (636,472)
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-12
Desert Willow/PDRFC
Statement of Cash Flows-Combined
Direct Method
8/31/2023
Cash Flows from Operating Activities
Cash Received From Customers 1,775,256
Interest Received 39,240
Other Operating Cash Receipts 0
Cash Paid to Suppliers and Employees (2,429,839)
Interest Paid (21,098)
Taxes Paid (32)
Net cash flows from operating activities (636,473)
Cash Flows from Investing Activities
Contributed Capital -
Purchases of Property and Equipment (561,500)
Proceeds from sale of Property and Equipment -
Net cash flows from investing activities (561,500)
Cash Flows from Financing Activities
Loan proceeds-KSM/CITY -
Principal payments (142,984)
Net cash flows from financing activities (142,984)
Net change in cash (1,340,957)
Cash at beginning of period 7,074,899
Cash at end of period 5,733,942
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-13
DWGR
F&B Revenue Analysis
Year-to-Date Revenue Analysis
8/31/2023
Dining Analysis
2023.2024 2022.2023 Variance %
Dining Covers 3,721 4,725 (1,004) -21%
Dining Revenue 104,419$ 111,526$ (7,107) -6%
Dining - Ave Check 28.06$ 23.60$ 4.46$ 19%
Catering Analysis
2023.2024 2022.2023 Variance %
Catering Covers 919 1,231 (312)$ -25%
Catering Revenue 93,545$ 78,540$ 15,005$ 19%
Catering Ave Check 101.79$ 63.80$ 37.99$ 60%
Outlet Analysis
2023.2024 2022.2023 Variance %
Outlet Rounds 8,333 10,118 (1,785)$ -18%
Outlet Revenue 44,777$ 31,115$ 13,662$ 44%
Outing Ave Check 5.37$ 3.08$ 2.30$ 75%
Total F&B Revenue 242,741$ 221,181$ 21,560$ 10%
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-14
2023.2024 July August
Dining Covers 1,976 1,745
Catering Covers 374 545
2,350 2,290
Dining Revenue 53,982$ 50,437$
Catering Revenue 26,330$ 67,215$
80,312$ 117,652$
Dining - Ave Check 27.32$ 28.90$
Catering - Ave Check 70.40$ 123.33$
Outlet Revenue 22,744$ 22,032$
Rounds 4,371 3,962
$'s per Round 5.20$ 5.56$
2022.2023
Dining Covers 2,493 2,232
Catering Covers 609 622
3,102 2,854
Dining Revenue 58,206$ 53,320$
Catering Revenue 27,779$ 50,761$
85,985$ 104,081$
Dining - Ave Check 23.35$ 23.89$
Catering - Ave Check 45.61$ 81.61$
Outlet Revenue 18,415$ 12,700$
Rounds 5,952 4,166
$'s per Round 3.09$ 3.05$
PDRFC COVER ANALYSIS
FINANCE COMMITTEE MEETING FINANCIAL REPORT
Item 6C-15
[This page has intentionally been left blank.]
City of Palm Desert
Investments Summary
Through June 2023
The City’s investment portfolio is detailed below. Investment transactions were executed in
accordance with the California State Government Code, the City’s Investment Policy and all
bond indentures.
Investment Portfolio:
$ Millions
Beginning Ending
Book Value Purchases & Redemptions & Book Value % of
Asset Class 5/1/2023 Deposits Withdrawals 6/30/2023 Portfolio
Agencies 30.97$ -$ -$ 30.97$ 10%
Corporates 30.00$ -$ -$ 30.00$ 9%
Negotiable CD's -$ -$ -$ -$ 0%
CAMP Pool 157.42$ 1.37$ -$ 158.79$ 49%
LAIF Pool 20.66$ 0.16$ -$ 20.82$ 6%
County Pool 2.50$ -$ -$ 2.50$ 1%
Custodian ®64.26$ 0.48$ -$ 64.74$ 20%
Trustee ®2.95$ -$ -$ 2.95$ 1%
Cash 12.78$ 39.00$ 36.79$ 14.99$ 5%
Total 321.54$ 41.01$ 36.79$ 325.76$ 100%
® = Restricted funds based upon bond indenture terms.
The City Union Bank checking accounts merged with US Bank in May. Additionally, the City opened
new checking accounts with Wells Fargo in May. Cash Deposit and Withdrawal amounts include US
Bank to Wells Frago balance transfers as well as sweep account transfers which earned at a fund
Yield of 4.95% in June. Major changes to the portfolio over the reporting period include California
sales tax of $4.5 M, property taxes of $1.9 M, and Measure A of $.30 M received by the City.
Portfolio Allocations, Maturities and Performance:
59%
22%
10%
10%
Local Govt
Restricted
Custody/Trus…
Corporate
Agency
Investment
Allocation
-
2
4
6
9M 1Y 2Y 3Y 4Y 5Y
Investment
Maturity
0
2
4
6
1-Jan 1-Feb 1-Mar 1-Apr 1-May 1-Jun
Performance - Total Porfolio
City Yield LAIF Yield
1Y T-Bill CAMP
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-1
CITY OF PALM DESERT
Portfolio Management
June 30, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 158,792,423.09 151.09 5.2401158,792,423.09158,792,423.09
FEDERAL AGENCY - COUPON 13,997,213.17 1994.50 0.43983013,465,070.0014,000,000 00
LAIF 20,817,543.64 16.70 3.150120,817,543.6420,817,543.64
FEDERAL AGENCY - CALLABLE 16,984,552.57 2925.47 0.42793016,219,810.0017,000,000 00
TRUSTEE CASH BALANCES 2,948,750.21 10.95 0.28412,948,750.212,948,750 21
MEDIUM-TERM NOTES 29,997,105.92 6509.65 2.9171,11829,188,710.0030,000,000 00
CUSTODIAN PROJECT FUNDS 64,741,624.30 120.83 4.920164,741,624.3064,741,624 30
RIVERSIDE COUNTY POOL 2,504,768.68 10.81 3.86012,504,768.682,504,768.68
310,783,981.58 100.00%Investments 308,678,699.92310,805,109.92 88 197 4.272
Cash
(not included in yield calcula ions)
Passbook/Checking 14,985,060.36 1 0.000114,985,060.3614,985,060 36
325,769,041.94Total Cash and Investments 323,663,760.28325,790,170.28 88 197 4.272
Current Year
June 30
1,087,906.41
Fiscal Year To Date
9,507,939.23 9,507,939.23
Fiscal Year Ending
Average Daily Balance
Effective Rate of Return
327,070,790.49
4.05%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash
to fund city expenditures for the next six months. US Bank Custody Services has provided market value prices for all corporate securities. All balances are bank balances. The "% of Portfolio" calculation
on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio CITY
AP
Reporting period 06/01/2023-06/30/2023
Run Date: 09/11/2023 - 09:45 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-2
YTM/C
365
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CAMP
5.240C.A.M.P. POOL (CITY)13 154,438,584.68 154,438,584.68 5.240154,438,584.68SYS13 1
5.240C.A.M.P. POOL (DESERT WILLOW)12444 4,353,838.41 4,353,838.41 5.2404,353,838.41SYS12444 1
158,792,423.09158,792,423.09158,792,423.09158,133,720.55Subtotal and Average 5.240 1
U.S. BANK / LAIF BOND PROCEEDS
0.203LOCAL AGENCY INVESTMENT FUND12-33-084 0.00 0.00 0.2030.00252026003 1
0.000.000.000.00Subtotal and Average 0.000 0
FEDERAL AGENCY - COUPON
0.505FEDERAL HOME LOAN BANK664 3,000,000.00 2,999,816.54 10/28/20240.50007/28/2021 2,833,650.00 Aaa3130ANAC4 485
0.500FEDERAL HOME LOAN BANK710 5,000,000.00 5,000,000.00 12/08/20230.50011/04/2021 4,830,800.00 Aaa3130APR72 160
0.360FEDERAL HOME LOAN MTG CORP706 3,000,000.00 2,997,952.72 10/16/20230.12510/21/2021 2,893,710.00 Aaa3137EAEY1 107
0.350FEDERAL HOME LOAN MTG CORP707 3,000,000.00 2,999,443.91 09/08/20230.25010/21/2021 2,906,910.00 Aaa3137EAEW5 69
13,997,213.1713,465,070.0014,000,000.0013,996,804.52Subtotal and Average 0.439 199
LAIF
3.150LOCAL AGENCY INVESTMENT FUND12000 20,817,543.64 20,817,543.64 3.15020,817,543.6412000 1
20,817,543.6420,817,543.6420,817,543.6420,660,775.78Subtotal and Average 3.150 1
FEDERAL AGENCY - CALLABLE
0.520FEDERAL FARM CREDIT BANK668 5,000,000.00 4,985,335.03 12/23/20240.32009/14/2021 4,655,800.00 Aaa3133EMLP5 541
0.370FEDERAL FARM CREDIT BANK698 3,000,000.00 2,999,727.50 10/20/20230.34010/20/2021 2,908,920.00 Aaa3133ENBN9 111
0.331FEDERAL FARM CREDIT BANK699 3,000,000.00 2,999,490.04 10/12/20230.27010/19/2021 2,901,330.00 Aaa3133ENAU4 103
0.400FEDERAL HOME LOAN BANK660 3,000,000.00 3,000,000.00 07/29/20240.40007/29/2021 2,854,620.00 Aaa3130AN7K0 394
0.450FEDERAL HOME LOAN BANK708 3,000,000.00 3,000,000.00 11/24/20230.45011/24/2021 2,899,140.00 Aaa3130APMC6 146
16,984,552.5716,219,810.0017,000,000.0016,984,043.41Subtotal and Average 0.427 292
TRUSTEE CASH BALANCES
0.030GOLDMAN SACHS GOVERNMENT FUND382 0.00 0.00 0.0300.00 Aaa252026000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND383 0.00 0.00 0.03007/01/2022 0.00 Aaa252026001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND384 0.00 0.00 0.0300.00 Aaa252026002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND385 0.00 0.00 0.0300.00 Aaa252026003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND386 0.00 0.00 0.0300.00 Aaa252026004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND401 0.00 0.00 0.0300.00 Aaa252026017-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND402 0.00 0.00 0.0300.00 Aaa252026018-G 1
Portfolio CITY
AP
Run Date: 09/11/2023 - 09:45 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-3
YTM/C
365
Page 2
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
5.020GOLDMAN SACHS GOVERNMENT FUND404 27.47 27.47 5.02027.47 Aaa260128000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND405 0.00 0.00 0.03007/01/2022 0.00 Aaa260128001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND407 0.00 0.00 0.03007/01/2022 0.00 Aaa260128002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND408 0.00 0.00 0.03007/01/2022 0.00 Aaa260128003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND409 0.00 0.00 0.03007/01/2022 0.00 Aaa260128004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND410 0.00 0.00 0.0300.00 Aaa260128005-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND412 0.00 0.00 0.0300.00 Aaa260128006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND414 0.00 0.00 0.0300.00 Aaa260128007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND415 0.00 0.00 0.0300.00 Aaa260128008-G 1
5.020GOLDMAN SACHS GOVERNMENT FUND416 143.83 143.83 5.020143.83 Aaa260128009-G 1
5.020GOLDMAN SACHS GOVERNMENT FUND417 853.68 853.68 5.020853.68 Aaa260128010-G 1
5.020GOLDMAN SACHS GOVERNMENT FUND418 165,719.72 165,719.72 5.020165,719.72 Aaa260128011-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND419 0.00 0.00 0.0300.00 Aaa261470000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND420 0.00 0.00 0.0300.00 Aaa261470001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND421 0.00 0.00 0.0300.00 Aaa261470002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND671 43.72 43.7243.72 Aaa263346000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND672 0.50 0.5007/01/2022 0.50 Aaa263346001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND673 0.19 0.190.19 Aaa263346002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND674 874,214.36 874,214.36874,214.36 Aaa263346003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND675 0.00 0.00 0.03007/01/2022 0.00 Aaa263346004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND676 0.94 0.94 0.03007/01/2022 0.94 Aaa263346005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND677 0.00 0.000.00 Aaa263346006-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND678 1.53 1.531.53 Aaa263346007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND679 1.69 1.69 0.03007/01/2022 1.69 Aaa263599000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND680 81.25 81.2507/01/2022 81.25 Aaa263599001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND682 1,416,852.99 1,416,852.991,416,852.99 Aaa263599002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND683 0.00 0.000.00 Aaa263599003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND684 0.00 0.00 0.03007/01/2022 0.00 Aaa269048000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND685 19.62 19.6219.62 Aaa271146000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND687 0.10 0.1007/01/2022 0.10 Aaa271146001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND688 0.03 0.03 0.03007/01/2022 0.03 Aaa271146002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND689 468,407.70 468,407.70468,407.70 Aaa271146003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND690 0.00 0.00 0.03007/01/2022 0.00 Aaa271146004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND691 0.70 0.70 0.03007/01/2022 0.70 Aaa271146005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND692 0.00 0.000.00 Aaa271146006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND693 0.00 0.00 0.03007/01/2022 0.00 Aaa277580000-G 1
Portfolio CITY
AP
Run Date: 09/11/2023 - 09:45 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-4
YTM/C
365
Page 3
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
0.005GOLDMAN SACHS GOVERNMENT FUND744 22,380.19 22,380.19 0.00522,380.19 Aaa263599004 1
2,948,750.212,948,750.212,948,750.212,948,063.13Subtotal and Average 0.284 1
MEDIUM-TERM NOTES
0.450AMAZON.COM INC.662 3,000,000.00 3,000,000.00 05/12/20240.45007/19/2021 2,852,400.00 A023135BW5 316
0.500CATERPILLAR FINANCIAL SERVICES697 3,000,000.00 2,998,687.54 05/17/20240.45010/08/2021 2,841,930.00 A14913R2L0 321
5.250Freddie Mac760 5,000,000.00 5,000,000.00 12/30/20245.25012/30/2022 5,000,000.00 Aaa3134GYAB8 548
6.750GOLDMAN SACHS GOVERNMENT FUND752 5,000,000.00 5,000,000.00 10/29/20276.75010/31/2022 5,000,000.00 A238150APM1 1,581
3.999MORGAN STANLEY747 5,000,000.00 5,000,000.00 07/23/20254.00009/01/2022 5,000,000.00 A16174468C6 753
0.500TOYOTA MOTOR CREDIT CORP658 3,000,000.00 3,000,000.00 06/18/20240.50006/18/2021 2,831,460.00 A89236TJH9 353
0.530TOYOTA MOTOR CREDIT CORP659 3,000,000.00 2,999,135.77 06/18/20240.50007/08/2021 2,831,460.00 A89236TJH9 353
0.525TOYOTA MOTOR CREDIT CORP667 3,000,000.00 2,999,282.61 06/18/20240.50009/14/2021 2,831,460.00 A89236TJH9 353
29,997,105.9229,188,710.0030,000,000.0029,996,979.61Subtotal and Average 2.917 650
CUSTODIAN PROJECT FUNDS
4.920FIRST AMERICAN US TREASURY MMF647 6,008,950.46 6,008,950.46 4.9206,008,950.46 Aaa6736302420-G 1
4.920FIRST AMERICAN US TREASURY MMF648 26,204,708.31 26,204,708.31 4.92026,204,708.31 Aaa6736302430-G 1
4.920FIRST AMERICAN US TREASURY MMF649 12,405,185.02 12,405,185.02 4.92012,405,185.02 Aaa6736302440-G 1
4.920FIRST AMERICAN US TREASURY MMF650 20,122,780.51 20,122,780.51 4.92020,122,780.51 Aaa6736302450-G 1
64,741,624.3064,741,624.3064,741,624.3064,501,303.53Subtotal and Average 4.920 1
RIVERSIDE COUNTY POOL
3.860POOLED INVESTMENT FUND052460 2,504,768.68 2,504,768.68 3.8602,504,768.68 Aaa052460 1
2,504,768.682,504,768.682,504,768.682,504,768.68Subtotal and Average 3.860 1
CUSTODIAN PROJECT FUNDS
0.010GOLDMAN SACHS TREASURY FUND498 0.00 0.00 0.0100.00 Aaa6736302420 1
0.010GOLDMAN SACHS TREASURY FUND499 0.00 0.00 0.0100.00 Aaa6736302430 1
0.010GOLDMAN SACHS TREASURY FUND500 0.00 0.00 0.0100.00 Aaa6736302440 1
0.010GOLDMAN SACHS TREASURY FUND501 0.00 0.00 0.0100.00 Aaa6736302450 1
0.000.000.000.00Subtotal and Average 0.000 0
Portfolio CITY
AP
Run Date: 09/11/2023 - 09:45 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-5
YTM/C
365
Page 4
Par Value Book Value
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
327,070,790.49 310,805,109.92 4.272 88308,678,699.92 310,783,981.58Total and Average
Portfolio CITY
AP
Run Date: 09/11/2023 - 09:45 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-6
YTM/C
365
Page 5
Par Value Book Value
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CUSTODIAN PROJECT FUNDS
0.000CITY OF PALM DESERT753 0.00 0.0010/27/2022 0.00SYS753 1
UNION BANK CHECKING ACCOUNTS
0.000CITY OF PALM DESERT MAIN13016 0.00 0.000.00SYS13016 1
0.000DESERT WILLOW GOLF COURSE13013 0.00 0.0007/01/2022 0.00SYS13013 1
0.000PUBLIC SAFETY CHECKING602 0.00 0.0007/01/2022 0.00SYS602 1
0.000RECREATIONAL FACILITIES CORP13020 0.00 0.0007/01/2022 0.00SYS13020 1
0.000US Bank 1101 10,086,424.15 10,086,424.1505/26/2023 10,086,424.15SYS9121 1
0.000US Bank 1DW102 862,387.05 862,387.0505/26/2023 862,387.05SYS9154 1
0.000US Bank 1PDRFC103 613,463.61 613,463.6105/26/2023 613,463.61SYS9162 1
0.000US Bank 1PUBSAF107 1,136,961.77 1,136,961.7705/26/2023 1,136,961.77SYS4316 1
0.000WELLS FARGO BANKWFDW111 1,257,616.39 1,257,616.3905/24/2023 1,257,616.39 A1SYS6359 1
0.000WELLS FARGO BANKWFMAIN108 231,961.00 231,961.0005/19/2023 231,961.00 A1SYS6391 1
0.000WELLS FARGO BANKWFPDRFC112 796,246.39 796,246.3905/24/2023 796,246.39 A1SYS6342 1
0.00
327,070,790.49 325,790,170.28 4.272 88
1Average Balance
323,663,760.28 325,769,041.94Total Cash and Investments
Portfolio CITY
AP
Run Date: 09/11/2023 - 09:45 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-7
CITY OF PALM DESERT
LONG-TERM LOANS RECEIVABLE
June 30, 2023
11-Sep-23
12:50 PM
SymPro Book Stated
No.Investment Value Maturity Date Interest Rate
1 City Loan to RDA*-$ N/A 0.20%
348 EIP Loan **1,053,000.00$ 09/02/34 7.00%
594 Highlands Utility Undergrounding ***42,270.34$ 09/02/36 5.35%
Assessment District 04-01 Deferred Loan
Footnotes
*On May 17, 2019, the California State Department of Finance (DOF) denied the 1986 City Loan in the principal
amount of $6,000,000 as an enforceable obligation of the Successor Agency of the Palm Desert Redevelopment
Agency. Several attempts have been made to challenge this decision. The DOF, however, continues to maintain
its position and its interpretation of the dissolution law as it relates to the loans.
** EIP balance adjustments made on March 2
and on September 2 of each year.
*** Highlands balance adjustments made on
March 2 and on September 2 of each year.
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-8
PALM DESERT HOUSING AUTHORITY
Portfolio Management
June 30, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 50,910,721.38 198.08 5.240150,910,721.3850,910,721.38
LAIF 998,018.16 11.92 3.3601998,018.16998,018.16
51,908,739.54 100.00%Investments 51,908,739.5451,908,739.54 1 1 5.204
Cash
(not included in yield calculations)
Passbook/Checking 5,164,918.74 1 0.00015,164,918.745,164,918.74
57,073,658.28Total Cash and Investments 57,073,658.2857,073,658.28 1 1 5.204
Current Year
June 30
221,090.67
Average Daily Balance
Effective Rate of Return
56,887,871.97
4.73%
Total Earnings Month Ending
This investment portfolio complies with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash to fund
Housing Authority operations for the next six months. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio HA
AP
Reporting period 06/01/2023-06/30/2023
Run Date: 09/11/2023 - 09:48 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-9
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CAMP
1CA ASSET MANAGEMENT PROGRAM12008 50,910,721.38 50,910,721.38 5.24050,910,721.38SYS12008 5.240
50,910,721.3850,910,721.3850,910,721.3850,699,533.59Subtotal and Average 1 5.240
CUSTODIAN PROJECT FUNDS
1GOLDMAN SACHS TREASURY FUND590 0.00 0.00 0.0100.00 Aaa6736302460 0.010
0.000.000.000.00Subtotal and Average 0 0.000
LAIF
1LOCAL AGENCY INVESTMENT FUND21003 998,018.16 998,018.16 3.360998,018.16SYS21003 3.360
998,018.16998,018.16998,018.16990,502.52Subtotal and Average 1 3.360
CUSTODIAN PROJECT FUNDS
1FIRST AMERICAN US TREASURY MMF597 0.00 0.00 4.86001/01/2021 0.00 Aaa6736302460-G 4.860
0.000.000.000.91Subtotal and Average 0 0.000
56,887,871.97 51,908,739.54 1 5.20451,908,739.54 51,908,739.54Total and Average
Portfolio HA
AP
Run Date: 09/11/2023 - 09:48 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-10
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CHECKING
1HOUSING AUTH CHECKING25015 1,045,814.24 1,045,814.241,045,814.24SYS25015 0.000
1HOUSING AUTH CHECKINGHSG104 3,165.80 3,165.8006/01/2023 3,165.80SYS9204 0.000
1HOUSING AUTH TRUST25016 0.00 0.0007/01/2020 0.00SYS25016 0.000
1WELLS FARGO BANKWFHSG113 3,620,040.20 3,620,040.2006/01/2023 3,620,040.20 A1SYS6375 0.000
1WELLS FARGO BANKWFHSGT 495,898.50 495,898.5006/01/2023 495,898.50 A1SYS6367 0.000
0.00
56,887,871.97 57,073,658.28 1 5.204
1Average Balance
57,073,658.28 57,073,658.28Total Cash and Investments
Portfolio HA
AP
Run Date: 09/11/2023 - 09:48 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-11
RDA SUCCESSOR AGENCY
Portfolio Management
June 30, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
RIVERSIDE COUNTY POOL 340.91 10.00 3.8601340.91340.91
CAMP 5,973.09 10.05 5.24015,973.095,973.09
LAIF 762.35 10.01 3.3601762.35762.35
TRUSTEE CASH BALANCES - MMA 12,467,964.88 199.74 0.000112,467,964.8812,467,964.88
TRUSTEE CASH BALANCES - GF 25,848.53 10.21 5.020125,848.5325,848.53
12,500,889.76 100.00%Investments 12,500,889.7612,500,889.76 1 1 0.013
Cash
(not included in yield calculations)
Passbook/Checking 29,439,853.42 1 0.000129,439,853.4229,439,853.42
41,940,743.18Total Cash and Investments 41,940,743.1841,940,743.18 1 1 0.013
Current Year
June 30
135.00
Average Daily Balance
Effective Rate of Return
49,358,587.00
0.00%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to
fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the
Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio RDAS
AP
Reporting period 06/01/2023-06/30/2023
Run Date: 09/11/2023 - 09:44 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-12
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
RIVERSIDE COUNTY POOL
1POOLED INVESTMENT FUND052470 340.91 340.91 3.86007/01/2020 340.91 Aaa052470 3.860
340.91340.91340.91340.91Subtotal and Average 1 3.860
CAMP
1C.A.M.P. POOL (RDA S.A.)578 5,973.09 5,973.09 5.2405,973.09SYS578 5.240
5,973.095,973.095,973.095,948.31Subtotal and Average 1 5.240
LAIF
1L.A.I.F. (RDA S.A.)604 762.35 762.35 3.36007/01/2020 762.35SYS604 3.360
762.35762.35762.35756.61Subtotal and Average 1 3.360
TRUSTEE CASH BALANCES - MMA
1U.S. BANK MONEY MARKET ACCOUNT830 0.05 0.0507/01/2020 0.05 P-1247394001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT832 0.00 0.00 0.01007/01/2020 0.00 P-1247394003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT833 1.03 1.031.03 P-1247394002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT834 414,240.55 414,240.55414,240.55 P-1247394000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT837 14.42 14.4214.42 P-1236781002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT838 0.00 0.00 0.01007/01/2020 0.00 P-1236781003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT839 7,343,214.39 7,343,214.397,343,214.39 P-1236781000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT842 0.00 0.00 0.01007/01/2020 0.00 P-1253446003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT843 7.66 7.667.66 P-1253446002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT844 2,040,474.27 2,040,474.272,040,474.27 P-1253446000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT845 0.41 0.4107/01/2020 0.41 P-1253446001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT853 2,669,988.69 2,669,988.692,669,988.69 P-1224324000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT855 0.79 0.7907/01/2020 0.79 P-1224324001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT856 22.55 22.5522.55 P-1224324002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT857 0.00 0.00 0.01007/01/2020 0.00 P-1224324003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT881 0.07 0.0709/01/2020 0.07 P-1236781001-U 0.000
12,467,964.8812,467,964.8812,467,964.8812,467,913.70Subtotal and Average 1 0.000
TRUSTEE CASH BALANCES - GF
1GOLDMAN SACHS GOVERNMENT FUND811 25,848.53 25,848.53 5.02025,848.53 Aaa277861000-G 5.020
1GOLDMAN SACHS GOVERNMENT FUND812 0.00 0.00 0.0300.00 Aaa277861001-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND813 0.00 0.00 0.03007/01/2020 0.00 Aaa277861002-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND814 0.00 0.00 0.03007/01/2020 0.00 Aaa277861003-G 0.030
Portfolio RDAS
AP
Run Date: 09/11/2023 - 09:44 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-13
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
25,848.5325,848.5325,848.5325,743.79Subtotal and Average 1 5.020
49,358,587.00 12,500,889.76 1 0.01312,500,889.76 12,500,889.76Total and Average
Portfolio RDAS
AP
Run Date: 09/11/2023 - 09:44 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-14
Days to
Mat./Call
Page 3
Par Value Book Value
Stated
RateMarket Value
June 30, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
UNION BANK CHECKING ACCOUNTS
1RDA SUCCESSOR AGENCY582 0.00 0.000.00SYS582 0.000
1RDA SUCCESSOR AGENCYRDA106 29,439,853.42 29,439,853.4206/01/2023 29,439,853.42SYS4021 0.000
0.00
49,358,587.00 41,940,743.18 1 0.013
1Average Balance
41,940,743.18 41,940,743.18Total Cash and Investments
Portfolio RDAS
AP
Run Date: 09/11/2023 - 09:44 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-15
PALM DESERT RDA SUCCESSOR AGENCY
LONG-TERM LOANS RECEIVABLE
June 30, 2023
11-Sep-23
12:52 PM
.
SymPro Book Stated
No.Investment Value Maturity Date Interest Rate
738 EIP Loan *126,000.00$ 09/02/29 3.00%
Footnotes
*EIP balance adjustments made on March 2
and September 2 of each year.
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-16
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-17
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-18
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-19
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-20
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-21
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-22
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-23
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-24
MALIA M. COHEN
California State Controller
LOCAL AGENCY INVESTMENT FUND
REMITTANCE ADVICE
Agency Name CITY OF PALM DESERT
Account Number
As of 07/14/2023, your Local Agency Investment Fund account has been directly credited
with the interest earned on your deposits for the quarter ending 06/30/2023
Earnings Ratio .00008636172883763
Interest Rate 3 15%
Dollar Day Total $1,877,841,667.91
Quarter End Principal Balance $20,655,369.99
Quarterly Interest Earned $162,173.65
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-25
MALIA M. COHEN
California State Controller
LOCAL AGENCY INVESTMENT FUND
REMITTANCE ADVICE
Agency Name PALM DESERT HOUSING AUTHORITY
Account Number
As of 07/14/2023, your Local Agency Investment Fund account has been directly credited
with the interest earned on your deposits for the quarter ending 06/30/2023
Earnings Ratio .00008636172883763
Interest Rate 3 15%
Dollar Day Total $90,025,963.56
Quarter End Principal Balance $990,243.36
Quarterly Interest Earned $7,774.80
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-26
MALIA M. COHEN
California State Controller
LOCAL AGENCY INVESTMENT FUND
REMITTANCE ADVICE
Agency Name S/A TO THE PALM DESERT
Account Number
As of 07/14/2023, your Local Agency Investment Fund account has been directly credited
with the interest earned on your deposits for the quarter ending 06/30/2023
Earnings Ratio .00008636172883763
Interest Rate 3 15%
Dollar Day Total $68,767.53
Quarter End Principal Balance $756.41
Quarterly Interest Earned $5.94
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-27
Fund Detail Report
Parameters:Query: Fund Detail
County of Riverside Treasurer-Tax Collector
Account Number
Run Date:07-Jul-2023 09:56:05 AM User:Susan
From :
To :
As at :
01-Jun-2023
30-Jun-2023
07-Jul-2023
Balance Calculation Based On:Value Date
Closing BalanceReceiptsInstrumentEntityDeal NoValue Date T/TBank Value Date Peoplesoft Desc.
/p g
Ticket No
Journal Date
external ref t Receipts AmountCR
Payments
Account Name :
Account Number :
City Of Palm Desert
6/1/2023 6/1/2023 $2,504,768.68 OB $2,504,768.68 $0.00
$2,504,768.68 $2,504,768.68 $0.00
Account Name :
Account Number :
RDA Successor Agcy Palm Desert
6/1/2023 6/1/2023 $2,505,109.59 OB $340.91 $0.00
$340.91 $340.91 $0.00
Printed on 7/7/2023 Page 1 of 1End of Report
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-28
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-29
CITY OF PALM DESERT
Portfolio Management
May 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 158,111,006.67 151.05 5.1601158,111,006.67158,111,006.67
FEDERAL AGENCY - COUPON 13,996,367.69 2294.52 0.43983013,465,070.0014,000,000.00
LAIF 20,655,369.99 16.67 2.993120,655,369.9920,655,369.99
FEDERAL AGENCY - CALLABLE 16,983,499.13 3225.48 0.42793016,219,810.0017,000,000.00
TRUSTEE CASH BALANCES 2,948,039.44 10.95 0.28212,948,039.442,948,039.44
MEDIUM-TERM NOTES 29,996,844.59 6809.69 2.9171,11829,188,710.0030,000,000.00
CUSTODIAN PROJECT FUNDS 64,493,016.61 120.83 4.790164,493,016.6164,493,016.61
RIVERSIDE COUNTY POOL 2,504,768.68 10.81 3.72012,504,768.682,504,768.68
309,688,912.80 100.00%
Investments
307,585,791.39309,712,201.39 95 198 4.190
Cash
(not included in yield calculations)
Passbook/Checking 17,425,685.45 1 0.000117,425,685.4517,425,685.45
327,114,598.25Total Cash and Investments 325,011,476.84327,137,886.84 95 198 4.190
Current Year
May 31
1,075,338.14
Fiscal Year To Date
8,420,032.82
Average Daily Balance
Effective Rate of Return
322,926,682.73
3.92%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash
to fund city expenditures for the next six months. Union Bank Custody Services has provided market value prices for all corporate securities. All balances are bank balances. The "% of Portfolio"
calculation on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio CITY
AP
Reporting period 05/01/2023-05/31/2023
Run Date: 09/11/2023 - 16:23 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-30
YTM/C
365
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CAMP
5.160C.A.M.P. POOL (CITY)13 153,775,851.63 153,775,851.63 5.160153,775,851.63SYS13 1
5.160C.A.M.P. POOL (DESERT WILLOW)12444 4,335,155.04 4,335,155.04 5.1604,335,155.04SYS12444 1
158,111,006.67158,111,006.67158,111,006.67157,443,226.55Subtotal and Average 5.160 1
U.S. BANK / LAIF BOND PROCEEDS
0.203LOCAL AGENCY INVESTMENT FUND12-33-084 0.00 0.00 0.2030.00252026003 1
0.000.000.000.00Subtotal and Average 0.000 0
FEDERAL AGENCY - COUPON
0.505FEDERAL HOME LOAN BANK664 3,000,000.00 2,999,805.00 10/28/20240.50007/28/2021 2,833,650.00 Aaa3130ANAC4 515
0.500FEDERAL HOME LOAN BANK710 5,000,000.00 5,000,000.00 12/08/20230.50011/04/2021 4,830,800.00 Aaa3130APR72 190
0.360FEDERAL HOME LOAN MTG CORP706 3,000,000.00 2,997,367.78 10/16/20230.12510/21/2021 2,893,710.00 Aaa3137EAEY1 137
0.350FEDERAL HOME LOAN MTG CORP707 3,000,000.00 2,999,194.91 09/08/20230.25010/21/2021 2,906,910.00 Aaa3137EAEW5 99
13,996,367.6913,465,070.0014,000,000.0013,995,972.24Subtotal and Average 0.439 229
LAIF
2.993LOCAL AGENCY INVESTMENT FUND12000 20,655,369.99 20,655,369.99 2.99320,655,369.9912000 1
20,655,369.9920,655,369.9920,655,369.9920,655,369.99Subtotal and Average 2.993 1
FEDERAL AGENCY - CALLABLE
0.520FEDERAL FARM CREDIT BANK668 5,000,000.00 4,984,508.06 12/23/20240.32009/14/2021 4,655,800.00 Aaa3133EMLP5 571
0.370FEDERAL FARM CREDIT BANK698 3,000,000.00 2,999,652.50 10/20/20230.34010/20/2021 2,908,920.00 Aaa3133ENBN9 141
0.331FEDERAL FARM CREDIT BANK699 3,000,000.00 2,999,338.57 10/12/20230.27010/19/2021 2,901,330.00 Aaa3133ENAU4 133
0.400FEDERAL HOME LOAN BANK660 3,000,000.00 3,000,000.00 07/29/20240.40007/29/2021 2,854,620.00 Aaa3130AN7K0 424
0.450FEDERAL HOME LOAN BANK708 3,000,000.00 3,000,000.00 11/24/20230.45011/24/2021 2,899,140.00 Aaa3130APMC6 176
16,983,499.1316,219,810.0017,000,000.0016,983,006.39Subtotal and Average 0.427 322
TRUSTEE CASH BALANCES
0.030GOLDMAN SACHS GOVERNMENT FUND382 0.00 0.00 0.0300.00 Aaa252026000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND383 0.00 0.00 0.03007/01/2022 0.00 Aaa252026001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND384 0.00 0.00 0.0300.00 Aaa252026002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND385 0.00 0.00 0.0300.00 Aaa252026003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND386 0.00 0.00 0.0300.00 Aaa252026004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND401 0.00 0.00 0.0300.00 Aaa252026017-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND402 0.00 0.00 0.0300.00 Aaa252026018-G 1
Portfolio CITY
AP
Run Date: 09/11/2023 - 16:23 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-31
YTM/C
365
Page 2
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
5.010GOLDMAN SACHS GOVERNMENT FUND404 27.35 27.35 5.01027.35 Aaa260128000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND405 0.00 0.00 0.03007/01/2022 0.00 Aaa260128001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND407 0.00 0.00 0.03007/01/2022 0.00 Aaa260128002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND408 0.00 0.00 0.03007/01/2022 0.00 Aaa260128003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND409 0.00 0.00 0.03007/01/2022 0.00 Aaa260128004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND410 0.00 0.00 0.0300.00 Aaa260128005-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND412 0.00 0.00 0.0300.00 Aaa260128006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND414 0.00 0.00 0.0300.00 Aaa260128007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND415 0.00 0.00 0.0300.00 Aaa260128008-G 1
5.000GOLDMAN SACHS GOVERNMENT FUND416 143.23 143.23 5.000143.23 Aaa260128009-G 1
5.000GOLDMAN SACHS GOVERNMENT FUND417 850.10 850.10 5.000850.10 Aaa260128010-G 1
5.000GOLDMAN SACHS GOVERNMENT FUND418 165,025.07 165,025.07 5.000165,025.07 Aaa260128011-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND419 0.00 0.00 0.0300.00 Aaa261470000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND420 0.00 0.00 0.0300.00 Aaa261470001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND421 0.00 0.00 0.0300.00 Aaa261470002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND671 43.72 43.7243.72 Aaa263346000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND672 0.50 0.5007/01/2022 0.50 Aaa263346001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND673 0.19 0.190.19 Aaa263346002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND674 874,210.65 874,210.65874,210.65 Aaa263346003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND675 0.00 0.00 0.03007/01/2022 0.00 Aaa263346004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND676 0.94 0.94 0.03007/01/2022 0.94 Aaa263346005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND677 0.00 0.000.00 Aaa263346006-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND678 1.53 1.531.53 Aaa263346007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND679 1.69 1.69 0.03007/01/2022 1.69 Aaa263599000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND680 81.25 81.2507/01/2022 81.25 Aaa263599001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND682 1,416,846.97 1,416,846.971,416,846.97 Aaa263599002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND683 0.00 0.000.00 Aaa263599003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND684 0.00 0.00 0.03007/01/2022 0.00 Aaa269048000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND685 19.62 19.6219.62 Aaa271146000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND687 0.10 0.1007/01/2022 0.10 Aaa271146001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND688 0.03 0.03 0.03007/01/2022 0.03 Aaa271146002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND689 468,405.71 468,405.71468,405.71 Aaa271146003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND690 0.00 0.00 0.03007/01/2022 0.00 Aaa271146004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND691 0.70 0.70 0.03007/01/2022 0.70 Aaa271146005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND692 0.00 0.000.00 Aaa271146006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND693 0.00 0.00 0.03007/01/2022 0.00 Aaa277580000-G 1
Portfolio CITY
AP
Run Date: 09/11/2023 - 16:23 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-32
YTM/C
365
Page 3
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
0.005GOLDMAN SACHS GOVERNMENT FUND744 22,380.09 22,380.09 0.00522,380.09 Aaa263599004 1
2,948,039.442,948,039.442,948,039.442,947,403.58Subtotal and Average 0.282 1
MEDIUM-TERM NOTES
0.450AMAZON.COM INC.662 3,000,000.00 3,000,000.00 05/12/20240.45007/19/2021 2,852,400.00 A023135BW5 346
0.500CATERPILLAR FINANCIAL SERVICES697 3,000,000.00 2,998,562.94 05/17/20240.45010/08/2021 2,841,930.00 A14913R2L0 351
5.250Freddie Mac760 5,000,000.00 5,000,000.00 12/30/20245.25012/30/2022 5,000,000.00 Aaa3134GYAB8 578
6.750GOLDMAN SACHS GOVERNMENT FUND752 5,000,000.00 5,000,000.00 10/29/20276.75010/31/2022 5,000,000.00 A238150APM1 1,611
3.999MORGAN STANLEY747 5,000,000.00 5,000,000.00 07/23/20254.00009/01/2022 5,000,000.00 A16174468C6 783
0.500TOYOTA MOTOR CREDIT CORP658 3,000,000.00 3,000,000.00 06/18/20240.50006/18/2021 2,831,460.00 A89236TJH9 383
0.530TOYOTA MOTOR CREDIT CORP659 3,000,000.00 2,999,061.06 06/18/20240.50007/08/2021 2,831,460.00 A89236TJH9 383
0.525TOYOTA MOTOR CREDIT CORP667 3,000,000.00 2,999,220.59 06/18/20240.50009/14/2021 2,831,460.00 A89236TJH9 383
29,996,844.5929,188,710.0030,000,000.0029,996,722.35Subtotal and Average 2.917 680
CUSTODIAN PROJECT FUNDS
4.790FIRST AMERICAN US TREASURY MMF647 5,985,876.10 5,985,876.10 4.7905,985,876.10 Aaa6736302420-G 1
4.790FIRST AMERICAN US TREASURY MMF648 26,104,082.29 26,104,082.29 4.79026,104,082.29 Aaa6736302430-G 1
4.790FIRST AMERICAN US TREASURY MMF649 12,357,549.14 12,357,549.14 4.79012,357,549.14 Aaa6736302440-G 1
4.790FIRST AMERICAN US TREASURY MMF650 20,045,509.08 20,045,509.08 4.79020,045,509.08 Aaa6736302450-G 1
64,493,016.6164,493,016.6164,493,016.6164,266,937.74Subtotal and Average 4.790 1
RIVERSIDE COUNTY POOL
3.720POOLED INVESTMENT FUND052460 2,504,768.68 2,504,768.68 3.7202,504,768.68 Aaa052460 1
2,504,768.682,504,768.682,504,768.682,504,768.68Subtotal and Average 3.720 1
CUSTODIAN PROJECT FUNDS
0.010GOLDMAN SACHS TREASURY FUND498 0.00 0.00 0.0100.00 Aaa6736302420 1
0.010GOLDMAN SACHS TREASURY FUND499 0.00 0.00 0.0100.00 Aaa6736302430 1
0.010GOLDMAN SACHS TREASURY FUND500 0.00 0.00 0.0100.00 Aaa6736302440 1
0.010GOLDMAN SACHS TREASURY FUND501 0.00 0.00 0.0100.00 Aaa6736302450 1
0.000.000.000.00Subtotal and Average 0.000 0
Portfolio CITY
AP
Run Date: 09/11/2023 - 16:23 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-33
YTM/C
365
Page 4
Par Value Book Value
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
322,926,682.73 309,712,201.39 4.190 95307,585,791.39 309,688,912.80Total and Average
Portfolio CITY
AP
Run Date: 09/11/2023 - 16:23 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-34
YTM/C
365
Page 5
Par Value Book Value
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CUSTODIAN PROJECT FUNDS
0.000CITY OF PALM DESERT753 0.00 0.0010/27/2022 0.00SYS753 1
UNION BANK CHECKING ACCOUNTS
0.000CITY OF PALM DESERT MAIN13016 0.00 0.000.00SYS13016 1
0.000DESERT WILLOW GOLF COURSE13013 0.00 0.0007/01/2022 0.00SYS13013 1
0.000PUBLIC SAFETY CHECKING602 0.00 0.0007/01/2022 0.00SYS602 1
0.000RECREATIONAL FACILITIES CORP13020 0.00 0.0007/01/2022 0.00SYS13020 1
0.000US Bank 1101 10,951,975.91 10,951,975.9105/26/2023 10,951,975.91SYS9121 1
0.000US Bank 1DW102 606,588.79 606,588.7905/26/2023 606,588.79SYS9154 1
0.000US Bank 1PDRFC103 1,270,853.42 1,270,853.4205/26/2023 1,270,853.42SYS9162 1
0.000US Bank 1PUBSAF107 1,136,961.77 1,136,961.7705/26/2023 1,136,961.77SYS4316 1
0.000WELLS FARGO BANKWFDW111 1,832,503.91 1,832,503.9105/24/2023 1,832,503.91 A1SYS6359 1
0.000WELLS FARGO BANKWFMAIN108 1,609,650.00 1,609,650.0005/19/2023 1,609,650.00 A1SYS6391 1
0.000WELLS FARGO BANKWFPDRFC112 17,151.65 17,151.6505/24/2023 17,151.65 A1SYS6342 1
0.00
322,926,682.73 327,137,886.84 4.190 95
1Average Balance
325,011,476.84 327,114,598.25Total Cash and Investments
Portfolio CITY
AP
Run Date: 09/11/2023 - 16:23 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-35
CITY OF PALM DESERT
LONG-TERM LOANS RECEIVABLE
May 31, 2023
11-Sep-23
10:07 AM
SymPro Book Stated
No.Investment Value Maturity Date Interest Rate
1 City Loan to RDA*-$ N/A 0.20%
348 EIP Loan **1,053,000.00$ 09/02/34 7.00%
594 Highlands Utility Undergrounding ***42,270.34$ 09/02/36 5.35%
Assessment District 04-01 Deferred Loan
Footnotes
*On May 17, 2019, the California State Department of Finance (DOF) denied the 1986 City Loan in the principal
amount of $6,000,000 as an enforceable obligation of the Successor Agency of the Palm Desert Redevelopment
Agency. Several attempts have been made to challenge this decision. The DOF, however, continues to maintain
its position and its interpretation of the dissolution law as it relates to the loans.
** EIP balance adjustments made on March 2
and on September 2 of each year.
*** Highlands balance adjustments made on
March 2 and on September 2 of each year.
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-36
PALM DESERT HOUSING AUTHORITY
Portfolio Management
May 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 50,692,251.25 198.08 5.160150,692,251.2550,692,251.25
LAIF 990,243.36 11.92 2.9931990,243.36990,243.36
CUSTODIAN PROJECT FUNDS 2.47 10.00 4.86012.472.47
51,682,497.08 100.00%Investments 51,682,497.0851,682,497.08 1 1 5.118
Cash
(not included in yield calculations)
Passbook/Checking 1,045,814.24 1 0.00011,045,814.241,045,814.24
52,728,311.32Total Cash and Investments 52,728,311.3252,728,311.32 1 1 5.118
Current Year
May 31
220,987.33
Average Daily Balance
Effective Rate of Return
55,278,737.04
4.71%
Total Earnings Month Ending
This investment portfolio complies with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash to fund
Housing Authority operations for the next six months. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio HA
AP
Reporting period 05/01/2023-05/31/2023
Run Date: 09/11/2023 - 09:48 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-37
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CAMP
1CA ASSET MANAGEMENT PROGRAM12008 50,692,251.25 50,692,251.25 5.16050,692,251.25SYS12008 5.160
50,692,251.2550,692,251.2550,692,251.2550,478,153.08Subtotal and Average 1 5.160
CUSTODIAN PROJECT FUNDS
1GOLDMAN SACHS TREASURY FUND590 0.00 0.00 0.0100.00 Aaa6736302460 0.010
0.000.000.000.00Subtotal and Average 0 0.000
LAIF
1LOCAL AGENCY INVESTMENT FUND21003 990,243.36 990,243.36 2.993990,243.36SYS21003 2.993
990,243.36990,243.36990,243.36990,243.36Subtotal and Average 1 2.993
CUSTODIAN PROJECT FUNDS
1FIRST AMERICAN US TREASURY MMF597 2.47 2.47 4.86001/01/2021 2.47 Aaa6736302460-G 4.860
2.472.472.472.46Subtotal and Average 1 4.860
55,278,737.04 51,682,497.08 1 5.11851,682,497.08 51,682,497.08Total and Average
Portfolio HA
AP
Run Date: 09/11/2023 - 09:48 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-38
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CHECKING
1HOUSING AUTH CHECKING25015 1,045,814.24 1,045,814.241,045,814.24SYS25015 0.000
1HOUSING AUTH TRUST25016 0.00 0.0007/01/2020 0.00SYS25016 0.000
0.00
55,278,737.04 52,728,311.32 1 5.118
1Average Balance
52,728,311.32 52,728,311.32Total Cash and Investments
Portfolio HA
AP
Run Date: 09/11/2023 - 09:48 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-39
RDA SUCCESSOR AGENCY
Portfolio Management
May 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
RIVERSIDE COUNTY POOL 340.91 10.00 3.7201340.91340.91
CAMP 5,947.46 10.05 5.16015,947.465,947.46
LAIF 756.41 10.01 2.9931756.41756.41
TRUSTEE CASH BALANCES - MMA 12,467,911.94 199.74 0.000112,467,911.9412,467,911.94
TRUSTEE CASH BALANCES - GF 25,740.18 10.21 5.000125,740.1825,740.18
12,500,696.90 100.00%
Investments
12,500,696.9012,500,696.90 1 1 0.013
Cash
(not included in yield calculations)
Passbook/Checking 37,113,677.82 1 0.000137,113,677.8237,113,677.82
49,614,374.72Total Cash and Investments 49,614,374.7249,614,374.72 1 1 0.013
Current Year
May 31
189.93
Average Daily Balance
Effective Rate of Return
41,704,643.51
0.01%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to
fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the
Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio RDAS
AP
Reporting period 05/01/2023-05/31/2023
Run Date: 09/08/2023 - 16:59 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-40
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
RIVERSIDE COUNTY POOL
1POOLED INVESTMENT FUND052470 340.91 340.91 3.72007/01/2020 340.91 Aaa052470 3.720
340.91340.91340.91340.91Subtotal and Average 1 3.720
CAMP
1C.A.M.P. POOL (RDA S.A.)578 5,947.46 5,947.46 5.1605,947.46SYS578 5.160
5,947.465,947.465,947.465,922.34Subtotal and Average 1 5.160
LAIF
1L.A.I.F. (RDA S.A.)604 756.41 756.41 2.99307/01/2020 756.41SYS604 2.993
756.41756.41756.41756.41Subtotal and Average 1 2.993
TRUSTEE CASH BALANCES - MMA
1U.S. BANK MONEY MARKET ACCOUNT830 0.05 0.0507/01/2020 0.05 P-1247394001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT832 0.00 0.00 0.01007/01/2020 0.00 P-1247394003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT833 1.03 1.031.03 P-1247394002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT834 414,238.79 414,238.79414,238.79 P-1247394000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT837 14.42 14.4214.42 P-1236781002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT838 0.00 0.00 0.01007/01/2020 0.00 P-1236781003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT839 7,343,183.21 7,343,183.217,343,183.21 P-1236781000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT842 0.00 0.00 0.01007/01/2020 0.00 P-1253446003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT843 7.66 7.667.66 P-1253446002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT844 2,040,465.61 2,040,465.612,040,465.61 P-1253446000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT845 0.41 0.4107/01/2020 0.41 P-1253446001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT853 2,669,977.35 2,669,977.352,669,977.35 P-1224324000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT855 0.79 0.7907/01/2020 0.79 P-1224324001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT856 22.55 22.5522.55 P-1224324002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT857 0.00 0.00 0.01007/01/2020 0.00 P-1224324003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT881 0.07 0.0709/01/2020 0.07 P-1236781001-U 0.000
12,467,911.9412,467,911.9412,467,911.9412,467,861.59Subtotal and Average 1 0.000
TRUSTEE CASH BALANCES - GF
1GOLDMAN SACHS GOVERNMENT FUND811 25,740.18 25,740.18 5.00025,740.18 Aaa277861000-G 5.000
1GOLDMAN SACHS GOVERNMENT FUND812 0.00 0.00 0.0300.00 Aaa277861001-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND813 0.00 0.00 0.03007/01/2020 0.00 Aaa277861002-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND814 0.00 0.00 0.03007/01/2020 0.00 Aaa277861003-G 0.030
Portfolio RDAS
AP
Run Date: 09/08/2023 - 16:59 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-41
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
25,740.1825,740.1825,740.1825,643.32Subtotal and Average 1 5.000
41,704,643.51 12,500,696.90 1 0.01312,500,696.90 12,500,696.90Total and Average
Portfolio RDAS
AP
Run Date: 09/08/2023 - 16:59 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-42
Days to
Mat./Call
Page 3
Par Value Book Value
Stated
RateMarket Value
May 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
UNION BANK CHECKING ACCOUNTS
1RDA SUCCESSOR AGENCY582 37,113,677.82 37,113,677.8237,113,677.82SYS582 0.000
0.00
41,704,643.51 49,614,374.72 1 0.013
1Average Balance
49,614,374.72 49,614,374.72Total Cash and Investments
Portfolio RDAS
AP
Run Date: 09/08/2023 - 16:59 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-43
PALM DESERT RDA SUCCESSOR AGENCY
LONG-TERM LOANS RECEIVABLE
May 31, 2023
11-Sep-23
10:09 AM
.
SymPro Book Stated
No.Investment Value Maturity Date Interest Rate
738 EIP Loan *126,000.00$ 09/02/29 3.00%
Footnotes
*EIP balance adjustments made on March 2
and September 2 of each year.
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-44
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-45
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-46
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-47
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-48
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-49
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-50
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-51
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-52
6/21/23, 11:10 AM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
June 21, 2023
LAIF Home
PMIA Average Monthly
Yields
CITY OF PALM DESERT
CITY TREASURER
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260 2578
Account Number:
May 2023 Statement
Tran Type Definitions
Account Summary
Total Deposit:0.00 Beginning Balance:20,655,369.99
Total Withdrawal 0 00 Ending Balance 20,655,369.99
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-53
6/21/23, 11:12 AM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
June 21, 2023
LAIF Home
PMIA Average Monthly
Yields
PALM DESERT HOUSING AUTHORITY
CITY TREASURER
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260 2578
Account Number:
May 2023 Statement
Tran Type Definitions
Account Summary
Total Deposit:0.00 Beginning Balance:990,243.36
Total Withdrawal 0 00 Ending Balance 990,243.36
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-54
6/21/23, 11:11 AM LAIF Regular Monthly Statement
https://laifms.treasurer.ca.gov/RegularStatement.aspx 1/1
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
June 21, 2023
LAIF Home
PMIA Average Monthly
Yields
S/A TO THE PALM DESERT REDEVELOPMENT
AGENCY
FINANCE DIRECTOR
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260 2578
Account Number:
May 2023 Statement
Tran Type Definitions
Account Summary
Total Deposit:0.00 Beginning Balance:756.41
Total Withdrawal 0 00 Ending Balance 756.41
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-55
Fund Detail Report
Parameters:Query: Fund Detail
County of Riverside Treasurer-Tax Collector
Account Number:
Run Date:12-Jun-2023 10:58:21 AM User:Susan
From :
To :
As at :
01-May-2023
31-May-2023
12-Jun-2023
Balance Calculation Based On:Value Date
Closing BalanceReceiptsInstrumentEntityDeal NoValue Date T/TBank Value Date Peoplesoft Desc.
/p g
Ticket No
Journal Date
external ref t Receipts AmountCR
Payments
Account Name :
Account Number :
City Of Palm Desert
5/1/2023 5/1/2023 $2,504,768.68 OB $2,504,768.68 $0.00
$2,504,768.68 $2,504,768.68 $0.00
Account Name :
Account Number :
RDA Successor Agcy Palm Desert
5/1/2023 5/1/2023 $2,505,109.59 OB $340.91 $0.00
$340.91 $340.91 $0.00
Printed on 6/12/2023 Page 1 of 1End of Report
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-56
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-57
City of Palm Desert
Investments Summary
July 1st through August 31st, 2023
The City’s investment portfolio is detailed below. Investment transactions were executed in
accordance with the California State Government Code, the City’s Investment Policy and all
bond indentures.
Investment Portfolio:
Book Value Purchases & Redemptions & Book Value % of
Asset Class 7/1/2023 Deposits Withdrawals 8/31/2023 Portfolio
Agencies 30.97$ -$ -$ 30.97$ 10%
Corporates 30.00$ -$ -$ 30.00$ 9%
Negotiable CD's -$ -$ -$ -$ 0%
CAMP Pool 158.79$ 21.52$ 0.75$ 179.56$ 56%
LAIF Pool 20.82$ -$ 20.00$ 0.82$ 0%
County Pool 2.50$ 0.20$ -$ 2.70$ 1%
Custodian ®64.74$ 0.54$ 0.13$ 65.15$ 20%
Trustee ®2.95$ 4.38$ 2.19$ 5.14$ 2%
Cash 14.99$ 112.32$ 121.53$ 5.78$ 2%
Total 325.76$ 138.96$ 144.60$ 320.12$ 100%
® = Restricted funds based upon bond indenture terms.
Key Trends
Cash Deposit and Withdrawal amounts include sweep account transfers which earned at a fund Yield
of 5.21% in August. Major changes to the portfolio include transferring 20M from LAIF to CAMP,
California sales tax of $4.4 M, property taxes of $1.9 M, and Measure A of $.32 M received by the City.
Payments for contract law enforcement 9M, contract fire service 4.4M, annual PERs unfunded liability
payment 2.6M, JPIA insurance payment of 1.6M, and 2.19 in debt services payments.
Portfolio Allocations, Maturities and Performance:
58%
22%
10%
10%
Local Govt
Restricted…
Corporate
Agency
Investment
Allocation
-
2
4
6
8
9M 1Y 2Y 3Y 4Y 5Y
Investment
Maturity
0
2
4
6
1-Mar 1-Apr 1-May 1-Jun 1-Jul 1-Aug
Performance - Total Porfolio
City Yield LAIF Yield
1Y T-Bill CAMP
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-58
CITY OF PALM DESERT
Portfolio Management
July 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 159,509,140.92 151.15 5.3101159,509,140.92159,509,140.92
FEDERAL AGENCY - COUPON 13,998,058.65 1684.49 0.43983013,465,070.0014,000,000.00
LAIF 20,817,543.64 16.68 3.305120,817,543.6420,817,543.64
FEDERAL AGENCY - CALLABLE 16,985,606.01 2615.45 0.42793016,219,810.0017,000,000.00
TRUSTEE CASH BALANCES 2,949,447.61 10.95 0.29612,949,447.612,949,447.61
MEDIUM-TERM NOTES 29,997,367.26 6199.62 2.9171,11829,188,710.0030,000,000.00
CUSTODIAN PROJECT FUNDS 64,873,150.34 120.80 5.090164,873,150.3464,873,150.34
RIVERSIDE COUNTY POOL 2,697,698.66 10.87 3.86012,697,698.662,697,698.66
311,828,013.09 100.00%
Investments
309,720,571.17311,846,981.17 82 196 4.356
Cash
(not included in yield calculations)
Passbook/Checking 9,219,115.40 1 0.00019,219,115.409,219,115.40
321,047,128.49Total Cash and Investments 318,939,686.57321,066,096.57 82 196 4.356
Current Year
July 31
1,230,693.48
Fiscal Year To Date
1,230,693.48
Average Daily Balance
Effective Rate of Return
325,898,332.12
4.45%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash
to fund city expenditures for the next six months. US Bank Custody Services has provided market value prices for all corporate securities. All balances are bank balances. The "% of Portfolio" calculation
on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio CITY
AP
Reporting period 07/01/2023-07/31/2023
Run Date: 09/20/2023 - 12:39 PM (PRF_PM1) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-59
YTM/C
365
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CAMP
5.310C.A.M.P. POOL (CITY)13 155,135,651.23 155,135,651.23 5.310155,135,651.23SYS13 1
5.310C.A.M.P. POOL (DESERT WILLOW)12444 4,373,489.69 4,373,489.69 5.3104,373,489.69SYS12444 1
159,509,140.92159,509,140.92159,509,140.92158,815,543.02Subtotal and Average 5.310 1
U.S. BANK / LAIF BOND PROCEEDS
0.203LOCAL AGENCY INVESTMENT FUND12-33-084 0.00 0.00 0.2030.00252026003 1
0.000.000.000.00Subtotal and Average 0.000 0
FEDERAL AGENCY - COUPON
0.505FEDERAL HOME LOAN BANK664 3,000,000.00 2,999,828.08 10/28/20240.50007/28/2021 2,833,650.00 Aaa3130ANAC4 454
0.500FEDERAL HOME LOAN BANK710 5,000,000.00 5,000,000.00 12/08/20230.50011/04/2021 4,830,800.00 Aaa3130APR72 129
0.360FEDERAL HOME LOAN MTG CORP706 3,000,000.00 2,998,537.66 10/16/20230.12510/21/2021 2,893,710.00 Aaa3137EAEY1 76
0.350FEDERAL HOME LOAN MTG CORP707 3,000,000.00 2,999,692.91 09/08/20230.25010/21/2021 2,906,910.00 Aaa3137EAEW5 38
13,998,058.6513,465,070.0014,000,000.0013,997,663.18Subtotal and Average 0.439 168
LAIF
3.305LOCAL AGENCY INVESTMENT FUND12000 20,817,543.64 20,817,543.64 3.30520,817,543.6412000 1
20,817,543.6420,817,543.6420,817,543.6420,817,543.64Subtotal and Average 3.305 1
FEDERAL AGENCY - CALLABLE
0.520FEDERAL FARM CREDIT BANK668 5,000,000.00 4,986,162.00 12/23/20240.32009/14/2021 4,655,800.00 Aaa3133EMLP5 510
0.370FEDERAL FARM CREDIT BANK698 3,000,000.00 2,999,802.50 10/20/20230.34010/20/2021 2,908,920.00 Aaa3133ENBN9 80
0.331FEDERAL FARM CREDIT BANK699 3,000,000.00 2,999,641.51 10/12/20230.27010/19/2021 2,901,330.00 Aaa3133ENAU4 72
0.400FEDERAL HOME LOAN BANK660 3,000,000.00 3,000,000.00 07/29/20240.40007/29/2021 2,854,620.00 Aaa3130AN7K0 363
0.450FEDERAL HOME LOAN BANK708 3,000,000.00 3,000,000.00 11/24/20230.45011/24/2021 2,899,140.00 Aaa3130APMC6 115
16,985,606.0116,219,810.0017,000,000.0016,985,113.28Subtotal and Average 0.427 261
TRUSTEE CASH BALANCES
0.030GOLDMAN SACHS GOVERNMENT FUND382 0.00 0.00 0.0300.00 Aaa252026000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND383 0.00 0.00 0.03007/01/2022 0.00 Aaa252026001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND384 0.00 0.00 0.0300.00 Aaa252026002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND385 0.00 0.00 0.0300.00 Aaa252026003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND386 0.00 0.00 0.0300.00 Aaa252026004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND401 0.00 0.00 0.0300.00 Aaa252026017-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND402 0.00 0.00 0.0300.00 Aaa252026018-G 1
Portfolio CITY
AP
Run Date: 09/20/2023 - 12:39 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-60
YTM/C
365
Page 2
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
5.220GOLDMAN SACHS GOVERNMENT FUND404 27.58 27.58 5.22027.58 Aaa260128000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND405 0.00 0.00 0.03007/01/2022 0.00 Aaa260128001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND407 0.00 0.00 0.03007/01/2022 0.00 Aaa260128002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND408 0.00 0.00 0.03007/01/2022 0.00 Aaa260128003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND409 0.00 0.00 0.03007/01/2022 0.00 Aaa260128004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND410 0.00 0.00 0.0300.00 Aaa260128005-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND412 0.00 0.00 0.0300.00 Aaa260128006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND414 0.00 0.00 0.0300.00 Aaa260128007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND415 0.00 0.00 0.0300.00 Aaa260128008-G 1
5.210GOLDMAN SACHS GOVERNMENT FUND416 144.42 144.42 5.210144.42 Aaa260128009-G 1
5.210GOLDMAN SACHS GOVERNMENT FUND417 857.19 857.19 5.210857.19 Aaa260128010-G 1
5.210GOLDMAN SACHS GOVERNMENT FUND418 166,401.49 166,401.49 5.210166,401.49 Aaa260128011-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND419 0.00 0.00 0.0300.00 Aaa261470000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND420 0.00 0.00 0.0300.00 Aaa261470001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND421 0.00 0.00 0.0300.00 Aaa261470002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND671 43.72 43.7243.72 Aaa263346000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND672 0.50 0.5007/01/2022 0.50 Aaa263346001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND673 0.19 0.190.19 Aaa263346002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND674 874,217.95 874,217.95874,217.95 Aaa263346003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND675 0.00 0.00 0.03007/01/2022 0.00 Aaa263346004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND676 0.94 0.94 0.03007/01/2022 0.94 Aaa263346005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND677 0.00 0.000.00 Aaa263346006-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND678 1.53 1.531.53 Aaa263346007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND679 1.69 1.69 0.03007/01/2022 1.69 Aaa263599000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND680 81.25 81.2507/01/2022 81.25 Aaa263599001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND682 1,416,858.81 1,416,858.811,416,858.81 Aaa263599002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND683 0.00 0.000.00 Aaa263599003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND684 0.00 0.00 0.03007/01/2022 0.00 Aaa269048000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND685 19.62 19.6219.62 Aaa271146000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND687 0.10 0.1007/01/2022 0.10 Aaa271146001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND688 0.03 0.03 0.03007/01/2022 0.03 Aaa271146002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND689 468,409.62 468,409.62468,409.62 Aaa271146003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND690 0.00 0.00 0.03007/01/2022 0.00 Aaa271146004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND691 0.70 0.70 0.03007/01/2022 0.70 Aaa271146005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND692 0.00 0.000.00 Aaa271146006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND693 0.00 0.00 0.03007/01/2022 0.00 Aaa277580000-G 1
Portfolio CITY
AP
Run Date: 09/20/2023 - 12:39 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-61
YTM/C
365
Page 3
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
0.005GOLDMAN SACHS GOVERNMENT FUND744 22,380.28 22,380.28 0.00522,380.28 Aaa263599004 1
2,949,447.612,949,447.612,949,447.612,949,447.52Subtotal and Average 0.296 1
MEDIUM-TERM NOTES
0.450AMAZON.COM INC.662 3,000,000.00 3,000,000.00 05/12/20240.45007/19/2021 2,852,400.00 A023135BW5 285
0.500CATERPILLAR FINANCIAL SERVICES697 3,000,000.00 2,998,812.14 05/17/20240.45010/08/2021 2,841,930.00 A14913R2L0 290
5.250Freddie Mac760 5,000,000.00 5,000,000.00 12/30/20245.25012/30/2022 5,000,000.00 Aaa3134GYAB8 517
6.750GOLDMAN SACHS GOVERNMENT FUND752 5,000,000.00 5,000,000.00 10/29/20276.75010/31/2022 5,000,000.00 A238150APM1 1,550
3.999MORGAN STANLEY747 5,000,000.00 5,000,000.00 07/23/20254.00009/01/2022 5,000,000.00 A16174468C6 722
0.500TOYOTA MOTOR CREDIT CORP658 3,000,000.00 3,000,000.00 06/18/20240.50006/18/2021 2,831,460.00 A89236TJH9 322
0.530TOYOTA MOTOR CREDIT CORP659 3,000,000.00 2,999,210.49 06/18/20240.50007/08/2021 2,831,460.00 A89236TJH9 322
0.525TOYOTA MOTOR CREDIT CORP667 3,000,000.00 2,999,344.63 06/18/20240.50009/14/2021 2,831,460.00 A89236TJH9 322
29,997,367.2629,188,710.0030,000,000.0029,997,245.02Subtotal and Average 2.917 619
CUSTODIAN PROJECT FUNDS
5.090FIRST AMERICAN US TREASURY MMF647 5,984,015.29 5,984,015.29 5.0905,984,015.29 Aaa6736302420-G 1
5.090FIRST AMERICAN US TREASURY MMF648 26,304,972.79 26,304,972.79 5.09026,304,972.79 Aaa6736302430-G 1
5.090FIRST AMERICAN US TREASURY MMF649 12,381,629.38 12,381,629.38 5.09012,381,629.38 Aaa6736302440-G 1
5.090FIRST AMERICAN US TREASURY MMF650 20,202,532.88 20,202,532.88 5.09020,202,532.88 Aaa6736302450-G 1
64,873,150.3464,873,150.3464,873,150.3464,853,143.67Subtotal and Average 5.090 1
RIVERSIDE COUNTY POOL
3.860POOLED INVESTMENT FUND052460 2,697,698.66 2,697,698.66 3.8602,697,698.66 Aaa052460 1
2,697,698.662,697,698.662,697,698.662,683,570.65Subtotal and Average 3.860 1
CUSTODIAN PROJECT FUNDS
0.010GOLDMAN SACHS TREASURY FUND498 0.00 0.00 0.0100.00 Aaa6736302420 1
0.010GOLDMAN SACHS TREASURY FUND499 0.00 0.00 0.0100.00 Aaa6736302430 1
0.010GOLDMAN SACHS TREASURY FUND500 0.00 0.00 0.0100.00 Aaa6736302440 1
0.010GOLDMAN SACHS TREASURY FUND501 0.00 0.00 0.0100.00 Aaa6736302450 1
0.000.000.000.00Subtotal and Average 0.000 0
Portfolio CITY
AP
Run Date: 09/20/2023 - 12:39 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-62
YTM/C
365
Page 4
Par Value Book Value
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
325,898,332.12 311,846,981.17 4.356 82309,720,571.17 311,828,013.09Total and Average
Portfolio CITY
AP
Run Date: 09/20/2023 - 12:39 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-63
YTM/C
365
Page 5
Par Value Book Value
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CUSTODIAN PROJECT FUNDS
0.000CITY OF PALM DESERT753 0.00 0.0010/27/2022 0.00SYS753 1
BANK CHECKING ACCOUNTS
0.000CITY OF PALM DESERT MAIN13016 0.00 0.000.00SYS13016 1
0.000DESERT WILLOW GOLF COURSE13013 0.00 0.0007/01/2022 0.00SYS13013 1
0.000PUBLIC SAFETY CHECKING602 0.00 0.0007/01/2022 0.00SYS602 1
0.000RECREATIONAL FACILITIES CORP13020 0.00 0.0007/01/2022 0.00SYS13020 1
0.000US Bank 1101 5,727,425.01 5,727,425.0105/26/2023 5,727,425.01SYS9121 1
0.000US Bank 1DW102 61,987.05 61,987.0505/26/2023 61,987.05SYS9154 1
0.000US Bank 1PDRFC103 1,000.00 1,000.0005/26/2023 1,000.00SYS9162 1
0.000US Bank 1PUBSAF107 1,136,961.77 1,136,961.7705/26/2023 1,136,961.77SYS4316 1
0.000WELLS FARGO BANKWFDW111 860,955.39 860,955.3905/24/2023 860,955.39 A1SYS6359 1
0.000WELLS FARGO BANKWFMAIN108 82,959.00 82,959.0005/19/2023 82,959.00 A1SYS6391 1
0.000WELLS FARGO BANKWFPDRFC112 1,347,827.18 1,347,827.1805/24/2023 1,347,827.18 A1SYS6342 1
0.00
325,898,332.12 321,066,096.57 4.356 82
1Average Balance
318,939,686.57 321,047,128.49Total Cash and Investments
Portfolio CITY
AP
Run Date: 09/20/2023 - 12:39 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-64
PALM DESERT HOUSING AUTHORITY
Portfolio Management
July 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 51,140,509.56 198.09 5.310151,140,509.5651,140,509.56
LAIF 998,018.16 11.91 3.3051998,018.16998,018.16
52,138,527.72 100.00%
Investments
52,138,527.7252,138,527.72 1 1 5.272
Cash
(not included in yield calculations)
Passbook/Checking 4,195,946.84 1 0.00014,195,946.844,195,946.84
56,334,474.56Total Cash and Investments 56,334,474.5656,334,474.56 1 1 5.272
Current Year
July 31
242,509.49
Average Daily Balance
Effective Rate of Return
56,037,735.35
5.10%
Total Earnings Month Ending
This investment portfolio complies with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash to fund
Housing Authority operations for the next six months. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio HA
AP
Reporting period 07/01/2023-07/31/2023
Run Date: 09/20/2023 - 12:38 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-65
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CAMP
1CA ASSET MANAGEMENT PROGRAM12008 51,140,509.56 51,140,509.56 5.31051,140,509.56SYS12008 5.310
51,140,509.5651,140,509.5651,140,509.5650,918,133.90Subtotal and Average 1 5.310
CUSTODIAN PROJECT FUNDS
1GOLDMAN SACHS TREASURY FUND590 0.00 0.00 0.0100.00 Aaa6736302460 0.010
0.000.000.000.00Subtotal and Average 0 0.000
LAIF
1LOCAL AGENCY INVESTMENT FUND21003 998,018.16 998,018.16 3.305998,018.16SYS21003 3.305
998,018.16998,018.16998,018.16998,018.16Subtotal and Average 1 3.305
CUSTODIAN PROJECT FUNDS
1FIRST AMERICAN US TREASURY MMF597 0.00 0.00 4.86001/01/2021 0.00 Aaa6736302460-G 4.860
0.000.000.000.00Subtotal and Average 0 0.000
56,037,735.35 52,138,527.72 1 5.27252,138,527.72 52,138,527.72Total and Average
Portfolio HA
AP
Run Date: 09/20/2023 - 12:38 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-66
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CHECKING
1HOUSING AUTH CHECKING25015 0.00 0.000.00SYS25015 0.000
1HOUSING AUTH CHECKINGHSG104 3,165.80 3,165.8005/29/2023 3,165.80SYS9204 0.000
1HOUSING AUTH TRUST25016 0.00 0.0007/01/2020 0.00SYS25016 0.000
1WELLS FARGO BANKWFHSG113 3,696,532.54 3,696,532.5406/01/2023 3,696,532.54 A1SYS6375 0.000
1WELLS FARGO BANKWFHSGT 496,248.50 496,248.5006/01/2023 496,248.50 A1SYS6367 0.000
0.00
56,037,735.35 56,334,474.56 1 5.272
1Average Balance
56,334,474.56 56,334,474.56Total Cash and Investments
Portfolio HA
AP
Run Date: 09/20/2023 - 12:38 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-67
RDA SUCCESSOR AGENCY
Portfolio Management
July 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
RIVERSIDE COUNTY POOL 343.41 10.00 3.8601343.41343.41
CAMP 6,000.05 10.04 5.31016,000.056,000.05
LAIF 762.35 10.01 3.3101762.35762.35
TRUSTEE CASH BALANCES - MMA 12,468,016.12 190.77 0.000112,468,016.1212,468,016.12
TRUSTEE CASH BALANCES - GF 1,261,048.04 19.18 5.02011,261,048.041,261,048.04
13,736,169.97 100.00%
Investments
13,736,169.9713,736,169.97 1 1 0.463
Cash
(not included in yield calculations)
Passbook/Checking 28,207,497.23 1 0.000128,207,497.2328,207,497.23
41,943,667.20Total Cash and Investments 41,943,667.2041,943,667.20 1 1 0.463
Current Year
July 31
1,335.45
Average Daily Balance
Effective Rate of Return
42,181,051.84
0.04%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to
fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the
Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio RDAS
AP
Reporting period 07/01/2023-07/31/2023
Run Date: 09/20/2023 - 12:36 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-68
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
RIVERSIDE COUNTY POOL
1POOLED INVESTMENT FUND052470 343.41 343.41 3.86007/01/2020 343.41 Aaa052470 3.860
343.41343.41343.41343.02Subtotal and Average 1 3.860
CAMP
1C.A.M.P. POOL (RDA S.A.)578 6,000.05 6,000.05 5.3106,000.05SYS578 5.310
6,000.056,000.056,000.055,973.96Subtotal and Average 1 5.310
LAIF
1L.A.I.F. (RDA S.A.)604 762.35 762.35 3.31007/01/2020 762.35SYS604 3.310
762.35762.35762.35762.35Subtotal and Average 1 3.310
TRUSTEE CASH BALANCES - MMA
1U.S. BANK MONEY MARKET ACCOUNT830 0.05 0.0507/01/2020 0.05 P-1247394001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT832 0.00 0.00 0.01007/01/2020 0.00 P-1247394003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT833 1.03 1.031.03 P-1247394002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT834 414,242.25 414,242.25414,242.25 P-1247394000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT837 14.42 14.4214.42 P-1236781002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT838 0.00 0.00 0.01007/01/2020 0.00 P-1236781003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT839 7,343,244.57 7,343,244.577,343,244.57 P-1236781000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT842 0.00 0.00 0.01007/01/2020 0.00 P-1253446003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT843 7.66 7.667.66 P-1253446002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT844 2,040,482.66 2,040,482.662,040,482.66 P-1253446000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT845 0.41 0.4107/01/2020 0.41 P-1253446001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT853 2,669,999.66 2,669,999.662,669,999.66 P-1224324000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT855 0.79 0.7907/01/2020 0.79 P-1224324001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT856 22.55 22.5522.55 P-1224324002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT857 0.00 0.00 0.01007/01/2020 0.00 P-1224324003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT881 0.07 0.0709/01/2020 0.07 P-1236781001-U 0.000
12,468,016.1212,468,016.1212,468,016.1212,468,009.51Subtotal and Average 1 0.000
TRUSTEE CASH BALANCES - GF
1GOLDMAN SACHS GOVERNMENT FUND811 1,261,048.04 1,261,048.04 5.0201,261,048.04 Aaa277861000-G 5.020
1GOLDMAN SACHS GOVERNMENT FUND812 0.00 0.00 0.0300.00 Aaa277861001-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND813 0.00 0.00 0.03007/01/2020 0.00 Aaa277861002-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND814 0.00 0.00 0.03007/01/2020 0.00 Aaa277861003-G 0.030
Portfolio RDAS
AP
Run Date: 09/20/2023 - 12:36 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-69
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
1,261,048.041,261,048.041,261,048.04305,863.00Subtotal and Average 1 5.020
42,181,051.84 13,736,169.97 1 0.46313,736,169.97 13,736,169.97Total and Average
Portfolio RDAS
AP
Run Date: 09/20/2023 - 12:36 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-70
Days to
Mat./Call
Page 3
Par Value Book Value
Stated
RateMarket Value
July 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
UNION BANK CHECKING ACCOUNTS
1RDA SUCCESSOR AGENCY582 0.00 0.000.00SYS582 0.000
1RDA SUCCESSOR AGENCYRDA106 28,207,497.23 28,207,497.2306/01/2023 28,207,497.23SYS4021 0.000
0.00
42,181,051.84 41,943,667.20 1 0.463
1Average Balance
41,943,667.20 41,943,667.20Total Cash and Investments
Portfolio RDAS
AP
Run Date: 09/20/2023 - 12:36 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-71
CITY OF PALM DESERT
ACCOUNT STATEMENT
For the Month Ending
July 31, 2023
Customer Service
PO Box 11813
Harrisburg, PA 17108-1813
Contents
Cover/Disclosures
Summary Statement
Individual Accounts
CITY OF PALM DESERT
MITCHELL ARBAUGH
73-510 FRED WARING DR
PALM DESERT, CA 92260
Client Management Team
Accounts included in Statement
553-00 CITY OF PALM DESERT
553-04 DESERT WILLOW GOLF RESORT
553-06 PALM DESERT HOUSING AUTHORITY
553-08 RDA SUCCESSOR AGENCY -- PALM DESERT
www.camponline.comOnline Access 1-800-729-7665Customer Service
Important Messages
CAMP will be closed on 09/04/2023 for Labor Day.
Jeremy King
Key Account Manager
213 Market Street
Harrisburg, PA 17101-2141
1-800-729-7665
kingj@pfmam.com
Rachael Miller
Client Consultant
213 Market Street
Harrisburg, PA 17101-2141
1-800-729-7665
millerr@pfmam.com
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-72
For the Month Ending July 31, 2023
Account Statement
Important Disclosures
Important Disclosures
365 and dividing the result by 7. The yields quoted should not be considered a
representation of the yield of the fund in the future, since the yield is not fixed.
Average maturity represents the average maturity of all securities and
investments of a portfolio, determined by multiplying the par or principal value of
each security or investment by its maturity (days or years), summing the
products, and dividing the sum by the total principal value of the portfolio. The
stated maturity date of mortgage backed or callable securities are used in this
statement. However the actual maturity of these securities could vary depending
on the level or prepayments on the underlying mortgages or whether a callable
security has or is still able to be called.
Monthly distribution yield represents the net change in the value of one share
(normally $1.00 per share) resulting from all dividends declared during the month
by a fund expressed as a percentage of the value of one share at the beginning
of the month. This resulting net change is then annualized by multiplying it by
365 and dividing it by the number of calendar days in the month.
YTM at Cost The yield to maturity at cost is the expected rate of return, based
on the original cost, the annual interest receipts, maturity value and the time
period from purchase date to maturity, stated as a percentage, on an annualized
basis.
YTM at Market The yield to maturity at market is the rate of return, based on the
current market value, the annual interest receipts, maturity value and the time
period remaining until maturity, stated as a percentage, on an annualized basis.
Managed Account A portfolio of investments managed discretely by PFMAM
according to the client’s specific investment policy and requirements. The
investments are directly owned by the client and held by the client’s custodian.
Unsettled Trade A trade which has been executed however the final
consummation of the security transaction and payment has not yet taken place.
Please review the detail pages of this statement carefully. If you think your
statement is wrong, missing account information, or if you need more information
about a transaction, please contact PFMAM within 60 days of receipt. If you have
other concerns or questions regarding your account, or to request an updated
copy of PFMAM's current disclosure statement, please contact a member of your
client management team at PFMAM Service Operations at the address below.
PFM Asset Management LLC
Attn: Service Operations
213 Market Street
Harrisburg, PA 17101
NOT FDIC INSURED NO BANK GUARANTEE MAY LOSE VALUE
This statement is for general information purposes only and is not intended to provide
specific advice or recommendations. PFM Asset Management LLC ("PFMAM") is an
investment adviser registered with the U.S. Securities and Exchange Commission and a
subsidiary of U.S. Bancorp Asset Management, Inc. ("USBAM"). USBAM is a subsidiary
of U.S. Bank National Association ("U.S. Bank"). U.S. Bank is a separate entity and
subsidiary of U.S. Bancorp. U.S. Bank is not responsible for and does not guarantee the
products, services or performance of PFMAM. PFMAM maintains a written disclosure
statement of our background and business experience. If you would like to receive a
copy of our current disclosure statement, please contact Service Operations at the
address below.
Proxy Voting PFMAM does not normally receive proxies to vote on behalf of its clients.
However, it does on occasion receive consent requests. In the event a consent request
is received the portfolio manager contacts the client and then proceeds according to
their instructions. PFMAM’s Proxy Voting Policy is available upon request by contacting
Service Operations at the address below.
Questions About an Account PFMAM’s monthly statement is intended to detail our
investment advisory activity as well as the activity of any accounts held by clients in
pools that are managed by PFMAM. The custodian bank maintains the control of assets
and executes (i.e., settles) all investment transactions. The custodian statement is the
official record of security and cash holdings and transactions. PFMAM recognizes that
clients may use these reports to facilitate record keeping and that the custodian bank
statement and the PFMAM statement should be reconciled and differences resolved.
Many custodians use a settlement date basis which may result in the need to reconcile
due to a timing difference.
Account Control PFMAM does not have the authority to withdraw funds from or deposit
funds to the custodian outside the scope of services provided by PFMAM. Our clients
retain responsibility for their internal accounting policies; implementing and enforcing
internal controls and generating ledger entries or otherwise recording transactions.
Market Value Generally, PFMAM’s market prices are derived from closing bid prices as
of the last business day of the month as supplied by Refinitiv or Bloomberg. For certain
short-term investments or where prices are not available from generally recognized
sources the securities are priced using a yield-based matrix system to arrive at an
estimated market value. Prices that fall between data points are interpolated.
Non-negotiable FDIC-insured bank certificates of deposit are priced at par. Although
PFMAM believes the prices to be reliable, the values of the securities may not represent
the prices at which the securities could have been bought or sold. Explanation of the
valuation methods for a registered investment company or local government investment
program is contained in the appropriate fund offering documentation or information
statement.
Amortized Cost The original cost of the principal of the security is adjusted for the
amount of the periodic reduction of any discount or premium from the purchase date
until the date of the report. Discount or premium with respect to short term securities
(those with less than one year to maturity at time of issuance) is amortized on a
straightline basis. Such discount or premium with respect to longer term securities is
amortized using the constant yield basis.
Tax Reporting Cost data and realized gains / losses are provided for informational
purposes only. Please review for accuracy and consult your tax advisor to determine
the tax consequences of your security transactions. PFMAM does not report such
information to the IRS or other taxing authorities and is not responsible for the
accuracy of such information that may be required to be reported to federal, state or
other taxing authorities.
Financial Situation In order to better serve you, PFMAM should be promptly notified
of any material change in your investment objective or financial situation.
Callable Securities Securities subject to redemption prior to maturity may be
redeemed in whole or in part before maturity, which could affect the yield represented.
Portfolio The securities in this portfolio, including shares of mutual funds, are not
guaranteed or otherwise protected by PFMAM, the FDIC (except for certain
non-negotiable certificates of deposit) or any government agency. Investment in
securities involves risks, including the possible loss of the amount invested. Actual
settlement values, accrued interest, and amortized cost amounts may vary for
securities subject to an adjustable interest rate or subject to principal paydowns. Any
changes to the values shown may be reflected within the next monthly statement’s
beginning values.
Rating Information provided for ratings is based upon a good faith inquiry of selected
sources, but its accuracy and completeness cannot be guaranteed.
Shares of some local government investment programs and TERM funds are
marketed through representatives of PFMAM's affiliate, PFM Fund Distributors, Inc.
which is registered with the SEC as a broker/dealer and is a member of the Financial
Industry Regulatory Authority (“FINRA”) and the Municipal Securities Rulemaking
Board (“MSRB”). You may reach the FINRA by calling the FINRA Hotline at
1-800-289-9999 or at the FINRA website address
https://www.finra.org/investors/investor-contacts. A brochure describing the FINRA
Regulation Public Disclosure Program is also available from FINRA upon request.
Key Terms and Definitions
Dividends on local government investment program funds consist of interest earned,
plus any discount ratably amortized to the date of maturity, plus all realized gains and
losses on the sale of securities prior to maturity, less ratable amortization of any
premium and all accrued expenses to the fund. Dividends are accrued daily and may
be paid either monthly or quarterly. The monthly earnings on this statement represent
the estimated dividend accrued for the month for any program that distributes earnings
on a quarterly basis. There is no guarantee that the estimated amount will be paid on
the actual distribution date.
Current Yield is the net change, exclusive of capital changes and income other than
investment income, in the value of a hypothetical fund account with a balance of one
share over the seven-day base period including the statement date, expressed as a
percentage of the value of one share (normally $1.00 per share) at the beginning of
the seven-day period. This resulting net change in account value is then annualized by
multiplying it by
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-73
For the Month Ending July 31, 2023
Account Statement
Consolidated Summary Statement
CITY OF PALM DESERT
Investment Allocation
Investment Type Closing Market Value Percent
210,655,650.53 100.00 Joint Powers Authority
$210,655,650.53 Total 100.00%
Portfolio Summary
and Income
Closing
Market Value
Current
Portfolio Holdings
Cash Dividends
Yield
CAMP Pool 946,532.97 210,655,650.53 5.43 %
$946,532.97 $210,655,650.53 Total
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
210,655,650.53
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
100.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Under 30 days
31 to 60 days
61 to 90 days
91 to 180 days
181 days to 1 year
1 to 2 years
2 to 3 years
3 to 4 years
4 to 5 years
Over 5 years
Total $210,655,650.53
1
100.00%
Weighted Average Days to Maturity
Sector Allocation
100.00%
Joint Powers
Authority
Summary Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-74
For the Month Ending July 31, 2023
Account Statement
Consolidated Summary Statement
CITY OF PALM DESERT
and Income
Closing Market
Value
Change in
Value Trades MaturitiesDeposits ValueAccount Name
Account
Number
Cash DividendsUnsettled Redemptions / Sales/Purchases /Opening Market
553-00 154,438,584.68 697,066.55 0.00 0.00 155,135,651.23 0.00 697,066.55 CITY OF PALM DESERT
553-04 4,353,838.41 19,651.28 0.00 0.00 4,373,489.69 0.00 19,651.28 DESERT WILLOW GOLF RESORT
553-06 50,910,721.38 229,788.18 0.00 0.00 51,140,509.56 0.00 229,788.18 PALM DESERT HOUSING
AUTHORITY
553-08 5,973.09 26.96 0.00 0.00 6,000.05 0.00 26.96 RDA SUCCESSOR AGENCY -- PALM
DESERT
$209,709,117.56 $946,532.97 $0.00 $0.00 $210,655,650.53 $946,532.97 Total $0.00
Summary Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-75
For the Month Ending July 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - CITY OF PALM DESERT - 553-00
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
154,438,584.68
697,066.55
0.00
0.00
$155,135,651.23
CAMP Pool
Unsettled Trades 0.00
697,066.55 Cash Dividends and Income
July 31, 2023 June 30, 2023
Asset Summary
CAMP Pool 155,135,651.23 154,438,584.68
$155,135,651.23 $154,438,584.68 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-00 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-76
For the Month Ending July 31, 2023Account Statement
CITY OF PALM DESERT - CITY OF PALM DESERT - 553-00
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
154,438,584.68 Opening Balance
07/31/23 08/01/23 Accrual Income Div Reinvestment - Distributions 1.00 697,066.55 155,135,651.23
155,135,651.23
155,135,651.23
155,135,651.23
154,461,070.70
3,909,185.11
0.00
0.00
104,909,185.11
50,226,466.12
697,066.55
155,135,651.23
0.00
0.00
697,066.55
154,438,584.68
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
July January-July
5.31%
Account 553-00 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-77
For the Month Ending July 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT - 553-04
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
4,353,838.41
19,651.28
0.00
0.00
$4,373,489.69
CAMP Pool
Unsettled Trades 0.00
19,651.28 Cash Dividends and Income
July 31, 2023 June 30, 2023
Asset Summary
CAMP Pool 4,373,489.69 4,353,838.41
$4,373,489.69 $4,353,838.41 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-04 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-78
For the Month Ending July 31, 2023Account Statement
CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT - 553-04
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
4,353,838.41 Opening Balance
07/31/23 08/01/23 Accrual Income Div Reinvestment - Distributions 1.00 19,651.28 4,373,489.69
4,373,489.69
4,373,489.69
4,373,489.69
4,354,472.32
104,703.55
0.00
0.00
2,104,703.55
2,268,786.14
19,651.28
4,373,489.69
0.00
0.00
19,651.28
4,353,838.41
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
July January-July
5.31%
Account 553-04 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-79
For the Month Ending July 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY - 553-06
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
50,910,721.38
229,788.18
0.00
0.00
$51,140,509.56
CAMP Pool
Unsettled Trades 0.00
229,788.18 Cash Dividends and Income
July 31, 2023 June 30, 2023
Asset Summary
CAMP Pool 51,140,509.56 50,910,721.38
$51,140,509.56 $50,910,721.38 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-06 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-80
For the Month Ending July 31, 2023Account Statement
CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY - 553-06
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
50,910,721.38 Opening Balance
07/31/23 08/01/23 Accrual Income Div Reinvestment - Distributions 1.00 229,788.18 51,140,509.56
51,140,509.56
51,140,509.56
51,140,509.56
50,918,133.90
1,451,249.43
0.00
0.00
1,451,249.43
49,689,260.13
229,788.18
51,140,509.56
0.00
0.00
229,788.18
50,910,721.38
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
July January-July
5.31%
Account 553-06 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-81
For the Month Ending July 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT - 553-08
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
5,973.09
26.96
0.00
0.00
$6,000.05
CAMP Pool
Unsettled Trades 0.00
26.96 Cash Dividends and Income
July 31, 2023 June 30, 2023
Asset Summary
CAMP Pool 6,000.05 5,973.09
$6,000.05 $5,973.09 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-08 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-82
For the Month Ending July 31, 2023Account Statement
CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT - 553-08
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
5,973.09 Opening Balance
07/31/23 08/01/23 Accrual Income Div Reinvestment - Distributions 1.00 26.96 6,000.05
6,000.05
6,000.05
6,000.05
5,973.96
170.26
0.00
0.00
170.26
5,829.79
26.96
6,000.05
0.00
0.00
26.96
5,973.09
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
July January-July
5.31%
Account 553-08 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-83
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
September 12, 2023
LAIF Home
PMIA Average Monthly
Yields
CITY OF PALM DESERT
CITY TREASURER
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260-2578
Account Number: 98-33-621
July 2023 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
7/14/2023 7/19/2023 QRD 1736151 N/A SYSTEM 162,173.65
Account Summary
Total Deposit:162,173.65 Beginning Balance:20,655,369.99
Total Withdrawal:0.00 Ending Balance:20,817,543.64
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-84
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
September 12, 2023
LAIF Home
PMIA Average Monthly
Yields
PALM DESERT HOUSING AUTHORITY
CITY TREASURER
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260-2578
Account Number: 25-33-003
July 2023 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
7/14/2023 7/19/2023 QRD 1734679 N/A SYSTEM 7,774.80
Account Summary
Total Deposit:7,774.80 Beginning Balance:990,243.36
Total Withdrawal:0.00 Ending Balance:998,018.16
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-85
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
September 12, 2023
LAIF Home
PMIA Average Monthly
Yields
S/A TO THE PALM DESERT REDEVELOPMENT
AGENCY
FINANCE DIRECTOR
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260-2578
Account Number: 65-33-023
July 2023 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
7/14/2023 7/19/2023 QRD 1735101 N/A SYSTEM 5.94
Account Summary
Total Deposit:5.94 Beginning Balance:756.41
Total Withdrawal:0.00 Ending Balance:762.35
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-86
Parameters:Query: Fund Summary
County of Riverside Treasurer-Tax CollectorFund Summary Report
Bank: oneof
Account Number: oneof 052460, 052470
Counterparty: equalto
Run Date:02-Aug-2023 08:34:52 AM User:Susan
From :
To :
As at :
01-Jul-2023
31-Jul-2023
02-Aug-2023
Balance Calculation Based On:Value Date
TotalBalance Forward Totaltrans_typeAccount NameAccount Numbe Balance ForwardAccount NameAccount Number Total ReceiptsTotal Receipts Total PaymentsTotal Payments
City Of Palm Desert052460 $2,504,768.68 $192,929.98 $0.00 $2,697,698.66
RDA Successor Agcy Palm Desert052470 $340.91 $2.50 $0.00 $343.41
Grand Total:$2,505,109.59 $192,932.48 $0.00 $2,698,042.07
Printed on 8/2/2023 Page 1 of 1End of Report
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-87
CITY OF PALM DESERT
Portfolio Management
August 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 179,557,419.07 157.12 5.5201179,557,419.07179,557,419.07
FEDERAL AGENCY - COUPON 13,998,904.11 1374.45 0.43983013,465,070.0014,000,000.00
LAIF 817,543.64 10.26 3.3051817,543.64817,543.64
FEDERAL AGENCY - CALLABLE 16,986,659.46 2305.40 0.42793016,219,810.0017,000,000.00
TRUSTEE CASH BALANCES 5,144,189.13 11.64 0.31515,144,189.135,144,189.13
MEDIUM-TERM NOTES 29,997,628.60 5889.54 2.9171,11829,188,710.0030,000,000.00
CUSTODIAN PROJECT FUNDS 65,149,574.93 120.73 5.190165,149,574.9365,149,574.93
RIVERSIDE COUNTY POOL 2,697,698.66 10.86 3.86012,697,698.662,697,698.66
314,349,617.60 100.00%
Investments
312,240,015.43314,366,425.43 75 195 4.597
Cash
(not included in yield calculations)
Passbook/Checking 5,779,745.96 1 0.00015,779,745.965,779,745.96
320,129,363.56Total Cash and Investments 318,019,761.39320,146,171.39 75 195 4.597
Current Year
August 31
1,203,989.98
Average Daily Balance
Effective Rate of Return
320,275,540.68
4.43%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash
to fund city expenditures for the next six months. US Bank Custody Services has provided market value prices for all corporate securities. All balances are bank balances. The "% of Portfolio" calculation
on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio CITY
AP
Reporting period 08/01/2023-08/31/2023
Run Date: 09/21/2023 - 08:12 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-88
YTM/C
365
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CAMP
5.520C.A.M.P. POOL (CITY)13 175,914,340.44 175,914,340.44 5.520175,914,340.44SYS13 1
5.520C.A.M.P. POOL (DESERT WILLOW)12444 3,643,078.63 3,643,078.63 5.5203,643,078.63SYS12444 1
179,557,419.07179,557,419.07179,557,419.07170,309,085.38Subtotal and Average 5.520 1
U.S. BANK / LAIF BOND PROCEEDS
0.203LOCAL AGENCY INVESTMENT FUND12-33-084 0.00 0.00 0.2030.00252026003 1
0.000.000.000.00Subtotal and Average 0.000 0
FEDERAL AGENCY - COUPON
0.505FEDERAL HOME LOAN BANK664 3,000,000.00 2,999,839.62 10/28/20240.50007/28/2021 2,833,650.00 Aaa3130ANAC4 423
0.500FEDERAL HOME LOAN BANK710 5,000,000.00 5,000,000.00 12/08/20230.50011/04/2021 4,830,800.00 Aaa3130APR72 98
0.360FEDERAL HOME LOAN MTG CORP706 3,000,000.00 2,999,122.59 10/16/20230.12510/21/2021 2,893,710.00 Aaa3137EAEY1 45
0.350FEDERAL HOME LOAN MTG CORP707 3,000,000.00 2,999,941.90 09/08/20230.25010/21/2021 2,906,910.00 Aaa3137EAEW5 7
13,998,904.1113,465,070.0014,000,000.0013,998,508.65Subtotal and Average 0.439 137
LAIF
3.305LOCAL AGENCY INVESTMENT FUND12000 817,543.64 817,543.64 3.305817,543.6412000 1
817,543.64817,543.64817,543.649,204,640.41Subtotal and Average 3.305 1
FEDERAL AGENCY - CALLABLE
0.520FEDERAL FARM CREDIT BANK668 5,000,000.00 4,986,988.97 12/23/20240.32009/14/2021 4,655,800.00 Aaa3133EMLP5 479
0.370FEDERAL FARM CREDIT BANK698 3,000,000.00 2,999,877.50 10/20/20230.34010/20/2021 2,908,920.00 Aaa3133ENBN9 49
0.331FEDERAL FARM CREDIT BANK699 3,000,000.00 2,999,792.99 10/12/20230.27010/19/2021 2,901,330.00 Aaa3133ENAU4 41
0.400FEDERAL HOME LOAN BANK660 3,000,000.00 3,000,000.00 07/29/20240.40007/29/2021 2,854,620.00 Aaa3130AN7K0 332
0.450FEDERAL HOME LOAN BANK708 3,000,000.00 3,000,000.00 11/24/20230.45011/24/2021 2,899,140.00 Aaa3130APMC6 84
16,986,659.4616,219,810.0017,000,000.0016,986,166.72Subtotal and Average 0.427 230
TRUSTEE CASH BALANCES
0.030GOLDMAN SACHS GOVERNMENT FUND382 0.00 0.00 0.0300.00 Aaa252026000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND383 0.00 0.00 0.03007/01/2022 0.00 Aaa252026001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND384 0.00 0.00 0.0300.00 Aaa252026002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND385 0.00 0.00 0.0300.00 Aaa252026003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND386 0.00 0.00 0.0300.00 Aaa252026004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND401 0.00 0.00 0.0300.00 Aaa252026017-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND402 0.00 0.00 0.0300.00 Aaa252026018-G 1
Portfolio CITY
AP
Run Date: 09/21/2023 - 08:12 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-89
YTM/C
365
Page 2
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
5.220GOLDMAN SACHS GOVERNMENT FUND404 27.70 27.70 5.22027.70 Aaa260128000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND405 0.00 0.00 0.03007/01/2022 0.00 Aaa260128001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND407 0.00 0.00 0.03007/01/2022 0.00 Aaa260128002-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND408 0.00 0.00 0.03007/01/2022 0.00 Aaa260128003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND409 0.00 0.00 0.03007/01/2022 0.00 Aaa260128004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND410 0.00 0.00 0.0300.00 Aaa260128005-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND412 0.00 0.00 0.0300.00 Aaa260128006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND414 0.00 0.00 0.0300.00 Aaa260128007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND415 0.00 0.00 0.0300.00 Aaa260128008-G 1
5.210GOLDMAN SACHS GOVERNMENT FUND416 145.04 145.04 5.210145.04 Aaa260128009-G 1
5.210GOLDMAN SACHS GOVERNMENT FUND417 141,747.83 141,747.83 5.210141,747.83 Aaa260128010-G 1
5.210GOLDMAN SACHS GOVERNMENT FUND418 167,114.81 167,114.81 5.210167,114.81 Aaa260128011-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND419 0.00 0.00 0.0300.00 Aaa261470000-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND420 0.00 0.00 0.0300.00 Aaa261470001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND421 0.00 0.00 0.0300.00 Aaa261470002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND671 65.38 65.3865.38 Aaa263346000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND672 283,575.50 283,575.5007/01/2022 283,575.50 Aaa263346001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND673 305,000.19 305,000.19305,000.19 Aaa263346002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND674 874,200.00 874,200.00874,200.00 Aaa263346003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND675 0.00 0.00 0.03007/01/2022 0.00 Aaa263346004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND676 0.94 0.94 0.03007/01/2022 0.94 Aaa263346005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND677 0.00 0.000.00 Aaa263346006-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND678 1.53 1.531.53 Aaa263346007-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND679 1.69 1.69 0.03007/01/2022 1.69 Aaa263599000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND680 1,099,081.25 1,099,081.2507/01/2022 1,099,081.25 Aaa263599001-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND682 1,416,864.83 1,416,864.831,416,864.83 Aaa263599002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND683 0.00 0.000.00 Aaa263599003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND684 0.00 0.00 0.03007/01/2022 0.00 Aaa269048000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND685 31.23 31.2331.23 Aaa271146000-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND687 95,550.10 95,550.1007/01/2022 95,550.10 Aaa271146001-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND688 270,000.03 270,000.03 0.03007/01/2022 270,000.03 Aaa271146002-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND689 468,400.00 468,400.00468,400.00 Aaa271146003-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND690 0.00 0.00 0.03007/01/2022 0.00 Aaa271146004-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND691 0.70 0.70 0.03007/01/2022 0.70 Aaa271146005-G 1
0.000GOLDMAN SACHS GOVERNMENT FUND692 0.00 0.000.00 Aaa271146006-G 1
0.030GOLDMAN SACHS GOVERNMENT FUND693 0.00 0.00 0.03007/01/2022 0.00 Aaa277580000-G 1
Portfolio CITY
AP
Run Date: 09/21/2023 - 08:12 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-90
YTM/C
365
Page 3
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
TRUSTEE CASH BALANCES
0.005GOLDMAN SACHS GOVERNMENT FUND744 22,380.38 22,380.38 0.00522,380.38 Aaa263599004 1
5,144,189.135,144,189.135,144,189.133,091,699.24Subtotal and Average 0.315 1
MEDIUM-TERM NOTES
0.450AMAZON.COM INC.662 3,000,000.00 3,000,000.00 05/12/20240.45007/19/2021 2,852,400.00 A023135BW5 254
0.500CATERPILLAR FINANCIAL SERVICES697 3,000,000.00 2,998,936.74 05/17/20240.45010/08/2021 2,841,930.00 A14913R2L0 259
5.250Freddie Mac760 5,000,000.00 5,000,000.00 12/30/20245.25012/30/2022 5,000,000.00 Aaa3134GYAB8 486
6.750GOLDMAN SACHS GOVERNMENT FUND752 5,000,000.00 5,000,000.00 10/29/20276.75010/31/2022 5,000,000.00 A238150APM1 1,519
3.999MORGAN STANLEY747 5,000,000.00 5,000,000.00 07/23/20254.00009/01/2022 5,000,000.00 A16174468C6 691
0.500TOYOTA MOTOR CREDIT CORP658 3,000,000.00 3,000,000.00 06/18/20240.50006/18/2021 2,831,460.00 A89236TJH9 291
0.530TOYOTA MOTOR CREDIT CORP659 3,000,000.00 2,999,285.21 06/18/20240.50007/08/2021 2,831,460.00 A89236TJH9 291
0.525TOYOTA MOTOR CREDIT CORP667 3,000,000.00 2,999,406.65 06/18/20240.50009/14/2021 2,831,460.00 A89236TJH9 291
29,997,628.6029,188,710.0030,000,000.0029,997,506.36Subtotal and Average 2.917 588
CUSTODIAN PROJECT FUNDS
5.190FIRST AMERICAN US TREASURY MMF647 6,009,523.15 6,009,523.15 5.1906,009,523.15 Aaa6736302420-G 1
5.190FIRST AMERICAN US TREASURY MMF648 26,417,045.70 26,417,045.70 5.19026,417,045.70 Aaa6736302430-G 1
5.190FIRST AMERICAN US TREASURY MMF649 12,434,400.60 12,434,400.60 5.19012,434,400.60 Aaa6736302440-G 1
5.190FIRST AMERICAN US TREASURY MMF650 20,288,605.48 20,288,605.48 5.19020,288,605.48 Aaa6736302450-G 1
65,149,574.9365,149,574.9365,149,574.9364,882,067.26Subtotal and Average 5.190 1
RIVERSIDE COUNTY POOL
3.860POOLED INVESTMENT FUND052460 2,697,698.66 2,697,698.66 3.8602,697,698.66 Aaa052460 1
2,697,698.662,697,698.662,697,698.662,697,698.66Subtotal and Average 3.860 1
CUSTODIAN PROJECT FUNDS
0.010GOLDMAN SACHS TREASURY FUND498 0.00 0.00 0.0100.00 Aaa6736302420 1
0.010GOLDMAN SACHS TREASURY FUND499 0.00 0.00 0.0100.00 Aaa6736302430 1
0.010GOLDMAN SACHS TREASURY FUND500 0.00 0.00 0.0100.00 Aaa6736302440 1
0.010GOLDMAN SACHS TREASURY FUND501 0.00 0.00 0.0100.00 Aaa6736302450 1
0.000.000.000.00Subtotal and Average 0.000 0
Portfolio CITY
AP
Run Date: 09/21/2023 - 08:12 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-91
YTM/C
365
Page 4
Par Value Book Value
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
320,275,540.68 314,366,425.43 4.597 75312,240,015.43 314,349,617.60Total and Average
Portfolio CITY
AP
Run Date: 09/21/2023 - 08:12 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-92
YTM/C
365
Page 5
Par Value Book Value
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
CITY OF PALM DESERT
Days to
Mat./CallMoody'sCUSIPInvestment #
Purchase
Date
CUSTODIAN PROJECT FUNDS
0.000CITY OF PALM DESERT753 0.00 0.0010/27/2022 0.00SYS753 1
BANK CHECKING ACCOUNTS
0.000CITY OF PALM DESERT MAIN13016 0.00 0.000.00SYS13016 1
0.000DESERT WILLOW GOLF COURSE13013 0.00 0.0007/01/2022 0.00SYS13013 1
0.000PUBLIC SAFETY CHECKING602 0.00 0.0007/01/2022 0.00SYS602 1
0.000RECREATIONAL FACILITIES CORP13020 0.00 0.0007/01/2022 0.00SYS13020 1
0.000US Bank 1101 3,474,964.13 3,474,964.1305/26/2023 3,474,964.13SYS9121 1
0.000US Bank 1DW102 61,987.05 61,987.0505/26/2023 61,987.05SYS9154 1
0.000US Bank 1PDRFC103 1,000.00 1,000.0005/26/2023 1,000.00SYS9162 1
0.000US Bank 1PUBSAF107 0.00 0.0005/26/2023 0.00SYS4316 1
0.000WELLS FARGO BANKWFDW111 1,509,129.24 1,509,129.2405/24/2023 1,509,129.24 A1SYS6359 1
0.000WELLS FARGO BANKWFMAIN108 38,518.00 38,518.0005/19/2023 38,518.00 A1SYS6391 1
0.000WELLS FARGO BANKWFPDRFC112 694,147.54 694,147.5405/24/2023 694,147.54 A1SYS6342 1
0.00
320,275,540.68 320,146,171.39 4.597 75
1Average Balance
318,019,761.39 320,129,363.56Total Cash and Investments
Portfolio CITY
AP
Run Date: 09/21/2023 - 08:12 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-93
PALM DESERT HOUSING AUTHORITY
Portfolio Management
August 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
CAMP 51,380,217.63 198.09 5.520151,380,217.6351,380,217.63
LAIF 998,018.16 11.91 3.4341998,018.16998,018.16
52,378,235.79 100.00%
Investments
52,378,235.7952,378,235.79 1 1 5.480
Cash
(not included in yield calculations)
Passbook/Checking 4,254,546.16 1 0.00014,254,546.164,254,546.16
56,632,781.95Total Cash and Investments 56,632,781.9556,632,781.95 1 1 5.480
Current Year
August 31
242,704.94
Average Daily Balance
Effective Rate of Return
56,344,985.96
5.07%
Total Earnings Month Ending
This investment portfolio complies with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Barring unforeseen events, it has sufficient cash to fund
Housing Authority operations for the next six months. All balances are bank balances. The "% of Portfolio" calculation on the Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio HA
AP
Reporting period 08/01/2023-08/31/2023
Run Date: 09/20/2023 - 15:49 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-94
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CAMP
1CA ASSET MANAGEMENT PROGRAM12008 51,380,217.63 51,380,217.63 5.52051,380,217.63SYS12008 5.520
51,380,217.6351,380,217.6351,380,217.6351,148,242.08Subtotal and Average 1 5.520
CUSTODIAN PROJECT FUNDS
1GOLDMAN SACHS TREASURY FUND590 0.00 0.00 0.0100.00 Aaa6736302460 0.010
0.000.000.000.00Subtotal and Average 0 0.000
LAIF
1LOCAL AGENCY INVESTMENT FUND21003 998,018.16 998,018.16 3.434998,018.16SYS21003 3.434
998,018.16998,018.16998,018.16998,018.16Subtotal and Average 1 3.434
CUSTODIAN PROJECT FUNDS
1FIRST AMERICAN US TREASURY MMF597 0.00 0.00 4.86001/01/2021 0.00 Aaa6736302460-G 4.860
0.000.000.000.00Subtotal and Average 0 0.000
56,344,985.96 52,378,235.79 1 5.48052,378,235.79 52,378,235.79Total and Average
Portfolio HA
AP
Run Date: 09/20/2023 - 15:49 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-95
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
PALM DESERT HOUSING AUTHORITY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CHECKING
1HOUSING AUTH CHECKING25015 0.00 0.000.00SYS25015 0.000
1HOUSING AUTH CHECKINGHSG104 0.00 0.0005/29/2023 0.00SYS9204 0.000
1HOUSING AUTH TRUST25016 0.00 0.0007/01/2020 0.00SYS25016 0.000
1WELLS FARGO BANKWFHSG113 3,755,747.66 3,755,747.6606/01/2023 3,755,747.66 A1SYS6375 0.000
1WELLS FARGO BANKWFHSGT 498,798.50 498,798.5006/01/2023 498,798.50 A1SYS6367 0.000
0.00
56,344,985.96 56,632,781.95 1 5.480
1Average Balance
56,632,781.95 56,632,781.95Total Cash and Investments
Portfolio HA
AP
Run Date: 09/20/2023 - 15:49 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-96
RDA SUCCESSOR AGENCY
Portfolio Management
August 31, 2023
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value Term
Days to
Mat./Call
YTM/C
365 Equiv.
RIVERSIDE COUNTY POOL 343.41 10.00 3.8601343.41343.41
CAMP 6,028.17 10.05 5.52016,028.176,028.17
LAIF 762.35 10.01 3.4341762.35762.35
TRUSTEE CASH BALANCES - MMA 12,468,069.07 199.93 0.000112,468,069.0712,468,069.07
TRUSTEE CASH BALANCES - GF 1,544.91 10.01 5.02011,544.911,544.91
12,476,747.91 100.00%
Investments
12,476,747.9112,476,747.91 1 1 0.004
Cash
(not included in yield calculations)
Passbook/Checking 9,628,518.02 1 0.00019,628,518.029,628,518.02
22,105,265.93Total Cash and Investments 22,105,265.9322,105,265.93 1 1 0.004
Current Year
August 31
37.99
Average Daily Balance
Effective Rate of Return
40,094,571.73
0.00%
Total Earnings Month Ending
This investment portfolio is in compliance with the provisions of California Government Code Section 53601 and the City of Palm Desert investment policy. Pursuant to ABX126, the availability of cash to
fund the Palm Desert RDA Successor Agency's debt service is dependent upon the County of Riverside and the State of California. All balances are bank balances. The "% of Portfolio" calculation on the
Portfolio Summary page omits demand deposits.
__________________________________________________ ____________________
Veronica Chavez, Finance Director
Portfolio RDAS
AP
Reporting period 08/01/2023-08/31/2023
Run Date: 09/20/2023 - 15:55 PM (PRF_PM1) 7.3.11No fiscal year history available
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
9/21/2023
Item 6D-97
Days to
Mat./Call
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
RIVERSIDE COUNTY POOL
1POOLED INVESTMENT FUND052470 343.41 343.41 3.86007/01/2020 343.41 Aaa052470 3.860
343.41343.41343.41343.41Subtotal and Average 1 3.860
CAMP
1C.A.M.P. POOL (RDA S.A.)578 6,028.17 6,028.17 5.5206,028.17SYS578 5.520
6,028.176,028.176,028.176,000.96Subtotal and Average 1 5.520
LAIF
1L.A.I.F. (RDA S.A.)604 762.35 762.35 3.43407/01/2020 762.35SYS604 3.434
762.35762.35762.35762.35Subtotal and Average 1 3.434
TRUSTEE CASH BALANCES - MMA
1U.S. BANK MONEY MARKET ACCOUNT830 0.05 0.0507/01/2020 0.05 P-1247394001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT832 0.00 0.00 0.01007/01/2020 0.00 P-1247394003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT833 1.03 1.031.03 P-1247394002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT834 414,244.01 414,244.01414,244.01 P-1247394000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT837 14.42 14.4214.42 P-1236781002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT838 0.00 0.00 0.01007/01/2020 0.00 P-1236781003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT839 7,343,275.75 7,343,275.757,343,275.75 P-1236781000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT842 0.00 0.00 0.01007/01/2020 0.00 P-1253446003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT843 7.66 7.667.66 P-1253446002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT844 2,040,491.33 2,040,491.332,040,491.33 P-1253446000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT845 0.41 0.4107/01/2020 0.41 P-1253446001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT853 2,670,011.00 2,670,011.002,670,011.00 P-1224324000-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT855 0.79 0.7907/01/2020 0.79 P-1224324001-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT856 22.55 22.5522.55 P-1224324002-U 0.000
1U.S. BANK MONEY MARKET ACCOUNT857 0.00 0.00 0.01007/01/2020 0.00 P-1224324003-U 0.010
1U.S. BANK MONEY MARKET ACCOUNT881 0.07 0.0709/01/2020 0.07 P-1236781001-U 0.000
12,468,069.0712,468,069.0712,468,069.0712,468,067.36Subtotal and Average 1 0.000
TRUSTEE CASH BALANCES - GF
1GOLDMAN SACHS GOVERNMENT FUND811 1,544.91 1,544.91 5.0201,544.91 Aaa277861000-G 5.020
1GOLDMAN SACHS GOVERNMENT FUND812 0.00 0.00 0.0300.00 Aaa277861001-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND813 0.00 0.00 0.03007/01/2020 0.00 Aaa277861002-G 0.030
1GOLDMAN SACHS GOVERNMENT FUND814 0.00 0.00 0.03007/01/2020 0.00 Aaa277861003-G 0.030
Portfolio RDAS
AP
Run Date: 09/20/2023 - 15:55 PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-98
Days to
Mat./Call
Page 2
Par Value Book Value
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
1,544.911,544.911,544.911,544.91Subtotal and Average 1 5.020
40,094,571.73 12,476,747.91 1 0.00412,476,747.91 12,476,747.91Total and Average
Portfolio RDAS
AP
Run Date: 09/20/2023 - 15:55 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-99
Days to
Mat./Call
Page 3
Par Value Book Value
Stated
RateMarket Value
August 31, 2023
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
RDA SUCCESSOR AGENCY
YTM/C
365Moody'sCUSIPInvestment #
Purchase
Date
CHECKING ACCOUNTS
1RDA SUCCESSOR AGENCY582 0.00 0.000.00SYS582 0.000
1RDA SUCCESSOR AGENCYRDA106 9,622,988.82 9,622,988.8206/01/2023 9,622,988.82SYS4021 0.000
1RDA SUCCESSOR AGENCYWFRDA899 5,529.20 5,529.2008/01/2023 5,529.20 AaSYS899 0.000
0.00
40,094,571.73 22,105,265.93 1 0.004
1Average Balance
22,105,265.93 22,105,265.93Total Cash and Investments
Portfolio RDAS
AP
Run Date: 09/20/2023 - 15:55 PM (PRF_PM2) 7.3.11
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-100
CITY OF PALM DESERT
ACCOUNT STATEMENT
For the Month Ending
August 31, 2023
Customer Service
PO Box 11813
Harrisburg, PA 17108-1813
Contents
Cover/Disclosures
Summary Statement
Individual Accounts
CITY OF PALM DESERT
MITCHELL ARBAUGH
73-510 FRED WARING DR
PALM DESERT, CA 92260
Client Management Team
Accounts included in Statement
553-00 CITY OF PALM DESERT
553-04 DESERT WILLOW GOLF RESORT
553-06 PALM DESERT HOUSING AUTHORITY
553-08 RDA SUCCESSOR AGENCY -- PALM DESERT
www.camponline.comOnline Access 1-800-729-7665Customer Service
Important Messages
CAMP will be closed on 09/04/2023 for Labor Day.
CAMP will be closed on 10/09/2023 for Columbus Day.
Jeremy King
Key Account Manager
213 Market Street
Harrisburg, PA 17101-2141
1-800-729-7665
kingj@pfmam.com
Rachael Miller
Client Consultant
213 Market Street
Harrisburg, PA 17101-2141
1-800-729-7665
millerr@pfmam.com
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-101
For the Month Ending August 31, 2023
Account Statement
Important Disclosures
Important Disclosures
365 and dividing the result by 7. The yields quoted should not be considered a
representation of the yield of the fund in the future, since the yield is not fixed.
Average maturity represents the average maturity of all securities and
investments of a portfolio, determined by multiplying the par or principal value of
each security or investment by its maturity (days or years), summing the
products, and dividing the sum by the total principal value of the portfolio. The
stated maturity date of mortgage backed or callable securities are used in this
statement. However the actual maturity of these securities could vary depending
on the level or prepayments on the underlying mortgages or whether a callable
security has or is still able to be called.
Monthly distribution yield represents the net change in the value of one share
(normally $1.00 per share) resulting from all dividends declared during the month
by a fund expressed as a percentage of the value of one share at the beginning
of the month. This resulting net change is then annualized by multiplying it by
365 and dividing it by the number of calendar days in the month.
YTM at Cost The yield to maturity at cost is the expected rate of return, based
on the original cost, the annual interest receipts, maturity value and the time
period from purchase date to maturity, stated as a percentage, on an annualized
basis.
YTM at Market The yield to maturity at market is the rate of return, based on the
current market value, the annual interest receipts, maturity value and the time
period remaining until maturity, stated as a percentage, on an annualized basis.
Managed Account A portfolio of investments managed discretely by PFMAM
according to the client’s specific investment policy and requirements. The
investments are directly owned by the client and held by the client’s custodian.
Unsettled Trade A trade which has been executed however the final
consummation of the security transaction and payment has not yet taken place.
Please review the detail pages of this statement carefully. If you think your
statement is wrong, missing account information, or if you need more information
about a transaction, please contact PFMAM within 60 days of receipt. If you have
other concerns or questions regarding your account, or to request an updated
copy of PFMAM's current disclosure statement, please contact a member of your
client management team at PFMAM Service Operations at the address below.
PFM Asset Management LLC
Attn: Service Operations
213 Market Street
Harrisburg, PA 17101
NOT FDIC INSURED NO BANK GUARANTEE MAY LOSE VALUE
This statement is for general information purposes only and is not intended to provide
specific advice or recommendations. PFM Asset Management LLC ("PFMAM") is an
investment adviser registered with the U.S. Securities and Exchange Commission and a
subsidiary of U.S. Bancorp Asset Management, Inc. ("USBAM"). USBAM is a subsidiary
of U.S. Bank National Association ("U.S. Bank"). U.S. Bank is a separate entity and
subsidiary of U.S. Bancorp. U.S. Bank is not responsible for and does not guarantee the
products, services or performance of PFMAM. PFMAM maintains a written disclosure
statement of our background and business experience. If you would like to receive a
copy of our current disclosure statement, please contact Service Operations at the
address below.
Proxy Voting PFMAM does not normally receive proxies to vote on behalf of its clients.
However, it does on occasion receive consent requests. In the event a consent request
is received the portfolio manager contacts the client and then proceeds according to
their instructions. PFMAM’s Proxy Voting Policy is available upon request by contacting
Service Operations at the address below.
Questions About an Account PFMAM’s monthly statement is intended to detail our
investment advisory activity as well as the activity of any accounts held by clients in
pools that are managed by PFMAM. The custodian bank maintains the control of assets
and executes (i.e., settles) all investment transactions. The custodian statement is the
official record of security and cash holdings and transactions. PFMAM recognizes that
clients may use these reports to facilitate record keeping and that the custodian bank
statement and the PFMAM statement should be reconciled and differences resolved.
Many custodians use a settlement date basis which may result in the need to reconcile
due to a timing difference.
Account Control PFMAM does not have the authority to withdraw funds from or deposit
funds to the custodian outside the scope of services provided by PFMAM. Our clients
retain responsibility for their internal accounting policies; implementing and enforcing
internal controls and generating ledger entries or otherwise recording transactions.
Market Value Generally, PFMAM’s market prices are derived from closing bid prices as
of the last business day of the month as supplied by Refinitiv or Bloomberg. For certain
short-term investments or where prices are not available from generally recognized
sources the securities are priced using a yield-based matrix system to arrive at an
estimated market value. Prices that fall between data points are interpolated.
Non-negotiable FDIC-insured bank certificates of deposit are priced at par. Although
PFMAM believes the prices to be reliable, the values of the securities may not represent
the prices at which the securities could have been bought or sold. Explanation of the
valuation methods for a registered investment company or local government investment
program is contained in the appropriate fund offering documentation or information
statement.
Amortized Cost The original cost of the principal of the security is adjusted for the
amount of the periodic reduction of any discount or premium from the purchase date
until the date of the report. Discount or premium with respect to short term securities
(those with less than one year to maturity at time of issuance) is amortized on a
straightline basis. Such discount or premium with respect to longer term securities is
amortized using the constant yield basis.
Tax Reporting Cost data and realized gains / losses are provided for informational
purposes only. Please review for accuracy and consult your tax advisor to determine
the tax consequences of your security transactions. PFMAM does not report such
information to the IRS or other taxing authorities and is not responsible for the
accuracy of such information that may be required to be reported to federal, state or
other taxing authorities.
Financial Situation In order to better serve you, PFMAM should be promptly notified
of any material change in your investment objective or financial situation.
Callable Securities Securities subject to redemption prior to maturity may be
redeemed in whole or in part before maturity, which could affect the yield represented.
Portfolio The securities in this portfolio, including shares of mutual funds, are not
guaranteed or otherwise protected by PFMAM, the FDIC (except for certain
non-negotiable certificates of deposit) or any government agency. Investment in
securities involves risks, including the possible loss of the amount invested. Actual
settlement values, accrued interest, and amortized cost amounts may vary for
securities subject to an adjustable interest rate or subject to principal paydowns. Any
changes to the values shown may be reflected within the next monthly statement’s
beginning values.
Rating Information provided for ratings is based upon a good faith inquiry of selected
sources, but its accuracy and completeness cannot be guaranteed.
Shares of some local government investment programs and TERM funds are
marketed through representatives of PFMAM's affiliate, PFM Fund Distributors, Inc.
which is registered with the SEC as a broker/dealer and is a member of the Financial
Industry Regulatory Authority (“FINRA”) and the Municipal Securities Rulemaking
Board (“MSRB”). You may reach the FINRA by calling the FINRA Hotline at
1-800-289-9999 or at the FINRA website address
https://www.finra.org/investors/investor-contacts. A brochure describing the FINRA
Regulation Public Disclosure Program is also available from FINRA upon request.
Key Terms and Definitions
Dividends on local government investment program funds consist of interest earned,
plus any discount ratably amortized to the date of maturity, plus all realized gains and
losses on the sale of securities prior to maturity, less ratable amortization of any
premium and all accrued expenses to the fund. Dividends are accrued daily and may
be paid either monthly or quarterly. The monthly earnings on this statement represent
the estimated dividend accrued for the month for any program that distributes earnings
on a quarterly basis. There is no guarantee that the estimated amount will be paid on
the actual distribution date.
Current Yield is the net change, exclusive of capital changes and income other than
investment income, in the value of a hypothetical fund account with a balance of one
share over the seven-day base period including the statement date, expressed as a
percentage of the value of one share (normally $1.00 per share) at the beginning of
the seven-day period. This resulting net change in account value is then annualized by
multiplying it by
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-102
For the Month Ending August 31, 2023
Account Statement
Consolidated Summary Statement
CITY OF PALM DESERT
Investment Allocation
Investment Type Closing Market Value Percent
230,943,664.87 100.00 Joint Powers Authority
$230,943,664.87 Total 100.00%
Portfolio Summary
and Income
Closing
Market Value
Current
Portfolio Holdings
Cash Dividends
Yield
CAMP Pool 1,038,014.34 230,943,664.87 5.54 %
$1,038,014.34 $230,943,664.87 Total
Maturity Distribution (Fixed Income Holdings)
Portfolio Holdings Closing Market Value Percent
230,943,664.87
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
100.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Under 30 days
31 to 60 days
61 to 90 days
91 to 180 days
181 days to 1 year
1 to 2 years
2 to 3 years
3 to 4 years
4 to 5 years
Over 5 years
Total $230,943,664.87
1
100.00%
Weighted Average Days to Maturity
Sector Allocation
100.00%
Joint Powers
Authority
Summary Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-103
For the Month Ending August 31, 2023
Account Statement
Consolidated Summary Statement
CITY OF PALM DESERT
and Income
Closing Market
Value
Change in
Value Trades MaturitiesDeposits ValueAccount Name
Account
Number
Cash DividendsUnsettled Redemptions / Sales/Purchases /Opening Market
553-00 155,135,651.23 20,778,689.21 0.00 0.00 175,914,340.44 0.00 778,689.21 CITY OF PALM DESERT
553-04 4,373,489.69 19,588.94 (750,000.00) 0.00 3,643,078.63 0.00 19,588.94 DESERT WILLOW GOLF RESORT
553-06 51,140,509.56 239,708.07 0.00 0.00 51,380,217.63 0.00 239,708.07 PALM DESERT HOUSING
AUTHORITY
553-08 6,000.05 28.12 0.00 0.00 6,028.17 0.00 28.12 RDA SUCCESSOR AGENCY -- PALM
DESERT
$210,655,650.53 $21,038,014.34 ($750,000.00)$0.00 $230,943,664.87 $1,038,014.34 Total $0.00
Summary Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-104
For the Month Ending August 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - CITY OF PALM DESERT - 553-00
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
155,135,651.23
20,778,689.21
0.00
0.00
$175,914,340.44
CAMP Pool
Unsettled Trades 0.00
778,689.21 Cash Dividends and Income
August 31, 2023 July 31, 2023
Asset Summary
CAMP Pool 175,914,340.44 155,135,651.23
$175,914,340.44 $155,135,651.23 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-00 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-105
For the Month Ending August 31, 2023Account Statement
CITY OF PALM DESERT - CITY OF PALM DESERT - 553-00
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
155,135,651.23 Opening Balance
08/15/23 08/15/23 Purchase - Incoming Wires 1.00 20,000,000.00 175,135,651.23
08/31/23 09/01/23 Accrual Income Div Reinvestment - Distributions 1.00 778,689.21 175,914,340.44
175,914,340.44
175,914,340.44
175,914,340.44
166,128,512.17
4,687,874.32
0.00
0.00
125,687,874.32
50,226,466.12
778,689.21
175,914,340.44
0.00
0.00
20,778,689.21
155,135,651.23
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
August January-August
5.52%
Account 553-00 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-106
For the Month Ending August 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT - 553-04
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
4,373,489.69
19,588.94
(750,000.00)
0.00
$3,643,078.63
CAMP Pool
Unsettled Trades 0.00
19,588.94 Cash Dividends and Income
August 31, 2023 July 31, 2023
Asset Summary
CAMP Pool 3,643,078.63 4,373,489.69
$3,643,078.63 $4,373,489.69 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-04 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-107
For the Month Ending August 31, 2023Account Statement
CITY OF PALM DESERT - DESERT WILLOW GOLF RESORT - 553-04
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
4,373,489.69 Opening Balance
08/24/23 08/24/23 Redemption - Outgoing Wires 1.00 (750,000.00) 3,623,489.69
08/31/23 09/01/23 Accrual Income Div Reinvestment - Distributions 1.00 19,588.94 3,643,078.63
3,643,078.63
3,643,078.63
3,643,078.63
4,180,573.20
124,292.49
0.00
(750,000.00)
2,124,292.49
2,268,786.14
19,588.94
3,643,078.63
0.00
(750,000.00)
19,588.94
4,373,489.69
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
August January-August
5.52%
Account 553-04 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-108
For the Month Ending August 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY - 553-06
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
51,140,509.56
239,708.07
0.00
0.00
$51,380,217.63
CAMP Pool
Unsettled Trades 0.00
239,708.07 Cash Dividends and Income
August 31, 2023 July 31, 2023
Asset Summary
CAMP Pool 51,380,217.63 51,140,509.56
$51,380,217.63 $51,140,509.56 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-06 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-109
For the Month Ending August 31, 2023Account Statement
CITY OF PALM DESERT - PALM DESERT HOUSING AUTHORITY - 553-06
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
51,140,509.56 Opening Balance
08/31/23 09/01/23 Accrual Income Div Reinvestment - Distributions 1.00 239,708.07 51,380,217.63
51,380,217.63
51,380,217.63
51,380,217.63
51,148,242.08
1,690,957.50
0.00
0.00
1,690,957.50
49,689,260.13
239,708.07
51,380,217.63
0.00
0.00
239,708.07
51,140,509.56
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
August January-August
5.52%
Account 553-06 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-110
For the Month Ending August 31, 2023Account Statement - Transaction Summary
CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT - 553-08
Opening Market Value
Purchases
Redemptions
Change in Value
Closing Market Value
6,000.05
28.12
0.00
0.00
$6,028.17
CAMP Pool
Unsettled Trades 0.00
28.12 Cash Dividends and Income
August 31, 2023 July 31, 2023
Asset Summary
CAMP Pool 6,028.17 6,000.05
$6,028.17 $6,000.05 Total
Asset Allocation
100.00%
CAMP Pool
Account 553-08 Page 1
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-111
For the Month Ending August 31, 2023Account Statement
CITY OF PALM DESERT - RDA SUCCESSOR AGENCY -- PALM DESERT - 553-08
Total Settlement Dollar AmountShare or Trade
Shares OwnedDate Transaction Description of TransactionUnit PriceDate
CAMP Pool
6,000.05 Opening Balance
08/31/23 09/01/23 Accrual Income Div Reinvestment - Distributions 1.00 28.12 6,028.17
6,028.17
6,028.17
6,028.17
6,000.96
198.38
0.00
0.00
198.38
5,829.79
28.12
6,028.17
0.00
0.00
28.12
6,000.05
Monthly Distribution Yield
Average Monthly Balance
Closing Balance
Fiscal YTDMonth of
Cash Dividends and Income
Closing Balance
Check Disbursements
Redemptions (Excl. Checks)
Purchases
Opening Balance
Closing Balance
August January-August
5.52%
Account 553-08 Page 2
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-112
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
September 12, 2023
LAIF Home
PMIA Average Monthly
Yields
CITY OF PALM DESERT
CITY TREASURER
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260-2578
Account Number: 98-33-621
August 2023 Statement
Tran Type Definitions
Effective
Date
Transaction
Date
Tran
Type Confirm
Number
Web
Confirm
Number Authorized Caller Amount
8/14/2023 8/10/2023 RW 1737422 1697813 JAMES BOUNDS -20,000,000.00
Account Summary
Total Deposit:0.00 Beginning Balance:20,817,543.64
Total Withdrawal:-20,000,000.00 Ending Balance:817,543.64
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-113
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
September 12, 2023
LAIF Home
PMIA Average Monthly
Yields
PALM DESERT HOUSING AUTHORITY
CITY TREASURER
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260-2578
Account Number: 25-33-003
August 2023 Statement
Tran Type Definitions
Account Summary
Total Deposit:0.00 Beginning Balance:998,018.16
Total Withdrawal:0.00 Ending Balance:998,018.16
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-114
Local Agency Investment Fund
P.O. Box 942809
Sacramento, CA 94209-0001
(916) 653-3001
September 12, 2023
LAIF Home
PMIA Average Monthly
Yields
S/A TO THE PALM DESERT REDEVELOPMENT
AGENCY
FINANCE DIRECTOR
73-510 FRED WARING DRIVE
PALM DESERT, CA 92260-2578
Account Number: 65-33-023
August 2023 Statement
Tran Type Definitions
Account Summary
Total Deposit:0.00 Beginning Balance:762.35
Total Withdrawal:0.00 Ending Balance:762.35
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-115
Parameters:Query: Fund Summary
County of Riverside Treasurer-Tax CollectorFund Summary Report
Bank: oneof
Account Number: oneof 052460, 052470
Counterparty: equalto
Run Date:06-Sep-2023 07:58:47 AM User:Susan
From :
To :
As at :
01-Aug-2023
31-Aug-2023
06-Sep-2023
Balance Calculation Based On:Value Date
TotalBalance Forward Totaltrans_typeAccount NameAccount Numbe Balance ForwardAccount NameAccount Number Total ReceiptsTotal Receipts Total PaymentsTotal Payments
City Of Palm Desert052460 $2,697,698.66 $0.00 $0.00 $2,697,698.66
RDA Successor Agcy Palm Desert052470 $343.41 $0.00 $0.00 $343.41
Grand Total:$2,698,042.07 $0.00 $0.00 $2,698,042.07
Printed on 9/6/2023 Page 1 of 1End of Report
DocuSign Envelope ID: 4996490F-8376-4CD6-AD9B-EFA1A6277B2E
Item 6D-116
CITY OF PALM DESERT
ATTENDANCE REPORT
Advisory Body:
Prepared By:
Year 2022 2022 2023 2023 2023 2023 2023
Month Oct Nov Jan Mar May Jul Sep
Date 25-Oct 22-Nov 24-Jan 28-Mar 31-May N/A 26-Sep
Alexander, Karen A P A P A -3 3
Garcia, Carlos P P P P P -0 0
Leo, Robert P P P P P -0 0
Messenger, Faith P A A P P -2 2
Wuest, Jake P P P P P -0 0
Harnik, Jan*P P N/A N/A N/A -0 0
Jonathan, Sabby*P A N/A N/A N/A -1 1
Kelly, Kathleen*N/A N/A P P P -0 0
Quintanilla, Karina*N/A N/A P P A -1 1
Palm Desert Municipal Code 2.34.010:
P Present
A Absent
E Excused
-No meeting
Bimonthly: Two unexcused absences from regular meetings in any twelve-month period shall constitute an automatic
resignation of members holding office on boards that meet bimonthly.
Total
Absences
Total
Unexcused
Absences
Finance Committee
Michelle Nance
* Mayor and Mayor Pro Tem rotating positions are voting members of this Committee
Item 7G-1