Fiscal Tools

Local Control Funding Formula Calculator for School Districts and Charter Schools

The Local Control Funding Formula (LCFF) determines how all local educational agencies (LEAS) are funded. The Local Control Funding Formula (LCFF) Calculator for school districts and charter schools has been produced based on information currently available to the development working group, FCMAT, and our colleagues in the California Department of Education (CDE).

The LCFF Calculator announcement email list is FCMAT's primary communication tool for sharing information about updates or other material revisions to the school district and charter school LCFF Calculator.

FCMAT’s online help desk is intended to provide users with direct support for questions pertaining to the LCFF Calculator and calculations for school districts and charter schools. For county office calculations, please visit the Local Control Funding Formula Resources for County Offices page.

Links to the CDE's Principal Apportionment and Special Education certified data exhibits and other resources provide users with convenient access to the supporting certified data. Users should independently verify prepopulated data in the school district and charter school LCFF Calculator from the Principal Apportionment Section certified data exhibits. If any inconsistencies are noted, please report them to the FCMAT help desk.

FCMAT extends great appreciation to each member of the school district and charter school LCFF Calculator development team for their contributions and commitment to ensuring the quality of this tool. This includes the administrative staff of the Marin and El Dorado county offices of education. Further appreciation is extended to numerous members and support staff of the Business and Administration Steering Committees (BASC), the External Services Subcommittee of the BASC, the California Department of Finance, and the administration and staff of the CDE for their continued support and collaborative partnership in the development of the LCFF Calculator for school districts and charter schools.

FAQs

Click a question to view the answer.

Can users obtain the password to unprotect the LCFF Calculator?

No. The LCFF Calculator is password-protected to secure the underlying formulas and to protect the integrity of the calculation performed. FCMAT is unable to disperse the password for support reasons. If you would like to suggest a change, please create a help desk ticket and attach a copy of the file demonstrating your request.

Is there a user guide for the LCFF Calculator?

No. Instructions are maintained in a separate tab within the LCFF Calculator.

When is the LCFF Calculator updated?

The LCFF Calculator is updated twice a year, once in the second quarter and once in the third quarter:

The second quarter version of the LCFF calculator is typically released in May following the release of the Governor's May Revision. This version updates the prepopulated data certified by the CDE for the first principal apportionment (P-1), annual principal apportionment (Annual), and annual principal apportionment revision 2 (Annual R2) certification data. This data is typically released by the CDE in late February each year.
The third quarter version of the LCFF Calculator is typically released in July and incorporates changes to assumptions based on the state enacted budget. This version updates the prepopulated data certified by the CDE for the second principal apportionment (P-2), annual principal apportionment revision 1 (Annual R1), and annual principal apportionment revision 3 (Annual R3) certification data. This data is typically released by the CDE in late June of each year.

Additional updates may occur if material errors are found within the tool. Updates will be posted on this page and material updates that affect many agencies will also be communicated through the LCFF Calculator announcement email list.

What if the prepopulated data does not match my records?

Most prepopulated historical data fields remain accessible for user edit. Users can easily override prepopulated data between certification cycles if revisions have been submitted. Users should be cautious when overriding prepopulated data because data that has been overridden cannot be restored.

Download School District and Charter School LCFF Calculator

Subscribe / Unsubscribe to Email List

Submit a Help Desk Request

Additional Resources

California Department of Education (CDE)

The state agency responsible for allocating LCFF funding.

Principal Apportionment Exhibits

Education Protection Account

Local Control Funding Formula Overview

Current Version

Version 25.2a: Release Date: August 16, 2024

This update is optional for LEAs. See the notes on updates below for potential impacts on LEAs.

Changes to calculations in this version of the School District and Charter School LCFF Calculator include the following:

EPA Tab

