Free Excel templates

A free family entertainment center financial model in Excel, with a full worked case

Bowling lane-hours and leagues, game-card play and prizes, laser tag and soft play, parties and events, food and the bar, staffing from the schedule, a P&L with adjusted EBITDA and SDE, break-even and four stresses, the quarters and the line of credit, a ropes course and two offers for the business.

The file follows Brindlecove Fun Center, a fictional indoor center with 16 bowling lanes, an arcade, laser tag, soft play, party rooms, a kitchen and a bar. It welcomes 118,000 walk-in guests a year for revenue of $4,551,524 and EBITDA of $979,188 (21.5%), and breaks even at 73.7% of its volumes. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

FEC_Business_Model_Brindlecove.xlsx (62 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This file is the worked case of The Family Entertainment Center Owner. The book explains every assumption and every tab: why bowling is sold by the lane-hour, when a game-card load becomes revenue, why the schedule and not the guest count sets the payroll, which jobs a 16-year-old may not do, why the spring quarter consumes cash, what a ropes course costs, and how two buyers would value the business.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Thirteen tabs. Blue cells are inputs; every other cell is a formula.

Inputs
Hours by daypart, guests, lanes, utilization and lane prices, attach rates and prices, the average load and the payout, parties and events, food and bar spend and cost rates, the floor schedule by role, wages and salaries, rent and other costs, the debt and the line, the plan, the ropes course, the de novo budget, the stresses and the two offers.
Bowling
Lane-hours available, leagues, open play by daypart and bowling revenue (28,819 lane-hours sold in the case).
Attractions
Game-card loads, credits played, unused balances, prize cost, laser tag and soft play ($181,107 of prize cost).
Parties
Parties and events, the game credit in the packages, food costs and the deposits held at year end ($39,358).
Food
Food counter, bar and league food and drink, with their cost rates (70.7% gross margin).
Staffing
Hours worked from the schedule, hours paid with sick leave, pay with burden and the count toward fifty (55,956 hourly hours paid).
P&L
Revenue, variable costs, contribution, fixed costs, EBITDA, adjusted EBITDA and SDE ($1,119,603).
BreakEven
The share of 2026 volumes at which EBITDA is zero (73.7%), and the de novo first year at full and low volume.
Stress
The whole year rerun with lower volumes, lower prices, higher wages and higher food cost rates, the debt unchanged.
Cash
Four quarters: loan payments, distributions on the tax calendar, the line of credit and the cash floor, customer balances, and the volume stress with and without a cut in distributions.
Plan
2027 to 2029 with the ropes course: EBITDA, coverage, the expansion budget and loan, quarterly cash for each plan year, and the de novo budget of chapter 3.
Value
An operator’s offer on adjusted EBITDA, an individual buyer’s offer on SDE with an SBA loan and a seller note, the cash the seller keeps after debt and customer balances, and the buyer’s coverage test.
Checks
Internal checks (months, quarters, hours, card play, SDE, line limit, reserves, offer layers) and a comparison with every figure printed in the book.

Three things to try

Raise the weekend lane price. The case charges $52 a lane-hour from Friday to Sunday. In the book, five more points of weekend utilization at unchanged prices add $83,944 of EBITDA, because the floor is already staffed for the weekend.

Change the payout. The payout of 25% is a policy, not a rule: move it and the prize cost on the Attractions and Parties tabs moves at once ($181,107 in the case).

Cut the volumes. Set the volume stress and read the Cash tab: in the case, unchanged distributions would push the line $77,831 past its limit, while distributions cut to the tax keep it within.

Questions

Does it model game cards and unused balances?

Yes. Walk-in guests loaded $1,051,380 on cards in the case; revenue is the credits played, and the $36,798 left on the cards at year end stays a liability, with no breakage taken.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own center?

Yes: replace every blue input, starting with your hours, guests, lanes, attach rates and the floor schedule. Brindlecove and every figure in it are fictional case assumptions, not market data.

Related reading