Break-even analysis shows the sales level at which a product covers all its costs. This template has an Inputs tab for price, variable cost and profit target, a Costs tab for fixed monthly costs, and a Volumes table that shows revenue, cost and profit at different sales levels. The Dashboard shows break-even units, break-even revenue and a chart.

It comes with sample data for a small product business. Make a copy and replace the sample numbers. The break-even figures, volume table and chart update on their own.