Free Excel templates

A free tutoring center break-even calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

Three tabs. Inputs are blue; everything else is a formula; the Checks tab adds up the controls that fail.

1. Inputs
Members, the membership fee and its hours; students on prepaid packages, the package price per hour and the hours used a month; students in small-group courses, the course price per student hour, the course hours a month and the students per group; the share of membership hours cancelled and not made up; tutor pay per paid hour, employer payroll taxes and the share of paid hours outside sessions; card and bank fees; course materials per course student a month; fixed costs a month (rent, staff, software, insurance, marketing, background checks, the owner's pay if salaried); weeks open a year; prepaid hours still owed.
2. Calc
Revenue and session hours by offer, paid tutor hours, utilization, tutor pay, fees and course materials, the contribution margin and the margin per session hour, the margin a month once fixed costs are paid, the break-even in session hours a week and in students, and the revenue owed to families.
3. Checks
Rates between 0 and 1, at least one student per group when courses run, paid hours that cover the session hours, the break-even reinjected to the cent, and prices, pay, course materials, fixed costs and owed hours that are not below zero.

What the worked example returns

MeasureExample
Students62
Session hours delivered a month382.4
Revenue a month$24,784
Paid tutor hours a month490.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 week85
Break-even, students at this mix55.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.

How to use it on your own center

  1. Enter students and hours as sold, not as delivered: the calculator applies your cancellation rate to the membership hours.
  2. Enter tutor pay per paid hour and the share of paid hours with no session in them: shifts not filled, meetings, training, travel.
  3. Put the owner's salary in the fixed costs if the owner is paid one, so the break-even does not treat her work as free.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

Education only, not legal, tax or financial advice: your own price list and books govern, and your advisers decide.

Questions people ask

What does the tutoring center calculator do?

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.

Which break-even does it compute?

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.

What does it leave out?

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.

Can I rely on it for a business plan?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading