HomeMy WebLinkAboutGeneral Fund Balance Carryover.pdfGeneral Fund Balance Carryover
Final Forecast
2018 2019
Fund Balance as of beginning of year 4,489,233$ 4,920,728$
Less Investment Set Aside-Finance Software (175,700)$ (215,700)$
Actual/Forecast/Budgeted Carryover(shortage)431,495$ 66,100$
Net available as of end of the year 4,745,028$ 4,771,128$
Expenditures including contingency 11,222,360$ 12,173,800$
Less Contingency n/a -$
Net Expenditures 11,222,360$ 12,173,800$
Minimum Reserve % of Expenditures:25%2,805,590$ 3,043,450$
Amount Above Minimum Reserve:25%1,939,438$ 1,727,678$
Actual Percentage 42.28%39.19%
Maximum Reserve % of Expenditures 33%3,703,379$ 4,017,354$
Amount over/(Under) 33%1,041,649$ 753,774$
2019 2020 Dollar Percentage
General Fund Transfers-Subsidies Forecast Budget Increase Increase
FUND TFR -PARKS CAP RESERVE 50,000 50,000
FUND TFR -GOLF OPERATIONS 50,600 56,600 6,000 11.9%
FUND TFR - TRAILS FUND 25,000 25,000 - 0.0%
FUND TFR - VETERANS MEMORIAL TRUST FUND 500 500 - 0.0%
FUND TFR -LEGACY FLIGHT MUSEUM 15,000 15,000 - 0.0%
FUND TFR -AIRPORT CONSTRUCTION 5,000 10,000 5,000 100.0%
FUND TFR -PLANNING & ZONING 267,700 345,800 78,100 29.2%
FUND TFR -REXBURG CULTURAL ART 39,100 36,900 (2,200) -5.6%
FUND TFR -E I BUSINESS COMP 12,000 16,600 4,600 38.3%
FUND TFR -MAYOR'S YOUTH ADV BD 1,500 1,500 - 0.0%
FUND TFR-GOLF CON.LOAN PAYBACK 25,000 25,000 - 0.0%
FUND TFR- AIRPORT OPERATIONS 7,000 4,000 (3,000) -42.9%
FUND TFR -ROMANCE/FUND 30 227,800 327,700 99,900 43.9%
FUND TFR -DARE/FUND 09 FOR DEF 8,500 8,500 - 0.0%
FUND TFR -RECREATION 87,400 101,800 14,400 16.5%
FUND TFR -TABERNACLE 167,700 124,200 (43,500) -25.9%
FUND TFR -JOINT FIRE EQUIP 35,000 35,000 - 0.0%
FUND TFR AIRPORT RELOC.RESERVE 100,000 50,000 (50,000) -50.0%
FUND TFR -ANIMAL CONTROL FUND 163,600 178,500 14,900 9.1%
FUND TFR -REXBURG ORCHESTRA 5,000 5,000 - 0.0%
FUND TFR -JOINT FIRE OPERATION 1,119,100 1,204,000 84,900 7.6%
FUND TFR -R RAPIDS CAP REPLACE 60,000 65,000 5,000 8.3%
2,422,500$ 2,686,600$ 264,100$ 10.9%
Street Funds
Fund Description Fund
2019
Forecasted
Carryover
2020
Budgeted
Carryover
Accounts
Receivable
5/23/19 Notes
Street Operations 2 -$ -$ 34,661$
Transfer to street
repair fund at
Yearend
Street Impact 33 1,262,100$ 12,100$
To be spent on
East Parkway
ROW and 2nd E
7th N
Improvements
Street Repair 43 276,300$ 179,400$ 281,695$
AR mostly URA
Washington District
Project on 2nd W
and 1st N.
New Street Construction 44 426,100$ 426,100$ 28,008$
Most Projects
qualify for DIF or
URA
Total 1,964,500$ 617,600$ 344,364$
Total Available Cash/Investments 1,620,136$
Sanitation Fund 2019 2020
Fund Description Fund
Year End
Forecasted
Reserve*
Year End
Budgeted
Reserve*Notes
Sanitation Operations 25 626,051$ 768,551$
Water Funds 2019 2020
Fund Description Fund
Year End
Forecasted
Reserve*
Year End
Budgeted
Reserve*Notes
Water Operations 26 5,683,050$ 5,288,050$
Water Capital Reserve 34 2,188,800$ 2,062,100$
Water Capital Construction 42 -$
Water Line Extension 46 -$
Total 7,871,850$ 7,350,150$
Wastewater Funds 2019 2020
Fund Description Fund
Year End
Forecasted
Reserve*
Year End
Budgeted
Reserve*Notes
Sewer Operations 27 3,465,442$ 689,642$
Sewer Capital Reserve 35 719,600$ 847,200$
Sewer Plant Construction 52 -$ -$
Sewer Line Extension 46 -$ -$
Total 4,185,042$ 1,536,842$
*Cash/Investments/Net Accounts Receivable
Rates TBD-Consider a slight rate
reduction in 2020 (forecast shown
includes reduction)
Rates TBD-Projected to increase
approximately 1.8% for a typical
resident
Doing in Fund 27 until WW Plant
Final Phase Project closed out
Hope to finalize DEQ loan in
2020
Transfer in from Fund 26 & loan
proceeds to zero out fund
Doing in Fund 26 until Water
Upgrade Project closed out in
Rates TBD-Projected to increase
up to 1.7% for typical resident.
Funding from
Sugar/Teton/Developers with
Clawback TBD for Gravity Line
($2.3 M)
Will be exhausted by bond
payment/expansion projects
Transfer in from Fund 27 and 35
to zero out fund