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
 Transmission Formula Rate

Schedule 19 Projects

Actual for the 12 Months Ended 12/31/2021
 Index

 

Workpaper Tab Description

A Appendix A Annual Transmission Revenue Requirement for Schedule 19 Projects

 

1 RB Items Average Balances for Most Rate Base Items

 

2a ADIT-Current Year Current Year Average Accumulated Deferred Income Taxes

 

2b ADIT-Prior Year Prior Year Average Accumulated Deferred Income Taxes

 

2c ADIT Proration Projected Proration of Projected Accumulated Deferred Income Taxes

 

2d ADIT Proration Actual Proration of Actual Accumulated Deferred Income Taxes

 

3 EADIT Excess Accumulated Deferred Income Tax Rate Base and Amortization

 

4 IT Permanent Differences Permanent Book/Tax Differences

 

5 Project Return Return on Schedule 19 Projects

 

6 Project Cost Of Capital Schedule 19 Projects Cost of Capital

 

7 True-up Adjustment Annual True-up Adjustment

 

Depreciation Rates Approved by the Commission and Used to Determine Schedule 19

8 Depreciation Rates Projects Depreciation and Amortization Expense

 

9 Corrections Prior Period Corrections

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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

 

Composite Depreciation Rates

(1) (2) (3) (4) (5)

Line

Company Total Schedule 19

Form No. 1 or Transmission (where Projects (Col 3 *

No. RATE BASE (Note A): Formula Rate Reference applicable) Allocator (Note K) Col. 4)

GROSS PLANT IN SERVICE

1 Production Workpaper 1, Line 6, Col. (c) 0 NA 0

2 Transmission Workpaper 1, Line 6, Col. (d) or Col. (m) 0 DA 0

3 Distribution Workpaper 1, Line 6, Col. (e) 0 NA 0

4 Electric General Workpaper 1, Line 6, Col. (f) 0 S19 W/S #DIV/0! #DIV/0!

5 Electric Intangible Workpaper 1, Line 6, Col. (b) 0 S19 W/S #DIV/0! #DIV/0!

6 Common Workpaper 1, Line 6, Col. (g) 0 CP*S19 W/S #DIV/0! #DIV/0!

7 TOTAL GROSS PLANT (Sum of Lines 1 through 6) 0 GP= #DIV/0! #DIV/0!

8 Without Common - For Gross Plant Allocator Calculation Only 0 GPE= #DIV/0! #DIV/0!

 

ACCUMULATED DEPRECIATION

9 Production Workpaper 1, Line 12, Col. (c) - NA 0

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

10 Transmission (m) - DA -

11 Distribution Workpaper 1, Line 12, Col. (e) - NA 0

12 Electric General Workpaper 1, Line 12, Col. (f) - S19 W/S #DIV/0! #DIV/0!

13 Electric Intangible Workpaper 1, Line 12, Col. (b) - S19 W/S #DIV/0! #DIV/0!

14 Common Workpaper 1, Line 12, Col. (g) - CP*S19 W/S #DIV/0! #DIV/0!

15 TOTAL ACCUM. DEPRECIATION (Sum of Lines 9 through 14) - #DIV/0!

 

NET PLANT IN SERVICE

16 Production (Line 1 - Line 9) 0 0

17 Transmission (Line 2 - Line 10) 0 0

18 Distribution (Line 3 - Line 11) 0 0

19 General (Line 4 - Line 12) 0 #DIV/0!

20 Intangible (Line 5 - Line 13) 0 #DIV/0!

21 Common (Line 6 - Line 14) 0 #DIV/0!

22 TOTAL NET PLANT (Sum of Lines 16 through 21) 0 #DIV/0!

ACCUMULATED DEFERRED INCOME

TAXES  (Note B)

23 Accumulated Deferred Income Taxes Workpaper 2a, Line 11, Col. (g) NA #DIV/0!

 

24 Excess Accumulated Deferred Income Taxes Workpaper 3 NA 0

TOTAL ACCUMULATED DEFERRED

25 INCOME TAXES (Line 23 + Line 24) #DIV/0!

 

26 LAND HELD FOR FUTURE USE Workpaper 1, Line 18, Col. (b) or (c) 0 DA 0

 

OTHER RATE BASE ITEMS

27 Cash Working Capital (Note C) (Line 47 times 45/360) NA #DIV/0!

28 Materials & Supplies  - Transmission Workpaper 1, Line 18, Col. (d) 0 S19P #DIV/0! #DIV/0!

Materials and Supplies - Electric and Gas -

29 Assigned to Construction Workpaper 1, Line 18, Col. (e) 0 CP*GPE #DIV/0! #DIV/0!

30 Prepayments Workpaper 1, Line 18, Col. (f) 0 CP*GPE #DIV/0! #DIV/0!

31 Unfunded Liabilities Workpaper 1, Line 18, Col. (i) - CP*S19 W/S #DIV/0! #DIV/0!

32 TOTAL OTHER RATE BASE ITEMS (Sum of Lines 27 through 31) NA #DIV/0!

 

33 RATE BASE (Line 22+ Line 25 + Line 26 + Line 32) NA #DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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)

Line

Company Total Schedule 19

