20050118Griffith Exhibit No. 25.xls

Table A By Schedule
\BACK1
\BLOCK
\BLOCKT
\TBL1
\TBL2
\TBL3
\TBL4
\TBL5
all_months
BACK3
ID_0303_RVN_data
IDcontractsRVN
monthlist
monthtotals
NORMALIZE
OR_305_12mo_endg_200203
Query1
Rates
RevClass
Revenue_by_month_take_2
September_2001_305_Detail
TABLE_1
TABLE_2
TABLE_4
TRANSM_2
UT_305A_FY_2002
weather
TABLE A
UTAH POWER & LIGHT COMPANY
ESTIMATED IMPACT OF PROPOSED REVENUES ON NORMALIZED PRESENT REVENUES
FROM ELECTRIC SALES TO ULTIMATE CONSUMERS
DISTRIBUTED BY RATE SCHEDULES IN IDAHO
Actual
12 MONTH ENDING MARCH 2004
Irrigation -BPA kWh
Present Revenue ($000)
Proposed Revenue ($000)
Change in
Year 3
RMA
PCT
Average
Base Revenue
Net Revenue
(¢)/kWh
Line
Present
Proposed
No. of
Base
Sch. 93
Net
Base
No.
Description
Sch.
Customers
MWH
Revenue
($000)
%
(6)+(7)
(9)+(10)
(9)-(6)
(12)/(6)
(11)-(8)
Residential Sales
BPA
Residential Service
Residential Optional TOD
Irrigation
(¢)
AGA-Revenue
--
Non-Irrigation
Total Residential
Commercial & Industrial
General Service - Large Power
General Svc. - Lg. Power (R&F)
6A
Subtotal-Schedule 6
General Service - Med. Voltage
General Service - High Voltage
10
Comm. & Ind. Space Heating
General Service
General Service (R&F)
23A
Subtotal-Schedule 23
General Service Optional TOD
Special Contract-Monsanto
Total Commercial & Industrial
(Excluding Monsanto)
Public Street Lighting
Security Area Lighting
Security Area Lighting (R&F)
7A
Street Lighting - Company
Street Lighting - Customer
Traffic Signal Systems
Total Public Street Lighting
Total Sales to Ultimate Customers
Notes:
Revenue1
Revenue2
Revenue4
Revenue3
Special Contract-Nu-West
3: Schedule 93-Power Cost and Tax Surcharge (PCT) is estimated to expire September 2005.
4: Excludes Schedule 34-BPA credit.
1: Present base revenues include RMA revenues which are calculated based on current Schedule 94-Rate Mitigation Adjustment (RMA) rates effective June 8, 2004.
(14)/(8)
2: Schedule 93-Power Cost and Tax Surcharge (PCT) revenues are calculated by multiplying normalized actual loads with current PCT rates effective on June 8, 2004.
526206.66
-1.00
1.00
-2.00
1.00
-3.00
1.00
-4.00
1.00
-5.00
1.00
-6.00
1.00
-7.00
1.00
-8.00
1.00
-9.00
1.00
-10.00
1.00
-11.00
1.00
-12.00
1.00
-13.00
1.00
-14.00
1.00
-15.00
1.00
1.00
1.00
1.00
32172.83
306320.61
$24,069.84
$1,171.06
100.00
$25,240.91
$27,659.65
$0.00
$27,659.65
$3,589.81
0.15
$2,418.74
0.10
-0.70
0.38
2.00
1.00
36.00
36.00
15995.50
299983.53
$19,665.64
$244.19
100.00
$19,909.83
$21,817.97
$0.00
$21,817.97
$2,152.33
0.11
$1,908.15
0.10
-0.24
0.08
-3.94
3.00
1.00
$4.95
$0.00
$4.95
$4.95
$0.00
$4.95
$0.00
0.00
$0.00
0.00
-2.33
4.00
1.00
48168.33
606304.14
$43,740.44
$1,415.25
$45,155.69
$49,482.57
$0.00
$49,482.57
$5,742.14
0.13
$4,326.89
0.10
5.00
1.00
6.00
6.00
983.08
298203.74
$17,026.33
$356.65
100.00
$17,382.98
$18,678.58
$0.00
$18,678.58
$1,652.25
0.10
$1,295.60
0.07
0.00
0.12
6.00
1.00
235.42
29339.07
$1,901.53
$0.00
100.00
$1,901.53
$2,085.93
$0.00
$2,085.93
$184.40
0.10
$184.40
0.10
0.00
0.00
7.00
1.00
1218.50
327542.80
$18,927.85
$356.65
$19,284.50
$20,764.51
$0.00
$20,764.51
$1,836.65
0.10
$1,480.00
0.08
8.00
1.00
8.00
8.00
4.00
2648.19
$168.49
$0.00
$168.49
$176.25
$0.00
$176.25
$7.75
0.05
$7.75
0.05
0.25
0.00
9.00
1.00
9.00
9.00
11.25
87749.28
$3,982.76
$78.89
$4,061.65
$4,248.48
$0.00
$4,248.48
$265.71
0.07
$186.82
0.05
0.00
0.09
10.00
1.00
4578.00
674124.21
$39,709.32
$1,143.32
$40,852.64
$45,120.43
$0.00
$45,120.43
$5,411.11
0.14
$4,267.79
0.10
0.65
0.17
11.00
1.00
19.00
19.00
325.75
11281.28
$743.35
$49.02
$792.37
$829.13
$0.00
$829.13
$85.78
0.12
$36.76
0.05
-0.64
0.43
12.00
1.00
23.00
23.00
5140.42
96604.62
$7,233.03
$511.81
$7,744.84
$8,211.28
$0.00
$8,211.28
$978.25
0.14
$466.44
0.06
-1.29
0.53
13.00
1.00
1321.25
15931.23
$1,299.52
$86.87
$1,386.40
$1,423.70
$0.00
$1,423.70
$124.18
0.10
$37.31
0.03
-1.06
0.55
14.00
1.00
6461.67
112535.85
$8,532.55
$598.68
$9,131.24
$9,634.98
$0.00
$9,634.98
$1,102.43
0.13
$503.75
0.06
15.00
1.00
35.00
35.00
2.01
1721.38
$98.67
$1.73
100.00
$100.40
$108.12
$0.00
$108.12
$9.45
0.10
$7.72
0.08
0.00
0.10
16.00
1.00
1.00
1439284.37
$42,906.42
$0.00
100.00
$42,906.42
$42,906.42
$0.00
$42,906.42
$0.00
0.00
$0.00
0.00
17.00
1.00
1.00
117165.00
$4,011.52
$0.00
100.00
$4,011.52
$4,567.00
$0.00
$4,567.00
$555.48
0.14
$555.48
0.14
18.00
1.00
$250.36
$0.00
$250.36
$250.36
$0.00
$250.36
$0.00
0.00
$0.00
0.00
19.00
1.00
12603.18
2774052.36
$119,331.32
$2,228.28
$121,559.60
$128,605.68
$0.00
$128,605.68
$9,274.36
0.08
$7,046.08
0.06
20.00
1.00
12602.18
1334767.99
$76,424.90
$2,228.28
$78,653.18
$85,699.26
$0.00
$85,699.26
$9,274.36
0.12
$7,046.08
0.09
21.00
1.00
7.00
7.00
243.41
296.01
$56.08
$4.69
100.00
$60.77
$68.16
$0.00
$68.16
$12.08
0.22
$7.39
0.12
-6.60
1.59
22.00
1.00
164.60
122.02
$25.30
$2.01
100.00
$27.31
$30.50
$0.00
$30.50
$5.19
0.21
$3.18
0.12
-6.38
1.65
23.00
1.00
11.00
11.00
27.33
126.72
$26.57
$2.24
100.00
$28.81
$32.44
$0.00
$32.44
$5.87
0.22
$3.63
0.13
-8.03
1.77
24.00
1.00
12.00
12.00
219.16
1854.02
$171.33
$14.35
100.00
$185.68
$214.64
$0.00
$214.64
$43.30
0.25
$28.96
0.16
-3.49
0.77
25.00
1.00
12.00
12.00
24.69
245.49
$18.29
$1.48
100.00
$19.77
$20.68
$0.00
$20.68
$2.39
0.13
$0.91
0.05
-2.68
0.60
26.00
1.00
($2.12)
$0.00
($2.12)
($2.12)
$0.00
($2.12)
$0.00
0.00
$0.00
0.00
27.00
1.00
679.19
2644.26
$295.46
$24.76
$320.22
$364.29
$0.00
$364.29
$68.83
0.23
$44.07
0.14
28.00
1.00
61450.69
3383000.76
$163,367.21
$3,668.30
$167,035.51
$178,452.54
$0.00
$178,452.54
$15,085.33
0.09
$11,417.04
0.07
29.00
1.00
61449.69
1943716.39
$120,460.80
$3,668.30
$124,129.09
$135,546.13
$0.00
$135,546.13
$15,085.33
0.13
$11,417.04
0.09