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
Index

Page 1 of 16

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  TabDescription

AAppendix AAnnual Transmission Revenue Requirement for Schedule 19 Projects

 

1RB ItemsAverage Balances for Most Rate Base Items

 

2aADIT-Current YearCurrent Year Average Accumulated Deferred Income Taxes

 

2bADIT-Prior YearPrior Year Average Accumulated Deferred Income Taxes

 

2cADIT Proration ProjectedProration of Projected Accumulated Deferred Income Taxes

 

2dADIT Proration ActualProration of Actual Accumulated Deferred Income Taxes

 

3EADITExcess Accumulated Deferred Income Tax Rate Base and Amortization

 

4IT Permanent DifferencesPermanent Book/Tax Differences

 

5Project ReturnReturn on Schedule 19 Projects

 

6Project Cost Of CapitalSchedule 19 Project Cost of Capital

 

7True-up AdjustmentAnnual True-up Adjustment

 

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

8Depreciation RatesProjects Depreciation and Amortization Expense

 

9CorrectionsPrior Period Corrections

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

 

 

 

 

Section 6.19.7.2.2
Appendix A

Page 2 of 16

 

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedTransmission Formula Rate TemplateActual 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

Form No. 1 or Transmission(whereSchedule 19

No.RATE BASE (Note A):Formula Rate Referenceapplicable)Allocator (Note K)Projects

GROSS PLANT IN SERVICE

1ProductionWorksheet 1, Line 6, Col. (c)0NA0

Worksheet 1, Line 6, Col. (d) or Col.

2Transmission(m)0DA0

3DistributionWorksheet 1, Line 6, Col. (e)0NA0

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

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

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

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

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

 

ACCUMULATED DEPRECIATION

9ProductionWorksheet 1, Line 12, Col. (c)-NA0

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

10Transmission(m)-DA-

11DistributionWorksheet 1, Line 12, Col. (e)-NA0

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

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

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

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

 

NET PLANT IN SERVICE

16Production(Line 1 - Line 9)00

17Transmission(Line 2 - Line 10)00

18Distribution(Line 3 - Line 11)00

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

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

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

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

 

23CWIP (Note O)Worksheet 1, Line 18, Col. (g)NA-

 

24ABANDONNED PLANTWorksheet 1, Line 18, Col. (j)NA0

 

ACCUMULATED DEFERRED INCOME

TAXES  (Note B)

25Accumulated Deferred Income TaxesWorksheet 2a, Line 11, Col. (g)NA#DIV/0!

 

26Excess Accumulated Deferred Income Taxes3-EDITNA0

TOTAL ACCUMULATED DEFERRED

27INCOME TAXES(Line 25 + Line 26)#DIV/0!

 

28LAND HELD FOR FUTURE USEWorksheet 1, Line 18, Col. (h) or (i)0DA0

 

OTHER RATE BASE ITEMS

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

30Materials & Supplies  - TransmissionWorksheet 1, Line 18, Col. (k)0S19P#DIV/0!#DIV/0!

Materials and Supplies - Electric and Gas -

31Assigned to ConstructionWorksheet 1, Line 18, Col. (l)0CP*GPE#DIV/0!#DIV/0!

32PrepaymentsWorksheet 1, Line 18, Col. (m)0CP*GPE#DIV/0!#DIV/0!

33Regulatory Asset (Note E)Worksheet 1, Line 18, Col. (n)NADA0

34Unfunded LiabilitiesWorksheet 1, Line 18, Col. (q)-CP*S19 W/S#DIV/0!#DIV/0!

35TOTAL OTHER RATE BASE ITEMS(Sum of Lines 29 through 34)NA#DIV/0!

 

(Line 22 + Line 23 + Line 24 + Line 27

36RATE BASE+ Line 28 + Line 35)NA#DIV/0!

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

 

 

 

 

Section 6.19.7.2.2
Appendix A

Page 3 of 16

 

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedRate Formula TemplateActual 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

ANNUAL TRANSMISSION REVENUEForm No. 1 or Transmission(whereSchedule 19

No.REQUIREMENTFormula Rate Referenceapplicable)Allocator (Note K)Projects

OPERATIONS AND MAINTENANCE

EXPENSES

37Transmission - Direct Assign320-323.112.b fn0DA0

38Transmission - Allocate320-323.112.b fn0

39Less:  EPRI Dues in Account 566352-3530