ANNUAL TRANSMISSION REVENUE Form No. 1 or Transmission (where Projects (Col 3 *

No. REQUIREMENT Formula Rate Reference applicable) Allocator (Note K) Col. 4)

OPERATIONS AND MAINTENANCE

EXPENSES (Note M)

34 Transmission - Direct Assign 320-323.112.b fn 0 DA 0

35 Transmission - Allocate 320-323.112.b fn 0

36 Less:  EPRI Dues in Account 566 352-353 0

37 Subtotal - Transmission to Allocate Line 35 - Line 36 0 S19P #DIV/0! #DIV/0!

38 Electric A&G 320-323.197.b 0

39 Less:  EPRI Dues in A&G 352-353 0

40 Less: Regulatory Commission Expenses 320-323.189.b 0

41 Less: Property Insurance 320-323.185.b 0

42 Less:  Account 930.2 Items Note L 0

Line 38 - Line 39 - Line 40 - Line 41 -

43 Adjusted Electric A&G Line 42 0 S19 W/S #DIV/0! #DIV/0!

Plus: Transmission Related Regulatory

44 Expenses 350-351 fn 0 S19P #DIV/0! #DIV/0!

Plus:  Direct Assigned Regulatory

45 Commission Expenses (Note E) 350-351 fn NA DA 0

46 Plus: Property Insurance 320-323.185.b 0 GPE #DIV/0! #DIV/0!

 

47 TOTAL O&M Sum of Lines 34, 37 and 43 through 46 NA #DIV/0!

 

DEPRECIATION AND AMORTIZATION EXPENSE

 

 

48 Transmission 336.7.f, fn 0 DA 0

49 Electric General 336.10 f 0 S19 W/S #DIV/0! #DIV/0!

50 Electric Intangible 336.1.d 0 S19 W/S #DIV/0! #DIV/0!

51 Common Electric 336.11.f 0 S19 W/S #DIV/0! #DIV/0!

52 TOTAL DEPRECIATION Sum of Lines 48 through 51 0 #DIV/0!

 

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!

54 PLANT RELATED

55 Real Estate 262-263.6.l 0 CP*GPE #DIV/0! #DIV/0!

56 Franchise Tax 262-263 0 CP*GPE #DIV/0! #DIV/0!

57 Gross Receipts Tax NA Note N 0

58 Other 262-263 0 0

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

60 Composite Tax Rate = T * FIT * p)}= 0.0000%

61 Gross-up Factor 1 / (1 - T) 0.0000

62 Income Tax Factor T/(1-T) 0.0000

Amortization of Investment Tax Credit (enter

63 negative) 266-267.11. f, fn NA DA 0

Amortization of Excess Deferred Income

64 Taxes (enter negative) Workpaper 3 NA DA 0

65 Tax Effect of Permanent Differences Workpaper 4, Line 2, Col. (e) NA DA -

66 Income Tax Calculation (Line 72 * Line 62) NA Calc #DIV/0!

67 ITC adjustment (Line 63 * Line 61) NA Calc 0

Amortization of Excess Deferred Income Tax

68 Adjustment (Line 64 * Line 61) NA Calc 0

69 Permanent Differences Tax Adjustment (Line 65 * Line 61) NA Calc 0

70 TOTAL INCOME TAXES Sum of Lines 66 through 69 NA #DIV/0!

 

RETURN (Note H)

71 Debt Workpaper 5, Line 12, Col. (i) NA Calc #DIV/0!

72 Common Equity and Preferred Stock Workpaper 5, Line 12, Col. (f) NA Calc #DIV/0!

73 TOTAL RETURN Sum of Lines 71 through 72 NA #DIV/0!

 

 

ANNUAL TRANSMISSION REVENUE

REQUIREMENT BEFORE REVENUE (Line 47 + Line 52 + Line 59 + Line 70 +

74 CREDITS Line 73) DA #DIV/0!

 

75 REVENUE CREDITS (Line 99) DA -

 

ANNUAL TRANSMISSION REVENUE

76 REQUIREMENT (ATRR) (Line 74 + Line 75) NA #DIV/0!

 

77 CORRECTIONS Workpaper 9, Line 11, Col. (b) NA 0

 

ANNUAL TRUE-UP ADJUSTMENT (ATU)

78 (Note G) Workpaper 7, Line 5 NA 0

 

79 ATRR PLUS ATU AND CORRECTIONS Sum of Lines 76 through 78 NA #DIV/0!

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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 (Line 94) 0

81 Total Transmission Plant (Line 2) 0

82 Schedule 19 Projects (Line 2) 0

83 Schedule 19 Projects Plant Allocator (Line 82 / Line 81) #DIV/0! S19P

84 Transmission Plant Allocator (Line 81 / Line 80) #DIV/0! TP

ELECTRIC WAGE AND SALARY

ALLOCATOR

85 Production 354-355.20.b 0

86 Transmission 354-355.21.b 0

87 Distribution 354-355.23.b 0

88 Other 354-355.24,25,26.b 0

89 Total Sum of Lines 85 through 88 0

90 Transmission Wage and Salary Allocator (Line 86 / Line 89) #DIV/0! T W/S

 

Schedule 19 Projects Wages and Salaries

91 (transmission wages and salary times S19P) (Line 86 * Line 83) #DIV/0!

