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