A sale price is only one part of what you pay. This reusable deal math worksheet shows how to compare unit prices, coupons, shipping, memberships, cashback, subscriptions, and return costs so you can identify the lower real cost before checkout.
Overview
Two listings can appear to offer the same product while producing different final values. A larger package may have a higher total price but a lower cost per ounce. A promo code may reduce the item price but fail to cover delivery. A cashback offer may improve the outcome later, yet its value can depend on eligibility, tracking, redemption rules, and excluded items.
The most reliable comparison is to calculate both the effective order cost and the unit price. Effective order cost is the amount you expect the purchase to cost after applicable discounts and rewards. Unit price divides that cost by the usable quantity, such as ounces, sheets, count, servings, or fluid ounces.
Use this worksheet whenever you compare multipacks, warehouse sizes, subscription offers, clearance deals, free-shipping thresholds, or competing retailer deals. It is also useful when testing working promo codes, a coupon code for a first order, or a cashback offer against a straightforward sale price.
For a broader look at combining offers, see our coupon stacking guide. The key principle is simple: compare like with like, include costs that change the transaction, and label uncertain savings separately from guaranteed reductions.
How to estimate
Record each option in the same order. Do not compare one listing before tax and another after tax, or one option with cashback included and another without it.
- Write down the advertised item price. Use the price for the exact size, model, quantity, and condition you intend to buy.
- Apply eligible discounts. Subtract a fixed-dollar coupon first when the retailer calculates it from the item subtotal. For a percentage discount, multiply the eligible subtotal by the discount rate. Do not assume a code applies to sale items, shipping, taxes, or every item in a cart.
- Add delivery and mandatory fees. Include shipping, handling, delivery surcharges, required membership costs, and any unavoidable service fees. If a membership lasts a year, allocate only the portion you reasonably assign to this purchase and state that assumption.
- Subtract realistic rewards. Treat points, rebates, and cashback as savings only when you understand their value and expect to meet the redemption requirements. If the reward is uncertain, show a guaranteed-cost result and a separate potential-cost result.
- Calculate the effective cost. A practical formula is:
Effective cost = item subtotal − discounts + shipping and mandatory fees + allocated membership cost − usable rewards. - Calculate the unit price. Use:
Unit price = effective cost ÷ usable quantity. Keep the unit consistent across listings. Convert pounds to ounces, liters to milliliters, or a multi-item pack to individual units before comparing.
For a percentage discount, the basic calculation is eligible price × discount rate. For example, a 15% code on an eligible $40 subtotal produces $6 in discount, before any shipping or other fees. If the code has a maximum discount, minimum spend, category restriction, or one-use limit, use the actual permitted discount rather than the headline percentage.
Inputs and assumptions
A good comparison is transparent about what is known and what is estimated. Copy these fields into a note, spreadsheet, or calculator:
- Item details: product variant, package count, net weight, volume, servings, or usable capacity.
- Base price: regular, sale, or clearance price for the exact item.
- Discounts: store coupon, promo code, automatic markdown, first-order offer, student discount, or other eligible reduction.
- Shipping: standard delivery, expedited delivery, pickup fee, or the amount needed to reach a free-shipping threshold.
- Membership and subscription costs: required membership, recurring delivery discount, introductory rate, or cancellation-related cost.
- Rewards: cashback, points, rebate, discounted gift card value, or store credit. Record whether the reward is immediate, delayed, conditional, or non-cash.
- Taxes: include them when they differ between options or when you need a precise checkout total. If tax treatment is unknown, mark it as excluded rather than guessing.
- Risk costs: return shipping, restocking fees, non-returnable clearance status, or the cost of buying an unsuitable substitute.
Use conservative assumptions for uncertain rewards. For example, a cashback offer should not be treated as guaranteed if the purchase may be excluded, tracking could fail, or the reward cannot be used for the type of purchase you plan to make. Similarly, a subscription discount is not a true saving if you would not otherwise accept the recurring order or if cancellation creates a cost you have not included.
Compare products by useful quantity, not merely package size. “Two containers” is not a meaningful unit if the containers hold different amounts. For consumables, check net weight or volume. For household goods, count sheets, loads, bags, or uses when those measures are available. For electronics and other durable goods, unit price may be less useful than total ownership cost, including accessories, warranty differences, or likely return expense.
Worked examples
Example 1: A coupon versus free shipping
Assume two hypothetical listings for the same 12-ounce coffee product:
- Option A: two packs at $18 each, a $5 coupon, and $7 shipping.
- Option B: two packs at $20 each, no coupon, and free shipping.
Option A costs $36 − $5 + $7 = $38. Its unit price is $38 ÷ 24 ounces, or about $1.58 per ounce. Option B costs $40, producing about $1.67 per ounce. In this illustration, the lower advertised price is not the only factor: shipping reduces, but does not eliminate, the coupon’s advantage.
Example 2: A multipack with cashback
Suppose Option C contains 30 units at $27 with a $3 shipping charge. Option D contains 24 units at $23 with free shipping and an eligible $2 cashback reward. For a guaranteed comparison, Option C costs $30, or $1.00 per unit. Option D costs $23 before cashback, or about $0.96 per unit. If the cashback is reasonably expected and usable, its effective cost becomes $21, or $0.88 per unit. Show both figures because the reward may be delayed or subject to conditions.
Example 3: Membership allocation
Assume a membership costs $60 for a year. You are comparing a $90 order with free shipping through the membership against a $96 order with $6 shipping elsewhere. If you already have the membership, the incremental cost of the first order is $90. If you would purchase the membership solely for this order, adding the full $60 produces a different decision. If you expect several qualifying orders, allocate the fee across those planned purchases rather than hiding it from the calculation. State the number of orders used for the allocation so you can revise it later.
These examples use simple hypothetical figures. Replace them with checkout values, and verify whether discounts apply before or after other promotions. If a code fails, consult this promo code troubleshooting guide rather than counting an unconfirmed discount as savings.
When to recalculate
Recalculate immediately before placing the order if the cart total, delivery charge, coupon terms, or reward value has changed. Retailers may adjust prices, inventory, shipping thresholds, subscription terms, and clearance conditions without preserving the assumptions used in an earlier comparison.
Revisit the worksheet when:
- the item size, pack count, seller, or condition changes;
- a promo code is replaced, expires, or stops applying to sale merchandise;
- you add or remove products needed to qualify for free shipping;
- a membership, subscription, or recurring-delivery price changes;
- cashback, points, or rebate terms change, or the reward becomes unavailable;
- you are comparing a clearance item with different return restrictions;
- a retailer offers a price adjustment after purchase; or
- tax, delivery, or other checkout fees differ from your original estimate.
For future checks, save the product links, screenshots of coupon terms, package quantities, and the date of your calculation. A price comparison is most useful when you can see which input changed. If a lower price appears after purchase, review the applicable price adjustment guidance rather than assuming every retailer handles price drops the same way.
Before checkout, complete this short final test: confirm the exact quantity, enter the code, verify the discounted subtotal, inspect shipping and mandatory fees, separate guaranteed savings from possible rewards, and divide the final comparable cost by the usable quantity. That process takes longer than reading a sale banner, but it gives you a repeatable answer to the question that matters: which option costs less for what you will actually receive?