Schedule 19 Projects Wage and Salary

92 Allocator (Line 91 / Line 89) #DIV/0! S19 W/S

Schedule 19 Projects Transmission Wage and

93 Salary Allocator (Line 91 / Line 86) #DIV/0! S19 W/S T

ELECTRIC COMMON PLANT ALLOCATOR

(CE) % Electric

94 Electric 200-201.3.c+6.c 0

95 Gas 200-201.3.d+6.d 0 CP= 0.000%

96 Total (excludes common) (Line 94 + Line 95) 0

 

REVENUE CREDITS

Account 454, Rent from Electric Property (Note

97 I) 300-301, fn -

 

Account 456, Other Electric Revenue (Note J)

98 300-301, fn -

 

99 Total Revenue Credits -

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - Page 1


 

 

 

 

Formula Rate - Non-Levelized Rate Formula Template

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


 

 

 

Actual for the 12 Months Ended 12/31/2021


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.7.2.2 OATT Schedule 19 - Rochester Gas and Electric Cor

A  All amounts shown are based on five quarter averages which are contained in footnotes to the FF1 (with the following exceptions: CWC in line 28 which is based upon one-eighth of O&M, Accumulated

Deferred Income Taxes in line 24 which are a combination of beginning and end of year averages and proration amounts, and Excess Accumulated Deferred Income Taxes in line 25 which are beginning/ending year averages).

B The maximum accumulated deferred tax offset to rate base is calculated in accordance with the proration formula prescribed by IRS regulation section 1.167(l)-1(h)(6).

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

 

D Includes only FICA and unemployment taxes.

E 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 elected to utilize

amortization of tax credits against taxable income, rather than book tax credits to Account No. 255 and reduce rate base, must reduce its income tax expense by the amount of the Amortized Investment Tax Credit (Form 1, 266.8.f) multiplied by (1/1-T).  Any Excess or Deficient Deferred Income Taxes reduce or increase income tax expense by the amount of the expense multiplied by (1/1-T).

 

Inputs Required: FIT = 0.00%

SIT= 0.00% (State Income Tax Rate or Composite SIT)

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

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

H Debt cost rate = long-term interest  / long term debt.  Preferred cost rate = preferred dividends / preferred outstanding.  The ROE is determined by the New York Public Utilities Commission and capped by the

ROE determined by FERC.  The ROE Cap will be supported in the original filing and no change in ROE Cap may be made absent a filing with FERC.

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

J Includes revenue related to Schedule 19 Projects only.

K The following acronyms are used for allocators:

CP= common plant allocator (allocate common plant and common expenses to total electric)

DA= DA=direct assignment (the item is direct assigned to Schedule 19 Projects)

GP= gross plant allocator (allocated Schedule 19 Projects gross plant as % of electric and common plant)

GPE= gross electric plant allocator (allocated Schedule 19 Projects gross plant as % of total electric gross plant)

S19P= Schedule 19 Projects plant allocator (Schedule 19 Projects gross plant as % of total transmission gross plant)

S19 W/S= Schedule 19 Projects wage and salary allocator (Schedule 19 Projects wages and salaries as % of total electric wages and salaries)

S19 W/ST Schedule 19 Projects wages and salary allocator for transmission (Schedule 19 Projects wages and salaries as a % of transmission wages and salaries)
 NA= not applicable (the item is not applicable to Schedule 19 Projects)

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

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

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

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

N 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 0.00000%

Revenue requirement - Estimate of Line 79

Gross Receipts Tax -

O For future use.

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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

FF1 Reference 204-207, line 5 fn 204-207, line 46 fn 204-207, line 58 fn 204-207, Line 75 fn 204-207, l. 99 fn 355 fn 204-207, line 58 fn 204-207, line 58 fn 204-207, line 58 fn 204-207, line 58 fn 204-207, line 58 fn Sum of Columns (h)through (l)

Appendix A Line # 5 1 2 3 4 6 2 2 2 2 2 2

1 December 2020 - - - - - - - - - - - -

2 March 2021 - - - - - - - - - - - -

3 June 2021 - - - - - - - - - - - -

4 September 2021 - - - - - - - - - - - -

5 December 2021 - - - - - - - - - - - -

6 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

 

FF1 Reference 200-201.21c 219, lines 20-24 fn 219, line 25 fn 219, line 26 fn 219, line 28 fn 355 fn 219, line 25 fn 219, line 25 fn 219, line 25 fn 219, line 25 fn 219, line 25 fn Sum of Columns (h)through (l)

 

Appendix A Line # 13 9 10 11 12 14 10 10 10 10 10 10

7 December 2020 - - - - - - - - - - - -

8 March 2021 - - - - - - - - - - - -

9 June 2021 - - - - - - - - - - - -

10 September 2021 - - - - - - - - - - - -

11 December 2021 - - - - - - - - - - - -

12 Average 0 0 0 0 0 0 0 0 0 0 0 -

 

 

Miscellaneous Rate Base Items

Unfunded Liabilities

Materials and Supplies -

Transmission Land Held Schedule 19 Projects - Materials & Supplies - Assigned to Construction Prepayments

for Future Use Land Held for Future Use Transmission (Electric and Gas) Accumulated Provision for Miscellaneous Current and

