Attached files

file filename
8-K - 8-K - HAWAIIAN ELECTRIC CO INCa13-3878_18k.htm

HECO Exhibit 10

 

[HECO letterhead]

 

 

 

January 28, 2013

 

The Honorable Chair and Members

of the Hawaii Public Utilities Commission

465 South King Street

Kekuanaoa Building, First Floor

Honolulu, Hawaii 96813

 

Dear Commissioners:

 

Subject:

Docket No. 2008-0083 – Hawaiian Electric 2009 Test Year Rate Case

 

Stipulated Settlement Agreement between the Hawaiian Electric Companies and the Division of Consumer Advocacy regarding Certain Regulatory Matters

 

This letter (heretofore referred to as “Stipulated Settlement”) documents certain agreements between the Hawaiian Electric Companies1 and the Division of Consumer Advocacy of the Department of Commerce and Consumer Affairs (“Consumer Advocate”) (collectively referred to as the “Parties”) on certain regulatory matters as described below and in Exhibit 1.

 

The Parties agree to the following:

 

·                 Hawaiian Electric, HELCO and MECO will write-off, for accounting and ratemaking purposes, a total of $40 million of recorded capitalized costs in lieu of conducting the regulatory audits of the Campbell Industrial Park Combustion Turbine Unit 1 (“CIP CT-1”) and the Customer Information System (“CIS”) projects ordered in the Order Approving Consumer Advocate’s Recommendations regarding Focused Regulatory Audits, issued on May 2, 2011 in Docket No. 2008-0083.  This write-off amount is in addition to all credits received from the Hawaiian Electric Companies’ prior CIS vendor, which credits have already been used to reduce the capitalized costs of the CIS project.

·                 For purposes of accounting for the settlement, the entire write-off will be adjusted as part of the cost of the CIS project.  The write-off by company will be $29 million for Hawaiian Electric, $5.5 million for HELCO, and $5.5 million for MECO.

·                 The Hawaiian Electric Companies will include the net recoverable costs of CIP CT-1 and the CIS projects in rate base as of December 31, 2012.

 


1   The “Hawaiian Electric Companies” are Hawaiian Electric Company, Inc. (“Hawaiian Electric”), Hawaii Electric Light Company, Inc. (“HELCO”) and Maui Electric Company, Limited (“MECO”).

 



 

The Honorable Chair and Members

of the Hawaii Public Utilities Commission

January 28, 2013

Page 2

 

·                 The Hawaiian Electric Companies will include the net recoverable costs of the CIP CT-1 and the CIS projects not already included in rates as shown in Exhibit 3 in their 2013 Rate Adjustment Mechanism (“RAM”) Revenue Adjustments.  The Consumer Advocate will support RAM recovery in 2013 and the subsequent years thereafter and subsequent Hawaiian Electric, HELCO and MECO rate cases for the allowed portion of the CIP CT-1 project costs and CIS project costs in excess of the projects’ costs previously included in rate base, along with related accumulated depreciation, accumulated deferred income taxes, unamortized ITC, unamortized deferred CIS costs, the unamortized regulatory assets related to the carrying charges and deferred depreciation, as well as related project depreciation and regulatory asset amortization expenses.  Recovery of CIS costs through the RAM Revenue Adjustment mechanism is for the sole purpose of this settlement agreement and does not constitute a precedent for the recovery of software costs through the RAM Revenue Adjustment mechanism.

·                 HELCO will withdraw its 2013 test year rate case (Docket No. 2012-0099).  In lieu of the rate change HELCO would have received in the pending withdrawn rate case, the Company will submit annual RBA/RAM rate adjustment filings rolling forward the base year information from the prior HELCO rate case, Docket No. 2009-0164.  HELCO will not file a rate case until its next turn in the rate case cycle – i.e., for a 2016 test year.

·                 Hawaiian Electric will delay the filing of its 2014 test year rate case, and will file its 2014 test year rate case no earlier than January 2, 2014.  The Consumer Advocate will recommend that Hawaiian Electric be granted a waiver of Hawaii Administrative Rules (“HAR”) §6-61-87(4), that would enable Hawaiian Electric to file in 2014 a rate case application using a 2014 test year.

·                 Through calendar year 2016, the Hawaiian Electric Companies and the Consumer Advocate will recommend and support continuation of Hawaiian Electric Companies’ existing recovery mechanisms, which include the decoupling RBA and RAM, energy cost adjustment clause (“ECAC”), the Purchased Power Adjustment Clause (“PPAC”), the pension and OPEB tracking mechanisms, and the Renewable Energy Infrastructure Program (“REIP”) surcharge, in their present forms, except for the agreement for temporary acceleration of HECO’s RBA/RAM Revenue Adjustment described in the bullet below and the agreement to recover CIS costs through the RAM Revenue Adjustment described above.

·                 For only the 2014, 2015 and 2016 RAM Periods, Hawaiian Electric will be allowed to record the 2014, 2015 and 2016 RAM incremental revenues for the January 1 through December 31 calendar year (once Hawaiian Electric is able to assess the amount), and collect the RAM incremental revenues through the RBA Rate Adjustment (which includes the RAM Revenue Adjustment) from June 1 of each year to May 31 of the following year.  At the conclusion of that period, the current RAM provisions will again apply in accordance with the Amended Joint Proposal approved by the Final Decision and Order issued in the decoupling proceeding.

 



 

The Honorable Chair and Members

of the Hawaii Public Utilities Commission

January 28, 2013

Page 3

 

·                 MECO and the Consumer Advocate continue to support the Parties Stipulated Settlement in the MECO 2012 test year rate case (Docket No. 2011-0092).2  Given the other portions of this agreement, particularly in terms of the maintenance of the current financial structure and mechanisms, MECO and the Consumer Advocate even more strongly support the agreements set forth in the Parties Stipulated Settlement in the MECO 2012 test year rate case related to: (a) the rate of return on common equity used to determine the fair rate of return on rate base, (b) the ECAC, (c) the pension/OPEB tracking mechanisms, (d) decoupling and (e) the PPAC.

 

The Hawaiian Electric Companies’ customers, the Commission, the Consumer Advocate, the Hawaiian Electric Companies, and the Hawaiian Electric Companies’ investors will benefit if this Stipulated Settlement is approved.  First, with respect to the Hawaiian Electric Companies’ customers, approval of the Stipulated Settlement will reduce the CIP CT-1 and CIS investment costs that might otherwise be included in rates by $40 million, reduce revenues to be collected from customers as a result of the withdrawal of the HELCO 2013 test year rate case (with no filing of a HELCO rate case until the 2016 test year) and the delay in the filing of the Hawaiian Electric 2014 test year rate case, and prevent the further accrual of carrying costs pending the completion of the lengthy audit and post-audit process on the CIP CT-1 and CIS projects.

 

Second, the Stipulated Settlement will eliminate the need for the Commission, the Consumer Advocate and the Companies to dedicate the substantial resources, dollars and time necessary to complete the lengthy audit and post-audit process, and will allow them to focus those resources on the numerous priorities they face in improving the quality of customer service and transforming the electric utility industry in Hawaii from one based on oil-fired generation, to one based on energy efficiency and Hawaii’s indigenous renewable energy resources.

 

Third, with respect to the Hawaiian Electric Companies and their investors, approval of this Stipulated Settlement will resolve the substantial uncertainty as to when and how much of their investment in CIP CT-1 and CIS will be recovered.

 

The agreements set forth in this letter are for the purpose of simplifying and expediting the affected proceedings, and represent a negotiated compromise of the matters agreed upon, and do not constitute an admission by any party with respect to any of the matters agreed upon herein.

 


2   The Parties’ stipulated settlement is reflected in the Parties’ Stipulated Settlement Letter filed on April 20, 2012 and the Parties’ Revised Updated Stipulated Settlement Letter filed on May 14, 2012.

 



 

The Honorable Chair and Members

of the Hawaii Public Utilities Commission

January 28, 2013

Page 4

 

 

The Parties shall support and defend this Stipulated Settlement before the Commission.  If the Commission adopts an order approving all material terms of this Stipulated Settlement, the Parties will also support and defend the Commission’s order before any court or regulatory agency in which the order may be at issue.  If the Commission does not issue an order adopting all material terms of this Stipulated Settlement or makes material adjustments to this Stipulated Settlement, any or all of the Parties may withdraw from this Stipulated Settlement.  For the purposes of this Stipulated Settlement, whether a term is material shall be left to the discretion of the Party choosing to withdraw from this Stipulated Settlement.

 

 

 

 

Sincerely,

 

 

 

 

 

 

 

 

/s/ Patsy H. Nanbu

 

 

Patsy H. Nanbu

 

 

Vice President-Regulatory Affairs

 

 

Enclosure

 

cc: Division of Consumer Advocacy

 

 

Concurred:

 

/s/ Jeffrey T. Ono

 

 

 

Jeffrey T. Ono

 

 

Executive Director

 

 

Division of Consumer Advocacy

 

 

Department of Commerce and Consumer Affairs

 

 

 



 

 

Exhibit 1

 

Page 1 of 3

 

 

 

DETAILS OF CERTAIN AGREEMENTS REACHED BETWEEN

HAWAIIAN ELECTRIC AND THE CONSUMER ADVOCATE

 

Hawaiian Electric Company, Inc. (“Hawaiian Electric”), Maui Electric Company, Limited (“MECO”) and Hawaii Electric Light Company, Inc. (“HELCO”) (collectively the “Hawaiian Electric Companies” or “Companies”) will write-off for accounting and ratemaking purposes, a total of $40 million of recorded capitalized costs in lieu of regulatory audits for the Campbell Industrial Park Combustion Turbine Unit 1 (“CIP CT-1”), Customer Information System (“CIS”) projects.  This write-off amounts are in addition to all credits received from the Hawaiian Electric Companies’ prior CIS vendor, which credits have already been used to reduce the capitalized costs of the CIS project.  For purposes of accounting for the settlement, the entire write-off will be adjusted as part of the cost of the CIS project.  The write off by company will be $29 million for Hawaiian Electric, $5.5 million for HELCO, and $5.5 million for MECO, as shown in Exhibit 2.

 

Campbell Industrial Park Combustion Turbine Unit 1

 

The Parties agree that the recorded plant in service amount of $194.9 million for CIP CT-1 (and the accumulated depreciation, accumulated deferred income taxes and unamortized state investment tax credits related to the recorded costs) shall be included in Hawaiian Electric’s rate base as of December 31, 2012 and in the 2013 and succeeding Rate Adjustment Mechanism (“RAM”) Revenue Adjustments and Hawaiian Electric rate cases until the Company retires the CIP CT-1 assets.1

 

