Small Business 2027 Pricing and Profit Calculator (.xlsx spreadsheet)

$24.95

Find out what each product really costs you, including your time, your fees and a share of your rent, then get a suggested price that reaches the profit margin you choose. Type the price you charge to see your profit, your margin, what you earn per hour and how many you need to sell each month to cover your fixed costs.

Covers: the cost, a suggested price and the profit per item for up to 40 products that a small maker or product business makes and sells: materials from up to 60 supplies bought in packs, recipes (up to 300 lines), labor time at an hourly rate you choose, packaging, shipping you pay and other per-item costs, a share of your monthly fixed costs, selling fees for up to 6 sales channels you name (a percentage of the price plus a fixed fee per sale), a suggested price for a target profit margin you choose, profit and margin at the price you charge, a wholesale price at a multiple of cost you choose, earnings per hour of work, and break-even items per month.

Does not cover: sales tax, VAT, income tax or any other tax; discounts, coupons or free-shipping offers; orders with more than one item sharing one fixed fee; services priced without a product; inventory counts or stock values; more than one currency; what customers will pay or what other sellers charge; or advice on pricing, taxes or business decisions.

Not tax advice and not financial advice.

Many makers price by guesswork and only find out later that one product barely pays. This spreadsheet adds up every cost of one item and shows whether your price works.

What’s inside (7 tabs + a 3-page guide)

  • Start Here: the scope, how it works, every formula written out, and the source
  • Settings: your labor rate, target profit margin, wholesale multiple, expected items per month, and up to 6 sales channels with a fee % and a fixed fee per sale
  • Fixed Costs: up to 30 costs, monthly, quarterly or yearly, turned into one monthly total
  • Materials: up to 60 supplies; type the pack price and pack size and get the cost per unit
  • Recipes: up to 300 lines saying how much of each supply goes into one item
  • Products: up to 40 products with total cost, suggested price, fees, profit, margin, a check (On target, Below target, Below cost), wholesale price, earnings per hour and break-even items per month
  • Dashboard: the checks counted up and every product on one page

How the numbers are worked out

  • Suggested price = (total cost + fixed fee) / (1 − fee % − target margin)
  • Profit margin = profit / price, after every cost and fee
  • Break-even items per month = monthly fixed costs / (price − fees − variable cost), the U.S. Small Business Administration break-even formula, worked out as if each product were the only one you sold

Good to know

  • .xlsx spreadsheet plus a PDF guide. Made for Excel or Google Sheets; tested in LibreOffice only. A text file explains how to open it in Google Sheets.
  • Comes filled with labeled example data for a small candle and soap maker so you can see how it works. The example fees and prices are made up; use the fees your own sales channels publish. Clear the yellow cells before you start.
  • No macros. Prices exclude sales tax. No tax is calculated.
  • Digital download only. Nothing is shipped.

Source: U.S. Small Business Administration, Break-Even Calculator (opened Nov 14, 2026; no revision date shown), for the break-even formula and the meaning of fixed and variable costs. The other formulas are ordinary arithmetic, written out in the file.

How this was made: The spreadsheet formulas, layout, example data, guide and instructions were made with AI assistance and reviewed before release. Every formula was tested in LibreOffice against an independent calculation in 8 cases. The quoted SBA wording was not written or altered by AI.

Reviews

There are no reviews yet.

Be the first to review “Small Business 2027 Pricing and Profit Calculator (.xlsx spreadsheet)”

Your email address will not be published. Required fields are marked *