Month Year Injuries and Damages Accrued Liabilities Total

214, line 17 fn 214, line TBD 227, Line 8 fn 227, line 5 fn 110-111, line 57 fn Sum of Columns (g)

FF1 Reference 112-113, line 28 fn Account 242 - see below through (h)

Appendix A Line # 26 26 28 29 30 31

13 December 2020 - - - - - - - -

14 March 2021 - - - - - - - -

15 June 2021 - - - - - - - -

16 September 2021 - - - - - - - -

17 December 2021 - - - - - - - -

18 Average 0 0 0 0 0 0 0 0

 

 

 

 

Unfunded Liabilities - Account 242

Month Accrued Vacation Other Total

FF1 Reference NA NA

Appendix A Line # NA NA

19 December 2020 - - -

20 March 2021 - - -

21 June 2021 - - -

22 September 2021 - - -

23 December 2021 - - -

24 Average 0 0 0

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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

Nonprorated Items Related Related ADIT

Current Year

1 ADIT-190 0 0 0 (Line 24)

2 ADIT-282 0 0 0 (Line 30)

3 ADIT-283 0 0 0 (Line 38)

4 Subtotal 0 0 0 (Line 1 + Line 2 + Line 3)

5 Schedule 19 Projects W/S Allocator #DIV/0! Appendix A

6 GP Allocator #DIV/0! Appendix A

7 End of  Year ADIT 0 #DIV/0! #DIV/0! #DIV/0! (Line 4 * Line 5 or Line 6)

8 End of  Previous Year ADIT 0 #DIV/0! #DIV/0! #DIV/0! Workpaper 2b, Line 7

9 Average Beginning and End of Year 0 #DIV/0! #DIV/0! #DIV/0! (Average of Line 7 + Line 8)

10 Prorated ADIT #DIV/0! From Workpaper 2c, Line 14, Col. (r) or Workpaper 2d, Line 13, Col. (n)

11 Total ADIT #DIV/0! Line 9 + Line 10

 

 

 

In filling out this attachment, a full and complete description of each item and justification for the allocation to Columns B-G and each separate ADIT item will be listed,

dissimilar items with amounts exceeding $100,000 will be listed separately;

 

(a) (b) (c) (d) (e) (f) (g) (h)

ADIT-190 - Includes Only Items Applicable to Schedule Schedule 19

19 Projects Projects Plant Labor

Total Excluded Related Related Related Justification

12 0 0 0 0 0

13 0 0 0 0 0

14 0 0 0 0 0

15 0 0 0 0 0

16 0 0 0 0 0

17 0 0 0 0 0

18 0 0 0 0 0

19 0 0 0 0 0

20 0 0 0 0 0

21 0 0 0 0 0

22 0 0 0 0 0

23 0 0 0 0 0

24 Total 0 0 0 0 0

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) (b) (c) (d) (e) (f) (g) (h)

ADIT- 282 - Includes Only Items Applicable to Schedule 19

Schedule 19 Projects Total Projects Plant Labor

Excluded Related Related Related Justification

25 Depreciation - Liberalized Depreciation - Prorated #DIV/0! 0 #DIV/0! 0 0 Worksheet 2c, Line 14, Col. (r)

26 0

27 0

28 0

29 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) (b) (c) (d) (e) (f) (g) (h)

ADIT-283 - Includes Only Items Applicable to Schedule Schedule 19

19 Projects Total Projects Plant Labor

Excluded Related Justification

31 Cost of Removal 0 0 0 0

32 0 0

33 0

34 0

35 0

36 0

37 0

38 Total 0 0 0 0 0

 

Instructions for Account 283:

1. ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2. ADIT items related to Plant are included in Column E

3. ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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

Nonprorated Items Related Related ADIT

Prior Year

1 ADIT-190 0 0 0 (Line 20)

2 ADIT-282 0 0 0 (Line 26)

3 ADIT-283 0 0 0 (Line 34)

4 Subtotal 0 0 0 (Line 1 + Line 2 + Line 3)

5 Schedule 19 Projects W/S Allocator #DIV/0! Appendix A

6 GP Allocator #DIV/0! Appendix A

7 Prior Year ADIT 0 #DIV/0! #DIV/0! #DIV/0! (Line 4 * Line 5 or Line 6)

 

 

In filling out this attachment, a full and complete description of each item and justification for the allocation to Columns B-G and each separate ADIT item will be listed,

dissimilar items with amounts exceeding $100,000 will be listed separately;

 

(a) (b) (c) (d) (e) (f) (g)

ADIT-190 - Includes Only Items Applicable to Schedule Schedule 19

19 Projects Projects Plant Labor

Total Excluded Related Related Related Justification

8 0 0 0 0 0

9 0 0 0 0 0

10 0 0 0 0 0

11 0 0 0 0 0

12 0 0 0 0 0

13 0 0 0 0 0

14 0 0 0 0 0

15 0 0 0 0 0

16 0 0 0 0 0

17 0 0 0 0 0

18 0 0 0 0 0

19 0 0 0 0 0

20 Total 0 0 0 0 0

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 Schedule 19

19 Projects Projects Plant Labor

Excluded Related Related Related Justification

