NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

Section 6.19.6.2.2 Formula Rate Template

 

 

New York State Electric and Gas Corporation
Transmission Formula Rate

Schedule 19 Projects

Actual for the 12 Months Ended 12/31/2021
Index

 

WorksheetTabDescription

AAppendix AAnnual Transmission Revenue Requirement for Schedule 19 Projects

 

1RB ItemsAverage Balances for Most Rate Base Items

 

2aADIT-Current YearCurrent Year Average Accumulated Deferred Income Taxes

 

2bADIT-Prior YearPrior Year Average Accumulated Deferred Income Taxes

 

2cADIT Proration ProjectedProration of Projected Accumulated Deferred Income Taxes

 

2dADIT Proration ActualProration of Actual Accumulated Deferred Income Taxes

 

3EADITExcess Accumulated Deferred Income Tax Rate Base and Amortization

 

4IT Permanent DifferencesPermanent Book/Tax Differences

 

5Project ReturnReturn on Schedule 19 Project

 

6Project Cost Of CapitalSchedule 19 Project Cost of Capital

 

7True-up AdjustmentAnnual True-up Adjustment

 

Depreciation Rates Approved by the Commission and Used to Determine Schedule 19

8Depreciation RatesProject Depreciation and Amortization Expense

 

9CorrectionsPrior Period Corrections

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedTransmission Formula Rate TemplateActual for the 12 Months Ended 12/31/2021

Utilizing FERC Form 1 Data

 

New York State Electric and Gas Corporation

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects

 

Composite Depreciation Rates

(1)(2)(3)(4)(5)

Line

Form No. 1 or TransmissionCompany Total (whereSchedule 19

No.RATE BASE (Note A):Formula Rate Referenceapplicable)Allocator (Note K)Projects

GROSS PLANT IN SERVICE

1ProductionWorksheet 1, Line 6, Col. (c)0NA0

2TransmissionWorksheet 1, Line 6, Col. (d) or Col. (m)0DA0

3DistributionWorksheet 1, Line 6, Col. (e)0NA0

4Electric GeneralWorksheet 1, Line 6, Col. (f)0S19 W/S#DIV/0!#DIV/0!

5Electric IntangibleWorksheet 1, Line 6, Col. (b)0S19 W/S#DIV/0!#DIV/0!

6CommonWorksheet 1, Line 6, Col. (g)0CP*S19 W/S#DIV/0!#DIV/0!

7TOTAL GROSS PLANT(Sum of Lines 1 through 6)0GP=#DIV/0!#DIV/0!

8Without Common - For Gross Plant Allocator Calculation Only0GPE=#DIV/0!#DIV/0!

 

ACCUMULATED DEPRECIATION

9ProductionWorksheet 1, Line 12, Col. (c)-NA0

Worksheet 1, Line 12, Col. (d) or Col.

10Transmission(m)-DA-

11DistributionWorksheet 1, Line 12, Col. (e)-NA0

12Electric GeneralWorksheet 1, Line 12, Col. (f)-S19 W/S#DIV/0!#DIV/0!

13Electric IntangibleWorksheet 1, Line 12, Col. (b)-S19 W/S#DIV/0!#DIV/0!

14CommonWorksheet 1, Line 12, Col. (g)-CP*S19 W/S#DIV/0!#DIV/0!

15TOTAL ACCUM. DEPRECIATION(Sum of Lines 9 through 14)-#DIV/0!

 

NET PLANT IN SERVICE

16Production(Line 1 - Line 9)00

17Transmission(Line 2 - Line 10)00

18Distribution(Line 3 - Line 11)00

19General(Line 4 - Line 12)0#DIV/0!

20Intangible(Line 5 - Line 13)0#DIV/0!

21Common(Line 6 - Line 14)0#DIV/0!

22TOTAL NET PLANT(Sum of Lines 16 through 21)0#DIV/0!

 

23CWIP (Note O)Worksheet 1, Line 18, Col. (g)NA-

 

24ABANDONNED PLANTWorksheet 1, Line 18, Col. (j)NA0

 

ACCUMULATED DEFERRED INCOME

TAXES  (Note B)

25Accumulated Deferred Income TaxesWorksheet 2a, Line 11, Col. (g)NA#DIV/0!

 

26Excess Accumulated Deferred Income Taxes3-EDITNA0

TOTAL ACCUMULATED DEFERRED

27INCOME TAXES(Line 25 + Line 26)#DIV/0!

 

28LAND HELD FOR FUTURE USEWorksheet 1, Line 18, Col. (h) or (i)0DA0

 

OTHER RATE BASE ITEMS

29Cash Working Capital (Note C)(Line 50 times 45/360)NA#DIV/0!

30Materials & Supplies  - TransmissionWorksheet 1, Line 18, Col. (k)0S19P#DIV/0!#DIV/0!

Materials and Supplies - Electric and Gas -

31Assigned to ConstructionWorksheet 1, Line 18, Col. (l)0CP*GPE#DIV/0!#DIV/0!

32PrepaymentsWorksheet 1, Line 18, Col. (m)0CP*GPE#DIV/0!#DIV/0!

33Regulatory Asset (Note E)Worksheet 1, Line 18, Col. (n)NADA0

34Unfunded LiabilitiesWorksheet 1, Line 18, Col. (q)-CP*S19 W/S#DIV/0!#DIV/0!

35TOTAL OTHER RATE BASE ITEMS(Sum of Lines 29 through 34)NA#DIV/0!

 

(Line 22 + Line 23 + Line 24 + Line 27 +

36RATE BASELine 28 + Line 35)NA#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedRate Formula TemplateActual for the 12 Months Ended 12/31/2021

Utilizing FERC Form 1 Data

 

New York State Electric and Gas Corporation

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects

 