40Subtotal - Transmission to AllocateLine 38 - Line 390S19P#DIV/0!#DIV/0!

41Electric A&G320-323.197.b0

42Less:  EPRI Dues in A&G352-3530

43Less: Regulatory Commission Expenses320-323.189.b0

44Less: Property Insurance320-323.185.b0

45Less:  Account 930.2 ItemsNote L0

Line 41 - Line 42 - Line 43 - Line 44 -

46Adjusted Electric A&GLine 450S19 W/S#DIV/0!#DIV/0!

Plus: Transmission Related Regulatory

47Expenses350-351 fn0S19P#DIV/0!#DIV/0!

Plus:  Direct Assigned Regulatory

48Commission Expenses350-351 fnNADA0

49Plus: Property Insurance320-323.185.b0GPE#DIV/0!#DIV/0!

 

50TOTAL O&MSum of Lines 37, 40 and 46 through 49NA#DIV/0!

 

DEPRECIATION AND AMORTIZATION EXPENSE

 

 

51Transmission336.7.f, fn0DA0

52Electric General336.10 f0S19 W/S#DIV/0!#DIV/0!

53Electric Intangible0S19 W/S#DIV/0!#DIV/0!

54Common Electric336.11.f0S19 W/S#DIV/0!#DIV/0!

Amortization of Cost of Removal Regulatory

55Asset232NA0

56Amortization of Abandoned Plant230a fnNADA0

57TOTAL DEPRECIATIONSum of Lines 51 through 560#DIV/0!

 

TAXES OTHER THAN INCOME TAXES

LABOR RELATED

58Payroll (Note D)262-263.9.l+262-263.18.l0CP*S19 W/S#DIV/0!#DIV/0!

59PLANT RELATED

60Real Estate262-263.6.l0CP*GPE#DIV/0!#DIV/0!

61Franchise Tax262-2630CP*GPE#DIV/0!#DIV/0!

62Gross Receipts TaxNote MNANote M0

63Other (Note E)262-26300

64TOTAL OTHER TAXESSum of Lines 58 and 60 through 630#DIV/0!

 

INCOME TAXES (Note F)