21 Depreciation - Liberalized Depreciation - Prorated #DIV/0! 0 #DIV/0! 0 0 W orkpaper 2d, Line 13, Col. (n)

22 0 0

23 0

24 0

25 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 Schedule 19

19 Projects Total Projects Plant Labor

Excluded Related Related Related Justification

27 Cost of Removal 0 0 0 0

28 0 0

29 0

30 0

31 0

32 0

33 0

34 Total 0 0 0 0 0

 

Instructions for Account 283:

1.  ADIT items related only to Schedule 19 Projects are directly assigned to Column D

2.  ADIT items related to Plant are included in Column E

3.  ADIT items related to Labor are included in Column F

4. Deferred income taxes arise when items are included in taxable income in different periods than they are included in book income.

If the item giving rise to the ADIT is not included in the annual transmission revenue requirement ("ATRR"), the associated ADIT amount shall be excluded.

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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) (c) (d) (e) (f) (g) (h) (i) (j) (k) (l) (m) (n) (o) (p) (q) (r)

Beginning Balance & Monthly Changes Year Days in the Number of Days Total Days Weighting Beginning Schedule 19 Transmission Plant Related   Gross Plant Plant Plant Proration Labor W/S Labor Labor Total Transmission

Month Remaining in in the for Balance/ Projects Proration Allocator Allocation (j) (f) x (l) Related Allocator Allocation Proration Prorated Amount (i)

Year After Projected Projection Monthly Amount/ (f) x (h) (Appendix A) * (k) (General and (Appendix (n) * (o) (f) x (p) + (m) + (q)

Current Month Rate Year (d)/(e) Ending Balance Common) A)

Line #

 

December 31st balance of Prorated

1 ADIT (Note B) 2020 100.00% #DIV/0! #DIV/0! #DIV/0! #DIV/0!

2 January 2021 31 335 365 91.78% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

3 February 2021 28 307 365 84.11% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

4 March 2021 31 276 365 75.62% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

5 April 2021 30 246 365 67.40% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

6 May 2021 31 215 365 58.90% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

7 June 2021 30 185 365 50.68% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

8 July 2021 31 154 365 42.19% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

9 August 2021 31 123 365 33.70% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

10 September 2021 30 93 365 25.48% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

11 October 2021 31 62 365 16.99% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

12 November 2021 30 32 365 8.77% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

13 December 2021 31 1 365 0.27% 0 0 0 0 #DIV/0! #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

14 Prorated Balance 365 #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

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 2d: Accumulated Deferred Income Taxes - Actual Proration
 Actual for the 12 Months Ended 12/31/2021

 

Year = 2021

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

 

 

Account 282 (Note A)

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - Page 1


 

(a)

 

 

 

 

 

Month


Days in Period

(b) (c) (d)

Number of
 Days

Remaining in  Total Days in

Days in the Year After  Projected Rate

Month Month's Year (Line 14,

Accrual of Col b)

Deferred
 Taxes


Projection - Proration of Projected Deferred Tax

(e) (f) (g) (h)

 

 

 

Proration Projected Prorated Prorated Projected

Percentage Monthly Amount (e) Balance Sum

(c)/(d) Activity * (f) of (g)


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

(i) (j) (k) (l) (m) (n)

Preserve Difference between  Actual activity (Col I)

Difference proration when projected and when projected activity

between actual monthly  actual activity when is an increase while

Actual Monthly projected and projected actual and actual activity is a Balance reflecting

Activity (table monthly and monthly activity projected activity  decrease OR projected proration or averaging  (n)

below, grand total) actual monthly are either both are either both activity is a decrease + (k) +((l) + (m))/2

activity (i) - increases or increases or while actual activity is

(f) decreases. decreases. an increase.

(See Note A) (See Note A) (See Note A)


 

1 December 31st balance 0 0


2 January 31 335 365 91.78% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


3 February 28 307 365 84.11% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


4 March 31 276 365 75.62% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


5 April 30 246 365 67.40% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


6 May 31 215 365 58.90% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


7 June 30 185 365 50.68% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


8 July 31 154 365 42.19% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


9 August 31 123 365 33.70% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


10 September 30 93 365 25.48% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


11 October 31 62 365 16.99% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


12 November 30 32 365 8.77% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


13 December 31 1 365 0.27% 0 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!


14 Total 365 0 0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

 

 

Gross Plant Labor Related

Schedule 19 Allocator (General and W/S Allocator (Appendix Grand Total (b) +

Projects Plant Related (Appendix A)  Total (d) * (e) Common) A) Total (g) * (h) (f) + (i)

Actual Monthly Activity

15 January 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

16 February 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

17 March 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

18 April 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

19 May 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

20 June 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

21 July 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

22 August 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

23 September 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

24 October 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

25 November 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

26 December 0 0 #DIV/0! #DIV/0! 0 #DIV/0! #DIV/0! #DIV/0!

 

 

Note A:  The calculations of ADIT amounts resulting from liberalized depreciations are performed in accordance with the proration requirements of Treasury Regulation Section 1.167(l)-1(h)(6).

Differences attributable to over-projection of ADIT in the annual projection will result in a proportionate reversal of the projected prorated ADIT activity to the extent of the over-projection.

