Loading...
HomeMy WebLinkAboutCity Council Packet 11-25-2008 SpecialAgenda City of Plymouth Special City Council Meeting Tuesday, November 25, 2008 5:30 p.m. Medicine Lake Conference Room 1. Call to Order. 2. Discuss Utility Rate Study 3. Adjourn City of Plymouth City ofrilpplymouth Minnesota Water & Sanitary Sewer Utility Rate Study November 2008 Prepared By: City Staff and 401 IDLERS LEADERS IN PUBLIC FINANCE Introduction The City of Plymouth requested that Ehlers & Associates assist staff in an update of financial projections for the water and sanitary sewer system utilities. The purpose of the rate study is to ensure that: 1. Rates are sufficient to pay for the ongoing operations and capital improvements, and to maintain adequate cash balances; and, 2. The rate structure distributes the costs of operating the system across utility users consistent with the policy objectives of the Council. Background The City has maintained a comprehensive long-range capital improvement program for many years focusing upon replacement of existing infrastructure and also expansion for new growth. The City's planning has resulted in very little debt for the utility systems. Only one bond issue is outstanding, a $13,140,000 G.O. Water Revenue Bond originally issued in 2004. This bond will be retired in 2019. This study incorporates the expected long-term year capital improvement plan. The draft capital improvement plans for water and sewer are located in Appendices D and E, respectively, and include lift station replacements, replacement of existing sewer and water lines in the streets, wells, major trunk utility lines, equipment and vehicles, and a 7.6M well and water treatment plant expansion expected in 2013 if demand dictates. Assumptions Following is a chart that summarizes the significant assumptions in the rate study. 2 Water Utility Sanitary Sewer Utility Growth and 149 new residential connections per 149 new residential connections per Utility Usage year per Comprehensive Plan. year per Comprehensive Plan. Usage Water usage will continue at will continue at average levels. average levels. Operating Increase 5% annually (new demand City expenses and personnel increase Expenses plus inflation) 5% for personnel 5% annually with a one-time personnel increase MCES disposal fees increase 5% associated with the water treatment annually plant expansion Capital Costs of improvements are inflated Costs of improvements are inflated Expenses 6% per year from current estimates. 6% per year. Future trunk capital Future trunk capital expenditures improvements are estimated at $3M are $19.9M in future dollars from in future dollars from 2009 to 2023. 2009 to 2023. Operating capital Operating capital expenditures in expenditures, in future dollars, from future dollars, from 2009 to 2023 is 2 2009 to 2023 is S 16AM Debt of $5.2M is expected in 2010 and 2015. 22AM Debt of $14.1 M is expected. Rate Structure Current billing structure is a fixed Currently residents are billed year - rate of $1.13 per 1,000 gallons for round based on water consumption in all usage up to 12,500, $1.30 for the winter month at $2.61 per 1,000 next 22,500 usage and $2.43 for gallons. The City charges a base usage over 35,000 gallons per monthly rate of $4.44 for both month, and a $3.12 monthly fixed residential and commercial charge. Irrigation meters are billed properties. at the top two tiers based on usage levels. Commercial properties are billed at the highest tier for all usage. Proposed rate structures on page 7 No change proposed to methodology were determined to provide of how fees are charged. Rate sufficient cash flow and to comply increases are shown on page 10. with MN statute 103G.291 as amended during the 2008 legislature Development 1,025 water connection fee per City sewer connection fee of $400 Fees residential equivalent unit and an per residential equivalent unit and an area charge of $3,701 per acre. area charge of $998 per acre . Fees WAC is proposed to increase by 5% are projected to increase by 5% each each year. year. Water Utility Water and sewer utility funds are reported in financial statements as enterprise funds, meaning that rates and charges are designed to recoup the costs of operations. Goals of a Utility Enterprise Rate Structure In addition to setting rates and charges to recover the costs of operations, the Council, as an important policy question, should consider who predominately pays for costs. Each community may weight goals differently, but the general goals of a utility rate structure are: Rates sufficient to cover capital and operating costs of the system Provide for adequate cash balances for cash-flow and contingencies Allocate costs appropriately to those that use the system Promote water conservation. This is mainly a concern related to residential users who use most of the water, as would be expected. Complement the city's economic development goals Capital Needs The City has completed its Capital Improvement Plan (2009 — 2013) and future planned capital projects, which forms the basis of this analysis. The CIP and projects summary is provided in Appendix D, and includes lift station replacements, replacement of existing water service lines in the streets, wells, major new transmission lines, equipment and vehicles, and a $7.6M well and water treatment plant expansion expected in 2013 if demand dictates. Kvisting Water Fees There are three primary components to the City's water utility revenues: iVfeter Charges are a fixed monthly fee based on the size of meter in the home or business. Most meters are at $2.89 per month. The meter charge is established to recover certain fixed expenses, such as the billing system, that the City must incur for a customer regardless of the amount of water consumed. This meter charge raises approximately 1.2M per year and helps to pay for utility staffing costs. Usage Fees are based on the metered use of water. Currently the billing structure is a fixed rate of $1.13 per 1,000 gallons for all usage up to 12,500 gallons, $1.30 for the next 22,500 in usage and $2.43 for all usage over 35,000 gallons per month. Irrigation meters only are billed at the top two tiers for all usage. Commercial/industrial properties are charged at the lower rate of $1.30 per $1,000 gallons. In 2007, usage fees generated 77% of total water revenues. Below is a chart which demonstrates the breakdown of types of users in the water utility. 4 Type of Water Utility Users by Type 100% 80% Commercial 60% 18,855 Residential 40% 20% 0%© 2007 Commercial users logged 873,221,700 gallons per year in 2007. Included in this class of users are commercial, large and small, industrial and institutional. Commercial / industrial users comprise 28.8% of the water volume and usage and comprise roughly 27.5% of the usage revenues. All commercial water use is charged at a rate that is equivalent to the Tier Two rate for residential users. Commercial users are also charged a higher meter fee based on the size of the meter. Overall, commercial users generate roughly 27.9% of all water fund revenues, which includes usage and fixed charges. The City Council should discuss and determine if commercial rates should be tiered. The following table shows the top 10 commercial water users. These commercial entities account for 21 % of the water used by commercial entities. Minntech Corp 40,424,000 Circuit Science 27,799,000 Hutchinson Technology 22,093,800 Boston Scientific 18,849,000 Regency Plymouth Ventures 17,087,000 Honeywell 15,626,900 Hennepin County 12,830,000 Lifetime Fitness 12,706,000 United Health Group 11,521,000 Independent School #284 10.830.000 Water connection fees and area charges are paid by new construction of homes and businesses at the time of development and/or building permit. The water connection fees and area charges are expected to raise approximately $345,900 in 2009, given the growth assumptions from the Comprehensive Plan, and are expected to be used for capital costs needed to serve new development. We are recommending a rate increase of 5% per year. These fees represent approximately 41 % of the cost of the new wells, watermains and thg 5 treatment plant expansion. It is anticipated that the full cost of the water system expansion that is due to new growth should be paid by the new users who will benefit from the increased system capacity. Three Tiered Rate System (Residential) The City currently has a three tiered rate system. The City is currently in the process of changing its financial software. It is our understanding that extracting utility data from the old system is difficult. Because of complications in the utility billing system, the City is not able to exactly identify how many users will be affected at each level. We would recommend that the City analyze utility usage data after at least one year's experience with the new system. For that reason, we are not recommending any changes in the rate tiers. With a three tiered rate system, the typical resident will pay more for water used for sprinkling than they will for water used in daily activities. Most metro area suburbs have adopted a tiered rate system for the following reasons: 1. To promote conservation efforts. 2. To allocate costs appropriately to those who are generating them. Cities construct water systems to meet the capacity of peak watering days in the heat of the summer. A tiered rate system charges more per gallon for peak use, thereby allocating the cost of "oversizing" the system for peak days to the peak users. The Minnesota Legislature recently adopted an amendment which requires a conservation rate structure for all metropolitan area public water suppliers, who serve more than 1,000 people, by January 1, 2010. Additionally, all remaining public water suppliers who supply water to more than 1,000 people are required to have a conservation rate structure in place by January 1, 2013. A public water supplier must also have a conservation rate structure in place before the State will grant approval for constructing an additional well or for a request to increase the authorized volume of appropriation. The Department of Natural Resources has provided further guidance that an increasing block rate means that there is a sufficient increase in the rate between the tiers to promote conservation. Specifically, the DNR would be looking for a significant increase between the blocks to encourage conservation, or at least 25% cost increase between the first two tiers and at least 50% more between the last two steps. The DNR has approved the City's current rate structure as conservation rates. Further, we believe that the recommended rate structure proposed complies with DNR guidelines because there is 25% cost increase between tier one and two and a 50% cost increase between tier two and three. 6 Proposed Residential Water Rates This rate structure would apply to single family and multi -family residential. The monthly meter charge would increase by 3% to $3.21 per month for the average home in 2009, $3.37 in 2010, $3.54 in 2011, and $3.72 in 2012. Commercial flat rate users would pay the same rate as residential. Commercial users with large meters would pay 3% more in 2009. Proposed Water Utility Rates Usage Gallons 2009 2010 Proposed Water User Charges 2012 2013 Low User 2007 2008 2009 2010 2011 2012 2013 Increase 3.00% 5.00% 5.50% 6.00% 6.00% Residential Average User 25,000 gallons per month Tier 1: to 12,500 gal 1.05 1.13 1.16 1.22 51.29 1.37 1.45 Tier 2: 12,501-35,001 51.20 1.30 1.45 51.53 51.51 1.71 1.81 Tier 3: over 35,000 52.25 2.43 2.50 2.63 2.77 2.94 3.12 Commllndustriai 197.56 208.41 220.88 234.10, per 1,000 gal 51.20 1.30 1.34 1.41 51.48 1.57 1.67 Sample Charges at Various Usage Levels SAMPLE CHARGES AT VARIOUS USAGE LEVELS WITH PROPOSED RATES Water -Usage and Fixed Charge 2009 2010 2011 2012 2013 Low User 10,000 gallons per month 14.85 15.60 16.44 17.39 18.39 Average User 25,000 gallons per month 35.95 37.75 39.80 42.16 44.65 Moderately High User 50,000 gallons per month 63.01 66.16 69.78 73.94 78.33 High User 90,000 gallons per month 188.16 197.56 208.41 220.88 234.10, WAC Fees Water connection fees are collected in order to provide funding for capital improvement related to the water distribution system. It allocates the cost of the system to those who will derive benefit, which may include future users. Connection fees are collected to pay for the cost of an individual user to connect to the system and area charges are collected to pay for the cost of running the utility system to service the area. Connection and area fees become a consideration regarding development and the policy decision regarding which users pay for which costs. As was stated on page 5 above, 41% of the inflated cost 7 of the treatment plant expansion, wells, fire protection upgrade and watermain oversizing is expected to be paid from these sources of revenues. The following chart shows the comparison of area charges and connection fees with selected cities, with the proposed 2009 rates for the City of Plymouth Brooklyn Park 50 $1,600 $150 $1,675 Plymouth -2009 Proposed 1,076 $1,036 $420 $333 Eden Prairie 2,190 $520 Maple Grove 1,785 $725 Based on 1 REU residential unit on 113 acre Future Debt for Water Treatment We are projecting that existing cash balances in the trunk funds, as a whole, are sufficient, at this point, to finance the water treatment plant expansion with cash. However, we understand that the City Council has discussed the need to divide up the cash balances in Funds 421 (Utility Trunk Replacement Fund) and 441 (Utility Trunk Expansion Fund), between water and sewer funds. This analysis shows the trunk expansion needs of the water and the sewer system as a whole. It appears that the capital items from the Comprehensive Plan can be financed with cash balances_ One of the recommendations that we and staff have discussed is the basis upon which the balances. should be split. We would recommcnd that the cash balances be split based upon future need. As the funds are currently set up, connection fees, area charges and existing special assessments revenues go into the trunk funds. Capital costs from the Comprehensive Plan are expected to be paid from the trunk funds. Overall, these development fees pay for approximately 74% of development costs as shown below. Water trunk capital projects 2009-2024 inflated 19,959,110 Sewer trunk capital projects 2009-2024 inflated 3,037,702 nnection fees -water and sewer to 2024 5,256,268 a charges -water and sewer to 2024 5,583,175 ecial assessments -existing 6,167,506 rcent of project costs recouped through dev fees 74% If the special assessments were taken out of the equation above, then future development fees pay for approximately 47% of future development costs. ri 8 If the cash balances were split based on future development need, water trunk capital would be allocated 87% of the ending 2008 cash balances and sewer trunk capital would be allocated the remaining 13%. Cash Balances The Water fund had a 12/31/2007 cash balance of $9,031,593. One of the goals of completing a utility study is to identify appropriate cash balances. To that end, we have proposed a target operating and capital reserve, which would equal thee months of operating expenses, including depreciation, 100% of next year's debt and 100% of next year's capital costs, plus 10% of accumulated depreciation. The City has a history of operating its enterprise funds on a pay-as-you-go basis, meaning that capital projects and operations are paid with cash. This target capital reserve builds in operations, capital and debt plus a contingency for unexpected repairs. The operating portion of the reserve maintains cash balances in order to operate the utility fund and to provide a cushion for revenue fluctuations. The capital portion of the reserve provides funds for replacing capital in the CIP and for unexpected repairs. 10% of accumulated depreciation builds in nearly $3M for unexpected repairs at the outset and builds the balance thereafter as accumulated depreciation increases. A graph below demonstrates the projected capital cash balance compared to the accumulated depreciation of the assets of the water enterprise fund: Water Fund Target Reserve and Actual Reserve 14,000,000 12,000,000 10,000,000 Target 8,000,000 Reserve 6,000,000 I ®Actual 4,000,000 j Working 1 Capital 2,000,000 fl 0 tib - ' ti i tiQ ` qy Or r' 4. 0 Water Fund Recommendations Recommendation #1: We would recommend that the Council adopt the rates as presented in this study. We would also recommend that the Council update the study from time to time to make certain that rates are keeping pace with inflation and capital needs. A 9 Recommendation 42: We would recommend that the City Council discuss a commercial tiering rate. Recommendation #3: We recommend that the City Council split the Trunk Replacement and Expansion funds cash balances according to future estimated need. The respective connection fees and area charges may need to be adjusted based on beginning cash balances. Recommendation #4: Target Operating and Capital Reserves Operating Reserve We recommend the water fund carry a minimum cash balance for operations of an amount equal to three months of operating expenses (or 25% of annual expenses) plus annual debt service and capital. Cash balances are available to accommodate fluctuations in revenue depending on weather and higher than anticipated operating expenses. Capital Reserve The remaining cash balance should be held for long-term replacement of the system, which will not be able to be funded with growth. This fund would help minimize the reliance on debt, while still allowing a smoother rate structure over time. We recommend that the capital portion of cash reserve equal 10% of accumulated depreciation of assets as outlined in the city's annual financial report. 10 Sanitary Sewer Utility Sewer Fees The City of Plymouth participates in the Metropolitan Council Environmental Services MCES) sanitary sewer system. The City is responsible for the sewer collection system within the City Iimits and then pays MCES disposal fees for treatment. The MCES disposal fees have increased 5 - 9% each of the last four years. The rate study anticipates that future increases for these fees will be 5%, annually. The MCES disposal fees comprise 64% of the sewer utility's operating expenses. Another 11% of expenditures represent depreciation, while only 25% of operating expenditures are within the City's control. Server Rate Structure The current rate structure is $2.69 per 1,000 gallons of sewer for residential service. There is a minimum monthly fee of $4.44, regardless of use. The minimum charge helps pay for the fixed costs of the system as outlined in the water utility description. Proposed Server Rates The projected rate increase for sanitary sewer is 5.5% in 2009 and 5.5% per year for the next several years. We do not recommend changing the rate structure at this time for a tiered system. The proposed rate per 1,000 gallons is in the chart below. Usage Gallons Proposed sewer User Charges 2007 2008 2009 2010 2011 2012 2013 Increase 5.501/6 5.50% 5.50% 5.50% 5JG% Residential 2.47 2.61 2.75 $2.90 53.06 3.23 3.41 Senior Citizen 2.21 2.34 2.47 $2.60 52.75 2.90 3.06 Commercial 2.47 2.61 2.75 $2.90 S3.06 3.23 3.41 As mentioned above, the MCES charges are increasing at 5% per year. We are concerned about the long term cash balances of the sewer fund and the 5.5% rate increases are necessary to keep pace with costs. The flat monthly charge would increase to $4.68 in 2009, $4.94 in 2010, $5. 21 in 2011, and $5.50 in 2012. I SAMPLE CHARGES AT VARIOUS USAGE LEVELS WITH PROPOSED RATES Sewer -Usage and Fixed Charge 2009 2010 2011 2012 2013 Low User 10,000 gallons per month 32.22 33.99 35.86 37.83 39.91 Average User 25,000 gallons per month 73.52 77.57 81.83 86.33 91.08 Moderately Nigh User 50,000 gallons per month 73.52 77.57 81.83 86.33 91.08 High User 90,000 gallons per month 114.83 121.14 127.80 134.83 142.25 Sanitary Sewer City Connection Fees Sewer connection fees are collected in order to provide funding for capital improvement related to the sewer collection system. It allocates the cost of the system to those who will derive benefit, which may include future users. The MCES SAC fee will continue to increase over time. Connection fees are collected to pay for the cost of an individual user to connect to the system and area charges are collected to pay for the cost of running the utility system to service the area. Connection and area fees become a consideration regarding development and the policy decision regarding which users pay for which costs. Approximately 91% of the inflated cost of a portion of two liftstation upgrades and trunk sewer oversizing is expected to be paid from these sources of revenues. Cash Balances We are concerned about the long term cash balance in this fund. There is a strong pressure on balances due to capital projects that have been identified. See Appendix E for further detail. The beginning cash balance is fairly low and it appears that it will be necessary to issue bonds for future planned capital in order to provide cash flow for the fund. Operating Reserve We recommend the sewer fund carry a minimum cash balance for operations of an amount equal to three months of operating expenses plus annual debt service and capital. Cash balances are available to accommodate fluctuations in revenue and higher than anticipated operating expenses. Capital Reserve The remaining cash balance should be held for long-term replacement of the system, which will not be able to be funded with growth. The following graph demonstrates the projected capital cash balance related to the target working capital reserve; 12 8,000,000 7,000,000 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 Sewer Fund Target Reserve and Actual Reserves Doi a N lv ,3 tK h ,,'4 , g o >\ V *bN p p ryp ryq ry© p`L p`L p`• p`L Sewer Fund Recommendations Target Working Capital Reserve Actual Working Capital Recommendation #I: Target Operating and Capital Reserves Operating Reserve We recommend the sewer fund carry a minimum cash balance for operations of an amount equal to three months of operating expenses (or 25% of annual expenses) plus annual debt service and capital. Cash balances are available to accommodate fluctuations in revenue and expenses. Capital Reserve The remaining cash balance should be held for long-term replacement of the system, which will not be able to be funded with growth. This fund would help minimize the reliance on debt, while still allowing a smoother rate structure over time. We recommend that the capital portion of cash reserve equal 5% of accumulated depreciation of assets as outlined in the city's annual financial report. 13 Summary The City of Plymouth has managed its utility funds well, and as a result has been able to pay for almost all improvements on a cash basis. However, the need to upgrade and expand the water utility system over the next several years will introduce new financial pressures. Even with the proposed rate increases, the City of Plymouth is about average for its water and sewer rates. Appendix A shows sample cities with current proposed City rates. The rate study indicates that water rate increases are necessary in 2009 to maintain cash balances and pay for capital improvements and debt. Modest and steady rate increases will be needed for sanitary sewer, beginning in 2009, to keep pace with the MCES disposal fees and to pay for City operating costs and capital improvements. While this analysis proposes the use of debt to allow for steady and predictable rate increases, it is not a debt plan. The City should review whether it has sufficient cash to pay for capital improvements prior to issuing debt. At its option, the City may accumulate less cash in its utility funds (thereby funding less depreciation) in order to reduce the amount of new debt issued for utility improvements. As with all other bonding decisions, the City's decision to issue debt for any given improvement will be based on many factors, including the City's cash balances, rating, and other financing needs. J 14 Appendix A Comparisons to Other Cities' Rates Appendix B Water Utility Projections Appendix C Sanitary Sewer Utility Projections Appendix D Capital Improvement Plan for Water Appendix E Capital Improvement Plan for Sanitary Sewer 15 Appendix A Comparisons to Other Cities' Rates The graphs below compare monthly water charges and monthly sewer charges based on a user of 20,000 gallons per month Comparison of Water Rates Maple Grove Plymouth Water Minimum Brooklyn Water Volume Park Eden Prairie 0.00 10.00 20.00 30.00 40.00 Comparison of Sewer Rates Maple Grove Plymouth Sewer mum Brooklyn Sewer Volume Park Eden Prairie 0.00 20.00 40.00 60.00 80.00 tb WaterWaterMin Eden Prairie 4.17 31.00 4.17 39.00 Brooklyn Park 3.10 31.00 3.10 47.00 Plymouth 3.21 25.38 4.68 55.00 Maple Grove 10.10 9.00 5.50 27.00 Comparison of Water Rates Maple Grove Plymouth Water Minimum Brooklyn Water Volume Park Eden Prairie 0.00 10.00 20.00 30.00 40.00 Comparison of Sewer Rates Maple Grove Plymouth Sewer mum Brooklyn Sewer Volume Park Eden Prairie 0.00 20.00 40.00 60.00 80.00 tb Comparison of Total Monthly Utility Bill Maple Grove Plymouth Brooklyn Park Eden Prairie 0.00 20.00 40.00 60.00 80.00 100.00 17 Appendix B Water Utility Projections 18 City o1 Plymautn Utility Rale Study 1 Ray-& ycw51 awumptan- nan-usage 2 Inwatmant Income yleW 3 Exp6ma wawa • personnel 6 mtsmal 4 Expense Brawlh - mpalrand maintenance 5 Expanaa Vows - non pommmel 6 Ezp•nse Omwd1 • MCE6 7 e0 Beginning net swats 1011 Operating Raw -WW.' Ww 13 Canne464n lee 14 S-dhar9es ISAdddmnal Rwenue-new 9-th 76 Waur meter Wee 17Penatt19SAC 10 iniviiWir-mal 20 MI-0-oue 21 Oth., 22 Total Oporabnp Revenues 23 24 Op -ting Expenses 25 Wale, ProOucNan 2d Pemannel 27 Atldl6o..4 psmonnsl and apora5ne 20 Matenats and auppY•a 20 Other servkea and adarpes 30ContrecNsl 31 CapIW 32DeprealMlon 33, bane 34 S••nr Beryl. 35P -nal 36 Malanala and auppllaa 37 Con9ulual 34 MCES tree4mwtcharpea 39 CaPYW 40 Oaprecla9on 41 A9acMiane 42 43 Ta1at Operating Expanses 44 45 Nat Operaoans 46 Non cperabn9 rwanuea levpananl 47 Irww7m•hI Ineame le InlarM and 0.111 .. 49 Awafemenl Income 50Olh. Income lexp-.) 51Tmnstus 52 F' 3 WwU 14gmt-Nate 1 53 Fr Water Ra -r- F"Ow 1 54 UbYty Trunk Replacement 55 UbYty Trunk E rl,-" Be Water Swr COnatruc" 57 Trenelera 56 ToW nan opeuen9 rwmue (•ppanaea) 59 80 Netlnemwa (deareaea) In ttaaaaurc 8742 Caput contrbubons 43 Ow"par contnbubana 64 Other 65 Ending not nets 26,999.978 37,721.207 57607,016 56.04,208 3,445,380 3,559,327 4.065,548 5,077.743 7,307 7,570 7,010 7,988 12,524 12,047 8,811 16,671 33,403 35.006 38,418 59.752 41,719 76.695 40,440 75,816 3.540,S1S 3.600.654 4,21 C, 648 3.,237,983 1.502,687 1.501.944 1,855,751 1,665,094 254,348 352,642 415,557 495,933 1,072,108 7,410579 1,400.3891.801,518 5320 3,292 004,018 957,028 2.178,074 2.378,3&7 170,149 150„005 174,197 255,217 57,509,601 55,540,111 5,100,396 5,780853 5,005 53,982 10,800 11,644 36720 30656 0 87,200 IA 1176 5,346116 5,810,933 1,789,643 1,824,146 503,600 554,459 1,700.511 1,835,881 97,500 52,050 Z116: '383' 2,842.202 387,714 396,223 3.00% 3.00% 150% 3,65% 3,50% 3.50% 3,50% 3,50% 3,50% 390% 3,50% 3.50% 3,50% 3.50% 5.00% 5400% 5.00% 5,00% 5.00% 5.90% 5,00% 6,00% 5,00% 5,00% 5.05% 5109% 5.00% 5.00% 5.00% 5.00% 8.00% 5.00% 5.00% 5.00% 5.00% 5400% 5.00% 5.00% 5.00% 5.00% 5400% 5.00% 5400% 5,00% 5,90% 5,00% 5,00% 5,00% 5,00% 5,00% 5,00'% 5,00% 5100% 5.00% 5400% 530% 54,2117.411 52.518,745 S6,785,034 49,112,396 47,398,309 45,729,638 44,134,597 42,573,459 41,022,741 39,469,634 57979,030 38,476,746 34,941,867 33;408,246 6,030,145 5,400,163 6,779.241 7.171 4176 74587.309 0.027.947 6.428.400 0,649,820 9,292,311 9,756;926 104244,773 10,757,011 11,294,862 11,8594005 95,022 133,665 ma'a0d 240,194 314,733 300.140 457,391 5264119 001,312 662,323 7119.932 831,944 898733 969071 17.697 12,135 12.376 12,025 12,679 13,139 13,396 13,666 13,940 14,218 14,503 14,793 15,069 15.390 40.451 41.260 42.065 42,927 43,766 44,661 45,555 46,469 47,395 48.343 49,310 50,299 51,302 52,3211 C 0 0 0 0 0 0 0 0 0 0 9 0 0 15.276 15,581 15,893 16,211 15,535 16.955 17,203 17,547 17,595 15,256 19,621 15,993 19,373 16761 6.232.831 6610,835 7,037,605 7401,840 7.975,300 9,489,056 8.961,946 9,453,986 9,972,855 10,520,066 11,097,136 11,873,036 12,278,059 12,21e,155 1,815,355 2,011,123 2,111,670 21217,263 2,329,126 2,444,533 2,555,759 2,895,097 2,629,852 2,971,345 3,119,912 3,275,805 3,459,703 3,011846 0 0 0 50,000 52,500 53.125 67,981 60,775 63,974 67,005 70,355 73,673 77,509 61,445 613,532 544.365 675,564 71x,414 745,934 763,231 622,393 553,512 904,644 952,022 996623 1,049,001 1,102,065 1,157,169 2.033.725 2,135,411 2.242,102 2,354,291 2.472,006 2.595.69 2.725,366 2,661.556 3,004,738 3,154;875 3.312,724 3,476380 3,652,276 3,834,892 54,459 57,365 60,$54 83,267 88,496 69,752 77770 78,@53 60,747 64,784 68,027 93,474 94144 10],055 2.774 12 2,911.020 3.956,679 3,211,613 3,372.194 3;540,804 3,717,044 3,903,736 4,098,923 4,303.669 4,519,062 4,746.015 9,962,286 5,231,980 419,134 439,041 450,993 464,x43 509,245 533,657 560,940 584,357 017,775 444,063 561,006 715.151 750,696 766,454 3.904,261 4,341,396 540961562 0,756.477 0.995.551 7,437943 7,609.961 6.205,354 6,610,372 9.090,601 9.545,435 10,022,707 0,523.542 11.050.D34 110x2.36 12,112,543 12,791,700 13.431,3e6 14102.955 14,660,163 1343,76(3) 650742) 1490 514) 1,526594] 1,646,433) 11.527.030) 1.577.010( 01569.520) 11,572.767) 11.599,051) 1.570.136) 1,*32.651t 41.561.896) 1,506.067) 1,6290611 11.662587) 1.6846581 1,751,348) Il 824,097; 1,801,0461 264,867 298,150 327622 666,526 245,671 239,768 102120 le7,522 179.630 136,152 117,255 719460 143,650 149,449 159,374 174,292 194,375 221,270 290,478 305.909 12361 14,76 ,1361 1397,471] MASS) 1359,9131 1335,7561 1305,0131 1780.300) 1250,1641 218,6001 Y1 so600) 113,100) 104.1007 16311001 171,500} 0 0 0 a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 a 50,497 55,216 57,039 70,094 61,550 46,445 11,24511,245 634,060 1 21, 080 0 7,769,929 19,817,059 1935.444! 11,134,1321 8,110,945 18,874,415 076.321} 66,269 175,057) 153,6707 173,636) 141;3011 1100570) 014036) pe, 536) 162,101) 759 45,340 95,774. 152,792 164,375 221,270 200,678 386,009 7,787,190 19,323,676 2,664.75) 11,472,315( 1,721 4901 0,590,7001 1,750,606) 1.730,9111 11,673,436) 1,711,0871 0066,871) 1.595,047) 1,541,136) 1,550,716) 11,593007) 11.609.665} 0 502113) 11537.0791 11,533.4101 1524.D50} 934,150 630104 3,602.034 7104621 1206.4281 1313.123) 37,721.207 57,647,019 56,604,216 57,569,601 55,846,111 54,267,411 52,516,743 50,765,834 40,112,300 47,309,309 45,729,638 44.134,597 42,573,450 41.022,741 30,488.634 37,079,630 30,478,746 34541,887 33,408,240 31,603,299 City of Plymouth Utility Rabe Study 1 Revenue growth aseumpti----ge 2 Iheenment Ineam. y+eld 3 Eapease growth - par.onnel a mtemol 4 Expense g -Ah • repair and melntenance 5 Expense growth - non persennel 8 Expense growth -MCES 7 a 9 8a01-irg net Moats 10 Wa7 88 CIP Fondling SoCurnnl Va. Caplhl 70 Bend Proceed• 71 Bond P61- Fuhs.(15 years at 5%) 72 Band P41- Futuro (15 years al 5%I 73 Bond P81- Future (55 years •15%1 74 Bond P61- Future 115 yesre •15%) 75 Bond P51- Future [75 years at 5%) 76 Bond P61 • Ft1turo {15 yew at 5%) 77 Bond P61•Fuxin {1S yew" * 78 Band Pe' Future {55 yew at 5%j 70 Bond P61 -Futuro [15 yaw atz a0 Band Pal -Futuro [15 yaw at 5%) 61 Bond P61• Futuro [i5 yew n8%) 12 Bond PW-Fuxire [15 yew ars%) E3 Btlnd P&I -Future [75 yaw at 5%1 114 Bond Pnn • E.Mirg 95 98 B•OmMng Cnh 97 Add not operab40e(one 457 98 Add bock deprauabwh 01ne 32} 69 Ada nv1 non oper.bnp (6n• 56) 00 Add capMl and bond Was "A) 01 Net o4er 02 Ending Cash 9394 05 98 Ending net assets 97 9a 90 Capita outlay cwvregv 190181 Target minlmum workln. -pi. 102 Amid -W ng capltat 103 164 Beginning Accumuieted Cepr000ti- 105 C•pncladan IGS Addti 107 Total pepro4advn 109 Ending Accomu{eted Depreclebon JOB110 i11 72 Utibly Trunk Replacemenl 113 Bepinnirlg Cash 114 Capitol Pmyact• 115 Tnndaroul 112 Bend prtlwe. 117 C.necbon ieea•weter 118 Conneobon leeeaewor 110Area ehargen 120 S9•U44 auesemenm 121 Interosl 122 Bond P61 • Future {15 yew at 5%) 123 Other 124 En41n2 Cash 3.00% 3.00% 3.50% 3.50% 3.50% 150% 150% 3.50% 3.50% 3,50% 3.50% 3.50% 3.50% 3.50% 5,00% 5100% 5100% 5.00% 5.00% 5.00% SAW 5,00% 5.170% 5,017% SAM 5.00% 5.00% 5.00% 5,00% 5.004E 5.00% 5.00% 5.00% 5.00% 5,00% 5,00% 5,00% 5100% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5,00% SAM S,0O% 5.00% 5.00% 5.00% 5.00% 5.00% 5,00% 25,999;018 37,721,267 5707,019 55,504,218 1 57,589,501 55,848.1111 54,207,411 52.515,745 50,795,834 49,712.398 47,399,309 45329 010 44,134.597 42.573,459 41 022.741 39,456,834 37,879,030 38,478,746 34,941,667 33,408,248 25,937796) (1,769,353) 1715.000) (725,000 18.535,532 13,178,536 10 .167,359 1650,742) 11,685.514] 11,820,564' 57,1724 2,175,019 2.515,303 19,074,418 (076,321) 65,209 05937,796) (2 504,363} (2,279,573', 10,635,032 13,176,538 10,187,356 9,03t%3 37,721,267 57,657,019 55,504,215 57,569,601 0.51 4.07 4,03 6,004,378 9,031,593 24,512,712 0 24,512,712 12,741,575 12,764,575 9,031 ADS 6,345,480 1.6x6433) (1,527.0301 2. 353 2,642.202 175,057) 153,6701 13,491,000] (2,003,0001 6,345,460 5,403,960 55,845,111 54,267,411 26r 3rc(. 6,814,710 9,105,051 6,345,486 5,403,998 24,512,712 27,029,995 2,516,3x3 2,642,202 25111,783 2,642,2x2 27,029,095 20,671297 155,5741 (530,340) II 496 .,613) 1879,462) (461,1621 (2,103,679) 1546633) (573,071) (607.456) (643,903) (1,749,001) (723,469) (766,609) (612,913) 3,100,000 2,103,000 0 0 0 0 0 0 0 0 0 296,6611 1296,661) (296,661) 1298.6611 (296.661) (298.661) {206,661) (298,661) (296,6611 (298.661) (296,5611 (296,691) (295,681) 202,0957 M2.6051 (20205) (202,695) (202.695) (202,695) (202,695) 1202,8951 765000) 905.0001 630,0097 560.900) 890,000) 920,909) 955, 000Y 095,0001 0,030,000) 1 ,075,000) 0 0 0 0 5,403,9116 5,5114,959 5,132,275 3,690,043 3,350,426 3,363,127 4,110,244 4,258.955 4,553,556 4,0794761 5,553,567 8,321.960 6,305,981 10.485,674 1,577,0301 1,589,520) 1,572,7677 0.599.051) 1,570,136) 1,532,1151) I,Se1,896) 1,596,057) 11,529,661) 11,662.5971 1,I D4,058) 0.758,346) 0,524,007) 1.691,049) 2.774 312 2.913920 3.058,678 3,211.813 3,372,194 3,540,604 3,717,844 3.203,736 4,098,923 4,303,688 4,518.,082 4,745,015 4,082,268 5,231,3110 1173,636) 141,391) 100,570) 014,036) 09,535} 112,191) 759 45,344 95774 152,792 194,375 221,270 290,676 366,909 843,574) 1.633,901) 2'.627.474) 2.038.143) 1069,623) 1.218,6417 11 ADSMP) 2.059,427) C2,13a,a11) 12220,259) 2,250,357) 0.2248451 1,258254) 1,314,268) 5,554,059 5,132,275 3,680,043 3,350.428 3,383,127 4,110,248 4,260,065 4,553,556 4,079,761 5,553,557 6,327.,889 a,30S,061 10,4115,674 12,477,835 52,516,745 50,765,a34 49,112,396 47,399,308 45,729,636 44,134,597 42,573459 41.022 7411 39,484.834 37,976,030 34,876,746 34,947,667 33,408,246 31,963.299 692 3.14 1.48 1.64 2.03 3.37 2,14 2.2D 2,33 2,50 2,61 6,7E 6,27 9,40 71139,a41 6,403,7211 9,262,656 6,322,238 10,389,672 0,499,956 7,477,476 10,561,270 11.164,676 11,752.02 11,331,330 12909,138 12.721,271 12,106,426 S,Sa4,059 5,132,275 3,920,043 3,350,426 3,381,127 4,110,248 4,280,965 415534558 4,070,781 5,553,567 5,321,089 8,395,Da1 10,465,874 12,677835 29,671,297 32,445,999 35,358,637 38,417,317 41,626,930 45;001,124 4a,541,927 52,259,771 56,143,507 60,242,430 04,565,299 69,095,361 73.830,370 7a.812.643 2,774.312 2,913,028 3,058,879 3,211,893 3,372,104 3,540,804 3,717,644 3,903,735 4,088,923 4,303,869 1,519,062 4,745,015 4,992,206 5,231,360 2,774,372 3,81],026 7,056,678 7,211,853 3,372.194 3,540.804 7.717,944 3.803,738 4,096,923 4,303.669 4.519,062 4,745,075 4,962,16 5,237,360 32,445,800 35,7564697 98,417,317 41,828930 45,001,124 4x,541,927 52,250,771 58,163,507 110,252,430 648115,200 BD,Oa5,367 73,e7O,]ye 78,812,643 84,044,022 12,764,575 14,275,238 74,383,213 14,504,100 15,845,511 16,850,305 7,058,053 9,275,503 10,737,660 10,891264 11,2x4.022 12,366,663 13,362,110 9,959,412 11,751,052 12,566,444 1786,5241 1.a76,B60) 681,738) 1655,731) 10,760745} 210,506) 111,569) 1,267,1091 1841,696) 0 150,976) 3,625,973) 0 0 1, 270,17Lr 0 D 0 D 0 0 0 0 0 0 0 D 0 0 0 140.303 106,316 260.680 279,714 287,400 301.770 316,036 286.167 263.334 276,11D1 282,531 307.158 135,029 141.760 146,868 62,657' ea,085 101,729 108,815 112,15a 117,754 123,652 111,a76 103,545 105,722 114,15a 112,a55 52,624 55,322 56,095 224,421 235,642 247,424 379,851 325,694 415,479 436,253 456,085 367,480 340,709 357,744 375,632 394,413 274,183 287,803 302,296 1,269,243 227,736 557.313 756,873 517,036 455,640 453,520 0874013 332,883 186.'91 1873 14027 Vol 904 666 0 426,257 429,996 437,528 475,305 506,779 256,742 276,206 322,136 328,738 336,521 371,060 400,663 326,783 352,532 377,585 0 0 0 0 0 0 0 0 0 0 14,275;239 14,303,213 1 14,594,190 16,545,611 16,999,305 7,966,053 9,275,593 la,737,9a0 10,a91,264 11264922 12,356,093 13,362,116 10 959,410 11,751,952 12,500,464 12,206,255 Appendix C Server Utility Projections 19 Coy of Ply -11, U'gty Rata Study 1 Revenue growth aaaumpton - nan-agm 2 Inya t -t lnaam81101d 3 Expenaa pruwal - Panonnel 61nt-ml 4 Expen+a 9raw01 • fapalr and mdnlananco 5 Erpanaa 9rawlfl - nae PA. -.1 e Etipana. pn wlh-MCES 7 51 Ba9lnning nal -As 1011 Opwaling R. Anuu f2 Water idea 17Cannac34n he 14 Sever chargee 15 A4dronel Rayanut-now growth ld7 W+Sarmal.r Wa. 17 PanY6eaSAC 19In[ergayammanW 26 Mmollanaaua 21 Ctl1ar 22 Total Opera9ng Ravanuea 23 24 00.l np Expan+aa 25 Water Production 28 Panonnal 27 Additional pamenn+l and opera0ng 20 M.M." and auppeea 26 DO- -tom and chargaa 30Cmtra ml 31 CapdW 33A1aca04n+ 346avmr 6mwca 35monnol 35 Matanda and auppllaa 37CanW-w 30MCES tr..tmant cllarpea 30 CZW. 40 D.Pra41.[IOn 41 All-a44n. 4243 Tctd Op ... tng Exp. - 4445 Net Cpar W ana 48 Non ep.n lutp teem.. Iexp-.4 47 IM1waalmafll Incama 48 Int -M and Bard ten 4g A -aa I I- 60 Mar {neem: (aapaM1ea) 51 7rnafan 52 Fr 6 Ww. Mgm[4M9k11 53 Fr Wntar Raaaurcea F&Nola 1 54 11t0ry Trunk Rtplaumot 55 U86ty Trunk Expnd9n 50 Waior Swt C4nawc6an 57 Trnalan 50 Total non P.."s revenw laap-) 59 0 Nat Inar+ue {4mreaael In reaxurcn 102 C.Pud cwllnAu00n. 53 Deyelaper canhihngone B4 Oth., 05 Ending nal..." 25;801,133 25,307,885 27,196,900 30606290 7,367 1.'14 8,880 1Mill 6,680,121 8,9'w+,110 6,167, 1M 6,697,172 58,402 03,268 57,740 77,649 2.00.0 5,915,900 B,QBSA22 a,2N,7BB 8,594,$40 980,570 956,"9 977,938 917,772 15,953 39.581 53,191 129,126 300,037 435,485 413,131 499861 3,507,304 3,142,060 4,154787 4,205,325 173,1,21 0 13,mp 2279 500,532 520,577 521,838 732,709 189,453 109,118 106,221 19.287 5,1114.556 5,040,240 8,261,927 81857,172 176,5761 40,762 9,839 (82,523 97,216 75,345 54,515 134,556 48,948 98,439 11,920 1 33.732.346 33900.771 JAL11 959,306 971,335 143,506 152,490 410,095 602.080 4,42Q,Qa6 4566,6/P 39089 2 so 732,705 769,335 203.679 211,762 6.990,104 7,259,331 202,100) 113 Tao 3,0.6% 30.0% 3.50% 3.50% 3,50% 3,50% 3.50% 3,55% 3.50% 3.50% 3.50% 3,50% 3,50.% 3,50% 5.00% 50.0% S.PO% 5,00%. 5.0994 5.0.0% 5.00% 5,90% 5.00% 5.00% 5.00 5,0D% 5.00% 5,00% 5.00% 5.00% 5.00% 5.00% 5 Do% 5,50% 5.00% 100% 5.00% 5.00% 5.00% SAM 5.00% 5.15% 5.00% 5,00% 3,00% 5,09% 5,00% 5.00% 5.00% S.Oa% 5.00% 5,00% 5,00% 5,00% 5100% S,PO% 5,00% 5,00% 5.00% 5.00% 30.5% 5,00% 5.00% 5,00% 5,00% 5,00% 5,00% 409% 5.00% 5.005 33,824,100 34,146.955 34,571124 35.145,473 35,675,911 38,776,201 37,838,221 39094,815 4015184830 42,171730 44077,610 46.154.610 48,477,572 51.017,070 7.712,717 6,136,817 6,66{,447 9,Od5,fi1 9,154704 10,060,213 10,6]4,623 11,219,329 11,636,603 12,467,616 13,174,{36 13,888,@2@ 14,1",476 11,469,687 127,171 200,129 280,728 38@,9$6 4$7,373 574.787 860,404 787.078 @01,241 1,020,17 I,167,SH1 1,267,82@ 1,775,150 1,180.,$64 66,440 69,609 71,205 72,620 74,082 75,553 77075 75,616 60,131 81,792 $3,425 05,086 86388 86,534 7,906,376 6,488,855 6,63$,360 6,408,609 70,19751 10,730,573 11,392,284 12WS,224 12,826,047 13,599229 74,425,444 15,251,754 16.125,424 17,049,166 102@.112 1A71, 717 1.124,673 2,007,517 1,239.952 1.301,950 1,3&7,647 415,736 7,587,170 1,51,526 1,881955 42: 1777,214} 150.251) 59 625} 033.171} 173,1,21 62,733 7,620 2,514.356 60,011 36,575 1711.731) 120,515 17.,659 2,451,635 1141,5771 233,335 735,555 752,057 3,012,2161 047,616 2, 2: 11 11,680 1220,:391 26,404 2931,686 21,190,000 30,808,290 33,732,340 SS,SPo,777 39,624,1:0 3,0.6% 30.0% 3.50% 3.50% 3,50% 3,50% 3.50% 3,55% 3.50% 3.50% 3.50% 3,50% 3,50.% 3,50% 5.00% 50.0% S.PO% 5,00%. 5.0994 5.0.0% 5.00% 5,90% 5.00% 5.00% 5.00 5,0D% 5.00% 5,00% 5.00% 5.00% 5.00% 5.00% 5 Do% 5,50% 5.00% 100% 5.00% 5.00% 5.00% SAM 5.00% 5.15% 5.00% 5,00% 3,00% 5,09% 5,00% 5.00% 5.00% S.Oa% 5.00% 5,00% 5,00% 5,00% 5100% S,PO% 5,00% 5,00% 5.00% 5.00% 30.5% 5,00% 5.00% 5,00% 5,00% 5,00% 5,00% 409% 5.00% 5.005 33,824,100 34,146.955 34,571124 35.145,473 35,675,911 38,776,201 37,838,221 39094,815 4015184830 42,171730 44077,610 46.154.610 48,477,572 51.017,070 7.712,717 6,136,817 6,66{,447 9,Od5,fi1 9,154704 10,060,213 10,6]4,623 11,219,329 11,636,603 12,467,616 13,174,{36 13,888,@2@ 14,1",476 11,469,687 127,171 200,129 280,728 38@,9$6 4$7,373 574.787 860,404 787.078 @01,241 1,020,17 I,167,SH1 1,267,82@ 1,775,150 1,180.,$64 66,440 69,609 71,205 72,620 74,082 75,553 77075 75,616 60,131 81,792 $3,425 05,086 86388 86,534 7,906,376 6,488,855 6,63$,360 6,408,609 70,19751 10,730,573 11,392,284 12WS,224 12,826,047 13,599229 74,425,444 15,251,754 16.125,424 17,049,166 102@.112 1A71, 717 1.124,673 1,100,807 1,239.952 1.301,950 1,3&7,647 1,434,400 7,587,170 1,51,526 1,881955 1,1M,737 1,871,974 1,@23.573 185,11 188,796 176,:0' 165,431 194,718 284,444 214,688 22}.798 216,518 43.503 241/,12: 273.674 287,873 302,056 632,195 B:3,804 696,961 731,844 78:,438 665,659 847,291 69,5:1 934,03: 660,741 1029,776 1,681,267 1.13}, 339 1,182,097 4,7a5A:0 5,17,48: 5,2721,776 5,542,769 S,e1@,864 6,110,03* 0416,376 6,737,187 7,074,057 7,427359 7.790,147 0,180,105 6,596,560 9,629.481 159 2,266 2,373 2,492 2,918 2,747 2,1:5 3,62: 3.ia9 3,739 3,590 3,662 8,0.80 4,069 367,062 M8.192 6p0A01 935.132 961,80$ 1,030,682 1,002,532 1,138,659 1,163,491 1,253,188 7,315,14 1,3211 015 1,456,896 1.}23.231 222,350 23 AN 245,141 257,3911 270,28: 21,781 2@7,970 312,888 326,512 344,938 3a?,185 389294 369,309 416,274 7,532,798 5,014,437 8,455,159 3835,917 9,277,713 9,741,599 16,228,679 10.740,113 11,277,116 11,840,974 12.433,023 13,954,674 13,707,405 14,392,771 275.530 392.417 521.221 01,691 816,446 008,674 1,163,585 1,345,111 1,542,924 1,758,255 1,922.421 3.197,080 7,41:,018 2,055387 47,320 32,35152,520 17,546 04,845 70,118 92,947 70,951 10818 97,019 134,389 125,872 121.469 172.9}5 a a a 8 9 0 a 6 a P 0 0 0 0 47,320 32,351 52,528 87,546 84,645 70,116 02,947 70,651 108,926 07,519 134,369 125,672 121,09 172,955 322.850 424,760 573,740 730,430 903,291 1,059,092 1,756,532 1,425902 1,651,649 100,074 2,120,910 2,322.953 2,539,505 2820,342 34,140,056 34571,724 35,145,473 35,675,911 35,779,201 37,838.293 39,994,325 40,918,960 42,171,736 44,027,610 46,154,619 46,477,572 51,0174078 53,849420 City of Plymouth Utility Rat, Study IReyenue growth aswmptlon -nonce"ge 2 I-eaimant In -ma yuld 3 E4pen. growl, • pereonnel & Otani.] dExpense dmwm - repair and mkneanaoce 5 Expenw growls - non personnel a Expense growth - MCE9 7 d9 Beginning net aa.eta 10as 97 d0 CIP Funding a9 Cunem You Ceplal 70 Band Pr...d. 71 Bnd P& Future Maus at 5%) 72 Bond P61- Future (16 yera at 5%) 73 D -d Pig Future (95 }era at 5%) 74 Bend P&I-Future(15y.ane95%1 75 BondP&I•Future 1S yeraat 5%] 76 Dnd P&I-Future(; B Vere at5%} 77 Bond Pal- Fulure(15 yew at 5%) 7d Bond Pal- Future flSYrare at 5% 79 B,ntl P&I - Future [15 yeua at 5%1 B0 Band P&I• Future fl 5 } epen m 5%) 61 Band Pal -Future 175 ra Ki%] 62 BondP&1-Future (15 pan at 5%y 93 Bond P&l-Future(15 Yr -at 5%) Bontl Pnn -Cooling BS 40 Bagmmng Cash 57 Add nalaparatl,ns{IIne 45y 18 Add backtlepnalebn Illne 3Z a. Add reel nen apeneng (IIne 581 90 Add,apltel and B,nd (IIne. 60-041 at Nor.", 2 Ec ding Caeh g3g4 0596 Ending net -is g7gB 99 Cap"al.uSSY.-crape 109 101 Torgat minimum wwlang capita 102 Actual wumng upltal. 103 104 BrOmning Accumuiatod Deprocloon 105 Depreciation14aAddltien 197 T,W O.p..li., 105 Ending Accumuisted Depreciation log110 1H112 USIdy Trunk Rr tla.amnl 113 Bagl-rrg Can 114 C.PNI ykofem. 115 Trnetar.ut 116 Bond pr -d. 117 C,nn,mw lene-weler 118 C,nne,ticcr bes.aewer 119A-rllvgn 120 Sp -IW n`- 121 nta121lid ..t 122 Bontl P&I- Futura(is y- at a%) 123 Me' 124 Ending Cash 3.09% 300% 3.50% 150% 3.50% 3,50% 3,50% 3,50% 150% 3.50% 3.50% 3.54% 3.50% 3.50% 5.00% 5.00% 5.94% 5.99% 5.99% 5.90% 5.94% 5.00% 5.99% 5,09% 500% 5,90% 509% 5.90% 5,00% 5,00% 500% 5,44% 5,40% 5.00% 5.00% 500% 5.00% 9,00% iA0% 5,0014 500% 5.00% 5,09% 5,99% SAD% 509% 5.00% 5,00% 5.00% 5.00% 5.09% 5,00% 3,90% 5,Q0% 5.00% 5.00% 5,00% 5,40% S,OD% 5,00% 540% 5.00% 5.00% 3.90% S.00% 5.00% 5.40% S.DO% 5.00% 5.00% 25281,133 26702,855 27,196,900 30,606,290 33,732,345 33,590,771 33,024,106 34,146255 34,571,774 35,145,453 35,675,911 30,779,201 37,536293 39,094,525 40,519,566 42,171736 027,110 46156,619 46477,572 51,017,076 1525,215} 2,340034) 820.292) 22,995) 1,163,400) 11,557,3101 1521,501}{1,502,3451 950,140) 1,773,149) 917,714) 1,976,372) 1 00,552) 2,220;5511 0,157262) 2675,2211 0.301,0141 It„379.151} 11451, 9D41 1,549,0151 1,509,000 959.-000 1,773,900 1,976,400 2,220,700 2671,200 7,461,90@ 1,549,800 544 5131 1144,5771 1142,51]) 1144,511} 1544,319} 11",5131 161,513) 1144,513) 0",5131 1144,519) 166,515) 7144,5131 94,526) 191,525) 101,525) 1615251 91,5251 191.525) 91,5251 191,525) 91,525} 191,575) 101, 91 5251 170,6151 070,5151 179.5151 176,515) 070.915) 1170,6161 it705151 1170,8151 1170,815) 170,6151 790,411) 190,411; l 00.411) Igo,471) 1904111 1190,411} 190,411) l 00 dl 1) 0 0 0 D 0 0 0 1213.9471 213,9471 713,947) 2/3,947] 213,047) 213047) 0 0 0 0 D 267,1311 1257,631) 257,571) 257,831) a D D 0 0 140,943) 0 D 0 0 0 0 a 0 0 0 0 0 0 0 D D 3.321,461 4701.735 3,312.100 2.74a.1 Is 3.593,174 3.00t.297 1,577,322 1.07a 371 t20Q,792 1920,807 2,424,137 2,003.360 2.655,626 2.264.319 3.112,158 2.704,833 539,674 3.596,355 3,471113 4,941,575 75,5741 46,782 9,939 525731 1202,1141 109,710 275,530 302417 521,221 662,091 616448 @a6,@74 1,153,585 1,345,111 1,542,924 1,755,255 1,992429 2,197,050 2,415.01a 2,656.]87 500,532 520,877 529,836 732,709 732,700 0 9 0 0 0 0 0 0 D Q 0 d 0 0 Q 33,1521 12,733 7,52D 2,514,351 60,611 39,575 47,320 32,351 52,526 57,546 54,a45 70,111 92,947 79951 106,024 97,119 534,369 123,672 521,489 172.955 1525.2151 2,340.6341 1620,2021 22,9981 11,183.0001 1,9579101 1821,601) 2.346) 144,5541 1236,187! 01324.090) 1405,1251 11,/27,5471 597,2111 1,959,174) 611 2331 2,970,129) 14.,448,1941 11,D5o,043) 11,209200} 1409.732) 370,007 361,077) 2,311,4x61 4,701,735 3,392,106 2,746,116 3,503,174 3,001,297 1,577,322 1,078,371 1,500,792 1,929,687 2,424,137 2,DD3,340 2,055,626 2,284,311 3,112158 2,7N,a33 3,839,674 3,506,355 3,471,113 4,941,675 a,5e1a15 25,302,641 27, Mig00 30,408,200 33,732,348 33,590,771 33,424,t04 34.146,956 34,571,734 35,145,473 35,075,911 38779,201 37,839,283 39,094225 40,51909 42.171,734 44,D27,010 46,154210 414T7,572 51,017,076 3,646.420 1,44 0.00 155.24 2,54 0.95 1.31 639.29 13.34 10.26 1,51 6.53 1 A 5.21 1,42 4.73 1.52 1.42 4.62 5,42 3,421,439 4.017,890 7.250,362 4.1W,105 3,430,311 41064355 4,314.312 5,575,052 4,987.224 4.333,1 90 5269,139 T,d01.325 MUMS 8,779,411 7,056,754 7,551229 6,339.433 3,593,174 3,001,297 1,577,322 1,07a,371 1,500,792 1,029,887 2,424,137 2,003,380 2,655,426 2,284,311 3,112,158 2,704,833 3,830,174 3,506,355 3,471,113 4,941,376 6,541,017 11,412,925 11.482925 12.215024 12,914,901 13.792.743 14,040.955 15,331,556 14,464,049 17,441,570 16,479,554 19,552,090 20,696,741 21,892,239 23,145,405 24,441,229 25,16420" 27.293,540 0 732,700 T6@,335 07,902 646,102 820.001 036,132 061,Bd8 1,630,982 1,062,532 1,131,656 1,103,491 1,253,111 1,3t3,621 t,961,615 1,450,606 9,523,231 0 732,700 789,335 547,602 648,102 690.501 935,132 051.,858 1,030.952 1,W 2.532 7,738.695 1103,401 1,253,140 1,315.824 1311.475 1450,60/ 1,523,231 11,442.924 12.215525 12914,961 17,792,753 14,640,956 95,5]1,506 16,A45,6a1 17,445,676 7/479,556 10,552,490 70,668,746 21,192,330 23,16$405 24,401,229 23,842,8" 27,3@3,560 25;16,770 Appendix D Water Utility Capital Improvement Plan 20 GM % 11114!2008 City of Plymouth Water System Capital Improvement Program 3,001,136 4,313,860 671,109 1,793,222 11;660,227 691,676 2,103,879 1,366,373 1,269,410 607,456 643,903 4,308,515 723,489 766,899 2,063,088 Appendix E Sewer Utility Capital Improvement Plan 21 6.00% 11/14/2008 City of Plymouth Sanitary Sewer System Capital Improvement Program Proiect No 1,306,980 1,657,310 1,143,375 1,843,216 1,311,461 1,773,149 917,214 2,087,941 1,452.952 2,346,010 1,157,962 2„837,197 2,367,550 1,379,151 1,461,900 1,549,615 Note: past practice Indicates that lift station generators have been paid through trunk fund 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 _ 2019 2020 2021 - 2022 2023 Projects CAPITAL EQUIPMENTIPROJECTS Sewer lining dump truck 08-VE-NEW4 30,000 Line station annual maintenance program O"S-003 373,000 400,006 450.000 500.000 510,000 510,000 510,000 510.000 510.000 510,000 510.000 510.000 510,000 510,000 510,000 510,000 Refurbish/upgrade Pike Lake lift stator 08.5$-002 900.000 Refurbish/upgrade Im anal Hills lift station 11 -SS -001 140.000 600.000 POILrbisNupgrade, Ferndale N lift station 13 -SS -001 100,000 700,000 Street reconstructuon sewer 2098 110.000 Refurbish/upgrade 28th Ave lift station 08 -SS -001 600,000 Gree free West lift station 630.000 Waterfront IM station 630,000 Bass Lake Plaza lift station 720,000 CR 101 -Cr 5 to CR 24 08 -ST -003 100,000 2009 street reconstruct -Districts 71 09ST-008 75,000 2010 street reconstruct-Distncts 71 10ST-001 100,000 2011 street reconstruct 11 -ST -001 90.000 2012 street reconstruct 12 -ST -006 100,000 2013 street reconstruct 13 -ST -001 40,000 Future street reconstruction 100,000 100.000 100,co0 100.000 100,000 100,000 IOO.ODO 100,000 100,000 100,000 11SubtotalCapital1,113,0001 11475,000 690.0001 1.190,000 710,000 1.250,0001 61 0.000 1,240000 510.000 1,240.000 610,0001,330.000 610,000610,000 610,0001 610,000 Inflated at 6% PROJECTS 1,179.780 1,657,310 821.501 1.502.348 950.140 1.773.149 917.214 _1.976,372 1.030.582 2.220,651 1.157.962 2.676,221 1.301,086 1.379,151 1,461,900 1,549,615 Trunk seweroversizin OBSS-002 250,000 270,000 270,000 250,000 500.000 Greentree West lift station generator 70.000 Pike Station ktt station generator 100,000 Waterfront lift station gererator 70,000 Mission Farms lift station generator 20,000 Bass Lake Plaza lid station generator 80.000 Bass Lake Iltt station generator KOM 1= 1 Subtotal Protects 120,000 fl 270,000 270,000 1 270.000 0 0 1 70,000 1 250,000 70,000 D 80,000 i 5DD,000 1 0 1 0 t 0 Inflated at 6% 1 127,260 0 321,574 340,869 361,321 0 0 111,569 422,370 125,359 0 160,976 1,066,464 0 0 0 1,306,980 1,657,310 1,143,375 1,843,216 1,311,461 1,773,149 917,214 2,087,941 1,452.952 2,346,010 1,157,962 2„837,197 2,367,550 1,379,151 1,461,900 1,549,615 Note: past practice Indicates that lift station generators have been paid through trunk fund