ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / Break-Even Analysis
Free Excel template

Break-Even Analysis

Free Excel break-even analysis: contribution margin, break-even revenue, break-even point in days and as a date, safety margin and ratio, units to sell to break even.

Comptia by Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

Get the template by e-mail, and its updates.

Keep the six files of « Break-Even Analysis » in your inbox, to find or share them later. The direct download stays free, no sign-up.

  • The France, Québec and Africa versions, in French and English.
  • If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
  • Your details are never sold, one-click unsubscribe.
Contents

What the workbook contains.

Break-even

Inputs, results and unit approach

Break-even point

In days of activity and as a date

Safety

Safety margin and ratio

Settings

Currency, fiscal year start

Instructions

Get started in 3 minutes, cells protected without password

Print

One portrait page

How to use it

Up and running in minutes.

  1. 01

    Enter the expected yearly revenue, net of tax.

  2. 02

    Split costs between variable (they follow sales) and fixed.

  3. 03

    Break-even revenue, break-even point and safety margin compute.

  4. 04

    Optional: with unit price and variable cost, get the units to sell.

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
Break-even revenue = fixed costs / contribution margin ratio, where the ratio is (revenue - variable costs) / revenue. With 120,000 of fixed costs and a 50% margin, the business needs 240,000 of revenue to stop losing money.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.