Differences attributable to under-projection of ADIT in the annual projection will result in an adjustment to the projected prorated ADIT activity by the difference between the projected monthly activity and the actual monthly activity. However, when projected monthly ADIT activity is an increase and actual monthly ADIT activity is a decrease, actual monthly ADIT activity will be used.
Likewise, when projected monthly ADIT activity is a decrease and actual monthly ADIT activity is an increase, actual monthly ADIT activity will be used.


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

Adjusted Unprotected

Deficient or Deficient or Property

ADIT Balances Excess Excess Schedule 19 (UP)

ADIT Balances After Accumulated Accumulated Projects Allocated to Unprotected

Prior to Remeasurement Deferred Taxes Adjustments After Deferred Allocation Schedule 19 Other (UO) Amortization Balance at Amortization Balance at

Line Description Remeasurement (Note C) at December 31, Remeasurement Taxes Factors (Note B) Projects (Note B) Year December 31 Year December 31

Column (b) * Line Column (b) - Column (d) + Column (f) * Column (h) - Column (k) -

43 Column (c) Column (e) Column (g) Column (j) Column (l)

Deficient Deferred Income Taxes -

amortized to 410.1

FERC Account 190

1 0 0 0 0 0 0.000% 0 0 0 0 0

2 0 0 0 0 0 0.000% 0 0 0 0 0

3 0 0 0 0 0 0.000% 0 0 0 0 0

4 0 0 0 0 0 0.000% 0 0 0 0 0

5 0 0 0 0 0 0.000% 0 0 0 0 0

6 Total FERC Account 190 0 0 0 0 0 0 0 0 0 0

 

FERC Account 282

7 0 0 0 0 0 0.000% 0 0 0 0 0

8 0 0 0 0 0 0.000% 0 0 0 0 0

9 0 0 0 0 0 0.000% 0 0 0 0 0

10 0 0 0 0 0 0.000% 0 0 0 0 0

11 Total Account 282 0 0 0 0 0 0 0 0 0 0

 

FERC Account 283

12 0 0 0 0 0 0.000% 0 0 0 0 0

13 0 0 0 0 0 0.000% 0 0 0 0 0

14 0 0 0 0 0 0.000% 0 0 0 0 0

15 0 0 0 0 0 0.000% 0 0 0 0 0

16 0 0 0 0 0 0.000% 0 0 0 0 0

17 Total FERC Account 283 0 0 0 0 0 0 0 0 0 0

 

Subtotal Before Being Grossed up for Income

18 Taxes 0 0 0 0 0 0 0

19 Gross Up 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 0 0 0 0 0 0.000% 0 0 0 0 0

22 0 0 0 0 0 0.000% 0 0 0 0 0

23 Total Account 190 0 0 0 0 0 0 0 0 0 0

 

FERC Account 282

24 Accelerated Depreciation 0 0 0 0 0 0.000% 0 P 0 0 0 0

25 0 0 0 0 0 0.000% 0 0 0 0 0

26 0 0 0 0 0 0.000% 0 0 0 0 0

27 0 0 0 0 0 0.000% 0 0 0 0 0

28 0 0 0 0 0 0.000% 0 0 0 0 0

29 Total Account 282 0 0 0 0 0 0 0 0 0 0

 

FERC Account 283

30 0 0 0 0 0 0.000% 0 0 0 0 0

31 0 0 0 0 0 0.000% 0 0 0 0 0

32 0 0 0 0 0 0.000% 0 0 0 0 0

33 0 0 0 0 0 0.000% 0 0 0 0 0

34 0 0 0 0 0 0.000% 0 0 0 0 0

35 Total Account 283 0 0 0 0 0 0 0 0 0 0

 

Subtotal Before Being Grossed up for Income

36 Taxes 0 0 0 0 0 0 0

37 Gross Up 0 0 0 0 0

Total Excess Accumulated Deferred Income

38 Taxes - Account 254 0 0 0 0 0

 

39 Grand Total 0 0 0 0 0

 

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 New nominal rate 1.0%

42 Prior nominal rate 1.0%

43 Remeasurement Factor 100.0%

Note D:
Note E:
Note F:

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 AFUDC Equity Other 2 Other 3 Total

Permanent Schedule 19

Book/Tax Projects

Line # Differences

FF1 Reference

1 Amount - 0 0 -

 

2 Income Tax Effect - 0 0 -

Line 1 * Line 1 * Line 1 *

Composite Composite Composite Sum of

Income Tax Income Tax Income Tax Columns (b), (c)

Ref Rate Rate Rate and (d)

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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 Net Allocate Other Rate Base Items to Schedule 19 Projects

 

Intangible Net Common Accumulated Land Held for

Net General Plant - - Plant - - Deferred Income Future Use - Other Rate Base

Gross Plant in Accumulated Net Operating Plant - Using Using Using Taxes - Using (Excess)/Deficient Using Items - Using Total Rate

Line # Service Allocator Depreciation Property Allocator Allocator Allocator Allocator ADIT - Using Allocator Allocator Allocator

BaseSum of Col.

W orkpaper 1, W orkpaper 1, Line 6 * Col. Line 6 * Col. Line 6 * Col. (e) through

