# Start here: companion files of The Tutoring Center Owner (Julian R. Sterling)

Seven Excel files, each with three tabs: Inputs (blue cells, type your own values), Calc (formulas only) and Checks (each line reads 0 when the check passes; Checks!B2 adds them up).

- `Tutoring_1_Memberships.xlsx`: Workbook 1: Memberships, Hour Levels and Churn. From the members active at the start of a month and the new enrollments to the members billed and leaving, and from the hours scheduled to the hours cancelled, made up, delivered and expired, with the month's membership revenue. Filled with site 1 of Lantermoor in October 2025.
- `Tutoring_2_Tutor_Month.xlsx`: Workbook 2: A Tutor's Month: Pay, Utilization and Margin per Session Hour. From a tutor's wage and hours worked (shift, meetings, school hours, travel, course hours) to the pay, utilization, revenue of the sessions, contribution margin and margin per session hour. Filled with Jasper Quenell in October 2025, with the school contract and his travel.
- `Tutoring_3_Break_Even.xlsx`: Workbook 3: Pricing, Utilization and Break-Even. From students, prices and hours by offer, cancellations, tutor pay and the non-billable share to the session hours, the margin per session hour, utilization and the break-even in session hours a week and in students. Filled with the solo first year, a scenario.
- `Tutoring_4_Prepaid_Hours.xlsx`: Workbook 4: Prepaid Packages and the Money Owed to Families. From the package hours owed at the start of a month, refunds, new and renewal packages and the draw to the hours delivered and still owed, in hours and in dollars. Filled with site 1 of Lantermoor in September 2025.
- `Tutoring_5_Second_Center.xlsx`: Workbook 5: Second Center and SBA Loan. From the loan's amount, rate and term to the payment, the first eight payments and the balance, and from the investment to the site's payback. Filled with site 2 of Lantermoor, loan disbursed in June 2026.
- `Tutoring_6_Value.xlsx`: Workbook 6: SDE, Adjusted EBITDA and Cash at Closing. From EBITDA to SDE and adjusted EBITDA, from the multiple to the enterprise value, and from the enterprise value to the cash at closing after debt, money owed to families, fees and escrow. Filled with the group's offer, a scenario read in November 2026.
- `Tutoring_Center_Calculator.xlsx`: Tutoring Center Pricing, Tutor Utilization and Break-Even Calculator, the free calculator, filled with example values that are not the case of the book.

The values typed in the files are the book's fictional case and scenarios: teaching assumptions, not market figures. Change one input at a time and read the result again. Rely on nothing while Checks!B2 is above zero.
