$0.00

Kids Summer Camp Excel Financial Model for Startups

What you'd spend hiring a freelance analyst: $2,000+. What you'd spend building it yourself: days of setup and checking assumptions.
  • Fully Editable
  • Instant Download
  • Professional Design
  • Pre-Built
  • No Expertise Is Needed

The Summer Day Camp Financial Model is an Excel planning template for a seasonal, nonresidential camp serving children ages 9–14. It turns camper capacity, weekly enrollment, program mix, package prices, staffing, and operating costs into monthly calculations and five-year financial projections.

The illustrative case uses a leased school or community campus near Evanston, Illinois, with 160 simultaneous places and 12 camp weeks each June–August. It models five alternative programs, with meals and standard trips included in their weekly fees rather than sold separately.

Forecast
5annual periods
Camp places
160simultaneous capacity
Summer weeks
12per operating year
Programs
5weekly fee categories
WORKBOOK CONTENTS

What Is Included in the Camp Model?

The workbook connects day-camp operating inputs with revenue, expense, staffing, investment, scenario, and financial reporting schedules.

Revenue and Monthly Calc

Set camp places, summer utilization, the five program shares, weekly fees, and operating months; Calc applies those inputs to monthly revenue.

COGS, OPEX, and Payroll

Plan direct camper costs, revenue-linked expenses, contracted overhead, and compensation by role without counting salaried staff twice.

Startup Funding and Assets

Use CAPEX for equipment purchases, CapTable for owner contributions, and Sources & Uses to examine how opening resources are allocated.

Financial Reports and Checks

Dashboard, scenarios, statements, Returns, valuation, charts, and reconciliations support review; the supplied example verifies operating projections only through EBITDA.

REVENUE DRIVERS

How Are Camper-Weeks Converted Into Revenue?

Revenue is based on one shared place-capacity pool, summer enrollment utilization, and the weighted weekly prices of five programs.

The 160 available places operate across four modeled weeks in each of June, July, and August. Summer utilization increases from 70% in 2026 to 90% in 2030; the rest of each year has no camp revenue.

Each sold camper-week is assigned once across Traditional Day Camp (35%), Sports Skills (20%), STEM Discovery (20%), Creative Arts (15%), and Outdoor Adventure (10%). The program shares total 100%, so separate programs do not duplicate the same capacity.

Revenue Forecast

The Revenue Forecast links available places, camper-weeks, program mix, and editable weekly fees to annual sales. Monthly calculations follow the June–August seasonality profile, making utilization and pricing changes visible without adding new camp places.

Illustrative 2026 sales build

160 places × 12 weeks × 70% utilization = 1,344 camper-weeks; 1,344 × $496.225 weighted weekly fee = $666,926 revenue.

The example applies a user-defined 15% increase to all five baseline weekly fees, while enrollment, program mix, and staffing stay unchanged. Its 2026 fee inputs range from $454.25 for Traditional Day Camp to $569.25 for Outdoor Adventure.

These are estimated fees, not verified local prices. The higher-price case assumes unchanged enrollment and warrants attendance sensitivity tests.

OPERATING COSTS

What Drives Summer Camp Operating Expenses?

The cost model separates camper-related direct spending, revenue-based selling costs, fixed overhead, and the base salaries of four staffing groups.

Meals and snacks, program consumables, and field trip admissions are direct costs. In the higher-price case, their percentages are adjusted to preserve the baseline annual spending at unchanged camper volumes; processing and marketing instead remain 3.2% and 3% of revenue.

Fixed overhead covers facility lease, office and storage, insurance, transport, summer utilities, registration software, professional support, screening and training, and custodial work. The illustrative annual fixed total is $165,600.

COGS and Operating Expenses

The COGS and Operating Expenses Forecast separates direct costs, revenue-linked variable spending, and fixed expense assumptions. This helps identify which costs move with higher camp fees and which are held constant in the illustrated pricing scenario.

Payroll is modeled separately from all three expense groups. Its annual-average staffing plan includes one director, 0.5 enrollment coordinator FTE, 3.69 seasonal counselor FTE, and 0.46 activity-lead FTE, totaling 5.65 annual-average FTE.

The documented illustrative payroll cost is $265,100 per year. Employer payroll taxes, employee benefits, and personal income taxes are excluded from the companion operating case, so the user must review those costs before treating the forecast as a fully burdened budget.

Payroll Forecast by Staff Role

The Payroll Forecast organizes staffing by role, FTE assumptions, and fixed annual salaries. Monthly staffing schedules can help test counselor coverage and wage requirements as summer enrollment changes; the supplied operating illustration retains its original personnel plan.

OPENING FUNDING

How Much Startup Funding Does This Case Assume?

The example assumes $196,871 of owner funding to cover durable equipment, preopening cash payments, initial inventory, and an operating reserve.

The opening budget assigns $36,000 to durable sports equipment, STEM kits and devices, safety equipment, and activity furniture. Another $19,500 covers preopening payments, including a facility deposit, permits, staff orientation, promotion, and director preparation.

Opening inventory is approximately $4,511, and the modeled operating reserve is $136,860, equivalent to three months of first-year average operating outflows. Accounts receivable and payable days are both zero, while inventory is set to five days.

Capital Expenditure Plan

The Capital Expenditure Plan records purchases of durable camp assets and their timing. It separates spending on sports equipment, STEM kits, radios, and furniture from ordinary summer operating expenses and supports subsequent depreciation schedules.

The reserve is a planning allowance, not evidence that cash will remain sufficient through the seasonal enrollment and payment cycle. Startup purchases and equity contributions must also be distinguished from revenue and EBITDA when reviewing funding needs.

