Fiscal Tools

Local Control Funding Formula Resources

Summary of significant changes:

  • Establishment of an eight-year fixed structure that includes three historical years, current budget year and four projection years.
  • Simplified data entry tab for all projection types.
  • Simplified navigation, including conditional formatting based on each LEA projection type and conditions specific to the LEA, that identifies fields that required user data entry.
  • Removal of all historical elements supporting transition calculations.
21-22 22-23 23-24 24-25
LCFF Funded COLA 5.07% 2.48% 3.11% 3.54%
Statutory COLA 1.70% 2.48% 3.11% 3.54%
2020-21 COLA 2.31% + 1% super COLA (compounded) 3.366% - - -

For additional assumption details, please see the detailed version section below.



The LCFF Calculator has been produced based on information currently available to the development working group, FCMAT, and our colleagues in the California Department of Education. 

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

The Online Help Desk is intended to provide users with direct support for questions pertaining to the Local Control Funding Formula and and the LCFF Calculator. 

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

FCMAT extends great appreciation to each member of the LCFF development team for their contributions and commitment to ensuring the quality of this tool. This includes 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 California Department of Education for their continued support and collaborative partnership in the development of the LCFF Calculator.

 

FAQs

Click an FAQ to open the container and view the answer.

Additional Resources


California Department of Education (CDE)
The state agency responsible for allocating LCFF funding.

Current Version:

Newly Redesigned LCFF Calculator

Version v22.1b:  Release date: May 19, 2021

This version of the new LCFF Calculator contains minor corrections as follows:

  1. Data Entry tab correction: Corrected the formulas in Column I rows 91 & 99, which were summing rows 87-89 adn 95-98 as opposed to adding their totals together. This impacted the 2020-21 UPP.
  2. Calculator tab correction: Corrected the formulas beginning in FY 2024-25 in rows 8-11 (grade span adjustment, Supplemental and Concentration rates, and fixed the link to column G in the Summary tab for each variable. 2026-27 was fixed to column H. These were fixed to follow their appropriate fiscal years.


Prior Versions:

Version v22.1a:  Release date: May 19, 2021

This version of the new LCFF Calculator contains minor corrections as follows:

  1. Calculator tab correction: Row 5 COLA reference data - this change has no impact on calculations.
  2. Calculator tab correction: Cell AU 13 formula reference error, this change only impacts fiscal year 2024-25 calculations for districts with Necessary Small Schools.
  3. Summary tab correction: Row 55 Base Grant formula for the LCAP percentage corrected to eliminate TIIG and transportation add-ons, this change impacts all calculations.

Version v22.1:  Release date: May 17, 2021

Prepopulated Data:  CDE Certified Data 2020-21 First Qtr. (2020-21 P1, 2019-20 AN, 2018-19 AN R2)

21-22 22-23 23-24 24-25
LCFF Funded COLA 5.07% 2.48% 3.11% 3.54%
Statutory COLA 1.70% 2.48% 3.11% 3.54%
2020-21 COLA 2.31% + 1% super COLA (compounded) 3.366% - - -

The prepopulated assumptions for supplemental and concentration grant funding reflect the percentages as currently written into the Education Code. Users have been provided access to override the concentration grant funding percentage for the purpose of alternative projection modeling.