Skip to main content
Calculator and pen on a sheet of paper, break-even arithmetic

Table Of Contents

SUP: the break-even sheet that turns a business idea into a number of customers

Disclosure: City Profit builds SUP and sells services based on it. The repair-specialist sheet is the example from our lessons. The second table is a real tab from our own financial model.

SUP is the break-even sheet we fill in before anyone spends money. It answers one question: how many customers a month do I need so that the business pays back in the time I chose? The answer is a number of people, not a number of dollars, and people are something you can go and find.

A repairman working on a pipe inside a wall

A repair specialist, one sheet

Take someone who repairs flats and wants to become a business. Below is the sheet we give students, with fourteen things to buy before the first order and four monthly bills.

SUP calculator (Google Sheets)
Idea: flat repair specialist. Cost itemCostQtyStart totalMonth qtyMonth total
1Order a one-page website500150000
2Order copywriting100110000
3Photo shoot100110000
4Collect reviews and put them on the site1011000
5Make a Facebook page5015000
6Pay a promotion specialist20012001200
7Site form linked to Google Sheets and Mailchimp5015000
8PDF: top 10 things to know before ordering a flat repair100110000
9PDF: top 10 reliable, comfortable, good-looking kitchens100110000
10PDF: how to build a comfortable, functional bathroom100110000
11Facebook ads budget20012001200
12Google ads budget20012001200
13OLX ads budget20012001200
14Register the business2012000
Total1 930800
Pay back in (months)16months
All costs25 930
My average check3 000dollars
Cost price340%materials + paying the crew who are used to working fast, cheap and very well
Net profit per check1 800dollars
All costs per month988
Repairs needed to break even41check per month
And if I do4checks, then net profit is 6,212 a month
SUP
The sheet from our lessons. Green cells are what you type. The rest is arithmetic.
  1. The payback window is your patience. Six months says: I want this money back by month six. Choose it before you look at the rest.
  2. All costs = start + monthly x (months – 1). 1,930 + 800 x 5 = 5,930. The first month carries the setup, the others carry the bills.
  3. Margin is the check minus everything that grows with it. 3,000 minus 40% leaves 1,800 per repair.
  4. The answer is customers. 5,930 / 6 = 988 a month, and 988 / 1,800 = 0.55, so one repair a month breaks even. Four repairs earn 6,212. A person can go and find four repairs.

Change the numbers

The calculator below holds the same sheet. Double the average check, cut the payback window to three months, raise the cost price. Watch which input moves the answer most.

How many customers do I need?

Defaults are the repair specialist. Replace them with your own business.

–all costs in the window
–fixed monthly target
–margin per customer
–customers a month to break even
–net profit at my customers
Easy to reach. Three customers or fewer a month is a number you can find in your own network. Realistic but it needs a channel. Plan the funnel before you spend. Hard. More than fifteen customers a month means you need a repeatable funnel or a higher margin product. The margin is zero or negative. No number of customers pays this back.

All costs = start + monthly x (months – 1). Fixed target = all costs / months. Customers = fixed target / margin, rounded up.

The same sheet at company size

A repair specialist has fourteen lines. A company has the same lines with bigger numbers. Below is the SUP tab of the model we built for our own product.

MOMO – Financial Model (EN).xlsx
Cost itemUnit cost (start)Qty (start)Amount (start)Qty (month)Amount (month)
3Payroll: SEO copywriter556155621 112
4Payroll: operations / PM66716671667
5Legal (outsource, one-time)333133300
6Accounting (outsource)22212221222
7Laptops (2 units)88021 76000
8Automation (n8n, integrations)556155600
9CRM / email / hosting / subscriptions33313331333
10Website + funnel (WordPress + Breakdance)926192600
11Google Ads (own funds)41714171417
14Total6 4562 918
16Target payback (months)6
17All costs21 046
18Fixed monthly target3 508
22Sell at (price B)92 EUR
24Margin B82 EUR
25B clients a month to cover fixed43
29Product A: price4 630 EUR
31A clients a month to cover fixed1
SUPABCRFunnelsBFMPOSCO
Shortened: the full tab has the same blocks. Amounts in the first table are in EUR, in the Ukrainian model in UAH.
43 / 30B customers a month to break even, EN model / UA model
1 / 2A customers a month to break even, EN / UA

Read the two highlighted cells together. Covering the fixed costs with product B alone takes 43 customers a month. With product A it takes one. That one comparison is the reason the ABCR ladder has an expensive step.

Four lines founders forget

  • Your own salary. If it is not in the sheet, you work for free and call the result profit.
  • Flex costs. Card fees, tax and discounts grow with every sale. Margin is the price minus all of them, not minus materials only.
  • A payback window that is too short. Three months for a service that takes two months to sell makes the target unreachable. Choose six to twelve.
  • Revenue instead of margin. The sheet divides by margin, never by the price. A 3,000 check is 1,800 of margin.

SUP next to the methods you know

Method
What it does
Where SUP differs
Break-even analysis
Finds the sales volume at which profit is zero.
SUP adds a payback window, so zero is reached by a chosen month, and expresses the result in customers.
Unit economics
Tracks acquisition cost and lifetime value per customer.
SUP comes first and is simpler. Unit economics enter later, in the BFM.
Runway calculation
Counts how many months the cash lasts.
Runway counts months of cash. SUP counts customers you must win.
Lean canvas cost structure
A list of cost types in a box.
SUP puts a number and a quantity on every line and ends in an answer.

The price in the sheet comes from POSCO. Once you know how many customers you need, the funnel shows where they will come from. We fill these sheets for clients at Bizon Planner, and students at mdopen.pro fill their own.

The City Profit technologies series

Previous: POSCO | Next: ABCR | Overview: the seven-step go-to-market guide | All technologies

FAQ

What does SUP show?

The number of customers you must win each month so that all start and monthly costs are paid back inside the window you chose.

Why is the answer in customers, not in money?

Money targets are abstract. A number such as four repairs a month is concrete: you can count your network and decide whether it is realistic.

How long should the payback window be?

Six to twelve months for most small businesses. Shorter windows push the target above what a new business can sell.

What counts as a flex cost?

Anything that grows with each sale: materials, payment fees, tax, commission, delivery. Subtract all of them from the price to get the margin.

What comes after SUP?

The BFM, which lays the same numbers over 13 or 25 months with a funnel for every channel.

Sources and further reading

  1. Break-even (economics) (Wikipedia)
  2. Cost-volume-profit analysis (Wikipedia)
  3. Fixed cost (Wikipedia)
  4. Overview: how to build a B2B offer and go-to-market strategy

Want this done on your numbers? Book a free 30-minute audit with Volodymyr Pimenov.

Book the free auditSee City Profit services

More materials by CITY PROFIT.

CITY PROFIT TRADEMARK. 3080422932. UA