Spreadsheet: jeff_dasovich__14084__Undercollection recovery rate analysis
Sheet: PG&E Assessment

PG&E
 | Average [NAME]
 | Class | Rate | Source
 | Residential | 10.68 | PG&E 1999 F&S
 | Medium Commercial |  | Calculated from A-10 tariff |  |  | NOTE: THESE RATES ARE NOT USED ANYWHERE IN SPREADSHEET.
 | Large Industrial |  | Calcuated from E-20T tariff |  |  | EVERYTHING IS DONE ON A CLASS-AVERAGE BASIS.
 | Average Current Rates (incl. 1 c/kWh surcharge)
 | Class | Rate
 | Amortization of Undercollection
 | Amount | 5000 | million
 | Term | 10 | years
 | Carrying Charge | 0.07
 | Annual Charge |  | million
 | Average Usage
 | Class | Peak Load (kW) | Annual Energy (kWh) | Source |  |  |  | Load Factor
 | Residential | n/a |  | PG&E 1999 F&S (annual sales/customer) |  |  |  | n/a
 | Medium Commercial |  |  | Calculated for Example Customer
 | Large Industrial |  |  | Calculated for Example Customer
 | Class | Class-Average Annual Energy (kWh) | Source
 | Residential |  | PG&E 1999 F&S (annual sales/customer)
 | Commercial |  | PG&E 1999 F&S (annual sales/customer)
 | Industrial |  | PG&E 1999 F&S (annual sales/customer)
 | Class Sales
 | Class | Sales (millions of KWh) | Source |  |  |  | Percent of Sales
 | Residential | 27739 | PG&E 1999 F&S (annual sales/customer)
 | Commercial | 30426 | PG&E 1999 F&S (annual sales/customer)
 | Industrial | 16722 | PG&E 1999 F&S (annual sales/customer)
 | Other |  | PG&E 1999 F&S (annual sales/customer)
 | Total | 79230 | PG&E 1999 F&S (annual sales/customer)
 | Revenues
 | (excluding 1 c/kWh surcharge)
 | Class | Revenues ($million)
 | Residential | 2962 | PG&E 1999 F&S (annual sales/customer)
 | Commercial | 2837 | PG&E 1999 F&S (annual sales/customer)
 | Industrial | 864 | PG&E 1999 F&S (annual sales/customer)
 | Other |  | PG&E 1999 F&S (annual sales/customer)
 | Total | 7121 | PG&E 1999 F&S (annual sales/customer)
 | Revenues
 | (including 1 c/kWh surcharge)
 | Class | Revenues ($million)
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | Average Revenue per Unit Sale
 | (includes 1 c/kWh surcharge)
 | Class | Rate (c/kWh)
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | [NAME]
 | % of res class exempt from rate increase
 | Incremental Quarterly Rate Increase |  |  | 0.025
 | Discount Rate
 | Rate Increase cap
 |  | 0 | 1
 |  | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1
 |  | 2001 | 2001 |  |  | 2002
 | Present Worth Factor |  | 1
 | Approach  1: Flat (Mortgage type) rate increase
 | Rate Increase (%) | 0
 | Rate Increase (c/kWh) | 0
 | Revenue Increase (%) | 0
 | Revenue Increase ($millions) | 0
 | Allocation of Increases to Classes |  |  |  |  |  |  |  |  |  |  | NOTE: MUST UPDATE THIS TABLE MANUALLY!
 |  |  | % allocation | Sales | Sales that get rate increase |  | Rate Increase w/o [NAME] (c/kWh) | Rate Increase w/ [NAME] (c/kWh) | Rate Increase w/o [NAME] (%) | Rate Increase w/ [NAME] (%) |  | Mortgage Style Recovery of Undercollection
 | Residential |  |  |  |  |  |  |  |  |  |  |  | Length of Recovery Period
 | Commercial |  | 1 |  |  |  |  |  |  |  |  |  | 5 years |  | 10 years
 | Industrial |  | 1 |  |  |  |  |  |  |  |  |  | Rate Inc (c/kWh) | Rate Inc (%) | Rate Inc (c/kWh) | Rate Inc (%)
 | Other |  | 1 |  |  |  |  |  |  |  |  | No Res. Exclusion | 1.51 | 0.151 | 0.88 | 0.088
 | Total |  |  |  |  |  |  |  |  |  |  | Res. Exclusion | 1.71 | 0.175 | 1 | 0.102
 | Revenues (incremental to current revenues)
 | Residential | 0
 | Commercial | 0
 | Industrial | 0
 | Other | 0
 | Total | 0
 | Cumulative Increase | 0
 | PW of Increase | 0
 | Revenues (Total)
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | Rates | Old Rate | New Rate
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 |  | Amortization Period
 |  |  | 5 year |  | 10 year
 |  | Old Rate | New Rate | % Increase | New Rate | % Increase
 | Residential |  |  |  | 12.34439717274013 |  |  | NOTE: MUST UPDATE THESE DATA MANUALLY
 | Commercial |  |  |  | 11.32369794803136
 | Industrial |  |  |  | 7.166281874856733
 | Other |  |  |  | 12.54514153717663
 | Total |  |  |  | 10.87055638203651
 | Approach 2: Phased Increases in Revenues (allocated on an equal cents/kWh basis) |  |  |  |  |  |  | Rev cap | 0.25 |  | USE THIS CELL TO SET REVENUE CAP
 |  |  |  |  |  |  |  |  |  |  | USE CELL C148 TO CALCULATE NUMBER OF QUARTERS THAT RATE INCREASE IS IN PLACE
 | Making Payments?
 | Revenue Increase (%)
 | Rate Increase (c/kWh)
 | Rate Increase (%)
 | Revenue Increase ($millions)
 | Revenues (incremental to current revenues)
 | Residential | 0
 | Commercial | 0
 | Industrial | 0
 | Other | 0
 | Total | 0
 | Cumulative Increase | 0
 | PW of Increase | 0
 | Revenues (Total)
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | Rates
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | Approach 3: Phased Rate Increases (allocated on an equal percentage rate increase basis)
 | Rate Increase (%) |  |  | 0.05790075466415212 | 0.08685113199622796 | 0.1158015093283045 | 0.1447518866603807 | 0.1737022639924566 | 0.2026526413245329 | 0.2316030186566087 | 0.2605533959886852 | 0.2895037733207608 | 0.289503773320761 | 0.289503773320761 | 0.289503773320761 | 0.289503773320761 | 0.289503773320761 | 0.289503773320761 | 0.289503773320761 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Rate Increase (c/kWh)
 | Revenue Increase (%)
 | Revenue Increase ($millions)
 | Revenues (incremental to current revenues)
 | Residential | 0
 | Commercial | 0
 | Industrial | 0
 | Other | 0
 | Total
 | Cumulative Increase | 0
 | PW of Increase | 0
 | Revenues (Total)
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | Rates
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 | Graphing Results
PW of amortization | Equal % Rate Increase Quarterly
 | Mortgage Style Revenue Increase
 | Equal % Revenue Increase Quarterly
