Spreadsheet: 09c53fca-c129-4d58-87f7-8b9ca8347167
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 |  | Unnamed: 7 | Unnamed: 8 | SCHEDULE A | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
UNITED WATER NEW YORK
Financial Report for Twelve Months Ended August 31, 2011
(Thousands of Dollars)
 |  | Actual per | Actual per |  |  |  |  | Adjusted
 |  | Books | Books | Average |  | Adjustments |  | Results
 |  | as of Aug 10 | as of Aug 11 | 13 months
 |  | -1 | -2 | -3 |  | -4 |  | -5
-1 | Utility Plant in Service | 323530 | 340693 | 332111.5 |  | 0 |  | 332111.5
-2 | CWIP | 32065 | 37740 | 34902.5 |  |  |  | 34902.5
-3 | Plant Held for Future Use | 8793 | 8793 | 8793 |  |  |  | 8793
-4 | Total Plant in Service | 364388 | 387226 | 375807 |  |  |  | 375807
-5 | Less:  Accumulated Depreciation | 81529 | 85081 | 83305 |  |  |  | 83305
-6 | Net Plant in Service | 282859 | 302145 | 292502 |  | 0 |  | 292502
 | Additions:
-7 | Prepaid Property Taxes | 309 | 410 | 359.5 |  |  |  | 359.5
-8 | Other Prepayments | 33 | 41 | 37 |  |  |  | 37
-9 | Deferred Tank Painting (net of tax) | 515 | 500 | 507.5 |  | -199.4475 |  | 308.0525
-10 | Deferred Rate Case Expense | 704 | 485 | 594.5 |  | -233.6385 |  | 360.8615
-11 | Materials and Supplies | 1029 | 861 | 945 |  |  |  | 945
-12 | Cash Working Capital (b) | 3142.05832443984 | 3322.000773895622 | 3232.029549167732 |  |  |  | 3232.029549167732
 | Deductions: |  |  |  |  |  |  | 0
-13 | Accumulated Deferred Income Taxes | 35780 | 41190 | 38485 |  |  |  | 38485
-14 | Investment Tax Credit | 660 | 634 | 647 |  | 0 |  | 647
-15 | Customer Advances for Construction | 3045 | 2813 | 2929 |  |  |  | 2929
-16 | Total investment upon which a return is earned | 249106.0583244399 | 263127.0007738956 | 256116.5295491677 |  |  |  | 255683.4435491677
-17 | Interest Bearing CWIP | -29408 | -31742 | -30575 |  |  |  | -30575
-18 | Rate Base | 219698.0583244399 | 231385.0007738956 | 225541.5295491677 |  |  |  | 225108.4435491677
-19 | Operating Revenues |  |  | as of Aug 11
-20 | General Sales |  |  | 4 |  |  |  | 4
-21 | Metered Revenues |  |  | 51987 |  |  |  | 51987
-22 | Unbilled Revenue |  |  | 2850 |  |  |  | 2850
-23 | Fire Revenue |  |  | 7435 |  |  |  | 7435
-24 | Unbilled Revenue |  |  | -104 |  |  |  | -104
-25 | Other Sales |  |  | 0 |  |  |  | 0
-26 | Interdepartmental Sales |  |  | 1384 |  |  |  | 1384
-27 | Other Operating Revenues |  |  | 320 |  |  |  | 320
 |  |  |  | 63876 |  |  |  | 63876
 | Adjustments:
-28 | Antennae Revenues (d) |  |  | 196 |  |  |  | 196
-29 | Revenune and [NAME] (c) |  |  | 4261 |  |  |  | 4261
-30 | Fishing (d) |  |  | 0
-31 | Revenue Taxes (d) |  |  | -178 |  |  |  | -178
-32 | NWSS (d) |  |  | 86 |  |  |  | 86
-33 | UIRP  (d) |  |  | 118 |  |  |  | 118
-34 | Total Operating Revenues |  |  | 68359 |  |  |  | 68359
 | Operating Expenses
-35 | Operation & Maintenance |  |  | 29999 |  |  |  | 29999
-36 | Production Cost Reconciliation (c) |  |  | 275 |  |  |  | 275
-37 | Pension Allowance Deferral (c) |  |  | -116 |  |  |  | -116
-38 | OPEB Allowance Deferral (c) |  |  | -243 |  |  |  | -243
-39 | NJ Management Audit (d) |  |  | 0 |  |  |  | 0
-40 | Performance Payment (d) |  |  | 0 |  |  |  | 0
-41 | Annual Depreciation |  |  | 7673 |  |  |  | 7673
-42 | Taxes - Other than Income |  |  | 13241 |  |  |  | 13241
-43 | Property Tax Reconciliation (c) |  |  | -2346 |  |  |  | -2346
-44 | State Income Tax - Current (a) |  |  | 1514 |  | -409.0407261506541 |  | 1104.959273849346
-45 | Federal Income Tax - Current (a) |  |  | 5786 |  | -1691.440892460585 |  | 4094.559107539415
-46 | Deferred Income Taxes |  |  |  |  |  |  | 0
-47 | Investment Tax Credit (Net) |  |  | -26 |  | 10.218 |  | -15.782
-48 | Total Operating Expenses |  |  | 55757 |  |  |  | 53666.73638138876
-49 | Net Operating Income |  |  | 12602 |  |  |  | 14692.26361861124
-50 | RATE OF RETURN - OVERALL |  |  | 0.05587441046972585 |  |  |  | 0.06526749235597726
(a) | Regulatory Tax Calculation - Schedule D
(b) | Cash Working Capital Calculation - Schedule E
 | Target Adjustments to Revnue |  |  | Target/Allow
(c) | Revenue Target for Metered Revenue (net of revenue tax) |  |  | 57468
(c) | Property Tax Target |  |  | 11866
(c) | Production Costs Target |  |  | 5216
(c) | Pension Allowance |  |  | 1911
(c) | OPEB Allowance |  |  | 675
(d) | Required Inclusions/Exclusions per Case No. 09-W-0731
 | Check: | Revenue | Expense
 | Income Statement | 68536 | 55757
 | Earning Calc | 68359 | 55757
 |  | 177 | 0
 | Revenue Taxes | -178
 |  | -1
 | UIRP and NWSS in place from start of revenue month through the effective date of new rates
 | 8/26 - 8/31