Gym Business Plan: Build the Numbers a Lender Will Ask For With AI

A lender wants proof that the gym's cash flow covers its loan repayments with room to spare. That means a use-of-funds table backed by quotes, a month-by-month membership ramp, running costs, a break-even member count and stress tests. AI can build and attack that model from your own inputs; it cannot supply market figures you have not evidenced.

The usual failure is polished prose over soft numbers. Ask an assistant for a typical gym churn rate or a typical membership ramp and it will answer fluently, and the figure will have no source, which is exactly what a credit analyst circles. Every number below comes from a quote, a lease term, your price list or an assumption you state openly, and the assistant's job is arithmetic, structure and cross-examination.

Follow me on Instagram@sagnikteaches

The five numbers a lender checks before reading the story

Credit analysts work through a short list of figures, and a plan that makes them easy to find is easier to approve.

Connect on LinkedInSagnik Bhattacharya

1. The funding split. How much is the loan and how much is your own cash, and what the loan is secured on.
2. The monthly repayment. Worked out from loan size, interest rate and term.
3. Coverage. Cash left after running costs but before repayments, divided by the repayments for the same period. A figure of 1.0 means the gym only just pays its debt, so lenders want headroom above that.
4. Break-even members as a share of capacity. How full the gym must be before it pays its costs and its loan.
5. The cash low point. The lowest cumulative balance during the ramp-up, and the reserve that covers it.

Each lender sets its own minimum coverage, forecast length and format, so ask before you build: what coverage do you require, what security do you take, how many months do you want, monthly or annual, and which scenarios. Many lenders also ask for three statements: a profit and loss account, a cash-flow forecast and an opening balance sheet. The model below is a cash-flow model. The profit and loss adds depreciation on equipment and splits each repayment into interest and capital, and the opening balance sheet sets equipment and cash against the loan and your own capital. Ask the assistant to derive all three from one assumptions tab so they cannot disagree. For the general method, see building a 12-month forecast for a lender.

Subscribe on YouTube@sagnikteaches

Startup costs: turn a pile of quotes into a use-of-funds table

Every line in the first table should trace to a document you can hand over. These are illustrative figures for a new independent gym with a strength floor, a studio and changing rooms; yours will differ. This is version 1 of the plan, and the stress tests later turn it into a version 2 with a bigger reserve.

The reserve is the line owners most often guess, usually as "three months of costs". Here it comes from the model: the lowest point the cumulative cash balance reaches before the gym turns cash-positive. That is why the table comes first but the reserve is the last number you can fill in.

Quotes arrive as emails, PDFs and phone notes, and an assistant is good at tidying them. Paste the text, never a customer's or an employee's personal details, and ask for the table plus the gaps.

Below are six supplier quotes pasted as text. Build a table with item, supplier, date, amount, what is included, what is excluded and how long the price is valid.
Flag any quote that is past its validity date or excludes delivery, installation or taxes. Do not estimate missing figures: list the questions I should ask each supplier instead.

A realistic result (illustrative) flags three things: the equipment quote excludes installation, the flooring quote expires in 14 days, and the signage quote has no delivery line. Each flag becomes a question to the supplier before the figure goes into the plan, and the revised quote goes in the folder you will give the lender. If you are weighing a lease against a purchase for the equipment, get both quotes now, because the FAQ below explains how each one changes every scenario.

The membership ramp: joins, churn and capacity in four rows

Members each month follow one rule, and writing it out stops the assistant from inventing its own.

Members this month = MIN(Capacity, Members last month x (1 - Churn) + Joins this month)
Revenue this month = Members x Average fee + Other income
Cash before repayments = Revenue - Members x Variable cost - Fixed costs

The inputs sit on the assumptions tab, each with the evidence you would attach.

Churn is the input everyone wants a benchmark for, and a new gym has no history to supply one. There are three honest routes. Use your own records if you have run or managed a similar gym. Quote a published figure only if you can name the source, its date and how it was measured. Or treat churn as an assumption and show the lender how far it can move: in this model, year-2 coverage falls to 1.0 when monthly churn reaches about 7.6%, nearly double the 4% assumed. You can say that without claiming 4% is typical, and you can add what you would do if churn passed 6%. Once members exist, churn prediction for a small gym shows how to replace the assumption with measured data, and seasonal cash-flow planning covers the January and summer shape.

Running costs: the lines gym plans most often leave out

Fixed costs are the second half of the break-even sum, and omissions here flatter the plan. Illustrative monthly figures:

The five most-forgotten lines are your own pay, the replacement fund for equipment that wears out, any licence needed to play music in the gym, insurance that covers classes and one-to-one coaching, and rent paid before the doors open. This example assumes the lease starts in the opening month; if yours starts during the fit-out, add those months of rent to the use-of-funds table. A realistic mistake (illustrative): leave your own $3,000 out and year-2 coverage in this model jumps from 2.35 to about 3.3, which looks excellent until the lender asks who pays the owner. Ask the assistant to compare your cost list with the lines above and name anything missing, then decide each gap yourself.

Repayments, coverage and break-even: the three formulas

