Spreadsheet: jeff_dasovich__14084__Undercollection recovery rate analysis
Sheet: SCE Assessment

SCE
 | Average [NAME]
 | Class | Rate | Source
 | Residential |  | [NAME] 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 | 5
 | 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 | 24351 | [NAME] 1999 F&S
 | Commercial | 33093 | [NAME] 1999 F&S
 | Industrial | 13229 | [NAME] 1999 F&S
 | Other |  | [NAME] 1999 F&S
 | Total | 78602 | [NAME] 1999 F&S
 | Revenues
 | (excluding 1 c/kWh surcharge)
 | Class | Revenues ($million)
 | Residential | 2788 | [NAME] 1999 F&S
 | Commercial | 2894 | [NAME] 1999 F&S
 | Industrial | 736 | [NAME] 1999 F&S
 | Other |  | [NAME] 1999 F&S
 | Total | 7071 | [NAME] 1999 F&S
 | 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
 |  | 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: THIS TABLE MUST BE UPDATED 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.52 | 0.152 | 0.89 | 0.089
 | Total |  |  |  |  |  |  |  |  |  |  | Res. Exclusion | 1.69 | 0.174 | 0.99 | 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
 | Residential
 | Commercial
 | Industrial
 | Other
 | Total
 |  | Amortization Period
 |  |  | 5 year |  | 10 year
 |  | Old Rate | New Rate | % Increase | New Rate | % Increase
 | Residential |  |  |  | 13.11077325940126 |  |  | NOTE: YELLOW CELLS MUST BE UPDATED MANUALLY
 | Commercial |  |  |  | 10.73737901594123
 | Industrial |  |  |  | 7.555861850997092
 | Other |  |  |  | 10.22791806125477
 | Total |  |  |  | 10.88580674981238
 | Approach 2: Phased Increases in Revenues (allocated on an equal cents/kWh basis) |  |  |  |  |  |  | Rev cap | 0.25
 | 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.05737968942844396 | 0.08606953414266627 | 0.1147593788568884 | 0.1434492235711105 | 0.1721390682853323 | 0.2008289129995542 | 0.2295187577137765 | 0.2582086024279986 | 0.2868984471422205 | 0.2868984471422205 | 0.2868984471422205 | 0.2868984471422205 | 0.2868984471422205 | 0.2868984471422205 | 0.2868984471422205 | 0.2868984471422205 | 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
 |  |  | Approach 2 and 3 |  |  |  |  |  | Approach 2: Different caps on increases
 |  |  | Term: |  | [NAME]: |  |  |  | Term:
 |  | Quarter | Residential | Commercial | Industrial | Total
 |  | 0 | 12.44922179787278 | 9.745051823648506 | 6.563534658704362 | 9.995954301417267 |  |  | 12.44922179787278 | 9.745051823648506 | 6.563534658704362 | 9.995954301417267
 |  | 1 | 12.6873326246687 | 10.02463584720103 | 6.751841448839005 | 10.2458531589527 |  |  | 12.6350064801929 | 10.02372884712868 | 6.842211682184534 | 10.2458531589527
 |  |  | 12.92544345146462 | 10.30421987075355 | 6.940148238973645 | 10.49575201648813 |  |  | 12.82079116251301 | 10.30240587060885 | 7.120888705664708 | 10.49575201648813
 |  |  | 13.16355427826054 | 10.58380389430607 | 7.12845502910829 | 10.74565087402356 |  |  | 13.00657584483312 | 10.58108289408903 | 7.399565729144881 | 10.74565087402356
 |  |  | 13.40166510505645 | 10.8633879178586 | 7.316761819242933 | 10.99554973155899 |  |  | 13.19236052715324 | 10.8597599175692 | 7.678242752625055 | 10.995549731559
 |  |  | 13.63977593185238 | 11.14297194141112 | 7.505068609377576 | 11.24544858909442 |  |  | 13.37814520947335 | 11.13843694104937 | 7.956919776105227 | 11.24544858909443
 |  |  | 13.87788675864829 | 11.42255596496364 | 7.693375399512216 | 11.49534744662986 |  |  | 13.56392989179347 | 11.41711396452954 | 8.2355967995854 | 11.49534744662986
 |  |  | 14.11599758544421 | 11.70213998851616 | 7.881682189646859 | 11.74524630416528 |  |  | 13.74971457411359 | 11.69579098800972 | 8.514273823065572 | 11.74524630416529
 |  |  | 14.35410841224013 | 11.98172401206868 | 8.069988979781503 | 11.99514516170072 |  |  | 13.8569332908326 | 11.85661906308823 | 8.675101898144085 | 11.88946613154766
 |  |  | 14.59221923903605 | 12.26130803562121 | 8.258295769916145 | 12.24504401923615
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 14.83033006583197 | 12.54089205917372 | 8.446602560050787 | 12.49494287677158
 |  |  | 12.44922179787278 | 9.745051823648506 | 6.563534658704362 | 9.995954301417267