Percent-Off Discount Table (5% to 95%)
One grid for every sale sign. Rows are the discount, columns are common ticket prices, cells are what you pay. The multiplier column is the fastest way to apply a discount to a whole price list in a spreadsheet.
What you pay after the discount
To read the grid, find the discount on the left and the original price along the top; the cell is the sale price. To apply a discount to any other price, multiply by the number in the multiplier column: 30% off is × 0.70, 65% off is × 0.35.
| Discount | Multiplier | $9.99 | $19.99 | $29.99 | $49.99 | $79.99 | $99.99 | $149.99 | $199.99 | $499.99 | $999.99 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5% off | 0.95× | $9.49 | $18.99 | $28.49 | $47.49 | $75.99 | $94.99 | $142.49 | $189.99 | $474.99 | $949.99 |
| 10% off | 0.9× | $8.99 | $17.99 | $26.99 | $44.99 | $71.99 | $89.99 | $134.99 | $179.99 | $449.99 | $899.99 |
| 15% off | 0.85× | $8.49 | $16.99 | $25.49 | $42.49 | $67.99 | $84.99 | $127.49 | $169.99 | $424.99 | $849.99 |
| 20% off | 0.8× | $7.99 | $15.99 | $23.99 | $39.99 | $63.99 | $79.99 | $119.99 | $159.99 | $399.99 | $799.99 |
| 25% off | 0.75× | $7.49 | $14.99 | $22.49 | $37.49 | $59.99 | $74.99 | $112.49 | $149.99 | $374.99 | $749.99 |
| 30% off | 0.7× | $6.99 | $13.99 | $20.99 | $34.99 | $55.99 | $69.99 | $104.99 | $139.99 | $349.99 | $699.99 |
| 35% off | 0.65× | $6.49 | $12.99 | $19.49 | $32.49 | $51.99 | $64.99 | $97.49 | $129.99 | $324.99 | $649.99 |
| 40% off | 0.6× | $5.99 | $11.99 | $17.99 | $29.99 | $47.99 | $59.99 | $89.99 | $119.99 | $299.99 | $599.99 |
| 45% off | 0.55× | $5.49 | $10.99 | $16.49 | $27.49 | $43.99 | $54.99 | $82.49 | $109.99 | $274.99 | $549.99 |
| 50% off | 0.5× | $5.00 | $9.99 | $14.99 | $25.00 | $39.99 | $49.99 | $75.00 | $100.00 | $250.00 | $500.00 |
| 55% off | 0.45× | $4.50 | $9.00 | $13.50 | $22.50 | $36.00 | $45.00 | $67.50 | $90.00 | $225.00 | $450.00 |
| 60% off | 0.4× | $4.00 | $8.00 | $12.00 | $20.00 | $32.00 | $40.00 | $60.00 | $80.00 | $200.00 | $400.00 |
| 65% off | 0.35× | $3.50 | $7.00 | $10.50 | $17.50 | $28.00 | $35.00 | $52.50 | $70.00 | $175.00 | $350.00 |
| 70% off | 0.3× | $3.00 | $6.00 | $9.00 | $15.00 | $24.00 | $30.00 | $45.00 | $60.00 | $150.00 | $300.00 |
| 75% off | 0.25× | $2.50 | $5.00 | $7.50 | $12.50 | $20.00 | $25.00 | $37.50 | $50.00 | $125.00 | $250.00 |
| 80% off | 0.2× | $2.00 | $4.00 | $6.00 | $10.00 | $16.00 | $20.00 | $30.00 | $40.00 | $100.00 | $200.00 |
| 85% off | 0.15× | $1.50 | $3.00 | $4.50 | $7.50 | $12.00 | $15.00 | $22.50 | $30.00 | $75.00 | $150.00 |
| 90% off | 0.1× | $1.00 | $2.00 | $3.00 | $5.00 | $8.00 | $10.00 | $15.00 | $20.00 | $50.00 | $100.00 |
| 95% off | 0.05× | $0.50 | $1.00 | $1.50 | $2.50 | $4.00 | $5.00 | $7.50 | $10.00 | $25.00 | $50.00 |
Reading a sale sign against your margin
Shoppers read the grid one way: the discount is the saving. Sellers should read it the other way: the discount is margin given up. A line bought at a 40% gross margin keeps 40% of its price at full price, 25% of the reduced price at 20% off, and nothing at 40% off, where the sale price equals cost. Every row below 50% off still leaves something for a keystone retailer; every row at 50% or deeper does not. Use the percent-off pages, which carry the margin arithmetic for each level, before printing the sign.
Three things the grid does not show
Stacked discounts multiply rather than add: 20% off then 10% off is 28% off, not 30%. Each percent-off page has the stacked table for that starting discount. Reverse calculations divide rather than subtract: a $70 sale price after 30% off was $100 (70 ÷ 0.70), not $91. And a discount deeper than the gross margin sells below cost; the pricing hub links the margin pages that show where that line is for each markup.