The URL can be used to link to this page

Budget - FY 2008-2009t P TOWN ER. ORDINANCE NO. 08 -079 AN ORDINANCE OF THE TOWN OF PROSPER, TEXAS ADOPTING A BUDGET AND APPROPRIATING RESOURCES FOR THE FISCAL YEAR BEGINNING OCTOBER 1, 2008 AND ENDING SEPTEMBER 30, 2009, IN ACCORDANCE WITH EXISTING STATUTORY REQUIREMENTS; PROVIDING FOR REPEALING, SAVINGS AND SEVERABILITY CLAUSES; PROVIDING FOR AN EFFECTIVE DATE OF THIS ORDINANCE; AND PROVIDING FOR THE PUBLICATION OF THE CAPTION HEREOF. WHEREAS, pursuant to the laws of the State of Texas, the Town Manager of the Town of Prosper has submitted to the Mayor and Town Council a proposed budget of the revenues and expenditures /expenses for conducting the affairs of Prosper and providing a complete financial plan for Fiscal Year 2008/2009: and has filed the same with the Town Secretary (the "budget "): and WHEREAS, two public hearings — the first on August 26, 2008 and the second on September 9, 2008 -were held by the Town Council at which time said budget was fully considered, and interested taxpayers were given the opportunity to be heard by the Town Council; and WHEREAS, the Town Council has studied the budget and listened to the comments of the taxpayers at the public hearing and has investigated and determined that adoption of the budget is in the best interest of the Town; and WHEREAS, the Town Council finds that all legal notices, hearings, procedures and publishing requirements for the adoption of the budget have been performed or completed in the manner and form set forth by law. NOW THEREFORE, BE IT ORDAINED BY THE TOWN COUNCIL OF THE TOWN OF PROSPER, TEXAS, COLLIN COUNTY, TEXAS: SECTION 1: Findings Incorporated. The findings set forth above are incorporated into the body of this Ordinance as if fully set forth herein. SECTION 2: Adoption of Budget. We the Mayor and Town Council for the Town of Prosper do hereby approve, ratify, and adopt for fiscal year beginning October 1, 2008 and ending September 30, 2009 the Budget as filed with the Town Secretary. SECTION 3: Appropriation of Funds. The sums below are hereby appropriated from the respective funds for the payment of expenditures on behalf of Prosper as established in the approved budget: General Fund $ 6,322,298 Water & Sewer Fund $ 3,895,346 Interest & Sinking Fund $ 2,059,959 Page 1 of 2 SECTION 4: Authority of Town Manager. 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; and, to transfer appropriations from designated appropriations to any individual department or activity. SECTION 5: Savings/ Repealing Clause. All provisions of any ordinance in conflict with this Ordinance are hereby repealed; but 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: Severability. 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. Prosper 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: Effective Date. 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 ON THIS 16`" DAY OF SEPTEMBER, 2008 AT A MEETING WHICH WAS HELD IN STRICT ACCORDANCE WITH THE TEXAS OPEN MEETING ACT.. r CHARLES NISWANGER, Mayor ATTEST TO: TTHEW D. DENTON, TRMC Town Secretary Date of Publication 571 X07- i 16 2 5"j 2 400 6) O F P O:• % � e � i `. o° X10 e TEXAS ®�`�� Dallas Morning News — Collrnk%tltf twgw Page 2 of 2 OWN OF PISPER GENERALFUND REVENUES EXPENDITURES Town of Prosper Fiscal Year 2008 - 2009 Adopted Budget CONSOLIDATED STATEMENT A B C D 2,116,409 EXPENDITURES Projected Adopted Actual Budgeted Year End Budget 2006 -2007 2007 -2008 2007 -2008 2008 -2009 4,249,095 5,357,419 5,510,922 6,471,362 3,641,195 5,357,419 5,396,040 6,322,297 WATER / SEWER FUND REVENUES 5,161,710 3,867,000 3,961,930 3,895,993 EXPENDITURES 3,888,951 3,851,914 3,801,689 3,895,346 NET REVENUES OVER (UNDER) EXPENDITURES 1 1,272,759 15,086 160,241 647 DEBT SERVICE FUND REVENUES 1,967,566 1,965,930 2,059,520 2,116,409 EXPENDITURES 1,700,753 1,866,948 2,028,840 2,059,959 NET REVENUES OVER (UNDER) EXPENDITURES1 266,813 1 98,982 1 30,680 1 56,450 CAPITAL PROJECTS FUND REVENUES 1,255,386 206,100 524,440 220,000 EXPENDITURES 8,106,116 8,404,244 5,711,674 3,137,285 NET REVENUES OVER (UNDER) EXPENDITURES 1 (6,850,730) (8,198,144) (5,187,234) (2,917,285) PARKSFUND REVENUES 697,348 614,000 457,004 537,000 EXPENDITURES 32,770 35,000 - - NET REVENUES OVER (UNDER) EXPENDITURES 664,579 579,000 457,004 537,000 IMPACT FEES FUND REVENUES 1,961,462 2,223,500 1,653,973 856,000 EXPENDITURES 826,332 449,200 228,437 - NET REVENUES OVER (UNDER) EXPENDITURES 1 1,135,131 1,774,-33-5771 -,425,537 1 856,000 ECONOMIC DEVELOPMENT CORP. REVENUES 463,147 440,000 470,548 396,667 EXPENDITURES 176,269 319,066 383,990 336,815 NET REVENUES OVER (UNDER) EXPENDITURES1 286,878 1 20,934 1 86,558 1 59,852 INTERNAL SERVICE FUND REVENUES - - 4,050 33,480 EXPENDITURES - - 4,050 33,480 NET REVENUES OVER (UNDER) EXPENDITURES - - - I - i P T SPER. Town of Prosper FY 2008 - 2009 Town Budget General Fund Summary Fund Balance / Reserves GENERALFUND Adopted Account FY 06/07 FY 07/08 FY 07/08 FY 08 / 09 Description Actual Budgeted Projected Budget GENERALFUND REVENUES Current: Taxes: General Government $ 717,828 $ 912,461 Property $ 1,112,082 $ 2,179,404 $ 2,263,000 $ 2,884,060 Sales $ 1,207,541 $ 1,202,000 $ 1,102,900 $ 1,103,045 Franchise $ 304,284 $ 269,065 $ 285,232 $ 299,494 Licenses, fees, and permits $ 1,076,523 $ 1,144,950 $ 1,145,334 $ 1,072,286 Charges for services $ 155,717 $ 148,820 $ 163,200 $ 159,700 Grants $ - $ 184,000 $ 150,800 $ 341,550 Investment Income $ 134,275 $ 62,430 $ 95,200 $ 100,200 Fines, warrants and seizures $ 131,313 $ 120,000 $ 191,000 $ 205,375 Contributions $ - $ - $ - $ - Miscellaneous $ 78,910 $ 46,750 $ 114,256 $ 106,150 Total Revenues $ 4,200,645 $ 5,357,419 $ 5,510,922 $ 6,271,860 EXPENDITURES Current: General Government $ 717,828 $ 912,461 $ 891,896 $ 895,438 Police Department $ 819,754 $ 1,196,475 $ 1,157,941 $ 1,279,044 Court $ 124,820 $ - $ - $ 206,716 Fire Department $ 997,050 $ 1,367,129 $ 1,387,190 $ 2,023,059 Streets $ 177,028 $ 285,059 $ 286,465 $ 298,482 Parks and Recreation $ 59,699 $ 200,442 $ 184,351 $ 260,483 Inspections $ 418,254 $ 562,771 $ 553,378 $ 613,774 Engineering $ 1,494 $ 130,716 $ 176,926 $ 175,926 Planning $ 189,059 $ 288,288 $ 373,883 $ 385,540 Capital Outlay $ 85,398 $ 414,078 $ 384,010 $ 155,620 Debt Service: Principal $ 49,073 $ - $ - $ - Interest & fiscal charges $ 1,738 $ - $ - TotalExpenses $ 3,641,195 $ 5,357,419 $ 5,396,040 $ 6,294,082 Excess / (Deficit) $ 559,451 $ - $ 114,882 $ (22,222) OTHER FINANCING SOURCES(USES) Capital Leases $ Transfers (out) $ Transfers In Transfer Out for Debt Service $ Total Other Financing Sources (uses) $ Net change in fund balances Fund Balance, beginning (as stated) Fund Balance, ending Balance of Unrestricted Funds 25% Reserve 10% Contingency Amount over / (under) Reserve 48,450 $ 48,450 $ $ $ 28,215 $ 199,502 $ $ 171,287 $ 607,901 $ - $ 114,882 $ 149,065 $ 2,485,265 $ 3,093,166 $ 3,093,166 $ 3,208,048 $ 3,093,166 $ 3,093,166 $ 3,208,048 $ 3,357,113 $ 3,093,166 $ 3,093,166 $ 3,208,048 $ 3,357,113 $ 910,299 $ 1,339,355 $ 1,349,010 $ 1,573,521 $ 364,120 $ 535,742 $ 539,604 $ 629,408 $ 1,818,748 $ 1,218,070 $ 1,319,434 $ 1,154,184 2 P riSP ER. Town of Prosper FY 2008 - 2009 Town Budget Public Works Fund Summary Net Assets / Reserves WATER / SEWER FUND Adopted Account FY 06/07 FY 07/08 I FY 07/08 I FY 08109 I Description Actual Budgeted Projected Budget WATER / SEWER FUND Personnel services OPERATING REVENUES $ 526,401 $ 525,505 $ 568,729 Materials and supplies $ 353,663 Water and Sewer charges $ 2,065,819 $ 2,961,480 $ 2,386,000 $ 3,091,500 Sanitation charges $ 358,543 $ 348,000 $ 390,000 $ 424,900 Water and Sewer connections $ 426,659 $ 400,000 $ 400,000 $ 200,000 Service initiation fees $ 592,963 $ 25,520 $ 668,980 $ 14,000 Miscellaneous $ 33,423 $ 51,000 $ 31,950 $ 72,593 Total Operating Revenues $ 3,477,407 $ 3,786,000 $ 3,876,930 $ 3,802,993 NON - OPERATING REVENUES $ (280,028) $ 15,086 $ 160,241 $ 204,874 TRANSFERS Interest Income $ 131,516 $ 81,000 $ 85,000 $ 93,000 TRANSFERSIN Operating transfers $ - $ - $ - $ - Transfers in from other funds - $ - $ - $ - Total transfers in $ - $ - $ - Total Revenues $ 3,608,923 $ 3,867,000 $ 3,961,930 $ 3,895,993 OPERATING EXPENSES Personnel services $ 481,840 $ 526,401 $ 525,505 $ 568,729 Materials and supplies $ 353,663 $ 838,563 $ 1,870,914 $ 659,285 Contractual services $ 2,096,047 $ 2,102,290 $ 1,088,270 $ 2,395,445 Amortization $ 16,547 $ - $ 17,000 Depreciation $ 284,291 $ 300,000 $ 300,000 $ - Total Operating Expenses $ 3,232,388 $ 3,767,254 $ 3,801,689 $ 3,623,459 NON - OPERATING EXPENSES Interest expense and fiscal charges $ 656,563 $ 84,660 $ - $ 67,660 Net Income (loss) before operating transfers $ (280,028) $ 15,086 $ 160,241 $ 204,874 TRANSFERS Transfers in (out) for debt service $ 873,395 $ - $ - $ - Transfers out for Internal Service Fund $ 4,725 Transfers out for General Fund $ 199,502 Transfers in (out) for capital assets $ 679,392 $ - $ - $ - Total transfers $ 1,552,787 $ - $ - $ (204,227) Change in Net Assets $ 1,272,759 $ 15,086 $ 160,241 $ 647 Net Assets, beginning (as stated) $ 6,617,771 $ 7,890,530 $ 7,890,530 $ 8,050,771 Net Assets, ending $ 7,890,530 $ 7,905,616 $ 8,050,771 $ 8,051,417 16% Reserve $ 517,182 $ 602,761 $ 608,270 $ 579,753 3 WN O F priOSPER Town of Prosper Fiscal Year 2008 - 2009 Debt Service Summary DEBT SERVICE FUND REVENUES Taxes: Property $ 1,875,901 $ 1,940,430 $ 2,032,120 $ 2,087,409 Investment Income (Interest) $ 91,665 $ 25,500 $ 27,400 $ 29,000 Total Revenues $ 1,967,566 $ 1,965,930 $ 2,059,520 $ 2,116,409 EXPENDITURES Debt Service Principal $ 336,553 $ 805,192 Adopted Account FY 06/07 I FY 07/08 I FY 07 / 08 I FY 08 / 09 I Description Actual Budgeted Projected Budget DEBT SERVICE FUND REVENUES Taxes: Property $ 1,875,901 $ 1,940,430 $ 2,032,120 $ 2,087,409 Investment Income (Interest) $ 91,665 $ 25,500 $ 27,400 $ 29,000 Total Revenues $ 1,967,566 $ 1,965,930 $ 2,059,520 $ 2,116,409 EXPENDITURES Debt Service Principal $ 336,553 $ 805,192 $ 383,325 $ 2,055,959 Interest $ 489,858 $ 1,061,756 $ 475,244 $ - Total Expenditures $ 826,411 $ 1,866,948 $ 858,569 $ 2,055,959 Excess of revenues over expenditures $ 1,141,155 $ 98,982 $ 1,200,951 $ 60,450 OTHER FINANCING SOURCES (USES) Administrative Fees $ (947) $ Transfers out for debt service $ - $ Transfers out for debt service $ (873,395) $ Total other financing sources $ (874,342) $ Net change in fund balances Fund Balance, beginning (as stated) Fund Balance, ending $ 266,813 $ $ 314,558 $ - $ (3.779) $ - $ (157,880) $ - $ (1,008,612) $ - $ (1,170,271) $ 98,982 $ 30,680 $ 581,371 $ 581,371 $ (4,000) (4,000) 56,450 612,051 $ 581,371 $ 680,353 $ 612,051 $ 668,501 4 8/14/07 Rev P TOWN ER. Town of Prosper Adopted Budget Fiscal Year, 2008 -2009 Capital Projects Fund Balance / Reserves CAPITAL PROJECTS $ - $ - $ Adopted Account FY 06/07 FY 07/08 FY 07 / 08 FY 08 / 09 I Description Actual Budgeted Projected Budget CAPITAL PROJECTS $ - $ - $ REVENUES $ - $ - $ - $ - Proceeds From Bond Issuance $ - $ - $ - $ - Miscellaneous $ - $ - $ - $ - Grants $ 500,000 $ - Investment Income (Interest) $ 755,386 $ 206,100 $ 366,560 $ 220,000 $ (8,198,144) $ (5,345,114) $ (2,917,285) OTHER FINANCING SOURCES (USES) Total Revenues $ 1,255,386 $ 206,100 $ 366,560 $ 220,000 EXPENDITURES Current: $ - $ - $ General Government $ - $ - $ - $ - Capital Outlay $ 8,106,116 $ 8,404,244 $ 5,711,674 $ 3,137,285 - $ - $ - $ - Total Expenditures $ 8,106,116 $ 8,404,244 $ 5,71 1,674 $ 3,137,295 157,880 $ - Transfers Out $ Excess of revenues over expenditures $ (6,850,730) $ (8,198,144) $ (5,345,114) $ (2,917,285) OTHER FINANCING SOURCES (USES) Bonds Issue $ - $ - $ - $ - Bond issuance cost $ - $ - $ - $ - Due From Water Sewer $ - $ - $ - $ - Transfers In - $ - $ - $ 157,880 $ - Transfers Out $ - $ - $ - $ - Total other financing sources $ - $ - $ 157,880 $ Net change in fund balances $ (6,850,730) $ (8,198,144) $ (5,187,234) $ (2,917,285) Fund Balance, beginning $ 17,807,856 $ 10,957,126 $ 10,957,126 $ 5,769,892 Fund Balance, ending $ 10,957,126 $ 2,758,982 $ 5,769,892 $ 2,852,607 5 I �� P TOWN E R. Town of Prosper Adopted Departmental Budget Fiscal Year, 2008 -2009 Park Summary Fund Balance PARK FUND Adopted Account FY 06/07 FY 07/08 FY 07 / 08 FY 08 / 09 Description Actual Budgeted Projected Budget PARK FUND REVENUES Park Improvement Fees $ 388,000 $ 352,000 $ 208,897 $ 400,000 Park Dedication Fees $ 292,188 $ 255,000 $ 209,210 $ 100,000 Park Improvement- Interest $ 7,912 $ 2,500 $ 20,202 $ 19,000 Park Dedication - Interest $ 9,248 $ 4,500 $ 18,695 $ 18,000 Total Revenues $ 697,348 $ 614,000 $ 457,004 $ 537,000 EXPENDITURES General government -Parks Improv $ 31,697 $ 35,000 $ - $ - General government -Parks Dedication $ 1,073 $ - $ - $ - Total Expenses $ 32,770 $ 35,000 $ - $ - Excess / (Deficit) $ 664,579 $ 579,000 $ 457,004 $ 537,000 OTHER FINANCING SOURCES (USES) Total Other Financing Sources (uses) $ - Net change in fund balances $ 664,579 $ 579,000 $ 457,004 $ 537,000 Fund Balance, beginning (as stated) $ 416,498 $ 1,081,077 $ 1,081,077 $ 1,538,081 Fund Balance, ending $ 1,081,077 $ 1,660,077 $ 1,538,081 $ 2,075,081 0 P TOWN ER. Town of Prosper Adopted Departmental Budget Fiscal Year, 2008 -2009 Impact Fees Summary Account Description FY 06/07 I Actual FY 07/08 I Budgeted FY 07/08 I Projected Adopted FY 08 / 09 I Budget - IMPACT FEES $ 17,695 $ - $ - $ - General Government -water $ REVENUES $ - $ - $ - General Government -sewer $ 11,529 $ Impact Fees 34,036 $ - General Government - thoroughfare $ - $ - $ - Water $ 613,716 $ 648,750 $ 619,130 $ 225,000 Sewer $ 542,123 $ 494,250 $ 459,092 $ 175,000 Thoroughfare $ 697,259 $ 1,014,500 $ 485,183 $ 375,000 Investment income $ 108,365 $ 66,000 $ 90,569 $ 81,000 Total Revenues $ 1,961,462 $ 2,223,500 $ 1,653,973 $ 856,000 EXPENDITURES General Government $ 17,695 $ - $ - $ - General Government -water $ 17,695 $ - $ - $ - General Government -sewer $ 11,529 $ - $ 34,036 $ - General Government - thoroughfare $ - $ - $ - $ - CapitalOutlay -water $ 126,974 $ 329,200 $ 90,958 $ - Capital Outlay-sewer $ 517,028 $ - $ 68,989 $ - CapitalOutlay- thoroughfare $ 135,411 $ 120,000 $ 34,454 $ - Total Expenses $ 826,332 $ 449,200 $ 228,437 $ - Excess / (Deficit) $ 1,135,131 $ 1,774,300 $ 1,425,537 $ 856,000 OTHER FINANCING SOURCES (USES) Transfers In $ Transfers Out Total Other Financing Sources (uses) $ Net change in fund balances $ 1,135,131 $ 1,774,300 $ 1,425,537 $ 856,000 Fund Balance, beginning (as stated) $ 1,401,989 $ 2,537,120 $ 2,537,120 $ 3,962,656 Fund Balance, ending $ 2,537,120 $ 4,311,420 $ 3,962,656 $ 4,818,656 7 I�SPER P Town of Prosper FY 2008 - 2009 Town Budget Economic Development Corporation Net Assets / Reserves ECONOMIC DEVELOPMENT Adopted Account FY 06107 FY 07/08 I FY 07 / 08 FY 08 / 09 I Description Actual Budgetedi Projected Budget ECONOMIC DEVELOPMENT OPERATING REVENUES Sales Tax $ 401,647 $ 390,000 $ 427,849 $ 366,667 Interest $ 61,367 $ 50,000 $ 42,699 $ 30,000 Other Income $ 133 $ - $ - $ - Total Operating Revenues $ 463,147 $ 440,000 $ 470,548 $ 396,667 OPERATING EXPENSES Total Operating Expenses $ 176,269 $ 319,066 $ 383,990 $ 336,815 Total Expenses $ 176,269 $ 319,066 $ 383,990 $ 336,815 INCOME (LOSS) $ 286,878 $ 120,934 $ 86,558 $ 59,852 Change in Net Assets $ 286,878 $ 120,934 $ 86,558 $ 59,852 Fund Balance, beginning (as stated) $ 1,121,239 $ 1,408,117 $ 1,408,117 $ 1,494,675 Fund Balance, ending $ 1,408,117 $ 1,529,051 $ 1,494,675 $ 1,554,527 E-3 1SPER OWN OF P Town of Prosper Adopted Departmental Budget Fiscal Year, 2008 -2009 Internal Service Fund Internal Service Fund REVENUES Transfers In Interest Income EXPENDITURES Transfers Out Operating Expenses 4,050 $ 33,480 Total Revenues $ - $ - $ 4,050 $ 33,480 $ 4,050 $ 33,480 Total Expenses $ - $ - $ 4,050 $ 33,480 Excess / (Deficit) $ - $ - $ - $ - Net change in fund balances $ - $ - $ Adopted Account FY 06/07 FY 07/08 FY 07/08 I FY 08 / 09 I Description Actual Budgeted Projected Budget Internal Service Fund REVENUES Transfers In Interest Income EXPENDITURES Transfers Out Operating Expenses 4,050 $ 33,480 Total Revenues $ - $ - $ 4,050 $ 33,480 $ 4,050 $ 33,480 Total Expenses $ - $ - $ 4,050 $ 33,480 Excess / (Deficit) $ - $ - $ - $ - Net change in fund balances $ - $ - $ - $ - Fund Balance, beginning (as stated) $ - $ - $ - $ - Fund Balance, ending $ - $ - $ - $ - 9 Due to the passage of H. B. 3196 during the 80mLegislattve Session, the following statement must be Included as the cover page for any budget document "This budget will raise more total property taxes than last year's budget by $928,567 or 23.4 %, and of that amount $588,424 is tax revenue to be raised from new property added to the tax roll this year.,, p T S PER August 8, 2008 Honorable Mayor and Town Council Citizens of Prosper Mayor, Town Council, Citizens, I am pleased to present to you the Proposed 2008.2009 Town of Prosper Annual Operations and Maintenance Budget for your consideration. This document details the comprehensive strategic plan by which the Town of Prosper strives to enhance the community's quality of life. For the first time, the Prosper Town Council has adopted a Strategic Vision and Work Plan that was used in guiding the development of this proposed budget. The most important element of their effort resulted in the following Purpose Statement: TOWN OF PROSPER PURPOSE STATEMENT "Prosper is a place where everyone matters." In the coming year, a corresponding Performance Plan will be adopted that will be used to implement the Council's Strategic Vision and Work Plan. The Work Plan in conjunction with Performance Measures are important tools that will be used to define the level and quality of services to be provided to the citizens of Prosper. By establishing standards, the Council, citizens and team members of the Town will have clear expectations before them, helping everyone understand better the operations of the Town and the value of what is being provided. BUDGET OVERVIEW The Town of Prosper 2008 -2009 Proposed Budget represents a continuation of most Town services at the same or similar levels, with added focus on improving public safety and community services. Understanding that the Town's growth and revenues are directly related to uncertain economic conditions in various markets, the budget is being proposed after prudent examination and with conservative forecasts. The Town of Prosper currently employs 75 team members - 61 full -time, 2 part-time and 12 on -call temporary. Within the proposed budget there is a recommendation to only hire one additional employee, a Communications Manager in the Police Department. All other department's personnel will be funded at their current staffing levels. The budget does identify a four (4 %) percent pay increase for all employees. In evaluating the 2008 -2009 Proposed Budget it is important to consider several historical organizational initiatives, current environmental factors and the impact each has on planning for additional appropriations. Those with the greatest impact are listed below. FY 2009 will include the first full year's implementation of the Waters Consulting Group Pay Plan that was adopted in 2007. The current Fiscal Year Budget, 07 -08, implemented the pay plan in three phases, with the final phase not being implemented until this September, 2008. Implementing the plan in this way afforded the Town the opportunity to improve employees pay while at the same time minimizing its costs in the current Fiscal Year. The Fiscal Year 08 -09 Budget though reflects the full cost of the pay plan's implementation. This will automatically increase personnel cost approximately $105,000 plus benefits. • The Town is continuing to receive negatively trending sales tax revenues. The budget recognizes a decrease of nearly 17% or $200,000 in budgeted sales tax compared to the 07 -08 Budget despite the addition of some commercial space in 2009. • The addition of EMS/Fire staff as approved in FY 2007 has resulted in additional costs totaling $548,000, which are partially offset by grant revenues anticipated to be $341,550. This grant will continue for four more years with a decreasing value paid to the Town each year of the grant. • Energy and Fuel costs continue to rise at an alarming rate. The proposed 08 -09 Fiscal Year General Fund Budget anticipates increased cost totaling $85,000, or a 46% increase over the adopted 07 -08 Fiscal Year Budget. • The State of Texas on July 25, 2008 granted the Town of Prosper the ability to create its own 911 Dispatch Center. This was necessitated by the fact that the Town will no longer be receiving 911 dispatch services from Frisco sometime after the first quarter of 2009. In the interim and prior to the Town establishing its own Dispatch Center, the Town will be served by the Collin County Sheriff's Department. As a result of these actions, it is recommended that the Town hire a Communications Manager to shepherd this project, ensuring that the citizens of Prosper receive the best service possible with no service interruptions. The proposed 2008 — 2009 Budget Appropriations total $11,209,939 for all funds not including debt service payments. Of that amount, approximately $6,289,129 is for General Fund operations and maintenance, $3,897,686 is for the Town's Enterprise Funds including Solid Waste, Water and Sewer utilities, and the yet to be funded Stormwater Drainage utility. Debt service payments will total $2,127,619. Property Values Certified freeze- adjusted, taxable property valuations increased by $178M (23.4 %) in FY 2008 -09. These values increased from $762,250,305 to $940,820,954. While the growth in certified property valuations continues to increase, economic and inflationary pressures of rising energy cost are counterbalancing this growth specifically with the continuing decline in sales tax collection. This past year the Town has seen a stabilized residential construction market indicating property tax values will continue to increase. Property Tax Rate This year the property tax rate as proposed is consistent with the current tax rate of $0.52 per $100 of property valuations. The portion of the tax applied to debt service is $0.214989. Sales Taxes In the face of rising energy and fuel cost and the slow down in the construction industry throughout the region the Town's retail sales tax collections are projected to continue to decline. Utility Rates The Town of Prosper Town Council this past spring engaged the services of J. Stowe and Company to produce with staff a Water and Wastewater Utility Comprehensive Business Plan. The Plan will be presented to the Town Council within the next sixty (60) days. Contained within the plan are recommendations to enhance revenues, to establish a 60 day operations and maintenance reserve account and to fund an annual contribution of 2% to a capital replacement program. Solid Waste rates will be increasing this coming Fiscal Year reflecting the fuel service charge being added by IESI, as allowed for in the current contract with the service provider. Stormwater Drainage Utility rates will be implemented in the coming year. Staff continues to research data prior to recommending the establishment of a rate. GENERAL FUND The 2008 -2009 Proposed Budget as presented is based on using the Existing Tax Rate of $0.52. The projected effective tax rate, that is the rate that would generate the same amount of property tax revenues in 2008 -2009 that were generated in this fiscal year, is $0.486331. The rollback rate, which equates to 108% of the effective operating rate, plus the debt service rate, less the additional sales tax adjustment dedicated to property tax relief is $0.501568. Without the sales tax adjustment of $0.038043, the rollback rate would be $0.539611. Each penny of the tax rate generates approximately $94,000 in property tax revenue. Additionally, for property tax revenue projections the Collin County Tax Assessor - Collector states that it again expects to collect 100% of the current property taxes due. Revenues are expected to exceed Appropriations resulting in an increase of $55,232 to the Town's Fund balance. The Audited Fund Balance at the end of 2006 — 2007 was $3,093,165. Revised Fund balance prior to the final audit for 2007 — 2008 is expected to increase to $3,208,047. (The actual 2007 -2008 budget called for no increase to the Fund Balance.) Should the current projections hold true, the total projected fund balance as of September 30, 2009 could be $3,260,279. The Town has historically called for a reserve level equal to 16% (or 60 days) of appropriations. In the Proposed 2008 -2009 Budget, the target reserve level has been elevated to 25% (or 90 days). In addition to this reserve, staff has earmarked an amount of the fund balance equal to 10% of the total general fund expenditures to conform to the Town Charter provision regarding contingent funds. At the end of the 2008 -2009 fiscal year the projected total fund balance not otherwise restricted or held in contingency should total $1,068,959 which equates to an additional 61 days of operations depending on final audited numbers. Overall, revenues are projected to increase 18.4% compared to budgeted 2007 -2008. This increase continues to reflect the overall decrease in sales tax collections. Property Tax Revenues for Operations and Maintenance are projected to increase by approximately 32.3% compared to budgeted 2007 -2008 revenues. Sales Taxes are projected to decrease at a 9.1% rate over collections for this year while Franchise and other related Taxes are projected to increase 11.3% primarily as the result of increased energy cost and growth in the community. Staff continues to be conservative when projecting sales tax because of the down turn in construction related projections for the DFW metroplex. The Town's sales tax has seen a continued decline beginning in 2006 when it was at its height to the current year. In the current year, excluding the onetime audited adjustment from the State reflecting a single payment for sales tax collections between 2000 and 2003, the Town is expected to receive $1,012,000. This represents a decline of approximately 33% in sales tax receipts over the last 3 years. Permit Revenues are projected to remain constant when compared to the 2007 -2008 Budget yet substantially less than actual revenues for the current fiscal year reflecting less new home or multi- family construction and minimal non - residential construction in the coming year. Municipal Court Fines and Licenses are projected to remain consistent with the current year's projected revenues. Fees and Other Revenues are projected to increase by 105% over the prior budget. Street rental and payment in lieu of taxes from the Town's Enterprise Funds are projected as new revenue in the 2008- 2009 budget. The expected SAFER Grant revenues ($341,550) contribute to most of this large increase. General Fund Revenues by Source Revenue Category FY 2009 Proposed % of Total Property Tax $ 2,884,060 45.5% Licenses, fees, and permits $ 1,055,785 16.6% Sales Tax $ 1,003,045 15.8% Grants $ 341,550 5.4% Franchise $ 299,494 4.7% Interfund Transfer In $ 199,502 3.1% Fines & warrants $ 191,875 3.0% Charges for services $ 159,700 2.5% Miscellaneous $ 106,150 1.7% Investment Income $ 100,200 1.6% Revenue Total $ 6,341,361 100.0% APPROPRIATIONS Total General Fund Appropriations for the 2008 — 2009 Budget are $6,289,129. This is an increase of approximately 17.4% compared to the 2007 — 2008 Budget. Personnel costs constitute 65.3% of the General Fund Budget. There is only one (1) new addition to Personnel in the proposed budget and all other Departmental existing positions are proposed to be funded. Program Enhancement and Capital Expenditures included in the proposed appropriations and planned for the 2008 — 2009 Fiscal year by Division are as follows: CONTINUATION AND PROGRAM DIVISION ENHANCEMENT DESCRIPTION Administration $12,000 Dedicated Community Communications Program Planning $55,000 GIS increase, Annexation, Aerial Maps, Subscription to TRAKiT Program Hosting Engineering $40,000 Update to Town's Roadway Impact Fee Ordinance Police Fire Streets Parks and Recreation Administration $186,000 Communications Manager, Hand held radios, Outfit police officers for safety, Leased vehicles and additional cruisers, Weapons and vehicle equipment to outfit 3 vehicles- 2 new and a seized Tahoe $14,000 Leased vehicle $11,200 Trailer $17,000 Support equipment for maintenance The Administration proposed budget includes funding a dedicated communication program for the community. This represents funding one of the Town Council's goals and fulfills the commitment to improve communication between the Town and those it serves. What once was a section of the budget, Communications, has been folded into the Administration's budget. There are no other additions to the Administration budget. Police While additional Police Officers have been requested, the budget as presented does not include any additional Police personnel with the exception of a Communications Manager. With the Town's successful designation by the State to implement a 911 Dispatch Operation, there is a need to hire a Communications Manager in the coming Fiscal Year. This position will be responsible for the coordination of the dispatch project from inception and is expected to later serve as the Dispatch Supervisor. The budget as presented includes funding for the purchase or required tactical equipment including vests, personal and vehicle radios, and the continued acquisition of police vehicles. Additional costs reflected in the Police Department budget include contractual costs with Collin County for Animal Control. Municipal Court The 2008 -2009 Municipal Court proposed budget reflects increased costs resulting from the potential relocation of the Police Department to the current Town Hall, and the entire costs associated with their current location now being the responsibility of the Municipal Court. These increased costs even though they are actually just being redistributed from the Police Department's budget, include additional rent, electricity and IT costs. The 2008 -2009 proposed budget reflects the addition of the six (6) personnel the Town was able to bring on as a result of receiving the SAFER Grant. The SAFER grant reimbursement will cover 62.3% of these six firefighters and an additional three (3) that were already budgeted for 2007 -2008 and were able to be incorporated into the Grant. With these additional Firefighters/Paramedics, the Town for the first time is able to provide full time paid staff service to the residents on a 24/7 basis for both Fire and Ambulance services. Up until this time, paid part time staff and volunteers supplemented paid staff in accomplishing this goal. Personnel cost in this department reflect the single largest increase in the overall budget for the Town in the coming fiscal year. Public Works — Streets and Parks and Recreation There are no significant changes or additions to the Street Budget proposed in 2008 -2009 over the current fiscal year. In Parks and Recreation there are a several program changes proposed. The first change in Contracted Services represents increases resulting from additional park land coming online this coming fiscal year, including Folsom and Whitley Place parks. In the case of Whitley Place, the Town has entered into an agreement stating that the costs for the maintenance of this park will be pass through costs, reimbursed by the Developer; therefore the costs while revenue neutral should be recognized. The second cost increase in this division reflects the continued purchase of equipment to support the maintenance of the fields. Development Services - Inspections. Planning and Engineering There are no significant changes proposed for any of the divisions of Development Services. The Inspections Division will continue to utilize a private contractor to perform all health/food establishment/hotel inspections. Planning will continue to contract with Frisco's GIS department for mapping services and planned expenses are identified for the continuation of the Town's annexation of areas within its existing ETL This budget also includes the hosting service fee for the TRAKiT software program, which will support all of Development Services better than the existing tool. Contained within the Engineering Division's proposed budget is the update to the Town's Roadway Impact Fee Ordinance necessitated by the continued growth of the Town, increased construction cost and certain development agreements that have been entered into by the Town. ENTERPRISE AND SPECIAL REVENUE FUNDS GENERAL OBLIGATION I &S FUND This fund represents the debt portion of the tax rate. Debt payments from I &S for 2008 -2009 will total $2,055,959, an increase of $189,011 from the current year's budget. WATER, SEWER AND SOLID WASTE UTILITY FUND Revenues for the Water, Sewer and Solid Waste Fund are expected to increase to $3,895,993 without any revenue enhancements. Based on a the to be adopted business plan for the Water and Sewer Utility Fund, there will need to be revenue enhancements adopted to cover existing and future operations and maintenance costs as well as debt service and contracted sewer costs with Upper Trinity beginning in the 2009 -2010 fiscal year. Additionally due to TCEQ rules, the Town will need to adopt the equivalent of a per connection/door charge for any existing and future multi - family, nursing home and mobile home parks. Regarding Solid Waste, IESI has begun to bill the Town an additional $0.53 per residential customer per month for fuel costs. The fuel surcharge increase for commercial customers is $1.71 per month. This additional cost of approximately $1,700 per month and should be passed on to the customer as contemplated in the contract with IESI. Water /Sewer Fund Revenues by Source Revenue Category FY 2009 Proposed % of Total Water Charges $ 2,417,300 62.05% Sewer Charges $ 674,200 17.30% Solid Waste Charges $ 424,900 10.91% W/S Tap & Construction $ 200,000 5.13% Investment Income $ 93,000 2.39% Penalties $ 69,300 1.78% Service Initiation $ 14,000 0.36% Licenses, fees, and permits $ 1,650 0.04% Miscellaneous $ 1,643 0.04% Revenue Total $ 3,895,993 100.00% Expenses for the fund total $3,965,346 resulting in a net "loss" of $69,353 for the fiscal year, which will decrease the net asset balance of these funds. The projected Operating Revenues are well short of the targets established within the proposed business plan for these utilities. The additional revenues over expenses projected in the business plan are to be designated for reserves, capital investment reserves and debt service reserves. There is a $45,000 increase in Professional Services for the implementation of a Rate Study for the Water and Sewer Fund. This is critical in light of the targets, and in anticipation of the payments to the Upper Trinity system for sewer service beginning October 1, 2009. The Contractual/Professional Services category of the enterprise fund accounts for 34.5% of the budgeted expenditures; this category is comprised of sewer management fees and other directly related professional service fees, but also includes the Town's solid waste expense. The proposed budget calls for the addition of a mower and a 1 -Ton Utility Pickup. Utility Billing received funds to complete the setup for online utility payments on STW, the Town's financial system. There have been numerous citizen requests for this feature and the major hardware is already in place. STORMWATER UTILITY FUND There are currently no Revenues or Expenditures identified for this fund. Staff is completing an initial rate analysis that would at least cover the cost of engineering studies needed for establishing the parameters for a base rate for all customers, residential and non - residential. GENERAL DISCUSSION ITEMS The following items also have been incorporated into the Proposed 08 -09 Budget: In an effort to defer the rising costs of health care and simultaneously provide a more cost - feasible medical plan to our employees, the Town has elected to insure through a high deductible plan accompanied by a Medical Expense Reimbursement Plan (MERP). This will require some funding to the Internal Service Fund, but should produce a net savings based on actuarial experience. Expected MERP claims are $45 per member per month, but the proposed budget funded this at twice the amount to ensure ample coverage. The cost to have renewed the previous coverage would have been $213,528. Including the new design, MERP administration fees and MERP liability, the Town is projected to save almost $38,000 in medical premiums. If the claims experience is twice the actuarial estimate, the Town still saves $5,900 dollars as compared to the traditional plan. Proposed Personnel Policy Manual revision impacts: Two (2) days total paid time off were added. The merits of the current longevity pay practice (whereby employees receive $25 /month of service and are capped at $1,000) are being reviewed and possibly revised to a $5 /month with a benefit service limit of 25 years. This is more in line with standard practice in the market and would do more to incentivize long term service. This would not be implemented at any financial loss to existing employees. To make sure existing employees receive the full benefit as they had before the policy change, the Town could add the difference between the previous calculation and the new calculation directly into the employee's salary. The Proposed Budget includes $60,304 for payments made to employees to "cash out" vacation balances in excess of 40 hours. This is written in the policy so as to allow a total of 80 hours to be paid out per employee per fiscal year, but is being reduced to 40 hours due to budget constraints. The purpose of introducing this option is to reduce the Town's accrued liability from carrying existing employees "banked" vacation hours, placing a new limit on carry over, and limiting the Town's future liability in this area as new employees are hired. • Changes were made to TMRS to allow for a 20 year, any age retirement instead of the current 25 years. This constitutes an increase of 0.29% of employee wages or $10,225. For an additional 0.17% or $6,000, the Proposed Budget also calls for the allowance of a TMRS provision called Transfer Updated Service Credit. These updates combined should help in Town's recruitment efforts, especially for experienced public safety staff. Due to budget priorities and constraints, additional staff requests other than the Police Communications Manager's position have not been included. One last personnel issue that will be examined for implementation in the coming Fiscal Year is the implementation of a Public Safety Step Plan for Police and Fire. As this Step Plan is being finalized, it will be presented in the coming months for formal adoption separate and apart from this proposed budget. The plan will have to be implemented in phases and as such the first phase will not be recommended for implementation until April of 2009 if accepted by the Town Council. If Council supports the implementation of the Step Plan, the impact on the 2008 -2009 fiscal year will be approximately $55,000. Other Budget Issues to he addressed in Fiscal Year 2008 -2009: The Town Council and staff in the coming Fiscal Year will be working to create budget policies that address targets for Fund Balance/Net Assets as a percent of Annual Revenues over Annual Appropriations/Expenditures, Salaries and Related Expenses as a percent of annual operations and maintenance costs, target capital expenditures and multi -year budgeting. Other items that will be addressed include improving monthly budget reports designed to assist in identifying cash flow /operating requirements and the impact of economic cycles on the Town's budget. In summary, staff is able to present a proposed budget that meets the objectives provided by Council, utilizing the current tax rate, keeping personnel cost minimized compared to overall Appropriations, while maintaining continued capital and equipment investment. The momentum of the Town's growth going into FY 09 has been slowed somewhat by the downturn in the market. With the opening of the DNT frontage road north through Prosper, the addition of a couple of high quality multi - family projects and additional commercial space, the Town will continue to experience solid growth in population and property values. In this time of slower growth, the Town will prepare itself to better manage the rapid demand for services expected in future years. The Proposed Budget facilitates only needed improvements and expansions to this end. Total Freeze Adjusted Taxable Value Tax Rate Per $100 Tax Collections Tax Collections- Freeze Total Tax Levy One Cent Equals Ad Valorem Taxes $ 940,820,954 0.520000 $ 4,892,269 $ 170,880 $ 5,063,149 $ 94,082 Tax Rate Distribution FY 2008 -2009 Debt Service 41% General Fund 59 % 2007/2008 Debt _V JW General Service Fund 47% 53% General Fund Tax Rate (M 8 O) Debt Service Tax Rate ( I & S) Total Tax Rate 2006/2007 General Fund 37% Debt J&W Service 63% PER $100 VALUATION 29012007 2007/2008 2008/2009 08-09% 0.184549 0.275075 0.305011 59% 0.314268 0.244925 0.214989 41% 0.498817 0.520000 0 0.520000 1000/0 0.80 0.70 0.60 0.50 0.40 0.30 0.20 0.10 0.00 Q � �• Qc � P ,�� Q'� °� � Qr �a Tax Rate Comparison Fiscal Year 1007 2007 Tax Rate 1tv FY 2003 FY 2004 FY 2005 FY 2006 FY ZODY Lucas 0.372507 0.376600 0.376600 0.375000 0.375000 Parker 0.270000 0.282000 0.310000 0.377080 0.377078 Frisco 0.432000 0.422960 0.444893 0.450000 0.450000 Murphy 0.430400 0.468320 0.468300 0.468300 0.468300 Little Elm 0.399800 0.357500 0.399020 0.470000 0.470000 Prosper 0.324100 0.479700 0.405385 0.498817 0.520000 Melissa 0.437969 0.490215 0.520000 0.520000 0.520000 Aubrey 0.555450 0.52624 0.526240 0.526240 0.526240 Sachse 0.560056 0.558321 0.558319 0.553408 0.553408 Allen 0.561000 0.560000 0.559000 O.S58000 0.558000 Anna 0.499703 0.499703 0.525000 0.525000 0.575000 McKinney 0.598000 0.593000 0.588000 0.588000 0.583000 Pilot Point 0.499900 0.463310 0.500000 0.590000 0.590000 Farmersville 0.577730 0.554447 0.546005 0.599755 0.605165 Princeton 0.701300 0.675000 0.675000 0.649700 0.649699 Celina 0.760000 0.750000 0.740000 0.690000 0.655000 Colony 0.720000 0.720000 0.720000 0.715000 0.715000 Wylie 0.705000 0.695000 0.695000 0.706780 0.733250 TOWN ER. FY 2008 -2009 Proposed Budget By Fund and Category 1of6 pr Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. Category FY 2007 Actual 2007 %of ftwai roar FY 2008 Budget FY 2008 Total Revised 2008 %of Rev;sw total FY 2009 Proposed 2009 %of p ad Toni General Expenditure 01 Personnel $ 2,304,472 63.2% $ 3,196,453 $ 3,286,125 60.9% $ 4,104,738 65.3% 04 Materials and Supplies $ 135,636 3.7% $ 229,589 $ 193,471 3.6% $ 218,265 3.5% 05 Town Services /Maintenance $ 570,420 15.7% $ 795,938 $ 709,112 13.1% $ 900,433 14.3% 06 Contractual /Professional Services $ 494,457 13.6% $ 721,359 $ 823,322 15.3% $ 881,858 14.0% 07 Capital $ 139,447 3.8% $ 414,078 $ 384,010 7.1% $ 155,620 2.5% 09 Interfund Transfer Out 0.0% $ - $ - 0.0% $ 28,215 0.4% Expenditure Total $ 3,644,432 100% $ 5,357,417 $ 5,396,040 100% $ 6,289,129 100% Revenue 01 Property Tax $ (1,112,082) 26.2% $ (2,179,404) $ (2,263,000) 41.1% $ (2,884,060) 45.5% 02 Sales Tax $ (1,207,541) 28.4% $ (1,202,000) $ (1,102,900) 20.0% $ (1,003,045) 15.8% 03 Franchise $ (265,284) 6.2% $ (269,065) $ (285,232) 5.2% $ (299,494) 4.7% 04 Licenses, fees, and permits $ (1,106,563) 26.0% $ (1,144,700) $ (1,145,334) 20.8% $ (1,055,785) 16.6% 05 Charges for services $ (136,559) 3.2% $ (148,820) $ (163,200) 3.0% $ (159,700) 2.5% 06 Grants $ (32,250) 0.8% $ (184,000) $ (150,800) 2.7% $ (341,550) 5.4% 07 Investment Income $ (134,425) 3.2% $ (62,430) $ (95,200) 1.7% $ (100,200) 1.6% 08 Fines & warrants $ (128,591) 3.0% $ (120,000) $ (191,000) 3.5% $ (191,875) 3.0% 21 Interfund Transfer In 0.0% $ - $ - 0.0% $ (199,502) 22 Miscellaneous $ (129,038) 3.0% $ (47,000) $ (114,256) 2.1% $ (106,150) Revenue Totat $ (4,252,333) 100% $ (5,357,419) $ (5,510,922) 100% $ (6,341,361 A3.1% General Total $ (607,902) $ (2)1$ (114,882) $ (52,232) Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. P PER. FY 2008 -2009 Proposed Budget By Fund and Category 2 of 6 Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. Category FY 2007 Actual 2007 %of Actual Total FY 2008 Budget FY 2008 Tota! Revised 2008 96 of Revered Toes FY 2009 Proposed 2009 %of proposed Total Water /Sewer Expenditure 01 Personnel $ 481,840 20.6% $ 526,401 $ 525,505 13.8% $ 546,229 13.8% 04 Materials and Supplies $ 498,384 21.3% $ 938,400 $ 940,000 24.7% $ 1,100,425 27.8% 05 Town Services /Maintenance $ 1,231,658 52.7% $ 696,628 $ 640,618 16.9% $ 614,275 15.5% 06 Contractual /Professional Services $ 641,760 27.5% $ 1,076,225 $ 1,088,270 28.6% $ 1,368,530 34.5% 07 Capital $ 355,918 15.2% $ 546,600 $ 539,636 14.2% $ 64,000 1.6% 08 Bond $ - 0.0% $ 67,660 $ 67,660 1.8% $ 67,660 1.7% 09 Interfund Transfer Out $ (873,395) -37.4% $ - $ - 0.0% $ 204,227 5.2% Expenditure Total $ 2,336,165 100% $ 3,851,914 $ 3,801,689 100% $ 3,965,346 100% Revenue 04 Licenses, fees, and permits $ (775) 0.0% $ (500) $ (1,950) 0.0%1$ (1,650) 0.0% 07 Investment Income $ (131,516) 3.6% $ (81,000) $ (85,000) 2.1% $ (93,000) 2.4% 22 Miscellaneous $ (32,648) 0.9% $ (500) $ (30,000) 0.8% $ (1,643) 0.0% 23 W/S Tap & Construction $ (426,659) 11.8% $ (400,000) $ (400,000) 10.1% $ (200,000) 5.1% 24 Service Initiation $ (33,505) 0.9% $ (25,520) $ (27,500) 0.7% $ (14,000) 0.4% 25 Water Charges $ (1,988,988) 55.1% $ (2,320,000) $ (2,320,000) 58.6% $ (2,417,300) 62.0% 26 Sewer Charges $ (559,458) 15.5% $ (641,480) $ (641,480) 16.2% $ (674,200) 27 Penalties $ (76,831) 2.1% $ (50,000) $ (66,000) 1.7% $ (69,300) 30 Solid Waste Charges $ (358,543) 9.9% $ (348,000) $ (390,000) 9.8% $ (424,900) H17.3% Revenue Total $ (3,608,923) 100% $ (3,867,000) $ (3,961,930) 100% $ (3,895,993) Water /Sewer Total $ (11272,7S8) $ (15,086)1$ (160,24.1)1 1$ 69,353 Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. pri�SPER FY 2008 -2009 Proposed Budget By Fund and Category 3 of 6 Parks & Recreation Fund Category FY 2007 Actual 2007 %of Actual Total FY 20 08 Budget FY 2008 Total Revised 2008 % of gad Total FY 2009 Proposed 2009 %of Proposed Total Interest and Sinking $ 32,770 S 35,000 $ - $ - Expenditure 05 Town Services /Maintenance $ - 0% $ - $ - 0% 0% 0% 07 investment Income 08 Bond $ 827,358 49% $ 1,866,948 $ 1,870,637 92% $ 2,059,959 100% 19 Park Fees 09 Interfund Transfer Out $ 873,395 51% $ - $ 157,880 8% $ - 0% Expenditure Total $ 1,700,752 100% $ 1,866,948 $ 2,028,517 100% $ 2,059,959 Parks & Recreation Fund Total Revenue 01 Property Tax $ (1,875,901) 95.3% $ (1,940,430) $ (2,032,120) 98.7% $ (2,087,409) 07 Investment Income $ (91,665) 4.7% $ (25,500) $ (27,400) 1.3%1$ (29,000) N1.4% Revenue Total $ (1,967,566) 100% $ (1,965,930) $ (2,059,520) 100% $ (2,116,409) Interest and Sinking Total $ (266,813) $ (98,982) $ (31,003) $ (56,450) Parks & Recreation Fund Expenditure 06 Contractual /Professional Services $ 32,770 S 35,000 $ - $ - Expenditure Total $ 32,770 0% $ 35,000 $ - 0% $ - 0% Revenue 07 investment Income $ (17,160) 2.5% $ (7,000) $ (37,000) 8.1%.$ (37,000) 6.9% 19 Park Fees $ (680,188) 97.5% $ (607,000) $ (418,107) 91.9% $ (500,000) 93.1% Revenue Total $ (697,348) 100% $ (614,000) $ (455,107) 100% $ (537,000)1 17 Parks & Recreation Fund Total $ (664,579) $ (579,OW) $ (455,107) $ (537,000) Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. pri�SPER TOWN FY 2008 -2009 Proposed Budget By Fund and Category 4of6 Special Revenue - Donations Category FY 2007 Actual 2007 % of Actual Total FY 2008 Budget FY 2008 Total Revised 2008 %of peeked Total FY 2009 Proposed 2009 %of Total Impact Fees $ 69,045 100% $ 24,000 $ 24,175 100% $ 26,000 100% Expenditure Total Expenditure 01 Personnel $ 17,695 2% $ - $ - 0% Revenue 0% $ (2) OS Town Services /Maintenance $ 11,529 1% $ - $ - 0% 0% $ (4,590) 06 Contractual /Professional Services $ 17,695 2% $ - $ 34,036 14% $ - 0% $ (44,848) 07 Capital $ 779,413 94% $ 449,200 $ 205,000 86% $ 195,049 100% Expenditure Total 87.6% $ 826,332 100% $ 449,200 $ 239,036 100% $ 195,049 100% Revenue 107 Investment Income $ (108,365) 5.5% $ (66,000) $ (81,000) 9.3% $ (81,000) 9.5% 100%1$ 12 Impact Fees $ (1,853,098) 94.5% $ (2,157,500) $ (790,000) 90.7% $ (775,000) 90.5% Revenue Total $ (1,961,462) 100% $ (2,223,500) $ (871,000) 100% $ (856,000) 100% Impact Fees Total $ (1,135,130) $ (1,774,300) $ (631,964) $ (660,9S2) Special Revenue - Donations Expenditure O5 Town Services /Maintenance $ 69,045 100% $ 24,000 $ 24,175 100% $ 26,000 100% Expenditure Total $ 69,045 100% $ 24,000 $ 24,175 100% $ 26,000 100% Revenue 07 Investment Income $ (2) 0.0% $ - $ - 0.0% 0.0% 09 Court Fees $ (4,590) 1.2% $ (3,300) $ (5,750) 0.7% $ (5,500) 11.3% 10 Contributions $ (44,848) 11.2% $ (32,000) $ (44,897) 5.7% $ (41,000) 84.5% 11 Escrow Income $ (349,247) 87.6% $ - $ (734,397) 93.5% $ - 0.0% 22 Miscellaneous $ (2)1 0.0%1$ - 1 $ - 1 0.0%l$ (2,000) 4.1% Revenue Total $ (398,689) 100%1$ (3S,300)1$ (785,044) 100%1$ (48,500) 100% Special Revenue - Donations Total $ (329,643) $ (11,300)1$ (760,869) $ (22,500) Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. p ;1�V PLR FY 2008 -2009 Proposed Budget By Fund and Category 5of6 Capital Projects Category FY 2007 Actual 2007 %of Acft,al Tows FY 2008 Budget FY 2008 Total Revised ZM %of aewssd TOW FY 2009 Proposed 2009 %of Proposed Total Internal Service Fund 06 Contractual /Professional Services $ 423,886 5% $ - $ 452,467 7% $ - Expenditure 01 Personnel $ - $ 7,682,230 $ - $ - $ 6,342,399 $ 33,480 100% Expenditure Total $ - 0% $ - $ - 0% $ 33,480 100% Revenue 121 Interfund Transfer In $ - 0.0% $ - $ - 0.0% $ (33,480) 100% Revenue Total $ - 0% $ - $ - 0% $ (33,480) 100% Internal Service Fund Total I $ - 1 $ - $ _ 0% $ _ $ (325,000) Capital Projects Expenditure 06 Contractual /Professional Services $ 423,886 5% $ - $ 452,467 7% $ - 0% 07 Capital $ 7,682,230 95% $ 8,404,244 $ 6,342,399 93% $ 802,075 100% Expenditure Total $ 8,106,116 100% $ 8,404,244 $ 6,794,866 100% $ 802,075 100% Revenue 06 Grants $ (500,000) 40% $ - $ - 0% 0% 07 Investment Income $ (755,386) 60% $ (206,100) $ (365,026) 100% $ (220,000) 100% 21 Interfund Transfer In 0% $ - $ (325,000) 0% $ - 0% Revenue Total $ (1,255,386) 100%1$ (206,100)1$ (690,026) 100% $ (220,000) 100% Capital Projects Total $ 6,8S0,7301 1 $ 8,198,144 1 $ 6,104,8401 1 $ 582,075 Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. TOWN E R. FY 2008 -2009 Proposed Budget By Fund and Category 6of6 r P Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. Category FY 2007 Actual 2007 % of achai Toni FY 2008 Budget FY 2008 Total Revised 200E %of favIea Total FY 2009 Proposed 2009 % of ftaaowa Total Economic Development Corporation Expenditure 01 Personnel $ 104,208 59.1% $ 138,836 $ 138,000 20.3% $ 141,875 42.1% 04 Materials and Supplies $ 2,437 1.4% $ 9,525 $ 91500 1.4% $ 8,700 2.6% 05 Town Services /Maintenance $ 51,459 29.2% $ 68,080 $ 55,251 8.1% $ 63,600 18.9% 06 Contractual /Professional Services $ 18,165 10.3% $ 57,625 $ 40,000 5.9% $ 72,100 21.4% 07 Capital $ - 0.0% $ 45,000 $ 111,000 16.4% $ 50,000 14.8% 09 Interfund Transfer Out 0.0% $ - $ 325,000 47.9% $ 540 0.2% Expenditure Total $ 176,269 100% $ 319,066 $ 678,751 100% $ 336,815 100% Revenue 02 Sales Tax $ (401,647) 86.7% $ (390,000) $ (406,153) 95.0% $ (333,333) 91.7% 07 Investment Income $ (61,367) 13.3% $ (50,000) $ (21,572) 5.0% $ (30,000) 8.3% 22 Miscellaneous $ (133) 0.0% $ - $ - 0.0% 0.0% Revenue Total $ (463,147) 100% $ (440,000) $ (427,725) 100% $ (363,333) 100% Economic Development Corporation Total $ (286,878) $ (120,934)1 $ 251,026 $ (26,S18) Revenues are reported as negatives. A positive total represents a deficit and a negative total represents excess revenues over expenditures. r ' � P: P` TOWN Departmental Budget Allocations Summary Water /Sewer Fund FY 2007 Actual FY 2008 Budget FY 2008 Revised Dept. % Inc/Dec 2007 to 2008 FY 2009 Proposed Dept. % Inc/Dec 2008 to 2009 General Fund $ 2,525,785 $ 2,520,665 7.9% $ 2,512,487 -0.3% Sewer $ 1,202,103 $ 1,159,969 N/A Administrative $ 719,096 $ 892,641 $ 884,296 23.0% $ 905,233 2.4% Communications $ 1,494 $ 25,500 $ 9,100 509.2% $ - N/A Engineering $ 130,716 $ 176,926 N/A $ 175,926 -0.6% Planning $ 190,269 $ 288,288 $ 374,391 96.8% $ 381,313 1.8% Inspections $ 443,753 $ 567,950 $ 558,558 25.9% $ 611,974 9.6% Streets $ 177,028 $ 331,059 $ 338,259 91.1% $ 309,682 -8.4% Parks and Recreation $ 60,255 $ 221,549 $ 205,459 241.0% $ 277,483 35.1% Police $ 913,131 $ 1,146,625 $ 1,086,893 19.0% $ 1,385,556 27.5% Municipal Court $ 124,820 $ 157,610 $ 178,458 43.0% $ 203,503 14.0% Fire /EMS $ 1,014,587 $ 1,595,479 $ 1,583,700 56.1% $ 2,038,459 28.7% General Fund Total $ 3,644,432 $ 5,357,417 $ 5,396,040 48% $ 6,289,129 17% Water /Sewer Fund Water $ 2,336,165 $ 2,525,785 $ 2,520,665 7.9% $ 2,512,487 -0.3% Sewer $ 1,202,103 $ 1,159,969 N/A $ 1,285,972 10.9% Utility Billing Department $ 124,026 $ 121,055 N/A $ 166,887 37.9% Water /Sewer Fund Total $ 2,336,165 $ 3,851,914 1 $ 3,901,6891 62.7%1$ 3,965,346 4.3% ;I(SPER P Departmental Budget Allocations by Category Administration Departments Administration Departments Total $ 720,589 $ 918,1411$ 893,3961$ 905,233 1of6 FY 2007 Actual FY 2008 Budget FY 2008 Revised FY 2009 Proposed General Fund Administrative 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital 09 Interfund Transfer Out Communications 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services $ 719,096 $ 892,641 $ 884,296 $ 905,233 $ 449,829 $ 557,703 $ 571,580 $ 504,231 $ 12,336 $ 22,740 $ 12,400 $ 17,720 $ 63,597 $ 115,823 $ 70,065 $ 92,375 $ 192,066 $ 190,695 $ 228,751 $ 257,692 $ 1,268 $ 5,680 $ 11500 $ 51000 $ - $ - $ 28,215 $ 1,494 $ 25,500 $ 9,100 $ - $ 3,1901$ 200 $ - $ 295 $ 3,340 $ - $ - $ 1,199 $ 18,970 1 $ 8,900 $ - Administration Departments Total $ 720,589 $ 918,1411$ 893,3961$ 905,233 1of6 PrSPER i o w N ©F Departmental Budget Allocations by Category Development Services Departments Development Services Departments Total 1 $ 634,0221$ 986,954 $ 1,109,875 $ 1,169,213 2 of 6 FY 2007 Actual FY 2008 Budget FY 2008 Revised FY 2009 Proposed General Fund Engineering 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital Planning 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital Inspections 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital $ 130,716 $ 176,926 $ 175,926 $ 112,626 $ 112,601 $ 119,631 $ 2,600 $ 2,500 $ 1,850 $ 8,765 $ 8,115 $ 10,735 $ 6,725 $ 53,710 $ 43,710 $ - $ - $ - $ 190,269 $ 288,288 $ 374,391 $ 381,313 $ 76,504 S 159,638 $ 187,573 $ 197,913 $ 15,683 $ 9,875 $ 9,875 $ 5,600 $ 28,506 $ 23,125 $ 23,310 $ 29,872 $ 68,366 $ 95,650 $ 153,125 $ 147,420 $ 1,210 $ - $ 508 $ 508 $ 443,753 $ 567,950 $ 5581558 $ 611,974 $ 332,878 $ 448,504 $ 448,504 $ 511,659 $ 19,424 $ 20,004 $ 20,624 $ 13,770 $ 34,397 $ 53,502 $ 43,490 $ 52,485 $ 31,555 1 $ 40,760 $ 40,760 1 $ 34,060 $ 25,499 1 $ 5,1801 $ 5,180 1 $ - Development Services Departments Total 1 $ 634,0221$ 986,954 $ 1,109,875 $ 1,169,213 2 of 6 OWN OF TOWN Departmental Budget Allocations by Category Public Works - General Fund Departments Public Works - GF Total $ 237,283 $ 552,608 $ S43,7181$ 587,165 3 of 6 FY 2007 Actual FY 2008 Budget FY 2008 Revised FY 2009 Proposed General Fund Streets 01 Personnel 04 Materials and Supplies OS Town Services /Maintenance 06 Contractual /Professional Services 07 Capital Parks and Recreation Ol Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital $ 177,028 $ 331,059 $ 338,259 $ 309,682 $ 82,071 $ 100,609 $ 101,783 $ 102,170 $ 25,748 $ 67,180 $ 50,680 $ 66,480 $ 52,226 $ 81,470 $ 97,902 $ 91,782 $ 16,983 $ 35,800 $ 36,100 $ 38,050 $ 46,000 $ 51,794 $ 11,200 $ 60,255 $ 221,549 $ 205,459 $ 277,483 $ 25,961 $ 64,941 $ 65,601 $ 90,501 $ 689 $ 3,500 $ 3,100 $ 2,450 $ 29,646 $ 58,600 $ 40,250 $ 50,982 $ 3,404 $ 73,400 $ 75,400 $ 116,550 $ 556 $ 21,108 $ 21,108 $ 17,000 Public Works - GF Total $ 237,283 $ 552,608 $ S43,7181$ 587,165 3 of 6 I� I P TOWN ER Departmental Budget Allocations by Category Law Enforcement Departments law Enforcement Total 1 $ 1,037,9511 $ 1,304,235 1 $ 1,265,351 1 $ 1,589,059 4of6 FY 2007 Actual FY 2008 Budget FY 2008 Revised FY 2009 Proposed General Fund Police 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital Municipal Court 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital $ 913,131 $ 1,146,62S $ 1,086,893 $ 1,38S,S56 $ 543,294 $ 692,761 $ 678,789 $ 862,073 $ 18,586 $ 28,900 $ 24,501 $ 38,970 $ 107,926 $ 142,294 $ 116,151 $ 206,885 $ 149,947 $ 174,910 $ 160,042 $ 171,116 $ 93,377 $ 107,760 $ 107,410 $ 106,512 $ 124,820 $ 157,610 $ 178,458 $ 203,503 $ 58,501 $ 61,540 $ 61,868 $ 62,748 $ 2,896 $ 4,800 $ 3,805 $ 4,400 $ 52,347 $ 66,700 $ 89,780 $ 96,845 $ 11,077 $ 24,570 $ 23,005 $ 39,510 $ - $ - $ - law Enforcement Total 1 $ 1,037,9511 $ 1,304,235 1 $ 1,265,351 1 $ 1,589,059 4of6 p ;I�SPER TOWN Departmental Budget Allocations by Category Fire /EMS Department Fire /EMS Total $ 1,014,587 1 $ 1,595,479 1 $ 1,583,700 1 $ 2,038,459 5of6 FY 2007 Actual FY 2008 Budget FY 2008 Revised FY 2009 Proposed General Fund Fire /EMS 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual/Professional Services 07 Capital $ 1,014,587 $ 1,595,479 $ 1,583,700 $ 2,038,459 $ 735,435 $ 998,131 $ 1,057,826 $ 1,653,812 $ 40,274 $ 66,800 $ 65,786 $ 67,025 $ 201,479 $ 242,319 $ 220,049 $ 268,472 $ 19,862 1 $ 59,879 1 $ 43,529 1 $ 33,750 $ 17,537 $ 228,3501$ 196,S101$ 15,400 Fire /EMS Total $ 1,014,587 1 $ 1,595,479 1 $ 1,583,700 1 $ 2,038,459 5of6 priTOWN ER Departmental Budget Allocations by Category Public Works - Water /Sewer Fund Departments Public Works -W /S Total $ 2,336,165 1 $ 3,851,914 1 $ 3,801,689 1 $ 3,965,346 6of6 FY 2007 Actual FY 2008 Budget FY 2008 Revised FY 2009 Proposed Water /Sewer Water 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital 08 Bond 09 Interfund Transfer Out Sewer 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 07 Capital 09 Interfund Transfer Out Utility Billing Department 01 Personnel 04 Materials and Supplies 05 Town Services /Maintenance 06 Contractual /Professional Services 09 Interfund Transfer Out $ 2,336,165 $ 2,525,785 $ 2,520,665 $ 2,512,487 $ 481,840 $ 309,202 $ 308,697 $ 354,561 $ 498,384 $ 863,800 $ 862,500 $ 1,041,925 $ 1,231,658 $ 454,308 $ 453,908 $ 414,636 $ 641,760 $ 384,215 $ 386,640 $ 480,600 $ 355,918 $ 446,600 $ 441,260 $ 12,000 $ - $ 67,660 $ 67,660 $ 67,660 $ (873,395) $ - $ - $ 141,105 $ 1,202,103 $ 1,159,969 $ 1,285,972 $ 140,943 $ 142,943 $ 109,318 $ 69,800 $ 72,300 $ 51,750 $ 235,010 $ 181,000 $ 191,562 $ 656,350 $ 665,350 $ 842,930 $ 100,000 $ 98,376 $ 52,000 $ - $ - $ 38,412 $ 124,026 $ 121,055 $ 166,887 $ 76,256 $ 73,865 $ 82,350 $ 4,800 $ 5,200 $ 6,750 $ 7,310 $ 5,710 $ 8,077 $ 35,660 $ 36,280 $ 45,000 $ - $ - $ 24,710 Public Works -W /S Total $ 2,336,165 1 $ 3,851,914 1 $ 3,801,689 1 $ 3,965,346 6of6 OWN OF priSPER GENERAL FUND Administration Police Fire On -call temporary pool Streets Parks Court Inspections Code Enforcement Planning Engineering Schedule of Personnel Fiscal Year Budget 2008 - 2009 F 5/06 FY 06/07 FY 07/08 FY 07/08 FY I sed Revised I Adopted Revised Proposed 4 5 5 5 5 7 9 11 it 12 9 9 14 20 20 10 10 10 12 12 2 2 2 2 2 1 1 2 2 2 1 1 1 1 1 4 7 8 8 8 1 1 1 1 1 1 2 3 3 3 0 1 1 1 1 Total Full -Time 28 36 46 52 53 Total Part-Time 2 2 2 2 2 Total Temporary 10 10 10 12 12 Total General Fund 40 48 S8 66 67 WATER /SEWER F Water 4 5 5 5 5 Wastewater 3 2 2 2 2 Utility Billing 1 1 2 2 2 Total Full -Time 8 8 9 9 9 Total Part-Time 0 0 0 0 0 Total Water /Sewer Fund 8 8 9 9 9 • it 1 Administration Total Full -Time Total Part-Time Total Economic Development Corp. Subtotal All Funds Full -Time Subtotal All Funds Part -Time Subtotal All Funds Temporary TOTAL ALL FUNDS 2 2 2 2 2 2 2 1 1 1 0 0 1 1 1 2 2 2 2 2 38 46 56 62 63 2 2 3 3 3 10 10 10 12 12 50 58 69 77 78 Town of Prosper TOWN OF Fiscal Year 2008 - 2009 SP ER Proposed Budget CONSOLIDATED STATEMENT A B C D 6,341,361 EXPENDITURES Projected Proposed Actual Budgeted Year End Budget 2006 -2007 2007 -2008 2007 -2008 2008 -2009 GENERAL FUND REVENUES 4,252,331 5,357,419 5,510,922 6,341,361 EXPENDITURES 3,644,432 5,357,419 5,396,040 6,289,129 NET REVENUES OVER (UNDER) EXPENDITUREq 607,9001 1 114,8821 52, WATER / SEWER FUND REVENUES 5,161,710 3,867,000 3,961,930 3,895,993 EXPENDITURES 3,888,951 3,851,914 3,801,689 3,965,346 NET REVENUES OVER (UNDER) EXPENDITURE_q 1,272,7591 15,0861 160,241 69 353 DEBT SERVICE FUND REVENUES 1,967,566 1,965,930 2,059,520 2,116,409 EXPENDITURES 1,700,752 1,866,948 2,028,517 2,059,959 NET REVENUES OVER (UNDER) EXPENDITURE2 266,8141 98,9821 31,0031 56,450 CAPITAL PROJECTS FUND REVENUES 1,255,386 206,100 690,026 220,000 EXPENDITURES 8,106,116 8,404,244 6,794,866 802,075 NET REVENUES OVER (UNDER) EXPENDITURE (6,850,730 )1 (8,198,144 )1 (6,104,840)1 582,075 PARKS FUND REVENUES 697,348 614,000 537,000 EXPENDITURES 32,770 35,000 - - NET REVENUES OVER (UNDER) EXPENDITURE4 664,5791 579,000 - 1 537,000 IMPACT FEES FUND REVENUES 1,961,462 2,223,500 871,000 856,000 EXPENDITURES 826,331 449,200 239,036 195,049 NET REVENUES OVER (UNDER) EXPENDITURE4 1,135,131 1 1,774,300 1 631,9641 660,951 ECONOMIC DEVELOPMENT CORP. REVENUES 463,146 440,000 427,725 363,333 EXPENDITURES 176,269 319,066 678,751 337,355 NET REVENUES OVER (UNDER) EXPENDITUREq 286,8781 120,934 (251,026)1 25,978 INTERNAL SERVICE FUND REVENUES - - - 33,480 EXPENDITURES - - - 33,480 p,14SPER Town of Prosper FY 2008 - 2009 Town Proposed Budget General Fund Summary Fund Balance / Reserves GENERAL FUND REVENUES Taxes: Property Sales Franchise Licenses, fees, and permits Charges for services Grants Investment Income Fines, warrants and seizures Contributions Miscellaneous EXPENDITURES Current: General Government Police Department Fire Department Streets Parks and Recreation Court Inspections Engineering Planning Communications Capital Outlay $ 1,112,082 $ 2,179,403 $ 2,263,000 Proposed $ 1,207,541 FY 06107 FY 07108 FY 07 / 08 FY 08 109 1,003,045 Actual Budgeted Projected Budget GENERAL FUND REVENUES Taxes: Property Sales Franchise Licenses, fees, and permits Charges for services Grants Investment Income Fines, warrants and seizures Contributions Miscellaneous EXPENDITURES Current: General Government Police Department Fire Department Streets Parks and Recreation Court Inspections Engineering Planning Communications Capital Outlay $ 1,112,082 $ 2,179,403 $ 2,263,000 $ 2,884,060 $ 1,207,541 $ 1,202,000 $ 1,102,900 $ 1,003,045 $ 304,284 $ 269,065 $ 285,232 $ 299,494 $ 1,078,345 $ 1,144,950 $ 1,145,334 $ 1,055,785 $ 155,717 $ 148,820 $ 163,200 $ 159,700 $ - $ 184,000 $ 150,800 $ 341,550 $ 134,275 $ 62,430 $ 95,200 $ 100,200 $ 128,591 $ 120,000 $ 191,000 $ 191,875 $ 418,254 $ 562,771 $ $ 131 ,497 $ 46,750 $ 114,256 $ 106, 150 Total Revenues $ 4,252,331 $ 5,357,419 $ 5,510,922 $ 6,141,859 $ 719,322 $ 912,461 $ 891,896 $ 872,018 $ 944,573 $ 1,196,475 $ 1,157,941 $ 1,482,547 $ 997,050 $ 1,367,129 $ 1,387,190 $ 2,023,059 $ 177,028 $ 285,059 $ 286,465 $ 298,482 $ 59,699 $ 200,441 $ 184,351 $ 260,483 $ 418,254 $ 562,771 $ 553,378 $ 611,974 $ - $ 130,716 $ 176,926 $ 175,926 $ 189,059 $ 288,288 $ 373,883 $ 360,805 $ 139,447 $ 414,078 $ 384,010 $ 155,620 Total Expenses $ 3,644,432 $ 5,357,419 $ 5,396,040 $ 6,260,914 Excess / (Deficit) $ 607,900 $ - $ 114,882 $ (119,055) OTHER FINANCING SOURCES(USES) Capital Leases $ - $ - $ - $ - Transfers In $ - $ - $ - $ 199,502 Transfer Out $ - $ $ $ (28,215} Total Other Financing Sources (uses) $ - $ - $ - $ 171,287 Net change in fund balances Fund Balance, beginning (as stated) Fund Balance, ending Balance of Unrestricted Funds 25% Reserve 10% Contingency Amount over / (under) Reserve Actual Reserve % $ 607,900 $ - $ 114,882 $ 52,232 $ 2,485,265 $ 3,093,165 $ 3,093,165 $ 3,208,047 $ 3,093,165 $ 3,093,165 $ 3,208,047 $ 3,260,279 $ 3,093,165 $ 3,093,165 $ 3,208,047 $ 3,260,279 $ 911,108 $ 1,339,355 $ 1,349,010 $ 1,565,229 $ 364,443 $ 535,742 $ 539,604 $ 626,091 $ 1,817,614 $ 1,218,068 $ 1,319,433 $ 1,068,959 84.87% 57.74% 59.45% 52.07% C3 S", V " P CEF P ri Town of Prosper FY 2008.2009 Town Proposed Budget Public Works Fund Summary Net Assets / Reserves WATER / SEWER Fl OPERATING REVENUES Water and Sewer charges $ 2,065,819 $ Proposed $ FY 06/07 FY 07108 FY 07108 FY 08109 $ Actual Budgeted Projected Budget WATER / SEWER Fl OPERATING REVENUES Water and Sewer charges $ 2,065,819 $ 2,961,480 $ 2,386,000 $ 2,486,600 Sanitation charges $ 358,543 $ 348,000 $ 390,000 $ 424,900 Water and Sewer connections $ 426,659 $ 400,000 $ 400,000 $ 200,000 Service initiation fees $ 592,963 $ 25,520 $ 668,980 $ 688,200 Miscellaneous $ 33,423 $ 51,000 $ 31,950 $ 3,293 Total Operating Revenues $ 3,477,407 $ 3,786,000 $ 3,876,930 $ 3,802,993 NON -OPERATING REVENUES Interest Income $ 131,516 $ 81,000 $ 85,000 $ 93,000 TRANSFERSIN Operating transfers $ 873,395 $ - $ - $ - Transfers in from other funds 679,392 $ - $ - $ Total transfers in $ 1,552,787 $ - $ - Total Revenues $ 5,161,710 $ 3,867,000 $ 3,961,930 $ 3,895,993 OPERATING EXPENSES Personnel services $ 481,840 $ 526,401 $ 525,505 $ 546,229 Materials and supplies $ 353,663 $ 838,563 $ 1,870,914 $ 1,846,360 Contractual services $ 2,096,047 $ 2,102,290 $ 1,088,270 $ 1,368,530 Amortization $ 16,547 $ 17,000 $ - Depreciation $ 284,291 $ 300,000 $ 300,000 $ - Total Operating Expenses $ 3,232,388 $ 3,767,254 $ 3,801,689 $ 3,761,119 NON -OPERATING EXPENSES Interest expense and fiscal charges Net Income (loss) before operating transfers TRANSFERS Transfers out for Internal Service Fund Transfers out for capital assets $ 656,563 $ 84,660 $ - $ - $ 1,272,759 $ 15,086 $ 160,241 $ 134,874 $ - $ - $ - $ (4,725) $ $ - $ - $ (199,502) Total transfers $ - $ - $ - $ (204,227) Change in Net Assets(Loss) $ 1,272,759 $ 15,086 $ 160,241 $ (69,353) Net Assets, beginning (as stated) $ 6,617,771 $ 7,890,530 $ 7,890,530 $ 8,050,771 Net Assets, ending $ 7,890,530 $ 7,905,616 $ 8,050,771 $ 7,981,417 Operating 16% Reserve $ 517,182 $ 602,761 $ 608,270 $ 601,779 Capital Replacement Reserve per Workplan $ 231,902 Total Reserves $ 833,681 P PER Town of Prosper FY 2008 - 2009 Town Proposed Budget Debt Service Summary DEBT SERVICE FUND REVENUES Taxes: Property $ 1,875,901 $ 1,940,430 $ 2,032,120 $ 2,087,409 Investment Income (Interest) $ 91,665 $ 25,500 $ 27,400 $ 29,000 Total Revenues $ 1,967,566 $ 1,965,930 $ 2,059,520 $ 2,116,409 EXPENDITURES Debt Service: Principal $ 336,553 $ 805,192 $ Proposed $ FY 06107 FY 07108 I FY 07108 FY 08109 I $ Actual Budgeted Projected Budget DEBT SERVICE FUND REVENUES Taxes: Property $ 1,875,901 $ 1,940,430 $ 2,032,120 $ 2,087,409 Investment Income (Interest) $ 91,665 $ 25,500 $ 27,400 $ 29,000 Total Revenues $ 1,967,566 $ 1,965,930 $ 2,059,520 $ 2,116,409 EXPENDITURES Debt Service: Principal $ 336,553 $ 805,192 $ 383,325 $ 445,800 Interest $ 489,858 $ 1,061,756 $ 475,244 $ 458,811 Transfers out for debt service $ (873,395) $ $ (1,008,612) $ Total Expenditures $ 826,411 $ 1,866 948 $ 858,569 $ 904,611 (1,155,348) Net change in fund balances $ 266,814 $ 98,982 $ 31,003 Excess of revenues over expenditures $ 1,141,155 $ 98,982 $ 1,200,951 $ 1,211,798 OTHER FINANCING SOURCES (USES) Administrative Fees $ (947) $ - $ (3,456) $ (4,000) Transfers in for debt service $ - $ - $ (157,880) $ - Transfers out for debt service $ (873,395) $ $ (1,008,612) $ (1,151,348) Total other financing sources $ (874,341) $ - $ (1,169,948) $ (1,155,348) Net change in fund balances $ 266,814 $ 98,982 $ 31,003 $ 56,450 Fund Balance, beginning (as stated) $ 314,558 $ 581,372 $ 581,372 $ 612,375 Fund Balance, ending $ 581,372 $ 680,354 $ 612,375 $ 668,825 P T SPER- Town of Prosper Proposed Budget Fiscal Year, 2008-2009 Capital Projects Fund Balance / Reserves CAPITAL PROJECTS REVENUES Proceeds From Bond Issuance Miscellaneous Grants Investment Income (Interest) Total Revenues EXPENDITURES Current: General Government Capital Outlay Total Expenditures Excess of revenues over expenditures OTHER FINANCING SOURCES (USES) Bonds Issue Bond issuance cost Due From Water Sewer Transfers In Transfers Out Total other financing sources Net change in fund balances Fund Balance, beginning $ 500,000 $ 755,386 $ 206,100 $ 365,026 $ 220,000 $ 1,255,386 $ 206,100 $ 365,026 $ 220,000 $ - $ - $ 452,467 $ - Proposed $ 8,404,244 $ FY 06107 FY 07108 FY 07108 FY 08109 Actual Budgeted Projected Budget CAPITAL PROJECTS REVENUES Proceeds From Bond Issuance Miscellaneous Grants Investment Income (Interest) Total Revenues EXPENDITURES Current: General Government Capital Outlay Total Expenditures Excess of revenues over expenditures OTHER FINANCING SOURCES (USES) Bonds Issue Bond issuance cost Due From Water Sewer Transfers In Transfers Out Total other financing sources Net change in fund balances Fund Balance, beginning $ 500,000 $ 755,386 $ 206,100 $ 365,026 $ 220,000 $ 1,255,386 $ 206,100 $ 365,026 $ 220,000 $ - $ - $ 452,467 $ - $ 8,106,116 $ 8,404,244 $ 6,342,399 $ 802,075 $ 8,106,116 $ 8,404,244 $ 6,794,866 $ 802,075 $ (6,850,730) $ (8,198,144) $ (6,429,840) $ (582,075) $ - $ - $ 325,000 $ - $ - $ - $ 325,000 $ - $ (6,850,730) $ (8,198,144) $ (6,104,840) $ (582,075) $ 19,114,768 $ 12,264,038 $ 12,264,038 $ 6,159,198 Fund Balance, ending $ 12,264,038 $ 4,065,894 $ 6,159,198 $ 5,577,123 IS P Town of Prosper N O F Proposed Departmental Budget PER Fiscal Year, 2008 -2009 Park Summary Fund Balance PARK FUND Proposed FY 06107 FY 07/08 FY 07108 FY 08 t 09 Actual Budgeted Projected Budget PARK FUND REVENUES Park Improvement Fees $ 388,000 $ 352,000 $ 208,897 $ 400,000 Park Dedication Fees $ 292,188 $ 255,000 $ 209,210 $ 100,000 Park Improvement - Interest $ 7,912 $ 2,500 $ 19,000 $ 18,000 Park Dedication- Interest $ 9,248 $ 4,500 $ 18,000 $ 19,000 Total Revenues $ 697,348 $ 614,000 $ 455,107 $ 537,000 EXPENDITURES General government -Parks Improv $ 31,697 $ 35,000 $ - $ - General government -Parks Dedication $ 1,073 $ - $ - $ - Total Expenses $ 32,770 $ 35,000 $ - $ - Excess / (Deficit) $ 664,579 $ 579,000 $ 455,107 $ 537,000 OTHER FINANCING SOURCES (USES) Total Other Financing Sources (uses) $ - $ - $ - $ - Net change in fund balances Fund Balance, beginning (as stated) Fund Balance, ending $ 664,579 $ 579,000 $ 455,107 $ 537,000 $ 416,498 $ 1,081,077 $ 1,081,077 $ 1,536,184 $ 1,081,077 $ 1,660,077 $ 1,536,184 $ 2,073,184 s P ,r SPER Town of Prosper Proposed Departmental Budget Fiscal Year, 2008 -2009 Impact Fees Summary IMPACT FEES FY 06/07 Actual FY 07108 Budgeted FY 07108 Projected Proposed FY 08 / 09 Budget - $ - General Government -water $ REVENUES IMPACT FEES $ - $ - $ - $ - General Government -water $ REVENUES $ - $ - $ - General Government-sewer $ 17,695 $ Impact Fees 34,036 $ - General Government - thoroughfare $ 11,529 $ - $ - Water $ 613,716 $ 648,750 $ 225,000 $ 225,000 Sewer $ 542,123 $ 494,250 $ 180,000 $ 175,000 Thoroughfare $ 697,259 $ 1,014,500 $ 385,000 $ 375,000 Investment income $ 108,365 $ 66,000 $ 81,000 $ 81,000 Total Revenues $ 1,961,462 $ 2,223,500 $ 871,000 $ 856,000 EXPENDITURES General Government $ - $ - $ - $ - General Government -water $ 17,695 $ - $ - $ - General Government-sewer $ 17,695 $ - $ 34,036 $ - General Government - thoroughfare $ 11,529 $ - $ - $ - Capital Outlay-water $ 126,974 $ 329,200 $ 100,000 $ - Capital Outlay-sewer $ 517,028 $ - $ 70,000 $ 195,049 Capital Outlay-thoroughfare $ 135,410 $ 120,000 $ 35,000 $ - Total Expenses $ 826,331 $ 449,200 $ 239,036 $ 195,049 Excess / ( Deficit) $ 1,135,131 $ OTHER FINANCING SOURCES (USES) Transfers In $ - 1,774,300 $ 631,964 $ 660,951 Transfers Out - $ Total Other Financing Sources (uses) $ - $ - $ Net change in fund balances $ 1,135,131 $ 1,774,300 $ 631,964 $ 660,951 Fund Balance, beginning (as stated) $ 1,401,989 $ 2,537,120 $ 2,537,120 $ 3,169,084 Fund Balance, ending $ 2,537,120 $ 4,311,420 $ 3,169,084 $ 3,830,035 14SPER P Town of Prosper FY 2008 - 2009 Town Proposed Budget Economic Development Corporation Net Assets i Reserves ECONOMIC DEVELOPMENT Proposed FY 06/07 FY 07/08 FY 07108 FY 08109 Actual Budgeted Projected Budget ECONOMIC DEVELOPMENT OPERATING REVENUES Sales Tax $ 401,647 $ 390,000 $ 406,153 $ 333,333 Interest $ 61,367 $ 50,000 $ 21,572 $ 30,000 Other Income $ 132 $ - $ - $ - Total Operating Revenues $ 463,146 $ 440,000 $ 427,725 $ 363,333 OPERATING EXPENSES Total Operating Expenses $ 176,269 $ 319,066 $ 353,751 $ 336,815 Transfer Out $ 325,000 $ 540 Total Expenses $ 176,269 $ 319,066 $ 678,751 $ 337,355 INCOME (LOSS) $ 286,878 $ 120,934 $ (251,026) $ 25,978 Change in Net Assets $ 286,878 $ 120,934 $ (251,026) $ 25,978 Fund Balance, beginning (as stated) $ 1,121,239 $ 1,408,117 $ 1,408,117 $ 1,157,090 Fund Balance, ending $ 1,408,117 $ 1,529,051 $ 1,157,090 $ 1,183,068 14SPER P Town of Prosper FY 2008 - 2009 Town Proposed Budget Internet Service Fund Fund Balance INTERNAL SERVICE FUND $ - $ - $ Proposed Fund Balance, beginning (as stated) FY 06/07 FY 07/08 FY 07108 FY 08109 I - $ Actual Budgeted Projected Budget INTERNAL SERVICE FUND $ - $ - $ OPERATING REVENUES Fund Balance, beginning (as stated) $ - $ Transfers In $ - $ - $ - $ 33,480 - $ - $ - $ - Total Operating Revenues $ - $ - $ - $ 33,480 OPERATING EXPENSES Total Operating Expenses $ Transfer Out _ Total Expenses $ INCOME (LOSS) S $ 33,480 $ 33,480 Change in Net Assets $ - $ - $ - $ - Fund Balance, beginning (as stated) $ - $ - $ - $ - Fund Balance, ending $ - $ - $ - $ - r = P TSPER. CAPITAL IMPROVEMENT PROJECTS LIST WATER (2008 -2013) NO. — PROJECT E INEE ESTIMATED FEE EST. ESMT. / CONSTRUCTION COMPLETION CONSTRUCTION TOTAL ANN'S'- POTENTIAL FUNDING ME DATE ESTIMATE WATER SYSTEM RAPROYEMENTS 1s t Road 2D" (US 380 - First) Developer i 20,000.00 $ WA 6 morva Complete S 457,850 OO S 477,850.00 S 1,425.00 2006 CO Bonds 1b vstStreet20" Free" Nichols S 142,25520 $ June -07 12 months Duna -08 S 1,18546000 S 1,327.716 DD S 210000 2006 CO Bonds 2 Preston Road Elevated Storage Tank Freese Nichols $ 347.04000 $ Jury -07 12 months July -08 S 2 892 000 00 S 3,239.040 00 $ 100000 2006 CO Bonds 3 Custer Road/ Fronmer Parkway IT Developer $ 37.38300 S WA 9 mortha March -08 S 338,81100 S 376.194 00 $ 1.475 00 Impact Fee Credit ($124,560) ImpW Fee Fund f3251 -11§1_ 4 Prosper Teal 20" (Wilson Creek - Custer Road) Developer $ 110 76500 $ WA 12 months March-08 $ 923,04000 S 1.03380500 S 1.95000 Impact Fee Credit (Future) 5 LandPlan 16" Developer $ 101.37600 $ WA 9 months TBD S 844 800 00 S 946.176 00 $ 2.000 00 Impact Fee Credit (Future) Sa ProspwTra112° Oevolopw $ 14,25600 S WA 6months December -07 S 118,800.00 $ 133,05600 S 37500 Developer 7 First Street 2D TBD S 94.40640 S TBD 12 months TBD $ 786.72000 $ 881.127 00 S 1,40100 Future Bond 98 Coleman 16' (Prosper Trani -18W N of PT) TBD $ 19.008.00 $ TBD 6 months TBD S 158.40000 S 177,408.0 S 40000 inlpad Fee Credt (Future) 9b Coleman 16" (1600' N of PT - 32W N of PT) TBD $ 19.00810 $ TBD 6 months TBD S 156,40000 $ 177.408 00 S 40000 Impact Fee Credit (Future) 9e Coleman 16" (320(Y N of PT - Preston Road) TBD $ 111,348 00 S TBD 6 months TBD $ 927.90000 S 1,039,24800 $ 2,12500 Impact Fee Credit (Future) Ida Colt Road 20" (1200' S of Prosper Trl - PT) Developer $ $ WA 6 months Complete $ 115,00000 $ 11500000 $ 75000 impact Fee Fund 11 BNSF 12" TBD S 102.902.00 $ TBD 12 morhs TBD S 857,520.00 S 960,42200 S 2,325.001 Fuzee Bond 12 First Street 16' Road - rod Road) TBD S 166,21100 S TBD 12 months TBD $ 1.385,100.00 S 1,551,312 00 S 3,22500 Impact Fee Cr"t (Future) 13 Expand UPP PS to 15 MGD & New 3 MG GST Freese Nofols $ 2,41800 00 S TBD 6 months TBD S $ 244,800.00 S Future Bond 148 =:N,.1 TBD $ 92.642 00 S TBD 12 months TBD $ 772,020.00 S 864.66200 S 1,77500 Impact Fee CredO (Future) 14b US 38016" TBO S 77.220 00 i TBD 12 months TBD S 643,500.00 S 720,720.00 S 1,625.00 Impact Fee Credit (Future) 15 US3802d Presion Road) TBD $ 128.88000 $ TBD 12 moths TBD S 1.071,000.00 $ 1,202,88000 S 1,775.00 TIR2 16 Prosper Trail 1S- & 2 MG EST TBD $ 458,36fi 00 $ TBD 18 months TBD $ 3,819,720.00 S 4,278,085.00 i 2,10D.00 Future Bond 17 Dallas North Toliway 16' TBD $ 75,27600 S TBD 12 months TBD $ 627,300.00 S 702,57600 $ 1,47500 Impact Fes Credit (Future) 18 Dallas North Toilway 1,2' MM TBD S 34.64640 1 S TBD 12 months TBD S 288,720.00 S 323.367 00 $ 775.00 Impact Fee Credit (Futras) 19 US 380 i 6` TBD $ 93,906 00 $ TBD 12 months TBD S 782.55000 S 876 456 W $ 1.81250 Impact Fee Credit (Future) Revised 61&2008 Pape 1 of 4 CIPIProspadWlger and Saww CIP list 2005.2013 trh pi TOWN ER. CAPITAL IMPROVEMENT PROJECTS LIST WATER (2008 - 2013 Recently Completed 2006 - 2011 (On CIP Plan) 2012 - 2016 (On CIP Plan) 2017 - 2026 (On CIP Plan) Summary of Necessity: The rtecsssibr of die prapcts 6sbd are taloen from the approved Tom of Prosper Capdal Improvartterit Plan and Town staff racanntandabon based on proletied developmert Revised 818)2008 Pape 20(4 MProsperlWater and Sewer CIP List 20"13 )ft PROJECT FNCJNFGR ___ U MATEDFEE EST. ESMT. / M. DA CCI NSTRUCTM CdiMPIETION CONS7RUMM TOTAL ROW A WATER SYSTEM YPROVEMENTS YO US 38016" telds Drivel TBD $ 163,62000 $ TBD 12 months TBD $ 1,363.50000 S 1,527,120.00 S 3,225.00 Impact Fee Credit (Future) 21 Custer Rose 30 8 UPP PS to 20 MGD Hhjmn TBO $ 146,102 00 S TBD 24 months TBD $ 1,217,52000 $ 1,363.622.00 S 1,450.00 Future Bond 228 Prosper Trail Elevated SkmW Tank WA i i 100 00000 TBD 12 months TBD S S 10000000 S 2004 CO Bonds 22b Propw Trail 20' (1200' W of Colt- Colt) ""oper i i WA 8 rnorths TBD $ 130,000.OD $ 130,000.00 $ 850.00 Wgnd Fee Fund 23 Custer Road 24 TBD $ 93,13900 $ TBD 12 months TBD $ 776,16000 S 869,29900 S 1,225.00 Future Bond 26 Legacy Drive 16" (First Street - US 3801 TBD $ 69,46600 S TBD 12 months TBD $ 578,880 00 $ 648,346 00 $ 2,92500 Future Bond 27 Legacy Drive 12" TOD $ 74,736,00 S TBD 12 months TBD $ 622,8DD.00 $ 697,536,00 $ 1,875.00 Impact Fee Credit (Future) 32 Fields Road 16"& FW*ap Road 38" TBD S 333,97900 S TBD 12 martths TBD $ 2.783,160 00 S 3,117,139.00 S 3,200.00 Impact Fee Credit (Future) 35 Fields Road 20 b Prosper Trar 112" TBD $ 196634 00 E TBD 12 months TBD It 1.855,280 00 S 1,853,91400 S 4-175 00 Impact Fee Credit (Femxe) TOTAL 3,571,372A0 S 10/,OOOAO = 21,2i1,l11A0 :31,161,215.00 fi/1,912Q0 Do CO Hand 5.044.GWOU EM c 5 15.731W00 Recently Completed 2006 - 2011 (On CIP Plan) 2012 - 2016 (On CIP Plan) 2017 - 2026 (On CIP Plan) Summary of Necessity: The rtecsssibr of die prapcts 6sbd are taloen from the approved Tom of Prosper Capdal Improvartterit Plan and Town staff racanntandabon based on proletied developmert Revised 818)2008 Pape 20(4 MProsperlWater and Sewer CIP List 20"13 )ft Pr TOWN ER. CAPITAL IMPROVEMENT PROJECTS LIST WASTEWATER (2008 -2013) Recently Compteted 2006 - 2011 (tan GP Plan) 2012 - 2016 (On CIP Plan) 2017 - 2026 (On CtP Plan) Summary of Naassibr The necessity of the proge is listed ace taken from the approved Tom of Prosper Capital trnprorerrhent Plan and Town staff roodmrendistan based on proleced developneent Rewsed &6/2008 Pape 3 014 CWilPMaWWaler and Sewer CIP Ust 2006 -2013 AS PROJECT ENGINEER ESTIMATED FEE EST. ESMT. / IUD CONSTRUCTION COMPLETION COlt37RMMON TOTAL POTENTIAL FUNDING DATE TIME A E ASTEWATER SYSTBA WIPROVEMENTS Wastewater Treatment Plert DecaaNssion Freese Nichols i 25.00000 3 Apni % 9 months Jarwvy-09 3 50000000 S 525.000 00 S - Fuhra Bond 2 15'71 8"121"!27" Gravity Man (SB4) Developer S 150.00000 S WA 9 months December -07 S 1.250000 DO S 1,400.000 00 S 97800 Impact Fee Credit (Future) 2b 15'718 "121727" Grarvny Man (SB4) TOO $ 143 774 00 $ WA 9 months TOD S 1,198 -11600 S 1.341 89000 $ 1 537 50 Impact Fee Credit (Future) 3 10'712" Gravity Man (SB4) Developer $ 45.95200 S WA 9 months December -07 S 382.934 00 S 4288th 00 S 64500 Impact Fee Credit (Future) 4 10" Face Warn Realignment (SB5) TOD $ 31,11500 S TOD 9 months TOD S 259290 00 S 290.405 00 $ 30000 2004 CO Bond 5 15 "118' Gravity Man (SB6) (To be constructed by Torn Clark or Tavlorl TOO S 107.70000 S WA 9 months TOD S 897.504 00 S 1.005 204 00 S - Impact Fee Credit (Future) 6 10" Gravity Man (SB6) ag be constructed try Tom Clark at Tavlorl TOD $ 40.709 00 $ WA 9 months TOO S 339 24000 S 379.949 00 S 621 DO Impact Fee Credit (Future) 9,10 10718" Gravity Man (S66) constructed Developer S 208.99500 S WA 9manMhs 1211r2(108 - Portion to KhrL $ 1 74182000 S 1.95061500 $ 296700 2004 CO Bond ($975,000) 12 12" Gravity Main (SBS) TOD 3 42,311 00 S TOD 9 months TOD S 352,59000 S 394.901.00 S 60375, TtRZ 18 10721- Gravity Man (S83) TOD S 200,487.00 S TBO 9 maths TOD S 1.670,722 00 S 1,871,209.00 S 2,167.50 Impact Fee Credit (Futuna) 17 10"/12'118" Gravity Man (S83) TOD 3 159,224AO 3 TOO 9 maths TOD S 1.326,871 00 S 1,486,095.00 S ZlBS.65 WOW Fee Credit (Future) 22 New 2 25 MGD Hwy 380 Uft Station and Force Man (SMi TBD S 176,779.00 S TOD 9 months TOD 3 1.489,825 00 S 1,660,604.00 S 600.00 TIRZ 23 10. 1127/15.118" Gravity Man (SB4) TOD S 178701 00 S TOD 9 maMhs TOD i 1.489177.00 S 1,667.878 OD $ 2341 05 TIRZ 30 24 "127"142" Grwly Man (SB3) TOO 3 497.88300 S TOD 12 months TOD S 4,147.357,00 S 4,645,040.00 S 2,761.35 Impact Fee Credit (Future) 32 10"112"11 5" Gravity Main (SB3) TOD S 201.004 00 $ TOD 12 months TOD $ 1,675,037 00 S 1,878041 OD S 2,760 30 Impact Fee Credit (Future) TOTAL i 2,186,434.00 S S 18,226,2" S 20,631,T1TAO 526,468.10 2W4 GO Bond F .2"01"o 206 GO Uond rulturlit Bona 10 Dovoiftpor F" crocw 15,409,929,00 0 r" Puna Recently Compteted 2006 - 2011 (tan GP Plan) 2012 - 2016 (On CIP Plan) 2017 - 2026 (On CtP Plan) Summary of Naassibr The necessity of the proge is listed ace taken from the approved Tom of Prosper Capital trnprorerrhent Plan and Town staff roodmrendistan based on proleced developneent Rewsed &6/2008 Pape 3 014 CWilPMaWWaler and Sewer CIP Ust 2006 -2013 AS P TOWN EIS. CAPITAL IMPROVEMENT PROJECTS LIST THOROUGHFARE (2008 -2013) PROJECT ENGINEER ESTIMATED FEE EST. ESMT. / M CONSTRUCTION COMPLETION CONSTRUCTION M& ,- POTENTIAL FUNDING TE ESTIMATE TMOROMfIFARE SYSTEM IMPROVEMENTS Prosper Trail Ww wwig TBD S 365,039.00 S 200,000.00 TBD 9 n nft Dsos+dfa•08 S 3,85438800 S 4,435,425.00 S 3,411180 FUNS haw! (44217,713) First Streel Wi Wft M S 62,1220 S 15400.00 TBO 12 onts Noae-09 $ 2,621, .00 S 3,33,3"00 S 2,31000 Fla � (31,516,672) Curt Road Wafermp Street - US 38DI T80 $ 194,16400 S 150,000.00 WA 10 Months August -9 $ 1,941,642.00 S 2,285,806.00 S 1, 54800 Fulure Bond (11,112.903) Town Road Rehab 2008 Prosper Public Works S - S TBD 9 moths TBD S 489.87400 S 461187400 4 3190000 2008 CO Boat Town Road Rehab 2009 Prosper Pudic Wake S S TBD 6 moriti TBD S 500,000.00 S 500.000.00 4 3.50000 2008 CO Boa! Town Road Rehab 2010 Prosper Public Works S - i TBD 6 WON" Teo 4 500.000.00 S 500,000.00 S 3,500 00 Future Boa! Town Road Rehab 2011 Prosper Pudic Works S i TBID 6 madhs TBD 4 500,000 00 S 500,000.00 S 3,50000 FuNe Bond Town Road Rehab 2012 Prosper Public Wales 3 S TBD 6 months TBD $ 500.000.00 S 500,000.0 S 3,50000 Future Baal Prosper Trail (Legacy Drive to Dallas North Developer $ 200.00000 S WA 9,1041 TBD $ 1,900,000.00 S 2,000,000.00 S 1,64800 lapaet FN C" {fuNe) Legacy Drrvs {Prosper Trail to f islmner Road) Developer 3 200.00400 S WA 9 mordhs TED $ 1.1100.000.00 S 2,000,000.00 $ 1,54600 hrpatx Fes Credit {FUtrre) okir wn (Prosper Tram to Nrgh Setrool) T60 4 175,000.00 S TOO 9 nrorMhs TBD 4 1.575,00400 4 1,750,000.00 S 1,996.00 Future Bond Preston Road Inrpmvmnw is TBD S 90,000.00 $ 100,000,00 TOD 12 months TBD 4 920,000.00 S 1,100,000.00 $ 1,00000 Future Boras Fast Street (Colt Road to Custer Road) TBD $ 504000.00 S 250,000 00 TBD 12 morr6u TBD S 6.500.000.00 S 7.254000 W S 1.84800 Impact Fee Credit (Fus re) Legacy Drive (Fishtrap to US 38M TBD $ 375,000.00 $ 25000D W TOD 12 mor*w TBD 4 3,375,000.00 S 4,000.00400 S 1, 81800 FuNe Bond FM 1461 (Preston Road to Dallas North Toltway) TBD $ - S - TBD 12 moms TBD $ 2.500.00000 S 2,500.00400 S A 500 00 Fulrre Bond TOTAL $ 2,371,32600 f 1,100,000.00 f 29,333,124.00 f 32,024,449.00 727 2111111.00 cam Coullty 487750.00 4 11250 .00 wry or t1 .mft The necessity of aw pro" Iwed am taken from the approved Town of prosper capital Improwmarx Plan and town seat risom endaMar based on protected darvetop rierit Revised 81812008 Page 4 of 4 CIPWM paAWMer end Sewer CIP List 2006-2013 As