Excel financial planning template for preschool. 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.
01Revenue and enrolled placesThe seller-described Revenue view uses group capacity, occupancy, monthly tuition and separate extra revenue per place. Adapt it to two ages 3–5 groups and a school-year schedule.Explore layout ↓
02Costs and operating expensesThe seller page describes direct, variable and fixed cost schedules. Keep child supplies and collection costs separate from year-round occupancy and administration.Explore layout ↓
03Payroll and staff coverageUse the staffing schedule to budget classroom roles, paid preparation and leave, director work and substitutes before interpreting surplus.Explore layout ↓
04Startup and fundingConnect premises work, furniture, outdoor access, permission and recruitment uses with available funding and a protected operating reserve.Explore layout ↓
05Scenarios and seasonal cash reviewThe seller page confirms low/base/high analysis. Use it to compare occupied places, tuition, costs and funding; separately check the actual ten-month collection and twelve-month contract calendars.Explore layout ↓
06Statements and dashboardThe seller page describes five-year monthly/annual reporting, income statement, cash flow, balance sheet, summary and dashboard views.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.
PreschoolHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$324,000
$432,000
$486,000
Snacks, learning consumables and collection costs
$25,920
$34,560
$38,880
Teachers, assistants, paid director and substitute cover
$260,400
$260,400
$260,400
Year-round rent, insurance, utilities and administration
$96,000
$96,000
$96,000
EBITDA
−$58,320
$41,040
$90,720
EBITDA margin
-18.0%
9.5%
18.7%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Revenue and enrolled placesOperating assumptions
Revenue and enrolled places
Scenario purpose: The seller-described Revenue view uses group capacity, occupancy, monthly tuition and separate extra revenue per place. Adapt it to two ages 3–5 groups and a school-year schedule.
Inputs
Places by group and approved age scope
Occupied-place path
Monthly tuition by group
Start date and active teaching months
Extra revenue per place, set to zero in this case
Outputs
Occupied places by group
Monthly and annual tuition
Revenue mix
Scope and limitations
Enrollment pays for a place and is not daily attendance.
The website daily equivalent does not substitute for the workbook's month/group drivers.
A licensed-capacity or school-year cash adapter was not verified in the native file.
02Costs and operating expensesOperating assumptions
Costs and operating expenses
Scenario purpose: The seller page describes direct, variable and fixed cost schedules. Keep child supplies and collection costs separate from year-round occupancy and administration.
Inputs
Child-linked consumables and collection fees
Lease and annual overhead
Expense start/end dates
Maintenance and reopening needs
Outputs
Direct costs
Fixed and variable operating expenses
Contribution and operating coverage
Scope and limitations
The assumed direct-cost percentage is not a quote and must be rebuilt from actual inclusions.
Meals, transport, extra care and subsidies need separately costed terms if introduced.
03Payroll and staff coverageOperating assumptions
Payroll and staff coverage
Scenario purpose: Use the staffing schedule to budget classroom roles, paid preparation and leave, director work and substitutes before interpreting surplus.
Inputs
Teacher and assistant rates
Paid hours and weeks
Annual contract payout calendar
Director compensation
Employer costs and substitute allowance
Outputs
Gross and burdened payroll
Monthly staff cost
Role-by-role operating budget
Scope and limitations
The online blended payroll preset covers classroom staff only.
Budgeted labor does not prove credentials, ratios or cover through every break and absence.
No automatic jurisdiction or room-ratio checker was verified in the purchased workbook.
04Startup and fundingOperating assumptions
Startup and funding
Scenario purpose: Connect premises work, furniture, outdoor access, permission and recruitment uses with available funding and a protected operating reserve.
Inputs
Opening uses and commitment dates
Landlord responsibilities and deposits
Reserve and contingency
Debt/equity terms
Working-capital policy
Outputs
Opening sources and uses
Financing need
Cash availability and modeled runway
Scope and limitations
The opening allocation is an assumption rather than a bid.
Do not count prepaid tuition or the same reserve twice; debt, tax and replacement cash need explicit timing.
05Scenarios and seasonal cash reviewOperating assumptions
Scenarios and seasonal cash review
Scenario purpose: The seller page confirms low/base/high analysis. Use it to compare occupied places, tuition, costs and funding; separately check the actual ten-month collection and twelve-month contract calendars.
Inputs
Low/base/high enrollment and fee cases
Refund and collection assumptions
Summer obligations
Staff and rent sensitivities
Outputs
Revenue and EBITDA scenario comparisons
Cash-flow scenarios
Seasonal funding questions
Scope and limitations
This online cash illustration is a StartFigures operating check, not a verified native tuition-deposit or closed-month checker.
A school-month surplus does not establish closed-month cash coverage or an unrestricted distribution.
06Statements and dashboardOperating assumptions
Statements and dashboard
Scenario purpose: The seller page describes five-year monthly/annual reporting, income statement, cash flow, balance sheet, summary and dashboard views.
Inputs
Selected operating scenario
Opening balances
Financing, taxes and asset assumptions
Tuition collection and recognition policy
Outputs
Income statement
Cash flow and balance sheet
Summary, dashboard and KPIs
Scope and limitations
Seller-described reports were checked on the page and gallery; native formulas and paid delivery were not inspected.
Statements inherit assumptions and do not certify family demand, program quality, permissions or profitability.
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.
Preschool input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Annual tuition per enrolled child / reference day
$51.963048
$38.491147 – $65.434950
Revenue per sold unit
Unique enrolled children in the program
36
18 – 40
Daily throughput in the stated operating scope
Operating days per week
5
5 – 5
Trading schedule
Fixed operating costs / month
$29,700
Held constant
Operating break-even threshold
Contribution margin
92.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
50.0%
Base ramp input
Opening month revenue
Mature volume added / month
2.8%
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
$20,250
$32,283
Not reached
Base volume
36
$40,500
$32,283
Month 12
Higher volume
40
$45,000
$32,283
Month 9
Only unique enrolled children in the program changes. Annual tuition per enrolled child / reference day: $51.963048; 5 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs. 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
$324k
Year 1
$432k
Year 2
$486k
Year 3
$528.2k
Year 4
$572k
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Lease deposits and preopening rent$18,000
Classroom, restroom and safety fit-out$70,000
Learning furniture and equipment$34,000
Outdoor play and access work$22,000
Licensing, legal and staff recruitment$15,000
Curriculum, security and software setup$10,000
Enrollment launch and family outreach$6,000
Operating cash reserve$105,000
One-time budget: $280,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $486,000.
Snacks, learning consumables and collection costs$38,880
Teachers, assistants, paid director and substitute cover$260,400
Year-round rent, insurance, utilities and administration$96,000
EBITDA$90,720
EBITDA margin: 18.7%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
29
Break-even revenue / month
$32,283
Base revenue / month at maturity
$40,500
First operating break-even
Month 12
Units mean unique enrolled children in the program. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs. 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
Annual revenue and EBITDA use the annual forecast. Break-even uses a separate monthly calculator sensitivity; it does not establish when the annual forecast covers its costs.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$324,000
$317,250
Year 1 operating result
−$58,320
−$64,530
Year 2 revenue
$432,000
$462,375
Year 2 operating result
$41,040
$68,985
Year 3 revenue
$486,000
$486,000
Year 3 operating result
$90,720
$90,720
Year 3 / full-volume annual revenue
$486,000
$486,000
Year 3 / full-volume annual operating result
$90,720
$90,720
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 preschool 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 Preschool 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 and enrolled places, Costs and operating expenses, Payroll and staff coverage, Startup and funding, Scenarios and seasonal cash review, Statements 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 annual tuition per enrolled child / reference day, unique enrolled children in the program, 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.
