Skip to content
The first pages of the Break-Even Analysis Report template

Break-Even Analysis Report

Document template for Google Docs and Word

Make a copy in Google Docs
Price
Free
Style
Minimal
Difficulty
Beginner
Updated
November 5, 2026

Every page (7)

Overview

This template helps small business owners find the sales volume at which income covers every cost. It starts with fixed costs, then the variable cost per unit, the contribution each sale leaves, the break-even point in units and dollars, the margin of safety above it, and a sensitivity page that tests volume and cost shocks together. Each page builds on the one before, so every figure ties back to one set of inputs.

The sample follows Larkspur Partners, a fictional small-batch granola maker that sells 12-ounce bags at $14.00 each. Its monthly fixed costs of $6,240 and variable cost of $6.20 a bag give a break-even volume of 800 bags. Replace the inputs on the first two pages with your own rent, wages, unit price and ingredient costs, then rebuild the tables so the totals still tie out.

Useful for

  • A monthly check on whether a new product line covers its own overheads
  • Deciding whether a price rise or a supplier change is worth the risk
  • Showing a lender how far sales can fall before the business loses money

What's included

  • Seven designed pages in one Google Docs file
  • Fixed cost layers in a monthly cost structure diagram
  • Variable cost table with budget, forecast and actual by line
  • Break-even point with a stacked cost chart and ruled table
  • Margin of safety with a yearly trend and key figures
  • Sensitivity statement with three cases and a make-it-yours guide

How to use it

  1. 1

    Click Make a copy in Google Docs, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Replace the Larkspur sample inputs on pages 1 and 2 with your own rent, wages, unit price and variable costs.

  3. 3

    Rebuild the break-even table and chart from those inputs, and check that the totals still tie to fixed costs.

  4. 4

    Set the upside and downside cases from what has moved in your own market, then name an owner and a reforecast date.

  5. 5

    Delete the guide page, then share the file or present it.

What you need

Requirements

  • A Google account with access to Google Drive

Works with

  • Google Docs
  • Microsoft Word (download the .docx)

Questions

Is this break even analysis template free to use?

Yes. Make a copy in Google Docs and it is yours to edit. There is no sign-up on this page and no charge for the template.

Can I change the figures and the layout?

Yes. Every table, chart and text box uses standard Google Docs styles, so you can change figures, rows and fonts as you would in any document.

Are Larkspur Partners and its figures real?

No. Larkspur Partners, its people and every figure in this sample are fictional. Replace them with your own inputs before you share the document with anyone.

  • #break-even-analysis
  • #financial-projections
  • #margin-of-safety
  • #small-business-finance
  • #google-docs
  • #finance-template

More financial projections templates

See all 6

Also in Finance

All finance templates
Get this template

Preparing your template…