A simple break-even analysis template helps you estimate the sales needed to cover your fixed and variable costs. Use the worksheets below to organize your assumptions, compare prices and calculate a sales target before committing to a product, service or business idea.
This collection includes 13 free downloads: 10 Word documents and 3 Excel workbooks, supplied in ZIP files. Choose an editable worksheet for recording costs or a spreadsheet for working with numbers. Check the notes beside each download: the files do not all calculate results automatically.
Free Break-Even Analysis Templates for Word and Excel
Download and extract the ZIP file before opening the document or workbook. Replace sample figures, company details and instructions with your own information. Review the calculations before using any result to make a decision.
01. Cost Classification Worksheet
File format: Word (.docx), inside a ZIP file.
A table for recording fixed costs, variable cost percentages and variable cost amounts. Use it to organize inputs before calculating your sales threshold.
A sample layout showing revenue shares, selling prices, product costs and monthly unit targets for six products. Although its text refers to spreadsheet formulas, this download is a Word document; calculate and verify the results separately.
An explanatory document with manufacturing and hourly service examples. Adapt its assumptions carefully: an income target that includes owner compensation differs from a basic operating break-even calculation.
A blank layout for fixed costs, variable unit costs, selling price, expected unit sales and break-even units. Use the formulas below to complete the calculation.
A fill-in worksheet using projected annual sales, overhead and job costs. Use the contribution margin ratio formula below to interpret its layout. Its suggested timing estimate assumes even sales and costs throughout the year.
A compact form for listing variable cost percentages, fixed costs and a break-even sales level. Separate cash payments from accounting expenses before completing it.
Includes formulas for cost totals, per-unit costs, break-even units and revenue. Keep the production capacity and variable cost assumptions consistent. The summary sentence contains the original sample figures, so update it manually when you change inputs.
A company and financial-year worksheet with columns for fixed costs, variable cost percentages and variable cost amounts. Replace the zero placeholders with your own figures.
Provides an assumptions and comparison layout for units, revenue, fixed costs, variable costs, total costs and profit. The workbook contains no cell formulas; add and check your calculations before treating it as a calculator.
A discussion guide for reviewing transaction values, sales targets and business performance. It describes calculator inputs but is not an Excel calculator. Keep cash targets separate from operating break-even results.
A detailed cost-entry table for a business review. Classify each item according to how it behaves in your business rather than relying only on its position in the form.
Uses cost tables and formulas to estimate sales from fixed costs and variable cost percentages. Enter variable costs as percentages of revenue. The layout also includes debt principal and owner drawings; exclude those from an operating-profit calculation or identify the result as a separate cash target.
Provides fields for period costs, units sold and average selling price. Its printed break-even units formula divides existing total costs by price and does not account for variable costs increasing with volume. Replace that calculation with fixed costs ÷ (price per unit − variable cost per unit).
Your break-even point is the sales level at which total revenue equals the costs included in your model. At that point, the modeled profit is zero. Sales above that level can generate a profit if your selling price, variable cost per unit and fixed costs remain consistent with your assumptions.
Use it to assess whether a sales target is realistic, compare pricing options or test the effect of a cost increase. It does not establish demand, guarantee profitability or show when customers will pay you.
How to Calculate Your Break-Even Point
Choose a period. Use monthly fixed costs for a monthly sales target, or annual fixed costs for an annual target.
Total fixed costs. Include costs that remain broadly unchanged within the sales range you are analyzing, such as rent and base salaries.
Calculate variable cost per unit. Include costs that increase with each sale, such as materials, packaging, per-sale commissions and transaction fees.
Set the selling price per unit. Use a consistent basis for revenue and costs, allowing for expected discounts.
Calculate the contribution margin. Subtract variable cost per unit from selling price per unit. This amount contributes toward fixed costs and then profit.
Calculate and check the sales target. Divide fixed costs by contribution margin per unit, then round up when you sell whole units.
Core break-even formulas
Measure
Formula
Contribution margin per unit
Selling price per unit − Variable cost per unit
Break-even units
Fixed costs ÷ Contribution margin per unit
Contribution margin ratio
Contribution margin per unit ÷ Selling price per unit
Break-even sales revenue
Fixed costs ÷ Contribution margin ratio
Units needed for a target profit
(Fixed costs + Target profit) ÷ Contribution margin per unit
Check the denominator: if contribution margin is zero or negative and fixed costs are positive, increasing sales under those assumptions will not produce a finite break-even point. Revisit the price, costs or business model.
Simple Break-Even Analysis Example
Suppose a business has monthly fixed costs of $6,000. It sells one product for $50, with variable costs of $30 per unit.
Contribution margin per unit: $50 − $30 = $20.
Break-even quantity: $6,000 ÷ $20 = 300 units per month.
Contribution margin ratio: $20 ÷ $50 = 40%.
Break-even revenue: $6,000 ÷ 0.40 = $15,000 per month.
At 300 units, revenue is $15,000 and total costs are $6,000 + (300 × $30) = $15,000. At 400 units, modeled profit is (400 × $20) − $6,000 = $2,000. A $3,000 monthly profit target would require ($6,000 + $3,000) ÷ $20 = 450 units.
Check These Assumptions Before Using Your Results
Classify costs by behavior. Direct costs are not always variable, and indirect costs are not always fixed. Split mixed costs into fixed and variable portions where practical.
Avoid double counting. Do not add raw materials, inventory purchases and cost of goods sold together if they represent the same underlying cost.
Separate profit from cash requirements. Debt principal repayments and owner drawings are generally cash outflows rather than operating expenses. Depreciation is an expense without a matching current cash payment. Build a separate cash forecast for payment timing.
Allow for changes in capacity. Extra premises, staff or machinery can increase fixed costs when sales exceed the current operating range.
Check your product mix. For several products, use a contribution margin weighted by a realistic sales mix. A shift toward lower-margin items changes the break-even target.
Test alternatives. Compare a realistic base case with lower prices, higher unit costs or higher fixed costs. Confirm that the required sales are achievable.
Which download should I choose for a simple calculation?
Template 04 provides a straightforward Word layout for recording fixed costs, variable unit costs and price. Template 07 includes Excel formulas for a monthly production scenario. Review its assumptions and update the sample summary text after editing the numbers.
Do all the Excel templates calculate automatically?
No. Templates 07 and 12 contain formulas, while Template 09 has no cell formulas. Word downloads are document layouts or guidance, so do not assume that instructions referring to a calculator mean the file will calculate your results.
Can I use a break-even template for a service business?
Yes. Define the unit as a billable hour, appointment or completed job. Deduct the variable cost of delivering that unit from its price, then divide fixed costs by the resulting contribution margin. Check whether you have enough billable capacity to reach the target.
Is contribution margin the same as gross profit?
Not necessarily. Contribution margin subtracts variable costs from revenue. Gross profit subtracts cost of goods sold, which may include fixed production costs and may exclude variable selling costs. Use contribution margin for the formulas on this page.
Does reaching break-even mean I have enough cash?
No. Customers may pay later than your bills fall due, and loan repayments or inventory purchases may create additional cash needs. Check a cash forecast alongside the break-even analysis.
Pingback: Free Small Business Plan Templates for Word: 6 Options