Filing Date (enter w/leading '): 6/17/2013 RCCMRSTRP-1 Holding Company Filing Name: Holding Company Summary Holding Company Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Note: Copy the Study Area section down this worksheet for each Study Area in the Holding Company Study Area 1 Summary Study Area 1 Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Inputs in Blue (Revenue and MOU Source: Internal Company ICC Non-CMRS Recip Comp study) Inputs in Green (Revenue and MOU Source: ICC Access Reduction Form) Total Reciprocal Compensation Expense Dollars FY 2011 -$ Plan Year 2 - July 2, 2013 FY 2011 Revenue FY 2011 Terminating MOUs/Demand Revenue Yield FY 2011 Terminating Revenue FY 2011 Terminating MOUs/Demand Revenue Yield Interstate Weighted Rate Yield 2013 Plan Yr 2 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = Min C or G I = B * H J = I - A End Office Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Tandem Switching Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Common/Shared Transport Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Special Arrangement Dedicated Transport -$ - -$ -$ - -$ -$ -$ -$ -$ Other Element -$ -$ -$ -$ -$ Total -$ -$ -$ -$ Study Area 2 Summary Study Area 2 Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Inputs in Blue (Revenue and MOU Source: Internal Company ICC Non-CMRS Recip Comp study) Inputs in Green (Revenue and MOU Source: ICC Access Reduction Form) Total Reciprocal Compensation Expense Dollars FY 2011 Plan Year 2 - July 2, 2013 FY 2011 Revenue FY 2011 Terminating MOUs/Demand Revenue Yield FY 2011 Terminating Revenue FY 2011 Terminating MOUs/Demand Revenue Yield Interstate Weighted Rate Yield 2013 Plan Yr 2 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = Min C or G I = B * H J = I - A End Office Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Tandem Switching Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Common/Shared Transport Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Special Arrangement Dedicated Transport -$ - -$ -$ - -$ -$ -$ -$ -$ Other Element -$ -$ -$ -$ -$ Total -$ -$ -$ -$ Recip Comp Interstate Plan Impact Recip Comp Interstate Plan Impact RCCMRSTRP-1 Page 1 of 5 Filing Date (enter w/leading '): 6/17/2013 RCCMRSTRP-1 Holding Company Filing Name: Holding Company Summary Holding Company Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Note: Copy the Study Area section down this worksheet for each Study Area in the Holding Company Study Area 3 Summary Study Area 3 Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Inputs in Blue (Revenue and MOU Source: Internal Company ICC Non-CMRS Recip Comp study) Inputs in Green (Revenue and MOU Source: ICC Access Reduction Form) Total Reciprocal Compensation Expense Dollars FY 2011 -$ Plan Year 2 - July 2, 2013 FY 2011 Revenue FY 2011 Terminating MOUs/Demand Revenue Yield FY 2011 Terminating Revenue FY 2011 Terminating MOUs/Demand Revenue Yield Interstate Weighted Rate Yield 2013 Plan Yr 2 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = Min C or G I = B * H J = I - A End Office Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Tandem Switching Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Common/Shared Transport Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Special Arrangement Dedicated Transport -$ - -$ -$ - -$ -$ -$ -$ -$ Other Element -$ -$ -$ -$ -$ Total -$ -$ -$ -$ Study Area 4 Summary Study Area 4 Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Inputs in Blue (Revenue and MOU Source: Internal Company ICC Non-CMRS Recip Comp study) Inputs in Green (Revenue and MOU Source: ICC Access Reduction Form) Total Reciprocal Compensation Expense Dollars FY 2011 -$ Plan Year 2 - July 1, 2013 FY 2011 Revenue FY 2011 Terminating MOUs/Demand Revenue Yield FY 2011 Terminating Revenue FY 2011 Terminating MOUs/Demand Revenue Yield Interstate Weighted Rate Yield 2013 Plan Yr 2 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = Min C or G I = B * H J = I - A End Office Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Tandem Switching Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Common/Shared Transport Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Special Arrangement Dedicated Transport -$ - -$ -$ - -$ -$ -$ -$ -$ Other Element -$ -$ -$ -$ -$ Total -$ -$ -$ -$ Recip Comp Interstate Plan Impact Recip Comp Interstate Plan Impact RCCMRSTRP-1 Page 2 of 5 Filing Date (enter w/leading '): 6/17/2013 RCCMRSTRP-1 Holding Company Filing Name: Holding Company Summary Holding Company Plan Year 2 2013 Eligible ARC/CAF Recovery Revenue X = Col J -$ Eligible ARC/CAF Recovery Expense Y = Exp * Revenue Ratio -$ Net Non-CMRS Recip Comp Eligible Recovery (before Z * = X + Y -$ Demand Factor and CALLS Factor applied) *Negative is reduction to Eligible Recovery Note: Copy the Study Area section down this worksheet for each Study Area in the Holding Company RCCMRSTRP-1 Page 3 of 5 Filing Date (enter w/leading '): 6/17/2013 RCCMRSTRP-2 Holding Company Filing Name: Summary Holding Company Total Change in Reveneue Total Change in Expense Total Eligible ARC/CAF Recovery -$ -$ -$ IntraMTA Reciprocal Compensation Revenues Eligible ARC/CAF Recovery FY 2011 Proposed Change in FY 2011 Proposed Change in Net Revenue Revenue Revenue Expense Expense Expense Change * A B C = B-A D E F = E - D G = F - C Study Area 1 - - - - - - - Study Area 2 - - - - - - - Study Area 3a - - - - - - - Study Area 4a - - - - - - - Total - - - - - - - All non-transit, intraMTA usage based rate elements All non-transit, intraMTA usage based rate elements RCCMRSTRP-2 Page 4 of 5 Filing Date (enter w/leading '): 6/17/2013 RCCMRSTRP-2 Holding Company Filing Name: Summary Holding Company Total Change in Reveneue Total Change in Expense Total Eligible ARC/CAF Recovery -$ -$ -$ IntraMTA Reciprocal Compensation Revenues *Negative is reduction to Eligible Recovery RCCMRSTRP-2 Page 5 of 5