Product Pricing & Margin Planner
Price every product from cost, see true margin after discounts and sales commission, and know your break-even point. One clean Excel template.
Made by Talreon.com — the same team behind the free margin, markup and break-even calculators.
Five tabs. Real formulas. Yellow inputs, locked formulas.
Change any yellow input and everything updates. Formula cells are locked so you don't break them by accident (unlock anytime — no password).
1. Instructions
Plain-English guide, colour key, and the formulas explained — including markup vs margin and break-even.
2. Product Pricing
Enter unit cost, pick Margin or Markup, set your target %. Get selling price, gross profit, margin % and markup % side by side — for up to 8 products (copy a row to add more).
3. Discounts & Commission
See how a discount, sales commission and payment-processing fees change profit per unit and effective margin — plus how many extra units you'd need to earn the same profit.
4. Break-even
Monthly fixed costs and a target profit → weighted contribution, break-even units and revenue, units for target profit, margin of safety, and a profit-at-volumes table.
5. Summary dashboard
Key numbers at a glance plus a chart of gross vs effective margin by product.
Format & currency
USD formatting by default — switch to any currency via cell format. Works in Microsoft Excel, Google Sheets (File → Import) and LibreOffice.
See the workbook before you buy.
Screenshots show fictional example data included with the template so you can see how it works straight away.
Built for people who sell things and need clear margins.
- E-commerce, Etsy and Shopify sellers setting product prices
- Retailers and wholesalers comparing markup vs margin
- Makers and product freelancers who need a repeatable pricing sheet
- Sales managers modelling commission and discount impact
If you already use Talreon's free profit margin, markup or break-even calculators, this spreadsheet keeps those ideas in one place you can save and reuse.
Excel (.xlsx) · Opens in Google Sheets · Licensed for your own business use
Buy by email — US$9 Buy via WhatsApp — US$9 Enquire
How it works: send us a short email with your name and whether you prefer Excel or Google Sheets. We reply with a bank transfer invoice (usually within 1 business day). After you pay, we email you the file.
Questions first? support@talreon.com
Frequently asked questions
What format is the file?
An .xlsx Excel workbook. Open it in Microsoft Excel, import into Google Sheets (File → Import), or open it in LibreOffice Calc.
How do I buy and receive the file?
Click Buy by email or Buy via WhatsApp (+65 8791 2456), or email support@talreon.com directly. Include your name and preferred format (Excel or Google Sheets). We send a bank transfer invoice within about 1 business day. After payment clears, we email you the .xlsx file. There is no self-serve checkout yet.
What is the refund policy?
If the file doesn't open or work as described, email us within 7 days of purchase for a full refund. Contact support@talreon.com.
Can I use it for clients?
The licence is for the purchaser's own business use. Sharing or reselling the template file itself is not allowed. Using the numbers for your own client work is fine.
Is this financial or accounting advice?
No. It is an educational spreadsheet with working formulas. Always verify pricing and tax treatment for your situation.
Do you have free calculators too?
Yes — free browser tools for profit margin, markup, discount, commission and break-even, plus guides on talreon.com/guides.
Questions before you buy?
Email support@talreon.com. Content is reviewed by the Talreon team (Hypercloudsoft, Singapore).