ValueQuarry Pricing, profit, and payout tools

Calculator template

Mercari Profit Template

Use a Mercari-style marketplace profit template to estimate payout, profit, and margin after fees and shipping.

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

Open this template in the calculator builder Browse all calculator templates

Inputs

What people fill out

  • Sale price

    Uses sale_price in formulas, starts as a currency field, and begins at 45.

  • Product cost

    Uses product_cost in formulas, starts as a currency field, and begins at 16.

  • Shipping cost

    Uses shipping_cost in formulas, starts as a currency field, and begins at 6.

  • Marketplace fee

    Uses marketplace_fee in formulas, starts as a percent field, and begins at 10.

  • Payment fee

    Uses payment_fee in formulas, starts as a percent field, and begins at 2.9.

  • Fixed fee

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

Outputs

What the template calculates

  • Estimated payout

    Format currency

    Result style metric

    Formula sale_price - (sale_price * marketplace_fee) - (sale_price * payment_fee) - fixed_fee

    Payout after marketplace and payment fees.

  • Order profit

    Format currency

    Result style primary

    Formula sale_price - product_cost - shipping_cost - (sale_price * marketplace_fee) - (sale_price * payment_fee) - fixed_fee

    Profit after fees, cost, and shipping.

  • Profit margin

    Format percent

    Result style breakdown

    Formula (sale_price - product_cost - shipping_cost - (sale_price * marketplace_fee) - (sale_price * payment_fee) - fixed_fee) / sale_price

    Profit as a share of sale price.

Use cases

When this template helps

  • Estimate profit for another resale or marketplace workflow.
  • Include shipping cost and marketplace fee drag.
  • Adjust resale assumptions quickly inside the builder.

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 mercari profit 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.