Spreadsheet: jeff_dasovich__14043__COS & Rates Workpapers for GA II 12-20-2000 Proposal
Sheet: COS Totals

2000-12-20 00:00:00
Confidential: CPUC Rule 51
Calculation of Annual COS By Path
Important Notes: (Includes Looping on Line 401 in 2003)
(1) Depreciation info derived from the CPUC Approved May 1, 2000 Depreciation Accrural Report.
(2) All incremental CAPEX is Fully Normalized for federal income tax purposes (post-1981 Additions).
 |  |  |  | Proof: | 0 | 0 | 0 | 0 | 0 | 0 | 0
Line No. | Years | COS Components |  | Total | [NAME] | Line 401 | Ln 300 | Other Backbone | Gas Gathering | Local Trans | Storage
1 | 2003 | O&M |  | 99534.36137129396 | 10403.54980652275 | 5748.385823262774 | 24582.26184302166 | 6832.49895986758 | 6739.396368591205 | 32010.23234032392 | 13218.03622970408
2 | 2003 | A&G |  | 52392.31448346644 | 6166.624196993705 | 595.6749063918234 | 13340.06561210485 | 3931.189796117217 | 4190.637180773186 | 17321.09674470088 | 6847.026046384777
3 | 2003 | Original Capital COS |  | 272804.5068606859 | 14172.12640273517 | 83209.2963551805 | 30521.40285632051 | 12272.21236248872 | -212.5006924546269 | 95798.35545207755 | 37043.61412433807
4 | 2003 | Total COS | 424731.1827154463 | 424731.1827154463 | 30742.30040625162 | 89553.3570848351 | 68443.73031144703 | 23035.90111847352 | 10717.53285690976 | 145129.6845371024 | 57108.67640042692
5 | 2004 | O&M |  | 102388.0737120496 | 10663.00329135945 | 5891.74446158989 | 25195.31734993542 | 7317.694228621845 | 6907.469757582963 | 32865.1646056764 | 13547.68001728362
6 | 2004 | A&G |  | 54032.45293907376 | 6359.670020345518 | 614.3224758043527 | 13757.67561514532 | 4054.255471387921 | 4321.824841815587 | 17863.33270324483 | 7061.371811330214
7 | 2004 | Original Capital COS | 0.9459476397400489 | 258058.7793753138 | 13406.08952076496 | 78711.63749161325 | 28871.64899349157 | 11608.87031868486 | -201.0145284705804 | 90620.22823087101 | 35041.31934835874
8 | 2004 | COS on New Capital |  | 34234.98246414647 | 5804.988254809735 | 9218.493730158241 | 792.1891484801719 | 5977.427211259479 | 216.0515859491378 | 6485.670332254172 | 5740.162201235528
9 | 2004 | Total COS | 448714.2884905837 | 448714.2884905836 | 36233.75108727967 | 94436.19815916572 | 68616.8311070525 | 28958.2472299541 | 11244.33165687711 | 147834.3958720464 | 61390.5333782081
10 | 2005 | O&M |  | 105564.3672825244 | 10935.2701327519 | 6042.183002310251 | 25838.64918481406 | 7835.942665170399 | 7083.843610382477 | 33934.8751109687 | 13893.60357612659
11 | 2005 | A&G |  | 55761.03133526504 | 6563.125307050167 | 633.9755639432077 | 14197.80408528832 | 4183.957123622436 | 4460.086435493539 | 18434.80723966139 | 7287.275580205986
12 | 2005 | Original Capital COS | 0.9428590357550816 | 243313.0518899417 | 12640.05263879475 | 74213.978628046 | 27221.89513066263 | 10945.52827488099 | -189.5283644865338 | 85442.10100966446 | 33039.0245723794
13 | 2005 | COS on New Capital |  | 51391.26839566047 | 5684.206539491082 | 9074.92765577431 | 1561.329960481032 | 12005.17960541015 | 420.9069986323464 | 15397.93564921255 | 7246.78198665901
14 | 2005 | Total COS | 456029.7189033916 | 456029.7189033916 | 35822.6546180879 | 89965.06485007377 | 68819.67836124604 | 34970.60766908397 | 11775.30868002183 | 153209.7190095071 | 61466.68571537098
15 | 2006 | O&M |  | 108570.3450030232 | 11221.64442281717 | 6200.416484128739 | 26515.31512234629 | 8041.151360565073 | 7269.356236977846 | 35065.01028534438 | 14257.45109084366
16 | 2006 | A&G |  | 57586.94676990412 | 6778.037253810277 | 654.7353264452298 | 14662.71639046863 | 4320.962335092741 | 4606.133602616894 | 19038.46176805613 | 7525.900093414218
17 | 2006 | Original Capital COS | 0.9556830030627834 | 232530.1481145504 | 12079.88346471503 | 70925.03796448822 | 26015.50248753183 | 10460.45533184687 | -181.1290365380684 | 81655.5636809098 | 31574.83422159664
18 | 2006 | COS on New Capital |  | 70303.34591151052 | 5658.042007035127 | 8954.717288023772 | 9357.898648279952 | 11941.60979007689 | 635.7691872078465 | 25286.57858399874 | 8468.730406888184
19 | 2006 | Total COS | 468990.7857989882 | 468990.7857989881 | 35737.6071483776 | 86734.90706308596 | 76551.43264862671 | 34764.17881758157 | 12330.12999026452 | 161045.6143183091 | 61826.9158127427
20 | 2007 | O&M |  | 111728.6766644848 | 11521.93084035277 | 6366.336984110173 | 27224.85364343213 | 8256.329140571703 | 7463.881108729586 | 36256.37054756565 | 14638.97439972281
21 | 2007 | A&G |  | 59506.63829632753 | 7003.986733887972 | 676.5612770942378 | 15151.50584689876 | 4465.003914755153 | 4759.681518290363 | 19673.11902603346 | 7776.779979367589
22 | 2007 | Original Capital COS | 0.9706701254838972 | 225710.0680491398 | 11725.58199852579 | 68844.81550093995 | 25252.47106409916 | 10153.65148958251 | -175.8165446251842 | 79260.61624460708 | 30648.74829601046
23 | 2007 | COS on New Capital |  | 79751.77099030295 | 5637.618510902981 | 8756.698914331722 | 9648.857213118581 | 11726.35465843251 | 860.2015787546813 | 33472.27988426828 | 9649.760230494196
24 | 2007 | Total COS | 476697.1540002551 | 476697.154000255 | 35889.11808366952 | 84644.41267647607 | 77277.68776754863 | 34601.33920334187 | 12907.94766114945 | 168662.3857024745 | 62714.26290559505
 | Total COS
 | Annual Growth | Period | Year | Total | [NAME] | Line 401 | Ln 300 | Other Backbone | Gas Gathering | Local Trans | Storage
