20160923AVU to Clearwater Supplemental 2 Pension in working capital.xls

Macro1
Detail
Summary
Macro1
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Recover
TableName
Dummy
201412
201501
201502
201503
201504
201505
201506
201507
201508
201509
201510
201511
201512
190150
ADFIT FAS87 UNFUNDED PENSION
CD
AA
228300
ACCUM PROV FAS106 POST RET MED
ZZ
228320
ACCUM PROV FAS87 ACCUM PEN COS
283150
FAS 106-CURRENT
228330
HRA - RETIREE
ED
ID
WA
GD
AN
283152
ADFIT FAS 106 - HRA
228335
HRA - ACTIVE EMPLOYEES
283153
ADFIT FAS 106 - HRA ACTIVE EMP
Macro1
Macro2
Macro3
Macro4
Macro5
Macro6
Macro7
Recover
Auto_Open
Ferc Acct
Ferc Acct Desc
Dec 2014 AMA
Dec 2015 AMA
System Pension & Post-Retirement Benefits
System ADFIT for Pension & Post-Retirement Benefits
System Pension & Post-Retirement Benefits, Net of ADFIT
Idaho Electric
Idaho Natural Gas
2015 AMA
Avista

-26593533.72
-26155743.85
-25691438.26
-25227132.67
-24688223.74
-24205267.32
-23722310.90
-23239354.48
-22756398.06
-25035088.96
-24575670.68
-24116252.40
-23656834.12
-24544838.77
12.00
-269412881.32
-25125183.92
2.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-769300.00
-8462300.00
-769300.00
-13367358.70
-13534149.55
-13794299.00
-14428289.03
-14632531.58
-15049638.82
-15377423.10
-15748069.97
-16124599.61
-16536971.09
-16881778.81
-15889207.66
-16104318.66
-15227733.07
-167996958.22
-14735838.68
100198144.12
98339862.12
96369029.12
98398196.12
96110695.12
94060695.12
96010695.12
93960695.12
91910695.12
93860695.12
91875841.12
89890987.12
87906133.12
94570018.75
1040788086.32
94052138.62
-7174045.75
-7181922.44
-7161172.90
-6869406.13
-6808314.19
-6711104.67
-6630701.80
-6506873.14
-6355783.81
-6204221.51
-6209376.86
-5306307.67
-5458167.76
-6521774.32
-71945185.12
-6316106.75
-1153379.61
-1167828.37
-1190854.93
-1706454.75
-1719819.22
-1720129.40
-1719343.59
-1722097.73
-1725107.84
-1930561.30
-1937716.26
-4139526.69
-4235118.53
-1947807.43
-20679440.08
-2694249.07
4381214.55
4420508.56
4481796.78
4631157.54
4679274.74
4777540.41
4854762.62
4942082.76
5030788.81
5126237.14
5206047.02
4976304.52
5026094.54
4819179.62
53126500.90
4703654.54
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-21.08
-231.88
-21.08
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-17.86
-196.46
-17.86
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
20.62
226.82
20.62
-432542.00
-432542.00
-432542.00
-432542.00
-432542.00
-432542.00
-432542.00
-432542.00
-432542.00
-540179.00
-540179.00
-540179.00
-540179.00
-463936.13
-5080873.00
-486360.50
332279.52
334135.18
329246.83
260509.93
246117.37
223215.92
204273.93
175101.32
139506.41
104425.50
105618.77
-103407.43
-68257.59
179229.56
2018743.73
132010.97
312912.08
316316.04
321740.83
443210.22
446358.74
446431.81
446246.68
446895.52
447604.67
495159.34
496815.44
1006450.89
1028576.77
498664.55
5313230.18
670744.43
55734372.17
54169317.37
52462188.15
54299930.91
52431696.92
50619882.73
52864338.64
51106519.08
49364845.37
48570176.92
46770282.42
45009543.36
43128610.45
50591684.43
Avista

($11,995,988.82)
($15,227,733.07)
91474592.79
94570018.75
-7168720.75
-6521774.32
-1073035.23
-1947807.43
4033757.90
4819179.62
-21.08
-21.08
-17.86
-17.86
20.62
20.62
-236410.17
-463936.13
75034177.40
75227929.09
330279.81
179229.56
294146.41
498664.55
-25717098.12
-26486398.12
-24544838.77
-769300.00
-769300.00
-25861971.90
-24636244.66
$49,172,205.50
$50,591,684.43
$11,252,611.76
0.71
0.32
$11,568,507.65
0.72
0.32
$2,849,997.82
0.20
0.29
$2,747,899.99
0.20
0.28