|
City of New Brigton
<br /> Storm Water
<br /> 11/3/2021
<br /> %Increase
<br /> Original Year-End
<br /> Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br /> 2020 2021 2021 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041
<br /> Input Assumptions for revenue
<br /> %Increase 7.00% 7.00% 7.00% 7.00% 7.00% 5.00% 4.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 2.00% 2.00% 2.00% 2.00% 2.00% 1.00% 1.00% 2.00% 2.00% 2.00%
<br /> Rates:
<br /> Single Family Per Lot/Townhome Per Unit 17.40 18.62 18.62 19.92 21.31 22.38 23.28 23.98 24.70 25.44 26.20 26.99 27.80 28.36 28.93 29.51 30.10 30.70 31.01 31.32 31.95 32.59 33.24
<br /> Per Acre:
<br /> Park,Cemetery,Golf 4.77 5.1 5.10 5.46 5.84 6.13 6.38 6.57 6.77 6.97 7.18 7.40 7.62 7.77 7.93 8.09 8.25 8.42 8.50 8.59 8.76 8.94 9.12
<br /> School 51.94 55.58 55.58 59.47 63.63 66.81 69.48 71.56 73.71 75.92 78.20 80.55 82.97 84.63 86.32 88.05 89.81 91.61 92.53 93.46 95.33 97.24 99.18
<br /> Mobile Home Park 70.63 75.57 75.57 80.86 86.52 90.85 94.48 97.31 100.23 103.24 106.34 109.53 112.82 115.08 117.38 119.73 122.12 124.56 125.81 127.07 129.61 132.20 134.84
<br /> Church 96.77 103.54 103.54 110.79 118.55 124.48 129.46 133.34 137.34 141.46 145.70 150.07 154.57 157.66 160.81 164.03 167.31 170.66 172.37 174.09 177.57 181.12 184.74
<br /> Apt,Condo,Sr.Housing 115.30 123.37 123.37 132.01 141.25 148.31 154.24 158.87 163.64 168.55 173.61 178.82 184.18 187.86 191.62 195.45 199.36 203.35 205.38 207.43 211.58 215.81 220.13
<br /> Comm/Indust/Warehouse 216.11 231.24 231.24 247.43 264.75 277.99 289.11 297.78 306.71 315.91 325.39 335.15 345.20 352.10 359.14 366.32 373.65 381.12 384.93 388.78 396.56 404.49 412.58
<br /> Unimproved Vacant Land 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
<br /> Revenues
<br /> Customer Charges 2021
<br /> Single,Two-Family,&Townhomes 6070.42 416,556 449,785 452,125 483,691 517,443 543,424 565,278 582,275 599,757 617,726 636,180 655,363 675,031 688,628 702,469 716,552 730,879 745,448 752,975 760,502 775,800 791,340 807,123
<br /> Per Acre:
<br /> Park,Cemetery,Golf 10.09 193 206 206 220 236 247 257 265 273 281 290 299 308 314 320 327 333 340 343 347 354 361 368
<br /> School 91.01 18,908 20,233 20,233 21,649 23,164 24,322 25,293 26,051 26,833 27,638 28,468 29,323 30,204 30,809 31,424 32,054 32,694 33,350 33,685 34,023 34,704 35,399 36,105
<br /> Mobile Home Park 45.69 12,908 13,811 13,811 14,778 15,812 16,604 17,267 17,784 18,318 18,868 19,435 20,018 20,619 21,032 21,452 21,882 22,319 22,765 22,993 23,223 23,688 24,161 24,643
<br /> Church 42.27 16,362 17,507 17,507 18,732 20,044 21,047 21,889 22,545 23,221 23,918 24,635 25,374 26,135 26,657 27,190 27,734 28,289 28,855 29,144 29,435 30,024 30,624 31,236
<br /> Apt,Condo,Sr.Housing 191.26 84,068 93,406 94,383 100,993 108,062 113,463 118,000 121,542 125,191 128,947 132,819 136,804 140,905 143,720 146,597 149,527 152,518 155,571 157,124 158,692 161,867 165,103 168,408
<br /> Comm/Indust/Warehouse 496.78 433,681 464,043 459,502 491,673 526,090 552,399 574,496 591,725 609,470 627,751 646,589 665,983 685,954 699,665 713,654 727,922 742,487 757,331 764,902 772,553 788,012 803,770 819,846
<br /> Late Charges - 18,000 - 18,000 18,400 18,800 19,200 19,600 20,000 20,400 20,800 21,200 21,600 22,000 22,400 22,800 23,300 23,800 24,300 24,800 25,300 25,800 26,300
<br /> Sump Pump
<br /> Total Customer Charges 982,675 1,076,991 1,057,766 1,149,737 1,229,251 1,290,306 1,341,681 1,381,787 1,423,064 1,465,530 1,509,215 1,554,364 1,600,755 1,632,825 1,665,506 1,698,798 1,732,819 1,767,459 1,785,466 1,803,575 1,839,748 1,876,558 1,914,030
<br /> Non Operating Revenue
<br /> Interest Income 1% 15,125 4,600 8,000 5,000 12,300 6,000 4,800 7,900 6,600 5,400 4,600 4,200 3,900 4,800 5,800 5,900 5,600 8,600 11,100 13,900 16,200 33,687 11,293
<br /> In-house engineering and admin charges 5,257 4,800 4,800 5,700 5,800 5,900 6,000 6,100 6,200 6,300 6,400 6,500 6,600 6,700 6,800 6,900 7,000 7,100 7,200 7,300 7,400 7,500 7,700
<br /> LGA 25,000 - - - - - - - - - - - - - - - - - - - - - -
<br /> GrantFunds-Lions Park Total Non Operating Revenue 45,382 9,400 12,800 10,700 18,100 11,900 10,800 14,000 12,800 11,700 11,000 10,700 10,500 11,500 12,600 12,800 12,600 15,700 18,300 21,200 23,600 41,187 18,993
<br /> Total Revenue 1,028,057 1,086,391 1,070,566 1,160,437 1,247,351 1,302,206 1,352,481 1,395,787 1,435,864 1,477,230 1,520,215 1,565,064 1,611,255 1,644,325 1,678,106 1,711,598 1,745,419 1,783,159 1,803,766 1,824,775 1,863,348 1,917,745 1,933,023
<br /> Input Assumptions for Expenses 1,028,057
<br /> Growth in Personnel Services 3.00% 2.00% 2.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% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00%
<br /> Growth in Materials&Supplies cost 3.00% 2.00% 2.00% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10%
<br /> Growth in Contractual Services 3.00% 2.00% 2.00% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10%
<br /> Operating Expense
<br /> Personnel Services 109,535 179,600 179,600 186,300 191,889 197,646 203,575 209,682 215,973 222,452 229,126 235,999 243,079 250,372 257,883 265,619 273,588 281,795 290,249 298,957 307,926 317,163 326,678
<br /> Materials and Supplies 11,558 18,000 18,000 18,000 18,558 19,133 19,726 20,338 20,968 21,618 22,289 22,980 23,692 24,426 25,184 25,964 26,769 27,599 28,455 29,337 30,246 31,184 32,150
<br /> Long Lake Improvement Association 7,500 7,500 7,500 7,500 7,500 7,501 7,502 7,503 7,504 7,505 7,506 7,507 7,508 7,509 7,510 7,511 7,512 7,513 7,514 7,515 7,516 7,517 7,518
<br /> Contractual Services&Admin Fees 153,751 341,500 333,700 366,200 377,552 389,256 401,323 413,764 426,591 439,815 453,450 467,507 481,999 496,941 512,346 528,229 544,604 561,487 578,893 596,839 615,341 634,416 654,083
<br /> Total Operating 282,344 546,600 538,800 578,000 595,499 613,536 632,127 651,288 671,036 691,391 712,370 733,992 756,278 779,248 802,923 827,324 852,473 878,394 905,111 932,647 961,028 990,280 1,020,430
<br /> Non Operating Expenses
<br /> Transfer to Bicentenial Pond 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700 700
<br /> Transfer to Lake Diane 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250 1,250
<br /> Total Non Operating Expenses 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950 1,950
<br /> Capital Outlay 880,181 442,000 347,000 511,000 1,436,000 1,224,000 354,000 375,000 377,000 363,000 413,000 1,191,000 378,000 444,000 1,276,000 609,000 384,000 494,000 450,000 497,000 673,000 2,582,000 533,000
<br /> Total Expenses 1,162,525 988,600 887,750 1,090,950 2,033,449 1,839,486 988,077 1,028,238 1,049,986 1,056,341 1,127,320 1,926,942 1,136,228 1,225,198 2,080,873 1,438,274 1,238,423 1,374,344 1,357,061 1,431,597 1,635,978 3,574,230 1,555,380
<br /> Internal Loan Payments
<br /> 2012 Community Reinvestment Loan for$305,800 10 yrs 3% 33,900 33,900 33,900 33,900
<br /> 2013 Flood Mitigation Project Loan for$115,000 10 yrs 3% 13,200 13,200 13,200 13,200 13,200
<br /> 2014 Flood Mitigation Project Loan for$200,000 10 yrs 3% 23,000 23,000 23,000 23,000 23,000 23,000
<br /> 2018 Flood Mitigation Project Loan for$500,000 10 yrs 3% 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200
<br /> 2019 Internal Loan$700,000 10 years 3% 81,500 81,500 81,500 81,500 81,500 81,500 81,500 81,500 81,500 81,500 81,500
<br /> 2020 Internal Loan$500,000 10 yrs 3% 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200
<br /> 2021 Internal Loan$500,000 10 yrs 3% 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200
<br /> 2022 Internal Loan$400,000 10 yrs 3% 46,600 46,600 46,600 46,600 46,600 46,600 46,600 46,600 46,600 46,600
<br /> 2023 Internal Loan$500,000 10 yrs 3% 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200 58,200
<br /> 2024 Internal Loan$800,000 10 yrs 3% 93,200 93,200 93,200 93,200 93,200 93,200 93,200 93,200 93,200 93,200
<br /> 2025 Internal Loan$400,000 10 yrs 3% 46,600 46,600 46,600 46,600 46,600 46,600 46,600 46,600 46,600 46,600
<br /> 2030 Internal Loan$700,000 10 yrs 3% 81,600 81,600 81,600 81,600 81,600 81,600 81,600 81,600 81,600 81,600
<br /> 2033 Internal Loan$700,000 10 yrs 3% 81,600 81,600 81,600 81,600 81,600 81,600 81,600 81,600
<br /> 2040 Internal Loan$700,000 10 yrs 3% 81,600
<br /> Total Internal Loan Payments 209,800 268,000 268,000 326,200 338,900 383,900 454,100 500,700 500,700 500,700 442,500 361,000 384,400 326,200 279,600 303,000 209,800 163,200 163,200 163,200 163,200 163,200 163,200
<br /> Beginning Cash&Investments 514,687 670,420 670,420 1,085,236 1,228,524 603,525 482,345 792,649 659,498 544,677 464,866 415,261 392,383 483,010 575,937 593,570 563,894 861,090 1,106,705 1,390,210 1,620,188 1,684,357 564,672
<br /> Cash Increase/(Decrease) (344,268) (170,209) (85,184) (256,713) (1,124,998) (921,180) (89,696) (133,151) (114,822) (79,811) (49,605) (722,878) 90,627 92,927 (682,366) (29,676) 297,196 245,615 283,505 229,978 64,169 (1,819,685) 214,444
<br /> Proceeds from Internal Loan 500,000 500,000 500,000 400,000 500,000 800,000 400,000 - - - - 700,000 - - 700,000 - - - - - - 700,000 -
<br /> Estimated Ending Cash Balance 670,420 1,000,211 1,085,236 1,228,524 603,525 482,345 792,649 659,498 544,677 464,866 415,261 392,383 483,010 575,937 593,570 563,894 861,090 1,106,705 1,390,210 1,620,188 1,684,357 564,672 779,116
<br /> Possible Cash Balance Minimum 3 mos 136,650 139,795 134,700 144,500 148,875 153,384 158,032 162,822 167,759 172,848 178,092 183,498 189,070 194,812 200,731 206,831 213,118 219,599 226,278 233,162 240,257 247,570 255,107
<br /> Amount Over(Under)Minimum 533,770 860,416 950,536 1,084,024 454,651 328,961 634,618 496,677 376,918 292,018 237,169 208,885 293,940 381,125 392,840 357,063 647,972 887,106 1,163,932 1,387,026 1,444,100 317,102 524,008
<br /> Possible Cash Balance Maximum 1,261,600 1,318,378 1,417,150 2,372,349 2,223,386 1,442,177 1,528,938 1,550,686 1,557,041 1,569,820 2,287,942 1,520,628 1,551,398 2,360,473 1,741,274 1,448,223 1,537,544 1,520,261 1,594,797 1,799,178 3,737,430 1,718,580 1,637,106
<br /> Amount Over(Under)Maximum (591,180) (318,167) (331,914) (1,143,826) (1,619,861) (959,831) (736,288) (891,188) (1,012,364) (1,104,954) (1,872,681) (1,128,246) (1,068,389) (1,784,536) (1,147,703) (884,329) (676,454) (413,556) (204,588) (178,991) (2,053,073) (1,153,908) (857,990) 38
<br />
|