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 17.2b of the LCFF calculator has been updated with the assumptions from the Governor’s Proposed Budget and for the extension of EPA from Prop 55.

The next major update is estimated to be released Monday, April 3rd and will include updated CDE certifications and the addition of fiscal year 2021-22.

v17.2b January 11, 2017

  • Updated Assumptions (Governor’s Budget Proposal, Prop 55):
    16-17 17-18 18-19 19-20 20-21
    COLA 0.00% 1.48% 2.40% 2.53% 2.66%
    Gap Funding 55.28% 23.67% 53.85% 68.94% 100%
    EPA %, Prop 55 25.00% 23.00% 21.00% 21.00% 21.00%

v17.2b July 8, 2016

  • Corrected Calculator tab for LEAs that receive economic recovery target (ERT) funding.

v17.2a June 30, 2016

  • Updated Assumptions tab for the State Budget:
    16-17 17-18 18-19 19-20
    Gap Funding 54.18% 72.99% 40.36% 73.98%
  • Updated prefilled data for CDE June 2016 exhibits for 2013-14 (AN R3, final certification), 2014-15 (AN R1) and 2015-16 (P-2)
  • Updated the 2015-16 EPA rate (25.71753613%) and updated the EPA tab for the 2015-16 4th quarter certification (final certification)
  • Corrected an error that prevented 2016-17 newly operational charter schools from creating an LCFF revenue budget estimate
  • Corrected the transitional fair share reduction to limit by 2012-13 categorical awards (affected v17.1 only)
  • Corrected the hypothetical full implementation MPP calculation on the graphs tab for basic aid districts (line 90)
Local Control Funding Formula (LCFF) Calculator

LCFF Calculator v17.2b

Calculator Caveats v17.1


v17.1b May 13, 2016

  • Updated Assumptions tab for Governor’s May Revision:
    15-16 16-17 17-18 18-19 19-20
    COLA 1.02% 0.00% 1.11% 2.42% 2.67%
    Gap Funding 52.20% 54.84% 73.96% 41.22% 75.16%
  • Added an ADA-to-enrollment ratio line on District and Charter MYP Data tabs
  • Corrected school district ADA calculation for 2020-21 on District MYP Data tab
  • Corrected the 2012-13 Charter School Block Grant Awards reference on Awards tab
  • Corrected the NSS High School funding table reference for 4 FTE and less on District NSS tab.

v17.1a May 6, 2016

  • Addition of the 8th transition year, 2020-21
  • Updated certifications for 2013-14, 2014-15, 2015-16
  • Improved EPA calculation and display
  • New chart and graph displaying base vs. supplemental/concentration funding