Selling Price Calculation Excel Template

Setting a selling price is not just adding a random percentage to cost. If the calculation is wrong, the company may sell more and still earn less than expected.

A selling price calculation Excel template helps compare different pricing methods and understand how cost, margin, markup and profit expectations affect the final price.

This is useful for products, services, projects, commercial offers and any situation where the price must be calculated with more logic than intuition.

Selling price calculation Excel template

A selling price calculation Excel template is a spreadsheet used to calculate and compare different selling price methods.

It can help answer questions such as:

What price should I charge if I want a specific margin?
What is the difference between markup and margin?
How much profit does each price generate?
What happens if cost increases?
What price is needed to reach a target profit?

The objective is not to replace commercial judgment.

The objective is to avoid pricing decisions based only on habit, pressure or guesswork.

Why selling price calculation matters

Many companies calculate prices too quickly.

They take a cost, add a percentage and assume the result is acceptable.

The problem is that a small mistake in pricing can have a big effect on profit.

For example:

A price too low can destroy margin.
A price too high can reduce sales volume.
A wrong cost base can make every calculation unreliable.
Confusing margin and markup can create unexpected results.
Ignoring fixed costs can make the price look profitable when it is not.

A pricing spreadsheet helps make these relationships visible.

Information needed before calculating a selling price

Before using any pricing method, you need a reliable cost base.

Depending on the product or service, this may include:

Purchase cost.
Manufacturing cost.
Materials.
Direct labor.
Subcontracted services.
Packaging.
Logistics.
Sales commissions.
Other variable costs.

The selling price calculation is only as good as the cost information behind it.

If the cost is wrong, the price will be wrong too.

Method 1: cost-plus pricing

Cost-plus pricing is one of the simplest methods.

The logic is:

Selling price = Cost + Desired profit

For example, if a product costs 80 and the company wants to earn 20 per unit, the selling price would be 100.

This method is easy to understand, but it requires clarity about the profit objective.

It is useful when:

The cost base is reliable.
The company wants a clear profit amount per unit.
The market accepts the resulting price.
The product or service has predictable costs.

Its weakness is that it may ignore market demand, competitors and customer value perception.

Method 2: markup calculation

Markup is calculated as a percentage added to cost.

The formula is:

Selling price = Cost × (1 + Markup %)

For example:

Cost: 100
Markup: 30%
Selling price: 130

Markup is common in many businesses because it is simple.

However, markup is not the same as margin.

This is where many pricing errors appear.

Method 3: target margin pricing

Target margin pricing starts from the margin percentage the company wants to achieve on the selling price.

The formula is:

Selling price = Cost / (1 – Target margin %)

For example:

Cost: 100
Target margin: 30%
Selling price: 142.86

Why is this price higher than the markup example?

Because margin is calculated over the selling price, while markup is calculated over cost.

This method is especially useful when the company manages profitability using gross margin percentages.

Margin vs markup

Margin and markup are often confused.

They are not the same.

Markup is calculated over cost.
Margin is calculated over selling price.

Example:

Concept	Amount
Cost	100
Selling price	130
Profit	30
Markup	30%
Margin	23.1%

A 30% markup does not mean a 30% margin.

That distinction is essential for correct pricing.

Example comparing three pricing methods

A simple comparison can show how different methods produce different prices.

Method	Cost	Rule	Selling Price
Cost plus profit	100	+ 25 profit	125
Markup	100	30% markup	130
Target margin	100	30% margin	142.86

The right method depends on how the business manages prices, margins and commercial decisions.

Selling price calculation vs cost calculation

Cost calculation and selling price calculation are related, but they are not the same.

Cost calculation answers:

How much does the product or service cost?

Selling price calculation answers:

What price should be charged to achieve the desired result?

A company may calculate costs correctly and still set prices poorly.

That is why pricing deserves its own analysis.

Selling price calculation vs break-even analysis

Break-even analysis answers a different question.

It calculates the sales level needed to cover fixed and variable costs.

Selling price calculation focuses on the price per unit or service.

For example:

Selling price calculation: what price should I charge?
Break-even analysis: how many units must I sell at that price to cover costs?

Both analyses can work together.

A price may generate good margin per unit but still require enough volume to cover fixed costs.

Common mistakes in selling price calculation

Some common mistakes are:

Confusing margin and markup.
Using outdated costs.
Ignoring commissions or logistics.
Not considering discounts.
Forgetting payment fees or platform costs.
Assuming all customers should have the same price.
Not testing how price changes affect profitability.

The most dangerous mistake is believing that “selling more” automatically means “earning more”.

If the price is wrong, higher volume can amplify the problem.

How Excel helps with selling price calculation

Excel is useful because it allows you to compare scenarios quickly.

You can simulate:

Different cost levels.
Different markup percentages.
Different target margins.
Discounts.
Sales commissions.
Minimum acceptable price.
Expected profit per unit.

This makes pricing decisions more transparent.

Instead of discussing opinions, the team can see the financial effect of each price.

When Excel is useful

Excel can be useful when:

The company needs a flexible price calculation model.
Costs and margins need to be tested quickly.
The business sells products or services with different cost structures.
Commercial teams need a pricing reference.
The company wants to compare several pricing methods.

For small businesses and finance teams, a pricing spreadsheet can be a practical starting point.

When Excel may fall short

Excel may become insufficient when:

The company manages thousands of products.
Prices change frequently.
Customer-specific pricing rules are complex.
Promotions, discounts and contracts must be automated.
Pricing must be integrated with ERP, CRM or e-commerce platforms.
Approval workflows are required.

In those cases, ERP pricing rules, CPQ tools or pricing software may be more appropriate.

Excel can still be useful for simulations and management analysis.

A selling price calculation Excel template helps compare different pricing methods and understand the impact of cost, markup, margin and target profit.

The main lesson is simple: margin and markup are not the same, and a small pricing error can have a large effect on profitability.

A good pricing model does not make the commercial decision for you.

It gives you the numbers you need before making that decision.

This selling price calculation Excel template can be combined with other cost, margin and profitability tools depending on whether you need to calculate prices, analyze product costs, simulate break-even points or review real margins:

direct costing Excel template when you need to calculate product or service margins using variable costs, contribution margin and fixed cost coverage.

break-even point Excel template when you need to estimate the sales volume required to cover fixed costs before defining or validating selling prices.

sales budget control template in Excel when the objective is to compare sales performance against budget, not to calculate unit selling prices.

project cost and profitability Excel template when pricing decisions are linked to project revenues, planned costs, actual costs and expected profitability.