Pricing Calculator Template

Underpricing is one of the most common small business mistakes. This pricing worksheet calculates a price from your full cost and target margin, shows the equivalent markup and compares it with competitor prices for up to ten products or services.

Preview of the Pricing Calculator Template

Free download. No sign-up, no email.

Download Excel (.xlsx)6 KB
  • Formulas built in, just fill the yellow cells
  • Works in Excel, Google Sheets and LibreOffice
  • Example numbers show how it works

Who this template is for

  • New businesses setting prices
  • Product makers and retailers
  • Service businesses pricing packages

How to fill it in

  1. List each product or service.
  2. Enter the full cost per unit.
  3. Enter your target gross margin.
  4. Compare the suggested price with competitors.
  5. Round prices and update your plan.

What is inside

  • Sheet: Pricing
  • Product or service
  • Product A
  • Product B
  • Service package

Writing a full business plan?

Browse 39 free sample plans by industry, each with startup costs and projections.

See sample plans

Frequently asked questions

What is the difference between markup and margin?

Markup is profit as a percentage of cost. Margin is profit as a percentage of price. A 50% margin equals a 100% markup.

How do I price a service?

Estimate hours, multiply by a loaded hourly cost, add materials and overhead, then apply your target margin.

Is this pricing calculator template free to use?

Yes. Download it, edit it and use it for your own business at no cost. No account or email address is required.

Related templates

Excel

3-Year Financial Projections Template

Projected P&L and cash flow from simple assumptions.

Excel

Startup Costs Calculator

Add up one-time and monthly costs to open.

Excel

Break-Even Analysis Template

Find the sales you need to cover costs.

Word & PDF

Market Analysis Template

Size your market with TAM, SAM and SOM.