ValueQuarry Pricing, profit, and payout tools

Calculator template

Return Rate Impact Template

Estimate how return rate, return cost, and fees change expected profit across a set of orders.

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

  • Order count

    Uses order_count in formulas, starts as a number field, and begins at 100.

  • Sale price

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

  • Unit cost

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

  • Return rate

    Uses return_rate in formulas, starts as a percent field, and begins at 8.

  • Return cost

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

  • Fee rate

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

Outputs

What the template calculates

  • Expected returns

    Format number

    Result style metric

    Formula order_count * return_rate

    Expected number of returned orders.

  • Profit after returns

    Format currency

    Result style primary

    Formula ((sale_price - unit_cost - (sale_price * fee_rate)) * order_count) - ((order_count * return_rate) * return_cost)

    Profit after expected return costs are applied.

  • Return cost total

    Format currency

    Result style breakdown

    Formula (order_count * return_rate) * return_cost

    Total expected return-related cost.

Use cases

When this template helps

  • Estimate the profit impact of returns across multiple orders.
  • Use expected return cost in product planning.
  • Adjust order count and fee drag 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 return rate impact 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.