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

Workpaper Tab

Description

A

Appendix A

Annual Transmission Revenue Requirement for Schedule 19 Projects

1

RB Items

Average Balances for Most Rate Base Items

2a

2b

2c

2d

3

ADIT-Current Year

ADIT-Prior Year

Current Year Average Accumulated Deferred Income Taxes

Prior Year Average Accumulated Deferred Income Taxes

ADIT Proration Projected

ADIT Proration Actual

EADIT

Proration of Projected Accumulated Deferred Income Taxes

Proration of Actual Accumulated Deferred Income Taxes

Excess Accumulated Deferred Income Tax Rate Base and Amortization

Permanent Book/Tax Differences

4

IT Permanent Differences

Project Return

5

Return on Schedule 19 Projects

6

Project Cost Of Capital

True-up Adjustment

Schedule 19 Projects Cost of Capital

7

Annual True-up Adjustment

Depreciation Rates Approved by the Commission and Used to Determine Schedule

19 Projects Depreciation and Amortization Expense

8

9

Depreciation Rates

Corrections

Prior Period Corrections

Page 1 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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-Levelized

Transmission Formula Rate Template

Utilizing FERC Form 1 Data

Actual for the 12 Months Ended 12/31/2021

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

Schedule 19

Projects (Col. 3 *

Col. 4)

Form No. 1 or Transmission

Formula Rate Reference

Company Total (where

applicable)

No. RATE BASE (Note A):

Allocator (Note K)

GROSS PLANT IN SERVICE

1

Production

Workpaper 1, Line 6, Col. (c)

Workpaper 1, Line 6, Col. (d) or Col.

(m)

0

NA

0

2

3

4

5

6

7

8

Transmission

Distribution

Electric General

Electric Intangible

Common

0

0

0

0

0

0

0

DA

NA

0

0

Workpaper 1, Line 6, Col. (e)

Workpaper 1, Line 6, Col. (f)

Workpaper 1, Line 6, Col. (b)

Workpaper 1, Line 6, Col. (g)

S19 W/S

S19 W/S

CP*S19 W/S

GP=

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

TOTAL GROSS PLANT

Without Common - For Gross Plant Allocator Calculation Only

(Sum of Lines 1 through 6)

GPE=

ACCUMULATED DEPRECIATION

9

Production

Workpaper 1, Line 12, Col. (c)

-

NA

0

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

(m)

10

11

12

13

14

Transmission

Distribution

Electric General

Electric Intangible

Common

-

-

-

-

-

-

DA

NA

-

0

Workpaper 1, Line 12, Col. (e)

Workpaper 1, Line 12, Col. (f)

Workpaper 1, Line 12, Col. (b)

Workpaper 1, Line 12, Col. (g)

(Sum of Lines 9 through 14)

S19 W/S

S19 W/S

CP*S19 W/S

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

15 TOTAL ACCUM. DEPRECIATION

NET PLANT IN SERVICE

16

17

18

19

20

21

Production

Transmission

Distribution

General

Intangible

Common

(Line 1 - Line 9)

(Line 2 - Line 10)

(Line 3 - Line 11)

(Line 4 - Line 12)

(Line 5 - Line 13)

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

(Line 6 - Line 14)

22 TOTAL NET PLANT

(Sum of Lines 16 through 21)

23 CWIP

Workpaper 1, Line 18, Col. (g)

Workpaper 1, Line 18, Col. (j)

NA

NA

0

0

24 ABANDONED PLANT

ACCUMULATED DEFERRED INCOME

TAXES (Note B)

25

Accumulated Deferred Income Taxes

Excess Accumulated Deferred Income

Workpaper 2a, Line 11, Col. (g)

Workpaper 3

NA

NA

#DIV/0!

26 Taxes

TOTAL ACCUMULATED DEFERRED

0

27 INCOME TAXES

(Line 25 + Line 26)

#DIV/0!

0

28 LAND HELD FOR FUTURE USE

OTHER RATE BASE ITEMS

Workpaper 1, Line 18, Col. (h) or (i)

0

0

DA

29

30

Cash Working Capital (Note C)

Materials & Supplies - Transmission

Materials and Supplies - Electric and Gas -

(Line 49 times 45/360)

Workpaper 1, Line 18, Col. (k)

NA

#DIV/0!

#DIV/0!

S19P

#DIV/0!

31 Assigned to Construction

Workpaper 1, Line 18, Col. (l)

Workpaper 1, Line 18, Col. (m)

Workpaper 1, Line 18, Col. (p)

(Sum of Lines 29 through 33)