T=1 - {[(1 - SIT) * (1 - FIT)] / (1 - SIT

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

66Gross-up Factor1 / (1 - T)0.0000

67Income Tax FactorT/(1-T)0.0000

Amortization of Investment Tax Credit (enter

68negative)266-267.11. f, fnNADA0

Amortization of Excess Deferred Income

69Taxes (enter negative)Worksheet 3NADA0

70Tax Effect of Permanent DifferencesWorksheet 4, Line 2, Col. (e)NADA-

71Income Tax Calculation(Line 77 * Line 67)NACalc#DIV/0!

72ITC adjustment(Line 68 * Line 66)NACalc0

Amortization of Excess Deferred Income Tax

73Adjustment(Line 69 * Line 66)NACalc0

74Permanent Differences Tax Adjustment(Line 70 * Line 66)NACalc0

75TOTAL INCOME TAXESSum of Lines 71 through 74NA#DIV/0!

 

RETURN (Note H)

76DebtWorksheet 5, Line 12, Col. (i)NACalc#DIV/0!

77Common Equity and Preferred StockWorksheet 5, Line 12, Col. (f)NACalc#DIV/0!

78TOTAL RETURNSum of Lines 76 through 77NA#DIV/0!

 

 

ANNUAL TRANSMISSION REVENUE

REQUIREMENT BEFORE REVENUE(Line 50 + Line 57 + Line 64 + Line 75

79CREDITS+ Line 78)NA#DIV/0!

 

80REVENUE CREDITS(Line 104)NA-

 

ANNUAL TRANSMISSION REVENUE

81REQUIREMENT (ATRR)(Line 79 + Line 80)NA#DIV/0!

 

82CORRECTIONSWorksheet 9, Line 11, Col. (b)NA0

 

ANNUAL TRUE-UP ADJUSTMENT (ATU)

83(Note G)Worksheet 7, Line 7NA0

 

84ATRR PLUS ATU AND CORRECTIONSSum of Lines 81 through 83NA#DIV/0!

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

 

 

 

 

Section 6.19.7.2.2
Appendix A

Page 4 of 16

 

 

 

 

 

 

 

 

 

Formula Rate - Non-LevelizedRate Formula TemplateActual 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

85Electric Plant(Line 99)0

86Total Transmission Plant(Line 2)0

87Schedule 19 Projects(Line 2)0

88Schedule 19 Projects Plant Allocator(Line 87 / Line86)#DIV/0! S19P

89Transmission Plant Allocator(Line 86 / Line 85)#DIV/0! TP

 

ELECTRIC WAGE AND SALARY

ALLOCATOR

90Production354-355.20.b0

91Transmission354-355.21.b0

92Distribution354-355.23.b0

93Other354-355.24,25,26.b0

94TotalSum of Lines 90 through 930

95Transmission Wage and Salary Allocator(Line 91 / Line 94)#DIV/0!T W/S

 

Schedule 19 Projects Wages and Salaries

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

Schedule 19 Projects Wage and Salary

97Allocator(Line 96 / Line 94)#DIV/0!S19 W/S

Schedule 19 Projects Transmission Wage and

98Salary Allocator(Line 96 / Line 91)#DIV/0!S19 W/S T

 

ELECTRIC COMMON PLANT ALLOCATOR

(CE)% Electric

99Electric200-201.3.c+6.c0

100Gas200-201.3.d+6.d0CP=0.000%

101Total (excludes common)(Line 99 + Line 100)0

 

REVENUE CREDITS

Account 454, Rent from Electric Property

102(Note I)300-301, fn-

 

Account 456, Other Electric Revenue (Note J)

103300-301, fn-

 

104Total Revenue Credits-

 

 

 

 

Formula Rate - Non-LevelizedRate Formula TemplateActual 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).

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

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

 

DIncludes only FICA and unemployment taxes.

EIncludes removal costs related to assets removed to make room for Schedule 19 Projects which are amortized over 10 years to FERC Account 407.3, subject to FERC approval under a future, limited

Section 205 filing.

F Below are the currently effective income tax rate, where FIT is the Federal income tax rate; SIT is the State income tax rate, and p = "the percentage of federal income tax deductible for state income taxes".

If the utility is taxed in more than one state it must attach a work paper showing the name of each state and how the blended or composite SIT was developed.  Furthermore, a utility that elected to utilize

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

 

Inputs Required:FIT =0.00%

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

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

GInclude ATU for Year N with Projected ATRR for Year N+2

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

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

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

JIncludes revenue related to Schedule 19 Projects only.

KThe following acronyms are used for allocators:

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

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

GP= gross plant allocator (allocated 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

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

MIn 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 rate0.00000%

Revenue requirement-

Gross Receipts Tax-

OMay include CWIP in rate base as authorized by FERC.

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

 

 

Section 6.19.7.2.2
RB Items

Page 5 of 16

 

 

 

 

Rochester Gas and Electric Corporation

Workpaper 1: Average Balances for Most Rate Base Items
Actual for the 12 Months Ended 12/31/2021

 

Gross Operating Property

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

(a)

 

MonthYear
FF1 Reference

Appendix A Line #

1December2020

2March2021

3June2021

4September2021

5December2021

6Average

 

 

 

 

 

 

 

MonthYear

 

 

FF1 Reference

 

Appendix A Line #

7December2020

8March2021

9June2021

10September2021

11December2021

12Average

 

 

 

 

 

 

 

MonthYear

 

 

 

FF1 Reference
Appendix A Line #

13December2020

14March2021

15June2021

16September2021

17December2021

18Average

 

 

 

 

 

Month

FF1 Reference
Appendix A Line #

19December2020

20March2021

21June2021

22September2021

23 December2021
24 Average


(b)(c)(d)(e)

 

 

 

Electric IntangibleProductionTransmissionDistribution

204-207, line 5 fn204-207, line 46 fn204-207, line 58 fn204-207, Line 75 fn

5123

---

---

---

---

---

---

 

 

 

 

 

 

 

Electric IntangibleProductionTransmissionDistribution

 

 

200-201.21c219, lines 20-24 fn219, line 25 fn219, line 26 fn

 

1391011

----

----

----

----

----

0000

 

 

 

Schedule 19 Projects - CWIP

 

Project 1Project 2Project 3Project 4

 

 

 

 

216 fn216 fn216 fn216 fn

23232323

----

----

----

----

----

0000

 

 

 

 

Unfunded Liabilities - Account 242

Accrued VacationOtherTotal

NANA

NANA

---

---

---

---

---
0 0 0


(f)(g)(h)(i)

 

 

 

Electric GeneralCommonProject 1Project 2

204-207, l. 99 fn355 fn204-207, line 58 fn204-207, line 58 fn

4622

----

----

----

----

----

---

Note:  Exclude Asset Retirement Obligations

 

 

Accumulated Depreciation

 

 

 

Electric GeneralCommonProject 1Project 2

 

 

219, line 28 fn355 fn219, line 25 fn219, line 25 fn

 

12141010

----

----

----

----

----

0000

 

 

 

 

 

 

Transmission Land HeldSchedule 19 Projects -
Total

for Future UseLand Held for Future Use

 

 

214, line 17 fn214, line TBD

216 fn

23232828

0--

0--

0--

0--

0--
0 0 0 0


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

 

Schedule 19 Projects

 

Project 3Project 4Total

Sum of Columns (h)

204-207, line 58 fn204-207, line 58 fn204-207, line 58 fnthrough (l)

2222

---

---

---

---

---

----

 

 

 

 

 

Schedule 19 Projects

 

Project 3Project 4Total

 

 

219, line 25 fn219, line 25 fn219, line 25 fnSum of Columns (h)through (l)

 

10101010

----

----

----

----

----

000-

 

 

Miscellaneous Rate Base Items

 

 

Schedule 19 Projects -Materials & Supplies -Materials and Supplies -Regulatory

Assigned to ConstructionPrepayments

Abandoned PlantTransmission(Electric and Gas)Asset - Removal

Costs

 

230b, line TBD227, Line 8 fn227, line 5 fn110-111, line 57 fn232 fn

 

2430313233

-----

-----

-----

-----

-----
0 0 0 0 -

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

 

 

 

 

Section 6.19.7.2.2

ADIT Current YearPage 6 of 16

 

 

 

Rochester Gas and Electric Corporation

Workpaper 2a: Accumulated Deferred Income Taxes (ADIT) Worksheet - Current Year
Actual for the 12 Months Ended 12/31/2021

 

 

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

Schedule 19

ProjectsPlantLaborTotal

Nonprorated ItemsdRelatedRelatedADIT

Current Year

1ADIT-190000(Line 24)

2ADIT-282000(Line 30)

3ADIT-283000(Line 38)

4Subtotal000(Line 1 + Line 2 + Line 3)

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

6GP Allocator#DIV/0!Appendix A

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

8End of  Previous Year ADIT0#DIV/0!#DIV/0!#DIV/0!Worksheet 2b, Line 7

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

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

11Total ADIT#DIV/0!

 

 

 

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

Schedule 19 ProjectsProjectsPlantLabor

TotalExcludedRelatedRelatedRelatedJustification

1200000

1300000

1400000

1500000

1600000

1700000

1800000

1900000

2000000

2100000

2200000

2300000

24Total00000

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) Worksheet - Current Year

 

 

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

ADIT- 282 - Includes Only Items Applicable toSchedule 19

Schedule 19 ProjectsTotalProjectsPlantLabor

ExcludedRelatedRelatedRelatedJustification

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

260

270

280

2900000

30Total#DIV/0!0#DIV/0!00

Instructions for Account 282:

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

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

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

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

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

 

 

Rochester Gas and Electric Corporation

Workpaper 2a: Accumulated Deferred Income Taxes (ADIT) Worksheet - Current Year

 

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

ADIT-283 - Includes Only Items Applicable toSchedule 19

Schedule 19 ProjectsTotalProjectsPlantLabor

ExcludedRelatedJustification

31Cost of Removal0000

3200

330

340

350

360

370

38Total00000

 

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

 

 

 

 

 

Section 6.19.7.2.2ADIT Prior Year

Page 7 of 16

 

 

 

 

Rochester Gas and Electric Corporation

Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Worksheet - Prior Year
Actual for the 12 Months Ended 12/31/2021

 

 

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

Schedule 19

ProjectsPlantLaborTotal

Nonprorated ItemsRelatedRelatedADIT

Prior Year

1ADIT-190000(Line 20)

2ADIT-282000(Line 26)

3ADIT-283000(Line 34)

4Subtotal000(Line 1 + Line 2 + Line 3)

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

6GP Allocator#DIV/0!Appendix A

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

 

 

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

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

 

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

ADIT-190 - Includes Only Items Applicable toSchedule 19

Schedule 19 ProjectsProjectsPlantLabor

TotalExcludedRelatedRelatedRelatedJustification

800000

900000

1000000

1100000

1200000

1300000

1400000

1500000

1600000

1700000

1800000

1900000

20Total00000

Instructions for Account 190:

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

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

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

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

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

Rochester Gas and Electric Corporation

Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Worksheet - Prior Year

 

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

 

ADIT- 282 - Includes Only Items Applicable toSchedule 19

Schedule 19 ProjectsProjectsPlantLaborG

ExcludedRelatedRelatedRelatedJustification

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

2200

230

240

2500000

26Total#DIV/0!0#DIV/0!00

Instructions for Account 282:

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

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

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

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

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

 

 

Rochester Gas and Electric Corporation

Workpaper 2b: Accumulated Deferred Income Taxes (ADIT) Worksheet - Prior Year

 

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

ADIT-283 - Includes Only Items Applicable toSchedule 19

Scheduel 19 ProjectsTotalProjectsPlantLabor

ExcludedRelatedJustification

27Cost of Removal0000

2800

290

300

310

320

330

34Total00000

 

Instructions for Account 283:

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

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

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

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

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

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

 

 

 

Section 6.19.7.2.2

ADIT Proration ProjectedPage 8 of 16

 

 

 

 

 

 

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 & MonthlyYearDays in theNumber of DaysTotal DaysWeightingBeginningSchedule 19TransmissionPlant Related   Gross PlantPlantPlant ProrationLaborW/SLaborLaborTotal Transmission

ChangesMonthRemaining inin theforBalance/ProjectsProrationAllocatorAllocation(j)(f) x (l)RelatedAllocatorAllocationProrationProrated Amount(i)

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

Line #Current MonthRate Year(d)/(e)Ending BalanceCommon)A)

 

December 31st balance of Prorated

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

2January20213133536591.78%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

3February20212830736584.11%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

4March20213127636575.62%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

5April20213024636567.40%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

6May20213121536558.90%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

7June20213018536550.68%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

8July20213115436542.19%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

9August20213112336533.70%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

10September2021309336525.48%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

11October2021316236516.99%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

12November202130323658.77%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

13December20213113650.27%0000#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!

14Prorated Balance365#DIV/0!#DIV/0!#DIV/0!0#DIV/0!0#DIV/0!#DIV/0!

 

 

Note A:  The calculations of ADIT amounts resulting from liberalized depreciations are performed in accordance with the proration requirements of Treasury Regulation Section 1.167(l)-1(h)(6). Note B:  From Worksheet 2d-Prior Year ADIT Proration Actual

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

 

 

 

Section 6.19.7.2.2

ADIT Proration ActualPage 9 of 16

 

 

 

 

 

 

 

 

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 PeriodProjection - Proration of Projected Deferred TaxActual 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)(m)(n)

