Break-Even Planner Template: Fixed and Variable Cost Analysis for UK Limited Companies

Separating Fixed and Variable Costs

The foundation of break-even analysis is the clean separation of costs that exist regardless of output (fixed) from costs that move with volume (variable). Common errors include treating semi-variable costs — utilities, maintenance, certain labour — as entirely fixed, which overstates the true break-even point.

• Fixed costs: rent, rates, insurance, senior management salaries, depreciation, loan interest, software subscriptions
• Variable costs: direct materials, sales commissions, delivery costs, packaging, processing fees charged per transaction
• Semi-variable: allocate the fixed portion to fixed, the incremental portion to variable — the planner includes a split row for this

Calculating the Break-Even Point

Contribution margin per unit = selling price minus variable cost per unit. Break-even units = total fixed costs divided by contribution margin per unit. Break-even revenue = break-even units multiplied by selling price. For multi-product businesses, use a weighted average contribution margin based on the expected sales mix.

The planner presents both the unit and revenue break-even because different audiences use different metrics. Operations directors think in units; finance directors and lenders think in revenue. Present both in any board paper or lender pack.

Sensitivity Analysis Within the Planner

The most valuable output is not the break-even point itself but the sensitivity of that point to changes in price or volume. A 5% price reduction on a product with a 40% contribution margin moves the break-even revenue up by approximately 14% — a non-obvious relationship that the planner makes explicit.

The sensitivity section of the planner tests three scenarios: a 10% price reduction, a 10% volume reduction, and a 10% increase in a key variable cost. Each produces a revised break-even point. Directors should know which of these sensitivities is most material to their business and have a response plan prepared.

Using Break-Even Analysis to Size a Loan Repayment

Adding the annual debt service obligation — principal plus interest — to the fixed cost total produces a cash break-even that is higher than the accounting break-even. This is the revenue level below which the business cannot service the proposed borrowing from operating cash flow. Any facility that pushes the cash break-even above the downside revenue scenario in your planning model carries repayment risk that requires explicit acknowledgement.

Confirm all cost categorisations and the resulting break-even figures with your accountant. The planner is a planning tool; it does not constitute financial advice.