Spreadsheet: jeff_dasovich__14078__core_noncore_request_0522
Sheet: Scenario Summary

 |  | SCENARIO ONE |  |  | SCENARIO TWO |  |  | SCENARIO THREE |  |  | SCENARIO FOUR |  |  | SCENARIO FIVE
 |  | >MOU Forward Prices (1) |  |  | >MOU Forward Prices (1) |  |  | >Forward Price Blend (2) |  |  | >Forward Price Blend (2) |  |  | >Forward Price Blend (2)
 |  | >Pro Rata Shares for |  |  | >Noncore Receives 50% of Core's |  |  | >Pro Rata Shares for |  |  | >Noncore Receives 50% of Core's |  |  | >Noncore Receives 100% of Core's
 |  | Utility Past Costs |  |  | Share of Utility Past Costs |  |  | Utility Past Costs |  |  | Share of Utility Past Costs |  |  | Share of Utility Past Costs
Core's Cost Structure: |  | Cents per kwh: |  |  | Cents per kwh: |  |  | Cents per kwh: |  |  | Cents per kwh: |  |  | Cents per kwh:
 |  | PG&E | SCE |  | PG&E | SCE |  | PG&E | SCE |  | PG&E | SCE |  | PG&E | SCE
Share of past DWR Costs (3) |  | 0.9920604559302073 | 0.4774409166865601 |  | 0.9920604559302073 | 0.4774409166865601 |  | 0.9920604559302073 | 0.4774409166865601 |  | 0.9920604559302073 | 0.4774409166865601 |  | 0.9920604559302073 | 0.4774409166865601
Cost of short position (buys from market) |  | 0 | 0.6456262905396387 |  | 0 | 0.6456262905396387 |  | 0 | 0.5137074571361068 |  | 0 | 0.5137074571361068 |  | 0 | 0.5137074571361068
Value of long position (sales to market) |  | -0.3823980706062193 | 0 |  | -0.3823980706062193 | 0 |  | -0.3042638494486985 | 0 |  | -0.3042638494486985 | 0 |  | -0.3042638494486985 | 0
Cost of utility generation + QF power |  | 6.722699569984051 | 6.67741902345315 |  | 6.722699569984051 | 6.67741902345315 |  | 6.722699569984051 | 6.67741902345315 |  | 6.722699569984051 | 6.67741902345315 |  | 6.722699569984051 | 6.67741902345315
Share of Past Utility costs (4) |  | 0.6058314792274591 | 0.3123895917880162 |  | 0.3029157396137295 | 0.1561947958940081 |  | 0.6058314792274591 | 0.3123895917880162 |  | 0.3029157396137295 | 0.1561947958940081 |  | 0 | 0
Total Generation Cost for Core |  | 7.938193434535498 | 8.112875822467364 |  | 7.635277694921768 | 7.956681026573357 |  | 8.016327655693017 | 7.980956989063833 |  | 7.71341191607929 | 7.824762193169825 |  | 7.410496176465559 | 7.668567397275816
Other T&D Costs |  | 4.8875 | 5.25 |  | 4.8875 | 5.25 |  | 4.8875 | 5.25 |  | 4.8875 | 5.25 |  | 4.8875 | 5.25
Total Cost to Core in Core/Noncore Structure |  | 12.8256934345355 | 13.36287582246737 |  | 12.52277769492177 | 13.20668102657336 |  | 12.90382765569302 | 13.23095698906383 |  | 12.60091191607929 | 13.07476219316982 |  | 12.29799617646556 | 12.91856739727582
Total Cost to Core under CPUC's Recent Decision
Noncore's Cost Structure: |  | Cents per kwh: |  |  | Cents per kwh: |  |  | Cents per kwh: |  |  | Cents per kwh: |  |  | Cents per kwh:
 |  | PG&E | SCE |  | PG&E | SCE |  | PG&E | SCE |  | PG&E | SCE |  | PG&E | SCE
Share of past DWR Costs (3) |  | 0.9920604559302076 | 0.4774409166865599 |  | 0.9920604559302075 | 0.47744091668656 |  | 0.9920604559302076 | 0.4774409166865599 |  | 0.9920604559302076 | 0.4774409166865599 |  | 0.9920604559302076 | 0.4774409166865599
Cost of short position (buys from market) |  | 10.4 | 10.4 |  | 10.4 | 10.4 |  | 8.275 | 8.275 |  | 8.275 | 8.275 |  | 8.275 | 8.275
Share of Past Utility Costs (4) |  | 0.605831479227459 | 0.3123895917880162 |  | 1.131790162095947 | 0.6719154885660925 |  | 0.605831479227459 | 0.3123895917880162 |  | 1.131790162095948 | 0.6719154885660925 |  | 1.657748844964436 | 1.031441385344168
Total Generation Cost for Noncore |  | 11.99789193515767 | 11.18983050847458 |  | 12.52385061802616 | 11.54935640525265 |  | 9.872891935157668 | 9.064830508474575 |  | 10.39885061802616 | 9.424356405252652 |  | 10.92480930089465 | 9.783882302030728
Other T&D Costs |  | 2.212747116542884 | 1.783132079040916 |  | 2.212747116542884 | 1.783132079040916 |  | 2.212747116542884 | 1.783132079040916 |  | 2.212747116542884 | 1.783132079040916 |  | 2.212747116542885 | 1.783132079040916
Total Cost to Noncore in Core/Noncore Structure |  | 14.21063905170055 | 12.97296258751549 |  | 14.73659773456904 | 13.33248848429357 |  | 12.08563905170055 | 10.84796258751549 |  | 12.61159773456904 | 11.20748848429357 |  | 13.13755641743753 | 11.56701438107164
Total Cost to Noncore under CPUC's Recent Decision |  |  | 12.98326646751425
(1) Uses MOU forward price assumptions to create 10-fixed price power proxy (approximately $104/Mwh)
(2) Takes midpoint between MOU forward price assumptions and independent 3rd party expert's price assumptions to create 10-fixed price power proxy (approximately $82.75/Mwh)
(3) 15-year amortization
(4) 20-year amortization