Revenue & Calc
Set available places, paid occupancy, age shares, tuition, and the launch date. Monthly calculations convert those inputs into revenue by age group and total sales.

The In-Home Daycare Financial Model is an Excel template for projecting tuition, operating costs, and EBITDA for a six-place family child care home in San Diego, California. It connects one capacity pool, paid occupancy, five age-based tuition rates, and fixed staffing compensation across 2026–2030.
The illustrative case covers an owner-operated daycare in a rented primary residence, serving children from six weeks through age five. Inputs are estimates; transport, overnight care, and subsidy revenue are excluded.
The workbook links editable daycare assumptions to monthly calculations, annual financial projections, scenario comparisons, and financial reporting tools.
Set available places, paid occupancy, age shares, tuition, and the launch date. Monthly calculations convert those inputs into revenue by age group and total sales.
Separate costs that vary with revenue, monthly overhead, and compensation by role. This structure shows how enrollment changes affect earnings while base provider pay remains fixed.
Dashboard controls apply Low, Base, and High multipliers to revenue, COGS, variable expenses, fixed expenses, and payroll. Scenario reports compare the resulting revenue, margins, and EBITDA.
Review the declared income statement, cash flow, balance sheet, and combined summary functions. The illustrated daycare results on this page are limited to the documented operating forecast through EBITDA.
Revenue equals available places multiplied by paid occupancy, each age group’s share, and its monthly tuition, summed across five tariffs.
The first four age groups each receive exactly one-sixth of the shared pool; Pre-K receives the remaining one-third. The displayed 16.67% shares are rounded, so the five tariffs do not create separate capacity pools.
| Age group | Place share | Monthly tuition |
|---|---|---|
| Under 12 months | One-sixth | $1,850 |
| 12–23 months | One-sixth | $1,750 |
| Two-year-olds | One-sixth | $1,600 |
| Three-year-olds | One-sixth | $1,500 |
| Pre-K, ages 4–5 | One-third | $1,450 |
Estimated planning rates; the age-weighted monthly tuition is $1,600 in 2026.
The Revenue Forecast connects capacity, occupancy, age mix, and tuition to monthly sales. Use these inputs to assess how filling unused places or changing rates affects revenue before changing staffing or overhead.
6 places × 65% paid occupancy × $1,600 weighted monthly tuition × 12 modeled months = $74,880 annual revenue.
Paid occupancy increases from 65% in 2026 to 92% in 2030, with tuition following the entered annual schedule and no independent demand control or seasonality. All streams launch January 31, 2026; January counts as a full modeled month, producing 12 revenue months in the first year.
Operating expenses combine direct costs, variable expenses, monthly business overhead, and fixed compensation for the owner and relief provider.
The COGS and Operating Expenses forecast separates meals and snacks at 7% of revenue from learning and hygiene consumables at 3%. Payment processing and enrollment marketing each add 1% as variable operating expenses.
Fixed expenses cover the business share of rent, utilities and internet, insurance, software, bookkeeping, equipment upkeep, and license renewals and training. Annual fixed costs rise from $14,580 in 2026 to $16,410 in 2030; household rent is excluded.
The Payroll Forecast schedules the owner at 1.0 FTE and relief support at 0.15 FTE. Base annual pay of $48,000 and $40,000 per FTE produces $54,000 total annual payroll, with compensation excluded from COGS and other expense categories.
The estimated $28,535 owner funding budget combines startup assets, separate launch spending, opening stock, and a three-month recurring operating-cash reserve.
The Capital Expenditure Plan schedules asset purchases and depreciation. The case allocates $3,500 to child furniture and sleep equipment, $2,500 to durable play equipment, and $2,000 to childproofing and safety improvements, totaling $8,000.
Initial licensing, checks, training, and launch marketing are separate startup cash items whose individual amounts are not specified in the brief. Keep these payments and asset purchases separate from recurring operating expenses when reviewing opening funding.
The Sources and Uses of Funds report reconciles funding, operating receipts, payments, investment, and retained cash over selected months. Dashboard debt controls can model financing structures, but this case has no committed outside funding.
Working-capital inputs set receivable and payable days to zero and inventory days to seven. These assumptions affect cash timing; the opening funding figure is a planning budget, not a tested peak cash requirement.
The supplied 2026–2030 scenario moves from negative to positive EBITDA as occupancy and tuition increase while base payroll remains unchanged.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $74,880 | $77,566 | -$2,686 |
| 2027 | $88,992 | $79,696 | $9,296 |
| 2028 | $103,883 | $81,934 | $21,950 |
| 2029 | $113,294 | $83,527 | $29,767 |
| 2030 | $119,286 | $84,724 | $34,562 |
Illustrative projections, rounded to whole dollars; displayed revenue less expenses may differ from displayed EBITDA by $1.
Operating expenses include COGS, variable expenses, fixed overhead, and payroll. The projected improvement depends on the selected enrollment and pricing assumptions; it is not an observed industry result, a net-profit forecast, or evidence of a particular investment return.
The Cash Flow Forecast distinguishes operating, investing, and financing movements and reconciles opening to closing cash. Review startup purchases, stock, and funding timing there; the supplied EBITDA figures do not establish the daycare’s cash balances or liquidity sufficiency.
The Returns report provides separate views of sales break-even, cash break-even, investment payback, and annual return on invested capital.
The Returns analysis compares revenue with sales break-even requirements and tracks project and cumulative free cash flow. It also relates returns to invested capital, helping assess whether the chosen occupancy, tuition, and funding assumptions support the investment.
Sales break-even tests operating cost coverage; cash break-even assesses cash timing, while investment payback tracks recovery of the initial investment. Annual ROIC measures returns relative to invested capital; positive EBITDA from 2027 does not establish any cash break-even date, payback period, or ROIC result.
The model fits planning for a single owner-operated home with one shared capacity limit and monthly tuition differentiated by age.
The selected scenario assumes no resident children under ten occupy capacity. The six-place input is a planning assumption, not confirmation of licensing approval; different staffing, service lines, or capacity arrangements require assumptions appropriate to that operation.
These answers clarify the editable assumptions, forecast mechanics, and interpretation of this daycare planning case.
Yes; edit available places, paid occupancy, age shares, annual tuition rates, and launch timing in Revenue, then review the resulting revenue forecast and operating expenses.
No; all five age groups share one six-place pool, allocated one-sixth to each of the first four groups and one-third to Pre-K.
Yes; the case includes $48,000 annual owner base compensation plus $6,000 for 0.15 relief-provider FTE, totaling $54,000 annual payroll before excluded employer taxes and benefits.
No; the $28,535 estimate includes startup spending, opening stock, and a three-month recurring cash reserve, but it is not a tested peak funding requirement.
No; tuition, occupancy, costs, and funding are estimated planning inputs, and the displayed financial projections are illustrative scenario outputs rather than verified market averages.
No; EBITDA excludes depreciation, interest, and tax, while investment payback depends on cumulative project cash flow and the initial investment.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
I stopped juggling low, base, and high cases in separate tabs and got everything into one model. It saved me hours and made the plan easier to explain in one meeting.
The pricing, cost, and growth inputs finally felt organized instead of scattered across the file. I cut my setup time by a full afternoon and could check the logic without hunting for numbers.
I could see runway and possible shortfalls month by month instead of guessing where the gaps might hit. That made budgeting much clearer and helped me plan funding needs sooner.