Spreadsheet: jeff_dasovich__14105__Response to 10-12 Workshop Questions
Sheet: Q10

[NAME] 10
[NAME] provide the detailed cost of service analysis to support the cumulative annual cost of
investing in increased supply reliability (as discussed in the September 27
and October 12 workshops).
A. The detailed cost of service for the low and high cases of the supply reliability investments
follow:
 | Note:
 |  | The cost of service for reliability investments was developed on a simplified,
 |  | incremental basis.  Capital costs do not include AFUDC or Section 263a interest.
 |  | Cost of Service does not reflect an allocation of utility common costs or overhead.
 | Assumptions:
 |  |  |  |  | Weight | Rate
 |  | ROE |  |  | 0.48 | 0.124
 |  | Debt |  |  | 0.462 | 0.0726
 |  | Preferred |  |  | 0.058 | 0.066
 |  | Return
 |  | Federal Income Tax Rate |  |  |  |  | 0.35
 |  | State Income Tax |  |  |  |  | 0.0884
 |  | Combined |  |  |  |  | 0.4074599999999999
 |  | O&M  (% of initial plant) |  |  |  |  | 0.03
 |  | Inflation rate |  |  |  |  | 0.025
 |  | Depreciation Rate (30 Yr Life)
 |  | Property Tax Rate (on net plant) |  |  |  |  | 0.02
 |  | Assumes full year rather than mid-year convention for book and tax
 | Pacific Gas & Electric Company
LOW CASE - Option 2 - Other Backbone / Storage Reliability Investments
Illustrative Cost of Service
($ Thousands)
 |  |  |  |  | 2003 | 2004 | 2005 | 2006 | 2007
COST OF SERVICE
 | O & M Expenses |  |  |  | 900 | 922.5 | 945.5625 | 969.2015624999997 | 993.4316015624996
 | Depreciation |  |  |  | 1000 | 2000 | 3933.333333333333 | 4266.666666666667 | 4600
 | Property Taxes |  |  |  | 600 | 594.5 | 567.3375 | 1142.939916666666 | 2357.744334375
 | Debt & Equity Return |  |  |  | 2818.7974956 | 4020.2235756 | 7817.7957696 | 10503.758172 | 10855.1753004
 | Federal Income Tax |  |  |  | 992.3756575384614 | 1415.345380615385 | 2752.304920615385 | 3697.915135384616 | 3821.633779384615
 | State Income Tax |  |  |  | 274.9514452654673 | 392.1410758051777 | 762.5642668538834 | 1024.558697323388 | 1058.836664256253
 | Total Cost of Service |  |  |  | 6586.124598403929 | 9344.71003202056 | 16778.8982904026 | 21605.04015054134 | 23686.82167997837
[NAME]
 | Gas Plant in Service |  |  |  | 30000 | 30000 | 60000 | 118000 | 128000
 | Additions to Plant in Service |  |  |  | 0 | 30000 | 58000 | 10000 | 10000
 | Total |  |  |  | 30000 | 60000 | 118000 | 128000 | 138000
 | Accumulated Depreciation |  |  |  | -1000 | -3000 | -6933.333333333334 | -11200 | -15800
 | Working Capital |  |  |  | 0.45 | 0.45 | 0.45 | 0.45 | 0.45
 | Accumulated Deferred Taxes |  |  |  | -814.92 | -2200.284 | -4492.110679999999 | -6555.705431999999 | -8370.605614799999
 | Net Asset Balance (rate base) |  |  |  | 28185.53 | 54800.166 | 106575.0059866667 | 110244.744568 | 113829.8443852
 | Avg. Asset Balance |  |  |  | 29093 | 41493 | 80688 | 108410 | 112037
