Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2023.11.09 Work Session Packet
4141 Douglas Drive North • Crystal, Minnesota 55422-1696 Tel: (763) 531-1000 • Fax: (763) 531-1188 • www.crystalmn.gov Posted: Nov. 3, 2023 City Council Work Session Agenda Thursday, Nov. 9, 2023 6:30 p.m. Community Room (upper)/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, Nov. 9, 2023, at ______ p.m. in the upper Community Room 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 Nov. 9, 2023 Work Session. I. Attendance Council members Staff ____ Kiser ____ Bell ____ Onesirosan ____ Gilchrist ____ Adams ____ Therres ____ Budziszewski ____ Bursheim ____ Cummings ____ Elholm ____ Eidbo ____ Larson ____ Kamish ____ McGann ____ Ray ____ Revering ____ Sutter ____ Serres II. Agenda The purpose of the work session is to discuss the following agenda items: 1. Commission candidate interviews. 2. 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: Nov. 3, 2023 City of Crystal Notice of Nov. 9, 2023 Work Session NOTICE IS HEREBY GIVEN that the City Council of the City of Crystal will hold a work session on Thursday, Nov. 9, 2023, at 6:30 p.m. in the upper Community Room 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 below. Topic: Crystal City Council Work Session Time: Nov. 9, 2023 at 6:30 p.m. Central Time (US and Canada) Join Zoom Meeting https://us02web.zoom.us/j/86279126251?pwd=US9HMjc4UTNEWTVDTkw4YXFDQmowZz09 Meeting ID: 862 7912 6251 Passcode: 414141 One tap mobile: +19292056099,86279126251#,,,,*414141# US (New York) +13017158592,86279126251#,,,,*414141# US (Washington DC) Dial by your location: +1 929 205 6099 US (New York) +1 301 715 8592 US (Washington DC) +1 305 224 1968 US +1 309 205 3325 US +1 312 626 6799 US (Chicago) +1 646 931 3860 US +1 253 215 8782 US (Tacoma) +1 346 248 7799 US (Houston) +1 360 209 5623 US +1 386 347 5053 US +1 507 473 4847 US +1 564 217 2000 US +1 669 444 9171 US +1 669 900 6833 US (San Jose) +1 689 278 1000 US +1 719 359 4580 US +1 253 205 0468 US Find your local number: https://us02web.zoom.us/u/kc3oOQrl8R 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. Memorandum DATE: November 1, 2023 TO: Mayor and City Council FROM: Adam R. Bell, City Manager SUBJECT: Commission Interviews ____________________________________________________________________ The city has recruited for commission openings and staff received three applications for new appointments. The following interviews are scheduled for the Council work session on Nov. 9, 2023: Interview Time Applicant Board/Commission 6:30 p.m.; in-person Kassidy Swanson Parks and Recreation Commission or Environmental Quality Commission 6:40 p.m.; in-person Tony Sumnicht Planning Commission 6:50 p.m.; in-person Joe Sears Metro Blue Line Community Advisory A recommendation sheet will be available at the work session. Long Term Plan City of Crystal Crystal, Minnesota October 31, 2023 City of Crystal, Minnesota Long Term Plan Table of Contents Page No. Compilation Disclosure 3 Introductory Section Transmittal Letter 5 Financial Section General Fund 8 EDA Fund 12 Schedule of Property Taxes Levied and Tax Rates 14 Schedule of Annual Fund Cash Balances 16 Outstanding Debt Schedule 16 Capital Improvement Plan Street Capital Fund 415 Schedule of Planned Capital Outlay 2019 to 2030 18 Schedule of Projected Revenue, Expenditures and Debt 22 Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2019 to 2030 24 Schedule of Projected Revenue, Expenditures and Debt 26 Park Improvements 420 Schedule of Planned Capital Outlay 2019 to 2030 28 Schedule of Projected Revenue, Expenditures and Debt 32 Water Fund 505 Schedule of Planned Capital Outlay 2019 to 2030 34 Statement of Cash Flows 36 Sanitary Sewer Fund 510 Schedule of Planned Capital Outlay 2019 to 2030 38 Statement of Cash Flows 38 Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2019 to 2030 40 Statement of Cash Flows 40 Street Light Fund 520 Schedule of Planned Capital Outlay 2019 to 2030 42 Statement of Cash Flows 42 Fleet Fund 615 Schedule of Planned Capital Outlay 2019 to 2030 44 Statement of Cash Flows 48 Major Building Replacement Fund 408/625 Schedule of Planned Capital Outlay 2019 to 2030 50 Information Technology Fund 620 Schedule of Planned Capital Outlay 2019 to 2030 54 Statement of Cash Flows 58 2 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, 2033, for all presented funds. This forecast was compiled in accordance with attestation standards established by the American Institute of Certified Public Accountants. A compilation is limited to presenting in the form of forecast information that is the representation of management and does not include evaluation of the support for the assumptions underlying the forecast. We have not examined the forecast and, accordingly, do not express an opinion or any other form of assurance on the accompanying statements or assumptions. Furthermore, there will usually be differences between the forecasted and actual results because events and circumstances frequently do not occur as expected, and those differences may be material. We have no responsibility to update this report for events and circumstances occurring after the date of this report. Sincerely, Abdo Financial Solutions 3 INTRODUCTORY SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 4 Honorable Mayor and City Council City of Crystal 4141 Douglas Drive North Crystal, Minnesota 55422 Introduction The City’s long-term plan 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: Interest Earnings 1.00% Governmental Fund Other Revenue Growth 3.00% Governmental Fund Expenditure Growth 6.00% EDA expenditure Growth (assumption for home improvement grant program) 5.00% Water Revenue Growth 7.00% Sewer Revenue Growth 7.00% Storm Drainage 1 Revenue Growth Varies Street Lighting Revenue Growth 7.00% Enterprise Expenditure Growth 3.00% Internal Service Funds Revenue Growth 6.00% Internal Service Funds Expenditure Growth 6.00% General Fund Levy Growth varies Street Fund Levy Growth 15.00% PERF Fund Levy Growth 2.00% Parks Improvement Fund Levy Growth 13.00% EDA Fund Levy Growth varies Population Growth 0.30% Median Home Value Growth 5.00% Fiscal Disparity Growth Rate 0.00% Tax Capacity Growth Rate 4.00% Market Value 3.00% Governmental Fund Debt Interest Rate 3.00% Governmental Fund Debt Term 15 5 Assumptions with Future Action •General Fund property tax revenue has been increased based on the results of the long-term plan, Park System Master Plan, increased funding for capital projects, and inflation. •The Building Fund 625 and the Information Technology Fund 620 will receive internal loans to maintain positive cash flow while it builds reserves over the next several years. •All internal service funds (Fleet, Building and Information Technology) will require allocation increases over the next several years to build reserves. Key Highlights •The Minnesota Office of the State Auditor defines an adequate reserve as 35-50 percent of the General fund expenditures. The long-term plans projects planned transfers to build reserves to meet that target. In order to increase the General Fund reserve level, additional funding is projected in the property tax levy to include transfers into reserves. •The tax levy is projected to increase over the duration of this Plan to meet the service level demands and other capital levy needs. The levy increase will result in an increase in the projected city tax rate. A decrease in the tax levy or applicable tax rate is not anticipated, given the capital needs outlined in our report. •Total debt outstanding is projected to decrease from $9.6 million (2022 actual) to $280,000 (2032 projected) over the duration of this Plan. As a result, the debt per capita will fall from an estimated $425 (2022 actual) per household to an estimated $12 (2032 projected) over the duration of this Plan. •The total cash position of the city is projected to increase from $29.0 million (2022 actual) to $52.9 million over the duration of this Plan. •The projected cash results throughout the duration of this plan will vary based on actual results. 6 FINANCIAL SECTION CITY OF CRYSTAL, MINNESOTA LONG TERM PLAN 7 General Fund 2022 2023 2024 2025 2026 Actual Adopted Proposed Planned Planned Other revenue 3,734,332$ 3,769,129$ 5,467,087$ 5,631,100$ 5,800,033$ Property tax levy (GF) 12,488,689 13,697,548 14,818,719 16,880,086 18,940,222 Property tax levy delinquents and penalties 73,500 73,500 73,500 Transfers in 505,214 671,295 711,601 732,949 754,938 Expenditures (17,985,680) (18,137,972) (20,582,674) (22,517,634) (24,568,693) Transfers out - (to Fund Balance)(488,233) (800,000) (1,000,000) Net revenue/(expenses)(1,257,445)$ -$ -$ 0$ -$ Total Fund Balance 6,512,093$ 6,512,093$ 7,000,326$ 7,800,326$ 8,800,326$ Less: Nonspendable and committed funds (953,294)$ (953,294)$ (953,294)$ (953,294)$ (953,294)$ Unassigned Fund Balance 5,558,799$ 5,558,799$ 6,047,032$ 6,847,032$ 7,847,032$ % of Unassigned Fund Balance to next years budget (Policy)31%27%27%28%30% % of Unassigned Fund Balance to same year (OSA)31%31%29%30%32% % Levy Increase (GF only)4%10%8%14%12% Policy - Target Fund Balance (45%) next years budget 8,162,087$ 9,262,203$ 10,132,935$ 11,055,912$ 11,944,266$ OSA - Target Fund Balance (35%) same years expenditures 6,294,988$ 6,348,290$ 7,374,817$ 8,161,172$ 8,949,042$ Budget 17,103,583 18,137,972 20,582,674 22,517,634 24,568,693 Unassigned Fund Balance Over / (Under) Policy Target (45%)(2,603,288)$ (3,703,404)$ (4,085,903)$ (4,208,880)$ (4,097,234)$ Unassigned Fund Balance Over / (Under) OSA (35%)(736,189)$ (789,491)$ (1,327,785)$ (1,314,140)$ (1,102,010)$ % of Total Fund Balance based on budget 36%31%30%31%32% Other Revenue Growth Percentage 5%1%45%3%3% Expenditure Growth Percentage 8%1%13%9%9% 8 2027 2028 2029 2030 2031 2032 2033 2034 Planned Planned Planned Planned Planned Planned Planned Planned 5,974,034$ 6,153,255$ 6,337,852$ 6,527,988$ 6,723,827$ 6,925,542$ 7,133,309$ 7,347,308$ 20,717,695 22,007,715 23,449,213 25,061,460 26,825,388 28,672,291 30,633,848 32,717,142 73,500 73,500 73,500 73,500 73,500 73,500 73,500 73,500 777,586 800,913 824,941 849,689 875,179 901,435 928,478 956,332 (26,542,814) (28,335,383) (30,035,506) (31,837,636) (33,747,894) (35,772,768) (37,919,134) (40,194,282) (1,000,000) (700,000) (650,000) (675,000) (750,000) (800,000) (850,000) (900,000) -$ -$ -$ -$ -$ -$ 0$ 0$ 9,800,326$ 10,500,326$ 11,150,326$ 11,825,326$ 12,575,326$ 13,375,326$ 14,225,326$ 15,125,326$ (953,294)$ (953,294)$ (953,294)$ (953,294)$ (953,294)$ (953,294)$ (953,294)$ (953,294)$ 8,847,032$ 9,547,032$ 10,197,032$ 10,872,032$ 11,622,032$ 12,422,032$ 13,272,032$ 14,172,032$ 31%32%32%32%32%33%33%32% 33%34%34%34%34%35%35%35% 9%6%7%7%7%7%7%7% 12,750,922$ 13,515,978$ 14,326,936$ 15,186,552$ 16,097,746$ 17,063,610$ 18,087,427$ 19,941,388$ 9,639,985$ 10,162,384$ 10,739,927$ 11,379,423$ 12,074,263$ 12,800,469$ 13,569,197$ 14,382,999$ 26,542,814 28,335,383 30,035,506 31,837,636 33,747,894 35,772,768 37,919,134 40,194,282 (3,903,890)$ (3,968,946)$ (4,129,904)$ (4,314,520)$ (4,475,714)$ (4,641,578)$ (4,815,395)$ (5,769,356)$ (792,953)$ (615,352)$ (542,895)$ (507,391)$ (452,231)$ (378,437)$ (297,165)$ (210,967)$ 34%34%34%34%34%34%35%36% 3%3%3%3%3%3%3%3% 8%7%6%6%6%6%6%6% 9 EDA - Fund 220 2022 2023 2024 2025 2026 Actual Adopted Proposed Planned Planned Property tax levy 311,726$ 316,200$ 335,172$ 365,337$ 560,620$ Special Assessment 32,839$ 32,834$ 32,834$ 12,834$ 12,834$ Intergovernmental 12,500$ 26,800$ 28,140$ 29,547$ Other revenue (37,138) 8,000 8,000 8,240 8,487 Operating expenses (397,374) (357,923) (401,513) (421,589) (442,668) Debt service - - - - - Capital improvements - - - - - Net revenue/(expenses)(77,447)$ (889)$ 1,293$ (7,038)$ 168,820$ 3.40%1.44%6.00%9.00%53.45% 10 2027 2028 2029 2030 2031 2032 2033 Planned Planned Planned Planned Planned Planned Planned 577,439$ 594,762$ 612,605$ 630,983$ 649,912$ 669,410$ 689,492$ 31,024$ 32,576$ 383,369$ 402,537$ 422,664$ 443,798$ 465,987$ 8,742 9,004 9,274 9,552 9,839 10,134 10,438 (464,801) (488,042) (863,865) (907,058) (952,411) (1,000,031) (1,050,033) - - - - - - - - - - - - - - 152,403$ 148,300$ 141,383$ 136,015$ 130,005$ 123,310$ 115,885$ 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 11 2022 2023 2024 2025 2026 Actual Actual Estimated Estimated Estimated Property Taxes Levied for General Purposes 100 General 12,508,518$ 13,540,205$ 14,818,719$ 16,880,086$ 18,940,222$ 220 EDA/HRA 310,000 316,200 335,172 365,337 560,620 415 Street Capital 245,926 384,221 529,047 608,404 699,665 235 PERF Fund 158,037 161,197 92,211 94,055 95,936 420 Park Improvements 606,999 741,057 882,753 997,511 1,127,187 Total Taxes Levied 13,829,480 15,142,880 16,657,902 18,945,393 21,423,631 Percent Levy Increase 5.27%9.50%10.00%13.73%13.08% Less: Value of Market Value Levies (EDA/HRA)(310,000) (316,200) (335,172) (365,337) (560,620) Less: Distribution from fiscal disparities (2,572,319) (2,250,315) (2,368,451) (2,368,451) (2,368,451) City Net Levy 10,947,161$ 12,576,365$ 13,954,279$ 16,211,605$ 18,494,560$ Tax Capacity (For taxes payable year) Total Tax Capacity 25,586,218$ 28,993,403$ 30,922,687$ 32,159,594$ 33,757,052$ Percentage Growth 8.33%13.32%6.65%4.00%4.97% Other assumed net growth factors - - - - - Less: Contribution to fiscal disparities (1,661,902) (1,594,724) (1,707,733) (1,707,733) (1,707,733) Less: Tax Increment (288,561) (311,074) (311,074) (311,074) - Adjusted net tax capacity 23,635,755$ 27,087,605$ 28,903,880$ 30,140,788$ 32,049,319$ Market Value (for taxes payable year) Market Value - Referendum (for Tax rates)2,381,758,850$ 2,680,895,400$ 2,828,794,700$ 2,913,658,541$ 3,001,068,297$ Percentage Growth 8.59%12.56%5.52%3.00%3.00% Market Value - Estimated (for Max EDA/HRA Levy)2,402,167,100$ 2,708,020,400$ 2,856,423,000$ 2,942,115,690$ 3,030,379,161$ Percentage Growth 8.50%12.73%5.48%3.00%3.00% Fiscal Disparity Distribution Tax Capacity 5,317,895.00 4,858,508.00 5,101,231.00 5,101,231 5,101,231 Fiscal Disparity Distribution (tax $)60,411.00 51,306.00 49,890.00 49,890 49,890 Maximum EDA/HRA Levy 444,401 500,984 528,438 544,291 560,620 2022 2023 2024 2025 2026 Actual Actual Estimated Estimated Estimated Tax Rates General 42.85%49.99%43.83%48.87%52.39% Capital levies 3.46%4.03%4.45%4.92%5.32% Scheduled debt levies 0.00%0.00%0.00%0.00%0.00% Total City Levy Tax Rate 46.32%46.43%48.28%53.79%57.71% Total EDA Tax Rate 1.056%0.978%0.987%1.047%1.594% Population 24,739 22,791 22,859 22,928 22,997 Taxes per Capita 559$ 664$ 729$ 826$ 932$ Tax Levy (%) General 90%89%89%89%88% Economic Development Authority 2%2%2%2%3% Capital 7%8%9%9%9% Debt Service 0%0%0%0%0% City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates For the Years Ended December 31, 2022 (Actual) and 2023 to 2033 (Planned) City of Crystal, Minnesota Schedule of Property Taxes Levied and Tax Rates (Continued) For the Years Ended December 31, 2022 (Actual) and 2023 to 2033 (Planned) 12 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated 20,717,695$ 22,007,715$ 23,449,213$ 25,061,460$ 26,825,388$ 28,672,291$ 30,633,848$ 577,439 594,762 612,605 630,983 649,912 669,410 689,492 804,614 925,307 1,064,102 1,223,718 1,407,276 1,618,367 1,861,122 97,855 99,812 101,808 103,845 105,921 108,040 110,201 1,273,722 1,439,305 1,626,415 1,837,849 2,076,770 2,346,750 2,651,827 23,471,325 25,066,901 26,854,144 28,857,854 31,065,266 33,414,857 35,946,489 9.56%6.80%7.13%7.46%7.65%7.56%7.58% (577,439) (594,762) (612,605) (630,983) (649,912) (669,410) (689,492) (2,368,451) (2,368,451) (2,368,451) (2,368,451) (2,368,451) (2,368,451) (2,368,451) 20,525,435$ 22,103,688$ 23,873,088$ 25,858,420$ 28,046,903$ 30,376,996$ 32,888,546$ 35,107,334$ 36,511,628$ 37,972,093$ 39,490,977$ 41,070,616$ 42,713,440$ 44,421,978$ 4.00%4.00%4.00%4.00%4.00%4.00%4.00% - - - - - - - (1,707,733) (1,707,733) (1,707,733) (1,707,733) (1,707,733) (1,707,733) (1,707,733) - - - - - - - 33,399,601$ 34,803,895$ 36,264,360$ 37,783,244$ 39,362,883$ 41,005,707$ 42,714,245$ 3,091,100,346$ 3,183,833,357$ 3,279,348,357$ 3,377,728,808$ 3,479,060,672$ 3,583,432,492$ 3,690,935,467$ 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 3,121,290,536$ 3,214,929,252$ 3,311,377,129$ 3,410,718,443$ 3,513,039,996$ 3,618,431,196$ 3,726,984,132$ 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 5,101,231 5,101,231 5,101,231 5,101,231 5,101,231 5,101,231 5,101,231 49,890 49,890 49,890 49,890 49,890 49,890 49,890 577,439 594,762 612,605 630,983 649,912 669,410 689,492 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated 55.61%57.11%58.83%60.76%62.84%64.87%66.90% 5.84%6.40%7.00%7.67%8.41%9.21%10.10% 0.00%0.00%0.00%0.00%0.00%0.00%0.00% 61.45%63.51%65.83%68.44%71.25%74.08%77.00% 1.580%1.566%1.552%1.538%1.524%1.511%1.497% 23,066 23,135 23,204 23,274 23,344 23,414 23,484 1,018$ 1,084$ 1,157$ 1,240$ 1,331$ 1,427$ 1,531$ 88%88%87%87%86%86%85% 2%2%2%2%2%2%2% 9%10%10%11%12%12%13% 0%0%0%0%0%0%0% 13 2022 2023 2024 2025 2026 Actual Budget Estimated Estimated Estimated Government-Type General Operations 101 General 7,142,070$ 7,142,070$ 7,142,070$ 7,142,070$ 7,142,070$ Special Revenue 220 Economic Development Authority 1,971,841 1,970,952 1,972,245 1,965,207 2,134,028 *206-210 TIF Districts Special Revenue 898,933 907,922 917,002 926,172 935,433 *240-245 Special Projects 189,709 189,710 189,711 189,712 189,713 Subtotal 3,060,483 3,068,584 3,078,957 3,081,091 3,259,174 Debt Service 330-337 Debt Service 4,038,725 3,833,657 3,955,500 3,612,459 3,233,028 Capital Projects 415 Street Reconstruction 1,637,277 4,316,591 4,374,357 2,659,951 2,306,122 235 Police Equipment Revolving 1,613,600 1,570,785 993,281 1,054,673 993,960 420 Park Improvement 1,291,162 775,219 887,972 1,419,363 415,744 *404 Cable TV Equipment 299,823 302,821 305,849 308,908 311,997 Subtotal 4,841,862 6,965,416 6,561,459 5,442,895 4,027,823 Total - Governmental-type Funds 19,083,140 21,009,727 20,737,986 19,278,515 17,662,094 Internal Service 620 Information Technology - (273,824) (645,336) 409,180 641,361 625 Building 2,592,613 2,267,483 (2,735,472) 325,516 328,678 615 Fleet 2,668,995 1,589,953 1,475,496 536,000 754,534 *605 Self Insurance 356,411 359,975 363,575 367,211 370,883 Total - Internal Service-type Funds 5,618,019 3,943,588 (1,541,737) 1,637,906 2,095,455 Business-Type Business-Type Enterprise Funds 505 Water 1,700,754 2,169,005 1,949,303 465,262 812,990 510 Sewer 504,001 567,240 557,895 271,026 560,023 515 Storm Drainage 850,152 1,528,146 2,087,962 331,512 1,283,276 520 Street Lights 859,123 897,573 942,620 968,755 1,002,427 *525 Recycling 127,514 128,789 130,077 131,378 132,692 Total - Business-type Funds 4,041,544 5,290,753 5,667,857 2,167,932 3,791,408 Agency Fund *250 Hennepin Recycling Group 428,417 432,701 437,028 441,398 445,812 Grand Total - City 29,171,120$ 30,676,769$ 25,301,135$ 23,525,752$ 23,994,770$ * Trend indicator Adequate for reserve levels Adequate as of 2022 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, 2022 (Actual) and 2023 to 2033 (Planned) 14 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Trend 7,142,070$ 7,142,070$ 7,142,070$ 7,142,070$ 7,142,070$ 7,142,070$ 7,142,070$ 2,286,431 2,434,731 2,576,114 2,712,129 2,842,134 2,965,444 3,081,329 675,817 353,363 - - - - - 189,714 189,715 189,716 189,717 189,718 189,719 189,720 3,151,962 2,977,809 2,765,830 2,901,846 3,031,852 3,155,163 3,271,049 2,896,452 2,531,846 2,150,891 1,988,600 1,621,312 1,404,980 1,194,975 169,765 761,130 1,656,114 2,470,192 4,174,408 4,638,603 5,348,442 933,959 621,394 354,101 301,954 595,895 919,894 1,009,293 123,623 224,165 (107,179) 469,599 836,064 1,576,174 3,718,763 315,117 318,268 321,451 324,665 327,912 331,191 334,503 1,542,464 1,924,957 2,224,487 3,566,410 5,934,279 7,465,862 10,411,005 14,732,947 14,576,682 14,283,278 15,598,926 17,729,513 19,168,075 22,019,098 553,125 494,376 422,269 347,174 305,330 289,865 563,758 805,686 1,033,207 529,112 (344,110) 829,125 1,479,053 3,995,738 141,075 1,049,905 1,776,865 2,395,118 3,331,258 4,705,591 6,314,350 374,592 378,337 382,121 385,942 389,801 393,699 397,636 1,874,477 2,955,825 3,110,367 2,784,124 4,855,513 6,868,208 11,271,482 1,254,286 1,815,798 2,605,579 3,603,984 5,377,474 7,554,567 10,265,022 1,133,626 1,409,851 2,101,533 2,779,755 3,612,514 4,920,771 6,565,238 1,699,200 2,777,004 2,076,539 1,763,432 583,529 213,184 1,665,153 44,425 85,603 136,786 198,978 298,266 411,076 524,202 134,019 135,359 136,713 138,080 139,460 140,855 142,264 4,265,557 6,223,616 7,057,150 8,484,229 10,011,244 13,240,453 19,161,879 450,271 454,773 459,321 463,914 468,553 473,239 477,971 21,323,251$ 24,210,896$ 24,910,116$ 27,331,193$ 33,064,823$ 39,749,975$ 52,930,430$ 15 2022 2023 2024 Original Issue Maturity Interest Actual Estimated Estimated Fund Issue Issue Date Date Rate 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 %160,000$ -$ -$ 332 2011A Special Assessment 1,705,000 7/19/2011 2/1/2027 0.50 - 3.55 470,000 370,000 270,000 333 2012A Special Assessment 2,635,000 7/16/2013 2/1/2028 0.50 - 3.55 915,000 750,000 590,000 334 2013A Special Assessment 3,235,000 6/17/2015 2/1/2029 0.50 - 3.55 1,390,000 1,180,000 975,000 335 2015A Special Assessment 2,550,000 7/16/2015 2/1/2031 2.50 - 3.00 1,400,000 1,230,000 1,065,000 336 2016A Special Assessment 3,330,000 8/25/2016 2/1/2032 2.00 - 2.50 2,075,000 1,845,000 1,620,000 337 2017A Special Assessment 4,665,000 9/14/2017 2/1/2033 2.00 - 3.00 3,280,000 2,965,000 2,655,000 Total G.O. Tax Bonds 29,360,000 9,690,000 8,340,000 7,175,000 Total Government-Type 29,360,000$ 9,690,000$ 8,340,000$ 7,175,000$ Population 22,791 22,859 22,928 Debt Per Capita - Total 425$ 365$ 313$ City of Crystal, Minnesota Outstanding Debt Schedule For the Years Ended December 31, 2022 (Actual) and 2023 to 2033 (Estimated) 16 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Balance Balance Balance Balance Balance Balance Balance Balance Balance -$ -$ -$ -$ -$ -$ -$ -$ -$ 175,000 85,000 - - - - - - - 435,000 285,000 140,000 - - - - - - 770,000 570,000 375,000 185,000 - - - - - 900,000 740,000 585,000 435,000 285,000 140,000 - - - 1,400,000 1,185,000 975,000 770,000 570,000 375,000 185,000 - - 2,345,000 2,040,000 1,740,000 1,440,000 1,145,000 855,000 565,000 280,000 - 6,025,000 4,905,000 3,815,000 2,830,000 2,000,000 1,370,000 750,000 280,000 - 6,025,000$ 4,905,000$ 3,815,000$ 2,830,000$ 2,000,000$ 1,370,000$ 750,000$ 280,000$ -$ 22,997 23,066 23,135 23,204 23,274 23,344 23,414 23,484 23,554 262$ 213$ 165$ 122$ 86$ 59$ 32$ 12$ -$ 17 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Estimated 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 Railroad repair 75,000 - 75,000 Public works 0415.6305 TBA 2024 Contract mill and overlay 1,120,000 - 1,120,000 Public works 0415.6305 TBA 2024 In house mill and overlay 60,775 - 60,775 Public works 0415.6305 TBA 2024 Sidewalk shaving (trip hazard removal)20,000 - 20,000 Public works 0415.6305 TBA 2024 Misc concrete work 61,903 - 61,903 Public works 0415.6305 TBA 2024 ADA Ped Ramp replacements 45,020 - 45,020 Public works 0415.6305 TBA 2024 Utility Reconstruction 300,000 - 300,000 Public works 0415.6305 TBA 2025 36th Ave Recon & Regent mini-RB 750,000 - - Public works 0415.6305 TBA 2025 Body cameras 47,100 - - 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 21,072 - - 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 21,072 - - 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 1,000,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 2023 to 2033 18 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 750,000 - - - - - - - - 47,100 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 21,072 - - - - - - - - 300,000 - - - - - - - - - 300,000 - - - - - - - - 21,072 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 200,000 - - - - - - - - - 2,000,000 - - - - - - - - 1,000,000 - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - 19 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Estimated Public works 0415.6305 TBA 2028 In house mill and overlay 21,072$ -$ -$ 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,902 - - 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,902 - - 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,902 - - 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 - - Public works 0415.6305 TBA 2032 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2032 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2032 Misc concrete work 61,902 - - Public works 0415.6305 TBA 2032 Crack sealing 10,000 - - Public works 0415.6305 TBA 2032 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2032 Contract mill and overlay 1,230,000 - - Public works 0415.6305 TBA 2032 Utility Reconstruction 300,000 - - Public works 0415.6305 TBA 2033 In house mill and overlay 60,775 - - Public works 0415.6305 TBA 2033 Sidewalk shaving (trip hazard removal)20,000 - - Public works 0415.6305 TBA 2033 Misc concrete work 61,903 - - Public works 0415.6305 TBA 2033 Crack sealing 10,000 - - Public works 0415.6305 TBA 2033 ADA Ped Ramp replacements 45,020 - - Public works 0415.6305 TBA 2033 Contract mill and overlay 1,230,000 - - Public works 0415.6305 TBA 2033 Utility Reconstruction 300,000 - - 1,369,699$ 1,682,699$ City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Planned Capital Outlay 2020 to 2032 (Continued) 20 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated -$ -$ -$ 21,072$ -$ -$ -$ -$ -$ - - - 20,000 - - - - - - - - 61,903 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,902 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 882,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,902 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 1,230,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,902 - - - - - - - - 10,000 - - - - - - - - 45,020 - - - - - - - - 1,230,000 - - - - - - - - 300,000 - - - - - - - - - 60,775 - - - - - - - - 20,000 - - - - - - - - 61,902 - - - - - - - - 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,305,871$ 1,529,995$ 4,069,699$ 1,339,995$ 1,379,697$ 1,727,697$ 1,727,697$ 1,727,697$ 1,727,698$ 21 2023 2024 Actual/Budgeted Estimated Revenues Property taxes 384,221$ 529,047$ Special assessments 316,819 230,000 Interest on investments 25,000 25,000 Franchise fees - - Miscellaneous 47,880 - Total Revenues 773,920 784,047 Expenditures Operations 18,332 Capital 1,369,699 1,682,699 Total Expenditures 1,369,699 1,701,031 Excess (Deficiency) of Revenues Over (Under) Expenditures (595,779) (916,984) Other Financing Sources Transfers in - - Intergovernmental revenue (Municipal State Aid - MSA)3,075,092 274,750 Bond proceeds - - Sale of Fixed Asset - - Total Other Financing Sources 3,075,092 274,750 Net Change in Fund Balances 2,479,313 (642,234) Cash Balance, January 1 1,637,277 4,316,591 Advance to/from building fund 200,000 700,000 Advance to/from IT fund Cash Balances, December 31 4,316,591$ 4,374,357$ City of Crystal, Minnesota Capital Improvement Plan - Street Capital Fund 415 Schedule of Projected Revenue, Expenditures and Debt Capital Project Fund Projected Activity 22 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 608,404$ 699,665$ 804,614$ 925,307$ 1,064,102$ 1,223,718$ 1,407,276$ 1,618,367$ 1,861,122$ 166,500 166,500 166,500 166,500 166,500 166,500 166,500 43,744 26,600 23,061 1,698 7,611 16,561 24,702 41,744 46,386 - - - - - - - - - - - - - - - - 818,648 892,764 994,176 1,093,504 1,238,214 1,406,779 1,598,477 1,660,111 1,907,508 19,432 20,598 21,834 23,144 24,533 26,005 27,565 29,219 30,972 1,305,871 1,529,995 4,069,699 1,339,995 1,379,697 1,727,697 1,727,697 1,727,697 1,727,698 1,325,303 1,550,593 4,091,533 1,363,139 1,404,230 1,753,702 1,755,262 1,756,916 1,758,670 (506,655) (657,829) (3,097,357) (269,635) (166,016) (346,923) (156,784) (96,805) 148,838 - - - - - - - 292,250 304,000 311,000 311,000 311,000 311,000 311,000 311,000 311,001 - - - - - - - - - - - - - - - - 292,250 304,000 311,000 311,000 311,000 311,000 311,000 311,000 311,001 (214,405) (353,829) (2,786,357) 41,365 144,984 (35,923) 154,216 214,195 459,839 4,374,357 2,659,951 2,306,122 169,765 761,130 1,656,114 2,470,192 4,174,408 4,638,603 500,000 500,000 400,000 300,000 500,000 600,000 1,300,000 - (2,000,000) (500,000) 250,000 250,000 250,000 250,000 250,000 250,000 250,000 2,659,951$ 2,306,122$ 169,765$ 761,130$ 1,656,114$ 2,470,192$ 4,174,408$ 4,638,603$ 5,348,442$ Capital Project Fund Projected Activity 23 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Estimated 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 21,072 21,072 - Police 3500.6930 N/A 2023 Tactical vests ($4,100 each)8,200 8,200 - Police 3500.6930 N/A 2024 Ballistic windows 229,000 - 229,000 Police 3500.6930 N/A 2024 Body cameras 21,072 - 21,072 Police 3500.6930 N/A 2024 Lease Vehicle (5) and Equipment 241,116 - 241,116 Police 3500.6930 N/A 2024 Mobile data tablets ($5,000 each)15,000$ - 3,607 Police 3500.6930 N/A 2024 Bulletproof vests - mass replacement ($1,800 a piece)7,200 - 7,200 Police 3500.6930 N/A 2025 Body cameras 24,000 - - Police 3500.6930 N/A 2024 Tactical vests ($5,300 each)10,600 - 10,600 Police 3500.6930 N/A 2024 2024 Sprinter Raid Van 175,000 - 175,000 Police 3500.6930 N/A 2025 Bulletproof vests - mass replacement ($1,800 a piece)19,800 - - 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 ($5,300 each)10,600 - - Police 3500.6930 N/A 2026 Bulletproof vests - mass replacement ($1,800 a piece)10,800 - - Police 3500.6930 N/A 2026 Lease Vehicle (10) and Equipment 241,116 - - 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 ($5,300 each)10,600 - - Police 3500.6930 N/A 2027 Bulletproof vests - mass replacement ($1,800 a piece)1,800 - - 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 ($5,300 each)10,600 - - 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 30,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 ($5,300 each)10,600 - - Police 3500.6930 N/A 2029 Body cameras 30,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 ($4,100 each)8,200 - - Police 3500.6930 N/A 2029 Police Bicycles (3)6,000 - - Police 3500.6930 N/A 2030 Body cameras 30,000 - - Police 3500.6930 N/A 2030 Estimate based on average 294,532 - - Police 3500.6930 N/A 2031 Body cameras 30,000 - - Police 3500.6930 N/A 2032 Body cameras 30,000 - - Police 3500.6930 N/A 2033 Body cameras 30,000 - - 219,012$ 687,595$ City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 Schedule of Planned Capital Outlay 2023 to 2033 24 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 24,000 - - - - - - - - - - - - - - - - - - - - - - - - - - 19,800 - - - - - - - - 241,116 - - - - - - - - 20,000 - - - - - - - - 10,600 - - - - - - - - - 10,800 - - - - - - - - 241,116 - - - - - - - - 15,000 - - - - - - - - 24,000 - - - - - - - - 10,600 - - - - - - - - - 1,800 - - - - - - - - 241,116 - - - - - - - - 24,000 - - - - - - - - 5,000 - - - - - - - - 10,000 - - - - - - - - 10,600 - - - - - - - - 6,000 - - - - - - - - - 241,116 - - - - - - - - 75,000 - - - - - - - - 30,000 - - - - - - - - 15,000 - - - - - - - - 15,000 - - - - - - - - 150,000 - - - - - - - - 10,600 - - - - - - - - - 30,000 - - - - - - - - 241,116 - - - - - - - - 20,000 - - - - - - - - 55,000 - - - - - - - - 30,000 - - - - - - - - 8,200 - - - - - - - - 6,000 - - - - - - - - - 30,000 - - - - - - - - 294,532 - - - - - - - - - 30,000 - - - - - - - - - 30,000 - - - - - - - - - 30,000 315,516$ 301,516$ 298,516$ 536,716$ 390,316$ 324,532$ 30,000$ 30,000$ 30,000$ 25 2023 2024 Budgeted Estimated Revenues Property taxes 161,197$ 92,211$ Interest on investments 15,000 15,000 Miscellaneous - 2,880 Total Revenues 176,197 110,091 Expenditures Operations Capital 219,012 687,595 Total Expenditures 219,012 687,595 Excess (Deficiency) of Revenues Over (Under) Expenditures (42,815) (577,504) Other Financing Sources Transfer in - - Bond proceeds - - Sale of Fixed Asset - - Transfers out - - Total Other Financing Sources - - Net Change in Fund Balances (42,815) (577,504) Cash Balance, January 1 1,613,600 1,570,785 Internal Loan to Building Fund - Cash Balances, December 31 1,570,785$ 993,281$ Schedule of Projected Revenue, Expenditures and Debt Capital Project Fund Projected Activity City of Crystal, Minnesota Capital Improvement Plan - Police Equipment Revolving Fund 235 26 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 94,055$ 95,936$ 97,855$ 99,812$ 101,808$ 103,845$ 105,921$ 108,040$ 110,201$ 9,933 10,547 9,940 9,340 6,214 3,541 3,020 5,959 9,199 7,920 4,320 720 - - - - 111,908 110,803 108,515 109,152 108,022 107,386 108,941 113,999 119,400 315,516 301,516 298,516 536,716 390,316 324,532 30,000 30,000 30,000 315,516 301,516 298,516 536,716 390,316 324,532 30,000 30,000 30,000 (203,608) (190,713) (190,001) (427,564) (282,294) (217,147) 78,941 83,999 89,400 - - - - - - - - - - - - - - 15,000 15,000 15,000 15,000 15,000 15,000 15,000 - - - - - - - 15,000 15,000 15,000 15,000 15,000 15,000 15,000 - - (188,608) (175,713) (175,001) (412,564) (267,294) (202,147) 93,941 83,999 89,400 993,281 1,054,673 993,960 933,959 621,394 354,101 301,954 595,895 919,894 250,000 115,000 115,000 100,000 - 150,000 200,000 240,000 1,054,673$ 993,960$ 933,959$ 621,394$ 354,101$ 301,954$ 595,895$ 919,894$ 1,009,293$ Capital Project Fund Projected Activity 27 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Estimated 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 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 2024 Basketball court - Welcome 25,000 - 25,000 Recreation 0420.6938 TBA 2024 Garbage Can Pads - Becker Park 25,000 - 25,000 Recreation 0420.6937 TBA 2024 Hard Court Improvements 600,000 - 600,000 Recreation 0420.6937 TBA 2024 Valley Place Tennis Court Lights/Surfacing $425,000 - - - Recreation 0420.6938 TBA 2024 Basketball - Valley Place Park $75,000 - - - Recreation 0420.6937 TBA 2024 ALL Pavement (Sidewalks @ Trails)110,000 - 110,000 Recreation 0420.6937 TBA 2024 New Park Name Signage 15,000 - 15,000 Recreation 0420.6937 TBA 2025 Basketball Court - Cavanagh 25,000 - - Recreation 0420.6938 TBA 2025 New Park Signage 15,000 - - Recreation 0420.6937 TBA 2025 ALL Pavement (Sidewalks @ Trails)150,000 - - Recreation 0420.6937 TBA 2025 Picnic Shelter - Cavanagh 90,000 - - Recreation 0420.6937 TBA 2025 Play Area - Cavanaugh (2001)195,000 - - Recreation 0420.6937 TBA 2026 ALL Pavement (Sidewalks @ Trails)150,000 - - Recreation 0420.6937 TBA 2026 Basketball Court - Twin Oaks 25,000 - - Recreation 0420.6937 TBA 2026 Basketball - Bassett Creek Park 25,000 - - Recreation 0420.6937 TBA 2026 Sm. Picnic Shelter - Twin Oak 95,000 - - Recreation 0420.6937 TBA 2026 Community Park Building - Bassett Creek 1,600,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)200,000 - - Recreation 0420.6937 TBA 2027 Soccer Field - Bassett Creek 450,000 - - Recreation 0420.6937 TBA 2027 Parking Lot at Basset Creek Building 550,000 - - Recreation 0420.6937 TBA 2027 Play Area - Sunnyview (2000)200,000 - - Recreation 0420.6937 TBA 2027 Play Area - Lee (2000)200,000 - - Recreation 0420.6937 TBA 2027 Picnic Shelter - Lee 95,000 - - Recreation 0420.6937 TBA 2027 ALL Pavement (Sidewalks @ Trails)75,000 - - Recreation 0420.6937 TBA 2028 Play Area - Forest (2005)200,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 2023 to 2033 28 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 25,000 - - - - - - - - 15,000 - - - - - - - - 150,000 - - - - - - - - 90,000 - - - - - - - - 195,000 - - - - - - - - - 150,000 - - - - - - - - 25,000 - - - - - - - - 25,000 - - - - - - - - 95,000 - - - - - - - - 1,600,000 - - - - - - - - 50,000 - - - - - - - - 200,000 - - - - - - - - - 450,000 - - - - - - - - 550,000 - - - - - - - - 200,000 - - - - - - - - 200,000 - - - - - - - - 95,000 - - - - - - - - 75,000 - - - - - - - - - 200,000 - - - - - - - - 375,000 - - - - - - - - 185,000 - - - - - - - - 75,000 - - - - - - - - 160,000 - - - - - - - - 160,000 - - - - - - - - 25,000 - - - - - - - - 160,000 - - - - - - - - - 175,000 - - - - - - - - 75,000 - - - - 29 2023 2024 Cost Budgeted Estimated 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.00 - - Recreation 0420.6937 TBA 2030 Replace Play Area PIP Surfacing - Becker 150,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 Replace Play Area PIP Surfacing - Valley Place & Yunkers 60,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 2032 Replace Play Area PIP Surfacing - FAIR School 75,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 - - 1,262,000$ 775,000$ City of Crystal, Minnesota Capital Improvement Plan - Park Improvements 420 Schedule of Planned Capital Outlay 2020 to 2032 30 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - 1,500,000 - - - - - - - - 160,000 - - - - - - - - 50,000 - - - - - - - - - 100,000.00 - - - - - - - - 150,000 - - - - - - - - 15,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 350,000 - - - - - - - - 35,000 - - - - - - - - 185,000 - - - - - - - - 350,000 - - - - - - - - - 25,000 - - - - - - - - 80,000 - - - - - - - - 60,000 - - - - - - - - 50,000 - - - - - - - - 1,500,000 - - - - - - - - - 75,000 - - - - - - - - 185,000 - - - - - - - - 190,000 - - - - - - - - 530,000 - - - - - - - - 25,000 - - - - - - - - 350,000 - - - - - - - - 185,000 - - - - - - - - 75,000 - - - - - - - - - 75,000 - - - - - - - - 185,000 - - - - - - - - 185,000 - - - - - - - - 80,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 475,000$ 2,145,000$ 1,570,000$ 1,340,000$ 1,960,000$ 1,260,000$ 1,715,000$ 1,615,000$ 525,000$ 31 2023 2024 Budgeted Estimated Revenues Property taxes 741,057$ 882,753$ Interest on investments 5,000 5,000 Intergovernmental revenue - - Miscellaneous - - Total Revenues 746,057 887,753 Expenditures Operations Capital 1,262,000 775,000 Total Expenditures 1,262,000 775,000 Excess (Deficiency) of Revenues Over (Under) Expenditures (515,943) 112,753 Other Financing Sources (Uses) Transfers in EDA - - PIR - - Sale of fixed assets - - Transfers out - - Total Other Financing Sources - - Net Change in Fund Balances (515,943) 112,753 Cash Balances, January 1 1,291,162 775,219 Cash Balances, December 31 775,219$ 887,972$ Capital Improvement Plan - Park Improvements 420 Schedule of Projected Revenue, Expenditures and Debt City of Crystal, Minnesota Capital Project Fund Projected Activity 32 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 997,511$ 1,127,187$ 1,273,722$ 1,439,305$ 1,626,415$ 1,837,849$ 2,076,770$ 2,346,750$ 2,651,827$ 8,880 14,194 4,157 1,236 2,242 (1,072) 4,696 8,361 15,762 - - - - - - - - - - - - - - 1,006,391 1,141,381 1,277,879 1,440,542 1,628,657 1,836,777 2,081,466 2,355,110 2,667,589 475,000 2,145,000 1,570,000 1,340,000 1,960,000 1,260,000 1,715,000 1,615,000 525,000 475,000 2,145,000 1,570,000 1,340,000 1,960,000 1,260,000 1,715,000 1,615,000 525,000 531,391 (1,003,619) (292,121) 100,542 (331,343) 576,777 366,466 740,110 2,142,589 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 531,391 (1,003,619) (292,121) 100,542 (331,343) 576,777 366,466 740,110 2,142,589 887,972 1,419,363 415,744 123,623 224,165 (107,179) 469,599 836,064 1,576,174 1,419,363$ 415,744$ 123,623$ 224,165$ (107,179)$ 469,599$ 836,064$ 1,576,174$ 3,718,763$ Capital Project Fund Projected Activity 33 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Proposed 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 - 75,000 Water 0090.6935 TBA 2024 Utility Reconstruction 1,500,000 - 1,500,000 Water 0090.6935 TBA 2024 Replace SENSUS Radios 350,000 - 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 Utility Reconstruction 1,200,000 - - Water 0090.6935 TBA 2033 Commercial Meter replacement 200,000 - - Water 0090.6935 TBA 2033 Body cameras 47,100 - - 1,075,000$ 1,925,000$ City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Schedule of Planned Capital Outlay 2023 to 2033 34 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 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,200,000 - - - - - - - - 200,000 - - - - - - - - 75,000 - - - - - - - - - 1,200,000 - - - - - - - - 200,000 - - - - - - - - 47,100 1,880,000$ 1,925,000$ 3,680,000$ 2,175,000$ 2,230,000$ 2,275,000$ 1,575,000$ 1,475,000$ 1,447,100$ 35 *based on utility study cash flows, budget and actuals 2023 2024 Budgeted Proposed Cash Flows from Operating Activities Receipts from customers and users 5,393,284$ 5,743,847$ Payments to suppliers & employees (3,354,212) (3,539,160) Net Cash Provided (Used) by Operating Activities 2,039,072 2,204,687 Cash Flows from Noncapital Financing Activities Transfers to other funds (280,851) (294,605) Net Cash Provided (Used) by Noncapital Financing Activities (280,851) (294,605) Cash Flows from Capital and Related Financing Activities Infrastructure improvements (1,075,000) (1,925,000) Contribution to internal service funds (157,970) (162,709) Interest expense (7,000) (7,000) Advance to/(from) building fund - Advance to/(from) building fund - Advances to/(from) other funds (60,000) (60,000) Net Cash Provided (Used) by Capital and Related Financing Activities (1,299,970) (2,154,709) Cash Flows from Investing Activities Investment earnings 10,000 24,925 Net Increase (Decrease) in Cash and Cash Equivalents 468,251 (219,702) Cash and Cash Equivalents, January 1 1,700,754 2,169,005 Cash and Cash Equivalents, December 31 2,169,005$ 1,949,303$ Projected bills Average quarterly bill (9,000 gallons) - Residential 99.76$ 106.74$ Average quarterly dollar increase 6.53$ 6.98$ Average annual dollar increase 26.12$ 27.92$ Average quarterly bill (14,000 gallons) - Commercial 141.43$ 151.33$ Average quarterly dollar increase 9.25$ 9.90$ Average annual dollar increase 37.00$ 39.60$ City of Crystal, Minnesota Capital Improvement Plan - Water Fund 505 Statement of Cash Flows 36 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 6,117,197$ 6,514,815$ 6,938,278$ 7,389,266$ 7,869,568$ 8,381,090$ 8,925,861$ 9,506,042$ 10,171,465$ (3,729,697) (3,930,375) (4,141,756) (4,364,440) (4,599,063) (4,846,292) (5,106,839) (5,381,455) (5,542,899) 2,387,500 2,584,440 2,796,522 3,024,826 3,270,505 3,534,798 3,819,022 4,124,587 4,628,566 (303,444) (312,547) (321,923) (331,581) (341,528) (351,774) (362,327) (373,197) (384,393) (303,444) (312,547) (321,923) (331,581) (341,528) (351,774) (362,327) (373,197) (384,393) (1,880,000) (1,925,000) (3,680,000) (2,175,000) (2,230,000) (2,275,000) (1,575,000) (1,475,000) (1,447,100) (207,590) (253,818) (261,433) (269,275) (277,354) (285,674) (294,245) (303,072) (312,164) - - - - - - - - - - 100,000 250,000 150,000 200,000 200,000 - - - (1,500,000) 150,000 150,000 150,000 150,000 150,000 150,000 150,000 150,000 (3,587,590) (1,928,818) (2,041,433) (2,144,275) (2,157,354) (2,210,674) (1,719,245) (1,628,072) (1,609,263) 19,493 4,653 8,130 12,543 18,158 26,056 36,040 53,775 75,546 (1,484,041) 347,728 441,296 561,512 789,781 998,405 1,773,490 2,177,092 2,710,456 1,949,303 465,262 812,990 1,254,286 1,815,798 2,605,579 3,603,984 5,377,474 7,554,567 465,262$ 812,990$ 1,254,286$ 1,815,798$ 2,605,579$ 3,603,984$ 5,377,474$ 7,554,567$ 10,265,022$ 114.21$ 122.21$ 130.76$ 139.91$ 149.71$ 160.19$ 171.40$ 183.40$ 196.24$ 7.47$ 8.00$ 8.55$ 9.15$ 9.80$ 10.48$ 11.21$ 12.00$ 12.84$ 29.88$ 32.00$ 34.20$ 36.60$ 39.20$ 41.92$ 44.84$ 48.00$ 51.35$ 161.93$ 173.26$ 185.39$ 198.37$ 212.25$ 227.11$ 243.01$ 260.02$ 278.22$ 10.60$ 11.33$ 12.13$ 12.98$ 13.88$ 14.86$ 15.90$ 17.01$ 18.20$ 42.40$ 45.32$ 48.52$ 51.92$ 55.52$ 59.44$ 63.60$ 68.04$ 72.81$ Enterprise Fund Projected Activity 37 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Budget Proposed Sewer 0092.6935 TBA 2023 Utility Reconstruction 800,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 - - Sewer 0092.6935 TBA 2025 Sanitary Sewer Lining (outside of Recon)- - Sewer 0092.6935 TBA 2025 South lift station roof replacement - - Sewer 0092.6935 TBA 2025 East Lift Generator Replacement - - Sewer 0092.6935 TBA 2026 Utility Reconstruction - - Sewer 0092.6935 TBA 2027 Utility Reconstruction - - Sewer 0092.6935 TBA 2027 42nd Ave Sanitary Sewer replacement - - Sewer 0092.6935 TBA 2028 Utility Reconstruction - - Sewer 0092.6935 TBA 2029 Utility Reconstruction - - Sewer 0092.6935 TBA 2029 Sanitary Sewer Lining (outside of Recon)- - Sewer 0092.6935 TBA 2030 Utility Reconstruction - - Sewer 0092.6935 TBA 2031 Sanitary Sewer Lining (outside of Recon)- - Sewer 0092.6935 TBA 2031 Utility Reconstruction - - Sewer 0092.6935 TBA 2032 Utility Reconstruction - - Sewer 0092.6935 TBA 2033 Utility Reconstruction - - 800,000$ 870,000$ 2023 2024 *based on utility study cash flows, budget and actuals Adopted Proposed Cash Flows from Operating Activities Receipts from customers and users 3,530,087$ 3,758,307$ Payments to suppliers & employees (2,230,765) (2,442,587) Net Cash Provided (Used) by Operating Activities 1,299,322 1,315,720 Cash Flows from Noncapital Financing Activities Transfers to other funds (280,851) (294,605) Net Cash Provided (Used) by Noncapital Financing Activities (280,851) (294,605) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (800,000) (870,000) Contribution to internal service funds (190,232) (195,459) Advances to/(from) other funds 30,000 30,000 Grants and contributions - - Net Cash Provided (Used) by Capital and Related Financing Activities (960,232) (1,035,459) Cash Flows from Investing Activities Investment earnings 5,000 5,000 Net Increase (Decrease) in Cash and Cash Equivalents 63,239 (9,344) Cash and Cash Equivalents, January 1 504,001 567,240 Cash and Cash Equivalents, December 31 567,240$ 557,895$ Projected bills Average quarterly bill (9,000 gallons)-residential 67.38$ 72.09$ Average quarterly dollar increase 4.41$ 4.71$ Average annual dollar increase 17.64$ 18.84$ Average quarterly bill (14,000 gallons)-Commercial 153.78$ 164.55$ Average quarterly dollar increase 10.06$ 10.77$ Average annual dollar increase 40.24$ 43.08$ Schedule of Planned Capital Outlay 2023 to 2033 City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 Statement of Cash Flows City of Crystal, Minnesota Capital Improvement Plan - Sanitary Sewer Fund 510 38 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - 800,000 - - - - - - - - 200,000 - - - - - - - - 100,000 - - - - - - - - 200,000 - - - - - - - - - 850,000 - - - - - - - - - 250,000 - - - - - - - - 500,000 - - - - - - - - - 1,250,000 - - - - - - - - - 950,000 - - - - - - - - 100,000 - - - - - - - - - 1,300,000 - - - - - - - - - 100,000 - - - - - - - - 1,300,000 - - - - - - - - - 1,200,000 - - - - - - - - - 1,200,000 1,300,000$ 850,000$ 750,000$ 1,250,000$ 1,050,000$ 1,300,000$ 1,400,000$ 1,200,000$ 1,200,000$ 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 4,005,229$ 4,265,569$ 4,542,831$ 4,838,115$ 5,152,592$ 5,487,511$ 5,844,199$ 6,224,072$ 6,659,757$ (2,452,911) (2,528,173) (2,605,685) (2,685,509) (2,768,161) (2,853,750) (2,942,387) (3,034,184) (3,125,210)$ 1,552,318 1,737,396 1,937,146 2,152,606 2,384,431 2,633,761 2,901,812 3,189,888 3,534,548 (303,444) (312,547) (321,923) (331,581) (341,528) (351,774) (362,327) (373,197) (384,393) (303,444) (312,547) (321,923) (331,581) (341,528) (351,774) (362,327) (373,197) (384,393) (1,300,000) (850,000) (750,000) (1,250,000) (1,050,000) (1,300,000) (1,400,000) (1,200,000) (1,200,000) (241,323) (288,562) (297,219) (306,136) (315,320) (324,780) (334,523) (344,559) (354,895) - - - - - - - - - - - - - - - (1,541,323) (1,138,562) (1,047,219) (1,556,136) (1,365,320) (1,624,780) (1,734,523) (1,544,559) (1,554,895) 5,579 2,710 5,600 11,336 14,099 21,015 27,798 36,125 49,208 (286,869) 288,997 573,604 276,225 691,681 678,222 832,759 1,308,257 1,644,467 557,895 271,026 560,023 1,133,626 1,409,851 2,101,533 2,779,755 3,612,514 4,920,771 271,026$ 560,023$ 1,133,626$ 1,409,851$ 2,101,533$ 2,779,755$ 3,612,514$ 4,920,771$ 6,565,238$ 77.14$ 82.54$ 88.32$ 94.50$ 101.12$ 108.19$ 115.77$ 123.87$ 132.54$ 5.05$ 5.40$ 5.78$ 6.18$ 6.62$ 7.07$ 7.58$ 8.10$ 8.67$ 20.20$ 21.60$ 23.12$ 24.72$ 26.48$ 28.28$ 30.32$ 32.40$ 34.68$ 176.05$ 188.39$ 201.57$ 215.68$ 230.78$ 246.94$ 264.22$ 282.72$ 302.51$ 11.50$ 12.34$ 13.18$ 14.11$ 15.10$ 16.16$ 17.28$ 18.50$ 19.79$ 46.00$ 49.36$ 52.72$ 56.44$ 60.40$ 64.64$ 69.12$ 74.00$ 79.16$ Enterprise Fund Projected Activity 39 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Proposed Storm water 0094.6935 TBA 2023 Rate Control, water quality, structure Rehab projects 50,000 50,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 - 150,000 Storm water 0094.6935 TBA 2024 Utility Reconstruction 50,000 - 50,000 Storm water 0094.6935 TBA 2025 Rate Control, water quality, structure Rehab projects 100,000 - - Storm water 0094.6935 TBA 2025 Utility Reconstruction 50,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 Utility Reconstruction 50,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 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 Bassett Creek Park Streambank Stabilization and 29th culvert replacement (3)1,000,000 - - Storm water 0094.6935 TBA 2031 Basset Creek Park Pond Dredging 1,500,000 - - Storm water 0094.6935 TBA 2031 Utility Reconstruction 50,000 - - Storm water 0094.6935 TBA 2032 Saving for flood control structure replacement 1,600,000 - - Storm water 0094.6935 TBA 2032 Rate Control, water quality, structure Rehab projects 150,000 - - Storm water 0094.6935 TBA 2032 Utility Reconstruction 50,000 - - Storm water 0094.6936 TBA 2033 Utility Reconstruction 50,000 - - 100,000$ 200,000$ 0% res 5% comm *based on utility study cash flows, budget and actuals 2023 2024 Budgeted Proposed Cash Flows from Operating Activities Receipts from customers and users 1,319,152$ $1,319,152.00 Payments to suppliers and employees (383,215) (395,072) Net Cash Provided (Used) by Operating Activities 935,937 924,080 Cash Flows from Noncapital Financing Activities Transfers out (75,573) (79,274) Net Cash Provided (Used) by Noncapital Financing Activities (75,573) (79,274) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (100,000) (200,000) Contribution to internal service funds (87,369) (89,990) Advance (to) and repayment from building fund - Advance (to) and repayment from building fund - Net Cash Provided (Used) by Capital and Related Financing Activities (187,369) (289,990) Cash Flows from Investing Activities Investment earnings 5,000 5,000 Net Increase (Decrease) in Cash and Cash Equivalents 677,995 559,816 Cash and Cash Equivalents, January 1 850,152 1,528,146 Cash and Cash Equivalents, December 31 1,528,146$ 2,087,962$ Quarterly Rate/Bill -residential 22.15$ 22.15$ Average quarterly dollar increase -$ -$ Average annual dollar increase -$ -$ Quarterly -Commercial Rates 100.75$ 105.75$ Quarterly bill-Commercial Rates (2.10 acres)1,057.88$ 1,110.38$ Average quarterly dollar increase -$ 52.49$ Average annual dollar increase -$ 209.98$ Statement of Cash Flows City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 City of Crystal, Minnesota Capital Improvement Plan - Storm Drainage Fund 515 Schedule of Planned Capital Outlay 2023 to 2033 40 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 100,000 - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - - 750,000 - - - - - - - - 50,000 - - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - - 50,000 - - - - - - - - 2,000,000 - - - - - - - - - 420,000 - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - 1,000,000 - - - - - - - - - 1,000,000 - - - - - - - - 1,500,000 - - - - - - - - 50,000 - - - - - - - - - 1,600,000 - - - - - - - - 150,000 - - - - - - - - 50,000 - - - - - - - - - 50,000 - - 150,000$ 200,000$ 800,000$ 200,000$ 2,050,000$ 1,620,000$ 2,550,000$ 1,800,000$ 50,000$ Rate Study: 4% 0% res 5% comm 4.5%5.0%5.0%5.0%5.0%5.0%5.0%5.0% 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated $1,371,918.00 $1,433,654.31 $1,505,337.03 $1,580,603.88 $1,659,634.07 $1,742,615.77 $1,829,746.56 $1,921,233.89 2,017,296$ (407,284) (419,861) (432,819) (446,161) (459,907) (474,066) (490,267) (505,665) (520,835)$ 964,634 1,013,793 1,072,518 1,134,443 1,199,727 1,268,550 1,339,480 1,415,569 1,496,461 (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (79,274) (150,000) (200,000) (800,000) (200,000) (2,050,000) (1,620,000) (2,550,000) (1,800,000) (50,000) (112,690) (136,070) (140,153) (144,357) (148,688) (153,148) (157,743) (162,475) (167,349) 100,000 100,000 100,000 100,000 100,000 - - - (2,500,000) 250,000 250,000 250,000 250,000 250,000 250,000 250,000 250,000 (2,662,690) 13,930 (590,153) 5,643 (1,848,688) (1,523,148) (2,457,743) (1,712,475) 32,651 20,880 3,315 12,833 16,992 27,770 20,765 17,634 5,835 2,132 (1,756,450) 951,764 415,924 1,077,804 (700,465) (313,107) (1,179,903) (370,345) 1,451,969 2,087,962 331,512 1,283,276 1,699,200 2,777,004 2,076,539 1,763,432 583,529 213,184 331,512$ 1,283,276$ 1,699,200$ 2,777,004$ 2,076,539$ 1,763,432$ 583,529$ 213,184$ 1,665,153$ 23.04$ 24.07$ 25.28$ 26.54$ 27.87$ 29.26$ 30.72$ 32.26$ 33.87$ 0.89$ 1.03$ 1.21$ 1.26$ 1.33$ 1.39$ 1.46$ 1.54$ 1.61$ 3.56$ 4.12$ 4.84$ 5.04$ 5.32$ 5.56$ 5.84$ 6.16$ 6.45$ 110.75$ 115.73$ 121.52$ 127.59$ 133.97$ 140.67$ 147.70$ 155.09$ 162.84$ 1,162.88$ 1,215.17$ 1,275.92$ 1,339.72$ 1,406.71$ 1,477.04$ 1,550.89$ 1,628.44$ 1,709.86$ 52.50$ 52.29$ 60.76$ 63.80$ 66.99$ 70.34$ 73.85$ 77.54$ 81.42$ 210.00$ 209.16$ 243.03$ 255.18$ 267.94$ 281.34$ 295.41$ 310.18$ 325.69$ Enterprise Fund Projected Activity Enterprise Fund Projected Activity 41 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Budgeted Proposed Street light 0096.6915 TBA 2023 HPS to LED conversion 25,000 - Street light 0096.6915 TBA 2024 HPS to LED conversion - 25,000 Street light 0096.6915 TBA 2025 HPS to LED conversion - - Street light 0096.6915 TBA 2026 HPS to LED conversion - - Street light 0096.6915 TBA 2027 HPS to LED conversion - - Street light 0096.6915 TBA 2027 Undergrounding W. Broadway and Douglas - - Street light 0096.6915 TBA 2028 HPS to LED conversion - - Street light 0096.6915 TBA 2029 HPS to LED conversion - - Street light 0096.6915 TBA 2030 HPS to LED conversion - - 25,000$ 25,000$ *based on utility study cash flows, budget and actuals 2023 2024 Budgeted Proposed Cash Flows from Operating Activities Receipts from customers and users 205,440$ 219,821$ Payments to suppliers (155,600) (163,384) Net Cash Provided (Used) by Operating Activities 49,840 56,437 Cash Flows from Noncapital Financing Activities Transfers out (21,390) (21,390) Net Cash Provided (Used) by Noncapital Financing Activities (21,390) (21,390) 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 Net Cash Provided (Used) by Capital and Related Financing Activities 5,000 5,000 Cash Flows from Investing Activities Investment earnings 5,000 5,000 Net Increase (Decrease) in Cash and Cash Equivalents 38,450 45,047 Cash and Cash Equivalents, January 1 859,123 897,573 Cash and Cash Equivalents, December 31 897,573$ 942,620$ Projected rates Quarterly bill-Residential & Commercial 5.35$ 5.72$ Average quarterly dollar increase 0.35$ 0.37$ Average annual dollar increase 1.40$ 1.50$ Quarterly rate-Multi-family 4.01$ 4.29$ Quarterly bill-Multi-family (based on 19 units)76.24$ 81.57$ Average quarterly dollar increase 4.99$ 5.34$ Average annual dollar increase 19.95$ 21.35$ Capital Improvement Plan - Street Light Fund 520 Schedule of Planned Capital Outlay 2023 to 2033 City of Crystal, Minnesota Capital Improvement Plan - Street Light Fund 520 Statement of Cash Flows City of Crystal, Minnesota 42 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - 1,000,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - - - - - - - 25,000 - - - 25,000$ 25,000$ 1,025,000$ 25,000$ 25,000$ 25,000$ -$ -$ -$ 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 235,208$ 251,673$ 269,290$ 288,140$ 308,310$ 329,892$ 352,984$ 377,693$ 377,693$ (171,468) (179,995) (188,943) (198,332) (208,186) (218,527) (229,379) (240,769) (240,769) 63,740 71,678 80,347 89,808 100,124 111,365 123,605 136,924 136,924 (22,032) (22,693) (23,373) (24,075) (24,797) (25,541) (26,307) (27,096) (27,909) (22,032) (22,693) (23,373) (24,075) (24,797) (25,541) (26,307) (27,096) (27,909) (25,000) (25,000) (1,025,000) (25,000) (25,000) (25,000) - - - - - - - - - - - - - - - - - (25,000) (25,000) (1,025,000) (25,000) (25,000) (25,000) - - - 9,426 9,688 10,024 444 856 1,368 1,990 2,983 4,111 26,135 33,673 (958,002) 41,178 51,183 62,192 99,288 112,810 113,126 942,620 968,755 1,002,427 44,425 85,603 136,786 198,978 298,266 411,076 968,755$ 1,002,427$ 44,425$ 85,603$ 136,786$ 198,978$ 298,266$ 411,076$ 524,202$ 6.13$ 6.55$ 7.01$ 7.50$ 8.03$ 8.59$ 9.19$ 9.84$ 10.52$ 0.40$ 0.43$ 0.46$ 0.49$ 0.53$ 0.56$ 0.60$ 0.64$ 0.69$ 1.60$ 1.72$ 1.84$ 1.96$ 2.10$ 2.25$ 2.41$ 2.57$ 2.75$ 4.59$ 4.92$ 5.26$ 5.63$ 6.02$ 6.44$ 6.89$ 7.38$ 7.89$ 87.28$ 93.39$ 99.93$ 106.93$ 114.41$ 122.42$ 130.99$ 140.16$ 149.97$ 5.71$ 6.11$ 6.54$ 7.00$ 7.48$ 8.01$ 8.57$ 9.17$ 9.81$ 22.84$ 24.44$ 26.15$ 27.98$ 29.94$ 32.04$ 34.28$ 36.68$ 39.24$ Enterprise Fund Projected Activity Enterprise Fund Projected Activity 43 Business Unit Year to 2023 2024 Object Code Subledger Replace Item Cost Budgeted Proposed 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 2023 Replace #307 - 2012 Ram 2500 (new is swap loader)75,000 75,000 - Public Works 0615.6930 TBA 2023 Replace #309 - 2010 Freightliner TA 270,000 270,000 - Public Works 0615.6930 TBA 2023 Replace #109 - 2003 Int'l 7400 Tandem drup truck (rehabbed in 2019)190,000 190,000 - Public Works 0615.6930 TBA 2023 Replace #158 (replace Z turn trailer)15,000 15,000 - Public Works 0615.6930 TBA 2023 Replace #420 Tractor backhoe 250,000 250,000 - Public Works 0615.6930 TBA 2024 Replace #108 Cushman Gas Truckster 4 Wheel (Replace with ToolCAT)100,000 - 100,000 Public Works 0615.6930 TBA 2024 Replace #178 Graco Fieldlazer @100 striper 10,000 - 10,000 Comm Dev 0615.6930 TBA 2024 Replace #56 - 2014 Ford Focus - - - Public Works 0615.6930 TBA 2024 Replace #351 - Rayco brush chipper 52,804 - 52,804 Public Works 0615.6930 TBA 2024 Replace #451 - SRECO easement machine (no title)44,590 - 44,590 Public Works 0615.6930 TBA 2024 Replace #457 - Broot utility trailer 11,000 - 11,000 Public Works 0615.6930 TBA 2024 Replace #303 Sidewalk machine 185,000 - 185,000 Public Works 0615.6930 TBA 2024 Replace scissor lift 30,000 - 30,000 Public Works 0615.6930 TBA 2024 Replace #310 - 2010 Chevy 3500 85,000 - 85,000 Public Works 0615.6930 TBA 2025 Replace #337 - 2013 Mauldin asphalt paver 200,000 - - Public Works 0615.6930 TBA 2025 Replace #364 - SPH-1.3 pre-mix heater hot box/patching 45,000 - - Public Works 0615.6930 TBA 2025 Replace #116 - PU truck with dump body and plow 100,000 - - Public Works 0615.6930 TBA 2025 Replace #302 Sidewalk machine 185,000 - - Public Works 0615.6930 TBA 2025 Replace #439 Onan trailer generator 150,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 #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)85,000 - - Public Works 0615.6931 TBA 2025 Vehicle #121 - John Deere Tractor 100,000 - - Public Works 0615.6930 TBA 2025 Replace #429 GMC Sierra 3500 C/CH 4WD (Truck with bigger crane)160,000 - - Public Works 0615.6930 TBA 2026 Replace Engineering #42 40,000 - - 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)65,000 - - 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)- - - 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 145,000 - - Public Works 0615.6930 TBA 2026 Replace #127 Toro Grounds Master 5910 (cab, leaft kit, road lights)160,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 - - City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 (Continued on the Following Page) Schedule of Planned Capital Outlay 2023 to 2033 Department 44 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 200,000 - - - - - - - - 45,000 - - - - - - - - 100,000 - - - - - - - - 185,000 - - - - - - - - 150,000 - - - - - - - - 135,000 - - - - - - - - 75,000 - - - - - - - - 35,000 - - - - - - - - 181,732 - - - - - - - - 96,924 - - - - - - - - 30,289 - - - - - - - - 90,000 - - - - - - - - 85,000 - - - - - - - - 100,000 - - - - - - - - 160,000 - - - - - - - - - 40,000 - - - - - - - - 65,000 - - - - - - - - 65,000 - - - - - - - - 306,476 - - - - - - - - - - - - - - - - - 10,007 - - - - - - - - 50,037 - - - - - - - - 145,000 - - - - - - - - 160,000 - - - - - - - - - 77,495 - - - - - - - - 80,000 - - - - - - - - 10,000 - - - - - - - - 252,000 - - - - - - - - 290,605 - - - - - - - - 19,000 - - - - - - - - 68,000 - - - - - - 18,000 - - - - - - 45 Business Unit Year to 2023 2024 Object Code Subledger Replace Item Cost Budgeted Proposed Public Works 0615.6930 TBA 2027 Replace #426 Freightliner w/Vactor Jet Rodder Unit 825,000 - - Public Works 0615.6930 TBA 2027 Replace #449 Chevy Silverado K2500 (white)80,000 - - Public Works 0615.6930 TBA 2027 Replace #450-2 - 12 ft Plow & ACS Adapter (for #450)16,003 - - 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 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 - 2019 Ford Fusion 36,000 - - Comm Dev 0615.6930 TBA 2029 Replace car #57 - 2019 Ford Fusion 36,000 - - Public Works 0615.6930 TBA 2029 Replace #427 - GMC 1 ton; Sierra 3500 4x4 double cab (white)55,000 - - 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 300,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 70,000 - - Public Works 0615.6930 TBA 2032 Bobcat T650 T4 Compact Track Loader 65,000 - - - - - - 1,396,543$ 520,417$ Schedule of Planned Capital Outlay 2023 to 2033 Department City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 (Continued) 46 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - 825,000 - - - - - - - - 80,000 - - - - - - - - 16,003 - - - - - - - - - 45,000 - - - - - - - - 6,668 - - - - - - - - 126,688 - - - - - - - - 93,349 - - - - - - - - - 385,530 - - - - - - - - 18,000 - - - - - - - - 36,000 - - - - - - - - 36,000 - - - - - - - - 55,000 - - - - - - - - - 54,022 - - - - - - - - 65,396 - - - - - - - - 250,000 - - - - - - - - 14,216 - - - - - - - - 78,190 - - - - - - - - 14,216 - - - - - - - - 21,325 - - - - - - - - 71,082 - - - - - - - - 150,000 - - - - - - - - - 75,000 - - - - - - - - 300,000 - - - - - - - - 8,000 - - - - - - - - 32,000 - - - - - - - - 20,000 - - - - - - - - 20,000 - - - - - - - - 8,000 - - - - - - - - 20,000 - - - - - - - - - 70,000 - - - - - - - - 65,000 - - - - - - - - - - - - - - - - - - - 1,670,970$ 843,546$ 1,738,129$ 273,732$ 532,559$ 720,478$ 485,031$ 137,032$ 2,033$ 47 2023 2024 Budgeted Proposed Cash Flows from Operating Activities Receipts from interfund services provided 347,391$ 350,865$ Payments to suppliers and employees (4,890) (4,905) Net Cash Provided (Used) by Operating Activities 342,501 345,960 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 (1,431,543) (520,417) Proceeds from sale of assets 50,000 Net Cash Used by Capital and Related Financing Activities (1,431,543) (470,417) Cash Flows from Investing Activities Investment earnings 10,000 10,000 Net Increase (Decrease) in Cash and Cash Equivalents (1,079,042) (114,457) Cash and Cash Equivalents, January 1 2,668,995 1,589,953 Cash and Cash Equivalents, December 31 1,589,953$ 1,475,496$ City of Crystal, Minnesota Capital Improvement Plan - Fleet Fund 615 Statement of Cash Flows 48 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 671,917$ 1,012,232$ 1,072,966$ 1,137,344$ 1,205,584$ 1,277,919$ 1,354,594$ 1,435,870$ 1,522,022$ (5,199) (5,511) (5,841) (6,192) (6,563) (6,957) (7,375) (7,817) (8,286) 666,718 1,006,721 1,067,124 1,131,152 1,199,021 1,270,962 1,347,220 1,428,053 1,513,736 - - - - - - - - - - - - - - - - - - (1,670,970) (843,546) (1,738,129) (273,732) (532,559) (720,478) (485,031) (137,032) (2,033) 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 50,000 (1,620,970) (793,546) (1,688,129) (223,732) (482,559) (670,478) (435,031) (87,032) 47,967 14,755 5,360 7,545 1,411 10,499 17,769 23,951 33,313 47,056 (939,497) 218,535 (613,460) 908,830 726,960 618,253 936,140 1,374,333 1,608,759 1,475,496 536,000 754,534 141,075 1,049,905 1,776,865 2,395,118 3,331,258 4,705,591 536,000$ 754,534$ 141,075$ 1,049,905$ 1,776,865$ 2,395,118$ 3,331,258$ 4,705,591$ 6,314,350$ Internal Service Fund Projected Activity 49 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Proposed 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 - Welcome Park 0625.6941 TBA 2023 Replace Building Fascia and Soflits 25,000 25,000 - Aquatic Building 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 - North Lions Park 0625.6940 TBA 2023 Replace skylights 25,000 25,000 - City Buildings 0625.6940 TBA 2024 Replace cabinets in Council Chambers 5,000 - 5,000 City Buildings 0625.6940 TBA 2024 Replace/improve to upstairs IT room 5,000 - 5,000 Public Works 0625.6940 TBA 2024 Interior touch up paint 20,000 - 20,000 Salt Building 0625.6940 TBA 2024 Paint exterior building, light panel replacement 10,000 - 10,000 City Buildings 0625.6940 TBA 2024 HVAC cleaning 35,000 - 35,000 Public Works 0625.6940 TBA 2024 Install boiler for heater 35,000 - 35,000 City Buildings 0625.6940 TBA 2024 City Hall fire extinguisher mounts/cabinets 15,000 - 15,000 Community Center 0625.6940 TBA 2024 Security Cameras 80,000 - 80,000 Community Center 0625.6940 TBA 2024 ADA and security update Front desk 85,000 - 85,000 Pool 0625.6940 TBA 2024 Grogan Park Pool improvements 2,800,000 - 2,800,000 Pool 0625.6940 TBA 2024 Grogan Park pool building improvements 700,000 - 700,000 Community Center 0625.6940 TBA 2024 Replace floor scrubber 15,000 - 15,000 City Buildings 0625.6940 TBA 2024 Replace city hall elevator 200,000 - 200,000 Community Center 0625.6940 TBA 2024 Replace Refrigerator/refrigerator 12,000 - 12,000 North Fire Station 0625.6940 TBA 2024 Replace generator 25,000 - 25,000 North Fire Station 0625.6940 TBA 2024 Upgrade emergency/exit lighting 5,000 - 5,000 City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors 5,000 - 5,000 South Fire Station 0625.6940 TBA 2024 Replace generator 15,000 - 15,000 City Buildings 0625.6940 TBA 2024 Replace NO/CO sensors 5,000 - 5,000 South Fire Station 0625.6940 TBA 2024 Replace Parking lot (concrete pad)60,000 - 60,000 North Lions Park 0625.6940 TBA 2024 Replace West Parking lot asphalt 290,000 - 290,000 Valley Place Park 0625.6940 TBA 2024 Replace parking lot (West)380,000 - 380,000 Aquatic building 0625.6940 TBA 2024 Replace staff lockers 20,000 - 20,000 Pool 0625.6940 TBA 2024 Pool Improvements 500,000 - 500,000 Aquatic building 0625.6940 TBA 2024 Paint interior 20,000 - 20,000 Aquatic Building 0625.6940 TBA 2024 Replace security lighting and exit lights 20,000 - 20,000 City Buildings 0625.6940 TBA 2025 Lighting upgrade to LED at City Hall, including chambers 40,000 - - City Buildings 0625.6940 TBA 2025 Replace can lighting in entire building 60,000 - - City Buildings 0625.6940 TBA 2025 Replace/improve to downstairs IT room (AC unit)15,000 - - Community Center 0625.6940 TBA 2025 Building Automation updates 120,000 - - Recreation 0625.6940 TBA 2025 Parking Lot - Valley Place Park (Near Play Area)400,000 - - City Buildings 0625.6940 TBA 2025 Replace Air Handler 150,000 - - City Buildings 0625.6940 TBA 2025 Replace toilets and urinals 35,000 - - Old Utilities bldg 0625.6940 TBA 2025 Replace heating system and thermostat 51,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 bathroom fixtures 30,000 - - Aquatic Building 0625.6940 TBA 2025 Replace hand dryers 15,000 - - Pool 0625.6940 TBA 2026 Replace waterwalk pads (5 floats)22,000 - - Aquatic building 0625.6940 TBA 2026 Install fiberglass doors in chemical areas (3)30,000 - - City Buildings 0625.6940 TBA 2026 Replace popcorn ceiling in Council Chambers 30,000 - - City Buildings 0625.6940 TBA 2026 Paint interior 30,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 2027 Remove Air compressors at City Hall 25,000 - - Community Center 0625.6940 TBA 2027 Re-key building 100,000 - - Community Center 0625.6940 TBA 2027 Divider Wall- gyms 30,000 - - Community Center 0625.6940 TBA 2027 Replace Refrigerator (double door)7,000 - - Aquatic building 0625.6940 TBA 2027 Replace furnaces (3)45,000 - - Pool 0625.6940 TBA 2028 Replace cargo net 10,000 - - Becker Park 0625.6940 TBA 2028 Replace Parking lot 400,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 Replace/relocate motion sensors for lights 10,000 - - Community Center 0625.6940 TBA 2028 Replace ovens 18,000 - - Community Center 0625.6940 TBA 2028 Replace 6-burner stove 7,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 2023 to 2033 50 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 40,000 - - - - - - - - 60,000 - - - - - - - - 15,000 - - - - - - - - 120,000 - - - - - - - - 400,000 - - - - - - - - 150,000 - - - - - - - - 35,000 - - - - - - - - 51,000 - - - - - - - - 50,000 - - - - - - - - 15,000 - - - - - - - - 30,000 - - - - - - - - 15,000 - - - - - - - - - 22,000 - - - - - - - - 30,000 - - - - - - - - 30,000 - - - - - - - - 30,000 - - - - - - - - 250,000 - - - - - - - - 30,000 - - - - - - - - 30,000 - - - - - - - - 10,000 - - - - - - - - - 25,000 - - - - - - - - 100,000 - - - - - - - - 30,000 - - - - - - - - 7,000 - - - - - - - - 45,000 - - - - - - - - - 10,000 - - - - - - - - 400,000 - - - - - - - - 19,000 - - - - - - - - 10,000 - - - - - - - - 25,000 - - - - - - - - 10,000 - - - - - - - - 18,000 - - - - - - - - 7,000 - - - - - - - - 200,000 - - - - - - - - 100,000 - - - - - 51 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Proposed Community Center 0625.6940 TBA 2029 Update Minnesota room 75,000 - - Grogan Park 0625.6940 TBA 2029 North Parking lot improvement 975,000 - - Grogan Park 0625.6940 TBA 2029 Skate park/picnic area 475,000 - - Fire Department 0625.6940 TBA 2029 Improve upstairs ventilation 40,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 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 - - Valley Place Park 0625.6940 TBA 2029 Re-key building 5,000 - - Pool 0625.6941 TBA 2029 Paint drop slide/walkway/waterslide structure 90,000 - - City Buildings 0625.6940 TBA 2029 Replace all window treatments 50,000 - - Public Works 0625.6939 TBA 2030 Re-key building 60,000 - - City Buildings 0625.6940 TBA 2030 Re-key building 50,000 - - City Buildings 0625.6940 TBA 2030 Replace exterior windows 450,000 - - City Buildings 0625.6940 TBA 2030 Upgrade life safety systems 100,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 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 Replace bathroom fixtures 50,000 - - Fire Department 0625.6940 TBA 2030 ADA restroom upgrades 25,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)150,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 Improve 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 - - City Buildings 0625.6940 TBA 2031 Paint interior 30,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 - - Public Works 0625.6940 TBA 2032 Siding replacement - salt building 25,000 - - Community Center 0625.6940 TBA 2032 Replace air handler 90,000 - - 1,493,000 5,362,000 City of Crystal, Minnesota Capital Improvement Plan - Building Fund 625 Schedule of Planned Capital Outlay 2023 to 2033 52 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - 975,000 - - - - - - - - 475,000 - - - - - - - - 40,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 3,000 - - - - - - - - 5,000 - - - - - - - - 90,000 - - - - - - - - 50,000 - - - - - - - - - 60,000 - - - - - - - - 50,000 - - - - - - - - 450,000 - - - - - - - - 100,000 - - - - - - - - 50,000 - - - - - - - - 100,000 - - - - - - - - 250,000 - - - - - - - - 75,000 - - - - - - - - 30,000 - - - - - - - - 225,000 - - - - - - - - 50,000 - - - - - - - - 50,000 - - - - - - - - 25,000 - - - - - - - - 15,000 - - - - - - - - 50,000 - - - - - - - - 150,000 - - - - - - - - 35,000 - - - - - - - - 25,000 - - - - - - - - 50,000 - - - - - - - - 125,000 - - - - - - - - 100,000 - - - - - - - - - 30,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 - - - - - - - - 25,000 - - - - - - - - 90,000 - 981,000 432,000 207,000 799,000 1,813,000 2,065,000 206,000 156,000 - 53 2023 2024 Budgeted Proposed Cash Flows from Operating Activities Receipts from interfund services provided 1,250,000 1,482,077 Receipts from miscellaneous revenue 32,870 90,928 Payments to suppliers and employees (410,000) (557,560) Net Cash Provided (Used) by Operating Activities 872,870 1,015,445 Cash Flows from Noncapital Financing Activities Transfers in/(out)(440,000) (466,400) Net Cash Provided (Used) by Noncapital Financing Activities (440,000) (466,400) Cash Flows from Capital and Related Financing Activities Acquisition of capital assets (1,493,000) (5,362,000) Proceeds from sale of assets - Grants and Contributions 730,000 Internal loan - - Internal Loan from Street Fund (200,000) Internal Loan from Police Revolving Fund - Internal Loan from Storm Water - Proposed from Water/Storm ($2M each)- Internal Loan from Water - Net Cash Used by Capital and Related Financing Activities (763,000) (5,562,000) Cash Flows from Investing Activities Investment earnings 5,000 10,000 Net Increase (Decrease) in Cash and Cash Equivalents (325,130) (5,002,955) Cash and Cash Equivalents, January 1 2,592,613 2,267,483 Cash and Cash Equivalents, December 31 2,267,483 (2,735,472) Capital Improvement Plan - Building Fund 625 Schedule of Planned Capital Outlay 2023 to 2033 City of Crystal, Minnesota 54 2025 2026 2027 2028 2029 2030 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 2,071,002 2,695,262 3,156,977 3,346,396 3,547,180 3,760,011 3,985,611 4,224,748 4,478,233 96,384 102,167 108,297 114,795 121,682 128,983 136,722 144,925 153,621 (591,014) (626,474) (664,063) (703,907) (746,141) (790,910) (838,364) (888,666) (941,986) 1,576,372 2,170,954 2,601,211 2,757,284 2,922,721 3,098,084 3,283,969 3,481,007 3,689,868 (494,384) (524,047) (555,490) (588,819) (624,148) (661,597) (701,293) (743,371) (787,973) (494,384) (524,047) (555,490) (588,819) (624,148) (661,597) (701,293) (743,371) (787,973) (981,000) (432,000) (207,000) (799,000) (1,813,000) (2,065,000) (206,000) (156,000) - - - - - - - - - - (700,000) (500,000) (500,000) (400,000) (300,000) (500,000) (600,000) (1,300,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) - - - - 4,000,000 (400,000) (400,000) (400,000) (400,000) (400,000) (400,000) (400,000) (400,000) - (100,000) (250,000) (150,000) (200,000) (200,000) - - - 1,969,000 (1,647,000) (1,572,000) (1,949,000) (2,813,000) (3,315,000) (1,406,000) (2,096,000) (400,000) 10,000 3,255 3,287 8,057 10,332 5,291 (3,441) 8,291 14,791 3,060,988 3,162 477,008 227,521 (504,095) (873,222) 1,173,235 649,928 2,516,685 (2,735,472) 325,516 328,678 805,686 1,033,207 529,112 (344,110) 829,125 1,479,053 325,516 328,678 805,686 1,033,207 529,112 (344,110) 829,125 1,479,053 3,995,738 Internal Service Fund Projected Activity 55 Business Unit Year to 2023 2024 Department Object Code Subledger Replace Item Cost Budgeted Proposed Information Technology 0620.6940 TBA 2023 Network Hardware 18,836 18,836 - Information Technology 0620.6940 TBA 2023 Computer Hardware & Software 65,000 65,000 - Information Technology 0620.6940 TBA 2023 Network Printers 21,072 21,072 - Information Technology 0620.6940 TBA 2023 Building Security & Access 50,000 50,000 - Information Technology 0620.6940 TBA 2023 Fiber Construction & Maintenance 70,000 70,000 - Information Technology 0620.6940 TBA 2024 Budget Software 50,000 - 50,000 Information Technology 0620.6940 TBA 2024 Robbinsdale SD Fiber - Potential Replacement 113,000 - 113,000 Information Technology 0620.6940 TBA 2024 Network Hardware 18,705 - 18,705 Information Technology 0620.6940 TBA 2024 Computer Hardware & Software 55,000 - 55,000 Information Technology 0620.6940 TBA 2024 Network Printers 1,000 - 1,000 Information Technology 0620.6940 TBA 2024 Building Security & Access 50,000 - 50,000 Information Technology 0620.6940 TBA 2024 Fiber Construction & Maintenance 20,000 - 20,000 Information Technology 0620.6940 TBA 2024 Computer Hardware & Software 10,000 - 10,000 Information Technology 0620.6940 TBA 2025 ERP Upgrade -Conversion cost 200,000 - - Information Technology 0620.6940 TBA 2025 ERP Upgrade -Logis Implementation 376,100 - - Information Technology 0620.6940 TBA 2025 Network Hardware 56,055 - - Information Technology 0620.6940 TBA 2025 Computer Hardware & Software 57,500 - - Information Technology 0620.6940 TBA 2025 Network Printers 18,100 - - Information Technology 0620.6940 TBA 2025 Building Security & Access 50,000 - - Year to 2023 2024 Department Replace Item Cost Proposed Proposed Information Technology 0620.6940 TBA 2025 Fiber Construction & Maintenance 20,000$ -$ -$ Information Technology 0620.6940 TBA 2025 VOIP & VM Server Replacement 100,000$ - - Information Technology 0620.6940 TBA 2026 Network Hardware 41,659 - - Information Technology 0620.6940 TBA 2026 Computer Hardware & Software 60,000 - - Information Technology 0620.6940 TBA 2026 Network Printers 27,800 - - Information Technology 0620.6940 TBA 2026 Building Security & Access 57,500 - - Information Technology 0620.6940 TBA 2026 Fiber Construction & Maintenance 20,000 - - Information Technology 0620.6940 TBA 2027 Network Hardware 62,000 - - Information Technology 0620.6940 TBA 2027 Computer Hardware & Software 65,000 - - Information Technology 0620.6940 TBA 2027 Network Printers 18,300 - - Information Technology 0620.6940 TBA 2027 Building Security & Access 58,000 - - Information Technology 0620.6940 TBA 2027 Fiber Construction & Maintenance 22,500 - - Information Technology 0620.6940 TBA 2028 Network Hardware 10,000 - - Information Technology 0620.6940 TBA 2028 Computer Hardware & Software 65,000 - - Information Technology 0620.6940 TBA 2028 Network Printers 8,300 - - Information Technology 0620.6940 TBA 2028 Building Security & Access 50,000 - - Information Technology 0620.6940 TBA 2028 Fiber Construction & Maintenance 20,000 - - Information Technology 0620.6940 TBA 2029 Network Hardware 35,811 - - Information Technology 0620.6940 TBA 2029 Computer Hardware & Software 67,500 - - Information Technology 0620.6940 TBA 2029 Network Printers 8,100 - - Information Technology 0620.6940 TBA 2029 Building Security & Access 55,000 - - Information Technology 0620.6940 TBA 2029 Fiber Construction & Maintenance 20,000 - - Information Technology 0620.6940 TBA 2030 Network Hardware 47,940 - - Information Technology 0620.6940 TBA 2030 Computer Hardware & Software 67,500 - - Information Technology 0620.6940 TBA 2030 Network Printers 17,300 - - Information Technology 0620.6940 TBA 2030 Building Security & Access 57,500 - - Information Technology 0620.6940 TBA 2030 Fiber Construction & Maintenance 20,000 - - Capital Improvement Plan - Information Technology Fund 620 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Schedule of Planned Capital Outlay 2023 to 2033 City of Crystal, Minnesota Schedule of Planned Capital Outlay 2023 to 2033 (Continued) 56 2025 2026 2027 2028 2029 2030 2031 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 200,000 - - - - - - - - - 376,100 - - - - - - - - - 56,055 - - - - - - - - - 57,500 - - - - - - - - - 18,100 - - - - - - - - - 50,000 - - - - - - - - - 2025 2026 2027 2028 2029 2030 2031 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 20,000$ -$ -$ -$ -$ -$ -$ - - - 100,000 - - - - - - - - - - 41,659 - - - - - - - - - 60,000 - - - - - - - - - 27,800 - - - - - - - - - 57,500 - - - - - - - - - 20,000 - - - - - - - - - - 62,000 - - - - - - - - - 65,000 - - - - - - - - - 18,300 - - - - - - - - - 58,000 - - - - - - - - - 22,500 - - - - - - - - - - 10,000 - - - - - - - - - 65,000 - - - - - - - - - 8,300 - - - - - - - - - 50,000 - - - - - - - - - 20,000 - - - - - - - - - - 35,811 - - - - - - - - - 67,500 - - - - - - - - - 8,100 - - - - - - - - - 55,000 - - - - - - - - - 20,000 - - - - - - - - - - 47,940 - - - - - - - - - 67,500 - - - - - - - - - 17,300 - - - - - - - - - 57,500 - - - - - - - - - 20,000 - - - - 57 Year to 2023 2024 Department Replace Item Cost Budgeted Estimated Information Technology 0620.6940 TBA 2031 Network Hardware 36,294 - - Information Technology 0620.6940 TBA 2031 Computer Hardware & Software 60,000 - - Information Technology 0620.6940 TBA 2031 Network Printers 27,800 - - Information Technology 0620.6940 TBA 2031 Building Security & Access 55,000 - - Information Technology 0620.6940 TBA 2031 Fiber Construction & Maintenance 20,000 - - Information Technology 0620.6940 TBA 2032 Network Hardware 60,703 - - Information Technology 0620.6940 TBA 2032 Computer Hardware & Software 64,000 - - Information Technology 0620.6940 TBA 2032 Network Printers 17,500 - - Information Technology 0620.6940 TBA 2032 Building Security & Access 60,000 - - Information Technology 0620.6940 TBA 2032 Fiber Construction & Maintenance 20,000 - - Information Technology 0620.6941 TBA 2033 - - - Information Technology 0620.6942 TBA 2033 - - - 224,908$ 317,705$ 2023 2024 Budgeted Proposed Cash Flows from Operating Activities Receipts from interfund services provided 662,510$ 774,792$ Payments to suppliers and employees (715,425) (832,600) Net Cash Provided (Used) by Operating Activities (52,915) (57,807) 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 (224,908) (317,705) Internal loan from Streets - Net Cash Provided (Used) by Capital and Related Financing Activities (224,908) (317,705) Cash Flows from Investing Activities Investment earnings 4,000 4,000 Net Increase (Decrease) in Cash and Cash Equivalents (273,823) (371,512) Cash and Cash Equivalents, January 1 (0) (273,824) Cash and Cash Equivalents, December 31 (273,824)$ (645,336)$ Internal Service Fund Projected Activity Schedule of Planned Capital Outlay 2023 to 2033 (Continued) City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 City of Crystal, Minnesota Capital Improvement Plan - Information Technology Fund 620 Statement of Cash Flows 58 2025 2026 2027 2028 2029 2030 2031 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated - - - - - - 36,294 36,294 - - - - - - - - 60,000 60,000 - - - - - - - - 27,800 27,800 - - - - - - - - 55,000 55,000 - - - - - - - - 20,000 20,000 - - - - - - - - - - 60,703 - - - - - - - - - 64,000 - - - - - - - - - 17,500 - - - - - - - - - 60,000 - - - - - - - - - 20,000 - - - - - - - - - - - - - - - - - - - - - 877,755$ 206,959$ 225,800$ 153,300$ 186,411$ 210,240$ 199,094$ 199,094$ 222,203$ -$ 2025 2026 2027 2028 2029 2030 2031 2031 2032 2033 Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated Estimated 821,280$ 870,557$ 1,122,790$ 1,390,157$ 1,473,567$ 1,561,981$ 1,655,700$ 1,755,042$ 1,860,344$ 1,971,965$ (882,556)$ (935,509)$ (991,640)$ (1,051,138)$ (1,114,206)$ (1,181,059)$ (1,251,922)$ (1,327,037)$ (1,406,660)$ (1,491,059)$ (61,276) (64,952) 131,151 339,020 359,361 380,922 403,778 428,004 453,685 480,906 - - - - - - - - - - - - - - - - - (877,755) (206,959) (225,800) (153,300) (186,411) (210,240) (199,094) (199,094) (222,203) - 2,000,000 500,000 (250,000) (250,000) (250,000) (250,000) (250,000) (250,000) (250,000) 1,122,245 293,041 (225,800) (403,300) (436,411) (460,240) (449,094) (449,094) (472,203) (250,000) (6,453) 4,092 6,414 5,531 4,944 4,223 3,472 3,472 3,053 3,296 1,054,516 232,180 (88,236) (58,749) (72,106) (75,095) (41,845) (17,618) (15,465) 234,201 (645,336) 409,180 641,361 553,125 494,376 422,269 347,174 347,174 305,330 329,556 409,180$ 641,361$ 553,125$ 494,376$ 422,269$ 347,174$ 305,330$ 329,556$ 289,865$ 563,758$ Internal Service Fund Projected Activity 59