Skip to content

Break even analysis

Find how many units you must sell to cover your costs, with a chart of sales against costs.

Break even analysis template, first page

Fill it in and preview

Break even analysis

A spreadsheet that shows how much you must sell to cover your costs. Enter the selling price, the variable cost of each unit and your fixed costs and it gives the contribution of each unit, the break even units and sales, your profit and margin of safety at the units you expect, and a table and chart of sales against total cost. Download it as Excel, OpenDocument, PDF or CSV.

Break even

Break even analysis

Fill in the yellow cells. The units and sales you need to cover your costs are worked out below.

Product or service Handmade candles

Selling price per unit 18.00

Variable cost per unit 6.50

Fixed costs per period 2,300.00

Expected units sold per period 260

Result Words shown
Contribution per unit 11.50 Not reachable
Contribution margin 63.9%
Break even units 200
Break even sales 3,600.00
Profit at expected units 690.00
Margin of safety 23.1%
Units sold Sales Total cost Profit
0 0.00 2,300.00 -2,300.00
40 720.00 2,560.00 -1,840.00
80 1,440.00 2,820.00 -1,380.00
120 2,160.00 3,080.00 -920.00
160 2,880.00 3,340.00 -460.00
200 3,600.00 3,600.00 0.00
240 4,320.00 3,860.00 460.00
280 5,040.00 4,120.00 920.00
320 5,760.00 4,380.00 1,380.00
360 6,480.00 4,640.00 1,840.00
400 7,200.00 4,900.00 2,300.00

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

What this template is for

A break even analysis spreadsheet: enter price, variable cost and fixed costs to see break even units and sales, the margin of safety and a cost chart.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Finance and accounting templates All free Excel and spreadsheet templates

Finance and accounting

What you fill in

The form asks for 5 details. The document fills itself in as you type.

  • Product or service

    For example: Handmade candles

  • Selling price per unit

    For example: 18

  • Variable cost per unit

    What each unit costs you to make or deliver: materials, packaging, fees.

    For example: 6.50

  • Fixed costs per period

    Costs that stay the same however much you sell: rent, salaries, subscriptions.

    For example: 2300

  • Expected units sold per periodoptional

    For example: 260

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1A spreadsheet that shows how much you must sell to cover your costs. Enter the selling price, the variable cost of ea...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Finance and accounting

Questions people ask

What details does this template ask for?

The form asks for 5 details, starting with Product or service, Selling price per unit, Variable cost per unit, Fixed costs per period. 1 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

The analysis assumes one price and a steady cost for each unit. Real costs change with volume and discounts, so use it to compare options, not as a forecast.

Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.