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-001 - 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 49 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!
33Unfunded LiabilitiesWorksheet 1, Line 18, Col. (p)-CP*S19 W/S#DIV/0!#DIV/0!
34TOTAL OTHER RATE BASE ITEMS(Sum of Lines 29 through 33)NA#DIV/0!
(Line 22 + Line 23 + Line 24 + Line 27 +
35RATE BASELine 28 + Line 34)NA#DIV/0!
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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)
36Transmission - Direct Assign320-323.112.b fn0DA0
37Transmission - Allocate320-323.112.b fn0
38Less: EPRI Dues in Account 566352-3530
39Subtotal - Transmission to AllocateLine 37 - Line 380S19P#DIV/0!#DIV/0!
40Electric A&G320-323.197.b0
41Less: EPRI Dues in A&G352-3530
42Less: Regulatory Commission Expenses320-323.189.b0
43Less: Property Insurance320-323.185.b0
44Less: Account 930.2 ItemsNote L0
Line 40 - Line 41 - Line 42 - Line 43 -
45Adjusted Electric A&GLine 440S19 W/S#DIV/0!#DIV/0!
Plus: Transmission Related Regulatory
46Expenses350-351 fn0S19P#DIV/0!#DIV/0!
Plus: Direct Assigned Regulatory
47Commission Expenses350-351 fnNADA0
48Plus: Property Insurance320-323.185.b0GPE#DIV/0!#DIV/0!
49TOTAL O&MSum of Lines 36, 39 and 45 through 48NA#DIV/0!
DEPRECIATION AND AMORTIZATION EXPENSE
50Transmission336.7.f, fn0DA0
51Electric General336.10 f0S19 W/S#DIV/0!#DIV/0!
52Electric Intangible0S19 W/S#DIV/0!#DIV/0!
53Common Electric336.11.f0S19 W/S#DIV/0!#DIV/0!
54Amortization of Abandoned Plant230a fnNADA0
55TOTAL DEPRECIATIONSum of Lines 50 through 540#DIV/0!
TAXES OTHER THAN INCOME TAXES
LABOR RELATED
56Payroll (Note D)262-263.9+262-263.17. l0CP*S19 W/S#DIV/0!#DIV/0!
57PLANT RELATED
58Real Estate262-263.5.l0CP*GPE#DIV/0!#DIV/0!
59Franchise Tax262-2630CP*GPE#DIV/0!#DIV/0!
60Gross Receipts TaxNANote N0
61Other (Note E)262-26300
62TOTAL OTHER TAXESSum of Lines 56 and 58 through 610#DIV/0!
INCOME TAXES (Note F)
T=1 - {[(1 - SIT) * (1 - FIT)] / (1 -
63Composite Tax Rate = TSIT * FIT * p)}=0.0000%
64Gross-up Factor1 / (1 - T)0.0000
65Income Tax FactorT/(1-T)0.0000
Amortization of Investment Tax Credit (enter
66negative)266-267.11. f, fnNADA0
Amortization of Excess Deferred Income
67Taxes (enter negative)Worksheet 3NADA0
68Tax Effect of Permanent DifferencesWorksheet 4, Line 2, Col. (e)NADA-
69Income Tax Calculation(Line 75 * Line 65)NACalc#DIV/0!
70ITC adjustment(Line 66 * Line 64)NACalc0
71Excess Deferred Income Tax Adjustment(Line 67 * Line 64)NACalc0
72Permanent Differences Tax Adjustment(Line 68 * Line 64)NACalc0
73TOTAL INCOME TAXESSum of Lines 69 through 72NA#DIV/0!
RETURN (Note H)
74DebtWorksheet 5, Line 12, Col. (i)NACalc#DIV/0!
75Common Equity and Preferred StockWorksheet 5, Line 12, Col. (f)NACalc#DIV/0!
76TOTAL RETURNSum of Lines 74 through 75NA#DIV/0!
ANNUAL TRANSMISSION REVENUE
REQUIREMENT BEFORE REVENUE(Line 49 + Line 55 + Line 62 + Line 73 +
77CREDITSLine 76)NA#DIV/0!
78REVENUE CREDITS(Line 102)NA-
ANNUAL TRANSMISSION REVENUE
79REQUIREMENT (ATU)(Line 77 + Line 78)NA#DIV/0!
80CORRECTIONSWorksheet 9, Line 11, Col. (b)NA0
ANNUAL TRUE-UP ADJUSTMENT (ATU)
81(Note G)Worksheet 7, Line 7NA0
82ATRR PLUS ATU AND CORRECTIONSSum of Lines 79 through 81NA#DIV/0!
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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
83Electric Plant(Line 97)0
84Total Transmission Plant(Line 2)0
85Schedule 19 Projects(Line 2)0
86Schedule 19 Projects Plant Allocator(Line 85 / Line84)#DIV/0! S19P
87Transmission Plant Allocator(Line 84 / Line 83)#DIV/0! TP
ELECTRIC WAGE AND SALARY
ALLOCATOR
88Production354-355.20.b0
89Transmission354-355.21.b0
90Distribution354-355.23.b0
91Other354-355.24,25,26.b0
92TotalSum of Lines 88 through 910
93Transmission Wage and Salary Allocator(Line 89 / Line 92)#DIV/0!T W/S
Schedule 19 Projects Wages and Salaries
94(transmission wages and salary times S19P)(Line 89 * Line 86)#DIV/0!
Schedule 19 Projects Wage and Salary
95Allocator(Line 94 / Line 92)#DIV/0!S19 W/S
Schedule 19 Projects Transmission Wage and
96Salary Allocator(Line 94 / Line 89)#DIV/0!S19 W/S T
ELECTRIC COMMON PLANT ALLOCATOR
(CE)% Electric
97Electric200-201.3.c+6.c0
98Gas200-201.3.d+6.d0CP=0.000%
99Total (excludes common)(Line 97 + Line 98)0
REVENUE CREDITS
Account 454, Rent from Electric Property
100(Note I)300-301, fn-
Account 456, Other Electric Revenue (Note J)
101300-301, fn-
102Total Revenue Credits-
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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
EFor future use
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 82
Gross Receipts Tax-
OMay include CWIP in rate base as authorized by FERC.
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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)
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 - CWIPUnfunded Liabilities
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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 1Project 2
Month
FF1 Reference216 fn216 fn
Appendix A Line #2323
13December2020--
14March2021--
15June2021--
16 September2021--
17 December 2021 --
Project 3Project 4
216 fn216 fn216 fn
232323
--0
--0
--0
--0
--0
Transmission Land Held Schedule 19 Projects -
Totalfor Future UseLand Held for Future Use
214, line 17 fn214, line TBD
232828
---
---
---
---
---
Schedule 19 Projects -Materials & Supplies - Materials and Supplies -
Abandoned PlantTransmissionAssigned to ConstructionPrepayments
(Electric and Gas)
230b, line TBD227, Line 8 fn227, line 5 fn110-111, line 57 fn
24303132
----
----
----
----
----
AccumulatedProvision for Miscellaneous
Injuries andCurrent and Accrued
DamagesLiabilitiesTotal
Sum of Columns
112-113, line 28 Account 242 - see(o) through (p)
fnbelow
33
---
---
---
---
---
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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
18Average---------------
Unfunded Liabilities - Account 242
MonthAccrued VacationOtherTotal
FF1 ReferenceNANA
Appendix A Line #NANA
19December2020---
20March2021---
21June2021---
22September2021---
23December2021---
24Average---
1-RB Items
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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
Number of
Days
Remaining in Total Days in
Days in theYear After Projected Rate
MonthMonthMonth'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 Monthlyprojectedprojected monthly
Activity(tablemonthly andactivity 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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-001 - 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
IntangiblePlant - -Net CommonDeferred Land Held for
Net GeneralUsingPlant - -AbandonedIncome Taxes -(Excess)/DeficientFuture Use -Other Rate Base
Gross Plant inAccumulatedNet OperatingPlant - UsingAllocatorUsingPlant - UsingUsingADIT - UsingUsingItems - Using
Line #ServiceAllocatorDepreciationPropertyAllocatorAllocatorCWIPAllocatorAllocatorAllocatorAllocatorAllocatorTotal Rate Base
W orkpaper 1,W orkpaper 1,Col. (b) - Col.Line 6 * Col.Line 6 * Col.Line 6 * Col.W orkpaper 1,W orkpaper 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,W orkpaper 1,W orkpaper 1,Appendix A,Appendix A,Appendix A, Line
RefLine 19Line 20Line 21Line 18Line 18Line 25Appendix A, Line 26Line 2834
W eighted
Preferred andPreferred and
CommonCommonW eighted
Rate BaseW ACCReturnEquity 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!
8ProjectGrouping 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
ProjectNameDescriptionInvestment
Grouping 1
Project
Grouping 2
Project
Grouping 3
Project
Grouping 4
Effective Date: 7/3/2023 - Docket #: ER23-1816-001 - 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-001 - 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-001 - 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-001 - 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-001 - Page 1