Financial Health Assessment Worksheet™
Somerset Education · interactive companion — enter your own school's figures below
🔒 Nothing you enter on this page is sent to us, stored, or shared anywhere — every calculation happens right here on the page.
Students and Staff (FTE)
Enter
Primary students (Prep–Year 6)
Secondary students
Total student enrolments
–
Primary principal & teachers
Secondary principal & teachers
Non-teacher staff
Total staff (FTE)
–
Income
Total school income (excl. revaluations and boarding)
Boarding income (incl. profit from trading)
Total Income
–
Reduce by
Interest subsidies (Australian government funded)
Capital (non-recurrent) income
Total Recurrent Income excl. interest subsidies & capital income
–
Expenses
Total school expenses (excl. revaluations and boarding)
Total boarding expenses (incl. loss from trading)
Total expenses
–
Add back
Interest expense
Depreciation and Amortisation
Total Recurrent Expenses (excl. interest exp. & depn)
–
Revaluation / (Devaluation) enter devaluation as negative
Total Comprehensive Income
–
Earnings before interest, depreciation & amortisationEBIDA
–
Note: operating EBIDA includes interest and investment income.
Estimated cash from operations (incl. capital income)
–
Balance Sheet (extract)
Financial Loans
Right of Use Loans
Loans — closing balance
–
Repayment of loans principal during the year
Cash at bank
Capital expenditure
Are we Profitable?
Set targets appropriate to your own school's context — the Financial Survey for Schools (FSS) benchmarking data can help identify what's typical for schools like yours.
Result
Target
Net Operating Margin %
–
Info
Total Income per student (excl. boarding)
–
Info
Total Expenses per student (excl. boarding)
–
Info
Primary student / teacher
–
Info
Secondary student / teacher
–
Info
Student / non-teacher
–
Info
Student / All staff
–
Info
Are we Solvent?
Set targets appropriate to your own school's context — the Financial Survey for Schools (FSS) benchmarking data can help identify what's typical for schools like yours.
Result
Target
Months' expenditure in cash reserves
–
> 1.0
–
Are we Sustainable?
Set targets appropriate to your own school's context — the Financial Survey for Schools (FSS) benchmarking data can help identify what's typical for schools like yours.
Result
Target
Debt per Student
–
Info
Debt / EBIDA
–
< 4
–
Debt servicing cover
–
> 1.5
–
Depreciation Impact ratio
–
< 80%
–
Reinvestment / Depreciation
–
> 1.0
–
Help us develop these tools
If you have tried the R&D tools, we would value your feedback. Tell us what works, what doesn’t, and what would make these tools more useful for you and your school.