FINANCIAL CALCULATORS AND SPREADSHEET TOOLS
More sales. But more profit?
Check what a discount does to your margins before you launch your next promotion.
Discount promotion calculator
Example figures are pre-filled. Replace them with your own estimates and use the same period for both scenarios.
Your promotion forecast
Change in total profit
—| Measure | No promotion | With discount |
|---|---|---|
| Selling price per order | — | — |
| Cost per order | — | — |
| Profit per order | — | — |
| Projected orders | — | — |
| Projected revenue | — | — |
| Total profit | — | — |
Projected orders use your estimate, rounded to the nearest whole order. Required orders are rounded up.
Understand the numbers
1. Enter normal trading
Use one representative basket and the orders you would normally receive during the campaign period.
2. Test your discount
Choose a discount and estimate the change in order volume. Adjust either figure to test different outcomes.
3. Compare profit
More revenue does not necessarily mean more profit. Compare the forecast with the orders required to match normal trading.
Assumptions and calculation detail
All amounts use consistent tax-exclusive figures in AUD and one representative order. Cost per order includes payment fees and stays the same in both scenarios. Percentage-based fees may fall when you discount; this simple calculator does not adjust them separately. Shipping income, returns, refunds, overheads, tax and one-off campaign costs are excluded. Results estimate profit before overheads and tax, not net business profit. The expected order increase is your assumption, not a prediction.
Discounted price = normal price × (1 − discount).
Profit per order = selling price − cost per order.
Total profit = profit per order × orders. Required orders = normal total profit ÷ discounted profit per order, rounded up.
Plan the whole promotion
Compare a discount with free shipping. Include advertising and one-off costs, save your campaign plans, and see how different order increases affect profit.
Promotion planner
Includes a reusable Excel planner, completed example and quick-start guide.
View the Excel planner$29.00 AUD one-off. No subscription.
Practical tools. Clearer decisions.
Coombs Wealth creates financial calculators and practical spreadsheet tools to help you understand your numbers and compare your options. Start with our free promotion calculator, then explore the assumptions in the Excel planner.