12 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 A B C D E F G H Filing Date: Filing Entity: Transmittal Number: Interstate Intrastate Net Rec. Comp. TRS Increment Regulatory-Fees Increment NANPA Increment Total 2013 RoR ILEC Interstate Rates, cell F11 2013 RoR ILEC Intrastate Rates, cell G10 2013 RoR ILEC Rec. Comp. Rates, cell E9 Input Input Input B+C+D+E+F+G 0 0 0 0 0 0 0 0 0 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 Eligible Recovery 0 TY 2012-2013 Eligible Recovery (Note 1) COSA 12 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 A B C D E F G H Filing Date: Filing Entity: Transmittal Number: COSA: Most Recently Filed Interstate Switched Access Revenue Requirement Input F7 0 TY Baseline Adjustment Factor (BAF) 0.95 0.95 .95*.95 0.9025 BAF X Most Recently Filed Interstate Switched Access Revenue Requirement F7*F8 0 H7*H8 0 Total Expected Maximum Interstate Revenue Sum of Col. H 0 Sum of Col. K 0 Interstate Eligible Recovery F9-F10 0 H9-H10 0 Interstate Tariff Section USOC Interstate Switched Access Rate Element Unit of Demand (e.g., MOU or DS1) 12/29/11 Interstate Rate 7/1/2012 Proposed Rate TY 2012-2013 Expected Units TY 2012-2013 Expected Maximum Revenue Input Input Input (Note 1) Input Input Input Input E*G ** LOCAL SWITCHING ** 0 0 0 0 0 ** INFORMATION ** 0 0 0 0 0 ** TANDEM-SWITCHED TRANSPORT AND TANDEM ** 0 0 0 0 0 ** SIGNALING FOR TANDEM SWITCHING ** 0 0 0 0 0 ** DIRECT-TRUNKED TRANSPORT ** 0 0 0 0 0 ** DEDICATED SIGNALING TRANSPORT ** 0 0 0 0 0 ** ENTRANCE FACILITIES ** 0 0 0 0 0 ** LINE INFORMATION DATABASE ** 0 0 0 0 0 ** BILLING NAME AND ADDRESS ** 0 0 0 0 0 Total TY 2012-2013 Expected Maximum Interstate Revenue (Sum of Col. H) 0 Note 1: Enter one rate element per line under the relevant category. Insert rows as necessary. TY 2012-2013 (Note 2) TY 2013-2014 (Note 3) TY 2012-2013 Interstate Rate and Eligible Recovery Calculations 12 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 A B C D E F G H I J K L M N O P Q R S Filing Date: Filing Entity: Transmittal Number: COSA: Total FY 2011 Actual Revenue for Transitional Intrastate Access Service Rate Elements Sum of Col. O 0 Sum of Col. O 0 Baseline Adjustment Factor X Total FY 2011 Actual Revenue for Transitional Intrastate Access Service Rate Elements Sum of Col. P 0 .9025*I7 0 Total Expected Maximum Transitional Intrastate Access Service Revenue Sum of Col. R 0 Sum of Col. X 0 Total Intrastate Eligible Recovery Sum of Col. S 0 I8-I9 0 Intrastate Tariff Section Interstate Tariff Section USOC Intrastate and Interstate Switched Access Rate Elements for Transitional Intrastate Access Service Categories Unit of Demand (e.g., MOU or DS1) 12/29/2011 Intrastate Rate 12/29/2011 Interstate Rate FY 2011 Intrastate Units: Terminating for Non- Dedicated or Originating and Terminating for Dedicated Elements Intrastate Price-Out with 12/29/2011 Rates and FY 2011 Units Interstate Price-Out with 12/29/2011 Rates and FY 2011 Units 50% of Price- Out Difference 7/1/2012 Proposed Intrastate Rate Intrastate Price-Out with 7/1/2012 Proposed Rates and FY 2011 Units Intrastate Price-Out Difference FY 2011 Actual Intrastate Revenue 95% of FY 2011 Actual Intrastate Revenue TY 2012- 2013 Expected Intrastate Units TY 2012- 2013 Expected Maximum Intrastate Revenue TY 2012- 2013 Intrastate Eligible Recovery Input Input Input Input (Note 1) Input Input Input Input F*H G*H .5*(I-J) Input L*H I-M Input .95*O Input L*Q P-R ** TERMINATING END OFFICE ACCESS SERVICE ** Terminating Carrier Common Line 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Terminating Local Switching 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Terminating Other (e.g., information surcharge, Transport or Residual Interconnection Charges) 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ** TERMINATING TANDEM-SWITCHED TRANSPORT ACCESS SERVICE ** Terminating Tandem-Switched Common Transport 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Terminating Tandem Switching 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ** ORIGINATING AND TERMINATING DEDICATED TRANSPORT ACCESS SERVICE ** Originating and Terminating Entrance Facilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Originating and Terminating Tandem-Switched Dedicated Transport 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Originating and Terminating Direct-Trunked Transport 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 Note 1: Enter one rate element per line under the relevant category. Insert rows as necessary. TY 2012-2013 (Note 2) TY 2013-2014 (Note 3) TY 2012-2013 Intrastate Rate and Eligible Recovery Calculations 12 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A B C D E F G H I J K L M N O Filing Date: Filing Entity: Transmittal Number: COSA: O20 0 W20 0 J26 0 U26 0 E7-E8 0 G7-G8 0 Revenue Category (Note 1) FY 2011 Revenue FY 2011 MOU FY 2011 Average Rate FY 2011 Terminating Revenue FY 2011 Terminating MOU FY 2011 Average Rate July 1, 2012 Average Rate Price Out with July 1, 2012 Average Rates and FY 2011 Units Revenue Difference % Revenue Difference TY 2012-2013 Expected Demand TY 2012- 2013 Expected Revenue 95% of FY 2011 Revenue TY 2012- 2013 Rec. Comp. Eligible Recovery Revenue Input Input B/C Input Input E/F (D-G)/2+G or D H*C B - I (J/B)*100 Input H*L .95*B N-M End Office Switching 0.000000 0.000000 0.000000 0 0 N/A 0 0 0 Tandem Switching 0.000000 0.000000 0.000000 0 0 N/A 0 0 0 Common Transport 0.000000 0.000000 0.000000 0 0 N/A 0 0 0 Transport and Termination 0.000000 0.000000 0.000000 0 0 N/A 0 0 0 Total 0 0 0 0 0.00% 0 0 0 0 Expense Category FY 2011 Expense FY 2011 MOU FY 2011 Average Rate % Revenue Difference July 1, 2012 Average Rate TY 2012- 2013 Expected MOU TY 2012-2013 Expected Expense 95% of FY 2011 Expense TY 2012- 2013 Rec. Comp. Eligible Recovery Expense Input Input B/C K20 D*(1-E) Input F*G .95*B I-H Total Expense 0.000000 0.00% 0.000000 0 0 0 Note 1: Use rows 16, 17, and 18 for traffic carried pursuant to reciprocal compensation agreements that specify separate rates for end office switching, tandem switching, and common transport. Use row 19 for traffic carried pursuant to reciprocal compensation agreements that specify only a single transport and termination rate. TY 2012-2013 Reciprocal Compensation Eligible Recovery Expense Calculations Reciprocal Compensation Equivalent Interstate Access Reciprocal Compensation Eligible Recovery Revenue Reciprocal Compensation Eligible Recovery Expense Net Reciprocal Compensation Eligible Recovery TY 2102-2013 Revised Reciprocal Compensation Rate and Eligible Recovery Calculations TY 2012-2013 (Note 2) TY 2013-2014 (Note 3) Reciprocal Compensation Eligible Recovery Revenue Calculations