Page 117 - Ord 866 Adopting a revised Fiscal Year 17-18 and new proposed Fiscal Year 18-19 budget

FIVE YEAR FINANCIAL FORECAST
ALL MUNICIPAL FUNDS

ESTIMATED PROPOSED 1 2 3 4
DESCRIPTION FY 17- 18 FY 18- 19 FY 19- 20 FY 20- 21 FY 21- 22 FY 22- 23

AT& T/ SBC dept 10 1.00% 304, 700 304, 700 307, 747 310, 824 313, 933 317, 072
Verizon dept 10 1.00% 23, 665 23, 665 23, 902 24, 141 24, 382 24, 626
TXU/ Atmos Gas dept 10 1.00% 39, 420 39, 420 39, 814 40, 212 40, 614 41, 021
Charter dept 10 1.00% 26, 955 26, 955 27, 225 27, 497 27, 772 28, 049
One Source dept 10 1.00% 3,670 3,670 3,707 3,744 3,781 3,819
Tri- County Electric dept 10 1.00% 473, 000 473, 000 477, 730 482, 507 487, 332 492, 206
Trinity Waste/ AWIN Mgmt dept 10 1.00% 63, 675 63, 675 64, 312 64, 955 65, 604 66, 260
Misc. Franchise Fees dept 10 1.00% 48, 730 48, 730 49, 217 49, 709 50, 207 50, 709
Franchise Fees 983, 815 983, 815 993, 653 1,003, 590 1,013, 626 1,023, 762
Citation Revenue dept 15 0.05% 620, 789 620, 789 621, 111 621, 434 621, 756 622, 079
Court Techology dept 15 0.05% 19, 395 19, 395 19, 405 19, 415 19, 425 19, 435
Court Security dept 15 0.05% 14, 492 14, 492 14, 500 14, 507 14, 515 14, 522
Warrant Fees dept 15 0.05% 41, 820 41, 820 41, 842 41, 863 41, 885 41, 907
NSF Check Fees dept 15 0.05% 5,240 5,240 5,243 5,245 5,248 5,251
Court Efficiency Fees dept 15 0.05% 1,879 1,879 1,880 1,881 1,882 1,883
Law Enforcement Stds/ Edu dept 15 0.05% 685 685 685 686 686 686
Collection Fees dept 15 0.05% 11, 245 11, 245 11, 251 11, 257 11, 263 11, 268
Court Fines and Forfeitures 715, 545 715, 545 715, 916 716, 288 716, 660 717, 032
Beverage Tax dept 10 1.00% 62, 500 62, 500 63, 125 63, 756 64, 394 65, 038
Blizzard Hotel dept 10 hard coded 0 0 0 15, 000 30, 000 30, 000
Entrada Hotel 1 dept 10 hard coded 0 0 15, 000 30, 000 30, 000 30, 000
Entrada Hotel 1 dept 10 hard coded 0 0 15, 000 30, 000 30, 000 30, 000
Beverage Tax 62, 500 62, 500 93, 125 138, 756 154, 394 155, 038
Interest Income dept 11 1.00% 175, 339 175, 339 177, 092 178, 863 180, 652 182, 458
Interest Income dept 15 1.00% 3,616 3,616 3,652 3,689 3,726 3,763
Interest Income 178, 955 178, 955 180, 745 182, 552 184, 378 186, 221
Contributions dept 14 1.00% 12,240 12,240 12,362 12,486 12,611 12,737
Contributions 12, 240 12, 240 12, 362 12, 486 12, 611 12, 737
Transfer In - UF 500 for Impact Fees linked to UF 62, 000 66, 539 67, 870 69, 227 70, 612 72, 024
Transfers In 62,000 66,539 67,870 69,227 70,612 72,024
TOTAL REVENUES AND TRANSFERS IN $ 9, 304, 946 $ 12, 313, 609 $ 9, 581, 327 $ 9,766, 546 $ 10, 146, 508 $ 10, 407, 058

