Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingBreak-Even Analysis

SpreadsheetFinancial Statements & ReportingFree

Break-Even Analysis

Units and revenue needed to cover costs for each product, with margin of safety at your expected sales.

Shown with sample data

Colour

Break-Even Analysis

Units and revenue needed to cover costs for each product, with margin of safety at your expected sales.

Expected monthly profit
$5,110
Fixed costs to cover
$30,500
Products below break-even
1
Expected profit by product
  • Standard plan$2,700
  • Team plan$1,770
  • Onboarding package$840
  • Starter kit$580
  • Annual support-$780

How to use it

  1. 1List each product with price and variable cost per unit.
  2. 2Allocate monthly fixed costs across products.
  3. 3Enter the units you expect to sell.
  4. 4Change price or cost to see how the break-even point moves.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Find out how much you have to sell before you make money. For each product enter the price, variable cost per unit and its share of fixed costs; the sheet calculates contribution margin, break-even units and revenue, and how far your expected sales sit above or below that line.

Who it’s for

  • Pricing decisions
  • New product launches
  • Testing a business idea

What’s included

  • Products sheet: One row per product.
  • Summary by Category sheet: Expected profit and the number of entries for each category, calculated from the Products sheet.

How to use it

  1. 1List each product with price and variable cost per unit.
  2. 2Allocate monthly fixed costs across products.
  3. 3Enter the units you expect to sell.
  4. 4Change price or cost to see how the break-even point moves.
Related searchesbreak even analysisbreak even pointcontribution marginpricingcost volume profit

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial Statements & ReportingFree

Break-Even Analysis

Units and revenue needed to cover costs for each product, with margin of safety at your expected sales.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More financial statements & reporting templates

View all
Small Business Profit and Loss Statement3 sheets

Revenue

$54,650

Gross margin

64%

Net profit

$7,460

Net profit by month
$7,460
$6,365
$3,620
$3,080
$1,650
Nov 2026Oct 2026Sep 2026Jul 2026Jun 2026
SpreadsheetFinancial Statements & Reporting

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

10 min setupPreview
Monthly Financial Dashboard2 sheets

Revenue this month

$655,000

Revenue, last 12 months

$7,013,000

EBITDA margin this month

16%

EBITDA by month
$57k
$38k
$62k
$79k
$78k
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetFinancial Statements & Reporting

Monthly Financial Dashboard

One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.

10 min setupPreview
Trial Balance2 sheets

Adjusted debits

$57,150

Adjusted credits

$57,150

Difference

$0

ABCD
1AccountTypeDebitCredit
2BankAsset$18,400$0.00
3Accounts receivableAsset$6,200$0.00
4Prepaid insuranceAsset$1,200$0.00
5EquipmentAsset$9,000$0.00
Trial balance
SpreadsheetGeneral Ledger & Trial Balance

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