HomeMy WebLinkAboutPackets - Budget and Finance Committee (26)
AGENDA
BUDGET AND FINANCE COMMISSION
REGULAR SESSION
SEPTEMBER 21, 2021
ORO VALLEY COUNCIL CHAMBERS
11000 N. LA CAÑADA DRIVE
REGULAR SESSION AT OR AFTER 4:00 PM
CALL TO ORDER
ROLL CALL
PLEDGE OF ALLEGIANCE
CALL TO AUDIENCE - at this time, any member of the public is allowed to address the Commission on any
issue not listed on today’s agenda. Pursuant to the Arizona open meeting law, individual Commission
members may ask Town staff to review the matter, ask that the matter be placed on a future agenda, or
respond to criticism made by speakers. However, the Commission may not discuss or take legal action on
matters raised during "Call to Audience." In order to speak during "Call to Audience", please specify what
you wish to discuss when completing the blue speaker card.
STAFF LIAISON REPORT
REGULAR SESSION AGENDA
1.REVIEW AND APPROVAL OF THE JUNE 15, 2021 REGULAR SESSION MEETING MINUTES
2.TOWN OF ORO VALLEY FY 20/21 FINANCIAL UPDATE THROUGH JUNE 2021 (Please reference the
attachments for the Town's monthly financial update)
COUNCIL LIAISON COMMENTS
FUTURE AGENDA ITEMS
ADJOURNMENT
POSTED: 9/16/21 at 5 pm. by P.P.
When possible, a packet of agenda materials as listed above is available for public inspection at least 24 hours
prior to the Commission meeting in the Town Clerk's Office between the hours of 8:00 a.m. – 5:00 p.m.
The Town of Oro Valley complies with the Americans with Disabilities Act (ADA). If any person with a disability
needs any type of accommodation, please notify the Town Clerk’s Office at least five days prior to the Commission
meeting at 229-4700.
INSTRUCTIONS TO SPEAKERS
Members of the public have the right to speak during any posted public hearing. However, those items not
listed as a public hearing are for consideration and action by the Commission during the course of their
business meeting. Members of the public may be allowed to speak on these topics at the discretion of the
Chair.
If you wish to address the Commission on any item(s) on this agenda, please complete a blue speaker card located
on the Agenda table at the back of the room and give it to the Recording Secretary. Please indicate on the
speaker card which item number and topic you wish to speak on, or if you wish to speak during “Call to
Audience,” please specify what you wish to discuss when completing the blue speaker card.
Please step forward to the podium when the Chair announces the item(s) on the agenda which you are interested
in addressing.
1. For the record, please state your name and whether or not you are a Town resident.
2. Speak only on the issue currently being discussed by the Commission. Please organize your speech, you will
only be allowed to address the Commission once regarding the topic being discussed.
3. Please limit your comments to 3 minutes.
4. During “Call to Audience”, you may address the Commission on any issue you wish.
5. Any member of the public speaking must speak in a courteous and respectful manner to those present.
In accordance with the Pima County Health Department’s most recent health advisory, the Town
respectfully asks all in-person meeting attendees, regardless of vaccination status, to please wear a mask
while indoors. COVID-19 remains a fluid situation, and the Town will adjust its safety guidelines in
accordance with any future health advisories from the Health Department.
Thank you for your cooperation.
“Notice of Possible Quorum of the Oro Valley Town Council, Boards, Commissions and Committees: In accordance
with Chapter 3, Title 38, Arizona Revised Statutes and Section 2-4-4 of the Oro Valley Town Code, a majority of the
Town Council, Board of Adjustment, Historic Preservation Commission, Parks and Recreation Advisory Board,
Stormwater Utility Commission, and Water Utility Commission may attend the above referenced meeting as a
member of the audience only.”
Budget and Finance Commission 1.
Meeting Date:09/21/2021
Submitted By:Alison Cote, Legal
SUBJECT:
REVIEW AND APPROVAL OF THE JUNE 15, 2021 REGULAR SESSION MEETING MINUTES
RECOMMENDATION:
Staff recommends approval
EXECUTIVE SUMMARY:
N/A
BACKGROUND OR DETAILED INFORMATION:
N/A
FISCAL IMPACT:
N/A
SUGGESTED MOTION:
I MOVE to approve (approve with changes) the June 15, 2021 regular session meeting minutes
Attachments
Draft Minutes - 6/15/21
D R A F T
MINUTES
BUDGET AND FINANCE COMMISSION
REGULAR SESSION
JUNE 15, 2021
ONLINE ZOOM MEETING
REGULAR SESSION AT OR AFTER 4:00 PM
CALL TO ORDER - Chair Latchford called the meeting to order at 4:00 P.M.
ROLL CALL
Present: John Latchford, Chairman
Cathy Solverson, Vice Chairman
Michael Mason, Commissioner
James Beasley, Commissioner
Absent:David Newell, Commissioner
Staff Present:David Gephart, Chief Financial Officer
Michael Dyckman, Senior Budget Analyst
Wendy Gomez, Finance and Budget Administrator
Tobin Sidles, Legal Services Director
PLEDGE OF ALLEGIANCE - Chair Latchford led the group in the Pledge of Allegiance.
CALL TO AUDIENCE - No comments were received.
STAFF LIAISON REPORT
Chief Financial Officer David Gephart discussed the following:
- the budget adoption by the Town Council at the next council meeting
- the update of the Town's bond rating with Standard & Poors
- bond issuance for PSPRS pension funding
- pension funding policy to be presented to Town Council for approval
- interviews to be held for a senior accountant position
- ARPA grant funds increased
- whether or not the commission should meet in July and August
REGULAR SESSION AGENDA
1.REVIEW AND APPROVAL OF THE MAY 17, 2021 REGULAR SESSION MEETING MINUTES
Motion by Vice Chairman Cathy Solverson, seconded by Commissioner Michael Mason to approve the
May 17, 2021 minutes as written.
Vote: 4 - 0 Carried
2.PRESENTATION AND POSSIBLE DISCUSSION OF THE TOWN'S FY 20/21 FINANCIAL UPDATE
THROUGH APRIL 2021
Senior Budget Analyst Michael Dyckman presented on the Town's FY 20/21 Financial Update through
April 2021.
Discussion ensued amongst staff and commissioners regarding Agenda Item #2.
3.PRESENTATION AND POSSIBLE DISCUSSION OF THE FIVE-YEAR FINANCIAL FORECAST
THROUGH FY 2026/27
Finance and Budget Administrator Wendy Gomez presented on the Five-Year Financial Forecast
Through FY 26/27.
Discussion ensued amongst staff and commissioners regarding Agenda Item #3.
COUNCIL LIAISON COMMENTS
The council liaison was not present.
FUTURE AGENDA ITEMS
- the status of Marketplace on Town Revenue
- status or general update of other pension plan
- commissioners agreed to take July and August off and meet again on September 21, 2021 at 4:00 PM
ADJOURNMENT
Motion by Commissioner James Beasley, seconded by Commissioner Michael Mason to adjourn the
meeting at 5:29 P.M.
Vote: 4 - 0 Carried
I hereby certify that the foregoing minutes are a true and correct copy of the minutes of the regular session of the
Town of Oro Valley Budget and Finance Commission of Oro Valley, Arizona held on the 15th day of June, 2021. I
further certify that the meeting was duly called and held and that a quorum was present.
Dated this 17th day of June, 2021.
___________________________
Alison Cote
Legal Secretary
Budget and Finance Commission 2.
Meeting Date:09/21/2021
Requested by: David Gephart, Finance Submitted By:Michael Dyckman, Finance
SUBJECT:
TOWN OF ORO VALLEY FY 20/21 FINANCIAL UPDATE THROUGH JUNE 2021 (Please reference the
attachments for the Town's monthly financial update)
RECOMMENDATION:
N/A
EXECUTIVE SUMMARY:
Please see attachments.
BACKGROUND OR DETAILED INFORMATION:
Please see attachments.
FISCAL IMPACT:
N/A
SUGGESTED MOTION:
N/A
Attachments
Memo
Attachment A - General Fund
Attachment B - Highway Fund
Attachment C1 - Community Center Fund
Attachment C2 - Cash Flow Statement
Attachment E - General Fund Sales Tax
Attachment F - General Fund State Shared Revenues
Attachment D - Summary All Funds
Oro Valley, it’s in our nature.
www.orovalleyaz.gov
11000 N. La Cañada Drive • Oro Valley, Arizona 85737
phone: (520) 229-4700 • fax: (520) 229-0428
Town Manager’s Office
M E M O R A N D U M
TO: Budget & Finance Commission
FROM: Mary Jacobs, Town Manager
David Gephart, Chief Financial Officer
DATE: September 21, 2021
SUBJECT: June 2021 Financial Update
This financial report is intended to provide an overview and status of revenues and expenditures
for the Town’s selected funds through FY 20/21 (July 2020 – June 2021). Funds included in this
financial update are the General Fund, Highway Fund and Community Center Fund. All amounts
are preliminary, un-audited and subject to change based upon adjusting entries, as necessary.
EXECUTIVE SUMMARY:
The Town has thus far successfully navigated the challenges posed by the COVID -19 pandemic.
Staff is pleased to report that financial performance across all funds has exceeded expectations.
Revenues are strong, especially for single-family residential permits and construction sales taxes
due to a strong housing market, as well as retail and online sales tax c ollections. There are also
indications of improvement in restaurant/bar and bed tax collections .
General Fund
Overall, General Fund revenues and expenditures ended the fiscal year better than originally
forecasted (See Attachment A). Due to strong local s ales taxes, permit fee revenues , as well as
federal aid from the CARES Act and American Rescue Plan Act, revenues total $56.9 million or
131.2% of budget. Combined with expenditures ending the fiscal year 5.7% below budget at $42.0
million, the General Fund preliminarily ended the fiscal year with a surplus of approximately $14.9
million.
Highway Fund
Revenues and expenditures for the Highway Fund ended the fiscal year better than originally
budgeted (See Attachment B). Revenues totaled approximately $3.8 million or 102.1% of budget,
while expenditures only totaled $3.4 million or 86.8% of budget. The Highway Fund preliminarily
ended the fiscal year with a surplus of $424,000.
Community Center Fund
Overall, year-end revenues and expenditures for the Community Center Fund performed better
than budgeted figures (See Attachment C-1 & C-2). Revenues totaled $7.6 million or 106.8% of
budget, while expenditures totaled $5.8 million or 83.9% of budget. Due to increased half-cent
sales tax collections and CIP project roll-over, the Community Center Fund preliminarily ended
the fiscal year with a surplus of $1.8 million.
BACKGROUND AND DETAILED INFORMATION:
GENERAL FUND
Attachment A shows General Fund revenues and expenditures through June 30, 2021, The
preliminary year-end amounts for the General Fund are as follows:
Revenues: $56,888,739
Less:
Expenditures: ($42,037,914)
Preliminary Estimated Change in Fund Balance: $14,850,825 *
*The adopted fiscal year 2020/21 budgeted change in fund balance is $(1,225,025)
General Fund Revenues
• Local sales tax collections in the General Fund totaled $21.8 million or 120.4% of the
budget amount of $18.1 million for the fiscal year. Construction sales tax collections
totaled $4.9 million through June 30th, which exceeded the budgeted amount by $1.5
million. Despite COVID-19, retail collections in the General Fund totaled $8.0 million for
FY 20/21 and are 9.9% or $300,000 higher than the prior fiscal year . Restaurant/bar
collections and bed tax collections remained relativity flat year-over-year and ended near
budgeted levels. Due to strong collections in construction, retail and remote collections,
General Fund sales taxes preliminarily ended the fiscal year $3.7 million, or 20.4% over
budget. Please see Attachment E for detailed information on General Fund local sales tax
collections.
• License and permit revenues totaled $3.3 million or 208.8% of the budget amount of $1.6
million for the fiscal year. Total Single Family Residential (SFR) permits issued for the
fiscal year were 498 and represent a large portion of this revenue. For reference, last fiscal
year, the Town had issued 275 SFR permits . Commercial permit revenue is another large
portion of this category and includes large one-time permit revenues .
• State shared revenues , which include shared sales tax, income tax and auto-lieu fees,
total $14.4 million or 109.4% of the budget amount of $13.2 million for the fiscal year. Both
state shared sales taxes and auto-lieu fees saw higher than expected collections
throughout the fiscal year. Please see Attachment F for detailed information on General
Fund state shared revenue collections.
• Other intergovernmental revenues include RTA reimbursements for transit services,
school resource officers, and animal control revenues. Preliminary year-end totals are
$1.2 million or 71.3% of budget. This is mainly due to reduced ridership demand as a
result of COVID-19, which caus ed reductions in RTA transit reimbursements.
• Charges for services revenues totaled $2.0 million or 88.9% of the budget amount of $2.2
million for the fiscal year. A large portion of these revenues are associated with Parks &
Recreation programming and farebox revenues. As anticipated, these revenues were
impact by COVID-19, but were starting to see recovery towards the end of the fiscal year .
• Federal grant revenues totaled $13.4 million for the fiscal year. This figure includes the
Town’s allotted $5.3 million of AZ Cares funding as well as the first of two receipts of the
American Rescue Plan Act which is approximately $7.7 million. The remaining amounts
are smaller grants related to public safety.
General Fund Expenditures
• General Fund expenditures ended the fiscal year below budget by about $2.5 million, or
5.7%. This is due to personnel savings from position vacancies, O&M savings from
departments and one-time projects, as well as project carry-over into next fiscal year.
Preliminarily, the General Fund ended the fiscal year with a total fund balance of $35.8 million,
or 80.2% of budgeted expenditures.
HIGHWAY FUND
Highway Fund Revenues
• State shared highway user funds totaled $3.7 million or 107.4% of the budget amount of
$3.5 million for the fiscal year. This was anticipated as monthly distributions from the state
remained stronger than original projections.
• Budgeted s tate grant revenues were reimbursable costs by the RTA related to the La
Cholla Road widening project. As this project was substantially completed in the prior fiscal
year, there were no additional reimbursements expected. Actual amounts received are
from an RTA street light program.
Highway Fund Expenditures
• Highway Fund expenditures ended the fiscal year at $3.4 million or 86.8% of the adopted
budget of $3.9 million. The primary reasons expenditures were below budget in the
Highway Fund are due to reimbursable costs associated with the La Cholla Road widening
project, as well as project carry-over for the Lambert Lane overlay project into the new
fiscal year.
The Highway Fund preliminarily ended the fiscal year with a surplus of $424,016 and an
ending fund balance of $1.2 million.
COMMUNITY CENTER FUND
Attachment C-1 shows the consolidated financial status of the Community Center Fund with all
revenues and expenditures from the golf operator and Town-managed operations.
Attachment C-2 shows the monthly line-item detail for the contract-managed operations ,
specifically revenues and expenditures associated with the golf, food and beverage operations.
Totals in the revenue and expenditure categories in Attachment C -2 tie to the c ontracted operating
revenues and expenditures in Attachment C -1.
Community Cente r Fund Revenues
• Revenues in the Community Center Fund through June totaled $7.6 million or 106.8% of
the budget amount of $7.1 million.
• Contracted operating revenues from the golf operator totaled $4.0 million for the fiscal
year. This is approximately $725,000 or 22.3% higher than revenues from last fiscal year.
This is mainly the result of increased golf and member related revenues.
• Due to facility closures and reduced patronage from COVID-19, Town operating revenues
for the fiscal year totaled $513,000 or 53.7% of budget. Savings in Town operating costs
partially helped offset this shortfall.
• Due to strong retail and remote collections, local sales tax revenues for the fiscal year
totaled $2.9 million or 118.2% of the budget amount of $2.5 million.
Community Center Fund Expenditures
• Expenditures in the Community Center Fund totaled $5.8 million or 83.9% of the budget
amount of $6.9 million for the fiscal year.
• Contracted operating expenditures from the golf operator totaled $4.6 million, or 103.1%
of budget to end the fiscal year. The primary driver for this overage is costs related to the
Pusch Ridge course which were unbudgeted. Overall year-end contracted operating
expenditures are approximately $232,000 or 4.8% lower than costs from the prior fiscal
year, even when including unbudgeted Pusch costs .
• Budgeted c apital outlay is comprised of several minor capital items , in addition to $1.1
million for the golf course irrigation project. As construction for the irrigation project is on
hold, the bulk of this year’s budgeted project was not spent. Actual expenditures of
$140,000 account for smaller items at the community center as well as design work for
the irrigation project.
• Overall, preliminary year-end expenditures for the Community Center Fund are under
budget by $1.1 million or 16.1%. This is due to a combination of personnel, O&M, and
capital outlay savings .
• Preliminarily, the Community Center Fund ended the fiscal year with a surplus of $1.8
million and a total fund balance of $2.7 million.
The year-end sales tax support for golf operations is estimated to be $456,612. This figure
assumes ($664,688) for contracted golf operations, $125,000 in outside HOA contributions, and
$83,076 in local sales taxes generated from golf related operations.
Please see Attachments A and B for additional details on the General Fund and Hi ghway Fund.
See Attachments C-1 and C-2 for additional details on the Community Center Fund. See
Attachment D for a fiscal year-to-date consolidated summary of all Town Funds. See attachments
E and F for a breakdown of monthly local sales tax collections and state shared revenue
collections for the General Fund.
ATTACHMENT A
June YTD Financial Status
General Fund
% Budget Completion through June --- 100.0%
% Actuals YE % Variance
to Budget to Budget
REVENUES:`
LOCAL SALES TAX 21,832,073 18,128,304 120.4%21,832,073 20.4%
LICENSES & PERMITS 3,325,826 1,592,500 208.8%3,325,826 108.8%
FEDERAL GRANTS 13,356,262 5,790,969 230.6%13,356,262 130.6%
STATE GRANTS 214,154 75,000 285.5%214,154 185.5%
STATE/COUNTY SHARED 14,435,338 13,194,438 109.4%14,435,338 9.4%
OTHER INTERGOVERNMENTAL 1,192,419 1,672,000 71.3%1,192,419 -28.7%
CHARGES FOR SERVICES 1,991,889 2,239,675 88.9%1,991,889 -11.1%
FINES 135,547 125,000 108.4%135,547 8.4%
INTEREST INCOME 123,041 150,000 82.0%123,041 -18.0%
MISCELLANEOUS 282,190 262,500 107.5%282,190 7.5%
TRANSFERS IN - 120,000 0.0%- -100.0%
TOTAL REVENUES 56,888,739 43,350,386 131.2%56,888,739 31.2%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES:
CLERK 400,345 428,524 93.4%400,345 -6.6%
COMMUNITY & ECON. DEV.2,696,250 2,779,661 97.0%2,696,250 -3.0%
COUNCIL 161,901 197,019 82.2%161,901 -17.8%
FINANCE 836,613 832,888 100.4%836,613 0.4%
GENERAL ADMINISTRATION 4,928,422 5,251,466 93.8%4,928,422 -6.2%
HUMAN RESOURCES 437,350 457,347 95.6%437,350 -4.4%
INNOVATION & TECHNOLOGY 3,577,773 3,944,198 90.7%3,577,773 -9.3%
LEGAL 863,668 870,592 99.2%863,668 -0.8%
MAGISTRATE COURT 802,123 864,826 92.7%802,123 -7.3%
MANAGER 946,617 1,028,734 92.0%946,617 -8.0%
PARKS & RECREATION 3,130,364 3,478,517 90.0%3,130,364 -10.0%
POLICE 16,602,121 16,953,228 97.9%16,602,121 -2.1%
PUBLIC WORKS 4,067,847 4,898,891 83.0%4,067,847 -17.0%
TRANSFERS OUT 2,586,520 2,589,520 99.9%2,586,520 -0.1%
TOTAL EXPENDITURES 42,037,914 44,575,411 94.3%42,037,914 -5.7%
SURPLUS / (DEFICIT)14,850,825 (1,225,025) 14,850,825
BEGINNING FUND BALANCE 20,899,548
Plus: Surplus / (Deficit)14,850,825
ENDING FUND BALANCE **35,750,373
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
FY 2020/2021
Year End
Estimate *
Budget Year End
Estimate *
Actuals
thru 06/2021
Actuals
thru 06/2021
Budget
ATTACHMENT B
June YTD Financial Status FY 2020/2021
% Budget Completion through June --- 100.0%
Actuals
thru 06/2021 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
REVENUES:
LICENSES & PERMITS 37,108 25,000 148.4%37,108 48.4%
STATE GRANTS 16,588 210,000 7.9%16,588 -92.1%
STATE/COUNTY SHARED 3,714,572 3,458,929 107.4%3,714,572 7.4%
INTEREST INCOME 1,022 5,000 20.4%1,022 -79.6%
MISCELLANEOUS 7,542 2,000 377.1%7,542 277.1%
TOTAL REVENUES 3,776,832 3,700,929 102.1%3,776,832 2.1%
Actuals
thru 06/2021 Budget % Actuals
to Budget
Year End
Estimate *
YE % Variance
to Budget
EXPENDITURES:
TRANSPORTATION ENGINEERING 3,046,525 3,512,881 86.7%3,046,525 -13.3%
STREET MAINTENANCE 306,291 348,220 88.0%306,291 -12.0%
TOTAL EXPENDITURES 3,352,816 3,861,101 86.8%3,352,816 -13.2%
SURPLUS / (DEFICIT)424,016 (160,172) 424,016
BEGINNING FUND BALANCE 818,962
Plus: Surplus / (Deficit)424,016
ENDING FUND BALANCE **1,242,978
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
-
Highway Fund
ATTACHMENT C-1
June YTD Financial Status
% Budget Completion through June --- 100.0%
% Actuals YE % Variance
to Budget to Budget
REVENUES:
CONTRACTED OPERATING REVENUES
Golf Revenues, Trail and Cart Fees 2,298,066 1,567,840 146.6%2,298,066 46.6%
Member Dues 1,021,503 850,000 120.2%1,021,503 20.2%
Food & Beverage 448,780 760,776 59.0%448,780 -41.0%
Merchandise & Other 202,516 325,933 62.1%202,516 -37.9%
3,970,865 3,504,548 113.3%3,970,865 13.3%
TOWN OPERATING REVENUES
Daily Drop-Ins 31,289 30,000 104.3%31,289 4.3%
Member Dues 343,628 707,000 48.6%343,628 -51.4%
Recreation Programs 86,696 160,000 54.2%86,696 -45.8%
Swim Team/Swim Lessons - 8,000 0.0%- -100.0%
Facility Rental Income 51,215 50,500 101.4%51,215 1.4%
Concession Sales 129 100 129.0%129 29.0%
512,957 955,600 53.7%512,957 -46.3%
OTHER REVENUES
Local Sales Tax 2,947,420 2,492,960 118.2%2,947,420 18.2%
Real Property Rental Income 19,502 19,502 100.0%19,502 0.0%
Interest Income 4,454 1,000 445.4%4,454 345.4%
Miscellaneous 127,060 125,000 0.0%127,060 1.6%
3,098,436 2,638,462 117.4%3,098,436 17.4%
TOTAL REVENUES 7,582,258 7,098,610 106.8%7,582,258 6.8%
% Actuals YE % Variance
to Budget to Budget
EXPENDITURES:
CONTRACTED OPERATING EXPENDITURES
Personnel 1,425,099 1,687,606 84.4%1,425,099 -15.6%
Operations & Maintenance 2,956,482 2,513,430 117.6%2,956,482 17.6%
Capital Equipment Purchases 53,873 - 0.0%53,873 0.0%
Equipment Leases 200,099 294,792 67.9%200,099 -32.1%
4,635,553 4,495,828 103.1%4,635,553 3.1%
TOWN OPERATING EXPENDITURES
Personnel 711,610 762,713 93.3%711,610 -6.7%
Operations & Maintenance 128,367 216,037 59.4%128,367 -40.6%
839,977 978,750 85.8%839,977 -14.2%
CAPITAL OUTLAY 139,657 1,124,500 12.4%139,657 -87.6%
TRANSFERS OUT 158,302 278,302 56.9%158,302 -43.1%
TOTAL EXPENDITURES 5,773,489 6,877,380 83.9%5,773,489 -16.1%
SURPLUS / (DEFICIT)1,808,769 221,230 1,808,769
BEGINNING FUND BALANCE 862,818
Plus: Surplus / (Deficit)1,808,769
ENDING FUND BALANCE **2,671,587
* Year-end estimates are subject to further revision
** Ending fund balance amounts are estimates and are subject to further revision
FY 2020/2021
Actuals
thru 06/2021 Budget Year End
Estimate *
Community Center Fund
Actuals
thru 06/2021 Budget Year End
Estimate *
ATTACHMENT C-2
July 2020 Aug. 2020 Sept. 2020 Oct. 2020 Nov. 2020 Dec. 2020 Jan.2021 Feb. 2021 Mar. 2021 April 2021 May 2021 June 2021 YTD FY 2021 FY 2021
Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Actual Budget Forecast
REVENUES:
Green Fees 104,791 105,899 122,143 93,295 171,862 161,787 162,631 229,807 269,410 241,815 163,971 88,767 1,916,178 1,333,602 1,916,178
Cart Fees 18,898 19,444 19,752 20,236 19,956 20,761 21,970 24,066 23,626 23,767 22,925 22,626 258,027 234,237 258,027
Driving Range 1,644 2,670 4,685 5,054 4,366 3,876 3,846 6,781 4,907 5,323 3,600 3,680 50,432 65,695 50,432
Golf Cards/Passes (709) - 709 - - - - - - - - - - - -
Pro Shop Sales 11,834 10,009 10,825 8,276 14,099 21,293 16,957 17,213 35,312 27,457 15,166 8,797 197,238 222,238 197,238
Other Golf Rev.4,015 3,186 4,282 2,300 9,313 6,704 4,985 2,124 3,582 3,325 1,635 1,136 46,587 3,000 46,587
Clinic/School Rev.360 1,243 1,184 864 1,927 2,089 4,302 3,634 2,878 2,146 1,838 4,377 26,842 15,000 26,842
Monthly Dues 74,950 82,272 75,649 77,485 79,933 87,318 84,558 91,219 93,616 94,466 90,061 89,976 1,021,503 850,000 1,021,503
Misc. & Discounts (642) 323 133 951 (448) 1,375 1,140 1,289 1,193 (712) 8,070 (7,394) 5,278 20,000 5,278
Food & Beverage 24,734 22,371 23,461 22,740 36,582 34,969 33,510 43,846 52,541 60,691 55,860 37,475 448,780 760,776 448,780
TOTAL REVENUES:239,875 247,417 262,823 231,201 337,590 340,172 333,899 419,979 487,065 458,278 363,126 249,440 3,970,865 3,504,548 3,970,865
COST OF SALES:
Pro Shop 9,815 8,835 10,735 5,880 11,797 21,621 10,803 11,629 23,458 19,847 11,628 6,229 152,277 144,454 152,277
Lessons & Group Services - - - - - - - - - - - - 13,350 -
Food & Beverage 8,569 7,784 8,471 9,529 12,831 12,235 9,909 13,001 15,485 18,454 16,288 15,029 147,585 256,095 147,585
TOTAL COST OF SALES:18,384 16,619 19,206 15,409 24,628 33,856 20,712 24,630 38,943 38,301 27,916 21,258 299,862 413,899 299,862
GROSS INCOME:221,491 230,798 243,617 215,792 312,962 306,316 313,187 395,349 448,122 419,977 335,210 228,182 3,671,003 3,090,649 3,671,003
EXPENDITURES:
Personnel 93,134 127,987 105,158 119,665 114,075 136,159 128,485 115,287 122,195 114,720 118,153 130,081 1,425,099 1,687,606 1,425,099
Golf Operations 5,503 1,778 2,224 6,329 17,209 8,906 3,681 12,133 7,201 4,414 7,036 7,332 83,746 30,900 83,746
G&A 20,792 52,369 24,364 12,231 22,577 30,873 72,503 28,926 35,216 33,613 40,392 (7,975) 365,881 135,509 365,881
Maintenance 148,148 151,140 221,930 219,568 118,088 67,554 12,972 68,592 86,897 101,845 139,825 158,460 1,495,019 1,524,660 1,495,019
Sales & Marketing 1,284 2,415 2,083 3,515 1,691 910 6,580 1,172 1,105 3,993 1,514 640 26,902 42,100 26,902
Food & Beverage 18,238 17,444 16,756 17,386 24,209 23,907 23,370 20,536 23,339 24,758 25,641 57,213 292,797 241,362 292,797
Management Fees 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000 120,000 120,000
Golf Cart Leases 13,041 13,041 13,041 13,041 18,092 13,041 13,041 13,041 13,041 13,041 13,041 13,041 161,542 156,488 161,542
Equipment Leases 19,277 19,280 - - - - - - - - - - 38,557 138,304 38,557
Capital Equipment Purchases - - - - - - - - 53,873 - - 53,873 - 53,873
Other Expenses 12,590 17,043 - - - 450 6,248 - 20,930 8,728 7,668 147,200 220,857 3,000 220,857
Insurance - P&C 3,300 3,300 3,300 3,300 9,115 4,463 4,600 4,600 3,812 3,380 4,868 3,380 51,418 2,000 51,418
TOTAL EXPENDITURES:345,306 415,797 398,856 405,035 335,056 296,263 281,480 274,287 323,736 372,365 368,138 519,372 4,335,691 4,081,929 4,335,691
NET INCOME:(123,815) (184,999) (155,239) (189,243) (22,094) 10,053 31,707 121,062 124,386 47,612 (32,928) (291,190) (664,688) (991,280) (664,688)
El Conquistador Cash Flow Statement
ATTACHMENT E
General Fund Local Sales Tax Collections
FY 2020/21
CATEGORY JULY AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNE TOTAL
Construction Sales Tax 643,435 471,705 517,101 483,032 384,176 321,621 305,338 241,562 254,568 450,343 409,924 442,859 4,925,664
Utility Sales Tax 267,771 337,260 350,040 360,019 286,715 249,286 245,891 271,681 241,698 227,632 221,458 205,402 3,264,853
Retail Sales Tax 647,068 579,089 560,008 613,570 607,315 709,153 889,306 606,222 620,243 748,368 700,138 692,038 7,972,518
Bed Tax 42,564 33,546 32,879 38,003 170,718 105,673 36,242 40,721 99,686 148,989 144,442 130,433 1,023,896
Restaurant & Bar Sales Tax 127,814 114,578 118,223 130,147 158,913 137,151 142,356 130,977 154,257 183,628 167,142 191,389 1,756,575
All Other Local Sales Tax *117,419 174,520 141,653 120,588 200,416 200,756 183,337 164,894 171,734 218,085 193,522 201,188 2,088,112
TOTAL 1,846,071$ 1,710,698$ 1,719,904$ 1,745,360$ 1,808,253$ 1,723,640$ 1,802,470$ 1,456,056$ 1,542,186$ 1,977,045$ 1,836,626$ 1,863,309$ 21,031,618$
FY 2019/20
CATEGORY JULY AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNE TOTAL
Construction Sales Tax 517,637 462,244 615,858 617,534 412,787 459,531 281,257 380,036 315,236 504,767 492,156 511,642 5,570,685
Utility Sales Tax 234,537 311,362 320,239 325,272 244,544 210,285 218,262 264,950 224,019 198,472 192,478 226,165 2,970,585
Retail Sales Tax 555,057 542,964 524,735 491,087 630,262 661,184 892,958 582,264 553,726 630,299 560,570 634,962 7,260,068
Bed Tax 54,830 91,322 99,278 104,342 120,624 123,846 109,383 142,745 100,338 51,680 14,780 21,154 1,034,323
Restaurant & Bar Sales Tax 142,433 139,049 154,388 151,118 150,996 176,520 173,479 175,764 138,125 129,206 93,589 119,171 1,743,839
All Other Local Sales Tax *46,762 59,797 66,191 63,774 119,804 155,857 181,405 158,895 123,624 111,669 101,265 108,652 1,297,696
TOTAL 1,551,256$ 1,606,738$ 1,780,689$ 1,753,127$ 1,679,017$ 1,787,223$ 1,856,744$ 1,704,654$ 1,455,069$ 1,626,093$ 1,454,838$ 1,621,747$ 19,877,196$
* Note: Does not include cable franchise fees or sales tax audit revenues
ATTACHMENT F
General Fund State Shared Revenues
FY 2020/21
CATEGORY JULY AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNE TOTAL
State Shared Income Tax 548,361 548,361 548,361 548,361 548,361 548,360 548,361 548,361 548,361 548,361 548,361 548,361 6,580,331
State Shared Sales Tax 243,577 413,638 354,744 490,371 357,106 523,608 454,947 376,182 433,435 572,504 533,021 709,210 5,462,343
County Auto Lieu 98,728 256,745 217,528 201,958 162,796 190,665 190,824 175,212 182,116 216,303 197,466 302,323 2,392,664
TOTAL 890,666$ 1,218,744$ 1,120,633$ 1,240,690$ 1,068,263$ 1,262,633$ 1,194,132$ 1,099,755$ 1,163,912$ 1,337,168$ 1,278,848$ 1,559,894$ 14,435,338$
FY 2019/20
CATEGORY JULY AUG SEP OCT NOV DEC JAN FEB MAR APR MAY JUNE TOTAL
State Shared Income Tax 489,186 489,186 489,186 489,186 489,186 489,186 489,186 489,186 489,186 489,186 489,186 489,186 5,870,232
State Shared Sales Tax 367,929 418,577 314,216 381,361 447,490 322,597 408,444 563,756 324,864 540,907 349,280 255,070 4,694,491
County Auto Lieu 89,556 184,257 174,793 173,529 183,209 157,268 177,671 183,502 159,026 80,587 138,405 371,622 2,073,425
TOTAL 946,671$ 1,092,020$ 978,195$ 1,044,076$ 1,119,885$ 969,051$ 1,075,301$ 1,236,444$ 973,076$ 1,110,680$ 976,871$ 1,115,878$ 12,638,148$
ATTACHMENT D
Consolidated Year-to-Date Financial Report through June 2021 FY 2020/2021
FY 20/21 Capital Leases/Left in Accounts
Begin Bal.Transfer Out Thru June 2021
General Fund 20,899,548 56,888,739 56,888,739 2,586,520 27,834,992 9,995,731 1,620,671 42,037,914 35,750,373
Highway Fund 818,962 3,776,832 3,776,832 1,203,687 599,777 1,549,352 3,352,816 1,242,978
Seizure & Forfeiture - Justice/State 244,194 100,394 100,394 - 55,063 22,715 77,778 266,810
Community Center Fund 862,818 7,582,258 7,582,258 358,401 2,136,709 3,138,722 139,657 5,773,489 2,671,587
Municipal Debt Service Fund 169,721 141,398 1,076,200 1,217,598 6,438 1,215,445 1,221,883 165,436
Oracle Road Debt Service Fund 6,841 173,191 173,191 1,800 174,038 175,838 4,194
Water Resource System & Dev. Impact Fee Fund 16,545,872 4,114,256 1,130,495 5,244,751 120,000 2,839,028 321,661 3,280,689 18,509,934
Townwide Roadway Dev Impact Fee Fund 2,966,188 514,773 514,773 1,647,354 1,647,354 1,833,607
Parks & Recreation Impact Fee Fund 779,573 370,700 370,700 880,708 880,708 269,565
Police Impact Fee Fund 103,398 165,367 165,367 100,000 100,000 168,765
Capital Fund 2,410,736 1,047,831 1,771,143 2,818,974 2,791,438 2,791,438 2,438,272
PAG/RTA Fund 382,519 2,204,727 2,204,727 1,338,628 1,338,628 1,248,618
Water Utility 13,830,116 18,198,408 1,131,611 19,330,019 1,130,495 3,400,842 7,680,813 2,903,046 4,711,254 19,826,450 13,333,685
Stormwater Utility 628,026 1,635,969 1,635,969 808,588 368,321 215,775 1,392,684 871,311
Benefit Self Insurance Fund 2,088,823 3,851,207 3,851,207 3,812,717 3,812,717 2,127,313
Recreation In-Lieu Fee Fund 16,100 945 945 - 17,045
Total 62,753,435 100,766,995 5,109,449 105,876,444 4,175,416 35,384,818 25,779,382 15,948,372 - 6,422,398 87,710,386 80,919,493
Total OutPersonnelO&M Capital ContingencyFundRevenueOther Fin Sources/
Tfrs Total In Debt Service