0

0

CP*GPE

CP*GPE

CP*S19 W/S

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

32

33

Prepayments

Unfunded Liabilities

-

34 TOTAL OTHER RATE BASE ITEMS

NA

NA

35 RATE BASE

(Line 22+ Line 27 + Line 28 + Line 34)

#DIV/0!

Formula Rate - Non-Levelized

Rate Formula Template

Actual 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

Projects (Col. 3 *

Col. 4)

Line

ANNUAL TRANSMISSION REVENUE

No. REQUIREMENT

Form No. 1 or Transmission

Formula Rate Reference

Company Total (where

applicable)

Allocator (Note K)

(Col 3 times Col 4)

OPERATIONS AND MAINTENANCE

EXPENSES (Note M)

36

37

38

Transmission - Direct Assign

Transmission - Allocate

Less: EPRI Dues in Account 566

320-323.112.b fn

320-323.112.b fn

352-353

Line 37 - Line 38

320-323.197.b

352-353

320-323.189.b

320-323.185.b

Note L

0

DA

0

0

0

0

0

0

0

0

0

39 Subtotal - Transmission to Allocate

40 Electric A&G

41

42

43

44

S19P

#DIV/0!

#DIV/0!

Less: EPRI Dues in A&G

Less: Regulatory Commission Expenses

Less: Property Insurance

Less: Account 930.2 Items

Line 40 - Line 41 - Line 42 - Line 43 -

45

Adjusted Electric A&G

Plus: Transmission Related Regulatory

Line 44

0

0

S19 W/S

S19P

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

46 Expenses

Plus: Direct Assigned Regulatory

47 Commission Expenses (Note E)

48 Plus: Property Insurance

350-351 fn

350-351 fn

320-323.185.b

NA

DA

GPE

0

0

#DIV/0!

#DIV/0!

Page 2 of 16


Sum of Lines 36, 39 and 45 through

48

49 TOTAL O&M

DEPRECIATION AND AMORTIZATION EXPENSE

NA

NA

NA

#DIV/0!

50

51

52

53

54

Transmission

Electric General

Electric Intangible

Common Electric

Amortization of Abandoned Plant

336.7.f, fn

336.10 f

336.1.d

336.11.f

230a fn

0

0

0

0

DA

0

0

S19 W/S

S19 W/S

S19 W/S

DA

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

55 TOTAL DEPRECIATION

Sum of Lines 50 through 54

0

#DIV/0!

TAXES OTHER THAN INCOME TAXES

LABOR RELATED

56

57

58

59

60

61

Payroll (Note D)

PLANT RELATED

Real Estate

262-263.9.l+262-263.17.l

0

CP*S19 W/S

#DIV/0!

#DIV/0!

#DIV/0!

262-263.5.l

262-263

0

0

CP*GPE

CP*GPE

Note N

#DIV/0!

#DIV/0!

Franchise Tax

Gross Receipts Tax

Other

#DIV/0!

0

0

262-263

Sum of Lines 56 and 58 through 61

0

0

62 TOTAL OTHER TAXES

#DIV/0!

INCOME TAXES (Note F)

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

SIT * FIT * p)}=

1 / (1 - T)

63 Composite Tax Rate = T

64 Gross-up Factor

65 Income Tax Factor

0.0000%

0.0000

0.0000

T/(1-T)

Amortization of Investment Tax Credit (enter

66 negative)

Amortization of Excess Deferred Income

67 Taxes (enter negative)

68 Tax Effect of Permanent Differences

69 Income Tax Calculation

70 ITC adjustment

266-267.11. f, fn

NA

DA

0

0

Workpaper 3

Workpaper 4, Line 2, Col. (e)

(Line 75 * Line 65)

NA

NA

NA

NA

DA

DA

Calc

Calc

-

#DIV/0!

(Line 66 * Line 64)

0

Amortization of Excess Deferred Income Tax

71 Adjustment

72 Permanent Differences Tax Adjustment

73 TOTAL INCOME TAXES

(Line 67 * Line 64)

(Line 68 * Line 64)

Sum of Lines 69 through 72

NA

NA

NA

Calc

Calc

0

0

#DIV/0!

RETURN (Note H)

74

Debt

Workpaper 5, Line 12, Col. (i)

Workpaper 5, Line 12, Col. (f)

Sum of Lines 74 through 75

NA

NA

NA

Calc

Calc

#DIV/0!

#DIV/0!

#DIV/0!

75 Common Equity and Preferred Stock

76 TOTAL RETURN

ANNUAL TRANSMISSION REVENUE

