NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.8.2.2 OATT Rate Schedule 19 Att 3 - Formula Rate Templa

Section 6.19.8.2.2 Formula Rate Template

Consolidated Edison Company of New York, Inc.

Transmission Formula Rate

Schedule 19 and Schedule 10 Projects

Actual or Projected for the 12 Months Ended December ….

Index

Workpaper Tab

Description

Annual Transmission Revenue Requirement for Schedule 19 and Schedule 10

A

Appendix A

Projects

Average Balances for Most Rate Base Items and Transmission Depreciation

and Amortization Expenses

1

RB Items

2a19

2a10

2b19

2b10

ADIT-Current Year (Schedule 19 Projects)

ADIT-Current Year (Schedule 10 Projects)

ADIT-Prior Year (Schedule 19 Projects)

ADIT-Prior Year (Schedule 10 Projects)

Current Year Average Accumulated Deferred Income Taxes

Current Year Average Accumulated Deferred Income Taxes

Prior Year Accumulated Deferred Income Taxes

Prior Year Accumulated Deferred Income Taxes

2c19

2c10

2d19

ADIT Proration Projected (Schedule 19 Projects) Proration of Projected Accumulated Deferred Income Taxes

ADIT Proration Projected (Schedule 10 Projects) Proration of Projected Accumulated Deferred Income Taxes

ADIT Proration Actual (Schedule 19 Projects)

Proration of Actual Accumulated Deferred Income Taxes

2d10

3a19

3b10

4

ADIT Proration Actual (Schedule 10 Projects)

EADIT (Schedule 19 Projects)

Proration of Actual Accumulated Deferred Income Taxes

Excess Accumulated Deferred Income Tax Rate Base and Amortization

Excess Accumulated Deferred Income Tax Rate Base and Amortization

Permanent Book/Tax Differences

EADIT (Schedule 10 Projects)

IT Permanent Differences

5

Project Return (Schedule 19 Projects)

Return on Schedule 19 Projects

6a19

6b10

Project Cost Of Capital (Schedule 19 Projects)

Cost Of Capital (Schedule 10 Projects)

Schedule 19 Projects Cost of Capital

Schedule 10 Projects Cost of Capital

Annual True-up Adjustment (Schedule 19

Projects)

7a19

7b10

Schedule 19 Projects Annual True-up Adjustment

Schedule 10 Projects Annual True-up Adjustment

Annual True-up Adjustment (Schedule 10

Projects)

Depreciation Rates Approved by the Commission and Used to Determine

Schedule 19 Projects and Schedule 10 Projects Depreciation and Amortization

Expense

8

9

Depreciation Rates

Corrections

Prior Period Corrections

10a19

10b10

11

Schedule 19 Project ATRRs

Schedule 10 Project ATRRs

ROE Adder (Schedule 10 Projects)

ATRRs for Schedule 19 Projects

ATRRs for Schedule 10 Projects

ROE Adder for Schedule 10 Projects


Formula Rate - Non-Levelized

Transmission Formula Rate Template

Utilizing FERC Form 1 Data

Actual or Projected for the 12 Months Ended December ….

Consolidated Edison Company of New York, Inc.

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 and Schedule 10 Projects

Thirteen Monthly Balances

Composite Depreciation Rates

(1)

(2)

(3)

(4)

(5)

(6)

(7)

Line

Schedule 19 Projects

Schedule 10 Projects

Company Total

(where

applicable)

Form No. 1 or Transmission Formula

Rate Reference

Schedule 19

Projects

Schedule 10

Projects

No. RATE BASE (Note A):

Allocator (Note K)

Allocator (Note K)

GROSS PLANT IN SERVICE

1

Production

Workpaper 1, Line 14, Col. (c)

0

NA

0

NA

0

Workpaper 1, Line 14, Col. (d), Col. (m) or Col.

(s)

2

3

4

5

6

7

8

Transmission

Distribution

Electric General

Electric Intangible

Common

0

0

0

0

0

0

0

DA

NA

0

0

DA

NA

-

-

Workpaper 1, Line 14, Col. (e)

Workpaper 1, Line 14, Col. (f)

Workpaper 1, Line 14, Col. (b)

Workpaper 1, Line 14, Col. (g)

S19 W/S

S19 W/S

CP*S19 W/S

GP19=

GPE19=

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

S10 W/S

S10 W/S

CP*S10 W/S

GP10=

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

TOTAL GROSS PLANT

(Sum of Lines 1 through 6)

Without Common - For Gross Plant Allocator Calculation Only

GPE10=

ACCUMULATED DEPRECIATION

9

Production

Transmission

Distribution

Electric General

Electric Intangible

Common

Workpaper 1, Line 28, Col. (c)

-

-

-

-

-

-

-

NA

DA

NA

0

0

NA

DA

NA

0

0

10

11

12

13

14

Workpaper 1, Line 28, Col. (d) or Col. (m)

Workpaper 1, Line 28, Col. (e)

Workpaper 1, Line 28, Col. (f)

Workpaper 1, Line 28, Col. (b)

Workpaper 1, Line 28, Col. (g)

(Sum of Lines 9 through 14)

-

-

S19 W/S

S19 W/S

CP*S19 W/S

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

S10 W/S

S10 W/S

CP*S10 W/S

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

15 TOTAL ACCUM. DEPRECIATION

NET PLANT IN SERVICE

16

17

18

19

20

21

Production

Transmission

Distribution

General

Intangible

Common

(Line 1 + Line 9)

(Line 2 + Line 10)

(Line 3 + Line 11)

(Line 4 + Line 12)

(Line 5 + Line 13)

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

(Line 6 + Line 14)

22 TOTAL NET PLANT

(Sum of Lines 16 through 21)

ACCUMULATED DEFERRED INCOME TAXES

(Note B)

23

24

Accumulated Deferred Income Taxes

Workpaper 2a19 or 2a10, Line 11, Col. (g)

3a19 or 3b10-EDIT

NA

NA

DA

DA

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Excess Accumulated Deferred Income Taxes

TOTAL ACCUMULATED DEFERRED INCOME

0

0

0

0

25 TAXES

(Line 23 - Line 24)

26 LAND HELD FOR FUTURE USE

OTHER RATE BASE ITEMS

Workpaper 1, Line 42, Col. (h) or (i)

NA

DA

27

28

Cash Working Capital

Materials & Supplies - Transmission

Materials and Supplies - Assigned to

(Line 47 times 45/360)

Workpaper 1, Line 42, Col. (d)

NA

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

S19P

#DIV/0!

S10P

#DIV/0!

29 Construction

Workpaper 1, Line 42, Col. (e)

Workpaper 1, Line 42, Col. (f)

Workpaper 1, Line 42, Col. (i)

(Sum of Lines 27 through 31)

0

0

GP19

GP19

CP*S19 W/S

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

GP10

GP10

CP*S10 W/S

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

30

31

Prepayments

Unfunded Liabilities

-

32 TOTAL OTHER RATE BASE ITEMS

NA

NA

33 RATE BASE

(Line 22 + Line 25 + Line 26 + Line 32)

#DIV/0!

#DIV/0!


Formula Rate - Non-Levelized

Rate Formula Template

Actual or Projected for the 12 Months Ended December ….

Utilizing FERC Form 1 Data

Consolidated Edison Company of New York, Inc.

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 and Schedule 10 Projects

(1)

(2)

(3)

(4)

(5)

(6)

(7)

Line

Schedule 10 Projects

Company Total

(where

applicable)

ANNUAL TRANSMISSION REVENUE

No. REQUIREMENT

Form No. 1 or Transmission Formula

Rate Reference

Schedule 19

Projects

Schedule 10

Projects

Allocator (Note K)

Allocator (Note K)

OPERATIONS AND MAINTENANCE

EXPENSES (Note M)

34

35

36

37

Transmission - Direct Assign

Transmission - Allocate

Less: EPRI Dues in Account 566

Subtotal - Transmission to Allocate

320-323.112.b fn

320-323.112.b fn

352-353.17.f

Line 35 - Line 36

320-323.197.b

352-353

NA

DA

0

DA

0

0

0

0

0

0

S19P

#DIV/0!

#DIV/0!

S10P

#DIV/0!

#DIV/0!

38 Electric A&G

39

Less: EPRI Dues in A&G

40

41

42

Less: Regulatory Commission Expenses

Less: Property Insurance

Less: Account 930.2 Items

320-323.189.b

320-323.185.b

Note L

0

0

0

43

Adjusted Electric A&G

