Loading...
7A - Master Plan input - Fund 118 analysisFUND 118 (.25 CENT SALES TAX) ANALYSIS PARKS AND RECREATION ADVLSORY BOARD EXECUTIVE SUMMARY January 20, 2005 Prepazed by : Jim Reasor and Kate Bernhardt Introduction• This analysis addresses the ballot language commitments for the .25 cent sales taa~ increase at the mid-point of the 20 yeaz sales tas period (1995-2015). It also provides information to support the Master Plan Update conversations about future spending priorities for both Fund 118 (.25 cent sales tax 1995-2015) and Fund 230 (Permanent Pazks and Recreation Fund 2005-2015). The initial work on this analysis has revealed several areas which will require additional study. Staff has not completed the discussion or analysis of this information and is presenting it to the Boazd at this time as a"work in progress information and discussion" item. The Board's comments will be considered as staff moves forward with further analysis of this information in prepaza[ion for Board discussions related to Parks and Recreation Master Plan update. Snreadsheets: PRAB-A A hypothetical model of categorized funding anticipated from the .25 cent sales t~ (Fund ll8) based on departmental priorities identified in the 1995 ballot materials PRAB-B Documentation of actual Fund 118 expenditures 1996-2004 PRAB-C Documentation of actual sales ta~c revenues (1996-2004) and projected revenues(2005-2015) PRAB-G1 Graph of PRAB-C PRAB-D Specific tracking of expenditures for major capital items identified in the ballot language PRAB-E List of projects accomplished 1996-2004 PRAB-F Pie Chart, Fund 118 Expenditures 1996-2004 PRAB-G Pie Chart, Debt Service Expenditures 1996-2015 Points of Interest and Comments: 1. Have we met the commitments of the sales tas ballot language? • land acquisition, yes • recreation facility renovations, yes • park development, maybe • new pazk development maintenance, no 2. Do we agree that completing °total required" expenditures on the major capital items identified io the ballot language constitutes completion of the ballot commitment? Agenda Item #VII-A, Page 1 3. .25 cent sales tax revenue collected from 1996 to 2001 exceeded projections by $2,000,000, however collections and projections from 2002-2015 indicate that the department will receive a net of $10,800,000 less than anticipated from this source. 4. Between 1996 and 2005, the department will have expended ll 8 funding for major capital projects and urban pazk renovation and refurbishment in amounts that meet or exceed the identified total in the ballot language. Do we want to allocate any additional sales tax money to these categories of spending over the next 10 yeazs? 5. Parks Maintenance expenditures 2005-2015 will exceed projected sales tax projections for this category by $1,500,000, although expenditures, 1996-2005, were less than the total possible allocation. Sales tax maintenance dollazs are currently being used to maintain the entire park system as opposed to only the newly acquired and developed acres (1996-2004) associated with the sales tax commitment. Sales tu~ maintenance dollars have also been utilized to offset General Fund reductions over the past several yeus. The City acquired 397 acres between 1996 and 2005 using sales talc funding and other resources. The 1995 sales tax ballot language identified the need to acquire 126 acres, based on the approved Pazks and Recreation Master Plan goals. Essentially the City acquired three times as much property as anticipated which has significantly impacted maintenance requirements and funding needs. Because sales taac dollars are being used to maintain more acres acquired than anticipated and to maintain the entire pazk system, specific projects identified to be maintained by sales tax dollars aze not being adequately maintained. While capital dollars are available for additional pazk development, development has been halted or delayed due to staff reported insufficiency of maintenance funding and resources. • How does this address the Sales Taac ballot commitment? • Should sales tax identified projects receive a higher level of maintenance than other park properties? • How should we fund and manage Parks Maintenance for: a) the existing park system b) any additional park development? • What further research, analysis, and reporting would be useful to address both the maintenance funding deficiencies, potential efficiency opportunities, and to obtain additional General Fund or other sources of funding as the economy recovers? 6. Recreation Renovation and Refurbishment sales ta~c dollars currenUy exceed original ballot language projections by 152°Io (2.5 times). In addition to the Fund 118 dollazs, Recreation R and R receives $130,000 annually from Fund 230. • How does this address the Sales Ta~c ballot commitment? • With Master Plan consideration of departmental needs, is this the appropriate level of funding desired? • Is a more detailed study of this subject needed, and if so, what would be included? Agenda Item #VII-A Page 2 2 7. Pazks and Recreation Staff 118 expenditures (Administration, Planning, Pazks Maintenance, Conservation Team, and Recreation) cunently represent 25.6% of total 118 revenues. By 2015, the anticipated Fund 118 salazy requirements will be$1,793,752. The sales ta~c dollars have been used to "grow° the entire department and Pazk and Recreatio^ system along with addressing some of the shortfalls due to General Fund reductions. • How does this address the Sales Ta1c ballot commitment? • How will these positions be funded when ffie sales tax is retired in 2015? • Is a more detailed study of this subject needed, and if so, what would be included? 8. The Pazks and Recreation and Open Space 2001 Agreement designated limited 118 funding for the Conservation Team through 2015 and shifred, all General Fund dollars associated with Parks and Recreation Mountain Pazks Division to Open Space. • As a result of the Mountain Pazk to Open Space transfer agreement, the full time salazies of this entire division are funded with 118 dollazs which will expire in 2015. How should we prepaze for funding this division afrer 2015? Next Stens Staff will review these issues in more detail over the next month. Projections will be created for both Funds 118 and 230 in order to determine what amount of discretionazy money might be available each year based on different "fixed" funding assumptions and how it might be allocated. The results of this work will be incorporated into the Master Plan update discussions with the Boazd. Attachments• PRAB-A 1995 Ballot Funding (.25 Sales Tax Fund) Projections and Requirements PRAB-B 1995 Ballot Funding (.25 Sales Taa~ Fund) Expenditures PRAB-C 1995 Ballot Funding (.25 Sales Tax Fund) Actual and Projected Revenues PRAB-C-1 Graph of PRAB-C PRAB-D 1995 Ballot Funding (.25 Sales T~) Capital Funding Analysis per Ballot Language PRAB-E 1995 (.25 Sales TaJC) Major Capital Projects by Category PRAB-F Pie Chart, Fund 118 Expenditures 1996-2004 PRAB-G Pie Chart, Debt Service Expenditures 1996-2015 Agenda Item #VII-A Page 3 DRAFT PRAB-A Ci otBOUlder Parks antl Recreation De rtment 7995 Ballot Funtlin (.25 Sales Tax Fund) Pro'ections and Requirem ents As of 12-142004 Cate o ' Total Amountto Bond 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2075 Totals Ac uisition - u to 16 acres ot Nei hborhootl Parks 4,500,000 4,500,000 Acquisihon - u to 10 acres for Pocket Parks 4,900,000 4,900,000 A msi6on - minimum of 100 acres for a Qt Park 18,000,000 18,000,000 Ac uisition - 350 acres (or Mountain Parks Bond Fund Totals 2,000,000 29,400,000 2,000,000 29,400 000 Cat o Required Funding - Annual Basis and Cumulativa ToWI Funtling Tier Vear Ballot Commitment Met 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2015 7otals Mountain Parks / Conservation Mountain Parks Environ Etlucallon Mountain Parks On oin Mountain Parks R& R- Trails 130,000 per ar 20,000 per ar 768,000 er ar 3 1 2 130,000 20,000 168,000 133,900 2Q600 773,040 737,917 21,218 178,231 142,055 2T,855 183,578 146,316 22,510 189,OB5 150,706 23,185 194,758 155,227 23,887 200,601 159,884 24,597 206,619 164,680 25,335 212,817 769,621 26,095 219,202 227,956; 35,070 294,589 3,493,149 537,407 4,514223 Total 378,000 327,540 337,366 347,487 357,912 368,649 379,709 391,700 402,833 474,918 557,615 8,544779 Recreation Facilities R 8 R- Recreation Facih[ies R 8 R- Pool Improvements Development-RecreationCenterlmprovements 178,000 er ar 277.000 per un~il fundin lotals 3,400,000 i50.000per untilfundin totals2,000,000 2 2 3 2006 2007 178,000 277,000 150,000 183,340 285,310 154,500 188,840 293,869 159,135 194,505 302,685 163,909 200,341 311,766 168,826 206,351 321,119 173,891 212,541 330,752 179,108 218,918 340,675 184,461 225,485 350,895 190,016 232,250 361,422 195,716 312,124 485,721 263,026 4,762,927 7,443,094 4,030,556 Development - New Recreation Facilities 200,000 per until funtlin totals 2,250,000 3 2005 200,000 206,000 212,180 218,545 225,102 231,055 238,810 245,975 253,354 260,955 350,701 5,374,075 Park Develo ment Development - New Nei hborhood Parks Development - New Pocket Parks Development - Existin Pocket, Nei hborhootl antl Communi Parks 200,000 per unfil fundin totals 2,400,000 120,000 per unfil fundin [otals 1,500,000 200,000 per until fundin totals 2,400,000 3 3 3 2006 2006 2006 200,000 120,000 200,000 206,000 123,600 206,000 212,180 127,308 212,180 218,545 131,127 218,545 225,102 135,061 225,102 231,855 139,113 231,855 I 236,810 143,286 238,810 245,975 147,585 245,975 253,354 152,012 253,354 260,955 156,573 260,955 350,701 210,421 350.701 5,374,075 3,224,445 5,374,075 Urban Park Renovation antl Refurbishment Renova6on & Refurbishment- Urban Parks 130,000 per untd fundm totals 1,500,000 2 2006 130,000 133,900 137,917 142,055 146,316 150,706 I 155,227 159,884 164,680 169,621 227,956 3,493,149 Park Maintenance Parks Maintenance - New Pocket Park srtes Parks Maintenance - New Nei hborhootl Park sites Parks Maintenance - Existin Nei hborhood Park si~es 40, 000 er ar 64,000 r ar 67,000 per ar 3 3 3 40,000 64,000 67,000 41,200 65,920 69,010 42,436 67,898 71,080 43,709 69,935 73,213 45,020 72,033 75,409 46,371 74,194 7Z,671 47.762 76,419 80,002 49,195 78,712 82,402 50,671 81,073 84,874 52,191 83,505 87,420 70,140 112,224 117,485 1,074,815 1,719,704 1,800,315 Parks Mamlenance - CommunR Park ParksMaintenance-Cit Park Total: Parks Maintenance 210,000 per ar 200,000 r ar 3 1 0 200,000 371,000 0 206,000 382,130 210,000 212,180 603,594 216,300 218,545 621,702 222,789 225,102 640,353 229,473 231,855 659,563 236,357 238,810 679,350 243,446 245,975 699,737 250,757 253,354 720,723 258,274 260,955 742,344 347,098 350,70'I 997,649 4,917,031 5,374,075 14,885,940 Miscellaneous Ballot Fundin Histoncal and Cultural Facditles QvicCenterComplex 50,000 r ar 75,000 er ar 4 2 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 50,000 75,000 1,000,000 1,500,000 Debt Service 1 2.544,978 2,544,978 2.544.978 2.544.978 2,544.978 2,544,978 2.544.978 2.544,978 2.544.978 2,544,978 2.544.978 50.899.561 DRAFT PRAB-A Ci of Boulder Parks and Recreation De aftment 1995 Ballot Fundi~ .25 Sales Tax Furtd Pr ' ctioas and R uirements As of 12-742004 Fu tlin Not Identified b Ballot Lsn ua e Administration - - ' - - - Plannin ' - - - - Recreation - - - - - - - Cost Allocation TotalBallotS cifiedFundin 4,813,978 4,876,298 5,154,548 5,229,085 - 5305858 ' 5,384,934 - 5,466,3831 " 5,550,275 - 5,636,684 - 5725685 - 6,776,593 77,919,906 Notes: 1. Annual funding amounts were assumed to increase b 3% each year 2. Historical 8 Gultural and Civic Center Complex fundin is not increased annuall . The funded amount remains the same each year. ' 3. Ballot information did not specify funding for cost allowtion or operatin fundin related to Plannin , Administration, Recreation, or Conservation. d The Year column indicates the ear thet the accumulated fundin total would have been met the re uired fundinc. ' DRAFT City of Boulder Parks and Recreatfon DepaRment 7995 Ballot Fundin (.25 Sales Tax Fund) Expenditures Expenditures from 1996 Throu h November 15, 2004 Cat o Amount Re u ired to Bond Total Bonded Acquisition - up to 16 acres of Neighborhood Parks 4.500,000 397,599 Acquisition - up to 10 acres for Pocket Parks 4,900,000 2,939,588 Acquisition - mmimum of 100 acres for a City Park 18,000,000 18,870,463 Arquisition - 350 acres for Mountain Parks 2,000,000 1,979,531 Refundin Bond Fund Totals 29,400,000 6,014,545 30,201,726 Cate o 7996 1997 1998 ~999 2000 2001 2002 2003 2004 ToWI Mountain Parks I Conservation Mountain Parks - Combined 118,786 266,511 281,246 333,968 317,639 46,495 4,703 0 0 1,369,348 O eretions and Maintenance - Conservahon Total: 118,786 266,571 281,246 333,968 317,639 286,550 333,045 338,715 343,418 352,574 352,574 216,910 216,910 1,194,749 2,564,097 Recreation Facilities R& R- Recreation Facilities 0 40,073 819,002 777,103 573,850 793,737 298,767 598,186 488,520 3,900,712 R& R- Pool Improvements 54,812 107,273 1,210 2,339 30,163 145,339 0 90 0 341.226 Development - Rec Cenler Improvements Develo ment - New Recreation Facilities 430.043 592,007 92,273 425,905 1,681,532 20,377 233,396 t08,662 282,018 813,284 2,050,374 28,689 7,405,786 0 388,610 0 0 0 12,564,034 1,988,924 Total 1,076,862 665,524 2,522,121 1,121,502 7,699,375 3,078,139 7,704,547 986,886 18,794,896 Park Develo ment Development - New Nei hborhood Parks 0 0 5,030 3,317 35,138 9,939 10,311 85 0 63,820 Development - New Pocket Parks Development - Existin Neighborhood and Pocket Parks Develo ment-Existin Communi Park Total: 0 0 0 0 1,412 165,989 163,785 33'1,786 12,629 400,590 48,007 466,256 29,632 443,836 949,521 1,426,306 302,715 291,244 152,462 781,559 179,968 42,248 0 232,155 1,086.988 2,569 0 1,099,868 345,570 158,351 0 503,946~ 60,000 0 28.102 2,018,854 1,504,827 1,341,877 4,929,378 Urban Park Renovatlon and Refurbishment Renovation & Refurbishment - Urban Parks 0 10,661 181,283 237,762 92,044 451,109 106.685 353,811 14.493 1,447,849 Parks Maintenance Operahons and Maintenance - Parks 3,072 204,594 305,761 148,103 542,237 705,480 5'13,908 747,056 3,170,211 O erahons and Maintenance - Forest 10,829 28,112 0 91,043 82,821 69,423 102,510 85,793 490,531 Total 0 13,901 232,706 305,761 239,146 625,058 794,903 616,418 832,849 3,660,742 Miscellaneous Ballot Fundin HistodcBCulturalFacilities 13,114 50,000 3,299 52,037 63,033 117,894 29,962 15,154 51,929 396,422 CivicCenterComplex 27.668 78,399 3,290 60,325 36,447 65,836 10,059 57,047 ~8,2~2 357,283 Debt Service 2,321,769 2,464,698 1,036,420 0 0 0 2,052,026 2,398,943 10,273,876 PRAB - B DRAFT Cate o 7996 199 1998 1999 2000 2001 2002 2003 2004 Total Fundin Not Identifled b Ballot Lan ua e Adminis[ratlon 106,330 152,689 390,257 216,671 113,616 158,829 '143,498 257,748 1,539,638 Plannin 0 43,082 81,993 279,737 264,606 213,269 286,532 246,882 1,416,101 Recreation 0 35,033 57,804 67,170 68,942 70,429 77,168 70,t92 446,738 CostAllocation 0 159.665 100,774 162.038 744,825 108,387 733,172 131.862 940,663 Wind Ga Loan 0 26,401 26,401 - - - - - 52,802 Total 706,330 416870 657,169 M5616 591,989 550,914 640,370 706,664 4,395,942 Total -.25 Sales Tax Ex enses 1,236,430 3,833,472 6,543,657 5,231,250 3,863,756 5,352,404 70,550,933 i 5,475,722 4,754,227 47,270,617 Total -.25 Sales Tax Revenues 4,98U,200 5,094,80U 5,333,4UU 5,872,6U0 6,183,700 6,014,200 5,46~,800 5.1T4,900 3,844,300 47,958,900 Notes: 'I. R& R- Recreation Facilities funding is used by FAM tor depaRment wide renovati on antl refur bisHment 2. Debt Service was not paid for several years after the Bond Refunding. 3. Cost Allocation was not charged to .25 Sales Tax fund until 1998. Cost Allocation expendNures are incurred to coverthe cost of citywide services, such as legal services, insurance, Finance, HR and IR. Cost Allocation expenditures are typically 3-4% of Fund Appropriations 4. Park Operalions and Maintenance expenditures for 2001 and 2002 are overstated by 5431,000 due to capital irrigation prqects. 5. Operations and Maintenance category contains both Personnel and Non-Personnel Expenses F. ~nn6 E:ne~dHures were not verified due to the chanoe in citywide Finance system in 1997. 1996 Amounts were~roduced b rior Mal t. PRAB-B DRAFT City of Boulder Parks and Recreation De artment 1995 Ballot .25 Sales Tax Actual and Pro ected Revenues As of December 14, 2004 A B C D E F Ori inal Sales Actual Sales Future Sales Annual Cumulative Accumulated Actual and Year Tax Pro"ection Tax Collections Tax Pro'ections Difference Sales Tax Difference Pro'ected Collections 1996 4,850,000 4,980,200 130,200 4,980,200 1997 4,995,500 5,094,800 99,300 229,500 10,075,000 1998 5,145,365 5,333,400 188,035 417,535 15,408,400 1999 5,299',726 5,872,600 572,874 990,409 21,281,000 2000 5,458,718 6,183,700 724,982 1,715,391 27,464,700 2001 5,622,479 6,014,200 391,721 2,107,112 33,478,900 2002 5,791,154 5,460,800 (330,354) 1,776,758 38,939,700 2003 5,964,888 5,174,900 (789,988 986,770 44,114,600 2004 6,143,835 5,153,000 (990,834 (4,064) 49,267,600 2005 6,328,150 5,222,000 (1,106,150) (1,110214) 54,489,600 2006 6,517,994 5,561,229 (956,765) (2,066,980 60,050,829 2007 6,713,534 5,845,614 867,920) (2,934,900) 65,896,443 2008 6,914,940 6,020,982 (893,958) (3,828,858 71,917,426 2009 7,122,389 6,201,612 (920,777 (4,749,635) 78,119,038 2010 7,336,060 6,387,660 (948,400 (5,696,035) 84,506,698 2011 7,556,142 6,579,290 (976,852 (6,674,886) 91,085,988 2012 7,782,826 6,776,669 (1,006,157) (7,681,044) 97,862,657 2013 8,016,311 6,979,969 (1,036,342) (8,717.386) 104,842,625 2014 8,256,800 7,189,368 (1,067,432) (9,784,819) 112,031,993 2015 8,504,504 7,405,049 1,099,455 10,684,274 119,437,042 130,321,316 44,114,600 75,322,442 (10,884,274) 119,437,042 Column A: Original sales tax coilection projedions based on a h pothetical assumption of consistent 3% annua l increases. Column B: Shows actual sales tax revenue collections b ear. Column C: Future pro ections for 2004 throu h 2008 are provided b the City of Boulder Bud et office. Additional revenues resulting from 29th Street redevelopment are included in 2005 to 2007. Projections for 2009 through 2015 based on the assumption of annual 3% increase. Column D: Indicates the early difference between ori inal pro'ections and actuaUfulure collections Column E: The total pro ected fundm discrepanc between ori inal 1995 projection and curtent pro ections. Column F: Total anticipated 25 Sales Tax revenues accordin to actual and revised future sales tax pro ections. PRAB - C .25 Sales Tax Fund Revenues Original Sales Tax Projections vs Actual/Revised Projections 9,000,000 8,500,000 8,000,000 7,500,000 a~ ~ 7,000,000 a~ > a~ ~ K 6,500,000 ~a H ~ ~ 6,000,000 ~ 5,500,000 5,000,000 4,500,000 4,000,000 PRAB - C-1 +Original Sales Tax Projection o Actual/Revised Sales Tax Collections ~ 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 Year DRAFT City of Boulder Parks and Recreation Department 1995 Ballot Funding (.25 Sales Tax) Capital Funding Analysis per Ballot Language As of 12-14-2004 Capital Funding Analysis per B allot Language Category Initial Mnual Funding Cumulative Required Funding Tier Actual Expenditures Ballot Requirements Expenditure Amount Over/(Under) Required Funding Recreation Facilities R& R- Pool Improvements Development - Recreation Center Improvements 277,000 150,000 3,400,000 2,000,000 2 3 341,226.00 12,564,034.00 3,400,000.00 2,000,000.00 Development - New Recreation Facilities 200,000 2,250,000 3 1,988,924.00 74,894,184.00 2,250,000.00 7,650,000.00 7,244,184.00 Park Develo ment Development - New Neighborhood Parks 200,000 2,400,000 3 63,820.00 2,400,000.00 (2,336,180.00) Development- New Pocket Parks Development - Existing Pocket, Neighborhood, and Community Parks 120,000 200,000 1,500,000 2,400,000 3 3 1,958,854.00 2,818,602.00 1,500,000.00 2,400,000.00 458,854.00 418,602.00 4,841,276.00 6,300,000.00 (1,458,724.00) Urban Park Renovation and Refurbishment Renovation 8 Refurbishment - Urban Parks 130,000 1,500,000 2 1,433,356.00 1,500,000.00 (66,644.00) PRAB - D DRAFT Lover's Hill/Blue : Elmer's Two Mile Sinton Mesa Memorial Dakota Middle Parks ~ Foothills _I Tom Watson! IBM IUrban Parks W onderland East Creek West Parks INew Reservoir I R&R Renovation PRAB - E PRAB - F Planning ? o% Administi 3% Debt Service 22% Civic Center Complex 1% Historic & Cultural Facilities 1% Parks Mainten2 8% .25 Sales Tax Fund Expenditures 1996 Through 2004 Keturbishment - Urban Parks 3% Park Development 11% Renovation and Refurbishment - Recreation Facilities 8% Recreation Capital Improvements 32 °/a Cost Allocation 2% Mountain Parks / Recreation J Conservation _ - 1 %, \ / , ~~/ PRAB - G .25 Sales Tax Fund Debt Service Expenditures 1996 to 2015 *Total Projected .25 Sales Tax Funding = $119,437,042 Funding Available for other Uses $82,621,099 (69%) ~ebt Service ,815,943 (31 %)