{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["TJN-2 p 1 Summary","TJN-2 p 2 Avg and Proj","TJN-2 p 3 LTD 23","TJN-2 p 4 LTD 24","TJN-2 p 5 LTD 25","TJN-2 p 6 STD","TJN-2 p 7 Common Equity"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":5,"defined_names":43,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TJN-2 p 1 Summary","index":0,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["CASCADE NATURAL GAS CORPORATION"]
["PROPOSED UTILITY CAPITAL STRUCTURE"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Required"]
[null,null,"Balance",null,"Ratio",null,"Cost",null,"Return"]
[]
["Based on Normalized 2024"]
["Long-Term Debt 4/",null,{"$f":"'TJN-2 p 2 Avg and Proj'!C31","v":475000000},null,{"$f":"'TJN-2 p 2 Avg and Proj'!E31","v":0.44213999999999998},null,{"$f":"'TJN-2 p 2 Avg and Proj'!G31","v":4.915579738947369E-2},null,{"$f":"ROUND(+G10*E10,5)","v":2.1729999999999999E-2}]
["Short-Term Debt  2/",null,{"$f":"'TJN-2 p 2 Avg and Proj'!C32","v":59102250},null,{"$f":"'TJN-2 p 2 Avg and Proj'!E32","v":5.5010000000000003E-2},null,{"$f":"'TJN-2 p 2 Avg and Proj'!G32","v":8.0140000000000003E-2},null,{"$f":"ROUND(+G11*E11,5)","v":4.4099999999999999E-3}]
["Common Equity  3/",null,{"$f":"'TJN-2 p 2 Avg and Proj'!C33","v":540218000},null,{"$f":"'TJN-2 p 2 Avg and Proj'!E33","v":0.50285000000000002},null,{"$f":"'TJN-2 p 2 Avg and Proj'!G33","v":0.105},null,{"$f":"ROUND(+G12*E12,5)","v":5.28E-2}]
["    Total",null,{"$f":"SUM(C10:C12)","v":1074320250},null,{"$f":"SUM(E10:E12)","v":1},null,null,null,{"$f":"SUM(I10:I12)","v":7.8939999999999996E-2}]
[]
[]
[]
[]
[]
[]
[" "]
["2/  Exhibit TJN-2, page 6."]
["3/  Exhibit TJN-2, page 7."]
["4/  Exhibit TJN-2, page 4."]

{"sheet":"TJN-2 p 2 Avg and Proj","index":1,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["CASCADE NATURAL GAS CORPORATION"]
["AVERAGE AND PROJECTED UTILITY CAPITAL STRUCTURE"]
["TWELVE MONTHS ENDING DECEMBER 31, 2023"]
["PROJECTED 2024 - 2025"]
[]
[]
[null,null,null,null,null,null,null,null,"Required"]
[null,null,"Balance",null,"Ratio",null,"Cost",null,"Return"]
["Per Books 2023"]
["Long-Term Debt 1/",null,{"$f":"'TJN-2 p 3 LTD 23'!G30","v":475000000},null,{"$f":"ROUND(+C10/$C$13,5)","v":0.43264000000000002},null,{"$f":"'TJN-2 p 3 LTD 23'!K30","v":4.9065181010526315E-2},null,{"$f":"ROUND(+G10*E10,5)","v":2.1229999999999999E-2}]
["Short-Term Debt  2/",null,{"$f":"'TJN-2 p 6 STD'!C12","v":145875000},null,{"$f":"ROUND(+C11/$C$13,5)","v":0.13286999999999999},null,{"$f":"'TJN-2 p 6 STD'!G12","v":7.1690000000000004E-2},null,{"$f":"ROUND(+G11*E11,5)","v":9.5300000000000003E-3}]
["Common Equity  3/",null,{"$f":"'TJN-2 p 7 Common Equity'!C8","v":477031415.50999999},null,{"$f":"ROUND(+C12/$C$13,5)","v":0.43448999999999999},null,0.105,null,{"$f":"ROUND(+G12*E12,5)","v":4.5620000000000001E-2}]
["    Total",null,{"$f":"SUM(C10:C12)","v":1097906415.51},null,{"$f":"SUM(E10:E12)","v":1},null,null,null,{"$f":"SUM(I10:I12)","v":7.6380000000000003E-2}]
[]
[]
["Normalized 2023"]
["Long-Term Debt 1/",null,{"$f":"C10","v":475000000},null,{"$f":"ROUND(+C17/$C$13,5)","v":0.43264000000000002},null,{"$f":"G10","v":4.9065181010526315E-2},null,{"$f":"ROUND(+G17*E17,5)","v":2.1229999999999999E-2}]
["Short-Term Debt  2/",null,{"$f":"C11-(153113241.28*0.5)","v":69318379.359999999},null,{"$f":"ROUND(+C18/$C$13,5)","v":6.3140000000000002E-2},null,{"$f":"G11","v":7.1690000000000004E-2},null,{"$f":"ROUND(+G18*E18,5)","v":4.5300000000000002E-3}]
["Common Equity  3/",null,{"$f":"C12+(153113241.28*0.5)","v":553588036.14999998},null,{"$f":"ROUND(+C19/$C$13,5)","v":0.50422},null,0.105,null,{"$f":"ROUND(+G19*E19,5)","v":5.2940000000000001E-2}]
["    Total",null,{"$f":"SUM(C17:C19)","v":1097906415.51},null,{"$f":"SUM(E17:E19)","v":1},null,null,null,{"$f":"SUM(I17:I19)","v":7.8699999999999992E-2}]
[]
[]
["Projected 2024"]
["Long-Term Debt 4/",null,{"$f":"'TJN-2 p 4 LTD 24'!G30","v":475000000},null,{"$f":"ROUND(+C24/$C$27,5)","v":0.44213999999999998},null,{"$f":"'TJN-2 p 4 LTD 24'!K30","v":4.915579738947369E-2},null,{"$f":"ROUND(+G24*E24,5)","v":2.1729999999999999E-2}]
["Short-Term Debt  2/",null,{"$f":"'TJN-2 p 6 STD'!C17","v":96332250},null,{"$f":"ROUND(+C25/$C$27,5)","v":8.967E-2},null,{"$f":"'TJN-2 p 6 STD'!G17","v":8.0140000000000003E-2},null,{"$f":"ROUND(+G25*E25,5)","v":7.1900000000000002E-3}]
["Common Equity  3/",null,{"$f":"'TJN-2 p 7 Common Equity'!C14","v":502988000},null,{"$f":"ROUND(+C26/$C$27,5)","v":0.46819},null,{"$f":"G12","v":0.105},null,{"$f":"ROUND(+G26*E26,5)","v":4.9160000000000002E-2}]
["    Total",null,{"$f":"SUM(C24:C26)","v":1074320250},null,{"$f":"SUM(E24:E26)","v":1},null,null,null,{"$f":"SUM(I24:I26)","v":7.8080000000000011E-2}]
[]
[]
["Normalized 2024"]
["Long-Term Debt 4/",null,{"$f":"C24","v":475000000},null,{"$f":"ROUND(+C31/$C$27,5)","v":0.44213999999999998},null,{"$f":"G24","v":4.915579738947369E-2},null,{"$f":"ROUND(+G31*E31,5)","v":2.1729999999999999E-2}]
["Short-Term Debt  2/",null,{"$f":"C25-(74460000*0.5)","v":59102250},null,{"$f":"ROUND(+C32/$C$27,5)","v":5.5010000000000003E-2},null,{"$f":"G25","v":8.0140000000000003E-2},null,{"$f":"ROUND(+G32*E32,5)","v":4.4099999999999999E-3}]
["Common Equity  3/",null,{"$f":"C26+(74460000*0.5)","v":540218000},null,{"$f":"ROUND(+C33/$C$27,5)","v":0.50285000000000002},null,{"$f":"G26","v":0.105},null,{"$f":"ROUND(+G33*E33,5)","v":5.28E-2}]
["    Total",null,{"$f":"SUM(C31:C33)","v":1074320250},null,{"$f":"SUM(E31:E33)","v":1},null,null,null,{"$f":"SUM(I31:I33)","v":7.8939999999999996E-2}]
[]
[]
["Projected 2025"]
["Long-Term Debt 5/",null,{"$f":"'TJN-2 p 5 LTD 25'!G29","v":450000000},null,{"$f":"ROUND(+C38/$C$41,5)","v":0.45530999999999999},null,{"$f":"'TJN-2 p 5 LTD 25'!K29","v":4.9603341688888893E-2},null,{"$f":"ROUND(+G38*E38,5)","v":2.2579999999999999E-2}]
["Short-Term Debt  2/",null,{"$f":"'TJN-2 p 6 STD'!C22","v":17268916.666666668},null,{"$f":"ROUND(+C39/$C$41,5)","v":1.7469999999999999E-2},null,{"$f":"'TJN-2 p 6 STD'!G22","v":7.46E-2},null,{"$f":"ROUND(+G39*E39,5)","v":1.2999999999999999E-3}]
["Common Equity  3/",null,{"$f":"'TJN-2 p 7 Common Equity'!C16","v":521065000},null,{"$f":"ROUND(+C40/$C$41,5)","v":0.52722000000000002},null,{"$f":"G12","v":0.105},null,{"$f":"ROUND(+G40*E40,5)","v":5.5359999999999999E-2}]
["    Total",null,{"$f":"SUM(C38:C40)","v":988333916.66666675},null,{"$f":"SUM(E38:E40)","v":1},null,null,null,{"$f":"SUM(I38:I40)","v":7.9240000000000005E-2}]
[]
[]
[]
[]
["1/  Exhibit TJN-2, page 3."]
["2/  Exhibit TJN-2, page 6."]
["3/  Exhibit TJN-2, page 7."]
["4/  Exhibit TJN-2, page 4."]
["5/  Exhibit TJN-2, page 5."]

{"sheet":"TJN-2 p 3 LTD 23","index":2,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["CASCADE NATURAL GAS CORPORATION"]
["LONG-TERM DEBT CAPITAL"]
["DECEMBER 31, 2023"]
[]
[]
[]
[null,null,null,null,null,null,"Principal"]
[null,null,"Date of",null,"Interest",null,"Amount",null,"Annual Interest"]
["Description",null,"Maturity",null,"Rate",null,"of Issue",null,"Expense"]
["Unsecured Long-Term Debt"]
["    7.48%  -  Medium-Term Note",null,"2027-09-15",null,7.4800000000000005E-2,null,20000000,null,{"$f":"E11*G11","v":1496000}]
["    7.10%  -  Medium-Term Note",null,"2029-03-16",null,7.0999999999999994E-2,null,15000000,null,{"$f":"E12*G12","v":1065000}]
["    5.79%  -  Medium-Term Note",null,"1937-03-08",null,5.79E-2,null,40000000,null,{"$f":"E13*G13","v":2316000}]
["    4.11%  -  Senior Note",null,"2025-08-23",null,4.1099999999999998E-2,null,25000000,null,1027499.9999999999]
["    4.36%  -  Senior Note",null,"2028-08-23",null,4.36E-2,null,25000000,null,1090000]
["    4.09%  -  Senior Note",null,"1944-11-24",null,4.0899999999999999E-2,null,12500000,null,511250]
["    4.24%  -  Senior Note",null,"1954-11-24",null,4.24E-2,null,12500000,null,{"$f":"E17*G17","v":530000}]
["    4.09%  -  Senior Note",null,"1945-01-15",null,4.0899999999999999E-2,null,12500000,null,511250]
["    4.24%  -  Senior Note",null,"1955-01-15",null,4.24E-2,null,12500000,null,{"$f":"E19*G19","v":530000}]
["    3.62%  -  Senior Note",null,"2029-06-13",null,3.6200000000000003E-2,null,25000000,null,905000.00000000012]
["    3.82%  -  Senior Note",null,"1934-06-13",null,3.8199999999999998E-2,null,20000000,null,764000]
["    4.26%  -  Senior Note",null,"1949-06-13",null,4.2599999999999999E-2,null,30000000,null,{"$f":"E22*G22","v":1278000}]
["    3.58%  -  Senior Note",null,"1950-06-15",null,3.5799999999999998E-2,null,30000000,null,1074000]
["    3.78%  -  Senior Note",null,"1960-06-15",null,3.78E-2,null,20000000,null,756000]
["    3.34%  -  Senior Note",null,"1960-10-30",null,3.3399999999999999E-2,null,25000000,null,835000]
["    4.26%  -  Senior Note",null,"1932-06-15",null,4.2599999999999999E-2,null,15000000,null,639000]
["    4.60%  -  Senior Note",null,"1952-06-15",null,3.8199999999999998E-2,null,35000000,null,1337000]
["    6.39%  -  Senior Note",null,"2033-11-30",null,6.3899999999999998E-2,null,100000000,null,6390000]
["Debt Amortization",null,null,null,null,null,null,null,{"$f":"191101.62+59859.36","v":250960.97999999998}]
["Total Long-Term Debt Capital",null,null,null,null,null,{"$f":"SUM(G11:G28)","v":475000000},null,{"$f":"SUM(I11:I29)","v":23305960.98},null,{"$f":"I30/G30","v":4.9065181010526315E-2}]

{"sheet":"TJN-2 p 4 LTD 24","index":3,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["CASCADE NATURAL GAS CORPORATION"]
["LONG-TERM DEBT CAPITAL"]
["PROJECTED DECEMBER 31, 2024"]
[]
[]
[]
[null,null,null,null,null,null,"Principal"]
[null,null,"Date of",null,"Interest",null,"Amount",null,"Annual Interest"]
["Description",null,"Maturity",null,"Rate",null,"of Issue",null,"Expense"]
["Unsecured Long-Term Debt"]
["    7.48%  -  Medium-Term Note",null,"2027-09-15",null,7.4800000000000005E-2,null,20000000,null,{"$f":"E11*G11","v":1496000}]
["    7.10%  -  Medium-Term Note",null,"2029-03-16",null,7.0999999999999994E-2,null,15000000,null,{"$f":"E12*G12","v":1065000}]
["    5.79%  -  Medium-Term Note",null,"1937-03-08",null,5.79E-2,null,40000000,null,{"$f":"E13*G13","v":2316000}]
["    4.11%  -  Senior Note",null,"2025-08-23",null,4.1099999999999998E-2,null,25000000,null,1027499.9999999999]
["    4.36%  -  Senior Note",null,"2028-08-23",null,4.36E-2,null,25000000,null,1090000]
["    4.09%  -  Senior Note",null,"1944-11-24",null,4.0899999999999999E-2,null,12500000,null,511250]
["    4.24%  -  Senior Note",null,"1954-11-24",null,4.24E-2,null,12500000,null,530000]
["    4.09%  -  Senior Note",null,"1945-01-15",null,4.0899999999999999E-2,null,12500000,null,511250]
["    4.24%  -  Senior Note",null,"1955-01-15",null,4.24E-2,null,12500000,null,530000]
["    3.62%  -  Senior Note",null,"2029-06-13",null,3.6200000000000003E-2,null,25000000,null,905000.00000000012]
["    3.82%  -  Senior Note",null,"1934-06-13",null,3.8199999999999998E-2,null,20000000,null,764000]
["    4.26%  -  Senior Note",null,"1949-06-13",null,4.2599999999999999E-2,null,30000000,null,1278000]
["    3.58%  -  Senior Note",null,"1950-06-15",null,3.5799999999999998E-2,null,30000000,null,1074000]
["    3.78%  -  Senior Note",null,"1960-06-15",null,3.78E-2,null,20000000,null,756000]
["    3.34%  -  Senior Note",null,"1960-10-30",null,3.3399999999999999E-2,null,25000000,null,835000]
["    4.26%  -  Senior Note",null,"1932-06-15",null,4.2599999999999999E-2,null,15000000,null,639000]
["    4.60%  -  Senior Note",null,"1952-06-15",null,3.8199999999999998E-2,null,35000000,null,1337000]
["    6.39%  -  Senior Note",null,"2033-11-30",null,6.3899999999999998E-2,null,100000000,null,6390000]
["Debt Amortization",null,null,null,null,null,null,null,{"$f":"'TJN-2 p 3 LTD 23'!I29+(3912.98*11)","v":294003.76}]
["Total Long-Term Debt Capital",null,null,null,null,null,{"$f":"SUM(G11:G28)","v":475000000},null,{"$f":"SUM(I11:I29)","v":23349003.760000002},null,{"$f":"I30/G30","v":4.915579738947369E-2}]

{"sheet":"TJN-2 p 5 LTD 25","index":4,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["CASCADE NATURAL GAS CORPORATION"]
["LONG-TERM DEBT CAPITAL"]
["PROJECTED DECEMBER 31, 2025"]
[]
[]
[]
[null,null,null,null,null,null,"Principal"]
[null,null,"Date of",null,"Interest",null,"Amount",null,"Annual Interest"]
["Description",null,"Maturity",null,"Rate",null,"of Issue",null,"Expense"]
["Unsecured Long-Term Debt"]
["    7.48%  -  Medium-Term Note",null,"2027-09-15",null,7.4800000000000005E-2,null,20000000,null,{"$f":"E11*G11","v":1496000}]
["    7.10%  -  Medium-Term Note",null,"2029-03-16",null,7.0999999999999994E-2,null,15000000,null,{"$f":"E12*G12","v":1065000}]
["    5.79%  -  Medium-Term Note",null,"1937-03-08",null,5.79E-2,null,40000000,null,{"$f":"E13*G13","v":2316000}]
["    4.36%  -  Senior Note",null,"2028-08-23",null,4.36E-2,null,25000000,null,1090000]
["    4.09%  -  Senior Note",null,"1944-11-24",null,4.0899999999999999E-2,null,12500000,null,511250]
["    4.24%  -  Senior Note",null,"1954-11-24",null,4.24E-2,null,12500000,null,530000]
["    4.09%  -  Senior Note",null,"1945-01-15",null,4.0899999999999999E-2,null,12500000,null,511250]
["    4.24%  -  Senior Note",null,"1955-01-15",null,4.24E-2,null,12500000,null,530000]
["    3.62%  -  Senior Note",null,"2029-06-13",null,3.6200000000000003E-2,null,25000000,null,905000.00000000012]
["    3.82%  -  Senior Note",null,"1934-06-13",null,3.8199999999999998E-2,null,20000000,null,764000]
["    4.26%  -  Senior Note",null,"1949-06-13",null,4.2599999999999999E-2,null,30000000,null,1278000]
["    3.58%  -  Senior Note",null,"1950-06-15",null,3.5799999999999998E-2,null,30000000,null,1074000]
["    3.78%  -  Senior Note",null,"1960-06-15",null,3.78E-2,null,20000000,null,756000]
["    3.34%  -  Senior Note",null,"1960-10-30",null,3.3399999999999999E-2,null,25000000,null,835000]
["    4.26%  -  Senior Note",null,"1932-06-15",null,4.2599999999999999E-2,null,15000000,null,639000]
["    4.60%  -  Senior Note",null,"1952-06-15",null,3.8199999999999998E-2,null,35000000,null,1337000]
["    6.39%  -  Senior Note",null,"2033-11-30",null,6.3899999999999998E-2,null,100000000,null,6390000]
["Debt Amortization",null,null,null,null,null,null,null,{"$f":"'TJN-2 p 4 LTD 24'!I29","v":294003.76}]
["Total Long-Term Debt Capital",null,null,null,null,null,{"$f":"SUM(G11:G27)","v":450000000},null,{"$f":"SUM(I11:I28)","v":22321503.760000002},null,{"$f":"I29/G29","v":4.9603341688888893E-2}]

{"sheet":"TJN-2 p 6 STD","index":5,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["CASCADE NATURAL GAS CORPORATION"]
[" AVERAGE SHORT-TERM DEBT"]
["TWELVE MONTHS ENDING DECEMBER 31, 2023"]
["PROJECTED 2024 - 2025"]
[]
[]
[null,null,"Balance",null,"Annual",null,"Average"]
[null,null,"Outstanding",null,"Cost",null,"Cost"]
[2023]
["Average Balance  1/",null,{"$f":"(150000000/12*11)+(50000000/12)+(50500000/12)","v":145875000},null,{"$f":"649787.57+9674009.21","v":10323796.780000001},null,{"$f":"ROUND(E10/C10,5)","v":7.077E-2}]
["Amortization of Fees  2/",null,null,null,133472.22]
["    Total",null,{"$f":"SUM(C10:C11)","v":145875000},null,{"$f":"SUM(E10:E11)","v":10457269.000000002},null,{"$f":"ROUND(E12/C12,5)","v":7.1690000000000004E-2}]
[]
["Projected 2024"]
["Average Balance  1/",null,{"$f":"(50000000/12)+(1105987000/12)","v":96332250},null,{"$f":"C15*G15","v":7586164.6875},null,{"$f":"(0.0825+0.08+0.0775+0.075)/4","v":7.8750000000000001E-2}]
["Amortization of Fees  2/",null,null,null,{"$f":"E11","v":133472.22}]
["    Total",null,{"$f":"SUM(C15:C16)","v":96332250},null,{"$f":"SUM(E15:E16)","v":7719636.9074999997},null,{"$f":"ROUND(E17/C17,5)","v":8.0140000000000003E-2}]
[]
["Projected 2025"]
["Average Balance  1/",null,{"$f":"207227000/12","v":17268916.666666668},null,{"$f":"C20*G20","v":1154858.8020833335},null,{"$f":"(0.07+0.0675+0.065+0.065)/4","v":6.6875000000000004E-2}]
["Amortization of Fees  2/",null,null,null,{"$f":"E11","v":133472.22}]
["    Total",null,{"$f":"SUM(C20:C21)","v":17268916.666666668},null,{"$f":"SUM(E20:E21)","v":1288331.0220833335},null,{"$f":"ROUND(E22/C22,5)","v":7.46E-2}]
[]
[]
[]
["1/  Twelve month average balance."]
["2/  Negotiation and commitment fees."]

{"sheet":"TJN-2 p 7 Common Equity","index":6,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["CASCADE NATURAL GAS CORPORATION"]
["AVERAGE UTILITY COMMON EQUITY"]
["TWELVE MONTHS ENDING DECEMBER 31, 2023"]
["PROJECTED 2024 - 2025"]
[]
[]
["Description",null,"Amount"]
["Common Equity - 12/31/2023",null,477031415.50999999]
[]
["  Investment in Subsidiaries",null,0]
[]
["Utility Common Equity - 12/31/2019",null,{"$f":"C8-C10","v":477031415.50999999}]
[]
["Common Equity - 12/31/2024",null,502988000]
[]
["Common Equity - 12/31/2025",null,521065000]