Plus: Transmission Related Regulatory

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

350-351 fn

0

0

S19 W/S

S19P

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

S10 W/S

S10P

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

44 Expenses (Note E)

Plus: Direct Assigned Regulatory

45 Commission Expenses

46 Plus: Property Insurance

47 TOTAL O&M

350-351 fn

320-323.185.b

Sum of Lines 34 through 46

NA

NA

DA

GPE19

0

0

DA

GPE10

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

DEPRECIATION AND AMORTIZATION EXPENSE

Transmission

Electric General

48

49

50

336.7f or Workpaper 1, Line 58 or Line 57

336.10 f

0

0

0

0

DA

S19 W/S

S19 W/S

DA

S10 W/S

S10 W/S

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Common Electric (includes Intangible)

336.11.f

Sum of Lines 48 through 50

51 TOTAL DEPRECIATION

TAXES OTHER THAN INCOME TAXES

(TOTAL COMPANY)

LABOR RELATED

52

53

54

55

56

57

Payroll (Note D)

PLANT RELATED

Real Estate

Franchise Tax

Gross Receipts Tax

Other (Note E)

262-263.35+262-263.36. l

0

CP*S19 W/S

#DIV/0!

#DIV/0!

#DIV/0!

CP*S10 W/S

#DIV/0!

#DIV/0!

262-263.4.l

262-263.28.l

0

0

GP19

GP19

Note N

#DIV/0!

#DIV/0!

GP10

GP10

Note N

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

0

0

262-263

Sum of Lines 52 and 54 through 57

0

0

0

58 TOTAL OTHER TAXES

#DIV/0!

#DIV/0!

INCOME TAXES (Note F)

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

59 Composite Tax Rate = T

60 Gross-up Factor

61 Income Tax Factor

* p)}=

1 / (1 - T)

T/(1-T)

0.0000%

0.0000

0.0000

Amortization of Investment Tax Credit (enter

62 negative)

Amortization of Excess Deferred Income Taxes

63 (enter negative)

64 Tax Effect of Permanent Differences

65 Income Tax Calculation

66 ITC adjustment

266-267.11. f, fn

NA

DA

0

0

DA

0

0

Workpaper 3

Workpaper 4, Line 2 Col. (e)

(Line 71 * Line 61)

NA

NA

NA

NA

DA

DA

Calc

Calc

DA

DA

Calc

Calc

-

-

#DIV/0!

#DIV/0!

(Line 62 * Line 60)

0

0

Amortization of Excess Deferred Income Tax

67 Adjustment

68 Permanent Differences Tax Adjustment

69 TOTAL INCOME TAXES

(Line 63 * Line 60)

(Line 64 * Line 60)

Sum of Lines 65 through 68

NA

NA

NA

Calc

Calc

0

0

Calc

Calc

0

0

#DIV/0!

#DIV/0!

RETURN (Note H)

Workpaper 5 19, Line 12, Col. (i) or Workpaper

6b 10, Line 1 * Line 33

Workpaper 5 19, Line 12, Col. (f) or Workpaper

6b 10, Line 3 * Line 33

70

71

Debt

NA

Calc

Calc

#DIV/0!

#DIV/0!

Common Equity and Preferred Stock

NA

NA

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

72 TOTAL RETURN

Sum of Lines 70 through 71

ANNUAL TRANSMISSION REVENUE

REQUIREMENT BEFORE REVENUE

73 CREDITS

(Line 47 + Line 51 + Line 58 + Line 69 + Line

72)

NA

NA

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

74 REVENUE CREDITS

(Line 100)

-

-

ANNUAL TRANSMISSION REVENUE

75 REQUIREMENT (ATRR)

(Line 73 + Line 74)

NA

NA

76 CORRECTIONS

Workpaper 9, Line 11, Col. (b) and Col. (d)

0

0

0

0

ANNUAL TRUE-UP ADJUSTMENT (ATU)

77 (Note G)

Workpaper 7a, Line 5 or Workpaper 7b,

Line 5

NA

NA

78 ATRR PLUS ATU AND CORRECTIONS

79 ROE Adder

Sum of Lines 75 through 77

#DIV/0!

#DIV/0!

#DIV/0!

Workpaper 10, Line 33

Sum of Lines 78 and 79

80 Total with ROE Adder

#DIV/0!

(Note P)


Formula Rate - Non-Levelized

Rate Formula Template

Actual or Projected for the 12 Months Ended December ….

Utilizing FERC Form 1 Data

Consolidated Edison Company of New York, Inc.

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 and Schedule 10 Projects

SUPPORTING CALCULATIONS AND NOTES

Line

Schedule 19

Projects

Schedule 10

Projects

No. TRANSMISSION PLANT ALLOCATOR

81 Total Electric Plant

82 Total Transmission Plant

(Line 94)

(Line 2)

(Line 2)

0

0

0

0

0

83 Schedule Specific Projects

-

84 Schedule Specific Projects Plant Allocator

(Line 83 / Line 82)

#DIV/0! S19P

#DIV/0! S10P

ELECTRIC WAGE AND SALARY

ALLOCATOR

85

86

87

88

89

Production

Transmission

Distribution

Other

354-355.20.b

354-355.21.b

354-355.23.b

0

0

0

0

0

354-355.24,25,26.b

Sum of Lines 85 through 88

(Line 86 / Line 89)

Total

90 Transmission Wage and Salary Allocator

#DIV/0!

T W/S

91 Schedule Specific Projects Wages and Salaries

Schedule Specific Projects Wage and Salary

92 Allocator

Schedule Specific Projects Transmission Wage

93 and Salary Allocator

(Line 86 * Line 84)

(Line 91 / Line 89)

(Line 91 / Line 86)

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

S19 W/S

#DIV/0!

#DIV/0!

S10 W/S

S19 W/S T

S10 W/S T

ELECTRIC COMMON PLANT ALLOCATOR

(CE)

Electric

Gas

% Electric

#DIV/0!

94

95

200-201.3.c+6.c

200-201.3.d+6.d

0

0

CP=

96

97

Steam

Total (excludes common)

200-201.3.e+6.e

Sum of Lines 94 through 96

0

0

(Line 94 / Line 97)

Schedule 19

Projects

Schedule 10

Projects

REVENUE CREDITS

Account 454, Rent from Electric Property (Note

98 I)

300-301, fn

300-301, fn

-

-

Account 456, Other Electric Revenue (Note J)

99

-

-

-

-

100 Total Revenue Credits

Formula Rate - Non-Levelized

Transmission Formula Rate Template

Utilizing FERC Form 1 Data

Actual or Projected for the 12 Months Ended December ….

Consolidated Edison Company of New York, Inc.

Appendix A: Annual Transmission Revenue Requirement for Schedule 19 and Schedule 10 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)

Notes

A

All amounts shown are based on 13 month averages which monthly numbers are contained in footnotes to the FF1 (with the following exceptions: CWC in line 28, which is based upon one-eigth of

O&M,Accumulated Deferred Income Taxes in line 24 and Excess Accumulated Deferred Income Taxes in line 25, which are beginning/ending year averages and prorated amounts) .

B

C

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

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

D

E

Includes only FICA and unemployment taxes.

Any transmission regulatory expenses allocated to Schedule 19 or Schedule 10 Projects are determined after deducting any directly assigned transmission 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 =

SIT=

p =

0.00%

0.00% (State Income Tax Rate or Composite SIT)

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

G

H

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

Debt cost rate = long-term interest / long term debt. Preferred cost rate = preferred dividends / preferred outstanding. For Schedule 19 Projects, 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. For Schedule 10 Projects,

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

I

J

K

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

Includes revenue related to Schedule 19 Projects or Schedule 10 Projects only.

The following acronyms are used for allocators:

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

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

GP19 or GP10= gross plant allocator (allocated Schedule 19 Projects or Schedule 10 Projects gross plant as % of electric and common plant)

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

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

Schedule 19 Projects or Schedule 10 Projects wage and salary allocator (Schedule 19 Projects or Schedule 10 Projects wages and salaries as % of total electric

S19 W/S or S10 W/S= wages and salaries)

Schedule 19 Projects or Schedule 10 Projects wages and salary allocator for transmission (Schedule 19 Projects or Schedule 10 Projects wages and salaries as

S19 W/S T or S10 W/S T a % of transmission wages and salaries)

NA= not applicable (the item is not applicable to Schedule 19 Projects or Scheduel 10 Projects)

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

L

Con Edison 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 the provision of transmission services.

