Studio Cash Flow Forecasting: A 13-Week Model for Owners

A studio cash flow forecast is a week-by-week list of every dollar expected in and out over the next 13 weeks. Its job is to find your lowest cash week before it arrives. That matters because the median small business held just 27 days of cash buffer, so few owners have much room for error.

What is a studio cash flow forecast, and why 13 weeks?

A studio cash flow forecast lists every dollar expected in and out, week by week. Thirteen weeks covers one full quarter.

A monthly P&L hides timing. Rent clears on the 1st, instructors are paid every other Friday, and autopay memberships run in batches on the 1st and 15th. A month can be profitable overall while one week inside it dips below payroll.

Thirteen weeks catches renewals and seasonal dips while your numbers still come from real bookings. One catch: the IRS estimated tax schedule has uneven gaps. Payments are generally due April 15, June 15, September 15 and January 15. The September to January gap is four months, so a window built in late September will not show January 15 until mid-October. Add it as a note now.

How much cash do studios actually keep on hand?

Not much. The median small business held 27 days of cash buffer, and personal services businesses held 21, according to JPMorgan Chase Institute research.

That JPMorgan Chase Institute study followed nearly 600,000 small businesses through their bank transactions. The data dates from the mid-2010s, but it remains one of the largest transaction-level studies of small business cash. A quarter of the businesses held fewer than 13 buffer days. For a studio, 21 days is less than one rent payment plus one payroll cycle.

Costs are not easing either. Rising costs of goods, services or wages has been the most commonly cited financial challenge for employer firms in recent Federal Reserve Small Business Credit Survey reports.

What goes into the forecast, line by line?

Sort every line into one of three buckets: committed outflows, recurring inflows, and probable inflows. Each bucket gets treated differently.

Committed outflows are fixed by contract: rent, payroll, loan payments, software, insurance. Enter each one on the day it clears, not the day the invoice arrives.

Recurring inflows are autopay memberships. Date them to the day the money reaches your bank, not the billing day. Stripe lists 2 business days as standard payout timing for most US accounts, so a batch charged on a Friday lands on Tuesday. Then subtract your failed-payment rate, taken from your own last three batches. If fees and settlement speed are part of the problem, see how ACH compares with credit cards for studios.

Probable inflows are class packs, drop-ins, retail and intro offers. Use an 8-week trailing average and cut it by 10 to 15 percent. Most owners overestimate this bucket.

How do you build the model in one afternoon?

Pull four exports: bank balance, bills calendar, billing schedule, and eight weeks of non-recurring sales. Budget about three hours for the first version.

Use one spreadsheet with four tabs:

1. Opening balance. Use today's bank balance, not your accounting software. Uncleared transactions make book balances misleading.
2. Committed calendar. List every bill with its clearing date for 13 weeks. Include annual items like insurance, music licensing and equipment leases.
3. Recurring schedule. Export upcoming autopay charges by date. Remove members on a freeze and anyone whose card failed twice.
4. Probable sales. Calculate weekly averages from the last eight weeks, then apply your cut.

A summary row runs across the 13 weekly columns: opening balance, plus inflows, minus outflows, equals closing balance. Each week's closing balance becomes the next week's opening balance.

What does a real 13-week forecast look like?

An illustrative 160-member reformer studio looks healthy month to month, yet its forecast shows cash dropping to $3,100 in week 10. Timing causes it, not a lack of profit.

Here is the example. 160 members at $219 a month bring in $35,040 in autopay, charged on the 1st. Rent is $8,200 and clears on the 1st. Instructor payroll is $6,900 every other Friday. Utilities, software, marketing and the owner's draw take most of the remaining margin. The studio starts the forecast with $18,500.

Week 10 falls at the turn of November into December. Payroll went out on Friday, November 27. Rent clears on Tuesday, December 1, but the autopay batch charged that morning does not settle until Thursday. The annual liability policy renews the same week. And 14 members froze for the holidays, which takes $3,066 out of the batch. None of these items is dangerous on its own. Together they leave $3,100 in the account.

The December P&L still shows a profit. Only the weekly view shows the gap.

Which timing traps sink studio forecasts?

Five traps come up again and again: three-paycheck months, weekend settlement lag, holiday freezes, annual prepay spikes, and lump-sum contractor payments.

• Three-paycheck months. On a biweekly schedule, two months a year usually have three payrolls. Mark them the day you build the model.
• Weekend and holiday lag. A charge run on the Friday before a Monday holiday can take until Wednesday to arrive.
• Freezes and cancellations. Check last year's December and August freeze counts, and use real churn assumptions. The warning signs covered in at-risk member detection belong in your forecast before they show up in your bank account.
• Annual prepay spikes. See the warning below.
• Contractor payments. If some instructors are 1099 contractors paid monthly, that payment arrives as one large lump. The 1099 vs W-2 breakdown covers how the timing differs.

How do you run the weekly forecast review?

Every Monday, take 20 minutes: replace last week with actuals, flag lines off by more than 10 percent, add a new week, and recheck the low point.

Do it before 10am, after weekend sales have settled and before payroll runs. Write down why each flagged line missed. A line that misses by the same amount two weeks in a row is a pattern, so change the assumption rather than hoping next week corrects it.

Keep old versions. By week six, comparing what you forecast with what happened will show whether you run optimistic or pessimistic, and in which bucket.

What cash floor should a studio set?

Set a floor of one month's rent plus two payrolls. If any week in the next six breaches it, act now, while the cheap fixes still work.

In the example studio, the floor is $8,200 plus two payrolls of $6,900, which is $22,000. Week 10 breaches it by $18,900. Spotting that in late September leaves time to work through the fixes, cheapest first:

1. Move the annual insurance renewal to monthly installments.
2. Bill new members on the 15th, so December autopay is split across two dates.
3. Run a 10-class pack presale in October with a firm deadline, not an open-ended discount.
4. Push non-urgent equipment purchases back one quarter.
5. Only then, look at a credit line.

Find the same breach in late November and only option five is left.

Is a 13-week forecast better than a monthly budget?

They answer different questions. The budget asks whether the year will be profitable. The 13-week forecast asks whether you can pay everyone on Friday.

You need both. The budget sets prices and targets. The forecast keeps the lights on while you hit them. If you are weighing annual against monthly plans, the annual vs monthly membership analysis shows how each one shapes the cash curve.