Sales template
Pricing Calculator Template (Margin and VAT)
Enter your unit cost and the margin you want. The sheet calculates the price before and after VAT, and your profit per unit.
Opening a template uses no credits.
What's inside
| Row | A | B |
|---|---|---|
| 1 | Input | Value |
| 2 | Unit cost | 120 |
| 3 | Target margin | 40% |
| 4 | VAT | 25% |
| 5 | Price excl. VAT | =B2/(1-B3) |
| 6 | Price incl. VAT | =B5*(1+B4) |
| 7 | Profit per unit | =B5-B2 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
B5 =B2/(1-B3)
Price that gives the target margin on the selling price (not markup on cost).
B6 =B5*(1+B4)
Adds VAT on top of the price.
Make it yours by asking
Try a request like this in Tabstra:
"Create a pricing calculator from unit cost, target margin and VAT, showing price and profit per unit"
Questions
Related templates
Sales Performance Dashboard
Targets, actuals and attainment by rep and region, ready to turn into charts.
Business Budget
Monthly revenue, costs and profit for a small business, with totals that update automatically.
Sales Forecast
A 12-month revenue forecast driven by one starting value and one growth assumption.