Loading...
HomeMy WebLinkAboutFive Year Forecast - updated 06-04-2012ACTUAL ACTUAL PROPOSED ADOPTED ESTIMATED 1 2 3 4 5 FY 09-10 FY 10-11 FY 11-12 FY 11-12 FY 11-12 FY 12-13 FY 13-14 FY 14-15 FY 15-16 FY 16/17 GENERAL FUND 100 Total Revenues & Transfers In 4,932,215 6,308,147 5,247,328 5,247,328 6,017,315 5,687,971 5,863,239 6,044,327 6,231,437 6,424,778 Total Expenditures & Transfers Out (3,876,195)(6,715,618)(5,469,566)(5,469,566)(5,324,957)(5,316,386)(5,617,086)(6,072,415)(5,940,506)(6,083,970) NET R&TI Over(Under) E&TO 1,056,020 (407,471)(222,238)(222,238)692,358 371,585 246,153 (28,088)290,931 340,807 Beginning Fund Balance 2,675,312 3,731,332 3,731,332 3,323,861 3,323,861 4,016,218 4,387,803 4,633,956 4,605,868 4,896,799 Ending Fund Balance 3,731,332 3,323,861 3,509,093 3,101,622 4,016,218 4,387,803 4,633,956 4,605,868 4,896,799 5,237,607 Restricted/Committed/Assigned 214,751 415,021 255,079 415,021 430,707 439,321 448,108 457,070 466,211 475,535 Unassigned Ending Balance (projected)3,516,581 2,908,840 3,254,014 2,686,601 3,585,511 3,948,482 4,185,848 4,148,798 4,430,588 4,762,071 Operating Days 337 240 245 202 264 279 285 271 279 288 VISITOR ASSOCIATION FUND 220 Total Revenues & Transfers In 475,977 547,904 557,175 557,175 557,175 568,319 579,685 591,279 603,104 615,166 Total Expenditures & Transfers Out (619,981)(537,564)(666,536)(666,536)(686,536)(702,936)(714,593)(731,718)(749,128)(766,837) NET R&TI Over(Under) E&TO (144,004)10,340 (109,361)(109,361)(129,361)(134,617)(134,908)(140,439)(146,023)(151,671) Beginning Fund Balance 1,244,945 1,100,941 1,100,941 1,111,281 1,111,281 981,920 847,303 712,395 571,956 425,932 Ending Fund Balance 1,100,941 1,111,281 991,580 1,001,920 981,920 847,303 712,395 571,956 425,932 274,261 Restricted/Committed/Assigned 0 0 0 0 0 0 0 0 0 0 Assigned Ending Balance (projected)1,100,941 1,111,281 991,580 1,001,920 981,920 847,303 712,395 571,956 425,932 274,261 Operating Days 670 755 543 556 528 440 364 285 208 131 CEMETERY FUND 255 Total Revenues & Transfers In 5,615 13,417 3,475 3,475 5,575 5,687 5,800 5,916 6,035 6,155 Total Expenditures & Transfers Out (27,822)(5,604)(5,100)(5,100)(4,400)(4,532)(4,668)(4,808)(4,952)(5,101) NET R&TI Over(Under) E&TO (22,207)7,813 (1,625)(1,625)1,175 1,155 1,132 1,108 1,082 1,054 Beginning Fund Balance 0 0 (22,207)0 0 1,175 2,330 3,462 4,570 5,652 Ending Fund Balance (22,207)7,813 (23,832)(1,625)1,175 2,330 3,462 4,570 5,652 6,707 Restricted/Committed/Assigned 0 7,813 0 (1,625)1,175 2,330 3,462 4,570 5,652 6,707 Assigned Ending Balance (projected)(22,207)0 (23,832)0 0 0 0 0 0 0 ECONOMIC DEVELOPMENT FUND 210 Total Revenues & Transfers In 333,830 706,543 185,758 185,758 260,758 272,008 283,821 296,224 309,247 287,163 Total Expenditures & Transfers Out (333,830)(706,543)(185,758)(185,758)(260,758)(272,008)(283,821)(296,224)(309,247)(287,163) NET R&TI Over(Under) E&TO 0 0 0 0 0 0 0 0 0 0 Beginning Fund Balance 0 0 0 0 0 0 0 0 0 0 Ending Fund Balance 0 0 0 0 0 0 0 0 0 0 Restricted/Committed/Assigned 0 0 0 0 0 0 0 0 0 0 Assigned Ending Balance (projected)0 0 0 0 0 0 0 0 0 0 4B ECONOMIC DEVELOPMENT FUND 200 Total Revenues & Transfers In 948,096 1,218,883 688,000 688,000 944,250 1,006,250 1,044,730 1,084,749 1,126,369 1,169,654 Total Expenditures & Transfers Out (948,096)(1,248,614)(717,730)(717,730)(973,980)(1,035,981)(1,074,461)(1,114,480)(1,156,100)(1,199,385) NET R&TI Over(Under) E&TO 0 (29,731)(29,730)(29,730)(29,730)(29,731)(29,731)(29,731)(29,731)(29,731) Beginning Fund Balance 297,308 297,308 297,308 267,577 267,577 237,847 208,116 178,385 148,654 118,923 Ending Fund Balance IFA due from UF 297,308 267,577 267,578 237,847 237,847 208,116 178,385 148,654 118,923 89,192 Restricted/Committed/Assigned 0 0 0 237,847 237,847 208,116 178,385 148,654 118,923 89,192 Assigned Ending Balance (projected)297,308 267,577 267,578 0 0 0 0 0 0 0 DEBT SERVICE FUND 300 Total Revenues & Transfers In 1,499,369 1,536,125 1,656,032 1,656,032 1,648,528 1,655,218 1,844,968 1,846,056 1,844,586 1,845,977 Total Expenditures & Transfers Out (1,499,369)(1,528,620)(1,656,032)(1,656,032)(1,656,032)(1,655,218)(1,844,968)(1,846,056)(1,844,586)(1,845,977) NET R&TI Over(Under) E&TO 0 7,504 0 0 (7,504)0 0 0 0 0 Beginning Fund Balance 0 0 0 7,504 7,504 0 0 0 0 0 Ending Fund Balance 0 7,504 0 7,504 0 0 0 0 0 0 Restricted/Committed/Assigned 0 0 0 0 0 0 0 0 0 0 Assigned Ending Balance (projected)0 7,504 0 7,504 0 0 0 0 0 0 UTILITY FUND 500 Total Revenues & Transfers In 2,217,235 3,283,239 2,721,266 2,721,266 2,728,766 2,783,341 2,839,008 2,895,788 2,953,704 3,012,778 Total Expenditures & Transfers Out (2,170,277)(2,751,145)(3,004,659)(3,004,659)(3,141,727)(2,855,561)(3,016,578)(2,936,417)(3,009,431)(3,084,330) NET R&TI Over(Under) E&TO 46,958 532,094 (283,393)(283,393)(412,961)(72,220)(177,570)(40,629)(55,727)(71,552) Beginning Fund Balance 1,496,222 1,543,180 2,075,274 2,511,251 2,511,251 2,098,290 2,026,070 1,848,500 1,807,871 1,752,144 Ending Fund Balance 1,543,180 2,075,274 1,791,881 2,227,858 2,098,290 2,026,070 1,848,500 1,807,871 1,752,144 1,680,592 Restricted/Committed/Assigned 195,918 481,709 744,983 744,983 744,983 141,380 144,208 147,092 150,034 153,034 Unassigned Ending Balance (projected)1,347,262 1,593,565 1,046,898 1,482,875 1,353,307 1,884,690 1,704,293 1,660,780 1,602,111 1,527,558 Total Operating Expenditures 2,102,849 2,392,565 2,321,056 2,321,056 2,321,056 2,387,839 2,456,286 2,524,986 2,597,204 2,671,291 Operating Days 234 243 165 233 213 288 253 240 225 209 DESCRIPTION TOWN OF WESTLAKE FIVE YEAR FORECAST All Municipal Funds Monday, June 04, 2012 Page 1 of 2 6/4/2012 12:01 PM 40 ACTUAL ACTUAL PROPOSED ADOPTED ESTIMATED 1 2 3 4 5 FY 09-10 FY 10-11 FY 11-12 FY 11-12 FY 11-12 FY 12-13 FY 13-14 FY 14-15 FY 15-16 FY 16/17DESCRIPTION TOWN OF WESTLAKE FIVE YEAR FORECAST All Municipal Funds Monday, June 04, 2012 UTILITY - MAINTENANCE & REPLACEMENT FUND 510 Total Revenues & Transfers In 28 112 50,100 50,100 50,125 260,026 353,128 200,129 200,130 200,131 Total Expenditures & Transfers Out (7,500)0 (31,200)(31,200)0 (31,200)(188,000)(185,000)(165,000)0 NET R&TI Over(Under) E&TO (7,472)112 18,900 18,900 50,125 228,826 165,128 15,129 35,130 200,131 Beginning Fund Balance 50,000 42,528 42,528 42,640 42,640 92,765 321,591 486,718 501,847 536,977 Ending Fund Balance 42,528 42,640 61,428 61,540 92,765 321,591 486,718 501,847 536,977 737,109 Restricted/Committed/Assigned 42,528 42,640 61,428 61,540 92,765 321,591 486,718 501,847 536,977 737,109 Assigned Ending Balance (projected)0 0 0 0 0 0 0 0 0 0 GENERAL- MAINTENANCE & REPLACEMENT FUND 600 Total Revenues & Transfers In 23,054 670,919 530,250 530,250 531,750 401,768 551,785 501,803 551,821 551,839 Total Expenditures & Transfers Out (11,400)(41,037)(418,520)(418,520)(423,520)(245,700)(121,900)(106,000)(1,534,500)(136,000) NET R&TI Over(Under) E&TO 11,654 629,881 111,730 111,730 108,230 156,068 429,885 395,803 (982,679)415,839 Beginning Fund Balance 0 0 11,654 0 0 108,230 264,298 694,183 1,089,986 107,307 Ending Fund Balance 11,654 629,881 123,384 111,730 108,230 264,298 694,183 1,089,986 107,307 523,146 Restricted/Committed/Assigned 11,654 629,881 123,384 111,730 108,230 264,298 694,183 1,089,986 107,307 523,146 Unassigned Ending Balance (projected)0 0 0 0 0 0 0 0 0 0 CAPITAL PROJECT FUND 410 Total Revenues & Transfers In 138,465 6,259,006 27,800 27,800 2,595,561 1,842,334 2,372,000 347,510 0 0 Total Expenditures & Transfers Out (148,576)(1,844,954)(2,047,545)(2,047,545)(4,250,684)(4,748,073)(1,750,880)(1,042,100)0 0 NET R&TI Over(Under) E&TO (10,111)4,414,052 (2,019,745)(2,019,745)(1,655,123)(2,905,739)621,120 (694,590)0 0 Beginning Fund Balance 230,391 220,279 220,279 4,634,332 4,634,332 2,979,209 73,470 694,590 0 0 Ending Fund Balance 220,279 4,634,332 (1,799,466)2,614,587 2,979,209 73,470 694,590 0 0 0 Restricted/Committed/Assigned 220,279 4,634,332 (1,799,466)2,614,587 2,979,209 73,470 694,590 0 0 0 Unassigned Ending Balance (projected)0 0 0 0 0 0 0 0 0 0 LONE STAR PUBLIC FUND 418 Total Revenues & Transfers In 29 36 30 30 45 46 48 49 51 52 Total Expenditures & Transfers Out 0 (102)0 0 0 0 0 0 0 0 NET R&TI Over(Under) E&TO 29 (66)30 30 45 46 48 49 51 52 Beginning Fund Balance 13,569 13,598 13,598 13,531 13,531 13,576 13,623 13,670 13,720 13,770 Ending Fund Balance 13,598 13,531 13,628 13,561 13,576 13,623 13,670 13,720 13,770 13,822 Restricted/Committed/Assigned 13,598 13,531 13,628 13,561 13,576 13,623 13,670 13,720 13,770 13,822 Unassigned Ending Balance (projected)0 0 0 0 0 0 0 0 0 0 SUMMARY Total Revenues & Transfers in 11,985,254 21,865,291 11,667,214 11,667,214 15,339,848 14,482,967 15,738,211 13,813,830 13,826,484 14,113,694 Total Expenditures & Transfers Out (10,633,146)(18,344,664)(14,202,646)(14,202,646)(16,722,594)(16,867,595)(14,616,955)(14,335,217)(14,713,450)(13,408,763) NET R&TI Over(Under) E&TO 1,352,107 3,520,627 (2,535,432)(2,535,432)(1,382,746)(2,384,628)1,121,256 (521,387)(886,966)704,931 7,230,407 8,535,811 9,057,352 11,911,976 11,911,976 10,529,231 8,144,603 9,265,859 8,744,471 7,857,505 8,582,514 12,056,437 6,521,920 9,376,544 10,529,231 8,144,603 9,265,859 8,744,471 7,857,505 8,562,436 698,728 6,224,927 (600,964)4,197,643 4,608,492 1,464,128 2,663,323 2,362,938 1,398,874 1,998,545 Unassigned Ending Balance (projected)7,883,787 5,831,510 7,122,884 5,178,901 5,920,739 6,680,475 6,602,536 6,381,534 6,458,631 6,563,891 Restricted/Committed/Assigned Beginning Fund Balance Ending Fund Balance Page 2 of 2 6/4/2012 12:01 PM 41