Skip to content

Profit margin and markup calculator

See the profit, margin and markup of every product and the price that reaches your target margin.

Profit margin and markup calculator template, first page

Fill it in and preview

Profit margin and markup calculator

A spreadsheet that works out how much you earn on each product. Enter the cost and selling price and it gives the profit, the margin and the markup, the average and lowest margin across your range, how many products fall below your target and the price each needs to reach it. Download it as Excel, OpenDocument, PDF or CSV.

Margins

Margin and markup calculator

List your products with cost and selling price. Margin, markup and profit are worked out for each. Set a target margin to see the price it needs.

Business Corner Coffee Roasters

Target margin (%) 40

Product Cost price Selling price Profit Margin Markup Price for target margin
House blend 250 g 3.60 7.90 4.30 54.4% 119.4% 6.00
Single origin 250 g 5.40 9.50 4.10 43.2% 75.9% 9.00
Decaf 250 g 4.10 7.50 3.40 45.3% 82.9% 6.83
Cold brew bottle 1.90 4.20 2.30 54.8% 121.1% 3.17
Ceramic mug 3.20 8.00 4.80 60.0% 150.0% 5.33
Products 5
Average margin 51.5%
Lowest margin 43.2%
Highest margin 60.0%
Products below the target margin 0

Open this spreadsheet in nerixA preview of the first rows with sample figures. Open it in nerix to fill in your own and change any cell.

Templates are a careful starting point, not legal advice. Where the law matters, check what applies where you are.

Finance and accounting

What this template is for

A profit margin and markup calculator spreadsheet: list products with cost and price to see profit, margin and markup, and the price needed for a target margin.

It is free to fill in online, needs no account, and downloads as a Word document or a PDF. See all Finance and accounting templates All free Excel and spreadsheet templates

Finance and accounting

What you fill in

The form asks for 3 details. The document fills itself in as you type.

  • Businessoptional

    For example: Corner Coffee Roasters

  • Target margin (%)optional

    The margin you want on every product, such as 40. Leave empty to skip the target price.

    For example: 40

  • Products

    One row for each product: what it costs you and what you sell it for.

Finance and accounting

What is inside

The parts of this document, in order.

  1. 1A spreadsheet that works out how much you earn on each product. Enter the cost and selling price and it gives the pro...

Templates

How it works

  1. 01

    Open

    Open the spreadsheet in nerix and fill in the short form. Your answers go straight into its cells.

  2. 02

    Change

    Every figure is a live formula. Change any cell and the totals, differences and charts work themselves out.

  3. 03

    Download

    Save it as an Excel file, an OpenDocument sheet, a PDF or CSV.

Make it yours with AI

Open it in the chat and ask for changes: shorter, firmer, another situation, another language.

Adapt it with nerix

Finance and accounting

Questions people ask

What details does this template ask for?

The form asks for 3 details, starting with Products. 2 more are optional.

Can I download this template as Word or PDF?

Yes. Open it in nerix and the finished spreadsheet downloads as Excel, OpenDocument, PDF or CSV. It is free and the page only shows sample figures.

Is what I type sent anywhere?

No. What you type stays in your browser while you fill in the document. It only goes to nerix if you choose to open the template in the chat.

What should I check before I use this template?

Margin is profit as a share of the selling price, markup is profit as a share of cost, and the two are not the same. Cost here should include everything you pay to sell one item, but not general overheads.

Are these finance templates free?

Most are. Fill in and download them for free as Word or PDF, with no account. A few longer documents are premium: free to fill in, paid once to download, and marked with their price.

Do these templates include tax rules?

No. Tax and invoicing rules differ by country. Each template has fields for amounts and references, and you add the tax details your local rules require.

Can I use them with my accounting software?

Yes. They are plain documents. Download the Word version, or copy the figures into your software.