REQUIREMENT BEFORE REVENUE

77 CREDITS

(Line 49 + Line 55 + Line 62 + Line 73 +

Line 76)

DA

DA

#DIV/0!

#DIV/0!

78 REVENUE CREDITS

(Line 102)

-

ANNUAL TRANSMISSION REVENUE

79 REQUIREMENT (ATRR)

(Line 77 + Line 78)

NA

NA

80 CORRECTIONS

Workpaper 9, Line 11, Col. (b)

0

0

ANNUAL TRUE-UP ADJUSTMENT (ATU)

81 (Note G)

Workpaper 7, Line 5

NA

NA

82 ATRR PLUS ATU AND CORRECTIONS

Sum of Lines 79 through 81

#DIV/0!

Formula Rate - Non-Levelized

Rate Formula Template

Actual 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

83 Electric Plant

84 Total Transmission Plant

85 Schedule 19 Projects

(Line 97)

(Line 2)

(Line 2)

0

0

0

86 Schedule 19 Projects Plant Allocator

87 Transmission Plant Allocator

(Line 85 / Line 84)

(Line 84 / Line 83)

#DIV/0! S19P

#DIV/0! TP

ELECTRIC WAGE AND SALARY

ALLOCATOR

88

89

90

91

92

Production

Transmission

Distribution

Other

354-355.20.b

354-355.21.b

354-355.23.b

0

0

0

0

354-355.24,25,26.b

Sum of Lines 88 through 91

(Line 89 / Line 92)

Total

0

93 Transmission Wage and Salary Allocator

#DIV/0!

T W/S

Schedule 19 Projects Wages and Salaries

94 (transmission wages and salary times S19P)

Schedule 19 Projects Wage and Salary

95 Allocator

Schedule 19 Projects Transmission Wage

96 and Salary Allocator

(Line 89 * Line 86)

(Line 94 / Line 92)

(Line 94 / Line 89)

#DIV/0!

#DIV/0!

#DIV/0!

S19 W/S

S19 W/S T

ELECTRIC COMMON PLANT ALLOCATOR

(CE)

Electric

% Electric

0.000%

97

98

99

200-201.3.c+6.c

200-201.3.d+6.d

(Line 97 + Line 98)

0

0

0

Gas

CP=

Total (excludes common)

Page 3 of 16


REVENUE CREDITS

Account 454, Rent from Electric Property

100 (Note I)

300-301, fn

300-301, fn

-

Account 456, Other Electric Revenue (Note J)

101

-

-

102 Total Revenue Credits

Formula Rate - Non-Levelized

Rate Formula Template

Actual 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

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

A All 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

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

averages).

B

The 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).

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

D Includes only FICA and unemployment taxes.

E

F

Any transmission regulatory expenses allocated to Rate Schedule 19 Projects are determined after deducting any directly assigned regulatory expenses.

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 =

SIT=

p =

0.00%

0.00% (State Income Tax Rate or Composite SIT)

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

G Include ATU for Year N with Projected ATRR for Year N+2

H Debt 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.

I

J

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

Includes revenue related to Schedule 19 Projects only.

K The 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 Schedule 19 Projects gross plant as % of electric and common plant)

GPE= gross electric plant allocator (allocated Schedule 19 Projects gross 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)

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

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

L

NYSEG 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.

M NYSEG 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.

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

Total

Gross receipt tax rate

Revenue requirement

Gross Receipts Tax

0.0000%

-

-

Estimate of Line 82

O For future use.

Page 4 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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 Averages

Gross Operating Property

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

(m)

(n)

(o)

(p)

Schedule 19 Projects

Month

Year

Electric Intangible

Production

Transmission

Distribution

Electric General

Common

Project 1

Project 2

Project 3

Project 4

Total

Sum of Columns (h)

FF1 Reference

204-207, line 5 fn

5

204-207, line 46 fn

1

204-207, line 58 fn

2

204-207, Line 75 fn

3

204-207, l. 99 fn

4

355 fn

6

204-207, line 58 fn

2

204-207, line 58 fn

2

204-207, line 58 fn

2

204-207, line 58 fn

2

204-207, line 58 fn

2

through (l)

Appendix A Line #

December

March

2

-

-

-

-

-

-

1

2

3

4

5

6

2020

2021

2021

2021

2021

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

June

September

December

Average

-

-

-

-

-

-

Note: Exclude Asset Retirement Obligations

Accumulated Depreciation

Schedule 19 Projects

Month

Year

Electric Intangible

Production

Transmission

Distribution

Electric General