The Parties agree that the independently conducted regulatory audit for the CIP CT-1 project set forth in the Order Approving Consumer Advocate’s Recommendations Regarding Focused Regulatory Audits issued on May 2, 2011 in Docket No. 2008-0083 (“Audit Order”) should not be conducted.

 

The recorded plant in service amount for CIP CT-1 and the related accumulated depreciation, accumulated deferred income taxes and unamortized state investment tax credits and regulatory assets related to depreciation and carrying charges estimated through the effective date of the Revenue Balancing Account (“RBA”) Rate Adjustment (that includes the Rate Adjustment Mechanism (“RAM”) Revenue Adjustment for these items) shall be included in the beginning and ending balance of Hawaiian Electric’s rate base for the RAM Revenue Adjustment for 2013 and subsequent years thereafter, and for subsequent Hawaiian Electric rate cases.  See Exhibit 3.

 

Hawaiian Electric will amortize the regulatory assets, directly resulting from the deferral of depreciation and the accrual of carrying charges, over six years, beginning on the effective date of the 2013 RAM Revenue Adjustment, and to include such amortization in the 2013 RAM Revenue Adjustment.

 


1   The “Parties” to this settlement agreement are the Hawaiian Electric Companies and the Division of Consumer Advocacy of the Department of Commerce and Consumer Affairs (“Consumer Advocate”).

 



 

 

Exhibit 1

 

Page 2 of 3

 

 

 

Consistent with the agreements on CIP CT-1 in the Parties’ Stipulated Settlement Letter filed on July 5, 2011 in the Hawaiian Electric 2011 test year rate case, Docket No. 2010-0080, (“Hawaiian Electric 2011 Rate Case Settlement Agreement”), the following shall continue until the Commission has approved this settlement and the rate adjustment to include the project costs in rates (through the RAM Revenue Adjustment of the RBA) goes into effect:

·                 record the depreciation on the project costs in excess of the respective projects’ Commission approved costs to a regulatory asset; and

·                 accrue carrying charges (based on an interest rate equivalent to the Company’s AFUDC rate) on the project costs in excess of the respective projects’ Commission approved costs (net of accumulated depreciation, accumulated deferred income taxes, and unamortized ITC) and depreciation expense, which have been deferred for later recovery, to a regulatory asset.

 

The RAM Revenue Adjustment for 2013 and the subsequent years thereafter and subsequent Hawaiian Electric rate cases would reflect the additional revenue requirements related to the allowed portion of the CIP CT-1 project costs in excess of the project’s costs previously included in rate base, along with related accumulated depreciation, accumulated deferred income taxes, unamortized ITC, and including the unamortized regulatory assets related to the carrying charge and deferred depreciation, as well as related depreciation expense and amortization of regulatory asset expenses.

 

Customer Information System

 

The Parties agree that the allocable share of the deferred cost balance of CIS (which is the total deferred cost of $57.4 million for the project (after considering the credits from the prior CIS vendor), and the accrued carrying charges of $2.2 million, less a write-off of $40 million) should be included in the rate base as of December 31, 2012 of Hawaiian Electric, MECO and HELCO and recovered in the 2013 and succeeding RAM Revenue Adjustments and Hawaiian Electric Companies rate cases until the deferred costs are fully amortized.

 

The Parties agree that the independently conducted regulatory audit for the CIS project set forth in the Audit Order should not be conducted.

 

The Parties agree that reflecting the write-off entirely under the CIS docket would result in a smaller amount of depreciation expense required to be recovered in the current revenue requirements for the CIS project and CIP CT-1 project, than if the write-off amount is allocated to both the CIS project and the CIP CT-1 project.2

 

Consistent with the agreements on CIS in the Hawaiian Electric 2011 Rate Case Settlement and the Parties’ Stipulated Settlement Letter filed on April 20, 2012 in the MECO 2012 test year rate case, Docket No. 2011-0092, (“MECO 2012 Rate Case Settlement Agreement”), the

 


2   Since the CIS project would be amortized over 12 years, and the average depreciation period for the CIP CT-1 project cost is 40 years, the amortization expense savings would be greatest if the amount is amortized over the shorter period (i.e., amortization savings on $40 million over 12 years amounts to $3.33 million compared to $1.00 million over 40 years).

 



 

 

Exhibit 1

 

Page 3 of 3

 

 

 

Parties agree that the Hawaiian Electric Companies shall continue to accrue AFUDC on the recoverable CIS project deferred costs, including the expenses removed from the Hawaiian Electric 2011 test year and the MECO 2012 test year, and CIS project expenses incurred through the in-service date as agreed in the Hawaiian Electric 2011 Rate Case Settlement Agreement and the MECO 2012 Rate Case Settlement Agreement, until the Commission has approved this Stipulated Settlement and the RBA Rate Adjustment that includes the CIS project costs goes into effect.  Amortization of CIS project deferred costs would commence on the effective date of the RBA Rate Adjustment for Hawaiian Electric, MECO and HELCO that includes the recovery of the project costs and the associated amortization expense.    The Parties agree that the RAM Revenue Adjustment for 2013 and subsequent years thereafter and subsequent rate cases for Hawaiian Electric, MECO and HELCO would reflect revenue requirements related to including the deferred CIS costs that the Parties agree to be recoverable, including the estimated carrying charges through the effective date of the RBA that includes the RAM revenue adjustment for these items and the amortization expense for the amortization of the recoverable deferred costs including carrying charges, with the recovery period not to exceed the twelve year amortization period approved by the Commission in Docket No. 04-0268.  See Exhibit 3.

 

RBA/RAM Revenue Adjustment

 

The Parties agree that for only the 2014, 2015 and 2016 RAM Periods, Hawaiian Electric will be allowed to record the 2014, 2015 and 2016 incremental revenues for the January 1 through December 31 calendar year (once Hawaiian Electric is able to assess the amount), and collect the RAM incremental revenues for the calendar year through the RBA Rate Adjustment (which includes the RAM Revenue Adjustment) on customer bills from June 1 of each year to May 31 of the following year.3

 

At the conclusion of that period, the current RAM provisions will again apply in accordance with the Amended Joint Proposal approved by the Final Decision and Order issued in the decoupling proceeding

 


3   In the case when an interim order or final order in a rate case is issued, the RAM revenue adjustment would be recalculated to determine the unrecovered recorded (accrued) revenues.  For example, if in 2014, an interim decision for a 2014 test year rate case becomes effective November 1, 2014, the RAM incremental revenues for the period from January 1, 2014 to October 31, 2014 would be calculated, and compared to RAM incremental revenues collected through the RBA Rate Adjustment, and the unrecovered amount would be reflected in the RBA Rate Adjustment to be collected from November 1, 2014 through May 31, 2015.

 



 

Exhibit 2

Page 1 of 1

 

Allocation of Total CIS Deferred Costs

(in Thousands)

As of 12/31/2012

 

 

 

HECO

 

HELCO

 

MECO

 

 

Total

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIS Deferred Project Cost

 

$

41,482

 

$

8,025

 

$

7,859

 

 

$

57,366

 

 

Carrying charge since go-live

 

1,830

 

 

 

370

 

 

2,200

 

 

 

 

43,312

 

8,025

 

8,229

 

 

59,566

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Percentage

 

72.7%

 

13.5%

 

13.8%

 

 

100.0%

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Write-off amount

 

29,085

 

5,389

 

5,526

 

 

40,000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

write-off amount rounded

 

29,000

 

5,500

 

5,500

 

 

40,000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIS costs as of 12/31/12

 

$

14,312

 

$

2,525

 

$

2,729

 

 

$

19,566

 

 

 



 

Exhibit 3

Page 1 of 2

 

CIP CT-1 Costs in 2013 RAM Calculations

 

Recoverable Costs:

 

 

 

 

 

 

 

 

 

 

Rate Base RAM

 

 

 

 

 

 

 

 

 

 

 

 

Rate Base

 

 

Rate Base

 

 

 

 

 

 

 

 

 

 

 

 

 

12/31/2012

 

 

12/31/2013

 

 

CIP CT-1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Plant In service

 

$194,929,577

 

 

 

 

 

 

 

 

$194,929,577

 

 

$194,929,577

 

 

Accumulated Depreciation

 

(10,379,709

)

 

 

 

 

 

 

 

(10,379,709

)

 

