Inventory value at start of period
Inventory value at end of period
Enter values to see detailed analysis and insights.
How to Use
- 1Enter beginning inventory value (start of period)
- 2Input total purchases during the period
- 3Add ending inventory value (end of period)
- 4Enter total revenue for the period
- 5Review COGS, gross profit, and margin
COGS & Gross Profit Formulas
COGS = Beginning Inventory + Purchases - Ending Inventory
Gross Profit = Revenue - COGS
Gross Margin = (Gross Profit ÷ Revenue) × 100%Variables:
COGSCost of Goods Sold - direct product costsGross ProfitRevenue minus COGSGross MarginGross profit as % of revenueInventoryStock at beginning/end of periodExample
Inputs:
Steps:
- 1.COGS = $10,000 + $50,000 - $8,000 = $52,000
- 2.Gross Profit = $100,000 - $52,000 = $48,000
- 3.Gross Margin = ($48,000 ÷ $100,000) × 100 = 48%
- 4.Inventory Turnover = $52,000 ÷ $9,000 avg = 5.8×
