An FBA Profit Calculator in Google Sheets or Excel helps you determine the profitability of your products by factoring in costs, fees, and selling price.
Your calculator should include the following fields:
| Metric | Description | Formula |
|---------------------------|----------------------------------------------------------------|------------------------------------------|
| Selling Price | The price you sell the product for on Amazon. | Input |
| Cost of Product | The cost of manufacturing or purchasing the product. | Input |
| Shipping Cost | The cost of shipping the product to Amazon’s FBA warehouse. | Input |
| Amazon Referral Fee | A percentage of the selling price (usually 15%). | Selling Price × Referral Fee (%) |
| FBA Fulfillment Fee | Fee charged by Amazon for storage, packing, and shipping. | Input (lookup based on size/weight) |
| Total Costs | All costs combined. | Cost of Product + Shipping + Fees |
| Net Profit | How much you earn after costs. | Selling Price - Total Costs |
| Profit Margin (%) | The percentage of revenue that is profit. | (Net Profit ÷ Selling Price) × 100 |
| ROI (%) | Return on investment, a measure of profitability. | (Net Profit ÷ Cost of Product) × 100 |
| Metric | Example Value | Formula |
|----------------------|-------------------|-------------|
| Selling Price | $25 | Input |
| Cost of Product | $8 | Input |
| Shipping Cost | $2 | Input |
| Referral Fee (%) | 15% | Fixed |
| FBA Fulfillment Fee | $3.50 | Input |
Referral Fee:
Formula:
[
{Referral Fee} = {Selling Price} * 0.15
]
Example: If the selling price is $25:
[
25 * 0.15 = \$3.75
]
Total Costs:
Formula:
[
{Total Costs} = {Cost of Product} + {Shipping Cost} + {Referral Fee} + {FBA Fulfillment Fee}
]
Example:
[
8 + 2 + 3.75 + 3.50 = \$17.25
]
Net Profit:
Formula:
[
{Net Profit} = {Selling Price} - {Total Costs}
]
Example:
[
25 - 17.25 = \$7.75
]
Profit Margin (%):
Formula:
[
{Profit Margin} = \left(\frac{{Net Profit}} / {{Selling Price}}\right) * 100
]
Example:
[
\left(\frac{7.75}{25}\right) * 100 = 31\%
]
ROI (%):
Formula:
[
{ROI} = \left(\frac{{Net Profit}} / {{Cost of Product}}\right) * 100
]
Example:
[
\left(\frac{7.75}{8}\right) * 100 = 96.88\%
]
Here’s how your spreadsheet might look after adding formulas:
| Metric | Example Value | Formula (for reference) |
|-------------------------|-------------------|-----------------------------------------------------|
| Selling Price | $25 | Input |
| Cost of Product | $8 | Input |
| Shipping Cost | $2 | Input |
| Referral Fee | $3.75 | =B2*0.15
|
| FBA Fulfillment Fee | $3.50 | Input |
| Total Costs | $17.25 | =B3+B4+B5+B6
|
| Net Profit | $7.75 | =B2-B7
|
| Profit Margin (%) | 31% | =(B8/B2)*100
|
| ROI (%) | 96.88% | =(B8/B3)*100
|
| Product Name | Selling Price | Cost of Product | Net Profit | Profit Margin (%) | ROI (%) |
|------------------------|-------------------|---------------------|----------------|------------------------|-------------|
| Bamboo Cutting Board | $25 | $8 | $7.75 | 31% | 96.88% |
| Yoga Mat | $20 | $10 | $3.50 | 17.5% | 35% |
Add a formula to determine the minimum price to break even:
[
{Break-Even Price} = {Total Costs}
]
Example:
If Total Costs = $17.25, the Break-Even Price is $17.25.