Common

Project 1

Project 2

Project 3

Project 4

Total

Sum of Columns (h)

through (l)

FF1 Reference

200-201.21c

13

219, lines. 20-24 fn

9

219, line 25 fn

10

219, line 26 fn

11

219, line 28 fn

12

355 fn

14

219, line 25 fn

10

219, line 25 fn

10

219, line 25 fn

10

219, line 25 fn

10

219, line 25 fn

10

Appendix A Line #

December

March

10

7

8

9

2020

2021

2021

2021

2021

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

June

-

10 September

11 December

-

-

12

Average

-

-

-

0

Schedule 19 Projects - CWIP

Miscellaneous Rate Base Items

Unfunded Liabilities

Miscellaneous

Accumulated

Provision for

Injuries and

Damages

Materials and Supplies -

Assigned to Construction

(Electric and Gas)

Transmission Land Held

for Future Use

Schedule 19 Projects -

Land Held for Future Use

Schedule 19 Projects -

Abandoned Plant

Materials & Supplies -

Transmission

Current and

Accrued

Liabilities

Project 1

Project 2

Project 3

Project 4

Total

Prepayments

Month

Total

Sum of Columns

(n) through (o)

214, line 17 fn

214, line TBD

230b, Line TBD

24

227, Line 8 fn

30

227, line 5 fn

110-111, line 57 fn

112-113, line 28 Account 242 -

FF1 Reference

Appendix A Line #

216 fn

23

216 fn

23

216 fn

23

216 fn

23

216 fn

23

fn

see below

23

28

28

31

32

33

13 December

14 March

15 June

16 September

17 December

2020

2021

2021

2021

2021

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

18

Average

-

-

-

-

-

-

-

-

-

-

Unfunded Liabilities - Account 242

Month

FF1 Reference

Appendix A Line #

Accrued Vacation

Other

NA

NA

Total

NA

NA

19 December

20 March

21 June

22 September

23 December

2020

2021

2021

2021

2021

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

24

Average

-

-

Page 5 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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) Workpaper - Current Year

Actual for the 12 Months Ended 12/31/2021

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Plant

Labor

Total

ADIT

Nonprorated Items

Related

Related

Current Year

ADIT-190

ADIT-282

ADIT-283

Subtotal

Schedule 19 Projects W/S Allocator

GP Allocator

End of Year ADIT

1

2

3

4

5

6

7

8

9

0

0

0

0

0

0

0

0

0

0

0

0

(Line 24)

(Line 30)

(Line 38)

(Line 1 + Line 2 + Line 3)

Appendix A

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Appendix A

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

(Line 4 * Line 5 or Line 6)

Workpaper 2b, Line 7

(Average of Line 7 + Line 8)

End of Previous Year ADIT

Average Beginning and End of Year

0

10

11

Prorated ADIT

Total ADIT

#DIV/0!

#DIV/0!

From Workpaper 2c, Line 14, Col. (r) or Workpaper 2d, Line 13, Col. (n)

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)

ADIT-190 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Plant

Related

Labor

Related

Total

Excluded

Justification

12

13

14

15

16

17

18

19

20

21

22

23

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

24 Total

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) Workpaper - Current Year

(a)

ADIT- 282 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Total

Plant

Related

Labor

Related

Excluded

Justification

25 Depreciation - Liberalized Depreciation - Prorated

#DIV/0!

0

#DIV/0!

0

0

Worksheet 2c, Line 14, Col. (r)

26

27

28

29

0

0

0

0

0

0

0

0

30 Total

#DIV/0!

0

#DIV/0!

0

0

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) Workpaper - Current Year

(a)

ADIT-283 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Total

Plant

Labor

Excluded

Justification

31 Cost of Removal

32

33

34

35

36

37

38 Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

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.

Page 6 of 16

2a-ADIT Current Year


Effective Date: 7/8/2024 - Docket #: ER24-1968-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) Workpaper - Prior Year

Actual for the 12 Months Ended 12/31/2021

(a)

(b)

(c)

(d)

(e)

(f)

(g)

Schedule 19

Projects

Plant

Labor

Total

ADIT

Nonprorated Items

Related

Related

Prior Year

ADIT-190

ADIT-282

ADIT-283

Subtotal

Schedule 19 Projects W/S Allocator

GP Allocator

Prior Year ADIT

1

2

3

4

5

6

7

0

0

0

0

0

0

0

0

0

(Line 20)

(Line 26)

(Line 34)

(Line 1 + Line 2 + Line 3)

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Appendix A

(Line 4 * Line 5 or Line 6)