Sources and Uses of Funds

The Sources and Uses of Funds report shows planned funding inflows and cash allocations over selected periods. Use it with CapTable, Debt controls, and Cash Flow to evaluate financing choices without treating owner contributions as operating income.

FIVE-YEAR PROJECTIONS

What Do the Illustrative Annual Results Show?

Under unchanged enrollment and staffing with weekly fees increased 15%, revenue rises with utilization and price assumptions through 2030.

Illustrative higher-price summer day camp forecast, USD
YearRevenueOperating ExpensesEBITDA
2026$666,926$547,441$119,485
2027$739,404$560,128$179,276
2028$815,194$573,394$241,799
2029$894,295$587,241$307,055
2030$976,709$601,667$375,042

Illustrative projections, not actual business results; each figure is rounded to the nearest whole dollar.

The documented 2030 EBITDA margin is 38.40% in this selected case, versus 30.09% in the original lower-price assumptions. The improvement reflects higher realized fees with the specified enrollment mix, direct-cost amounts, and staffing retained.

EBITDA is operating earnings before depreciation, interest, and income taxes; it is neither net profit nor cash available to owners. The companion example does not independently establish after-tax profitability, cash balances, or the adequacy of seasonal funding.

Cash Flow Forecast

The Cash Flow Forecast tracks operating receipts and payments alongside investing and financing cash movements. It can reveal liquidity pressures that an annual EBITDA table cannot, especially when camp income is concentrated in three summer months.

DECISION ANALYSIS

How Can You Evaluate Break-Even and Returns?

The workbook offers separate calculations for operating break-even, cash break-even, investment payback, and return on invested capital.

Sales break-even asks how much activity is required to cover modeled costs. Cash break-even considers timing of cash receipts and payments; investment payback tests when cumulative project cash flows recover invested funds, while ROIC compares operating returns with invested capital.

None of these results can be inferred directly from the EBITDA figures above. Use the Returns and Cash Flow schedules with reviewed investment, depreciation, working-capital, and financing inputs before drawing conclusions about recovery timing or investor returns.

Break-Even, Payback and ROIC

The Returns report compares sales break-even, cash break-even timing, investment payback, and annual ROIC. These are distinct tests for enrollment pricing, liquidity, recovery of startup investment, and capital efficiency; the case brief provides no verified payback date or ROIC value.

Dashboard scenario controls and Scenarios compare Low, Base, and High revenue and cost multipliers. Test weaker enrollment or higher facility and payroll costs rather than assuming the user-defined fee increase can be achieved without affecting demand.

PLANNING APPLICATIONS

Who Can Use This Summer Camp Template?

The model is designed for operators assessing a leased-campus, fee-based summer day camp with a short annual sales season.

It supports pricing decisions across five weekly program types, counselor and activity-lead staffing plans, seasonal cost budgets, opening asset purchases, and the size and timing of funding needs. All example inputs should be replaced or confirmed for the operator’s own location and contracts.

It does not model overnight cabins, an owned swimming pool, a dedicated bus fleet, or separately billed extended-care services. Those business lines require changes to the operating assumptions rather than being silently included in the example forecasts.

FREQUENT QUESTIONS

Summer Day Camp Financial Model FAQ

Practical answers about the template’s capacity logic, forecast periods, financing, and interpretation of the example.

Can I change camp enrollment and weekly fees?

Yes. Edit the place capacity, summer utilization, program mix, and weekly fees to recalculate camper-weeks and sales.

Does the model include revenue outside summer?

No. The illustrated case earns camp fees only in June, July, and August; its monthly seasonality inputs can be reviewed.

Are meals and field trips sold separately?

No. Standard meals and field trips are included in the five program fees, with related expenses modeled as direct costs.

Does it include counselor salaries and seasonal staffing?

Yes. Payroll plans annual-average FTE, compensation, and monthly schedules; the illustrated operating case excludes employer tax and benefit burdens.

Does the $196,871 opening funding amount represent profit?

No. It is an estimated owner contribution for startup assets, preopening cash, opening inventory, and an operating reserve.

Can the template analyze borrowing and cash flow?

Yes. Debt controls, financing schedules, and cash flow reporting are provided, but the companion EBITDA case does not establish debt terms or verified cash outcomes.

Are the displayed figures actual camp performance?

No. They are illustrative 2026–2030 projections based on estimated inputs and a user-defined 15% fee increase.

Can EBITDA tell me the investment payback date?

No. Payback requires cumulative project cash flows and invested-capital inputs; EBITDA alone cannot establish recovery timing.

What Does the Summer Camp Financial Model Contain?

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

Sources & Uses

Funding sources, spending, and closing cash.

Returns & Break-Even

Cash break-even, payback, and ROIC.

Business Valuation

DCF valuation and sensitivity analysis.

Expense Breakdown

Largest costs and spending trends.

Financial Summary

Annual and monthly financial performance.

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Cleaner Assumptions, Less Guesswork

Megan Carter, TX

5 star rating

The pricing, cost, and growth inputs were all over the place before this. I had one clean place to map everything and cut my assumption review time by a few hours.

Built Fast, Not From Scratch

Derek Wilson, CA

4 star rating

I usually lose half a day building camp projections by hand. This template gave me a working model in minutes, so I could move on with planning instead of fighting spreadsheets.

Runway Is Easier To See

Lauren Mitchell, FL

4 star rating

Cash flow was the part I kept second-guessing. With the forecast laid out clearly, I could spot a shortfall early and map runway month by month without guessing.