These are the formulas to paste into the summary tab. The values shown use the illustrative inputs and an assumed 9% interest rate over 60 months; use your lender's indicative rate and term.

Monthly repayment      =PMT(0.09/12, 60, -150000)                 gives 3,113.75 (37,365 a year)
Annual coverage        =SUM(cash before repayments, 12 months) / (12 * repayment)
Break-even members     =(Fixed costs + Repayment - Other income) / (Average fee - Variable cost)
                        =(23,100 + 3,113.75 - 800) / (55.00 - 2.10)   gives 481 members
Lowest cash balance    =Reserve + MIN(cumulative net cash column)

Without the repayment, break-even is 422 members. Against a capacity of 560, that is 75% before the loan and 86% with it. The second figure is the one a lender will fix on, because it says the gym must be nearly full before it covers its costs and its debt. If your own figure is that high, say so, and show what would bring it down: a higher fee, a smaller loan, lower fixed costs or more capacity.

Stress tests: what moves the answer and what to change

Change one input at a time, then change three together. Each row below shows members at month 12, year-2 coverage and the lowest cash balance after the reserve, for two versions of the plan. All figures are illustrative outputs of the model above.

Version 1 passes the base case, but only with $7,580 of headroom, and each of the five single changes pushes the balance below zero. The model gives the break points: the $90,000 reserve runs out if churn passes about 5.3%, if joins fall about 4% short of plan, or if the average fee is below about $52.70. A lender running the same tests would see a plan that works only if nothing slips.

Version 2 changes three things, and each needs evidence rather than hope. The landlord agrees three rent-free months, which must appear in the heads of terms before you count it. You cut your own pay to $2,000 a month for year 1, which is a personal decision the lender will want to see in writing. And the reserve rises to $100,000, which takes total funding to $240,000 with $90,000 of your own cash (37.5%). Now the base case keeps $46,127 of headroom, and the worst single change, joins 20% lower, still ends at $4,917. The reserve runs out only if joins fall about 22% short, or if churn passes about 8.4%.

The three-together case still fails in both versions, and the plan should say so. Add a risks paragraph that states what you would do if it happened: cut opening hours, freeze hiring, pause the replacement fund, or ask the landlord for a longer rent-free period. A plan that names its own breaking point is more credible than one that shows none. The assistant is useful here because it can rerun fifty variations in minutes, but you choose which ones the plan reports.

If the gym already trades: borrow against last year, with no uplift

An existing gym asking for an equipment loan has something a startup lacks: history. Replace the ramp with your own records, and ask one hard question first: does last year's cash flow cover the new repayment with no extra members at all? A lender can see for itself what last year's cash flow supports but cannot verify the uplift the new kit is supposed to bring, so show coverage before you show hopes.

Illustrative figures: 380 members at an average of $52, $1,000 a month of other income, fixed costs of $14,900 a month including $3,000 for your own pay, and $2.10 a member in variable costs. Cash before repayments is $5,062 a month, or $60,744 a year. A $60,000 loan over 48 months at an assumed 9% costs $1,493.10 a month ($17,917 a year), so coverage is 3.39 with zero uplift.

Coverage falls to 1.0 at about 309 members, a loss of 71 (19%). That sentence is more persuasive than any growth story. Take churn from your own export rather than a benchmark: leavers in a month divided by members at the start of it, so 15 leavers from 380 members is 3.9%, averaged over the last 12 months. Paste an anonymised export, with names and emails removed, and ask the assistant to compute it, then check one month by hand.

Prompts that build the model, then attack it

Use three prompts in order, in one ChatGPT or Claude conversation, with your assumptions typed in rather than summarised. Either assistant can write the formulas; paste them into Google Sheets or Excel yourself rather than accepting a finished file, so every number stays traceable to a cell you can show a lender. The first prompt builds the sheet.

You are helping me build a 36-month financial model for a lender, for a new independent gym. Use ONLY the inputs below. If you need a figure I have not given, list it as a question; do not fill it with a typical value.
Inputs: Standard $49 (70% of members), Plus $69 (30%); 140 pre-sale members in month 1; joins per month: [paste the 36 values]; monthly churn 4% (my assumption, no history); capacity 560; variable cost $2.10 per member; other income $800 a month from month 4; fixed costs: [paste the list]; loan $150,000, 60 months, 9% (assumed).
Build Google Sheets tabs called Assumptions, Members, Cash flow and Summary. Members each month = MIN(capacity, last month x (1 - churn) + joins). Give me every formula so I can paste it, and make each formula point to the Assumptions tab rather than contain typed-in numbers.

The second prompt turns the assistant into the lender's analyst.

Act as a credit analyst reviewing this model for a $150,000 loan. List the ten weakest points, ranked. For each give the question a lender would ask, the cell or assumption it touches, and the evidence I could attach. Do not suggest new numbers; ask me for evidence instead.

Here are five of the ten points such an audit might return for version 1 (illustrative output, trimmed).

