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
Annual Transmission Revenue Requirement for Schedule 19 Projects
Average Balances for Most Rate Base Items
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
IT Permanent Differences
Project Return
Return on Schedule 19 Projects
Project Cost Of Capital
True-up Adjustment
Schedule 19 Projects Cost of Capital
Annual True-up Adjustment
Depreciation Rates Approved by the Commission and Used to Determine Schedule
19 Projects Depreciation and Amortization Expense
Depreciation Rates
Corrections
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)
Schedule 19
Projects (Col. 3 *
Col. 4)
Form No. 1 or Transmission
Formula Rate Reference
Company Total (where
applicable)
Workpaper 1, Line 6, Col. (c)
Workpaper 1, Line 6, Col. (d) or Col.
(m)
Workpaper 1, Line 6, Col. (e)
Workpaper 1, Line 6, Col. (f)
Workpaper 1, Line 6, Col. (b)
Workpaper 1, Line 6, Col. (g)
(Sum of Lines 1 through 6)
Transmission
Distribution
Electric General
Electric Intangible
Common
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
Workpaper 1, Line 12, Col. (c)
Workpaper 1, Line 12, Col. (d) or Col.
(m)
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)
Electric General
Electric Intangible
Common
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
15 TOTAL ACCUM. DEPRECIATION
(Line 1 - Line 9)
(Line 2 - Line 10)
(Line 3 - Line 11)
(Line 4 - Line 12)
(Line 5 - Line 13)
Distribution
General
Intangible
Common
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
(Sum of Lines 16 through 21)
Workpaper 1, Line 18, Col. (g)
Workpaper 1, Line 18, Col. (j)
ACCUMULATED DEFERRED INCOME
TAXES (Note B)
Accumulated Deferred Income Taxes
Workpaper 2a, Line 11, Col. (g)
Workpaper 3
Excess Accumulated Deferred Income Taxes
TOTAL ACCUMULATED DEFERRED
28 LAND HELD FOR FUTURE USE
Workpaper 1, Line 18, Col. (h) or (i)
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)
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)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Prepayments
Unfunded Liabilities
34 TOTAL OTHER RATE BASE ITEMS
(Line 22+ Line 27 + Line 28 + Line 34)
Formula Rate - Non-Levelized
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
Projects (Col. 3 *
Col. 4)
ANNUAL TRANSMISSION REVENUE
No. REQUIREMENT
Form No. 1 or Transmission
Formula Rate Reference
Company Total (where
applicable)
OPERATIONS AND MAINTENANCE
EXPENSES (Note M)
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
39 Subtotal - Transmission to Allocate
40 Electric A&G
41
42
43
44
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 -
Line 44
Adjusted Electric A&G
Plus: Transmission Related Regulatory
46 Expenses
Plus: Direct Assigned Regulatory
47 Commission Expenses (Note E)
48 Plus: Property Insurance
Sum of Lines 36, 39 and 45 through
48
DEPRECIATION AND AMORTIZATION EXPENSE
336.7.f, fn
336.10 f
336.1.d
336.11.f
230a fn
Electric General
Electric Intangible
Common Electric
Amortization of Abandoned Plant
Sum of Lines 50 through 54
TAXES OTHER THAN INCOME TAXES
LABOR RELATED
Payroll (Note D)
PLANT RELATED
Real Estate
Franchise Tax
Gross Receipts Tax
Other
262-263
Sum of Lines 56 and 58 through 61
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
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
Workpaper 3
Workpaper 4, Line 2, Col. (e)
(Line 75 * Line 65)
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
Workpaper 5, Line 12, Col. (i)
Workpaper 5, Line 12, Col. (f)
Sum of Lines 74 through 75
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)
ANNUAL TRANSMISSION REVENUE
Workpaper 9, Line 11, Col. (b)
ANNUAL TRUE-UP ADJUSTMENT (ATU)
82 ATRR PLUS ATU AND CORRECTIONS
Sum of Lines 79 through 81
Formula Rate - Non-Levelized
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
No. TRANSMISSION PLANT ALLOCATOR
83 Electric Plant
84 Total Transmission Plant
85 Schedule 19 Projects
(Line 97)
(Line 2)
(Line 2)
86 Schedule 19 Projects Plant Allocator
87 Transmission Plant Allocator
(Line 85 / Line 84)
(Line 84 / Line 83)
ELECTRIC WAGE AND SALARY
ALLOCATOR
354-355.24,25,26.b
Sum of Lines 88 through 91
(Line 89 / Line 92)
93 Transmission Wage and Salary Allocator
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 and
96 Salary Allocator
(Line 89 * Line 86)
(Line 94 / Line 92)
(Line 94 / Line 89)
ELECTRIC COMMON PLANT ALLOCATOR
200-201.3.c+6.c
200-201.3.d+6.d
(Line 97 + Line 98)
REVENUE CREDITS
Account 454, Rent from Electric Property
Account 456, Other Electric Revenue (Note J)
102 Total Revenue Credits
Formula Rate - Non-Levelized
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)
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).
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).
Cash Working Capital for Schedule 19 Projects equals one-eighth (45 days) of O&M allocated to Schedule 19 Projects.
Includes only FICA and unemployment taxes.
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).
0.00% (State Income Tax Rate or Composite SIT)
0.00% (percent of federal income tax deductible for state purposes)
Include ATU for Year N with Projected ATRR for Year N+2
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.
Includes revenue related to Schedule 19 Projects only, such as pole attachments, rentals and special use.
Includes revenue related to Schedule 19 Projects only.
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
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.
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.
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
Effective Date: 7/8/2024 - Docket #: ER23-1816-005 - 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
Sum of Columns (h)
through (l)
Appendix A Line #
December
March
Note: Exclude Asset Retirement Obligations
Sum of Columns (h)
through (l)
Schedule 19 Projects - CWIP
Miscellaneous Rate Base Items
Unfunded Liabilities
Miscellaneous
Current and
Accrued
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
Sum of Columns
(n) through (o)
FF1 Reference
Appendix A Line #
13 December
14 March
15 June
16 September
17 December
Unfunded Liabilities - Account 242
Month
FF1 Reference
Appendix A Line #
19 December
20 March
21 June
22 September
23 December
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
Nonprorated Items
Current Year
ADIT-190
ADIT-282
ADIT-283
Subtotal
Schedule 19 Projects W/S Allocator
GP Allocator
End of Year ADIT
End of Previous Year ADIT
Average Beginning and End of Year
(Line 24)
(Line 30)
(Line 38)
(Line 1 + Line 2 + Line 3)
Appendix A
#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)
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
Schedule 19
Projects
Related
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
(d)
Schedule 19
Projects
Related
25 Depreciation - Liberalized Depreciation - Prorated
Workpaper 2c, Line 14, Col. (r)
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
Schedule 19
Projects
Related
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/8/2024 - Docket #: ER23-1816-005 - 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
Prior Year
ADIT-190
ADIT-282
ADIT-283
Subtotal
Schedule 19 Projects W/S Allocator
GP Allocator
Prior Year ADIT
(Line 20)
(Line 26)
(Line 34)
(Line 1 + Line 2 + Line 3)
Appendix A
Appendix A
(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)
ADIT-190 - Includes Only Items Applicable to Schedule
19 Projects
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
ADIT- 282 - Includes Only Items Applicable to
Schedule 19 Projects
Schedule 19
Projects
Related
21 Depreciation - Liberalized Depreciation - Prorated
Workpaper 2d, Line 13, Col. (n)
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
Schedule 19
Projects
Related
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.
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)
(g)
Beginning
Balance/
Monthly Amount/
Ending Balance
(l)
Plant
Allocation (j)
* (k)
(m)
Plant Proration
(f) x (l)
(q)
Labor
Proration
(f) x (p)
Beginning Balance & Monthly
Changes
Days in the Number of Days Total Days Weighting
Month
Transmission Plant Related Gross Plant
Proration
(f) x (h)
Total Transmission
Prorated Amount (i)
+ (m) + (q)
Remaining in
Year After
Current Month
(General (Appendix (n) * (o)
and
December 31st balance of Prorated
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!
365
365
365
365
365
365
365
365
365
365
365
365
#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
10 September
11 October
12 November
13 December
14 Prorated Balance
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
New York State Electric and Gas Corporation
Workpaper 2d: Accumulated Deferred Income Taxes - Actual Proration
Actual for the 12 Months Ended 12/31/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
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
monthly and
projected monthly
activity are either
both increases or
(i) -
decreases.
Difference
between
projected
monthly and
actual monthly
activity
projected and
actual activity when is an increase while
actual and actual activity is a
Proration
Percentage
(c)/(d)
projected activity decrease OR projected proration or averaging (n)
are either both
increases or
decreases.
activity is a decrease
while actual activity is
an increase.
January
February
March
April
May
June
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%
#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
10 September
11 October
12 November
13 December
14 Total
Gross Plant
Allocator
(Appendix A) Total (d) * (e)
Labor Related
(General and W/S Allocator (Appendix
Grand Total (b) +
(f) + (i)
15 January
16 February
17 March
18 April
19 May
20 June
#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!
22 August
23 September
24 October
25 November
26 December
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.
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)
Protected (P)
Unprotected
Property (UP)
Unprotected
Other (UO)
(Note B)
Deficient or
Excess
Accumulated
Adjusted
Deficient or
Excess
Schedule 19
Projects
Allocation
Allocated to
Schedule 19
Projects
Column (f) *
Column (g)
ADIT Balances Prior Remeasurement (Note Deferred Taxes Adjustments After
Balance at
December 31
Column (h) -
Column (j)
Balance at
December 31
Column (k) -
Column (l)
at December 31, Remeasurement Deferred Taxes Factors (Note B)
Column (b) -
Column (c)
Deficient Deferred Income Taxes -
amortized to 410.1
FERC Account 190
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
17 Total FERC Account 283
Subtotal Before Being Grossed up for
18 Income Taxes
19 Gross Up
Total Deficient Accumulated Deferred
20 Income Taxes - Account 182.3
Excess Accumulated Deferred Income
Taxes - amortized to 411.1
FERC Account 190
24 Accelerated Depreciation
25
26
27
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
0.000%
Subtotal Before Being Grossed up for
36 Income Taxes
37 Gross Up
Total Excess Accumulated Deferred Income
38 Taxes - Account 254
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
New nominal rate
Prior nominal rate
Remeasurement Factor
Effective Date: 7/8/2024 - Docket #: ER23-1816-005 - 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
Allocate Other Rate Base Items to Schedule 19 Projects
Net
Intangible
Plant -
Using
Allocator
Net General
Plant - Using
Allocator
Net Common
Plant - Using
Allocator
Income Taxes - (Excess)/Deficient Future Use - Other Rate Base
Using
Allocator
Abandoned Plant -
Using Allocator
Total Rate Base
Sum of Col. (e)
Line 6 * Col. Line 6 * Col. Line 6 * Col. Workpaper 1, Workpaper 1, Line Line 6 * Col.
(c)
Reference
Project
Grouping 1
Line 6 * Col. (c) through Col. (n)
Appendix A, Appendix A, Appendix A, Workpaper 1, Workpaper 1, Line Appendix A,
Appendix A, Appendix A, Line
Weighted Preferred
and Common Equity
Rate
Preferred and
Common
Equity 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.
Reference
Project
Grouping 1
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Schedule 19 Projects Included in Each Project Group
New York State Electric and Gas Corporation
Workpaper 6: Schedule 19 Project Cost of Capital
Actual for the 12 Months Ended 12/31/2021
Project Grouping 1
Long Term Debt
Preferred Stock
Common Stock
Line 22, Col. (k)
Line 22 Col. (c)
Line 22 Col. (e)
ROE per New York State Public Service Commission, Case No.
ROE Cap
0.0% Lines 1 or 2, Col. (k))
Long Term Debt
Preferred Stock
Common Stock
Line 22, Col. (k)
Line 22 Col. (c)
Line 22 Col. (e)
ROE per New York State Public Service Commission, Case No.
ROE Cap
(Line 25, Col. (b) or
0.0% Lines 5 or 6, Col. (k))
Long Term Debt
Preferred Stock
Common Stock
Line 22, Col. (k)
Line 22 Col. (c)
Line 22 Col. (e)
ROE per New York State Public Service Commission, Case No.
ROE Cap
(Line 25, Col. (b) or
0.0% Lines 9 or 10, Col. (k))
Long Term Debt
Preferred Stock
Common Stock
Line 22, Col. (k)
Line 22 Col. (c)
Line 22 Col. (e)
ROE per New York State Public Service Commission, Case No.
ROE Cap
0.000%
0.000%
(Line 25, Col. (b) or
Lines 13 or 14, Col.
(k))
Common Equity
Less: Accumulated
Long-term Debt
Unamortized
Common Equity
for
Capitalization
Col. (b) - Col. (c)
- Col. (d)
Unamortized Loss Long-term Debt
Capitalization
Col. (g) + Col.
(h) - Col. (i) - (j)
17 December
18 March
19 June
20 September
21 December
22 Average
(114-117c, sum of
lines 62, 63, 64, 65,
66)
24 Long-Term Debt
25 Long-term Debt Interest Rate
(Line 22, Col. (k)
(Line 23 / Line 24)
26 Preferred Dividends
27 Preferred Stock
28 Preferred Stock Rate
118-119c, l.29
(Line 22 , Col. (c)
(Line 26 / Line 27)
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.
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:
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.
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
Multiply the ATRR Before Interest by (1+i)^24 months
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.
Actual Interest Rate True-
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)
i = average interest rate as calculated below
Interest on Amount of Refunds or Surcharges
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%
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%
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
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.
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
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
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
11.33%
1.64%
4.32%
11.33%
14.29%
9.00%
10.00%
1.55%
3.09%
5.00%
6.67%
4.91%
Transportation Equipment - Auto
Transportation Equipment - In Reserve
Stores Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
Communication Equipment
Miscellaneous Equipment
Note 1: The above depreciation rates cannot change absent Commission authorization
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.
Revenue
Impact of
Correction
Filing Name and Date
Original Revenue Requirement
Description of Correction 1
Description of Correction 2
(Line 3 + Line 4)
(Line 2 + Line 5)
(Line 5)
Corrected Revenue Requirement
Total Corrections
Average Monthly FERC Refund Rate
Number of Months of Interest
Note A
Note B
(Line 7 * Line 8 *
11 Sum of Corrections Plus Interest
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.
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.
Effective Date: 7/8/2024 - Docket #: ER23-1816-005 - Page 1
