Students on each offer, prices and hours, cancellations, tutor pay and the paid hours outside sessions, fixed costs. The margin per session hour, utilization and the break-even in session hours a week, every step shown.
A center with 40 members, 12 students on prepaid packages and 10 in small-group courses delivers 382.4 session hours a month and brings in $24,784. Its tutors are paid for 490.26 hours, so utilization is 78 percent, and each session hour leaves $28.82 after tutor pay, fees and course materials. Against $9,800 of fixed costs a month, that is $1,221.97 of margin a month, just above a break-even of 85 session hours a week. The calculator lays it out, ready for your own figures.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Tutoring_Center_Calculator.xlsx (8 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This calculator uses the same cells as Workbook 3 of The Tutoring Center Owner, which follows one tutoring center through two fiscal years: hours at five levels, memberships, prepaid packages and courses, tutor pay and utilization, online contractors, a school contract, 529 payments, a second site and its loan, and what the center is worth.
Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.
| Measure | Example |
|---|---|
| Students | 62 |
| Session hours delivered a month | 382.4 |
| Revenue a month | $24,784 |
| Paid tutor hours a month | 490.26 |
| Tutor utilization (session hours / paid hours) | 78 percent |
| Tutor pay a month, taxes included | $12,942.86 |
| Card and bank fees a month | $669.17 |
| Course materials a month | $150 |
| Contribution margin a month | $11,021.97 |
| Margin per session hour | $28.82 |
| Margin a month after fixed costs | $1,221.97 |
| Break-even, session hours a week | 85 |
| Break-even, students at this mix | 55.1 |
| Revenue owed to families for 180 prepaid hours | $11,160 |
The example center is fictional and separate from the book's case: 40 members at $440.00 a month for 8 hours; 12 students on packages at $62.00 an hour, using 6 hours a month; 10 course students at $34.00 a student hour, 8 hours a month, in groups of 5, with $15.00 of course materials a student a month (the $30 of a two-month course, spread over its two months); 8 percent of membership hours cancelled and not made up; tutors at $24.00 an hour plus 10 percent payroll taxes, with 22 percent of paid hours outside sessions; fees of 2.70 percent; $9,800.00 of fixed costs a month; 48 weeks open a year; 180 prepaid hours still owed. Every input is a teaching assumption.
Education only, not legal, tax or financial advice: your own price list and books govern, and your advisers decide.
From the students on each offer (membership, prepaid package, small-group course), their prices and hours, the share of membership hours cancelled and not made up, tutor pay, payroll taxes, the share of paid hours outside sessions, fees, course materials and fixed costs, it computes the session hours delivered, revenue, utilization, the margin per session hour, the margin a month after fixed costs, the break-even in session hours a week and in students, and the revenue owed to families for prepaid hours.
The book's one definition: the session hours a week at which the margin per session hour (contribution margin, that is revenue minus tutor pay, card and bank fees and course materials, divided by session hours delivered) covers the month's fixed costs (owner's pay, staff, fixed lines such as rent, and background checks), divided by the open weeks of the month. It is a break-even of EBITDA, not of cash: loan payments are not in it. If the margin per session hour is zero or negative, it reads not reached.
Online sessions and contractors, a school contract, churn and enrollment month by month, refunds, a second site and its loan. The book's six workbooks cover them on one center.
Use it for a first pass and to learn the mechanics. Your prices come from your own price list and your costs from your own books, and the conclusions belong to you and your advisers.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The six free workbooks of The Tutoring Center Owner go further: memberships, hour levels and churn; a tutor's month with meetings, school hours and travel; prepaid packages and the money owed to families; a second center and its SBA loan; SDE, adjusted EBITDA and cash at closing.