Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Five Year Forecast
TOWN OF WESTLAKE 9/9/2013 FIVE YEAR FORECAST All Municipal Funds May 30,2013 ESTIMATED 1 2 3 4 5 FY 13-14 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19 GENERAL FUND 100 1 Sales Tax (ongoing 100% minus one time)3.0%4,000,000 4,120,000 4,243,600 4,370,908 4,502,035 4,637,096 2 Sales Tax (audit/one-time)0.0%400,000 400,000 400,000 400,000 400,000 400,000 3 Sales Tax Allocation to 4B linked (1,100,000) (1,130,000) (1,160,900) (1,192,727) (1,225,509) (1,259,274) 4 Sales Tax Allocation to ED 3.0%(150,000) (154,500) (159,135) (163,909) (168,826) (173,891) 5 Sales Tax Subtotal 3,150,000 3,235,500 3,323,565 3,414,272 3,507,700 3,603,931 6 Property Tax 2.0%1,189,825 1,213,621 1,237,894 1,262,651 1,287,905 1,313,663 7 Estimated Additional Property Tax - per schedule - 94,104 188,208 439,152 8 Property Tax Subtotal 1,189,825 1,213,621 1,237,894 1,356,755 1,476,113 1,752,815 9 Beverage Tax 2.0%50,000 51,000 52,020 53,060 54,122 55,204 10 Franchise Fees 2.0%650,388 663,396 676,664 690,197 704,001 718,081 11 Permits and Fees 2.0%786,000 801,720 817,754 834,109 850,792 867,808 12 Permits and Fees - per schedule 1,000,000 1,000,000 2,000,000 800,000 800,000 13 Fines & Forfeitures 2.0%570,000 581,400 593,028 604,888 616,986 629,326 14 Interest 2.0%8,670 8,843 9,020 9,201 9,385 9,572 15 Misc Income 2.0%51,759 52,794 53,850 54,927 56,025 57,146 16 Other Revenues 2,116,816 3,159,153 3,202,336 4,246,382 3,091,310 3,137,136 17 Transfer In - UF 500 Impact linked 37,500 38,250 39,015 39,795 40,591 41,403 18 Transfer In - UF (IF loan repymt of $500K plus interest )- 256,245 256,245 - - - 19 Transfer In - WAE 412 0.0%- - - - - - 19 Transfer In - VA 220 Dept 22 3.0%13,020 13,411 13,813 14,227 14,654 15,094 20 Transfers In 50,520 307,906 309,073 54,023 55,245 56,497 21 Total Revenues & Transfers In 6,507,161 7,916,179 8,072,867 9,071,432 8,130,368 8,550,379 22 Payroll Salaries 3.0%(2,339,745) (2,409,938) (2,482,236) (2,556,703) (2,633,404) (2,712,406) 23 Payroll Insurance (Health/Dental/Life)3.0%(325,884) (335,661) (345,731) (356,103) (366,786) (377,789) 24 Payroll Taxes (SSM/WC/TWC)3.0%(209,783) (216,076) (222,558) (229,235) (236,112) (243,196) 25 Payroll Retirement (TMRS/ICMA)3.0%(193,291) (199,090) (205,063) (211,215) (217,551) (224,078) 26 Payroll Transfers In 3.0%607,660 625,890 644,667 664,007 683,927 704,445 27 Personnel Forecast PR Xfr In - UF 500 (additional staff)- - - 31,880 32,836 33,821 28 Five-Year Personnel Forecast 3.0%- (104,639) (196,892) (358,361) (369,112) (380,185) 29 Total Payroll and Related (2,461,043) (2,639,514) (2,807,813) (3,015,729) (3,106,201) (3,199,387) 30 Supplies 3.0%(235,921) (242,998) (250,288) (257,797) (265,531) (273,497) 31 Service 3.0%(2,224,612) (1,887,600) (1,944,228) (2,002,555) (2,062,631) (2,124,510) 32 Insurance 3.0%(30,520) (31,435) (32,378) (33,350) (34,350) (35,381) 33 R&M 3.0%(126,962) (130,771) (134,694) (138,735) (142,897) (147,184) 34 Rent & Utilities 3.0%(299,812) (308,806) (318,071) (327,613) (337,441) (347,564) 35 Reduce Solana rent (General Fund portion)141,203 141,203 141,203 36 Reduce Fire Station utilities 14,000 14,000 14,000 37 Park/Well Improvement impact to budget Project (5,408) (7,570) (9,737) (10,029) (10,330) 38 Municipal/Fire Station/Maint. Bldg/Warning system Project (11,750) (136,799) (166,076) (171,058) (176,190) 39 Street/Trails CIP impact to budget Project (5,150) (111,305) (148,739) (166,417) (171,409) 40 Total Operating Expenditures (2,917,826) (2,623,919) (2,935,333) (2,929,398) (3,035,151) (3,130,862) 41 Capital Outlay 3.0%(31,700) (32,651) (33,631) (34,639) (35,679) (36,749) 42 IT Forecast - (47,500) (54,000) (56,500) (55,500) (60,000) 43 Total Capital (31,700) (80,151) (87,631) (91,139) (91,179) (96,749) 44 Transfer Out - ED 210 (35,758) (35,758) (35,758) - - - 45 Transfer Out - GMR 600 fixed (550,000) (275,000) (275,000) (275,000) (275,000) (275,000) 46 Transfer Out- WA (K-5 Westlake reserve slots)fixed (325,000) (300,000) (300,000) (300,000) (300,000) (300,000) 47 Transfer Out - DS (Debt for Academy Exp $8.5M) linked - (451,269) (447,798) (448,732) (445,172) (446,018) 48 linked (682,677) (131,843) (784,831) (1,092,237) (1,067,830) (1,367,899) 49 Transfers Out - Operating (1,593,435) (1,193,870) (1,843,386) (2,115,970) (2,088,003) (2,388,917) 50 Transfer Out - CP 410 linked - (743,000) - - - - 51 Transfer Out - WAE 412 (630,000) - - - - - 52 Transfer out - WA Capital Projects (1-time $$)(1,000,000) (1,000,000) (1,000,000) - - 53 Transfers Out - Non Operating (630,000) (1,743,000) (1,000,000) (1,000,000) - - 54 Total Expenditures & Transfers Out (7,634,004) (8,280,453) (8,674,163) (9,152,236) (8,320,534) (8,815,915) 55 NET R&TI Over(Under) E&TO (1,126,843) (364,274) (601,296) (80,804) (190,166) (265,536) 56 Beginning Fund Balance 5,812,583 4,685,739 4,321,465 3,720,170 3,639,366 3,449,200 57 Ending Fund Balance 4,685,739 4,321,465 3,720,170 3,639,366 3,449,200 3,183,663 58 Restricted/Committed/Assigned 2.0%250,388 263,631 268,904 274,282 279,768 285,363 59 Unassigned Ending Balance 4,435,351 4,057,834 3,451,266 3,365,084 3,169,432 2,898,300 60 Operating Days 231 227 164 151 139 120 DESCRIPTION Transfer Out - DS 300 (Including 5-year CIP) 1 TOWN OF WESTLAKE 9/9/2013 FIVE YEAR FORECAST All Municipal Funds May 30,2013 ESTIMATED 1 2 3 4 5 FY 13-14 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19DESCRIPTION DEBT SERVICE FUND 300 1 Property Tax 153,868 154,704 154,503 154,475 154,625 154,575 2 Transfer in from ED Fund - Phase II - - 393,886 393,886 52,227 3 Transfer in - GF 100- including 5-year CIP 682,677 131,843 784,831 1,092,237 1,067,830 1,367,899 4 Transfer in - GF 100 - Phase I - 451,269 447,798 448,732 445,172 446,018 5 Transfer In - VA 220 linked 151,700 164,450 142,250 169,950 162,400 169,463 6 Transfer In - 4B 200 linked 1,100,500 1,130,500 1,161,400 1,193,227 1,226,009 1,259,774 7 Total Revenues & Transfers In 2,088,745 2,032,766 2,690,781 3,452,508 3,449,923 3,449,956 8 9 DS Principal - Issue 2002 CO Phase I (330,000) - - - - - 10 DS Interest - Issue 2002 CO (21,450) - - - - - 11 Bank Charge - 2002 CO (530) - - - - - 12 13 DS Principal - Issue 2003 CO Phase II (175,000) (185,000) (190,000) - - - 14 DS Interest - Issue 2003 CO (97,411) (90,630) (83,230) (75,250) (75,250) (75,250) 15 Bank Charge - 2003 CO - - - - - - 16 17 DS Principal - Issue 2007 GORB Refunding (35,000) (35,000) (410,000) (425,000) (40,000) (40,000) 18 DS Interest - Issue 2007 GORB (294,608) (293,295) (291,983) (276,608) (259,608) (258,008) 19 Bank Charge - 2007 GORB - (309) (309) (309) (309) (309) 20 21 DS Principal - Issue 2008 GO A&S - - - - - - 22 DS Interest - Issue 2008 GO - - - - - - 23 24 DS Principal - Issue 2011 GORB Refunding (100,000) (440,000) (100,000) (275,000) (700,000) (715,000) 25 DS Interest - Issue 2011 GORB (223,200) (217,800) (212,400) (207,275) (192,650) (171,425) 26 Bond Issue Cost 2011 GORB - 27 Bond Issue Cost 2011 GORB - 28 Bank Charge - 2011 GORB (300) (309) (309) (309) (309) (309) 29 30 DS Principal - Issue 2011 CO Taxes (93,000) (97,000) (100,000) (75,000) (79,000) (83,000) 31 DS Interest - Issue 2011 CO (60,791) (57,704) (54,503) (79,475) (75,625) (71,575) 32 Bank Charge - 2011 CO (77) - - - - - 33 34 DS Principal - Issue 2013 GORB Ref 2008 (105,000) (120,000) (100,000) (130,000) (125,000) (135,000) 35 DS Interest - Issue 2013 GORB A&S (46,700) (44,450) (42,250) (39,950) (37,400) (34,463) 36 Bond Issue Cost 2013 GORB - 37 38 DS Principal - Issue 2013 CO WA (100,000) (173,550) (173,550) (178,000) (178,000) (182,450) 39 DS Interest - Issue 2013 CO Expansion (407,159) (277,719) (274,248) (270,732) (267,172) (263,568) 40 41 2014-15 CO (Town Hall and Fire Station &Others ($56 per $1M) - (658,000) (658,000) (658,000) (658,000) 42 43 2014-15 CO (WA Phase II) ($7M) (30 yrs)- - (393,886) (393,886) (393,886) 44 45 2015-16 CO (Town Hall and Fire Station &Others ($13.6K) (30 yrs)- - (367,714) (367,714) (367,714) 46 47 Total Expenditures & Transfers Out (2,090,226) (2,032,766) (2,690,781) (3,452,508) (3,449,923) (3,449,956) 48 NET R&TI Over(Under) E&TO (1,481)0 0 0 0 0 49 Beginning Fund Balance 1,481 (0) (0) (0) (0) (0) 50 Ending Fund Balance 0 (0) (0) (0) (0) (0) 51 Unassigned Ending Balance 0 (0) (0) (0) (0) (0) ref 2011 CO 2 TOWN OF WESTLAKE 9/9/2013 FIVE YEAR FORECAST All Municipal Funds May 30,2013 ESTIMATED 1 2 3 4 5 FY 13-14 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19DESCRIPTION UTILITY FUND 500 1 Water/Sewer/Waste Revenues 2.0%2,646,850 2,699,787 2,753,783 2,808,858 2,865,036 2,922,336 2 Water/Sewer Tap Fees 2.0%23,250 23,715 24,189 24,673 25,167 25,670 3 Fort Worth Impact Fees 2.0%37,500 38,250 39,015 39,795 40,591 41,403 4 Misc Income 2.0%192,004 195,844 199,761 203,756 207,831 211,988 5 Interest 2.0%6,000 6,120 6,242 6,367 6,495 6,624 6 Total Revenues & Transfers In 2,905,604 2,963,716 3,022,990 3,083,450 3,145,119 3,208,022 7 Expenditures 3.0%(804,078) (828,200) (853,046) (878,638) (904,997) (932,147) 8 Solana Expense - 31,613 31,613 31,613 9 Water Purchases 3.0%(1,110,600) (1,143,918) (1,178,236) (1,213,583) (1,249,990) (1,287,490) 10 Payroll Transfers to GF new acct 3.0%(321,554) (331,200) (341,136) (351,370) (361,911) (372,769) 11 Personnel Forecast PR Xfr Out - GF100 (addl staff)linked - - - (31,880) (32,836) (33,821) 12 Funded/Proposed Capital Projects Impact to Operations - - (13,100) (25,730) (26,501) (27,295) 13 Total Operating Expense (2,236,232) (2,303,319) (2,385,518) (2,469,588) (2,544,623) (2,621,909) 14 Transfer Out - UMR 510 fixed (263,530) (450,000) (300,000) (300,000) (300,000) (300,000) 15 Transfer Out - GF 100 Impact Fees linked (37,500) (38,250) (39,015) (39,795) (40,591) (41,403) 16 Transfer Out to GF (Interfund loan)- (256,245) (256,245) - - - 17 Water Meter Automation 0.0%- - - - - - 18 Total Transfers Out (301,030) (744,495) (595,260) (339,795) (340,591) (341,403) 19 N1 Sewer Line Transfer 0.0%(82,967) (250,000) - - - - 20 Ground Storage Tank 0.0%(1,403,197) - - - - - 21 METER READING EQUIPMENT NEW PROJECT 0.0%- (38,500) (35,000) - - - 22 Total Capital Projects (1,486,164) (288,500) (35,000) - - - 23 Debt Service (Hillwood)3.0%(73,000) (75,190) (77,446) (79,769) (82,162) (84,627) 24 Debt Service (Keller OH Storage)ends fy2020 linked (118,212) (119,462) (118,949) (119,879) (120,538) (120,936) 23 DS Principal - Issue 2013 CO Ground Storage Tank $1.025M (11,000) (21,450) (21,450) (22,000) (22,000) (22,550) 26 DS Interest - Issue 2013 CO Ground Storage Tank (42,385) (34,325) (33,896) (33,461) (33,021) (32,576) 27 Total Debt (244,597) (250,427) (251,741) (255,109) (257,721) (260,689) 28 Total Expenditures & Transfers Out (4,268,023) (3,586,740) (3,267,519) (3,064,492) (3,142,935) (3,224,001) 29 NET R&TI Over(Under) E&TO (1,362,419) (623,024) (244,529) 18,958 2,184 (15,979) 30 Beginning Fund Balance 5,550,572 4,188,153 3,565,129 3,320,600 3,339,558 3,341,743 31 Ending Fund Balance 4,188,153 3,565,129 3,320,600 3,339,558 3,341,743 3,325,763 32 Restricted/Committed/Assigned 2.0%159,802 164,628 167,921 171,279 174,705 178,199 33 Unassigned Ending Balance 4,028,351 3,400,501 3,152,679 3,168,279 3,167,038 3,147,565 34 Total Operating Expenditures 2,480,829 2,553,745 2,637,259 2,724,697 2,802,344 2,882,598 35 Operating Days 593 486 436 424 413 399 UTILITY - MAINTENANCE & REPLACEMENT FUND 510 36 Revenues 1.0%125 126 128 129 130 131 37 Transfers In - UF 500 linked 263,530 450,000 300,000 300,000 300,000 300,000 38 Total Revenues & Transfers In 263,655 450,126 300,128 300,129 300,130 300,131 39 Expenditures linked (324,530) (155,000) (82,500) (87,500) - - 40 REPAINT EXISTING STORAGE TANK NEW PROJECT 0.0%- (10,000) (160,000) - - - 41 Total Expenditures & Transfers Out (324,530) (165,000) (242,500) (87,500) - - 42 NET R&TI Over(Under) E&TO (60,875) 285,126 57,628 212,629 300,130 300,131 43 Beginning Fund Balance 61,298 423 285,549 343,177 555,806 855,936 44 Ending Fund Balance 423 285,549 343,177 555,806 855,936 1,156,067 45 Restricted/Committed/Assigned 423 285,549 343,177 555,806 855,936 1,156,067 46 Assigned Ending Balance (projected)- - - - - - 3 TOWN OF WESTLAKE 9/9/2013 FIVE YEAR FORECAST All Municipal Funds May 30,2013 ESTIMATED 1 2 3 4 5 FY 13-14 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19DESCRIPTION CAPITAL PROJECT FUND 410 1 FM1938 Streetscape/Wayfinding - 320,000 - - - - 2 Hwy 377 Westport Parkway Signal 16,500 - - - - - 3 Interest Income 7,400 - - - - - 4 Transfer in from GF linked - 743,000 - - - - 5 Transfer in from GF (Addl permits)linked 1,000,000 1,000,000 1,000,000 - - 6 Other Sources - Bond Proceeds 4,750,000 13,600,000 - - - 7 Total Revenues & Transfers In 23,900 6,813,000 14,600,000 1,000,000 - - 8 WATERLINE & WELL IMPROVEMENTS NEW PROJECT - (63,000)- - - - 9 MUNICIPAL BUILDING NEW PROJECT - (2,765,000)(7,765,000)- - - 10 FIRE STATION COMPLEX NEW PROJECT - (1,497,000)(5,748,600)- - - 11 MAINTENANCE & STORAGE FACILITY NEW PROJECT - (20,000) - - - 12 FM 1938 Streetscape/Wayfinding (1,687,600) (680,000) - - - - 13 SH 114/Hwy 170 Enhancements (Contribution)(320,000) 14 SH 114/Hwy 170 Enhancements (PY Bonds)(511,967) (71,766) - - - - 15 SH 114/Hwy 170 Enhancements (Cash)- (264,234) 16 Stagecoach Hills Street Reconstruction & Drainage (9,020) - - - - - 17 S. Roanoke Road Reconstruction & Drainage - (453,000)- - - - 18 Sam School Road Reconstruction & Drainage - (266,000) - - - 19 E. Dove Road Reconstruction & Drainage (Vaq - TB)- (100,000) (414,945) - - - 20 Trail and Parks Improvements - (195,000) - - - - 21 Transfer out to WA Expansion parking lot (200,000) - - - - - 22 Outdoor Warning System (99,000) - - - - - 23 Pearson Lane Recon/Drain (One Project)- - - (381,250) - - 24 Trail - Dove/Pearson/Aspen - - - (273,600) - - 25 Ottinger Road - Creek Bridge - - - - (330,000) - 26 Ottinger Road Recon/Drain (One Project)- - - - (572,710) - 27 Trail - WA to Cemetery - - - (276,100) - 28 Total Expenditures & Transfers Out (2,507,587) (6,675,000) (13,948,545) (654,850) (1,178,810) - 29 NET R&TI Over(Under) E&TO (2,483,687) 138,000 651,455 345,150 (1,178,810) - 30 Beginning Fund Balance 2,638,835 155,148 293,148 944,603 1,289,753 110,943 31 Ending Fund Balance 155,148 293,148 944,603 1,289,753 110,943 110,943 32 Restricted/Committed/Assigned 155,148 293,148 944,603 1,289,753 110,943 110,943 33 Unassigned Ending Balance - - - - - - WESTLAKE ACADEMY EXPANSION & PHASE II 34 Contributions 66,000 - - - - - 35 Interest Earned Bonds 4,197 36 Misc Revenue 8,500 37 Transfer in from GF 630,000 - - - - - 38 Transfer in from CP 200,000 - - - 39 Other Sources 466,775 7,000,000 - - - - 40 Total Revenues & Transfers In 1,375,472 7,000,000 - - - - 41 Expenditures (8,191,950) (865,603) - - - - 42 Phase II (608,905) (4,955,810) (1,428,405) 43 Transfers Out - - - - - - 44 Total Expenditures & Transfers Out (8,191,950) (1,474,508) (4,955,810) (1,428,405) - - 45 NET R&TI Over(Under) E&TO (6,816,478) 5,525,492 (4,955,810) (1,428,405) - - 46 Beginning Fund Balance 7,682,081 865,603 6,391,095 1,435,285 6,880 6,880 47 Ending Fund Balance 865,603 6,391,095 1,435,285 6,880 6,880 6,880 48 Restricted Funds 865,603 - - - - - 49 Unassigned Ending Balance (projected)- 6,391,095 1,435,285 6,880 6,880 6,880 4 TOWN OF WESTLAKE 9/9/2013 FIVE YEAR FORECAST All Municipal Funds May 30,2013 ESTIMATED 1 2 3 4 5 FY 13-14 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19DESCRIPTION GENERAL - MAINTENANCE & REPLACEMENT FUND 600 1 Revenues 1.0%1,750 1,768 1,785 1,803 1,821 1,839 2 Transfers In - GF 100 linked 550,000 275,000 275,000 275,000 275,000 275,000 3 Total Revenues & Transfers In 551,750 276,768 276,785 276,803 276,821 276,839 4 Expenditures (498,016) (1,121,000) (149,500) (224,450) (193,500) (194,000) 5 Total Expenditures & Transfers Out (498,016) (1,121,000) (149,500) (224,450) (193,500) (194,000) 6 NET R&TI Over(Under) E&TO 53,734 (844,233) 127,285 52,353 83,321 82,839 7 Beginning Fund Balance 1,239,048 1,292,782 448,549 575,835 628,188 711,509 8 Ending Fund Balance 1,292,782 448,549 575,835 628,188 711,509 794,348 9 Restricted/Committed/Assigned 1,292,782 448,549 575,835 628,188 711,509 794,348 10 Unassigned Ending Balance - - - - - - VISITOR ASSOCIATION FUND 220 11 Hotel Tax 2.0%700,000 714,000 728,280 742,846 757,703 772,857 12 Other Revenues 2.0%21,550 21,981 22,421 22,869 23,326 23,793 13 Total Revenues & Transfers In 721,550 735,981 750,701 765,715 781,029 796,650 14 Expenditures 3.0%(248,945) (256,413) (264,106) (272,029) (280,190) (288,595) 15 Solana Expense 31,612 31,612 31,612 16 Payroll Transfers to GF 3.0%(286,107) (294,690) (303,531) (312,637) (322,016) (331,676) 17 Transfer Out - GF 100 Dept 22 linked (13,020) (13,411) (13,813) (14,227) (14,654) (15,094) 18 Transfer Out - DS 300 Schedule (151,700) (164,450) (142,250) (169,950) (162,400) (169,463) 19 Total Expenditures & Transfers Out (699,772) (728,964) (723,699) (737,231) (747,648) (773,216) 20 NET R&TI Over(Under) E&TO 21,778 7,017 27,001 28,484 33,381 23,434 21 Beginning Fund Balance 1,026,639 1,048,417 1,055,434 1,082,435 1,110,919 1,144,300 22 Ending Fund Balance 1,048,417 1,055,434 1,082,435 1,110,919 1,144,300 1,167,734 23 Restricted/Committed/Assigned 142,250 142,250 169,950 162,400 169,463 171,025 24 Unassigned Ending Balance 906,167 913,184 912,485 948,519 974,838 996,709 25 Operating Days 473 457 460 470 476 471 4B ECONOMIC DEVELOPMENT FUND 200 26 Sales tax (on-going)linked 1,000,000 1,030,000 1,060,900 1,092,727 1,125,509 1,159,274 27 Sales tax (one-time)fixed 100,000 100,000 100,000 100,000 100,000 100,000 28 Interest fixed 500 500 500 500 500 500 29 Total Revenues & Transfers In 1,100,500 1,130,500 1,161,400 1,193,227 1,226,009 1,259,774 30 Expendures - - - - - - 31 Transfer Out (1,100,500) (1,130,500) (1,161,400) (1,193,227) (1,226,009) (1,259,774) 32 Total Expenditures & Transfers Out (1,100,500) (1,130,500) (1,161,400) (1,193,227) (1,226,009) (1,259,774) 33 NET R&TI Over(Under) E&TO - - - - - - 34 Beginning Fund Balance - - - - - - 35 Ending Fund Balance - - - - - - 36 Restricted/Committed/Assigned - - - - - - 37 Unassigned Ending Balance - - - - - - ECONOMIC DEVELOPMENT FUND 210 38 General Sales Tax linked to GF allo linked 150,000 154,500 159,135 163,909 168,826 173,891 39 Transfers In End FY2016 fixed 35,758 35,758 35,758 - - - 40 Granada $10K/lot 440,000 400,000 41 Total Revenues & Transfers In 185,758 190,258 634,893 563,909 168,826 173,891 42 Expendures (185,758) (190,258) (194,893) (163,909) (168,826) (173,891) 43 Transfer out to Debt Service Fund - (393,886) (393,886) (52,227) 44 Total Expenditures & Transfers Out (185,758) (190,258) (194,893) (557,795) (562,713) (226,119) 45 NET R&TI Over(Under) E&TO - - 440,000 6,114 (393,886) (52,227) 46 Beginning Fund Balance - - - 440,000 446,114 52,227 47 Ending Fund Balance - - 440,000 446,114 52,227 - 48 Restricted/Committed/Assigned - - 440,000 446,114 52,227 - 49 Unassigned Ending Balance - - - - - - 5 TOWN OF WESTLAKE 9/9/2013 FIVE YEAR FORECAST All Municipal Funds May 30,2013 ESTIMATED 1 2 3 4 5 FY 13-14 FY 14-15 FY 15-16 FY 16-17 FY 17-18 FY 18-19DESCRIPTION CEMETERY FUND 255 1 Revenues 2.0%6,060 6,181 6,305 6,431 6,560 6,691 2 Transfers In 2.0%- - - - - - 3 Total Revenues & Transfers In 6,060 6,181 6,305 6,431 6,560 6,691 4 Expenditures 3.0%(11,440) (11,783) (12,137) (12,501) (12,876) (13,262) 5 Transfers Out 3.0%- - - - - - 6 Total Expenditures & Transfers Out (11,440) (11,783) (12,137) (12,501) (12,876) (13,262) 7 NET R&TI Over(Under) E&TO (5,380) (5,602) (5,832) (6,070) (6,316) (6,571) 8 Beginning Fund Balance 147,621 142,241 136,639 130,807 124,737 118,421 9 Ending Fund Balance 142,241 136,639 130,807 124,737 118,421 111,850 10 Restricted/Committed/Assigned 142,241 136,639 130,807 124,737 118,421 111,850 11 Unassigned Ending Balance - - - - - - LONE STAR PUBLIC FUND 418 12 Revenues 3.0%45 - - - - 13 Transfers In 3.0%- - - - - - 14 Total Revenues & Transfers In 45 - - - - - 15 Expenditures 3.0%- - - - - - 16 Transfers Out 3.0%- - - - - - 17 Total Expenditures & Transfers Out - - - - - - 18 NET R&TI Over(Under) E&TO 45 - - - - - 19 Beginning Fund Balance 13,599 13,666 13,666 13,666 13,666 13,666 20 Ending Fund Balance 13,644 13,666 13,666 13,666 13,666 13,666 21 Restricted/Committed/Assigned 13,644 13,666 13,666 13,666 13,666 13,666 22 Unassigned Ending Balance - - - - - - SUMMARY 23 Total Revenues & Transfers in 15,730,200 29,515,475 31,516,850 19,713,604 17,484,785 18,022,332 24 Total Expenditures & Transfers Out (27,511,806) (25,396,972) (36,020,947) (20,565,195) (18,834,947) (17,956,242) 25 NET R&TI Over(Under) E&TO (11,781,606) 4,118,503 (4,504,097) (851,591) (1,350,162) 66,090 26 24,173,757 12,392,172 16,510,675 12,006,578 11,154,986 9,804,825 27 12,392,151 16,510,675 12,006,578 11,154,986 9,804,825 9,870,915 28 3,022,282 1,748,061 3,054,862 3,666,224 2,486,637 2,821,460 29 Unassigned Ending Balance 9,369,869 14,762,614 8,951,715 7,488,762 7,318,188 7,049,454 Restricted/Committed/Assigned Beginning Fund Balance Ending Fund Balance 6