Con Edison either will direct assign O&M expense that have been tracked for the Schedule 19 Projects or Schedule 10 Projects or allocate transmission O&M to the Schedule 19 Projects or Schedule 10 Projects,

M

N

but not both.

In accordance with the NYISO OATT, Section 14.1.5, the gross receipts tax included in the ATRR for Schedule 19 and Schedule 10 Projects is as follows:

Schedule 19

0.00000%

Schedule 10

0.00000%

Gross receipt tax rate

Revenue requirement

Gross Receipts Tax

-

-

-

-

O

P

For future use

By project ATRRs are on Workpaper 10a for Schedule 19 Projects and Workpaper 10b for Schedule 10 Projects.


Effective Date: 8/22/2023 - Docket #: ER23-2212-002 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.8.2.2 OATT Rate Schedule 19 Att 3 - Formula Rate Templa

 

Consolidated Edison Company of New York, Inc.

Workpaper 1: Average Balances for Most Rate Base Items and Transmission Depreciation and Amortization Expenses

Actual or Projected for the 12 Months Ended December ….

Gross Operating Property

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

(m)

(n)

(o)

(p)

(q)

(r)

(s)

Total Company

Schedule 19 Projects

Schedule 10 Projects

Month

Electric Intangible

Production

204-207, line 46 fn

1

Transmission

Distribution

204-207, Line 75 fn

3

Electric General

204-207, l. 99 fn

4

Common

356 fn

6

Project 1

Project 2

Project 3

Project 4

Total

Sum of Columns (h)

through (l)

Project 1

Project 2

Project 3

Project 4

Total

Sum of Columns

(n) through (r)

FF1 Reference

204-207, line

5

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

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 204-207, line 58

Appendix A line

#

5

2

2

2

2

2

2

2

-

-

-

-

-

-

-

-

-

-

-

-

-

-

2

2

2

-

-

-

-

-

-

-

-

-

-

-

-

-

0

2

2

2

-

-

-

-

-

-

-

-

-

-

-

-

-

-

1

2

3

4

5

6

7

8

9

December '20

January '21

February

March

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

April

May

June

July

August

10 September

11 October

12 November

13 December '21

14

Average

0

0

0

0

0

0

0

0

0

0

0

0

Note: Exclude Asset Retirement Obligations

Accumulated Depreciation

Schedule 19 Projects

Schedule 10 Projects

Project 3

Month

Electric Intangible

Production

Transmission

Distribution

Electric General

Common

Project 1

Project 2

Project 3

Project 4

Total

Project 1

Project 2

Project 4

Total

200-201 l. 18d

-

FF1 Reference

Workpaper 1-RB Items

Line 45, Col. (c) - Col. (d) -

Col. (e) - Col. (f)

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)

219, line 25 fn

219, line 25 fn

219, line 25 fn

219, line 25 fn

219, line 25 fn

Sum of Columns

(n) through (r)

Appendix A line

#

13

9

10

11

12

14

10

10

10

10

10

10

10

10

10

10

10

10

15 December '20

16 January '21

17 February

18 March

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

19 April

-

-

-

-

-

-

-

-

-

-

-

-

-

20 May

-

-

-

-

-

-

-

-

-

-

-

-

-

21 June

-

-

-

-

-

-

-

-

-

-

-

-

-

22 July

-

-

-

-

-

-

-

-

-

-

-

-

-

23 August

-

-

-

-

-

-

-

-

-

-

-

-

-

24 September

25 October

26 November

27 December '21

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

28

Average

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Miscellaneous Rate Base Items

Unfunded Liabilities

Schedule 19 Projects

Land Held for Future Use Land Held for Future Use

-

Schedule 10 Projects

-

Materials

Transmission

&

Supplies

-

Materials and Supplies

-

Assigned to Construction

(Electric, Gas and Steam)

Prepayments

Accumulated Provision

for Injuries and Damages

Miscellaneous Current

and Accrued Liabilities

Month

Total

214, line TBD

214, line TBD

227, Line

8

fn

227, line

5

fn

110-111, line 57 fn

Sum of Columns (g) + (h)

FF1 Reference

112-113, line 28 fn

Line 43 to Line 56

Appendix A line

#

11

11

28

29

30

31

29  December '20

30 January '21

31 February

32 March

33 April

34 May

35 June

36 July

37 August

38 September

39 October

40 November

41 December '21

42 Average

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

0

0

0

Unfunded Liabilities - Account 242

Employee Stock Based

Other

NA

Month

Accrued Vacation

NA

Total

NA

Sum of Columns (b)

FF1 Reference

Appendix A line

43  December '20

44 January '21

45 February

46 March

47 April

48 May

49 June

50 July

51 August

52 September

53 October

54 November

55 December '21

56 Average

#

NA

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

0

0

0

0

Schedule 10 Projects - Depreciation Expense

Project 1

336 fn

NA

Project 2

336 fn

NA

Project 3

336 fn

NA

Project 4

336 fn

NA

Total

FF1 Reference

Appendix A line

#

50

57

58

2021

-

-

-

-

-

-

-

-

Schedule 19 Projects - Depreciation Expense

Project 1

336 fn

NA

Project 2

336 fn

NA

Project 3

336 fn

NA

Project 4

336 fn

NA

Total

FF1 Reference

Appendix A line

#

50

2021

-

-


Consolidated Edison Company of New York, Inc.

Workpaper 2a19: Accumulated Deferred Income Taxes (ADIT) Workpaper - Current Year (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Plant

Labor

Total

ADIT

Nonprorated Items

Related

Related

Current Year

ADIT-190

ADIT-282

ADIT-283

Subtotal

Schedule 19 Projects W/S Allocator

GP Allocator

End of Year ADIT

1

2

3

4

5

6

7

8

9

0

0

0

0

0

0

0

0

0

(Line 24)

(Line 30)

(Line 38)

(Line 1 + Line 2 + Line 3)

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

(Line 4 * Line 5 or Line 6)

Workpaper 2b, Line 7

(Average of Line 7 + Line 8)

End of Previous Year ADIT

Average Beginning and End of Year

Prorated ADIT

10

11

From Workpaper 2c, Line 14, Col. (r) or Workpaper 2d, Line 13, Col. (n)

Total ADIT

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

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

(a)

ADIT-190 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Plant

Related

Labor

Related

Total

Excluded

Justification

12 Alternative Minimum Tax

13 Net Operating Loss

14

15

16

17

18

19

20

21

22

23

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

24 Total

Instructions for Account 190:

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

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

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

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

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

Consolidated Edison Company of New York, Inc.

Workpaper 2a19: Accumulated Deferred Income Taxes (ADIT) Workpaper - Current Year (Schedule 19 Projects)

(a)

ADIT- 282 - Includes Only Items Applicable to

Schedule 19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Total

Plant

Labor

Excluded

Related

Related

Related

Justification

25 Accelerated Depreciation - Prorated

#DIV/0!

0

#DIV/0!

0

0

Workpaper 2c, Line 14, Col. (r)

26

27

28

29

0

0

0

0

0

0

0

0

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.

Consolidated Edison Company of New York, Inc.

Workpaper 2a19: Accumulated Deferred Income Taxes (ADIT) Workpaper - Current Year (Schedule 19 Projects)

(a)

ADIT-283 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Total

Plant

Labor

Excluded

Justification

31

32

33

34

35

36

37

0

0

0

0

0

0

0

0

0

0

0

0

38 Total

0

0

0

0

Instructions for Account 283:

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

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

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

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

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


Consolidated Edison Company of New York, Inc.

Workpaper 2a10: Accumulated Deferred Income Taxes (ADIT) Workpaper - Current Year (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Plant

Labor

Total

ADIT

Nonprorated Items

Related

Related

Current Year

ADIT-190

ADIT-282

ADIT-283

Subtotal

Schedule 10 Projects W/S Allocator

GP Allocator

End of Year ADIT

1

2

3

4

5

6

7

8

9

0

0

0

0

0

0

0

0

0

(Line 24)

(Line 30)

(Line 38)

(Line 1 + Line 2 + Line 3)

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

(Line 4 * Line 5 or Line 6)

Workpaper 2b, Line 7

(Average of Line 7 + Line 8)

End of Previous Year ADIT

Average Beginning and End of Year

Prorated ADIT

10

11

From Workpaper 2c, Line 14, Col. (r) or Workpaper 2d, Line 13, Col. (n)

Total ADIT

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

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

(a)

ADIT-190 - Includes Only Items Applicable to Schedule

10 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Related

Plant

Related

Labor

Related

Total

Excluded

Justification

12 Alternative Minimum Tax

13 Net Operating Loss

14

15

16

17

18

19

20

21

22

23

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

24 Total

Instructions for Account 190:

1. ADIT items related only to Schedule 10 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.

Consolidated Edison Company of New York, Inc.

Workpaper 2a10: Accumulated Deferred Income Taxes (ADIT) Workpaper - Current Year (Schedule 10 Projects)

(a)

ADIT- 282 - Includes Only Items Applicable to

Schedule 10 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Total

Plant

Labor

Excluded

Related

Related

Related

Justification

25 Accelerated Depreciation - Prorated

#DIV/0!

0

#DIV/0!

0

0

Workpaper 2c, Line 14, Col. (r)

26

27

28

29

0

0

0

0

0

0

0

0

0

30 Total

#DIV/0!

0

#DIV/0!

0

0

Instructions for Account 282:

1. ADIT items related only to Schedule 10 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.

Consolidated Edison Company of New York, Inc.

Workpaper 2a10: Accumulated Deferred Income Taxes (ADIT) Workpaper - Current Year (Schedule 10 Projects)

(a)

ADIT-283 - Includes Only Items Applicable to Schedule

10 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Related

Total

Plant

Labor

Excluded

Justification

31

32

33

34

35

36

37

0

0

0

0

0

0

0

0

0

0

0

0

38 Total

0

0

0

0

Instructions for Account 283:

1. ADIT items related only to Schedule 10 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.


Consolidated Edison Company of New York, Inc.

Workpaper 2b19: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Plant

Labor

Total

ADIT

Nonprorated Items

Prior Year

Related

Related

1

2

3

4

5

6

7

ADIT-190

ADIT-282

ADIT-283

Subtotal

Schedule 19 Projects W/S Allocator

GP Allocator

0

0

0

0

0

0

0

0

0

(Line 20)

(Line 26)

(Line 34)

(Line 1 + Line 2 + Line 3)

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Appendix A

(Line 4 * Line 5 or Line 6)

Prior Year ADIT

0

#DIV/0!

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

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

(a)

ADIT-190 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Plant

Related

Labor

Related

Total

Excluded

Justification

8

9

Alternative Minimum Tax

Net Operating Loss

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

10

11

12

13

14

15

16

17

18

19

20 Total

Instructions for Account 190:

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

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

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

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

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

Consolidated Edison Company of New York, Inc.

Workpaper 2b19: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year (Schedule 19 Projects)

(a)

(b)

(c)

(d)

(e)

(f)

)g)