25 | 0 | 1 | 2003 | 424731.1827154463 | 30742.30040625162 | 89553.3570848351 | 68443.73031144703 | 23035.90111847352 | 10717.53285690976 | 145129.6845371024 | 57108.67640042692
26 |  | 2 | 2004 | 448714.2884905836 | 36233.75108727967 | 94436.19815916572 | 68616.8311070525 | 28958.2472299541 | 11244.33165687711 | 147834.3958720464 | 61390.5333782081
27 |  | 3 | 2005 | 456029.7189033916 | 35822.6546180879 | 89965.06485007377 | 68819.67836124604 | 34970.60766908397 | 11775.30868002183 | 153209.7190095071 | 61466.68571537098
28 |  | 4 | 2006 | 468990.7857989881 | 35737.6071483776 | 86734.90706308596 | 76551.43264862671 | 34764.17881758157 | 12330.12999026452 | 161045.6143183091 | 61826.9158127427
29 |  | 5 | 2007 | 476697.154000255 | 35889.11808366952 | 84644.41267647607 | 77277.68776754863 | 34601.33920334187 | 12907.94766114945 | 168662.3857024745 | 62714.26290559505
30 | Levelized 5 Yr Growth Total |  |  | 0.03502100100000005
31 | The 3.5% represents the equivalent growth rate of the change in annual COS from 2003-2007 when discounted at 8.43%.
 |  | Period | Year | UGS Total COS | Storage Exp COS | COS WITH Expansion | COS with Fixed Escalator |  | COS at Required Rate Escalator | COS (Excluding UGS Expansion in 2005) | Delta
 |  |  |  |  |  | (a)+(b) | PROOF | Required Rate Escalator | 1.035021001
 |  |  |  | (a) | (b) | (c) | (d) | NPV | 1788384.74474835 | 1788372.317114677 | 12.4276336729982
32 |  | 1 | 2003 | 57108.67640042692 | 0 | 57108.67640042692 | 57108.67640042692 | Yr 1 COS | 424731.1827154463 | 424731.1827154463 | 0
33 |  | 2 | 2004 | 61390.5333782081 | 0 | 61390.5333782081 | 61353.70549332731 | Yr 2 COS | 439605.6938900552 | 448714.2884905836 | -9108.59460052842
34 |  | 3 | 2005 | 61466.68571537098 | 14519.98892820423 | 75986.67464357521 | 65914.27809266828 | Yr 3 COS | 455001.1253353845 | 456029.7189033916 | -1028.593568007054
35 |  | 4 | 2006 | 61826.9158127427 | 13861.87112967654 | 75688.78694241925 | 70813.84932732592 | Yr 4 COS | 470935.7202007562 | 468990.7857989881 | 1944.934401768027
36 |  | 5 | 2007 | 62714.26290559505 | 13363.35489829311 | 76077.61780388816 | 76077.61780388819 | Yr 5 COS | 487428.3605288426 | 476697.154000255 | 10731.20652858756