Loading...
HomeMy WebLinkAbout2012Annual Report.pdf2C?:APR H Ai 0:51 tDAH ANNUAL REPORT si; UNITED WATER IDAHO INC. NAME P.O. Box 190420, Boise, ID 719-0420 ADDRESS UTILITIES COMMISSION FOR THE YEAR ENDED: DECEMBER 31, 2012 ANNUAL REPORT FOR WATER UTILITIES TO THE IDAHO PUBLIC UTILITIES COMMISSION FOR THE YEAR ENDING: December 31, 2012 COMPANY INFORMATION 1 Give full name of utility Telephone Area Code E-mail address 2 Date of Organization 3 Organized under the laws of the state of 4 Address of Principal Office (number & street) 5 P.O. Box (if applicable) 6 City 7 State 8 Zip Code 9 Organization (proprietor, partnership, Corp.) 10 Towns, Counties served UNITED WATER IDAHO INC. (208) 362-7304 Website: www.unitedwater.com/idaho/ Email: uwid@unitedwater.com April 2, 1928 Idaho 8248 W. Victory Road P.O. Box 190420 Boise Idaho 83719-0420 Corporation Towns: Boise, Eagle Counties: Ada 11 Are there any affiliated Companies? Yes If yes, attach a list with names, addresses & descriptions. Explain any services provided to the utility. 12 Contact Information: President Vice President, Finance Secretary General Manager Complaints or Billing Engineering Emergency Service Accounting I Finance Name Phone No. David Stanton (201) 767-9300 Philippe Dartienne (201) 767-9300 John T. Dillon (201) 767-9300 Gregory P. Wyatt (208) 362-7327 Patricia Foss (208) 362-7303 Scott Rhead (208) 362-7345 Greg Wyatt, Scott Rhead or Patty Foss (208) 362-1300 Jarmila M. Cary or Jeremiah J. Healy (208) 362-7332 or 7337 13 Were any water systems acquired during the year or any additions/deletions made to the service area during the year? No If yes, attach a list with names, addresses & descriptions. Explain any services provided to the utility. 14 Where are the Company's books and records kept? United Water Management & Service Inc. Street Address 200 Old Hook Road City Harrington Park State New Jersey Zip 07640 Page 1 Nam UNITED WATER IDAHO INC. COMPANY INFORMATION For Year Ended: December 31, 2012 11. Affiliated Companies: UNITED WATER MANAGEMENT & SERVICE INC. 200 Old Hook Road Harrington Park, NJ 07640 Services provided to the utility: Management and service contract on file with the I.P.U.C. 13. Additions / Deletions to service area: No Change Page 1 Detail NAME: UNITED WATER IDAHO INC. COMPANY INFORMATION (continued) For the Year Ended December 31, 2012 15 Is the system operated or maintained under a service contract? No 16 If yes: With whom is the contract? When does the contract expire? What services and rates are included? 17 Is water purchased for resale through the system? No 18 If yes: Name of Organization Name of owner or operator Mailing Address City State Zip Water Purchased 19 Has any system(s) been disapproved by the Idaho Department of Environmental Quality? If yes, attach full explanation 20 Has the Idaho Department of Environmental Quality recommended any improvements? If yes, attach full explanation 21 Number of Complaints received during year concerning: Quality of Service High Bills Disconnection 22 No. of Customers involuntarily disconnected 23 Date customers last received a copy of the Summary of Rules required by IDAPA 31.21.01.701? Attach a Copy of the Summary 24 Did significant additions or retirements from the Plant Accounts occur during the year? If yes, attach full explanation and an updated system map Gallons Amount 2,224,000 $ 1,938 No No 465 2,853 1,128 1,128 Jan./Feb. Yes Page 2 PAGE 2 DETAIL PUC ANNUAL REPORT PAGE 1 OF 1 FOR UNITED WATER IDAHO INC. December 31, 2012 41,367 24. SIGNIFICANT ADDITIONS TO THE PLANT ACCOUNT ADDITIONS (Over $100,000 Gross) NO. DESCRIPTION AMOUNT 1 "F" NEW, REPLACEMENT & FIRE SERVICES $ 2,177,406 2 "G" NEW & REPLACEMENT METERS $ 363,349 3 C1OD101_060 36TH ST PRESSURE SOLUTION $ 167,017 4 C10J959_060 CIS IMPLEMENTATION $ 130,082 5 Cl 1A501_060 REDRILL FOXTAIL WELL $ 606,082 6 Cl 1COO1_060 GOWEN CONTROL VALVE $ 238,426 7 C11C107 060 WELL PUMP REPLACEMENTS $ 174,676 8 C1 C506_060 GOOD STREET BOOSTER $ 949,226 9 C11D659 060 MALAD, HELEN, ELMCREST $ 104,210 10 C12AO01_060 WATER RIGHTS $ 308,249 11 C1 213502 060 REPL MARDEN HVAC CONTROL EQUIP $ 102,110 12 C12C101_060 WELL PUMP REPLACEMENTS $ 138,428 13 C12C106_060 REPL OREGON TRAIL PUMP $ 114,791 14 C12C503_060 36TH ST BOOSTER REPLACEMENT $ 197,032 15 C1 2D003 060 N MOUNTAIN TO SCENIC COVE PH 1 $ 231,761 16 C1213101 060 BOGUS BASIN (RANCH-CARTWRIGHT) $ 242,327 17 C1213305 060 LAKEMOOR SUB NO.3 $ 116,861 18 C12D308_060 DALLAS HARRIS ESTATES NO. 8 $ 121,929 19 C12D309_060 BOISE PARK WEST $ 100,279 20 C12D502_060 REPL SHORT MAINS & VALVES $ 139,713 21 Cl 2D601 060 UNIVERSITY DR (BRADY-THEATER) $ 234,660 22 Cl 2D606 060 COLFAX AVE & BRIDGETOWER DR $ 113,369 23 C1213651_060 CORPORAL, STANLEY, MORRIS HILL $ 201,064 24 C12D653_060 ONA STREET (VISTA-COLUMBUS) $ 108,515 25 C12D654_060 MICHALE, AGATE & GROVER $ 125,550 26 C12D656_060 EDSON, ABBS AND BROXON $ 109,475 27 C12D657_060 FORREST, CAMAS & OPAL $ 128,749 28 C12D658_060 29TH (BRENEMAN-DEWEY) $ 173,282 29 C12D701_060 FRANKLIN MAIN REPLACEMENTS $ 224,360 30 C12D703_060 CLOVERDALE RD & USTICK RD $ 174,520 31 C12J950_060 SYSTEM ENHANCEMENTS $ 166,606 32 C1 2K302 060 HYDRAULIC MODEL $ 185,059 33 C12K303_060 SANDY HILL AS MITIGATION STUDY $ 178,771 34 C12K305_060 FISK WELL VOC REMOVAL STUDY $ 184,000 $ 9,031,936 Page 2 Detail Additions December 31, 2012 04/02/13 24. SIGNIFICANT RETIREMENTS FROM THE PLANT ACCOUNT RETIREMENTS (Over $15,000) NO. DESCRIPTION BOOK COST ACCUMULATED DEPRECIATION I "F" RETIREMENT OF SERVICES $ 82,400 $ 102,589 2 "G" RETIREMENT OF METERS $ 92,584 $ 75,575 3 Ri 1A501 060 REDRILL FOXTAIL WELL $ 57,753 $ 57,952 4 R11C107 060 WELL PUMP REPLACEMENTS $ 41,112 $ 51,077 5 R110506 060 GOOD STREET BOOSTER $ 67,246 $ 72,233 6 R11J501_060 VOICE RADIO REPLACEMENT $ 55,553 $ 55,553 7 R11J502_060 TELEPHONE SYSTEM UPGRADE $ 23,000 $ 23,000 8 R1213502_060 REPL MARDEN HVAC CONTROL EQUIP $ 50,000 $ 50,000 9 R12C101_060 WELL PUMP REPLACEMENTS $ 36,756 $ 50,860 10 R12C301 060 AUXILIARY POWER-HIDDEN VLY# $ 53,915 $ 60,565 11 R1 2C503_060 36TH ST BOOSTER REPLACEMENT $ 70,654 $ 74,603 12 R12D323 060 WHITNEY ELEMENTARY SCHOOL $ 19,165 $ 19,165 13 R12D606 060 COLFAX AVE & BRIDGETOWER RD $ 18,665 $ 18,665 14 R1 2D701060 FRANKLIN (CLOVE RDALE-FIVEMILE) $ 20,325 $ 22,324 15 R1 2D703060 CLOVERDALE RD & USTICK RD $ 43,399 $ 43,399 16 R1 2D705060 MIDDLETON MILL CROSSING $ 24,433 $ 24,433 17 R12K701_060 CONF RM CHAIRS & C.S. CARPET $ 18,106 $ 18,056 $ 775,065 $ 820,047 Page 2 Detail Retirements 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 NAME: UNITED WATER IDAHO INC. REVENUE & EXPENSE DETAIL For the Year Ended December 31, 2012 ACCT # DESCRIPTION AMOUNT 400 REVENUES 460 - Unmetered Water revenue - 461.1 - Metered Sales - residential 29,738,015 461.2 - Metered Sales - commercial, industrial 12,766,259 462 - Fire Protection Revenue - Private 880,105 464 - Other revenue 232,002 465 - Irrigation Sales revenue - 466 - Sales for Resale - 400 Total Revenue (Add Lines I - 7) 43,616,380 (also enter result on Page 4, line 1) Booked to Account * DEQ Fees Billed separately to customers 245,976 23699 ** Hookup or Connection Fees Collected - ***Commission Approved Surcharges Collected (Franchise Taxes) 1,127,823 23610 401 OPERATING EXPENSES - 601.1-6 - Labor- Operations & Maintenance 2,308,051 601.7 - Labor - Customer Accounts 996,108 601.8- Labor - Administrative & General 1,014,141 603 - Salaries - Officers & Directors - 604 - Employee Pensions & Benefits 2,003,995 610 - Purchased Water (Includes leased) 159,395 615-16 - Purchased Power & Fuel for Power 1,933,476 618 - Chemicals 282,581 620.1-6 - Material & Supplies - Operation & Maint 237,065 620.7-8 - Material & Supplies - A&G and Cust Care 331,418 631-34 - Contract Services - Professional 3,508,957 635 - Contract Services - Water Testing 68,380 636 - Contract Services - Other 663,948 641-42 - Rentals - Property & Equipment 15,426 650 - Transportation Expense 506,159 656-59 - Insurance 389,510 660 - Advertising 136,630 666 - Rate Case Expense (Amortization) 63,119 667 - Regulatory Comm. Exp. (Amortization) 77,594 670-Bad Debt Expense 272,718 675 - Miscellaneous 998,724 Total Operating Expenses (less Reg. Comm, Depr, Taxes) 15,967,395 (Add lines 12 - 32, also enter on Pg 4, line 2) Page 3 1 2 3 4 5 6 7 8 9A 9B 9C 90 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Name: UNITED WATER IDAHO INC. INCOME STATEMENT For Year Ended December 31. 2012 ACCT # DESCRIPTION Revenue (From Page 3, line 8) 43,616,380 Operating Expenses (From Page 3, line 33) 15,967,395 403 - Depreciation Expense 7 Q0Q .,oc 406 - Amortization, Utility Plant Acquisition Adj 9,324 407 - Amortization Exp. - Other Utility Plant 408.10 - Regulatory Fees 89,752 408.11 - Property Taxes 1,791,429 408.12 - Payroll Taxes 452,388 408.13- Other Taxes 409.10 - Federal Income Taxes 3,819,895 409.11 - State Income Taxes 844,121 410.10 - Prov for Deferred Income Tax - Federal 570,815 410.11 - Prov for Deferred Income Tax - State 167,573 411 - Prov for Deferred Utility Income Tax Credits - 412 - Investment Tax Credits - Utility (48,240) Total Expenses from operations before interest (add lines 2-15) 31,572,750 413 - Income from Utility Plant Leased to Others - 414 - Gains (Losses) from Disposition of Util Plant - Net Operating Income (Add lines 1, 17 &18 less line 16) - 12,043,630 415- Revenues, Mdsing, Jobbing & Contract Work 299,098 416 - Expenses, Mdsing, Jobbing & Contract Work 256,949 419- Interest & Dividend Income Other - 420 - Allowance for Funds Used During Construction 150,442 421 - Miscellaneous Non-Utility Income 44,461 - Mr'Ik,ncr. ic rsjr,r,_I IHU+ ')l ill I '.'I IS i.iulLy t1J_iI IO L. I, I I 408.20 - Other Taxes, Non-Utility Operations - 409.20 - Income Taxes, Non-Utility Operations - Net Non-Utility Income (Add lines 20,22,23 & 24 less lines 21,25,26, & 27) 215,941 Gross Income (add lines 19 & 28) 12,259,571 427.3 - Interest Expense on Long-Term Debt 4,309,152 427.5 - Other Interest Charges 922 NET INCOME (Line 29 less lines 30 & 31) (Also Enter on Pg 9, Line 2) 7,949,497 Page 4 Name: UNITED WATER IDAHO INC. SUB ACCT # 1 301 2 302 3 303 4 304 5 305 6 306 7 307 8 308 9 309 10 310 11 311 12 320 13 330 14 331 15 333 16 334 17 335 18 336 19 339 20 340 21 341 22 342 23 343 24 344 25 345 26 346 27 347 28 348 29 Organization Franchises and Consents Land, Land Rights & Water Rights Structures and Improvements Reservoirs & Standpipes Lake, River & Other Intakes Wells Infiltration Galleries & Tunnels Supply Mains Power Generation Equipment Power Pumping Equipment Purification Systems Distribution Reservoirs & Standpipes Trans. & Distrib. Mains & Accessories Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant & Misc. Equipment Office Furniture and Computer Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment Laboratory Equipment Power Operated Equipment Communications Equipment Miscellaneous Equipment Other Tangible Property Rounding Difference ACCOUNT 101 PLANT IN SERVICE DETAIL For Year Ended: December 31, 2012 Balance Added Removed Balance Beginning During During End of DESCRIPTION of Year Year Year Year 107,754 (3,207) 104,548 9,733,096 379,248 10,112,344 26,050,409 425,481 (104,120) 26,371,771 83,217 83,217 1,172,321 1,172,321 8,089,877 342,074 (24,032) 8,407,919 60,351 60,351 2,203,583 397,055 2,600,637 2,476,469 140,199 (32,243) 2,584,425 21,040,906 1,541,733 (210,965) 22,371,674 25,922,522 139,957 (32,362) 26,030,117 10,661,739 47,203 (7,076) 10,701,866 149,342,376 4,175,996 (286,296) 153,232,076 55,825,654 2,176,872 (74,518) 57,928,007 14,779,515 362,928 (92,366) 15,050,077 3,496,530 18,588 - 3,515,118 10,734,682 624,243 (26,930) 11,331,995 47,193 (6,761) - 40,432 31,917 31,917 741,610 (60,266) (11,123) 670,221 249,501 20,131 (6,926) 262,706 240,982 240,982 2,572,871 190,996 (86,096) 2,677,770 156,299 (80,440) - 75,859 1,492,427 559,107 - 2,051,534 30 TOTAL PLANT IN SERVICE 347,313,801 11,391,138 (995,053) 357,709,886 Enter beginning & end of year totals on Pg 7, Line 1 Page 5 Name: UNITED WATER IDAHO INC. ACCUMULATED DEPRECIATION ACCOUNT 108.1 DETAIL SUB ACCT # For Year Ended: DESCRIPTION December 31, 2012 Annual Depreciation Balance Rate * Beginning % of Year Balance End of Year Increase or (Decrease) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 304 305 306 307 308 309 310 311 320 330 331 333 334 335 336 339 340 341 342 343 344 345 346 347 348 Structures and Improvements Reservoirs & Standpipes Lake, River & Other Intakes Wells Infiltration Galleries & Tunnels Supply Mains Power Generation Equipment Electric Pumping Equipment Purification Systems Distribution Reservoirs & Standpipes Trans. & Distrib. Mains & Accessories Services Meters and Meter Installations Hydrants Backflow Prevention Devices Other Plant & Misc. Equipment Office Furniture and Equipment Transportation Equipment Stores Equipment Tools, Shop and Garage Equipment Laboratory Equipment Power Operated Equipment Communications Equipment Miscellaneous Equipment Other Tangible Property Cost of Removal / Salvage Rounding TOTALS (Add Lines 1 -25) 2.00% 5.00% 6.67% 2.00% 2.50% Office Bldg. 2.00% 2.00% 2.86% 2.00% 2.00% 5.00% 5.00% 14.28% Filters 2.00% 2.00% 2.50% 2.50% 2.50% 2.00% 2.00% 10.00% 20.00% 11.49% 6.67% 6.67% 6.67% 14.50% 6.67% 6.67% 10.00% Master Plan 5,781,043 6,207,823 426,780 35,137 - (35,137) 328,249 351,695 23,446 3,205,123 3,399,119 193,995 37,209 38,416 1,207 372,465 429,645 57,180 373,538 518,952 145,414 9,913,639 10,706,599 792,960 13,772,080 15,127,122 1,355,042 2,358,202 2,567,957 209,755 40,201,041 42,900,327 2,699,286 16,308,149 17,658,431 1,350,282 3,534,979 3,816,339 281,360 569,192 656,861 87,669 - - - - - 3,369,302 4,404,370 1,035,068 61,004 64,719 3,714 31,570 24,448 (7,121) 450,247 573,506 123,259 150,242 160,791 10,549 266,947 152,563 (114,384) 1,106,799 1,191,314 84,515 102,618 57,819 (44,799) 161,751 295,690 133,939 (37,254) 37,254 - - 102,453,270 111,304,506 8,851,236 I Page 6 Name: UNITED WATER IDAHO INC. BALANCE SHEET For Year Ended: December 31, 2012 ASSETS ACCT # DESCRIPTION 1 101 Utility Plant in Service (From Pg 5, Line 30) 2 102 Utility Plant Leased to Others 3 103 Plant Held for Future Use 4 107 Construction Work in Progress 5 114 Utility Plant Aquisition Adjustment 6 Subtotal (Add Lines I - 5) 7 108.1 Accumulated Depreciation (From Pg 6, Line 26) 8 108.2 Accum. Depr.- Utility Plant Lease to Others 9 108.3 Accum. Depr. - Property Held for Future Use 10 110.1 Accum. Amort. - Utility Plant In Service 11 110.2 Accum. Amort.- Utility Plant Lease to Others 12 115 Accumulated Amortization- Aquisition Adj. 13 Net Utility Plant (Line 6 less lines 7 - 12) 14 123 Investment in Subsidiaries 15 125 Other Investments 16 Total Investments (Add lines 14 & 15) 17 131 Cash 18 135 Short Term Investments 19 141 Accts/Notes Receivable - Customers 20 142 Other Receivables 21 145 Receivables from Associated Companies 22 151 Materials & Supplies Inventory 23 162 Prepaid Expenses 24 173 Unbilled (Accrued) Utility Revenue 25 143 Provision for Uncollectable Accounts 26 Total Current (add lines 17 -24 less line 25) 27 181 Unamortized Debt Discount & Expense 28 183 Preliminary Survey & Investigation Charges 29 184 Deferred Rate Case Expenses 30 186 Other Deferred Charges 31 Total Assets (Add lines 13,16 & 26 - 30) Balance Balance Increase Beginning End of or of Year Year (Decrease) 347,313,801 357,709,886 10,396,085 2,977,068 2,595,068 (382,000) 600,761 600,761 - 350,891,630 360,905,715 10,014,085 102,453,270 111,304,506 8,851,236 82,232 91,556 9,324 248,356,128 249,509,653 1,153,525 117,043 118,817 1,774 117,043 118,817 1,774 312,923 310,933 (1,990) 2,192,081 1,757,595 (434,486) 166,444 185,178 18,734 272,525 314,728 42,203 11,151 69,050 57,899 2,670,927 2,677,507 6,580 36,600 88,867 52,267 5,589,451 5,226,124 (363,328) 183,275 135,400 (47,875) 3,153,445 3,390,463 237,018 257,399,342 258,380,456 981,114 Page 7 Name: UNITED WATER IDAHO INC. BALANCE SHEET For Year Ended: December 31, 2012 LIABILITIES & CAPITAL Balance Balance Increase Beginning End of or ACCT # DESCRIPTION of Year Year (Decrease) 1 201-3 Common Stock 1,261,750 1,261,750 - 2 204-6 Preferred Stock - - - 3 207-13 Miscellaneous Capital Accounts 76,704,330 76,704,330 - 4 214 Appropriated Retained Earnings - - - 5 215 Unappropriated Retained Earnings 79,888,567 76,634,160 (3,254,407) 6 216 Reacquired Capital Stock 7 218 Proprietary Capital 8 Total Equity Capital (Add Lines 1-5+7 less line 6) 157,854,647 154,600,240 (3,254,407) 9 221-2 Bonds - - - 10 223 Advances from Associated Companies - - - 11 224 Other Long- Term Debt 12 231 Accounts Payable 1,849,074 1,827,952 (21,122) 13 232 Notes Payable - 14 233 Accounts Payable - Associated Companies 187,555 190,263 2,708 15 235 Customer Deposits (Refundable) - - - 16 236.11 Accrued Other Taxes Payable 947,058 984,883 37,824 17 236.12 Accrued Income Taxes Payable 3,018,244 4,409,761 1,391,518 18 236.2 Accrued Taxes - Non-Utility - - - 19 237-40 Accrued Debt, Interest & Dividends Payable - - - 20 241 Misc. Current & Accrued Liabilities 579,181 793,729 214,548 21 251 Unamortized Debt Premium - 22 252 Advances for Construction 6,541,116 6,312,209 (228,908) 23 253 Other Deferred Liabilities 5,632,397 8,003,554 2,371,157 24 255.1 Accumulated Investment Tax Credits - Utility 953,314 905,074 (48,240) 25 255.2 Accum. Investment Tax Credits - Non-Utility - 26 261-5 Operating Reserves (Pension & Benefits) 10,015,520 11,032,115 1,016,595 27 271 Contributions in Aid of Construction 90,828,054 93,041,670 2,213,616 28 272 Accum. Amort. of Contrib. in Aid of Const. ** (21,958,355) (24,053,714) (2,095,359) 29 281-3 Accumulated Deferred Income Taxes 951,537 332,720 (618,817) 30 Total Liabilities (Add lines 9 - 29) 99,544,695 1 103,780,216 1 4,235,521 31 TOTAL LIAB & CAPITAL (Add lines 8 & 30) 257,399,342 258,380,456 981,114 ** Only if Commission Approved Page 8 Name: UNITED WATER IDAHO INC. STATEMENT OF RETAINED EARNINGS For Year Ended: December 31, 2012 1 Retained Earnings Balance @ Beginning of Year 79,888,567 2 Amount Added from Current Year Income (From Pg 4, Line 32) 7,949,497 3 Other (Credits) / Debits to Account (2,040,904) 4 Dividends Paid or Appropriated (9,163,000) 5 Other Distributions of Retained Earnings - 6 Retained Earnings Balance @ End of Year 76,634,160 CAPITAL STOCK DETAIL No. Shares No. Shares Dividends 7 Description (Class, Par Value etc.) Authorized Outstanding Paid Common Stock, $50.00 Par Value 50,000 25,235 1 $ (9,163,000) 1 DETAIL OF LONG-TERM DEBT Interest Year-end Interest Interest Page 9 Name: UNITED WATER IDAHO INC. SYSTEM ENGINEERING DATA For Year Ended: December 31, 2012 1 Provide an updated system map if significant changes have been made to the system during the year. 2 Water Supply: Type of Water Treatment: Supply Rated (None, Chlorine Annual Source Capacity Fluoride Production (Well, Spring, 3 System Storage: Total Usable Type of Capacity Capacity Reservoir Construction 000's 000's (Elevated,Pres- (Wood, Steel (Duplicate form and attach if necessary. Asterisk facilities added this year.) Page 10 PUC ANNUAL REPORT Page 10 - 2. Water Supply FOR UNITED WATER IDAHO INC. December 31, 2012 04/02/13 1 - 116TH ST IGround Water 800 - 28,375 INaOCI (12 to 15%), PO4 2 27TH ST Ground Water 350 43,118 NaOCI (12 to 15%) 3 AMITY Ground Water 700 210,714 NaOCI <1% 4 ARCTIC Ground Water 700 117 NaOCI (12 to 15%), PO4 5 BALI HAl Ground Water 2,400 316,172 Green Sand, NaOCI <1% 6 BEACON Ground Water 600 14,039 NaOCI (12 to 15%) 7 BERGESON Ground Water 700 0 NaOCI (12 to 15%) 8 BETHEL Ground Water 2,500 628,282 NaOCI <1% 9 BIF Ground Water 250 21,465 NaOCI (12 to 15%), PO4 10 BROADWAY Ground Water 1,000 345,707 NaOCI <1% 11 BROOK HOLLOW Ground Water 850 19,957 NaOCI (12 to 15%), PO4 12 BYRD Ground Water 0 0 NaOCI (12 to 15%) out of service 13 CASSIA 1 Ground Water 900 161,685 NaOCI <1%, PO4 14 CASSIA Ground Water 800 10,762 NaOCI<1% 15 CENTENNIAL Ground Water 750 197,859 NaOCI <1% 16 CENTRAL PARK Ground Water 250 0 NaOCI (12 to 15%) 17 CHAMBERLAIN 1 Ground Water 250 0 NaOCI (12 to 15%), PO4 18 CHAMBERLAIN 2 Ground Water 600 39,089 NaOCI (12 to 15%) 19 CLIFFSIDE Ground Water 800 42,837 NaOCI (12 to 15%) 20 CLINTON Ground Water 1,300 66,619 NaOCI (12 to 15%), PO4 21 COLE Ground Water 700 44,998 NaOCI (12 to 15%) & ASR 22 COUNTRY CLUB Ground Water 800 61,584 NaOCI (12 to 15%) 23 COUNTRY SQUARE Ground Water 1,100 62,275 NaOCI (12 to 15%) 24 COUNTRYMAN Ground Water 500 0 NaOCI (12 to 15%) 25 DURHAM Ground Water 200 23,260 NaOCI (12 to 15%) 26 EDGEVIEW Ground Water 800 4,860 NaOCI (12 to 15%) 27 FISK Ground Water 1,900 0 NaOCI<1% 28 FIVE MILE 12 Ground Water 1,000 0 NaOCI (12 to 15%) 29 FLOATING FEATHER Ground Water 3,000 505,602 NaOCI <1% 30 FOX TAIL #2 Ground Water 1,000 0 NaOCI (12 to 15%) 31 FRANKLIN PARK Ground Water 1,200 562,686 NaOCI <1% 32 FRONTIER 2 Ground Water 1,750 6,646 NaOCI (12 to 15%), PO4 & ASR 33 GODDARD 2 Ground Water 1,300 198,774 NaOCI <1% 34 HIDDEN VALLEY 1 Ground Water 950 160,849 NaOCI <1% 35 HIDDEN VALLEY 2 Ground Water 750 39,622 NaOCI <1% 36 HILLCREST Ground Water 750 330,222 NaOCI <1% 37 HILTON Ground Water 1,400 564,623 Green Sand, NaOCI <1% 38 HOPE Ground Water 500 0 N/A (Out of Service) 39 HP Ground Water 1,100 427,972 NaOCI<1% 40 HUMMEL Ground Water 600 0 NaOCI (12 to 15%), PO4 41 IDAHO Ground Water 375 0 NaOCI (12 to 15%), PO4 42 ISLAND WOODS 1 (Pump #1) Ground Water 150 22,716 NaOCI (12 to 15%) 43 ISLAND WOODS 1 (Pump #2) Ground Water 800 426 NaOCI (12 to 15%) 44 ISLAND WOODS 2 Ground Water 800 49,972 NaOCL (12 to 15%) 45 JRFLAT Ground Water 450 112,007 NaOCI<1% 46 KIRKWOOD Ground Water 300 40,044 NaOCI (12 to 15%) 47 LA GRANGE Ground Water 1,350 206,707 NaOCI <1% Page 10 Detail A Treatment (Page 1 of 2) PUC ANNUAL REPORT Page 10 - 2. Water Supply FOR UNITED WATER IDAHO INC. December 31, 2012 04/02/13 48 ILICORICE IGround Water I 190 I 21,188 JNaOCI (12 to 15%) I 49 LOGGER Ground Water 750 103,253 NaOCI <1% 50 LONGMEADOW Ground Water 250 38,398 NaOCI (12 to 15%) 51 MAC Ground Water 1,200 65,536 NaOCI (12 to 15%), PO4 52 MAPLE HILL 1 Ground Water 1,800 311,830 Green Sand, NaOCI <1% 53 MAPLE HILL 2 Ground Water 500 47,178 NaOCI <1% ASR 54 MARKET Ground Water 700 0 NaOCI (12 to 15%) & ASR 55 MCMILLAN Ground Water 800 88,945 NaOCI (12 to 15%) 56 OREGON TRAIL Ground Water 1,000 82,540 NaOCI (12 to 15%) 57 OVERLAND Ground Water 1,000 85,851 NaOCI <1%,PO4 58 PARADISE Ground Water 500 30,737 NaOCI (12 to 15%) 59 PIONEER Ground Water 1,200 287,670 NaOCI <1% 60 PLEASANT VALLEY Ground Water 1,800 653,335 NaOCI <1% 61 RAPTOR Ground Water 1,000 0 NaOCI (12 to 15%) 62 REDWOOD CREEK 1 Ground Water 1,800 1,115 NaOCI (12 to 15%) 63 RIVER RUN Ground Water 900 43,217 NaOCI (12 to 15%) 64 ROOSEVELT I Ground Water 700 1 30,843 NaOCI <1%, PO4 65 ROOSEVELT 3 Ground Water 600 104,949 NaOCI <1 %,PO4 66 SETTLERS Ground Water 1,000 30,774 NaOCI (12 to 15%) & ASR 67 SHERMAN OAKS Ground Water 300 0 N/A (Out of Service) 68 SPURWING Ground Water 2,000 3,865 NaOCI (12 to 15%) 69 SUNSET WEST Ground Water 2,000 682,959 NaOCI <1% 70 SWIFT 1 Ground Water 1,100 62,503 NaOCI (12 to 15%) GAC &ASR 71 SWIFT 2 Ground Water 900 113,673 NaOCI (12 to 15%) GAG 72 TAGGART 1 Ground Water 300 131,629 NaOCI <1% 73 TAGGART 2 Ground Water 750 314,637 NaOCI <1% 74 TEN MILE Ground Water 1,000 55,719 NaOCI <1% 75 TERTELING Ground Water 425 46,903 NaOCI (12 to 15%) 76 VETERANS Ground Water 740 180,675 NaOCL <1% 77 VICTORY Ground Water 600 173,545 NaOCL <1% 78 VISTA Ground Water 450 128,275 NaOCI <1%, PO4 79 WARM SPRINGS 2 Ground Water 450 3,763 NaOCI (12 to 15%) 80 WARM SPRINGS 3 Ground Water 600 0 NaOCI (12 to 15%) 81 WESTMORELAND Ground Water 350 25,246 NaOCL (12 to 15%) 82 WILLOW LANE 1 Ground Water 500 0 NaOCI (12 to 15%), PO4 83 WILLOW LANE 2 Ground Water 370 19,180 NaOCI (12 to 15%) 84 WILLOW LANE 3 Ground Water 300 24,952 NaOCI (12 to 15%) 1 COLUMBIA PLANT Surface Water 4,170 918,919 Membrane Filtration, NaOCI <1% 2 MARDEN PLANT Surface Water 12,700 3,049,430 Conventional Filtration, NaOCI <1% 89,720 13,535,874 Asterisk facilities added this year Page 10 Detail A Treatment (Page 2 of 2) PUC ANNUAL REPORT Page 10 - 3. System Storage FOR UNITED WATER IDAHO INC. December 31, 2012 04/08/13 1 AERONICA 150 135 I BOOSTED I STEEL 2 ARROWHEAD 440 397 BOTH CONCRETE 3 _ARROWHEAD 1CW 30 20 BOTH CONCRETE 4 ARROWHEAD 2CW 30 20 BOTH CONCRETE 5 _BARBER 2,000 2,000 BOTH STEEL 6 _BOGUS 120 120 ELEVATED CONCRETE 7 BOULDER 630 563 BOTH CONCRETE 8 BRAEMERE 200 167 BOTH CONCRETE 9 _ BRIARHILL 250 222 BOTH CONCRETE 10 BROKENHORN 576 576 ELEVATED STEEL 11 CLAREMONT 2 193 193 ELEVATED CONCRETE 12 CLAREMONT1 90 90 ELEVATED CONCRETE 13 COLUMBIA 3,000 3,000 ELEVATED STEEL 14 COLUMBIA WTPCW 2,000 1,750 BOOSTED STEEL 15 CRESTLINE 300 270 BOTH STEEL 16 FEDERAL 2,000 1,875 BOOSTED STEEL 17 FIVEMILEB 2,500 2,288 BOOSTED STEEL 18 GOODST 3,000 2,873 BOTH STEEL 19 GOWEN 2,000 1,953 BOTH STEEL 20 HARRISRANCH 360 317 ELEVATED CONCRETE 21 HARVARD 150 135 BOOSTED STEEL 22 HIDDENHOLLOW 2,000 1,905 BOTH STEEL 23 HIDDENSPRINGS 347 347 ELEVATED CONCRETE 24 HIGHLAND VIEW #1 200 167 BOTH CONCRETE 25 HIGHLAND VIEW #2 300 271 BOTH STEEL 26 HILLCREST 2,000 1,857 BOOSTED STEEL 27 HULLSGULCH 6,000 5,500 BOTH STEEL 28 LANCASTER 50 50 ELEVATED CONCRETE 29 MARDEN WTP CW 900 750 BOOSTED CONCRETE 30 NORTHMTN 300 281 ELEVATED STEEL 31 OLDPEN 320 320 ELEVATED CONCRETE 32 QUAILRIDGE 325 325 ELEVATED CONCRETE 33 STEELHEAD 3,000 2,850 BOOSTED STEEL 34 TABLEROCK 68 58 ELEVATED CONCRETE 35 TOLUKA 100 87 BOTH STEEL 36 UPPER DANMOR 750 675 BOTH CONCRETE 37 USTICK 2,000 1,875 BOOSTED STEEL 38,679 36,282 Asterisk facilities added this year Page 10 Detail B Storage Name: UNITED WATER IDAHO INC. SYSTEM ENGINEERING DATA (continued) For Year Ended: December 31, 2012 4 Pump information for ALL system pumps, including wells and boosters. Rated Discharge Energy Designation or Location Horse Capacity Pressure Used - Submit pump curves unless previously provided or unavailable. Asterisk facilities added this year. Attach additional sheets if inadequate space is available on this page. (in Million Gal.) 5 If Wells are metered: What was the total amount pumped this year? 14,821 What was the total amount pumped during peak month? 2,435 What was the total amount pumped on the peak day? 84 6 If customers are metered, what was the total amount sold in peak month? 2,325 7 Was your system designed to supply fire flows? Yes If Yes: What is current system rating? ISO-3 8 How many times were meters read this year? 6 During which Months? Meters are read every other month. There are two cycles, one set of meters are read on even months, the other set on odd months. 9 How many additional customers could be served with no system improvements except a service line and meter? 1,000 How many of those potential additions are vacant lots? 1,000 Note: Estimates based on numerous assumptions. 10 Are backbone plant additions anticipated during the coming year? Yes If Yes, attach an explanation of projects and anticipated costs Cl 3C002_060 Replace the Technology Way Booster Station $ 77,000 C12E501_060 Replace the Bogus Basin Reservoir $ 840,000 C1213503060 CWTP Membrane Replacement ($1 M Retirement) $ 2,100,000 11 In what year do you anticipate that the system capacity (supply, storage or distribution) will have to be expanded? 2017 Page 11 PUC ANNUAL REPORT Page 11 - 4. All System Pumps (including Wells & Boosters) FOR UNITED WATER IDAHO INC. December 31, 2012 04/02/13 1 WELL 16TH DWVTRB --- 1 100 f 8001 -,_ 320 72 91,800 ____ RM 59,300 11 .548060708 2 1 WELL 127TH { SUBM 60 1 350 1 442 122,6121 50,994 2.404439738 3 1 WELL JAMITY DWVTRB 150 700 1 490 1 87 139,1201 56,037 rKM645395 4 1 WELL JARCTIC DWVTRB 100 700 1 360 1 80 7,1201 NA 5 1 WELL I BALI HAl DWVTRB 350 2,400 1 455 1 80 1 732,800 1 346,867 1 2.1126253 6 1 WELL IBEACON DWVTRB 75 600 1 335 1 65 1 65,7071 25,176 2.60990626 7 1 WELL 1BERGESON SUBM 100 700 1 325 1 62 1 4,800 - NA 8 WELL BETHEL DWVTRB 1 200 2,500 1 223 1 64 1 782,7601 761,467 1.027963129 9 WELL BE SUBM 40 250 1 450 1 57 1 66,2381 22,652 2.924156807 10 1 WELL BROADWAY DWVTRB 150 1,000 1 425 1 55 1 549,1201 201,266 2.728329673 11 1 WELL I8R00KH0L 0W DWVTRB 75 850 1 277 1 60 1 43,7781 26,881 1.628585246 12 WELL I BYRD None 0 - 0 1 0 1 4 - 13 1 CASSIA PUMP #1 SUBM 100 900 310 1 60 1 343,160 139,824 1.806000705 14 WELL I CASSIA PUMP #2 DWVTRB 125 800 404 60 1 in above 50,187 15 1 WELL ICENTENNIAL DWVTRB 100 750 1 406 1 57 506,040 274,886 1.840908595 16 1 WELL ICENTRALPARK DW VTRB 50 250 1 450 86 1 2,653 - 17 WELL CHAMBERLIN #1 DWVTRB 50 2501 270 50 33,480 - 1.685206624 18 WELL CHAMBERLIN #2 DW VTRB 60 6001 200 50 in above 1 19,867 19 WELL ICLIFESIDE DWVTRB 125 800 1 262 135,888 89,737 1.514291764 20 WELL ICLINTON DWVTRB 125 1,300 1 275 1 59 1 155,2401 92,338 1.681214668 21 WELL .IC0IE { DWVTRB 100 700 1 335 1 70 1 97,0401 61,886 1.568044469 22 WELL I COUNTRY CLUB { DWVTRB 125 800 1 330 1 46 1 214,8801 83,439 2.575294527 23 WELL COUNTRY SQUARE { DWVTRB 125 1,100 1 325 1 58 1 165,9201 98,548 1.683646548 24 WELL ICOUNTRYMAN { DWVTRB 50 500 1 334 1 65 1 1,673 - 25 1 WELL IDURHAM { SUBM 15 1 200 1 106 1 62 1 47,241 1 28,785 1.641167275 26 1 WELL lEDGE VIEW jj SUBM 75 800 1 430 1 60 1 15,6001 4,867 3205259914 27 1 WELL 1E1SK DWVTRB 200 1,9001 317 1 59 1 4,3201 22,095 0.195519348 28 1 WELL IFIVE MILE #12 DWVTRB 75 1,0001 230 1 55 1 24,3201 12,310 1.975629569 29 WELL FLOATING FEATHER DWVTRB 450 3,0001 47 1 63 1 1,112,0001 627,0431 1.7734031 WELL IFOX TAIL (Retired in 2012) None 50 1,0501 150 1 80 17391 1 NA 30 WELL IFOX Tail #2 DWVTRB 125 1,0001 400 1 80 1 39,6401 7,1141 5.57211133 31 WELL IFRANKLIN PARK DWVTRB 125 1 1,2001 218 1 60 1 713,4801 489,611 1.457238502 32 WELL }FRONTIER#2 DWVTRB 1 150 1,7501 250 1 58 1 2,520 - NA WELL GODDARD DWVTRB 150 1,3001 350 1 ,711 2258003235 34 WELL 'HIDDEN VALLEY #1 DWVTRB 150 956F71301 312,5601 143,426 2.179242257 35 WELL HIDDEN VALLEY #2 DWVTRB 100 1 7501 359 1 70 1 183,8001 68,100 2.6989721 36 WELL HILLCREST (Inc Boosters) DWVTRB 100 7501 388 1 32 1 938,0401 309,591 3.029933041 37 1 WELL IHILTON DWVTRB 200 1,4001 250 1 58 1 1,031,8401 636,815 1.620313592 38 1 WELL IHOPE DWVTRB 50 500 1 216 1 66 1 1,600 - 39 WELL HP DWVTRB 150 1 1,1001 410 1 70 1 612,7201 332,934 1.840364757 40 WELL 1 HUMMEL DWVTRB 75 6001 242 1 66 1 1,840 - T WELL IID,tkHO DWVTRB 50 3751 375 1 68 2,400 - 42 WELL ISLAND WOODS #1/ PUMP #1 SUBM 15 1 1501 230 1 69 16,733 10,062 1.662989465 43 WELL ISLAND WOODS #1/ PUMP #2 SUBM 75 8001 230 1 69 1 in above - 44 WELL IISLAND WOODS #2 SUBM 75 8001 280 1 66 1 117,9701 66,253 1.780598614 45 WELL IR FLAT SUBM 100 4501 543 1 71 1 341,8401 121,987 2.802265815 46 WELL IKIRKWOOD DWVTRB 40 3001 260 1 66 1 84,1221 56,130 1.498699448 47 1 WELL jLaGRANGE DWVTRB 150 1,3501 320 1 60 1 489,2001 253,750 1.927881773 48 WELL ILICORICE SUBM 15 1 1901 180 1 62 1 37,7841 24,1801 1.56261373 49 WELL ILOGGER DWVTRB 1 150 1 7001 463 1 67 1 283,5201 118,539 2.391786669 501 WELL ILONGMEADOW DWVTRB 1 50 1 2501 303 1Thö 1 74,8001 44.014 11.699459263 51 1 WELL IMAC DWVTRB 150 1,2001 350 1 79 1 189,3201 97,9581 1.93266502 52 WELL MAPLE HILLS #1 DWVTRB 200 1,8001 377 1 70 868,8401 556,153 1.545788862 53 WELL I MAPLE HILLS #2 DW VTRB 60 5001 328 1 70 1 in above 15,916 54 WELL MARKET DWVTRB 125 7001 553 1 69 1 3,4801 44 55 WELL IMCMILLAN DWVTRB 1 100 1 8001 372 1 80 1 92,4801 57,544 1.607118031 56 WELL I0REGON TRAIL I SUBM 1 150 1 1,0001 420 1 70 1 3,7201 263 14.14448669 57 WELL IOVERND I DWVTRB 1 100 1 1,0001 290 1 69 1 225,9611 121,285 1.863068086 58 WELL IPARADISE SUBM 1 40 1 5061 235 1 65 1 117,8201 62,637 1.880996855 59{ WELL IPIONEER I DWVTRB 1 300 1 1,2001 780 1 65 1 955,0401 224,864 4.247189412 Page 11 Detail Pumps & Boosters (Page 1 of 4) PUC ANNUAL REPORT Page 11 - 4. All System Pumps (Including Wells & Boosters) FOR UNITED WATER IDAHO INC. December 31, 2012 04/02/13 1 50 WELL PLEASANTVAULE I DWVTRB 1 500--1 18001 774 67 2,376,150 671,6l9'3.53795827 61 1 WELL IRAPTOR ]j DWVTRB 1 250 1 1,000 775 'T 173,440 40,984 4.231895374 62 1 WELL I REDWOOD CREEK SUBM 200 1,800 344 65 54,920 16,044 1 3.423086512 63 WELL RIVER RUN SUBM 100 900 370 65 37,120 16,090 2.307022996 64 WELL ROOSEVELT #1 DWVTRB 50 700 230 55 232,800 41,346 1.405567933 65 WELL ROOSEVELT #3 DW VTRB 75 600 334 55 in above 124.281 66 1 WELL ISETTLERS OW VTR B 100 1,000 270 56 87,089 53.277 1 1.634645344 r 1 WELL ISHERMAN OAKS SUBM 30 300 240 58 1,269 - 68 1 WELL ISPURWING DWVTRB 150 2,000 246 80 31,400 4,888 6.423895254 69 WELL SUNSET WEST DWVTRB 250 2,000 339 68 1,377,280 733,902 1.876653831 70 WELL SWIFT #1 DWVTRB 125 1,100 363 66 288,720 59,655 1.538068145 71 WELL SWIFT #2 DWVTRB 100 900 1 342 66 in above 128,061 72 WELL TAGGART PUMP #1 DWVTRB 50 300 420 55 821,560 142,066 2.096752377 73 WELL TAGGART PUMP #2 DW VTRB 125 750 450 55 in above 249,759 74 WELL TEN MILE DWVTRB 300 1,000 710 177,280 38,724 4.5780394% 75 WELL ITERTELING SUBM 1 75 4251 500 1 69 132,208 43,247 1 3.057044419 W WELL VETERANS DWVTRB 75 7401 290 60 319,440 196,625 1.624615385 77 WELL VICTORY DWVTRB 60 600 1 320 55 360,498 225,578 11.598107972 WELL IVISTA DW VTRB 75 4501 430 50 376,680 169,037 2.228387866 W WELL IWARM SPRINGS #2 DWVTRB 75 4501 533 2,115 - NA WELL IWARM SPRINGS #3 DWVTRB 100 600 1 490 3,225 - r WELL IWESTMORELAND DWVTRB 1 50 1 3501 260 44,849 28,849 1.554611945 82 WELL IWILLOW LANE #1 DWVTRB 40 5001 340 69 3,360 - 83 WELL WILLOW LANE #2 DWVTRB 50 370 235 69 73,685 21,811 1.500193416 84 WELL WILLOW LANE #3 DW VTRB 40 300 265 69 in above 27,306 SURFACE COLUMBIA WTP 3,168,826 1,176,573 2.693267651 86 SURFACE #1 Intake SSVTRB 500 2,800 535 205 2,226,518 87 SURFACE #2 Intake SS VTRB 500 2,800 535 205 in above 88 1 SURFACE #3 Intake SS VTRB 500 2,800 535 205 in above 89 SURFACE #1 Finished SSVTRB 75 1,050 85 35 942,308 90 SURFACE #2 Finished SS VTRB 75 1,050 85 35 in above 91 SURFACE #3 Finished SS VTRB 200 2,800 85 35 in above 92 SURFACE #4 Finished SS VTRB 200 2,800 85 35 in above WELL MARDEN WTP 4,644,945 3,469,978 1.338609351 93 SURFACE #1 Ranney SUBM 50 1,750 80 30 in above 94 SURFACE #2 Ranney SUBM 20 1,000 54 30 in above 95 SURFACE #3 Ranney SUBM 90 2,800 70 30 in above 96 SURFACE #1 Intake SS VTRB 15 1,390 28 30 in above 97 SURFACE #2 Intake SS VTRB 30 2,775 28 1 30 in above 98 1 SURFACE 1#3 Intake SS VTRB 30 2,775 28 30 in above 99 SURFACE #4 Intake SS VTRB 25 2,775 28 30 in above 100 SURFACE #5 Intake SS VTRB 50 4,166 31 30 in above 101 SURFACE #1 Finished SS VTRB 75 2,777 170 63 in above 102 SURFACE #2 Finished SS VTRB 150 2,777 170 63 in above 103 SURFACE #3 Finished SSVTRB 150 4,166 170 63 in above 104 SURFACE #4 Finished SS VTRB 250 4,166 170 63 in above 105 SURFACE #5 Finished SS VTRB 250 4,166 200 85 in above IT0TAL WELLS 1 1 4,9451 127,433 33 ,050 6,870 28,390,232 14,819,033 154.464499 1 I BOOSTER 128TH STREET (Retired 11/12) HORZ-CENTRIF 5 75 162 70 12,811 2 BOOSTER 36TH ST. (Pump #1) SSVTRB 75 1,000 200 95 87,119 BOOSTER 36th ST. (Pump #2) SS VTRB 75 1,000 200 95 3 BOOSTER AERONICA (Pump #2) HORZ-CENTRIF 15 200 183 52 20,862 BOOSTER AERONICA (Pump #1) HORZ-CENTRIF 50 800 183 52 BOOSTER ARCTIC PIT SS VTRB 40 2,5001 184 80 1 8,316 5 BOOSTER ARROWHEAD #1 (Pump #1) SSVTRB 25 450 162 50 57,867 BOOSTER ARROWHEAD #1 (Pump #2) SS VTRB 25 450 162 50 = BOOSTER ARROWHEAD #1 (Pump #3) SS VTRB 50 900 1 162 50 Page 11 Detail Pumps & Boosters (Page 2 of 4) PUC ANNUAL REPORT Page 11 - 4. All System Pumps (including Wells & Boosters) FOR UNITED WATER IDAHO INC. December 31, 2012 04/02/13 6ARROWHEAD #2 (Pump #1) SS VTRB 40 450 248 95 84,400 BOOSTER ARROWHEAD #2 (Pump #2) SS VTRB 40 450 248 95 BOOSTER ARROWHEAD #2 (Pump #3) SS VTRB 75 900 248 95 7 BOOSTER BARBER (Pump #1) HORZ-CENTRIF 150 1,500J 260 90 44,280 - BOOSTER BARBER (Pump #2) HORZ-CENTRIF 150 1,5001 260 90 8 BOOSTER BLUFFS (Pump #1) HORZ-CENTRIF 7.5 150 140 75 22,606 BOOSTER BLUFFS (Pump #2) HORZ-CENTRIF 25 500 140 75 - BOOSTER BLUFFS (Pump #3) HORZ-CENTRIF 25 500 140 75 9 BOOSTER BOISE AVE HORZ-CENTRIF 30 1,0001 173 Iii2i 16,387 10 BOOSTER BOULDER (Pump #1) HORZ-CENTRIF 15 250 138 60 47,192 - BOOSTER BOULDER (Pump #2) HORZ-CENTRIF 15 250 138 60 BOOSTER BOULDER (Pump #3) HORZ-CENTRIF BOOSTER 20 500 130 55 11 BRAEMERE (Pump #1) SSVTRB 75 1,000 215 83 95,080 BOOSTER BRAEMERE (Pump #2) SSVTRB 75 1,000 215 83 BOOSTER I BRAEMERE (Pump #3) SS VTRB 40 600 215 83 - BOOSTER I BRAEMERE (Pump #4) (Redundant) SS VTRB 20 250 190 83 121 BOOSTER BRIARHILL (Pump #1) HORZ-CENTRIF 50 500 230 150 147,200 BOOSTER BRIARHILL (Pump #2) HORZ-CENTRIF 30 300 1 230 1 150 - BOOSTER BRIARHILL (Pump #3) HORZ-CENTRIF 100 8001 235 1 150 13 BOOSTER BROKEN HORN (Pump #1) SSVTRB 125 1,000 365 165 83,040 BOOSTER BROKEN HORN (Pump #2) SSVTRB 125 1,000 365 165 BOOSTER BROKEN HORN (Pump #3) (Redundant) SS VTRB 125 1,000 365 165 14 BOOSTER BRUMBACK#1 HORZ-CENTRIF 100 600 380 150 239,400 BOOSTER BRUMBACK#2 HORZ-CENTRIF 100 600 380 150 15 BOOSTER CARTWRIGHT BSTR (Pump #1) IN LINE-CENTRIF 60 3251 380 120 1 57,240 BOOSTER CARTWRIGHT BSTR (Pump #2) IN LINE-CENTRIF 60 3251 380 120 16 BOOSTER CRESTLINE (Pump #1) HORZ-CENTRIF 40 420 230 90 69,287 BOOSTER CRESTLINE (Pump #2) HORZ-CENTRIF 40 420 230 90 171 BOOSTER I FEDERAL (Pump #1) HORZ-CENTRIF 100 1,500 190 60 146,800 BOOSTER FEDERAL (Pump #2) HORZ-CENTRIF 1 100 1,5001 190 1 60 18 BOOSTER FIVE MILE (PUMP #1) SSVTRB 1 40 500 1 207 1 78 1 90,840 BOOSTER FIVE MILE (PUMP #2) SSVTRB 100----1 1,5001 207 1 78 1 - BOOSTER FIVE MILE (PUMP #3) (Redundant) SS VTRB 100 1 1,500 1 207 1 78 19 BOOSTER FLOATING FEATHER B HORZ-CENTRIF 200 2,5001 237 1 120 In Supply List 201 BOOSTER I GARFIELD (Refired Booster 2011) 1 50 2,089 211 BOOSTER GOOD STREET (Pump #1) SS VTRB 100 4,500 63 25 96,649 BOOSTER BOGUS (Pump #2) (Redundant) SS VTRB 125 2,500 159 75 BOOSTER BOGUS (Pump #3) SSVTRB 125 2,500 159 75 BOOSTER BOGUS (Pump #4) SS VTRB 40 700 189 75 221 BOOSTER GOWEN (Pump #1) HORZ-CENTRIF 40 1,000 110 66 31,275 BOOSTER GOWEN (Pump #2) - HORZ-CENTRIF 50 1,500 110 66 BOOSTER GOWEN (Pump #3) HORZ-CENTRIF 25 340 150 66 23 BOOSTER HARRIS RANCH (Pump #1) HORZ-CENTRIF 10 300 95 65 17.079 - BOOSTER HARRIS RANCH (Pump #2) HORZ-CENTRIF 30 700 95 65 - BOOSTER HARRIS RANCH (Pump #3) HORZ-CENTRIF 30 700 95 65 24 BOOSTER HARVARD (Pump #1) HORZ-CENTRIF 20 350 90 85 14,223 - BOOSTER HARVARD (Pump #2) HORZ-CENTRIF 20 350 90 85 25 BOOSTER HIDDEN HOLLOW (Pump #1) SSVTRB 200 1,000 575 220 531,800 BOOSTER HIDDEN HOLLOW (Pump #2) SS VTRB 200 1,000 575 220 - BOOSTER HIDDEN HOLLOW (Pump #3) SSVTRB 125 600 565 220 26 BOOSTER HIGI-ILD VIEW (Pump #1) HORZ-CENTRIF 40 1 600_t 180 67 149,280 BOOSTER HIGNL'D VIEW (Pump #2) HORZ-CENTRIF 40 600 1 180 67 = BOOSTER HIGHLD VIEW (Pump #3) HORZ-CENTRIF 100 1,2001 180 67 27 BOOSTER HILLCREST (Pump #1) SS VTRB 75 1,500 151 65 In Supply List - BOOSTER HILLCREST (Pump #2) SSVTRB 125 3,000 118 52 BOOSTER HILLCREST (Pump #3) SSVTRB 125 3,000 118 52 - BOOSTER HILLCREST (Pump #4) (Redundant) SS VTRB 125 3,000 118 52 28 BOOSTER HILLS BORO (Pump #1) SSVTRB 50 6001 245 104 1 53,640 BOOSTER HILLS BORO (Pump #2) SSVTRB 75 9001 245 104 BOOSTER HILLSBORO (Pump #3) HORZ-CENTRIF 20 3001 170 104 Page 11 Detail Pumps & Boosters (Page 3 of 4) PUC ANNUAL REPORT Page II - 4. All System Pumps (including Wells & Boosters) FOR UNITED WATER IDAHO INC. December 31, 2012 04/02/13 • 29 BOOSTER HILO HORZ-CENTRIF __ 50 800 __ 185 105 29.[ 30 BOOSTER HULLS GULCH (Pump #1) SSVTRB 125 1,400 258 112 331,360 BOOSTER HULLS GULCH (Pump #2) SSVTRB 125 1,400 258 112 - BOOSTER HULLS GULCH (Pump #3) SSVTRB 125 1,400 258 112 31 BOOSTER LOWER DANMOR (Pump #1) HORZ-CENTRIF 50 600 230 132 243,440 - BOOSTER LOWER DANMOR (Pump #2) HORZ-CENTRIF 75 1,000 230 132 BOOSTER LOWER DANMOR (Pump #3) HORZ-CENTRIF 75 1,000 230 132 32 BOOSTER MICRON (Pump #1) FIORZ-CENTRIF 50 900 150 105 6,069 BOOSTER MICRON (Pump #2) HORZ-CENTRIF 20 340 150 105 BOOSTER MICRON (Pump #3) HORZ-CENTRIF 75 1 1,700 165 105 BOOSTER MICRON (Pump #4) Diesel HORZ-CENTRIF 125 1,700 92 105 33 BOOSTER NORTH MTN (Pump #1) HORZ-CENTRIF 15 250 150 88 28,521 BOOSTER NORTH MTN (Pump #2) HORZ-CENTRIF 25 600 120 88 341 BOOSTER JOLD PEN HORZ-CENTRIF] 15 300 150 70 35 BOOSTER QUAIL RIDGE (Pump #1) HORZ-CENTRIF 30 200 160 151 186,468 - BOOSTER QUAIL RIDGE (Pump #2) HORZ-CENTRIF 60 500 160 151 BOOSTER QUAIL RIDGE (Pump #3) HORZ-CENTRIF 60 500 160 151 36 BOOSTER ROGER HEIGHTS (Pump #1) HORZ-CENTRIF 75 3,000 100 45 113,200 BOOSTER ROGER HEIGHTS (Pump #2) HORZ-CENTRIF 75 3,000 100 45 - BOOSTER ROGER HEIGHTS (Pump #3) (Redundant) HORZ-CENTRIF 75 3,000 100 45 - BOOSTER SOMERSET (Pump #1) HORZ-CENTRIF 25 200 280 166 BOOSTER SOMERSET (Pump #2) HORZ-CENTRIF 100 1,000 280 166 37 BOOSTER SCENIC COVE (Pump #1) HORZ-CENTRIF 1.5 30 63 63 144 - BOOSTER SCENIC COVE (Pump #2) HORZ-CENTRIF 5 100 63 63 38 BOOSTER STEELHEAD (Pump #1) HORZ-CENTRIF 25 500 135 60 162,240 - BOOSTER 5TEELHEAD (Pump #2) HORZ-CENTRIF 60 1,500 135 60 BOOSTER STEELHEAD (Pump #3) HORZ-CENTRIF 100 2,500 135 60 39 BOOSTER ISTONECREEK HORZ-CENTRIF 5 80 80 80] 19,9771 40 BOOSTER ISUNVIEW HORZ-CENTRIF 60 750 145 101] 15,145 1 41 BOOSTER TOLUKA (Pump #1) HORZ-CENTRIF 50 500 240 81 141,400 - BOOSTER TOLUKA (Pump #2) HORZ-CENTRIF 50 500 240 81 - BOOSTER TOLUKA (Pump #3) (Redundant) HORZ-CENTRIF 50 500 240 81 42 BOOSTER UPPER DANMOR (Pump #3) HORZ-CENTRIF 50 300 300 104 170,640 - BOOSTER UPPER DANMOR (Pump #2) HORZ-CENTRIF 50 300 300 104 BOOSTER UPPER DANMOR (Pump #1) HORZ-CENTRIF 125 1.200 300 104 43 BOOSTER US TICK (Pump #1) HORZ-CENTRIF 75 1,500 164 65 157,280 BOOSTER USTICK (Pump #2) HORZ-CENTRIF 75 1,500 164 65 BOOSTER USTICK (Pump #3) HORZ-CENTRIF 30 500 175 65 441 BOOSTER WARM SPRINGS (Pump #1) HORZ-CENTRIF 100 600 377 155 161,4401 BOOSTER IWARM SPRINGS (Pump #2) HORZ-CENTRIF 100 600 377 155 ITOTAL BOOSTERS 3.2791 104,755 9,792 3,286 3.994,823 liii ITOTA1 WELLS & BOOSTERS 8.2241 232,188 42,842! iI 32,385,0551 14,819.033 Asterisk facilities added this year Annual Report on Deferred Power Cost will show 32,389,856 kWh, difference is Lizaso (non-utility) & PRy's and monitoring stations that are classified together with Boosters. Page 11 Detail Pumps & Boosters (Page 4 of 4) 2 Metered: 2A Residential 2B Commercial 2C Industrial 3 Flat Rate: 3A Residential 3B Commercial 3C Industrial 4 Private Fire Protection: 5 Public Fire Protection: 6 Street Sprinkling (included in other) 7 Municipal, Other 8 Other Water TOTALS (Add lines 2 through 8) Name: UNITED WATER IDAHO INC. SYSTEM ENGINEERING DATA (continued) For Year Ended: December 31, 2012 FEET OF MAINS In Use Installed Abandoned In Use 1 Pipe Beginning During During End of Size of Year Year Year Year 36" 1,348 1,348 30" 15,587 (1) 15,586 24" 66,065 8,743 74,808 20" 10,172 (5) 10,167 18" 3,420 (1) 3,419 16" 228,443 1,987 230,430 14" 8,195 8,195 12" 1,430,295 31,883 (5,548) 1,456,630 10" 54,775 (571) 54,204 8" 2,549,479 69,588 (3,646) 2,615,421 6" 1,556,090 597 (6,631) 1,550,056 4" 207,884 1,887 (3,230) 206,541 3" 5,782 12 5,794 2", 2.5" 209,971 4,188 (22,097) 192,062 1", 1.25", 1.5" 9,427 (2,703) 6,724 TOTAL 6,356,933 118,885 (44,433) 6,431,385 MILES 1,218.07 CUSTOMER STATISTICS Number of This Year Customers Thousands of Last This Year Year Gallons Sold Last Year 75,483 74,352 9,253,630 8,489,186 8,420 8,336 4,850,655 4,559,578 1,645 1,644 - - 48 46 71,688 60,488 30,430 25,700 85,596 84,378 14,206,403 13,134,952 Page 12 CERTIFICATE State of Idaho County of Ada WE, the undersigned Gregory P. Wyatt, Vice President and Jarmila M. Cary, Accounting Manager of United Water Idaho Inc., a water utility, on our oath do severally say that the foregoing report has been prepared under our direction, from the original books, papers and records of said utility; that we have carefully examined same, and declare the same to be a correct statement of the business and affairs of said utility for the period covered by the report in respect to each and every matter and thing therin set forth, to the best of our knowledge, information and belief. 7M ePreent (Officer in Charge of Acco ts) - Subscribed and Sworn to Before Me this —day of ,2013 (Notary Public) Residing at: My Commission Expires: United Water Idaho Inc. Annual Report on Deferred Power Cost - Pending Summary of 18714 Account as of December 31, 2012 Prepared By: Michael Wilson, March 4th 2013 Column I Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Interest kWH subject to PCA Accrual at Misc Total 18714 Cumulative Accounting Month change Deferred PCA Costs 1% Adjustments Monthly Increase Account Balance NOTES GL BAL Beginning Balance: $ 184,626.58 $ 184,626.58 January2012 1,412,877 $ 11.25 $ 154.79 $ 166.04 $ 184,792.62 $ 184,792.62 February 2012 1,502,194 $ 10.61 $(184,792.62) $ (184,782.01) $ 10.61 $ 10.61 March 2012 1,615,264 $ 16.62 $ 16.62 $ 27.23 $ 27.23 April 2012 1,364,526 $ 27.94 $ 27.94 $ 55.17 $ 55.17 May 2012 1,412,971 $ (0.23) $ (0.23) $ 54.94 $ 54.94 June 2012 2,062,458 $ 64.26 $ 64.26 $ 119.20 $ 119.20 July 2012 3,259,039 $ 1,575.34 $ 1,575.34 $ 1,694.54 $ 1,694.54 August 2012 4,487,715 $ 7,057.08 $ 9.10 $ 7,066.18 $ 8,760.72 $ 8,760.72 September 2012 5,080,636 $ 8,089.95 $ 11.40 $ 8,101.35 $ 16,862.07 $ 16,862.07 October 2012 4,696,030 $ 7,490.44 $ 17.38 $ 7,507.82 $ 24,369.89 $ 24,369.89 November 2012 3,528,316 $ 5,662.88 $ 22.63 $ 5,685.51 $ 30,055.40 $ 30,055.40 December 2012 1,967,830 3,209.22 $ 27.16 $ 3,236.38 $ 33,291.78 $ 33,291.78 Total 32,389,856 $ 33,215.36 $ 242.46 $(184,792.62) Note 1: The IPUC authorized the establishment of a deferral account for the incremental cost resulting from increases in Idaho Power PCA adjustment in Order No. 28800 issued in 2001. IPUC Order No. 29838 issued in August 2005 authorized continuation of the deferral mechanism and added the requirement that United Water Idaho file an annual report with the Commission documenting account activity and balance. In Order No. 30104, issued July 24, 2006 the Commission approved the settlement stipulation of UWID's general rate case. The Agreement called for continuation of the deferral account methodology as well as amortization of the deferred power expense over three years. In Order No. 31016, issued March 4, 2010, the IPUC approved the settlement stipulation of UWID's GRC, UWI-W-09-01. The Stipulation allowed a three year amortization of Deferred Power Costs accumulated through the end of February, 2010. The Stipulation modified the methodology used by UWID to calculate Deferred Power: as of March 1, 2010, the Company is entitled to defer the entire amount of Idaho Power PCA charge. Prior to this modification, United Water Idaho deferred only the incremental change in PCA rates from the base PCA rate in effect at the time of UWID's rate change and Idaho Power new PCA rate, which is updated each year effective June 1. Per PUC Order 32443 UWI-W-11-02 and Settlement Stipulation, the unamortized deferred power expense balance through Jan. 2012 will be re-amortized over 36 months commencing Feb. 1, 2012. S:\ACC\Power\IPUC Annual Deferred Power Report\IPUC Power Def Summary 201 2.xlsx General Metered Service United Water Idaho bills each current customer every two (2) months. There are two components to the water billing: a bi-monthly Customer Charge based on the size of the meter as shown below and the Volume Charge for consumption determined by the meter reading. The customer charge will only change if the meter size is increased or decreased. The volume charge is applied to each 100 cubic feet (1 CCF) of water used.* These rates are effective February 1, 2012. Meter Size Customer Charge 3/4" and smaller........ $20.10 1"............................... $25.70 1-1/4" - 1-1/2 .............. $44.00 2"............................... $68.20 3"............................... $133.10 (or multiple meters of equivalent capacity) 4"............... $248.20 6" ............... $414.50 8" ............... $542.20 10" .............. $780.30 *000 cubic feet = approximately 748 gallons) When the billing period encompasses both seasonal periods, the water billing will be prorated. Bills will be prorated twice each year. If there are any questions concerning the billing, we will be happy to discuss this process with you step by step. Miscellaneous Charges United Water Idaho believes that the cost of providing special services should be borne by those customers responsible for incurring the costs. The handling of returned checks, accounts that are disconnected for non-payment and after-hour or weekend service are some examples of special services. These miscellaneous charges are as follows: • Returned Checks: $20.00 • Reconnection for non-payment: Regular hours $20.00 After hours $30.00 • New service connections: Regular hours No Charge After hours $25.00 • Field collection: $15.00 J"~ •- / 0 United Volume charges are seasonal. One rate is charged during the summer season and one during the winter season. The summer season is May 1 through September 30. The rates are: Winter Summer $14388 per ccf $14388 for 1st 3 CCF $17985 above 3 CCF For example: If there is a 3/4" meter and the billing states the consumption is 18 ccf, the usage during the last two month billing period was 1,800 cubic feet. The bill would include the customer charge for a 3/4" meter plus the volume charge per 100 cubic feet. The billing would be calculated as follows: Winter Customer charge = $20.10 18 CCF © $14388 = $25.90 Total = $46.00 Summer Customer charge = $20.10 3 CCF © $ 1.4388 = $ 4.32 15 CCF © $17985 = $26.98 Total = $51.40 In most cases, these fees must be paid prior to service being granted or restored. Payment Options There are several ways to pay your bill: • Try our new Budget Billing Plan. Call 362.7304 to enroll • Direct debit from either your checking or savings account • * On-line at www.unitedwater.com/idaho • * 24-hour automated payment line: 1.888.608.6690 * Visa, MasterCard or check-by-phone: 362.7304 • * Pay stations (see website for locations) • At our payment center at the U.S. Bank on 10th and Idaho (checks or money orders only) • Use the envelope provided with your bill • At our office at 8248 W. Victory Road *Conven ience or service fees apply (These total charges do not include taxes, state fees, or charges for any other types of service.) 060020512 The IPUC service rules allow utilities to ask for deposits or payment guarantees under specific conditions. At this time, United Water Idaho does not require deposits or payment guarantees. Termination With Prior Notice With proper customer notification, United Water Idaho may deny or terminate water service for one of the following reasons: 1.Nonpayment of a past due billing, payment of a past due billing with any check not honored by the bank, or insufficient funds on an electronic payment; 2.Failure to abide by the terms of a payment arrangement; 3.Obtaining service by misrepresentation of identity; 4.Denying or willfully preventing access to the water meter; 5.Willfully wasting service through improper equipment or otherwise; 6.The applicant or customer is a minor. Termination Without Prior Notice United Water Idaho may deny or terminate water service without prior notice for one of the following reasons: 1.A situation exists that is immediately dangerous to life, physical safety or property; 2.To prevent a violation of federal, state or local safety or health codes; 3.Service is obtained, diverted or used without the authorization of United Water Idaho; 4.United Water Idaho has diligently attempted to notify the customer of termination and has been unable to make contact; 5.If ordered by any court, the Commission, or any other duly authorized public authority. Notification 1. A billing may be considered past due fifteen (15) days after the billing date. A written notice of termination must be mailed at least seven (7) days before the proposed termination date. 2.At least twenty-four (24) hours before the service is terminated, another attempt shall be made to contact the customer in person or by telephone. 3.If service is terminated, a notice will be left at the property advising the customer of the necessary steps to have service restored. Only a twenty-four (24) hour notice is required if: 4.The initial payment of a payment arrangement is not made or the initial payment is made with a check not honored by the bank; 5.Payment is made by check to a company representative at the premises to prevent termination and the check is not honored by the bank. Additional Notice 1. If service is not terminated within twenty-one (21) calendar days after the proposed termination date, United Water will begin the notice process again with the seven (7) day written notice. Payment Arrangements And Special Circumstances If the customer cannot pay the billing in full or receives a notice of termination, payment arrangements can be made to avoid termination of service. Call customer service at 208.362.7304. If the customer cannot pay the billing and a member of the household is seriously ill or there is a medical emergency, United Water Idaho will postpone termination of service for thirty (30) days. A written certificate is required from a licensed physician or public health official stating the name of the person who is ill and the name, title, and signature of the person certifying the serious illness or medical emergency. Restrictions On Termination Of Service Service cannot be terminated if: 1.The past due billing is less than $50.00 or two (2) months of service, whichever is less; 2.The unpaid billing is for service to another customer; 3.The billing is for charges other than water service. Service cannot be disconnected on Friday, Saturday, Sunday, legal holidays recognized by the state of Idaho, or on any day immediately preceding any legal holiday. Service may be terminated only between the hours of 8:00 a.m. and 4:00 p.m. The employee sent to the premises to terminate service will identify himself/herself to the customer and state the purpose of the visit. This employee is authorized to accept payment in full on the account. If service is terminated for any one of the conditions listed, United Water Idaho has employees available for reconnection as soon as the situation is corrected. Complaint Procedure If at any time there is a complaint concerning termination of service, policies and practices, or any other matter regarding our service, please contact United Water Idaho in person, by telephone or in writing. The complaint will be investigated promptly and thoroughly. The customer will be notified orally or in writing of the results of the investigation, and we will make every effort to resolve the complaint. If the customer is dissatisfied with the proposed resolution of the complaint, the IPUC may be asked to review the matter. The service will not be disconnected while the complaint is being investigated by the utility or the IPUC. Rate Schedule Information Most United Water Idaho customers are billed under the enclosed rate schedule. However, some customers may be billed under a special temporary tariff. Please call customer service if there are any questions about the rate schedule used for your billing. UW Cares United Water Idaho has established UW Cares, a program to help low-income residents and customers who have experienced temporary financial hardship pay their water bills. United Water matches contributions made to the program by our customers. Your donation to UW Cares is tax deductible, and 100 percent of your donation goes to helping families meet their most essential need - water. Donations can be mailed to UW Cares, P.O. Box 190420, Boise, ID 83719-0420. UW Cares is administered by the El-Ada Community Action Agency. To get more information on the program and eligibility requirements, please call El-Ada at 377.0700, or toll-free at 1.866.375.7382. Report ID: ISREGO60 Layout ID: ISREGO60 United Water Idaho General Ledger System Business Unit: 00060 Regulatory Income Statement Period Ending: Dec 31,2012 Run on 03/05113 at 0143 PM Current Prior Increase Year Year (Decrease) REVENUES 460 - Unmetered Water revenue 0.00 0.00 0.00 40105 Metered sales—residential consumption revenL 29,738,014.95 25,912,828.55 3,825,186.40 461.1 - Metered Sales - residential 29,738,014.95 25,912,828.55 3,825,186.40 40110 Metered sales—commercial consumption rever 12,766,258.68 11161,312.11 1,604,946.57 461.2- Metered Sales - commercial, industrial 12,766,258.68 11,161,312.11 1,604,946.57 40140 Private fire protection facility charge 880,104.83 806,689.49 73,415.34 462- Fire Protection Revenue - Private 880,104.83 806,689.49 73,415.34 40120 Metered sales—public auth's consumption reve 190,426.50 154,475.93 35,950.57 40200 Miscellaneous Service Revenue 26,995.00 127,432.21 (100,437.21) 40205 Rents from Water Property 8,000.00 7,300.00 700.00 40300 Reg Unbilled consumption revenue 6,580.00 185,373.00 (178,793.00) 464- Other revenue 232,001.50 474,581.14 (242,579.64) 465-Irrigation Sales revenue 0.00 0.00 0.00 466- Sales for Resale 0.00 0.00 0.00 400-Total Revenue 43,616,379.96 38,355,411.29 5,260,968.67 OPERATING EXPENSES 50100 Supervisory Labor 345,768.45 342,997.36 2,771.09 50105 Direct Labor 1,962,282.92 1,987,686.74 (25,403.82) 601.1-6 - Labor - Operations & Maintenance 2,308,051.37 2,330,684.10 (22,632.73) 50100 Supervisory Labor 225,963.47 215,074.06 10,889.41 50105 Direct Labor 768,725.17 715,043.20 53,681.97 50115 Direct Labor transferred in 1,419.23 534.59 884.64 601.7 - Labor - Customer Accounts 996,107.87 930,651.85 65,456.02 50100 Supervisory Labor 1,501,751.74 1,338,955.95 162,795.79 50105 Direct Labor 949,526.55 894,559.67 54,966.88 50110 Supervisory Labor Transferred 0.00 605.27 (605.27) 50115 Direct Labor transferred in 0.00 162.03 (162.03) 50120 Supervisory labor transferred out (669,146.29) (655,197.06) (13,949.23) 50125 Direct labor transferred out (767,990.86) (783,946.62) 15,955.76 601.8- Labor - Administrative & General 1,014,141.14 795,139.24 219,001.90 603-Salaries - Officers & Directors 0.00 0.00 0.00 90950 Fringe Benefits Transferred (17,452.16) (335,855.98) 318,403.82 90953 Fringe Ben Trf Capital & Other (861,914.12) (470,690.30) (391,223.82) 91500 Employee Pension Cost 1,018,920.00 973,532.00 45,388.00 91550 Post Retirement Health Care Accrued 550,188.00 432,648.00 117,540.00 91700 Employee Group Health & Life 1,115,648.62 943,976.02 171,672.60 91800 Employee 401K 131,785.21 121,376.90 10,408.31 91850 Other Employee Benefits 64,592.49 60,693.42 3,899.07 91860 Other Awards 2,227.42 5,258.07 (3,030.65) 604-Employee Pensions & Benefits 2,003,995.46 1,730,938.13 273,057.33 50605 Purchased Water 159,394.56 128,426.41 30,968.15 610- Purchased Water 159,394.56 128,426.41 30,968.15 50610 Purchased power 1,933,476.18 1,775,238.55 158,237.63 615-16 - Purchased Power & Fuel for Power 1,933,476.18 1,775,238.55 158,237.63 50635 Chemicals 282,581.27 241,318.14 41,263.13 618- Chemicals 282,581.27 241,318.14 41,263.13 50300 Material 237,064.85 208,203.54 28,861.31 620.1-6 - Material & Supplies - Operation & Maint 237,064.85 208,203.54 28,861.31 50300 Material 427.54 1,418.67 (991.13) 90100 Office Supplies 53,210.46 42,840.48 10,369.98 90700 IT Supplies and Expense 53,270.91 40,930.68 12,340.23 90450 Postage & Air Freight 224,508.64 237,439.51 (12,930.87) 620.7-8 - Material & Supplies - A&G and Cust Care 331,417.55 322,629.34 8,788.21 90850 Corporate M&S Fees 1441,225.83 1,331,989.63 109,236.20 90851 Regulated M&S Fees 1,485,714.38 1,186,909.39 298,804.99 90852 Non-regulated M&S fees 6,473.73 4,886.19 1,587.54 91100 Outside Service - Accounting & Auditing 56,177.20 53,483.00 2,694.20 91200 Outside Service - Legal 38,952.03 10,224.78 28,727.25 91250 Outside Service - IS 172,087.22 185,662.44 (13,575.22) 91300 Outside Service - Temporary Help 51,994.25 15,922.11 36,072.14 91310 Outside Services -Management Fees Other 186,752.07 170,757.73 15,994.34 91350 Outside Service - Other 69,580.24 96,319.27 (26,739.03) 631-34 - Contract Services - Professional 3,508,956.95 3,056,154.54 452,802.41 50420 Lab Testing Fees 68,379.61 65,901.75 2,477.86 ISREt3OE0 BU 00060 2012.12-31.xts Page 1 of 3 .\, •_, Report ID: ISREG060 Layout ID: ISREGO60 United Water Idaho General Ledger System Business Unit: 00060 Regulatory Income Statement Period Ending: Dec 31,2012 Run on 03105113 at 05:43 PM Current Prior Increase Year Year (Decrease) 635-Contract Services - Water Testing 68,379.61 65,901.75 2,477.86 50400 Outside Contractors 233,781.35 687,771.59 (453,990.24) 50405 CC&B support costs 356,527.57 88,485.17 268,042.40 50410 Outside Professional Services 73,639.12 75,829.95 (2,190.83) 636-Contract Services - Other 663,948.04 852,086.71 (188,138.67) 50310 Equipment rental 42.42 42.43 (0.01) 50600 Rents 1,575.06 9,493.95 (7,918.89) 90110 Office equipment rental 13,808.13 16,224.54 (2,416.41) 641-42 - Rentals - Property & Equipment 15,425.61 25,760.92 (10,335.31) 50645 Transportation Cost - Other 506,158.66 551,776.42 (45,617.76) 650- Transportation Expense 506,158.66 551 ,776.42 (45,617.76) 91400 Property Insurance 31,095.70 36,797.50 (5,701.80) 91450 General Corporate Insurance 237,798.50 400,149.30 (162,350.80) 91455 Injuries & Damages 0.00 1,108.68 (1,108.68) 91460 Worker compensation 120,615.50 104,813.50 15,802.00 656-59 - Insurance 389,509.70 542,868.98 (153,359.28) 90410 Advertising 136,629.53 114,212.33 22,417.20 660- Advertising 136,629.53 114,212.33 22,417.20 92000 Amortization of Rate Case Expense 63,119.49 41,820.00 21,299.49 666- Rate Case Expense (Amortization) 63,119.49 41,820.00 21,299.49 92050 Amortization of Deferred Expenses 77,594.37 63,984.00 13,610.37 667 - Regulatory Comm. Exp. (Amortization) 77,594.37 63,984.00 13,610.37 90400 Bad Debt Expense - write-off 220,450.59 139,530.86 80,919.73 90405 Bad Debt Exp - provision (allowance) 52,267.00 8,400.00 43,867.00 670- Bad Debt Expense 272,717.59 147,930.86 124,786.73 50620 Other Utilities 27,611.88 33,451.69 (5,839.81) 50625 Waste Disposal - Sludge 18.00 0.00 18.00 50650 Meals 9,567.42 8,661.80 905.62 50655 Miscellaneous Expenses 147,375.24 142,523.73 4,851.51 90150 Dues & Subscriptions 411.79 347.48 64.31 90200 Licenses and Fees 8,550.66 5,932.04 2,618.62 90250 Telephone 152,983.13 153,413.68 (430.55) 90300 Other Utilities G&A 19,814.36 20,750.35 (935.99) 90500 Club and Professional Dues 86,468.38 86,302.68 165.70 90600 Travel Expense 34,382.25 32,441.84 1,940.41 90750 IT System Support 1,537.00 212.00 1,325.00 92052 Amortization of Relocation Exp 12,645.61 0.00 12,645.61 92053 Amortization of Tank Painting 44,380.99 33,858.24 10,522.75 92056 Amortization of OPEB Costs 40,560.00 40,560.00 0.00 92061 Amortization of Power Costs 196,274.89 337,044.00 (140,769.11) 92064 Amort of AFUDC Equity GU 38,361.44 34,931.36 3,430.08 92150 Staff Meetings, Conferences & Seminars 20,060.70 21,442.59 (1,381.89) 92200 Clothing & Uniforms 9,913.47 8,606.87 1,306.60 92450 Severance Plan 27,322.31 0.00 27,322.31 92500 Claims & Settlements 22.88 0.00 22.88 92550 Safety equipment 38,365.12 20,179.57 18,185.55 92600 Other misc G&A expenses 82,097.47 58,786.09 23,311.38 675- Miscellaneous 998,724.99 1,039,446.01 (40,721.02) Total Operating Expenses (less Reg. Comm. 15,967,394.79 14,965,171.82 1,002,222.97 Depreciation, Taxes) 70100 Depreciation 7,908,297.99 7,539.599.29 368,698.70 403- Depreciation Expense 7,908,297.99 7,539,599.29 368,698.70 92100 Amortization of Goodwill 9,324.00 9,366.00 (42.00) 406 - Amortization, Utility Plant Acquisition Adj 9,324.00 9,366.00 (42.00) 407 - Amortization Exp. - Other Utility Plant 0.00 91900 Regulatory Commission Expense 89,751.66 85,878.74 3,872.92 408.10- Regulatory Fees 89,751.66 85,878.74 3,872.92 70200 Real Estate 1,791,429.45 1,654,183.10 137,246.35 408.11 - Property Taxes 1,791,429.45 1,654,183.10 137,246.35 70251 FICA Taxes 417,231.63 420,938.92 (3.707.29) 70252 Federal Unemployment Taxes 4,194.96 5,563.57 (1,368.61) 70253 State Unemployment Taxes 30,961.68 30,940.07 21.61 408.12- Payroll Taxes 452,388.27 457,442.56 (5,054.29) 408.13- Other Taxes 0.00 80100 Current - Federal 3,819,895.00 2,953,153.00 866,742.00 409.10- Federal Income Taxes 3,819,895.00 2,953,153.00 866,742.00 80150 Current - State 844,120.83 638,488.84 205,631.99 409.11 - State Income Taxes 844,120.83 638,488.84 205,631.99 80200 Deferred - Federal Income Taxes 570,815.18 622,237.57 (51,422.39) 410.10- Prov for Deferred Income Tax - Federal 570,815.18 622,237.57 (51,422.39) ISREGO60 BU 00060 2012-12-31.xls Page 2 of 3 Report ID: ISREGO60 Layout ID: ISREGO60 United Water Idaho General Ledger System Business Unit: 00060 Regulatory Income Statement Period Ending: Dec 31,2012 tun o, 03105113 t 0I43 PM Current Prior increase Year Year (Decrease) 80250 Deferred - State Income taxes 167,572.63 179,971.53 (12,398.90) 410.11 - Prov for Deferred Income Tax - State 167,572.63 179,971.53 (12,398.90) 411 - Prov for Deferred Utility Income Tax Credits 0.00 80400 Investment Tax Credit Amortization (48,240.00) (48,408.00) 168.00 412-Investment Tax Credits - Utility (48,240.00) (48,408.00) 168.00 Total Expenses from operations before interest 31,572,749.80 29,057,084.45 2,515,665.35 413-Income from Utility Plant Leased to Others 0.00 0.00 0.00 71200 Income on Disposition of Property 0.00 13,720.00 (13,720.00) 414-Gains (Losses) from Disposition of Util Plant 0.00 13,720.00 (13,720.00) Net Operating Income 12,043,630.16 9,312,046.84 2,731,583.32 71100 Merchandising & Jobbing 299,097.76 284,269.30 14,828.46 415-Revenues, Mdsing, Jobbing & Contract Work 299,097.76 284,269.30 14,828.46 71105 Mdse & Jobbing - Expense (256,949.29) (244,665.68) (12.283.61) 416-Expenses, Mdsing, Jobbing & Contract Work (256,949.29) (244,665.68) (12,283.61) 419 - Interest & Dividend Income Other 0.00 71050 AFUDC (Cr) Debt 39,647.74 156,495.93 (116,848.19) 71060 AFUDC (Cr) Equity 66,524.65 262,583.87 (196,059.22) 71070 AFUDC (Cr) - Gross Up 44,269.80 173,735.57 (129,465.77) 420- Allowance for Funds Used During Constructic 150,442.19 592,815.37 (442,373.18) 70900 Interest Income 1,689.16 0.00 1,689.16 71250 Misc non operating income (29.839.00) (22,499.20) (7,339.80) 71251 Misc Non Operating Rental Income 72,610.88 53,966.20 18,644.68 421 - Miscellaneous Non-Utility Income 44,461.04 31,467.00 12,994.04 71252 Misc non operating deductions (549.68) (1,655.06) 1,105.38 71253 Penalties (62.00) 0.00 (62.00) 71254 Charitable Contributions - Reg Companies (19,402.02) (22,993.85) 3,591.83 71261 Federal PAC Withholding 165.00 110.00 55.00 71264 Union Dues Withholding (1,050.00) 50.00 (1,100.00) 71300 Equity Earnings of Affiliates (212.00) (490.00) 278.00 426- Miscellaneous Non-Utility Expense (21,110.70) (24,978.91) 3,868.21 408.20- Other Taxes, Non-Utility Operations 0.00 0.00 0.00 409.20- Income Taxes, Non-Utility Operations 0.00 0.00 0.00 Net Non-Utility Income 215,941.00 638,907.08 (422,966.08) Gross Income 12,259,571.16 9,950,953.92 2,308,617.24 70800 Interest on Debt to Assoc Companies 4,309,152.00 4,408,446.00 (99,294.00) 427.3 - Interest Expense on Long-Term Debt 4,309,152.00 4,408,446.00 (99,294.00) 71000 Other Interest 922.07 6,045.68 (5.123.61) 427.5- Other Interest Charges 922.07 6,045.68 (5,123.61) NET INCOME 7,949,497.09 5,536,462.24 2,413,034.85 ISREGO60 BU 00060 2012-12-31 .xis Page 3 of 3 • Report0 1 : BSREG060 Layout ID: BSREG060 Business Unit: 00060 Period Ending: Dec 31, 2012 Roes., 03105113 0001:26 PM United Water Idaho General Ledger System Regulatory Balance Sheet Prior Variance to Prior Year Actual Year Amount Assets Utility Plant 10100 - Utility Plant in Service 101 Utility Plant in Service 103 Plant held for future use 10700 Construction work in progress 107 Construction Work in Progress 11400 Utility plant acquisition adjustment 114 Utility Plant Acquisition Adjustment Sub Total - Utility Plant 10800 Utility Accumulated Depreciation 10810 Retirement work in progress 11100 Utility Accumulated Depreciation - CIAC 108.1 Accumulated Depreciation 108.3 Accum Deprec - Property Held for Future Use 11500 Amort. of Utility Plant Acquisition Adjustment 115 Accum Amortization - Acquisition Adj Net Utility Plant Investments 12100 Non-Utility Property 12410 Equity Earnings Non-Consolidated Companies 125 Other Investments Total Investments Current Assets 13100 Operations Cash Account Current 13120 Collections 13130 Disbursements (local accounts) 13501 Working Funds 131 Cash 135 Short Term Investments 14200 Customer Accounts Receivable Billing System 141 AcctslNotes Receivable - Customers 14309 Accounts Receivable-Other 14310 Accounts receivable - M&J billed 14311 Accounts receivable - M&J cost 142 Other Receivables 14400 Provision for Uncollectible Accounts (Cr) 143 Provision for Uncollectable Accounts 145 Receivables from Associated Companies 15400 Capital & Maintenance Inventory Nonexempt 15410 Small Repairs Inventory Exempt 15420 Other Inventory 15430 Chemical Inventory 151 Material & Supplies Inventory 16599 Prepaid Expenses-Other 162 Prepaid Expenses 17300 Unbilled Revenue 173 Accrued Utility Revenue Total Current Assets Deferred Debits 181 Unarnort Debt Discount and Expense 183 Preliminary Survey and Investigation 18680 Deferred rate charges 184 Deferred Rate Case Expense 18409 Clearing Expense- General 18450 Clearing - Payroll Accrual 18609 Deferred Employee Benefits-Other 18611 Deferred PensionIOPEB 18620 Deferred Tank Painting Expense 18621 Deferred Relocation Exp - Approved 18623 Deferred AFUDC Equity Gross Up 18625 Deferred Power Costs - Approved 18650 Reg Deferred Tank Painting - Amort 18653 Deferred AFUDC Equity Gross-Up Amort. 18699 Other Regulatory Assets 18714 Deferred Power Costs - Pending 18719 Other Deferred Charges 18799 Other Deferred Charges-Non Utility 186 Other Deferred Charges Total Deferred Debits 357,709,885.73 357,709,885.73 0.00 2,595,068.25 2,595,068.25 600,761.18 600,761.18 360,905,715.16 (87,251,296.81) 504.81 (24,053,714.20) (111,304,506.20) 0.00 (91,556.18) (91,556.18) 249,509,652.78 18,335.83 100,481.00 118,816.83 118,816.83 259,982.56 41,000.00 0.00 9,950.00 310,932.56 0.00 1,757,595.20 1,757,595.20 58,944.57 36,535.20 89,698.01 185,177.78 (88,867.00) (88,867.00) 0.00 39,938.16 149,230.77 38,182.64 87,376.43 314,728.00 69,050.00 69,050.00 2,677,507.00 2,677,507.00 5,226,123.54 0.00 0.00 135,400.00 135,400.00 94,504.00 89,595.76 464,662.16 156,251.00 907,240.49 41,993.00 1,365,514.50 382,175.00 (149,542.21) (81,360.91) 86,138.00 33,291.78 0.00 0.00 3,390,462.57 3,525,862.57 347,313,800.62 347,313,800.62 0.00 2,977,067.87 2,977,067.87 600,761.18 600,761.18 350,891,629.67 (80,532,169.19) 37,254.47 (21,958,355.21) (102,453,269.93) 0.00 (82,232.18) (82,232.18) 248,356,127.56 16,349.83 100,693.00 117,042.83 117,042.83 261,872.93 41,000.00 100.00 9,950.00 312,922.93 0.00 2,192,081.02 2,192,081.02 50,066.91 68,858.93 47,518.22 166,444.06 (36,600.00) (36,600.00) 0.00 32,724.99 134,138.25 35,390.38 70,271.47 272,525.09 11,151.00 11,151.00 2,670,927.00 2,670,927.00 5,589,451.10 0.00 0.00 183,275.42 183,275.42 46,836.00 86,840.32 0.00 196,811.00 907,240.49 0.00 1,321,244.70 393,657.27 (105,161.22) (42,999.47) 90,012.00 184,626.58 74,272.37 64.68 3,153,444.72 3,336,720.14 10,396,085.11 10,396,085.11 0.00 (381,999.62) (381,999.62) 0.00 0.00 10,014,085.49 (6,719,127.62) (36,749.66) (2,095,358.99) (8,851,236.27) 0.00 (9,324.00) (9,324.00) 1,153,525.22 1,986.00 (212.00) 1,774.00 1,774.00 (1,890.37) 0.00 (100.00) 0.00 (1,990.37) 0.00 (434,485.82) (434,485.82) 8,877.66 (32,323.73) 42,179.79 18,733.72 (52,267.00) (52,267.00) 0.00 7,213.17 15,092.52 2,792.26 17,104.96 42,202.91 57,899.00 57,899.00 6,580.00 6,580.00 (363,327.56) 0.00 0.00 (47,875.42) (47,875.42) 47,668.00 2,755.44 464,662.16 (40,560.00) 0.00 41,993.00 44,269.80 (11,482.27) (44,380.99) (38,361.44) (3,874.00) (151334.80) (74,272.37) (64.68) 237,017.85 189,142.43 Page 1 of 5 Report ID: BSREGO60 Layout ID: BSREGO60 Business Unit 00060 Period Ending: Dec 31, 2012 Ron on 0310511351 01:28 PM United Water Idaho General Ledger System Regulatory Balance Sheet - I Prior Variance to Prior Year Actual Year Amount Total Assets 258,380,455.72 257,399,341.63 981,114.09 Page 2 of 5 Report4D: BSREG060 Layout ID: BSREG060 Business Unit 00060 United Water Idaho General Ledger System Period Ending: Dec 31, 2012 Run on 03105113 at 01:26 Regulatory Balance Sheet Prior Variance to Prior Year Actual Year Amount Capitalization and Liabilities Capital 20100 Common Stock Issued 1,261,750.00 1,261,750.00 0.00 201.3 Common Stock Issued 1,261,750.00 1,261,750.00 0.00 204.6 Preferred Stock Issued 0.00 0.00 0.00 20700 Additional Paid-in Capital 76,704,330.21 76,704,330.21 0.00 207.13 Miscellaneous Capital Accounts 76,704,330.21 76,704,330.21 0.00 21600 Retained Earnings - Cumulated Income 84,327,809.87 79,791,347.63 4,536,462.24 21800 OCI - Pension (5,048,711.00) (4,161,872.00) (886,839.00) 21805 OCt - PBOP (1,431,436.00) (277,371.00) (1,154,065.00) 40105 Metered sales—residential consumption revenue 29,738,014.95 25,912,828.55 3,825,186.40 40110 Metered sales—commercial consumption revenue 12,766,258.68 11,161,312.11 1604,946.57 40120 Metered sales—public auth's consumption revenue 190,426.50 154,475.93 35,950.57 40140 Private fire protection facility charge 880,104.83 806,689.49 73,415.34 40200 Miscellaneous Service Revenue 26,995.00 127,432.21 (100,437.21) 40205 Rents from Water Property 8,000.00 7,300.00 700.00 40300 Reg Unbilled consumption revenue 6,580.00 185,373.00 (178,793.00) 50100 Supervisory Labor (2,073,483.66) (1,897,027.37) (176,456.29) 50105 Direct Labor (3,680,534.64) (3,597,289.61) (83,245.03) 50110 Supervisory Labor Transferred 0.00 (605.27) 605.27 50115 Direct Labor transferred in (1,419.23) (696.62) (722.61) 50120 Supervisory labor transferred out 669,146.29 655,197.06 13,949.23 50125 Direct labor transferred out 767,990.86 783,946.62 (15,955.76) 50300 Material (237,492.39) (209,622.21) (27,870.18) 50310 Equipment rental (42.42) (42.43) 0.01 50400 Outside Contractors (233,781.35) (687,771.59) 453,990.24 50405 CC&B support costs (356,527.57) (88,485.17) (268,042.40) 50410 Outside Professional Services (73,639.12) (75,829.95) 2,190.83 50420 Lab Testing Fees (68.379.61) (65,901.75) (2,477.86) 50600 Rents (1,575.06) (9,493.95) 7,918.89 50605 Purchased Water (159,394.56) (128,426.41) (30,968.15) 50610 Purchased power (1,933,476.18) (1,775,238.55) (158,237.63) 50620 Other Utilities (27,611.88) (33,451.69) 5,839.81 50625 Waste Disposal - Sludge (18.00) 0.00 (18.00) 50635 Chemicals (282,581.27) (241,318.14) (41,263.13) 50645 Transportation Cost - Other (506,158.66) (551.776.42) 45,617.76 50650 Meals (9,567.42) (8,661.80) (905.62) 50655 Miscellaneous Expenses (147,375.24) (142,523.73) (4,851.51) 70100 Depreciation (7,908,297.99) (7,539,599.29) (368,698.70) 70200 Real Estate (1,791,429.45) (1,654,183.10) (137,246.35) 70251 FICA Taxes (417,231.63) (420,938.92) 3,707.29 70252 Federal Unemployment Taxes (4,194.96) (5,563.57) 1,368.61 70253 State Unemployment Taxes (30,961.68) (30,940.07) (21.61) 70800 Interest on Debt to Assoc Companies (4,309,152.00) (4,408,446.00) 99,294.00 70900 Interest Income 1,689.16 0.00 1,689.16 71000 Other Interest (922.07) (6,045.68) 5,123.61 71050 AFUDC (Cr) Debt 39,647.74 156,495.93 (116,848.19) 71060 AFUDC (Cr) Equity 66,524.65 262,583.87 (196,059.22) 71070 AFUDC (Cr) - Gross Up 44,269.80 173,735.57 (129.465.77) 71100 Merchandising & Jobbing 299,097.76 284,269.30 14,828.46 71105 Mdse & Jobbing - Expense (256,949.29) (244,665.68) (12,283.61) 71200 Income on Disposition of Property 0.00 13,720.00 (13,720.00) 71250 Misc non operating income (29,839.00) (22,499.20) (7,339.80) 71251 Misc Non Operating Rental Income 72,61088 53,966.20 18,644.68 71252 Misc non operating deductions (549.68) (1,655.06) 1,105.38 71253 Penalties (62.00) 0.00 (62.00) 71254 Charitable Contributions - Reg Companies (19,402.02) (22,993.85) 3,591.83 71261 Federal PAC Withholding 165.00 110.00 55.00 71264 Union Dues Withholding (1,050.00) 50.00 (1,100.00) 71300 Equity Earnings of Affiliates (212.00) (490.00) 278.00 80100 Current - Federal (3,819,895.00) (2,953,153.00) (866,742.00) 80150 Current - State (844,120.83) (638,488.84) (205,631.99) 80200 Deferred - Federal Income Taxes (570,815.18) (622,237.57) 51,422.39 80250 Deferred - State Income taxes (167,572.63) (179,971.53) 12,398.90 80400 Investment Tax Credit Amortization 48,24000 48,408.00 (168.00) 80550 Common Stock Dividend (9,163,000.00) (1,000,000.00) (8,163,000.00) 90100 Office Supplies (53,210.46) (42,840.48) (10,369.98) 90110 Office equipment rental (13,808.13) (16,224.54) 2,416.41 90150 Dues & Subscriptions (411.79) (347.48) (64.31) 90200 Licenses and Fees (8,550.66) (5,932.04) (2,618.62) 90250 Telephone (152,983.13) (153,413.68) 430.55 90300 Other Utilities G&A (19,814.36) (20,750.35) 935.99 90400 Bad Debt Expense - write-off (220,450.59) (139,530.86) (80,919.73) 90405 Bad Debt Exp - provision (allowance) (52,267.00) (8,400.00) (43,867.00) 90410 Advertising (136,629.53) (114,212.33) (22,417.20) 90450 Postage & Air Freight (224,508.64) (237,439.51) 12,930.87 90500 Club and Professional Dues (86,468.38) (86,302.68) (165.70) 90600 Travel Expense (34,382.25) (32,441.84) (1,940.41) 90700 IT Supplies and Expense (53,270.91) (40,930.68) (12,340.23) Page 3 of 5 Report ID: BSREG060 Layout ID: BSREGO60 Business Unit 00060 Period Ending: Dec 31, 2012 Run on 03105113510326 PM United Water Idaho General Ledger System Regulatory Balance Sheet Prior Actual Year (1,537.00) (212.00) (1,441,225.83) (1,331,989.63) (1,485,714.38) (1,186,909.39) (6,473.73) (4,886.19) 17,452.16 335,855.98 861,914.12 470,690.30 (56,177.20) (53,483.00) (38,952.03) (10,224.78) (172,087.22) (185,662.44) (51,994.25) (15,922.11) (186,752.07) (170,757.73) (69,580.24) (96,319.27) (31,095.70) (36,797.50) (237,798.50) (400,149.30) 0.00 (1,108.68) (120,615.50) (104,813.50) (1,018,920.00) (973,532.00) (550,188.00) (432,648.00) (1,115,648.62) (943,976.02) (131,785.21) (121,376.90) (64,592.49) (60,693.42) (2,227.42) (5,258.07) (89,751.66) (85,878.74) (63,119.49) (41,820.00) (77,594.37) (63,984.00) (12,645.61) 0.00 (44,380.99) (33,858.24) (40,560.00) (40,560.00) (196,274.89) (337,044.00) (38,361.44) (34,931.36) (9,324.00) (9,366.00) (20,060.70) (21,442.59) (9,913.47) (8,606.87) (27,322.31) 0.00 (22.88) 0.00 (38,365.12) (20,179.57) (82,097.47) (58,786.09) 76,634,159.96 79,888,566.87 0.00 0.00 154,600,240.17 157,854,647.08 0.00 0.00 0.00 0.00 1,056,613.04 1,168,107.52 768,163.28 651,873.00 517.73 111.69 2,658.28 28,982.16 1,827,952.33 1,849,074.37 0.00 0.00 190,262.76 187,554.51 190,262.76 187,554.51 0.00 0.00 895,801.13 826,287.26 63,518.63 71,402.94 24,568.70 23,363.27 234.07 253.01 760.21 632.72 0.00 25,119.11 984,882.74 947,058.31 4,000,644.10 2,973,147.10 409,117.24 45,096.41 4,409,761.34 3,018,243.51 0.00 0.00 147,802.66 119,462.27 189,400.00 173,796.00 27,322.31 0.00 104,522.00 89,608.00 1,022.88 752.48 7,658.16 2,418.30 40,260.00 38,602.00 480.73 (909.49) 274,903.00 173,472.00 357.27 0.00 0.00 (18,484.40) 0.00 463.52 793,728.99 579,180.68 6,533,742.58 6,681,865.12 (221,534.00) (140,749.00) 6,312,208.58 6,541,116.12 462,973.00 0.00 25,310.00 25,310.00 Variance to Prior Year Amount (1,325.00) (109,236.20) (298,804.99) (1.587.54) (318,403.82) 391,223.82 (2,694.20) (28,727.25) 13,575.22 (36,072.14) (15,994.34) 26,739.03 5,701.80 162,350.80 1,108.68 (15,802.00) (45,388.00) (117.540.00) (171,672.60) (10,408.31) (3,899.07) 3,030.65 (3,872.92) (21,299.49) (13,610.37) (12,645.61) (10,522.75) 0.00 140,769.11 (3,430.08) 42.00 1,381.89 (1,306.60) (27,322.31) (22.88) (18,185.55) (23,311.38) (3,254,406.91) 0.00 (3,254,406.91) 0.00 0.00 (111,494.48) 116,290.28 406.04 (26,323.88) (21,122.04) 0.00 2,708.25 2,708.25 0.00 69,513.87 (7,884.31) 1,205.43 (18.94) 127.49 (25,119.11) 37,824.43 1,027,497.00 364,020.83 1,391,517.83 0.00 28,340.39 15,604.00 27,322.31 14,914.00 270.38 5,239.86 1,658.00 1,390.22 101,431.00 357.27 18,484.40 (463.52) 214,548.31 (148,122.54) (80,785.00) (228,907.54) 462,973.00 0.00 90750 IT System Support 90850 Corporate M&S Fees 90851 Regulated M&S Fees 90852 Non-regulated M&S fees 90950 Fringe Benefits Transferred 90953 Fringe Ben Trf Capital & Other 91100 Outside Service - Accounting & Auditing 91200 Outside Service - Legal 91250 Outside Service - IS 91300 Outside Service - Temporary Help 91310 Outside Services -Management Fees Other 91350 Outside Service - Other 91400 Property Insurance 91450 General Corporate Insurance 91455 Injuries & Damages 91460 Worker compensation 91500 Employee Pension Cost 91550 Post Retirement Health Care Accrued 91700 Employee Group Health & Life 91800 Employee 4011< 91850 Other Employee Benefits 91860 Other Awards 91900 Regulatory Commission Expense 92000 Amortization of Rate Case Expense 92050 Amortization of Deferred Expenses 92052 Amortization of Relocation Exp 92053 Amortization of Tank Painting 92056 Amortization of OPEB Costs 92061 Amortization of Power Costs 92064 Amort of AFUDC Equity GU 92100 Amortization of Goodwill 92150 Staff Meetings, Conferences & Seminars 92200 Clothing & Uniforms 92450 Severance Plan 92500 Claims & Settlements 92550 Safety equipment 92600 Other misc G&A expenses 215 Unappropriated Retained Earnings Other Equities Total Equity Capital Liabilities 221.2 Bonds 223 Advances from Associated Companies 23200 Accounts Payable - System 23210 Accounts Payable Month End Accrual 23220 Accounts Payable - Inventory Accrued 23291 Accounts Payable- Retainage 231 Accounts Payable 232 Notes Payable 23400 Accounts Payables - Associate Companies 233 Accounts Payable - Associated Companies 235 Customer Deposits (Refundable) 23601 Property Taxes Accrued 23610 Franchise taxes Accrued 23661 FICA Tax Accrued 23663 State Unemployment Tax Accrued 23670 Sales & Use Taxes Accrued 23699 Other Accrued Taxes 236.11 Accrued Other Taxes Payable 23641 Federal Income Tax Accrued 23651 State Income Tax Accrued 236.12 Accrued Income Taxes Payable 237.40 Accrued Debt, Interest & Dividends Payable 24205 Accrued - Payroll 24215 Accrued - Power 24235 Accrued - Severance 24245 Accrued - Vacation 24260 Accrued - Employee expense reimbursement 24261 Accrued 4011< 24263 Accrued LTIP 24264 Accrued Stock Option 24268 Accrued SlIP 24299 Accrued Other 24301 Employee W1hg-401 K 24314 Employee W/hg-Fund Raiser 241 Misc current & accrued liabilities 25200 Advances for Construction 25201 Taxable Advances/Service Laterals 252 Advances for Construction 25311 Pension Regulatory Account 25316 Def. Reg. Liab.-Federal-Medicare Part D Page 4 of 5 RCport'l BSREG060 Layout ID: BSREGO60 Business Unit: 00060 Period Ending: Dec 31, 2012 Roe or, 03105113 at 01:26 PM United Water Idaho General Ledger System Regulatory Balance Sheet 25317 Def Reg Liab-State-Medicare Part 0 25340 PBOP Liability - Trustee 25380 Other Deferred Credits 25381 Deferred Escheats 25386 Deferred Developer Deposits 25386 Deferred M&J Payments From Customers 253 Other Deferred Liabilities 25500 Deferred ITC 255.1 Accumulated Investment Tax Credits - Utility 26340 Pension - Accrued 261.5 Operating Reserves (Pensions & Benefits) 27100 Contribution in Aid of Construction 27101 Taxable CIAC - Serv Laterals 271 Contributions In Aid of Construction 27110 Accumulated Amortization CIAC 272 Accum Amort of Contrib in Aid of Construction 19010 Def. Federal Inc Taxes- Other 19012 Del. State Income Taxes- Other 19013 Def. Federal Income Taxes-Medicare Part D 19014 Del. Federal Income Taxes-GU-Medicare Part D 19015 Del. State Income Taxes-Medicare Part 0 19016 Def. State Income Taxes-GU-Medicare Part D 19101 Def. FIT-FAS109 ITC 19103 Def. FIT-F71/F109 GIU ITC 19131 Del.SIT-FAS1 09 ITC 19132 Del. SIT-F71/F109 G/U ITC 25402 DefRegLiab F71/F1 09-Fed:ITC 28203 Del. FIT-MACRS 28206 Del. FIT- OCI Pension/POOP 28211 Def. FIT Benefit on DSIT 28300 Del. FIT-Other 28301 Del. FIT-Tank Painting 28302 Del. FIT-Rate Expenses 28303 Del. FIT-Deferred Charges 28304 Del. FIT-Relocation Expense 28305 Del. FIT-M_S Fees 28306 Del. FIT-Pensions 28307 Del. FIT-PEBOP 28308 Del. FIT-Cost of Removal 28310 Del. FIT-Uncollectibles 28312 Del. FIT - AFUDC Equity 28313 Del. FIT - AFUDC Equity GU 28314 Def. FIT - AFUDC Equity GU-TRF 28350 Del. SIT- Other 28353 Del. SIT - Tank Painting 28354 Del. SIT-Pensions 28355 Del. SIT-Post Retirement Benefits 28356 Del. SIT-AFUDC Equity 28357 Del. SIT-Excess Depreciation 28358 Del. SIT- Cost of Removal 28359 Del. SIT- Relocation 28360 Del. SIT- OCI Pension/PBOP 28363 Del. SIT - M&S Fees 28364 Del. SIT - AFUDC Equity GU 28365 Del. SIT - AFUDC Equity GU-TRF 281 Accum def inc tax Total Liabilities Total Liabilities & Capital Actual 3,865.00 7,212,569.59 66,908.16 7,848.47 151,793.88 72,286.16 8,003,554.26 905074.00 905,074.00 11,032,115.00 11,032,115.00 92,128,922.35 912,747.49 93,041,669.84 (24,053,714.20) (24,053,714.20) (94,869.82) (22,292.37) (15,201.00) (10,108.00) (3,572.00) (294.00) (292,632.00) (194,593.00) (68,754.00) (45,729.00) 601,708.00 5,735,535.00 (3,489,311.00) (382,157.00) (92,756.00) 245,039.00 40,105.00 (180,538.00) 13,583.00 (766,998.00) (855,779.00) (1,517,708.00) 394,577.00 (4.00) 347,969.00 415,295.57 624,491.00 (51,900.00) 57,586.00 (239,728.00) (318,050.00) 80,228.00 1,104,193.00 76,433.00 3,192.00 (819,999.00) (188,609.00) 97,596.53 146,771.00 332,719.91 103,780,215.55 258,380,455.72 Prior Year 3,865.00 5,117,257.59 94,119.30 6,886.72 288,011.46 96,947.06 5,632,397.13 953,314.00 953,314.00 10,015,520.00 10,015,520.00 90232,559.99 595,494.04 90,828,054.03 (21,958,355.21) (21,958,355.21) (72,167.00) (16,958.00) (15,201.00) (10.108.00) (3,572.00) (294.00) (308,292.00) (205.009.00) (72,438.00) (48,177.00) 633,916.00 5,462,935.00 (2,403,480.00) (382,157.00) (218,551.00) 259,392.00 59,272.00 (138,643.00) 2.00 (836,955.00) (1,004,541.00) (1,434,734.00) 312,780.00 (4.00) 326,455.00 413,384.57 621,618.00 (67,111.00) 60,959.00 (274,688.00) (298,550.00) 75,172.00 1,006,702.00 57,210.00 1.00 (564,825.00) (205,049.00) 97,146.53 146,096.00 951,537.10 99,544,694.55 257,399,341.63 Variance to Prior Year Amount 0.00 2,095,312.00 (27,211.14) 961.75 (136,217.58) (24,660.90) 2,371,157.13 (48.240.00) (48,240.00) 1,016,595.00 1,016,595.00 1,896,362.36 317,253.45 2,213,615.81 (2.095,358.99) (2,095,358.99) (22,702.82) (5,334.37) 0.00 0.00 0.00 0.00 15,660.00 10,416.00 3,684.00 2,448.00 (32,208.00) 272,600.00 (1.085,831.00) 0.00 125,795.00 (14,353.00) (19,167.00) (41895.00) 13,581.00 69,957.00 148,762.00 (82,974.00) 81,797.00 0.00 21,514.00 1,911.00 2,873.00 15,211.00 (3,373.00) 34,960.00 (19,500.00) 5,056.00 97,491.00 19,223.00 3,191.00 (255.174.00) 16,440.00 450.00 675.00 (618,817.19) 4,235,521.00 981,114.09 Page 5 of 5