(h)

ADIT- 282 - Includes Only Items Applicable to Schedule

19 Projects

Schedule 19

Projects

Related

Plant

Related

Labor

Related

Excluded

Justification

21 Depreciation - Liberalized Depreciation - Prorated

#DIV/0!

0

#DIV/0!

0

0

Workpaper 2d, Line 13, Col. (n)

22

23

24

25

0

0

0

0

0

0

0

0

0

26 Total

#DIV/0!

0

#DIV/0!

0

0

Instructions for Account 282:

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

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

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

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

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

Consolidated Edison Company of New York, Inc.

Workpaper 2b19: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year (Schedule 19 Projects)

(a)

ADIT-283 - Includes Only Items Applicable to Schedule

19 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 19

Projects

Related

Total

Plant

Related

Labor

Related

Excluded

Justification

27

28

29

30

31

32

33

0

0

0

0

0

0

0

0

0

0

0

0

34 Total

0

0

0

0

Instructions for Account 283:

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

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

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

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

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


Consolidated Edison Company of New York, Inc.

Workpaper 2b10: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Plant

Labor

Total

ADIT

Nonprorated Items

Prior Year

Related

Related

1

2

3

4

5

6

7

ADIT-190

ADIT-282

ADIT-283

Subtotal

Schedule 10 Projects W/S Allocator

GP Allocator

0

0

0

0

0

0

0

0

0

(Line 20)

(Line 26)

(Line 34)

(Line 1 + Line 2 + Line 3)

Appendix A

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Appendix A

(Line 4 * Line 5 or Line 6)

Prior Year ADIT

0

#DIV/0!

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

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

(a)

ADIT-190 - Includes Only Items Applicable to Schedule

10 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Related

Plant

Related

Labor

Related

Total

Excluded

Justification

8

9

Alternative Minimum Tax

Net Operating Loss

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

10

11

12

13

14

15

16

17

18

19

20 Total

Instructions for Account 190:

1. ADIT items related only to Schedule 10 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.

Consolidated Edison Company of New York, Inc.

Workpaper 2b10: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year (Schedule 10 Projects)

(a)

(b)

(c)

(d)

(e)

(f)

)g)

(h)

ADIT- 282 - Includes Only Items Applicable to Schedule

10 Projects

Schedule 10

Projects

Related

Plant

Related

Labor

Related

Excluded

Justification

21 Depreciation - Liberalized Depreciation - Prorated

#DIV/0!

0

#DIV/0!

0

0

Workpaper 2d, Line 13, Col. (n)

22

23

24

25

0

0

0

0

0

0

0

0

0

26 Total

#DIV/0!

0

#DIV/0!

0

0

Instructions for Account 282:

1. ADIT items related only to Schedule 10 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.

Consolidated Edison Company of New York, Inc.

Workpaper 2b10: Accumulated Deferred Income Taxes (ADIT) Workpaper - Prior Year (Schedule 10 Projects)

(a)

ADIT-283 - Includes Only Items Applicable to Schedule

10 Projects

(b)

(c)

(d)

(e)

(f)

(g)

(h)

Schedule 10

Projects

Related

Total

Plant

Related

Labor

Related

Excluded

Justification

27

28

29

30

31

32

33

0

0

0

0

0

0

0

0

0

0

0

0

34 Total

0

0

0

0

Instructions for Account 283:

1. ADIT items related only to Schedule 10 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.


Consolidated Edison Company of New York, Inc.