ProjectReference Line 6 Calculated Line 12 Col. (b) + Col. (d) Line 6 * Col. (c) (c) (c) Line 6 * Col. (c) Line 6 * Col. (c) (c) Line 6 * Col. (c) Col. (l)

 

1 Grouping 1 - #DIV/0! - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

2 ProjectGrouping 2 - #DIV/0! - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

Project

3 Grouping 3 - #DIV/0! - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

4 ProjectGrouping 4 - #DIV/0! - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

5 #DIV/0! - #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

6 Total - #DIV/0! - - #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 - #DIV/0! #DIV/0!

Appendix A, Appendix A, Appendix A, Appendix A, Appendix A, Appendix A, Line

Ref Line 19 Line 20 Line 21 Line 23 Appendix A, Line 24 Line 26 32

W eightedPreferred and

Preferred and

Common Equity Common W eighted

Rate Base WACC Return Rate Equity Return Debt Rate Debt Return

 

W orkpaper 6,

W orkpaper 6, Lines 2 + 3, W orkpaper 6,

Line 4, Line 8, Lines 6 + 7, Line 1, Line

Line 12, or Col. (b) * Col. Lines 10 + 11 or Col. (b) * Col. 5, Line 9 or

Reference Col. (m) Line 16 (c) Lines 14 + 15 (e) Line 13 Col. (b) * Col. (h)

7 ProjectGrouping 1 #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0!

 

Project

8 Grouping 2 #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0!

 

9 ProjectGrouping 3 #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0!

 

Project

10 Grouping 4 #DIV/0! #DIV/0! #DIV/0! 0.00% #DIV/0! #DIV/0! #DIV/0!

 

11 #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

12 Total #DIV/0! #DIV/0! #DIV/0! #DIV/0!

 

 

 

Schedule 19 Projects Included in Each Project Group

Project Project Gross

Project Name Description Investment

Grouping 1

 

 

 

 

 

 

 

 

 

 

 

ProjectGrouping 2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ProjectGrouping 3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Project

Grouping 4

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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) (d) (e) (f) (g) (h) (i) (j) (k)

Line # Project Grouping 1 (Note A)

Capitalization %s Cost Rates WACC

1 Long Term Debt Line 22, Col. (k) 0 0.0% #DIV/0! #DIV/0! ROE per New York State Public Service Commission, Case No. 0.00%

2 Preferred Stock Line 22, Col. (c) - 0.0% 0.000% 0.00% ROE Cap 10.87%

3 Common Stock Line 22, Col. (e) 0 0.0% 0.000% 0.00%

(Line 25, Col. (b)

or Lines 1 or 2,

4 Total Capitalization 0 0.0% Col. (k)) #DIV/0!

 

 

 

Project Grouping 2

Capitalization %s Cost Rates WACC

5 Long Term Debt Line 22, Col. (k) 0 0.0% #DIV/0! #DIV/0! ROE per New York State Public Service Commission, Case No. 0.00%

6 Preferred Stock Line 22, Col. (c) - 0.0% 0.000% 0.00% ROE Cap 10.87%

7 Common Stock Line 22, Col. (e) 0 0.0% 0.000% 0.00%

(Line 25, Col. (b)

or Lines 5 or 6,

8 Total Capitalization 0 0.0% Col. (k)) #DIV/0!

 

 

 

Project Grouping 3

Capitalization %s Cost Rates WACC

9 Long Term Debt Line 22, Col. (k) 0 0.0% #DIV/0! #DIV/0! ROE per New York State Public Service Commission, Case No. 0.00%

10 Preferred Stock Line 22, Col. (c) - 0.0% 0.000% 0.00% ROE Cap 10.87%

11 Common Stock Line 22, Col. (e) 0 0.0% 0.000% 0.00%

(Line 25, Col. (b)

or Lines 9 or 10,

12 Total Capitalization 0 0.0% Col. (k)) #DIV/0!

 

 

 

Project Grouping 4

Capitalization %s Cost Rates WACC

13 Long Term Debt Line 22, Col. (k) 0 0.0% #DIV/0! #DIV/0! ROE per New York State Public Service Commission, Case No. 0.00%

14 Preferred Stock Line 22, Col. (c) - 0.0% 0.000% 0.00% ROE Cap 10.87%

15 Common Stock Line 22, Col. (e) 0 0.0% 0.000% 0.00%

(Line 25, Col. (b)

or Lines 13 or 14,

16 Total Capitalization 0 0.0% Col. (k)) #DIV/0!

 

 

 

Common Equity Long-term Debt

Less:

Accumulated

Other Common Unamortized Unamortized Loss Long-term Debt

Less: Preferred Comprehensive Equity for Gains on Unamortized Debt on Reacquired for

Total Stock Income Capitalization Total Reacquired Debt Expense Debt Capitalization

Col. (b) - Col. Col. (g) + Col.

Month Year 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 2020 - - - - -

18 March 2021 - - - - -

19 June 2021 - - - - -

20 September 2021 - - - - -

21 December 2021 - - - - -

22 Average -

 

 

 

(114-117c, sum of

lines 62, 63, 64, 65,

23 Long Term Interest 66) 0

24 Long-Term Debt (Line 22, Col. (k)) 0

