Simple Excel Markup and Margin Tool

A simple Excel tool to help you with

Markup calculations


Margin calculations. 

Want to get a handle on Pricing, Markup and Margin?

Are you not sure which method to use for your pricing structures?  How would they compare?

Markup and Margin are often used interchangeably.

But, they are not the same thing.

This leads to confusion when comparing suppliers.

Markup Definition

Markup = The percentage of your cost you add to your cost to determine your price to the customer.

e.g. Cost = £10.  10% markup = £1.  Price to customer  = £10 + £1 = £11

Margin Definition

Margin = The percentage difference between your cost and the price to your customer as a percentage of the price.

e.g. Cost = £10. Price to customer = £11.  Margin = (11-10) / 11 = 9%


A simple-to-use, neat, Markup and Margin Excel Tool

The Simple Markup and Margin Excel Tool  from Working Data:

Calculates Markup from Margin, and Margin from Markup.

Compare and Contrast the two methods.

See how different markups and margins affect your final prices.

Save yourself time by automating your Markups and Margins.

Reusable & 100% Money Back Guarantee (30 days from date of purchase)

Simple Excel Markup and Margin Tool

How to use the Simple Excel Markup and Margin Tool

Know your Costs and Markup? Now Calculate Price and Margin

If you know your costs and what markup you want to apply, this is the section for you.  Add your markup percentage in the top right box, then add each product’s cost and let the Excel Tool calculate your price and margin!
Applying Markup to a cost

Know your Costs and Margin?  Now Calculate Price and Markup

If you know your costs and what margin you want to apply, this is your section.  Add your margin percentage then add the cost to each row and let the Excel Tool calculate your price and markup!

Applying Margin to a Cost

Know your Costs and Prices?  Now Calculate Margin and Markup

If you know your costs and what prices you want to charge the third section is for you.  Enter your cost and price per item and watch as the Excel Tool automatically calculates your markup and margin!

Calculating Markup and Margin from Cost and Price

Some further information on the subject

As you can see, markup and margin are not the same.

Comparison of markup and margin

100% markup is equivalent to 50% margin.

Graph of markup versus margin

However, ‘markup’ and ‘margin’ are often used interchangeably. This is usually done quite innocently, but can lead to stressful confusion when trying to compare suppliers and products. The Markup & Margin Excel Tool will help you overcome this problem. You can set your pricing by markup or margin, or start with your cost and price and calculate back to your markup or margin. If one supplier is talking to you in markup and the other in margin, enter their data into the Excel Tool to compare like-for-like. Set your pricing policy and set prices accurately, quickly and simply.

How We Work

From a free consultation to ongoing support, find out the simple stages we take you through when you engage us to build your bespoke business solution. 

Automate Business Processes

Software can automate many manual and time-consuming processes.  Discover how processes in your business can be automated by software.

Who We Work With

Working Data have designed, built and supported bespoke business software for companies from all sectors and of all sizes.

Comments are closed.