Workpaper 2c19: Accumulated Deferred Income Taxes - Prorated Projection (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

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

Rate Year = 2021

Account 282 (Note A)

(a)

(b)

Year

(c)

(d)

(e)

(f)

for

(g)

Beginning

Balance/

(h)

(i)

(j)

(k)

(l)

Plant

Allocation (j)

* (k)

(m)

(n)

(o)

(p)

Labor

(q)

Labor

Proration

(f) x (p)

(r)

Beginning Balance & Monthly Changes

Days in the Number of Days Total Days Weighting

Month

Schedule 19

Projects

Transmission Plant Related Gross Plant

Proration

(f) x (h)

Plant Proration Labor Related W/S Allocator

(f) x (l)

Total Transmission

Prorated Amount (i)

+ (m) + (q)

Remaining in

Year After

Current Month

in the

Projected

Rate Year

Allocator

(Appendix A)

(General and (Appendix A) Allocation

Common)

Projection Monthly Amount/

(d)/(e)

(n) * (o)

Ending Balance

December 31st balance of Prorated

1

2

3

4

5

6

7

8

9

10

11

12

13

14

ADIT (Note B)

January

February

March

April

May

June

July

August

September

October

November

December

Prorated Balance

2020

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

100.00%

91.78%

84.11%

75.62%

67.40%

58.90%

50.68%

42.19%

33.70%

25.48%

16.99%

8.77%

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

31

335

365

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

28

31

30

31

30

31

31

30

31

30

31

365

307

276

246

215

185

154

123

93

365

365

365

365

365

365

365

365

365

365

365

62

32

1

0.27%

#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


Consolidated Edison Company of New York, Inc.

Workpaper 2c10: Accumulated Deferred Income Taxes - Prorated Projection (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

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

Rate Year = 2021

Account 282 (Note A)

(a)

(b)

Year

(c)

(d)

(e)

(f)

for

(g)

Beginning

Balance/

(h)

(i)

(j)

(k)

(l)

Plant

Allocation (j)

* (k)

(m)

(n)

(o)

(p)

Labor

(q)

Labor

Proration

(f) x (p)

(r)

Beginning Balance & Monthly Changes

Days in the Number of Days Total Days Weighting

Month

Schedule 10

Projects

Transmission Plant Related Gross Plant

Proration

(f) x (h)

Plant Proration Labor Related W/S Allocator

(f) x (l)

Total Transmission

Prorated Amount (i)

+ (m) + (q)

Remaining in

Year After

Current Month

in the

Projected

Rate Year

Allocator

(Appendix A)

(General and (Appendix A) Allocation

Common)

Projection Monthly Amount/

(d)/(e)

(n) * (o)

Ending Balance

December 31st balance of Prorated

1

2

3

4

5

6

7

8

9

10

11

12

13

14

ADIT (Note B)

January

February

March

April

May

June

July

August

September

October

November

December

Prorated Balance

2020

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

2021

100.00%

91.78%

84.11%

75.62%

67.40%

58.90%

50.68%

42.19%

33.70%

25.48%

16.99%

8.77%

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

31

335

365

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

28

31

30

31

30

31

31

30

31

30

31

365

307

276

246

215

185

154

123

93

365

365

365

365

365

365

365

365

365

365

365

62

32

1

0.27%

#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


Consolidated Edison Company of New York, Inc

Workpaper 2d19: Accumulated Deferred Income Taxes - Actual Proration (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

Year =

2021

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

Account 282 (Note A)

Days in Period

Projection - Proration of Projected Deferred Tax

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

Activity

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

Difference between Actual activity (Col I)

projected and when projected activity

(m)

(n)

Preserve

proration when

Number of

Days

Remaining in Total Days in

Year After Projected Rate

Month's

Accrual of

Deferred

Taxes

Difference

between

projected

monthly and

actual monthly

actual monthly actual activity when is an increase while

Proration

Percentage

(c)/(d)

Projected

Monthly

Activity

Prorated

Amount

* (f)

Prorated Projected

Actual Monthly

and projected

monthly activity

are either both

increases or

decreases.

actual and

actual activity is a

Balance reflecting

Days in the

Month

Month

(e) Balance

Sum

Activity

(table

projected activity decrease OR projected proration or averaging (n)

Year (Line 14,

Col b)

of (g)

below, grand total)

are either both

increases or

decreases.

activity is a decrease

while actual activity is

an increase.

+ (k) +((l) + (m))/2

activity

(i) -

(f)

(See Note A)

(See Note A)

(See Note A)

1 December 31st balance

2 January

3 February

4 March

5 April

6 May

7 June

8 July

9 August

10 September

11 October

12 November

13  December

14 Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

31

335

365

365

365

365

365

365

365

365

365

365

365

365

91.78%

84.11%

75.62%

67.40%

58.90%

50.68%

42.19%

33.70%

25.48%

16.99%

8.77%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

28

31

30

31

30

31

31

30

31

30

31

365

307

276

246

215

185

154

123

93

62

32

1

0.27%

Gross Plant

Allocator

Plant Related (Appendix A) Total (d) * (e)

Labor Related

(General and W/S Allocator (Appendix

Schedule 19

Projects

Grand Total (b) +

(f) + (i)

Common)

A)

Total (g) * (h)

Actual Monthly Activity

15 January

16 February

17 March

18 April

19 May

20 June

21 July

22 August

23 September

24 October

25 November

26 December

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

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

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

Differences attributable to under-projection of ADIT in the annual projection will result in an adjustment to the projected prorated ADIT activity by the difference between the projected monthly activity

and the actual monthly activity. However, when projected monthly ADIT activity is an increase and actual monthly ADIT activity is a decrease, actual monthly ADIT activity will be used.

Likewise, when projected monthly ADIT activity is a decrease and actual monthly ADIT activity is an increase, actual monthly ADIT activity will be used.


Consolidated Edison Company of New York, Inc

Workpaper 2d10: Accumulated Deferred Income Taxes - Actual Proration (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

Year =

2021

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

Account 282 (Note A)

Days in Period

Projection - Proration of Projected Deferred Tax

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

Activity

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

Difference between Actual activity (Col I)

projected and when projected activity

(m)

(n)

Preserve

proration when

Number of

Days

Remaining in Total Days in

Year After Projected Rate

Month's

Accrual of

Deferred

Taxes

Difference

between

projected

monthly and

actual monthly

actual monthly actual activity when is an increase while

Proration

Percentage

(c)/(d)

Projected

Monthly

Activity

Prorated

Amount

* (f)

Prorated Projected

Actual Monthly

and projected

monthly activity

are either both

increases or

decreases.

actual and

actual activity is a

Balance reflecting

Days in the

Month

Month

(e) Balance

Sum

Activity

(table

projected activity decrease OR projected proration or averaging (n)

Year (Line 14,

Col b)

of (g)

below, grand total)

are either both

increases or

decreases.

activity is a decrease

while actual activity is

an increase.

+ (k) +((l) + (m))/2

activity

(i) -

(f)

(See Note A)

(See Note A)

(See Note A)

1 December 31st balance

2 January

3 February

4 March

5 April

6 May

7 June

8 July

9 August

10 September

11 October

12 November

13  December

14 Total

0

0

0

0

0

0

0

0

0

0

0

0

0

0

31

335

365

365

365

365

365

365

365

365

365

365

365

365

91.78%

84.11%

75.62%

67.40%

58.90%

50.68%

42.19%

33.70%

25.48%

16.99%

8.77%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

28

31

30

31

30

31

31

30

31

30

31

365

307

276

246

215

185

154

123

93

62

32

1

0.27%

Gross Plant

Allocator

Plant Related (Appendix A) Total (d) * (e)

Labor Related

(General and W/S Allocator (Appendix

Schedule 10

Projects

Grand Total (b) +

(f) + (i)

Common)

A)

Total (g) * (h)

Actual Monthly Activity

15 January

16 February

17 March

18 April

19 May

20 June

21 July

22 August

23 September

24 October

25 November

26 December

0

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

0

0

0

0

0

0

0

0

0

0

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

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

Differences attributable to under-projection of ADIT in the annual projection will result in an adjustment to the projected prorated ADIT activity by the difference between the projected monthly activity

and the actual monthly activity. However, when projected monthly ADIT activity is an increase and actual monthly ADIT activity is a decrease, actual monthly ADIT activity will be used.

Likewise, when projected monthly ADIT activity is a decrease and actual monthly ADIT activity is an increase, actual monthly ADIT activity will be used.


Effective Date: 8/22/2023 - Docket #: ER23-2212-002 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.8.2.2 OATT Rate Schedule 19 Att 3 - Formula Rate Templa

 

Consolidated Edison Company of New York, Inc.

Workpaper 3a19: Excess Accumulated Deferred Income Taxes (Schedule 19 Projects)

Resulting from Income Tax Rate Changes (Note A)

Actual or Projected for the 12 Months Ended December ….

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 or

Excess

Accumulated

Deferred Taxes

at December

31,

Adjusted

Deficient or

Excess

Accumulated

Deferred

Unprotected

Property

(UP)

Schedule 19

Projects

Allocation

Factors (Note

B)

ADIT Balances

After

Remeasurement

(Note C)

ADIT Balances

Prior to

Remeasurement

Allocated to Unprotected

Schedule 19 Other (UO) Amortization

Adjustments After

Remeasurement

Balance at

December 31

Column (h) -

Column (j)

Amortization

Year

Balance at

December 31

Column (k) -

Column (l)

Line Description

Taxes

Projects

(Note B)

Year

`

Column (b) * Line Column (b) -

43 Column (c)

Column (d) +

Column (e)

Column (f) *

Column (g)

Deficient Deferred Income Taxes -

amortized to 410.1

FERC Account 190

1

2

3

4

5

6

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Total FERC Account 190

FERC Account 282

7

8

9

Depreciation - Liberalized Depreciation

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

10

11 Total Account 282

FERC Account 283

12

13

14

15

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

16

17 Total FERC Account 283

Subtotal Before Being Grossed up for

18 Income Taxes

19 Gross Up

0

0

0

0

0

0

0

0

0

0

0

0

Total Deficient Accumulated Deferred

20 Income Taxes - Account 182.3

0

0

0

0

0

Excess Accumulated Deferred Income

Taxes - amortized to 411.1

FERC Account 190

21

22

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

23 Total Account 190

FERC Account 282

24 Depreciation - Liberalized Depreciation

25

26

27

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

P

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

28

29 Total Account 282

FERC Account 283

30

31

32

33

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

34

35 Total Account 283

Subtotal Before Being Grossed up for

36 Income Taxes

0

0

0

0

0

0

0

0

0

0

0

0

37 Gross Up

Total Excess Accumulated Deferred Income

38 Taxes - Account 254

0

0

0

0

0

0

0

0

0

0

39 Grand Total

40 Total Amortization

0

0

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

Note B: The allocation factors used to allocate total excess accumulated deferred income taxes to local transmission projections are (to be completed when used)

Note C: Remeasurement Factor equals the ratio of the current nominal tax rate to the prior nominal tax rate

41

42

43

New nominal rate

Prior nominal rate

Remeasurement Factor

1.0%

1.0%

100.0%

Note D:

Note E:

Note F:


Consolidated Edison Company of New York, Inc.

Workpaper 3b10: Excess Accumulated Deferred Income Taxes (Schedule 10 Projects)

Resulting from Income Tax Rate Changes (Note A)

Actual or Projected for the 12 Months Ended December ….

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 or

Excess

Accumulated

Deferred Taxes

at December

31,

Adjusted

Deficient or

Excess

Accumulated

Deferred

Unprotected

Property

(UP)

Schedule 10

Projects

Allocation

Factors (Note

B)

ADIT Balances

After

Remeasurement

(Note C)

ADIT Balances

Prior to

Remeasurement

Allocated to Unprotected

Schedule 10 Other (UO) Amortization

Adjustments After

Remeasurement

Balance at

December 31

Column (h) -

Column (j)

Amortization

Year

Balance at

December 31

Column (k) -

Column (l)

Line Description

Taxes

Projects

(Note B)

Year

`

Column (b) * Line Column (b) -

43 Column (c)

Column (d) +

Column (e)

Column (f) *

Column (g)

Deficient Deferred Income Taxes -

amortized to 410.1

FERC Account 190

1

2

3

4

5

6

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

Total FERC Account 190

FERC Account 282

7

8

9

Depreciation - Liberalized Depreciation

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

10

11 Total Account 282

FERC Account 283

12

13

14

15

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

16

17 Total FERC Account 283

Subtotal Before Being Grossed up for

18 Income Taxes

19 Gross Up

0

0

0

0

0

0

0

0

0

0

0

0

Total Deficient Accumulated Deferred

20 Income Taxes - Account 182.3

0

0

0

0

0

Excess Accumulated Deferred Income

Taxes - amortized to 411.1

FERC Account 190

21

22

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

23 Total Account 190

FERC Account 282

24 Depreciation - Liberalized Depreciation

25

26

27

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

P

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

28

29 Total Account 282

FERC Account 283

30

31

32

33

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0.000%

0.000%

0.000%

0.000%

0.000%

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

0

34

35 Total Account 283

Subtotal Before Being Grossed up for

36 Income Taxes

0

0

0

0

0

0

0

0

0

0

0

0

37 Gross Up

Total Excess Accumulated Deferred Income

38 Taxes - Account 254

0

0

0

0

0

0

0

0

0

0

39 Grand Total

40 Total Amortization

0

0

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

Note B: The allocation factors used to allocate total excess accumulated deferred income taxes to local transmission projections are (to be completed when used)

Note C: Remeasurement Factor equals the ratio of the current nominal tax rate to the prior nominal tax rate

41

42

43

New nominal rate

Prior nominal rate

Remeasurement Factor

1.0%

1.0%

100.0%

Note D:

Note E:

Note F:


Consolidated Edison Company of New York, Inc.

Workpaper 4: Permanent Book/Tax Differences

Actual or Projected for the 12 Months Ended December ….

Schedule 19 Projects

(a)

(b)

(c)

(d)

(e)

Tax Effect of

Permanent

Book/Tax

AFUDC Equity

Other 2

Other 3

Total

Line #

Differences

FF1 Reference

Amount

336-337

-

1

2

0

0

0

0

-

-

Income Tax Effect

-

Line 1 *

Sum of

Composite Tax Line 1 * Composite Line 1 * Composite Columns (b), (c)

Ref

Rate

Tax Rate

Tax Rate

and (d)

Schedule 10 Projects

(a)

(b)

(c)

(d)

(e)

Tax Effect of

Permanent

Book/Tax

AFUDC Equity

Other 2

Other 3

Total

Line #

Differences

FF1 Reference

336-337

-

3

4

Amount

0

0

0

0

-

-

Income Tax Effect

-

Line 3 *

Sum of

Composite Tax Line 3 * Composite Line 3 * Composite Columns (b), (c)

Rate Tax Rate Tax Rate and (d)

Ref


Consolidated Edison Company of New York, Inc.

Workpaper 5: Project Return (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

(j)

(k)

(l)

(m)

13 Month Averages

Allocate Other Rate Base Items to Schedule 19 Projects

Accumulated

Net General

Plant - Using

Allocator

Net Intangible Plant

Net Common

Deferred Income

Taxes - Using

Allocator

(Excess)/

Deficient ADIT -

Using Allocator

Land Held for Future Other Rate Base

Gross Plant in

Service

Accumulated

Depreciation

Net Operating

Property

-

- Using Allocator Plant - - Using

Use - Using

Allocator

Items - Using

Allocator

Total Rate

Base

Line #

Allocator

Allocator

Sum of Col.

(e) through

Col. (l)

Workpaper 1,

Line 14

Workpaper 1,

Line 28

Reference

Calculated

#DIV/0!

Col. (b) - Col. (d)

-

Line 6 * Col. (c)

#DIV/0!

Line 6 * Col. (c)

#DIV/0!

Line 6 * Col. (c)

#DIV/0!

Line 6 * Col. (c) Line 6 * Col. (c)

Line 6 * Col. (c)

#DIV/0!

Line 6 * Col. (c)

#DIV/0!

Project

Grouping 1

1

2

3

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 2

#DIV/0!

#DIV/0!

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 3

Project

Grouping 4

4

5

6

#DIV/0!

#DIV/0!

#DIV/0!

Total

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0

-

#DIV/0!

Appendix A, Line

32

#DIV/0!

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

Appendix A,

Line 24

Reference

19

20

21

23

Appendix A, Line 26

Weighted Preferred

and Common Equity

Rate

Preferred and

Common Equity

Return

Weighted Debt

Rate

Rate Base

WACC

Return

Debt Return

Attachment 6a

19, Line 4, Line

8, Line 12, or Col. (b) * Col.

Line 16

Attachment 6a 19,

Lines 2 + 3, Lines 6 +

7, Lines 10 + 11 or

Lines 14 + 15

Attachment 6a 19,

Line 1, Line 5,

Reference

Project

Grouping 1

Col.

(c)

Col. (b) * Col. (e)

#DIV/0!

Line 9 or Line 13 Col. (b) * Col. (h)

7

8

9

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 2

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project

Grouping 3

Project

10 Grouping 4

11

12 Total

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Schedule 19 Projects Included in Each Project Group

Project Project

Name Description

Gross

Investment

Project

Grouping 1

Project

Grouping 2

Project

Grouping 3

Project

Grouping 4


Consolidated Edison Company of New York, Inc.

Workpaper 6a19: Project Cost of Capital (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(Note A)

%s

(d)

(e)

(f)

(g)

(h)

(i)

(j)

Line #

Project 1

Long Term Debt

Preferred Stock

Common Stock

Capitalization

Cost Rates

WACC

1

2

3

Line 30, Col. (i)

Line 30, Col. (b)

Line 30, Col. (d)

0

0.0%

#DIV/0!

0.000% #DIV/0!

0.000%

(Lines 1 and 2,

Col. (j))

#DIV/0!

ROE per New York Public Service Commission, Case No.

ROE Ceiling

0.00%

10.87%

-

#DIV/0!

#DIV/0!

0

0.0%

0.00%

4

Total Capitalization

0

#DIV/0!

Project 2

Capitalization

%s

Cost Rates

WACC

5

6

7

Long Term Debt

Preferred Stock

Common Stock

Line 30, Col. (i)

Line 30, Col. (b)

Line 30, Col. (d)

0

0.0%

0.0%

#DIV/0!

0.000% #DIV/0!

0.000%

(Lines 5 and 6,

Col. (j))

#DIV/0!

ROE per New York Public Service Commission, Case No.

ROE Ceiling

0.00%

10.87%

-

#DIV/0!

0

0.00%

8

Total Capitalization

0

#DIV/0!

#DIV/0!

Project 3

Capitalization

%s

Cost Rates

WACC

9

10

11

Long Term Debt

Preferred Stock

Common Stock

Line 30, Col. (i)

Line 30, Col. (b)

Line 30, Col. (d)

0

0.0%

0.0%

#DIV/0!

0.000% #DIV/0!

0.000%

(Lines 9 and 10,

Col. (j))

#DIV/0!

ROE per New York Public Service Commission, Case No.

ROE Ceiling

0.00%

10.87%

-

#DIV/0!

0

0.00%

12

Total Capitalization

0

#DIV/0!

#DIV/0!

Project 4

Capitalization

%s

Cost Rates

WACC

13

14

15

Long Term Debt

Preferred Stock

Common Stock

Line 30, Col. (i)

Line 30, Col. (b)

Line 30, Col. (d)

0

0.0%

0.0%

#DIV/0!

0.000% #DIV/0!

0.000%

(Lines 13 and 14,

Col. (j))

#DIV/0!

ROE per New York Public Service Commission, Case No.

ROE Ceiling

0.00%

10.87%

-

#DIV/0!

0

0.00%

16

Total Capitalization

0

#DIV/0!

#DIV/0!

Common Equity

Less:

Accumulated

Other

Less: Preferred Comprehensive

Long-term Debt

Unamortized

Common Equity

for

Capitalization

Col. (a) - Col. (b)

- Col. (c)

Gains on

Reacquired

Debt

Unamortized Loss

on Reacquired

Debt

Unamortized

Debt Expense

Long-term Debt for

Capitalization

Total

Stock

Income

Total

Col. (e) + Col. (f) - Col. (g) -

(h)

Month

112-113, l.16, fn 112-113, l.3, fn

112-113, l.15, fn

112-113, l.24, fn 112-113, l.61, fn 110-111, l.69, fn 110-111, l.81, fn

17 December

18 January

19 February

20 March

21 April

22 May

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

23 June

24 July

25 August

26 September

27 October

28 November

29 December

30 Average

(114-117c, sum

of lines 62, 63,

31 Long Term Interest

32 Long-Term Debt

64, 65, 66)

0

(Line 30, Col. (i))

(Line 31 / Line

32)

0

33 Long-term Debt Interest Rate

34 Preferred Dividends

35 Preferred Stock

#DIV/0!

118-119c, l.29

-

-

(Line 30, Col. (b))

(Line 34 / Line

35)

36 Preferred Stock Rate

0

Note A: The 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.


Consolidated Edison Company of New York, Inc.

Workpaper 6b10: Cost of Capital (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

(f)

(g)

(h)

(i)

Line #

Capitalization

%s

Cost Rates

WACC

1

2

3

4

Long Term Debt

Preferred Stock

Common Stock

Total Capitalization

Line 18, Col. (i)

Line 18, Col. (b)

Line 18, Col. (d)

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0.000% #DIV/0!

11.100% #DIV/0!

#DIV/0!

-

0

0

(Note 1)

#DIV/0!

Note 1: The ROE includes the base ROE of 10.13% plus the RTO Participation Adder of 0.50%.

Common Equity

Less:

Long-term Debt

Accumulated

Other

Less: Preferred Comprehensive

Unamortized

Gains on

Reacquired

Debt

Common Equity

Unamortized Loss

on Reacquired

Debt

for

Unamortized

Debt Expense

Long-term Debt for

Capitalization

Total

Stock

Income

Capitalization

Col. (a) - Col. (b)

- Col. (c)

Total

Col. (e) + Col. (f) - Col. (g) -

(h)

Month

112-113, l.16, fn 112-113, l.3, fn

112-113, l.15, fn

112-113, l.24, fn 112-113, l.61, fn 110-111, l.69, fn 110-111, l.81, fn

5

6

7

8

9

December

January

February

March

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

April

10 May

11 June

12 July

13 August

14 September

15 October

16 November

17 December

18 Average

(114-117c, sum

of lines 62, 63,

19 Long Term Interest

20 Long-Term Debt

64, 65, 66)

0

(Line 18, Col. (i))

(Line 19 / Line

20)

0

21 Long-term Debt Interest Rate

22 Preferred Dividends

23 Preferred Stock

#DIV/0!

118-119c, l.29

-

-

(Line 18, Col. (b))

(Line 22 / Line

23)

24 Preferred Stock Rate

0


Consolidated Edison Company of New York, Inc.

Workpaper 7a19: Annual True-up Adjustment (Schedule 19 Projects)

Actual or Projected for the 12 Months Ended December ….

Schedule 19

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, Con Edison 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

Estimated

Interest Rate

Actual Interest

Rate

Interest

Rate True

1

2

3

4

5

6

A

B

C

D

E

F

ATRR based on actual costs included for the previous calendar year

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

Difference (A-B)

Future Value Factor (1+i)^24

True-up Adjustment (C*D)

Interest Rate True-up (Note 1)

0

0

0

0

1.0000

1.0000

0

0

0

0

Where:

i = average interest rate as calculated below

Interest on Amount of Refunds or Surcharges

Estimated

Actual

Monthly

Interest Rate

Monthly

Interest Rate

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

Month

July

August

September

10 October

11 November

12 December

13 January

14 February

15 March

16 April

Year

7

8

9

Year 1

Year 1

Year 1

Year 1

Year 1

Year 1

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 3

Year 3

Year 3

Year 3

Year 3

Year 3

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

17 May

18 June

19 July

20 August

21 September

22 October

23 November

24 December

25 January

26 February

27 March

28 April

29 May

30 June

31 Average

0.00000%

0.00000%

Note 1: Use Workpaper 7a19-True-up Adjustment to determine ATU with actual interest rates and include interest rate true-up adjustment with subsequent ATU adjustment.


Consolidated Edison Company of New York, Inc.

Workpaper 7b10: Annual True-up Adjustment (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

Schedule 10

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, Con Edison 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

Estimated

Interest Rate

Actual Interest

Rate

Interest

Rate True

1

2

3

4

5

6

A

B

C

D

E

F

ATRR based on actual costs included for the previous calendar year

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

Difference (A-B)

Future Value Factor (1+i)^24

True-up Adjustment (C*D)

Interest Rate True-up from (Note 1)

0

0

0

0

1.0000

1.0000

0

0

0

0

Where:

i = average interest rate as calculated below

Interest on Amount of Refunds or Surcharges

Estimated

Actual

Monthly

Interest Rate

Monthly

Interest Rate

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

Month

July

August

September

10 October

11 November

12 December

13 January

14 February

15 March

16 April

Year

7

8

9

Year 1

Year 1

Year 1

Year 1

Year 1

Year 1

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 2

Year 3

Year 3

Year 3

Year 3

Year 3

Year 3

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

0.0000%

17 May

18 June

19 July

20 August

21 September

22 October

23 November

24 December

25 January

26 February

27 March

28 April

29 May

30 June

31 Average

0.00000%

0.00000%

Note 1: Use Workpaper 7a10-True-up Adjustment to determine ATU with actual interest rates and include interest rate true-up adjustment with subsequent ATU adjustment.


Consolidated Edison Company of New York, Inc.

Workpaper 8: Electric and Common Depreciation and Amortization Rates

Actual or Projected for the 12 Months Ended December ….

FERC Account

Description

Rate (Note 1)

Transmission

350

Land Rights

NA

351

352

353

354

Energy Storage Equipment

Structures and Improvements

Station Equipment

Towers and Fixtures

Poles and Fixtures

6.67%

2.00%

2.80%

2.00%

NA

355

356

357

358

359

Overhead Conductors & Devices

Underground Conduit

Underground Conductors & Devices

Roads and Trails

2.45%

1.64%

2.08%

NA

Transmission General and Intangible

303

Intangible Plant - Transmission Software

Truck Automobile

Light Truck Automobile

20.00%

11.25%

11.25%

6.67%

392.1

392.2

397

Communication Equipment

Common

302

Franchises and Consents

NA

303

303

303

303

303

390

Intangible Plant - Software 5 years

Intangible Plant - Software 10 years

Intangible Plant - Software 15 years

Intangible Plant - Software 20 years

Intangible Plant - C Plant 15 Years

Structures and Improvements

Office Furniture and Equipment - EDP

Equipment

20.00%

10.00%

7.00%

5.00%

6.67%

2.55%

391

391

12.00%

11.88%

Office Furniture and Equipment - EDP

Equipment - ERRP

391

392

393

394

395

396

362.7

398

Office Furniture and Equipment - All Other

Transportation Equipment - All

Stores Equipment

Tools, Shop and Garage Equipment

Laboratory Equipment

Power Operated Equipment

Communication Equipment

Miscellaneous Equipment

6.00%

11.00%

5.00%

5.00%

5.00%

8.00%

7.00%

5.00%

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


Consolidated Edison Company of New York, Inc.

Workpaper 9: Prior Period Corrections

Actual or Projected for the 12 Months Ended December ….

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

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

(a)

(b)

(c)

(d)

Calendar Year

Calendar Year

Schedule 19 Projects

Revenue

Impact of

Correction

Schedule 10 Projects

Revenue

Impact of

Correction

Line

Revenue

Requirement

Revenue

No. Description

Source

Description

Source

Requirement

1

2

Filing Name and Date

Original Revenue Requirement

Filing Name and Date

Original Revenue Requirement

0

0

3

4

Description of Correction 1

Description of Correction 2

0

0

Description of Correction 1

Description of Correction 2

0

0

5

6

7

Total Corrections

(Line 3 + Line 4)

(Line 2 + Line 5)

(Line 5)

0

0

0

Total Corrections

(Line 3 + Line 4)

(Line 2 + Line 5)

(Line 5)

0

0

0

Corrected Revenue Requirement

Total Corrections

Corrected Revenue Requirement

Total Corrections

8

9

10

Average Monthly FERC Refund Rate

Number of Months of Interest

Note A

Note B

(Line 7 * Line 8 *

Line 9)

0.00% Average Monthly FERC Refund Rate

Note A

Note B

(Line 7 * Line 8 *

Line 9)

0.00%

0

0

0

0

Number of Months of Interest

Interest on Correction

Interest on Correction

0

0

11 Sum of Corrections Plus Interest

(Line 7 + Line 10)

Sum of Corrections Plus Interest

(Line 7 + Line 10)

Notes:

A

B

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

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

up Adjustment is computed.

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

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

computed.


Effective Date: 8/22/2023 - Docket #: ER23-2212-002 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.8.2.2 OATT Rate Schedule 19 Att 3 - Formula Rate Templa

 

Consolidated Edison Company of New York, Inc.

Workpaper 10a19: Schedule 19 Project ATRRs

Actual or Projected for the 12 Months Ended December ….

Line

No.

Item

Page, Line, Col.

Transmission ($)

(1)

(2)

1

2

3

Gross Transmission Plant

Accumulated Depreciation - Transmission

Direct Assignable Rate Base

Appendix A, Line 2

Appendix A, Line 10

(Sum of Lines 1 + 2)

-

-

-

4

5

O&M TRANSMISSION EXPENSE

TAXES OTHER THAN INCOME TAXES

GENERAL AND COMMON DEPRECIATION EXPENSE

REVENUE CREDITS

Appendix A, Line 47

Appendix A, Line 58

Appendix A, Line 49 + Line 50

Appendix A 1, Line 74

(Sum of Lines 4 through 7)

Line 8 / Line 1

#DIV/0!

#DIV/0!

#DIV/0!

-

6

7

8

TOTAL

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

9

Annual Factor for Expenses

INCOME TAXES

10

11

Appendix A 1, Line 69

Line 10 / Line 3

Annual Factor for Income Taxes

1

2

3

4

5

6

7

8

9

10

11

12

13

14

Annual Expenses

Annual Allocation

Line

No.

Without

Depreciation ($)

Accumulated

Depreciation ($)

Direct Assignable Rate

Base

Factor for Income Annual Income Tax

Annual Revenue

Requirement ($)

Net Revenue

Requirement ($)

Project Name and #

Gross Plant ($)

Annual Factor for Expenses

Taxes

Charge ($)

Return

Workpaper 5-

Project Return,

Line 7 through

11

Project Depreciation ($)

True-Up Adjustment ($)

Corrections

Workpaper 1-RB

Items, Line 14

Workpaper 1-RB

Items, Line 28

Workpaper 1-RB Items, Col.4 + Col. 8 + Col. 9 +

Col.11 + Col. 12

+ Col. 13

Reference

Line 9

Col.2 * Col. 3

Col.2 + Col. 5

Line 11

Col.6 + Col. 7

Line 58

10

Note A

Note B

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

Schedule 19 Projects

Project 1

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Project 2

#DIV/0!

Project 3

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

31

Total

-

#DIV/0!

-

-

#DIV/0!

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Note C

Notes

A

B

C

True-up adjustment is from Workpaper 7a19 and allocated to Schedule 19 Projects using Col. 13.

Corrections are from Workpaper 9 and allocated to Schedule 19 Projects using Col. 13.

Ties to Appendix A, Line 78, Col. (5)


Consolidated Edison Company of New York, Inc.

Workpaper 10b10: Schedule 10 Project ATRRs

Actual or Projected for the 12 Months Ended December ….

Line

No.

Item

Page, Line, Col.

Transmission ($)

(1)

(2)

1

2

3

Gross Transmission Plant

Accumulated Depreciation - Transmission

Direct Assignable Rate Base

Appendix A, Line

2

-

-

-

Appendix A, Line 10

(Sum of Lines

1

+

2)

4

5

O&M TRANSMISSION EXPENSE

TAXES OTHER THAN INCOME TAXES

GENERAL AND COMMON DEPRECIATION EXPENSE

REVENUE CREDITS

Appendix A, Line 47

Appendix A, Line 58

#DIV/0!

#DIV/0!

#DIV/0!

6

Appendix A, Line 49

Appendix A 1, Line 74

(Sum of Lines through 7)

Line Line

Appendix A 1, Line 69

Line 10 Line

W orkpaper 11, Line

Line 12 Line

+

Line 50

7

-

8

TOTAL

4

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

9

Annual Factor for Expenses

8

/

1

10

11

12

13

RETURN AND INCOME TAXES

+

8

72

Annual Factor for Return and Income Taxes

Value of 100 Basis Points ROE Adder

Annual Factor Based Upon Direct Assignable Rate Base

/

3

/

3

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

Total Annual

Revenue

Annual Expenses

Without

Depreciation ($)

Annual Allocation

Factor for Return

and Income Taxes

Project

Depreciation

Expense ($)

Line

No.

Accumulated

Depreciation ($)

Direct Assignable Rate

Base

Annual Return

Charge ($)

Annual Revenue

Requirement ($)

Incentive Return in Incentive Return Requirement True-Up Adjustment

Net Revenue

Requirement ($)

Project Name and

#

Gross Plant ($)

Annual Factor for Expenses

Basis Points

($)

Col. 11

1.00%

($)

($)

Corrections

Col.

/

6

*

*

W orkpaper 11-

ROE Adder

W orkpaper 1-RB

Items, Line 14

W orkpaper 1-RB

Items, Line 28

W orkpaper 1-RB

Items, Line 57

Col.4

Col.

+

Col.

9

8

+

Col. 10

Col. 12

+

Col.13

+

Col. 14

Reference

Line

9

Col.2

*

Col.

3

Col.2

+

Col.

5

Line 11

Col.6

+

Col.

7

Note

C

Line

8

Note

A

Note

B

+

Col. 15

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

Schedule 10 Projects

Project

Project

Project

1

2

3

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

0.00%

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

-

33

Total

-

#DIV/0!

-

-

#DIV/0!

-

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Note D

Notes

A

B

True-up adjustment is from Workpaper 7b10 and allocated to Schedule 10 Projects using Col. 15.

Corrections are from Workpaper 9 and allocated to Schedule 10 Projects using Col. 15.

C

ROE Incentive adders are as follows:

ROE Adder

FERC Order

Project

Project

Project

1

2

3

D

Ties to Appendix A, Line 83, Column

7


Effective Date: 8/22/2023 - Docket #: ER23-2212-002 - Page 1


NYISO Tariffs --> Open Access Transmission Tariff (OATT) --> 6 OATT Rate Schedules --> 6.19.8.2.2 OATT Rate Schedule 19 Att 3 - Formula Rate Templa

 

Consolidated Edison Company of New York, Inc.

Workpaper 11: ROE Adder (Schedule 10 Projects)

Actual or Projected for the 12 Months Ended December ….

(a)

(b)

(c)

(d)

(e)

Line #

Change in WACC for 100 basis point ROE Adder

Capitalization

%s

Cost Rates

WACC

#DIV/0!

#DIV/0!

From Workpaper

6b10

From Workpaper

6b10

1

2

Long Term Debt

Preferred Stock

0

#DIV/0!

#DIV/0!

0.000%

-

0.000%

1.000%

From Workpaper

6b10

3

4

Common Stock

0

0

#DIV/0!

#DIV/0!

#DIV/0!

#DIV/0!

Total Capitalization

Line 4 * Appendix

A, Line 61

5

6

Income Taxes

Total

#DIV/0!

#DIV/0!

Line 4 + Line 5

Workpaper 10b10,

Line 3

7

8

Direct Assignable Rate Base

Value of 100 basis points

0

Line 6 * Line 7

#DIV/0!

 

Effective Date: 8/22/2023 - Docket #: ER23-2212-002 - Page 1