Free toolkit

BFCM Promo Margin Calculator

Three calculators that show what a discount, a tiered offer or a bundle does to your profit per order, with live formulas.

  • Discount break-even and sensitivity
  • Tiered "spend more, save more" model
  • Bundle vs hero product comparison

Excel workbook

Get the free toolkit

Tell us where to send it. It is free.

We use your details to respond to this request. See our Privacy Policy.

What is inside

3 parts, ready to use

  1. Discount break-even

    How many more orders a percentage discount needs just to earn the same gross profit as no offer, from 5% to 40% off.

  2. Tiered offer

    Profit per order across your spend thresholds, based on how you expect orders to spread across the tiers.

  3. Bundle

    Whether a bundle earns more per sale than the product most customers would have bought anyway.

Preview

What you put in, and what you get

Yellow cells are inputs, everything else is calculated. Works in any single currency.

  1. Price, product cost and units per order
  2. Payment fees and fulfilment cost per order
  3. Your planned discount and baseline orders
  4. Break-even uplift and a plain-English verdict
  5. Profit per order for each tier and bundle

How to use it

Open the workbook in Excel or Google Sheets, replace the example values in the yellow cells with your own, and read the verdict under each calculator. Your Shopify reports give you average order value and orders; product costs come from each product’s cost per item; fees and shipping from your provider invoices.

The figures are planning estimates. They leave out returns, taxes, marketing spend and the lifetime value of new customers, so treat them as a floor for the decision rather than a forecast.

It is the companion to our guide to BFCM offers that protect your margin. If you want a second opinion on your offer plan, talk to our team.

Who it is for

Who gets the most from it

  • Shopify brands deciding on Black Friday offers
  • Founders and finance leads checking promotion margins
  • Marketers who need to defend an offer to the business

BFCM Promo Margin Calculator

Get the free toolkit

Get it now

Prefer to just talk it through?

Tell us where it hurts. We will tell you honestly whether we are the right people for it.

Talk to an expert Book 30 minutes