0

#DIV/0!

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)

ADIT-190 - Includes Only Items Applicable to

Schedule 19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

Schedule 19

Projects

Related

Plant

Related

Labor

Related

Total

Excluded

Justification

8

9

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

10

11

12

13

14

15

16

17

18

19

20 Total

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) Workpaper - Prior Year

(a)

(b)

(c)

(d)

(e)

(f)

(g)

ADIT- 282 - Includes Only Items Applicable to

Schedule 19 Projects

Schedule 19

Projects

Related

Plant

Related

Labor

Related

G

Excluded

Justification

21 Depreciation - Liberalized Depreciation - Prorated

#DIV/0!

0

#DIV/0!

0

0

Workpaper 2d, Line 13, Col. (n)

22

23

24

25

0

0

0

0

0

0

0

0

0

26 Total

#DIV/0!

0

#DIV/0!

0

0

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) Workpaper - Prior Year

(a)

ADIT-283 - Includes Only Items Applicable to

Schedule 19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

Schedule 19

Projects

Related

Total

Plant

Related

Labor

Related

Excluded

Justification

27 Cost of Removal

28

29

30

31

32

33

34 Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

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.

Page 7 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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

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

Rate Year =

Account 282 (Note A)

(a)

(b)

Year

(c)

(d)

(e)

(f)

for

(g)

Beginning

Balance/

(h)

(i)

(j)

(k)

(l)

Plant

Allocation (j)

* (k)

(m)

Plant Proration

(f) x (l)

(n)

Labor

Related

(o)

W/S

(p)

Labor

(q)

Labor

Proration

(f) x (p)

(r)

Beginning Balance & Monthly

Changes

Days in the Number of Days Total Days Weighting

Schedule 19

Projects

Transmission Plant Related Gross Plant

Total Transmission

Prorated Amount (i)

+ (m) + (q)

Month

Remaining in

Year After

Current Month

in the

Projected

Rate Year

Proration

(f) x (h)

Allocator

(Appendix A)

Allocator Allocation

Projection Monthly Amount/

(General (Appendix (n) * (o)

(d)/(e)

Ending Balance

and

A)

Line #

Common)

December 31st balance of Prorated

1

2

3

4

5

6

7

8

9

ADIT (Note B)

January

February

March

April

May

June

July

August

2020

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

100.00%

91.78%

84.11%

75.62%

67.40%

58.90%

50.68%

42.19%

33.70%

25.48%

16.99%

8.77%

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

31

335

365

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

28

31

30

31

30

31

31

30

31

30

31

365

307

276

246

215

185

154

123

93

365

365

365

365

365

365

365

365

365

365

365

0

0

0

0

0

0

0

0

0

0

0

0

10 September

11 October

12 November

13 December

14 Prorated Balance

62

32

1

0.27%

#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).

Note B: From Workpaper 2d-Prior Year ADIT Proration Actual

Page 8 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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)

Days in Period

Projection - Proration of Projected Deferred Tax

Actual Activity - Proration of Projected Deferred Tax Activity and Averaging of Other Deferred Tax Activity

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

(m)

(n)

Difference between Actual activity (Col I)

Number of

Days

Remaining in Total Days in

Year After Projected Rate

Month's

Accrual of

Deferred

Taxes

Preserve proration

when actual

Difference

between

projected

projected and

actual activity when is an increase while

actual and actual activity is a

when projected activity

monthly and

Proration

Percentage

(c)/(d)

Projected

Monthly

Activity

Prorated

Amount

* (f)

Prorated Projected

Actual Monthly

Balance reflecting

Days in the

Month

projected monthly

activity are either

both increases or

decreases.

Month

(e) Balance

Sum

Activity

(table

monthly and

actual monthly

projected activity decrease OR projected proration or averaging (n)

Year (Line 14,

Col b)

of (g)

below, grand total)

are either both

increases or

decreases.

activity is a decrease

while actual activity is

an increase.

+ (k) +((l) + (m))/2

activity

(i) -

(f)

(See Note A)

(See Note A)

(See Note A)

1 December 31st balance

2 January

3 February

4 March

5 April

6 May

7 June

8 July

9 August

10 September

11 October

12 November

13 December

14 Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

31

335

365

365

365

365

365

365

365

365

365

365

365

365

91.78%

84.11%

75.62%

67.40%

58.90%

50.68%

42.19%

33.70%

25.48%

16.99%

8.77%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

28

31

30

31

30

31

31

30

31

30

31

365

307

276

246

215

185

154

123

93

62

32

1

0.27%

