NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor
Section 6.19.7.2.2 Formula Rate Template
Rochester Gas and Electric Corporation
Transmission Formula Rate
Schedule 19 Projects
Actual for the 12 Months Ended 12/31/2021
Index
Worksheet 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 Project 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
Effective Date: 7/3/2023 - Docket #: ER23-1817-005 - Page 1
NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor
Formula Rate - Non-Levelized
Transmission Formula Rate Template
Utilizing FERC Form 1 Data
Actual for the 12 Months Ended 12/31/2021
Rochester Gas and Electric Corporation
Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects
Composite Depreciation Rates
(1)
(2)
(3)
(4)
(5)
Line
Company Total
(where
applicable)
Schedule 19
Projects (Col 3 *
Col. 4)
Form No. 1 or Transmission
Formula Rate Reference
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)
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)
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
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
GPE=
ACCUMULATED DEPRECIATION
9
Production
Workpaper 1, Line 12, Col. (c)
-
NA
0
Workpaper 1, Line 12, Col. (d) or Col.
(m)
10 Transmission
11 Distribution
12 Electric General
13 Electric Intangible
14 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 Production
17 Transmission
18 Distribution
19 General
20 Intangible
(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!
21 Common
22 TOTAL NET PLANT
(Line 6 - Line 14)
(Sum of Lines 16 through 21)
ACCUMULATED DEFERRED INCOME
TAXES (Note B)
23 Accumulated Deferred Income Taxes
Excess Accumulated Deferred Income
24 Taxes
Workpaper 2a, Line 11, Col. (g)
Workpaper 3
NA
NA
#DIV/0!
0
TOTAL ACCUMULATED DEFERRED
25 INCOME TAXES
(Line 23 + Line 24)
#DIV/0!
0
26 LAND HELD FOR FUTURE USE
Workpaper 1, Line 18, Col. (b) or (c)
0
DA
OTHER RATE BASE ITEMS
27 Cash Working Capital (Note C)
28 Materials & Supplies - Transmission
Materials and Supplies - Electric and Gas -
29 Assigned to Construction
30 Prepayments
31 Unfunded Liabilities
32 TOTAL OTHER RATE BASE ITEMS
(Line 47 times 45/360)
Workpaper 1, Line 18, Col. (d)
NA
0
#DIV/0!
#DIV/0!
S19P
#DIV/0!
Workpaper 1, Line 18, Col. (e)
Workpaper 1, Line 18, Col. (f)
Workpaper 1, Line 18, Col. (i)
(Sum of Lines 27 through 31)
0
0
CP*GPE
CP*GPE
CP*S19 W/S
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
-
NA
33 RATE BASE
(Line 22+ Line 25 + Line 26 + Line 32)
NA
#DIV/0!
Formula Rate - Non-Levelized
Rate Formula Template
Actual for the 12 Months Ended 12/31/2021
Utilizing FERC Form 1 Data
Rochester Gas and Electric Corporation
Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects
(1)
(2)
(3)
(4)
(5)
Schedule 19
Projects (Col 3 *
Col. 4)
Line
Company Total
(where
applicable)
ANNUAL TRANSMISSION REVENUE
Form No. 1 or Transmission
Formula Rate Reference
No. REQUIREMENT
Allocator (Note K)
OPERATIONS AND MAINTENANCE
EXPENSES (Note M)
34 Transmission - Direct Assign
35 Transmission - Allocate
36 Less: EPRI Dues in Account 566
37 Subtotal - Transmission to Allocate
38 Electric A&G
39 Less: EPRI Dues in A&G
40 Less: Regulatory Commission Expenses
41 Less: Property Insurance
42 Less: Account 930.2 Items
320-323.112.b fn
320-323.112.b fn
352-353
Line 35 - Line 36
320-323.197.b
352-353
320-323.189.b
320-323.185.b
Note L
0
0
0
0
0
0
0
0
0
DA
0
S19P
#DIV/0!
#DIV/0!
Line 38 - Line 39 - Line 40 - Line 41 -
Line 42
43 Adjusted Electric A&G
Plus: Transmission Related Regulatory
44 Expenses
0
0
S19 W/S
S19P
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
350-351 fn
Plus: Direct Assigned Regulatory
45 Commission Expenses (Note E)
46 Plus: Property Insurance
350-351 fn
320-323.185.b
NA
0
DA
GPE
0
0
#DIV/0!
#DIV/0!
#DIV/0!
47 TOTAL O&M
Sum of Lines 34, 37 and 43 through 46
NA
DEPRECIATION AND AMORTIZATION EXPENSE
48 Transmission
336.7.f, fn
336.10 f
336.1.d
0
0
0
0
0
DA
49 Electric General
50 Electric Intangible
51 Common Electric
52 TOTAL DEPRECIATION
S19 W/S
S19 W/S
S19 W/S
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
336.11.f
Sum of Lines 48 through 51
TAXES OTHER THAN INCOME TAXES
LABOR RELATED
53
Payroll (Note D)
262-263.8.l+262-263.16.l
0
CP*S19 W/S
#DIV/0!
#DIV/0!
#DIV/0!
54 PLANT RELATED
55
56
57
58
Real Estate
Franchise Tax
Gross Receipts Tax
Other
262-263.6.l
262-263
0
0
CP*GPE
CP*GPE
Note N
#DIV/0!
#DIV/0!
#DIV/0!
NA
0
0
0
262-263
59 TOTAL OTHER TAXES
Sum of Lines 53 and 55 through 58
0
#DIV/0!
INCOME TAXES (Note F)
T=1 - {[(1 - SIT) * (1 - FIT)] / (1 -
SIT * FIT * p)}=
1 / (1 - T)
60 Composite Tax Rate = T
61 Gross-up Factor
62 Income Tax Factor
0.0000%
0.0000
0.0000
T/(1-T)
Amortization of Investment Tax Credit (enter
63 negative)
Amortization of Excess Deferred Income
64 Taxes (enter negative)
65 Tax Effect of Permanent Differences
66 Income Tax Calculation
67 ITC adjustment
266-267.11. f, fn
NA
DA
0
0
Workpaper 3
Workpaper 4, Line 2, Col. (e)
(Line 72 * Line 62)
NA
NA
NA
NA
DA
DA
Calc
Calc
-
#DIV/0!
(Line 63 * Line 61)
0
Amortization of Excess Deferred Income Tax
68 Adjustment
69 Permanent Differences Tax Adjustment
70 TOTAL INCOME TAXES
(Line 64 * Line 61)
(Line 65 * Line 61)
Sum of Lines 66 through 69
NA
NA
NA
Calc
Calc
0
0
#DIV/0!
RETURN (Note H)
71 Debt
72 Common Equity and Preferred Stock
73 TOTAL RETURN
Workpaper 5, Line 12, Col. (i)
Workpaper 5, Line 12, Col. (f)
Sum of Lines 71 through 72
NA
NA
NA
Calc
Calc
#DIV/0!
#DIV/0!
#DIV/0!
ANNUAL TRANSMISSION REVENUE
REQUIREMENT BEFORE REVENUE
74 CREDITS
(Line 47 + Line 52 + Line 59 + Line 70 +
Line 73)
DA
DA
#DIV/0!
#DIV/0!
75 REVENUE CREDITS
(Line 99)
-
ANNUAL TRANSMISSION REVENUE
76 REQUIREMENT (ATRR)
(Line 74 + Line 75)
NA
NA
77 CORRECTIONS
Workpaper 9, Line 11, Col. (b)
0
0
ANNUAL TRUE-UP ADJUSTMENT (ATU)
78 (Note G)
Workpaper 7, Line 5
NA
NA
79 ATRR PLUS ATU AND CORRECTIONS
Sum of Lines 76 through 78
#DIV/0!
Formula Rate - Non-Levelized
Rate Formula Template
Actual for the 12 Months Ended 12/31/2021
Utilizing FERC Form 1 Data
Rochester Gas and Electric Corporation
Appendix A: Annual Transmission Revenue Requirement for Schedule 19 Projects
SUPPORTING CALCULATIONS AND NOTES
Line
No. TRANSMISSION PLANT ALLOCATOR
80 Electric Plant
81 Total Transmission Plant
82 Schedule 19 Projects
(Line 94)
(Line 2)
(Line 2)
0
0
0
83 Schedule 19 Projects Plant Allocator
84 Transmission Plant Allocator
(Line 82 / Line 81)
(Line 81 / Line 80)
#DIV/0! S19P
#DIV/0! TP
ELECTRIC WAGE AND SALARY
ALLOCATOR
85 Production
86 Transmission
87 Distribution
88 Other
354-355.20.b
354-355.21.b
354-355.23.b
0
0
0
0
0
354-355.24,25,26.b
Sum of Lines 85 through 88
(Line 86 / Line 89)
89 Total
90 Transmission Wage and Salary Allocator
#DIV/0!
T W/S
Schedule 19 Projects Wages and Salaries
91 (transmission wages and salary times S19P)
Schedule 19 Projects Wage and Salary
92 Allocator
Schedule 19 Projects Transmission Wage
93 and Salary Allocator
(Line 86 * Line 83)
(Line 91 / Line 89)
(Line 91 / Line 86)
#DIV/0!
#DIV/0!
#DIV/0!
S19 W/S
S19 W/S T
ELECTRIC COMMON PLANT ALLOCATOR
(CE)
94 Electric
95 Gas
96 Total (excludes common)
% Electric
0.000%
200-201.3.c+6.c
200-201.3.d+6.d
(Line 94 + Line 95)
0
0
0
CP=
REVENUE CREDITS
Account 454, Rent from Electric Property
97 (Note I)
300-301, fn
300-301, fn
-
Account 456, Other Electric Revenue (Note J)
98
-
-
99 Total Revenue Credits
Formula Rate - Non-Levelized
Rate Formula Template
Actual for the 12 Months Ended 12/31/2021
Utilizing FERC Form 1 Data
Rochester Gas and Electric 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
C
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.
D
E
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.
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 electe
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
H
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.
I
J
K
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
L
M
N
Rochester Gas and Electric 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.
RG&E 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:
Gross receipt tax rate
Revenue requirement
Gross Receipts Tax
0.00000%
-
-
Estimate of Line 79
O
For future use.
Effective Date: 7/3/2023 - Docket #: ER23-1817-005 - Page 1
NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor
Rochester Gas and Electric 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)
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)
2
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
Appendix A Line #
December
March
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
0
0
0
0
0
0
0
0
0
0
Miscellaneous Rate Base Items
Unfunded Liabilities
Materials and Supplies -
Assigned to Construction
(Electric and Gas)
Transmission Land Held
for Future Use
Schedule 19 Projects -
Land Held for Future Use
Materials & Supplies -
Transmission
Prepayments
Accumulated Provision
for Injuries and Damages
Miscellaneous Current
and Accrued Liabilities
Month
Year
Total
Sum of Columns (g)
through (h)
31
214, line 17 fn
26
214, line TBD
227, Line 8 fn
28
227, line 5 fn
110-111, line 57 fn
30
FF1 Reference
Appendix A Line #
112-113, line 28 fn
Account 242 - see below
26
29
13 December
14 March
15 June
16 September
17 December
18 Average
2020
2021
2021
2021
2021
-
-
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
-
-
-
-
0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
0
0
0
0
0
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
24 Average
2020
2021
2021
2021
2021
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
0
0
0
Rochester Gas and Electric 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
0
#DIV/0!
#DIV/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)
From Workpaper 2c, Line 14, Col. (r) or Workpaper 2d, Line 13, Col. (n)
Line 9 + Line 10
End of Previous Year ADIT
Average Beginning and End of Year
Prorated ADIT
10
11
Total ADIT
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.
Rochester Gas and Electric 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
Workpaper 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.
Rochester Gas and Electric 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
32
33
34
35
36
37
0
0
0
0
0
0
0
0
0
0
0
0
38 Total
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.
Rochester Gas and Electric 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)
(b)
(c)
(d)
(e)
(f)
(g)
ADIT-190 - Includes Only Items Applicable to
Schedule 19 Projects
Schedule 19
Projects
Related
Plant
Labor
Total
Excluded
Related
Related
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.
Rochester Gas and Electric 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
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.
Rochester Gas and Electric Corporation
Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year
(a)
(b)
(c)
(d)
(e)
(f)
(g)
ADIT-283 - Includes Only Items Applicable to
Schedule 19 Projects
Schedule 19
Projects
Related
Total
Plant
Related
Labor
Related
Excluded
Justification
27
28
29
30
31
32
33
0
0
0
0
0
0
0
0
0
0
0
0
34 Total
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.
Rochester Gas and Electric 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 = 2021
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)
(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
Month
Schedule 19
Projects
Transmission Plant Related Gross Plant
Proration
(f) x (h)
Plant Proration
(f) x (l)
Total Transmission
Prorated Amount (i)
+ (m) + (q)
Remaining in
Year After
in the
Projected
Allocator
(Appendix A)
Allocator Allocation
Projection Monthly Amount/
(General and (Appendix (n) * (o)
Current Month Rate Year
(d)/(e)
Ending Balance
Common)
A)
Line #
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!
31
335
307
276
246
215
185
154
123
93
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
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#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!
28
31
30
31
30
31
31
30
31
30
31
365
365
365
365
365
365
365
365
365
365
365
365
10 September
11 October
12 November
13 December
14 Prorated Balance
62
32
1
0.27%
#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 Workpaper 2d-Prior Year ADIT Proration Actual
Rochester Gas and Electric 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)
Difference between Actual activity (Col I)
projected and when projected activity
(m)
(n)
Preserve
proration when
actual monthly actual activity when is an increase while
and projected
monthly activity
are either both
increases or
decreases.
Number of
Days
Remaining in Total Days in
Year After Projected Rate
Month's
Accrual of
Deferred
Taxes
Difference
between
projected
monthly and
actual monthly
Proration
Percentage
(c)/(d)
Projected
Monthly
Activity
Prorated
Amount
* (f)
Prorated Projected
Actual Monthly
actual and
actual activity is a
Balance reflecting
Days in the
Month
Month
(e) Balance
Sum
Activity
(table
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.
Rochester Gas and Electric 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
Adjusted
Deficient or
Excess
Accumulated
Deferred
Taxes
Column (d) +
Column (e)
Deficient or
Excess
Accumulated
ADIT Balances
After
Schedule 19
Projects
Allocation
(UP)
ADIT Balances
Prior to
Remeasurement
Allocated to Unprotected
Remeasurement Deferred Taxes Adjustments After
(Note C) at December 31, Remeasurement
Column (b) * Line Column (b) -
43 Column (c)
Schedule 19
Projects
Column (f) *
Column (g)
Other (UO) Amortization
(Note B) Year
Balance at
December 31
Column (h) -
Column (j)
Amortization
Year
Balance at
December 31
Column (k) -
Column (l)
Line Description
Factors (Note B)
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.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
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 Income
18 Taxes
19 Gross Up
0
0
0
0
0
0
0
0
0
0
0
0
Total Deficient Accumulated Deferred Income
20 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
36 Taxes
37 Gross Up
0
0
0
0
0
0
0
0
0
0
0
0
Total Excess Accumulated Deferred Income
38 Taxes - Account 254
0
0
0
0
0
0
0
0
0
0
39 Grand Tota
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:
Effective Date: 7/3/2023 - Docket #: ER23-1817-005 - Page 1
NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor
Rochester Gas and Electric 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
Rochester Gas and Electric 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)
Five Quarter Average
Allocate Other Rate Base Items to Schedule 19 Projects
Net
Intangible Net Common Accumulated
Land Held for
Future Use -
Using
Net General
Plant - Using
Allocator
Plant -
Using
-
Plant -
-
Deferred Income
Taxes - Using
Allocator
Other Rate Base
Items - Using
Allocator
Gross Plant in
Service
Accumulated
Depreciation
Net Operating
Property
Using
(Excess)/Deficient
ADIT - Using Allocator
Total Rate
Base
Sum of Col.
Line #
Allocator
Allocator
Allocator
Allocator
Workpaper 1,
Line 6
Workpaper 1,
Line 12
Line 6 * Col. Line 6 * Col.
Line 6 * Col.
(c)
(e) through
Col. (l)
Reference
Project
Grouping 1
Calculated
#DIV/0!
Col. (b) + Col. (d)
-
Line 6 * Col. (c)
#DIV/0!
(c)
(c)
Line 6 * Col. (c)
#DIV/0!
Line 6 * Col. (c)
#DIV/0!
Line 6 * Col. (c)
#DIV/0!
1
2
3
-
-
-
-
-
-
-
-
#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!
6
Total
-
-
0
-
Appendix A,
Line 26
#DIV/0!
Appendix A, Appendix A, Appendix A, Appendix A, Line
Ref
Line 19
Line 20
Line 21
23
Appendix A, Line 24
Appendix A, Line 32
Weighted
Preferred and
Common Equity
Rate
Preferred and
Common Equity
Return
Weighted
Debt Rate
Rate Base
WACC
Return
Debt Return
Workpaper 6,
Lines 2 + 3, Lines
6 + 7, Lines 10 +
11 or Lines 14 +
15
Workpaper 6,
Line 4, Line 8,
Line 12, or
Line 16
Workpaper 6,
Line 1, Line 5,
Line 9 or Line
13
Col. (b) * Col.
(c)
Col. (b) * Col.
(e)
Reference
Project
Grouping 1
Col. (m)
#DIV/0!
Col. (b) * Col. (h)
#DIV/0!
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!
#DIV/0!
#DIV/0!
Project
Grouping 2
#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
Effective Date: 7/3/2023 - Docket #: ER23-1817-005 - Page 1
NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor
Rochester Gas and Electric 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
Capitalization
Cost Rates
WACC
1
2
3
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.60%
-
0.000%
0.000%
(Line 25, Col. (b)
0.00%
0.00%
0
or Lines 1 or 2,
Col. (k))
4
Total Capitalization
0
0.0%
#DIV/0!
Project Grouping 2
Capitalization
%s
%s
%s
Cost Rates
#DIV/0!
0.000%
0.000%
(Line 25, Col. (b)
or Lines 5 or 6,
Col. (k))
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%
ROE per New York State Public Service Commission, Case No.
ROE Cap
0.00%
10.60%
-
0.00%
0.00%
0
8
Total Capitalization
0
0.0%
#DIV/0!
Project Grouping 3
Capitalization
Cost Rates
#DIV/0!
0.000%
0.000%
(Line 25, Col. (b)
or Lines 9 or 10,
Col. (k))
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%
ROE per New York State Public Service Commission, Case No.
ROE Cap
0.00%
10.60%
-
0.00%
0.00%
0
12
Total Capitalization
0
0.0%
#DIV/0!
Project Grouping 4
Capitalization
Cost Rates
#DIV/0!
0.000%
0.000%
(Line 25, Col. (b)
WACC
#DIV/0!
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%
ROE per New York State Public Service Commission, Case No.
ROE Cap
0.00%
10.60%
-
0.00%
0.00%
0
or Lines 13 or 14,
Col. (k))
16
Total Capitalization
0
0.0%
#DIV/0!
Common Equity
Long-term Debt
Less:
Accumulated
Other
Common
Equity for
Capitalization
Col. (b) - Col.
Unamortized
Gains on
Reacquired Debt
Unamortized
Loss on
Reacquired Debt Capitalization
Long-term
Debt for
Less: Preferred Comprehensive
Stock Income
Unamortized Debt
Expense
Total
Total
Col. (g) + Col.
Month
Year
2020
2021
2021
2021
2021
112-113, l.16, fn 112-113, l.3, fn 112-113, l.15, fn (c) - Col. (d)
112-113, l.24, fn
112-113, l.61, fn 110-111, l.69, fn
110-111, l.81, fn (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)
23 Long Term Interest
24 Long-Term Debt
0
0
(Line 22, Col. (k))
25 Long-term Debt Interest Rate (Line 23 / Line 24)
#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.
Effective Date: 7/3/2023 - Docket #: ER23-1817-005 - Page 1
NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor
Rochester Gas and Electric 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, RG&E 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.
Rochester Gas and Electric 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.4
352
353
354
355
356
357
358
Land Rights
Structures and Improvements
Station Equipment
Towers and Fixtures
Poles and Fixtures
Overhead Conductors & Devices
Underground Conduit
Underground Conductors & Devices
Roads and Trails
1.33%
1.69%
1.92%
2.00%
2.17%
1.92%
1.57%
1.79%
NA
359
Electric General and Intangible
302
303
390
391
391.2
391.3
394
395
397
Franchises and Consents
Intangible Plant
Structures and Improvements
Office Furniture and Equipment
Computer Equipment
Office Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
NA
14.29%
2.18%
3.57%
14.29%
2.77%
3.43%
0.96%
3.63%
2.86%
6.67%
Communication Equipment
Communication Equipment - Overhead
Miscellaneous Equipment
397.1
398
Common
302
303
Franchises and Consents
Intangible Plant
NA
13.09%
2.98%
3.42%
13.09%
1.09%
10.00%
11.25%
8.18%
9.00%
8.18%
11.25%
10.00%
9.00%
390
391
Structures and Improvements
Office Furniture and Equipment
Computer Equipment
Office Equipment
Mini Passenger Vans
Passenger Cars
Full Size Pickups
Light Duty Gas Powered Utility Trucks
Heavy Duty Gas Powered Utility Trucks
Mini Cargo Vans
391.2
391.3
392.09
392.13
392.32
392.33
392.34
392.36
392.37
392.38
Full Size Cargo Vans
Mini Pickups
Heavy Duty Diesel Powered Utility Trucks
and Equipment
392.39
6.92%
Medium Duty Diesel Powered Utility
Trucks
Medium Duty Gas Power Utility Trucks
Stores Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
Power Operated Equipment
Communication Equipment
Miscellaneous Equipment
392.42
392.43
393
394
395
396
397
398
7.50%
8.18%
2.87%
2.91%
2.83%
7.69%
5.38%
6.25%
Note 1: The above depreciation rates cannot change absent Commission authorization
Rochester Gas and Electric 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.
Effective Date: 7/3/2023 - Docket #: ER23-1817-005 - Page 1