Excel template: purchase and sales price calculation
What sales price do you need for your target margin once marketplace fees, shipping and packaging are deducted? The template calculates the minimum price and checks your actual price.
What's in the template
Calculation
Purchase price, shipping, packaging, fee in %, fixed fee, VAT rate and target margin – minimum gross sales price, contribution margin, margin and markup are calculated.
In three steps
- Enter costs and fee rate
- Set the target margin
- Enter your own sales price and check the margin
You fill in the yellow fields; the template calculates the grey ones. You can overwrite the example rows.
Frequently asked questions
How is the minimum sales price calculated?
Net price = (purchase + shipping + packaging + other + fixed fee) ÷ (1 − target margin − fee rate × (1 + VAT rate)); the gross price is derived from this. As with the marketplaces, the fee is calculated on the gross price.
Where do I get the fee rates?
From our marketplace profit calculator or directly from the marketplaces' fee pages.