|
Table 2
<br />Water Utility Rate Impact Summary
<br />City of Ramsey, Minnesota
<br />9/15/2017
<br />Beginning Balance
<br />Projected /
<br />Actual Actual Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected
<br />2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2035 2040
<br />$ 18,440,114 $ 18,249,021 $ 17,702,048 $ 19,553,332 $ 20,635,777 $ 22,190,135 $ 23,779,713 $ 23,704,661 $ 25,339,597 $ 27,009,720 $ 28,876,172 $ 18,784,291 $ 6,426,591 $ 7,126,392 $ 7,072,941 $ 9,587,285
<br />Water System Revenue
<br />New Customers 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160 160
<br />Annual Water Sales (gallons/year) 994,500,000 1,006,500,000 1,018,500,000 1,030,500,000 1,042,500,000 1,054,500,000 1,066,500,000 1,078,500,000 1,090,500,000 1,102,500,000 1,114,500,000 1,126,500,000 1,138,500,000 1,150,500,000 1,210,500,000 1,270,500,000
<br />Water Rates ($/1000 gallons) (Inflated at 2% per year) $ 2. 2.62 2.67 2.73 2.78 2.84 433 2.89 2.95 3.01 3.07 3.13 3.20 3.26 3.32 3.67
<br />2,181
<br />4.05
<br />Water Availability Charge (WAC) ($/connection) (Inflated at 2.5% per ye
<br />Water 1,2 $ 1,267 $ 1,299 $ 1,331 $ 1,364 $ 1,398 $ 1,$ 1,469 $ 1,506 $ 1,544 $ 1,582 $ 1,622 $ 1,662 $ 1,704 $ 1,928 $
<br />Connection/Trunk Charge ($/connection) (Inflated at 2.5% per year) $ 1,7 $ 1,763 $ 1,807 $ 1,852 $ 1,899 $ 1,946 $ 1,995 $ 2,045 $ 2,096 $ 2,148 $ 2,202 $ 2,257 $ 2,313 $ 2,371 $ 2,683 $ 3,035
<br />Water Rate Revenue (Inflated at 2.5% per year) $ 2,087,443 $ 2,139,629 $ 2,193,120 $ 2,247,948 $ 2,304,146 $ 2,361,750 $ 2,420,794 $ 2,481,314 $ 2,543,347 $ 2,606,930 $ 2,672,104 $ 2,738,906 $ 2,807,379 $ 2,877,563 $ 3,255,699 $ 3,683,524
<br />WAC Revenue $ 197,760 $ 202,704 $ 207,772 $ 212,966 $ 218,290 $ 223,747 $ 229,341 $ 235,074 $ 240,951 $ 246,975 $ 253,150 $ 259,478 $ 265,965 $ 272,614 $ 308,438 $ 348,969
<br />Trunk Revenue $ 290,575 $ 294,230 $ 297,976 $ 301,816 $ 305,752 $ 309,787 $ 313,922 $ 318,161 $ 322,506 $ 343,687 $ 352,279 $ 361,086 $ 370,113 $ 379,366 $ 429,218 $ 485,621
<br />Interest Earnings $ 184,401 $ 273,735 $ 265,531 $ 293,300 $ 309,537 $ 332,852 $ 356,696 $ 355,570 $ 380,094 $ 405,146 $ 433,143 $ 281,764 $ 96,399 $ 106,896 $ 106,094 $ 143,809
<br />Total Water System Revenue $ 2,760,179 $ 2,910,298 $ 2,964,398 $ 3,056,030 $ 3,137,726 $ 3,228,136 $ 3,320,753 $ 3,390,119 $ 3,486,897 $ 3,602,738 $ 3,710,675 $ 3,641,235 $ 3,539,856 $ 3,636,440 $ 4,099,449 $ 4,661,924
<br />Water Utility Expenses - Capital Improvement Projects
<br />Miscellaneous Projects
<br />Fire Station #1 Extension of Water $ 55,000
<br />County Radio Station ( 3 -Year Funding) $ 1,700
<br />Public Works Campus $ 1,715,750
<br />3/4 Ton Truck $ 43,000
<br />Utility Truck $ 25,000 $ 23,500
<br />Water Supply & Treatment Improvements
<br />Renovate Pump House #3 $ 60,000
<br />Construct Well & Pumphouse #9 $ 75,000
<br />Well #1 Rehabilitation $ 38,000 $ 41,000 $ 44,000 $ 47,000
<br />Emergency Supply for Well #3 $ 115,000
<br />Well Location Study $ 75,000
<br />Water Treatment Facility - 10 MGD Groundwater
<br />Water Storage Improvements
<br />Refurbish Water Tower #1 $ 1,300,000
<br />Refurbish Water Tower #2 $ 700,000
<br />Maintain Water Tower #3 $ 75,000
<br />Distribution System Improvements
<br />River Pines Lift Station Water Connection $ 20,000
<br />Distribution System Maintenance Improvements
<br />Watermain Looping Bunker Lake Blvd. $ 340,000
<br />Watermain Looping Sunfish Lake Blvd. $ 450,000
<br />Watermain Looping Ramsey Blvd to Traprock $ 129,250
<br />Watermain Bunker Lake Boulevard - Business Park $ 162,842
<br />Watermain Puma Street - Business Park $ 220,226
<br />2021 through 2040 Projected Improvements
<br />Distribution System
<br />Construct Well & Pumphouse #10
<br />Storage Tower 3 Rehabilitation
<br />Well Service and Pump Maintenance (8 wells)
<br />Subtotal- Capital Expenses $ 2,067,018 $
<br />Operational Expenses
<br />Operating Expense- Distribution and Administration (Inflated at 4% per year)
<br />Operating Expense- Treatment (Inflated at 3% per year)
<br />Subtotal- Operating Expense
<br />Total Annual Expenses
<br />Finance Adjustments
<br />Trunk Charges Returend per John Peterson's agreement (thru 2025)
<br />PW Land/Building - Internal Loan 2009-2028 @2%
<br />Internal Loan to offset Muni Center Debt beginning year 2011-2030@2%
<br />Internal Loan for RTC Land Purchase- 10 yr@2% when land sold
<br />Net Finance Adjustments
<br />Water System Working Capital Balance
<br />Total Annual Expenses
<br />Total System revenue
<br />Net Income (loss)
<br />Beginning Water Working Capital Balance
<br />Remaining Working Capital Balance
<br />$ 1,700,000
<br />$ 12,000,000 $ 12,000,000
<br />$ 443,952 $ 457,271 $ 470,989 $ 485,118 $ 499,672 $ 514,662 $ 530,102 $ 546,005 $ 562,385 $ 579,257 $ 671,517 $ 778,473
<br />$ 2,138,641
<br />$ 3,025,179
<br />$ 115,927 $ 119,405 $ 122,987 $ 126,677 $ 130,477 $ 134,391 $ 138,423 $ 142,576
<br />2,540,250 $ 162,000 $ 987,000 $ 559,879 $ 576,675 $ 2,293,976 $ 611,795 $ 630,149 $ 649,053 $ 12,668,525 $ 14,827,222 $ 562,385 $ 3,604,436 $ 671,517 $ 778,473
<br />$ 836,662 $ 870,128 $ 904,934 $ 941,131 $ 978,776 $ 1,017,927 $ 1,058,644 $ 1,100,990 $ 1,145,030 $ 1,190,831 $ 1,238,464 $ 1,288,003 $ 1,339,523 $ 1,393,104 $ 1,694,924 $ 2,062,134
<br />$ 1,000,000 $ 1,030,000 $ 1,194,052 $ 1,384,234
<br />$ 836,662 $ 870,128 $ 904,934 $ 941,131 $ 978,776 $ 1,017,927 $ 1,058,644 $ 1,100,990 $ 1,145,030 $ 1,190,831 $ 1,238,464 $ 1,288,003 $ 2,339,523 $ 2,423,104 $ 2,888,976 $ 3,446,368
<br />$ 2,903,680 $ 3,410,378 $ 1,066,934 $ 1,928,131 $ 1,538,655 $ 1,594,603 $ 3,352,620 $ 1,712,785 $ 1,775,178 $ 1,839,884 $ 13,906,989 $ 16,115,224 $ 2,901,908 $ 6,027,539 $ 3,560,493 $ 4,224,840
<br />$ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375) $ (144,375)
<br />$ 34,930 $ 35,629 $ 36,341 $ 37,068 $ 37,810 $ 38,566 $ 39,337 $ 40,124 $ 40,926 $ 41,745 $ 42,580 $ 54,436
<br />$ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853 $ 61,853
<br />$ (47,592) $ (46,893) $ (46,181) $ (45,454) $ (44,712) $ (43,956) $ (43,185) $ (42,398) $ (41,596) $ 103,598 $ 104,433 $ 116,289 $ 61,853 $ 61,853
<br />$ 2,903,680 $ 3,410,378 $ 1,066,934 $ 1,928,131 $ 1,538,655 $ 1,594,603 $ 3,352,620 $ 1,712,785 $ 1,775,178 $ 1,839,884 $ 13,906,989 $ 16,115,224 $ 2,901,908 $ 6,027,539 $ 3,560,493 $ 4,224,840
<br />$ 2,712,587 $ 2,863,405 $ 2,918,217 $ 3,010,576 $ 3,093,014 $ 3,184,180 $ 3,277,568 $ 3,347,721 $ 3,445,301 $ 3,706,336 $ 3,815,108 $ 3,757,524 $ 3,601,709 $ 3,698,293 $ 4,099,449 $ 4,661,924
<br />$ (191,093) $ (546,973) $ 1,851,284 $ 1,082,445 $ 1,554,358 $ 1,589,578 $ (75,052) $ 1,634,936 $ 1,670,123 $ 1,866,452 $ (10,091,881) $ (12,357,700) $ 699,801 $ (2,329,247) $ 538,956 $ 437,084
<br />$ 18,440,114 $ 18,249,021 $ 17,702,048 $ 19,553,332 $ 20,635,777 $ 22,190,135 $ 23,779,713 $ 23,704,661 $ 25,339,597 $ 27,009,720 $ 28,876,172 $ 18,784,291 $ 6,426,591 $ 7,126,392 $ 7,072,941 $ 9,587,285
<br />$ 18,249,021 $ 17,702,048 $ 19,553,332 $ 20,635,777 $ 22,190,135 $ 23,779,713 $ 23,704,661 $ 25,339,597 $ 27,009,720 $ 28,876,172 $ 18,784,291 $ 6,426,591 $ 7,126,392 $ 4,797,145 $ 7,611,896 $ 10,024,369
<br />
|