Home / Calculators / Profit levers calculator

Profit levers calculator

Your figures

The levers

A year on your figures

Price–
Volume–
Direct costs–
Overheads–
Profit added a year, all four together–
Added to the value of the business–
Cash from customers paying sooner–
Cash from holding less stock–
Cash from paying suppliers later–
Cash released once–

Sales and costs before VAT, and profit before tax. Set the multiple yourself: buyers value companies at different multiples of profit by sector and size, and a broker or corporate finance adviser can tell you yours. The four profit levers together add slightly more than their sum, because more sales are also sold at the higher price.

How it is worked out

  • Price: sales multiplied by the price rise. Direct costs stay the same, so all of it is profit.
  • Volume: sales multiplied by the increase and by the gross margin.
  • Direct costs: sales less gross profit, multiplied by the cut.
  • Overheads: overheads multiplied by the cut.
  • All four together: sales and direct costs worked out again with every change made at once, less the profit now.
  • Value: the profit added multiplied by the multiple.
  • Customers paying sooner: sales a day multiplied by the days. Stock and suppliers: direct costs a day multiplied by the days.

Questions

What are the profit levers?

Seven figures that between them set a business's profit and cash. Four change profit: price, volume, direct costs and overheads. Three change the cash tied up in the business: how long customers take to pay, how long stock sits before it sells and how long you take to pay suppliers.

Which lever is worth most?

Usually price. A price rise adds to profit without adding to costs, while extra volume adds only its gross margin. On the figures shown, a 1% price rise adds £20,000 and 1% more sales adds £8,000. The break-even and price rise calculator shows how many sales a price rise could lose before it costs you.

Why is the cash only released once?

Cash tied up in debtors, stock and creditors comes out once, when the days change, and stays out for as long as the new terms hold. Profit is added every year. Paying suppliers later should be agreed with them, because a supplier paid late can stop supplying or raise prices.

13-week cash flow forecast template

An Excel workbook with receipts and payments for 13 weeks, the closing balance and the low point worked out, and an example filled in with invented figures.

  1. 1How to use
  2. 2Forecast, blank
  3. 3Example, filled in

Get the template

Excel workbook, three sheets.

Talk to us

Tell us about the business and what is taking up your week, or book 30 minutes with Peter. He will come back within 48 hours with the level that fits and a fixed monthly fee.

Book a call

Or call

07476 989568

Accreditations and partners

AAT Licensed Accountant
ICPA
FreeAgent Partner
Equity & General
All In Place
Xero Gold Partner
Swoop
The Gap
Institute of Advisors