Financial calculator templates

A break-even analysis shows how many sales you need before a product or business covers its fixed and variable costs. It is the starting point for setting a selling price and for any startup financial model.

Include fixed costs, variable cost per unit, selling price per unit, break-even units, break-even revenue, and sales scenarios. Test the model with a cautious sales figure as well as your hopeful one, because the break-even point moves quickly when sales fall short.

The break-even point is the sales level at which total revenue equals total costs. Below it you make a loss, and above it you make a profit.

Divide fixed costs by the contribution per unit, which is the selling price minus the variable cost per unit. The answer is the number of units you must sell to cover all costs.

Most startup models cover three to five years, with monthly detail for the first year or two. Keep the assumptions visible so you can update them as real results come in.

Start with Break-Even Analysis: Work out how many units you must sell to cover your costs, and how profit changes with volume. If that is not the right fit, compare it with Product Pricing Calculator.

The templates here are 3 to 5 pages long. Cut any section you do not need; each template explains what its sections are for.

Yes. These financial calculator templates work in Google Sheets and Microsoft Excel. All 3 templates are free, with no account or email needed.