Discount & Promo Margin Calculator

See how many extra sales a discount needs to keep the same profit, product by product, before you run the promotion.

Type price, unit cost, current monthly units, the discount and the extra units you expect. The file compares profit before and after.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Settings — Your currency. You fill in: Currency.
  • Products — One row per product in the promotion. You fill in: Product, Price, Unit cost, Units per month now, Discount, Extra units you expect. Worked out for you: Discounted price, Margin before, Margin after, Extra units needed to break even, Profit before, Profit after, Verdict.
  • Dashboard — Profit before and after the promotion. Shows: Profit before, Profit after, Change in profit, Products worth it, a chart.
  • Summary — What the numbers say. Shows: Profit before, Profit after, Change in profit, Change in profit (%), Products worth discounting, Products losing profit, Products sold below cost, Average discount, Hardest to make up (most extra units needed).
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Before every promotion. 8 steps to tick off, with a progress bar.

How to use it

  1. In Products, add one row per product with its price, unit cost and current units per month.
  2. Type the discount you plan and the extra units you expect it to bring.
  3. Compare the extra units you expect with the extra units needed to break even.
  4. Dashboard adds up profit before and after the promotion.

What it does

  • Margin before and after the discount
  • Extra units needed to break even, per product
  • Profit before vs after, with Worth it / Loses profit
  • Flags discounts that sell below cost
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Microsoft Excel
  • Excel for Mac

Support

Questions about setup? Send us a message from your account page and we reply by email.

Discount & Promo Margin Calculator

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

$29.00

Free

File language: English

Add To Cart
Mia Ready
39 templates in the shop
View All Templates
  • Last updateNov 16, 2026
  • PublishedNov 16, 2026
  • CategorySales & CRM
  • File format.xlsx
  • LanguagesEnglish
  • LayoutLeft-to-right; Arabic right-to-left
  • MacrosNone
  • Works WithMicrosoft Excel, Excel for Mac
  • Tags Excel, Sales & CRM
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate