Income Forecast for Personal Trainers: A Six Month Template

A six month income forecast for a personal trainer needs four inputs, active clients, sessions per client, churn and package renewals, and a three-scenario table that you update once a month. The goal is not to predict the future; it is to see a slow month coming early enough to act on it. Open the income calculator in another tab so you can check your per-session profit as you build the sheet.
The four inputs
- Active clients and their weekly sessions. List each client with the number of sessions they book per week.
- Average net per session. Rate minus room cost and fees. See how many sessions cover your space for the room line.
- Churn. The share of clients likely to leave in a month, from your own history.
- Renewals. Which packages end in which month, and how likely each is to renew.
The template
Build a sheet with the months across the top and these rows.
| Row | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 |
|---|---|---|---|---|---|---|
| Clients at start | 20 | |||||
| Expected losses (churn) | ||||||
| New clients (pipeline) | ||||||
| Clients at end | ||||||
| Sessions (clients x weekly sessions x 4) | ||||||
| Revenue | ||||||
| Renewal revenue at weighted value | ||||||
| Costs (space, software, insurance) | ||||||
| Net |
Fill the first column from today’s real numbers and then run the formulas forward.
Three scenarios
Make three copies of the sheet.
- Cautious: high churn, no new clients, renewals at half the usual rate.
- Expected: your recent average on all four inputs.
- Strong: lower churn and the new clients you are actively pursuing.
Plan fixed spending, such as a software subscription or a marketing push, against the cautious sheet. If the cautious sheet still shows a positive net, you can commit with confidence. If not, you know exactly how many clients you need to add.
A worked mini example
Start with 20 clients each booking 2 sessions a week, which is about 160 sessions a month. At a net of $65 per session, that is $10,400. If one in ten clients leaves each month and you add one new client monthly, you end month 2 with 19 clients and about $9,880. Without any new clients you drift lower, which is why the pipeline row matters. The numbers are illustrative.
Link it to your cash and your taxes
A forecast is only useful if it changes what you do. Set aside your tax share from each projected month, and use the cautious figure to decide how much to move into savings. For the first months of independence, first month income for an independent trainer shows how the numbers start, and a steady paycheck from irregular income explains how to pay yourself a fixed amount from a variable forecast. Log everything in your books each month, per bookkeeping for personal trainers, and compare the forecast to what happened.
Related questions
What churn rate should I assume?
Use your own history: count clients you had at the start of a quarter who were gone by the end. If you have no history yet, run three scenarios, losing none, one in ten and one in five clients per month, and plan around the middle one.
How do I handle packages that renew in different months?
Give each client a renewal month in the sheet and a probability that they renew. Revenue that is likely but not certain goes in the forecast at its weighted value.
How often should I update the forecast?
Monthly, on the same day you close your books. A forecast that is not refreshed is a guess with a spreadsheet around it.