(1)(2)(3)(4)(5)

Schedule 19

LineProjects

ANNUAL TRANSMISSION REVENUEForm No. 1 or TransmissionCompany Total (where

No.REQUIREMENTFormula Rate Referenceapplicable)Allocator (Note K)(Col 3 times Col 4)

OPERATIONS AND MAINTENANCE

EXPENSES (Note M)

37Transmission - Direct Assign320-323.112.b fn0DA0

38Transmission - Allocate320-323.112.b fn0

39Less:  EPRI Dues in Account 566352-3530

40Subtotal - Transmission to AllocateLine 38 - Line 390S19P#DIV/0!#DIV/0!

41Electric A&G320-323.197.b0

42Less:  EPRI Dues in A&G352-3530

43Less: Regulatory Commission Expenses320-323.189.b0

44Less: Property Insurance320-323.185.b0

45Less:  Account 930.2 ItemsNote L0

Line 41 - Line 42 - Line 43 - Line 44 -

46Adjusted Electric A&GLine 450S19 W/S#DIV/0!#DIV/0!

Plus: Transmission Related Regulatory

47Expenses350-351 fn0S19P#DIV/0!#DIV/0!

Plus:  Direct Assigned Regulatory

48Commission Expenses350-351 fnNADA0

49Plus: Property Insurance320-323.185.b0GPE#DIV/0!#DIV/0!

 

50TOTAL O&MSum of Lines 37, 40 and 46 through 49NA#DIV/0!

 

DEPRECIATION AND AMORTIZATION EXPENSE

 

 

51Transmission336.7.f, fn0DA0

52Electric General336.10 f0S19 W/S#DIV/0!#DIV/0!

53Electric Intangible0S19 W/S#DIV/0!#DIV/0!

54Common Electric336.11.f0S19 W/S#DIV/0!#DIV/0!

Amortization of Cost of Removal Regulatory

55Asset232NADA0

56Amortization of Abandoned Plant230a fnNADA0

57TOTAL DEPRECIATIONSum of Lines 51 through 560#DIV/0!

 

TAXES OTHER THAN INCOME TAXES

LABOR RELATED

58Payroll (Note D)262-263.9+262-263.17. l0CP*S19 W/S#DIV/0!#DIV/0!

59PLANT RELATED

60Real Estate262-263.5.l0CP*GPE#DIV/0!#DIV/0!

61Franchise Tax262-2630CP*GPE#DIV/0!#DIV/0!

62Gross Receipts TaxNANote N0

63Other (Note E)262-26300

64TOTAL OTHER TAXESSum of Lines 58 and 60 through 630#DIV/0!

 

INCOME TAXES (Note F)

T=1 - {[(1 - SIT) * (1 - FIT)] / (1 -

65Composite Tax Rate = TSIT * FIT * p)}=0.0000%

66Gross-up Factor1 / (1 - T)0.0000

67Income Tax FactorT/(1-T)0.0000

Amortization of Investment Tax Credit (enter

68negative)266-267.11. f, fnNADA0

Amortization of Excess Deferred Income

69Taxes (enter negative)Worksheet 3NADA0

70Tax Effect of Permanent DifferencesWorksheet 4, Line 2, Col. (e)NADA-

71Income Tax Calculation(Line 77 * Line 67)NACalc#DIV/0!

72ITC adjustment(Line 68 * Line 66)NACalc0

73Excess Deferred Income Tax Adjustment(Line 69 * Line 66)NACalc0

74Permanent Differences Tax Adjustment(Line 70 * Line 66)NACalc0

75TOTAL INCOME TAXESSum of Lines 71 through 74NA#DIV/0!

 

RETURN (Note H)

76DebtWorksheet 5, Line 12, Col. (i)NACalc#DIV/0!

77Common Equity and Preferred StockWorksheet 5, Line 12, Col. (f)NACalc#DIV/0!

78TOTAL RETURNSum of Lines 76 through 77NA#DIV/0!

 

 

ANNUAL TRANSMISSION REVENUE

REQUIREMENT BEFORE REVENUE(Line 50 + Line 57 + Line 64 + Line 75 +

79CREDITSLine 78)NA#DIV/0!

 

80REVENUE CREDITS(Line 104)NA-

 

ANNUAL TRANSMISSION REVENUE

81REQUIREMENT (ATU)(Line 79 + Line 80)NA#DIV/0!

 

82CORRECTIONSWorksheet 9, Line 11, Col. (b)NA0

 

ANNUAL TRUE-UP ADJUSTMENT (ATU)

83(Note G)Worksheet 7, Line 7NA0

84ATRR PLUS ATU AND CORRECTIONSSum of Lines 81 through 83NA#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedRate Formula TemplateActual for the 12 Months Ended 12/31/2021

Utilizing FERC Form 1 Data

 

New York State Electric and Gas Corporation

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects

 

SUPPORTING CALCULATIONS AND NOTES

Line

No.  TRANSMISSION PLANT ALLOCATOR

85Electric Plant(Line 99)0

86Total Transmission Plant(Line 2)0

87Schedule 19 Projects(Line 2)0

88Schedule 19 Projects Plant Allocator(Line 87 / Line86)#DIV/0! S19P

89Transmission Plant Allocator(Line 86 / Line 85)#DIV/0! TP

 

ELECTRIC WAGE AND SALARY

ALLOCATOR

90Production354-355.20.b0

91Transmission354-355.21.b0

92Distribution354-355.23.b0

93Other354-355.24,25,26.b0

94TotalSum of Lines 90 through 930

95Transmission Wage and Salary Allocator(Line 91 / Line 94)#DIV/0!T W/S

 

Schedule 19 Projects Wages and Salaries

96(transmission wages and salary times S19P)(Line 91 * Line 88)#DIV/0!

