Indoor Playground & Family Entertainment Centre Business Model: Indoor Play Centre Financial Model Spreadsheet
Full description
For founders, investors and operators who plan an indoor playground or a small family entertainment centre and need numbers a lender can follow. You enter your quotes, prices, staff plan, rent and a normal week of child visits. The workbook builds Year 1 month by month from the weekday profile and the season of each month, adds ticket, membership, cafe and party revenue, deducts cost of sales, staff, rent and running costs, then projects five years with break-even visitors per day, payback and NPV.
Save with a bundle: this template is also in the Food & Leisure Business Startup Bundle, 14 templates for $35 instead of $103. All 141 templates are in the All-Access Hospitality Template Library for $79.
What is inside
- Indoor_Playground_Business_Model.xlsx: 8 tabs, 915 formulas, 6 native charts, 11 drop-down or number rules. No macros.
- Settings: 26 inputs (prices, cafe spend, party price, membership fee, rent per m2, on-cost %, tax rate, discount rate, flag targets), children per day for each of the 7 weekdays, 4 season levels with an index, a 12-month season calendar, growth rates for Years 2 to 5 and 5 editable drop-down lists.
- Capex: room for 50 investment lines (26 sample lines) across 7 zones, including play frame, soft play, cafe, party rooms and pre-opening. Budget variance, depreciation per year and an over-budget flag, with a summary and chart by zone.
- Visitors: Year 1 child visits for 12 months, split by weekday and weekend, from the weekday profile x season index x trading % for the opening ramp-up.
- Staff_Costs: staff plan with room for 15 roles (8 sample) with FTE, pay and employer on-cost, plus room for 16 monthly cost lines (11 sample) with rent calculated from area and rate.
- Year1_Monthly: 12 months of tickets and entry, membership, cafe, parties, cost of sales, staff, rent, other costs and EBITDA, with a loss-month flag and a chart.
- Projection_5Y: five-year P&L and cash flow, depreciation, tax, cumulative cash, payback, NPV, staff and rent % of revenue, contribution per visit and break-even child visits per day.
- Dashboard: 8 KPI tiles, 6 checks against your targets and 3 charts on one printable page.
- README.txt and LICENSE-and-Terms.txt.
How it works
- Enter prices, rent, tax rate and your normal week of child visits on Settings.
- Set the season of each calendar month and the growth rates for Years 2 to 5.
- Replace the sample capex lines, staff roles and running costs with your own quotes.
- Set the trading % for the opening months on Visitors.
- Read Year1_Monthly, Projection_5Y and the Dashboard, then change inputs until the plan meets your targets.
Details
- Format: Excel workbook (.xlsx). No macros.
- Language: English. Currency is a label you choose.
- Software: Excel 2016 or later, or a spreadsheet program that opens .xlsx files.
- Delivery: instant digital download. Nothing is shipped.
Good to know
- All sample prices, visitor numbers, quotes and costs are illustrative. Replace them with your own figures.
- Tax, employer on-cost, rent and licence costs depend on your location. Verify local requirements.
- The model is a planning tool, not financial, legal or tax advice. Ask a qualified adviser before you sign a lease or a loan.
- Single-user license. Do not share or resell the files.
FAQ
Can I use it for a trampoline park or a soft play cafe?
Yes. Rename the zones and capex lines, and set the prices and party numbers for your concept.
How does the model handle the opening months?
Each month on Visitors has a trading %. The sample uses 70%, 85% and 95% for the first three months.
Does it work in Google Sheets?
It opens in Google Sheets and the formulas calculate. Check the drop-downs and charts after import.
Can I change the number of years?
The projection covers five years. Growth rates for each year are inputs on Settings.
Is this a physical product?
No. It is a digital download. Refund terms follow the store policy at the time of purchase.
