Loading...
3. Scandia 2021 Budget Workbook 12-2-2020TNT HEARING 12/2/2020 2021 Levy / Budget Presentation Packet CITY OF SCANDIA Truth-In-Taxation Public Hearing 12/2/2020 BUDGET WORKBOOK 12/2/2020 Page 1 of 18 TNT HEARING 12/2/2020 Opt A Total Tax Levy:$2,613,824 Option A Tax Rate:31.825%Change in Rate over PY:1.1% Final Tax Capacities for 2021 are not available. However, it is still possible to estimate the dollar for dollar impacts on individual tax statements. The following is a breakdown of tax bill impacts: Class Rate State Taxing Classification Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff 1.00%Class 1a Homestead Under $500k $3.18 $0.04 $318.25 $3.59 $795.63 $8.99 $1,238.66 $13.99 $1,273.00 $14.38 $1,591.25 $17.97 1.25%Class 1a Homestead Over $500k $3,580.31 $40.44 0.50%Class 2a Agricultural Land first $1.5Mil $1.59 $0.02 $159.13 $1.80 $397.81 $4.49 $619.33 $6.99 $636.50 $7.19 $795.63 $8.99 $1,591.25 $17.97 0.65%Class 2c Managed Forest Land $2.07 $0.02 $206.86 $2.34 $517.16 $5.84 $805.13 $9.09 $827.45 $9.35 $1,034.31 $11.68 $2,068.63 $23.36 1.50%Class 3a Commercial-Industrial, Utility first $150k $4.77 $0.05 $477.38 $5.39 2.00%Class 3a Commercial-Industrial, Utility over $150k $1,352.56 $15.28 $2,238.64 $25.28 $2,307.31 $26.06 $2,943.81 $33.25 $6,126.31 $69.19 * Average property value for the City of Scandia How do I make since of this table? What does this table not include? Estimated Impacts on Tax Bills (Option A) $500,000 of Value $1,000,000 of Value 2021 Estimated Tax Rate Impacts The table above shows what a property tax rate would look like based on the value points noted at the top of the table in the bold boxes. Rates very based on state taxing classifications. The most common classification is Class 1a for residential properties. This means if you had a residential property that was valued at $100,000, for example, that value is multiplied by the classification rate of 1% before it is multiplied by the local tax rate. The result is a payment of $316.38. Tax statements can be a little complicated. The above table lays out any base taxes prior to the application of tax credits, taxes authorized by referendums, the state's general property tax rate, and rates of other local government jurisdictions. So its important to remember that the County, schools, and other agencies tax in addition to what the city taxes. $1000 of Value $100,000 of Value $250,000 of Value $389,211 of Value*$400,000 of Value BUDGET WORKBOOK 12/2/2020 Page 2 of 18 TNT HEARING 12/2/2020 Opt B Total Tax Levy:$2,584,824 Option B Tax Rate:31.455%Change in Rate over PY:0% Final Tax Capacities for 2021 are not available. However, it is still possible to estimate the dollar for dollar impacts on individual tax statements. The following is a breakdown of tax bill impacts: Class Rate State Taxing Classification Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff 1.00%Class 1a Homestead Under $500k $3.15 $0.00 $314.55 -$0.11 $786.38 -$0.26 $1,224.26 -$0.41 $1,258.20 -$0.42 $1,572.75 -$0.53 1.25%Class 1a Homestead Over $500k $3,538.69 -$1.19 0.50%Class 2a Agricultural Land first $1.5Mil $1.57 $0.00 $157.28 -$0.05 $393.19 -$0.13 $612.13 -$0.21 $629.10 -$0.21 $786.38 -$0.26 $1,572.75 -$0.53 0.65%Class 2c Managed Forest Land $2.04 $0.00 $204.46 -$0.07 $511.14 -$0.17 $795.77 -$0.27 $817.83 -$0.27 $1,022.29 -$0.34 $2,044.58 -$0.69 1.50%Class 3a Commercial-Industrial, Utility first $150k $4.72 $0.00 $471.83 -$0.16 2.00%Class 3a Commercial-Industrial, Utility over $150k $1,336.84 -$0.45 $2,212.61 -$0.74 $2,280.49 -$0.77 $2,909.59 -$0.98 $6,055.09 -$2.04 * Average property value for the City of Scandia How do I make since of this table? What does this table not include? The table above shows what a property tax rate would look like based on the value points noted at the top of the table in the bold boxes. Rates very based on state taxing classifications. The most common classification is Class 1a for residential properties. This means if you had a residential property that was valued at $100,000, for example, that value is multiplied by the classification rate of 1% before it is multiplied by the local tax rate. The result is a payment of $316.38. Tax statements can be a little complicated. The above table lays out any base taxes prior to the application of tax credits, taxes authorized by referendums, the state's general property tax rate, and rates of other local government jurisdictions. So its important to remember that the County, schools, and other agencies tax in addition to what the city taxes. Estimated Impacts on Tax Bills (Option B) 2021 Estimated Tax Rate Impacts $1000 of Value $100,000 of Value $250,000 of Value $389,211 of Value*$400,000 of Value $500,000 of Value $1,000,000 of Value BUDGET WORKBOOK 12/2/2020 Page 3 of 18 TNT HEARING 12/2/2020 Opt C Total Tax Levy:$2,558,824 Option C Tax Rate:31.123%Change in Rate over PY:-1.1% Final Tax Capacities for 2021 are not available. However, it is still possible to estimate the dollar for dollar impacts on individual tax statements. The following is a breakdown of tax bill impacts: Class Rate State Taxing Classification Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff 1.00%Class 1a Homestead Under $500k $3.11 -$0.03 $311.23 -$3.43 $778.08 -$8.56 $1,211.34 -$13.33 $1,244.92 -$13.70 $1,556.15 -$17.13 1.25%Class 1a Homestead Over $500k $3,501.34 -$38.54 0.50%Class 2a Agricultural Land first $1.5Mil $1.56 -$0.02 $155.62 -$1.71 $389.04 -$4.28 $605.67 -$6.67 $622.46 -$6.85 $778.08 -$8.56 $1,556.15 -$17.13 0.65%Class 2c Managed Forest Land $2.02 -$0.02 $202.30 -$2.23 $505.75 -$5.57 $787.37 -$8.67 $809.20 -$8.91 $1,011.50 -$11.13 $2,023.00 -$22.27 1.50%Class 3a Commercial-Industrial, Utility first $150k $4.67 -$0.05 $466.85 -$5.14 2.00%Class 3a Commercial-Industrial, Utility over $150k $1,322.73 -$14.56 $2,189.26 -$24.10 $2,256.42 -$24.84 $2,878.88 -$31.69 $5,991.18 -$65.95 * Average property value for the City of Scandia How do I make since of this table? What does this table not include? The table above shows what a property tax rate would look like based on the value points noted at the top of the table in the bold boxes. Rates very based on state taxing classifications. The most common classification is Class 1a for residential properties. This means if you had a residential property that was valued at $100,000, for example, that value is multiplied by the classification rate of 1% before it is multiplied by the local tax rate. The result is a payment of $316.38. Tax statements can be a little complicated. The above table lays out any base taxes prior to the application of tax credits, taxes authorized by referendums, the state's general property tax rate, and rates of other local government jurisdictions. So its important to remember that the County, schools, and other agencies tax in addition to what the city taxes. Estimated Impacts on Tax Bills (Option C) 2021 Estimated Tax Rate Impacts $1000 of Value $100,000 of Value $250,000 of Value $389,211 of Value*$400,000 of Value $500,000 of Value $1,000,000 of Value BUDGET WORKBOOK 12/2/2020 Page 4 of 18 TNT HEARING 12/2/2020 Opt D Total Tax Levy:$2,510,824 Option D Tax Rate:30.506%Change in Rate over PY:-3% Final Tax Capacities for 2021 are not available. However, it is still possible to estimate the dollar for dollar impacts on individual tax statements. The following is a breakdown of tax bill impacts: Class Rate State Taxing Classification Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff Payment PY Diff 1.00%Class 1a Homestead Under $500k $3.05 -$0.10 $305.06 -$9.60 $762.65 -$23.99 $1,187.33 -$37.35 $1,220.24 -$38.38 $1,525.30 -$47.98 1.25%Class 1a Homestead Over $500k $3,431.93 -$107.95 0.50%Class 2a Agricultural Land first $1.5Mil $1.53 -$0.05 $152.53 -$4.80 $381.33 -$11.99 $593.66 -$18.67 $610.12 -$19.19 $762.65 -$23.99 $1,525.30 -$47.98 0.65%Class 2c Managed Forest Land $1.98 -$0.06 $198.29 -$6.24 $495.72 -$15.59 $771.76 -$24.28 $793.16 -$24.95 $991.45 -$31.19 $1,982.89 -$62.37 1.50%Class 3a Commercial-Industrial, Utility first $150k $4.58 -$0.14 $457.59 -$14.39 2.00%Class 3a Commercial-Industrial, Utility over $150k $1,296.51 -$40.78 $2,145.86 -$67.50 $2,211.69 -$69.57 $2,821.81 -$88.76 $5,872.41 -$184.72 * Average property value for the City of Scandia How do I make since of this table? What does this table not include? The table above shows what a property tax rate would look like based on the value points noted at the top of the table in the bold boxes. Rates very based on state taxing classifications. The most common classification is Class 1a for residential properties. This means if you had a residential property that was valued at $100,000, for example, that value is multiplied by the classification rate of 1% before it is multiplied by the local tax rate. The result is a payment of $316.38. Tax statements can be a little complicated. The above table lays out any base taxes prior to the application of tax credits, taxes authorized by referendums, the state's general property tax rate, and rates of other local government jurisdictions. So its important to remember that the County, schools, and other agencies tax in addition to what the city taxes. Estimated Impacts on Tax Bills (Option D) 2021 Estimated Tax Rate Impacts $1000 of Value $100,000 of Value $250,000 of Value $389,211 of Value*$400,000 of Value $500,000 of Value $1,000,000 of Value BUDGET WORKBOOK 12/2/2020 Page 5 of 18 TNT HEARING 12/2/2020 YTD Actual Percent FUND 101 2018 2019 7/31/2020 2020 2021 (Proposed)Change REVENUE Taxes 1,350,146 1,410,578 801,059 1,502,700 1,398,700 -7%(1) Special assessments - - - - - 0% Intergovernmental revenue 106,721 65,079 6,983 62,100 62,900 1% Licenses and permits 297,174 150,876 73,264 133,900 108,400 -19%(2) Charges for services 59,962 66,980 52,403 73,100 58,600 -20%(3) Fines & Forfeitures 9,517 7,831 3,760 9,000 8,100 -10%(4) Interest earnings 12,560 21,631 31,797 5,000 17,900 258%(4) Refunds and reimbursements 507 6,853 366 500 500 0% Donations 9,325 3,714 9,364 3,000 5,000 67%(4) Grants 11,732 7,980 8,000 12,400 12,000 -3% Miscellaneous revenue 8,881 1,656 - 5,500 1,400 -75%(4) Transfers from Other funds - - 17,700 - 1,440 0% TOTAL REVENUES 1,866,525 1,743,179 1,004,697 1,807,200 1,674,940 -7% EXPENDITURES City Council 18,904 29,536 9,297 21,000 19,982 -5% City Administration 313,936 340,026 220,254 381,400 387,272 2%(5) Elections 5,467 830 2,489 6,400 1,030 -84%(6) Planning & Building Inspection 160,672 126,170 53,203 131,400 118,050 -10% Assessor 22,483 21,200 11,975 21,400 21,600 1% Animal Control - - 936 1,800 2,000 11%(7) Police Protection 136,077 135,946 69,739 139,100 147,460 6% Fire Protection 226,039 274,281 125,800 296,114 262,778 -11% Street Department 517,136 625,911 296,851 690,700 658,253 -5% Capital Outlay 9,291 - 332 - 14,400 0% Parks and Playgrounds 65,851 73,053 49,990 77,600 88,397 14%(8) Recreation/Education/Social 42,063 47,469 21,841 46,500 56,500 22%(9) Miscellaneous expense - - - - - 0% Transfer out 423,500 444,962 - 3,000 283,000 0% TOTAL EXPENDITURES 1,941,420 2,119,384 862,707 1,816,414 2,060,722 13% NET REVENUE OVER (UNDER) EXPENSE (74,895)$ (376,205)$ 141,990$ (9,214)$ (385,782)$ EXPLANATION OF CHANGE (1) (2) (3) (4) (5) (6) (7) (8) (9) Redistribution of employee compensation Redistribution of employee compensation / increased hours for office asst. Proposed Property Taxes are the same as 2020. The increase is the result including revenues related to fiscal disparities. Estimated 19% drop in permit revenue for 2021 due to Covid-19 Adjusted estimate for 2021 Proposed increase to office asst. hours/adjustment to P.T. Benefits Estimated 21% drop in charges for service for 2021 due to Covid-19 SUMMARY BUDGET - GENERAL FUND ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 30, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 STATEMENT OF REVENUES AND EXPENDITURES - No election in 2021 New estimate for animal control services Actual Budget BUDGET WORKBOOK 12/2/2020 Page 6 of 18 TNT HEARING 12/2/2020 CITY OF SCANDIA 2021 PROJECTED GENERAL REVENUE SOURCES Percent 2020 Proposed 2021 Change Taxes 1,502,700$ 1,398,700$ -7% Special assessments -$ -$ 0% Intergovernmental revenue 62,100$ 62,900$ 1% Licenses and permits 133,900$ 108,400$ -19% Charges for services 73,100$ 58,600$ -20% Fines & Forfeitures 9,000$ 8,100$ -10% Interest earnings 5,000$ 17,900$ 258% Refunds and reimbursements 500$ 500$ 0% Donations 3,000$ 5,000$ 67% Grants 12,400$ 12,000$ -3% Miscellaneous revenue 5,500$ 1,400$ -75% Transfers from Other funds -$ 1,440$ 0% Total Revenue 1,807,200 1,674,940 -7% Budget Taxes 84% Special assessments 0% Intergovernmental revenue 4% Licenses and permits 6% Charges for services 4% Fines & Forfeitures 0%Interest earnings 1% Refunds and reimbursements 0% Donations 0% Grants 1%Miscellaneous revenue 0% Transfers from Other funds 0% 2021 Projected General Revenue Sources BUDGET WORKBOOK 12/2/2020 Page 7 of 18 TNT HEARING 12/2/2020 CITY OF SCANDIA 2016 PROJECTED GENERAL EXPENDITURES Percent 2020 Proposed 2021 Change General Government 561,600$ 547,934$ -2% Public Safety 437,014$ 412,238$ -6% Public Works 690,700$ 658,253$ -5% Capital Outlay -$ 14,400$ 0% Culture and Recreation 124,100$ 144,897$ 17% Transfers to other funds 3,000$ 283,000$ 9333% Total Expenditures 1,816,414 2,060,722 13% Budget General Government 26% Public Safety 20% Public Works 32% Capital Outlay 1% Culture and Recreation 7% Transfers to other funds 14% 2021 Budgeted General Expenditures BUDGET WORKBOOK 12/2/2020 Page 8 of 18 TNT HEARING 12/2/2020 YTD Actual Percent FUND 602 2018 2019 7/31/2020 2020 2021 Change OPERATING REVENUES Special assessments 611 4,824 387 600 200 -67%(1) Grants 138 35 16,990 - - 0% Charges for services 85,518 81,238 36,053 90,615 88,045 -3%(2) Miscellaneous - - - - - 0% 86,267 86,096 53,430 91,215 88,245 -3% OPERATING EXPENSES Operations and maintenance 57,403 67,691 36,468 76,875 77,805 1% Depreciation 39,632 39,630 - 49,700 51,200 3% Capital Outlay 1,376 10,692 103,000 9,000 38,000 322%(3) Total Operating Expenses 98,412 118,013 139,468 135,575 167,005 OPERATING INCOME (12,145) (31,917) (86,038) (44,360) (78,761) 78% NON-OPERATING REVENUES (EXPENSES) Interest expense - - - - - Interest Earnings 770 3,226 - 200 700 Refunds and reimbursements - - 550 - - Total Non-Operating Revenues (Expenses)770 3,226 550 200 700 250% INCOME BEFORE TRANSFERS (11,375) (28,691) (85,488) (44,160) (78,061) 77% Transfer out - - - - - Transfer in - - - - 10,000 100%(4) CHANGE IN NET POSITION (11,375) (28,691) (85,488) (44,160) (68,061) 54% BEG. NET POSITION 88,588 77,213 48,522 48,522 4,362 -91% ENDING NET POSITION 77,213 48,522 (36,966) 4,362 (63,698) -1560%(5) EXPLANATION OF CHANGE (1) The are less outstanding assessments to be paid off. Drop in revenue. (2) Reduction due to a change in rounding in formula based on rate. (3) 4 Lift Station Pump Replacements and Reserve of Distribution System Maintenance (4) (5) Budgets of utilities have not included depreciation expenses in the process of setting revenues. STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - SEWER FUND 602 BIG MARINE LAKE ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 Actual Budget Recommended 7% Rate Increase (+$13.98/quarter) due to financial condition of utility Recommended Lending the 602 Fund $10,000 from Fund 401 @ 2% Interest For Cashflow for 5 years starting in 2022 BUDGET WORKBOOK 12/2/2020 Page 9 of 18 TNT HEARING 12/2/2020 YTD Actual Percent FUND 612 2018 2019 7/31/2020 2020 2021 Change OPERATING REVENUES Special assessments - - - - - Grants 48 11 - - - Charges for services 21,347 20,535 3,585 21,800 23,000 6%(1) Miscellaneous - - - - - 21,395 20,546 3,585 21,800 23,000 6% OPERATING EXPENSES Operations and maintenance 12,529 9,302 5,522 16,370 17,530 7%(2) Depreciation 4,877 4,877 - 4,877 4,877 Capital Outlay - - - 1,200 5,200 333%(3) Total Operating Expenses 17,406 14,179 5,522 22,447 27,607 23% OPERATING INCOME 3,989 6,367 (1,937) (647) (4,607) 612% NON-OPERATING REVENUES (EXPENSES) Interest expense - - - - - Interest Earnings 49 - - - - Refunds and reimbursements - - - - - Total Non-Operating Revenues (Expenses)49 - - - - INCOME BEFORE TRANSFERS 4,038 6,367 (1,937) (647) (4,607) 612% Transfer out - 2,640 - - - 0% Transfer in - - - - - 0% CHANGE IN NET POSITION 4,038 9,007 (1,937) (647) (4,607) 612%(4) BEG. NET POSITION - 4,038 13,045 13,045 12,398 -5% ENDING NET POSITION 4,038 13,045 11,108 12,398 7,791 -37% EXPLANATION OF CHANGE (1) (2) Increase due to labor costs. (3) (4) Budgets of utilities have not included depreciation expenses in the process of setting revenues. STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - SEWER FUND 612 UPTOWN Includes a 5% recommended increase $4.17 per quarter to $87.50 from $83.33. Purchase of drainfield blower ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 Actual Budget BUDGET WORKBOOK 12/2/2020 Page 10 of 18 TNT HEARING 12/2/2020 YTD Actual 2018 2019 5/30/2020 2020 2021 EDA - Fund 225 REVENUES Taxes 800 4,649 2,418 5,000 5,000 0% Grants 6,474 7,892 - - - - Interest earnings 203 300 - - - - Transfers In 20,000 - - - - - TOTAL REVENUES 27,477 12,841 2,418 5,000 5,000 0% EXPENSES Economic Development 15,909 10,949 325 800 750 -6% Miscellaneous - - - - 1,150 - Transfer out - - - - - - TOTAL EXPENSES 15,909 10,949 325 800 1,900 138% 11,568 1,892 2,093 4,200 3,100 -26% EXPLANATION OF CHANGE YTD Actual 2018 2019 5/30/2020 2020 2021 Cable TV - Fund 226 REVENUES Interest earnings 5 65 - - - - Charges for Service 9,465 18,321 9,622 18,000 16,500 -8% Transfer in - - - - - - TOTAL REVENUES 9,471 18,386 9,622 18,000 16,500 -8% EXPENSES Miscellaneous 4,319 18,668 3,081 8,920 10,500 18% Transfer out - - - - - - TOTAL EXPENSES 4,319 18,668 3,081 8,920 10,500 18% 5,152 (281) 6,541 9,080 6,000 -34% EXPLANATION OF CHANGE Actual Budget No Major changes compared to prior yeaer budget. STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - ECOMOMIC DEVELOPMENT AUTHORITY FUND ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 CHANGE IN NET POSITION Actual Budget No Major changes compared to prior yeaer budget. STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - CABLE TVFUND ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 CHANGE IN NET POSITION BUDGET WORKBOOK 12/2/2020 Page 11 of 18 TNT HEARING 12/2/2020 Fund YTD Actual Percent 401 2018 2019 7/31/2020 2020 2021 Change REVENUES Taxes - 146 - - 100,000 100%(1) Grants 33,055 74,874 - - - 0% Charges for services - - - - - 0% Interest earnings 4,837 12,751 - 2,000 500 -75% Donations 7,493 21,500 - - - 0% Miscellanous revenue - - - - - 0% Transfer in 403,500 550,602 - 3,000 200,000 6567% TOTAL REVENUES 448,884 659,873 - 5,000 300,500 EXPENSES General Improvement 195,135 64,093 24,532 430,000 297,000 -31%(2) Fire Improvement - - - - 255,000 100%(3) Public Works Improvement - - 5,553 - 10,000 100%(4) Street & Road Improvement - - - - - 0% Park Improvement - - - - - 0% Community Center Improvement - - - - 15,000 0% Miscellanous 29,556 109,822 - - - 0% Transfers out - - - - 10,000 100%(5) TOTAL EXPENSES 224,691 173,914 30,085 430,000 587,000 37% CHANGE IN NET POSITION 224,193 485,959 (30,085) (425,000) (286,500) -33% EXPLANATION OF CHANGE (1) (2) (3) Fire Dept Radio Replacement for $75k (4) Public Works Radio Replacement for $10k (5) Interfund Loan to the Sewer fund for $10k @ 2% over 5 years for cashflow. ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - GENERAL CAPITAL FUND $165,000 for MN DEED Broadband Expansion Grant / $85,000 for additional Internet expansion in 2021 Actual Budget Proposed $100,000 levy, should be considered again in 2021 expenses are anticipated to outpace revenue drawing on fund balance. BUDGET WORKBOOK 12/2/2020 Page 12 of 18 TNT HEARING 12/2/2020 Fund YTD Actual Percent 404 2018 2019 7/31/2020 2020 2021 Change REVENUES Taxes - - 14,505 30,000 10,000 -67%(1) Grants - 9,300 3,250 32,180 10,585 -67%(2) Interest earnings 853 2,600 - - - 0% Donations 1,269 1,595 802 - - 0% Charges for services 13,650 4,650 - 7,600 7,600 0%(3) Miscellanous revenue - 140,000 - - - 0% Transfer in 100,000 - - - - 0% TOTAL REVENUES 115,772 158,145 18,557 69,780 28,185 -60% EXPENSES Miscellaneous 1,412 2,472 2,564 3,620 - -100% Park Improvement - 22,650 19,950 78,000 40,585 -48%(4) Transfers Out - 103,000 - - 1,440 0% TOTAL EXPENSES 1,412 128,122 22,514 81,620 42,025 CHANGE IN NET POSITION 114,360 30,023 (3,957) (11,840) (13,840) 17% EXPLANATION OF CHANGE (1) (2) (3) Ballfield Ad Revenue and Park Dedication Fees (4) $5k park planning, $10k trails, $20k park signs, $10585 DNR Grant, $5k Settlers' Monument SUMMARY BUDGET - PARK CAPITAL FUND STATEMENT OF REVENUES AND EXPENDITURES - Lower levy from $30k to $10k DNR Prairie Restoration Grant at Lilleskogen Park Actual Budget ACTUAL FOR YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 BUDGET WORKBOOK 12/2/2020 Page 13 of 18 TNT HEARING 12/2/2020 Fund YTD Actual Percent 406 2018 2019 7/31/2020 2020 2021 Change REVENUES Taxes 30,000 27,894 14,505 30,000 130,000 333%(1) Grants - - - - - 0% Interest earnings 3,212 4,376 - 1,000 1,000 0% Donations 9,540 - - - - 0% Miscellanous revenue 14,300 - 13,500 10,000 7,000 -30% Transfer in - - - - - 100% TOTAL REVENUES 57,052 32,270 28,005 41,000 138,000 237% EXPENSES Miscellaneous 400 - - - - 0% Capital Equipment 257,477 75,961 93,498 256,000 52,500 -79%(2) Transfers Out - - - - - 0% TOTAL EXPENSES 257,877 75,961 93,498 256,000 52,500 -79% CHANGE IN NET POSITION (200,826) (43,692) (65,493) (215,000) 85,500 -140% EXPLANATION OF CHANGE (1) (2) STATEMENT OF REVENUES AND EXPENDITURES - Actual Budget $130k levy Only a PW Pickup is scheduled for replacement on 2021. SUMMARY BUDGET - EQUIPMENT REPLACEMENT FUND ACTUAL FOR YEARS ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 BUDGET WORKBOOK 12/2/2020 Page 14 of 18 TNT HEARING 12/2/2020 Fund YTD Actual Percent 408 2018 2019 7/31/2020 2020 2021 Change REVENUES Taxes 725,050 353,019 184,466 381,516 438,539 15%(1) Grants - - - - - Interest earnings 12,708 23,740 - 10,000 - -100% Donations - - - - - Miscellanous revenue - - - - - Debt Proceeds - - - - - Transfer in 3,842,638 - - - 210,000 TOTAL REVENUES 4,580,396 376,759 184,466 391,516 648,539 66% EXPENSES Capital Outlay 4,672,273 87,818 390,859 637,000 845,000 33%(2) Transfers Out - - - - - 0% TOTAL EXPENSES 4,672,273 87,818 390,859 637,000 845,000 33% CHANGE IN NET POSITION (91,877) 288,942 (206,393) (245,484) (196,461) -20% EXPLANATION OF CHANGE (1) $57k increase to road improvement levy. (2) Actual Budget STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - LOCAL ROAD IMPROVEMENT FUND ACTUAL FOR YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 The 2021 Road Project has a higher cost estimate than 2020. Project to include 220th Street N and Peabody Trail N BUDGET WORKBOOK 12/2/2020 Page 15 of 18 TNT HEARING 12/2/2020 313 - GO EQUIPMENT CERTIFICATE OF INDEBTEDNESS 2013 FUND Fund 313 YTD Actual 2018 2019 7/31/2020 2020 2021 REVENUE Taxes 66,752$ 63,985$ 35,214$ 72,831$ 68,220$ Special Assessments - - - - - Interest earnings - - - - - Refunds and Reimbursements - - - - - Bond Proceeds - - - - - Transfer In - - - - - TOTAL REVENUES 66,752 63,985 35,214 72,831 68,220 EXPENDITURES Miscellaneous 495 495 495 500 495 Principal 55,000 55,000 60,000 60,000 60,000 Interest Expense 4,575 7,995 3,420 6,060 4,500 Transfer Out - - - - - TOTAL EXPENDITURES 60,070 63,490 63,915 66,560 64,995 NET REVENUE OVER (UNDER) EXPENSE 6,682$ 495$ (28,701)$ 6,271$ 3,225$ 315 - EQUIPMENT CERTIFICATE OF INDEBTEDNESS 2015 FUND - To be phased out in 2021 Fund 315 YTD Actual 2018 2019 7/31/2020 2020 2021 REVENUE Taxes 47,566$ 45,556$ 22,082$ 45,670$ -$ Special Assessments - - - - - Interest Earnings - - - - - Refunds and Reimbursements - - - - - Bond Proceeds - - - - - Transfer In - - - - - TOTAL REVENUES 47,566 45,556 22,082 45,670 - EXPENDITURES Miscellaneous - - - 500 - Principal 43,000 43,000 43,000 43,000 - Interest Expense 2,709 1,892 495 495 - Transfer Out - - - - - TOTAL EXPENDITURES 45,709 44,892 43,495 43,995 - NET REVENUE OVER (UNDER) EXPENSE 1,857$ 664$ (21,413)$ 1,675$ -$ 317 EQUIPMENT CERTIFICATE OF INDEBTEDNESS 2017 FUND Fund 317 YTD Actual 2018 2019 7/31/2020 2020 2021 REVENUE Taxes 37,884$ 34,791$ 17,742$ 36,695$ 35,909$ Special Assessments - - - - - Interest Earnings - - - - - Refunds and Reimbursements - - - - - Bond Proceeds - - - - - Transfer In - - - - - TOTAL REVENUES 37,884 34,791 17,742 36,695 35,909 Actual Budget Actual Budget CITY OF SCANDIA STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - DEBT SERVICE FUNDS ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 Actual Budget BUDGET WORKBOOK 12/2/2020 Page 16 of 18 TNT HEARING 12/2/2020 EXPENDITURES Miscellaneous - - - 500 495 Principal 32,000 32,000 32,000 32,000 32,000 Interest Expense 3,921 3,328 2,544 2,448 1,728 Transfer Out - - - - - TOTAL EXPENDITURES 35,921 35,328 34,544 34,948 34,223 NET REVENUE OVER (UNDER) EXPENSE 1,963$ (537)$ (16,802)$ 1,747$ 1,686$ BUDGET WORKBOOK 12/2/2020 Page 17 of 18 TNT HEARING 12/2/2020 GO 2018 STREET RECONSTRUCTION FUND Fund 318 YTD Actual 2018 2019 7/31/2020 2020 2021 REVENUE Taxes - 321,820 166,101 343,534 341,456 Special Assessments - - - - - Interest Earnings - - - - - Refunds and Reimbursements - - - - - Bond Proceeds - - - - - Transfer In - - - - - TOTAL REVENUES - 321,820 166,101 343,534 341,456 EXPENDITURES Miscellaneous - 495 495 1,000 495 Principal - 155,000 55,588 215,000 220,000 Interest Expense - 173,738 - 111,175 104,725 Transfer Out - - - - - TOTAL EXPENDITURES - 329,233 56,083 327,175 325,220 NET REVENUE OVER (UNDER) EXPENSE -$ (7,413)$ 110,018$ 16,359$ 16,236$ Actual Budget ACTUAL FOR THE YEAR ENDED DECEMBER 31, 2018 AND 2019, PERIOD TO DATE JULY 31, 2020 AND BUDGET FOR THE YEARS ENDED DECEMBER 31, 2020 AND 2021 CITY OF SCANDIA STATEMENT OF REVENUES AND EXPENDITURES - SUMMARY BUDGET - DEBT SERVICE FUNDS CONTINUED BUDGET WORKBOOK 12/2/2020 Page 18 of 18