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.