Calculator template

Pricing Calculator Template

Build a pricing calculator that works backward from unit cost, target margin, and fee assumptions.

Review the inputs and formulas below, then open this template in the calculator builder to customize the field names, values, result styles, and notes.

Inputs

What people fill out

  • Unit cost

    Uses unit_cost in formulas, starts as a currency field, and begins at 40.

  • Target margin

    Uses target_margin in formulas, starts as a percent field, and begins at 40.

  • Fee rate

    Uses fee_rate in formulas, starts as a percent field, and begins at 6.5.

  • Fixed fee

    Uses fixed_fee in formulas, starts as a currency field, and begins at 0.3.

Outputs

What the template calculates

  • Suggested selling price

    Format currency

    Result style primary

    Formula (unit_cost + fixed_fee) / (1 - target_margin - fee_rate)

    Suggested list price based on target margin after fees.

  • Expected profit per sale

    Format currency

    Result style metric

    Formula ((unit_cost + fixed_fee) / (1 - target_margin - fee_rate)) - unit_cost - fixed_fee - (((unit_cost + fixed_fee) / (1 - target_margin - fee_rate)) * fee_rate)

    Estimated profit per sale after the chosen fee assumptions.

Use cases

When this template helps

  • Find a selling price that protects a target margin.
  • Include percentage and fixed fees before choosing a list price.
  • Create a reusable pricing worksheet for products or services.

Related

More ways to work with this math

FAQ

Quick answers

Short answers for the questions that usually come up first.

Can I edit this pricing calculator template?

Yes. Open the template in the builder, then change the labels, values, formulas, notes, or output display styles to fit your workflow.

Can I save a version after I change it?

Yes. Save it on this device, export JSON, or copy a share link after you make changes.

Can I use this as a starting point for a different calculator?

Yes. Templates are meant to be edited. Remove fields, add new ones, or swap formulas if you want a different custom calculator.