Calculation of Return
 | [NAME] |  |  |  | 0.0726 | 0.0726 | 0.0726 | 0.0726 | 0.0726
 | [NAME] |  |  |  | 0.462 | 0.462 | 0.462 | 0.462 | 0.462
 |  |  |  |  | 0.0335412 | 0.0335412 | 0.0335412 | 0.0335412 | 0.0335412
 | Preferred Return |  |  |  | 0.066 | 0.066 | 0.066 | 0.066 | 0.066
 | Preferred Ratio |  |  |  | 0.058 | 0.058 | 0.058 | 0.058 | 0.058
 |  |  |  |  | 0.003828 | 0.003828 | 0.003828 | 0.003828 | 0.003828
 | Equity Return |  |  |  | 0.124 | 0.124 | 0.124 | 0.124 | 0.124
 | Equity Ratio |  |  |  | 0.48 | 0.48 | 0.48 | 0.48 | 0.48
 |  |  |  |  | 0.05952 | 0.05952 | 0.05952 | 0.05952 | 0.05952
 | Overall Return |  |  |  | 0.09688920000000001 | 0.09688920000000001 | 0.09688920000000001 | 0.09688920000000001 | 0.09688920000000001
 | Return on Debt |  |  |  | 975.8141316 | 1391.7250116 | 2706.3723456 | 3636.201492 | 3757.8554244
 | Return on Equity and Preferred |  |  |  | 1842.983364 | 2628.498564 | 5111.423424000001 | 6867.556680000001 | 7097.319876
 | Total Return |  |  |  | 2818.7974956 | 4020.2235756 | 7817.7957696 | 10503.758172 | 10855.1753004
LOW CASE - Option 2 - Other Backbone / Storage Reliability Investments
 |  |  |  |  | 2003 | 2004 | 2005 | 2006 | 2007
Depreciation
 | Gas Plant |  |  |  | 30000 | 60000 | 118000 | 128000 | 138000
 | Depreciation Expense |  |  |  | 1000 | 2000 | 3933.333333333333 | 4266.666666666667 | 4600
 | Accumulated Depreciation |  |  |  | 1000 | 3000 | 6933.333333333334 | 11200 | 15800
Deferred Taxes
 | Tax Depreciation |  |  |  | -3000 | -5400 | -9558 | -9331.2 | -9054.18
 | Book Depreciation |  |  |  | 1000 | 2000 | 3933.333333333333 | 4266.666666666667 | 4600
 | Total Differences |  |  |  | -2000 | -3400 | -5624.666666666666 | -5064.533333333334 | -4454.18
 | Income Tax Rate |  |  |  | 0.4074599999999999 | 0.4074599999999999 | 0.4074599999999999 | 0.4074599999999999 | 0.4074599999999999
 | Deferred Taxes |  |  |  | -814.92 | -1385.364 | -2291.826679999999 | -2063.594752 | -1814.9001828
 | Accumulated Deferred Taxes |  |  |  | -814.92 | -2200.284 | -4492.110679999999 | -6555.705431999999 | -8370.605614799999
Income Taxes
 | Return on rate base |  |  |  | 2818.7974956 | 4020.2235756 | 7817.7957696 | 10503.758172 | 10855.1753004
 | Less:   Debt return |  |  |  | -975.8141316 | -1391.7250116 | -2706.3723456 | -3636.201492 | -3757.8554244
 | Adjusted Taxable Equity return |  |  |  | 1842.983364 | 2628.498564 | 5111.423424000001 | 6867.556680000002 | 7097.319876
 | Federal Tax Rate/(1-Fed. [NAME]) |  |  |  | 0.5384615384615384 | 0.5384615384615384 | 0.5384615384615384 | 0.5384615384615384 | 0.5384615384615384
 | Federal Income Tax |  |  |  | 992.3756575384614 | 1415.345380615385 | 2752.304920615385 | 3697.915135384616 | 3821.633779384615
 | State Tax. Inc.(Eq.Ret.+Fed. Inc.Tax) |  |  |  | 2835.359021538461 | 4043.843944615384 | 7863.728344615385 | 10565.47181538462 | 10918.95365538462
 | State Tax Rate/(1-State Tax Rate) |  |  |  | 0.09697235629662133 | 0.09697235629662133 | 0.09697235629662133 | 0.09697235629662133 | 0.09697235629662133
 | State Income Tax |  |  |  | 274.9514452654673 | 392.1410758051777 | 762.5642668538834 | 1024.558697323388 | 1058.836664256253
 | Total Income Taxes |  |  |  | 1267.327102803929 | 1807.486456420562 | 3514.869187469268 | 4722.473832708003 | 4880.470443640868
