20191018IRP Exhibit 5.pdf

INTERMOUNTAI N'
GAs COMPANY
lntermountain Gas Company
Avoided Cost Model
lntegrated Resource Plan 20 I I - 2023
A Subsidiary of MDU Resources Group, lnc.
ln the Community to Serve@
Exhibit No. 5
Fall 2019
lntermountain Gas Company
2019-2023 tRP
Avoided Costs
AVOIDED COSTS
Assumptions
lnflation Rate 2.O0o/o
Nominal Discount Rate 6.68%
Real Discount Rate 4.68%
Year #Year
Portfolio
Nominal Cost Real Percent
Therm
Real cost
(S/201e1 per
Therm
Real PV
2019Ss of
Resource
Portfolio
Cost
Effectiveness
Limit Real
2019
s0.4sl S0.46 S0.4812019s0.48
S0.47 -3.77%so.462l S0.88 S0.4722020
-8.20%3 2021 50.44 So.42l s1.2s 50.46
4 2022 S0.43 -4.930/a 50.403 |s1.s8 So.++
5 2023 s0.44 0.00%So.403l S1.91 S0.44
6 2024 So.+a -0.850/a So.40ol 52.27 s0.43
7 2025 s0.s0 10.69%so.442l s2.s3 50.43
8 2025 50.s6 9.98%So.485l 52.87 S0.44
9 2027 50.s7 0.09%So.487l s3.1e s0.44
10 2028 So.s8 -0.58%So.484l s3.s0 So.+s
11 2029 So.s9 0.83%So.488l S3.79 50.+s
r2 2030 50.51 7.14%So.494l S4.08 So.4s
t3 2031 S0.63 -0.09o/o so.4e3l s4.3s So.4s
1-4 2032 50.63 -0.70%So.4sol 54.61 So.4o
15 2033 So.5s 0.74%So.4eol S4.8s S0.46
16 2034 So.sz 0.80o/a So.4e4l Ss.09 S0.46
t7 2035 s0.68 0.42o/o 5o.4e6l Ss.32 S0.46
18 2035 50.70 136%So.s03 |Ss.s4 s0.46
19 2037 S0.73 7.37o/o Ss.7sSo.slol s0.46
zo 2038 So.7s !.38o/o Ss.96So.s 171 So.az
21-2039 S0.78 t.40%56.16so.s24l 50.47
22 2040 5o.ao 7.4t%So.s32 |So.:o 50.47
23 2041-S0.83 7.42%So.s3sl S6.ss S0.47
24 2042 S0.86 7A3%S6.73So.saz;5o.47
25 2043 S0.89 7.44%so.sss I S6.90 5o.47
26 2044 So.e2 t.46%S7.08So.s63l S0.48
27 2045 So.9s 1.47%57.24So.s71l S0.48
28 2046 So.es L.4a%S7.40so.ssol S0.48
29 2047 S1.02 t.49%Sz.soso.s88l S0.48
S1.06 L50%30 2048 57.715o.se7l 50.48
lntermountain 6as Company
2019-2023 tRP
Avoided Costs
Assumptions
lnflation Rate 2.OO%
Nominal Discou 6.680/o
Real Discount R 4.68%
HDD SHAPED AVOIDED COSTS
Year #Year
Portfolio
Nominal Cost Real Percent
Therm
Real cost
($/2019) per
Therm
Real PV
2019Ss of
Resource
Portfolio
Cost
Effectiveness
[imit Real
2019
.n q112019 So.s1 S0.49 So.s1
n cl22020 -1.89%So.so1 So.es 5o.sr
3 S0.48 -9.03%S0.45 S1.34 S0.49202L
4 -7.25%S0.423 S1.69 50.4720225o.as
5 -05L%S0.421 S2.03 S0.462023s0.46
6 2024 S0.46 -2.03%50.412 52.34 90.46
7 2025 So.s2 t2.83%So.46s s2.68 S0.46
0.s882026 9.42%So.so9 S3.03 S0.46
0.6092027 -0.06%s0.508 S3.37 s0.47
0.60102028 -o.83%So.so4 S3.6s 50.47
oR)11.2029 o.6s%So.so7 s4.00 50.47
72 2030 t.t6%So.s13 54.29 S0.48
13 -o.o90/.S0.513 S4.s7 S0.482031
t4 2032 -0.81%So.soe 5q.sq S0.48
15 0.04%So.so9 Ss.10 S0.482033
15 0.6L%So.s12 Ss.3s203450.59 S0.48
So.s14772035s0.71 0.37o/"Ss.sg s0.48
t.67%So.s23182036s0.73 ss.81 So.as
19 7.68%So.s31 S6.032037 s0.4s
20 1.70o/o So.s40 S6.2s2038S0.79 S0.49
2t 7.720/o So.sso S6.45 S0.492039s0.82
22 2040 So.8s t.74%So.ss9 S6.67 S0.49
23 2047 i0.88 1.75%5o.sos S6.86 S0.49
24 2042 i0.91 L.77%So.s79 S7.06 So.so
25 i0.95 L.79%So.s89 57.2s So.so2043
?6 2044 ;0.98 LAO%So.5oo 57.43 So.so
27 2045 S1.02 1.82%So.su 57.61 So.so
28 S1.06 1.84%$0.622 S7.78 So.so2046
29 L35%S0.634 S7.9s So.s1204751.10
30 2048 S1.14 1.87%S0.646 S8.11 So.s1
31 S1.18 1.50%So.6ss $8.27 So.s12049
32 1.35%S0.664 S8.422050$L.22 So.s1
33 1.20%5o.672 Sa.sz So.s12057S1.26
34 2052 S1.30 !.Q5o/o S0.679 S8.71 So.s2
35 2053 iL.34 0.90%50.68s S8.8s So.sz
36 2054 tL.37 0.750/.s0.590 S8.99 So.sz
37 205s 0.600/o S0.694 S9.11 So.s2
;L.44387056 oA5%s0.598 $g.zq S0.52
39 2057 o.30%So.7oo 59.3s So.s3
40 2058 S1.s1 0,75%So.7o1 S9.47 So.s3
4L 2059 So.70l Se.s7 so.s3
42 2060 0.00%So.7o1 S9.68 So.s3
43 2067 S1.60 0.00%So.701 5g.tt So.s3
44 2062 o.00%s0.701 S9.87 So.s3
45 2053 ;L.67 0.00%So.701 ss.e6 So.s3
46 2064 iL.70 o.00%So.701 S1o.04 So.s4
47 2065 tL.73 0.00%So.701 s10.12 So.s4
48 2066 iL.77 0.00%So.7o1 s10.20 So.sa
49 2067 S1.80 O.0oo/a So.701 S10.28 So.sa
50 2068 S1.84 0.00o/o 50.701 S1o.3s $0.s4
51 2059 51.88 0.0004 So.7o1 S10.42 So.s4
52 zo70 s1.91 0.00%So.7o1 s10.48 So.s4
lntermountain Gas Company
2019-2023 IRP
Avoided Costs
Assumptions
lnflation Rate 2.OO%
Nominal Discot 6.68%
Real Discount F 4.680/.
USAGE SHAPED AVOIDED COSTS
Portfolio Real cost
Nominal Cost Real Percent (5/2019) per
Real PV
2019$s of
Resource
Portfolio
Cost
Effectiveness
Limit Real
Year f Year Therm Therm zoLg
So.s1 S0.49 So.s1120L9So.s1
2 So.s1 -2.03%5o.so1 S0.94 So.s12020
3 -8.97%S0.46 S1.34 S0.49202LSo.ae
4 7.22%S0.423 S1.69 50.472027So.4s
5 -o59%So.42o S2.03 S0.46202350.46
6 So.4s -2.56%50.410 S2.34 S0.462024
7 13.34%S0.464 S2.582025So.s2 S0.46
9.47%So.so882026So.s8 S3.03 S0.46
0.02%s0.s0892027So.6o S3.37 S0.47
-o.80%So.so4 S3.6s10202850.60 s0.47
So.so711,2029 5o.oz 0.51%s3.es 50.+z
L.79%So.s13 54.29722030S0.54 S0.48
0.02o/a s0.s1313203tSo.6s 54.s7 S0.48
t4 S0.66 -0.7804 So.so9 54.s4 S0.482032
15 S0.67 -O.060/0 So.so9 5s. ro S0.482033
16 2034 S0.69 0.610/0 So.s1 Ss.34 S0.48
T7 S0.71 O.47o/o So.s14 Ss.s8 S0.482035
18 2036 S0.73 t.4t%So.s2 5s.81 S0.48
19 2037 So.7s 7.43%50.s29 S6.03 S0.49
20 S0.78 1A4%So.s35 56.24 S0.492038
2L 7.45%So.s44 S6.4s2039s0.81 S0.49
22 S0.84 1.46%So.ss2 )b.b5 S0.492040
23 L.48%s0.s60 S5.8s204LS0.86 S0.49
t.49%So.s59242042So.9o 57.o4 S0.49
25 Ls0%5o.s772043S0.93 57.22 So.so
26 t5L%So.s86 S7.402044S0.95 so.so
27 L.52%So.s9s 57.s72045S0.99 So.so
28 t.54o/o So.604 57.742046s1.03 So.so
29 t.55%S0.613 S7.9020475r.oo 5o.so
30 2048 t.56%S0.623 S8.06 So.s1
31 51.14 1.50%S0.632 5e.22 So.s12049
32 S1.18 t.35%S0.641 S8.362050 So.s1
33 7.20%S0.648 S8.s1zo575t.22 So.sr
34 $1.2s 7.05%So.6ss S8.5s So.s12052
35 S1.29 o.90%So.66r S8.78 So.s12053
36 o.75%s0.665 S8.912054s1.33 So.s2
37 S1.36 o.60%So.67o $s.os So.s22055
38 2056 S1.39 o.45%S0.573 5e.1s So.s2
39 2057 S1.43 o.3004 So.67s Ss.26 so.s2
40 2058 s1.46 o.L5%S0.676 Ss.:z So.s2
4L 2059 Sr.+s o.00%S0.676 5g.qt So.s2
42 2060 s1.s1 o.00%S0.676 $g.sz 50.s2
43 2061 s1.ss 0.00%S0.676 S9.57 So.ss
44 2062 S1.s8 0.00%S0.575 S9.76 So.s3
45 o.o0%S0.676206351.61 5g.a+So.s3
0.00%S0.676462064Sr.oq S9.93 So.s3
47 0.00%S0.67620655t.at 910.01 So.sg
48 0.00o/"S0.6752065S1.71 s10.08 So.s3
49 0.000/o S0.67620675!.74 S1o.1s So.se
50 o.o0%S0.676205851..77 iLo.22 So.s3
51 o.o0%S0.6762069$1.81 s10.29 So.s3
S0.676522070s1.8s 0.00%s10.3s So.s3
lntermountain Gas Company
2019-2023 rRP
Avoided Nominal Costs by Year
Asrumptions
2.00%llnfl ation annu.l %
S1.624lStarting Da*ribution Cost 5/MMBTU
Year #
I
2
3
4
5
e
7
I
I
10
11
12
13
14
15
16
17
18
19
2A
21
____3
23
24
25
21
28
29
30
lnt€rmountain Gas Company
Avoided Cost by Year
Nomlnal S/MMBTU/Yeal
Plannint Year Oct;Sep
tRP 2019-2023
Commodity
Cost
Distdbution
System Con
Fixed
Tranpofi
Cost
Assufrotions
Cost
lntcrmountain Gas Company
2019,2023 rRP
Avoided Nominal Costs by Year
lntermountain Gas Company
Avoided Cost by Year (HDD Shapel
Nominal S/MMBTU/Year
Plannint Year Oct:Sep
rRP 2019-2023
Year f
1
2
3
A
6
I
10
11
12
13
14
15
16
17
18
19
20
21
23
24
25
26
27
28
3o
Commodity
Cost
Distjlbutlon
System Cost
lnaremantal
FIred
Variable
Transport
Cost
A$umDtlons
Main
lntermountain Ges Company
2019-2023 rRP
Avoided Nominal Costs by Year
lntermountaln Gas Company
Avolded Cost by Year (Usage Shapel
Nominal 5/MMBTU/Year
Plannint Year OdiSep
tRP 2019-2023
Year {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
77
18
19
20
21
22
23
24
25
26
21
28
29
30
Commodity
Cort
Oistrlbution
Syltem Cost
lnaremental
Fixed Tranport
Co*
va,iable
Transpon Cost
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs (HDD Shaped)
AC Expected (BASE)
commodity, $/MMBTU
Date Year FWear Month HDD Shape
HDD Shaped
Commodity
So'10
so.2s
50.53
So 83
so.se
s0.4s
s0.29
s0.17
so.o8
So.o3
so.oo
so.o2
So.10
So.2s
s0.63
s0.83
so.ss
s0.4s
50.2s
s0.1s
so.o7
so.o3
So'oo
so.o2
So.os
s0.26
so.s5
s0.73
So's2
50.3e
s0.25
So'14
s0.07
s0'02
so.oo
So'or
so.o8
s0.23
so.4s
s0.64
$o'qt
So.se
So.zs
so.1s
s0.08
so.o2
s0.oo
so.o1
so.o8
s0.24
s0.48
3.5o/o
8.6%
L4.8o/o
20.Lo/o
L6.4o/o
L4.5%
!0.Oo/o
7.7o/o
3.4%
O.9o/o
o.r%
0.6%
3.5%
8.6%
L4.8%
20.t%
L6.4%
L4.5%
t0.o%
7.t%
3.4o/o
o.9%
0.7o/o
o.6%
3.5%
8.6%
14.8o/o
20.Lo/o
L6.4o/o
74.5o/o
I0.o%
7.Lo/o
3.4%
0.9o/o
0.7%
O.6Yo
3.5%
8.6%
L4.8%
20.t%
L6.4o/o
L4.5%
L0.Oo/o
7.7%
3.4o/o
0.9o/o
o.t%
o.6%
3.5%
8.6%
L4.8%
Oct-18 2018 20L9 10 s2.78
Nov-18 2018 2079 77 3.4t5
Dec-18 2078 2079 t2 4.24s
Jan-19 20L9 2019 1 4.13S
Feb-19 2079 2079 2 3.61S
Mar-19 20t9 20]-9 3 3.07s
Apr-19 2019 2079 4 2.9ts
May-19 5 s 2.35201920t9
Jun-19 2019 2019 6 2.42s
Jul-19 7 s 3.08201920L9
Aug-19 20t9 2019 8 3.09s
Sep-19 2019 20L9 9 )2.86
Oct-19 10 2.78s20L92020
Nov-19 20L9 2020 11 3.47s
Dec-19 20L9 2020 72 4.245
Jan-20 2020 2020 7 4.I3s
Feb-20 2 S 3.6120202020
Mar-20 2020 2020 3 $3.O7
Apr-20 2020 2020 4 s 2.9L
May-20 5 2.L5S20202020
Jun-20 2020 2020 5 s 2.79
Jul-20 2020 2020 7 2.79s
Aug-20 2020 2020 8 2.76s
Sep-20 2020 2020 9 2.545
Oct-20 2020 202L 10 s 2.48
Nov-20 2020 2021 77 s 3.03
Dec-20 L2 3.75S2020202t
Jan-21 2027 202L 1 3.56s
Feb-21 2021.202L 2 s 3.19
Mar-21 3 s 2.692027202t
Apr-27 2027 202L 4 s 2.55
May-21 2021.202L 5 s 1.99
Jun-21 202t 202t 5 2.05s
Jul-21 202L 202t 7 s 2.46
Aue-21 8 s 2.4920212027
Sep-21 2021 2027 9 2.34s
Oct-21 2021 2022 10 s 2.33
Nov-21 202L 2022 77 s 2.73
Dec-21 2021 2022 72 s 3.29
Jan-22 1 3.20520222022
Feb-22 2022 2022 2 2.88s
Mar-22 2022 2022 3 2.47s
Apr-22 2022 2022 4 2.305
May-22 2022 2022 5 2.L5s
Jun-22 2022 2022 6 2.2Ls
Jut-22 2022 2022 7 2.37
AuP,-22 8 2.42s20222022
Sep-22 2022 2022 9 2.38s
Ocl-22 2022 2023 10 2.35
Nov-22 11 2.76S20222023
Dec-22 2022 2023 L2 3.24S
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs (HDD Shaped)
AC Expected (BASEI
Commodity, $/MMBTU
Date Year FWear Month
HDD Shaped
Commodity
s0.64
S0.48
So'37
s0.23
s0.16
so.o8
5o'02
so.oo
So'02
s0.08
50.22
s0.41
So'61
So.s2
s0.38
50.2s
s0.17
so.08
so.o2
so.oo
so.o2
s0.10
So.za
so.se
so.7e
s0.s8
s0.4s
so.3o
s0.18
s0.09
So.o3
s0.00
so.o2
so.1o
s0.30
s0.60
S0.81
so.50
s0.47
s0.31
So.1s
so.os
50.03
so.oo
So.o2
s0.10
So.ao
S0.52
s0.82
s0.61
S0.47
HDD Shape
20.Lo/o
L6.4o/o
t4.5%
70.o%
7.1o/o
3.4%
0.9%
o.7%
o.6%
3.SYo
8.60/o
t4.8%
20.1o/o
16.4%
L4.5o/o
LO.O%
7.t%
3.4%
o.9%
0.t%
0.6%
3s%
8.6%
14.8o/o
20.7o/o
L6.4o/o
74.5%
70.0o/o
7.7o/o
3.4%
o.9%
0.t%
0.6%
3.5%
8.6%
t4.8%
20.L%
L6.4o/o
!4.5o/o
ro.o%
7.r%
3.4%
0.9o/o
0.7o/o
0.6%
3.s%
8.6%
74.8%
20.1%
L6.4%
L4.5%
Jan-23 2023 2023 L 3.20s
Feb-23 2023 2023 2 s 2.96
S 2.53Mar-23 2023 2023 3
Apr-23 2023 2023 4 s 2.33
May-23 2023 2023 5 s 2.24
s 2.29Jun-23 2023 2023 5
Jul-23 2023 2023 7 s 2.46
Aus-23 2023 8 s 2.502023
s 2.47Sep-23 2023 2023 9
Oct-23 2023 2024 10 s 2.45
11 s 2.55Nov-23 2023 2024
Dec-23 2023 2024 L2 2.79s
Jan-24 2024 2024 7 s 3.05
2 3.155Feb-24 2024 2024
s 2.65Mar-24 2024 2024 3
Apt-24 2024 2024 4 s 2.47
May-24 2024 5 S 2.342024
6 s 2.39Jun-24 2024 2024
Jul-24 2024 2024 7 s 2.55
Aue-24 2024 2024 8 s 2.57
9 s 2.55Sep-24 2024 2024
Oct-24 2024 202s 10 2.765
Nov-24 2024 2025 LL s 3.33
Dec-24 L2 5 3.9720242025
Jan-25 2025 2025 L 3.93s
Feb-25 202s 202s 2 s 3.55
Mar-25 2025 202s 3 s 3.10
s 3.01Apr-25 2025 2025 4
May-25 2025 2025 5 s 2.55
Jun-25 6 S 2.6020252025
Jul-25 2025 2025 7 3.05s
Aus-25 2025 2025 8 s 3.06
9 s 2.93Sep-25 202s 2025
Oct-25 202s 2026 10 2.90s
Nov-25 2025 2026 11 5 3.46
Dec-25 L2 s 4.O720252026
L s 4.05Jan-26 2026 2026
Feb-26 2026 2026 2 3.66s
Mar-25 2026 2026 3 3.27s
Apr-26 2026 2026 4 3.t2s
May-25 5 s 2.6720262026
Jun-26 2026 2026 6 2.70s
Jut-26 2026 2026 7 5 3.r4
Aug-26 8 3.L7s20262026
Sep-26 2026 2026 9 3.05s
Oct-26 2026 2027 10 3.01s
Nov-26 2026 2027 It s 3.55
Dec-25 L2 s 4.t620262027
Jan-27 2027 2027 1 4.O9s
Feb-27 2027 2027 2 3.725
Mar-27 2027 2027 3 3.28s
Intermountain 6as Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs (HDD Shaped)
AC Expected (BASEI
Commodity, $/MMBTU
Date Year FWear Month HDD Shape
HDD Shaped
Commodity
s0.32
50.19
so.os
So.o3
so.oo
so.o2
s0.11
s0.31
So.sz
s0.82
s0.61
s0.48
S0.32
so.2o
s0.10
50.03
s0.00
so.o2
So'11
So'31
s0.63
So'8s
So.ss
so.so
s0.33
s0.21
so.1o
so.o3
So.oo
so.o2
s0.11
S0.32
so.6s
S0.88
50.65
So.s2
so.3s
So.zz
so.1o
so.o3
so.oo
So'02
So'12
s0.33
50.67
so.8e
s0.67
So.s3
so.3s
5o.22
s0.11
I0.Oo/o
7.Lo/o
3.40/o
0.9o/o
0.to/o
0.60/o
3.5o/o
8.60/o
L4.8%
20.Lo/o
76.4%
74.5o/o
lO.0o/o
7.7o/o
3.4%
os%
0.1%
0.6%
3.5%
8.60/o
74.8%
20.1%
76.4%
74.5%
to.o%
7.LYo
3.4%
O.9o/o
o.1%
o.6%
3.5%
8.6%
L4.8%
20.Lo/o
L6.4%
t4.5%
lO.Oo/o
7.L%
3.4o/o
0.9%
0.L%
o.6%
3.s%
8.6%
L4.8%
20.1%
L6.4o/o
t4.5%
ro.o%
7.Lo/o
3.4o/o
Apr-27 2027 2027 4 3.18s
Mav-27 2027 5 2.74s2027
Jun-27 2027 2027 5 2.75s
Jul27 2027 2027 7 3.2ts
8 3.23sAug-27 2027 2027
3.10sSep-27 2027 2027 9
Ocl-27 2027 2028 10 s
Nov-27 2027 2028 11 3.57s
L2 4.L7sDec-27 2027 2028
Jan-28 2028 2028 L $
Feb-28 2 3.72s20282028
3.33sMar-28 2028 2028 3
Apr-28 2028 2028 4 3.22s
5 2.77sMay-28 2028 2028
Jun-28 2028 2028 6 2.795
Jul-28 2028 2028 7 3.24s
3.28sAug-28 2028 2028 8
Sep-28 2028 2028 9 s
Oct-28 2028 2029 10 3.L4s
Lt 3.62sNov-28 2028 2029
4.22sDec-28 2028 2029 L2
Jan-29 2029 2029 1 4.22s
Feb-29 2029 2029 2 3.85s
3.48sMar-29 2029 2029 3
Apr-29 2029 2029 4 3.335
May-29 2029 5 2.91s2029
2.92sJun-29 2029 2029 6
Jul-29 2029 2029 7 5
Aue-29 2029 2029 8 3.43s
9 3.30SSep-29 2029 2029
3.29sOct-29 2029 2030 10
Nov-29 2029 2030 11 3.79s
Dec-29 2029 2030 t2 4.38s
Jan-30 L 4.37s20302030
Feb-30 2030 2030 2 4.01s
Mar-30 2030 2030 3 3.62S
4 3.45sApr-30 2030 2030
May-30 2030 2030 5 3.03s
Jun-30 2030 2030 6 3.05S
Jul-30 7 3.50s20302030
3.53SAug-30 2030 2030 8
Sep-30 2030 2030 9 3.43S
Oct-30 203L 10 3.40S2030
11 3.91SNov-30 2030 203r
Dec-30 2030 2031 t2 4.51s
Jan-31 2037 203L t 4.43S
Feb-31 2037 203L 2 4.O7S
3.66sMar-31 2031 203L 3
Apr-31 2031 2031 4 s
May-31 203t 203t 5 3.08s
3.11sJun-31 2031 203L 6
3.07
4.09
3.r7
3.38
3.50
Jul-3L 203r 2031 7 3.555
Aug-31 2031 2037 8 s 3.57
Sep-31.2037 9 s 3.47203t
s 3.44Oct-31 2031 2032 10
Nov-31 2031 2032 LT S 3.96
Dec-31 2032 t2 s 4.55203t
1 s 4.43Jan-32 2032 2032
Feb-32 2032 2032 2 s 4.09
Mar-32 2032 2032 3 s 3.69
Apr-32 2032 2032 4 3.53s
May-32 2032 2032 5 3.10S
Jun-32 2032 2032 6 3.L45
3.60sJul-32 2032 2032 7
Aug-32 2032 2032 8 3.60s
Sep-32 2032 2032 9 3.48s
Oct-32 2032 2033 10 3.47stt3.99sNov-32 2032 2033
Dec-32 2032 2033 t2 s
Jan-33 2033 2033 1 s 4.53
2 4.20sFeb-33 2033 2033
Mar-33 2033 2033 3 3.795
Apr-33 2033 4 3.62s2033
May-33 2033 2033 5 3.20s
Jun-33 2033 2033 6 3.245
Jul-33 2033 2033 7 3.70S
8 3.70SAug-33 2033 2033
Sep-33 2033 2033 9 3.60s
Oct-33 2033 2034 10 s 3.57
Nov-33 2033 2034 11 4.L0s
t2 4.70sDec-33 2033 2034
Jan-34 2034 2034 1 s 4.64
Feb-34 2034 2034 2 s 4.37
Mar-34 3 s 3.9220342034
Apr-34 2034 2034 4 3.76s
May-34 2034 2034 5 s 3.34
Jun-34 2034 2034 6 S 3.36
7 s 3.83Jul-34 2034 2034
Aug-34 2034 2034 8 s 3.85
Sep-34 2034 2034 9 3.76s
Oct-34 2034 2035 10 3.72s
Nov-34 LL s 4.2520342035
Dec-34 2034 203s T2 4.875
Jan-35 2035 203s 1 4.74s
Feb-35 2035 2035 2 5 4.40
Mar-35 2035 203s 3 4.01s
Apr-35 2035 203s 4 s 3.85
May-35 2035 203s 5 s 3.44
Jun-35 2035 2035 6 3.45S
Jul-35 203s 2035 7 3.91s
Aus-35 8 s 3.9520352035
Sep-35 2035 2035 9 s 3.84
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs (HDD Shaped)
AC Expected (BASEI
Commodity, $/MMBTU
Date Year FYYear Month HDD Shape
HDD Shaped
Commodity
so.o3
so.oo
so.o2
S0.12
s0.34
s0.68
So'ss
$0.67
so.s4
so.3s
So'22
S0.11
So.os
so.oo
So'02
So.rz
So.a+
s0.58
So'91
5o.ss
so.ss
s0.35
S0.23
S0.11
so.03
so.oo
so.02
s0.12
so.3s
so.7o
s0.93
So.zr
so.s7
s0.38
s0.24
s0.11
So'04
5o.oo
So.o2
50.13
s0.36
s0.72
so.ss
50'72
so.s8
s0.39
So.z+
s0.12
50.04
so.oo
So'02
0.9%
o.7%
o.6%
3.s%
8.6%
14.8%
20.1%
t6.4%
L4.5o/o
L0.0o/o
7.t%
3.40/o
0.9%
o.L%
0.60/o
3.5%
8.60/o
74.8o/o
20.t%
16.4o/o
L4.5o/o
t0.o%
7.to/o
3.4%
o.9%
0.L%
0.6%
3.5%
8.6%
74.8o/o
20.7%
L6.4%
74.s%
L0.o%
7.r%
3.4%
0.9o/o
0.Lo/o
O.6%o
3.5%
8.6%
74.8%
20.!ok
76.4o/o
14.5%
70.0%
7.1%
3.4%
o.9%
o.L%
0.6%
4.58
Intermountain Gas Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs (HDD Shaped)
AC Expected (BASE)
Commodity, S/MMBTU
Date Year FYYear Month HDD Shape
HDD Shaped
Commodity
S0.13
s0.37
s0.73
Sr'o+
s0.77
so.60
So'+r
so.2s
s0.12
so.04
so.oo
so.o2
So.rs
s0.38
So'80
3.5%
8.6%
t4.8%
20.1o/o
t6.4%
L4.5o/o
L0.o%
7.L%
3.4o/o
0s%
0.70/o
0.60/o
3.5%
8.6%
L4.8%
ocr3sl 2o3s 102035 |3.82s
Nov-351 2035 2036 |11 s 4.3L
Dec-351 2035 t22035 |4.93s
Jan-361 2036 2036 |1 5.18s
5 4.69Feb-361 2036 22036 |Mar-361 2cf,G 2035 |3 4.L5s
4.09sApr-361 2$6 42036 |May-361 2036 52036 |3.455
Jun-361 2036 2035 |6 3.55s
4.20$Jul-361 2036 72036 |
4.20sAug-361 2036 82036 |
Sep-361 2036 92036 |3.97s
oct-361 2036 20371 10 5 3.88
s 4.49Nov-361 2036 112c37l
Dec-361 2036 t22037l s.385
lntermountain 6as Company
2019-2023 tRP
Avoided Costs - Monthly Commodity Costs (HDD Shaped)
Year Sum of HDD Shaped Commodity
20t9 3.474274827
2020 3.447t09756
202t 3.054825339
2022 2.77L5525r3
2023 2.80403092
2024 2.7575L8053
3.4093413072025
HDD Shape
Month % ofAnnual HDD
2026
2027
3.522629704
3.589331948
1
2
3
4
5
6
7
8
9
10
11
t2
20.r%
16.4o/o
L4.5%
70.Oo/o
7.t%
3.4%
O.9o/o
0.106
0.6%
3.5%
8.6%
74.8o/o
2028 3.6L1877436
2029 3.723t3246
2030 3.859115839
2031 3.940642339
3.9558568632032
2033
2034
4.O49L49239
4.L71239t77
4.2803t44432035
2036 4.483ss9691
2037 1.376670L17
lntermountain Gas Company
2019-2023 rRP
Avoided costs - Monthly Commodity Costs (Usage Shaped)
AC Expected (BASE)
commodity, S/MMBTU
Date Year FYYear Month Usage Shape
UsaSe Shaped
Commodity
so.20
So'43
S0.73
So.7o
S0.48
So'sq
s0.23
S0.12
So.o6
So.04
s0.0s
So.o9
So.2o
5o.qe
S0.73
So.7o
s0.48
S0.34
S0.23
S0.11
So.os
So.04
So.04
So.08
$0.18
S0.38
s0.6s
S0.62
s0.43
s0.30
50.20
So.1o
So.os
So.o3
So'o+
So'oz
So'rz
s0.3s
So's7
So's4
so.3s
S0.28
S0.18
S0.11
So.os
So.o3
So.04
So'07
S0.17
So.3s
So.s6
So.s4
So.40
S0.28
$0.18
s0.11
so.06
so.03
So'04
7.3%
72.7o/o
173%
76.9%
L3.4o/o
7L.lo/o
7.9%
5.00/o
25%
1.4%
!.50/o
3,00/o
73%
t2.7%
L7 .30/o
L6.9%
L3.4%
LL,L%
7.9%
5.Oo/o
2.5%
1.4%
75%
3.0o/o
73%
L2.7%
!7.3%
16.90/o
13.4%
ll.lo/o
7.90/o
5.Oo/o
2s%
L.4%
75%
3.0%
73%
12.7%
t73%
16.90/.
73.4%
L!.Lo/o
7.9%
5.O%
2.5o/o
1.40/o
L.5o/o
3.0%
7,30/o
12.7%
17.3%
76,9%
13.4%
tt.L%
7.9o/o
s.o%
25%
7.4o/o
t.5o/o
Oct-18 2018 2079 10 52.78
Nov-18 2018 2079 11 3.4L
Dec-18 2018 2019 t2 4.24
Jan-19 20t9 1 4.1320L9
Feb-19 2 3.6120L92019
Mar-19 zolg 2019 3 3.O7
Aor-19 4 2.9t20792079
May-19 5 2.3520192019
Jun-L9 6 2.4220192019
J ul-19 7 3.0820\9 2079
Aus-19 8 3.0920192079
Sep-19 20L9 2079 9 2.86
Oct-19 10 2.78zoL92020
Nov-19 2079 2020 11 3.41
Dec-1.9 2019 2020 L2 4.24
Jan-20 1 4.13zo202020
Feb-20 2 3.61?o20 2020
Mar-20 2020 2020 3 3.07
Apr-20 7020 2020 4 2.91-
May-20 2020 5 2.152020
Jun-20 2020 2020 6 2.1-9
Jul-20 2020 2020 2.79
Aue-20 2020 2020 8 2.76
Sep-20 2020 2020 9 2.54
Oct-20 2020 202L 10 2.48
Nov-20 2020 202L 11 3.03
Dec-20 2020 2021 L2 3.75
Jan-21 1 3.66202t2027
Feb-21 2 3.192021202L
Mat-ZL 3 2.6920212021
Apr-2L 202L 2021-4 2.55
May-21 202t 2027 5 1.99
Jun-21 202t 202L 6 2.05
JUIZL 202r 202L 7 2.46
Aug-21 202L 20zr 8 2.49
Sep-21 2021 2021 9 2.34
Oct-2L 2027 2022 10 2.33
Nov-21 207L 2022 11 2.73
Dec-21 202L 2022 t2 3.29
Jan-22 2022 2022 1 3.20
Feb-22 2022 2022 2 2.88
Mar-22 2022 2022 3 2.47
Apr-22 2022 2022 4 2.30
Mav-22 zo22 2022 5 2.!5
Jun-22 2022 2022 6 2.2ts
s 2.37)u122 2022 2022 7
s 2.42Auc-22 2022 2022 8
5ep-22 9 s 2.3820222022
Oct-22 10 2.3520222023
Nov-22 11 2.7620222023
Oec-22 t2 3.2420222023
.Jan-23 1 s 3.2020232023
Feb-23 2 2.9620232023
Mar-23 3 s 2.5320232023
AOr-23 5 2.33202320234
s 2.24May-23 2023 2023 5
Jun-23 s 2.2920?3 2023 5
J ul-23 s 2.46202320237
s 2.50Aug-23 2023 2023 8
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs (Usage Shapedl
AC Expected (BASE)
Commodity, 9/MMBTU
Date Year FYYear Month Usate Shape
Usage Shaped
Commodity
So.o7
S0.18
So'32
So'48
So sz
So 42
So.3o
S0.19
S0.12
So.o6
So'04
So'04
so.o8
So.20
s0.42
S0.69
S0.57
S0.48
So.3s
So'24
s0.13
s0.06
50.04
So.os
so.os
s0.21
So'+a
So'70
so.5e
s0.49
s0.35
So'2s
S0.13
So'oz
s0.04
So.os
So'oe
So'22
So'4s
5o'tz
S0.69
So.so
So'37
So.2s
S0.14
So.o7
So'04
So.os
So.o9
s0.22
So.4s
50.72
S0.59
So.so
S0.37
So.2s
So.la
5o'07
So.os
3.0%
7.3o/o
!2.70/o
!7.30/o
L6.9%
L3.4%
LL.T%
7.9%
5.0%
2.5%
1.4%
75%
3.0%
7.3%
12.704
173%
t6.9%
t3.4%
tL.t%
7.9%
5,0%
2s%
7.4o/o
L.5o/o
3.Oo/o
7,30/o
12.70/o
!7.3%
16.9%
L3/.%
tt.t%
7.9%
5.O%
2.5%
7.4%
L.5'/o
3.0%
7.3%
72.7%
\7.3%
t6.9o/o
t3.4%
!7.!oA
7.9o/o
5.0%
2.s%
1.4%
l.5o/o
3.Oo/o
7.30/o
L2.70
173%
L6.9%
t3.4%
LL.L%
7.9%
5.0%
2.s%
!.4o/o
Sep-23 9 2.4720232023
Oct-23 zo23 2024 10 2.45
Nov-23 2023 11 2.552074
Dec-23 L2 2.7920232024
Jan-24 1 3.0520242024
Feb-24 2024 7024 2 3.15
Mat-24 3 2.6520242024
Apr-24 4 2.4720242024
May-24 5 2.3420242024
Jun-24 6 2.3920242024
7 2.55Ju|.z4 2024 2024
8 2.57Aug-24 2024 2024
9 2.55Sep-24 2024 2024
10 2.76Oct-24 2024 2025
11 3.33Nov-24 2024 2025
Dec-?4 12 3.9720242025
Jan-25 1 3.9320252025
Feb-25 2025 2025 2 3.55
Mar-25 20?5 2025 3 3.10
Apr-25 2025 2025 4 3.01
May-25 2025 2025 5 2.55
J un-25 202s 2025 6 )Rn
Jul-25 2025 2025 7 3.0s
Aus-25 7025 2025 8 3.06
Sep-25 2025 2025 9 2.93
Oct-25 2025 2026 10 2.90
Nov-25 2025 2026 11 3.46
Dec-25 2025 2026 L2 4.O7s
Jan-26 2026 2026 1 4.05s
Feb-26 2026 2026 2 3.66s
Mar-26 2026 2026 3 3.21s
Apr-26 2026 2026 4 3.72s
May-26 2026 2026 5 2.67s
Jun-26 2026 2026 6 2.70Sr
Jul-26 2026 2026 7 3.14S
Aug-26 2026 2026 8 3.L7s
Sep-26 2026 2026 9 3.05S
Oct-26 2026 2027 10 3.01s
Nov-26 2026 2027 11 3.555
Dec-25 2026 2027 1-2 4.t6s
s 4.09Jan-27 2027 2027 1
s 3.72Feb-27 2027 2027 2
s 3.28Ma??7 2027 2027 3
s 3.18Apt-27 2077 2027 4
May-?7 5 2.7420272027
)un-27 5 2.7520272021
Jul27 7 3.2120272027
Aue-27 8 3.2320272027
sep-27 2027 2027 9 3.10
Oct-27 2027 2028 10 3.O7
Nov-27 2027 2028 11 3.57
Oec-27 2027 2028 L2 4.17
Jan-28 2028 2028 1 4.09
Feb-28 2028 2028 2 3.72
Matr28 2028 2028 3 s 3.33
Apr-28 2028 2028 4 1.22s
May-28 2028 2028 5 2.77s
Jun-28 2028 2028 6 2.79s
J ul-28 2028 2028 7 3.24)
lntermountain Gas Company
2019-2023 tRP
Avoided Costs - Monthly Commodity Costs (Usage Shaped)
AC Expected (BASE)
commodity, S/MMBTU
Date Year FYYear Month Usage Shape
Usage Shaped
Commodity
So'os
So.1o
s0.23
S0.46
S0.73
S0.71
so.s2
S0.39
s0.26
So'14
s0.07
So.os
So.os
so.1o
5o'zq
S0.48
s0.76
5o.74
So'sq
So'40
5o.27
So.1s
So'07
So.os
so.os
So.10
So.2s
So.so
s0.78
So.7s
5o.ss
S0.41
S0.28
So.1s
So.08
So.os
So'os
So.1o
So'2s
So.so
So'zs
So.7s
So.ss
S0.41
S0.28
So.1s
5o'08
So.os
So os
So'10
So'2s
so.s1
So'zg
50.77
So.s5
S0.42
S0.29
S0.16
So.08
L.5%
3.0%
7.3%
L2.7%
77.3%
16.9%
73.4%
tt.t%
7.9%
5.0%
2.5%
7.4%
7.5%
3.0%
7.3o/o
!2.7%
17.3%
76.9%
13.404
77.7%
7.9%
5.00/o
2.5%
1.4%
7s%
3.0%
73%
72.7%
77.3%
16.9%
13.4o/o
tL.Lo/o
7.9%
5.0%
2.5o/o
L.4o/o
L,5%
3,Oo/o
7.304
72.7o/o
\7.30/o
76.90/o
73.4%
tl.LoA
7.9%
5.Oo/o
2.s%
L.4%
t.5%
3.0%
7.3%
t2.7%
L7.3%
16.9o/o
13.4%
7L.7%
7.9%
5.0%
2.5%
Aus-28 2028 2028 8 3.28
5ep-28 2028 2028 9 3.L7
Oct-28 2028 2029 10 3.L4
Nov-28 2028 2029 11 3.62
Dec-28 2028 2029 L2 4.22
Jan-29 2029 2029 1 4.22
Feb-29 2029 2029 2 3.86
Mar-29 2029 ?oz9 3 3.48
Apr29 2029 zo29 4 3.33
May-29 2029 2029 5 2.97
J un-29 2029 2029 6 2.92
Jul-29 2029 2029 1 s 3.38
Aup-29 8 3.4320292029
Sep-29 2029 2029 9 3.30
Oct-29 2029 2030 10 3.29
Nov-29 2029 2030 11 3.79
Dec-29 72 4.3820292030
Jan-30 2030 2030 1 4.37
Feb-30 2030 2030 2 4.01
Mar-30 2030 3 3.522030
Apr-30 4 3.4520302030
May-30 2030 2030 5 3.03
J un-30 2030 2030 5 3.0s
Jul-30 2030 2030 1 s 3.s0
Aus-30 2030 2030 8 3.53
Sep-30 2030 2030 9 3.43
Oct-30 2030 2037 10 3.40
Nov-30 2030 2031 11 s 3.91
Dec-30 2030 2037 72 s 4.51
Ja n-3 1 2031 203!L 4.43
Feb-31 2031 2037 2 s 4.O7
Mar-31 2031 2031 3 3.66s
Apr-31 zo3L 2031 4 3.50S
s 3.08NIay-3 1 2031 2031 5
5 3.11Jun-31 2031 203t 6
5 3.55J ul-31 2031 2031 7
3.57AUB-31 703L 203L 8
Sep-31 9 3.47203L203L
Oct-31 10 3.4420372032
11 3.96Nov-31 2031 2032
L2 4.55Dec-31 2031 2032
)an-32 I 4.4320322032
2 s 4.09Feb-32 2032 2032
Matr32 3 3.6970322032
Apr-32 zo3?2032 4 3.53
May-32 2032 2032 5 3.10
Jun-32 2032 2032 6 3.14
Jul-32 2Q32 2032 7 3.50
Aua-32 2032 2032 8 3.50
Sep-32 2032 2032 9 3.48
Oct-32 2032 2033 10 3.47
Nov-32 2032 2033 11 3.99
Dec-32 2032 2033 L2 4.58
Jan-33 2033 2033 7 4.53
Feb-33 2033 2033 z 4.20
Mar-33 2033 2033 3 3.79
Apr-33 2033 2033 4 3.62
May-33 2033 2033 5 3.20
Jun-33 2033 2033 6 s 3.24
lntermountain Gas Company
2019-2023 IRP
Avoided Costs - Monthly Commodity Costs (Usage Shaped)
AC Expected (BASE)
commodity, $/MMBTU
Date Year Month Usage Shape
Usage Shaped
Commodity
So.os
So.o6
So.rr
S0.26
50.s2
S0.81
S0.79
So.s8
S0.44
So.3o
S0.17
So.08
So.os
So.06
So.rr
5o'zt
So.s4
So.sq
So.80
So.s9
So.4s
So.3o
So.lz
So.o8
5o.os
50.06
50.12
s0.28
so.ss
So.8s
s0.88
S0.63
S0.45
50.32
So'rz
So.o9
So.oo
So.o6
So'12
S0.28
So.s7
So.e3
L,40/o
L.5%
3.0%
7.3%
72.7%
t7.3%
76.90A
13,40/o
7L.L%
7.9%
5.0%
25%
t.4%
L.5%
3.Oo/o
7.3o/o
t2.7%
77.3o/o
16.9%
L33%
lL.to/o
7.90/o
5.Oo/o
2.s%
L.4%
L5%
3.O%
73%
!2.70h
77.3o/o
L6.90A
!3.4o/o
77.7%
7.9%
5,Oo/o
2.50/o
L.4%
L5%
3.0%
7.3o/o
L2.7%
L7.3%
Jul-33 7 s 3.7020332033
Aus-33 2033 2033 s 3.70
Sep-33 2033 9 s 3.502033
Oct-33 2033 2034 10 s 3.57
Nov-33 2033 11 s 4.102034
Dec-33 2033 2034 L2 4.70
Jan-34 2034 2034 1.s 4.64
Feb-34 2034 2 s 4.312034
Mar34 2034 3 3.92s2034
Apr-34 2034 2034 4 3.76
May-34 2034 2034 5 3.34
J u n-34 6 3.3520342034
Jul-34 2034 2034 7 3.83)
Aus-34 2034 8 s 3.852034
Sep-34 2034 2034 9 3.76s
Oct-34 2034 2035 10 3.72s
Nov-34 2034 2035 11 4.25
Dec-34 ?o34 2035 72 4.87
Jan-35 2035 2035 1 4.74
Feb-35 2035 2035 2 4.40
Mar-35 2035 2035 3 4.0L
Apr-35 203s 203s 4 3.8s
May-35 2035 203s 5 3.44
Jun-35 2035 2035 6 3.45
J ul-35 2035 2035 7 3.91
Aug-35 2035 203s 8 3.9s
Sep-35 2035 2035 9 3.84
Oct-35 2035 2036 10 3.82
Nov-35 2035 2036 t7 4.3L
Dec-35 2035 2036 L2 4.93
Jan-36 2036 2036 L 5.18
Feb-36 2036 2036 2 4.69
Mar-35 2035 2036 3 4.L5
Apr-36 2035 2036 4 4.09
May-36 2036 2036 5 3.45
Jun-36 2035 2036 6 3.55
Jul-36 2036 2036 7 4.20
Aua-36 2036 2036 8 4.20
Sep-35 2036 2036 9 3.97
Oct-36 2036 2037 10 s 3.88
Nov-36 2036 2037 ),1,S 4.49
Dec-36 2036 2037 t2 s 5.38
lntermountain Gas Company
2019-2023 tRP
Avoided Costs - Monthly Commodity Costs (Usage Shapedl
Year Sum ofUsage Shaped Commodity
20t9 3.477201404
2020 3.442965087
2027 3.053833744
2022 2.772003484
2023 2.80110478
2.74047469420?4
2025 3.40L441125
2026 3.516247688
3.5875403L72027
2028 3.61189916
2079 3.715155502
2030 3.86273207
2031 3.94L356774
2032 3.969524t22
2033 4.044756369
2034 4.166349595
2035 4.78L790967
2036 4.467793078
2037 7.7851687L7
Usage shape
Month %ofAnnual Usage
1
2
3
4
5
6
7
8
9
10
11
L2
76,9%
13.4%
tL.t%
7.9%o
5.0%
2s%
t.4%
L5%
3.O%
73%
t2.7%
L7.3%
lntermountain Gas Company
2019-2023 tRP
Avoided Corts - Monthly Commodity Costs
Date Year FYYear Month
Nominal $s
AC Expected (BASE)
Commodity, S/MMBTU
Com Year Annual Commodity Cost
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
zo3L
2032
2033
2034
2035
2036
2037
3.163083333
3.048412728
2.721067054
2.559690779
2.6708475
2.62675675
3.752377882
3.26434709
3.334459453
3.3679359t2
3.483585216
3.620788592
3.687846988
3.7779a4795
3.807479173
3.92927037
4.035650385
4.208903928
4.582827399
Oct-18 2078 2079 10 s2.78
Nov-18 11 3.47S20182079
Dec-18 2018 2079 r2 4.74S
4.7r5Jan-19 2019 2079 1
Feb-19 2079 2079 2 3.615
Mar-19 2079 2019 3 3.075
Apr-19 2079 2079 4 z.9L5
May-19 2019 2079 5 2.35s
J un-19 6 s 2.4720192019
J ul-19 2019 2019 7 s 3.08
Aug-19 2079 2019 8 s 3.09
Sep-19 9 S 2.8620792019
Oct-19 2079 2020 10 2.78S
5 3.47Nov-19 2079 2020 11
Dec-19 7079 2020 12 s 4.24
Jan-20 2020 2020 1 s 4.13
Feb-20 2 3.61s20202020
Mar-20 2020 zo20 3 s 3.07
Apr-20 5 2.97202020zo4
May-20 2020 2020 5 5 2.75
Jun-20 2020 2020 6 2.79s
Jul-20 2020 7 2.79S2020
Aug-20 2020 2020 8 2.76S
Sep-20 9 S 2.5420202020
Oct-20 2020 2027 10 2.48
Nov-20 2020 2027 77 3.03s
Dec-20 2020 2027 72 3.75s
Jan-27 2027 202t 7 3.66s
Feb-21 2027 2 s 3.192021
Mar-21 202L 2021 3 )2.69
Apr-21 4 s 2.5520212027
May-27 202L 2027 5 s 1.99
J un-21 6 s 2.05202t2027
Jul-21 202L 7027 7 s 2.46
Aus-21 s 2.492021202r8
Sep-21 2027 2027 9 S 2.34
Oct-21 2.332021202210
Nov-21 2027 2022 77 s 2.73
Dec-21 2021 2022 72 s 3.29
Jan-22 2022 2022 7 3.20
Feb-22 2022 2022 2 )2.88
Mar-22 2022 2022 3 2.47
Apr-22 2022 2022 4 s 2.30
May-22 2022 2022 5 s 2.75
)un-22 2022 6 2.272022
Jul22 2022 2022 7 2.37s
Aua-22 2.42202220228
Sep-22 2022 2022 9 2.?8S
Oct-22 2.3s2022202310
Nov-22 2022 2023 7L 2.76$
Dec-22 2022 2023 TZ 3.24S
Jan-23 2023 2023 1 3.20s
Feb-23 2023 2023 2 2.96s
Mar-23 2.s3202320233
Apr-23 2023 2023 4 2.33s
lntermountaln Gas Company
2019-2023 rRP
Avoided costs - Monthly Commodity Costs
Nominal Ss
AC Expected (BASEI
Commodity, S/MMBTU
Date Year FYYear Month
May-23 2023 2023 5 5 2.24
J u n-23 2023 2023 6 ? ,os
J u l-23 2023 2023 7 s 2.46
Aug-23 2023 2023 e 5 2.50
Sep-23 9 s 2.4720232023
Oct-23 2023 2024 10 S 2.43
Nov-23 2023 2024 77 S 2.55
Dec-23 2023 2024 72 2.79I
Jan-24 2024 2024 7 3.05s
Feb-24 2 3.15s20242024
Mar24 2024 2024 3 2.655
Apr-24 zo24 2024 4 2.475
Mav-24 2024 2024 5 2.34S
Jun-24 2074 2024 6 2.395
Jul24 2024 7 s 2.552024
Aug-24 2024 2024 6 s 2.57
Sep-24 9 s 2.5520242024
Oct-24 2024 2025 10 2.76s
Nov-24 2024 2025 L1 3.33)
Dec-24 2024 2025 t2 s 3.97
Jan-25 2023 2025 1 5 3.93
Feb-25 2 S 3.5520252025
Mar-25 2025 2025 3 S 3.10
Apr-25 202s 2025 4 s 3.01
May-25 2025 2025 5 s 2.55
J un-25 zo25 2025 6 s 2.60
Jul-25 2025 2025 7 5 3.05
Aug-25 2025 2025 8 5 3.06
Sep-25 2025 2025 9 s 2.93
Oct-25 2025 2026 10 S 2.90
Nov-25 2025 2026 11 S 3.46
Dec-25 2025 2026 72 S 4.07
Jan-25 2026 2026 1 s 4.05
Feb-26 2026 2 3.662026
Mar-26 zo26 2026 3 s 3.27
Apr-26 2026 2026 4 3.72
May-26 2026 2026 5 2.67s
Jun-25 2026 2026 6 2.70s
J ul-25 2026 2026 7 3.74S
Aug-26 2026 2026 8 3.77S
Sep-25 2026 2026 9 3.0s
Oct-26 2026 2027 10 3.01s
Nov-26 2026 2027 77 3.55s
Dec-26 2026 2027 L2 4.76s
Jan-27 2027 2027 1 s 4.09
Feb-27 2027 2027 2 3.725
Mar27 2027 2027 3 3.28
Apt-27 2027 2027 4 3.18S
May-27 2027 2027 5 2.74S
lun-27 6 2.7520272027
Jul27 2027 2027 7 3.27s
Aus-27 2027 2027 8 3.23
Sep-27 2027 2027 9 s 3.10
Oct-27 2027 2028 10 5 3.O7
Nov-27 2027 L7 3.572028
lntermountain Gas Company
2019-2023 tRP
Avoided Costs - Monthly Commodity Costs
Nominal Ss
Ac Expected (8ASEl
commodity, S/MMBTU
Date Year FYYear Month
t2 )4.77Oec-27 2027 2028
Jan-28 2028 2028 L S 4.09
5 3.72Feb-28 2028 2028 2
Mar-28 2028 7028 3 S 3.33
Apr-28 zo28 2028 4 3.22s
S 2.77May-28 2028 2028 5
Jun-28 6 )2.7920282028
Jul-28 2028 2028 7 S 3.24
s 3.28Aug-28 2028 2028 8
Sep-28 2028 2028 9 S 3.L7
Oct-28 2028 zo29 10 3.L4s
Nov-28 2028 2029 11 S 3.62
Dec-28 2028 2029 77 4.22s
Jan-29 1 4.2220292029
Feb-29 2029 2029 2 S 3.86
3.48Mar-29 2029 2029 3
Apr29 2029 2029 4 )3.33
May-29 2029 2029 5 2.97S
Jun-29 5 s 2.9220292029
Jul-29 2029 2029 7 s 3.38
s 3.43Aug-29 2029 2029 8
Sep-29 2029 2029 9 s 3.30
5 3.29Oct-29 2029 2030 10
Nov-29 2029 2030 L7 s ?.79
s 4.38Dec-29 2029 2030 IZ
Ja n-30 2030 2030 7 S 4.37
Feb-30 2030 2030 2 4.01s
Mar30 3 5 3.6220302030
Apr-30 2030 2030 4 s 3.45
5 3.03May-30 2030 2030 5
Jun-30 6 3.0ss20302030
lul-30 2030 2030 7 5 3.50
a 3.s3sAug-30 2030 2030
Sep-30 2030 2030 9 s 3.43
Oct-30 2030 2037 10 3.405
Nov-30 11 s 3.9120302037
Dec-30 2030 2017 L2 4.57s
Ja n-31 1 5 4.43203t2037
Feb-31 2031 203L 2 )4.07
3 3.66SMar-31 2031 2037
Apr-31 203L 2031 4 3.s0S
May-31 3.08S203Lzo375
J u n-31 2037 2037 6 3.115
J ul-31 203t zo31 7 3.555
Aus-31 2037 2037 8 3.57S
Sep-31 2037 203L 9 3.47S
Oct-31 10 3.44S203L2032
Nov-31 2037 2032 71 3.96S
tz S 4.55Dec-3 1 203t 2032
Jan-32 2032 zo32 1 S 4.43
S 4.09Feb-32 2032 2032 2
Mar-32 2032 2032 3 3.59S
Apr-32 zo32 2032 4 3.s3s
May-32 2012 2032 5 3.10S
J un-32 2032 2032 6 3.74
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Monthly Commodity Costs
Nominal Ss
AC Expected (BASEI
Commodity, S/MMBTU
Date Year FYYear Month Com
Jul-32 2032 2032 7 3.60S
Aug-32 2032 2037 8 3.60s
Sep-32 9 3.48)2032 2032
Oct-32 20!2 2033 10 3.47s
11 3.99sNov-32 2032 2033
Dec-32 2032 2033 72 4.58s
4.535Ja n-33 2033 2033 1
Feb-33 2033 2033 2 4.20s
Mar-33 2033 2033 3 3.79s
Apr-33 4 3.62)2033 2033
May-33 2033 2033 5 3.20s
Jun-33 2033 2033 6 3.24S
3.70sJul-33 2033 2033 7
Aue-33 2033 2033 a 3.70S
Sep-33 2033 2033 9 3.50s
3.57sOct-33 2033 2034 10
Nov-33 2033 2034 L7 4.70S
4.70sDec-33 2033 2034 L2
Ja n-34 2034 2034 L S 4.64
Feb-34 2034 2034 2 4.315
Mar-34 2034 2034 3 3.92S
Apr-34 2034 2034 4 3.76s
May-34 2034 2034 5 3.34S
Jun-34 2034 2034 6 3.36S
7 3.83SJul-34 2034 2034
Aus-34 2034 2034 6 3.85S
Sep-34 2034 2034 9 3.76S
Oct-34 10 3.72S20342035
Nov-34 2034 2035 t7 S 4.25
Dec-34 72 $4.8720342035
Jan-35 2035 2035 1 4.74s
2 )4.40Feb-35 2035 2035
Mar-35 2035 2035 3 s 4.01
S 3.8sApr-35 2035 203s 4
May-35 2035 2035 5 S 3.44
Jun-35 2035 2035 6 3.45S
J ul-35 2035 2035 7 s 3.91
Aug-35 2035 2035 8 s 3.9s
Sep-35 I s 3.8420352035
Oct-35 2035 2036 10 3.82
Nov-35 2035 2036 17 4.37s
Dec-35 2015 2036 72 s 4.93
Jan-36 2036 2036 1 )5.18
Feb-36 2 5 4.6920362036
Mar-36 2035 2036 3 s 4.75
Apr-36 4 5 4.0920362036
May-36 2036 2036 5 s 3.45
s 3.55Jun-36 2036 2036 6
Jul-36 2036 2036 7 s 4.20
4.20Aug-36 2036 2036 6
Sep-36 2036 2036 9 5 3.97
Oct-36 2036 2037 10 s 3.88
Nov-36 t7 S 4.4920362037
Dec-36 2036 2037 L2 S 5.38
!l**l*l
,l-'l'l
=l"l-l
,l-'l-l
9!
J sg
ni
t
.9
!
E
.J
=B
;l,il:l
;I,il:l
iE
: s-! €
,EE E E
'd --'d 'a
li5; i
=lH
rl
II"?,r!l
3
F
rl
TE"I!
g
q a
r!
EI'![l I
ll
!8"r$i
a
r!
E!"r!
rl
I!--1rt
!r
N
E
ou()durr
oN
.=ocloE
@
E
til! ![E l:lr8a38 Il, taat
ii?t ffiillu tltrIIIIIIIIIFItt t Etc!
,;;;iir,,,,
iiiiltliili
EIIIB83C88
!
II
Ilrr€,t
IIilr
iii
IiI
I
ii
Itt
It
Ii
lr
if
II
iiITriil
rrliril ilr
fi iii
fii
Iili,
I
I
I
t
III
E
dtt
ilt.I trl
iiri
iI'i
illt
I,I>9EE
U!s4.EEi
E*s
Ee:
t6
T
TtaI
*
IE
B:
8
I
Eeoo
It
i
I
EE
IHli
TH
t
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Fixed and Variable Transportation Costs
llollh$ert Plpcllnc LL('
FERC'Gcs Trillf
Fllth Rcvlsrd \-olumc \-o. I -\-lnth Revlred Slreet }o. 5
Superr.dlng
flghth Rcrlsrd Sheet No. 5
STATEMENT OF F,ATESEflectlve Rates Appllcab1e toRate Schedules TF-1,, TE-:, T1-1. ?EL-l and TII-I(Dollars per Dth)
Rate schedule and
BaseTariff Rate(1.), (3)
Minimum Maximumtype of Rate
Rate schedule TF-I (4) (5)
Reservation(Large Custcmer)
System-Wide:5 Year Evergreen Exp
0r1000
r)0000
39033
3:039
voluttetric (:)(Large customer)systen-nide:5 Year Evergreen Exp
00832
008 3:
0083:
0083:
Dollars/Dth Percent of Total
Fixed
Variable
Total
S 0.39033
0.00832
98%
2%
0.39865 100%
lntermountain Gas Company
2019-2023 rRP
Avoided Costs - Weighted Average Cost of Capital
Cost Ratio Weighting WTax benefit
Debt
Equity
Weighted Average Cost of Capital
4.94%
9.50%
50%
50%
2.5Oo/o
4.80%
1.98%
4.80%
730%6.78%
Real Discount Rate 4.68%
lnflation 2.0%