The URL can be used to link to this page

Home My WebLink AboutU-1034-99 Exhibit 2 Blickenstaff.pdfI Intermountain Gas Company I Case No. U-l034-99 Exhibit 2 Schedule 1 I Witness:Blickenstaff APPENDIX A I Financial & Common Stock Information Month Ended December 31,1981 Edward D. Jones & Company I LINE 12 MOS DIV PAY BOOK MKT TO NO.ENDED EPS RATE ROE OUT YLD BOOK I 1 SE MICHIGAN GAS *9/30/81 82 1.52 5.7 185 11.2 86 2 COLONIAL GAS COMPANY 9/30/81 1.00 1.40 8.3 140 II .8 80 3 SOUTHWEST GAS 9/30/81 .93 1.16 8.7 125 10.9 80 I 4 INTERMOUNTAIN GAS 9/30/81 1.15 1.40 6.5 122 7.9 53 5 ROCKY MOUNTAIN NATL 9/30/81 .40 .48 5.9 120 7.0 93 6 UNITED CITIES GAS 9/30/81 1.05 1.20 6.5 114 7.5 61 I 7 MICHIGAN ENERGY RES 9/30/81 1.36 1.30 10.2 96 11.1 96 8 BAY STATE GAS 9/30/81 2.48 2.32 8.8 94 8.3 68 9 CONNECTICUT ENERGY 9/30/81 2.77 2.60 9.9 94 9.3 70 I 10 NEW JERSEY NATURAL 9/30/81 2.01 1.68 10.3 84 10.5 86 II NORTHWEST NATURAL 9/30/81 1.52 1.28 11.3 84 9.6 86 12 CASCADE NATURAL GAS 9/30/81 1.28 1.04 10.3 81 9.1 78 I 13 GAS SERVICE 9/30/81 1.64 1.28 8.6 78 6.7 52 14 TENNESSEE NATURAL 9/30/81 1.28 1.00 8.6 78 6.8 59 15 WASHINGTON GAS LIGHT 9/30/81 3.38 2.64 9.4 78 8.5 103 I 16 LACLEDE GAS 9/30/81 3.15 2.40 10.7 76 8.1 68 17 WICOR 9/30/81 2.84 2.14 10.6 75 8.0 69 18 CONNECTICUT NATURAL 9/30/81 3.02 2.20 15.8 73 II .5 95 19 NATIONAL UTILS/INDS 9/30/81 2.57 1.80 10.8 70 7.7 94 I 20 PIEDMONT NATURAL 7/31/81 2.55 1. 76 11.3 69 7.7 76 21 INDIANA GAS 9/30/81 4.47 3.04 12.9 68 8.8 75 22 WASHINGTON ENERGY 9/30/81 2. II 1.44 II .8 68 8.1 68 I 23 SOUTH JERSEY INDS.9/30/81 2.97 2.00 12.9 67 8.7 73 24 ATLANTA GAS LIGHT 9/30/81 2.57 1.68 9.9 65 6.5 58 25 PUB SVC/N CAROLINA 9/30/81 2.32 1.48 15.6 64 11. 3 93 I 26 PEOPLES ENERGY 9/30/81 1.66 1.00 15.9 60 9.7 78 27 BROOKLYN UNION GAS 9/30/81 4.05 2.40 14.6 59 8.8 90 I 28 NICOR 9/30/81 4.88 2.84 13.9 58 7.9 92 29 PENNSYLVANIA ENT 9/30/81 2.82 1.60 9.3 57 5.3 41 30 MINNESOTA GAS 9/30/81 3.85 2.16 13.6 56 7.8 70 I 31 ALAGASCO 9/30/81 2.91 1.60 12.4 55 6.8 65 32 NORTH CAROLINA NATL 9/30/81 2.57 1.40 15.9 54 8.6 76 33 COLUMBIA GAS SYSTEM 9/30/81 5.12 2.70 13.7 53 7.0 83 I 34 PACIFIC LIGHTING 9/30/81 5.31 2.76 16.5 52 8.7 86 35 PROVIDENCE ENERGY 9/30/81 2.85 1.44 12.6 51 6.4 56 36 ONEOK 8/31/81 4.42 2.20 18.0 50 9.0 112 37 MOBILE GAS SERVICE 9/30/81 1. 71 .84 18.2 49 8.9 85 I 38 MISSISSIPPI VALLEY 9/30/81 3.63 1. 70 15.5 47 7.2 70 39 ENTEX 9/30/81 2.17 1.00 22.6 46 10.4 136 40 CITY GAS OF FLORIDA 6/30/81 2.23 1.00 10.3 45 4.6 72 I 41 VALLEY RESOURCES 8/31/81 3.20 1.44 14.5 45 6.5 74 42 SOUTHERN UNION 9/30/81 3.73 1.56 19.3 42 8.1 115 43 TENNESSEE/VIRGINIA 10/31/81 1. 37 .48 18.9 35 6.5 84 I 44 EQUITABLE GAS 9/30/81 4.63 1.32 20.5 29 5.4 145 45 LOUIS lANA GENERAL SVCS*9/30/81 2.63 .42 29.4 16 4.5 170 I NOTES: 46 * -STOCK DIVIDEND PAID MA 29.4 185 1l.8 170 47 DURING LAST 12 MOS.MIN 5.7 16 4.5 41 I 48 MEDIAN 1l.8 67 8.1 78 49 HEA 12.8 72 8.2 83 I I I I I I I I I I I I I I I I I I I I I I Intermountain Gas Company Case No. U-1034-99 Exhibit 2 Schedule 2 Witness: Blickenstaff Appendix B R.O.E. 1980 LineNo. Company 1 National Gas of Ohio Connecticut Natural 2 Gas Company Wisconsin Natural 3 Gas Company Southwest Gas 4 Corporation North Carolina 5 Gas Public Service Co. 6 of North Carolina Northwest Natural 7 Gas Company Washington Energy 8 Company Cascade Natural 9 Gas Company Intermountain Gas 10 Company I I I I I I Line No.Company I National Gas 1 of Ohio I Connecticut 2 Natural Gas Co. I Wisconsin Natural 3 Gas Company I Southwest Gas 4 Corporation I North Carolina 5 Natural Gas I Public Service Co. 6 of North Carolina I Northwest Natural 7 Gas Company I Washington Energy 8 Company I Cascade Natural 9 Gas Company I Intermountain 10 Gas Company I 11 I I I I I Intermountain Gas Company Case No. U-1034-99 Exhibit No. 2 Schedule No. 3Witness: Blickenstaff Appendix B Equity Multiplier 1980 Assets Equity Multiplier"t Equity 15,126,516 22,842,866 L.51X 30,558,500 147,700,000 4.83X 109,175,000 314,167,000 2.88X 81,162,269 301,773,598 3.72X 24,604,205 73,254,676 2.97X 32,070,589 139,970,000 4.36X 102,176,825 312,372,428 3.06X 90,482,500 319,258,500 3.52X 32,193,000 123,063,000 3.82X 26,201,500 93,281,500 3.56X Average (Excluding Intermountain Gas) = 3.41X I I I I I I Line No.Company I National Gas I 1 of Ohio Connecticut Natural I 2 Gas Company Wisconsin Natural I 3 Gas Company Southwest Gas I 4 Corporation North Carolina I 5 Natural Gas Public Service Co. I 6 of North Carolina Northwest Natural I 7 Gas Company Washington Energy I 8 Company Cascade Natural I 9 Gas Company Intermountain I 10 Gas Company I 11 I I I I Intermountain Gas Company Case No. U-1034-99 Exhibit No. 2 Schedule No. 4 Witness: Blickenstaff Appendix B Asset Turnover 1980 Gross Income "t Average Assets = Asset Turnover 40,627,808 22,842,866 1. 7786X 123 ,472 ,000 147,700,000 .8360X 450,284 ,000 314,167,000 1.4333X 317,548,590 301,773,598 1.0531X 123,238,038 73,254,676 1. 6823X 159,226,189 139,970,000 1. 1376X 335,610,182 312,372,428 1.0744X 307,939,000 319,258,500 . 9645X 176,170,000 123,063,000 1.4315X 138,833,000 93,281,500 1.4883X Average (Excluding Intermountain Gas) = 1.2657X Company National Gas of Ohio Connecticut Natural Gas Company Wisconsin Natural Gas Company Southwest Gas Corporation North Carolina Natural Gas Public Service Co. of North Carolina Northwest Natural Gas Company Washington Energy Company Cascade Natural Gas Company Intermountain Gas Company Appendix B Profit Margin 1980 (Net Income/Gross Income) Intermountain Gas Company Case No. U-1034-99 Exhibit No. 2 Schedule No. 5 Witness: Blickenstaff Net Income -: Gross Income = Profit Margin $ 3,178,871 $ 40,627,808 7.82% 3,974,000 123,472,000 3.22% 11,455,000 450,284,000 2.54% 6,634,655 317,548,590 2.09% 4,017,742 123,238,038 3.26% 3,984,834 159,226,189 2.50% 13,714,209 335,610,182 4.09% 9,603,000 307,939,000 3.12% 4,539,000 176,170,000 2.58% 1,785,000 138,833,000 1.29% Average (Excluding Intermountain Gas) = 3.47% Intermountain Gas Company Case No. U-1034-99 Exhibit No. 2 Schedule No. 6 Witness: Blickenstaff Appendix B Cost of Gas Purchased as a Percentage of Operating Revenues Company 1978 1979 1980 Southwest Gas Corporation 79.90%79.33%82.41% North Carolina Natural Gas 64.34%73.14%78.30% Wisconsin Gas Company 70.42%73.49%77 .89% Natural Gas Company of Ohio 69.21%71.89%75.20% Public Service Co. of North Carolina 56.79%64.98%73.93% Connecticut Natural Gas Corporation 54.31%55.20%58.07% Northwest Natural Gas Company 71.00%72.79%75.65% Washington Energy Company 66.10%68.13% Cascade Natural Gas Company 75.07%75.65%77 .94% Intermountain Gas Company 75.85%74.33%81.04% Average (Excluding Intermountain Gas)67.63%70.29%74.17% I I I I I I I I I I I I I I I I I I I I I I Line No. 1 2 3 4 5 6 7 8 9 10 11 Intermountain Gas Company Case No. U-I034-99 Exhibit No. 2 Schedule No. 7 Witness: Blickenstaff Appendix B Operations & Maintenance as a Percentage of Operating Revenues Company 1978 1979 1980 Connecticut Natural Gas Company 21.40%21.93%19.79% Wisconsin Gas Company 12.19%11.32%10.24% Na t ional Gas of Ohio 7.52%6.62%6.39% Southwest Gas Corpora t ion 11.00%8.57%9.82% Public Service Company of North Carolina 14.56%10.60%9.00% North Carolina Natural Gas 7.34%5.47% Northwest Natural Gas Company 8.34%8.42%8.82% Washington Energy Company 12.52%12.80%13 .04% Cascade Natural Gas Company 11.23%9.47%9.07% Intermountain Gas Company 10.34%9.87%8.11% Average (Excluding Intermountain Gas)10.18% I I I I I I Line I No. I 1 2 I 3 I 4 I 5 6 I 7 I 8 I 9 10 I I I I I I I I Appendix B Earnings Per Share Company 1978 Wisconsin Natural Gas $3.19 North Carolina Natural Gas 1.50 Connecticut Natural Gas 1.85 Natural Gas of Ohio 1.36 Public Service Company of North Carolina 1.44 Southwest Gas Corporation 1. 10 Northwest Natural Gas 1.50 Washington Energy Company 1.52 Cascade Natural Gas Corporation Intermountain Gas Intermountain Gas Company Case No. U-I034-99 Exhibit No. 2 Schedule No. 8 Witness: Blickenstaff 1979 1980 $3.31 $2.80 1.93 2.34 1.95 2.29 1.45 1.63 1.97 1.51 1.57 .91 1.88 1.40 2.19 1.68 .68 1.54 1.40 .05 2.13 1.23