25 Long-term Debt Interest Rate (Line 23 / Line 24) #DIV/0!

 

26 Preferred Dividends 118-119c, l.29 -

27 Preferred Stock (Line 22 , Col. (c)) -

28 Preferred Stock Rate (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-003 - 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 A ATRR based on actual costs included for the previous calendar year 0

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

3 C Difference  (A-B) 0 0

4 D Future Value Factor (1+i)^24 1.0000 1.0000

5 E True-up Adjustment (C*D) 0 0 0

6 F Interest Rate True-up  (Note 1) 0

 

 

Where:

i= average interest rate as calculated below

 

Interest on Amount of Refunds or Surcharges Estimated Actual

Monthly Monthly

Month Year Interest Rate Interest Rate

7 July Year 1 0.0000% 0.0000%

8 August Year 1 0.0000% 0.0000%

9 September Year 1 0.0000% 0.0000%

10 October Year 1 0.0000% 0.0000%

11 November Year 1 0.0000% 0.0000%

12 December Year 1 0.0000% 0.0000%

13 January Year 2 0.0000% 0.0000%

14 February Year 2 0.0000% 0.0000%

15 March Year 2 0.0000% 0.0000%

16 April Year 2 0.0000% 0.0000%

17 May Year 2 0.0000% 0.0000%

18 June Year 2 0.0000% 0.0000%

19 July Year 2 0.0000% 0.0000%

20 August Year 2 0.0000% 0.0000%

21 September Year 2 0.0000% 0.0000%

22 October Year 2 0.0000% 0.0000%

23 November Year 2 0.0000% 0.0000%

24 December Year 2 0.0000% 0.0000%

25 January Year 3 0.0000% 0.0000%

26 February Year 3 0.0000% 0.0000%

27 March Year 3 0.0000% 0.0000%

28 April Year 3 0.0000% 0.0000%

29 May Year 3 0.0000% 0.0000%

30 June Year 3 0.0000% 0.0000%

 

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.

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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 Land Rights 1.33%

352 Structures and Improvements 1.69%

353 Station Equipment 1.92%

354 Towers and Fixtures 2.00%

355 Poles and Fixtures 2.17%

356 Overhead Conductors & Devices 1.92%

357 Underground Conduit 1.57%

358 Underground Conductors & Devices 1.79%

359 Roads and Trails NA

 

Electric General and Intangible

302 Franchises and Consents NA

303 Intangible Plant 14.29%

390 Structures and Improvements 2.18%

391 Office Furniture and Equipment 3.57%

391.2 Computer Equipment 14.29%

391.3 Office Equipment 2.77%

394 Tools, Shop and Garage Equipment 3.43%

395 Laboratory Equipment 0.96%

397 Communication Equipment 3.63%

397.1 Communication Equipment - Overhead 2.86%

398 Miscellaneous Equipment 6.67%

 

Common

302 Franchises and Consents NA

303 Intangible Plant 13.09%

390 Structures and Improvements 2.98%

391 Office Furniture and Equipment 3.42%

391.2 Computer Equipment 13.09%

391.3 Office Equipment 1.09%

392.09 Mini Passenger Vans 10.00%

392.13 Passenger Cars 11.25%

392.32 Full Size Pickups 8.18%

392.33 Light Duty Gas Powered Utility Trucks 9.00%

392.34 Heavy Duty Gas Powered Utility Trucks 8.18%

392.36 Mini Cargo Vans 11.25%

392.37 Full Size Cargo Vans 10.00%

392.38 Mini Pickups 9.00%

Heavy Duty Diesel Powered Utility Trucks

392.39 and Equipment 6.92%

 

392.42 Medium Duty Diesel Powered Utility Trucks 7.50%

392.43 Medium Duty Gas Power Utility Trucks 8.18%

393 Stores Equipment 2.87%

394 Tools, Shop and Garage Equipment 2.91%

395 Laboratory Equipment 2.83%

396 Power Operated Equipment 7.69%

397 Communication Equipment 5.38%

398 Miscellaneous Equipment 6.25%

 

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

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - 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 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

Line Impact of Revenue

No. Description Source Correction Requirement

 

1 Filing Name and Date

2 Original Revenue Requirement 0

 

3 Description of Correction 1 0

4 Description of Correction 2 0

 

 

5 Total Corrections (Line 3 + Line 4) 0

 

6 Corrected Revenue Requirement (Line 2 + Line 5) 0

 

7 Total Corrections (Line 5) 0

 

8 Average Monthly FERC Refund Rate Note A 0.00%

9 Number of Months of Interest Note B 0

10 (Line 7 * Line 8 *

Interest on Correction Line 9) 0

 

11 Sum of Corrections Plus Interest (Line 7 + Line 10) 0

 

 

Notes:

A  The interest rate on corrections will be the average monthly FERC interest rate for the period from the beginning of the year being

corrected through the end of the rate year where the correction is reflected in rates - the same as how interest on the Annual Trueup Adjustment is computed.

B  The number of months in which interest is computed is from the middle of the rate year in which the correction is needed to the

middle of the rate year where the correction is reflected in rates - the same as how interest on the Annual True-up Adjustment is
computed.

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

 

Effective Date: 7/3/2023 - Docket #: ER23-1817-003 - Page 1