Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
09.12.23 Town Council Regular Meeting Packet
Page 1 of 3 ] Welcome to the Prosper Town Council Meeting. Citizens may watch the meeting live by using the following link: https://prospertx.gov/livemeetings Addressing the Town Council: Those wishing to address the Town Council must complete the Public Comment Request Form located on the Town's website or in the Council Chambers. If you are attending in person, please submit this form to the Town Secretary or the person recording the minutes for the Board/Commission prior to the meeting. When called upon, please come to the podium, and state your name and address for the record. If you are watching online, please submit this form to the Town Secretary prior to 4:00 p.m. on the day of the meeting in order for your comments to be read into the record. The Town assumes no responsibility for technical issues beyond our control. In compliance with the Texas Open Meetings Act, the Town Council/Board/Commission may not deliberate or vote on any matter that does not appear on the agenda. The Council/Board/Commission, however, may provide statements of fact regarding the topic, request the topic be included as part of a future meeting, and/or refer the topic to Town staff for further assistance. Citizens and other visitors attending Town Council meetings shall observe the same rules of propriety, decorum, and good conduct applicable to members of the Town Council. Any person making personal, impertinent, profane or slanderous remarks or who becomes boisterous while addressing the Town Council or while attending the meeting shall be removed from the room, if so directed by the Mayor or presiding officer, and the person shall be barred from further audience before the Town Council during that session. Disruption of a public meeting could constitute a violation of Section 42.05 of the Texas Penal Code. Call to Order/ Roll Call. Invocation, Pledge of Allegiance and Pledge to the Texas Flag. Announcements of recent and upcoming events. Presentations. 1. Presentation of THRIVES coins to members of the Engineering Department for outstanding performance. (DFB) CONSENT AGENDA: Items placed on the Consent Agenda are considered routine in nature and non-controversial. The Consent Agenda can be acted upon in one motion. Items may be removed from the Consent Agenda by the request of Council Members or staff. Agenda Prosper Town Council Meeting Prosper Town Hall, Council Chambers 250 W. First Street, Prosper, Texas Tuesday, September 12, 2023 6:15 PM Page 1 Page 2 of 3 2. Consider and act upon the minutes from the August 22, 2023, Town Council Regular meeting. (MLS) 3. Consider and act upon the minutes from the August 29, 2023, Town Council Special meeting. (MLS) 4. Consider acceptance of the April, May, and June 2023 monthly financial reports. (CL) 5. Consider and act upon adopting the FY 2023-2024 Prosper Economic Development Corporation Budget. (MM) 6. Consider and act upon adopting an ordinance repealing existing Section I, “Construction Permits and Fees,” and Section II, “Reserved,” contained in Appendix A, “Fee Schedule,” of the Town’s Code of Ordinances and replacing them with a new Section I, “Engineering Inspection Fees,” and a new Section II, “Building Permits/Inspection Fees”. (DHeischman) 7. Consider and act upon a Façade Plan for a Restaurant, on 1.7± acres, located south of Lovers Lane and west of South Preston Road. The property is zoned Planned Development-67 (PD-67) Gates of Prosper. (DEVAPP-23-0129) (DH) 8. Consider and act upon whether to direct staff to submit a written notice of appeals on behalf of the Town Council to the Development Services Department, pursuant to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance, regarding action taken by the Planning & Zoning Commission on any Site Plans including Prestonwood Baptist Church and Outback Steakhouse. (DH) CITIZEN COMMENTS The public is invited to address the Council on any topic. However, the Council is unable to discuss or take action on any topic not listed on this agenda. Please complete a “Public Comment Request Form” and present it to the Town Secretary prior to the meeting. Please limit your comments to three minutes. If multiple individuals wish to speak on a topic, they may yield their three minutes to one individual appointed to speak on their behalf. All individuals yielding their time must be present at the meeting, and the appointed individual will be limited to a total of 15 minutes. REGULAR AGENDA: Pursuant to Section 551.007 of the Texas Government Code, individuals wishing to address the Council for items listed as public hearings will be recognized when the public hearing is opened. [If you wish to address the Council, please fill out a “Public Comment Request Form” and present it to the Town Secretary, preferably before the meeting begins.] Items for Individual Consideration: 9. Conduct a public hearing to receive public input, consider such input, and consider and act upon an ordinance adopting the Fiscal Year (FY) 2023-2024 Annual Operating and Capital Project Funds budgets and five-year Capital Improvement Program for the fiscal year beginning October 1, 2023, and ending September 30, 2024. (RBS/CL) 10. Conduct a public hearing to consider and act upon an ordinance adopting a tax rate of $0.51 per $100 valuation for fiscal year 2023-2024. (CL) 11. Ratifying the property tax increase in the budget for fiscal year (FY) 2023-2024. (CL) 12. Discuss and consider Town Council Subcommittee reports. (DFB) Page 2 Page 3 of 3 Possibly direct Town staff to schedule topic(s) for discussion at a future meeting. EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: Section 551.087 – To discuss and consider economic development incentives and all matters incident and related thereto. Section 551.072 – To discuss and consider purchase, exchange, lease or value of real property for municipal purposes and all matters incident and related thereto. Section 551.074 – To discuss and consider personnel matters and all matters incident and related thereto. Section 551.074 - To discuss appointments to the Board of Adjustment/Construction Board of Appeals, Parks & Recreation Board, Library Board, Prosper Economic Development Corporation Board, Planning & Zoning Commission, and the Community Engagement Committee, and all matters incident and related thereto. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. Adjourn. CERTIFICATION I, the undersigned authority, do hereby certify that this Notice of Meeting was posted at Prosper Town Hall, located at 250 W. First Street, Prosper, Texas 75078, a place convenient and readily accessible to the general public at all times, and said Notice was posted by 5:00 p.m., on Friday, September 8, 2023, and remained so posted at least 72 hours before said meeting was convened. ________________________________ _________________________ Michelle Lewis Sirianni, Town Secretary Date Notice Removed Pursuant to Section 551.071 of the Texas Government Code, the Town Council reserves the right to consult in closed session with its attorney and to receive legal advice regarding any item listed on this agenda. NOTICE Pursuant to Town of Prosper Ordinance No. 13-63, all speakers other than Town of Prosper staff are limited to three (3) minutes per person, per item, which may be extended for an additional two (2) minutes with approval of a majority vote of the Town Council. NOTICE OF ASSISTANCE AT PUBLIC MEETINGS: The Prosper Town Council meetings are wheelchair accessible. For special services or assistance, please contact the Town Secretary’s Office at (972) 569 -1011 at least 48 hours prior to the meeting time. Page 3 Page 1 of 6 ] Call to Order/ Roll Call. The meeting was called to order at 6:15 p.m. Council Members Present: Mayor David F. Bristol Mayor Pro-Tem Craig Andres Deputy Mayor Pro-Tem Marcus E. Ray Councilmember Amy Bartley Councilmember Chris Kern Councilmember Jeff Hodges Councilmember Charles Cotten Staff Members Present: Mario Canizares, Town Manager Michelle Lewis Sirianni, Town Secretary Terry Welch, Town Attorney Bob Scott, Deputy Town Manager Chuck Ewings, Assistant Town Manager Robyn Battle, Executive Director Mary Ann Moon, Economic Development Director David Hoover, Development Services Director Hulon Webb, Director of Engineering Dan Baker, Parks & Recreation Director Chris Landrum, Finance Director Leigh Johnson, IT Director James Edwards, Human Resources Director Todd Rice, Communications Manager Jessika Hotchkin, Help Desk Technician Doug Kowalski, Police Chief Stuart Blasingame, Fire Chief Invocation, Pledge of Allegiance and Pledge to the Texas Flag. Casey Burt with Prestonwood Baptist Church led the invocation. The Pledge of Allegiance and the Pledge to the Texas Flag were recited. An nouncements of recent and upcoming events. Councilmember Kern made the following announcements: Join Town staff for a Budget Town Hall meeting on Thursday, August 31 at 6:00 p.m. in the Council Chambers of Town Hall. Residents are invited to participate in person or may watch live online at prospertx.gov/livemeetings. Reminder that Town Hall Offices will be closed on Monday, September 4 for the Labor Day Holiday. Due to the holiday, residents whose trash service falls on Monday will be delayed by one day. MINUTES Prosper Town Council Meeting Prosper Town Hall, Council Chambers 250 W. First Street, Prosper, Texas Tuesday, August 22, 2023 Page 4 Item 2. Page 2 of 6 Don’t miss out on an unforgettable evening at Freedom Fest 2023, featuring a live performance by Coffey Anderson. This highly anticipated concert is set to take place on the south lawn of Town Hall in downtown Prosper on Saturday, September 2 beginning at 5:30 p.m. General Admission tickets are now available or reserve your VIP tickets at prospertx.gov/freedomfesttickets. Join us on Saturday, September 9 for Paws on Broadway as part of the Downtown Discover event series in partnership with the Prosper EDC from 11:00 a.m. to 2:00 p.m. Bring your pup downtown to enjoy a fun afternoon featuring treats and contests, along with pet-related exhibits and vendors. Join the Prosper Police and Fire Departments on Monday, September 11 at 9 a.m. at Central Fire Station located at 911 Safety Way for the Town’s annual 9/11 Remembr ance Ceremony. Carter Blood Care will also be on site from 7:30 a.m. to 6:00 p.m. for anyone wishing to donate. Registration is now open for the annual Prosper Veterans Day 5K & Fun Run. This event held on Saturday, November 11 is a salute to the men and women who have served in our nation’s military. All proceeds will benefit the Prosper Veterans Memorial at Frontier Park. Register today by visiting prospertx.gov/veteransday5k. Presentations. 1. Presentation of THRIVES coins to members of the Prosper Police Department for outstanding performance. (DFB) Mayor Bristol presented a Mayors and THRIVES coin(s) to members of the Police Department for their honorable efforts regarding two recent incidents. CONSENT AGENDA: Items placed on the Consent Agenda are considered routine in nature and non-controversial. The Consent Agenda can be acted upon in one motion. Items may be removed from the Consent Agenda at the request of Council Members or staff. 2. Consider and act upon the minutes from the August 8, 2023, Town Council Work Session meeting. (MLS) 3. Consider and act upon the minutes from the August 8, 2023, Town Council Regular meeting. (MLS) 4. Receive the Quarterly Investment Report for June 30, 2023. (CL) 5. Consider and act upon Ordinance 2023-54 approving a Negotiated Settlement between the Atmos Cities Steering Committee and Atmos Energy Corporation, Mid-Tex Division regarding the Company’s 2023 Rate Review Mechanism Filing; declaring the existing rates to be unreasonable; finding the rates to be set by the attached Settlement Tariffs to be reasonable and in the public interest; and approving an attachment establishing a benchmark for pensions and retiree medical benefits. (TW) 6. Consider and act upon Resolution 2023-55 suspending the September 1, 2023, effective date of a rate request from CoServ Gas Ltd. for the maximum period allowed by law. (TW) 7. Consider and act upon authorizing the Town Manager to execute an Agreement between Vector Solutions and the Town of Prosper for online training management and scheduling applications. (SB) Page 5 Item 2. Page 3 of 6 8. Consider and act upon authorizing the Town Manager to execute a contract between Astound Business Solutions and the Town of Prosper, Texas, related to establishing fiber network connectivity from Town Hall to Fire Stations 2 & 3, pump station, and establishing fiber radio system connectivity from Prosper to the City of Frisco. (LJ) 9. Consider and act upon Resolution 2023-56 designating The Frisco Enterprise as the official newspaper of the Town of Prosper and The Dallas Morning News as an alternative advertising source for FY 2023-2024. (MLS) 10. Consider and act upon Ordinance 2023-57 adopting new personnel policies regarding mental health leave for certain personnel as required by recent legislation and injury and illness leave for certain personnel as required by recent legislation. (JE) Deputy Mayor Pro-Tem Ray requested to pull item 8. Mayor Pro-Tem Andres made a motion to approve items 2 through 7, 9, and 10. Councilmember Hodges seconded that motion. Motion carried unanimously. Deputy Mayor Pro-Tem Ray asked staff to clarify the service terms of the contract. Mr. Johnson replied and spoke to the service terms of the contract. Deputy Mayor Pro-Tem Ray made a motion to approve item 8. Councilmember Hodges seconded that motion. Motion carried unanimously. CITIZEN COMMENTS No comments were made. Items for Individual Consideration: 11. Consider all matters incident and related to the issuance and sale of “Town of Prosper, Texas, Combination Tax and Surplus Revenue Certificates of Obligation, Series 2023”, including the adoption of an ordinance authorizing the issuance of such obligations and establishing procedures and delegating authority for the sale and delivery of such obligations. (CL) Mr. Landrum stated this item, if approved, authorizes the Town Manager to execute the sale of bonds within the parameters set forth and the noted the water and wastewater projects in connection with the issuance. Mayor Pro-Tem Andres made a motion to adopt Ordinance 2023-58 authorizing the issuance and sale of “Town of Prosper, Texas, Combination Tax and Surplus Revenue Certificates of Obligation, Series 2023” and approving all other matters related thereto. Deputy Mayor Pro-Tem Ray seconded that motion. Motion carried unanimously. 12. Receive an update on the 2023 Texas Legislative Session. (RB) Ms. Battle introduced Jake Posey and Lorena Robledo with Strategies 360. Mr. Posey and Ms. Robledo provided an update highlighting the bills that have the most significant impact to the Town, ones that did not pass, and bills that will require ordinance changes and/or policy changes. An advocacy strategy for the post and off- session was also discussed. Page 6 Item 2. Page 4 of 6 13. Consider and act upon a request to rezone 34.7± acres from Commercial District (C) to a new Planned Development for Mixed Use, located northside of Prosper Trail and west of Dallas Parkway. (Z22-0019) (DH) Mr. Hoover reviewed the history of the request and stated all the requests by the Town Council have been captured and presented within the materials for the Council’s consideration. Mayor Bristol read written comments by Shawn Graham, 2940 Vista View Ln supporting the rezoning request. The Town Council discussed the multi-family component of the project and noted their appreciation for the triggers along with the developer’s willingness to make changes based on their feedback. Deputy Mayor Pro-Tem Ray made a motion to approve a request to rezone 34.7± acres from Commercial District (C) to a new Planned Development for Mixed Use, located northside of Prosper Trail and west of Dallas Parkway. Councilmember Hodges seconded that motion. Motion carried unanimously. 14. Consider and act upon a Development Agreement for the proposed Pradera Development, located north of Prosper Trail and west of the Dallas Parkway. (DH) Mr. Hoover indicated this item is in relation to the previous rezoning request, and the agreement includes all changes requested. Councilmember Bartley made a motion to approve a Development Agreement for the proposed Pradera Development located north of Prosper Trail and west of Dallas Parkway. Councilmember Hodges seconded that motion. Motion carried unanimously. 15. Conduct a public hearing and consider and act upon a request to update the Town of Prosper’s Comprehensive Plan. (DH) Mr. Hoover introduced this item stating the proposed plan has been presented to the Planning and Zoning Commission as well as the Community Engagement Committee. The P&Z Commissioners recommended that low density residential remain on the southeast corner of FM-1385 and Parvin Road instead of the proposed medium density residential. Additionally, they recommended that low density residential remain on the southwest corner of Frontier and Shawnee instead of the proposed medium density residential. Ms. Wendy Bonneau and Rhys Wilson with Freese & Nichols, Consultants, presented the recommendations from the advisory committee and the Planning and Zoning Commission, and highlighted the changes in the goals and objectives to the proposed update. The Town Council discussed the proposed changes to the Future Land Use Plan (FLUP), drive-thrus, building heights, detention ponds with lighting, and considering adding the DNT overlay as an objective. Mayor Bristol opened the public hearing. No comments were made. Page 7 Item 2. Page 5 of 6 Mayor Bristol closed the public hearing. Deputy Mayor Pro-Tem Ray made a motion to approve a request to update the Comprehensive Plan based on the recommendations from the Town’s consultant with the following revisions: Change the Planning and Zoning Commission recommendation to the CPAC recommendation regarding Area 1 contained in Figure 49 and Area 3 contained in Figure 53; eliminate the first bullet point regarding drive - thrus on page 71; add a recommendation to explore a DNT overlay; and add an objective regarding wet detention in Image Enhancement on page 82, consistent with the Town’s current ordinance. Councilmember Bartley seconded that motion. Motion carried unanimously. 16. Discuss CIP and Finance Subcommittee recommendations and receive Council direction regarding the FY 2023-2024 Proposed Budget. (RBS/CL) Mr. Scott provided an overview of the proposed budget including General Fund, Utility Fund, Solid Waste Fund, Stormwater Drainage Fund, and personnel and compensation changes. Mr. Scott stated based on the Town Councils request, these committees met in order to provide recommendations regarding the capital dedicated projects. The CIP Subcommittee recommendation is to maintain the capital dedicated portion of the tax levy at its current level. The subcommittee also outlined a list of their recommended projects for 2024. The Finance Subcommittee accepted these recommendations. In addition, the Finance Subcommittee provided general support for the staff recommendations. The Town Council discussed the summary of the proposed capital dedicated projects, personnel, and searching for grants when feasible for projects. 17. Discuss and consider Town Council Subcommittee reports. (DFB) Mayor Bristol indicated updates were presented in the previous agenda item. Possibly direct Town staff to schedule topic(s) for discussion at a future meeting. Councilmember Kern requested a list of the no-thru truck zones within Town limits. Deputy Mayor Pro-Tem Ray requested an assessment of the streets that have buckled, as well as revisiting damaged medians in need of repair. EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: Section 551.087 – To discuss and consider economic development incentives and all matters incident and related thereto. Section 551.072 – To discuss and consider purchase, exchange, lease or value of real property for municipal purposes and all matters incident and related thereto. Section 551.074 – To discuss and consider personnel matters and all matters incident and related thereto. Section 551.089 - Deliberation of security information collected, assembled or maintained by or for a governmental entity to prevent, detect, or investigate criminal Page 8 Item 2. Page 6 of 6 activity, pursuant to Section 2059.055 of the Texas Government Code, and all matters incident and related thereto. Section 551.074 - To discuss appointments to the Board of Adjustment/Construction Board of Appeals, Parks & Recreation Board, Library Board, Prosper Economic Development Corporation Board, Planning & Zoning Commission, and the Community Engagement Committee, and all matters incident and related thereto. The Town Council recessed into Executive Session at 8:56 p.m. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. The Town Council reconvened into Regular Session at 9:46 p.m. No action was taken. Adjourn. The meeting was adjourned at 9:46 p.m. These minutes were approved on the 12th day of September 2023. APPROVED: David F. Bristol, Mayor ATTEST: Michelle Lewis Sirianni, Town Secretary Page 9 Item 2. Page 1 of 1 ] Call to Order/ Roll Call. The meeting was called to order at 5:32 p.m. Council Members Present: Mayor David F. Bristol Mayor Pro-Tem Craig Andres arrived 7:12 p.m. Deputy Mayor Pro-Tem Marcus E. Ray Councilmember Amy Bartley Councilmember Chris Kern Councilmember Jeff Hodges Councilmember Charles Cotten Staff Members Present: Michelle Lewis Sirianni, Town Secretary EXECUTIVE SESSION: Recess into Closed Session in compliance with Section 551.001 et seq. Texas Government Code, as authorized by the Texas Open Meetings Act, to deliberate regarding: Section 551.074 - To conduct interviews for positions on the Town's Board & Commissions. The Town Council recessed into Executive Session at 5:32 p.m. Reconvene in Regular Session and take any action necessary as a result of the Closed Session. The Town Council reconvened into Regular Session at 8:11 p.m. No action was taken. Adjourn. The meeting was adjourned at 8:11 p.m. These minutes were approved on the 12th day of 2023. APPROVED: David F. Bristol, Mayor ATTEST: Michelle Lewis Sirianni, Town Secretary MINUTES Prosper Town Council Special Meeting Prosper Town Hall – Community Room 250 W. First Street, Prosper, Texas Tuesday, August 29, 2023 Page 10 Item 3. Page 1 of 2 To: Mayor and Town Council From: Chris Landrum, Finance Director Through: Mario Canizares, Town Manager Bob Scott, Deputy Town Manager Re: Monthly Financial Reports Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Consider acceptance of the April, May, and June 2023 monthly financial reports. (CL) Description of Agenda Item: The Town Charter requires the submission of monthly financial reports to the Town Council. Staff has included a summary for the third quarter of fiscal year 2023 and will continue to expand the summary as needed for future quarters submitted to the Town Council. In summary, both revenues and expenditures are occurring within the expected ranges and no unexpected events have occurred that require significant changes in original projections. The attached monthly financial reports for April-June 2023 were prepared in the old format. This format is not particularly “user friendly” and staff is looking to reformat the monthly financial reports after the ERP software conversion. Budget Impact: There is no budgetary impact affiliated with this item. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Third Quarter Financial Summary 2. Monthly Financial Report – April 30, 2023 3. Monthly Financial Report – May 31, 2023 4. Monthly Financial Report – June 30, 2023 Town Staff Recommendation: Town staff recommends the Town Council accept the submission of the monthly financial reports for the periods April-June 2023 in compliance with the requirements of the Town Charter. FINANCE Page 11 Item 4. Page 2 of 2 Proposed Motion: I move to accept the April through June 2023 Monthly Financial Reports in compliance with charter requirements. Page 12 Item 4. TOWN OF PROSPER REPORT TO TOWN COUNCIL FY 2023 RESULTS OF THIRD QUARTER ENDING JUNE 30, 2023 In compliance with the Town Charter, Town Management presents to the Council the following summary of the third quarter financial results. These results are presented on a cash/budgetary basis in which certain accruals including property taxes, sales tax, payroll, accounts payable etc. are recorded on a cash basis month by month to facilitate more tfmely financial reportfng and then at year end are recorded for the purposes of reportfng in the audited financial statements to reduce the difference between budget basis and GAAP (Generally Accepted Accountfng Principles) basis. In summary, both revenues and expenditures are occurring within the expected ranges and no unexpected events have occurred that require significant changes in original projectfons. With 75% of the year now complete, results for the major operatfons of the funds with related commentary are: GENERAL FUND Revenues total $40,909,394, or 86% of annual budget Property Tax Collectfons are 101% of annual budget Sales Tax Revenues are 72% of annual budget Franchise Fees are 77% of annual budget, an increase of 35% from the prior year. Building Permit Revenues are 57% of annual budget, a decrease of 17% from the prior year. Expenditures total $35,179,223, or 70% of annual budget Revenues: It is common for a disproportfonate percentage of General Fund revenues to be received early in the year as our largest revenue-property taxes are due January 31st with many paying by the end of December to receive the income tax deductfon in the current calendar year. Sales tax revenue is lagging budget slightly due to the loss of a major sales taxpayer at the end of December 2021 that is being offset by organic growth of new businesses overtfme. Many franchise fees are paid on a quarterly basis which creates a lag early in the year but as noted organic growth is creatfng substantfal growth in receipts from the prior year. Finally, Building Permits is behind the 75% reference point due to higher mortgage rates slowing demand for new home starts. Due to this trend, building permit revenue is budgeted less in FY2024. Currently, however, the shortiall in this one category is not considered enough to cause total revenues to be under budget. Expenditures: Expenditures three-quarters through the year are slightly less than the 75% reference point. Page 13 Item 4. WATER & SEWER FUND Revenues total $20,724,425, or 72% of annual budget and up 10% from prior year Expenditures total $18,702,790, or 56% of annual budget and up 5% from prior year Water purchases show an increase of 48% from prior year due to the rate and minimum demand increase from NTMWD. Revenues: Due to monthly billing of utflity accounts and recording of revenues monthly on a cash basis, the revenues for the first nine months traditfonally lower use months explaining why revenues are slightly lower than the 75% reference point. It should be noted that that for FY 2023, a separate Solid Waste fund has been created with solid waste related revenues and expenses being excluded from the utflity fund and prior year numbers restated. Expenditures: Due to the “take or pay” fee structures of regional supplier’s, expenditures tend to have less seasonal variatfon than revenues. The expenditures have increased 48% due to the North Texas Municipal Water District Water Service Monthly Minimum payment, from $596,439 to $884,485 per month. Debt service expenditures are down due to the early redemptfon of the 2012 CO’s in the prior year. SOLID WASTE FUND The Revenues and expenditures recorded reflect the terms of the current contract with the decision to issue a request for proposal and not renew the current contract. The $1,750,000 was budgeted for administratfon consistfng of $50,000 for an RFP consultant and $1.7 million for possible purchase of solid waste and recycling carts. Easing supply chain constraints now make it possible to order the carts in FY2024. IMPACT FEE REVENUES Water Impact Fees total $2,326,780 which is 66% of annual budget Wastewater Impact Fees total $1,835,099 which is 89% of annual budget Street Impact Fees for East Thoroughfare Impact Fees total $1,763,003 which is 176% of annual budget (Prosper Brookhollow Apts Building 1 - $1,066,800) Street Impact Fees for West Thoroughfare Impact Fees total $3,104,695 which is 78% of annual budget. Due to their nature impact fees can vary significantly throughout the year. West impact fees are primarily single family residentfal and are generated when a home builder takes out a permit for a single home. As such they will occur more evenly throughout the year. Large multf-family will be collected all at once. Mario Canizares Town Manager Page 14 Item 4. MONTHLY FINANCIAL REPORT as of April 30, 2023 Cash/Budgetary Basis Prepared by Finance Department September 12, 2023 Page 15 Item 4. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 2023 Table of Contents Dashboard Charts 3 - 4 General Fund 5 Water-Sewer Fund 8 Solid Waste Fund 13 Debt Service Fund 15 Crime Control and Prevention Special Purpose District 16 Fire Control, Prevention, and Emergency Medical Services Special Purpose District 17 Vehicle and Equipment Replacement Fund 18 Storm Drainage Utility Fund 19 Park Dedication and Improvement Fund 20 TIRZ #1 - Blue Star 21 TIRZ #2 22 Water Impact Fees Fund 23 Wastewater Impact Fees Fund 24 Thoroughfare Impact Fees Fund 25 Special Revenue Fund 27 Capital Projects Fund-General 28 Capital Projects Fund-Water/Sewer 30 Page 16 Item 4. 0 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 Total Budget YTD Budget YTD Actual Building Permit Revenues 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept Town of Prosper, Texas Sales Tax Revenue by Month FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY22/23 3 Page 17 Item 4. 0 6288751.47 $56.072 $32.708 $25.363 $47.585 $27.758 $36.098 $- $10 $20 $30 $40 $50 $60 Total Budget YTD Budget YTD Actual In Millions General Fund Revenues and Expenditures Revenues Expenditures $34.438 $20.089 $14.509 $28.843 $16.825 $15.381 $- $5 $10 $15 $20 $25 $30 $35 $40 Total Budget YTD Budget YTD Actual In Millions Water -Sewer Fund Revenues and Expenditures Revenues Expenditures 4 Page 18 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actuals Encumbrances Budget Balance YTD Percent Note YTD Actuals Prior Year REVENUES Property Taxes 23,519,547$ -$ 23,519,547$ 23,472,797$ -$ 46,750$ 100%1 18,985,659$ 24% Sales Taxes 10,220,208 0 10,220,208 5,582,136 0 4,638,072 55%5,403,899 3% Franchise Fees 2,404,527 0 2,404,527 1,405,830 0 998,697 58%2 1,170,894 20% Building Permits 4,781,000 0 4,781,000 2,154,595 0 2,626,405 45%2,575,876 -16% Other Licenses, Fees & Permits 1,552,430 80,000 1,632,430 710,753 0 921,677 44%1,237,744 -43% Charges for Services 1,240,961 0 1,240,961 693,230 0 547,731 56%520,884 33% Fines & Warrants 250,425 0 250,425 230,593 0 19,832 92%138,736 66% Intergovernmental Revenue (Grants)1,525,000 0 1,525,000 134,226 0 1,390,774 9%218,185 -38% Interest Income 150,000 0 150,000 563,464 0 (413,464) 376%52,428 975% Transfers In 1,235,335 0 1,235,335 720,612 0 514,723 58%641,967 12% Miscellaneous 116,576 0 116,576 49,479 0 67,097 42%170,609 -71% Park Fees 509,300 0 509,300 379,855 0 129,445 75%312,332 22% Total Revenues 47,505,309$ 80,000$ 47,585,309$ 36,097,570$ -$ 11,487,739$ 76%31,429,214$ 15% EXPENDITURES Administration 9,341,007$ 729,900$ 10,070,907$ 4,550,915$ 1,403,278$ 4,116,714$ 59%3,790,174$ 20% Police 6,635,120 1,111,113 7,746,233 3,806,949 763,365 3,175,919 59%3,217,529 18% Fire/EMS 9,990,721 35,083 10,025,804 5,284,444 327,097 4,414,263 56%4,510,333 17% Public Works 4,136,738 652,564 4,789,302 2,002,617 469,893 2,316,792 52%1,552,654 29% Community Services 7,174,446 113,200 7,287,646 2,826,288 465,091 3,996,267 45%2,720,221 4% Development Services 4,173,570 294,487 4,468,057 1,653,069 210,772 2,604,216 42%1,808,346 -9% Engineering 2,601,325 301,867 2,903,192 1,348,963 308,024 1,246,205 57%1,133,357 19% Transfers Out 7,780,485 1,000,000 8,780,485 3,890,243 0 4,890,243 44%5,447,447 -29% Total Expenses 51,833,412$ 4,238,214$ 56,071,627$ 25,363,488$ 3,947,520$ 26,760,618$ 52%24,180,060$ 5% REVENUE OVER (UNDER) EXPENDITURES (4,328,103)$ (4,158,214)$ (8,486,318)$ 10,734,081$ Beginning Fund Balance October 1-Unassigned/Unrestricted 18,925,919 18,925,919 Ending Fund Balance 10,439,601$ 29,660,000$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Franchise fees and other various license and fees are paid quarterly or annually. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% GENERAL FUND 5 Page 19 Item 4. 100% 55% 58% 45% 44% 56% 9% Property Taxes Sales Taxes Franchise Fees Building Permits Other Licenses, Fees & Permits Charges for Services Intergovernmental Revenue (Grants) 0%20%40%60%80%100%120% GENERAL FUND YTD REVENUE % OF ANNUAL BUDGET 6 Page 20 Item 4. $23,472,797 5,582,136 1,405,830 2,154,595 $18,985,659 5,403,899 1,170,894 2,575,876 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Property Taxes Sales Taxes Franchise Fees Building Permits GENERAL FUND REVENUE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 7 Page 21 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Water Charges for Services 17,557,737$ 500,000$ 18,057,737$ 8,510,467$ -$ 9,547,270$ 47%7,927,183$ 7% Sewer Charges for Services 9,462,990 200,000 9,662,990 5,908,647 - 3,754,343 61%5,401,484 9% Licenses, Fees & Permits 377,705 30,000 407,705 228,911 - 178,794 56%210,048 9% Utility Billing Penalties 186,900 - 186,900 112,010 - 74,890 60%104,890 7% Interest Income 60,000 - 60,000 243,027 - (183,027) 405%21,443 1033% Other 467,427 - 467,427 377,518 - 89,909 81%308,624 22% Transfer In - - - - - - 0 - 0% Total Revenues 28,112,759$ 730,000$ 28,842,759$ 15,380,582$ -$ 13,462,177$ 53%13,973,672$ 10% EXPENDITURES Administration 1,558,936$ 199,091$ 1,758,027$ 837,914$ -$ 920,113 48%714,780 17% Debt Service 4,354,465 - 4,354,465 1,850,739 - 2,503,726 43%1 4,463,060 -59% Water Purchases 9,605,940 - 9,605,940 5,306,907 - 4,299,033 55%4,175,072 27% Sewer Management Fee 3,854,505 - 3,854,505 2,294,283 - 1,560,222 60%2,154,513 6% Public Works 11,604,745 382,678 11,987,423 3,542,048 559,964 7,885,412 34%3,221,676 10% Transfer Out 2,877,339 - 2,877,339 677,450 - 2,199,889 24%583,730 16% Total Expenses 33,855,930$ 581,769$ 34,437,699$ 14,509,342$ 559,964$ 17,808,172$ 44%15,312,831$ -5% REVENUE OVER (UNDER) EXPENDITURES (5,743,171)$ 148,231$ (5,594,940)$ 871,240$ (1,339,159)$ Beginning Working Capital October 1 12,669,408 12,669,408$ Ending Working Capital 7,074,468$ 13,540,648$ Notes 1 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% WATER-SEWER FUND 8 Page 22 Item 4. Apr-23 Apr-22 Growth % Average Total Residential Water Consumption by Month WATER SEWER WATER SEWER Change Four Year Cumulative # of Accts Residential 12,282 11,576 11,389 10,674 8.14%FY2023 FY2022 Average Average # of Accts Commercial 434 391 408 364 6.87%October 20,110 16,543 14,882 14,882 Consumption-Residential 123,573,260 75,141,380 98,343,860 74,227,563 15.15%November 11,190 11,256 10,010 24,892 Consumption-Commercial 21,544,860 14,751,380 17,036,930 13,313,800 19.59%December 6,273 7,850 7,663 32,554 Consumption-Commercial Irrigation 13,516,850 9,934,900 36.05%January 8,049 6,936 6,159 38,713 Avg Total Res Water Consumption 10,053 8,613 16.71%February 5,914 7,385 6,618 45,331 Billed ($) Residential 851,916$ 694,735$ 697,231$ 665,228$ 22.19%March 5,839 6,006 6,335 51,665 Billed ($) Commercial 202,145$ 123,129$ 163,390$ 113,817$ 23.72%April 10,053 8,613 8,838 60,503 Billed ($) Commercial Irrigation 119,224$ 86,748$ 37.44%May 13,130 10,904 71,407 Total Billed ($)1,173,285$ 817,863$ 947,369$ 779,045$ 15.33%June 13,330 13,121 84,527 July 22,900 17,334 101,861 August 27,840 22,933 124,794 September 15,450 18,824 143,618 TOTAL (gal)67,428 157,239 143,618 FY2023 FY2022 Average Cumulative October 5.65 2.60 4.56 4.56 November 5.82 2.92 3.07 7.63 December 3.43 0.76 2.84 10.47 January 1.29 0.20 2.62 13.09 February 4.51 2.15 3.05 16.14 March 2.69 2.62 3.92 20.06 April 1.20 5.90 3.97 24.03 May 8.01 5.65 29.68 June 1.90 4.07 33.75 July 0.41 2.27 36.02 August 5.08 2.83 38.85 September 0.26 2.76 41.61 Annual 24.59 32.81 41.61 Rainfall TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% WATER-SEWER FUND 9 Page 23 Item 4. 47% 61% 56% 60% 81% Water Charges for Services Sewer Charges for Services Licenses, Fees & Permits Utility Billing Penalties Other 0%20%40%60%80%100% WATER/SEWER REVENUE YTD % OF ANNUAL BUDGET 10 Page 24 Item 4. $8,510,467 5,306,907 $7,927,183 4,175,072 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 $8,000,000 $9,000,000 Water Charges for Services Water Purchases WATER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 11 Page 25 Item 4. 5,908,647 2,294,283 5,401,484 2,154,513 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 Sewer Charges for Services Sewer Management Fee SEWER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 12 Page 26 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sanitation Charges for Services 2,158,200 - 2,158,200 1,381,918 - 776,282 64%1,076,796 28% Interest Income - - - 834 - (834) 0%- 0% Transfer In 1,750,000 - 1,750,000 - - 1,750,000 0%- 0% Total Revenues 3,908,200$ -$ 3,908,200$ 1,382,752$ -$ 2,525,448$ 35%1,076,796$ 28% EXPENDITURES Administration 1,750,000$ -$ 1,750,000$ 35,090$ 14,910$ 1,700,000 3%- 0% Sanitation Collection 2,158,200 - 2,158,200 1,166,901 - 991,299 54%923,653 26% Transfer Out - - - - - - 0%- 0% Total Expenses 3,908,200$ -$ 3,908,200$ 1,201,991$ 14,910$ 2,691,299$ 31%923,653$ 30% REVENUE OVER (UNDER) EXPENDITURES -$ -$ -$ 180,761$ 153,143$ Beginning Working Capital October 1 - -$ Ending Working Capital -$ 180,761$ 153,143$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% SOLID WASTE FUND 13 Page 27 Item 4. 1,381,918 1,166,901 1,076,796 923,653 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 Sanitation Charges for Services Sanitation Collection SOLID WASTE REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 14 Page 28 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes-Delinquent 75,000$ -$ 75,000$ 96,202$ -$ (21,202)$ 128%76,002$ 27% Property Taxes-Current 12,605,972 - 12,605,972 12,670,565 - (64,593) 101%1 10,395,492 22% Taxes-Penalties - - - 23,603 - (23,603) 0%28,514 -17% Interest Income 20,000 - 20,000 89,454 - (69,454) 447%10,219 775% Transfer In - - - - - - 0%428,581 -100% Total Revenues 12,700,972$ -$ 12,700,972$ 12,879,824$ -$ (178,852)$ 101%10,938,809$ 18% EXPENDITURES Professional Services -$ -$ -$ -$ -$ -$ 0%-$ 0% Bond Administrative Fees 20,000 0 20,000 500 0 19,500 3%600 -17% 2013 GO Refunding Bond 180,000 0 180,000 0 0 180,000 0%0 0% 2014 GO Bond Payment 315,000 0 315,000 0 0 315,000 0%0 0% 2015 GO Bond Payment 1,309,200 0 1,309,200 1,309,200 0 - 100%1,220,300 7% 2015 CO Bond Payment 465,000 0 465,000 465,000 0 - 100%445,000 4% 2016 GO Debt Payment 0 0 0 0 0 - 0%0 0% 2016 CO Debt Payment 80,000 0 80,000 80,000 0 - 100%70,000 14% 2017 CO Debt Payment 85,000 0 85,000 85,000 0 - 100% 2 70,000 21% 2018 GO Debt Payment 145,000 0 145,000 145,000 0 - 100%145,000 0% 2018 CO Debt Payment 475,000 0 475,000 475,000 0 - 100%455,000 4% 2019 CO Debt Payment 399,806 0 399,806 399,806 0 1 100%381,123 5% 2019 GO Debt Payment 160,000 0 160,000 160,000 0 - 100%155,000 3% 2020 CO Debt Payment 255,000 0 255,000 255,000 0 - 100%245,000 4% 2021 CO Debt Payment 245,000 0 245,000 245,000 0 - 100%310,000 -21% 2021 GO Debt Payment 1,225,000 0 1,225,000 1,225,000 0 - 100%1,925,000 -36% 2022 GO Debt Payment 1,890,000 0 1,890,000 1,890,000 0 - 100%0 0% Bond Interest Expense 5,662,157 0 5,662,157 2,785,327 0 2,876,830 49%2,238,972 24% Total Expenditures 12,911,163$ -$ 12,911,163$ 9,519,832$ -$ 3,391,331$ 74%10,250,995$ -7% REVENUE OVER (UNDER) EXPENDITURES (210,191)$ -$ (210,191)$ 3,359,992$ 687,814$ Beginning Fund Balance October 1 683,357 683,357 2,619,367 Ending Fund Balance Current Month 473,166$ 4,043,349$ 3,307,181$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% DEBT SERVICE FUND 15 Page 29 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 2,741,662$ -$ 2,741,662$ 1,501,446$ -$ 1,240,216$ 55%1,438,899$ 4% Interest Income 1,200 - 1,200 (252) - 1,452 -21%448 -156% Other - - - - - - 0%- 0% Total Revenue 2,742,862$ -$ 2,742,862$ 1,501,194$ -$ 1,241,668$ 55%1,439,347$ 4% EXPENDITURES Personnel 2,711,865$ -$ 2,711,865$ 1,584,807$ -$ 1,127,058$ 58%1,149,476$ 38% Other 1,200 - 1,200 (9,299) - 10,499 -775%469 -2083% Total Expenditures 2,713,065$ -$ 2,713,065$ 1,575,509$ -$ 1,137,556$ 58%1,149,945$ 37% REVENUE OVER (UNDER) EXPENDITURES 29,797$ -$ 29,797$ (74,314)$ 289,402$ Beginning Fund Balance October 1 453,711 453,711 302,439 Ending Fund Balance Current Month 483,508$ 379,397$ 591,841$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% CRIME CONTROL AND PREVENTION SPECIAL PURPOSE DISTRICT 16 Page 30 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 2,710,483$ -$ 2,710,483$ 1,499,677$ -$ 1,210,806$ 55%1,435,143$ 4% Interest Income 600 - 600 1,393 - (793) 232%242 476% Other - - - - - - 0%- 0% Total Revenue 2,711,083$ -$ 2,711,083$ 1,501,070$ -$ 1,210,013$ 55%1,435,385$ 5% EXPENDITURES Personnel 2,682,642$ -$ 2,682,642$ 1,511,326$ -$ 1,171,316$ 56%1,267,866$ 19% Other 2,400 - 2,400 (9,299) - 11,699 -387%469 -2083% Total Expenditures 2,685,042$ -$ 2,685,042$ 1,502,027$ -$ 1,183,015$ 56%1,268,334$ 18% REVENUE OVER (UNDER) EXPENDITURES 26,041$ -$ 26,041$ (957)$ 167,050$ Beginning Fund Balance October 1 457,409 457,409 203,982 Ending Fund Balance Current Month 483,450$ 456,452$ 371,032$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% FIRE CONTROL, PREVENTION, AND EMERGENCY MEDICAL SERVICES SEPCIAL PURPOSE DISTRICT 17 Page 31 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Grant Revenue -$ -$ -$ -$ -$ -$ 0%-$ 0% Other Reimbursements 150,000 - 150,000 - - 150,000 0%- 0% Interest Income 25,000 - 25,000 93,676 - (68,676) 375%8,156 1049% Charges for Services 1,385,257 - 1,385,257 808,067 - 577,190 58%682,615 18% Total Revenue 1,560,257$ -$ 1,560,257$ 901,743$ -$ 658,514$ 58%690,772$ 31% EXPENDITURES Vehicle Replacement 754,100$ 69,135$ 823,235$ 137,570$ 75,176$ 610,489$ 26%392,447$ -65% Equipment Replacement 170,906 - 170,906 9,461 - 161,445 6%- 0% Technology Replacement 293,200 120,277 413,477 20,782 104,260 288,435 30%194,034 -89% Total Expenditures 1,218,206$ 189,412$ 1,407,618$ 167,813$ 179,436$ 1,060,369$ 25%586,481$ -71% REVENUE OVER (UNDER) EXPENDITURES 342,051$ (189,412)$ 152,639$ 733,930$ 104,291$ Beginning Fund Balance October 1 3,957,862 3,957,862 3,957,862 Ending Fund Balance Current Month 4,110,501$ 4,691,792$ 4,062,153$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% VEHICLE AND EQUIPMENT REPLACEMENT FUND 18 Page 32 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 45-4 Storm Drainage Utility Fee 825,000$ -$ 825,000$ 496,191$ -$ 328,809$ 60%459,498$ 8% Drainage Review Fee 3,000 - 3,000 3,150 - (150) 105%2,428 30% 45-4 Interest Income 1,800 - 1,800 (2,925) - 4,725 -162%1,260 -332% Transfer In - - - - - - 0%531,449 -100% Other Revenue - - - 2,096 - (2,096) 0%- 0% Total Revenue 829,800$ -$ 829,800$ 498,513$ -$ 331,287$ 60%994,635$ -50% EXPENDITURES Personnel Services 181,914$ -$ 181,914$ 92,688$ -$ 89,226$ 51%82,584$ 12% Debt Service 217,575 - 217,575 149,610 - 67,965 69%2 736,206 -80% 45-7 Operating Expenditures 288,177 82,706 370,883 97,004 (25,282) 299,161 19%40,056 142% Transfers Out 107,996 - 107,996 62,998 - 44,998 58%1 560,508 -89% Total Expenses 795,662$ 82,706$ 878,368$ 402,300$ (25,282)$ 501,350$ 43%1,419,354$ -72% REVENUE OVER (UNDER) EXPENDITURES 34,138$ (82,706)$ (48,568)$ 96,213$ (424,719)$ Beginning Working Capital October 1 816,012 816,012 632,579 Ending Working Capital Current Month 767,444$ 912,225$ 207,860$ Notes 1 Capital project funds are transferred as needed; General fund transfers are made monthly. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% STORM DRAINAGE UTILITY FUND 19 Page 33 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 60-4Park Dedication-Fees 964,000$ -$ 964,000$ -$ -$ 964,000$ 0%97,378$ -100% Park Dedication - Transfers In - - - - - - 0%- 0% 60-4Park Improvements 873,000 - 873,000 - - 873,000 0%299,766 -100% Contributions/Grants 200,550 - 200,550 - - 200,550 0%- 0% 60-4Interest-Park Dedication 2,000 - 2,000 19,041 - (17,041) 952%3,968 380% 60-4Interest-Park Improvements 4,050 - 4,050 22,176 - (18,126) 548%2,079 967% Total Revenue 2,043,600$ -$ 2,043,600$ 41,217$ -$ 2,002,383$ 2%403,191$ -90% EXPENDITURES Cockrell Park Trail Connection -$ -$ -$ -$ -$ -$ 0%-$ 0% Park Dedication Land Acquisition - - - - - - 0%- 0% Hike & Bike Master Plan - - - - - - 0%- 0% Hays Park - - - - - - 0%35,560 -100% Pecan Grove H&B Trail - - - - - - 0%- 0% Pecan Grove Park - 798,971 798,971 244,819 602,726 (48,575) 106%- 0% Windsong Neighborhood Park 100,000 - 100,000 - - 100,000 0%- 0% Capital (Misc. small projects)- - - - - - 0%12,298 -100% Total Expenses 100,000$ 798,971$ 898,971$ 244,819$ 602,726$ 51,425$ 94%47,858$ 412% REVENUE OVER (UNDER) EXPENDITURES 1,943,600$ (798,971)$ 1,144,630$ (203,602)$ Beginning Fund Balance October 1 2,140,734 2,140,734 2,660,035 Ending Fund Balance Current Month 3,285,364$ 1,937,132$ 2,660,035$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% PARK DEDICATION AND IMPROVEMENT FUNDS 20 Page 34 Item 4. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Impact Fee Revenue: Water Impact Fees -$ -$ -$ -$ -$ 0%259,800$ -100% Wastewater Impact Fees - - - 117,068 (117,068) 0%474,773 -75% East Thoroughfare Impact Fees 200,000 - 200,000 - 200,000 0%1,318,973 -100% Property Taxes - Town (Current)824,243 - 824,243 810,076 14,167 98%612,991 32% Property Taxes - Town (Rollback)- - - - - 0%- 0% Property Taxes - County (Current)184,704 - 184,704 - 184,704 0%144,308 -100% Sales Taxes - Town 1,024,068 - 1,024,068 537,206 486,862 52%471,133 14% Sales Taxes - EDC 857,656 - 857,656 449,910 407,746 52%394,574 14% Interest Income 6,000 - 6,000 44,898 (38,898) 748%2,927 1434% Transfer In - - - - - 0%- 0% Total Revenue 3,096,671$ -$ 3,096,671$ 1,959,159$ 1,137,512$ 63%3,679,480$ -47% EXPENDITURES Professional Services 6,000$ -$ 6,000$ -$ 6,000$ 0%-$ 0% Developer Rebate 3,090,671 - 3,090,671 - 3,090,671$ 0%1,207,639 -100% Transfers Out - - - - -$ 0%- 0% Total Expenses 3,096,671$ -$ 3,096,671$ -$ 3,096,671$ 0%1,207,639$ -100% REVENUE OVER (UNDER) EXPENDITURES -$ 1,959,159$ 2,471,841$ Beginning Fund Balance October 1 1,392,520 1,392,520 301,260 Ending Fund Balance Current Month 1,392,520$ 3,351,679$ 2,773,101$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% TIRZ #1 - BLUE STAR 21 Page 35 Item 4. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes - Town (Current)33,166$ -$ 33,166$ 33,061$ 105$ 100%154,136$ -79% Property Taxes - Town (Rollback)- - - - - 0%- 0% Property Taxes - County (Current)7,432 - 7,432 - 7,432 0%30,280 -100% Sales Taxes - Town - - - - - 0%- 0% Sales Taxes - EDC - - - - - 0%- 0% Interest Income 75 - 75 798 (723) 1064%(14) -5617% Total Revenue 40,673$ -$ 40,673$ 33,860$ 6,814$ 83%184,402$ -82% EXPENDITURES Professional Services -$ -$ -$ -$ - 0%-$ 0% Developer Rebate 40,673 - 40,673 - 40,673 0%- 0% Transfers Out - - - - - 0%- 0% Total Expenditures 40,673$ -$ 40,673$ -$ 40,673$ 0%-$ 0% REVENUE OVER (UNDER) EXPENDITURES -$ 33,860$ 184,402$ Beginning Fund Balance October 1 24,835 24,835 25,189 Ending Fund Balance Current Month 24,835$ 58,695$ 209,591$ TIRZ #2 TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% 22 Page 36 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Water 3,500,000$ -$ 3,500,000$ 1,556,378$ Interest Income 45,000 - 45,000 109,900 Total Revenues 3,545,000$ -$ 3,545,000$ 1,666,279$ EXPENDITURES Developer Reimbursements Cambridge Park Estates - 0 - 0 180,350 - (180,350) - (180,350) Parks at Legacy Developer Reimb 250,000 250,000 - 250,000 - - 250,000 - 250,000 Star Trail Developer Reimb 367,000 367,000 - 367,000 639,029 - (272,029) - (272,029) Victory at Frontier Developer Reimb 42,000 42,000 - 42,000 - - 42,000 - 42,000 Westside Developer Reimb - - - - - - - - - TVG Windsong Developer Reimb 625,000 625,000 - 625,000 1,083 - 623,917 - 623,917 Total Developer Reimbursements 1,284,000$ 1,284,000$ -$ 1,284,000$ 820,463$ -$ 463,537$ -$ 463,537$ Capital Expenditures 12" Water Line - DNT 200,000 24,250 85,042 109,292 25,438 59,832 24,022 90,708 109,064 Lower Pressure Plane Easements 1,000,000 1,400,000 - 1,400,000 95 - 1,399,905 - 999,905 Impact Fee Study 100,000 - - - 165 99,835 (100,000) - - Lower Pressure Plane 3,100,000 3,200,000 - 3,200,000 - - 3,200,000 - 3,100,000 Total Projects 4,400,000$ 4,624,250$ 85,042$ 4,709,292$ 25,698$ 159,667$ 4,523,927$ 90,708$ 4,208,969$ Transfer to CIP Fund - - - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 5,684,000$ 5,908,250$ 85,042$ 5,993,292$ 846,160$ 159,667$ 4,987,464$ 90,708$ 4,672,506$ REVENUE OVER (UNDER) EXPENDITURES (2,448,292)$ 820,118$ Beginning Fund Balance October 1 4,366,761 4,366,761 Ending Fund Balance Current Month 1,918,469$ 5,186,879$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 WATER IMPACT FEES FUND 23 Page 37 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Wastewater 1,750,000$ -$ 1,750,000$ 1,200,088$ Interest Income 14,625 - 14,625 54,648 Upper Trinity Equity Fee 300,000 - 300,000 165,500 Total Revenues 2,064,625$ -$ 2,064,625$ 1,420,236$ EXPENDITURES Developer Reimbursements TVG Westside Utility Developer Reimb 350,000 350,000 - 350,000 73,372 - 276,628 - 276,628 Prosper Partners Utility Developer Reimb 100,000 100,000 - 100,000 - - 100,000 100,000 Frontier Estates Developer Reimb 25,000 25,000 - 25,000 683 - 24,317 - 24,317 LaCima Developer Reimb 20,000 20,000 - 20,000 - - 20,000 - 20,000 Brookhollow Developer Reimb 100,000 100,000 - 100,000 2,822 - 97,178 - 97,178 TVG Windsong Developer Reimb 700,000 700,000 - 700,000 174,964 - 525,036 - 525,036 All Storage Developer Reimb 50,000 50,000 - 50,000 9,030 - 40,970 - 40,970 Legacy Garden Developer Reimb 60,000 60,000 - 60,000 1,366 - 58,634 - 58,634 Total Developer Reimbursements 1,405,000$ 1,405,000$ -$ 1,405,000$ 262,237$ -$ 1,142,763$ -$ 1,142,763$ Capital Expenditures Doe Branch Wastewater Lines 475,000 212,000 314,400 526,400 47,000 766,506 (287,106) 48,600 (335,706) Impact Fee Study 100,000 - - - 165 99,835 (100,000) - (100,000) Total Projects 575,000$ 212,000$ 314,400$ 526,400$ #47,165$ 866,341$ (387,106)$ 48,600$ (435,706)$ Transfer to CIP Fund - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 1,980,000$ 1,617,000$ 314,400$ 1,931,400$ 309,402$ 866,341$ 755,657$ 48,600$ 707,057$ REVENUE OVER (UNDER) EXPENDITURES 133,225$ 1,110,835$ Beginning Fund Balance October 1 2,733,394 2,733,394 Ending Fund Balance Current Month 2,866,619$ 3,844,229$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 WASTEWATER IMPACT FEES FUND 24 Page 38 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES East Thoroughfare Impact Fees 1,000,000$ -$ 1,000,000$ 1,414,190$ East Thoroughfare Other Revenue - - - - West Thoroughfare Impact Fees 4,000,000 - 4,000,000 2,374,845 West Thoroughfare Other Revenue - - - - Interest-East Thoroughfare Impact Fees 14,000 - 14,000 57,968 Interest-West Thoroughfare Impact Fees 45,000 - 45,000 87,022 Total Revenues 5,059,000$ -$ 5,059,000$ 3,934,026$ EXPENDITURES East FM 1461 (SH289-CR 165)175,000 175,000 - 175,000 77,074 - 97,927 154,147 (56,221) Coleman Median Landscape (Talon-Victory)30,000 - - - - - -25,200 4,800 Coit Road (First - Frontier)1,289,900 50,000 364,755 414,755 - 364,755 50,000 925,776 (630) Traffic Signal - Coit & Richland - - - - - -- - - Impact Fee Study 50,000 - - - 165 49,835 (50,000) - - Cambridge Park Estates - - - - 174,494 - (174,494) - (174,494) Transfer to Capital Project Fund 1,820,000 1,820,000 - 1,820,000 158,383 - 1,661,617 1,661,617 Total East 3,364,900$ 2,045,000$ 364,755$ 2,409,755$ 410,115$ 414,590$ 1,585,050$ 1,105,123$ 1,435,073$ West Teel 380 Intersection Improvements 100,000 0 1,000 1,000 358,413 1,615 (359,028) 100,985 (361,013) Fishtrap (Elem-DNT)6,600,000 6,600,000 - 6,600,000 - - 6,600,000 - 6,600,000 Traffic Signal 300,000 - - - - - - 269,492 30,508 Parks at Legacy Developer Reimb 500,000 500,000 - 500,000 102,901 - 397,099 - 397,099 Star Trail Developer Reimb 1,500,000 1,500,000 - 1,500,000 2,566,792 - (1,066,792) - (1,066,792) Tellus Windsong Developer Reimb 750,000 750,000 - 750,000 4,680 - 745,320 - 745,320 Legacy Garden Developer Reimb 200,000 200,000 - 200,000 - - 200,000 - 200,000 Impact Fee Study 50,000 - - - 165 49,835 (50,000) - (50,000) Transfer to Capital Project Fund - - - - 31,025 - (31,025) (31,025) Total West 10,000,000$ 9,550,000$ 1,000$ $ 3,063,976 9,551,000 $ 51,450$ 6,435,574$ 370,477$ 6,464,097$ Total Expenditures 13,364,900$ 11,595,000$ 365,755$ 11,960,755$ 3,474,090$ 466,040$ 8,020,624$ 1,475,600$ 7,899,169$ REVENUE OVER (UNDER) EXPENDITURES (6,901,755)$ 459,935$ Beginning Fund Balance October 1 10,678,812 10,678,812 Ending Fund Balance Current Month 3,777,058$ 11,138,747$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 THOROUGHFARE IMPACT FEES FUND 25 Page 39 Item 4. WATER WASTEWATER EAST THOROUGHFARE WEST THOROUGHFARE ANNUAL BUDGET $3,500,000 $1,750,000 $1,000,000 4,000,000 YTD ACTUAL $1,556,378 $1,200,088 $1,414,190 $2,374,845 % OF BUDGET 44%69%141%59% 44% 69% 141% 59% $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 IMPACT FEE REVENUE YTD Actual to Annual Budget 26 Page 40 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year Police Donation Revenue 15,500$ -$ 15,500$ 16,461$ -$ (961)$ 106%8,799$ 87% Fire Donation Revenue 15,500 - 15,500 9,029 - 6,471 58%8,668 4% Child Safety Revenue 28,000 - 28,000 6,420 - 21,580 23%7,560 -15% Court Security Revenue 8,000 - 8,000 6,889 - 1,111 86%4,193 64% Court Technology Revenue 7,650 - 7,650 5,734 - 1,916 75%3,536 62% Municipal Jury revenue 150 - 150 136 - 14 91%81 68% Interest Income 2,425 - 2,425 14,895 - (12,470) 614%1,753 750% Interest Income CARES/ARPA Funds - - - 123,552 - (123,552) 0%6,386 1835% Tree Mitigation - - - 244,038 - (244,038) 0%- 0% Miscellaneous 3,000 - 3,000 2,416 - 584 81%2,997 -19% CARES Act/ARPA Funding 3,045,165 - 3,045,165 - - 3,045,165 0%6,018 -100% Transfer In - - - - - - 0%- 0% Total Revenue 3,125,390$ -$ 3,125,390$ 429,569$ -$ 2,695,821$ 14%49,991$ 759% EXPENDITURES LEOSE Expenditure 17,500$ -$ 17,500$ 3,300$ -$ 14,200$ 19%-$ 0% Court Technology Expense - - - - - - 0%10,688 -100% Court Security Expense 15,675 - 15,675 50 - 15,625 0%- 0% Police Donation Expense 38,740 - 38,740 17,842 - 20,898 46%8,237 117% Fire Donation Expense 5,387 5,000 10,387 8,546 - 1,841 82%- 0% Child Safety Expense 39,761 19,985 59,746 22,238 - 37,508 37%2,706 722% Tree Mitigation Expense - - - - - - 0%33,600 -100% Police Seizure Expense 12,995 - 12,995 - - - 0%- 0% CARES Act/ARPA Funding - - - - - - 0%- 0% Transfer Out (Tree Mitigation funds)- - - - - - 0%- 0% Total Expenses 130,058$ 24,985$ 155,043$ 51,976$ -$ 90,072$ 34%55,231$ -6% REVENUE OVER (UNDER) EXPENDITURES 2,995,332$ (24,985)$ 2,970,347$ 377,593$ (5,240)$ Beginning Fund Balance October 1 817,219 817,219 567,535 Ending Fund Balance Current Month 3,787,566$ 1,194,812$ 562,295$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 Expected Year to Date Percent 58.33% SPECIAL REVENUE FUNDS 27 Page 41 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Grants -$ -$ -$ -$ Contributions/Interlocal Revenue - - - - Bond Proceeds - - - - Interest Income - - - 1,006,355 Other Revenue - - - 5,460 Transfers In - General Fund - 1,000,000 1,000,000 3,890,243 Professional Svc - Upper Doe Branch WW Line -$ -$ -$ -$ -$ Transfers In - Impact Fee Funds - - - 189,408 *Transfers In/Out - Bond Funds - - - - Total Revenues -$ 1,000,000$ 1,000,000$ 5,091,465$ EXPENDITURES Frontier Parkway BNSF Overpass 9,293,771 -$ - - - - - 9,345,276 (51,505) West Prosper Roads 14,168,828 - - - - - - 14,017,321 151,507 BNSF Quiet Zone First/Fifth 145,000 - 4,950 4,950 4,218 732 - 17,146 122,904 Coit Rd (First-Frontier) 4 Lns 2,089,900 - - - 114 - (114) 2,089,786 First St (DNT to Coleman)5,786,567 - 1,584,883 1,584,883 136,836 467,643 980,404 1,540,745 3,641,343 Fishtrap (Elem-DNT) 4 Lanes 30,807,380 - 26,870,802 26,870,802 627,820 26,287,507 (44,525) 3,127,872 764,181 First St (Coit-Custer) 4 Lanes 27,260,000 - 22,840,969 22,840,969 1,983,829 21,023,041 (165,901) 2,744,075 1,509,055 Preston/Prosper Trail Turn Lane 900,000 - - - 21,355 147,591 (168,946) - 731,054 Craig Street (Preston-Fifth)450,000 - 148,005 148,005 87,180 73,325 (12,500) 175,595 113,900 Fishtrap Section 1 & 4 778,900 - 5,000 5,000 5,000 - - 382,323 391,577 Fishtrap (Teel - Gee Road)6,425,000 - 6,025,000 6,025,000 552,320 5,849,269 (376,589) 247 23,164 Gee Road (Fishtrap - Windsong)4,949,000 - 4,169,579 4,169,579 1,071,224 2,591,162 507,193 4,052 1,282,561 Teel (US 380 Intersection Improvements)1,480,000 - 200,000 200,000 11,436 951,760 (763,196) 106,198 410,606 Coleman (Gorgeous - Prosper Trail)1,500,000 - 740,906 740,906 212,063 528,843 - 120,534 638,561 Coleman (Prosper Trail - PHS)1,150,000 - - - - - - - 1,150,000 Legacy (Prairie - Fishtrap)1,425,000 - 1,133,307 1,133,307 305,333 252,974 575,000 235,694 631,000 Coit/US 380 SB Turn Lanes 300,000 - - - 5,608 44,392 (50,000) - 250,000 Safety Way 800,000 - 800,000 800,000 - - 800,000 - 800,000 Gorgeous/McKinley 700,000 - 700,000 700,000 - - 700,000 - 700,000 Renaming of Fishtrap Road to W. First Street 80,000 - - - - - - - 80,000 First Street (Coleman)500,000 - 500,000 500,000 - - 500,000 - 500,000 Teel Parkway (US 380 - Fishtrap Rd) NB 2 Lanes (Design)750,000 - 135,700 135,700 102,150 33,550 - 82,943 531,357 Total Street Projects 111,739,346$ -$ 65,859,101$ 65,859,101$ 5,126,486$ 58,251,788$ 2,480,827$ 31,900,019$ 16,461,053$ Turf Irrigation SH289 68,000 - - - - - - 48,935 19,065 US 380 Median Design (Green Ribbon)821,250 - - - - - - 65,800 755,450 Whitley Place H&B Trail Extension 750,000 - - - - - - 734,209 15,791 Tanner's Mill Phase 2 Design 1,396,400 - 688,651 688,651 588,768 100,272 (388) 696,070 11,291 Lakewood Preserve, Phase 2 3,845,000 - - - - 131,477 (131,477) - 3,713,523 Pecan Grove Ph II 907,500 - 4,352 4,352 796 3,556 - 66,105 837,043 Downtown Pond Improvements 120,000 - - - - - - 11,760 108,240 Sexton Park Phase I 1,200,000 - 936,986 936,986 82,524 854,462 - 154,672 108,342 Coleman Median Landscape (Victory-Preston)650,000 - 432,358 432,358 90,360 346,186 (4,188) 19,783 193,671 Prosper Trail Median Landscape 275,000 - 146,481 146,481 45,736 103,679 (2,934) 7,352 118,234 Total Park Projects 10,033,150$ -$ 2,208,828$ 2,208,828$ 808,184$ 1,539,632$ (138,988)$ 1,804,685$ 5,880,649$ PD Car Camera and Body worn Camera System 387,225 - 17,000 17,000 14,500 2,500 - - 370,225 Station #3 Quint Engine 1,495,000 - 118,273 118,273 39,313 51,532 27,427 1,376,727 27,427 Station #3 Ambulance 495,000 - 79,251 79,251 3,951 32,622 42,677 415,749 42,677 Park Ops Vehicle 27,035 - - - 23,242 - (23,242) - 3,793 Awnings for Storage 19,800 - 300 300 - 300 - 11,100 8,400 Public Safety Complex, Phase 2-Design 1,578,290 - 205,380 205,380 112,899 91,871 610 1,373,520 - Public Safety Complex, Phase 2-Dev Costs 647,325 - 555,818 555,818 17,602 11,375 526,842 91,507 526,842 TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 CAPITAL PROJECTS FUND - GENERAL 28 Page 42 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 CAPITAL PROJECTS FUND - GENERAL Public Safety Complex, Phase 2-Construction 14,500,000 - 8,903,575 8,903,575 6,754,442 2,149,000 134 5,596,425 134 Public Safety Complex, Phase 2-FFE 1,274,385 - 1,224,224 1,224,224 457,812 405,574 360,838 50,161 360,838 Fire Engine Station 4 - FUNDS REALLOCATED 1,100,000 - - - - - - - 1,100,000 Fire Station #4 - Design 600,000 - 285,616 285,616 135,048 150,568 - 337,939 (23,555) Fire Station #4 - Engine 1,250,000 - 117,557 117,557 38,022 51,651 27,884 1,132,443 27,884 Fire Station #4 - Ambulance 552,000 - 509,445 509,445 3,602 453,225 52,618 42,555 52,618 Fire Station #4 - Other Costs 400,000 - - - - - - 8,250 391,750 Total Facility Projects 24,326,060$ -$ 12,016,439$ 12,016,439$ 7,600,433$ 3,400,218$ 1,015,788$ 10,436,376$ 2,889,032$ Transfer Out - - - - - - - - - Total Expenditures 146,098,556$ -$ 80,084,368$ 80,084,368$ 13,535,103$ 63,191,639$ 3,357,627$ 44,141,080$ 25,230,735$ REVENUE OVER (UNDER) EXPENDITURES (79,084,368)$ (8,443,638)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 77,609,702 77,609,702 Ending Fund Balance (Restricted for Capital Projects) Current Month (1,474,666)$ 69,166,064$ 29 Page 43 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Year Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Interest Income -$ -$ -$ 488,853$ Bond Proceeds - - - - Transfers In - - - 19,835 Transfers In - Impact Fee Funds - - - - Transfers In - Bond Funds - - - (0) Total Revenues -$ -$ -$ 508,688$ EXPENDITURES Lower Pressure Plane Pump Station Design 24,331,100 - 16,204,853 16,204,853 3,292,603 13,493,221 (580,971) 1,701,715 5,843,562 Custer Rd Meter Station/Water Line Relocation 3,869,563 - 826 826 48,276 - (47,450) 3,832,735 (11,448) Doe Branch Parallel Interceptor 15,000 - -- - - -15,000 - Upper Doe Branch WW Line (Teel-PISD Stadium)250,000 - -- - - -- 250,000 Water Line Relocation Frontier 4,000,000 - 398,239 398,239 17,795 383,808 (3,363) 2,041 3,596,357 Total Water & Wastewater Projects 32,465,663$ -$ 16,603,918$ 16,603,918$ 3,358,674$ 13,877,028$ (631,784)$ 5,551,490$ 9,678,471$ Frontier Park/Preston Lakes Drainage 1,085,000 - 148,379 148,379 140,960 7,419 0 648,022 288,599 Old Town Regional Pond #2 385,000 - 17,114 17,114 - 17,114 - 31,210 336,677 Total Drainage Projects 1,470,000$ -$ 165,493$ 165,493$ 140,960$ 24,532$ 0$ 679,232$ 625,276$ Transfer out - - - - - - - - Total Expenses 33,935,663$ -$ 16,769,410$ 16,769,410$ 3,499,634$ 13,901,561$ (631,784)$ 6,230,722$ 10,303,747$ REVENUE OVER (UNDER) EXPENDITURES (16,769,410)$ (2,990,945)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 40,601,835 40,601,835 Ending Fund Balance (Restricted for Capital Projects) Current Month 23,832,425$ 37,610,890$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT April 30, 2023 CAPITAL PROJECTS FUND-WATER/SEWER 30 Page 44 Item 4. MONTHLY FINANCIAL REPORT as of May 31, 2023 Cash/Budgetary Basis Prepared by Finance Department September 12, 2023 Page 45 Item 4. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 2023 Table of Contents Dashboard Charts 3 - 4 General Fund 5 Water-Sewer Fund 8 Solid Waste Fund 13 Debt Service Fund 15 Crime Control and Prevention Special Purpose District 16 Fire Control, Prevention, and Emergency Medical Services Special Purpose District 17 Vehicle and Equipment Replacement Fund 18 Storm Drainage Utility Fund 19 Park Dedication and Improvement Fund 20 TIRZ #1 - Blue Star 21 TIRZ #2 22 Water Impact Fees Fund 23 Wastewater Impact Fees Fund 24 Thoroughfare Impact Fees Fund 25 Special Revenue Fund 27 Capital Projects Fund-General 28 Capital Projects Fund-Water/Sewer 30 Page 46 Item 4. 0 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 Total Budget YTD Budget YTD Actual Building Permit Revenues 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept Town of Prosper, Texas Sales Tax Revenue by Month FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY22/23 3 Page 47 Item 4. 0 6288751.47 $56.072 $37.381 $28.579 $47.585 $31.724 $38.918 $- $10 $20 $30 $40 $50 $60 Total Budget YTD Budget YTD Actual In Millions General Fund Revenues and Expenditures Revenues Expenditures $34.438 $22.958 $17.383 $28.843 $19.229 $18.066 $- $5 $10 $15 $20 $25 $30 $35 $40 Total Budget YTD Budget YTD Actual In Millions Water -Sewer Fund Revenues and Expenditures Revenues Expenditures 4 Page 48 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actuals Encumbrances Budget Balance YTD Percent Note YTD Actuals Prior Year REVENUES Property Taxes 23,519,547$ -$ 23,519,547$ 23,674,605$ -$ (155,058)$ 101%1 19,051,183$ 24% Sales Taxes 10,220,208 0 10,220,208 6,578,693 0 3,641,515 64%6,261,771 5% Franchise Fees 2,404,527 0 2,404,527 1,702,310 0 702,217 71%2 1,238,696 37% Building Permits 4,781,000 0 4,781,000 2,415,771 0 2,365,229 51%2,918,368 -17% Other Licenses, Fees & Permits 1,552,430 80,000 1,632,430 1,230,264 0 402,166 75%1,416,019 -13% Charges for Services 1,240,961 0 1,240,961 831,862 0 409,099 67%599,718 39% Fines & Warrants 250,425 0 250,425 262,698 0 (12,273) 105%161,184 63% Intergovernmental Revenue (Grants)1,525,000 0 1,525,000 140,535 0 1,384,465 9%270,881 -48% Interest Income 150,000 0 150,000 714,987 0 (564,987) 477%63,012 1035% Transfers In 1,235,335 0 1,235,335 833,087 0 402,248 67%733,676 14% Miscellaneous 116,576 0 116,576 94,407 0 22,169 81%177,018 -47% Park Fees 509,300 0 509,300 439,016 0 70,284 86%499,481 -12% Total Revenues 47,505,309$ 80,000$ 47,585,309$ 38,918,236$ -$ 8,667,073$ 82%33,391,008$ 17% EXPENDITURES Administration 9,341,007$ 729,900$ 10,070,907$ 5,183,542$ 1,257,237$ 3,630,128$ 64%4,236,892$ 22% Police 6,635,120 1,111,113 7,746,233 4,361,814 750,212 2,634,206 66%3,672,741 19% Fire/EMS 9,990,721 35,083 10,025,804 6,160,631 211,509 3,653,665 64%5,134,137 20% Public Works 4,136,738 652,564 4,789,302 2,296,390 332,522 2,160,390 55%1,733,328 32% Community Services 7,174,446 113,200 7,287,646 3,257,223 473,850 3,556,573 51%3,073,065 6% Development Services 4,173,570 294,487 4,468,057 1,870,778 160,759 2,436,521 45%2,181,915 -14% Engineering 2,601,325 301,867 2,903,192 1,558,244 293,545 1,051,404 64%1,301,704 20% Transfers Out 7,780,485 1,000,000 8,780,485 3,890,243 0 4,890,243 44%5,805,363 -33% Total Expenses 51,833,412$ 4,238,214$ 56,071,627$ 28,578,863$ 3,479,634$ 24,013,130$ 57%27,139,145$ 5% REVENUE OVER (UNDER) EXPENDITURES (4,328,103)$ (4,158,214)$ (8,486,318)$ 10,339,373$ 6,251,863$ Beginning Fund Balance October 1-Unassigned/Unrestricted 18,925,919 18,925,919 Ending Fund Balance 10,439,601$ 29,265,292$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Franchise fees and other various license and fees are paid quarterly or annually. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% GENERAL FUND 5 Page 49 Item 4. 101% 64% 71% 51% 75% 67% 9% Property Taxes Sales Taxes Franchise Fees Building Permits Other Licenses, Fees & Permits Charges for Services Intergovernmental Revenue (Grants) 0%20%40%60%80%100%120% GENERAL FUND YTD REVENUE % OF ANNUAL BUDGET 6 Page 50 Item 4. $23,674,605 6,578,693 1,702,310 2,415,771 $19,051,183 6,261,771 1,238,696 2,918,368 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Property Taxes Sales Taxes Franchise Fees Building Permits GENERAL FUND REVENUE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 7 Page 51 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Water Charges for Services 17,557,737$ 500,000$ 18,057,737$ 10,166,789$ -$ 7,890,948$ 56%9,414,940$ 8% Sewer Charges for Services 9,462,990 200,000 9,662,990 6,760,153 - 2,902,837 70%6,240,954 8% Licenses, Fees & Permits 377,705 30,000 407,705 268,346 - 139,359 66%243,077 10% Utility Billing Penalties 186,900 - 186,900 129,396 - 57,504 69%116,640 11% Interest Income 60,000 - 60,000 306,693 - (246,693) 511%24,931 1130% Other 467,427 - 467,427 434,759 - 32,668 93%344,493 26% Transfer In - - - - - - 0 - 0% Total Revenues 28,112,759$ 730,000$ 28,842,759$ 18,066,137$ -$ 10,776,622$ 63%16,385,035$ 10% EXPENDITURES Administration 1,558,936$ 199,091$ 1,758,027$ 936,115$ 13,103$ 808,809 54%811,796 15% Debt Service 4,354,465 - 4,354,465 1,850,739 - 2,503,726 43%1 4,463,060 -59% Water Purchases 9,605,940 - 9,605,940 7,075,877 - 2,530,063 74%4,771,511 48% Sewer Management Fee 3,854,505 - 3,854,505 2,626,919 - 1,227,586 68%2,446,268 7% Public Works 11,604,745 382,678 11,987,423 4,119,101 516,554 7,351,768 39%3,618,804 14% Transfer Out 2,877,339 - 2,877,339 774,309 - 2,103,031 27%667,120 16% Total Expenses 33,855,930$ 581,769$ 34,437,699$ 17,383,059$ 529,657$ 15,297,396$ 52%16,778,559$ 4% REVENUE OVER (UNDER) EXPENDITURES (5,743,171)$ 148,231$ (5,594,940)$ 683,078$ (393,524)$ Beginning Working Capital October 1 12,669,408 12,669,408$ Ending Working Capital 7,074,468$ 13,352,486$ Notes 1 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% WATER-SEWER FUND 8 Page 52 Item 4. May-23 May-22 Growth % Average Total Residential Water Consumption by Month WATER SEWER WATER SEWER Change Four Year Cumulative # of Accts Residential 12,434 11,731 11,481 10,764 8.63%FY2023 FY2022 Average Average # of Accts Commercial 440 396 411 367 7.46%October 20,110 16,543 14,882 14,882 Consumption-Residential 175,567,650 76,348,650 151,108,520 75,410,973 11.21%November 11,190 11,256 10,010 24,892 Consumption-Commercial 23,362,150 15,141,710 21,502,320 15,906,220 2.93%December 6,273 7,850 7,663 32,554 Consumption-Commercial Irrigation 27,824,460 20,874,020 33.30%January 8,049 6,936 6,159 38,713 Avg Total Res Water Consumption 14,092 13,133 7.30%February 5,914 7,385 6,618 45,331 Billed ($) Residential 1,180,718$ 702,974$ 1,018,082$ 673,310$ 15.97%March 5,839 6,006 6,335 51,665 Billed ($) Commercial 217,863$ 125,701$ 199,642$ 128,952$ 9.13%April 10,053 8,613 8,838 60,503 Billed ($) Commercial Irrigation 250,606$ 183,655$ 36.45%May 14,092 13,130 10,904 71,407 Total Billed ($)1,649,186$ 828,674$ 1,401,379$ 802,262$ 12.44%June 13,330 13,121 84,527 July 22,900 17,334 101,861 August 27,840 22,933 124,794 September 15,450 18,824 143,618 TOTAL (gal)81,520 157,239 143,618 FY2023 FY2022 Average Cumulative October 5.65 2.60 4.56 4.56 November 5.82 2.92 3.07 7.63 December 3.43 0.76 2.84 10.47 January 1.29 0.20 2.62 13.09 February 4.51 2.15 3.05 16.14 March 2.69 2.62 3.92 20.06 April 1.20 5.90 3.97 24.03 May 3.62 8.01 5.65 29.68 June 1.90 4.07 33.75 July 0.41 2.27 36.02 August 5.08 2.83 38.85 September 0.26 2.76 41.61 Annual 28.21 32.81 41.61 Rainfall TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% WATER-SEWER FUND 9 Page 53 Item 4. 56% 70% 66% 69% 93% Water Charges for Services Sewer Charges for Services Licenses, Fees & Permits Utility Billing Penalties Other 0%20%40%60%80%100% WATER/SEWER REVENUE YTD % OF ANNUAL BUDGET 10 Page 54 Item 4. $10,166,789 7,075,877 $9,414,940 4,771,511 $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 Water Charges for Services Water Purchases WATER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 11 Page 55 Item 4. 6,760,153 2,626,919 6,240,954 2,446,268 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 Sewer Charges for Services Sewer Management Fee SEWER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 12 Page 56 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sanitation Charges for Services 2,158,200 - 2,158,200 1,600,068 - 558,132 74%1,253,147 28% Interest Income - - - 2,086 - (2,086) 0%- 0% Transfer In 1,750,000 - 1,750,000 - - 1,750,000 0%- 0% Total Revenues 3,908,200$ -$ 3,908,200$ 1,602,153$ -$ 2,306,047$ 41%1,253,147$ 28% EXPENDITURES Administration 1,750,000$ -$ 1,750,000$ 49,426$ 574$ 1,700,000 3%- 0% Sanitation Collection 2,158,200 - 2,158,200 1,166,901 - 991,299 54%1,095,534 7% Transfer Out - - - - - - 0%- 0% Total Expenses 3,908,200$ -$ 3,908,200$ 1,216,327$ 574$ 2,691,299$ 31%1,095,534$ 11% REVENUE OVER (UNDER) EXPENDITURES -$ -$ -$ 385,826$ 157,613$ Beginning Working Capital October 1 - -$ Ending Working Capital -$ 385,826$ 157,613$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% SOLID WASTE FUND 13 Page 57 Item 4. 1,600,068 1,166,901 1,253,147 1,095,534 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 Sanitation Charges for Services Sanitation Collection SOLID WASTE REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 14 Page 58 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes-Delinquent 75,000$ -$ 75,000$ 130,780$ -$ (55,780)$ 174%73,149$ 79% Property Taxes-Current 12,605,972 - 12,605,972 12,730,453 - (124,481) 101%1 10,433,216 22% Taxes-Penalties - - - 30,862 - (30,862) 0%30,940 0% Interest Income 20,000 - 20,000 112,357 - (92,357) 562%11,612 868% Transfer In - - - - - -0%428,581 -100% Total Revenues 12,700,972$ -$ 12,700,972$ 13,004,452$ -$ (303,480)$ 102%10,977,498$ 18% EXPENDITURES Professional Services -$ -$ -$ -$ -$ -$ 0%2,500$ -100% Bond Administrative Fees 20,000 0 20,000 500 0 19,500 3%600 -17% 2013 GO Refunding Bond 180,000 0 180,000 0 0 180,000 0%0 0% 2014 GO Bond Payment 315,000 0 315,000 0 0 315,000 0%0 0% 2015 GO Bond Payment 1,309,200 0 1,309,200 1,309,200 0 - 100%1,220,300 7% 2015 CO Bond Payment 465,000 0 465,000 465,000 0 - 100%445,000 4% 2016 GO Debt Payment 0 0 0 0 0 - 0%0 0% 2016 CO Debt Payment 80,000 0 80,000 80,000 0 - 100%70,000 14% 2017 CO Debt Payment 85,000 0 85,000 85,000 0 - 100% 2 70,000 21% 2018 GO Debt Payment 145,000 0 145,000 145,000 0 - 100%145,000 0% 2018 CO Debt Payment 475,000 0 475,000 475,000 0 - 100%455,000 4% 2019 CO Debt Payment 399,806 0 399,806 399,806 0 - 100%381,123 5% 2019 GO Debt Payment 160,000 0 160,000 160,000 0 - 100%155,000 3% 2020 CO Debt Payment 255,000 0 255,000 255,000 0 - 100%245,000 4% 2021 CO Debt Payment 245,000 0 245,000 245,000 0 - 100%310,000 -21% 2021 GO Debt Payment 1,225,000 0 1,225,000 1,225,000 0 - 100%1,925,000 -36% 2022 GO Debt Payment 1,890,000 0 1,890,000 1,890,000 0 - 100%0 0% Bond Interest Expense 5,662,157 0 5,662,157 2,785,327 0 2,876,830 49%2,238,972 24% Total Expenditures 12,911,163$ -$ 12,911,163$ 9,519,833$ -$ 3,391,330$ 74%10,253,495$ -7% REVENUE OVER (UNDER) EXPENDITURES (210,191)$ -$ (210,191)$ 3,484,620$ 724,003$ Beginning Fund Balance October 1 683,357 683,357 2,619,367 Ending Fund Balance Current Month 473,166$ 4,167,977$ 3,343,370$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% DEBT SERVICE FUND 15 Page 59 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 2,741,662$ -$ 2,741,662$ 1,763,393$ -$ 978,269$ 64%1,665,521$ 6% Interest Income 1,200 - 1,200 (395) - 1,595 -33%607 -165% Other - - - - - - 0%- 0% Total Revenue 2,742,862$ -$ 2,742,862$ 1,762,999$ -$ 979,863$ 64%1,666,128$ 6% EXPENDITURES Personnel 2,711,865$ -$ 2,711,865$ 1,801,956$ -$ 909,909$ 66%1,311,807$ 37% Other 1,200 - 1,200 (7,964) - 9,164 -664%469 -1799% Total Expenditures 2,713,065$ -$ 2,713,065$ 1,793,992$ -$ 919,073$ 66%1,312,276$ 37% REVENUE OVER (UNDER) EXPENDITURES 29,797$ -$ 29,797$ (30,993)$ 353,853$ Beginning Fund Balance October 1 453,711 453,711 302,439 Ending Fund Balance Current Month 483,508$ 422,718$ 656,292$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% CRIME CONTROL AND PREVENTION SPECIAL PURPOSE DISTRICT 16 Page 60 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 2,710,483$ -$ 2,710,483$ 1,761,563$ -$ 948,920$ 65%1,661,596$ 6% Interest Income 600 - 600 1,781 - (1,181) 297%347 413% Other - - - - - - 0%- 0% Total Revenue 2,711,083$ -$ 2,711,083$ 1,763,344$ -$ 947,739$ 65%1,661,943$ 6% EXPENDITURES Personnel 2,682,642$ -$ 2,682,642$ 1,709,313$ -$ 973,329$ 64%1,437,290$ 19% Other 2,400 - 2,400 (7,964) - 10,364 -332%469 -1799% Total Expenditures 2,685,042$ -$ 2,685,042$ 1,701,349$ -$ 983,693$ 63%1,437,759$ 18% REVENUE OVER (UNDER) EXPENDITURES 26,041$ -$ 26,041$ 61,995$ 224,184$ Beginning Fund Balance October 1 457,409 457,409 203,982 Ending Fund Balance Current Month 483,450$ 519,404$ 428,166$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% FIRE CONTROL, PREVENTION, AND EMERGENCY MEDICAL SERVICES SEPCIAL PURPOSE DISTRICT 17 Page 61 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Grant Revenue -$ -$ -$ -$ -$ -$ 0%-$ 0% Other Reimbursements 150,000 - 150,000 - - 150,000 0%- 0% Interest Income 25,000 - 25,000 121,630 - (96,630) 487%9,866 1133% Charges for Services 1,385,257 - 1,385,257 923,505 - 461,752 67%780,132 18% Total Revenue 1,560,257$ -$ 1,560,257$ 1,045,135$ -$ 515,122$ 67%789,998$ 32% EXPENDITURES Vehicle Replacement 754,100$ 69,135$ 823,235$ 137,570$ 259,101$ 426,564$ 48%431,582$ -68% Equipment Replacement 170,906 - 170,906 9,461 170,387 (8,942) 105%- 0% Technology Replacement 293,200 120,277 413,477 48,864 117,716 246,896 40%194,034 -75% Total Expenditures 1,218,206$ 189,412$ 1,407,618$ 195,895$ 547,205$ 664,518$ 53%625,616$ -69% REVENUE OVER (UNDER) EXPENDITURES 342,051$ (189,412)$ 152,639$ 849,240$ 164,382$ Beginning Fund Balance October 1 3,957,862 3,957,862 3,957,862 Ending Fund Balance Current Month 4,110,501$ 4,807,102$ 4,122,244$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% VEHICLE AND EQUIPMENT REPLACEMENT FUND 18 Page 62 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 45-4 Storm Drainage Utility Fee 825,000$ -$ 825,000$ 569,367$ -$ 255,633$ 69%527,293$ 8% Drainage Review Fee 3,000 - 3,000 3,150 - (150) 105%3,628 -13% 45-4 Interest Income 1,800 - 1,800 (3,493) - 5,293 -194%1,373 -354% Transfer In - - - - - - 0%531,449 -100% Other Revenue - - - 2,096 - (2,096) 0%- 0% Total Revenue 829,800$ -$ 829,800$ 571,120$ -$ 258,680$ 69%1,063,743$ -46% EXPENDITURES Personnel Services 181,914$ -$ 181,914$ 105,927$ -$ 75,987$ 58%96,922$ 9% Debt Service 217,575 - 217,575 149,610 - 67,965 69%2 736,206 -80% 45-7 Operating Expenditures 288,177 82,706 370,883 112,497 (40,834) 299,220 19%48,014 134% Transfers Out 107,996 - 107,996 71,997 - 35,999 67%1 615,771 -88% Total Expenses 795,662$ 82,706$ 878,368$ 440,032$ (40,834)$ 479,170$ 45%1,496,913$ -71% REVENUE OVER (UNDER) EXPENDITURES 34,138$ (82,706)$ (48,568)$ 131,089$ (433,170)$ Beginning Working Capital October 1 816,012 816,012 632,579 Ending Working Capital Current Month 767,444$ 947,101$ 199,409$ Notes 1 Capital project funds are transferred as needed; General fund transfers are made monthly. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% STORM DRAINAGE UTILITY FUND 19 Page 63 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 60-4 Park Dedication-Fees 964,000$ -$ 964,000$ -$ -$ 964,000$ 0%97,378$ -100% Park Dedication - Transfers In - - - - - - 0%- 0% 60-4 Park Improvements 873,000 - 873,000 - - 873,000 0%299,766 -100% Contributions/Grants 200,550 - 200,550 - - 200,550 0%- 0% 60-4 Interest-Park Dedication 2,000 - 2,000 24,376 - (22,376) 1219%4,010 508% 60-4 Interest-Park Improvements 4,050 - 4,050 25,261 - (21,211) 624%2,590 875% Total Revenue 2,043,600$ -$ 2,043,600$ 49,637$ -$ 1,993,963$ 2%403,744$ -88% EXPENDITURES Pecan Grove Park - 798,971 798,971 718,661 128,885 (48,575) 106%- 0% Windsong Neighborhood Park 100,000 - 100,000 - - 100,000 0%- 0% Capital (Misc. small projects)- - - - - - 0%12,362 -100% Total Expenses 100,000$ 798,971$ 898,971$ 718,661$ 128,885$ 51,425$ 94%12,362$ 5714% REVENUE OVER (UNDER) EXPENDITURES 1,943,600$ (798,971)$ 1,144,630$ (669,023)$ Beginning Fund Balance October 1 2,140,734 2,140,734 2,660,035 Ending Fund Balance Current Month 3,285,364$ 1,471,711$ 2,660,035$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% PARK DEDICATION AND IMPROVEMENT FUNDS 20 Page 64 Item 4. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Impact Fee Revenue: Water Impact Fees -$ -$ -$ -$ -$ 0%259,800$ -100% Wastewater Impact Fees - - - 145,288 (145,288) 0%525,569 -72% East Thoroughfare Impact Fees 200,000 - 200,000 - 200,000 0%1,318,973 -100% Property Taxes - Town (Current)824,243 - 824,243 810,076 14,167 98%612,991 32% Property Taxes - Town (Rollback)- - - - - 0%- 0% Property Taxes - County (Current)184,704 - 184,704 172,956 11,748 94%144,308 20% Sales Taxes - Town 1,024,068 - 1,024,068 619,120 404,948 60%550,602 12% Sales Taxes - EDC 857,656 - 857,656 518,513 339,143 60%461,129 12% Interest Income 6,000 - 6,000 63,912 (57,912) 1065%4,543 1307% Transfer In - - - - - 0%- 0% Total Revenue 3,096,671$ -$ 3,096,671$ 2,329,864$ 766,807$ 75%3,877,915$ -40% EXPENDITURES Professional Services 6,000$ -$ 6,000$ -$ 6,000$ 0%-$ 0% Developer Rebate 3,090,671 - 3,090,671 - 3,090,671$ 0%1,207,639 -100% Transfers Out - - - - -$ 0%- 0% Total Expenses 3,096,671$ -$ 3,096,671$ -$ 3,096,671$ 0%1,207,639$ -100% REVENUE OVER (UNDER) EXPENDITURES -$ 2,329,864$ 2,670,277$ Beginning Fund Balance October 1 1,392,520 1,392,520 301,260 Ending Fund Balance Current Month 1,392,520$ 3,722,384$ 2,971,537$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% TIRZ #1 - BLUE STAR 21 Page 65 Item 4. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes - Town (Current)33,166$ -$ 33,166$ 33,061$ 105$ 100%154,136$ -79% Property Taxes - Town (Rollback)- - - - - 0%- 0% Property Taxes - County (Current)7,432 - 7,432 7,059 373 95%30,280 -77% Sales Taxes - Town - - - - - 0%- 0% Sales Taxes - EDC - - - - - 0%- 0% Interest Income 75 - 75 1,163 (1,088) 1551%72 1504% Total Revenue 40,673$ -$ 40,673$ 41,283$ (610)$ 101%184,489$ -78% EXPENDITURES Professional Services -$ -$ -$ -$ - 0%-$ 0% Developer Rebate 40,673 - 40,673 - 40,673 0%- 0% Transfers Out - - - - - 0%- 0% Total Expenditures 40,673$ -$ 40,673$ -$ 40,673$ 0%-$ 0% REVENUE OVER (UNDER) EXPENDITURES -$ 41,283$ 184,489$ Beginning Fund Balance October 1 24,835 24,835 25,189 Ending Fund Balance Current Month 24,835$ 66,118$ 209,678$ TIRZ #2 TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% 22 Page 66 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Water 3,500,000$ -$ 3,500,000$ 1,809,327$ Interest Income 45,000 - 45,000 143,472 Total Revenues 3,545,000$ -$ 3,545,000$ 1,952,799$ EXPENDITURES Developer Reimbursements Cambridge Park Estates - 0 - 0 180,350 - (180,350) - (180,350) Parks at Legacy Developer Reimb 250,000 250,000 - 250,000 - - 250,000 - 250,000 Star Trail Developer Reimb 367,000 367,000 - 367,000 639,029 - (272,029) - (272,029) Victory at Frontier Developer Reimb 42,000 42,000 - 42,000 - - 42,000 - 42,000 Westside Developer Reimb - - - - 16,047 - (16,047) - (16,047) TVG Windsong Developer Reimb 625,000 625,000 - 625,000 1,083 - 623,917 - 623,917 Total Developer Reimbursements 1,284,000$ 1,284,000$ -$ 1,284,000$ 836,510$ -$ 447,490$ -$ 447,490$ Capital Expenditures 12" Water Line - DNT 200,000 24,250 85,042 109,292 28,059 57,211 24,022 90,708 109,064 Lower Pressure Plane Easements 1,400,000 1,400,000 - 1,400,000 95 - 1,399,905 - 1,399,905 Impact Fee Study 100,000 100,000 - 100,000 4,793 95,207 - - - Lower Pressure Plane 3,100,000 3,100,000 - 3,100,000 - - 3,100,000 - 3,100,000 Total Projects 4,800,000$ 4,624,250$ 85,042$ 4,709,292$ 32,947$ 152,418$ 4,523,927$ 90,708$ 4,608,969$ Transfer to CIP Fund - - - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 6,084,000$ 5,908,250$ 85,042$ 5,993,292$ 869,457$ 152,418$ 4,971,417$ 90,708$ 5,056,459$ REVENUE OVER (UNDER) EXPENDITURES (2,448,292)$ 1,083,342$ Beginning Fund Balance October 1 4,366,761 4,366,761 Ending Fund Balance Current Month 1,918,469$ 5,450,103$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 WATER IMPACT FEES FUND 23 Page 67 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Wastewater 1,750,000$ -$ 1,750,000$ 1,350,218$ Interest Income 14,625 - 14,625 69,806 Upper Trinity Equity Fee 300,000 - 300,000 193,000 Total Revenues 2,064,625$ -$ 2,064,625$ 1,613,024$ EXPENDITURES Developer Reimbursements TVG Westside Utility Developer Reimb 350,000 350,000 - 350,000 251,704 - 98,296 - 98,296 Prosper Partners Utility Developer Reimb 100,000 100,000 - 100,000 - - 100,000 100,000 Frontier Estates Developer Reimb 25,000 25,000 - 25,000 1,366 - 23,634 - 23,634 LaCima Developer Reimb 20,000 20,000 - 20,000 - - 20,000 - 20,000 Brookhollow Developer Reimb 100,000 100,000 - 100,000 19,754 - 80,246 - 80,246 TVG Windsong Developer Reimb 700,000 700,000 - 700,000 400,946 - 299,054 - 299,054 All Storage Developer Reimb 50,000 50,000 - 50,000 9,030 - 40,970 - 40,970 Legacy Garden Developer Reimb 60,000 60,000 - 60,000 4,781 - 55,219 - 55,219 Total Developer Reimbursements 1,405,000$ 1,405,000$ -$ 1,405,000$ 687,581$ -$ 717,419$ -$ 717,419$ Capital Expenditures Doe Branch Wastewater Lines 475,000 112,000 314,400 426,400 47,000 766,506 (387,106) 48,600 (435,706) Impact Fee Study 100,000 100,000 - 100,000 4,793 95,207 - - - Total Projects 575,000$ 212,000$ 314,400$ 526,400$ 51,793$ 861,713$ (387,106)$ 48,600$ (435,706)$ Transfer to CIP Fund - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 1,980,000$ 1,617,000$ 314,400$ 1,931,400$ 739,374$ 861,713$ 330,313$ 48,600$ 281,713$ REVENUE OVER (UNDER) EXPENDITURES 133,225$ 873,650$ Beginning Fund Balance October 1 2,733,394 2,733,394 Ending Fund Balance Current Month 2,866,619$ 3,607,044$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 WASTEWATER IMPACT FEES FUND 24 Page 68 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES East Thoroughfare Impact Fees 1,000,000$ -$ 1,000,000$ 1,477,634$ East Thoroughfare Other Revenue - - - - West Thoroughfare Impact Fees 4,000,000 - 4,000,000 2,699,284 West Thoroughfare Other Revenue - - - - Interest-East Thoroughfare Impact Fees 14,000 - 14,000 75,021 Interest-West Thoroughfare Impact Fees 45,000 - 45,000 108,935 Total Revenues 5,059,000$ -$ 5,059,000$ 4,360,874$ EXPENDITURES East FM 1461 (SH289-CR 165)175,000 175,000 - 175,000 77,074 - 97,927 154,147 (56,221) Coleman Median Landscape (Talon-Victory)30,000 - - - - - - 25,200 4,800 Coit Road (First - Frontier)1,289,900 50,000 364,755 414,755 - 364,755 50,000 925,776 (630) Traffic Signal - Coit & Richland - - - - - - - - - Impact Fee Study 50,000 - - - 1,443 48,557 (50,000) - - Cambridge Park Estates - - - - 174,494 - (174,494) - (174,494) Transfer to Capital Project Fund 1,820,000 1,820,000 - 1,820,000 188,324 - 1,631,676 1,631,676 Total East 3,364,900$ 2,045,000$ 364,755$ 2,409,755$ 441,334$ 413,311$ 1,555,109$ 1,105,123$ 1,405,132$ West Teel 380 Intersection Improvements 100,000 0 1,000 1,000 358,413 1,615 (359,028) 100,985 (361,013) Fishtrap (Elem-DNT)6,600,000 6,600,000 - 6,600,000 - - 6,600,000 - 6,600,000 Traffic Signal 300,000 - - - - - - 269,492 30,508 Parks at Legacy Developer Reimb 500,000 500,000 - 500,000 552,531 - (52,531) - (52,531) Star Trail Developer Reimb 1,500,000 1,500,000 - 1,500,000 2,697,632 - (1,197,632) - (1,197,632) Tellus Windsong Developer Reimb 750,000 750,000 - 750,000 12,833 - 737,168 - 737,168 Legacy Garden Developer Reimb 200,000 200,000 - 200,000 - - 200,000 - 200,000 Impact Fee Study 50,000 - - - 1,443 48,557 (50,000) - - Transfer to Capital Project Fund - - - - 31,025 - (31,025) (31,025) Total West 10,000,000$ 9,550,000$ 1,000$ 9,551,000$ 3,653,877$ 50,172$ 5,846,951$ 370,477$ 5,925,474$ Total Expenditures 13,364,900$ 11,595,000$ 365,755$ 11,960,755$ 4,095,211$ 463,483$ 7,402,060$ 1,475,600$ 7,330,606$ REVENUE OVER (UNDER) EXPENDITURES (6,901,755)$ 265,663$ Beginning Fund Balance October 1 10,678,812 10,678,812 Ending Fund Balance Current Month 3,777,058$ 10,944,475$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 THOROUGHFARE IMPACT FEES FUND 25 Page 69 Item 4. WATER WASTEWATER EAST THOROUGHFARE WEST THOROUGHFARE ANNUAL BUDGET $3,500,000 $1,750,000 $1,000,000 4,000,000 YTD ACTUAL $1,809,327 $1,350,218 $1,477,634 $2,699,284 % OF BUDGET 52%77%148%67% 52% 77%148% 67% $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 IMPACT FEE REVENUE YTD Actual to Annual Budget 26 Page 70 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year Police Donation Revenue 15,500$ -$ 15,500$ 17,756$ -$ (2,256)$ 115%10,096$ 76% Fire Donation Revenue 15,500 - 15,500 10,330 - 5,170 67%9,923 4% Child Safety Revenue 28,000 - 28,000 13,725 - 14,275 49%14,187 -3% Court Security Revenue 8,000 - 8,000 7,834 - 166 98%4,935 59% Court Technology Revenue 7,650 - 7,650 6,518 - 1,132 85%4,156 57% Municipal Jury revenue 150 - 150 155 - (5) 103%96 62% Interest Income 2,425 - 2,425 19,104 - (16,679) 788%1,952 878% Interest Income CARES/ARPA Funds - - - 158,183 - (158,183) 0%7,654 1967% Tree Mitigation - - - 244,038 - (244,038) 0%14,175 1622% Cash Seizure Forfeit - - - 11,122 - (11,122) 0%- 0% Miscellaneous 3,000 - 3,000 2,416 - 584 81%2,997 -19% CARES Act/ARPA Funding 3,045,165 - 3,045,165 - - 3,045,165 0%6,018 -100% Transfer In - - - - - - 0%- 0% Total Revenue 3,125,390$ -$ 3,125,390$ 491,179$ -$ 2,634,211$ 16%76,190$ 545% EXPENDITURES LEOSE Expenditure 17,500$ -$ 17,500$ 5,050$ -$ 12,450$ 29%-$ 0% Court Technology Expense - - - - - - 0%10,688 -100% Court Security Expense 15,675 - 15,675 50 - 15,625 0%- 0% Police Donation Expense 38,740 - 38,740 17,842 14,462 6,436 83%8,237 117% Fire Donation Expense 5,387 5,000 10,387 8,546 - 1,841 82%- 0% Child Safety Expense 39,761 19,985 59,746 22,238 - 37,508 37%2,706 722% Tree Mitigation Expense - - - - - - 0%33,600 -100% Police Seizure Expense 12,995 - 12,995 4,457 - - 34%- 0% CARES Act/ARPA Funding - - - - - - 0%- 0% Transfer Out (Tree Mitigation funds)- - - - - - 0%366,400 -100% Total Expenses 130,058$ 24,985$ 155,043$ 58,183$ 14,462$ 73,860$ 47%421,631$ -86% REVENUE OVER (UNDER) EXPENDITURES 2,995,332$ (24,985)$ 2,970,347$ 432,996$ (345,441)$ Beginning Fund Balance October 1 817,219 817,219 567,535 Ending Fund Balance Current Month 3,787,566$ 1,250,215$ 222,094$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 Expected Year to Date Percent 66.67% SPECIAL REVENUE FUNDS 27 Page 71 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Grants -$ -$ -$ -$ Contributions/Interlocal Revenue - - - - Bond Proceeds - - - - Interest Income - - - 1,126,137 Other Revenue - - - 5,460 Transfers In - General Fund - 1,000,000 1,000,000 3,890,243 Professional Svc - Upper Doe Branch WW Line - - - - Transfers In - Impact Fee Funds - - - 219,349 *Transfers In/Out - Bond Funds - - - - Total Revenues -$ 1,000,000$ 1,000,000$ 5,241,188$ EXPENDITURES Frontier Parkway BNSF Overpass 9,402,125 -$ - - - - - 9,345,276 56,849 West Prosper Roads 14,168,828 - - - - - - 14,017,321 151,507 BNSF Quiet Zone First/Fifth 145,000 - 4,950 4,950 4,218 732 - 17,146 122,904 Coit Rd (First-Frontier) 4 Lns 2,089,900 - - - 114 - (114) 2,089,786 First St (DNT to Coleman)5,786,567 - 1,584,883 1,584,883 397,444 415,495 771,944 1,540,745 3,432,883 Fishtrap (Elem-DNT) 4 Lanes 30,807,380 - 26,870,802 26,870,802 629,260 26,286,067 (44,525) 3,127,872 764,181 First St (Coit-Custer) 4 Lanes 27,260,000 - 22,840,969 22,840,969 1,974,974 21,023,041 (157,046) 2,744,075 1,517,910 Preston/Prosper Trail Turn Lane 900,000 - - - 46,238 122,708 (168,946) - 731,054 Craig Street (Preston-Fifth)450,000 - 148,005 148,005 102,855 57,650 (12,500) 175,595 113,900 Fishtrap Section 1 & 4 778,900 - 5,000 5,000 5,000 - - 382,323 391,577 Fishtrap (Teel - Gee Road)6,425,000 - 6,025,000 6,025,000 356,230 5,849,269 (180,499) 247 219,254 Gee Road (Fishtrap - Windsong)4,949,000 - 4,169,579 4,169,579 1,071,224 2,591,162 507,193 4,052 1,282,561 Teel (US 380 Intersection Improvements)1,180,000 - 200,000 200,000 724,855 238,474 (763,329) 106,198 110,473 Coleman (Gorgeous - Prosper Trail)1,500,000 - 740,906 740,906 301,996 438,910 - 120,534 638,561 Coleman (Prosper Trail - PHS)1,150,000 - - - - - - - 1,150,000 Legacy (Prairie - Fishtrap)1,425,000 - 1,133,307 1,133,307 305,333 252,974 575,000 235,694 631,000 Coit/US 380 SB Turn Lanes 300,000 - - - 19,874 30,126 (50,000) - 250,000 Safety Way 800,000 - 800,000 800,000 - - 800,000 - 800,000 Gorgeous/McKinley 700,000 - 700,000 700,000 - - 700,000 - 700,000 Renaming of Fishtrap Road to W. First Street 80,000 - - - 2,877 - (2,877) - 77,123 First Street (Coleman)500,000 - 500,000 500,000 - - 500,000 - 500,000 Teel Parkway (US 380 - Fishtrap Rd) NB 2 Lanes (Design)750,000 - 135,700 135,700 103,100 33,550 (950) 82,943 530,407 Total Street Projects 111,547,700$ -$ 65,859,101$ 65,859,101$ 6,045,592$ 57,340,157$ 2,473,352$ 31,900,019$ 16,261,932$ Turf Irrigation SH289 68,000 - - - - - - 48,935 19,065 US 380 Median Design (Green Ribbon)821,250 - - - - - - 65,800 755,450 Whitley Place H&B Trail Extension 750,000 - - - - - - 734,209 15,791 Tanner's Mill Phase 2 Design 1,396,400 - 688,651 688,651 685,039 4,000 (388) 696,070 11,291 Lakewood Preserve, Phase 2 3,845,000 - - - - 131,477 (131,477) - 3,713,523 Pecan Grove Ph II 907,500 - 4,352 4,352 796 3,556 - 66,105 837,043 Downtown Pond Improvements 120,000 - - - - - - 11,760 108,240 Sexton Park Phase I 1,200,000 - 936,986 936,986 82,524 854,462 - 154,672 108,342 Coleman Median Landscape (Victory-Preston)650,000 - 432,358 432,358 272,665 163,881 (4,188) 19,783 193,671 Prosper Trail Median Landscape 275,000 - 146,481 146,481 110,644 38,770 (2,934) 7,352 118,234 Total Park Projects 10,033,150$ -$ 2,208,828$ 2,208,828$ 1,151,669$ 1,196,146$ (138,988)$ 1,804,685$ 5,880,649$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 CAPITAL PROJECTS FUND - GENERAL 28 Page 72 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 CAPITAL PROJECTS FUND - GENERAL PD Car Camera and Body worn Camera System 387,225 - 17,000 17,000 14,500 2,500 - - 370,225 Station #3 Quint Engine 1,495,000 - 118,273 118,273 41,108 49,737 27,427 1,376,727 27,427 Station #3 Ambulance 495,000 - 79,251 79,251 5,746 30,827 42,677 415,749 42,677 Park Ops Vehicle 27,035 - - - 23,242 - (23,242) - 3,793 Awnings for Storage 19,800 - 300 300 - 300 - 11,100 8,400 Public Safety Complex, Phase 2-Design 1,578,290 - 205,380 205,380 131,462 73,309 610 1,373,520 - Public Safety Complex, Phase 2-Dev Costs 647,325 - 555,818 555,818 18,306 11,375 526,137 91,507 526,137 Public Safety Complex, Phase 2-Construction 14,500,000 - 8,903,575 8,903,575 7,670,754 1,232,687 134 5,596,425 134 Public Safety Complex, Phase 2-FFE 1,274,385 - 1,224,224 1,224,224 525,311 403,912 295,000 50,161 295,000 Fire Engine Station 4 - FUNDS REALLOCATED 1,100,000 - - - - - - - 1,100,000 Fire Station #4 - Design 600,000 - 285,616 285,616 135,048 150,568 - 337,939 (23,555) Fire Station #4 - Engine 1,250,000 - 117,557 117,557 39,817 49,856 27,884 1,132,443 27,884 Fire Station #4 - Ambulance 552,000 - 509,445 509,445 7,109 449,717 52,618 42,555 52,618 Fire Station #4 - Other Costs 400,000 - - - - - - 8,250 391,750 Total Facility Projects 24,326,060$ -$ 12,016,439$ 12,016,439$ 8,612,404$ 2,454,789$ 949,246$ 10,436,376$ 2,822,491$ Transfer Out - - - - - - - - - Total Expenditures 145,906,910$ -$ 80,084,368$ 80,084,368$ 15,809,665$ 60,991,093$ 3,283,610$ 44,141,080$ 24,965,072$ REVENUE OVER (UNDER) EXPENDITURES (79,084,368)$ (10,568,477)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 77,609,702 77,609,702 Ending Fund Balance (Restricted for Capital Projects) Current Month (1,474,666)$ 67,041,225$ 29 Page 73 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Year Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Interest Income -$ -$ -$ 546,578$ Bond Proceeds - - - - Transfers In - - - 22,749 Transfers In - Impact Fee Funds - - - - Transfers In - Bond Funds - - - (0) Total Revenues -$ -$ -$ 569,327$ EXPENDITURES Water/Sewer Lower Pressure Plane Pump Station Design 24,331,100 - 16,204,853 16,204,853 5,542,725 11,243,872 (581,745) 1,701,715 5,842,788 Custer Rd Meter Station/Water Line Relocation 3,869,563 - 826 826 48,276 - (47,450) 3,831,064 (9,777) Doe Branch Parallel Interceptor 15,000 - - - - - - 15,000 - Upper Doe Branch WW Line (Teel-PISD Stadium)250,000 - - - - - - - 250,000 Water Line Relocation Frontier 4,000,000 - 398,239 398,239 20,709 380,894 (3,363) 2,041 3,596,357 Total Water & Wastewater Projects 32,465,663$ -$ 16,603,918$ 16,603,918$ 5,611,710$ 11,624,766$ (632,558)$ 5,549,819$ 9,679,368$ Drainage Frontier Park/Preston Lakes Drainage 1,085,000 - 148,379 148,379 140,960 7,419 0 648,022 288,599 Old Town Regional Pond #2 385,000 - 17,114 17,114 - 17,114 - 31,210 336,677 Total Drainage Projects 1,470,000$ -$ 165,493$ 165,493$ 140,960$ 24,532$ 0$ 679,232$ 625,276$ Transfer out - - - - - - - - Total Expenses 33,935,663$ -$ 16,769,410$ 16,769,410$ 5,752,670$ 11,649,299$ (632,558)$ 6,229,051$ 10,304,644$ REVENUE OVER (UNDER) EXPENDITURES (16,769,410)$ (5,183,343)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 40,601,835 40,601,835 Ending Fund Balance (Restricted for Capital Projects) Current Month 23,832,425$ 35,418,492$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT May 31, 2023 CAPITAL PROJECTS FUND-WATER/SEWER 30 Page 74 Item 4. MONTHLY FINANCIAL REPORT as of June 30, 2023 Cash/Budgetary Basis Prepared by Finance Department September 12, 2023 Page 75 Item 4. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 2023 Table of Contents Dashboard Charts 3 - 4 General Fund 5 Water-Sewer Fund 8 Solid Waste Fund 13 Debt Service Fund 15 Crime Control and Prevention Special Purpose District 16 Fire Control, Prevention, and Emergency Medical Services Special Purpose District 17 Vehicle and Equipment Replacement Fund 18 Storm Drainage Utility Fund 19 Park Dedication and Improvement Fund 20 TIRZ #1 - Blue Star 21 TIRZ #2 22 Water Impact Fees Fund 23 Wastewater Impact Fees Fund 24 Thoroughfare Impact Fees Fund 25 Special Revenue Fund 27 Capital Projects Fund-General 28 Capital Projects Fund-Water/Sewer 30 Page 76 Item 4. 0 $- $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 Total Budget YTD Budget YTD Actual Building Permit Revenues 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 Oct Nov Dec Jan Feb Mar Apr May June July Aug Sept Town of Prosper, Texas Sales Tax Revenue by Month FY 18/19 FY 19/20 FY 20/21 FY 21/22 FY22/23 3 Page 77 Item 4. 0 6288751.47 $56.072 $42.054 $35.179 $47.585 $35.689 $40.909 $- $10 $20 $30 $40 $50 $60 Total Budget YTD Budget YTD Actual In Millions General Fund Revenues and Expenditures Revenues Expenditures $34.438 $25.828 $18.703 $28.843 $21.632 $20.724 $- $5 $10 $15 $20 $25 $30 $35 $40 Total Budget YTD Budget YTD Actual In Millions Water -Sewer Fund Revenues and Expenditures Revenues Expenditures 4 Page 78 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actuals Encumbrances Budget Balance YTD Percent Note YTD Actuals Prior Year REVENUES Property Taxes 23,519,547$ -$ 23,519,547$ 23,809,420$ -$ (289,873)$ 101%1 19,077,613$ 25% Sales Taxes 10,220,208 0 10,220,208 7,381,074 0 2,839,134 72%6,995,400 6% Franchise Fees 2,404,527 0 2,404,527 1,856,201 0 548,326 77%2 1,378,129 35% Building Permits 4,781,000 0 4,781,000 2,746,619 0 2,034,381 57%3,305,532 -17% Other Licenses, Fees & Permits 1,552,430 80,000 1,632,430 1,520,454 0 111,976 93%1,763,273 -14% Charges for Services 1,240,961 0 1,240,961 943,482 0 297,479 76%684,348 38% Fines & Warrants 250,425 0 250,425 295,803 0 (45,378) 118%179,231 65% Intergovernmental Revenue (Grants)1,525,000 0 1,525,000 142,602 0 1,382,398 9%270,881 -47% Interest Income 150,000 0 150,000 715,029 0 (565,029) 477%70,745 911% Transfers In 1,235,335 0 1,235,335 936,031 0 299,304 76%830,779 13% Miscellaneous 116,576 0 116,576 101,013 0 15,563 87%194,865 -48% Park Fees 509,300 0 509,300 461,666 0 47,634 91%533,553 -13% Total Revenues 47,505,309$ 80,000$ 47,585,309$ 40,909,394$ -$ 6,675,915$ 86%35,284,349$ 16% EXPENDITURES Administration 9,341,007$ 729,900$ 10,070,907$ 6,092,958$ 1,199,172$ 2,778,777$ 72%4,858,165$ 25% Police 6,635,120 1,111,113 7,746,233 5,091,873 708,273 1,946,088 75%4,135,101 23% Fire/EMS 9,990,721 35,083 10,025,804 7,332,166 105,831 2,587,807 74%5,750,868 27% Public Works 4,136,738 652,564 4,789,302 2,659,895 1,230,951 898,456 81%1,990,929 34% Community Services 7,174,446 113,200 7,287,646 4,027,550 389,737 2,870,359 61%3,500,752 15% Development Services 4,173,570 294,487 4,468,057 2,221,591 121,865 2,124,602 52%2,489,240 -11% Engineering 2,601,325 301,867 2,903,192 1,917,827 265,944 719,422 75%1,512,096 27% Transfers Out 7,780,485 1,000,000 8,780,485 5,835,364 0 2,945,121 66%6,163,280 -5% Total Expenses 51,833,412$ 4,238,214$ 56,071,627$ 35,179,223$ 4,021,771$ 16,870,633$ 70%30,400,430$ 16% REVENUE OVER (UNDER) EXPENDITURES (4,328,103)$ (4,158,214)$ (8,486,318)$ 5,730,172$ 4,883,919$ Beginning Fund Balance October 1-Unassigned/Unrestricted 18,925,919 18,925,919 Ending Fund Balance 10,439,601$ 24,656,091$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Franchise fees and other various license and fees are paid quarterly or annually. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% GENERAL FUND 5 Page 79 Item 4. 101% 72% 77% 57% 93% 76% 9% Property Taxes Sales Taxes Franchise Fees Building Permits Other Licenses, Fees & Permits Charges for Services Intergovernmental Revenue (Grants) 0%20%40%60%80%100%120% GENERAL FUND YTD REVENUE % OF ANNUAL BUDGET 6 Page 80 Item 4. $23,809,420 7,381,074 1,856,201 2,746,619 $19,077,613 6,995,400 1,378,129 3,305,532 $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Property Taxes Sales Taxes Franchise Fees Building Permits GENERAL FUND REVENUE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 7 Page 81 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Water Charges for Services 17,557,737$ 500,000$ 18,057,737$ 11,878,342$ -$ 6,179,395$ 66%10,991,021$ 8% Sewer Charges for Services 9,462,990 200,000 9,662,990 7,616,912 - 2,046,078 79%7,070,524 8% Licenses, Fees & Permits 377,705 30,000 407,705 300,378 - 107,327 74%281,696 7% Utility Billing Penalties 186,900 - 186,900 129,535 - 57,365 69%132,201 -2% Interest Income 60,000 - 60,000 322,431 - (262,431) 537%28,299 1039% Other 467,427 - 467,427 476,827 - (9,400) 102%385,347 24% Transfer In - - - - - - 0 - 0% Total Revenues 28,112,759$ 730,000$ 28,842,759$ 20,724,425$ -$ 8,118,334$ 72%18,889,088$ 10% EXPENDITURES Administration 1,558,936$ 199,091$ 1,758,027$ 1,054,768$ 37,757$ 665,502 62%926,132 14% Debt Service 4,354,465 - 4,354,465 1,850,739 - 2,503,726 43%1 4,463,060 -59% Water Purchases 9,605,940 - 9,605,940 7,075,877 - 2,530,063 74%4,771,511 48% Sewer Management Fee 3,854,505 - 3,854,505 2,856,182 - 998,323 74%2,651,799 8% Public Works 11,604,745 382,678 11,987,423 4,843,433 525,355 6,618,635 45%4,166,443 16% Transfer Out 2,877,339 - 2,877,339 1,021,791 - 1,855,548 36%750,510 36% Total Expenses 33,855,930$ 581,769$ 34,437,699$ 18,702,790$ 563,112$ 14,173,474$ 56%17,729,455$ 5% REVENUE OVER (UNDER) EXPENDITURES (5,743,171)$ 148,231$ (5,594,940)$ 2,021,635$ 1,159,633$ Beginning Working Capital October 1 12,669,408 12,669,408$ Ending Working Capital 7,074,468$ 14,691,043$ Notes 1 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% WATER-SEWER FUND 8 Page 82 Item 4. Jun-23 Jun-22 Growth % Average Total Residential Water Consumption by Month WATER SEWER WATER SEWER Change Four Year Cumulative # of Accts Residential 12,464 11,764 11,640 10,915 7.42%FY2023 FY2022 Average Average # of Accts Commercial 441 397 411 367 7.71%October 20,110 16,543 14,882 14,882 Consumption-Residential 178,257,450 77,509,000 155,557,810 76,211,333 10.35%November 11,190 11,256 10,010 24,892 Consumption-Commercial 23,286,570 13,966,240 21,935,300 13,383,630 5.48%December 6,273 7,850 7,663 32,554 Consumption-Commercial Irrigation 29,200,560 27,454,090 6.36%January 8,049 6,936 6,159 38,713 Avg Total Res Water Consumption 14,281 13,332 7.12%February 5,914 7,385 6,618 45,331 Billed ($) Residential 1,201,539$ 711,259$ 1,051,943$ 680,788$ 14.22%March 5,839 6,006 6,335 51,665 Billed ($) Commercial 218,904$ 118,649$ 205,292$ 114,426$ 6.63%April 10,053 8,613 8,838 60,503 Billed ($) Commercial Irrigation 262,953$ 245,526$ 7.10%May 14,092 13,130 10,904 71,407 Total Billed ($)1,683,395$ 829,907$ 1,502,761$ 795,213$ 9.37%June 14,281 13,330 13,121 84,527 July 22,900 17,334 101,861 August 27,840 22,933 124,794 September 15,450 18,824 143,618 TOTAL (gal)95,801 157,239 143,618 FY2023 FY2022 Average Cumulative October 5.65 2.60 4.56 4.56 November 5.82 2.92 3.07 7.63 December 3.43 0.76 2.84 10.47 January 1.29 0.20 2.62 13.09 February 4.51 2.15 3.05 16.14 March 2.69 2.62 3.92 20.06 April 1.20 5.90 3.97 24.03 May 3.62 8.01 5.65 29.68 June 2.35 1.90 4.07 33.75 July 0.41 2.27 36.02 August 5.08 2.83 38.85 September 0.26 2.76 41.61 Annual 30.56 32.81 41.61 Rainfall TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% WATER-SEWER FUND 9 Page 83 Item 4. 66% 79% 74% 69% 102% Water Charges for Services Sewer Charges for Services Licenses, Fees & Permits Utility Billing Penalties Other 0%20%40%60%80%100%120% WATER/SEWER REVENUE YTD % OF ANNUAL BUDGET 10 Page 84 Item 4. $11,878,342 7,075,877 $10,991,021 4,771,511 $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 Water Charges for Services Water Purchases WATER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 11 Page 85 Item 4. 7,616,912 2,856,182 7,070,524 2,651,799 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 Sewer Charges for Services Sewer Management Fee SEWER REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 12 Page 86 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sanitation Charges for Services 2,158,200 - 2,158,200 1,819,874 - 338,326 84%1,431,386 27% Interest Income - - - 2,573 - (2,573) 0%- 0% Transfer In 1,750,000 - 1,750,000 - - 1,750,000 0%- 0% Total Revenues 3,908,200$ -$ 3,908,200$ 1,822,447$ -$ 2,085,753$ 47%1,431,386$ 27% EXPENDITURES Administration 1,750,000$ -$ 1,750,000$ 49,426$ 574$ 1,700,000 3%- 0% Sanitation Collection 2,158,200 - 2,158,200 1,382,501 - 775,699 64%1,270,079 9% Transfer Out - - - - - - 0%- 0% Total Expenses 3,908,200$ -$ 3,908,200$ 1,431,927$ 574$ 2,475,699$ 37%1,270,079$ 13% REVENUE OVER (UNDER) EXPENDITURES -$ -$ -$ 390,519$ 161,307$ Beginning Working Capital October 1 - -$ Ending Working Capital -$ 390,519$ 161,307$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% SOLID WASTE FUND 13 Page 87 Item 4. 1,819,874 1,382,501 1,431,386 1,270,079 - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2,000,000 Sanitation Charges for Services Sanitation Collection SOLID WASTE REVENUE AND EXPENSE Current YTD to Prior Year YTD Actual Comparison Current Year Prior Year 14 Page 88 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes-Delinquent 75,000$ -$ 75,000$ 143,170$ -$ (68,170)$ 191%67,957$ 111% Property Taxes-Current 12,605,972 - 12,605,972 12,780,028 - (174,056) 101%1 10,452,163 22% Taxes-Penalties - - - 37,881 - (37,881) 0%33,323 14% Interest Income 20,000 - 20,000 116,638 - (96,638) 583%12,696 819% Transfer In - - - - - - 0%428,581 -100% Total Revenues 12,700,972$ -$ 12,700,972$ 13,077,717$ -$ (376,745)$ 103%10,994,721$ 19% EXPENDITURES Professional Services -$ -$ -$ -$ -$ -$ 0%9,500$ -100% Bond Administrative Fees 20,000 0 20,000 500 0 19,500 3%600 -17% 2013 GO Refunding Bond 180,000 0 180,000 0 0 180,000 0%0 0% 2014 GO Bond Payment 315,000 0 315,000 0 0 315,000 0%0 0% 2015 GO Bond Payment 1,309,200 0 1,309,200 1,309,200 0 - 100%1,220,300 7% 2015 CO Bond Payment 465,000 0 465,000 465,000 0 - 100%445,000 4% 2016 GO Debt Payment 0 0 0 0 0 - 0%0 0% 2016 CO Debt Payment 80,000 0 80,000 80,000 0 - 100%70,000 14% 2017 CO Debt Payment 85,000 0 85,000 85,000 0 - 100% 2 70,000 21% 2018 GO Debt Payment 145,000 0 145,000 145,000 0 - 100%145,000 0% 2018 CO Debt Payment 475,000 0 475,000 475,000 0 - 100%455,000 4% 2019 CO Debt Payment 399,806 0 399,806 399,806 0 - 100%381,123 5% 2019 GO Debt Payment 160,000 0 160,000 160,000 0 - 100%155,000 3% 2020 CO Debt Payment 255,000 0 255,000 255,000 0 - 100%245,000 4% 2021 CO Debt Payment 245,000 0 245,000 245,000 0 - 100%310,000 -21% 2021 GO Debt Payment 1,225,000 0 1,225,000 1,225,000 0 - 100%1,925,000 -36% 2022 GO Debt Payment 1,890,000 0 1,890,000 1,890,000 0 - 100%0 0% Bond Interest Expense 5,662,157 0 5,662,157 2,785,327 0 2,876,830 49%2,238,972 24% Total Expenditures 12,911,163$ -$ 12,911,163$ 9,519,833$ -$ 3,391,330$ 74%10,260,495$ -7% REVENUE OVER (UNDER) EXPENDITURES (210,191)$ -$ (210,191)$ 3,557,885$ 734,226$ Beginning Fund Balance October 1 683,357 683,357 2,619,367 Ending Fund Balance Current Month 473,166$ 4,241,242$ 3,353,593$ Notes 1 Property taxes are billed in October and the majority of collections occur December through February. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% DEBT SERVICE FUND 15 Page 89 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 2,741,662$ -$ 2,741,662$ 1,974,925$ -$ 766,737$ 72%1,859,230$ 6% Interest Income 1,200 - 1,200 (806) - 2,006 -67%735 -210% Other - - - - - - 0%- 0% Total Revenue 2,742,862$ -$ 2,742,862$ 1,974,119$ -$ 768,743$ 72%1,859,965$ 6% EXPENDITURES Personnel 2,711,865$ -$ 2,711,865$ 2,118,173$ -$ 593,692$ 78%1,495,697$ 42% Other 1,200 - 1,200 (7,290) - 8,490 -608%469 -1655% Total Expenditures 2,713,065$ -$ 2,713,065$ 2,110,883$ -$ 602,182$ 78%1,496,166$ 41% REVENUE OVER (UNDER) EXPENDITURES 29,797$ -$ 29,797$ (136,764)$ 363,799$ Beginning Fund Balance October 1 453,711 453,711 302,439 Ending Fund Balance Current Month 483,508$ 316,947$ 666,238$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% CRIME CONTROL AND PREVENTION SPECIAL PURPOSE DISTRICT 16 Page 90 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Sales Tax - Town 2,710,483$ -$ 2,710,483$ 1,972,900$ -$ 737,583$ 73%1,855,083$ 6% Interest Income 600 - 600 1,658 - (1,058) 276%443 275% Other - - - - - - 0%- 0% Total Revenue 2,711,083$ -$ 2,711,083$ 1,974,558$ -$ 736,525$ 73%1,855,526$ 6% EXPENDITURES Personnel 2,682,642$ -$ 2,682,642$ 1,981,430$ -$ 701,212$ 74%1,596,761$ 24% Other 2,400 - 2,400 (7,290) - 9,690 -304%469 -1655% Total Expenditures 2,685,042$ -$ 2,685,042$ 1,974,139$ -$ 710,903$ 74%1,597,230$ 24% REVENUE OVER (UNDER) EXPENDITURES 26,041$ -$ 26,041$ 418$ 258,296$ Beginning Fund Balance October 1 457,409 457,409 203,982 Ending Fund Balance Current Month 483,450$ 457,827$ 462,278$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% FIRE CONTROL, PREVENTION, AND EMERGENCY MEDICAL SERVICES SEPCIAL PURPOSE DISTRICT 17 Page 91 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Grant Revenue -$ -$ -$ -$ -$ -$ 0%-$ 0% Other Reimbursements 150,000 - 150,000 - - 150,000 0%- 0% Interest Income 25,000 - 25,000 128,637 - (103,637) 515%11,232 1045% Charges for Services 1,385,257 - 1,385,257 1,038,943 - 346,314 75%877,648 18% Total Revenue 1,560,257$ -$ 1,560,257$ 1,167,579$ -$ 392,678$ 75%888,881$ 31% EXPENDITURES Vehicle Replacement 754,100$ 69,135$ 823,235$ 137,570$ 259,101$ 426,564$ 48%431,582$ -68% Equipment Replacement 170,906 - 170,906 9,461 170,387 (8,942) 105%- 0% Technology Replacement 293,200 120,277 413,477 81,814 279,463 52,200 87%194,034 -58% Total Expenditures 1,218,206$ 189,412$ 1,407,618$ 228,845$ 708,951$ 469,821$ 67%625,616$ -63% REVENUE OVER (UNDER) EXPENDITURES 342,051$ (189,412)$ 152,639$ 938,734$ 263,265$ Beginning Fund Balance October 1 3,957,862 3,957,862 3,957,862 Ending Fund Balance Current Month 4,110,501$ 4,896,596$ 4,221,127$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% VEHICLE AND EQUIPMENT REPLACEMENT FUND 18 Page 92 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 45-4 Storm Drainage Utility Fee 825,000$ -$ 825,000$ 642,586$ -$ 182,414$ 78%595,642$ 8% Drainage Review Fee 3,000 - 3,000 3,150 - (150) 105%3,628 -13% 45-4 Interest Income 1,800 - 1,800 (3,417) - 5,217 -190%1,460 -334% Transfer In - - - - - - 0%531,449 -100% Other Revenue - - - 2,096 - (2,096) 0%- 0% Total Revenue 829,800$ -$ 829,800$ 644,415$ -$ 185,385$ 78%1,132,178$ -43% EXPENDITURES Personnel Services 181,914$ -$ 181,914$ 125,065$ -$ 56,849$ 69%105,771$ 18% Debt Service 217,575 - 217,575 149,610 - 67,965 69%2 736,206 -80% 45-7 Operating Expenditures 288,177 82,706 370,883 114,406 35,651 220,826 40%51,503 122% Transfers Out 107,996 - 107,996 80,997 - 26,999 75%1 671,494 -88% Total Expenses 795,662$ 82,706$ 878,368$ 470,078$ 35,651$ 372,639$ 58%1,564,973$ -70% REVENUE OVER (UNDER) EXPENDITURES 34,138$ (82,706)$ (48,568)$ 174,337$ (432,795)$ Beginning Working Capital October 1 816,012 816,012 632,579 Ending Working Capital Current Month 767,444$ 990,349$ 199,784$ Notes 1 Capital project funds are transferred as needed; General fund transfers are made monthly. 2 Annual debt service payments are made in February and August. TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% STORM DRAINAGE UTILITY FUND 19 Page 93 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES 60-4 Park Dedication-Fees 964,000$ -$ 964,000$ 205,514$ -$ 758,486$ 21%97,378$ 111% Park Dedication - Transfers In - - - - - - 0%- 0% 60-4 Park Improvements 873,000 - 873,000 144,000 - 729,000 16%299,766 -52% Contributions/Grants 200,550 - 200,550 - - 200,550 0%- 0% 60-4 Interest-Park Dedication 2,000 - 2,000 26,259 - (24,259) 1313%4,043 550% 60-4 Interest-Park Improvements 4,050 - 4,050 25,506 - (21,456) 630%2,986 754% Total Revenue 2,043,600$ -$ 2,043,600$ 401,279$ -$ 1,642,321$ 20%404,173$ -1% EXPENDITURES Cockrell Park Trail Connection -$ -$ -$ -$ -$ -$ 0%-$ 0% Park Dedication Land Acquisition - - - - - - 0%1,914,647 -100% Hike & Bike Master Plan - - - - - - 0%- 0% Hays Park - - - - - - 0%35,560 -100% Pecan Grove H&B Trail - - - - - - 0%- 0% Pecan Grove Park - 798,971 798,971 743,036 104,510 (48,575) 106%- 0% Windsong Neighborhood Park 100,000 - 100,000 - - 100,000 0%- 0% Capital (Misc. small projects)- - - - - - 0%12,362 -100% Total Expenses 100,000$ 798,971$ 898,971$ 743,036$ 104,510$ 51,425$ 94%1,962,569$ -62% REVENUE OVER (UNDER) EXPENDITURES 1,943,600$ (798,971)$ 1,144,630$ (341,757)$ (1,558,395)$ Beginning Fund Balance October 1 2,140,734 2,140,734 2,660,035 Ending Fund Balance Current Month 3,285,364$ 1,798,977$ 1,101,640$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% PARK DEDICATION AND IMPROVEMENT FUNDS 20 Page 94 Item 4. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Impact Fee Revenue: Water Impact Fees -$ -$ -$ -$ -$ 0%259,800$ -100% Wastewater Impact Fees - - - 221,482 (221,482) 0%565,760 -61% East Thoroughfare Impact Fees 200,000 - 200,000 - 200,000 0%1,318,973 -100% Property Taxes - Town (Current)824,243 - 824,243 810,076 14,167 98%612,991 32% Property Taxes - Town (Rollback)- - - - - 0%- 0% Property Taxes - County (Current)184,704 - 184,704 172,956 11,748 94%144,308 20% Sales Taxes - Town 1,024,068 - 1,024,068 686,085 337,983 67%619,741 11% Sales Taxes - EDC 857,656 - 857,656 574,596 283,060 67%519,033 11% Interest Income 6,000 - 6,000 70,360 (64,360) 1173%5,866 1099% Transfer In - - - - - 0%- 0% Total Revenue 3,096,671$ -$ 3,096,671$ 2,535,555$ 561,116$ 82%4,046,472$ -37% EXPENDITURES Professional Services 6,000$ -$ 6,000$ -$ 6,000$ 0%-$ 0% Developer Rebate 3,090,671 - 3,090,671 - 3,090,671$ 0%1,207,639 -100% Transfers Out - - - - -$ 0%- 0% Total Expenses 3,096,671$ -$ 3,096,671$ -$ 3,096,671$ 0%1,207,639$ -100% REVENUE OVER (UNDER) EXPENDITURES -$ 2,535,555$ 2,838,833$ Beginning Fund Balance October 1 1,392,520 1,392,520 301,260 Ending Fund Balance Current Month 1,392,520$ 3,928,075$ 3,140,093$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% TIRZ #1 - BLUE STAR 21 Page 95 Item 4. Original Budget Amended Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Budget Balance YTD Percent Note YTD Actual Prior Year REVENUES Property Taxes - Town (Current)33,166$ -$ 33,166$ 33,061$ 105$ 100%154,136$ -79% Property Taxes - Town (Rollback)- - - - - 0%- 0% Property Taxes - County (Current)7,432 - 7,432 7,059 373 95%30,280 -77% Sales Taxes - Town - - - - - 0%- 0% Sales Taxes - EDC - - - - - 0%- 0% Interest Income 75 - 75 1,275 (1,200) 1700%140 813% Total Revenue 40,673$ -$ 40,673$ 41,395$ (722)$ 102%184,556$ -78% EXPENDITURES Professional Services -$ -$ -$ -$ - 0%-$ 0% Developer Rebate 40,673 - 40,673 - 40,673 0%- 0% Transfers Out - - - - - 0%- 0% Total Expenditures 40,673$ -$ 40,673$ -$ 40,673$ 0%-$ 0% REVENUE OVER (UNDER) EXPENDITURES -$ 41,395$ 184,556$ Beginning Fund Balance October 1 24,835 24,835 25,189 Ending Fund Balance Current Month 24,835$ 66,230$ 209,745$ TIRZ #2 TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% 22 Page 96 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Water 3,500,000$ -$ 3,500,000$ 2,174,075$ Interest Income 45,000 - 45,000 152,704 Total Revenues 3,545,000$ -$ 3,545,000$ 2,326,780$ EXPENDITURES Developer Reimbursements Cambridge Park Estates - 0 - 0 180,350 - (180,350) - (180,350) Parks at Legacy Developer Reimb 250,000 250,000 - 250,000 - - 250,000 - 250,000 Star Trail Developer Reimb 367,000 367,000 - 367,000 639,029 - (272,029) - (272,029) Victory at Frontier Developer Reimb 42,000 42,000 - 42,000 - - 42,000 - 42,000 Westside Developer Reimb - - - - 16,047 - (16,047) - (16,047) TVG Windsong Developer Reimb 625,000 625,000 - 625,000 1,083 - 623,917 - 623,917 Total Developer Reimbursements 1,284,000$ 1,284,000$ -$ 1,284,000$ 836,510$ -$ 447,490$ -$ 447,490$ Capital Expenditures 12" Water Line - DNT 200,000 24,250 85,042 109,292 31,573 53,697 24,022 90,708 109,064 Lower Pressure Plane Easements 1,000,000 1,400,000 - 1,400,000 95 - 1,399,905 - 999,905 Impact Fee Study 100,000 - - - 7,233 92,767 (100,000) - - Lower Pressure Plane 3,100,000 3,200,000 - 3,200,000 - - 3,200,000 - 3,100,000 Total Projects 4,400,000$ 4,624,250$ 85,042$ 4,709,292$ 38,901$ 146,464$ 4,523,927$ 90,708$ 4,208,969$ Transfer to CIP Fund - - - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 5,684,000$ 5,908,250$ 85,042$ 5,993,292$ 875,410$ 146,464$ 4,971,417$ 90,708$ 4,656,459$ REVENUE OVER (UNDER) EXPENDITURES (2,448,292)$ 1,451,369$ Beginning Fund Balance October 1 4,366,761 4,366,761 Ending Fund Balance Current Month 1,918,469$ 5,818,130$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 WATER IMPACT FEES FUND 23 Page 97 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Impact Fees Wastewater 1,750,000$ -$ 1,750,000$ 1,535,459$ Interest Income 14,625 - 14,625 73,640 Upper Trinity Equity Fee 300,000 - 300,000 226,000 Total Revenues 2,064,625$ -$ 2,064,625$ 1,835,099$ EXPENDITURES Developer Reimbursements TVG Westside Utility Developer Reimb 350,000 350,000 - 350,000 251,704 - 98,296 - 98,296 Prosper Partners Utility Developer Reimb 100,000 100,000 - 100,000 - - 100,000 100,000 Frontier Estates Developer Reimb 25,000 25,000 - 25,000 1,366 - 23,634 - 23,634 LaCima Developer Reimb 20,000 20,000 - 20,000 - - 20,000 - 20,000 Brookhollow Developer Reimb 100,000 100,000 - 100,000 19,754 - 80,246 - 80,246 TVG Windsong Developer Reimb 700,000 700,000 - 700,000 400,946 - 299,054 - 299,054 All Storage Developer Reimb 50,000 50,000 - 50,000 9,030 - 40,970 - 40,970 Legacy Garden Developer Reimb 60,000 60,000 - 60,000 4,781 - 55,219 - 55,219 Total Developer Reimbursements 1,405,000$ 1,405,000$ -$ 1,405,000$ 687,581$ -$ 717,419$ -$ 717,419$ Capital Expenditures Doe Branch Wastewater Lines 526,400 212,000 314,400 526,400 85,670 727,836 (287,106) 48,600 (335,706) Impact Fee Study 100,000 - - - 7,233 92,767 (100,000) - - Total Projects 626,400$ 212,000$ 314,400$ 526,400$ 92,904$ 820,602$ (387,106)$ 48,600$ (335,706)$ Transfer to CIP Fund - - - - - - Total Transfers Out -$ -$ -$ -$ -$ -$ -$ -$ -$ Total Expenditures 2,031,400$ 1,617,000$ 314,400$ 1,931,400$ 780,485$ 820,602$ 330,313$ 48,600$ 381,713$ REVENUE OVER (UNDER) EXPENDITURES 133,225$ 1,054,614$ Beginning Fund Balance October 1 2,733,394 2,733,394 Ending Fund Balance Current Month 2,866,619$ 3,788,008$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 WASTEWATER IMPACT FEES FUND 24 Page 98 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES East Thoroughfare Impact Fees 1,000,000$ -$ 1,000,000$ 1,763,003$ East Thoroughfare Other Revenue - - - - West Thoroughfare Impact Fees 4,000,000 - 4,000,000 3,104,695 West Thoroughfare Other Revenue - - - - Interest-East Thoroughfare Impact Fees 14,000 - 14,000 76,118 Interest-West Thoroughfare Impact Fees 45,000 - 45,000 113,793 Total Revenues 5,059,000$ -$ 5,059,000$ 5,057,609$ EXPENDITURES East FM 1461 (SH289-CR 165)175,000 175,000 - 175,000 77,074 - 97,927 154,147 (56,221) Coleman Median Landscape (Talon-Victory)30,000 - - - - - - 25,200 4,800 Coit Road (First - Frontier)1,289,900 50,000 364,755 414,755 - 364,755 50,000 925,776 (630) Traffic Signal - Coit & Richland - - - - - - - - - Impact Fee Study 50,000 - - - 2,477 47,523 (50,000) - - Cambridge Park Estates - - - - 174,494 - (174,494) - (174,494) Transfer to Capital Project Fund 1,820,000 1,820,000 - 1,820,000 234,085 - 1,585,915 1,585,915 Total East 3,364,900$ 2,045,000$ 364,755$ 2,409,755$ 488,129$ 412,277$ 1,509,348$ 1,105,123$ 1,359,371$ West Teel 380 Intersection Improvements 100,000 0 1,000 1,000 358,413 1,615 (359,028) 100,985 (361,013) Fishtrap (Elem-DNT)6,600,000 6,600,000 - 6,600,000 - - 6,600,000 - 6,600,000 Traffic Signal 300,000 - - - - - - 269,492 30,508 Parks at Legacy Developer Reimb 500,000 500,000 - 500,000 552,531 - (52,531) - (52,531) Star Trail Developer Reimb 1,500,000 1,500,000 - 1,500,000 2,697,632 - (1,197,632) - (1,197,632) Tellus Windsong Developer Reimb 750,000 750,000 - 750,000 12,833 - 737,168 - 737,168 Legacy Garden Developer Reimb 200,000 200,000 - 200,000 - - 200,000 - 200,000 Impact Fee Study 50,000 - - - 2,477 47,523 (50,000) - - Transfer to Capital Project Fund - - - - 31,025 - (31,025) (31,025) Total West 10,000,000$ 9,550,000$ 1,000$ 9,551,000$ #3,654,911$ 49,138$ 5,846,951$ 370,477$ 5,925,474$ Total Expenditures 13,364,900$ 11,595,000$ 365,755$ 11,960,755$ 4,143,040$ 461,415$ 7,356,299$ 1,475,600$ 7,284,845$ REVENUE OVER (UNDER) EXPENDITURES (6,901,755)$ 914,568$ Beginning Fund Balance October 1 10,678,812 10,678,812 Ending Fund Balance Current Month 3,777,058$ 11,593,380$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 THOROUGHFARE IMPACT FEES FUND 25 Page 99 Item 4. WATER WASTEWATER EAST THOROUGHFARE WEST THOROUGHFARE ANNUAL BUDGET $3,500,000 $1,750,000 $1,000,000 4,000,000 YTD ACTUAL $2,174,075 $1,535,459 $1,763,003 $3,104,695 % OF BUDGET 62%88%176%78% 62% 88%176% 78% $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 IMPACT FEE REVENUE YTD Actual to Annual Budget 26 Page 100 Item 4. Original Budget Amended Current Year Current Year Current Remaining Prior Year Change from Budget Adjustment Budget YTD Actual Encumbrances Budget Balance YTD Percent Note YTD Actual Prior Year Police Donation Revenue 15,500$ -$ 15,500$ 19,058$ -$ (3,558)$ 123%11,349$ 68% Fire Donation Revenue 15,500 - 15,500 11,638 - 3,862 75%11,183 4% Child Safety Revenue 28,000 - 28,000 13,725 - 14,275 49%14,187 -3% Court Security Revenue 8,000 - 8,000 8,823 - (823) 110%5,512 60% Court Technology Revenue 7,650 - 7,650 7,338 - 312 96%4,636 58% Municipal Jury revenue 150 - 150 175 - (25) 116%107 63% Interest Income 2,425 - 2,425 20,031 - (17,606) 826%2,105 851% Interest Income CARES/ARPA Funds - - - 165,631 - (165,631) 0%8,638 1818% Tree Mitigation - - - 244,038 - (244,038) 0%22,400 989% Cash Seizure Forfeit - - - 11,122 - (11,122) 0%- 0% Miscellaneous 3,000 - 3,000 2,416 - 584 81%2,997 -19% CARES Act/ARPA Funding 3,045,165 - 3,045,165 - - 3,045,165 0%6,018 -100% Transfer In - - - - - - 0%- 0% Total Revenue 3,125,390$ -$ 3,125,390$ 503,994$ -$ 2,621,396$ 16%89,133$ 465% EXPENDITURES LEOSE Expenditure 17,500$ -$ 17,500$ 5,050$ -$ 12,450$ 29%-$ 0% Court Technology Expense - - - - - - 0%10,688 -100% Court Security Expense 15,675 - 15,675 50 - 15,625 0%360 -86% Police Donation Expense 38,740 - 38,740 17,842 14,462 6,436 83%24,425 -27% Fire Donation Expense 5,387 5,000 10,387 8,546 - 1,841 82%- 0% Child Safety Expense 39,761 19,985 59,746 22,238 - 37,508 37%2,706 722% Tree Mitigation Expense - - - - - - 0%33,600 -100% Police Seizure Expense 12,995 - 12,995 4,457 - - 34%- 0% CARES Act/ARPA Funding - - - - - - 0%- 0% Transfer Out (Tree Mitigation funds)- - - - - - 0%366,400 -100% Total Expenses 130,058$ 24,985$ 155,043$ 58,183$ 14,462$ 73,860$ 47%438,179$ -87% REVENUE OVER (UNDER) EXPENDITURES 2,995,332$ (24,985)$ 2,970,347$ 445,810$ (349,047)$ Beginning Fund Balance October 1 817,219 817,219 567,535 Ending Fund Balance Current Month 3,787,566$ 1,263,029$ 218,488$ Notes TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 Expected Year to Date Percent 75% SPECIAL REVENUE FUNDS 27 Page 101 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Grants -$ -$ -$ -$ Contributions/Interlocal Revenue - 1,700,000 1,700,000 - Bond Proceeds - - - - Interest Income - - - 1,362,302 Other Revenue - - - 5,460 Transfers In - General Fund - 1,000,000 1,000,000 5,835,364 Professional Svc - Upper Doe Branch WW Line - - - - Transfers In - Impact Fee Funds - - - 265,110 *Transfers In/Out - Bond Funds - - - - Total Revenues -$ 2,700,000$ 2,700,000$ 7,468,235$ EXPENDITURES Frontier Parkway BNSF Overpass 9,402,125 -$ - - - - - 9,345,276 56,849 West Prosper Roads 14,168,828 - - - - - - 14,017,321 151,507 BNSF Quiet Zone First/Fifth 145,000 - 4,950 4,950 4,218 732 - 17,146 122,904 Coit Rd (First-Frontier) 4 Lns 2,089,900 - - - 535 - (535) 2,089,365 First St (DNT to Coleman)5,786,567 - 1,000,000 1,000,000 221,189 - 778,811 1,540,745 4,024,634 Fishtrap (Elem-DNT) 4 Lanes 30,807,380 - 26,870,802 26,870,802 716,209 26,244,405 (89,812) 3,127,872 718,894 First St (Coit-Custer) 4 Lanes 27,260,000 - 22,840,969 22,840,969 5,486,338 17,524,713 (170,081) 2,744,075 1,504,875 Preston/Prosper Trail Turn Lane 900,000 - - - 116,879 52,067 (168,946) - 731,054 Craig Street (Preston-Fifth)450,000 - 148,005 148,005 130,410 30,095 (12,500) 175,595 113,900 Fishtrap Section 1 & 4 778,900 - 5,000 5,000 5,000 - - 382,323 391,577 Fishtrap (Teel - Gee Road)6,425,000 - 6,609,883 6,609,883 1,488,861 5,298,714 (177,692) 247 (362,822) Gee Road (Fishtrap - Windsong)4,949,000 - 4,169,579 4,169,579 2,000,386 2,591,162 (421,969) 4,052 353,399 Teel (US 380 Intersection Improvements)1,480,000 - 200,000 200,000 726,052 238,474 (764,526) 106,198 409,276 Coleman (Gorgeous - Prosper Trail)1,500,000 - 740,906 740,906 301,996 438,910 - 120,534 638,561 Coleman (Prosper Trail - PHS)1,150,000 - - - - - - - 1,150,000 Legacy (Prairie - Fishtrap)1,425,000 - 1,133,307 1,133,307 395,826 162,481 575,000 235,694 631,000 Coit/US 380 SB Turn Lanes 300,000 - - - 21,200 28,800 (50,000) - 250,000 Safety Way 800,000 - 800,000 800,000 - - 800,000 - 800,000 Gorgeous/McKinley 700,000 - 700,000 700,000 - - 700,000 - 700,000 Renaming of Fishtrap Road to W. First Street 80,000 - - - 2,877 - (2,877) - 77,123 Gee Road (US 380--FM 1385)1,700,000 - 1,700,000 1,700,000 - - 1,700,000 1,700,000 First Street (Coleman)500,000 - 500,000 500,000 209 - 499,791 - 499,791 Teel Parkway (US 380 - Fishtrap Rd) NB 2 Lanes (Design)750,000 - 135,700 135,700 103,765 33,550 (1,615) 82,943 529,742 Total Street Projects 113,547,700$ -$ 67,559,101$ 67,559,101$ 11,721,950$ 52,644,101$ 3,193,050$ 31,900,019$ 17,281,630$ Turf Irrigation SH289 68,000 - - - - - - 48,935 19,065 US 380 Median Design (Green Ribbon)821,250 - - - - - - 65,800 755,450 Whitley Place H&B Trail Extension 750,000 - - - - - - 734,209 15,791 Tanner's Mill Phase 2 Design 1,396,400 - 688,651 688,651 685,039 4,000 (388) 696,070 11,291 Lakewood Preserve, Phase 2 3,845,000 - - - - 131,477 (131,477) - 3,713,523 Pecan Grove Ph II 907,500 - 4,352 4,352 1,393 2,959 - 66,105 837,043 Downtown Pond Improvements 120,000 - - - - - - 11,760 108,240 Raymond Park 1,200,000 - 936,986 936,986 116,524 820,462 - 154,672 108,342 Coleman Median Landscape (Victory-Preston)650,000 - 432,358 432,358 272,665 163,881 (4,188) 19,783 193,671 Prosper Trail Median Landscape 275,000 - 146,481 146,481 110,644 38,770 (2,934) 7,352 118,234 Total Park Projects 10,033,150$ -$ 2,208,828$ 2,208,828$ 1,186,266$ 1,161,549$ (138,988)$ 1,804,685$ 5,880,649$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 CAPITAL PROJECTS FUND - GENERAL 28 Page 102 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Years Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 CAPITAL PROJECTS FUND - GENERAL PD Car Camera and Body worn Camera System 387,225 - 17,000 17,000 14,500 2,500 - - 370,225 Station #3 Quint Engine 1,495,000 - 118,273 118,273 41,460 49,737 27,075 1,376,727 27,075 Station #3 Ambulance 495,000 - 79,251 79,251 5,746 30,827 42,677 415,749 42,677 Park Ops Vehicle 27,035 - - - 23,242 - (23,242) - 3,793 Awnings for Storage 19,800 - 300 300 - 300 - 11,100 8,400 Public Safety Complex, Phase 2-Design 1,578,290 - 205,380 205,380 153,235 51,536 610 1,373,520 - Public Safety Complex, Phase 2-Dev Costs 647,325 - 555,818 555,818 21,173 11,375 523,270 91,507 523,270 Public Safety Complex, Phase 2-Construction 14,500,000 - 8,903,575 8,903,575 7,670,754 1,232,687 134 5,596,425 134 Public Safety Complex, Phase 2-FFE 1,274,385 - 1,224,224 1,224,224 770,264 182,768 271,192 50,161 271,192 Fire Engine Station 4 - FUNDS REALLOCATED 1,100,000 - - - - - - - 1,100,000 Fire Station #4 - Design 600,000 - 285,616 285,616 135,048 150,568 - 337,939 (23,555) Fire Station #4 - Engine 1,250,000 - 117,557 117,557 40,169 49,856 27,532 1,132,443 27,532 Fire Station #4 - Ambulance 552,000 - 509,445 509,445 7,109 449,717 52,618 42,555 52,618 Fire Station #4 - Other Costs 400,000 - - - - - - 8,250 391,750 Total Facility Projects 24,326,060$ -$ 12,016,439$ 12,016,439$ 8,882,701$ 2,211,872$ 921,867$ 10,436,376$ 2,795,111$ Transfer Out - - - - - - - - - Total Expenditures 147,906,910$ -$ 81,784,368$ 81,784,368$ 21,790,917$ 56,017,522$ 3,975,928$ 44,141,080$ 25,957,390$ REVENUE OVER (UNDER) EXPENDITURES (79,084,368)$ (14,322,683)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 77,609,702 77,609,702 Ending Fund Balance (Restricted for Capital Projects) Current Month (1,474,666)$ 63,287,019$ 29 Page 103 Item 4. Current Year Current Year Current Year Project Project Original Budget Amended Current Year Current Year Current Remaining Prior Year Budget Budget Budget Adjustment Budget Actual Encumbrances Budget Balance Expenditure Balance REVENUES Interest Income -$ -$ -$ 747,942$ Bond Proceeds - - - - Transfers In - - - 176,287 Transfers In - Impact Fee Funds - - - - Transfers In - Bond Funds - - - (0) Total Revenues -$ -$ -$ 924,228$ EXPENDITURES Lower Pressure Plane Pump Station Design 24,331,100 - 16,204,853 16,204,853 6,378,213 9,958,626 (131,987) 1,701,715 6,292,546 Custer Rd Meter Station/Water Line Relocation 3,869,563 - 826 826 48,276 - (47,450) 3,831,064 (9,777) Doe Branch Parallel Interceptor 15,000 - - - - - - 15,000 - Upper Doe Branch WW Line (Teel-PISD Stadium)250,000 - - - - - - - 250,000 Water Line Relocation Frontier 4,000,000 - 398,239 398,239 174,246 227,357 (3,363) 2,041 3,596,357 Total Water & Wastewater Projects 32,465,663$ -$ 16,603,918$ 16,603,918$ 6,600,735$ 10,185,983$ (182,800)$ 5,549,819$ 10,129,126$ Frontier Park/Preston Lakes Drainage 1,085,000 - 148,379 148,379 140,960 7,419 0 648,022 288,599 Old Town Regional Pond #2 385,000 - 17,114 17,114 - 17,114 - 31,210 336,677 Total Drainage Projects 1,470,000$ -$ 165,493$ 165,493$ 140,960$ 24,532$ 0$ 679,232$ 625,276$ Transfer out - - - - - - - - Total Expenses 33,935,663$ -$ 16,769,410$ 16,769,410$ 6,741,695$ 10,210,515$ (182,800)$ 6,229,051$ 10,754,402$ REVENUE OVER (UNDER) EXPENDITURES (16,769,410)$ (5,817,466)$ Beginning Fund Balance (Restricted for Capital Projects) October 1 40,601,835 40,601,835 Ending Fund Balance (Restricted for Capital Projects) Current Month 23,832,425$ 34,784,369$ TOWN OF PROSPER, TEXAS MONTHLY FINANCIAL REPORT June 30, 2023 CAPITAL PROJECTS FUND-WATER/SEWER 30 Page 104 Item 4. Page 1 of 1 ECONOMIC DEVELOPMENT To: Mayor and Town Council From: Mary Ann Moon, Executive Director of Economic Development Through: Mario Canizares, Town Manager Re: FY 2023-2024 Budget Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 5. Work Towards a Growing & Diversified Tax Base Agenda Item: Consider and act upon adopting the FY 2023-2024 Prosper Economic Development Corporation Budget. Description of Agenda Item: Section 21 of the Development Corporation Act of 1979 (Texas Revised Civil Statutes Article 5190.6), the “Act,” provides that the Town shall approve all programs and expenditures of the development corporation and shall annually review any financial statements of the corporation. It further provides that at all times the Town will have access to the books and the records of the development corporation. Additionally, Section 23(a)(13) of the Act states that the powers of the corporation shall be subject at all times to the control of the Town’s governing body. Budget Impact: There is no impact to the Town of Prosper’s General Fund as the Prosper Economic Development Corporation (Prosper EDC) is funded wholly by a half-cent of the local sales tax revenue. Since approved by Prosper citizens in 1996, the Prosper EDC has endeavored as its mission to “create jobs and capital investment” with the aim of expanding the local commercial property tax base and sales tax base, thereby lessening the property tax burden on homeowners. Attached Documents: 1. PEDC FY 2023-2024 Annual Budget PEDC Board Recommendation: The Prosper EDC Board recommends that the Town Council review and adopt the FY 2023-2024 Prosper Economic Development Corporation Budget. Proposed Motion: I move to adopt the FY 2023-2024 Prosper Economic Development Corporation Budget as presented. Page 105 Item 5. 8/18/2023 Final Approved/Amended Actual to Date PROPOSED FY 2021-2022 FY 2022-2023 FY 2022-2023 FY 2023-2024 REVENUES 800 4120 65 00 Sales Tax 5,166,371$ 5,561,403$ 4,427,236$ 6,121,611$ 800 4610 65 00 Interest on Investments 89,799$ 72,000$ 412,617$ 400,000$ 500 0000 65 00 Sale of Land -$ 500 0000 65 00 Contributions/Donations Revenue 800 4910 65 00 Other Revenue 336,624$ 0.01$ 500 0000 00 00 Operating Transfer In 500 0000 30 00 Gain/Loss on Sale - Auction Revenue 800 4920 65 00 Lease Proceeds 13,351$ 800 4990 65 00 Gain/Loss-Sale of Fi 187,299$ Total Revenues 5,793,444$ 5,633,403$ 4,839,853$ 6,521,611$ EXPENSES Personnel Services - Salary 800 5110 65 00 Salaries & Wages 268,177$ 331,869$ 215,293$ 276,462$ 800 5115 65 00 Salaries - Overtime -$ 800 5140 65 00 Salaries - Longevity Pay 430$ 670$ 550$ 790$ 800 5141 65 00 Salary Incentive 57,861$ 50,000$ 54,682$ 50,000$ 800 5142 65 00 Car Allowance 13,000$ 12,000$ 10,000$ 12,000$ 800 5143 65 00 Cell Phone Allowance 1,925$ 2,400$ 2,000$ 2,400$ 800 0000 65 00 Temporary Salaries -$ Total Salary 341,393$ 396,939$ 282,526$ 341,652$ Personnel Services - Benefit 800 5145 65 00 Social Security Expense 14,562$ 18,052$ 11,247$ 13,977$ 800 5150 65 00 Medicare Expense 4,646$ 5,018$ 3,883$ 4,229$ 800 5155 65 00 Unemployment (SUTA)18$ 486$ 18$ 324$ 800 5160 65 00 Health Insurance 24,579$ 30,744$ 19,045$ 20,880$ 800 5162 65 0 HSA Expense 3,000$ 4,200$ 3,000$ 2,400$ 800 5165 65 00 Dental Insurance 859$ 1,368$ 613$ 816$ 800 5170 65 00 Life Insurance 282$ 338$ 210$ 208$ 800 5175 65 00 Liability (TML) Worker's Comp 650$ 796$ 588$ 496$ 800 5176 65 00 TML Prop. & Liab. Insurance -$ -$ -$ -$ 800 5180 65 00 TMRS-Expense 47,410$ 48,861$ 39,851$ 41,677$ 800 5185 65 00 Long Term/Short Term Disability 509$ 631$ 409$ 526$ 800 5186 65 00 WELLE-Wellness Prog Reimb-Empl 768$ 1,200$ 618$ 600$ 500 0000 20 83 Relocation Expenses -$ -$ -$ -$ Total Benefits 97,282$ 111,694$ 79,482$ 86,133$ Operating, Land & Incentive Expenses 800 5189 65 00 Admin. Fees to Town 15,000$ 15,500$ 12,500$ 15,500$ 800 5190 65 00 Contract Labor 48,000$ 75,000$ 43,000$ 75,000$ 800 5191 65 00 Hiring Cost -$ -$ -$ -$ 800 5210 65 00 Office Supplies 2,187$ 5,000$ 1,462$ 5,000$ 800 5212 65 00 Building Supplies 1,000$ -$ 1,000$ 800 5220 65 00 Office Equip & Furniture 9,925$ 10,000$ 2,107$ 10,000$ 800 5230 65 00 Dues & Subscriptions 23,350$ 20,000$ 18,472$ 20,000$ 800 5240 65 00 Postage & Freight 461$ 1,030$ 425$ 1,030$ 800 5265 65 00 Promotional Expense 14,476$ 87,550$ 23,475$ 87,550$ 800 5268 65 00 Sponsorships & Donations 10,000$ 25,000$ 2,800$ 25,000$ 800 5280 65 00 Printing and Reproduction 2,575$ -$ 2,575$ 800 5305 65 00 Chapter 380 Program Grant 864,662$ 1,500,000$ 690,289$ 1,500,000$ 800 5310 65 00 Rental/Office Lease 1$ 1$ 1$ 1$ 800 5330 65 00 Copier Expense 2,368$ 5,000$ 1,790$ 5,000$ 800 5340 65 00 Building Repairs 10,000$ 1,095$ 10,000$ 800 5410 65 00 Professional Services 36,256$ 100,000$ 31,439$ 100,000$ 800 5412 65 00 Audit Fees 2,375$ 3,500$ 3,500$ 800 5414 65 00 Appraisal/Tax Fees 4,442$ 5,000$ -$ 5,000$ 800 5418 65 00 IT Fees -$ -$ -$ -$ 800 5430 65 00 Legal Fees 13,713$ 25,000$ 15,543$ 50,000$ 800 5480 65 00 Contracted Services -$ -$ -$ -$ 800 5510 65 0 Liability Insurance -$ -$ -$ -$ 800 5520 65 00 Telephones-Cable -$ -$ -$ 800 5521 65 00 Cell Phone Expense -$ -$ -$ -$ 800 5523 65 00 Water 605$ 700$ 494$ 2,000$ 800 5524 65 00 Gas - Office -$ -$ -$ -$ 800 5525 65 00 Electricity - Office 3,631$ 4,000$ 2,730$ 6,000$ 800 5526 65 00 Mobile Data Network 912$ 1,000$ 760$ 1,000$ 800 5530 65 00 Travel/Lodging/Meals Expense 321$ 5,000$ -$ 5,000$ 800 5531 65 00 Prospect Mtgs/Business Meals 8,102$ 10,000$ 7,171$ 10,000$ 800 5533 65 00 Mileage Expense 269$ 500$ 171$ 500$ 800 5536 65 00 Training/Seminars 1,548$ 5,000$ 900$ 5,000$ 800 5600 65 0 Special Events 20,634$ 25,000$ -$ 25,000$ 800 6015 65 00 Project Incentives 525,982$ 2,000,000$ 604,655$ 2,000,000$ 800 7100 65 0 Operating Transfer Out Total Expenses 1,609,219$ 3,942,356$ 1,461,280$ 3,970,656$ Total Operating Costs 2,047,894$ 4,450,989$ 1,823,287$ 4,398,441$ Net Income 3,745,550$ 1,182,414$ 3,016,566$ 2,123,170$ Page 106 Item 5. Page 1 of 2 To: Mayor and Town Council From: Daniel Heischman, Assistant Director of Engineering Services - Development Through: Mario Canizares, Town Manager Chuck Ewings, Assistant Town Manager Hulon T. Webb, Jr., Director of Engineering Services Re: Construction Inspection Fee Update Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Consider and act upon adopting an ordinance repealing existing Section I, “Construction Permits and Fees,” and Section II, “Reserved,” contained in Appendix A, “Fee Schedule,” of the Town’s Code of Ordinances and replacing them with a new Section I, “Engineering Inspection Fees,” and a new Section II, “Building Permits/Inspection Fees”. Description of Agenda Item: On September 1, 2023, HB 3492 became effective, which prohibits municipalities from considering the cost of constructing or improving the public infrastructure for a subdivision, lot, or related property development in determining the amount of a fee for inspection of said improvements. The law also prohibits requiring disclosure of valuations as a condition of acceptance. Municipalities must now have a fee structure based on “the municipality’s actual cost to, as applicable, to review and process the engineering or construction plan or to inspect the public infrastructure.” On November 8, 2022, the Town Council adopted engineering plan review fees based on costs to provide the service prior to any knowledge of this house bill; however, the construction inspection fee was not updated. Since it is currently a value-based (3% of construction costs of the public infrastructure) fee structure, it must be changed to comply with the new state law. Since the surrounding municipalities construction inspection fee structures are also value-based, staff from many of the neighboring communities met to discuss different strategies. While the initial intent of the collaboration was to work towards a consistent calculation that all involved could utilize, it soon became apparent that the level of effort expended was different for each municipality and that more specific tracking of actual time and effort were needed to formulate a more accurate calculation. So, in order for Prosper to adopt a fee structure to comply with the new state law, estimated time spent by all applicable staff on several project sizes and types were calculated. Those values were then converted to a proposed fee structure based on the size and different types of developments in order to streamline the calculation and assessment process. ENGINEERING SERVICES Page 107 Item 6. Page 2 of 2 The following table represents the proposed amendment to the construction inspection fees to comply with the new state law. Over the next six (6) to nine (9) months, staff will evaluate the actual time spent by all applicable staff on each project type to verify whether the proposed fees accurately account for all actual costs attributed to the inspection process of public infrastructure, or if changes to the fees need to be made. Budget Impact: Staff performed an initial analysis of the 3% construction inspection fees collected over the past 3 years (FY2020 to FY2022) for several project sizes and types and compared those fees to the proposed fees based on costs to provide the service for those same projects. The results of the comparison show that the proposed fees are on average 25% less than the current value-based fees. During the next six (6) to nine (9) months, staff will monitor the amount of construction inspection fees being collected compared to the $1,321,821 estimated revenue in the FY2024 budget. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has reviewed the ordinance as to form and legality. Attached Documents: 1. Ordinance Town Staff Recommendation: Town staff recommends that the Town Council approve an ordinance repealing existing Section I, “Construction Permits and Fees,” and Section II, “Reserved,” contained in Appendix A, “Fee Schedule,” of the Town’s Code of Ordinances and replacing them with a new Section I, “Engineering Inspection Fees,” and a new Section II, “Building Permits/Inspection Fees”. Proposed Motion: I move to approve an ordinance repealing existing Section I, “Construction Permits and Fees,” and Section II, “Reserved,” contained in Appendix A, “Fee Schedule,” of the Town’s Code of Ordinances and replacing them with a new Section I, “Engineering Inspection Fees,” and a new Section II, “Building Permits/Inspection Fees”. Single Family Residential Development $1,000 base fee plus $600 per platted lot Non-Residential Development $1,000 base fee plus $1,500 per final platted acreage Non-Residential Infrastructure * = or as identified on preliminary site plan Linear Utility Infrastructure $1,000 base fee** plus For offsite utilities outside of platted boundary Wastewater $3.00 per linear foot **=no base fee if done with platted development Water $3.00 per linear foot Storm Sewer $4.00 per linear foot Development Road $1,000 base fee** plus $3.00 per square yard of concrete surface Separate from platted development **=no base fee if done with platted development Turn Lanes and Median Openings **=no base fee if done with platted development Creek Stablization **=no base fee if done with platted development $1,000 base fee plus $1,200 per conveyance* platted acreage $1,000 base fee** plus $0.50 per square yard of distrurbed area $1,000 base fee** plus $3.00 per square yard of concrete surface Page 108 Item 6. Ordinance No. 2023-__, Page 1 TOWN OF PROSPER, TEXAS ORDINANCE NO. 2023-__ AN ORDINANCE OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, AMENDING APPENDIX A, “FEE SCHEDULE,” TO THE TOWN’S CODE OF ORDINANCES BY REPEALING EXISTING SECTION I, “CONSTRUCTION PERMITS AND FEES,” AND SECTION II, “RESERVED,” AND REPLACING THE FOREGOING SECTIONS WITH A NEW SECTION I, “ENGINEERING INSPECTION FEES,” AND A NEW SECTION II, “BUILDING PERMITS/INSPECTION FEES”; PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVIDING FOR AN EFFECTIVE DATE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF. WHEREAS, the Town Council of the Town of Prosper, Texas (“Town Council”), has investigated and determined that, as a result of recent legislation, House Bill 3492, approved by the 88th Texas Legislature and signed by the Governor, the Town’s engineering inspection fees should be contained in a separation section of Appendix A, “Fee Schedule,” since House Bill 3492 specifically addresses inspection fees related to public infrastructure; and WHEREAS, since engineering inspection fees will be contained as a stand-alone item in new Section I, new Section II will address building permit and inspection fees which are not the subject of House Bill 3492; and WHEREAS, the Town Council has reviewed the current and proposed engineering inspection fees and recommends the adoption of the revised fee schedule, as contained in proposed Sections I and II of Appendix A; and WHEREAS, the Town Council hereby finds and determines that it will be advantageous, beneficial and in the best interests of the citizens of Prosper to repeal existing Section I, “Construction Permits and Fees,” and Section II, “Reserved,” of Appendix A, “Fee Schedule,” and replace said sections with a new Section I, “Engineering Inspection Fees,” and a new Section II, “Building Permits/Inspection Fees.” NOW, THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2 From and after the effective date of this Ordinance, existing Section I, “Construction Permits and Fees,” and existing Section II, “Reserved,” of Appendix A, “Fee Schedule,” to the Town’s Code of Ordinances are hereby repealed in their entirety and replaced with a new Section I, “Engineering Inspection Fees,” and a new Section II, “Building Permits/Inspection Fees,” to read as follows: Page 109 Item 6. Ordinance No. 2023-__, Page 2 “Sec. I. Engineering Inspection Fees. The following engineering inspection fees are hereby adopted for all public infrastructure and related development: Sec. II. Building Permits/Inspection Fees. (a) The building permit and inspection fees as follows are hereby for various construction-type projects in conjunction with, among others, residential, commercial and industrial structures prior to the start of construction. A determination of the valuation f or any enclosed structure other than residential shall be determined at the discretion of the town. (1) Minimum building permit fees: $20.00. (2) Residential new construction: (A) Residential building plan review fee: A nonrefundable plan review of $300.00 or 10% of the building permit, whichever is less, is due at the time of submittal. (B) Residential building permit fee: Single Family Residential Development $1,000 base fee plus $600 per platted lot Non-Residential Development $1,000 base fee plus $1,500 per final platted acreage Non-Residential Infrastructure * = or as identified on preliminary site plan Linear Utility Infrastructure $1,000 base fee** plus For offsite utilities outside of platted boundary Wastewater $3.00 per linear foot **=no base fee if done with platted development Water $3.00 per linear foot Storm Sewer $4.00 per linear foot Development Road $1,000 base fee** plus $3.00 per square yard of concrete surface Separate from platted development **=no base fee if done with platted development Turn Lanes and Median Openings **=no base fee if done with platted development Creek Stablization **=no base fee if done with platted development $1,000 base fee plus $1,200 per conveyance* platted acreage $1,000 base fee** plus $0.50 per square yard of distrurbed area $1,000 base fee** plus $3.00 per square yard of concrete surface Page 110 Item 6. Ordinance No. 2023-__, Page 3 Gross Square Feet Fee 999 sq. ft. or less $1.00 per sq. ft. up to and including 999 sq. ft. 1,000 sq. ft. to 4,900 sq. ft. $1,040.30 for the first 1,000 sq. ft.; plus $0.713 for each additional one (1) sq. ft., up to and including 4,900 sq. ft. 4,901 sq. ft. to 7,999 sq. ft. $3,824.11 for the first 4,901 sq. ft.; plus $0.509 for each additional one (1) sq. ft., up to and including 7,999 sq. ft. 8,000 sq. ft. or greater $5,403.00 for the first 8,000 sq. ft.; plus $0.30 for each additional one (1) sq. ft. (3) Residential accessory buildings and carports: $0.75 per sq. ft. + $75.00. (4) Residential alteration or addition: $0.75 per sq. ft. + $75.00. (5) Residential roof repair or replacement: $100.00. (6) Swimming pools: (A) In ground: $300.00 permit fee. (B) Above ground: $100.00 permit fee. (C) Spas: $100.00. (7) Commercial (new construction, additions, alterations, and single trade permits for mechanical, electrical or plumbing): (A) Commercial building plan review fee: A nonrefundable plan review of $300.00 or 10% of the building permit, whichever is less, is due at the time of submittal. (B) Commercial building permit fee: Page 111 Item 6. Ordinance No. 2023-__, Page 4 Total valuation Plan Review Fee Inspection Fee $1.00 to $10,000.00 $50.00 $76.92 $10,001.00 to $25,000.00 $70.69 for the first $10,00.00; plus $5.46 for each additional $1,000.00 $108.75 for the first $10,00.00; plus $8.40 for each additional $1,000.00 $25,001.00 to $50,000.00 $159.59 for the first $25,000.00; plus $3.94 for each additional $1,000.00 $234.75 for the first $25,000.00; plus $6.06 for each additional $1,000.00 $50,001.00 to $100,000.00 $251.09 for the first $50,000.00; plus $2.73 for each additional $1,000.00 $386.25 for the first $50,000.00; plus $4.20 for each additional $1,000.00 $100,001.00 to $500,000.00 $387.59 for the first $100,000.00; plus $2.19 for each additional $1,000 $596.25 for the first $100,000.00; plus $3.36 for each additional $1,000. $500,001.00 to $1,000,000.00 $1,263.59 for the first $500,000.00; plus $1.85 for each additional $1,000.00 $1,940.25 for the first $500,000.00; plus $2.85 for each additional $1,000.00 $1,000,001.00 and over $2,188.59 for the first $1,000,000.00; plus $1.23 for each additional $1,000.00 $3,365.25 for the first $1,000,000.00; plus $1.89 for each additional $1,000.00 The valuation shall be based upon the square foot construction cost per the most current ICC Building Valuation Data. The valuation is determined using the building gross area times the square foot construction cost. For shell only buildings deduct 20 percent of construction cost. For finish outs only, deduct 50 percent of the construction cost. (8) Certificate of occupancy: $50.00 each. (9) Contractor registration (except where such registration is prohibited by state law): $100.00 each. All contractors are required to register with the Town. Annual $100.00 registration fee. (10) After-hours inspections: $50.00 per inspection with a 2-hour minimum. (11) Demolition: $50.00 permit fee. (12) Document retrieval fee: $10.00. (13) Dumpster enclosure: $20.00 permit fee/per enclosure. (14) Fence: $30.00 per permit. No permit is needed if replacing less than 2 panels of fence totaling less than 16' in length. (15) Foundations/foundation repair: $50.00. Page 112 Item 6. Ordinance No. 2023-__, Page 5 (16) Lawn irrigation systems: $30.00 permit fee. The inspection must be done by a certified backflow tester and report must be given to building inspector. (17) Miscellaneous inspections: Backflow prevention, electrical, mechanical, and plumbing: $50.00 each. (18) Multifamily: One application is required per building: $5.00 per $1,000.00 valuation of project. (19) Re-inspection fee: (A) $50.00 for the first re-inspection. (B) $75.00 for the second re-inspection. (C) $100.00 for the third re-inspection. (D) fees will increase on a basis of $25.00 each thereafter. (20) Concrete flatwork including sidewalks, approaches and patios: $50.00 per permit. (21) Temporary outdoor seasonal sale or special event permit: $100.00 permit fee + $1,000.00 deposit. (22) Construction Trailer: $100.00. (23) Residential solar and generators permit: $150.00. (24) Revision/Restamp Fee and fee for multiple round plan review (starting after second round): $50.00 per hour with a 2-hour minimum. (25) Residential single-trade permits for mechanical, electrical or plumbing: $75.00. (b) Third-party geotechnical and material testing fee. The Town shall hire and manage third-party geotechnical and material testing companies for any project where such testing is deemed necessary and proper by the town. The town shall be reimbursed by the developer for the town's actual costs for such geotechnical and material testing. (c) Camera inspection fee for wastewater mains. Prior to the Town’s acceptance of any wastewater main, the town shall inspect the wastewater main by camera. The fee for such inspection shall be $1.00 per linear foot of wastewater main.” SECTION 3 All provisions of any ordinance in conflict with this Ordinance are hereby repealed to the extent they are in conflict; but such repeal shall not abate any pending prosecution for violation of the repealed ordinance, nor shall the repeal prevent a prosecution from being commenced for any violation if occurring prior to the repeal of the ordinance. Any remaining portion of conflicting ordinances shall remain in full force and effect. Page 113 Item 6. Ordinance No. 2023-__, Page 6 SECTION 4 If any section, subsection, sentence, clause or phrase of this Ordinance is for any reason held to be unconstitutional or invalid by a court of competent jurisdiction, such decision shall not affect the validity of the remaining portions of this Ordinance. The Town hereby declares that it would have passed this Ordinance, and each section, subsection, clause or phrase thereof, irrespective of the fact that any one or more sections, subsections, sentences, clauses, and phrases be declared unconstitutional. SECTION 5 This Ordinance shall take effect and be in full force from and after its passage and publication, as provided by the Revised Civil Statutes of the State of Texas and the Home Rule Charter of the Town of Prosper, Texas. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ON THIS 12TH DAY OF SEPTEMBER, 2023. APPROVED: ________________________________ David F. Bristol, Mayor ATTEST: ___________________________________ Michelle Lewis Sirianni, Town Secretary APPROVED AS TO FORM AND LEGALITY: __________________________________ Terrence S. Welch, Town Attorney Page 114 Item 6. Page 1 of 2 To: Mayor and Town Council From: David Hoover, Director of Development Services Through: Mario Canizares, Town Manager Chuck Ewings, Assistant Town Manager Re: Façade Plan Outback Steakhouse Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 3. Commercial Corridors are ready for Development Agenda Item: Consider and act upon a Façade Plan for a Restaurant, on 1.7± acres, located south of Lovers Lane and west of South Preston Road. The property is zoned Planned Development-67 (PD-67) Gates of Prosper. (DEVAPP-23-0129) Description of Agenda Item: Per Planned Development-67 (PD-67), façade plans are required to be approved by the Town Council. The Façade Plan shows exterior elevations of the restaurant that is being proposed on the subject property as shown below: On August 15, 2023, the Planning & Zoning Commission approved the Site Plan (DEVAPP-23- 0126) and Façade Plan (DEVAPP-23-0129) for a Restaurant with a vote of 6-0. PLANNING Page 115 Item 7. Page 2 of 2 Budget Impact: There is no budgetary impact affiliated with this item. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Location Map 2. Façade Plan Town Staff Recommendation: Town Staff recommends approval of a Façade Plan for a Restaurant, on 1.7± acres, located south of Lovers Lane and west of South Preston Road. Proposed Motion: I move to approve/deny a Façade Plan for a Restaurant, on 1.7± acres, located south of Lovers Lane and west of South Preston Road. Page 116 Item 7. Page 117 Item 7. GPD GROUP Professional Corporaion 520 Soh ain Sree, Sie 2531 Fax 330.572.2101330.572.2100 Akron, OH 44311 SHEET TITLE: SHEET NO.PROJ. NO. DRAWN BY: PROJECT ARCHITECT: PRINCIPAL IN CHARGE: SHEET ISSUE: A 1 2 3 4 5 1 2 3 4 5 CONSULTANT LOGOB C D SEALS7/13/2023 4:35:29 PMC:\Users\pcarthern\Documents\ARCH_OBS_JOEY_PROSPER TX_R21_pcarthernWNHCE.rvt2022231.11OUTBACK STEAKHOUSEBLOOMIN' BRANDSDEVAPP-23-0129JOEY PROTOTYPE - 2023.1 RELEASESTORE #4472GATES OF PROSPERPHASE 1, BLOCK A, LOT 4PROSPER, TX 7507806/19/2023 SITE PLAN SUBMITTAL 07/18/2023 SITE PLAN RESUBMITTAL EXTERIOR PAINT COLOR NUMBER METAL COPING COLOR:COPPER BROWN ALUMINUM BRAKE METAL STOREFRONT ALUMINUM STOREFRONT COLOR:DARK BRONZE MT-19 SF-01 MASONRY TYPE REMARKS MANUFACTURER: BERRIDGE DOUBLE LATTE SW 9108 PT-69 SHERWIN WILLIAMSTURKISH COFFEEPT-11 SW 6076 SHERWIN WILLIAMS: STO COLOR: NA22-0002 (CEILING OF COVERED WAITING AREA) DOUBLE LATTEPT-69 1 1/2" GALVANIZED METAL DECKING, 22 GA COLOR:PT-70 MT-20 SW 7019 SHERWIN WILLIAMSGAUNTLET GRAYPT-70 BRAND BR-01 CULTURED STONE VENEER SYSTEM MANUFACTURER: ENDICOTT STYLE: IVORY BLEND, VELOUR TEXTURE, MODULAR SIZE GROUT: LATICRETE #60 DUSTY GREY, OR EQUAL CONTACT: DOUG MCCALL; (813)482-8526; Doug.McCall@oldcastle.com BR-02 CULTURED STONE VENEER SYSTEM MANUFACTURER: ENDICOTT STYLE: RUBY RED, VELOUR TEXTURE, MODULAR SIZE GROUT: LATICRETE #60 DUSTY GREY, OR EQUAL CONTACT: DOUGH MCCALL; (813)482-8526; Doug.McCall@oldcastle.com FIBER CEMENT SIDING COLOR:PRIMED FOR PAINTING (PT-11) HARDIEPANEL SELECT CEDARMILL CB-06 MANUFACTURER: JAMES HARDIE CONTACT: (888) 716-6744, RUBEN.GARCIA@JAMESHARDIE.COM FIBER CEMENT SIDING COLOR:ROUGH SAWN, ESPRESSO # AWP30-30 CB-07 MANUFACTURER: NICHIHA USA, INC CONTACT: (770) 805-9466 FIBER CEMENT SIDING EXTERIOR FINISH SCHEDULE FRONT ELEVATION 1321 SQ. FT. 1381 SQ. FT. 329 SQ. FT TOTAL SURFACE AREA DOOR AND WINDOW SURFACE AREA NET SURFACE AREA % OF BRICK % OF NICHIHA 71 29 938 SQ. FT. (71%) 383 SQ. FT. (29%) NON-TAKE AWAY SIDE ELEVATION 1189 SQ. FT. 1538 SQ. FT. 349 SQ. FT TOTAL SURFACE AREA DOOR AND WINDOW SURFACE AREA NET SURFACE AREA % OF BRICK % OF NICHIHA 83 17202 SQ. FT. (17%) 987 SQ. FT. (83%) SCALE: 1/4" = 1'-0" SCALE: 1/4" = 1'-0" A300 EXTERIOR ELEVATIONS RO MS PC GENERAL NOTES 1. THIS FACADE PLAN IS FOR CONCEPTUAL PURPOSES ONLY. ALL BUILDING PLANS REQUIRE REVIEW AND APPROVAL FROM THE BUILDING INSPECTIONS DIVISION. 2. ALL MECHANICAL EQUIPMENT SHALL BE SCREENED FROM PUBLIC VIEW. ROOFTOP MOUNTED EQUIPMENT SHALL BE SCREENED BY A PARAPET WALL OR SCREENING WALL. SCREENING WALLS SHALL BE THE SPECIFICATIONS OF THE ZONING ORDINANCE. 3. WHEN PERMITTED, EXPOSED UTILITY BOXES AND CONDUITS SHALL BE PAINTED TO MATCH THE BUILDING. 4. ALL SIGNAGE AREAS AND LOCATIONS ARE SUBJECT TO APPROVAL BY THE BUILDING INSPECTIONS DIVISION. 5. WINDOWS SHALL HAVE A MAXIMUM EXTERIOR VISIBLE REFLECTIVITY OF TEN (10) PERCENT. 6. ANY DEVIATION FROM THE APPROVED FACADE PLAN WILL REQUIRE RE-APPROVAL BY THE TOWN OF PROSPER. Approved by Town Council on ____ of __________, 20__ Page 118 Item 7. GPD GROUP Professional Corporaion 520 Soh ain Sree, Sie 2531 Fax 330.572.2101330.572.2100 Akron, OH 44311 SHEET TITLE: SHEET NO.PROJ. NO. DRAWN BY: PROJECT ARCHITECT: PRINCIPAL IN CHARGE: SHEET ISSUE: A 1 2 3 4 5 1 2 3 4 5 CONSULTANT LOGOB C D SEALS7/13/2023 4:37:20 PMC:\Users\pcarthern\Documents\ARCH_OBS_JOEY_PROSPER TX_R21_pcarthernWNHCE.rvt2022231.11OUTBACK STEAKHOUSEBLOOMIN' BRANDSDEVAPP-23-0129 TAKE AWAY SIDE ELEVATION 1336 SQ. FT. 1574 SQ. FT. 238 SQ. FT TOTAL SURFACE AREA DOOR AND WINDOW SURFACE AREA NET SURFACE AREA % OF BRICK % OF NICHIHA 84 16 JOEY PROTOTYPE - 2023.1 RELEASESTORE #4472GATES OF PROSPERPHASE 1, BLOCK A, LOT 4PROSPER, TX 7507806/19/2023 SITE PLAN SUBMITTAL 07/18/2023 SITE PLAN RESUBMITTAL EXTERIOR PAINT COLOR NUMBER METAL COPING COLOR:COPPER BROWN ALUMINUM BRAKE METAL STOREFRONT ALUMINUM STOREFRONT COLOR:DARK BRONZE MT-19 SF-01 MASONRY TYPE REMARKS MANUFACTURER: BERRIDGE DOUBLE LATTE SW 9108 PT-69 SHERWIN WILLIAMSTURKISH COFFEEPT-11 SW 6076 SHERWIN WILLIAMS: STO COLOR: NA22-0002 (CEILING OF COVERED WAITING AREA) DOUBLE LATTEPT-69 1 1/2" GALVANIZED METAL DECKING, 22 GA COLOR:PT-70 MT-20 SW 7019 SHERWIN WILLIAMSGAUNTLET GRAYPT-70 BRAND BR-01 CULTURED STONE VENEER SYSTEM MANUFACTURER: ENDICOTT STYLE: IVORY BLEND, VELOUR TEXTURE, MODULAR SIZE GROUT: LATICRETE #60 DUSTY GREY, OR EQUAL CONTACT: DOUG MCCALL; (813)482-8526; Doug.McCall@oldcastle.com BR-02 CULTURED STONE VENEER SYSTEM MANUFACTURER: ENDICOTT STYLE: RUBY RED, VELOUR TEXTURE, MODULAR SIZE GROUT: LATICRETE #60 DUSTY GREY, OR EQUAL CONTACT: DOUGH MCCALL; (813)482-8526; Doug.McCall@oldcastle.com FIBER CEMENT SIDING COLOR:PRIMED FOR PAINTING (PT-11) HARDIEPANEL SELECT CEDARMILL CB-06 MANUFACTURER: JAMES HARDIE CONTACT: (888) 716-6744, RUBEN.GARCIA@JAMESHARDIE.COM FIBER CEMENT SIDING COLOR:ROUGH SAWN, ESPRESSO # AWP30-30 CB-07 MANUFACTURER: NICHIHA USA, INC CONTACT: (770) 805-9466 FIBER CEMENT SIDING EXTERIOR FINISH SCHEDULE SCALE: 1/4" = 1'-0" SCALE: 1/4" = 1'-0" 1122 SQ. FT. (84%) 214 SQ. FT. (16%) REAR ELEVATION 1321 SQ. FT. 1390 SQ. FT. 63 SQ. FT TOTAL SURFACE AREA DOOR AND WINDOW SURFACE AREA NET SURFACE AREA % OF BRICK % OF NICHIHA 100 0 1321 SQ. FT. (100%) N/A A301 EXTERIOR ELEVATIONS RO MS PC GENERAL NOTES 1. THIS FACADE PLAN IS FOR CONCEPTUAL PURPOSES ONLY. ALL BUILDING PLANS REQUIRE REVIEW AND APPROVAL FROM THE BUILDING INSPECTIONS DIVISION. 2. ALL MECHANICAL EQUIPMENT SHALL BE SCREENED FROM PUBLIC VIEW. ROOFTOP MOUNTED EQUIPMENT SHALL BE SCREENED BY A PARAPET WALL OR SCREENING WALL. SCREENING WALLS SHALL BE THE SPECIFICATIONS OF THE ZONING ORDINANCE. 3. WHEN PERMITTED, EXPOSED UTILITY BOXES AND CONDUITS SHALL BE PAINTED TO MATCH THE BUILDING. 4. ALL SIGNAGE AREAS AND LOCATIONS ARE SUBJECT TO APPROVAL BY THE BUILDING INSPECTIONS DIVISION. 5. WINDOWS SHALL HAVE A MAXIMUM EXTERIOR VISIBLE REFLECTIVITY OF TEN (10) PERCENT. 6. ANY DEVIATION FROM THE APPROVED FACADE PLAN WILL REQUIRE RE-APPROVAL BY THE TOWN OF PROSPER. Approved by Town Council on ____ of __________, 20__ 1410 SQ. FT. 1340 SQ. FT. 1340 SQ. FT. Page 119 Item 7. Page 1 of 1 To: Mayor and Town Council From: David Hoover, Director of Development Services Through: Mario Canizares, Town Manager Chuck Ewings – Assistant Town Manager Re: Notice of Appeals Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 3. Commercial Corridors are ready for Development Agenda Item: Consider and act upon whether to direct staff to submit a written notice of appeals on behalf of the Town Council to the Development Services Department, pursuant to Chapter 4, Section 1.5(C)(7) and 1.6(B)(7) of the Town’s Zoning Ordinance, regarding action taken by the Planning & Zoning Commission on any Site Plans including Prestonwood Baptist Church and Outback Steakhouse. Description of Agenda Item: Attached are the Site Plans that were acted on by the Planning & Zoning Commission at their meeting on August 15, 2023. Per the Zoning Ordinance, the Town Council can direct staff to submit a written notice of appeal on behalf of the Town Council to the Development Services Department for any Site Plans and Preliminary Site Plans acted on by the Planning & Zoning Commission. Budget Impact: There is no budgetary impact affiliated with this item. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. DEVAPP-23-0112 – Prestonwood Baptist Church (Approved 6-0) 2. DEVAPP-23-0126 – Outback Steakhouse (Approved 6-0) Town Staff Recommendation: Town Staff recommends the Town Council take no action on this item. PLANNING Page 120 Item 8. VANVANSSSSSSSSSS SS SS SSSSSS SSSS SSSS SSSS SSSSSSSS SSSS SSSSSSSS SSSS SSSS SSSS SSSS SSSSSSSSSSSSSSSSSS SS SSSS SSSSSS SSSSSSSSSSSSS S SS SS FIRELANE SS SSSS SSSS SSSSSSSSSSSSSSSSSSSSSSSS SS SS SS SS SS SSSSSSSSSSSSSSSSSS SSSS SS SSSS SSSS SS SSSSSSSSSSSSSSSSSS– ” THESE PLANS HAVE BEEN LOCATED FROM REFERENCE INFORMATION AND AS-BUILT PLANS. IT SHALL BE THE RESPONSIBILITY OF THE CONTRACTOR TO VERIFY HORIZONTAL AND VERTICAL LOCATION OF ALL EXISTING UTILITIES PRIOR TO CONSTRUCTION. THE CONTRACTOR SHALL TAKE NECESSARY PRECAUTIONS TO PROTECT ALL EXISTING UTILITIES AND WILL BE RESPONSIBLE FOR ANY DAMAGE TO SAID UTILITIES. THE CONTRACTOR SHALL NOTIFY ALL UTILITY COMPANIES PRIOR TO CONSTRUCTION. EXISTING UTILITIES AND UNDERGROUND FACILITIES OF CAUTION: DRAWN BY: DATE: PROJECT NO.SHEET Graham Associates,Inc. CONSULTING ENGINEERS & PLANNERS 600 SIX FLAGS DRIVE, SUITE 500 ARLINGTON, TEXAS 76011 (817) 640-8535 TBPE FIRM: F-1191/TBPLS FIRM: 101538-00 NORTH CAMPUS - SITE PLAN PRESTONWOOD BAPTIST CHURCH TOWN of PROSPER, COLLIN COUNTY, TEXAS GAI 9929-1039 8/9/2023 1.01 SITE REVISED SITE PLAN - BLOCK A, LOT 1R (DEVAPP-23-0112) 08/09/2023 Page 121 Item 8. 5 8 9 1414 10 15 12 8 5 FL FLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFL WWWWWWWWWWWWWWWWWWWWFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFLFL FL FL FL FL FL FL FL FL FL FL FL FL FL FL FL FL FL FL Z Z RWRWRWRWRWRWRWRWRWRWRWRWRW RW RW RW RWRWRWRWRWRWRWFLFLFLFLFLFLFLFL5 9 TUGEUGEUGEUGEUGEUGEUGEUGE UGE UGEUGEUGEUGE UGE UGEUGEUGEUGEUGEPCOMMCOMMCOMMCOMMCOMMCOMMCOMMCOMMCOMMCOMMCOMMCOM M COMMCOMMCOMMCOMMCOMMCOMMGASGASGASGASGASGASGASGASGASGASGASGASGAS GAS GASGASGASGASGASGASGASUGEUGETBLOCK A LOT 4 1.74 ACRES 75,849 SQ FT RESTAURANT 4,936 SQ FT FFE=709.95 EX 15' WE EX WE EX WEEX WE S DUMPSTER ENCLOSURE W/ 8' TALL MASONRY SCREENING WALL (BRICK AND STONE) TO MATCH BUILDING AND 8' METAL GATE. 15'X12' (TYP.)24'18'9' TYP. 26' FIRE LANE, ACCESS, DRAINAGE, AND UTILITY EASEMENT CONCRETE BOLLARDS WITH ADA SIGN MOUNTED EXISTING WYE INLET 24'PROPOSED RETAINING WALL WITH HANDRAIL REFERENCE ARCHITECTURE PLAN EXISTNG RETAINING WALL EXISTING RETAINING WALL TO BE DEMOLISHED 9' TYP.CI CI6'3 - STEPS BFR 6' CONCRETE SIDEWALK EX 30' LANDSCAPE EASEMENT BFR TYP. ADA LOADING ZONE TYP. 15' WE 20'20' 18' 20'18'18'18'6' CONCRETE SIDEWALK 6'18'24'18' R30' R261' 15' BUILDING SETBACK 5' LANDSCAPE SETBACK EX 15' WE EX 30' LANDSCAPE EASEMENT ∆=56°37'14" R=165.00' L=163.06' CB=N83°52'12"W C=156.50' N55°33'35"W 282.30'N34°26'33"E150.04'N69°39'11"E 27.44' N34°26'25"E 19.53'S33°38'20"W300.00'S35°04'16"W385.16'CONCRETE BOLLARDS WITH TAKE-OUT SIGN MOUNTED LIGHT POLE LIGHT POLE 1 2 5' LANDSCAPE SETBACK 5' LANDSCAPE SETBACK EX FH PROPOSED FH 26' GREASE TRAP MIN CAPACITY 1000 GALLONS REMOTE FDC WITH BOLLARDS RISER ROOM 10'10' 10' EX FH R30' SAMPLE WELLS This document, together with the concepts and designs presented herein, as an instrument of service, is intended only for the specific purpose and client for which it was prepared. Reuse of and improper reliance on this document without written authorization and adaptation by Kimley-Horn and Associates, Inc. shall be without liability to Kimley-Horn and Associates, Inc.BYDATEAS SHOWNREVISIONSNo.DATESHEET NUMBER CHECKED BYSCALEDESIGNED BYDRAWN BYKHA PROJECT260 EAST DAVIS STREET, SUITE 100, MCKINNEY, TX 75069PHONE: 469-301-2580 FAX: 972-239-3820WWW.KIMLEY-HORN.COM TX F-928RAKKEMRAKLAST SAVED8/9/2023 3:22 PMPLOTTED BYMAHLMANN, KAITLIN (MCCOY) 8/9/2023 3:23 PMDWG PATHK:\MKN_CIVIL\068109030-GATES OF PROSPER\_PHASE 1\_BUILDING J\CAD\PLANSHEETSDWG NAMESITE PLAN.DWG , [ 24 x 36 ]IMAGES Town of Prosper Logo :XREFS xStrm : xSurv : xUtil : xBrdr : xSite : xSurv-Ph3-Onsite : xUtil-Building J : xStrm-Building J : xFrost068109030OUTBACKSTEAKHOUSEPROSPER, TEXAS© 2020 KIMLEY-HORN AND ASSOCIATES, INC.JUNE 2023Not for construction or permit purposes. FOR REVIEW ONLY Engineer P.E. No.Date132468 RACHEL A. KORUS 06/19/2023 C-07SITE PLAN00 20'40' GRAPHIC SCALE 20' TYP TYPICAL WATER EASEMENTWE SANITARY SEWER EASEMENTSSE NUMBER OF PARKING SPACESX FH ACCESSIBLE PARKING SYMBOL BARRIER FREE RAMP (BFR) EXISTING CONTOUR - MAJOR EXISTING CONTOUR - MINOR DRAINAGE EASEMENTDE BARRIER FREE RAMPBFR SIDEWALKSW CURB INLETCI LEGEND FIRE HYDRANT EXISTING PAVEMENT FDC FIRE DEPARTMENT CONNECTION EXISTINGEX PROPOSEDPROP. PROPOSED FIRE LANE PROPOSED BUILDING FL FL BUILDING LINE/SETBACKBL WM WYE INLETWI MANHOLEMH TRANSFORMER PAD GRATE INLETGI JUNCTION BOXJB T S SANITARY SEWER MANHOLE CURB INLET GRATE INLET HEADWALL JUNCTION BOX OR WYE INLET WATER METER (AND VAULT) PROPSED CONTOUR - MAJOR PROPOSED CONTOUR - MINOR N.T.S. US HWY 380 (UNIVERSITY)BNSF RAILROADTOWN OF PROSPER RICHLAND LOVERS LNLOVERS LN CITY OF FRISCO STATE HWY 289 (PRESTON)BUS. 289BUS. 289PROJECT LOCATION SITE DATA SUMMARY TABLE ZONING/PROPOSED USE PD-67/PD LOT AREA/ SQ. FT. AND AC BUILDING AREA (gross square footage)4,776 GSF (REST.) BUILDING HEIGHT (number of stories) MAX HEIGHT = 40' LOT COVERAGE FLOOR AREA RATIO (for non-residential zoning) TOTAL PARKING PROVIDED 100 SURFACE SPACES TOTAL HANDICAP REQUIRED 4 SPACES TOTAL HANDICAP PROVIDED 4 SPACES USABLE OPEN SPACE REQUIRED 5303 SQ. FT. (%) USABLE OPEN SPACE PROVIDED BLOCK A, LOT 4 *HANDICAP PARKING IS PROVIDED IN ACCORDANCE WITH TAS STANDARDS TOTAL PARKING REQUIRED (1:100 FOR RESTAURANT) IMPERVIOUS SURFACE 53,670 SQ. FT. 50 SPACES INTERIOR LANDSCAPING REQUIRED 11,378 SQ. FT. INTERIOR LANDSCAPING PROVIDED 21,530 SQ. FT. RESTAURANT 75,759 SF; 1.74 AC 7.10% GOP #2 LLC 1 Cowboys Way Frisco, Texas 75034 Contact: Nicholas Link Phone:(972)-497-4854 Kimley-Horn and Associates, Inc. 260 East Davis Street, Suite 100 McKinney, Texas 75069 Contact: Rachel Korus, P.E. Phone: (469)-301-2580 Bloomin' Brands, Inc. 2202 N. West Shore Blvd., Suite 500 Tampa, FL 33607 Phone: (727) 207-9270 Contact: Stacy Miller BM #452 "(" SET ON SOUTHWEST CORNER OF CURB INLET LOCATED ON WEST SIDE OF PRESTON ROAD AND ±900' NORTH OF U.S. 380. ELEV. = 670.70' BM #453 "(" SET ON CENTER OF CONCRETE HEADWALL LOCATED ±15' WEST OF S. COLEMAN ST. AND ±2,900' NORTH OF PRESTON ROAD. ELEV. = 672.80' BM #454 "(" SET ON CENTER OF CONCRETE HEADWALL LOCATED ±16' WEST OF PRESTON ROAD AND ±60' SOUTH OF LOVERS LANE. ELEV. = 721.15' BENCH MARK LIST ID BLOCK A TYPE DOMESTIC IRRIGATIONA SIZE 2" 1" LOT 4 4 SANITARY SEWER 6" N/A METER SCHEDULE 1 2 ANY REVISION TO THIS PLAN WILL REQUIRE TOWN APPROVAL AND WILL REQUIRE REVISIONS TO ANY CORRESPONDING PLANS TO AVOID CONFLICTS BETWEEN PLANS. 1.DUMPSTERS AND TRASH COMPACTORS SHALL BE SCREENED IN ACCORDANCE WITH THE ZONING ORDINANCE. 2.OPEN STORAGE, WHERE PERMITTED, SHALL BE SCREENED IN ACCORDANCE WITH THE ZONING ORDINANCE. 3.OUTDOOR LIGHTING SHALL COMPLY WITH THE LIGHTING AND GLARE STANDARDS CONTRAINED WITHIN THE ZONING ORDINANCE. 4.LANDSCAPING SHALL CONFORM TO LANDSCAPE PLANS APPROVED BY THE TOWN. 5.ALL ELEVATIONS SHALL COMPLY WITH THE STANDARDS CONTAINED WITHIN THE ZONING ORDINANCE. 6.BUILDINGS OF 5,000 SQUARE FEET OR GREATER SHALL BE 100% FIRE SPRINKLED. ALTERNATIVE FIRE PROTECTION MEASURES MAY BE APPROVED BY THE FIRE DEPARTMENT. 7.OCCUPANT NOTIFICATION PER THIS SECTION AND 907.5 SHALL BE REQUIRED FOR ALL NEW CONSTRUCTION, OR EXISTING CONSTRUCTION COMPLYING WITH THE INTERNATIONAL BUILDING CODE, FOR RENOVATIONS TO EXISTING BUILDINGS, TENANT SPACES, CHANGES IN OCCUPANCY, REPLACEMENT OR MODIFICATION OF THE EXISTING FIRE ALARM SYSTEM, OR AS REQUIRED BY THE FIRE CODE OFFICIAL, FOR ALL BUILDINGS OR SPACES PROVIDED WITH AN APPROVED AUTOMATIC SPRINKLER SYSTEM. 8.FIRE LANES SHALL BE DESIGNED AND CONSTRUCTED PER TOWN STANDARDS OR AS DIRECTED BY THE FIRE DEPARTMENT. 9.TWO POINTS OF ACCESS SHALL BE MAINTAINED FOR THE PROPERTY AT ALL TIMES. 10.SPEED BUMPS/HUMPS ARE NOT PERMITTED WITHIN A FIRE LANE. 11.FIRE LANES SHALL BE PROVIDED WITHIN 150 FEET OF ALL EXTERIOR WALLS OF ANY BUILDING FOR HOSE LAY REQUIREMENTS. AMENDMENT 503.1.1 12.THE FIRE LANE SHALL BE A MINIMUM OF 24 FEET WIDE. AMENDMENT 503.2.1 13.BUILDINGS MORE THAN 30 FEET IN HEIGHT ARE REQUIRED TO HAVE A MINIMUM OF A 26-FOOT WIDE FIRE LANE IN THE IMMEDIATE VICINITY FOR FIREFIGHTING OPERATIONS OF THE BUILDING. ONE OF THE 26-FOOT WIDE FIRE LANES SHALL BE LOCATED A MINIMUM OF 15 FEET FROM THE BUILDING AND NO MORE THAN 30 FEET. APPENDIX D105 14.THE INSIDE TURNING RADIUS OF THE 24-FOOT FIRE LANE SHALL BE A MINIMUM OF 30 FEET. AMENDMENT 503.2.4 15.THE INSIDE TURNING RADIUS OF THE 26-FOOT FIRE LANE SHALL BE A MINIMUM OF 30 FEET. AMENDMENT 503.2.4 16.DEAD-END FIRE LANES ARE ONLY PERMITTED WITH APPROVED HAMMERHEADS. 17.FIRE HYDRANTS SHALL BE PROVIDED AT THE ENTRANCES AND INTERSECTIONS. AMENDMENT 507.5.1 18.AS PROPERTIES DEVELOP, FIRE HYDRANTS SHALL BE LOCATED AT ALL INTERSECTING STREETS AND THE MAXIMUM SPACING SHALL BE EVERY 300 FEET (300') FOR ALL DEVELOPMENTS, AND FACILITIES OTHER THAN R3. R-3 DEVELOPMENTS SHALL BE EVERY 500 FEET (500'). DISTANCES BETWEEN HYDRANTS SHALL BE MEASURED ALONG THE ROUTE THAT FIRE HOSE IS LAID BY A FIRE APPARATUS FROM HYDRANT-TO-HYDRANT, NOT AS THE "CROW FLIES." AMENDMENT 507.5.1 19.FIRE DEPARTMENT CONNECTION (FDC) FOR THE FIRE SPRINKLER SYSTEM SHALL BE LOCATED WITHIN 50 FEET OF A FIRE HYDRANT AND 50 FEET OF A FIRE LANE. 5” STORZ, 30-DEGREE DOWNWARD TURN WITH LOCKING CAP. AMENDMENT 507.5.1 20.FIRE HYDRANTS SHALL BE LOCATED 2 FOOT (2') TO 6 FOOT (6') BACK FROM THE CURB OR FIRE LANE AND SHALL NOT BE LOCATED IN THE BULB OF A CUL-DE-SAC. AMENDMENT 507.5.1 21.THERE SHALL BE A MINIMUM OF TWO (2) FIRE HYDRANTS SERVING EACH PROPERTY WITHIN THE PRESCRIBED DISTANCES LISTED ABOVE. A MINIMUM OF ONE FIRE HYDRANT SHALL BE LOCATED ON EACH LOT. AMENDMENT 507.5.1 22.A MINIMUM 10-FOOT UNOBSTRUCTED WIDTH SHALL BE PROVIDED AROUND A BUILDING FOR ADEQUATE FIRE DEPARTMENT ACCESS. A CONTINUOUS ROW OF PARKING AND LANDSCAPING SHALL BE CONSIDERED A BARRIER. AMENDMENT 503.1.1 23.THE MAXIMUM DEAD- END CUL-DE-SAC LENGTH SHALL NOT EXCEED SIX HUNDRED FEET (600') AS MEASURED FROM THE CENTERLINE OF THE INTERSECTION STREET TO THE CENTER POINT OF THE RADIUS. AMENDMENT 503.1.5 24.ONE-AND TWO-FAMILY DWELLINGS AUTOMATIC FIRE SYSTEMS. AUTOMATIC FIRE PROTECTION SYSTEMS PER NFPA 13D OR NFPA 13R SHALL BE PROVIDED IN ALL ONE-AND TWO-FAMILY DWELLINGS WITH A CONDITIONED FLOOR AREA OF 5,500 SQUARE FEET (511 M2) OR GREATER, DWELLINGS THREE (3) STORIES OR GREATER, OR DWELLINGS WITH ROOF HEIGHTS EXCEEDING THIRTY-FIVE FEET (35') FROM GRADE. IRC-2015 AMENDMENT R313.2 25.HANDICAPPED PARKING AREAS AND BUILDING ACCESSIBILITY SHALL CONFORM TO THE AMERICANS WITH DISABILITIES ACT (ADA) AND WITH THE REQUIREMENTS OF THE CURRENT, ADOPTED BUILDING CODE. 26.ALL SIGNAGE IS SUBJECT TO BUILDING OFFICIAL APPROVAL. 27.ALL FENCES AND RETAINING WALLS SHALL BE SHOWN ON THE PRELIMINARY SITE PLAN AND ARE SUBJECT TO BUILDING OFFICIAL APPROVAL. 28.ALL EXTERIOR BUILDING MATERIALS ARE SUBJECT TO BUILDING OFFICIAL APPROVAL AND SHALL CONFORM TO THE APPROVED FAÇADE PLAN. 29.SIDEWALKS OF NOT LESS THAN SIX (6) FEET IN WIDTH ALONG THOROUGHFARES AND COLLECTORS AND FIVE (5) FEET IN WIDTH ALONG RESIDENTIAL STREETS AND BARRIER-FREE RAMPS AT ALL CURB CROSSINGS SHALL BE PROVIDED PER TOWN STANDARDS. 30.APPROVAL OF THE SITE PLAN IS NOT FINAL UNTIL ALL ENGINEERING PLANS ARE APPROVED BY THE ENGINEERING SERVICES DEPARTMENT. 31.SITE PLAN APPROVAL IS REQUIRED BEFORE THE GRADING RELEASE. 32.ALL NEW ELECTRICAL LINES SHALL BE INSTALLED AND/OR RELOCATED UNDERGROUND. 33.ALL MECHANICAL EQUIPMENT SHALL BE SCREENED FROM PUBLIC VIEW IN ACCORDANCE WITH THE ZONING ORDINANCE. 34.ALL LANDSCAPE EASEMENTS MUST BE EXCLUSIVE OF ANY OTHER TYPE OF EASEMENT. 35.IMPACT FEES WILL BE ASSESSED IN ACCORDANCE WITH THE LAND USE CLASSIFICATION(S) IDENTIFIED ON THE SITE DATA SUMMARY TABLE; HOWEVER, CHANGES TO THE PROPOSED LAND USE AT THE TIME OF CO AND/OR FINISH-OUT PERMIT MAY RESULT IN ADDITIONAL IMPACT FEES AND/OR PARKING REQUIREMENTS. 36.THE APPROVAL OF A SITE PLAN SHALL BE EFFECTIVE FOR EIGHTEEN (18) MONTHS FROM THE DATE OF APPROVAL BY THE PLANNING & ZONING COMMISSION, AT THE END OF WHICH TIME THE APPLICANT MUST HAVE SUBMITTED AND RECEIVED THE APPROVAL OF ENGINEERING PLANS AND BUILDING PERMITS. IF THE ENGINEERING PLANS AND BUILDING PERMITS ARE NOT APPROVED, THE SITE PLAN APPROVAL, TOGETHER WITH ANY PRELIMINARY SITE PLAN FOR THE PROPERTY IS NULL AND VOID. TOWN SITE PLAN NOTES NOTES 1.ALL DIMENSIONS ARE TO FACE OF CURB UNLESS NOTED OTHERWISE. 2.ALL RADII ARE 3' UNLESS NOTED OTHERWISE. 3.HANDICAP PARKING IS PROVIDED IN ACCORDANCE WITH ADA STANDARDS. 4.ALL 18-FOOT DEEP PARKING STALLS SHALL PROVIDE A 2-FOOT PARKING OVERHANG OFFSET PER THE ORDINANCE 5.HANDICAP MARKING IS PROVIDED IN ACCORDANCE WITH ADA STANDARDS FOR ALL LOTS. 6.FIRE LANES SHALL BE PROVIDED IN ACCORDANCE WITH PROSPER REQUIREMENTS. 7.FIRE HYDRANTS SHALL BE PROVIDED IN ACCORDANCE WITH PROSPER REQUIREMENTS AND WILL BE LOCATED IN A 10'x10' WATER EASEMENT. 8.ALL SCREENING WILL BE PROVIDED IN ACCORDANCE WITH PROSPER REQUIREMENTS. FLOOD NOTE NO 100-YEAR FLOODPLAIN EXISTS ON THE SITE. 24' 1 (STORY) .063:1 6703 SQ. FT. (8.8%) 39Page 122 Item 8. Page 1 of 2 To: Mayor and Town Council From: Chris Landrum, Finance Director Through: Mario Canizares, Town Manager Robert B. Scott, Deputy Town Manager Re: Public Hearing & Adoption of FY 2023-2024 Annual Budget Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Conduct a public hearing to receive public input, consider such input, and consider and act upon an ordinance adopting the Fiscal Year (FY) 2023-2024 Annual Operating and Capital Project Funds budgets and five-year Capital Improvement Program for the fiscal year beginning October 1, 2023, and ending September 30, 2024. Description of Agenda Item: According to Local Government Code Chapter 102 and the Town Charter, the Town must hold a Public Hearing on the proposed budget. Approval of this item will appropriate funds for the FY 2023-2024 Operating and Capital Project Fund budgets and adopt the five-year Capital Improvement Program plan. Prior to this meeting, the Town published required notices, held a public hearing that included staff presentations about the budget, 2023 tax rate, and gave interested citizens the opportunity to ask questions and provide input at a Budget Town Hall Meeting. Subsection C of Section 102.007 of the Local Government Code requires that adoption of a budget raising more revenue from property taxes than in the previous year requires a separate vote of the governing body to ratify the property tax increase reflected in the budget. A vote under this subsection is in addition to, and separate from, the vote to adopt the budget or a vote to set the tax rate as required by Chapter 26 of the Tax Code. Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Ordinance 2. Ordinance Exhibit A – FY 2023-2024 Proposed Budget Summary FINANCE Page 123 Item 9. Page 2 of 2 Town Staff Recommendation: Town Staff recommends that the Town Council approve an ordinance adopting the Fiscal Year 2023-2024 Annual Budget and Capital Improvement Program for the fiscal year beginning October 1, 2023, and ending September 30, 2024, as proposed. This item requires a roll call/record vote. Proposed Motion: I move to approve an ordinance adopting the Fiscal Year 2023-2024 Annual Budget and Capital Improvement Program for the fiscal year beginning October 1, 2023, and ending September 30, 2024, as proposed. Page 124 Item 9. TOWN OF PROSPER, TEXAS ORDINANCE NO. 2023- AN ORDINANCE OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ADOPTING THE FISCAL YEAR 2023-2024 ANNUAL BUDGET AND CAPITAL PROJECT FUND BUDGETS FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2023, AND ENDING SEPTEMBER 30, 2024, FOR THE TOWN OF PROSPER, TEXAS; PROVIDING A SEVERABILITY CLAUSE; PROVIDING FOR A REPEALER CLAUSE; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the Annual Budget for the Town of Prosper, Texas, was prepared by the Town Manager and presented to the Town Council on August 8, 2023, in accordance with the Town Charter of the Town of Prosper, Texas; and WHEREAS, the proposed annual budget document was posted on the Town's Internet website and also made available for public review; and WHEREAS, a Notice of a Public Hearing concerning the proposed Annual Town and Capital Project Fund Budget was published as required by state law and said Public Hearing thereon was held by the Town Council on September 12, 2023; and WHEREAS, following the Public Hearing, and upon careful review of the proposed Fiscal Year 2023-2024 Annual and Capital Project Fund Budget, it is deemed to be in the best financial interests of the citizens of the Town of Prosper, Texas, that the Town Council approve said budget; and WHEREAS, in conjunction with the adoption of the Annual Town Budget, the Town also wishes to adopt its recommended Fiscal Year 2023-2024 five-year Capital Improvement Program as required by Town Charter. NOW, THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 The above findings are hereby found to be true and correct and are incorporated herein in their entirety. SECTION 2 The official budget for the Town of Prosper, Texas, for the fiscal year beginning October 1, 2023, and ending September 30, 2024, is hereby adopted by the Town Council of the Town of Prosper, Texas, and the Town Secretary is directed to keep and maintain a copy of such official budget on file in the office of the Town Secretary and, upon request, make same available to the citizens and the general public. SECTION 3 The sums specified in Exhibit A are hereby appropriated from the respective funds for the payment of expenditures on behalf of the Town government as established in the approved budget document. Page 125 Item 9. Ordinance No. 2023-xx, Page 2 SECTION 4 Should any part, portion, section, or part of a section of this Ordinance be declared invalid, or inoperative, or void for any reason by a court of competent jurisdiction, such decision, opinion, or judgment shall in no way affect the remaining provisions, parts, sections, or parts of sections of this Ordinance, which provisions shall be, remain, and continue to be in full force and effect. SECTION 5 All ordinances and appropriations for which provisions have heretofore been made are hereby expressly repealed if in conflict with the provisions of this Ordinance. SECTION 6 In accordance with state law and the Town’s Code of Ordinances, proper Notice of Public Hearing was provided for said Ordinance to be considered and passed, and this Ordinance shall take effect and be in full force and effect from and after its final passage. SECTION 7 Specific authority is hereby given to the Town Manager to transfer appropriations budgeted from one account classification or activity to another within any individual department or activity. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, BY A VOTE OF ___ TO ___ON THIS THE 12TH DAY OF SEPTEMBER, 2023. APPROVED: ________________________________ David F. Bristol, Mayor ATTEST: _____________________________________ Michelle Lewis Sirianni, Town Secretary APPROVED AS TO FORM AND LEGALITY: _____________________________________ Terrence S. Welch, Town Attorney Page 126 Item 9. Ordinance No. 2023-xx, Page 3 EXHIBIT A Page 127 Item 9. AMENDED BUDGET2022-2023PRELIMINARY 2023-2024 CHANGESFINAL PROPOSED 2023-2024GENERAL FUND Administration 10,070,907$ 9,800,919$ -$ 9,800,919$ Police Services 7,746,233 9,640,650 (57,122) 9,583,528 Fire Services 10,025,804 10,562,449 - 10,562,449 Public Works 4,789,302 4,727,062 - 4,727,062 Community Services 7,287,646 7,355,779 - 7,355,779 Development Services 4,468,057 4,139,855 - 4,139,855 Engineering 2,903,192 2,684,047 - 2,684,047 Transfer to Capital Dedicated 8,780,485 - - - 56,071,626$ 48,910,761$ (57,122)$ 48,853,639$ WATER/SEWER FUNDAdministration 1,758,027$ 1,827,915$ -$ 1,827,915$ Debt Service 4,354,465 4,610,464 - 4,610,464Water Purchases 9,605,940 12,704,415 - 12,704,415Sewer Management 3,854,505 4,560,895 - 4,560,895Public Works 12,061,423 8,226,657 1,183,706 9,410,363 Transfers Out 2,877,339 6,708,706 1,362,944 8,071,650 New Capital Projects - 88,772,475 (11,708,420) 77,064,055 34,511,699$ 127,411,527$ (9,161,770)$ 118,249,757$ DEBT SERVICE (I&S)12,911,163$ 14,952,436$ -$ 14,952,436$ TIRZ # 13,096,668 4,622,209 - 4,622,209TIRZ # 240,673 49,178 - 49,178CRIME CONTROL AND PREVENTION SPECIAL PURPOSE DISTRICT 2,713,065 3,019,990 148,574 3,168,564FIRE CONTROL, PREVENTION, AND EMERGENCY MEDICAL SERVICES SPECIAL PURPOSE DISTRICT 2,685,042 2,947,428 81,795 3,029,223PARK DEDICATION/IMPROVEMENT100,000 1,313,800 400,000 1,713,800IMPACT FEES22,788,614 10,897,145 - 10,897,145SPECIAL REVENUE275,404 6,439,038 - 6,439,038STORM DRAINAGE847,803 797,550 195,745 993,295 SOLID WASTE3,908,200 4,964,441 30,000 4,994,441 VERF1,407,618 1,105,220 16,350 1,121,570 HEALTH INSURANCE TRUST4,940,815 5,118,939 - 5,118,939 NEW GOVERNMENTAL CAPITAL PROJECTS FUND- 114,037,464 (36,643,472) 77,393,992 55,715,065$ 170,264,838$ (35,771,008)$ 134,493,830$ 146,298,390$ 346,587,126$ (44,989,900)$ 301,597,226$ Capital Projects are budgeted on a project basis with appropriations remaining valid for the life of the project.Funds encumbered for the VERF will also be re-apportioned for FY 2023-2024.GRAND TOTALEXHIBIT AGeneral Fund TotalWater/Sewer TotalOther Funds TotalOrd 23-xx, Page 3Page 128Item 9. Page 1 of 1 To: Mayor and Town Council From: Chris Landrum, Finance Director Through: Mario Canizares, Town Manager Robert B. Scott, Deputy Town Manager Re: Public Hearing & Adoption FY 2023-2024 Tax Rate Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Conduct a public hearing to consider and act upon an ordinance adopting a tax rate of $0.51 per $100 valuation for fiscal year 2023-2024. Description of Agenda Item: This item is to adopt the 2023 tax rate to generate sufficient revenues as required in the Adopted FY 2023-2024 Budget. The attached ordinance sets the 2023 ad valorem tax rate at $0.51 cents per $100 assessed valuation, to be distributed as follows: $0.332742 for Maintenance and Operations $0.177258 for Debt Service Totaling $0.510000 Total Tax Rate Legal Obligations and Review: Terrence Welch of Brown & Hofmeister, L.L.P., has approved the attached documents as to form and legality. Attached Documents: 1. Ordinance Town Staff Recommendation: This item requires a record vote, and at least 60 percent of the members of the governing body must vote in favor of the ordinance. The tax code is specific in the form of making a motion to set the tax rate. Town staff recommends that the Town Council approve an ordinance adopting the 2023 tax rate using the required language below. Proposed Motion: Please make your motion using this required language: “I move that the property tax rate be increased by the adoption of a tax rate of $0.51, which is effectively a 13.8 percent increase in the tax rate.” FINANCE Page 129 Item 10. TOWN OF PROSPER, TEXAS ORDINANCE NO. 2023-XX AN ORDINANCE OF THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, ADOPTING THE TOWN OF PROSPER 2023 PROPERTY TAX RATE; LEVYING TAXES FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2023, AND ENDING SEPTEMBER 30, 2024, AT THE RATE OF $0.51 PER ONE HUNDRED DOLLARS ($100.00) ASSESSED VALUE ON ALL TAXABLE PROPERTY WITHIN THE CORPORATE LIMITS OF THE TOWN OF PROSPER, TEXAS, IN ACCORDANCE WITH EXISTING STATUTORY REQUIREMENTS; PROVIDING A SEVERABILITY CLAUSE; PROVIDING FOR A REPEALER CLAUSE; PROVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF ON THE TOWN’S HOME PAGE OF ITS WEBSITE; AND PROVIDING FOR AN EFFECTIVE DATE. WHEREAS, the Town Council of the Town of Prosper, Texas (hereinafter referred to as the “Town”), hereby finds that the tax for the fiscal year beginning October 1, 2023, and ending September 30, 2024, hereinafter levied for current expenditures of the Town and the general improvements of the Town and its property, must be levied to provide revenue requirements for the budget for the ensuing year; and WHEREAS, the Town Council has approved, by separate ordinance to be adopted on the 12th day of September, 2023, the budget for the fiscal year beginning October 1, 2023, and ending September 30, 2024; and WHEREAS, all statutory and constitutional requirements concerning the levying and assessing of ad valorem taxes have been complied with by the Town. NOW, THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, THAT: SECTION 1 The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2 The Town Council of the Town of Prosper, Texas, does hereby adopt and levy the following tax rate of $0.5100 per $100 assessed valuation for the Town for tax year 2023 as follows: $0.332742 for the purpose of maintenance and operation; and $0.177258 for payment of principal and interest on debt service. SECTION 3 The rate adopted is higher than the no-new-revenue rate and lower than the voter- approval rate as calculated according to the Truth in Taxation provisions of the Texas Tax Code, as amended, and the total levy for maintenance and operations exceeds last year’s levy for same. Page 130 Item 10. Ordinance No. 2023-XX, Page 2 THIS TAX RATE WILL RAISE MORE TAXES FOR MAINTENANCE AND OPERATIONS THAN LAST YEAR’S TAX RATE. THE TAX RATE WILL EFFECTIVELY BE RAISED BY 9.19 PERCENT AND WILL RAISE TAXES FOR MAINTENANCE AND OPERATIONS ON A $100,000 HOME BY APPROXIMATELY $2.91. The Town’s website shall reflect the foregoing statements, pursuant to applicable provisions of the Texas Tax Code, as amended. SECTION 4 The Tax Assessor-Collectors for Collin County and Denton County are hereby authorized to assess and collect the taxes of the Town of Prosper in accordance with this Ordinance. The Town shall have all rights and remedies provided by the law for the enforcement of the collection of taxes levied under this ordinance. SECTION 5 All provisions of any ordinance in conflict with this Ordinance are hereby repealed; however, such repeal shall not abate any pending prosecution for violation of the repealed Ordinance, nor shall the repeal prevent prosecution from being commenced for any violation if occurring prior to the repeal of the Ordinance. Any remaining portions of conflicting ordinances shall remain in full force and effect. SECTION 6 Should any section, subsection, sentence, clause or phrase of this Ordinance be declared unconstitutional or invalid by a court of competent jurisdiction, it is expressly provided that any and all remaining portions of this Ordinance shall remain in full force and effect. The Town hereby declares that it would have passed this Ordinance, and each section, subsection, sentence, clause, or phrase thereof irrespective of the fact that any one or more sections, subsections, sentences, clauses, or phrases be declared unconstitutional or invalid. SECTION 7 This Ordinance shall become effective from and after its adoption and publication, as required by law. DULY PASSED AND APPROVED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, BY A VOTE OF ___ TO ___, ON THIS THE 12TH DAY OF SEPTEMBER, 2023. APPROVED: ___________________________________ David F. Bristol, Mayor Page 131 Item 10. Ordinance No. 2023-XX, Page 3 ATTEST: ___________________________________ Michelle Lewis Sirianni, Town Secretary APPROVED AS TO FORM AND LEGALITY: ___________________________________ Terrence S. Welch, Town Attorney Page 132 Item 10. Ordinance No. 2023-XX, Page 4 Page 133 Item 10. Page 1 of 1 To: Mayor and Town Council From: Chris Landrum, Finance Director Through: Mario Canizares, Town Manager Robert B. Scott, Deputy Town Manager Re: Ratification of FY 2023-2024 Tax Rate Town Council Meeting – September 12, 2023 Strategic Visioning Priority: 4. Provide Excellent Municipal Services Agenda Item: Ratifying the property tax increase in the budget for fiscal year (FY) 2023-2024. Description of Agenda Item: According to Texas Local Government Code Section 102.007, "Adoption of a budget that will require raising more revenue from property taxes than in the previous year requires a separate vote of the governing body to ratify the property tax increase reflected in the budget. A vote under this subsection is in addition to and separate from the vote to adopt the budget or a vote to set the tax rate required by Chapter 26, Tax Code, or other law." This budget will raise more revenue from property taxes than last year's budget by an amount of $7,378,985, which is a 21.62 percent increase from last year's budget. The property tax revenue to be raised from new property added to the tax roll this year is $4,531,952. Budget Impact: This action is a required step in adoption of the Budget and Tax Rate. Town Staff Recommendation: Town Staff recommends making a motion to ratify the property tax increase in the budget for fiscal year (FY) 2023-2024. Proposed Motion: I move to ratify the property tax increase in the budget for fiscal year (FY) 2023-2024. FINANCE Page 134 Item 11.