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.
NOTE: 18.2 with the June PASE exhibits is scheduled to be released late July/early August. Until then, you may continue to use Version 18.1b and manually override any applicable changes per the new certifications.
v18.1b May 22, 2017
- Corrected ‘District MYP Data’ ADA guarantee for school districts that experienced no ADA growth or loss, but shifted ADA between grade spans. Previous version completed the ADA guarantee with the prior year grade span data.
- Corrected ‘LCAP’ supplemental & concentration grant allocation calculation in initial year for reorganized school district or newly operational charter school. Previous version allocated target level supplemental & concentration funding in initial year when $0 prior year expenditures was entered.
- Added target component detail to ‘Summary’ tab.
PRIOR VERSION 18 HISTORY
v18.1a May 14, 2017
- Updated CDE PASE exhibit certifications and added additional fiscal years to create multi-year projections.
- Updated Assumptions (Governor’s May Revision):
16-17 17-18 18-19 19-20 20-21 COLA 0.00% 1.56% 2.15% 2.35% 2.57% Gap Funding 55.03% 43.97% 71.53% 73.51% 100% EPA %, Prop 55 25.40% 23.70% 22.70% 22.70% 22.70%