Loading...
HomeMy WebLinkAbout20080520Crowley Direct.pdf't ,,..r Dean J. Miler (ISH No. 1968) McDevitt & Miler LLP 420 West Banock Street P.O. Box 2564-83701 Boise, Idaho 83702 208-343-7500 (T) 208-336-6912 (F) joeaymcdevitt-miler.com 211m 20 PI"\ i: 06 Attorneys for Teton Springs Water & Sewer Company LLC. ORIGINAL BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF ) TETON SPRINGS WATER AND SEWER ) COMPANY LLC, FOR THE ISSUANCE OF A ) CERTIFICATE OF PUBLIC CONVENIENCE ) AND NECESSITY, FOR APPROVAL OF ) RATES AND CHARGES FOR WATER ) SERVICE, FOR APPROVAL OF ) RULES AND REGULATIONS GOVERNING ) THE RENDERING OF WATER SERVICE. ) ) CaseNo.l7..w-08-cf BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION DIRECT TESTIMONY OF LARY A. CROWLEY May 20, 2008 ~ 1 Q. 2 A. 3 4 5 6 7 8 Q. 9 A. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Please state your name and your business affliation. My name is Lar A. Crowley. I am Director and President of the Energy Strategies Institute ("ESI"), a consulting company and network of experenced business professionals with diverse interests specializing in energy and utility matters. The Institute provides regulatory and litigation support, industr restrctung support including economic and financial analysis, and business and organzational development analysis and implementation support. Please descrbe your educational background and professional experence. I have a Bachelor of Science degree in Economics from the University of Marland, College Park, Marland. I have over 30 year of extensive utility industr experence including corporate strategic planng, organzational development, new business development including renewable energy technologies, regulatory affairs, transmission system planing, and generation and resource planng. My regulatory experence includes the preparation and filing of testimony and exhibits before varous regulatory commissions, including testifyng as an exper witness before the Idaho Public Utilities Commission, the Oregon Public Utilties Commission, the Nevada Public Service Commission, the Colorado Public Utilities Commssion, the Wisconsin Public Utilities Commission, the Michigan Public Serce Commssion, the Nort Dakota Public Serice Commission, the Montana Public Serice Commission, the Texas Public Utility Commission, the Pennsylvana Public Utility Commssion and the Federal Energy Regulatory Commission. A sumar of my professional experence is attached as Exhbit 4 to ths testimony. Crowley, Di 2 Teton Springs Water and Sewer Company LLC I Q. 2 A. 3 4 Q 5 A. 6 7 8 9 10 11 12 13 Q. 14 15 A. 16 17 18 19 20 21 22 23 On whose behalf are you testifyng in this proceeding? I am testifyng on behalf of Teton Springs Water & Sewer Company ("TSW &S" or the "Company"). What is the purose of your testimony in this proceeding? My testimony addresses the preparation of a revenue requirements study using total Company data for the 12 months ending December 31, 2007 adjusted for known and measurable changes, the test perod being used by the Company in ths proceeding. My testimony specifically addresses the calculation of the Company's jursdictional revenue deficiency and revenue requirements for water distrbution and deliver serce provided by the Company. I also recommend rates for water service based on the results of the revenue requirements study and the natue of the system and serce characterstics. Please explain how the Company's jurisdictional cost of servce and revenue requirements for water distrbution and deliver service was deterined. First, prior to May 2008, when the sewer and water assets at issue in ths filing were transferred to Teton Springs, the water and sewer system was operated by Teton Springs Golf & Casting LLC and the financial results of operations were shown on the books and records of that company. The financial records of Teton Springs Golf & Casting LLC were not organized according to the Uniform System of Accounts for Class C Water Companes (USOC) as promulgated by the National Association of Public Utilty Commissioners and adopted by the Idaho Public Utilties Commission. My first step, therefore, was to re-classify the plant accounts, revenues and opertin¡expenses for the 12 month perod ending Crowley, Di 3 Teton Springs Water and Sewer Company LLC 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Q. 17 18 19 A. 20 Q. 21 22 A. 23 December 31, 2007, to be consistent with the USOC. These results are shown in Exhibit 6 in Colum 2, "Total Utilty per Books." Second, because Teton Springs operates both an unegulated sewer system and a water system which wil be regulated, it was necessar to prepare an abbreviated jursdictional separation study to allocate plant accounts and financial results of operations between the unegulated sewer business and regulated water business. These allocations are shown in colums 5 and 6 of Exhibit No 6. Third, ths filing is based on the investments and expenses incured by the Company to provide water distrbution and deliver service to its jursdictional customers. Accordingly, the Company's historic test year per books (CY 2007) operating results are adjusted to reflect know and measurable changes to revenues and expenses. Exhibits 5 though 9 provide specific details regarding the allocation of total Company costs between the Company's water and sewer (unegulated) business units costs and the deterination of the Company's water jursdictional distrbution servce revenue deficiency and revenue requirements. Have you prepared work papers with the Company's Application supporting your reclassification of accounts and allocations between Unreguated Sewer and Regulated Water? Yes I have, and they are available for audit by the Commission Staff Have you prepared or supersed the preparation of varous exhibits or Cost of Serce Statements for this proceeding? Yes, I have prepared or superised the preparation of the following exhbits or Cost of Serce Statements for ths proceeding: Crowley, Di 4 Teton Springs Water and Sewer Company LLC 1 2 3 4 5 6 7 8 9 10 11 12 Q. 13 14 A. 15 16 17 Q. 18 19 A. 20 21 22 23 Exhbit No Descrption 5 Jursdictional Operating Income - Pro Forma at Present and Proposed Rates for the 12 Months Ending December 31, 2007. 6 Development of TSW &S Revenue Requirements - Jursdictional Separation Study and Cost of Service Study for the 12 Months Ending December 31, 2007. 7 Schedule of Accounts and Sumar of Adjustments for the 12 Months Ending December 31, 2007. 8 Calculation of the Net-to-Gross Tax Multiplier. 9 Development of Water Tarffs based on the cost of serice results for the 12 Months Ending December 31, 2007. Have you calculated the Company's revenue deficiency for its water distrbution and deliver service in Idaho? Yes I have. The revenue deficiency for the Company's water distrbution and deliver serice is $99,256 based on the test perod ending December 31,2007, as adjusted. Please generally descrbe the methodology used to separate Total Utilty costs between the regulated water and unegulated sewer jursdictions. The cost of providing serce is measured through the use of the Company's accounting and operating data for a specific 12-month perod oftime. In ths instance, I am using the total utilty information provided by Mr. Jon Pinardi, Director of Operations of the Company and adjusted by myself in collaboration 'with Mr. Pinardi for the 12-month perod ending December 31,2007, which is the Crowley, Di 5 Teton Springs Water and Sewer Company LLC 1 2 3 4 5 6 7 8 Q. 9 10 A. 11 12 13 14 15 16 17 18 19 20 21 22 23 test year being used in this proceeing to determine water distrbution and deliver revenue requirements. The methodology used to separate costs by jursdiction and to calculate the Company's jursdictional revenue requirement for water distrbution deliver service in this case is descrbed in detail below. After re-classifyng and allocating the accounts, I then made a series of adjustments to the per books values to reflect known and measurable changes. Those adjustments are sumarzed on Exhbit No 7 and are detailed below. Have you prepared an exhibit that sumarzes the calculation of the Company's water revenue deficiency? Yes. I prepared Exhibit 5 consisting of thee tables and three pages. Ths exhbit sumarzes the results of the jursdictional separation study prepared for the 12 months ending December 31, 2007 that is descrbed in detail later in this testimony. Table 1, page 1 of this exhibit, sets fort the Company's jursdictional operating income (losses) at curent rates and operating income, including incremental income taxes, at proposed rates for the Company's water jursdiction. Table 2, page 2 of ths exhbit sets fort Total Utility operating income and sumarzes the calculation of the jursdictional revenue deficiency and revenue requirements for the Company's Idaho water jursdiction. References are provided for the supportng cost of serice statements detaled on Exhibit No 6 for each component shown on ths table. As shown in colum 2 of ths table, the revenue deficiency previously identified results in a total revenue requirement of $345,252 and a revenue requirement of $298,082 from water rates. The indicated Crowley, Di 6 Teton Springs Water and Sewer Company LLC 1 2 3 4 5 6 7 8 9 Q. 10 A. 11 12 13 14 15 16 17 Q. 18 A. 19 20 Q. 21 A. 22 23 revenue requirement would provide the revenues necessar to recover the Company's costs of providing water serce and ear a modest operating margin. Table 3, page 3 of Exhibit 5, sumarzes the calculation and allocation of the Company's plant in serice and rate base. This table shows the allocated individual components of rate base for the Total Company and the Company's water jursdiction. References are again provided for the supporting cost of servce statements for each component of Total Utilty rate base. The Company's allocated water rate base is a negative $50,993. Please explain the Company's water rate base and its implications. Although the water plant in serice is valued in excess of $3 milion, that investment is completely off-set by contributions in aid of constrction. As a result, the Company has a negative rate base. Under traditional rate making principles, since there is nothing on which the Company would ear a retu, the Company would only recover its anual operating expenses and would not produce any operating margins or source of fuds for continuing operations or contingencies. Is that a desirable or reasonable result for an ongoing utility? No. Ever business strves to produce some amount of margin over its operating expense so as to maintain financial stabilty. What do you propose as a remedy? As shown on Table 2, Line 8 of Exhibit No 5, I am proposing that the Commission allow an anua amortization expense of$89,140. Ths amortization is similar to what other Idaho water utilties have been allowed to do in order to Crowley, Di 7 Teton Springs Water and Sewer Company LLC 1 2 3 4 5 6 Q. 7 A. 8 9 10 11 12 Q. 13 A. 14 15 16 17 Q. 18 19 A. 20 21 22 23 recognze the wear and tear of the water assets in serice and, over time, reduce the amount of contrbuted capital in the same fashion depreciation is used to amortze and reduce plant in serce financed by conventional debt and equity instrents. The anual expense amounts of ths amortization would be booked to Account 272 - Accumulated Amortization of CIAC. What would the effect of this allowance? In addition to recognzing the normal expense associated with the wear and tear of the operating assets, it would produce cash flow for the Company to maintain and upgrade its system, improve the financial stabilty of the Company and it would, over time, amortze the contrbutions of aid in constrction from the Company's books. How did you calculate the amortzation amount of$89,l40? The calculation of the propose amortzation adjustment is detailed on Exhbit No 7, page 10. The amount shown is based on a defacto depreciation schedule which I calculated using the most recent depreciation rates approved by the commission applied to the reclassified plant accunts of the Company. What other adjustments are you recommending for calculating the Company's revenue requirements? As shown on Line 17 of Page 2 of Exhibit No 5, I am proposing that the commission allow the Company to include a modest operating margi in the calculation of its revenue requirements. The amount of the proposed margin would be based on the Company's operating expenses rather than a retu on rate base. I am proposing an operating margin equivalent to 7.5 percent ofthe Crowley, Di 8 Teton Springs Water and Sewer Company LLC 1 Company's total operating expenses as shown on Line 10 of Page 2 of Exhibit No 2 5. Ths wil provide the Company a small margin to cover unexpected increases 3 in expenses, other contingencies wil allow the Company to show a margin over 4 its operating costs. 5 Calculation of Jurisdictional Revenue Requirements 6 Q. Please descrbe Exhibit 6. 7 A. Exhibit 6, which consists of 10 pages, is the complete Jursdictional Separation 8 and Revenue Requirements Study ("JSS") detailng the allocation of each 9 component of rate base, operating revenues and expenses by account number for 10 the 12 month test perod ending December 31, 2007. The JSS is designed to 11 show the Total Utility values as developed (Colum 2) and the allocation of those 12 total utilty values to the Company's water service which is at issue in this 13 proceeding (Colum 6). Results from ths JSS for the Company's water 14 jurisdiction were used to prepare the proposed rates for water serce. The JSS, 15 Exhibit 6 is organized as follows: 16 Table No Description 17 1 Total Rate Base 18 2 Cost of Servce and Revenue Requirement 19 3 Utilty Plant in Serce 20 4 Accuulated Provision for Depreciation 21 5 Optig Revenues 22 6 Opation & Maintenance Expenses 23 7 Depreciation & Amortization Expenses and Taxes Crowley, Di 9 Teton Springs Water and Sewer Company LLC 1 2 3 Q. 4 A. 5 6 7 8 9 10 11 12 13 14 Q. 15 A. 16 17 18 19 20 21 22 23 8 Calculation of Incremental Federal & State Income Taxes Please descrbe Table 1 of Exhibit 6. Table 1 is a sumar table which consolidates allocated jursdictional water utility rate base information developed on varous tables of the JSS. The tota Company's jursdictional water rate base in the amount of $(50,993) is shown on Line 20, Colum 6 of Table 1. References to supporting tables or specific allocation factors are also shown for each component of Total Utilty Rate Base and are listed under the colum labeled "Allocation Factor or Reference". Table 1 sumarzes plant in serice, accumulated provision for depreciation, contrbutions in aid of constrction (CIAC) and working capital requirements. Working Capital is calculating in the traditional maner by using 1/8th of total operation and maintenance expenses. Please describe Table 2 of Exhbit 6. Table 2 is a sumar table which consolidates allocated jursdictional revenue and expense information developed on varous tables of the JSS. In addition, this table details the calculation of revenue deficiency and revenue requirements for the Company's Idaho water jurisdiction. The Company's water jursdictional revenue deficiency and revenue requirement are $99,256 and $345,252, respectively, shown on Lines 25 and 27 of Colum 6 of Table 2. References to supporting tables or cost of serce statements are also provided for each component of ths table and are listed under the colum labeled "Allocation FactorlRef'. Crowley, Di 10 Teton Springs Water and Sewer Company LLC , 1 The net-to-gross tax multiplier for the Company's Idaho jursdiction is 1.6350 2 which is shown on Line 24, Colum 6 ofthis table. The development of the net- 3 to-gross tax multiplier is detailed on Exhibit 8. 4 Q.Please describe Table 3 of Exhibit 6. 5 A.Table 3 of Exhibit 6 sets fort the separation and allocation of water and sewer 6 plant in serice. Any component of plant that is allocated by direct assignent 7 has an allocation factor that begins with the letters "DA" to reflect direct 8 assignent. For example, water plant is allocated to the Company's Idaho 9 jursdiction by direct assignent. 10 Q.Please descrbe Table 4 of Exhibit 6. 11 A.Table 4 of Exhibit 6 sets fort the allocation of accumulated provision for 12 depreciation and amortzation of plant in serice. Allocation factors are listed in 13 the colum labeled "Allocation FactorlRef'. The allocation factors used to 14 allocate accumulated provision for depreciation are normally based on allocated 15 plant balances. In this case since all water and sewer plant accounts were directly 16 assigned, the accumulated depreciation was allocated in the same fashion. I 17 should also note that this information is being provided for reference only.Since 18 the Company is not claiming any depreciation on contrbuted plant, this 19 information is not included in the calculation of rate base. I should also add that 20 these balances were calculated by an assessment prepared by CH2M Hil on 21 behalf of Teton Springs Golf & Casting. 22 Q.Please descrbe Table 5 of Exhibit 6. Crowley, Di 11 Teton Springs Water and Sewer Company LLC 1 A. 2 3 4 5 6 7 Q. 8 A. 9 10 11 l2 13 14 15 16 Q. 17 A. 18 19 20 21 22 23 Table 5 of Exhibit 6 sets fort the total operating revenues at present rates for the Company for the 12 months ending December 31, 2007. This table lists the Company's revenues by jursdiction and Other Operating Revenues by account number. Oter Operating Revenues are allocated or directly assigned to the appropriate jursdiction. Also shown are the anualizing adjustments to water revenues which are shown in Column 3 and descrbed below. Please descrbe Table 6 of Exhibit 6. Table 6 of Exhibit 6 details the Company's Operation and Maintenance Expenses by servce and by account number for the 12 months ending December 31, 2007. Allocation factors are listed in the colum labeled "Allocation FactorlRef'. In general, the basis for each allocation may be readily interreted from the exhbit. Many of the allocations are direct assignent to the appropriate fuction or servce and begin with a "DA"; other allocation factors are referenced as necessar. Also shown are the anualizing adjustments, shown in Colum 3, to operating and maintenance expenses which are described below. Please descrbe Table 7 of Exhibit 6. Table 7 of Exhibit 6 details the allocation of the Company's Depreciation and Amortization Expense by fuction or by serce. These expenses have been identified by fuction or by primary plant account. Allocation is then accomplished on the basis of the related plant account as previously allocated or by direct assignent. All taxes, including taxes other than income taxes, are also sumarzed on this table. Taxes Other Than Income Taxes are listed individually and are allocated in a maner consistent with the basis by which the Crowley, Di 12 Teton Springs Water and Sewer Company LLC 1 2 3 4 5 6 Q. 7 A. respective taxes are assessed. For example, the Company's public utilties commission assessment fee is allocated on the basis of jursdictional revenues which are subject to the fee assessment. Also shown are the anualizing adjustments, shown in Colum 3, to amortization and tax expenses which are descrbed below. Please descrbe Table 8 of Exhbit 6. Table 8 of Exhibit 6 details the calculation of the Company's jursdictional 8 incremental income taxes for the 12 month perod ending December 31,2007 9 based on the increase in revenues shown on Table No 2. 10 Annualiing Adjustments 11 Q. 12 A. 13 14 15 16 Q. 17 18 A. 19 20 21 22 23 Please descrbe Exhbit 7. Exhibit No 7 is entitled Schedule of Accounts and Sumar of Adjustments and consists of 10 pages. The fist page is a sumar of all the known and measurable adjustments used in the preparation of the jursdictional separation study and the results of each adjustment by USOA account number. Please sumarze the anualizing adjustments you are proposing for ths proceeding. The first adjustment is to reflect the increase in management fees to the Company. These fees were increased on Januar l, 2008 by $6,000 per year. The Company does not have any employees and therefore uses outside contract sources to manage and operate the Company's assets and facilities. The second adjustment is a reduction in operating expenses of$3,785 to reflect the elimination of one- time purchase expense of biling softare which is a non-recurng expense. The Crowley, Di 13 Teton Springs Water and Sewer Company LLC 1 thrd adjustment reflects the increase in chemical expenses associated with the 2 higher number of customers and related higher usage of water requiring treatment. 3 The four adjustment reflects the increase in operating revenues associated with 4 the anualizing of new customers by each class of customer. The new level of 5 customers is based on actual customers receiving serce in the first quarer of 6 2008 as well as undeveloped lots within the Teton Sprigs development. The 7 fifth adjustment reflects the anualizing of expenses associated with lab sampling 8 expenses. The sixth adjustment reflects the assessment of the IPUC fees to what 9 would now be the regulated water business of the Company. The'adjustment LO reflects the application of the fee rate approved by the commission in its Order No 11 30537 in Case No F-2008-L. The seventh adjustment reflects the thee-year 12 amortization of the outside expenses incured by the Company to prepare and file 13 this case. These expenses do not include any curent employees or other outside 14 contract employees of the Company. The eighth adjustment details the proposed l5 amortzation of CIAC discussed earlier in this testimony. Each adjustment has an 16 individua worksheet attached to Exhibit No 7 which details the calculations for 17 each adjustment. The eighth adjustment contains two pages. 18 Net-to-Gross Tax Multiplier 19 Q.Please descrbe Exhibit No 8. 20 A.Exhibit No 8 details the calculation of the net-to-gross multiplier used to calculate 21 the Company's revenue deficiency as shown on Exhbit No 5 and Exhibit No 6. 22 The multiplier uses curent IPUC assessment fees, state income tax rates and 23 federal income tax rates. Crowley, Di 14 Teton Springs Water and Sewer Company LLC I Rates 2 Q. 3 A. 4 5 6 7 Q. 8 A. 9 10 11 12 13 14 15 16 17 18 Q. 19 20 A. 21 Q. 22 Please descrbe the rate design that the Company is proposing. Teton Springs is proposing revised rates; one for those customers who are curently taking water serce from the Company; and another for those customers/owners who are curently not taking servce but who have facilities provided by the Company available to their property. Please descrbe Exhibit No 9. Exhibit No 9 is a one-page exhibit which sets fort the curent monthly rates for water service (Colum 5), the proposed rates for the active and non-active customers by class of serice. The proposed rates for all customers are flat since serice is not metered. The rates and revenue recover from the application of rates are shown for the total jursdiction (Colum 1, Line 16) which is shown on Exhibits 5 and 6. Exhbit 9 shows the proposed rate strctues consisting of a flat monthy charge, which wil be biled on a quarerly basis, for customers who are curently receiving serce and are connected to the system, and an availabilty charge for properies or inactive customers for which facilities are in place and that are capable of being connecte but have not yet done so. Does Company Witness Jon 'linardi explain the rationale for this rate design in his testimony? Yes, he descrbes the reasons for a flat quarerly charge and an availabilty charge. What rates are you proposing for the monthy active service charge and the availability charge? Crowley, Di 15 Teton Springs Water and Sewer Company LLC 1 A. 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Q. 17 A. 18 19 20 21 22 23 Q. I am proposing a flat monthy charge of $50.00 for all residential customers curently receiving service and an availabilty charge of$25.00 for all other residential customers who are not receiving servce. This wil result in a significant reduction from curent monthy residential rates which are now $80.00 per month for residential customers receiving service. For commercial serice, I am proposing a flat monthly charge of $l50.00 for all commercial customers curently receiving servce and an availability charge of$75.00 for all other commercial customers who are not receiving servce. As described by Mr. Pinardi, commercial service is provided by facilties that supply thee times the level of serice of residential customers. For this reason I have proposed commercial rates that are thee times higher than residential serce. Finally, for multifamily customers, which are predominately residential customers, I am proposing the same flat monthy residential rate of$50.00 per month. There are no inactive customers in this class of serice so there is no availability charge proposed for ths class of serce. Why is the Company proposing availabilty rates? The use of an availabilty charge wil allow the Company to recover all of its fixed costs and eliminate the penalties that would otherise be assessed to the active customers who would be payig all the fixed costs of the system. The availabilty charge allows the Company to recover a portion of its costs in recogntion that the water system is in place and available to serce to all lots and locations contained in the development. Does this conclude your direct testimony in ths proceeding? Crowley, Di 16 Teton Springs Water and Sewer Company LLC 1 A.Yes it does. Crowley, Di 17 Teton Sprigs Water and Sewer Company LLC Larry A. Crowley, President and Director The Energy Strategies Institute, Inc. APPENDIX A - PROFESSIONAL EXPERIENCE I have 30 years of senior-level utilty operating, planning and regulatory experience. My regulatory experience includes the preparation of exhibits and testimony for jurisdictional separation and revenue requirement studies, class cost of service studies, unbundled cost studies, and rate design studies for filng before various regulatory commissions. I have appeared as an expert witness before the Idaho Public Utilties Commission, the Oregon Public Utilties Commission, the Nevada Public Service Commission, the Colorado Public Utilties Commission, the Wisconsin Public Utilties Commission, the Michigan Public Service Commission, the North Dakota Public Service Commission, the Montana Public Service Commission, the Texas Public Utilty Commission, the Pennsylvania Public Utilty Commission, and the Federal Energy Regulatory Commission. My principal clients include Wisconsin Elecric Power Company, Milwaukee, Wisconsin; Montana-Dakota Utilties Company, Bismarck, North Dakota; Duquesne Light Company, Pittsburgh, PA; The US Department of Energy, Offce of Renewable Energy and Energy Efficiency, Washington, D.C.; The Washington Group International, Boise, Idaho; The J.R. Simplot Company, Boise, Idaho; Riley Creek Lumber Company, Hayden, Idaho; United Electric Co-op, Heyburn, Idaho; Eagle Water Company, Eagle, Idaho; Sithe Global Power, LLC, Houston, TX; Idaho Power Company, Boise, Idaho; The Electric Department of the City of Weiser, Idaho; The International Energy Agency, Paris, France; The World Bank, Washington, DC; The Solar Electric Power Association, Washington, DC; and the German Development Bank, (KfW), Berlin, Germany. The Energy Strategies Institute, Inc. Present October 1999 to Founder and Director of a consulting company and network of experienced professionals with diverse interests specializing in energy and utilty rate and regulatory matters, dedicated to developing and implementing practical solutions for energy service providers and customers. The Institute provides regulatory and litigation support, industry restructuring support including economic and financial analysis, and business and organizational development analysis and implementation support. The Institute also offers assistance and faciltation with energy and utilty strategic planning initiatives, resource planning studies, and strategic, financial and feasibilty studies for mergers and acquisitions. The Institute delivers value through the application of senior-level industry experience and a team-based philosophy that result in the development and transfer of knowledge to its clients. Idaho Power Resources Corporation July 1996 to October 1999 A wholly owned subsidiary of Idaho Power Company, responsible for developing domestic and international non-regulated business initiatives to provide future revenue and earnings growth. President Established, organized and led a new independent business division including establishment of the entity, selection and training of staff, systems implementation and day-to-day management of the entity. The entity consisted of eight engineers, economists and technologists. I was also responsible for $3.5 millon annual operating budget for preparation of strategic plans, business plans including due dilgence and analysis for mergers and acquisitions, and research, development and deployment Ex 4 PAC 1 01'' of new technologies such as PEM fuel cells and solar energy systems. · Developed extensive business plans for energy-related projecs in Brazil, Argentina, Peru and Indonesia, including acquisitions of operating electric distribution systems, new and existing hydroelecric generating project, information and communication technologies, and the application of renewable energy technologies in remote areas of developing countries. Plan formulation was accomplished by identification of specific and unique market opportunities through personal contact and research. · Marketed the capabilties of Idaho Power Company and its subsidiaries to various South American entities resulting in first year sales of $4.5 milion. · Responsible for formulating strategies and directing the due dilgence related to the acquisition of various unregulated subsidiaries with annual revenues in excess of $18.0 milion. · Negotiated a Memorandum of Understanding with the Ministry of Energy of Brazil to examine the possibilties of developing large-scale electrification projects in the remote areas of BraziL. . Negotiated an exclusive Memorandum of Understanding with the Government of Indonesia for the provision of energy services in the remote areas of Indonesia under the jurisdiction of the Ministry of Transmigration. . Participated in a number of high-level trade missions to South America representing domestic energy interests. These trips to Brazil, Argentina, Bolivia and Peru were sponsored by the US Agency for International Development and other industry-specific trade associations such as the US National Hydropower Association and the US Export Council for Renewable Energy. Honors · Invited by the Minister of Energy of Brazil to attend the first annual conference held in Brazil on renewable energy and energy efficiency and to participate as a panelist at that conference. · Co-hosted the 1997 Renewable Energy in the Americas Conference (REIA 97) with the Minister of Energy of Brazil. This conference was held in Rio de Janeiro in July 1997 and attended by over 350 senior representatives for North, Central and South American energy companies, utilties, government agencies, NGOs and multilateral financing organizations. . Invited by the US Department of Energy and then-Secretary of Energy Hazel O'Leary to participate as a panelist/presenter at the Second Annual Meeting of the Energy Ministers of the Western Hemisphere - August 1997. . Invited to travel with US Secretary of Commerce (Daley) as a member of a trade mission to Brazil, Argentina and Chile - May 1997. . Invited to travel with the US Secretary of Energy (Pena) to the Third Annual Meeting of the Energy Ministers of the Western Hemisphere held in Caracas, Venezuela in January 1998, and to participate on various discussion panels during the conference. · Invited to participate at a number of international renewable energy conferences hosted by The World Bank and the US Agency for International Development. Idaho Power Company March 1979 to Octber 1999 Idaho Power Company is the largest investor-owned electric utilty serving in Idaho with 2004 revenues of $844.5 millon, total plant investment of approximately $3.2 billion and over 440,000 customers. Senior Manager, Strategic Planning January 1991 to October 1999 As Senior Manager of Strategic Planning, I reported directly to the Chairman of the Board and CEO of the company. I was responsible for direcing all corporate strategic planning activities of the company, including regulatory initiatives and merger and acquisition activities. I was responsible for the preparation of the annual economic forecast used by the major business units of the company in the preparation of their annual business plans, operating budgets and capital requirements. I was also responsible for overseeing the company's research and development programs and projecs 2 i: .. PAG 2 OF" dealing with new technologies or improvements in operating practices. · Developed a rate mechanism that tracks and recovers changes or fluctuations in the company's cost of production (PCA), including formulation of the concept, plan and the regulatory strategy to secure approval of the regulatory commissions having jurisdiction over the company. . Directed the litigation team that participated in the PacifiCorp/Utah Power merger appearing before the Idaho PUC and the Federal Energy Regulatory Commission. Negotiated the settlement agreement between the parties, resulting in significant benefits to Idaho Power Company including firm transmission service in Utah, ownership of a major strategic substation, additional transmission revenue and favorable resolution of a number of pending regulatory disputes. · Negotiated a comprehensive transmission services agreement between the company and Bonnevile Power Administration that resulted in annual revenues of approximately $1.5 milion. . Identified new business opportunities for the company and prepared the requisite business plans and analysis. Honors . Recognized for developing Idaho Power Company's innovative "first-of-its-kind" solar energy program that won unanimous approval from the regulatory commissions. This effort established Idaho Power as a domestic and international leader with renewable energy technologies. · Selected by the lEA Executive Committee to chair the Organizing Committee for the highly acclaimed 1995 International Executive Conference on Photovoltaics (Solar Energy) sponsored by the International Energy Agency and hosted by Idaho Power Company. · Selected by the US Department of Energy to represent the United States on the Organizing Committee for the 1999 International Executive Conference on Photovoltaics that was organized under the auspices of the International Energy Agency. Manager, Power Management 1986 to 1991 . Responsible for the management of a department consisting of 45 senior level engineers, analysts and technical experts dealing with generation resource planning, transmission system planning, wholesale power marketing and wholesale bilateral contract development and administration. · Responsible for directing all regulatory activities with the Federal Energy Regulatory Commission dealing with wholesale power and transmission services rates, terms and conditions and related contract approvals. . Responsible for negotiating wholesale power contract and transmission service agreements that generated $40MM in annual revenues and rates of return for Idaho Power exceeding the average ROR for the company by 500 to 600 basis points. Manager of Rates and Regulatory Affairs 1979 to 1986 · Responsible for preparing all materials required for the company's rate filings before the Idaho, Oregon and Nevada state regulatory commissions having jurisdiction over the company, as well as the Federal Energy Regulatory Commission. . Developed a multi-jurisdictional cost-of-service/revenue requirements model that was accepted by all state and federal commissions having jurisdiction over the company. . Developed a series of innovative class cost of service and rate design models. · Developed and directed a load research program for the company. Wisconsin Electric Power Company 1978 to 1979 Projec Coordinator, Rate Department I was responsible for all rate and regulatory filings before the Wisconsin and Michigan Public Utilty Commissions and the Federal Energy Regulatory Commission. These activities included preparing jurisdictional separation and revenue requirement studies, cost-of-service studies, rate design studies, load research information and the testimony related to these studies as required by the commissions 3 Ex 4 PAG 3 cw 4 ( in support of retail and wholesale rate filings. I developed the first computerized cost-of-service model for the company that was accepted by all three commissions having jurisdiction over the company. Southeast Colorado Power Association 1971 to 1978 General Manager I was the Chief Operating Offcer of an electric distribution cooperative with 50 employees. Responsible to the Board of Directors for all matters relating to the operation of the cooperative including financial planning, marketing, budgeting, quality of service and all regulatory proceedings before the Colorado Public Utilties Commission. EDUCATION Bachelor of Science - Economics, University of Mary/anCL College Park, Maryland LANGUAGE SKILLS Fluent in Spanish, (FSI rating of 4) and conversational in Portuguese CONTACT INFORMATION Larry A Crowley, President & Director The Energy Strategies Institute, Inc. 5549 S Cliffsege Avenue Boise, ID 83716 Phone: (208) 344-5459 Fax: (208) 345-2424 Mobile: (208) 890- 1871 E-mail: crowleyla(âaol.com 4 t: 4 'AG4 01 4 Teton Springs Water & Sewer Before The Idaho Public Utilities Commission Exhibit No 5 Operating Income Pro Forma at Present and Proposed Rates 12 Months Ending December 31, 2007 - Adjusted Table No 1 Earned Rate of Return with Additional Revenue Requirements (1)(2)(3)ROR Before Proposed ROR With Line Additional Additional Additional-!Description Revenues Revenues Revenues Total Water Rate Base (50,993)(50,993) Total Operating Revenues: 2 Total Unmetered Water Revenues 198,827 99,256 298,082 3 Other Sales or Adjustments 1,970 1,970 4 Other Operating Revenues 45,200 45,200 5 Total Revenues 245,996 99,256 345,252 Total Operating Expenses: 6 Operation & Maintenance Expenses 192,210 249 192,459 7 Depreciation Expense 3,091 3,091 8 Amortization Expense 89,140 89,140 9 Taxes Other Than Income Taxes 726 726 10 Total Operating Expenses 285,166 249 285,415 11 Utility Operating Income Before Taxes (39,170)99,007 59,837 Income Taxes: 12 Federal 32,608 32,608 13 State 5,841 5,841 14 Total Operating Expenses 285,166 38,698 323,864 15 Total Operating Income (Losses) - $(39,170)60,558 21,387 Page 1 of 3 Exæm 5 PAG i Of 3 Teton Springs Water & Sewer Before The Idaho Public Utilities Commission Exhibit No 5 Operating Income Pro Forma at Present and Proposed Rates 12 Months Ending December 31, 2007 - Adjusted Table No 2 Determination of Jurisdictional Revenue Deficiency (1)(2)(3) Line Total Total ID COSS~Description Utility Jurisdiction Reference Total Utility Rate Base - Adjusted $(79,289)$(50,993)Table No 1 Total Operating Revenues 2 Total Sales Revenues 434,985 198,827 Table No 5 3 Other Sales or Adjustments 3,939 1,970 Table No 5 4 Other Operating Revenues 45,200 45,200 Table No 5 5 Total Revenues 484,124 245,996 Total Operating Expenses 6 Operation & Maintenance Expenses 436,702 192,210 Table No 6 7 Depreciation Expense 61,736 3,091 Table No 7 8 Amortization Expense 89,140 89,140 Table No 7 9 Taxes Other Than Income Taxes 726 726 Table No 7 10 Total Operating Expenses 588,303 285,166 11 Utility Operating Income Before Taxes (104,179)(39,170)Income Taxes: 12 Federal Table Nos 7/8 13 State Table Nos 7/8 14 Total Operating Expenses 588,303 285,166 15 Total Operating Income (104,179)(39,170) Revenue Deficiency & Requirements 16 Income Deficiency (Line 15)39,170 17 Operating Margin Requirements - 7.5% of Total Oper Exps 21,387 18 Total Income Deficiency 60,558 19 Net-to-Gross Multiplier 1.6390 20 Revenue Deficiency - $ (Line 18*Line 19)$99,256 21 Revenue Deficiency - % (Line 20/Line 2)49.92% 22 Total Revenue Requirements - $ (Line 5 + Line 20)345,252 23 Less Other Operating Revenues (Lines 3 + 4)47,170 24 Revenue Requirements From Water Sales $298,082 Page 2 of 3 Exæ.iS P4G201' Teton Springs Water & Sewer Before The Idaho Public Utilities Commission Exhibit No 5 Operating Income Pro Forma at Present and Proposed Rates 12 Months Ending December 31, 2007 - Adjusted Table No 3 Water Utility Rate Base - Idaho (1)(2)(3) Line Total Total ID COSS.J Description Utility Jurisdiction Reference Utility Plant in Service - Account 101: 1 Water Plant in Service - Total 3,176,409 3,176,409 Table No 1 2 Sewer Utility in Plant - Total 2,783,660 Table No 1 3 Total Utility Plant in Service 5,960,069 3,176,409 4 Net Correcting Adjustment to Utilty Plant in Service - Water 12,363 12,363 Table No 1 5 Adjusted Total Utilty Plant in Service 5,972,432 3,188,772 Less: 6 Contributions in Aid of Construction (CIAC) - 271 (5,960,069)(3,176,409)Table No 1 7 Correcting Adjustment to Contributions in Aid of Construction 8 Adjusted Total Contributions in Aid of Construction (5,960,069)(3,176,409) 9 Subtotal of Investor Owned Assets for Rate Base 12,363 12,363 Table No 1 10 Less: Accumulated Provision for Depreciation 11 Correcting Adjustment to Accumulated Provision for Depreciation 1,545 1,545 Table No 1 12 Adjusted Total Accumulated Provision for Depreciation 1,545 1,545 13 Less: Accumulated Amortization of CIAC - 272 147,785 89,140 Table No 1 14 Correcting Adjustment to Accumulated Amortization of CIAC 15 Adjusted Total Accumulated Amortization of CIAC 147,785 89,140 16 Total Accumulated Depreciation Net of Accumulated Amort of CIAC 146,240 87,595 17 Net Plant in Service (133,877)(75,232)Working Capital: 18 1/8 O&M Expenses - Water 24,238 24,238 Table No 1 19 1/8 O&M Expenses - Sewer 30,349 20 Total Utilty Rate Base (79,289)(50,993) Page 3 of 3 Ex 5 PAG 3 or 3 Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Lin e Al l o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Ut i l t y P l a n t i n s e r v i c e - A c c o u n t 1 0 1 : 1 Wa t e r P l a n t i n S e r v i c e - T o t a l Ta b l e N o 3 3,1 7 6 , 4 0 9 3, 1 7 6 , 4 0 9 3, 1 7 6 , 4 0 9 2 Se w e r U t i l i t y i n P l a n t - T o t a l Ta b l e N o 3 2,7 8 3 , 6 6 0 2, 7 8 3 , 6 6 0 2,7 8 3 , 6 6 0 3 To t a l U t i l i t y P l a n t i n S e r v i c e 5,9 6 0 , 0 6 9 5, 9 6 0 , 0 6 9 2,7 8 3 , 6 6 0 3, 1 7 6 , 4 0 9 4 Ne t C o r r e c t i n g A d j u s t m e n t t o U t i l t y P l a n t i n S e r v i c e - W a t e r 12 , 3 6 3 12 , 3 6 3 12 , 3 6 3 5 Ad j u s t e d T o t a l U t i l i t y P l a n t i n S e r v i c e 5,9 7 2 , 4 3 2 5, 9 7 2 , 4 3 2 2,7 8 3 , 6 6 0 3, 1 8 8 , 7 7 2 Le s s : 6 Co n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n ( C I A C ) - 2 7 1 Ta b l e N o 4 (5 , 9 6 0 , 0 6 9 ) (5 , 9 6 0 , 0 6 9 ) (2 , 7 8 3 , 6 6 0 ) (3 , 1 7 6 , 4 0 9 ) 7 Co r r e c t i n g A d j u s t m e n t t o C o n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n 8 Ad j u s t e d T o t a l C o n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n (5 , 9 6 0 , 0 6 9 ) (5 , 9 6 0 , 0 6 9 ) (2 , 7 8 3 , 6 6 0 ) (3 , 1 7 6 , 4 0 9 ) 9 Su b t o t a l o f I n v e s t o r O w n e d A s s e t s f o r R a t e B a s e Lin e 5 - L i n e 8 12 , 3 6 3 12 , 3 6 3 12 , 3 6 3 10 Le s s : A c c u m u l a t e d P r o v i s i o n f o r D e p r e c i a t i o n Ta b l e N o 4 11 Co r r e c t i n g A d j u s t m e n t t o A c c u m u l a t e d P r o v i s i o n f o r D e p r e c i a t i o n 1, 5 4 5 1,5 4 5 1,5 4 5 12 Ad j u s t e d T o t a l A c c u m u l a t e d P r o v i s i o n f o r D e p r e c i a t i o n 1, 5 4 5 1,5 4 5 1,5 4 5 13 Le s s : A c c u m u l a t e d A m o r t i z a t i o n o f C I A C - 2 7 2 Ta b l e N o 4 14 7 , 7 8 5 14 7 , 7 8 5 58 , 6 4 5 89 , 1 4 0 14 Co r r e c t i n g A d j u s t m e n t t o A c c u m u l a t e d A m o r t i z a t i o n o f C I A C 15 Ad j u s t e d T o t a l A c c u m u l a t e d A m o r t i z a t i o n o f C I A C 14 7 , 7 8 5 14 7 , 7 8 5 58 , 6 4 5 89 , 1 4 0 16 To t a l A c c u m u l a t e d D e p r e c i a t i o n N e t o f A c c u m u l a t e d A m o r t o f C I A C Li n e 1 2 - L i n e 1 5 (1 4 6 , 2 4 0 ) (1 4 6 , 2 4 0 ) (5 8 , 6 4 5 ) (8 7 , 5 9 5 ) 17 Ne t P l a n t i n S e r v i c e Li n e 9 + L i n e 1 6 12 , 3 6 3 (1 4 6 , 2 4 0 ) (1 3 3 , 8 7 7 ) (5 8 , 6 4 5 ) (7 5 , 2 3 2 ) Wo r k i n g C a p i t a l : 18 1/ 8 O & M E x p e n s e s - W a t e r Ta b l e N o 6 21 , 9 4 9 2, 2 8 9 24 , 2 3 8 24 , 2 3 8 19 1/8 O & M E x p e n s e s - S e w e r Ta b l e N o 6 39 , 6 5 5 (9 , 3 0 6 ) 30 , 3 4 9 30 , 3 4 9 20 To t a l U t i l t y R a t e B a s e $ 73 , 9 6 7 (1 5 3 , 2 5 7 ) (7 9 , 2 8 9 ) (2 8 , 2 9 6 ) (5 0 , 9 9 3 ) Pa g e 1 o f 1 0 Ex H i i a r 6 PA G 1 0 1 1 ' Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Al l o c a t i o n To t a l U t i l t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Co s t o f S e r v i c e l i R e v e n u e R e q u i r e m e n t s To t a l R a t e B a s e I n c l u d i n g C W I P Ta b l e N o 1 73 , 9 6 7 (1 5 3 , 2 5 7 ) (7 9 , 2 8 9 ) (2 8 , 2 9 6 ) (5 0 , 9 9 3 ) Re v e n u e a n d E x p e n s e s a t t h e R e q u i r e d R a t e o f R e t u r n 2 Un m e t e r e d W a t e r S a l e s - R e s i d e n t i a l - 4 6 0 , 1 Ta b l e N o 5 17 0 , 4 0 0 15 , 8 4 0 18 6 , 2 4 0 18 6 , 2 4 0 3 Un m e t e r e d W a t e r S a l e s - C o m m e r c i a l - 4 6 0 . 2 Ta b l e N o 5 4, 8 0 0 4, 8 0 0 4, 8 0 0 4 Un m e t e r e d W a t e r S a l e s - M u l t i - f a m i l y U n i t s - 4 6 0 . 5 Ta b l e N o 5 7, 7 8 7 7, 7 8 7 7, 7 8 7 5 Oth e r S a l e s o r A d j u s t m e n t s - 4 6 0 . 6 Ta b l e N o 5 37 4 (3 7 4 ) 6 Ot h e r O p e r a t i n g W a t e r R e v e n u e s - 4 6 2 / 4 7 4 Ta b l e N o 5 45 . 2 0 0 45 , 2 0 0 45 , 2 0 0 7 To t a l W a t e r S a l e s R e v e n u e s 22 0 , 7 7 4 23 , 2 5 3 24 4 , 0 2 7 24 4 , 0 2 7 8 Oth e r O p e r a t i n g R e v e n u e s - 4 1 9 . 1 / 2 Ta b l e N o 5 3, 9 3 9 3, 9 3 9 1, 9 7 0 1,9 7 0 9 To t a l S e w e r R e v e n u e s Ta b l e N o 5 23 6 , 1 5 8 23 6 , 1 5 8 23 6 . 1 5 8 10 To t a l U t i l t y O p e r a t i n g R e v e n u e s 46 0 , 8 7 1 23 , 2 5 3 48 4 , 1 2 4 23 8 , 1 2 8 24 5 , 9 9 6 Op e r a t i n g E x p e n s e s : 11 Op e r a t i o n & M a i n t e n a n c e E x p e n s e s Ta b l e N o 6 49 2 , 8 3 5 (5 6 , 1 3 3 ) 43 6 , 7 0 2 24 4 , 4 9 2 19 2 , 2 1 0 12 De p r e c i a t i o n / A m o r t i z a t i o n E x p e n s e - W a t e r Ta b l e N o 7 3, 0 9 1 3, 0 9 1 3, 0 9 1 13 De p r e c i a t i o n / A m o r t i z a t i o n E x p e n s e - S e w e r / W a t e r Ta b l e N o 7 14 7 , 7 8 5 14 7 , 7 8 5 58 , 6 4 5 89 , 1 4 0 14 Ta x e s O t h e r T h a n I n c o m e T a x e s Ta b l e N o 7 10 9 61 7 72 6 72 6 15 To t a l O p e r a t i n g E x p e n s e s 49 6 , 0 3 5 92 , 2 6 9 58 8 , 3 0 3 30 3 , 1 3 7 28 5 , 1 6 6 16 Op e r a t i n g I n c o m e T a x e s B e f o r e I n c o m e T a x e s (3 5 , 1 6 4 ) (6 9 , 0 1 6 ) (1 0 4 , 1 7 9 ) (6 5 , 0 0 9 ) (3 9 , 1 7 0 ) In c o m e T a x e s : 17 Fe d e r a l T a x e s Ta b l e N o 7 18 St a t e T a x e s Ta b l e N o 7 19 To t a l O p e r a t i n g E x p e n s e s 49 6 , 0 3 5 92 , 2 6 9 58 8 , 3 0 3 30 3 , 1 3 7 28 5 , 1 6 6 20 Ne t O p e r a t i n g I n c o m e ( L o s s e s ) (3 5 , 1 6 4 ) (6 9 , 0 1 6 ) (1 0 4 , 1 7 9 ) (6 5 , 0 0 9 ) (3 9 , 1 7 0 ) Re v e n u e D e f i c i e n c y l i R e q u i r e m e n t s 21 In c o m e D e f i c i e n c y ( L i n e 2 0 ) 35 , 1 6 4 69 , 0 1 6 10 4 , 1 7 9 65 , 0 0 9 39 , 1 7 0 22 Op e r a t i n g M a r g i n R e q u i r e m e n t s - 7 , 5 % o f T o t a l O p e r a t i n g E x p e n s e s 7, 5 0 % 44 . 1 2 3 22 , 7 3 5 21 . 3 8 7 23 To t a l I n c o m e D e f i c i e n c y 14 8 , 3 0 2 87 , 7 4 5 60 , 5 5 8 24 Ne t - t o - G r o s s M u l t i p l i e r Ex h i b i t N o L A C - 5 1. 6 3 9 0 1.6 3 9 0 1. 6 3 9 0 25 Re v e n u e D e f i c i e n c y - $ ( L i n e 2 3 * L i n e 2 4 ; 24 3 , 0 7 2 14 3 , 8 1 6 99 , 2 5 6 26 Re v e n u e D e f i c i e n c y - % ( L i n e 2 5 / ( L i n e s 2 , 3 + 4 ) ) 50 . 2 1 % 60 3 9 % 49 , 9 2 % 27 To t a l R e v e n u e R e q u i r e m e n t s - $ ( L i n e 1 0 + L i n e 2 5 ) $ 72 7 , 1 9 6 $ 38 1 , 9 4 4 $ 34 5 , 2 5 2 28 Le s s O t h e r O p e r a t i n g R e v e n u e s ( L i n e s 6 + L i n e 8 ) (4 7 , 1 7 0 ) 29 Re v e n u e R e q u i r e m e n t s F r o m W a t e r S a l e s $ 29 8 , 0 8 2 Pa g e 2 o f 1 0 EX H l a I 6 PA G i 0 1 1 . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l i t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Lin e All o c a t i o n To t a l U t i l t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Wa t e r P l a n t i n S e r v i c e ( 1 ) : In t a n g i b l e P l a n t - 3 0 1 / 3 0 3 1 Or g a n i z a t i o n - 3 0 1 ( * ) 2 Fr a n c h i s e s & C o n s e n t s - 3 0 2 ( * ) 3 La n d & l a n d R i g h t s - 3 0 3 ( * * ) 4 To t a l I n t a n g i b l e P l a n t Su p p l y l i T r e a t m e n t - 3 0 4 / 3 2 0 5 St r u c t u r e s & I m p r o v e m e n t s - 3 0 4 DA 3, 4 5 5 3, 4 5 5 3, 4 5 5 6 Co l l e c t i n g & I m p o u n d i n g R e s e r v o i r s - 3 0 5 DA 7 La k e , R i v e r & O t h e r I n t a k e s - 3 0 6 DA 8 We l l s - 3 0 7 DA 23 6 , 9 3 6 23 6 , 9 3 6 23 6 , 9 3 6 9 In f i l t r a t i o n G a l l e r i e s & T u n n e l s - 3 0 E DA 10 Su p p l y M a i n s - 3 0 9 DA 1, 5 1 9 , 7 2 2 1,5 1 9 , 7 2 2 1,5 1 9 , 7 2 2 11 Po w e r G e n e r a t i o n E q u i p m e n t - 3 1 0 DA 12 Po w e r P u m p i n g E q u i p m e n t - 3 1 1 DA 13 , 9 6 0 13 , 9 6 0 13 , 9 6 0 13 Pu r i f i c a t i o n S y s t e m s - 3 2 0 DA 14 To t a l S u p p l y & T r e a t m e n t P l a n t 1, 7 7 4 , 0 7 4 1,7 7 4 , 0 7 4 1, 7 7 4 , 0 7 4 Tr a n s p o r t t i o n l i D i s t r i b u t i o n P l a n t - 3 3 0 / 3 3 9 15 Dis t r i b u t i o n R e s e r v o i r s & S t a n d p i p e s - 3 3 0 DA 36 4 , 2 5 6 36 4 , 2 5 6 36 4 , 2 5 6 16 Tr a n s & D i s t M a i n s & A c c e s s o r i e s - 3 3 1 DA 57 9 , 9 3 0 57 9 , 9 3 0 57 9 , 9 3 0 17 Se r v i c e s - 3 3 3 DA 18 Me t e r s & M e t e r I n s t a l l a t i o n s - 3 3 4 DA 19 Hy d r a n t s - 3 3 5 DA 17 9 , 9 5 6 17 9 , 9 5 6 17 9 , 9 5 6 20 Ba c k f l o w P r e v e n t i o n D e v i c e s . 3 3 6 DA 21 Ot h e r P l a n t & M i s c e l l a n e o u s E q u i p m e n t - 3 3 9 DA 22 To t a l T r a n s m i s s i o n & D i s t r i b u t i o n P l a n t 1, 1 2 4 , 1 4 1 1,1 2 4 , 1 4 1 1,1 2 4 , 1 4 1 No t e s : (* ) A m o r t i z a b l e (* * ) N o n d e p r e c i a b l e Pa g e 3 o f 1 0 Ex l 1 l 6 PA G 3 0 1 1 . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Al l o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d -- De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Ge n e r a i P l a n t - 3 4 0 / 3 4 8 1 Of f c e F u r n i t u r e & E q u i p m e n t - 3 4 0 DA 2 Tr a n s p o r t a t i o n E q u i p m e n t - 3 4 1 DA 3 Sto r e s E q u i p m e n t - 3 4 2 DA 4 To o l s , S h o p & G a r a g e E q u i p m e n t - 3 4 3 DA 5 La b o r a t o r y E q u i p m e n t - 3 4 4 DA 6 Po w e r O p e r a t e d E q u i p m e n t - 3 4 5 DA 7 Co m m u n i c a t i o n s E q u i p m e n t - 3 4 6 DA 8 Mi s c e l l a n e o u s E q u i p m e n t - 3 4 7 DA 9 Ot h e r I n t a n g i b l e E q u i p m e n t - 3 4 8 DA 27 8 , 1 9 4 27 8 . 1 9 4 27 8 . 1 9 4 10 To t a l G e n e r a l P l a n t 27 8 , 1 9 4 27 8 , 1 9 4 27 8 , 1 9 4 11 To t a l W a t e r U t i l t y P l a n t I n S e r v i c e $ 3, 1 7 6 , 4 0 9 $ $ 3,1 7 6 , 4 0 9 $ $ 3, 1 7 6 , 4 0 9 Se w e r P l a n t i n S e r v i c e ( 2 ) , 12 Pr e s s u r e S e w e r s , F o r c e M a i n s DA 17 9 , 4 4 6 17 9 , 4 4 6 17 9 , 4 4 6 13 Gr a v i t y M a i n s DA 90 3 , 3 8 8 90 3 , 3 8 8 90 3 , 3 8 8 14 Ma n h o l e s DA 55 9 , 2 6 6 55 9 , 2 6 6 55 9 , 2 6 6 15 Lif t S t a t i o n s DA 39 8 , 7 4 4 39 8 , 7 4 4 39 8 , 7 4 4 16 Se r v i c e L i n e s DA 49 7 , 9 1 5 49 7 , 9 1 5 49 7 , 9 1 5 17 En g i n e e r i n g S e r v i c e s DA 24 4 . 9 0 1 24 4 , 9 0 1 24 4 , 9 0 1 18 To t a l S e w e r U t i l t y P l a n t I n S e r v i c e $ 2, 7 8 3 , 6 6 0 $ $ 2,7 8 3 , 6 6 0 $ 2, 7 8 3 , 6 6 0 19 To t a l W a t e r . S e w e r P l a n t i n S e r v i c e $ 5, 9 6 0 , 0 6 9 $ $ 5, 9 6 0 , 0 6 9 No t e s : (1 ) P e r R e v i s e d A p p e n d i x A - C H 2 M H i l i (2 ) P e r R e v i s e d A p p e n d i x B - C H 2 M H i l i Pa g e 4 o f 1 0 EX H l a i ' P A G E 4 O F i . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Lin e All o c a t i o n To t a i U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad i u s t m e n t s Ad j u s t e d Se w e r Wa t e r Wa t e r P l a n t - A c c u m u l a t e d P r o v i s i o n ( 1 ) : In t a n g i b l e P l a n t - 3 0 1 / 3 0 3 1 Or g a n i z a t i o n - 3 0 1 2 Fr a n c h i s e s & C o n s e n t s - 3 0 2 3 La n d & l a n d R i g h t s - 3 0 3 4 To t a l I n t a n g i b l e P l a n t Su p p l y & T r e a t m e n t - 3 0 4 / 3 2 0 5 St r u c t u r e s & I m p r o v e m e n t s - 3 0 4 DA 26 2 26 2 26 2 6 Co l l e c t i n g & I m p o u n d i n g R e s e r v o i r s - 3 0 5 DA 7 La k e , R i v e r & O t h e r I n t a k e s - 3 0 6 DA 8 We l l s - 3 0 7 DA 23 , 4 5 4 23 , 4 5 4 23 , 4 5 4 9 In f i l t r a t i o n G a l l e r i e s & T u n n e l s - 3 0 E DA 10 Su p p l y M a i n s - 3 0 9 DA 22 7 , 9 3 3 22 7 , 9 3 3 22 7 , 9 3 3 11 Po w e r G e n e r a t i o n E q u i p m e n t - 3 1 0 DA 12 Po w e r P u m p i n g E q u i p m e n t - 3 1 1 DA 4, 2 1 7 4, 2 1 7 4, 2 1 7 13 Pu r i f i c a t i o n S y s t e m s - 3 2 0 DA 14 To t a l S u p p l y & T r e a t m e n t P i a n t 25 5 , 8 6 6 25 5 , 8 6 6 25 5 , 8 6 6 Tr a n s p o r t t i o n & D i s t r i b u t i o n P l a n t - 3 3 0 / 3 3 9 15 Dis t r i b u t i o n R e s e r v o i r s & S t a n d p i p e s - 3 3 0 DA 36 , 0 5 8 36 , 0 5 8 36 , 0 5 8 16 Tr a n s & D i s t M a i n s & A c c e s s o r i e s - 3 3 1 DA 58 , 9 6 4 58 , 9 6 4 58 , 9 6 4 17 Se r v i c e s - 3 3 3 DA 18 Me t e r s & M e t e r I n s t a l l a t i o n s - 3 3 4 DA 19 Hy d r a n t s - 3 3 5 DA 18 , 2 7 7 18 , 2 7 7 18 , 2 7 7 20 Ba c k f i o w P r e v e n t i o n D e v i c e s - 3 3 6 DA 21 Ot h e r P l a n t & M i s c e l l a n e o u s E q u i p m e n t - 3 3 9 DA 22 To t a l T r a n s m i s s i o n & D i s t r i b u t i o n P l a n t 11 3 , 2 9 9 11 3 , 2 9 9 11 3 , 2 9 9 Pa g e 5 o f 1 0 "" Ex 8 l Y ' PM Z 5 0 r l l Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Al l o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Ge n e r a l P l a n t - 3 4 0 / 3 4 8 1 Of f c e F u r n i t u r e & E q u i p m e n t - 3 4 0 2 Tr a n s p o r t a t i o n E q u i p m e n t - 3 4 1 3 Sto r e s E q u i p m e n t - 3 4 2 4 To o l s , S h o p & G a r a g e E q u i p m e n t - 3 4 3 5 La b o r a t o r y E q u i p m e n t - 3 4 4 6 Po w e r O p e r a t e d E q u i p m e n t - 3 4 5 7 Co m m u n i c a t i o n s E q u i p m e n t - 3 4 6 8 Mi s c e l l a n e o u s E q u i p m e n t - 3 4 7 9 Ot h e r I n t a n g i b l e E q u i p m e n t - 3 4 8 10 To t a l G e n e r a l P l a n t 11 To t a i A c c u m u l a t e d P r o v i s i o n f o r D e p r e c i a t i o n - W a t e r 36 9 , 1 6 5 36 9 , 1 6 5 36 9 , 1 6 5 Se w e r P l a n t i n S e r v i c e ( 2 ) : 12 Pr e s s u r e S e w e r s , F o r c e M a i n s DA 20 , 8 9 4 20 , 8 9 4 20 , 8 9 4 13 Gr a v i t y M a i n s DA 11 4 , 7 8 7 11 4 , 7 8 7 11 4 , 7 8 7 14 Ma n h o l e s DA 52 , 1 9 6 52 , 1 9 6 52 , 1 9 6 15 Lif t S t a t i o n s DA 33 , 8 4 4 33 , 8 4 4 33 , 8 4 4 16 Se r v i c e L i n e s DA 56 , 1 0 7 56 , 1 0 7 56 , 1 0 7 17 En g i n e e r i n g S e r v i c e s DA 18 To t a l A c c u m u l a t e d P r o v i s i o n f o r D e p r e c i a t i o n - S e w e r 27 7 , 8 2 8 27 7 , 8 2 8 27 7 , 8 2 8 19 To t a l U t i l t y A c c u m u l a t e d P r o v i s i o n f o r D e p r e c i a t i o n 64 6 , 9 9 3 64 6 , 9 9 3 No t e s : (1 ) P e r R e v i s e d A p p e n d i x A - C H 2 M H i l l (2 ) P e r R e v i s e d A p p e n d i x B - C H 2 M H i l i Pa g e 6 o f 1 0 EX H I M T ' PA G E ' O t 1 . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Un e Al l o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d -- De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Wa t e r R e v e n u e s - 4 6 0 / 4 7 4 Un me t e r e d W a t e r R e v e n u e - 4 6 0 1 Sa l e s t o R e s i d e n t i a l C u s t o m e r s - 4 6 0 , 1 Dir e c t A s s i g n 17 0 , 4 0 0 15 , 8 4 0 18 6 , 2 4 0 18 6 , 2 4 0 2 Sa l e s t o C o m m e r c i a l C u s t o m e r s - 4 6 0 , 2 Dir e c t A s s i g n 4,8 0 0 4, 8 0 0 4,8 0 0 3 Sa l e s t o I n d u s t r i a l C u s t o m e r s - 4 6 0 . 3 4 Sa l e s t o P u b l i c A u t h o r i t i e s - 4 6 0 - 4 5 Sa l e s t o M u l t i p l e F a m i l y D w e l l i n g s - 4 6 0 . 5 Dir e c t A s s i g n 7,7 8 7 7, 7 8 7 7,7 8 7 6 Ot h e r S a l e s o r A d j u s t m e n t s - 4 6 0 . 6 Dir e c t A s s i g n 37 4 (3 7 4 ) 7 To t a l U n m e t e r e d W a t e r R e v e n u e s 17 5 , 5 7 4 23 , 2 5 3 19 8 , 8 2 7 19 8 , 8 2 7 Me t e r e d W a t e r R e v e n u e - 4 6 1 8 Sa l e s t o R e s i d e n t i a l C u s t o m e r s - 4 6 L 1 9 Sa l e s t o C o m m e r c i a l C u s t o m e r s - 4 6 L 2 10 Sa l e s t o I n d u s t r i a l C u s t o m e r s - 4 6 L 3 11 Sa l e s t o P u b l i c A u t h o r i t i e s - 4 6 L 4 12 Sa l e s t o M u l t i p l e F a m i l y D w e l l n g s - 4 6 L 5 13 To t a l M e t e r e d W a t e r R e v e n u e s 14 Fir e P r o t e c t i o n R e v e n u e - 4 6 2 15 Sa l e s t o I r r i g a t i o n C u s t o m e r s - 4 6 5 16 Sa l e s f o r R e s a l e - 4 6 6 17 Gu a r a n t e e d R e v e n u e s - 4 6 9 18 Oth e r W a t e r R e v e n u e s ( M e t e r s ) . 4 7 4 Di r e c t A s s i g n 45 , 2 0 0 45 , 2 0 0 45 , 2 0 0 19 To t a l W a t e r R e v e n u e s 22 0 , 7 7 4 23 , 2 5 3 24 4 , 0 2 7 24 4 , 0 2 7 Ot h e r O p e r a t i n g R e v e n u e s - 4 1 9 . 1 / 2 20 Ba n k I n t e r e s t I n c o m e - 4 1 9 . 1 SO / 5 0 63 0 63 0 31 5 31 5 21 In t e r e s t / L a t e F e e - 4 1 9 , 2 SO / 5 0 3,3 0 9 3, 3 0 9 1, 6 5 4 1,6 5 4 Se w e r R e v e n u e s 22 Se w e r A c t i v e F e e Dir e c t A s s i g n 88 , 5 6 9 88 , 5 6 9 88 , 5 6 9 23 St a n d b y S e w e r C h a r g e s Dir e c t A s s i g n 14 7 , 5 8 9 14 7 , 5 8 9 14 7 , 5 8 9 24 Ot h e r S e w e r R e v e n u e s Dir e c t A s s i g n 25 To t a l S e w e r R e v e n u e s 23 6 , 1 5 8 23 6 , 1 5 8 23 6 , 1 5 8 26 To t a l U t i l t y R e v e n u e s 46 0 , 8 7 1 23 , 2 5 3 48 4 , 1 2 4 23 8 , 1 2 8 24 5 , 9 9 6 Pa g e 7 o f 1 0 Ex l l 6 PA C 7 0 1 i . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l i t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Ac c o u n t All o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o -- Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Op e r a t i n g E x p e n s e s - W a t e r : 1 La b o r - O p e r a t i o n & M a i n t e n a n c e 60 1 . 1 - 6 35 , 9 8 2 35 , 9 8 2 35 , 9 8 2 2 La b o r - C u s t o m e r A c c o u n t s 60 1 . 7 3 La b o r - A d m i n i s t r a t i v e & G e n e r a l 60 1 . 8 4 Sa l a r i e s - O f f c e r s & D i r e c t o r s 60 3 5 Em p l o y e e P e n s i o n s & B e n e f i t s 60 4 6 Pu r c h a s e d W a t e r 61 0 7 Pu r c h a s e d P o w e r 61 5 8, 8 7 2 8,8 7 2 8, 8 7 2 8 Fu e l f o r P o w e r P r o d u c t i o n 61 6 9 Ch e m i c a l s 61 8 1,7 6 8 4, 3 9 0 6,1 5 9 6, 1 5 9 10 Ma t e r i a l s & S u p p l i e s - O p e r a t i o n & M a i n t e n a n c e 62 0 . 1 - 6 27 , 8 4 8 27 , 8 4 8 27 , 8 4 8 11 Ma t e r i a l s & S u p p l i e s - A d m i n i s t r a t i v e & G e n e r a l 62 0 , 7 - 1 1 50 / 5 0 3, 3 9 6 3, 3 9 6 1,6 9 8 1, 6 9 8 12 Co n t r a c t S e r v i c e s - B i l i n g 63 0 13 Co n t r a c t S e r v i c e s - P r o f e s s i o n a l 63 1 43 , 0 2 4 43 , 0 2 4 43 , 0 2 4 14 Co n t r a c t S e r v i c e s - T e s t i n g 63 5 2, 2 9 0 40 2,3 3 0 2, 3 3 0 15 Co n t r a c t S e r v i c e s - O t h e r 63 6 28 , 7 8 5 2, 2 1 5 31 , 0 0 0 31 , 0 0 0 16 Re n t s 64 0 17 Tr a n s p o r t a t i o n E x p e n s e s 65 0 18 In s u r a n c e E x p e n s e 65 5 19 Re g u l a t o r y C o m m i s s i o n E x p e n s e s 66 5 11 , 6 6 7 11 , 6 6 7 11 , 6 6 7 20 Ba d D e b t E x p e n s e 67 0 21 Mi s c e l l a n e o u s E x p e n s e s - C o s t o f M e t e r s 67 5 23 , 6 3 1 23 , 6 3 1 23 , 6 3 1 22 To t a l O p e r a t i n g E x p e n s e s - W a t e r 17 5 , 5 9 6 18 , 3 1 2 19 3 , 9 0 8 1,6 9 8 19 2 , 2 1 0 Op e r a t i n g E x p e n s e s - s e w e r : 23 Se w e r - L i c e n s e s , F e e s & P e r m i t 50 50 50 24 Se w e r - C o n t r a c t L a b o r 31 , 1 8 5 31 , 1 8 5 31 , 1 8 5 25 Se w e r - G r o u n d s M a i n t e n a n c e 1,0 2 6 1, 0 2 6 1,0 2 6 26 Se w e r - C i t y o f V i c t o r 19 , 3 0 8 19 , 3 0 8 19 , 3 0 8 27 Se w e r - U t i l i t i e s 8, 2 8 1 8,2 8 1 8, 2 8 1 28 Se w e r - L e g a l F e e s 53 , 1 2 9 53 , 1 2 9 53 , 1 2 9 29 Se w e r - R e p a i r s & M a i n t e n a n c e 13 , 7 2 4 13 , 7 2 4 13 , 7 2 4 30 Se w e r - O p e r a t i n g S u p p l i e s 1,2 6 0 1, 2 6 0 1,2 6 0 31 Se w e r - S o f t w a r e 4, 7 2 0 4, 7 2 0 4, 7 2 0 32 Se w e r - R e s e r v e ( 2 % o f A s s e t ) 60 , 0 0 0 60 , 0 0 0 60 , 0 0 0 33 Se w e r - J e t t i n g & C a m e r a 10 0 , 5 5 6 (8 0 , 4 4 5 ) 20 , 1 1 1 20 , 1 1 1 34 Se w e r - M a n a g e m e n t F e e 24 , 0 0 0 6, 0 0 0 30 , 0 0 0 30 , 0 0 0 35 To t a l O p e r a t i n g 8 r M a i n t e n a n c e E x p e n s e s - s e w e r 31 7 , 2 3 9 (7 4 , 4 4 5 ) 24 2 , 7 9 4 24 2 , 7 9 4 36 To t l U t i l t y O p e r a t i n g 8 r M a i n t e n a n c e E x p e n s e s 49 2 , 8 3 5 (5 6 , 1 3 3 ) 43 6 , 7 0 2 24 4 , 4 9 2 19 2 , 2 1 0 Pa g e 8 o f 1 0 ~ EX H l l t 6 PA G ' O f i . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l i t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Ac c o u n t Al l o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d -- De s c r i p t i o n / A c c o u n t N o ~ Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad i u s t e d Se w e r Wa t e r De p r e c i a t i o n E x p e n s e - W a t e r - A c c o u n t 4 0 3 1 So u r c e o f S u p p l y P l a n t 2 Pu m p i n g P l a n t 3 Tr a n s m i s s i o n a n d D i s t r i b u t i o n P l a n t 4 Ge n e r a l P i a n t 3, 0 9 1 3, 0 9 1 3, 0 9 1 5 To t a l D e p r e c i a t i o n E x p e n s e - W a t e r 3, 0 9 1 3, 0 9 1 3, 0 9 1 6 De p r e c i a t i o n E x p e n s e - S e w e r 58 , 6 4 5 58 , 6 4 5 58 , 6 4 5 Am o r t i z a t i o n E x p e n s e - A c c o u n t 4 0 6 / 7 7 So u r c e o f S u p p l y P l a n t 37 , 2 4 0 37 , 2 4 0 37 , 2 4 0 8 Pu m p i n g P l a n t 69 8 69 8 69 8 9 Tr a n s m i s s i o n a n d D i s t r i b u t i o n P l a n t 23 , 3 8 3 23 , 3 8 3 23 , 3 8 3 10 Ge n e r a l P l a n t 27 , 8 1 9 27 , 8 1 9 27 , 8 1 9 11 To t a l A m o r t i z a t i o n E x p e n s e - W a t e r 89 , 1 4 0 89 , 1 4 0 89 , 1 4 0 Ta x e s O t h e r T h a n I n c o m e T a x e s - A c c o u n t 4 0 8 12 Re g u l a t o r y F e e s - P U C - 4 0 8 , 1 61 7 61 7 61 7 13 Pr o p e r t y T a x e s - 4 0 8 , 2 10 9 10 9 10 9 14 Ot h e r T a x e s - D E Q F e e s - 4 0 8 . 3 15 Pa y r o l l T a x e s - 4 0 8 - 4 16 Fr a n c h i s e F e e s - 4 0 8 , 5 17 Ot h e r F e e s & L i c e n s e s - 4 0 8 . 6 18 To t a l T a x e s O t h e r T h a n I n c o m e T a x e s 10 9 61 7 72 6 72 6 Fe d e r a l " S t a t e I n c o m e T a x e s - A c c o u n t 4 0 9 19 Fe d e r a l I n c o m e T a x e s - 4 0 9 , 1 20 Sta t e I n c o m e T a x e s - 4 0 9 . 2 21 To t a l I n c o m e T a x e s In t e r e s t a n d D e b t S e r v i c e E x p e n s e 22 In t e r e s t o n L o n g - T e r m D e b t - 4 2 7 . 3 23 Ot h e r I n t e r e s t E x p e n s e - 4 2 7 , 5 24 Ot h e r - B a d D e b t E x p e n s e 25 To t a l I n t e r e s t / D e b t S e r v i c e E x p e n s E Pa g e 9 o f 1 0 ., EX H I B I T 6 PA G 9 01 . . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n De v e l o p m e n t o f R e v e n u e R e q u i r e m e n t s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ex h i b i t N o 6 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Al l o c a t i o n To t a l U t i l i t y Pr o F o r m a Te s t Y e a r Un r e g u l a t e d Re g u l a t e d ~ De s c r i p t i o n / A c c o u n t N o Fa c t o r / R e f Pe r B o o k s Ad j u s t m e n t s Ad j u s t e d Se w e r Wa t e r Ca l c u l a t i o n o f F e d e r a l a . S t a t e I n c o m e T a x e s - A c c o u n t 4 0 9 (A t p r e s e n t a n d p r o p o s e d r a t e s ) Op e r a t i n g I n c o m e B e f o r e I n c o m e T a x e s Ta b l e N o 2 , L i n e 1 6 (3 5 , 1 6 4 ) (6 9 , 0 1 6 ) (1 0 4 , 1 7 9 ) (6 5 , 0 0 9 ) (3 9 , 1 7 0 ) Le s s T a x D e d u c t i o n s : 2 In t e r e s t E x p e n s e 3 Ex c e s s t a x o v e r d e p r e c i a t i o n 4 To t a l T a x D e d u c t i o n s 5 Ta x a b l e I n c o m e - S t a t e ( L i n e 1 - L i n e 4 ) (3 S , 1 6 4 ) (6 9 , 0 1 6 ) (1 0 4 , 1 7 9 ) (6 5 , 0 0 9 ) (3 9 , 1 7 0 ) 6 5ta t e I n c o m e T a x ¡ ¡ 5 . 9 p e r c e n t 5. 9 0 % (2 , 0 7 5 ) (4 , 0 7 2 ) (6 , 1 4 7 ) (3 , 8 3 6 ) (2 , 3 1 1 ) 7 Fe d e r a l T a x a b l e I n c o m e ( L i n e 5 - L i n e 6 ) (3 3 , 0 8 9 ) (6 4 , 9 4 4 ) (9 8 , 0 3 3 ) (6 1 , 1 7 4 ) (3 6 , 8 5 9 ) 8 Fe d e r a l I n c o m e T a x e s ¡ ¡ 3 5 p e r c e n t 35 , 0 0 % (1 1 , 5 8 1 ) (2 2 , 7 3 0 ) (3 4 , 3 1 1 ) (2 1 , 4 1 1 ) (1 2 , 9 0 1 ) 9 Le s s A m o r t i z a t i o n o f I T C 10 Le s s P r o d u c t i o n C r e d i t s 11 Ne t F e d e r a l I n c o m e T a x E x p e n s e (1 1 , 5 8 1 ) (2 2 , 7 3 0 ) (3 4 , 3 1 1 ) (2 1 , 4 1 1 ) (1 2 , 9 0 1 ) In c o m e T a x e s a t P r o p o s e d R a t e s - W a t e r 12 Op e r a t i n g I n c o m e B e f o r e I n c o m e T a x e s (3 9 , 1 7 0 ) 13 Re v e n u e D e f i c i e n c y - P r o p o s e d R a t e s Ta b l e N o 2 , L i n e 2 6 99 , 2 5 6 Le s s T a x D e d u c t i o n s : 14 In t e r e s t E x p e n s e 15 IP U C A s s e s s m e n t F e e 24 , 8 8 3 16 To t a l T a x D e d u c t i o n s 24 , 8 8 3 17 Ta x a b l e I n c o m e - S t a t e ( L i n e 1 2 + L i n e 1 3 - L i n e 1 6 ) 84 , 9 6 9 18 Sta t e I n c o m e T a x ¡ ¡ 5 . 9 p e r c e n t - W a t e r 5, 9 0 % 4, 3 8 8 19 Fe d e r a l T a x a b l e I n c o m e ( L i n e 1 7 - L i n e 1 8 ) 24 , 4 9 5 20 Fe d e r a l I n c o m e T a x e s ¡ ¡ 3 5 p e r c e n t 35 . 0 0 % 8, 5 7 3 21 Le s s A m o r t i z a t i o n o f r r c 22 Le s s P r o d u c t i o n C r e d i t s 23 Ne t F e d e r a l I n c o m e T a x E x p e n s e - W a t e r 8, 5 7 3 Pa g e 1 0 o f 1 0 .. EX H l a r 6 P A G i . 0 1 i . Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y Ex h i b i t N o 7 Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n Pa g e 1 Sc h e d u l e o f A c c o u n t s Fo r t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Su m m a r y o f A d j u s t m e n t s (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) (8 ) (9 ) (1 0 ) Li n e Ac c o u n t Pe r B o o k s Ad j u s t m e n t Ad j u s t m e n t Ad j u s t m e n t Ad j u s t m e n t Ad j u s t m e n t Ad j u s t m e n t Ad j u s t m e n t Ad j u s t m e n t Ad j u s t e d -- De s c r i p t i o n Nu m b e r Am o u n t No 1 No 2 No 3 No 4 No 5 ~ No 7 No 8 Am o u n t Re v e n u e s ( 4 0 0 ) : 1 Un m e t e r e d W a t e r R e v e n u e - 4 6 0 2 Sa l e s t o R e s i d e n t i a l C u s t o m e r s 46 0 , 1 17 0 , 4 0 0 15 , 8 4 0 18 6 , 2 4 0 3 Sa l e s t o C o m m e r c i a l C u s t o m e r s 46 0 , 2 4, 8 0 0 4, 8 0 0 4 Sa l e s t o I n d u s t r i a l C u s t o m e r s 46 0 3 5 Sa l e s t o P u b l i c A u t h o r i t i e s 46 0 , 4 6 Sa l e s t o M u l t i p l e F a m i l y D w e l l n g s 46 0 , 5 7, 7 8 7 7, 7 8 7 7 Ot h e r S a l e s 46 0 , 6 -l 37 4 8 To t a l U n me t e r e d W a t e r R e v e n u e s 17 4 , 8 2 6 24 , 0 0 0 19 8 , 8 2 7 Me t e r e d W a t e r R e v e n u e 46 1 10 Fi r e P r o t e c t i o n R e v e n u e 46 2 11 Sa l e s t o I r r i g a t i o n C u s t o m e r s 46 5 12 Sa l e s f o r R e s l e 46 6 13 Gu a r a n t e e d R e v e n u e s 46 9 14 Ot h e r W a t e r R e v e n u e s ( M e t e r s ) 47 4 ~ ~ 15 To t a l W a t e r R e v e n u e s 22 0 , 0 2 6 24 , 0 0 0 24 4 , 0 2 7 Op e r a t i n g E x p e n s e s ( 4 0 1 ) : 16 La b o r - O p e r a t i o n & M a i n t e n a n c e 60 L l - 6 35 , 9 8 2 35 , 9 8 2 17 La b o r - C u s t o m e r A c c o u n t s 60 L 7 18 La b o r - A d m i n i s t r a t i v e & G e n e r a l 60 L 8 19 Sa l a r i e s - O f f c e r s & D i r e c t o r s 60 3 20 Em p l o y e e P e n s i o n s & B e n e f i t s 60 4 21 Pu r c h a s e d W a t e r 61 0 22 Pu r c h a s e d P o w e r 61 5 8,8 7 2 8, 8 7 2 23 Fu e l f o r P o w e r P r o d u c t i o n 61 6 24 Ch e m i c a l s 61 8 1, 7 6 8 4, 3 9 0 6, 1 5 9 25 Ma t e r i a l s & S u p p l i e s - O p e r a t i o n & M a i n t e n a n c e 62 0 , 1 - 6 27 , 8 4 8 27 , 8 4 8 26 Ma t e r i a l s & S u p p l i e s - A d m i n i s t r a t i v e & G e n e r a l 62 0 . 7 - 1 1 3,3 9 6 3, 3 9 6 27 Co n t r a c t S e r v i c e s - B i l l n g 63 0 28 Co n t r a c t S e r v i c e s - P r o f e s s i o n a l 63 1 43 , 0 2 4 43 , 0 2 4 29 Co n t r a c t S e r v i c e s - T e s t i n g 63 5 2,2 9 0 40 2, 3 3 0 30 Co n t r a c t S e r v i c e s - O t h e r 63 6 28 , 7 8 5 6, 0 0 0 (3 , 7 8 5 ) 31 , 0 0 0 31 Re n t s 64 0 32 Tr a n s p o r t a t i o n E x p e n s e s 65 0 33 In s u r a n c e E x p e n s e 65 5 34 Re g u l a t o r y C o m m i s s i o n E x p e n s e s 66 5 11 , 6 6 7 11 , 6 6 7 35 Ba d D e b t E x p e n s e 67 0 36 Mi s c e l l a n e o u s E x p e n s e s - C o s t o f M e t e r s 67 5 ~ - ~ 37 To t a l O p e r a t i n g E x p e n s e s 17 5 , 5 9 6 6, 0 0 0 (3 , 7 8 5 ) 4, 3 9 0 40 11 , 6 6 7 19 3 , 9 0 8 Ot h e r O p e r a t i n g E x p e n s e s : 38 De p r e c i a t i o n E x p e n s e 40 3 3,0 9 1 3, 0 9 1 39 Am o r t i z a t i o n E x p e n s e - O t h e r 40 7 89 , 1 4 0 89 , 1 4 0 40 Re g u l a t o r y F e e s ( I P U C ) 40 8 , 1 61 7 61 7 41 Pr o p e r t T a x e s 40 8 - 2 10 9 10 9 42 Pa y r o l l T a x e s 40 8 3 43 Oth e r T a x e s - D E Q / I D W R 40 8 , 4 67 4 67 4 44 Ot h e r T a x e s - O t h e r F e e s & L i c e n s e s 40 8 , 5 45 Fe d e r a l I n c o m e T a x e s 40 9 , 1 46 St a t e I n c o m e T a x e s 40 9 . 2 47 To t a l O t h e r O p e r a t i n g E x p e n s e s ~ -- 89 , 1 4 0 -g 48 To t a l E x p e n s e s f r o m O p e r a t i o n s ( B e f o r e I n t e r e s t ) 17 9 , 4 7 0 6, 0 0 0 (3 , 7 8 5 ) 4, 3 9 0 40 61 7 11 , 6 6 7 89 , 1 4 0 28 7 , 5 3 8 49 Ne t O p e r a t i n g I n c o m e 40 , 5 5 7 (6 , 0 0 0 ) 3,7 8 5 (4 , 3 9 0 ) 24 , 0 0 0 (4 0 ) (6 1 7 ) (1 1 , 6 6 7 ) (8 9 , 1 4 0 ) (4 3 , 5 1 2 ) .. . Ex H I B I 7 PA G t O f t l I Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Exhibit No 7 Page 2 Adjustment No 1 Line No Description Amount 1 Adjust Management Fees: To annualize the increase in management fees and expenses for the test year. 2 Actual expenses incurred January 1 to $24,000 December 31, 2007. 3 Add annual increase for TV 2007 6,000 4 Total Annualized Expenses $30,000 5 Adjustment for TV 2007 $6,000 ExHI..7 PAG2... ~ Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Exhibit No 7 Page 3 Adjustment No 2 Line No Description Amount 1 Adjust Billing Software Expense: To remove the nonrecurring expenses associated with the acquisition of billing software. 2 Actual expenses incurred January 1 to $4,785 December 31, 2007. 3 Less nonrecurring expenses for TV 2007 3,785 4 Total Recurring Annualized Expenses $1,000 5 Adjustment for TV 2007 $(3,785) Exll1 PAG 3 Of i. . Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Exhibit No 7 Page 4 Adjustment No 3 Line No Description Amount 1 Adjust Chemical (Chlorine) Expenses:$1,768 To normalize chemical expenses using test year usage at current prices and annualized number of customers and usage. 2 Gallons treated from mid-July to December 2,674,000 3 Actual cost per 1000 gallons $0.66 4 Annualized gallons - test period CY 2007 5,611,000 (Actual treated gallons amounts to 47.66% of the annual amount to be treated) 5 Annualized gallons - test period 9,314,260 (CY2007 adjusted for growth of newcustomers and usage based on the 1st four months of 2008 - see notes below) 6 Annualized cost - Line 5 * Line 3 $6,158 7 Adjustment - Line 6 - Line 1 $4,390 Note: (January-April growth of 66% from 2007): CY 2008 554,000 768,000 521,000 684,000 2,527,000 CY 2007 296,000 394,000 338,000 493,000 1,521,000 Percent change CY 2008 over CY 2007 66.14% EXHIwr 7 PAC.. or i. Te t o n S p r i n g s W a t e r & S e w e r C o m p a n y An n u a l i z e d R e v e n u e s b y C u s t o m e r C l a s s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 An n u a l i z e d f o r 2 0 0 8 N u m b e r o f C u s t o m e r s Ex h i b i t N o 7 Pa g e 5 Ad j u s t m e n t N o 4 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Li n e Mo n t h l y 1s t 2n d 3r d 4t h An n u a l ~ De s c r i p t i o n Ra t e Qu a r t e r Qu a r t e r Qu a r t e r Qu a r t e r To t a l s Un m e t e r e d R e s i d e n t i a l S e r v i c e : 1 Nu m b e r o f A c t i v e C u s t o m e r s 19 4 19 4 19 4 19 4 2 To t a l S i n g l e F a m i l y B u i l d i n g l o t s 58 1 58 1 58 1 58 1 58 1 58 1 3 Cu r r e n t M o n t h l y R a t e - A c t i v e $ 80 . 0 0 4 Re v e n u e s $ 46 , 5 6 0 $ 46 , 5 6 0 $ 46 , 5 6 0 $ 46 , 5 6 0 $ 18 6 , 2 4 0 Se r v i c e A v a i l a b i l i t y - R e s i d e n t i a l : 5 Nu m b e r o f N o n a c t i v e C u s t o m e r s 38 7 38 7 38 7 38 7 6 Pr o p o s e d A v a i l a b i l i t y R a t e s 7 Re v e n u e s 8 Ba s e A v a i l a b i l i t y C h a r g e Un m e t e r e d M u l t i - f a m i l y ( 1 ) : 9 Nu m b e r o f A c t i v e C u s t o m e r s 73 73 73 73 10 Nu m b e r o f N o n - a c t i v e C u s t o m e r s 14 3 14 3 14 3 14 3 14 3 14 3 11 Pr o p o s e d M o n t h l y R a t e s $ 26 . 6 7 12 Re v e n u e s 1, 9 4 7 1, 9 4 7 1, 9 4 7 1, 9 4 7 7, 7 8 7 Se r v i c e A v a i l a b i l t y - M u l t i - f a m i l y : 13 Nu m b e r o f N o n a c t i v e C u s t o m e r s 70 70 70 70 14 Pr o p o s e d A v a i l a b i l i t y R a t e s 15 Re v e n u e s 16 Ba s e A v a i l a b i l i t y C h a r g e Un m e t e r e d C o m m e r c i a l S e r v i c e : 17 Nu m b e r o f A c t i v e C u s t o m e r s 5 5 5 5 18 To t a l C o m m e r c i a l B u i l d i n g l o t s 14 14 14 14 14 14 19 Cu r r e n t M o n t h l y R a t e - A c t i v e $ 80 . 0 0 20 Re v e n u e s $ 1, 2 0 0 $ 1, 2 0 0 $ 1, 2 0 0 $ 1, 2 0 0 $ 4, 8 0 0 Se r v i c e A v a i l a b i l i t y - C o m m e r c i a l : 21 Nu m b e r o f N o n a c t i v e C u s t o m e r s 9 9 9 9 8 22 Pr o p o s e d A v a i l a b i l i t y R a t e s 23 Re v e n u e s 24 Ba s e A v a i l a b i l i t y C h a r g e 25 To t a l S e r v i c e R e v e n u e s : $ 49 , 7 0 7 $ 49 , 7 0 7 $ 49 , 7 0 7 $ 49 , 7 0 7 $ 19 8 , 8 2 7 26 To t a l N u m b e r o f A c t i v e C u s t o m e r s : 27 2 27 2 27 2 27 2 1, 0 8 8 27 To t a l S e r v i c e R e v e n u e s p e r B o o k s ( P e r R e v i s e d P / l ) : $ 17 4 , 8 2 6 28 An n u a l i z i n g A d j u s t m e n t - C Y 2 0 0 7 .. 24 , 0 0 0 . II I I 22 11 1 . d . "I EX H I B I 7 P~ 5 O F l ' Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Exhibit No 7 Page 6 Adjustment No 5 Line No Description Amount 1 Adjust Lab Sampling Expenses: To annualize Lab Sampling experises for the test year. 2 Actual expenses incurred from March to $2,290 December 31, 2007. 3 Add expenses for January and February, 2007 40 4 Total Annualized Expenses $2,330 5 Adjustment for CY 2007 $40 EXH.. 7 PAG l 01 i. .. Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Exhibit No 7 Page 7 (*) Per IPUC Order No 30537, Case No F-2008-1 EXHIBI 7 PAG 7 Of i. .. Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Exhibit No 7 Page 8 Adjustment No 7 Line No Description Amount 1 Adjust Rate Case Expense Amortization: To amortize over three years the projected level of deferred rate case expenses. (a) Consulting Fees 25,000 (b) Legal Fees 10,000 Total 35,000 2 Actual expenses incurred CY 2007.$ Details: 3 Estimated deferred rate case expenses $35,000 4 Amortization period - Years 3 5 Pro Forma Rate Case Expense Amortization $11,667 6 Test Year Actual Expense - Line 2 $ 7 Adjustment - Line 5 - Line 6 $11,667 EXi'" '1 PAG' ~ l' .. Teton Springs Water & Sewer Company Before the Idaho Public Utilities Commission Adjustments to Operating Results For the 12 Months Ending December 31, 2007 Adjustment No 8 - Table 1 Line No Description Amount 1 Adjust Depreciation/Amortization Expense: To adjust the test year level of depreciation and/or amortiztion expense to the proforma level based on plant in service, CIAC and customer advances. 2 Actual expenses incurred CY 2007.$ Details: 3 Pro forma depreciation/amortization expense for the test year 2007 - per Table No 2. 4 Pro Forma Depreciation/Amortization Expense 89,140 5 Test Year Expense - Line 2 $ 6 Adjustment - Line 4 - Line 5 $89,140 Exhibit No 7 Page 9 EXHIIl 7 PAG' Of i. Te t o n S p r i n g s W a t e r & S e w e r Ex h i b i t N o 7 Be f o r e t h e I d a h o P u b l i c U t i l i t i e s C o m m i s s i o n Pa g e 1 0 Pr o F o r m a A m o r t i z a t i o n P r o v i s i o n Fo r t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 Ad j u s t m e n t N o 8 - T a b l e 2 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Pr o F o r m a Ne t Li n e Ac c o u n t Ut i l i t y Pr o F o r m a Pr o F o r m a De p r e c i a b l e De p r e c i a t i o n An n u a l -- Nu m b e r Ac c o u n t T i t l e Pl a n t CI A C Ad v a n c e s Pl a n t Ra t e s ~r e c i a t i o n So u r c e o f S u p p l y P l a n t : 1 30 4 St r u c t u r e s a n d I m p r o v e m e n t s 3, 4 5 5 3, 4 5 5 2. 0 0 % 69 2 30 5 Co l l e c t i n g a n d I m p o u n d i n g R e s e r v o i r s 2. 0 0 % 3 30 6 La k e , R i v e r a n d O t h e r I n t a k e s 2. 0 0 % 4 30 7 We l l s a n d S p r i n g s 23 6 , 9 3 6 23 6 , 9 3 6 2. 8 6 % 6, 7 7 6 5 30 9 Su p p l y M a i n s 1, 5 1 9 , 7 2 2 1, 5 1 9 , 7 2 2 2. 0 0 % 30 , 3 9 4 6 30 9 . 1 Ot h e r W a t e r S o u r c e P l a n t - V a l v e s 4. 0 0 % 7 To t a l 37 , 2 4 0 Pu m p i n g P l a n t : 8 31 0 . 1 St r u c t u r e s a n d I m p r o v e m e n t s 2. 9 0 % 9 31 1 . 1 Ot h e r P o w e r P r o d u c t i o n E q u i p m e n t 5. 0 0 % 10 31 1 . 2 El e c t r i c P u m p i n g E q u i p m e n t 13 , 9 6 0 13 , 9 6 0 5. 0 0 % 69 8 11 31 1 . 3 Di e s e l P u m p i n g E q u i p m e n t 5. 0 0 % 12 31 1 . 4 Ot h e r P u m p i n g E q u i p m e n t 5. 0 0 % 13 To t a l 69 8 Wa t e r T r e a t m e n t P l a n t : 14 32 0 . 1 St r u c t u r e s a n d I m p r o v e m e n t s 2. 9 0 % 15 32 0 . 2 Wa t e r T r e a t m e n t E q u i p m e n t - F i l t r a t i o n 5. 0 0 % 16 32 0 . 3 Wa t e r T r e a t m e n t E q u i p m e n t - C h l o r i n a t i o n 5. 0 0 % 17 To t a l Tr a n s m i s s i o n a n d D i s t r i b u t i o n P l a n t : 18 33 0 . 1 St r u c t u r e s a n d I m p r o v e m e n t s 2. 9 0 % 19 33 0 . 2 Di s t r i b u t i o n R e s e r v o i r s a n d S t a n d p i p e s 36 4 , 2 5 6 36 4 , 2 5 6 2. 0 0 % 7, 2 8 5 20 33 1 Tr a n s m i s s i o n a n d D i s t r i b u t i o n M a i n s 57 9 , 9 3 0 57 9 , 9 3 0 2. 0 0 % 11 , 5 9 9 21 33 3 Se r v i c e s 2. 5 0 % 22 33 4 Me t e r s & M e t e r I n s t a l l a t i o n s 2. 5 0 % 23 33 5 Hy d r a n t s 17 9 , 9 5 6 17 9 , 9 5 6 2. 5 0 % 4, 4 9 9 24 33 6 Ba c k f l o w P r e v e n t i o n D e v i c e s / O t h e r P l a n t 0. 0 0 % 25 To t a l 23 , 3 8 3 Ge n e r a l P l a n t : 26 33 9 St r u c t u r e s a n d I m p r o v e m e n t s 2. 5 0 % 27 34 0 Of f i c e F u r n i t u r e a n d E q u i p m e n t 6. 6 7 % 28 34 0 . 1 Co m p u t e r E q u i p m e n t 20 . 0 0 % 29 34 1 Tr a n s p o r t a t i o n E q u i p m e n t 11 . 4 9 % 30 34 2 St o r e s E q u i p m e n t 6. 6 7 % 31 34 3 To o l s , S h o p a n d G a r a g e E q u i p m e n t 6. 6 7 % 32 34 4 La b o r a t o r y E q u i p m e n t 6. 6 7 % 33 34 5 Po w e r O p e r a t e d E q u i p m e n t 14 . 5 0 % 34 34 6 Co m m u n i c a t i o n E q u i p m e n t 9. 0 0 % 35 34 7 Co m m u n i c a t i o n E q u i p m e n t - S C A D A 10 . 0 0 % 36 34 8 Ot h e r I n t a n g i b l e P l a n t / M i s e E q u i p m e n t 27 8 , 1 9 4 27 8 , 1 9 4 10 . 0 0 % 27 , 8 1 9 37 To t a l 27 , 8 1 9 38 To t a l s 3, 1 7 6 , 4 0 9 3, 1 7 6 , 4 0 9 89 , 1 4 0 ,. 4 EX H l a r 7 P A G i . O F i. -, .. Teton Springs Water & Sewer Company Before The Idaho Public Utilities Commission Net-to-Gross Multiplier for the Idaho Retail Jurisdiction 12 Months Ending December 31, 2007 Exhibit No 8 Idaho Jurisdiction Line No 1 2 3 4 5 6 7 8 9 10 11 12 Description Income Before Income Taxes Less Uncollectable Accounts Adjustment Less IPUC Assessment Fees (*) Net Revenues State Income Tax Rate State Income Taxes (Line 4 x Line 5) Federal Tax Base (Line 4-6) Times Federal Income Tax Rate Federal Income Tax Rate-Effective (Line 7 x Line 8) Net Operating Income Factor (line 7-Line 9) Gross Revenue Conversion Factor (Line 1jLine 8) Combined Tax Rate for ID (Line 6 + Line 9) Amounts 100.00% 0.00% 0.250700% 99.749% 5.90% 5.8852% 93.86% 35.00% 32.85% 61.01% 1.6390 38.738% (*) Per IPUC Order No 30537, Case No F-2008-1 Exhibit No 8 (LAC-4) (2)/10 Net to Gross Mult - (LAC-4) EXHlII . PAG i Of i Te t o n S p r i n g s W a t e r & S e w e r Be f o r e t h e I d a h o P u b l i c U t i l t i e s C o m m i s s i o n Ca l c u l a t i o n o f R a t e s b y C u s t o m e r C l a s s Ba s e d o n t h e 1 2 M o n t h s E n d i n g D e c e m b e r 3 1 , 2 0 0 7 - A d j u s t e d (1 ) (2 ) (3 ) (4 ) (5 ) Pr o p o s e d R a t e s Li n e No o f Cu r r e n t Mo n t h l y Qu a r t e r l y An n u a l 2! De s c r i p t i o n Cu s t o m e r s Ra t e s / M o Ra t e Ra t e s Re v e n u e s Un m e t e r e d R e s i d e n t i a l : 1 To t a l N u m b e r o f S i n g l e F a m i l y L o t s 58 1 2 To t a l N u m b e r o f A c t i v e C u s t o m e r s 19 4 $ 80 . 0 0 $ 50 . 0 0 $ 1 5 0 . 0 0 11 6 , 4 0 0 3 To t a l N u m b e r o f I n a c t i v e L o t s 38 7 $ $ 25 . 0 0 $ 75 . 0 0 11 6 , 1 0 0 4 To t a l s 23 2 , 5 0 0 Un m e t e r e d C o m m e r c i a l : 5 To t a l N u m b e r o f C o m m e r c i a l L o t s 19 6 To t a l N u m b e r o f A c t i v e C u s t o m e r s 5 $ 80 . 0 0 $ 15 0 . 0 0 $ 4 5 0 . 0 0 9, 0 0 0 7 To t a l N u m b e r o f I n a c t i v e L o t s 14 $ $ 75 . 0 0 $ 2 2 5 . 0 0 12 , 6 0 0 8 To t a l s 21 , 6 0 0 Un m e t e r e d M u l t i f a m i l y : 9 To t a l N u m b e r o f M u l t i f a m i l y U n i t s 14 3 10 To t a l N u m b e r o f A c t i v e C u s t o m e r s 73 $ 26 . 6 7 $ 50 , 0 0 $ 1 5 0 . 0 0 43 , 8 0 0 11 To t a l N u m b e r o f I n a c t i v e C u s t o m e r s $ $ $ 12 To t a l s 43 , 8 0 0 To t a l N u m b e r o f b i l l i n g u n i t s : 13 To t a l N u m b e r o f A c t i v e C u s t o m e r s 27 2 16 9 , 2 0 0 14 To t a l N u m b e r o f I n a c t i v e C u s t o m e r s / L o t s 40 1 12 8 , 7 0 0 15 To t a l s 67 3 29 7 , 9 0 0 16 To t a l R e v e n u e R e q u i r e m e n t s f r o m S a l e s : $ 2 9 8 , 0 8 2 (E x h i b i t N o 5 ) ,. . Ex h i b i t N o 9 Ex m l l 9 P A G E 1 O f 1