Loading...
2022.08.04 Budget Work Session Packet 4141 Douglas Drive North • Crystal, Minnesota 55422-1696 Tel: (763) 531-1000 • Fax: (763) 531-1188 • www.crystalmn.gov Posted: July 29, 2022 City Council Work Session Agenda Thursday, Aug. 4, 2022 at 6:30 p.m. Council Chambers/Zoom 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 on Thursday, Aug. 4, 2022 at ______ p.m. in the Council Chambers at City Hall, 4141 Douglas Dr. N., Crystal, MN and via Zoom. The public may attend the meeting via Zoom by connecting to it through one of the methods identified on the Notice of Aug. 4, 2022 Work Session. I. Attendance Council members Staff ____ Adams ____ Norris ____ Banks ____ Therres ____ Budziszewski ____ Gilchrist ____ Cummings ____ Elholm ____ Kiser ____ Larson ____ LaRoche ____ Ray ____ Parsons ____ Revering ____ McGann ____ Bursheim ____ Sutter ____ Serres II. Agenda The purpose of the work session is to discuss the following agenda items: 1. 2023 – 2024 budgets and preliminary levies. 2. 2023 – 2032 long term plan. 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. 4141 Douglas Drive North • Crystal, Minnesota 55422-1696 Tel: (763) 531-1000 • Fax: (763) 531-1188 • www.crystalmn.gov Posted: July 29, 2022 CITY COUNCIL WORK SESSION NOTICE OF AUG. 4, 2022 WORK SESSION NOTICE IS HEREBY GIVEN that the City Council of the City of Crystal will hold a work session on Thursday, Aug. 4, 2022 at 6:30 p.m. at Crystal City Hall, 4141 Douglas Dr. N., Crystal, MN and via Zoom. The public may attend the meeting via Zoom by connecting to it through one of the methods identified below. Topic: City Council Work Session Time: Aug. 4, 2022, 6:30 p.m. Central Time (US and Canada) Join Zoom Meeting https://us02web.zoom.us/j/82578903905?pwd=M3VyWElYVGlxbTc4SnJhU29vb1prUT09 Meeting ID: 825 7890 3905 Passcode: 405286 One tap mobile +19292056099,,82578903905#,,,,*405286# US (New York) +13017158592,,82578903905#,,,,*405286# US (Washington DC) Dial by your location +1 929 205 6099 US (New York) +1 301 715 8592 US (Washington DC) +1 312 626 6799 US (Chicago) +1 646 931 3860 US +1 346 248 7799 US (Houston) +1 386 347 5053 US +1 564 217 2000 US +1 669 444 9171 US +1 669 900 6833 US (San Jose) +1 253 215 8782 US (Tacoma) Find your local number: https://us02web.zoom.us/u/kbas7dLtyv 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. August 4, 2022 2023 –2024 Budget Update 2023 –2024 Property Taxes General Fund Overview Long-term Plan Property taxes increase proposed at 11.12%, of which; ◦1% levy increase dedicated to park capital ◦1% levy increase dedicated to streets capital ◦3.14% levy increase due to loss of Local Government Aid (LGA) Local Government Aid loss of $425k o General Fund impact of $232,960 o Building Fund impact of $232,960 American Rescue Plan Act dollars of $2.2M allocated to Police Department construction West Metro –increase request of $115,000 Police staffing increase request of $200,000 ….. continued Worker compensation and insurance premiums increases Health insurance –estimated at 13% increase (City and Employees will share in the increase which will be determined during contract negotiations) Cost of Living (COLA) will be higher than in past years due to contracts being lower than neighboring cities and the general market in 2021/2022 Fuel increases –Diesel 50%, Regular 27% Union contracts open Updated Utility Rate Study underway ….. continued •Property tax increase proposed at 11.59% •Utilities staffing increase one person for meter maintenance and replacements -$37,738 •Three Elections in 2024 •Market value shift in Crystal residential properties •Capital levy increases as planned •Worker compensation and insurance premiums increases •Health insurance increases anticipated 2022 Adopted 2022 Increase (Decrease) 2022 % Change 2023 Proposed 2023 Increase (Decrease) 2023 % Change 2024 Proposed 2024 Increase (Decrease) 2024 % Change General levy 12,508,518$ 424,029$ 3.51 %13,874,048$ 1,365,530$ 10.92 %15,180,999$ 1,306,951$ 9.42 % Capital Improvements Police Equipment Revolving 158,037 - 0.00 161,197 3,160 2.00 164,421 3,224 2.00 Park Improvement 606,999 126,488 26.32 741,057 134,058 22.09 882,753 141,696 19.12 Street Construction 245,926 131,376 114.69 384,221 138,295 56.23 529,047 144,826 37.69 Total Capital Improvements levy 1,010,962 257,864 34.24 1,286,475 275,513 27.25 1,576,221 289,746 22.52 EDA 310,000 10,000 3.23 316,200 6,200 2.00 322,524 6,324 2.00 Total levy 13,829,480$ 691,893$ 5.27 %15,476,723$ 1,538,400$ 11.12 %17,079,744$ 1,603,021$ 11.59 % Amount Percent Levy Increase Amount Percent Levy Increase Operations 1,365,530$ 9.97 %Local Government Aid loss 232,960$ 1.57% Capital 275,513 0.92 Licenses and Permits (81,700) -0.55% EDA 6,200 0.23 Charges for Services 85,378 0.58% Total Levy Increase 1,647,243$ 11.12 %Fines and Forfeits 88,500 0.60% Special Assessments and other (19,950) -0.13% Administrative Transfers (146,110) -0.99% Wages and benefits - existing staff 902,872 6.09% Wages and benefits - Crime Analyst 138,938 0.94% Mayor and Council - contingency and dues/subscriptions 146,453 0.99% Administration - postage and phone 9,470 0.06% Assessing - County contract 6,445 0.04% Legal 2,000 0.01% Elections (11,500) -0.08% Finance - professional services and audit 40,500 0.27% Police - MH Social Worker, Cornerstone, fuel 54,705 0.37% Fire 104,819 0.71% Community Development - contractual services 8,000 0.05% Forestry - tree trimming 22,000 0.15% Recreation - rental of equipment 22,000 0.15% Recreation programs 32,555 0.22% Internal Service Fund transfers (103,878) -0.70% City Utility Charges and Insurance (now accounted for in Internal Service fund)(206,743) -1.40% Capital 275,513 1.86% EDA 6,200 0.04% Inflationery increases 37,816 0.26% 1,647,242$ 11.12% Summary Detail Amount Percent Levy Increase Amount Percent Levy Increase Operations 1,306,951$ 10.30 %Local Government Aid loss -$ 0.00% Capital 289,746 1.07 Licenses and Permits 28,800 0.21% EDA 6,324 0.22 Charges for Services (17,720) -0.13% Total Levy Increase 1,603,021$ 11.59 %Fines and Forfeits - 0.00% Special Assessments and other 20,000 0.14% Administrative Transfers (31,377) -0.23% Wages and benefits - existing staff 685,519 4.96% Wages and benefits - Crime Analyst - 0.00% Mayor and Council - contingency and dues/subscriptions - 0.00% Administration - newsletters, supplies and postage 4,500 0.03% Assessing - County contract 8,000 0.06% Legal 2,000 0.01% Elections 15,800 0.11% Finance - professional services and audit 16,800 0.12% Police - legal 4,800 0.03% Fire 184,627 1.33% Community Development - contractual services 6,100 0.04% Forestry - tree trimming - 0.00% Recreation - rental of equipment 1,000 0.01% Recreation programs 5,870 0.04% Internal Service Fund transfers 347,834 2.51% City Utility Charges and Insurance (now accounted for in Internal Service fund)13,781 0.10% Capital 289,746 2.09% EDA 6,324 0.05% Inflationery increases 10,617 0.08% 1,603,021$ 11.59% Summary Detail 2021 2022 2023 2024 Adopted Adopted Proposed Proposed REVENUES Property taxes - operations 12,052,301$ 12,586,094$ 13,922,548$ 15,229,499$ Special assessments and other 30,806 52,000 71,950 51,950 Licenses and permits 874,704 850,960 932,660 903,860 Intergovernmental revenues 1,797,751 1,777,489 1,596,986 1,559,486 Charges for services 663,909 863,853 778,475 796,195 Fines & forfeits 158,325 275,000 186,500 186,500 Investment income (50,292) 125,000 100,000 100,000 Miscellaneous 88,307 68,000 44,500 44,500 Other - interfund services transfers in 479,502 505,185 651,295 682,672 TOTAL REVENUES 16,095,313$ 17,103,581$ 18,284,914$ 19,554,662$ EXPENDITURES General Government 2,237,903$ 2,353,195$ 2,573,075$ 2,765,141$ Public safety 8,478,735 8,515,723 9,313,974 9,960,732 Community Development 677,719 742,832 823,802 862,680 Public works 3,142,032 3,239,980 3,349,557 3,558,026 Recreation 2,131,805 2,251,851 2,224,507 2,398,082 TOTAL EXPENDITURES 16,668,193$ 17,103,581$ 18,284,914$ 19,544,662$ Long Term Plan City of Crystal Crystal, Minnesota December 21, 2021 DRAFT THIS PAGE IS LEFT BLANK INTENTIONALLY 2 DRAFT City of Crystal, Minnesota Long Term Plan Table of Contents Page No. Compilation Disclosure 5 Introductory Section Transmittal Letter 8 Financial Section Schedule of Property Taxes Levied and Tax Rates 12 Schedule of Annual Fund Cash Balances 16 Outstanding Debt Schedule 18 Capital Improvement Plan Street Capital Fund 415 Schedule of Planned Capital Outlay 2019 to 2030 20 Schedule of Projected Revenue, Expenditures and Debt 24 Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2019 to 2030 26 Schedule of Projected Revenue, Expenditures and Debt 30 Park Improvements 420 Schedule of Planned Capital Outlay 2019 to 2030 32 Schedule of Projected Revenue, Expenditures and Debt 36 Water Fund 505 Schedule of Planned Capital Outlay 2019 to 2030 38 Statement of Cash Flows 40 Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2019 to 2030 42 Statement of Cash Flows 44 Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2019 to 2030 46 Statement of Cash Flows 48 Street Light Fund 520 Schedule of Planned Capital Outlay 2019 to 2030 50 Statement of Cash Flows 52 Fleet Fund 615 Schedule of Planned Capital Outlay 2019 to 2030 54 Statement of Cash Flows 58 Major Building Replacement Fund 408/625 Schedule of Planned Capital Outlay 2019 to 2030 60 Schedule of Projected Revenue, Expenditures and Debt 66 Information Technology Fund 620 Schedule of Planned Capital Outlay 2019 to 2030 68 Statement of Cash Flows 74 Selected Graphical Data from Projections 76 Appendix A Internal Loan Schedule for Police Department Facility Renovation/Construction 80 Appendix B Internal Service Summary Schedule 85 3 DRAFT THIS PAGE IS LEFT BLANK INTENTIONALLY 4 DRAFT COMPILATION DISCLOSURE Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, Minnesota 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, 2032, 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 stat ements 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, Abdo Financial Solutions 5 DRAFT THIS PAGE IS LEFT BLANK INTENTIONALLY 6 DRAFT INTRODUCTORY SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 7 DRAFT Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, Minnesota 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 ten 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 made 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 11.00% 2023 - 2024 5.50% 2025 - 2030 3.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% Estimated Market Value 2022 - 2024 3.00% 2025 - 2031 1.00% Governmental Fund Debt Interest Rate 3.00% Governmental Fund Debt Term 15 (1) Specific enterprise fund assumptions are noted in the Financial Section. 8 DRAFT Assumptions with Future Action • General Fund property tax revenue has been increased for 2023 and 2024 based on the results of the long-term plan, Park System Master Plan, increased funding for Streets and inflation. • PERF Fund 235 will need additional analysis and policy review to ensure capital needs are met. • Building Fund 625 will receive internal loans for the renovation/construction of a Police Department Facility and for other capital needs. These loans are from the Street Improvement Fund, Police Revolving Fund, Water Fund, and Storm Water Fund. All loans will be repaid by 2032 and the repayment schedule is included on page 78. Key Highlights • As of December 31, 2021, the General fund had a 40.59 percent operating reserve. 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 $13.8 million (2022 adopted) to $27.3 million (2032 projected) over the duration of this Plan based on the anticipated construction of a public safety facility along with other capital levy needs. The levy increase will result in an increase in the projected city tax rate, ranging from 46.188 percent (2022) to 72.964 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 3 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 is projected in 2022. • Beginning in 2022, the Street fund received an additional 1% overall levy increase annually to assist in preserving/maintaining and reconstructing streets within the city. • Total debt outstanding is projected to decrease from $11.1 million (2021 actual) to $275,000 (2032 projected) over the duration of this Plan. As a result, the debt per capita will fall from an estimated $445 (2021 actual) per household to an estimated $10 (2032 projected) over the duration of this Plan. • Due to planned capital projects, the total cash position of the city is projected to decrease from $42.0 million (2021 actual) to $34.0 million over the duration of this Plan. • The Police Department facility has been allocated $4,000,000 based on the 2020 state bonding bill. This allocation was received in 2021 and 2022. In addition, the American Rescue Plan Act Funds (ARPA) of $2.2M are allocated to the Police Department facility. • 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 20 22 - 2032 will vary from the results estimated in this report. 9 DRAFT THIS PAGE IS LEFT BLANK INTENTIONALLY 10 DRAFT FINANCIAL SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 11 DRAFT NOTE: 1% additional levy to street fund 2021 2022 2023 2024 2025 Actual Budgeted Proposed Proposed Estimated Amounts Amounts Amounts Amounts Amounts Property Taxes Levied for General Purposes 100 General 12,084,489$ 12,508,518$ 13,874,048$ 15,180,999$ 15,940,049$ 220 EDA/HRA Funds 301,471 310,000 316,200 322,524 328,974 415 Street Capital 114,550 245,940 384,267 529,062 681,987 235 PERF Fund 158,037 161,197 161,197 164,421 171,064 420 Park Improvements 480,511 606,999 741,043 882,738 1,032,500 Total Taxes Levied 13,139,058 13,832,654 15,476,755 17,079,744 18,154,574 Percent Levy Increase 6.68%5.28%11.89%10.36%6.29% Less: Value of Market Value Levies - - - - - Less: Distribution from fiscal disparities (2,269,837) (2,572,319) (2,649,489) (2,728,973) (2,810,842) City Net Levy 10,869,221$ 11,260,335$ 12,827,266$ 14,350,771$ 15,343,732$ Market Value Tax Levy to be Spread 10,567,750$ 10,950,335$ 12,511,066$ 14,028,247$ 15,014,757$ Tax Capacity Personal and Real Estate 23,617,970$ 25,658,448$ 26,428,201$ 27,221,047$ 28,037,679$ Other assumed net growth factors - - - - - Less: Contribution to fiscal disparities (1,481,700) (1,661,902) (1,711,759) (1,763,112) (1,816,005) Less: Tax Increment (288,561) (288,561) (288,561) (288,561) (288,561) Adjusted net tax capacity 21,847,709$ 23,707,985$ 24,427,881$ 25,169,375$ 25,933,113$ Estimated Market Value 2,213,904,900$ 2,280,322,047$ 2,348,731,708$ 2,419,193,660$ 2,443,385,596$ Maximum EDA/HRA Levy 409,572 421,860 434,515 447,551 452,026 City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates For the Years Ended December 31, 2021 (Actual) and 2022 to 2032 (Estimated) DRAFT 12 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts 16,737,051$ 17,573,904$ 18,452,599$ 19,375,229$ 20,343,991$ 21,361,190$ 22,429,250$ 335,554 342,265 349,110 356,093 363,214 370,479 377,888 843,454 1,013,897 1,193,772 1,383,556 1,583,751 1,794,885 2,017,511 174,485 177,975 181,534 185,165 188,868 192,645 196,498 1,190,742 1,357,896 1,534,415 1,720,777 1,917,481 2,125,054 2,344,047 19,281,286 20,465,937 21,711,430 23,020,819 24,397,305 25,844,253 27,365,194 6.21%6.14%6.09%6.03%5.98%5.93%5.89% - - - - - - - (2,895,168) (2,982,023) (3,071,483) (3,163,628) (3,258,537) (3,356,293) (3,456,982) 16,386,119$ 17,483,914$ 18,639,947$ 19,857,191$ 21,138,768$ 22,487,960$ 23,908,212$ 16,050,565$ 17,141,649$ 18,290,837$ 19,501,098$ 20,775,554$ 22,117,482$ 23,530,324$ 28,878,809$ 29,745,174$ 30,637,529$ 31,556,655$ 32,503,354$ 33,478,455$ 34,482,809$ - - - - - - - (1,870,485) (1,926,600) (1,984,398) (2,043,930) (2,105,248) (2,168,405) (2,233,457) - - - - - - - 27,008,324$ 27,818,574$ 28,653,131$ 29,512,725$ 30,398,107$ 31,310,050$ 32,249,351$ 2,467,819,452$ 2,492,497,647$ 2,517,422,623$ 2,542,596,849$ 2,568,022,818$ 2,593,703,046$ 2,619,640,077$ 456,547 461,112 465,723 470,380 475,084 479,835 484,633 DRAFT 13 2021 2022 2023 2024 2025 Actual Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Tax Rates General 45.53%42.72%46.87%50.49%51.77% Capital levies 2.84%3.46%4.35%5.24%6.12% Scheduled debt levies 0.00%0.00%0.00%0.00%0.00% Total City Levy Tax Rate 48.370%46.188%51.216%55.735%57.898% Total EDA Tax Rate 1.142%1.053%1.047%1.041%1.036% Population 24,833 24,833 24,955 25,077 25,200 Taxes per Capita 529$ 557$ 620$ 681$ 720$ Tax Levy ($) General 12,084,489$ 12,508,518$ 13,874,048$ 15,180,999$ 15,940,049$ Capital 753,098 1,014,136 1,286,507 1,576,221 1,885,551 Economic Development Authority 301,471 310,000 316,200 322,524 328,974 Debt service - - - - - Tax Levy (%) General 91.97%90.43%89.64%88.88%87.80% Capital 5.73%7.33%8.31%9.23%10.39% Economic Development Authority 2.29%2.24%2.04%1.89%1.81% Debt Service 0.00%0.00%0.00%0.00%0.00% For the Years Ended December 31, 2021 (Actual) and 2022 to 2032 (Estimated) City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates (Continued) DRAFT 14 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts 52.50%53.81%55.14%56.49%57.85%59.24%60.64% 6.93%7.81%8.69%9.59%10.49%11.40%12.32% 0.00%0.00%0.00%0.00%0.00%0.00%0.00% 59.428%61.619%63.835%66.077%68.345%70.640%72.964% 1.019%1.013%1.008%1.002%0.996%0.990%0.984% 25,323 25,448 25,572 25,698 25,824 25,950 26,078 761$ 804$ 849$ 896$ 945$ 996$ 1,049$ 16,737,051$ 17,573,904$ 18,452,599$ 19,375,229$ 20,343,991$ 21,361,190$ 22,429,250$ 2,208,681 2,549,768 2,909,721 3,289,497 3,690,100 4,112,584 4,558,056 335,554 342,265 349,110 356,093 363,214 370,479 377,888 - - - - - - - 86.80%85.87%84.99%84.16%83.39%82.65%81.96% 11.46%12.46%13.40%14.29%15.13%15.91%16.66% 1.74%1.67%1.61%1.55%1.49%1.43%1.38% 0.00%0.00%0.00%0.00%0.00%0.00%0.00%DRAFT 15 NOTE: 1% additional levy to street fund 2021 2022 2023 2024 Actual Estimated Proposed Proposed Amounts Amounts Amounts Amounts Government-Type General Operations 101 General 9,842,790$ 9,842,790$ 9,842,790$ 9,842,790$ Special Revenue 220 Economic Development Authority 2,053,388 1,986,998 1,949,029 1,901,214 *206-210 TIF Districts Special Revenue 814,716 822,863 831,092 839,403 *240-245 Special Projects 193,060 193,061 193,062 193,063 Subtotal 3,061,164 3,002,922 2,973,183 2,933,680 Debt Service 330-337 Debt Service 4,332,003 4,198,820 3,608,267 3,180,356 Capital Projects 415 Street Reconstruction 6,937,822 985,396 669,818 3,777,880 235 Police Equipment Revolving 2,822,034 2,700,723 1,397,211 1,311,577 420 Park Improvement 1,253,593 937,592 400,011 385,749 *404 Cable TV Equipment 271,449 274,164 276,905 279,674 Subtotal 11,284,898 4,897,875 2,743,946 5,754,880 Total - Governmental-type Funds 28,520,855 21,942,407 19,168,186 21,711,706 Internal Service 620 Information Technology 241,663 504,407 488,930 473,293 625 Building 2,742,830 6,619,121 4,298,640 1,412,032 615 Fleet 2,492,013 2,117,610 1,622,666 1,607,784 *605 Self Insurance 522,235 527,458 532,732 538,060 Total - Internal Service-type Funds 5,998,741 9,768,596 6,942,968 4,031,167 Business-Type Enterprise Funds 505 Water 2,724,849 2,779,526 2,012,132 1,451,111 510 Sewer 994,248 943,530 693,142 497,254 515 Storm Drainage 2,468,500 2,884,890 3,000,889 3,351,457 520 Street Lights 839,166 871,658 907,203 938,253 *525 Recycling 143,548 144,984 146,433 147,898 Total - Business-type Funds 7,170,311 7,624,588 6,759,799 6,385,974 Agency Fund *250 Hennepin Recycling Group 359,660 363,257 366,889 370,558 Grand Total - City 42,049,567$ 39,698,848$ 33,237,842$ 32,499,405$ *Annual growth in fund balance of 1% assumed Trend indicator Adequate for reserve levels Adequate as of 2020 but decreasing balance, 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, 2021 (Actual) and 2022 to 2032 (Estimated) DRAFT 16 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Trend 9,842,790$ 9,842,790$ 9,842,790$ 9,842,790$ 9,842,790$ 9,842,790$ 9,842,790$ 9,842,790$ 1,848,739 1,791,401 1,728,987 1,661,278 1,588,046 1,509,056 1,366,155 1,274,910 847,797 856,275 864,837 873,486 882,221 891,043 899,953 908,953 193,064 193,065 193,066 193,067 193,068 193,069 193,070 193,071 2,889,600 2,840,741 2,786,890 2,727,831 2,663,335 2,593,169 2,459,179 2,376,934 2,791,451 2,366,155 1,983,714 1,553,244 1,121,424 908,269 515,117 281,016 3,274,447 8,277,446 6,900,919 7,480,501 8,185,664 8,921,073 10,344,970 12,465,930 1,492,440 1,379,533 1,457,987 1,301,785 1,201,652 1,312,741 1,823,514 2,278,247 1,036,107 291,210 46,018 464,894 67,958 392,052 79,388 98,597 282,471 285,296 288,149 291,030 293,940 296,880 299,849 302,847 6,085,465 10,233,486 8,693,073 9,538,210 9,749,213 10,922,746 12,547,720 15,145,622 21,609,306 25,283,171 23,306,468 23,662,075 23,376,763 24,266,974 25,364,806 27,646,362 460,956 447,178 431,822 415,619 399,568 384,307 331,702 334,414 485,378 437,426 52,114 296,218 722,187 (12,009) 971,186 1,500,103 1,309,374 1,049,961 271,886 430,165 523,451 439,188 650,477 1,324,055 543,440 548,875 554,363 559,907 565,506 571,161 576,873 582,641 2,799,149 2,483,440 1,310,186 1,701,910 2,210,712 1,382,648 2,530,238 3,741,213 1,048,651 761,438 445,161 219,764 178,115 290,053 1,110,371 2,628,724 72,450 (39,212) (707,290) (1,095,528) (1,209,509) (1,504,948) (1,832,426) (1,533,901) 3,888,624 3,881,990 3,783,462 4,322,325 3,012,461 2,211,957 1,264,752 2,144,875 964,401 985,216 500,242 503,994 500,910 490,446 497,029 465,298 149,377 150,871 152,379 153,903 155,442 156,996 158,566 160,152 6,123,502 5,740,303 4,173,954 4,104,457 2,637,419 1,644,505 1,198,291 3,865,148 374,264 378,006 381,786 385,604 389,460 393,355 397,288 401,261 30,906,220$ 33,884,921$ 29,172,394$ 29,854,047$ 28,614,354$ 27,687,482$ 29,490,624$ 35,653,985$ DRAFT 17 2020 2021 2022 2023 Original Issue Maturity Interest Actual Actual Estimated Estimated Fund Issue Issue Date Date Rate Balance Balance Balance Balance Government-Type General Obligation Bonds 330 2009A Special Assessment 3,360,000$ 7/21/2009 2/1/2030 2.00 - 4.50 %485,000$ 320,000$ 160,000$ -$ 332 2011A Special Assessment 1,705,000 7/19/2011 2/1/2027 0.50 - 3.55 685,000 575,000 470,000 370,000 333 2012A Special Assessment 2,635,000 7/16/2013 2/1/2028 0.50 - 3.55 1,250,000 1,080,000 915,000 750,000 334 2013A Special Assessment 3,235,000 6/17/2015 2/1/2029 0.50 - 3.55 1,825,000 1,605,000 1,390,000 1,180,000 335 2015A Special Assessment 2,550,000 7/16/2015 2/1/2031 2.50 - 3.00 1,755,000 1,575,000 1,400,000 1,230,000 336 2016A Special Assessment 3,330,000 8/25/2016 2/1/2032 2.00 - 2.50 2,550,000 2,310,000 2,075,000 1,845,000 337 2017A Special Assessment 4,665,000 9/14/2017 2/1/2033 2.00 - 3.00 3,920,000 3,595,000 3,280,000 2,965,000 Total G.O. Tax Bonds 29,360,000 12,470,000 11,060,000 9,690,000 8,340,000 Total Government-Type 29,360,000$ 12,470,000$ 11,060,000$ 9,690,000$ 8,340,000$ Population 24,712 24,833 24,955 25,077 Debt Per Capita - Total 505$ 445$ 388$ 333$ City of Crystal, Minnesota Outstanding Debt Schedule For the Years Ended December 31, 2020 (Actual) and 2021 to 2032 (Estimated) DRAFT 18 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Balance Balance Balance Balance Balance Balance Balance Balance Balance -$ -$ -$ -$ -$ -$ -$ -$ -$ 270,000 175,000 85,000 - - - - - - 590,000 435,000 285,000 140,000 - - - - - 975,000 770,000 570,000 375,000 185,000 - - - - 1,065,000 900,000 740,000 585,000 435,000 285,000 140,000 - - 1,620,000 1,400,000 1,185,000 975,000 770,000 570,000 375,000 185,000 - 2,655,000 2,345,000 2,040,000 1,740,000 1,440,000 1,145,000 855,000 565,000 275,000 7,175,000 6,025,000 4,905,000 3,815,000 2,830,000 2,000,000 1,370,000 750,000 275,000 7,175,000$ 6,025,000$ 4,905,000$ 3,815,000$ 2,830,000$ 2,000,000$ 1,370,000$ 750,000$ 275,000$ 25,200 25,323 25,448 25,572 25,698 25,824 25,950 26,078 26,206 285$ 238$ 193$ 149$ 110$ 77$ 53$ 29$ 10$ DRAFT 19 2021 2022 2023 Business Unit Year to Actual Proposed Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Public works 0415.6305 TBA 2022 In house mill and overlay 57,881 - 57,881 - Public works 0415.6305 TBA 2022 Sidewalk shaving (trip hazard removal)20,000 - 20,000 - Public works 0415.6305 TBA 2022 Misc concrete work 60,100 - 60,100 - Public works 0415.6305 TBA 2022 Contract mill and overlay 846,000 - 846,000 - Public works 0415.6305 TBA 2022 ADA Ped Ramp replacements 43,709 - 43,709 - Public works 0415.6305 TBA 2022 Utility Reconstruction 550,000 - 550,000 - Public works 0415.6305 TBA 2023 In house mill and overlay 60,775 - - 60,775 Public works 0415.6305 TBA 2023 Sidewalk shaving (trip hazard removal)20,000 - - 20,000 Public works 0415.6305 TBA 2023 Misc concrete work 61,903 - - 61,903 Public works 0415.6305 TBA 2023 Contract mill and overlay 882,000 - - 882,000 Public works 0415.6305 TBA 2023 ADA Ped Ramp replacements 45,020 - - 45,020 Public works 0415.6305 TBA 2023 Utility Reconstruction 300,000 - - 300,000 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 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2024 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2025 36th Ave Recon & Regent mini-RB 750,000 - - - 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 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2025 Contract mill and overlay 882,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 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 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2026 Contract mill and overlay 882,000 - - - Public works 0415.6305 TBA 2026 Retaining wall replacement 4009 Douglas Dr N 200,000 - - - Public works 0415.6306 TBA 2027 42nd Street Reconstruction 2,000,000 - - - Public works 0415.6305 TBA 2027 Utility Reconstruction 300,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 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2027 Contract mill and overlay 882,000 - - - City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2020 to 2032 DRAFT 20 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,120,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 300,000 - - - - - - - - - 750,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 300,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 200,000 - - - - - - - - - 2,000,000 - - - - - - - - 300,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - DRAFT 21 2021 2022 2023 Business Unit Year to Actual Proposed Estimated Department Object Code Subledger Replace Item Cost Amounts 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 2028 Utility Reconstruction 300,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 2029 Utility Reconstruction 300,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 2030 Utility Reconstruction 300,000 - - - Public works 0415.6305 TBA 2031 In house mill and overlay 60,775 - - - Public works 0415.6305 TBA 2031 Sidewalk shaving (trip hazard removal)20,000 - - - Public works 0415.6305 TBA 2031 Misc concrete work 61,903 - - - Public works 0415.6305 TBA 2031 Crack sealing 10,000 - - - Public works 0415.6305 TBA 2031 ADA Ped Ramp replacements 45,020 - - - Public works 0415.6305 TBA 2031 Contract mill and overlay 1,230,000 - - - Public works 0415.6305 TBA 2031 Utility Reconstruction 300,000 - - - -$ 1,577,690$ 1,369,699$ City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2020 to 2032 (Continued) DRAFT 22 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ 60,775$ -$ -$ -$ -$ - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 1,230,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 1,230,000 - - - - - - - - 300,000 - 1,607,699$ 2,119,699$ 1,569,699$ 3,369,699$ 1,379,699$ 1,379,699$ 1,727,699$ 1,727,699$ -$ DRAFT 23 NOTE: 1% additional levy to street fund 2021 2022 2023 Actual Proposed Estimated Revenues Property taxes (1% overall levy increase, annually, beginning in 2022) *114,550$ 245,940$ 384,267$ Special assessments 507,307 230,000 230,000 Interest on investments 75,000 75,000 9,854 Franchise fees - - - Miscellaneous 133,733 - - Total Revenues 830,589 550,940 624,121 Expenditures Capital outlay Public works 1,946,448 1,577,690 1,369,699 Total Expenditures 1,946,448 1,577,690 1,369,699 Excess (Deficiency) of Revenues Over (Under) Expenditures (1,115,859) (1,026,750) (745,578) Other Financing Sources Transfers in 40,828 - - Intergovernmental revenue (Municipal State Aid - MSA)919,356 230,000 230,000 Internal loan to Building (5,000,000) 200,000 Bond proceeds - - - Sale of Fixed Asset - - - Total Other Financing Sources 960,184 (4,770,000) 430,000 Net Change in Fund Balances (155,675) (5,796,750) (315,578) Cash Balance, January 1 6,937,822 6,782,146 985,396 Cash Balances, December 31 6,782,146$ 985,396$ 669,818$ Capital Project Fund Projected Activity Capital Project Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Projected Revenue, Expenditures and Debt DRAFT 24 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 529,062$ 681,987$ 843,454$ 1,013,897$ 1,193,772$ 1,383,556$ 1,583,751$ 1,794,885$ 2,017,511$ 150,000 166,500 166,500 166,500 166,500 166,500 167,500 167,500 6,698 37,779 32,744 82,774 69,009 74,805 81,857 89,211 103,450 - - - - - - - - - - - - - - - - - 685,760 886,265 1,042,698 1,263,172 1,429,281 1,624,861 1,833,108 2,051,596 2,120,960 1,607,699 2,119,699 1,569,699 3,369,699 1,379,699 1,379,699 1,727,699 1,727,699 - 1,607,699 2,119,699 1,569,699 3,369,699 1,379,699 1,379,699 1,727,699 1,727,699 - (921,939) (1,233,433) (527,000) (2,106,527) 49,582 245,162 105,409 323,897 2,120,960 - - - - - - - - 3,330,000 230,000 4,230,000 230,000 230,000 230,000 230,000 230,000 700,000 500,000 1,300,000 500,000 300,000 230,000 400,000 870,000 - - - - - - - - - - - - - - - - - 4,030,000 730,000 5,530,000 730,000 530,000 460,000 630,000 1,100,000 - 3,108,061 (503,433) 5,003,000 (1,376,527) 579,582 705,162 735,409 1,423,897 2,120,960 669,818 3,777,880 3,274,447 8,277,446 6,900,919 7,480,501 8,185,664 8,921,073 10,344,970 3,777,880$ 3,274,447$ 8,277,446$ 6,900,919$ 7,480,501$ 8,185,664$ 8,921,073$ 10,344,970$ 12,465,930$ Capital Project Fund Projected Activity DRAFT 25 2021 2022 2023 Business Unit Year to Actual Proposed Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Police 3500.6930 N/A 2022 Lease Vehicle (4) and Equipment 139,308 - 139,308 - Police 3500.6930 N/A 2022 Mobile data tablets ($5,000 each)20,000 - 20,000 - Police 3500.6930 N/A 2022 Bulletproof vests - mass replacement ($1,000 a piece)6,000 - 6,000 - Police 3500.6930 N/A 2022 Tactical vests ($3,600 each)7,200 - 7,200 - Police 3500.6930 N/A 2022 Upgrade FATS 30,000 - 30,000 - Police 3500.6930 N/A 2022 Upgrade Cellbrite 15,000 - 15,000 - Police 3500.6930 N/A 2022 Ballistic windows 100,000 - 100,000 - Police 3500.6930 N/A 2023 Ballistic windows 129,000 - - 129,000 Police 3500.6930 N/A 2023 Lease Vehicle (3) and Equipment 175,740 - - 175,740 Police 3500.6930 N/A 2023 Bulletproof vests - mass replacement ($1,000 a piece)4,000 - - 4,000 Police 3500.6930 N/A 2023 Mobile data tablets ($5,000 each)10,000 - - 10,000 Police 3500.6930 N/A 2023 Body cameras 24,000 - - 24,000 Police 3500.6930 N/A 2023 Tactical vests ($3,600 each)7,200 - - 7,200 Police 3500.693 N/A 2024 SWAT Robot 15,000 - - - Police 3500.6930 N/A 2024 Body cameras 24,000 - - - Police 3500.6930 N/A 2024 Lease Vehicle (5) and Equipment 241,116 - - - City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 26 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 15,000 - - - - - - - - 24,000 - - - - - - - - 241,116 - - - - - - - - DRAFT 27 2021 2022 2023 Year to Year to Actual Proposed Estimated Department Replace Subledger Replace Item Cost Amounts Amounts Amounts Police 3500.6930 N/A 2024 Mobile data tablets ($5,000 each)15,000$ -$ -$ -$ Police 3500.6930 N/A 2025 Body cameras 30,000 - - - Police 3500.6930 N/A 2024 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2025 Lease Vehicle (1) and Equipment 241,116 - - - 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 Lease Vehicle (10) and Equipment 241,116 - - - 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 Body cameras 24,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 Lease Vehicle (4) and Equipment 241,116 - - - Police 3500.6930 N/A 2027 Body cameras 24,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 Tactical vests ($3,600 each)7,200 - - - Police 3500.6930 N/A 2027 SWAT Gas Launcher 6,000 - - - Police 3500.6930 N/A 2028 Lease Vehicle (3) and Equipment 241,116 - - - Police 3500.6930 N/A 2028 Mobile radios ($5,000 each)75,000 - - - Police 3500.6930 N/A 2028 Body cameras 24,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 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 Body cameras 24,000 - - - Police 3500.6930 N/A 2029 Lease Vehicle (5) and Equipment 241,116 - - - Police 3500.6930 N/A 2029 Mobile data tablets ($5,000 each)20,000 - - - Police 3500.6930 N/A 2029 Handgun Replacement 55,000 - - - Police 3500.6930 N/A 2029 Rifle replacement /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 Body cameras 24,000 - - - Police 3500.6930 N/A 2030 Estimate based on average 310,795 - - - -$ 317,508$ 349,940$ City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2020 to 2032 (Continued) DRAFT 28 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 15,000$ -$ -$ -$ -$ -$ -$ -$ -$ - 30,000 - - - - - - - 7,200 - - - - - - - - - 241,116 - - - - - - - - 20,000 - - - - - - - - 7,200 - - - - - - - - - 241,116 - - - - - - - - 150,000 - - - - - - - - 15,000 - - - - - - - - 24,000 - - - - - - - - 7,200 - - - - - - - - 35,000 - - - - - - - - - 241,116 - - - - - - - - 24,000 - - - - - - - - 5,000 - - - - - - - - 10,000 - - - - - - - - 7,200 - - - - - - - - 6,000 - - - - - - - - - 241,116 - - - - - - - - 75,000 - - - - - - - - 24,000 - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 150,000 - - - - - - - - 7,200 - - - - - - - - - 24,000 - - - - - - - - 241,116 - - - - - - - - 20,000 - - - - - - - - 55,000 - - - - - - - - 30,000 - - - - - - - - 7,200 - - - - - - - - 6,000 - - - - - - - - - 24,000 - - - - - - - - 310,795 - - 302,316$ 298,316$ 472,316$ 293,316$ 527,316$ 383,316$ 334,795$ -$ -$ DRAFT 29 2021 2022 2023 Actual Proposed Estimated Revenues Property taxes 158,037$ 161,197$ 164,421$ Additional levy to balance - - 10,000 Interest on investments (13,773) 20,000 27,007 Miscellaneous 3,057 - - Total Revenues 147,321 181,197 201,428 Expenditures Capital outlay Public safety 112,368 317,508 349,940 Total Expenditures 112,368 317,508 349,940 Excess (Deficiency) of Revenues Over (Under) Expenditures 34,953 (136,311) (148,512) Other Financing Sources Transfer in - - - Bond proceeds - - - Internal Loan to Building Fund - - (1,170,000) Sale of Fixed Asset 8,428 15,000 15,000 Transfers out - - - Total Other Financing Sources 8,428 15,000 (1,155,000) Net Change in Fund Balances 43,381 (121,311) (1,303,512) Unrestricted Cash Balance (159,626) (114,867) (238,178) Assigned Cash Balance 2,938,279 2,936,902 2,938,902 Cash Balance, January 1 2,778,653 2,822,034 2,700,723 Unrestricted Cash Balance (114,867) (238,178) (1,544,391) Assigned Cash Balance 2,936,902 2,938,902 2,941,602 Cash Balances, December 31 2,822,034$ 2,700,723$ 1,397,211$ Capital Project Fund Projected Activity Capital Project Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Projected Revenue, Expenditures and Debt DRAFT 30 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 167,709$ 171,064$ 174,485$ 177,975$ 181,534$ 185,165$ 188,868$ 192,645$ 196,498$ 20,000 30,000 40,000 50,000 60,000 70,000 80,000 90,000 13,972 13,116 14,924 13,795 14,580 13,018 12,017 13,127 18,235 - - - - - - - - 201,681 214,179 229,409 241,770 256,114 268,183 280,884 295,773 214,733 302,316 298,316 472,316 293,316 527,316 383,316 334,795 - 302,316 298,316 472,316 293,316 527,316 383,316 334,795 - - (100,635) (84,137) (242,907) (51,546) (271,202) (115,133) (53,911) 295,773 214,733 - - - - - - - - - - - - - - - - - 250,000 115,000 115,000 100,000 - 150,000 200,000 240,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 - - - - - - - - 15,000 265,000 130,000 130,000 115,000 15,000 165,000 215,000 240,000 (85,635) 180,863 (112,907) 78,454 (156,202) (100,133) 111,089 510,773 454,733 (1,544,391) (1,631,423) (1,451,871) (1,566,270) (1,489,196) (1,646,856) (1,748,291) (1,638,404) (1,128,944) 2,941,602 2,943,000 2,944,311 2,945,804 2,947,183 2,948,641 2,949,943 2,951,145 2,952,457 1,397,211 1,311,577 1,492,440 1,379,533 1,457,987 1,301,785 1,201,652 1,312,741 1,823,514 (1,631,423) (1,451,871) (1,566,270) (1,489,196) (1,646,856) (1,748,291) (1,638,404) (1,128,944) (676,034) 2,943,000 2,944,311 2,945,804 2,947,183 2,948,641 2,949,943 2,951,145 2,952,457 2,954,281 1,311,577$ 1,492,440$ 1,379,533$ 1,457,987$ 1,301,785$ 1,201,652$ 1,312,741$ 1,823,514$ 2,278,247$ Capital Project Fund Projected Activity DRAFT 31 2021 2022 2023 Business Year to Actual Proposed Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Recreation 0420.6937 TBA 2022 New Park Name Signage 10,000 - 10,000 - Recreation 0420.6937 TBA 2022 ALL Pavement (Sidewalks @ Trails)100,000 - 100,000 - Recreation 0420.6937 TBA 2022 Dog Park and Parking - Basset Creek 400,000 - 400,000 - Recreation 0420.6937 TBA 2022 Soccer Field - Fair School Park 50,000 - 50,000 - Recreation 0420.6937 TBA 2022 Becker Tennis Court Lights/Surfacing 200,000 - 200,000 - Recreation 0420.6937 TBA 2022 Ped Bridge - Bassett Creek 200,000 - 200,000 - Recreation 0420.6937 TBA 2023 Large Play Area - Welcome (1997)350,000 - - 350,000 Recreation 0420.6937 TBA 2023 New Park Name Signage 12,000 - - 12,000 Recreation 0420.6937 TBA 2023 ALL Pavement (Sidewalks @ Trails)150,000 - - 150,000 Recreation 0420.6938 TBA 2023 Garbage Can Pads - Becker Park 25,000 - - 25,000 Recreation 0420.6938 TBA 2023 Court Lighting - Becker Park 75,000 - - 75,000 Recreation 0420.6937 TBA 2023 NP Basketball Court - Broadway 15,000 - - 15,000 Recreation 0420.6937 TBA 2023 BP Basketball Court - Crystal Highlands 15,000 - - 15,000 Recreation 0420.6937 TBA 2023 Picnic Shelter - Broadway 80,000 - - 80,000 Recreation 0420.6937 TBA 2023 Play Area - Broadway (1999)185,000 - - 185,000 Recreation 0420.6937 TBA 2023 Picnic Shelter - Crystal Highlands 80,000 - - 80,000 Recreation 0420.6937 TBA 2023 Disc Golf Course - Bassett Creek Park 150,000 - - 150,000 Recreation 0420.6938 TBA 2023 Fitness Equipment - Welcome 150,000 - - 150,000 Recreation 0420.6939 TBA 2023 Basketball court - Welcome 25,000 - - 25,000 Recreation 0420.6937 TBA 2024 Valley Place Tennis Court Lights/Surfacing 400,000 - - - Recreation 0420.6938 TBA 2024 Basketball - Valley Place Park 50,000 - - - Recreation 0420.6937 TBA 2024 ALL Pavement (Sidewalks @ Trails)60,000 - - - Recreation 0420.6937 TBA 2024 New Park Name Signage 15,000 - - - Recreation 0420.6937 TBA 2024 Parking Lot - Valley Place Park (Near Play Area)400,000 - - - Recreation 0420.6937 TBA 2025 Basketball Court - Cavanagh 15,000 - - - Recreation 0420.6938 TBA 2025 New Park Signage 15,000 - - - Recreation 0420.6937 TBA 2025 ALL Pavement (Sidewalks @ Trails)75,000 - - - Recreation 0420.6937 TBA 2025 Picnic Shelter - Cavanagh 85,000 - - - Recreation 0420.6937 TBA 2025 Maintenance Binder - Play Area PIP Surfacing - Becker & Fair 35,000 - - - Recreation 0420.6937 TBA 2025 Play Area - Cavanaugh (2001)185,000 - - - Recreation 0420.6937 TBA 2026 ALL Pavement (Sidewalks @ Trails)125,000 - - - Recreation 0420.6937 TBA 2026 Basketball - Bassett Creek Park 25,000 - - - Recreation 0420.6937 TBA 2026 Sm. Picnic Shelter - Twin Oak 85,000 - - - Recreation 0420.6937 TBA 2026 Community Park Building - Bassett Creek 1,500,000 - - - Recreation 0420.6937 TBA 2026 Fiber & Technology at Basset Creek Park Building 50,000 - - - Recreation 0420.6937 TBA 2026 Play Area - Twin Oak (2003)185,000 - - - Recreation 0420.6937 TBA 2027 Soccer Field - Bassett Creek 550,000 - - - Recreation 0420.6937 TBA 2027 Parking Lot at Basset Creek Building 550,000 - - - Recreation 0420.6937 TBA 2027 Play Area - Sunnyview (2000)185,000 - - - Recreation 0420.6937 TBA 2027 Play Area - Lee (2000)185,000 - - - Recreation 0420.6937 TBA 2027 Picnic Shelter - Lee 85,000 - - - Recreation 0420.6937 TBA 2027 ALL Pavement (Sidewalks @ Trails)75,000 - - - Recreation 0420.6937 TBA 2028 Large Play Area - North Lions (2006)375,000 - - - Recreation 0420.6937 TBA 2028 Play Area - Iron Horse (2004)185,000 - - - Recreation 0420.6937 TBA 2028 ALL Pavement (Sidewalks @ Trails)75,000 - - - Recreation 0420.6937 TBA 2028 Med. Shelter - Bassett Creek (pond)160,000 - - - Recreation 0420.6937 TBA 2028 Med. Shelter - North Lions 160,000 - - - Recreation 0420.6937 TBA 2028 Volleyball - bassett Creek 25,000 - - - Recreation 0420.6937 TBA 2028 Medium Shelter - Bassett Creek (woods)160,000 - - - Recreation 0420.6937 TBA 2029 Med. Shelter - Valley Place 175,000 - - - Recreation 0420.6937 TBA 2029 ALL Pavement (Sidewalks @ Trails)75,000 - - - City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 32 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 400,000 - - - - - - - - 50,000 - - - - - - - - 60,000 - - - - - - - - 15,000 - - - - - - - - 400,000 - - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 75,000 - - - - - - - - 85,000 - - - - - - - - 35,000 - - - - - - - - 185,000 - - - - - - - - - 125,000 - - - - - - - - 25,000 - - - - - - - - 85,000 - - - - - - - - 1,500,000 - - - - - - - - 50,000 - - - - - - - - 185,000 - - - - - - - - - 550,000 - - - - - - - - 550,000 - - - - - - - - 185,000 - - - - - - - - 185,000 - - - - - - - - 85,000 - - - - - - - - 75,000 - - - - - - - - - 375,000 - - - - - - - - 185,000 - - - - - - - - 75,000 - - - - - - - - 160,000 - - - - - - - - 160,000 - - - - - - - - 25,000 - - - - - - - - 160,000 - - - - - - - - - 175,000 - - - - - - - - 75,000 - - - DRAFT 33 2021 2022 2023 Actual Proposed Estimated Cost Amounts Amounts Amounts Recreation 0420.6937 TBA 2029 Park Building - Welcome 1,500,000 - - - Recreation 0420.6937 TBA 2029 Med. Shelter - Welcome 160,000 - - - Recreation 0420.6937 TBA 2029 Fiber & Technology at Welcome Park Building 50,000 - - - Recreation 0420.6937 TBA 2030 ALL Pavement (Sidewalks @ Trails)100,000$ -$ -$ -$ Recreation 0420.6937 TBA 2030 Replace Play Area PIP Surfacing - Becker 125,000 - - - Recreation 0420.6937 TBA 2030 Replace Play Area Structure Sun Sails - Becker 15,000 - - - Recreation 0420.6937 TBA 2030 Replace Patio Sun Sails - Becker 25,000 - - - Recreation 0420.6937 TBA 2030 Replace Play Area PIP Surfacing - FAIR School 50,000 - - - Recreation 0420.6937 TBA 2030 Parking Lot at Welcome Park Building 350,000 - - - Recreation 0420.6938 TBA 2030 Field #2 Infield - Welcome Park 35,000 - - - Recreation 0420.6937 TBA 2030 Play Area - Bass Lake (2004)185,000 - - - Recreation 0420.6937 TBA 2030 Soccer Field at Welcome Park 350,000 - - - Recreation 0420.6937 TBA 2031 ALL Pavement (Sidewalks @ Trails)25,000 - - - Recreation 0420.6937 TBA 2031 Picnic Shelter - Forest School Park 80,000 - - - Recreation 0420.6937 TBA 2031 Play Area - Forest (2005)185,000 - - - Recreation 0420.6937 TBA 2031 Replace Play Area PIP Surfacing - Valley Place & Yunkers 35,000 - - - Recreation 0420.6937 TBA 2031 Fiber & Technology at North Lions Building 50,000 - - - Recreation 0420.6937 TBA 2031 Park Building - North Lions 1,500,000 - - - Recreation 0420.6937 TBA 2032 ALL Pavement (Sidewalks @ Trails)75,000 - - - Recreation 0420.6937 TBA 2032 Play Area - Grogan Park (2008)185,000 - - - Recreation 0420.6937 TBA 2032 Medium Shelter - North Lions (picnic area)190,000 - - - Recreation 0420.6937 TBA 2032 CP Soccer Field - North Lions 530,000 - - - Recreation 0420.6937 TBA 2032 Basketball Court - North Lions 25,000 - - - Recreation 0420.6937 TBA 2032 Parking Lot at North Lions Park Building 350,000 - - - Recreation 0420.6937 TBA 2032 Play Area - Crystal Highlands (2007)185,000 - - - Recreation 0420.6937 TBA 2033 ALL Pavement (Sidewalks @ Trails)75,000 - - - Recreation 0420.6937 TBA 2033 Play Area - Skyway Park (2008)185,000 - - - Recreation 0420.6937 TBA 2033 Play Area - Kentucky Park (2010)185,000 - - - Recreation 0420.6937 TBA 2033 Picnic Shelter - Skyway Park 80,000 - - - Recreation 0420.6937 TBA 2034 ALL Pavement (Sidewalks @ Trails)75,000 - - - Recreation 0420.6937 TBA 2034 Hockey Rinks - Valley Place Park 500,000 - - - Recreation 0420.6937 TBA 2034 Med. Shelter - Becker 200,000 - - - Recreation 0420.6937 TBA 2034 Building - Becker 1,650,000 - - - Recreation 0420.6937 TBA 2034 Fiber and Technology at Becker 50,000 - - - Recreation 0420.6937 TBA 2035 Large Play Area - Basset Creek Park 400,000 - - - Recreation 0420.6937 TBA 2035 Baseball Lights - Basset Creek Park 300,000 - - - Recreation 0420.6937 TBA 2035 Softball Field - Valley Place Park 550,000 - - - Recreation 0420.6937 TBA 2036 Fiber & Technology at Valley Place 50,000 - - - Recreation 0420.6937 TBA 2036 Park Building - Valley Place 1,650,000 - - - Recreation 0420.6937 TBA 2037 Parks replacements 1,500,000 - - - Recreation 0420.6937 TBA 2038 Parks replacements 1,500,000 - - - Recreation 0420.6937 TBA 2039 Parks replacements 1,500,000 - - - -$ 960,000$ 1,312,000$ City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Planned Capital Outlay 2020 to 2032 DRAFT 34 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - 1,500,000 - - - - - - - - 160,000 - - - - - - - - 50,000 - - - -$ -$ -$ -$ -$ -$ 100,000$ -$ - - - - - - - 125,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 350,000 - - - - - - - - 35,000 - - - - - - - - 185,000 - - - - - - - - 350,000 - - - - - - - - - 25,000 - - - - - - - - 80,000 - - - - - - - - 185,000 - - - - - - - - 35,000 - - - - - - - - 50,000 - - - - - - - - 1,500,000 - - - - - - - - - 75,000 - - - - - - - - 185,000 - - - - - - - - 190,000 - - - - - - - - 530,000 - - - - - - - - 25,000 - - - - - - - - 350,000 - - - - - - - - 185,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 925,000$ 410,000$ 1,970,000$ 1,630,000$ 1,140,000$ 1,960,000$ 1,235,000$ 1,875,000$ 1,540,000$ DRAFT 35 2021 2022 2023 Actual Proposed Estimated Revenues Property taxes (1% overall levy increase, annually, 2022-2029)480,724$ 606,999$ 741,043$ Interest on investments (4,881) 13,000 9,376 Intergovernmental revenue 130,000 - - Miscellaneous 2,288 - - Total Revenues 608,131 619,999 750,419 Expenditures Capital outlay Recreation 540,224 960,000 1,312,000 Total Expenditures 540,224 960,000 1,312,000 Excess (Deficiency) of Revenues Over (Under) Expenditures 67,906 (340,001) (561,581) Other Financing Sources (Uses) Transfers in Sale of fixed assets - 24,000 24,000 Transfers out - - - Total Other Financing Sources - 24,000 24,000 Net Change in Fund Balances 67,906 (316,001) (537,581) Cash Balances, January 1 1,185,687 1,253,593 937,592 Cash Balances, December 31 1,253,593$ 937,592$ 400,011$ Capital Project Fund Projected Activity Capital Project Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Projected Revenue, Expenditures and Debt DRAFT 36 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 882,738$ 1,032,500$ 1,190,742$ 1,357,896$ 1,534,415$ 1,534,415$ 1,534,415$ 1,534,415$ 1,534,415$ 4,000 3,857 10,361 2,912 460 4,649 680 3,921 794 - - - - - - - - - - - - - - - - 886,738 1,036,358 1,201,103 1,360,808 1,534,875 1,539,064 1,535,095 1,538,336 1,535,209 925,000 410,000 1,970,000 1,630,000 1,140,000 1,960,000 1,235,000 1,875,000 1,540,000 925,000 410,000 1,970,000 1,630,000 1,140,000 1,960,000 1,235,000 1,875,000 1,540,000 (38,262) 626,358 (768,897) (269,192) 394,875 (420,936) 300,095 (336,664) (4,791) 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 (14,262) 650,358 (744,897) (245,192) 418,875 (396,936) 324,095 (312,664) 19,209 400,011 385,749 1,036,107 291,210 46,018 464,894 67,958 392,052 79,388 385,749$ 1,036,107$ 291,210$ 46,018$ 464,894$ 67,958$ 392,052$ 79,388$ 98,597$ Capital Project Fund Projected Activity DRAFT 37 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Water 0090.6935 TBA 2022 Utility Reconstruction 1,100,000 - 1,100,000 - Water 0090.6935 TBA 2022 6235 -Gate valve and hydrant replacements 75,000 - 75,000 - Water 0090.6935 TBA 2023 6235 -Gate Valve and Hydrant replacement 75,000 - - 75,000 Water 0090.6935 TBA 2023 Utility Reconstruction 1,000,000 - - 1,000,000 Water 0090.6935 TBA 2024 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2024 Utility Reconstruction 1,500,000 - - - Water 0090.6935 TBA 2024 Replace SENSUS Radios 350,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 2025 Replace SENSUS Radios 350,000 - - - Water 0090.6935 TBA 2026 Utility Reconstruction 1,500,000 - - - Water 0090.6935 TBA 2026 Replace SENSUS Radios 350,000 - - - Water 0090.6935 TBA 2026 6235 -Gate Valve and Hydrant replacement 75,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 2027 Replace SENSUS Radios 350,000 - - - Water 0090.6935 TBA 2027 42nd Ave Water Main Replacement 1,700,000 - - - Water 0090.6935 TBA 2028 Utility Reconstruction 1,750,000 - - - Water 0090.6935 TBA 2028 Replace SENSUS Radios 350,000 - - - Water 0090.6935 TBA 2028 6235 -Gate Valve and Hydrant replacement 75,000 - - - Water 0090.6935 TBA 2029 Utility Reconstruction 1,850,000 - - - Water 0090.6935 TBA 2029 Replace SENSUS Radios 350,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 Commercial Meter replacement 200,000 - - - Water 0090.6935 TBA 2031 Utility Reconstruction 1,300,000 - - - Water 0090.6935 TBA 2031 Gate Value and Hydrant Replacement 75,000 - - - Water 0090.6935 TBA 2031 Commercial Meter replacement 200,000 - - - Water 0090.6935 TBA 2032 Utility Reconstruction 1,200,000 - - - Water 0090.6935 TBA 2032 Commercial Meter replacement 200,000 - - - Water 0090.6935 TBA 2032 Gate Value and Hydrant Replacement 75,000 - - - Water 0090.6935 TBA 2033 Commercial Meter replacement 200,000 - - - -$ 1,175,000$ 1,075,000$ City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 38 2024 2025 2026 2027 2028 2029 2030 2031 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 75,000 - - - - - - - 1,500,000 - - - - - - - 350,000 - - - - - - - - 1,500,000 - - - - - - - 30,000 - - - - - - - 350,000 - - - - - - - - 1,500,000 - - - - - - - 350,000 - - - - - - - 75,000 - - - - - - - - 1,600,000 - - - - - - - 30,000 - - - - - - - 350,000 - - - - - - - 1,700,000 - - - - - - - - 1,750,000 - - - - - - - 350,000 - - - - - - - 75,000 - - - - - - - - 1,850,000 - - - - - - - 350,000 - - - - - - - 30,000 - - - - - - - - 2,000,000 - - - - - - - 75,000 - - - - - - - 200,000 - - - - - - - - 1,300,000 - - - - - - - 75,000 - - - - - - - 200,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 1,925,000$ 1,880,000$ 1,925,000$ 3,680,000$ 2,175,000$ 2,230,000$ 2,275,000$ 1,575,000$ DRAFT 39 2021 2022 2023 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from customers and users (based on utility rate analysis)5,646,977$ 5,195,116$ 5,369,944$ Payments to suppliers (based on utility rate analysis)(3,241,780) (3,155,313) (3,232,494) Payments to employees (based on utility rate analysis)(442,627) (418,631) (482,400) Net Cash Provided (Used) by Operating Activities 1,962,570 1,621,172 1,655,050 Cash Flows from Noncapital Financing Activities Transfers to other funds (200,621) (211,367) (231,778) Net Cash Provided (Used) by Noncapital Financing Activities (200,621) (211,367) (231,778) Cash Flows from Capital and Related Financing Activities Infrastructure improvements (377,134) (1,175,000) (1,075,000) Contribution to internal service funds (122,847) (127,928) (180,433) Intergovernmental (Joint Water Commission).- - Interest expense (4,800) (7,200) (3,029) Advance to/(from) building fund (900,000) Advances to/(from) other funds (60,000) (60,000) (60,000) Net Cash Provided (Used) by Capital and Related Financing Activities (564,781) (1,370,128) (2,218,462) Cash Flows from Investing Activities Investment earnings (9,876) 15,000 27,795 Net Increase (Decrease) in Cash and Cash Equivalents 1,187,292 54,677 (767,395) Cash and Cash Equivalents, January 1 1,537,557 2,724,849 2,779,526 Cash and Cash Equivalents, December 31 2,724,849$ 2,779,526$ 2,012,132$ New projected rates Average quarterly bill (9,000 gallons)86.16$ 93.91$ 100.49$ Average quarterly dollar increase 8.54$ 7.75$ 6.57$ Average annual dollar increase 34.15$ 31.02$ 26.30$ Enterprise Fund Projected Activity Enterprise Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Statement of Cash Flows DRAFT 40 2024 2025 2026 2027 2028 2029 2030 2031 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated 5,653,634$ 5,838,893$ 6,030,178$ 6,227,686$ 6,539,070$ 6,866,024$ 7,209,325$ 7,569,791$ (3,329,468) (3,429,352) (3,532,233) (3,638,200) (3,747,346) (3,859,766) (3,975,559) (4,094,826) (506,520) (531,846) (558,438) (586,360) (615,678) (646,462) (678,785) (712,724) 1,817,646 1,877,695 1,939,507 2,003,126 2,176,046 2,359,796 2,554,981 2,762,241 (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (1,925,000) (1,880,000) (1,925,000) (3,680,000) (2,175,000) (2,230,000) (2,275,000) (1,575,000) (178,981) (179,860) (177,399) (162,211) (146,088) (138,835) (135,017) (135,017) - - - 1,500,000 - - - - (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) (3,029) - - 100,000 250,000 150,000 200,000 200,000 - (60,000) - - - - - - - (2,167,010) (2,062,889) (2,005,428) (2,095,240) (2,174,117) (2,171,864) (2,213,046) (1,713,046) 20,121 14,511 10,487 7,614 4,452 2,198 1,781 2,901 (561,021) (402,461) (287,212) (316,277) (225,397) (41,649) 111,938 820,318 2,012,132 1,451,111 1,048,651 761,438 445,161 219,764 178,115 290,053 1,451,111$ 1,048,651$ 761,438$ 445,161$ 219,764$ 178,115$ 290,053$ 1,110,371$ 105.51$ 108.68$ 111.94$ 115.29$ 118.75$ 122.31$ 125.98$ 125.98$ 5.02$ 3.17$ 3.26$ 3.36$ 2.74$ 2.74$ 2.74$ 2.74$ 20.10$ 12.66$ 13.04$ 13.43$ 10.94$ 10.94$ 10.94$ 10.94$ Enterprise Fund Projected Activity DRAFT 41 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Sewer 0092.6935 TBA 2022 Equipment Replacement - South Lift Building/Generator and Pump #2 350,000 - 350,000 - Sewer 0092.6935 TBA 2022 Utility Reconstruction 250,000 - 250,000 - Sewer 0092.6935 TBA 2023 Utility Reconstruction 800,000 - - 800,000 Sewer 0092.6935 TBA 2023 Sanitary Sewer Lining (outside of Recon)100,000 - - 100,000 Sewer 0092.6935 TBA 2024 Utility Reconstruction 800,000 - - - Sewer 0092.6935 TBA 2024 Perry Lift Station Panel Replacement 70,000 - - - Sewer 0092.6935 TBA 2025 Utility Reconstruction 800,000 - - - Sewer 0092.6935 TBA 2025 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2025 East Lift Generator Replacement 200,000 - - - Sewer 0092.6935 TBA 2026 Utility Reconstruction 850,000 - - - Sewer 0092.6935 TBA 2027 Utility Reconstruction 950,000 - - - Sewer 0092.6935 TBA 2027 42nd Ave Sanitary Sewer replacement 500,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 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2030 Utility Reconstruction 1,300,000 - - - Sewer 0092.6935 TBA 2031 Sanitary Sewer Lining (outside of Recon)100,000 - - - Sewer 0092.6935 TBA 2031 Utility Reconstruction 1,300,000 - - - Sewer 0092.6935 TBA 2032 Utility Reconstruction 1,200,000 - - - -$ 600,000$ 900,000$ City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 42 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 800,000 - - - - - - - - 70,000 - - - - - - - - - 800,000 - - - - - - - - 100,000 - - - - - - - - 200,000 - - - - - - - - - 850,000 - - - - - - - - - 950,000 - - - - - - - - 500,000 - - - - - - - - - 1,250,000 - - - - - - - - - 950,000 - - - - - - - - 100,000 - - - - - - - - - 1,300,000 - - - - - - - - - 100,000 - - - - - - - - 1,300,000 - - - - - - - - - 1,200,000 870,000$ 1,100,000$ 850,000$ 1,450,000$ 1,250,000$ 1,050,000$ 1,300,000$ 1,400,000$ 1,200,000$ DRAFT 43 2021 2022 2023 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from customers and users 3,163,780$ 3,251,948$ 3,537,548$ Payments to suppliers (based on utility rate analysis)(2,056,205) (1,917,853) (1,975,389) Payments to employees (based on utility rate analysis)(403,959) (457,649) (480,531) Net Cash Provided (Used) by Operating Activities 703,616 876,446 1,081,628 Cash Flows from Noncapital Financing Activities Transfers to other funds (200,621) (211,367) (231,778) Net Cash Provided (Used) by Noncapital Financing Activities (200,621) (211,367) (231,778) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (547,459) (600,000) (900,000) Contribution to internal service funds (152,151) (163,797) (244,918) Advances to/(from) other funds 30,000 30,000 30,000 Grants and contributions - - - Net Cash Provided (Used) by Capital and Related Financing Activities (669,610) (733,797) (1,114,918) Cash Flows from Investing Activities Investment earnings 421 18,000 14,680 Net Increase (Decrease) in Cash and Cash Equivalents (166,194) (50,718) (250,388) Cash and Cash Equivalents, January 1 1,160,442 994,248 943,530 Cash and Cash Equivalents, December 31 994,248$ 943,530$ 693,142$ Projected rates Average quarterly bill (9,000 gallons)58.31$ 62.97$ 66.75$ Average quarterly dollar increase 5.30$ 4.66$ 3.78$ Average annual dollar increase 21.20$ 18.64$ 15.12$ Enterprise Fund Projected Activity Enterprise Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Statement of Cash Flows DRAFT 44 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 3,643,674$ 3,752,985$ 3,865,574$ 3,981,541$ 4,180,618$ 4,389,649$ 4,609,131$ 4,839,588$ 5,081,567$ (2,034,651) (2,095,690) (2,158,561) (2,223,318) (2,334,484) (2,451,208) (2,573,768) (2,702,457) (2,837,580) (504,558) (529,786) (556,275) (584,089) (613,293) (643,958) (676,156) (709,964) (745,462) 1,104,465 1,127,509 1,150,738 1,174,134 1,232,841 1,294,483 1,359,207 1,427,167 1,498,526 (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) (231,778) - (870,000) (1,100,000) (850,000) (1,450,000) (1,250,000) (1,050,000) (1,300,000) (1,400,000) (1,200,000) (243,255) (235,216) (195,302) (175,114) (153,981) (141,366) (137,548) (137,548) 30,000 - - - - - - - - - - - - - - - - (1,083,255) (1,335,216) (1,045,302) (1,625,114) (1,403,981) (1,191,366) (1,437,548) (1,537,548) (1,200,000) 14,680 14,680 14,680 14,680 14,680 14,680 14,680 14,680 (195,888) (424,805) (111,662) (668,078) (388,238) (113,981) (295,439) (327,479) 298,526 693,142 497,254 72,450 (39,212) (707,290) (1,095,528) (1,209,509) (1,504,948) (1,832,426) 497,254$ 72,450$ (39,212)$ (707,290)$ (1,095,528)$ (1,209,509)$ (1,504,948)$ (1,832,426)$ (1,533,901)$ 69.42$ 71.50$ 73.65$ 75.86$ 78.14$ 80.48$ 82.89$ 82.89$ 2.67$ 2.08$ 2.15$ 2.21$ 2.28$ 2.34$ 2.41$ 2.41$ 10.68$ 8.32$ 8.60$ 8.84$ 9.10$ 9.38$ 9.66$ 9.66$ Enterprise Fund Projected Activity DRAFT 45 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Storm water 0094.6935 TBA 2022 Utility Reconstruction 50,000 - 50,000 - Storm water 0094.6936 TBA 2022 SCWMC 639W Wetland Project (reimbursed by watershed)200,000 - 200,000 - Storm water 0094.6935 TBA 2022 Rate Control, water quality, structure Rehab projects 75,000 - 75,000 - Storm water 0094.6935 TBA 2023 Rate Control, water quality, structure Rehab projects 50,000 - - 50,000 Storm water 0094.6935 TBA 2023 Saving for flood control structure replacement 200,000 - - 200,000 Storm water 0094.6935 TBA 2023 Utility Reconstruction 50,000 - - 50,000 Storm water 0094.6935 TBA 2024 Rate Control, water quality, structure Rehab projects 150,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 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 Stabilization and 29th culvert replacement (3)1,000,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 2026 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2027 Pond dredging - Killmer Pond 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 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2028 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2028 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2029 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2029 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2029 Bass Lake Road storm water pipe 2,000,000 - - - Storm water 0094.6935 TBA 2030 Storm Pipe Rehabilitation 420,000 - - - Storm water 0094.6935 TBA 2030 Utility Reconstruction 50,000 - - - Storm water 0094.6935 TBA 2030 Rate Control, water quality, structure Rehab projects 150,000 - - - Storm water 0094.6935 TBA 2030 Pond dredging - location to be determined 1,000,000 - - - Storm water 0094.6935 TBA 2031 Basset Creek Park Pond Dredging 1,500,000 - - - Storm water 0094.6935 TBA 2031 Saving for flood control structure replacement 200,000 - - - Storm water 0094.6935 TBA 2031 Utility Reconstruction 50,000 - - - -$ 325,000$ 300,000$ City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 46 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 150,000 - - - - - - - - 200,000 - - - - - - - - 50,000 - - - - - - - - - 100,000 - - - - - - - - 200,000 - - - - - - - - 50,000 - - - - - - - - - 1,000,000 - - - - - - - - 200,000 - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - - 750,000 - - - - - - - - 200,000 - - - - - - - - 50,000 - - - - - - - - - 200,000 - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - - 200,000 - - - - - - - - 50,000 - - - - - - - - 2,000,000 - - - - - - - - - 420,000 - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - 1,000,000 - - - - - - - - - 1,500,000 - - - - - - - - 200,000 - - - - - - - - 50,000 - - 400,000$ 350,000$ 1,400,000$ 1,000,000$ 400,000$ 2,250,000$ 1,620,000$ 1,750,000$ -$ DRAFT 47 2021 2022 2023 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from customers and users 1,310,107$ 1,331,152$ 1,391,249$ Payments to suppliers and employees (5% growth assumption)(326,252) (467,595) (490,975) Net Cash Provided (Used) by Operating Activities 983,855 863,557 900,274 Cash Flows from Noncapital Financing Activities Transfers out (53,985) (56,876) (59,720) Net Cash Provided (Used) by Noncapital Financing Activities (53,985) (56,876) (59,720) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (534,913) (325,000) (300,000) Contribution to internal service funds (82,043) (71,292) (153,405) Advance (to) and repayment from building fund (200,000) (300,000) Intergovernmental revenue (Watershed, Met Council, MNDNR and other)- 200,000 - Net Cash Provided (Used) by Capital and Related Financing Activities (616,956) (396,292) (753,405) Cash Flows from Investing Activities Investment earnings 6,000 6,000 28,849 Net Increase (Decrease) in Cash and Cash Equivalents 318,914 416,389 115,999 Cash and Cash Equivalents, January 1 2,149,587 2,468,501 2,884,890 Cash and Cash Equivalents, December 31 2,468,501$ 2,884,890$ 3,000,889$ Projected rates Quarterly bill 21.15$ 22.15$ 23.15$ Annual dollar increase 1.00$ 1.00$ 1.00$ Percent increase 5%5%5% Enterprise Fund Projected Activity Enterprise Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Statement of Cash Flows DRAFT 48 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 1,451,346$ 1,511,443$ 1,541,492$ 1,571,541$ 1,601,589$ 1,631,638$ 1,661,686$ 1,691,735$ 1,721,784$ (515,523) (541,300) (568,365) (596,783) (626,622) (657,953) (690,851) (725,393) (761,663) 935,823 970,144 973,127 974,758 974,967 973,685 970,836 966,342 960,121 (62,706) (65,841) (69,133) (72,590) (76,219) (80,030) (84,032) (88,233) (92,645) (62,706) (65,841) (69,133) (72,590) (76,219) (80,030) (84,032) (88,233) (92,645) (400,000) (350,000) (1,400,000) (1,000,000) (400,000) (2,250,000) (1,620,000) (1,750,000) - (152,557) (150,651) (149,514) (139,516) (97,720) (96,741) (97,433) (97,433) - 100,000 100,000 100,000 100,000 100,000 - - - - - 500,000 - - - - - (552,557) (400,651) (949,514) (1,039,516) (397,720) (2,246,741) (1,717,433) (1,847,433) - 30,009 33,515 38,886 38,820 37,835 43,223 30,125 22,120 12,648 350,569 537,166 (6,633) (98,528) 538,863 (1,309,863) (800,505) (947,205) 880,123 3,000,889 3,351,457 3,888,624 3,881,990 3,783,462 4,322,325 3,012,461 2,211,957 1,264,752 3,351,457$ 3,888,624$ 3,881,990$ 3,783,462$ 4,322,325$ 3,012,461$ 2,211,957$ 1,264,752$ 2,144,875$ 24.15$ 25.15$ 25.65$ 26.15$ 26.65$ 27.15$ 27.65$ 28.15$ 28.65$ 1.00$ 1.00$ 0.50$ 0.50$ 0.50$ 0.50$ 0.50$ 0.50$ 0.50$ 4%4%2%2%2%2%2%2%2% Enterprise Fund Projected Activity DRAFT 49 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Street light 0096.6915 TBA 2022 HPS to LED conversion 25,000 - 25,000 - Street light 0096.6915 TBA 2023 HPS to LED conversion 25,000 - - 25,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 2027 Underground utility poles (42nd)1,000,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 - - - -$ 25,000$ 25,000$ City of Crystal, Minnesota Capital Improvement Plan - Street Light Fund 520 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 50 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - 1,000,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - 25,000$ 25,000$ 25,000$ 1,025,000$ 25,000$ 25,000$ 25,000$ -$ -$ DRAFT 51 Enterprise Fund Projected Activity 2021 2022 2023 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from customers and users (2% growth assumption)194,435$ 194,200$ 198,084$ Payments to suppliers and employees (5% growth assumption)(212,864) (151,764) (159,352) Net Cash Provided (Used) by Operating Activities (18,429) 42,436 38,732 Cash Flows from Noncapital Financing Activities Transfers out (15,251) (16,098) (16,903) Net Cash Provided (Used) by Noncapital Financing Activities (15,251) (16,098) (16,903) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets - (25,000) (25,000) Intergovernmental revenue - - - Advances to/(from) other funds 30,000 30,000 30,000 Net Cash Provided (Used) by Capital and Related Financing Activities 30,000 5,000 5,000 Cash Flows from Investing Activities Investment earnings (1,666) 6,500 8,717 Net Increase (Decrease) in Cash and Cash Equivalents (5,346) 37,838 35,545 Cash and Cash Equivalents, January 1 839,166 833,820 871,658 Cash and Cash Equivalents, December 31 833,820$ 871,658$ 907,203$ Capital Improvement Plan - Street Light Fund 520 Statement of Cash Flows City of Crystal, Minnesota DRAFT 52 Enterprise Fund Projected Activity 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 202,046$ 206,087$ 210,208$ 214,412$ 218,701$ 223,075$ 227,536$ 232,087$ 236,729$ (167,320) (175,686) (184,470) (193,694) (203,378) (213,547) (224,225) (235,436) (247,208) 34,726 30,401 25,738 20,719 15,322 9,528 3,312 (3,349) (10,479) (17,748) (18,635) (19,567) (20,546) (21,573) (22,652) (23,784) (24,973) (26,222) (17,748) (18,635) (19,567) (20,546) (21,573) (22,652) (23,784) (24,973) (26,222) (25,000) (25,000) (25,000) (1,025,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 5,000 5,000 5,000 (495,000) 5,000 5,000 5,000 30,000 - 9,072 9,383 9,644 9,852 5,002 5,040 5,009 4,904 4,970 31,050 26,148 20,815 (484,975) 3,752 (3,084) (10,463) 6,582 (31,731) 907,203 938,253 964,401 985,216 500,242 503,994 500,910 490,446 497,029 938,253$ 964,401$ 985,216$ 500,242$ 503,994$ 500,910$ 490,446$ 497,029$ 465,298$ DRAFT 53 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Object Code Subledger Replace Item Cost Amounts Amounts Amounts Public Works 0615.6930 TBA 2022 Replace #109 - 2003 Int'l 7400 Tandem drup truck (rehabbed in 2019)190,000 - 190,000 - Public Works 0615.6930 TBA 2022 Replace #303-1 - MTV Trackless MT-6 160,000 - 160,000 - Public Works 0615.6930 TBA 2022 Replace #144 - Kubota Zero-Turn Tractor w/Catcher 15,000 - 15,000 - Public Works 0615.6930 TBA 2022 Replace #158 (replace Z turn trailer)15,000 - 15,000 - Public Works 0615.6930 TBA 2022 Replace #309 - 2010 Freightliner TA 270,000 - 270,000 - Public Works 0615.6930 TBA 2022 Replace #307 - 2012 Ram 2500 (new is swap loader)75,000 - 75,000 - Public Works 0615.6930 TBA 2022 Replace #428 - GMC Sierra 3500HD 1 ton dump truck 54,000 - 54,000 - Public Works 0615.6930 TBA 2023 Replace #337 - 2013 Mauldin asphalt paver 200,000 - - 200,000 Public Works 0615.6930 TBA 2023 Replace #364 - SPH-1.3 pre-mix heater hot box/patching 45,000 - - 45,000 Public Works 0615.6930 TBA 2023 Replace #310 - 2010 Chevy 3500 85,000 - - 85,000 Public Works 0615.6930 TBA 2023 Replace #314 - 2012 International SA 265,000 - - 265,000 Public Works 0615.6930 TBA 2023 Replace #431 - Sterling Acterra w/jetter 275,000 - - 275,000 Public Works 0615.6930 TBA 2023 Replace #110 - Chevy K3500 Silverado and 9' plow w/Tommy gate 54,520 - - 54,520 Public Works 0615.6930 TBA 2024 Replace #108 Cushman Gas Truckster 4 Wheel (Replace with ToolCAT)75,000 - - - Public Works 0615.6930 TBA 2024 Replace #178 Graco Fieldlazer @100 striper 10,000 - - - Comm Dev 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 #420 Tractor backhoe 250,000 - - - Public Works 0615.6930 TBA 2024 Replace #451 - SRECO easement machine (no title)44,590 - - - Public Works 0615.6930 TBA 2024 Replace #457 - Broot utility trailer 11,000 - - - Public Works 0615.6930 TBA 2025 Replace #439 20 Kw portable generator with light tower (replace existing 37kW)45,000 - - - Public Works 0615.6930 TBA 2025 Aries CCTV Pathfinder Command Ctr 135,000 - - - Public Works 0615.6930 TBA 2025 Replace #102 Ford F350 Pickup 75,000 - - - Public Works 0615.6930 TBA 2025 Aerator 35,000 - - - Public Works 0615.6930 TBA 2025 Replace Engineering #42 40,000 - - - 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 3-yd grapple bucket for use w/front end loaders 30,289 - - - Public Works 0615.6930 TBA 2025 Replace #106 - Ford F350 Pickup w/Henderson Dump body 90,000 - - - Public Works 0615.6930 TBA 2025 Replace #401 - Chevy Silverado 2500 (white)46,674 - - - Public Works 0615.6930 TBA 2026 Replace #453 Power Prime 6" trash pump 65,000 - - - 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 2026 Replace #117 Case 321FHS Wheel Loader 125,000 - - - Public Works 0615.6930 TBA 2026 Replace #127 Toro Grounds Master 5910 (cab, leaft kit, road lights)150,000 - - - 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)80,000 - - - Public Works 0615.6930 TBA 2027 Replace #342 - TowMaster T-10DT Trailer 10,000 - - - Public Works 0615.6930 TBA 2027 Replace #450-1 - Caterpillar 930K wheel loader (no title) and 12 ft plow 252,000 - - - Public Works 0615.6930 TBA 2027 Replace #462 - Elgin Pelican NP Sweeper 290,605 - - - Public Works 0615.6930 TBA 2027 Replace #120 J.D. Gator 5710M w/Ballfield Drag & Sun Cab 19,000 - - - Public Works 0615.6930 TBA 2027 Replace #124 - 2018 Toro GM4000-D mower 68,000 - - - Public Works 0615.6930 TBA 2027 Replace #145 - Toro Workman MDX w/ballfield groomer 18,000 - - - Public Works 0615.6930 TBA 2027 Replace #426 Freightliner w/Vactor Jet Rodder Unit 450,000 - - - Public Works 0615.6930 TBA 2027 Replace #449 Chevy Silverado K2500 (white)45,000 - - - Public Works 0615.6930 TBA 2028 Replace #455 - MacLander trailer 6,668 - - - Public Works 0615.6930 TBA 2028 Replace #306 - GMC Sierra 1500 Ext Cab 1/2 Ton (blue)45,000 - - - 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 #430 - Sreco sewer rodder 93,349 - - - Public Works 0615.6930 TBA 2028 Replace #450-2 - 12 ft Plow & ACS Adapter (for #450)16,003 - - - Public Works 0615.6930 TBA 2028 Replace #429 GMC Sierra 3500 C/CH 4WD 105,000 - - - 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 2029 Replace #130 ExMark Z Turn/Vac 18,000 - - - Comm Dev 0615.6930 TBA 2029 Replace car #27 - 2007 Chevy Malibu 21,587 - - - Comm Dev 0615.6930 TBA 2029 Replace car #57 - 2006 Chevy Malibu 21,587 - - - Public Works 0615.6930 TBA 2029 Replace #427 - GMC 1 ton; Sierra 3500 4x4 double cab (white)55,000 - - - City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Schedule of Planned Capital Outlay 2022 to 2032 Department DRAFT 54 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 75,000 - - - - - - - - 10,000 - - - - - - - - 21,587 - - - - - - - - 52,804 - - - - - - - - 250,000 - - - - - - - - 44,590 - - - - - - - - 11,000 - - - - - - - - - 45,000 - - - - - - - - 135,000 - - - - - - - - 75,000 - - - - - - - - 35,000 - - - - - - - - 40,000 - - - - - - - - 181,732 - - - - - - - - 96,924 - - - - - - - - 30,289 - - - - - - - - 90,000 - - - - - - - - 46,674 - - - - - - - - - 65,000 - - - - - - - - 50,037 - - - - - - - - 306,476 - - - - - - - - 6,255 - - - - - - - - 10,007 - - - - - - - - 50,037 - - - - - - - - 125,000 - - - - - - - - 150,000 - - - - - - - - - 77,495 - - - - - - - - 80,000 - - - - - - - - 10,000 - - - - - - - - 252,000 - - - - - - - - 290,605 - - - - - - - - 19,000 - - - - - - - - 68,000 - - - - - - - 18,000 - - - - - - - - 450,000 - - - - - - - - 45,000 - - - - - - - - - 6,668 - - - - - - - - 45,000 - - - - - - - - 6,668 - - - - - - - - 126,688 - - - - - - - - 93,349 - - - - - - - - 16,003 - - - - - - - - 105,000 - - - - - - - - - 385,530 - - - - - - - - 18,000 - - - - - - - - 21,587 - - - - - - - - 21,587 - - - - - - - - 55,000 - - - DRAFT 55 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Object Code Subledger Replace Item Cost Amounts Amounts Amounts 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 #305 - Dodge Ram 5500 4X4 Bucket Truck w/Dura-Lift (white)250,000 - - - 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 #459 Aries CCTV Pathfinder Command Ctr and trailer (no title)150,000 - - - Public Works 0615.6930 TBA 2031 Replace #336 Cimline crack/joint sealer, Magma 150 75,000 - - - Public Works 0615.6930 TBA 2031 Replace #447 Freightliner 114SD w/plow,wing,sander,controls 280,000 - - - Public Works 0615.6930 TBA 2031 Replace #436 Landa portable hot water jetter w/trailer 8,000 - - - Public Works 0615.6930 TBA 2031 Replace #103 GMC Sierra 2500 4WD (white)32,000 - - - Public Works 0615.6930 TBA 2031 Replace #152 Felling FT-10IT-E00260 Trailer 20,000 - - - Public Works 0615.6930 TBA 2031 Replace #159 Felling FT-10 IT-E Trailer 20,000 - - - Public Works 0615.6930 TBA 2031 Replace #346 TowMaster T-20T Trailer 8,000 - - - Public Works 0615.6930 TBA 2031 Replace #365 Cimline asphalt crack router, PCR30 20,000 - - - Public Works 0615.6930 TBA 2032 Replace #432 - 2008 Ford F150: Water Utility Replace 55,000 - - - Public Works 0615.6930 TBA 2032 Bobcat T650 T4 Compact Track Loader 65,000 - - - -$ 779,000$ 924,520$ City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Department Schedule of Planned Capital Outlay 2018 to 2032 (Continued) DRAFT 56 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ 54,022$ -$ -$ - - - - - - 65,396 - - - - - - - - 250,000 - - - - - - - - 14,216 - - - - - - - - 78,190 - - - - - - - - 14,216 - - - - - - - - 21,325 - - - - - - - - 71,082 - - - - - - - - 150,000 - - - - - - - - - 75,000 - - - - - - - - 280,000 - - - - - - - - 8,000 - - - - - - - - 32,000 - - - - - - - - 20,000 - - - - - - - - 20,000 - - - - - - - - 8,000 - - - - - - - - 20,000 - - - - - - - - - - - - - - - - - 464,980$ 775,619$ 762,812$ 1,310,100$ 399,375$ 501,704$ 718,448$ 463,000$ -$ DRAFT 57 2021 2022 2023 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from interfund services provided 336,540$ 341,585$ 365,496$ Payments to suppliers and employees (2.5% growth annually)15,368 (3,628) (3,737) Net Cash Provided (Used) by Operating Activities 351,908 337,957 361,759 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 (449,647) (779,000) (924,520) Proceeds from sale of assets 58,500 46,640 46,640 Internal loan to Building Fund - - - Net Cash Used by Capital and Related Financing Activities (391,147) (732,360) (877,880) Cash Flows from Investing Activities Investment earnings (11,737) 20,000 21,176 Net Increase (Decrease) in Cash and Cash Equivalents (50,976) (374,403) (494,944) Cash and Cash Equivalents, January 1 2,542,989 2,492,013 2,117,610 Cash and Cash Equivalents, December 31 2,492,013$ 2,117,610$ 1,622,666$ Internal Service Fund Projected Activity Internal Service Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Statement of Cash Flows DRAFT 58 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 391,081$ 418,456$ 447,748$ 479,091$ 512,627$ 548,511$ 586,907$ 627,990$ 671,949$ (3,849) (3,964) (4,083) (4,206) (4,332) (4,462) (4,596) (4,734) (4,876) 387,232 414,492 443,665 474,885 508,295 544,049 582,311 623,256 667,074 - - - - - - - - - - - - - - - - - - (464,980) (775,619) (762,812) (1,310,100) (399,375) (501,704) (718,448) (463,000) - 46,640 46,640 46,640 46,640 46,640 46,640 46,640 46,640 - - - - - - - - - (418,340) (728,979) (716,172) (1,263,460) (352,735) (455,064) (671,808) (416,360) - 16,227 16,078 13,094 10,500 2,719 4,302 5,235 4,392 6,505 (14,882) (298,409) (259,413) (778,075) 158,279 93,286 (84,263) 211,288 673,578 1,622,666 1,607,784 1,309,374 1,049,961 271,886 430,165 523,451 439,188 650,477 1,607,784$ 1,309,374$ 1,049,961$ 271,886$ 430,165$ 523,451$ 439,188$ 650,477$ 1,324,055$ Internal Service Fund Projected Activity DRAFT 59 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts City Buildings 0625.6940 TBA 2022 City Hall - office cubes and desks 200,000 - 200,000 - Police 0625.6940 TBA 2022 Public Safety Facility 8,000,000 - 8,000,000 - City Buildings 0625.6940 TBA 2022 Parking lot replacement 250,000 - 250,000 - City Buildings 0625.6940 TBA 2022 Make cell phone boost system typical install 50,000 - 50,000 - City Buildings 0625.6940 TBA 2022 Replace alarms and sensors 50,000 - 50,000 - City Buildings 0625.6940 TBA 2022 Replace control panel 18,000 - 18,000 - City Buildings 0625.6940 TBA 2022 Upgrade system to code 10,000 - 10,000 - City Buildings 0625.6940 TBA 2022 Replace VFD on air handlers 10,000 - 10,000 - Old Utilities Bldg 0625.6940 TBA 2022 Replace garage door obstruction sensors 5,000 - 5,000 - Public Works 0625.6940 TBA 2022 Re-seal garage doors - PW 12,000 - 12,000 - Community Center 0625.6940 TBA 2022 Refinish Crystal Room Floors 50,000 - 50,000 - Community Center 0625.6940 TBA 2022 Replace South Parking lot 85,000 - 85,000 - Community Center 0625.6940 TBA 2022 Replace gym windows 125,000 - 125,000 - Community Center 0625.6940 TBA 2022 Parking lot lighting 35,000 - 35,000 - Community Center 0625.6940 TBA 2022 Replace windows 220,000 - 220,000 - Bassett Creek Park 0625.6940 TBA 2022 Replace Parking lot 25,000 - 25,000 - North Lions Park 0625.6940 TBA 2022 Replace furnace/thermostat and chimney 15,000 - 15,000 - Public Works 0625.6940 TBA 2022 Interior touch up paint 20,000 - 20,000 - City Buildings 0625.6940 TBA 2022 Replace carpeting 100,000 - 100,000 - Community Center 0625.6940 TBA 2022 Replace Air Handler 45,000 - 45,000 - Bassett Creek Park 0625.6940 TBA 2023 Replace Parking lot 350,000 - - 350,000 Police 0625.6941 TBA 2023 Public Safety Facility 4,000,000 - - 4,000,000 Community Center 0625.6940 TBA 2023 Replace flooring- Valley room 15,000 - - 15,000 Community Center 0625.6940 TBA 2023 Replace South Parking lot 1,375,000 - - 1,375,000 Community Center 0625.6940 TBA 2023 South Parking lot cameras 10,000 - - 10,000 Welcome Park 0625.6941 TBA 2023 Replace Building Fascia and Soflits 25,000 - - 25,000 City Buildings 0625.6940 TBA 2023 Evaluate city hall system for space heater use 60,000 - - 60,000 City Buildings 0625.6940 TBA 2023 Parking lot lighting upgrade 14,000 - - 14,000 City Buildings 0625.6940 TBA 2023 Replace cabinets in copy room 10,000 - - 10,000 City Buildings 0625.6940 TBA 2023 Replace cabinets in Council Chambers 15,000 - - 15,000 City Buildings 0625.6940 TBA 2023 City Hall fire extinguisher mounts/cabinets 15,000 - - 15,000 City Buildings 0625.6940 TBA 2023 Install boiler for heater at PW 35,000 - - 35,000 City Buildings 0625.6940 TBA 2023 Fob access all doors - City Hall 25,000 - - 25,000 City Buildings 0625.6940 TBA 2023 Replace/improve to upstairs IT room 15,000 - - 15,000 Salt Building 0625.6940 TBA 2023 Paint exterior building, light panel replacement 10,000 - - 10,000 Public Works 0625.6940 TBA 2023 Install boiler for heater 35,000 - - 35,000 Valley Place Park 0625.6940 TBA 2023 Replace furnace / thermostat 18,000 - - 18,000 City Buildings 0625.6940 TBA 2023 HVAC cleaning 35,000 - - 35,000 North Lions Park 0625.6940 TBA 2023 Replace skylights 25,000 - - 25,000 City Buildings 0625.6940 TBA 2023 Investigate drainage in boiler room 10,000 - - 10,000 Community Center 0625.6940 TBA 2024 ADA and security update Front desk 85,000 - - - Pool 0625.6940 TBA 2024 Grogan Park improvements 3,500,000 - - - City of Crystal, Minnesota Capital Improvement Plan - Building Fund 625 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 60 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 85,000 - - - - - - - - 3,500,000 - - - - - - - - DRAFT 61 2021 2022 2023 Business Unit Year to Actual Proposed Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Community Center 0625.6940 TBA 2024 Replace floor scrubber 15,000$ -$ -$ -$ City Buildings 0625.6940 TBA 2024 Lighting upgrade to LED at City Hall, including chambers 40,000 - - - City Buildings 0625.6940 TBA 2024 Replace can lighting in entire building 60,000 - - - City Buildings 0625.6940 TBA 2024 Replace popcorn ceiling in Council Chambers 30,000 - - - City Buildings 0625.6940 TBA 2024 Replace/improve to downstairs IT room (AC unit)15,000 - - - Community Center 0625.6940 TBA 2024 Replace Refrigerator/refrigerator 12,000 - - - Community Center 0625.6940 TBA 2024 Building Automation updates 120,000 - - - North Fire Station 0625.6940 TBA 2024 Replace generator 25,000 - - - North Fire Station 0625.6940 TBA 2024 Upgrade emergency/exit lighting 5,000 - - - City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors 5,000 - - - South Fire Station 0625.6940 TBA 2024 Replace generator 15,000 - - - City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors 5,000 - - - South Fire Station 0625.6940 TBA 2024 Replace Parking lot (concrete pad)60,000 - - - North Lions Park 0625.6940 TBA 2024 Replace West Parking lot asphalt 320,000 - - - Pool 0625.6940 TBA 2025 Replace waterwalk pads (5 floats)22,000 - - - Aquatic building 0625.6940 TBA 2025 Install fiberglass doors in chemical areas (3)30,000 - - - Pool 0625.6940 TBA 2025 Replaster Zero depth pool and replace play feature - from leak report 325,000 - - - Pool 0625.6940 TBA 2025 Play feature pumps 40,000 - - - Pool 0625.6940 TBA 2025 Recoat Gutters/Drop Slide Stairs 25,000 - - - Pool 0625.6940 TBA 2025 Gel coat water slides and drop slide 150,000 - - - City Buildings 0625.6940 TBA 2025 Replace water heater 25,000 - - - City Buildings 0625.6940 TBA 2025 Elevator rehab 100,000 - - - City Buildings 0625.6940 TBA 2025 Replace Air Handler 150,000 - - - City Buildings 0625.6940 TBA 2025 Replace toilets and urinals 35,000 - - - Community Center 0625.6940 TBA 2025 Re-key building 100,000 - - - Old Utilities bldg 0625.6940 TBA 2025 Replace heating system and thermostat 51,000 - - - Public Works 0625.6940 TBA 2025 Fob access all doors 35,000 - - - City Buildings 0625.6940 TBA 2025 Remove Air compressors at City Hall 25,000 - - - Valley Place Park 0625.6940 TBA 2025 Replace parking lot (West)300,000 - - - Fire Department 0625.6941 TBA 2025 Replace exterior doors- south Fire Station 50,000 - - - Community Center 0625.6940 TBA 2025 Replace Volleyball Standards/ref stands 15,000 - - - Aquatic building 0625.6940 TBA 2025 Replace staff lockers 20,000 - - - City Buildings 0625.6940 TBA 2026 Paint interior 60,000 - - - City Buildings 0625.6940 TBA 2026 Upgrade Generator 250,000 - - - Community Center 0625.6940 TBA 2026 Replace Carpet 30,000 - - - Community Center 0625.6940 TBA 2026 Replace windows 30,000 - - - City Buildings 0625.6940 TBA 2026 Replace restroom fixtures 10,000 - - - City Buildings 0625.6940 TBA 2026 Replacing upstairs ceiling 25,000 - - - Aquatic Building 0625.6940 TBA 2026 Replace bathroom fixtures 30,000 - - - Aquatic Building 0625.6940 TBA 2026 Replace hand dryers 15,000 - - - Aquatic Building 0625.6940 TBA 2026 Replace security lighting and exit lights 20,000 - - - Becker Park 0625.6940 TBA 2026 Replace Parking lot 400,000 - - - Community Center 0625.6940 TBA 2027 Divider Wall- gyms 200,000 - - - Community Center 0625.6940 TBA 2027 Replace Refrigerator (double door)7,000 - - - Pool 0625.6940 TBA 2027 Replace cargo net 10,000 - - - Aquatic building 0625.6940 TBA 2027 Paint interior 20,000 - - - Aquatic building 0625.6940 TBA 2027 Replace furnaces (3)45,000 - - - Pool 0625.6940 TBA 2028 Replace sun sail shade cover 19,000 - - - Valley Place Park 0625.6940 TBA 2028 Replace water heater 10,000 - - - Aquatic building 0625.6940 TBA 2028 Tuck pointing 25,000 - - - City Buildings 0625.6940 TBA 2028 Building wide public address system 75,000 - - - City Buildings 0625.6940 TBA 2028 Replace/relocate motion sensors for lights 10,000 - - - City Buildings 0625.6940 TBA 2028 Upgrade life safety systems 100,000 - - - Community Center 0625.6940 TBA 2028 Replace ovens 18,000 - - - Community Center 0625.6940 TBA 2028 Replace 6-burner stove 7,000 - - - Pool 0625.6940 TBA 2028 Replace drain covers 25,000 - - - Fire Department 0625.6940 TBA 2028 Replace exterior windows 200,000 - - - Fire Department 0625.6940 TBA 2028 Replace roof at North Fire Station 100,000 - - - City of Crystal, Minnesota Capital Improvement Plan - Building Fund 625 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 62 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts 15,000$ -$ -$ -$ -$ -$ -$ -$ -$ 40,000 - - - - - - - - 60,000 - - - - - - - - 30,000 - - - - - - - - 15,000 - - - - - - - - 12,000 - - - - - - - - 120,000 - - - - - - - - 25,000 - - - - - - - - 5,000 - - - - - - - - 5,000 - - - - - - - - 15,000 - - - - - - - - 5,000 - - - - - - - - 60,000 - - - - - - - - 320,000 - - - - - - - - - 22,000 - - - - - - - - 30,000 - - - - - - - - 325,000 - - - - - - - - 40,000 - - - - - - - - 25,000 - - - - - - - - 150,000 - - - - - - - - 25,000 - - - - - - - - 100,000 - - - - - - - - 150,000 - - - - - - - - 35,000 - - - - - - - - 100,000 - - - - - - - - 51,000 - - - - - - - - 35,000 - - - - - - - - 25,000 - - - - - - - - 300,000 - - - - - - - - 50,000 - - - - - - - - 15,000 - - - - - - - - 20,000 - - - - - - - - - 60,000 - - - - - - - - 250,000 - - - - - - - - 30,000 - - - - - - - - 30,000 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 30,000 - - - - - - - - 15,000 - - - - - - - - 20,000 - - - - - - - - 400,000 - - - - - - - - - 200,000 - - - - - - - - 7,000 - - - - - - - - 10,000 - - - - - - - - 20,000 - - - - - - - - 45,000 - - - - - - - - - 19,000 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 75,000 - - - - - - - - 10,000 - - - - - - - - 100,000 - - - - - - - - 18,000 - - - - - - - - 7,000 - - - - - - - - 25,000 - - - - - - - - 200,000 - - - - - - - - 100,000 - - - - DRAFT 63 2021 2022 2023 Business Unit Year to Actual Proposed Estimated Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Community Center 0625.6940 TBA 2029 Update Minnesota room 75,000$ -$ -$ -$ City Buildings 0625.6940 TBA 2029 Re-key building 50,000 - - - City Buildings 0625.6940 TBA 2029 Replace all window treatments 100,000 - - - Fire Department 0625.6940 TBA 2029 Improve upstairs ventilation 40,000 - - - Public Works 0625.6940 TBA 2029 Re-key building 25,000 - - - Fire Department 0625.6940 TBA 2029 Replace exterior doors 50,000 - - - Public Works 0625.6940 TBA 2029 Paint exterior building 25,000 - - - Public Works 0625.6940 TBA 2029 Re-key building 50,000 - - - Public Works 0625.6940 TBA 2029 Replace skylights 50,000 - - - City Buildings 0625.6940 TBA 2029 Replace asphalt with concrete in bins 50,000 - - - City Buildings 0625.6940 TBA 2029 Replace parking lot asphalt 50,000 Public Works 0625.6940 TBA 2029 Service door replacement 3,000 - - - City Buildings 0625.6940 TBA 2029 Fob access all doors 25,000 - - - Valley Place Park 0625.6940 TBA 2029 Re-key building 5,000 - - - Valley Place Park 0625.6940 TBA 2029 Fob access all doors 25,000 - - - Pool 0625.6941 TBA 2029 Replace diving board and diving board stand 22,000 - - - Pool 0625.6941 TBA 2029 Paint drop slide/walkway/waterslide structure 90,000 - - - City Buildings 0625.6940 TBA 2030 Replace exterior windows 450,000 - - - Aquatic building 0625.6940 TBA 2030 Fob access all doors 25,000 - - - City Buildings 0625.6940 TBA 2030 Install building security system 50,000 - - - City Buildings 0625.6940 TBA 2030 Paint exterior building 100,000 - - - City Buildings 0625.6940 TBA 2030 Replace finance safe with building-integrated safe 10,000 - - - City Buildings 0625.6940 TBA 2030 Re-roof entire building 250,000 - - - Community Center 0625.6940 TBA 2030 Upgrade building safety systems 75,000 - - - Community Center 0625.6940 TBA 2030 Paint interior- meeting rooms 30,000 - - - Community Center 0625.6940 TBA 2030 Replace roof 225,000 - - - Community Center 0625.6940 TBA 2030 Tuckpointing 50,000 - - - Community Center 0625.6940 TBA 2030 Fob access all doors 25,000 - - - Community Center 0625.6940 TBA 2030 Replace bathroom fixtures 50,000 - - - Fire Department 0625.6940 TBA 2030 ADA restroom upgrades 25,000 - - - City Buildings 0625.6940 TBA 2030 Paint interior 30,000 - - - Pool 0625.6940 TBA 2030 Replace lounge chairs 15,000 - - - Pool 0625.6940 TBA 2030 Replace water play feature 50,000 - - - Pool 0625.6940 TBA 2030 Replace main pumps (2)50,000 - - - Pool 0625.6940 TBA 2030 Replace landscaping 50,000 - - - Public Works 0625.6940 TBA 2030 Exterior touch up paint 35,000 - - - Public Works 0625.6940 TBA 2030 Exterior touch up paint 25,000 - - - Fire Department 0625.6940 TBA 2030 Do something in downstairs training area 50,000 - - - Fire Department 0625.6940 TBA 2030 Exterior repair 125,000 - - - Fire Department 0625.6940 TBA 2030 Upgrade life safety systems 100,000 - - - Community Center 0625.6940 TBA 2031 Replace freezer (single) 6,000 - - - Community Center 0625.6940 TBA 2031 Replace convection oven (2 stacked)12,000 - - - Community Center 0625.6940 TBA 2031 Replace gym tables 10,000 - - - Community Center 0625.6940 TBA 2031 Replace tables- Valley room 18,000 - - - Community Center 0625.6940 TBA 2031 Replace High Efficency Heaters (3)50,000 - - - Public Works 0625.6940 TBA 2031 Replace pressure washer 20,000 - - - Fire Department 0625.6940 TBA 2031 Install eyewash station at North Fire station 10,000 - - - Fire Department 0625.6940 TBA 2031 Install railing on roof by access door at North Fire 15,000 - - - Fire Department 0625.6940 TBA 2031 Replace entry door heater (in wall)15,000 - - - Public Works 0625.6940 TBA 2031 Replace pressure washer 20,000 - - - Community Center 0625.6940 TBA 2032 Replace coffee maker 5,000 - - - Community Center 0625.6940 TBA 2032 Replace folding chair 10,000 - - - Community Center 0625.6940 TBA 2032 Replace Crystal room chairs 20,000 - - - Community Center 0625.6940 TBA 2032 Replace MN room Lounge Chair 6,000 - - - -$ 9,327,022$ 6,099,023$ City of Crystal, Minnesota Capital Improvement Plan - Building Fund 625 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 64 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ 75,000$ -$ -$ -$ - - - - - 50,000 - - - - - - - - 100,000 - - - - - - - - 40,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 3,000 - - - - - - - - 25,000 - - - - - - - - 5,000 - - - - - - - - 25,000 - - - - - - - - 22,000 - - - - - - - - 90,000 - - - - - - - - - 450,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 100,000 - - - - - - - - 10,000 - - - - - - - - 250,000 - - - - - - - - 75,000 - - - - - - - - 30,000 - - - - - - - - 225,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 30,000 - - - - - - - - 15,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 35,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 125,000 - - - - - - - - 100,000 - - - - - - - - - 6,000 - - - - - - - - 12,000 - - - - - - - - 10,000 - - - - - - - - 18,000 - - - - - - - - 50,000 - - - - - - - - 20,000 - - - - - - - - 10,000 - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 20,000 - - - - - - - - - 5,000 - - - - - - - - 10,000 - - - - - - - - 20,000 - - - - - - - - 6,000 5,041,024$ 2,092,025$ 872,026$ 284,027$ 591,028$ 687,029$ 1,897,030$ 178,031$ 158,032$ DRAFT 65 2021 2022 2023 Actual Proposed Estimated Revenues Internal charges ((1% increase in 2022, $217403 reduction in 2023, 1% increase (based on 2022) thereafter))1,323,091$ 1,467,403$ 1,250,000$ Interest on investments (16,868) 10,000 66,191 Intergovernmental revenue 343,888 6,523,888 90,328 Miscellaneous 4,370 - - Total Revenues 1,654,481 8,001,291 1,406,519 Expenditures Capital outlay Capital outlay 970,859 - - City Buildings - 688,000 234,000 Community Center - 560,000 1,400,000 Aquatic Building - - - Public Safety - - - Public Works - 32,000 35,000 Salt Building - - 10,000 Pool - - - Fire Department - - - Police 2,676,032 8,000,000 4,000,000 Parks & Recreation - - - Bassett Creek Park - 25,000 350,000 Becker Park - - - North Fire Station - - - South Fire Station - - - North Lions Park - 15,000 25,000 Valley Place Park - - 18,000 Bass Lake - - - Old utilities bldg - 5,000 - Welcome Park - - 25,000 Total Expenditures 3,646,891 9,325,000 6,097,000 Excess (Deficiency) of Revenues Over (Under) Expenditures (1,992,410) (1,323,709) (4,690,481) Other Financing Sources Internal Loan from Street Fund - 5,000,000 - Internal Loan from Police Revolving Fund - - 1,170,000 Internal Loan from Storm Water - 200,000 300,000 Internal Loan from IT - - - Internal Loan from Water 900,000 Total Other Financing Sources - 5,200,000 2,370,000 Net Change in Fund Balances (1,992,410) 3,876,291 (2,320,481) Cash Balances, January 1 4,735,240 2,742,830 6,619,121 Cash Balances, December 31 2,742,830$ 6,619,121$ 4,298,640$ 2021 2022 2023 Estimated Estimated Estimated Amounts Amounts Amounts Beginning Balance -$ -$ -$ Revenue Property taxes - - - Interest - - - Other - - - Total Revenue - - - Expenditures Principal - - - Interest - - - Total Expenditures - - - Ending Balance -$ -$ -$ City of Crystal, Minnesota Capital Improvement Plan - Building Fund 625 Schedule of Projected Revenue, Expenditures and Debt (Continued) Internal Service Fund Projected Activity Internal Service Fund Projected Activity Debt Service Fund Related Activity Capital Improvement Plan - Building Fund 625 Schedule of Planned Capital Outlay 2022 to 2032 City of Crystal, Minnesota DRAFT 66 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 1,482,077$ 1,496,898$ 1,511,867$ 1,526,985$ 1,542,255$ 1,557,678$ 1,573,255$ 1,588,987$ 1,604,877$ 42,986 14,120 4,854 4,374 521 2,962 7,222 (120) 9,712 100,328 110,328 120,328 130,328 140,328 150,328 160,328 170,328 180,328 - - - - - - - - 1,625,391 1,621,346 1,637,049 1,661,688 1,683,104 1,710,968 1,740,804 1,759,195 1,794,917 - - - - - - - - - 155,000 335,000 345,000 - 185,000 225,000 890,000 - - 232,000 115,000 60,000 207,000 25,000 75,000 455,000 96,000 131,000 - 50,000 65,000 65,000 25,000 - 25,000 - - - - - - - - - - - - 35,000 - - - 153,000 60,000 40,000 25,000 - - - - - - - - - 3,500,000 562,000 - 10,000 44,000 112,000 165,000 - - - 50,000 - - 300,000 90,000 300,000 40,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 400,000 - - - - - - 30,000 - - - - - - - - 75,000 - - - - - - - - 320,000 - - - - - - - - - 300,000 - - 10,000 30,000 - - - - - - - - - - - - - 51,000 - - - - - - - - - - - - - - - - - 4,312,000 1,498,000 870,000 282,000 589,000 685,000 1,895,000 176,000 156,000 (2,686,609) 123,346 767,049 1,379,688 1,094,104 1,025,968 (154,196) 1,583,195 1,638,917 (200,000) (700,000) (500,000) (1,300,000) (500,000) (300,000) (230,000) (400,000) (870,000) - (250,000) (115,000) (115,000) (100,000) - (150,000) (200,000) (240,000) - (100,000) (100,000) (100,000) (100,000) (100,000) - - - - - - - - - - - - - - (100,000) (250,000) (150,000) (200,000) (200,000) - - (200,000) (1,050,000) (815,000) (1,765,000) (850,000) (600,000) (580,000) (600,000) (1,110,000) (2,886,609) (926,654) (47,951) (385,312) 244,104 425,968 (734,196) 983,195 528,917 4,298,640 1,412,032 485,378 437,426 52,114 296,218 722,187 (12,009) 971,186 1,412,032$ 485,378$ 437,426$ 52,114$ 296,218$ 722,187$ (12,009)$ 971,186$ 1,500,103$ 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ -$ -$ -$ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -$ -$ -$ -$ -$ -$ -$ -$ -$ Internal Service Fund Projected Activity DRAFT 67 2021 2022 2023 Business Unit Year to Actual Proposed Proposed Department Object Code Subledger Replace Item Cost Amounts Amounts Amounts Information Technology 0620.6940 TBA 2022 Networked Department Printers 800 - 800 - Information Technology 0620.6940 TBA 2022 Multi-Function Printer - Public Works 7,500 - 7,500 - Information Technology 0620.6940 TBA 2022 Large Format Plotter/Scanner 10,000 - 10,000 - Information Technology 0620.6940 TBA 2022 Building Security Upgrade/Repair/Replace 25,000 - 25,000 - Information Technology 0620.6940 TBA 2022 Building Access Control Upgrade/Repair/Rplc 25,000 - 25,000 - Information Technology 0620.6940 TBA 2022 Robbinsdale SD - Potential Replacement 18,833 - 18,833 - Information Technology 0620.6940 TBA 2022 Computer Hardware & Software 62,500 - 62,500 - Information Technology 0620.6940 TBA 2022 City Hall Switch - 24 Port | LOGIS 4,703 - 4,703 - Information Technology 0620.6940 TBA 2022 WiFi AP's - Crystal Cove (New)6,000 - 6,000 - Information Technology 0620.6940 TBA 2022 FIN - Tungsten to Laserfiche 3,000 - 3,000 - Information Technology 0620.6940 TBA 2022 Utility/Lift Station Fiber 100,000 - 100,000 - Information Technology 0620.6940 TBA 2023 Robbinsdale SD - Potential Replacement 18,833 - -18,833 Information Technology 0620.6940 TBA 2023 Fiber Improvement & Adds 20,000 - -20,000 Information Technology 0620.6940 TBA 2023 Computer Hardware & Software 65,000 - -65,000 Information Technology 0620.6940 TBA 2023 Multi-Function Printer - ComDev 7,500 - -7,500 Information Technology 0620.6940 TBA 2023 Networked Department Printers 800 - -800 Information Technology 0620.6940 TBA 2023 Network Firewall ASA 5,252 - -5,252 Information Technology 0620.6940 TBA 2023 Public Works Switch - 24 Port | LOGIS 4,703 - -4,703 Information Technology 0620.6940 TBA 2023 Police Cellebrite Hardware 3,000 - -3,000 Information Technology 0620.6940 TBA 2023 Building Security Upgrade/Repair/Replace 25,000 - -25,000 Information Technology 0620.6940 TBA 2023 Building Access Control Upgrade/Repair/Rplc 25,000 - -25,000 Information Technology 0620.6940 TBA 2024 Becker Park 24P POE Switch 3,715 - -- Information Technology 0620.6940 TBA 2024 Becker Park Outdoor AP & Antennas 1,770 - -- 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 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 Building Security Upgrade/Repair/Replace 15,000 - -- Information Technology 0620.6940 TBA 2024 Building Access Control Upgrade/Repair/Rplc 22,000 - -- Information Technology 0620.6940 TBA 2025 6612 41st Lift Station Switch 4,890 - -- Information Technology 0620.6940 TBA 2025 4648 Tower Switch 4,360 - -- Information Technology 0620.6940 TBA 2025 Robbinsdale SD - Potential Replacement 18,833 - -- Information Technology 0620.6940 TBA 2025 Fiber Improvement & Adds 20,000 - -- City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2022 to 2032 DRAFT 68 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 3,715 - - - - - - - - 1,770 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 55,000 - - - - - - - - 9,605 - - - - - - - - 11,128 - - - - - - - - 800 - - - - - - - - 3,141 - - - - - - - - 902 - - - - - - - - 10,000 - - - - - - - - 3,000 - - - - - - - - 15,000 - - - - - - - - 22,000 - - - - - - - - - 4,890 - - - - - - - - 4,360 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - DRAFT 69 2021 2022 2023 Year to Actual Proposed Proposed Department Replace Item Cost Amounts Amounts Amounts 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 Switch 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 CCC DVR Server 10,000 - - - Information Technology 0620.6940 TBA 2025 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2025 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2026 Lift Station Switch HW (5825, 6125, 3203, 3000)19,600 - - - 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 - - - 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 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2026 Building Access Control Upgrade/Repair/Rplc 25,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 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2027 Building Access Control Upgrade/Repair/Rplc 25,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 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 Police Cellebrite Hardware 3,000 - - - Information Technology 0620.6940 TBA 2028 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2028 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2029 Becker Park 24P POE Switch 3,715 - - - Information Technology 0620.6940 TBA 2029 Becker Park Outdoor AP & Antennas 1,770 - - - 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 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2029 Building Access Control Upgrade/Repair/Rplc 22,000 - - - Information Technology 0620.6940 TBA 2030 6612 41st Lift Station Switch 4,890 - - - Information Technology 0620.6940 TBA 2030 4648 Tower Switch 4,360 - - - 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 - - - City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) DRAFT 70 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ 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 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - - 19,600 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 732 - - - - - - - - 5,365 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 12,000 - - - - - - - - 800 - - - - - - - - 6,937 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 15,000 - - - - - - - - 7,500 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 18,833 - - - - - - - - 62,500 - - - - - - - - 4,703 - - - - - - - - 6,000 - - - - - - - - 3,693 - - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 65,000 - - - - - - - - 7,500 - - - - - - - - 800 - - - - - - - - 5,252 - - - - - - - - 4,703 - - - - - - - - 3,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - - 3,715 - - - - - - - - 1,770 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 55,000 - - - - - - - - 9,605 - - - - - - - - 11,128 - - - - - - - - 5,459 - - - - - - - - 7,300 - - - - - - - - 800 - - - - - - - - 3,141 - - - - - - - - 902 - - - - - - - - 10,000 - - - - - - - - 3,000 - - - - - - - - 15,000 - - - - - - - - 22,000 - - - - - - - - - 4,890 - - - - - - - - 4,360 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 57,500 - - DRAFT 71 2021 2022 2023 Year to Actual Proposed Estimated Department Replace Item Cost Amounts Amounts Amounts Information Technology 0620.6940 TBA 2030 City Hall Switch 2 - 48 Port POE 8,021$ -$ -$ -$ Information Technology 0620.6940 TBA 2030 City Hall Switch 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 - - - Information Technology 0620.6940 TBA 2030 CCC DVR Server 10,000 - - - Information Technology 0620.6940 TBA 2030 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2030 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2031 Lift Station Switch HW (5825, 6125, 3203, 3000)19,600 - - - Information Technology 0620.6940 TBA 2031 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2031 Fiber Improvement & Adds 20,000 - - - Information Technology 0620.6940 TBA 2031 VOIP Phone Hardware 40,000 - - - Information Technology 0620.6940 TBA 2031 Computer Hardware & Software 60,000 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Emergency Ops Center 732 - - - Information Technology 0620.6940 TBA 2031 Network Firewall ASA 5,365 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Conference A 732 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Cable Room 732 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - Server Room 732 - - - Information Technology 0620.6940 TBA 2031 Multi-Function Printer - Police 12,000 - - - Information Technology 0620.6940 TBA 2031 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2031 CCC Switch - 48 Port POE 6,937 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - CCC AB Room $732 - - - Information Technology 0620.6940 TBA 2031 WiFi AP - CCC Activity Room 732 - - - Information Technology 0620.6940 TBA 2031 Multi-Function Printer - City Hall 15,000 - - - Information Technology 0620.6940 TBA 2031 PW DVR Server 7,500 - - - Information Technology 0620.6940 TBA 2031 Building Security Upgrade/Repair/Replace 15,000 - - - Information Technology 0620.6940 TBA 2031 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2032 Networked Department Printers 800 - - - Information Technology 0620.6940 TBA 2032 Multi-Function Printer - Public Works 7,500 - - - Information Technology 0620.6940 TBA 2032 Large Format Plotter/Scanner 10,000 - - - Information Technology 0620.6940 TBA 2032 Building Security Upgrade/Repair/Replace 25,000 - - - Information Technology 0620.6940 TBA 2032 Building Access Control Upgrade/Repair/Rplc 25,000 - - - Information Technology 0620.6940 TBA 2032 Robbinsdale SD - Potential Replacement 18,833 - - - Information Technology 0620.6940 TBA 2032 Computer Hardware & Software 64,000 - - - Information Technology 0620.6940 TBA 2032 City Hall Switch - 24 Port | LOGIS 4,703 - - - Information Technology 0620.6940 TBA 2032 WiFi AP's - Crystal Cove 6,000 - - - Information Technology 0620.6940 TBA 2032 Fiber Improvement & Adds 20,000 - - - 288,619$ 180,247$ 179,134$ City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2020 to 2031 (Continued) DRAFT 72 2024 2025 2026 2027 2028 2029 2030 2031 2032 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts Amounts -$ -$ -$ -$ -$ -$ 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 - - - - - - - - 10,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - - 19,600 - - - - - - - - 18,833 - - - - - - - - 20,000 - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 732 - - - - - - - - 5,365 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 12,000 - - - - - - - - 800 - - - - - - - - 6,937 - - - - - - - - 732 - - - - - - - - 732 - - - - - - - - 15,000 - - - - - - - - 7,500 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - - 800 - - - - - - - - 7,500 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 18,833 - - - - - - - - 64,000 - - - - - - - - 4,703 - - - - - - - - 6,000 - - - - - - - - 20,000 178,942$ 317,223$ 264,479$ 206,916$ 179,144$ 191,711$ 229,733$ 254,489$ 185,900$ DRAFT 73 Internal Service Fund Projected Activity 2021 2022 2023 Actual Proposed Proposed Cash Flows from Operating Activities Receipts from interfund services provided (3% growth annually)552,919$ 554,792$ 592,641$ Payments to suppliers and employees (2.5% inflation annual starting in 2021)(689,998) (117,800) (434,029) Net Cash Provided (Used) by Operating Activities (137,079) 436,992 158,612 Cash Flows from Noncapital Financing Activities Transfers in - - - Net Cash Provided (Used) by Noncapital Financing Activities - - - Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (166,276) (180,247) (179,134) Intergovernmental revenue 8,000 - - Proceeds from sale of assets - - - Internal loan to Building Fund - - Internal loan repayment from Building Fund Proceeds from bonds and notes issued - - - Net Cash Provided (Used) by Capital and Related Financing Activities (158,276) (180,247) (179,134) Cash Flows from Investing Activities Investment earnings (1,402) 6,000 5,044 Net Increase (Decrease) in Cash and Cash Equivalents (296,757) 262,745 (15,478) Cash and Cash Equivalents, January 1 538,420 241,662 504,407 Cash and Cash Equivalents, December 31 241,662$ 504,407$ 488,930$ Internal Service Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Statement of Cash Flows DRAFT 74 Internal Service Fund Projected Activity 2024 2025 2026 2027 2028 2029 2030 2031 2032 Proposed Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 612,335$ 751,602$ 701,023$ 669,888$ 655,264$ 683,824$ 707,895$ 707,895$ 707,895$ (453,920) (451,448) (454,932) (482,799) (496,642) (512,320) (497,419) (509,854) (522,601) 158,416 300,154 246,091 187,089 158,623 171,504 210,476 198,041 185,294 - - - - - - - - - - - - - - - - - (178,942) (317,223) (264,479) (206,916) (179,144) (191,711) (229,733) (254,489) (185,900) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - (178,942) (317,223) (264,479) (206,916) (179,144) (191,711) (229,733) (254,489) (185,900) 4,889 4,733 4,610 4,472 4,318 4,156 3,996 3,843 3,317 (15,637) (12,336) (13,778) (15,355) (16,203) (16,051) (15,261) (52,605) 2,711 488,930 473,293 460,956 447,178 431,822 415,619 399,568 384,307 331,702 473,293$ 460,956$ 447,178$ 431,822$ 415,619$ 399,568$ 384,307$ 331,702$ 334,414$ DRAFT 75 THIS PAGE IS LEFT BLANK INTENTIONALLY DRAFT 76 Appendix A INTERNAL LOAN SCHEDULE FOR PUBLIC SAFETY FACILITY RENOVATION / CONSTRUCTIONDRAFT 77 City of Crystal, Minnesota Internal Loan Schedule for Public Safety Facility Renovation/Construction Internal Loan From 2021 2022 2023 Total Street Improvement -$ 5,000,000$ -$ 5,000,000$ Police Revolving - - 1,170,000 1,170,000 Water fund - - 900,000 900,000 Storm Water - 200,000 300,000 500,000 -$ 5,200,000$ 2,370,000$ 7,570,000$ Internal Loan To 2021 2022 2023 Total Building -$ 5,200,000$ 2,370,000$ 7,570,000$ Crystal Internal Loans 2021 2022 2023 2024 2025 Amounts Amounts Amounts Amounts Amounts Amounts Building Fund Internal Loans Street Improvement -$ 5,000,000$ -$ (200,000)$ (700,000)$ Police Revolving Fund - - 1,170,000 - (250,000) Water - - 900,000 - - Storm Water - 200,000 300,000 - (100,000) -$ 5,200,000$ 2,370,000$ (200,000)$ (1,050,000)$ Repayment Fund Loan Amount Period Street Improvement 5,000,000$ 2024 - 2032 Police Revolving 1,170,000 2025 - 2032 Water 900,000 2026 - 2030 Storm Water 500,000 2025 - 2029 Total Internal Loans 7,570,000$ DRAFT 78 2026 2027 2028 2029 2030 2031 2032 Total Amounts Amounts Amounts Amounts Amounts Amounts Amounts Repayments (500,000)$ (1,300,000)$ (500,000)$ (300,000)$ (230,000)$ (400,000)$ (870,000)$ (5,000,000)$ (115,000) (115,000) (100,000) - (150,000) (200,000) (240,000) (1,170,000) (100,000) (250,000) (150,000) (200,000) (200,000) - (900,000) (100,000) (100,000) (100,000) (100,000) - - - (500,000) (815,000)$ (1,765,000)$ (850,000)$ (600,000)$ (580,000)$ (600,000)$ (1,110,000)$ (7,570,000)$ DRAFT 79 THIS PAGE IS LEFT BLANK INTENTIONALLY DRAFT 80 Appendix B INTERNAL SERVICE SUMMARY SCHEDULE DRAFT 81 City of Crystal, Minnesota Internal Service Summary Schedule 2020 2021 2022 Allocation to: Building -$ 1,323,091$ 1,467,403$ Fleet - 336,540 341,585 IT 604,332 552,919 554,792 Total Allocations IN 604,332 2,212,550 2,363,780 Allocation from: General Mayor and Council 220 12,419 13,135 Administration 43,755 81,234 88,088 Human resources 6,563 9,525 10,037 Assessing 46,158 50,488 53,225 Legal - 1,957 2,301 Election - 11,079 13,152 Finance 44,123 50,568 53,019 Police 205,428 595,427 656,476 Fire 855 107,707 117,460 Engineering 1,265 24,990 27,701 Street Maintenance 14,195 250,393 257,770 Park Maintenance 30,160 201,790 205,654 Forestry - 3,839 4,273 Community Center 7,395 266,552 276,938 Pool 14,085 84,466 85,343 EDA - 4,568 5,186 Community Development 65,059 68,630 67,807 Recreation 32,379 64,555 69,961 Total General Fund 511,420 1,890,188 2,007,526 Water 54,918 123,887 126,768 Sewer 74,384 156,964 158,509 Storm 30,474 82,331 70,977 Street Lights 9,180 1,773 - Total Enterprise Fund 168,956 364,955 356,254 DRAFT 82