Loading...
HomeMy WebLinkAbout20090903Doherty Direct.pdfORIGINAL .Dean J. Miler (ISB # 1968) McDEVITT & MILLER LLP 420 West Banock Street P.O. Box 2564-83701 Boise, ID 83702 Tel: 208.343.7500 Fax: 208.336.6912 joe~cdevitt-miler.com RECEIVED 1069 SEP -3 PH 3: 54 ....; 'lC' i'-' IDAHO ¡"'LJt1;7~\;:'~IOt UT\L1TIES COMrl.lv:: \i Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN TH MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES Case No. UWI-W-09-01 AND CHAGES FOR WATER SERVICE IN THE STATE OF IDAHO .BEFORE THE IDAHO PUBLIC UTILITIES CDMMISSION DIRECT TESTIMONY OF KEVIN H. DOHERTY . .1 Q. 2 A. 3 4 Q. 5 A. 6 7 Q. 8 A. 9 10 11.12 13 14 15 16 17 18 19 20 21 22.23 Please state your name and business address. Kevin Dohert. My business address is 200 Old Hook Road, Harington Park, New Jersey 07640. By whom are you employed and in what capacity? I am employed by United Water Management and Services Inc. (UWM&S) as Director of Rates. Please describe your work experience. Prior to joining United Water, from 1987 to 1989, I was employed by Arhur Young and Company as a Staff Auditor. I paricipated in audits for clients in the manufacturing, energy, and defense industries. I was employed by Citizens Communications Company beginning in 1989. From 1989 until 1994, I held the position of Senior Capital Asset Accountat, responsible for preparation of varous plant in service and depreciation reports, and I provided data for rate , proceedings and certin bond indenture requirements. In 1994, I was promoted to Senior Regulatory Accountat and paricipated in rate proceedings in the states of Ohio and Ilinois. In 1995, I was promoted to Regulatory. Specialist, and testified on rate base in rate proceedings in the states of Pennsylvania and Arzona. In 1999, I accepted a position as Manager of Regulatory Accounting and testified on rate base and certain operating expenses in the states of Vermont and Arizona. I joined United Water in 2003 and have fied testimony on behalf of United Water in the states of Arkansas, Delaware, New Jersey, New York and Pennsylvania Dohert, Di i United Water Idaho Inc. . . . 1 Q. 2 A. 3 4 5 6 Q. 7 A. 8 9 10 11 12 13 14 Q. 15 A. 16 17 18 Q. 19 A. 20 21 22 23 Please sumarze your educational background. I graduated from Pace University In 1987 with a Bachelor of Business Administration degree in Accounting, and have completed Pace University's MBA program in Financial Management. I have attended seminars and presentations that addressed accounting, rates and other financial matters. What is the purose of your testimony? The purose of my testimony is to describe and present the calculation of the revenue deficiency and the resulting request for rate relief, and sponsor the calculation of Rate Base for the test year ending May 31, 2009 with proforma adjustments through December 31, 2009. United Water Idaho ("United Water" or "The Company"). Additionally, I am sponsoring the calculation of the Company's Depreciation Expense for the test year ending May 31, 2009 with proforma adjustments through December 31,2009. What level of increase is being sought by the Company in this proceeding? United Water is seeking a revenue increase of $5,626,085 or 15.2% over curent rates for the Test Year ending December 31,2009. Company witness-Wyatt will be discussing the drivers of this increase. What rate of retur on rate base is this rate increase based upon? It is based on an overall rate of retur of 8.49% with a retur on equity of 10.40%. United Water and Commission Staff held discussions prior to the filing of ths case and agreed that a retu on equity of 10.40% was just and reasonable, and agreed to its use in the rate case. I have attched signed copies of both a letter from the Company to Staff proposing the use of a retu on equity of 10.40%, and Dohert, Di 2 United Water Idaho Inc. . . . 1 2 3 Q. Staffs response that formalizes the agreement between the two paries as Exhibit 6. Have you prepared an Exhibit that shows the calculation of the Company's 4 proposed overall Rate of Retur of 8.49%? 5 A.Yes. Exhibit 7, page 1 shows the capital structure of United Waterworks along 6 with the cost of debt as well as the agreed upon retu on equity of 10.40%. The 7 weighted average of these components is the 8.49% overall requested rate of 8 retur. 9 Q.Has the Commission previously approved the use of United Waterworks' capital 1 0 structure and cost of debt by the Company in its rate case fiings? 11 A. 12 13 Q. Yes it has. The Commis'sion approved the use of United Waterworks' capital strctue and cost of debt with its Order No. 27616 in Case No. UWI-W-97-6. Have you prepared from the Company's books and records a series of exhibits 14 depicting the Company's balance sheet and operating income statement for the 15 twelve months ended May 31, 2009? 16 A.I have prepared Exhibits Numbered 8 and 9 ilustrating the Company's Balance 17 Sheet (Exhibit No.8) and Operating Income Statement Per Books (Exhibit No.9) 18 as of May 3l, 2009. 19 Q.Have you prepared an exhibit that indicates the pro forma operating income for 20 the Company at existing and proposed rates? 21 A.Yes. I have prepared Exhibit No. 10, which is titled "Statement of Operating 22 Income Per Books and Pro Forma under Present and Proposed Rates For The 23 Twelve Months Ending December 31,2009". Dohert, Di 3 United Water Idaho Inc. . . . 1 Colum 1 of Exhibit No. 10 identifies the schedule on Exhibit No. 11 that details 2 the adjustments to the test year results indicated in aggregate fashion on Exhibit 3 No. 10. Colum 2 of Exhibit No. 10 indicates the elements of operating income: 4 operations and maintenance expense, depreciation and amortization expense, 5 taxes other than income and income taxes. The amounts therein are per books, as 6 shown on Exhibit No. 11. Colum 3 of Exhbit No. 10 shows a sumar of test 7 year adjustments made to revenues and expenses. The adjustment to operating 8 revenue shown on line 1 is detaled on Exhibit 12 and wil be explained by 9 Witness Loy. The adjustments to operation and maintenance expenses, 10 summarized on line 2, are detailed on Exhibit No. 11, Schedule 1 and they wil 11 also be explained by Witness Loy. The adjustments to depreciation expense and 12 amortization of utility plant acquisition adjustments sumarized on lines 3 and 4 13 are detailed in Exhibit No. 11, Schedule 2, pages 1 and 2, and wil be explained 14 later in my testimony. The adjustments to operating taxes sumarized on lines 6 15 and 7 are detailed in Exhibit No. ll, Schedule 3, pages 1 to 3, and will be 16 explained by Witness Loy. Colum 4 of Exhibit No. 10 shows the adjusted 17 operating income at existing rates for the test period. Column 4 also indicates that 18 based on the test year adjustments made, the Company wil earn a 6.31 % overall 19 rate of retu on its rate base investment as of December 31, 2009 with known and 20 measurable adjustments taken into consideration. Column 5 of Exhibit No. 10 21 indicates the adjustments to operating revenue, operation and maintenance 22 expenses, and income taxes under the increased rates proposed by the Company 23 herein. The adjustment to operating revenues of $5,626,085 was computed using Dohert, Di 4 United Water Idaho Inc. . . . 1 an 8.49% rate of retu on rate base. Colum 6 of Exhibit No. 10 ilustrates the 2 adjusted operating income necessar to produce the requested rate of retu, 3 8.49%. The income taxes shown on lines 11 and 12 were computed as indicated 4 on Exhibit No. 11, Schedule 4, and wil be explained in conjunction therewith. 5 Q.Retuing to Column 3 of Exhibit No. 10, please explain the adjustments to 6 operating expenses? 7 A.Operation and maintenance expenses have been increased by $1,281,820 (Exhbit 8 10, line 2). Depreciation and amortization expense have been increased by 9 $203,372 (Exhibit 10, line 5). Payroll taes have been increased $53,927 10 (Exhibit 10, line 8). Federal income taxes have increased $2,534,377 and State 11 income taxes have been decreased by $1,694,275 (Exhibit No. 10, lines 11 & 12). 12 The detailed support for the operating expense adjustments are shown on the four 13 Schedules following the Exhibit 11 Summar. Schedule 1, pages 1 to 22, provides 14 detail for adjustments made to operation and maintenance expenses that are 15 explained by Witness Loy. Schedule 2, pages 1 and 2, provides detail for 16 adjustments to depreciation and amortization expense. Schedule 3, pages 1 to 3, 17 provides detail for adjustments to propert and payroll taxes. Schedule 4, page 1 18 provides detail for adjustment of State and Federal income tax expense. Page 2 of 19 Schedule 4 shows the methodology I employed to compute the "Net to Gross 20 Multiplier" utilized in this case to gross up the Net Operating Income deficiency 21 Q.Please explain Exhibit No. 11, Schedule 2. 22 A.Exhibit No. 11, Schedule 2 consists of two pages indicating the depreciable basis 23 of Utility Plant by primar account, net of contributions and advances (advances Dohert, Di 5 United Water Idaho Inc. . . . 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Q. 15 A. 16 17 Q. 18 A. 19 20 21 22 23 for constrction are classified as non-depreciable propert until the Company acquires an investment in the propert though the payment of refuds on advances as required by Order No. 28505 in Case UWI-W-OO-L), the depreciation rate for each plant account and the anual depreciation expense by primar account. The depreciation rates utilzed are the same as those used in prior rate case filings. Pro forma anual depreciation expense of $7,255,334 is sumarized at the bottom of the schedule, and the amortization of certain utilty plant acquisition adjustments that have previously been approved by the IPUC of $9,329 (the calculation of this amortization is shown on Exhibit 13, Schedule 7) is added. The total depreciation and amortization of $7,264,663 is then compared to depreciation and amortization expense recorded in the test year of $7,061,291. The difference between the proforma and recorded amounts yields an adjustment of$203,372. Please explain Exhibit No.ll, Schedule 3. Exhibit No. 11, Schedule 3, shows the adjustments to both test year propert and payroll taxes and is explained by Witness Loy. Please explain Exhibit No. 11, Schedule 4. Exhibit No. 11, Schedule 4, Page 1 of 2 shows the calculation of state and federal income taxes at both existing and proposed rates. The amounts shown on line 1 of colums 1 and 2 are the same as the amounts shown on line 10 of columns 4 and 6 on Exhibit No. 10. These figures represent operating income before income taxes. From these figures the applicable statutory deductions must be deducted when computing the state and federal income taes. Dohert, Di 6 United Water Idaho Inc. .1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Q. 16 A. 17 18 19 Q. 20 A. 21 Q. . . The first deduction is interest expense and it is deductible in the computation of both state and federal taxable income. The calculation for the interest deduction is shown in Note A on lines 11 though 15. The deduction of interest expense is shown on line 2. The second deduction is the excess of pro forma ta depreciation over pro forma book depreciation. The excess tax depreciation is deducted from state taable income only since state income taes are calculated on the basis of flow-through accounting while federal income taxes are calculated on the basis of normalization accounting. Lines 17, 18 and 19 indicate the amounts used in determining excess tax depreciation. The remaining calculations are self-explanatory except for the amortization of investment tax credit shown on Line 9. Federal income tax expense was reduced by the amortization of ITC that is amortized ratably over the lives of the assets and represents 2% of the ITC claimed from 1971 though 1999. Please explain the adjustment shown on line 2, Column 5 of Exhibit No. 10. The adjustment shown on line 2, Column 5 of Exhibit No. 10 represents additional uncollectible expense and IPUC assessment as a result of the pro forma adjustment to operating revenue shown on line 1, Column 5 of Exhibit No. 10 Does this conclude your testimony regarding operating expenses? Yes. Please address your rate base testimony. Dohert, Di 7 United Water Idaho Inc. . . . 1 A. 2 3 4 Q. 5 A. 6 7 8 9 10 11 12 13 14 Q. 15 A. 16 17 18 Q. 19 A. 20 21 22 23 The Company was directed by the Commission in Case UWI-W-04-04, Order Nos. 29838 and 29871, to fie futue rate cases utilzing a thirteen-month average rate base methodology. Has the Company complied with the Commission directive stated above? Yes. The Company has computed rate base using essentially the same methodology as was used by the IPUC Staff and approved by the Commission in Case No. UWI-W-04-04. Major elements of rate base, namely: plant in service, accumulated depreciation, contributions in aid of construction, advances for constrction and utilty plant acquisition adjustments are all thirteen-month averaged. Working capital is computed as of the Company's May 31, 2009 balance sheet. Deferred debits and gains on sales of propert are not averaged but are included in rate base at their anticipated balance as of December 31, 2009 the end of the proforma period. What is the level of rate base the Company is requesting in this proceeding? The rate base is $154,127,480. Company Witness Rhead discusses the plant in service additions that are a par of the reason for the increase in their direct testimony. Please explain Exhibit 13, Schedule 1, Page 1 of 1. Exhibit 13, Schedule 1, Page 1 of 1, Rate Base Summar, shows the elements of the Company's rate base as of December 31, 2009, using the thirteen-month average methodology. The elements of rate base are as follows: Utility Plant in Service; Accumulated Depreciation; Customer Advances for Constrction; Contributions In Aid of Construction; Net Utilty Plant Acquisition Adjustments; Dohert, Di 8 United Water Idaho Inc. . . . 1 Accumulated Deferred Income Taxes; Pre-1971 Investment Tax Credits; Deferred 2 Charges, Working Capital and a rate base deduction for the Gain on the Sale of 3 Propert. 4 Q.Please explain Exhibit 13, Schedule 2, Page 1 of 1. 5 A.Exhibit 13, Schedule 2, Page 1 of 1, Thirteen-Month Average Worksheet, shows 6 the monthly balances from December 31, 2008 to December 31, 2009 for those 7 rate base components that are thirteen-month averaged. Monthly balances are 8 caried forward to this schedule from the supporting schedules for Plant in Service 9 (Schedule 3), Accumulated Depreciation and Amortization (Schedule 4), 10 Customer Advances for Construction (Schedule 5), Contributions in Aid of 11 Constrction (Schedule 6), Utility Plant Acquisition Adjustment (Schedule 7) and 12 Pre-1971 Investment Tax Credits (Schedule 8). Schedule 2 shows the thirteen- 13 month average calculation of the balances from the respective schedules. 14 Q Please explain Exhbit 13, Schedule 3, Pages 1 through 3. 15 A.Exhibit 13, Schedule 3, Pages 1 through 3 shows the Company's Utility Plant 16 balance as of May 31, 2009 by plant account. Schedule 3 then summarizes the 17 forecast plant additions and retirements by plant account from June through 18 December 2009. Witness Rheads' Exhibit 4 forms the basis for the plant activity 19 shown on this schedule. The thirteen-month average of Utilty Plant in Service is 20 $324,143,710. 21 Q Please explain Exhibit 13, Schedule 4, Page 1 of 1. 22 A.Exhibit 13, Schedule 4, Page 1 of 1 shows the Company's Accumulated 23 Depreciation and CIAC Amortization. The schedule shows the recorded amounts Dohert, Di 9 United Water Idaho Inc. . . . 1 for these rate base components for the months of December 2008 through May 2 2009. For the months beginning in June 2009, I calculated a monthly incremental 3 amount for both accumulated depreciation and amortization of CIAC. To these 4 monthly amounts, I added any retirement, cost of removal or salvage information 5 provided by Witness Rhead, forming a balance for accumulated depreciation and 6 amortization of CIAC for the months of June through December 2009. The 7 thirteen-month average of accumulated depreciation is $71,369,828, while the 8 thirteen-month average for amortization ofCIAC is $15,255,672. 9 Q.Please explain Exhibit 13, Schedule 5, Page 1 of 1. 10 A.Exhibit 13, Schedule 5, Page 1 of 1 sumarizes change to advances for 11 constrction for the test year. Since the issuace of Order No. 28505 in case UWI- 12 W -00-1, the Company does not depreciate advanced propert. This requires the 13 Company to accurately track, by associated plant account, all additions and 14 refuds impacting the advance account. The thirteen-month average balance of 15 advances for construction is $7,067,143. 16 Q.Please explain Exhbit 13, Schedule 6, Page 1 of 1. 17 A.Exhibit 13, Schedule 6, Page 1 of 1 indicates activity in Contributions in Aid of 18 Construction (CIAC) during the test period. Like advances for construction, 19 CIAC fuded assets are not depreciated for rate- making puroses. The thirteen- 20 month average balance of net CIAC is $71,658,448. 21 Q.Please explain Exhibit 13, Schedule 7, Page 1 of 1. 22 A.Exhibit 13, Schedule 7, Page 1 of 1 indicates the net change to the balance of 23 Utility Plant Acquisition Adjustment (UP AA). The UPAA gross balance is Dohert, Di i 0 United Water Idaho Inc. .1 comprised of both debit and credit balances. The gross value of the six individual 2 UP AA, all approved by the Commission in various proceedings, is a positive 3 $600,762. As of December 31, 2009, the net balance will be $536,245; the 4 thirteen-month average balance is $540,910. 5 Q.Please explain Exhibit 13, Schedule 8, Page 1 of 1. 6 A.Exhibit 13, Schedule 8, Page 1 of 1 indicates the composition of Accumulated 7 Deferred Income Taxes (ADIT) at the end of the test period. The ta depreciation 8 portion of this account was adjusted for assets in service as of December 31, 2009. 9 The balance of ADIT excludable from rate base for rate-making puroses is 10 $10,030,655. 11 Q.Please explain Exhibit 13, Schedule 9, Page 1 of 1..12 A.Exhibit 13, Schedule 9, Page 1 of 1, represents the activity related to the pre-1971 13 investment tax credits that are deducted from rate base and amortized at a rate of 14 $1.285 anually. The balance at December 31, 2009 will be $7,388. The thirteen- 15 month average balance is $8,031. 16 Q.Please explain Exhibit 13, Schedule 10, Page 1 of 1. 17 A.Exhibit 13, Schedule 10, Page 1 of 1, identifies the deferred items the Company 18 has included in rate base. The tota balance is $2,019,690. Of this balance, 19 $1,141,906 is the net unamortized balance of deferred items included in rate base 20 from the Company's two previous rate cases. The $877,784 of new deferred 21 charges requested for inclusion in rate base in this proceeding is comprised of five 22 line items. First is the estimated cost of preparing and presenting the curent case.23 of $198,884. Next is the cost incured by the Company to paint the Ustick ta. Dohert,Di i i United Water Idaho Inc. .1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Q. 17 A. 18 19 20 21 22 Q. . . The cost of this project was $74,182. As explained by Witness Loy, the Company is requesting a twenty year amortization of this expenditue. Also, the Company will spend $276,000 before December 31, 2009 to paint the Steelhead, Crestline and Hilcrest tans. The Company has also requested a twenty year amortization of these expenditures, in line with the amortization of tan paintings granted in case UWI-W-04-04. These planed ta painting projects are explained by Witness Loy. Also included is the Company's request to ear a return on the unamortized balance of its Conservation Plan and its related costs which are expected to be $195,264. Witness Wyatt explains the Conservation Plan in his direct testimony and Witness Loy reflects the requested amortization of these costs in his Operating Expense exhibits. Finally, the Company is reflecting a $133,454 increase to its deferred debit account that represents additional AFUDC equity ta gross-up for the period between the previous rate case and the end of the test year in this case. These dollar amounts have been moved out of plant-in- service pursuant to Order No. 29838 in Case UWI-W-04-04. Please explain Exhibit 13, Schedule 1 i, Pages 1 through 6. Exhibit 13, Schedule 11, Pages 1 through 6 indicates the calculation of the allowance for working capital prepared by the Company using the balance sheet dated May 31, 2009. The same methodology used in Case UWI-W-06-02 was employed in the instat case. The working capital allowance included in rate base is $2,912,431. Please explain Exhibit 13, Schedule 12, Page 1 of 1. Dohert, Di i 2 United Water Idaho Inc. .1 A.Exhibit 13, Schedule 12, Page 1 of 1 shows the calculation of the unamortized 2 gains from the Company's sales of propert. First is the gain associated with the 3 sale of the Danskin propert to the City of Kuna. In Case No. UWI-W-07-05, 4 Order No.30481, dated December 27, 2007, the Commission approved a 5 Settlement Stipulation between the Company and Staff that established the 6 amount of the gain at $207,905 and also called for the inclusion of the remaining 7 unamortized balance to be included as a deduction from rate base in any 8 subsequent rate case. The unamortized balance of this gain is calculated to be 9 $69,302 at December 31, 2009. Next is the gain associated with the sale of the 10 Canyon County properties to the City of Nampa. In Case No. UWI-W-08-02, 11 Order No. 30651, dated October 7, 2008, the Commission approved accounting.12 treatment similar to what it had approved in Case No. UWI-W-07-05, whereby the 13 unamortized balance of the gain associated with the sale the Canyon Propert 14 would be also be included as a deduction from rate base in any subsequent case. 15 The initial amount of this gain was $49,402 and the unamortized balance is 16 calculated to be $30,182 at December 31, 2009.The sum of these two 17 unamortized gains is $99,484 at December 31, 2009 and this amount is included 18 as a deduction from rate base on Schedule 1. 19 Q.Does this conclude your direct testimony? 20 A.Yes. .Dohert, Di i 3 United Water Idaho Inc. . . . McDevitt & Miller LLP Lawyers (208) 343-7500 (208) 336-6912 (Fax) 420 West Bannock Street P.O. Box 2564-83701 Boise, Idaho 83702 Chas. F. McDevitt Dean J. a oe) Miler July 30, 2009 Vìa U.S. Mai Weldon Stutzman Deputies Attorney General Idaho Public Utities Commssion 472 W. Washigton Boffe. Idaho 83720 C'-' t=_-0-')im:i000 O"J0"...;:rr;i 3-=.i;:: U''(::Wo2.This is to confim discussions between Greg Wyatt and myself with you, Rady Lobb and Terri Carlock yesterday regardig retun on equity (ROE) to be alowed in United Water's impendig general rate case. ~ !5 lWRe:United Water Idaho Case No. UWI-W-09-1; Return on Common Equity Dea Weldon: As we dicussed, the cuent alowed retu ff 10.3% which was established in United Water's 2004 rate case and adopted by stipultion in the United Water's 2006 rate case. A review of Commssion ROE alowances in electrc utity rate case indicates that an alowance of 10.5% has become common in recent cases. Thus, for settement puroses, we agreed that a mid-point of 10.4% percent was a .reasonable compromie from the Staff and Company perspectives. Accordingly, it is our intention to fie diect testiony recommendig a 10.4% alowance and recite that it is based on discussions 'with Staff and your agreement. We would anticipate that Staff would subsequently fie diect testiony config our agreement and supportg the 10.4% recommendation. Kidly confim that I have accurately stated our understadig by reply correspondence. Very Truy Yours, McDevitt & Miler U.. \riU_~nTMiler DJM/hh cc: Greg Wyatt, Unite Water Case No. UWI-W-09-01 Exhibit NO.6 Page 1 of2 K. Doherty ;0rn("m -0:: e:.. CJ.. c~ rri::: . STATE OF IDAHO OFFICE OF THE ATTORNEY GENERAL LAWRENCE G. WASDEN July 31, 2009 Dean J. (Joe) Miller McDevitt & Miler LLP PO Box 2564 Boise, ID 83701-2564.Re:United Water Idaho, Case No. UWI-W-09-01 Return on Common Equity Dear Joe, ¡, LLF U 4 ¿OO9 HECEJVED This will confirm Stafts and United Water's agreement, as outlined in your correspondence dated July 30, 2009, to support a retur on equity (ROE) of 10.4% in the Company's pending rate case. Staff will fie testimony to support a 10.4% ROE. Sincerely,~ Weldon B. Stutzman Deputy Attorney General blsfL:UWI-W-09-0 i _Miler _ ws . Case No. UWI-W-09-01 Exhibit NO.6 Page 2 of 2 K. Doherty Contract & Administrative law Division, Idaho Public Utilties Commision P.O. Box 83720, 801se, Idaho 83720-0074. Telepone: (208) 334-0300, FAX: (208) 334-3762, E-mail: Ipuciæpuc.stateJd.us Locted at 472 West Washington St.. Boise, Idaho 83702 . Capital Structure Component Debt Equity Total . . United Water Idaho Calculation of Weighted Average Cost of Capital Case UWI-W-09-01 Capital Structure and Cost of Debt of United Waterworks Cost of Weighted Avg. Cost of Amount Percentage Source Capital 293,015,000 48.87%6.49%3.17% 306,516,216 51.13%10.40%5.32% 599,531,216 100.00%8.49% $ $ $ Case No. UWI-W-09-01 Exhibit NO.7 Page 1 of 2 K.Doherty C-li=-=io-):/T--(I..o()-i¡0-.-l'~\. ~'tJo sg=-.~-0 tW ;vm('m --p..:- -0:: ca(J.. nî;"' . . . UN I T E D W A T E R W O R K S 30 - J u n - Q 9 CO M P O S I T E C O S T R A T E O F D E B T (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) (8 ) (9 ) (1 0 ) (1 1 ) (1 2 ) Un a m o r t i z e d An n u a l Am o r t i z a t i o n o f Ef f e c t i v e (a ) Ne t D i s c o u n t , Ne t St a t e d In t e r e s t Ne t D i s c o u n t An n u a l Co s t We i g h t e d Li n e De s c r i p t i o n Is s u e Ma t u r i t y Am o u n t Pr e m i u m a n d Pr o c e d s In t e r e s t Ex p e n s e Pr e m i u m a n d Co s t Ra t e Em b e d d e d # of D e b t Da t e Da t e Ou t s t a n d i n g Ex p e n s e (C . 4 + / . c . 5 ) Ra t e (C . 4 x C . 7 ) Ex p e n s e (C . 8 + C . 9 ) Co s t R a t e 1 M e d i u m T e r m N o t e S e r i e s A 1 9 9 8 21 9 8 21 2 3 25 , 0 0 0 , 0 0 0 1, 3 2 0 , 4 6 3 23 , 6 7 9 , 5 3 7 6. 9 7 % 1, 7 4 2 , 5 0 0 97 , 2 1 2 1, 8 3 9 , 7 1 2 7. 7 7 % 0. 6 6 % 2 M e d i u m T e r m N o t e S e r i e s A 1 9 9 8 12 1 9 8 12 1 1 7 5, 0 0 0 , 0 0 0 34 , 2 7 2 4,9 6 5 , 7 2 8 6. 9 0 % 34 5 , 0 0 0 4, 0 3 2 34 9 , 0 3 2 7. 0 3 % 0. 1 2 % 3 M e d i u m T e r m N o t e S e r i e s A 1 9 9 8 21 9 8 21 2 8 15 , 0 0 0 , 0 0 0 14 8 , 9 6 4 14 , 8 5 1 , 0 3 6 7. 1 0 % 1, 0 6 5 , 0 0 0 8, 0 1 6 1, 0 7 3 , 0 1 6 7. 2 3 % 0. 3 8 % 4 T a x E x e m p t - D e l a w a r e 9 5 T E F 6/ 9 5 6/ 2 5 25 , 0 0 0 , 0 0 0 64 2 , 9 7 7 24 , 3 5 7 , 0 2 3 6. 2 0 % 1, 5 5 0 . 0 0 0 40 , 4 0 4 1, 5 9 0 , 4 0 4 6. 5 3 % 0. 5 7 % 5 T a x E x e m p t - D a u p h i n 9 2 T E F S e r i e s B 6/ 9 2 6/ 1 7 4, 1 8 5 , 0 0 0 32 , 5 8 5 4, 1 5 2 , 4 1 5 6. 7 0 % 28 0 , 3 9 5 4, 1 1 6 28 4 , 5 1 1 6. 8 5 % 0. 1 0 % 6 T a x E x e m p t - B o i s e 2 0 0 1 T E F 9/ 0 1 9/3 1 26 , 4 3 5 , 0 0 0 2, 9 2 8 , 8 8 3 23 , 5 0 6 , 1 1 7 5. 0 0 % 1, 3 2 1 , 7 5 0 13 2 , 1 3 2 1, 4 5 3 , 8 8 2 6. 1 9 % 0. 5 2 % 7 T a x E x e m p t - D E 2 0 0 2 T E F 3/ 0 2 3/ 3 3 16 , 6 0 5 , 0 0 0 1, 7 7 4 , 2 8 4 14 , 8 3 0 , 7 1 6 5. 1 5 % 85 5 , 1 5 8 74 , 9 6 4 93 0 , 1 2 2 6. 2 7 % 0. 3 3 % 8 T a x E x e m p t N Y ( N R ) 2 0 0 2 T E F 3/ 0 2 3/ 3 4 11 , 6 4 5 , 0 0 0 1, 3 1 6 , 8 8 0 10 , 3 2 8 , 1 2 0 5. 1 5 % 59 9 . 7 1 8 53 , 3 8 8 65 3 , 1 0 6 6. 3 2 % 0. 2 3 % 9 T a x E x e m p t - D a u p h i n 9 2 T E F S e r i e s A 6/ 9 2 6/ 2 4 10 . 0 0 0 , 0 0 0 27 5 , 5 4 9 9, 7 2 4 , 4 5 1 6. 9 0 % 69 0 , 0 0 0 18 , 4 8 0 70 8 , 4 8 0 7. 2 9 % 0. 2 5 % 10 T a x E x e m p t - B o i s e 0 5 T E F 5/ 0 5 5/ 3 5 19 , 2 6 5 , 0 0 0 1, 7 7 2 , 6 6 5 17 , 4 9 2 , 3 3 5 4.5 5 % 87 6 , 5 5 8 65 , 4 6 0 94 2 , 0 1 8 5. 3 9 % 0. 3 4 % 11 T a x E x e m p t - J A X 9 5 T E F 8/ 9 5 8/ 2 5 20 , 0 0 0 , 0 0 0 43 5 , 4 5 6 19 , 5 6 4 . 5 4 4 6. 3 5 % 1, 2 7 0 , 0 0 0 27 , 0 7 2 1, 2 9 7 , 0 7 2 6. 6 3 % 0. 4 6 % 12 T a x E x e m p t - B o i s e 9 7 $ 2 0 M T E F S e r i e s 1 9 9 7 8/ 9 7 8/ 2 7 19 , 8 5 0 , 0 0 0 77 3 , 6 0 4 19 , 0 7 6 , 3 9 6 5. 3 0 % 1, 0 5 2 , 0 5 0 42 , 7 8 0 1, 0 9 4 , 8 3 0 5. 7 4 % 0. 3 9 % 13 T a x E x e m p t - P e n n s y l v a n i a S e r i e s 2 0 0 7 21 0 7 21 3 7 25 , 0 3 0 , 0 0 0 1, 2 0 7 , 0 4 8 23 , 8 2 2 , 9 5 2 4.5 0 % 1, 1 2 6 , 3 5 0 43 , 7 6 0 1, 1 7 0 , 1 1 0 4. 9 1 % 0. 4 2 % 14 S e n i o r N o t e S e r i e s A 11 / 0 7 11 / 1 7 15 , 0 0 0 , 0 0 0 12 8 , 5 1 4 14 , 8 7 1 , 4 8 6 5. 6 6 % 84 9 , 0 0 0 15 , 2 6 9 86 4 , 2 6 9 5. 8 1 % 0. 3 1 % 15 S e n i o r N o t e S e r i e s B 11 / 0 7 11 / 2 8 15 , 0 0 0 , 0 0 0 14 1 , 1 7 8 14 , 8 5 8 , 8 2 2 6. 1 3 % 91 9 , 5 0 0 7,2 7 1 92 6 , 7 7 1 6. 2 4 % 0. 3 3 % 16 M e d i u m T e r m N o t e M u t u a l o f O m a h a A 10 / 0 8 10 / 2 9 7, 5 0 0 , 0 0 0 50 , 0 8 8 7,4 4 9 , 9 1 2 6. 5 4 % 49 0 , 5 0 0 2, 4 7 3 49 2 , 9 7 3 6. 6 2 % 0. 1 8 % 17 M e d i u m T e r m N o t e M u t u a l o f O m a h a B 12 1 0 8 12 1 2 9 7, 5 0 0 , 0 0 0 50 , 6 0 3 7,4 4 9 , 3 9 7 6. 5 9 % 49 4 , 2 5 0 2, 4 7 8 49 6 , 7 2 8 6. 6 7 % 0. 1 8 % 18 M e d i u m T e r m N o t e N Y L i f e A 10 / 0 8 12 1 1 8 12 , 5 0 0 , 0 0 0 80 , 0 7 9 12 , 4 1 9 , 9 2 1 6. 2 1 % 77 6 , 2 5 0 8, 6 4 6 78 4 , 8 9 6 6. 3 2 % 0. 2 8 % 19 M e d i u m T e r m N o t e N Y L i f e B 12 1 0 8 12 1 1 8 12 , 5 0 0 , 0 0 0 81 , 8 7 4 12 , 4 1 8 , 1 2 6 6. 3 1 % 78 8 , 7 5 0 8, 6 8 4 79 7 , 4 3 4 6. 4 2 % 0. 2 8 % 20 T o t a l L o n g - T e r m D e b t 29 3 , 0 1 5 , 0 0 0 13 , 1 9 5 , 9 6 7 27 9 , 8 1 9 , 0 3 3 17 , 0 9 2 , 7 2 8 65 6 , 6 3 8 17 , 7 4 9 , 3 6 6 6. 3 4 % Ad d i t i o n a l D e b t C o s t s 21 U n a m o r t i z e d C o s t s A s s o c i a t e d W i t h R e t i r e d 87 , 5 1 6 5, 6 1 6 5,6 1 6 0. 0 0 2 % 0. 0 0 2 % Me d i u m T e r m N o t e ( $ 1 0 M ~ 8 . 8 4 % ) 22 P r e m i u m o n R e t i r e m e n t o f M e d i u m T e r m N o t e 34 4 , 2 6 7 22 , 0 9 2 22 , 0 9 2 0. 0 1 % 0. 0 1 % Pr e m i u m o n R e t i r e m e n t o f P r u d e n t i a l C a p i t a l Co r p . De b t ( $ 2 0 M ~ 1 0 . 0 5 % , $ 1 5 M ~ 9 . 5 7 % ) 23 a n d J a c k s o n v i l e D e b t ( $ 1 2 M ~ 6 . 7 5 % ) 5, 0 5 8 , 0 4 8 34 0 , 9 9 2 34 0 , 9 9 2 0. 1 2 % 0. 1 2 % Un a m o r t i z e d C o s t s A s s o c i a t e d W i t h R e t i r e d 24 J a c k s o n v i l e D e b t ( $ 1 2 M ~ 6 . 7 5 % ) 33 4 , 5 2 2 24 , 9 2 4 24 , 9 2 4 0. 0 1 % 0. 0 1 % Un a m o r t i z e d C o s t s A s s o c i a t e d W i t h R e t i r e d 25 U W W e s t c h e s t e r T E F ( $ 2 . 2 5 M ~ 8 . 8 5 % ) 57 , 4 0 6 8, 5 5 4 8, 5 5 4 0. 0 0 3 % 0. 0 0 3 % 26 T o t a l s 19 , 0 7 7 , 7 2 6 1, 0 5 8 , 8 1 6 18 , 1 5 1 , 5 4 4 6. 4 9 % Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 7 Pa g e 2 o f 2 K. D o h e r t y United Water Idaho Balance Sheet Per Books RECEIVED.May 31, 2009 Case No. UWI-W-09-D1 3=51Line2069 SEp..3 PHNo.Assets Utility Plant 323,2.H~EriO ¿d~t~\ŠSION1Water Plant in Service $ 2 Retirement Work in Progress (13 , 3 Plant Held for Future Use 0 4 Construction Work in Progress 1,997,485 5 Utilty Plant Acquisition Adjustment 600,761 6 Less: Accumulated Depreciation and Amortization (86,126,408) 7 Net Utilty Plant 239,538,155 Investments 8 Other Investments 11,054 9 Total Investments 11,054 Current Assets 10 Cash (2,561,690) 11 Accts/Notes Receivable - Customers 890,816 12 Other Receivables 152,003 13 Provision for Uncollectable Accounts (28,700) 14 Material & Supplies Inventory 364,579 15 Prepaid Expenses (9,065,516) 16 Accrued Utilty Revenue 4,639,684 17 Total Current Assets (5,608,824) Deferred Debits 18 Deferred Rate Case Expense 102,196 19 Other Deferred Charges 2,374,182.20 Total Deferred Debits 2,476,378 21 Total Assets $236,416,763 Capitalization and Liabiliies Capital 22 Common Stock Issued $1,261,750 23 Additional Paid-in Capital 76,704,330 24 Retained Earnings 66,172,255 25 Total Equity Capital 144,138,335 Lia bilities 26 Accunts Payable 224,178 27 Notes Payable 0 28 Customer Deposits 2,756 29 Accrued Other Taxes Payable 1,356,364 30 Accrued Income Taxes Payable 3,002,212 31 Misc Current & Accrued Liabilties 709,244 32 Advances for Construction 7,050,743 33 Other Deferred Liabilities 6,958,186 34 Accumulated Investment Tax Credits 1,078,368 35 Contributions in Aid of Construction 86,656,999 36 Accumulated Amortization of CIAC (15,084,975) 37 Accumulated Deferred Income Tax 324,354 38 Total Liabilties 92,278,428 $39 Total Liabilties & Capitl 236,416,763 Case NO.UWI-W-G9-G1.Exhibit No.8 Page of 1 of 1 K.Dohert .United Water Idaho R E C E Statement of Income For the Twelve Months Ended May 31, 200ßß9 StIP - 3 Case No. UWI-W-09-o1 IDAHO .~ UTIUTIES CLine No. 1 Operating Revenues $ Operating Expenses 2 Operation and Maintenance Expense 3 Depreciation Expense 4 Amortization, Utilty Plant Acquisition Adjustment 5 Taxes Other Than Income Taxes 6 Income Taxes 7 Total Operating Expenses c PH 3: 58 Li¡~ MISSiOÎ\! 36,905,290 13,765,211 7,051,962 9,329 1,757,475 2,292,778 24,876,755 8 Net Operating Revenues 12,028,535 9 Gains (Losses) from Disposition of Utility Plant 90,469 $12,119,00410 Utilty Operating Income .Case NO.UWI-W-09-o1 Exhibit NO.9 Page of 1 of 1 K.Dohert . . Li n e No . De s c r i p t i o n Op e r a t i n g R e v e n u e s Op e r a t i n g E x p e n s e s 2 O p e r a i o n & M a i n t e n a n c e 3 D e p r e c i a t i o n 4 A m o r t i z a t i o n O f U P A A 5 T o t a l D e p r e c i a t i o n a n d A m o r t i z t i o n Ta x e s O t h e r T h a n I n c o m e 6 A d Va l o r e m 7 P a y r o l l T a x e s 8 T o t a l T a x e s O t h e r T h a n I n c o m e To t a l O p e r a t i n g E x p e n s e s 9 E x c l u d i n g I n c o m e T a x e s 10 O p 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 In c o m e T a x e s 11 5 t a t e I n c o m e T a x e s 12 F e d e r a l In c o m e T a x e s 13 T o t a l In c o m e T a x e s 14 U t i l i t y O p e r a t i n g I n c o m e 15 A d j u s t e d R a t e B a s e 16 R a t e o f R e t u m o n R a t e B a s e 17 R e q u i r e d R a t e o f R e t u r n 18 R e q u i r e d N e t O p e r a t i n g I n c o m e 19 O p e r a t i n g I n c o m e D e f i c i e n c y 20 G r o s s R e v e n u e C o n v e r s i o n F a c t o r 21 R e v e n u e D e f i c i e n c y . UN I T E D W A T E R I D A H O ST A T E M E N T O F O P E R A T I N G I N C O M E P E R B O O K S A N D P R O F O R M A U N D E R PR E S E N T A N D P R O P O S E D R A T E S F O R T H E T W E L V E 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 9 Co l u m n Co l u m n Co l u m n Co l u m n Co l u m n Co l u m n (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Pe r Un d e r P r o p o s e d R a t e s Ad j u s t m e n t Bo o k s Te s t Ye a r Ad j u s t e Re f e r e n c e 05 1 3 1 / 0 9 Ad j u s t m e n t Te s t Ye a r Ad j u s t m e n t s Pr o f o r m a Ex h N o . 1 2 , 5 c h 1 $3 6 . 9 0 5 , 2 9 0 $7 9 , 5 9 6 $3 6 , 9 8 4 , 8 8 6 $5 , 6 2 6 , 0 8 5 $4 2 , 6 1 0 , 9 7 1 15 . 2 1 % Ex h N o . 1 1 , S c h 1 13 , 7 6 5 , 5 4 8 1, 2 8 1 , 8 2 0 15 , 0 4 7 , 3 6 8 Ex h N o . 1 1 , S c h 2 7, 0 5 1 , 9 6 2 20 3 , 3 7 2 7, 2 5 5 , 3 3 4 Ex h N o . 1 1 , 5 c h 2 9, 3 2 9 . 9, 3 2 9 7, 0 6 1 , 2 9 1 20 3 , 3 7 2 7, 2 6 4 , 6 6 3 Ex h N o . 1 1 , 5 c h 3 1, 3 7 0 , 5 9 5 . 1, 3 7 0 , 5 9 5 Ex h N o . 1 1 , 5 c h 3 38 6 , 5 4 3 53 , 9 2 7 44 0 , 4 7 0 1, 7 5 7 , 1 3 8 53 , 9 2 7 1, 8 1 1 , 0 6 5 22 , 5 8 3 , 9 7 7 1, 5 3 9 , 1 1 9 24 , 1 2 3 , 0 9 6 14 , 3 2 1 , 3 1 2 (1 , 4 5 9 , 5 2 3 ) 12 , 8 6 1 , 7 9 0 Ex h N o . 1 1 , 5 c h 4 2, 2 8 9 , 8 3 0 (1 , 6 9 4 , 2 7 5 ) 59 5 , 5 5 5 Ex h N o . 1 1 , 5 c h 4 2, 9 4 7 2, 5 3 4 , 3 7 7 2, 5 3 7 , 3 2 4 2, 2 9 2 , 7 7 7 84 0 , 1 0 2 3, 1 3 2 , 8 7 9 $1 2 , 0 2 8 , 5 3 5 ($ 2 , 2 9 9 , 6 2 5 ) $9 , 7 2 8 , 9 1 1 Ex h N o . 1 3 , 5 c h 1 $1 5 4 , 1 2 7 , 4 8 0 6. 3 1 % = Ex h N o . 7 , P a g e 1 8. 4 9 % $1 3 , 0 6 5 , 4 2 3 $3 , 3 5 6 , 5 1 2 = Ex h N o . 1 1 , 5 c h 4 1. 6 7 6 2 $5 , 6 2 6 , 0 8 5 37 , 4 8 7 15 , 0 8 4 , 8 5 5 7, 2 5 5 , 3 3 4 9, 3 2 9 7, 2 6 4 , 6 6 3 1, 3 7 0 , 5 9 5 44 0 , 4 7 0 1, 8 1 1 , 0 6 5 37 , 4 8 7 24 , 1 6 0 , 5 8 2 5, 5 8 8 , 5 9 9 18 , 4 5 0 , 3 8 8 42 4 , 7 3 3 1, 0 2 0 , 2 8 8 1, 8 0 7 , 3 5 3 4, 3 4 4 , 6 7 7 2, 2 3 2 , 0 8 6 5, 3 6 4 , 9 6 5 $3 , 3 5 6 , 5 1 2 $1 3 , 0 8 5 , 4 2 3 $1 5 4 , 1 2 7 , 4 8 0 8. 4 9 % Ca s e N o . U W I . W - 0 9 - o 1 Ex h i b i t N o . 10 Pa g e 1 o f 1 K. D o h e r t y . RE C E t; r ' ) :; . . . , , ' " , . _ , - 20 0 9 S E P - 3 P H 3 : 5 8 ID A H O P U B L I C UT I L I T I E S C O r " H . . l I S S I O N . . . Plant Account Number 301.10 303.20 303.2W 303-3 303-4 303.50 30420 3040 304-4 304.50 305.20 306.20 307.20 308.20 309.20 United Water Idaho Calculation of Depreciation Expense and Amortzation of UPAA Case UWI-W-Ð9-Ð1 Plant Account Description 310.20 311.20 Organization Organization.CIAC Land & Land Rights. Sourc of Supply waer Rights. Sourc of Supply Land & Land Rights. Water Treatment Land & Land Rights - Trans. & Distrib. Land & Land Rights - General Plant Land and Land Rights-CIAC Structures and Improveme - Sourc of Supply Str & Imprv.-Sourc of Supply-CIAC Strctures and Improvements. Water Treatment Strctures and Improvements - Trans. & Distb. Structures and Improvements - General Plant Collecting & Imponding Reservoirs - Sourc of Supply Coli. & Impound. ReservoirsSourc of Supply-CIAC Lake, River & Oter Intakes wells & Springs Wells & Springs.CIAC Infi~raion Galleries & Tunnels Supply Mains Supply Mains-CIAC Power Generation Equipment Power Elecc Pumping Equipment - Source of Supply Elec Pump. Equip.-Sourc of Supply-CIAC Power Diesel Pumping Equipment - Sourc of Supply Power Pumping Equipment- Water Treatment Power Pumping Equipment. Trans. & Distb. waer Treatment Equipment waer Treatment Equipment. Membrnes Water Treatnt Equipment-eIAC Distrbution Reservoirs & Stndpipes Distribution Reservoirs & Standpipes-CIAC Trans. & Distrib. Mains & Accssories - Intangible Trans. & Distb. Mains & Accssores - 50S Trans. & Distrb. Mains & Accssors T&D Mains & Accssores-CIAC Services Services-CIAC Meiers and Meter Installations Melers-CIAC Hydrants HydrantsIAC 311.20 311-30 311-4 320.30 320-30 330-40 331.10 331.20 331-4 333-40 334-4 335-40 coLf ¿;::0- C"' l0-W(,i:æ;C" zo (¡ :2'¡")._3:;,:"" :=?ô',~'U\:: tf ..UJ.;-Ol---il-~ u.J u'' Net Gros Plant In Depreciable Service CIAC Advances Plant Depreiatin Depreciation 1213112009 1213112009 1213112009 1213112009 Rate Expense 104.54 .(6.986)97,562 0.00%. (9,878)-(9.878)0.00%- 1,497,002 .(376,878)1,120,124 0.00%. 5,976,698 --5,976,698 0.00%- 145,297 -.145,297 0.00%- 1,105,432 --1,105,432 0.00%- 213,383 --213,383 0.00%- (325,405)-(325,405)0.00%- 5,065,120 .(79.492)4,985,628 2.00%99,713 (331,64)-(331,64)2.00%(6,633) 15,419,328 --15.419,328 2.00%308,387 1,569,578 .1,569,578 2.00%31.392 3,249,125 --3,249,125 2.50%81,228 83,217 .-83,217 2.00%1,66 (21,950).(21,950)2.00%(439) 1,164,725 -.1.164,725 2.00%23,294 8,642,701 .(564.726)8.277.975 2.86%236,750 (1,397,310)(1.397,310)2.86%(39,963) 60,351 ..60,351 2.00%1,207 2,205,562 .(374,273)1,831,309 2.00%36,626 (9.391)-(9,391)2.00%(186) 1,284,761 --1,284.761 5.00%64,238 17,712,795 -(462,018)17,250,778 5.00%862,539 (1,783,358).(1,783,356)5.00%(89,168) ----0.00%. 35,674 ..35,674 5.00%1,784 1,697,230 .-1,697.230 5.00%84,862 23,920,349 -(3,384)23,916,965 5.00%1,195,848 992,097 .-992,097 14.28%141,671 (34,570).(34,570)5.00%(1,729) 9,523,589 -(1,054.339)8,469,251 2.00%169,385 (1,163,794)-(1,163,794)2.00 (23,276) ----0.00%- ---0.00%. 142.947,424 -(3,202,486)139,744,938 2.00%2,794,899 (70,622,073)-(70,622.073)2.00%(1,412,441) 50.992,625 -(60,560)50,386,065 2.50%1,259,652 (11,842.00)-(11,842,00)2.50%(296,050) 14,194,432 ..14,194,432 2.50%354,861 (309,508)-(309,508)2.50%(7.738) 3,230,141 .(6,966)3.223,155 2.50%80,579 -(469,83).(469,843)2.50%(11,746) Case No. UWI-W-09-01 Exhibit No. 11 Schedule 2 Page 1 of2 K. Doherty . . . Plant Account Number 336-4 339-10 339-20 339.30 339-4 339.50 340-500 340-5AO 34O-5AO 340-5HO 340-510 340-550 341-5 342-50 343-50 343-50 344-50 345-50 34-50 34-50 347-50 347-50 348-50 348-50 United Water Idaho Calculation of Depreciation Expense and Amortzation of UPAA Case UWI.W-Ð9-Ð1 Plant Account Description Backf Preventon Devices Other Plant & Misc. Equipment - Intangible Other Plant & Misc. Equipment - Source of Supply Other Plant & Misc. Equipment - Water Treatent Other Plant & Misc. Equipment - Trans. & Distrib. Other Plant & Misc. Equipment. General Plant Offce Fumiture and Equipment AM 1 FM System - (GIS) AM 1 FM System Computer Equipment. Hardware IT Initiatives & IFMS Costs Compuer Equipment. Softare Ofic Fumiture & Equipment-CIAC Transportation Equipment Stores Equipment Tools, Shop and Garae Equipment Confined Space Monitor, Generaor, Trench Shield Laboratory Equipment Laboratory Equipment-CIAC Power Operated Equipment Power Operaed Equipment Communications Equipment Miscellaneous Equipment Miscellaneous Equipment Other Tangible Propert MasterPlan TOTAL Net Gross Plant In DepreciableServeCIACAdvancesPlant Depreciation Depreiatin 12131/2009 121112009 12131/2009 121112009 Rate Expense ----0.00%- ----0.00%- ----0.00 - ----0.00%- ----0.00 - ----0.00%- 740,112 --740,112 0.00%- 552.910 --552,910 0.00%- 1,503,683 --1.503,683 10.00%150,368 l,54,Q6 --1,545,076 0.00%- 1,409,202 --1,409,202 10.00%140,920 3,711,978 --3.711,978 20.00%742,396 (1,131)-(1,131)0.00%- 51,356 --51,356 0.00%- 31,917 --31,917 6.67%2,129 607,862 --607,862 6.67%40,54 ----- 134,347 --134,347 6.67%8,961 (16,729)-(16,729)6.67%(1,116) 95,184 --95,184 0.00%- 124,036 --124,036 14.50%17,985 2,157,895 -(34,583)2,123,311 6.67%141,625 239,713 --239,713 0.00%- 154,853 --154.653 6.67%10,315 1,093,387 --1,093,387 2.00%21,868 381,30 --361,306 10.00%36,131 327,767,821 (88,338,589)(6,772,710)232,656,521 7,255,334 Profonna Depreciation Expnse Amrtization of Utiiit Plant Acquisition Adjustment (Exh 13, Sch7) Total Profonna Depreciation and Amortization Depreaton and Amrtation Recorded at May 31, 2009 Proforma Adjustment $ 7.255,334 9,329 7.264,66 7,061,291 $203,372 Case No. UWI.W-G9-G1 Exhibit No. 11 Schedule 2 Page 2 of2 K.Dohert .'ne~ .10 . 1. UNITED WATER IDAHO Case UWI-W-09-01 Computation of State and Federal Income Taxes At Present and Proposed Rates PRESENT PROPOSED RATES RATES (1)(2) OPERATING INCOME BEFORE INCOME TAXES $12,861,790 $18,450,388 LESS: TAX DEDUCTIONS Interest Expense (A)4,888,806 4,888,806 Excess Tax Over Book Depreciation (B)136,734 136,734 TOTAL TAX DEDUCTIONS 5,025,541 5,025,541 Taxable Income-State 7,836,249 13,424,848 State Income Tax at 7.6%$595,555 $1,020,288 Federal Taxable Income (L.1-L.3-L.7)$7,377,428 $12,541.294 Federal Income Tax at 35%$2,582,100 $4,389,453 Less: Amortization of ITC $(44,776)$(44,776) NET FEDERAL INCOME TAX EXPENSE $2.537.324 $4.344.677 2 3 4 5 6 7 8 9 (A) CALCULATION OF INTEREST EXPENSE DEDUCTION: 11 Pro Forma Rate Base 12 Debt Percentage of Capitalization 13 Debt Portion of Rate Base 14 Debt Rate 15 INTEREST EXPENSE 16 (B) EXCESS TAX OVER BOOK DEPRECIATION: 17 Pro Forma Tax Depreciation 18 Pro Forma Book Depreciation 19 EXCESS TAX OVER BOOK DEPRECIATION (8) $ 154,127,480 48.874% 75,328.294 6,49% $ 4,888.806 $ 7,392,068 $ 7,255,334 N01S~\~~~h~.P Os~~~~iin i. t .'. '.",.,~ - . $136,734 8S =t Wcl £- d3S66DZ Case No. UWI-W-09-o1 Exhibit No. 11 Schedule 4 Page 1 of2 K. Dohert3/\1303tl . United Water Idaho Case UWI-W -0-01 Calculation of Revenue Requirement & Net to Gross Multiplier Rate Base $154,127,480 Required Rate of Return 8.49% Required Net Operating Income 13,085,423 Adjusted Net Operating Income Realized 9,728,911 Net Operating Income Deficiency 3,356,512 Net To Gross Multiplier 1.6762 Gross Revenue Increase $5,626,085 .Net Operating Income Requirement 1.0000000 $5,626,085 Less: IPUC Assessment Rate 0.0025070 Less: Uncollectible Accounts Expense 0.0041560 Rate Applicable to O&M Expense & IPUC Assessment 0.0066630 $37,487 State Tax Rate 0.0760000 Effective Net State Tax Rate 0.0754936 $424,733 Federal Income Tax Residual 0.0821566 Incremental Federal Income Tax Rate 0.3500000 Effective Federal Tax Rate 0.3212452 $1,807,353 Composite:IPUC Fees, Uncollectibles & Income Taxes 0.403402 $2,269,573 Composite Residual 0.596598 $3,356,512 Net to Gross Multiplier 1.6762 $5,626,085 Case No. UWI-W-09-o1 Exhibit No. 11 Schedule 4 Page 2 of 2 K.Dohert . . . . R, E . C i : i ; ~ . . I . . L 20 n 9 S E P - 3 P H 3 : 5 8 ID A H O ' P " U , C H , ¡ . , ' .. . . . \ . J w . . . . . . 1 UT I l i T I E S C O M M I S S I O N Un i t e d W a t e r I d a h o Ra t e C a s e U W I - W - 0 9 - 0 1 Ra t e B a s e S u m m a r y Us i n g 1 3 M o n t h A v e r a g e M e t h o d o l o g y Li n e N o . Ra t e B a s e E l e m e n t Ex h i b i t 1 3 S c h e d u l e Re f e r e n c e Ba s i s o f C a l c u l a t i o n Am o u n t Sc h e d u l e 3 13 M o n t h A v e r a g e $ 32 4 , 1 4 3 , 7 1 0 Sc h e d u l e 4 13 M o n t h A v e r a g e (8 6 , 6 2 5 , 5 0 0 ) 23 7 , 5 1 8 , 2 1 0 Sc h e d u l e 5 13 M o n t h A v e r a g e (7 , 0 6 7 , 1 4 3 ) Sc h e d u l e 6 13 M o n t h A v e r a g e (7 1 , 6 5 8 , 4 4 8 ) Sc h e d u l e 7 13 M o n t h A v e r a g e 54 0 , 9 1 0 Sc h e d u l e 8 Te s t Y e a r E n d (1 0 , 0 3 0 , 6 5 5 ) Sc h e d u l e 9 13 M o n t h A v e r a g e (8 , 0 3 1 ) Sc h e d u l e 1 0 Te s t Y e a r E n d 2, 0 1 9 , 6 9 0 At M a y 3 1 , 2 0 0 9 B a l a n c e Sc h e d u l e 1 1 Sh e e t M e t h o d 2, 9 1 2 , 4 3 1 Sc h e d u l e 1 2 Te s t Y e a r E n d $ (9 9 , 4 8 4 ) $ 15 4 , 1 2 7 , 4 8 0 Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 Pa g e 1 o f 1 K. D o h e r t 1 G r o s s U t i l i t y P l a n t i n S e r v i c e 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 a n d C I A C 2 A m o r t i z a t i o n 3 Ne t U t i l t y P l a n t i n S e r v i c e 4 C u s t o m e r A d v a n c e s f o r C o n s t r u c t i o n 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 ( n e t o f 5 a m o r t i z a t i o n ) 6 U t i l t y P l a n t A c q u i s t i o n A d j u s t m e n t N e t 7 A c c u m u l a t e d D e f e r r e d I n c o m e T a x e s 8 P r e - 1 9 7 1 I n v e s t m e n t T a x C r e d i t s 9 D e f e r r e d C h a r g e s I n c l u d e d i n R a t e B a s e 10 W o r k i n g C a p i t a l A l l o w a n c e 11 G a i n o n S a l e o f P r o p e r t 12 T o t a l R a t e B a s e . Un i t e d W a t e r I d a h o Su m m a r y R a t e B a s e C a l c u l a t i o n Th i r t e n M o n t h A v e r a g e W o r k h e e Ca s e U W l . W - U 9 - U 1 Un e N o . Ra t e B a s e E l e m e n t 1 U t i l i t P l a n t i n S e r v i c e 2 3 G r o s s P l a n t In S e r v i c e 4 A c c m u l a t e d D e p r e c i a t i o n - U t i l i t y P l a n t 5 R e t i r e m e n t W o r K i n P r o g r e s s 6 7 A c c m u l a t e d A m o r t z a t i o n C I A C 8 T o t a l A c c m u l a t e d D e p r e c i a t i o n & A m o r t z a t i o n 9 C u s t o m e r A d v a n c e s f o r C o n s t r c t o n 10 Co n t n b u t i o n s i n A i d o f C o n s t r c t o n - N e t 11 Uti l i t y P i a n t A c q u i s i t o n A d j u s t m n t ( N e t ) 12 Ac c m u l a t e d D e f r r d I n c o m e T a x e s 13 Pr e 1 9 7 1 I n v e s t m e n t T a x C r e d i t 14 De f e r r d C h a r g e s 15 Wo r K i n g C a p i t a l 16 G a i n o n S a l e o f P r o p e r t y 17 To t a l R a t e B a s e . . I Re c o r d e d A m o u n t -- ) 12 1 1 1 0 8 11 3 1 1 0 9 21 8 1 0 9 31 3 1 1 0 9 41 3 0 1 9 51 3 1 1 0 9 61 3 0 1 9 71 3 1 1 0 9 81 1 1 0 9 91 3 0 1 0 9 10 1 3 1 1 0 9 11 1 3 0 1 0 9 12 1 3 1 1 0 9 13 M o n t h A v g 31 8 , 8 8 3 . 3 6 1 32 0 . 4 0 1 , 4 9 3 32 1 , 0 1 5 , 3 6 2 32 1 , 6 8 5 , 8 2 7 32 2 , 6 4 9 , 0 9 1 32 3 , 0 6 , 3 1 7 32 4 . 4 3 1 , 9 2 1 32 5 , 3 6 8 , 0 7 7 32 6 , 1 8 7 , 8 3 2 32 6 , 8 1 2 , 0 7 5 32 7 , 5 4 8 , 3 6 6 32 8 , 0 7 0 , 6 8 3 32 7 , 7 6 7 , 8 2 1 31 8 , 8 8 3 , 3 6 1 32 0 , 4 0 1 . 4 9 3 32 1 , 0 1 5 , 3 6 2 32 1 , 6 8 5 , 8 2 7 32 2 , 6 4 9 , 0 9 1 32 3 , 0 6 , 3 1 7 32 4 , 4 3 1 , 9 2 1 32 5 , 3 6 8 , O n 32 6 , 1 6 7 , 8 3 2 32 6 , 8 1 2 , 0 7 5 32 7 , 5 4 , 3 6 32 8 , 0 7 0 , 6 8 3 32 7 , 7 6 7 , 8 2 1 32 4 , 1 4 3 , 7 1 0 (6 6 , 0 8 8 , 1 4 3 ) (6 8 , 6 4 1 , 9 6 9 ) (6 9 , 2 7 0 , 3 7 8 ) (6 9 , 8 2 8 , 2 6 4 ) (7 0 , 4 2 3 , 3 7 8 ) (7 0 , 9 9 9 , 6 0 9 ) (7 1 , 4 6 4 , 0 8 2 ) (7 2 , 0 2 4 , 5 3 3 ) (7 2 , 3 7 0 , 6 0 6 ) (7 2 , 9 5 5 , 9 7 6 ) (7 3 , 5 5 8 . 4 9 3 ) (7 4 , 1 1 7 , 3 9 9 ) (7 4 , 1 4 0 , 4 0 4 ) (7 1 , 3 7 5 , 6 3 4 ) 12 , 6 9 2 16 . 4 8 3 28 , 9 n (2 , 6 5 3 ) 2,7 2 0 17 , 2 5 1 5, 8 0 5 (1 4 , 4 0 6 , 5 4 3 ) (1 4 , 5 5 8 , 5 6 ) (1 4 , 6 2 3 , 7 5 8 ) (1 4 , 7 7 6 , 6 0 3 ) (1 4 , 9 3 0 , 3 9 6 ) (1 5 , 0 8 4 , 9 7 5 ) (1 5 , 2 3 9 , 2 0 6 ) (1 5 , 3 9 4 , 1 3 9 ) (1 5 , 5 4 9 , 6 4 1 ) (1 5 , 7 0 5 , 5 6 5 ) (1 5 , 8 6 1 , 6 9 2 ) (1 6 , 0 1 7 , 9 8 7 ) (1 6 , 1 7 4 , 4 6 1 ) (1 5 , 2 5 5 , 6 7 2 ) (8 2 , 4 6 1 , 9 9 4 ) (8 3 , 1 8 4 . Q 2 ) (8 3 , 8 6 5 , 1 5 9 ) (8 4 , 6 0 7 , 7 2 0 ) (8 5 , 3 5 1 , 0 5 4 ) (8 6 , 0 6 7 , 3 3 3 ) (6 6 , 7 0 3 , 2 8 9 ) (8 7 , 4 1 8 , 6 7 1 ) (8 7 , 9 2 0 , 2 4 8 ) (8 8 , 6 6 1 , 5 4 1 ) (8 9 . 4 2 0 , 1 8 5 ) (9 0 , 1 3 5 , 3 8 6 ) (9 0 , 3 1 4 , 6 6 5 ) (8 6 , 6 2 5 , 5 0 0 ) (7 , 1 9 7 , 5 3 4 ) (7 , 1 9 4 , 2 0 0 ) (7 , 1 9 5 , 1 6 0 ) (7 , 1 3 9 , 9 4 ) (7 , 0 6 7 , 0 7 7 ) (7 , 0 5 0 , 7 4 3 ) (7 , 0 5 0 . 7 4 3 ) (7 , 0 5 0 , 7 4 3 ) (7 , 0 2 8 , 9 4 3 ) (7 , 0 0 7 , 1 4 3 ) (6 , 9 8 5 , 3 4 3 ) (6 , 9 6 3 , 5 4 3 ) (6 , 9 4 1 , 7 4 3 ) (7 , 0 6 7 , 1 4 3 ) (7 1 , 0 4 0 , 8 3 2 ) (7 0 , 9 1 0 , 9 5 5 ) (7 0 , 9 8 9 , 0 8 0 ) (7 1 , 0 8 , 6 7 2 ) (7 1 , 0 1 6 , 1 1 6 ) (7 1 , 5 7 2 , 0 2 4 ) (7 1 , 9 1 9 , 7 5 4 ) (7 2 , 0 6 1 , 1 2 7 ) (7 2 , 2 7 5 , 3 2 9 ) (7 2 , 2 5 7 , 4 6 0 ) (7 2 , 1 9 9 , 3 9 0 ) (7 2 , 1 4 1 , 1 5 0 ) (7 2 , 0 9 1 , 9 3 2 ) (7 1 , 6 5 8 , 4 4 8 ) 54 5 , 5 7 4 54 , 7 9 7 54 , 0 1 9 54 3 , 2 4 2 54 2 , 4 6 5 54 1 , 6 8 7 54 0 , 9 1 0 54 0 , 1 3 2 53 9 , 3 5 5 53 8 , 5 n 53 7 , 8 0 0 53 7 , 0 2 3 53 6 , 2 4 5 54 0 , 9 1 0 (1 0 , 0 3 0 , 6 5 5 ) (1 0 , 0 3 0 , 6 5 5 ) (8 , 6 7 3 ) (8 , 5 6 6 ) (8 , 4 5 9 ) (8 , 3 5 2 ) (8 , 2 4 5 ) (8 , 1 3 8 ) (8 , 0 3 1 ) (7 . 9 2 3 ) (7 . 8 1 6 ) (7 , 7 0 9 ) (7 , 6 0 2 ) (7 , 4 9 5 ) (7 , 3 8 8 ) (8 , 0 3 1 ) 2, 0 1 9 , 6 9 0 2, 0 1 9 , 6 9 0 2, 9 1 2 , 4 3 1 2, 9 1 2 , 4 3 1 (9 9 . 4 8 4 ) (9 9 . 4 8 4 ) 15 8 , 6 9 9 , 9 0 2 15 9 , 6 4 8 , 5 1 7 15 9 , 5 0 1 , 5 2 4 15 9 , 4 0 8 , 3 7 9 15 9 , 7 4 9 , 0 6 4 15 8 , 9 0 9 , 7 8 6 15 9 , 2 9 1 , 0 1 4 15 9 , 3 4 9 , 7 4 4 15 9 , 4 7 4 , 8 5 0 15 9 , 4 1 6 , 7 9 9 15 9 , 4 7 3 , 6 4 6 15 9 , 3 6 0 , 1 3 1 15 3 : 7 5 0 , 1 1 9 15 4 , 1 2 7 , 4 6 0 Ca s e N o , U W I . W - U 9 - U 1 Ex h i b i t N o . 1 3 Sc h e d u l e 2 Pa g e 1 o f 1 c..p- -0 :: ) : m: : (/ 0 C1 - a °c S: U ~ , ;; r " ~~ ~ : : , (J ( . en Q-i; , t ' ~ '"c:e: \o~-0 ItA :im()IT -0X(,..ui CO .'1 1G . Un i t e d W a t e r I d a h o Ut i l t y P l a n t I n S e r v i c e w i t h F o r e c a s t A d d i t i o n s a n d R e t i r e m e n t s Ca s e U W I - W - 0 9 - 0 1 Pl a n t Ac c o u n t Nu m b e r Pl a n t A c c o u n t D e s c r i p t i o n 30 1 - 1 0 O r g a n i z a t i o n 30 3 - 2 0 L a n d & L a n d R i g h t s - S o u r æ o f S u p p l y 30 3 - 2 W W a t e r R i g h t s - S o u r c o f S u p p l y 30 3 - 3 0 L a n d & L a n d R i g h t s - W a t e r T r e a t m e n t 30 3 - 4 0 L a n d & L a n d R i g h t s - T r a n s . & D i s t r i b . 30 3 - 5 L a n d & L a n d R i g h t s - G e n e r a l P l a n t 30 4 - 2 0 S t r u c t u r e s a n d I m p r o v e m e n t s - S o u r æ o f S u p p l y 30 4 0 S t r u c t u r e s a n d I m p r o v e m e n t s - W a t e r T r e a t m e n t 30 4 S t r u c t u r e s a n d I m p r o v e m e n t s - T r a n s . & D i s t r i b . 30 4 0 S t r u c t u r e s a n d I m p r o v e m e n t s - G e n e r a l P l a n t 30 5 - 2 0 C o 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 - S o u r æ o f S u p p l y 30 6 - 2 0 L a k e , R i v e r & O t h e r I n t a k e s 30 7 - 2 0 W e l l s & S p r i n g s 30 8 - 2 0 I n f l t r t i o n G a l l e r i e s & T u n n e l s 30 9 - 2 0 S u p p l y M a i n s 31 0 - 2 0 P o w e r G e n e r a t i o n E q u i p m e n t 31 1 - 2 0 P o w e r E l e c t i c P u m p i n g E q u i p m e n t - S o u r æ o f S u p p l y 31 1 - 2 0 P o w e r D i e s e l P u m p i n g E q u i p m e n t - S o u r æ o f S u p p l y 31 1 - 3 0 P o w e r P u m p i n g E q u i p m e n t - W a t e r T r e a t m e n t 31 1 - 4 0 P o w e r P u m p i n g E q u i p m e n t - T r a n s . & D i s l r b . 32 0 - 3 0 W a t e r T r e a t m e n t E q u i p m e n t 32 0 - 3 0 w a t e r T r e a t m e n t E q u i p m e n t - M e m b r a n e s 33 0 - 4 D i s t r b u t o n R e s e r v o i r s & S t a n d p i p e s 33 1 . 1 0 T r a n s . & D i s t r b . M a i n s & A c æ s s o r i e s - I n t a n g i b l e 33 1 . 2 0 T r a n s . & D i s t r i b . M a i n s & A c æ s s o r i e s - S O S 33 1 - 4 T r a n s . & D i s t r i b . M a i n s & A c s s o r i e s 33 3 - 4 S e r v i æ s 33 4 - 4 0 M e t e r a n d M e t e r I n s t a l l a t i o n s 33 5 - H y d r a n t s 33 6 - 4 B a c k o w P r e v e n t i o n D e v i æ s 33 9 . 1 0 O t h e r P l a n t & M i s c . E q u i p m e n t - I n t a n g i b l e 33 9 - 2 0 O t h e r P l a n t & M i s c . E q u i p m e n t - S o u r æ o f S u p p l y 33 9 - 3 0 O t h e r P l a n t & M i s c . E q u i p m e n t - W a t e r T r e a t m e n t 33 9 - 4 O t h e r P l a n t & M i s c . E q u i p m e n t - T r a n s . & D i s t r i b . 33 9 . 5 0 O t h e r P l a n t & M i s c . E q u i p m e n t - G e n e r a l P l a n 34 0 - 5 0 O f æ F u r n i t u r e a n d E q u i p m e n t 34 O - 5 A O A M I F M S y s t e m - ( G I S ) 34 0 A O A M I F M S y s t e m 34 0 . 5 H O C o m p u t e r E q u i p m e n t - H a r d w a r e 34 - 6 1 0 I T I n i t i a t i v e s & I F M S C o s t s 34 - 5 S 0 C o m p u t e r E q u i p m e n t - S o f t a r e 34 1 - 5 0 T r a n s p o r t t i o n E q u i p m e n t 34 2 - 5 0 S t o r e s E q u i p m e n t 34 3 - 5 0 T o 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 34 3 - 5 0 C o n f i n e d S p a æ M o n ~ o r , G e n e r a t o r , T r e n c h S h i e l d 34 - 5 0 L a b o r a t o r y E q u i p m e n t 34 5 - 5 0 P o w e r O p e r a t e d E q u i p m e n t 34 5 - 5 0 P o w e r O p e r a t e d E q u i p m e n t 34 6 - 5 0 C o m m u n i c a t i o n s E q u i p m e n t 34 7 - 5 0 M i s æ l l a n e o u s E q u i p m e n t 34 7 - 5 M i s æ l l a n e o u s E q u i p m e n t 34 8 - 5 0 O t h e r T a n g i b l e P r o p e r t 34 8 - 5 0 M a s t e r P l a n TO T A L . . RE E ! V i ' ) Pla n t I n S e r v i c e Ac t u a l J u n e 2 0 0 9 Pl a n t I n S e r v i c e Fo r e c a s t J u l y 2 0 0 9 Pl a n t I n s e r v i c e Fo r e c a s t A u g u s t 2 0 0 9 Pl a n t I n S e r v i c e 05 1 3 1 1 2 0 0 9 Ad d i t i o n s Re t i r e m e n t s 06 1 3 0 1 2 0 0 9 Ad d i t i o n s Re t i r e m e n t s 07 1 3 1 1 2 0 0 9 Ad d i t i o n s Re t i r e m e n t s ZO o Q 2 1 § 0 ~ l 3 PH 3: 5 8 10 4 , 5 4 10 4 , 5 4 8 10 4 , 5 4 8 lÐ i i ~ 1, 4 9 7 , 0 0 2 1,4 9 7 , 0 0 2 1, 4 9 7 , 0 0 2 UT l l J Z J = I 5,8 8 6 , 6 3 7 22 , 0 4 2 5,9 0 8 , 6 7 9 11 , 5 6 7 5,9 2 0 , 2 4 7, 6 6 0 14 5 , 2 9 7 14 5 , 2 9 7 14 5 , 2 9 7 14 5 , 2 9 7 1, 1 0 5 , 4 3 2 1,1 0 5 , 4 3 2 1, 1 0 5 , 4 3 2 1, 1 0 5 , 4 3 2 21 3 , 3 8 3 21 3 , 3 8 3 21 3 , 3 8 3 21 3 , 3 8 3 4,9 8 4 , 9 8 6 1, 3 3 0 4, 9 8 6 , 3 1 6 12 , 9 7 7 (1 , 5 0 0 ) 4, 9 9 7 , 7 9 3 58 , 3 2 7 (1 , 0 0 ) 5, 0 5 5 , 1 2 0 15 , 4 1 9 , 7 0 4 15 , 4 1 9 , 7 0 4 15 , 4 1 9 , 7 0 4 (3 7 6 ) 15 , 4 1 9 , 3 2 8 1,5 2 2 , 3 1 3 41 , 7 4 0 1,5 6 4 , 0 5 3 5,9 7 8 1, 5 7 0 , 0 3 1 (3 , 8 5 3 ) (5 0 0 ) 1, 5 6 5 , 6 7 8 3,0 2 7 , 5 1 3 44 1 3,0 2 7 , 9 5 4 6,4 8 8 3, 0 3 4 , 4 4 2 77 , 7 0 8 (2 7 , 9 5 9 ) 3, 0 8 4 , 1 9 1 83 , 2 1 7 83 , 2 1 7 83 , 2 1 7 83 , 2 1 7 1, 1 6 4 , 7 2 5 1,1 6 4 , 7 2 5 1, 1 6 4 , 7 2 5 1, 1 6 4 , 7 2 5 8,8 1 9 , 3 1 4 21 , 4 1 5 8,8 4 0 , 7 3 0 1, 2 7 3 8, 8 4 2 , 0 0 3 (3 0 2 ) 8, 8 4 1 , 7 0 1 60 , 3 5 1 60 , 3 5 1 60 , 3 5 1 60 , 3 5 1 2,2 0 5 , 5 8 2 2,2 0 5 , 5 8 2 2, 2 0 5 , 5 8 2 2, 2 0 5 , 5 8 2 1,3 4 0 , 7 5 2 6,7 2 2 1,3 4 7 , 4 7 4 (5 9 , 9 8 9 ) 1, 2 8 7 , 4 8 5 (2 , 7 2 4 ) 1, 2 8 4 , 7 6 1 17 , 5 8 6 , 6 0 1 12 4 , 3 9 0 (1 2 , 5 7 9 ) 17 , 6 9 8 , 4 1 2 2,2 1 0 (1 3 , 0 0 0 ) 17 , 6 8 7 , 6 2 2 16 , 0 3 9 (6 3 , 3 1 0 ) 17 , 6 4 0 , 3 5 1 . . . - 29 , 9 1 6 29 , 9 1 6 29 , 9 1 6 20 9 30 , 1 2 5 1,6 6 2 , 4 1 7 10 , 4 7 9 1,6 7 2 , 8 9 6 50 1, 6 7 2 , 9 4 6 (3 , 2 3 8 ) 1, 6 6 9 , 7 0 8 23 , 8 3 4 , 5 2 6 57 , 8 6 7 23 , 8 9 2 , 3 9 3 3,3 3 9 23 , 8 9 5 , 7 3 2 10 , 5 9 3 23 , 9 0 6 , 3 2 5 99 2 , 0 9 7 99 2 , 0 9 7 99 2 , 0 9 7 99 2 , 0 9 7 9,5 1 4 , 2 4 8 77 3 9,5 1 5 , 0 2 1 11 , 5 6 4 9, 5 2 6 , 5 8 5 (2 , 9 9 6 ) 9, 5 2 3 , 5 8 9 . . . . . 13 9 , 9 7 6 , 4 7 5 71 8 , 5 1 8 (1 0 0 , 6 6 6 ) 14 0 , 5 9 4 , 3 2 7 76 5 , 8 7 0 (2 1 , 9 1 8 ) 14 1 , 3 3 8 , 2 7 9 66 0 , 5 4 3 (4 , 8 1 0 ) 14 1 , 8 9 4 , 0 1 2 49 , 9 2 9 , 7 6 7 36 3 , 7 9 5 50 , 2 9 3 , 5 6 2 15 4 , 8 3 3 50 , 4 4 , 3 9 5 14 1 , 4 8 7 (6 , 0 2 9 ) 50 , 5 8 3 , 8 3 3 14 , 3 5 0 , 5 0 6 45 , 0 3 1 14 , 3 9 5 , 5 3 7 31 , 7 9 6 14 , 4 2 7 , 3 3 3 71 , 3 8 7 14 , 4 9 8 , 7 2 0 3,2 2 7 , 1 6 7 2,9 7 4 3,2 3 0 , 1 4 1 3,2 3 0 , 1 4 1 3, 2 3 0 , 1 4 1 - - - . - . . - -. . . - - . 72 2 , 7 6 3 9, 0 1 9 73 1 , 7 8 2 11 , 3 3 0 (4 2 5 ) 74 2 , 6 8 7 (1 3 1 ) (3 , 0 2 2 ) 73 9 , 5 3 4 55 2 , 9 1 0 55 2 , 9 1 0 55 2 , 9 1 0 55 2 , 9 1 0 1, 5 0 3 , 6 8 3 1, 5 0 3 , 6 8 3 1, 5 0 3 , 6 8 3 1,5 0 3 , 6 8 3 1,5 4 , 0 7 6 1, 5 4 5 , 0 7 6 1, 5 4 5 , 0 7 6 1,5 4 5 , 0 7 6 1,4 1 2 , 8 4 1, 4 1 2 , 8 4 3 1, 4 1 2 , 8 4 3 (3 , 6 4 1 ) 1,4 0 9 , 2 0 2 3, 8 0 6 , 5 5 4 5, 5 2 5 3,8 1 3 , 0 7 9 1, 9 2 1 3, 8 1 5 , 0 0 0 6, 1 6 1 (1 2 8 , 8 2 2 ) 3,6 9 2 , 3 3 9 51 , 3 5 6 51 , 3 5 6 51 , 3 5 6 51 , 3 5 6 31 , 9 1 7 31 , 9 1 7 31 , 9 1 7 31 , 9 1 7 60 7 , 3 4 1 63 6 60 7 , 9 7 7 60 7 , 9 7 7 (1 1 5 ) 60 7 , 8 6 2 ~- . - - 13 4 , 3 4 7 13 4 , 3 4 7 13 4 , 3 4 7 13 4 , 3 4 7 95 , 1 8 4 96 , 1 8 4 95 , 1 8 4 95 , 1 8 4 12 3 , 9 1 6 12 0 12 4 , 0 3 6 12 4 , 0 3 6 12 4 , 0 3 6 2, 1 0 5 , 9 9 0 5, 4 8 2 2, 1 1 1 , 4 7 2 64 0 (3 , 6 0 0 ) 2, 1 0 8 , 5 1 2 4, 3 6 4 2,1 1 2 , 8 7 6 23 9 , 7 1 3 23 9 , 7 1 3 23 9 , 7 1 3 23 9 , 7 1 3 16 4 , 6 5 3 16 4 , 6 5 3 16 4 , 6 5 3 16 4 , 6 5 3 1, 0 9 3 , 3 8 7 1, 0 9 3 , 3 8 7 1,0 9 3 , 3 8 7 1,0 9 3 , 3 8 7 20 0 , 2 0 7 39 , 5 5 0 23 9 , 7 5 7 14 , 7 5 2 25 4 , 5 0 9 98 , 1 2 5 35 2 , 6 3 4 32 3 , 0 6 6 , 3 1 6 1, 4 7 8 , 8 5 0 (1 1 3 , 2 4 5 32 4 , 4 3 1 , 9 2 1 97 6 , 5 9 9 40 . 4 4 3 ) 32 5 , 3 6 8 , 0 7 7 1, 0 3 5 , 2 0 7 1 /2 3 5 , 4 5 2 ) 32 6 , 1 6 7 . 8 3 2 W- 0 9 - 0 1 K. D o h e r t y . . . !l ¡ ~..i -g.. 1 :gci -= ~o.. i ~,g ~ :: :2 ~ f? ~ - 3:! ë ~ ~ ~~ ~ ~:: :5 ~ ~ fl ~ .5 ~ ¡; ..oi0)9 ~~~ :: . C' C' :;.0Q)..t:02_0Q)2 := -5 C\ .i Q):9Q)Q) ° ¡ß .i .i OlO" X (, ro .~WCla.:: I ~NO~N~om~~~~__N_~..OO.::ClNN....-NOIOCCDCJi~~~~~~~~~~ï~~~~~_~=~~N!;=~~_:CD2~~~vr ~ .,=~.; ~fI Ñ"=t:l !I ~~il;or ,, ølN :;: Iõ:;~~~~!5!~ :t Wl .. NO C" lØN Il CD""'"__CO..O..Io_cøor CI U! a, C' CD.. C" G! caiNl"IO.---....::~:te:;IØf'~...... .. t;:~=::~t¡="_om..."'..;t=~li~;t:;;!,. __N_04"Ñ .. Ij ~z i i i' .5 ~¡; ~ ô'0 Il ~E i: l "'0 0 "':~ N..~0 0 e NC0'"0 a~~~,.:!,. "ci l ~ t:..; 0.. ..~~.~.... .."'.. NN .. ~ ~ :: ~ ;:o I"' ~ ~ IlNN..NC"OeiClIO..IO__N....:OO.C"eiNN..N_NOlOeicø~t~a~ga~~i:aiagg~t...___NO..ION _00 NNcø..lI .. r4~"=ñ .,,, Ñ":t:i NOC"CDNcicø..N__ei..O..Io_cø~otC!°..rtG!l"cn..oc~&:s~~;::;;;t;..101Ø..ut.._.... CD,.,... .. ti:~~:!:3~~i=ii~ia~.. __NorOC"Ñ .. "'lØ....ci i¡~l~ "=f# .N ,. c" N "lN ei ci..~~~;.CD ii co ..Ii co 1f NÑõ"£fl;! IØ .. I~ I i; ~ :r Il i .5 i ~Il E! 1iII .."'.. ~:.~c ~'"0 ~::i!.. :i"::.."c( ¡;ë ¡ "' .. ..~i:.i:"'.. ..., .. .... .. ~.: I- ~ ~ '"i:Ñ t: ;: I CIN....NMOeieiO..IO__N.....OO.",CONN..C"_NOIOOCCDCÐi~á~i~~~~~~~~~~~~_~:~~N~;=~~~:.~~="'iô ., to..~.,fi .,.; Ñ..t:~"'. l!.. =t;;l;:_NIOOIO ~~~i~.... '"N fØ N .. _.. _ 0..en 0 _ _IÔÑÖÖCÐ N .. .._.. 10 NÑö.,';:! 10 _ NOC"lØNØlcø..N__~..OC"Io..cø-.. cr ca 0.. C'l' C".. ot at° NCO 10 en en _ _ ..t!=~:¡~IOC"fg.,.,.,CO.. ~:~~=:tõS:(it~i~i~i.. __N_O..Ñ ., i~ 1:l Jl i ë § ji: § §c(z ~ô'.. Il EEe! .."''"0 ~. '" .,~::0 e ..c ~~~i ~.::i..N"c( Ñ ~! =: ~ t;"'.. ...,.;..0'" .... .. "'i;~ t:": ¡; ~.::.. ::., 6a'C lë i ~¡; lo ..8: 8:-6~_ i ~ ~ ~ ~~ . ~-c._ 00 ~ ~m~ .-~~€_O ~õ~. ~ ~Ei~ ~~E~"fl w "'~ "en en~-" ~en~õ~~ ~~EE ø ~o llõl!C~ 0~ _ õ~~~~ g ~lå ~ ~~ ~~t~ë !~ i~ ~~Ø~I ~~t~ e w=~ c~~~~ ~~ §i¡~~~~~ ~~~~ ~ll¡l ~&~~~ ~~0~mo-0S~ø~ æ~~m æa~00 i I I I I ! m eeõa! ~ i I I I ~ EE~I-~ ~~00Ø ___~_~ m ~ ~ø~~~~000W= ~ ~~~~ Ic!8§ ~ CCC~Cæ ~ m ~C~Æ~~~~~~~~: ~ ~!l~i~¡~~~c ~ l(l(lli l~l- $~ ~~~_oõ~eiiEEEEol ~ ~ w"'''EE~~~~ ~ ~~~~~~~_ ~øeni "'~ EEE"e..0~~omømmc_ ~ '5~æEE~~0ø0Ø 5 ~~uuuuU0 IO'E æO ~~~mm~i ~ I I I ~ ~ ~ ~ ~ ~ ~ua~ ~&'5 3 ~ ~ £ ~ ø W W W W W W ~ -" u -" ~ !! ~ ~ 3 3 E E ~WtW0W~~~~C~ wE~~~auommm c c.... .~~ w- momu~u~&~~~~EE~~~~g! l ä~E$MWW~2~~ ~ ~~~g~~i i ~~~~E02iwwwiiegenggg---- ~5 ø ~ ~Q. ~ ooee ~~~~ l i~~~~~ I! E Ea~aw "," 3~"i ~wwQ. C ~ ~ ~ ~ ~ ! ~ ! ~ § ~ ~ ~ 0 ~ p ~ i i ~ ~ ~ E E S ~ ~ ~ ~ ~ ~ ~ ~ ! l i ~ ~ § i i m ~~ ~ g~ ~ ~o c~ c C c m m m m~ ~~O~ ~5 æ E eii c~~~ ~ Q.~---~-~E ~~w W",W¡3 ~&w i ~ m 0 O.~C~mæmmm0W~Wæm cmØ~æ mmoCOO C CCC~C øø~ ~ uO~~~~~GGcm~~æ~~~ ~ e e !s.~0~~om5ææ~~~~~~ ø m~ ~~~~~~ ~~~!a!äw~~soo c i i m~~~~~~~52~~n~~~~~~~~~~~~.. .!~C ~~~~~~~~~.~~~ø .~e~~~==~~ O~ l ~ l l l i ~ i B ~ l i i l l l l l ~ ~ ~ I ~ ~ ~ l ~ II ~o~'ol 01 ~o~ 01 ~;; r ~I-! r ~ i l 1 l l l ~ i l 1 j~ ~ ~ ~ ~ en en en en U ~ S £ en Q. Q. Q. Q. Q. sse I- I- I- en ~ ~ m 0 ~ ~ u _ U I- en I- U ~ Q. Q. U ~ ~ 0 ~ oo~ ° ° 000900 0 00 00 ° 0 ° ~ 000 00 ~ ~ g ego 0 0 S og~~ ~2~o 000 0 00 000 0 ° ¡ ~ , ~ i ~~ ~ ~ ~ 2 2 ~ ~ ~ 2 ~ ~ ~ i 2 ~ i ¡ ~ i i ~ i J ¡ 2 2 ~ i ~ ~ 10 ~ ~ ~ ~ ~ ~ ~ ~ ~~ i ~ ~ ~ ~00 S 0 0 000 0 0 0 0003_ _ __ _ N2.. ~.. CO C" CO M ~C""'''" ng2~ g ~~. ....~ i~~ ~e..: ~.. C" M M M""'" n"""" C""".. MC" CO"" C"""""""""".... "MMM.. M.. " M C" C" M"M C"M".. ~ ~ . Un i t e d W a t e r I d a h o Ut i l t y P l a n t I n S e r v i c e w i t h F o r e c a s t A d d i t i o n s a n d R e t i r e m e n t s Ca s e U W I - W - l 9 - l 1 Pl a n t Ac c o u n t Nu m b e r Pl a n t A c c o u n t D e s c r i p t i o n 30 1 - 1 0 O r g a n i z t i o n 30 3 - 2 0 L a n d & L a n d R i g h t s - S o u r c o f S u p p l y 30 3 - 2 W W a t e r R i g h t s - S o u r c e o f S u p p l y 30 3 - 3 0 L a n d & L a n d R i g h t s - W a t e r T r e a t m e n t 30 3 - 4 L a n d & L a n d R i g h t s - T r a n s . & D i s t r i b . 30 3 - 5 0 L a n d & L a n d R i g h t s - G e n e r a l P l a n t 30 4 - 2 0 S t r u c t u r e s a n d I m p r o v e m e n t s - S o u r c e o f S u p p l y 30 4 - 3 0 S t r u c t u r e s a n d I m p r o v e m e n t s - W a t e r T r e a t m e n t 30 4 0 S t r u c t u r e s a n d I m p r o v e m e n t s - T r a n s . & D i s t r i b . 30 4 - 5 0 S t r c t u r e s a n d I m p r o v e m e n t s - G e n e r a l P l a n t 30 5 . 2 0 C o 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 - S o u r c o f S u p p l y 30 6 - 2 0 L a k e , R i v e r & O t h e r I n t a k e s 30 7 . 2 0 W e l l s & S p r i n g s 30 8 - 2 0 I n f l t r a t i o n G a l l e r i e s & T u n n e l s 30 9 . 2 0 S u p p l y M a i n s 31 0 . 2 0 P o w e r G e n e r a t i o n E q u i p m e n t 31 1 . 2 0 P o w e r E l e c t r i c P u m p i n g E q u i p m e n t - S o u r c e o f S u p p l y 31 1 . 2 0 P o w e r D i e s e l P u m p i n g E q u i p m e n t - S o u r c e o f S u p p l y 31 1 . 3 0 P o w e r P u m p i n g E q u i p m e n t - W a t e r T r e a t m e n t 31 1 - 4 P o w e r P u m p i n g E q u i p m e n t - T r e n s . & D i s t i b . 32 0 - 3 W e t e r T r e a t m e n t E q u i p m e n t 32 0 - 3 W a t e r T r e a t m e n t E q u i p m e n t - M e m b r a n e s 33 0 - 4 D i s t r b u t i o n R e s e r v o i r & S t a n d p i p e s 33 1 . 1 0 T r a n s . & D i s t r b . M a i n s & A c c s s o r i e s - I n t a n g i b l e 33 1 - 2 0 T r a n s . & D i s t i b . M a i n s & A c c s s o r i e s - S O S 33 1 - 4 0 T r a n s . & D i s t r i b . M a i n s & A c c s s o r i e s 33 3 - 4 S e r i c e s 33 4 - M e t e r s a n d M e t e r I n s t a l l a t i o n s 33 5 - 4 H y d r e n t 33 8 - 4 0 B a c k o w P r e v e n t i o n D e v i c e s 33 9 . 1 0 O t h e r P l a n t & M i s c . E q u i p m e n t - I n t n g i b l e 33 9 . 2 0 O t e r P l a n t & M i s c . E q u i p m e n t - S o u r c e o f S u p p l y 33 9 - 3 0 O t h e r P l a n t & M i s c . E q u i p m e n t - W a t e r T r e a t m e n t 33 9 - 4 O t h e r P l a n t & M i s c . E q u i p m e n t - T r a n s . & D i s t r i b . 33 9 - 5 0 O t h e r P l a n t & M i s c . E q u i p m e n t - G e n e r a l P l a n t 34 0 - 5 0 0 O f f c e F u r n i t u r e a n d E q u i p m e n t 34 - 5 A O A M I F M S y s t e m - ( G I S ) 34 - 5 A O A M I F M S y s t e m 34 - 5 H O C o m p u t e r E q u i p m e n t - H a r d a r e 34 0 - 1 0 I T I n i t i a t i v e s & I F M S C o s t s 34 . 5 5 0 C o m p u t e r E q u i p e n t - S o f t a r e 34 1 . 5 0 T r a n s p o r t a t i o n E q u i p m e n t 34 2 - 5 S t o r e s E q u i p m e n t 34 3 . 5 0 T o 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 34 5 0 C o n f i n e d S p a c e M o n n o r , G e n e r a t o r , T r e n c h S h i e l d 34 4 0 L a b o r a t o r y E q u i p e n t 34 5 - 5 0 P o w e r O p e r a t e d E q u i p m e n t 34 8 - 5 0 P o w e r O p e r a t e d E q u i p e n t 34 6 5 0 C o m m u n i c a t i o n s E q u i p m e n t 34 7 - 5 0 M i s c e l l a n e o u s E q u i p m e n t 34 7 - 5 0 M i s c e l l a n e o u s E q u i p m e n 34 0 O t h e r T a n g i b l e P r o e r t y 34 - 5 0 M a s t e r P l a n TO T A L I Fo r e c a s t D e c e m b e r 2 0 0 9 Pla n t I n S e r v i c e Ad d i t i o n s Re t i r e m e n t s 12 1 1 / 2 0 0 9 10 4 , 5 4 8 1,4 9 7 , 0 0 2 12 , 1 9 8 5, 9 7 8 , 6 9 8 14 5 , 2 9 7 1, 1 0 5 , 4 3 2 21 3 , 3 8 3 5, 0 6 5 , 1 2 0 15 , 4 1 9 , 3 2 8 1, 5 8 9 , 5 7 8 3,2 4 9 , 1 2 5 83 , 2 1 7 1,1 5 4 , 7 2 5 8, 8 4 2 , 7 0 1 60 , 3 5 1 2, 2 0 5 , 5 8 2 1, 2 8 4 , 7 6 1 17 , 7 1 2 , 7 9 5 . 35 , 6 7 4 1, 8 9 7 , 2 3 0 23 , 9 2 0 , 3 4 9 99 2 , 0 9 7 9,5 2 3 , 5 8 9 -. 97 , 5 2 6 (7 , 6 0 0 ) 14 2 , 9 4 7 , 4 2 4 13 3 , 7 7 1 (1 3 0 , 7 0 0 ) 50 , 9 9 2 , 8 2 5 14 , 7 7 5 (4 3 0 , 0 0 0 ) 14 , 1 9 4 , 4 3 2 3, 2 3 0 , 1 4 1 .-.-- 74 0 , 1 1 2 55 2 , 9 1 0 1, 5 0 3 , 6 8 3 1, 5 4 5 , 0 7 8 1, 4 0 9 , 2 0 2 3,7 1 1 , 9 7 8 51 , 3 5 6 31 , 9 1 7 80 7 , 8 6 2 13 4 , 3 4 7 95 , 1 8 4 12 4 0 3 6 2, 1 5 7 , 8 9 5 23 9 , 7 1 3 15 4 6 5 3 1, 0 9 3 , 3 8 7 7, 1 6 8 38 1 , 3 0 8 I 28 5 , 4 3 8 1 (5 6 8 , 3 0 0 ) 32 7 , 7 6 7 , 8 2 1 . . Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 3 Pa g e 3 o f 3 K. D o h e r t y . Li n e N o . De s c r i p t i o n 1 A c c m u l a t e d D e p r e c i a t i o n - R e c o r d e d 2 I n c r m e n t a l D e p r e c i a t i o n 3 R e t i r e m e n t s 4 C o s t o f R e m o v a l 5 S a l v a g e 6 T o t a l A c c m u l a t e d D e p r e i a t i o n 7 C I A C A m o r t z a t i o n - R e c o r d e d 8 I n c r e m e n t a l C I A C A m o r t i z a t i o n 9 T o t a l C I A C A m o r z a t i o n . Un i t e d W a t e r I d a h o Ca s e U W I - W - 0 9 - 0 1 Ac c u m u l a t e d D e p r e c i a t i o n A n d A c c u m u l a t e d C I A C A m o r t z a t i o n Re c o r d e d A m o u n t s Fo r e c a s t e d A m o u n t s . 12 1 3 1 1 0 8 11 3 1 1 0 9 21 2 8 1 0 9 31 3 1 1 0 9 41 3 0 1 0 9 51 3 1 1 0 9 61 3 0 1 0 9 71 3 1 1 0 9 81 3 1 1 0 9 91 3 0 1 0 9 10 1 3 1 1 0 9 11 1 3 0 1 0 9 12 1 3 1 1 0 9 (6 8 , 0 7 5 , 4 5 1 ) (6 8 , 6 2 5 , 4 8 6 ) (6 9 , 2 4 1 , 4 0 1 ) (6 9 , 8 3 0 , 9 1 7 ) (7 0 , 4 2 0 , 6 5 8 ) (7 0 , 9 8 2 , 3 5 8 ) (5 9 9 , 7 8 6 ) (6 0 1 , 4 9 3 ) (6 0 1 , 7 8 4 ) (6 0 2 , 2 8 3 ) (6 0 3 , 7 3 4 ) (6 0 4 , 9 3 5 ) (6 0 5 , 0 0 5 ) 11 3 , 2 4 5 40 , 4 3 23 5 , 4 5 2 14 , 4 0 2 98 3 43 , 7 1 7 56 8 , 3 0 0 4, 8 1 7 60 0 26 , 6 0 7 2,5 1 3 23 3 2, 3 1 3 13 , 7 0 0 /6 , 3 5 0 1 /6 8 , 0 7 5 , 4 5 1 ) / 6 8 , 6 2 5 , 4 8 6 ) /6 9 , 2 4 1 , 4 0 1 ) /6 9 , 8 3 0 , 9 1 7 17 0 , 4 2 0 , 6 5 8 ) 1 7 0 , 9 8 2 , 3 5 8 ) 17 , 4 6 4 , 0 8 2 ) 1 7 2 , 0 2 4 , 5 3 3 ) 1 7 2 , 3 7 0 , 6 0 8 ) 1 7 2 , 9 5 5 , 9 7 6 ) 1 7 3 , 5 5 8 , 4 9 3 ) / 7 4 , 1 1 7 , 3 9 9 ) 1 7 4 , 1 4 0 , 4 0 4 ) ~¡=:: O-) i rn : i (1 0 Ca s e N o . U W I . W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 4 Pa g e 1 o f 1 .. . : i ~ ~: . ,.~(,~I(¡-a:: 'fai CD "~:;m()m . . . Un i t e d W a t e r I d a h o Ca s e U W I - W - 0 9 - 0 1 De v e l o p e r A d v a n c e s f o r C o n s t r c t i o n S u b j e c t t o R e f u n d Li n e N o . Mo n t h Pl a n t A c c o u n t 30 1 1 0 30 3 2 0 30 4 2 0 30 7 2 0 30 9 2 0 31 1 2 0 32 0 3 0 33 0 4 0 33 1 4 0 33 3 4 0 33 5 4 0 34 6 5 0 Or g a n i z a t i o n So u r c e o f So u r c e o f So u r c e o f So u r c e o f So u r c e o f Wa t e r T & D P l a n t : T & D P l a n t : T & D P l a n t : T& D Ge n e r a l P l a n t : AI A C I N Su p p l y an d Su p p l y an d Su p p l y an d Su p p l y an d Su p p l y an d Tr e a t m e n t Pu m p i n g Pu m p i n g Pu m p i n g Pl a n t : Di s t r i b u t i o n Pu m p i n g Pu m p i n g Pl a n t : Co m m u n i c a t i o n Pl a n t : L a n d Pl a n t : Pl a n t : Wa t e r Re s e r v o i r s & & La n d Str u c t u r e s & Pla n t : W e l l s P l a n t : S u p p l y Pu m p i n g Tr e a t m e n t Mo n t h l y Mo n t h l y Ri g h t s Im p r o v e m e n t s & Sp r i n g s Ma i n s Eq u i p m e n t Eq u i p m e n t S t a n d p i p e s Ma i n s Se r v i c e s Hy d r a n t s Eq u i p m e n t CW I P Ac t i v i t y Ba l a n c e Be g i n n i n g B a l a n c e Ma y 3 1 , 2 0 0 9 $ 6,9 8 6 $ 37 6 , 8 7 8 $ 79 , 4 9 2 $ 56 4 , 7 2 6 $ 37 4 , 2 7 3 $ 46 2 , 0 1 8 $ 3,3 8 4 $ 1 , 0 5 4 , 3 3 9 $ 3 , 3 1 1 , 4 8 6 $ 6 0 , 5 6 0 $ 6, 9 8 6 $ 34 , 5 8 3 $1 6 9 , 0 3 3 $ 7 , 0 5 0 , 7 4 3 2 Ju n e 0 9 A c t i v i t y 3 Ju n e 0 9 B a l a n c e 6, 9 8 6 37 6 , 8 7 8 79 , 4 9 2 56 4 , 7 2 6 37 4 , 2 7 3 46 2 , 0 1 8 3, 3 8 4 1, 0 5 4 , 3 3 9 3, 3 1 1 , 4 8 6 60 6 , 5 6 0 6, 9 8 6 34 , 5 8 3 16 9 , 0 3 3 7,0 5 0 , 7 4 3 4 Ju l y 0 9 A c t i v i t y 5 Ju l y 0 9 B a l a n c e 6, 9 8 6 37 6 , 8 7 8 79 , 4 9 2 56 4 , 7 2 6 37 4 , 2 7 3 46 2 , 0 1 8 3, 3 8 4 1, 0 5 4 , 3 3 9 3, 3 1 1 , 4 8 6 60 6 , 5 6 0 6, 9 8 6 34 , 5 8 3 16 9 , 0 3 3 7,0 5 0 , 7 4 3 6 Au g u s t 0 9 A c t v i t y (2 1 , 8 0 0 ) (2 1 , 8 0 0 ) 7 Au g u s t 0 9 B a l a n c e 6, 9 8 6 37 6 , 8 7 8 79 , 4 9 2 56 4 , 7 2 6 37 4 , 2 7 3 46 2 , 0 1 8 3, 3 8 4 1,0 5 4 , 3 3 9 3, 2 8 9 . 6 8 6 60 6 , 5 6 0 6, 9 8 6 34 , 5 8 3 16 9 , 0 3 3 7,0 2 8 , 9 4 3 8 Se p t . 0 9 A c t i v i t y (2 1 , 8 0 0 ) (2 1 , 8 0 0 ) 9 Se p l 0 9 B a l a n c e 6, 9 8 6 37 6 , 8 7 8 79 , 4 9 2 56 4 , 7 2 6 37 4 , 2 7 3 46 2 , 0 1 8 3, 3 8 4 1, 0 5 4 , 3 3 9 3, 2 6 7 , 8 8 6 60 6 , 5 6 0 6. 9 8 6 34 , 5 8 3 16 9 , 0 3 3 7,0 0 7 , 1 4 3 10 Oc t o b e r 0 9 A c t i v i t y (2 1 , 8 0 0 ) (2 1 , 8 0 0 ) 11 Oc t o b e r 0 9 B a l a n c e 6, 9 8 6 37 6 , 8 7 8 79 , 4 9 2 56 4 , 7 2 6 37 4 , 2 7 3 46 2 , 0 1 8 3, 3 8 4 1,0 5 4 , 3 3 9 3, 2 4 6 , 0 8 6 60 6 , 5 6 0 6, 9 8 6 34 , 5 8 3 16 9 , 0 3 3 6, 9 8 5 , 3 4 3 12 No v , 0 9 A c t i v i t y (2 1 , 8 0 0 ) (2 1 , 8 0 0 ) 13 No v . 0 9 B a l a n c e 6, 9 8 6 37 6 , 8 7 8 79 , 4 9 2 56 4 , 7 2 6 37 4 , 2 7 3 46 2 . 0 1 8 3, 3 8 4 1, 0 5 4 , 3 3 9 3, 2 2 4 , 2 8 6 60 6 , 5 6 0 6, 9 8 6 34 , 5 8 3 16 9 , 0 3 3 6, 9 6 3 , 5 4 3 14 De c . 0 9 A c t i v i t y (2 1 , 8 0 0 ) (2 1 , 8 0 0 ) En d i n g B a l a n c e . 15 De c e m b e r 3 1 , 2 0 0 9 $6 , 9 8 6 $3 7 6 , 8 7 8 $7 9 , 4 9 2 $5 6 4 , 7 2 6 $3 7 4 , 2 7 3 $4 6 2 , 0 1 8 $3 , 3 8 4 $1 , 0 5 4 , 3 3 9 $3 , 2 0 2 , 4 8 6 $6 0 6 , 5 6 0 $6 . 9 8 6 $3 4 , 5 8 3 $1 6 9 , 0 3 3 $6 , 9 4 1 , 7 4 3 C f" C a s e N o . U W I - W - 0 9 - 0 1 (1 0 9 , 0 0 0 ) -l g E x h i b i t No . 13 F_ .. S c h e d u l e 5 =t o (/ P a g e ; 1 -) l r: m m. . m- I 0 0 m (J ' * ~ Co , ; OJc: "':: rnr. : ""..(, \D Ltn e N o Mo n t Be g i n n i n g B a l a c e Ma y 3 1 , 2 0 0 B Ju n e 0 9 A c v i t y Ju n e O S B a l a n c e 4 J u l y 0 9 A c t v i t y 5 J u l y O S B a l a n c e 6 A u g u s t O g A c t v i t y 7 A u g u s t O S B a l a n c e 8 S e p L . O S A c t v i t 9 S e p l O S B a l a n c e 10 O c o b e r O g A c t v i t y 11 O c t o b e r 0 9 B a l a n c e 12 N o v . 0 9 A c t v i t y 13 N o v . 0 9 B a l a n c e 14 D e " , 0 9 A c t v i En d i n g B a l a n c e 15 D e b e r 31 . Z1 9. . Un i t e d W a t e r I d a h o Ca s e U W I - W . a 9 . a l 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 Pl o n t A e c . 30 1 1 0 30 3 2 0 & 4 0 30 2 0 30 $ 2 0 30 7 2 0 30 9 2 0 31 1 2 0 32 0 33 0 4 33 1 4 0 33 3 4 0 33 4 33 5 4 34 0 5 0 34 5 0 Or g a n i z o n So r e o f So u r ç e o f So u r c of So u r c o f So u r c o f So u r c o f Wo t r T& D P l o n t : T& D P I a T& D P l o n t T & D P i o n t T & D P l a : Go n l Ge n r a l CI A C I N Su p p l y o n Su p p l y an d Su p p l y o n Su p p l y an d Su p p l y an d Su p p l y an d Tr o n t Pu m p i n g P l a n P u m p i n g P l a n t : Pu p l n S DI s t b u o n Me t r s & Pl a n t : o m e e Pl a n t Pu m p i n g P l a n t : P u m p i n g P l a n t : Pu m p i n g PL O n W o t r an d T & D P l a C o l l e c t & Pla n : Re s e r v o i r s & Mo t r Fu m l t r e & La b o r a t o r y Mo n t l y Mo n l y La d & L a d Str c t r e s & Im p o i n g We l l o & Plo n t : S u p p l y Pu m p i n g Tr e e n t Ba l a G r o s s Ba l a c e C I A C Rl a h t Im i n o v e m e n Re s e r v o i r s Sn r l n d s Ma i n Eo u l o m n t Eo u l o m n t Sl a d o " " _ Ma i n s Se r v i c e In s t a l l a t i o n Hv d r a Eo u l o m Eo u l D m o n t CW I P CI A C Am o r t t k No t C i A C $ 9.$ 7 $ $ 32 5 . 4 0 $ 33 1 , _ $ 21 , 9 5 0 $ 1, 3 9 7 , 3 1 0 $ 9. 3 9 1 $ 1 . 8 3 , 3 5 8 $ 34 , 5 7 0 $ 1 , 1 8 3 , 7 9 4 $ 6 9 , 2 2 8 , 5 7 1 $ 1 1 , 7 4 4 , 1 0 5 $ 19 1 , 5 1 7 $ 4 6 9 , 8 4 3 $ 1,1 3 1 $ 16 , 7 2 9 $ ( 7 2 . 1 9 6 ) $ 86 , 6 5 6 , 9 9 9 $ ( 1 5 , 0 8 4 , 9 7 5 ) $ 7 1 , 5 7 2 , 0 2 4 41 9 4 2 6 18 7 4 4 63 , 7 9 1 50 1 9 6 1 9, 8 7 8 32 5 , 4 0 5 33 1 , 6 4 4 21 , 9 5 0 1, 3 9 7 , 3 1 0 9,3 9 1 1,7 8 3 , 3 5 8 34 , 5 7 0 1,1 6 3 . 7 9 4 69 , 6 4 7 , 9 9 7 11 , 7 6 2 , 8 4 9 25 5 , 3 0 8 46 9 , 8 4 3 1,1 3 1 16 , n 9 (7 2 , 1 9 6 ) 87 , 1 5 8 , 9 6 0 (1 5 , 2 3 9 , 2 0 6 ) 71 , 9 1 9 , 7 5 4 30 6 4 4 4 98 6 1 31 6 3 0 5 9,8 7 8 32 5 , 4 0 5 33 1 , _ 21 , 9 5 0 1, 3 9 7 , 3 1 0 9, 3 9 1 1, 7 8 3 , 3 5 8 34 , 5 7 0 1, 1 8 3 , 7 9 4 69 , 9 5 4 , 4 4 1 11 , 7 7 2 , 7 1 0 25 5 , 3 0 8 46 9 , 8 4 3 1,1 3 1 16 , 7 2 9 (7 2 , 1 9 6 ) 87 , 4 7 5 , 2 6 5 (1 5 , 3 9 4 , 1 3 9 ) 72 , 0 8 1 , 1 2 7 28 7 , 9 n 16 7 3 2 45 0 0 0 34 9 7 0 4 9,9 7 9 32 5 , 4 0 5 33 1 , 6 4 4 21 , 9 5 0 1,3 9 7 . 3 1 0 9.3 9 1 1.7 8 3 , 3 5 9 34 , 5 7 0 1,1 6 3 , 7 9 4 70 , 2 4 2 , 4 1 3 11 , 7 8 9 , 4 4 2 30 0 . 3 0 8 46 9 , 8 4 3 1,1 3 1 16 , 7 2 9 (7 , 1 9 6 ) 87 , 8 2 4 , 9 6 9 (1 5 , 5 4 9 , 6 4 1 ) 72 , 2 7 5 , 3 2 12 4 9 1 5 13 1 4 1 13 8 0 5 6 9,8 7 8 32 5 , 4 0 5 33 1 , 6 4 4 21 , 9 5 0 1,3 9 7 . 3 1 0 9.3 9 1 1,7 8 3 . 3 5 8 34 , 5 7 0 1,1 6 3 , 7 9 4 70 , 3 6 7 , 3 2 8 11 , 8 0 2 , 5 8 3 30 0 , 3 0 8 46 9 , 8 4 3 1, 1 3 1 16 , 7 2 9 (7 2 , 1 9 6 ) 87 , 9 6 3 , 0 2 5 (1 5 , 7 0 5 , 5 6 5 ) n, 2 5 7 , 4 6 0 84 9 1 5 13 1 4 1 98 0 5 6 9, 8 7 8 32 5 , 4 0 5 33 1 , 6 4 4 21 , 9 5 0 1,3 9 7 . 3 1 0 9,3 9 1 1.7 8 3 , 3 5 6 34 , 5 7 0 1,1 6 3 , 7 9 4 70 , 4 5 2 , 2 4 3 11 , 8 1 5 , n 4 30 0 , 3 0 8 46 9 , 8 4 3 1.1 3 1 16 , 7 2 9 (7 . 1 9 6 ) 88 , 0 6 1 , 0 8 1 (1 5 , 8 6 1 , 8 9 2 ) 72 , 1 9 9 . 3 0 84 9 1 5 13 1 4 1 98 0 5 6 9, 8 7 8 32 5 , 4 0 5 33 1 , _ 21 . 5 0 1,3 9 7 , 3 1 0 9,3 9 1 1,7 8 3 , 3 5 8 34 , 5 7 0 1,1 6 3 , 7 9 4 70 , 5 3 7 , 1 5 8 11 , 8 2 8 , 8 6 5 30 0 , 3 0 8 46 9 , 8 4 3 1,1 3 1 16 , 7 2 9 (n , I 9 6 ) 88 , 1 5 9 , 1 3 7 (1 6 , 0 1 7 , 9 8 7 ) n,1 4 1 , 1 5 0 84 9 1 5 13 1 4 1 9.2 0 0 10 7 , 2 5 6 9. 7 9 32 5 4 0 5 33 1 8 4 4 21 8 5 0 13 9 7 3 1 0 93 9 1 17 9 3 . 5 8 34 5 7 0 11 6 3 7 9 4 70 6 2 2 . 7 3 11 . 4 2 0 0 6 30 9 5 0 8 46 9 8 4 3 11 3 1 16 7 2 9 /7 2 1 9 6 1 $ 88 . 2 6 6 3 9 3 $ 1 1 5 1 7 4 4 6 1 7. . ' 1 9 3 2 . - - - - _ . S?- :: O ñi 5 ' mO i: ü 0c : ~t : 1 J s. C (ñ o (JÕz 1,6 0 9 , 3 9 4 Cu e N o . U W - W . . 9 - o 1 Ex h l b f N o . 1 3 Sc h d u l e ' P_ l o f l K. D _ r t ~~-0 ,eN :;m("rn'. . -0:s W) ..c. \D . . . United Water Idaho Case UWI-W-0-Ø1 Summary of Net Utilit Plant Acquisiton Adjustments Line No.Acquistion Description IPUC Order AmortzatonMonth PeriodCompany Project 10 X00009 X00010 XOOO11 XOOO14 X00020 X00027 Aug-96 May-95 Apr-95 Sep-OO Jan-99 Jan-99 1 Warm Springs Mesa 2 Redwood Creek 3 Island WOds 4 Raintre 5 South County Water 6 Barbr Water Monthly Ending Month Amortzation Balance December-08 $545.574 January-09 ($777)544,797 February-09 rT77 544,019 March-09 rT77)543,242 April-09 rm)542,465 May-09 (777)541,687 June-09 rT77)540,910 July-09 rT77)540,132 August-09 rT77)539,355 September-09 (777)538,577 October-09 rT77)537,800 November-09 (777)537,023 Decmber-09 i777í 536,245 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Years 20 Years 20 Years 40 Years 40 Years 40 Years utlity Plant Acquisition Adjustment Amount $62,302 (110,249) (179,675) (227,594) 1,009,011 46,966 $600,762 Accumulated Amortzation ofUPAA Through 12131/08 ($38,419) 75,796 122,778 47,474 (252,249) (10,567) ($55,18V Unamortized Balance at 12131/08 Monthly Amortization Amount $23,883 (34,453) (56,897) (180,120) 756,762 36,399 $545,574 ($260)459 749 474 (2,102) (98) ($77V $9,329Annual Amortzaon Amount Case No. UWI-W-G9-G1 Exhibit No. 13 Schedule 7 Page 1 of1 K. DohertC ~ :: egr__ (/ :;::o r" rnrñ~ -0 ("(10 t rri 8-0 U)_c -0:;;: ~;.c-- ~. (,.(f;¡~ .~. ...OJ. c.Õ \D;¡ . Line No. .10 11 . United Water Idaho Case UWI-W-09-01 Accumulated Deferred Income Taxes as of December 31, 2009 Account & Description 1 2 3 4 5 6 7 8 Accumulated Deferred FIT-MACRS Accumulated Deferred FIT Cost of Removal Accumulated Deferred FIT AFUDC Equity Def. FIT-Tank Painting Def. SIT - Tank Painting Def. SIT-AFUDC Equity Def. SIT-Excess Depree. Def. SIT-Cost of Removal 9 Accumulated Deferred Income Taxes at May 31, 2009 Pro Forma Tax Depreciation Pro Forma Book Depreciation 12 13 14 Excess Tax Over Book Depreciation State Income Tax Rate Incremental State Deferred Income Tax 15 16 17 18 19 Excess Tax Over Book Depreciation Less: State Deferred Income Tax Federal Amount Federal Income Tax Rate Incremental Federal Deferred Income Tax 20 Total Incremental Deferred Income Taxes 21 Total Deferred Income Tax (Line 9 + Line 20) RECE r'¡l~I 2009 SEP -3 PH 3: 59 IDAHO PUBUQ UTiLITIES COMMisSION Balance at May 31, 2009 Pro Forma Balance at December 31, 2009 $7,242,063 162,946 167,474 86,025 26,776 37,810 2,216,073 36,876 $9,976,043 Case No. UWI-W-09-Q1 Exhibit No. 13 Schedule 8 Page 1 of 1 K.Dohert $7,392,068 7,255,334 $136,734 7.60% 10,392 $136,734 10,392 126,342 35.00% 44,220$ $ $ 54,612 10,030,655 . . . United Water Idaho Case No UWI-W-09-o1 Pre-1971 Investment Tax Credit RECE zan, SEP -3 PM 3: 59 \DAnO PUBU~~S\ON UT\L1T\ES COMM\S L" N Book Balance Annual B k L"f t 12/31/08 E Monthly Eyine0ear00ieaxpensexpense 1 1962 50 Years $560 $182 $15 2 1963 50 Years 539 134 11 3 1964 50 Years 488 99 8 4 1965 50 Years 1,064 176 15 5 1966 50 Years 939 136 11 6 1967 50 Years 1,006 124 10 7 1968 50 Years 2,329 258 22 8 1969 50 Years 1,748 176 15 9 I $8,673 $1,285 $107 10 Month Balance 11 Dec-08 $8,673 12 Jan-09 8,566 13 Feb-09 8,459 14 Mar-09 8,352 15 Apr-09 8,245 16 May-09 8,138 17 Jun-09 8,031 18 Jul-09 7,923 19 Aug-09 7,816 20 Sep-09 7,709 21 Oct-09 7,602 22 Nov-09 7,495 23 Dec-09 7,388 Case No. UWI-W-09-01 Exhibit No. 13 Schedule 9 Page 1 of 1 K.Dohert . . . Un i t e d W a t e r I d a h o Ca s e U W - W - 0 9 - o 1 De f e r r e d D e b i t s B a l a n c e In c l u d e d i n R a t e B a s e Li n e N o . A m o u n t s A p p r o v e d I n C a s e U W I - W . 0 4 - 0 4 : De s c r i p t i o n 1 D e f e r r e d R a t e C a s e E x p e n s e U W I - W - 0 4 - 0 4 2 D e f e r r e d R e l o c a t i o n C o s t 3 D e f e r r e d R e n t s ( L a k e w o o d W e l l L e a s e ) 4 D e f e r r e d L T 2 E S w r R 5 D e f e r r e d T e r r a G r a n d e C o s t 6 D e f e r r e d L e g a l E x p e n s e I P C O R a t e C a s e 7 D e f e r r e d T a n k P a i n t i n g - E x i s t i n g 8 D e f e r r e d T a n k P a i n t i n g - N e w 9 D e f e r r e d A F U D C E q u i t y I n c o m e 10 S u b T o t a l Am o u n t s A p p r o v e d I n C a s e U W I . W - 0 6 - o 2 : De f e r r e d R C E x p e n s e f r o m U W I - W - 0 4 - 0 4 N o t 11 a d d r e s s e d i n O r d e r 12 D e f e r r e d R C E x p e n s e f r o m U W I - W - 0 6 - 0 2 13 D e f e r r e d T a n k P a i n t i n g - F e d e r a l R e s e r v o i r 14 D e f e r r e d A F U D C E q u i t y I n c o m e 15 R e m o v e U n a m o r t i z e d R C ( l i n e s 1 1 & 1 2 ) 16 S u b T o t a l 17 D e f e r r e d R C E x p e n s e f r o m C u r r e n t F i l n g 18 D e f e r r e d T a n k P a i n t i n g - C o m p l e t e d ( U s t i c k ) 19 D e f e r r e d T a n k P a i n t i n g - P l a n n e d (S t e e l h e a d & H i l c r e s t $ 1 0 0 k e a c h & C r e s t l i n e $ 7 6 k ) 20 C o n s e r v a t i o n P l a n a n d R e l a t e d C o s t s 21 D e f e r r e d A F U D C E q u i t y I n c o m e 22 S u b T o t a l 23 G r a n d T o t a l Un a m o r t i z e d Un a m o r t i z e d Am o r t i z a t i o n Ba l a n c e a t Ap p r o v e d Ba l a n c e a t Pe r i o d i n Mo n t h l y An n u a l De c e m b e r 3 1 , Am o u n t s Ma y 3 1 , 2 0 0 9 Mo n t h s Ex p e n s e Ex p e n s e 20 0 9 $2 3 6 , 4 6 7 $9 , 8 5 3 48 $4 , 9 2 6 $0 $0 80 , 0 0 0 18 , 6 6 7 60 1, 3 3 3 16 , 0 0 0 9, 3 3 3 19 , 0 9 0 16 , 7 9 0 60 0 46 55 2 16 , 4 6 8 12 , 0 0 0 2, 8 0 0 60 20 0 2, 4 0 0 1, 4 0 0 3, 8 7 7 90 4 60 65 77 5 45 2 8. 3 7 4 1, 9 5 4 60 14 0 1, 6 7 5 97 7 15 , 5 4 8 3, 8 7 0 12 0 25 8 3, 0 9 6 2, 0 6 4 60 , 9 0 8 49 , 2 3 3 24 0 25 4 3, 0 4 5 47 , 4 5 7 69 6 , 3 4 6 69 6 , 3 4 6 N/ A N/ A 69 6 , 3 4 6 - $1 , 1 3 2 , 6 1 0 $8 0 0 , 4 1 7 $7 , 2 2 2 $2 7 , 5 4 4 $7 7 4 , 4 9 7 $2 0 4 , 7 0 3 $5 9 , 7 0 5 48 $4 , 2 6 5 $5 1 , 1 7 6 $2 9 . 8 5 3 11 0 , 1 6 8 32 , 1 3 2 48 2, 2 9 5 27 , 5 4 2 16 , 0 6 6 16 2 , 8 9 5 13 9 , 8 1 8 24 0 67 9 8, 1 4 5 13 5 , 0 6 7 23 2 , 3 4 2 23 2 , 3 4 2 N/ A N/ A 23 2 , 3 4 2 (4 5 , 9 1 9 ) $7 1 0 , 1 0 8 $4 6 3 , 9 9 8 $7 , 2 3 9 $8 6 , 8 6 3 $3 6 7 , 4 0 9 Pr o p o s e d Un a m o r t i z e d Ne w It e m s Am o r t i z a t i o n P r o p o s e d P r o p o s e d Ba l a n c e a t Pr o p o s e d I n Pe r i o d I n Mo n t h l y An n u a l De c e m b e r 3 1 , ~ Cu r r e n t C a s e Mo n t h s Ex p e n s e Ex p e n s e 20 0 9 S $ - 19 8 , 8 8 4 36 5, 5 2 5 66 , 2 9 5 19 8 . 8 8 4 r- _ ~ ;0 :: O 74 , 1 8 2 24 0 30 9 3, 7 0 9 74 , 1 8 2 fi ~ "' rn 27 6 , 0 0 0 24 0 1, 1 5 0 13 , 8 0 0 27 6 , 0 0 0 l (' (P O (# rn 0 -, 2 19 5 , 2 6 4 36 5, 4 2 4 65 , 0 8 8 19 5 , 2 6 4 O~ 13 3 , 4 5 4 N/ A N/ A 13 3 , 4 5 4 .. en 3: 0 ) :J 3: r ~ :; : J $8 7 7 , 7 8 4 $1 2 , 4 0 8 $1 4 8 , 8 9 2 $8 7 7 , 7 8 0 4 (J ; , (,.. (, " c. $2 , 1 4 2 , 1 9 9 $~ , 8 6 _ 8 _ _ $ 2 6 3 , ~ ~ _ $2 , 0 1 9 , 6 9 0 Õ \. Z Ca s e N o . U W I - W - 0 9 - o 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 0 Pa g e 1 o f 1 K. D o h e r t .Ut i l t y P l a n t In v e s t m e n t s Cu r r n t A s s e t s ut i l t y P l a n t - O t h e r Ut i l i t y P l a n t - L a n d Ut i l i t y P l a n t - B u i l d i n g s Uti l i t y P l a n t i n S e r v c e - T r a n s p o r t t i o n Ut i l i t y r e t i r e m e n t s Co n s t r c t o n w o r k I n p r o g r e s s Ut i l i t y p l a n t a c q u i s i t i o n a d j u s t m e n t Ut i l i t y A c c m D e p r e e - O t h e r P l a n t Ut i l A c c u m D e p r e e - T r a n s p o r t t i o n Re t i r e m e n t w o r k i n p r o g r e s s Ut i l i t y A c c u m u l a t e d D e p r e c i a t i o n - C I A C Am o f u t i l i t p l a n t a c q u i s i t i o n a d j u s t m e n t No n - U t i l i t y P r o p e r t - O t h e r Op e r a t i o n s C a s h A c c u n t C u r r n t Co l l e c t o n s Di s b u r s e m e n t s ( l o c l a c c o u n t s ) Wo r k i n g F u n d s Cu s t o m e r A c c o u n t s R e c e i v a b l e U B S Ac c u n t s R e c i v a b l e - S p r i n g P r o g Ac c u n t s R e c e i v a b l e - O t h e r Ac c u n t s r e c e i v a b l e - M & J Pr o v i s i o n f o r U n c o l l e c t o n A c c u n t s ( C r ) Ca p i t a l & M a i n t e n a n c e I n v e n t o r y N o n e x e m p t Sm a l l R e p a i r s I n v e n t o r y E x e m p t Oth e r I n v e n t o r y Ch e m i c a l In v e n t o r y Pr e p a i d D u e s Pr e p a i d P e n s i o n Un b i l e d R e v e n u e . Un i t e d W a t e r I d a h o Ca s e N o . U W I - W - 0 9 - 0 1 Wo r k i n g C a p i t a l C a l c u l a t i o n Re g u l a t o r y B a l a n c e S h e e t No n - C a s h O t h Pl a n t a n d R a t e B In v e n t o r y , Su p p l i e s & C 01 , C .. . . . . - - - , - - - - .. . . - - - _ . -- -- - - -- _ . . -- - . . _ . . . - . 32 3 , 2 0 4 , 8 7 1 32 3 , 2 0 4 , 8 7 1 0 0 0 (1 3 8 , 5 5 4 ) (1 3 8 , 5 5 4 ) 1,9 9 7 , 4 8 5 1, 9 9 7 , 4 8 5 60 0 , 7 6 1 60 0 , 7 6 1 (7 0 , 9 9 9 , 6 0 9 ) (7 0 , 9 9 9 , 6 0 9 ) 0 17 , 2 5 1 17 . 2 5 1 (1 5 , 0 8 4 , 9 7 5 ) (1 5 , 0 8 , 9 7 5 ) (5 9 , 0 7 5 ) (5 9 , 0 7 5 ) 11 , 0 5 4 11 , 0 5 4 (2 , 6 1 2 , 7 4 0 ) (2 , 6 1 2 , 7 4 0 ) 41 , 0 0 0 41 , 0 0 0 10 0 10 0 9, 9 5 0 9, 9 5 0 89 0 , 8 1 6 89 0 , 8 1 6 0 0 68 , 4 1 9 68 , 4 1 9 83 , 5 8 4 83 , 5 8 4 (2 8 , 7 0 0 ) (2 8 , 7 0 0 ) 60 , 5 5 1 60 , 5 5 1 13 0 , 1 8 7 13 0 , 1 8 7 28 , 4 1 3 28 , 4 1 3 14 5 , 4 2 8 14 5 , 4 2 8 (1 4 , 0 4 5 ) (1 4 , 0 4 5 ) (9 , 0 5 1 , 4 7 1 ) (9 , 0 5 1 , 4 7 1 ) 4, 6 3 9 , 6 8 4 4, 6 3 9 , 6 8 4 Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o , 1 3 Sc h e d u l e 1 1 Pa g e 1 o f 6 K. D o h e r t y . r~ ' RE C E in n q S E P - 3 P M 3 : 6 9 \O M ì O P U B L I C . ; UT \ L 1 i \ E S C O M M I S S I O N .De f e r r d D e b i t s To t a l A s s e t s Ca p i t a l De f e r r d r a t e c h a r g e s Cl e a i i n g F i i n g e B e n e f i t s Cl e a i i n g - P a y r o l l A c c a l De f e r r d P e n s i o n / O P E B Re g u l a r D e f e r r d T a n k P a i n t i n g De f R e l o c a t i o n E x p - A p p r o v e d De f e r r d A F U D C E q u i t y I n c o m e De f e r r d L e g a l E x p e n s e s - A p p r o v e d De f e r r d P o w e r C o s t s - A p p r o v e d Ot h e r R e g u l a t o r y A s s e t s De f e r r P o w e r C o s t s - P e n d i n g Ot h e r D e f e r r d C h a r g e s Re g u l a t o r y A s s e t - F A S 1 0 9 Ca p i t a l i z a t i o n a n d L i a b i l i t s Co m m o n S t o c k I s s u e d Ad d i t o n a l P a i d - I n C a p i t a l Re t a i n e d E a r n i n g s - C u m u l a t e d I n c o m e OC I - P e n s i o n OC I - P B O P Me t e r e d S a l e s - R e s i d e n t i a l Me t e r e d S a l e s - C o m m e r c a l Me t e r e d S a l e s - P u b l i c A u t h o i i t i e s Pii v a t e F i r e P r o t e c t i o n Mis c e l l a n e o u s S e r v i c e R e v e n u e Re n t s f r o m W a t e r P r o p e r t Re g u l a t o r y U n b i l e d R e v e n u e Su p e r v i s o r y L a b o r Di r e c t L a b o r Di r e c t L a b o r t r a n s f e r r d i n Su p e r v i s o r y l a b o r t r a n s f e r r d o u t Di r e c t l a b o r t r n s f e r r e d o u t Ma t e i i a l Eq u i p m e n t r e n t a l Ou t s i d e C o n t r c t o r s Ou t s i d e P r o f e s s i o n a l S e r v c e s La b T e s t i n g F e e s . . Un i t e d W a t e r I d a h o Ca s e N o . U W L - W - 0 9 - 0 1 Wo r k i n g C a p i t a l C a l c u l a t i o n Re g u l a t o r y B a l a n c e S h e e t Pl a n t a n d R a t e In v e n t o r y , Su p p l i e s & C C No n . C o "" . . . . i a y . " . 1 6 V V , " ... . . - . . . . _ . .. . _ . . _ _ _ . _ _ w . . _ . -- - - .. . 10 2 . 1 9 6 10 2 , 1 9 6 41 , 0 8 7 41 , 0 8 7 81 , 5 1 4 81 . 5 1 4 30 1 . 5 9 1 30 1 . 5 9 1 26 7 , 1 0 4 26 7 . 1 0 4 18 . 6 6 7 18 . 6 6 7 1. 0 3 4 . 6 2 8 1. 0 3 4 . 6 2 8 2.8 5 8 2. 8 5 8 4, 3 6 8 4.3 6 8 19 . 5 9 0 19 . 5 9 0 48 0 . 0 4 1 48 0 . 0 4 1 12 2 , 7 3 3 12 2 . 7 3 3 0 23 6 , 4 1 6 , 7 6 3 1. 2 6 1 . 7 5 0 (1 . 2 6 1 . 7 5 0 ) 78 . 7 0 4 . 3 3 0 (7 6 . 7 0 4 . 3 3 0 ) 70 . 7 3 2 . 3 2 8 (7 0 . 7 3 2 . 3 2 8 ) (3 . 2 6 3 . 4 6 6 ) 3.2 6 3 . 4 6 6 (6 6 3 . 6 4 1 ) 66 3 . 6 4 1 5. 8 5 9 . 0 2 4 (5 . 8 5 9 . 0 2 4 ) 2. 4 4 8 , 7 9 8 (2 . 4 4 8 . 7 9 8 ) 20 . 6 7 5 (2 0 . 6 7 5 ) 28 2 . 1 6 8 (2 8 2 . 1 6 8 ) 39 , 4 2 1 (3 9 , 4 2 1 ) 4.3 2 5 (4 . 3 2 5 ) 1.8 4 6 . 9 1 3 (1 . 8 4 6 . 9 1 3 ) (8 2 4 . 5 7 5 ) 82 4 . 5 7 5 (1 . 3 9 6 . 3 2 6 ) 1. 3 9 6 . 3 2 6 14 (1 4 ) 25 5 . 4 4 2 (2 5 5 . 4 4 2 ) 28 6 . 8 2 4 (2 8 6 . 8 2 4 ) (9 2 . 9 3 0 ) 92 . 9 3 0 0 0 (3 1 3 . 2 2 8 ) 31 3 . 2 2 8 (2 4 . 0 0 6 ) 24 , 0 0 6 (2 9 , 4 1 2 ) 29 , 4 1 2 Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 1 Pa g e 2 o f G K. D o h e r t y . Re n t s Pu r c a s e d W a t e r Pu r c a s e d p o w e r Ot h e r U l i i l e s Ch e m i c a l s Tr a n s p o r t t i o n C o s t - O t h e r Me a l s Mi s c e l l a n e o u s E x e n s e s De p r e c i a t i o n Re a l E s t a t e Pa y r o l l T a x e s FI C A T a x e s Fe d e r a l U n e m p l o y m e n t T a x e s Sta t e U n e m p l o y m e n t T a x e s In t e r e s t o n D e b t t o A s s o c C o m p a n i e s Ot h e r I n t e r e s t AF U D C ( C r ) D e b t AF U D C ( C r ) E q u i t y Me r c a n d i s i n g & J o b b i n g Md s e & J o b b i n g - E x p e n s e In c o m e o n D i s p o s i t i o n o f P r o p e r t Mis c n o n o p e r a t i n g i n c o m e Mis c n o n o p e r r e n t a i n c o m e Mis c n o n o p e r a t i n g d e d u c t o n s Ch a r i b l e C o n t r b u t i o n s - R e g C o m p a n i e s Cu r r e n t - F e d e r a l Fe d e r a l T a x E x p e n s e ( C I A C G U ) Cu r r n t - S t a t e Sta t e T l i x E x p e n s e ( C I A C G U ) De f e r r d - F e d e r a l De f e r r d - S t a t e In v e s t m e n t T a x C r e d i t A m o r t i z a t i o n Ot c e S u p p l i e s Ot c e e q u i p m e n t r e n t a l Du e s & S u b s c r p t i o n s Lic e n s e s a n d F e e s Te l e p h o n e Ot h e r U t i l i t i e s G & A Ba d D e b t E x p e n s e Ad v e r t s i n g Po s t a g e & A i r F r e i g h t Clu b a n d P r o f e s s i o n a l D u e s Tr a v e l E x e n s e IT S u p p l i e s a n d E x p e n s e . . Un i t e d W a t e r I d a h o Ca s e N o . U W I - W - 0 9 - 0 1 Wo r k i n g C a p i t a l C a l c u l a t i o n Re g u l a t o r y B a l a n c e S h e e t Pl a n t a n d R a t e In v e n t o r y , Su p p l i e s & .. - . . . . - _ . - - - - ... . _ _ . _ . '- - 0 " .. - _ . . _ . -- - -. -_ . - - - - - . - (5 0 5 ) 50 5 (1 2 2 , 1 5 3 ) 12 2 , 1 5 3 (5 2 8 , 9 7 6 ) 52 8 , 9 7 6 (2 6 , 4 0 0 ) 26 , 4 0 0 (8 0 , 0 4 3 ) 80 , 0 4 3 (1 9 8 , 3 4 8 ) 19 8 , 3 4 8 (4 , 4 8 4 ) 4, 4 8 4 (4 5 , 6 8 8 ) 45 , 6 8 6 (2 , 9 9 0 , 7 8 3 ) 2, 9 9 0 , 7 8 3 (5 8 1 , 5 9 1 ) 58 1 , 5 9 1 (3 3 6 ) 33 6 (1 6 2 , 8 8 4 ) 16 2 , 8 8 4 (5 , 2 9 1 ) 5, 2 9 1 (9 . 2 3 6 ) 9, 2 3 6 (1 , 8 5 4 , 2 3 7 ) 1, 8 5 4 , 2 3 7 76 6 (7 6 6 ) 11 , 8 7 0 (1 1 , 8 7 0 ) 27 , 9 8 5 (2 7 , 9 8 5 ) 32 , 5 7 7 (3 2 , 5 7 7 ) (1 , 0 4 4 ) 1, 0 4 35 , 7 3 5 (3 5 , 7 3 5 ) 5 (5 ) 16 , 2 0 9 (1 6 , 2 0 9 ) (2 4 5 ) 24 5 (7 , 9 0 0 ) 7, 9 0 0 34 , 9 6 3 (3 4 , 9 6 3 ) (1 , 4 3 6 ) 1, 4 3 6 0 0 (2 , 1 9 4 ) 2. 1 9 4 (5 , 4 4 0 ) 5, 4 4 0 0 0 20 , 1 7 0 (2 0 , 1 7 0 ) (2 0 , 2 2 6 ) 20 , 2 2 6 (7 , 7 5 0 ) 7, 7 5 0 (2 5 2 ) 25 2 (5 , 8 6 3 ) 5, 8 6 3 (5 4 , 8 9 0 ) 54 , 8 9 0 (1 2 , 8 9 3 ) 12 , 8 9 3 (1 1 7 , 7 2 5 ) 11 7 , 7 2 5 (3 1 , 3 8 3 ) . 31 , 3 8 3 (1 2 1 , 5 2 7 ) 12 1 , 5 2 7 (5 8 , 1 4 0 ) 58 , 1 4 0 (1 7 , 7 3 3 ) 17 , 7 3 3 (2 1 , 1 3 2 ) 21 , 1 3 2 Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 1 Pa g e 3 o f 6 K. D o h e r t y . IT S y s t e m S u p p o r t Co r p r a t e M & S F e e s Re g u l a t e d M & S F e e s No n - r e g u l a t e d M & S f e e s Fr i n g e B e n e f i t s T r a n s f e r r d Ou t s i d e S e i v c e - A c c u n t i n g & A u d i t i n g Ou t s i d e S e r v i c e - L e g a l Ou t s i d e S e i v c e - i S Ou t s i d e S e i v c e - T e m p o r a r y H e l p Ou t s i d e s e i v c e s m a n a g e m e n t f e e s Ou t s i d e S e i v c e - O t h e r Pr o p e r t I n s u r a n c e Ge n e r a l C o r p o r a t e I n s u r a n c e In j u r i e s & D a m a g e s Wo r k e r c o m p e n s a t i o n Em p l o y e e P e n s i o n C o s t Po s t R e t i r e m e n t H e a l t h C a r e A c c e d Em p l o y e e G r o u p H e a l t h & L i f e Em p l o y e e 4 0 1 K Ot h e r E m p l o y e e B e n e f t s Re g u l a t o r y C o m m i s s i o n E x e n s e Am o r t z a t i o n o f R a t e C a s e E x p Am o r t z a t i o n o f R e l o c a o n E x Am o r t z a t i o n o f T a n k P a i n t i n g Mi s e a m o r t z a t i o n Am o r t z a t i o n o f O P E B C o s t s Am o r t z a t i o n o f L e g a l C o s t s Am o r t z a t i o n o f P o w r C o s t s Am o r t z a t i o n o f G o o d w i l l St a f f M e e t i n g s , C o n f e r e n c e s & S e m i n a r s Cl o t h i n g & U n i f o m i s Co n t r b u t i o n s - C o n t r c t O p s Sa f e l y e q u i p m e n t Ot e r m i s e G & A e x p e n s e s 21 5 U n a p p r o p r i a t e d R e t a i n e d E a r n i n g s To t a l E q u i t y C a p i t a l . . Un i t e d W a t e r I d a h o Ca s e N o . U W I - W - 0 9 - o 1 Wo r k i n g C a p i t a l C a l c u l a t i o n Re g u l a t o r y B a l a n c e S h e e t Pl a n t a n d R a t e In v e n t o r y , Su p p l i e s & .. _ . . . - - - , - - - - -_ . . _ - - - - - . . - - . - - - - - ~ ~ ~ ~ (2 , 8 0 9 ) 2, 8 0 9 (5 1 8 , 3 6 0 ) 51 8 , 3 6 0 (5 2 9 , 7 4 2 ) 52 9 , 7 4 2 (2 , 5 5 3 ) 2, 5 5 3 35 4 , 4 9 2 (3 5 4 , 4 9 2 ) (1 4 , 3 4 0 ) 14 , 3 4 (5 , 3 2 0 ) 5,3 2 0 (5 1 , 7 1 2 ) 51 , 7 1 2 (1 , 4 0 1 ) 1,4 0 1 (5 1 , 6 4 9 ) 51 , 6 4 9 (2 6 , 3 0 8 ) 26 , 3 0 8 (2 7 , 0 0 0 ) 27 , 0 0 0 (2 0 0 , 9 0 0 ) 20 0 , 9 0 0 0 (8 8 , 8 7 5 ) 88 , 8 7 5 (4 3 0 , 2 8 4 ) 43 0 , 2 8 4 (2 0 1 , 0 9 0 ) 20 1 , 0 9 0 (3 0 1 , 3 3 6 ) 30 1 , 3 3 6 (4 3 , 5 0 6 ) 43 , 5 0 (2 7 , 4 4 9 ) 27 , 4 4 9 (3 1 , 4 7 2 ) 31 , 4 7 2 (5 7 , 6 0 8 ) 57 , 6 0 8 (6 , 6 6 7 ) 6, 6 6 7 (5 , 9 5 3 ) 5, 9 5 3 (1 , 0 0 0 ) 1, 0 0 (1 6 , 9 0 0 ) 16 , 9 0 0 (1 , 0 2 1 ) 1, 0 2 1 (1 0 , 9 2 0 ) 10 , 9 2 0 (3 , 8 8 7 ) 3, 8 8 7 (2 1 , 1 1 3 ) 21 , 1 1 3 59 1 (5 9 1 ) (6 , 2 3 0 ) 6, 2 3 0 (1 1 , 3 2 1 ) 11 , 3 2 1 (4 4 , 0 0 4 ) 44 , 0 0 4 66 , 1 7 2 , 2 5 5 14 4 , 1 3 8 , 3 3 5 Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 1 Pa g e 4 o f 6 K. D o h e r t y .Li a b i l t i e s Ac c u n t s P a y a b l e - S y s t e m Ac c o u n t s P a y a b l e M o n t h E n d A c c a l Ac c u n t s P a y a b l e - I n v e n t o r y A c c r u e d Ac c u n t s P a y a b l e - R e l a i n a g e Cu s t o m e r D e p o s i t s - O t h e r Pr o p e r t T a x e s A c c e d Ac c e d T a x e s - F r a n c h i s e FI C A T a x A c c e d Fe d e r a l U n e m p l o y m e n t T a x A c c Sl a t e U n e m p l o y m e n t T a x A c c e d Ac c r u e d T a x e s - S a l e s a n d U s e Ot h e r A c c r u e d T a x e s Fe d e r a l In c o m e T a x A c c r u e d Sl a t e I n c o m e T a x A c c e d Ac c e d - P a y r o l l Ac c r u e d - P o w e r Ac c r u e d U B S C h a r g e s Ac c e d - V a c a t i o n Ac c e d - E m p e x p e n s e r e i m b u r s Ac c e d 4 0 1 K Ac c e d m a n a g e m e n t i n c e n t i v e s Ac c e d S t o c k O p t i o n Ac c r u e d O t h e r Em p l o y e e W l h g - 4 0 1 K Em p l o y e e W l h g - H l t h P l a n l C a r e Em p l o y e e W l h g - F e d e r a l P A C Em p l o y e e W l h g - F u n d R a i s e r Em p l o y e e W i t h h o l d i n g - M e t L i f e Ad v a n c e s f o r C o n s t r c t o n Ta x a b l e A d v a n c e s l e r v L a t e r a l s De f . R e g . L i a b . - F e d e r a l - M e d i c a r e P a r t 0 De f R e g L i a b - S t a t e - M e d i c a r e P a r t 0 PB O P l i a b i l t y - T r u s t e e Ot h e r D e f e r r d C r e d i t s De f e r r e d E s c h e a t s De f e r r d M & J C o s t s De f e r r d I T C Co n t r b u t i o n i n A i d o f C o n s t r c t o n Ta x a b l e C I A C - S e r v L a t e r a l s Ac c m u l a t e d A m o r z a t i o n C I A C De f . F e d e r a l In c T a x e s - O t h e r De f . S t a t e I n c o m e T a x e s - O t h e r De f . F e d e r a l In c o m e T a x e s - M e d i c a r e P a r t 0 . Un i t e d W a t e r I d a h o Ca s e N o . U W I . W - 0 9 - 0 1 Wo r k i n g C a p i t l C a l c u l a t i o n Re g u l a t o r y B a l a n c e S h e e t Pl a n t a n d R a t e In v e n t o r y , Su p p l i e s & . .. . ~ . . . - - . , - - - - .. . . _ - ~ _ . .. _ . . _ _ _ . . _ w . . _ . -- - - -- _ . . -- _ . . - _ . _ . 16 6 , 0 2 1 (1 6 6 , 0 2 1 ) 46 , 3 5 9 (4 6 , 3 5 9 ) 3, 1 4 3 (3 , 1 4 3 ) 8, 6 5 4 (8 , 6 5 4 ) 2, 7 5 6 (2 , 7 5 6 ) 1, 2 6 7 , 8 0 9 (1 , 2 6 7 , 8 0 9 ) 53 , 1 3 7 (5 3 , 1 3 7 ) 27 , 0 5 1 (2 7 , 0 5 1 ) 23 (2 3 ) 1, 3 8 4 (1 . 3 8 4 ) 1, 0 0 2 (1 , 0 0 2 ) 5,9 5 9 (5 , 9 5 9 ) 3, 6 8 6 , 0 3 5 (3 , 6 8 6 , 0 3 5 ) (6 8 3 , 8 2 2 ) 68 3 , 8 2 2 38 9 , 2 5 2 (3 8 9 , 2 5 2 ) 18 9 , 3 5 8 (1 8 9 , 3 5 8 ) 57 , 2 0 0 (5 7 , 2 0 0 ) 51 , 0 9 5 (5 1 , 0 9 5 ) 5, 5 0 8 (5 , 5 0 8 ) 4, 1 1 7 (4 , 1 1 7 ) 10 , 1 8 4 (1 0 , 1 8 4 ) 0 0 35 6 (3 5 6 ) (1 9 , 0 4 ) 19 , 0 4 8 17 , 9 0 9 (1 7 , 9 0 9 ) 27 5 (2 7 5 ) 2, 9 6 8 (2 , 9 6 8 ) 70 (7 0 ) 7, 0 8 2 , 1 8 5 (7 , 0 8 2 , 1 8 5 ) (3 1 , 4 2 ) 31 , 4 4 2 25 4 , 1 8 4 (2 5 4 , 1 8 4 ) 38 , 8 2 7 (3 8 , 8 2 7 ) 5,8 4 4 , 5 5 7 (5 , 8 4 , 5 5 7 ) 63 2 , 6 1 7 (6 3 2 , 6 1 7 ) 23 , 4 9 5 (2 3 , 4 9 5 ) 16 4 , 5 0 6 (1 6 4 , 5 0 6 ) 1,0 7 8 , 3 6 8 (1 , 0 7 8 , 3 6 8 ) 86 , 4 9 0 , 2 3 1 (8 6 , 4 9 0 , 2 3 1 ) 16 6 , 7 6 8 (1 6 6 , 7 6 8 ) (1 5 , 0 8 4 , 9 7 5 ) 15 , 0 8 4 , 9 7 5 (1 2 2 , 6 8 7 ) 12 2 , 6 6 7 (2 8 , 8 3 1 ) 28 , 8 3 1 (1 5 2 , 6 6 3 ) 15 2 , 6 6 3 -W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 1 Pa g e 5 0 f 6 K. D o h e r t y .To t a l L i a b i l i t e s To t a l L i a b i l t i e s & C a p i t l Oa f . F e d e r a l In c o m e T a x e s - G U - M e d i c a r e P a r t 0 Oa f . S l a t e I n c o m e T a x e s - M e d i c a r e P a r t 0 De f . S l a t e I n c o m e T a x e s - G U - M e d l c a r e P a r t 0 De f . S I T - F A S 1 0 9 V a . A 1 l o w - O t h e De f . F I T - F A S 1 0 9 I T C Oa f . F I T - F 7 1 / F 1 0 9 G I U I T C Oa f . F I T - F A S 1 0 9 O t h e r O e d . De f . S I T - F A S 1 0 9 I T C De f . S I T - F 7 1 1 F 1 0 9 G I U I T C De f . S I T - F A S 1 0 9 O t h e r O e d . De f R e g L i a b F 7 1 1 F 1 0 9 - F e d : I T C De f . F I T - M A C R S De f . F I T - O C I P e n s i o n / P B O P Oa f . F I T B e n e f i t o n D S I T Oa f . F I T - O t h e r De f . F I T - T a n k P a i n t i n g De f . F I T - R a t e E x p e n s e s De f . F I T - D e f . C h a r g e s De f . F I T - R e l o c a t i o n E x p e n s e Oa f . F I T - M _ S F e e s De f . F I T - P e n s i o n s De f . F I T - P E B O P De f . F I T - C o s t o f R e m o v a l De f . F I T - U n c o l l e c t . De f . F I T - A F U D C E q u i t y De f . S I T - O t h e r Oa f . S I T - T a n k P a i n t i n g Oa f . S I T - P e n s i o n s Oa f . S I T - P o s t R e t i r e m e n t B n l l De f . S I T - A F U D C E q u i t y De f . S I T - E x c e s s D e p r e e . De f . S I T - C o s t o f R e m o v a l De f . S I T - R e l o c a t i o n De f . S I T - O C I P e n s i o n / P B O P . Un i t e d W a t e r I d a h o Ca s e N o . U W I - W - 0 9 - 0 1 Wo r k i n g C a p i t a l C a l c u l a t i o n Re g u l a t o r y B a l a n c e S h e e t At M a v 3 1 , 2 0 0 9 No n - C a s h O t h Pl a n t a n d R a t e B In v e n t o r y , Su p p l i e s & Ca s h Ca s h O t h -- -- - - - -- - - . - _ . . _ . (1 0 1 , 5 2 1 ) 10 1 , 5 2 1 (3 5 , 8 7 6 ) 35 , 8 7 6 (2 , 9 5 1 ) 2, 9 5 1 0 0 (3 4 , 7 4 7 ) 34 8 , 7 4 7 (2 3 1 , 9 1 7 ) 23 1 , 9 1 7 0 . 0 (8 1 , 9 5 5 ) 81 , 9 5 5 (5 4 , 5 0 1 ) 54 , 5 0 1 0 0 71 7 , 1 2 0 (7 1 7 , 1 2 0 ) 7, 2 4 2 , 0 6 3 (7 , 2 4 2 , 0 6 3 ) (2 , 1 1 4 , 5 9 6 ) 2, 1 1 4 , 5 9 6 (3 8 2 , 1 5 7 ) 38 2 , 1 5 7 (2 9 4 , 0 2 6 ) 29 4 , 0 2 6 86 , 0 2 5 (8 6 , 0 2 5 ) 51 , 9 0 5 (5 1 , 9 0 5 ) (5 0 , 8 3 3 ) 50 , 8 3 3 8, 1 9 4 (8 , 1 9 4 ) (7 5 5 , 4 9 7 ) 75 5 , 4 9 7 (1 , 7 2 0 , 2 3 3 ) 1, 7 2 0 , 2 3 3 (1 , 4 8 5 , 3 0 5 ) 1, 4 8 5 , 3 0 5 16 2 , 9 4 6 (1 6 2 , 9 4 6 ) (4 ) 4 16 7 , 4 7 4 (1 6 7 , 4 7 4 ) (9 6 1 , 9 8 8 ) 96 1 , 9 8 8 26 , 7 7 6 (2 6 , 7 7 6 ) (6 5 8 , 5 5 7 ) 65 8 , 5 5 7 (3 4 9 , 0 5 2 ) 34 9 , 0 5 2 37 , 8 1 0 (3 7 , 8 1 0 ) 2, 2 1 6 , 0 7 3 (2 , 2 1 6 , 0 7 3 ) 36 , 8 7 6 (3 6 , 8 7 6 ) 1, 9 2 4 (1 , 9 2 4 ) (4 9 6 , 9 3 5 ) 49 6 , 9 3 5 92 . 2 7 8 , 4 2 8 (1 4 8 , 1 1 6 , 7 0 6 ) (1 , 4 8 5 , 8 9 4 ) 15 0 , 3 1 5 , 8 6 8 (1 , 9 9 1 , 9 2 5 ) 1, 2 7 8 , 6 5 6 23 6 , 4 1 6 , 7 6 3 In v e s t o r Pl a n t a n d R a t e B a s e Di f f r e n c e 14 8 , 1 1 6 , 7 0 6 15 0 , 3 1 5 , 8 6 8 (2 , 1 9 9 , 1 6 2 ) Pl u s : I n v e n t o r y , S u p p l i e s a n d C a s h Plu s : C a s h - O t h e r (1 , 9 9 1 , 9 2 5 ) 1, 2 7 8 , 6 5 6 (4 , 1 9 1 , 0 8 7 ) 1, 2 7 8 , 6 5 6 WO R K I N G C A P I T A L (2 , 9 1 2 , 4 3 1 ) (2 , 9 1 2 , 4 3 1 ) . Ca s e N o . U W I - W - 0 9 - 0 1 Ex h i b i t N o . 1 3 Sc h e d u l e 1 1 Pa g e 6 o f 6 K. D o h e r t y .United Water Idaho Case UWI.W-09-o1 Amorization of Deferred Gains on Sales of Propert To amortze gain on sale of propert to City of Kuna (36 mo. From Jan.08 to Dec.10) To amortize gain on sale of propert to City of Nampa (36 mo. From OC. 08 to Sept.11) . . Amount of Gain Per Order Unamortzed Balance 05131/09 Amortzation Period In Months Unamortized Monthly Annual Balance Amortzation Amortzation 12131/09 ($207,905) ($49,42) ($109,725) ($39,788) 36 ($5,775)($69,302)($69,302) 36 ($1,372)($16,467)($30,182) ($99,484) Case No. UWI.W-D9-D1 Exhibit No. 13 Schedule 12 Page 1 of1 K. Dohert c:::r-_=10-):m:imO ()O~3:,.ti7"-_..r OjÇ)()oz ~g.. ~-0 IW -0:x cac.Io ;0m("m l''J