Rate Increase
Annual revenue increases
Res Rates
Com Rates
Ind Rates
Approach 2 | Residential
 | Commercial
 | Industrial
 | Total
Approach 3 | Residential
 | Commercial
 | Industrial
 | Total
 |  |  | Scenario 2 | Term: |  | [NAME]:
 |  |  | 10 years
 |  | Quarter | Residential | Commercial | Industrial | Total
 |  | 0 | 11.67810663686506 | 10.32426214421876 | 6.166846071044134 | 9.9877571626909 |  | 11.67810663686506 | 10.32426214421876 | 6.166846071044134 | 9.9877571626909
 |  | 1 | 11.90349703263938 | 10.62315342896916 | 6.345378591749694 | 10.23745109175817 |  | 11.89634138777544 | 10.65161427058432 | 6.494198197409695 | 10.27690650125195
 |  |  | 12.12888742841368 | 10.92204471371956 | 6.523911112455251 | 10.48714502082544 |  | 12.08479726557549 | 10.93429808728441 | 6.776882014109781 | 10.52660043031922
 |  |  | 12.35427782418799 | 11.22093599846997 | 6.702443633160808 | 10.73683894989271 |  | 12.27325314337555 | 11.21698190398449 | 7.059565830809869 | 10.77629435938649
 |  |  | 12.57966821996231 | 11.51982728322037 | 6.880976153866369 | 10.98653287895999 |  | 12.37286990146129 | 11.3664070411131 | 7.208990967938471 | 10.90828122027794
 |  |  | 12.80505861573662 | 11.81871856797077 | 7.059508674571928 | 11.23622680802726
 |  |  | 13.03044901151093 | 12.11760985272117 | 7.238041195277485 | 11.48592073709453
 |  |  | 13.25583940728524 | 12.41650113747158 | 7.416573715983045 | 11.73561466616181
 |  |  | 13.48122980305955 | 12.71539242222198 | 7.595106236688602 | 11.98530859522908
 |  |  | 13.70662019883386 | 13.01428370697239 | 7.773638757394163 | 12.23500252429635
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099719 | 12.48469645336362
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 13.93201059460817 | 13.31317499172278 | 7.952171278099721 | 12.48469645336363
 |  |  | 11.67810663686506 | 10.32426214421876 | 6.166846071044134 | 9.9877571626909