Margin and Markup Calculator

What this two-scenario calculator estimates

This calculator translates two pricing assumptions into directly comparable unit economics. It starts with one unit cost, then solves each scenario from a known margin, markup, selling price, or profit amount. The result is a complete set of five connected measures: cost, selling price, profit, margin, and markup. The headline price range is useful when you are setting a minimum and maximum price, testing two policies, or comparing a current price with a proposed one.

The calculation is a gross-profit view rather than a complete business-profit forecast. Unit cost should include the direct costs you intend to recover through the sale, but the result does not automatically deduct rent, payroll, advertising, payment fees, taxes, or other operating expenses. The U.S. Small Business Administration offers a broader overview of managing business finances, while the IRS explains general business expense concepts.

How to enter each input

Unit cost

Enter the direct cost for one item, service unit, hour, package, or transaction. The field is required and accepts dollars, commas, spaces, and plain numbers. Use a nonnegative amount. A higher cost raises the selling price needed to preserve the same margin or markup. A common mistake is entering only the supplier invoice while omitting freight, packaging, transaction-specific labor, or other direct costs. Include those items when they are genuinely attributable to each unit.

Known measure for Scenario A and Scenario B

Choose the measure you already know. Target margin is best when policy says what percentage of sales should remain after direct cost. Markup on cost is best when pricing starts by adding a standard percentage to cost. Selling price is useful for checking an existing or competitor price. Profit per unit is useful when you need a fixed dollar contribution from every sale. Both scenarios may use the same basis or different bases.

Target value

The target field changes units with the selected basis. Margin and markup use percentages; selling price and profit use dollars. A margin must remain below 100% because a finite price cannot produce a full 100% gross margin when cost is positive. In this calculator, negative targets are treated as invalid so the comparison stays focused on nonnegative pricing and profit plans. Reset clears the cost, both scenario bases, and both target values, leaving a neutral state with no stale chart or results.

How to read every result

Required selling-price range

The primary result shows the lower and higher selling prices produced by the two scenarios. When both scenarios are valid, the range quickly communicates the pricing corridor. A narrow range means the assumptions are economically similar; a wide range signals that the chosen margin, markup, price, or profit targets imply materially different customer prices.

Scenario selling price and profit

Selling price is the amount charged per unit before sales tax or discounts unless you deliberately included those effects in your assumptions. Profit is selling price minus unit cost. A zero profit means price equals cost. A larger profit gives more dollars per sale to cover operating expenses and owner return, but it may also require a price the market will not accept. The comparison card shows the change from Scenario A to Scenario B in both price and profit.

Margin and markup

Margin measures profit as a share of selling price. Markup measures profit as a share of cost. For a profitable sale, markup is normally numerically higher because its denominator is smaller. For example, a $100 cost sold for $150 earns $50 profit, a 33.33% margin, and a 50% markup. Investopedia provides additional context on profit margin. Always confirm which percentage a supplier, salesperson, or internal policy is using before applying it.

How the model works

Every scenario is reduced to cost, selling price, and profit. If margin is known, price equals cost divided by one minus the margin expressed as a decimal. If markup is known, profit equals cost multiplied by markup, and price equals cost plus profit. If price is known, profit is simply price minus cost. If profit is known, price is cost plus profit. The calculator then derives margin and markup from those same amounts, keeping the table, chart, summary, and Excel workbook aligned.

How to interpret the chart and table

The stacked bars show how much of each selling price recovers cost and how much remains as gross profit. The legend identifies the exact cost and profit colors, and the accessible chart summary exposes the same dollar values. The detailed table is the audit view: each row contains the scenario basis and all calculated outputs. The highlighted row identifies the higher-profit scenario when the two profits differ.

Practical tradeoffs and common mistakes

• Do not treat gross profit as net income. Overhead, taxes, returns, discounts, and financing costs may still reduce the amount retained.
• Do not apply a 40% markup when the goal is a 40% margin. On a $100 cost, 40% markup gives a $140 price and only a 28.57% margin.
• Use consistent units. Compare per-item cost with per-item price, or monthly cost with monthly revenue—not mixed periods.
• Stress-test cost increases. If cost rises and price stays fixed, both profit and margin fall.
• Consider market demand. A mathematically sufficient price is not automatically commercially viable.

The exported Excel workbook captures current inputs and outputs at click time, so it can be used as a pricing record or starting point for a broader forecast. This tool is educational and does not provide individualized accounting, tax, legal, or investment advice.