Gross Plant

Allocator

Plant Related (Appendix A) Total (d) * (e)

Labor Related

(General and W/S Allocator (Appendix

Schedule 19

Projects

Grand Total (b) +

(f) + (i)

Common)

A)

Total (g) * (h)

Actual Monthly Activity

15 January

16 February

17 March

18 April

19 May

20 June

21 July

22 August

23 September

24 October

25 November

26 December

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

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.

Page 9 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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)

Unprotected

Property (UP)

Unprotected

Other (UO)

(Note B)

Deficient or

Excess

Accumulated

Adjusted

Deficient or

Excess

Schedule 19

Projects

Allocation

ADIT Balances After

Allocated to

Schedule 19

Projects

Column (f) *

Column (g)

ADIT Balances Prior Remeasurement (Note Deferred Taxes Adjustments After

Accumulated

Deferred Taxes Factors (Note B)

Column (d) +

Amortization

Year

Balance at

December 31

Column (h) -

Column (j)

Amortization

Year

Balance at

December 31

Column (k) -

Column (l)

Line Description

to Remeasurement

C)

at December 31, Remeasurement

Column (b) -

Column (b) * Line 43

Column (c)

Column (e)

Deficient Deferred Income Taxes -

amortized to 410.1

FERC Account 190

1

2

3

4

5

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

6 Total FERC Account 190

FERC Account 282

7

8

9

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

10

11 Total Account 282

FERC Account 283

12

13

14

15

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

16

17 Total FERC Account 283

Subtotal Before Being Grossed up for

18 Income Taxes

19 Gross Up

0

0

0

0

0

0

0

0

0

0

0

0

Total Deficient Accumulated Deferred

20 Income Taxes - Account 182.3

0

0

0

0

0

Excess Accumulated Deferred Income

Taxes - amortized to 411.1

FERC Account 190

21

22

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

23 Total Account 190

FERC Account 282

24 Accelerated Depreciation

25

26

27

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

P

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

28

29 Total Account 282

FERC Account 283

30

31

32

33

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

34

35 Total Account 283

Subtotal Before Being Grossed up for

Income Taxes

36

37 Gross Up

Total Excess Accumulated Deferred Income

0

0

0

0

0

0

0

0

0

0

0

0

38 Taxes - Account 254

0

0

0

0

0

0

0

0

0

0

39 Grand Total

40 Total Amortization

0

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

41

42

43

New nominal rate

Prior nominal rate

Remeasurement Factor

1.0%

1.0%

100.0%

Note D:

Note E:

Note F:

Page 10 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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 of

Permanent

Book/Tax

AFUDC Equity

Schedule 19

Projects

Other 2

Other 3

Total

Line #

Differences

FF1 Reference

1

2

Amount

-

0

0

0

0

-

-

Income Tax Effect

-

Line 1 *

Composite

Income Tax

Rate

Line 1 *

Composite

Income Tax

Rate

Line 1 *

Composite

Sum of

Income Tax Columns (b), (c)

Rate and (d)

Ref

Page 11 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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 Average

Allocate Other Rate Base Items to Schedule 19 Projects

Net

Intangible

Plant -

Using

Allocator

Accumulated

Deferred

Land Held for

Net General

Plant - Using

Allocator

Net Common

Plant - Using

Allocator

Income Taxes (Excess)/Deficient Future Use - Other Rate Base

Gross Plant in

Service

Accumulated

Depreciation

Net Operating

Property

Abandoned Plant -

Using Allocator

- Using

Allocator

ADIT - Using

Allocator

Using

Allocator

Items - Using

Allocator

Line #

Allocator

CWIP

Total Rate Base

Sum of Col. (e)

Workpaper 1,

Line 6

Workpaper 1,

Line 12

Line 6 * Col. Line 6 * Col. Line 6 * Col. Workpaper 1, Workpaper 1, Line Line 6 * Col.

Line 6 * Col.

(c)

Reference

Project

Grouping 1

Calculated

#DIV/0!

Col. (b) + Col. (d)

-

(c)

(c)

(c)

Line 18

18

(c)

Line 6 * Col. (c)

#DIV/0!

Line 6 * Col. (c) through Col. (n)

1

2

3

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 2

#DIV/0!

#DIV/0!

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 3

Project

Grouping 4

4

5

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

6

Total

-

-

0

-

-

0

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

Appendix A, Line

26

Appendix A, Appendix A, Line

Ref

Line 19

Line 20

Line 21

Line 18

18

Line 25

Line 28 34

Weighted Preferred

and Common Equity

Rate

