Back to Templates
SALES TOOL
Discount Profitability Matrix
A lookup table for sales teams to understand the margin impact of discounts before they offer them.
LIVE PREVIEW
| Product Line | Base Price | COGS | Base Margin % | 10% Disc Margin | 20% Disc Margin | 30% Disc Margin | Break-Even Vol Lift (20%) |
|---|---|---|---|---|---|---|---|
| Widget Standard | $50.00 | $25.00 | 50% | 44% | 37% | 28% | +67% |
| Widget Pro | $100.00 | $40.00 | 60% | 55% | 50% | 42% | +50% |
| Service Addon | $20.00 | $2.00 | 90% | 89% | 87% | 85% | +22% |
| -- | -- | -- | -- | -- | -- | -- | -- |
| -- | -- | -- | -- | -- | -- | -- | -- |
Instructions
- 1Green Zone: Discounts that are safe.
- 2Red Zone: Discounts that kill profit.
- 3Distribution: Print for sales desks.
Pro Tip
You can import the downloaded CSV directly into Google Sheets, Excel, or Airtable. The formatting is universal.
About this Template
Empower your sales team to negotiate without destroying the company's bottom line.
Key Features
Traffic Light Formatting: Visual risk indicators.
Volume Lift Calc: Built-in math.
Common Use Cases
Sales Enablement: Training material.
Black Friday Planning: Offer selection.
Frequently Asked Questions
Can I customize tiers?
Yes, columns are editable.