Filing Date (enter w/leading '): 6/16/2015 RCCMRSTRP-1 Holding Company KEY (Erase text & color before filing): Filing Name: Label / Date Change Formula changes / mandated by FCC rules Holding Company Summary Holding Company Plan Year 4 2015 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 4 2015 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 4 - July 1, 2015 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 2015 Plan Yr 4 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = EO: IF C<.0007 + (G - $0007)/3 then C else .0007 +- (G - $0007)/3; Tandem: Min(C,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 4 2015 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 4 - July 1, 2015 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 2015 Plan Yr 4 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = EO: IF C<.0007 + (G - $0007)/3 then C else .0007 +- (G - $0007)/3; Tandem: Min(C,G) I = B * H J = I - A End Office Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Tandem Switching Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Common/Shared Transport Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Special Arrangement Dedicated Transport -$ - -$ -$ - -$ -$ -$ -$ -$ Recip Comp Interstate Plan Impact Recip Comp Interstate Plan Impact RCCMRSTRP-1 Page 1 of 5 Filing Date (enter w/leading '): 6/16/2015 RCCMRSTRP-1 Holding Company KEY (Erase text & color before filing): Filing Name: Label / Date Change Formula changes / mandated by FCC rules Holding Company Summary Holding Company Plan Year 4 2015 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 Other Element -$ -$ -$ -$ -$ Total -$ -$ -$ -$ Study Area 3 Summary Study Area 3 Plan Year 4 2015 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 4 - July 1, 2015 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 2015 Plan Yr 4 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = EO: IF C<.0007 + (G - $0007)/3 then C else .0007 +- (G - $0007)/3; Tandem: Min(C,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 4 2015 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 4 - July 1, 2015 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 2015 Plan Yr 4 Rate Revenue Price Out Revenue Change A B C = A / B D E F = D / E G = F H = EO: IF C<.0007 + (G - $0007)/3 then C else .0007 +- (G - $0007)/3; Tandem: Min(C,G) I = B * H J = I - A End Office Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Tandem Switching Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Recip Comp Interstate Plan Impact Recip Comp Interstate Plan Impact RCCMRSTRP-1 Page 2 of 5 Filing Date (enter w/leading '): 6/16/2015 RCCMRSTRP-1 Holding Company KEY (Erase text & color before filing): Filing Name: Label / Date Change Formula changes / mandated by FCC rules Holding Company Summary Holding Company Plan Year 4 2015 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 Common/Shared Transport Revenue -$ - -$ -$ - -$ -$ -$ -$ -$ Special Arrangement Dedicated Transport -$ - -$ -$ - -$ -$ -$ -$ -$ Other Element -$ -$ -$ -$ -$ Total -$ -$ -$ -$ RCCMRSTRP-1 Page 3 of 5 Filing Date (enter w/leading '): 6/16/2015 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/16/2015 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