Schedule 19 Projects Wage and Salary

97Allocator(Line 96 / Line 94)#DIV/0!S19 W/S

Schedule 19 Projects Transmission Wage and

98Salary Allocator(Line 96 / Line 91)#DIV/0!S19 W/S T

 

ELECTRIC COMMON PLANT ALLOCATOR

(CE)% Electric

99Electric200-201.3.c+6.c0

100Gas200-201.3.d+6.d0CP=0.000%

101Total (excludes common)(Line 99 + Line 100)0

 

REVENUE CREDITS

Account 454, Rent from Electric Property

102(Note I)300-301, fn-

 

Account 456, Other Electric Revenue (Note J)

103300-301, fn-

 

104Total Revenue Credits-

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedRate Formula Template

Utilizing FERC Form 1 Data

 

New York State Electric and Gas Corporation

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects

 

General Note:  References to pages in this transmission formula rate rate are indicated as:  (page#, line#, col.#) References to data from FERC Form 1 are indicated as:  #.y.x  (page, line, column)

 

Note


 

 

 

 

 

 

 

Actual for the 12 Months Ended 12/31/2021

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

AAll amounts shown are based on five quarter averages which are contained in footnotes to the FF1 (with the following exceptions: CWC in line 28 which is based upon one-eighth of O&M, Accumulated Deferred

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

Income Taxes in line 24 which are a combination of beginning and end of year averages and proration amounts, and Excess Accumulated Deferred Income Taxes in line 25 which are beginning/ending year

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

averages).

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

BThe maximum accumulated deferred tax offset to rate base is calculated in accordance with the proration formula prescribed by IRS regulation section 1.167(l)-1(h)(6).

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

CCash Working Capital for Schedule 19 Projects equals one-eighth (45 days) of O&M allocated to Schedule 19 Projects.

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

DIncludes only FICA and unemployment taxes.

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

EIncludes removal costs related to assets removed to make room for Schedule 19 Projects which are amortized over 10 years to FERC Account 407.3, subject to FERC approval under a future, limited Section 205

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

filing.

F Below are the currently effective income tax rate, where FIT is the Federal income tax rate; SIT is the State income tax rate, and p = "the percentage of federal income tax deductible for state income taxes".  If the

utility is taxed in more than one state it must attach a work paper showing the name of each state and how the blended or composite SIT was developed.  Furthermore, a utility that elected to utilize amortization of

tax credits against taxable income, rather than book tax credits to Account No. 255 and reduce rate base, must reduce its income tax expense by the amount of the Amortized Investment Tax Credit (Form 1, 266.8.f) multiplied by (1/1-T).  Any Excess or Deficient Deferred Income Taxes reduce or increase income tax expense by the amount of the expense multiplied by (1/1-T).

 

Inputs Required:FIT =0.00%

SIT=0.00%(State Income Tax Rate or Composite SIT)

p =0.00%(percent of federal income tax deductible for state purposes)

GInclude ATU for Year N with Projected ATRR for Year N+2

HDebt cost rate = long-term interest/ long term debt.  Preferred cost rate = preferred dividends / preferred outstanding.  The ROE is determined by the New York Public Utilities Commission and capped by the ROE

determined by FERC.  The ROE Cap will be supported in the original filing and no change in ROE Cap may be made absent a filing with FERC.

IIncludes revenue related to Schedule 19 Projects only, such as pole attachments, rentals and special use.

JIncludes revenue related to Schedule 19 Projects only.

KThe following acronyms are used for allocators:

CP= common plant allocator (allocate common plant and common expenses to total electric)

DA= DA=direct assignment (the item is direct assigned to Schedule 19 Projects)

GP= gross plant allocator (allocated gross Schedule 19 Projects plant as % of electric and common plant)

GPE= gross electric plant allocator (allocated gross Schedule 19 Projects plant as % of total electric gross plant)

S19P= Schedule 19 Projects plant allocator (Schedule 19 Projects gross plant as % of total transmission gross plant)

S19 W/S= Schedule 19 Projects wage and salary allocator (Schedule 19 Projects wages and salaries as % of total electric wages and salaries)

S19 W/ST Schedule 19 Projects wages and salary allocator for transmission (Schedule 19 Projects wages and salaries as a % of transmission wages and salaries)
NA= not applicable (the item is not applicable to Schedule 19 Projects ATRR)

TPE= transmission plant allocator (transmission plant as % of electric)

T W/S= transmission wages and salaries as % of electric wages and salaries

LNYSEG will exclude items in Account 930.2 shown on FF1 page 335 that are greater than $1 M and not directly or indirectly related to its transmission assets.

MNYSEG either will direct assign O&M expense that have been tracked for the Schedule 19 Projects or allocate transmission O&M to the Schedule 19 Projects, but not both.

NIn accordance with the NYISO OATT, Section 14.1.5, the gross receipts tax included in Schedule 19 Project ATRR is as follows:

Total

Gross receipt tax rate0.0000%

Revenue requirement-Estimate of Line 84

Gross Receipts Tax-

OMay include CWIP in rate base as authorized by FERC.

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 1: Average Balances for Most Rate Base Items
Actual for the 12 Months Ended 12/31/2021

 

Five Quarter AveragesGross Operating Property

(a1)(a2)(b)(c)(d)(e)(f)(g)(h)(i)(j)(k)(l)(m)

(n)(o)(p)(q)

Schedule 19 Projects

 

MonthYearElectric IntangibleProductionTransmissionDistributionElectric GeneralCommonProject 1Project 2Project 3Project 4Total

FF1 Reference204-207, line 5 fn204-207, lines 16, 25, 35204-207, line 58 fn204-207, Line 75 fn204-207, l. 99 fn355 fn204-207, line 58 fn204-207, line 58 fn204-207, line 58 fn204-207, line 58 fn204-207, line 58 fnSum of Columns (h)

and 46 fnthrough (l)

Appendix A Line #512346222222

1December2020------------

2March2021------------

3June2021------------

4September2021------------

5December2021------------

6Average------------

Note:  Exclude Asset Retirement Obligations

 

 

Accumulated Depreciation

Schedule 19 Projects

 

MonthYearElectric IntangibleProductionTransmissionDistributionElectric GeneralCommonProject 1Project 2Project 3Project 4Total

 

 

FF1 Reference200-201.21c219, lines. 20-24 fn219, line 25 fn219, line 26 fn219, line 28 fn355 fn219, line 25 fn219, line 25 fn219, line 25 fn219, line 25 fn219, line 25 fnSum of Columns (h)through (l)

 

Appendix A Line #13910111214101010101010

7December2020------------

8March2021------------

9June2021------------

10September2021------------

11December2021------------

12Average-----------0

 

 

Miscellaneous Rate Base Items

Schedule 19 Projects - CWIPAccumulatedUnfunded Liabilities

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

Project 1
Month

 

 

 

FF1 Reference216 fn

Appendix A Line #23

13December2020-

14March2021-

15June2021-

16September2021-

17December2021-

18Average-

 

 

 

 

 

MonthAccrued Vacation

FF1 ReferenceNA

Appendix A Line #NA

19December2020-

20March2021-

21June2021-

22September2021-

23 December2021-
24 Average -


 

Project 2Project 3Project 4

 

 

 

 

216 fn216 fn216 fn

232323

---

---

---

---

---

---

 

 

 

 

 

Unfunded Liabilities - Account 242
Other Total

NA
NA

--

--

--

--

--

--


Transmission Land Held

Totalfor Future Use

 

 

 

214, line 17 fn

216 fn

232328

0--

0--

0--

0--

0--

---


Schedule 19 Projects -Schedule 19 Projects -Materials & Supplies -

Land Held for Future UseAbandoned PlantTransmission

 

 

214, line TBD230b, line TBD227, Line 8 fn

 

282430

---

---

---

---

---

---


Materials and Supplies -Regulatory

Assigned to ConstructionPrepaymentsAsset - Removal

(Electric and Gas)Costs

 

 

227, line 5 fn110-111, line 57 fn232 fn

 

313233

---

---

---

---

---

---


Provision forMiscellaneous

Injuries andCurrent and

DamagesAccrued LiabilitiesTotal

 

Sum of Columns

112-113, line 28 Account 242 - see  (o) through (p)

fnbelow

34

---

---

---

---

---

---

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

1-RB Items

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 2a: Accumulated Deferred Income Taxes (ADIT) Worksheet - Current Year
Actual for the 12 Months Ended 12/31/2021

 

 

(a)(b)(c)(d)(e)(f)(g)(h)

Schedule 19

ProjectsPlantLaborTotal

Nonprorated ItemsRelatedRelatedADIT

Current Year

1ADIT-190000(Line 23)

2ADIT-282000(Line 29)

3ADIT-283000(Line 37)

4Subtotal000(Line 1 + Line 2 + Line 3)

5Schedule 19 Projects W/S Allocator#DIV/0!Appendix A

6GP Allocator#DIV/0!Appendix A

7End of  Year ADIT0#DIV/0!#DIV/0!#DIV/0!(Line 4 * Line 5 or Line 6)

8End of  Previous Year ADIT0#DIV/0!#DIV/0!#DIV/0!W orksheet 2b, Line 7

9Average Beginning and End of Year0#DIV/0!#DIV/0!#DIV/0!(Average of Line 7 + Line 8)

10Prorated ADIT#DIV/0!From Worksheet 2c, Line 14, Col. (r) or Worksheet 2d, Line 13, Col. (n)

11Total ADIT#DIV/0!Line 9 + Line 10

 

 

 

In filling out this attachment, a full and complete description of each item and justification for the allocation to Columns B-G and each separate ADIT item will be listed,

dissimilar items with amounts exceeding $100,000 will be listed separately;

 

(a)(b)(c)(d)(e)(f)(g)(h)

ADIT-190 - Includes Only Items Applicable to ScheduleSchedule 19

19 ProjectsProjectsPlantLabor

TotalExcludedRelatedRelatedRelatedJustification

1100000

1200000

1300000

1400000

1500000

1600000

1700000

1800000

1900000

2000000

2100000

2200000

23Total00000

Instructions for Account 190:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

 

New York State Electric and Gas Corporation

Workpaper 2a: Accumulated Deferred Income Taxes (ADIT) Worksheet - Current Year

 

 

(a)(b)(c)(d)(e)(f)(g)(h)

ADIT- 282 - Includes Only Items Applicable to ScheduleSchedule 19

19 ProjectsTotalProjectsPlantLabor

ExcludedRelatedRelatedRelatedJustification

24Depreciation - Liberalized Depreciation - Prorated#DIV/0!0#DIV/0!00W orksheet 2c, Line 14, Col. (r)

250

260

270

2800000

29Total#DIV/0!0#DIV/0!00

Instructions for Account 282:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

 

 

New York State Electric and Gas Corporation

Workpaper 2a: Accumulated Deferred Income Taxes (ADIT) Worksheet - Current Year

 

(a)(b)(c)(d)(e)(f)(g)(h)

ADIT-283 - Includes Only Items Applicable to ScheduleSchedule 19

19 ProjectsTotalProjectsPlantLabor

ExcludedRelatedJustification

30Cost of Removal0000

3100

320

330

340

350

360

37Total00000

 

Instructions for Account 283:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

 

 

 

 

 

 

 

 

 

 

 

2a-ADIT Current Year

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Worksheet - Prior Year
Actual for the 12 Months Ended 12/31/2021

 

 

(a)(b)(c)(d)(e)(f)(g)(h)

Schedule 19

ProjectsPlantLaborTotal

Nonprorated ItemsRelatedRelatedADIT

Prior Year

1ADIT-190000(Line 20)

2ADIT-282000(Line 26)

3ADIT-283000(Line 34)

4Subtotal000(Line 1 + Line 2 + Line 3)

5Schedule 19 Projects W/S Allocator#DIV/0!Appendix A

6GP Allocator#DIV/0!Appendix A

7Prior Year ADIT0#DIV/0!#DIV/0!#DIV/0!(Line 4 * Line 5 or Line 6)

 

 

In filling out this attachment, a full and complete description of each item and justification for the allocation to Columns B-G and each separate ADIT item will be listed,

dissimilar items with amounts exceeding $100,000 will be listed separately;

 

(a)(b)(c)(d)(e)(f)(g)

ADIT-190 - Includes Only Items Applicable to ScheduleSchedule 19

19 ProjectsProjectsPlantLabor

TotalExcludedRelatedRelatedRelatedJustification

800000

900000

1000000

1100000

1200000

1300000

1400000

1500000

1600000

1700000

1800000

1900000

20Total00000

Instructions for Account 190:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

 

New York State Electric and Gas Corporation

Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Worksheet - Prior Year

 

(a)(b)(c)(d)(e)(f)(g)

 

ADIT- 282 - Includes Only Items Applicable toSchedule 19

Schedule 19 ProjectsProjectsPlantLaborG

ExcludedRelatedRelatedRelatedJustification

21Depreciation - Liberalized Depreciation - Prorated#DIV/0!0#DIV/0!00Worksheet 2d, Line 13, Col. (n)

2200

230

240

2500000

26Total#DIV/0!0#DIV/0!00

Instructions for Account 282:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

 

 

 

New York State Electric and Gas Corporation

Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Worksheet - Prior Year

 

(a)(b)(c)(d)(e)(f)(g)

ADIT-283 - Includes Only Items Applicable to ScheduleSchedule 19

19 ProjectsTotalProjectsPlantLabor

ExcludedRelatedRelatedRelatedJustification

27Cost of Removal0000

2800

290

300

310

320

330

34Total00000

 

Instructions for Account 283:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 2c: Accumulated Deferred Income Taxes - Prorated Projection
Actual for the 12 Months Ended 12/31/2021

 

Rate Year =Debit amounts are shown as positive and credit amounts are shown as negative.

Account 282 (Note A)

(a)(b)(c)(d)(e)(f)(g)(h)(i)(j)(k)(l)(m)(n)(o)(p)(q)(r)

Beginning Balance & MonthlyYearDays in theNumber of DaysTotal DaysWeightingBeginningSchedule 19TransmissionPlant Related   Gross PlantPlantPlant ProrationLaborW/SLaborLaborTotal Transmission

ChangesMonthRemaining inin theforBalance/ProjectsProrationAllocatorAllocation(j)(f) x (l)RelatedAllocatorAllocationProrationProrated Amount(i)

Year AfterProjectedProjectionMonthly Amount/(f) x (h)(Appendix A)* (k)(General(Appendix(n) * (o)(f) x (p)+ (m) + (q)

Current MonthRate Year(d)/(e)Ending BalanceandA)

Line #Common)

 

December 31st balance of Prorated

1ADIT (Note B)2020100.00%#DIV/0!#DIV/0!#DIV/0!#DIV/0!

2January20213133536591.78%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

3February20212830736584.11%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

4March20213127636575.62%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

5April20213024636567.40%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

6May20213121536558.90%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

7June20213018536550.68%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

8July20213115436542.19%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

9August20213112336533.70%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

10September2021309336525.48%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

11October2021316236516.99%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

12November202130323658.77%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

13December20213113650.27%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

14Prorated Balance365#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!

 

Note A:  The calculations of ADIT amounts resulting from liberalized depreciations are performed in accordance with the proration requirements of Treasury Regulation Section 1.167(l)-1(h)(6). Note B:  From Worksheet 2d-Prior Year ADIT Proration Actual

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 2d: Accumulated Deferred Income Taxes - Actual Proration
Actual for the 12 Months Ended 12/31/2021

 

Year =2021

Debit amounts are shown as positive and credit amounts are shown as negative.

 

 

Account 282 (Note A)

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

Days in PeriodProjection - Proration of Projected Deferred Tax

(a)(b)(c)(d)(e)(f)(g)(h)


Actual Activity - Proration of Projected Deferred Tax Activity and Averaging of Other Deferred Tax Activity
(i) (j) (k) (l) (m) (n)

Difference between  Actual activity (Col I)

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

Month


Number of
Days

Remaining in Total Days in

Days in theYear After  Projected Rate

MonthMonth'sYear (Line 14,

Accrual ofCol b)

Deferred
Taxes


 

ProrationProjectedProratedProrated Projected

PercentageMonthlyAmount(e)BalanceSum

(c)/(d)Activity* (f)of (g)


DifferencePreserve proration

when actual

betweenmonthly and

Actual Monthlyprojected

Activity(tablemonthly and  projected monthly

activity are either

below, grand total)actual monthly  both increases or

activity(i) -decreases.

(f)
(See Note A)


projected andwhen projected activity

actual activity when  is an increase while

actual andactual activity is aBalance reflecting

projected activity  decrease OR projected proration or averaging  (n)

are either bothactivity is a decrease+ (k) +((l) + (m))/2

increases orwhile actual activity is

decreases.an increase.
(See Note A) (See Note A)

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

1 December 31st balance00

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

2 January3133536591.78%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

3 February2830736584.11%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

4 March3127636575.62%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

5 April3024636567.40%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

6 May3121536558.90%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

7 June3018536550.68%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

8 July3115436542.19%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

9 August3112336533.70%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

10 September309336525.48%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

11 October316236516.99%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

12 November30323658.77%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

13 December3113650.27%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

14 Total36500#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

 

Gross PlantLabor Related

Schedule 19Allocator(General andW/S Allocator (AppendixGrand Total (b) +

ProjectsPlant Related(Appendix A)  Total (d) * (e)Common)A)Total (g) * (h)(f) + (i)

Actual Monthly Activity

15 January00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

16 February00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

17 March00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

18 April00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

19 May00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

20 June00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

21 July00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

22 August00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

23 September00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

24 October00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

25 November00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

26 December00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

 

Note A:  The calculations of ADIT amounts resulting from liberalized depreciations are performed in accordance with the proration requirements of Treasury Regulation Section 1.167(l)-1(h)(6).

Differences attributable to over-projection of ADIT in the annual projection will result in a proportionate reversal of the projected prorated ADIT activity to the extent of the over-projection.

Differences attributable to under-projection of ADIT in the annual projection will result in an adjustment to the projected prorated ADIT activity by the difference between the projected monthly activity and the actual monthly activity. However, when projected monthly ADIT activity is an increase and actual monthly ADIT activity is a decrease, actual monthly ADIT activity will be used.
Likewise, when projected monthly ADIT activity is a decrease and actual monthly ADIT activity is an increase, actual monthly ADIT activity will be used.

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 3: Excess Accumulated Deferred Income Taxes
Resulting from Income Tax Rate Changes (Note A)
Actual for the 12 Months Ended 12/31/2021

 

Debit amounts are shown as positive and credit amounts are shown as negative.

(a)(b)(c)(d)(e)(f)(g)(h)(i)(j)(k)(l)(m)(n)

 

 

Protected (P)

AdjustedUnprotected

Deficient orDeficient orProperty

ADIT BalancesExcessExcessSchedule 19(UP)

ADIT BalancesAfterAccumulatedAccumulatedProjectsAllocated toUnprotected

Prior toRemeasurementDeferred TaxesAdjustments AfterDeferredAllocationSchedule 19Other (UO)AmortizationBalance atAmortizationBalance at

LineDescriptionRemeasurement(Note C)at December 31,RemeasurementTaxesFactors (Note B)Projects(Note B)YearDecember 31YearDecember 31

Column (b) * LineColumn (b) -Column (d) +Column (f) *Column (h) -Column (k) -

43Column (c)Column (e)Column (g)Column (j)Column (l)

Deficient Deferred Income Taxes -

amortized to 410.1

FERC Account 190

1000000.000%00000

2000000.000%00000

3000000.000%00000

4000000.000%00000

5000000.000%00000

6Total FERC Account 1900000000000

 

FERC Account 282

7000000.000%00000

8000000.000%00000

9000000.000%00000

10000000.000%00000

11Total Account 2820000000000

 

FERC Account 283

12000000.000%00000

13000000.000%00000

14000000.000%00000

15000000.000%00000

16000000.000%00000

17Total FERC Account 2830000000000

 

Subtotal Before Being Grossed up for Income

18Taxes0000000

19Gross Up00000

Total Deficient Accumulated Deferred Income

20Taxes - Account 182.300000

 

 

Excess Accumulated Deferred Income

Taxes - amortized to 411.1

FERC Account 190

21000000.000%00000

22000000.000%00000

23Total Account 1900000000000

 

FERC Account 282

24Accelerated Depreciation000000.000%0P0000

25000000.000%00000

26000000.000%00000

27000000.000%00000

28000000.000%00000

29Total Account 2820000000000

 

FERC Account 283

30000000.000%00000

31000000.000%00000

32000000.000%00000

33000000.000%00000

34000000.000%00000

35Total Account 2830000000000

 

Subtotal Before Being Grossed up for Income

36Taxes0000000

37Gross Up00000

Total Excess Accumulated Deferred Income

38Taxes - Account 25400000

 

39Grand Total00000

 

40Total Amortization0

 

Note A:  Includes Excess Deferred Income Tax Regulatory Assets or Liabilities and the associated amortization arising from income tax rate changes.  This sheet will be populated and replicated for changes in federal, state or local income tax rates impacting Schedule 19
Project ADITs.

Note B:  The allocation factors used to allocate total excess accumulated deferred income taxes to local transmission projections are (to be completed when used) Note C:  Remeasurement Factor equals the ratio of the current nominal tax rate to the prior nominal tax rate

41New nominal rate1.0%

42Prior nominal rate1.0%

43Remeasurement Factor100.0%

Note D:
Note E:
Note F:

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

New York State Electric and Gas Corporation
Workpaper 4: Permanent Book/Tax Differences
Actual for the 12 Months Ended 12/31/2021

 

 

(a)(b)(c)(d)(e)

Tax Effect ofAFUDC EquityOther 2Other 3Total

PermanentSchedule 19

Book/TaxProjects

Line #Differences

FF1 Reference

1Amount-00-

 

2Income Tax Effect-00-

Line 1 *Line 1 *Sum of

Line 1 * IncomeIncome TaxIncome TaxColumns (b), (c)

RefTax FactorFactorFactorand (d)

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation
Workpaper 5: Schedule 19 Project Return
Actual for the 12 Months Ended 12/31/2021

 

 

(a)(b)(c)(d)(e)(f)(g)(h)(i)(j)(k)(l)(m)(n)(o)

Five Quarter AverageAllocate Other Rate Base Items to Schedule 19 Projects

NetAccumulated

IntangibleNet CommonDeferredLand Held for

Net GeneralPlant -  -Plant -  -AbandonedIncome Taxes -(Excess)/DeficientFuture Use -Other Rate Base

Gross Plant inAccumulatedNet OperatingPlant - UsingUsingUsingPlant - UsingUsingADIT - UsingUsingItems - Using

Line #ServiceAllocatorDepreciationPropertyAllocatorAllocatorAllocatorCWIPAllocatorAllocatorAllocatorAllocatorAllocatorTotal Rate Base

 

Workpaper 1,Workpaper 1,Col. (b) - Col.Line 6 * Col.Line 6 * Col.Line 6 * Col.Workpaper 1,Workpaper 1,Line 6 * Col.Line 6 * Col.Sum of Col. (e)

ReferenceProjectLine 6CalculatedLine 12(d)(c)(c)(c)Line 18Line 18(c)Line 6 * Col. (c)(c)Line 6 * Col. (c)through Col. (n)

 

1Grouping 1-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

Project

2Grouping 2-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

Project

3Grouping 3-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

Project

4Grouping 4-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

5#DIV/0!-#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

6Total-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!00#DIV/0!0-#DIV/0!#DIV/0!

Appendix A,Appendix A,Appendix A,Workpaper 1,Workpaper 1,Appendix A,Appendix A,Appendix A, Line

RefLine 19Line 20Line 21Line 18Line 18Line 25Appendix A, Line 26Line 2835

 

 

Weighted

Preferred andPreferred and

CommonCommonWeighted

Rate BaseWACCReturnEquity RateEquity ReturnDebt RateDebt Return

Attachment 6,

Lines 2 + 3,

Attachment 6,Lines 6 + 7,Attachment 6,

Line 4, Line 8,Lines 10 + 11Line 1, Line 5,

Line 12, orCol. (b) * Col.or Lines 14 +Col. (b) * Col.Line 9 or LineCol. (b) * Col.

ReferenceCol. (o)Line 16(c)15(e)13(h)

Project

7Grouping 1#DIV/0!#DIV/0!#DIV/0!0.00%#DIV/0!#DIV/0!#DIV/0!

 

Project

8Grouping 2#DIV/0!#DIV/0!#DIV/0!0.00%#DIV/0!#DIV/0!#DIV/0!

 

Project

9Grouping 3#DIV/0!#DIV/0!#DIV/0!0.00%#DIV/0!#DIV/0!#DIV/0!

 

Project

10Grouping 4#DIV/0!#DIV/0!#DIV/0!0.00%#DIV/0!#DIV/0!#DIV/0!

 

11#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

12Total#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

 

 

Schedule 19 Projects Included in Each Project Group

ProjectProjectGross

NameDescriptionInvestment

Project

Grouping 1

 

 

 

 

 

 

 

 

 

 

Project

Grouping 2

 

 

 

 

 

 

 

 

 

 

 

 

Project

Grouping 3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project

Grouping 4

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

6-Project Cost of Capital

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 6: Schedule 19 Project Cost of Capital
Actual for the 12 Months Ended 12/31/2021

 

(a)(b)(c)(d)(e)(f)(g)(h)(i)(j)

Line #Project Grouping 1(Note A)

Capitalization%sCost RatesWACC

1Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

2Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

3Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 1 and 2,

4Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Project Grouping 2

Capitalization%sCost RatesWACC

5Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

6Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

7Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 5 and 6,

8Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Project Grouping 3

Capitalization%sCost RatesWACC

9Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

10Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

11Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 9 and 10,

12Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Project Grouping 4

Capitalization%sCost RatesWACC

13Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Docket No.0.00%

14Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

15Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 13 and 14,

16Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Common EquityLong-term Debt

Less:

Accumulated

OtherCommon EquityUnamortizedUnamortized LossLong-term

Less: PreferredComprehensiveforGains onUnamortized Debton ReacquiredDebt for

TotalStockIncomeCapitalizationTotalReacquired DebtExpenseDebtCapitalization

 

Col. (a) - Col. (b)Col. (e) + Col.

MonthYear112-113, l.16, fn112-113, l.3, fn112-113, l.15, fn- Col. (c)112-113, l.24, fn112-113, l.61, fn112-113, l.69, fn112-113, l.81, fn(f) - Col. (g) - (h)

17December2020-----

18March2021-----

19June2021-----

20September2021-----

21December2021-----

22Average-

 

 

 

(114-117c, sum

of lines 62, 63,

23Long Term Interest64, 65, 66)0

 

24Long-Term Debt(Line 22, Col. (i))0

(Line 23 / Line

25Long-term Debt Interest Rate24)#DIV/0!

 

26Preferred Dividends118-119c, l.29-

 

27Preferred Stock(Line 22 Col. (b))-

(Line 26 / Line

28Preferred Stock Rate27)0

 

Note A:  The above common equity, preferred stock and long-term debt amounts are not used for capital structure purposes since the CSRA requires use of the NYPSC approved capital structure.

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 7: True-up Adjustment for Schedule 19 Projects
Actual for the 12 Months Ended 12/31/2021

 

Debit amounts are shown as positive and credit amounts are shown as negative.

The Annual True-Up Adjustment ("ATU") component of the Formula Rate for each Year shall be determined as follows:

 

(i) In accordance with its formula rate protocols, NYSEG shall recalculate its Annual Transmission

Revenue Requirement ("ATRR") for the previous calendar year based on its actual costs as reflected in its Form No. 1 and its books and records for that calendar year, consistent with FERC accounting policies.

 

(ii)Determine the difference between the Actual ATRR as determined in paragraph (i) above,

and actual revenues based upon the Projected ATRR for the previous calendar year

 

(iii)Multiply the ATRR Before Interest by (1+i)^24 months

 

Where:i =Average of the monthly rates from the middle of the Rate Year for which the ATU

is being calculated through the middle of the year in which the ATU is included in rates (24 months) The interest rates are initially estimated and then trued-up to actual

 

 

To the extent possible each input to the Formula Rate used to calculate the Actual ATRR

will be taken directly from the FERC Form No. 1 or will be reconcilable to the FERC Form 1
by the application of clearly identified and supported information.  If the reconciliation

is provided through a worksheet included in the filed Formula Rate Template, the inputs to the worksheet must meet this transparency standard, and doing so will satisfy this transparency requirement for the amounts that are output from the worksheet and input to the main body of the Formula Rate.

 

 

Line

Interest

EstimatedActual InterestRate True-

Interest RateRateUp

1AATRR based on actual costs included for the previous calendar year0

2BRevenues based upon the Projected ATRR for the previous calendar year and excluding any true-up adjustment0

3CDifference  (A-B)00

4DFuture Value Factor (1+i)^241.00001.00000

5ETrue-up Adjustment(C*D)00

6FInterest Rate True-up from Prior Periods0

7GATU Adjustment with Interest Rate True-up From Prior Periods0

 

Where:

i= average interest rate as calculated below

 

Interest on Amount of Refunds or SurchargesEstimatedActual

MonthlyMonthly

MonthYearInterest RateInterest Rate

8JulyYear 10.0000%0.0000%

9AugustYear 10.0000%0.0000%

10SeptemberYear 10.0000%0.0000%

11OctoberYear 10.0000%0.0000%

12NovemberYear 10.0000%0.0000%

13DecemberYear 10.0000%0.0000%

14JanuaryYear 20.0000%0.0000%

15FebruaryYear 20.0000%0.0000%

16MarchYear 20.0000%0.0000%

17AprilYear 20.0000%0.0000%

18MayYear 20.0000%0.0000%

19JuneYear 20.0000%0.0000%

20JulyYear 20.0000%0.0000%

21AugustYear 20.0000%0.0000%

22SeptemberYear 20.0000%0.0000%

23OctoberYear 20.0000%0.0000%

24NovemberYear 20.0000%0.0000%

25DecemberYear 20.0000%0.0000%

26JanuaryYear 30.0000%0.0000%

27FebruaryYear 30.0000%0.0000%

28MarchYear 30.0000%0.0000%

29AprilYear 30.0000%0.0000%

30MayYear 30.0000%0.0000%

31JuneYear 30.0000%0.0000%

 

32Average0.00000%0.00000%

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

New York State Electric and Gas Corporation

Workpaper 8: Electric and Common Depreciation and Amortization Rates
Actual for the 12 Months Ended 12/31/2021

 

 

 

FERC AccountDescriptionRate (Note 1)

 

Transmission

350Land RightsNA

352Structures and Improvements1.79%

353Station Equipment1.69%

354Towers and Fixtures1.63%

355Poles and Fixtures2.07%

356Overhead Conductors & Devices2.21%

357Underground Conduit1.54%

358Underground Conductors & Devices1.83%

359Roads and TrailsNA

 

Electric General and Intangible

302Franchises and ConsentsNA

303Intangible Plant9.14%

390Structures and Improvements1.77%

391Office Furniture and Equipment5.00%

391.2Computer Equipment9.14%

392.1Transportation Equipment - Auto9.50%

393Stores Equipment2.56%

394Tools, Shop and Garage Equipment4.00%

395Laboratory Equipment3.66%

396Power Operated Equipment8.18%

396.1Power Operated Equipment - Vehicle6.67%

397Communication Equipment5.75%

397.1Communication Equipment - Overhead2.86%

398Miscellaneous Equipment2.95%

 

Common

302Franchises and ConsentsNA

303Intangible Plant11.33%

390Structures and Improvements1.64%

391Office Furniture and Equipment4.32%

391.2Computer Equipment11.33%

391.4LANs/WANs14.29%

392Transportation Equipment - Auto9.00%

392.1Transportation Equipment - In Reserve10.00%

393Stores Equipment1.55%

394Tools, Shop and Garage Equipment3.09%

395Laboratory Equipment5.00%

397Communication Equipment6.67%

398Miscellaneous Equipment4.91%

 

Note 1:  The above depreciation rates cannot change absent Commission authorization

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.6.2.2 OATT Schedule 19 - New York State Electric and Ga

 

 

 

 

 

New York State Electric and Gas Corporation
Workpaper 9: Prior Period Corrections Actual for the 12 Months Ended 12/31/2021

 

Debit amounts are shown as positive and credit amounts are shown as negative.

(a)(b)

Calendar Year

Revenue

LineImpact ofRevenue

No.DescriptionSourceCorrectionRequirement

 

1Filing Name and Date

2Original Revenue Requirement0

 

3Description of Correction 10

4Description of Correction 20

 

 

5Total Corrections(Line 3 + Line 4)0

 

6Corrected Revenue Requirement(Line 2 + Line 5)0

 

7Total Corrections(Line 5)0

 

8Average Monthly FERC Refund RateNote A0.00%

9Number of Months of InterestNote B0

10(Line 7 * Line 8 *

Interest on CorrectionLine 9)0

 

11Sum of Corrections Plus Interest(Line 7 + Line 10)0

 

 

Notes:

A The interest rate on corrections will be the average monthly FERC interest rate for the period from the beginning of the year being

corrected through the end of the rate year where the correction is reflected in rates - the same as how interest on the Annual Trueup Adjustment is computed.

B The number of months in which interest is computed is from the middle of the rate year in which the correction is needed to the

middle of the rate year where the correction is reflected in rates - the same as how interest on the Annual True-up Adjustment is
computed.

 

Effective Date: 7/3/2023 - Docket #: ER23-1816-000 - Page 1