Small Business
Pricing & Profit Margin Calculator
Set a price from cost and target margin, or check what margin an existing price actually earns.
- Delivery
- Instant download
- Purchase
- One-time payment
- Format
- Google Sheets
- Excel
- Updated
- August 2026
Suggested price
$33.45
- Total cost$18.40
- Target margin45%
Sample data preview of the Pricing & Profit Margin Calculator spreadsheet, shown for illustration only.
What this spreadsheet does
Prices set by guessing or matching competitors often don't cover real costs, so the business earns less margin than it thinks.
What you can do with it
- Set a new product price that hits your target margin
- Check whether an existing price still covers costs
- Price a whole product line at once in the table
What's included
Sheet tabs
- Price Calculator
- Product Pricing Table
Features
- Cost-plus pricing calculator with target margin input
- Reverse calculator: enter a price, see the resulting margin
- Bulk pricing table for multiple products/services
- Cost breakdown (materials, labor, overhead)
How it works
- 1Enter the full cost of a product or service
- 2Set your target margin or enter a price to check
- 3Review the resulting price or margin
Who it's for
Small business owners and freelancers setting or checking product/service pricing.
Frequently asked questions
Does it work for services, not just products?
Yes, enter your labor and overhead cost per service the same way you would for a physical product's cost.
Can I price multiple products at once?
Yes, the Product Pricing Table tab is built for pricing a full product or service line together.
You might also need
Break-Even Calculator
Find the sales volume needed to cover fixed and variable costs.
- Google Sheets
- Excel
Small Business Cash Flow Tracker
See money in, money out and projected balance by month.
- Google Sheets
- Excel
Inventory Tracker
Track stock levels, reorder points and inventory value.
- Google Sheets
- Excel
Small Business Quarterly Estimated Tax Tracker
Know what to set aside and pay the IRS each quarter, calculated from your income log.
- Google Sheets
- Excel