2018-2022 Capital Improvement Plan (CIP) and 2018-2022 Equipment Replacement Plan (ERP); BishopCity of Hopkins
MEMORANDUM
Date: November 13th, 2017
To: Mayor & City Council
From: Nick Bishop, Finance Director
Subject: 2018-2022 Capital Improvement Plan (CIP)
2018-2022 Equipment Replacement Plan (ERP)
The CIP has undergone additional changes since the last council work session. All funds have
the ability fund requested projects except the Capital Improvements Fund and the Arts Center
Special Revenue Fund. The costs for a City Hall Lobby Upgrade have been moved from 2018
to 2019. The amount previously budgeted, $260,000, will not satisfy the needs identified in the
City Hall Facility Assessment. Staff will looking for input and direction related to the Capital
Improvement Fund. The Arts Center Special Revenue Fund budget will also be discussed
during this meeting as part of a separate agenda item.
The working capital projections for the enterprise funds are being refined and will be available at
the work session.
The ERP has undergone two changes since the last council work session. A tax levy was
added in years 2019-2022, which is consistent with the 2017-2021 ERP. These amounts will be
adjusted each year to reflect only what is needed. The interfund loan payback period was also
increased. Staff will again be looking for input on a financing approach that can sustain this
fund in future years.
FINANCE DEPARTMENT
City of Hopkins
Park Capital Improvements Fund (301)
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET
2016 2017 2018 2019 2020 2021 2022
Working Capital Begin Year 258,547 760,900 994,410 432,654 213,781 147,719 287,496
Revenues
Franchise Fees 296,520 295,300 295,300 295,300 295,300 295,300 295,300
Dedication Fees-Oxford Village 40,700 - - - - - -
Dedication Fees-Moline - 180,750 - - -
Dedication Fees-Creekview Apartments - - 390,000 - -
Dedication Fees-Cold Storage - - - 300,000 -
Interest earnings 4,886 7,609 9,944 4,327 2,138 1,477 2,875
Hennepin County Grants 180,000 - - - - - -
Donations 134,689 - - - - - -
Bond Proceeds 1,473,215 1,829,097 - - - - -
Total Revenues 2,130,010 2,312,756 695,244 599,627 297,438 296,777 298,175
Expenditures
Current 12,423 7,000 7,000 7,000 7,000 7,000 7,000
Capital Projects 1,605,234 1,967,246 1,140,000 701,500 246,500 40,000 83,200
Bond Payment Contribution (2015)10,000 10,000 10,000 10,000 10,000 10,000 10,000
Bond Payment Contribution (2016)95,000 100,000 100,000 100,000 100,000 100,000
Bond Payment Contribution (2017)- - - - -
Total Expenditures 1,627,657 2,079,246 1,257,000 818,500 363,500 157,000 200,200
Working Capital Ending Balance 760,900 994,410 432,654 213,781 147,719 287,496 385,471
(Unrestricted Net Position)
City of Hopkins
Capital Improvements Fund (305)
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET
2016 2017 2018 2019 2020 2021 2022
Working Capital Begin Year 67,621 (245,928) 87,572 (90,052) 96,047 129,007 260,297
Revenues from charges
Tax Levy per FMP 122,409 310,000 100,000 100,000 100,000 100,000 100,000
Interest earnings 187 - 876 (901) 960 1,290 2,603
Other revenues 3,371 - - - - - -
Bond Proceeds - - - - - - -
Transfer In from General Fund 125,000 100,000 100,000 100,000 100,000 100,000 100,000
Transfer In from Enterprise Funds 400,000 - - - - - -
Interfund Loan or Bond Proceeds - - - 500,000 - - -
Total Revenues 650,967 410,000 200,876 699,099 200,960 201,290 202,603
Expenditures
Current 123,530 - - - - - -
Capital Projects 840,986 76,500 378,500 513,000 168,000 45,000 21,761
Repay Interfund Loan 25,000 200,000
Total Expenditures 964,516 76,500 378,500 513,000 168,000 70,000 221,761
Working Capital Ending Balance (245,928) 87,572 (90,052) 96,047 129,007 260,297 241,139
(Unrestricted Net Position)
City of Hopkins
Municipal State Aid Fund (302)
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET2016201720182019202020212022
Working Capital Begin Year 422,235 (253,875) (256,414) (258,978) 138,432 539,816 245,214
Revenues
State MSA Funds, projects 707,492 - - 400,000 400,000 400,000 400,000
Interest Earnings (6,578) (2,539) (2,564) (2,590) 1,384 5,398 2,452
Total Revenues 700,914 (2,539) (2,564) 397,410 401,384 405,398 402,452
Expenditures
CIP State Aid Projects 1,377,024 - - - - 700,000 -
Total Expenditures 1,377,024 - - - - 700,000 -
Working Capital Ending Balance (253,875) (256,414) (258,978) 138,432 539,816 245,214 647,666
(Unrestricted Net Position)
City of Hopkins
Permanent Improving Revolving Fund (501)
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET
2016 2017 2018 2019 2020 2021 2022
Working Capital Begin Year 442,413 (639,073) 287,536 765,911 1,858,270 3,456,853 4,746,422
Revenues
Tax Levy per FMP 2,124 - - - - - -
Special Assessments (Prepaid)277,807 290,700 900,000 1,250,000 1,885,000 1,885,000 500,000
Grants 443,927 4,049,500 5,954,600 5,704,600 - - -
Investments 6,623 (6,391) 2,875 7,659 18,583 34,569 47,464
Bond Proceeds 4,341,871 16,895,000 3,100,000 5,000,000 3,800,000 3,500,000 1,500,000
Transfer In - Enterprise Funds - 405,000 - - - - -
Total Revenues 5,072,352 21,228,809 9,957,475 11,962,259 5,703,583 5,419,569 2,047,464
Expenditures
Current 26,245 - - - - - -
Residential Street Improvements 4,180,751 8,530,700 2,159,200 3,225,000 3,710,000 3,710,000 1,150,000
8th Avenue Construction 6,335,500
Light Rail Transit Stations - 800,000 - - -
Pedestrian & Bicycle Access Improvements 25,000 25,000 25,000 25,000 25,000
Blake Road Corridor Improvements 5,100,000 6,974,900 6,474,900 - - -
Street Overlay Improvements 336,000 300,000 325,000 350,000 375,000 400,000
Street Sign Management 20,000 20,000 20,000 20,000 20,000
Transfer Out 1,946,842
Total Expenditures 6,153,838 20,302,200 9,479,100 10,869,900 4,105,000 4,130,000 1,595,000
Working Capital Ending Balance (639,073) 287,536 765,911 1,858,270 3,456,853 4,746,422 5,198,886
(Unrestricted Net Position)
City of Hopkins
Equipment Replacement Fund (602)
Rate Change 9%9%10%9%9%9%6%
ACTUAL PROJECTED BUDGET BUDGET BUDGET BUDGET BUDGET
2016 2017 2018 2019 2020 2021 2022
Working Capital Begin Year (373,504) 1,172,861 271,121 44,156 75,370 63,991 209,571
Revenues from charges 408,459 445,220 489,742 533,819 581,863 634,231 672,284
Tax Levy 250,000 250,000 250,000 250,000
Transfer in Debt Service Fund 1,896,571 - - - - - -
Interest earnings 6,294 3,000 3,000 3,000 3,000 3,000 3,000
Other revenues (sale of assets)60,424 30,000 30,000 35,000 35,000 35,000 35,000
Enterpirse contribution to software upgrade 57,508 - - - - - -
Equipment Certificates (Bonds)- - 590,000 - - - -
Interfund Loan - 610,000 - - - - -
Total Revenues 2,429,256 1,088,220 1,112,742 821,819 869,863 922,231 960,284
Expenditures (excludes Leases & Depr.) 268,755 76,544 78,840 81,206 83,642 86,151 88,735
Fire Truck Financing Pymnts (2009-2018)53,782 54,217 54,217 - - - -
Capital Outlay - Equipment 560,354 1,859,200 1,006,650 584,400 672,600 530,500 1,014,600
Repayment of Interfund Loan - - 200,000 125,000 125,000 160,000 -
Total Expenses 882,891 1,989,961 1,339,707 790,606 881,242 776,651 1,103,335
Working Capital Ending Balance 1,172,861 271,121 44,156 75,370 63,991 209,571 66,520
(Unrestricted Net Position)