Merchant Sheets logo showing text and grid document
graphic representation of the Merchant Sheets Amazon FBA profit calculator
screenshot of the Merchant Sheets Amazon FBA calculator.
screenshot of the Merchant Sheets Amazon FBA calculator.
graphic representation of the Merchant Sheets Amazon FBA profit calculator
screenshot of the Merchant Sheets Amazon FBA calculator.
screenshot of the Merchant Sheets Amazon FBA calculator.

Amazon FBA Profitability Calculator

$99

The Amazon FBA Profitability Calculator computes the full per-unit P&L for any FBA SKU: landed cost, FBA fulfillment fee, referral fee, storage fee, ad spend, and payment fee, down to net contribution. The Scorecard compares your catalog by margin tier with a recommended action, and the single-SKU Calculator runs the same math pre-launch for a GO/NO-GO call.

✓

Works in Excel & Google Sheets

Template includes both versions. One price, no add-ons.

Save 67%

Skip to the Full Library

All 20 templates in one purchase, with lifetime updates and every new release included.

See bundles

How it works

Every fee Amazon charges gets its own line, so nothing gets buried in a single “fees” number.

  1. Inputs: Business constants: payment fee %, ad spend % (a TACoS proxy), and your minimum margin target
  2. Fees: The lookup source: 22 FBA size-tier fees, 26 referral fee categories, and storage rates
  3. SKUs: Your product master: category, size tier, dimensions, weight, costs, and monthly units
  4. Calculator: A single-SKU scenario tool for pre-launch “should I list this?” decisions
  5. Scorecard: The catalog table: landed cost, FBA fulfillment, referral, storage, and ad spend rolled up to net per unit, monthly contribution, and tier
  6. SKU Dashboard: Pick a SKU for the full P&L waterfall and monthly contribution
  7. Dashboard: The catalog view: total contribution, tier distribution, top and bottom SKUs, and performance by category

Steps to use it

  1. Set payment fee %, ad spend %, and minimum margin target on Inputs
  2. Review Fees and update values as Amazon revises its schedule
  3. Build your catalog on SKUs: category, size tier, dimensions, weight, costs, monthly units
  4. Use Calculator for a pre-launch GO/NO-GO read on any hypothetical product
  5. Review Scorecard for per-SKU net contribution and tier
  6. Open SKU Dashboard for the full waterfall on any SKU, then Dashboard for the catalog view

Margin tiers are built in: A at 30% net margin or above, B from 20% to 30%, C from 10% to 20%, D below 10% or negative. Recommended action follows tier: keep and lean in at A, keep and optimize cost at B, reconsider sourcing or price at C, and kill or delist at D.