Kolumn

14 / 20 · Budget and finance

Break-even analysis

How much you need to sell to break even.

SEK 89

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

How much do you need to sell to break even? Enter fixed costs per month, price and variable cost per unit, and the template works out the break-even point in units and money, the safety margin, and draws a chart.

What you get

Sheets
Break-even
Each file also has an instructions sheet and a lists sheet.
Formulas
91
Charts
1
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Enter fixed costs per month (rent, salaries, insurance …).
  2. Enter price excl. tax and variable cost per unit.
  3. Enter expected sales per month to see the safety margin.
  4. The table and chart show revenue, cost and profit at different volumes.