Filing Date (enter w/leading '): 05/17/2013 2013 Annual Filing? (Y/N) y Do you have an extension of X-factor rules? n q "
Tariff Entity (4 character COSA code): test Initial CALLS Restructure? n
Transmittal Number (enter w/leading '): xxx
Filing Name: Proposed 2013 Annual Filing SHORTFORM TRP (130212.xls)
1) Uses multiplicative SBI Upper limits To print EXG1 report (for filing), press "CTRL+SHIFT+P"
2) Chart check sheets begin at row 1001 To print YZE_EXG1 report (for analysis only), press "CTRL+SHIFT+Y"
3) ANALYZER (18 pages) starts in column DG.
IND-1 eliminated in ShortForm. Arrow right for next chart.
The only data cells to be populated are in range AN35 to AW131.
TGT & PCI eliminated in ShortForm.
SUM1 eliminated in ShortForm
EXG-1 chart, Page 1. Arrow down for next page.
Page down 60 for next page.
To Print, Use Manual Compression = 63% and Landscape Mode.
EXG-1
Filing Date: 05/17/2013
Filing Entity: test
Transmittal Number: xxx
Proposed 2013 Annual Filing SHORTFORM TRP (130212.xls) Price Cap Tariff Review Plan
Page 1 of 2 Exogenous Cost Changes
TRUEUP PRIOR
REGULA- EXCESS REMOVAL OF SHARING / CURRENT TELECOMM.
SALE OF TORY DEFERRED ITC LOW END LOW END LOW END RELAY
EXCHANGES FEES TAXES AMORTIZ. ADJUSTMENT ADJUSTMENT ADJUSTMENT SERVICES REG/NON-REG
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------
(A) (B) (C) (D) (E) (F) (G) (H) (I)
COMMON LINE Revenue Effect
100 Depreciation Expense N/A N/A N/A N/A N/A N/A N/A N/A N/A
110 Expense less Depreciation N/A N/A N/A N/A N/A N/A N/A N/A N/A
120 Taxes less F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A
130 Net Return N/A N/A N/A N/A N/A N/A N/A N/A N/A
140 F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A
150 Uncollectible Rev. & Other Adj. N/A N/A N/A N/A N/A N/A N/A N/A N/A
160 Revenue Effects 0 0 0 0 0 0 0 0 0
INTEREXCHANGE Revenue Effect
700 Depreciation Expense N/A N/A N/A N/A N/A N/A N/A N/A N/A
710 Expense less Depreciation N/A N/A N/A N/A N/A N/A N/A N/A N/A
720 Taxes less F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A
730 Net Return N/A N/A N/A N/A N/A N/A N/A N/A N/A
740 F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A
750 Uncollectible Rev. & Other Adj. N/A N/A N/A N/A N/A N/A N/A N/A N/A
760 Revenue Effects 0 0 0 0 0 0 0 0 0
SPECIAL Access Revenue Effect
1300 Depreciation Expense N/A N/A N/A N/A N/A N/A N/A N/A N/A
1310 Expense less Depreciation N/A N/A N/A N/A N/A N/A N/A N/A N/A
1320 Taxes less F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A
1330 Net Return N/A N/A N/A N/A N/A N/A N/A N/A N/A
1340 F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A
1350 Uncollectible Rev. & Other Adj. N/A N/A N/A N/A N/A N/A N/A N/A N/A
1360 Revenue Effects 0 0 0 0 0 0 0 0 0
NOTE: (1) Total may not equal sum of changes due to interactive effects.
(2) Display whole numbers.
EXG-1
Filing Date: 05/17/2013
Filing Entity: test
Transmittal Number: xxx
Proposed 2013 Annual Filing SHORTFORM TRP (130212.xls) Price Cap Tariff Review Plan
Page 2 of 2 Exogenous Cost Changes
DESCRIPTION: NANPA TBNP
(incl. reversal)
OTHER (1) OTHER (2) OTHER (3) OTHER (4) OTHER (5) OTHER (6) OTHER (7) OTHER (8) OTHER (9) TOTAL
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ----------------------
(J) (K) (L) (M) (N) (O) (P) (Q) (R) (S)
COMMON LINE Revenue Effect
100 Depreciation Expense N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
110 Expense less Depreciation N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
120 Taxes less F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
130 Net Return N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
140 F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
150 Uncollectible Rev. & Other Adj. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
160 Revenue Effects 0 0 0 0 0 0 0 0 0 0
INTEREXCHANGE Revenue Effect
700 Depreciation Expense N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
710 Expense less Depreciation N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
720 Taxes less F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
730 Net Return N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
740 F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
750 Uncollectible Rev. & Other Adj. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
760 Revenue Effects 0 0 0 0 0 0 0 0 0 0
SPECIAL Access Revenue Effect
1300 Depreciation Expense N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
1310 Expense less Depreciation N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
1320 Taxes less F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
1330 Net Return N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
1340 F.I.T. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
1350 Uncollectible Rev. & Other Adj. N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A
1360 Revenue Effects 0 0 0 0 0 0 0 0 0 0
NOTE: (1) Total may not equal sum of changes due to interactive effects.
(2) Display whole numbers.
EXG-1 ANALYZE
Filing Date: 05/17/2013
Filing Entity: test
Transmittal Number: xxx
Proposed 2013 Annual Filing SHORTFORM TRP (130212.xls) Price Cap Tariff Review Plan
Page 1 of 2 Exogenous Cost Changes
TRUEUP PRIOR
REGULA- EXCESS REMOVAL OF SHARING / CURRENT TELECOMM.
SALE OF TORY DEFERRED ITC LOW END LOW END LOW END RELAY
EXCHANGES FEES TAXES AMORTIZ. ADJUSTMENT ADJUSTMENT ADJUSTMENT SERVICES REG/NON-REG
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- --------------------
(A) (B) (C) (D) (E) (F) (G) (H) (I)
COMMON LINE Revenue Effect
160 Revenue Effects 0 0 0 0 0 0 0 0 0
INTEREXCHANGE Revenue Effect
760 Revenue Effects 0 0 0 0 0 0 0 0 0
SPECIAL Access Revenue Effect
1360 Revenue Effects 0 0 0 0 0 0 0 0 0
NOTE: (1) Total may not equal sum of changes due to interactive effects.
(2) Display whole numbers.
EXG-1 ANALYZE
Filing Date: 05/17/2013
Filing Entity: test
Transmittal Number: xxx
Proposed 2013 Annual Filing SHORTFORM TRP (130212.xls) Price Cap Tariff Review Plan
Page 2 of 2 Exogenous Cost Changes
DESCRIPTION: NANPA TBNP
(incl. reversal)
OTHER (1) OTHER (2) OTHER (3) OTHER (4) OTHER (5) OTHER (6) OTHER (7) OTHER (8) OTHER (9) TOTAL
-------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ----------------------
(J) (K) (L) (M) (N) (O) (P) (Q) (R) (S)
COMMON LINE Revenue Effect
160 Revenue Effects 0 0 0 0 0 0 0 0 0 0
INTEREXCHANGE Revenue Effect
760 Revenue Effects 0 0 0 0 0 0 0 0 0 0
SPECIAL Access Revenue Effect
1360 Revenue Effects 0 0 0 0 0 0 0 0 0 0
NOTE: (1) Total may not equal sum of changes due to interactive effects.
(2) Display whole numbers.