HomeMy WebLinkAboutEx 109 to 115, smith.xlsEx 112 Advances-Depr Adj
Ex 114 Rev Req
Ex108 (Carlock) ROR
Ex 113 Tax Calc
Ex 111 Oper Rslts
Ex 110 Rate Base
Ex 115 Raintree
wrk paper Spurwing
Ex 107 (Lobb) Redwood
United Water Idaho
Case UWI-W-00-1
Pro Forma Rate Base Summary
Test Year Ended September 30, 1999
Utility Plant in Service
Accumulated Depreciation
Net Utility Plant
Adjusted
Per Books
Customer Advances for Construction
Contributions in Aid of Construction
Utility Plant Acquisition Adjustment
Accumulated Deferred Income Taxes
Pre-1971 Investment Tax Credits
Deferred Charges
Co. Ex. 15
Pg 1, Col (A)
Working Capital
Total Rate Base
Co. Adj
Elim
Banbury
&SCWC
Remove
Boise R.
Intake
Add
Barber
Water
Raintree
Budget
Co. Adj.
UNITED WATER IDAHO
CIAC
Pro Forma
Cost
Depreciation
Rate
Total
Company
(Brown Ex 9&10)
Retirements
(Brown Ex9)
Adv &
Refunds
Annual
Depr
Exp
annualize
Amort.
Amort
Acq Adj
To 4/00
Elim
Note
Payable
Pro form
Def
Inc Tax
Co Adj
Pre 71
ITC
Def
Reg Asset
Staff
Staff Adj
Rate Base
Per
Adjustment
Books
Test Year
Description
Shown on
09/30/99
Adjustments
Operating Revenues
Operating Expenses
Operation & Maintenance
Exh 11, Sch 1
Exh 11, Sch 2
Amortization Of PHFU
Amortization Of UPAA
Taxes Other Than Income
Exh 11, Sch 3
Payroll Taxes
Total Operating Expenses
Excluding Income Taxes
Op Income Before Income Taxes
Income Taxes
State Income Taxes
Exh 11, Sch 4
Federal Income Taxes
Total Income Taxes
Utility Operating Income
Adjusted Rate Base
Rate of Return on Rate Base
Exhibit No. 11
J. Healy
STATEMENT OF OPERATING INCOME
TEST YEAR ENDED DECEMBER 31, 1999
(Ex No. 11)
CALCULATION OF REVENUE REQUIREMENT
Required Rate of Return
Required net operating income
Net operating income Deficiency
Computation of State and Federal Income Taxes
OPERATING INCOME BEFORE INCOME TAXES
LESS: TAX DEDUCTIONS
Interest Expense (A)
Excess Tax Over Book Depreciation (B)
TOTAL TAX DEDUCTIONS
Taxable Income-State
State Income Tax at 8%
Federal Taxable Income (L.1-L.3-L.7)
Federal Income Tax at 35%
Less: Amortization of ITC
NET FEDERAL INCOME TAX EXPENSE
(A) CALCULATION OF INTEREST EXPENSE DEDUCTION:
Pro Forma Rate Base
Debt Percentage of Capitalization
Debt Portion of Rate Base
Debt Rate
INTEREST EXPENSE
(B) EXCESS TAX OVER BOOK DEPRECIATION:
Pro Forma Tax Depreciation
Pro Forma Book Depreciation
EXCESS TAX OVER BOOK DEPRECIATION
Schedule 4
Actual per Healy Ex13
CALCULATION OF REQUIRED RETURN
Common Equity
Amount
Weighted
Ratio
Note:
Healy used 51.93% to calc Ln 15
rather than Debt ratio on Ln 14 of 56.81%.
Long Term Debt
Minority Interest
Incremental Income Tax Net to Gross Multiplier Calculation
Net Operating Income Requirement
Incremental Federal Income Tax Rate
State Tax Rate
Gross Revenue Increase
Correct
Calculation
Eliminate
Project
C00J001
Depr on
Advances
Investor
Relations
Customer Advances per Ex 15, P1, Col E, Line 4
Power Pumping Equipment
Structures & Improvements
Wells & Springs
Totals
Distributed
Adjusted Net Operating Income realized
State Taxable Income Residual
Net to Gross Multiplier **
**
Correct PUC
Assessment
Ex11,S1,P18
Co. Req
Dif
Staff Adjustment for Depreciation on Advances
Net to Gross Multiplier (L18 / L 8)
Less Uncollectible Accounts Exp.
Less PUC Assessment Rate (2000)
Federal Taxable Income Residual (L 11 - L 13)
Composite Residual (L8 - L 17)
Corrected
With Staff
Company Tax
To Recognize Interest Syncronization & Depreciation
Tax Depr
& Interest
Synchronization
Plant Category
Estimated
Capital Component
(A)
(B)
(C)
(D)
(E)
(F)
Reduce
C98A004
C00B001
C00A106
(G)
(H)
(I)
(J)
(K)
(L)
(M)
(N)
(O)
(P)
(Q)
(R)
(S)
(T)
(U)
(V)
Contributions
Net Rate Base
Balance of Plant Constructed Year 1
Depreciation Expense (@ 3.737%)
Amortization of Contribution
Rate Base Deduction (Contribution or Advance)
Net Depreciation Expense to Customers
Example A: No Refunds Are Made
Year 1
Year 2
Rate Base Addition (Amortization of Contribution)
Rate Base Deduction (Accumulated Depreciation)
Year 3
No Refunds
25% Refunded
Offset for Contribution Amortization
Net Depreciation Passed to Customers
Cummulative
Depreciation Expense Passed to Customers
Subsidy from Existing Customers
Effect of Depreciation Expense on Advances
Per Carlock Recommendation
INVESTMENT IN REDWOOD CREEK
Mains & Valves
Investment
Depr.
Accum
Hydrants
Elec Pump Equip
Structures & Impr.
Replacement Pump
Services
Organization Costs
Land & Land Rights
Depr 4/30/00
Net
Accum Amort UPAA
Floating Feather Well Included Above
Staff Adjustment
Residual Sub-Total
Rate Base Per Co Excluding Floating Feather Well
Rate Base Supportable by Revenues
Staff Rate Base Reduction Adjustment
Treatment Equip
Redwood
Creek
South County
Rates @
(W)
Spurwing
Expense
Spurwing Telementry/Chemical Feed C98C109
Spurwing Replacement Pump C99A106
Total Adjustments
Plant in Serv
(X)
Increase
Proforma
Results
Adjustment to Depreciation Expense
Composite- Uncollectibles, Fees & Taxes (add L 9,10,13 & 16)
(Y)
Ad Valorem Taxes
Effective Net State Tax Rate (L11 * L12)
Effective Net Federal Tax Rate (L 14 * L 15)
RAINTREE ACCOUNTING
Per Co. Witness Linam
Cash
Purchase of system
Plant in Service - Mains
Utility Plant Acquisition Adj
Contribution - Mains & Services
Retained Earnings
Per Staff Proposal
Corrected Entries
Accumulated Amortization
Proposed
Entry
Accounting Entries
Exhibit No. 112
Page of 2
1.00
$5,850,608.00
2.00
3.00
0.45
$2,632,773.60
0.03
$75,297.32
4.00
0.45
2632773.60
0.05
131638.68
5.00
0.10
585060.80
0.02
11701.22
6.00
1.00
$5,850,608.00
0.04
$218,637.22
1.00
$5,850,608.00
$5,850,608.00
$5,850,608.00
2.00
-218637.00
-218637.00
-218637.00
3.00
218637.00
0.00
0.00
4.00
-5850608.00
-5850608.00
-4387956.00
5.00
$0.00
($218,637.00)
$1,244,015.00
6.00
$218,637.22
$218,637.22
$218,637.00
7.00
-218637.22
0.00
0.00
8.00
$0.00
$218,637.22
$218,637.00
9.00
$5,850,608.00
$5,850,608.00
$5,850,608.00
10.00
-437274.00
2.00
-437274.00
2.00
437274.00
218637.00
2.00
11.00
437274.00
2.00
0.00
2.00
0.00
12.00
-5850608.00
-5850608.00
-2925304.00
-5850608.00
0.50
13.00
$0.00
($437,274.00)
$3,362,578.00
14.00
218637.22
218637.22
218637.00
15.00
-218637.22
0.00
0.00
16.00
$0.00
$218,637.22
$218,637.00
17.00
$5,850,608.00
$5,850,608.00
$5,850,608.00
18.00
-655911.00
3.00
-655911.00
3.00
-655911.00
-218637.00
3.00
19.00
655911.00
3.00
0.00
3.00
0.00
20.00
-5850608.00
-5850608.00
-4387956.00
-5850608.00
0.75
21.00
$0.00
($655,911.00)
$806,741.00
22.00
$218,637.00
$218,637.00
$218,637.00
23.00
-218637.00
0.00
0.00
24.00
$0.00
$218,637.00
$218,637.00
25.00
$655,911.00
3.00
$655,911.00
3.00
$655,911.00
3.00
26.00
-655911.00
3.00
0.00
0.00
27.00
$0.00
$655,911.00
$655,911.00
28.00
0.00
$655,911.00
$327,955.50
0.25
218637.00
0.50
218637.00
0.75
218637.00
Exhibit No. 114
1.00
$97,526,384.52
2.00
0.09
3.00
$8,624,634.08
4.00
7649511.00
5.00
$975,123.07
6.00
1.68
7.00
$1,640,854.92
$3,057,100.00
$1,416,245.08
0.46
8.00
1.00
9.00
2.80E-03
10.00
3.43E-03
11.00
0.99
12.00
0.08
13.00
0.08
14.00
0.91
15.00
0.35
16.00
0.32
17.00
0.41
18.00
0.59
19.00
1.68
IPUC Assessment rate spring of 2000 per fiscal division.
.003425% from Healy Ex 11, Sch 1, Pg 13
1.00
$280,574,362.00
0.57
0.08
0.04
2.00
603687.00
1.22E-03
0.05
6.11E-05
3.00
212697897.00
0.43
0.11
0.05
4.00
$493,875,946.00
1.00
0.09
Exhibit No. 113
1.00
$9,284,233.00
$9,817,757.21
2.00
3.00
$4,229,054.79
$4,166,487.42
4.00
$1,671,507.00
$1,991,620.21
5.00
$5,900,561.79
$6,158,107.63
6.00
$3,383,671.21
$3,659,649.58
7.00
$270,693.70
0.08
$292,771.97
0.08
225449.00
2180615.00
8.00
$4,784,484.51
$5,358,497.83
9.00
$1,674,569.58
0.35
$1,875,474.24
0.35
10.00
($47,824.00)
($47,824.00)
11.00
$1,626,745.58
$1,827,650.24
12.00
13.00
$98,992,133.00
$97,526,384.52
14.00
0.57
0.57
15.00
$56,237,430.76
$55,405,417.77
16.00
0.08
0.08
17.00
$4,229,054.79
$4,166,487.42
18.00
19.00
$6,189,895.00
$6,189,895.00
20.00
$4,518,388.00
$4,198,274.79
21.00
$1,671,507.00
$1,991,620.21
Note: Numbers in this column are hard input from Ex 11, Sch 4 for the purpose of correcting error in interest calc on co exhibit. Int Exp (L4) is calculated using corrected debt ratio of 56.81% rather than 51.93 in Co. Ex.
Exhibit 111
Page of 2
0.70
1.00
$26,186,310.00
$226,580.00
$26,412,890.00
$136,118.00
$26,549,008.00
$1,640,854.92
$28,189,862.92
0.06
2.00
$10,463,030.00
$568,532.00
$11,031,562.00
($82,575.00)
$5,282.00
$10,954,269.00
$10,214.32
$10,964,483.32
3.00
3876792.00
641596.00
4518388.00
($3,200.00)
0.20
($4,250.00)
0.05
($7,202.00)
0.02
($218,637.22)
-7371.44
-2722.55
-76730.00
4198274.79
4198274.79
4.00
16664.00
-16664.00
0.00
0.00
0.00
5.00
-31747.00
41075.00
9328.00
9328.00
9328.00
6.00
1236954.00
-30875.00
1206079.00
1206079.00
1206079.00
7.00
361168.00
2132.00
363300.00
363300.00
363300.00
8.00
$15,922,861.00
$1,205,796.00
$17,128,657.00
$0.00
($3,200.00)
($4,250.00)
($7,202.00)
($218,637.22)
($82,575.00)
$5,282.00
($7,371.44)
$0.00
($2,722.55)
($76,730.00)
$0.00
$16,731,250.79
$10,214.32
$16,741,465.11
9.00
$10,263,449.00
($979,216.00)
$9,284,233.00
$0.00
$3,200.00
$4,250.00
$7,202.00
$218,637.22
$82,575.00
($5,282.00)
$7,371.44
$136,118.00
$2,722.55
$76,730.00
$0.00
$9,817,757.21
$1,630,640.59
$11,448,397.80
11.00
$225,449.00
$74,307.00
$299,756.00
($29,062.30)
$256.00
0.08
$0.00
$0.00
$17,490.98
0.08
$6,606.00
0.08
($422.56)
0.08
$0.00
$0.00
$0.00
$0.00
($1,852.15)
$292,771.97
$130,451.25
0.08
423223.21
12.00
2180615.00
($436,894.00)
1743721.00
-69151.42
1030.40
0.35
70401.19
0.35
26589.15
0.35
-1700.80
0.35
104584.73
1875474.24
525066.27
0.35
2400540.51
13.00
$2,406,064.00
($362,587.00)
$2,043,477.00
($98,213.72)
$1,286.40
$0.00
$0.00
$87,892.16
$33,195.15
($2,123.36)
$0.00
$0.00
$0.00
$0.00
$102,732.58
$2,168,246.21
$655,517.52
$2,823,763.73
14.00
$7,857,385.00
($616,629.00)
$7,240,756.00
$98,213.72
$1,913.60
$4,250.00
$7,202.00
$130,745.06
$49,379.85
($3,158.64)
$7,371.44
$136,118.00
$2,722.55
$76,730.00
($102,732.58)
$7,649,511.00
$975,123.07
$8,624,634.08
15.00
$98,992,133.00
$97,526,384.52
$97,526,384.52
16.00
0.07
0.08
0.09
Healy used 51.93% to calculate interest exp deduction rather than 56.81% debt ratio developed in this case. Adjustment reflects staff proposed capital structure.
Per Healy Adj #32, Ex 11, Sch 1, P.32
Recognizes PUC spring 2000 assessment ratio of .28%
Project "Maintenance Software Upgrade" has been cancelled per D. Brown 4/21/00
Per Dan Brown project not yet defined as of 4/21/00. $85,000 is a guess. Not started.
Per Dan Brown project estimate increased by $60,000 but not yet in progress @4/21/00
Per testimony of R. Lobb
Depr Rate for computer software is 20% per Healy Ex11, Sch 2, P.2
Depr rate for water treatment equip 5% per Healy Ex11,Sch2,P2
Depr rate on collecting and impounding reservoirs @ 2% per Healy Ex 11,Sch2,P2
Per R. Lobb Testimony
See Egan-Long Depr workpapers accumulated Depr.
Tax numbers from correction to Ex 11, Schedule 4 after correcting line 15 for debt portion of rate base @ 56.81% rather than 51.93% used in Co. Ex.
Note: These Tax numbers backed into. Tax calculation exhibit incorporates tax effect of other adjustments shown to left.
Exhibit No. 110
Page of 4
1.00
$171,964,522.00
($2,320,273.00)
$152,546.00
$1,429,325.00
$4,753,035.00
($967,551.00)
$175,011,604.00
($16,000.00)
($70,000.00)
($85,000.00)
($360,100.00)
($312,542.84)
($54,451.00)
($1,429,325.00)
$172,684,185.16
2.00
-36220627.00
38653.00
-57386.00
-76730.00
961536.00
967551.00
90526.00
84511.00
-4552913.00
-690976.00
-40598443.00
218637.22
41036.87
1614.26
76730.00
-40260424.65
3.00
$135,743,895.00
$0.00
($2,281,620.00)
$95,160.00
$1,352,595.00
$4,753,035.00
($6,015.00)
$0.00
($4,552,913.00)
($690,976.00)
$0.00
$0.00
$0.00
$134,413,161.00
($16,000.00)
($70,000.00)
($85,000.00)
($360,100.00)
$218,637.22
($271,505.96)
($52,836.74)
($1,352,595.00)
$132,423,760.52
4.00
-5983204.00
-170000.00
302596.00
-17000.00
319596.00
-5850608.00
-5850608.00
5.00
-27205508.00
-84125.00
-296058.00
-13496.00
690976.00
-26908211.00
296058.00
-26612153.00
6.00
976204.00
-158904.00
-31734.00
127170.00
46965.00
-227594.00
-8076.00
628595.00
227594.00
856189.00
7.00
-6152296.00
-304136.00
-6456432.00
-6456432.00
8.00
-20558.00
750.00
-19808.00
-19808.00
9.00
484821.00
461291.00
946112.00
946112.00
10.00
4539324.00
-2300000.00
2239324.00
2239324.00
11.00
$102,382,678.00
($158,904.00)
($2,281,620.00)
$58,000.00
$828,943.00
$4,569,539.00
($6,015.00)
$302,596.00
($4,552,913.00)
$0.00
($8,076.00)
($2,300,000.00)
($304,136.00)
$750.00
$461,291.00
$98,992,133.00
($16,000.00)
($70,000.00)
($85,000.00)
($360,100.00)
$218,637.22
($271,505.96)
($52,836.74)
($828,943.00)
$97,526,384.52
Eliminates Acquisition adjustment of Banbury $31,734 and portion of SCWC not allowed by Commission of $127,170
see Ex15 P.4
See Eagan -Long workpapers: Accum Depr.
See Eagan -Long workpapers: Accum Depr.
See Egan Long Workpaper (elec) Accum Depr.
See Egan-Long ciacadj3 workpaper Col P line 33 and Accum Depr workpaper T68
See egal-Long Ex 15 workpaper working capital computation column K to eliminate payment of note to affiliate.
Egan-Long Ex 15 accum def inc tax worksheet
Egan-Long Ex 15 Pre-1971 ITC worksheet
Per R. Lobb Testimony
Per R. Lobb Testimony
Project "Maintenance Software Upgrade" has been cancelled per D. Brown 4/21/00
Per Dan Brown Water Rights were over estimated. Some yet to be aquired. Actual @4/21/00 $127,431 vs $200,000.
Per Dan Brown project not yet defined as of 4/21/00. $85,000 is a guess. Not started.
Per Dan Brown project estimate increased by $60,000 but not yet in progress @4/21/00
Quail Ridge Reservoir
see Ex 15 pg2
$17,000 Hidden Springs Adj less $319,596 Refunds
See Ex 15 P2
Egan-Long ciac adj3 workpaper
See Egan -Long ciacadj3 workpaper
Per Brown Ex 10 budget estimate CWIP
Egan-Long acq adj workpaper attached to elec file Ex15.
See Linam testimony pg21 & 22. Also egan-long Acq adj workpaper attached to elec file Ex 15.
See Egan-long Acq Adj workpaper attached to elec file Ex 15. Amot allowed amnt 1,153.37 x 7 mos.
Egan-Long Ex 15 accumulated def inc tx worksheet @E24
Eagan-Long Ex15 Deferred Dr worksheet D27 ($18,934) plus additions on lines 22-26 Col D $480,225.
Exhibit No. 115
1.00
$1,429,325.00
$1,429,325.00
2.00
-227594.00
-1133267.00
828943.00
($905,673.00)
3.00
296058.00
296058.00
4.00
76730.00
76730.00
5.00
76730.00
76730.00
6.00
828943.00
828943.00
7.00
828943.00
828943.00
8.00
$1,201,731.00
$1,201,731.00
$1,201,731.00
$1,201,731.00
0.00
9.00
$828,943.00
$0.00
($27,673.00)
0.05
($1,383.65)
$1,614.26
12.00
14.00
($26,058.74)
-26778.00
0.05
-1338.90
0.00
-26778.00
($54,451.00)
($2,722.55)
$1,614.26
($52,836.74)
Per Response to Request No. 65
Per Brown Exhibit No. 9 Page 1
Assume 14 months of Depreciation @ 5% Annual Rate
See R. Lobb Testimony
1.00
$403,890.00
0.02
$8,077.80
$41,062.15
32.00
29.00
12.00
$362,827.85
2.00
15000.00
0.03
375.00
1906.25
13093.75
3.00
172544.00
0.05
8627.20
43854.93
128689.07
4.00
75254.00
0.05
3762.70
19127.06
56126.94
5.00
66577.00
0.02
1331.54
6768.66
59808.34
6.00
295493.00
0.03
8421.55
42809.55
252683.45
7.00
31432.00
0.03
785.80
3994.48
27437.52
8.00
43200.00
0.00
0.00
0.00
43200.00
9.00
52915.00
0.00
0.00
0.00
52915.00
10.00
539.00
0.05
26.95
137.00
402.00
11.00
$1,156,844.00
0.03
$31,408.54
$159,660.08
$997,183.92
12.00
-381032.00
0.03
-12459.75
-53992.23
52.00
12.00
-327039.77
13.00
$775,812.00
0.02
$18,948.79
$105,667.85
$670,144.15
14.00
-110249.00
15.00
14010.81
110249.00
0.03
12.00
61.00
16.00
$573,905.96
17.00
-348106.37
0.87
-45706.37
0.13
-302400.00
18.00
312542.84
0.87
41036.87
0.13
$271,505.96
19.00
($7,371.44)
From Response to Request No. 33
Case 97-6 updated for depr through 4/30/00
Net rate base supportable grossed up by reciprocal of 13.13% accumulated depreciation ratio. (86.87%)
13.13% developed by
dividing Col E Line 19
by Col A Line 19
conservative adjustment! Composite rate @ D17 times RB adjustment rather than gross depreciable plant.