Kolumn

13 / 20 · Sales and invoicing

Pricing and margin calculator

From cost to price, with fees and margin.

SEK 99

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Work out a price from your cost and the margin you want – including platform and payment fees – and check what you actually make at the price you set.

What you get

Sheets
Calculator
Each file also has an instructions sheet and a lists sheet.
Formulas
400
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Enter the cost per unit: purchase, freight and duty (e.g. from the Landed cost template) and other (packaging, labels).
  2. Enter fees as a percentage of the price (e.g. marketplace + card fees) and the margin you want.
  3. The template suggests a price excl. tax and a rounded price incl. tax ending in 9.
  4. Enter your actual price incl. tax in column L to see the real margin and markup.