Preferred and

Common

Equity Return

Weighted

Debt Rate

Rate Base

WACC

Return

Debt Return

Workpaper 6,

Line 4, Line 8,

Line 12, or

Line 16

Workpaper 6, Lines

2 + 3, Lines 6+ 7 ,

Lines 10 + 11 or

Lines 14 + 15

Workpaper 6,

Line 1, Line 5,

Line 9 or Line Col. (b) * Col.

Col. (b) * Col.

(c)

Col. (b) * Col.

(e)

Reference

Project

Grouping 1

Col. (m)

#DIV/0!

13

(h)

7

8

9

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0.00%

0.00%

0.00%

0.00%

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 2

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 3

Project

10 Grouping 4

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

11

12 Total

Schedule 19 Projects Included in Each Project Group

Project Project

Gross

Name Description

Investment

Project

Grouping 1

Project

Grouping 2

Project

Grouping 3

Project

Grouping 4

Page 12 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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 6: Schedule 19 Project Cost of Capital

Actual for the 12 Months Ended 12/31/2021

(a)

(b)

(c)

(Note A)

%s

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

Line #

Project Grouping 1

Long Term Debt

Preferred Stock

Common Stock

Capitalization

Cost Rates

WACC

1

2

3

Line 22, Col. (k)

Line 22 Col. (c)

Line 22 Col. (e)

0

0.0%

0.0%

0.0%

#DIV/0!

#DIV/0!

ROE per New York State Public Service Commission, Case No.

ROE Cap

0.00%

10.87%

-

0.000%

0.000%

0.00%

0.00%

0

(Line 25, Col. (b) or

4

Total Capitalization

0

0.0% Lines 1 or 2, Col. (k))

#DIV/0!

Project Grouping 2

Capitalization

%s

%s

%s

Cost Rates

WACC

#DIV/0!

5

6

7

Long Term Debt

Preferred Stock

Common Stock

Line 22, Col. (k)

Line 22 Col. (c)

Line 22 Col. (e)

0

0.0%

0.0%

0.0%

#DIV/0!

ROE per New York State Public Service Commission, Case No.

ROE Cap

0.00%

10.87%

-

0.000%

0.000%

0.00%

0.00%

0

(Line 25, Col. (b) or

0.0% Lines 5 or 6, Col. (k))

8

Total Capitalization

0

#DIV/0!

Project Grouping 3

Capitalization

Cost Rates

WACC

#DIV/0!

9

10

11

Long Term Debt

Preferred Stock

Common Stock

Line 22, Col. (k)

Line 22 Col. (c)

Line 22 Col. (e)

0

0.0%

0.0%

0.0%

#DIV/0!

ROE per New York State Public Service Commission, Case No.

ROE Cap

0.00%

10.87%

-

0.000%

0.000%

0.00%

0.00%

0

(Line 25, Col. (b) or

0.0% Lines 9 or 10, Col. (k))

12

Total Capitalization

0

#DIV/0!

Project Grouping 4

Capitalization

Cost Rates

WACC

13

14

15

Long Term Debt

Preferred Stock

Common Stock

Line 22, Col. (k)

Line 22 Col. (c)

Line 22 Col. (e)

0

0.0%

0.0%

0.0%

#DIV/0!

#DIV/0!

ROE per New York State Public Service Commission, Case No.

ROE Cap

0.00%

10.87%

-

0.000%

0.000%

(Line 25, Col. (b) or

Lines 13 or 14, Col.

(k))

0.00%

0.00%

0

16

Total Capitalization

0

0.0%

#DIV/0!

Common Equity

Less: Accumulated

Long-term Debt

Unamortized

Other

Comprehensive

Income

Common Equity

for

Capitalization

Col. (b) - Col. (c)

- Col. (d)

Unamortized Loss Long-term Debt

Unamortized Debt on Reacquired for

Less: Preferred

Stock

Gains on

Total

Total

Reacquired Debt

Expense

Debt

Capitalization

Col. (g) + Col.

110-111, l.81, fn (h) - Col. (i) - (j)

Month

Year

2020

2021

2021

2021

2021

112-113, l.16, fn

112-113, l.3, fn

112-113, l.15, fn

112-113, l.24, fn

112-113, l.61, fn

110-111, l.69, fn

17 December

18 March

19 June

20 September

21 December

22 Average

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

(114-117c, sum of

lines 62, 63, 64, 65,

66)

23 Long Term Interest

0

24 Long-Term Debt

25 Long-term Debt Interest Rate

