Excel financial planning template for tutoring center. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Online five-year scenario and monthly operating sensitivity
Excel template sold separately; review the selected file specification
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01RevenueThe inspected Revenue screen uses available group places, occupancy and a monthly fee. This center sells enrolled student places; learner-hours provide an external capacity bridge.Explore layout ↓
02COGS & OPEXThe product page identifies direct and operating costs. The online case separates payment/materials cost from the committed center overhead.Explore layout ↓
03PayrollA Payroll tab is visible in the inspected product screen. The online illustration includes all paid tutor time, owner management and a substitute provision.Explore layout ↓
04CAPEX and CapitalInvestment and Capital tabs are visible. The online allocation keeps setup, deposits, contingency and operating reserve separate.Explore layout ↓
05IS, CF and BSThe page describes financial statements and the inspected screen shows their tabs. StartFigures supplies a separate operating scenario for the web illustrations.Explore layout ↓
06Scenarios and DashboardScenario and Dashboard reports appear on the product page. The online checks compare enrollment, tuition, seasonal withdrawal and cash needs.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Tutoring CenterHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$204,120
$302,400
$302,400
Payment fees and learner materials
$10,206
$15,120
$15,120
Tutors, paid owner and cover
$196,200
$196,200
$196,200
Premises and center overhead
$66,000
$66,000
$66,000
EBITDA
−$68,286
$25,080
$25,080
EBITDA margin
-33.5%
8.3%
8.3%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01RevenueOperating assumptions
Revenue
Scenario purpose: The inspected Revenue screen uses available group places, occupancy and a monthly fee. This center sells enrolled student places; learner-hours provide an external capacity bridge.
Inputs
Available enrolled places by subject and compatible group
Monthly occupied-place path and realized tuition
Two hours of weekly entitlement per enrolled learner
Opening calendar and separately tested summer withdrawals
Additional revenue per occupied place set to zero
Outputs
Occupied-place tuition revenue
Room, tutor and learner-hour reconciliation
Capacity constraints before growth
Scope and limitations
The paid workbook and cell formulas were not inspected; visible inputs do not verify monthly allocation or billable-day treatment.
An empty chair at an unsuitable grade, subject or requested time is not a saleable compatible place.
The seller's gallery example values and extra-income inputs are not used as this center's revenue assumptions.
02COGS & OPEXOperating assumptions
COGS & OPEX
Scenario purpose: The product page identifies direct and operating costs. The online case separates payment/materials cost from the committed center overhead.
Inputs
Selected payment-and-materials share
Base rent, property charges and utilities
Insurance, systems, marketing, cleaning, upkeep and professional services
Outputs
Learner-hour contribution
Recurring premises and administration budget
Cost allocation without repeated tutor pay
Scope and limitations
The payment share is simplified; actual payment and billing terms need a separate quote.
Scheduled tutor compensation belongs in payroll even when groups are empty.
A public cost screen does not verify delivered-file formulas or local supplier terms.
03PayrollOperating assumptions
Payroll
Scenario purpose: A Payroll tab is visible in the inspected product screen. The online illustration includes all paid tutor time, owner management and a substitute provision.
Inputs
Three tutor roles and contact/noncontact duty roster
Selected tutor hourly pay and 52 paid weeks
Paid owner-manager compensation
Employer-cost allowance and substitute hours
Outputs
Annual paid labor allowance
Contact-hour capacity and other paid time
Cover responsibilities and owner dependence
Scope and limitations
National occupation pay is context rather than an actual local hiring offer.
The selected employer allowance is not a prescribed payroll-tax rate.
A funded substitute provision does not demonstrate backup availability or owner-manager succession.
04CAPEX and CapitalOperating assumptions
CAPEX and Capital
Scenario purpose: Investment and Capital tabs are visible. The online allocation keeps setup, deposits, contingency and operating reserve separate.
Inputs
Fit-out and access bid
Complete furniture, technology and curriculum basket
Deposits and pre-opening commitments
Operating reserve and funding dates
Outputs
Opening use-of-funds allocation
Selected ramp and reserve bridge
Unspent operating cash after modeled losses
Scope and limitations
A supplier table range does not verify a complete installed classroom.
No premises purchase, landlord contribution or financing is assumed.
Do not add the same ramp loss to both the reserve and opening expense total.
05IS, CF and BSOperating assumptions
IS, CF and BS
Scenario purpose: The page describes financial statements and the inspected screen shows their tabs. StartFigures supplies a separate operating scenario for the web illustrations.
Inputs
Enrollment revenue, variable costs, payroll and overhead
Opening uses and funding dates
Earned tuition, receipts, refunds and outstanding service obligations
Outputs
Five-year operating forecast
Revenue and cost reconciliation
Inputs needed for dated cash-flow and balance-sheet work
Scope and limitations
Web EBITDA is before depreciation, interest and income tax; it is not owner take-home pay.
The case does not audit purchased statement formulas or create a complete balance sheet.
Prepaid tuition receipts and earned service revenue must not both be counted as sales.
06Scenarios and DashboardOperating assumptions
Scenarios and Dashboard
Scenario purpose: Scenario and Dashboard reports appear on the product page. The online checks compare enrollment, tuition, seasonal withdrawal and cash needs.
Inputs
Current enrollment and tuition
Lower fee or retained-place cases
Summer continuation and slower launch path
Unchanged capacity, paid roster and cost scope
Outputs
Operating threshold and feasible timetable
Selected adverse-case results
Reserve requirements within the inspected horizon
Scope and limitations
Scenarios are assumptions without assigned probabilities.
A larger opening reserve cannot repair persistent negative mature economics.
A public report description does not establish native sensitivity formulas, actual collections or investment returns.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
Use the Excel template to compare your financial assumptions. Review the selected version's input structure and outputs before adapting it. The online inputs and outputs on this page explain this website's price, volume, cost and opening-budget assumptions; they do not edit or verify a workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Neither template establishes local demand, licensing compliance, financing approval or available owner cash.
Tutoring Center input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Allocated tuition per learner-hour
$41.570438799076214
$34.642032332563510 – $48.498845265588910
Revenue per sold unit
Paid learner-hours per day, center-wide
28
18 – 36
Daily throughput in the stated operating scope
Operating days per week
5
4 – 5
Trading schedule
Fixed operating costs / month
$21,850
Held constant
Operating break-even threshold
Contribution margin
95.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
40.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
18
$16,200
$23,000
Not reached
Base volume
28
$25,200
$23,000
Month 12
Higher volume
36
$32,400
$23,000
Month 8
Only paid learner-hours per day, center-wide changes. Allocated tuition per learner-hour: $41.570438799076214; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$204.1k
Year 1
$302.4k
Year 2
$302.4k
Year 3
$333k
Year 4
$355.7k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Fit-out and accessibility allowance$30,000
Furniture and technology$15,000
Curriculum, security and setup$5,000
Premises deposits$10,000
Legal, permits and initial insurance$8,000
Pre-opening training and launch$8,000
Construction contingency$10,000
Operating cash reserve$80,000
One-time budget: $166,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $302,400.
Payment fees and learner materials$15,120
Tutors, paid owner and cover$196,200
Premises and center overhead$66,000
EBITDA$25,080
EBITDA margin: 8.3%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
26
Break-even revenue / month
$23,000
Base revenue / month at maturity
$25,200
First operating break-even
Month 12
Units mean paid learner-hours per day, center-wide. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$204,120
$204,120
Year 1 operating result
−$68,286
−$68,286
Year 2 revenue
$302,400
$302,400
Year 2 operating result
$25,080
$25,080
Year 3 revenue
$302,400
$302,400
Year 3 operating result
$25,080
$25,080
Year 3 / full-volume annual revenue
$302,400
$302,400
Year 3 / full-volume annual operating result
$25,080
$25,080
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your tutoring center together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Tutoring Center Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Revenue, COGS & OPEX, Payroll, CAPEX and Capital, IS, CF and BS, Scenarios and Dashboard using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review allocated tuition per learner-hour, paid learner-hours per day, center-wide, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
Do the web previews reproduce the purchased files?
The online outlines, tables and worksheet illustrations use this website's scenario. They are not screenshots, a verified page count or a confirmed worksheet inventory of the purchased files. Check the selected product's specification before buying.
How are the files delivered?
Review the selected item's delivery method and license in Shopify before paying. These pages do not document a completed purchase or download test.