PreserveDifference betweenActual activity (Col I)

Number ofDaysDifferenceproration whenprojected andwhen projected activity

Remaining in

Total Days inbetweenactual monthlyactual activity whenis an increase while

ProrationProjectedProratedProrated ProjectedActual Monthlyprojectedand projectedactual andactual activity is aBalance reflecting

MonthDays in theYear AfterProjected RatePercentageMonthlyAmount(e)BalanceSumActivity(tablemonthly andmonthly activityprojected activitydecrease OR projectedproration or averaging  (n)

MonthMonth'sYear (Line 14,(c)/(d)Activity* (f)of (g)below, grand total)actual monthlyare either bothare either bothactivity is a decrease+ (k) +((l) + (m))/2

Accrual ofCol b)activity(i) -increases orincreases orwhile actual activity is

DeferredTaxes(f)decreases.decreases.an increase.

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

 

1 December 31st balance00

2 January3133536591.78%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

3 February2830736584.11%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

4 March3127636575.62%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

5 April3024636567.40%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

6 May3121536558.90%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

7 June3018536550.68%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

8 July3115436542.19%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

9 August3112336533.70%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

10 September309336525.48%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

11 October316236516.99%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

12 November30323658.77%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

13 December3113650.27%000#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

14 Total36500#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

 

 

