Free Break-Even Analysis Template
Estimate the sales needed to cover the costs you enter. Includes single-product formulas and step-by-step guidance.
What Is This Template?
A break-even analysis is one of the most important calculations a business owner or entrepreneur can perform. It tells you the exact point at which your total revenue equals your total costs — the moment your business stops losing money and starts generating profit.
Knowing your break-even point removes guesswork from business decisions. Before launching a new product, opening a second location, hiring a new employee, or raising prices, a break-even calculation shows you whether the numbers stack up. It answers the fundamental question every investor, lender, and business owner wants answered: how much do we need to sell to make this work?
Our free break-even analysis template uses the standard contribution margin method and covers three key calculations: break-even in units, break-even in revenue, and margin of safety (how far above break-even you currently are or need to be). It contains a calculation sheet and an Instructions sheet. Change the inputs to compare scenarios manually; it does not include charts or a multi-product model.
The template is suitable for product businesses, service businesses, and businesses evaluating new ventures or pricing changes.
Who Should Use This Template
- Startup founders evaluating whether a business concept can generate sufficient revenue to be viable before investing significant capital
- Product business owners deciding on pricing strategies and needing to know the minimum price that covers costs
- Service businesses calculating the minimum monthly client revenue or hours billed to cover overheads
- Entrepreneurs preparing business plans for investors or bank loans that require financial viability analysis
- Existing business owners evaluating whether a new product, service, or pricing change makes financial sense
- Freelancers setting minimum monthly billing targets to cover business and personal costs
How To Use This Template
- Step 1 — Enter fixed costs. Enter fixed operating costs such as rent, insurance, employee wages and software subscriptions. Exclude loan principal repayments and owner draws: they use cash but are not accounting expenses. For a separate cash-coverage target, add full debt-service payments and planned draws to the operating cash costs, without counting interest twice. Label that result cash coverage, not operating break-even.
- Step 2 — Enter selling price per unit. Enter the price at which you sell one unit of your product or service. For service businesses, this is your average fee per client or project.
- Step 3 — Enter variable cost per unit. Enter the cost of producing or delivering one unit: materials, direct labour, packaging, commissions, or delivery costs.
- Step 4 — Review the contribution margin. The template calculates: Contribution Margin = Selling Price − Variable Cost. This is how much each unit sold contributes toward covering fixed costs.
- Step 5 — Read your break-even point. Break-Even Units = Fixed Costs ÷ Contribution Margin. Break-Even Revenue = Break-Even Units × Selling Price. The template calculates both automatically.
- Step 6 — Check your margin of safety. If you already know your current sales volume, enter it to see how far above or below break-even you are operating. This is your margin of safety.
Formula and calculation model
- Contribution Margin per Unit = Selling Price − Variable Cost per Unit
- Break-Even Units = Fixed Costs ÷ Contribution Margin per Unit
- Break-Even Revenue = Break-Even Units × Selling Price
- Margin of Safety (units) = Expected Monthly Unit Sales − Break-Even Units
Assumptions in this version
- The workbook uses a single product or single blended unit assumption with one contribution margin figure.
- Fixed costs, selling price, and variable cost are treated as constant for the period you are planning.
- The model is for planning and does not auto-adjust for changing price mix, demand volatility, or discounting.
What this template does not include
- It does not model tax, financing, deferred payment timing, returns, or churn from late collection.
- It is not a multi-product worksheet; mixed product portfolios require separate assumptions or weighted margins.
- Use a positive selling price and contribution margin for the sales threshold. Break-even shows N/A when price or contribution is zero or negative, or fixed costs are negative. Margin of safety percentage also shows N/A at zero expected sales.
Example Scenario
Jake's Custom T-Shirt Business — Break-Even Calculation
Jake is launching an online custom t-shirt business and wants to know how many shirts he needs to sell each month to break even.
- Fixed costs (platform fees, marketing, insurance): $800/month
- Selling price per shirt: $35
- Variable cost per shirt (blank shirt, printing, packaging, shipping): $14
Using the break-even template:
- Contribution margin = $35 − $14 = $21 per shirt
- Break-even units = $800 ÷ $21 = 38.1 shirts/month (round up to 39)
- Continuous break-even revenue = ($800 ÷ $21) × $35 = $1,333.33/month; selling the minimum 39 whole shirts produces $1,365 revenue
Jake needs to sell 39 whole shirts per month to cover the costs entered. At 60 shirts, profit is 60 × $21 − $800 = $460. Use fixed costs in the profit calculation, not the rounded sales threshold: 39 shirts already produce $19 profit. These results exclude costs and taxes not entered in the model.
Common Mistakes to Avoid
- Mixing up fixed and variable costs. A cost is only variable if it changes directly with each unit sold. Salaries for staff who work regardless of sales volume are fixed costs, not variable.
- Using an average price when you sell multiple products. If you sell a range of products at different prices, calculate a weighted average contribution margin separately using your expected sales mix. This workbook has no multi-product worksheet.
- Forgetting your own salary. Your time has a cost. If you are working full-time in the business for free, your break-even calculation is understating true costs. Include employee-owner wages where applicable. For a sole proprietor, calculate a separate sales target to fund an owner draw; the draw is not an accounting expense.
- Treating break-even as a goal, not a floor. Break-even means zero profit. Your real target is a margin above break-even that pays you adequately and funds growth.
- Ignoring taxes. Your break-even in pre-tax revenue is not the same as in post-tax profit. Ensure your target sales level generates enough post-tax income to meet your personal financial needs.
Methodology & Accuracy
How this template produces its results, and the limits you should keep in mind when using them.
- Formula source
- The result is produced by the exact mathematical formula shown on this page. The formula is derived from the definition of the relationship between the inputs and the output (for example, profit margin is profit divided by revenue by definition). Where a formula relies on an external rule, rate, or convention, the authoritative source supporting that claim is linked in the Sources section below. The calculation has not been certified or approved by any professional body.
- Assumptions
- Calculations assume the figures you enter are accurate and apply to your situation. These are simplified models that may not capture every business scenario, and the estimates depend entirely on the values you select.
- Uncertainty and limitations
- Results are estimates based on the information entered. Actual financial outcomes may differ depending on business circumstances, market conditions, taxes, location, and other factors.
- Jurisdiction limitations
- Financial rules, taxes, lending practices, and business requirements may vary by location. Consider local requirements when making financial decisions based on these results.
- Tested with sample inputs
- The formulas in this template have been checked using the sample figures shown in the workbook to confirm the calculation logic produces expected results.
- Ownership and testing
- This template is maintained by Small Business Finance Toolkit. Its calculation can be checked using the sample figures shown on this page. It has not been certified or reviewed by a licensed financial professional. Found an error or outdated information? Contact us.
- Review status
- Sample checks are listed above where available. This page is documented as an educational tool and is updated before major edits using a documented review process.
Download Free Template
Calculate your break-even point with built-in formulas for units, revenue, contribution margin, and margin of safety. Contains a single-product calculation sheet and an Instructions sheet; no chart or multi-product worksheet.
No sign-up required. Download, customize, and use the template for your own business needs.
- Free to use
- Editable formulas
- Example data included
- Instructions tab
- Google Sheets compatible
- No sign-up needed
Sources and references
The notes below identify the topics each reference supports. Worked scenarios and calculator outputs are illustrations, not endorsements by these organizations.
- U.S. Small Business Administration — Plan your business: Break-even pointU.S.See the “Break-even point” section for the unit formula and fixed/variable cost definitions. This is a planning estimate under stated assumptions.https://www.sba.gov/counseling/plan-your-business/
Published and maintained by Small Business Finance Toolkit
Content updated: September 2026
This template was created using standard break-even analysis concepts, including fixed costs, variable costs, contribution margin, and required sales volume. It helps business owners understand the relationship between costs, pricing, and profitability. The template is an educational resource and does not replace professional accounting or financial advice.