Fiscal Tools

Local Control Funding Formula Resources


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:

Version v22.2b:  Release date: November 4, 2021

Version 22.2b of the Local Control Funding Formula (LCFF) Calculator is now available for download.

This version of the LCFF Calculator contains updates as follows:

  1. Corrected formula in cell AV13 on the Calculator tab: formula reference in grade span adjustment funding calculation was pointing to the incorrect fiscal year column on the summary tab. Potential affected grade span adjustment funding calculation for districts with necessary small schools in fiscal year 2024-25. All other fiscal year calculations were and remain correct.

Prior Versions:

Version v22.2a:  Release date: August 23, 2021

Version 22.2a of the Local Control Funding Formula (LCFF) Calculator is now available for download.

This version of the LCFF Calculator contains updates as follows:

  1. Data Entry Tab: Unlocked 2021-22 COLA assumptions so users may run alternative scenarios to calculate the value of COLA. Locked charter shift data entry cells for FY 2021-22; language suspended in AB 130. Added more detail on row 116 regarding basic aid ADA funded outside the LCFF for greater clarity. Unlocked the concentration grant rate assumption line so users may run calculations using the 50% and 65% to calculate the 15% increase that must be tracked separately. Moved 1.0% mega COLA to the augmentation assumption line so the current year COLA of 1.7% stands alone.
  2. District In-Lieu Taxes Tab: Corrected formula in cell I14 (2020-21 in-lieu taxes) which was referencing Data Entry tab cell J206 (2021-22) as opposed to I206 (2020-21).
  3. Summary Tab: Corrected formula error on row 46 - EPA, Prior Year Adjustment (Object Code 8019) (P-A less Prior Year Accrual); was bringing in an external link.


Version v22.2:  Release date: July 13, 2021

Version 22.2 of the Local Control Funding Formula (LCFF) Calculator is now available for download.

This version of the LCFF Calculator contains updates as follows:

  1. Prepopulated Data: CDE Certified Data as of 2020-21 third quarter released June 18, 2021, including 2020-21 (P2), 2019-20 (AN R1) and 2018-19 (AN R3).
  2. Revised Concentration Grant funding rate from 50% to 65% ongoing.
  3. Confirmed COLA and Augmentation per DOF - no revisions necessary.
  4. 2020-21 EPA entitlement as a percentage of statewide adjusted revenue limit as of P2: 70.06785065%.

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% - - -


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

This version of the LCFF Calculator contains corrections as follows:

  1. Data Entry tab correction: Section 3(d) (Rows 91 and 99 Column I (2020-21)) - corrected formula from a sum of rows 87-90 to a a sum of only rows 87 and 90. This change impacts the Unduplicated Pupil Percentages for all school district calculations.
  2. Calculator tab correction: Rows 9-11, Grade Span Adjustment, Supplemental and Concentration Grant rates for fiscal years 2024-25 through 2026-27, corrected to draw the funding rates for the correct fiscal years from the Summary tab. This change impacts all LCFF calculations.


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.