← All free resources
Spreadsheet
Simple Pricing Calculator
Underpricing is one of the most common reasons small businesses work hard but make little profit. Knowing your true cost per unit and the margin you need makes it much easier to set prices with confidence.
This simple Excel pricing calculator takes your direct costs, overheads, expected sales and target margin, then works out the price you should charge (with and without GST), your profit per unit and how many sales you need each month to break even.
What’s inside
- Inputs for direct costs, labour, overheads and volume
- Price to hit your target margin, excluding and including GST
- Profit per unit, markup and monthly break-even point
- A quick explanation of margin versus markup
Who it’s for
Product and service businesses setting or reviewing their prices.
General guidance only — not legal, tax or financial advice.