Free download. No sign-up, no email.
Download Excel (.xlsx)6 KBWho this template is for
- Owners setting prices
- Anyone writing the financial section of a plan
- Businesses testing a new product
How to fill it in
- Enter monthly fixed costs.
- Enter your average selling price.
- Enter the variable cost per unit.
- Read break-even units and revenue.
- Use the table to see profit at other sales levels.
What is inside
- Sheet: Break-Even
- Input
- Monthly fixed costs (rent, salaries, insurance...)
- Average selling price per unit
- Variable cost per unit (materials, commissions...)
- Result
- Contribution margin per unit
- Contribution margin ratio
- Break-even units per month
- Break-even revenue per month
- Break-even units per day (30 days)
- % of break-even
Writing a full business plan?
Browse 39 free sample plans by industry, each with startup costs and projections.
Frequently asked questions
What is the break-even formula?
Break-even units equal fixed costs divided by price minus variable cost per unit.
Why does break-even matter to lenders?
It shows how realistic your sales targets are and how much room you have if sales come in low.
Is this break-even analysis template free to use?
Yes. Download it, edit it and use it for your own business at no cost. No account or email address is required.