Loading...
4. b) Sewer Financial Management PlanAdditional impact on users if no state bonding received - - 68.80 155.15 262.44 394.70 556.61 753.68 Base Charge 2021 2022 2023 2024 Big Marine Sewer -State Bonding Received 2025 2026 2027 2028 Bonding 2027 2029 2030 2031 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00 a-te Charge 9asa Charge 446.69 Quarterly 87.50 91.88 96.47 101.29 106.36 111.67 Increase Annual 854.40 939.84 1,033.82 1,137.21 1,250.93 1,376.02 1,513.62 1,664.96 1,831 48 2,014.63 2,216.09 Quarterly 213.70 234.96 258.46 284.30 312.73 344.00 378.41 416.25 457 87 503.66 554.02 Increase 642.81 742.44 52.29 54.91 Increase 60.53 Annual 85.44 93.98 103.38 113.72 125.09 137.60 151.36 166.50 113.72 183.15 201.46 Quarterly 298.75 21.26 23.50 25-85 28.43 31.27 34.40 37.84 41.62 25.85 45.79 50.37 nrr47 Adj Charge 64.66 74.69 86.26 99.64 Fn*rgl Adj Charge Annual 0.00 9.80 7 68 10.65 11.71 12.88 14.17 15.59 17.15 8.80 18.86 20.75 Qu-.rte:ly 1.00 2.20 2.42 2.66 2.93 3.22 3.54 3.90 4.29 '.00 4.72 5.19 Additional impact on users if no state bonding received - - 68.80 155.15 262.44 394.70 556.61 753.68 Base Charge 2021 2022 2023 2024 Big Marine 2025 Sewer No State 2026 Bonding 2027 2028 2029 2030 2031 10.00% 10.00% 10.00% 10.00% 15.50% 15.50% 15.50% 15.50% 15.50% 15.50% 9asa Charge 446.69 Quarterly 87.50 91.88 96.47 101.29 106.36 111.67 Increase Annual 854.40 939.84 1,033.82 1,137.21 1,250.93 1,444.82 1,668.77 1,927.43 2,226.18 Quarterly 2,571.24 2,969.78 4.59 4.82 Quarterly 213.70 234.96 258.46 284.30 312.73 361.21 417.19 481.86 556.54 Annual 642.81 742.44 52.29 54.91 Increase 60.53 Annual 85.44 93.98 103.38 113.72 193.89 223.95 258.66 298.75 345.06 398.54 Quarterly 21.26 23 50 25.85 28.43 48.47 55.99 64.66 74.69 86.26 99.64 Fn*rgl Adj Charge Annual N.00 8.80 9.68 10.65 11.71 13.53 15.63 18.05 20.84 24.08 27.81 Quarry-ly '.00 2.20 2.42 2.66 2.93 3.38 3.91 4.51 5.21 6.02 6.95 Additional impact on users if no state bonding received - - 68.80 155.15 262.44 394.70 556.61 753.68 Base Charge 2021 2022 5.00% Uptown Sewer System 2023 2024 5.00% 5.00% 2025 5.00% 2026 5.00% Annual 349.99 367.49 385.86 405.16 425.42 446.69 Quarterly 87.50 91.88 96.47 101.29 106.36 111.67 Increase Annual 17.50 18.37 19.29 20.26 21.27 Quarterly 4.38 4.59 4.82 5.06 5.32 Volunw Charge Annual 47.43 49.80 52.29 54.91 57.65 60.53 14,978.63 374.47 17,170.00 2,191.38 429.26 219.14 (54.78) CITY OF SCANDIA 86,418 1,367 7 550 88,342 85,518 611 138 770 87,037 81,236 4,824 35 3,226 89,323 90,615 600 200 91,415 88,045 200 700 475,000 563,945 96,850 0 8,172 0 105,021 106,534 0 8,428 519,168 634,130 117,186 0 984 118,172 128,907 0 0 1,320 130,227 141,797 0 0 1,866 243,331 386,994 155,977 0 0 2,481 171,575 0 0 5,397 Financial Management Plan 207,606 0 0 6.386 228,366 0 0 2224 158,458 176,972 191,157 215,992 230,590 EXPENSES Big Marine Lake Sewer Fund 602 14 Wages 17,947 23,592 19,476 26,400 nRation Asxumutlons 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,946 27,487 28,037 15 Materials 883 1 Revenue (Non -property tax) 2.00% 2.00% 2.00% 200% 200% 200% 200% 2.00% 2 009/, 2 00% 2 00% 200% Inflation on rales 16 Professional services 4,967 10.00% 10.00% 1000% 10.00% 10.00% 10.00% 1000% 10 00% 1000% 1000% 2 Interest Earnings 150% 1.50% 1.50% 150% 150% 1.50% 1.50% 1.50% 1 50% 1.50% 1.50% 150% 3 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 300% 3.00% 3.00% 300% 4 CIP Inflation Factor 10,097 10,299 4.00% 4.00% 400% 4.00% 4.00% 4.00% 400% 400% 400% 400% 5 6 Charges for services 7 Special assessments 8 Intergovernmental 9 Interest 10 Amens Rescue Plan 11 Stale bonding 12 13 Total Revenue 86,418 1,367 7 550 88,342 85,518 611 138 770 87,037 81,236 4,824 35 3,226 89,323 90,615 600 200 91,415 88,045 200 700 475,000 563,945 96,850 0 8,172 0 105,021 106,534 0 8,428 519,168 634,130 117,186 0 984 118,172 128,907 0 0 1,320 130,227 141,797 0 0 1,866 243,331 386,994 155,977 0 0 2,481 171,575 0 0 5,397 184732 0 0 2,425 207,606 0 0 6.386 228,366 0 0 2224 158,458 176,972 191,157 215,992 230,590 EXPENSES 14 Wages 17,947 23,592 19,476 26,400 23,000 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,946 27,487 28,037 15 Materials 883 1,742 996 2,000 3,700 3,774 3,849 3,926 4,005 4,085 4,167 4,250 4,335 4,422 4,510 16 Professional services 4,967 2,377 20,978 8,000 10,200 10,404 10,612 10,824 11,040 11,261 11,486 11,716 11,950 12,189 12,433 17 Repair and maintenance 29,138 23,151 17,863 31,200 31,200 31,824 32,460 33,109 33,771 34,446 35,135 35,838 36,555 37,286 38,032 18 Other 10,343 7,918 19,072 9,275 9,705 9,899 10,097 10,299 10,505 10,715 10,929 11,148 11,371 11,596 11,630 19 Depredation 36,718 39,631 39,630 49,700 51,200 52,224 53,268 54,333 55,420 56,526 57,659 58,812 59,986 61,188 62,412 20 21 Debt service 0 0 0 0 0 0 0 20,942 77,484 77,484 161,251 161,251 22 23 Total Expenses 101,976 98,411 118,015 126,575 129,005 131,585 134,215 136,899 139,637 142,429 166,220 225,668 228,631 315,421 318,505 24 Revenue Over 1(Under) Expenses (13,634) (11,374) (28,692) (35,160) 434,940 (26,564) 499,915 (18,727) (9,410) 244,565 (7,762) (48,696) (37,474) (99,429) (67,914 OTHER FNIWCWG SOURCES I W_KM 25 Bond Pmceeds 0 250,000 675,000 1,000,000 26 Transfers In 0 0 0 0 9 0 0 0 0 0 0 27 Purchase of c*W assets (10,270) (23,276) (9,000) (38,000) (8,580) (1,049,423) (13,217) (9,652) (510,082) (530,484) (208,247) (625,093) (372,552) (20,353 28 Transfers Out- ut29 144,516 (206,247) 374,907 (372,552) (20,353 29Total Other Sources / (Uses) (10,270) 0 (23,276} (9,006) (38,0001 (8,5801 (1,04.9,423} (13,217} (9,652) (260,062} 30 Chanaa in balance sheet (8,836) (373) CITY OF SCANDIA Financial Management Plan Big Marine Lake Sewer Fund 602 nft0on Acaum Mons 200% 2 00% 2.00% 200% 2.00% 200% 2.00% 2.00% 2.00% 2.00% 2,00% 2,00% 1 Revenue (Non -property tax) 188.732 1000% 10.00% 10,00% 10.00% 10 00 % 1000% 1000% 10.00% 10.00% 10,00% Inflation on rates 1.50% 150% 150% 1,50% 1.50% 1.50% 1 50% 150% 150% 1.50% 1,50% 1.50% 2 Interest Earnings 300% 300% 3.00% 3.00% 3.00% 3.00% 3.00% 300% 3.00% 3.00% 3.00% 3.00% 3 Expenses 7 550 4.00% 4,00% 4.00% 4,00% 4.00% 4 00% 4 00% 4.00% 4 00% 400% 4 CIP Inflation Factor (5,483) 360 (5.922) 9 Interest 0 5 86,418 85,518 81,238 90,615 88,045 96,850 106,534 117,188 128,907 141.797 155,977 171,575 188.732 207,606 228.366 6 Charges for services 1,367 611 4,824 600 200 0 0 0 0 0 0 0 7 Special assessments 138 35 0 0 0 0 0 0 0 0 0 0 8 Intergovernmental 7 550 770 3,226 200 700 1,047 1,196 (6,355) (6,130) (5,697) (5,195) (2,394) (5,483) 360 (5.922) 9 Interest 0 10 American Rescue Plan 0 519, 68 243,331 11 State bonding 12 88,341 87,037 89,323 51,415 86,945 97,896 62&,898 110,832 122,776 379,431 150,782 169,181 183,250 207,965 222,444 13 Total Revenue EXPENSES 17,947 23,592 19,476 26,400 23,000 23,460 23,929 24,408 24,896 25,394 25,902 28,420 26,946 27,487 26,037 14 Wages 863 1,742 996 2,000 3,700 3,774 3,849 3,926 4,005 4,085 4,167 4,250 4,335 4,422 4,510 15 Materials 4,967 2,377 20,978 8,000 10,200 10,404 10,612 10,824 11,040 11,261 11,486 11,716 11,950 12,189 12,433 16 Professional services 29,138 23,151 17,663 31,200 31,200 31,824 32,460 33,109 33,771 34,446 35,135 35,838 36,555 37,286 38,032 17 Repair and maintenance 10,343 7,918 19,072 9,275 9,705 9,899 10,097 10,299 10,505 10,715 10,929 11,148 11,371 11,598 11,830 18 Other 38,718 39,631 39,630 49,700 51,200 52,224 53,268 54,333 55,420 56,528 57,659 58,812 59,988 61,188 62,412 19 Depreciation 200 0 0 0 0 0 0 20,942 77,484 77,484 161,251 161,251 21 Debtservice 22 101,976 98,411 118,015 126,575 129,005 131,585 134,215 136,699 139,637 142,429 166,220 225,668 228,631 315,421 318,505 23 Total Expenses (13,634) (11,374) (28,692) (35,160) (40,060) (33,689) 492,683 (26,067) (16,861) 237,002 (15,438) (56,467) (45,382) (107,455) (96,061 24 Revenue Overl(Under) Expenses OTHER FWIINCIRG S011RCE51(USESi 0 250,000 675,000 1,000,000 25 Bond Proceeds 0 0 0 0 0 0 0 0 0 0 C 26 Transfers In (23,276) (9,000) (36,000) (8,580) (1,049,423) (13,217) (9,652) (510;082) (530,484) (208,247) (625,093) (372,552) (20,352, 27 Purchase of capital assets (10,270) 28 Transfers Out - (10,270) tl (23,276) (9,000) (38,0001 (8,560) (1,049,423) (13,217) (9,552) (280,062) 144,516 (208,247) 374,907 (372,552) (20,35: 29 Total Other Sources/(Uses) 30 Cha npe bhalarre sheet (8.836) {373] CITY OF SCANDIA Financial Management Plan Big Marine Lake Sewer Fund 602 No State Bonding to Ration Assum ouons 2.00% 2.00% 2.00% 2.00% 2.00% 0.00% 2,00% 2.00% 200% 2.00% 2.00% 2 r Revenue (Non -property tax) 10.00% 10.00% 10.00% 10.00% 15.50% 15.50% 15.50% 15.50% 15.50% 1550% Inflation on rates 1.50% 150% 1.50% 150% 1.50% 1.50% 1.50% 150% 1.50% 1.50% 1.50% 1.50% 2 Interest Earrings 3. DO% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 300% 3.00% 3 Expenses 4.00% 4.00% 400% 4.00% 4.00% 400% 4.00% 4-00% 4.00% 4.00% 4 CIP Inflation Factor Sud Bud et P,]. -td (3i<VEMiE 5 86,418 85,518 81,238 90,615 88,045 96,850 106,534 117,188 126,907 148,887 171,965 198,619 229,405 264,963 306,032 6 Charges for services 1,367 611 4,624 600 200 0 0 0 0 0 0 0 7 Special assessments 35 0 0 O 0 0 0 0 0 0 0 8 Inlagovemmental 7 550 138 770 3,226 200 700 8,172 8,426 8,947 8,130 7,505 7.140 8,779 4,677 9,696 2,828 9 Intemst 475.000 10 American Rescue Plan 0 11 Slap bonding 12 8a, 342 87,037 89,323 91,415 563,945 105,021 114,962 716,135 137,037 156,393 179,104 207,390 234,083 274,660 308.861 13 Total ikvenue EXPENSES 17,947 23,592 19,476 26,400 23,000 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,948 27,487 28,03 14 Wages 863 1,742 996 2,000 3,700 3,774 3,849 3,926 4,005 4,085 4,167 4,250 4,335 4,422 4,510 15 Makerials 4,967 2,377 20,978 8,000 10,200 10,404 10,612 10,824 11,040 11,261 11,486 11,716 11,950 12,189 12,433 16 Prdessional services 29,138 23,151 17,863 31,200 31,200 31,824 32,460 33,109 33,771 34,448 35,135 35,838 36,555 37,286 38,032 17 Repair and maintenance 10,343 7,918 19,072 9,275 9,705 9,899 10,097 10,299 10,505 10,715 10,929 11,148 11,371 11,598 11,830 18 Other 38,718 39,631 39,630 49,700 51,200 52,224 53,268 54,333 55,420 56,528 57,659 58,012 59,988 61,188 62,412 19 Depreciation 20 0 0 0 0 84,005 84,805 84,805 126,688 183,231 183,231 266,997 266.997 21 Debt service 22 101,976 96,411 118,015 126,575 129,005 131,585 134,215 221,704 224,442 227,234 271,966 331,415 334,378 421,167 424,251 23 Total Expenses (13,634) (11,374) (28,692) (35,160) 434,940 (26,564) (19,253) (95,569) (87,405) (70,841} (92,662) (124,016) (100,295) (146,508) (115,390 24 Revenue Over I jUnder) Expenses OTNEa r NAHMNG SOURCES_I (I !P) 0 1,050,000 500,000 675,000 1,000,000 25 Bond Proceeds 0 0 0 0 0 0 0 D 0 0 0 26 Transfers In (23,276) (9,000) (38,000) (8,580) (1,049,423) (13,217) (9,652) (510,082) (530,484) (208,247) (625,093) (372,552) (20,35: 27 Purchase of capital assets (10,270) 28 Tranders Out- (10,270) 9 [23,276] ROOM (38.000) 16,5601 577 {13,2171 [9,6521 (10,082) 144,516 (200,247) 374,907 (372,552) 29 Total Other Sources /(Uses) 30 Char vi balance sheat {6,636) [373} CITY OF SCANDIA Financial Management Plan Big Marine Lake Sewer Fund 602 No State Banding Lg9X ASSOmCGar� 106,534 117,188 128,907 2.00% 200% Revenue (Non -property tax) 229,405 264,963 306,032 Inflation on rates 0 0 0 1.50% 1.50% 2 Interest Earnings 0 0 0 3.00% 3.00% 3 Expenses 0 0 0 0 0 4 CIP Inflation Factor 1,196 1,606 680 (57) (536) 9BB r 1,570 r Bu rt r Budget REYENUE 5 86,418 85,518 81,238 90,615 86,045 6 Charges for services 1,367 611 4,824 600 200 7 Special assessments 7 138 35 25,394 25,902 8 Intergovernmental 550 770 3,226 200 700 9 Interest 4,005 4,085 4,167 4,250 0 10 Nnedcan Rescue Plan 4,510 10,404 10,612 10,824 11,040 11 Stale bonding 11,486 11,716 11,950 12,189 12,433 12 ea,342 $1,037 89,323 91,415 86,945 13 Total Revenue 36,555 37,286 38,032 9,899 10,097 EXPENSES 17,947 23,592 19,476 26,400 23,000 14 Wages 863 1,742 996 2,000 3,700 15 Materials 4,967 2,377 20,978 8,000 10,200 16 professional services 29,138 23,151 17,883 31,200 31,200 17 Repair and maintenance 10,343 7,918 19,072 9,275 9,705 18 DBrer 38,718 39,631 39,630 49,700 51,200 19 Depreciation 424,251 (33,689) (26,485) (102,909) (94,856) 20 (100,537) (131,807) (108,202) 0 0 21 Debt service 1,050,000 500,000 675,000 22 101,976 98,411 118,015 126,575 129,005 23 Total Expenses 0 0 0 0 0 24 Revenue Over I(Under) Expenses (13,634) (11,374) (28,692) (35,160) (40,060) OTISR F7fJAN_CrINi3 SOURCES IALSE 1 (530,484) (208,247) (625,093) (372,552) (20,35: 25 Bond Proceeds 0 0 26 Transfers In (10,270) (23,276) (9,000) (38,000) 27 purchase of capital assets 28 Transfers Out - (10,270) 0 (23,276) (91000) (38,000) 29 Total Other Sources/ (Uses) 30 Crtarlae in balance sheet _ (8.8361 (311 31 2.00% 2.00% 2 00% 200% 200% 200% 2.00% 2.00% 200% 2 00% 10 00% 10.00% 10.00% 10.00% 1550% 1550% 15.50% 15.50% 15.50% 15 50% 1.50% 150% 150% 150% 150% 1.50% 1.50% 1.50% 1.50% 150% 300% 300% 300% 3.00% 3.00% 300% 3.00% 300% 300% 300% 400% 4.00% 400% 4.00% 400% 400% 400% 4.00% 400% 400% 96,850 106,534 117,188 128,907 148,887 171,965 198,619 229,405 264,963 306,032 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1,047 1,196 1,606 680 (57) (536) 9BB (3,230) 1,570 (5,318) 0 97,896 107,730 1118,794 129,586 148,830 171,429 199,608 226,175 266,633 300,714 23,460 23,929 24,408 24,896 25,394 25,902 26,420 26,948 27,487 28,037 3,774 3,849 3,926 4,005 4,085 4,167 4,250 4,335 4,422 4,510 10,404 10,612 10,824 11,040 11,261 11,486 11,716 11,950 12,189 12,433 31,824 32,460 33,109 33,771 34,446 35,135 35,838 36,555 37,286 38,032 9,899 10,097 10,299 10,505 10,715 10,929 11,148 11,371 11,598 11,830 52,224 53,268 54,333 55,420 56,528 57,659 58,812 59,988 61,168 62,412 0 0 84,805 84,805 84,805 126,688 183,231 183,231 266,997 256,997 131,585 134,215 221,104 224,442 227,234 271,966 331,415 334,378 421,167 424,251 (33,689) (26,485) (102,909) (94,856) {70,403) (100,537) (131,807) (108,202) (154,534) (123,537 1,050,000 500,000 675,000 1,000,000 0 0 0 0 0 0 0 0 0 0 (8,580) (1,049,423) (13,217) (9,652) (510,082) (530,484) (208,247) (625,093) (372,552) (20,35: (8,580) 577 (13,217) (9,652) (10,082] 1144,516 (208,247) 374,907 (372,552) (20,35] 33 A/E Drannf w 2026 300.000' 41Y 111 Par A—m(Line 14) - 1.050000 500000 675,000 1000000 112 Numbnol Yens 9 9 15 15 15 20 15 15 15 15 15 34 A/E Dra,nrwW—sneennp 113 1,1,,W Rate 20:2 300% 300% 3OD% 60.000 - - - - 35 36 fiWrelnlaVmlr-rerrt rs-rgaxX 20M 960.000 - - - 1039-N 37 Teal well 2022 50.000 - - -- - 88 L5 1 Cor4ml Panel 2027 10,000 - - - 12 653 - - 35 L82 Ca4rol Penal 2126 10,000 - - - - 12.167 - 40 LS2Ca dPanel 2177 1$00 - - - - - - - 2220 41 L6 81 (Layton Awl 2171 500 520 42 LS E11Lehon A. 2123 500 - - - -• 43 LS M11Lahon Ave) 2024 2.500 � - - 2.612 - - - - 44 LS a1 (Layton Awl 2125 500 45 LE 11 1 La on Awl 2026 500 - 43M- - - ' 46 L601 ILayton Awl 2127 350.000 - - - - 442662 - - 47 U." Leyton Awl 2028 500 46 L661 (Layton Awl 2029 500 - - - - 6B4' 48 LS Nt (Leyton 11 2030 500 � � � - - - 712 53 L 01 ILahon Awl X131 500 - - - - - - 740 St LS 12 (1139M- Main 51211 2022 500 132L5a29182J1-Mon Sl l 2723 2.500 - - - 2704 63 LS E2(1891h-Main Station) 2024 500 - 562 - - - 54I'S#2(Is"'-Main Slation3 2025 500 - - - .85 LS#211B91h-Mein Station) 2026 350.000 - - - - 425.829 - 56 LB 92(1891h -Main Station) 2127 S03- 57L6N2(1891h-Main Siabon) 2028 500 57 .5121fB%h•M'"l-ha4 2029 500 - - _ _ - 684 _ _ S9 15 a2 (189th - Main Station) 2130 500 - - - - - - 712 50 LS0291BRh-Main Slatinn) 2131 250D - - - 3,701 61 LS AD 4t Tan6a1 to 2022 500 _ 520 62 LS S? IDoaaoe T."" 2)23 500 _ 541 n LS R3 (D—Tanks) 2024 500 _ Sw 64 L5 /3 (Dpeaoe Tanks) 2125 500 ossoe 45LSP3(DTenksl 2016 2500- 66L6#31DoeaoeTenksl 2127 500 - - - - 833 - 87 !9 N3(Doeape Tanks) 2028 500 _ _ 550 - - 50 LS #3 (Doesoe Tanks) 2029 500 - - - - 69 Lo D ­`Tanks) 2730 70,000 99.532 70 L61#3(Doasoe Tenksl 2031 2500 - - 3701 71 LS #4 (Dosaoe Tanks) 2012 500 520- - - - 72LSE4(DaeapeTenksl 2023 500 - - 541 - - 7� L5 041Do a T nks 2024 500 74'LS 0410aeaw Tanks) 2725 500 75 L9 a44be Tankal 2026500 76 LS4490arr,pe Taf&s1 2027 2500 - 3163 - - 77 LS'I4 ID—Tankal 228 500 70 LS M4 fDoaepe Tanks) 2029SOOT 664 - - 79 L544(Ooaaoe Tanks) 2031 500 _. - - _ _ 740 80 LS N4iD—T—Z X130 70,000 88.632 B1 Rapaira Yea 2012 2131 2,500 - 2,600 2704 7012 797H 3042 3163 3290 3421 3,558 3701 B2 Faoemain Yee,2)22 2015 500 '1503 541 962 83 Fain Yee 2026 2027 50.000 - - 60,833 63266 - 84 Forcemein Yea 2128 2129500 - - - - 656 684 - 85 Fin «rema 2030 50000- - 71.166 - 86 Facemain 202B 5000 _ _ _ 6,5 80 _ _ B7 Fproemain 2131 500 - - 748 88 Conn-K-rr.( p 2026 1200 00 - - - - - - 157.912 - - 89 Conn -.n meler wuipmenl 2128 25000 _ 32898- - 90 AIF oa4ml panel 2029 50000 - - - - - 68.42B 91 A/E LS Ya, 2122 2023 1.000 - 1,040 1082 - - - - - - 92A/E LS 2724 2500 - - - 2 812 - - 93 AIF LS Yes 2025 202E t - 1-170 1-217 1.265 1,316 - 94AIE LS 2529 350000 _ _ - - 476999 95 A/E LS Yes 2130 2131 1 000 - - 1,423 1.480 96 AE rapein Yea 2172 2131 1 750 - 1 827 1.693 1.969 2047 2.129 2 214 2 303 2 395 2,491 2 590 97 AIE f.—n in Yea 2022 2028 500 - - 521 541 562 585 Sw 633 658 - 9B A/E(aoenuin 2029 50000 - - - _ _ 66428 - 99 AlE lacemein Yea 2130 2031 500 - - - - 777 740 100 !4T ann 'ol palmma antl sullwre 2730 65000 - _ _ _ _ 92515 - 101 102 - 103- 10A 106 - - - - 107 109 PROJECTED NEW DEBTTERMS 41Y 111 Par A—m(Line 14) - 1.050000 500000 675,000 1000000 112 Numbnol Yens 9 9 15 15 15 20 15 15 15 15 15 15 15 15 15 113 1,1,,W Rate 250% 300% 300% 300% 250% 300% 300% 3OD% 300% 300% 300% 3DD% 300%1 CITY OF SCANDIA Financial Management Plan Uptown Sewer Fund 612 (nllabag A55umPhhpn 1 Revenue (Non -property tax) Inflation on rates 2 Interest Earnings 3 Expenses 4 CIP Inflation Factor 5 6 Charges for services 17,371 21,347 7 Special assessments 200% 2.00% 8 Intergovernmental 2 48 9 Interest 36 49 10 5.00% 5.00% 11 5.00% 5.00% 12 1.50% 1.50% Total Revenue 17,409 21,44413 EXPENSES 1.50% 1.50% 14 Wages 7,928 7,850 Materials 174 1,369 Professional services 120 104 Repair and maintenance 1,853 801 Other 2,233 2,404 Depreciation 4,877 4,877 15 Debt service 36,171 38,130 16 11,716 11,950 17 Total Expenses 17,185 17,405 18 Revenue Over I(Under) Expenses 224 4,039 OTHIER SNANCING $gVRqgALWSES 25,358 26,625 19 Bond Proceeds 29,354 0 20 Transfers In 3,461 3,551 21 Purchase of capital assets 3,694 (2,640) 22 Advance to other fund 0 0 23 Transfers Out - d 0 24 Total Other Sources/(Uses) 0 (2,640) 25 Change in balance sheet Ending Cash 4.19Q, 1.125) 9,347 8,062 9,392 10,815 200% 2.00% 200% 200% 200% 2.00% 2.00% 2.00% 2.00% 150% 150% 150% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 4 00% 1.50% 1.50% 1.50% 150% 1.50% 1.50% 1.50% 1.50% 0 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 0 0 0 400% 4.00% 4.00% 4.00% 4.00% 4.00% 34,317 36,171 38,130 11,486 11,716 11,950 12 189 FNu 351 20,535 21,800 23,000 24,150 25,358 26,625 27,957 29,354 30,822 4,266 3,461 3,551 3,622 3,694 5,605 0 0 0 11 d 0 0 0 0 0 0 0 8,062 9,392 10,815 357 418 458 518 546 659 0 0 0 0. 0 0 0 0 0 17,354 SI 0 0 0 0 0 20,546 21,600 23,000 24,507 4775 27,083 28,474 29,901 31,481 4,385 8,850 10,000 10,200 10,404 10,612 10,824 11,040 11,261 205 375 300 306 312 318 324 330 337 579 350 700 714 728 743 758 773 788 1,258 3,300 3,500 3,570 3,641 3,714 3,788 3,864 3,941 2,876 3,496 3,030 3,091 3,153 3,216 3,280 3,346 3,413 4,877 4,877 4,877 4,975 5,075 5,177 5,281 5,387 5,495 0 0 0 0 0 0 0 0 14,180 21,248 22,407 22,856 23,313 23,780 24,255 24,740 25,235 6,366 552 593 1,651 2,462 3,303 4,219 5,161 6,246 0 0 0 0 0 0 0 (1,200) (5,200) (2,600) (4,867) (4,499) (7,604) (3,042) (39,858) 2,640 (2.640) 0 (1,200) 15,2001 (2,600) (4,867) (4,495) (7,604) (3,042) (39,656) 200% 2 00% 2 00% 2 00% 5.00% 5 00% 5 00% 500% 1.50% 150% 150% 150% 300% 300% 300% 3()0% 4.00% 4 00% r 4 00% 4 00% 32.363 33,981 35,681 37 465 0 0 0 0 0 0 0 0 237 335 490 655 0 0 0 0 0 0 0 32,600 34,317 36,171 38,130 11,486 11,716 11,950 12 189 344 351 358 365 804 820 836 853 4,020 4,100 4,182 4,266 3,461 3,551 3,622 3,694 5,605 5,717 5,831 5,948 0 d 0 0 25,740 26,255 26,779 27,315 6,660 8,062 9,392 10,815 175,000 0 0 0 0 (5,922) (3,421) (3,558) (157,646) (5,422) (3,421) .(3,6sel 17,354