Local Control Funding Formula Resources

The LCFF Calculator has been produced to the best of our ability based on the information that is currently available to our development working group, FCMAT and our colleagues in the California Department of Education. While the state transitions to the Local Control Funding Formula, it is likely that there will be additional changes in policy and in the fiscal application of the law that will affect the function of the Calculator. This, in turn, will impact budget development and fiscal projections at districts and charter schools. As those changes become available, FCMAT will revise the Calculator and provide the field with update notification using the new LCFF Listserve.

The LCFF Calculator, Calculator Caveats, LCFF Listserve Subscription, LCFF Online Help Desk, and CALPADS Reports & LCFF Self-paced Training links are accessible below. The Calculator Caveats link provides access to “Calculator Caveats,” an attempt to identify known issues, assumptions and unique situations that are common to this version of the LCFF Calculator, which have been updated to reflect current conditions. Please consider the information contained in this document when using the LCFF Calculator. The LCFF Listserve link provides access to our Listserve subscription page where three new Listserve mailing lists have been created. Each of these new Listserve mailing lists has been created to support dialog focused on matters specifically related to the Local Control Funding Formula and the unique application to school district, dependent charter school, independent charter school, and county office of education calculations. The LCFF Online Help link provides access to FCMAT’s free online help desk, created to assist in providing committed support to users related to questions pertaining to the Local Control Funding Formula. The CALPADS Reports & LCFF Self-paced Training link provides users guidance on CALPADS reporting data used in the Local Control Funding Formula.

Thank you to the Business and Administration Steering Committees (BASC), the External Services Subcommittee of the BASC (ESSCO), the Calculator Working Group, the Marin County Office of Education, the California Department of Finance, and the administration and staff of the California Department of Education for their support and work in the development of the LCFF Calculator.

The LCFF Calculator has been optimized for use with Microsoft Excel versions 2007 and later. If you are using an earlier version of Excel you must first download and install the appropriate updates from Microsoft in order to open, edit and save the calculations. This link http://support.microsoft.com/kb/924074 will provide you or your IT staff with the information needed to install these updates.

Version 20.1 of the LCFF calculator is now available for download.

v20.1b
May 14, 2019

  • Corrected gradespans 4-6 and 7-8 for the new ‘Base, Supplemental and Concentration Rate per ADA’ subtotal on Assumptions tab
  • Corrected prior year/current year ADA determination error for Necessary Small Schools, fiscal year 2017-18 only.
Local Control Funding Formula (LCFF) Calculator

LCFF Calculator

CALPADS Data Reporting
PRIOR Version 20 HISTORY

v20.1a
May 10, 2019

  • Updated 2016-17 ANR1, 2017-18 AN and 2018-19 P1 PASE data from CDE
  • Updated prefilled assumptions (May Revise):
    19-20 20-21 21-22
    Statutory COLA 3.26% 3.00% 2.80%
  • New ‘Base, Supplemental and Concentration Rate per ADA’ subtotal on Assumptions
  • Corrected prior year/current year ADA determination error for Necessary Small Schools, fiscal year 2017-18 only.