E-Rate Discount Calculations

The discount calculation section, formerly the “Block 4 worksheets,” of the online FCC Form 471 (or “Application”), seeks information from applicants on each of their entities (schools and/or libraries) to:

* Calculate the E-rate Program discount for a school district, a library system, or a consortium or statewide application.

* Calculate the Category Two budget for each individual entity that will have a budget for discounts on eligible Category Two services.

While this information may be entered directly into the online Application when the yearly FCC Form 471 window is open, applicants may also upload this information into the Application via an Excel file using USAC-provided discount calculation templates (different versions are provided for schools and libraries). These templates help applicants to compile discount calculation information and simplify the process of completing the discount calculation section of the FCC Form 471 by allowing applicants to prepare an Excel file for uploading in advance.

Please review the Discount Template Instructions before completing the Library Template.

E-Rate Form 471 Discount Template Instructions

E-Rate Form 471 Discount Calculations – Library Template