Loading...
2019.09.03 Work Session Packet (1st) 4141 Douglas Drive North • Crystal, Minnesota 55422-1696 Tel: (763) 531-1000 • Fax: (763) 531-1188 • www.crystalmn.gov Posted: August 30, 2019 City Council Work Session Agenda September 3, 2019 6:30 p.m. Conference Room A Pursuant to due call and notice given in the manner prescribed by Section 3.01 of the City Charter, the work session of the Crystal City Council was held at ______ p.m. on September 3, 2019 in Conference Room A, 4141 Douglas Dr. N., Crystal, Minnesota. I. Attendance: Council Members Staff ____ Adams ____ Norris ____ Banks ____ Therres ____ Budziszewski ____ Ray ____ Deshler ____ Revering ____ Kiser ____ Serres ____ LaRoche ____ McGann ____ Parsons ____ Elholm ____ Sutter ____ Gilchrist II. Agenda of discussion items: 1. 2020 preliminary levy and budget. 2. Constituent issues update. 3. New business. * 4. Announcements. * * Denotes no supporting information included in the packet. III. Adjournment: The work session adjourned at ______ p.m. Auxiliary aids are available upon request to individuals with disabilities by calling the City Clerk at (763) 531- 1145 at least 96 hours in advance. TTY users may call Minnesota Relay at 711 or 1-800-627-3529. September 3, 2019 What has changed Fiscal disparity overview General and capital property tax levies Property tax levy options Public Safety Facility Street Infrastructure investment Fiscal disparities for 2020 Total Tax Capacity Less Contribution Less Tax Increment Plus Distribution Net Tax Capacity 2020 22,426,399 1,297,703 278,074 4,913,996 25,764,618 2019 19,577,862 1,216,174 212,599 2,251,066 20,400,155 Change 14.5%81,529 65,475 2,662,930 5,364,463 Contribution to fiscal disparities reduces tax capacity resulting in lower tax base to distribute overall levy Distribution to fiscal disparities increase tax capacity resulting in higher tax base to distribute overall levy Distribution allocation increased by 14.5% 10.00%11.00%12.00%13.00%9.03%2019 Levy General Fund 10,488,040$ 10,488,040$ 10,488,040$ 10,488,040$ 10,488,040$ 9,716,249$ Capital Funds 5,505,618 5,614,888 5,714,888 5,815,888 5,416,345 1,626,883 Total Levy 15,993,658$ 16,102,928$ 16,202,928$ 16,303,928$ 15,904,385$ 11,343,132$ Less: Distribution from fiscal disparities (4,913,996) (4,913,996) (4,913,996) (4,913,996) (4,913,996) (2,251,066) City Net Levy 11,079,662$ 11,188,932$ 11,288,932$ 11,389,932$ 10,990,389$ 9,092,066$ Tax Capacity Personal and Real Estate 22,426,399$ 22,426,399$ 22,426,399$ 22,426,399$ 22,426,399$ 19,577,862$ Less: Contribution to fiscal disparities (1,297,703) (1,297,703) (1,297,703) (1,297,703) (1,297,703) (1,216,174) Less: Tax Increment (278,074) (278,074) (278,074) (278,074) (278,074) (212,599) Adjusted net tax capacity 20,850,622$ 20,850,622$ 20,850,622$ 20,850,622$ 20,850,622$ 18,149,089$ Taxes per Capita 686$ 686$ 686$ 703$ 686$ 491$ Median Home Value (Jan 2)201,880$ 201,880$ 201,880$ 201,880$ 201,880$ 196,000$ Median Home Taxes (from city)971$ 981$ 990$ 999$ 964$ 884$ % change from prior year $'s 9.92%11.00%12.00%13.00%9.03%8.02% Median Home dollar change from prior year 88 97 106 115 80 66 Estimated Investment $16,000,000 Cash on hand $6,000,000 2020 Property tax levy 3,500,000 2021 Property tax levy 3,570,000 2022 Property tax levy 2,930,000 Total $16,000,000 •If fiscal disparities change then combination of savings/bonding alternative should be considered. •In 2021 an internal loan from Streets to Buildings in amount of $2,700,000 should be considered. Internal loan to be repaid in two years With fiscal disparity change, current projections result in $39M available at end of 2030 Infrastructure needs should be consistently monitored, and funding reallocated as needed Property tax levy percent increase Public Safety facility CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN Prepared on August 29, 2019 Prepared by AEM Financial Solutions, LLC. City of Crystal, Minnesota Long Term Plan Table of Contents Page No. Compilation Disclosure 3 Introductory Section Transmittal Letter 5 Financial Section Schedule of Property Taxes Levied and Tax Rates 9 Schedule of Annual Fund Cash Balances 13 Outstanding Debt Schedule 15 Capital Improvement Plan Street Capital Fund 415 Schedule of Planned Capital Outlay 2019 to 2030 17 Schedule of Projected Revenue, Expenditures and Debt 21 Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2019 to 2030 23 Schedule of Projected Revenue, Expenditures and Debt 27 Park Improvements 420 Schedule of Planned Capital Outlay 2019 to 2030 29 Schedule of Projected Revenue, Expenditures and Debt 31 Major Building Replacement Fund 408/625 Schedule of Planned Capital Outlay 2019 to 2030 33 Schedule of Projected Revenue, Expenditures and Debt 39 Fleet Fund 615 Schedule of Planned Capital Outlay 2019 to 2030 41 Statement of Cash Flows 45 Information Technology Fund 620 Schedule of Planned Capital Outlay 2019 to 2030 47 Statement of Cash Flows 53 Water Fund 505 Schedule of Planned Capital Outlay 2019 to 2030 55 Statement of Cash Flows 57 Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2019 to 2030 59 Statement of Cash Flows 61 Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2019 to 2030 63 Statement of Cash Flows 65 Street Light Fund 520 Schedule of Planned Capital Outlay 2019 to 2030 67 69 71 Statement of Cash Flows Selected Graphical Data from Projections 2 August 29, 2019 COMPILATION DISCLOSURE Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, MN 55422 We have compiled the accompanying forecasted long-term plan that includes property tax, tax rate, fund balance and debt projections based on input from the City Council and City staff. This projection incorporates estimates through December 31, 2030 for all presented funds. This forecast was compiled in accordance with attestation standards established by the American Institute of Certified Public Accountants. A compilation is limited to presenting in the form of forecast information that is the representation of management and does not include evaluation of the support for the assumptions underlying the forecast. We have not examined the forecast and, accordingly, do not express an opinion or any other form of assurance on the accompanying statements or assumptions. Furthermore, there will usually be differences between the forecasted and actual results because events and circumstances frequently do not occur as expected, and those differences may be material. We have no responsibility to update this report for events and circumstances occurring after the date of this report. Sincerely, AEM FINANCIAL SOLUTIONS, LLC 3 INTRODUCTORY SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 4 August 29, 2019 Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, MN 55422 Introduction As discussed in prior communications to the City Council, we have been preparing a long term plan for the City that is intended to give a big picture view of the status now and five years from now. We have measured and projected operations, capital and debt for the City based on assumptions made by management. The City’s assumptions m ade are as follows: Assumptions The following assumptions have been used to calculate the projections in this report: Rates Interest Earnings 1.00% Governmental Fund Revenue Growth 3.00% Governmental Fund Expenditure Growth 3.00% Water and Sanitary Sewer Funds 2020 - 2022 15.00% 2023 - 2024 10.00% 2025 - 2030 0.00% Storm Drainage Fund Expense Growth(1)5.00% Street Lighting 2.00% General Fund Levy Growth 3.00% EDA Fund Levy Growth 2.00% Population Growth 0.49% Median Home Value Growth 3.00% Tax Capacity Growth Rate (Including Fiscal Disparities)3.00% Governmental Fund Debt Interest Rate 3.00% Governmental Fund Debt Term 15 5 Assumptions with Future Action • General Fund property tax revenue has been increased for 2020 based on the results of the long-term plan and the Park System Master Plan. o General Fund payroll allocation for Community Development Director increased by $31,554 offset by an EDA payroll allocation decrease of the same amount in 2020. o JCPP cost allocation has been reduced by the County resulting in the City absorbing the additional cost - $30,000. • Fire Equipment Revolving Fund 409 will require further review and analysis. Beginning in 2020, a property allocation of $100,000 has been incorporated into the plan. At this time we do not have a capital schedule for Fire. It is recommended to work with West Metro Fire-Rescue District to incorporate a capital plan into the City long-term plan. • Fleet Fund 615 will require additional analysis and discussion regarding future charge out rates. Internal Fleet charge out rates begin in 2021 based on this analysis. Reserves of $1,200,000 have been allocated to individual fleet replacements to reduce future contributions from the general fund. Enterprise fund replacements are expected to pay 100% of cost. • PERF Fund 235 requires an additional levy beginning in 2020 in order to stay within policy guidelines and capital needs. • Information Technology (IT) Fund 620 was established as an internal service fund to provide for the ongoing operations and replacement of the City’s IT services. In 2019, the operations charge out rate was implemented. Additional analysis has been completed regarding the charge out rate for future years. Continued review is encouraged to ensure technology needs are met • Storm Drainage Fund 515 includes several grant assumptions for major infrastructure projects. Anticipated funding sources include: watershed, Met Council, MNDNR and other resources. If these grants are not secured, financing for these projects may need to be considered. • The Building Fund future costs have been analyzed and internal charges are programmed to begin in 2021. Key Highlights • At December 31, 2017 the General fund had a 51.7 percent operating reserve. This operating reserve percentage will be updated when the 2018 audit is finalized. The Minnesota Office of the State Auditor defines an adequate reserve as 35-50 percent of the General fund expenditures. A 45 percent fund balance reserve has been assumed in the long-term plan. The projected General Fund reserve balance is anticipated to remain at or above 45 percent rage throughout the life of this Plan. We anticipate the General fund levy will grow by an average of 3 percent to maintain the desired reserve level. • The tax levy is projected to increase from $9.0 million (2019 adopted) to $17.7 million (2030 projected) over the duration of this Plan based on the anticipated debt issuance for the police facility along with other capital levy needs. The levy increase will result in an increase in the projected tax rate, ranging from 50.097 percent (2019) to 56.466 percent throughout the life of this Plan. A decrease in the tax levy or applicable tax rate is not anticipated, given the capital needs outlined in our report. o Tax capacity is assumed to grow at a rate of 5 percent during the duration of this Plan. A growth in tax rate in excess of these projections may result in lower tax rates in future years. o The future captured tax increment capacity has not been analyzed for this report and is assumed to remain the same as it was in 2018. 6 • The annual tax amount for the Median Home is projected to increase from $884 (2019 adopted) to $1,260 (2030) over the duration of this Plan. A decrease in the tax levy or applicable tax rate is not anticipated, given the capital needs outlined in our report. • Total debt outstanding is projected to decrease from $17.2 million (2018 actual) to $3.2 million (2030 projected) over the duration of this Plan. The decrease includes anticipated debt issuance for the police department expansion in 2021 at an estimated $4.8 million dollars. As a result, the debt per capita will fall from an estimated $752 (2018 actual) per household to an estimated $135 (2030 projected) over the duration of this Plan. • The fiscal disparities distribution increased from $2,251,066 in 2019 to $4,913,996 in 2020. This change results in the city having the ability to increase the 2020 capital levy by $3,500,000. • Due to planned capital projects, the total cash position of the City is projected to increase from $45.9 million (2018 actual) to $73.2 million over the duration of this Plan. • Several funds were not analyzed for the purposes of this report and include a 1 percent interest rate earnings assumption the cash balance. These funds include: TIF Districts, Special Projects, Cable TV Equipment, Recycling, Self Insurance and Hennepin Recycling Group. The actual cash results for the years 2018 - 2030 will vary from the results estimated in this report. 7 FINANCIAL SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 8 2018 2019 2020 2021 2022 Actual Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Property Taxes Levied for General Purposes 100 General 9,436,779$ 9,716,249$ 10,488,040$ 11,320,182$ 11,659,787$ 220 EDA/HRA Funds 277,200 282,744 288,399 294,167 300,050 415 Street Capital 163,600 110,144 116,950 121,628 126,493 235 PERF Fund 151,900 154,938 208,037 231,197 244,421 405 PIR Fund 301,210 - - - - 408 Building Fund 574,400 585,888 4,097,606 4,179,558 4,263,149 420 Park Improvements - 248,310 358,914 483,778 613,275 409 Fire Equipment Revolving 100,000 100,000 100,000 615 Fleet - 85,680 86,537 87,402 88,276 620 Information Technology - 159,179 159,902 - - Total Taxes Levied 10,905,089 11,343,132 15,904,385 16,817,913 17,395,453 Less: Value of Market Value Levies - - - - - Less: Distribution from fiscal disparities (2,186,657) (2,251,066) (4,913,996) (5,061,416) (5,213,258) City Net Levy 8,718,432$ 9,092,066$ 10,990,389$ 11,756,497$ 12,182,195$ Tax Capacity Personal and Real Estate 18,459,975$ 19,577,862$ 22,426,399$ 23,099,191$ 23,792,167$ Other assumed net growth factors - - - - - Less: Contribution to fiscal disparities (1,079,088) (1,216,174) (1,297,703) (1,336,634) (1,376,733) Less: Tax Increment (212,599) (212,599) (278,074) (278,074) (278,074) Adjusted net tax capacity 17,168,288$ 18,149,089$ 20,850,622$ 21,484,483$ 22,137,360$ City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates For the Years Ended December 31, 2017 and 2018 (Actual) and 2019 to 2030 (Estimated) 9 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 12,159,581$ 12,674,368$ 13,054,599$ 13,446,237$ 14,069,061$ 14,664,284$ 15,104,213$ 15,557,339$ 306,051 312,172 318,416 324,784 331,280 337,905 344,664 351,557 131,553 136,815 142,288 147,979 153,898 160,054 166,456 173,115 257,710 261,064 274,485 287,975 301,535 315,165 328,869 342,646 - - - - - - - - 4,348,412 4,435,381 4,435,381 4,435,381 4,435,381 4,435,381 4,435,381 4,435,381 747,533 886,656 1,030,752 1,179,932 1,334,310 1,494,004 1,659,134 1,829,827 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 89,159 90,051 90,951 91,861 92,779 93,707 94,644 95,590 - - - - - - - - 18,139,999 18,896,507 19,446,872 20,014,148 20,818,243 21,600,500 22,233,360 22,885,454 - - - - - - - - (5,369,656) (5,530,746) (5,696,668) (5,867,568) (6,043,595) (6,224,903) (6,411,650) (6,604,000) 12,770,343$ 13,365,761$ 13,750,203$ 14,146,580$ 14,774,648$ 15,375,597$ 15,821,710$ 16,281,455$ 24,505,932$ 25,241,110$ 25,998,343$ 26,778,293$ 27,581,642$ 28,409,091$ 29,261,364$ 30,139,205$ - - - - - - - - (1,418,035) (1,460,576) (1,504,393) (1,549,525) (1,596,011) (1,643,891) (1,693,208) (1,744,004) (278,074) (278,074) (278,074) - - - - - 22,809,823$ 23,502,459$ 24,215,875$ 25,228,768$ 25,985,631$ 26,765,200$ 27,568,156$ 28,395,201$ 10 2018 2019 2020 2021 2022 Actual Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Tax Rates General 45.09%44.01%35.40%37.49%37.53% Capital levies 5.69%6.09%17.31%17.23%17.50% Scheduled debt levies 0.00%0.00%0.00%0.00%0.00% Total City Levy Tax Rate 50.782%50.097%52.710%54.721%55.030% Total EDA Tax Rate 1.274%1.244%1.131%1.125%1.120% Population 22,967 23,080 23,193 23,307 23,307 Taxes per Capita 475$ 491$ 686$ 722$ 746$ Median Home Value (Jan 2)182,000$ 196,000$ 201,880$ 207,936$ 214,174$ Median Home Taxes (from city)818 884 964 1,036 1,080 % Change from prior year $'s 16.31%8.02%9.03%7.56%12.05% Median Home dollar change from prior year 115 66 80 73 43 Tax Levy ($) General 9,436,779$ 9,716,249$ 10,488,040$ 11,320,182$ 11,659,787$ Capital 1,191,110 1,184,960 4,968,044 5,203,564 5,435,615 Economic Development Authority 277,200 282,744 288,399 294,167 300,050 Debt service - - - - - Tax Levy (%) General 86.54%85.66%65.94%67.31%67.03% Capital 10.92%10.45%31.24%30.94%31.25% Economic Development Authority 2.54%2.49%1.81%1.75%1.72% Debt Service 0.00%0.00%0.00%0.00%0.00% For the Years Ended December 31, 2017 and 2018 (Actual) and 2019 to 2030 (Estimated) City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates (Continued) 11 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 38.17%38.78%38.75%38.29%39.05%39.62%39.60%39.59% 17.81%18.08%18.03%17.78%17.81%17.83%17.79%17.75% 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 55.986%56.870%56.782%56.073%56.857%57.446%57.391%57.339% 1.114%1.109%1.103%1.097%1.091%1.085%1.079%1.073% 23,421 23,536 23,651 23,767 23,884 24,001 24,118 24,237 775$ 803$ 822$ 842$ 872$ 900$ 922$ 944$ 220,600$ 227,218$ 234,034$ 241,055$ 248,287$ 255,736$ 263,408$ 271,310$ 1,138 1,197 1,237 1,264 1,327 1,387 1,434 1,482 9.77%10.82%8.76%5.68%7.26%9.72%8.08%6.84% 58 59 41 27 63 60 47 48 12,159,581$ 12,674,368$ 13,054,599$ 13,446,237$ 14,069,061$ 14,664,284$ 15,104,213$ 15,557,339$ 5,674,367 5,909,966 6,073,856 6,243,127 6,417,902 6,598,310 6,784,484 6,976,558 306,051 312,172 318,416 324,784 331,280 337,905 344,664 351,557 - - - - - - - - 67.03%67.07%67.13%67.18%67.58%67.89%67.93%67.98% 31.28%31.28%31.23%31.19%30.83%30.55%30.51%30.48% 1.69%1.65%1.64%1.62%1.59%1.56%1.55%1.54% 0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% 12 2017 2018 2019 2020 2021 Actual Actual Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Government-Type General Operations 101 General 7,380,956$ 7,604,564$ 7,604,564$ 7,604,564$ 7,604,565$ Special Revenue 220 Economic Development Authority 3,190,635 3,357,844 2,128,636 2,077,289 2,021,514 *206-210 TIF Districts Special Revenue 1,817,122 1,154,369 1,165,913 1,177,572 1,189,348 *240-245 Special Projects 98,913 144,472 144,473 144,474 144,475 Subtotal 5,106,670 4,656,685 3,439,022 3,399,335 3,355,337 Debt Service 329-337 Debt Service 5,282,301 6,062,087 6,007,982 5,962,715 5,920,732 Capital Projects 405 Capital Improvement Revolving 8,229,232 - 399,581 - - 415 Street Reconstruction 6,049,965 8,249,930 8,005,554 6,596,190 5,372,848 409 Fire Equipment Revolving - - - 100,000 202,750 235 Police Equipment Revolving 3,080,805 2,838,545 2,841,482 2,849,713 2,831,267 410 Street Maintenance 1,696,364 - - - - 420 Park Improvement 210,780 1,935,048 1,184,708 1,319,470 1,070,442 *404 Cable TV Equipment 108,477 149,793 151,291 152,804 154,332 Subtotal 19,375,623 13,173,316 12,582,617 11,018,177 9,631,640 Total - Governmental-type Funds 37,145,550 31,496,652 29,634,185 27,984,791 26,512,273 Internal Service 620 Information Technology - 483,992 479,175 800,553 787,380 408/625 Building 644,615 3,339,340 4,405,377 8,927,293 (2,681,120) 615 Fleet - 2,790,279 2,261,061 1,650,674 1,446,137 *605 Self Insurance 898,302 697,711 704,688 711,735 718,852 Total - Internal Service-type Funds 1,542,917 7,311,322 7,850,301 12,090,255 271,250 Business-Type Enterprise Funds 505 Water 953,039 1,366,637 1,075,213 794,624 804,758 510 Sewer 2,121,076 2,116,511 1,524,051 502,924 554,600 515 Storm Drainage 787,914 1,556,505 1,091,994 1,287,541 953,391 520 Street Lights 488,501 602,471 649,730 709,982 767,133 *525 Recycling 120,021 126,355 127,619 128,895 130,184 Total - Business-type Funds 4,470,551 5,768,479 4,468,607 3,423,965 3,210,066 Agency Fund *250 Hennepin Recycling Group 1,399,536 1,289,199 1,302,091 1,315,112 1,328,263 Grand Total - City 44,558,554$ 45,865,652$ 43,255,185$ 44,814,124$ 31,321,852$ *Annual growth in fund balance of 1% assumed Trend indicator Adequate for reserve levels Adequate as of 2016 but decreasing balances, watch Below targeted reserve levels and should have a plan to address The fund has events in the future that need addressing now City of Crystal, Minnesota Schedule of Annual Fund Cash Balances For the Years Ended December 31, 2017 and 2018 (Actual) and 2019 to 2030 (Estimated) 13 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Trend 7,604,565$ 7,754,565$ 8,059,065$ 8,372,700$ 8,695,744$ 9,028,480$ 9,371,198$ 9,724,197$ 10,087,786$ 1,961,124 1,895,922 1,825,704 1,750,257 1,669,363 1,582,793 1,490,315 1,391,682 1,286,644 1,201,241 1,213,253 1,225,386 1,237,640 1,250,016 1,262,516 1,275,142 1,287,893 1,300,772 144,476 144,477 144,478 144,479 144,480 144,481 144,482 144,483 144,484 3,306,841 3,253,653 3,195,568 3,132,376 3,063,859 2,989,791 2,909,938 2,824,058 2,731,900 5,887,056 5,761,836 5,639,226 5,639,226 5,639,226 5,639,226 5,639,226 5,639,226 5,639,226 - - - - - - - - - 4,387,067 3,310,768 5,240,968 4,433,942 3,624,536 2,812,954 1,999,411 1,184,134 19,361 308,326 416,805 528,267 642,794 760,471 881,384 1,005,622 1,133,276 1,264,442 2,814,834 2,901,125 2,954,867 2,937,171 2,860,159 2,971,958 2,878,699 2,829,512 2,918,024 - - - - - - - - - 1,093,422 1,530,889 1,011,854 1,851,725 2,279,174 3,585,275 3,449,131 4,171,757 4,617,301 155,875 157,434 159,008 160,598 162,204 163,826 165,465 167,119 168,791 8,759,523 8,317,021 9,894,965 10,026,230 9,686,544 10,415,398 9,498,327 9,485,798 8,987,918 25,557,985 25,087,074 26,788,823 27,170,532 27,085,373 28,072,894 27,418,689 27,673,279 27,446,830 773,555 759,868 749,989 743,188 734,741 725,110 714,689 704,541 694,548 2,021,824 6,503,939 10,812,844 15,573,838 20,382,442 25,645,132 30,606,449 35,608,379 39,702,328 1,423,271 1,194,150 1,407,430 1,022,794 918,863 706,099 833,088 909,005 552,907 726,041 733,301 740,634 748,041 755,521 763,076 770,707 778,414 786,198 4,944,690 9,191,259 13,710,897 18,087,860 22,791,567 27,839,417 32,924,934 38,000,339 41,735,982 723,076 820,377 719,750 749,586 750,086 830,512 851,922 1,055,708 1,211,716 455,506 415,977 448,761 471,547 592,113 611,647 468,448 527,269 487,749 566,423 892,067 1,230,063 1,593,485 1,523,806 1,337,646 1,907,825 1,113,394 243,948 820,844 370,756 411,486 447,578 478,599 504,092 523,573 536,525 542,404 131,486 132,800 134,128 135,470 136,824 138,193 139,575 140,970 142,380 2,697,335 2,631,979 2,944,188 3,397,665 3,481,429 3,422,090 3,891,342 3,373,866 2,628,196 1,341,546 1,354,961 1,368,511 1,382,196 1,396,018 1,409,978 1,424,078 1,438,319 1,452,702 34,541,556$ 38,265,273$ 44,812,419$ 50,038,253$ 54,754,387$ 60,744,379$ 65,659,043$ 70,485,802$ 73,263,710$ 14 2017 2018 2019 2020 Original Issue Maturity Interest Actual Actual Estimated Estimated Fund Issue Issue Date Date Rate Balance Balance Balance Balance Government-Type General Obligation Bonds 327 2005B General Obligation Aquatic Center Bond 2,395,000$ 9/1/2005 2/1/2020 3.50-4.00%%-$ -$ -$ -$ 326 2005A Special Assessment 1,440,000 9/14/2005 2/1/2021 3.50-4.00%- - - - 328 2006A Special Assessment 1,855,000 6/29/2006 2/1/2022 3.75-4.20%- - - - 329 2008A Special Assessment 2,190,000 8/1/2008 2/1/2024 3.50-4.35%900,000 760,000 625,000 495,000 330 2009A Special Assessment 3,360,000 7/21/2009 2/1/2030 2.00-4.50%2,020,000 1,845,000 1,675,000 1,505,000 331 2013B Street Reconstruction 85,940 - - - - 332 2011A Special Assessment 1,705,000 7/19/2011 2/1/2027 0.50-3.55%1,030,000 910,000 795,000 685,000 333 2012A Special Assessment 2,635,000 7/16/2013 2/1/2028 0.50-3.55%1,805,000 1,615,000 1,430,000 1,250,000 334 2013A Special Assessment 3,235,000 6/17/2015 2/1/2029 0.50-3.55%2,525,000 2,285,000 2,050,000 1,825,000 335 2015A Special Assessment 2,550,000 7/16/2015 2/1/2031 2.50-3.00%2,325,000 2,130,000 1,940,000 1,755,000 336 2016A Special Assessment 3,330,000 8/25/2016 2/1/2032 2.00-2.50%3,330,000 3,050,000 2,795,000 2,550,000 337 2017A Special Assessment 4,665,000 9/14/2017 2/1/2033 2.00-3.00%4,665,000 4,665,000 4,250,000 3,920,000 408 Police Building - 2020 12,000,000 1/1/2020 2/1/2035 3%- - - - Total G.O. Tax Bonds 41,445,940 18,600,000 17,260,000 15,560,000 13,985,000 Total Government-Type 41,445,940$ 18,600,000$ 17,260,000$ 15,560,000$ 13,985,000$ Population 22,855 22,967 23,080 23,193 Debt Per Capita - total 814$ 752$ 674$ 603$ City of Crystal, Minnesota Outstanding Debt Schedule 15 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Balance Balance Balance Balance Balance Balance Balance Balance Balance Balance -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - 365,000 240,000 120,000 - - - - - - - 1,340,000 1,180,000 1,020,000 865,000 715,000 565,000 420,000 275,000 135,000 - - - - - - - - - - - 575,000 470,000 370,000 270,000 175,000 85,000 - - - - 1,080,000 915,000 750,000 590,000 435,000 285,000 140,000 - - - 1,605,000 1,390,000 1,180,000 975,000 770,000 570,000 375,000 185,000 - - 1,575,000 1,400,000 1,230,000 1,065,000 900,000 740,000 585,000 435,000 285,000 140,000 2,310,000 2,075,000 1,845,000 1,620,000 1,400,000 1,185,000 975,000 770,000 570,000 375,000 3,595,000 3,280,000 2,965,000 2,655,000 2,345,000 2,040,000 1,740,000 1,440,000 1,145,000 855,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 4,800,000 17,245,000 15,750,000 14,280,000 12,840,000 11,540,000 10,270,000 9,035,000 7,905,000 6,935,000 6,170,000 17,245,000$ 15,750,000$ 14,280,000$ 12,840,000$ 11,540,000$ 10,270,000$ 9,035,000$ 7,905,000$ 6,935,000$ 6,170,000$ 23,307 23,421 23,536 23,651 23,767 23,884 24,001 24,118 24,237 24,356 740$ 672$ 607$ 543$ 486$ 430$ 376$ 328$ 286$ 253$ 16 City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Public works 2018 Flashing yellow arrows at county signals 32,000$ -$ -$ Public works 2018 Phase 16 Skyway remaining costs 311,747 - - Public works 0415.6305 0009 2019 Sidewalk shaving (trip hazard removal)20,000 20,000 - Public works 0415.6305 0011 2019 Misc concrete work 55,000 55,000 - Public works 0415.6305 0010 2019 Winpark Drive Reconstruction 225,000 225,000 - Public works 0415.6305 0009 2019 Contract mill and overlay 500,000 500,000 - Public works 0415.6305 0015 2019 Crack sealing 10,000 10,000 - Public works 0415.6305 0014 2019 Flashing yellow arrows 20,000 20,000 - Public works 0415.6305 0009 2019 ADA Ped Ramp replacements 60,000 60,000 - Public works 0415.6305 TBA 2020 In house mill and overlay 52,500 - 52,500 Public works 0415.6305 TBA 2020 Sidewalk shaving (trip hazard removal)20,000 - 20,000 Public works 0415.6305 TBA 2020 Misc concrete work 56,650 - 56,650 Public works 0415.6305 TBA 2020 Contract mill and overlay 1,478,000 - 1,478,000 Public works 0415.6305 TBA 2020 Crack sealing 10,000 - 10,000 Public works 0415.6305 TBA 2020 Flashing yellow arrows 26,000 - 26,000 Public works 0415.6305 TBA 2020 Replace retaining wall Douglas and 36th 75,000 - 75,000 Public works 0415.6305 TBA 2020 ADA Ped Ramp replacements 41,200 - 41,200 Public works 0415.6305 TBA 2021 In house mill and overlay 55,125 - - Public works 0415.6305 TBA 2021 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2021 Misc concrete work 58,350 - - Public works 0415.6305 TBA 2021 Contract mill and overlay 1,276,000 - - Public works 0415.6305 TBA 2021 Crack sealing 10,000 - - Public works 0415.6305 TBA 2021 Flashing yellow arrows 27,000 - - Public works 0415.6305 TBA 2021 ADA Ped Ramp replacements 42,436 - - Public works 0415.6305 TBA 2022 In house mill and overlay 57,881 - - Public works 0415.6305 TBA 2022 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2022 Misc concrete work 60,100 - - Public works 0415.6305 TBA 2022 Contract mill and overlay 846,000 - - Public works 0415.6305 TBA 2022 Crack sealing 10,000 - - Public works 0415.6305 TBA 2022 Construct sidewalk on W. Broadway gap 250,000 - - Public works 0415.6305 TBA ADA Ped Ramp replacements 43,709 - - Public works 0415.6305 TBA 2023 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2023 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2023 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2023 Contract mill and overlay 882,000 - - Public works 0415.6305 TBA 2023 Crack sealing 10,000 - - Public works 0415.6305 TBA 2023 Regent Ave mini-roundabout 250,000 - - Public works 0415.6305 TBA 2023 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2024 Contract mill and overlay 1,120,000 - - Public works 0415.6305 TBA 2024 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2024 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2024 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2024 Crack sealing 10,000 - - Public works 0415.6305 TBA 2024 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2025 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2025 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2025 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2025 Crack sealing 10,000 - - Public works 0415.6305 TBA 2025 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2025 Contract mill and overlay 882,000 - - Public works 0415.6305 TBA 2026 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2026 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2026 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2026 Crack sealing 10,000 - - Public works 0415.6305 TBA 2026 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2026 Contract mill and overlay 882,000 - - Public works 0415.6305 TBA 2027 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2027 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2027 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2027 Crack sealing 10,000 - - Public works 0415.6305 TBA 2027 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2027 Contract mill and overlay 882,000 - - 17 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 55,125 - - - - - - - - - 20,000 - - - - - - - - - 58,350 - - - - - - - - - 1,276,000 - - - - - - - - - 10,000 - - - - - - - - - 27,000 - - - - - - - - - 42,436 - - - - - - - - - - 57,881 - - - - - - - - - 20,000 - - - - - - - - - 60,100 - - - - - - - - - 846,000 - - - - - - - - - 10,000 - - - - - - - - - 250,000 - - - - - - - - - - - - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 882,000 - - - - - - - - - 10,000 - - - - - - - - - 250,000 - - - - - - - - - 45,020 - - - - - - - - - - 1,120,000 - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - 882,000 - - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - 882,000 - - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - 882,000 - - - 18 City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Public works 0415.6305 TBA 2028 In house mill and overlay 60,775$ -$ -$ Public works 0415.6305 TBA 2028 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2028 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2028 Crack sealing 10,000 - - Public works 0415.6305 TBA 2028 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2028 Contract mill and overlay 882,000 - - Public works 0415.6305 TBA 2029 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2029 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2029 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2029 Crack sealing 10,000 - - Public works 0415.6305 TBA 2029 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2029 Contract mill and overlay 882,000 - - Public works 0415.6305 TBA 2030 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2030 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2030 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2030 Crack sealing 10,000 - - Public works 0415.6305 TBA 2030 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2030 Contract mill and overlay 1,230,000 - - Public works 0415.6305 TBA 2020 Utility Reconstruction 300,000 - 300,000 Public works 0415.6305 TBA 2021 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2022 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2023 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2024 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2025 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2026 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2027 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2028 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2029 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2030 Utility Reconstruction 300,000 - - 892,019$ 2,061,370$ 19 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ 60,775$ -$ -$ - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - 882,000 - - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - 882,000 - - - - - - - - - - 60,775 - - - - - - - - - 20,000 - - - - - - - - - 61,903 - - - - - - - - - 10,000 - - - - - - - - - 45,020 - - - - - - - - - 1,230,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 - - - - - - - - - - 300,000 1,790,932$ 1,546,003$ 1,631,722$ 1,619,723$ 1,381,724$ 1,381,725$ 1,381,726$ 1,381,727$ 1,381,728$ 1,729,729$ 20 City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Projected Revenue, Expenditures and Debt 2019 2020 Estimated Estimated Revenues Property taxes (4% increase, annually, beginning in 2021) *110,144$ 116,950$ Special assessments 225,000 225,000 Interest on investments 82,499 80,056 Franchise fees - - Miscellaneous - - Total Revenues 417,643 422,006 Expenditures Capital outlay Public works 892,019 2,061,370 Total Expenditures 892,019 2,061,370 Excess (Deficiency) of Revenues Over (Under) Expenditures (474,376) (1,639,364) Other Financing Sources Transfers in - - Intergovernmental revenue (Municipal State Aid - MSA)230,000 230,000 Bond proceeds - - Sale of Fixed Asset - - Total Other Financing Sources 230,000 230,000 Net Change in Fund Balances (244,376) (1,409,364) Fund Balances, January 1 8,249,930 8,005,554 Fund Balances, December 31 8,005,554$ 6,596,190$ * The Street Maintenance Fund and Street Construction have been combined. The reduction in property taxes reflected in 2019 is a result of reallocating state aid payments. 21 Capital Project Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 121,628$ 126,493$ 131,553$ 136,815$ 142,288$ 147,979$ 153,898$ 160,054$ 166,456$ 173,115$ 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 65,962 53,728 43,871 33,108 52,410 44,339 36,245 28,130 19,994 11,841 - - - - - - - - - - - - - - - - - - - - 337,590 330,222 325,424 319,923 344,697 342,318 340,144 338,184 336,450 334,956 1,790,932 1,546,003 1,631,722 1,619,723 1,381,724 1,381,725 1,381,726 1,381,727 1,381,728 1,729,729 1,790,932 1,546,003 1,631,722 1,619,723 1,381,724 1,381,725 1,381,726 1,381,727 1,381,728 1,729,729 (1,453,342) (1,215,782) (1,306,298) (1,299,800) (1,037,026) (1,039,406) (1,041,582) (1,043,543) (1,045,277) (1,394,773) - - - - - - - - - - 230,000 230,000 230,000 3,230,000 230,000 230,000 230,000 230,000 230,000 230,000 - - - - - - - - - - - - - - - - - - - - 230,000 230,000 230,000 3,230,000 230,000 230,000 230,000 230,000 230,000 230,000 (1,223,342) (985,782) (1,076,298) 1,930,200 (807,026) (809,406) (811,582) (813,543) (815,277) (1,164,773) 6,596,190 5,372,848 4,387,067 3,310,768 5,240,968 4,433,942 3,624,536 2,812,954 1,999,411 1,184,134 5,372,848$ 4,387,067$ 3,310,768$ 5,240,968$ 4,433,942$ 3,624,536$ 2,812,954$ 1,999,411$ 1,184,134$ 19,361$ 22 City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Police 3500.6930 N/A 2018 2018 Ford Interceptor Utility 47,000$ -$ -$ Police 3500.6930 N/A 2018 2018 Ford Interceptor Utility 47,000 - - Police 3500.6930 N/A 2018 2018 Ford Interceptor Utility 47,000 - - Police 3500.6930 N/A 2018 Mobile radios ($5,000 each)17,100 - - Police 3500.6930 N/A 2018 Mobile data tablets ($5,000 each)12,000 - - Police 3500.6930 N/A 2018 Body cameras 25,000 - - Police 3500.6930 N/A 2018 Portable radios ($3,000 each)90,000 - - Police 3500.6930 N/A 2018 Bulletproof vests - mass replacement ($1,000 a piece)2,000 - - Police 3500.6930 N/A 2018 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2019 2015 Ford F150 crew cab 50,000 50,000 - Police 3500.6930 N/A 2019 2020 Ford Interceptor Utility 35,000 35,000 - Police 3500.6930 N/A 2019 2010 Ford Crown Victoria 50,000 50,000 - Police 3500.6930 N/A 2019 2019 Ford Escape 35,000 35,000 - Police 3500.6930 N/A 2019 2013 Ford Interceptor Sedan 5,000 5,000 - Police 3500.6930 N/A 2019 Mobile data tablets ($5,000 each)8,000 8,000 - Police 3500.6930 N/A 2019 Handgun Replacement 45,000 45,000 - Police 3500.6930 N/A 2019 Rifle replacment /Replace Sniper Rifle 7,000 7,000 - Police 3500.6930 N/A 2019 Bulletproof vests - mass replacement ($1,000 a piece)5,000 5,000 - Police 3500.6930 N/A 2019 Tactical vests ($3,600 each)7,200 7,200 - Police 3500.6930 N/A 2020 2016 Ford Interceptor Utility (SUV)50,000 - 50,000 Police 3500.6930 N/A 2020 2016 Ford Interceptor utility 50,000 - 50,000 Police 3500.6930 N/A 2020 2016 Ford Interceptor Utility 50,000 - 50,000 Police 3500.6930 N/A 2020 Mobile data tablets ($5,000 each)15,000 - 15,000 Police 3500.6930 N/A 2020 Rifle replacment /Replace Sniper Rifle 16,500 - 16,500 Police 3500.6930 N/A 2020 Bulletproof vests - mass replacement ($1,000 a piece)15,000 - 15,000 Police 3500.6930 N/A 2020 Tactical vests ($3,600 each)7,200 - 7,200 Police 3500.6931 N/A 2020 Investigator car 40,000 - 40,000 Police 3500.6930 N/A 2021 2017 Ford Interceptor Utility (SUV)60,000 - - Police 3500.6930 N/A 2021 2017 Ford Interceptor Utility 50,000 - - Police 3500.6930 N/A 2021 2017 Ford Interceptor Utility 50,000 - - Police 3500.6930 N/A 2021 2015 Ford Interceptor Utility, silver unmarked 50,000 - - Police 3500.6930 N/A 2009 Chevy Impala 40,000 - - Police 3500.6930 N/A 2021 Mobile data tablets ($5,000 each)20,000 - - Police 3500.6930 N/A 2021 Mobile radar/lidar replacement ($4,000-5,000 each)8,000 - - Police 3500.6930 N/A 2021 In-squad digital video equipment ($6,000 each)24,000 - - Police 3500.6930 N/A 2021 Bulletproof vests - mass replacement ($1,000 a piece)10,000 - - Police 3500.6930 N/A 2021 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2021 SWAT Gas Masks (7) @$1,000 a piece 7,000 - - Police 3500.6930 N/A 2021 SWAT Helmets (7) @$1,000 a piece 7,000 - - Police 3500.6930 N/A 2022 2012 Dodge Journey 40,000 - - Police 3500.6930 N/A 2022 2018 Ford Interceptor Utility 52,000 - - Police 3500.6930 N/A 2022 2018 Ford Interceptor Utility 52,000 - - Police 3500.6930 N/A 2022 2018 Ford Interceptor Utility 52,000 - - Police 3500.6930 N/A 2022 2007 ACT RT-100 speed trailer 5,000 - - Police 3500.6930 N/A 2022 Mobile data tablets ($5,000 each)15,000 - - Police 3500.6930 N/A 2022 Mobile radar/lidar replacement ($4,000-5,000 each)12,000 - - Police 3500.6930 N/A 2022 In-squad digital video equipment ($6,000 each)18,000 - - Police 3500.6930 N/A 2022 Bulletproof vests - mass replacement ($1,000 a piece)6,000 - - Police 3500.6930 N/A 2022 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2022 Upgrade FATS 30,000 - - Police 3500.6930 N/A 2022 Upgrade Cellbrite 15,000 - - Police 3500.6930 N/A 2023 2015 Ford F150 crew cab 52,000 - - Police 3500.6930 N/A 2023 2011 Buick Sedan 40,000 - - Police 3500.6930 N/A 2023 2010 Ford Crown Victoria 52,000 - - Police 3500.6930 N/A 2023 2013 Ford Interceptor Sedan 7,500 - - Police 3500.6930 N/A 2023 Mobile data tablets ($5,000 each)10,000 - - Police 3500.6930 N/A 2023 In-squad digital video equipment ($6,000 each)12,000 - - Police 3500.6930 N/A 2023 Body cameras 30,000 - - Police 3500.6930 N/A 2023 Bulletproof vests - mass replacement ($1,000 a piece)4,000 - - Police 3500.6930 N/A 2023 Tactical vests ($3,600 each)7,200 - - Police 3500.693 N/A 2024 SWAT Robot 15,000 - - Police 3500.6930 N/A 2024 2016 Ford Interceptor Utility (SUV)55,000 - - Police 3500.6930 N/A 2024 2016 Ford Interceptor utility 55,000 - - 23 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 60,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - - - - - - - - - - - 20,000 - - - - - - - - - 8,000 - - - - - - - - - 24,000 - - - - - - - - - 10,000 - - - - - - - - - 7,200 - - - - - - - - - 7,000 - - - - - - - - - 7,000 - - - - - - - - - - 40,000 - - - - - - - - - 52,000 - - - - - - - - - 52,000 - - - - - - - - - 52,000 - - - - - - - - - 5,000 - - - - - - - - - 15,000 - - - - - - - - - 12,000 - - - - - - - - - 18,000 - - - - - - - - - 6,000 - - - - - - - - - 7,200 - - - - - - - - - 30,000 - - - - - - - - - 15,000 - - - - - - - - - - 52,000 - - - - - - - - - 40,000 - - - - - - - - - 52,000 - - - - - - - - - 7,500 - - - - - - - - - 10,000 - - - - - - - - - 12,000 - - - - - - - - - 30,000 - - - - - - - - - 4,000 - - - - - - - - - 7,200 - - - - - - - - - - 15,000 - - - - - - - - - 55,000 - - - - - - - - - 55,000 - - - - - - 24 City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2019 2020 Year to Year to Estimated Estimated Department Replace Subledger Replace Item Cost Amounts Amounts Police 3500.6930 N/A 2024 2016 Ford Interceptor Utility 55,000$ -$ -$ Police 3500.6930 N/A 2024 Mobile data tablets ($5,000 each)15,000 - - Police 3500.6930 N/A 2024 In-squad digital video equipment ($6,000 each)18,000 - - Police 3500.6930 N/A 2024 Body cameras 30,000 - - Police 3500.6930 N/A 2024 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2025 2017 Ford Interceptor Utility (SUV)65,000 - - Police 3500.6930 N/A 2025 2017 Ford Interceptor Utility 55,000 - - Police 3500.6930 N/A 2025 2015 Chevrolet Equinox 40,000 - - Police 3500.6930 N/A 2025 2017 Ford Interceptor Utility 55,000 - - Police 3500.6930 N/A 2025 2015 Ford Interceptor utility, dark blue unmarked 40,000 - - Police 3500.6930 N/A 2025 2010 Ford Crown Victoria 55,000 - - Police 3500.6930 N/A 2025 Mobile data tablets ($5,000 each)20,000 - - Police 3500.6930 N/A 2025 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2026 2018 Ford Interceptor Utility 55,000 - - Police 3500.6930 N/A 2026 2020 Ford Interceptor Utility 40,000 - - Police 3500.6930 N/A 2026 2018 Ford Interceptor Utility 55,000 - - Police 3500.6930 N/A 2026 2018 Ford Interceptor Utility 55,000 - - Police 3500.6930 N/A 2026 1999 Ford ambulance 150,000 - - Police 3500.6930 N/A 2026 Mobile data tablets ($5,000 each)15,000 - - Police 3500.6930 N/A 2026 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2026 SWAT Pole Cam 35,000 - - Police 3500.6930 N/A 2027 2014 Ford Interceptor utility 40,000 - - Police 3500.6930 N/A 2027 2015 Ford F150 crew cab 55,000 - - Police 3500.6930 N/A 2027 2010 Ford Crown Victoria 55,000 - - Police 3500.6930 N/A 2027 2015 Ford Interceptor Utility, silver unmarked 55,000 - - Police 3500.6930 N/A 2027 Mobile data tablets ($5,000 each)5,000 - - Police 3500.6930 N/A 2027 Mobile radar/lidar replacement ($4,000-5,000 each)10,000 - - Police 3500.6930 N/A 2027 In-squad digital video equipment ($6,000 each)6,000 - - Police 3500.6930 N/A 2027 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2027 SWAT Gas Launcher 6,000 - - Police 3500.6930 N/A 2028 2016 Ford Interceptor Utility (SUV)60,000 - - Police 3500.6930 N/A 2028 2016 Ford Interceptor utility 60,000 - - Police 3500.6930 N/A 2028 2016 Ford Interceptor Utility 60,000 - - Police 3500.6930 N/A 2028 Mobile radios ($5,000 each)75,000 - - Police 3500.6930 N/A 2028 Mobile data tablets ($5,000 each)15,000 - - Police 3500.6930 N/A 2028 Mobile radar/lidar replacement ($4,000-5,000 each)15,000 - - Police 3500.6930 N/A 2028 In-squad digital video equipment ($6,000 each)18,000 - - Police 3500.6930 N/A 2028 Portable radios ($3,000 each)150,000 - - Police 3500.6930 N/A 2028 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2029 2017 Ford Interceptor Utility (SUV)70,000 - - Police 3500.6930 N/A 2029 2017 Ford Interceptor Utility 60,000 - - Police 3500.6930 N/A 2029 2017 Ford Interceptor Utility 60,000 - - Police 3500.6930 N/A 2029 2019 Ford Escape 40,000 - - Police 3500.6930 N/A 2029 2010 Ford Crown Victoria 60,000 - - Police 3500.6930 N/A 2029 Mobile data tablets ($5,000 each)20,000 - - Police 3500.6930 N/A 2029 In-squad digital video equipment ($6,000 each)24,000 - - Police 3500.6930 N/A 2029 Handgun Replacement 55,000 - - Police 3500.6930 N/A 2029 Rifle replacment /Replace Sniper Rifle 30,000 - - Police 3500.6930 N/A 2029 Tactical vests ($3,600 each)7,200 - - Police 3500.6930 N/A 2029 Police Bicycles (3)6,000 - - Police 3500.6930 N/A 2030 Estimate based on average 310,708 - - 247,200$ 243,700$ 25 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ 55,000$ -$ -$ -$ -$ -$ -$ - - - 15,000 - - - - - - - - - 18,000 - - - - - - - - - 30,000 - - - - - - - - - 7,200 - - - - - - - - - - 65,000 - - - - - - - - - 55,000 - - - - - - - - - 40,000 - - - - - - - - - 55,000 - - - - - - - - - 40,000 - - - - - - - - - 55,000 - - - - - - - - - 20,000 - - - - - - - - - 7,200 - - - - - - - - - - 55,000 - - - - - - - - - 40,000 - - - - - - - - - 55,000 - - - - - - - - - 55,000 - - - - - - - - - 150,000 - - - - - - - - - 15,000 - - - - - - - - - 7,200 - - - - - - - - - 35,000 - - - - - - - - - - 40,000 - - - - - - - - - 55,000 - - - - - - - - - 55,000 - - - - - - - - - 55,000 - - - - - - - - - 5,000 - - - - - - - - - 10,000 - - - - - - - - - 6,000 - - - - - - - - - 7,200 - - - - - - - - - 6,000 - - - - - - - - - - 60,000 - - - - - - - - - 60,000 - - - - - - - - - 60,000 - - - - - - - - - 75,000 - - - - - - - - - 15,000 - - - - - - - - - 15,000 - - - - - - - - - 18,000 - - - - - - - - - 150,000 - - - - - - - - - 7,200 - - - - - - - - - - 70,000 - - - - - - - - - 60,000 - - - - - - - - - 60,000 - - - - - - - - - 40,000 - - - - - - - - - 60,000 - - - - - - - - - 20,000 - - - - - - - - - 24,000 - - - - - - - - - 55,000 - - - - - - - - - 30,000 - - - - - - - - - 7,200 - - - - - - - - - 6,000 - - - - - - - - - - 310,708 293,200$ 304,200$ 214,700$ 250,200$ 337,200$ 412,200$ 239,200$ 460,200$ 432,200$ 310,708$ 26 City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Projected Revenue, Expenditures and Debt 2019 2020 Estimated Estimated Revenues Property taxes (2% increase, anually, beginning in 2019)154,938$ 158,037$ Additional levy to balance - 50,000 Interest on investments 29,373 28,894 Miscellaneous - - Total Revenues 184,311 236,931 Expenditures Capital outlay Public safety 247,200 243,700 Total Expenditures 247,200 243,700 Excess (Deficiency) of Revenues Over (Under) Expenditures (62,889) (6,769) Other Financing Sources Transfer in - - Bond proceeds - - Sale of Fixed Asset 15,000 15,000 Transfers out - - Total Other Financing Sources 15,000 15,000 Net Change in Fund Balances (47,889) 8,231 Unrestricted Cash Balance - - Assigned Cash Balance 2,838,545 2,841,482 Cash Balance, January 1 2,838,545 2,841,482 Unrestricted Cash Balance - 5,342 Assigned Cash Balance 2,841,482 2,844,372 Fund Balances, December 31 2,841,482$ 2,849,713$ 27 Capital Project Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 161,197$ 164,421$ 167,710$ 171,064$ 174,485$ 177,975$ 181,535$ 185,165$ 188,869$ 192,646$ 70,000 80,000 90,000 90,000 100,000 110,000 120,000 130,000 140,000 150,000 28,557 28,345 28,281 27,879 30,018 32,213 34,465 36,775 39,144 41,575 - - - - - - - - - - 259,754 272,767 285,991 288,943 304,503 320,188 336,000 351,940 368,013 384,220 293,200 304,200 214,700 250,200 337,200 412,200 239,200 460,200 432,200 310,708 293,200 304,200 214,700 250,200 337,200 412,200 239,200 460,200 432,200 310,708 (33,446) (31,433) 71,291 38,743 (32,697) (92,012) 96,800 (108,260) (64,187) 73,512 - - - - - - - - - - - - - - - - - - - - 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 - - - - - - - - - - 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 (18,446) (16,433) 86,291 53,743 (17,697) (77,012) 111,800 (93,260) (49,187) 88,512 5,342 (15,960) (35,228) 48,235 99,189 78,491 (1,742) 106,611 9,674 (43,428) 2,844,372 2,847,227 2,850,062 2,852,890 2,855,678 2,858,680 2,861,901 2,865,347 2,869,025 2,872,939 2,849,713 2,831,267 2,814,834 2,901,125 2,954,867 2,937,171 2,860,159 2,971,958 2,878,699 2,829,512 (15,960) (35,228) 48,235 99,189 78,491 (1,742) 106,611 9,674 (43,428) 40,927 2,847,227 2,850,062 2,852,890 2,855,678 2,858,680 2,861,901 2,865,347 2,869,025 2,872,939 2,877,097 2,831,267$ 2,814,834$ 2,901,125$ 2,954,867$ 2,937,171$ 2,860,159$ 2,971,958$ 2,878,699$ 2,829,512$ 2,918,024$ 28 City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Recreation 0420.6937 0062 2018 New Park Name Signage 10,000$ -$ -$ Recreation 0420.6937 2018 Replace trash receptacle and recycling bins (HRG grant)2,500 - - Recreation 0420.6937 2018 Welcome Park 738,000 - - Recreation 0420.6937 0062 2019 New Park Name Signage 10,000 10,000 - Recreation 0420.6937 0016 2019 ALL Pavement (Parking @ Trails)25,000 25,000 - Recreation 0420.6937 0017 2019 DP Becker 1,200,000 1,200,000 - Recreation 0420.6937 0061 2019 DP Becker 1,800,000 1,800,000 - Recreation 0420.6937 N/A 2019 Lounge Chairs 18,000 18,000 - Recreation 0420.6937 N/A 2019 Chair / Table Replacement 12,000 12,000 - Recreation 0420.6937 N/A 2019 Staging & Risers 10,000 10,000 - Recreation 0420.6937 TBA 2020 New Park Name Signage 10,000 - 10,000 Recreation 0420.6937 TBA 2020 ALL Pavement (Parking @ Trails)25,000 - 25,000 Recreation 0420.6937 TBA 2020 NP Fair Play Area (1999)125,000 - 125,000 Recreation 0420.6937 TBA 2020 Hockey Rink - North Lions 100,000 - 100,000 Recreation 0420.6937 TBA 2021 CP Welcome Play Area (1997)275,000 - - Recreation 0420.6937 TBA 2021 New Park Name Signage 10,000 - - Recreation 0420.6937 TBA ALL Pavement (Parking @ Trails)25,000 - - Recreation 0420.6937 TBA 2021 CP Valley Place PA (2001)275,000 - - Recreation 0420.6937 TBA 2021 NP Yunkers (2001)150,000 - - Recreation 0420.6937 TBA 2021 NP Shelter - Iron Horse 60,000 - - Recreation 0420.6937 TBA 2022 New Park Name Signage 10,000 - - Recreation 0420.6937 TBA 2022 ALL Pavement (Parking @ Trails)25,000 - - Recreation 0420.6937 TBA 2022 CP Dog Park - Bassett Creek 60,000 - - Recreation 0420.6937 TBA 2022 CP Soccer Field - North Lions 530,000 - - Recreation 0420.6937 TBA 2023 New Park Name Signage 10,000 - - Recreation 0420.6937 TBA 2023 ALL Pavement (Parking @ Trails)25,000 - - Recreation 0420.6937 TBA 2023 NP Shelter - Broadway 60,000 - - Recreation 0420.6937 TBA 2023 NP Broadway (1999)160,000 - - Recreation 0420.6937 TBA 2023 Ped Bridge - Bassett Creek 90,000 - - Recreation 0420.6937 TBA 2024 ALL Pavement (Parking @ Trails)25,000 - - Recreation 0420.6937 TBA 2024 New Park Name Signage 10,000 - - Recreation 0420.6937 TBA 2024 CP Park Building - Bassett Creek 1,350,000 - - Recreation 0420.6937 TBA 2024 Re-Surface Courts - North Lions 60,000 - - Recreation 0420.6937 TBA 2025 Play Area - Sunnyview (2000)160,000 - - Recreation 0420.6937 TBA 2025 Sm. Picnic Shelter - Forest 65,000 - - Recreation 0420.6937 TBA 2026 Play Area - Lee (2000)165,000 - - Recreation 0420.6937 TBA 2026 Play Area - Cavanaugh (2001)165,000 - - Recreation 0420.6937 TBA 2026 Play Area - Twin Oak (2003)165,000 - - Recreation 0420.6937 TBA 2026 Med. Shelter - North Lions 115,000 - - Recreation 0420.6937 TBA 2026 Med. Shelter - Valley Place 115,000 - - Recreation 0420.6937 TBA 2026 Sm. Picnic Shelter - Twin Oak 70,000 - - Recreation 0420.6937 TBA 2027 Sm. Shelter - Crystal Highlands 75,000 - - Recreation 0420.6937 TBA 2028 Park Building - Welcome 1,400,000 - - Recreation 0420.6937 TBA 2028 Med. Shelter - Welcome 120,000 - - Recreation 0420.6937 TBA 2028 Play Area - Iron Horse (2004)170,000 - - Recreation 0420.6937 TBA 2029 Soccer Field - Bassett Creek 695,000 - - Recreation 0420.6937 TBA 2029 Med. Shelter - Bassett Creek (lake)125,000 - - Recreation 0420.6937 TBA 2029 Play Area - Bass Lake (2004)175,000 - - Recreation 0420.6937 TBA 2030 Park Building - North Lions 1,450,000 - - 3,075,000$ 260,000$ 29 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 275,000 - - - - - - - - - 10,000 - - - - - - - - - - - - - - - - - - - 275,000 - - - - - - - - - 150,000 - - - - - - - - - 60,000 - - - - - - - - - - 10,000 - - - - - - - - - 25,000 - - - - - - - - - 60,000 - - - - - - - - - 530,000 - - - - - - - - - - 10,000 - - - - - - - - - 25,000 - - - - - - - - - 60,000 - - - - - - - - - 160,000 - - - - - - - - - 90,000 - - - - - - - - - - 25,000 - - - - - - - - - 10,000 - - - - - - - - - 1,350,000 - - - - - - - - - 60,000 - - - - - - - - - - 160,000 - - - - - - - - - 65,000 - - - - - - - - - - 165,000 - - - - - - - - - 165,000 - - - - - - - - - 165,000 - - - - - - - - - 115,000 - - - - - - - - - 115,000 - - - - - - - - - 70,000 - - - - - - - - - - 75,000 - - - - - - - - - - 1,400,000 - - - - - - - - - 120,000 - - - - - - - - - 170,000 - - - - - - - - - - 695,000 - - - - - - - - - 125,000 - - - - - - - - - 175,000 - - - - - - - - - - 1,450,000 770,000$ 625,000$ 345,000$ 1,445,000$ 225,000$ 795,000$ 75,000$ 1,690,000$ 995,000$ 1,450,000$ 30 City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Projected Revenue, Expenditures and Debt 2019 2020 Estimated Estimated Revenues Property taxes (1% overall levy increase, annually, beginning in 2020)248,310$ 358,914$ Interest on investments 19,350 11,847 Intergovernmental revenue (HCYSPG grants)620,000 - Miscellaneous - - Total Revenues 887,660 370,761 Expenditures Capital outlay General government 3,075,000 260,000 Total Expenditures 3,075,000 260,000 Excess (Deficiency) of Revenues Over (Under) Expenditures (2,187,340) 110,761 Other Financing Sources Transfers in EDA 1,200,000 - PIR - - Sale of fixed assets 237,000 24,000 Transfers out - - Total Other Financing Sources 1,437,000 24,000 Net Change in Fund Balances (750,340) 134,761 Fund Balances, January 1 1,935,048 1,184,708 Fund Balances, December 31 1,184,708$ 1,319,470$ 31 Capital Project Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 483,778$ 613,275$ 747,533$ 886,656$ 1,030,752$ 1,179,932$ 1,334,310$ 1,494,004$ 1,659,134$ 1,829,827$ 13,195 10,704 10,934 15,309 10,119 18,517 22,792 35,853 34,491 41,718 - - - - - - - - - - - - - - - - - - - - 496,973 623,980 758,467 901,965 1,040,871 1,198,449 1,357,101 1,529,856 1,693,626 1,871,544 770,000 625,000 345,000 1,445,000 225,000 795,000 75,000 1,690,000 995,000 1,450,000 770,000 625,000 345,000 1,445,000 225,000 795,000 75,000 1,690,000 995,000 1,450,000 (273,027) (1,020) 413,467 (543,035) 815,871 403,449 1,282,101 (160,144) 698,626 421,544 - - - - - - - - - - - - - - - - - - - - 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 - - - - - - - - - - 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 24,000 (249,027) 22,980 437,467 (519,035) 839,871 427,449 1,306,101 (136,144) 722,626 445,544 1,319,470 1,070,442 1,093,422 1,530,889 1,011,854 1,851,725 2,279,174 3,585,275 3,449,131 4,171,757 1,070,442$ 1,093,422$ 1,530,889$ 1,011,854$ 1,851,725$ 2,279,174$ 3,585,275$ 3,449,131$ 4,171,757$ 4,617,301$ 32 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Amounts Amounts City Buildings 0625.6940 TBA 2019 Skylight/leaking roof repair 145,000$ -$ City Buildings 0625.6940 TBA 2019 City Hall - office cubes and desks 100,000 - City Buildings 0625.6940 TBA 2019 Replace garage door obstruction sensors 5,000 - City Buildings 0625.6940 TBA 2019 Replace NO/CO sensors 5,000 - City Buildings 0625.6940 TBA 2020 City Hall - office cubes and desks - - City Buildings 0625.6940 TBA 2020 City Hall fire alarm system upgrade - 9,000 Community Center 0625.6940 TBA 2020 LED Lights - Office/Meeting Rooms - 25,500 Community Center 0625.6940 TBA 2020 CCC Temparature Light Control - 22,000 Community Center 0625.6941 TBA 2020 Audio Upgrade in the Crystal Room - 15,000 Community Center 0625.6942 TBA 2020 Replace basketball hoop safety straps - 10,000 Aquatic Building 0625.6943 TBA 2020 Irrigation in front of building - 15,000 Aquatic Building 0625.6944 TBA 2020 Misc. Electrical Upgrades / LED & Security Lights - 35,000 Pool 0625.6945 TBA 2020 Lifeguard Chairs - 20,000 Bassett Creek Park 0625.6946 TBA 2020 Improve Building Ventillation - 10,000 North Lions Park 0625.6940 TBA 2020 Remove concrete trip edges - 5,000 North Lions Park 0625.6941 TBA 2020 Building Restroom Upgrades - 10,000 North Lions Park 0625.6942 TBA 2020 Building ADA Drinking Fountain Upgrades - 15,000 Bass Lake 0625.6943 TBA 2020 Picnic Shelter - 70,000 Fire Department 0625.6940 TBA 2020 North Fire Station- replace co-ray heaters - 10,000 Fire Department 0625.6940 TBA 2020 North Fire Station- replace NO/CO sensors - 5,000 Police 0625.6940 TBA 2021 Public Safety Facility - - Fire Department 0625.6940 TBA 2021 Replace roof at south fire station - - Community Center 0625.6940 TBA 2021 Parking Lot Improvements - - Aquatic Building 0625.6940 TBA 2021 Install eyewash station - - Community Center 0625.6940 TBA 2021 LED lighting upgrade - - Community Center 0625.6940 TBA 2021 Security camera upgrade - - Community Center 0625.6940 TBA 2021 Replace flooring- Valley room - - North Lions Park 0625.6940 TBA 2021 Replace exterior lighting - - Fire Department 0625.6940 TBA 2021 Irrigate campus (does not work currently) North Fire Station - - Pool 0625.6940 TBA 2021 Umbrella fabric - - Pool 0625.6940 TBA 2021 Replace all tile and caulking in all pools - - Pool 0625.6940 TBA 2021 Fully replace umbrella (2)- - Community Center 0625.6941 TBA 2021 Tuckpointing - - City Buildings 0625.6940 TBA 2021 Fob access all doors - - Fire Department 0625.6940 TBA 2021 Install exterior ladder to roof at South Fire - - Welcome Park 0625.6940 TBA 2021 Replace Furnace and Thermostat - - Valley Place Park 0625.6941 TBA 2021 Replace Fascia - - Valley Place Park 0625.6942 TBA 2021 Replace Interior Lighting - - Valley Place Park 0625.6943 TBA 2021 Replace Exterior Doors - - City Buildings 0625.6940 TBA 2022 Investiagate drainage in boiler room - - City Buildings 0625.6940 TBA 2022 Make cell phone boost system typical install - - City Buildings 0625.6940 TBA 2022 Replace alarms and sensors - - City Buildings 0625.6940 TBA 2022 Replace control panel - - City Buildings 0625.6940 TBA 2022 Upgrade system to code - - Community Center 0625.6940 TBA 2022 Replace dishwasher - - Community Center 0625.6940 TBA 2022 Replace floor scrubber - - Community Center 0625.6940 TBA 2022 Window film- heat reducing forest room/entryways - - Community Center 0625.6940 TBA 2022 Install motion sensors for lighting - - Community Center 0625.6940 TBA 2022 Replace gym and MN Room windows/flashing - - North Lions Park 0625.6940 TBA 2022 Replace furnace/thermostat and chimney - - City Buildings 0625.6940 TBA 2022 Install service door from secure PW operations area - - City Buildings 0625.6940 TBA 2022 Interior touch up paint - - Aquatic building 0625.6940 TBA 2023 Repair Siding and Paint exterior building - - Aquatic building 0625.6940 TBA 2023 Front Desk Security Improvement - - Welcome Park 0625.6941 TBA 2023 Replace Building Fascia - - Welcome Park 0625.6942 TBA 2023 Replace Building Soffits - - Welcome Park 0625.6943 TBA 2023 Replace Building Sidewalk Entry - - City Buildings 0625.6940 TBA 2023 Evaluate city hall system for space heater use - - City Buildings 0625.6940 TBA 2023 Fob access all doors - - City Buildings 0625.6940 TBA 2023 Parking lot lighting upgrade - - City Buildings 0625.6940 TBA 2023 Replace cabinets in copy room - - City Buildings 0625.6940 TBA 2023 Replace cabinets in Council Chambers - - City Buildings 0625.6940 TBA 2023 Replace carpeting - - City Buildings 0625.6940 TBA 2023 Replace ceiling tiles - - City Buildings 0625.6940 TBA 2023 Replace water heater - - City Buildings 0625.6940 TBA 2023 Replace/improve to upstairs IT room - - Community Center 0625.6940 TBA 2023 ADA update Front desk - - Community Center 0625.6940 TBA 2023 HVAC/mechanical updates - - Community Center 0625.6940 TBA 2023 Replace Air Handler - - Community Center 0625.6940 TBA 2023 Replace Exterior Windows - - Community Center 0625.6940 TBA 2023 Tile floor update/repair - - 33 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 16,000,000 - - - - - - - - - 150,000 - - - - - - - - - 140,000 - - - - - - - - - 10,000 - - - - - - - - - 40,000 - - - - - - - - - 40,000 - - - - - - - - - 8,000 - - - - - - - - - 15,000 - - - - - - - - - 25,000 - - - - - - - - - 15,000 - - - - - - - - - 75,000 - - - - - - - - - 30,000 - - - - - - - - - 55,000 - - - - - - - - - 35,000 - - - - - - - - - 20,000 - - - - - - - - - 11,000 - - - - - - - - - 25,000 - - - - - - - - - 15,000 - - - - - - - - - 25,000 - - - - - - - - - - 10,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 18,000 - - - - - - - - - 10,000 - - - - - - - - - 20,000 - - - - - - - - - 15,000 - - - - - - - - - 15,000 - - - - - - - - - 35,000 - - - - - - - - - 125,000 - - - - - - - - - 15,000 - - - - - - - - - 10,000 - - - - - - - - - 20,000 - - - - - - - - - - 35,000 - - - - - - - - - 60,000 - - - - - - - - - 25,000 - - - - - - - - - 20,000 - - - - - - - - - 10,000 - - - - - - - - - 60,000 - - - - - - - - - 25,000 - - - - - - - - - 14,000 - - - - - - - - - 10,000 - - - - - - - - - 15,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 15,000 - - - - - - - - - 40,000 - - - - - - - - - 125,000 - - - - - - - - - 45,000 - - - - - - - - - 40,000 - - - - - - - - - 5,000 - - - - - - - 34 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Amounts Amounts Pool 0625.6940 TBA 2023 New Water Feature -$ -$ Pool 0625.6940 TBA 2023 Replace Sand in filters - - City Buildings 0625.6940 TBA 2023 Install boiler for heater - - Aquatic building 0625.6940 TBA 2024 Install fiberglass doors in chemical areas (3)- - Aquatic building 0625.6940 TBA 2024 Mechanical Ventilation - - City Buildings 0625.6940 TBA 2024 Front counter - - City Buildings 0625.6940 TBA 2024 HVAC cleaning - - City Buildings 0625.6940 TBA 2024 Lighting upgrade to LED - - City Buildings 0625.6940 TBA 2024 Replace can lighting in entire building - - City Buildings 0625.6940 TBA 2024 Replace exterior windows - - City Buildings 0625.6940 TBA 2024 Replace fire gate on customer service window - - City Buildings 0625.6940 TBA 2024 Replace popcorn ceiling in Council Chambers - - City Buildings 0625.6940 TBA 2024 Replace/improve to downstairs IT room (AC unit)- - Community Center 0625.6940 TBA 2024 Replace Refrigerator/refrigerator - - Community Center 0625.6940 TBA 2024 Building Automation updates - - City Buildings 0625.6940 TBA 2024 Replace ceiling fans - - City Buildings 0625.6940 TBA 2024 Replace generator - - City Buildings 0625.6940 TBA 2024 Upgrade emergency/exit lighting - - Pool 0625.6940 TBA 2024 Replace cargo net - - Pool 0625.6940 TBA 2024 Replace chemical feed system - - Pool 0625.6940 TBA 2024 Replace waterwalk pads (5 floats)- - Pool 0625.6940 TBA 2024 Replace smaller pump (main water slide)- - City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors - - City Buildings 0625.6940 TBA 2024 Replace ceiling fans - - City Buildings 0625.6940 TBA 2024 Replace generator - - City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors - - City Buildings 0625.6940 TBA 2024 Replace thermostat - - Welcome Park 0625.6940 TBA 2024 Install bathroom ventillation - - Welcome Park 0625.6941 TBA 2024 Replace Interior Lighting - - Aquatic Building 0625.6940 TBA 2025 Misc electrical upgrades - - Aquatic Building 0625.6940 TBA 2025 Replace bathroom fixtures - - Aquatic Building 0625.6940 TBA 2025 Replace hand dryers - - City Buildings 0625.6940 TBA 2025 Deal with patio outside of lunch room - - City Buildings 0625.6940 TBA 2025 Elevator rehab - - City Buildings 0625.6940 TBA 2025 Replace Air Handler - - City Buildings 0625.6940 TBA 2025 Replace toliets and urinals - - Community Center 0625.6940 TBA 2025 Re-key building - - Old Utilities bldg 0625.6940 TBA 2025 Paint interior - - Old Utilities bldg 0625.6940 TBA 2025 Replace heating system and thermostat - - Pool 0625.6940 TBA 2025 Concrete repairs - - Pool 0625.6941 TBA 2025 Diamond Brite Flooring in Zero Depth Pool - - Fire Department 0625.6941 TBA 2025 Replace exterior doors- south Fire Station - - Valley Place Park 0625.6940 TBA 2025 Paint interior - - Welcome Park 0625.6940 TBA 2025 Replace water heater - - Aquatic building 0625.6940 TBA 2026 Paint interior - - Aquatic building 0625.6940 TBA 2026 Replace heaters- building - - City Buildings 0625.6940 TBA 2026 Paint interior - - City Buildings 0625.6940 TBA 2026 Replace Air Handler - - City Buildings 0625.6940 TBA 2026 Upgrade Generator - - Community Center 0625.6940 TBA 2026 Replace Carpet - - Community Center 0625.6940 TBA 2026 Window film- heat reducing all building - - City Buildings 0625.6940 TBA 2026 Replace restroom fixtures - - City Buildings 0625.6940 TBA 2026 Replacing upstairs ceiling - - Valley Place Park 0625.6940 TBA 2026 Replace furnace / thermostate - - Community Center 0625.6940 TBA 2027 Divider Wall- gyms - - North Lions Park 0625.6941 TBA 2026 Paint building interior - - Community Center 0625.6940 TBA 2027 Install/replace Bball scoreboard - - Community Center 0625.6940 TBA 2027 Replace Volleyball Standards/ref stands - - City Buildings 0625.6940 TBA 2027 Replace interior lighting - - Pool 0625.6940 TBA 2027 Gel coat water slides and drop slide - - Pool 0625.6940 TBA 2027 Replace sun sail shade cover - - Valley Place Park 0625.6940 TBA 2027 ADA drinking fountain upgrades - - Valley Place Park 0625.6940 TBA 2027 ADA park shelter restroom upgrades - - Aquatic building 0625.6940 TBA 2028 Tuck pointing - - City Buildings 0625.6940 TBA 2028 Building wide public address system - - City Buildings 0625.6940 TBA 2028 Replace workout room lighting - - City Buildings 0625.6940 TBA 2028 replace/relocate motion sensors for lights - - City Buildings 0625.6940 TBA 2028 Upgrade life safety systems - - Community Center 0625.6940 TBA 2028 Replace ovens - - Pool 0625.6940 TBA 2028 Paint drop slide and water slide super structure - - Pool 0625.6940 TBA 2028 Replace drain covers - - 35 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ 50,000$ -$ -$ -$ -$ -$ -$ -$ - - 30,000 - - - - - - - - - 35,000 - - - - - - - - - - 25,000 - - - - - - - - - 50,000 - - - - - - - - - 25,000 - - - - - - - - - 35,000 - - - - - - - - - 30,000 - - - - - - - - - 60,000 - - - - - - - - - 450,000 - - - - - - - - - 23,000 - - - - - - - - - 30,000 - - - - - - - - - 15,000 - - - - - - - - - 12,000 - - - - - - - - - 100,000 - - - - - - - - - 15,000 - - - - - - - - - 25,000 - - - - - - - - - 5,000 - - - - - - - - - 8,000 - - - - - - - - - 10,000 - - - - - - - - - 20,000 - - - - - - - - - 40,000 - - - - - - - - - 5,000 - - - - - - - - - 15,000 - - - - - - - - - 15,000 - - - - - - - - - 5,000 - - - - - - - - - 1,000 - - - - - - - - - 10,000 - - - - - - - - - 10,000 - - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 10,000 - - - - - - - - - 25,000 - - - - - - - - - 100,000 - - - - - - - - - 150,000 - - - - - - - - - 25,000 - - - - - - - - - 100,000 - - - - - - - - - 25,000 - - - - - - - - - 51,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 15,000 - - - - - - - - - 5,000 - - - - - - - - - - 19,000 - - - - - - - - - 45,000 - - - - - - - - - 60,000 - - - - - - - - - 150,000 - - - - - - - - - 250,000 - - - - - - - - - 30,000 - - - - - - - - - 30,000 - - - - - - - - - 10,000 - - - - - - - - - 25,000 - - - - - - - - - 11,000 - - - - - - - - - - 40,000 - - - - - - - - 10,000 - - - - - - - - - - 25,000 - - - - - - - - - 15,000 - - - - - - - - - 20,000 - - - - - - - - - 80,000 - - - - - - - - - 19,000 - - - - - - - - - 15,000 - - - - - - - - - 10,000 - - - - - - - - - - 40,000 - - - - - - - - - 75,000 - - - - - - - - - 10,000 - - - - - - - - - 10,000 - - - - - - - - - 100,000 - - - - - - - - - 18,000 - - - - - - - - - 65,000 - - - - - - - - - 25,000 - - 36 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Amounts Amounts City Buildings 0625.6940 TBA 2028 Fob access all doors -$ -$ City Buildings 0625.6940 TBA 2028 Replace exterior windows - - Welcome Park 0625.6940 TBA 2028 ADA restroom upgrades - - Bassett Creek Park 0625.6940 TBA 2029 Fob access all doors - - Bassett Creek Park 0625.6940 TBA 2029 Re-key building - - City Buildings 0625.6940 TBA 2029 Re-key building - - City Buildings 0625.6940 TBA 2029 Replace all window treatments - - Valley Place Park 0625.6940 TBA 2029 Fob access all doors - - North Lions Park 0625.6940 TBA 2029 Paint exterior building - - North Lions Park 0625.6940 TBA 2029 Re-key building - - City Buildings 0625.6940 TBA 2029 Fob access all doors - - City Buildings 0625.6940 TBA 2029 Improve upstairs ventilation - - City Buildings 0625.6940 TBA 2029 Re-key building - - City Buildings 0625.6940 TBA 2029 Replace exterior doors - - City Buildings 0625.6940 TBA 2029 Paint exterior building - - City Buildings 0625.6940 TBA 2029 Replace thermostat - - City Buildings 0625.6940 TBA 2029 Replace thermostat (upstairs)- - City Buildings 0625.6940 TBA 2029 Re-key building - - City Buildings 0625.6940 TBA 2029 Replace skylights - - City Buildings 0625.6940 TBA 2029 Replace asphalt with concrete in bins - - City Buildings 0625.6940 TBA 2029 Re-key building - - City Buildings 0625.6940 TBA 2029 Service door replacement - - City Buildings 0625.6940 TBA 2029 Upgrade emergency/exit lighting - - Valley Place Park 0625.6940 TBA 2029 Fob access all doors - - Valley Place Park 0625.6940 TBA 2029 Misc electrical upgrades - - Valley Place Park 0625.6940 TBA 2029 Re-key building - - Welcome Park Shelter 0625.6940 TBA 2029 Fob access all doors - - Welcome Park Shelter 0625.6940 TBA 2029 Re-key building - - Pool 0625.6941 TBA 2029 Replace Diving Board - - Community Center 0625.6940 TBA 2030 Fob access all doors - - Aquatic Building 0625.6940 TBA 2030 Fob access all doors - - City Buildings 0625.6940 TBA 2030 Improve zoning for HVAC - - City Buildings 0625.6940 TBA 2030 Install building security system - - City Buildings 0625.6940 TBA 2030 Paint exterior building - - City Buildings 0625.6940 TBA 2030 Replace finanace safe with building-integrated safe - - City Buildings 0625.6940 TBA 2030 Re-roof entire building - - Community Center 0625.6940 TBA 2030 Upgrade building safety systems - - Community Center 0625.6940 TBA 2030 Paint interior- meeting rooms - - Community Center 0625.6940 TBA 2030 Replace roof - - Community Center 0625.6940 TBA 2030 Paint exterior building - - City Buildings 0625.6940 TBA 2030 ADA restroom upgrades - - City Buildings 0625.6940 TBA 2030 Paint interior - - City Buildings 0625.6940 TBA 2030 Proper chemical storage - - City Buildings 0625.6940 TBA 2030 Replace bay area lighting - - Pool 0625.6940 TBA 2030 Recplace lounge chairs - - Pool 0625.6940 TBA 2030 Replace water play feature - - Pool 0625.6940 TBA 2030 Replace main pumps (2)- - Pool 0625.6940 TBA 2030 Replace landscaping - - City Buildings 0625.6940 TBA 2030 Exterior touch up paint - - City Buildings 0625.6940 TBA 2030 Exterior touch up paint - - City Buildings 0625.6940 TBA 2030 Do something in downstairs training area - - City Buildings 0625.6940 TBA 2030 Exterior repair - - City Buildings 0625.6940 TBA 2030 Upgrade life safety systems - - 114,038$ 280,540$ 37 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ 25,000$ -$ -$ - - - - - - - 200,000 - - - - - - - - - 10,000 - - - - - - - - - - 25,000 - - - - - - - - - 5,000 - - - - - - - - - 50,000 - - - - - - - - - 100,000 - - - - - - - - - 25,000 - - - - - - - - - 20,000 - - - - - - - - - 5,000 - - - - - - - - - 25,000 - - - - - - - - - 40,000 - - - - - - - - - 25,000 - - - - - - - - - 50,000 - - - - - - - - - 25,000 - - - - - - - - - 1,000 - - - - - - - - - 1,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 5,000 - - - - - - - - - 3,000 - - - - - - - - - 5,000 - - - - - - - - - 25,000 - - - - - - - - - 10,000 - - - - - - - - - 5,000 - - - - - - - - - 25,000 - - - - - - - - - 5,000 - - - - - - - - - 12,000 - - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 40,000 - - - - - - - - - 50,000 - - - - - - - - - 100,000 - - - - - - - - - 10,000 - - - - - - - - - 250,000 - - - - - - - - - 75,000 - - - - - - - - - 30,000 - - - - - - - - - 225,000 - - - - - - - - - 150,000 - - - - - - - - - 25,000 - - - - - - - - - 30,000 - - - - - - - - - 10,000 - - - - - - - - - 25,000 - - - - - - - - - 15,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - 25,000 - - - - - - - - - 35,000 - - - - - - - - - 25,000 - - - - - - - - - 50,000 - - - - - - - - - 125,000 - - - - - - - - - 100,000 16,673,042$ 397,044$ 738,046$ 1,033,048$ 710,050$ 644,052$ 228,054$ 582,056$ 634,058$ 1,549,060$ 38 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 408/625 Schedule of Projected Revenue, Expenditures and Debt 2019 2020 Estimated Estimated Amounts Amounts Revenues Property taxes (2% increase, annually in 2019 - 2024, 0% increase thereafter)585,888$ 4,097,606$ Internal charges (1% increase in 2022 - 2023, 0% increase thereafter)- - Interest on investments 33,393 44,054 Intergovernmental revenue (local government aid, 0% increase projected)556,756 556,756 Miscellaneous - - Total Revenues 1,176,037 4,698,416 Expenditures Capital outlay City Buildings 110,000 9,000 Community Center - 72,500 Aquatic Building - 50,000 Public Safety - - Public Works - - Pool - 20,000 Fire Department - 15,000 Police - - Parks & Recreation - - Bassett Creek Park - 10,000 Lions Park - - Valley Place Park - - Welcome Park - - Total Expenditures 110,000 176,500 Excess (Deficiency) of Revenues Over (Under) Expenditures 1,066,037 4,521,916 Other Financing Sources Bond proceeds - - Transfers in - - Total Other Financing Sources - - Net Change in Fund Balances 1,066,037 4,521,916 Fund Balances, January 1 3,339,340 4,405,377 Fund Balances, December 31 4,405,377$ 8,927,293$ 39 Capital Project Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 4,179,558$ 4,263,149$ 4,348,412$ 4,435,381$ 4,435,381$ 4,435,381$ 4,435,381$ 4,435,381$ 4,435,381$ 4,435,381$ 285,000 287,850 290,729 290,729 290,729 290,729 290,729 290,729 290,729 290,729 89,273 (26,811) 20,218 65,039 108,128 155,738 203,824 256,451 306,064 356,084 556,756 556,756 556,756 556,756 556,756 556,756 556,756 556,756 556,756 556,756 - - - - - - - - - - 5,110,587 5,080,944 5,216,115 5,347,905 5,390,994 5,438,604 5,486,690 5,539,317 5,588,930 5,638,949 35,000 168,000 249,000 754,000 300,000 495,000 20,000 420,000 480,000 875,000 283,000 210,000 255,000 112,000 100,000 60,000 80,000 18,000 - 505,000 10,000 - 95,000 75,000 60,000 64,000 - 40,000 - 25,000 - - - - - - - - - - - - - - - - - - - - 120,000 - 80,000 78,000 100,000 - 99,000 90,000 12,000 140,000 195,000 - - - 50,000 - - - - - 16,000,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - 30,000 - - - - - - - - - - - 65,000 - - - 15,000 11,000 25,000 - 65,000 - 11,000 - 55,000 20,000 5,000 - - 10,000 - - 16,719,000 378,000 734,000 1,039,000 630,000 630,000 224,000 578,000 587,000 1,545,000 (11,608,413) 4,702,944 4,482,115 4,308,905 4,760,994 4,808,604 5,262,690 4,961,317 5,001,930 4,093,949 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - (11,608,413) 4,702,944 4,482,115 4,308,905 4,760,994 4,808,604 5,262,690 4,961,317 5,001,930 4,093,949 8,927,293 (2,681,120) 2,021,824 6,503,939 10,812,844 15,573,838 20,382,442 25,645,132 30,606,449 35,608,379 (2,681,120)$ 2,021,824$ 6,503,939$ 10,812,844$ 15,573,838$ 20,382,442$ 25,645,132$ 30,606,449$ 35,608,379$ 39,702,328$ 40 2019 Business Unit Year to Estimated Object Code Subledger Replace Item Cost Amounts Public Works 2018 Replace #329 - 2004 John Deere front end loader 220,000$ -$ Public Works 2018 Replace #302B - broom for 2006 MT5T trackless plow 8,000 - Public Works 2018 Replace #121 - 1988 John Deere tractor 85,000 - Public Works 2018 Replace #124 - 2007 Toro GM4000-D mower 63,000 - Public Works 0615.6930 0031 2019 Replace #315 - 2006 Freightliner SA with TA hook 265,000 265,000 Public Works 0615.6930 0032 2019 Replace #325 - 2000 Ingersoll Rand 1 ton roller 50,000 50,000 Public Works 0615.6930 0033 2019 Replace #308 - 2002 Chevy sign/fleet truck 90,000 90,000 Public Works 0615.6930 0035 2019 Tanker Truck (replacement)175,000 175,000 Public Works 0615.6930 0036 2019 Tommy Gate for truck # 106 5,000 5,000 Public Works 0615.6930 0037 2019 6205 - Water Utility Replace #432 - 2008 Ford F150 50,000 50,000 Public Works 0615.6930 TBA 2019 Pick-up Truck (Replace Truck # 40)28,000 28,000 Public Works 0615.6930 TBA 2019 Pick up truck ( Replace truck # 44)28,000 28,000 Public Works 0615.6930 TBA 2020 Replace #341 - 2005 CAT 3 ton roller 60,000 - Public Works 0615.6930 TBA 2020 Replace #302 - 2006 MT5T Trackless 149,732 - Public Works 0615.6930 TBA 2020 Replace #123 - 11' Large Area Mower (replacement)68,000 - Public Works 0615.6930 TBA 2020 Replace #339 Tack trailer 90,000 - Public Works 0615.6930 TBA 2020 Replace #327 - 2008 message board 25,000 - Public Works 0615.6930 TBA 2020 One ton dump (Replace truck # 125)75,000 - Public Works 0615.6930 TBA 2021 Replace #311 - 2007 Freightliner SA 260,000 - Comm Dev 0615.6930 TBA 2021 Replace car #27 - 2007 Chevy Malibu 20,000 - Comm Dev 0615.6930 TBA 2021 Replace car #57 - 2006 Chevy Malibu 20,000 - Public Works 0615.6930 TBA 2021 Replace #301 - 2011 Dodge Ram 75,000 - Public Works 0615.6930 TBA 2021 Replace #303-1 - MTV Trackless MT-6 181,732 - Public Works 0615.6930 0034 2022 Z Turn Mower (replacement)15,000 - Public Works 0615.6930 TBA 2022 Replace #309 - 2010 Freightliner TA 270,000 - Public Works 0615.6930 TBA 2022 Replace #307 - 2012 Ram 2500 (new is swap loader)75,000 - Public Works 0615.6930 TBA 2022 utility trailer (replace Z turn trailer)8,000 - Public Works 0615.6930 TBA 2022 20 Kw portable generator with light tower (replace existing 37kW)20,000 - Public Works 0615.6930 TBA 2023 Replace #337 - 2013 Mauldin asphalt paver 195,000 - Public Works 0615.6930 TBA 2023 Replace #364 - 1998 trailer hot box/patching 45,000 - Public Works 0615.6930 TBA 2023 Replace #310 - 2010 Chevy 3500 75,000 - Public Works 0615.6930 TBA 2023 Replace #314 - 2012 International SA 265,000 - Public Works 0615.6930 TBA 2023 6237- water utility Replace #434 - 1996 Air Compressor 30,000 - Public Works 0615.6930 TBA 2024 Replace #56 - 2014 Ford Focus 21,587 - Public Works 0615.6930 TBA 2024 Replace #351 - Rayco brush chipper 52,804 - Public Works 0615.6930 TBA 2024 Replace #428 - GMC Sierra 3500HD 1 ton dump truck 63,364 - Public Works 0615.6930 TBA 2024 Replace #451 - SRECO easement machine (no title)44,590 - Public Works 0615.6930 TBA 2025 Aerator 35,000 - Public Works 0615.6930 TBA 2025 Replace Engineering #42 35,000 - Public Works 0615.6930 TBA 2025 Replace #110 - Chevy K3500 Silverado and 9' plow w/Tommy gate 54,520 - Public Works 0615.6930 TBA 2025 Replace #303-2 - Sno-Quip 51" ribbon PTO blower for #303 19,385 - Public Works 0615.6930 TBA 2025 Replace #303-4 - Sidewalk MT Trackless 51" Vee plow for #303 9,692 - Public Works 0615.6930 TBA 2025 Replace #340 - Tenco TCS-172A-LMM Snow Blower 181,732 - Public Works 0615.6930 TBA 2025 Replace #390 - Veritec salt brine system/generator 96,924 - Public Works 0615.6930 TBA 2025 Replace #431 - Sterling Acterra w/jetter 284,714 - Public Works 0615.6930 TBA 2025 Replace #456 - Target Pro 65-lll concrete saw 53,308 - Public Works 0615.6930 TBA 2025 Replace 3-yd grapple bucket for use w/front end loaders 30,289 - Public Works 0615.6930 TBA 2026 Replace #106 - Ford F350 Pickup w/Henderson Dump body 112,583 - Public Works 0615.6930 TBA 2026 Replace #115 - GMC 1 ton; Sierra 3500 (gray)50,037 - Public Works 0615.6930 TBA 2026 Replace #433-1 - John Deere 190D excavator 306,476 - Public Works 0615.6930 TBA 2026 Replace #433-2 - 30" V-bottom frost bucket (for #433)6,255 - Public Works 0615.6930 TBA 2026 Replace #433-3 - Empire excavator grapple (for #433)10,007 - Public Works 0615.6930 TBA 2026 Replace #433-4 - Allied hydraulic hammer (for #433)50,037 - Public Works 0615.6930 TBA 2027 Replace #111 - Chevy Silverado K2500 Pickup (blue)Utility box 77,495 - Public Works 0615.6930 TBA 2027 Replace #316 - Chevrolet 1 ton Silverado 3500 4X4 (white)41,330 - Public Works 0615.6930 TBA 2027 Replace #342 - TowMaster T-10DT Trailer 9,041 - Public Works 0615.6930 TBA 2027 Replace #450-1 - Caterpillar 930K wheel loader (no title)245,400 - Public Works 0615.6930 TBA 2027 Replace #462 - Elgin Pelican NP Sweeper 290,605 - Public Works 0615.6930 TBA 2028 Replace #306 - GMC Sierra 1500 Ext Cab 1/2 Ton (blue)42,674 - Public Works 0615.6930 TBA 2028 Replace #332 - Wacker WP1550AW plate tamper 6,668 - Public Works 0615.6930 TBA 2028 Replace #334 - Bobcat Skid loader Model A770 IT4 126,688 - Public Works 0615.6930 TBA 2028 Replace #401 - Chevy Silverado 2500 (white)46,674 - Public Works 0615.6930 TBA 2028 Replace #430 - Sreco sewer rodder 93,349 - Public Works 0615.6930 TBA 2028 Replace #450-2 - 12 ft Plow & ACS Adapter (for #450)16,003 - Department City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Schedule of Planned Capital Outlay 2018 to 2030 41 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 60,000 - - - - - - - - - - 149,732 - - - - - - - - - - 68,000 - - - - - - - - - - 90,000 - - - - - - - - - - 25,000 - - - - - - - - - - 75,000 - - - - - - - - - - - 260,000 - - - - - - - - - - 20,000 - - - - - - - - - - 20,000 - - - - - - - - - - 75,000 - - - - - - - - - - 181,732 - - - - - - - - - - - 15,000 - - - - - - - - - - 270,000 - - - - - - - - - - 75,000 - - - - - - - - - - 8,000 - - - - - - - - - - 20,000 - - - - - - - - - - - 195,000 - - - - - - - - - - 45,000 - - - - - - - - - - 75,000 - - - - - - - - - - 265,000 - - - - - - - - - - 30,000 - - - - - - - - - - - 21,587 - - - - - - - - - - 52,804 - - - - - - - - - - 63,364 - - - - - - - - - - 44,590 - - - - - - - - - - - 35,000 - - - - - - - - - - 35,000 - - - - - - - - - - 54,520 - - - - - - - - - - 19,385 - - - - - - - - - - 9,692 - - - - - - - - - - 181,732 - - - - - - - - - - 96,924 - - - - - - - - - - 284,714 - - - - - - - - - - 53,308 - - - - - - - - - - 30,289 - - - - - - - - - - - 112,583 - - - - - - - - - - 50,037 - - - - - - - - - - 306,476 - - - - - - - - - - 6,255 - - - - - - - - - - 10,007 - - - - - - - - - - 50,037 - - - - - - - - - - - 77,495 - - - - - - - - - - 41,330 - - - - - - - - - - 9,041 - - - - - - - - - - 245,400 - - - - - - - - - - 290,605 - - - - - - - - - - - 42,674 - - - - - - - - - - 6,668 - - - - - - - - - - 126,688 - - - - - - - - - - 46,674 - - - - - - - - - - 93,349 - - - - - - - - - - 16,003 - - 42 2019 Business Unit Year to Estimated Object Code Subledger Replace Item Cost Amounts Public Works 0615.6930 TBA 2028 Replace #455 - MacLander trailer 6,668$ -$ Public Works 0615.6930 TBA 2028 Replace #457 - Broot utility trailer 5,334 - Public Works 0615.6930 TBA 2029 Replace #118 - Bear Cat truckloader leaf blower & vacuum w/trailer 34,422 - Public Works 0615.6930 TBA 2029 Replace #312 - Int'l 7400 4x2 truck w/dump box, plow & sander 385,530 - Public Works 0615.6930 TBA 2030 Replace #101 - GMC Sierra 3500 4wd (white) w/V-Plow 54,022 - Public Works 0615.6930 TBA 2030 Replace #113 - Chevy Silverado 3500 4X4 w/Crysteel dump body & hoist 65,396 - Public Works 0615.6930 TBA 2030 Replace #145 - Toro Workman MDX w/ballfield groomer 25,590 - Public Works 0615.6930 TBA 2030 Replace #305 - Dodge Ram 5500 4X4 Bucket Truck w/Dura-Lift (white)284,329 - Public Works 0615.6930 TBA 2030 Replace #347 - TowMaster 10,000 LB trailer (Skidsteer, 3 TN Roller)14,216 - Public Works 0615.6930 TBA 2030 Replace #350 - Tennant MS20GLP Floor Sweeper 78,190 - Public Works 0615.6930 TBA 2030 Replace #352 - Coats Wheel Balancer 14,216 - Public Works 0615.6930 TBA 2030 Replace #353 - Coats Tire Changer 21,325 - Public Works 0615.6930 TBA 2030 Replace #363 - Toyota 5000-lb forklift w/sideshifting positioner 71,082 - Public Works 0615.6930 TBA 2030 Replace #445 - Honda WT30XK3A 3" trash pump 2,132 - Public Works 0615.6930 TBA 2030 Replace #449 - Chevy Silverado K2500 (white)49,758 - Public Works 0615.6930 TBA 2030 Replace #459-1 - Bravo covered trailer (for use w/449 pickup)5,687 - Public Works 0615.6930 TBA 2030 Replace #459-2 - Aries CCTV Pathfinder Command Ctr (no title)191,922 - 693,019$ Department Schedule of Planned Capital Outlay 2018 to 2030 (Continued) City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 43 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ 6,668$ -$ -$ - - - - - - - - 5,334 - - - - - - - - - - - 34,422 - - - - - - - - - - 385,530 - - - - - - - - - - - 54,022 - - - - - - - - - - 65,396 - - - - - - - - - - 25,590 - - - - - - - - - - 284,329 - - - - - - - - - - 14,216 - - - - - - - - - - 78,190 - - - - - - - - - - 14,216 - - - - - - - - - - 21,325 - - - - - - - - - - 71,082 - - - - - - - - - - 2,132 - - - - - - - - - - 49,758 - - - - - - - - - - 5,687 - - - - - - - - - - 191,922 469,752$ 558,753$ 390,022$ 612,023$ 184,369$ 802,588$ 537,421$ 665,898$ 346,085$ 421,982$ 879,895$ 44 City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Statement of Cash Flows 2019 Estimated Cash Flows from Operating Activities Receipts from interfund services provided -$ Receipts from property taxes (1% increase, annually, beginning in 2020)85,680 Payments to suppliers and employees (2.5% growth annually)3,578 Net Cash Provided (Used) by Operating Activities 89,258 Cash Flows from Noncapital Financing Activities Transfers in/(out)- Net Cash Provided (Used) by Noncapital Financing Activities - Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (693,019) Proceeds from sale of assets 46,640 Proceeds from bonds and notes issued - Net Cash Used by Capital and Related Financing Activities (646,379) Cash Flows from Investing Activities Investment earnings 27,903 Net Increase (Decrease) in Cash and Cash Equivalents (529,218) Cash and Cash Equivalents, January 1 2,790,279 Cash and Cash Equivalents, December 31 2,261,061$ 45 Enterprise Fund Projected Activity 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated -$ 200,000$ 214,000$ 228,980$ 245,009$ 262,159$ 280,510$ 300,146$ 321,156$ 343,637$ 367,692$ 86,537 87,402 88,276 89,159 90,051 90,951 91,861 92,779 93,707 94,644 95,590 3,578 3,667 3,777 3,891 4,008 4,128 4,252 4,379 4,511 4,646 4,785 90,115 291,070 306,054 322,030 339,067 357,238 376,622 397,304 419,374 442,927 468,067 (300,000) - - - - - - - - - - (300,000) - - - - - - - - - - (469,752) (558,753) (390,022) (612,023) (184,369) (802,588) (537,421) (665,898) (346,085) (421,982) (879,895) 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 - - - - - - - - - - - (423,112) (512,113) (343,382) (565,383) (137,729) (755,948) (490,781) (619,258) (299,445) (375,342) (833,255) 22,611 16,507 14,461 14,233 11,941 14,074 10,228 9,189 7,061 8,331 9,090 (610,387) (204,537) (22,867) (229,121) 213,280 (384,636) (103,930) (212,765) 126,990 75,916 (356,097) 2,261,061 1,650,674 1,446,137 1,423,271 1,194,150 1,407,430 1,022,794 918,863 706,099 833,088 909,005 1,650,674$ 1,446,137$ 1,423,271$ 1,194,150$ 1,407,430$ 1,022,794$ 918,863$ 706,099$ 833,088$ 909,005$ 552,907$ 46 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Information Technology 2018 Security access control system 24,000$ -$ -$ Information Technology 2018 Computer hardware and software 55,000 - - Information Technology 2018 Laserfiche/Docusphere records management 12,000 - - Information Technology 2018 800 MGHZ for Public Works 55,000 - - Information Technology 0620.6940 0038 2019 Robbinsdale SD - Potential Replacement 18,833 18,833 - Information Technology 0620.6940 0039 2019 System Log Server 3,500 3,500 - Information Technology 0620.6940 0040 2019 Computer Hardware & Software 55,000 55,000 - Information Technology 0620.6940 0041 2019 City Hall Switch 1 - 48 Port POE 9,605 9,605 - Information Technology 0620.6940 0042 2019 City Hall Switch 5 - 48 Port POE 11,128 11,128 - Information Technology 0620.6940 0043 2019 Wireless Controller - 25 AP License 5,459 5,459 - Information Technology 0620.6940 0044 2019 Large Format Scanner 7,300 7,300 - Information Technology 0620.6940 0045 2019 Networked Department Printers 800 800 - Information Technology 0620.6940 0046 2019 Communication Room Wiring Upgrade 4,500 4,500 - Information Technology 0620.6940 0047 2019 Redundant Connectivity | PW -> CH 676 676 - Information Technology 0620.6940 0048 2019 Pool Switch - 24 Port POE 3,141 3,141 - Information Technology 0620.6940 0049 2019 WiFi AP - CCC Office 902 902 - Information Technology 0620.6940 0050 2019 Redundant Connectivity | CCC -> PW 3,176 3,176 - Information Technology 0620.6940 0051 2019 CH & PD DVR Server 10,000 10,000 - Information Technology 0620.6940 0052 2019 Access Control Server 3,000 3,000 - Information Technology 0620.6940 0053 2019 Access Control Maintenance & Updates 3,000 3,000 - Information Technology 0620.6940 0054 2019 IP Camera Maintenance & Updates 8,000 8,000 - Information Technology 0620.6940 TBA 2020 Robbinsdale SD - Potential Replacement 18,833 - 18,833 Information Technology 0620.6940 TBA 2020 Computer Hardware & Software 57,500 - 57,500 0620.6940 TBA 2020 Catalyst 3650 Fiber Switch 3,782 - 3,782 Information Technology 0620.6940 TBA 2020 City Hall Switch 2 - 48 Port POE 9,133 - 9,133 Information Technology 0620.6940 TBA 2020 City Hall Swtich 3 - 48 port POE 9,133 - 9,133 Information Technology 0620.6940 TBA 2020 City Hall Switch 4 - 48 Port POE 8,081 - 8,081 Information Technology 0620.6940 TBA 2020 WiFi AP - PD Investigations 845 - 845 Information Technology 0620.6940 TBA 2020 Multi-Function Printer - Copy Room 9,000 - 9,000 Information Technology 0620.6940 TBA 2020 Multi-Function Printer - Finance 7,500 - 7,500 Information Technology 0620.6940 TBA Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2020 Public Works Switch - 48 Port POE 9,133 - 9,133 Information Technology 0620.6940 TBA 2020 PW Switch - 24 Port POE (Pumphouse)3,682 - 3,682 Information Technology 0620.6940 TBA 2020 WiFi AP - PW Office 845 - 845 Information Technology 0620.6940 TBA 2020 WiFi AP - PW Garage East 845 - 845 Information Technology 0620.6940 TBA 2020 WiFi AP - PW Garage West 845 - 845 Information Technology 0620.6940 TBA 2020 Networked Department Printers 800 - 800 Information Technology 0620.6940 TBA 2020 Networked Department Printers 800 - 800 Information Technology 0620.6940 TBA 2020 Door Readers - Public Works (7)10,000 - 10,000 Information Technology 0620.6940 TBA 2020 Access Control Maintenance & Updates 6,000 - 6,000 Information Technology 0620.6940 TBA 2020 Council Chamber Door Security 6,500 - 6,500 Information Technology 0620.6940 TBA 2020 Audio Update - A/B Room 15,000 - 15,000 Information Technology 0620.6940 TBA 2021 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2021 Computer Hardware & Software 60,000 - - Information Technology 0620.6940 TBA 2021 WiFi AP - Emergency Ops Center 732 - - Information Technology 0620.6940 TBA 2021 Network Firewall ASA 5,365 - - Information Technology 0620.6940 TBA 2021 WiFi AP - Conference A 732 - - Information Technology 0620.6940 TBA 2021 WiFi AP - Cable Room 732 - - Information Technology 0620.6940 TBA 2021 WiFi AP - Server Room 732 - - Information Technology 0620.6940 TBA 2021 Multi-Function Printer - Police 12,000 - - Information Technology 0620.6940 TBA 2021 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2021 CCC Switch - 48 Port POE 6,937 - - Information Technology 0620.6940 TBA 2021 WiFi AP - CCC AB Room 732 - - Information Technology 0620.6940 TBA 2021 WiFi AP - CCC Activity Room 732 - - Information Technology 0620.6940 TBA 2021 Multi-Function Printer - CCC 15,000 - - Information Technology 0620.6940 TBA 2021 PW DVR Server 7,500 - - Information Technology 0620.6940 TBA 2021 Security Camera Upgrades (Public Works)16,000 - - Information Technology 0620.6940 TBA 2021 Security Camera Upgrades (Soft Interview)4,000 - - 47 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 18,833 - - - - - - - - - 60,000 - - - - - - - - - 732 - - - - - - - - - 5,365 - - - - - - - - - 732 - - - - - - - - - 732 - - - - - - - - - 732 - - - - - - - - - 12,000 - - - - - - - - - 800 - - - - - - - - - 6,937 - - - - - - - - - 732 - - - - - - - - - 732 - - - - - - - - - 15,000 - - - - - - - - - 7,500 - - - - - - - - - 16,000 - - - - - - - - - 4,000 - - - - - - - - - 48 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2019 2020 Year to Estimated Estimated Department Replace Item Cost Amounts Amounts Information Technology 0620.6940 TBA 2022 Networked Department Printers 800$ -$ -$ Information Technology 0620.6940 TBA 2022 Multi-Function Printer - Public Works 7,500 - - Information Technology 0620.6940 TBA 2022 Large Format Plotter/Scanner 10,000 - - Information Technology 0620.6940 TBA 2022 Access Control Maintenance & Updates 6,000 - - Information Technology 0620.6940 TBA 2022 IP Camera Maintenance & Updates 10,000 - - Information Technology 0620.6940 TBA 2022 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2022 Computer Hardware & Software 62,500 - - Information Technology 0620.6940 TBA 2022 City Hall Switch - 24 Port | LOGIS 4,703 - - Information Technology 0620.6940 TBA 2022 WiFi AP's - Crystal Cove (New)6,000 - - Information Technology 0620.6940 TBA 2022 WiFi AP - PD External 3,693 - - Information Technology 0620.6940 TBA 2023 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2023 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2023 Computer Hardware & Software 65,000 - - Information Technology 0620.6940 TBA 2023 Multi-Function Printer - ComDev 7,500 - - Information Technology 0620.6940 TBA 2023 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2023 Network Firewall ASA 5,252 - - Information Technology 0620.6940 TBA 2023 Public Works Switch - 24 Port | LOGIS 4,703 - - Information Technology 0620.6940 TBA 2023 Access Control Maintenance & Updates 6,000 - - Information Technology 0620.6940 TBA 2023 Police Cellebrite Hardware 3,000 - - Information Technology 0620.6940 TBA 2023 IP Camera Maintenance & Updates 10,000 - - Information Technology 0620.6940 TBA 2024 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2024 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2024 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2024 Computer Hardware & Software 55,000 - - Information Technology 0620.6940 TBA 2024 City Hall Switch 1 - 48 Port POE 9,605 - - Information Technology 0620.6940 TBA 2024 City Hall Switch 5 - 48 Port POE 11,128 - - Information Technology 0620.6940 TBA 2024 Wireless Controller - 25 AP License 5,459 - - Information Technology 0620.6940 TBA 2024 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2024 Pool Switch - 24 Port POE 3,141 - - Information Technology 0620.6940 TBA 2024 WiFi AP - CCC Office 902 - - Information Technology 0620.6940 TBA 2024 CH & PD DVR Server 10,000 - - Information Technology 0620.6940 TBA 2024 Access Control Server 3,000 - - Information Technology 0620.6940 TBA 2024 Access Control Maintenance & Updates 3,000 - - Information Technology 0620.6940 TBA 2024 IP Camera Maintenance & Updates 8,000 - - Information Technology 0620.6940 TBA 2025 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2025 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2025 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2025 VOIP & VM Server Replacement 100,000 - - Information Technology 0620.6940 TBA 2025 Computer Hardware & Software 57,500 - - Information Technology 0620.6940 TBA 2025 City Hall Switch 2 - 48 Port POE 8,021 - - Information Technology 0620.6940 TBA 2025 City Hall Swtich 3 - 48 port POE 8,757 - - Information Technology 0620.6940 TBA 2025 City Hall Switch 4 - 48 Port POE 7,345 - - Information Technology 0620.6940 TBA 2025 WiFi AP - PD Investigations 845 - - Information Technology 0620.6940 TBA 2025 Multi-Function Printer - FINANCE 9,000 - - Information Technology 0620.6940 TBA 2025 Multi-Function Printer - CCC 7,500 - - Information Technology 0620.6940 TBA 2025 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2025 Public Works Switch - 48 Port POE 6,937 - - Information Technology 0620.6940 TBA 2025 PW Switch - 24 Port POE (Pumphouse)4,250 - - Information Technology 0620.6940 TBA 2025 WiFi AP - PW Office 845 - - Information Technology 0620.6940 TBA 2025 WiFi AP - PW Garage East 845 - - Information Technology 0620.6940 TBA 2025 WiFi AP - PW Garage West 845 - - Information Technology 0620.6940 TBA 2025 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2025 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2025 CCTV System Adds & Improvements 10,000 - - Information Technology 0620.6940 TBA 2025 Access Control Maintenance & Updates 12,000 - - Information Technology 0620.6940 TBA 2026 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2026 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2026 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2026 VOIP Phone Hardware 40,000 - - Information Technology 0620.6940 TBA 2026 Computer Hardware & Software 60,000 - - Information Technology 0620.6940 TBA 2026 WiFi AP - Emergency Ops Center 732 - - Information Technology 0620.6940 TBA 2026 Network Firewall ASA 5,365 - - Information Technology 0620.6940 TBA 2026 WiFi AP - Conference A 732 - - Information Technology 0620.6940 TBA 2026 WiFi AP - Cable Room 732 - - Information Technology 0620.6940 TBA 2026 WiFi AP - Server Room 732 - - Information Technology 0620.6940 TBA 2026 Multi-Function Printer - Police 12,000 - - Information Technology 0620.6940 TBA 2026 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2026 CCC Switch - 48 Port POE 6,937 - - 49 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ 800$ -$ -$ -$ -$ -$ -$ -$ -$ - 7,500 - - - - - - - - - 10,000 - - - - - - - - - 6,000 - - - - - - - - - 10,000 - - - - - - - - - 18,833 - - - - - - - - - 62,500 - - - - - - - - - 4,703 - - - - - - - - - 6,000 - - - - - - - - - 3,693 - - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 65,000 - - - - - - - - - 7,500 - - - - - - - - - 800 - - - - - - - - - 5,252 - - - - - - - - - 4,703 - - - - - - - - - 6,000 - - - - - - - - - 3,000 - - - - - - - - - 10,000 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 55,000 - - - - - - - - - 9,605 - - - - - - - - - 11,128 - - - - - - - - - 5,459 - - - - - - - - - 800 - - - - - - - - - 3,141 - - - - - - - - - 902 - - - - - - - - - 10,000 - - - - - - - - - 3,000 - - - - - - - - - 3,000 - - - - - - - - - 8,000 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 100,000 - - - - - - - - - 57,500 - - - - - - - - - 8,021 - - - - - - - - - 8,757 - - - - - - - - - 7,345 - - - - - - - - - 845 - - - - - - - - - 9,000 - - - - - - - - - 7,500 - - - - - - - - - 800 - - - - - - - - - 6,937 - - - - - - - - - 4,250 - - - - - - - - - 845 - - - - - - - - - 845 - - - - - - - - - 845 - - - - - - - - - 800 - - - - - - - - - 800 - - - - - - - - - 10,000 - - - - - - - - - 12,000 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 40,000 - - - - - - - - - 60,000 - - - - - - - - - 732 - - - - - - - - - 5,365 - - - - - - - - - 732 - - - - - - - - - 732 - - - - - - - - - 732 - - - - - - - - - 12,000 - - - - - - - - - 800 - - - - - - - - - 6,937 - - - - 50 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2018 to 2030 (Continued) 2019 2020 Year to Estimated Estimated Department Replace Item Cost Amounts Amounts Information Technology 0620.6940 TBA 2026 WiFi AP - CCC AB Room 732$ -$ -$ Information Technology 0620.6940 TBA 2026 WiFi AP - CCC Activity Room 732 - - Information Technology 0620.6940 TBA 2026 Multi-Function Printer - City Hall 15,000 - - Information Technology 0620.6940 TBA 2026 PW DVR Server 7,500 - - Information Technology 0620.6940 TBA 2026 CCTV System Adds & Improvements 10,000 - - Information Technology 0620.6940 TBA 2026 Access Control Maintenance & Updates 12,000 - - Information Technology 0620.6940 TBA 2027 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2027 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2027 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2027 Multi-Function Printer - Public Works 7,500 - - Information Technology 0620.6940 TBA 2027 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2027 Large Format Plotter/Scanner 10,000 - - Information Technology 0620.6940 TBA 2027 Access Control Maintenance & Updates 6,000 - - Information Technology 0620.6940 TBA 2027 IP Camera Maintenance & Updates 10,000 - - Information Technology 0620.6940 TBA 2027 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2027 Computer Hardware & Software 62,500 - - Information Technology 0620.6940 TBA 2027 City Hall Switch - 24 Port | LOGIS 4,703 - - Information Technology 0620.6940 TBA 2027 WiFi AP's - Crystal Cove (New)6,000 - - Information Technology 0620.6940 TBA 2027 WiFi AP - PD External 3,693 - - Information Technology 0620.6940 TBA 2028 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2028 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2028 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2028 Computer Hardware & Software 65,000 - - Information Technology 0620.6940 TBA 2028 Multi-Function Printer - ComDev 7,500 - - Information Technology 0620.6940 TBA 2028 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2028 Network Firewall ASA 5,252 - - Information Technology 0620.6940 TBA 2028 Public Works Switch - 24 Port | LOGIS 4,703 - - Information Technology 0620.6940 TBA 2028 Access Control Maintenance & Updates 6,000 - - Information Technology 0620.6940 TBA 2028 Police Cellebrite Hardware 3,000 - - Information Technology 0620.6940 TBA 2028 IP Camera Maintenance & Updates 10,000 - - Information Technology 0620.6940 TBA 2029 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2029 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2029 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2029 Computer Hardware & Software 55,000 - - Information Technology 0620.6940 TBA 2029 City Hall Switch 1 - 48 Port POE 9,605 - - Information Technology 0620.6940 TBA 2029 City Hall Switch 5 - 48 Port POE 11,128 - - Information Technology 0620.6940 TBA 2029 Wireless Controller - 25 AP License 5,459 - - Information Technology 0620.6940 TBA 2029 Large Format Scanner 7,300 - - Information Technology 0620.6940 TBA 2029 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2029 Pool Switch - 24 Port POE 3,141 - - Information Technology 0620.6940 TBA 2029 WiFi AP - CCC Office 902 - - Information Technology 0620.6940 TBA 2029 CH & PD DVR Server 10,000 - - Information Technology 0620.6940 TBA 2029 Access Control Server 3,000 - - Information Technology 0620.6940 TBA 2029 Access Control Maintenance & Updates 3,000 - - Information Technology 0620.6940 TBA 2029 IP Camera Maintenance & Updates 8,000 - - Information Technology 0620.6940 TBA 2030 Capital Acquisition 150,000 - - Information Technology 0620.6940 TBA 2030 Robbinsdale SD - Potential Replacement 18,833 - - Information Technology 0620.6940 TBA 2030 Fiber Improvement & Adds 20,000 - - Information Technology 0620.6940 TBA 2030 Computer Hardware & Software 57,500 - - Information Technology 0620.6940 TBA 2030 City Hall Switch 2 - 48 Port POE 8,021 - - Information Technology 0620.6940 TBA 2030 City Hall Swtich 3 - 48 port POE 8,757 - - Information Technology 0620.6940 TBA 2030 City Hall Switch 4 - 48 Port POE 7,345 - - Information Technology 0620.6940 TBA 2030 WiFi AP - PD Investigations 845 - - Information Technology 0620.6940 TBA 2030 Multi-Function Printer - FINANCE 9,000 - - Information Technology 0620.6940 TBA 2030 Multi-Function Printer - CCC 7,500 - - Information Technology 0620.6940 TBA 2030 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2030 Public Works Switch - 48 Port POE 6,937 - - Information Technology 0620.6940 TBA 2030 PW Switch - 24 Port POE (Pumphouse)4,250 - - Information Technology 0620.6940 TBA 2030 WiFi AP - PW Office 845 - - Information Technology 0620.6940 TBA 2030 WiFi AP - PW Garage East 845 - - Information Technology 0620.6940 TBA 2030 WiFi AP - PW Garage West 845 - - Information Technology 0620.6940 TBA 2030 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2030 Networked Department Printers 800 - - Information Technology 0620.6940 TBA 2030 Access Control Maintenance & Updates 6,000 - - Information Technology 0620.6940 TBA 2030 CCTV System Adds & Improvements 6,500 - - 150,039$ 180,277$ 51 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ 732$ -$ -$ -$ -$ - - - - - 732 - - - - - - - - - 15,000 - - - - - - - - - 7,500 - - - - - - - - - 10,000 - - - - - - - - - 12,000 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 7,500 - - - - - - - - - 800 - - - - - - - - - 10,000 - - - - - - - - - 6,000 - - - - - - - - - 10,000 - - - - - - - - - 18,833 - - - - - - - - - 62,500 - - - - - - - - - 4,703 - - - - - - - - - 6,000 - - - - - - - - - 3,693 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 65,000 - - - - - - - - - 7,500 - - - - - - - - - 800 - - - - - - - - - 5,252 - - - - - - - - - 4,703 - - - - - - - - - 6,000 - - - - - - - - - 3,000 - - - - - - - - - 10,000 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 55,000 - - - - - - - - - 9,605 - - - - - - - - - 11,128 - - - - - - - - - 5,459 - - - - - - - - - 7,300 - - - - - - - - - 800 - - - - - - - - - 3,141 - - - - - - - - - 902 - - - - - - - - - 10,000 - - - - - - - - - 3,000 - - - - - - - - - 3,000 - - - - - - - - - 8,000 - - - - - - - - - - 150,000 - - - - - - - - - 18,833 - - - - - - - - - 20,000 - - - - - - - - - 57,500 - - - - - - - - - 8,021 - - - - - - - - - 8,757 - - - - - - - - - 7,345 - - - - - - - - - 845 - - - - - - - - - 9,000 - - - - - - - - - 7,500 - - - - - - - - - 800 - - - - - - - - - 6,937 - - - - - - - - - 4,250 - - - - - - - - - 845 - - - - - - - - - 845 - - - - - - - - - 845 - - - - - - - - - 800 - - - - - - - - - 800 - - - - - - - - - 6,000 - - - - - - - - - 6,500 152,848$ 132,051$ 143,111$ 300,892$ 427,948$ 364,853$ 320,889$ 293,116$ 308,197$ 318,453$ 52 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Statement of Cash Flows 2019 2020 Estimated Estimated Cash Flows from Operating Activities Receipts from interfund services provided (3% growth annually)459,394$ 477,131$ Receipts from property taxes (1% increase, annually, beginning in 2020)159,179 159,902 Payments to suppliers and employees (2.5% inflation annual starting in 2021)(478,191) (440,170) Net Cash Provided (Used) by Operating Activities 140,382 196,863 Cash Flows from Noncapital Financing Activities Transfers in - 300,000 Net Cash Provided (Used) by Noncapital Financing Activities - 300,000 Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (150,039) (180,277) Intergovernmental revenue - - Proceeds from sale of assets - - Proceeds from bonds and notes issued - - Net Cash Provided (Used) by Capital and Related Financing Activities (150,039) (180,277) Cash Flows from Investing Activities Investment earnings 4,840 4,792 Net Increase (Decrease) in Cash and Cash Equivalents (4,817) 321,378 Cash and Cash Equivalents, January 1 483,992 479,175 Cash and Cash Equivalents, December 31 479,175$ 800,553$ 53 Enterprise Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 579,417$ 588,792$ 592,641$ 612,335$ 751,602$ 701,023$ 669,888$ 655,264$ 683,824$ 707,895$ - - - - - - - - - - (447,748) (478,440) (470,953) (328,921) (337,955) (352,048) (365,976) (379,820) (392,922) (406,481) 131,669 110,352 121,689 283,414 413,647 348,974 303,911 275,444 290,902 301,414 - - - - - - - - - - - - - - - - - - - - (152,848) (132,051) (143,111) (300,892) (427,948) (364,853) (320,889) (293,116) (308,197) (318,453) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - (152,848) (132,051) (143,111) (300,892) (427,948) (364,853) (320,889) (293,116) (308,197) (318,453) 8,006 7,874 7,736 7,599 7,500 7,432 7,347 7,251 7,147 7,045 (13,173) (13,825) (13,687) (9,879) (6,801) (8,447) (9,630) (10,421) (10,148) (9,993) 800,553 787,380 773,555 759,868 749,989 743,188 734,741 725,110 714,689 704,541 787,380$ 773,555$ 759,868$ 749,989$ 743,188$ 734,741$ 725,110$ 714,689$ 704,541$ 694,548$ 54 City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Water 2018 Gate valve and hydrant replacements 50,000$ -$ -$ Water 0090.6935 0055 2019 6235 -Gate Valve and Hydrant replacement 75,000 75,000 - Water 0090.6935 0056 2019 6220- Water main replacement/relining 100,000 100,000 - Water 0090.6935 0057 2019 6205 - Water Utility Replace #432 - 2008 Ford F150 50,000 50,000 - Water 0090.6935 0058 2019 Equipment Replacement 50,000 50,000 - Water 0090.6935 TBA 2020 6207 - Upgrade Sensus meter software 30,000 - 30,000 Water 0090.6935 TBA 2020 Utility Reconstruction 600,000 - 600,000 Water 0090.6935 TBA 2021 6235 -Gate Valve and Hydrant replacement 75,000 - - Water 0090.6935 TBA 2021 Utility Reconstruction 600,000 - - Water 0090.6935 TBA 2022 Utility Reconstruction 1,100,000 - - Water 0090.6935 TBA 2023 June Ave water main replacement (with Blue Line)200,000 - - Water 0090.6935 TBA 2023 6235 -Gate Valve and Hydrant replacement 75,000 - - Water 0090.6935 TBA 2023 6237- water utility Replace #434 - 1996 Air Compressor 30,000 - - Water 0090.6935 TBA 2023 Equipment Replacement 60,000 - - Water 0090.6935 TBA 2023 Utility Reconstruction 800,000 - - Water 0090.6935 TBA 2024 Utility Reconstruction 1,500,000 - - Water 0090.6935 TBA 2024 6235 -Gate Valve and Hydrant replacement 75,000 - - Water 0090.6935 TBA 2024 Equipment Replacement 50,000 - - Water 0090.6935 TBA 2025 Utility Reconstruction 1,500,000 - - Water 0090.6935 TBA 2025 6235 -Gate Valve and Hydrant replacement 30,000 - - Water 0090.6935 TBA 2026 Utility Reconstruction 1,500,000 - - Water 0090.6935 TBA 2026 6235 -Gate Valve and Hydrant replacement 75,000 - - Water 0090.6935 TBA 2026 Equipment Replacement 50,000 - - Water 0090.6935 TBA 2027 Utility Reconstruction 1,600,000 - - Water 0090.6935 TBA 2027 6235 -Gate Valve and Hydrant replacement 30,000 - - Water 0090.6935 TBA 2028 Utility Reconstruction 1,750,000 - - Water 0090.6935 TBA 2028 6235 -Gate Valve and Hydrant replacement 75,000 - - Water 0090.6935 TBA 2028 Equipment Replacement 50,000 - - Water 0090.6935 TBA 2029 Utility Reconstruction 1,850,000 - - Water 0090.6935 TBA 2029 6235 -Gate Valve and Hydrant replacement 30,000 - - Water 0090.6935 TBA 2030 Utility Reconstruction 2,000,000 - - Water 0090.6935 TBA 2030 6235 -Gate Valve and Hydrant replacement 75,000 - - Water 0090.6935 TBA 2030 Equipment Replacement 50,000 - - 275,000$ 630,000$ 55 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 75,000 - - - - - - - - - 600,000 - - - - - - - - - - 1,100,000 - - - - - - - - - - 200,000 - - - - - - - - - 75,000 - - - - - - - - - 30,000 - - - - - - - - - 60,000 - - - - - - - - - 800,000 - - - - - - - - - - 1,500,000 - - - - - - - - - 75,000 - - - - - - - - - 50,000 - - - - - - - - - - 1,500,000 - - - - - - - - - 30,000 - - - - - - - - - - 1,500,000 - - - - - - - - - 75,000 - - - - - - - - - 50,000 - - - - - - - - - - 1,600,000 - - - - - - - - - 30,000 - - - - - - - - - - 1,750,000 - - - - - - - - - 75,000 - - - - - - - - - 50,000 - - - - - - - - - - 1,850,000 - - - - - - - - - 30,000 - - - - - - - - - - 2,000,000 - - - - - - - - - 75,000 - - - - - - - - - 50,000 675,000$ 1,100,000$ 1,165,000$ 1,625,000$ 1,530,000$ 1,625,000$ 1,630,000$ 1,875,000$ 1,880,000$ 2,125,000$ 56 City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Statement of Cash Flows 2019 2020 Estimated Estimated Cash Flows from Operating Activities Receipts from customers and users based on utility rate analysis)3,631,212$ 4,114,447$ Payments to suppliers (based on utility rate analysis)(2,872,029) (2,958,190) Payments to employees (based on utility rate analysis)(396,872) (416,715) Net Cash Provided (Used) by Operating Activities 362,311 739,542 Cash Flows from Noncapital Financing Activities Transfers to other funds (190,684) (200,218) Net Cash Provided (Used) by Noncapital Financing Activities (190,684) (200,218) Cash Flows from Capital and Related Financing Activities Infrastructure improvements (275,000) (630,000) Contribution to fleet internal service fund (134,350) (134,350) Intergovernmental (Joint Water Commission)- - Interest expense (7,368) (6,315) Advances to/(from) other funds (60,000) (60,000) Net Cash Provided (Used) by Capital and Related Financing Activities (476,718) (830,665) Cash Flows from Investing Activities Investment earnings 13,666 10,752 Net Increase (Decrease) in Cash and Cash Equivalents (291,424) (280,589) Cash and Cash Equivalents, January 1 1,366,637 1,075,213 Cash and Cash Equivalents, December 31 1,075,213$ 794,624$ 57 Enterprise Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 4,579,442$ 5,005,116$ 5,369,944$ 5,653,634$ 5,838,893$ 6,030,178$ 6,227,686$ 6,539,070$ 6,866,024$ 7,209,325$ (3,046,935) (3,138,343) (3,232,494) (3,232,494) (3,429,352) (3,532,233) (3,638,200) (3,747,346) (3,859,766) (3,975,559) (437,551) (459,429) (482,400) (506,520) (531,846) (558,438) (586,360) (615,678) (646,462) (678,785) 1,094,956 1,407,344 1,655,050 1,914,620 1,877,695 1,939,507 2,003,126 2,176,046 2,359,795 2,554,980 (210,229) (220,741) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (210,229) (220,741) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (675,000) (1,100,000) (1,165,000) (1,625,000) (1,530,000) (1,625,000) (1,630,000) (1,875,000) (1,880,000) (2,125,000) (134,350) (104,139) (97,942) (95,441) (90,249) (86,696) (65,394) (53,134) (49,722) (49,722) .- - - - - - - - - (5,242) (4,147) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (60,000) (60,000) (60,000) (60,000) - - - - - - (874,592) (1,268,286) (1,325,971) (1,783,470) (1,623,278) (1,714,725) (1,698,423) (1,931,163) (1,932,751) (2,177,751) - - - - 7,197 7,496 7,501 8,305 8,519 10,557 10,134 (81,683) 97,302 (100,627) 29,837 500 80,426 21,410 203,786 156,009 794,624 804,758 723,076 820,377 719,750 749,586 750,086 830,512 851,922 1,055,708 804,758$ 723,076$ 820,377$ 719,750$ 749,586$ 750,086$ 830,512$ 851,922$ 1,055,708$ 1,211,716$ 58 City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Year to Estimated Estimated Department Replace Item Cost Amounts Amounts Sewer 2018 Back-up pump - South lift station #9 20,000$ -$ -$ Sewer 2018 Three phase power - South lift station #9 50,000 - - Sewer 2018 Reline sewer - 30" CIPP 2002-10 50,000 - - Sewer 2018 Add emerg generator - Welcome Av lift station #5 50,000 - - Sewer 2018 Replace manhole covers 225,000 - - Sewer 0092.6935 0007 2019 6504 - Sanitary Sewer Replacement (lining, dig up)600,000 600,000 - Sewer 0092.6935 TBA 2020 Install Pad mount Generator at West Lift Station 50,000 - 50,000 Sewer 0092.6935 TBA 2020 Utility Reconstruction 1,200,000 - 1,200,000 Sewer 0092.6935 TBA 2021 Utility Reconstruction 400,000 - - Sewer 0092.6935 TBA 2022 20 Kw portable generator with light tower (replace existing 37kW)20,000 - - Sewer 0092.6935 TBA 2022 Equipment Replacement 220,000 - - Sewer 0092.6935 TBA 2022 Utility Reconstruction 500,000 - - Sewer 0092.6935 TBA 2023 Utility Reconstruction 800,000 - - Sewer 0092.6935 TBA 2024 Utility Reconstruction 800,000 - - Sewer 0092.6935 TBA 2025 Utility Reconstruction 800,000 - - Sewer 0092.6935 TBA 2025 Equipment Replacement 60,000 - - Sewer 0092.6935 TBA 2026 Utility Reconstruction 850,000 - - Sewer 0092.6935 TBA 2027 Utility Reconstruction 950,000 - - Sewer 0092.6935 TBA 2027 Equipment Replacement 60,000 - - Sewer 0092.6935 TBA 2028 Utility Reconstruction 1,250,000 - - Sewer 0092.6935 TBA 2029 Utility Reconstruction 950,000 - - Sewer 0092.6935 TBA 2029 Equipment Replacement 60,000 - - Sewer 0092.6935 TBA 2029 Replace generator - Vera Cruz life 120,000 - - Sewer 0092.6935 TBA 2030 Utility Reconstruction 1,300,000 - - 600,000$ 1,250,000$ 59 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 400,000 - - - - - - - - - - 20,000 - - - - - - - - - 220,000 - - - - - - - - - 500,000 - - - - - - - - - - 800,000 - - - - - - - - - - 800,000 - - - - - - - - - - 800,000 - - - - - - - - - 60,000 - - - - - - - - - - 850,000 - - - - - - - - - - 950,000 - - - - - - - - - 60,000 - - - - - - - - - - 1,250,000 - - - - - - - - - - 950,000 - - - - - - - - - 60,000 - - - - - - - - - 120,000 - - - - - - - - - - 1,300,000 400,000$ 740,000$ 800,000$ 800,000$ 860,000$ 850,000$ 1,010,000$ 1,250,000$ 1,130,000$ 1,300,000$ 60 City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Statement of Cash Flows 2019 2020 Estimated Estimated Cash Flows from Operating Activities Receipts from customers and users 2,497,838$ 2,805,211$ Payments to suppliers (based on utility rate analysis)(1,742,193) (1,794,459) Payments to employees (based on utility rate analysis)(395,334) (415,101) Net Cash Provided (Used) by Operating Activities 360,310 595,651 Cash Flows from Noncapital Financing Activities Transfers to other funds (190,684) (200,218) Net Cash Provided (Used) by Noncapital Financing Activities (190,684) (200,218) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (600,000) (1,250,000) Contribution to fleet internal service fund (215,774) (215,774) Advances to/(from) other funds 30,000 30,000 Grants and contributions - - Net Cash Provided (Used) by Capital and Related Financing Activities (785,774) (1,435,774) Cash Flows from Investing Activities Investment earnings 23,688 19,214 Net Increase (Decrease) in Cash and Cash Equivalents (592,460) (1,021,127) Cash and Cash Equivalents, January 1 2,116,511 1,524,051 Cash and Cash Equivalents, December 31 1,524,051$ 502,924$ 61 Enterprise Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 3,094,129$ 3,350,727$ 3,561,382$ 3,713,834$ 3,835,545$ 3,961,216$ 4,090,976$ 4,295,525$ 4,510,301$ 4,735,816$ (1,848,293) (1,903,742) (1,960,854) (2,019,680) (2,080,270) (2,142,678) (2,206,958) (2,317,306) (2,433,171) (2,554,830) (435,856) (457,649) (480,531) (504,558) (529,786) (556,275) (584,089) (613,293) (643,958) (676,156) 809,980 989,336 1,119,997 1,189,596 1,225,489 1,262,263 1,299,929 1,364,925 1,433,172 1,504,830 (210,229) (220,741) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (210,229) (220,741) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (400,000) (740,000) (800,000) (800,000) (860,000) (850,000) (1,010,000) (1,250,000) (1,130,000) (1,300,000) (194,092) (173,437) (172,428) (169,715) (155,605) (104,599) (83,297) (71,027) (57,253) (57,253) 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 - - - - - - - - - - (564,092) (883,437) (942,428) (939,715) (985,605) (924,599) (1,063,297) (1,291,027) (1,157,253) (1,327,253) 16,017 15,748 14,680 14,680 14,680 14,680 14,680 14,680 14,680 14,680 51,676 (99,094) (39,529) 32,783 22,786 120,566 19,534 (143,199) 58,821 (39,520) 502,924 554,600 455,506 415,977 448,761 471,547 592,113 611,647 468,448 527,269 554,600$ 455,506$ 415,977$ 448,761$ 471,547$ 592,113$ 611,647$ 468,448$ 527,269$ 487,749$ 62 City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Year to Estimated Estimated Department Replace Item Cost Amounts Amounts Storm water 2018 Dredge Basset Creek Park pond 1,000,000$ -$ -$ Storm water 0094.6935 0059 2019 Becker Park infiltration project (1)2,432,985 2,432,985 - Storm water 0094.6935 TBA 2020 City storm water model and flood analysis 125,000 - 125,000 Storm water 0094.6935 TBA 2020 Rate Control,water quality, structure Rehab projects 50,000 - 50,000 Storm water 0094.6935 TBA 2020 W. Broadway and Kentucky Infiltration 150,000 - 150,000 Storm water 0094.6935 TBA 2020 Utility Reconstruction 50,000 - 50,000 Storm water 0094.6935 TBA 2021 6804 - Gaulke Pond design, dredging, lift station rehab 800,000 - - Storm water 0094.6935 TBA 2021 Rate Control,water quality, structure Rehab projects 50,000 - - Storm water 0094.6935 TBA 2021 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2022 Brownwood pond dredging and expansion 750,000 - - Storm water 0094.6935 TBA 2022 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2022 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2023 Rate Control,water quality, structure Rehab projects 50,000 - - Storm water 0094.6935 TBA 2023 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2023 Equipment Replacement 20,000 - - Storm water 0094.6935 TBA 2023 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2024 Rate Control,water quality, structure Rehab projects 100,000 - - Storm water 0094.6935 TBA 2024 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2024 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2025 Equipment Replacement 20,000 - - Storm water 0094.6935 TBA 2025 Rate Control,water quality, structure Rehab projects 100,000 - - Storm water 0094.6935 TBA 2025 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2025 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2026 Bassett Creek Park Streambank Stablization and 29th culvert replacement (3)1,000,000 - - Storm water 0094.6935 TBA 2026 Rate Control,water quality, structure Rehab projects 100,000 - - Storm water 0094.6935 TBA 2026 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2026 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2027 Equipment Replacement 20,000 - - Storm water 0094.6935 TBA 2027 Pond dredging - TBD 750,000 - - Storm water 0094.6935 TBA 2027 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2027 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2028 Rate Control,water quality, structure Rehab projects 100,000 - - Storm water 0094.6935 TBA 2028 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2028 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2029 Equipment Replacement 20,000 - - Storm water 0094.6935 TBA 2029 Saving for flood control structure replacement 200,000 - - Storm water 0094.6935 TBA 2029 Yunkers Park storage project 1,500,000 - - Storm water 0094.6935 TBA 2029 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2030 Capital 1,837,500 - - Storm water 0094.6935 TBA 2030 Utility Reconstruction 50,000 - - 2,432,985$ 375,000$ (1) Secured grants of $1,325,000 have been included in the cash flow analysis below; the City has also applied for an additional $80K of grants and identified $400K in other potential grant opportunities. 63 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 800,000 - - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - - - 750,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 50,000 - - - - - - - - - 200,000 - - - - - - - - - 20,000 - - - - - - - - - 50,000 - - - - - - - - - - 100,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 20,000 - - - - - - - - - 100,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 1,000,000 - - - - - - - - - 100,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 20,000 - - - - - - - - - 750,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 100,000 - - - - - - - - - 200,000 - - - - - - - - - 50,000 - - - - - - - - - - 20,000 - - - - - - - - - 200,000 - - - - - - - - - 1,500,000 - - - - - - - - - 50,000 - - - - - - - - - - 1,837,500 - - - - - - - - - 50,000 900,000$ 1,000,000$ 320,000$ 350,000$ 370,000$ 1,350,000$ 1,020,000$ 350,000$ 1,770,000$ 1,887,500$ 64 City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Statement of Cash Flows 2019 2020 Estimated Estimated Cash Flows from Operating Activities Receipts from customers and users (5% growth assumption)1,149,899$ 1,207,394$ Payments to suppliers and employees (5% growth assumption)(482,142) (506,249) Net Cash Provided (Used) by Operating Activities 667,757 701,145 Cash Flows from Noncapital Financing Activities Transfers out (49,326) (50,997) Net Cash Provided (Used) by Noncapital Financing Activities (49,326) (50,997) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (2,432,985) (375,000) Contribution to fleet internal service fund (140,521) (140,521) Intergovernmental revenue (Watershed, Met Council, MNDNR and other)1,475,000 50,000 Net Cash Provided (Used) by Capital and Related Financing Activities (1,098,506) (465,521) Cash Flows from Investing Activities Investment earnings 15,565 10,920 Net Increase (Decrease) in Cash and Cash Equivalents (464,511) 195,547 Cash and Cash Equivalents, January 1 1,556,505 1,091,994 Cash and Cash Equivalents, December 31 1,091,994$ 1,287,541$ 65 Enterprise Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 1,267,763$ 1,331,151$ 1,397,709$ 1,467,594$ 1,540,974$ 1,618,023$ 1,698,924$ 1,783,870$ 1,873,064$ 1,966,717$ (531,562) (558,140) (586,047) (615,349) (646,116) (678,422) (712,343) (747,960) (785,359) (824,626) 736,202 773,012 811,662 852,246 894,858 939,601 986,581 1,035,910 1,087,705 1,142,091 (53,547) (56,224) (59,035) (61,987) (65,086) (68,341) (71,758) (75,346) (79,113) (83,069) (53,547) (56,224) (59,035) (61,987) (65,086) (68,341) (71,758) (75,346) (79,113) (83,069) (900,000) (1,000,000) (320,000) (350,000) (370,000) (1,350,000) (1,020,000) (350,000) (1,770,000) (1,887,500) (129,680) (113,290) (112,647) (111,184) (108,650) (106,873) (96,222) (53,761) (52,102) (52,102) - - - - - 500,000 - - - - (1,029,680) (1,113,290) (432,647) (461,184) (478,650) (956,873) (1,116,222) (403,761) (1,822,102) (1,939,602) 12,875 9,534 5,664 8,921 12,301 15,935 15,238 13,376 19,078 11,134 (334,150) (386,968) 325,644 337,995 363,422 (69,678) (186,161) 570,180 (794,431) (869,446) 1,287,541 953,391 566,423 892,067 1,230,063 1,593,485 1,523,806 1,337,646 1,907,825 1,113,394 953,391$ 566,423$ 892,067$ 1,230,063$ 1,593,485$ 1,523,806$ 1,337,646$ 1,907,825$ 1,113,394$ 243,948$ 66 City of Crystal, Minnesota Capital Improvement Plan - Street Light Fund 520 Schedule of Planned Capital Outlay 2018 to 2030 2019 2020 Business Unit Year to Estimated Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Street light 0096.6915 0060 2019 Parking lot lighting upgrades at City Hall 45,000$ 45,000$ -$ Street light 0096.6915 TBA 2020 HPS to LED conversion 25,000 - 25,000 Street light 0096.6915 TBA 2021 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2022 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2023 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2023 Underground utility poles (42nd)1,000,000 - - Street light 0096.6915 TBA 2024 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2025 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2026 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2027 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2028 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2029 HPS to LED conversion 25,000 - - Street light 0096.6915 TBA 2030 HPS to LED conversion 25,000 - - 45,000$ 25,000$ 67 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - 1,000,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 - - - - - - - - - - 25,000 25,000$ 25,000$ 1,025,000$ 25,000$ 25,000$ 25,000$ 25,000$ 25,000$ 25,000$ 25,000$ 68 City of Crystal, Minnesota Capital Improvement Plan - Street Light Fund 520 Statement of Cash Flows 2019 2020 Estimated Estimated Cash Flows from Operating Activities Receipts from customers and users (2% growth assumption)204,688$ 204,688$ Payments to suppliers and employees (5% growth assumption)(135,237) (141,999) Net Cash Provided (Used) by Operating Activities 69,451 62,689 Cash Flows from Noncapital Financing Activities Transfers out (13,216) (13,935) Net Cash Provided (Used) by Noncapital Financing Activities (13,216) (13,935) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (45,000) (25,000) Intergovernmental revenue - - Advances to/(from) other funds 30,000 30,000 Net Cash Provided (Used) by Capital and Related Financing Activities (15,000) 5,000 Cash Flows from Investing Activities Investment earnings 6,025 6,497 Net Increase (Decrease) in Cash and Cash Equivalents 47,259 60,251 Cash and Cash Equivalents, January 1 602,471 649,730 Cash and Cash Equivalents, December 31 649,730$ 709,982$ 69 Enterprise Fund Projected Activity 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 208,782$ 212,957$ 217,217$ 221,561$ 225,992$ 230,512$ 235,122$ 239,825$ 244,621$ 249,514$ (149,099) (156,554) (164,381) (172,601) (181,231) (190,292) (199,807) (209,797) (220,287) (231,301) 59,683 56,404 52,835 48,960 44,762 40,220 35,315 30,028 24,334 18,212 (14,632) (15,363) (16,132) (16,938) (17,785) (18,674) (19,608) (20,588) (21,618) (22,699) (14,632) (15,363) (16,132) (16,938) (17,785) (18,674) (19,608) (20,588) (21,618) (22,699) (25,000) (25,000) (1,025,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) (25,000) - - 500,000 - - - - - - - 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 30,000 5,000 5,000 (495,000) 5,000 5,000 5,000 5,000 5,000 5,000 5,000 7,100 7,671 8,208 3,708 4,115 4,476 4,786 5,041 5,236 5,365 57,151 53,712 (450,088) 40,730 36,091 31,021 25,493 19,480 12,952 5,879 709,982 767,133 820,844 370,756 411,486 447,578 478,599 504,092 523,573 536,525 767,133$ 820,844$ 370,756$ 411,486$ 447,578$ 478,599$ 504,092$ 523,573$ 536,525$ 542,404$ 70 Tax Rates Tax Rates: General Fund Operations and All Funds Cash Balances General Fund Balance as a Percent of Expenditures:Cash Balance by Planned Use (000's): Tax rates are a function of the levy and total tax base. The city tax rate is computed by dividing the city levy by the taxable tax capacity. Future tax rates are based on the assumption of 3.5% growth in tax capacity (see Assumptions). Comparable communities are provided for reference. The General fund fund balance should be maintained at a level to provide for adequate working capital reserves. The MN State Auditor recommends a 35-50% reserve. As the expenditure budget grows, the required reserve should increase accordingly. The City can build to this target by adding to contingency each year. This can be accomplished by reducing expenditures and maintaining the same level of revenue or increasing tax levy. The balances represented in this graph are categorized by the planned use and/or limitations determined by statute. $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 Total Fund BalanceBudget (calculation based on next years budget)Target Fund Balance (45%) General Fund Balance as a Percent of Expenditures 2017 (Actual) 2018 -2030 (Estimated) 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% City Tax Capacity Rates 2017 -2018 (Actual) and 2019 -2030 (Estimated) General Capital levies Scheduled debt levies Total EDA Tax Rate $- $10,000,000 $20,000,000 $30,000,000 $40,000,000 $50,000,000 $60,000,000 $70,000,000 $80,000,000 Cash Balance by Planned Use 2017 (Actual) and 2018 -2030 (Estimated) General fund Debt service Capital projects Special revenue Enterprise Internal service Agency (pass-through grant) 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 2013 2014 2015 2016 2017 2018 Tax Capacity Tax Rate -Comparison Cities 2013 -2018 (Actual) New Hope Golden Valley Hopkins Brooklyn Center Crystal 71 Property Taxes by Type Debt Debt Balances This graph highlights the percent of levy by planned use. Increases in the levy are primarily attributed to the growth in scheduled and proposed debt levies as well as growth in the City's General levy. The overall city tax burden for a $196,000 house in 2019 is shown in the graph on the right. The overall property tax levy for an average valued house is highlighted above. The above assumes a new $8 million bond in 2020 for a new Public Safety building. From 2016 to 2030, as presented above, total governmental type debt is reduced from $15.9 million to $4.6 million, a reduction of approximately $11.3 million. Projected City Tax Impact - 2019 $196,000 homePercent of Property Taxes - General Levy and Bonds $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 2018201920202021202220232024202520262027202820292030Property Taxes -General Levy, EDA, Debt Service and Capital 2017 -2018 (Actual) and 2019 -2030 (Estimated) General Capital Economic Development Authority Debt service - 200 400 600 800 1,000 1,200 1,400 1,600 Projected City Tax Impact 2017 -2030 (Estimated) $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 $20,000,000 Projected Debt Balances Based on Current Amortizations and New Debt Assumed in CIP 2017 (Actual) and 2018 -2030 (Estimated) G.O. Aquatic Center Bonds G.O. Improvement G.O. Street Reconstruction 0 500 1000 1500 2000 2500 3000 3500 4000 4500 2012201320142015201620172018201920202021202220232024202520262027202820292030Debt Per Capita -Comparison Cities 2012 -2017 (Actual) 2018 -2030 (Estimated) New Hope Golden Valley Hopkins Brooklyn Center Crystal 72