Loading...
Option 2 of the Draft 2022 Scandia City Budget9/1/2021CITY OF SCANDIA 9/1/2021 Financial Management Plan Option II: No Tax Impact Inflation Assumptions 531,272 586,043 634,802 665,770 664,685 678,858 699,223 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Interest Earnings 1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50% Expenses 2.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00% Actual Actual Adopted Preliminary GENERAL FUND 2017 2018 2019 2020 2021 2022 2023 2024 REVENUE 1 General Property Tax-Current 1,556,278 1,358,056 1,409,921 1,553,879 1,381,700 1,583,000 1,721,700 1,692,626 2 Other taxes 17,000 24,500 24,990 25,490 3 Intergovernmental 107,716 105,857 67,105 72,885 62,900 64,200 65,484 66,794 4 Federal grant 311,080 5 Franchise fees 7,989 6,613 5,104 6 Licenses and Permits 366,902 300,274 150,876 151,164 108,400 149,500 172,490 175,940 7 Charges for Services 63,886 59,962 66,979 43,276 58,600 51,200 52,224 53,268 8 Fines & Forfeits 8,392 9,517 7,831 7,561 8,100 7,000 7,140 7,283 9 Interest Earnings 12,958 12,560 21,631 11,463 17,900 15,900 16,139 16,381 10 Miscellaneous Revenues 38,023 15,411 12,223 18,879 18,900 16,900 11 - - - 12 Total Revenue 2,154,155 1,869,626 1,743,179 2,175,291 1,673,500 1,912,200 2,060,167 2,037,781 EXPENSES 13 Current 14 General Government 566,215 521,457 514,691 535,026 609,320 611,620 629,969 648,868 15 Public Safety 334,787 361,381 408,622 323,316 435,090 435,090 448,143 461,587 16 Public Works 665,123 517,139 624,818 568,500 688,590 683,490 703,995 725,115 17 Park and Recreation 99,791 107,916 120,523 133,534 163,200 152,900 157,487 162,212 18 Applied to Federal Grant 198,919 19 Federal fund returned 31,088 20 Capital Outlay - 10,026 5,754 23,337 6,000 16,000 21 - - - - 22 - - - - - - - 23 - - - - - - 24 - - - - - - - 25 Total Expenses 1,665,916 1,517,919 1,674,408 1,813,720 1,902,200 1,899,100 1,939,593 1,997,781 26 Revenues Over / (Under) Expenses 488,239 351,707 68,771 361,571 (228,700) 13,100 120,574 40,000 OTHER FINANCING SOURCES / (USES) 27 Transfers In - - 28 Contingency 29 Sale of Fixed Assets - - - - 30 Bond Proceeds - - - - - - 31 Transfer in 1,440 32 Transfer out to General Capital (200,000) 33 Transfer out to Local Road Improvement (80,000) 34 Transfers Out (523,200) (423,500) (444,962) (3,000) - - 35 Total Other Sources / (Uses)(523,200) (423,500) (444,962) (3,000) (278,560) - - - 36 37 Prior Period Adjustments 38 Ending General Fund Balance (FB)1,715,008 1,643,215 1,267,024 1,824,514 1,317,254 1,330,354 1,450,928 1,490,928 39 Restricted - - - - - - - 40 Unassigned 1,715,008 1,643,215 1,267,024 1,824,514 1,317,254 1,330,354 1,450,928 1,490,928 41 Fund Balance as a % of Next Year's Expenditures (net of contingency)69.9%95.9%69.4%68.6%72.6%72.5% Projected 9/1/2021CITY OF SCANDIA 9/1/2021 Financial Management Plan Option II: No Tax Impact Inflation Assumptions 531,272 586,043 634,802 665,770 664,685 678,858 699,223 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Interest Earnings 1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50% Expenses 2.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00% Actual Actual Adopted Preliminary GENERAL FUND 2017 2018 2019 2020 2021 2022 2023 2024 Projected 1 41 General Fund Operating Tax Levy 1,545,600 1,349,820 1,342,592 1,484,700 1,381,700 1,583,000 1,721,700 1,692,626 42 Annual Increase -12.7%-0.5%10.6%-6.9%14.6%8.8%-1.7% ANNUAL DEBT LEVIES BY BOND ISSUE-FUTURE 43 44 45 46 47 - - - - - - 48 Total Annual Debt Levies - - - - - - - OTHER SPECIAL TAX LEVIES 49 Debt service 50 2013 Certificates 68,000 66,752 68,816 72,831 68,220 66,000 64,000 - 51 2015 Certificates 48,739 47,566 48,996 45,670 52 2017 Certificates 37,884 37,418 36,695 35,909 34,524 53 2018 GO Bonds 346,120 343,534 341,456 344,531 342,536 345,634 54 55 Park Improvement 30,000 10,000 20,000 30,000 50,000 56 Equipment Replacement 30,000 30,000 30,000 130,000 30,000 40,000 40,000 57 Local Road Improvement 560,533 725,050 378,930 381,516 438,539 200,000 165,000 70,000 61 General Capital Improvement 30,000 100,000 230,000 150,000 250,000 62 63 EDA 5,000 800 5,000 5,000 5,000 8,000 8,000 8,000 64 65 - 66 Total Other Special Levies 712,272 908,052 915,280 945,246 1,129,124 933,055 799,536 763,634 67 Total Tax Levy 2,257,872 2,257,872 2,257,872 2,429,946 2,510,824 2,516,055 2,521,236 2,456,260 68 Increase/(Decrease) in Total Tax Levy 0.00%0.00%7.62%3.33%0.21%0.21%-2.58% 69 Less: Fiscal Disparities (112,010)(121,125)(132,815)(133,843)(121,180)(118,933)(115,934)(111,856) 70 Net Levy to Taxpayers 2,145,862 2,136,747 2,125,057 2,296,103 2,389,644 2,397,122 2,405,302 2,344,404 71 72 Existing Tax Base 6,023,919 6,230,838 6,723,403 7,460,384 7,911,011 8,140,985 8,466,624 8,635,956 73 74 75 76 77 78 79 80 81 82 83 New Net Tax Capacity 0 0 0 0 0 0 0 0 84 Total Net Tax Capacity 6,023,919 6,230,838 6,723,403 7,460,384 7,911,011 8,140,985 8,466,624 8,635,956 85 Tax Rate on Tax Capacity 35.622%34.293%31.607%30.777%30.207%29.445%28.409%27.147% 86 Tax Rate % Change -3.73%-7.83%-2.62%-1.85%-2.52%-3.52%-4.44% 9/1/2021CITY OF SCANDIA 9/1/2021 Financial Management Plan Option II: No Tax Impact Inflation Assumptions 531,272 586,043 634,802 665,770 664,685 678,858 699,223 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Interest Earnings 1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50% Expenses 2.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00% Actual Actual Adopted Preliminary GENERAL FUND 2017 2018 2019 2020 2021 2022 2023 2024 Projected 87 City Taxes on $297,800 Residential Homestead 1,022 1,000 1,024 1,112 1,127 1,147 1,155 1,128 88 $ Tax Increase/(Decrease)(22)$ 24$ 88$ 15$ 20$ 8$ (28)$ 89 % Tax Increase / (Decrease)-2.19%2.38%8.59%1.38%1.79%0.72%-2.40% 90 Existing Tax Base Inflation / (Deflation)0.0%0.0%0.0%1.0%2.0%4.0%4.0%2.0% 91 Total Tax Base Increase 3%8%11%6%3%4%2% 9/1/2021 720,200 741,806 764,060 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2025 2026 2027 2028 2029 2030 2031 1,705,738 1,810,513 1,842,002 1,920,258 1,980,335 2,042,290 2,061,180 26,000 26,520 27,050 27,591 28,143 28,706 29,280 68,130 69,492 70,882 72,300 73,746 75,221 76,725 179,459 183,048 186,709 190,443 194,252 198,137 202,100 54,334 55,421 56,529 57,660 58,813 59,989 61,189 7,428 7,577 7,729 7,883 8,041 8,202 8,366 16,626 16,876 17,129 17,386 17,647 17,911 18,180 - - - - - - - 2,057,714 2,169,446 2,208,029 2,293,520 2,360,975 2,430,455 2,457,018 668,334 688,384 709,035 730,306 752,215 774,782 798,025 475,435 489,698 504,389 519,520 535,106 551,159 567,694 746,868 769,274 792,352 816,123 840,606 865,825 891,799 167,078 172,090 177,253 182,571 188,048 193,689 199,500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2,057,714 2,119,446 2,183,029 2,248,520 2,315,975 2,385,455 2,457,018 - 50,000 25,000 45,000 45,000 45,000 - - - - - - - - (50,000) (25,000) (45,000) (45,000) (45,000) - - - - - - - - - - - - - - - - - - (50,000) (25,000) (45,000) (45,000) (45,000) - 1,490,928 1,540,928 1,565,928 1,610,928 1,655,928 1,700,928 1,700,928 - - - - - - - 1,490,928 1,540,928 1,565,928 1,610,928 1,655,928 1,700,928 1,700,928 70.3%70.6%69.6%69.6%69.4%69.2%69.2% Projected 9/1/2021 720,200 741,806 764,060 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2025 2026 2027 2028 2029 2030 2031 Projected 1,705,738 1,810,513 1,842,002 1,920,258 1,980,335 2,042,290 2,061,180 0.8%6.1%1.7%4.2%3.1%3.1%0.9% - - - - - - - 343,166 340,541 343,009 345,161 341,749 343,429 344,794 85,000 85,000 85,000 85,000 85,000 25,000 25,000 75,000 75,000 75,000 75,000 75,000 25,000 15,000 - 30,000 45,000 - - - - 285,000 250,000 300,000 265,000 200,000 45,000 35,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 793,166 785,541 853,009 775,161 706,749 443,429 424,794 2,498,904 2,596,054 2,695,011 2,695,419 2,687,084 2,485,719 2,485,974 1.74%3.89%3.81%0.02%-0.31%-7.49%0.01% (106,886)(106,919)(109,078)(111,098)(108,852)(106,466)(96,323) 2,392,018 2,489,135 2,585,933 2,584,321 2,578,233 2,379,253 2,389,651 8,808,675 8,984,849 9,164,546 9,347,837 9,534,794 9,725,490 9,920,000 0 0 0 0 0 0 0 8,808,675 8,984,849 9,164,546 9,347,837 9,534,794 9,725,490 9,920,000 27.155%27.704%28.217%27.646%27.040%24.464%24.089% 0.03%2.02%1.85%-2.02%-2.19%-9.53%-1.53% 9/1/2021 720,200 741,806 764,060 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2025 2026 2027 2028 2029 2030 2031 Projected 1,151 1,197 1,244 1,243 1,240 1,144 1,150 23$ 47$ 46$ (1)$ (3)$ (96)$ 5$ 2.03%4.07%3.88%-0.07%-0.23%-7.71%0.45% 2.0%2.0%2.0%2.0%2.0%2.0%2.0% 2%2%2%2%2%2%2% CITY OF SCANDIA Financial Management Plan Capital Improvement Fund 401 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 0.00%0.00%4.00%4.00%4.00% 2017 2018 2019 2020 2021 2022 2023 2024 Actual Budget Projected REVENUE 5 Property taxes 30,000 100,000 230,000 150,000 250,000 6 Intergovernmental 33,054 74,873 481,250 481,250 7 Special assessments 146 149 50 51 52 53 8 Investment Income 2,412 4,837 12,751 9 Refunds and Reimbursements 11,162 12,530 13,265 10 Park Dedication Fees 11 Rental and lease income 0 0 0 0 0 12 Miscellaneous Revenue 7,492 21,500 0 0 0 13 Total Revenue 32,412 45,383 109,270 149 100,050 722,463 643,832 263,318 EXPENSES 14 Total Current 7,306 9,350 4,733 0 0 15 Debt service 0 0 0 0 16 Capital project offset 17 Total Capital Projects 6,335 115,339 169,181 115,788 544,000 631,280 594,880 748,597 18 Total Expenses 13,641 124,689 173,914 115,788 544,000 631,280 594,880 748,597 19 Revenue Over / (Under) Expenses 18,771 (79,306)(64,644)(115,639)(443,950)91,183 48,952 (485,279) OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 0 21 Transfers In from General Fund 403,500 550,602 0 200,000 0 0 0 22 Transfers Out to Sewer Fund (100,000)(10,000) 23 Transfers Out- 24 Total Other Sources / (Uses)0 303,500 550,602 0 190,000 0 0 0 25 Prior Period Adjustments 26 Ending Fund Balance 403,602 627,796 1,113,754 998,115 744,165 835,348 884,300 399,021CASH FLOW ANALYSIS CITY OF SCANDIA Financial Management Plan Capital Improvement Fund 401 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 0.00%0.00%4.00%4.00%4.00% 2021 2019 2020 2021 2022 2023 2024 Capital Project Name First Year Last Year Costs Projected 27 28 Broadband Expansion 2021 307,000 - 307,000 - - - 29 Community Center Upgrade 2021 15,000 - 15,000 - - - 30 Fire Department Radio Replacement 2021 75,000 - 75,000 - - - 31 Radio Replacement 2021 10,000 - 10,000 - - - 32 Broadband Expansion 2022 307,000 - - 319,280 - - 33 Community Center HVAC/FD Replacement Replacement2022 50,000 - - 52,000 - - 34 Annex Roof Replacement 2021 18,000 - 18,000 - - - 35 2nd Fire Station 2025 180,000 - - - - - 36 FD/PW Bldg Roof Replacement 2021 119,000 - 119,000 - - - 37 Bliss Additions Stormwater plan 2022 250,000 - - 260,000 - - 38 Broadband Expansion 2023 250,000 - - - 270,400 - 39 Community Center Upgrade 2023 20,000 - - - 21,632 - 40 Arts & Heritage Center Amphitheater 2023 30,000 - - - 32,448 - 41 Bliss Additions Stormwater plan 2023 250,000 - - - 270,400 - 42 Community Center Upgrade 2026 600,000 - - - - - 43 Exhaust removal system 2024 48,000 - - - - 53,993 44 Warning Sirens 2024 7,500 - - - - 8,436 45 Cold Storage Building 2024 150,000 - - - - 168,730 46 Bliss Additions Stormwater plan 2024 110,000 - - - - 123,735 47 Bliss Additions Stormwater plan 2025 35,000 - - - - - 48 Thermo Cameras 2027 8,000 - - - - - 49 UTV/Trailer 2027 28,000 - - - - - 50 Jaws of Life 2028 12,000 - - - - - 51 CIP placeholder 2029 2031 75,000 - - - - - 52 Broadband Expansion 2024 350,000 - - - - 393,702 53 Fire Station HVAC Replacement - - - - - 54 Back-up Generator for Fire Hall - - - - - 55 Layton Avenue N Segment Repair 47,000 - - - - - 56 89 90 Total Capital Projects 3,351,500 - - - - 544,000 631,280 594,880 748,597 CAPITAL PROJECTS & DEBT LEVYProject 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2025 2026 2027 2028 2029 2030 2031 285,000 250,000 300,000 265,000 200,000 45,000 35,000 0 0 0 0 0 0 54 55 56 57 58 59 60 5,985 6,578 9,978 12,714 15,413 15,874 13,956 0 0 0 0 0 0 0 0 0 0 0 0 0 0 291,039 256,633 310,034 277,771 215,471 60,933 49,016 0 0 0 0 0 0 0 0 0 82,061 82,061 82,061 82,061 82,061 251,520 729,992 45,551 15,791 102,643 106,748 111,018 251,520 729,992 127,613 97,853 184,704 188,809 193,079 39,519 (473,359)182,421 179,918 30,767 (127,876)(144,063) 700,000 0 0 0 0 0 0 0 0 700,000 0 0 0 0 0 438,540 665,182 847,603 1,027,521 1,058,288 930,412 786,348 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2025 2026 2027 2028 2029 2030 2031 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 210,575 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 729,992 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 40,945 - - - - - - - - 10,123 - - - - - - 35,429 - - - - - - - 15,791 - - - - - - - 102,643 106,748 111,018 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 251,520 729,992 45,551 15,791 102,643 106,748 111,018 CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund 404 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 4.00%4.00% 2017 2018 2019 2020 2021 2022 2023 Actual Budget Projected REVENUE 5 Property taxes 28,137 10,000 20,000 30,000 6 Intergovernmental 4,300 9,380 10,585 7 Charges for services 1,950 1,650 1,650 1,600 7,600 7,600 8 Investment Income 132 853 2,600 1,614 9 Sale of capital assets 140,000 2,015 578 10 Park Dedication Fees 3,000 12,000 3,000 6,000 11 Rental and lease income 0 0 0 0 12 Miscellaneous Revenue 500 1,269 6,595 802 0 0 13 Total Revenue 5,582 15,772 158,145 39,933 28,185 29,615 38,178 EXPENSES 14 Total Current 1,413 2,472 0 15 Debt service 0 0 0 0 16 Total Capital Projects 22,650 27,847 40,585 125,408 0 17 Total Expenses 0 1,413 25,122 27,847 40,585 125,408 0 18 Revenue Over / (Under) Expenses 5,582 14,359 133,023 12,086 (12,400)(95,793)38,178 OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 0 20 Transfers In 100,000 0 21 Transfers Out (103,000) 22 Transfers Out- 23 Total Other Sources / (Uses)0 100,000 (103,000)0 0 0 0 24 Prior Period Adjustments 25 Ending Fund Balance (9,745)104,614 134,636 146,722 134,322 38,529 76,707 Multiple 2021 2019 2020 2021 2022 2023 Capital Project Name Year?First Year Last Year Costs 26 27 Playground Equipment - Community Center Park 2022 100,000 - - 104,000 - 28 Pleasure Rink Expansion 2024 10,000 - - - - 29 Replacement of the boards at the the rink 2024 50,000 - - - - 30 Lilleskogen Park Picnic Shelter 2022 10,000 - - 10,400 - 31 Playground Equipment - Erickson ballfield 2025 50,000 - - - - 32 Cycling & Trails 2025 30,000 - - - - 33 Nature park trails 2021 10,000 - 10,000 - - 34 Settlers Monument Improvements 2021 5,000 - 5,000 - - 35 Lilleskogen Praire/Wetland Restoration Project 2022 10,585 - - 11,008 - 36 Lilleskogen Park Park Signage 2021 10,000 - 10,000 - - 37 Lilleskogen Praire/Wetland Restoration Project 2021 10,585 - 10,585 - - 38 Lilleskogen Praire/Wetland Restoration Project 2026 10,000 - - - - 38 Park Planning 2021 5,000 - 5,000 - - 39 Replacement ballfield for South Field 2024 20,000 - - - - 40 CIP placeholder Yes 2025 2031 50,000 - - - - 74 75 Total Capital Projects 381,170 - - - - 40,585 125,408 - CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProject 2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2024 2025 2026 2027 2028 2029 2030 2031 50,000 85,000 85,000 85,000 85,000 85,000 25,000 25,000 7,600 7,600 7,600 7,600 7,600 7,600 7,600 7,600 1,151 682 (200)91 532 942 1,319 760 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 58,751 93,282 92,400 92,691 93,132 93,542 33,919 33,360 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 89,989 152,082 73,000 63,266 65,797 68,428 71,166 74,012 89,989 152,082 73,000 63,266 65,797 68,428 71,166 74,012 (31,238)(58,800)19,400 29,425 27,335 25,114 (37,247)(40,652) 0 0 0 0 0 0 0 0 45,468 (13,331)6,069 35,494 62,829 87,943 50,696 10,044 2024 2025 2026 2027 2028 2029 2030 2031 - - - - - - - - 11,249 - - - - - - - 56,243 - - - - - - - - - - - - - - - - 58,493 - - - - - - - 35,096 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 12,167 - - - - - - - - - - - - - 22,497 - - - - - - - - 58,493 60,833 63,266 65,797 68,428 71,166 74,012 89,989 152,082 73,000 63,266 65,797 68,428 71,166 74,012 CITY OF SCANDIA Financial Management Plan Equipment Replacement Fund 406 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Actual Budget Projected REVENUE 5 Property taxes 30,000 27,894 30,000 130,000 30,000 40,000 40,000 75,000 75,000 75,000 75,000 75,000 25,000 15,000 6 Intergovernmental 0 0 0 0 0 0 0 0 0 0 7 Sale of capital assets 14,300 500 10,000 7,000 50,000 35,000 0 0 0 0 0 0 0 8 Investment Income 3,523 3,212 4,376 2,000 500 508 516 524 532 540 548 556 564 572 581 9 Refunds and Reimbursements 10 Park Dedication Fees 11 Rental and lease income 0 0 0 0 0 0 0 0 0 0 0 0 12 Miscellaneous Revenue 9,540 0 0 0 0 0 0 0 0 0 0 13 Total Revenue 3,523 57,052 32,770 42,000 137,500 80,508 75,516 40,524 75,532 75,540 75,548 75,556 75,564 25,572 15,581 EXPENSES 14 Total Current 400 0 0 0 0 0 0 0 0 0 15 Debt service 0 0 0 0 57,129 57,129 57,129 57,129 57,129 57,129 57,129 57,129 16 Equipment replacement capital offset (79,000)(303,000)(67,000) 17 Total Capital Projects 195,094 257,477 75,961 93,498 52,500 302,640 574,330 67,492 0 0 0 0 273,714 0 0 18 Total Expenses 195,094 257,877 75,961 93,498 52,500 223,640 271,330 57,621 57,129 57,129 57,129 57,129 330,843 57,129 57,129 19 Revenue Over / (Under) Expenses (191,571)(200,825)(43,191)(51,498)85,000 (143,132)(195,814)(17,097)18,403 18,411 18,419 18,427 (255,279)(31,557)(41,548) OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 160,000 0 500,000 21 Transfers In 8,312 22 Transfers Out 23 Transfers Out- 24 Total Other Sources / (Uses)168,312 0 0 0 0 0 500,000 0 0 0 0 0 0 0 0 25 Prior Period Adjustments 26 Ending Fund Balance 477,802 276,977 233,786 182,288 267,288 124,156 428,342 411,245 429,648 448,058 466,477 484,904 229,624 198,067 156,519 2021 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Project Name First Year Costs Projected 27 28 Bolins Lawnmower 2021 9,000 - 9,000 - - - - - - - - - - 29 Pickup w/Plow Replacement 2011 Ford F250 (103-11)2021 43,500 - 43,500 - - - - - - - - - - 30 Grass Rig 5175 Replacement 2022 60,000 - - 62,400 - - - - - - - - - 31 Fire Boat 2022 25,000 - - 26,000 - - - - - - - - - 32 Tiger Ditch Rear Mower Replacement 2022 16,000 - - 16,640 - - - - - - - - - 33 Tiger Boom Mower Attachment Replacement 2022 17,000 - - 17,680 - - - - - - - - - 34 1999 JD-6410 Tractor Replacement (302-99)2022 133,000 - - 138,320 - - - - - - - - - 35 Skid Loader and Trailer 2022 40,000 - - 41,600 - - - - - - - - - 36 Tanker 5178 Replacement 2023 250,000 - - - 270,400 - - - - - - - - 37 2011 Mack Dump Truck/Plow Replacement (203-11)2023 225,000 - - - 243,360 - - - - - - - - 38 One-Ton F-550 Work Truck 2023 56,000 - - - 60,570 - - - - - - - - 39 Kubota F3990 Tractor Mower w/Broom & Blower (303-09) 2024 45,000 - - - - 50,619 - - - - - - - 40 Asphalt Patching Equipment Trailer (312)2024 15,000 - - - - 16,873 - - - - - - - 41 Western Star Dump Truck/ Plow (Replace 201- 17) 2029 200,000 - - - - - - - - - 273,714 - - 42 - - - - - - - - - - - - 43 44 45 Total Capital Projects 1,134,500 - - - - 52,500 302,640 574,330 67,492 - - - - 273,714 - - CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProject CITY OF SCANDIA Financial Management Plan Local Road Improvement Fund 408 0 0 0 0 0 0 0 0 0 0 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Actual Budget Projected REVENUE 5 Property taxes 560,533 725,050 352,326 381,516 438,539 340,000 550,000 550,000 800,000 800,000 6 Levy off set to maintain taxes (140,000) (385,000) (480,000) (770,000) (755,000) 7 Special assessments 693 8 Investment Income 6,718 19,726 23,740 19,228 13,156 1,746 2,270 1,476 1,465 2,769 2,217 2,233 2,266 9 Refunds and Reimbursements 10 Park Dedication Fees 11 Rental and lease income 0 0 0 0 0 0 0 0 0 0 0 0 12 Miscellaneous Revenue 0 0 0 0 0 0 0 0 0 0 13 Total Revenue 567,251 744,776 376,759 381,516 438,539 219,228 178,156 71,746 2,270 31,476 46,465 2,769 2,217 2,233 2,266 EXPENSES 14 Total Current 0 0 0 0 0 0 0 0 0 15 Debt service 0 0 0 0 0 0 0 0 0 0 0 0 16 Principal 17 Interest 77,339 18 Capital project offset (700,000)(1,000,000)(1,300,000)(1,138,787)(1,000,000)(1,080,000) 19 Total Capital Projects 88,753 4,672,273 87,818 355,305 915,000 624,000 938,829 736,786 1,055,212 1,332,235 1,098,297 1,039,586 1,081,170 0 0 20 Total Expenses 88,753 4,749,612 87,818 355,305 915,000 624,000 938,829 36,786 55,212 32,235 (40,490)39,586 1,170 0 0 21 Revenue Over / (Under) Expenses 478,498 (4,004,836)288,941 26,211 (476,461)(404,772)(760,673)34,960 (52,942)(759)86,955 (36,817)1,047 2,233 2,266 OTHER FINANCING SOURCES / (USES) 22 Bond Proceeds 3,835,000 23 Bond premium 59,645 24 Transfers In 602,518 18,314 80,000 0 0 0 0 0 0 0 0 0 0 25 Transfers Out 26 Transfers Out- 27 Total Other Sources / (Uses)602,518 3,912,959 0 0 80,000 0 0 0 0 0 0 0 0 0 0 28 Prior Period Adjustments 29 Ending Fund Balance 1,455,036 1,363,159 1,652,100 1,678,311 1,281,850 877,078 116,405 151,365 98,423 97,665 184,620 147,803 148,851 151,083 153,350 2021 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Project Name First Year Costs Projected 30 31 2021 Local Road Improvement Project 2021 70,000 - 70,000 - - - - - - - - - - 32 2021 Local Road Improvement Project 2021 845,000 - 845,000 - - - - - - - - - - 33 2022 Local Road Improvement Project 2022 600,000 - - 624,000 - - - - - - - - - 34 2023 Seal Coating Project 2023 183,000 - - - 197,933 - - - - - - - - 35 Seal boring 2023 20,000 - - - 21,632 - - - - - - - - 36 2023 Local Road Improvement Project 2023 665,000 - - - 719,264 - - - - - - - - 37 2024 Local Road Improvement Project 2024 655,000 - - - - 736,786 - - - - - - - 38 2025 Seal Coating Project 2025 252,000 - - - - - 294,804 - - - - - - 39 2025 Local Road Improvement Project 2025 630,000 - - - - - 737,011 - - - - - - 40 Seal boring 2025 20,000 - - - - - 23,397 - - - - - - 41 2026 Seal Coating Project 2026 335,000 - - - - - - 407,579 - - - - - 42 2026 street reconstruction 2026 760,000 - - - - - - 924,656 - - - - - 43 2027 street reconstruction 2027 770,000 - - - - - - - 974,296 - - - - 44 2027 seal coating and boring 2027 98,000 - - - - - - - 124,001 - - - - 45 2028 street reconstruction 2028 790,000 - - - - - - - - 1,039,586 - - - 46 2029 street reconstruction 2029 770,000 - - - - - - - - - 1,053,798 - - 47 2029 seal coating and boring 2029 20,000 - - - - - - - - - 27,371 - - 48 - - - - - - - - - - - - 49 50 51 - - - - - - - - - - - - 52 53 54 Total Capital Projects 7,483,000 - - - - 915,000 624,000 938,829 736,786 1,055,212 1,332,235 1,098,297 1,039,586 1,081,170 - - CASH FLOW ANALYSISProject CAPITAL PROJECTS & DEBT LEVY CITY OF SCANDIA Financial Management Plan Uptown Sewer Fund 612 Inflation Assumptions 1 Revenue (Non-property tax) Inflation on rates 2 Interest Earnings 3 Expenses 4 CIP Inflation Factor 2017 REVENUE 5 6 Charges for services 17,371 7 Special assessments 8 Intergovernmental 2 9 Interest 36 10 11 12 13 Total Revenue 17,409 EXPENSES 14 Wages 7,928 Materials 174 Professional services 120 Repair and maintenance 1,853 Other 2,233 Depreciation 4,877 15 Debt service 16 17 Total Expenses 17,185 18 Revenue Over / (Under) Expenses 224 OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 20 Transfers In 21 Purchase of capital assets 22 Advance to other fund 23 Transfers Out- 24 Total Other Sources / (Uses)0 25 Change in balance sheet 26 Ending Cash 4,196 2021 Capital Project Name First Year Costs Projected 27 28 Drain field Blower 2021 4,000.00 CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProject 29 Uptown Pump 1 Replacement 2024 5,800.00 30 Uptown Pump 2 Replacement 2024 5,800.00 31 Drainfield Pump 1 Replacement 2022 5,800.00 32 Drainfield Pump 2 Replacement 2022 5,800.00 33 34 35 36 37 38 39 40 41 42 43 44 45 Total Capital Projects 27,200 - PROJECTED NEW DEBT TERMS 46 Par Amount (Line 14)- 47 Number of Years 9 48 Interest Rate 49 New Debt Levy 0 Debt Service Term 0 Bonded Debt 0 9 0 Bonded Debt 0 9 0 Bonded Debt 0 9 0 Bonded Debt 2019 10 0 Bonded Debt 2020 10 0 Bonded Debt 2021 10 0 Bonded Debt 2022 10 0 Bonded Debt 2023 10 0 Bonded Debt 2024 10 0 Bonded Debt 2025 10 0 Bonded Debt 2026 10 0 Bonded Debt 2027 10 0 Bonded Debt 2028 10 Bonded Debt 2029 10 2029 10 2030 10 Total Debt Service 157 0 0 0 0 0 0 0 0CAPITAL PROJECTS & DEBT LEVY 0 0 0 0 0 2.00%2.00%2.00%2.00%2.00% 3.00%3.00%3.00% 1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00% 2018 2019 2020 2021 2022 2023 2024 Budget Budget 21,347 20,535 21,800 23,000 23,690 24,401 25,133 48 11 0 0 0 49 357 269 365 0 0 0 0 0 0 0 0 21,444 20,546 21,800 23,000 24,047 24,670 25,498 7,850 4,385 8,850 10,000 10,200 10,404 10,612 1,369 205 375 300 306 312 318 104 579 350 700 714 728 743 801 1,258 3,300 3,500 3,570 3,641 3,714 2,404 2,876 3,496 3,030 3,091 3,153 3,216 4,877 4,877 4,877 4,877 4,975 5,075 5,177 0 0 0 0 0 17,405 14,180 21,248 22,407 22,856 23,313 23,780 4,039 6,366 552 593 1,191 1,357 1,718 0 0 0 0 0 (2,640)(1,200)(5,200)(12,064)0 (13,048) 2,640 (2,640) (2,640)0 (1,200)(5,200)(12,064)0 (13,048) (1,125)(1,258) 9,347 19,332 23,561 23,831 17,933 24,365 18,212 2019 2020 2021 2022 2023 2024 - 4,000 - - - Projected - - - - 6,524 - - - - 6,524 - - 6,032 - - - - 6,032 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 4,000 12,064 - 13,048 Per MA: - - - - - - - 9 10 10 10 10 10 10 2.50%3.00%3.00%2.00%2.50%3.00% 0 0 0 0 0 0 0 0 2019 2020 2021 2022 2023 2024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2019 2020 2021 2022 2023 2024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 3 4 5 0 0 0 1 2 3 4 0 0 0 0 1 2 3 0 0 0 0 0 1 2 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2025 2026 2027 2028 2029 2030 2031 25,887 26,663 27,463 28,287 29,136 30,010 30,910 0 0 0 0 0 0 0 0 0 0 0 0 0 0 273 381 496 620 751 891 1,041 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26,160 27,044 27,960 28,907 29,887 30,901 31,951 10,824 11,040 11,261 11,486 11,716 11,950 12,189 324 330 337 344 351 358 365 758 773 788 804 820 836 853 3,788 3,864 3,941 4,020 4,100 4,182 4,266 3,280 3,346 3,413 3,481 3,551 3,622 3,694 5,281 5,387 5,495 5,605 5,717 5,831 5,948 0 0 0 0 0 0 0 24,255 24,740 25,235 25,740 26,255 26,779 27,315 1,905 2,304 2,725 3,167 3,632 4,122 4,636 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25,398 33,089 41,309 50,080 59,429 69,383 79,966 2025 2026 2027 2028 2029 2030 2031 - - - - - - - Projected - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - As of Date: - - - - - - - 10 10 10 10 10 10 10 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 0 0 0 0 0 0 0 2025 2026 2027 2028 2029 2030 2031 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2025 2026 2027 2028 2029 2029 2030 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 7 8 9 10 0 0 5 6 7 8 9 10 0 4 5 6 7 8 9 10 3 4 5 6 7 8 9 2 3 4 5 6 7 8 1 2 3 4 5 6 7 0 1 2 3 4 5 6 0 0 1 2 3 4 5 0 0 0 1 2 3 4 0 0 0 0 1 1 2 1 2 0 1 CITY OF SCANDIA Financial Management Plan Big Marine Lake Sewer Fund 602 Inflation Assumptions 1 Revenue (Non-property tax) Inflation on rates 2 Interest Earnings 3 Expenses 4 CIP Inflation Factor 2017 REVENUE 5 6 Charges for services 86,418 7 Special assessments 1,367 8 Intergovernmental 7 9 Interest 550 10 American Rescue Plan? 11 State bonding 12 13 Total Revenue 88,342 EXPENSES 14 Wages 17,947 Materials 863 Professional services 4,967 Repair and maintenance 29,138 Other 10,343 Depreciation 38,718 15 Debt service 16 17 Total Expenses 101,976 18 Revenue Over / (Under) Expenses (13,634) OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 20 Transfers In 21 Purchase of capital assets (10,270) 22 Transfers Out- 23 Total Other Sources / (Uses)(10,270) 24 Change in balance sheet 25 Ending Cash 84,391 2021 Capital Project Name First Year Costs Projected 26 27 A/E Drainfield 200,000 28 Bliss L.S. 1 Pump 1 6,050 CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProject 29 Bliss nitrate treatment equipment 2022 1,390,000 30 Bliss L.S. 1 Pump 2 2024 6,050 31 Bliss LS 2 Pump 1 2024 6,000 32 Bliss LS 2 Pump 2 2024 6,000 33 Bliss LS 3 Pump 1 2021 6,000 34 Bliss LS 3 Pump 2 2021 6,000 35 Bliss LS 4 Pump 1 2021 6,000 36 Bliss LS 4 Pump 2 2021 6,000 37 AE LS 1 PUMP 2 2023 12,000 38 Distribution Network Replacement 2021 5,000 39 Distribution Network Replacement 2022 8,000 40 Distribution Network Replacement 2023 11,000 41 Distribution Network Replacement 2024 14,000 42 Distribution Network Replacement 2025 17,000 43 44 Total Capital Projects 1,705,100 - PROJECTED NEW DEBT TERMS 45 Par Amount (Line 14)- 46 Number of Years 9 47 Interest Rate 48 New Debt Levy 0 Debt Service Term 0 Bonded Debt 0 9 0 Bonded Debt 0 9 0 Bonded Debt 0 9 0 Bonded Debt 2019 10 0 Bonded Debt 2020 10 0 Bonded Debt 2021 10 0 Bonded Debt 2022 10 0 Bonded Debt 2023 10 0 Bonded Debt 2024 10 0 Bonded Debt 2025 10 0 Bonded Debt 2026 10 0 Bonded Debt 2027 10 0 Bonded Debt 2028 10 Bonded Debt 2029 10 2029 10 2030 10 Total Debt Service 157 0 0 0 0 0 0 0 0 0CAPITAL PROJECTS & DEBT LEVY 0 0 0 0 0 0 2.00%2.00%2.00%2.00%2.00% 5.00%5.00%5.00% 1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00% 0.00%4.00%4.00% 2018 2019 2020 2021 2022 2023 2024 Budget Budget 85,518 81,238 90,615 88,045 92,447 97,070 101,923 611 4,824 600 200 138 35 0 0 0 770 3,226 200 700 8,172 (2,054)(2,217) 475,000 695,000 87,037 89,323 91,415 563,945 795,619 95,015 99,707 23,592 19,476 26,400 23,000 23,460 23,929 24,408 1,742 996 2,000 3,700 3,774 3,849 3,926 2,377 20,978 8,000 10,200 10,404 10,612 10,824 23,151 17,863 31,200 31,200 31,824 32,460 33,109 7,918 19,072 9,275 9,705 9,899 10,097 10,299 39,631 39,630 49,700 51,200 52,224 53,268 54,333 0 0 0 0 0 98,411 118,015 126,575 129,005 131,585 134,215 136,899 (11,374)(28,692)(35,160)434,940 664,034 (39,200)(37,192) 0 0 0 0 0 (23,276)(9,000)(38,000)(1,398,000)(24,877)(36,052) 0 (23,276)(9,000)(38,000)(1,398,000)(24,877)(36,052) (8,836)(373) 103,812 91,101 96,641 544,781 (136,961)(147,770)(166,681) 2019 2020 2021 2022 2023 2024 - - - - - - - - - - Projected See Option III Bond Funding for updated projection - - 1,390,000 - - - - - - 6,805 - - - - 6,749 - - - - 6,749 - 6,000 - - - - 6,000 - - - - 6,000 - - - - 6,000 - - - - - - 12,979 - - 5,000 - - - - - 8,000 - - - - - 11,898 - - - - - 15,748 - - - - - - - - 29,000 1,398,000 24,877 36,052 Per MA: - - - - - - - 9 10 10 10 10 10 10 2.50%3.00%3.00%2.00%2.50%3.00% 0 0 0 0 0 0 0 0 2019 2020 2021 2022 2023 2024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2019 2020 2021 2022 2023 2024 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 3 4 5 0 0 0 1 2 3 4 0 0 0 0 1 2 3 0 0 0 0 0 1 2 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 5.00%5.00%5.00%5.00%5.00%5.00%5.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2025 2026 2027 2028 2029 2030 2031 107,019 112,370 117,989 123,888 130,083 136,587 143,416 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (2,500)(2,494)(2,134)(1,711)(1,219)(653)(9) 104,519 109,876 115,854 122,177 128,864 135,934 143,407 24,896 25,394 25,902 26,420 26,948 27,487 28,037 4,005 4,085 4,167 4,250 4,335 4,422 4,510 11,040 11,261 11,486 11,716 11,950 12,189 12,433 33,771 34,446 35,135 35,838 36,555 37,286 38,032 10,505 10,715 10,929 11,148 11,371 11,598 11,830 55,420 56,528 57,659 58,812 59,988 61,188 62,412 0 0 0 0 0 0 0 139,637 142,429 145,278 148,184 151,147 154,170 157,254 (35,118)(32,553)(29,424)(26,007)(22,283)(18,236)(13,847) 0 0 0 0 0 0 0 (19,888)0 0 0 0 0 0 (19,888)0 0 0 0 0 0 (166,267)(142,291)(114,056)(81,251)(43,546)(594)47,971 2025 2026 2027 2028 2029 2030 2031 - - - - - - - - - - - - - - Projected - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 19,888 - - - - - - 19,888 - - - - - - As of Date: - - - - - - - 10 10 10 10 10 10 10 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 0 0 0 0 0 0 0 2025 2026 2027 2028 2029 2030 2031 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2025 2026 2027 2028 2029 2029 2030 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 7 8 9 10 0 0 5 6 7 8 9 10 0 4 5 6 7 8 9 10 3 4 5 6 7 8 9 2 3 4 5 6 7 8 1 2 3 4 5 6 7 0 1 2 3 4 5 6 0 0 1 2 3 4 5 0 0 0 1 2 3 4 0 0 0 0 1 1 2 1 2 0 1