Gross PlantLabor Related

Schedule 19Allocator(General andW /S Allocator (AppendixGrand Total (b) +

ProjectsPlant RelatedAppendix A)  Total (d) * (e)Common)A)Total (g) * (h)(f) + (i)

Actual Monthly Activity

15 January00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

16 February00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

17 March00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

18 April00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

19 May00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

20 June00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

21 July00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

22 August00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

23 September00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

24 October00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

25 November00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

26 December00#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!

 

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

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

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

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

 

 

 

 

Section 6.19.7.2.2EADIT

Page 10 of 16

 

 

 

 

 

 

 

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)

Deficient orAdjustedUnprotected

ExcessDeficient orSchedule 19Property

ADIT BalancesAccumulatedExcessProjects(UP)

ADIT BalancesAfterDeferred TaxesAccumulatedAllocationAllocated toUnprotected

Prior toRemeasurementat DecemberAdjustments AfterDeferredFactors (NoteSchedule 19Other (UO)AmortizationBalance atAmortizationBalance at

Line DescriptionRemeasurement(Note C)31,RemeasurementTaxesB)Projects(Note B)YearDecember 31YearDecember 31

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

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

Deficient Deferred Income Taxes -

amortized to 410.1

FERC Account 190

1000000.000%00000

2000000.000%00000

