FY 2019-2023 Capital Improvement Plan

City of Spencer, Iowa Solid Waste Enterprise Fund

EXHIBIT 1

Growth Assumptions

Solid Waste Rate Adjustments

Tonnage Growth Other O&M Expenses

0.00%

1-Jul-16 1-Jul-17 1-Jul-18 1-Jul-19

2.00% 2.00% 3.00% 4.00%

1-Jul-20 1-Jul-21 1-Jul-22 1-Jul-23

4.00% 4.00% 4.00% 4.00%

Var.

Interest Rate - Cash Balances

0.85%

Budget Projected FY 2014-15 FY 2015-16 FY 2016-17 FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 Audited Financial Statements Budget Projected Projected Projected Projected

Solid Waste Closure Reserve Beginning Balance

$16,978

$17,122

$17,276

$17,436

$17,436

$17,436

$17,436

$17,436

$17,436

$17,436

53 54 55 56

Operating Transfers Capital Expenditures

144

154

160

0 0

0 0

0 0

0 0

0 0

0 0

0 0

0

0

0

Ending Balance

$17,122

$17,276

$17,436

$17,436

$17,436

$17,436

$17,436

$17,436

$17,436

$17,436

Total Cash Balance

57 $1,382,022 $1,436,261 $1,596,319 $1,650,052 $1,692,056 $1,445,631 $1,355,416 $1,185,840 $1,175,436 $1,128,178

Deposit to Solid Waste Reserve

$100,000

$0

$430,000

$90,000

$105,000

$125,000

$140,000

Solid Waste Operating Capital Outlays FY 2017-18 FY 2018-19 FY 2019-20 FY 2020-21 FY 2021-22 FY 2021-23 FY 2023-24 Commercial Packer $0 $0 $0 $180,000 $0 $0 $0 Automated Residential Truck 0 0 260,000 0 275,000 0 0 Container Replacement 15,000 15,000 18,000 18,000 18,000 18,000 18,000 Transfer Trailers 0 75,000 0 0 0 0 0 Automated Arm Replacement 0 0 15,500 0 0 0 0 Tipping Edge Rehab 0 10,000 0 0 0 0 0 Lighting Upgrade 0 0 50,000 0 0 0 0 Scale Installation 200,000 0 0 0 0 0 0 Transfer Station Interior Lining 0 55,000 0 0 0 0 0 Sewer Hookup 25,000 0 0 0 0 0 0 Semi Truck 0 0 0 0 0 130,000 0 Tractor 30,000 0 0 0 0 0 0 Miscellaneous 0 0 0 0 0 0 182,000 Total $270,000 $155,000 $343,500 $198,000 $293,000 $148,000 $200,000 ^ ^ ^

Prepared by PFM Financial Advisors LLC