ValueQuarry Pricing, profit, and payout tools

Calculator template

Amazon FBA Profit Template

Build an Amazon FBA-style profit calculator with sale price, product cost, referral fee, FBA fee, shipping, storage, and ads.

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 48.

  • Product cost

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

  • Referral fee

    Uses referral_fee in formulas, starts as a percent field, and begins at 15.

  • FBA fee

    Uses fba_fee in formulas, starts as a currency field, and begins at 7.25.

  • Inbound shipping

    Uses inbound_shipping in formulas, starts as a currency field, and begins at 1.2.

  • Storage cost

    Uses storage_cost in formulas, starts as a currency field, and begins at 0.55.

  • Ad spend

    Uses ad_spend in formulas, starts as a currency field, and begins at 3.

Outputs

What the template calculates

  • Estimated payout

    Format currency

    Result style metric

    Formula sale_price - (sale_price * referral_fee) - fba_fee

    Estimated payout after referral and FBA fees.

  • Estimated profit

    Format currency

    Result style primary

    Formula sale_price - (sale_price * referral_fee) - fba_fee - product_cost - inbound_shipping - storage_cost - ad_spend

    Profit after referral, fulfillment, product, shipping, storage, and ads.

  • Profit margin

    Format percent

    Result style breakdown

    Formula (sale_price - (sale_price * referral_fee) - fba_fee - product_cost - inbound_shipping - storage_cost - ad_spend) / sale_price

    Profit as a share of sale price.

Use cases

When this template helps

  • Estimate profit on an FBA sale before listing or advertising.
  • Include referral, fulfillment, storage, and ad costs.
  • Adjust assumptions without rebuilding a spreadsheet.

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 amazon fba 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.