Basic Information
 
Total units ordered from supplier
 
Units sold to date
 
Retail Price:The selling price on Amazon
$
 
Cost of Goods Sold
$
 
Estimated FBA Fees (per unit)
$
 
Promotional Products Given Away
 
Total Landed Cost per Product
$
 
Upfront Costs (per product)
 
 
Samples
$
 
Graphic Design Work
$
 
Photography
$
 
Additional Miscellaneous Costs: Cost #1
$
 
Additional Miscellaneous Costs: Cost #2
$
 
Total Upfront Costs
$
 
Fixed Costs
 
 
Cost of Goods Sold
$
 
Shipping Costs – Importing from Overseas
$
 
Shipping to Amazon Warehouses
$
 
Additional Costs: Cost #1
$
 
Additional Costs: Cost #2
$
 
Total Fixed Costs
$
 
Advertising
 
 
Total Advertising Spend
$
 
Total Units Sold
$
 
Ad Spend Per Unit
$
 
Promotion and Giveaways
 
 
Cost of Goods Sold (per unit)
$
 
Amazon FBA Fees (per unit)
$
 
Giveaway Fees (per unit)
$
 
Product Giveaway Price
$
 
Total Cost per Promotional Giveaway
$
 
Variable Costs
 
 
Advertising
$
 
Promotion
$
 
FBA Fees (per unit)
$
 
 
Net Margin at Different Various Price Points
Retail Price
$
$
$
FBA Fees
$
$
$
COGS
$
$
$
Shipping (Includes overseas + to AMZ warehouse)
$
$
$
Total Landed Cost
$
$
$
Landed Cost, Per Unit
$
$
$
PPC Cost
$
$
$
FBA Fees
$
$
$
Cost Per Unit
$
$
$
Net Margin Per Unit
$
$
$
 
Gross Margin Calculation
REVENUE
Product Sold
$
Total Revenue
$
EXPENSES
Samples
$
Graphic Design
$
Product Photography
$
Miscellaneous
$
All Shipping Costs
$
COGS
$
Product Giveaway
$
PPC Cost
$
Amazon FBA Fees
$
Total Expenses
$
GROSS MARGIN
$
John Bate

John has 22 years of experience in financial services. This spans across financial research, financial services (As a qualified mortgage broker and underwriter), financial trading and sales at global investment banks. While working as a publishing research analyst, he covered European bank credit and advised institutional clients on investment strategies at both JP Morgan and Societe Generale. John has passed all three levels of the CFA (Chartered Financial Analyst) programme.