Loading...
6e. 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 400,000 416,000 432,640 449,946 467,943 486,661 506,128 526,373 547,428 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 40,196 23,829 8,347 21,743 13,270 4,950 30,877 23,612 9 Refunds and Reimbursements 10 Intergovermental 17,744 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 11 Rental and lease income - - - - - - - - - - - 12 Miscellaneous Revenue - - - - - - - - - - - 13 Total Revenue 239,259 224,127 417,605 867,734 868,007 1,274,467 1,305,862 1,316,106 1,599,213 1,645,385 1,659,174 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,157,395) (467,635) (442,362) (2,788,942) (564,877) (554,632) (271,526) (484,362) (570,573) 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,148,471 680,836 238,474 1,449,532 884,656 330,023 2,058,498 1,574,136 1,003,563 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,377 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,122 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 569,325 592,098 615,782 640,413 666,029 692,671 720,377 749,192 779,160 810,327 842,740 876,449 911,507 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 - 15,053 6,695 20,511 8,619 19,419 30,765 42,681 49,121 57,792 70,927 78,658 92,770 107,601 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 6,900 - - - - - - - - - - - - - - - - - - - - - - - - - - 1,672,513 1,950,792 1,988,292 2,001,032 2,037,448 2,075,435 1,710,420 1,473,716 1,512,355 1,152,019 1,192,162 1,239,984 1,026,008 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 (557,234) (2,078,955) (792,755) 719,985 756,401 794,388 429,373 578,038 875,686 515,350 940,862 988,685 774,708 - 3,000,000 - - - - - - - - - - - 446,328 1,367,373 574,617 1,294,602 2,051,003 2,845,391 3,274,764 3,852,802 4,728,488 5,243,837 6,184,700 7,173,384 7,948,093 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