Faith Lutheran School Financial Model

Change weekly tuition, enrollment, staffing, payroll, and expense assumptions to see whether the school model balances.

Each classroom is calculated independently. Shared labor coverage, director cost, and other expenses are applied only in the total model.

This model uses weekly tuition and weekly payroll assumptions, converted to monthly using 4.33 weeks per month. This is a planning tool and not an accounting record. Settings files are saved locally on your computer and are not uploaded anywhere. When supported by your browser, Save Settings File lets you choose the folder and file name.

Total Enrollment

0

Monthly Tuition Revenue

$0

Monthly Payroll / Labor

$0

Monthly Other Expenses

$0

Monthly Surplus / Deficit

$0

Annual Surplus / Deficit

$0

Model Status

BALANCED BUDGET

Classroom Inputs

Tuition and payroll are weekly assumptions. Labor is wages only.

Classroom Enrolled Students Capacity Weekly Tuition Staff Count Hourly Rate Weekly Hours

Classroom Calculations

Classroom net is before shared labor coverage, director cost, and other expenses.

Classroom Monthly Tuition Income Base Classroom Labor Benefits/Payroll Tax Add-on Loaded Classroom Labor Classroom Net Before Shared Expenses

Floaters / Coverage

Reception / Admin Coverage

Director, Subs, and Admin

Benefits / Payroll Taxes

Labor Summary

Benefit-eligible labor base$0 Benefits + payroll tax add-on$0 Payroll-tax-only labor base$0 Payroll tax only add-on$0 Total labor$0

Expenses

Simple Expense Estimate

This estimates non-payroll expenses as a percentage of tuition revenue.

Planning note: this model uses weekly tuition and weekly payroll assumptions, converted to monthly using 4.33 weeks per month. This is a planning tool and not an accounting record.