(15,060,387

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Net Plant in Sevice as of 12/31/2012

 

$184,549,868

 

 

 

 

 

 

 

 

$184,549,868

 

 

$179,869,190

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Deferral Cost

 

 

 

 

 

 

 

 

 

 

 

 

Additional

 

 

 

 

 

 

 

 

 

 

 

 

To

 

Through

 

To

 

 

 

 

 

 

 

Deferred CIP CT-1 costs

 

12/31/2012

 

5/31/2013

 

5/31/2013

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Depreciation deferral

 

 $

1,165,412

 

 

 $

342,530

 

 

 $

1,507,942

 

 

a

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ADIT deferral

 

(2,903,781

)

 

(363,200

)

 

(3,266,981

)

 

a

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Unamortized State ITC deferral

 

(42,990

)

 

395

 

 

(42,595

)

 

a

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Carrying Charge (AFUDC)

 

3,380,907

 

 

989,370

 

 

4,370,277

 

 

a

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Deferrred costs

 

 $

1,599,548

 

 

 $

969,095

 

 

 $

2,568,643

 

 

  $

2,568,643

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Additional annual amortization expense (deferred costs / 6 years)

 

 

428,107

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Actual amortization expense (7/12 of annual amount)

 

 

 

 

 

249,729

 

 

 

 

 

 $

2,318,914

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Depreciation Expense

 

 

 

 

 

 

 

 $

4,680,678

 

 a

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

a   Per Workpapers for Exhibit 3 CT-1.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



 

Exhibit 3

Page 2 of 2

 

CIS in 2013 RAM Calculations

 

Recoverable Costs:

 

 

 

 

 

 

 

 

 

Rate Base RAM

 

 

 

 

 

 

 

 

 

 

 

 

Rate Base

 

Rate Base

 

 

 

 

 

 

 

 

 

 

 

 

12/31/2012

 

12/31/2013

 

CIS

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

HECO

 

HELCO

 

MECO

 

Total

 

 

 

 

 

 

Total deferred cost

 

 

 

 

 

 

 

 

 

 

 

 

 

 

as of 12/31/2012 per Settlement

 

14,312

 

2,525

 

2,729

 

19,566

b

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Carrying charge (AFUDC)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

January 1-May 31, 2013

 

454

 

78

 

82

 

614

c

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIS deferred costs recoverable

 

14,766

 

2,603

 

2,811

 

20,180

 

20,180

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Additional amortization expense

 

1,231

 

217

 

234

 

1,682

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Amoritzation in 2013 RAM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(7/12 of annual amortization)

 

718

 

127

 

137

 

981

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIS deferred costs as of 12/31/2013

 

14,048

 

2,476

 

2,674

 

19,199

 

 

 

19,199

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

b

See Exhibit 2.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

c

See Workpapers for Exhibit 3 CIS, p.1.

 

 

 

 

 

 

 

 

 

 

 

 

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 1 of 10

 

CIP CT-1

As of December 31, 2012 (Estimated as of 1/16/2013)

 

 

 

Before Settlement Discussions

 

 

 

 

 

 

 

 

Before exclusion

 

Deferred

 

 

 

 

 

 

Plant In service

 

194,929,577

 

 

 

 

 

 

 

 

 

 

Accumulated Depreciation

 

(10,379,709

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Net Plant in Sevice

 

184,549,868

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Amount included in rates

 

163,280,000

 

 

a/o 12/31/12

 

Jan - May 2013

 

a/0 5/31/13

 

 

 

 

 

 

 

 

 

 

 

 

 

CT-1 Plant in service

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

Accumulated Depreciation

 

 

 

 

(1,810,383

)

 

(342,531

)

 

(2,152,914

)

 

 

 

 

 

 

 

 

 

 

 

-

 

Depreciation deferral

 

 

 

 

1,165,412

 

 

342,530

 

 

1,507,942

 

 

 

 

 

 

 

 

 

 

 

 

-

 

ADIT deferral

 

 

 

 

(2,903,781

)

 

(363,200

)

 

(3,266,981

)

 

 

 

 

 

 

 

 

 

 

 

-

 

Unamortized State ITC deferral

 

 

 

 

(42,990

)

 

395

 

 

(42,595

)

 

 

 

 

 

 

 

 

 

 

 

-

 

Carrying Charge (AFUDC)

 

 

 

 

3,380,907

 

 

 

989,370

 

 

 

4,370,277

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Deferred Balance 12/31/12

 

 

31,438,742

 

 

626,564

 

 

32,065,306

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 2 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

  Jun 2011

 

 

 

 

 

  Jul 2011

 

 

 

 

 

  Aug 2011

 

 

 

 

 

  Sep 2011

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  CIP CT-1

 

 

  Change

 

 

  CIP CT-1

 

 

  Change

 

 

  CIP CT-1

 

 

  Change

 

 

  CIP CT-1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost

 

195,050,054

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

(303,711

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

194,746,343

 

 

 

 

 

194,746,343

 

 

 

 

 

194,751,036

 

 

 

 

 

194,753,563

 

 

Current Month’s Capital Costs

 

-    

 

 

 

 

 

4,693

 

 

 

 

 

2,527

 

 

 

 

 

17,186

 

 

Ending Month’s Capital Costs

 

194,746,343

 

 

 

 

 

194,751,036

 

 

 

 

 

194,753,563

 

 

 

 

 

194,770,749

 

 

Amount included in rates

 

163,279,651

 

 

 

 

 

163,279,651

 

 

 

 

 

163,279,651

 

 

 

 

 

163,279,651

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,466,692

 

 

 

 

 

31,471,385

 

 

 

 

 

31,473,912

 

 

 

 

 

31,491,098

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,466,692

 

 

4,693

 

 

31,471,385

 

 

2,527

 

 

31,473,912

 

 

17,186

 

 

31,491,098

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(644,967

)

 

(38,826

)

 

(683,793

)

 

(65,970

)

 

(749,762

)

 

(65,966

)

 

(815,728

)

 

(-) Less:

related ADIT

 

(2,830,330

)

 

(174,576

)

 

(3,004,907

)

 

(83,933

)

 

(3,088,840

)

 

(502,933

)

 

(3,591,773

)

 

(-) Less:

related unamortized ITC

 

(44,389

)

 

111

 

 

(44,278

)

 

70

 

 

(44,208

)

 

70

 

 

(44,138

)

 

(+) Add:

regulatory asset - depreciation expense

 

 

 

 

38,826

 

 

38,826

 

 

65,967

 

 

104,792

 

 

65,966

 

 

170,758

 

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

 

 

 

-    

 

 

-    

 

 

182,246

 

 

182,246

 

 

182,021

 

 

364,267

 

 

(=) Equals:

Total base for calculating carrying charge

 

27,947,006

 

 

(169,772

)

 

27,777,233

 

 

100,907

 

 

27,878,141

 

 

(303,656

)

 

27,574,484

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

 

 

 

 

 

 

27,862,119

 

 

 

 

 

27,827,687

 

 

 

 

 

27,726,312

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

 

 

 

 

 

 

0.006541

 

 

 

 

 

0.006541

 

 

 

 

 

0.006541

 

 

(=) Equals:

Monthly carrying charge

 

 

 

 

 

 

 

182,246

 

 

 

 

 

182,021

 

 

 

 

 

181,358

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

 

 

 

 

 

 

54,331

 

 

 

 

 

54,264

 

 

 

 

 

54,066

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

 

 

 

 

 

 

127,915

 

 

 

 

 

127,757

 

 

 

 

 

127,292

 

 

Total AFUDC (as calculated)

 

 

 

 

 

 

 

182,246

 

 

 

 

 

182,021

 

 

 

 

 

181,358

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

 

 

 

 

 

 

-    

 

 

 

 

 

(901

)

 

 

 

 

(1,279

)

 

AFUDC - Equity (prior adjustment)

 

 

 

 

 

 

 

-    

 

 

 

 

 

(2,121

)

 

 

 

 

(3,434

)

 

Prior months adjustments that should be recorded

 

 

 

 

 

 

 

-    

 

 

 

 

 

(3,022

)

 

 

 

 

(4,713

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

 

 

 

 

 

 

54,331

 

 

 

 

 

53,363

 

 

 

 

 

52,787

 

 

AFUDC - Equity (revised adjustment)

 

 

 

 

 

 

 

127,915

 

 

 

 

 

125,636

 

 

 

 

 

123,857

 

 

Revised Total AFUDC (that should be recorded)

 

 

 

 

 

 

 

182,246

 

 

 

 

 

178,999

 

 

 

 

 

176,645

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

 

 

 

 

 

 

55,232

 

 

 

 

 

54,642

 

 

 

 

 

52,589

 

 

AFUDC - Equity (what was recorded)

 

 

 

 

 

 

 

130,036

 

 

 

 

 

129,070

 

 

 

 

 

123,391

 

 

Total Recorded AFUDC (via JE) during the month

 

 

 

 

 

 

 

185,268

 

 

 

 

 

183,712

 

 

 

 

 

175,980

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

 

 

 

 

 

 

(901

)

 

 

 

 

(1,279

)

 

 

 

 

198

 

 

AFUDC - Equity (adjustment for following month)

 

 

 

 

 

 

 

(2,121

)

 

 

 

 

(3,434

)

 

 

 

 

466

 

 

Adjustment that should be reflected on the following month

 

 

 

 

 

 

 

(3,022

)

 

 

 

 

(4,713

)

 

 

 

 

665

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

 

 

 

 

 

 

69,210

 

 

 

 

 

69,124

 

 

 

 

 

68,872

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

 

 

 

 

 

 

 

 

 

 

 

 

69,210

 

 

 

 

 

138,333

 

 

True-Up AFUDC - Debt (that should be recorded)

 

 

 

 

 

 

 

69,210

 

 

 

 

 

138,333

 

 

 

 

 

207,206

 

 

True-Up AFUDC - Debt (what was recorded))

 

 

 

 

 

 

 

-    

 

 

 

 

 

-    

 

 

 

 

 

207,198

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

 

 

 

 

 

 

69,210

 

 

 

 

 

138,333

 

 

 

 

 

8

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

  Jun-11

 

 

 

 

 

  Jul-11

 

 

 

 

 

  Aug-11

 

 

 

 

 

  Sep-11

 

 

7,676,961

 

P0001050

 

127,256

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

3,801,520

 

P0001051

 

2,035

 

3,803,555

 

 

4,693

 

 

3,808,248

 

 

-    

 

 

3,808,248

 

 

-    

 

 

3,808,248

 

 

603,567

 

P0001052

 

2,595

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

1,809,875

 

P0001084

 

-    

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

668,194

 

P0001134

 

-    

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

753,115

 

P0001135

 

-    

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

1,795,941

 

P0001136

 

137,896

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

212,405

 

P0001137

 

39,682

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

4,857,924

 

P0001340

 

-    

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

1,261,761

 

P0001585

 

-    

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

3,046,322

 

P0001880

 

-    

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

7,107,036

 

P0001881

 

-    

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

161,127,436

 

P4900000

 

18,533

 

161,145,969

 

 

-    

 

 

161,145,969

 

 

2,527

 

 

161,148,496

 

 

17,186

 

 

161,165,682

 

 

 

 

Less (NR/NE Cost)

 

(303,711

)

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

194,722,057

 

 

 

24,286

 

194,746,343

 

 

4,693

 

 

194,751,036

 

 

2,527

 

 

194,753,563

 

 

17,186

 

 

194,770,749

 

 

(1,809,875)

 

 

 

 

 

 

 

 

4,693

 

 

 

 

 

2,527

 

 

 

 

 

17,186

 

 

(1,809,875

)

 

192,912,182

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

192,960,874

 

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 3 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

 

 

 

  Oct 2011

 

 

 

 

 

  Nov 2011

 

 

 

 

 

  Dec 2011

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  Change

 

 

  CIP CT-1

 

 

  Change

 

 

  CIP CT-1

 

 

  Change

 

 

  CIP CT-1

 

 

  Change

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

 

 

 

194,770,749

 

 

 

 

 

194,773,708

 

 

 

 

 

194,929,577

 

 

 

 

 

Current Month’s Capital Costs

 

 

 

 

2,958

 

 

 

 

 

155,869

 

 

 

 

 

-    

 

 

 

 

 

Ending Month’s Capital Costs

 

 

 

 

194,773,708

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

Amount included in rates

 

 

 

 

163,279,651

 

 

 

 

 

163,279,651

 

 

 

 

 

163,280,000

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

 

 

 

31,494,057

 

 

 

 

 

31,649,926

 

 

 

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

2,958

 

 

31,494,057

 

 

155,869

 

 

31,649,926

 

 

(349

)

 

31,649,577

 

 

-    

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(65,966

)

 

(881,694

)

 

(65,966

)

 

(947,660

)

 

(65,966

)

 

(1,013,626

)

 

(43,189

)

 

(-) Less:

related ADIT

 

(27

)

 

(3,591,800

)

 

208,347

 

 

(3,383,453

)

 

(27

)

 

(3,383,480

)

 

1,278,802

 

 

(-) Less:

related unamortized ITC

 

70

 

 

(44,068

)

 

69

 

 

(43,999

)

 

70

 

 

(43,929

)

 

(78

)

 

(+) Add:

regulatory asset - depreciation expense

 

65,967

 

 

236,725

 

 

65,966

 

 

302,691

 

 

65,967

 

 

368,658

 

 

43,188

 

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

181,358

 

 

545,625

 

 

180,968

 

 

726,592

 

 

183,354

 

 

909,946

 

 

185,736

 

 

(=) Equals:

Total base for calculating carrying charge

 

184,360

 

 

27,758,844

 

 

545,253

 

 

28,304,097

 

 

183,049

 

 

28,487,146

 

 

1,464,459

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

 

 

 

27,666,664

 

 

 

 

 

28,031,471

 

 

 

 

 

28,395,621

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

 

 

 

0.006541

 

 

 

 

 

0.006541

 

 

 

 

 

0.006541

 

 

 

 

 

(=) Equals:

Monthly carrying charge

 

 

 

 

180,968

 

 

 

 

 

183,354

 

 

 

 

 

185,736

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

 

 

 

53,950

 

 

 

 

 

54,661

 

 

 

 

 

55,371

 

 

 

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

 

 

 

127,018

 

 

 

 

 

128,692

 

 

 

 

 

130,364

 

 

 

 

 

Total AFUDC (as calculated)

 

 

 

 

180,968

 

 

 

 

 

183,354

 

 

 

 

 

185,736

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

 

 

 

198

 

 

 

 

 

14

 

 

 

 

 

(517

)

 

 

 

 

AFUDC - Equity (prior adjustment)

 

 

 

 

466

 

 

 

 

 

34

 

 

 

 

 

(1,217

)

 

 

 

 

Prior months adjustments that should be recorded

 

 

 

 

665

 

 

 

 

 

48

 

 

 

 

 

(1,735

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

 

 

 

54,148

 

 

 

 

 

54,676

 

 

 

 

 

54,854

 

 

 

 

 

AFUDC - Equity (revised adjustment)

 

 

 

 

127,484

 

 

 

 

 

128,727

 

 

 

 

 

129,147

 

 

 

 

 

Revised Total AFUDC (that should be recorded)

 

 

 

 

181,632

 

 

 

 

 

183,402

 

 

 

 

 

184,001

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

 

 

 

54,134

 

 

 

 

 

55,193

 

 

 

 

 

54,452

 

 

 

 

 

AFUDC - Equity (what was recorded)

 

 

 

 

127,450

 

 

 

 

 

129,944

 

 

 

 

 

128,200

 

 

 

 

 

Total Recorded AFUDC (via JE) during the month

 

 

 

 

181,584

 

 

 

 

 

185,137

 

 

 

 

 

182,652

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

 

 

 

14

 

 

 

 

 

(517

)

 

 

 

 

402

 

 

 

 

 

AFUDC - Equity (adjustment for following month)

 

 

 

 

34

 

 

 

 

 

(1,217

)

 

 

 

 

947

 

 

 

 

 

Adjustment that should be reflected on the following month

 

 

 

 

48

 

 

 

 

 

(1,735

)

 

 

 

 

1,349

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

 

 

 

68,724

 

 

 

 

 

69,630

 

 

 

 

 

70,535

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

 

 

 

8

 

 

 

 

 

1

 

 

 

 

 

(3

)

 

 

 

 

True-Up AFUDC - Debt (that should be recorded)

 

 

 

 

68,732

 

 

 

 

 

69,631

 

 

 

 

 

70,532

 

 

 

 

 

True-Up AFUDC - Debt (what was recorded))

 

 

 

 

68,731

 

 

 

 

 

69,634

 

 

 

 

 

70,019

 

 

 

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

 

 

 

1

 

 

 

 

 

(3

)

 

 

 

 

513

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

 

 

 

  Oct-11

 

 

 

 

 

  Nov-11

 

 

 

 

 

  Dec-11

 

 

 

 

 

7,676,961

 

P0001050

 

127,256

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

3,801,520

 

P0001051

 

2,035

 

603

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

603,567

 

P0001052

 

2,595

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

1,809,875

 

P0001084

 

-    

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

668,194

 

P0001134

 

-    

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

753,115

 

P0001135

 

-    

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

1,795,941

 

P0001136

 

137,896

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

212,405

 

P0001137

 

39,682

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

4,857,924

 

P0001340

 

-    

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

1,261,761

 

P0001585

 

-    

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

3,046,322

 

P0001880

 

-    

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

7,107,036

 

P0001881

 

-    

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

161,127,436

 

P4900000

 

18,533

 

2,355

 

 

161,168,037

 

 

155,869

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

 

 

Less (NR/NE Cost)

 

(303,711

)

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

194,722,057

 

 

 

24,286

 

2,958

 

 

194,773,707

 

 

155,869

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

(1,809,875)

 

 

 

 

 

2,958

 

 

(1,809,875

)

 

155,869

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

192,912,182

 

 

 

 

 

 

 

 

192,963,832

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 4 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

Jan 2012

 

 

 

 

 

Feb 2012

 

 

 

 

 

Mar 2012

 

 

 

 

 

Apr 2012

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

Current Month’s Capital Costs

 

-    

 

 

 

 

 

-    

 

 

 

 

 

-    

 

 

 

 

 

-    

 

 

Ending Month’s Capital Costs

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

Amount included in rates

 

163,280,000

 

 

 

 

 

163,280,000

 

 

 

 

 

163,280,000

 

 

 

 

 

163,280,000

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(1,056,815

)

 

(68,506

)

 

(1,125,321

)

 

(68,506

)

 

(1,193,827

)

 

(68,506

)

 

(1,262,333

)

 

(-) Less:

related ADIT

 

(2,104,678

)

 

(72,701

)

 

(2,177,379

)

 

(72,639

)

 

(2,250,018

)

 

(72,642

)

 

(2,322,660

)

 

(-) Less:

related unamortized ITC

 

(44,007

)

 

234

 

 

(43,773

)

 

79

 

 

(43,694

)

 

78

 

 

(43,616

)

 

(+) Add:

regulatory asset - depreciation expense

 

411,846

 

 

68,506

 

 

480,352

 

 

68,506

 

 

548,858

 

 

68,506

 

 

617,364

 

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

1,095,682

 

 

187,676

 

 

1,283,358

 

 

192,749

 

 

1,476,107

 

 

193,505

 

 

1,669,612

 

 

(=) Equals:

Total base for calculating carrying charge

 

29,951,605

 

 

115,209

 

 

30,066,814

 

 

120,189

 

 

30,187,003

 

 

120,941

 

 

30,307,944

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

29,219,375

 

 

 

 

 

30,009,209

 

 

 

 

 

30,126,908

 

 

 

 

 

30,247,473

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

0.006423

 

 

 

 

 

0.006423

 

 

 

 

 

0.006423

 

 

 

 

 

0.006423

 

 

(=) Equals:

Monthly carrying charge

 

187,676

 

 

 

 

 

192,749

 

 

 

 

 

193,505

 

 

 

 

 

194,280

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

59,023

 

 

 

 

 

60,619

 

 

 

 

 

60,856

 

 

 

 

 

61,100

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

128,653

 

 

 

 

 

132,131

 

 

 

 

 

132,649

 

 

 

 

 

133,180

 

 

Total AFUDC (as calculated)

 

187,676

 

 

 

 

 

192,749

 

 

 

 

 

193,505

 

 

 

 

 

194,280

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

402

 

 

 

 

 

0

 

 

 

 

 

(0

)

 

 

 

 

(719

)

 

AFUDC - Equity (prior adjustment)

 

947

 

 

 

 

 

(0

)

 

 

 

 

0

 

 

 

 

 

(1,567

)

 

Prior months adjustments that should be recorded

 

1,349

 

 

 

 

 

0

 

 

 

 

 

0

 

 

 

 

 

(2,286

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

59,425

 

 

 

 

 

60,619

 

 

 

 

 

60,856

 

 

 

 

 

60,381

 

 

AFUDC - Equity (revised adjustment)

 

129,600

 

 

 

 

 

132,130

 

 

 

 

 

132,649

 

 

 

 

 

131,613

 

 

Revised Total AFUDC (that should be recorded)

 

189,025

 

 

 

 

 

192,749

 

 

 

 

 

193,505

 

 

 

 

 

191,994

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

59,425

 

 

 

 

 

60,619

 

 

 

 

 

61,575

 

 

 

 

 

60,381

 

 

AFUDC - Equity (what was recorded)

 

129,600

 

 

 

 

 

132,130

 

 

 

 

 

134,216

 

 

 

 

 

131,613

 

 

Total Recorded AFUDC (via JE) during the month

 

189,025

 

 

 

 

 

192,749

 

 

 

 

 

195,791

 

 

 

 

 

191,994

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

0

 

 

 

 

 

(0

)

 

 

 

 

(719

)

 

 

 

 

0

 

 

AFUDC - Equity (adjustment for following month)

 

(0

)

 

 

 

 

0

 

 

 

 

 

(1,567

)

 

 

 

 

(0

)

 

Adjustment that should be reflected on the following month

 

0

 

 

 

 

 

0

 

 

 

 

 

(2,286

)

 

 

 

 

(0

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

69,133

 

 

 

 

 

71,002

 

 

 

 

 

71,280

 

 

 

 

 

71,566

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

513

 

 

 

 

 

(0

)

 

 

 

 

0

 

 

 

 

 

(842

)

 

True-Up AFUDC - Debt (that should be recorded)

 

69,646

 

 

 

 

 

71,001

 

 

 

 

 

71,281

 

 

 

 

 

70,723

 

 

True-Up AFUDC - Debt (what was recorded))

 

69,646

 

 

 

 

 

71,001

 

 

 

 

 

72,123

 

 

 

 

 

70,723

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

(0

)

 

 

 

 

0

 

 

 

 

 

(842

)

 

 

 

 

0

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

  Jan-12

 

 

 

 

 

  Feb-12

 

 

 

 

 

  Mar-12

 

 

 

 

 

  Apr-12

 

 

7,676,961

 

P0001050

 

127,256

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

3,801,520

 

P0001051

 

2,035

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

603,567

 

P0001052

 

2,595

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

1,809,875

 

P0001084

 

-    

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

668,194

 

P0001134

 

-    

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

753,115

 

P0001135

 

-    

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

1,795,941

 

P0001136

 

137,896

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

212,405

 

P0001137

 

39,682

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

4,857,924

 

P0001340

 

-    

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

1,261,761

 

P0001585

 

-    

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

3,046,322

 

P0001880

 

-    

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

7,107,036

 

P0001881

 

-    

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

161,127,436

 

P4900000

 

18,533

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

 

 

Less (NR/NE Cost)

 

(303,711

)

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

194,722,057

 

 

 

24,286

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

(1,809,875)

 

 

 

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

192,912,182

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 5 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

 

 

 

May 2012

 

 

 

 

 

Jun 2012

 

 

 

 

 

Jul 2012

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

Current Month’s Capital Costs

 

 

 

 

-    

 

 

 

 

 

-    

 

 

 

 

 

-    

 

 

 

 

 

Ending Month’s Capital Costs

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

Amount included in rates

 

 

 

 

163,280,000

 

 

 

 

 

163,280,000

 

 

 

 

 

163,280,000

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

-    

 

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

-    

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(68,506

)

 

(1,330,840

)

 

(68,506

)

 

(1,399,346

)

 

(68,506

)

 

(1,467,852

)

 

(68,506

)

 

(-) Less:

related ADIT

 

(72,639

)

 

(2,395,299

)

 

(72,641

)

 

(2,467,940

)

 

(72,640

)

 

(2,540,580

)

 

(72,641

)

 

(-) Less:

related unamortized ITC

 

78

 

 

(43,538

)

 

78

 

 

(43,460

)

 

78

 

 

(43,382

)

 

79

 

 

(+) Add:

regulatory asset - depreciation expense

 

68,506

 

 

685,870

 

 

68,506

 

 

754,376

 

 

68,506

 

 

822,882

 

 

68,506

 

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

194,280

 

 

1,863,892

 

 

195,059

 

 

2,058,951

 

 

195,843

 

 

2,254,794

 

 

196,632

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(=) Equals:

Total base for calculating carrying charge

 

121,718

 

 

30,429,662

 

 

122,496

 

 

30,552,158

 

 

123,281

 

 

30,675,439

 

 

124,070

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

 

 

 

30,368,803

 

 

 

 

 

30,490,910

 

 

 

 

 

30,613,798

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

 

 

 

0.006423

 

 

 

 

 

0.006423

 

 

 

 

 

0.006423

 

 

 

 

 

(=) Equals:

Monthly carrying charge

 

 

 

 

195,059

 

 

 

 

 

195,843

 

 

 

 

 

196,632

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

 

 

 

61,345

 

 

 

 

 

61,592

 

 

 

 

 

61,840

 

 

 

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

 

 

 

133,714

 

 

 

 

 

134,251

 

 

 

 

 

134,793

 

 

 

 

 

Total AFUDC (as calculated)

 

 

 

 

195,059

 

 

 

 

 

195,843

 

 

 

 

 

196,632

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

 

 

 

0

 

 

 

 

 

692

 

 

 

 

 

2,149

 

 

 

 

 

AFUDC - Equity (prior adjustment)

 

 

 

 

(0

)

 

 

 

 

1,510

 

 

 

 

 

4,685

 

 

 

 

 

Prior months adjustments that should be recorded

 

 

 

 

(0

)

 

 

 

 

2,202

 

 

 

 

 

6,834

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

 

 

 

61,345

 

 

 

 

 

62,284

 

 

 

 

 

63,989

 

 

 

 

 

AFUDC - Equity (revised adjustment)

 

 

 

 

133,714

 

 

 

 

 

135,761

 

 

 

 

 

139,478

 

 

 

 

 

Revised Total AFUDC (that should be recorded)

 

 

 

 

195,059

 

 

 

 

 

198,045

 

 

 

 

 

203,466

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

 

 

 

60,653

 

 

 

 

 

60,135

 

 

 

 

 

60,237

 

 

 

 

 

AFUDC - Equity (what was recorded)

 

 

 

 

132,204

 

 

 

 

 

131,076

 

 

 

 

 

131,300

 

 

 

 

 

Total Recorded AFUDC (via JE) during the month

 

 

 

 

192,857

 

 

 

 

 

191,211

 

 

 

 

 

191,537

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

 

 

 

692

 

 

 

 

 

2,149

 

 

 

 

 

3,752

 

 

 

 

 

AFUDC - Equity (adjustment for following month)

 

 

 

 

1,510

 

 

 

 

 

4,685

 

 

 

 

 

8,178

 

 

 

 

 

Adjustment that should be reflected on the following month

 

 

 

 

2,202

 

 

 

 

 

6,834

 

 

 

 

 

11,929

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

 

 

 

71,853

 

 

 

 

 

72,141

 

 

 

 

 

72,432

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

 

 

 

0

 

 

 

 

 

812

 

 

 

 

 

2,518

 

 

 

 

 

True-Up AFUDC - Debt (that should be recorded)

 

 

 

 

71,853

 

 

 

 

 

72,953

 

 

 

 

 

74,950

 

 

 

 

 

True-Up AFUDC - Debt (what was recorded))

 

 

 

 

71,041

 

 

 

 

 

70,435

 

 

 

 

 

70,556

 

 

 

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

 

 

 

812

 

 

 

 

 

2,518

 

 

 

 

 

4,394

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

 

 

 

May-12

 

 

 

 

 

Jun-12

 

 

 

 

 

Jul-12

 

 

 

 

 

7,676,961

 

P0001050

 

127,256

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

3,801,520

 

P0001051

 

2,035

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

603,567

 

P0001052

 

2,595

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

1,809,875

 

P0001084

 

-    

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

668,194

 

P0001134

 

-    

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

753,115

 

P0001135

 

-    

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

1,795,941

 

P0001136

 

137,896

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

212,405

 

P0001137

 

39,682

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

4,857,924

 

P0001340

 

-    

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

1,261,761

 

P0001585

 

-    

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

3,046,322

 

P0001880

 

-    

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

7,107,036

 

P0001881

 

-    

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

161,127,436

 

P4900000

 

18,533

 

-    

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

 

 

Less (NR/NE Cost)

 

(303,711

)

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

194,722,057

 

 

 

24,286

 

-    

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

(1,809,875)

 

 

 

 

 

-    

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

192,912,182

 

 

 

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 6 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

Aug 2012

 

 

 

 

 

Sep 2012

 

 

 

 

 

Oct 2012

 

 

 

 

 

Nov 2012

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Change

 

 

CIP CT-1

 

 

Total Project Cost

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

Current Month’s Capital Costs

 

-    

 

 

 

 

 

-    

 

 

 

 

 

-    

 

 

 

 

 

-    

 

 

Ending Month’s Capital Costs

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

 

 

 

194,929,577

 

 

Amount included in rates

 

163,280,000

 

 

 

 

 

163,280,000

 

 

 

 

 

163,280,000

 

 

 

 

 

163,280,000

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

-    

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(1,536,358

)

 

(68,506

)

 

(1,604,864

)

 

(68,506

)

 

(1,673,370

)

 

(68,506

)

 

(1,741,877

)

 

(-) Less:

related ADIT

 

(2,613,221

)

 

(72,639

)

 

(2,685,860

)

 

(72,640

)

 

(2,758,500

)

 

(72,641

)

 

(2,831,141

)

 

(-) Less:

related unamortized ITC

 

(43,303

)

 

78

 

 

(43,225

)

 

78

 

 

(43,147

)

 

78

 

 

(43,069

)

 

(+) Add:

regulatory asset - depreciation expense

 

891,388

 

 

68,506

 

 

959,894

 

 

68,506

 

 

1,028,400

 

 

68,506

 

 

1,096,906

 

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

2,451,426

 

 

184,517

 

 

2,635,943

 

 

185,225

 

 

2,821,169

 

 

185,900

 

 

3,007,069

 

 

(=) Equals:

Total base for calculating carrying charge

 

30,799,509

 

 

111,956

 

 

30,911,465

 

 

112,663

 

 

31,024,128

 

 

113,337

 

 

31,137,465

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

30,737,474

 

 

 

 

 

30,855,487

 

 

 

 

 

30,967,796

 

 

 

 

 

31,080,796

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

0.006003

 

 

 

 

 

0.006003

 

 

 

 

 

0.006003

 

 

 

 

 

0.006003

 

 

(=) Equals:

Monthly carrying charge

 

184,517

 

 

 

 

 

185,225

 

 

 

 

 

185,900

 

 

 

 

 

186,578

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

54,805

 

 

 

 

 

55,015

 

 

 

 

 

55,216

 

 

 

 

 

55,417

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

129,712

 

 

 

 

 

130,210

 

 

 

 

 

130,684

 

 

 

 

 

131,161

 

 

Total AFUDC (as calculated)

 

184,517

 

 

 

 

 

185,225

 

 

 

 

 

185,900

 

 

 

 

 

186,578

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

3,752

 

 

 

 

 

5,297

 

 

 

 

 

6,973

 

 

 

 

 

8,782

 

 

AFUDC - Equity (prior adjustment)

 

8,178

 

 

 

 

 

11,835

 

 

 

 

 

15,802

 

 

 

 

 

20,081

 

 

Prior months adjustments that should be recorded

 

11,929

 

 

 

 

 

17,131

 

 

 

 

 

22,775

 

 

 

 

 

28,863

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

58,557

 

 

 

 

 

60,312

 

 

 

 

 

62,189

 

 

 

 

 

64,199

 

 

AFUDC - Equity (revised adjustment)

 

137,890

 

 

 

 

 

142,045

 

 

 

 

 

146,486

 

 

 

 

 

151,242

 

 

Revised Total AFUDC (that should be recorded)

 

196,446

 

 

 

 

 

202,357

 

 

 

 

 

208,675

 

 

 

 

 

215,441

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

53,260

 

 

 

 

 

53,339

 

 

 

 

 

53,407

 

 

 

 

 

64,199

 

 

AFUDC - Equity (what was recorded)

 

126,055

 

 

 

 

 

126,243

 

 

 

 

 

126,405

 

 

 

 

 

151,242

 

 

Total Recorded AFUDC (via JE) during the month

 

179,315

 

 

 

 

 

179,582

 

 

 

 

 

179,812

 

 

 

 

 

215,441

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

5,297

 

 

 

 

 

6,973

 

 

 

 

 

8,782

 

 

 

 

 

(0

)

 

AFUDC - Equity (adjustment for following month)

 

11,835

 

 

 

 

 

15,802

 

 

 

 

 

20,081

 

 

 

 

 

(0

)

 

Adjustment that should be reflected on the following month

 

17,131

 

 

 

 

 

22,775

 

 

 

 

 

28,863

 

 

 

 

 

(0

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

51,460

 

 

 

 

 

51,658

 

 

 

 

 

51,846

 

 

 

 

 

52,035

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

4,394

 

 

 

 

 

5,845

 

 

 

 

 

7,419

 

 

 

 

 

9,117

 

 

True-Up AFUDC - Debt (that should be recorded)

 

55,855

 

 

 

 

 

57,503

 

 

 

 

 

59,265

 

 

 

 

 

61,152

 

 

True-Up AFUDC - Debt (what was recorded))

 

50,010

 

 

 

 

 

50,084

 

 

 

 

 

50,148

 

 

 

 

 

61,152

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

5,845

 

 

 

 

 

7,419

 

 

 

 

 

9,117

 

 

 

 

 

(0

)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

Aug-12

 

 

 

 

 

Sep-12

 

 

 

 

 

Oct-12

 

 

 

 

 

Nov-12

 

 

7,676,961

 

P0001050

 

127,256

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

-    

 

 

7,804,217

 

 

3,801,520

 

P0001051

 

2,035

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

-    

 

 

3,808,851

 

 

603,567

 

P0001052

 

2,595

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

-    

 

 

606,162

 

 

1,809,875

 

P0001084

 

-    

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

-    

 

 

1,809,875

 

 

668,194

 

P0001134

 

-    

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

-    

 

 

668,194

 

 

753,115

 

P0001135

 

-    

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

-    

 

 

753,115

 

 

1,795,941

 

P0001136

 

137,896

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

-    

 

 

1,933,837

 

 

212,405

 

P0001137

 

39,682

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

-    

 

 

252,087

 

 

4,857,924

 

P0001340

 

-    

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

-    

 

 

4,857,924

 

 

1,261,761

 

P0001585

 

-    

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

-    

 

 

1,261,761

 

 

3,046,322

 

P0001880

 

-    

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

-    

 

 

3,046,322

 

 

7,107,036

 

P0001881

 

-    

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

-    

 

 

7,107,036

 

 

161,127,436

 

P4900000

 

18,533

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

-    

 

 

161,323,906

 

 

 

 

Less (NR/NE Cost)

 

(303,711

)

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

-    

 

 

(303,711

)

 

194,722,057

 

 

 

24,286

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

-    

 

 

194,929,576

 

 

(1,809,875)

 

 

 

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

-    

 

 

(1,809,875

)

 

192,912,182

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 

 

 

193,119,701

 

 

 



 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 7 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

 

 

Dec 2012

 

 

 

Jan 2013

 

 

 

Feb 2013

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Change

 

CIP CT-1

 

Change

 

CIP CT-1

 

Change

 

CIP CT-1

 

Change

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

 

 

194,929,577

 

 

 

194,929,577

 

 

 

194,929,577

 

 

 

Current Month’s Capital Costs

 

 

 

-    

 

 

 

-    

 

 

 

-    

 

 

 

Ending Month’s Capital Costs

 

 

 

194,929,577

 

 

 

194,929,577

 

 

 

194,929,577

 

 

 

Amount included in rates

 

 

 

163,280,000

 

 

 

163,280,000

 

 

 

163,280,000

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

 

 

31,649,577

 

 

 

31,649,577

 

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

-     

 

31,649,577

 

-     

 

31,649,577

 

-     

 

31,649,577

 

-     

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(68,506)

 

(1,810,383)

 

(68,506)

 

(1,878,889)

 

(68,506)

 

(1,947,395)

 

(68,506)

 

(-) Less:

related ADIT

 

(72,640)

 

(2,903,781)

 

(72,640)

 

(2,976,421)

 

(72,640)

 

(3,049,061)

 

(72,640)

 

(-) Less:

related unamortized ITC

 

79

 

(42,990)

 

79

 

(42,911)

 

79

 

(42,832)

 

79

 

(+) Add:

regulatory asset - depreciation expense

 

68,506

 

1,165,412

 

68,506

 

1,233,918

 

68,506

 

1,302,424

 

68,506

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

186,578

 

3,193,647

 

187,260

 

3,380,907

 

196,338

 

3,577,245

 

197,085

 

(=) Equals:

Total base for calculating carrying charge

 

114,017

 

31,251,481

 

114,699

 

31,366,181

 

123,777

 

31,489,957

 

124,524

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

 

 

31,194,473

 

 

 

31,308,831

 

 

 

31,428,069

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

 

 

0.006003

 

 

 

0.006271

 

 

 

0.006271

 

 

 

(=) Equals:

Monthly carrying charge

 

 

 

187,260

 

 

 

196,338

 

 

 

197,085

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

 

 

55,620

 

 

 

58,328

 

 

 

58,550

 

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

 

 

131,641

 

 

 

138,009

 

 

 

138,535

 

 

 

Total AFUDC (as calculated)

 

 

 

187,260

 

 

 

196,338

 

 

 

197,085

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

 

 

(0)

 

 

 

0

 

 

 

58,329

 

 

 

AFUDC - Equity (prior adjustment)

 

 

 

(0)

 

 

 

(0)

 

 

 

138,009

 

 

 

Prior months adjustments that should be recorded

 

 

 

(0)

 

 

 

(0)

 

 

 

196,338

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

 

 

55,619

 

 

 

58,329

 

 

 

116,879

 

 

 

AFUDC - Equity (revised adjustment)

 

 

 

131,641

 

 

 

138,009

 

 

 

276,544

 

 

 

Revised Total AFUDC (that should be recorded)

 

 

 

187,260

 

 

 

196,338

 

 

 

393,423

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

 

 

55,619

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Equity (what was recorded)

 

 

 

131,641

 

 

 

 

 

 

 

 

 

 

 

Total Recorded AFUDC (via JE) during the month

 

 

 

187,260

 

 

 

-    

 

 

 

-    

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

 

 

0

 

 

 

58,329

 

 

 

116,879

 

 

 

AFUDC - Equity (adjustment for following month)

 

 

 

(0)

 

 

 

138,009

 

 

 

276,544

 

 

 

Adjustment that should be reflected on the following month

 

 

 

(0)

 

 

 

196,338

 

 

 

393,423

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

 

 

52,225

 

 

 

68,472

 

 

 

68,733

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

 

 

(0)

 

 

 

0

 

 

 

68,473

 

 

 

True-Up AFUDC - Debt (that should be recorded)

 

 

 

52,225

 

 

 

68,473

 

 

 

137,206

 

 

 

True-Up AFUDC - Debt (what was recorded))

 

 

 

52,225

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

 

 

0

 

 

 

68,473

 

 

 

137,206

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

 

 

Dec-12

 

 

 

Jan-13

 

 

 

Feb-13

 

 

 

7,676,961

P0001050

 

127,256

 

-     

 

7,804,217

 

-     

 

7,804,217

 

-     

 

7,804,217

 

-     

 

3,801,520

P0001051

 

2,035

 

-     

 

3,808,851

 

-     

 

3,808,851

 

-     

 

3,808,851

 

-     

 

603,567

P0001052

 

2,595

 

-     

 

606,162

 

-     

 

606,162

 

-     

 

606,162

 

-     

 

1,809,875

P0001084

 

-      

 

-     

 

1,809,875

 

-     

 

1,809,875

 

-     

 

1,809,875

 

-     

 

668,194

P0001134

 

-      

 

-     

 

668,194

 

-     

 

668,194

 

-     

 

668,194

 

-     

 

753,115

P0001135

 

-      

 

-     

 

753,115

 

-     

 

753,115

 

-     

 

753,115

 

-     

 

1,795,941

P0001136

 

137,896

 

-     

 

1,933,837

 

-     

 

1,933,837

 

-     

 

1,933,837

 

-     

 

212,405

P0001137

 

39,682

 

-     

 

252,087

 

-     

 

252,087

 

-     

 

252,087

 

-     

 

4,857,924

P0001340

 

-      

 

-     

 

4,857,924

 

-     

 

4,857,924

 

-     

 

4,857,924

 

-     

 

1,261,761

P0001585

 

-      

 

-     

 

1,261,761

 

-     

 

1,261,761

 

-     

 

1,261,761

 

-     

 

3,046,322

P0001880

 

-      

 

-     

 

3,046,322

 

-     

 

3,046,322

 

-     

 

3,046,322

 

-     

 

7,107,036

P0001881

 

-      

 

-     

 

7,107,036

 

-     

 

7,107,036

 

-     

 

7,107,036

 

-     

 

161,127,436

P4900000

 

18,533

 

-     

 

161,323,906

 

-     

 

161,323,906

 

-     

 

161,323,906

 

-     

 

 

Less (NR/NE Cost)

 

(303,711)

 

-     

 

(303,711)

 

-     

 

(303,711)

 

-     

 

(303,711)

 

-     

 

194,722,057

 

 

24,286

 

-     

 

194,929,576

 

-     

 

194,929,576

 

-     

 

194,929,576

 

-     

 

(1,809,875)

 

 

 

 

-     

 

(1,809,875)

 

-     

 

(1,809,875)

 

-     

 

(1,809,875)

 

-     

 

192,912,182

 

 

 

 

 

 

193,119,701

 

 

 

193,119,701

 

 

 

193,119,701

 

 

 

 


 


 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 8 of 10

 

HECO

Major Projects:  CIP CT-1

Monthly Carrying Charge Calculation

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Mar 2013

 

 

 

Apr 2013

 

 

 

May 2013

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CIP CT-1

 

Change

 

CIP CT-1

 

Change

 

CIP CT-1

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less: NR/NE (removal/expense) Costs

 

 

 

 

 

 

 

 

 

 

 

 

 

Beginning Month’s Capital Costs

 

194,929,577

 

 

 

194,929,577

 

 

 

194,929,577

 

 

 

Current Month’s Capital Costs

 

-    

 

 

 

-    

 

 

 

-    

 

 

 

Ending Month’s Capital Costs

 

194,929,577

 

 

 

194,929,577

 

 

 

194,929,577

 

 

 

Amount included in rates

 

163,280,000

 

 

 

163,280,000

 

 

 

163,280,000

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,649,577

 

 

 

31,649,577

 

 

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Gross Capital Cost in excess of Commission - approved amount

 

31,649,577

 

-      

 

31,649,577

 

-      

 

31,649,577

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(-) Less:

related accumulated depreciation

 

(2,015,901)

 

(68,506)

 

(2,084,407)

 

(68,506)

 

(2,152,914)

 

 

 

(-) Less:

related ADIT

 

(3,121,701)

 

(72,640)

 

(3,194,341)

 

(72,640)

 

(3,266,981)

 

 

 

(-) Less:

related unamortized ITC

 

(42,753)

 

79

 

(42,674)

 

79

 

(42,595)

 

 

 

(+) Add:

regulatory asset - depreciation expense

 

1,370,930

 

68,506

 

1,439,436

 

68,506

 

1,507,942

 

 

 

(+) Add:

regulatory asset - carrying charge of AFUDC debt/equity component

 

3,774,330

 

197,864

 

3,972,194

 

198,647

 

4,170,841

 

 

 

(=) Equals:

Total base for calculating carrying charge

 

31,614,482

 

125,303

 

31,739,784

 

126,086

 

31,865,870

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Average Capital Cost base for calculating carrying charge

 

31,552,219

 

 

 

31,677,133

 

 

 

31,802,827

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

(x) Multiply:

Rate equivalent to AFUDC / 12

 

0.006271

 

 

 

0.006271

 

 

 

0.006271

 

 

 

(=) Equals:

Monthly carrying charge

 

197,864

 

 

 

198,647

 

 

 

199,436

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly Carrying Charge Breakdown

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (eff. 8/2012, rates were changed)

 

58,782

 

 

 

59,014

 

 

 

59,249

 

 

 

AFUDC - Equity (eff. 8/2012, rates were changed)

 

139,082

 

 

 

139,633

 

 

 

140,187

 

 

 

Total AFUDC (as calculated)

 

197,864

 

 

 

198,647

 

 

 

199,436

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (prior adjustment)

 

116,879

 

 

 

175,661

 

 

 

234,676

 

 

 

AFUDC - Equity (prior adjustment)

 

276,544

 

 

 

415,626

 

 

 

555,259

 

 

 

Prior months adjustments that should be recorded

 

393,423

 

 

 

591,287

 

 

 

789,934

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (revised adjustment)

 

175,661

 

 

 

234,676

 

 

 

293,924

 

 

 

AFUDC - Equity (revised adjustment)

 

415,626

 

 

 

555,259

 

 

 

695,446

 

 

 

Revised Total AFUDC (that should be recorded)

 

591,287

 

 

 

789,934

 

 

 

989,370

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (what was recorded)

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Equity (what was recorded)

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Recorded AFUDC (via JE) during the month

 

-    

 

 

 

-    

 

 

 

-    

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC - Debt (adjustment for following month)

 

175,661

 

 

 

234,676

 

 

 

293,924

 

 

 

AFUDC - Equity (adjustment for following month)

 

415,626

 

 

 

555,259

 

 

 

695,446

 

 

 

Adjustment that should be reflected on the following month

 

591,287

 

 

 

789,934

 

 

 

989,370

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (0.4434% - 0.1950%)
[eff. 8/12 (0.3457% - 0.1783%)]

 

69,005

 

 

 

69,278

 

 

 

69,553

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (prior adjustment)

 

137,206

 

 

 

206,211

 

 

 

275,489

 

 

 

True-Up AFUDC - Debt (that should be recorded)

 

206,211

 

 

 

275,489

 

 

 

345,041

 

 

 

True-Up AFUDC - Debt (what was recorded))

 

 

 

 

 

 

 

 

 

 

 

 

 

True-Up AFUDC - Debt (adjustment for the following month)

 

206,211

 

 

 

275,489

 

 

 

345,041

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Capital Cost

 

 

 

Mar-13

 

 

 

Apr-13

 

 

 

May-13

 

 

 

7,676,961

P0001050

 

127,256

 

7,804,217

 

-      

 

7,804,217

 

-      

 

7,804,217

 

 

 

3,801,520

P0001051

 

2,035

 

3,808,851

 

-      

 

3,808,851

 

-      

 

3,808,851

 

 

 

603,567

P0001052

 

2,595

 

606,162

 

-      

 

606,162

 

-      

 

606,162

 

 

 

1,809,875

P0001084

 

-      

 

1,809,875

 

-      

 

1,809,875

 

-      

 

1,809,875

 

 

 

668,194

P0001134

 

-      

 

668,194

 

-      

 

668,194

 

-      

 

668,194

 

 

 

753,115

P0001135

 

-      

 

753,115

 

-      

 

753,115

 

-      

 

753,115

 

 

 

1,795,941

P0001136

 

137,896

 

1,933,837

 

-      

 

1,933,837

 

-      

 

1,933,837

 

 

 

212,405

P0001137

 

39,682

 

252,087

 

-      

 

252,087

 

-      

 

252,087

 

 

 

4,857,924

P0001340

 

-      

 

4,857,924

 

-      

 

4,857,924

 

-      

 

4,857,924

 

 

 

1,261,761

P0001585

 

-      

 

1,261,761

 

-      

 

1,261,761

 

-      

 

1,261,761

 

 

 

3,046,322

P0001880

 

-      

 

3,046,322

 

-      

 

3,046,322

 

-      

 

3,046,322

 

 

 

7,107,036

P0001881

 

-      

 

7,107,036

 

-      

 

7,107,036

 

-      

 

7,107,036

 

 

 

161,127,436

P4900000

 

18,533

 

161,323,906

 

-      

 

161,323,906

 

-      

 

161,323,906

 

 

 

 

Less (NR/NE Cost)

 

(303,711)

 

(303,711)

 

-      

 

(303,711)

 

-      

 

(303,711)

 

 

 

194,722,057

 

 

24,286

 

194,929,576

 

-      

 

194,929,576

 

-      

 

194,929,576

 

 

 

(1,809,875)

 

 

 

 

(1,809,875)

 

-      

 

(1,809,875)

 

-      

 

(1,809,875)

 

 

 

192,912,182

 

 

 

 

193,119,701

 

 

 

193,119,701

 

 

 

193,119,701

 

 

 

 


 


 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 9 of 10

 

HECO

Major Projects:  CT-1

Monthly Carrying Charge Calculation

 

 

 

 

Depreciation

 

AFUDC
Equity

 

 

AFUDC
Debt

 

 

 

 

18670120

 

18670122

 

 

18670121

 

 

Jul-11

 

38,826

 

130,036

 

 

55,232

 

 

Aug-11

 

65,966

 

129,070

 

 

54,642

 

 

Sep-11

 

65,966

 

123,391

 

 

52,589

 

 

Oct-11

 

65,967

 

127,450

 

 

54,134

 

 

Nov-11

 

65,966

 

129,944

 

 

55,193

 

 

Dec-11

 

65,967

 

128,200

 

 

54,452

 

 

2011 Total

 

368,658

 

768,091

 

 

326,242

 

 

 

 

 

 

 

 

 

 

 

 

Jan-12

 

43,188

 

129,600

 

 

59,425

 

 

Feb-12

 

68,506

 

132,130

 

 

60,619

 

 

Mar-12

 

68,506

 

134,216

 

 

61,575

 

 

Apr-12

 

68,506

 

131,613

 

 

60,381

 

 

May-12

 

68,506

 

132,204

 

 

60,653

 

 

Jun-12

 

68,506

 

131,076

 

 

60,135

 

 

Jul-12

 

68,506

 

131,300

 

 

60,237

 

 

Aug-12

 

68,506

 

126,055

 

 

53,260

 

 

Sep-12

 

68,506

 

126,243

 

 

53,339

 

 

Oct-12

 

68,506

 

126,405

 

 

53,407

 

 

Nov-12

 

68,506

 

151,242

 

 

64,199

 

 

Dec-12

 

68,506

 

131,641

 

 

55,620

 

 

2012 Total

 

796,754

 

1,583,725

 

 

702,850

 

 

 

 

 

 

 

 

 

 

 

 

Jan-13

 

68,506

 

138,009

 

 

58,328

 

Estimated

Feb-13

 

68,506

 

138,535

 

 

58,550

 

Estimated

Mar-13

 

68,506

 

139,082

 

 

58,782

 

Estimated

Apr-13

 

68,506

 

139,633

 

 

59,014

 

Estimated

May-13

 

68,506

 

140,187

 

 

59,249

 

Estimated

2013 Total

 

342,530

 

695,446

 

 

293,924

 

 

 

 

 

 

 

 

 

 

 

 

Total Deferred

 

1,507,942

 

3,047,262

 

 

1,323,016

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

AFUDC (Equity)

 

 

 

3,047,262

 

 

 

 

 

AFUDC (Debt)

 

 

 

1,323,016

 

 

 

 

 

Carrying Charge (AFUDC)

 

4,370,278

 

 

 

 

 

 


 

 


 

Workpapers for Exhibit 3 CT-1

CT-1 Deferred Cost

Page 10 of 10

 

HECO

 

 

 

 

 

 

 

 

 

 

 

Major Projects:  CIP CT-1

 

 

 

 

 

 

 

 

 

 

 

A/D Adjustment & AFUDC Rates

 

 

 

 

 

 

 

 

 

Annual

 

 

 

 

 

 

 

 

 

 

 

Depreciation

 

 

 

 

 

 

 

 

 

Excess

 

for entire

 

 

 

Original

 

 

Difference

 

 

Revised

 

(incl. Excess)

 

Accumulated Depreciation Adjustment

 

CIP CT-1

 

 

CIP CT-1

 

 

CIP CT-1

 

CIP CT-1

 

 

 

 

 

 

 

 

 

 

 

 

 

Total Project Cost (as of Dec 31, 2010)

 

192,912,182

 

 

 

 

 

 

 

 

 

Amount included in rates

 

161,469,776

 

 

 

 

 

 

 

 

 

 

 

31,442,406

 

 

 

 

 

 

 

 

 

Depreciation Expense

 

 

 

 

 

 

 

 

 

 

 

2011 Depr Exp (Jan - Jul)

 

465,906

 

 

 

 

 

 

 

 

 

2011 Depr Exp (Monthly)

 

38,826

 

 

 

 

 

 

 

 

 

Rev 2011 Depr Exp (Aug - Dec)

 

791,597

 

 

(197,279)

 

 

594,318

 

 

 

Rev 2011 Depr Exp (Monthly)

 

65,966

 

 

(16,440)

 

 

49,527

 

 

 

2012 Depr Exp (Jan - Dec)

 

 

 

 

 

 

 

822,074

 

 

 

2012 Depr Exp (Monthly)

 

 

 

 

 

 

 

68,506

 

 

 

2013 Depr Exp (Jan - Dec)

 

 

 

 

 

 

 

822,074

 

4,680,678

 

2013 Depr Exp (Monthly)

 

 

 

 

 

 

 

68,506

 

390,057

 

 

 

 

 

 

 

 

 

 

 

 

 

Accumulated Depreciation

 

 

 

 

 

 

 

 

 

 

 

2010 Accum Depr (12/31/11)

 

412,014

 

 

955

 

 

412,969

 

 

 

2011 Depr Exp (Jan - Jun)

 

232,953

 

 

64,206

 

 

297,159

 

 

 

Total Accum Depr (6/30/11)

 

644,967

 

 

65,161

 

 

710,128

 

 

 

2011 Depr Exp (Jul)

 

38,826

 

 

10,701

 

 

49,527

 

 

 

Total Accum Depr (7/31/11)

 

683,793

 

 

75,862

 

 

759,655

 

 

 

2011 Depr Exp (Aug - Dec)

 

329,832

 

 

(82,200)

 

 

247,632.50

 

 

 

Total Accum Depr (12/31/11)

 

1,013,625

 

 

(6,338)

 

 

1,007,287

 

 

 

2012 Depr Exp (Jan)

 

43,189

 

 

 

 

 

49,527

 

 

 

Total Accum Depr (1/31/12)

 

1,056,814

 

 

 

 

 

1,056,814

 

 

 

2012 Depr Exp (Feb-Dec)

 

 

 

 

 

 

 

753,568

 

 

 

Total Accum Depr (12/31/12)

 

 

 

 

 

 

 

1,810,381

 

 

 

2013 Depr Exp (Jan-Dec)

 

 

 

 

 

 

 

822,074

 

 

 

Total Accum Depr (12/31/13)

 

 

 

 

 

 

 

2,632,455

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly 2011 AFUDC Debt rate

 

= rate in ELLIPSE table

 

0.001950

 

 

0.001950

 

 

 

 

 

 

Monthly 2011 AFUDC Equity rate

 

= rate in ELLIPSE table

 

0.004591

 

 

0.004591

 

 

 

 

 

 

 

 

 

 

0.006541

 

 

0.006541

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Annual 2011 AFUDC Debt rate

 

= rate in ELLIPSE table

 

0.023552

 

 

0.023552

 

 

 

 

 

 

Annual 2011 AFUDC Equity rate

 

= rate in ELLIPSE table

 

0.055449

 

 

0.055449

 

 

 

 

 

 

 

 

 

 

0.079001

 

 

0.079001

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Annual 2011 Actual Debt rate

 

Recalculated

 

0.053209

 

 

0.053209

 

 

 

 

 

 

Monthly 2011 Actual Debt rate

 

Recalculated

 

0.004434

 

 

0.004434

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly 2011 Actual Debt (true-up) rate

 

(0.004434 - 0.001950)

 

0.002484

 

 

0.002484

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

January - July 2012

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly 2012 AFUDC Debt rate

 

= rate in ELLIPSE table

 

0.002020

 

 

0.002020

 

 

 

 

 

 

Monthly 2012 AFUDC Equity rate

 

= rate in ELLIPSE table

 

0.004403

 

 

0.004403

 

 

 

 

 

 

 

 

 

 

0.006423

 

 

0.006423

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly 2012 Actual Debt rate

 

Recalculated

 

0.004386

 

 

0.004386

 

 

 

 

 

 

Monthly 2012 Actual Debt (true-up) rate

 

(0.004386 - 0.002020)

 

0.002366

 

 

0.002366

 

 

 

 

 

 

 

 

 

 

2012

 

 

 

 

 

 

 

 

 

July - December 2012 (“Catch-up” Amount)

 

 

 

“Catch-up Amount”

 

 

“Annual Amount”

 

 

 

 

 

 

Monthly 2012 AFUDC Debt rate

 

= rate in ELLIPSE table

 

0.001783

 

 

0.001863

 

 

 

 

 

 

Monthly 2012 AFUDC Equity rate

 

= rate in ELLIPSE table

 

0.004220

 

 

0.004408

 

 

 

 

 

 

 

 

 

 

0.006003

 

 

0.006271

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly 2012 Actual Debt rate

 

Recalculated

 

0.003457

 

 

0.004050

 

 

 

 

 

 

Monthly 2012 Actual Debt (true-up) rate

 

(0.00345719 - 0.001783)

 

0.001674

 

 

0.002187

 

 

 

 

 

 

 

Notes:

o AFUDC rate is 0.6541% per month in 2011. Budgets reviews rate quarterly.

(Annual rate = 7.9001%)

o AFUDC amount for current month is computed on prior end-of-month balance plus

1/2 of current month’s additions

o AFUDC is added on AFUDC -- 0.6541% rate is reduced to reflect this compounding.

 

ADIT & Unamortized ITC related to Excess Project Costs

 

Calculated by HEI Tax (as provided by Mary Zane)

 



 

Workpapers for Exhibit 3 CIS

CIS Carrying Charges

Page 1 of 4

 

HECO & Subsidiaries

Estimate CIS Carrying Charge

January 2013 - May 2013 (Estimated 1/16/2013)

 

 

 

HECO

 

HELCO

 

MECO

 

Total

 

 

 

 

 

 

 

 

 

 

 

CIS costs as of 12/31/12

 

14,312

 

2,525

 

2,729

 

19,566

 

 

 

 

 

 

 

 

 

 

 

Estimated AFUDC: (Jan 2013 - May 2013)        

 

 

 

 

 

 

 

 

 

AFUDC - Debt

 

135

 

22

 

22

 

179

 

AFUDC - Equity

 

319

 

56

 

60

 

435

 

Total AFUDC

 

454

 

78

 

82

 

614

 

 



 

Workpapers for Exhibit 3 CIS

CIS Carrying Charges

Page 2 of 4

 

HECO

Monthly Carrying Charge on deferred CIS system development project costs (Post Go-live)

2013

(Do this calculation on 3rd work day, after Gail Shimabukuro has reclassed non-deferrable on-costs to expense on 2nd work day)

 

 

 

 

 

AFUDC Equity

 

AFUDC Debt

 

Acct Balance

 

 

 

 

 

CIS Def Cost

 

Cr. 42002000

 

Cr. 42004000

 

Dr. 18670202

 

 

 

 

 

(Acct 186050)

 

Dr. 42002000

 

Dr. 42004000

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

G.L. balance 12/31/12

 

14,312.00

 

 

 

 

 

 

 

 

 

Costs incurred in 1/13

 

 

 

 

 

 

 

 

 

 

 

Add AFUDC @ .6423%

 

0.00

 

63.09

 

26.66

 

89.75

 

 

 

Add’l costs after AFUDC calc

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

G.L. balance 1/31/13

 

14,312.00

 

 

 

 

 

89.75

 

 

 

Costs incurred in 2/13

 

0.00

 

 

 

 

 

 

 

 

 

Add AFUDC @ .6423%

 

0.00

 

63.48

 

26.83

 

90.31

 

 

 

Add’l costs after AFUDC calc

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

G.L. balance 2/28/13

 

14,312.00

 

 

 

 

 

180.06

 

 

 

Costs incurred in 3/13

 

 

 

 

 

 

 

 

 

 

 

Add AFUDC @ .6203%

 

0.00

 

63.88

 

27.00

 

90.88

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

G.L. balance 3/31/13

 

14,312.00

 

 

 

 

 

270.94

 

 

 

Costs incurred in 4/13

 

 

 

 

 

 

 

 

 

 

 

Add AFUDC @ .6203%

 

0.00

 

64.28

 

27.17

 

91.45

 

 

 

Add’l costs after AFUDC calc

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

G.L. balance 4/30/13

 

14,312.00

 

 

 

 

 

362.39

 

 

 

Costs incurred in 5/13

 

 

 

 

 

 

 

 

 

 

 

Add AFUDC @ .6203%

 

0.00

 

64.68

 

27.34

 

92.02

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

G.L. balance 5/31/13

 

14,312.00

 

319.41

 

135.00

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Monthly 2012 AFUDC Debt rate

 

0.001863

 

= rate in ELLIPSE table

 

0.001863

 

= rate in ELLIPSE table

 

Monthly 2012 AFUDC Equity rate

 

0.004408

 

= rate in ELLIPSE table

 

0.004408

 

= rate in ELLIPSE table

 

 

 

0.00627100

 

 

 

 

 

0.00627100

 

 

 

 

Notes:

o AFUDC rate is 0.6423% per month in 2012 (through July 2012).  AFUDC rate is 0.6203% per month in 2012 (August onward).

Budgets reviews rate quarterly.  (Annual rate = 7.7578% through July 2012,  7.5728% from August onward)

 

o AFUDC amount for current month is computed on prior end-of-month balance plus

1/2 of current month’s additions

 

o AFUDC is added on AFUDC -- 0.6423% (or 0.6203%) rate is reduced to reflect this compounding.

 



 

Workpapers for Exhibit 3 CIS

CIS Carrying Charges

Page 3 of 4

 

Hawaii Electric Light Company, Inc.

Calculation of AFUDC on CIS costs as of 12/31/12

 

 

 

AFUDC rates:

 

 

 

 

 

 

 

 

 

 

 

debt

 

equity

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

*Apr 2012 - Dec 2012

 

 

 

 

 

 

 

 

 

0.1933%

 

0.4835%

 

0.6768%

 

 

 

 

 

 

 

 

ineligible

 

 

 

 

 

AFUDC
base

 

AFUDC

 

AFUDC

 

AFUDC
base

 

 

 

labor

 

overheads

 

on-costs

 

other

 

total

 

BOM

 

debt

 

equity

 

EOM

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Jan-13

 

-

 

-

 

-

 

2,525.00

 

2,525.00

 

1,262.50

 

2.44

 

6.10

 

2,533.54

 

Feb-13

 

-

 

-

 

-

 

-

 

-

 

2,533.54

 

4.90

 

12.25

 

2,550.69

 

Mar-13

 

-

 

-

 

-

 

-

 

-

 

2,550.69

 

4.93

 

12.33

 

2,567.95

 

Apr-13

 

-

 

-

 

-

 

-

 

-

 

2,567.95

 

4.96

 

12.42

 

2,585.33

 

May-13

 

-

 

-

 

-

 

-

 

-

 

2,585.33

 

5.00

 

12.50

 

2,602.83

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

-

 

-

 

-

 

2,525.00

 

2,525.00

 

 

 

22.23

 

55.60

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Total AFUDC

 

77.83

 

 

 

 

*    AFUDC rates based on current information available.  2013 AFUDC rates still being finalized.

 



 

Workpapers for Exhibit 3 CIS

CIS Carrying Charges

Page 4 of 4

 

Maui Electric Company, Limited

Estimated CIS Carrying Charges

January - May 2013

 

 

 

Month/Yr

 

Estimated

 

Monthly

 

AFUDC

 

Debt Rate

 

Estimated

 

Monthly

 

AFUDC

 

Equity Rate

 

Principal

 

Balance

 

Carrying

 

Charge based

 

upon AFUDC

 

Debt Rate

 

Carrying

 

Charge based

 

upon AFUDC

 

Equity Rate

 

Cumulative

 

Balance

 

Monthly

 

Carrying

 

Charge

 

 

 

 

 

 

 

 

 

 

 

 

 

-    

 

 

 

Dec-12

 

0.1755%

 

0.4843%

 

-     

 

-      

 

-      

 

-    

 

 

 

Jan-13

 

0.1755%

 

0.4843%

 

2,729.00

 

2.39

 

6.61

 

2,738.00

 

9.00

 

Feb-13

 

0.1755%

 

0.4843%

 

-     

 

4.81

 

13.26

 

2,756.07

 

18.07

 

Mar-13

 

0.1755%

 

0.4843%

 

-     

 

4.84

 

13.35

 

2,774.26

 

18.19

 

Apr-13

 

0.1755%

 

0.4843%

 

-     

 

4.87

 

13.44

 

2,792.57

 

18.31

 

May-13

 

0.1755%

 

0.4843%

 

-     

 

4.90

 

13.52

 

2,810.99

 

18.42

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2,729.00

 

21.81

 

60.18

 

2,810.99

 

81.99