TN Comptroller BEP Calculator

Calculator Inputs

Enter district values, BEP weights, local capacity, and adjustment amounts.

District Name

Fiscal Year Or Scenario

Average Daily Membership

Base Per Pupil Amount

Instructional Weight

Classroom Weight

Support Weight

Special Education Count

Special Education Weight

English Learner Count

English Learner Weight

Economically Disadvantaged Count

Economic Need Weight

Career Technical Count

Career Technical Weight

State Participation Percent

Local Match Percent

Fiscal Capacity Index

Growth Adjustment

Hold Harmless Amount

Other Adjustments

Reset

Formula Used

Core Weighted Enrollment = ADM × (Instructional Weight + Classroom Weight + Support Weight)

Supplemental Weighted Enrollment = Sum of each special count × its assigned weight

Total Weighted Enrollment = ADM + Core Weighted Enrollment + Supplemental Weighted Enrollment

Gross BEP Need = Total Weighted Enrollment × Base Per Pupil Amount

Adjusted Local Factor = Local Match Percent × Fiscal Capacity Index

Estimated Local Share = Gross BEP Need × Adjusted Local Factor

Estimated State Support = (Gross BEP Need − Estimated Local Share) × State Participation Percent

Final Estimated Allocation = Estimated State Support + Growth Adjustment + Hold Harmless + Other Adjustments

This is a planning model. It is not an official state award calculation.

How To Use This Calculator

Enter the district name and fiscal year or scenario label.
Add ADM, base per pupil amount, and each BEP component weight.
Enter special student counts and their matching weight factors.
Add state participation, local match, and fiscal capacity values.
Include growth, hold harmless, or other adjustments.
Submit the form to show the result above the inputs.
Use CSV or PDF download buttons to save the estimate.

Example Data Table

Scenario	ADM	Base Per Pupil	Fiscal Capacity	State Percent	Growth Adjustment
Stable Enrollment	8,250	$7,100	0.92	70%	$80,000
Moderate Growth	12,500	$7,350	1.00	70%	$225,000
High Need Review	16,900	$7,600	0.78	72%	$410,000

Advanced BEP Planning Context

The Basic Education Program has been used as a detailed way to estimate classroom, instructional, and support funding needs for Tennessee school systems. A local budget team often needs a working model before reviewing state files. This calculator helps organize the inputs that drive a planning estimate. It is not an official award notice. It lets users enter enrollment, component weights, fiscal capacity, local effort, and adjustments in one place.

Why The Estimate Matters

District finance staff must explain how changes in enrollment or student needs can affect expected support. A small shift in average daily membership can change the base calculation. Extra weights for special education, English learners, economic disadvantage, or career technical programs can also move the final number. The tool separates those pieces so the user can see the effect of each group.

How Fiscal Capacity Fits

Fiscal capacity is a planning measure for local ability to fund education. In this page, it is entered as an index. A higher index increases the estimated local responsibility. A lower index increases the estimated state responsibility. The model also includes a local match percentage, because many reviews compare statutory shares with actual local budget choices.

Using The Results

The result card shows weighted enrollment, gross need, estimated state support, estimated local share, adjustments, and final allocation. The CSV export helps move values into a workbook. The PDF export creates a short report for meetings. Both exports use the same submitted inputs, so the numbers match the screen.

Planning Limits

BEP calculations can depend on fiscal year rules, component schedules, county splits, salary data, insurance assumptions, and final state adjustments. For that reason, this calculator should be treated as a review aid. Enter values from the fiscal year that you are studying. Compare the output with official district files before making decisions. When a rule changes, update the weights and percentages before running a new estimate.

Good Review Practice

Use conservative assumptions when final file is not ready. Keep a note beside every rate source. Save one export for each scenario. Then compare low, expected, and high enrollment cases. This habit helps boards understand risk. It also keeps budget conversations focused on numbers instead of memory.

FAQs

Is this an official TN Comptroller calculator?

No. This is a planning tool for local review. Always compare results with official state files before making budget decisions.

What does BEP mean?

BEP means Basic Education Program. It refers to a detailed school funding calculation used for Tennessee education finance reviews.

How should I enter fiscal capacity?

Enter it as an index. Use 1.00 for neutral capacity, below 1.00 for lower capacity, and above 1.00 for higher capacity.

Can I change the weights?

Yes. Every weight field is editable. Use values from the fiscal year, scenario, or local model you are studying.

Why does local share change?

Local share changes when gross need, local match percent, or fiscal capacity changes. The calculator combines those values.

What are other adjustments?

Other adjustments can include manual corrections, scenario changes, estimated reductions, or extra planning amounts not covered elsewhere.

Can I export the result?

Yes. After submitting the form, use the CSV or PDF buttons shown in the result section.

Should I use current fiscal year data?

Use the fiscal year data that matches your review. Old ratios can produce misleading estimates for current planning.