Loading...
11.a6 408 CIP FundCITY OF SCANDIA CAPITAL IMPROVEMENT PLAN LOCAL ROAD IMPROVEMENT FUND 408 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 Interest Earnings 1.50%3.50%3.50%3.50%3.50%3.50%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%4.00%4.00%4.00%4.00%4.00%3.00%4.00%4.00%4.00%4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Actual Projected REVENUE 5 Property taxes 216,860 212,012 375,000 375,000 390,000 405,600 421,824 438,697 456,245 474,495 493,474 6 Debt levy - 404,638 404,638 809,275 809,275 809,275 1,081,235 1,081,235 1,081,235 7 Special assessments 8 Investment Income 4,655 12,115 10,705 39,080 20,997 3,681 18,905 9,594 396 25,403 17,174 9 Refunds and Reimbursements 10 Intergovermental 17,744 11 Rental and lease income - - - - - - - - - - - 12 Miscellaneous Revenue - - - - - - - - - - - 13 Total Revenue 239,259 224,127 385,705 818,718 815,635 1,218,557 1,250,004 1,257,566 1,537,876 1,581,133 1,591,883 EXPENSES 14 Total Current 15 Debt service 385,369 385,369 385,369 770,738 770,738 770,738 1,029,747 1,029,747 16 Principal 17 Interest 18 Total Capital Projects 595,069 815,000 3,575,000 950,000 925,000 3,678,040 1,100,000 1,100,000 1,100,000 1,100,000 1,200,000 19 Total Expenses 595,069 815,000 3,575,000 1,335,369 1,310,369 4,063,409 1,870,738 1,870,738 1,870,738 2,129,747 2,229,747 20 Revenue Over / (Under) Expenses (355,810) (590,873) (3,189,295) (516,652) (494,734) (2,844,852) (620,734) (613,172) (332,862) (548,615) (637,864) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 4,000,000 1,000,000 22 Bond premium 23 Transfers In 24 Transfers Out 25 Transfers Out- 25 Total Other Sources / (Uses)- - 4,000,000 - - 4,000,000 - - 2,000,000 - - 26 Prior Period Adjustments 27 Ending Fund Balance 896,739 305,866 1,116,571 599,920 105,185 1,260,333 639,599 26,427 1,693,564 1,144,950 507,086 CITY OF SCANDIA Financial Management Plan Local Road Improvement Fund 408 CASH FLOW ANALYSIS Project Multiple 2022 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Number Year?First Year Last Year Costs Actual Proposed Est. 28 1,200,000 28 Soil Borings for 2024 & 2025 PW-061 2023 20000 25,000 29 Soil Borings for 2026 & 2027 PW-062 2025 20000 25,000 30 Soil Borings for 2028 & 2029 PW-069 2027 20000 28,000 31 Soil Borings for 2030 & 2031 PW-070 2029 20000 32 2022 Local Road Improvement Project PW-043 2022 707200 707,200 33 2023 Local Road Improvement Project PW-043 2023 790000 671,745 34 2023 Seal Coat & Crack Filling Project PW-050 2023 183000 168,374 35 2024 Local Road Improvement Project PW-056 2024 815000 3,575,000 36 2025 Local Road Improvement Project PW-053 2025 540000 750,000 37 2025 Seal Coat & Crack Filling PW-052 2025 252000 175,000 38 2026 Local Road Improvement Project PW-035 2027 870000 750,000 39 2026 Seal Coat & Crack Filling Project PW-051 2027 335000 175,000 40 2027 Local Road Improvement Project PW-057 2028 900000 3,500,000 41 2027 Seal Coat & Crack Filling PW-060 2028 78000 150,000 42 2028 Local Road Improvement Project PW-036 2029 1000000 40 1,100,000 43 2029 Local Road Improvement Project PW-060 2030 860000 - 1,100,000 44 2030 Local Road Improvement Project PW-072 2031 880000 - 1,100,000 45 2031 Local Road Improvement Project PW-073 2032 1000000 - 1,100,000 46 Total Capital Projects 9,290,200 - 707,200 865,119 3,575,000 950,000 925,000 3,678,040 1,100,000 1,100,000 1,100,000 1,100,000 1,200,000 PROJECTED NEW DEBT TERMS 47 Par Amount (Line 14)- - - 4,000,000 - - 4,000,000 - - 2,000,000 - - 48 Number of Years 9 15 15 15 15 15 15 15 15 10 15 15 49 Interest Rate 2.00%2.50%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00%5.00% 50 New Debt Levy 0 0 0 0 404,638 404,638 404,638 809,275 809,275 809,275 1,081,235 1,081,235Local Road Project OutlayProject 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.00% 1.50%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.00%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.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 513,213 533,742 555,092 577,295 600,387 624,403 649,379 675,354 702,368 730,463 759,681 790,068 821,671 1,081,235 1,345,100 1,345,100 1,345,100 1,345,100 1,345,100 940,462 668,502 668,502 263,865 263,865 263,865 - 7,606 (1,809) 10,900 (2,149) 7,439 17,517 28,107 33,160 40,380 51,999 58,144 70,600 83,698 - - - - - - - - - - - - - - - - - - - - - - - - - - 1,602,055 1,877,032 1,911,091 1,920,246 1,952,925 1,987,019 1,617,947 1,377,016 1,411,250 1,046,326 1,081,690 1,124,533 905,369 1,029,747 1,029,747 1,281,047 1,281,047 1,281,047 1,281,047 1,281,047 895,678 636,669 636,669 251,300 251,300 251,300 1,200,000 3,000,000 1,500,000 - - - - - - - - - - 2,229,747 4,029,747 2,781,047 1,281,047 1,281,047 1,281,047 1,281,047 895,678 636,669 636,669 251,300 251,300 251,300 (627,693) (2,152,715) (869,956) 639,198 671,878 705,972 336,900 481,338 774,582 409,657 830,390 873,233 654,069 - 3,000,000 - - - - - - - - - - - (120,607)726,678 (143,278)495,921 1,167,799 1,873,771 2,210,671 2,692,009 3,466,590 3,876,248 4,706,638 5,579,871 6,233,940 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 1,200,000 3,000,000 1,500,000 1,200,000 3,000,000 1,500,000 - - - - - - - - - - - 3,000,000 - - - - - - - - - - - 15 15 15 15 15 15 15 15 15 15 15 15 15 5.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 1,081,235 1,081,235 1,345,100 1,345,100 1,345,100 1,345,100 1,345,100 940,462 668,502 668,502 263,865 263,865 263,865