(Line 22, Col. (k)

(Line 23 / Line 24)

0

#DIV/0!

26 Preferred Dividends

27 Preferred Stock

28 Preferred Stock Rate

118-119c, l.29

(Line 22 , Col. (c)

(Line 26 / Line 27)

-

-

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.

Page 13 of 16

6-Project Cost of Capital


Effective Date: 7/8/2024 - Docket #: ER24-1968-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 workpaper included in the filed Formula Rate Template, the inputs to the workpaper must meet this

transparency standard, and doing so will satisfy this transparency requirement for the amounts that are output from the

workpaper and input to the main body of the Formula Rate.

Line

Interest

Estimated Actual Interest Rate True-

Interest Rate

Rate

Up

1

2

3

4

5

6

A

B

C

D

E

F

ATRR based on actual costs included for the previous calendar year

Revenues based upon the Projected ATRR for the previous calendar year and excluding any true-up adjustment

Difference (A-B)

Future Value Factor (1+i)^24

True-up Adjustment (C*D)

Interest Rate True-up (Note 1)

0

0

0

0

1.0000

1.0000

0

0

0

0

Where:

i = average interest rate as calculated below

Interest on Amount of Refunds or Surcharges

Estimated

Actual

Monthly

Interest Rate

Monthly

Interest Rate

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

Month

July

August

Year

7

8

9

Year 1

Year 1

Year 1

Year 1

Year 1

Year 1

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 3

Year 3

Year 3

Year 3

Year 3

Year 3

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

September

10 October

11 November

12 December

13 January

14 February

15 March

16 April

17 May

18 June

19 July

20 August

21 September

22 October

23 November

24 December

25 January

26 February

27 March

28 April

29 May

30 June

31 Average

0.00000%

0.00000%

Note 1: Use Workpaper 7-True-up Adjustment to determine the ATU with actual interest rates and include the interest rate true-up with a subsequent ATU adjustment.

Page 14 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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 Account

Description

Rate (Note 1)

Transmission

350

Land Rights

NA

352

353

354

355

356

357

358

359

Structures and Improvements

Station Equipment

Towers and Fixtures

Poles and Fixtures

Overhead Conductors & Devices

Underground Conduit

1.79%

1.69%

1.63%

2.07%

2.21%

1.54%

1.83%

NA

Underground Conductors & Devices

Roads and Trails

Electric General and Intangible

302

303

390

391

391.2

392.1

393

394

395

396

396.1

397

397.1

398

Franchises and Consents

Intangible Plant

Structures and Improvements

Office Furniture and Equipment

Computer Equipment

Transportation Equipment - Auto

Stores Equipment

Tools, Shop and Garage Equipment

Laboratory Equipment

Power Operated Equipment

Power Operated Equipment - Vehicle

Communication Equipment

Communication Equipment - Overhead

Miscellaneous Equipment

NA

9.14%

1.77%

5.00%

9.14%

9.50%

2.56%

4.00%

3.66%

8.18%

6.67%

5.75%

2.86%

2.95%

Common

302

303

390

391

391.2

391.4

392

392.1

393

Franchises and Consents

Intangible Plant

Structures and Improvements

Office Furniture and Equipment

Computer Equipment

NA

11.33%

1.64%

4.32%

11.33%

14.29%

9.00%

10.00%

1.55%

3.09%

5.00%

6.67%

4.91%

LANs/WANs

Transportation Equipment - Auto

Transportation Equipment - In Reserve

Stores Equipment

Tools, Shop and Garage Equipment

Laboratory Equipment

394

395

397

398

Communication Equipment

Miscellaneous Equipment

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

Page 15 of 16


Effective Date: 7/8/2024 - Docket #: ER24-1968-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

Impact of

Correction

Line

No. Description

Revenue

Requirement

Source

1

2

Filing Name and Date

Original Revenue Requirement

0

3

4

Description of Correction 1

Description of Correction 2

0

0

5

6

7

Total Corrections

(Line 3 + Line 4)

(Line 2 + Line 5)

(Line 5)

0

0

0

Corrected Revenue Requirement

Total Corrections

8

9

10

Average Monthly FERC Refund Rate

Number of Months of Interest

Note A

Note B

(Line 7 * Line 8 *

0.00%

0

Interest on Correction

Line 9)

0

0

11 Sum of Corrections Plus Interest

(Line 7 + Line 10)

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 True-up Adjustment is computed.

B

C

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.

Corrected formula rate calculations will be provided to support any corrections.

Page 16 of 16

 

Effective Date: 7/8/2024 - Docket #: ER24-1968-000 - Page 1