Filing Date:  
Filing Entity: 
Transmittal Number:
COSA:
TY 2017-2018 Special Access Revenue Requirement Before CBOL Adjustment (based on CY 2015 and 2016 data) @ 10.75% RoR and 2017 FIT rate
TY 2017-2018 Special Access Revenue Requirement Before CBOL Adjustment (based on CY 2015 and 2016 data) @ 10.5% RoR and 2018 FIT rate
 Adjustment Factor
TY 2017-2018 Revenue Requirement Moved from Special Access to CBOL  (based on CY 2015 and 2016 data) @10.75% RoR and 2017 FIT rate
TY 2017-2018 Revenue Requirement Moved from Special Access to CBOL  (based on CY 2015 and 2016 data) @10.5% RoR and 2018 FIT rate
TY 2017-2018 Special Access Revenue Requirement After CBOL Adjustment (based on CY 2015 and 2016 data) @ 10.5% RoR and 2018 tax rate
CAF-BLS (net amount after budget constraint is applied) or "ACAM"
TY 2018-2019 Projected Number of CBOL Lines (CAF-BLS recipients only)
CY 2015 and 2016 Number of Broadband-Only Lines (CAF-BLS recipients only)
Maximum CBOL Rate 
Tariffed CBOL Rate
Note 1.  Enter in cell C9 of this worksheet the amount that is in cell C12, worksheet 61.39 SA RR Adjustment for CBOL, workbook 2017 61.39 ILEC special access reallocation.
Note 2.  Enter in cell C10 of this worksheet the amount that is in cell C13, worksheet 61.39 SA RR Adjustment for CBOLworkbook 2017 61.39 ILEC special access reallocation.
Note 3:  Enter in cell C17 of this worksheet the amount of CAF-BLS (the net amount after the budget constraint is applied) attributable to CBOL lines that the ILEC expects to receive this tariff year, or "ACAM" if the ILEC receives model-based support.
Note 4:  Enter in cell C18 of this worksheet one-twelfth (1/12) of the number that is in cell AG12, worksheet ExchangeLevel ARC, workbook 2018 Tariff Rate Comp CAF RoR ILEC or Tariff Rate Comp No CAF RoR ILEC (CAF-BLS recipients only).
Note 5.  Enter in cell C19 of this worksheet the number that is in cell C9, worksheet 61.39 SA RR Adjustment for CBOL, workbook 2017 61.39 ILEC special access reallocation (CAF-BLS recipients only).
Input (Note 1)
Input
C10/C9 #DIV/0!
Input (Note 2)
C11*C13 #DIV/0!
C10-C14 #DIV/0!
Input (Note 3)
Input (Note 4)
Input (Note 5)
42 or (C14-(C17/C18)*C19)/12/C19 #DIV/0!
Input
Note 1.  Enter in cell C9 of this worksheet the amount that is in cell C12, worksheet 61.39 SA RR Adjustment for CBOL, workbook 2017 61.39 ILEC special access reallocation.
Note 2.  Enter in cell C10 of this worksheet the amount that is in cell C13, worksheet 61.39 SA RR Adjustment for CBOLworkbook 2017 61.39 ILEC special access reallocation.
Note 3:  Enter in cell C17 of this worksheet the amount of CAF-BLS (the net amount after the budget constraint is applied) attributable to CBOL lines that the ILEC expects to receive this tariff year, or "ACAM" if the ILEC receives model-based support.
Note 4:  Enter in cell C18 of this worksheet one-twelfth (1/12) of the number that is in cell AG12, worksheet ExchangeLevel ARC, workbook 2018 Tariff Rate Comp CAF RoR ILEC or Tariff Rate Comp No CAF RoR ILEC (CAF-BLS recipients only).
Note 5.  Enter in cell C19 of this worksheet the number that is in cell C9, worksheet 61.39 SA RR Adjustment for CBOL, workbook 2017 61.39 ILEC special access reallocation (CAF-BLS recipients only).