Tax Depreciation
 | Tax Basis |  |  |  | 30000 | 60000 | 118000 | 128000 | 138000
 | [NAME]. Rate 15 yr 200% DDB |  |  |  | 0.1 | 0.09 | 0.081 | 0.0729 | 0.06561
 | Tax Depreciation |  |  |  | 3000 | 5400 | 9558 | 9331.2 | 9054.18
HIGH CASE - Option 2 - Other Backbone/Storage Reliability Investments
 |  |  |  |  | 2003 | 2004 | 2005 | 2006 | 2007
COST OF SERVICE
 | O & M Expenses |  |  |  | 1800 | 1845 | 1891.125 | 1938.403124999999 | 1986.863203124999
 | Depreciation |  |  |  | 2000 | 4000 | 7266.666666666667 | 8266.666666666666 | 9266.666666666666
 | Property Taxes |  |  |  | 1200 | 1189 | 1134.675 | 2298.802520833333 | 4337.248784895832
 | Debt & Equity Return |  |  |  | 5637.498102 | 8040.350262 | 14809.51422 | 19859.0886564 | 21545.5420716
 | Federal Income Tax |  |  |  | 1984.717204615385 | 2830.656650769231 | 5213.784046153845 | 6991.518970153846 | 7585.245663692308
 | State Income Tax |  |  |  | 549.8934397542783 | 784.272700833699 | 1444.551211935059 | 1937.097338938131 | 2101.597557419921
 | Total Cost of Service |  |  |  | 13172.10874636966 | 18689.27961360293 | 31760.31614475557 | 41291.57727799198 | 46823.16394739973
[NAME]
 | Gas Plant in Service |  |  |  | 60000 | 60000 | 120000 | 218000 | 248000
 | Additions to Plant in Service |  |  |  | 0 | 60000 | 98000 | 30000 | 30000
 | Total |  |  |  | 60000 | 120000 | 218000 | 248000 | 278000
 | Accumulated Depreciation |  |  |  | -2000 | -6000 | -13266.66666666667 | -21533.33333333334 | -30800
 | Working Capital |  |  |  | 0.45 | 0.45 | 0.45 | 0.45 | 0.45
 | Accumulated Deferred Taxes |  |  |  | -1629.84 | -4400.567999999999 | -8634.620679999998 | -12632.835512 | -16288.9387788
 | Net Asset Balance (rate base) |  |  |  | 56370.61 | 109599.882 | 196099.1626533334 | 213834.2811546667 | 230911.5112212
 | Avg. Asset Balance |  |  |  | 58185 | 82985 | 152850 | 204967 | 222373
Calculation of Return
 | [NAME] |  |  |  | 0.0726 | 0.0726 | 0.0726 | 0.0726 | 0.0726
 | [NAME] |  |  |  | 0.462 | 0.462 | 0.462 | 0.462 | 0.462
 |  |  |  |  | 0.0335412 | 0.0335412 | 0.0335412 | 0.0335412 | 0.0335412
 | Preferred Return |  |  |  | 0.066 | 0.066 | 0.066 | 0.066 | 0.066
 | Preferred Ratio |  |  |  | 0.058 | 0.058 | 0.058 | 0.058 | 0.058
 |  |  |  |  | 0.003828 | 0.003828 | 0.003828 | 0.003828 | 0.003828
 | Equity Return |  |  |  | 0.124 | 0.124 | 0.124 | 0.124 | 0.124
 | Equity Ratio |  |  |  | 0.48 | 0.48 | 0.48 | 0.48 | 0.48
 |  |  |  |  | 0.05952 | 0.05952 | 0.05952 | 0.05952 | 0.05952
 | Overall Return |  |  |  | 0.09688920000000001 | 0.09688920000000001 | 0.09688920000000001 | 0.09688920000000001 | 0.09688920000000001
 | Return on Debt |  |  |  | 1951.594722 | 2783.416482 | 5126.77242 | 6874.8391404 | 7458.6572676
 | Return on Equity and Preferred |  |  |  | 3685.90338 | 5256.93378 | 9682.7418 | 12984.249516 | 14086.884804
 | Total Return |  |  |  | 5637.498102 | 8040.350262 | 14809.51422 | 19859.0886564 | 21545.5420716