Wages - Full Time Salaries acct 41110 2.50%( 3,408, 814)( 3,472, 786)( 3,559, 606)( 3,648, 596)( 3,739, 811)( 3,833, 306)
Wages - Part Time Salaries acct 41210 2.50%( 231, 976)( 290, 025)( 297, 276)( 304, 708)( 312, 326)( 320, 134)
Wages - Overtime acct 41120 2.50%( 133, 131)( 121, 725)( 124, 768)( 127, 887)( 131, 084)( 134, 361)
Wages - Premium Pay acct 41510 2.50%( 13,560)( 21,476)( 22,012)( 22,563)( 23,127)( 23,705)
Wages - Car Allowance acct 41640 0%( 29,600)( 34,800)( 34,800)( 34,800)( 34,800)( 34,800)
Wages - Performance Pay acct 41647 0% 0 ( 42,000) 0 0 0 0
Wages - Phone Allowance acct 41641 0%( 7,680)( 11,760)( 11,760)( 11,760)( 11,760)( 11,760)
Other - Transfers In VA & UF acct 42698 2.50% 1,055, 775 1,114, 192 1,142, 047 1,170, 598 1,199, 863 1,229, 859
Payroll Salaries & Wages ( 2,768, 986)( 2,880, 380)( 2,908, 175)( 2,979, 716)( 3,053, 045)( 3,128, 207)
Insurance - Medical acct 42110 7.50%( 544, 606)( 711, 266)( 764, 611)( 821, 957)( 883, 604)( 949, 874)
Insurance - Dental acct 42111 1.00%( 29,115)( 32,862)( 33,190)( 33,522)( 33,857)( 34,196)
Insurance - Life acct 42130 0.50%( 26,274)( 36,141)( 36,320)( 36,500)( 36,681)( 36,862)
Taxes - Social Security acct 42210 2.50%( 236, 919)( 247, 663)( 253, 855)( 260, 201)( 266, 706)( 273, 374)
Taxes - Medicare acct 42220 2.50%( 55,334)( 57,843)( 59,289)( 60,771)( 62,291)( 63,848)
Taxes - Unemployment acct 42510 1.00%( 8,790)( 9,517)( 9,612)( 9,708)( 9,805)( 9,903)
Taxes - Workers Comp acct 42610 1.00%( 42,390)( 33,966)( 34,305)( 34,648)( 34,995)( 35,345)
Retirement - TMRS acct 42310 2.50%( 468, 685)( 461, 823)( 473, 369)( 485, 203)( 497, 333)( 509, 766)
Retirement - ICMA acct 42311 0%( 27,270)( 24,270)( 24,270)( 24,270)( 24,270)( 24,270)
Payroll Taxes, Insurance, Retirement ( 1,439, 383)( 1,615, 351)( 1,688, 822)( 1,766, 781)( 1,849, 542)( 1,937, 439)
Sub- Total Payroll and Related ( 4,208, 369)( 4,495, 731)( 4,596, 997)( 4,746, 497)( 4,902, 587)( 5,065, 645)
General Service Debt ( thru 24-25) acct 47120 0%( 36,680)( 36,680)( 36,680)( 36,680)( 36,680)( 36,680)
K-5 Westlake Reserve Slots acct 47900 0%( 315, 000)( 315, 000)( 315, 000)( 315, 000)( 315, 000)( 315, 000)
Total Debt Expenditures ( 351, 680)( 351, 680)( 351, 680)( 351, 680)( 351, 680)( 351, 680)
Fire Department dept 14 1.00%( 57, 224)( 53, 945)( 54, 484)( 55, 029)( 55, 580)( 56, 135)
Municipal Court dept 15 1.00%( 1,672)( 1,672)( 1,689)( 1,706)( 1,723)( 1,740)
Public Works dept 16 1.00%( 28, 605)( 28, 605)( 28, 891)( 29, 180)( 29, 472)( 29, 766)
Facilities Maintenance WA dept 17 1.00%( 38, 740)( 38, 740)( 39, 127)( 39, 519)( 39, 914)( 40, 313)
Parks & Recreations dept 19 1.00%( 79,472)( 79,472)( 80,267)( 81,069)( 81,880)( 82,699)
Facilities Maintenance Town dept 26 1.00%( 12, 789)( 17, 790)( 17, 968)( 18, 148)( 18, 329)( 18, 512)
Total Repair & Maintenance ( 218, 502)( 220, 224)( 222, 426)( 224, 651)( 226, 897)( 229, 166)

103