Skip to content
← TemplatesFinance & modelling

Free Break-even & Pricing Calculator (Excel) — Kenya

Two questions decide whether a business survives: how much must I sell to cover my costs, and what should I charge? This free calculator answers both. Enter your fixed costs, the cost of one unit and your price, and it shows your break-even point; type a cost and a target margin, and it gives you the price to charge.

Download free — Excel (.xlsx) ↓Opens in Excel or Google Sheets · no sign-up

What's inside

  • Break-even units and revenue from fixed costs, variable cost and price
  • Contribution per unit and contribution margin worked out
  • Profit-at-volume table (loss red, profit green)
  • Price to a target margin — or the margin from a price you set
  • Change any input and everything recalculates instantly

The tabs

  • Start Here (guide)
  • Break-even
  • Pricing

Yellow cells only. You type in the yellow cells; the rest are locked formulas. Gridlines are off and it prints clean on A4.

The Break-even tab takes three inputs — monthly fixed costs, variable cost per unit and selling price — and computes your contribution per unit, contribution margin, and the exact units and revenue you need each month to break even. A profit-at-volume table then shows your profit or loss at 50, 100, 200… units, with losses in red and profits in green, so you can see the volume where you start making money.

The Pricing tab works the other way: enter a product's cost and the margin you want, and it gives you the price to charge, the markup and the profit per unit — or enter a price and see the margin it delivers. Change any yellow number and everything recalculates instantly, so you can test a price before you commit to it.

It's the maths behind every sound pricing decision, done for you. To see what's actually selling and at what margin once you're trading, pair it with the free Sales Dashboard for SMEs.

Do it online instead

Explore our free business tools

Open the free tool →

Frequently asked questions

How is the break-even point calculated?

Break-even units = fixed costs ÷ contribution per unit, where contribution per unit = selling price − variable cost. Break-even revenue is those units × price. Below that volume you make a loss; above it, a profit — the profit-at-volume table shows exactly where the line is.

How do I price to a target margin?

On the Pricing tab, enter the product's cost and the margin you want (say 40%). The price = cost ÷ (1 − margin), so a KES 300 cost at 40% margin gives a KES 500 price. It also shows the markup and profit per unit.

Does it work in Google Sheets?

Yes — upload the .xlsx to Google Drive and open it with Google Sheets; every formula recalculates as you change the inputs.