Local Control Funding Formula Resources

Version 22.1b of the newly designed Local Control Funding Formula (LCFF) Calculator is now available for download.
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.

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.

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.