3000000.000%00000

4000000.000%00000

5000000.000%00000

6 Total FERC Account 1900000000000

 

FERC Account 282

7000000.000%00000

8000000.000%00000

9000000.000%00000

10000000.000%00000

11 Total Account 2820000000000

 

FERC Account 283

12000000.000%00000

13000000.000%00000

14000000.000%00000

15000000.000%00000

16000000.000%00000

17 Total FERC Account 2830000000000

 

Subtotal Before Being Grossed up for

18Income Taxes0000000

19 Gross Up00000

Total Deficient Accumulated Deferred

20Income Taxes - Account 182.300000

 

 

Excess Accumulated Deferred Income

Taxes - amortized to 411.1

FERC Account 190

21000000.000%00000

22000000.000%00000

23 Total Account 1900000000000

 

FERC Account 282

24 Accelerated Depreciation000000.000%0P0000

25000000.000%00000

26000000.000%00000

27000000.000%00000

28000000.000%00000

29 Total Account 2820000000000

 

FERC Account 283

30000000.000%00000

31000000.000%00000

32000000.000%00000

33000000.000%00000

34000000.000%00000

35 Total Account 2830000000000

 

Subtotal Before Being Grossed up for

36Income Taxes0000000

37 Gross Up00000

Total Excess Accumulated Deferred Income

38Taxes - Account 25400000

 

39 Grand Total00000

 

40 Total Amortization0

 

Note A:  Includes Excess Deferred Income Tax Regulatory Assets or Liabilities and the associated amortization arising from income tax rate changes.  This sheet will be populated and replicated for changes in federal, state or local income tax rates impacting Schedule 19 Project ADITs.

Note B:  The allocation factors used to allocate total excess accumulated deferred income taxes to local transmission projections are (to be completed when used) Note C:  Remeasurement Factor equals the ratio of the current nominal tax rate to the prior nominal tax rate

41New nominal rate1.0%

42Prior nominal rate1.0%

43Note D:Remeasurement Factor100.0%

 

Note E:Note F:

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

 

Section 6.19.7.2.2

Permanent Book/Tax Differences

Effective Date: 7/3/2023 - Docket #: ER23-1817-000 - 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 ofAFUDC EquityOther 2Other 3Total

PermanentLocal

Book/TaxTransmission

Line #DifferencesProjects

FF1 Reference

1Amount-00-

 

2Income Tax Effect-00-

Line 1 *Line 1 *Sum of

Line 1 * IncomeIncome TaxIncome TaxColumns (b), (c)
Ref Tax Factor Factor Factor and (d)


Page 11 of 16

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

 

 

Section 6.19.7.2.2

Project ReturnPage 12 of 16

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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)(n)(o)

Five Quarter AveragesAllocate Other Rate Base Items to Schedule 19 Projects

NetIntangibleAccumulated

Plant -  -Net CommonDeferredLand Held for

Net GeneralUsingPlant -  -Abandonedncome Taxes -(Excess)/DeficientFuture Use -Other Rate Base

Gross Plant inAccumulatedNet OperatingPlant - UsingUsingPlant - UsingUsingADIT - UsingUsingItems - Using

Line #ServiceAllocatorDepreciationPropertyAllocatorAllocatorAllocatorCWIPAllocatorAllocatorAllocatorAllocatorAllocatorTotal Rate Base

 