Updated cells K12-N12 for the years 2025-26, 2026-27, 2027-28, and 2028-29 to properly reference the COLA from the Data Entry tab for their respective years. The prior formula referenced the COLA rate for 2024-25 (cell J15 in the Data Entry tab).
This update only affects the estimated EPA calculations for the subsequent budget years 2025-26 to 2028-29. The total LCFF entitlement estimates for these years remain unchanged because EPA funding offsets other state aid received under the LCFF.

Prior Versions

Version 25.2: Release Date: July 29, 2024

This version includes updated certified data as of the 2023-24 second principal apportionment (P-2), the 2022-23 annual principal apportionment revision 1 (AN-R1), and the 2021-22 annual principal apportionment revision 3 (AN-R3).

FCMAT recommends that all LEAs use this current version.

Changes to calculations in this version of the School District and Charter School LCFF Calculator include the following:

Data Entry Tab – Universal Assumptions

Cost-of-living adjustments (COLAs) remain the same as provided by the Department of Finance as of May 2024.
The 2023-24 P-2 EPA rate is prepopulated with 21.98880689% as published by the CDE P-2 certification.

Graphs Tab

Added a new feature that provides detail on supplemental and concentration grants and rates (see cells A52 to I70).

Version 25.1a: Release Date: May 24, 2024

This update is optional for most LEAs but essential for some. See the note at the bottom of this entry regarding when it is essential for an LEA to use this update.

This version includes the following updates:

EPA Tab

Changed the formulas to calculate ADA for minimum EPA funding (row 7) for 2023-24, 2024-25 and 2025-26 columns. Removed duplication of district basic aid ADA funded outside of the LCFF (court-ordered, voluntary transfer, and open enrollment) in the EPA formula.

Data Entry Tab

Unlocked for editing the 2022-23 TK ADA entry fields for charters (cell H54) and school districts (cell H112).

Summary Tab

Changed the title and calculation of local revenue and in-lieu of property taxes (row 46) to the Funding Source Summary to include in-lieu of property taxes data for charter schools (informational display only).

Based on the changes listed above, it is essential for a district to use this updated version when either of the following apply:

School districts that report district basic aid ADA funded outside of the LCFF (court-ordered, voluntary transfer, and open enrollment).
School districts and charters that need to enter adjustments to the 2022-23 TK ADA.

Version 25.1: Release Date: May 15, 2024

This version includes updated certified data as of the 2023-24 first principal apportionment (P-1), the 2022-23 annual principal apportionment (AN), and the 2021-22 annual principal apportionment second revision (AN R-2), with minor corrections to formulas. The base year has transitioned to 2024-25, and the year 2028-29 has been added to the calculator. Although the 2021-22, 2022-23, and 2023-24 columns are “historical” years, they remain editable. LEAs can continue to use the 2023-24 column to calculate current year figures.

FCMAT recommends all LEAs use Version 25.1.

Universal Assumptions:

Cost-of-living adjustments (COLAs) provided by the Department of Finance as of May 2024 are as follows:

	24-25	25-26	26-27	27-28	28-29
Statutory COLA	1.07%	2.93%	3.08%	3.30%	3.29%

EPA rates are prepopulated with those published by the CDE for 2022-23 AN and include current estimates for 2023-24 as follows:

	22-23 AN	23-24 P-1
EPA Rate	12.84814107%	48.75954508%

Major Changes:

Summary Tab - LCAP Percentage to Increase or Improve Services Calculation

Added a new feature that projects an additional 15% in LCFF concentration grant funding. This amount can now be included in the LCAP's "Increased or Improved Services section" for LEAs that receive concentration grant funding.
Included TK add-on funding in the base grant formula to help calculate an LEA's minimum proportionality percentage.

Additional State Aid and Excess Tax Calculation Updates

Resolved questions from basic aid/community funded districts regarding the Calculator and Summary tabs by aligning the Additional State Aid (ASA) and Excess Tax calculations with the CDE's certified exhibits, which calculates Excess Taxes before ASA/MSA.
Provided flexibility in the Graphs tab for local calculation of excess taxes after ASA/MSA. LEAs can calculate starting on lines 74-81.