HIGH CASE - Option 2 - Other Backbone/Storage Reliability Investments
 |  |  |  |  | 2003 | 2004 | 2005 | 2006 | 2007
Depreciation
 | Gas Plant |  |  |  | 60000 | 120000 | 218000 | 248000 | 278000
 | Depreciation Expense |  |  |  | 2000 | 4000 | 7266.666666666667 | 8266.666666666666 | 9266.666666666666
 | Accumulated Depreciation |  |  |  | 2000 | 6000 | 13266.66666666667 | 21533.33333333334 | 30800
Deferred Taxes
 | Tax Depreciation |  |  |  | -6000 | -10800 | -17658 | -18079.2 | -18239.58
 | Book Depreciation & Amort |  |  |  | 2000 | 4000 | 7266.666666666667 | 8266.666666666666 | 9266.666666666666
 | Total Differences |  |  |  | -4000 | -6800 | -10391.33333333333 | -9812.533333333335 | -8972.913333333336
 | Income Tax Rate |  |  |  | 0.4074599999999999 | 0.4074599999999999 | 0.4074599999999999 | 0.4074599999999999 | 0.4074599999999999
 | Deferred Taxes |  |  |  | -1629.84 | -2770.728 | -4234.052679999999 | -3998.214832 | -3656.1032668
 | Accumulated Deferred Taxes |  |  |  | -1629.84 | -4400.567999999999 | -8634.620679999998 | -12632.835512 | -16288.9387788
Income Taxes
 | Return on rate base |  |  |  | 5637.498102 | 8040.350262 | 14809.51422 | 19859.0886564 | 21545.5420716
 | Less:   Debt return |  |  |  | -1951.594722 | -2783.416482 | -5126.77242 | -6874.8391404 | -7458.6572676
 | Adjusted Taxable Equity return |  |  |  | 3685.903380000001 | 5256.933779999999 | 9682.7418 | 12984.249516 | 14086.884804
 | Federal Tax Rate/(1-Fed. [NAME]) |  |  |  | 0.5384615384615384 | 0.5384615384615384 | 0.5384615384615384 | 0.5384615384615384 | 0.5384615384615384
 | Total Federal Income Tax |  |  |  | 1984.717204615385 | 2830.656650769231 | 5213.784046153845 | 6991.518970153846 | 7585.245663692308
 | State Tax. Inc.(Eq.Ret.+Fed. Inc.Tax) |  |  |  | 5670.620584615385 | 8087.59043076923 | 14896.52584615385 | 19975.76848615384 | 21672.13046769231
 | State Tax Rate/(1-State Tax Rate) |  |  |  | 0.09697235629662133 | 0.09697235629662133 | 0.09697235629662133 | 0.09697235629662133 | 0.09697235629662133
 | State Income Tax |  |  |  | 549.8934397542783 | 784.272700833699 | 1444.551211935059 | 1937.097338938131 | 2101.597557419921
 | Total Income Taxes |  |  |  | 2534.610644369663 | 3614.929351602929 | 6658.335258088904 | 8928.616309091976 | 9686.843221112229
Tax Depreciation
 | Tax Basis |  |  |  | 60000 | 120000 | 218000 | 248000 | 278000
 | [NAME]. Rate 15 yr 200% DDB |  |  |  | 0.1 | 0.09 | 0.081 | 0.0729 | 0.06561
 | Tax Depreciation |  |  |  | 6000 | 10800 | 17658 | 18079.2 | 18239.58