1. The cash balance falls to $7,580 in month 10 in the base case, 8% of the reserve. What protects the lender if joins are 5% short? Evidence: the stress table and a larger reserve or lower fixed costs.
2. Members reach 526 by month 12, 94% of the 560 capacity. How was capacity calculated? Evidence: a floor plan with peak-hour and class-size workings.
3. Break-even needs 481 members including repayments, 86% of capacity. What is the plan for a year at 75%? Evidence: a cost-reduction plan with figures.
4. Churn is a single 4% assumption with no history. What is the basis? Evidence: records from a comparable gym, or a sourced figure, plus the break-even churn.
5. The 140 pre-sale members pay in month 1. When are first collections actually taken? Evidence: the payment provider's first-debit schedule.

Sort those by what they need. Points 1 and 4 change the plan, which is how version 2 came about. Point 2 needs a document, not an edit. Point 5 is a quick sum: if first collections slip a month, month-1 revenue falls by about $7,700 (140 x $55), roughly the whole of version 1's $7,580 headroom. The audit did not find an error; it found the questions, and you supply the evidence.

The third prompt writes the financial section, and its main job is to stay inside your numbers.

Using only the figures in the Summary tab below, write a half-page "Financial request and repayment" section for a lender. State the loan, monthly repayment, coverage, break-even members as a share of capacity and the cash low point in plain words.
Mark any assumption without attached evidence with [EVIDENCE NEEDED]. Do not add any number, benchmark or market statistic that is not in the Summary tab.

Check the arithmetic before the lender does

Assistants write convincing formulas and sometimes wrong ones, and a long chain of sums is where they slip. Treat the spreadsheet as the calculator and the assistant as the author of formulas you then test. Seven checks cover the usual slips, and each is quick to run. If you want a refresher on prompting for formulas, the ChatGPT for Excel guide covers it.

1. Capacity. The maximum of the members column must never exceed the capacity cell.
2. Repayment. Check the PMT result against a lender's online calculator. Over 60 months, 60 x $3,113.75 is $186,825, so the interest is $36,825.
3. Totals tie. The sum of monthly net cash must equal the closing balance minus the opening reserve.
4. The zero test. Set joins to zero. Members should decay by 4% a month, revenue should shrink with them and costs should stay put.
5. Units. Search for any place where a monthly figure meets an annual one, usually in the coverage formula.
6. Hidden numbers. Ask the assistant to list every typed-in constant inside a formula. Each should live on the Assumptions tab instead.
7. Re-key three. Pick the three biggest costs and re-enter them by hand from the quotes. If any differs from the model, find out why.

Writing the financial section so every figure has a source

The plan's financial section needs a request, a repayment story, the key assumptions with their evidence and what happens if things go wrong. Keep one register that the whole plan draws on, and attach each document behind it.

Then the one-page summary, taken straight from the Summary tab of version 2.

What to hand the assistant and what to keep

If you would rather map this with someone before you approach a lender, that is what my AI implementation consultation covers; get in touch. For the loan paperwork itself, see preparing a business loan application with AI help.

Questions gym owners ask about lender numbers

Should the plan show leased or bought equipment?

Show the route you intend to take, and ask suppliers for both quotes so you can describe the alternative. Leasing lowers the cash needed on day one but adds a fixed monthly cost to every scenario, while buying does the reverse. Put the total cost over the loan term side by side and ask your lender which it prefers to finance.

How many months should the forecast cover?

Ask the lender, because requirements differ. Many ask for month-by-month figures for the first year or two and annual figures after that, but the application guide decides. Build 36 months monthly so you can summarise to any shape, and keep one assumptions tab so every version you send uses the same inputs.

Can I paste bank statements or ID into an AI tool?

Keep identity documents and account details out of consumer chatbots. A plan needs your business figures, not account numbers or ID scans. Use a business plan with data protection if you have one, check the model-training switch in the privacy settings, and give the assistant rounded inputs or labels instead of raw statements.

Will a lender mind that AI helped build the model?

A lender will question the figures, not the tool. Keep the source for every assumption, be able to rebuild any key number by hand, and be ready to explain every tab. If you cannot say where a cell comes from or why it moves, do not send it, however tidy the assistant made it look.

Further reads

• How to Write a Business Plan With AI, and What to Check Yourself — The wider plan around these numbers: market, team and operations.
• Hair Salon Business Plan: Chairs, Prices and Cash Flow With AI — The same cash-flow method on a chair-based business.
• How to Build a 13-Week Cash Flow Forecast With AI Help — Run the short-range cash view once the gym is open.
• Gym Marketing Plan for January: Offers, Emails and Posts With AI — Plan the January launch the forecast depends on.
• Gym Retention Software With AI: What It Costs and Delivers — What it costs to keep the churn assumption honest.
• AI for Gym Owners: Five Jobs to Hand Over First and Two to Keep — Which gym jobs to hand to AI and which to keep.
• Can AI Write a Business Plan for a Food Truck? A Worked Example — A worked food truck plan: AI drafts the text and formulas, you verify menu costs, pitch fees, loan terms and break-even before a lender or organiser sees it.
• AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.

Sources: worked example uses illustrative inputs, not benchmarks; the formulas are standard spreadsheet functions (PMT, MIN, SUM). Lender requirements vary, so confirm coverage, forecast length and security with your own lender.