First product, wrong decision
I bought 500 units of a kitchen gadget because the Amazon FBA calculator showed a 40% margin. I ignored that the calculator doesn't include PPC, returns, or storage fees. I sold 62 units over four months. The remaining 438 sat in an Amazon warehouse eating into my capital until I paid removal fees to get them back. I lost approximately $2,100 on that order alone. A Why Amazon Fba Worksheet is a spreadsheet model that forces you to commit your real assumptions before you spend money on inventory. It tracks every cost layer from supplier to fulfilled sale, calculates your actual per-unit profit after all fees, and shows you whether a product is viable or just looks good on a surface-level calculator. Most sellers treat the Amazon FBA Profit Calculator as sufficient. It isn't. That tool gives you gross numbers, not net numbers. Net numbers are what determine whether you're building a business or funding someone else's
How to build a working model from scratch
I don't buy expensive tools anymore. I use a Google Sheet with seven core sections. Here is what goes into each one. Product cost per unit: Get this from your supplier's actual quote, not their MSRP. MOQ discounts change this number significantly. If you negotiate 30% off after ordering 1,000 units, your per-unit cost drops from $4.50 to $3.15. Document the volume tier you're buying at. Shipping per unit: This is freight cost from your supplier to Amazon's warehouse. Don't guess. Get a quote from your freight forwarder with the actual dimensions and weight of your shipment. Amazon charges inbound shipping fees based on the same data. A $3,200 ocean freight charge split across 2,000 units is $1.60 per unit. That's a real number you can model against.
Amazon referral fee: This is a percentage of the total sale price, and it varies by category. Electronics sit around 8%. Home and Kitchen is 15%. Jewelry is 20%. Use the current Amazon fee schedule, not a generic 15% assumption. I once used a flat 15% for an electronics product and overestimated my costs by roughly $1.20 per unit because the actual referral fee was 8%. That $1.20 gap made or broke my margins on a low-ticket item. FBA fulfillment fee: This depends on size tier. Standard size items in the US currently run around $3.22 to $5.75 depending on weight. Check Amazon's current fee table for your region. This covers picking, packing, and shipping to the customer. Other fees: Include anything non-recurring like product labeling, palletizing, customs duties, or quality inspection costs. I budget $0.35 per unit for barcode labeling when my supplier won't do it. Small line items accumulate.
Get the Full Details
Operating Assumptions
Monthly sales estimate: This is the hardest number to get right. I use three scenarios: conservative, expected, and optimistic. Conservative might be 30 units per month. Expected is 80. Optimistic is 150. The difference between these scenarios tells you your risk profile. Return rate: Set this by category. Kitchen gadgets often return at 8-12%. Clothing and accessories can hit 15-20%. Appliances with defects might return at 5%. I track my actual return rate by product in a separate tab once sales begin, then apply that real data to future models. PPC spend: For new launches, assume 20-35% of revenue goes to advertising in the first 90 days. This isn't optional. Without PPC, a new product has virtually no visibility. Mature products might settle at 10-15%. Build the launch PPC spike into your model because it destroys margins in month one.
Storage fees: Amazon charges monthly storage fees per cubic foot. If your item is 2 cubic feet and you have 500 units sitting for 6 months during a slow season, that's significant. I calculate storage as a percentage of product cost rather than tracking individual cubic feet. Roughly 3-8% of inventory value per quarter, depending on velocity.
Calculations
Each row calculates: sale price minus product cost minus shipping minus referral fee minus FBA fee minus PPC minus returns adjustment equals net profit per unit. Then multiply by units sold for monthly profit. Revenue minus all costs equals net profit. Net profit divided by total investment equals ROI. The break-even units calculation tells you how many units you need to sell to cover your initial investment. Total investment divided by net profit per unit gives you the number. If your investment is $4,000 and your net profit per unit is $6.50, you need to sell 616 units just to break even. That number changes your decision.
Where models fail in practice
The single biggest mistake I see is selling cost accuracy. People pull product costs from Alibaba listings that don't include packaging, freight, customs, or supplier markup. I learned to ask for a landed cost breakdown from my freight forwarder before building the model. One forwarder quote revealed my $2.80 product actually cost $4.15 landed at Amazon's door after duty, freight, and port fees. Dimensional weight is another hidden cost. Amazon charges by the greater of actual weight or dimensional weight. A lightweight but bulky product can have a fulfillment fee that's $1.50 higher than you expect. I measured every product I sourced and recalculated the size tier before committing. Three products dropped from standard to large standard size, which added roughly $2.00 per unit in FBA fees. Long-term storage is a silent killer. If inventory sits beyond 180 days, storage fees increase dramatically. I had a batch of 800 units that moved too slowly and accumulated $640 in long-term storage fees over six months. I pulled them and liquidated them through an outlet instead of letting the fees compound.
Category changes matter. Amazon reclassified one of my products from Home & Kitchen to Tools & Home Improvement. The referral fee dropped from 15% to 12%. That 3% difference added $0.90 per unit to my margin. If your category assignment is wrong, your entire model is wrong. Verify your ASIN category before you source.
Why you still need this even with automated tools
Profit calculators online give you instant answers. They also give you wrong answers because they lack your actual numbers. A spreadsheet forces you to think through each cost component individually. The friction is the point. If you can't fill in every field, you don't know enough about your product to proceed. I also maintain a living model where I update actuals against projections every month after launch. The variance between my model and reality teaches me something. In my first three products, my return rate assumptions were 40% too optimistic. My PPC assumptions were 25% too low. Each product's actual data corrected the next model. By product four, my projections were within 8% of actual results.
Why Amazon Fba Worksheet remains essential
It makes implicit assumptions explicit. That is its only real value and that value is enormous. When you can see every cost line and every variable, you either discover the product is unviable or you enter with confidence. The alternative is what I did with my first order: buying blind and hoping. Free templates exist on Reddit's r/FulfillmentByAmazon and on Helium10's resource pages. Jungle Scout also offers a basic profitability calculator. But none of these replace a model you build yourself with your own supplier quotes and real market data. The template is a starting point, not a finished product. A simple spreadsheet with 7 fields and 3 scenarios takes about 20 minutes to set up and 15 minutes to update with new data. The time investment is negligible compared to the cost of ordering the wrong product. If your break-even requires selling 1,200 units at a $3 profit each, the model has already told you to walk away before you spend a single dollar on inventory.
