MarginMaster | Pricing & Profit Calculator Excel Template

Excel pricing calculator for small businesses. Find your true cost, profit after fees, margin vs markup, recommended price and break-even. No macros.

MarginMaster – Pricing & Profit Calculator

Price Smarter. Profit Better.

Are your prices actually making you money?

Marketplace fees, payment fees, packaging, shipping and your own time quietly eat into every sale. Many sellers find out too late that a “best-seller” earns almost nothing, or loses money. MarginMaster adds up every cost and shows exactly what you keep from each sale, and what you should charge.

Type in your costs, fees and price. MarginMaster does the maths instantly.

WHAT MARGINMASTER CALCULATES FOR YOU

✔ True cost per unit: product cost, packaging, shipping, labor, other costs and a fair share of your overheads

✔ Fees in money: your marketplace, payment and other percentage fees, worked out on your selling price

✔ Profit per unit: what you really keep after all costs and fees

✔ Profit margin AND markup: both calculated and clearly labelled, so you never mix them up again

✔ Recommended selling price: the exact price that hits your target margin, with fees built into the formula

✔ Price gap: how far your current price is above or below that target

✔ Break-even point: how many units, and how much revenue, you need each month to cover your fixed costs

✔ Sales for a profit goal: the units you need to reach a monthly profit target

WHAT’S INSIDE THE WORKBOOK (7 SHEETS)

📌 Start Here: simple setup steps, a colour guide and a worked example

💲 Pricing Calculator: price one product in detail. Includes a what-if table showing the price you need for 8 different target margins.

📦 Bulk Product Calculator: price up to 150 products at once. Filter and sort them, and spot problems fast with colour alerts:

• 🟢 Green: meets your target margin
• 🟠 Amber: profitable but below target
• 🔴 Red: losing money, or a target that’s impossible after fees
• 
  

📈 Break-Even Calculator: your monthly break-even units and revenue, a sales-volume table and a profit chart. It shows a clear warning if a price can never break even.

📊 Profit & Sales Dashboard: product count, average price, cost and margin, loss-makers, below-target products, best and worst margins, a category summary and charts. All of it is calculated automatically.

🧾 Example Products: 12 clearly labelled sample products across clothing, accessories, packaged food, beauty, digital downloads, home decor, stationery, crafts, pet products and services

⚙️ Settings & Lists: your business name, a default target margin, a default fee %, editable categories and 13 currency options

WHY SELLERS LIKE IT

• 1. No formulas to write: just type in the yellow cells
• 2. Margin vs markup explained in plain English
• 3. Overhead is never counted twice; the guide shows you exactly 4. where each cost goes
• 5. Clear warnings instead of confusing errors
• 6. Easy to clear the sample data and start with your own products
• 7. No macros, no subscription, no account and no internet needed

WHO IT’S FOR

Etsy, Shopify, Amazon and other online sellers · small retailers · resellers · makers and handmade businesses · freelancers who sell packaged services · anyone who wants to set prices on purpose instead of guessing

WHAT YOU GET

• - MarginMaster_Pricing_Profit_Calculator.xlsx
• - MarginMaster_User_Guide.pdf (16 pages, with step-by-step worked examples)
• - MarginMaster_Quick_Start.pdf
• - MarginMaster_README.pdf (compatibility and troubleshooting)
• - MarginMaster_License.txt

REQUIREMENTS

• - Microsoft Excel 2016 or later, or Microsoft 365 (Windows or Mac)
• - Also opens in LibreOffice Calc
• - Designed for use on a computer, not a phone

PLEASE NOTE

• - MarginMaster calculates results from the numbers you enter. 
• - Accurate inputs give accurate results.
• - It is a planning tool. It does not guarantee profits and is not tax, legal or accounting advice.
• - It is a single-user Excel file. It does not connect to online shops or accounting software.
• - This is an instant digital download; nothing physical is shipped.

Stop guessing your prices. Start knowing your profit.

👉 Download MarginMaster now and price every product with confidence.