Workpaper 1,Workpaper 1,Line 6 * Col.Line 6 * Col.Workpaper 1,Workpaper 1,Line 6 * Col.Line 6 * Col.Sum of Col. (e)

ReferenceProjectLine 6CalculatedLine 12Col. (b) - Col. (d)Line 6 * Col. (c)(c)(c)Line 18Line 18(c)Line 6 * Col. (c)(c)Line 6 * Col. (c)through Col. (n)

 

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

 

Project

2Grouping 2-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

Project

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

 

Project

4Grouping 4-#DIV/0!--#DIV/0!#DIV/0!#DIV/0!0#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!

 

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

 

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

Appendix A,Appendix A,Appendix A,Workpaper 1,Workpaper 1,Appendix A,Appendix A, LineAppendix A,Appendix A, Line

RefLine 19Line 20Line 21Line 18Line 18Line 2526Line 2835

 

Weighted

Preferred andPreferred and

Common EquityCommonWeighted

Rate BaseWACCReturnRateEquity ReturnDebt RateDebt Return

 

Workpaper 6,

Workpaper 6,Lines 2 + 3,Workpaper,

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

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

ReferenceProjectCol. (o)Line 16(c)Lines 14 + 15(e)Line 13(h)

 

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

 

Project

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

 

Project

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

 

 

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

 

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

 

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

 

 

 

Schedule 19 Projects Included in Each Project Group

ProjectProjectGross

ProjectNameDescriptionInvestment

Grouping 1

 

 

 

 

 

 

 

 

 

 

 

ProjectGrouping 2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ProjectGrouping 3

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ProjectGrouping 4

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

 

 

Section 6.19.7.2.2
Project Cost of Capital
Page 13 of 16

 

 

 

 

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)

Line #Project Grouping 1(Note A)

Capitalization%sCost RatesWACC

1Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

2Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

3Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 1 and 2,

4Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Project Grouping 2

Capitalization%sCost RatesWACC

5Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

6Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

7Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 5 and 6,

8Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Project Grouping 3

Capitalization%sCost RatesWACC

9Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

10Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

11Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 9 and 10,

12Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Project Grouping 4

Capitalization%sCost RatesWACC

13Long Term DebtLine 22, Col. (i)00.0%#DIV/0!#DIV/0!ROE per New York State Public Service Commission, Case No.0.00%

14Preferred StockLine 22 Col. (b)-0.0%0.000%0.00%ROE Cap10.87%

15Common StockLine 22 Col. (d)00.0%0.000%0.00%

(Lines 13 and 14,

16Total Capitalization00.0%Col. (j))#DIV/0!

 

 

 

Common EquityLong-term Debt

Less:

Accumulated

OtherCommonUnamortizedUnamortized LossLong-term Debt

Less: PreferredComprehensiveEquity forGains onUnamortized Debton Reacquiredfor

TotalStockIncomeCapitalizationTotalReacquired DebtExpenseDebtCapitalization

 

Col. (a) - Col.Col. (e) + Col.

MonthYear112-113, l.16, fn112-113, l.3, fn112-113, l.15, fn(b) - Col. (c)112-113, l.24, fn112-113, l.61, fn110-111, l.69, fn110-111, l.81, fn(f) - Col. (g) - (h)

17December2020-----

18March2021-----

19June2021-----

20September2021-----

21December2021-----

22Average-

 

 

 

(114-117c, sum

of lines 62, 63,

23Long Term Interest64, 65, 66)0

 

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

 

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

 

26Preferred Dividends118-119c, l.29-

 

27Preferred Stock(Line 22 Col. (b))-

 

28Preferred Stock RateLine 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-000 - 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

 

 

Section 6.19.7.2.2
True-up Adjustment
Page 14 of 16

 

 

 

 

 

 

 

 

 

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 worksheet included in the filed Formula Rate Template, the inputs to the worksheet must meet this transparency standard, and doing so will satisfy this transparency requirement for the amounts that are output from the worksheet and input to the main body of the Formula Rate.

 

 

Line

Interest

EstimatedActual InterestRate True-

Interest RateRateUp

1AATRR based on actual costs included for the previous calendar year0

2BRevenues based upon the Projected ATRR for the previous calendar year and excluding any true-up adjustment0

3CDifference  (A-B)00

4DFuture Value Factor (1+i)^241.00001.00000

5ETrue-up Adjustment(C*D)00

