Page 131 - 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

WAF Grant 175, 000 0 135, 000 0 0 0
WA - OUTDOOR LEARNING CENTER ( 175, 000) 0 ( 123, 595) 0 0 0
NET project 71 0 0 11, 405 0 0 0
Bond Revenue - Issue $ 3.387M 0 82, 000 0 0 0 0
WA - POND REPAIRS 0 ( 82, 000) 0 0 0 0
NET project 77 0 0 0 0 0 0
FACILITY and GROUND IMPROVEMENTS DEPT 17 0 0 11, 405 0 0 0
Bond Revenue - Issue $ 3.387M 0 229, 500 0 0 0 0
WAYFINDING SIGNAGE 0 ( 229, 500) 0 0 0 0
NET project 67 0 0 0 0 0 0
Bond Revenue - Issue $ 3.387M 0 30, 000 0 0 0 0
TRAIL CONNECTION AT 114/ SOLANA 0 ( 30, 000) 0 0 0 0
NET project 42 0 0 0 0 0 0

Bond Revenue - Issue $ 3.387M 0 300, 949 0 0 0 0
TRAIL - WESTLAKE ACADEMY TO CEMETERY 0 0 ( 300, 949) 0 0 0
NET project 52 0 300, 949 ( 300, 949) 0 0 0
Bond Revenue - Issue $ 3.387M 0 290, 016 0 0 0 0
TRAIL - DOVE/ PEARSON/ ASPEN 0 ( 290, 016) 0 0 0 0
NET project 53 0 0 0 0 0 0
Contribution in prior year 0 0 0 0 0 0
CEMETARY IMPROVEMENTS ( 100, 000)( 50, 000) 0 0 0 0
NET project 76 ( 100, 000)( 50, 000) 0 0 0 0
PARKS/ TRAIL/ CEMETERY IMPROVEMENTS DEPT 19 ( 100, 000) 250, 949 ( 300, 949) 0 0 0
Cash ( Fund Balance) 0 0 0 0 0 0
Fiber Connectivity between Buildings 0 ( 300, 000) 0 0 0 0
INFORMATION TECHNOLOGY IMPROVEMENTS 0 ( 300, 000) 0 0 0 0
Cash ( Fund Balance) 0 0 0 0 0 0
Payroll Transfers Out to GF ( 54, 565) 0 0 0 0 0
PAYROLL TRANSFERS ( 54, 565) 0 0 0 0 0

Total Revenues & Transfers in 539, 390 4,450, 134 173, 000 38, 000 38, 000 38, 000
Total Expenditures & Transfers Out ( 649, 565)( 2,192, 051)( 1,888, 678) 0 0 0
NET CHANGE TO FUND BALANCE ( 110, 175) 2,258, 083 ( 1,715, 678) 38, 000 38, 000 38, 000
Beginning Fund Balance 1,700, 249 1,590, 074 3,848, 157 2,132, 479 2,170, 479 2,208, 479
Ending Fund Balance 1,590, 074 3,848, 157 2,132, 479 2,170, 479 2,208, 479 2,246, 479
Restricted/ Committed/ Assigned Contributions/ Grants/ Bonds 201, 390 2,258, 083 135, 000 0 0 0
Unassigned Ending Balance 1,388, 684 1,590, 074 1,997, 479 2,170, 479 2,208, 479 2,246, 479

FUND 405 - FIRE STATION PROJECT

Cash ( Fund Balance) hard coded 0 0 0 0 0 0
Total Revenues 0 0 0 0 0 0
Engineering Fees tied to vision ( 545, 742)( 4,100) 0 0 0 0
Construction Expense tied to vision ( 6,248, 000)( 1,739, 281) 0 0 0 0
Land Purchase tied to vision 0 0 0 0 0 0
Design Fees tied to vision ( 76, 950)( 61, 474) 0 0 0 0
Furniture & Fixtures tied to vision ( 200, 000)( 75, 000) 0 0 0 0
Security Service tied to vision ( 167, 000)( 150, 500) 0 0 0 0
Contingency tied to vision ( 75, 000)( 107, 700) 0 0 0 0
Misc. Expense tied to vision ( 4,250)( 258, 075) 0 0 0 0
Appraisal Fees tied to vision ( 2,115) 0 0 0 0 0
Misc Legal tied to vision ( 3,147) 0 0 0 0 0
Boyle & Lowry tied to vision ( 16, 690) 0 0 0 0 0
Advertising Public Notices tied to vision ( 224)( 2,500) 0 0 0 0
Printing tied to vision ( 555)( 1,000) 0 0 0 0
Total Expenditures ( 7, 339, 673)( 2, 399, 630) 0 0 0 0

117