6FInterest Rate True-up from Prior Periods0

7GATU Adjustment with Interest Rate True-up From Prior Periods0

 

Where:

i = average interest rate as calculated below

 

Interest on Amount of Refunds or SurchargesEstimatedActual

MonthlyMonthly

MonthYearInterest RateInterest Rate

8JulyYear 10.0000%0.0000%

9AugustYear 10.0000%0.0000%

10SeptemberYear 10.0000%0.0000%

11OctoberYear 10.0000%0.0000%

12NovemberYear 10.0000%0.0000%

13DecemberYear 10.0000%0.0000%

14JanuaryYear 20.0000%0.0000%

15FebruaryYear 20.0000%0.0000%

16MarchYear 20.0000%0.0000%

17AprilYear 20.0000%0.0000%

18MayYear 20.0000%0.0000%

19JuneYear 20.0000%0.0000%

20JulyYear 20.0000%0.0000%

21AugustYear 20.0000%0.0000%

22SeptemberYear 20.0000%0.0000%

23OctoberYear 20.0000%0.0000%

24NovemberYear 20.0000%0.0000%

25DecemberYear 20.0000%0.0000%

26JanuaryYear 30.0000%0.0000%

27FebruaryYear 30.0000%0.0000%

28MarchYear 30.0000%0.0000%

29AprilYear 30.0000%0.0000%

30MayYear 30.0000%0.0000%

31JuneYear 30.0000%0.0000%

 

32Average0.00000%0.00000%

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

 

Section 6.19.7.2.2
Depreciation Rates
Page 15 of 16

 

 

 

 

 

 

Rochester Gas and Electric Corporation

Workpaper 8:  Electric and Common Depreciation and Amortization Rates
Actual for the 12 Months Ended 12/31/2021

 

 

 

 

FERC AccountDescriptionRate (Note 1)

 

Transmission

350Land Rights1.33%

352Structures and Improvements1.69%

353Station Equipment1.92%

354Towers and Fixtures2.00%

355Poles and Fixtures2.17%

356Overhead Conductors & Devices1.92%

357Underground Conduit1.57%

358Underground Conductors & Devices1.79%

359Roads and TrailsNA

 

Electric General and Intangible

302Franchises and ConsentsNA

303Intangible Plant14.29%

390Structures and Improvements2.18%

391Office Furniture and Equipment3.57%

391.2Computer Equipment14.29%

391.3Office Equipment2.77%

394Tools, Shop and Garage Equipment3.43%

395Laboratory Equipment0.96%

397Communication Equipment3.63%

397.1Communication Equipment - Overhead2.86%

398Miscellaneous Equipment6.67%

 

Common

302Franchises and ConsentsNA

303Intangible Plant13.09%

390Structures and Improvements2.98%

391Office Furniture and Equipment3.42%

391.2Computer Equipment13.09%

391.3Office Equipment1.09%

392.09Mini Passenger Vans10.00%

392.13Passenger Cars11.25%

392.32Full Size Pickups8.18%

392.33Light Duty Gas Powered Utility Trucks9.00%

392.34Heavy Duty Gas Powered Utility Trucks6.92%

392.36Mini Cargo Vans11.25%

392.37Full Size Cargo Vans10.00%

392.38Mini Pickups9.00%

Heavy Duty Diesel Powered Utility Trucks

392.39and Equipment6.92%

Medium Duty Diesel Powered Utility

392.42Trucks7.50%

392.43Medium Duty Gas Power Utility Trucks8.18%

393Stores Equipment2.87%

394Tools, Shop and Garage Equipment2.91%

395Laboratory Equipment2.83%

396Power Operated Equipment7.69%

397Communication Equipment5.38%

398Miscellaneous Equipment6.25%

 

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

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

 

Section 6.19.7.2.2
Corrections

Page 16 of 16

 

 

 

 

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

LineImpact ofRevenue

No.  DescriptionSourceCorrectionRequirement

 

1Filing Name and Date

2Original Revenue Requirement0

 

3Description of Correction 10

4Description of Correction 20

 

 

5Total Corrections(Line 3 + Line 4)0

 

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

 

7Total Corrections(Line 5)0

 

8Average Monthly FERC Refund RateNote A0.00%

9Number of Months of InterestNote B0

10(Line 7 * Line 8 *

Interest on CorrectionLine 9)0

 

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

 

 

Notes:

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

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

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

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

 

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